DATE_TRUNC('day', BLOCK_TIMESTAMP) AS day_block_time,

COUNT(DISTINCT(tx_id)) as sol_transaction_count

FROM solana.core.fact_transactions

WHERE DATE(block_timestamp) > '2023-01-01'

AND succeeded = TRUE

GROUP BY DATE_TRUNC('day', BLOCK_TIMESTAMP)

),

polygon_tps as (

SELECT

DATE_TRUNC('day', BLOCK_TIMESTAMP) AS day_block_time,

COUNT(*) AS poly_transaction_count

FROM polygon.core.fact_transactions

WHERE BLOCK_TIMESTAMP >= '2023-01-01'

AND status = 'SUCCESS'

GROUP BY DATE_TRUNC('day', BLOCK_TIMESTAMP)

),

avax_tps as (

SELECT

DATE_TRUNC('day', BLOCK_TIMESTAMP) AS day_block_time,

COUNT(*) AS avax_transaction_count

FROM avalanche.core.fact_transactions

WHERE BLOCK_TIMESTAMP >= '2023-01-01'

AND status = 'SUCCESS'

GROUP BY DATE_TRUNC('day', BLOCK_TIMESTAMP)

, tbl as (SELECT

a.day_block_time as dt,

sol_transaction_count,

poly_transaction_count,

avax_transaction_count,