with main as (
select
'Polygon' as chain,
--BLOCK_TIMESTAMP::date as date,
avg (tx_count) as avg,
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) as avg,
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) as avg,
min(tx_count),
max(tx_count)
from solana.core.fact_blocks
where BLOCK_TIMESTAMP >='2022-06-23'
-- group by 2
union ALL