Data

/data6195

Let the data discussions flow- onchain or offchain.

Reminder: Back in March, we were still paying up to $2 in transaction fees on Layer 2s, but now the cost of a transaction is just a few cents 🪙

🔗 https://dune.com/Marcov/layer-2-transaction-cost
Anyone building a credit protocol for Farcaster?
Made this model 2 years ago, would be cool to adapt the idea to Farcaster data:
https://randombishop.medium.com/can-credit-models-work-in-defi-f15cc8df7e0d
Gm
Recent developments in the meme coin space have seen some significant activity and interesting trends. One of the most notable updates is that Solana-based meme coins are gaining momentum, with nearly 40% of Solana's trading volume driven by meme coins. This surge has helped Solana outpace Ethereum in terms of on-chain trading volume, marking a significant shift in the crypto ecosystem. Popular meme coins in this trend include newly minted tokens such as Popcat, Neiro, and SPX6900.
@mats feature request: could we get PIVOT in DuneSQL?
when forecasting a variety of data without individual models tuned to each subset (variety length, fragmentation, etc) is it appropriate to use a polynomial average from multiple forecasts (moving avg, regressor, no regressor, interpolation) since no one works well on all subsets? or am i missing something more obvious

timeseries forecasting
wow, so cool
Gm
The meme coin market has seen significant activity in October 2024. Dogecoin (DOGE), Shiba Inu (SHIB), and other established meme coins like PEPE have shown notable price increases, with DOGE rising 11.8%, SHIB up by 32.8%, and PEPE by 38% in the last month. Overall, the market capitalization for meme coins grew by 34.7% over the past month to $48 billion, reflecting renewed investor confidence.
Top 20 FC Channels by Member Count
Just wanted to keep my /data streak so linking this data analysis from 6 moths ago:
https://x.com/randombishop/status/1782774433888776380
Last week Tal/I have been working on building a small Trader PnL Webapp powered by sim. This ended up being particularly timely as @zachxbt recently identified 11 wallets owned by Murad, which generated some excitement on CT. The PnL app shows the profit and loss (PnL) and other details of a trader's activity by token, given their address(es) active on @base or @ethereum

The data is live, not a snapshot from minutes/hours ago.
Test drive the PnL app on these wallets or any wallets on:

playground.sim.io/trader-pnl?addresses=0x6b411100c72ba2445e50ffd20839c28b3546de7c%2C0xcbd0dee0c3eed152c3398b062361becc4a15522b%2C0x13fc38ec99a8217a06d1dc6db8c0bf0ee97ebf7f%2C0x71b4fd11eef705ba60176e7c034cd1a4f97ae02d%2C0x30b46a659761b576a00028b44d1e37fdc64b034d%2C0x5b1569db234a0f2884814a3f7184f01cf641b0c6%2C0x464e0a666734ba93e231d929ace538eaf05ff424%2C0xdb47714727cba70f0408ba30dc4ea0b5ac436055
Wonder if anyone has done correlation analysis for Warpcast DAU with Eth/ BTC price fluctuations?
Trying to do so but unable to find accurate fc data (thats downloadable)...
This one looks serious until you realize how I made it...
'being able to have transparent data and also be rewarded for your contributions (for even some random anon like myself) is what makes crypto so special to me'

@jhackworth, data scientist @variant
Farcaster Channels Ranked by Total Member Count

Key Insights:

- 10 channels have >1,000 members
- 398 channels have >100 members
- 764 channels have >50 members
- 13,839 channels have >1 member

Data via @neynar

https://docs.google.com/spreadsheets/d/1gkLfgD8GmWOy6-vQRryB-5GHUyKyFZXAT699j41Od6o/
The reason why blockchain data is hard, an example with Gnosis Safe

How call data (or input args of smart contract functions) are normally decoded:

1) Take call data
2) Extract function name from the 1st 8 chars or by looking at the Contract ABI
3) Apply and get decoded input args, nicely formatted with their names and types

How to do it with Gnosis Safe transactions:

1) Take call data
2) Look at the code of Gnosis Safe SDK or other repositories to find the logic of how this call data was constructed and argument names
3) ...

Now I'm wondering, what is the reason for not using a common method, used by all the devs and explorers, and instead doing this
I haven't looked at what the clusters are made of but I like my Farcaster map. I am building it into something interactive. Imagine a google maps UX for exploring FC users in 2 dimensions. What would you like to see on the map?
Today is a good day to be data-first!!
Although a lot of development is happening on Layer 2 now, the number of unique contracts published on Ethereum reached a new high in september: ~43K unique contracts 📈

🔗 https://dune.com/Marcov/contract-deployment
Good morning! 🌞 New day, new chances, and fresh energy. Let's make today amazing! 🌿 Stay positive and keep shining.
Can we really predict the future? As prediction markets reshape media and decision-making, learn more about how they work and how Envio enhances /limitless with real-time data indexing and insights in our latest case study. 🔮 ⚡

https://docs.envio.dev/blog/case-study-limitless-prediction-market
Can we really predict the future? As prediction markets reshape media and decision-making, learn more about how they work and how Envio enhances /limitless with real-time data indexing and insights in our latest case study. 🔮 ⚡

https://docs.envio.dev/blog/case-study-limitless-prediction-market
If the ask isn't too crazy, I don't mind helping out a project or protocol on farcaster to make a dashboard for free

I may be a bit slow. Have been out of serious data work for awhile. Let me know in the comments and I'll see how I can accommodate. I wanna get back into the game

Your data must be on Dune (onchain)
I’ve starting creating data engineering themed short video content. My latest can be found here:
https://youtu.be/VWu9bZg58B4