Skip to main content

​
Tables

​
blocks

Block header data containing sequential numbering, cryptographic hashes linking to parent blocks, timestamps, and consensus metadata. Primary source for blockchain state verification and chain navigation.
ColumnTypeDescription
timestampTIMESTAMPTimestamp when the block was produced. UTC timezone.
block_dateDATEDate when the block was produced. Derived from block timestamp, truncated to day precision.
heightINT64Sequential block number indicating the position of the block in the blockchain. Increments by 1 for each new block in the chain.
block_hashSTRINGUnique identifier for the block. 66-character hex string including 0x prefix.
block_timeSTRINGUnix timestamp when the block was produced. Integer value representing seconds since Unix epoch (January 1, 1970).
proposerSTRINGValidator address responsible for producing the block. Hex-encoded string, typically 66 characters including 0x prefix.
numberINT64Sequential block number indicating the position of the block in the blockchain. Increments by 1 for each new block in the chain.
number_indexINT64Index of the record within the block, starting at 0 for the first record and incrementing by 1 for each subsequent record.
heightnumberproposertimestampblock_dateblock_hashblock_timenumber_index
9980002599800025471BF3F414235FF34E4B746B1A294079F4C3AEB12023-11-12T22:23:31.874Z2023-11-120x25586b2ca9e90ddae79d5dbf19eb4b291db60f86a809693095b20351aa92adc22023-11-12T22:23:31.8747170
9980004599800045471BF3F414235FF34E4B746B1A294079F4C3AEB12023-11-12T22:23:37.539Z2023-11-120xcca8d9524f771c5153e4ce12d7dc061d403a7477268c7fa49e645e550deb3b252023-11-12T22:23:37.5390840
9980049799800497471BF3F414235FF34E4B746B1A294079F4C3AEB12023-11-12T22:25:43.489Z2023-11-120x6300425c03afad3ac83593afede6bdf81b6c35823f53c92ee8b7ef7e34be3d0f2023-11-12T22:25:43.4893400
Query with partition filter
SELECT *
FROM `tt-blockchain.hypercore.blocks`
WHERE timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

​
node_fills

