nitsWhale Swaps
Updated 2022-05-03
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
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