select receiver,

min(block_timestamp) as first_transfer_date

from osmosis.core.fact_transfers

where receiver like 'osmo%'

and tx_succeeded = TRUE

group by 1

),

daily_prices as (

select date_trunc('day', recorded_at) as fecha,

symbol,

avg(price) as avg_price

from osmosis.core.dim_prices

where recorded_at > '2021-05-01'

group by fecha, symbol

),

first_transfer_extended as (

select b.receiver as new_address,

b.block_timestamp as first_transfer_date,

b.tx_id,

b.transfer_type,

b.sender,

case

when b.sender like 'osmo%' then 'OSMOSIS'

when b.sender like 'cosmos%' then 'COSMOS'

when b.sender like 'evmos%' then 'EVMOS'

when b.sender like 'umee%' then 'UMEE'

when b.sender like 'terra%' then 'TERRA'

when b.sender like 'juno%' then 'JUNO'

when b.sender like 'secret%' then 'SECRET'

when b.sender like 'cro%' then 'CRYPTO.ORG'

when b.sender like 'cheqd%' then 'CHEQD'

when b.sender like 'comdex%' then 'COMDEX'

when b.sender like 'stars%' then 'STARGAZE'