nitsWhale Swaps
    Updated 2022-05-03
    SELECT date(block_timestamp) as day, count(DISTINCT tx_hash) as total_txs, sum(amt_net) as total_amt,
    total_amt/total_txs as amt_per_tx,
    sum(total_amt) over (order by day) as cumulative_amt ,
    sum(total_txs) over (order by day) as cumulative_txs ,
    cumulative_amt /cumulative_txs as amt_per_tx_over_time
    from
    (SELECT *, case when amount_in_usd >= '150000' then amount_in_usd else amount_out_usd end as amt_net
    from ethereum_sushi.ez_swaps
    where amount_in_usd >= '150000' or amount_out_usd >= '150000' )
    where day >= '2022-01-01'
    GROUP by 1
    -- limit 100
    Run a query to Download Data