select *

from near.core.fact_logs

where RECEIVER_ID='usmen.hot.tg'

and try_parse_json(CLEAN_LOG):event='nft_transfer'

and try_parse_json(CLEAN_LOG):standard='nep171'

and block_timestamp::date>='2024-04-10'),

usmen_mints as (

select block_timestamp, try_parse_json(CLEAN_LOG) as log,

log:data[0]:old_owner_id as from_address,

log:data[0]:new_owner_id as to_address,

log:data[0]:token_ids[0]::decimal as token_id,

tx_hash

from usmen_events

where to_address not in ('a.mitte-orderbook.near')

qualify row_number() over (partition by token_id order by block_timestamp desc)=1

count(distinct to_address) as holders

from usmen_mints