Blockchain and DeFi Analytics

Comprehensive on-chain data including blockchain fundamentals (blocks, transactions, logs, balances) and DeFi protocol analytics (DEX trading, lending protocols) across multiple networks delivered via Amazon S3 for advanced blockchain research and DeFi strategy development.

Blockchain Data

Transaction Data

Blockchain	Sample Files
Bitcoin	Download
Ethereum	Download
Arbitrum	Download
BNB Chain	Download
Polygon	Download

Transaction Logs

Blockchain	Sample Files
Ethereum	Download
Arbitrum	Download
BNB Chain	Download
Polygon	Download

Account Balances

Blockchain	Sample Files
Ethereum	Download
Arbitrum	Download
BNB Chain	Download
Polygon	Download

Block Data

Blockchain	Sample Files
Ethereum	Download
Arbitrum	Download
BNB Chain	Download
Polygon	Download

DeFi Data

DEX (Decentralized Exchange) Data

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

Blockchain Data Fields

Transaction Fields

Ethereum-based Chains (Ethereum, Arbitrum, BNB Chain, Polygon):

Field	Description
hash	The transaction hash
blockNumber	The block number containing the transaction
blockHash	The hash of the block containing the transaction
transactionIndex	The position of the transaction within the block
from	Transaction sender address
to	Transaction recipient address
value	Amount transferred in Wei
gas	Gas limit set for the transaction
gasPrice	Gas price in Wei per gas unit
gasUsed	Actual gas consumed by the transaction
cumulativeGasUsed	Total gas used up to and including this transaction in the block
status	Transaction success (1) or failure (0) status
timestamp	Block timestamp when transaction was confirmed
input	Smart contract function call data
contractAddress	Address of created contract (if transaction creates a contract)
nonce	The number of transactions sent by the sender address
type	Transaction type: 0 (legacy), 2 (EIP-1559)

Bitcoin/UTXO Chains:

Field	Description
hash	The transaction hash
blockNumber	The block number containing the transaction
timestamp	Block timestamp when transaction was confirmed
value	Total transaction input value minus transaction fee
adjustedValue	Total amount received by the recipient address
fees	The transaction fee paid to miners
isCoinbase	Indicates if this is a coinbase transaction (mining reward)
transactionInputs	Array of transaction inputs with addresses and amounts
transactionOutputs	Array of transaction outputs with addresses and amounts

Transaction Logs Fields

Smart contract event data for Ethereum-based chains:

Field	Description
address	The contract address that emitted the log
topics	Array of indexed event parameters (up to 4 topics)
data	Non-indexed event parameters (ABI-encoded)
blockNumber	Block number containing the transaction
transactionHash	Hash of the transaction that generated this log
logIndex	Position of this log within the transaction

DeFi Data Fields

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

Blockchain Analytics Applications

Transaction Analysis: Monitor and analyze on-chain activity patterns across multiple chains
Address Tracking: Follow wallet behaviors and fund flows for compliance and research
Smart Contract Analysis: Study contract interactions using transaction logs
Network Health: Monitor blockchain performance and congestion patterns
Compliance: AML/KYC analysis and regulatory reporting
MEV Research: Study Maximum Extractable Value opportunities and front-running patterns
Cross-Chain Analysis: Compare activity across different blockchain networks

DeFi Analytics 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

Cross-Domain Integration

On-Chain to DeFi Flow: Track how raw blockchain activity feeds into DeFi protocols
Gas Analysis: Study gas usage patterns across different DeFi activities
Address Classification: Identify DeFi protocol addresses and user behavior patterns
Market Impact: Correlate on-chain activity with DeFi protocol performance
Ecosystem Health: Monitor the entire DeFi ecosystem from blockchain fundamentals to protocol metrics

Supported Networks and Protocols

Blockchain Networks

Bitcoin: UTXO-based transactions, mempool data, and block information
Ethereum: Smart contracts, EVM transactions, and comprehensive event logs
Litecoin: UTXO transactions with faster block times
Arbitrum: Ethereum Layer 2 with optimistic rollup technology
Polygon: Ethereum-compatible sidechain with fast, low-cost transactions
BNB Chain: Binance Smart Chain with Ethereum-compatible smart contracts

DeFi 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

Basic Blockchain Analysis

import pandas as pd

# Load Ethereum transaction data
eth_txns = pd.read_csv('ETH_transactions_sample.csv')

