> ## Documentation Index > Fetch the complete documentation index at: https://docs.allium.so/llms.txt > Use this file to discover all available pages before exploring further. # Overview 🌱 ### Table Details | Property | Value | | ------------ | --------------------------- | | Table Name | `filecoin.metrics.overview` | | Table Status | Beta 🌱 | | Unique Key | `activity_date` | ### Table Columns | Column Name | Data Type | Description | | ---------------------------------- | ----------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | | chain | VARCHAR(16777216) | Slug identifying the blockchain this record belongs to (e.g. `ethereum`, `base`, `avalanche`, `solana`). In per-chain tables this is always the same value; in cross-chain tables it identifies which chain the row came from. | | activity\_date | TIMESTAMP\_NTZ(9) | Calendar date (UTC) for which this metric or aggregate is computed. Only includes fully completed days — the current in-progress day is excluded. | | symbol | VARCHAR(16777216) | Ticker symbol of this token or asset. Short alias for `token_symbol` used in tables that preserve the original blockchain field naming convention. | | name | VARCHAR(16777216) | Name of this token or asset. Short alias for `token_name` used in tables that preserve the original blockchain field naming convention. | | price\_median\_usd | FLOAT | The median price of the native token in USD | | market\_cap\_usd | FLOAT | The market capitalization of the native token in USD | | project\_token\_symbol | VARCHAR(16777216) | The symbol of the project token (same as native token for most chains) | | project\_token\_name | VARCHAR(16777216) | The name of the project token (same as native token for most chains) | | project\_token\_price\_median\_usd | FLOAT | The median price of the project token in USD | | project\_token\_market\_cap\_usd | FLOAT | The market capitalization of the project token in USD | | project\_token\_total\_volume\_usd | FLOAT | The total trading volume of the project token in USD | | total\_tipsets | NUMBER(38,0) | The total number of tipsets produced on the given date. | | total\_blocks | NUMBER(38,0) | Total number of blocks produced on this date. | | avg\_tipset\_time | FLOAT | The average time between tipsets in seconds. | | avg\_transactions\_per\_second | FLOAT | The average number of transactions per second, calculated as the average number of transactions per block divided by the average block time (in seconds) | | active\_addresses | NUMBER(38,0) | Number of distinct wallet addresses that initiated at least one successful transaction on this date. | | new\_addresses | NUMBER(38,0) | Number of distinct wallet addresses that sent their very first transaction on this date (nonce = 0). | | returning\_addresses | NUMBER(38,0) | Number of distinct wallet addresses that sent a transaction on this date but are not new (nonce > 0). | | total\_transactions | NUMBER(38,0) | Total number of transactions processed in this aggregated time period or entity scope. | | success\_transactions | NUMBER(38,0) | Number of transactions that executed successfully (receipt\_status = 1) on this date. | | failed\_transactions | NUMBER(38,0) | Number of transactions that reverted or failed (receipt\_status = 0) on this date. | | transaction\_fees | FLOAT | Total gas fees paid for this transaction in the chain's native token. | | transaction\_fees\_usd | FLOAT | Total gas fees paid for this transaction, converted to USD. | | avg\_transaction\_fees | FLOAT | The average transaction fees paid (including L1 and L2 fees) expressed in the native token, excluding system transactions (where applicable) and transactions with 0 fees | | avg\_transaction\_fees\_usd | FLOAT | The average transaction fees paid (including L1 and L2 fees) in USD terms, excluding system transactions (where applicable) and transactions with 0 fees | | total\_base\_fee\_burn | FLOAT | Total base fee burn in FIL (permanently destroyed). | | total\_overestimation\_burn | FLOAT | Total gas overestimation burn in FIL (permanently destroyed). | | total\_miner\_tip | FLOAT | Total miner tips paid in FIL. | | total\_miner\_penalty | FLOAT | Total miner penalties in FIL (permanently destroyed). | | total\_fil\_burned | FLOAT | Total FIL burned (base\_fee\_burn + overestimation\_burn + miner\_penalty). | | total\_gas\_used | NUMBER(38,0) | Total gas units consumed. | | total\_base\_fee\_burn\_usd | FLOAT | Total base fee burn in USD. | | total\_overestimation\_burn\_usd | FLOAT | Total gas overestimation burn in USD. | | total\_miner\_tip\_usd | FLOAT | Total miner tips paid in USD. | | total\_miner\_penalty\_usd | FLOAT | Total miner penalties in USD. | | total\_fil\_burned\_usd | FLOAT | Total FIL burned in USD. | | native\_transfer\_count | NUMBER(38,0) | The total number of native FIL transfers. | | native\_transfer\_volume | FLOAT | The total volume of native FIL transfers in FIL. | | native\_transfer\_volume\_usd | FLOAT | The total volume of native FIL transfers in USD. | | fevm\_transfer\_count | NUMBER(38,0) | The total number of FEVM (ERC20-like) token transfers. | | fevm\_transfer\_volume | FLOAT | The total volume of FEVM token transfers in native token units. | | fevm\_transfer\_volume\_usd | FLOAT | The total volume of FEVM token transfers in USD. | | total\_miner\_rewards | FLOAT | Total miner rewards in FIL (block rewards + miner tips), derived from miner balance changes in actor\_state\_snapshots. | | total\_miner\_rewards\_usd | FLOAT | Total miner rewards in USD. | | deals\_published | NUMBER(38,0) | The number of storage deal proposals published. | | deals\_activated | NUMBER(38,0) | The number of storage deals activated. | | deals\_terminated | NUMBER(38,0) | The number of storage deals terminated early. | | deals\_completed | NUMBER(38,0) | The number of storage deals completed successfully. | | total\_deal\_size\_gib | FLOAT | Total size of published deals in GiB. | | sectors\_precommitted | NUMBER(38,0) | The number of sectors pre-committed. | | sectors\_provecommitted | NUMBER(38,0) | The number of sectors prove-committed (standard 2-step sealing). | | sectors\_provecommitted\_ni | NUMBER(38,0) | The number of sectors prove-committed non-interactively (1-step sealing, no separate precommit). | | sectors\_replica\_updated | NUMBER(38,0) | The number of existing sectors that had their data replaced via Snap Deals (replica\_update). | | sectors\_net\_growth | NUMBER(38,0) | Net new sector growth (provecommitted + provecommitted\_ni - precommitted). | | avg\_sealing\_time\_seconds | FLOAT | Average sealing time in seconds (provecommit - precommit, standard 2-step only). | | median\_sealing\_time\_seconds | FLOAT | Median sealing time in seconds (standard 2-step only). | | deals\_renewed | NUMBER(38,0) | Number of deal proposals that renew previously stored content (same piece\_cid in an earlier deal). | | deal\_renewal\_rate | FLOAT | Fraction of deal proposals that are renewals of previously stored content. | | deals\_renewed\_1m | NUMBER(38,0) | Renewed deals where the previous deal's duration was under 1 month. | | deal\_renewal\_rate\_1m | FLOAT | Renewal rate for deals where the previous deal's duration was under 1 month. | | deals\_renewed\_3m | NUMBER(38,0) | Renewed deals where the previous deal's duration was 1 to 3 months. | | deal\_renewal\_rate\_3m | FLOAT | Renewal rate for deals where the previous deal's duration was 1 to 3 months. | | deals\_renewed\_6m | NUMBER(38,0) | Renewed deals where the previous deal's duration was under 6 months. | | deal\_renewal\_rate\_6m | FLOAT | Renewal rate for deals where the previous deal's duration was under 6 months. | | deals\_renewed\_1y | NUMBER(38,0) | Renewed deals where the previous deal's duration was 6 months to 1 year. | | deal\_renewal\_rate\_1y | FLOAT | Renewal rate for deals where the previous deal's duration was 6 months to 1 year. | | deals\_renewed\_2y | NUMBER(38,0) | Renewed deals where the previous deal's duration was 1 to 2 years. | | deal\_renewal\_rate\_2y | FLOAT | Renewal rate for deals where the previous deal's duration was 1 to 2 years. | | deals\_renewed\_2y\_plus | NUMBER(38,0) | Renewed deals where the previous deal's duration was over 2 years. | | deal\_renewal\_rate\_2y\_plus | FLOAT | Renewal rate for deals where the previous deal's duration was over 2 years. | | active\_addresses\_7d | NUMBER(38,0) | Same as active\_addresses but over 7-day rolling window | | new\_addresses\_7d | NUMBER(38,0) | Same as new\_addresses but over 7-day rolling window | | returning\_addresses\_7d | NUMBER(38,0) | Same as returning\_addresses but over 7-day rolling window | | active\_addresses\_28d | NUMBER(38,0) | Same as active\_addresses but over 28-day rolling window. 28 days chosen for equal weekday/weekend weighting | | new\_addresses\_28d | NUMBER(38,0) | Same as new\_addresses but over 28-day rolling window. 28 days chosen for equal weekday/weekend weighting | | returning\_addresses\_28d | NUMBER(38,0) | Same as returning\_addresses but over 28-day rolling window. 28 days chosen for equal weekday/weekend weighting |