par_rnTotal swap Volume (USD)
Updated 2022-12-24
999
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
'last 1-month' AS Time,
'PAXG' AS Symbol,
sum(case when TOKEN_IN='0x45804880de22913dafe09f4980848ece6ecbaf78' then AMOUNT_IN_USD else AMOUNT_OUT_USD end) AS Volume,
count(distinct ORIGIN_FROM_ADDRESS) AS "swappers number",
count(*) AS "Swaps number",
avg(case when TOKEN_IN='0x45804880de22913dafe09f4980848ece6ecbaf78' then AMOUNT_IN_USD else AMOUNT_OUT_USD end) AS "Average Swap size",
Volume/"swappers number" AS "Average Volume/swapper"
from ethereum.core.ez_dex_swaps
where (TOKEN_IN='0x45804880de22913dafe09f4980848ece6ecbaf78' or TOKEN_OUT='0x45804880de22913dafe09f4980848ece6ecbaf78' )
and BLOCK_TIMESTAMP::Date >= dateadd('month',-1,CURRENT_DATE)
union ALL
select
'last 3-month' AS Time,
'PAXG' AS Symbol,
sum(case when TOKEN_IN='0x45804880de22913dafe09f4980848ece6ecbaf78' then AMOUNT_IN_USD else AMOUNT_OUT_USD end) AS Volume,
count(distinct ORIGIN_FROM_ADDRESS) AS "swappers number",
count(*) AS "Swaps number",
avg(case when TOKEN_IN='0x45804880de22913dafe09f4980848ece6ecbaf78' then AMOUNT_IN_USD else AMOUNT_OUT_USD end) AS "Average Swap size",
Volume/"swappers number" AS "Average Volume/swapper"
from ethereum.core.ez_dex_swaps
where (TOKEN_IN='0x45804880de22913dafe09f4980848ece6ecbaf78' or TOKEN_OUT='0x45804880de22913dafe09f4980848ece6ecbaf78' )
and BLOCK_TIMESTAMP::Date >= dateadd('month',-3,CURRENT_DATE)
union ALL
select
'last 6-month' AS Time,
'PAXG' AS Symbol,
sum(case when TOKEN_IN='0x45804880de22913dafe09f4980848ece6ecbaf78' then AMOUNT_IN_USD else AMOUNT_OUT_USD end) AS Volume,
count(distinct ORIGIN_FROM_ADDRESS) AS "swappers number",
count(*) AS "Swaps number",
avg(case when TOKEN_IN='0x45804880de22913dafe09f4980848ece6ecbaf78' then AMOUNT_IN_USD else AMOUNT_OUT_USD end) AS "Average Swap size",
Volume/"swappers number" AS "Average Volume/swapper"
from ethereum.core.ez_dex_swaps
where (TOKEN_IN='0x45804880de22913dafe09f4980848ece6ecbaf78' or TOKEN_OUT='0x45804880de22913dafe09f4980848ece6ecbaf78' )
and BLOCK_TIMESTAMP::Date >= dateadd('month',-6,CURRENT_DATE)
union ALL
Run a query to Download Data