flow_transactions AS (

SELECT tx.proposer AS user_address

, tx.block_timestamp

, tx.tx_id

, 'Flow' AS blockchain

FROM flow.core.fact_transactions AS tx

WHERE tx.block_timestamp >= '2021-12-01 00:00:00.000'

),

ethereum_transactions AS (

SELECT tx.from_address AS user_address

, tx.block_timestamp

, tx.tx_hash AS tx_id

, 'Ethereum' AS blockchain

FROM ethereum.core.fact_transactions AS tx

WHERE tx.block_timestamp >= '2021-12-01 00:00:00.000'

),

solana_transactions AS (

SELECT tx.signers[0]::STRING AS user_address

, tx.block_timestamp

, tx.tx_id

, 'Solana' AS blockchain

FROM solana.core.fact_transactions AS tx

WHERE tx.block_timestamp >= '2021-12-01 00:00:00.000'

),

user_active_periods AS (

SELECT blockchain

, user_address

, date_trunc('month', block_timestamp) AS period