Lars Bakke Krogvig

Data Engineer and co-founder of @nansen_ai. Tables and views are my own.

[Eric Pan @pandelic]

hi charlie brown it’s bandcamp friday !! 3-CD boxsets ship worldwide // christmas cutoff is SOON // or choose from a delectable catalog 🍱
→ https://t.co/W1aL909A5n

[Lars Bakke Krogvig @l4rsbk]

@benhylak @arek10000 I've not had much luck with o1 and ClickHouse. Do you have any tricks you can share (to the narrow audience)?

[Lars Bakke Krogvig @l4rsbk]

@dataalways @ASvanevik @base Giving the other chains the same treatment next week!

[Lars Bakke Krogvig @l4rsbk]

@dataalways @ASvanevik @base Fixed for Base

[Lars Bakke Krogvig @l4rsbk]

@fiege_max @adcv_ As in like a breakfast burrito?

[Lars Bakke Krogvig @l4rsbk]

@ASvanevik Nice Vulfpeck reference

[Lars Bakke Krogvig @l4rsbk]

Credit where credit is due

[Lars Bakke Krogvig @l4rsbk]

@adcv_ The yield is not a lie

[Lars Bakke Krogvig @l4rsbk]

It's come to my attention that I'm being impersonated on-chain. I have no affiliation with larsbakkekrogvig.eth. Stay safe folks

[Lars Bakke Krogvig @l4rsbk]

@bankless @balajis It's a lot easier to follow with sound on

[Lars Bakke Krogvig @l4rsbk]

@VitalikButerin Alfalfa leek

[Alex Svanevik 🐧 @ASvanevik]

first time all @nansen_ai co-founders meet in person

[Lars Bakke Krogvig @l4rsbk]

@jacobcollier With the merge out of the way and the tech hopefully proven to be sustainable, would you consider taking another look at NFTs? I'd be one of the first in line if you did make anything.

[Lars Bakke Krogvig @l4rsbk]

@nansen_intern You want a dumb money label? I can get you a dumb money label. Believe me, there are ways, you don't wanna know about it.

[Nansen 🧭 @nansen_ai]

Introducing Nansen Portfolio ✨

With coverage of 40+ chains and 470+ protocols, you can track all your DeFi holdings in a single dashboard.

Create unlimited portfolios with wallet bundles.

Free to use by anyone, anywhere.

Unlock your Portfolio now: https://t.co/WlQru5DZwv

[Lars Bakke Krogvig @l4rsbk]

@mbuenn @kelsos86 @gakonst Yes.

[Lars Bakke Krogvig @l4rsbk]

@troels_a My pleasure!

[Lars Bakke Krogvig @l4rsbk]

Some clarification: Looking for one row per address involved in wash trading.

You can also add on more metrics like the number of different Meebits involved if you want to!

[Lars Bakke Krogvig @l4rsbk]

Hey crypto curious Data Engineers, up for a little query challenge?

Let's investigate NFT wash trading using public blockchain data in BigQuery. Challenge below👇

DM me your SQL + email if you want an interview for a position at @nansen_ai!

[Lars Bakke Krogvig @l4rsbk]

A few hints: The Meebits address is 0x7bd29408f11d2bfc23c34f18275bbf23bb716bc7, and a wash trader could be someone sending and receiving the same NFT more than twice within the same day.

Get started with BigQuery here: https://t.co/zO7715VncE

Have fun!

[Lars Bakke Krogvig @l4rsbk]

@SoybeanCrypto Up to you! But twice or more is probably ok.