Order fill records from Hypercore perpetual futures protocol showing executed trades with price, size, position data, and fees denominated in various tokens (HYPE, UBTC, etc). Used for analyzing trade execution, position tracking, and calculating realized PnL across different perpetual markets.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, microsecond precision.
block_numberINT64Sequential number of the block in the blockchain. Starts at 0 for the genesis block and increments by 1 for each subsequent block.
block_dateDATEDate when the block was produced. Derived from block timestamp, truncated to day precision.
fill_timestampTIMESTAMPTimestamp when the order fill was executed on the Hypercore exchange. Recorded at microsecond precision in UTC.
account_addressSTRINGTrader’s wallet address that executed the fill on Hypercore. Hex-encoded, 0x-prefixed 40-character string representing the account holder’s Ethereum address.
cloidSTRINGClient-Level Order Identifier assigned by the trader or trading system for order tracking purposes. Null when orders originate from the platform rather than external systems.
closed_pnlBIGNUMERICRealized profit or loss from closing or reducing a position through this fill. Denominated in the trading pair’s quote currency, typically zero for position-increasing trades.
coinSTRINGTrading pair or asset identifier on the Hypercore platform. Uses @ prefix followed by a numeric code (e.g., @107, @142) to represent specific tokens or contracts.
crossedBOOLIndicates whether this fill crossed the bid-ask spread by taking liquidity from the opposite side of the order book. True when the order acted as a taker rather than a maker.
directionSTRINGTrading side indicator for the account holder. Values are “Buy” or “Sell” for purchase or sale transactions, “Net Child Vaults” for vault reconciliation operations, “in” for incoming messages, and “out” for outgoing messages.
feeBIGNUMERICTransaction fee paid to validators or network operators. Denominated in the blockchain’s native currency unit (microAlgos for Algorand, satoshis for Bitcoin, lamports for Solana, smallest divisible unit for other chains).
fee_tokenSTRINGToken symbol used to pay the trading fee on this fill. Typically the native exchange token (e.g., HYPE, UBTC) or the traded asset itself.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
order_idINT64Platform-assigned unique identifier for the order that generated this fill. Numeric sequence identifier used to track individual orders across partial and complete fills.
priceBIGNUMERICPrice at which the trade or order was executed. Numeric value representing the exchange rate between traded assets.
sideSTRINGOrder side identifier indicating the taker’s position in the trade. Either ‘B’ for buy or ‘S’ for sell.
start_positionBIGNUMERICPosition size held by the account in this coin before this fill executed. Denominated in the base asset, represents the quantity (positive or negative) of the trading pair prior to this trade.
sizeBIGNUMERICBlock size in bytes. Represents the total serialized size of the block data structure.
trade_idINT64Unique identifier for each individual trade execution on the Hypercore platform. Always present as a numeric value that distinguishes this fill from all other trades.
twap_idSTRINGTime-Weighted Average Price order identifier, linking fills that are part of a TWAP execution strategy. Null for standard orders that are not part of a TWAP split.
number_indexINT64Index of the record within the block, starting at 0 for the first record and incrementing by 1 for each subsequent record.
feecoinsidesizecloidpricecrossedtwap_idorder_idtrade_iddirectionfee_tokenblock_dateclosed_pnlblock_numbernumber_indexfill_timestampstart_positionaccount_addressblock_timestamptransaction_hash
0.0126@107B2045.061true132518468360297422555949258BuyHYPE2025-08-12069474705802025-08-12T22:19:41.571Z17.973605620x001005306685021a4edaf9de69c9b5b2a34c4caa2025-08-12T22:19:41.571Z0xb36dd0b52311bb7511de042968ffb20202d700dbf5f45654341340a81b77403d
4.059299@188B57990.0040429true132332709500700517335171918BuyUPUMP2025-08-12069453434602025-08-12T17:39:13.505Z69969.9119480x0015fb45c80dadae4142901208975005e9b2eedc2025-08-12T17:39:13.505Z0xb46efe078699807e2e8f042965c0ca0206ad0070005baa91da57bc7eb6d0f231
0.000002063@142B0.00307119653true1014501132370607711972771212191334BuyUBTC2025-08-12069457598602025-08-12T18:34:19.020Z0.07350526650x001900845643957d031ecdb3c5fd84ef08f6aaca2025-08-12T18:34:19.020Z0x0000000000000000000000000000000000000000000000000000000000000000
Query with partition filter
SELECT *
FROM `tt-blockchain.hypercore.node_fills`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

​
node_fills_without_block_number

