blocks AS (

SELECT 'NEAR' AS blockchain

, block_height

, block_timestamp

, tx_count

FROM flipside_prod_db.mdao_near.blocks

WHERE block_timestamp >= '2021-09-01 00:00:00.000'

UNION ALL

SELECT 'Ethereum' AS blockchain

, block_number AS block_height

, block_timestamp

, tx_count

FROM ethereum.core.fact_blocks

WHERE block_timestamp >= '2021-09-01 00:00:00.000'

UNION ALL

SELECT 'Solana' AS blockchain

, block_height

, block_timestamp

, tx_count

FROM solana.core.fact_blocks

WHERE block_timestamp >= '2021-09-01 00:00:00.000'

UNION ALL

SELECT 'Algorand' AS blockchain

, block_id AS block_height

, block_timestamp