alirsOptimistic Bears-part-03
Updated 2022-08-10
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
with dex as
(SELECT * from optimism.core.dim_labels
where label_type = 'dex')
SELECT date(block_timestamp) as Date, project_name, count(DISTINCT tx_hash) as total_txs,
sum(total_txs) over (partition by project_name order by Date) as cumulative_txs
from optimism.core.fact_event_logs
inner join dex on contract_address = address
where Date>='2022-07-01' and Date <='2022-07-30'
GROUP by Date, project_name
Run a query to Download Data