XRP Ledger Data by XrpScan | Crypto and Blockchain

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

Automated Market Makers (AMMs)

@xrpscan.xrp_ledger.amms

10.29 MB
24730 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
);

Issued Tokens And Currencies

@xrpscan.xrp_ledger.tokens

18.74 MB
57854 rows
44 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_icon" VARCHAR,
  "meta_token_name" VARCHAR,
  "meta_token_trust_level" DOUBLE,
  "meta_token_weblinks" VARCHAR,
  "meta_token_asset_class" VARCHAR,
  "meta_issuer_id" VARCHAR,
  "meta_issuer_icon" VARCHAR,
  "meta_issuer_kyc" VARCHAR,
  "meta_issuer_name" VARCHAR,
  "meta_issuer_trust_level" DOUBLE,
  "metrics_id" VARCHAR,
  "metrics_trustlines" DOUBLE,
  "metrics_holders" DOUBLE,
  "metrics_supply" VARCHAR,
  "metrics_marketcap" VARCHAR,
  "metrics_price" VARCHAR,
  "metrics_volume_24h" DOUBLE,
  "metrics_volume_7d" DOUBLE,
  "metrics_exchanges_24h" DOUBLE,
  "metrics_exchanges_7d" DOUBLE,
  "metrics_takers_24h" DOUBLE,
  "metrics_takers_7d" DOUBLE
);

Daily Network Performance Metrics

@xrpscan.xrp_ledger.metrics

751.67 KB
4569 rows
106 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,
  "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,
  "type_oracleset" DOUBLE
);

Network Nodes And Peers

@xrpscan.xrp_ledger.nodes

4.79 MB
64191 rows
10 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
);

Network Validators

@xrpscan.xrp_ledger.validators

578.85 KB
1351 rows
20 columns


CREATE TABLE validators (
  "master_key" VARCHAR,
  "chain" VARCHAR,
  "ephemeral_key" VARCHAR,
  "last_seen" TIMESTAMP,
  "ledger_index" BIGINT,
  "server_version" DOUBLE,
  "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
);

Child Accounts Created By Parent Accounts

@xrpscan.xrp_ledger.accounts

883.32 MB
1000 rows
6 columns


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

Account Balance Information

@xrpscan.xrp_ledger.balances

306.61 MB
6801299 rows
4 columns


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