ramishoowUntitled Query
Updated 2023-01-13
9
1
2
3
›
⌄
SELECT BLOCK_TIMESTAMP::DATE AS DAYS, COUNT(DISTINCT(TX_HASH)) AS "Number of transactions", SUM(TRANSACTION_FEE) AS "FEE spent (near)", CASE WHEN DAYS BETWEEN '2022-12-25' AND '2022-12-31' THEN 'First week of holidays'
--SELECT BLOCK_TIMESTAMP::DATE AS DAYS, COUNT(DISTINCT(TX_HASH)) AS "Number of transactions", SUM(TRANSACTION_FEE) AS "FEE spent (near)", 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.fact_transactions WHERE DAYS BETWEEN '2022-12-25' AND '2023-01-13' GROUP BY DAYS, TYPE
Run a query to Download Data