wait what, arthur hayes saying penang was never in my bingo card

see yall in devcon!!

Wanna do a YouTube live to roast your sql queries (and give feedback on where to optimise/query correctly). Anyone wanna volunteer their queriessss

If you're tired of always seeing the same analysis and the types of dashboards, be the change you wanna see. Time to learn the hard stuffs. Starting point here - youtube.com/playlist?list=…

No Sunday video because irl video today

Sunday = New video! Watch to see how I recreated the NFT transfers table on Base: youtu.be/lf_2jXc4a3I NFT transfers include both 721 and 1155 standards. While 721 is pretty straight forward, 1155 has a TransferBatch event where multiple tokenids and their quantities are

Some points here that I think are worth highlighting: 1. It is not built off decoded event logs because nfts (contracts) might not be verified and thus we might not have its ABI which is needed for the decoded event logs which is why the regular event logs is used instead. 2.

Anyone in the data CT going to devcon?

New video today will be another example of decoding traces. This time, it's Astaria on Base Haven't made the video yet though, gotta do some groceries first 😎

1/ Did you know that you can use LLMs in Snowflake? Let me show you how its done with Flipside and Farcaster's data! ✅ Zero shot classification ✅ Make summaries ✅ Provide your own labels and summarize all content under your given label ✅ FREE ✅ Download CSVs Let's go!