Name: XRP Ledger Data
Creator: XrpScan
License: https://creativecommons.org/licenses/by/4.0/

About this Dataset

XRP Ledger Data

The XRP Ledger dataset provides comprehensive data from the XRP Ledger (XRPL), one of the most efficient and sustainable blockchain networks for payments and tokenization.

This dataset captures real-time and historical information across eight key areas of the XRPL ecosystem:

Automated Market Makers (AMMs): Complete liquidity pool data including asset pairs, LP tokens, trading fees, auction slots, and governance voting mechanisms that enable decentralized trading without traditional order books.
Tokens and Currencies: Detailed metadata for all issued tokens beyond native XRP, including supply metrics, holder statistics, trust levels, issuer information, and trading volumes with flattened metadata for enhanced queryability.
Network Metrics: Daily aggregated performance data including transaction counts by type and result code, ledger statistics, account creation rates, and network health indicators that provide insights into XRPL usage patterns.
Network Nodes: Infrastructure data about peer nodes participating in the network, including their software versions, connectivity details, and operational status for network topology analysis.
Validators: Comprehensive validator information including consensus participation metrics, identity keys, performance data, and voting records essential for understanding network security and decentralization.
Child Accounts: Information about accounts created through Payment transactions, including parent-child relationships, initial funding amounts, and creation timestamps for analyzing account growth patterns.
Well-Known Account Names: Registry of verified and notable accounts with their associated metadata, including exchanges, services, and organizations, useful for identity verification and compliance monitoring.
Account Balances: Current XRP balance information across accounts, providing insights into wealth distribution, liquidity patterns, and network economics at the account level.

The XRP Ledger supports advanced features like native DEX functionality, payment channels, escrow, multi-signing, and efficient consensus mechanisms. All nested JSON structures are flattened into relational columns for optimal analytical performance.

This dataset is particularly valuable for:

DeFi analytics and AMM liquidity analysis
Token ecosystem research and compliance monitoring
Network health analysis and validator performance studies
Trading strategy development and market microstructure research
Academic blockchain research and infrastructure analysis
Account relationship mapping and wealth distribution analysis
Fraud prevention and compliance monitoring through named account identification

Tables

Child Accounts Created By Parent Accounts

@xrpscan.xrp_ledger.accounts

988.8 MB
1,000 rows
6 columns

CREATE TABLE accounts (
  "account" VARCHAR,
  "inception" TIMESTAMP,
  "initial_balance" DOUBLE,
  "ledger_index" BIGINT,
  "parent" VARCHAR,
  "tx_hash" VARCHAR
);

Automated Market Makers (AMMs)

@xrpscan.xrp_ledger.amms

11.95 MB
27,635 rows
32 columns

CREATE TABLE amms (
  "account" VARCHAR,
  "balance" DOUBLE,
  "flags" BIGINT,
  "ledgerentrytype" VARCHAR,
  "ownernode" BIGINT,
  "previoustxnid" VARCHAR,
  "previoustxnlgrseq" DOUBLE,
  "index" VARCHAR,
  "updated_at" TIMESTAMP,
  "tradingfee" DOUBLE,
  "asset_currency" VARCHAR,
  "asset_issuer" VARCHAR,
  "asset2_currency" VARCHAR,
  "asset2_issuer" VARCHAR,
  "lp_token_currency" VARCHAR,
  "lp_token_issuer" VARCHAR,
  "lp_token_value" DOUBLE,
  "auction_slot_account" VARCHAR,
  "auction_slot_expiration" BIGINT,
  "auction_slot_price_currency" VARCHAR,
  "auction_slot_price_issuer" VARCHAR,
  "auction_slot_price_value" DOUBLE,
  "auction_slot_discountedfee" DOUBLE,
  "auction_slot_authaccounts" VARCHAR,
  "vote_slots_count" BIGINT,
  "vote_slots_total_weight" BIGINT,
  "vote_slots_avg_trading_fee" DOUBLE,
  "vote_slots_min_trading_fee" DOUBLE,
  "vote_slots_max_trading_fee" BIGINT,
  "vote_slots_dominant_account" VARCHAR,
  "vote_slots_dominant_fee" DOUBLE,
  "vote_slots_dominant_weight" BIGINT
);

Account Balance Information

@xrpscan.xrp_ledger.balances

341.78 MB
7,253,391 rows
4 columns

CREATE TABLE balances (
  "account" VARCHAR,
  "balance" DOUBLE,
  "supply" DOUBLE,
  "escrow" DOUBLE
);

