DIS_VOLUME | SWAPPERS | SWAPS | |
|---|---|---|---|
1 | $100~$1K | 102 | 168 |
2 | $1K~$10K | 33 | 117 |
3 | $10~$100 | 261 | 615 |
4 | Below $10 | 408 | 826 |
5 | $Up to $10K | 2 | 2 |
0-MIDswap size
Updated 6 days ago
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
select
case
when FROM_AMOUNT_USD>0 and FROM_AMOUNT_USD<10 then 'Below $10'
when FROM_AMOUNT_USD>=10 and FROM_AMOUNT_USD<=100 then '$10~$100'
when FROM_AMOUNT_USD>100 and FROM_AMOUNT_USD<=1000 then '$100~$1K'
when FROM_AMOUNT_USD>1000 and FROM_AMOUNT_USD<=10000 then '$1K~$10K'
when FROM_AMOUNT_USD>10000 then '$Up to $10K' end as dis_volume
,count(distinct FROM_ADDRESS) as swappers
,count(distinct TX_ID) as swaps
from thorchain.defi.fact_swaps
where AFFILIATE_ADDRESS='t'
and BLOCK_TIMESTAMP::date>=current_date-30
and dis_volume is not null
group by 1
Last run: 6 days ago
5
105B
32s