linea

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
`base_fee_per_gas`	`INT64`	Minimum fee per gas unit required for transaction inclusion in the block. Measured in wei, representing the base cost dynamically adjusted by the network’s fee mechanism.
`difficulty`	`INT64`	Mining difficulty target for the block. Integer value representing the computational effort required to produce the block, with 0 indicating proof-of-stake consensus and higher values indicating proof-of-work difficulty.
`extra_data`	`STRING`	Arbitrary data field included in the block by the block producer. Hex-encoded string format, typically containing miner software version, pool information, or chain-specific metadata.
`gas_limit`	`INT64`	Maximum gas allowed to be consumed by all transactions in the block. Measured in gas units, representing the computational capacity limit set for block execution.
`gas_used`	`INT64`	Amount of gas consumed by the execution. Measured in gas units, representing the computational resources used to process the operation.
`block_hash`	`STRING`	Unique identifier for the block. 66-character hex string including 0x prefix.
`logs_bloom`	`STRING`	Bloom filter for efficient event log querying within the block. 512-character hex string (including 0x prefix) representing a probabilistic data structure for testing event presence.
`miner`	`STRING`	Address of the block producer who created the block. Hex-encoded, 0x-prefixed, 42-character string.
`mix_hash`	`STRING`	Hash value used in proof-of-work mining or consensus verification. 66-character hex string including 0x prefix.
`nonce`	`STRING`	Sequential counter for transactions or operations from an account. Increments by 1 for each new transaction to prevent replay attacks and ensure transaction ordering.
`number`	`INT64`	Sequential block number indicating the position of the block in the blockchain. Increments by 1 for each new block in the chain.
`parent_hash`	`STRING`	Hash of the parent block in the blockchain. 66-character hex string including 0x prefix.
`receipts_root`	`STRING`	Merkle root hash of all transaction receipts in the block. 66-character hex string including 0x prefix.
`sha3_uncles`	`STRING`	Keccak-256 hash of the RLP-encoded list of uncle block headers. 66-character hex string including 0x prefix.
`size`	`INT64`	Block size in bytes. Represents the total serialized size of the block data structure.
`state_root`	`STRING`	Merkle root hash representing the complete state of the blockchain after block execution. 66-character hex string including 0x prefix.
`timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone.
`total_difficulty`	`NUMERIC`	Cumulative sum of block difficulty from genesis to the current block. Numeric value representing the total computational work expended on the chain up to and including this block.
`transaction_count`	`INT64`	Number of transactions included in the block.
`transactions_root`	`STRING`	Merkle root hash of all transactions included in the block. 66-character hex string including 0x prefix.
`uncles`	`ARRAY<STRING>`	List of uncle block hashes included in the block. Empty array for chains not supporting uncle blocks in their consensus mechanism.

Sample Data

size	miner	nonce	number	uncles	gas_used	mix_hash	gas_limit	timestamp	block_hash	difficulty	extra_data	logs_bloom	state_root	parent_hash	sha3_uncles	receipts_root	base_fee_per_gas	total_difficulty	transaction_count	transactions_root
1001	0x0000000000000000000000000000000000000000	0x0000000000000000	1651467	[]	366216	0x0000000000000000000000000000000000000000000000000000000000000000	61000000	2024-01-14T07:57:06.000Z	0x7919745118f4cf91ffb3f39b13bbeda1198cefe47d08350fc23faa0a25a643a8	2	0xd983010b06846765746889676f312e32302e3132856c696e75780000000000006f3c68332cc7c0178a3eecab903fc7179b8f6acc39110df50b54f1000fd9ad9b4c89f5798db27ca75e4f46cd6adbcc1100e3379f6978fe81429995c32ae1513601	0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000004000000000000200000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000800200000004000000000000000000000004000000000000000000004000000000000000000000000000020800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	0x2cc0a758f3e941b47494ef81ac790a180fc4edf38deee2b0dbb65706548f4a85	0xcfe1e76d4bed32963e4cdf0b0854ccb1dca5c989bf374bba69cadf8e81c746ae	0x1dcc4de8dec75d7aab85b567b6ccd41ad312451b948a7413f0a142fd40d49347	0x06bb8255de21484c1a871383f9dd102091de38fd09dd9e9d71f74007f27b3442	7	3302935	1	0x4e3d9b5886f97b8a5f4ec6c16feb9168ca53663f6d56ba53d0040227d6be40ef
984	0x0000000000000000000000000000000000000000	0x0000000000000000	1651004	[]	33316	0x0000000000000000000000000000000000000000000000000000000000000000	61000000	2024-01-14T07:10:48.000Z	0x9e85cdb63285798ab79686330354533e0fe72c5bda7e4b0a331120ec1154169e	2	0xd983010b06846765746889676f312e32302e3132856c696e75780000000000007f4897e0a7693264b22d3e6a5d659d4f81d429930f9d25958f90ccb3dfb3deca171513572113e105da29d7055757d452d91590f19d1ba184ac77e1b2c7d68e0201	0x00000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000400000000000000000000000000240000000000004000000000000000000000000000000000000000080000000000002000000000000000040000000000000000000000000080000000000000000000000000000000000000000000000000000000000000000000000040000000000000000000000000000000000000000200000000000000000000000000000100000000000000000000000000000000000000000000008000002000000000000000000000000000000000000000000000000000100000000000000000000000	0x9c3b50038b617dec971ec12238faab6074acfbb440c9954e949711f9f9c41691	0xa9775a17b9a0335554c7f0338649e8bb59b3bd947813cfc56c59b61a7e3d5194	0x1dcc4de8dec75d7aab85b567b6ccd41ad312451b948a7413f0a142fd40d49347	0x2e0292513dd330ffc896aaa269125018f6ca0ede0d3a9fbc3a2463f6e8494ff9	7	3302009	1	0x949c3dd66d989fc3964c39897b38d1b5fe719dadd0d4d7c6b7c6fd082cbba77f
993	0x0000000000000000000000000000000000000000	0x0000000000000000	1651233	[]	59698	0x0000000000000000000000000000000000000000000000000000000000000000	61000000	2024-01-14T07:33:42.000Z	0x8292e9bac3297be13adfa98dff24f2fbeda55e4a6d16544d5ec1d1ce124c50ab	2	0xd983010b06846765746889676f312e32302e3132856c696e75780000000000005aa574332d7b66d3410f4ff22ebfdf6c8b8f470d53b707f06fbb73e99582baf04e63e5f0bd6ebfbdb4ee759417a6b8cf4258f4fcf40e82d9c8f6519fa8c2c60300	0x00000000000000000000000000000000000000200000020000000000000004000000001000000000008000000000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000020000000040000000100800000000800000000000000010000000000000000000000000000000000000000008000000000000000000000000000000200000080000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000800000	0x94428abac70ec7d5ada8c6a1d16ff32dcabbf3b9f30e324421ed7918d463051c	0x2e36ed1e3022cbf65c1695ee93bdb77562c2853d3edfb3b7bb5b9c791a20c1c0	0x1dcc4de8dec75d7aab85b567b6ccd41ad312451b948a7413f0a142fd40d49347	0x0ff33cc9c36299f9820a6a54682db55f972a0a6bf80f5a68bf5bbf57d749ea93	7	3302467	1	0xb95af7dd155f3255071c29440a23f927b135df39e1afd67aece34d98e9861224

Example Query

Query with partition filter

SELECT *
FROM `tt-blockchain.linea.blocks`
WHERE timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

logs

Event logs emitted by smart contracts during transaction execution, containing indexed topics for efficient filtering and ABI-encoded data payloads. Primary source for tracking contract interactions, token transfers, and state changes across blockchain networks.

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.
`address`	`STRING`	Contract address that emitted the event log. Hex-encoded, 0x-prefixed, 42-character string.
`topics`	`ARRAY<STRING>`	Indexed event parameters from the emitted log. Array of 66-character hex strings including 0x prefix, where the first element is the event signature hash and subsequent elements are indexed parameters.
`data`	`STRING`	ABI-encoded event or transaction data. Hex-encoded string 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.
`block_hash`	`STRING`	Unique identifier for the block. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event log within its containing block. Zero-indexed integer indicating the sequential order of logs emitted in the block.
`removed`	`BOOL`	Indicates whether the log was removed due to a chain reorganization.

Sample Data

data	topics	address	removed	log_index	block_hash	block_number	block_timestamp	transaction_hash	transaction_index
0x	[“0xbb47ee3e183a558b1a2ff0874b079f3fc5478b7454eacf2bfc5af2ff5878f972”]	0x5ff137d4b0fdcd49dca30c7cf57e578a026d2789	false	16	0x871c4ccb85b48272de6012e272f0c522ff5b89cb250e7d9bd8af22472c96f893	628044	2023-10-14T00:00:10.000Z	0xbdb17204987b67d8ad5a6633b29fbc487e8127394867b8f05d52dad710c21670	6
0x2d7ecfe0113e975162145172ba86e12c3627aaaef4cd50ba1bbb7f2df19d1a982d7ecfe0113e975162145172ba86e12c3627aaaef4cd50ba1bbb7f2df19d1a98000000000000000000000000000000000000000000000000000000000000000a	[“0x74bbc026808dcba59692d6a8bb20596849ca718e10e2432c6cdf48af865bc5d9”,“0x00000000000000000000000000000000000000000000000000000000000000b8”,“0x000000000000000000000000d56e4eab23cb81f43168f9f45211eb027b9ac7cc”]	0x38de71124f7a447a01d67945a51edce9ff491251	false	0	0x871c4ccb85b48272de6012e272f0c522ff5b89cb250e7d9bd8af22472c96f893	628044	2023-10-14T00:00:10.000Z	0xb563bd424ad00b511a0ac3dbe67273d761ef329ddc794aa2d758035761f0e93f	0
0x000000000000000000000000000000000000000000003496d6feb4299902236b000000000000000000000000000000000000000000000008aacb3a11f4161746	[“0xcf2aa50876cdfbb541206f89af0ee78d44a2abf8d328e37fa4917f982149848a”]	0x7f72e0d8e9abf9133a92322b8b50bd8e0f9dcfcb	false	7	0x871c4ccb85b48272de6012e272f0c522ff5b89cb250e7d9bd8af22472c96f893	628044	2023-10-14T00:00:10.000Z	0x1bcf8e6b18e1790890b7ddd8decbb204f8ba4c93e87daa383d57873d0731c5e5	3

Example Query

Query with partition filter

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

traces

Individual transaction execution steps recording internal operations, including contract calls, value transfers, and gas consumption. Used for analyzing complex transaction flows and debugging smart contract interactions.

Columns

Column	Type	Description
`from_address`	`STRING`	Address that initiated the transaction or internal operation. Hex-encoded, 0x-prefixed, 42-character string.
`gas`	`INT64`	Maximum gas units allocated for the transaction execution.
`gas_used`	`INT64`	Amount of gas consumed by the execution. Measured in gas units, representing the computational resources used to process the operation.
`to_address`	`STRING`	Address receiving the transaction or internal operation. Hex-encoded, 0x-prefixed, 42-character string.
`input`	`STRING`	Calldata or transaction payload sent with the call or transaction. Hex-encoded string starting with 0x, containing the function signature and encoded parameters for smart contract interactions.
`value`	`NUMERIC`	Amount transferred in the transaction or operation. Denominated in the smallest unit of the blockchain’s native currency.
`trace_type`	`STRING`	Type of trace operation executed within the transaction. Common values include CALL for contract calls, CREATE for contract deployments, DELEGATECALL for delegate calls, STATICCALL for static calls, and SELFDESTRUCT for contract destruction operations.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`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.
`trace_address`	`STRING`	Hierarchical position of the trace within the transaction’s execution tree. Comma-separated string of zero-indexed integers representing the depth and order of nested calls.
`output`	`STRING`	Return data from the smart contract execution or call. Hex-encoded string starting with 0x, containing the function’s return value in ABI-encoded format.
`error`	`STRING`	Error message returned when transaction execution fails. Empty when execution succeeds.
`revert_reason`	`STRING`	Human-readable explanation for why a transaction or call reverted during execution. Empty when execution succeeds.
`transaction_index`	`INT64`	Position of the transaction within its containing block. Zero-indexed integer indicating the sequential order of transactions in the block.
`trace_id`	`STRING`	Unique identifier for the trace operation within a transaction. Composite string combining the trace type and transaction hash, with optional trace address appended to distinguish between multiple operations of the same type.
`status`	`BOOL`	Success indicator for the operation. Boolean value where true indicates successful execution and false indicates failure.