Daily Network Performance Metrics

@xrpscan.xrp_ledger.metrics

803.65 kB
4,671 rows
113 columns

CREATE TABLE metrics (
  "date" TIMESTAMP,
  "metric_accounts_created" BIGINT,
  "metric_ledger_count" BIGINT,
  "metric_ledger_interval" DOUBLE,
  "metric_payments_count" BIGINT,
  "metric_transaction_count" BIGINT,
  "metric_tx_per_ledger" DOUBLE,
  "metric_exchanges_count" DOUBLE,
  "metric_transaction_success_count" DOUBLE,
  "metric_payments_volume" DOUBLE,
  "metric_fee_total" DOUBLE,
  "metric_active_accounts" DOUBLE,
  "result_tecno_dst_insuf_xrp" DOUBLE,
  "result_tecpath_dry" DOUBLE,
  "result_tessuccess" BIGINT,
  "result_tecunfunded" DOUBLE,
  "result_tecno_dst" DOUBLE,
  "result_tecinsuf_reserve_line" DOUBLE,
  "result_tecno_line_insuf_reserve" DOUBLE,
  "result_tecpath_partial" DOUBLE,
  "result_tecinsuf_reserve_offer" DOUBLE,
  "result_tecno_line_redundant" DOUBLE,
  "result_tecunfunded_offer" DOUBLE,
  "result_tecunfunded_payment" DOUBLE,
  "result_tecfailed_processing" DOUBLE,
  "result_tecowners" DOUBLE,
  "result_tecno_issuer" DOUBLE,
  "result_tecno_line" DOUBLE,
  "result_tecno_auth" DOUBLE,
  "result_tecno_regular_key" DOUBLE,
  "result_tecfrozen" DOUBLE,
  "result_tecdst_tag_needed" DOUBLE,
  "result_tecinternal" DOUBLE,
  "result_tecneed_master_key" DOUBLE,
  "result_tecoversize" DOUBLE,
  "result_tecno_alternative_key" DOUBLE,
  "result_tecinsufficient_reserve" DOUBLE,
  "result_tecno_permission" DOUBLE,
  "result_teccryptocondition_error" DOUBLE,
  "result_tecno_target" DOUBLE,
  "result_tecno_entry" DOUBLE,
  "result_tecexpired" DOUBLE,
  "result_teckilled" DOUBLE,
  "result_tecinsuff_fee" DOUBLE,
  "result_techas_obligations" DOUBLE,
  "result_tectoo_soon" DOUBLE,
  "result_tecdir_full" DOUBLE,
  "result_tecinsufficient_funds" DOUBLE,
  "result_tecobject_not_found" DOUBLE,
  "result_teccant_accept_own_offer" DOUBLE,
  "result_tecoffer_type_mismatch" DOUBLE,
  "result_tecinsufficient_payment" DOUBLE,
  "result_tecnftoken_offer_type_mismatch" DOUBLE,
  "result_teccant_accept_own_nftoken_offer" DOUBLE,
  "result_tecbuy_sell_mismatch" DOUBLE,
  "result_tecnftoken_buy_sell_mismatch" DOUBLE,
  "result_tecduplicate" DOUBLE,
  "result_tecamm_failed" DOUBLE,
  "result_tecunfunded_amm" DOUBLE,
  "result_tecamm_invalid_tokens" DOUBLE,
  "result_tecamm_balance" DOUBLE,
  "result_tecamm_account" DOUBLE,
  "result_tecarray_too_large" DOUBLE,
  "result_tecamm_not_empty" DOUBLE,
  "result_tecinvalid_update_time" DOUBLE,
  "result_tecinvariant_failed" DOUBLE,
  "type_offercreate" DOUBLE,
  "type_payment" BIGINT,
  "type_trustset" BIGINT,
  "type_offercancel" DOUBLE,
  "type_accountset" DOUBLE,
  "type_setregularkey" DOUBLE,
  "type_setfee" DOUBLE,
  "type_enableamendment" DOUBLE,
  "type_signerlistset" DOUBLE,
  "type_escrowcreate" DOUBLE,
  "type_paymentchannelcreate" DOUBLE,
  "type_escrowcancel" DOUBLE,
  "type_escrowfinish" DOUBLE,
  "type_paymentchannelclaim" DOUBLE,
  "type_paymentchannelfund" DOUBLE,
  "type_depositpreauth" DOUBLE,
  "type_accountdelete" DOUBLE,
  "type_checkcreate" DOUBLE,
  "type_checkcancel" DOUBLE,
  "type_checkcash" DOUBLE,
  "type_ticketcreate" DOUBLE,
  "type_unlmodify" DOUBLE,
  "type_nftokenacceptoffer" DOUBLE,
  "type_nftokenburn" DOUBLE,
  "type_nftokencanceloffer" DOUBLE,
  "type_nftokencreateoffer" DOUBLE,
  "type_nftokenmint" DOUBLE,
  "type_clawback" DOUBLE,
  "type_ammdeposit" DOUBLE,
  "type_ammvote" DOUBLE,
  "type_ammcreate" DOUBLE,
  "type_ammwithdraw" DOUBLE,
  "type_ammbid" DOUBLE,
  "type_didset" DOUBLE
);

