with near as (select
block_timestamp::date as date,
count(distinct txn_hash) / (24 * 60) as tx_per_min
from flipside_prod_db.mdao_near.transactions
group by 1),
eth as (select
block_timestamp::date as date,
count(distinct tx_hash) / (24 * 60) as tx_per_min
from ethereum.core.fact_transactions
where date > (select min(date) from near)
group by 1)
select 'Near' as blockchain, * from near
union
select 'Ethereum' as blockchain, * from eth