sepehrmhz82023-06-12 11:33 AM
Updated 2023-06-25
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
case
when symbol_in = 'COMP' then 'SELL'
when symbol_out = 'COMP' then 'BUY'
end as swap_type,
count(distinct tx_hash) as Txs,
sum(
case
when symbol_in = 'COMP' then amount_in_usd
else amount_out_usd
end
) Volume
from
ethereum.core.ez_dex_swaps
where
(
symbol_in = 'COMP'
or symbol_out = 'COMP'
)
group by
1
Run a query to Download Data