deevhyn2024-03-05 11:12 AM
Updated 2024-03-31
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
SELECT
--date_trunc('day',block_timestamp) AS Date,
-- origin_from_address,
platform,
--symbol_in,
-- amount_in_usd,
--event_name,
COUNT(DISTINCT tx_hash) AS No_Of_Transactions
FROM ethereum.defi.ez_dex_swaps
WHERE
platform IN('uniswap-v3','curve', 'sushiswap')
AND amount_in_usd IS NOT NULL
--AND event_name= 'Swap'
GROUP BY 1
ORDER BY 1 DESC
QueryRunArchived: QueryRun has been archived