jackguylol_lol_11
Updated 2022-09-29
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
SELECT
-- date_trunc('day', block_timestamp) as day,
PLATFORM,
count(DISTINCT tx_hash) as swaps,
count(DISTINCT origin_from_address) as users,
sum(amount_in_usd) as swap_volume,
avg(amount_in_usd) as avg_swap_volume
FROM ethereum.core.ez_dex_swaps
where block_timestamp > '2022-01-01'
AND amount_in_usd < 100000000000
GROUP BY 1
Run a query to Download Data