i_dan2024-05-02 11:53 AM
Updated 2024-05-06
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
SELECT
date_trunc(mm, block_timestamp),
platform,
symbol_in,
amount_in_usd
--SUM(amount_in_usd) total_amount
FROM ethereum.defi.ez_dex_swaps
WHERE platform IN ('sushiswap', 'balancer', 'uniswap-v2', 'uniswap-v3')
AND amount_in_usd IS NOT NULL
AND block_timestamp::date BETWEEN '2024-01-01' AND '2024-01-30'
--And amount_in_usd >= 10000000
--GROUP BY 1, 2, 3
--HAVING total_amount >= 1000000000
ORDER BY amount_in_usd ASC
LIMIT 200
QueryRunArchived: QueryRun has been archived