MoeQS 4 copy
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
select
count(DISTINCT tx_hash) as swaps,
count(DISTINCT origin_from_address) as traders,
sum(amount_in_usd) as swap_volume,
avg(amount_in_usd) as avg_swap_volume
from
polygon.core.ez_dex_swaps
where
platform like 'quickswap-v3'
and amount_in_usd is not null -- threre are some incompleteness in the usd amounts also , which I had fixed it in my main query joining it to the price table.
and amount_in_usd != 0
Run a query to Download Data