Name: XRP Ledger Blockchain
Creator: Baselight
License: https://creativecommons.org/licenses/by/4.0/

About this Dataset

XRP Ledger Blockchain

Raw historical ledger and transaction data directly from XRP Ledger (XRPL) nodes.

ledgers table: one row per validated ledger, including index, hash, close time, parent linkage and aggregate totals.
transactions table: one row per validated transaction, including basic transaction fields, payment/offer parameters and raw metadata needed for downstream decoding and aggregation.

Recommendation for most use cases:

For balances, token movements, holders and higher-level analytics, prefer the curated dataset @xrpscan.xrp_ledger, which normalizes and enriches XRPL data for analysis.
This @blt.xrp_ledger dataset should be used when you specifically need low-level, raw on-chain node responses (ledger headers and transactions) for debugging, reconciliation or building your own XRPL transformations.

Tables

Ledgers (Raw)

@blt.xrp_ledger.ledgers

98.49 MB
306,000 rows
15 columns

CREATE TABLE ledgers (
  "account_hash" VARCHAR,
  "close_flags" BIGINT,
  "close_time" BIGINT,
  "close_time_human" VARCHAR,
  "close_time_resolution" BIGINT,
  "closed" BOOLEAN,
  "ledger_hash" VARCHAR,
  "ledger_index" BIGINT,
  "parent_close_time" BIGINT,
  "parent_hash" VARCHAR,
  "total_coins" VARCHAR,
  "transaction_hash" VARCHAR,
  "ledger_close_time" TIMESTAMP,
  "status" VARCHAR,
  "validated" BOOLEAN
);

Transactions (Raw)

@blt.xrp_ledger.transactions

27.55 GB
27,343,108 rows
32 columns

CREATE TABLE transactions (
  "ledger_index" BIGINT,
  "ledger_close_time" TIMESTAMP,
  "tx_hash" VARCHAR,
  "account" VARCHAR,
  "transaction_type" VARCHAR,
  "fee" VARCHAR,
  "sequence" BIGINT,
  "offer_sequence" DOUBLE,
  "flags" DOUBLE,
  "last_ledger_sequence" DOUBLE,
  "source_tag" DOUBLE,
  "signing_pub_key" VARCHAR,
  "ticket_sequence" DOUBLE,
  "txn_signature" VARCHAR,
  "expiration" DOUBLE,
  "destination" VARCHAR,
  "destination_tag" DOUBLE,
  "amount" VARCHAR,
  "amount2" VARCHAR,
  "asset" VARCHAR,
  "asset2" VARCHAR,
  "send_max" VARCHAR,
  "deliver_min" VARCHAR,
  "deliver_max" VARCHAR,
  "taker_gets" VARCHAR,
  "taker_pays" VARCHAR,
  "memos" VARCHAR,
  "signers" VARCHAR,
  "limit_amount" VARCHAR,
  "validated" BOOLEAN,
  "owner_funds" VARCHAR,
  "metadata" VARCHAR
);