🗃️Data Catalog

Nansen Query is a set of standardized data tables meant to cover the entire blockchain ecosystem: including activities of the blockchain itself, aggregated blockchain usage metrics, and event level data for specific projects.

Nansen Query covers multiple blockchains and employs a standardized data schema across all chains. This makes it extremely easy to use without having to deal with the idiosyncrasies of any particular chain or project.

Dataset Structure & Naming Convention

Nansen Query contains the following types of data:

  • Chains: data from the blockchain itself, such as logs, blocks, transactions, and token transfers

    • These datasets have the prefix "raw_" followed by the name of the chain

    • Example: raw_ethereum contains the chain data for Ethereum, raw_ethereum.transactions are the transactions dataset for Ethereum

    • raw_ethereum.token_transfers contains all the ERC20 token transfers for Ethereum

  • Tokens: Token datasets mainly include pricing information and are organized by chain. If the data is sourced from a third party, it will be annotated.

    • current_token_prices contains the latest price for a token according to multiple sources. This table can be used for any dashboard which require the latest price

    • daily_token_prices contains the historical TWAP price for each token according to multiple sources

    • hourly_token_prices contains hourly TWAP prices for tokens according to Coinpaprika

  • NFTs: Transaction and balance data related to NFT and NFT marketplaces

    • These datasets are organized by the chain where the NFT are deployed

    • These datasets have the prefix nft_ followed by the name of the chain

    • Example: nft_ethereum.nft_balances contains all the NFT balances on the Ethereum chain

  • Dex Trades: Transaction level information for all Dex trades for all wallets

    • Data for all tokens traded on covered Dexes

    • May not cover custom AMMs

  • Aggregates: Aggregated statistics about wallets, tokens, and entities

    • User statistics and characteristics to quickly find interesting wallets

    • address_stats table contains a list of all Ethereum addresses behaviorial parameters that can be used for user segmentation and research

  • Snapshot: Votes and proposals from snapshot.org

  • Market Indicators: Specialized data used as trading signals

Last updated