CryptoQuant User Guide
English
English
  • 🔍What is CryptoQuant
    • Introduction
      • How We Process Data
      • Why Trust CryptoQuant Metrics?
      • Why Market Driven?
    • Background Knowledge
      • What is On-Chain Data?
      • What are Entities?
      • What is a UTxO?
    • Our Product
  • 🎯QuickStart
    • 5 Minute Data Guide
      • 3 Key On-Chain Metrics
      • 3 Key Market Metrics
      • 3 Key Indicators
      • Deriving Insights
    • 5 Minute Feature Guide
      • 1. Charting Overview
      • 2. Set Alerts
      • 3. Dashboards
      • 4. Quicktake
      • 5. Top 15 Pro Charts
        • Miner Selling
        • Whale Accumulation
        • Large OTC deals
        • Buying/Selling Pressure
        • Market Trend
        • Market Sentiment
        • Whale Dumping
  • 📊CryptoQuant Metrics
    • Exchange Flows/Indicators
      • Exchange In/Outflow and Netflow
      • Exchange Reserve
      • Exchange to Exchange
      • Exchange Addresses Count
      • Exchange Transactions Count
      • Fund Flow Ratio
      • Exchange Supply Ratio
      • Exchange Inflow CDD
      • Exchange Inflow - Spent Output Age Bands
      • Exchange Inflow - Spent Output Value Bands
    • Miner Flows/Indicators
      • Miner Outflow
      • Miner to Exchange
      • Miners' Position Index (MPI)
      • Miner Supply Ratio
    • UTxO Data/Indicators
      • Profit and Loss (UTxO)
      • Profit and Loss (Supply)
      • Coin Days Destroyed (CDD)
      • Binary CDD
      • Mean Coin Age (MCA)
      • Sum Coin Age (SCA)
      • Sum Coin Age Distribution (SCA Distribution)
      • Spent Output Profit Ratio (SOPR)
        • aSOPR (Adjusted SOPR)
        • STH-SOPR
        • LTH-SOPR
        • SOPR Ratio (LTH-SOPR/STH-SOPR)
      • Net Unrealized Profit/Loss (NUPL)
      • UTXO Bands (Age)
        • UTXO Age Bands
        • Realized Cap - UTXO Age Bands
        • Realized Price - UTXO Age Bands
        • UTXO Count - Age Bands
        • Spent Output Age Bands
      • UTXO Bands (Value)
        • UTXO Value Bands
        • Realized Cap - UTXO Value Bands USD
        • UTXO Count - Value Bands
        • Spent Output Value Bands
    • Market Data/Indicators
      • Open Interest
      • Funding Rates
      • Estimated Leverage Ratio
      • Taker Buy Sell Volume/Ratio
      • Capitalization models
      • Realized Price
      • Exchange Whale Ratio
      • MVRV (Market Value to Realized Value) Ratio
    • Network Indicators
      • NVT Ratio
      • NVT Golden Cross
      • Puell Multiple
      • Stock to Flow Ratio
      • Stock to Flow Reversion
      • NVM Ratio
    • Stablecoin Exchange Flows/Indicators
      • Stablecoin Network Data
      • Stablecoin Exchange In/Outflow & Netflow
      • Stablecoin Exchange Reserve
      • Stablecoin Exchange Addresses Count
      • Stablecoin Exchange Transactions Count
      • Stablecoins Ratio
      • Stablecoin Supply Ratio (SSR)
    • Fund Data & Premium
      • Grayscale Bitcoin Trust (GBTC)
        • GBTC Digital Asset Holdings
        • GBTC Premium or Discount
      • Grayscale Ethereum Trust (ETHE)
        • ETHE Digital Asset Holdings
        • ETHE Premium or Discount
      • Coinbase Premium
      • Korea Premium Index
      • Bank Supply Ratio
  • 🛠️Web3 Analytics Tool
    • Overview
    • Cohort Data Navigation
    • Query Data Navigation
    • How to Use(Query Tool)
      • 1. DateTime Aggregation
      • 2. Query Block - Metric
      • 3. Query Block - Where
      • 4. Query Block - Group by
      • 5. Query Block - Join
      • 6. Query Block - Order by
      • 7. Save and Run
      • 8. Editing the Result
      • 9. Visualization
        • Table
        • Pie
        • Serial
        • Number
        • Pivot Table
  • 📌Reference
    • FAQ
    • Community Guidelines
    • Community Links
Powered by GitBook
On this page
  • Metric
  • How to use
  • Function

Was this helpful?

  1. Web3 Analytics Tool
  2. How to Use(Query Tool)

2. Query Block - Metric

Previous1. DateTime AggregationNext3. Query Block - Where

Last updated 1 year ago

Was this helpful?

Metric

The "metric" section is an essential component of creating a query and must include at least one metric.

In this section, you determine how to calculate the selected table using specific values and measurements. You can take advantage of different functions and arithmetic operations, or freely input your own custom formula.

How to use

  1. You can add a table to the Metric section by either entering the name of the column you want to add directly or by dragging it from the panel on the left.

  2. You can change the name of the metric after adding a column from the table by using the input window that appears on the right. The name of the metric can consist of alphanumeric characters and underscores (_), but it cannot start with a number. If a name is not provided, a random name will be assigned.

  3. To add additional metrics, click the "+ Metric" button.

  4. Click the "Save and Run" button to give a title to the query and save it. The result table will become available below once the query calculation is completed.

Function

  1. Aggregate Function This function includes options such as Sum, Count, Min, Max, and Average, and determines how the rows in a column will be summarized horizontally When you have chosen to use the Datetime aggregation option or have added a column to the group by section, you must use an aggregate function in the metric section. If you haven't selected the aggregation option, do not use an aggregate function. When multiple operations are utilized, the final function applied must be an aggregate operation.

  2. Scalar Function

    The Scalar functions determine how to perform calculations between multiple columns. They can be used freely regardless of whether an aggregation has taken place or not.

  3. Arithmetic Operation You can directly input the symbols *, /, +, - to perform arithmetic operations between columns or between a column and a number.

  4. Nested Operation You can perform nested operations using parentheses, which allows you to add the results of other functions within a function, and use arithmetic operations within a function.

  5. You can also use all of the other functions available in BigQuery.

🛠️