Mats Profile
Mats

@mewwts

3,880
Followers
501
Following
162
Media
4,259
Statuses

co-founder & cto at @DuneAnalytics encryption maximalist

Zug, Switzerland
Joined September 2010
Don't wanna be here? Send us removal request.
@mewwts
Mats
3 years
The journey of a CTO
Tweet media one
16
16
398
@mewwts
Mats
2 years
SQL is an essential web3 skill
33
26
330
@mewwts
Mats
4 months
Clear as day to me that @solana is at least a $200B marketcap ecosystem
24
31
309
@mewwts
Mats
2 years
At @DuneAnalytics we export ~500GB of data a day from @solana so that you don't have to
33
84
294
@mewwts
Mats
3 months
Sharing this knowing it will trigger some of you
Tweet media one
13
11
145
@mewwts
Mats
1 year
Today I'm incredibly excited to announce that Dune is building LLM based tools. First out is query explanations. Live on Dune now! Read more
Tweet media one
13
14
119
@mewwts
Mats
3 years
First ever Dune party in Lisbon on Saturday.
11
3
111
@mewwts
Mats
3 years
Turning 32 today and having the time of my life with the growing crew at @DuneAnalytics <3
10
0
98
@mewwts
Mats
2 years
Today is my birthday. This deep dive is a brilliant account of the wild ride the last 4 years of building @DuneAnalytics has been!
@mariogabriele
Mario Gabriele 🦊💭
2 years
DANG I've been excited for this one! New deep dive on Dune ready for all lovers of spice melange, data analysis, or stories of companies that were basically dead and are now on fire. An inside look at a very quirky unicorn 🔥 🧙‍♂️ 👇
Tweet media one
6
46
305
13
2
94
@mewwts
Mats
2 years
big week for @DuneAnalytics
13
1
90
@mewwts
Mats
4 years
God I love Ethereum
4
7
73
@mewwts
Mats
3 years
do not write "crypto is the future" as your main motivation to join dune
19
0
69
@mewwts
Mats
5 months
select * from beacon.blobs
6
4
65
@mewwts
Mats
3 years
Google makes it easy to find and make sense of information on the internet. @DuneAnalytics makes it easy to find and make sense of information on the blockchain.
5
5
63
@mewwts
Mats
3 months
I have more or less worked on @DuneAnalytics for 6 years to the day.
6
0
63
@mewwts
Mats
3 years
The things we’re working on at @DuneAnalytics are mindblowing
4
1
60
@mewwts
Mats
5 years
I'm convinced @WalletConnect 's rise is the single most important thing that happened to Ethereum in 2019.
3
10
56
@mewwts
Mats
2 years
It's with a heavy heart that I announce that I am now a mac user.
11
1
55
@mewwts
Mats
3 years
Fun fact: the first version of was built on my friend @theoriginalburk 's second hand, ancient, 12" thinkpad that I borrowed because I could not afford a laptop.
4
1
55
@mewwts
Mats
3 months
Two announcements: 1. I am a rust engineer now 2. ping me if you want to try Dune's new multichain token balance api
8
2
54
@mewwts
Mats
2 years
We're looking for a VP of Engineering at @DuneAnalytics . DM me if you or someone you know would be great for the role
3
12
52
@mewwts
Mats
3 months
Might as well leak some alpha
4
3
53
@mewwts
Mats
2 years
Dune is still hiring
2
4
48
@mewwts
Mats
6 months
If you have recently bought a Dune Premium or Enterprise plan (or are looking to do so) I will personally help you succeed in whatever you are trying to do on the platform. DM me here and I will roll up my sleeves with you and make you successful on Dune.
4
3
46
@mewwts
Mats
3 years
The @DuneAnalytics team lunch the other day. gm
Tweet media one
2
2
45
@mewwts
Mats
1 year
You can access 715,889 tables with crypto data on Dune SQL today
8
4
47
@mewwts
Mats
3 years
we're casually ingesting ~ 250 blocks/second. soon™
@DuneAnalytics
Dune
3 years
More soon
Tweet media one
38
67
696
2
3
44
@mewwts
Mats
4 years
Looking for talented developers to join us at @DuneAnalytics and lead the development of our new frontend.
1
14
43
@mewwts
Mats
2 years
What if I told you @DuneAnalytics needs help to scale a data platform running 10M+ custom SQL queries a month?
8
7
41
@mewwts
Mats
4 years
A very warm welcome to team Dune to all of our amazing backers 🙏
@DuneAnalytics
Dune
4 years
📣 We are incredibly excited to announce that we've: Raised a $2M seed round lead by @dragonfly_cap ! Together with top investors @multicoincap , @hashed_official , @coinbase Ventures, @DCGco , @AlamedaResearch , @coingecko , @SemanticVC + great angels 💪 👇
29
37
381
6
0
43
@mewwts
Mats
5 months
👀
Tweet media one
3
3
43
@mewwts
Mats
4 years
Nothing makes me more angry than a dapp without @WalletConnect
6
4
42
@mewwts
Mats
2 years
We, @DuneAnalytics , exist to make this data understandable and accessible, so that builders and participants in this new economy can truly understand what is going on.
@brian_armstrong
Brian Armstrong
2 years
Twitter has broken just about every piece of this FTX story using blockchain analytics, while NYT is writing puff pieces on a criminal. Feels like a turning point for citizen journalism and loss of trust in MSM.
3K
17K
85K
2
12
40
@mewwts
Mats
4 years
Still looking for developers to join @hagaetc and me on an amazing adventure. Remote. CET ± 3. Salary + Equity. Extremely early. Well funded. Join the fun!
0
6
42
@mewwts
Mats
1 year
I feel like OP, Zora and Base are manifesting some sort of bull market akin to defi summer
3
1
41
@mewwts
Mats
4 years
Dune has recently grown from a 2 person team to a 4 person team. We're still looking for more engineers to join us building the future. DMs are open!
4
9
39
@mewwts
Mats
3 years
I think @DuneAnalytics might be the fastest web based analytics tool in the world. If it's not yet, you can be sure it will be.
1
3
38
@mewwts
Mats
3 years
1. hire the best people
4
5
39
@mewwts
Mats
1 year
Did you know that you can embed @DuneAnalytics queries and dashboards into other websites, e.g. on notion?
4
6
36
@mewwts
Mats
4 years
Is this a good time to say that I need help? 😅
@hagaetc
hagaetc.eth
4 years
Talking to investors for our seed round they've usually been pretty blown away when they hear we are just two guys✌️ They are🤯^2 when they learn that I'm not an engineer and that @mewwts build and operate the tech side of @DuneAnalytics alone! Most underrated dev in crypto!??🧐
5
4
82
1
3
36
@mewwts
Mats
1 year
Decent views today
Tweet media one
2
0
37
@mewwts
Mats
4 months
My advice to ambitious Norwegians: move now
8
1
35
@mewwts
Mats
2 years
Did you know that you can be the web3 lead of @DuneAnalytics ?
2
8
35
@mewwts
Mats
9 months
There will be
Tweet media one
1
1
35
@mewwts
Mats
5 years
What's the business case for maintaining Ethereum (2.0) clients? The business case for building one is grants. The business case for maintaining one is...?
11
5
34
@mewwts
Mats
3 years
developers, developers, developers
0
5
33
@mewwts
Mats
3 years
2022 off to a crazy good start at @DuneAnalytics with 6 amazing people joining the team
2
0
32
@mewwts
Mats
4 months
xy=k
1
4
32
@mewwts
Mats
3 years
I'll be mentoring at @ETHLisbon ! Can't wait to see the sun again
1
0
32
@mewwts
Mats
2 months
Every app will have their own chain.
9
3
28
@mewwts
Mats
2 years
Follow me for more SQL maximalism
4
0
32
@mewwts
Mats
2 months
Just use Dune
@0xMert_
mert | helius | hSOL
2 months
want to get started on Solana and make a name for yourself? Do this: - learn sql (pretty easy with chatgpt) - go to dune and flipside; query the chain, make some dashboards - get good at writing - tell stories with data - iterate based on feedback - you now have a network
61
85
904
2
1
29
@mewwts
Mats
1 year
I’m really proud that you can just self serve bring any IDL to @DuneAnalytics and have world class data about your @solana program at your fingertips. No eng work required.
@mewwts
Mats
2 years
At @DuneAnalytics we export ~500GB of data a day from @solana so that you don't have to
33
84
294
2
2
28
@mewwts
Mats
1 year
The best meme I've seen in a long while, courtesy of our engineer @vegardstikbakke which conveniently sums up how we think about engineering at @DuneAnalytics
Tweet media one
2
3
28
@mewwts
Mats
8 months
i'm more of a keyboard person myself cmd+k is here on @DuneAnalytics
3
3
29
@mewwts
Mats
8 months
Our quarterly hackathon at @DuneAnalytics is coming up next week. What should we build? Reply or DM!
29
2
28
@mewwts
Mats
1 year
@0xKofi @marcov_91 Can probably take it one step further. Your query has an error X on line 123 and you just hover and click "fix" and it's magically rewritten?
4
1
28
@mewwts
Mats
3 years
Things I've learned as a founder: - no one has the answers
1
0
29
@mewwts
Mats
3 years
We're growing faster than our team of 4 can handle! If you're a full stack engineer or frontend developer with a sense for design looking for the opportunity of a life time, here it is:
1
6
27
@mewwts
Mats
4 years
So much cool stuff brewing under the surface at @DuneAnalytics these days 🙆‍♂️
3
3
29
@mewwts
Mats
3 years
Love data visualizations? Want more of them in Dune? Now hiring Data Visualization Engineers / Designers for @DuneAnalytics !
1
6
27
@mewwts
Mats
3 years
Dune is hiring for analysts, a marketing manager, infrastructure engineers and software engineers. My DMs are open!
0
3
28
@mewwts
Mats
3 years
The vibes must flow
Tweet media one
0
1
28
@mewwts
Mats
4 months
Quick demo of result filtering on the @DuneAnalytics API. Have you tried it? Would love your feedback
5
5
27
@mewwts
Mats
1 month
q3 okrs are set and we are cooking a good stew at @DuneAnalytics
2
1
19
@mewwts
Mats
4 years
. @hagaetc and I met @tomhschmidt at the very first ETHBerlin in 2018. I was personally awestruck to be speaking with someone from the 0x team... Since then Tom has helped us out countless times and we're now so lucky to have him and @dragonfly_cap onboard as lead investors 🙌
@tomhschmidt
Tom Schmidt >|<
4 years
1/ Today, we're excited to announce @dragonfly_cap 's leading investment in @DuneAnalytics 's seed round! If you work in crypto, you know that Dune has been a total game-changer in how we analyze, share, and talk about on-chain data in the industry.
3
9
124
1
1
28
@mewwts
Mats
1 year
You can now create and edit queries using natural language on Pretty excited about this major milestone on our mission of making crypto data accessible
Announcement time! 🚀Today, we’re excited to roll out 3 new features that make it even easier to use Dune! 1️⃣ ‘Create with Wand' - with Dune Wand 🪄input your question, and the Create Wand will translate your query into SQL for you. ✨ 1/6
13
43
235
0
1
26
@mewwts
Mats
9 months
I AM PUMPED FOR DUNECON NEXT WEEK
5
1
24
@mewwts
Mats
5 months
I am attending denver and are travelling a lot this year, fully open. this is a very important year. people should not forget that the #1 priority is talking to customers, meeting customers and talking more to customers.
@eliasimos
Ξlias Simos
5 months
not attending denver or any travel in coming months, fully heads down. this is a very important year. people should not forget that the #1 priority is shipping, and shipping, and shipping more.
2
2
33
4
0
26
@mewwts
Mats
5 months
According to my query the answer seems to be $763M on Ethereum alone.
Tweet media one
@ChainLinkGod
Zach Rynes | CLG
5 months
I wonder how many billions of dollars have been wasted on ERC20 approve() transactions
29
10
282
2
1
25
@mewwts
Mats
9 months
is this something more folks would like?
@Data_Always
Data Always
9 months
wen dune option to submit PRs to fix people's broken queries?
3
2
21
8
1
25
@mewwts
Mats
11 months
Reminder that my DMs are open and I love hearing your thoughts about @DuneAnalytics
5
2
24
@mewwts
Mats
6 months
The best money a new EVM can spend to make devs happy is on a @paradigm reth implementation
@BogdanHabic
Bogdan Habic
6 months
The best money a new EVM can spend to make devs happy is @DuneAnalytics support.
2
4
47
3
5
21
@mewwts
Mats
3 years
Dune is a web4 company
0
0
24
@mewwts
Mats
4 years
ETHBerlin 2018 was also the time I truly realized what a beast @hagaetc is. Laser focused. Relentless. Shameless. Together I think we've proved we make one hell of a team @DuneAnalytics 🤠
@mewwts
Mats
4 years
. @hagaetc and I met @tomhschmidt at the very first ETHBerlin in 2018. I was personally awestruck to be speaking with someone from the 0x team... Since then Tom has helped us out countless times and we're now so lucky to have him and @dragonfly_cap onboard as lead investors 🙌
1
1
28
1
1
23
@mewwts
Mats
2 years
I've never been more excited to be building in crypto.
3
0
21
@mewwts
Mats
2 years
We've been busy making magic🪄
@DuneAnalytics
Dune
2 years
*Extremely* excited to announce Dune Engine v2 It's a complete overhaul of our entire data architecture, a massive performance upgrade Dune 🧙‍♂️ are about to get a lot more powerful..... 🧵
30
173
832
2
0
23
@mewwts
Mats
1 year
Q2 is shaping up to be perhaps the best quarter of all times at @DuneAnalytics
0
1
22
@mewwts
Mats
1 year
Never underestimate what a small team can do
2
1
23
@mewwts
Mats
4 months
@cybertraffiking allright I'm in. don't rug me
10
4
22
@mewwts
Mats
3 years
Now officially looking for Engineering Managers to join @DuneAnalytics
1
2
21
@mewwts
Mats
3 years
Lisbon LFG
2
0
22
@mewwts
Mats
2 years
In case you missed it the Dune API is coming and we're looking for a PM
1
0
22
@mewwts
Mats
3 years
A decentralized package manager and cdn built on ipfs or arweave seems like it would be the biggest thing ever.
3
0
21
@mewwts
Mats
3 years
If you think crypto is a vertical you are ngmi
0
1
20
@mewwts
Mats
4 years
About to drop something hot
2
2
21
@mewwts
Mats
4 months
I'm speaking alongside @VitalikButerin and many others!
@CoinbaseInsto
Coinbase Institutional 🛡️
4 months
Registration for the Coinbase Machine Learning and Blockchain Research Summit is now open. Join us virtually on Thursday, May 2, 2024 to discover valuable insights and innovations from the sector's foremost voices. Learn more and register now →
2
6
38
2
0
20
@mewwts
Mats
5 years
Which wallet will be the first to abstract away into a toggle while sending?
@AlexMasmej
Alex Masmej
5 years
Crypto mixers are basically the same privacy add-on as VPNs for web browsing Just like VPNs, if it’s not built-in wallets like @opera has a built-in VPN, it won’t gain much traction
2
1
9
1
4
20
@mewwts
Mats
4 years
So good to be back home
Tweet media one
1
0
21
@mewwts
Mats
3 years
Analyze it all on @DuneAnalytics
@MihailoBjelic
Mihailo Bjelic
3 years
It's official, @binance is integrated with @0xPolygon and supports $MATIC deposits/withdrawals! 🤯 Polygon is now the only platform that offers seamless onboarding/transition from the world's biggest CEX to a robust Web3 ecosystem with cheap and near-instant transactions. 🔥🦄💫
34
106
669
0
3
20
@mewwts
Mats
4 years
We're looking for a contractor to help us with a short (1-2 week) engineering project at Dune involving the GitHub API, golang and Kubernetes jobs. DM me if you're interested!
1
6
20
@mewwts
Mats
4 years
Just a reminder that if you love Ethereum, and also like programming, I'd love to hear from and work with you
1
7
20
@mewwts
Mats
2 months
Did you know that Dune has a token balance API now? It's also free while in beta. Check it out
1
2
20
@mewwts
Mats
3 years
Benchmarked some long running queries using the new @citusdata columnar storage for older partitions on our @PostgreSQL setup. Perf gains across almost all the board, with a few exceptions where indexes really shines. Compression ratio of ~ 4.
Tweet media one
0
4
19
@mewwts
Mats
2 years
and what a day it was
0
0
20