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")
Get daily market price points for an asset over a given time period.
=SAN_OHLC("santiment", DATE(2019,5,1), DATE(2019,5,31))
Get the latest known price for an asset in a single cell.
=SAN_LATEST_PRICE("santiment", "USD")
Get the average daily price for an asset over a given time period.
=SAN_PRICES("santiment", DATE(2019,5,1), DATE(2019,5,31))
Get the closing price for an asset over a given time period.
=SAN_DAILY_CLOSING_PRICE("santiment", DATE(2019,6,1))
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))
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()
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")
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))
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))
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)
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))