Order fill records from Hypercore perpetual futures protocol with missing block number data. Contains execution details including price, size, side (buy/sell), closed PnL, and vault position tracking for debugging incomplete blockchain indexing.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, microsecond precision.
block_numberINT64Sequential number of the block in the blockchain. Starts at 0 for the genesis block and increments by 1 for each subsequent block.
block_dateDATEDate when the block was produced. Derived from block timestamp, truncated to day precision.
fill_timestampTIMESTAMPTimestamp when the trade fill was executed on the Hypercore exchange. Recorded with millisecond precision in UTC, distinct from block_timestamp which represents hourly granularity.
account_addressSTRINGBlockchain address of the account executing the trade on Hypercore. Hex-encoded, 0x-prefixed 40-character string representing the trader’s wallet or vault address.
cloidSTRINGClient order identifier assigned by the trader for tracking and reconciliation purposes. This field is typically null for automated or system-generated orders, as seen in the sample data.
closed_pnlBIGNUMERICRealized profit or loss from the portion of the position closed by this fill, denominated in the quote currency (typically USDC). Can be positive (profit), negative (loss), or zero for position-increasing trades.
coinSTRINGToken symbol or trading pair identifier for the filled order. May include standard symbols (e.g., VVV, USDC) or custom identifiers with special characters (e.g., @166).
crossedBOOLIndicates whether the fill crossed the spread by executing against an existing order on the opposite side of the order book. True when the order was a taker order that matched with a maker order.
directionSTRINGTrading side indicator for the account holder. Values are “Buy” or “Sell” for purchase or sale transactions, “Net Child Vaults” for vault reconciliation operations, “in” for incoming messages, and “out” for outgoing messages.
feeBIGNUMERICTransaction fee paid to validators or network operators. Denominated in the blockchain’s native currency unit (microAlgos for Algorand, satoshis for Bitcoin, lamports for Solana, smallest divisible unit for other chains).
fee_tokenSTRINGToken in which the trading fee is denominated, typically a stablecoin like USDC or USDT. May vary by trading pair or platform configuration.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
order_idINT64Platform-assigned unique identifier for the trading order that resulted in this fill. Integer value that remains consistent across partial fills of the same order.
priceBIGNUMERICPrice at which the trade or order was executed. Numeric value representing the exchange rate between traded assets.
sideSTRINGOrder side indicating whether the fill was a buy (B) or ask/sell (A) from the trader’s perspective. Always populated with single-character value B or A.
start_positionBIGNUMERICPosition size held by the account in the specified coin immediately before this fill was executed. Denominated in the same units as the trade size, representing the trader’s existing exposure prior to the transaction.
sizeBIGNUMERICBlock size in bytes. Represents the total serialized size of the block data structure.
trade_idINT64Unique identifier for this specific trade execution on the Hypercore platform. Non-null integer value that serves as the primary reference for each individual fill event.
twap_idSTRINGIdentifier linking this fill to a time-weighted average price (TWAP) order strategy if applicable. Null for regular orders not part of a TWAP execution.
number_indexINT64Index of the record within the block, starting at 0 for the first record and incrementing by 1 for each subsequent record.
feecoinsidesizecloidpricecrossedtwap_idorder_idtrade_iddirectionfee_tokenblock_dateclosed_pnlblock_numbernumber_indexfill_timestampstart_positionaccount_addressblock_timestamptransaction_hash
0VVVA2.882.7052false106595008455513402672104397Net Child VaultsUSDC2025-06-26-0.03602025-06-26T17:55:24.756Z19.10x010461c14e146ac35fe42271bdc1134ee31c703a2025-06-26T17:00:00.000Z0x1265fb0e4ed0aa0650d504264b530402017700a0303d6819766c788bb1008256
0VVVA3.322.7371false106411818837830636894437770Net Child VaultsUSDC2025-06-260.01560402025-06-26T05:09:13.985Z175.190x010461c14e146ac35fe42271bdc1134ee31c703a2025-06-26T05:00:00.000Z0xffac39a1d78b9c329b8504264240fa01d200478b0d15f56ff484d1ae0bcaabcb
0VVVB6.962.7242false106577326596899189411623790Net Child VaultsUSDC2025-06-26002025-06-26T16:37:27.037Z507.10x010461c14e146ac35fe42271bdc1134ee31c703a2025-06-26T16:00:00.000Z0xbf97b404bf677b53f89704264a636501c40052ab3d133ca7cb6d318235f1bdf7
Query with partition filter
SELECT *
FROM `tt-blockchain.hypercore.node_fills_without_block_number`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

​
node_trades

