StangFASTmint - part 1
Updated 2023-12-11
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
SELECT
date_trunc( 'day' , a.block_timestamp ) AS "date"
, count( distinct a.instruction:"accounts"[1] ) AS "users"
, count( distinct a.tx_id ) AS "transactions"
, sum( "users" ) over ( ORDER BY "date" ASC ) AS "total users"
, sum( "transactions" ) over ( ORDER BY "date" ASC ) AS "total transactions"
FROM
solana.core.ez_events_decoded a
JOIN
lateral flatten ( input => a.decoded_instruction ) b
WHERE
"date" >= '2023-02-01'
AND "date" <= dateadd( 'day' , -1 , current_date )
AND a.program_id = 'BGUMAp9Gq7iTEuizy4pqaxsTyUCBK68MDfK752saRPUY'
AND a.succeeded = 'true'
AND a.signers[0] = '7TUxaYgxGqRdmgtddPFjfyD5RHSrfGRinGktevEtMRny'
AND b.value = 'mintToCollectionV1'
GROUP BY 1
ORDER BY 1 DESC
Run a query to Download Data