Skip to content


The optimism.protocols table provides indexed views for all protocols we track in tables in the protocol_layer. This includes DEXs, NFT Markets, Bridges, and Aggregators.


Name Type Description
contract_address text Contract address associated with a protocol that we track (could be a Sushiswap dex pool, the Uniswap V3 factory address, etc.).
contract_type text The type of contract (e.g. factory, pool, registry, etc.).
contract_version text The version of the protocol (e.g. v1, v2, etc.), mirrors the version tracked in our tables.
protocol_name text The name of the protocol (e.g. uniswap, sushiswap, etc.)
tables text[] The tables that include the protocol (e.g. dex_swaps, dex_pools).
__block_number integer The last block number in the batch that the data was updated in.
__confirmed boolean Flag indicating whether the data point the rows is derived from has been confirmed.
__last_modified timestamp The date at which this row was last updated (in ISO-8601 format).


protocol_name, contract_version
__indexer_id WHERE __confirmed = false
__indexer_id, __block_number

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.