Too many markets for balancer v2
Returns DEX trades on Ethereum, where DEX smart contract is 0xa821…5e43, 0xba12…f2c8 or 1 more, DEX protocol name is balancer_v2 and block time since 2024-11-24: buy currency symbol, buy smart contract, buy currency name, buy price, sell currency symbol, sell smart contract, sell currency name and 7 more fields.
What it returns
- buy currency symbol
- buy smart contract
- buy currency name
- buy price
- sell currency symbol
- sell smart contract
- sell currency name
- sell price
- protocol name
- smart contract
- sum of trade buy amount
- sum of trade sell amount
- block time
- block number
Filters
- DEX smart contract is 0xa821…5e43, 0xba12…f2c8 or 1 more
- DEX protocol name is balancer_v2
- block time since 2024-11-24
The query
query fetchBulkTickers(
$network: evm_network!
$protocol: String!
$twentyFourHoursAgo: DateTime
$smartContracts: [String!]!
) {
EVM(dataset: realtime, network: $network) {
DEXTrades(
where: {
Trade: {
Dex: {
ProtocolName: { is: $protocol }
SmartContract: { in: $smartContracts }
}
}
Block: { Time: { since: $twentyFourHoursAgo } }
}
) {
Trade {
Buy {
Currency {
Symbol
SmartContract
Name
}
High: Price(maximum: Trade_Buy_Price)
Low: Price(minimum: Trade_Buy_Price)
Open: Price(minimum: Block_Number)
Close: Price(maximum: Block_Number)
}
Sell {
Currency {
Symbol
SmartContract
Name
}
High: Price(maximum: Trade_Sell_Price)
Low: Price(minimum: Trade_Sell_Price)
Open: Price(minimum: Block_Number)
Close: Price(maximum: Block_Number)
}
Dex {
ProtocolName
SmartContract
}
}
VolumeBuy: sum(of: Trade_Buy_Amount)
VolumeSell: sum(of: Trade_Sell_Amount)
Block {
LastTradeTime: Time(maximum: Block_Time)
FirstTradeTime: Time(minimum: Block_Time)
LastTradeBlock: Number(maximum: Block_Number)
FirstTradeBlock: Number(minimum: Block_Number)
}
}
}
}
Variables
{
"twentyFourHoursAgo": "2024-11-24T10:51:31.046Z",
"network": "eth",
"protocol": "balancer_v2",
"smartContracts": [
"0xa8210885430aaa333c9f0d66ab5d0c312bed5e43",
"0xba12222222228d8ba445958a75a0704d566bf2c8",
"0xd315a9c38ec871068fec378e4ce78af528c76293"
]
}
Similar queries
- Latest Curve DEX swaps on Ethereum · Ethereum · DEXTrades
- Top Curve liquidity pools by 24h volume on Ethereum · Ethereum · DEXTrades
- STRN_TOKEN_MULTIPLE_DECIMALS_DEX_TRADES · Ethereum · DEXTrades
- USDT DECIMAL SHOWING 0 · Ethereum · DEXTrades
- Trades - 0xEE61159E8A72A08371c52D62c19Efd0C7914f917 · Ethereum · DEXTrades