Top Ledger
WebsiteTwitter
  • πŸ‘‹Welcome to Top Ledger
  • DATA TABLES
    • πŸ“ŠSolana Data
      • Blocks
      • Transactions
      • Account activity
    • πŸ“ŠSmart Tables
      • DEX Trades
        • πŸ“ŠDEX ecosystem on Solana
      • NFT Trades
        • πŸ“ŠNFT ecosystem on Solana
      • cNFT Trades
        • πŸ“ŠcNFT ecosystem on Solana
      • Liquid Staking
        • πŸ“ŠLST ecosystem on Solana
    • ➑️Decoded Instructions Data
      • Metaplex
        • Auction House
        • Token Metadata
        • Candy Machine
          • CM V2
          • CM V1
      • Saber
      • Mercurial Finance
      • Sol Splits
      • Stake Pool
      • Hubble
      • Robox Fi
      • Switchboard V2
      • Drift V2
      • Tulip Protocol
      • AllDomains
      • Whirlpool
      • GooseFX
      • Invariant
      • Squads Protocol
      • xNFT Backpack
      • Sharky
      • Frakt
      • Flash
      • Helium
  • USE CASES
    • πŸ“ŠSample Dashboard
  • Developer docs
    • Integrate Topledger dashboards
    • Supported DBs
Powered by GitBook
On this page
  1. DATA TABLES
  2. Solana Data

Account activity

Accounts are similar to files in operating systems such as Linux in that they may hold arbitrary data that persists beyond the lifetime of a program.

tl-solana-merged-data.account_activity

The table contains information from the transactions table catering to account usage. Each row in this table has information about an account's usage in a transaction.

Column Name
Column Type
Description

block_slot

bigint

The slot of the block this transaction was in

block_hash

string

The hash of the block this transaction was in

block_time

timestamp

The timestamp that this account usage occurred

block_date

date

The date this account usage occurred

address

string

The address of the account, also referred to as public key

tx_index

int

The index of this transaction in the block

tx_id

string

The ID of the transaction in which this account usage occurred

tx_success

boolean

The transaction succeeded and was committed

signed

boolean

This account signed this transaction

writeable

boolean

This account was granted read-write access in this transaction

pre_balance

bigint

The balance of this account before the transaction was processed

post_balance

bigint

The balance of this account after the transaction was processed

pre_token_balance

decimal

The token balance before the transaction was processed

post_token_balance

decimal

The token balance after the transaction was processed

balance_change

bigint

The balance change that occurred as part of the transaction

token_balance_change

decimal

The balance change that occurred as part of the transaction

token_mint_address

string

Public key of the token’s mint

PreviousTransactionsNextSmart Tables

Last updated 2 years ago

πŸ“Š