tornadocash_v1_optimism

Tables

ETH01_Withdrawal_event

Withdrawal events from Tornado Cash ETH 0.1 pool on Optimism, capturing privacy-preserving fund exits with recipient addresses, nullifier hashes, relayer details, and withdrawal fees. Used for analyzing Tornado Cash withdrawal patterns, relayer economics, and privacy protocol usage on L2.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_nullifierHash`	`STRING`	Nullifier hash used to prevent double-spending in Tornado Cash withdrawals. Hex-encoded, 0x-prefixed, 66-character string.
`in_relayer`	`STRING`	Address of the relayer executing the cross-chain transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_fee`	`STRING`	Fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency.

Sample Data

in_to	in_fee	address	removed	in_relayer	block_number	block_timestamp	in_nullifierHash	transaction_hash
0x619489245089649412478e5018a84068026f40c2	1055590442803600	0x84443cfd09a48af6ef360c6976c5392ac5023a1f	false	0xc7285e85a6d11c762a7d9c57ac38e31a671e9777	15019499	2022-07-19T16:00:06.000Z	0x070b406c2810c72b2295048eba0f9f068f880654ebff36a5274775d10d6a775e	0x0ea7d143a4b7b07a009d1a7e63453e8ea6ce57ef0276508db42fb42eb8aeb078
0x08ec3a4e3873505d34450b0f726136e1bf0c9df7	782150001482720	0x84443cfd09a48af6ef360c6976c5392ac5023a1f	false	0xc7285e85a6d11c762a7d9c57ac38e31a671e9777	15019704	2022-07-19T16:01:55.000Z	0x1639cbd12f5c2827d578f181c9189c84fe776558b0d0e2ba4bc12706db04553f	0xce300f6ccdbbd158e4badcce9ee9922b189eb948230a0910fc0d25e11b7b1ae5
0xc1d3d66e8bd2ad26388be24a1f547e9ce7cffd38	141289556888080	0x84443cfd09a48af6ef360c6976c5392ac5023a1f	false	0xc7285e85a6d11c762a7d9c57ac38e31a671e9777	16831162	2022-07-30T23:03:08.000Z	0x270e1bb76207638b232ae84e99d76e282a624a1590cf6436b8827e543120e513	0xa61598d4d9f120ab62ff8db59cf672e32228cf7f281972b1bc6282980f83f5e7

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.tornadocash_v1_optimism.ETH01_Withdrawal_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

ETH1_Withdrawal_event

Withdrawal events from Tornado Cash ETH privacy pool on Optimism, capturing recipient addresses, relayer fees, and nullifier hashes used to prevent double-spending. Enables analysis of fund exits from the mixer and relayer usage patterns.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_nullifierHash`	`STRING`	Nullifier hash used to prevent double-spending in Tornado Cash withdrawals. Hex-encoded, 0x-prefixed, 66-character string.
`in_relayer`	`STRING`	Address of the relayer executing the cross-chain transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_fee`	`STRING`	Fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency.

Sample Data

in_to	in_fee	address	removed	in_relayer	block_number	block_timestamp	in_nullifierHash	transaction_hash
0x6ad55a226ae5814d1a739b4f618b2909ec5dbcce	900440000000000	0xd47438c816c9e7f2e2888e060936a499af9582b3	false	0xa0f0287683e820ff4211e67c03cf46a87431f4e1	9211252	2022-05-28T16:17:57.000Z	0x027dc6f04ddacbcd8c104f4cfd282be46c25c73efd03b2ab0699295f53994526	0x357a4fbae7687ff7c1d4e171ed01c2b290385706878cd8c563eb27a1234d6181
0x5b65d5526119ddc0ba8b1caa20e9294aacbe59a1	1274540421062640	0xd47438c816c9e7f2e2888e060936a499af9582b3	false	0xc7285e85a6d11c762a7d9c57ac38e31a671e9777	15853601	2022-07-26T16:26:33.000Z	0x24f7180ec81fce7338471d2685848d51c5fe5a9ac05e99decb166bfb787f1d89	0xdbacbb84d517462d7cf0b0de51468263f1331ece4b1a85d304709f9a1460b2af
0x5b65d5526119ddc0ba8b1caa20e9294aacbe59a1	1274540421062640	0xd47438c816c9e7f2e2888e060936a499af9582b3	false	0xc7285e85a6d11c762a7d9c57ac38e31a671e9777	15853583	2022-07-26T16:26:18.000Z	0x1e5bbaf10e6e6d294f6bf44a3e988df52487c0a102887feb0ad29aa463a0ad20	0x2ff4ef598a34305e624e6a2d9fa9020b08b1c2bee679312ab3e9724434f8ce57

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.tornadocash_v1_optimism.ETH1_Withdrawal_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

ETH10_Withdrawal_event

Withdrawal events from Tornado Cash’s 10 ETH pool on Optimism, recording when users extract funds through the privacy mixer. Tracks recipient addresses, relayer information, nullifier hashes for preventing double-withdrawals, and fees paid for transaction execution.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_nullifierHash`	`STRING`	Nullifier hash used to prevent double-spending in Tornado Cash withdrawals. Hex-encoded, 0x-prefixed, 66-character string.
`in_relayer`	`STRING`	Address of the relayer executing the cross-chain transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_fee`	`STRING`	Fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency.

Sample Data

in_to	in_fee	address	removed	log_index	in_relayer	block_number	block_timestamp	in_nullifierHash	transaction_hash
0x557a356b7a5bc37fd5f459cb180df129c67ecde1	11020169139485920	0x330bdfade01ee9bf63c209ee33102dd334618e0a	false	0	0xa0f0287683e820ff4211e67c03cf46a87431f4e1	9916622	2022-06-01T09:04:53.000Z	0x1e18b5557db02ad250f5c97cb6d41556d8715a5a4cde7f62d062ce2a863866e6	0xbc090ae5388222274da7fb3fc4694879b33ee22d942d99452ac687d0c1ebd99a
0x1c0a055e864f853f23bafcfd17005367e95cb17a	20321716482750960	0x330bdfade01ee9bf63c209ee33102dd334618e0a	false	0	0x85972458dfbf9269567b2a27c4ffc958a4f24761	12170996	2022-06-17T21:25:17.000Z	0x1adff23639c2719f1289f88fa6b2692f7e792829370a05d180c2bc82a34e97ff	0x4e6b0553e5077f26df37e3e018456f79c1040533c12cce1821e8d8d5d530d221

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.tornadocash_v1_optimism.ETH10_Withdrawal_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

ETH100_Withdrawal_event

No description available.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_nullifierHash`	`STRING`	Nullifier hash used to prevent double-spending in Tornado Cash withdrawals. Hex-encoded, 0x-prefixed, 66-character string.
`in_relayer`	`STRING`	Address of the relayer executing the cross-chain transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_fee`	`STRING`	Fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency.

Sample Data

No sample data available.

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.tornadocash_v1_optimism.ETH100_Withdrawal_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Metrics

Primitives

Contracts

Blockchain

Tables

ETH01_Withdrawal_event

ETH1_Withdrawal_event

ETH10_Withdrawal_event

ETH100_Withdrawal_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​ETH01_Withdrawal_event

​ETH1_Withdrawal_event

​ETH10_Withdrawal_event

​ETH100_Withdrawal_event

Tables

ETH01_Withdrawal_event

ETH1_Withdrawal_event

ETH10_Withdrawal_event

ETH100_Withdrawal_event