Grace Profile Banner
Grace Profile
Grace

@_grace_lily

Followers
618
Following
827
Media
39
Statuses
690
Explore trending content on Musk Viewer
@_grace_lily
Grace
3 years
Happy Valentine’s Day frens! Finally posting my first article about optimizing PostgreSQL queries on @DuneAnalytics :’)
12
23
125
@_grace_lily
Grace
1 year
First day at @Uniswap & I’m hooked🦄🦄🦄🤩🤩
29
6
128
@_grace_lily
Grace
3 years
Taught my brother about NFTs last night & we minted @vibesdotart together :) Love how different these two pieces are @remnynt
Tweet media one
Tweet media two
2
3
29
@_grace_lily
Grace
2 years
Sometimes I forget how much fun it is to work on Dune - new stuff in the works 👀
Tweet media one
0
1
25
@_grace_lily
Grace
1 year
psa — if you live in New York highly recommend visiting the Adirondacks
Tweet media one
Tweet media two
Tweet media three
Tweet media four
1
0
15
@_grace_lily
Grace
3 years
Dev #7534 says hi @developer_dao 🤗
Tweet media one
1
1
19
@_grace_lily
Grace
1 year
Data nerds go MINT - honestly whoever made this @DuneAnalytics it’s 10/10
3
0
16
@_grace_lily
Grace
1 year
some of the most important questions around the growth & economic outcomes of L2s are answered in this dash. Everyone should thank @0xKofi for this incredible work🥲🙏🏼✨
@0xKofi
Kofi
1 year
@0xkydo Based on the feedback, I've updated my Rollup Economics dashboard to show - Daily Quantity of L1 data posts by each L2 - Daily Average size in MB of L1 data posts by each L2 You can find these new charts in the "Raw Material" section 📊✨ Note: You'll notice Jan to June OP
Tweet media one
6
4
43
1
1
16
@_grace_lily
Grace
2 years
Whoever is responsible for @dagsterio ’s UI deserves praise
1
2
13
@_grace_lily
Grace
3 years
Extremely clear & well thought out thread on why Defi is here to stay. A must read!
@TaschaLabs
Tascha
3 years
With regulations coming, some say DeFi will lose its edge. They’re wrong. “No regulation” is not the winning feature of DeFi. Neither is decentralization. Take those away and DeFi is still 100x better than TradFi. Here's a look at DeFi’s true competitive advantages 👇
57
346
1K
0
1
12
@_grace_lily
Grace
3 years
💯❤️🥳🤩 LETS GO @OurNetwork__ !!! So exciting!!!
@spencernoon
Spencer Noon 🕛
3 years
ONE HUNDRED ISSUES ❤️🥲 Thrilled & humbled to be dropping the 100th weekly issue of @OurNetwork__ , with coverage on @MagicEden_NFT , @impossiblefi , and @rabbithole_gg Contributors: @Derekmw23 @0xGrL @mikecaballero_ @kristineberth @p_petertherock @0xsinex
5
16
93
1
1
10
@_grace_lily
Grace
1 year
don’t forget to cross your t’s, dot you i’s, & remove your company name from your comments (unless u want @hildobby_ to surface ur data)
@hildobby_
hildobby
1 year
1. A comment in the smart contract mentions Coinbase
Tweet media one
1
0
20
0
0
8
@_grace_lily
Grace
2 years
🥲
@andrewhong5297
ilemi
2 years
gm @DuneAnalytics table previews are now live; no more SELECT * FROM LIMIT 10
19
17
174
0
0
10
@_grace_lily
Grace
1 year
very cool - been wanting to see this for awhile & they even crushed the UI
@zapper_fi
Zapper ⚡️
1 year
Let's make Ethereum readable. Together. ⚡️ We're excited to launch event curation, allowing you to contribute and help make onchain events understandable to everyone.
23
108
288
0
0
8
@_grace_lily
Grace
3 years
@spencernoon @OurNetwork__ @VectorDAO for design, @developer_dao to help build it out, @MetricsDAO for content (or more friends that love on chain data :)
0
1
9
@_grace_lily
Grace
11 months
@DuneAnalytics @mewwts not sure if this has already been asked but it would be great to be able to visualize a query workload. Would love to see what part of a query is slowest (even if it can’t include # rows scanned if it could just show % of time spent on each operation)
1
0
9
@_grace_lily
Grace
2 years
OP stack becoming OPrah for l2s
@eshita
Eshita
2 years
everyone gets a rollup
7
3
74
3
0
9
@_grace_lily
Grace
1 year
someone xgboost me out of here
@tszzl
roon
1 year
i wonder what gradient descent feels like
192
43
995
0
0
7
@_grace_lily
Grace
3 years
Brb sending this to my data science friends to pill them into web3
@andrewhong5297
ilemi
3 years
✨📊My inaugural guide to web3 data is here! In it, I'll walk you through: > how and why web3 vs web2 data thinking is different > layers and players of the data landscape, and key communities > 3 types of data roles with skills mapped out
19
179
613
2
0
9
@_grace_lily
Grace
1 year
Lord please give me the confidence of a vc investing in men with no product
@ASvanevik
Alex Svanevik 🐧
1 year
And we thought crypto was bad.
Tweet media one
Tweet media two
59
75
835
1
1
7
@_grace_lily
Grace
2 years
Atomic Habits is just Thinking in Systems on an intrapersonal level
1
0
8
@_grace_lily
Grace
1 year
1 year since waking up before dunecon to watch merge & now Danning is blessing us with the data 🥲
@sui414
danning.eth⚡️🤖
1 year
🎂 Happy Anniversary of the Merge 🐼 To celebrate, @Freddmannen and I wrote a report to provide a timeline view of how rapid the space has evolved over past year, covering notable events and behaviors in the MEV supply chain. (1/x) Highlights:
8
42
138
1
0
5
@_grace_lily
Grace
2 years
People like proof of merge
Tweet media one
0
0
8
@_grace_lily
Grace
2 years
@netcapgirl Ik we’re not supposed to judge a book by it’s cover but judging by its cover this is a great read
0
0
7
@_grace_lily
Grace
2 years
Decentralization is the disruption the scientific community needs. It’s going to unlock forms of collaboration in medicine and research that hasn’t been possible. Excited to see how each of these communities grow & more importantly what grows out of them.
@awrigh01
Aaron Wright
2 years
People sleeping on DeSci. It’s growing exponentially
Tweet media one
53
190
978
0
0
7
@_grace_lily
Grace
3 years
@EvanDeKim @hildobby_ I think it means understanding the data that comes w a tx executing on chain. It’s a mix of knowing the dif. features, the large decoded tbls (transactions, logs, traces, dex/nft.trades) & contract specific info like when certain events are emitted & which contract tbl to look at
1
0
7
@_grace_lily
Grace
2 years
Can we all agree now there is no security without transparency?
1
0
7
@_grace_lily
Grace
2 years
Who knew there was a master class on solana data
2
0
7
@_grace_lily
Grace
3 years
@nosleepjon wen no sleep chat so we can talk abt no sleep readings & rlly get no sleep
2
0
6
@_grace_lily
Grace
2 years
This is pretty close to the storyline of “The Lifecycle of Software Objects” — Ted Chiang is becoming modern day Nostradamus
@gaby_goldberg
Gaby Goldberg
2 years
This is a really fun project from @PraneetKedari and @yumat_10 , leveraging ChatGPT to talk to your NFTs. Currently getting to know my @finiliar ... try it out for yourself at
Tweet media one
5
9
55
1
1
4
@_grace_lily
Grace
3 years
Check this out!!! New issue filled with awesome work from fellow @DuneAnalytics x @OurNetwork__ mentees :) So lucky to have gotten to learn from / with them!
@spencernoon
Spencer Noon 🕛
3 years
Just dropped: @OurNetwork__ #99 might be one of our best issues ever 🧞🦉🔥🚨 Coverage: - @genie_xyz - @indexcoop $DPI Contributors: - @anyaa004 - @TejuAdeyinka - @chuxin_h - @dot2dotseurat - @bakabhai993 - @ruvaag Read/Subscribe:
1
13
70
0
0
6
@_grace_lily
Grace
3 years
We have digital galleries but what about digital libraries? With the popularity of reading lists & the collection of nfts on @viamirror it would be cool to be able to enter someone’s “library” & spend time reading what they’ve collected.
0
0
6
@_grace_lily
Grace
3 years
This year I discovered I love podcasts. I made this list originally as a recommendation list to send to friends, but deciding to share since it's a good intro to a lot of topics in the space. 21 podcasts for 2021.
0
1
6
@_grace_lily
Grace
3 years
@sui414 I’m writing an article rn it’s not ready but I can send list
3
0
6
@_grace_lily
Grace
3 years
Playing with nft data has never been easier!
@DarenMatsuoka
Daren Matsuoka
3 years
Introducing the NFT Analyst Starter Pack. Enter a contract address, and with one command generate CSV extracts for all token transfers, historical sales, and each underlying item’s metadata (w/ calculated rarity scores). Powered by @AlchemyPlatform . 🧵👇
41
255
1K
0
0
6
@_grace_lily
Grace
2 years
@startingfromnix One of my all time favorites. He just wrote a story for the New Yorker about chatgpt too!
1
0
6
@_grace_lily
Grace
2 years
Dad hasn’t even seen my taxes yet:
Tweet media one
2
0
6
@_grace_lily
Grace
2 years
Excited to see this dash grow :)
@MSilb7
Michael Silberling
2 years
First OP Stack op-chains (eventual Superchain) Dashboard?
3
6
41
1
0
6
@_grace_lily
Grace
2 years
@gaby_goldberg @hildobby_ , @eliasimos & @andrewhong5297 , best being easily digestible yet comprehensive analysis
1
0
6
@_grace_lily
Grace
2 years
Cool visual to see narrative shifts: - defi & nfts rising to top in ‘21 - macro in ‘19 and rising again in ‘22/‘23 - shift in focus to development & smart contracts - dissociation from the word “currency” as a popular discussion topic
@n4motto
Emre ⚡
2 years
1/ To survive crypto, you need to grok CT. I analyzed 100M tweets to separate the signal from the noise. • Popular topics • Key players • Emerging trends Here are WHO and WHAT matters on CT 👇
21
64
250
0
0
5
@_grace_lily
Grace
3 years
This is awesome
@dethcrypto
☠️ dΞth
3 years
Browsing contracts directly on @etherscan sucks. Browsing multi-file contracts on etherscan sucks even harder! What if you could start an instance of VS Code with the source code of a given address preloaded? Well, Ethereum Code Viewer does exactly that!
49
357
2K
0
0
5
@_grace_lily
Grace
3 years
This is an invaluable resource for anyone wanting to learn web3 analytics 🧙‍♀️🪄Huge thank you to the teachers & sponsors for putting this together!!!
@andrewhong5297
ilemi
3 years
The last week of materials for @OurNetwork__ Learn is up! Shoutout to all the teachers, students, and sponsors for their hard work over the last 30 days - it's been a joy seeing everyone work together! ❤️‍🔥 And a big thank you to @DuneAnalytics for hosting and sponsoring us 🧙
Tweet media one
3
13
92
0
0
5
@_grace_lily
Grace
2 years
Great takeaways!! Every time i think about optimizations I’m 10x more thankful for Dune’s new v2 engine built on Spark🙏🏼 @DuneAnalytics team is the best
@paulapivat
paulx.Ξth
2 years
shout out to @_grace_lily for writing this 🔥 post on PostgreSQL query optimization tricks 🪄 some tips i picked up👇
8
5
18
1
0
5
@_grace_lily
Grace
3 years
DAOs aren’t here to uproot all traditional forms of work, they’re here to solve problems that these current forms of work cannot.
@0xstation
Station Labs ®
3 years
From Station Newstand, by @katiewav and @fkpxls — A New Genre of Work The future of work is coming, and we are all its contributors.
3
14
101
1
0
5
@_grace_lily
Grace
3 years
Completed my first @_buildspace project & I must say it was such a blast!! Great intro to solidity & got me excited to learn and build more :)
Tweet media one
Tweet media two
0
0
5
@_grace_lily
Grace
3 years
Been in a consumption era but time to get into a production mode
0
0
5
@_grace_lily
Grace
1 year
@camiinthisthang no one knows what it means but it’s provocative
0
0
5
@_grace_lily
Grace
3 years
Special thanks to @EvanDeKim @seidtweets @hildobby_ for your help!
0
0
5
@_grace_lily
Grace
3 years
One of the coolest visuals I’ve seen recently - really helps paint a picture of the value of metaverse land in Sandbox. Will be interesting to see how this evolves as more land is bought & the ecosystem grows.
@RobertoTalamas
Roberto Talamas
3 years
Incredible proud of this visual 🥲 Check out the code below 👇
4
6
31
2
0
5
@_grace_lily
Grace
2 years
@serenalihere He’s a 9 but he brought a kiwi
1
0
5
@_grace_lily
Grace
3 years
Woah - the ability to connect nfts & attribute creative inspiration or credit to the original is so obvious it’s mind blowing!! Then add on top the potential to earn passive income on an nft?! Amazing 😆 Can’t wait to see what else @GlassProtocol does with this
@sam_sends
Sam Sends
3 years
okay so im still shiet at vlogging BUT this is a test of a new NFT primitive we've been working on called hyperlink - link NFTs together - remixing & sampling - monetary utility
11
11
155
1
0
4
@_grace_lily
Grace
1 year
🤯☀️🪩⛓
0
0
4
@_grace_lily
Grace
3 years
Does anyone know any tricks / have any good resources for minimizing query times on @DuneAnalytics (or just for PostgresSQL in general)? The cte -> nested query is not enough :(
3
0
4
@_grace_lily
Grace
2 years
@john_c_palmer Directionals (plural of directional but not a real word) essentially what governance does is choose “paths” or “directions” for whatever it governs.. “this dao participates in on-chain directionals” sounds kinda cooler (tho could be shortened maybe)
Tweet media one
0
0
4
@_grace_lily
Grace
3 years
Cont. @parcelHQ - treasury management @hedgeyfinance - treasury liquidity @SnapshotLabs - off chain voting (so free & accessible for DAO members to participate) @guildxyz - token gating for discords @Collab_Land_ - verification of membership @gnosisSafe - MULTI-SIGS 🥳
1
1
4
@_grace_lily
Grace
2 years
@serenalihere Your double jointed elbow popping off
0
0
4
@_grace_lily
Grace
1 year
with all the new infra it’s more important than ever to understand standards. A few more to add to this list: Smart accounts (AA) - erc 4337 Nft ownership of other tokens - erc 6551 (And not knew but critical to understand) Multi-token standard - erc 1155
@andrewhong5297
ilemi
1 year
Once you understand how the data flows, you need to build a strong mental framework for abstracting protocols into easy to remember bits. All patterns you see have developed over time, with many becoming EIP/ERC standards. Protocols like @opensea develop their own SIPs as well.
Tweet media one
2
0
8
0
0
1
@_grace_lily
Grace
3 years
Helpful to understand how to work with Solana NFT data & just how accounts work on Solana in general
@pencilflip
pencilflip 🍄
3 years
Solana NFTs 101 🎓 🌟 Part 1: Account overview 🌟 Solana NFTs are composed of at least three accounts: 1. Token mint account 2. Token account 3. Metadata account 4. [Optional] Edition account Let's review these accounts one-by-one
Tweet media one
11
81
304
0
0
4
@_grace_lily
Grace
2 years
@youfoundanisha Yes why go to therapy when u can punch stuff
1
0
4
@_grace_lily
Grace
3 years
Some projects building towards this future for DAOs: @wonderverse_xyz - project management @utopialabs_ - payment management & accounting @coordinape - decentralized compensation @OrcaProtocol - internal structure & governance @superdao_co - all in one dashboard view of DAO
1
0
3
@_grace_lily
Grace
1 year
this is such a cool initiative
@Optimism
Optimism
1 year
Announcing We ❤️ The Art: a five week contest celebrating onchain creators. 🏆 1,000,000 OP prize pool with up to 184 potential winners 🖼️ 4 distinct submission categories ⏰Submission deadline: December 13th, 23:00 UTC
249
585
2K
0
0
3
@_grace_lily
Grace
3 years
“web2 was the internet of information & web3 is the internet of value” - @sandeepnailwal new favorite definition said yesterday during polygon zk day
@spencernoon
Spencer Noon 🕛
3 years
Literally nobody has a good definition for web3 🤣
121
11
225
0
0
4
@_grace_lily
Grace
2 years
@0xJim Awesome article :) I’d love to see a massive network drawing w bridges as directed edges & chains as nodes (w L2s included) does that exist somewhere?
1
0
4
@_grace_lily
Grace
2 years
sbf: crypto :: jerome: us economy
@TheStalwart
Joe Weisenthal
2 years
From $4.8 billion to $25 million
120
272
2K
1
0
4
@_grace_lily
Grace
1 year
@SabrinaHalper Yes but there’s also various forms of content consumption that come with different contexts. Hyper personalization will never be the only outcome because of your second point, but it may be appealing when reframing why an individual is consuming certain content.
1
1
4
@_grace_lily
Grace
2 years
It’s been now a little over 1 day since @BuildOnBase publicly announced their L2 testnet & there is already more than 25,000 goerli eth bridged from ~65k distinct addresses :o
1
0
4
@_grace_lily
Grace
1 year
Anyone else sometimes catch the astrophysics bug? Just finished How the Universe got it’s Spots & about to read anything by Janna Levin or Lee Smolin
Tweet media one
2
0
4
@_grace_lily
Grace
2 years
Interested to see how accuracy & free speech will play out on this bird app… sometimes accuracy feels impossible in an opinionated world
@elonmusk
Elon Musk
2 years
Twitter needs to become by far the most accurate source of information about the world. That’s our mission.
70K
62K
699K
0
0
4
@_grace_lily
Grace
3 years
@shannonlitweets Might be a good thing - makes room for better heroes
0
0
3
@_grace_lily
Grace
1 year
Look at that power law distribution, I’d expect the % of wallets who’ve only made 1 tx to be high but the drop off from 1-2 tx being ~75% :0
@jphackworth42
J.Hackworth
1 year
Ethereum Address Stats in Past Year -Monthly active addresses ranges from ~4.5M - 7M on Ethereum. -In the past year, more than 26.69 million wallets were created, averaging around 2 million new wallets per month. -The retention rate of new wallets is relatively modest, with
Tweet media one
Tweet media two
Tweet media three
11
9
97
0
0
3
@_grace_lily
Grace
3 years
@andrewhong5297 @MSilb7 “The revolution will not be reported quarterly” would be sick on a sweatshirt
1
0
3
@_grace_lily
Grace
1 year
artwork
@nero_eth
Toni Wahrstätter ⟠
1 year
Stackin' layers on top.
Tweet media one
6
13
92
0
0
2
@_grace_lily
Grace
1 year
ok this could be huge
@0xGhostLogs
Ghost
1 year
If you work with onchain data, you probably rely on the events emitted by smart contracts. GhostLogs lets you ‘rewrite’ deployed contracts to emit new events. You can read from local context, private variables, or call other contracts. All within the contract you’re analyzing
1
0
5
0
1
3
@_grace_lily
Grace
1 year
Summer media sales are my favorite until it’s December & I’m suddenly charged $100 for yearly membership In the meantime, I will read every New Yorker article I can 🙃
1
0
3
@_grace_lily
Grace
3 years
Anyone else find your best ideas come right as you close your eyes? Next thing you know it’s 3 am and you try to close your eyes again & bam, back to square one. No more 5 pm coffee.
0
0
3
@_grace_lily
Grace
2 years
And w the ability to normalize & export you have 0 excuses not to check the chain
@notnotstorm
storm
2 years
for multi-block calls the syntax is one of `ctc calls <addr> <function> --blocks ...` or `ctc calls <addr> <function> --times ...` numerical output will be formatted in a table and a chart 10 / 16
Tweet media one
Tweet media two
2
0
4
0
0
3
@_grace_lily
Grace
2 years
@jackmelnick_ Inspo for Astrid pics
1
0
3
@_grace_lily
Grace
1 year
Queen
@Dot2DotSeurat
Meghan Heintz
1 year
This Barbie just shipped an LLM-powered SQL debugger for @DuneAnalytics .
Tweet media one
4
3
53
0
0
3
@_grace_lily
Grace
2 years
@PuriVaish Ya but their franchise model is fire
1
0
3
@_grace_lily
Grace
3 years
@princessmiaeth Sending you ❤️
0
0
3
@_grace_lily
Grace
3 years
Honestly, I’m impressed. It’s methodical, not jumping to conclusions, and admitting importance to handle legislation with care. Obviously not definitive for what regulation will be, but a wildly optimistic start.
@JackNiewold
Jack Niewold 🫡
3 years
Alright, I did it so you don't have to. Here's a thread on what Biden's executive order sets out for the industry. And what that might might mean for crypto investors like you and me. 🧵
Tweet media one
68
815
3K
0
0
3
@_grace_lily
Grace
2 years
yah this rocks
@oralabs_
ora ▩
2 years
Excited to share that we're launching today! A new search experience for @DuneAnalytics powered by LLMs. Now you can find dashboards by describing what you're looking for - like "how's dex activity on eth?" - rather than relying on keyword matches.
29
110
545
0
0
3
@_grace_lily
Grace
3 years
Fei/Rari kinda sounds like Ferrari
0
0
2
@_grace_lily
Grace
2 years
New data viz just dropped 👀
@DuneAnalytics
Dune
2 years
Recently we've shipped some new product features that you 🧙‍♂️ are going to like....... 1/ Bubble charts Just Select the "Circle Radius" property under the "Result data" section in your Scatter Chart ..... and you'll be bubbling away Here's an example by @_HariB_
Tweet media one
5
7
96
0
0
2
@_grace_lily
Grace
2 years
@0xKofi @optimismFND Well deserved, ty for all your incredible data insights!!! 🫡
1
0
3
@_grace_lily
Grace
3 years
Over the moon to be a part of this cohort and dive deep into learning about data in web3! Thank you @OurNetwork__ & @DuneAnalytics for this incredible opportunity!! To all the dedicated mentors, I can’t wait to learn from you & help foster this community 😃🔝🌕
@andrewhong5297
ilemi
3 years
... @natimuril @0xtsukasa @quasimatt @iamlizendary @defihal @st_beas @0xGrl @JoshNuttall @p_petertherock @Ingwer_s @web3jane Congrats to everyone, we're all really excited to teach you! ❤️ Please dm me your discord id and eth address if you didn't supply it in your form.
2
1
32
1
0
3
@_grace_lily
Grace
3 years
My entire dream last night was a heated discussion on how every wordcel needs a rotator best friend but if someone’s both they either have a million friends or 0.
@tszzl
roon
3 years
dropping my post on the wordcel v rotator history. there's a lotta newcomers so i want to give them context (and also stake my claim). for the love of god don't take this too seriously, and the document is a work in progress
184
217
2K
0
0
3
@_grace_lily
Grace
3 years
Very exciting 🚀
@_token_flow
Token Flow
3 years
After months of working in shadows we are happy to announce the 🚀 Ethereum Data Warehouse (EDW) 🚀 It is a full queryable history of the Ethereum blockchain with everything that you can get from a full node and much, much more 👀
2
9
44
1
0
3
@_grace_lily
Grace
3 years
@sui414 Woah the comparisons add great insight — awesome work!!
0
0
3
@_grace_lily
Grace
3 years
Pretty huge. 6 / 11 of these are EVM compatible and of those, 4 are in the top growth spots for total addresses. Not much competition for Polygon when it comes to #’s & growth though.
@Coin98Analytics
Coin98 Analytics
3 years
Total Addresses on popular blockchain platforms
Tweet media one
128
568
2K
1
0
3
@_grace_lily
Grace
2 years
I feel like people aren’t talking about the novelty of @ratedw3b & the importance of a standardized reputation for machines. Currently they’re focused on staking infra, but imagine if they create standards for relayers, sequencers, etc. Huge.
1
0
3
@_grace_lily
Grace
2 years
When millennials try to market to gen z:
Tweet media one
Tweet media two
1
0
3