origin_address as eth_user,

min(date_trunc('day', block_timestamp)) as eth_first_tx

from ethereum.udm_events

group by 1),

eth_new as (select

eth_first_tx,

count(distinct(eth_user)) as eth_new_users

from eth_base

where eth_first_tx > '2022-05-03'

and eth_first_tx < '2022-05-11'

group by 1),

terra_base as (select

msg_value:sender as terra_user,

min(date_trunc('day', block_timestamp)) as terra_first_tx

from terra.msgs

group by 1),

terra_new as (select

terra_first_tx,

count(distinct(terra_user)) as terra_new_users

from terra_base

where terra_first_tx > '2022-05-03'

and terra_first_tx < '2022-05-11'group by 1),

algo_base as (select

sender,

min(date_trunc('day', block_timestamp)) as algo_first_tx

from algorand.transactions

group by 1),

algo_new as (select

algo_first_tx,

count(distinct(sender)) as algo_new_users