jackguyperpetual protocol 3
Updated 2022-09-05
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
WITH contracts as (
SELECT *
FROM optimism.core.dim_labels
WHERE project_name LIKE 'perpetual protocol'
)
SELECT
-- date_trunc('day', block_timestamp) as day,
COUNT(DISTINCT tx_hash) as events,
COUNT(DISTINCT ORIGIN_FROM_ADDRESS) as users
FROM optimism.core.fact_event_logs
WHERE contract_address IN (SELECT address FROM contracts)
--GROUP BY 1
Run a query to Download Data