> ## Documentation Index
> Fetch the complete documentation index at: https://tokenterminal.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.
# scroll
> Tables in tt-blockchain.scroll
## 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.
| 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` | List of uncle block hashes included in the block. Empty array for chains not supporting uncle blocks in their consensus mechanism. |
| 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 |
| ---- | ------------------------------------------ | ------------------ | ------- | ------ | --------- | ------------------------------------------------------------------ | ---------- | ------------------------ | ------------------------------------------------------------------ | ---------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------------------------------------------------------------ | ------------------------------------------------------------------ | ------------------------------------------------------------------ | ------------------------------------------------------------------ | ------------------- | ----------------- | ------------------ | ------------------------------------------------------------------ |
| 1340 | 0x0000000000000000000000000000000000000000 | 0x0000000000000000 | 3401406 | \[] | 168195 | 0x0000000000000000000000000000000000000000000000000000000000000000 | 10000000 | 2024-02-17T00:08:14.000Z | 0x041146dfd5b9161786edb94c34251dd31920d9f88d38c72a163fc512ff128a08 | 2 | 0xd88305010a846765746888676f312e31392e31856c696e7578000000000000009dc7bfe58a21a478a4d986c5a80a7672250a1f7d3758a2bf18300f16713be46f37712a3119aa10e2c2bb6f2ac01da7f00bff54d1725230be6d30ca272ba7b22101 | 0x00200000000000000000000000000400000000000000000000000000000000000a00000000000000000000000000000000000000000000800000000000000000000000000000000000000008000002200000000000000800000000000000000000000000000400000000000000000000000000042000000000000010000000000000000000000000000000000000000000001040000000400000004000000000000000000000000000000000000000000000000000000000000000000000000800008002000000000000000400000000000000000000000000000000000000000000000000000000000000000000000000000000000080000000000088000000 | 0x180771aedd2b74bc42b334aaaef14d217d6d30f133ce32dac29cadfcb3136728 | 0xadcae115890c665b6d577625825fd1cb626220dc124ce1e90afb730b302e25c8 | 0x1dcc4de8dec75d7aab85b567b6ccd41ad312451b948a7413f0a142fd40d49347 | 0x1425acbda7f7f40d02558260586d579cdecc321c084c0295a50825a87d7ea1f4 | | 6802813 | 1 | 0xa8fc26a38078b4b1d65f6512ea8286b304867eb7186271f5b606d225c16992ee |
| 785 | 0x0000000000000000000000000000000000000000 | 0x0000000000000000 | 3401336 | \[] | 59830 | 0x0000000000000000000000000000000000000000000000000000000000000000 | 10000000 | 2024-02-17T00:04:22.000Z | 0x2655c101f830396ba0f3200a7286a9174b5932680933de622c1a03f5ef39ce2d | 2 | 0xd88305010a846765746888676f312e31392e31856c696e757800000000000000cc894ae65081db4f03345680bca82afa90643390d9678185440ab9c987b4920824f35edd27c855fe5af31e08214355a74cd074f2a453105886ed27d597dea16400 | 0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000200000000000000000000000000000000000000000000000000000000000040001000000000000000000000000000000000000000000000000000001000000000000000000000000000008000000000000000000000040080000000000000000000000020000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000080000000000008000000 | 0x08a227b12e4d4497961f1ed663b0228429540ca001e2c61de5bfdf329c033db6 | 0xe2ff24b73b64c15c21b31aac8def8ebd97ed1d0fc63bff1e25d42a4c1899db16 | 0x1dcc4de8dec75d7aab85b567b6ccd41ad312451b948a7413f0a142fd40d49347 | 0xf07c4fa1ec1c2100293dff3b88296defd6e6096f0f7ce5af9fe374519bd7508e | | 6802673 | 1 | 0xe70aaf7cb7453c86f81361af04efb5a8de7f4a61d55df0b645962a4f2ec72258 |
| 785 | 0x0000000000000000000000000000000000000000 | 0x0000000000000000 | 3401943 | \[] | 48926 | 0x0000000000000000000000000000000000000000000000000000000000000000 | 10000000 | 2024-02-17T00:35:14.000Z | 0x1ea7f81f0b1a975bdfc6c1a49f91683adf14961adb55814455e0a35d9d64f865 | 2 | 0xd88305010a846765746888676f312e31392e31856c696e757800000000000000754f0020c5aacf5484fb9b281fa510f7b09283ab0b1d531e0633f88a76437f9200aebe2e93336956d5c8424f30d17aa623906c44cfd2f3864e2e9f7cd3ee537a00 | 0x08000000000000000000000000000000000000000000000000000000000000000000000120000000000000000000000000000000000000000000000000200000000080000040000000000000000000000800000000000000000000040001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000080000000000000000000000020000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000 | 0x1f897dd79ca6223e6cc4cee2f93b8c1809a1fef2fe8152a0ee1d3d9ff89a1f28 | 0x0a2532abb023418e583db2cb6f090829e03390cb7bba7d6ab22db1be4156d39c | 0x1dcc4de8dec75d7aab85b567b6ccd41ad312451b948a7413f0a142fd40d49347 | 0xa4c184c0e354cd3f14c753f79349f687aac0c609581e752e60cd62280e06516f | | 6803887 | 1 | 0x3030f56eba3053bce5dede2464a17274f7bf992bcf93818411cf197c5dfbe47d |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-blockchain.scroll.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.
| 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` | 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. |
| data | topics | address | removed | log\_index | block\_hash | block\_number | block\_timestamp | transaction\_hash | transaction\_index |
| ------------------------------------------------------------------ | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------------------------------------ | ------- | ---------- | ------------------------------------------------------------------ | ------------- | ------------------------ | ------------------------------------------------------------------ | ------------------ |
| 0x00000000000000000000000000000000000000000000000000000000140f8a0b | \["0x8c5be1e5ebec7d5bd14f71427d1e84f3dd0314c0f7b2291e5b200ac8c7c3b925","0x000000000000000000000000bfad5bc0372cafb0b2a4ab0ec4cb0db4ecc1f676","0x00000000000000000000000080e38291e06339d10aab483c65695d004dbd5c69"] | 0xf55bec9cafdbe8730f096aa55dad6d22d44099df | false | 0 | 0x80a4623d99215c7502a8b10883b029b245f80f1d4c7e9307a6c86ed87205f63e | 5045018 | 2024-04-23T00:00:01.000Z | 0x7be4e81f5517ba79772e42ae0aa6c0c649a3cc8df005669ace5585b4cf1521e1 | 0 |
| 0x000000000000000000000000000000000000000000000000000000000e153281 | \["0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef","0x000000000000000000000000f1783f3377b3a70465c193ef33942c0803121ba0","0x000000000000000000000000fc30937f5cde93df8d48acaf7e6f5d8d8a31f636"] | 0x06efdbff2a14a7c8e15944d1f4a48f9f95f663a4 | false | 5 | 0x94a427e9eda89d9be6b0d296201c3c7eb54aaa6624d9cc1c5bb43954e2081156 | 5045019 | 2024-04-23T00:00:04.000Z | 0x8e01174962b6ac73d57c7bcc5ac3b64c8da3563adee350fd1f349cdefb7369a6 | 5 |
| 0x000000000000000000000000000000000000000000000000000000000e153281 | \["0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef","0x000000000000000000000000fc30937f5cde93df8d48acaf7e6f5d8d8a31f636","0x000000000000000000000000813df550a32d4a9d42010d057386429ad2328ed9"] | 0x06efdbff2a14a7c8e15944d1f4a48f9f95f663a4 | false | 9 | 0x94a427e9eda89d9be6b0d296201c3c7eb54aaa6624d9cc1c5bb43954e2081156 | 5045019 | 2024-04-23T00:00:04.000Z | 0x8e01174962b6ac73d57c7bcc5ac3b64c8da3563adee350fd1f349cdefb7369a6 | 5 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-blockchain.scroll.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.
| 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. |
| `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. |
| gas | error | input | value | output | status | gas\_used | trace\_id | to\_address | trace\_type | block\_number | from\_address | trace\_address | block\_timestamp | transaction\_hash | transaction\_index |
| ------ | ---------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ----- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------ | --------- | -------------------------------------------------------------------------------------- | ------------------------------------------ | ------------ | ------------- | ------------------------------------------ | -------------- | ------------------------ | ------------------------------------------------------------------ | ------------------ |
| 135952 | out of gas | 0xb63e800d0000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000140000000000000000000000000f48f2b2d2a534e402487b3ee7c18c33aec0fe5e40000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001000000000000000000000000ee12c640b0793cf514e42ea1c428bd5399545d4d0000000000000000000000000000000000000000000000000000000000000000 | | | false | 135952 | DELEGATECALL\_0x5cbc83b13c5481a5bd5499d04fc713e04c2ea98310916f25e9ab2e7c3011b714\_1\_0 | 0x3e5c63644e683549055b9be8653de26e0b4cd36e | DELEGATECALL | 1300 | 0x05bbea669e7672ea73c86ebc4bfbdfd6615ed2ec | 1,0 | 2023-10-10T18:13:49.000Z | 0x5cbc83b13c5481a5bd5499d04fc713e04c2ea98310916f25e9ab2e7c3011b714 | 0 |
| 135952 | out of gas | 0xb63e800d0000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000140000000000000000000000000f48f2b2d2a534e402487b3ee7c18c33aec0fe5e40000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001000000000000000000000000ee12c640b0793cf514e42ea1c428bd5399545d4d0000000000000000000000000000000000000000000000000000000000000000 | | | false | 135952 | DELEGATECALL\_0x792022f98cda23b4d3ed918a9c2d9b9a7157feadb0f30ddcd86f3782e2d93a8e\_1\_0 | 0x3e5c63644e683549055b9be8653de26e0b4cd36e | DELEGATECALL | 1302 | 0x05bbea669e7672ea73c86ebc4bfbdfd6615ed2ec | 1,0 | 2023-10-10T18:14:59.000Z | 0x792022f98cda23b4d3ed918a9c2d9b9a7157feadb0f30ddcd86f3782e2d93a8e | 1 |
| 889376 | | 0x608060405234801561001057600080fd5b50610ee0806100206000396000f3fe6080604052600436106100f35760003560e01c80634d2301cc1161008a578063a8b0574e11610059578063a8b0574e1461025a578063bce38bd714610275578063c3077fa914610288578063ee82ac5e1461029b57600080fd5b80634d2301cc146101ec57806372425d9d1461022157806382ad56cb1461023457806386d516e81461024757600080fd5b80633408e470116100c65780633408e47014610191578063399542e9146101a45780633e64a696146101c657806342cbb15c146101d957600080fd5b80630f28c97d146100f8578063174dea711461011a578063252dba421461013a57806327e86d6e1461015b575b600080fd5b34801561010457600080fd5b50425b6040519081526020015b60405180910390f35b61012d610128366004610a85565b6102ba565b6040516101119190610bbe565b61014d610148366004610a85565b6104ef565b604051610111929190610bd8565b34801561016757600080fd5b50437fffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff0140610107565b34801561019d57600080fd5b5046610107565b6101b76101b2366004610c60565b610690565b60405161011193929190610cba565b3480156101d257600080fd5b5048610107565b3480156101e557600080fd5b5043610107565b3480156101f857600080fd5b50610107610207366004610ce2565b73ffffffffffffffffffffffffffffffffffffffff163190565b34801561022d57600080fd5b5044610107565b61012d610242366004610a85565b6106ab565b34801561025357600080fd5b5045610107565b34801561026657600080fd5b50604051418152602001610111565b61012d610283366004610c60565b61085a565b6101b7610296366004610a85565b610a1a565b3480156102a757600080fd5b506101076102b6366004610d18565b4090565b60606000828067ffffffffffffffff8111156102d8576102d8610d31565b60405190808252806020026020018201604052801561031e57816020015b6040805180820190915260008152606060208201528152602001906001900390816102f65790505b5092503660005b8281101561047757600085828151811061034157610341610d60565b6020026020010151905087878381811061035d5761035d610d60565b905060200281019061036f9190610d8f565b6040810135958601959093506103886020850185610ce2565b73ffffffffffffffffffffffffffffffffffffffff16816103ac6060870187610dcd565b6040516103ba929190610e32565b60006040518083038185875af1925050503d80600081146103f7576040519150601f19603f3d011682016040523d82523d6000602084013e6103fc565b606091505b50602080850191909152901515808452908501351761046d577f08c379a000000000000000000000000000000000000000000000000000000000600052602060045260176024527f4d756c746963616c6c333a2063616c6c206661696c656400000000000000000060445260846000fd5b5050600101610325565b508234146104e6576040517f08c379a000000000000000000000000000000000000000000000000000000000815260206004820152601a60248201527f4d756c746963616c6c333a2076616c7565206d69736d6174636800000000000060448201526064015b60405180910390fd5b50505092915050565b436060828067ffffffffffffffff81111561050c5761050c610d31565b60405190808252806020026020018201604052801561053f57816020015b606081526020019060019003908161052a5790505b5091503660005b8281101561068657600087878381811061056257610562610d60565b90506020028101906105749190610e42565b92506105836020840184610ce2565b73ffffffffffffffffffffffffffffffffffffffff166105a66020850185610dcd565b6040516105b4929190610e32565b6000604051808303816000865af19150503d80600081146105f1576040519150601f19603f3d011682016040523d82523d6000602084013e6105f6565b606091505b5086848151811061060957610609610d60565b602090810291909101015290508061067d576040517f08c379a000000000000000000000000000000000000000000000000000000000815260206004820152601760248201527f4d756c746963616c6c333a2063616c6c206661696c656400000000000000000060448201526064016104dd565b50600101610546565b5050509250929050565b43804060606106a086868661085a565b905093509350939050565b6060818067ffffffffffffffff8111156106c7576106c7610d31565b60405190808252806020026020018201604052801561070d57816020015b6040805180820190915260008152606060208201528152602001906001900390816106e55790505b5091503660005b828110156104e657600084828151811061073057610730610d60565b6020026020010151905086868381811061074c5761074c610d60565b905060200281019061075e9190610e76565b925061076d6020840184610ce2565b73ffffffffffffffffffffffffffffffffffffffff166107906040850185610dcd565b60405161079e929190610e32565b6000604051808303816000865af19150503d80600081146107db576040519150601f19603f3d011682016040523d82523d6000602084013e6107e0565b606091505b506020808401919091529015158083529084013517610851577f08c379a000000000000000000000000000000000000000000000000000000000600052602060045260176024527f4d756c746963616c6c333a2063616c6c206661696c656400000000000000000060445260646000fd5b50600101610714565b6060818067ffffffffffffffff81111561087657610876610d31565b6040519080825280602002602001820160405280156108bc57816020015b6040805180820190915260008152606060208201528152602001906001900390816108945790505b5091503660005b82811015610a105760008482815181106108df576108df610d60565b602002602001015190508686838181106108fb576108fb610d60565b905060200281019061090d9190610e42565b925061091c6020840184610ce2565b73ffffffffffffffffffffffffffffffffffffffff1661093f6020850185610dcd565b60405161094d929190610e32565b6000604051808303816000865af19150503d806000811461098a576040519150601f19603f3d011682016040523d82523d6000602084013e61098f565b606091505b506020830152151581528715610a07578051610a07576040517f08c379a000000000000000000000000000000000000000000000000000000000815260206004820152601760248201527f4d756c746963616c6c333a2063616c6c206661696c656400000000000000000060448201526064016104dd565b506001016108c3565b5050509392505050565b6000806060610a2b60018686610690565b919790965090945092505050565b60008083601f840112610a4b57600080fd5b50813567ffffffffffffffff811115610a6357600080fd5b6020830191508360208260051b8501011115610a7e57600080fd5b9250929050565b60008060208385031215610a9857600080fd5b823567ffffffffffffffff811115610aaf57600080fd5b610abb85828601610a39565b90969095509350505050565b6000815180845260005b81811015610aed57602081850181015186830182015201610ad1565b81811115610aff576000602083870101525b50601f017fffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffe0169290920160200192915050565b600082825180855260208086019550808260051b84010181860160005b84811015610bb1578583037fffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffe001895281518051151584528401516040858501819052610b9d81860183610ac7565b9a86019a9450505090830190600101610b4f565b5090979650505050505050565b602081526000610bd16020830184610b32565b9392505050565b600060408201848352602060408185015281855180845260608601915060608160051b870101935082870160005b82811015610c52577fffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffa0888703018452610c40868351610ac7565b95509284019290840190600101610c06565b509398975050505050505050565b600080600060408486031215610c7557600080fd5b83358015158114610c8557600080fd5b9250602084013567ffffffffffffffff811115610ca157600080fd5b610cad86828701610a39565b9497909650939450505050565b838152826020820152606060408201526000610cd96060830184610b32565b95945050505050565b600060208284031215610cf457600080fd5b813573ffffffffffffffffffffffffffffffffffffffff81168114610bd157600080fd5b600060208284031215610d2a57600080fd5b5035919050565b7f4e487b7100000000000000000000000000000000000000000000000000000000600052604160045260246000fd5b7f4e487b7100000000000000000000000000000000000000000000000000000000600052603260045260246000fd5b600082357fffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff81833603018112610dc357600080fd5b9190910192915050565b60008083357fffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffe1843603018112610e0257600080fd5b83018035915067ffffffffffffffff821115610e1d57600080fd5b602001915036819003821315610a7e57600080fd5b8183823760009101908152919050565b600082357fffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffc1833603018112610dc357600080fd5b600082357fffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffa1833603018112610dc357600080fdfea2646970667358221220bb2b5c71a328032f97c676ae39a1ec2148d3e5d6f73d95e9b17910152d61f16264736f6c634300080c0033 | 0 | 0x6080604052600436106100f35760003560e01c80634d2301cc1161008a578063a8b0574e11610059578063a8b0574e1461025a578063bce38bd714610275578063c3077fa914610288578063ee82ac5e1461029b57600080fd5b80634d2301cc146101ec57806372425d9d1461022157806382ad56cb1461023457806386d516e81461024757600080fd5b80633408e470116100c65780633408e47014610191578063399542e9146101a45780633e64a696146101c657806342cbb15c146101d957600080fd5b80630f28c97d146100f8578063174dea711461011a578063252dba421461013a57806327e86d6e1461015b575b600080fd5b34801561010457600080fd5b50425b6040519081526020015b60405180910390f35b61012d610128366004610a85565b6102ba565b6040516101119190610bbe565b61014d610148366004610a85565b6104ef565b604051610111929190610bd8565b34801561016757600080fd5b50437fffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff0140610107565b34801561019d57600080fd5b5046610107565b6101b76101b2366004610c60565b610690565b60405161011193929190610cba565b3480156101d257600080fd5b5048610107565b3480156101e557600080fd5b5043610107565b3480156101f857600080fd5b50610107610207366004610ce2565b73ffffffffffffffffffffffffffffffffffffffff163190565b34801561022d57600080fd5b5044610107565b61012d610242366004610a85565b6106ab565b34801561025357600080fd5b5045610107565b34801561026657600080fd5b50604051418152602001610111565b61012d610283366004610c60565b61085a565b6101b7610296366004610a85565b610a1a565b3480156102a757600080fd5b506101076102b6366004610d18565b4090565b60606000828067ffffffffffffffff8111156102d8576102d8610d31565b60405190808252806020026020018201604052801561031e57816020015b6040805180820190915260008152606060208201528152602001906001900390816102f65790505b5092503660005b8281101561047757600085828151811061034157610341610d60565b6020026020010151905087878381811061035d5761035d610d60565b905060200281019061036f9190610d8f565b6040810135958601959093506103886020850185610ce2565b73ffffffffffffffffffffffffffffffffffffffff16816103ac6060870187610dcd565b6040516103ba929190610e32565b60006040518083038185875af1925050503d80600081146103f7576040519150601f19603f3d011682016040523d82523d6000602084013e6103fc565b606091505b50602080850191909152901515808452908501351761046d577f08c379a000000000000000000000000000000000000000000000000000000000600052602060045260176024527f4d756c746963616c6c333a2063616c6c206661696c656400000000000000000060445260846000fd5b5050600101610325565b508234146104e6576040517f08c379a000000000000000000000000000000000000000000000000000000000815260206004820152601a60248201527f4d756c746963616c6c333a2076616c7565206d69736d6174636800000000000060448201526064015b60405180910390fd5b50505092915050565b436060828067ffffffffffffffff81111561050c5761050c610d31565b60405190808252806020026020018201604052801561053f57816020015b606081526020019060019003908161052a5790505b5091503660005b8281101561068657600087878381811061056257610562610d60565b90506020028101906105749190610e42565b92506105836020840184610ce2565b73ffffffffffffffffffffffffffffffffffffffff166105a66020850185610dcd565b6040516105b4929190610e32565b6000604051808303816000865af19150503d80600081146105f1576040519150601f19603f3d011682016040523d82523d6000602084013e6105f6565b606091505b5086848151811061060957610609610d60565b602090810291909101015290508061067d576040517f08c379a000000000000000000000000000000000000000000000000000000000815260206004820152601760248201527f4d756c746963616c6c333a2063616c6c206661696c656400000000000000000060448201526064016104dd565b50600101610546565b5050509250929050565b43804060606106a086868661085a565b905093509350939050565b6060818067ffffffffffffffff8111156106c7576106c7610d31565b60405190808252806020026020018201604052801561070d57816020015b6040805180820190915260008152606060208201528152602001906001900390816106e55790505b5091503660005b828110156104e657600084828151811061073057610730610d60565b6020026020010151905086868381811061074c5761074c610d60565b905060200281019061075e9190610e76565b925061076d6020840184610ce2565b73ffffffffffffffffffffffffffffffffffffffff166107906040850185610dcd565b60405161079e929190610e32565b6000604051808303816000865af19150503d80600081146107db576040519150601f19603f3d011682016040523d82523d6000602084013e6107e0565b606091505b506020808401919091529015158083529084013517610851577f08c379a000000000000000000000000000000000000000000000000000000000600052602060045260176024527f4d756c746963616c6c333a2063616c6c206661696c656400000000000000000060445260646000fd5b50600101610714565b6060818067ffffffffffffffff81111561087657610876610d31565b6040519080825280602002602001820160405280156108bc57816020015b6040805180820190915260008152606060208201528152602001906001900390816108945790505b5091503660005b82811015610a105760008482815181106108df576108df610d60565b602002602001015190508686838181106108fb576108fb610d60565b905060200281019061090d9190610e42565b925061091c6020840184610ce2565b73ffffffffffffffffffffffffffffffffffffffff1661093f6020850185610dcd565b60405161094d929190610e32565b6000604051808303816000865af19150503d806000811461098a576040519150601f19603f3d011682016040523d82523d6000602084013e61098f565b606091505b506020830152151581528715610a07578051610a07576040517f08c379a000000000000000000000000000000000000000000000000000000000815260206004820152601760248201527f4d756c746963616c6c333a2063616c6c206661696c656400000000000000000060448201526064016104dd565b506001016108c3565b5050509392505050565b6000806060610a2b60018686610690565b919790965090945092505050565b60008083601f840112610a4b57600080fd5b50813567ffffffffffffffff811115610a6357600080fd5b6020830191508360208260051b8501011115610a7e57600080fd5b9250929050565b60008060208385031215610a9857600080fd5b823567ffffffffffffffff811115610aaf57600080fd5b610abb85828601610a39565b90969095509350505050565b6000815180845260005b81811015610aed57602081850181015186830182015201610ad1565b81811115610aff576000602083870101525b50601f017fffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffe0169290920160200192915050565b600082825180855260208086019550808260051b84010181860160005b84811015610bb1578583037fffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffe001895281518051151584528401516040858501819052610b9d81860183610ac7565b9a86019a9450505090830190600101610b4f565b5090979650505050505050565b602081526000610bd16020830184610b32565b9392505050565b600060408201848352602060408185015281855180845260608601915060608160051b870101935082870160005b82811015610c52577fffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffa0888703018452610c40868351610ac7565b95509284019290840190600101610c06565b509398975050505050505050565b600080600060408486031215610c7557600080fd5b83358015158114610c8557600080fd5b9250602084013567ffffffffffffffff811115610ca157600080fd5b610cad86828701610a39565b9497909650939450505050565b838152826020820152606060408201526000610cd96060830184610b32565b95945050505050565b600060208284031215610cf457600080fd5b813573ffffffffffffffffffffffffffffffffffffffff81168114610bd157600080fd5b600060208284031215610d2a57600080fd5b5035919050565b7f4e487b7100000000000000000000000000000000000000000000000000000000600052604160045260246000fd5b7f4e487b7100000000000000000000000000000000000000000000000000000000600052603260045260246000fd5b600082357fffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff81833603018112610dc357600080fd5b9190910192915050565b60008083357fffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffe1843603018112610e0257600080fd5b83018035915067ffffffffffffffff821115610e1d57600080fd5b602001915036819003821315610a7e57600080fd5b8183823760009101908152919050565b600082357fffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffc1833603018112610dc357600080fd5b600082357fffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffa1833603018112610dc357600080fdfea2646970667358221220bb2b5c71a328032f97c676ae39a1ec2148d3e5d6f73d95e9b17910152d61f16264736f6c634300080c0033 | true | 762392 | CREATE\_0x07471adfe8f4ec553c1199f495be97fc8be8e0626ae307281c22534460184ed1\_ | 0xca11bde05977b3631167028862be2a173976ca11 | CREATE | 14 | 0x05f32b3cc3888453ff71b01135b34ff8e41263f2 | | 2023-10-10T06:12:56.000Z | 0x07471adfe8f4ec553c1199f495be97fc8be8e0626ae307281c22534460184ed1 | 0 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-blockchain.scroll.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.
| 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. |
| `sender` | `STRING` | Address that initiated the transaction. Hex-encoded, 0x-prefixed, 42-character string for EVM chains; base58-encoded or base32-encoded for non-EVM chains. |
| `queue_index` | `INT64` | Layer 2 sequencer queue position for transactions submitted to Scroll's rollup batch. Null for most transactions as this field is specific to Scroll's batching mechanism. |
| `access_list` | `ARRAY>>` | 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_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_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. |
| r | s | v | gas | input | nonce | value | sender | chain\_id | gas\_price | block\_hash | to\_address | access\_list | queue\_index | 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 | max\_priority\_fee\_per\_gas | receipt\_contract\_address | receipt\_transaction\_index | receipt\_cumulative\_gas\_used | receipt\_effective\_gas\_price |
| ------------------------------------------------------------------ | ------------------------------------------------------------------ | ------- | ----- | ----- | ----- | ------------------- | ------ | --------- | ---------- | ------------------------------------------------------------------ | ------------------------------------------ | ---------------------------------------- | ------------ | ------------- | ------------------------------------------ | ------------- | ---------------- | --------------- | ------------------------ | ------------------ | ------------------ | ------------------------------------------------------------------ | ----------------- | ------------------ | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ---------------------------- | -------------------------- | --------------------------- | ------------------------------ | ------------------------------ |
| 0x5b97fe3f8afa711ec298cd16625b074cf4a125399deddef705e1b84649da38b5 | 0x18d99bcb42cf0b3cc0cf8b52bc7b27c559bfc9ca2e0c9ebf6194fc79287a8c4e | 1068740 | 21000 | 0x | 55 | 0 | | | 1178100000 | 0xf29530047a481db7535d6a9c3dd9c7249020f34a4859720e21b0e8d11241530b | 0x2e6f043ecb78b2e0a992359789064594a2557418 | \[\{"address":null,"storage\_keys":\[]}] | | 4850672 | 0x2e6f043ecb78b2e0a992359789064594a2557418 | 0 | 129952548198285 | true | 2024-04-15T15:21:53.000Z | | 21000 | 0x2ac086a9db0f96d0e4ef45f7465a19a9844bd64d244ef3a7aed0374af3ada3eb | 0 | 0 | 0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 | | | 0 | 21000 | 1178100000 |
| 0x7cc1f3199e3668deeae9f7eb5ba29f82c2df84184af8e46915fa8734d5f441b1 | 0x3914b911c4c6a830aff1f31266b4a8fc037402212236b05d49378768a0747948 | 1068740 | 21000 | 0x | 25 | 1000000000000000000 | | | 854700000 | 0x819df08c45526194bd87a12889c87a4aae35d6e1e16110289a16558c3a3f81b4 | 0x2fc617e933a52713247ce25730f6695920b3befe | \[\{"address":null,"storage\_keys":\[]}] | | 4845121 | 0x32bde5a71f933801d6f83f0b6830fc943aaf31c8 | 0 | 51758864757653 | true | 2024-04-15T07:31:09.000Z | | 21000 | 0x35cc0747efa34a649f49e3d4b1a7cbb8470b9a6a53a4724fe0719eca6dd30372 | 0 | 0 | 0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 | | | 0 | 21000 | 854700000 |
| 0xc0911e4f1788a1054140b02eba1c22478b31368132f41f8c0e2a1f387ec40cfe | 0x16def602f627da1a183e5ff956cd25bf35e1895d0ff275c95eb72f870967d730 | 1068740 | 21000 | 0x | 5869 | 59436000000000000 | | | 962000000 | 0x9ce6230590438b93985dacad8d5f6a7368890987179a774274b006f4c9497a93 | 0x12ec94c31e08e924f0f09bba14b25b3512a2976e | \[\{"address":null,"storage\_keys":\[]}] | | 4851989 | 0x009905bf008cca637185eeafe8f51bb56dd2aca7 | 0 | 95845871105600 | true | 2024-04-15T16:29:39.000Z | | 21000 | 0x575a57bacd92d32d4b605cf0b643bcc7e1c2e7620ddb18224c2e2f76c7f99984 | 0 | 0 | 0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 | | | 0 | 21000 | 962000000 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-blockchain.scroll.transactions`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***