Fuse Pool USDC Allocation | Sajjadiii

How are the tokens in the USDC Vault being allocated into the various Fuse Pools?

Rari Capital is a powerful open interest rate protocol built on the Ethereum blockchain. Any user can supply and borrow any asset in a Fuse pool.
In this dashboard, we'll look at how to change the allocation of tokens from the USDC Vault over time.
Next,we will examine Rari Capital's USDC vault to see how overall tokens are allocated among various pools.

I used 'flipside_prod_db.ethereum.udm_events' table to find the answers.
I gathered the amount of amount_usd and put the contract_address of each group as a condition.

The bar chart above shows the USDC allocation from the USDC Vault to the pools per month.
Allocation of DAI Vault began in May 2021 and reached a record $ 30 million in November 2021.
In the months following November 2021, there was no mysterious allocation to the pools.
In jan 2022, only fuse pool 7 was allocated.
Fuse Pool 7 is the only pool that has received token allocation for all nine months, which is in line with the fact that the USDC fund has allocated the most USDC to Fuse Pool 7

The chart above shows that the largest allocation is for fuse Pool 7, with an approximate value of $ 24.8 million and 41.6% of the total value.
fuse Pool 6 is in second place with an approximate value of $ 16.5 million and owns 27.7% of the total value.
fuse Pool 18 is also in third place with an approximate value of $ 13.7 million and 23.1% of the total value.
The rest of the pools account for approximately 7% of the total value

Conclusions

nearly 94.4 % of pool utilization is done via the Fuse pools (7,6,18)
Fuse 7 is the biggest pool with 41.6% or 24.8 m $
Fuse 6 is the second biggest at 27.7 % or 16.52 m $
Fuse 18 is the third biggest at 23.1 % or 13.78 m $
Less is utilized via Aave and Compound and et.
Fuse Pool 7 is the only pool that has received token allocation for all nine months, which is in line with the fact that the USDC fund has allocated the most USDC to Fuse Pool 7