snowmanUntitled Query
    Updated 2022-10-02
    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