maybeyonassushi_may_volat_sushi
Updated 2022-05-23
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
select
date(block_timestamp) as date,
case when token_in = '0x6b3595068778dd592e39a122f4f5a5cf09c90fe2' then 'sell' else 'buy' end as type,
count(distinct tx_hash) as txs,
count(distinct sender) as user,
sum(
case when token_in = '0x6b3595068778dd592e39a122f4f5a5cf09c90fe2' then amount_in else amount_out end
) as sushi_vol,
sum(amount_in_usd+amount_out_usd)/2 as usd_vol
from ethereum_core.ez_dex_swaps
where (token_in = '0x6b3595068778dd592e39a122f4f5a5cf09c90fe2' or token_out = '0x6b3595068778dd592e39a122f4f5a5cf09c90fe2')
and date > '2022-04-01'
group by 1,2
-- limit 100
Run a query to Download Data