davidwallNew Query
Updated 2023-01-28
9
1
2
3
4
5
6
7
8
9
›
⌄
--credit : https://app.flipsidecrypto.com/velocity/queries/8e1bedb2-0380-4f90-98e2-f607672537ce
SELECT DATE_TRUNC('month', block_timestamp) AS month
, COUNT(DISTINCT signers[0]) AS num_fee_payers
FROM solana.core.fact_transactions
WHERE succeeded
AND block_timestamp::DATE >= '2021-01-01'
AND block_timestamp::DATE < DATE_TRUNC('month', CURRENT_DATE)
GROUP BY 1
ORDER BY 1 DESC
Run a query to Download Data