Liquidity Events
Availability
This collection is available for the Ethereum, Polygon, Arbitrum, and Base.
Points-of-Presence | Tables |
---|---|
eu-west-1 |
|
Methodology
The table is built by extracting data from DEXes activity and then normalizing it to fit a unified data model.
We currently support the following DEXes:
Uniswap V2
Uniswap V3
Curve
We extract data from any contract compatible with one of the above DEXes ABI.
It means that any DEXes that forked or tried to be compatible at the ABI level with these contracts will be indexed automatically.
Table Schema
Column Name | Column Type | Description |
---|---|---|
chain_name | string | Name of the chain ( |
chain_network_name | string | name of the network ( |
block_hash | string | Block hash encoded as binary string |
block_number | uint64 | Block height |
transaction_index | uint64 | The index of the transaction in the block |
timestamp | datetime | UNIX timestamp for when the block was collated |
decoder_name | string | The internal name of the decoder used to decode this trade (uniswap_v2_liquidity_event, curve_liquidity_event) |
type | string | Either |
factory | string | The address of the DEX factory contract (if any) |
contract | string | The address of the DEX pair/pool |
provider | string | The address of the account that provided or withdraw the liquidity |
raw_amounts | map(string, uint256) | A map of token amounts provided or withdrawn |
amounts | map(string, float64) | A map of token amounts provided or withdrawn. The amount of tokens are divided by |
Usage
The query below makes use of the defi_liquidity_events_ethereum_mainnet_v1
to chart the daily delta of liquidity for each token of the famous Curve 3Pool (0xbEbc44782C7dB0a1A60Cb6fe97d0b483032FF1C7).
Last updated