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.
What it returns
- timestamp time
- minute
- iso8601
- month
- day of week
- day of month
- hour
- median time time
- block hash
- block size big int
- block stripped size
- block version
- block weight
- chainwork
- difficulty
- transaction count
- count big int
- maximum of date
- any of time
- currency address
- token ID
- token type
- currency symbol
- properties
- currency name
- minimum of time
- maximum of time
- transaction hash
- transaction index
- value in
- value in decimal
- value out
- receivers count
- senders count
- json
- index
- version
- valid
- count
- date
- hash
- input count
- input count big int
- input value
- block
- any of date
- deposit index
- expression
- block root
- minimum of date
- state root
- body root
- ledger
- year
- success
- transaction type
- value
- validator address
- account hash
- amount
- deliver min currency address
- deliver min amount
- delivered amount
- flags
- invoice
- partial
- send max amount
- tag
- amount from
- amount to
- address
- annotation
- balance
- account
- reward type
- depth
- transfer type
- block height
- protocol
- proto
- op path
- direction
- destination contract
- sender address
- timestamp
- call depth
- energy usage total
- tx hash
- currency
- protocol type
- net usage
- external
- smart contract method
Filters
- height is 887520
- total coins is 1.5
- total coins is above 1.5
- total coins is below 1.5
- total coins is not 1.5
- amount is above 1.5
- amount is 1.5
- amount is below 1.5
- amount is not 1.5
- send max amount is above 1.5
- send max amount is 1.5
- send max amount is below 1.5
- send max amount is not 1.5
- block is above 10
- block is 10
- block is below 10
- block is not 10
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
- Bitcoin height using time · Bitcoin · Blocks
- bitcoin blocks · Bitcoin · Blocks
- bitcoin-tip-of-chain-block-height · Bitcoin · Blocks
- bitcoin_blocks · Bitcoin · Blocks
- A · Bitcoin · Blocks