ramishoowUntitled Query
Updated 2023-01-13
9
1
2
3
4
›
⌄
WITH NUMBER_OF_TRANSACTIONS_AND_FEES_SPENT AS ( 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)
SELECT type, (SUM("Number of transactions")) AS "Number of transactions", (SUM("FEE spent (near)")) AS "Fees spent (near)" FROM NUMBER_OF_TRANSACTIONS_AND_FEES_SPENT GROUP BY TYPE
Run a query to Download Data