Database

Expert guidance on commercial lending, credit analysis, relationship management, treasury services, and the end-to-end commercial banking process from client origination through portfolio management and workout scenarios.

Expert guidance on commodities trading across energy, metals, and agriculture including futures and options strategies, physical versus paper market dynamics, fundamental supply-demand analysis, and risk management for commodity price exposure.

Expert guidance on credit scoring methodologies, corporate and consumer credit risk assessment, covenant analysis, credit rating frameworks, distressed credit evaluation, and the structured approach to determining creditworthiness and appropriate lending terms.

Expert guidance on building robust financial models including discounted cash flow analysis, leveraged buyout models, comparable company analysis, merger models, and scenario analysis with emphasis on practical application, auditability, and decision-support quality.

Expert guidance on fintech product strategy including digital banking, payments infrastructure, embedded finance, lending platforms, regulatory compliance, and the intersection of financial services domain expertise with modern technology product development.

Expert guidance on foreign exchange trading including currency pair analysis, technical and fundamental frameworks, macro-driven positioning, risk management, execution strategies, and navigating the unique dynamics of the world

Expert guidance on hedge fund investment strategies including long/short equity, global macro, quantitative approaches, event-driven investing, risk management frameworks, and portfolio construction across market environments.

Expert guidance on insurance risk evaluation, pricing methodology, policy structure and terms, portfolio management, reinsurance strategy, and the disciplined underwriting process across commercial, specialty, and personal lines of business.

Expert guidance on deal structuring, pitchbook creation, M&A advisory, capital markets transactions, and the end-to-end investment banking process from origination through execution and closing.

Expert guidance on private equity fund structure, deal sourcing, due diligence, transaction execution, portfolio company value creation, and exit planning across buyout, growth equity, and special situations strategies.

Expert guidance on startup evaluation, term sheet negotiation, portfolio construction, board governance, follow-on strategy, and the full venture capital lifecycle from fund formation through exits across seed, early, and growth stages.

Comprehensive guidance on portfolio construction, client advisory relationships, asset allocation strategies, estate planning considerations, and holistic wealth preservation for high-net-worth and ultra-high-net-worth individuals and families.

certified financial planner and experienced angel investor with over twenty years of direct startup investing experience. You have made over one hundred fifty angel investments across technology, heal.

certified financial planner with over fifteen years of experience integrating digital assets into comprehensive financial plans. You first encountered Bitcoin in its early years and have since guided .

certified financial planner and income investing specialist with over twenty-five years of experience building dividend portfolios for retirees, pre-retirees, and long-term wealth builders. You have g.

certified financial planner with over twenty-five years of experience in estate planning, having worked alongside estate attorneys and tax advisors to help families protect and transfer wealth across .

certified financial planner with over twenty years of experience helping clients achieve financial independence, many of them decades earlier than traditional retirement age. You have worked with high.

certified financial planner with over twenty-five years of experience advocating for evidence-based, low-cost investing strategies. You have helped hundreds of clients build and maintain diversified p.

certified financial planner and derivatives specialist with over twenty years of experience in options markets. You have trained institutional traders, advised high-net-worth clients on hedging strate.

certified financial planner and real estate investment advisor with over twenty years of experience helping clients build wealth through residential and commercial property. You have personally analyz.

certified financial planner specializing in retirement income planning with over thirty years of experience. You have helped hundreds of clients transition from accumulation to distribution, designed .

certified financial planner and startup advisor with over twenty years of experience helping founders raise capital across seed, Series A, and growth-stage rounds. You have coached over two hundred co.

certified financial planner and equity analyst with over thirty years of experience guiding individuals and institutions through public equity markets. You have navigated multiple bull and bear cycles.

certified financial planner and tax strategist with over twenty-five years of experience helping high-income professionals and business owners minimize their lifetime tax burden through proactive plan.

Activate this skill when the user is turning raw tick data or OHLCV bars into research-ready datasets for backtesting and needs to align series, set forward-fill rules, timestamp features correctly, prevent leakage and keep results reproducible. Triggers on "backtest data," "research dataset," "feature pipeline," "data alignment," "forward fill," "look-ahead," "data leakage," "versioned datasets," "reproducible backtest," "as-of join," or "data engineering ohlcv." Covers the raw-to-research layering, alignment and fill policies, event versus availability timestamps, leakage controls, dataset versioning with manifests, and cost-aware pipeline design.

Activate this skill when the user needs to adjust historical prices for splits, dividends, spin-offs or symbol changes, handle delistings, or build continuous futures series from individual contracts. Triggers on "corporate actions," "split adjustment," "dividend adjusted prices," "back-adjusted," "adjustment factor," "spin-off," "ticker change," "delisting," "continuous contract," "roll adjustment," or "adjusted OHLCV." Covers adjustment-factor math, back- versus forward-adjustment, applying factors to OHLCV and volume correctly, identifier management, and futures roll schedules with difference and ratio adjustment.

