> ## Documentation Index > Fetch the complete documentation index at: https://docs.sqd.dev/llms.txt > Use this file to discover all available pages before exploring further. ## Submitting Feedback If you encounter incorrect, outdated, or confusing documentation on this page, submit feedback: POST https://docs.sqd.dev/feedback ```json { "path": "/en/api/solana/finalized-stream", "feedback": "Description of the issue" } ``` Only submit feedback when you have something specific and actionable to report. # Stream Finalized Blocks > Returns only finalized blocks matching the query. Same request format as /stream but never returns unfinalized blocks, so there are no chain reorganizations to handle (no 409 responses). ## OpenAPI ````yaml /en/api/catalog/solana/openapi.yaml post /finalized-stream openapi: 3.1.0 info: title: SQD Portal API - Solana Dataset Endpoints description: >- API endpoints for interacting with Solana datasets under the SQD Portal, specifically for the solana-mainnet dataset. version: 1.0.0 servers: - url: https://portal.sqd.dev/datasets/solana-mainnet security: [] paths: /finalized-stream: post: summary: Stream Finalized Blocks description: > Returns only finalized blocks matching the query. Same request format as /stream but never returns unfinalized blocks, so there are no chain reorganizations to handle (no 409 responses). requestBody: description: Data query to filter and retrieve finalized blocks required: true content: application/json: schema: $ref: '#/components/schemas/DataQuery' examples: token-transfers: summary: Track SPL Token Transfers value: type: solana fromBlock: 280000000 toBlock: 280000100 fields: block: number: true timestamp: true tokenBalance: account: true preMint: true postMint: true preAmount: true postAmount: true preOwner: true postOwner: true tokenBalances: - preMint: - EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v program-instructions: summary: Program Instructions value: type: solana fromBlock: 280000000 toBlock: 280000100 fields: block: number: true timestamp: true instruction: programId: true accounts: true data: true transactionIndex: true instructions: - programId: - whirLbMiicVdio4qvUfM5KAg6Ct8VwpYzGff3uctyCc transactions: summary: Transactions value: type: solana fromBlock: 280000000 toBlock: 280000100 fields: block: number: true timestamp: true transaction: signatures: true feePayer: true err: true transactions: - {} responses: '200': description: >- A stream of blocks in JSON lines format, optionally gzipped. Can only be empty if the data query has a bounded range and all blocks in the range have been skipped. content: application/json: schema: type: array items: $ref: '#/components/schemas/Block' examples: token-balance-response: summary: Token balance response value: - header: number: 280000042 timestamp: 1700000000 tokenBalances: - transactionIndex: 3 account: 7kMFogLSGwpcPmxjYBYZq2F5uSJa3Fy6jhfW3GfdhGE8 preMint: EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v postMint: EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v preAmount: 1000000 postAmount: 500000 preOwner: 9WzDXwBbmkg8ZTbNMqUxvQRAyrZzDsGYdLVL9zYtAWWM postOwner: 9WzDXwBbmkg8ZTbNMqUxvQRAyrZzDsGYdLVL9zYtAWWM '204': description: >- Indicates that the requested block range is entirely above the range of blocks available in the dataset. The portal may wait for up to 5s before returning this content: text/plain: schema: type: string '400': description: > Possible causes: (1) request headers or body encoding are incorrect; (2) the query is invalid - the response will include an explanation; (3) fromBlock is below the dataset's start_block (see /metadata) content: text/plain: schema: type: string '404': description: Dataset not found content: text/plain: schema: type: string '409': description: Conflict due to a mismatched parent block hash content: application/json: schema: $ref: '#/components/schemas/ConflictResponse' '429': description: >- Too many requests; rate limit exceeded. May include a Retry-After header indicating the number of seconds to wait before retrying the request content: text/plain: schema: type: string headers: Retry-After: schema: type: integer description: Seconds to wait before retrying '500': description: Internal server error. Do not retry requests causing these content: text/plain: schema: type: string '503': description: >- The server could not process the request at the moment. The client should retry the request later. May include a Retry-After header indicating the number of seconds to wait before retrying the request content: text/plain: schema: type: string headers: Retry-After: schema: type: integer description: Seconds to wait before retrying x-codeSamples: - lang: shell label: Track SPL Token Transfers source: > curl --compressed -X POST 'https://portal.sqd.dev/datasets/solana-mainnet/finalized-stream' \ -H 'Content-Type: application/json' \ -d '{ "type": "solana", "fromBlock": 280000000, "toBlock": 280000100, "fields": { "block": { "number": true, "timestamp": true }, "tokenBalance": { "account": true, "preMint": true, "postMint": true, "preAmount": true, "postAmount": true, "preOwner": true, "postOwner": true } }, "tokenBalances": [{ "preMint": ["EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v"] }] }' - lang: shell label: Program Instructions source: > curl --compressed -X POST 'https://portal.sqd.dev/datasets/solana-mainnet/finalized-stream' \ -H 'Content-Type: application/json' \ -d '{ "type": "solana", "fromBlock": 280000000, "toBlock": 280000100, "fields": { "block": { "number": true, "timestamp": true }, "instruction": { "programId": true, "accounts": true, "data": true, "transactionIndex": true } }, "instructions": [{ "programId": ["whirLbMiicVdio4qvUfM5KAg6Ct8VwpYzGff3uctyCc"] }] }' - lang: shell label: Transactions source: > curl --compressed -X POST 'https://portal.sqd.dev/datasets/solana-mainnet/finalized-stream' \ -H 'Content-Type: application/json' \ -d '{ "type": "solana", "fromBlock": 280000000, "toBlock": 280000100, "fields": { "block": { "number": true, "timestamp": true }, "transaction": { "signatures": true, "feePayer": true, "err": true } }, "transactions": [{}] }' - lang: python label: Track SPL Token Transfers source: | import requests response = requests.post( "https://portal.sqd.dev/datasets/solana-mainnet/finalized-stream", json={ "type": "solana", "fromBlock": 280000000, "toBlock": 280000100, "fields": { "block": { "number": True, "timestamp": True }, "tokenBalance": { "account": True, "preMint": True, "postMint": True, "preAmount": True, "postAmount": True, "preOwner": True, "postOwner": True } }, "tokenBalances": [{ "preMint": ["EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v"] }] } ) data = response.json() - lang: javascript label: Track SPL Token Transfers source: > const response = await fetch("https://portal.sqd.dev/datasets/solana-mainnet/finalized-stream", { method: "POST", headers: { "Content-Type": "application/json" }, body: JSON.stringify({ type: "solana", fromBlock: 280000000, toBlock: 280000100, fields: { block: { number: true, timestamp: true }, tokenBalance: { account: true, preMint: true, postMint: true, preAmount: true, postAmount: true, preOwner: true, postOwner: true } }, tokenBalances: [{ preMint: ["EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v"] }] }) }); const data = await response.json(); components: schemas: DataQuery: type: object properties: type: type: string enum: - solana default: solana fromBlock: type: integer format: int64 description: >- The number of the first block to fetch. If unsure how far into the past this can go consult /metadata default: 317617480 toBlock: type: integer format: int64 description: The number of the last block to fetch (inclusive) default: 317617482 parentBlockHash: type: string description: Expected hash of the parent of the first requested block includeAllBlocks: type: boolean description: If true, includes blocks with no matching data fields: type: object description: >- Field selector. See the HTTP 200 response description for details on fields that aren't self-explanatory properties: instruction: type: object description: Field selector for instructions properties: transactionIndex: type: boolean description: Index of the parent transaction within the slot instructionAddress: type: boolean description: Position of the instruction in the call tree programId: type: boolean description: Public key of the program that executed the instruction accounts: type: boolean description: List of account public keys used by the instruction data: type: boolean description: Base58-encoded instruction data d1: type: boolean description: One-byte instruction discriminator d2: type: boolean description: Two-byte instruction discriminator d4: type: boolean description: Four-byte instruction discriminator d8: type: boolean description: Eight-byte instruction discriminator (Anchor standard) error: type: boolean description: Error message if the instruction failed computeUnitsConsumed: type: boolean description: Number of compute units consumed by the instruction isCommitted: type: boolean description: >- Whether the transaction containing this instruction was committed hasDroppedLogMessages: type: boolean description: Whether log messages were truncated for this instruction transaction: type: object description: Field selector for transactions properties: transactionIndex: type: boolean description: Index of the transaction within the slot version: type: boolean description: Transaction version (legacy or 0) accountKeys: type: boolean description: List of account public keys used by the transaction addressTableLookups: type: boolean description: Address table lookups used by versioned transactions numReadonlySignedAccounts: type: boolean description: Number of readonly accounts that require signatures numReadonlyUnsignedAccounts: type: boolean description: Number of readonly accounts that do not require signatures numRequiredSignatures: type: boolean description: Total number of signatures required by the transaction recentBlockhash: type: boolean description: Recent blockhash used by the transaction signatures: type: boolean description: List of transaction signatures err: type: boolean description: Error object if the transaction failed, null otherwise fee: type: boolean description: Transaction fee in lamports computeUnitsConsumed: type: boolean description: Number of compute units consumed by the transaction loadedAddresses: type: boolean description: Addresses loaded from address lookup tables feePayer: type: boolean description: Public key of the account that paid the transaction fee hasDroppedLogMessages: type: boolean description: Whether log messages were truncated for this transaction log: type: object description: Field selector for log messages properties: transactionIndex: type: boolean description: Index of the parent transaction within the slot logIndex: type: boolean description: Index of the log message within the transaction instructionAddress: type: boolean description: Address of the instruction that produced the log programId: type: boolean description: Public key of the program that emitted the log kind: type: boolean description: Log kind (log, data, or other) message: type: boolean description: The log message content balance: type: object description: Field selector for SOL balance updates properties: transactionIndex: type: boolean description: Index of the parent transaction within the slot account: type: boolean description: Public key of the account whose SOL balance changed pre: type: boolean description: SOL balance in lamports before the transaction post: type: boolean description: SOL balance in lamports after the transaction tokenBalance: type: object description: Field selector for token balance updates properties: transactionIndex: type: boolean description: Index of the parent transaction within the slot account: type: boolean description: Public key of the token account preMint: type: boolean description: Token mint address before the transaction postMint: type: boolean description: Token mint address after the transaction preDecimals: type: boolean description: Token decimals before the transaction postDecimals: type: boolean description: Token decimals after the transaction preProgramId: type: boolean description: Token program ID before the transaction postProgramId: type: boolean description: Token program ID after the transaction preOwner: type: boolean description: Owner of the token account before the transaction postOwner: type: boolean description: Owner of the token account after the transaction preAmount: type: boolean description: Token amount before the transaction postAmount: type: boolean description: Token amount after the transaction reward: type: object description: Field selector for rewards properties: pubKey: type: boolean description: Public key of the account that received the reward lamports: type: boolean description: Reward amount in lamports postBalance: type: boolean description: Account balance in lamports after the reward was applied rewardType: type: boolean description: Type of reward (e.g. fee, rent, voting, staking) commission: type: boolean description: Vote account commission when the reward was credited block: type: object description: >- Field selector for block headers (the .header objects of JSON block records) properties: number: type: boolean description: Slot number of the block hash: type: boolean description: Block hash parentNumber: type: boolean description: Slot number of the parent block parentHash: type: boolean description: Hash of the parent block height: type: boolean description: >- Block height (may differ from slot number due to skipped slots) timestamp: type: boolean description: Unix timestamp of the block default: instruction: data: true block: number: true instructions: type: array default: - programId: - dRiftyHA39MWEi3m9aunc5MzRF1JYuBsbn6VPcn33UH description: >- Instruction data requests. Selects instructions found anywhere in the call tree, not just the top level ones. d1-d8 filter by the starting bytes of the data (in 0x-prefixed hex format); a0-a15 filter by account at the corresponding position in the accounts array; mentionsAccount filters by account mentions anywhere in the list items: type: object properties: programId: type: array items: type: string d1: description: >- Accepted values for the first byte of the data in 0x-prefixed hex format type: array items: type: string d2: description: >- Accepted values for the first two bytes of the data in 0x-prefixed hex format type: array items: type: string d3: description: >- Accepted values for the first three bytes of the data in 0x-prefixed hex format type: array items: type: string d4: description: >- Accepted values for the first four bytes of the data in 0x-prefixed hex format type: array items: type: string d8: description: >- Accepted values for the first eight bytes of the data in 0x-prefixed hex format type: array items: type: string mentionsAccount: description: >- Selects instructions that mention a given account anywhere in their account lists, including at the positions higher than these accessible by the a* filters listed below type: array items: type: string a0: type: array items: type: string a1: type: array items: type: string a2: type: array items: type: string a3: type: array items: type: string a4: type: array items: type: string a5: type: array items: type: string a6: type: array items: type: string a7: type: array items: type: string a8: type: array items: type: string a9: type: array items: type: string a10: type: array items: type: string a11: type: array items: type: string a12: type: array items: type: string a13: type: array items: type: string a14: type: array items: type: string a15: type: array items: type: string isCommitted: type: boolean transaction: description: Fetch parent transactions for all matching instructions type: boolean transactionBalances: description: >- Fetch SOL balance updates caused by parent transactions of all matching instructions type: boolean transactionTokenBalances: description: >- Fetch token balance updates caused by parent transactions of all matching instructions type: boolean transactionInstructions: description: >- Fetch all "sibling" instructions / instructions executed by parent transactions of all matching instructions type: boolean innerInstructions: description: >- Fetch all instructions called by matching instructions (entire subtrees, not just the ones called directly) type: boolean logs: description: >- Fetch logs produced by matching instructions. Read https://docs.soldexer.dev/api-reference/data-notes/logs-truncation before attempting to use logs type: boolean transactions: type: array description: Transaction data requests items: type: object properties: feePayer: type: array items: type: string mentionsAccount: type: array items: type: string instructions: description: Fetch all instructions executed in the matching transactions type: boolean balances: description: Fetch all SOL balance updates due to the matching transactions type: boolean tokenBalances: description: >- Fetch all token balance updates due to the matching transactions type: boolean logs: description: >- Fetch all logs produced by the matching transactions. Read https://docs.soldexer.dev/api-reference/data-notes/logs-truncation before attempting to use logs type: boolean balances: type: array description: Requests for SOL balance updates items: type: object properties: account: type: array items: type: string transaction: description: Fetch parent transactions for all matching balance updates type: boolean transactionInstructions: description: >- Fetch all instructions executed by parent transactions of all matching balance updates type: boolean tokenBalances: type: array description: Requests for token balance updates items: type: object properties: account: type: array items: type: string preProgramId: type: array items: type: string postProgramId: type: array items: type: string preMint: type: array items: type: string postMint: type: array items: type: string preOwner: type: array items: type: string postOwner: type: array items: type: string transaction: description: Fetch parent transactions for all matching balance updates type: boolean transactionInstructions: description: >- Fetch all instructions executed by parent transactions of all matching balance updates type: boolean rewards: type: array description: Reward data requests items: type: object properties: pubkey: type: array items: type: string logs: type: array description: > Logs data requests. Read https://docs.soldexer.dev/api-reference/data-notes/logs-truncation before attempting to use logs items: type: object properties: programId: type: array items: type: string kind: type: array items: type: string enum: - log - data - other instruction: description: Fetch parent instructions for all matching logs type: boolean transaction: description: Fetch parent transactions for all matching logs type: boolean required: - fromBlock Block: type: object properties: header: type: object properties: number: type: integer format: uint64 hash: type: string parentNumber: type: integer format: uint64 parentHash: type: string height: type: integer format: uint64 instructions: type: array items: type: object properties: transactionIndex: type: integer instructionAddress: description: >- An array of tree indices addressing the instruction in the call tree. Top level instructions get addresses [0], [1], ...; addresses of length 2 indicate inner instructions directly called by one of the top ones; and so on. type: array items: type: integer programId: type: string accounts: type: array items: type: string data: type: string d1: description: One byte instruction discriminator type: string d2: description: Two bytes instruction discriminator type: string d4: description: Four bytes instruction discriminator type: string d8: description: Eight bytes instruction discriminator (Anchor standard) type: string error: type: string computeUnitsConsumed: type: integer format: uint64 isCommitted: type: boolean hasDroppedLogMessages: type: boolean transactions: type: array items: type: object properties: transactionIndex: type: integer version: type: integer accountKeys: type: array items: type: integer addressTableLookups: type: array items: type: object properties: accountKey: type: string readonlyIndexes: type: array items: type: integer writableIndexes: type: array items: type: integer numReadonlySignedAccounts: type: integer numReadonlyUnsignedAccounts: type: integer numRequiredSignatures: type: integer recentBlockhash: type: string signatures: description: >- List of transaction signatures. The first one of these is also known as a "transaction hash" type: array items: type: string err: type: object nullable: true fee: type: integer computeUnitsConsumed: type: integer loadedAddresses: type: object properties: readonly: type: array items: type: string writable: type: array items: type: string feePayer: type: string hasDroppedLogMessages: type: boolean balances: type: array description: > Records of SOL balance updates done per transaction and account. Combines pre- and post-balance records, making one record per account items: type: object properties: transactionIndex: type: integer account: type: string pre: type: integer post: type: integer tokenBalances: type: array description: > Records of token balance updates done per transaction and token account. Uses data from https://solana.com/docs/rpc/json-structures#token-balances but combines pre- and post-balance records, making one record per token account items: type: object properties: transactionIndex: type: integer account: description: The token account type: string preMint: description: >- The token mint account. Coincides with postMint when both are defined type: string postMint: description: >- The token mint account. Coincides with preMint when both are defined type: string preDecimals: type: integer postDecimals: type: integer preProgramId: type: string postProgramId: type: string preOwner: description: The owner of the token account at the start of the transaction type: string postOwner: description: >- The owner of the token account at the end of the transaction. When both pre- and postOwner are defined they can only be different if the transaction has changed the token account owner via the SetAuthority instruction type: string preAmount: type: integer postAmount: type: integer rewards: type: array items: type: object properties: pubKey: type: string lamports: type: integer postBalance: type: integer rewardType: type: string commission: type: integer logs: type: array description: > Read https://docs.soldexer.dev/api-reference/data-notes/logs-truncation before attempting to use logs items: type: object properties: transactionIndex: type: integer logIndex: type: integer instructionAddress: description: >- Address of the instruction that produced the log. See the instruction field description for details (HTTP 200 response description -> instructions -> instructionAddress) type: array items: type: integer programId: type: string kind: type: string enum: - log - data - other message: type: string required: - header ConflictResponse: type: object properties: previousBlocks: type: array items: type: object properties: number: type: integer format: int64 hash: type: string required: - number - hash required: - previousBlocks ````