select

address,

min(date) as address_creation_date

from terra.daily_balances

group by 1

),

contract_labels as (

select

address,

address_name

from terra.labels

where address = 'terra1sepfj7s0aeg5967uxnfk4thzlerrsktkpelm5s'

or address in ('terra1wfz7h3aqf4cjmjcvc6s8lxdhh7k30nkczyf0mj', 'terra17f7zu97865jmknk7p2glqvxzhduk78772ezac5', 'terra1wh39swv7nq36pnefnupttm2nr96kz7jjddyt2x')

or address_name like '%Terraswap%'

),

first_relevant_transaction_block as (select

u.address,

u.address_creation_date,

min(m.block_id) as first_transaction_block

from new_users u

inner join terra.msgs m

on u.address = m.msg_value:sender::string

and u.address_creation_date = date(m.block_timestamp)

inner join contract_labels l

on m.msg_value:contract::string = l.address

group by 1, 2)

date(m.block_timestamp) as block_date,

m.msg_value:contract::string as contract_address,

l.address_name as contract_name,

count(fb.address) as total_address_with_first_interaction

from first_relevant_transaction_block fb

inner join terra.msgs m

on m.msg_value:sender::string = fb.address

and m.block_id = fb.first_transaction_block