date(minute) as day, avg(n_txn_flow) as avg_tpm

from (select date_trunc('minute', block_timestamp) as minute, count(distinct tx_id) as n_txn_flow

from flow.core.fact_transactions

-- where TX_SUCCEEDED = 'TRUE'

group by 1)

group by 1),

avaxd as (

select date(minute) as day, avg(n_txn_avax) as avg_txn

from (select date_trunc('minute', block_timestamp) as minute, count(distinct tx_hash) as n_txn_avax

from avalanche.core.fact_transactions

-- where STATUS='SUCCESS'

group by 1)

group by 1),

arbd as (select date(minute) as day, avg(n_txn) as avg_tpm_arbit

from

(select date_trunc('minute',block_timestamp) as minute, count(tx_hash) as n_txn from arbitrum.core.fact_transactions

group by 1)

group by 1)

select flowd.day, flowd.avg_tpm as flow_avg_tpm, avaxd.avg_txn as aval_avg_tpm, avg_tpm_arbit as arbit_avg_tpm

from flowd left join avaxd on flowd.day = avaxd.day

left join arbd on flowd.day = arbd.day