blast

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.
`number`	`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.
`transaction_count`	`INT64`	Number of transactions included in the block.
`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.
`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.
`miner`	`STRING`	Address of the block producer who created the block. Hex-encoded, 0x-prefixed, 42-character string.
`parent_hash`	`STRING`	Hash of the parent block in the blockchain. 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.
`sha3_uncles`	`STRING`	Keccak-256 hash of the RLP-encoded list of uncle block headers. 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.
`transactions_root`	`STRING`	Merkle root hash of all transactions included in the block. 66-character hex string including 0x prefix.
`state_root`	`STRING`	Merkle root hash representing the complete state of the blockchain after block execution. 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.
`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.
`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.
`size`	`INT64`	Block size in bytes. Represents the total serialized size of the block data structure.
`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.
`mix_hash`	`STRING`	Hash value used in proof-of-work mining or consensus verification. 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	extra_data	logs_bloom	state_root	parent_hash	sha3_uncles	receipts_root	base_fee_per_gas	transaction_count	transactions_root
1433	0x4200000000000000000000000000000000000011	0x0000000000000000	83959	[]	145929	0x8997dbd77229477bbf5abe8373a30d5eda65475b8be4bfe351c528bbb31ae112	30000000	2024-02-26T20:02:13.000Z	0x329b4fe9df035e52143697f3eb22bb2bc55575628e54834444fe2fd9099fa5a2	0x	0x0000000000000000000000000000000000000000000000000000000000100000000000000000008000000000000000000000000000000000000000000000020000000000000c000000000000000000000000000000000000000000000000000100000080020000400000000000020800000000000000000000000008000000000000000000004000400000000000000001800000000000000000000000000000000000000000000000000000001000000004200000000000000000000000000000000000000080000000000100000000000002100000000000000100000020001000000000000000000000000000000000000000000000000000000008000000	0x5f02d383afb2368db7b4a280e1048e2d63b27151dcee1c8b2bfa5e3b16bdc6db	0xebe0e6c443748e28842f2c76acaa23a0b7131178b96ca63d12cf5e6745d8ac15	0x1dcc4de8dec75d7aab85b567b6ccd41ad312451b948a7413f0a142fd40d49347	0x22696335724948945178a4412a911c96313ab1bd6968549afd632dc009c66fc3	252	2	0xc2ade760a9816448bcf3c4c473f4af1358eb26c6caa28e2d908085ef61681bf0
903	0x4200000000000000000000000000000000000011	0x0000000000000000	59413	[]	64021	0x380b9a43eb92c40dd66c7ea7da36a4690c86174180f1b395de83e16bf80638a2	30000000	2024-02-26T06:24:01.000Z	0x0d0d649e5104c6eef434e35b3adb16ba839c3b55b3e884a062562c3ec4a0f5cf	0x	0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	0x7e46b367df4871772c4ea26aad6636346bd3c2b818cf7566045ff7bb23d4b8fb	0x53eb5c293d2f9cb15c44f09595bdd269fc549b2e745646793f57fcc09c8836a5	0x1dcc4de8dec75d7aab85b567b6ccd41ad312451b948a7413f0a142fd40d49347	0x2dd6c603f4c726da5d9cb945d4bbee3d27b4b1df2869ebb025d3a4445251e339	252	1	0xc4b3a6b916adcd20bc84318894c43b957a3d1efe1fa864e27bf14a4710ed6997
903	0x4200000000000000000000000000000000000011	0x0000000000000000	55404	[]	64021	0x504417de5de9016b90b936690baa1997ec06745df7c31ad5d99f4e6ddf62f463	30000000	2024-02-26T04:10:23.000Z	0xbfa490277d624986280325cd50514920025eef62066a1bd33140193388aee75e	0x	0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	0xf7f8b0e40370eb4c596c327c0e59210b3e4022c9019dec56775cd6f0ae2f45a0	0x579cdc25240941a16107689711c0a75b939fe4215f7ae04616b35a6435dae89e	0x1dcc4de8dec75d7aab85b567b6ccd41ad312451b948a7413f0a142fd40d49347	0xbb03b8b8b79a5677ef07323446dea10be4ef77917e2d4de861f65eb20a982a4e	252	1	0x4401c2726730539fa768b3b975a8e92de442bba36f5ec707026d6b03d04f09f3

