# Past Writings

*Collected Works*

By [Defi, Data, Degen](https://paragraph.com/@evandekim) · 2024-05-12

defi, mev, data engineering, data science, web3, crypto, python, solana, sui

---

[Github](https://github.com/Evan-Kim2028) | [Twitter](https://x.com/EvanDeKim) | [Dune](https://dune.com/evandekim) | [Sui LST Dash on Sentio](https://app.sentio.xyz/evandekim/sui-lst/dashboards/6fO9DNrQ)

  

Latest
------

*   [On-chain Atomic Gaussian Math](https://paragraph.com/editor/31o6StqKYWR7B5fGsWYv) (December 2025)
    
*   [Building an Agentic Native MCP for Data Science](https://paragraph.com/editor/IZ7hruMsuonAs8DFhJXt) (October 2025)
    

  

Highlights
----------

*   [Sui NFT Analytics](https://paragraph.xyz/@evandekim/sui-nft-collection-analytics) (February 2025)
    

*   [Economics of Sui Shared Liquidity Pool Objects](https://paragraph.xyz/@evandekim/economics-of-sui-shared-liquidity-pool-objects) (December 2024)
    

*   [Data Observability with Sentio Pipelines](https://paragraph.xyz/@evandekim/data-observability-with-sentio-pipelines) (December 2024)
    

*   [**Tackling Blob Fee Slippage with Preconfirmations**](https://mirror.xyz/preconf.eth/xX2wu_3DC76qVYy1GHi1WVeOV2cXDF_rtDh7GlD6ZEU) (September 2024)
    
*   [Slot Inclusion Rates and Blob Market Combinatorics](https://ethresear.ch/t/slot-inclusion-rates-and-blob-market-combinatorics/19817) (June 2024)
    
*   [Analyzing Blob Inclusion Rates and Market Strategies](https://mirror.xyz/preconf.eth/6lZYL62DR9U14KC7wCC4RHReVdHcBeMy5PKeHVbPq5k) (April 2024)
    

*   [Trading in the Dark: Measuring Reordering Slippage in MEV](https://frontier.tech/measuring-reordering-slippage-in-mev) (January 2024)
    
*   [Feedlot: trading with safe, low latency price oracles](https://github.com/mohammed7s/Feedlot/blob/main/report/build/report.pdf) (April 2023)
    
*   [Using Topological Data Analysis to Identify Distinct MEV Behavior](https://github.com/Evan-Kim2028/tda_ohm_analysis/blob/main/Using_Topological_Data_Analysis_to_Identify_MEV_Behavior.pdf) (November 2022)
    

Data
----

*   [Economic Implications of a Competitive Blob Market](https://ethresear.ch/t/economic-implications-of-a-competitive-blob-market/20931) (November 2024)
    

*   [Clustering Analysis on Zeta <> Pyth Transaction Logs](https://paragraph.xyz/@evandekim/clustering-analysis-on-zeta-lessgreater-pyth-transaction-logs) (August 2024)
    

*   [Conquering Solana Data Analytics Part 1 - Tooling](https://paragraph.xyz/@evandekim/conquering-solana-data-analytics-part-1-tooling) (August 2024)
    
*   [**Economic Costs of Failed Transactions on Solana**](https://paragraph.xyz/@evandekim/economic-costs-of-failed-transactions-on-solana) (August 2024)
    
*   [Slot Inclusion Rates and Blob Market Combinatorics](https://ethresear.ch/t/slot-inclusion-rates-and-blob-market-combinatorics/19817) (June 2024)
    

*   [Streaming Embedded OLAP Data Pipeline with LanceDB + DuckDB in Python](https://paragraph.xyz/@evandekim/streaming-embedded-olap-data-pipeline-with-lancedb-duckdb-in-python) (May 2024)
    

*   [Fetching Uniswap Historical Swap Data With Python and Subgrounds](https://mirror.xyz/0x70b0451b1C047ed750C4661B4624B67FD94A31c5/-gq99zeoHqQxc1ViSJV4135u2ZgaH8v6q_WacrPECSA) (November 2023)
    
*   [Free Historical Blockchain Extraction with Cryo + Merkle Reth Nodes](https://mirror.xyz/0x70b0451b1C047ed750C4661B4624B67FD94A31c5/86O5gGvnrm3q_J2ZCAkZZL0o9ernHSGVMvoX564hzlA) (November 2023)
    
*   [Streamline Subgraph Pipeline Creation With DataStreams](https://mirror.xyz/0x70b0451b1C047ed750C4661B4624B67FD94A31c5/P-ZBadPVJLENgsLKoxgA9nPGchVARK9QoD0EfaNQeh8) (January 2023)
    

**MEV**
-------

*   [**Tackling Blob Fee Slippage with Preconfirmations**](https://mirror.xyz/preconf.eth/xX2wu_3DC76qVYy1GHi1WVeOV2cXDF_rtDh7GlD6ZEU) (September 2024)
    

*   [Calculate Jito Tips in Solana](https://paragraph.xyz/@evandekim/setup-a-solana-etl-pipeline-and-calculate-jito-tips) (July 2024)
    

*   [Analyzing Blob Inclusion Rates and Market Strategies](https://mirror.xyz/preconf.eth/6lZYL62DR9U14KC7wCC4RHReVdHcBeMy5PKeHVbPq5k) (April 2024)
    

*   [Censorship, Latency, and Preconfirmations in the Blob Market](https://mirror.xyz/preconf.eth/cxUO8pPBfqnqAlzFUzoEUa6sgnr68DRmsNhBWPb2u-c) (February 2024)
    

*   [Trading in the Dark: Measuring Reordering Slippage in MEV](https://frontier.tech/measuring-reordering-slippage-in-mev) (January 2024)
    
*   [Cross-Chain NFT Marketplace MEV Strategy with Artemis: A Technical Commentary](https://mirror.xyz/0x70b0451b1C047ed750C4661B4624B67FD94A31c5/8yqC4SPzhEqeG5ZyNNIWtlP6oQxi5Nr1oO7wVrF3_w0) (May 2023)
    

*   [Using Topological Data Analysis to Identify Distinct MEV Behavior](https://mirror.xyz/evandekim.eth/Xb8XRL7nD-ORyeX76nrG6eOiTYOMTmKfOxEfMEpBae0) (blog, November 2022)
    
*   [Using Topological Data Analysis to Identify Distinct MEV Behavior](https://github.com/Evan-Kim2028/tda_ohm_analysis/blob/main/Using_Topological_Data_Analysis_to_Identify_MEV_Behavior.pdf) (paper, November 2022)
    
*   [MEV Arbitrage on Olympus](https://mirror.xyz/evandekim.eth/Mc11J16dVP7Ervk1r2Sx_wkJ7dzb7Ce60Y2EpbRBlHY) (October 2022)
    

**DeFi**
--------

*   [Feedlot: trading with safe, low latency price oracles](https://github.com/mohammed7s/Feedlot/blob/main/report/build/report.pdf) (April 2023)
    
*   [Applying Balancer’s Managed Pool Controllers to Manage Liquidity in Bonding Curves](https://mirror.xyz/evandekim.eth/YPI5RbKi9CyIEgpnrFtmnyACHMtTHM9FBsMJFjdwLXI) (December 2022)
    
*   [Pari-Mutuel Market Design](https://mirror.xyz/evandekim.eth/0KZf_XYMCfjgy7fng4nJL_2JOH2k1UOgb_deXoIQg_A) (August 2022)
    
*   [The AMM Design Trilemma](https://mirror.xyz/evandekim.eth/SVp-wan8A0VtZVff8YgUKTQAhJlpKa4CPXNVKqW_d5o) (August 2022)
    
*   [RMM-01 Concentrated Liquidity Analysis](https://primitive.mirror.xyz/wXPmtmaO4yvhyra36XKqwX36gM0qmR0X3YNTOBZB5Kk) (July 2022)
    
*   [Replicating Market Makers and Super Hedging Portfolios](https://mirror.xyz/evandekim.eth/aUULTZFwhJ9XsOZ6XIbAYl1iaSncDKpDwKazCemJlI8) (May 2022)
    
*   [Liquidity Management and Supply Issuance Optimization Model](https://mirror.xyz/evandekim.eth/Q2tdbKQjTyrSixC4YaElqr83zJE0gUIOIzltxFa-VIQ) (April 2022)
    
*   [Quantitative Modeling on Rebase Tokens (Ohm)](https://mirror.xyz/evandekim.eth/_6voXoEEfJqy58fNAhQjDWo6K3PvDeCxubfFBC6oAes) (January 2022)
    
*   [Crypto Speculation Index (CSI)](https://mirror.xyz/evandekim.eth/ujJJbOtc25RAGJMewlPahBUcDyozOJaBF7qznEET3ik) (January 2022)
    
*   [Why Decentralized Algorithmic Stablecoins Win the Stablecoin Wars (UST, BEAN)](https://mirror.xyz/evandekim.eth/pExa2KveQ5B3WWSyWEW_iVKi2Ka3oqeRdfkjYBxBIhE) (December 2021)
    

*   [Applications of Graph Theory on the Structure of a DAO](https://mirror.xyz/evandekim.eth/fuznGoiFzMmDk6iMdunDejkPiuRbJ5yqDRzg7-q2IYA) (November 2021)
    

**Math**
--------

*   [Quadratic Reciprocity of Lucas Polynomials](https://github.com/Evan-Kim2028/math-studies/blob/main/quadratic_reciprocity_lucas_polynomials.pdf) (December 2021)
    
*   [Groebner Basis and Automated Geometric Theorem Solver](https://github.com/Evan-Kim2028/math-studies/blob/main/MAT402_Grobner_Basis_Presentation_4.22.21.nb) (Mathematica, April 2021)
    
*   [Measure Theory - Lebesgue Integration](https://github.com/Evan-Kim2028/math-studies/blob/main/independent_study_measure_theory_lebesgue_integration_notes.pdf) (May 2020)
    
*   [Abstract Algebra - Groups, Kernels, Normal Subgroups](https://github.com/Evan-Kim2028/math-studies/blob/main/independent_study_abstract_algebra_notes.pdf) (November 2020)
    
*   [Perceptron Neural Networks](https://github.com/Evan-Kim2028/math-studies/blob/main/independent_study_perceptron_neural_network_notes.pdf) (May 2020)

---

*Originally published on [Defi, Data, Degen](https://paragraph.com/@evandekim/past-writings)*
