select

block_number,

block_timestamp,

tx_hash,

event_index,

event_inputs:to::string as to_address,

event_inputs:from::string as from_address,

event_inputs:tokenId::string as tokenId

from flipside_prod_db.ethereum_core.fact_event_logs

where block_timestamp > '2021-01-01'

and event_name = 'Transfer'

and contract_address = '0xbc4ca0eda7647a8ab7c2061c2e118a18a936f13d'

and tx_status = 'SUCCESS'

and event_inputs:tokenId::string = '6573'

qualify(ROW_NUMBER() over(PARTITION BY tokenId

ORDER BY block_number desc, tx_hash, event_index DESC)) = 1