piperDaily PSG1 Mints from the past 10 days
Updated 2025-01-20
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
-- forked from Weekly PSG1 Mints @ https://flipsidecrypto.xyz/studio/queries/59a61fde-4a4e-4f98-b157-152460ece8f7
SELECT
DATE_TRUNC('day', BLOCK_TIMESTAMP) AS date,
COUNT(DISTINCT TX_ID) AS number_of_mints,
COUNT(DISTINCT INSTRUCTION:accounts[4]) AS number_of_wallets,
SUM(number_of_mints) OVER (ORDER BY date) AS all_mints,
sum(number_of_wallets) OVER (ORDER BY date) AS all_wallets
FROM
solana.core.fact_events
WHERE
SUCCEEDED = TRUE
AND BLOCK_TIMESTAMP >= CURRENT_DATE - 10
--AND TX_ID = '4NQHDkr8fCMGukjy34LSvDUDxihTtSCF5HCHrhjnPP9tKiveE9YnY2vWZwTMnwQkxQoTjAhPTxu5YCCH86qWqzqL'
AND PROGRAM_ID = 'CoREENxT6tW1HoK8ypY1SxRMZTcVPm7R94rH4PZNhX7d'
AND INSTRUCTION:accounts[3] = 'PSG1TGSniaZTFdzcxz8G5JaQ4oa8k2cSa9YZiqKTGu6'
--AND INSTRUCTION:accounts[4] = 'CFCdnbGHyhsNwY6w7mUXgNW4VSpnL2AaZdtihA716zJG'
GROUP BY date
QueryRunArchived: QueryRun has been archived