Hi Solana And DaoSol👋

Assumption

for this question most of Assumption provided as tip in question (thank you 😉), but there is some point so I write all of them:

1. data is in events table
2. each transaction maybe have multiple events that's run sequence. data we need there is in index labled with index=4 and has MintAuthority = 41CKnj1gy1AXQ1nf2dB9Ubst3QGHxjWkFLd78KLpGYsr and Mint = monKYjV2bHTjbJVWCCcwhxE8C96sdTKR2HUNUHCjh4z at third instruction in inner_instruction column
3. we can find amount of solDao that deposited in inner_instruction:instructions[0]:parsed:info:amount
4. we can find amount of sol that deposited in inner_instruction:instructions[1]:parsed:info:amount
5. we can find amount of daoSol that minted in inner_instruction:instructions[2]:parsed:info:amount

Problem

in first question we must find how much liquidity has been deposited in the daoSOL-SOL pool per day? as according assumption we know how to find tx that create (deposite) daoSol-Sol lp token and we know how to find amount of daoSol and Sol so we just need to group them and find sum of these.

notice 1: black line shows how many user deposite in each day.

notice 2: there is one transaction have by far more Sol and daoSol deposite than other. if I show chart in linear scale other bars have so much little so I change scale to Log for better showing bars.

we can also find how much daoSol-Sol minted by user during this time

now We can put all in one chart to better compare ( notice: scale type is log )

next question want to now __ How many unique wallets have added liquidity to that pool since February 1st?__ if we one to show as daily info we can se this data in chart in top but for all of this period I provided some information in bellow.

for the last question Create a visualization showing liquidity trends with this pool. we should draw chart. for daily information I have created some charts before but in addition to before I created to chart that cumulative Information.

• first chart I sort tx from in order time tx created and sum daoSol deposited,SOL deposited,daoSol-SOL minted as we see In 6th tx we have a jump. raeson for this jump is some one added 5,200 SOL and 4,771.44 daoSOL to liquidity in one tx (link).

in daily Tx count: we have less than 10 tx in each day usually (you can see in pervious charts) but from 8 to 11 Feb we have a big jump but what is reason of this jump? because In this duration we have a hunt in Flipsidecrypto that need deposit tx for completion(😉)

that's end of__Saber and daoSOL__ bounty🎉. see you soon 😅