Query editor
SELECT 'boba' AS blockchain, CAST(date_trunc('day', c.block_time) AS date) AS day, t."from" AS tx_from, count_if(c."from" <> t."from") AS internal_contracts, count_if(c."from" = t."from") AS direct_contractsFROM boba.creation_traces cJOIN boba.transactions t ON t.hash = c.tx_hash AND t.block_number = c.block_numberWHERE c.block_month >= DATE '2026-11-01'AND c.block_month < DATE '2026-12-01'AND c.block_time >= TIMESTAMP '2026-11-14 00:00:00'AND c.block_time < TIMESTAMP '2026-11-20 00:00:00'AND t.block_date >= DATE '2026-11-14'AND t.block_date < DATE '2026-11-20'GROUP BY 1, 2, 3UNION ALLSELECT 'boba' AS blockchain, COALESCE(CAST(date_trunc('day', max(t.block_time)) AS date), DATE '1970-01-01') AS day, 0x00 AS tx_from, CAST(-1 AS bigint) AS internal_contracts, CAST(-1 AS bigint) AS direct_contractsFROM boba.transactions tWHERE t.block_date >= DATE '2026-11-14'