lens_v1_polygon

Tables

HubEvents_Collected_event

Collection events from Lens Protocol social graph on Polygon, recording when users collect posts or mirrors. Tracks collector addresses, profile IDs, and publication references for analyzing content engagement and NFT-based social interactions.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_collector`	`STRING`	Address that receives collected fees or content. Hex-encoded, 0x-prefixed, 42-character string.
`in_profileId`	`STRING`	Unique identifier for the Lens Protocol profile. Numeric string representation of the profile ID.
`in_pubId`	`STRING`	Unique identifier for the publication within a Lens Protocol profile. Numeric string representation of the publication ID.
`in_rootProfileId`	`STRING`	Lens Protocol profile ID of the original post being collected, which may differ from the collector’s profile when collecting mirrors or comments. Numeric string identifier that traces back to the root content creator in the engagement chain.
`in_rootPubId`	`STRING`	Identifier of the original publication that was collected, when the collect action is on a mirror or comment. Equal to `in_pubId` for direct collects of root posts.
`in_collectModuleData`	`STRING`	Arbitrary data passed to the collect module when collecting a Lens publication. Typically empty (0x) but may contain encoded parameters for custom collect logic.
`in_timestamp`	`STRING`	Unix timestamp when the event or operation occurred. Numeric string representation of seconds since epoch.

Sample Data

address	removed	in_pubId	log_index	block_number	in_collector	in_profileId	in_rootPubId	in_timestamp	block_timestamp	in_rootProfileId	transaction_hash	in_collectModuleData
0xdb46d1dc155634fbc732f92e853b10b288ad5a1d	false	1	5	32911781	0xd1feccf6881970105dfb2b654054174007f0e07e	24701	1	1662777729	2022-09-10T02:42:09.000Z	24701	0x494c5026dfbaa38d097eb326cef9aee9fe6bfffc1969c2975a55f0a80ab13f6c	0x
0xdb46d1dc155634fbc732f92e853b10b288ad5a1d	false	1	186	32913373	0xd1feccf6881970105dfb2b654054174007f0e07e	3885	1	1662781141	2022-09-10T03:39:01.000Z	3885	0xb6adf0bd7a867b915d3d30c171624cc463d5a37bd55b8d079aed9b8ce9cae3e2	0x
0xdb46d1dc155634fbc732f92e853b10b288ad5a1d	false	1	36	32909055	0xd1feccf6881970105dfb2b654054174007f0e07e	1311	1	1662771849	2022-09-10T01:04:09.000Z	1311	0xe344b5f126993861605fb0e4c0d735f18f1d3407f2270002a0f5c54825822bba	0x

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.lens_v1_polygon.HubEvents_Collected_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

HubEvents_CommentCreated_event

Comment creation events from Lens Protocol social graph on Polygon, linking profile IDs to publication IDs and content URIs stored on Arweave. Used to analyze commenting behavior, content engagement patterns, and social interaction networks.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_profileId`	`STRING`	Unique identifier for the Lens Protocol profile. Numeric string representation of the profile ID.
`in_pubId`	`STRING`	Unique identifier for the publication within a Lens Protocol profile. Numeric string representation of the publication ID.
`in_contentURI`	`STRING`	URI pointing to the comment’s content metadata, typically stored on decentralized storage like Arweave. Contains the actual text, media, and metadata for the comment being created.
`in_profileIdPointed`	`STRING`	Lens Protocol profile ID of the publication being commented on. Numeric string identifier referencing the original post’s author profile.
`in_pubIdPointed`	`STRING`	Numeric identifier of the publication being commented on in the Lens Protocol. References the target post or content that this comment is responding to.
`in_referenceModuleData`	`STRING`	Hex-encoded data passed to the reference module contract when the comment was created. Typically empty (0x) when no additional module parameters are required.
`in_collectModule`	`STRING`	Contract address of the collect module that defines monetization rules for this comment on Lens Protocol. Can be the zero address (0x0000…) if no collect functionality is enabled.
`in_collectModuleReturnData`	`STRING`	Data returned by the collect module after executing its logic, typically empty (0x) for standard collect modules. Hex-encoded bytes that may contain module-specific output for custom collect implementations.
`in_referenceModule`	`STRING`	Contract address of the reference module controlling who can comment on or mirror this post. Commonly set to zero address (0x0000…) to allow unrestricted references.
`in_referenceModuleReturnData`	`STRING`	Hex-encoded return data from the reference module contract executed during comment creation. Typically empty (0x) when no reference module is configured or when the zero address module is used.
`in_timestamp`	`STRING`	Unix timestamp when the event or operation occurred. Numeric string representation of seconds since epoch.

