select
'Polygon' as chain,
BLOCK_TIMESTAMP::date as date,
avg (tx_count),
min(tx_count),
max(tx_count)
from polygon.core.fact_blocks
where BLOCK_TIMESTAMP >='2022-06-23'
group by 2
union ALL
select
'Flow' as chain,
BLOCK_TIMESTAMP::date as date,
avg (tx_count),
min(tx_count),
max(tx_count)
from flow.core.fact_blocks
where BLOCK_TIMESTAMP >='2022-06-23'
group by 2
union ALL
select
'Solana' as chain,
BLOCK_TIMESTAMP::date as date,
avg (tx_count),
min(tx_count),
max(tx_count)
from solana.core.fact_blocks
where BLOCK_TIMESTAMP >='2022-06-23'
group by 2
union ALL