🗃
Data Schema

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_coingecko contains the latest price for a token according to CoinGecko. This table can be used for any dashboard which require the latest price
daily_token_prices_coingecko contains the historical TWAP price for each token according to CoinGecko
hourly_token_prices_coinpaprika 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
Data - Previous
Data Sources
Raw Events (EVM)
Last modified 2mo ago