Query editor
-- This query has been migrated to run on DuneSQL.-- If you need to change back because you’re seeing issues, use the Query History view to restore the previous version.-- If you notice a regression, please email [email protected].SELECTfirst_time,COUNT(DISTINCT Minted_Shoes) AS New_Shoes,SUM(COUNT(DISTINCT Minted_Shoes)) OVER (ORDER BYfirst_time) AS Cumu_ShoesFROM(SELECTMIN(block_date) AS first_time,mint AS Minted_ShoesFROMsolana.transactionsCROSS JOIN UNNEST (post_token_balances) AS post_token_balance(account, mint, owner, amount)WHEREblock_date >= (CURRENT_DATE - interval '60' day)AND signer = 'STEPNq2UGeGSzCyGVr2nMQAzf8xuejwqebd84wcksCK'AND CONTAINS(log_messages,'Program TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA invoke [1]')AND CONTAINS(log_messages,'Program log: Instruction: InitializeMint')AND successAND error IS NULLGROUP BY2)GROUP BYfirst_time