ramishoowUntitled Query
    Updated 2023-01-13
    SELECT BLOCK_TIMESTAMP::DATE AS DAYS, SUM(POOL_ID) "STAKED AMOUNT",
    CASE
    WHEN DAYS BETWEEN '2022-12-25' AND '2022-12-31' THEN 'First week of holidays'
    WHEN DAYS BETWEEN '2023-01-01' AND '2023-01-13' THEN 'Second week of holidays'
    END AS TYPE
    FROM near.core.ez_dex_swaps
    WHERE DAYS BETWEEN '2022-12-25' AND '2023-01-13' AND ACTION = 'Delegate'
    GROUP BY DAYS, ACTION
    ORDER BY DAYS

    Run a query to Download Data