Optimism DEXs (redux)

-
Optimism is a fast, stable, and scalable L2 blockchain built by Ethereum developers, for Ethereum developers. Built as a minimal extension to existing Ethereum software, Optimism's EVM-equivalent architecture scales your Ethereum apps without surprises.
\
-
The velodrome is an AMM designed as the central trading and liquidity marketplace on Optimism Network. It is the next evolution of the solidly Exchange model introduced by Andrew Cronje.
\
-
SushiSwap is a decentralized exchange (DEX) in which users can exchange between different virtual currencies using a connected cryptocurrency wallet, such as MetaMask. The exchange allows swapping between 11,700 currency pairs.
\
-
0x is a decentralized cryptocurrency exchange protocol for trading Ethereum tokens. ... 0x is a peer-to-peer exchange of Ethereum-based tokens.
\

from optimism.core.fact_event_logs
from optimism.core.fact_token_transfers
from optimism.core.dim_contracts
from optimism.core.fact_hourly_token_prices
from optimism.sushi.ez_swaps
where day >= CURRENT_DATE - 30
count(DISTINCT tx_hash) as swaps,
count(DISTINCT wallet) as users,
sum(amount_from) as volume_usd,
sum(swaps) over (order by day asc) as cumulative_swaps,
sum(volume_usd) over (order by day asc) as cumulative_volume
where platforms = 'Velodrome'
where platforms = 'Sushiswap'
where platforms = '0xProject'
\n

\
==Velodrome== | ==Sushiswap== | ==0xProject== |
---|---|---|
Number of swaps: 461k | Number of swaps: 3810 | Number of swaps: 8.87k |
Number of users: 41.1k | Number of users: 1629 | Number of users: 2580 |
USD Volume: 190M | USD Volume: 253k | USD Volume: 6.52 Million |
Top pair-transactions: WETH/USDC | Top pair-transactions: WETH/USDC | Top pair-transactions: OP/USDC |
Top pair-volume: OP/USDC | Top pair-volume: USDC/WETH | Top pair-volume: USDC/OP |
Top token_in: USDC | Top token_in: WETH | Top token_in: USDC |
Top token_out: USDC | Top token_out: WETH | Top token_out: USDC |

Number of swaps
The highest number of transactions was on October 13th with 26.883k.
The lowest number of transactions was on October 9th with 6356.
The number of swaps grew to almost 442.68k from September 26th to October 26th.
Number of user
The highest number of users who had swapped on Velodrome was on October 13th with 7146.
The lowest number of transactions was on October 26th with 1538. (This might be because the date of this date is not completed since the dashboard has written)
USD volume
The highest USD volume of all the swaps on Velodrome was on October 25th. On this day, the USD volume of the total swaps was 14.5 million.
The lowest USD volume was on October 9th. On this day the USD volume was almost 2.5 million.
The total USD volume grew almost 28% over the time.
Top pairs
Top tokens based on the number of swaps
Swap from (token_in)
Swap to (token_out)
In total, WETH/USDC pair has the most number of transactions over time. The total number of transactions on this pool is almost 102k.
The least number of transactions happened on VELO/OP pair with 32k.
The highest USD volume belongs to OP/USDC with almost 30 million USD.
The least USD volume of all the swaps on Velodrome belongs to USDC/VELO pair with almost 4.5 million USD.
The top token uses to swap from in Velodrome is USDC with 255k.
USD uses the least to make swaps from in Velodrome with 4706.
The top token is USDC which is used almost 260k.
The least number of swaps is used MIM with only 390 times.
Sushiswap
Velodrome

Number of swaps
The highest number of swaps on Sushiswap was on October 15th with 256 swaps.
The least number of swaps was on September 29th with 50 swaps.
The cumulative swaps number grow by almost 49% overtime.
Number of users
The highest number of users who had swaps on Suhiswap was on October 15th. On this day, 155 users had swaps on this platform.
The least number of users was on September 27th with only 27 users.
USD volume
The most USD that was used to make swaps on Sushiswap was on October 15th. On this day, the total USD volume was 18.3k.
The cumulative USD volume started at 2207 on September 26th and ended at 253.2k on October 26th.
The cumulative USD raised almost 114% over the month.
Top pairs
The top pair that had the most number of transactions is WETH/USDC with 1501 transactions.
The least number of transactions is on WETH/OP with 333 transactions.
USDC/WETH has the most USD volume over time. This pair has a 105.6k USD volume.
The USDC/USDT has the least USD volume over the month with 1174 USD.
Top tokens based on the number of swaps
Swap from (token_in)
Swap to (token_out)
The top token is WETH which has almost 2103 swaps over the month.
SNX had the least number of swaps from with only 1 swap.
The top token us WETH with 1949 swaps.
The least number of swaps happens on SNX with only 2 swaps.
0xProject

