DEX Trades
Raw trading data from major decentralized exchanges:Sample Files |
---|
Download |
DEX Liquidity Events
Liquidity pool addition and removal events:Sample Files |
---|
Download |
Lending Protocol Data
Protocol Events
Raw lending, borrowing, and liquidation events from major DeFi protocols:Protocol | Blockchain | Sample Files |
---|---|---|
Aave v2 | Ethereum | Download |
Aave v3 | Ethereum | Download |
Aave v3 | Arbitrum | Download |
Aave v2 | Avalanche | Download |
Aave v3 | Avalanche | Download |
Aave v3 | Optimism | Download |
Compound v2 | Ethereum | Download |
MakerDAO | Ethereum | Download |
Daily Asset Metrics
Aggregated daily metrics for individual assets across protocols:Protocol | Blockchain | Sample Files |
---|---|---|
Aave v2 | Ethereum | Download |
Aave v3 | Ethereum | Download |
Compound v2 | Ethereum | Download |
Compound v3 | Ethereum | Download |
MakerDAO | Ethereum | Download |
Daily Protocol Metrics
Aggregated daily metrics for entire protocols:Protocol | Blockchain | Sample Files |
---|---|---|
Aave v2 | Ethereum | Download |
Aave v3 | Ethereum | Download |
Compound v2 | Ethereum | Download |
Compound v3 | Ethereum | Download |
MakerDAO | Ethereum | Download |
Daily Stablecoin Metrics
Focused metrics on stablecoin usage within lending protocols:Protocol | Blockchain | Sample Files |
---|---|---|
Aave v2 | Ethereum | Download |
Aave v3 | Ethereum | Download |
Compound v2 | Ethereum | Download |
Compound v3 | Ethereum | Download |
MakerDAO | Ethereum | Download |
Data Field Descriptions
DEX Trade Fields
Comprehensive trading data from decentralized exchanges:Field | Description |
---|---|
exchange | The name of the DEX (e.g., Uniswap, SushiSwap, PancakeSwap) |
timestamp | Timestamp when Amberdata received the data |
timestampNanoseconds | The nanosecond part of the timestamp where applicable |
isBuy | Indicates the direction of the trade: true means buy the base, sell the quote; false means sell the base, buy the quote |
price | The actual price at which the asset was traded (including slippage, but not fees) |
volume | The total amount of that asset that was traded |
tradeId | The exchange provided id of the trade |
logIndex | The index of the log within the transaction which included this trade event |
pairAddress | The address of the trading pair contract |
amountInBase | The amount of the base asset accepted in the trade |
amountInQuote | The amount of the quote asset accepted in the trade |
amountOutBase | The amount of the base asset returned in the trade |
amountOutQuote | The amount of the quote asset returned in the trade |
fromAddress | The address which initiated the trade (sender) |
toAddress | The recipient of the trade (receiver) |
DEX Liquidity Fields
Liquidity pool events and changes:Field | Description |
---|---|
exchangeName | The name of the DEX |
pairAddress | The address of the trading pair contract |
baseAddress | The address of the first underlying asset behind the pair |
quoteAddress | The address of the second underlying asset behind the pair |
address | The address of the asset for which this liquidity event is for (either base or quote address) |
timestamp | The timestamp associated with this record |
transactionHash | The hash of the transaction which included this liquidity event |
amount | The new amount of the underlying asset after this liquidity event |
liquidityPrice | The new price of the underlying asset after this liquidity event |
Lending Protocol Fields
Protocol Events (Aave v2 & v3):Field | Description |
---|---|
account | The EOA (Externally Owned Account) that triggered this event |
action | The event that the EOA triggered in the smart contract (deposit, withdraw, borrow, repay, liquidate, etc.) |
amountNative | The amount of the asset in native units, normalized with the asset’s decimals |
amountUSD | The amount of the asset in US dollars |
assetId | The smart contract address of the asset |
assetSymbol | The human readable, abbreviated name of the asset (e.g., ETH, USDC, DAI) |
blockNumber | The integer value identifying the block |
borrowRate | The interest rate for borrowing the asset |
borrowRateMode | Indicates whether the borrowRate is stable or variable |
liquidatee | The EOA being liquidated because they are under-collateralized |
liquidator | The EOA that is triggering the liquidation |
collateralAssetId | The smart contract address of the collateral asset |
collateralAssetSymbol | The human readable name of the collateral asset |
principalAssetId | The smart contract address of the borrowed asset |
principalAssetSymbol | The human readable name of the borrowed asset |
profitUSD | The amount in US dollars that the liquidator earned from triggering a liquidation |
timestamp | Indicates the datetime or epoch milliseconds of when the event took place |
transactionHash | The unique identifier of the transaction |
Use Cases and Applications
- DEX Trading Analysis: Study arbitrage opportunities, slippage patterns, and trading efficiency
- Liquidity Pool Analysis: Calculate yield farming returns and impermanent loss patterns
- Lending Protocol Analysis: Monitor interest rates, liquidations, and protocol health
- Protocol Comparison: Compare efficiency and safety across different DeFi protocols
- Yield Strategies: Optimize lending, borrowing, and liquidity provision strategies
- Risk Assessment: Monitor lending protocol health and liquidation cascade risks
- Stablecoin Research: Analyze peg stability and stablecoin usage across protocols
Supported Networks and Protocols
- DEX Protocols: Uniswap, SushiSwap, PancakeSwap, Balancer, Curve
- Lending Protocols: Aave v2/v3, Compound v2/v3, MakerDAO
- Cross-Chain Coverage: Multi-chain deployments across Ethereum, Arbitrum, Optimism, Polygon, Avalanche
Getting Started
Data Quality and Processing
Data Freshness
- Real-time Processing: Near real-time data ingestion and processing
- Historical Completeness: Complete historical data from network/protocol genesis
- Cross-Chain Consistency: Standardized field formats across all networks
- Quality Assurance: Automated validation and error checking
Technical Specifications
- File Formats: Apache Parquet and CSV formats optimized for analytics
- Compression: Efficient storage with fast query performance
- Partitioning: Organized by date and blockchain/protocol for optimal access patterns
- Schema Evolution: Backward-compatible updates as networks and protocols evolve
Access Information
Amazon S3 Access
- Requirements: AWS credentials for Requester Pays bucket access
- Setup: Include
x-amz-request-payer: requester
in all requests - Contact: Your Account Executive for credential provisioning
Support Resources
- Technical Documentation: Comprehensive guides for blockchain and DeFi data
- Sample Analysis: Python notebooks with common analysis patterns
- Integration Support: Assistance with data pipeline setup and optimization
- Research Community: Access to blockchain and DeFi research insights