princefarzamAmount of minting nft
Updated 2022-04-22
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
WITH mint AS (
SELECT
DISTINCT TX_ID AS Minting_txns
FROM solana.fact_events
WHERE PROGRAM_ID='tovt1VkTE2T4caWoeFP6a2xSFoew5mNpd7FWidyyMuk'
AND INDEX=4
AND INSTRUCTION:accounts[1]::string='rLmyBAjCYR1MNc3KSG77y5XXT2DuMxkcxfqLYvjjJCs'
AND INSTRUCTION:accounts[12]::string='Lednq4o7qpgBPVpr69ECzUqwZwXPevBdm4iXUxrLeiL')
SELECT
DATE_TRUNC('DAY', BLOCK_TIMESTAMP) AS DAY,
SUM(INSTRUCTION:parsed:info:amount::INT)/1E9 AS MNDE_TRANSFERRED
FROM solana.fact_events A INNER JOIN mint B ON A.TX_ID=B.Minting_txns
WHERE INDEX=1
AND EVENT_TYPE='transfer'
GROUP BY 1
ORDER BY 1 ASC
Run a query to Download Data