How has EIP-4844 impacted L2 costs?

1/ As the table below shows, most L2s experienced a 90%+ reduction in their L1 costs after adopting EIP-4844 blobs

L1 costs = Gas and Blob Fees for batch posting transactions + Gas Fees for proof verification transactions 2/ Since their costs dropped by an order of magnitude, L2s could afford to reduce the gas fees they charged users.

As shown in the charts below, the cost of making common transactions like ETH transfers or Uniswap trades has dropped 90%+ on most L2s.

I often get asked the question, "What's happening onchain?"

The answer usually lies in incentives. Every new wave of onchain activity is driven by a new incentives playbook. For example 👇 [2020] Liquidity mining

- Compound, a lending protocol, kicked off the liquidity mining trend in June 2020 with a wildly successful token incentive program. Compound's TVL spikes from $100M to $600M in one week

- Every DeFi protocol under the sun copied this playbook and DeFi summer entered full swing.

Learning crypto data science changed my life and was 100% free.

If you're looking for a change (I was a transport planner), start coding 1 hour a night. More on weekends.

Pick a simple @DuneAnalytics project. Learn just enough to build it. Pick a bigger project. Repeat. It took me 3 years to get to my current level of crypto data proficiency (preceded by 3 years of writing coding in other fields). Here are some free resources you can use to get there 10X faster 👇

Here is what rollups spent on posting data to Ethereum in November:

1. Arbitrum - $4.4M
2. Linea - $3.7M
3. Optimism - $2.508M
4. zkSync Era - $2.506M
5. Scroll - $1.43M
6. Base - $1.34M
7. Polygon zkEVM - $678k
8. Starknet - $500k
9. Zora - $211k
10. Aevo - $109k
11. Orderly - $101.2k
12. zkSync Lite - $101k
13. Public Goods Network - $95k
14. Mode - $31k
15. Lyra - $17k You can query insights like this using the Rollup Economics Spell on @DuneAnalytics.

Huge thanks to Archwizard @LehmannLorenz for adding Scroll and Linea to the dataset last week! 🧙‍♂️✨

It's been 5 months since I started that Spell. Feels really exciting to see more wizards building it up 🥹

Here's an example of how to use the Spell 👇

https://x.com/0xKofi/status/1732068147979846062?s=20

How to become a DeFi frontend engineer (starting from scratch): Step 0: Learn basic JavaScript and HTML from a free resource of your choice (CodeAcademy, w3schools, freecodecamp .etc)

For JavaScript, if you understand variables, functions, if statements, and while loops then you're fine.

Introducing "DefiLlama ChatGPT Plugin🦙✨"

Retrieve data on DeFi protocols and blockchains using plain english!

Here's how to use it 👇 If you have ChatGPT Plus, install the plugin and try it out!

I'd love to see us hit the Trending page on the plugin store 😁

I'm writing a guide to generating Dune queries with GPT.

It's a work in progress. Lots of new lessons in the pipeline, and I'll continuously update to include new Dune features.

If you want to read it, subscribe to 0xTrends Premium ($25/month).

0xtrends.com/gpt-crypto-dat… Limitations:

GPT is not deterministic; there is an element of randomness in how it responds to prompts.

A good prompt will usually generate passable DuneSQL code, but not always.

I include examples of common mistakes GPT makes and tips on how to deal with those hallucinations

How to make token value go up 🚀

An insight shared by @Gabe_PZ on our @gauntletnetwork x @DefiLlama Space 👇 There are three ways in which a protocol's token has value:

- token controls highly valuable governance decisions

- token has claim on current cash flows so you're earning money from the protocol

- expectation that token will have claim on future cash flows

The next crypto data unicorn will be built on vector embeddings

Here is a breakdown of
- What vector embeddings are
- How they supercharge LLMs like GPT4
- How they will help you crush your competition LLMs are limited to the knowledge in their training data

If asked about something beyond their knowledge, they'll likely generate an incorrect answer.

Smart contracts emit "Events" to notify devs when a specific activity has happened

Yesterday, the 𝗛𝗮𝘀𝗖𝗹𝗮𝗶𝗺𝗲𝗱 event of the Arbitrum airdrop contract was emitted 420k times

