SELECT ethereum.date,

ethereum.tps AS ethereum,

avelanch.tps AS avelanch,

near.tps AS near

FROM

SELECT block_timestamp::date as date, COUNT(TXN_HASH)/1440 AS tps

FROM flipside_prod_db.mdao_near.transactions

WHERE block_timestamp::date > '2022-01-01'

GROUP BY date

) near

LEFT JOIN

SELECT block_timestamp::date as date, COUNT(tx_id)/1440 AS tps

FROM ethereum.transactions

WHERE (block_timestamp::date > '2022-01-01')

GROUP BY date

) ethereum

ON (near.date = ethereum.date)

LEFT JOIN

SELECT block_timestamp::date as date, COUNT(TX_HASH)/1440 AS tps

FROM avalanche.core.fact_transactions

WHERE (block_timestamp::date> '2022-01-01')

GROUP BY date

) avelanch

ON (near.date = avelanch.date)