henrystats 🦇🔊

One of the requirements for the recent $ZK airdrop from the @zksync L2 was to be a Milady or Pudgy Penguins NFT holders. I've spent 2 days gathering a lot of data to highlight some differences in behaviors between these two communities so you don't have to. The last airdrop Miladys got was the $OMNI airdrop. At that time, the amount being held (in terms of %) was good and it was super surprising given the market conditions. The point was made that Milady holders were not jeeters, but rather diamond hands. However, market condition can shift really fast. What about now ? What does the data tell us ? To make this happen, we'll be using @DuneAnalytics and also gather data into Excel to figure out the amount of $ZK being retained by both collections. Let's dive in, follow me now🧵

Okay, so here are some observations about today's @DuneAnalytics update from the perspective of a novice SQL learner (for now). I believe novices opinions are by far the most importants for projects to take care of for few obvious reasons : -Feedback on ease of use of your interface -Can improve documentation -Unbiased perspective Anyway briefly : It's just incredible. These updates are amazing. I have no doubts now that Dune is actually going on the right path for mass adoption. I wouldn't be surprised to see Dune Analysis courses in some univerisities in the future. Now, few screenshots below : 1) Informative and straight detail on what roles the column occupy in the table : First here you can see that now Dune added these new "i" circle logos (for "information") at the right of each columns. If you just get your mouse on them, it gives you a quick idea of what this column contains or what it can be used for : That was super needed for newbies and please thunderous applause to the team and specially to @__scalar__ which is a super smart guy who knows where to listen to the powerful feedbacks. He told me the team had some plays in mind and it's crazy how this one just impressed me. However if I am correct, that option is not included in every table rn. I am just not sure if that's because some other tables, that might also have these columns, already got these informative logos on their right so they are prolly not doing that again and again for every data table, idk. Anyway, I'll just give another feedback on this one later. 2)Columns to use to boost query speed with filtering : Honestly, as I said I am just getting started and not an expert at all. I won't be able to give a proper feedback on this one tho I believe it's super useful too rn. So this might now allow people to write more efficient queries. Doc here if you guys wanna get a deeper understanding : docs.dune.com/query-engine/w… (doc will be updated soon with more info, team says) 3)Direct links to github sql repos with every spellbooks: Again so sorry but I am not an expert. However, if I have to guess that's super powerful because : -Now everyone is able to identify any potential bugs or errors regarding the tables and can just pull request to fix it asap (super nice). -Better comprehension of how the data is stored, structured. -Maybe better integration for people building apps ? I hope I didn't miss anything but I am so proud of how the team is smartly filling the gaps. There is no doubt that Dune will be by far one of the most used platform for analysing crypto data. They are focusing on the right things to make this happen so it's pretty cool to see these improvements merging to make User Discovery, UX better every months.. But if I may offer one critique in relation to the first thing I talked about, it is that occasionally the information provided isn't sufficiently clear. Taking the data column tx_hash as an example here : It returns "Transaction hash" as an information but I would've preferred something like : "unique immutable identifier for each transaction on the blockchain that allows verification of transaction details" Unfortunately, it's not always clear (I've only used one example here), but yeah might happen more idk. However, the Dune crew will undoubtedly handle this better than I will (as they showed us today LOL), so it's not even that big of a problem for them😂 Anyway massive congrats to @andrewhong5297, @__scalar__ , @hagaetc and the rest of the team. Too smart to fail I'd say 👏