Optimism pair list
Returns 100 DEX trades by token on Optimism, where block time after 2024-09-30, sorted by USD, highest first: currency symbol, currency name, smart contract, protocol name, side currency symbol, side currency name, side smart contract and 8 more fields.
What it returns
- currency symbol
- currency name
- smart contract
- protocol name
- side currency symbol
- side currency name
- side smart contract
- side protocol name
- price in USD
- unique of trade DEX owner address
- sum of trade side amount
- sum of trade side amount in USD
- unique of trade seller
- unique of trade buyer
- count
Filters
- block time after 2024-09-30
The query
query pairs($min_count: String, $network: evm_network, $time_10min_ago: DateTime, $time_1h_ago: DateTime, $time_3h_ago: DateTime,
$weth: String!, $usdc: String!, $usdt: String!, $usdc2: String!) {
EVM(network: $network) {
DEXTradeByTokens(
where: {Block: {Time: {after: $time_3h_ago}}, any: [
{Trade: {Side: {Currency: {SmartContract: {is: $usdt}}}}},
{Trade: {Side: {Currency: {SmartContract: {is: $usdc}}}, Currency: {SmartContract: {notIn: [$usdt]}}}},
{Trade: {Side: {Currency: {SmartContract: {is: $usdc2}}}, Currency: {SmartContract: {notIn: [$usdt, $usdc]}}}},
{Trade: {Side: {Currency: {SmartContract: {is: $weth}}}, Currency: {SmartContract: {notIn: [$usdc, $usdt, $usdc2]}}}},
{Trade: {Side: {Currency: {SmartContract: {notIn: [$usdc, $usdt, $weth]}}}, Currency: {SmartContract: {notIn: [$usdc, $usdc2, $usdt, $weth]}}}}]}
orderBy: {descendingByField: "usd"}
limit: {count: 100}
) {
Trade {
Currency {
Symbol
Name
SmartContract
ProtocolName
}
Side {
Currency {
Symbol
Name
SmartContract
ProtocolName
}
}
price_last: PriceInUSD(maximum: Block_Number)
price_10min_ago: PriceInUSD(
maximum: Block_Number
if: {Block: {Time: {before: $time_10min_ago}}}
)
price_1h_ago: PriceInUSD(
maximum: Block_Number
if: {Block: {Time: {before: $time_1h_ago}}}
)
price_3h_ago: PriceInUSD(minimum: Block_Number)
}
dexes: uniq(of: Trade_Dex_OwnerAddress)
amount: sum(of: Trade_Side_Amount)
usd: sum(of: Trade_Side_AmountInUSD)
sellers: uniq(of: Trade_Seller)
buyers: uniq(of: Trade_Buyer)
count(selectWhere: {ge: $min_count})
}
}
}
Variables
{
"network": "optimism",
"time_10min_ago": "2024-09-30T05:11:40Z",
"time_1h_ago": "2024-09-30T04:21:40Z",
"time_3h_ago": "2024-09-30T02:21:40Z",
"usdc": "0x0b2c639c533813f4aa9d7837caf62653d097ff85",
"usdc2": "0x7f5c764cbc14f9669b88837ca1490cca17c31607",
"usdt": "0x94b008aa00579c1307b0ef2c499ad98a8ce58e58",
"weth": "0x4200000000000000000000000000000000000006",
"min_count": "100"
}
Similar queries
- AfricaCryptoChainx · Ethereum · DEXTradeByTokens
- UniversalSearch EVM · Ethereum · DEXTradeByTokens
- trade stats for a token pair on uniswap v4 optimism · Optimism · DEXTradeByTokens
- get virtual pool address for a token on uniswap v4 optimism · Optimism · DEXTradeByTokens
- Bitget hack: ETH on Optimism and Base to the attacker, Sep 24, 2026 · Optimism · Transfers