Converts questions from plain English into ready-to-run SQL queries with explanations.
Derive DEX Notionals by Blockchain.SQL Query Prompted:
This query aggregates the total notional traded on decentralized exchanges (DEX) for different blockchains by summing upusd_amount
for eachchain
on a daily basis. DEX Data Available Allium provides detailed data on DEX trades, including:For more detailed information on DEX tables and their descriptions, you can visit the DEX documentation. Additionally, Allium supports data for multiple blockchain protocols, including Uniswap, Sushiswap, Balancer, Curve, and others, across different chains like Ethereum, Binance Smart Chain, Avalanche, and many more.
- Trades: Token swaps on major DEXes
- Aggregator Trades: Trades executed by aggregators or contracts that route swaps across multiple liquidity pools
- Liquidity Pool Events: Liquidity pool events such as mints, burns, sync, and collect
- Liquidity Pools: Pool creation events and their parameters