select receiver as new_address,

min(block_timestamp) as first_transfer_date

from osmosis.core.fact_transfers

group by 1

),

first_transactions as (

select tx_from as new_active_address,

min(block_timestamp) as first_transaction_date

from osmosis.core.fact_transactions

group by 1

select date_trunc('day', tf.first_transfer_date) as fecha,

count(distinct tf.new_address) as daily_new_addresses_funded,

count(distinct tx.new_active_address) as daily_new_active_addresses_funded,

sum(daily_new_addresses_funded) over (order by fecha) as total_new_addresses_over_time,

sum(daily_new_active_addresses_funded) over (order by fecha) as total_new_active_addresses_over_time

from first_transfer_to tf

left join first_transactions tx

on tf.new_address = tx.new_active_address

group by 1

order by 1 desc