solana AS (

SELECT

date_trunc(day, block_timestamp) AS day,

COUNT(DISTINCT signers[0]) AS num_users,

COUNT(DISTINCT program_id) AS num_programs,

COUNT(DISTINCT tx_id) AS num_txs,

AVG(num_users) OVER () AS avg_num_users,

AVG(num_programs) OVER() AS avg_num_programs,

AVG(num_txs) OVER() AS avg_num_txs,

'solana' AS chain

FROM solana.core.fact_events

WHERE succeeded = TRUE

AND block_timestamp >= CURRENT_DATE - 30

AND block_timestamp < CURRENT_DATE

GROUP BY day

ORDER BY day

),

polygon AS (

SELECT

date_trunc(day, block_timestamp) AS day,

COUNT(DISTINCT origin_from_address) AS num_users,

COUNT(DISTINCT contract_address) AS num_programs,

COUNT(DISTINCT tx_hash) AS num_txs,

AVG(num_users) OVER () AS avg_num_users,

AVG(num_programs) OVER() AS avg_num_programs,

AVG(num_txs) OVER() AS avg_num_txs,

'polygon' AS chain

FROM polygon.core.ez_decoded_event_logs

WHERE tx_status = 'SUCCESS'

AND block_timestamp >= CURRENT_DATE - 30

AND block_timestamp < CURRENT_DATE

GROUP BY day

ORDER BY day