headitmanagerDaily chat How many swaps
Updated 2022-05-01
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
select 'number of swaps are above 150.000$' as title,count(tx_hash) as val ,date(block_timestamp) as dt from ethereum_core.ez_dex_swaps where platform='sushiswap' and amount_in_usd > 150000
group by dt
UNION ALL
select 'number of swaps are above 300.000$' as title,count(tx_hash) as val,date(block_timestamp) as dt from ethereum_core.ez_dex_swaps where platform='sushiswap' and amount_in_usd > 300000
group by dt
UNION ALL
select 'number of swaps are above 600.000$' as title,count(tx_hash) as val,date(block_timestamp) as dt from ethereum_core.ez_dex_swaps where platform='sushiswap' and amount_in_usd > 600000
group by dt
UNION ALL
select 'number of swaps are above 900.000$' as title,count(tx_hash) as val,date(block_timestamp) as dt from ethereum_core.ez_dex_swaps where platform='sushiswap' and amount_in_usd > 900000
group by dt
Run a query to Download Data