Popex404Total DYDX Swaps
Updated 2023-01-26
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
select
'Swap Selling DYDX'as "Type",
count(tx_hash) as "Swaps",
count (distinct origin_from_address) as "Swapper",
sum(amount_in) as "DYDX Amount"
from ethereum.core.ez_dex_swaps
where token_in = lower('0x92D6C1e31e14520e676a687F0a93788B716BEff5')
and block_timestamp >= '2022-11-01'
group by 1
UNION ALL
select
'Swap Buying DYDX'as "Type",
count(tx_hash) as "Swaps",
count (distinct origin_from_address) as "Swapper",
sum(amount_out) as "DYDX Amount"
from ethereum.core.ez_dex_swaps
where token_out = lower('0x92D6C1e31e14520e676a687F0a93788B716BEff5')
and block_timestamp >= '2022-11-01'
group by 1
Run a query to Download Data