> For the complete documentation index, see [llms.txt](https://docs.everstake.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.everstake.com/integrations/everstake-products/data-product-deprecated/solana.md).

# Solana

Public documentation for Solana blockchain data product on Snowflake

<details>

<summary>General Information</summary>

<table data-header-hidden><thead><tr><th width="337.75"></th><th></th><th data-hidden></th></tr></thead><tbody><tr><td>Refresh Frequency</td><td>Daily at 12:01 UTC</td><td></td></tr><tr><td>Status</td><td>Supporting</td><td></td></tr><tr><td>Support</td><td>account-data-support@everstake.one</td><td></td></tr><tr><td>Contact</td><td>contact@everstake.one</td><td></td></tr></tbody></table>

</details>

***

## Overview

This dataset allows businesses and investors to strategically monitor Solana staking behavior, gain real-time insights into validator performance, and optimize reward-based investment decisions. Analyzing metrics such as APR, delegated stakes, and validator rewards can uncover patterns in on-chain activity to support portfolio management and yield optimization.

Whether you’re assessing validator reliability, identifying top-performing validators for delegation, or seeking to predict market trends based on staking activity, our comprehensive Solana staking data provides a powerful foundation for actionable insights.

***

## Tables

<details>

<summary>APR</summary>

{% hint style="success" %}

#### Business value and potential connections

Provides insights into validator profitability by calculating annual percentage rates (APR) and rewards from both the consensus and execution layers. Useful for tracking staking returns over time.

> **Can be JOINed with** `VALIDATORS` (to get validator details) and `STAKE` (to compare staking activity with APR and rewards).
> {% endhint %}

<table data-full-width="false"><thead><tr><th width="182.111083984375">Column</th><th width="157.111083984375">Type</th><th>Description</th></tr></thead><tbody><tr><td>APR</td><td>Float</td><td>Annual Percentage Rate</td></tr><tr><td>CURRENCY</td><td>Varchar</td><td>The constant 'lamport' in this case</td></tr><tr><td>DIM_NAME</td><td>Varchar</td><td>Dimension name</td></tr><tr><td>DIM_NUMBER</td><td>Number</td><td>The numeric identifier of the dimension</td></tr><tr><td>INSERTED_TIME</td><td>Timestamp_NTZ</td><td>The UTC timestamp at which the row was inserted into the table</td></tr><tr><td>MODIFIED_TIME</td><td>Timestamp_NTZ</td><td>The UTC timestamp at which the row was last modified</td></tr><tr><td>REWARD</td><td>Number</td><td>The total reward earned by the validator during the dimension</td></tr><tr><td>TOTAL_STAKE</td><td>Number</td><td>The total amount of stake delegated to the validator during the dimension</td></tr><tr><td>VALIDATOR</td><td>Varchar</td><td>Validator's vote account </td></tr></tbody></table>

</details>

<details>

<summary>AUTHORITY_STAKE</summary>

{% hint style="success" %}

### Business value and potential connections

Provides information on the relationship between stake accounts and their controlling authorities, supporting analysis of validator influence and stake management.

> **Can be JOINed with** `VALIDATORS` (to get validator details) and `STAKE` (to analyze authority control over staking activity).
> {% endhint %}

<table><thead><tr><th width="221">Column</th><th width="154.75">Type</th><th>Description</th></tr></thead><tbody><tr><td>BLOCK</td><td>Number</td><td>The Solana slot number in which the transaction was recorded</td></tr><tr><td>BLOCK_TIME</td><td>Number</td><td>The UNIX timestamp when the block was produced</td></tr><tr><td>DELEGATOR_AUTHORITY</td><td>Varchar</td><td>The authority account controlling the stake account</td></tr><tr><td>DELEGATOR_IDENTITY</td><td>Varchar</td><td>The unique identifier of the delegator account (stake account address)</td></tr><tr><td>HASH</td><td>Varchar</td><td>The transaction signature</td></tr><tr><td>INSERTED_TIME</td><td>Timestamp_NTZ</td><td>The UTC timestamp at which the row was inserted into the table</td></tr><tr><td>MODIFIED_TIME</td><td>Timestamp_NTZ</td><td>The UTC timestamp at which the row was last modified</td></tr></tbody></table>

</details>

<details>

<summary>DELEGATOR_REWARDS</summary>

{% hint style="success" %}

### Business value and potential connections

Provides insights into individual delegator earnings, helping to evaluate the distribution and effectiveness of staking rewards across participants.

> **Can be JOINed with** `VALIDATORS` (to get validator details) and `STAKE` (to analyze staking and reward relationships).
> {% endhint %}

<table><thead><tr><th width="166">Column</th><th width="158.5">Type</th><th>Description</th></tr></thead><tbody><tr><td>AMOUNT</td><td>Number</td><td>The amount of reward earned by the delegator, in lamports</td></tr><tr><td>BLOCK</td><td>Number</td><td>The Solana slot number in which the reward was recorded</td></tr><tr><td>CREATED_AT</td><td>Timestamp_NTZ</td><td>The original UTC timestamp when the reward event occurred on-chain</td></tr><tr><td>CURRENCY</td><td>Varchar</td><td>The constant 'lamport' in this case</td></tr><tr><td>DELEGATOR</td><td>Varchar</td><td>The public key of the delegator who received the reward</td></tr><tr><td>DIM_NAME</td><td>Varchar</td><td>The name of the dimension</td></tr><tr><td>DIM_NUMBER</td><td>Number</td><td>The numerical identifier of the dimension</td></tr><tr><td>HASH</td><td>Varchar</td><td>Unique transaction signature</td></tr><tr><td>INSERTED_TIME</td><td>Timestamp_NTZ</td><td>The UTC timestamp at which the row was inserted into the table</td></tr><tr><td>MODIFIED_TIME</td><td>Timestamp_NTZ</td><td>The UTC timestamp at which the row was last modified</td></tr><tr><td>VALIDATOR</td><td>Varchar</td><td>Validator's vote account</td></tr></tbody></table>

</details>

<details>

<summary>DIMENSIONS</summary>

{% hint style="success" %}

#### Business value and potential connections

Provides essential blockchain structure data (epochs, blocks), enabling time-based analysis and historical event tracking.

> **Can be JOINed with** `STAKE` (to enrich historical data with epoch and slot context)
> {% endhint %}

<table data-full-width="false"><thead><tr><th width="161">Column</th><th width="167.25">Type</th><th>Description</th></tr></thead><tbody><tr><td>BLOCK_FROM</td><td>Number</td><td>Starting block number</td></tr><tr><td>BLOCK_TO</td><td>Number</td><td>Ending block number</td></tr><tr><td>DIM_NAME</td><td>Varchar</td><td>Dimension name in this case is the constant 'epoch'</td></tr><tr><td>DIM_NUMBER</td><td>Number</td><td>Epoch number</td></tr><tr><td>TIME_FROM</td><td>Timestamp_NTZ</td><td>Start timestamp</td></tr><tr><td>TIME_TO</td><td>Timestamp_NTZ</td><td>End timestamp</td></tr></tbody></table>

</details>

<details>

<summary>STAKE</summary>

{% hint style="success" %}

#### Business value and potential connections

Tracks staking activity, including delegations and undelegations, allowing analysis of validator participation and delegation trends. Helps monitor capital flows in staking ecosystems.

> **Can be JOINed with** `VALIDATORS` (to get validator details) and `APR` (to compare staking activity with APR and rewards).
> {% endhint %}

<table data-full-width="false"><thead><tr><th width="164.75">Column</th><th width="157.5">Type</th><th>Description</th></tr></thead><tbody><tr><td>AMOUNT</td><td>Number</td><td>The amount of tokens staked (positive) or unstaked (negative), measured in lamports</td></tr><tr><td>BLOCK</td><td>Number</td><td>The Solana block number where the transaction was recorded</td></tr><tr><td>CREATED_AT</td><td>Timestamp_NTZ</td><td>Timestamp when the record was created</td></tr><tr><td>CURRENCY</td><td>Varchar</td><td>The constant 'lamport' in this case</td></tr><tr><td>DELEGATOR</td><td>Varchar</td><td>The public key of the delegator account performing the staking action</td></tr><tr><td>DIM_NAME</td><td>Varchar</td><td>The name of the dimension</td></tr><tr><td>DIM_NUMBER</td><td>Number</td><td>The numeric identifier of the dimension</td></tr><tr><td>HASH</td><td>Varchar</td><td>Unique transaction signature</td></tr><tr><td>INSERTED_TIME</td><td>Timestamp_NTZ</td><td>The UTC timestamp at which the row was inserted into the table</td></tr><tr><td>MODIFIED_TIME</td><td>Timestamp_NTZ</td><td>The UTC timestamp at which the row was last modified</td></tr><tr><td>TYPE</td><td>Varchar</td><td>Type of transaction</td></tr><tr><td>VALIDATOR</td><td>Varchar</td><td>Validator's vote account</td></tr></tbody></table>

</details>

<details>

<summary>VALIDATORS</summary>

{% hint style="success" %}

#### Business value and potential connections

Stores validator metadata including public keys, names, commission rates, and status. Enables validator-level analysis and performance monitoring.

> **Can be JOINed with** `STAKE` (to analyze validator participation), `APR` (to assess validator performance), and `VALIDATOR_REWARDS` (to evaluate validator earnings).
> {% endhint %}

<table data-full-width="false"><thead><tr><th width="217.25">Column</th><th width="153.75">Type</th><th>Description</th></tr></thead><tbody><tr><td>COMMISSION</td><td>Number</td><td>The commission percentage charged by the validator on staking rewards</td></tr><tr><td>CREATED_AT</td><td>Timestamp_NTZ</td><td>The timestamp when the validator record was created</td></tr><tr><td>IS_ACTIVE</td><td>Boolean</td><td>Boolean flag indicating if the validator is currently active on the network</td></tr><tr><td>JITO</td><td>Boolean</td><td>Boolean flag indicating if the validator is participating in the Jito program</td></tr><tr><td>KEYBASE_ID</td><td>Varchar</td><td>The associated Keybase ID of the validator, used for identity verification</td></tr><tr><td>NAME</td><td>Varchar</td><td>The display name or label of the validator</td></tr><tr><td>UPDATED_AT</td><td>Timestamp_NTZ</td><td>The timestamp when the validator record was last updated</td></tr><tr><td>VALIDATOR</td><td>Varchar</td><td>Validator's Vote account</td></tr><tr><td>VALIDATOR_IDENTITY</td><td>Varchar</td><td>Validator's Identity address</td></tr><tr><td>WWW_URL</td><td>Number</td><td>The validator's website URL providing additional information or contact</td></tr></tbody></table>

</details>

<details>

<summary>VALIDATOR_REWARDS</summary>

{% hint style="success" %}

#### Business value and potential connections

Provides insights into validator rewards at the consensus layer, useful for tracking staking profitability and historical earnings.

> **Can be JOINed with** `VALIDATORS` (to get validator details) for validator-level reward analysis.
> {% endhint %}

<table data-full-width="true"><thead><tr><th width="203.5">Column</th><th width="175.25">Type</th><th>Description</th></tr></thead><tbody><tr><td>AMOUNT</td><td>Number</td><td>The amount of reward received, measured in lamports</td></tr><tr><td>BLOCK</td><td>Number</td><td>The block number where the reward transaction was recorded</td></tr><tr><td>CREATED_AT</td><td>Timestamp_NTZ</td><td>The timestamp when the reward event occurred on-chain</td></tr><tr><td>CURRENCY</td><td>Varchar</td><td>The constant 'lamport' in this case</td></tr><tr><td>DIM_NAME</td><td>Varchar</td><td>The name of the dimension</td></tr><tr><td>DIM_NUMBER</td><td>Number</td><td>The numeric identifier of the dimension</td></tr><tr><td>HASH</td><td>Varchar</td><td>Unique transaction signature</td></tr><tr><td>INSERTED_TIME</td><td>Timestamp_NTZ</td><td>The UTC timestamp at which the row was inserted into the table</td></tr><tr><td>MODIFIED_TIME</td><td>Timestamp_NTZ</td><td>The UTC timestamp at which the row was last modified</td></tr><tr><td>TYPE</td><td>Varchar</td><td>The source or type of the reward</td></tr><tr><td>VALIDATOR</td><td>Varchar</td><td>Validator's Vote account</td></tr><tr><td>VALIDATOR_IDENTITY</td><td>Varchar</td><td>Validator's Identity address</td></tr></tbody></table>

</details>

***

## Query examples

{% tabs %}
{% tab title="Delegator staking rewards" %}

```sql
select * from delegator_rewards
where delegator='Cw1bUx1gFSaWkobEZU4hNbvyBVrHDjpT7Ku3rRMYeGUx'
```

{% endtab %}

{% tab title="Validator APR" %}

```sql
select 
    dim_number as epoch,
    APR*100
from apr
where validator='9QU2QSxhb24FUX3Tu2FpczXjpK3VYrvRudywSZaM29mF'
order by epoch desc 
```

{% endtab %}

{% tab title="Validator rewards" %}

```sql
select 
    type,
    dim_number as epoch,
    sum(amount) as reward_amount
from validator_rewards
where validator='9QU2QSxhb24FUX3Tu2FpczXjpK3VYrvRudywSZaM29mF'
group by type, epoch
```

{% endtab %}
{% endtabs %}

***

## FAQ

<table data-header-hidden><thead><tr><th width="189"></th><th></th><th data-hidden></th></tr></thead><tbody><tr><td><strong>1. What does this dataset cover?</strong></td><td>This dataset provides detailed insights into Solana staking activity, including validator rewards, staking and unstaking behavior, delegator performance, and validator metadata. It enables users to analyze validator profitability, monitor staking flows, and evaluate validator performance in Solana’s proof-of-stake ecosystem.</td><td></td></tr><tr><td><strong>2. How can this data benefit staking providers and investors?</strong></td><td><ul><li><strong>Staking providers</strong> can track validator earnings, commission settings, and delegator engagement to optimize their operations and transparency.</li><li><strong>Investors</strong> can evaluate staking opportunities, analyze historical performance, and identify high-yield or consistent validators for delegation.</li></ul></td><td></td></tr><tr><td><p></p><p><strong>3. How can this dataset help detect validator risks?</strong></p></td><td>By analyzing staking and unstaking patterns (<code>STAKE</code>), authority changes (<code>AUTHORITY_STAKE</code>), and reward fluctuations (<code>VALIDATOR_REWARDS</code> and <code>APR</code>), users can identify validators with unstable performance, potential slashing risk, or sudden delegator churn.</td><td></td></tr><tr><td>4<strong>. Can I track individual validator performance?</strong></td><td><p>Yes. The <code>VALIDATORS</code> table can be JOINed with:</p><ul><li><code>VALIDATOR_REWARDS</code> – to review rewards over time</li><li><code>APR</code> – to monitor yield and return trends</li><li><code>STAKE</code> – to assess staking inflows and outflows</li></ul></td><td></td></tr><tr><td>5<strong>. How does the historical blockchain data help?</strong></td><td>The <code>STAKE</code> table provides block, event, and epoch-based tracking of staking actions, helping correlate staking movements with validator performance. The <code>DIMENSIONS</code> table adds temporal context (epoch/slot/block) to enable historical trend analysis and support time-based grouping across datasets.</td><td></td></tr><tr><td>6<strong>. How frequently is the data updated?</strong></td><td>The dataset updates <strong>daily at 12:01 UTC</strong>, ensuring accurate and timely access to Ethereum staking metrics.</td><td></td></tr></tbody></table>

***

## Links

<table data-view="cards"><thead><tr><th></th><th data-hidden data-card-cover data-type="files"></th></tr></thead><tbody><tr><td><a href="https://everstake.one/staking/solana">Stake with Everstake</a></td><td><a href="https://1249209355-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsyXGefmWNIENxOOHmKgY%2Fuploads%2FyWN8N0revZW0x4Gnn87T%2F%D0%B7%D0%BE%D0%B1%D1%80%D0%B0%D0%B6%D0%B5%D0%BD%D0%BD%D1%8F_2025-03-21_001348788.png?alt=media&amp;token=3fae7594-dfda-4be4-9095-6e4367735a84">зображення_2025-03-21_001348788.png</a></td></tr><tr><td><a href="https://app.powerbi.com/view?r=eyJrIjoiNzBhZTk0MmUtMDUxMy00YjlmLWE2MzctODM2MjdlODcxOTUxIiwidCI6IjFmMjc3YTcyLTM5OTItNDM4NC1iYTIyLWVmN2JlZTdmNzJiZCIsImMiOjl9">Everstake SOL dashboard on PowerBI</a></td><td><a href="https://1249209355-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsyXGefmWNIENxOOHmKgY%2Fuploads%2FyWN8N0revZW0x4Gnn87T%2F%D0%B7%D0%BE%D0%B1%D1%80%D0%B0%D0%B6%D0%B5%D0%BD%D0%BD%D1%8F_2025-03-21_001348788.png?alt=media&amp;token=3fae7594-dfda-4be4-9095-6e4367735a84">зображення_2025-03-21_001348788.png</a></td></tr></tbody></table>


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:

```
GET https://docs.everstake.com/integrations/everstake-products/data-product-deprecated/solana.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.