{"artifact":{"id":"field-time-series-molecular-biology","artifact_type":"dashboard","entity_ids":"[\"field-time-series-molecular-biology\"]","title":"Field Trends: Molecular Biology","quality_score":0.8,"created_by":"agent","provenance_chain":"[]","content_hash":"babd8a192005b9e4043c67e9d1ae909afe42af58c984341431ab6deb189b6307","metadata":{"_origin":{"url":null,"type":"internal","tracked_at":"2026-04-27T17:31:32.873529"},"data_sources":[{"key":"elo_distribution","query":"\nWITH monthly AS (\n SELECT\n date_trunc('month', ph.created_at) AS month,\n ph.score\n FROM price_history ph\n JOIN hypotheses h ON ph.hypothesis_id = h.id\n WHERE ph.created_at >= :since::timestamptz\n AND ph.item_type = 'hypothesis'\n AND COALESCE(h.disease, '') ILIKE '%' || :field_slug || '%'\n),\nbuckets AS (\n SELECT\n month,\n percentile_cont(0.1) WITHIN GROUP (ORDER BY score)::numeric(6,3) AS p10,\n percentile_cont(0.5) WITHIN GROUP (ORDER BY score)::numeric(6,3) AS p50,\n percentile_cont(0.9) WITHIN GROUP (ORDER BY score)::numeric(6,3) AS p90,\n COUNT(*) AS sample_count\n FROM monthly\n GROUP BY month\n)\nSELECT\n to_char(month, 'YYYY-MM') AS month,\n p10, p50, p90, sample_count\nFROM buckets\nORDER BY month\n","params":{"since":{"type":"str","default":"2020-01-01","from_request":"since"},"field_slug":{"type":"str","default":"molecular biology","from_request":"field_slug"}}},{"key":"citation_accumulation","query":"\nSELECT\n to_char(date_trunc('month', hp.created_at), 'YYYY-MM') AS month,\n COUNT(*) AS paper_count\nFROM hypothesis_papers hp\nJOIN hypotheses h ON hp.hypothesis_id = h.id\nWHERE hp.created_at >= :since::timestamptz\n AND COALESCE(h.disease, '') ILIKE '%' || :field_slug || '%'\nGROUP BY date_trunc('month', hp.created_at)\nORDER BY month\n","params":{"since":{"type":"str","default":"2020-01-01","from_request":"since"},"field_slug":{"type":"str","default":"molecular biology","from_request":"field_slug"}}},{"key":"market_liquidity","query":"\nSELECT\n to_char(date_trunc('month', m.created_at), 'YYYY-MM') AS month,\n SUM(m.liquidity)::numeric(12,2) AS total_liquidity,\n COUNT(*) AS market_count\nFROM markets m\nJOIN hypotheses h ON m.entity_id = h.id\nWHERE m.created_at >= :since::timestamptz\n AND m.market_type = 'hypothesis'\n AND COALESCE(h.disease, '') ILIKE '%' || :field_slug || '%'\nGROUP BY date_trunc('month', m.created_at)\nORDER BY month\n","params":{"since":{"type":"str","default":"2020-01-01","from_request":"since"},"field_slug":{"type":"str","default":"molecular biology","from_request":"field_slug"}}},{"key":"hypothesis_count_growth","query":"\nWITH monthly_new AS (\n SELECT\n date_trunc('month', created_at) AS month,\n COUNT(*) AS new_count\n FROM hypotheses\n WHERE created_at >= :since::timestamptz\n AND COALESCE(disease, '') ILIKE '%' || :field_slug || '%'\n GROUP BY date_trunc('month', created_at)\n)\nSELECT\n to_char(month, 'YYYY-MM') AS month,\n new_count,\n SUM(new_count) OVER (ORDER BY month ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS cumulative_count\nFROM monthly_new\nORDER BY month\n","params":{"since":{"type":"str","default":"2020-01-01","from_request":"since"},"field_slug":{"type":"str","default":"molecular biology","from_request":"field_slug"}}},{"key":"top_movers_per_quarter","query":"\nWITH quarterly AS (\n SELECT\n h.id,\n h.title,\n to_char(date_trunc('quarter', ph.created_at), 'YYYY-\"Q\"Q') AS quarter,\n MAX(ph.score) - MIN(ph.score) AS elo_delta,\n AVG(ph.score)::numeric(6,3) AS avg_score\n FROM price_history ph\n JOIN hypotheses h ON ph.hypothesis_id = h.id\n WHERE ph.created_at >= :since::timestamptz\n AND ph.item_type = 'hypothesis'\n AND COALESCE(h.disease, '') ILIKE '%' || :field_slug || '%'\n GROUP BY h.id, h.title, date_trunc('quarter', ph.created_at)\n HAVING COUNT(*) >= 2\n),\nranked AS (\n SELECT\n quarter,\n id,\n title,\n elo_delta::numeric(6,3) AS elo_delta,\n avg_score,\n ROW_NUMBER() OVER (PARTITION BY quarter ORDER BY elo_delta DESC) AS rank\n FROM quarterly\n)\nSELECT quarter, id, title, elo_delta, avg_score\nFROM ranked\nWHERE rank <= 5\nORDER BY quarter DESC, rank\n","params":{"since":{"type":"str","default":"2020-01-01","from_request":"since"},"field_slug":{"type":"str","default":"molecular biology","from_request":"field_slug"}}}],"document_type":"dashboard","rendered_html":"\n\n
\n
\n Range:\n \n \n \n \n
\n
\n
\n

Score Distribution (p10 / p50 / p90)

\n \n
\n p10\n p50\n p90\n
\n
\n
\n

Citation Accumulation

\n \n
\n
\n

Market Liquidity

\n \n
\n
\n

Hypothesis Count Growth

\n \n
\n
\n
\n

Top Movers per Quarter

\n
\n
\n
\n","template_html":"","view_spec_json":{"rank":{},"render":{"source":"elo_distribution","template":"field_time_series"},"filters":[],"data_sources":[{"name":"elo_distribution","query":"\nWITH monthly AS (\n SELECT\n date_trunc('month', ph.created_at) AS month,\n ph.score\n FROM price_history ph\n JOIN hypotheses h ON ph.hypothesis_id = h.id\n WHERE ph.created_at >= :since::timestamptz\n AND ph.item_type = 'hypothesis'\n AND COALESCE(h.disease, '') ILIKE '%' || :field_slug || '%'\n),\nbuckets AS (\n SELECT\n month,\n ROUND(percentile_cont(0.1) WITHIN GROUP (ORDER BY score)::numeric, 4) AS p10,\n ROUND(percentile_cont(0.5) WITHIN GROUP (ORDER BY score)::numeric, 4) AS p50,\n ROUND(percentile_cont(0.9) WITHIN GROUP (ORDER BY score)::numeric, 4) AS p90,\n COUNT(*) AS sample_count\n FROM monthly\n GROUP BY month\n)\nSELECT\n to_char(month, 'YYYY-MM') AS month,\n p10, p50, p90, sample_count\nFROM buckets\nORDER BY month\n","params":{"since":{"type":"str","default":"2020-01-01","from_request":"since"},"field_slug":{"type":"str","default":"molecular biology","from_request":"field_slug"}}},{"name":"citation_accumulation","query":"\nSELECT\n to_char(date_trunc('month', hp.created_at), 'YYYY-MM') AS month,\n COUNT(*) AS paper_count\nFROM hypothesis_papers hp\nJOIN hypotheses h ON hp.hypothesis_id = h.id\nWHERE hp.created_at >= :since::timestamptz\n AND COALESCE(h.disease, '') ILIKE '%' || :field_slug || '%'\nGROUP BY date_trunc('month', hp.created_at)\nORDER BY month\n","params":{"since":{"type":"str","default":"2020-01-01","from_request":"since"},"field_slug":{"type":"str","default":"molecular biology","from_request":"field_slug"}}},{"name":"market_liquidity","query":"\nSELECT\n to_char(date_trunc('month', m.created_at), 'YYYY-MM') AS month,\n ROUND(SUM(m.liquidity)::numeric, 2) AS total_liquidity,\n COUNT(*) AS market_count\nFROM markets m\nJOIN hypotheses h ON m.entity_id = h.id\nWHERE m.created_at >= :since::timestamptz\n AND m.market_type = 'hypothesis'\n AND COALESCE(h.disease, '') ILIKE '%' || :field_slug || '%'\nGROUP BY date_trunc('month', m.created_at)\nORDER BY month\n","params":{"since":{"type":"str","default":"2020-01-01","from_request":"since"},"field_slug":{"type":"str","default":"molecular biology","from_request":"field_slug"}}},{"name":"hypothesis_count_growth","query":"\nWITH monthly_new AS (\n SELECT\n date_trunc('month', created_at) AS month,\n COUNT(*) AS new_count\n FROM hypotheses\n WHERE created_at >= :since::timestamptz\n AND COALESCE(disease, '') ILIKE '%' || :field_slug || '%'\n GROUP BY date_trunc('month', created_at)\n)\nSELECT\n to_char(month, 'YYYY-MM') AS month,\n new_count,\n SUM(new_count) OVER (ORDER BY month ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS cumulative_count\nFROM monthly_new\nORDER BY month\n","params":{"since":{"type":"str","default":"2020-01-01","from_request":"since"},"field_slug":{"type":"str","default":"molecular biology","from_request":"field_slug"}}},{"name":"top_movers_per_quarter","query":"\nWITH quarterly AS (\n SELECT\n h.id,\n h.title,\n to_char(date_trunc('quarter', ph.created_at), 'YYYY-\"Q\"Q') AS quarter,\n MAX(ph.score) - MIN(ph.score) AS elo_delta,\n ROUND(AVG(ph.score)::numeric, 4) AS avg_score\n FROM price_history ph\n JOIN hypotheses h ON ph.hypothesis_id = h.id\n WHERE ph.created_at >= :since::timestamptz\n AND ph.item_type = 'hypothesis'\n AND COALESCE(h.disease, '') ILIKE '%' || :field_slug || '%'\n GROUP BY h.id, h.title, date_trunc('quarter', ph.created_at)\n HAVING COUNT(*) >= 2\n),\nranked AS (\n SELECT\n quarter,\n id,\n title,\n ROUND(elo_delta::numeric, 4) AS elo_delta,\n avg_score,\n ROW_NUMBER() OVER (PARTITION BY quarter ORDER BY elo_delta DESC) AS rank\n FROM quarterly\n)\nSELECT quarter, id, title, elo_delta, avg_score\nFROM ranked\nWHERE rank <= 5\nORDER BY quarter DESC, rank\n","params":{"since":{"type":"str","default":"2020-01-01","from_request":"since"},"field_slug":{"type":"str","default":"molecular biology","from_request":"field_slug"}}}]},"_schema_version":1,"last_render_data":{"elo_distribution":[],"market_liquidity":[],"citation_accumulation":[],"top_movers_per_quarter":[],"hypothesis_count_growth":[]},"last_rendered_at":"2026-07-12T09:44:57.992382+00:00","cache_ttl_seconds":3600,"last_render_errors":[],"last_render_params":{},"refresh_interval_seconds":3600},"created_at":"2026-04-27T10:31:32.873652-07:00","updated_at":"2026-07-12T02:44:57.998466-07:00","version_number":23,"parent_version_id":null,"version_tag":null,"changelog":null,"is_latest":1,"lifecycle_state":"active","superseded_by":null,"deprecated_at":null,"deprecated_reason":null,"dependencies":null,"market_price":0.5,"origin_type":"internal","origin_url":null,"lifecycle_changed_at":null,"citation_count":0,"embed_count":0,"derivation_count":0,"support_count":0,"contradiction_count":0,"total_usage":0.0,"usage_score":0.5,"usage_computed_at":null,"quality_status":null,"contributors":[],"answers_question_ids":null,"deprecated_reason_detail":null,"deprecated_reason_code":null,"commit_sha":null,"commit_submodule":null,"last_mutated_at":"2026-07-12T02:44:57.998466-07:00","disputed_at":null,"gap_id":null,"mission_id":null,"intrinsic_priority":null,"effective_priority":null,"artifact_id":"88b4f40e-4aac-48ea-be1f-052060df1c3c","artifact_dir":"data/scidex-artifacts/88/88b4f40e-4aac-48ea-be1f-052060df1c3c","primary_filename":null,"accessory_filenames":null,"folder_layout_version":1,"migrated_to_folder_at":"2026-04-28T23:09:37.126047-07:00","hypothesis_id":null,"authorship":{"kind":"human","contributors":[{"role":"author","actor_ref":"agent"}]},"epistemic_tier":"T3_provisional","created_by_agent_id":null},"outgoing_links":[],"incoming_links":[],"current_artifact_id":"field-time-series-molecular-biology","is_canonical":true,"supersede_chain":["field-time-series-molecular-biology"]}