balilaicbas

passionated in crypto and macroeconomics
currently learning how to deep dive in data with dune analytics

[storm @notnotstorm]

install: `pip install dune_spice`

upgrade: `pip install -U dune_spice`

docs+repo: https://t.co/1g2Y824f8G

[Yule @yulesa]

Crypto Data Series Part 1: Understanding Data Flow

Crypto data is essential for anyone involved in blockchain. This thread will guide you through the journey of on-chain data, from initial requests to transformed metrics. Let’s dive in!

[balilaicbas @animark_fi]

@FrankResearcher i'm not enough skilled to participate, will solutions be public? in order to learn something

[Fjord Foundry @FjordFoundry]

There has been a lot of talk recently about LBPs on Solana.

Fjord will be the leading LBP platform on Solana.

We will be adding LBP support for Solana with a bag of new features and launch types - Solana LBP season is right around the corner.

[balilaicbas @animark_fi]

@FjordFoundry lfg

[hildobby @hildobby]

2/ Here is the documentation for MATCH_RECOGNIZE, which is perfect for pattern matching. As a heuristics lover, you'll definitely see me use it more 🫡

https://t.co/AeY7FaRc4n

[hildobby @hildobby]

3/ Here is a snippet from the code mentioned above where you can see me using it to find atomic arbitrage loops within transactions 🔎

[hildobby @hildobby]

1/ Efficiently searching for looping patterns in SQL turned out not so evident. Luckily, Kasia from Dune taught me all about the MATCH_RECOGNIZE clause

Nothing crazy here, aside from that she's the one who implemented that clause into Trino 😎

https://t.co/HT3z8IAPti

[hildobby @hildobby]

onchain @basepaint_xyz art in a dune chart, kind of cool

h/t @rob_0x

src: https://t.co/tQeQg2mRKl

[Kofi @0xKofi]

I wrote a guide to building a Discord bot that notifies you of ANY on-chain event in real-time.

Monitor swaps, deposits, transfers, and more on any protocol or wallet that interests you!

[hildobby @hildobby]

SQL cross joins are so underrated, here are 2 ways to get daily NFT traders

[HangukQuant @HangukQuant]

‼️‼️
QT101: Introductory Lectures in Quantitative Trading.
Our new quant course is up! It is currently free-of-charge, but...not open to public. For a chance to get invited, share/rt/dm/whatever/do your thing to make me notice...and fill out form below.
https://t.co/YbMcN8XSho

[ilemi @andrewhong5297]

Ever wondered how liquid staking, block rewards, and MEV work on @solana?

I've done a deep dive of the data with @jito, creating a dashboard and guide to help you understand it.

In them, I cover everything you need to know in this "flow of funds" chart:

[balilaicbas @animark_fi]

@Deebs_DeFi Cnv

[Bitcoin Archive @BitcoinArchive]

JUST IN: El Salvador President Nayib Bukele scared off Wall Street by embracing #Bitcoin. Now El Salvador's bonds are up 70% this year - the best performing USD bonds in Emerging Markets - Bloomberg

🏄🤙🏄‍♀️

[balilaicbas @animark_fi]

I tried to summarized moneyflow from and to dexes related to Worldcoin token, it's not enough old to summarize conclusions, but if you are interested here's the dashboard!
feel free to express any feedback or ideas, DMs are open
https://t.co/sXjgvzbCIn

[ETHKL | ethkl.eth @ETHKL1]

📢 Ethereum Kuala Lumpur 2023

Bringing the international Ethereum community to Malaysia with a conference and hackathon 🇲🇾🥳️

📅 October 13-15, 2023
📍 Sunway University, Malaysia

Supported by @EF_ESP and @etherscan

[Kirk Borne @KirkDBorne]

[Download 211-page PDF] The conceptual #mathematics behind #MachineLearning with example-based learning: https://t.co/QpOLEEaatx
————
#BigData #DataScience #AI #ML #LinearAlgebra #Calculus #Inference #Graphs #DirectedGraphs #DiscreteMathematics #Probability #Statistics