date_trunc(day,block_timestamp)::date as date,

'Flow' as chain,

count(distinct tx_id) as "# of Daily Tx",

count(distinct PROPOSER) as "# of Daily User",

("# of Daily Tx"/1440) as "Tx/Minute - TPM",

("# of Daily Tx"/86400) as "Tx/Sec - TPS",

("# of Daily Tx"/"# of Daily User") as "Tx/User"

from flow.core.fact_transactions

where block_timestamp >= '2022-01-01'

AND block_timestamp <= CURRENT_DATE - 1

group by 1,2

union ALL

select

date_trunc(day,block_timestamp)::date as date,

'Ethereum' as chain,

count(distinct tx_hash) as "# of Daily Tx",

count(distinct FROM_ADDRESS) as "# of Daily User",

("# of Daily Tx"/1440) as "Tx/Minute - TPM",

("# of Daily Tx"/86400) as "Tx/Sec - TPS",

("# of Daily Tx"/"# of Daily User") as "Tx/User"

from ethereum.core.fact_transactions

where block_timestamp >= '2022-01-01'

AND block_timestamp <= CURRENT_DATE - 1

group by 1,2

union ALL

select

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

'Cosmos' as chain,

count(distinct tx_id) as "# of Daily Tx",

count(distinct TX_FROM) as "# of Daily User",

("# of Daily Tx"/1440) as "Tx/Minute - TPM",