AS (SELECT Date_trunc('hour', block_timestamp) AS date,

Count(tx_id) / ( 60 ) AS flow_succeed_txs

FROM flow.core.fact_events

WHERE tx_succeeded = 'true'

AND date >= '2022-05-09'

AND DATE < CURRENT_DATE

GROUP BY 1 ),

flow_unsucceeded_txs

AS (SELECT Date_trunc('hour', block_timestamp) AS date,

Count(tx_id) / ( 60 ) AS flow_unsucceed_txs

FROM flow.core.fact_events

WHERE tx_succeeded = 'false'

AND date >= '2022-05-09'

AND DATE < CURRENT_DATE

GROUP BY 1

),

polygon_succeeded_txs

AS (SELECT Date_trunc('hour', block_timestamp) AS date,

Count(tx_id) / ( 60 ) AS poly_succeed_txs

FROM flipside_prod_db.polygon.transactions

WHERE success = 'true'

AND date >= '2022-05-09'

AND DATE < CURRENT_DATE

GROUP BY 1 ),

polygon_unsucceeded_txs

AS (SELECT Date_trunc('hour', block_timestamp) AS date,

Count(tx_id) / ( 60 ) AS poly_unsucceed_txs

FROM flipside_prod_db.polygon.transactions

WHERE success = 'false'

AND date >= '2022-05-09'

AND DATE < CURRENT_DATE

GROUP BY 1

),