Query editor
-- This query used incompatible data types from Dune SQL alpha and may need to be updated.-- More details can be found on https://dune.com/docs/query/dunesql-changes/SELECT time,mints_gnosis_count as mint_countsFROM (SELECT time,mints_gnosis_count,COALESCE(mints_gnosis_count, 0) as gFROM (SELECT time,SUM(mints_gnosis) OVER(ORDER BY time) as mints_gnosis_countFROM (SELECT time,SUM(CASE WHEN source = 's2' THEN mints END) as mints_gnosisFROM (SELECT gnosis.evt_block_time as time, COUNT(gnosis.evt_block_time) AS mints, 's2' AS sourceFROM gnosis_sismo_badges_gnosis.Badges_evt_TransferSingle gnosisWHERE gnosis."from" = 0x0000000000000000000000000000000000000000 and gnosis."id" = '12747637'GROUP BY gnosis.evt_block_time) as countsGROUP BY time) as accumulated))