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

'Flow' as chain,

count(tx_id) as "count of transactions",

count(distinct PROPOSER) as "count of users",

("count of transactions"/24*60) as "transaction per miute (TPM)",

("count of transactions"/24*60*60) as "transaction per secound (TPS)",

("count of transactions"/"count of users") as "transaction per user"

from flow.core.fact_transactions

where block_timestamp >= '2022-01-01'

group by 1,2

union

select

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

'Ethereum' as chain,

count(tx_hash) as "count of transactions",

count(distinct ORIGIN_FROM_ADDRESS) as "count of users",

("count of transactions"/24*60) as "transaction per miute (TPM)",

("count of transactions"/24*60*60) as "transaction per secound (TPS)",

("count of transactions"/"count of users") as "transaction per user"

from ethereum.core.fact_token_transfers

where block_timestamp >= '2022-01-01'

group by 1,2

union

select

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

'Bsc' as chain,

count(tx_hash) as "count of transactions",

count(distinct FROM_ADDRESS) as "count of users",

("count of transactions"/24*60) as "transaction per miute (TPM)",

("count of transactions"/24*60*60) as "transaction per secound (TPS)",

("count of transactions"/"count of users") as "transaction per user"

from bsc.core.fact_transactions

where block_timestamp >= '2022-01-01'

group by 1,2

union