# Analyze transaction patterns
print("Transaction volume by hour:")
eth_txns['hour'] = pd.to_datetime(eth_txns['timestamp']).dt.hour
volume_by_hour = eth_txns.groupby('hour')['value'].sum()
print(volume_by_hour)

# Gas usage analysis
print("\nAverage gas usage:")
avg_gas = eth_txns['gasUsed'].mean()
print(f"Average gas used: {avg_gas:.0f}")

DeFi Protocol Analysis

# 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)

Cross-Domain Analysis

# Combine blockchain and DeFi data
# Analyze gas costs for DeFi activities
def analyze_defi_gas_costs():
    # Load transaction logs for DeFi protocols
    defi_logs = pd.read_csv('ETH_transaction_logs_sample.csv')

    # Filter for major DeFi protocols
    aave_address = '0x...'  # Aave protocol address
    uniswap_address = '0x...'  # Uniswap protocol address

    defi_protocols = defi_logs[defi_logs['address'].isin([aave_address, uniswap_address])]

    # Join with transaction data to get gas costs
    transactions = pd.read_csv('ETH_transactions_sample.csv')
    defi_gas = defi_protocols.merge(transactions, on='transactionHash')

    # Calculate average gas costs by protocol
    gas_by_protocol = defi_gas.groupby('address')['gasUsed'].mean()
    print("Average gas usage by DeFi protocol:")
    print(gas_by_protocol)

analyze_defi_gas_costs()

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

Blockchain and DeFi Analytics

Blockchain Data

Transaction Data

Transaction Logs

Account Balances

Block Data

DeFi Data

DEX (Decentralized Exchange) Data

DEX Trades

DEX Liquidity Events

Lending Protocol Data

Protocol Events

Daily Asset Metrics

Daily Protocol Metrics

Daily Stablecoin Metrics

Data Field Descriptions

Blockchain Data Fields

Transaction Fields

Transaction Logs Fields

DeFi Data Fields

DEX Trade Fields

DEX Liquidity Fields

Lending Protocol Fields

Use Cases and Applications

Blockchain Analytics Applications

DeFi Analytics Applications

Cross-Domain Integration

Supported Networks and Protocols

Blockchain Networks

DeFi Protocols

Getting Started

Basic Blockchain Analysis

DeFi Protocol Analysis

Cross-Domain Analysis

Data Quality and Processing

Data Freshness

Technical Specifications

Access Information

Amazon S3 Access

Support Resources

​Blockchain Data

​Transaction Data

​Transaction Logs

​Account Balances

​Block Data

​DeFi Data

​DEX (Decentralized Exchange) Data

​DEX Trades

​DEX Liquidity Events

​Lending Protocol Data

​Protocol Events

​Daily Asset Metrics

​Daily Protocol Metrics

​Daily Stablecoin Metrics

​Data Field Descriptions

​Blockchain Data Fields

​Transaction Fields

​Transaction Logs Fields

​DeFi Data Fields

​DEX Trade Fields

​DEX Liquidity Fields

​Lending Protocol Fields

​Use Cases and Applications

​Blockchain Analytics Applications

​DeFi Analytics Applications

​Cross-Domain Integration

​Supported Networks and Protocols

​Blockchain Networks

​DeFi Protocols

​Getting Started

​Basic Blockchain Analysis

​DeFi Protocol Analysis

​Cross-Domain Analysis

​Data Quality and Processing

​Data Freshness

​Technical Specifications

​Access Information

​Amazon S3 Access

​Support Resources

Blockchain Data

Transaction Data

Transaction Logs

Account Balances

Block Data

DeFi Data

DEX (Decentralized Exchange) Data

DEX Trades

DEX Liquidity Events

Lending Protocol Data

Protocol Events

Daily Asset Metrics

Daily Protocol Metrics

Daily Stablecoin Metrics

Data Field Descriptions

Blockchain Data Fields

Transaction Fields

Transaction Logs Fields

DeFi Data Fields

DEX Trade Fields

DEX Liquidity Fields

Lending Protocol Fields

Use Cases and Applications

Blockchain Analytics Applications

DeFi Analytics Applications

Cross-Domain Integration

Supported Networks and Protocols

Blockchain Networks

DeFi Protocols

Getting Started

Basic Blockchain Analysis

DeFi Protocol Analysis

Cross-Domain Analysis

Data Quality and Processing

Data Freshness

Technical Specifications

Access Information

Amazon S3 Access

Support Resources