with flow_u1 as(

SELECT block_timestamp, proposer as wallets , tx_id, 'Flow' AS blockchain

from flow.core.fact_transactions

where block_timestamp >= '2022-01-01'

),

sol_u1 as(

SELECT block_timestamp, SIGNERS [0] as wallets , tx_id, 'Solana' AS blockchain

from solana.core.fact_transactions

where block_timestamp >= '2022-01-01'

),

eth_u1 as(

SELECT block_timestamp, FROM_ADDRESS as wallets ,tx_hash as tx_id, 'Ethereum' AS blockchain

from ethereum.core.fact_transactions

where block_timestamp >= '2022-01-01'

),

active_user as(

SELECT blockchain,

wallets,

date_trunc('week', block_timestamp) AS period,

count(*) AS transactions

FROM flow_u1

GROUP BY 1,2,3

union all