All / ERC20 Projects

Get up-to-the-moment data for all projects in the Santiment database, or just the ERC20 list. Metrics include Price, Volume, Market Cap, ETH Balance, and ETH Spent. The return also lets you know the so called 'slug' of each project, which is used in most other queries below. The slug used in the examples is "santiment".

=SAN_ALL_PROJECTS()
=SAN_ERC20_PROJECTS()

Project Fundamentals

Get basic information for a specific project, including current price in BTC and USD, Volume, Marketcap, etc.

=SAN_PROJECT_FUNDAMENTALS("santiment")

Prices: Open, High, Low, Close

Get daily market price points for an asset over a given time period.

=SAN_OHLC("santiment", DATE(2019,5,1), DATE(2019,5,31))

Prices: Latest

Get the latest known price for an asset in a single cell.

=SAN_LATEST_PRICE("santiment", "USD")

Prices: Average

Get the average daily price for an asset over a given time period.

=SAN_PRICES("santiment", DATE(2019,5,1), DATE(2019,5,31))

Prices: Daily Close

Get the closing price for an asset over a given time period.

=SAN_DAILY_CLOSING_PRICE("santiment", DATE(2019,6,1))

Prices: Percentage Change

Get the percentage of price change for an asset between to given dates.

=SAN_PRICE_PERCENT_CHANGE("santiment", date(2019,5,1), date(2019,5,31))

All / ERC20 Projects

Get up-to-the-moment data for all projects in the Santiment database, or just the ERC20 list. Metrics include Price, Volume, Market Cap, ETH Balance, and ETH Spent.

=SAN_ALL_PROJECTS()
=SAN_ERC20_PROJECTS()

Social Volume

Returns the number of times an asset was mentioned in social media each day. You can specify either Telegram, Reddit, or an aggregation of professional trader chats.

=SAN_SOCIAL_VOLUME("santiment", DATE(2019,5,1), DATE(2019,5,31), "PROFESSIONAL_TRADERS_CHAT_OVERVIEW")

Active Addresses

Gets the number of addresses active on a network during each day for a given time period.

=SAN_ACTIVE_ADDRESSES("santiment", DATE(2019,5,1), DATE(2019,5,31))

Active Deposits

Returns the number of transactions that went into tracked deposit addresses of exchanges on a given day, over the chosen period of time.

=SAN_ACTIVE_DEPOSITS("santiment", DATE(2019,5,1), DATE(2019,5,31))

Price/Volume Difference

Returns any events where price and volume movement diverged (price increased while volume decreased). Currency can be specified in USD or BTC.

=SAN_PRICE_VOLUME_DIFF("USD", "santiment", DATE(2019,5,1), DATE(2019,5,31)

Transaction Volume

Gets the number of tokens that have transacted across the network each day, for a given timeframe.

=SAN_TRANSACTION_VOLUME("santiment", DATE(2019,5,1), DATE(2019,5,31))

Network Growth

Returns the number of newly created addresses (they received a token for the first time) each day for a given time period.

=SAN_NETWORK_GROWTH("santiment", DATE(2019,5,1), DATE(2019,5,31))

Developer Activity

Gets the number of relevant Github events of a project for each day in a given time period, excluding certain events e.g. forked commits.

=SAN_DEV_ACTIVITY("santiment", DATE(2019,5,1), DATE(2019,5,31))

Realized Value

Returns the summed price of all tokens on the network, estimated by the historical price at the moment they were last sent, respectively, in USD.

=SAN_REALIZED_VALUE("santiment", DATE(2019,5,1), DATE(2019,5,31))

MVRV Ratio

Returns the daily ratio of market value to realized value over a given time period.

=SAN_MVRV_RATIO("santiment", DATE(2019,5,1), DATE(2019,5,31))

Token Age Consumed

Gets the product of the total amount of tokens sent on a certain day and the time they were not moved prior to this event, measured in blocks, over a given time period.

=SAN_TOKEN_AGE_CONSUMED("santiment", DATE(2019,5,1), DATE(2019,5,31))

Exchange Funds Flow

Returns the result of the amount of tokens that were deposited to exchanges minus the number of tokens that were withdrawn, for each day over the specified time period.

=SAN_EXCHANGE_FUNDS_FLOW("santiment", DATE(2019,5,1), DATE(2019,5,31))

Token Circulation

Gets the total amount of tokens that have been sent at least once during each day for a given time period.

=SAN_TOKEN_CIRCULATION("santiment", DATE(2019,5,1), DATE(2019,5,31))

NVT Ratio

The first return is the market cap of the asset on the given day divided by the transaction volume of that day. The second return uses the token circulation instead of transaction volume.

=SAN_NVT_RATIO("santiment", DATE(2019,5,1), DATE(2019,5,31))

ETH Mining Pools Distribution

Returns three values, the part of miners (return is between 0 and 1) that use the Top3, Top10 or other mining pools. 

=SAN_MINING_POOLS_DISTRIBUTION("ethereum", DATE(2019,5,1), DATE(2019,5,31))

ETH Gas used

Returns the amount of gas used across the whole Ethereum network for each day.

=SAN_GAS_USED("ethereum", DATE(2019,5,1), DATE(2019,5,31))

Did this answer your question?