gistfile1.txt

Covalent Tools
0xabefbc9fd2f806065b4f3c237d4b59d9a97bcac7

Get events
Found 5 log events.

Event name: Approval(indexed address owner, indexed address approved, indexed uint256 tokenId)
Topic hash: 0x8c5be1e5ebec7d5bd14f71427d1e84f3dd0314c0f7b2291e5b200ac8c7c3b925

SELECT 
    e.block_signed_at, 
    e.block_height, 
    '0x' || encode(e.tx_hash, 'hex'),
    '0x' || encode(extract_address(e.topics[2]), 'hex') AS logged_owner, 
    '0x' || encode(extract_address(e.topics[3]), 'hex') AS logged_approved, 
    e.topics[4] AS logged_tokenid   
     
FROM live.block_log_events e 
WHERE 
     e.sender = '\xabefbc9fd2f806065b4f3c237d4b59d9a97bcac7' 
     AND e.topics[1] = '\x8c5be1e5ebec7d5bd14f71427d1e84f3dd0314c0f7b2291e5b200ac8c7c3b925'
     
Event name: ApprovalForAll(indexed address owner, indexed address operator, bool approved)
Topic hash: 0x17307eab39ab6107e8899845ad3d59bd9653f200f220920489ca2b5937696c31

SELECT 
    e.block_signed_at, 
    e.block_height, 
    '0x' || encode(e.tx_hash, 'hex'),
    '0x' || encode(extract_address(e.topics[2]), 'hex') AS logged_owner, 
    '0x' || encode(extract_address(e.topics[3]), 'hex') AS logged_operator,   
    cast(abi_field(e.data, 0) as numeric) AS logged_approved 
FROM live.block_log_events e 
WHERE 
     e.sender = '\xabefbc9fd2f806065b4f3c237d4b59d9a97bcac7' 
     AND e.topics[1] = '\x17307eab39ab6107e8899845ad3d59bd9653f200f220920489ca2b5937696c31'
     
Event name: TokenMetadataURIUpdated(indexed uint256 _tokenId, address owner, string _uri)
Topic hash: 0xe3df41127db820c79e5b8d541a63e40e3e97b9af96f7a50bded13091b70df9ae

SELECT 
    e.block_signed_at, 
    e.block_height, 
    '0x' || encode(e.tx_hash, 'hex'),
    e.topics[2] AS logged__tokenid,   
    '0x' || encode(extract_address(abi_field(e.data, 0)), 'hex') AS logged_owner, 
    cast(abi_field(e.data, 1) as numeric) AS logged__uri 
FROM live.block_log_events e 
WHERE 
     e.sender = '\xabefbc9fd2f806065b4f3c237d4b59d9a97bcac7' 
     AND e.topics[1] = '\xe3df41127db820c79e5b8d541a63e40e3e97b9af96f7a50bded13091b70df9ae'
     
Event name: TokenURIUpdated(indexed uint256 _tokenId, address owner, string _uri)
Topic hash: 0x702fe2dc2dc0f68023540aa4a1e11811c0f29112f6ebf01e61b90538e4f29810

SELECT 
    e.block_signed_at, 
    e.block_height, 
    '0x' || encode(e.tx_hash, 'hex'),
    e.topics[2] AS logged__tokenid,   
    '0x' || encode(extract_address(abi_field(e.data, 0)), 'hex') AS logged_owner, 
    cast(abi_field(e.data, 1) as numeric) AS logged__uri 
FROM live.block_log_events e 
WHERE 
     e.sender = '\xabefbc9fd2f806065b4f3c237d4b59d9a97bcac7' 
     AND e.topics[1] = '\x702fe2dc2dc0f68023540aa4a1e11811c0f29112f6ebf01e61b90538e4f29810'
     
Event name: Transfer(indexed address from, indexed address to, indexed uint256 tokenId)
Topic hash: 0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef

SELECT 
    e.block_signed_at, 
    e.block_height, 
    '0x' || encode(e.tx_hash, 'hex'),
    '0x' || encode(extract_address(e.topics[2]), 'hex') AS logged_from, 
    '0x' || encode(extract_address(e.topics[3]), 'hex') AS logged_to, 
    e.topics[4] AS logged_tokenid   
     
FROM live.block_log_events e 
WHERE 
     e.sender = '\xabefbc9fd2f806065b4f3c237d4b59d9a97bcac7' 
     AND e.topics[1] = '\xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef'

zora uri func