01Cross-chain ingestion and ETL
Pull blocks, transactions, logs and events from node RPCs, indexers and chain APIs into a common schema in BigQuery. Reorg handling, backfills, checkpointing and per-chain rate limits are part of the pipeline rather than an afterthought. Work has covered Ethereum, Bitcoin, Immutable X, Immutable zkEVM, XDC, WEMIX, Tezos and Cardano.
02Decoding transactions, logs and events
Apply contract ABIs with Web3.py to turn opaque input data and topics into named events with typed arguments: transfers, mints, burns, stakes, swaps. That includes proxy contracts, non-standard implementations and the contracts whose interface has to be reconstructed before anything can be read.
03Token identification and valuation
Maintain token registries and price reference data, and value movements at the relevant block timestamp in the reporting currency, handling decimals, fee proration and FX explicitly. Widening mapping coverage is ordinary, high-value work: on past engagements it moved from 35 tokens to 42 and beyond, pulling material volume out of the unknown bucket.
04Transaction categorisation
Classify activity into the categories the business reports on — transfer, trade, fee, reward, bridge, internal movement — using contract, method, counterparty and pattern rules that are written down and reviewable rather than buried inside a query.
05Staking-reward reconciliation
Reward ledgers per validator, delegator or wallet, reconciled against on-chain distributions and internal records, with period totals, accrual timing and a discrepancy report. On past engagements a ledger of this kind has removed more than 70% of a manual reconciliation cycle.
06Wallet analytics and attribution
Wallet-level histories, balances over time, cohort and retention views, and attribution of addresses to known entities or internal accounts, with the labelling maintained as data rather than hardcoded into reports.
07Compliance and AML investigative datasets
Queryable datasets for investigation and monitoring: counterparty exposure, flows through addresses of interest, thresholds and time-windowed aggregates. They support an analyst’s judgement and an auditor’s questions; they do not replace either.
08Immutable base data with an audit trail
Base tables hold exactly what the chain reported and are never edited. Manual corrections, whitelists and overrides live in separate layers applied when the reporting view is built, each carrying an author, a timestamp and a reason, so a figure can still be explained months later.