Sample Data

address	removed	in_pubId	log_index	block_number	in_profileId	in_timestamp	in_contentURI	block_timestamp	in_pubIdPointed	in_collectModule	transaction_hash	in_referenceModule	in_profileIdPointed	in_referenceModuleData	in_collectModuleReturnData	in_referenceModuleReturnData
0xdb46d1dc155634fbc732f92e853b10b288ad5a1d	false	30	38	35014393	68016	1667192884	https://arweave.net/FN_fJXKVi4FZDdw1ujd556hdiSw61KwVXXJT_v9JsiU	2022-10-31T05:08:04.000Z	99	0x23b9467334beb345aaa6fd1545538f3d54436e96	0x68a202cb982c9367ab96d74e3a9fa7a723f625dc91df997eccf0643bc23e0150	0x0000000000000000000000000000000000000000	1	0x	0x0000000000000000000000000000000000000000000000000000000000000000	0x
0xdb46d1dc155634fbc732f92e853b10b288ad5a1d	false	161	429	35024000	4763	1667213421	https://arweave.net/gPLfamVjQytMvxfBkYDL55NaKdEyUGK7N9CcjvXjVIw	2022-10-31T10:50:21.000Z	126	0x23b9467334beb345aaa6fd1545538f3d54436e96	0xb8d2d08900104e036a363f68ba3560695ca0de2d6947bbf95ca50fb2d2c079e0	0x0000000000000000000000000000000000000000	1	0x	0x0000000000000000000000000000000000000000000000000000000000000000	0x
0xdb46d1dc155634fbc732f92e853b10b288ad5a1d	false	273	135	35024160	4703	1667213762	https://arweave.net/OPL-ayqEVjKAWW6Wn1MERLRj3vmRF-HHqLqkqyWKQYk	2022-10-31T10:56:02.000Z	126	0x23b9467334beb345aaa6fd1545538f3d54436e96	0xbee95c9e795f9cff6793cdfc6d9c61ae6a29c340fa7241a412bbe83880206c99	0x0000000000000000000000000000000000000000	1	0x	0x0000000000000000000000000000000000000000000000000000000000000000	0x

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.lens_v1_polygon.HubEvents_CommentCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

HubEvents_Followed_event