Number of swaps
The highest number of transactions on 0xProject was on October 13th. On this day the total number of transactions was 524.
The cumulative swaps number raised almost 48% over the last month.
Number of users
The highest number of users was on October 1st.
On this day, 288 users had swapped on 0xProject.
The least number of users was on October 10th with 63 users.
USD volume
Top 10 pairs
The highest USD volume of all the swaps on 0xProject was on October 1st with almost 619k.
The cumulative USD volume on 0xProject started at 76.17k on September 26th and ended at 6.5 million USD on October 26th.
The cumulative USD raised 84% over the last month.
Number of swaps
Number of users
USD volume
Top 10 pairs
Number of swaps
Number of users
USD volume
Top 10 pairs
Number of swaps
Number of users
USD volume
Top 10 pairs
Top tokens
In total the top pair that had the most number of transactions on 0xProject is OP/USDC pool with 980 transactions.
The least number of transactions happened on USDC/SNX pair with 311.
The pair that had the most USD volume is USDC/OP pair with almost 793k USD.
The least USD volume of top 10 pairs belongs to SNX/USDC pair with 227k.
Swap from (token_in)
Swap to (token_out)
The top token of the top 10 tokens is USDC with 3774 transactions.
The least number of transactions used CRV token with 47 times.
Compare Velodrome & Sushiswap & 0xProject
In total the highest number of swaps was on October 13th. On this day, of all the swaps 26.3 k were on Velodrome, 459 swaps were on 0xProject, and 105 swaps were on Sushiswap.
In total, the highest number of swaps belongs to Velodrome with 466k, 0xProject is in second place with 8023 and Sushiswap has 3817 swaps over the last month.
Number of users
USD volume
The highest number of users was also on October 13th. Of all the users who had swaps on this day, 7066 users belonged to Velodrome, 93 users were on 0xproject and 46 users were on Sushiswap.
In total, the highest number of users is on Velodrome with 41.2k, 0xProject is in second place with 2536 and Sushiswap has the least number of users with 1639.
The highest USD volume that used to make swaps on these 3 platforms was on October 25th. On this day, The USD volume of Velodrome was 14.5 million, 0xProject was 488.6k and on Sushiswap was almost 14k.
In total, like the number of transactions and number of users, Velodrome is in first palace of the these platform and had the most USD volume. The total USD volume on this platform is 197.6 million USD, on 0xProject is almost 6.5 million and on Sushiswap is 257k.




The highest number of transactions was on October 25th. On this day OP/USDC pair had the most part.
7910 swaps happened in this pair.
The second pair that had a noticeable part was WETH/USDC with 6547.
The highest number of users was on October 13th. On this day OP/USDC pair attracted the most users.
1935 users had swapped on this pair.
The second pair that had a noticeable part was WETH/USDC with 1409.
The highest volume of swaps was on October 25th. On this day the most volume belonged to USDC/WETH pair with almost 1.40 million USD.
The second pair of this day was WETH/USDC with 1.35 million USD.
The highest number of transactions was on October 15th. On this day, the highest number of transactions was on USDC/WETH pair with 106 and the least number of transactions happened on DAI/USD and USDC/DAI pairs with only 12 transactions.
The highest number of users was on October 15th. On this day, 91 users used USD/WETH pair.
The least number of users used USDC/DAI, WETH/DAI and DAI/USDC pairs. 12 users used these pairs.
The highest USD volume was on October 15th. On this day, the highest USD volume was on USDC/WETH pair with 8574 USD.
The least USD volume was on DAI/USDC pair with 30.3 USD.
The highest number of transactions was on October 25th. On this day, most of the swaps happened on OP/USDC pair with 140 and the least number of swaps happened on WETH/USDC and USDT/USDC pairs with 13 swaps.
The highest number of users was on September 29th. On this day, 39 users used sUSD/USDC and USDC/DAI pools.
Only 1 user used USDC/QI and USDC/USDC pairs.
The highest USD volume was on October 1st.
On this day, the most USD volume was on USDC/OP pair with 203.6k USD.
The least USD volume belonged to sUSD/USDC pair with 1507 USD.
The highest number of swaps used USDC. The total number of swaps that uses USDC is 3899.
The least number of swaps is on WBTC with 173.