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.
numberINT64Sequential block number indicating the position of the block in the blockchain. Increments by 1 for each new block in the chain.
l1_block_numberINT64Block number on the Layer 1 blockchain corresponding to this Layer 2 block or transaction. Integer value representing the L1 block height at the time of L2 block production or transaction submission.
block_hashSTRINGUnique identifier for the block. 66-character hex string including 0x prefix.
transaction_countINT64Number of transactions included in the block.
gas_limitINT64Maximum 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_usedINT64Amount of gas consumed by the execution. Measured in gas units, representing the computational resources used to process the operation.
base_fee_per_gasINT64Minimum 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.
minerSTRINGAddress of the block producer who created the block. Hex-encoded, 0x-prefixed, 42-character string.
parent_hashSTRINGHash of the parent block in the blockchain. 66-character hex string including 0x prefix.
nonceSTRINGSequential counter for transactions or operations from an account. Increments by 1 for each new transaction to prevent replay attacks and ensure transaction ordering.
sha3_unclesSTRINGKeccak-256 hash of the RLP-encoded list of uncle block headers. 66-character hex string including 0x prefix.
logs_bloomSTRINGBloom 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_rootSTRINGMerkle root hash of all transactions included in the block. 66-character hex string including 0x prefix.
state_rootSTRINGMerkle root hash representing the complete state of the blockchain after block execution. 66-character hex string including 0x prefix.
receipts_rootSTRINGMerkle root hash of all transaction receipts in the block. 66-character hex string including 0x prefix.
difficultyINT64Mining 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_difficultyNUMERICCumulative 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.
sizeINT64Block size in bytes. Represents the total serialized size of the block data structure.
extra_dataSTRINGArbitrary 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_hashSTRINGHash value used in proof-of-work mining or consensus verification. 66-character hex string including 0x prefix.
unclesARRAY<STRING>List of uncle block hashes included in the block. Empty array for chains not supporting uncle blocks in their consensus mechanism.
send_countINT64Number of outbound messages or cross-chain communications sent from the Layer 2 to Layer 1 in the block. Integer value representing the count of L2-to-L1 message transactions included in the block for Arbitrum-based rollup chains.
send_rootSTRINGMerkle root hash of all outbound Layer 2 to Layer 1 messages in the block. 66-character hex string including 0x prefix.
sizeminernoncenumberunclesgas_usedmix_hashgas_limitsend_roottimestampblock_hashdifficultyextra_datalogs_bloomsend_countstate_rootparent_hashsha3_unclesreceipts_rootl1_block_numberbase_fee_per_gastotal_difficultytransaction_counttransactions_root
8530xa4b000000000000000000073657175656e6365720x00000000000b769e78819701[]3317930x0000000000010fac0000000001039d63000000000000000a000000000000000011258999068426240x677f1f042338fc0337efd0735e08a39e4cf57de99f5bb8dad5c67997500df0b12023-04-10T00:00:00.000Z0x38ec1451c68da19a7a4fbeb6c67e358175a9fd725fa94cc20e6241dbbd99662d10x677f1f042338fc0337efd0735e08a39e4cf57de99f5bb8dad5c67997500df0b10x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000695480x45c6fa9786654d5362f927985bb2cb07eaecd276564a3a83182e4f66522757da0xb734bf5970cbf26571b2807df6501cc1875fa631ab1db16ffc98e581f085d3920x1dcc4de8dec75d7aab85b567b6ccd41ad312451b948a7413f0a142fd40d493470xf44f1d244e1b94ce1454c33e89e1175008695a67b24b59e84df172a91af98364170141151000000005661188520xb01b33b722cf0de4aa28c6f24835eb3c062307d170453651d2cfe6ddd2e7a7f0
11030xa4b000000000000000000073657175656e6365720x00000000000b769e78819702[]8697650x0000000000010fac0000000001039d63000000000000000a000000000000000011258999068426240x677f1f042338fc0337efd0735e08a39e4cf57de99f5bb8dad5c67997500df0b12023-04-10T00:00:01.000Z0x61bb39b8316eeca362c47fbde0d604db5fe76387c5b4ffcda02c4c4357f6421d10x677f1f042338fc0337efd0735e08a39e4cf57de99f5bb8dad5c67997500df0b10x00000000000000000000000000000000000000000000000200000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000020800000008000000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000110000000000000000000000000800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001000000000000002000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000100000000000400000000000000000695480x0b8540f28d4314799ef133629a84ea9fb019da8ce6bd79abc5464a347c9e1ba80x38ec1451c68da19a7a4fbeb6c67e358175a9fd725fa94cc20e6241dbbd99662d0x1dcc4de8dec75d7aab85b567b6ccd41ad312451b948a7413f0a142fd40d493470x4fd2808a3aaea9723637916474424a74600509772fcee2f76eeefd4164255b47170141151000000005661188640xc560849adccfdc7187bef69ea8de2771995c18ba75e20fe51ee04fec2c3c3b16
15120xa4b000000000000000000073657175656e6365720x00000000000b769e78819716[]18114710x0000000000010fac0000000001039d63000000000000000a000000000000000011258999068426240x677f1f042338fc0337efd0735e08a39e4cf57de99f5bb8dad5c67997500df0b12023-04-10T00:00:04.000Z0x83b37bbe07b5faad41acd88afd36d5f8221dd2cc91eddfab7875bf2b74ef210410x677f1f042338fc0337efd0735e08a39e4cf57de99f5bb8dad5c67997500df0b10x000000000000000040000000000000000080000000000000000000000010000004200000040000000000000000000000000040000000000000000000002000000200000100000048000808080001000008000000000000000010001000000000000000008000000000b0000408000000000000000000400000000114000000000000028000000000200000000800800000000000400000000000000000000000020000000000000100000000000000000000000100000010001000000000000000000002002100000002000000000010000040000000000000200000000000000410000000000000004000000000040000410000000000c00000000400004000695480xf03e21e4b2ec23dfe09a14249a8e844cec52e4cb71f0852b43fcadc4cdd877080xc06fe2c80e9a506efce865c19cd2b617feaa36a2e248815b10dd5b5914ccbd740x1dcc4de8dec75d7aab85b567b6ccd41ad312451b948a7413f0a142fd40d493470x0ff75f5a2b44939582f1957647ae855c45fe4e905b2b73a7f34d600cd3cea83d170141151000000005661190050x7c176be0b61123187e61a9b52329b6f69ec16b357008059eec08626debecb7bd
Query with partition filter
SELECT *
FROM `tt-blockchain.arbitrum.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.
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.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event log within its containing block. Zero-indexed integer indicating the sequential order of logs emitted in the block.
addressSTRINGContract address that emitted the event log. Hex-encoded, 0x-prefixed, 42-character string.
dataSTRINGABI-encoded event or transaction data. Hex-encoded string including 0x prefix.
topicsARRAY<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.
removedBOOLIndicates whether the log was removed due to a chain reorganization.
block_hashSTRINGUnique identifier for the block. 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.
datatopicsaddressremovedlog_indexblock_hashblock_numberblock_timestamptransaction_hashtransaction_index
0x[“0x00058a56ea94653cdf4f152d227ace22d4c00ad99e2a43f58cb7d9e3feb295f2”,“0x0000000000000000000000002f2a2543b76a4166549f7aab2e75bef0aefc5b0f”,“0x000000000000000000000000022824cdbe3854f922eedeb8c925fb2a8182b78c”]0xf4b1486dd74d07706052a33d31d7c0aafd0659e1false400x2004993d6718e75108bd11050e43325b5ba46f7e6a948a77ab5c53d9bca33e0f802247652023-04-14T02:54:28.000Z0x3a79dc058ff7ebb1c4abcfb16b425a092564b022ce1edce93f2b0732c5e9a40d1
0x[“0x00058a56ea94653cdf4f152d227ace22d4c00ad99e2a43f58cb7d9e3feb295f2”,“0x0000000000000000000000002f2a2543b76a4166549f7aab2e75bef0aefc5b0f”,“0x00000000000000000000000051cb07c606b3a5d1062200a4829b362d10943259”]0x2032b9a8e9f7e76768ca9271003d3e43e1616b1ffalse270x26b9df0796732dc98cb9100037270d5553d8bd9a55bd9b2e784c3d7436fa3543802734382023-04-14T06:17:57.000Z0x6eb5f28bf2e131d5b8f5a88df4cd721516e258825fba4323d408f78b6aa1af151
0x[“0x00058a56ea94653cdf4f152d227ace22d4c00ad99e2a43f58cb7d9e3feb295f2”,“0x0000000000000000000000002f2a2543b76a4166549f7aab2e75bef0aefc5b0f”,“0x00000000000000000000000068dcf10e26ced2e838c677b3549e318d1560dcda”]0xf4b1486dd74d07706052a33d31d7c0aafd0659e1false380xf3da8d95aa81c5a7cf59b24b1879c3497b6febd431b870d58da3dad7a9a7c302803831132023-04-14T13:52:39.000Z0xb67b54a58efc2b81fd54075a1fa8c97614b34b7e6a3a12379ac66305eb5b8dbc1
Query with partition filter
SELECT *
FROM `tt-blockchain.arbitrum.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.
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.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
trace_typeSTRINGType 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.
statusBOOLSuccess indicator for the operation. Boolean value where true indicates successful execution and false indicates failure.
errorSTRINGError message returned when transaction execution fails. Empty when execution succeeds.
trace_addressSTRINGHierarchical 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_addressSTRINGAddress that initiated the transaction or internal operation. Hex-encoded, 0x-prefixed, 42-character string.
to_addressSTRINGAddress receiving the transaction or internal operation. Hex-encoded, 0x-prefixed, 42-character string.
valueSTRINGAmount transferred in the transaction or operation. Denominated in the smallest unit of the blockchain’s native currency.
inputSTRINGCalldata 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.
outputSTRINGReturn data from the smart contract execution or call. Hex-encoded string starting with 0x, containing the function’s return value in ABI-encoded format.
gasINT64Maximum gas units allocated for the transaction execution.
gas_usedINT64Amount of gas consumed by the execution. Measured in gas units, representing the computational resources used to process the operation.
transaction_indexINT64Position of the transaction within its containing block. Zero-indexed integer indicating the sequential order of transactions in the block.
revert_reasonSTRINGHuman-readable explanation for why a transaction or call reverted during execution. Empty when execution succeeds.
trace_idSTRINGUnique 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.
before_evm_transfersARRAY<STRUCT<purpose STRING, from_address STRING, to_address STRING, value NUMERIC>>Array of native currency transfers that occurred before the trace operation executed. Each transfer includes a purpose label, source address, destination address, and transfer amount in the smallest unit of the native currency.
after_evm_transfersARRAY<STRUCT<purpose STRING, from_address STRING, to_address STRING, value NUMERIC>>Array of native currency transfers that occurred after the trace operation executed. Each transfer includes a purpose label, source address, destination address, and transfer amount in the smallest unit of the native currency.
gaserrorinputvalueoutputstatusgas_usedtrace_idto_addresstrace_typeblock_numberfrom_addressrevert_reasontrace_addressblock_timestamptransaction_hashtransaction_indexafter_evm_transfersbefore_evm_transfers
00x00xtrue0INVALID_0xbcb30f60d87f18e7746eede62216cb797df202be942a106eba06b310a3b6121b_0_0_0_2_00x0000000000000000000000000000000000000000INVALID1190271270x00000000000000000000000000000000000000640,0,0,2,02023-08-07T11:17:40.000Z0xbcb30f60d87f18e7746eede62216cb797df202be942a106eba06b310a3b6121b2[{“value”:null,“purpose”:null,“to_address”:null,“from_address”:null}][{“value”:null,“purpose”:null,“to_address”:null,“from_address”:null}]
00x00xtrue0INVALID_0xe65152e9b1102d274579589cbec8f387723c5c81ca1cfaf57e9fc968c443c54c_40x0000000000000000000000000000000000000000INVALID1191834120xee488a11475d588908001e0e99e4fd89abda654542023-08-07T22:38:33.000Z0xe65152e9b1102d274579589cbec8f387723c5c81ca1cfaf57e9fc968c443c54c1[{“value”:null,“purpose”:null,“to_address”:null,“from_address”:null}][{“value”:null,“purpose”:null,“to_address”:null,“from_address”:null}]
85896630xa3638a8dcc5f672e65e9a9557e5ec6da3dc563e2a45fbdb4af73364abcc51d29000000000000000000000000000000000000000000000000000000000000001cf19221568013598c3536985cf2d86a06ada33875b4aff4034b47d0c6c8cbce9e68d3fd6d8dc4636709f042deace21806398dd2240ca3aa2c64aecb375708d4920x0000000000000000000000001a8ed0d3ad42c9019cc141aace7e5fb6e576b917true3000STATICCALL_0xf2dbce24ddf1e1451abc9dd27a2b06e4f98174ee9efc1146d5097d96ebbc2469_0_00x0000000000000000000000000000000000000001STATICCALL1190699760xa0cc33dd6f4819d473226257792afe230ec3c67f0,02023-08-07T14:18:28.000Z0xf2dbce24ddf1e1451abc9dd27a2b06e4f98174ee9efc1146d5097d96ebbc24692[{“value”:null,“purpose”:null,“to_address”:null,“from_address”:null}][{“value”:null,“purpose”:null,“to_address”:null,“from_address”:null}]
Query with partition filter
SELECT *
FROM `tt-blockchain.arbitrum.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.
ColumnTypeDescription
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_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, microsecond precision.
l1_block_numberINT64Block number on the Layer 1 blockchain corresponding to this Layer 2 block or transaction. Integer value representing the L1 block height at the time of L2 block production or transaction submission.
block_hashSTRINGUnique identifier for the block. 66-character hex string including 0x prefix.
from_addressSTRINGAddress that initiated the transaction or internal operation. Hex-encoded, 0x-prefixed, 42-character string.
gasINT64Maximum gas units allocated for the transaction execution.
gas_priceSTRINGPrice 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_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
inputSTRINGCalldata 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.
nonceINT64Sequential counter for transactions or operations from an account. Increments by 1 for each new transaction to prevent replay attacks and ensure transaction ordering.
rSTRINGECDSA signature component r from the transaction signature. 66-character hex string including 0x prefix.
sSTRINGECDSA signature component s from the transaction signature. 66-character hex string including 0x prefix.
to_addressSTRINGAddress receiving the transaction or internal operation. Hex-encoded, 0x-prefixed, 42-character string.
transaction_indexINT64Position of the transaction within its containing block. Zero-indexed integer indicating the sequential order of transactions in the block.
vINT64ECDSA signature component v from the transaction signature. Integer value used for signature verification and public key recovery.
valueFLOAT64Amount transferred in the transaction or operation. Denominated in the smallest unit of the blockchain’s native currency.
beneficiarySTRINGArbitrum-specific field indicating the address designated to receive refunds or excess fees from the transaction. Null for standard user transactions; populated for special Arbitrum transaction types like retryable tickets.
access_listARRAY<STRUCT<address STRING, storageKeys 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.
chain_idINT64Numeric identifier for the blockchain network. Integer value that uniquely identifies the blockchain according to EIP-155 chain ID standard.
deposit_valueNUMERICValue of ETH deposited from L1 to L2 in wei, relevant for cross-layer transactions initiated on Ethereum mainnet. Null for standard L2-only transactions.
l1_base_feeNUMERICL1 base fee component of the transaction cost, denominated in wei. Represents the Ethereum mainnet gas price used to calculate L1 data posting costs for this Arbitrum transaction.
max_fee_per_gasNUMERICMaximum 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_gasFLOAT64Maximum 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.
max_refundSTRINGMaximum gas refund amount for retried L1-to-L2 messages denominated in wei. Null for standard L2 transactions; only populated for Arbitrum-specific retry mechanisms.
max_submission_feeNUMERICMaximum fee (in wei) allocated for L1 to L2 message submission costs when bridging assets or data to Arbitrum. Null for transactions that don’t involve cross-chain messaging or L1-originated transactions.
refund_toSTRINGAddress designated to receive gas refunds for this transaction. Null for most transactions; populated for Arbitrum-specific transaction types involving cross-chain operations.
request_idSTRINGUnique identifier for retryable transaction requests on Arbitrum-based Layer 2 chains.
retry_dataSTRINGEncoded data to be executed in a retry attempt when an Arbitrum L1-to-L2 message fails. Null for standard transactions and non-retryable messages.
retry_toSTRINGAddress to which a retried Arbitrum transaction should be sent. Null for standard transactions; populated for retryable ticket transactions on Arbitrum’s Layer 2.
retry_valueNUMERICNumeric value (in wei) to be sent when retrying a failed cross-chain transaction on Arbitrum. Null for standard transactions that are not retryable ticket operations.
submission_fee_refundSTRINGAmount of unused submission fee refunded to the user after cross-chain transaction processing. Denominated in wei; null for standard L2 transactions that don’t involve L1-to-L2 message submissions.
ticket_idSTRINGRetryable ticket identifier for Arbitrum cross-chain messages that can be reexecuted if initial execution fails. Null for standard transactions; populated for Layer 1 to Layer 2 deposit transactions.
transaction_typeINT64EIP-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.
arb_sub_typeINT64Arbitrum-specific transaction subtype indicator for specialized L2 operations. Null for standard user transactions; populated for system-level messages like retryable ticket redemptions or batch submissions.
arb_typeINT64Arbitrum-specific transaction classification code indicating the type of Layer 2 transaction. Null for standard user-initiated transactions; populated for system-level operations like retryable tickets or batch submissions.
index_in_parentINT64Position of this transaction within its parent transaction when part of a batched or grouped submission. Null for standalone transactions not part of a batch structure.
l1_sequence_numberSTRINGSequence number assigned to this transaction within the batch of L1-to-L2 messages posted to Ethereum. Null for L2-native transactions; populated only for retryable tickets and L1-initiated transactions.
parent_request_idSTRINGIdentifier linking this transaction to a parent cross-chain request in Arbitrum’s retryable ticket system. Null for standard transactions; populated for L2 transactions initiated from L1 via the Arbitrum bridge.
receipt_contract_addressSTRINGContract 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_usedINT64Total 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_priceINT64Actual gas price paid per unit for transaction execution. Integer value denominated in wei.
receipt_gas_usedINT64Gas units consumed by this specific transaction.
receipt_logs_bloomSTRINGBloom 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_statusBOOLTransaction execution outcome indicator. Boolean value where true indicates successful execution and false indicates failure.
receipt_transaction_indexINT64Position of the transaction within its containing block. Zero-indexed integer indicating the sequential order of transactions in the block.
receipt_typeINT64Transaction encoding format identifier from EIP-2718. Integer value indicating the transaction type returned in the receipt.
receipt_gas_used_for_l1INT64Gas units consumed on Layer 1 for publishing this Layer 2 transaction to the Layer 1 blockchain.
receipt_return_codeINT64Status code returned by the transaction execution on Arbitrum. Null for successful transactions; populated with error codes when transaction execution fails.
receipt_return_dataSTRINGData returned by the contract after transaction execution, hex-encoded. Null for most transactions; populated when contracts explicitly return values or revert with custom error data.
rsvgasinputnoncevaluearb_typechain_idretry_togas_pricerefund_toticket_idblock_hashmax_refundrequest_idretry_datato_addressaccess_listbeneficiaryl1_base_feeretry_valuearb_sub_typeblock_numberfrom_addressreceipt_typedeposit_valuereceipt_statusblock_timestampindex_in_parentl1_block_numbermax_fee_per_gasreceipt_gas_usedtransaction_hashtransaction_typeparent_request_idtransaction_indexl1_sequence_numbermax_submission_feereceipt_logs_bloomreceipt_return_codereceipt_return_datasubmission_fee_refundreceipt_gas_used_for_l1max_priority_fee_per_gasreceipt_contract_addressreceipt_transaction_indexreceipt_cumulative_gas_usedreceipt_effective_gas_price
0xed7e2f543527738f31f13d59822665ad7cfd8435e395f9414efc6c48606a0c00x44281b71096e7a2c7bec090fb298785e86d2f984919c1951ee3624380f0fb314843573282840x60806040526000805461ffff1916905534801561001b57600080fd5b5060fb8061002a6000396000f3fe6080604052348015600f57600080fd5b506004361060325760003560e01c80630c55699c146037578063b49004e914605b575b600080fd5b60005460449061ffff1681565b60405161ffff909116815260200160405180910390f35b60616063565b005b60008054600191908190607a90849061ffff166096565b92506101000a81548161ffff021916908361ffff160217905550565b61ffff81811683821601908082111560be57634e487b7160e01b600052601160045260246000fd5b509291505056fea2646970667358221220666c87ec501268817295a4ca1fc6e3859faf241f38dd688f145135970920009264736f6c634300081200333042161510000000x1238a84d039dcb947cfa5a812adb6f91093e8633e14326878e5fb7d359dced20[]3119165260xd0d2e4f328163fffb48caf81e2977efcbc5452560true2025-03-03T19:49:00.000Z219685491871850xf8892ab95ef4a1900745c907957a85ce6c75f9ad387a3e2e7bbbd2985b6d15070440x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000771760x694fb7127e97be20604c30bbd8909ea2e30c5e6144793970340726000
0x47e1bff27f76a31280ac0b3d3fc2ef8b9f12f1334846f3c817f81b9c04aafdf40x22b78369f6924ce11df5b04d122d3ec31a414e8506acfb6ed206254af1e11360843573601650x6080604052737500a83df2af99b2755c47b6b321a8217d876a856000806101000a81548173ffffffffffffffffffffffffffffffffffffffff021916908373ffffffffffffffffffffffffffffffffffffffff160217905550652d79883d20003410156100a1576040517f08c379a000000000000000000000000000000000000000000000000000000000815260040161009890610170565b60405180910390fd5b60008054906101000a900473ffffffffffffffffffffffffffffffffffffffff1673ffffffffffffffffffffffffffffffffffffffff166108fc652d79883d20009081150290604051600060405180830381858888f1935050505015801561010d573d6000803e3d6000fd5b50610190565b600082825260208201905092915050565b7f496e73756666696369656e74206465706c6f796d656e74206665650000000000600082015250565b600061015a601b83610113565b915061016582610124565b602082019050919050565b600060208201905081810360008301526101898161014d565b9050919050565b61016b8061019f6000396000f3fe608060405234801561001057600080fd5b50600436106100365760003560e01c80634690484014610038578063a8f3225114610059575b600080fd5b610043610074565b60405161004d91906100e6565b60405180910390f35b61006161009b565b60405161006b9190610113565b60405180910390f35b60008054906101000a900473ffffffffffffffffffffffffffffffffffffffff1681565b652d79883d200081565b600073ffffffffffffffffffffffffffffffffffffffff82169050919050565b60006100cc826100a5565b9050919050565b6100dc816100c5565b82525050565b60006020820190506100f760008301846100d7565b92915050565b6000819050919050565b61011081610101565b82525050565b600060208201905061012b6000830184610107565b9291505056fea2646970667358221220d08b6ffa72e04c90cdfb72b342dda2a82efd1b23a7f85f2c844f98cd8a915f3964736f6c634300081300337975000000000000042161480000000x7cd4e800c376eb6ec5cc4079aeacdf4cc648fbaacbd1c2861bc4f970ee1779ca[]3117676290x57d9f565ee542639e6d3ed2d9018cc581f36846e0true2025-03-03T09:27:50.000Z219654612218740x28a943f76c5e82dcc545e7e2188759485bb1b66b973ff54d04113fce43986c010280x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000529440x06f1a0a55568b060f6f11bbc4cd416ddb96dc2b728422457136437000
0xd931e0bab92051f8a67dd7475d966eb1ec9b7dd3018467bfc91b0e134bdf1b4f0x358856d06fe100b245d241a095ac258ee64a5e97e673b8e2cfe47104edde18cc1853120x4420e4860000000000000000000000008a2b6e437671c5814876ea4fbe68806b575b5d2a32334042161100000000x721efb8bd2d6fa41f7edaa541bc17a70005b875000d90fdb17148c244e86f0e60x0000000000000000000000000000000000000066[]3119611070x72c61b30584a6dd402b19ea942df3b0e7fe04d7d2true2025-03-03T22:55:35.000Z2196947920000000842600xf3cd1eefab3936752baabb36beb844c570f39ea08310558689f1350fb92deb352760x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000422076880924210000000
Query with partition filter
SELECT *
FROM `tt-blockchain.arbitrum.transactions`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100