(SELECT date(first_use) as day, count(DISTINCT sender) as total_new_users , sum(total_new_users ) over (order by day) as cumulative_users,'algo' as platform

from

(SELECT sender, min(block_timestamp) as first_use from algorand.TRANSACTIONs

GROUP by 1)

where first_use >= '2022-01-01'

GROUP by 1 ),

solana as

(SELECT date(first_use) as day, count(DISTINCT sender) as total_new_users , sum(total_new_users ) over (order by day) as cumulative_users,'solana' as platform

from

(SELECT signers[0] as sender, min(block_timestamp) as first_use from solana.fact_TRANSACTIONs

GROUP by 1)

where first_use >= '2022-01-01'

GROUP by 1 ),

terra as

(SELECT date(first_use) as day, count(DISTINCT sender) as total_new_users , sum(total_new_users ) over (order by day) as cumulative_users,'terra' as platform

from

(SELECT tx_from as sender, min(block_timestamp) as first_use from terra.TRANSACTIONs

GROUP by 1)

where first_use >= '2022-01-01'

GROUP by 1 ),

ethereum as

(SELECT date(first_use) as day, count(DISTINCT sender) as total_new_users , sum(total_new_users ) over (order by day) as cumulative_users,'ethereum' as platform

from

(SELECT origin_address as sender, min(block_timestamp) as first_use from ethereum.udm_events

GROUP by 1)

where first_use >= '2022-01-01'

GROUP by 1 )

SELECT * from ethereum

UNION ALL

SELECT * from terra

UNION ALL

SELECT * FROM algo

UNION ALL

SELECT * from solana