zakkisyedBlank
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
select distinct asset_blockchain, is_small, count(is_small)
FROM
(
select asset_blockchain,
case when asset_amount_usd <1000 then 'small' else 'large' end as is_small
from thorchain.liquidity_actions
where lp_action != 'remove_liquidity'
and block_timestamp >= CURRENT_DATE - 30
--and asset_blockchain = 'TERRA'
--and asset_amount_usd <1000
and asset_amount_usd !=0
)
group by 1,2
Run a query to Download Data