Logs

Find arbitrary smart contract events
Use Spice to find any smart contract event by filtering on the first value of the topics column. 
As an example, to get all on-chain OpenSea NFT sales, use the OrderFulfilled event hash: 0x9d9af8e38d66c62e2c12f0225249fd9d721c54b83f48d9352c97c6cacdcb6f31
Ethereum
Polygon
SELECT * 
FROM eth.recent_logs 
WHERE address = '0x00000000006c3852cbef3e08e8df289169ede581' -- OpenSea Seaport Contract
 AND topics[0] = '0x9d9af8e38d66c62e2c12f0225249fd9d721c54b83f48d9352c97c6cacdcb6f31'
-- OrderFulfilled(bytes32,address,address,address,(uint8,address,uint256,uint256)[],(uint8,address,uint256,uint256,address)[])
SELECT * 
FROM polygon.recent_logs 
WHERE address = '0x00000000006c3852cbef3e08e8df289169ede581' -- OpenSea Seaport Contract
 AND topics[0] = '0x9d9af8e38d66c62e2c12f0225249fd9d721c54b83f48d9352c97c6cacdcb6f31'
-- OrderFulfilled(bytes32,address,address,address,(uint8,address,uint256,uint256)[],(uint8,address,uint256,uint256,address)[])

Tokens

ENS Domains

Last modified 8mo ago