maybeyonassushi_may_volat_sushi
    Updated 2022-05-23
    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