princefarzamthe pace of minting nft
    Updated 2022-04-22
    SELECT
    date_trunc('day',BLOCK_TIMESTAMP) AS DAY,
    COUNT(DISTINCT TX_ID) AS Number_of_NFTs
    FROM solana.fact_events
    WHERE PROGRAM_ID='tovt1VkTE2T4caWoeFP6a2xSFoew5mNpd7FWidyyMuk'
    AND INDEX=4
    AND INSTRUCTION:accounts[1]::string='rLmyBAjCYR1MNc3KSG77y5XXT2DuMxkcxfqLYvjjJCs'
    AND INSTRUCTION:accounts[12]::string='Lednq4o7qpgBPVpr69ECzUqwZwXPevBdm4iXUxrLeiL'
    GROUP BY 1
    ORDER BY 1 ASC
    Run a query to Download Data