Follow events from Lens Protocol on Polygon capturing when users follow profiles, including follower addresses, profile IDs, and optional follow module data. Used for analyzing social graph growth and follower relationships across the decentralized social network.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_follower`	`STRING`	Polygon address of the user who initiated the follow action on Lens Protocol. Hex-encoded, 0x-prefixed 40-character string representing the follower’s wallet address.
`in_profileIds`	`STRING`	Lens Protocol profile IDs that were followed in this transaction, represented as a comma-separated string of numeric identifiers. May be empty when following multiple profiles in batch operations.
`in_followModuleDatas`	`STRING`	Additional encoded data passed to the Lens follow module contract to validate or process the follow action. Typically empty or minimal hex-encoded bytes; may contain parameters for gated follows or custom follow logic.
`in_timestamp`	`STRING`	Unix timestamp when the event or operation occurred. Numeric string representation of seconds since epoch.

Sample Data

address	removed	log_index	in_follower	block_number	in_timestamp	in_profileIds	block_timestamp	transaction_hash	in_followModuleDatas
0xdb46d1dc155634fbc732f92e853b10b288ad5a1d	false	77	0x6544e1c25ca2789fa2e221a68c9890c8915633ab	28564944	1653086071		2022-05-20T22:34:31.000Z	0xcbf00d54674e46b5aa15d77d752ac92b921dd74773200b188d7d25ef3d6f9adf
0xdb46d1dc155634fbc732f92e853b10b288ad5a1d	false	2	0x57b7bf6f792a6181ec5afb88ce7bce330a9d1b67	28529113	1653008467	1887	2022-05-20T01:01:07.000Z	0x407576d35968c97026c997a4df1e778d80dcbfbaad32f5bd8605a287f1fd40df	0x
0xdb46d1dc155634fbc732f92e853b10b288ad5a1d	false	2	0x57b7bf6f792a6181ec5afb88ce7bce330a9d1b67	28533532	1653017838	79	2022-05-20T03:37:18.000Z	0x4f72ed1b804b74223b11187a0adbfc3327cd0fb6aa5a50289a218ab2e44c8f80	0x

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.lens_v1_polygon.HubEvents_Followed_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

HubEvents_MirrorCreated_event

Mirror (repost) events from Lens Protocol v1 on Polygon, linking mirroring profiles to original posts via profile and publication IDs. Used for analyzing content amplification patterns and cross-profile engagement dynamics.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_profileId`	`STRING`	Unique identifier for the Lens Protocol profile. Numeric string representation of the profile ID.
`in_pubId`	`STRING`	Unique identifier for the publication within a Lens Protocol profile. Numeric string representation of the publication ID.
`in_profileIdPointed`	`STRING`	Lens Protocol profile ID that is being mirrored by this action. This references the original content creator’s profile in the mirror relationship.
`in_pubIdPointed`	`STRING`	Publication ID of the post being mirrored by this user. String-encoded integer identifier referencing the original publication within the pointed profile.
`in_referenceModuleData`	`STRING`	Hex-encoded data passed to the reference module smart contract when creating the mirror. Typically empty (0x) when no reference module is configured or no additional data is required.
`in_referenceModule`	`STRING`	Contract address of the reference module applied to this mirror, or zero address if none. Typically zero address, indicating no custom access control or validation logic for this mirror action.
`in_referenceModuleReturnData`	`STRING`	Encoded data returned by the reference module after processing the mirror creation. Typically empty (0x) when no reference module is used or when the module has no return data.
`in_timestamp`	`STRING`	Unix timestamp when the event or operation occurred. Numeric string representation of seconds since epoch.

Sample Data

address	removed	in_pubId	log_index	block_number	in_profileId	in_timestamp	block_timestamp	in_pubIdPointed	transaction_hash	in_referenceModule	in_profileIdPointed	in_referenceModuleData	in_referenceModuleReturnData
0xdb46d1dc155634fbc732f92e853b10b288ad5a1d	false	2	65	34875729	8007	1666900849	2022-10-27T20:00:49.000Z	1	0x684ed295ae9caef0299cb79a2a71eaeedfd206680d7662d0faf8228adc417812	0x0000000000000000000000000000000000000000	1	0x	0x
0xdb46d1dc155634fbc732f92e853b10b288ad5a1d	false	9	27	34864510	77963	1666877497	2022-10-27T13:31:37.000Z	114	0xeaf2a4347ecda1411c49377cda7a6b5ec07fe8d6c42fec459a7d1dde36abee51	0x0000000000000000000000000000000000000000	1	0x	0x
0xdb46d1dc155634fbc732f92e853b10b288ad5a1d	false	36	290	34853955	6448	1666855369	2022-10-27T07:22:49.000Z	126	0x743a5fd6dd34fdf4fc20c06133c6dece5f7d05ab3d15186ad72488b6b055bf6e	0x0000000000000000000000000000000000000000	1	0x	0x

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.lens_v1_polygon.HubEvents_MirrorCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

