Data Class

To cover OpenSea actions and features, we created the following data classes:

• AddressOpenseaTransaction: Records all opensea transactions for a specific address. One opensea transaction per row.

• OpenseaOrder: Records information about individual OpenSea orders. One order per row.

These data classes capture the essential information for tracking OpenSea activities and order details.

AddressOpenseaTransaction

Column Name	Data Type	Note
address	str	Address associated with the transaction
related_address	str	Related address in the transaction
is_offer	bool	Flag indicating if the address is an offer in transaction
transaction_type	int	Type of the transaction(buy, sell or swap)
order_hash	str	Hash of the associated opensea order
zone	str	Zone of the transaction
offer	dict	Details of the offer
consideration	dict	Details of the consideration
fee	dict	Fee details for the transaction
transaction_hash	str	Hash of the transaction
block_number	int	Number of the block containing the transaction
log_index	int	Index of the log in the transaction
block_timestamp	int	Timestamp of when the block was mined
block_hash	str	Hash of the block containing the transaction
protocol_version	str	Version of the seaport protocol used

OpenseaOrder

Column Name	Data Type	Note
order_hash	str	Hash of the order
zone	str	Zone of the order
offerer	str	Address of the offerer
recipient	str	Address of the recipient
offer	dict	Details of the offer
consideration	dict	Details of the consideration
block_timestamp	int	Timestamp of when the block was mined
block_hash	str	Hash of the block containing the order
transaction_hash	str	Hash of the transaction associated with the order
log_index	int	Index of the log in the transaction
block_number	int	Number of the block containing the order
protocol_version	str	Version of the protocol used (default: "1.6")