The Convex operational database holds the current state the web application and dashboard read in real time. It never stores raw ticks or historical order books — that is the Parquet/DuckDB lake’s job.
Reference & sources app_users Field Type Description idID Internal user ID auth_user_idstring Authentication provider ID emailstring User email display_namestring Display name rolestring Owner, service statusstring Active, disabled last_login_atdatetime, optional Last login created_atdatetime Creation date updated_atdatetime Last update
chains Field Type Description idID Chain ID codestring ethereum, solana, base namestring Human-readable name chain_typestring EVM, Solana, Sui, other native_symbolstring ETH, SOL, BNB network_identifierstring Technical chain identifier explorer_urlstring, optional Block explorer rpc_statusstring Healthy, degraded, offline is_enabledboolean Collection enabled created_atdatetime Creation date updated_atdatetime Last update
exchanges Field Type Description idID Exchange ID codestring binance, bybit, raydium namestring Exchange name exchange_typestring CEX, DEX ccxt_identifierstring, optional CCXT exchange ID website_urlstring, optional Exchange website api_statusstring Healthy, degraded, offline trading_enabledboolean Real trading allowed paper_trading_enabledboolean Simulation allowed priorityinteger Source priority created_atdatetime Creation date updated_atdatetime Last update
data_sources Field Type Description idID Source ID namestring Source name source_typestring Exchange, API, social, RSS, on-chain providerstring Binance, X, DEX Screener endpoint_referencestring, optional Endpoint or feed identifier collection_methodstring WebSocket, API, polling, RSS statusstring Active, degraded, disabled priorityinteger Source priority reliability_scorenumber Historical reliability last_success_atdatetime, optional Last successful collection last_failure_atdatetime, optional Last failure error_countinteger Consecutive failures configurationobject Non-secret configuration (no secrets) created_atdatetime Creation date updated_atdatetime Last update
Tokens & markets tokens Field Type Description idID Canonical token ID symbolstring Token symbol namestring Token name slugstring Normalized identifier asset_typestring Token, coin, stablecoin, meme primary_chain_idID, optional Main chain project_websitestring, optional Official website project_statusstring Upcoming, active, inactive, abandoned is_meme_coinboolean Meme classification is_verifiedboolean Identity verified first_detected_atdatetime Initial detection created_atdatetime Creation date updated_atdatetime Last update
token_contracts Field Type Description idID Contract ID token_idID Related token chain_idID Blockchain contract_addressstring Token contract address decimalsinteger Token decimals deployment_tx_hashstring, optional Deployment transaction deployer_addressstring, optional Contract deployer deployed_atdatetime, optional Deployment date is_verified_contractboolean Source verification mint_authority_activeboolean, optional Mint authority status freeze_authority_activeboolean, optional Freeze authority status ownership_renouncedboolean, optional Ownership status security_statusstring Unknown, safe, suspicious, blocked created_atdatetime Creation date updated_atdatetime Last update
markets Field Type Description idID Market ID exchange_idID Exchange token_idID Base token quote_symbolstring USDT, USDC, BTC exchange_symbolstring Exchange pair identifier market_typestring Spot, futures, perpetual, DEX pool chain_idID, optional Required for DEX markets pool_addressstring, optional DEX pool address tick_sizedecimal, optional Minimum price movement quantity_stepdecimal, optional Minimum quantity increment minimum_order_valuedecimal, optional Minimum notional trading_statusstring Upcoming, active, suspended, closed listed_atdatetime, optional Market listing date created_atdatetime Creation date updated_atdatetime Last update
listing_events Field Type Description idID Listing event ID token_idID Related token market_idID, optional Related market exchange_idID, optional Related exchange chain_idID, optional Related chain event_typestring Announcement, launch, spot/futures listing statusstring Rumored, confirmed, active, cancelled source_idID Detection source source_event_idstring, optional External source ID announced_atdatetime, optional Announcement time trading_start_atdatetime, optional Trading start time detected_atdatetime System detection time confidencenumber Confidence in event validity raw_referencestring, optional External reference created_atdatetime Creation date updated_atdatetime Last update
Opportunities & scoring opportunities Field Type Description idID Opportunity ID token_idID Related token listing_event_idID, optional Triggering listing market_idID, optional Preferred trading market opportunity_typestring New listing, pre-listing, DEX launch, momentum detected_atdatetime Detection time statusstring Detected, researching, watch, rejected, approved, expired priorityinteger Processing priority current_scorenumber, optional Latest global score current_risk_levelstring Unknown, low, medium, high, critical expires_atdatetime, optional Opportunity validity assigned_strategy_version_idID, optional Strategy under evaluation decisionstring None, watch, simulate, buy, avoid decision_atdatetime, optional Latest decision time decision_summarystring, optional Concise explanation created_atdatetime Creation date updated_atdatetime Last update
opportunity_snapshots Field Type Description idID Snapshot ID opportunity_idID Related opportunity captured_atdatetime Snapshot time pricedecimal, optional Current price market_capdecimal, optional Market capitalization fully_diluted_valuedecimal, optional FDV liquiditydecimal, optional Available liquidity volume_5mdecimal, optional Five-minute volume volume_1hdecimal, optional One-hour volume holder_countinteger, optional Holder count spread_percentagenumber, optional Bid-ask spread estimated_slippagenumber, optional Estimated slippage social_velocitynumber, optional Social activity rate whale_activity_scorenumber, optional Whale activity data_quality_scorenumber Snapshot quality analytics_referencestring, optional Parquet/DuckDB reference created_atdatetime Record creation
feature_definitions Field Type Description idID Feature ID codestring Unique feature code namestring Feature name descriptionstring Feature definition categorystring Price, volume, liquidity, social, on-chain value_typestring Number, boolean, category formula_descriptionstring Human-readable formula implementation_referencestring Code function or module time_windowstring, optional 1m, 5m, 1h minimum_valuenumber, optional Expected minimum maximum_valuenumber, optional Expected maximum missing_value_policystring Ignore, zero, reject, impute versioninteger Feature version statusstring Draft, active, deprecated created_bystring Human or agent created_atdatetime Creation date
signal_snapshots Field Type Description idID Signal snapshot ID opportunity_idID Related opportunity captured_atdatetime Calculation time feature_version_setstring Feature set identifier signal_scorenumber Quantitative score market_regimestring Bull, bear, high volatility, neutral feature_valuesobject Feature code → calculated value triggered_rulesarray Activated deterministic rules failed_rulesarray Rules that rejected the opportunity data_completenessnumber Available data percentage calculation_versionstring Quant engine version analytics_referencestring, optional Historical dataset reference created_atdatetime Record creation
score_snapshots Field Type Description idID Score snapshot ID opportunity_idID Related opportunity signal_snapshot_idID Quantitative evidence strategy_version_idID Strategy used calculated_atdatetime Calculation time signal_scorenumber Quantitative evidence ai_scorenumber Structured AI interpretation risk_scorenumber Risk assessment memory_scorenumber Historical similarity score strategy_scorenumber Strategy confidence execution_scorenumber Execution feasibility final_scorenumber Deterministically calculated score weightsobject Weights applied blocking_reasonsarray Reasons preventing execution recommendationstring Ignore, watch, buy, sell, review confidencenumber Confidence level created_atdatetime Record creation
agent_reports Field Type Description idID Report ID opportunity_idID, optional Related opportunity trade_idID, optional Related trade agent_typestring Research, quant, social, risk workflow_run_idID Related workflow model_providerstring Model provider model_namestring Model used prompt_versionstring Prompt version report_statusstring Complete, partial, failed rationale_summarystring Concise conclusion evidencearray Supporting evidence counterargumentsarray Contrary evidence missing_informationarray Missing data structured_outputobject Validated agent output confidencenumber Agent confidence created_atdatetime Creation date
Strategies & experiments strategies Field Type Description idID Strategy ID codestring Unique strategy code namestring Strategy name descriptionstring Strategy purpose strategy_typestring Listing sniper, momentum, pre-listing statusstring Research, active, paused, archived current_version_idID, optional Current approved version created_atdatetime Creation date updated_atdatetime Last update
strategy_versions Field Type Description idID Strategy version ID strategy_idID Parent strategy versioninteger Version number parent_version_idID, optional Previous version statusstring Draft, testing, paper, production, rejected entry_rulesobject Entry conditions exit_rulesobject Exit conditions score_weightsobject Score configuration feature_requirementsarray Required features risk_policy_idID Risk policy position_sizing_rulesobject Position sizing maximum_holding_durationinteger, optional Seconds supported_exchangesarray Exchange IDs supported_chainsarray Chain IDs created_bystring Human or agent creation_reasonstring Why this version exists approved_byID, optional Human approver approved_atdatetime, optional Approval date created_atdatetime Creation date
experiments Field Type Description idID Experiment ID namestring Experiment name hypothesisstring Hypothesis being tested experiment_typestring Backtest, replay, shadow, paper statusstring Draft, running, complete, rejected strategy_version_idsarray Compared strategies dataset_referencestring Dataset location evaluation_metricsarray Metrics to calculate created_bystring Human or agent created_atdatetime Creation date completed_atdatetime, optional Completion date
experiment_runs Field Type Description idID Run ID experiment_idID Parent experiment strategy_version_idID Strategy tested statusstring Queued, running, complete, failed started_atdatetime Start time completed_atdatetime, optional Completion time parametersobject Run parameters dataset_versionstring Dataset version code_versionstring Git commit or image version total_tradesinteger Number of trades win_ratenumber Winning trade percentage net_returnnumber Total return average_returnnumber Mean trade return profit_factornumber Gross profit / gross loss maximum_drawdownnumber Maximum drawdown average_holding_secondsnumber Average holding duration sharpe_rationumber, optional Risk-adjusted return result_referencestring DuckDB/Parquet result failure_reasonstring, optional Error details created_atdatetime Creation date
Trading trades Field Type Description idID Trade ID modestring Shadow, paper, live opportunity_idID Related opportunity strategy_version_idID Strategy used market_idID Traded market statusstring Planned, open, reducing, closed, cancelled directionstring Long, short opened_atdatetime, optional Position opening closed_atdatetime, optional Position closure entry_pricedecimal, optional Average entry exit_pricedecimal, optional Average exit initial_quantitydecimal Initial quantity remaining_quantitydecimal Remaining quantity initial_notionaldecimal Initial value realized_pnldecimal Realized profit or loss unrealized_pnldecimal Current unrealized PnL fees_paiddecimal Total fees maximum_favorable_excursionnumber Best price movement maximum_adverse_excursionnumber Worst price movement holding_duration_secondsinteger, optional Holding duration entry_reasonstring Entry summary exit_reasonstring, optional Exit summary human_overrideboolean Manual intervention created_atdatetime Creation date updated_atdatetime Last update
positions Field Type Description idID Position ID trade_idID Related trade market_idID Market modestring Paper, live statusstring Open, reducing, closing quantitydecimal Current quantity average_entry_pricedecimal Average entry current_pricedecimal Latest price market_valuedecimal Current market value unrealized_pnldecimal Current PnL unrealized_pnl_percentagenumber Current PnL percentage highest_pricedecimal Highest observed price lowest_pricedecimal Lowest observed price risk_statestring Normal, caution, emergency next_evaluation_atdatetime Next mandatory evaluation last_evaluated_atdatetime Last evaluation created_atdatetime Creation date updated_atdatetime Last update
orders Field Type Description idID Internal order ID trade_idID Related trade position_idID, optional Related position exchange_idID Exchange market_idID Market modestring Paper, live client_order_idstring Idempotency key exchange_order_idstring, optional Exchange order ID sidestring Buy, sell order_typestring Market, limit, stop time_in_forcestring, optional GTC, IOC, FOK requested_quantitydecimal Requested quantity filled_quantitydecimal Filled quantity requested_pricedecimal, optional Requested limit price average_fill_pricedecimal, optional Average execution maximum_slippagenumber Maximum allowed slippage actual_slippagenumber, optional Realized slippage statusstring Created, validated, submitted, partial, filled, rejected, cancelled expires_atdatetime, optional Instruction expiry submitted_atdatetime, optional Submission time completed_atdatetime, optional Completion time rejection_reasonstring, optional Rejection reason created_atdatetime Creation date updated_atdatetime Last update
order_events Field Type Description idID Event ID order_idID Related order event_typestring Validated, submitted, partial fill, filled, cancelled event_atdatetime Event time quantitydecimal, optional Event quantity pricedecimal, optional Event price feesdecimal, optional Event fees exchange_payload_referencestring, optional Secure raw payload reference messagestring, optional Human-readable message created_atdatetime Creation date
Governance & operations human_reviews Field Type Description idID Review ID review_typestring Strategy, trade, risk, configuration target_typestring Opportunity, strategy version, order target_idstring Reviewed entity statusstring Pending, approved, rejected, expired requested_bystring Agent or service request_summarystring Requested decision supporting_dataobject Evidence summary risk_summarystring Risk explanation reviewed_byID, optional Human reviewer decision_notestring, optional Mandatory note requested_atdatetime Request date reviewed_atdatetime, optional Review date expires_atdatetime, optional Review expiry
risk_policies Field Type Description idID Policy ID namestring Policy name versioninteger Policy version statusstring Draft, active, deprecated maximum_trade_valuedecimal Maximum trade value maximum_capital_percentagenumber Maximum capital allocation maximum_daily_lossdecimal Daily loss limit maximum_drawdownnumber Drawdown limit maximum_open_positionsinteger Position limit minimum_liquiditydecimal Required liquidity maximum_slippagenumber Allowed slippage maximum_spreadnumber Allowed spread maximum_holder_concentrationnumber Holder concentration limit blocked_security_flagsarray Forbidden contract flags created_bystring Human or agent approved_byID, optional Human approver approved_atdatetime, optional Approval date created_atdatetime Creation date
risk_events Field Type Description idID Risk event ID risk_typestring Liquidity, contract, drawdown, exchange severitystring Info, warning, high, critical token_idID, optional Related token opportunity_idID, optional Related opportunity trade_idID, optional Related trade position_idID, optional Related position detected_atdatetime Detection time statusstring Open, acknowledged, resolved descriptionstring Incident description evidenceobject Supporting data automatic_actionstring, optional Block, reduce, exit, halt resolved_atdatetime, optional Resolution date created_atdatetime Creation date
workflow_runs Field Type Description idID Workflow run ID workflow_typestring Research, scoring, exit evaluation workflow_versionstring Graph version target_typestring Opportunity, trade, experiment target_idstring Related entity statusstring Queued, running, waiting, complete, failed current_stepstring Current graph node started_atdatetime Start time completed_atdatetime, optional Completion time retry_countinteger Number of retries input_summaryobject Validated input summary output_summaryobject, optional Validated output summary error_summarystring, optional Failure summary created_atdatetime Creation date
model_runs Field Type Description idID Model run ID workflow_run_idID Related workflow agent_typestring Agent role providerstring Model provider modelstring Model name prompt_versionstring Prompt version statusstring Complete, failed, timeout input_tokensinteger Input tokens output_tokensinteger Output tokens estimated_costdecimal Estimated model cost latency_msinteger Request latency structured_output_validboolean Schema validation fallback_usedboolean Fallback provider used created_atdatetime Creation date
system_alerts Field Type Description idID Alert ID categorystring Data, execution, infrastructure, risk severitystring Info, warning, critical titlestring Alert title messagestring Alert description source_servicestring Service producing alert target_typestring, optional Related entity type target_idstring, optional Related entity ID statusstring Open, acknowledged, resolved detected_atdatetime Detection time acknowledged_atdatetime, optional Acknowledgement resolved_atdatetime, optional Resolution
configuration_versions Field Type Description idID Configuration version ID configuration_typestring Collector, scoring, execution, agent versioninteger Version number statusstring Draft, active, deprecated configurationobject Non-secret configuration change_summarystring Change description created_bystring Human or agent approved_byID, optional Human approver approved_atdatetime, optional Approval time created_atdatetime Creation date
Unique constraints token_contracts: chain_id + contract_address. orders: client_order_id (idempotency).
The SQLite memory and Parquet/DuckDB schemas follow on the next pages.