Network Nodes And Peers

@xrpscan.xrp_ledger.nodes

5.21 MB
66,172 rows
11 columns

CREATE TABLE nodes (
  "public_key" VARCHAR,
  "asn" VARCHAR,
  "complete_ledgers" VARCHAR,
  "ip" VARCHAR,
  "last_seen" TIMESTAMP,
  "last_seen_unix" DOUBLE,
  "server_version" VARCHAR,
  "version" VARCHAR,
  "uptime" DOUBLE,
  "port" DOUBLE,
  "country" VARCHAR
);

Issued Tokens And Currencies

@xrpscan.xrp_ledger.tokens

24.07 MB
63,287 rows
46 columns

CREATE TABLE tokens (
  "id" VARCHAR,
  "amms" BIGINT,
  "code" VARCHAR,
  "createdat" TIMESTAMP,
  "currency" VARCHAR,
  "holders" BIGINT,
  "issuer" VARCHAR,
  "token" VARCHAR,
  "trustlines" BIGINT,
  "updatedat" TIMESTAMP,
  "emailhash" VARCHAR,
  "blackholed" VARCHAR,
  "marketcap" DOUBLE,
  "price" DOUBLE,
  "supply" DOUBLE,
  "disabled" VARCHAR,
  "score" DOUBLE,
  "tomldata" VARCHAR,
  "ammid" VARCHAR,
  "meta_issuer_weblinks_count" BIGINT,
  "meta_issuer_primary_website" VARCHAR,
  "meta_token_id" VARCHAR  -- Meta Token, Id,
  "meta_token_desc" VARCHAR,
  "meta_token_icon" VARCHAR,
  "meta_token_name" VARCHAR,
  "meta_token_trust_level" DOUBLE,
  "meta_token_weblinks" VARCHAR,
  "meta_token_asset_class" VARCHAR,
  "meta_token_asset_subclass" VARCHAR,
  "meta_issuer_id" VARCHAR  -- Meta Issuer, Id,
  "meta_issuer_icon" VARCHAR,
  "meta_issuer_kyc" VARCHAR,
  "meta_issuer_name" VARCHAR,
  "meta_issuer_trust_level" DOUBLE,
  "metrics_id" VARCHAR  -- Metrics, Id,
  "metrics_trustlines" DOUBLE,
  "metrics_holders" DOUBLE,
  "metrics_supply" VARCHAR,
  "metrics_marketcap" VARCHAR,
  "metrics_price" VARCHAR,
  "metrics_volume_24h" VARCHAR,
  "metrics_volume_7d" VARCHAR,
  "metrics_exchanges_24h" DOUBLE,
  "metrics_exchanges_7d" DOUBLE,
  "metrics_takers_24h" DOUBLE,
  "metrics_takers_7d" DOUBLE
);

Network Validators

@xrpscan.xrp_ledger.validators

612.51 kB
1,405 rows
20 columns

CREATE TABLE validators (
  "master_key" VARCHAR,
  "chain" VARCHAR,
  "ephemeral_key" VARCHAR,
  "last_seen" TIMESTAMP,
  "ledger_index" BIGINT,
  "server_version" VARCHAR,
  "domain" VARCHAR,
  "domain_legacy" VARCHAR,
  "meta_manifest" VARCHAR,
  "meta_verified" VARCHAR,
  "meta_verification_message" VARCHAR,
  "votes_amendments_count" BIGINT,
  "votes_amendments_list" VARCHAR,
  "votes_reserve_base" DOUBLE,
  "votes_reserve_inc" DOUBLE,
  "votes_base_fee" DOUBLE,
  "votes_load_fee" DOUBLE,
  "unl_count" BIGINT,
  "unl_member" BOOLEAN,
  "unl_names" VARCHAR
);