select block_timestamp:: date as date, count(tx_id) as flow_transactions

from flow.core.fact_transactions

where block_timestamp:: date >= '2022-05-09'

and tx_succeeded = TRUE

group by 1

),

ethereum_data as (

select block_timestamp:: date as date, count(tx_hash) as ethereum_transactions

from flipside_prod_db.ethereum_core.fact_transactions

where block_timestamp:: date >= '2022-05-09'

and status = 'SUCCESS' --FAIL

group by 1

),

solana_data as (

select block_timestamp:: date as date, count(tx_id) as solana_transactions

from flipside_prod_db.solana.fact_transactions

where block_timestamp:: date >= '2022-05-09'

and succeeded = TRUE

group by 1

),

algorand_data as (

select block_timestamp:: date as date, count(tx_id) as algorand_transactions

from flipside_prod_db.algorand.transactions

where block_timestamp:: date >= '2022-05-09'

group by 1

select f.*,algorand_transactions,solana_transactions,ethereum_transactions from flow_data f

left join ethereum_data e on f.date=e.date

left join algorand_data a on f.date=a.date

left join solana_data s on f.date=s.date