Tornado Cash Withdrawals

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

Columns

Name	Type	Description
block_number	integer	The block number of the event.
contract_address	text	The mixer pool address.
fork_number	integer	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.
log_index	integer	The log index of the event.
mixer_name	text	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.
origin_address	text	The address that sent the withdrawal transaction.
quantity	numeric	The raw amount of tokens withdrawn.
timestamp	timestamp without time zone	The timestamp of the event (in ISO-8601 format).
to_address	text	The address that withdrew the tokens.
token_address	text	The token address of the mixer pool.
transaction_hash	text	The transaction hash of the event.
__block_number	integer	An internal identifier for the indexer that updates this row. Use block_number instead when querying.
__confirmed	boolean	Flag indicating whether the transfer has been confirmed.
__last_modified	timestamp	The date at which this row was last updated (in ISO-8601 format).

Indexes

Index
token_address, timestamp, log_index
to_address, block_number, log_index
timestamp, log_index
contract_address, block_number, log_index
__last_modified
__indexer_id WHERE __confirmed = false
transaction_hash, log_index
to_address, timestamp, log_index
contract_address, timestamp, log_index
__indexer_id, __block_number
block_number, 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.