Query editor
-- How many accounts has this factory deployed, per chain?SELECT 'bnb' AS chain, COUNT(*) AS n_deployed, COUNT(DISTINCT address) AS n_distinct,MIN(block_time) AS first_deploy, MAX(block_time) AS last_deployFROM bnb.creation_traces WHERE "from" = 0xaac5d4240af87249b3f71bc8e4a2cae074a3e419UNION ALLSELECT 'base', COUNT(*), COUNT(DISTINCT address), MIN(block_time), MAX(block_time)FROM base.creation_traces WHERE "from" = 0xaac5d4240af87249b3f71bc8e4a2cae074a3e419UNION ALLSELECT 'ethereum', COUNT(*), COUNT(DISTINCT address), MIN(block_time), MAX(block_time)FROM ethereum.creation_traces WHERE "from" = 0xaac5d4240af87249b3f71bc8e4a2cae074a3e419UNION ALLSELECT 'arbitrum', COUNT(*), COUNT(DISTINCT address), MIN(block_time), MAX(block_time)FROM arbitrum.creation_traces WHERE "from" = 0xaac5d4240af87249b3f71bc8e4a2cae074a3e419