bertaUntitled Query
Updated 2022-12-24
99
1
2
3
4
5
6
7
8
9
10
›
⌄
--credit : https://app.flipsidecrypto.com/velocity/queries/2e151d1e-9bde-4fc9-b844-b9d9702ab8e9
SELECT
-- date_trunc('week', block_timestamp) as day,
platform,
max(AMOUNT_IN_USD),
sum(AMOUNT_IN_USD),
count(DISTINCT ORIGIN_FROM_ADDRESS)
FROM ethereum.core.ez_dex_swaps
WHERE block_timestamp > '2022-01-01'
GROUP BY 1
Run a query to Download Data