It was the 5th most popular event of the day! 𝗦𝘄𝗮𝗽 was the 4th most popular event of the day

You can guess why 😂

Introducing "NFT Appraisal App Tutorial 🖼️✨"

When you finish this guide, you will have:

- Built an app that takes a wallet’s address or ENS name and returns the value of that wallet’s NFT portfolio

- Used Python, @AlchemyPlatform, @GoogleColab, @Streamlit and @Replit Here's the link to the video ⚡

Don't know how to code - You'll be able to follow along and build your first crypto data app

Basic programming skills - You'll learn enough to edit the example project into a range of different crypto data apps

Done editing my first crypto data app tutorial

Don't know how to code - You'll be able to follow along and build a simple NFT analytics website

Basic programming skills - You'll learn enough to edit the example project into a range of different crypto data apps The whole thing is in python, including the frontend

It's 30 minutes long

Looking forward to putting it out soon

Don't let it flop guys, I've overinvested in this video 😂😭😂

Introducing "Bitcoin Security" 🪙✨

A dashboard I'm working on to track the Bitcoin security budget

- Block Rewards and Transaction Fees
- Security Budget as % of Market Cap
- Impact of ordinals on Txn Fees
and more... Still a WIP. Open to feedback.

Wouldnt have been possible without the prior work of ArchWizards @Data_Always, @andrewhong5297 and @hildobby_ 🧙‍♂️✨

dune.com/niftytable/bit…

I crunched the data on Bitcoin's security budget

Some believe that this one data point could spell the death of Bitcoin.

Here are 4 key insights into what the budget is, what the current stats are and how Bitcoin NFTs might save the day 👇 The security budget is the money paid to miners (block rewards + transaction fees).

When the budget is high, 51% attacks are expensive and vice versa.

53% of Blur's volume comes from just 500 wallets

(research by Archmage @jphackworth42 🧙✨)

The marketplaces are killing their profits, long-term relationships with creators and future growth prospects to compete for ~500 pro traders Instead of trying to grow the pie of NFT users 🤦

There has been an intense battle over royalties in the NFT space

I crunched the data on how much creators have earned from royalties

Here are 3 key insights I found 👇 1/ In 2023

Opensea has paid out 18k ETH in royalties ($31M at today's price)

Blur has paid out 3.7k ETH ($6.1M at today's price)

If you work in VC/trading/sales/BD you spend a lot of time researching what new protocols people are using and why

I write two emails a month summarizing the data on early + fast-growing protocols

These emails will save you time

Here is this week's 👇

0xtrends.com/issue-003-nft-… I'm ok with making this one public because the products I covered are relatively well known 🤷🏽

Usually, my emails include more unknown projects

If you want to access the archive, and get sent future reports, sign up for my email list here 👇

0xtrends.com

The most popular crypto mobile apps in Nigeria 🇳🇬

Google Play Finance Rankings
#7 - Metamask
#36 - TrustWallet
#46 - Binance The most popular crypto mobile apps in Ghana 🇬🇭

Google Play Finance Rankings
#36 - Binance
#41 - YellowCard
#43 - TrustWallet

I crunched the data on @manifoldxyz, one of the most popular no-code tools for creating NFT contracts and NFT drop websites.

Here are 4 key insights I found 👇 1/ Manifold's Claims product makes it easy to create websites for limited edition and open edition NFT drops

𝟮𝟮𝟯𝗠 NFTs have been sold using the Claims tool for a total of $𝟯𝟮𝗠

Why did @manifoldxyz gallery/marketplace have crazy high trading volume in Feb 2022? Anyone know? 2022 people. Last year. Not talking about the current OE craze lol 😂

In crypto, attention = power

Here are 5 tips on leveraging the media to get attention for your project from @eking0x (managing editor of @DLNewsInfo) 👇 We covered these tactics on this week's @DefiLlama X DLNews Twitter space

To learn more about the inner workings of the crypto media industry and how you can benefit from it, listen to the full recording 👇
twitter.com/i/spaces/1ypJd…