dune.neynar.dataset_farcaster_links - Dune Docs

Table description

The dune.neynar.dataset_farcaster_links table contains data about follower and following relationships on the Farcaster protocol. Each row represents a social graph link between two users.

Table Schema

Column Name	Type	Description
`id`	`BIGINT`	Auto-incrementing row identifier
`fid`	`BIGINT`	Farcaster user ID of the user who created the link
`target_fid`	`BIGINT`	Farcaster user ID of the link target
`hash`	`VARBINARY`	Unique hash of the link on the protocol
`timestamp`	`TIMESTAMP`	Timestamp when the link was created on the Farcaster protocol
`created_at`	`TIMESTAMP`	Timestamp when the record was created in the database
`updated_at`	`TIMESTAMP`	Timestamp when the record was last updated in the database
`deleted_at`	`TIMESTAMP`	Timestamp when the link was removed on the Farcaster protocol
`type`	`VARCHAR`	Link type (e.g. `follow`)
`display_timestamp`	`TIMESTAMP`	Display-friendly timestamp for the link event

Table Sample