nitsTotal Volume vs Sushiswap Transaction Volume
Updated 2022-02-12
9
1
2
3
4
5
6
7
8
9
›
⌄
with total_vol as (SELECT date(block_timestamp) as day , sum(amount_usd) as total_Vol, sum(total_vol) over (order by day) as cumulative_vol from ethereum.dex_swaps
where block_timestamp > CURRENT_DATE -60 and amount_usd < pow(10,10)
GROUP by 1 )
SELECT *, total_Vol_sushi/total_Vol* 100 as percent_sushi,cumulative_vol_sushi/ cumulative_vol * 100 as percent_cumulative_vol from
(SELECT date(block_timestamp) as day_, sum(amount_usd) as total_Vol_sushi, sum(total_Vol_sushi) over (order by day_) as cumulative_vol_sushi from ethereum.dex_swaps
where block_timestamp > CURRENT_DATE -60 and platform = 'sushiswap'
GROUP by 1 )
inner join total_vol
on day =day_
Run a query to Download Data