from sei.core.fact_msg_attributes

where attribute_key = '_contract_address'

and attribute_value in ('sei1ln7ntsqmxl8s502f83km9a475zyhcfhpj7v2fsm3pcmckdyys3tsktx9vk','sei1e3gttzq5e5k49f9f5gzvrl0rltlav65xu6p9xc0aj7e84lantdjqp7cncc')

and tx_succeeded = 'true'

and block_timestamp::Date >= '2023-12-01'

,

liquid_user as ( select block_timestamp::Date as date,

'Liquid Staking' as type,

a.tx_id,

attribute_value as user

from sei.core.fact_msg_attributes a join liquid b on a.tx_id = b.tx_id

where block_timestamp::Date >= '2023-12-01'

and attribute_key = 'fee_payer'

UNION all

select block_timestamp::Date as date,

'Spot Trading' as type,

tx_id,

swapper as user

from sei.defi.fact_dex_swaps

UNION all

select block_timestamp::Date as date,

'Liquidity' as type,

tx_id,

LIQUIDITY_PROVIDER_ADDRESS as user

from sei.defi.fact_lp_actions

select block_timestamp::Date as date,

'Lending and Borrow' as type,

tx_hash as tx_id,

origin_from_address as user

from sei.core_evm.fact_event_logs a join sei.core_evm.dim_contracts b on a.contract_address = b.address

where name ilike '%yei%'