Skip to content
View 0xlong's full-sized avatar

Block or report 0xlong

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.

Maximum 250 characters. Please don’t include any personal information such as legal names or email addresses. Markdown is supported. 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
0xlong/README.md

Hi πŸ‘‹

πŸ‡¨πŸ‡­ Zurich | πŸ› οΈ Finance and Blockchain Data Engineer & Analyst

Turning raw on-chain chaos into insights. Building reliable blockchain data pipelines.

Currently deep in Across Protocol live data streaming, multi-chain event extraction (Ethereum, Arbitrum, Base, Polygon, Linea, etc.), and medallion architecture ETL.

Python SQL Polars DuckDB dbt BigQuery Claude EVM

πŸš€ Current Focus

  • Real-time & historical analytics for Across Protocol bridge (live streaming + decoded events)
  • Multi-chain event log extraction & decoding (Etherscan, Moralis, custom RPC)
  • Medallion architecture pipelines (bronze β†’ silver β†’ gold) in Python + dbt + DuckDB/Polars
  • AI-assisted SQL generation for blockchain queries
  • Enriching transactions with LLM context (RAG-style)

Featured Projects

Tech Stack & Tools

  • Languages: Python β€’ SQL
  • Data: Polars β€’ DuckDB β€’ PostgreSQL β€’ BigQuery β€’ dbt-core
  • Blockchain: Web3.py β€’ Etherscan API β€’ Moralis β€’ RPC providers
  • Others: Pandas β†’ Polars migration β€’ LLM prompt engineering for SQL β€’ GitHub Actions

Feel free to explore the repos β€” feedback & forks always welcome! πŸš€

Pinned Loading

  1. across_live_stream across_live_stream Public

    Across Analytics Live Data Streaming

    HTML

  2. across-analytics across-analytics Public

    Analytics for Across Bridge protocol for insights

    Python

  3. ilv_holders_bigquery ilv_holders_bigquery Public

  4. auto_sql auto_sql Public

    Ethereum blockchain data extraction with AI generated SQL queries

    Python

  5. blockchain_transactions_context blockchain_transactions_context Public

    Web app for extracting last transaction for a token and enriching transaction context using LLM.

    Python

  6. rag_studio rag_studio Public

    Python