SolanaAccount Activity

Column Descriptions

for solana.account_activity

21 rows

Name	Type	Description
block_hash	TEXT
block_date	DATE
post_balance	NUMBER
post_token_balance	FLOAT
writable	BOOLEAN
address	TEXT
token_mint_address	TEXT
signed	BOOLEAN
block_height	NUMBER
tx_id	TEXT
block_parent_slot	NUMBER
tx_index	NUMBER
block_time	TIMESTAMP_NTZ
balance_change	NUMBER
pre_token_balance	FLOAT
block_previous_block_hash	TEXT
token_balance_change	FLOAT
pre_balance	NUMBER
tx_success	BOOLEAN
token_balance_owner	TEXT
block_slot	NUMBER

Sample Queries

Top 10 Accounts with Largest Balance Changes

Identifies the top 10 accounts with the largest absolute changes in their lamport balances.

SELECT
  address,
  SUM(ABS(balance_change)) AS total_balance_change
FROM
  solana.account_activity
GROUP BY
  address
ORDER BY
  total_balance_change DESC
LIMIT
  10;

Average Token Balance Change for a Specific Token

Calculates the average token balance change for a specific token mint address (replace 'TokenMintAddress' with the actual token mint address).

SELECT
  AVG(token_balance_change) AS avg_token_balance_change
FROM
  solana.account_activity
WHERE
  token_mint_address = 'TokenMintAddress';

Accounts with Activity on a Specific Date

Retrieves all unique accounts that had any activity on a specific date.

SELECT DISTINCT
  address
FROM
  solana.account_activity
WHERE
  block_date = '2024-10-30';