hypercore

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.

Columns

Column	Type	Description
`timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone.
`block_date`	`DATE`	Date when the block was produced. Derived from block timestamp, truncated to day precision.
`height`	`INT64`	Sequential block number indicating the position of the block in the blockchain. Increments by 1 for each new block in the chain.
`block_hash`	`STRING`	Unique identifier for the block. 66-character hex string including 0x prefix.
`block_time`	`STRING`	Unix timestamp when the block was produced. Integer value representing seconds since Unix epoch (January 1, 1970).
`proposer`	`STRING`	Validator address responsible for producing the block. Hex-encoded string, typically 66 characters including 0x prefix.
`number`	`INT64`	Sequential block number indicating the position of the block in the blockchain. Increments by 1 for each new block in the chain.
`number_index`	`INT64`	Index of the record within the block, starting at 0 for the first record and incrementing by 1 for each subsequent record.

Sample Data

height	number	proposer	timestamp	block_date	block_hash	block_time
99800025	99800025	471BF3F414235FF34E4B746B1A294079F4C3AEB1	2023-11-12T22:23:31.874Z	2023-11-12	0x25586b2ca9e90ddae79d5dbf19eb4b291db60f86a809693095b20351aa92adc2	2023-11-12T22:23:31.874717
99800045	99800045	471BF3F414235FF34E4B746B1A294079F4C3AEB1	2023-11-12T22:23:37.539Z	2023-11-12	0xcca8d9524f771c5153e4ce12d7dc061d403a7477268c7fa49e645e550deb3b25	2023-11-12T22:23:37.539084
99800497	99800497	471BF3F414235FF34E4B746B1A294079F4C3AEB1	2023-11-12T22:25:43.489Z	2023-11-12	0x6300425c03afad3ac83593afede6bdf81b6c35823f53c92ee8b7ef7e34be3d0f	2023-11-12T22:25:43.489340

Example Query

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, microsecond precision.
`block_number`	`INT64`	Sequential number of the block in the blockchain. Starts at 0 for the genesis block and increments by 1 for each subsequent block.
`block_date`	`DATE`	Date when the block was produced. Derived from block timestamp, truncated to day precision.
`fill_timestamp`	`TIMESTAMP`	Timestamp when the order fill was executed on the Hypercore exchange. Recorded at microsecond precision in UTC.
`account_address`	`STRING`	Trader’s wallet address that executed the fill on Hypercore. Hex-encoded, 0x-prefixed 40-character string representing the account holder’s Ethereum address.
`cloid`	`STRING`	Client-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_pnl`	`BIGNUMERIC`	Realized 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.
`coin`	`STRING`	Trading 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.
`crossed`	`BOOL`	Indicates 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.
`direction`	`STRING`	Trading 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.
`fee`	`BIGNUMERIC`	Transaction 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_token`	`STRING`	Token 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_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`order_id`	`INT64`	Platform-assigned unique identifier for the order that generated this fill. Numeric sequence identifier used to track individual orders across partial and complete fills.
`price`	`BIGNUMERIC`	Price at which the trade or order was executed. Numeric value representing the exchange rate between traded assets.
`side`	`STRING`	Order side identifier indicating the taker’s position in the trade. Either ‘B’ for buy or ‘S’ for sell.
`start_position`	`BIGNUMERIC`	Position 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.
`size`	`BIGNUMERIC`	Block size in bytes. Represents the total serialized size of the block data structure.
`trade_id`	`INT64`	Unique 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_id`	`STRING`	Time-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_index`	`INT64`	Index of the record within the block, starting at 0 for the first record and incrementing by 1 for each subsequent record.

Sample Data

fee	coin	side	size	price	crossed	twap_id	order_id	trade_id	direction	fee_token	block_date	block_number	fill_timestamp	start_position	account_address	block_timestamp	transaction_hash
0.0126	@107	B	20	45.061	true		132518468360	297422555949258	Buy	HYPE	2025-08-12	694747058	2025-08-12T22:19:41.571Z	17.97360562	0x001005306685021a4edaf9de69c9b5b2a34c4caa	2025-08-12T22:19:41.571Z	0xb36dd0b52311bb7511de042968ffb20202d700dbf5f45654341340a81b77403d
4.059299	@188	B	5799	0.0040429	true		132332709500	700517335171918	Buy	UPUMP	2025-08-12	694534346	2025-08-12T17:39:13.505Z	69969.911948	0x0015fb45c80dadae4142901208975005e9b2eedc	2025-08-12T17:39:13.505Z	0xb46efe078699807e2e8f042965c0ca0206ad0070005baa91da57bc7eb6d0f231
0.000002063	@142	B	0.00307	119653	true	1014501	132370607711	972771212191334	Buy	UBTC	2025-08-12	694575986	2025-08-12T18:34:19.020Z	0.0735052665	0x001900845643957d031ecdb3c5fd84ef08f6aaca	2025-08-12T18:34:19.020Z	0x0000000000000000000000000000000000000000000000000000000000000000

Example Query

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, microsecond precision.
`block_number`	`INT64`	Sequential number of the block in the blockchain. Starts at 0 for the genesis block and increments by 1 for each subsequent block.
`block_date`	`DATE`	Date when the block was produced. Derived from block timestamp, truncated to day precision.
`fill_timestamp`	`TIMESTAMP`	Timestamp 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_address`	`STRING`	Blockchain address of the account executing the trade on Hypercore. Hex-encoded, 0x-prefixed 40-character string representing the trader’s wallet or vault address.
`cloid`	`STRING`	Client 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_pnl`	`BIGNUMERIC`	Realized 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.
`coin`	`STRING`	Token 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).
`crossed`	`BOOL`	Indicates 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.
`direction`	`STRING`	Trading 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.
`fee`	`BIGNUMERIC`	Transaction 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_token`	`STRING`	Token in which the trading fee is denominated, typically a stablecoin like USDC or USDT. May vary by trading pair or platform configuration.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`order_id`	`INT64`	Platform-assigned unique identifier for the trading order that resulted in this fill. Integer value that remains consistent across partial fills of the same order.
`price`	`BIGNUMERIC`	Price at which the trade or order was executed. Numeric value representing the exchange rate between traded assets.
`side`	`STRING`	Order 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_position`	`BIGNUMERIC`	Position 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.
`size`	`BIGNUMERIC`	Block size in bytes. Represents the total serialized size of the block data structure.
`trade_id`	`INT64`	Unique 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_id`	`STRING`	Identifier 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_index`	`INT64`	Index of the record within the block, starting at 0 for the first record and incrementing by 1 for each subsequent record.

Sample Data

coin	side	size	price	crossed	order_id	trade_id	direction	fee_token	block_date	closed_pnl	fill_timestamp	start_position	account_address	block_timestamp	transaction_hash
VVV	A	2.88	2.7052	false	106595008455	513402672104397	Net Child Vaults	USDC	2025-06-26	-0.036	2025-06-26T17:55:24.756Z	19.1	0x010461c14e146ac35fe42271bdc1134ee31c703a	2025-06-26T17:00:00.000Z	0x1265fb0e4ed0aa0650d504264b530402017700a0303d6819766c788bb1008256
VVV	A	3.32	2.7371	false	106411818837	830636894437770	Net Child Vaults	USDC	2025-06-26	0.015604	2025-06-26T05:09:13.985Z	175.19	0x010461c14e146ac35fe42271bdc1134ee31c703a	2025-06-26T05:00:00.000Z	0xffac39a1d78b9c329b8504264240fa01d200478b0d15f56ff484d1ae0bcaabcb
VVV	B	6.96	2.7242	false	106577326596	899189411623790	Net Child Vaults	USDC	2025-06-26	0	2025-06-26T16:37:27.037Z	507.1	0x010461c14e146ac35fe42271bdc1134ee31c703a	2025-06-26T16:00:00.000Z	0xbf97b404bf677b53f89704264a636501c40052ab3d133ca7cb6d318235f1bdf7

Example Query

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, microsecond precision.
`block_date`	`DATE`	Date when the block was produced. Derived from block timestamp, truncated to day precision.
`trade_timestamp`	`TIMESTAMP`	Timestamp 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_address`	`STRING`	Blockchain 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.
`cloid`	`STRING`	Client 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.
`coin`	`STRING`	Trading pair or instrument identifier on the Hypercore exchange, using @ prefix notation (e.g., ‘@1’). This represents the specific market being traded on the platform.
`side`	`STRING`	Trade 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_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`order_id`	`INT64`	Unique 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.
`price`	`BIGNUMERIC`	Price at which the trade or order was executed. Numeric value representing the exchange rate between traded assets.
`size`	`BIGNUMERIC`	Block size in bytes. Represents the total serialized size of the block data structure.
`start_position`	`STRING`	User’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_id`	`INT64`	Identifier 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_index`	`INT64`	Index of the record within the block, starting at 0 for the first record and incrementing by 1 for each subsequent record.
`is_taker`	`BOOL`	Indicates 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_override`	`JSON`	Trade direction override flag indicating manual adjustments or exceptions to the automatically determined trade direction. Typically set to “Na” when no override is applied.

Sample Data

coin	side	size	price	is_taker	order_id	block_date	start_position	account_address	block_timestamp	trade_timestamp	transaction_hash	trade_dir_override
@1	A	0.5	30.476	false	87982152329	2025-04-22	0.50965006	0x0c4bef84b07dc0d84ebc414b24cf7acce24261ba	2025-04-22T10:00:00.000Z	2025-04-22T10:09:37.195751000Z	0x3d58f5306e3b876b49a8042206890f020150002183f859bf47a3ba8dda7489f6	”Na”
@1	B	0.9	30.094	false	88121384699	2025-04-22	126.31626349	0x25bdd0a95d95319033360a2989219c697fc8a7d9	2025-04-22T22:00:00.000Z	2025-04-22T22:25:16.861965000Z	0xe799d53d78ae683b10a204220edf0402011e00b5c794b1aa95e6e7d4efe2847c	”Na”
@1	B	33	30.083	true	88125713505	2025-04-22	33.56304814	0x25bdd0a95d95319033360a2989219c697fc8a7d9	2025-04-22T23:00:00.000Z	2025-04-22T23:25:17.486697000Z	0x5b363bfc9bb9b054f28f04220f8f8f0202f900aef2705ebf875b6d48f99186e9	”Na”

Example Query

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, microsecond precision.
`block_date`	`DATE`	Date when the block was produced. Derived from block timestamp, truncated to day precision.
`block_height`	`INT64`	Sequential position of the block in the blockchain. Zero-indexed integer representing the block’s distance from the genesis block.
`block_hash`	`STRING`	Unique identifier for the block. 66-character hex string including 0x prefix.
`block_time`	`STRING`	Unix timestamp when the block was produced. Integer value representing seconds since Unix epoch (January 1, 1970).
`proposer`	`STRING`	Validator address responsible for producing the block. Hex-encoded string, typically 66 characters including 0x prefix.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`transaction_index`	`INT64`	Position of the transaction within its containing block. Zero-indexed integer indicating the sequential order of transactions in the block.
`user`	`STRING`	User address initiating the transaction on Hypercore. Hex-encoded, 0x-prefixed 40-character Ethereum-style address representing the account submitting orders or cancellations.
`error`	`STRING`	Error message returned when transaction execution fails. Empty when execution succeeds.
`actions`	`ARRAY<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.
`number`	`INT64`	Sequential block number indicating the position of the block in the blockchain. Increments by 1 for each new block in the chain.
`number_index`	`INT64`	Index of the record within the block, starting at 0 for the first record and incrementing by 1 for each subsequent record.