Example Query

Query with partition filter

SELECT *
FROM `tt-blockchain.blast.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.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 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.
`address`	`STRING`	Contract address that emitted the event log. Hex-encoded, 0x-prefixed, 42-character string.
`data`	`STRING`	ABI-encoded event or transaction data. Hex-encoded string including 0x prefix.
`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.
`removed`	`BOOL`	Indicates whether the log was removed due to a chain reorganization.
`block_hash`	`STRING`	Unique identifier for the block. 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.

Sample Data

data	topics	address	removed	log_index	block_hash	block_number	block_timestamp	transaction_hash	transaction_index
0x000000000000000000000000000000000000000000000000000000000000000400000000000000000000000000000000000000000000000000000000000009ef0000000000000000000000000000000000000000000000000000000000000002	[“0xf7ab5a65307ab9788b10eab6a0e173842698dc9772bc3e58eaac1d6e0315b059”]	0x0000000000acc01064aa5280da3f1c41a35827bc	false	5	0x05c2d567c21d39b8863688cf67adf58c3e1e1db8871305f6b0cff2e94760536a	1776128	2024-04-06T00:07:51.000Z	0xb58be285457dca0ed4f450f31a446da6fd6eded2ca063998e6d57ee400974bed	2
0x000000000000000000000000000000000000000000000000000000000000000400000000000000000000000000000000000000000000000000000000000009ee0000000000000000000000000000000000000000000000000000000000000004	[“0xf7ab5a65307ab9788b10eab6a0e173842698dc9772bc3e58eaac1d6e0315b059”]	0x0000000000acc01064aa5280da3f1c41a35827bc	false	1	0x05c2d567c21d39b8863688cf67adf58c3e1e1db8871305f6b0cff2e94760536a	1776128	2024-04-06T00:07:51.000Z	0xb58be285457dca0ed4f450f31a446da6fd6eded2ca063998e6d57ee400974bed	2
0x000000000000000000000000000000000000000000000000000000006610945703000000000000000000000000000b0f00000000000000000000000000000000	[“0x3695e77f1dc9ee69125911ebaab12e1fd94718d613d1b557073bfa10d78aca6b”,“0x0000000000000000000000001a81b33c81957cad62b7167d1d43abcc79b1261e”]	0x86ba05aa6d1e92fe0dc85bccbc7847370238fd22	false	2	0xf4a4199cf745c46bf47f2132402194ddd61db7fe3299d50bf218f88366d3143a	1776384	2024-04-06T00:16:23.000Z	0x6675b9aae32fa802d0a9c0df626eb963f26d9ca73b6f2b33b3dd95f0297f6f94	3

Example Query

Query with partition filter

SELECT *
FROM `tt-blockchain.blast.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
`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.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`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.
`status`	`BOOL`	Success indicator for the operation. Boolean value where true indicates successful execution and false indicates failure.
`error`	`STRING`	Error message returned when transaction execution fails. Empty when execution succeeds.
`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.
`from_address`	`STRING`	Address that initiated the transaction or internal operation. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or internal operation. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`NUMERIC`	Amount transferred in the transaction or operation. Denominated in the smallest unit of the blockchain’s native currency.
`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.
`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.
`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.
`revert_reason`	`STRING`	Human-readable explanation for why a transaction or call reverted during execution. Empty when execution succeeds.
`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.

Sample Data

