ramishoowUntitled Query
    Updated 2023-01-13
    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