Updated 2022-08-17
9
1
2
3
4
5
6
7
8
9
›
⌄
SELECT --block_timestamp::date as date,
POOL_NAME,
sum(AMOUNT_IN_USD) as AMOUNT_IN_USD,
sum(AMOUNT_OUT_USD) as AMOUNT_OUT_USD,
sum(zeroifnull(AMOUNT_IN_USD))-sum(zeroifnull(AMOUNT_OUT_USD)) as Volume
from optimism.velodrome.ez_swaps
GROUP BY 1--,2
order by 4 desc
Run a query to Download Data