date_trunc('month',block_timestamp)::date as date,

'Flow' as chain,

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

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

("# of Montly Tx"/43200) as "Tx/Minute - TPM",

("# of Montly Tx"/2592000) as "Tx/Sec - TPS",

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

from flow.core.fact_transactions

where block_timestamp::date >= '2022-01-01'

AND block_timestamp::date <= CURRENT_DATE - 1

group by 1,2

union ALL

select

date_trunc('month',block_timestamp)::date as date,

'Ethereum' as chain,

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

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

("# of Montly Tx"/43200) as "Tx/Minute - TPM",

("# of Montly Tx"/2592000) as "Tx/Sec - TPS",

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

from ethereum.core.fact_transactions

where block_timestamp::date >= '2022-01-01'

AND block_timestamp::date <= CURRENT_DATE - 1

group by 1,2

union ALL

select

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

'Cosmos' as chain,

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

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

("# of Montly Tx"/43200) as "Tx/Minute - TPM",