Flippppppa2023-12-15 11:50 AM copy
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
-- forked from 2023-12-15 11:50 AM @ https://flipsidecrypto.xyz/edit/queries/8bc367f9-9482-46b8-8f39-ca90efcbb654
SELECT
date_trunc("day", block_timestamp) as Date ,
platform,
event_name,
symbol_in,
SUM(amount_in_usd) total_usd,
tx_hash
FROM ethereum.defi.ez_dex_swaps
WHERE event_name = 'Swap' AND amount_in_usd is NOT NULL
GROUP by Date, platform, event_name, symbol_in, tx_hash
HAVING total_usd >= 1
AND platform IN ('uniswap_v3','Curve','sushiswap', 'balancer')
ORDER BY 5 DESC
LIMIT 100
Run a query to Download Data