Tornado Cash Deposits

The tornado_cash_deposits table provides indexed views of all deposits from any Tornado Cash mixer pools on a specific chain, including any forks of Tornado Cash.

Columns

Name	Description	Type
block_number	The block number at which the deposit transaction occurred.	integer
log_index	The log index at which the deposit event occurred.	integer
transaction_hash	The transaction hash at which the deposit event occurred.	text
timestamp	The timestamp of the deposit event (in ISO-8601 format).	timestamp
mixer_name	The name of the pool, the symbol of the pool token, and the allowed size of the deposit token. Includes whether the pool is an actual Tornado Cash pool, or a Tornado Cash fork.	text
fork_number	If the pool was not deployed by Tornado Cash Devs or other labelled fork deployers, then this indicates a Tornado Cash fork deployed by a unique dev, incrementing upwards when a new deployer address is seen.	integer
contract_address	The contract address of the Tornado Pool.	text
token_address	The token address deposited to the Tornado Pool. If none, the token is native ETH.	text
quanity	The raw amount of the token deposited.	numeric
from_address	The address that deposited the token amount.	text
origin_address	The address that initiated the deposit transaction (the from address in the transaction).	text
__confirmed	Flag indicating whether the transfer has been confirmed.	boolean

Indexes

The following indexes are available for this table:

(timestamp, log_index)
(contract_address, block_number, log_index)
(contract_address, timestamp, log_index)
(from_address, block_number, log_index)
(from_address, timestamp, log_index)
(token_address, timestamp, log_index)
(transaction_hash, log_index)

Got questions? Join our Discord

Discord is the primary home of the Transpose developer community. Join us to ask questions, share your work, and get help.