DATE | NUMBER_OF_MINTS | NUMBER_OF_WALLETS | ALL_MINTS | ALL_WALLETS | |
|---|---|---|---|---|---|
1 | 2025-01-10 00:00:00.000 | 347 | 336 | 347 | 336 |
2 | 2025-01-11 00:00:00.000 | 433 | 393 | 780 | 729 |
3 | 2025-01-12 00:00:00.000 | 391 | 367 | 1171 | 1096 |
4 | 2025-01-16 00:00:00.000 | 1 | 1 | 1172 | 1097 |
5 | 2025-01-17 00:00:00.000 | 1 | 1 | 1173 | 1098 |
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
Last run: about 2 months ago
5
219B
24s