Methodology :

1.off-chain investigation :

To find Swap Pairs, I first went to Sushiswap Contracts on Optimism :

ConstantProductPoolFactory : 0x93395129bd3fcf49d95730D3C2737c17990fF328 which manage to create pairs pools contracts

TridentRouter : 0xbE811A0D44E2553d25d11CB8DC0d3F0D0E6430E6 which manage swap transactions

But none of them have information or events or signatures about created pairs. To create a Swap Pair, a Multicall interaction is performed with the TridentRouter contract, which doesn’t contains an EVENT that can be distinguished from other transactions, also is recorded in the Flipside database in the same way. so I went to the api data at

Analytics.sushi.com has an api for Swap Pairs on Arbitrum: here , also for polygon here but there is nothing for Optimism, then I went to Sushi.com to see how it gets information about swap pairs and pools.

Suhiswap receives information about pools and swap pairs in Optimism from a subgraph at api.thegraph.com/subgraphs/name/olastenberg/trident-optimism/graphql

Through this api you can get information about pools, User Liqudities. In this way, I was able to obtain direct SwapPairs.

so first i export liquidityPositions with this query from the api :

query MyQuery {liquidityPositions { pool { id assets { token { name symbol id decimals } } } } }

which put out user created pools with pool-address, pair-address and symbol and decimals in Json format.

then export same date from pools table from the api graph and combine both and remove the duplicate pools by pool-address.

then convert the result Json to CSV table and finally result can be access :

1. here :

   and

2. here :

Tables Contains

i added the table end of current Dashboard.

2.on-chain investigation :

Considering that the Optimism table was recently added to Flipside, it is not possible to find information about past transactions and information about Sushi contracts.

However, data can be obtained from the TridentRouter contract using the optimism.core.fact_event_logs table.

below table contains swaps between 2 tokens via Sushiswap, obtained through this table.

Sushiswap Swap Pairs on Optimism Tabel