dune.lens.publication_open_action_module_acted_record - Dune Docs

Deprecation Notice: Lens data ingestion has been discontinued as of December 2025. Only historical data is available, and no new data will be added.

Table description

The dune.lens.publication_open_action_module_acted_record table holds which profiles have acted on that publication (collects are a part of an action).

Table Schema

Column Name	Type	Description
history_id	integer	Auto-incrementing record identifier
record_id	integer	Reference to the open action module record
publication_id	varchar	Publication ID that was acted on (format: `profileId-pubId`)
acted_profile_id	varbinary	Profile ID of the user who performed the action
implementation	varbinary	Contract address of the open action module
init_return_data	varbinary	Data returned by the module after processing the action
fiat_price_snapshot	decimal(10,2)	Fiat price snapshot at the time of the action
is_collect	boolean	Whether this action was specifically a collect
transaction_executor	varbinary	Address that executed the action transaction
tx_hash	varbinary	Transaction hash of the action
block_hash	varbinary	Hash of the block containing the transaction
block_number	integer	Block number of the transaction
log_index	integer	Index of the event log within the transaction
tx_index	integer	Index of the transaction within the block
block_timestamp	timestamp	Timestamp of the block

Table Sample