date_trunc('day',block_timestamp) as "date(day)",

'Flow' as chain,

count(tx_id) as "total count of transactions",

"total count of transactions"/(24*60) as "total count of transactions per minute (TPM)",

count(case when TX_SUCCEEDED != TRUE then 1 end) as "count of fail transaction",

"count of fail transaction"/(24*60) as "total count of fail transactions per minute (TPM)",

"total count of transactions" - "count of fail transaction" as "count of success transaction",

"count of success transaction"/(24*60) as "total count of success transactions per minute (TPM)",

("count of success transaction"/"total count of transactions")* 100 as "rate of fail transaction"

from flow.core.fact_transactions

where block_timestamp >= '2022-01-01'

group by 1,2

union

select

date_trunc('day',block_timestamp) as "date(day)",

'Ethereum' as chain,

count(tx_hash) as "total count of transactions",

"total count of transactions"/(24*60) as "total count of transactions per minute (TPM)",

count(case when STATUS != 'SUCCESS' then 1 end) as "count of fail transaction",

"count of fail transaction"/(24*60) as "total count of fail transactions per minute (TPM)",

"total count of transactions" - "count of fail transaction" as "count of success transaction",

"count of success transaction"/(24*60) as "total count of success transactions per minute (TPM)",

("count of success transaction"/"total count of transactions")* 100 as "rate of fail transaction"

from ethereum.core.fact_transactions

where block_timestamp >= '2022-01-01'

group by 1,2

union

select

date_trunc('day',block_timestamp) as "date(day)",

'Bsc' as chain,

count(tx_hash) as "total count of transactions",

"total count of transactions"/(24*60) as "total count of transactions per minute (TPM)",

count(case when STATUS != 'SUCCESS' then 1 end) as "count of fail transaction",

"count of fail transaction"/(24*60) as "total count of fail transactions per minute (TPM)",

"total count of transactions" - "count of fail transaction" as "count of success transaction",