Table Details
| Property | Value |
|---|---|
| Table Name | provenance.rwa.figure_metrics_daily |
| Table Status | Beta 🌱 |
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| date | DATE | Calendar date (UTC) this record represents. Used in daily aggregate tables. |
| signed_loan_count | NUMBER(38,0) | Number of Figure loan scopes created (loans signed) on this day. |
| funded_loan_count | NUMBER(38,0) | Number of Figure loans whose first NAV was set (funded) on this day. |
| los_funded_volume_usd | FLOAT | Sum of initial_nav_usd for loans funded on this day (= marketplace_volume_usd). |
| marketplace_volume_usd | FLOAT | On-chain lower bound for Figure’s Consumer Loan Marketplace Volume. Equals LOS-funded originations only; Figure Connect USD is off-chain and excluded. |
| connect_tx_count | NUMBER(38,0) | Figure Connect transactions of all types on this day. |
| connect_pool_token_legs | NUMBER(38,0) | Pool-token (pm.*) commitment/release legs on Figure Connect this day. Use as trade activity proxy. |
| ylds_circulating_usd | FLOAT | $YLDS circulating supply at end of day in USD. Forward-filled on days with no mint/burn. |
| ylds_mints_usd | FLOAT | $YLDS minted on this day in USD. |
| ylds_burns_usd | FLOAT | $YLDS burned on this day in USD. |
| ylds_net_change_usd | FLOAT | Net change in YLDS supply on this day (mints - burns). |
| cumulative_marketplace_volume_usd | FLOAT | Running total of marketplace_volume_usd since the first funded loan. |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was created in the database. |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was last updated in the database. |
| _changed_since_full_refresh | BOOLEAN | Indicates if the record has changed since the last full data refresh. |