(1/7) What is sim Studio anyway?

RT @Dune: 🛣️ Milestone reached! 🎉. Dune now supports 100+ blockchains – the most comprehensive coverage in onchain analytics!. From @ethere….

Join millions who have switched to Grok.

RT @andrewhong5297: A data problem most devs will face is that you can't call read functions to get pre/post transaction data using eth_cal….

RT @Dune: Dune Echo x @layer3xyz 🔊. ✅ 50x Speed improvement.✅ Hundreds of requests --> One request.✅ 48-hour migration. In this case study….

🔔 PSA: As announced in #Dunecon, smlXL will be joining @dune to create the industry's most comprehensive real-time blockchain platform for developers and analysts alike. As we work towards our shared vision, we're sunsetting with plans to reimagine and.

(6/6) Take a peek at the sim Canvas that powers this feature here: . Are you an app developer who needs PnL data, or any real-time blockchain data? Reach out to us and we can help supercharge your app.

(5/6) Using sim, our PnL dashboard can now provide the actual ROI and PnL for this trade (an impressive 5x):

(4/6) The same is true for many of the industry-standard PnL apps: they simply show the buyer "receiving" tokens without any payment. For example, no LAIKA token appears on their Cielo PnL page

(3/6) Looking closer, you can see that they actually made a cross-chain purchase with USDT (courtesy of @axelar's GMP!): Here's the other side of that cross-chain payment on @base:.

(2/6) Here's an address that bought some LAIKA ( @Laika_Layer2 ) tokens via @FjordFoundry:.?address=0x777C9e6e43e14A332bB94de84A7cA58f94CBE81B. On-chain, it may look like they simply "received" the tokens out of thin air:.

(1/6) Most PnL tracker apps are oblivious to pre-sales/launchpad sales. Not ours! We now track and account for tokens bought via the major pre-sales/launchpad platforms. Try it out: Or read more below about how complex these purchases can be.👇.

(2/6) Here's an address that bought some LAIKA ( @Laika_Layer2 ) tokens via @FjordFoundry:.?address=0x777C9e6e43e14A332bB94de84A7cA58f94CBE81B. On-chain, it may look like they simply "received" the tokens out of thin air:.

We're thrilled to join @Dune! Our shared mission of making blockchain data more accessible creates a perfect match. Together, we are creating the easiest way for anyone to build lightning-fast, real-time applications with blockchain data.

(8/8) PS: There are some other little challenges in indexing the logs:.- Some transactions emit multiple logs.- Need to identify buyer and seller.- Have to handle the NFT being in either the offer or the consideration. Check out the canvas: Build on sim!.

(7/8) A few bucks in @AnthropicAI credits later (cheers @sdrzn for Cline--it's awesome!), and with the help of @opensea's APIs, we have our dashboard with the most expensive NFT purchases on Seaport 1.6 on Ethereum and @base in the last 24 hours!.

(6/8) With the transformation done (by ChatGPT🤫) in Solidity, the SQL fits in a tweet!.```. select * from @shane.simple_seaport_nft_purchases_ethereum. where block_timestamp >= now()/1000 - 3600 * 24. order by price_paid desc. limit 10.```.

(5/8) Conceptual solution: Let's narrow our scope to simple purchases with exactly one NFT and Ether (wrapped or native) as all other considerations. Logistics: And let's do the aggregation we need in Solidity in our sim EVM Lambda. SQL should be SQueaky clean and Light!.

(4/8) Challenge: Notice how a single OrderFulfilled log contains dynamic arrays for the offer and consideration?. Conceptually hard: how do we value one NFT that was traded for another NFT, 2 wrapped ether, and a ham sandwich?. And logistically: writing SQL on JSON columns! 😱

(3/8) But good luck using it!. Seaport 1.6 is extraordinarily flexible and can enable all sorts of trades--like a real seaport, there's goods moving all over the place and it's complex. We'll hook an EVM Lambda on that log, but there's work to be done!

(2/8) Let's focus on the OG marketplace's most recent protocol, @opensea's Seaport 1.6. Sometimes data indexing is hard because we don't have logs for the right data--sim serves these cases with function and other hooks. In this case, all the data is in OrderFulfilled logs. .

(1/8) Sometimes you just want to see some pretty NFTs. Which ones are prettiest? The ones that people are spending the most money on in the last 24 hours!. How do we work this out? It's a can of worms. cc: @opensea @BoredApeYC @yugalabs @pudgypenguins @Azuki @XCOPYART @9GAG