jackguyOptimism DEXs (redux) 2
Updated 2022-10-25
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
SELECT
date_trunc('day', block_timestamp) as day,
count(DISTINCT tx_hash) as swaps,
count(DISTINCT origin_from_address) as users
FROM optimism.core.fact_event_logs
LEFT outer JOIN optimism.core.dim_labels
ON contract_address = address
where not address is NULL
--AND event_name like 'Swap'
AND project_name LIKE '%uniswap%'
AND block_timestamp > CURRENT_DATE - 30
GROUP BY 1
Run a query to Download Data