Individual trade executions from Hypercore protocol showing order fills with price, size, side, and maker/taker status. Used for analyzing trading patterns, price discovery, and order flow dynamics across markets.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, microsecond precision.
block_dateDATEDate when the block was produced. Derived from block timestamp, truncated to day precision.
trade_timestampTIMESTAMPTimestamp when the trade was executed on the Hypercore exchange, recorded with microsecond precision. Always populated and typically occurs within minutes of the corresponding block timestamp.
account_addressSTRINGBlockchain address of the account executing the trade on the Hypercore decentralized exchange. Hex-encoded, 0x-prefixed 40-character string representing an EVM-compatible wallet address.
cloidSTRINGClient order identifier assigned by the trader, used to track and manage orders within their own systems. Null when no custom identifier was provided by the trader.
coinSTRINGTrading pair or instrument identifier on the Hypercore exchange, using @ prefix notation (e.g., ‘@1’). This represents the specific market being traded on the platform.
sideSTRINGTrade direction indicator where ‘A’ represents ask (sell) orders and ‘B’ represents bid (buy) orders. All sample trades show either ‘A’ or ‘B’ values corresponding to the order book side.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
order_idINT64Unique identifier for the order on the Hypercore exchange, with values typically in the billions range. This ID links multiple trade executions that filled the same order.
priceBIGNUMERICPrice at which the trade or order was executed. Numeric value representing the exchange rate between traded assets.
sizeBIGNUMERICBlock size in bytes. Represents the total serialized size of the block data structure.
start_positionSTRINGUser’s position size in the trading pair before this trade executed. Numeric string representing the account’s position balance, with positive values indicating long positions and negative values indicating short positions.
twap_idINT64Identifier linking this trade to a Time-Weighted Average Price (TWAP) order strategy if applicable. Null when the trade is not part of a TWAP execution.
number_indexINT64Index of the record within the block, starting at 0 for the first record and incrementing by 1 for each subsequent record.
is_takerBOOLIndicates whether the account took liquidity (true) or provided liquidity (false) for this trade. Taker orders execute immediately against existing limit orders in the orderbook.
trade_dir_overrideJSONTrade direction override flag indicating manual adjustments or exceptions to the automatically determined trade direction. Typically set to “Na” when no override is applied.
coinsidesizecloidpricetwap_idis_takerorder_idblock_datenumber_indexstart_positionaccount_addressblock_timestamptrade_timestamptransaction_hashtrade_dir_override
@1A0.530.476false879821523292025-04-2200.509650060x0c4bef84b07dc0d84ebc414b24cf7acce24261ba2025-04-22T10:00:00.000Z2025-04-22T10:09:37.195751000Z0x3d58f5306e3b876b49a8042206890f020150002183f859bf47a3ba8dda7489f6”Na”
@1B0.930.094false881213846992025-04-220126.316263490x25bdd0a95d95319033360a2989219c697fc8a7d92025-04-22T22:00:00.000Z2025-04-22T22:25:16.861965000Z0xe799d53d78ae683b10a204220edf0402011e00b5c794b1aa95e6e7d4efe2847c”Na”
@1B3330.083true881257135052025-04-22033.563048140x25bdd0a95d95319033360a2989219c697fc8a7d92025-04-22T23:00:00.000Z2025-04-22T23:25:17.486697000Z0x5b363bfc9bb9b054f28f04220f8f8f0202f900aef2705ebf875b6d48f99186e9”Na”
Query with partition filter
SELECT *
FROM `tt-blockchain.hypercore.node_trades`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

​
transactions

