sakineh5021-nIQRzBWhale Swaps 3
Updated 2022-05-05
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
SELECT count( tx_hash) as number_of_swaps , sum(AMOUNT_OUT_USD) as swap_volume ,
CASE
when AMOUNT_OUT_USD <'1000' then 'less than 1000'
when AMOUNT_OUT_USD >='1000' and AMOUNT_OUT_USD <'10000' then 'between 1000 than 10000'
when AMOUNT_OUT_USD >='10000' and AMOUNT_OUT_USD <'50000' then 'between 10000 than 50000'
when AMOUNT_OUT_USD >='50000' and AMOUNT_OUT_USD <'100000' then 'between 50000 than 100000'
when AMOUNT_OUT_USD >='100000' and AMOUNT_OUT_USD <'150000' then 'between 100000 than 150000'
when AMOUNT_OUT_USD >='150000' then 'more than 150000'
end as swap_size , date_trunc('week' , block_timestamp) as week
from ethereum_sushi.ez_swaps
where amount_out_usd is not NULL
group by 3 , 4
Run a query to Download Data