gas	input	value	status	trace_id	to_address	trace_type	block_number	from_address	trace_address	block_timestamp	transaction_hash
188130	0x	10427550000000000	true	CALL_0xc64ecf8980e10ac15c9328b39930969984a73b88b6bc2d968068f99d599533c9_0_60	0x82f0ecb78fea9fd74e6df333df5478d857c28000	CALL	391064	0x00000000000000adc04c56bf30ac9d3c0aaf14dc	0,60	2024-03-04T22:39:03.000Z	0xc64ecf8980e10ac15c9328b39930969984a73b88b6bc2d968068f99d599533c9
240161	0x	72450000000000	true	CALL_0xc64ecf8980e10ac15c9328b39930969984a73b88b6bc2d968068f99d599533c9_0_53	0x2dcc7c4ab800bf67380e2553be1e6891a36f18e7	CALL	391064	0x00000000000000adc04c56bf30ac9d3c0aaf14dc	0,53	2024-03-04T22:39:03.000Z	0xc64ecf8980e10ac15c9328b39930969984a73b88b6bc2d968068f99d599533c9
91501	0x	72450000000000	true	CALL_0xc64ecf8980e10ac15c9328b39930969984a73b88b6bc2d968068f99d599533c9_0_73	0x2dcc7c4ab800bf67380e2553be1e6891a36f18e7	CALL	391064	0x00000000000000adc04c56bf30ac9d3c0aaf14dc	0,73	2024-03-04T22:39:03.000Z	0xc64ecf8980e10ac15c9328b39930969984a73b88b6bc2d968068f99d599533c9

Example Query

Query with partition filter

SELECT *
FROM `tt-blockchain.blast.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_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_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.
`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).
`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.
`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.
`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.
`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.
`v`	`INT64`	ECDSA signature component v from the transaction signature. Integer value used for signature verification and public key recovery.
`value`	`STRING`	Amount transferred in the transaction or operation. Denominated in the smallest unit of the blockchain’s native currency.
`chain_id`	`INT64`	Numeric identifier for the blockchain network. Integer value that uniquely identifies the blockchain according to EIP-155 chain ID standard.
`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.
`mint`	`NUMERIC`	Amount of native currency minted and credited to the transaction sender. Denominated in the smallest unit of the blockchain’s native currency.
`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.
`source_hash`	`STRING`	Unique identifier for Layer 2 deposit transactions originating from Layer 1. 66-character hex string including 0x prefix.
`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_l1_gas_price`	`INT64`	Price per gas unit paid on Layer 1 for publishing Layer 2 transaction data. Denominated in wei.
`receipt_l1_gas_used`	`INT64`	Gas units consumed on Layer 1 for the transaction on Layer 2 rollup chains.
`receipt_type`	`INT64`	Transaction encoding format identifier from EIP-2718. Integer value indicating the transaction type returned in the receipt.
`receipt_l1_fee`	`INT64`	Fee paid for publishing the transaction data to Layer 1. Denominated in the smallest unit of the blockchain’s native currency.
`receipt_l1_fee_scalar`	`NUMERIC`	Scaling factor applied to Layer 1 fee calculations for Layer 2 transaction data publishing costs.
`receipt_deposit_nonce`	`INT64`	Sequential counter for Layer 2 deposit transactions originating from Layer 1. Increments by 1 for each new deposit to prevent replay attacks and ensure transaction ordering for cross-chain deposits.
`receipt_da_footprint_gas_scalar`	`INT64`	Scaling factor applied to the data availability footprint gas calculation for Layer 2 transaction data publishing costs.

Sample Data

