par_rnMonthly swap Volume (USD)
Updated 2022-12-24
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
select
date_trunc('month',BLOCK_TIMESTAMP) AS month,
'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",
sum(Volume) over (order by month) AS "Cumulative Volume",
sum("Swaps number") over (order by month) AS "Cumulative Swaps number"
from ethereum.core.ez_dex_swaps
where (TOKEN_IN='0x45804880de22913dafe09f4980848ece6ecbaf78' or TOKEN_OUT='0x45804880de22913dafe09f4980848ece6ecbaf78' )
group by 1,2
union ALL
select
date_trunc('month',BLOCK_TIMESTAMP) AS month,
'XAUT' 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",
sum(Volume) over (order by month) AS "Cumulative Volume",
sum("Swaps number") over (order by month) AS "Cumulative Swaps number"
from ethereum.core.ez_dex_swaps
where (TOKEN_IN=lower('0x68749665FF8D2d112Fa859AA293F07A622782F38') or TOKEN_OUT=lower('0x68749665FF8D2d112Fa859AA293F07A622782F38'))
group by 1,2
Run a query to Download Data