select receiver,

min(block_timestamp) as first_transfer_date

from osmosis.core.fact_transfers

where tx_succeeded = TRUE

group by 1

),

last_transfers as (

select receiver,

min(block_timestamp) as last_transfer_date

from osmosis.core.fact_transfers

where tx_succeeded = TRUE

group by 1

),

osmo_transfers as (

select receiver,

count (distinct tx_id) as transactions

from osmosis.core.fact_transfers

where tx_succeeded = TRUE

and transfer_type = 'OSMOSIS'

group by 1

),

ibc_out_transfers as (

select sender,

count (distinct tx_id) as transactions

from osmosis.core.fact_transfers

where tx_succeeded = TRUE

and transfer_type = 'IBC_TRANSFER_OUT'

group by 1

),

ibc_in_transfers as (

select receiver,