Query editor
select 'abstract' as blockchain, count(*) as transactions_30d, count(*) / 30.0 as transactions_per_day, count(distinct block_date) as days_with_data, cast(max(block_date) as varchar) as last_data_date from abstract.transactions where block_date >= date '2026-08-12' and block_date < date '2026-09-11'union allselect 'hedera' as blockchain, count(*) as transactions_30d, count(*) / 30.0 as transactions_per_day, count(distinct block_date) as days_with_data, cast(max(block_date) as varchar) as last_data_date from hedera.transactions where block_date >= date '2026-08-12' and block_date < date '2026-09-11'union allselect 'unichain' as blockchain, count(*) as transactions_30d, count(*) / 30.0 as transactions_per_day, count(distinct block_date) as days_with_data, cast(max(block_date) as varchar) as last_data_date from unichain.transactions where block_date >= date '2026-08-12' and block_date < date '2026-09-11'union allselect 'shape' as blockchain, count(*) as transactions_30d, count(*) / 30.0 as transactions_per_day, count(distinct block_date) as days_with_data, cast(max(block_date) as varchar) as last_data_date from shape.transactions where block_date >= date '2026-08-12' and block_date < date '2026-09-11'union allselect 'celo' as blockchain, count(*) as transactions_30d, count(*) / 30.0 as transactions_per_day, count(distinct block_date) as days_with_data, cast(max(block_date) as varchar) as last_data_date from celo.transactions where block_date >= date '2026-08-12' and block_date < date '2026-09-11'union allselect 'lens' as blockchain, count(*) as transactions_30d, count(*) / 30.0 as transactions_per_day, count(distinct block_date) as days_with_data, cast(max(block_date) as varchar) as last_data_date from lens.transactions where block_date >= date '2026-08-12' and block_date < date '2026-09-11'union allselect 'tac' as blockchain, count(*) as transactions_30d, count(*) / 30.0 as transactions_per_day, count(distinct block_date) as days_with_data, cast(max(block_date) as varchar) as last_data_date from tac.transactions where block_date >= date '2026-08-12' and block_date < date '2026-09-11'union allselect 'nova' as blockchain, count(*) as transactions_30d, count(*) / 30.0 as transactions_per_day, count(distinct block_date) as days_with_data, cast(max(block_date) as varchar) as last_data_date from nova.transactions where block_date >= date '2026-08-12' and block_date < date '2026-09-11'union allselect 'sei' as blockchain, count(*) as transactions_30d, count(*) / 30.0 as transactions_per_day, count(distinct block_date) as days_with_data, cast(max(block_date) as varchar) as last_data_date from sei.transactions where block_date >= date '2026-08-12' and block_date < date '2026-09-11'union allselect 'polygon' as blockchain, count(*) as transactions_30d, count(*) / 30.0 as transactions_per_day, count(distinct block_date) as days_with_data, cast(max(block_date) as varchar) as last_data_date from polygon.transactions where block_date >= date '2026-08-12' and block_date < date '2026-09-11'union allselect 'base' as blockchain, count(*) as transactions_30d, count(*) / 30.0 as transactions_per_day, count(distinct block_date) as days_with_data, cast(max(block_date) as varchar) as last_data_date from base.transactions where block_date >= date '2026-08-12' and block_date < date '2026-09-11'union allselect 'somnia' as blockchain, count(*) as transactions_30d, count(*) / 30.0 as transactions_per_day, count(distinct block_date) as days_with_data, cast(max(block_date) as varchar) as last_data_date from somnia.transactions where block_date >= date '2026-08-12' and block_date < date '2026-09-11'union allselect 'boba' as blockchain, count(*) as transactions_30d, count(*) / 30.0 as transactions_per_day, count(distinct block_date) as days_with_data, cast(max(block_date) as varchar) as last_data_date from boba.transactions where block_date >= date '2026-08-12' and block_date < date '2026-09-11'union allselect 'apechain' as blockchain, count(*) as transactions_30d, count(*) / 30.0 as transactions_per_day, count(distinct block_date) as days_with_data, cast(max(block_date) as varchar) as last_data_date from apechain.transactions where block_date >= date '2026-08-12' and block_date < date '2026-09-11'union allselect 'solana' as blockchain, count(*) as transactions_30d, count(*) / 30.0 as transactions_per_day, count(distinct block_date) as days_with_data, cast(max(block_date) as varchar) as last_data_date from solana.transactions where block_date >= date '2026-08-12' and block_date < date '2026-09-11'union allselect 'arbitrum' as blockchain, count(*) as transactions_30d, count(*) / 30.0 as transactions_per_day, count(distinct block_date) as days_with_data, cast(max(block_date) as varchar) as last_data_date from arbitrum.transactions where block_date >= date '2026-08-12' and block_date < date '2026-09-11'union allselect 'bnb' as blockchain, count(*) as transactions_30d, count(*) / 30.0 as transactions_per_day, count(distinct block_date) as days_with_data, cast(max(block_date) as varchar) as last_data_date from bnb.transactions where block_date >= date '2026-08-12' and block_date < date '2026-09-11'union allselect 'ronin' as blockchain, count(*) as transactions_30d, count(*) / 30.0 as transactions_per_day, count(distinct block_date) as days_with_data, cast(max(block_date) as varchar) as last_data_date from ronin.transactions where block_date >= date '2026-08-12' and block_date < date '2026-09-11'union allselect 'megaeth' as blockchain, count(*) as transactions_30d, count(*) / 30.0 as transactions_per_day, count(distinct block_date) as days_with_data, cast(max(block_date) as varchar) as last_data_date from megaeth.transactions where block_date >= date '2026-08-12' and block_date < date '2026-09-11'union allselect 'kaia' as blockchain, count(*) as transactions_30d, count(*) / 30.0 as transactions_per_day, count(distinct block_date) as days_with_data, cast(max(block_date) as varchar) as last_data_date from kaia.transactions where block_date >= date '2026-08-12' and block_date < date '2026-09-11'