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].WITHfirstseen AS (SELECTaccount_keys[1] AS account_id,MIN(block_date) AS block_dateFROMsolana.transactionsWHEREblock_date >= (CURRENT_DATE - interval '80' day)AND element_at(account_keys, 2) = 'STEPNq2UGeGSzCyGVr2nMQAzf8xuejwqebd84wcksCK'AND error IS NULLGROUP BY1)SELECT DISTINCTblock_date,COUNT(account_id) OVER (PARTITION BYblock_dateORDER BYblock_date) AS daily_new_deposited_accountsFROMfirstseenORDER BY1