nsa2000pixel party2
Updated 2022-10-06
9
1
2
3
4
5
6
7
8
›
⌄
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