Skip to content
View SleepAqua's full-sized avatar
  • Amsterdam, Netherlands

Block or report SleepAqua

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Content in all repositories owned by your account will be closed.
Maximum 250 characters. Please don’t include any personal information such as legal names or email addresses. This note will only be visible to you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
SleepAqua/README.md

Louis Tian

Data engineer. Nearly three years building the market-data platform behind a Shanghai quant asset manager, then independent consulting for private quant clients. Moving to the Netherlands and looking for sponsored data engineering work.

Most of what I write is about the unglamorous half of data: getting it in, knowing it is correct, and knowing when it is late. A wrong number before the open is a trading loss, not a bad chart.

Selected work

Repo What it is
data-quality-gate Stops a daily pipeline when a symbol goes stale, a day disappears, a column is renamed or rows duplicate. Exits non-zero so CI gates on it.
tick-rollup Streams a trade CSV into OHLCV bars, with hard session boundaries and two documented late-tick modes. Measured at ~260k ticks/s on this machine.
rag_im Snapshots government visa pages, diffs them section by section, answers questions with citations. Local-first, no API key.
mahjong-mc Plays millions of Japanese Mahjong hands to compare strategies. Pure Python, no dependencies, 114 tests.
GapFiller Monte Carlo Yahtzee: hundreds of thousands of games per strategy, reported with standard errors instead of opinions.
PacePulse Offline-first HIIT and strength timer, shipped as a web app and an Android wrapper.

What I work with

Python, SQL and Bash; Spark, PySpark, Hive and HDFS; Airflow for orchestration; pandas and NumPy for analysis; dbt (certified, and putting it to work); LlamaIndex and ChromaDB for retrieval work. HDF5 and Parquet are where the data actually lives.

Elsewhere

Email: louis.xiaxu.tian@gmail.com · LinkedIn

Pinned Loading

  1. data-quality-gate data-quality-gate Public

    A gate that stops a daily data pipeline when a symbol goes stale, a day is missing, a column is renamed or rows duplicate. Stdlib Python, exits non-zero for CI.

    Python

  2. GapFiller GapFiller Public

    Monte Carlo Yahtzee: play hundreds of thousands of games to compare strategies, with standard errors instead of opinions.

    Python

  3. mahjong-mc mahjong-mc Public

    Monte Carlo Mahjong (Japanese rules): play millions of hands to test a strategy, in pure Python with no dependencies.

    Python

  4. PacePulse PacePulse Public

    Offline-first HIIT and strength timer: web app plus an Android wrapper, workout history stored on the device.

    TypeScript

  5. tick-rollup tick-rollup Public

    Streaming tick CSV to OHLCV bars with hard session boundaries and late-tick handling, in plain Python at 260k ticks per second.

    Python

  6. LouisTools LouisTools Public

    A very useful tool-set for data/operation/testing engineers

    Python 1