from sei.core.fact_msg_attributes

where msg_type = 'wasm-staked'

and attribute_value = 'sei1cujl8ujhc36lp7sr98x30u0aeqtjlj68kll5rqqr9dke5xvn2ltquzhysl'

and attribute_key = 'token_address'

and block_timestamp::date >= '2024-04-15'

and tx_id in (select tx_id from sei.core.fact_msg_attributes

where block_timestamp::date >= '2024-04-15'

and attribute_value = 'sei1k20knz5qc0twatcs3t0tap32klaxprnwtc0f0npj8wd8x2a55vrs269a6f'

and attribute_key = '_contract_address'))

,

owner as ( select block_timestamp,

a.tx_id,

attribute_value as owner,

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

where msg_type = 'wasm-staked'

and block_timestamp::date >= '2024-04-15'

and ATTRIBUTE_KEY = 'owner'

and tx_succeeded = 'TRUE')

,

token_id as ( select a.block_timestamp,

a.tx_id,

owner,

a.msg_group,

attribute_value as token_id

from sei.core.fact_msg_attributes a join owner b on a.tx_id = b.tx_id and a.msg_group = b.msg_group

where msg_type = 'wasm-staked'

and a.block_timestamp::date >= '2024-04-15'

and ATTRIBUTE_KEY = 'token_id')

select

count(DISTINCT tx_id) as transaction,

count(DISTINCT owner) as owners,

count(DISTINCT token_id) as nfts,

nfts/owners as avg