Query editor
-- Aggregate raw columns first so to_hex runs on the reduced set.-- block_date >= DATE '2026-04-01' AND block_date < DATE '2026-07-01' is a block_date filter (activity window or a-- quarter slice) so Dune can prune time partitions.SELECT'abstract' AS chain,concat('0x', to_hex(address)) AS address,coalesce(concat('0x', to_hex("from")), '') AS entity,coalesce(cast(max_block AS varchar), '') AS extra,'created_contract' AS role,'evm_contract' AS address_kind,true AS source_eligibleFROM (SELECTaddress,"from",max(block_number) AS max_blockFROM abstract.creation_tracesWHERE block_date >= DATE '2026-04-01' AND block_date < DATE '2026-07-01'AND address IS NOT NULLGROUP BY 1, 2) deployed