princefarzamAmount of minting nft
    Updated 2022-04-22
    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