Sample Data

user	number	actions	proposer	block_date	block_hash	block_time	block_height	block_timestamp	transaction_hash	transaction_index
0xb6ec0fc5749bd191eb12e24baf38489555f17e62	99815625	[”{“grouping”:“na”,“orders”:[{“a”:29,“b”:true,“p”:“54.132”,“r”:false,“s”:“0.62”,“t”:{“limit”:{“tif”:“Alo”}}}],“type”:“order”}“]	471BF3F414235FF34E4B746B1A294079F4C3AEB1	2023-11-12	0x000335175d4a7b36edfb5e4af18a77700751b14ba9fab2487d5e26e043f0ab05	2023-11-12T23:32:16.587071	99815625	2023-11-12T23:32:16.587Z	0x5354a626849f658805510054a86c2f208b1d494812d0121088b34791cd7d72af	42
0x7899f00dd07a577d11dc9f4a845b46b71d5298a1	99815625	[”{“cancels”:[{“a”:2,“o”:2984334559}],“type”:“cancel”}“]	471BF3F414235FF34E4B746B1A294079F4C3AEB1	2023-11-12	0x000335175d4a7b36edfb5e4af18a77700751b14ba9fab2487d5e26e043f0ab05	2023-11-12T23:32:16.587071	99815625	2023-11-12T23:32:16.587Z	0x17a861c8f48cd638b95af2ca065443dfd3ed25c179cb8a5104cc7d9e61c27bc9	26
0x31ca8395cf837de08b24da3f660e77761dfb974b	99815625	[”{“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”}“]	471BF3F414235FF34E4B746B1A294079F4C3AEB1	2023-11-12	0x000335175d4a7b36edfb5e4af18a77700751b14ba9fab2487d5e26e043f0ab05	2023-11-12T23:32:16.587071	99815625	2023-11-12T23:32:16.587Z	0xc2eeb503f93f750fcab14928854bf08f28ca708d41f11cccec319a5075c4a178	38

Example Query

Query with partition filter

SELECT *
FROM `tt-blockchain.hypercore.transactions`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

blocks

node_fills

node_fills_without_block_number

node_trades

transactions

​Tables

​blocks

​node_fills

​node_fills_without_block_number

​node_trades

​transactions

Tables

blocks

node_fills

node_fills_without_block_number

node_trades

transactions