TOKEN | AVG_VOLUME | |
|---|---|---|
1 | ARB | 215203330 |
2 | OP | 30794868 |
0-MID20
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
›
⌄
with tab1 as (
select 'ARB'as token
,date_trunc('week',BLOCK_TIMESTAMP) as week
,sum(AMOUNT_IN_USD) as sell_volume
,count(distinct ORIGIN_FROM_ADDRESS) as buyers
,count(distinct TX_HASH) as buy_swaps
from arbitrum.defi.ez_dex_swaps
where BLOCK_TIMESTAMP::date>='2023-10-01'
and PLATFORM='uniswap-v3'
and SYMBOL_IN='ARB'
group by 1,2),
tab2 as (
select 'OP'as token
,date_trunc('week',BLOCK_TIMESTAMP) as week
,sum(AMOUNT_IN_USD) as sell_volume
,count(distinct ORIGIN_FROM_ADDRESS) as buyers
,count(distinct TX_HASH) as buy_swaps
from optimism.defi.ez_dex_swaps
where BLOCK_TIMESTAMP::date>='2023-10-01'
and PLATFORM='uniswap-v3'
and SYMBOL_IN='OP'
group by 1,2)
select token
,round(avg(sell_volume)) as avg_volume
from tab1
group by 1
union all
select token
,round(avg(sell_volume)) as avg_volume
from tab2
group by 1
Last run: about 1 year agoAuto-refreshes every 24 hours
2
35B
4s