nsa2000pixel party2
    Updated 2022-10-06
    SELECT
    DATE_TRUNC('{{period}}',block_timestamp) as date,
    CASE WHEN tx_receiver = 'pixelparty.near' THEN 'Pixelparty'
    ELSE 'Other' END as label,
    SUM(Transaction_fee)/POW(10,24) as fees_denom
    FROM near.core.fact_transactions
    WHERE block_timestamp::date >= '2021-04-01'
    GROUP BY date,label
    Run a query to Download Data