mine

Returns blocks and money flows on Bitcoin, eth2, flow, harmony, hedera, XRP Ledger, Solana, Stellar, tezos and Tron, where height is 887520, total coins is 1.5 and total coins is above 1.5: timestamp time, minute, iso8601, month, day of week, day of month, hour and 86 more fields.

By Christie Asberry · saved 12 March 2025 · Bitquery API v1

What it returns

Filters

The query

query ($network: BitcoinNetwork!, $height: Int!) {
  bitcoin(network: $network) {
    blocks(height: {is: $height}) {
      timestamp {
        time(format: "%Y-%m-%d %H:%M:%S")
        minute
        iso8601
        month
        dayOfWeek
        dayOfMonth
        hour
      }
      medianTime {
        time(format: "%Y-%m-%d %H:%M:%S")
      }
      blockHash
      blockSizeBigInt
      blockStrippedSize
      blockVersion
      blockWeight
      chainwork
      difficulty
      transactionCount
      countBigInt
      maximum(of: date)
    }
    coinpath {
      any(of: time)
      countBigInt
      currency {
        address
        tokenId
        tokenType
        symbol
        properties
        name
      }
      minimum(of: time)
      maximum(of: time)
      transaction {
        hash
        index
        valueIn
        valueInDecimal
        valueOut
      }
      sender {
        receiversCount
        sendersCount
      }
    }
    omniTransactions {
      json
      index
      maximum(of: date)
      version
      valid
      count
      blockHash
    }
    transactions {
      count(txCoinbase: false, uniq: blocks)
      date
      hash
      index
      inputCount
      inputCountBigInt(txCoinbase: true)
      inputValue(in: USD, txCoinbase: true)
    }
  }
  ethereum2(network: eth2) {
    deposits(any: {}) {
      block
      any(of: date)
      depositIndex
      expression(get: "")
    }
    proposerSlashings {
      blockRoot
      any(of: date)
      minimum(of: date)
      stateRoot
      slashing {
        bodyRoot
      }
    }
  }
  flow(network: flow)
  harmony(network: harmony) {
    stakingTransactions(success: true, status: true) {
      ledger
      expression(get: "")
      time {
        dayOfMonth
        dayOfWeek
        hour
        year
        month
        iso8601
        minute
      }
      success(success: false)
      transactionType
      transactionHash
      value
      validatorAddress
    }
  }
  hedera(network: hedera)
  metrics(queryId: "", options: {}) {
    id
    points
    sqlRequestsCount
  }
  ripple(network: ripple) {
    blocks(
      accountHash: {is: "", in: "", not: "", notIn: ""}
      any: {totalCoins: {between: 1.5, in: 1.5, gteq: 1.5, gt: 1.5, lteq: 1.5, lt: 1.5, is: 1.5, not: 1.5}, accountHash: {in: "", is: ""}}
    ) {
      accountHash
      maximum(of: date)
    }
    payments(
      amount: {between: 1.5, gt: 1.5, gteq: 1.5, is: 1.5, in: 1.5, lt: 1.5, lteq: 1.5, not: 1.5}
      amountCurrency: {in: "", notIn: "", not: "", is: ""}
      deliveredCurrency: {is: "", in: "", not: "", notIn: ""}
      sender: {in: "", is: "", not: ""}
      sendMaxAmount: {between: 1.5, gt: 1.5, gteq: 1.5, in: 1.5, lt: 1.5, is: 1.5, not: 1.5, lteq: 1.5}
      invoice: {is: "", in: "", not: ""}
      deliverMinCurrency: {in: "", is: ""}
      deliveredIssuer: {in: "", is: ""}
    ) {
      amount(
        calculate: maximum
        invoice: {in: "", is: ""}
        in: USD
        partial: {not: false, is: false}
      )
      block
      any(of: date)
      count(uniq: dates)
      countBigInt(uniq: dates)
      deliverMinCurrency {
        address
      }
      deliverMinAmount(date: {}, calculate: maximum, invoice: {}, in: USD)
      deliveredAmount(calculate: maximum, in: USD)
      expression(get: "")
      flags
      invoice
      minimum(of: date)
      maximum(of: date)
      partial
      sendMaxAmount
      tag
    }
    transfers {
      amountFrom(calculate: maximum, in: USD)
      any(of: date)
      amountTo(calculate: maximum, in: USD)
      block
      count(uniq: times)
      countBigInt
      minimum(of: date, get: date)
      maximum(of: date, get: date)
      expression(get: "")
    }
  }
  solana(network: solana) {
    address(address: {is: "", in: ""}) {
      address
      annotation
      balance(in: USD)
    }
    blockRewards {
      account
      any(of: date)
      count(uniq: times)
      amount(in: USD)
      countBigInt(uniq: times)
      expression(get: "")
      rewardType
    }
    blocks {
      blockHash
      any(of: date)
      count
      transactionCount
    }
    coinpath {
      amount
      any(of: time)
      count
      maximum(of: time)
      depth
    }
    transfers {
      amount(calculate: maximum, parsed: {})
      count
      block
      countBigInt
      expression(get: "")
      maximum(of: date, get: date)
      minimum(of: date)
      transferType
    }
  }
  stellar {
    transfers(
      block: {gt: 10, between: 10, gteq: 10, in: 10, is: 10, lt: 10, not: 10, lteq: 10}
    ) {
      amountFrom
      any(of: date)
      amountTo(calculate: maximum)
      block
      count
      countBigInt
      expression(get: "")
      minimum(of: date)
      maximum(of: date)
    }
  }
  tezos(network: tezos) {
    blocks {
      any(of: date)
    }
    transfers {
      amount
      block {
        height
      }
      any(of: date)
      protocol
      proto
      opPath
      direction
      destinationContract
      maximum(of: date, get: date)
      sender {
        address
        annotation
      }
      timestamp
    }
  }
  tron(network: tron) {
    smartContractCalls(
      any: {time: {before: "", not: "", between: "", in: "", is: ""}, success: true}
      external: true
      success: true
    ) {
      callDepth
      countBigInt(
        external: true
        time: {after: "", before: ""}
        success: true
        uniq: calls
      )
      expression(get: "")
      energyUsageTotal
      txHash
      success(success: true)
      smartContract {
        currency
        protocolType
      }
      netUsage
      minimum(of: date)
      maximum(of: date)
      external
      smartContractMethod
    }
    smartContractEvents
  }
}

Variables

{
  "limit": 10,
  "offset": 0,
  "height": 887520,
  "network": "bitcoin"
}

Similar queries