Skip to main content
Schema: near.gov Table: fact_lockup_actions Type: View

​
Description

This table contains all lockup account transactions on the NEAR Protocol blockchain, capturing lockup creation, vesting schedules, and release mechanisms. The data includes lockup amounts, duration periods, vesting schedules, and associated metadata, providing comprehensive tracking of token lockups and vesting arrangements. This table provides the foundation for lockup analytics, vesting schedule analysis, and token release tracking across the NEAR ecosystem.

​
Key Use Cases

  • Lockup account analysis and vesting schedule tracking
  • Token release analysis and unlock pattern identification
  • Vesting schedule compliance monitoring and analysis
  • Lockup duration analysis and trend identification
  • Cross-account lockup comparison and performance analysis
  • Token distribution analysis and supply impact assessment
  • Governance token lockup analysis and voting power tracking

​
Important Relationships

  • Links to core.fact_transactions through tx_hash for transaction context
  • Connects to core.fact_blocks through block_id for temporal context
  • Provides lockup data for governance analytics and vesting analysis
  • Supports core.ez_native_daily_balances with lockup balance tracking
  • Enables analysis in stats.ez_core_metrics_hourly for lockup metrics
  • Powers supply analysis and token distribution studies

​
Commonly-used Fields

  • tx_hash: Essential for linking to transaction details and verification
  • block_timestamp: Primary field for time-series analysis and trend detection
  • lockup_account_id and owner_account_id: Critical for account identification and ownership tracking
  • deposit: Important for lockup amount analysis and value tracking
  • lockup_duration and release_duration: Essential for vesting schedule analysis
  • lockup_timestamp and lockup_timestamp_ntz: Important for timeline analysis and unlock tracking
  • vesting_schedule: Critical for vesting pattern analysis and compliance monitoring

​
Columns

Column NameData TypeDescription
TX_HASHTEXTUnique identifier (hash) of this transaction.
BLOCK_TIMESTAMPTIMESTAMP_NTZThe date and time at which the block began.
BLOCK_IDNUMBERThe height of the chain this block corresponds with.
DEPOSITFLOATSum of all NEAR tokens transferred from the signing account to the receiver account during receipt processing. This includes tokens sent in a Transfer action(s), and tokens sent in a FunctionCall action(s) with a deposit attached.
In raw number format with 24 decimal places, to adjust divide by POW(10,24) or multiply by 1e-24. | | LOCKUP_ACCOUNT_ID | TEXT | A vault created by the lockup action that holds the distributed NEAR tokens until the end of the lockup duration. | | OWNER_ACCOUNT_ID | TEXT | The wallet address of the owner for the locked tokens, per the initial distribution. | | LOCKUP_DURATION | TEXT | The duration of the lockup period. | | LOCKUP_TIMESTAMP | TEXT | The initial lockup timestamp, in epoch time. | | LOCKUP_TIMESTAMP_NTZ | TIMESTAMP_NTZ | Timestamp of the start of the lockup period, converted to UTC time. | | RELEASE_DURATION | TEXT | The duration until the locked tokens can be released. | | VESTING_SCHEDULE | TEXT | Legacy/no longer used. The vesting schedule for the locked tokens. | | TRANSFERS_INFORMATION | TEXT | A dictionary of information about the parameters allowing or limiting transfers of the locked NEAR. | | FACT_LOCKUP_ACTIONS_ID | TEXT | A unique identifier for the record. | | INSERTED_TIMESTAMP | TIMESTAMP_LTZ | The timestamp at which the record was initially created and inserted into this table. | | MODIFIED_TIMESTAMP | TIMESTAMP_LTZ | The timestamp at which this record was last modified by an internal process. |