date_trunc('day',block_timestamp) as date,

count(DISTINCT proposer) as active_users,

count(DISTINCT tx_id) as transactions

from flow.core.fact_transactions

where block_timestamp >= '2022-12-24'

and tx_succeeded = TRUE

group by 1,2

UNION ALL

select 'Solana' as blockchain,

date_trunc('day',block_timestamp) as date,

count(DISTINCT signers[0]) as active_users,

count(DISTINCT tx_id) as transactions

from solana.core.fact_transactions

where block_timestamp >= '2022-12-24'

and succeeded = TRUE

group by 1,2

UNION ALL

select 'Osmosis' as blockchain,

date_trunc('day',block_timestamp) as date,

count(DISTINCT tx_from) as active_users,

count(DISTINCT tx_id) as transactions

from osmosis.core.fact_transactions

where block_timestamp >= '2022-12-24'

and tx_status = 'SUCCEEDED'

group by 1,2