justinrhill2023@gmail.com
Returns DEX trades and balance updates on Ethereum: array intersect, contingency of block difficulty, average of block difficulty, correlation of block difficulty, count, cramers of block difficulty, covariance of block difficulty and 29 more fields.
What it returns
- array intersect
- contingency of block difficulty
- average of block difficulty
- correlation of block difficulty
- count
- cramers of block difficulty
- covariance of block difficulty
- cramers bias corrected of block difficulty
- dispersion of block difficulty
- entropy of block difficulty
- gini of block difficulty
- kurtosis of block difficulty
- median of block difficulty
- nakamoto of block difficulty
- quantile of block difficulty
- rank correlation of block difficulty
- skew of block difficulty
- standard deviation
- sum of block difficulty
- block date
- block hash
- block number
- parent hash
- block time
- chain ID
- call path
- average of balance update ID
- contingency of balance update ID
- correlation of balance update ID
- cramers of balance update ID
- covariance of balance update ID
- cramers bias corrected of balance update ID
- dispersion of balance update ID
- entropy of balance update ID
- gini of balance update ID
- kurtosis of balance update ID
The query
query MyQuery {
EVM(mempool: false, dataset: archive, network: eth, select_blocks: tree) {
DEXTrades {
array_intersect(side1: Call_Error, side2: Call_Error, intersectWith: "5000000")
contingency(of: Block_Difficulty, with: Block_Difficulty)
average(of: Block_Difficulty)
correlation(of: Block_Difficulty)
count(distinct: Block_Time)
cramers(of: Block_Difficulty, with: Block_Difficulty)
covariance(of: Block_Difficulty)
cramers_bias_corrected(of: Block_Difficulty, with: Block_Difficulty)
dispersion(of: Block_Difficulty)
entropy(of: Block_Difficulty)
gini(of: Block_Difficulty)
kurtosis(of: Block_Difficulty)
median(of: Block_Difficulty)
nakamoto(of: Block_Difficulty, ratio: 1.5)
quantile(of: Block_Difficulty, level: 1.5, method: exact)
rank_correlation(
of: Block_Difficulty
if: {Trade: {Sell: {AmountInUSD: {eq: "5000", ge: "50000", gt: "", lt: "", le: "4000000", ne: "4000000"}, Currency: {Fungible: false, Name: {endsWith: "", in: "5000000", includes: ""}, HasURI: false}}, Success: false}}
)
skew(of: Block_Difficulty)
standard_deviation(if: {})
sum(
of: Block_Difficulty
if: {Receipt: {ContractAddress: {endsWith: "500000", startsWith: "5000000"}}, Trade: {Sell: {}}}
)
}
BalanceUpdates {
Block {
Date(
minimum: BalanceUpdate_AmountInUSD
maximum: BalanceUpdate_AmountInUSD
selectWhere: {after: "", in: "", before: "", is: "", not: "", notIn: "", since: "", till: ""}
)
Hash(
maximum: BalanceUpdate_AmountInUSD
minimum: BalanceUpdate_AmountInUSD
selectWhere: {endsWith: "", in: "", is: "", includes: "", like: "", not: "", notIncludes: "", notLike: "", notIn: "", startsWith: ""}
)
Number(
maximum: BalanceUpdate_AmountInUSD
minimum: BalanceUpdate_AmountInUSD
selectWhere: {eq: "", ge: "", gt: "", in: "", le: "", lt: "", notIn: "5000000", ne: ""}
)
ParentHash(
maximum: BalanceUpdate_AmountInUSD
minimum: BalanceUpdate_AmountInUSD
)
Time(maximum: BalanceUpdate_AmountInUSD, minimum: BalanceUpdate_AmountInUSD)
}
ChainId(maximum: BalanceUpdate_AmountInUSD, minimum: BalanceUpdate_AmountInUSD)
Call {
CallPath(
maximum: BalanceUpdate_AmountInUSD
minimum: BalanceUpdate_AmountInUSD
selectWhere: {endsWith: {eq: "", ge: "Dvfv", gt: 500000000, in: 500000000, le: 500000000, lt: 500000000, ne: 500000000, notIn: 10}}
)
}
array_intersect(
side1: Uncle_Block_Hash
side2: Uncle_Block_Hash
intersectWith: "5000000"
)
average(of: BalanceUpdate_Id)
contingency(of: BalanceUpdate_Id, with: BalanceUpdate_Id)
correlation(of: BalanceUpdate_Id, with: BalanceUpdate_Id)
count(distinct: Currency_SmartContract)
cramers(of: BalanceUpdate_Id, with: BalanceUpdate_Id)
covariance(of: BalanceUpdate_Id, with: BalanceUpdate_Id)
cramers_bias_corrected(of: BalanceUpdate_Id, with: BalanceUpdate_Id)
dispersion(of: BalanceUpdate_Id)
entropy(of: BalanceUpdate_Id)
gini(of: BalanceUpdate_Id)
kurtosis(of: BalanceUpdate_Id)
}
}
}
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