sarathsushi_uni 3
Updated 2022-10-17
9
1
2
3
4
5
6
›
⌄
SELECT date_trunc('day', BLOCK_TIMESTAMP) AS dt, platform, sum(AMOUNT_IN_USD), sum(AMOUNT_OUT_USD), sum(AMOUNT_IN_USD - AMOUNT_OUT_USD) AS NET_FLOW
FROM ethereum.core.ez_dex_swaps
WHERE BLOCK_TIMESTAMP >='2022-01-01'
and (platform = 'sushiswap' OR platform = 'uniswap-v2')
GROUP BY 1,2
ORDER BY 1 DESC, 2 DESC
Run a query to Download Data