select receiver,

block_timestamp,

tx_id,

transfer_type,

amount / pow(10,decimal) as amount,

currency

from osmosis.core.fact_airdrop

where receiver like 'osmo%'

and tx_succeeded = TRUE

union all

select receiver,

block_timestamp,

tx_id,

transfer_type,

amount / pow(10,decimal) as amount,

currency

from osmosis.core.fact_transfers

where transfer_type = 'OSMOSIS'

and receiver like 'osmo%'

and tx_succeeded = TRUE

),

first_transfer as (

select receiver,

min(block_timestamp) as first_transfer_date

from osmosis.core.fact_transfers

where receiver like 'osmo%'

and tx_succeeded = TRUE

and transfer_type = 'IBC_TRANSFER_IN'

group by 1

),

first_transfer_extended as (

select b.receiver as new_address,

b.block_timestamp as first_transfer_date,