(select

block_timestamp::date as date,

'ETH' as chain,

count(*) as txns

from ethereum.core.fact_transactions

group by 1, 2)

UNION

(select

block_timestamp::date as date,

'NEAR' as chain,

count(*) as txns

from near.core.fact_transactions

group by 1, 2)

UNION

(select

block_timestamp::date as date,

'POLYGON' as chain,

count(*) as txns

from polygon.core.fact_transactions

group by 1, 2)

) as combined_results

ORDER BY date DESC;