Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
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
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.
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.
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.
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.
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.
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.
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.
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.
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.
The OpenBlock Labs (OBL) point system is designed with the following key principles:
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.
The following table capture detailed data on airdrop events, the tokens distributed, and user participation.
For all protocols that are part of an incentive program, we also track incentive claims to derive incentive-based metrics.
Token prices in USD at the hourly and 1-minute level across chains
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.
This is a high level overview of the OpenBlock Sybil Methodology:
Graph Construction: We create an Asset Transfer Graph (ATG) that helps identify clusters of wallets that may be controlled by the same actor.
Using points as a basis for incentive allocation has become increasingly popular due to several key advantages they offer to ecosystem builders:
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.
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.
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.
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.
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
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.
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.
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.
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
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
timestamp
The timestamp of the claim.
number
chain_id
The standard chain id.
number
transaction_hash
The hash of the transaction.
string
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
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
Timestamp
timestamp
price_usd
USD value of the token
double
decimals
The amount of decimals in the token
int
chain
The chain the token is on
string
contract_address
The token contract address
string
symbol
The token symbol (ex. UNI, COMP)
string
timestamp
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.
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.
Our data tables track user positions, orders, and various market parameters.
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
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.\
We collect data on the minting, transferring, and burning of ERC20 tokens across EVM ecosystems.
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
Our tables track transfers and ownership of NFTs across various collections.
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
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
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
fees_usd
The fees collected in USD in the given snapshot period.
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
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.
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).
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.
string
number
number
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
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
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.
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.
decimals
The decimals name of the token, from the eth_call decimals().
number
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.
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.
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.
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
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
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.
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.
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
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
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.\
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.
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
number
fees_usd
The fees (ie, total revenue generated in the protocol) collected in USD, during the snapshot period.
number
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
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
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
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
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
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.
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.
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.
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
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
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
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
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
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
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
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.
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.
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.
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
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
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
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
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
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
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
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.
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.
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.
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
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.
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.
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.
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).
Events: Tracks lending events like deposits, withdrawals, borrowing, and repayments.
Liquidations: Tracks liquidation events.
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
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
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
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
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
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
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
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
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
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
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
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
number
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.
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.
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.
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.
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.
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.
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.
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.
number
string
string
string
number
string
string
string
transaction_count
The number of transactions in this time period.
number
fees_usd
The amount of fees in this given period, decimal normalized.
number
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
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
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
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
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.
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.
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
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
number
block_number
The address of the user this snapshot activity is based on.
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
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
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
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
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
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.
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.
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.
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.
string
string
number
number
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.
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
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.
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.
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.
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.
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.
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
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
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
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
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
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