HubEvents_PostCreated_event

Post creation events from Lens Protocol V1 on Polygon, capturing publication metadata including profile IDs, content URIs (Arweave/IPFS), and collect/reference module configurations. Used for analyzing content creation patterns and social graph activity.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_profileId`	`STRING`	Unique identifier for the Lens Protocol profile. Numeric string representation of the profile ID.
`in_pubId`	`STRING`	Unique identifier for the publication within a Lens Protocol profile. Numeric string representation of the publication ID.
`in_contentURI`	`STRING`	URI pointing to the post’s content stored off-chain, typically on Arweave or IPFS. Follows formats like `ar://` or `https://arweave.net/` followed by the content identifier hash.
`in_collectModule`	`STRING`	Contract address of the collect module attached to this Lens post, defining how the content can be collected or monetized. Address 0xa31ff85e840ed117e172bc9ad89e55128a999205 indicates a common default collect module, while zero address means collecting is disabled.
`in_collectModuleReturnData`	`STRING`	Contract address of the collect module applied to this post on Lens Protocol. Set to zero address (0x0000…0000) when no collect conditions are enforced.
`in_referenceModule`	`STRING`	Contract address of the reference module governing interaction rules for this post on Lens Protocol. Zero address (0x000…000) indicates no reference restrictions are applied.
`in_referenceModuleReturnData`	`STRING`	Contract address of the reference module used for this post, or zero address if none configured. The reference module controls who can comment, mirror, or quote the post.
`in_timestamp`	`STRING`	Unix timestamp when the event or operation occurred. Numeric string representation of seconds since epoch.

Sample Data

address	removed	in_pubId	block_number	in_profileId	in_timestamp	in_contentURI	block_timestamp	in_collectModule	transaction_hash	in_referenceModule	in_collectModuleReturnData	in_referenceModuleReturnData
0xdb46d1dc155634fbc732f92e853b10b288ad5a1d	false	373	47248256	4417	1694077163	https://arweave.net/j5Eo8jGBH42MoEVzEGrBxcPBO_H2so4VflNs5o7yv20	2023-09-07T08:59:23.000Z	0xa31ff85e840ed117e172bc9ad89e55128a999205	0x7bfe68ac3648fae18c919c73e72207ef21b73028758e5fb1ee12415829db6ca7	0x0000000000000000000000000000000000000000	0x	0x
0xdb46d1dc155634fbc732f92e853b10b288ad5a1d	false	14	47247392	81252	1694075210	ar://LP_HXDiR4SaS1cvOJ2KtqDL5EdF-7NqxnhQfjpM6Xm0	2023-09-07T08:26:50.000Z	0xa31ff85e840ed117e172bc9ad89e55128a999205	0x361f89db334a179109098f3ce9aff810c25a002e23e5409f915f53849113b135	0x0000000000000000000000000000000000000000	0x	0x
0xdb46d1dc155634fbc732f92e853b10b288ad5a1d	false	1	47256608	119527	1694095065	ar://stvVaWVASh9zuVSuH-yr-FxtI06pzZG0sj3KD9czhFQ	2023-09-07T13:57:45.000Z	0xa31ff85e840ed117e172bc9ad89e55128a999205	0x327f08d1650756f7b28d8742a3d3f619c59faae16016daff58d905711e479212	0x0000000000000000000000000000000000000000	0x	0x

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.lens_v1_polygon.HubEvents_PostCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

HubEvents_ProfileCreated_event

