boomer77uni vs sushi vol
Updated 2021-11-16
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
with sushixxx as (select block_timestamp, amount_usd, ROW_NUMBER() OVER (PARTITION BY tx_id ORDER BY amount_usd desc) as num
from ethereum.udm_events
where amount_usd between 0 and 10000000 and to_address = '0xd9e1ce17f2641f24ae83637ab66a2cca9c378b9f' and block_timestamp >= '2021-01-01'),
sushi as (select date_trunc('month', block_timestamp) as dt, sum(amount_usd) as sushi_vol
from sushixxx
where num =1
group by 1),
uni as (select date_trunc('month', block_timestamp) as dt, sum(amount1_usd) as uni_vol
from uniswapv3.swaps
where block_timestamp >= '2021-01-01' and amount1_usd between 0 and 10000000
group by 1)
select a.dt, a.sushi_vol, b.uni_vol, (a.sushi_vol + b.uni_vol) as total_vol, (a.sushi_vol/total_vol)*100 as sushi_perc, (b.uni_vol/total_vol)*100 as uni_perc
from sushi a
join uni b on a.dt=b.dt
Run a query to Download Data