Every data table that feeds the alpha pipeline
One row per Postgres table the family registry depends on, with its origin, ingest cadence, and the families that consume it. Generated from alpha_family_registry.required_tables; re-exported whenever the registry changes.
Price & Volume
OHLCV bars, sector ETFs, VIX term structure, and the microstructure tape that anchors every TA family.
daily_prices332 familiesDaily OHLCV bars for ~11k US tickers, 2010–present. Adjusted closes.
/api/cron/daily-pricesDaily 3pm PToptions_chain_daily2 familiesOption chain snapshots. Successor: IBKR pull (gated, paper account).
/api/cron/borrow-ratesDaily 2am PTnbbo_ticks1 familyTick-level NBBO for microstructure families. Sampled, not full-tape.
/api/cron/daily-pricesDaily 3pm PTSentiment & Attention
Earnings-call transcripts (FinBERT-scored), retail social mentions, Wikipedia/Google attention, app DAU, foot traffic, box office.
earnings_call_transcripts15 familiesEarnings-call transcripts text by symbol + fiscal period.
/api/cron/motley-fool-transcripts0 11,23 * * *transcript_finbert_scores12 familiesPer-transcript tone, dispersion, Q&A tone (FinBERT model).
/api/cron/motley-fool-transcripts0 11,23 * * *box_office_daily5 familiesDaily film gross by title.
/api/cron/data-hub-dailyDaily 11pm PTsteam_top_games_concurrent5 familiesTop-game concurrent user counts.
/api/cron/data-hub-dailyDaily 11pm PTgoogle_trends_svi3 familiesSearch-volume index per ticker.
/api/cron/google-trendsDaily 1am PTnft_volume_daily2 familiesDaily NFT trading volume by collection.
/api/cron/data-hub-nft-dailyDaily 12:30am PTwikipedia_pageviews2 familiesDaily company-page views — wikipedia_attention_spike.
/api/cron/wikipedia-pageviewsDaily 5am PTwsb_mentions2 familiesReddit r/wallstreetbets mention counts.
/api/cron/data-hub-dailyDaily 11pm PTamazon_reviews1 familyPer-product review velocity + rating.
/api/cron/data-hub-weekly-monWeekly Mon 6am PTlinkedin_headcount1 familyDeprecated — ToS-restricted. Replaced by 10-K Item 1 employee count + BLS JOLTS.
/api/cron/data-hub-weekly-monWeekly Mon 6am PTmobile_app_dau1 familyDaily active users per app/ticker.
/api/cron/data-hub-dailyDaily 11pm PTsafegraph_visits1 familyPOI visit counts — store-traffic signal.
/api/cron/data-hub-weekly-monWeekly Mon 6am PTstocktwits_daily1 familyDaily bullish/bearish message counts per ticker.
/api/cron/stocktwits-dailyHourly (:30)Synthetic / Derived
In-house tables computed from the raw feeds above, regime labels, similarity scores, peer panels.
box_office_distributor_ticker_map5 familiesDistributor → parent-ticker mapping.
/api/cron/data-hub-weekly-monWeekly Mon 6am PTmarket_regime_daily5 familiesDaily regime label (bull/bear/sideways/crisis) — Layer 7 output.
/api/cron/fred-macroWeekly Mon 10pm PTsteam_publisher_ticker_map5 familiesSteam publisher → ticker mapping.
/api/cron/data-hub-weekly-monWeekly Mon 6am PTfirm_hq_locations4 familiesPer-ticker HQ state/city mapping.
/api/cron/data-hub-monthly-1stMonthly · day 1stocks4 familiesfaers_drug_severity_daily2 familiesDaily severity rollup by drug.
/api/cron/data-hub-dailyDaily 11pm PTofac_corporate_exposure2 familiesComputed sanctions exposure per US ticker.
/api/cron/data-hub-weekly-monWeekly Mon 6am PTsec_filing_similarity2 familiesYear-over-year 10-K text similarity — lazy_prices, filing_text_delta.
/api/cron/filing-similarityWeekly Sat 7pm PTtnic_peers2 familiesText-based industry classification peers.
/api/cron/tnic-monthlyMonthly · day 5corporate_jets_lookup1 familyAircraft registration → owner mapping.
/api/cron/data-hub-corp-jet-dailyDaily 12:10am PTfda_maude_device_severity_daily1 familyMedical-device severity rollup.
/api/cron/data-hub-dailyDaily 11pm PTuser_strategies1 familyProduction strategy table.
/api/cron/alpha-family-rollupHourly (:05)vix_term_structure1 familyComputed front/back ratio + slope used by vol_of_vol_signal.
/api/cron/daily-pricesDaily 3pm PTSEC Filings
Raw + parsed 10-K, 10-Q, 8-K, 13D, 13F, Form 4, S-1, DEF 14A, comment letters and threshold-list data, pulled from EDGAR.
sec_8k_events11 familiesMaterial events: M&A, departures, ratings — by item code.
/api/cron/sec-edgar-ftsDaily 9pm PTsec_10k_sections5 familiesParsed 10-K Item 1, 1A, 3, 7 text — text-NLP family input.
/api/cron/sec-10k-sectionsWeekly Sat 8pm PTsec_13d_filings4 familiesActivist >5% beneficial-owner filings.
/api/cron/sec-13dWeekly Mon 7am PTsec_10k_business_text2 families10-K business-description text only (separate cadence).
/api/cron/sec-10k-sectionsWeekly Sat 8pm PTsec_13f_aggregate2 familiesInstitutional holdings — n_filers, total_shares, delta.
/api/cron/sec-13f-quarterlyDaily 2am PTsec_def14a_filings2 familiesProxy statement filings — exec comp + governance.
/api/cron/sec-def14aWeekly Sat 8:30pm PTsec_comment_letters1 familySEC reviewer comment letters — comment-letter-drift signal.
/api/cron/sec-comment-lettersWeekly Sat 9pm PTsec_form_d_filings1 familyReg D private-placement notices.
/api/cron/sec-form-dWeekly Mon 8am PTsec_proxy_contests1 familyActivist proxy contests — proxy_contest_drift signal.
/api/cron/sec-proxy-contestsWeekly Mon 11am PTsec_s1_filings1 familyIPO registration statements — ipo_underpricing input.
/api/cron/sec-s1Weekly Mon 9am PTsec_seo_filings1 familySeasoned equity offerings — seo_underperformance trigger.
/api/cron/sec-seoWeekly Mon 10am PTsec_shelf_takedowns1 familyShelf-registration takedowns — secondary_offering_dilution.
/api/cron/sec-shelf-takedownsWeekly Mon 12pm PTFundamentals
Quarterly financials, analyst consensus, and reported earnings sourced from FinancialModelingPrep.
key_metrics17 familiesComputed ratios: ROE, ROIC, EV/EBITDA, etc. Quarterly.
/api/cron/key-metricsDaily 4am PTearnings_history8 familiesReported vs estimated EPS by ticker × date. Feeds PEAD/SUE.
/api/cron/earnings-historyDaily 12:30am PTanalyst_estimates3 familiesAnalyst EPS/revenue consensus + dispersion.
/api/cron/analyst-estimatesWeekly Mon 1am PTcash_flows3 familiesQuarterly cash-flow statement line items.
/api/cron/fundamentalsYearly · Feb/May/Aug/Nov 1Alt-Data Events
ACLED conflict, terror events, GDELT tone, OFAC sanctions, layoffs, index rebalances, corporate jet flights.
acled_events6 familiesWorldwide conflict, protest, riot events.
/api/cron/data-hub-dailyDaily 11pm PTcorporate_jet_flights6 familiesCorporate-jet flight tracks. Deprecated; replaced by corporate_jet_state_vectors v2.
/api/cron/data-hub-corp-jet-dailyDaily 12:10am PTgdelt_country_tone5 familiesPer-country media tone aggregated daily.
/api/cron/data-hub-dailyDaily 11pm PTlayoffs_fyi_events4 familiesTech-sector mass-layoff events.
/api/cron/data-hub-dailyDaily 11pm PTterror_events4 familiesHistorical terror events with target/casualty data.
/api/cron/data-hub-weekly-monWeekly Mon 6am PTofac_sdn3 familiesSpecially Designated Nationals sanctions list.
/api/cron/data-hub-weekly-monWeekly Mon 6am PThomepage_snapshots1 familyDaily homepage text/screenshot snapshots.
/api/cron/wayback-monthlyMonthly · day 2index_rebalance_events1 familyS&P 500 / R3K rebalance adds/drops — index_rebalance_drift.
/api/cron/index-rebalanceWeekly Sun 9pm PTCommodities & Trade
CME settlements, CFTC positioning, LME stocks, USDA WASDE/crop, port throughput, AIS shipping, Census FT-900 trade.
cme_futures_settle3 familiesDaily settlement prices for ag/energy/metals futures.
/api/cron/data-hub-dailyDaily 11pm PTdefi_tvl3 familiesTotal Value Locked across DeFi protocols.
/api/cron/data-hub-dailyDaily 11pm PTeia_crude_storage3 familiesUS crude oil storage levels.
/api/cron/data-hub-weekly-monWeekly Mon 6am PTport_throughput3 familiesContainer-throughput TEUs per port.
/api/cron/data-hub-weekly-monWeekly Mon 6am PTusda_crop_progress3 familiesWeekly crop-condition % by state × crop.
/api/cron/data-hub-weekly-monWeekly Mon 6am PTcensus_ft9002 familiesUS international trade balance by partner/product.
/api/cron/data-hub-monthly-1stMonthly · day 1cftc_cit_supplement2 familiesCommodity index swap-dealer positioning.
/api/cron/data-hub-weekly-monWeekly Mon 6am PTcftc_cot2 familiesWeekly futures positioning by trader type.
/api/cron/data-hub-weekly-monWeekly Mon 6am PTusda_grain_basis2 familiesRegional cash-vs-futures grain basis.
/api/cron/data-hub-weekly-monWeekly Mon 6am PTclarkson_shipping1 familyClarkson shipping index — deprecated 2026-05-20.
/api/cron/data-hub-weekly-monWeekly Mon 6am PTeia_natgas_storage1 familyUS natural gas storage levels.
/api/cron/data-hub-weekly-monWeekly Mon 6am PTlme_warehouse_stocks1 familyGlobal metals warehouse inventory.
/api/cron/data-hub-dailyDaily 11pm PTmarinecadastre_ais_aggregates1 familyAggregated AIS shipping activity — baltic_dry proxy.
/api/cron/data-hub-weekly-monWeekly Mon 6am PToil_chokepoint_events1 familySuez/Hormuz/Bab-el-Mandeb disruption events.
/api/cron/data-hub-dailyDaily 11pm PTusda_wasde_yields1 familyMonthly world agricultural supply/demand yields.
/api/cron/data-hub-monthly-1stMonthly · day 1Macro & Rates
FRED series, Fama-French factor returns, BIS effective rates, BLS JOLTS openings, geopolitical-risk indices.
fred_macro17 familiesMacro series: DXY, HY/IG spreads, yield curve, CPI, unemployment.
/api/cron/fred-macroWeekly Mon 10pm PTfama_french_daily2 familiesDaily FF5 + momentum factor returns.
/api/cron/fama-french-monthlyMonthly · day 7gpr_index2 familiesGeopolitical Risk index — gpr_geopolitical_risk.
/api/cron/fred-extendedDaily 11pm PTbis_effective_rates1 familyNominal + real effective FX rates.
/api/cron/fred-extendedDaily 11pm PTepu_index1 familyEconomic Policy Uncertainty index.
/api/cron/fred-extendedDaily 11pm PTfed_speeches1 familyFed-governor speech tone/text — fed-speak signals.
/api/cron/fred-extendedDaily 11pm PTiso_load_forecasts1 familyRegional electricity load forecasts.
/api/cron/data-hub-dailyDaily 11pm PTjolts_industry_openings1 familyJob-openings per industry — proxy_for_hiring.
/api/cron/jolts-monthlyMonthly · day 8pension_funding1 familyS&P 1500 pension funding-ratio index.
/api/cron/data-hub-monthly-1stMonthly · day 1tpu_index1 familyTrade Policy Uncertainty index.
/api/cron/fred-extendedDaily 11pm PTWeather & Climate
NOAA, NASA, USDM, NIFC and USGS feeds covering temperature, drought, hurricanes, fires, and earthquakes.
eia_degree_days4 familiesRegional HDD/CDD — natgas demand proxy.
/api/cron/data-hub-weekly-monWeekly Mon 6am PTnoaa_hurdat23 familiesAtlantic hurricane historical track data.
/api/cron/data-hub-yearly-aprYearly · Apr 15nifc_fires2 familiesUS wildfire incident records.
/api/cron/data-hub-dailyDaily 11pm PTnoaa_ghcnd_daily2 familiesDaily temperature/precipitation by station.
/api/cron/data-hub-dailyDaily 11pm PTnoaa_hurricane_outlook2 familiesPre-season hurricane forecast.
/api/cron/data-hub-yearly-aprYearly · Apr 15noaa_oni2 familiesENSO state index — El Niño / La Niña phases.
/api/cron/data-hub-monthly-1stMonthly · day 1usgs_earthquakes2 familiesGlobal earthquake events.
/api/cron/data-hub-dailyDaily 11pm PTmerra2_temp_anomaly1 familyGridded temperature anomalies.
/api/cron/data-hub-weekly-monWeekly Mon 6am PTnasa_black_marble_msa1 familyNighttime lights per MSA — economic-activity proxy.
/api/cron/data-hub-monthly-1stMonthly · day 1noaa_strat_temp1 familyPolar-vortex / SSW detection input.
/api/cron/data-hub-dailyDaily 11pm PTusdm_drought1 familyWeekly drought-severity map by county.
/api/cron/data-hub-weekly-monWeekly Mon 6am PTusgs_state_zone_lookup1 familyState→seismic-zone lookup.
/api/cron/data-hub-yearly-aprYearly · Apr 15Political & Lobbying
Congressional STOCK Act trades, Senate LDA disclosures, USAspending federal contracts, prediction-market odds.
polymarket_markets8 familiesActive prediction-market metadata.
/api/cron/data-hub-dailyDaily 11pm PTpolymarket_prices_daily7 familiesDaily yes/no prices for prediction markets.
/api/cron/data-hub-dailyDaily 11pm PTlobbying_disclosures2 familiesPer-issuer lobbying spend + issues filed.
/api/cron/lobbying-quarterlyWeekly Mon 6am PTcongress_trades1 familySenator/Representative STOCK Act disclosed trades.
/api/cron/congress-trades-historyMonthly · day 1election_odds1 familyUS election + policy event probabilities.
/api/cron/data-hub-dailyDaily 11pm PTfederal_contracts1 familyFederal contract awards by ticker (~610k rows).
/api/cron/data-hub-monthly-1stMonthly · day 1sipri_milex1 familyAnnual defense spending by country.
/api/cron/data-hub-yearly-aprYearly · Apr 15Insider & Ownership
Per-investor holdings, insider transactions, ETF constituents, and 10b5-1 plan adoptions.
sec_insider_trades6 familiesInsider buy/sell transactions — insider_form4, form4_cluster.
/api/cron/sec-insider-tradesDaily 11pm PTetf_holdings4 familiesPer-ETF constituent weights — etf_comembership signal.
/api/cron/etf-holdingsWeekly Mon 9pm PTsec_form_144_filings3 familiesNotice of proposed sale by affiliates; form_144_overhang short.
/api/cron/sec-form-144Weekly Mon 8:30am PTsec_insider_10b5_plans2 familiesRule 10b5-1 trading-plan adoptions/cancellations.
/api/cron/sec-form4-10b5Daily 7pm PTinvestor_holdings1 familyPosition-level 13F holdings (~875k rows).
/api/cron/sec-13f-quarterlyDaily 2am PTShort Interest
FINRA short-volume, SEC fails-to-deliver, Reg SHO threshold list, IBKR borrow rates.
finra_short_volume4 familiesDaily short-sale volume per ticker.
/api/cron/finra-short-volumeDaily 7:30pm PTsec_fail_to_deliver_daily4 familiesT+2 fails-to-deliver per ticker — sec_ftd_fail_pressure.
/api/cron/finra-short-volumeDaily 7:30pm PTsec_reg_sho_threshold4 familiesPersistent FTD threshold-list inclusion.
/api/cron/sec-reg-sho-thresholdDaily 8pm PTstock_borrow_rates4 familiesPer-ticker stock-loan borrow rate.
/api/cron/borrow-ratesDaily 2am PTHealth & Safety
FDA AdCom, FAERS adverse events, MAUDE device reports, ClinicalTrials.gov readouts, NHTSA recalls.
fda_adcomm4 familiesAdCom meeting schedule + outcomes.
/api/cron/data-hub-weekly-monWeekly Mon 6am PTclinical_trials_phaseiii3 familiesPhase III trial events + outcomes.
/api/cron/data-hub-weekly-monWeekly Mon 6am PTfaers_adverse_events3 familiesDrug adverse-event reports.
/api/cron/data-hub-quarterlyYearly · Feb/May/Aug/Nov 1nhtsa_vehicle_recalls3 familiesAuto recall events by manufacturer.
/api/cron/data-hub-weekly-monWeekly Mon 6am PTPatents & Innovation
USPTO grants, applications and litigation, plus the Kogan-Papanikolaou-Seru-Stoffman patent-value panel.
patent_innovation_value2 familiesStock-market value of patents — KPSS panel.
/api/cron/patent-kpss-yearlyYearly · Feb 10patent_litigation2 familiesPatent-lawsuit events by defendant.
/api/cron/patent-kpss-yearlyYearly · Feb 10uspto_patent_applications2 familiesPatent application filings (1.3M rows).
/api/cron/patent-kpss-yearlyYearly · Feb 10Cron times shown in Pacific (PDT during Mar–Nov, PST during Nov–Mar). Underlying schedules in vercel.json are UTC. Family counts include every family that lists this table in its required_tables manifest.
Freshness snapshot generated against the production cloud DB.