Profile creation events from Lens Protocol on Polygon, capturing new user registrations with handles, profile IDs, wallet addresses, and follow module configurations. Used for analyzing user onboarding patterns and social graph formation.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_profileId`	`STRING`	Unique identifier for the Lens Protocol profile. Numeric string representation of the profile ID.
`in_creator`	`STRING`	Address of the account that initiated the creation event. Hex-encoded, 0x-prefixed, 42-character string.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_handle`	`STRING`	Unique username handle for the newly created Lens Protocol profile, formatted with .lens suffix. Human-readable identifier chosen by the profile creator at registration time.
`in_imageURI`	`STRING`	URI pointing to the profile’s image asset, typically stored on IPFS. May be empty if no profile image was set at creation time.
`in_followModule`	`STRING`	Smart contract address of the follow module applied to this profile, controlling who can follow and under what conditions. Zero address (0x00…00) indicates no follow restrictions are enabled.
`in_followModuleReturnData`	`STRING`	Return data from the follow module initialization when the profile was created. Typically empty (0x) when no follow module is configured or no initialization data is required.
`in_followNFTURI`	`STRING`	IPFS URI (InterPlanetary File System) pointing to the metadata for the follower NFT associated with this Lens Protocol profile. Each profile has a unique follower NFT collection, and this URI defines its metadata structure.
`in_timestamp`	`STRING`	Unix timestamp when the event or operation occurred. Numeric string representation of seconds since epoch.

Sample Data

in_to	address	removed	in_handle	log_index	in_creator	block_number	in_profileId	in_timestamp	block_timestamp	in_followModule	in_followNFTURI	transaction_hash	in_followModuleReturnData
0x9dd32d4cbf47b80bb6e32b639b52f7e8fd8fba4f	0xdb46d1dc155634fbc732f92e853b10b288ad5a1d	false	rajath.lens	69	0x1eec6eccaa4625da3fa6cd6339dbcc2418710e8a	29995441	34040	1656193492	2022-06-25T21:44:52.000Z	0x0000000000000000000000000000000000000000	ipfs://QmdhqUPgTYcub2MKD1TF6yMqctW7zU3EHngUHjxDcNn1bn	0xd3ffde1d929c8609fcb98abb9276275c8ba502197cceecab298e9f1e1be59f91	0x
0x30a82c1910af3e6233235a3bc3d738b6a2131ede	0xdb46d1dc155634fbc732f92e853b10b288ad5a1d	false	haradeas.lens	98	0x1eec6eccaa4625da3fa6cd6339dbcc2418710e8a	29970919	33997	1656135599	2022-06-25T05:39:59.000Z	0x0000000000000000000000000000000000000000	ipfs://QmQEJoMYkupMi7LFK7xKJ9MGsTXPmMruk8nMWniVt4YJsn	0x8f71ce5328438e98d3b70ea3fc42264689934352d45e76c8210868a0519e22d3	0x
0x85a363699c6864248a6ffca66e4a1a5ccf9f5567	0xdb46d1dc155634fbc732f92e853b10b288ad5a1d	false	marsx.lens	149	0x1eec6eccaa4625da3fa6cd6339dbcc2418710e8a	29985043	34022	1656170503	2022-06-25T15:21:43.000Z	0x0000000000000000000000000000000000000000	ipfs://QmSaeVe5pbXG3GFq82YBPAC57zL4CJwd539vSxLuxrG4VW	0x99d2b30680a29e7cd1a955cb4a4bc10928ca6e6c03367b650e0a29043f861706	0x

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.lens_v1_polygon.HubEvents_ProfileCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

HubEvents_Collected_event

HubEvents_CommentCreated_event

HubEvents_Followed_event

HubEvents_MirrorCreated_event

HubEvents_PostCreated_event

HubEvents_ProfileCreated_event

​Tables

​HubEvents_Collected_event

​HubEvents_CommentCreated_event

​HubEvents_Followed_event

​HubEvents_MirrorCreated_event

​HubEvents_PostCreated_event

​HubEvents_ProfileCreated_event

Tables

HubEvents_Collected_event

HubEvents_CommentCreated_event

HubEvents_Followed_event

HubEvents_MirrorCreated_event

HubEvents_PostCreated_event

HubEvents_ProfileCreated_event