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.
||Contract address associated with a protocol that we track (could be a Sushiswap dex pool, the Uniswap V3 factory address, etc.).|
||The type of contract (e.g. factory, pool, registry, etc.).|
||The version of the protocol (e.g. v1, v2, etc.), mirrors the version tracked in our tables.|
||The name of the protocol (e.g. uniswap, sushiswap, etc.)|
||The tables that include the protocol (e.g.
||The last block number in the batch that the data was updated in.|
||Flag indicating whether the data point the rows is derived from has been confirmed.|
||The date at which this row was last updated (in ISO-8601 format).|
|__indexer_id WHERE __confirmed = false|
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.