Sample Data

gas	input	output	status	gas_used	trace_id	to_address	trace_type	block_number	from_address	trace_address	block_timestamp	transaction_hash	transaction_index
54115	0x0f66dfe7f1f4c66874536a0687a088d141fba0ba4e693fb9820eeba36ac774d9000000000000000000000000000000000000000000000000000000000000001b1fb8d7403514769932cf94ef6fad18784d771f16c0da7bb5106c665bba890f7336b672dbda3e20a079eb0596a531409dd918a595437248569fc2234899dd2b84	0x000000000000000000000000433704c40f80cbff02e86fd36bc8bac5e31eb0c1	true	3000	STATICCALL_0xc7ac75af67b80517fb5cf6ab8cfad414ef21f80e3dec12c93c380f2c05f88d15_1_0	0x0000000000000000000000000000000000000001	STATICCALL	11856144	0x0000000000000039cd5e8ae05257ce51c473ddd1	1,0	2024-11-09T22:15:31.000Z	0xc7ac75af67b80517fb5cf6ab8cfad414ef21f80e3dec12c93c380f2c05f88d15	0
54115	0x7272521c4ce081346c773f8df0be7498d80763b57ce344d6e4a576f14cb9438b000000000000000000000000000000000000000000000000000000000000001ced955adfe5d2d6504bbd1f94b974db971b51fb44cc871655ff165a552e71999c6c91b784a114fc37ee2d65992492ebd59cd247fcc96c421aef43065b2e4a558c	0x000000000000000000000000433704c40f80cbff02e86fd36bc8bac5e31eb0c1	true	3000	STATICCALL_0xd8c3040958a740422013fc04b89839c26baef2fc6d91ef3ce36c930afa70e82c_1_0	0x0000000000000000000000000000000000000001	STATICCALL	11841380	0x0000000000000039cd5e8ae05257ce51c473ddd1	1,0	2024-11-09T13:55:31.000Z	0xd8c3040958a740422013fc04b89839c26baef2fc6d91ef3ce36c930afa70e82c	1
54115	0xd0387bc6aab2e098fa6563bdcd079d0cff44812123c992ed317dbe13d63b10d4000000000000000000000000000000000000000000000000000000000000001c5abf0899d74692129b11c6e75f7b243ce3bfb2e677e2d3178c84a0c3555720ff4096fe711b227de49df93c178f330785994f769d26c5cb709a829016b1ce7414	0x000000000000000000000000433704c40f80cbff02e86fd36bc8bac5e31eb0c1	true	3000	STATICCALL_0xa0ed8626db4aef74bc1902c994e2be1c444dbcd11fef34eab00b95e4ca911778_1_0	0x0000000000000000000000000000000000000001	STATICCALL	11856417	0x0000000000000039cd5e8ae05257ce51c473ddd1	1,0	2024-11-09T22:25:30.000Z	0xa0ed8626db4aef74bc1902c994e2be1c444dbcd11fef34eab00b95e4ca911778	1

