Fetch User Information
- User by Wallet Address
- Mutual Follows/Followers
- Username Search
- Mutes, Blocks, and Bans
Build Farcaster Mini Apps
Host Farcaster Mini Apps
Fetch Cast Information
Build Bots and Agents
- Create Farcaster Bot or Agent
- Listen for @bot Mentions
- Make Agents Prompt Transactions
Fetch Farcaster Feeds
- Trending Feed on Farcaster
- Channel Feeds
- Feed of Given Farcaster user ID
- Casts by Embed in Farcaster
- How to Use the Neynar Feed API
Onboard New Users
- Create New Farcaster Account
- SIWN: Connect Farcaster Accounts
- Fetch Signers
- Add User Verification
Write Data to Farcaster
- Choose the Right Signer
- Write Data with Managed Signers
- Like & Recast
- Write Casts to Channel
Filter Spam, Low Quality Data
Run Queries on FC Data
- Choose Among Data Products
- Ingest Farcaster Data
- From Parquet Exports
- From Kafka Stream
- Indexer Service
- Hosted SQL
Render Farcaster in React
Get Events Via Webhooks
Fetch Notifications
Create Onchain Transactions
Intersect Onchain & Social Data
Write Direct Casts
Get Farcaster Storage Data
Publish Actions on FC Apps
Get Farcaster Data on Base
Explore Network Health
Get Hypersub Subscriptions
Contribute To Development
From Parquet Exports
Parquet Schema
Schema for data available in parquet ingestion
Details below:
Copy
% for x in data/*.parquet; do echo $x; parquet schema $x | jq; done
data/farcaster-casts-1713814200-1713814500.parquet
{
"type": "record",
"name": "schema",
"fields": [
{
"name": "created_at",
"type": [
"null",
{
"type": "long",
"logicalType": "timestamp-micros"
}
],
"default": null
},
{
"name": "updated_at",
"type": [
"null",
{
"type": "long",
"logicalType": "timestamp-micros"
}
],
"default": null
},
{
"name": "deleted_at",
"type": [
"null",
{
"type": "long",
"logicalType": "timestamp-micros"
}
],
"default": null
},
{
"name": "timestamp",
"type": [
"null",
{
"type": "long",
"logicalType": "timestamp-micros"
}
],
"default": null
},
{
"name": "fid",
"type": [
"null",
"long"
],
"default": null
},
{
"name": "hash",
"type": [
"null",
"bytes"
],
"default": null
},
{
"name": "parent_hash",
"type": [
"null",
"bytes"
],
"default": null
},
{
"name": "parent_fid",
"type": [
"null",
"long"
],
"default": null
},
{
"name": "parent_url",
"type": [
"null",
"string"
],
"default": null
},
{
"name": "text",
"type": [
"null",
"string"
],
"default": null
},
{
"name": "embeds",
"type": [
"null",
"string"
],
"default": null
},
{
"name": "mentions",
"type": [
"null",
"string"
],
"default": null
},
{
"name": "mentions_positions",
"type": [
"null",
"string"
],
"default": null
},
{
"name": "root_parent_hash",
"type": [
"null",
"bytes"
],
"default": null
},
{
"name": "root_parent_url",
"type": [
"null",
"string"
],
"default": null
},
{
"name": "id",
"type": [
"null",
"long"
],
"default": null
}
]
}
data/farcaster-fids-1713814200-1713814500.parquet
{
"type": "record",
"name": "schema",
"fields": [
{
"name": "created_at",
"type": [
"null",
{
"type": "long",
"logicalType": "timestamp-micros"
}
],
"default": null
},
{
"name": "updated_at",
"type": [
"null",
{
"type": "long",
"logicalType": "timestamp-micros"
}
],
"default": null
},
{
"name": "custody_address",
"type": [
"null",
"bytes"
],
"default": null
},
{
"name": "fid",
"type": [
"null",
"long"
],
"default": null
}
]
}
data/farcaster-fnames-1713814200-1713814500.parquet
{
"type": "record",
"name": "schema",
"fields": [
{
"name": "created_at",
"type": [
"null",
{
"type": "long",
"logicalType": "timestamp-micros"
}
],
"default": null
},
{
"name": "updated_at",
"type": [
"null",
{
"type": "long",
"logicalType": "timestamp-micros"
}
],
"default": null
},
{
"name": "custody_address",
"type": [
"null",
"bytes"
],
"default": null
},
{
"name": "expires_at",
"type": [
"null",
{
"type": "long",
"logicalType": "timestamp-micros"
}
],
"default": null
},
{
"name": "fid",
"type": [
"null",
"long"
],
"default": null
},
{
"name": "deleted_at",
"type": [
"null",
{
"type": "long",
"logicalType": "timestamp-micros"
}
],
"default": null
},
{
"name": "fname",
"type": [
"null",
"string"
],
"default": null
}
]
}
data/farcaster-links-1713814200-1713814500.parquet
{
"type": "record",
"name": "schema",
"fields": [
{
"name": "fid",
"type": [
"null",
"long"
],
"default": null
},
{
"name": "target_fid",
"type": [
"null",
"long"
],
"default": null
},
{
"name": "hash",
"type": [
"null",
"bytes"
],
"default": null
},
{
"name": "timestamp",
"type": [
"null",
{
"type": "long",
"logicalType": "timestamp-micros"
}
],
"default": null
},
{
"name": "created_at",
"type": [
"null",
{
"type": "long",
"logicalType": "timestamp-micros"
}
],
"default": null
},
{
"name": "updated_at",
"type": [
"null",
{
"type": "long",
"logicalType": "timestamp-micros"
}
],
"default": null
},
{
"name": "deleted_at",
"type": [
"null",
{
"type": "long",
"logicalType": "timestamp-micros"
}
],
"default": null
},
{
"name": "type",
"type": [
"null",
"string"
],
"default": null
},
{
"name": "display_timestamp",
"type": [
"null",
{
"type": "long",
"logicalType": "timestamp-micros"
}
],
"default": null
},
{
"name": "id",
"type": [
"null",
"long"
],
"default": null
}
]
}
data/farcaster-reactions-1713814200-1713814500.parquet
{
"type": "record",
"name": "schema",
"fields": [
{
"name": "created_at",
"type": [
"null",
{
"type": "long",
"logicalType": "timestamp-micros"
}
],
"default": null
},
{
"name": "updated_at",
"type": [
"null",
{
"type": "long",
"logicalType": "timestamp-micros"
}
],
"default": null
},
{
"name": "deleted_at",
"type": [
"null",
{
"type": "long",
"logicalType": "timestamp-micros"
}
],
"default": null
},
{
"name": "timestamp",
"type": [
"null",
{
"type": "long",
"logicalType": "timestamp-micros"
}
],
"default": null
},
{
"name": "reaction_type",
"type": [
"null",
"long"
],
"default": null
},
{
"name": "fid",
"type": [
"null",
"long"
],
"default": null
},
{
"name": "hash",
"type": [
"null",
"bytes"
],
"default": null
},
{
"name": "target_hash",
"type": [
"null",
"bytes"
],
"default": null
},
{
"name": "target_fid",
"type": [
"null",
"long"
],
"default": null
},
{
"name": "target_url",
"type": [
"null",
"string"
],
"default": null
},
{
"name": "id",
"type": [
"null",
"long"
],
"default": null
}
]
}
data/farcaster-signers-1713814200-1713814500.parquet
{
"type": "record",
"name": "schema",
"fields": [
{
"name": "created_at",
"type": [
"null",
{
"type": "long",
"logicalType": "timestamp-micros"
}
],
"default": null
},
{
"name": "updated_at",
"type": [
"null",
{
"type": "long",
"logicalType": "timestamp-micros"
}
],
"default": null
},
{
"name": "deleted_at",
"type": [
"null",
{
"type": "long",
"logicalType": "timestamp-micros"
}
],
"default": null
},
{
"name": "timestamp",
"type": [
"null",
{
"type": "long",
"logicalType": "timestamp-micros"
}
],
"default": null
},
{
"name": "fid",
"type": [
"null",
"long"
],
"default": null
},
{
"name": "signer",
"type": [
"null",
"bytes"
],
"default": null
},
{
"name": "name",
"type": [
"null",
"string"
],
"default": null
},
{
"name": "app_fid",
"type": [
"null",
"long"
],
"default": null
},
{
"name": "id",
"type": [
"null",
"long"
],
"default": null
}
]
}
data/farcaster-storage-1713814200-1713814500.parquet
{
"type": "record",
"name": "schema",
"fields": [
{
"name": "created_at",
"type": [
"null",
{
"type": "long",
"logicalType": "timestamp-micros"
}
],
"default": null
},
{
"name": "updated_at",
"type": [
"null",
{
"type": "long",
"logicalType": "timestamp-micros"
}
],
"default": null
},
{
"name": "deleted_at",
"type": [
"null",
{
"type": "long",
"logicalType": "timestamp-micros"
}
],
"default": null
},
{
"name": "timestamp",
"type": [
"null",
{
"type": "long",
"logicalType": "timestamp-micros"
}
],
"default": null
},
{
"name": "fid",
"type": [
"null",
"long"
],
"default": null
},
{
"name": "units",
"type": [
"null",
"long"
],
"default": null
},
{
"name": "expiry",
"type": [
"null",
{
"type": "long",
"logicalType": "timestamp-micros"
}
],
"default": null
},
{
"name": "id",
"type": [
"null",
"long"
],
"default": null
}
]
}
data/farcaster-user_data-1713814200-1713814500.parquet
{
"type": "record",
"name": "schema",
"fields": [
{
"name": "created_at",
"type": [
"null",
{
"type": "long",
"logicalType": "timestamp-micros"
}
],
"default": null
},
{
"name": "updated_at",
"type": [
"null",
{
"type": "long",
"logicalType": "timestamp-micros"
}
],
"default": null
},
{
"name": "deleted_at",
"type": [
"null",
{
"type": "long",
"logicalType": "timestamp-micros"
}
],
"default": null
},
{
"name": "timestamp",
"type": [
"null",
{
"type": "long",
"logicalType": "timestamp-micros"
}
],
"default": null
},
{
"name": "fid",
"type": [
"null",
"long"
],
"default": null
},
{
"name": "hash",
"type": [
"null",
"bytes"
],
"default": null
},
{
"name": "type",
"type": [
"null",
"long"
],
"default": null
},
{
"name": "value",
"type": [
"null",
"string"
],
"default": null
},
{
"name": "id",
"type": [
"null",
"long"
],
"default": null
}
]
}
data/farcaster-verifications-1713814200-1713814500.parquet
{
"type": "record",
"name": "schema",
"fields": [
{
"name": "created_at",
"type": [
"null",
{
"type": "long",
"logicalType": "timestamp-micros"
}
],
"default": null
},
{
"name": "updated_at",
"type": [
"null",
{
"type": "long",
"logicalType": "timestamp-micros"
}
],
"default": null
},
{
"name": "deleted_at",
"type": [
"null",
{
"type": "long",
"logicalType": "timestamp-micros"
}
],
"default": null
},
{
"name": "timestamp",
"type": [
"null",
{
"type": "long",
"logicalType": "timestamp-micros"
}
],
"default": null
},
{
"name": "fid",
"type": [
"null",
"long"
],
"default": null
},
{
"name": "hash",
"type": [
"null",
"bytes"
],
"default": null
},
{
"name": "claim",
"type": [
"null",
"string"
],
"default": null
},
{
"name": "id",
"type": [
"null",
"long"
],
"default": null
}
]
}
data/farcaster-profile_with_addresses-1713975600-1713975900.parquet
{
"type" : "record",
"name" : "schema",
"fields" : [ {
"name" : "fname",
"type" : [ "null", "string" ],
"default" : null
}, {
"name" : "display_name",
"type" : [ "null", "string" ],
"default" : null
}, {
"name" : "avatar_url",
"type" : [ "null", "string" ],
"default" : null
}, {
"name" : "bio",
"type" : [ "null", "string" ],
"default" : null
}, {
"name" : "verified_addresses",
"type" : [ "null", "string" ],
"default" : null
}, {
"name" : "updated_at",
"type" : [ "null", {
"type" : "long",
"logicalType" : "timestamp-micros"
} ],
"default" : null
}, {
"name" : "fid",
"type" : [ "null", "long" ],
"default" : null
} ]
}
Was this page helpful?
Assistant
Responses are generated using AI and may contain mistakes.