anniecryptoVolume Market Share
Updated 2022-02-13
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
select day1, sushi_volume, total_volume
from
( (select date_trunc('day', block_timestamp) as day1, sum(amount_usd) as sushi_volume
from ethereum.dex_swaps where day1 >= current_date - INTERVAL'60 days' and platform = 'sushiswap'
group by 1) as a
join (select date_trunc('day', block_timestamp) as day2, sum(amount_usd) as total_volume
from ethereum.dex_swaps
where day2 >= current_date - INTERVAL'60 days'
group by 1) as b
on a.day1 = b.day2
)
Run a query to Download Data