Transaction records containing signed operations that modify blockchain state. Primary source for tracking value transfers, contract interactions, and account state changes across the network.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, microsecond precision.
block_dateDATEDate when the block was produced. Derived from block timestamp, truncated to day precision.
block_heightINT64Sequential position of the block in the blockchain. Zero-indexed integer representing the block’s distance from the genesis block.
block_hashSTRINGUnique identifier for the block. 66-character hex string including 0x prefix.
block_timeSTRINGUnix timestamp when the block was produced. Integer value representing seconds since Unix epoch (January 1, 1970).
proposerSTRINGValidator address responsible for producing the block. Hex-encoded string, typically 66 characters including 0x prefix.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
transaction_indexINT64Position of the transaction within its containing block. Zero-indexed integer indicating the sequential order of transactions in the block.
userSTRINGUser address initiating the transaction on Hypercore. Hex-encoded, 0x-prefixed 40-character Ethereum-style address representing the account submitting orders or cancellations.
errorSTRINGError message returned when transaction execution fails. Empty when execution succeeds.
actionsARRAY<JSON>JSON-encoded array of trading actions (orders, cancels) executed within the transaction on Hypercore’s decentralized exchange. Each action object contains market identifiers, price/size parameters, and order type metadata.
numberINT64Sequential block number indicating the position of the block in the blockchain. Increments by 1 for each new block in the chain.
number_indexINT64Index of the record within the block, starting at 0 for the first record and incrementing by 1 for each subsequent record.
usererrornumberactionsproposerblock_dateblock_hashblock_timeblock_heightnumber_indexblock_timestamptransaction_hashtransaction_index
0xb6ec0fc5749bd191eb12e24baf38489555f17e6299815625[”{“grouping”:“na”,“orders”:[{“a”:29,“b”:true,“p”:“54.132”,“r”:false,“s”:“0.62”,“t”:{“limit”:{“tif”:“Alo”}}}],“type”:“order”}“]471BF3F414235FF34E4B746B1A294079F4C3AEB12023-11-120x000335175d4a7b36edfb5e4af18a77700751b14ba9fab2487d5e26e043f0ab052023-11-12T23:32:16.5870719981562502023-11-12T23:32:16.587Z0x5354a626849f658805510054a86c2f208b1d494812d0121088b34791cd7d72af42
0x7899f00dd07a577d11dc9f4a845b46b71d5298a199815625[”{“cancels”:[{“a”:2,“o”:2984334559}],“type”:“cancel”}“]471BF3F414235FF34E4B746B1A294079F4C3AEB12023-11-120x000335175d4a7b36edfb5e4af18a77700751b14ba9fab2487d5e26e043f0ab052023-11-12T23:32:16.5870719981562502023-11-12T23:32:16.587Z0x17a861c8f48cd638b95af2ca065443dfd3ed25c179cb8a5104cc7d9e61c27bc926
0x31ca8395cf837de08b24da3f660e77761dfb974b99815625[”{“grouping”:“na”,“orders”:[{“a”:9,“b”:true,“p”:“1.8002”,“r”:false,“s”:“11398.3”,“t”:{“limit”:{“tif”:“Alo”}}}],“type”:“order”}”,”{“grouping”:“na”,“orders”:[{“a”:9,“b”:false,“p”:“1.801”,“r”:false,“s”:“5288.7”,“t”:{“limit”:{“tif”:“Alo”}}}],“type”:“order”}”,”{“grouping”:“na”,“orders”:[{“a”:9,“b”:false,“p”:“1.8033”,“r”:false,“s”:“12554.1”,“t”:{“limit”:{“tif”:“Alo”}}}],“type”:“order”}”,”{“grouping”:“na”,“orders”:[{“a”:9,“b”:false,“p”:“1.8052”,“r”:false,“s”:“12456.2”,“t”:{“limit”:{“tif”:“Alo”}}}],“type”:“order”}”,”{“grouping”:“na”,“orders”:[{“a”:63,“b”:true,“p”:“4.7208”,“r”:false,“s”:“1493.9”,“t”:{“limit”:{“tif”:“Alo”}}}],“type”:“order”}”,”{“grouping”:“na”,“orders”:[{“a”:63,“b”:true,“p”:“4.7191”,“r”:false,“s”:“2779.6”,“t”:{“limit”:{“tif”:“Alo”}}}],“type”:“order”}”,”{“grouping”:“na”,“orders”:[{“a”:63,“b”:true,“p”:“4.712”,“r”:false,“s”:“2847.3”,“t”:{“limit”:{“tif”:“Alo”}}}],“type”:“order”}”,”{“grouping”:“na”,“orders”:[{“a”:63,“b”:true,“p”:“4.7068”,“r”:false,“s”:“3124.1”,“t”:{“limit”:{“tif”:“Alo”}}}],“type”:“order”}”,”{“grouping”:“na”,“orders”:[{“a”:11,“b”:true,“p”:“1.1505”,“r”:false,“s”:“8275.3”,“t”:{“limit”:{“tif”:“Alo”}}}],“type”:“order”}”,”{“grouping”:“na”,“orders”:[{“a”:11,“b”:false,“p”:“1.1509”,“r”:false,“s”:“8229.8”,“t”:{“limit”:{“tif”:“Alo”}}}],“type”:“order”}”,”{“grouping”:“na”,“orders”:[{“a”:11,“b”:false,“p”:“1.1511”,“r”:false,“s”:“18839”,“t”:{“limit”:{“tif”:“Alo”}}}],“type”:“order”}”,”{“grouping”:“na”,“orders”:[{“a”:11,“b”:false,“p”:“1.1516”,“r”:false,“s”:“17298.1”,“t”:{“limit”:{“tif”:“Alo”}}}],“type”:“order”}”,”{“grouping”:“na”,“orders”:[{“a”:50,“b”:false,“p”:“85.99”,“r”:false,“s”:“107.51”,“t”:{“limit”:{“tif”:“Alo”}}}],“type”:“order”}”,”{“grouping”:“na”,“orders”:[{“a”:50,“b”:false,“p”:“86.021”,“r”:false,“s”:“94.2”,“t”:{“limit”:{“tif”:“Alo”}}}],“type”:“order”}”,”{“grouping”:“na”,“orders”:[{“a”:36,“b”:true,“p”:“0.42051”,“r”:false,“s”:“10648”,“t”:{“limit”:{“tif”:“Alo”}}}],“type”:“order”}”,”{“grouping”:“na”,“orders”:[{“a”:36,“b”:true,“p”:“0.42042”,“r”:false,“s”:“23156”,“t”:{“limit”:{“tif”:“Alo”}}}],“type”:“order”}”,”{“grouping”:“na”,“orders”:[{“a”:36,“b”:true,“p”:“0.42029”,“r”:false,“s”:“21177”,“t”:{“limit”:{“tif”:“Alo”}}}],“type”:“order”}”,”{“grouping”:“na”,“orders”:[{“a”:36,“b”:false,“p”:“0.42069”,“r”:false,“s”:“11452”,“t”:{“limit”:{“tif”:“Alo”}}}],“type”:“order”}”,”{“grouping”:“na”,“orders”:[{“a”:36,“b”:false,“p”:“0.42078”,“r”:false,“s”:“23548”,“t”:{“limit”:{“tif”:“Alo”}}}],“type”:“order”}”,”{“grouping”:“na”,“orders”:[{“a”:36,“b”:false,“p”:“0.4209”,“r”:false,“s”:“25782”,“t”:{“limit”:{“tif”:“Alo”}}}],“type”:“order”}”,”{“grouping”:“na”,“orders”:[{“a”:71,“b”:true,“p”:“0.59906”,“r”:false,“s”:“8070”,“t”:{“limit”:{“tif”:“Alo”}}}],“type”:“order”}”,”{“grouping”:“na”,“orders”:[{“a”:71,“b”:true,“p”:“0.59895”,“r”:false,“s”:“17536”,“t”:{“limit”:{“tif”:“Alo”}}}],“type”:“order”}”,”{“grouping”:“na”,“orders”:[{“a”:71,“b”:true,“p”:“0.59879”,“r”:false,“s”:“16563”,“t”:{“limit”:{“tif”:“Alo”}}}],“type”:“order”}”,”{“grouping”:“na”,“orders”:[{“a”:26,“b”:true,“p”:“235.55”,“r”:false,“s”:“42.697”,“t”:{“limit”:{“tif”:“Alo”}}}],“type”:“order”}”,”{“grouping”:“na”,“orders”:[{“a”:26,“b”:true,“p”:“235.51”,“r”:false,“s”:“81.121”,“t”:{“limit”:{“tif”:“Alo”}}}],“type”:“order”}”,”{“grouping”:“na”,“orders”:[{“a”:26,“b”:false,“p”:“235.58”,“r”:false,“s”:“48.471”,“t”:{“limit”:{“tif”:“Alo”}}}],“type”:“order”}”,”{“grouping”:“na”,“orders”:[{“a”:26,“b”:false,“p”:“235.62”,“r”:false,“s”:“89.778”,“t”:{“limit”:{“tif”:“Alo”}}}],“type”:“order”}”,”{“grouping”:“na”,“orders”:[{“a”:26,“b”:false,“p”:“235.67”,“r”:false,“s”:“85.859”,“t”:{“limit”:{“tif”:“Alo”}}}],“type”:“order”}”,”{“grouping”:“na”,“orders”:[{“a”:14,“b”:true,“p”:“0.61469”,“r”:false,“s”:“10654”,“t”:{“limit”:{“tif”:“Alo”}}}],“type”:“order”}”,”{“grouping”:“na”,“orders”:[{“a”:14,“b”:true,“p”:“0.61453”,“r”:false,“s”:“20971.3”,“t”:{“limit”:{“tif”:“Alo”}}}],“type”:“order”}”,”{“grouping”:“na”,“orders”:[{“a”:14,“b”:false,“p”:“0.61492”,“r”:false,“s”:“18096.5”,“t”:{“limit”:{“tif”:“Alo”}}}],“type”:“order”}”,”{“grouping”:“na”,“orders”:[{“a”:14,“b”:false,“p”:“0.61505”,“r”:false,“s”:“35299.7”,“t”:{“limit”:{“tif”:“Alo”}}}],“type”:“order”}”,”{“grouping”:“na”,“orders”:[{“a”:14,“b”:false,“p”:“0.61526”,“r”:false,“s”:“36235.5”,“t”:{“limit”:{“tif”:“Alo”}}}],“type”:“order”}”,”{“grouping”:“na”,“orders”:[{“a”:14,“b”:false,“p”:“0.61661”,“r”:false,“s”:“33529.6”,“t”:{“limit”:{“tif”:“Alo”}}}],“type”:“order”}”,”{“grouping”:“na”,“orders”:[{“a”:13,“b”:true,“p”:“17.165”,“r”:false,“s”:“522.9”,“t”:{“limit”:{“tif”:“Alo”}}}],“type”:“order”}”,”{“grouping”:“na”,“orders”:[{“a”:13,“b”:true,“p”:“17.161”,“r”:false,“s”:“999.6”,“t”:{“limit”:{“tif”:“Alo”}}}],“type”:“order”}”,”{“grouping”:“na”,“orders”:[{“a”:13,“b”:true,“p”:“17.155”,“r”:false,“s”:“1087.4”,“t”:{“limit”:{“tif”:“Alo”}}}],“type”:“order”}”,”{“grouping”:“na”,“orders”:[{“a”:13,“b”:false,“p”:“17.175”,“r”:false,“s”:“535.6”,“t”:{“limit”:{“tif”:“Alo”}}}],“type”:“order”}”,”{“grouping”:“na”,“orders”:[{“a”:13,“b”:false,“p”:“17.179”,“r”:false,“s”:“909.7”,“t”:{“limit”:{“tif”:“Alo”}}}],“type”:“order”}”,”{“grouping”:“na”,“orders”:[{“a”:5,“b”:true,“p”:“55.879”,“r”:false,“s”:“963.54”,“t”:{“limit”:{“tif”:“Alo”}}}],“type”:“order”}“]471BF3F414235FF34E4B746B1A294079F4C3AEB12023-11-120x000335175d4a7b36edfb5e4af18a77700751b14ba9fab2487d5e26e043f0ab052023-11-12T23:32:16.5870719981562502023-11-12T23:32:16.587Z0xc2eeb503f93f750fcab14928854bf08f28ca708d41f11cccec319a5075c4a17838
Query with partition filter
SELECT *
FROM `tt-blockchain.hypercore.transactions`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100