Layer3 in collaboration with Flipside Crypto has decided to sponsor one of Flipside’s Educational Bountys.

This walkthrough was designed to prepare arriving analysts to know their way through Flipside’s Ethereum Core tables.

On this particular case, the next tables will be used:

• ethereum_core.dim_dex_liquidity_pools to find pools dealing with specific tokens.
• ethereum_core.dim_contracts to find the contracts dealing with those tokens.
• ethereum_core.fact_event_longs to find swapping transactions inside those contracts.

Hunting the educational bounty

After reaching the final steps of the educational bounty a task will be given, and this will be our bounty

Bounty

• By using ethereum_core tables, create the same analysis for WBTC-WETH pool on Sushiswap from April 1 - April 15, 2022.
  • Does this pool have more or less swap volume as compared to WETH-USDC?

The Target

At the moment one reaches the end of the educational bounty one should have the sql ready to be reused and specified for our bounty.

In this case, our already done WETH/USDC chart should be mapped out, now it’s just a matter of changing the corresponding date to our new timeframe, in this case being April 1 - April 15.

And also changing our pool address/contract to reflect WBTC-WETH pool.

Bounty Hunting

So, does the WBTC-WETH pool has more swap volume than the WETH-USDC one?

Well, nope.

The WETH-USDC pool not only had by far more activity than the WBTC-WETH one, also moved more value.

While their activity remained somewhat correlated, meaning general trends, the USDC pool just had more activity.

Can we look closer to these behaviours around these days?

Yes, if we expand the tables given in the walkthrough with some few parameters and inner join them both, we can have a detailed movements around these days.

Pools Usage

WETH Volume on each pool

Pools usage

As stated before, but now more clearly, the activity on USDC-WETH pool is far bigger than that inside WBTC-WETH pool, if the scale weren’t set in log, WBTC pool line would be flat in comparison with WETH’s.

Pools Volume

Pools Volume

And in volume it’s a little more tricky, just using the walkthrough the steps to converting to USD values is not presented so i thought it would be out of line to just add another table..

But even though the values of each BTC is not here, we know for example that it has never reached 100k in USD price. despite Plan B’s projection.

So there is no doubt that USDC-WETH pool swapped a USD volume far bigger than WBTC-WETH pool

And WETH volume inside those pools?

Just in case the question popped in your mind.

It’s not negligible.

While obviously USDC swapped far more WETH than their WBTC counterpart, it did actually moved a lot of WETH.

But again, its still far less than WBTC pool WETH swapping.

A little bonus snapshot of those days in early April

Thanks to Flipside’s Database, we can also look at how did the entire Pool ecosystem inside Sushi performed.

For example, we can see that USDC-WETH pool was actually the top biggest performer in the entire sushi liquidity portfolio.

Followed in second place by USDT-WETH pool.

Making the two top performers pure Stablecoins.

And WBTC wasnt even in the list of the top 10 most used :c

The rest of the pools decrease abruptly in used when compared with the top 10 performers.

Many of them simply disappear in the sea of pools with low % use.

                                                                                              **Powered by**