Example Query

Query with partition filter

SELECT *
FROM `tt-blockchain.linea.traces`
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_hash`	`STRING`	Unique identifier for the block. 66-character hex string including 0x prefix.
`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.
`from_address`	`STRING`	Address that initiated the transaction or internal operation. Hex-encoded, 0x-prefixed, 42-character string.
`gas`	`INT64`	Maximum gas units allocated for the transaction execution.
`gas_price`	`INT64`	Price per unit of gas for the transaction. Integer value denominated in the smallest unit of the blockchain’s native currency (wei for EVM chains).
`max_fee_per_gas`	`NUMERIC`	Maximum gas price per unit willing to be paid for transaction execution. Integer value denominated in wei for EVM chains, specified by the transaction sender as part of EIP-1559 fee market transactions.
`max_priority_fee_per_gas`	`NUMERIC`	Maximum tip per gas unit offered to validators for transaction priority. Integer value denominated in wei for EVM chains, specified by the transaction sender in EIP-1559 transactions to incentivize faster inclusion.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`input`	`STRING`	Calldata or transaction payload sent with the call or transaction. Hex-encoded string starting with 0x, containing the function signature and encoded parameters for smart contract interactions.
`nonce`	`INT64`	Sequential counter for transactions or operations from an account. Increments by 1 for each new transaction to prevent replay attacks and ensure transaction ordering.
`to_address`	`STRING`	Address receiving the transaction or internal operation. Hex-encoded, 0x-prefixed, 42-character string.
`transaction_index`	`INT64`	Position of the transaction within its containing block. Zero-indexed integer indicating the sequential order of transactions in the block.
`value`	`STRING`	Amount transferred in the transaction or operation. Denominated in the smallest unit of the blockchain’s native currency.
`transaction_type`	`INT64`	EIP-2718 transaction type indicator. Integer value representing the transaction format: 0 for legacy, 1 for EIP-2930 access list, 2 for EIP-1559 fee market, 3 for EIP-4844 blob transactions.
`chain_id`	`INT64`	Numeric identifier for the blockchain network. Integer value that uniquely identifies the blockchain according to EIP-155 chain ID standard.
`v`	`INT64`	ECDSA signature component v from the transaction signature. Integer value used for signature verification and public key recovery.
`r`	`STRING`	ECDSA signature component r from the transaction signature. 66-character hex string including 0x prefix.
`s`	`STRING`	ECDSA signature component s from the transaction signature. 66-character hex string including 0x prefix.
`y_parity`	`INT64`	ECDSA signature parity indicator for EIP-2718 typed transactions. Binary value (0 or 1) representing the y-coordinate parity of the public key recovery point.
`blob_gas_used`	`INT64`	Total gas consumed by blob transactions in the block. Measured in blob gas units, representing the data availability cost for EIP-4844 blob-carrying transactions.
`access_list`	`ARRAY<STRUCT<address STRING, storage_keys ARRAY<STRING>>>`	List of addresses and storage keys accessed during EIP-2930 access list transactions. Array of structs containing contract addresses and their associated storage slot keys that the transaction declares it will access.
`receipt_contract_address`	`STRING`	Contract address created by the transaction when deploying a new smart contract. Hex-encoded, 0x-prefixed, 42-character string. Null for all non-deployment transactions.
`receipt_cumulative_gas_used`	`INT64`	Total gas consumed by all transactions in the block up to and including this transaction. Integer value representing the cumulative sum of gas used, incrementing with each transaction in sequential order.
`receipt_effective_gas_price`	`INT64`	Actual gas price paid per unit for transaction execution. Integer value denominated in wei.
`receipt_gas_used`	`INT64`	Gas units consumed by this specific transaction.
`receipt_logs_bloom`	`STRING`	Bloom filter for efficiently querying event logs emitted by the transaction. 512-character hex string including 0x prefix, representing a 256-byte bit array used for probabilistic matching of log topics and addresses.
`receipt_status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true indicates successful execution and false indicates failure.
`receipt_transaction_index`	`INT64`	Position of the transaction within its containing block. Zero-indexed integer indicating the sequential order of transactions in the block.
`receipt_type`	`INT64`	Transaction encoding format identifier from EIP-2718. Integer value indicating the transaction type returned in the receipt.

Sample Data

r	s	v	gas	input	nonce	value	chain_id	y_parity	gas_price	block_hash	to_address	access_list	block_number	from_address	receipt_type	receipt_status	block_timestamp	max_fee_per_gas	receipt_gas_used	transaction_hash	transaction_type	receipt_logs_bloom	max_priority_fee_per_gas	receipt_cumulative_gas_used	receipt_effective_gas_price
0xd1a436370bc9a70d6d9aad461863dc745d8bf8371d4427fd4aeaaad06b5d1b04	0x1ef6625f2870764f64c2f49660280538176a16a722b54e22c0027042664efb20	0	21000	0x	87343	5000000000000021	59144	0	7000000007	0xc618f7891327c3640c7f4dbf04ee1cfe10348d7160b68a644a30e8e6547c3b88	0xe18c7d5503e49c78716710c40c8cd3785592a859	[{“address”:null,“storage_keys”:[]}]	268059	0x80c67432656d59144ceff962e8faf8926599bcf8	2	true	2023-08-24T15:19:41.000Z	200000000000	21000	0x9ab57694c285a2e33544aecfb10364b719da760de72a7a2ffd8b685d4cbd61d9	2	0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	7000000000	21000	7000000007
0xc03a848aa15b7471d64e0651f69715999cea74aec9026b99de33d7db310693f1	0x6ab633c76fee03c19154fd119576db32b8364bebfae47ec6fc25688216e0a065	1	21000	0x	88605	600000000000000163	59144	1	7000000007	0xa19ae0351c308b0165223c528a16b267f3eee943cebcd84d71da20eaeffdcd33	0x1a1051c39652c0ff81a819da4283871c3f076a3a	[{“address”:null,“storage_keys”:[]}]	268763	0xe4edb277e41dc89ab076a1f049f4a3efa700bce8	2	true	2023-08-24T17:40:29.000Z	200000000000	21000	0x366aef9ab0adf20a03e03045be7056ff49d0f832a423fe0d5b87677269868290	2	0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	7000000000	21000	7000000007
0x1b43472979219fd9be51f141a632a7ac0a451400e2a7bf2209ceb9c1b06d67a1	0x294ebdad2e9711edf60c449c0e88e534c3b8ac76d61efbda6a6fc8e55ec1ebc0	1	21000	0x	87286	232669000000000113	59144	1	7000000007	0x601f0e54865ca8ef605e6245ba67c4fac00b53a7625ce6bb9694be04bc219093	0x6c986054571db3067e5cadbd5e3d5395f5ea2c70	[{“address”:null,“storage_keys”:[]}]	267616	0x80c67432656d59144ceff962e8faf8926599bcf8	2	true	2023-08-24T13:51:05.000Z	200000000000	21000	0x3963a81ceccf9d74f6d82ce7c09b815c2822a717ac7211ab09f89e938f602435	2	0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	7000000000	21000	7000000007

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

blocks

logs

traces

transactions

Metrics

Primitives

Contracts

Blockchain

​Tables

​blocks

​logs

​traces

​transactions

Tables

blocks

logs

traces

transactions