# Welcome To OpenBlock
At OpenBlock Labs, we specialize in transforming blockchain data into actionable insights that help you design, optimize, and execute smarter incentive strategies.
Our goal is to empower teams with the data-driven intelligence they need to improve protocol performance, enhance user engagement, and manage incentive programs seamlessly.
## **What We Do**
OpenBlock Labs is a full-service platform that transforms raw blockchain data into actionable insights and economic models, assessing protocol health and performance while optimizing incentive programs for sustainable growth.
* **Data Transformations**: We ingest raw blockchain data and transform it into high signal metrics for analysis, such as Total Value Locked, Volume, Non-Recursive Supply, and Loss vs. Rebalancing.
* **Intelligence Models for Incentive Design**: We use models like Sybil, user labeling, and retention predictions to ensure that rewards are distributed fairly, and that you're attracting the right participants.
* **Innovative Incentive Strategies**: We help you design incentive systems that encourage the behaviors you want to see—whether that’s rewarding long-term users, discouraging bad actors, or fostering liquidity. By understanding your users' actions, we enable you to create dynamic incentives that maximize both engagement and protocol growth.
## **Our Offering**
OpenBlock gives you the tools to:
* **Assess Protocol Performance And Drive Growth**: With our comprehensive suite of data visualizations, models and analysis, we enable you to assess your protocol effectively, attracting high-value participants and reducing inefficiencies in your incentive programs.
* **Launch Incentive Campaigns**: We help you design and optimize reward structures—like long-term incentive programs, point systems, or airdrops—based on historcal and real-time data.
* **Understand User Behavior**: Through user analytics and behavioral modeling, we uncover patterns and predict how users will respond to different incentives.
OpenBlock Labs helps you make smarter decisions, reduce risk, and build more sustainable incentive programs.
## Explore Further
{% content-ref url="/pages/sfMbK2ghEV1OmoBZX26i" %}
[Data Offering](/data-offering/overview)
{% endcontent-ref %}
{% content-ref url="/pages/IhyoPjM1qdtVm97xjKE0" %}
[Intelligence Models](/intelligence-models/sybil)
{% endcontent-ref %}
{% content-ref url="/pages/lfGvKWmaYhtgpyrwGsGh" %}
[Incentive Methodologies](/incentive-methodologies/point-campaigns)
{% endcontent-ref %}
# Overview
Data and schemas supported by OpenBlock
## Data Schemas
Data schemas supported by OpenBlock
| Schema | Description |
| --------------------- | --------------------------------------------------------------------------------------------------------------------- |
| DeFi Canonical Data | Protocol-specific data, including events and core metrics at the pool level (e.g., Total Value Locked, Volume, etc.). |
| DEX Events | Events from DEXs, spanning multiple DEX protocols, including trades, mints/burns, etc. |
| ERC20 Token Transfers | Minting, transferring, and burning of ERC20 tokens across EVM ecosystems. |
| Airdrop Data | Data on airdrop events, the tokens distributed, and user participation |
| Global Token Prices | Token price data across multiple blockchains. Available at hourly and 1-minute intervals |
# DeFi Canonical Data
Our DeFi Canonical Data covers historical data for variety of different protocols types. Within each protocol type, there is a shared schema that covers core pool-level metrics and events specific to that type. This allows for metrics within protocol types to be easily compared/queried together.
Protocol and vertical level metrics can be created from the aggregation of this data and can also be access in DeFi Protocol Metrics
Protocol Types Supported:
* Automated Liquidity Manager
* Bridge
* Derivative
* DEX Aggregator
* DEX
* Lending
* Liquid Staking
* NFT Marketplace
* Prediction Markets
* Yield Aggregators
# Automated Liquidity Manager
Our tables track liquidity provisioning, withdrawals, and user-specific events
Key Tables:
* **Pools**: Information about liquidity pools, including details like pool address, token symbols, and liquidity amounts.
* **Position Snapshot**: Snapshot of user positions in liquidity pools, detailing their share in the pool and the associated value.
* **Pool Snapshot**: Snapshot of pool state over time, including fees earned, and liquidity supplied.
* **Events**: Tracks user activities like deposits, withdrawals, and changes to pool positions.
{% tabs %}
{% tab title="Pools" %}
| Property | Description | Type |
| ----------------------------------------- | ---------------------------------------------------------------------------------------- | ------ |
| chain\_id | The standard chain id. | number |
| timestamp | The timestamp this pool was created. | number |
| creation\_block\_number | The block number that this pool was created. | number |
| strategy\_vault\_contract\_address | The contract address of the strategy vault which manages the liquidity pool positions. | string |
| liquidity\_pool\_address | The contract address of the underlying liquidity pool where liquidity are deposited into | string |
| strategy\_vault\_receipt\_token\_address | The contract address of ERC20 token which represents the share of liquidity provided. | string |
| strategy\_vault\_receipt\_token\_decimals | The decimal amount of the ERC20 receipt token. | number |
| strategy\_vault\_receipt\_token\_symbol | The symbol of the receipt token. | string |
| {% endtab %} | | |
{% tab title="Position Snapshot" %}
| Property | Description | Type |
| ---------------------------------- | ----------------------------------------------------------------------------------------------------------------- | ------ |
| timestamp | The timestamp of the snapshot. | number |
| block\_date | The timestamp truncated (ie, YYYY-MM-DD format for daily snapshots and YYYY-MM-DD HH:00:00 for hourly snapshots). | date |
| chain\_id | The standard chain id. | number |
| strategy\_vault\_contract\_address | The address of the strategy vault this user has a position in. | string |
| user\_address | The address of the user who has a position in the strategy vault. | string |
| liquidity\_pool\_address | The address of the underlying liquidity pool where liquidity are deposited into | string |
| underlying\_token\_address | The address of the supplied underlying token. | string |
| underlying\_token\_index | The index of the underlying token in the smart contract, default 0. | number |
| underlying\_token\_amount | The amount based on the user's share of the total underlying token, decimal normalized. | number |
| underlying\_token\_amount\_usd | The amount based on the user's share of the total underlying token, in USD. | number |
| total\_fees\_usd | The total amount of revenue and fees paid in this pool in the given snapshot, in USD. | number |
| {% endtab %} | | |
{% tab title="Pool Snapshot" %}
| Property | Description | Type |
| ---------------------------------- | ----------------------------------------------------------------------------------------------------------------- | ------ |
| timestamp | The timestamp of the snapshot. | number |
| block\_date | The timestamp truncated (ie, YYYY-MM-DD format for daily snapshots and YYYY-MM-DD HH:00:00 for hourly snapshots). | date |
| chain\_id | The standard chain id. | number |
| strategy\_vault\_contract\_address | The address of the strategy vault this user has a position in. | string |
| liquidity\_pool\_address | The address of the underlying liquidity pool where liquidity are deposited into | string |
| underlying\_token\_address | The address of the supplied underlying token. | string |
| underlying\_token\_index | The index of the underlying token in the smart contract, default 0. | number |
| underlying\_token\_amount | The amount of underlying token supplied in this pool, decimal normalized. | number |
| underlying\_token\_amount\_usd | The amount of underlying tokens supplied in this pool, in USD. | number |
| total\_fees\_usd | The total amount of revenue and fees paid in this pool in the given snapshot, in USD. | number |
| {% endtab %} | | |
{% tab title="Events" %}
| Property | Description | Type |
| -------------------------- | ----------------------------------------------------------------------------------------- | ------ |
| timestamp | The timestamp of the transaction. | number |
| chain\_id | The standard id of the chain. | number |
| block\_number | The block number of the trade. | number |
| log\_index | The event log | number |
| transaction\_hash | The hash of the transaction. | string |
| user\_address | The address that initiates the transaction (ie, the transaction signer). | string |
| pool\_address | The smart contract address of the pool. | string |
| underlying\_token\_address | The contract address of the underlying token or deposited token. | string |
| amount | The amount of token transacted, decimal normalized. | number |
| amount\_usd | The amount of token transacted, in USD. | number |
| event\_type | The type of event, corresponds to the action taken by the user (ie, deposit, withdrawal). | string |
| {% endtab %} | | |
| {% endtabs %} | | |
# Bridge
Our data tables track key metrics on pools, liquidity providers, user activity, and transactions across various bridge protocols, both pool-based and intent-based.
Key Tables:
* **Tokens:** Details of the tokens in the protocol, including address, symbol, and decimals.
* **Pools:** Details of pools in bridge protocols, including token information, pool creation data, and fee rates.
* **LP Snapshot:** Snapshots of liquidity provider positions in pool-based bridge protocols, including token amounts and their USD value.
* **User Snapshot:** User activity snapshots in pool and intent-based bridge protocols, tracking token inflows and outflows.
* **Pool Snapshot:** Snapshot of individual pools, including token volume, fees, and bridged data.
* **Bridge Transactions:** Records of user transactions across bridge protocols, including source/destination chain IDs and token amounts.
* **Maker Snapshot:** Snapshots on makers in intent-based bridge protocols, including tokens supplied and fees collected.
* **Taker Snapshot:** Snapshots on takers in intent-based bridge protocols, including volume bridged and fees paid.
* **Token Snapshot:** Token-level data across bridge protocols, capturing amounts held, bridged volume, and fees collected.
{% tabs %}
{% tab title="Tokens" %}
| Property | Description | Type |
| --------------- | ------------------------------------------ | ------ |
| token\_address | The contract address of the token. | string |
| token\_symbol | The symbol of the token. | string |
| token\_decimals | The decimal amount of the token. | number |
| chain\_id | The blockchain ID where the token resides. | number |
| {% endtab %} | | |
{% tab title="Pools" %}
| Property | Description | Type |
| ----------------------- | --------------------------------------------------------------------------------- | ------- |
| timestamp | The timestamp this pool was created. | number |
| creation\_block\_number | The block number this pool was created on. | number |
| token\_address | The contract address of the token being bridged or pooled. | string |
| token\_index | The index of the pooled token in the smart contract. | number |
| token\_symbol | The symbol of the token. | string |
| fee\_rate | The fee rate as a percentage for the pool, if applicable (ie, 2.3% fee as 0.023). | number |
| pool\_address | The contract address of the pool. | string |
| chain\_id | Standard chain ID (ie, the chain ID of the network the pool lives on). | number |
| bridge\_type | The type of bridge (ie, pool-based, mint-based, or intent-based). | vstring |
| {% endtab %} | | |
{% tab title="LP Snapshot" %}
| Property | Description | Type |
| ------------------ | ----------------------------------------------------------------------------------------------------------------- | ------ |
| timestamp | The timestamp of the snapshot. | number |
| block\_date | The timestamp truncated (ie, YYYY-MM-DD format for daily snapshots and YYYY-MM-DD HH:00:00 for hourly snapshots). | date |
| pool\_address | The address of the pool. | string |
| lp\_address | The address of the liquidity provider. | string |
| token\_address | The contract address of the token supplied. | string |
| token\_index | The index in the smart contract of this token, default to 0. | number |
| token\_amount | The amount of the supplied token, decimal normalized. | number |
| token\_amount\_usd | The amount supplied, in USD. | number |
| chain\_id | The standard chain ID where the liquidity provider resides. | number |
| bridge\_type | The type of bridge (pool-based, mint-based, or intent-based). | string |
| {% endtab %} | | |
{% tab title="User Snapshot" %}
| Property | Description | Type |
| ---------------- | ----------------------------------------------------------------------------------------------------------------- | ------ |
| timestamp | The timestamp of the snapshot. | number |
| block\_date | The timestamp truncated (ie, YYYY-MM-DD format for daily snapshots and YYYY-MM-DD HH:00:00 for hourly snapshots). | date |
| pool\_address | The contract address of the pool. | string |
| user\_address | The address of the user this snapshot activity is based on. | string |
| amount\_in\_usd | The amount of tokens received on this network by the user in USD during the given snapshot. | number |
| amount\_out\_usd | The amount of tokens sent out of this network by the user in USD during the given snapshot. | number |
| chain\_id | The standard chain ID where the bridger resides. | number |
| bridge\_type | The type of bridge (pool-based, mint-based, or intent-based). | string |
| {% endtab %} | | |
{% tab title="Pool Snapshot" %}
| Property | Description | Type |
| ------------------ | ----------------------------------------------------------------------------------------------------------------- | ------ |
| timestamp | The timestamp of the snapshot. | number |
| block\_date | The timestamp truncated (ie, YYYY-MM-DD format for daily snapshots and YYYY-MM-DD HH:00:00 for hourly snapshots). | date |
| pool\_address | The contract address of the pool. | string |
| token\_address | The contract address of the token being bridged or pooled. | string |
| token\_index | The index of the pooled token in the smart contract. | number |
| token\_symbol | The symbol of the token. | string |
| token\_amount | The amount of the supplied token (in a pool-based bridge), decimal normalized. | number |
| token\_amount\_usd | The amount supplied, in USD. | number |
| volume\_usd | The bridged volume in USD, during this snapshot. | number |
| fees\_usd | The fees collected in USD, during the snapshot period. | number |
| chain\_id | The standard chain ID where the pool resides. | number |
| bridge\_type | The type of bridge (pool-based, mint-based, or intent-based). | string |
| {% endtab %} | | |
{% tab title="Transactions" %}
| Property | Description | Type |
| ---------------------- | --------------------------------------------------------------------------- | ------ |
| timestamp | The timestamp of the transaction. | number |
| block\_number | The block number of the transaction. | number |
| transaction\_hash | The hash of the transaction this bridge originated from. | string |
| log\_index | The log index of the transaction. | number |
| source\_chain\_id | The source standard chain ID. | number |
| destination\_chain\_id | The destination standard chain ID. | number |
| user\_address | The address of the user initiating the transaction. | string |
| token\_address | The smart contract address of the source chain bridge token. | string |
| token\_amount | The amount of the token sent out from the source chain, decimal normalized. | number |
| token\_amount\_usd | The token amount in USD. | number |
| solver\_address | The address of the solver (for intent-based bridges). | string |
| pool\_address | The address of the pool (for pool-based and mint-based bridges). | string |
| bridge\_type | The type of bridge (pool-based, mint-based, or intent-based). | string |
| {% endtab %} | | |
{% tab title="Maker Snapshot" %}
| Property | Description | Type |
| ------------------ | ----------------------------------------------------------------------------------------------------------------- | ------ |
| timestamp | The timestamp of the snapshot. | number |
| block\_date | The timestamp truncated (ie, YYYY-MM-DD format for daily snapshots and YYYY-MM-DD HH:00:00 for hourly snapshots). | date |
| user\_address | The address of the maker. | string |
| token\_address | The smart contract address of the token being supplied by the maker. | string |
| token\_in\_amount | The amount of the token received, decimal normalized. | number |
| amount\_in\_usd | The amount received in USD, during this snapshot. | number |
| token\_out\_amount | The amount of the token sent out, decimal normalized. | string |
| amount\_out\_usd | The amount sent in USD, during this given snapshot. | number |
| fees\_usd | The fees collected in USD, during this snapshot. | number |
| chain\_id | The standard chain ID where the maker resides. | string |
| {% endtab %} | | |
{% tab title="Taker Snapshot" %}
| Property | Description | Type |
| -------------- | ----------------------------------------------------------------------------------------------------------------- | ------ |
| timestamp | The timestamp of the snapshot. | number |
| block\_date | The timestamp truncated (ie, YYYY-MM-DD format for daily snapshots and YYYY-MM-DD HH:00:00 for hourly snapshots). | date |
| user\_address | The address of the taker. | string |
| token\_address | The smart contract address of the token. | string |
| volume\_amount | The amount of volume bridged from the source chain, decimal normalized. | number |
| volume\_usd | The volume bridged in USD, in the given snapshot. | number |
| chain\_id | The standard chain ID where the taker resides. | number |
| {% endtab %} | | |
{% tab title="Token Snapshot" %}
| Property | Description | Type |
| -------------- | ----------------------------------------------------------------------------------------------------------------- | ------ |
| timestamp | The timestamp of the snapshot. | number |
| block\_date | The timestamp truncated (ie, YYYY-MM-DD format for daily snapshots and YYYY-MM-DD HH:00:00 for hourly snapshots). | date |
| user\_address | The address of the taker. | string |
| token\_address | The smart contract address of the token. | string |
| volume\_amount | The amount of volume bridged from the source chain, decimal normalized. | number |
| volume\_usd | The volume bridged in USD, in the given snapshot. | number |
| chain\_id | The standard chain ID where the taker resides. | number |
| {% endtab %} | | |
| {% endtabs %} | | |
# Derivative
Our data tables capture key derivative metrics on liquidity pools, trade positions, and user activity.
Key Tables:
* **Pools:** Details of liquidity pools, including token addresses, pool creation data, and associated tokens.
* **LP Snapshot:** Liquidity provider snapshots, tracking deposits, liquidated amounts, and fees accrued for each token in a pool.
* **Pool Snapshot:** Snapshot of individuals pools, including funding rates, fee rates, and open interest for long and short positions.
* **Trades:** Records of user trades, including open/close actions, trade amounts, notional values, and profit/loss (P\&L) data for both makers and takers.
{% tabs %}
{% tab title="Pools" %}
| Property | Description | Type |
| ----------------------- | -------------------------------------------------------------------------------- | ------ |
| chain\_id | Standard chain id. | number |
| timestamp | The timestamp of the block the pool was created on. | number |
| creation\_block\_number | The block number this pool was created on. | number |
| pool\_address | The contract address of the pool. | string |
| pool\_name | The name of the pool (ie, name()) in the smart contract). | string |
| token\_index | The index of the token in the smart contract (one row for each token in a pool). | number |
| token\_address | The contract address of the token. | string |
| token\_symbol | The symbol of the token. | string |
| {% endtab %} | | |
{% tab title="LP Snapshot" %}
| Property | Description | Type |
| ----------------------- | -------------------------------------------------------------------------------------------------------------------------- | ------ |
| timestamp | The timestamp of the snapshot. | number |
| block\_date | The timestamp truncated (ie, YYYY-MM-DD format for daily snapshots and YYYY-MM-DD HH:00:00 for hourly snapshots). | date |
| chain\_id | Standard chain id. | number |
| pool\_address | The address of the pool. | string |
| lp\_address | The address of the liquidity provider. | string |
| token\_index | The index of the token in the smart contract. | number |
| token\_address | The address of the token provided as liquidity. | string |
| token\_symbol | The symbol of the token. | string |
| deposit\_amount | (Optional, for Order Books) The amount deposited into the pool, decimal normalized. | number |
| deposit\_amount\_usd | (Optional, for Order Books) The amount deposited, in USD. | number |
| amount\_useful | (Optional, for LPs) The amount of tokens supplied that are liquid and usable by users of the protocol, decimal normalized. | number |
| amount\_useful\_usd | (Optional, for LPs) The amount of liquid tokens supplied in USD. | number |
| liquidated\_amount | The amount of tokens liquidated from the LP, decimal normalized. | number |
| liquidated\_amount\_usd | The amount liquidated, in USD. | number |
| total\_fees\_usd | (Optional) All fees generated by the LP in the given snapshot in USD. | number |
| user\_fees\_usd | (Optional) The portion of fees accrued to users of the protocol, in USD. | number |
| protocol\_fees\_usd | (Optional) The portion of fees accrued to the protocol, in USD. | number |
| {% endtab %} | | |
{% tab title="Pool Snapshot" %}
| Property | Description | Type |
| --------------------------- | ----------------------------------------------------------------------------------------------------------------- | ------ |
| timestamp | The timestamp of the snapshot. | number |
| block\_date | The timestamp truncated (ie, YYYY-MM-DD format for daily snapshots and YYYY-MM-DD HH:00:00 for hourly snapshots). | date |
| chain\_id | Standard chain id. | number |
| pool\_address | The smart contract address of the pool. | string |
| token\_index | The index of the token in the smart contract (one row for each token in a pool). | number |
| funding\_rate | The funding rate in this pool at the time of the snapshot, as a percentage. | number |
| fee\_rate | he pool's fee rate, as a percentage. | number |
| total\_value\_locked\_usd | The total value locked in USD. | number |
| volume\_usd | The volume of positions opened and closed in the given snapshot in USD. | number |
| open\_interest\_longs\_usd | The sum of open interest of longs held within this pool in USD. | number |
| open\_interest\_shorts\_usd | The sum of open interest in shorts held within this pool in USD. | number |
| {% endtab %} | | |
{% tab title="Trades" %}
| Property | Description | Type |
| -------------------- | --------------------------------------------------------------------------------------------------- | ------- |
| timestamp | The timestamp of the trade. | number |
| chain\_id | Standard chain id. | number |
| transaction\_hash | The hash of the transaction this trade was performed in. | string |
| log\_index | Event log index. | number |
| block\_number | The block number of the trade. | number |
| pool\_address | The address of the pool this token was traded in. | string |
| maker\_address | The address of the maker. | string |
| taker\_address | The address of the taker. | string |
| token\_address | The address of the token. | string |
| amount | The value that a trader is putting to open a long or short, decimal normalized. | number |
| amount\_usd | The trade amount in USD. | number |
| notional\_value | The value of the leveraged amount of the trade, decimal normalized. | number |
| notional\_value\_usd | The notional value, in USD. | number |
| maker\_pnl\_usd | The total profit and loss of the trade on the maker's side, in USD. | number |
| taker\_pnl\_usd | The total profit and loss of the trade on the taker's side, in USD. | number |
| trade\_action | The action of trade being recorded in this entry (ie, OPEN, CLOSE, INCREASE, DECREASE, LIQUIDATED). | string |
| trade\_type | The type of the trade being recorded in this entry (ie, LONG, SHORT). | vstring |
| {% endtab %} | | |
| {% endtabs %} | | |
# DEX Aggregator
Our data tables capture key metrics related to token volumes, fees, and trades.
Key Tables:
* **Tokens:** Details of the tokens supported by the aggregator, including token addresses, names, symbols, and decimals.
* **Token Snapshot:** Token-level snapshots, capturing trading volume, fees, and incentives collected in USD for a given period.
* **Protocol Snapshot:** Snapshot of aggregator-wide metrics, including total volume and fees in USD across all tokens.
* **Trades:** Data on individual trades executed via the aggregator, including token swaps, slippage, and fees.
{% tabs %}
{% tab title="Tokens" %}
| Property | Description | Type |
| -------------- | -------------------------------------------------------------- | ------ |
| chain\_id | The standard id of the chain. | number |
| token\_address | The contract address of the token. | string |
| token\_name | The full name of the token, from the eth\_call name(). | string |
| token\_symbol | The symbol of the token, from the eth\_call symbol(). | string |
| decimals | The decimals name of the token, from the eth\_call decimals(). | number |
| {% endtab %} | | |
{% tab title="Token Snapshot" %}
| Property | Description | Type |
| ----------------- | ----------------------------------------------------------------------------------------------------------------- | ------ |
| timestamp | The timestamp of the record. | number |
| block\_date | The timestamp truncated (ie, YYYY-MM-DD format for daily snapshots and YYYY-MM-DD HH:00:00 for hourly snapshots). | date |
| chain\_id | The standard id of the chain. | number |
| token\_address | The contract address of the token. | string |
| volume\_amount | The volume amount of the token, during the snapshot period, decimal normalized. | number |
| volume\_usd | The volume of the token in USD. | number |
| fees | The fees (ie, revenue generated from trading this token) from this token in native, decimal normalized terms. | number |
| fees\_usd | The fees collected in USD. | number |
| incentive\_amount | The amount of incentives collected from this token, during the snapshot period, decimal normalized. | number |
| incentive\_usd | The value of incentives in USD. | number |
| {% endtab %} | | |
{% tab title="Protocol Snapshot" %}
| Property | Description | Type |
| ------------ | ----------------------------------------------------------------------------------------------------------------- | ------ |
| timestamp | The timestamp of the block this snapshot was taken. | number |
| block\_date | The timestamp truncated (ie, YYYY-MM-DD format for daily snapshots and YYYY-MM-DD HH:00:00 for hourly snapshots). | date |
| chain\_id | The standard id of the chain. | number |
| volume\_usd | The volume in USD, in the given snapshot period. | number |
| fees\_usd | The fees (ie, total revenue generated in the protocol) collected in USD, during the snapshot period. | number |
| {% endtab %} | | |
{% tab title="Trades" %}
| Property | Description | Type |
| ---------------------- | ----------------------------------------------------------------------------------------------- | --------- |
| timestamp | The timestamp of the trade. | number |
| chain\_id | The standard id of the chain this trade belongs to. | number |
| block\_number | The block number in which the trade occurred. | number |
| transaction\_hash | The transaction hash associated with this trade. | string |
| log\_index | The event log. For transactions that don't emit event, create arbitrary index starting from 0. | number |
| fees | The amount of fees from this trade (ie, the revenue generated from executing this trade). | number |
| fees\_usd | The fees for this trade in USD. | number |
| slippage | (Optional) The slippage of the given trade, as a percentage (ie, 1.3% slippage is 0.013). | number |
| user\_address | The address of the user initiating the trade. | string |
| input\_tokens | The contract address of the input token(s). | \[string] |
| input\_token\_amounts | Parallel array to input\_tokens, dictating the normalized native amounts of each token traded. | \[number] |
| output\_tokens | The contract address of the output token(s). | \[string] |
| output\_token\_amounts | Parallel array to output\_tokens, dictating the normalized native amounts of each token traded. | \[number] |
| swap\_amount\_usd | The value of the swap in USD. | number |
| {% endtab %} | | |
| {% endtabs %} | | |
# DEX
Our data tables capture key metrics on trades, liquidity pools, and user activity.
Key Tables:
* **Pools**: Details of liquidity pools, including token pairs, liquidity provided, and fee rates.
* **LP Position Snapshot**: Snapshots of liquidity provider positions, tracking token amounts and USD values.
* **Pool Snapshot**: Snapshot of individuals pools, including token volume, fees, and transaction data.
* **Trades**: Records of user trades, capturing swap amounts, tokens involved, and fees.\\
{% tabs %}
{% tab title="Pools" %}
| Property | Description | Type |
| ----------------------- | --------------------------------------------------------------------------------------------------------------- | ------ |
| chain\_id | The standard id of the chain. | number |
| creation\_block\_number | The block this pool was created in. | number |
| timestamp | The timestamp of the block that this pool was created in. | number |
| pool\_address | The contract address of the LP pool. | string |
| lp\_token\_address | The token address of the LP token for this pool. | string |
| lp\_token\_symbol | The symbol of the LP token. | string |
| token\_address | The token address of the pool token at token\_index. | string |
| token\_symbol | The symbol of the pool token. | string |
| token\_decimals | The decimals of the pool token. | string |
| token\_index | The index in the pool smart contract that this token appears at, default 0 (ie, one entry per token in a pool). | number |
| fee\_rate | The fee rate of the pool, as a percentage (ie, 2.3% as 0.023). | number |
| dex\_type | The type of the DEX (ie, CPMM, CLMM, Orderbook). | string |
| {% endtab %} | | |
{% tab title="LP Position Snapshot" %}
| Property | Description | Type |
| ------------------ | -------------------------------------------------------------------------------------------------------------------------------------------------- | ------ |
| timestamp | The timestamp of the snapshot. | number |
| block\_date | The timestamp truncated (ie, YYYY-MM-DD format for daily snapshots and YYYY-MM-DD HH:00:00 for hourly snapshots). | date |
| chain\_id | The standard id of the chain. | number |
| pool\_address | The contract address of the pool. | string |
| user\_address | The address of the liquidity provider. | string |
| token\_index | The token index based on the smart contract. | number |
| token\_address | The contract address of the token provided as liquidity. | string |
| token\_symbol | The symbol of the token. | string |
| token\_amount | The amount of the underlying liquidity position in the pool, decimal normalized (ie, the amount of USDC provided by the LPer in a USDC/WETH pool). | number |
| token\_amount\_usd | The amount of the token in USD. | number |
| {% endtab %} | | |
{% tab title="Pool Snapshot" %}
| Property | Description | Type |
| ------------------- | ----------------------------------------------------------------------------------------------------------------- | ------ |
| timestamp | The timestamp of the snapshot. | number |
| block\_date | The timestamp truncated (ie, YYYY-MM-DD format for daily snapshots and YYYY-MM-DD HH:00:00 for hourly snapshots). | date |
| chain\_id | The standard id of the chain. | number |
| pool\_address | The contract address of the LP pool. | string |
| token\_index | The token index in the smart contract. | number |
| token\_address | The contract address of the token in the pool. | string |
| token\_symbol | The symbol of the token. | string |
| token\_amount | The amount of the token in this pool at the snapshot. | number |
| token\_amount\_usd | The amount of the token in USD. | number |
| volume\_amount | The volume of the token transacted in this pool during the given snapshot, decimal normalized. | number |
| volume\_usd | The volume transacted in the given snapshot, in USD. | number |
| fee\_rate | The fee rate of the pool, as a percentage (ie, 2.3% as 0.023). | number |
| total\_fees\_usd | The total amount of revenue and fees paid in this pool in the given snapshot, in USD. | number |
| user\_fees\_usd | The amount of total fees accrued to liquidity providers of the protocol, in USD. | number |
| protocol\_fees\_usd | The amount of total fees accrued to the protocol, in USD. | number |
| {% endtab %} | | |
{% tab title="Trades" %}
| Property | Description | Type |
| ------------------------ | -------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------ |
| timestamp | The timestamp of the transaction. | number |
| chain\_id | The standard id of the chain. | number |
| block\_number | The block number of the trade. | number |
| log\_index | The event log. For transactions that don't emit event, create arbitrary index starting from 0. | number |
| transaction\_hash | The hash of the transaction. | string |
| user\_address | The address that initiates the transaction (ie, the transaction signer). | string |
| taker\_address | The taker, the address that receives the output of the swap (ie, could be the same as user\_address unless a proxy contract/router is used). | string |
| pair\_name | The name of the token pair. | string |
| pool\_address | The contract address of the LP pool being traded in. | string |
| input\_token\_address | The contract address of the input token (ie, the tokenIn or the token being sold to the pool). | string |
| input\_token\_symbol | The symbol of the input token. | string |
| input\_token\_amount | The amount of the input token, decimal normalized. | number |
| output\_token\_address | The contract address of the output token (ie, the tokenOut of the token being bought by the user and sent to the taker). | string |
| output\_token\_symbol | The symbol of the output token. | string |
| output\_token\_amount | The amount of the output token, decimal normalized. | number |
| spot\_price\_after\_swap | The spot price in the pool after the swap is complete. This is the price ratio a user would get if they made an infinitesimal swap immediately after this one. | number |
| swap\_amount\_usd | The amount of the swap in USD. | number |
| fees\_usd | The fees paid by the user. | number |
| {% endtab %} | | |
| {% endtabs %} | | |
# Lending
Our tables track user positions, pool data, and specific lending-related events.
Key Tables:
* **Pools**: Contains information about different lending pools, including the token types, interest rates, and liquidity.
* **Position Snapshot**: Snapshot of user positions in lending pools, including the amounts borrowed and supplied.
* **Pool Snapshot**: Tracks the state of the pool over time, including Total Value Locked, fees earned, and interest rates.
* **Events**: Tracks lending events like deposits, withdrawals, borrowing, and repayments.
* **Liquidations**: Tracks liquidation events.
{% tabs %}
{% tab title="Pools" %}
| Property | Description | Type |
| -------------------------- | --------------------------------------------------------------------- | ------ |
| chain\_id | The standard id of the chain. | number |
| creation\_block\_number | The block this pool was created in. | number |
| timestamp | The timestamp of the block that this pool was created in. | number |
| underlying\_token\_address | The contract address of the underlying token. | string |
| underlying\_token\_symbol | The symbol of the underlying token. | string |
| receipt\_token\_address | The contract address of the receipt token. | string |
| receipt\_token\_symbol | The symbol of the receipt token. | string |
| pool\_address | The contract address of the pool. | string |
| pool\_type | The type of the pool (collateral\_only, isolated, supply\_pool, cdp). | string |
| {% endtab %} | | |
{% tab title="Position Snapshot" %}
| Property | Description | Type |
| -------------------------- | ----------------------------------------------------------------------------------------------------------------- | ------ |
| timestamp | The timestamp of the snapshot. | number |
| block\_date | The timestamp truncated (ie, YYYY-MM-DD format for daily snapshots and YYYY-MM-DD HH:00:00 for hourly snapshots). | date |
| chain\_id | The standard id of the chain. | number |
| pool\_address | The contract address of the pool. | string |
| underlying\_token\_address | The contract address of the underlying token. | string |
| underlying\_token\_symbol | The symbol of the underlying token. | string |
| user\_address | The address of the user who has the position. | string |
| supplied\_amount | The amount supplied by the user in the underlying token, decimal normalized. | number |
| supplied\_amount\_usd | (Optional) The supplied amount in USD. | number |
| borrowed\_amount | The amount borrowed by the user in the underlying token, decimal normalized. | number |
| borrowed\_amount\_usd | (Optional) The borrowed amount in USD. | number |
| collateral\_amount | (Optional) The amount of collateral-only tokens of this asset, decimal normalized. | number |
| collateral\_amount\_usd | (Optional) The amount of collateral-only tokens in USD. | number |
| {% endtab %} | | |
{% tab title="Pool Snapshot" %}
| Property | Description | Type |
| ----------------------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------- | ------ |
| timestamp | The timestamp of the snapshot. | number |
| block\_date | The timestamp truncated (ie, YYYY-MM-DD format for daily snapshots and YYYY-MM-DD HH:00:00 for hourly snapshots). | date |
| chain\_id | The standard id of the chain. | number |
| pool\_address | The contract address of the pool. | string |
| underlying\_token\_address | The contract address of the underlying token. | string |
| underlying\_token\_symbol | The symbol of the underlying token. | string |
| underlying\_token\_price\_usd | (Optional) The token price of the underlying asset in USD. | number |
| available\_amount | The amount of token's available to borrow (liquidity or net supply or supply - borrow). | number |
| available\_amount\_usd | (Optional) The available amount of token's in this pool in USD. | number |
| supplied\_amount | The total amount of the underlying token supplied in this pool, decimal normalized. | number |
| supplied\_amount\_usd | (Optional) The supplied amount in USD. | number |
| collateral\_amount | (Optional) The amount of collateral only tokens in this pool. | number |
| collateral\_amount\_usd | (Optional) The amount of collateral only tokens in the pool. | number |
| collateral\_factor | The collateral factor of the pool (defined as a decimal percentage, between 0-100). | number |
| supply\_index | The supply index of the pool. | number |
| supply\_apr | The current annual percentage rate for supplied amount, as a decimal percentage. | number |
| borrowed\_amount | The amount of underlying tokens borrowed from this pool in the underlying token, decimal normalized. | number |
| borrowed\_amount\_usd | (Optional) The borrowed amount in USD. | number |
| borrow\_index | The borrow index of the pool. | number |
| borrow\_apr | The current annual percentage rate for borrow, as a decimal percentage. | number |
| total\_fees\_usd | (Optional) The total revenue or fees accrued in this pool during the given snapshot period (ie, user\_fees\_usd + protocol\_fees\_usd = total\_fees\_usd). | number |
| user\_fees\_usd | (Optional) The portion of total revenue or fees accrued to users of the protocol during the given snapshot period. | number |
| protocol\_fees\_usd | (Optional) The portion of total revenue or fees accrued to protocol during the given snapshot period. | number |
| {% endtab %} | | |
{% tab title="Events" %}
| Property | Description | Type |
| ----------------- | ---------------------------------------------------------------------------------------------------------------------------------------- | ------ |
| timestamp | The timestamp of the transaction. | number |
| chain\_id | The standard id of the chain. | number |
| block\_number | The block number of the trade. | number |
| log\_index | The event log. For transactions that don't emit event, create arbitrary index starting from 0. | number |
| transaction\_hash | The hash of the transaction. | string |
| user\_address | The address that initiates the transaction (ie, the transaction signer). | string |
| taker\_address | The address that receives the output of the event (ie, account that receives aTokens in an Aave Deposit). | string |
| pool\_address | The contract address of the pool. | string |
| token\_address | The address of the underlying token that was interacted with (ie, USDC and not aUSDC in Aave). | string |
| amount | The amount of token\_address transacted, decimal normalized. | number |
| amount\_usd | The amount of token\_address transacted, in USD. | number |
| event\_type | The type of lending event, corresponds to the action taken by the user (ie, deposit, withdrawal, borrow, repay, liquidation, flashloan). | string |
| {% endtab %} | | |
{% tab title="Liquidations" %}
| Property | Description | Type |
| ------------------- | ------------------------------------------------------------------------------------------------------- | ------ |
| timestamp | The timestamp of the transaction. | number |
| chain\_id | The standard id of the chain. | number |
| block\_number | The block number of the trade. | number |
| log\_index | The event log. For transactions that don't emit event, create arbitrary index starting from 0. | number |
| transaction\_hash | The hash of the transaction. | string |
| liquidator\_address | The address that initiates the liquidation. | string |
| user\_address | The address that was liquidated. | string |
| pool\_address | The contract address of the pool. | string |
| token\_address | The address of the underlying token that was repaid by the liquidator (ie, USDC and not aUSDC in Aave). | string |
| amount | The amount of token\_address transacted, decimal normalized. | number |
| amount\_usd | The amount of token\_address transacted, in USD. | number |
| profit\_usd | The amount of profit the liquidator made from liquidating user\_address (can be negative). | number |
| {% endtab %} | | |
| {% endtabs %} | | |
# Liquid Staking
Our tables track staking data, user positions, and protocol-level metrics.
Key Tables:
* **Position Snapshot**: Snapshot of the amount of liquid staking tokens held by users.
* **Protocol Snapshot**: Overview of protocol-level metrics like Total Value Locked and fees collected from staking activities.
* **Events**: Tracks events like minting, burning, and transferring liquid staking tokens.\\
{% tabs %}
{% tab title="Position Snapshot" %}
| Property | Description | Type |
| -------------- | ----------------------------------------------------------------------------------------------------------------- | ------ |
| timestamp | The timestamp of the snapshot. | number |
| block\_date | The timestamp truncated (ie, YYYY-MM-DD format for daily snapshots and YYYY-MM-DD HH:00:00 for hourly snapshots). | date |
| chain\_id | Standard chain ID. | number |
| token\_address | The contract address of the LST token. | string |
| token\_symbol | The symbol of the token. | string |
| user\_address | The address of the user holding the LST. | string |
| amount | The amount of LST tokens held in the protocol, decimal normalized. | number |
| amount\_usd | The amount held in USD. | number |
| {% endtab %} | | |
{% tab title="Protocol Snapshot" %}
| Property | Description | Type |
| ------------------------- | ----------------------------------------------------------------------------------------------------------------- | ------ |
| timestamp | The timestamp of the snapshot. | number |
| block\_date | The timestamp truncated (ie, YYYY-MM-DD format for daily snapshots and YYYY-MM-DD HH:00:00 for hourly snapshots). | date |
| chain\_id | Standard chain ID. | number |
| total\_value\_locked\_usd | The total value locked in USD (ie, the value of the liquid staking tokens in the protocol). | number |
| fees\_usd | The fees collected in USD in the given snapshot period. | number |
| {% endtab %} | | |
{% tab title="Events" %}
| Property | Description | Type |
| ----------------- | ---------------------------------------------------------------------------------------------- | ------ |
| timestamp | The timestamp of the transaction. | number |
| chain\_id | The standard id of the chain. | number |
| block\_number | The block number of the trade. | number |
| log\_index | The event log. For transactions that don't emit event, create arbitrary index starting from 0. | number |
| transaction\_hash | The hash of the transaction. | string |
| user\_address | The address that initiates the transaction (ie, the transaction signer). | string |
| from\_address | The address that the event is from (ie, 0x00... address if a Mint). | string |
| to\_address | The address receiving the tokens (ie, the 0x000... address if a Burn). | string |
| token\_address | The contract address of the LST token. | string |
| amount | The amount of token\_address transacted, decimal normalized. | number |
| amount\_usd | The amount of token\_address transacted, in USD. | number |
| event\_type | The type of event, corresponds to the action taken by the user (ie, mint, burn, transfer). | string |
| {% endtab %} | | |
| {% endtabs %} | | |
# NFT Marketplace
Our tables track transfers and ownership of NFTs across various collections.
| Property | Description | Type |
| ------------------------ | ---------------------------------------------------------------------------------------------- | ------ |
| timestamp | The timestamp of the transfer. | number |
| chain\_id | The standard id of the chain. | number |
| block\_number | The block number of the transfer. | number |
| transaction\_hash | The transaction hash of the transfer. | string |
| log\_index | The event log. For transactions that don't emit event, create arbitrary index starting from 0. | number |
| nft\_collection\_address | The contract address of the NFT collection. | string |
| nft\_id | The unique identifier of the NFT. | string |
| sender\_address | The address of the sender of the NFT. | string |
| receiver\_address | The address of the receiver of the NFT. | string |
# Prediction Market
Our data tables track user positions, orders, and various market parameters.
| Property | Description | Type |
| ------------------------ | ------------------------------------------------------------------------------------------------------------------------- | ------ |
| timestamp | The timestamp of the snapshot (in unix time). | number |
| block\_date | The timestamp truncated (ie, YYYY-MM-DD format for daily snapshots and YYYY-MM-DD HH:00:00 for hourly snapshots). | date |
| chain\_id | The standard id of the chain. | number |
| user\_address | The address of the user that owns this order in the snapshot. | string |
| market\_address | The smart contract of the address of the market (if no smart contract, please create a unique identifier for the market). | string |
| order\_id | Identifier for the particular limit order. | number |
| open\_order\_size\_usd | The USD value of the open amount for this particular limit order. | number |
| closed\_order\_size\_usd | The USD value of the open amount for this particular limit order in the interval for the given timestamp. | number |
| locked\_order\_size\_usd | The USD value of the open filled and matched for this particular limit order. | number |
| poll\_open\_timestamp | The timestamp that the poll opens at. | number |
| poll\_close\_timestamp | The timestamp that the poll closes at. | number |
# Yield Aggregator
Our data tables capture key metrics on vault pools, withdrawals, deposits, and user activity.
**Key Tables**:
* **Pools**: Information about vault pools, including underlying tokens, pool address, and receipt tokens.
* **Position Snapshot**: Snapshot of user positions, detailing underlying tokens and their value.
* **Pool Snapshot**: Snapshot of individuals pools, tracking TVL, fees, and other high-level metrics.
* **Events**: Tracks user interactions such as deposits, withdrawals, and changes to positions.Pools
{% tabs %}
{% tab title="Pools" %}
| Property | Description | Type |
| --------------------------- | ------------------------------------------------------------------------------- | ------ |
| chain\_id | The standard chain id. | number |
| timestamp | The timestamp this pool was created. | number |
| creation\_block\_number | The block number that this pool was created. | number |
| underlying\_token\_address | The contract address of the underlying token or deposited token. | string |
| underlying\_token\_index | The index of the underlying token in the smart contract, default 0. | number |
| underlying\_token\_symbol | The symbol of the underlying token token. | string |
| underlying\_token\_decimals | The decimal amount of the underlying token. | number |
| receipt\_token\_address | The contract address of the output or receipt token of this pool, if available. | string |
| receipt\_token\_symbol | The symbol of the receipt token. | string |
| receipt\_token\_decimals | The symbol decimal amount for the receipt token. | number |
| pool\_address | The smart contract address of the pool. | string |
| pool\_symbol | The symbol of the pool. | string |
| {% endtab %} | | |
{% tab title="Position Snapshot" %}
| Property | Description | Type |
| ------------------------------ | ----------------------------------------------------------------------------------------------------------------- | ------ |
| timestamp | The timestamp of the snapshot. | number |
| block\_date | The timestamp truncated (ie, YYYY-MM-DD format for daily snapshots and YYYY-MM-DD HH:00:00 for hourly snapshots). | date |
| chain\_id | The standard chain id. | number |
| pool\_address | The address of the pool this user has a position in. | string |
| user\_address | The address of the user who has a position in the pool. | string |
| underlying\_token\_address | The address of the supplied underlying token. | string |
| underlying\_token\_index | The index in the smart contract of this underlying token, default 0. | number |
| underlying\_token\_amount | The amount of the underlying token that the user deposited, decimal normalized. | number |
| underlying\_token\_amount\_usd | The amount of underlying tokens supplied, in USD. | number |
| total\_fees\_usd | The total amount of revenue and fees paid in this pool in the given snapshot, in USD. | number |
| {% endtab %} | | |
{% tab title="Pool Snapshot" %}
| Property | Description | Type |
| ------------------------------ | ----------------------------------------------------------------------------------------------------------------- | ------ |
| timestamp | The timestamp of the snapshot. | number |
| block\_date | The timestamp truncated (ie, YYYY-MM-DD format for daily snapshots and YYYY-MM-DD HH:00:00 for hourly snapshots). | date |
| chain\_id | The standard chain id. | number |
| underlying\_token\_address | The contract address of the underlying token or deposited token. | string |
| underlying\_token\_index | The index of the underlying token in the smart contract, default 0. | number |
| pool\_address | The address of the pool. | string |
| underlying\_token\_amount | The amount of underlying token supplied in this pool, decimal normalized. | number |
| underlying\_token\_amount\_usd | The amount of underlying tokens supplied in this pool, in USD. | number |
| total\_fees\_usd | The total amount of revenue and fees paid in this pool in the given snapshot, in USD. | number |
| {% endtab %} | | |
{% tab title="Events" %}
| Property | Description | Type |
| -------------------------- | ----------------------------------------------------------------------------------------------- | ------ |
| timestamp | The timestamp of the transaction. | number |
| chain\_id | The standard id of the chain. | number |
| block\_number | The block number of the trade. | number |
| log\_index | The event log. For transactions that don't emit event, create arbitrary index starting from 0. | number |
| transaction\_hash | The hash of the transaction. | string |
| user\_address | The address that initiates the transaction (ie, the transaction signer). | string |
| taker\_address | The address that owns the position (ie, most of the time, it is the same as the user\_address). | string |
| pool\_address | The smart contract address of the pool. | string |
| underlying\_token\_address | The contract address of the underlying token or deposited token. | string |
| amount | The amount of token transacted, decimal normalized. | number |
| amount\_usd | The amount of token transacted, in USD. | number |
| event\_type | The type of event, corresponds to the action taken by the user (ie, deposit, withdrawal). | string |
| {% endtab %} | | |
| {% endtabs %} | | |
# General
For protocols that do not fall into any of the protocol types listed here, they are captured under the Generic Protocol type. Our tables capture key metrics on liquidity, tokens, and user activity.
Key Tables:
* **Pool Snapshot**: Insights into pools, including total value locked and APRs.
* **Protocol Snapshot**: Aggregated data on the protocol’s fees, transactions, and user count.
* **Token Balance Snapshot**: User-level token balance snapshots.
* **General Transactions**: Transactions on the protocol, capturing details about token transfers, fees, and associated addresses.
* **User Transaction Fee Snapshot**: Gas and transaction snapshot data at the user level.
{% tabs %}
{% tab title="Pool Snapshot" %}
| Property | Description | Type |
| ------------------------- | ----------------------------------------------------------------------------------------------------------------- | ------ |
| timestamp | The timestamp of the record. | number |
| block\_date | The timestamp truncated (ie, YYYY-MM-DD format for daily snapshots and YYYY-MM-DD HH:00:00 for hourly snapshots). | date |
| chain\_id | The standard chain id. | number |
| protocol\_type | The type of protocol (ie, Lending, CDP, DEX, Gaming, etc). | string |
| pool\_address | The smart contract address of the pool. | string |
| pool\_name | The name of the pool (ie, pool() in the smart contract, if it exists). | string |
| total\_value\_locked\_usd | The total value locked within this pool in USD. | number |
| supply\_apr | The annual percentage rate of this pool at the snapshot. | number |
| supply\_apy | The annual percentage yield of the pool. | number |
| {% endtab %} | | |
{% tab title="Protocol Snapshot" %}
| Property | Description | Type |
| -------------------- | ----------------------------------------------------------------------------------------------------------------- | ------ |
| timestamp | The timestamp of the snapshot. | number |
| block\_date | The timestamp truncated (ie, YYYY-MM-DD format for daily snapshots and YYYY-MM-DD HH:00:00 for hourly snapshots). | date |
| chain\_id | The standard chain id. | number |
| daily\_active\_users | The number of unique daily active users on this protocol. | number |
| transaction\_count | The number of transactions in this time period. | number |
| fees\_usd | The amount of fees in this given period, decimal normalized. | number |
| {% endtab %} | | |
{% tab title="Token Balance Snapshot" %}
| Property | Description | Type |
| ------------------ | ----------------------------------------------------------------------------------------------------------------- | ------ |
| timestamp | The timestamp of the snapshot. | number |
| block\_date | The timestamp truncated (ie, YYYY-MM-DD format for daily snapshots and YYYY-MM-DD HH:00:00 for hourly snapshots). | date |
| chain\_id | The standard chain id. | number |
| user\_address | The address of the user this snapshot activity is based on. | string |
| token\_address | The smart contract address of the token. | string |
| token\_symbol | The symbol of the token we are getting the balance of. | string |
| token\_amount | The amount of the token at the given snapshot timestamp (decimal normalized). | number |
| token\_amount\_usd | The amount of the token in USD. | number |
| {% endtab %} | | |
{% tab title="General Transactions" %}
| Property | Description | Type |
| --------------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------- | --------- |
| timestamp | The timestamp of the transaction. | timestamp |
| block\_date | A date representation of the timestamp (ie, YYYY-MM-DD HH:MM:SS) | date |
| chain\_id | The standard chain id. | number |
| block\_number | The ordinal block number. | number |
| signer\_address | The transaction signer's address. | varbinary |
| transaction\_hash | The unique identifier for this transaction. | varbinary |
| log\_index | The unique identifier for this transaction. | number |
| event\_name | The string name for the event associated with log\_index, corresponds to the action taken by the user (ie, deposit, withdrawal, borrow, repay, liquidation, flashloan). | string |
| transaction\_fee | The total amount of gas used in the transactions occurring in the given snapshot (in the native gas amount). | number |
| transaction\_fee\_usd | The total amount of gas used in USD terms in the given snapshot. | number |
| {% endtab %} | | |
{% tab title="User Transaction Fee Snapshot" %}
| Property | Description | Type |
| ---------------------- | ----------------------------------------------------------------------------------------------------------------- | ------- |
| timestamp | The timestamp of the snapshot. | number |
| block\_date | The timestamp truncated (ie, YYYY-MM-DD format for daily snapshots and YYYY-MM-DD HH:00:00 for hourly snapshots). | date |
| chain\_id | The standard chain id. | number |
| user\_address | The address of the user this snapshot activity is based on. | string |
| transaction\_count | The number of transactions this user has signed in the given snapshot. | number |
| transaction\_fees | The total amount of gas used in the transactions occurring in the given snapshot (in the native gas amount). | number |
| transaction\_fees\_usd | (Optional, if possible) The total amount of gas used in USD terms in the given snapshot. | vnumber |
| {% endtab %} | | |
| {% endtabs %} | | |
# Incentive Claims
For all protocols that are part of an incentive program, we also track incentive claims to derive incentive-based metrics.
| Property | Description | Type |
| ----------------------- | ----------------------------------------------------------------------------------------------------- | ------ |
| timestamp | The timestamp of the claim. | number |
| chain\_id | The standard chain id. | number |
| transaction\_hash | The hash of the transaction. | string |
| log\_index | The event log. For transactions that don't emit event, create arbitrary index starting from 0. | number |
| transaction\_signer | The address of the account that signed the transaction. | string |
| user\_address | The address of the user who claimed the incentives (could be different from the transaction\_signer). | string |
| claimed\_token\_address | The smart contract address of the claimed token. | string |
| amount | The amount of the token claimed, decimal normalized. | number |
| amount\_usd | The amount of claimed tokens in USD. | number |
| other\_incentive\_usd | Any incentives outside of the claimed token, in this transaction, summed up in USD terms. | number |
# DEX Events
In addition to the core DEX metrics offered in the DEX Protocol tables, we also track and aggregate V2/V3 (Uniswap forks) events of DEXs across multiple EVMs.
Key tables:
* **V2 Mints, Burns, and Syncs**: Events related to LP token minting, burning, and pool synchronization for V2 protocols.
* **V2 Transfers**: Tracks transfers of LP tokens between addresses on V2 DEX protocols.
* **V3 Events**: Records of liquidity position changes, including minting, burning, and transfers, specific to V3 protocols.
* **V3 Transfers**: Tracks transfers of LP tokens between addresses on V3 DEX protocols.
{% tabs %}
{% tab title="V2 Mints" %}
| Property | Description | Type |
| -------------------------- | ---------------------------------------------------------------------------------------------- | ------ |
| timestamp | The timestamp of the record. | number |
| chain\_id | The standard id of the chain. | number |
| block\_number | The block number of the mint. | number |
| log\_index | The event log. For transactions that don't emit event, create arbitrary index starting from 0. | number |
| transaction\_hash | The hash of the transaction. | string |
| transaction\_from\_address | The address that initiates the transaction (ie, the transaction signer). | string |
| from\_address | The from address of the event (ie, the from field in a transfer). | string |
| to\_address | The to address of the event (ie, the to field in a transfer). | string |
| pool\_address | The contract address of the pool. | string |
| token0\_address | The contract address of token0. | string |
| token0\_amount | The amount of token0. | number |
| token1\_address | The contract address of token1. | string |
| token1\_amount | The amount of token1. | number |
| mint\_amount | The amount of LP token minted by the trader, decimal normalized. | number |
| mint\_amount\_usd | (Optional) The amount of the mint in USD. | number |
| {% endtab %} | | |
{% tab title="V2 Burns" %}
| Property | Description | Type |
| -------------------------- | ---------------------------------------------------------------------------------------------- | ------- |
| timestamp | The timestamp of the transaction. | number |
| chain\_id | The standard id of the chain. | number |
| block\_number | The block number of the trade. | number |
| log\_index | The event log. For transactions that don't emit event, create arbitrary index starting from 0. | number |
| transaction\_hash | The hash of the transaction. | string |
| transaction\_from\_address | The address that initiates the transaction (ie, the transaction signer). | string |
| from\_address | The from address of the event (ie, the from field in a transfer). | string |
| to\_address | The to address of the event (ie, the to field in a transfer). | string |
| pool\_address | The contract address of the pool. | string |
| token0\_address | The contract address of token0. | string |
| token0\_amount | The amount of token0. | number |
| token1\_address | The contract address of token1. | string |
| token1\_amount | The amount of token1. | number |
| burn\_amount | The amount of LP tokens burned, decimal normalized. | number |
| burn\_amount\_usd | (Optional) The amount of the burn in USD. | vnumber |
| {% endtab %} | | |
{% tab title="V2 Sync" %}
| Property | Description | Type |
| ----------------- | ---------------------------------------------------------------------------------------------- | ------ |
| timestamp | The timestamp of the transaction. | number |
| chain\_id | The standard id of the chain. | number |
| block\_number | The block number of the trade. | number |
| log\_index | The event log. For transactions that don't emit event, create arbitrary index starting from 0. | number |
| transaction\_hash | The hash of the transaction. | string |
| pool\_address | The contract address of the pool. | string |
| token0\_address | The contract address of token0. | string |
| token0\_amount | The amount of token0. | number |
| token1\_address | The contract address of token1. | string |
| token1\_amount | The amount of token1. | number |
| {% endtab %} | | |
{% tab title="V2 Transfers" %}
| Property | Description | Type |
| -------------------------- | ---------------------------------------------------------------------------------------------- | ------ |
| timestamp | The timestamp of the transaction. | number |
| chain\_id | The standard id of the chain. | number |
| block\_number | The block number of the trade. | number |
| log\_index | The event log. For transactions that don't emit event, create arbitrary index starting from 0. | number |
| transaction\_hash | The hash of the transaction. | string |
| transaction\_from\_address | The address that initiates the transaction (ie, the transaction signer). | string |
| from\_address | The address that sends the LP token. | string |
| to\_address | The address that receives the LP token. | string |
| pool\_address | The contract address of the pool. | string |
| pool\_token\_balance | The balance of the pool token, decimal normalized. | number |
| {% endtab %} | | |
{% tab title="V3 Events" %}
| Property | Description | Type |
| -------------------------- | ---------------------------------------------------------------------------------------------- | ------ |
| timestamp | The timestamp of the transaction. | number |
| chain\_id | The standard id of the chain. | number |
| block\_number | The block number of the trade. | number |
| log\_index | The event log. For transactions that don't emit event, create arbitrary index starting from 0. | number |
| transaction\_hash | The hash of the transaction. | string |
| transaction\_from\_address | The address that initiates the transaction (ie, the transaction signer). | string |
| event\_type | The action type of the event (ie, mint, burn). | string |
| pool\_address | The contract address of the pool. | string |
| tick\_lower | The lower tick of the liquidity position. | number |
| tick\_upper | The upper tick of the liquidity position. | number |
| current\_tick | The current tick of the liquidity pool. | number |
| tick\_spacing | The tick spacing of the liquidity pool. | number |
| nft\_token\_id | The token ID of the NFT that represents the liquidity position | number |
| token0\_address | The contract address of token0. | string |
| token0\_amount | The amount of token0(raw token amount). | number |
| token1\_address | The contract address of token1. | string |
| token1\_amount | The amount of token1(raw token amount). | number |
| token\_fees | The amount of token fees. | number |
| amount\_liquidity | The amount of liquidity. | number |
| {% endtab %} | | |
{% tab title="V3 Transfers" %}
| Property | Description | Type |
| -------------------------- | ---------------------------------------------------------------------------------------------- | ------ |
| timestamp | The timestamp of the transaction. | number |
| chain\_id | The standard id of the chain. | number |
| block\_number | The block number of the trade. | number |
| log\_index | The event log. For transactions that don't emit event, create arbitrary index starting from 0. | number |
| transaction\_hash | The hash of the transaction. | string |
| transaction\_from\_address | The address that initiates the transaction (ie, the transaction signer). | string |
| from\_address | The from address of the event (ie, the from field in a transfer). | string |
| to\_address | The to address of the event (ie, the to field in a transfer). | string |
| event\_type | The action type of the event (ie, transfer). | string |
| pool\_address | The contract address of the pool. | string |
| tick\_lower | The lower tick. | number |
| tick\_upper | The upper tick. | number |
| tick\_spacing | The tick spacing. | number |
| token0\_address | The contract address of token0. | string |
| token0\_amount | The amount of token0. | number |
| token1\_address | The contract address of token1. | string |
| token1\_amount | The amount of token1. | number |
| token\_fees | The amount of token fees. | number |
| amount\_liquidity | The amount of liquidity. | number |
| {% endtab %} | | |
| {% endtabs %} | | |
# ERC20 Transfers
We collect data on the minting, transferring, and burning of ERC20 tokens across EVM ecosystems.
| Property | Description | Type |
| ----------------------- | ---------------------------------------------------------------------------------------------- | ------ |
| timestamp | The UNIX timestamp of the block associated with the transaction. | number |
| block\_number | The block number for the transaction | number |
| chain\_id | The standard chain id. | number |
| from\_user\_address | The address of the user sending the erc-20 transfer. | string |
| to\_user\_address | The address of the user receiving the erc-20 transfer. | string |
| token\_transfer\_amount | The amount of the token transferred (decimal normalized). | number |
| token\_address | The smart contract address of the token. | string |
| token\_symbol | The symbol of the token we are getting the balance of. | string |
| log\_index | The event log. For transactions that don't emit event, create arbitrary index starting from 0. | number |
| transaction\_hash | The hash of the transaction. | string |
# Airdrop Data
The following table capture detailed data on airdrop events, the tokens distributed, and user participation.
| Property | Description | Type |
| ----------------------- | ---------------------------------------------------------------------------------------------- | ------ |
| airdrop\_timestamp | The timestamp the airdrop was given to the user. | number |
| user\_address | The address of the user claiming the airdrop. | string |
| claim\_timestamp | The timestamp of when the user claimed the airdrop. | number |
| transaction\_hash | The hash of the transaction. | string |
| log\_index | The event log. For transactions that don't emit event, create arbitrary index starting from 0. | number |
| airdrop\_token\_address | The smart contract address of the airdropped token. | string |
| airdrop\_token\_symbol | The symbol of the token being airdropped. | string |
| token\_amount | The amount of each token airdropped, decimal normalized. | number |
| amount\_usd | The USD value of the airdropped tokens. | number |
# Global Token Prices
Token prices in USD at the hourly and 1-minute level across chains
| Property | Description | Type |
| ----------------- | ----------------------------------- | --------- |
| chain | The chain the token is on | string |
| contract\_address | The token contract address | string |
| symbol | The token symbol (ex. UNI, COMP) | string |
| timestamp | Timestamp | timestamp |
| price\_usd | USD value of the token | double |
| decimals | The amount of decimals in the token | int |
# Sybil
Sybil attacks—where a single actor controls multiple wallets to exploit incentive structures—can undermine incentives. OpenBlock Labs employs advanced algorithms to detect and mitigate Sybil activity, ensuring the fair distribution of rewards in incentive programs like airdrops and liquidity mining campaigns.
#### Detection Methodology
This is a high level overview of the OpenBlock Sybil Methodology:
1. **Graph Construction**: We create an Asset Transfer Graph (ATG) that helps identify clusters of wallets that may be controlled by the same actor.
2. **Behavioral Analysis**: Once potential Sybil clusters are detected, we analyze the wallets in each cluster—looking for high level similarities and anomalies such as non-human type behavior.
3. **Quality Assurance**: Our algorithms produce negligible false positive rate. However, to reduce it further, we apply both automated and manual QA to our results. We always prioritize precision.
# User Labeling
User labeling helps identify and categorize users based on their on-chain behavior, enabling more targeted and effective incentive strategies. OpenBlock Labs uses advanced analysis techniques to understand user engagement and long-term value.
#### **Methodology**
At a high level, OpenBlock’s user labeling methodology involves analyzing transactional patterns to profile users based on their activities, such as liquidity provision, trading, and borrowing. By examining the frequency and volume of these interactions, we can assign labels to users that reflect their commitment and involvement in the protocol.
We also consider behavioral metrics like user net worth and engagement level, helping us assess the potential long-term value of each participant.
# User Retention Prediction
Accurate predictions of user retention are critical for the success of incentive programs. OpenBlock Labs uses sophisticated models to predict how long users are likely to remain engaged with a protocol, helping protocols better allocate rewards to retain high-value participants.
#### **Methodology**
Our retention prediction model analyzes user behavior over time, identifying patterns that suggest whether a user is likely to remain active or become inactive. We look at factors such as transaction frequency, asset holding patterns, and overall protocol engagement to forecast retention rates.
By focusing on metrics like TVL-days (the duration assets are locked in the protocol) and user engagement levels, we predict long-term user retention with a high degree of accuracy. This enables protocols to tailor their incentives, ensuring they retain users who provide ongoing value and avoid wasting resources on users likely to churn.
# Mercenary Strategy Identification
In DeFi, some users adopt mercenary strategies, prioritizing short-term profits over long-term commitment to a protocol. These users often engage in behaviors that are net negative to and reduce the effectiveness of reward programs. OpenBlock Labs helps identify these mercenary tactics and adjust incentives accordingly.
#### **Methodology**
OpenBlock's approach to identifying mercenary strategies begins with analyzing user behavior patterns that indicate a focus on profit maximization—such as frequent arbitrage trading or moving liquidity to chase the highest APRs across protocols. These behaviors often signal users who are not invested in the long-term success of the protocol but rather in short-term gains.
Once we identify these patterns, we can adjust the reward structures to avoid incentivizing transient users. By recognizing mercenary strategies, we can optimize reward programs to ensure they attract and retain users who add real, lasting value to the ecosystem/protocol.
# Point Campaigns
## What is a point system?
A point system is a non-liquid incentive mechanism designed to foster growth within an ecosystem. Points act as a flexible tool to reward participants without the need to immediately issue or distribute liquid tokens, which could affect ecosystem dynamics prematurely. In decentralized finance (DeFi), points can incentivize users to contribute to the ecosystem by providing liquidity, engaging in DeFi, or participating in other valuable activities.
The primary objective of a point system is to define and measure the alignment of participant's actions with the ecosystem's objectives. This involves creating metrics and methodologies that encourage behaviors beneficial to the ecosystem's long-term health. In the early stages of a DeFi ecosystem’s lifecycle, it is crucial to attract and retain liquidity that is "useful". This "useful liquidity" is often defined as the holding and active management of assets and positions that are integral to the ecosystem's operations, such as holding core tokens, stablecoins, or strategic partner assets, and supplying liquidity across DeFi verticals.
## Why use points?
Using points as a basis for incentive allocation has become increasingly popular due to several key advantages they offer to ecosystem builders:
#### Pre-token Incentives
Points allow for the rewarding of early users and contributors without the immediate need to distribute liquid tokens. This helps to manage token supply and demand more effectively and prevents early price volatility.
#### Responsiveness to User Behavior and Objective Alignment
Points can be distributed in a manner that aligns with the evolving goals of the ecosystem. For example, if increasing TVL across DeFi verticals becomes a priority, point allocations can be adjusted to reward productive LP behavior.
#### Flexibility in Airdrop Allocations
Points systems offer the flexibility to design token distributions that are based on meaningful participation rather than mere presence in the ecosystem. By rewarding points for specific behaviors, projects can ensure that token distributions are more likely to go to active and engaged users who have contributed to the ecosystem's growth. Further, the ecosystem is not committed at early stages to any particular point-to-token methodology and can adjust their distribution approach based on the measured behavior of participants.
# Point Methodologies
The OpenBlock Labs (OBL) point system is designed with the following key principles:
#### TVL-Time Integration
The OBL point system heavily incorporates Total Value Locked (TVL) over time as a measure of useful liquidity. By combining the amount of liquidity provided with the duration it remains within the ecosystem, the system rewards sustained contributions. Liquidity is denominated in USD to provide incentives commensurate to the market value of assets deployed.
#### Incentivizing Useful Liquidity
Not all liquidity is equal. The OBL point system emphasizes the importance of "useful liquidity," which refers to assets and liquidity positions that have a high impact on the ecosystem’s usability and growth. An objective function is used for each participating protocol to measure the useful liquidity supplied there.
#### Manipulation Resistance
OBL employs multiple measures to prevent the gamification of its incentive programs. Points are economically bonded to the quality of liquidity held, discouraging short-term or superficial contributions. Protocol-specific methodologies are in place to mitigate risks such as recursive borrowing and out-of-range liquidity provision, ensuring that only genuinely beneficial activities are rewarded
#### Multiplier Mechanisms
To ensure that the system remains adaptive and aligned with the ecosystem's goals, multipliers are applied to point calculations. These multipliers can emphasize or de-emphasize certain dimensions, such as the type of asset, protocol, or duration of liquidity provision. This allows the system to remain dynamic and responsive to the ecosystem's needs.