Updated 2022-08-17
9
1
2
3
4
5
6
7
›
⌄
SELECT date(block_timestamp) as date,
count(DISTINCT tx_hash) as total_txs,
avg(total_txs) over (order by date) as avg_txs,
count(DISTINCT pool_name) as total_pools_interacted_with
from optimism.velodrome.ez_swaps
GROUP BY 1
order by 1 asc
Run a query to Download Data