UniversalSearch EVM
Returns one DEX trade by token on Ethereum, BNB Chain, Base, Arbitrum, Polygon, Optimism, Robinhood Chain, Solana and Tron, where currency smart contract is TBhCa8…dk6t, transaction from is TBhCa8…dk6t and currency mint address is TBhCa8…dk6t: currency symbol, currency name, smart contract, protocol name, protocol family, pool ID, side currency symbol and 7 more fields.
What it returns
- currency symbol
- currency name
- smart contract
- protocol name
- protocol family
- pool ID
- side currency symbol
- side currency name
- side smart contract
- currency mint address
- program address
- market address
- side currency mint address
- account owner
Filters
- currency smart contract is TBhCa8…dk6t
- transaction from is TBhCa8…dk6t
- currency mint address is TBhCa8…dk6t
- market market address is TBhCa8…dk6t
- account owner is TBhCa8…dk6t
- DEX smart contract is TBhCa8…dk6t
- transaction fee payer is TBhCa8…dk6t
The query
query UniversalSearch($address: String!) {
eth_token: EVM( network: eth) {
DEXTradeByTokens(
where: { Trade: { Currency: { SmartContract: { is: $address } } } }
limit: { count: 1 }
) {
Trade {
Currency { Symbol Name SmartContract }
Dex { ProtocolName ProtocolFamily SmartContract }
}
}
}
eth_pool: EVM(network: eth) {
DEXTradeByTokens(
where: {
any: [
{ Trade: { Dex: { SmartContract: { is: $address } } } },
{ Trade: { Dex: { Pair: { SmartContract: { is: $address } } } } },
{ Trade: { PoolId: { is: $address } } }
]
}
limit: { count: 1 }
) {
Trade {
PoolId
Currency { Symbol Name SmartContract }
Side { Currency { Symbol Name SmartContract } }
Dex {
ProtocolName
SmartContract
Pair { SmartContract }
}
}
}
}
eth_trader: EVM( network: eth) {
DEXTradeByTokens(
where: { Transaction: { From: { is: $address } } }
limit: { count: 1 }
) {
Trade {
Currency { Symbol Name }
}
}
}
bsc_token: EVM( network: bsc) {
DEXTradeByTokens(
where: { Trade: { Currency: { SmartContract: { is: $address } } } }
limit: { count: 1 }
) {
Trade {
Currency { Symbol Name SmartContract }
Dex { ProtocolName ProtocolFamily SmartContract }
}
}
}
bsc_pool: EVM( network: bsc) {
DEXTradeByTokens(
where: {
any: [
{ Trade: { Dex: { SmartContract: { is: $address } } } },
{ Trade: { Dex: { Pair: { SmartContract: { is: $address } } } } },
{ Trade: { PoolId: { is: $address } } }
]
}
limit: { count: 1 }
) {
Trade {
PoolId
Currency { Symbol Name SmartContract }
Side { Currency { Symbol Name SmartContract } }
Dex { ProtocolName ProtocolFamily SmartContract }
}
}
}
bsc_trader: EVM( network: bsc) {
DEXTradeByTokens(
where: { Transaction: { From: { is: $address } } }
limit: { count: 1 }
) {
Trade {
Currency { Symbol Name }
}
}
}
base_token: EVM( network: base) {
DEXTradeByTokens(
where: { Trade: { Currency: { SmartContract: { is: $address } } } }
limit: { count: 1 }
) {
Trade {
Currency { Symbol Name SmartContract }
Dex { ProtocolName ProtocolFamily SmartContract }
}
}
}
base_pool: EVM( network: base) {
DEXTradeByTokens(
where: {
any: [
{ Trade: { Dex: { SmartContract: { is: $address } } } },
{ Trade: { Dex: { Pair: { SmartContract: { is: $address } } } } },
{ Trade: { PoolId: { is: $address } } }
]
}
limit: { count: 1 }
) {
Trade {
PoolId
Currency { Symbol Name SmartContract }
Side { Currency { Symbol Name SmartContract } }
Dex { ProtocolName ProtocolFamily SmartContract }
}
}
}
base_trader: EVM( network: base) {
DEXTradeByTokens(
where: { Transaction: { From: { is: $address } } }
limit: { count: 1 }
) {
Trade {
Currency { Symbol Name }
}
}
}
arbitrum_token: EVM( network: arbitrum) {
DEXTradeByTokens(
where: { Trade: { Currency: { SmartContract: { is: $address } } } }
limit: { count: 1 }
) {
Trade {
Currency { Symbol Name SmartContract }
Dex { ProtocolName ProtocolFamily SmartContract }
}
}
}
arbitrum_pool: EVM( network: arbitrum) {
DEXTradeByTokens(
where: {
any: [
{ Trade: { Dex: { SmartContract: { is: $address } } } },
{ Trade: { Dex: { Pair: { SmartContract: { is: $address } } } } },
{ Trade: { PoolId: { is: $address } } }
]
}
limit: { count: 1 }
) {
Trade {
PoolId
Currency { Symbol Name SmartContract }
Side { Currency { Symbol Name SmartContract } }
Dex { ProtocolName ProtocolFamily SmartContract }
}
}
}
arbitrum_trader: EVM( network: arbitrum) {
DEXTradeByTokens(
where: { Transaction: { From: { is: $address } } }
limit: { count: 1 }
) {
Trade {
Currency { Symbol Name }
}
}
}
matic_token: EVM( network: matic) {
DEXTradeByTokens(
where: { Trade: { Currency: { SmartContract: { is: $address } } } }
limit: { count: 1 }
) {
Trade {
Currency { Symbol Name SmartContract }
Dex { ProtocolName ProtocolFamily SmartContract }
}
}
}
matic_pool: EVM( network: matic) {
DEXTradeByTokens(
where: {
any: [
{ Trade: { Dex: { SmartContract: { is: $address } } } },
{ Trade: { Dex: { Pair: { SmartContract: { is: $address } } } } },
{ Trade: { PoolId: { is: $address } } }
]
}
limit: { count: 1 }
) {
Trade {
PoolId
Currency { Symbol Name SmartContract }
Side { Currency { Symbol Name SmartContract } }
Dex { ProtocolName ProtocolFamily SmartContract }
}
}
}
matic_trader: EVM(network: matic) {
DEXTradeByTokens(
where: { Transaction: { From: { is: $address } } }
limit: { count: 1 }
) {
Trade {
Currency { Symbol Name }
}
}
}
optimism_token: EVM( network: optimism) {
DEXTradeByTokens(
where: { Trade: { Currency: { SmartContract: { is: $address } } } }
limit: { count: 1 }
) {
Trade {
Currency { Symbol Name SmartContract }
Dex { ProtocolName ProtocolFamily SmartContract }
}
}
}
optimism_pool: EVM( network: optimism) {
DEXTradeByTokens(
where: {
any: [
{ Trade: { Dex: { SmartContract: { is: $address } } } },
{ Trade: { Dex: { Pair: { SmartContract: { is: $address } } } } },
{ Trade: { PoolId: { is: $address } } }
]
}
limit: { count: 1 }
) {
Trade {
PoolId
Currency { Symbol Name SmartContract }
Side { Currency { Symbol Name SmartContract } }
Dex {
ProtocolName
ProtocolFamily
SmartContract
Pair { SmartContract }
}
}
}
}
optimism_trader: EVM( network: optimism) {
DEXTradeByTokens(
where: { Transaction: { From: { is: $address } } }
limit: { count: 1 }
) {
Trade {
Currency { Symbol Name }
}
}
}
robinhood_token: EVM( network: robinhood) {
DEXTradeByTokens(
where: { Trade: { Currency: { SmartContract: { is: $address } } } }
limit: { count: 1 }
) {
Trade {
Currency { Symbol Name SmartContract }
Dex { ProtocolName ProtocolFamily SmartContract }
}
}
}
robinhood_pool: EVM( network: robinhood) {
DEXTradeByTokens(
where: {
any: [
{ Trade: { Dex: { SmartContract: { is: $address } } } },
{ Trade: { Dex: { Pair: { SmartContract: { is: $address } } } } },
{ Trade: { PoolId: { is: $address } } }
]
}
limit: { count: 1 }
) {
Trade {
PoolId
Currency { Symbol Name SmartContract }
Side { Currency { Symbol Name SmartContract } }
Dex {
ProtocolName
ProtocolFamily
SmartContract
Pair { SmartContract }
}
}
}
}
robinhood_trader: EVM( network: robinhood) {
DEXTradeByTokens(
where: { Transaction: { From: { is: $address } } }
limit: { count: 1 }
) {
Trade {
Currency { Symbol Name }
}
}
}
solana_token: Solana(network: solana) {
DEXTradeByTokens(
where: { Trade: { Currency: { MintAddress: { is: $address } } } }
limit: { count: 1 }
) {
Trade {
Currency { Symbol Name MintAddress }
Dex { ProtocolName ProtocolFamily ProgramAddress }
Market { MarketAddress }
}
}
}
solana_pool: Solana(network: solana) {
DEXTradeByTokens(
where: {
Trade: {
Market: {
MarketAddress: { is: $address, not: "" }
}
}
}
limit: { count: 1 }
) {
Trade {
Currency { Symbol Name MintAddress }
Side { Currency { Symbol Name MintAddress } }
Dex { ProtocolName ProtocolFamily ProgramAddress }
Market { MarketAddress }
}
}
}
solana_trader: Solana(network: solana) {
DEXTradeByTokens(
where: { Trade: { Account: { Owner: { is: $address, not: "" } } } }
limit: { count: 1 }
) {
Trade {
# Account.Owner must stay selected: without it the planner falls back to
# the minute-aggregate table, which has no Trade_Account_Owner column --
# the Owner filter then returns arbitrary rows (and "not" hard-errors).
Account { Owner }
Currency { Symbol Name }
}
}
}
tron_token: Tron {
DEXTradeByTokens(
where: { Trade: { Currency: { SmartContract: { is: $address } } } }
limit: { count: 1 }
) {
Trade {
Currency { Symbol Name SmartContract }
Dex { ProtocolName ProtocolFamily SmartContract }
}
}
}
tron_pool: Tron {
DEXTradeByTokens(
where: { Trade: { Dex: { SmartContract: { is: $address } } } }
limit: { count: 1 }
) {
Trade {
Currency { Symbol Name SmartContract }
Side { Currency { Symbol Name SmartContract } }
Dex { ProtocolName ProtocolFamily SmartContract }
}
}
}
tron_trader: Tron {
DEXTradeByTokens(
where: { Transaction: { FeePayer: { is: $address } } }
limit: { count: 1 }
) {
Trade {
Currency { Symbol Name }
}
}
}
}
Variables
{"address":"TBhCa8FNknCAssaPMrsErwDnDNSazRdk6t"}
Similar queries
- CRV hourly OHLC on Curve - Ethereum · Ethereum · DEXTradeByTokens
- Top Metric liquidity pools by 24h volume on Ethereum · Ethereum · DEXTradeByTokens
- ATH of eth token · Ethereum · DEXTradeByTokens
- historical price and historical volume · Ethereum · DEXTradeByTokens
- topTraders EVM · Ethereum · DEXTradeByTokens