Skip to content

Instantly share code, notes, and snippets.

View 0xBoxer's full-sized avatar

0xBoxer

29 followers · 0 following
View GitHub Profile
@0xBoxer
0xBoxer / tx-hash-wallet-mapping-guide.md
Created April 30, 2026 09:28
Dune guide: mapping transaction hashes to wallets

Dune guide: mapping transaction hashes to wallets

Goal

Input:

  • blockchain
  • tx_hash

Output:

@0xBoxer
0xBoxer / kalshi_hourly_price_pipeline_d4ba71db.plan.md
Created March 4, 2026 11:49
Kalshi Hourly Price Pipeline to Dune — plan & architecture

name: Kalshi hourly price pipeline overview: Build a Python pipeline that fetches hourly candlestick data from the Kalshi API for all markets (live + historical), transforms it into a flat table, and uploads it to Dune as a queryable dataset — mirroring the pattern of polymarket_polygon.market_prices_hourly. todos:

  • id: scaffold content: Create project scaffold (pyproject.toml, .env template, directory structure) status: pending
  • id: fetch-markets content: Implement market universe fetcher (live + historical markets with metadata) status: pending
@0xBoxer
0xBoxer / documentation.md
Created November 10, 2025 19:42
capital_actions description

Polymarket Polygon User Capital Actions

Overview

This table tracks all capital movements (deposits, withdrawals, transfers, and conversions) for Polymarket users on Polygon. It provides a comprehensive view of USDC and USDC.e flows in and out of user wallets, enabling analysis of user funding patterns, capital allocation, and liquidity movements on the Polymarket prediction market platform.

Table Information

  • Schema: polymarket_polygon
  • Table Name: users_capital_actions