TOKEN | DIS_VOLUME | SWAPPERS | SWAPS | |
|---|---|---|---|---|
1 | ARB | 10~100 $ | 47945 | 120063 |
2 | OP | 10~100 $ | 49120 | 87093 |
3 | ARB | 1K~10K $ | 17055 | 1019446 |
4 | OP | 1K~10K $ | 6265 | 124289 |
5 | ARB | 100~1K $ | 38606 | 523846 |
6 | OP | 100~1K $ | 22497 | 141539 |
7 | ARB | Below 10 $ | 49043 | 82256 |
8 | ARB | Up to 10K $ | 2119 | 42149 |
9 | OP | Below 10 $ | 53334 | 75338 |
10 | OP | Up to 10K $ | 490 | 10011 |
0-MID22
Updated 2024-01-29
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
select 'ARB'as token
,case
when AMOUNT_IN_USD>0 and AMOUNT_IN_USD<10 then 'Below 10 $'
when AMOUNT_IN_USD>=10 and AMOUNT_IN_USD<=100 then '10~100 $'
when AMOUNT_IN_USD>100 and AMOUNT_IN_USD<=1000 then '100~1K $'
when AMOUNT_IN_USD>1000 and AMOUNT_IN_USD<=10000 then '1K~10K $'
when AMOUNT_IN_USD>10000 then 'Up to 10K $' end as dis_volume
,count(distinct ORIGIN_FROM_ADDRESS) as swappers
,count(distinct TX_HASH) as swaps
from arbitrum.defi.ez_dex_swaps
where BLOCK_TIMESTAMP::date>='2023-10-01'
and PLATFORM='uniswap-v3'
and SYMBOL_IN='ARB'
and dis_volume is not null
group by 1,2
union all
select 'OP'as token
,case
when AMOUNT_IN_USD>0 and AMOUNT_IN_USD<10 then 'Below 10 $'
when AMOUNT_IN_USD>=10 and AMOUNT_IN_USD<=100 then '10~100 $'
when AMOUNT_IN_USD>100 and AMOUNT_IN_USD<=1000 then '100~1K $'
when AMOUNT_IN_USD>1000 and AMOUNT_IN_USD<=10000 then '1K~10K $'
when AMOUNT_IN_USD>10000 then 'Up to 10K $' end as dis_volume
,count(distinct ORIGIN_FROM_ADDRESS) as swappers
,count(distinct TX_HASH) as swaps
from optimism.defi.ez_dex_swaps
where BLOCK_TIMESTAMP::date>='2023-10-01'
and PLATFORM='uniswap-v3'
and SYMBOL_IN='OP'
and dis_volume is not null
group by 1,2
Last run: about 1 year agoAuto-refreshes every 24 hours
10
318B
4s