ramishoowUntitled Query
Updated 2023-01-13
99
1
2
3
4
5
6
7
8
9
10
›
⌄
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