snowmanUntitled Query
Updated 2022-10-02Copy Reference Fork
9
1
2
3
4
›
⌄
SELECT BLOCK_TIMESTAMP::DATE AS Time, COUNT(DISTINCT(ORIGIN_FROM_ADDRESS)) "Daily_Active_Addresses", CASE
--SELECT BLOCK_TIMESTAMP::DATE AS Time, COUNT(DISTINCT(ORIGIN_FROM_ADDRESS)) "Daily_Active_Addresses", CASE
WHEN Time BETWEEN '2022-09-01' AND '2022-09-14' THEN 'Before Merge' WHEN Time BETWEEN '2022-09-15' AND '2022-10-01' THEN 'After Merge' END AS TIME_
FROM ethereum.core.ez_dex_swaps WHERE BLOCK_TIMESTAMP::DATE BETWEEN '2022-09-01' AND '2022-10-01' GROUP BY Time, TIME_
Run a query to Download Data