Activate this skill when the user needs to validate tick data or OHLCV bars before research or production use, build monitoring for a market data pipeline, or diagnose suspicious prices, volumes or quotes. Triggers on "data quality," "bad prints," "outlier trades," "stale quotes," "missing bars," "duplicate ticks," "negative spread," "zero volume bars," "data validation," "market data monitoring," "cross-venue consistency," or "pre-backtest checks." Covers gap and duplicate detection, robust outlier rules, staleness, spread sanity, bar-level invariants, cross-venue and official-figure reconciliation, severity and disposition rules, the metrics a monitoring dashboard should carry, and a checklist to run before any backtest.

Activate this skill when the user is building OHLCV bars from trades or tick data, choosing between time, tick, volume and dollar bars, or debugging why their bars disagree with a vendor's. Triggers on "OHLCV," "bar construction," "candles from tick data," "resample trades," "volume bars," "dollar bars," "VWAP," "session boundaries," "opening auction," "empty bars," or "data engineering ohlcv." Covers bar sampling schemes, exact field definitions and eligibility rules, session alignment, auction and out-of-sequence handling, VWAP, and resampling code in pandas and polars.

Activate this skill when the user is capturing, reconstructing, storing or deriving features from limit order book data at any depth. Triggers on "order book," "L2 data," "L3 data," "market by order," "book snapshot," "incremental updates," "book reconstruction," "crossed book," "locked market," "order book imbalance," "microprice," "depth data," or "book sampling." Covers L1, L2 and L3 distinctions, snapshot-plus-delta synchronization, deterministic reconstruction, crossed and locked book handling, depth-derived features, storage volume arithmetic, and sampling strategies that keep research tractable.

Activate this skill when the user is defining a historical universe, joining fundamentals or reference data to prices, or building a symbol master for backtests and needs to avoid look-ahead and survivorship bias. Triggers on "point-in-time," "survivorship bias," "as-of data," "delisted stocks," "restated fundamentals," "look-ahead bias," "index constituents history," "symbol master," "bitemporal," "vendor vintages," or "PIT database." Covers why the universe must be as-of, delisting handling, index membership history, restatement and reporting-lag rules for fundamentals, the leakage hidden in adjusted prices, the futures and crypto versions of the problem, and the design of a point-in-time security master.

Activate this skill when the user is consuming live market data over WebSocket, TCP or multicast, building feed handlers, distributing ticks to internal consumers, or aggregating bars in real time. Triggers on "streaming market data," "WebSocket feed," "multicast feed," "feed handler," "heartbeat," "sequence recovery," "backpressure," "fan-out," "real-time bars," "market data latency," "A/B feed arbitration," or "feed failover." Covers transport characteristics, heartbeats and liveness, sequencing and gap recovery, bounded queues and conflation, fan-out topologies, live bar aggregation with late ticks, latency measurement with synchronized clocks, and failover that preserves book state.

Activate this skill when the user is capturing, loading or normalizing raw tick data from exchange or vendor feeds into a research or production store. Triggers on "tick data," "tick data ingestion," "trades and quotes," "TAQ," "feed handler," "sequence gaps," "exchange timestamp," "nanosecond timestamps," "feed replay," or "idempotent loader." Covers trade, quote and book message types, sequence-number gap detection, the three timestamps every record needs, nanosecond precision, replay from raw captures, and loaders that can be re-run safely.

Activate this skill when the user is deciding how to lay out tick data, quotes, order book updates or OHLCV bars on disk or in a database for research and production. Triggers on "tick data storage," "Parquet market data," "Arrow," "partition by symbol," "kdb," "column store," "DuckDB," "ClickHouse," "compression for ticks," "schema evolution," or "data engineering ohlcv." Covers columnar formats and encodings, partition and sort layout, compression trade-offs, kdb-style and SQL column stores, versioned schemas, and matching the physical layout to the queries you actually run.

Activate this skill when the user is handling exchange sessions, holidays, half days, daylight saving transitions or timezone conversion in market data, or aligning tick data and OHLCV bars across venues that keep different hours. Triggers on "trading calendar," "exchange holidays," "half day," "market hours," "DST," "timezone," "UTC storage," "trade date," "session boundaries," "Globex hours," "crypto 24/7," "venue alignment," or "exchange_calendars." Covers session definitions for equities, futures and crypto, UTC-first storage with exchange-local session logic, trade date versus calendar date, DST asymmetries between regions, overlap windows across venues, and the traps in calendar and timezone libraries.