r	s	gas	input	nonce	value	chain_id	gas_price	block_hash	to_address	access_list	block_number	from_address	receipt_type	receipt_l1_fee	receipt_status	block_timestamp	max_fee_per_gas	receipt_gas_used	transaction_hash	transaction_type	transaction_index	receipt_logs_bloom	receipt_l1_gas_used	receipt_l1_gas_price	max_priority_fee_per_gas	receipt_contract_address	receipt_transaction_index	receipt_cumulative_gas_used	receipt_effective_gas_price
0x4c7e05dd04da4bfff491549872ab0ec08104b176fabc597030e0cb43d2c7483f	0x6de398668501b9134ab110856addd013bd0015b61f6b155eca4f3e74747e4e6e	680251	0x60806040523480156200001157600080fd5b5060405162000f3f38038062000f3f833981016040819052620000349162000349565b338282600362000045838262000442565b50600462000054828262000442565b5050506001600160a01b0381166200008757604051631e4fbdf760e01b8152600060048201526024015b60405180910390fd5b6200009281620000c1565b50620000b933620000a66012600a62000623565b620000b390600a6200063b565b62000113565b50506200066b565b600580546001600160a01b038381166001600160a01b0319831681179093556040519116919082907f8be0079c531659141344cd1fd0a4f28419497f9722a3daafe3b4186f6b6457e090600090a35050565b6001600160a01b0382166200013f5760405163ec442f0560e01b8152600060048201526024016200007e565b6200014d6000838362000151565b5050565b6001600160a01b0383166200018057806002600082825462000174919062000655565b90915550620001f49050565b6001600160a01b03831660009081526020819052604090205481811015620001d55760405163391434e360e21b81526001600160a01b038516600482015260248101829052604481018390526064016200007e565b6001600160a01b03841660009081526020819052604090209082900390555b6001600160a01b038216620002125760028054829003905562000231565b6001600160a01b03821660009081526020819052604090208054820190555b816001600160a01b0316836001600160a01b03167fddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef836040516200027791815260200190565b60405180910390a3505050565b634e487b7160e01b600052604160045260246000fd5b600082601f830112620002ac57600080fd5b81516001600160401b0380821115620002c957620002c962000284565b604051601f8301601f19908116603f01168101908282118183101715620002f457620002f462000284565b816040528381526020925086838588010111156200031157600080fd5b600091505b8382101562000335578582018301518183018401529082019062000316565b600093810190920192909252949350505050565b600080604083850312156200035d57600080fd5b82516001600160401b03808211156200037557600080fd5b62000383868387016200029a565b935060208501519150808211156200039a57600080fd5b50620003a9858286016200029a565b9150509250929050565b600181811c90821680620003c857607f821691505b602082108103620003e957634e487b7160e01b600052602260045260246000fd5b50919050565b601f8211156200043d57600081815260208120601f850160051c81016020861015620004185750805b601f850160051c820191505b81811015620004395782815560010162000424565b5050505b505050565b81516001600160401b038111156200045e576200045e62000284565b62000476816200046f8454620003b3565b84620003ef565b602080601f831160018114620004ae5760008415620004955750858301515b600019600386901b1c1916600185901b17855562000439565b600085815260208120601f198616915b82811015620004df57888601518255948401946001909101908401620004be565b5085821015620004fe5787850151600019600388901b60f8161c191681555b5050505050600190811b01905550565b634e487b7160e01b600052601160045260246000fd5b600181815b80851115620005655781600019048211156200054957620005496200050e565b808516156200055757918102915b93841c939080029062000529565b509250929050565b6000826200057e575060016200061d565b816200058d575060006200061d565b8160018114620005a65760028114620005b157620005d1565b60019150506200061d565b60ff841115620005c557620005c56200050e565b50506001821b6200061d565b5060208310610133831016604e8410600b8410161715620005f6575081810a6200061d565b62000602838362000524565b80600019048211156200061957620006196200050e565b0290505b92915050565b60006200063460ff8416836200056d565b9392505050565b80820281158282048414176200061d576200061d6200050e565b808201808211156200061d576200061d6200050e565b6108c4806200067b6000396000f3fe608060405234801561001057600080fd5b50600436106100cf5760003560e01c806370a082311161008c57806395d89b411161006657806395d89b41146101aa578063a9059cbb146101b2578063dd62ed3e146101c5578063f2fde38b146101fe57600080fd5b806370a082311461015e578063715018a6146101875780638da5cb5b1461018f57600080fd5b806306fdde03146100d4578063095ea7b3146100f257806318160ddd1461011557806323b872dd14610127578063313ce5671461013a57806340c10f1914610149575b600080fd5b6100dc610211565b6040516100e9919061070e565b60405180910390f35b610105610100366004610778565b6102a3565b60405190151581526020016100e9565b6002545b6040519081526020016100e9565b6101056101353660046107a2565b6102bd565b604051601281526020016100e9565b61015c610157366004610778565b6102e1565b005b61011961016c3660046107de565b6001600160a01b031660009081526020819052604090205490565b61015c6102f7565b6005546040516001600160a01b0390911681526020016100e9565b6100dc61030b565b6101056101c0366004610778565b61031a565b6101196101d3366004610800565b6001600160a01b03918216600090815260016020908152604080832093909416825291909152205490565b61015c61020c3660046107de565b610328565b60606003805461022090610833565b80601f016020809104026020016040519081016040528092919081815260200182805461024c90610833565b80156102995780601f1061026e57610100808354040283529160200191610299565b820191906000526020600020905b81548152906001019060200180831161027c57829003601f168201915b5050505050905090565b6000336102b181858561036b565b60019150505b92915050565b6000336102cb85828561037d565b6102d68585856103fb565b506001949350505050565b6102e961045a565b6102f38282610487565b5050565b6102ff61045a565b61030960006104bd565b565b60606004805461022090610833565b6000336102b18185856103fb565b61033061045a565b6001600160a01b03811661035f57604051631e4fbdf760e01b8152600060048201526024015b60405180910390fd5b610368816104bd565b50565b610378838383600161050f565b505050565b6001600160a01b0383811660009081526001602090815260408083209386168352929052205460001981146103f557818110156103e657604051637dc7a0d960e11b81526001600160a01b03841660048201526024810182905260448101839052606401610356565b6103f58484848403600061050f565b50505050565b6001600160a01b03831661042557604051634b637e8f60e11b815260006004820152602401610356565b6001600160a01b03821661044f5760405163ec442f0560e01b815260006004820152602401610356565b6103788383836105e4565b6005546001600160a01b031633146103095760405163118cdaa760e01b8152336004820152602401610356565b6001600160a01b0382166104b15760405163ec442f0560e01b815260006004820152602401610356565b6102f3600083836105e4565b600580546001600160a01b038381166001600160a01b0319831681179093556040519116919082907f8be0079c531659141344cd1fd0a4f28419497f9722a3daafe3b4186f6b6457e090600090a35050565b6001600160a01b0384166105395760405163e602df0560e01b815260006004820152602401610356565b6001600160a01b03831661056357604051634a1406b160e11b815260006004820152602401610356565b6001600160a01b03808516600090815260016020908152604080832093871683529290522082905580156103f557826001600160a01b0316846001600160a01b03167f8c5be1e5ebec7d5bd14f71427d1e84f3dd0314c0f7b2291e5b200ac8c7c3b925846040516105d691815260200190565b60405180910390a350505050565b6001600160a01b03831661060f578060026000828254610604919061086d565b909155506106819050565b6001600160a01b038316600090815260208190526040902054818110156106625760405163391434e360e21b81526001600160a01b03851660048201526024810182905260448101839052606401610356565b6001600160a01b03841660009081526020819052604090209082900390555b6001600160a01b03821661069d576002805482900390556106bc565b6001600160a01b03821660009081526020819052604090208054820190555b816001600160a01b0316836001600160a01b03167fddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef8360405161070191815260200190565b60405180910390a3505050565b600060208083528351808285015260005b8181101561073b5785810183015185820160400152820161071f565b506000604082860101526040601f19601f8301168501019250505092915050565b80356001600160a01b038116811461077357600080fd5b919050565b6000806040838503121561078b57600080fd5b6107948361075c565b946020939093013593505050565b6000806000606084860312156107b757600080fd5b6107c08461075c565b92506107ce6020850161075c565b9150604084013590509250925092565b6000602082840312156107f057600080fd5b6107f98261075c565b9392505050565b6000806040838503121561081357600080fd5b61081c8361075c565b915061082a6020840161075c565b90509250929050565b600181811c9082168061084757607f821691505b60208210810361086757634e487b7160e01b600052602260045260246000fd5b50919050565b808201808211156102b757634e487b7160e01b600052601160045260246000fdfea26469706673582212204d7841638dc9ced6391696a2cdfdecc60dadba5609654aee754332e2c039e7e564736f6c6343000814003300000000000000000000000000000000000000000000000000000000000000400000000000000000000000000000000000000000000000000000000000000080000000000000000000000000000000000000000000000000000000000000000c426c617374204d65726b6c7900000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000008424c4d45524b4c59000000000000000000000000000000000000000000000000	85	0	81457	10859064	0x1da4e973c919ef8420babe2c49dc67a23fe1823904e7376877a30ec8d87adbb8		[{“address”:null,“storage_keys”:[]}]	4381284	0x7c45fb10a18f834a47cc3f470e97140a399b6af8	2	620824266137	true	2024-06-05T07:26:23.000Z	31262417	680251	0xc9491f29ffd44247d19dd0f1fa8164f5e55ce84f905a1828c6fd2379a6db788b	2	17	0x00000000000000000000000000000000000000000000000000800000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000000000008000000000001000000000000000000000000000000000000020000000000000000000800000400000000000000000010000000400000000000000000000000000400000000000000000000000000002000000000000000000000000000000000000000000000000000000000000000000000000002000002000000000000000000000000000000000000000000080000000020000000000000000000000000000000000000000000000000000000000000000000	62432	9040006625	711353	0x83cc865d0a2f9d43799ff9fcb46fa6b249b258d3	17	3052133	10859064
0x5a007ca0af012e4763f35739f399cf9f611eb61e202e63bb0df726b718759320	0x43d103cd4f8d6ac55b3fac96865382a522ddcc32ce4fdfcaf1edf365d33f9e3b	21000	0x	410	320500000000009021	81457	10940416	0xa8e1e27c2f3260f8cceaea002eb00ff6d875ad3b162eb317e87ecae0a8d0a2f1	0x80c67432656d59144ceff962e8faf8926599bcf8	[{“address”:null,“storage_keys”:[]}]	4397996	0x110b80df62583c91f4f00047a51b512cf848e953	2	42457463527	true	2024-06-05T16:43:27.000Z	30838885	21000	0xe132abd5ad570a9a74b3dd0cb42f15c3d454b3eec8d18f45d20c7e44f39b7e59	2	17	0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	1924	20061171486	894442		17	4801101	10940416
0x499528e9041118f7c132d79590650eb7cc265283b5dd0f19759a415631c0002e	0x9b76db017e3c9033d6c6b72b34489601db41176ebd0e44aacc81bd2e36ee41f	21000	0x	22	642484359950	81457	11622519	0x34d610a55bdeba7d54e1d914b74337c45536e6a65151abd144a89356c7cfeabf	0xfa96971bbd9150cec95f59c8c2b747cc7b3c72db	[{“address”:null,“storage_keys”:[]}]	4400770	0x65960e4e68544b0afb9cbf50d71b93203769e359	2	46357519328	true	2024-06-05T18:15:55.000Z	116231190	21000	0x706b470ad3e42f3c7004a37ba4cdd6a1cd7a40c700806c8f04fdf4b3e3c0e014	2	17	0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	1844	22854229558	1000000		17	4060366	11622519

Example Query

Query with partition filter

SELECT *
FROM `tt-blockchain.blast.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