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

'Flow' as chain,

count(distinct tx_id) as Number_Tx,

count(distinct PROPOSER) as Number_Users,

(Number_Tx/1440) as Number_Tx_Minute,

(Number_Tx/86400) as Number_Tx_Sec,

(Number_Tx/Number_Users) as Number_TxUsers

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 Number_Tx,

count(distinct FROM_ADDRESS) as Number_Users,

(Number_Tx/1440) as Number_Tx_Minute,

(Number_Tx/86400) as Number_Tx_Sec,

(Number_Tx/Number_Users) as Number_TxUsers

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 Number_Tx,

count(distinct TX_FROM) as Number_Users,

(Number_Tx/1440) as Number_Tx_Minute,