Skip to main content

​
Historical Data Access

Solayer provides historical InfiniSVM data access through Delta Sharing, an open protocol for secure, cross-platform data sharing. This allows you to access historical blockchain data, transaction records, and protocol analytics directly from your preferred tools and environments.
This historical data is for InfiniSVM Mainnet only.

​
Overview

Delta Sharing enables secure data sharing without copying data. You can read and analyze the shared data using various tools including:
  • Python (with Pandas)
  • Apache Spark
  • Power BI
  • Tableau
  • Snowflake and other Iceberg clients
Access persists as long as the credential is valid. Updates to the data are available in near real time. You can read and make copies of the shared data for your analysis.

​
Available Tables

Two tables are available through Delta Sharing:
TableDescriptionPartition Column
transactionsAll InfiniSVM transaction records with execution resultsblock_date
blocksBlock-level metadata including hashes and timestampsblock_month

​
Transactions Table

The transactions table contains detailed records of all InfiniSVM transactions.
ColumnTypeDescription
signatureSTRINGUnique transaction signature (not null)
slotBIGINTSlot number (not null)
shred_indexBIGINTShred index within the slot (not null)
block_unix_timestampBIGINTUnix timestamp of the block (not null)
block_dateDATEPartition column, auto-generated from timestamp
versioned_txVARIANTNested JSON containing signatures, message, etc. (not null)
execution_resultVARIANTFull Ok/Err structure: {"Ok": null} or {"Err": {...}} (not null)
job_effect_diffVARIANTContains pre_accounts, diffs, pre_balances, account_diff_ops
statusSTRING”Success” or “Fail”
errSTRINGError details (only present when status = “Fail”)
log_messagesARRAY<STRING>Array of log message strings
inner_instructionsVARIANTNested structure for inner instructions
return_dataVARIANTTransaction return data
executed_unitsBIGINTCompute units consumed (not null)
accounts_data_len_deltaBIGINTChange in account data length (not null)
feeBIGINTTransaction fee in lamports (not null)
To filter successful transactions, use execution_result:Ok IS NOT NULL in your queries.

​
Blocks Table

The blocks table contains block-level metadata.
ColumnTypeDescription
slotBIGINTSlot number, primary key (not null)
block_unix_timestampBIGINTUnix timestamp of the block (not null)
block_monthDATEPartition column, first day of the month
blockhashSTRINGBlock hash (not null)
parent_blockhashSTRINGParent block hash

​
Credential File

To access Solayer’s historical data, save the credential file below as a .share file (e.g., solayer.share) on your local system: 
{
  "shareCredentialsVersion": 1,
  "bearerToken": "ZWatTOE294P9bB30V-SBjZYnhgz5CM3DySSrDBoedk1UgL0YCJJdC0lDktWPnc4y",
  "endpoint": "https://oregon.cloud.databricks.com/api/2.0/delta-sharing/metastores/7a9fc20e-6a36-4fef-98fb-3c6c7c72f622",
  "expirationTime": "2027-01-14T19:43:33.280Z",
  "icebergEndpoint": "https://oregon.cloud.databricks.com/api/2.0/delta-sharing/metastores/7a9fc20e-6a36-4fef-98fb-3c6c7c72f622/iceberg"
}
This credential expires on January 14, 2027. If you need access after this date, please contact the Solayer team.

​
How to Access the Data

For detailed instructions on how to read and query the shared data using your preferred tool, please refer to the official Databricks documentation:

Delta Sharing Documentation

Complete guide for reading data shared via Delta Sharing with bearer tokens, including examples for Python, Spark, Power BI, Tableau, and more.

​
Support

If you encounter any issues or have questions about accessing the historical data: