Rollup Economics Dune Spell

Contribution

𝗧𝗟𝗗𝗥A Dune dataset that makes it easy to query revenues and costs for all OP stack rollups and other L2s𝗗𝗲𝘀𝗰𝗿𝗶𝗽𝘁𝗶𝗼𝗻I created a Dune Spell table that has data on rollup - on-chain revenues (transaction fees)- costs (posting data to L1) - and raw materials (L1 calldata) of rollupsIt automatically updates to support new OP stack rollups.Here is a demo showing how to query Base revenue using the new Spellhttps://youtu.be/T2_j_JlGeDQThe dataset is a great tool that analysts can use to generate rollup business metrics for OP stack teams and their communities.

Impact

This Dune Spell is an open-source model that makes it easy for analysts to surface useful rollup economics insights and share those with the community. It's already being used by popular L2 Dune dashboards with more than 730 stars combined. For example, - https://dune.com/niftytable/rollup-economics (built by me)- https://dune.com/sealaunch/rollups-profits (built by the SeaLaunch team)The open-source code is also being used by analytics platforms outside of Dune::"At Artemis, we routinely use the roll-up economics spellbook as a reference to understand how to calculate profit across OP Mainnet, OP Stack chains, and other roll-ups in the Ethereum ecosystem."- Nirmal Krishnan [Head of Engineering at Artemis.xyz]