Comprehensive data, including DeFi protocol analytics (covering DEX trading, lending protocols, liquidity events, lending protocol events, stablecoin metrics, and more) across multiple networks, delivered via Amazon S3 for advanced research and DeFi strategy development.

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:
ProtocolBlockchainSample Files
Aave v2EthereumDownload
Aave v3EthereumDownload
Aave v3ArbitrumDownload
Aave v2AvalancheDownload
Aave v3AvalancheDownload
Aave v3OptimismDownload
Compound v2EthereumDownload
MakerDAOEthereumDownload

Daily Asset Metrics

Aggregated daily metrics for individual assets across protocols:
ProtocolBlockchainSample Files
Aave v2EthereumDownload
Aave v3EthereumDownload
Compound v2EthereumDownload
Compound v3EthereumDownload
MakerDAOEthereumDownload

Daily Protocol Metrics

Aggregated daily metrics for entire protocols:
ProtocolBlockchainSample Files
Aave v2EthereumDownload
Aave v3EthereumDownload
Compound v2EthereumDownload
Compound v3EthereumDownload
MakerDAOEthereumDownload

Daily Stablecoin Metrics

Focused metrics on stablecoin usage within lending protocols:
ProtocolBlockchainSample Files
Aave v2EthereumDownload
Aave v3EthereumDownload
Compound v2EthereumDownload
Compound v3EthereumDownload
MakerDAOEthereumDownload

Data Field Descriptions

DEX Trade Fields

Comprehensive trading data from decentralized exchanges:
FieldDescription
exchangeThe name of the DEX (e.g., Uniswap, SushiSwap, PancakeSwap)
timestampTimestamp when Amberdata received the data
timestampNanosecondsThe nanosecond part of the timestamp where applicable
isBuyIndicates the direction of the trade: true means buy the base, sell the quote; false means sell the base, buy the quote
priceThe actual price at which the asset was traded (including slippage, but not fees)
volumeThe total amount of that asset that was traded
tradeIdThe exchange provided id of the trade
logIndexThe index of the log within the transaction which included this trade event
pairAddressThe address of the trading pair contract
amountInBaseThe amount of the base asset accepted in the trade
amountInQuoteThe amount of the quote asset accepted in the trade
amountOutBaseThe amount of the base asset returned in the trade
amountOutQuoteThe amount of the quote asset returned in the trade
fromAddressThe address which initiated the trade (sender)
toAddressThe recipient of the trade (receiver)

DEX Liquidity Fields

Liquidity pool events and changes:
FieldDescription
exchangeNameThe name of the DEX
pairAddressThe address of the trading pair contract
baseAddressThe address of the first underlying asset behind the pair
quoteAddressThe address of the second underlying asset behind the pair
addressThe address of the asset for which this liquidity event is for (either base or quote address)
timestampThe timestamp associated with this record
transactionHashThe hash of the transaction which included this liquidity event
amountThe new amount of the underlying asset after this liquidity event
liquidityPriceThe new price of the underlying asset after this liquidity event

Lending Protocol Fields

Protocol Events (Aave v2 & v3):
FieldDescription
accountThe EOA (Externally Owned Account) that triggered this event
actionThe event that the EOA triggered in the smart contract (deposit, withdraw, borrow, repay, liquidate, etc.)
amountNativeThe amount of the asset in native units, normalized with the asset’s decimals
amountUSDThe amount of the asset in US dollars
assetIdThe smart contract address of the asset
assetSymbolThe human readable, abbreviated name of the asset (e.g., ETH, USDC, DAI)
blockNumberThe integer value identifying the block
borrowRateThe interest rate for borrowing the asset
borrowRateModeIndicates whether the borrowRate is stable or variable
liquidateeThe EOA being liquidated because they are under-collateralized
liquidatorThe EOA that is triggering the liquidation
collateralAssetIdThe smart contract address of the collateral asset
collateralAssetSymbolThe human readable name of the collateral asset
principalAssetIdThe smart contract address of the borrowed asset
principalAssetSymbolThe human readable name of the borrowed asset
profitUSDThe amount in US dollars that the liquidator earned from triggering a liquidation
timestampIndicates the datetime or epoch milliseconds of when the event took place
transactionHashThe 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

# Load DEX trade data
dex_trades = pd.read_parquet('dex_trades_sample.parquet')

# Analyze trading volume by exchange
volume_by_exchange = dex_trades.groupby('exchange')['volume'].sum()
print("Trading volume by DEX:")
print(volume_by_exchange)

# Load Aave protocol events
aave_events = pd.read_parquet('aave_protocol_events_sample.parquet')

# Analyze lending vs borrowing activity
activity_by_action = aave_events.groupby('action')['amountUSD'].sum()
print("\nLending protocol activity:")
print(activity_by_action)

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