Create
Query
event_store.db
—
signals
actions
approvals
artifacts
commitments
constraints
conversation_compaction
conversation_state
conversation_turns
dead_letters
decisions
deliveries
effects
email_messages
email_reply_drafts
email_threads
entities
entity_aliases
entity_tags
episode_context_index
episodes
event_subjects
events
events_archive
fact_sources
facts
inbox_items
inbox_links
jobs
leader_leases
links
memory_candidates
memory_embeddings
memory_items
memory_items_fts
(v)
memory_items_fts_config
memory_items_fts_data
memory_items_fts_idx
opportunity_memory
pending_interactions
proposal_sources
proposals
reminders
schedules
schema_migrations
signal_candidates
signal_fps
signals
sms_conversations
sms_messages
sms_reply_drafts
source_cursors
sources
sqlite_sequence
sqlite_stat1
stream_cursors
threads
watchers
Toggle helper tables
memory_items_fts_content
memory_items_fts_docsize
memory_items_fts_segdir
memory_items_fts_segments
memory_items_fts_stat
Structure
Content
Query
Insert
Drop
Import
Export
Update row sig_1b24a3af8727 in signals
id
sig_1b24a3af8727
Primary key.
TEXT
event_id
2481
TEXT NOT NULL
watcher_id
NULL
TEXT
signal_type
market_analysis
TEXT NOT NULL
value
{"as_of":"2026-04-08T23:23:50.700217+00:00","candles":[],"episode_id":"ep_e966e9848f01","event_id":"evt_c8d476fbe49d","headlines":[{"fp":"5e3d5beafad026cd","published_at":"2026-04-08T20:37:45+00:00","source":"Bloomberg","source_domain":"bloomberg.com","source_url":"https://www.bloomberg.com","summary":"","tickers":[],"title":"Stocks Gain as US-Iran Truce Deal Spurs Oil Plunge: Markets Wrap - Bloomberg","url":"https://news.google.com/rss/articles/CBMilAFBVV95cUxQSnh0RWFhb0tzVXRuZGdyeHZHLXZDNlFIdXpId1hoYjNXeHpFdGlNNHBHenVQeW1VdF9QNXZ4eENkNEFscUltbDhITXhpaFhXX2tjV3dsd3FFNnZ3VWNtSHJ4RVlUbVBaenUwXzktaVNyYmpXRWFvME1yVm9GR0o0OWxzbjNWUmk5NXlSZXEwZDQyR2Ra?oc=5"},{"fp":"a485f1546ee60cb7","published_at":"2026-04-08T17:23:26+00:00","source":"MarketBeat","source_domain":"marketbeat.com","source_url":"https://www.marketbeat.com","summary":"","tickers":[],"title":"Applied Optoelectronics (NASDAQ:AAOI) Hits New 52-Week High - Time to Buy? - MarketBeat","url":"https://news.google.com/rss/articles/CBMivwFBVV95cUxNMWdXRWh0OERSRHFNMk1QVzMybndfX2hsRzg4TDFrWmlwQzhJWDlSUVJORWpjZWRKeHlsLXB2Z3puVExBZzJjOW04RHVMX0otbGVtYnEyWEJ6OFZESUZ6LXU0dUdBT2Z6bjE1YjZMTmdnbGhMcFJPN05sQjZ0UThxTUFYWlRfUTJxRzVaQmN6SURNeDkxdDAxeERJMXhxdUNURzJseHYwUzlCcjJXLXlXMG5Ud1JBOC1LNG41U3dUUQ?oc=5"},{"fp":"a467fbe08d0a7990","published_at":"2026-04-08T14:51:41+00:00","source":"Inshorts","source_domain":"inshorts.com","source_url":"https://inshorts.com","summary":"","tickers":[],"title":"AAOI stock jumps 10% pre-market on massive order wins | Tap to know more | Inshorts - Inshorts","url":"https://news.google.com/rss/articles/CBMiogFBVV95cUxOVC15Qk5JSWFFYmJZYWZoMmpLQ081YlhUaDZkVjZiTFU2LUhxbjN2dEs0RHZJZ1FxazJtbnRuTU9PZUQxUkxDd0lvU3RUN2ZVeUNxQVpoSHFQbVE0amVNSzdLUHJJZ2Nmdnl5Si1lUEpqdXpIN3IyUHRDUTlMcjh6Z2hYMnJPbzM5RS1wdVZabjNmQ28wVld5Rlc0aDFfWk4yY3fSAaIBQVVfeXFMTlQteUJOSUlhRWJiWWFmaDJqS0NPNWJYVGg2ZFY2YkxVNi1IcW4zdnRLNER2SWdRcWsybW50bk1PT2VEMVJMQ3dJb1N0VDdmVXlDcUFaaEhxUG1RNGplTUs3S1BySWdjZnZ5eUotZVBKanV6SDdyMlB0Q1E5THI4emdoWDJyT28zOUUtcHVWWm4zZkNvMFZXeUZXNGgxX1pOMmN3?oc=5"},{"fp":"c8a27de9acfcc277","published_at":"2026-04-08T21:20:50+00:00","source":"fool.com","source_domain":"fool.com","source_url":"https://www.fool.com","summary":"","tickers":[],"title":"Stock Market Today (LIVE): VSEC Jumps 15%, Though $2B Bet Looms; Axon Whipsaws\u2014What Changed? - fool.com","url":"https://news.google.com/rss/articles/CBMigAFBVV95cUxQeXJuVF9iNzhYd1E0WDhEc0dpelRjd3BsUXVYWURfZ1JDb2dDZE9pYzF0b1VYNjc2UW1XTGcxSFlySWR5LUpqUS1qMWtrc2E1M2t6bjZNdW1nZUJZMjBTM1VpLUVGZEZCRHdDWmNhQkNHZ0xxbE9OU1dNNk5PVF9KWQ?oc=5"},{"fp":"7e58f4a5821c74a8","published_at":"2026-04-08T20:10:46+00:00","source":"Kiplinger","source_domain":"kiplinger.com","source_url":"https://www.kiplinger.com","summary":"","tickers":[],"title":"Dow Climbs 1,325 Points in Relief Rally: Stock Market Today - Kiplinger","url":"https://news.google.com/rss/articles/CBMiowFBVV95cUxORDJRWWFrZVN6SWNVZmpxMmozNTlodTUzS09FckF4X3B6NTlqNjNzcExUdGE2bzRieDZNWl9pZjlHdUt6VWxMMHlfYTd4RUhBbzc1bTBGRFBkYVJleDlhOFExNVpQZkxRUmxBbUhhbGgzeHVHYzJuMV9yS0VGazI4OENfZ0ZqQ1hiVi1EV0d6X1QwRFZhMk5IczVZeTAxZ3VDT2xR?oc=5"},{"fp":"323b4c412b7f81ab","published_at":"2026-04-08T21:30:52+00:00","source":"fool.com","source_domain":"fool.com","source_url":"https://www.fool.com","summary":"","tickers":[],"title":"Stock Market Today, April 8: Intel Surges After Joining Elon Musk Terafab AI Chip Project - fool.com","url":"https://news.google.com/rss/articles/CBMi4gFBVV95cUxPb3ItZm9PUVdxaURyeGZ0NXp2R2l4ZGNzNC0xN21tZHVfVlBWV1FraUZpWkJZblVlaWY2cjVnUjVHOUphX0hoMjFxRU5GZmNUSzVtR09IcXVRQjEtSW54U3pqUGkzUEc1aXhSRDJxbHVKM28xZlVGVnVFMHRYUmVuOWN2ZllvMzZsaHg1WFpSdDRTRGd6RkdxWmw5a0pNVThlbVJTRWs2dnl4NXBEWlU1QlRwei1HeG9SQW9LLWp4MUhKZzBLcGtFLXlDdzRzTm5ndmtoNGQySlRqNkVjVE40TDJB?oc=5"},{"fp":"18640acdf540611e","published_at":"2026-04-08T20:09:35+00:00","source":"CNBC","source_domain":"cnbc.com","source_url":"https://www.cnbc.com","summary":"","tickers":[],"title":"Tom Lee: The stock market bottom is in - CNBC","url":"https://news.google.com/rss/articles/CBMihwFBVV95cUxOekFBTlczWjZmYzNsbER5MHo1WlN3d2ZoR3VTQ1owcDBwZEZfeDNhcjJubXBXWDhNY2tYNUhoTWUzWjR6Zkp3d1p5dmhxUXAxYmpQM1ZlMDZuSDZlVXlmYThWeGNzdnlzR3h2S09ZQThEbzRnX0pncEdQanRPVzF1OVIxVTBSUmc?oc=5"},{"fp":"b4d7623d613ee8cf","published_at":"2026-04-08T19:31:00+00:00","source":"fool.com","source_domain":"fool.com","source_url":"https://www.fool.com","summary":"","tickers":[],"title":"Here's Why QXO Stock Outpaced the Market Today - fool.com","url":"https://news.google.com/rss/articles/CBMikgFBVV95cUxQcVdXRnlNM0pIaXluQjB5V1JwbjhORnlkTmliLTg5bjI0MEJScmxDRnhwTlFpbUFPSnd0d1pyTW1sd3hSZ0dlWEduLU1xNXgzMzg0UE8yaklYbFMzTkJvSEJrZExMOWMwRWo1akh2dFJTNllLOFFUTVNPOFJuX2M2ZkJmODJuYmNWOEVlRU5CeTRrQQ?oc=5"},{"fp":"0573c77c7944fb31","published_at":"2026-04-08T18:15:31+00:00","source":"MSN","source_domain":"msn.com","source_url":"https://www.msn.com","summary":"","tickers":[],"title":"Applied Optoelectronics (AAOI) climbs 20% on higher 800G transceiver demand - MSN","url":"https://news.google.com/rss/articles/CBMiwAFBVV95cUxPT05LQlFWbjBVYlNmbmJSTXVhaUc3U1lkc0RJVlZEbVlZVUlnVWpScEtmS2pXdTIxNGNMLWhnSWw3M05UMUdxY0lraHJqbHFCYXJjVTdDV2xUdTZxSGxhd3U5ZHhPQ2NBeUo0NjhYbVFFQ0d5cmlsVnFXQm1CQTl6S1JSbElhX2JseGthd2pES1Z3LURQbTJPQk5MOWFscVlMT2g4a0IzcFFCS2ZaR2IyOEZ4dWhsVkpvYXlEaGxFeUE?oc=5"},{"fp":"d888cd7c80d5f9e9","published_at":"2026-04-08T15:41:00+00:00","source":"Investor's Business Daily","source_domain":"investors.com","source_url":"https://www.investors.com","summary":"","tickers":[],"title":"Stock Market Today: Stock Market News And Analysis - Investor's Business Daily","url":"https://news.google.com/rss/articles/CBMid0FVX3lxTE8zdGl1MmxTM2JJa2pLNlFSWVhuZUd1ekRIeVpDcGVqckVJcloxaWlnRHJ3b0hqb291NXk4dlo0SmRQNlhDaGpubDh6ZWNTUHZiYVhjOVJINUxSYXE0NHRiNVE2OW51R2h4N1daaXRIdzVBR1UxT0g4?oc=5"}],"movers":[],"quote":null,"text":"\ud83d\udcc8 *AAOI \u2014 Market Snapshot*\n_as_of:_ `2026-04-08T23:23:50.700217+00:00`\n\u2022 *Quote:* \u2014\n\u2022 *Trend:* \u2014 (no candles available)\n*Top headlines:*\n\u2022 <https://news.google.com/rss/articles/CBMilAFBVV95cUxQSnh0RWFhb0tzVXRuZGdyeHZHLXZDNlFIdXpId1hoYjNXeHpFdGlNNHBHenVQeW1VdF9QNXZ4eENkNEFscUltbDhITXhpaFhXX2tjV3dsd3FFNnZ3VWNtSHJ4RVlUbVBaenUwXzktaVNyYmpXRWFvME1yVm9GR0o0OWxzbjNWUmk5NXlSZXEwZDQyR2Ra?oc=5|Stocks Gain as US-Iran Truce Deal Spurs Oil Plunge: Markets Wrap - Bloomberg> _(Bloomberg \u00b7 2026-04-08)_\n\u2022 <https://news.google.com/rss/articles/CBMivwFBVV95cUxNMWdXRWh0OERSRHFNMk1QVzMybndfX2hsRzg4TDFrWmlwQzhJWDlSUVJORWpjZWRKeHlsLXB2Z3puVExBZzJjOW04RHVMX0otbGVtYnEyWEJ6OFZESUZ6LXU0dUdBT2Z6bjE1YjZMTmdnbGhMcFJPN05sQjZ0UThxTUFYWlRfUTJxRzVaQmN6SURNeDkxdDAxeERJMXhxdUNURzJseHYwUzlCcjJXLXlXMG5Ud1JBOC1LNG41U3dUUQ?oc=5|Applied Optoelectronics (NASDAQ:AAOI) Hits New 52-Week High - Time to Buy? - MarketBeat> _(MarketBeat \u00b7 2026-04-08)_\n\u2022 <https://news.google.com/rss/articles/CBMiogFBVV95cUxOVC15Qk5JSWFFYmJZYWZoMmpLQ081YlhUaDZkVjZiTFU2LUhxbjN2dEs0RHZJZ1FxazJtbnRuTU9PZUQxUkxDd0lvU3RUN2ZVeUNxQVpoSHFQbVE0amVNSzdLUHJJZ2Nmdnl5Si1lUEpqdXpIN3IyUHRDUTlMcjh6Z2hYMnJPbzM5RS1wdVZabjNmQ28wVld5Rlc0aDFfWk4yY3fSAaIBQVVfeXFMTlQteUJOSUlhRWJiWWFmaDJqS0NPNWJYVGg2ZFY2YkxVNi1IcW4zdnRLNER2SWdRcWsybW50bk1PT2VEMVJMQ3dJb1N0VDdmVXlDcUFaaEhxUG1RNGplTUs3S1BySWdjZnZ5eUotZVBKanV6SDdyMlB0Q1E5THI4emdoWDJyT28zOUUtcHVWWm4zZkNvMFZXeUZXNGgxX1pOMmN3?oc=5|AAOI stock jumps 10% pre-market on massive order wins | Tap to know more | Inshorts - Inshorts> _(Inshorts \u00b7 2026-04-08)_\n\u2022 <https://news.google.com/rss/articles/CBMigAFBVV95cUxQeXJuVF9iNzhYd1E0WDhEc0dpelRjd3BsUXVYWURfZ1JDb2dDZE9pYzF0b1VYNjc2UW1XTGcxSFlySWR5LUpqUS1qMWtrc2E1M2t6bjZNdW1nZUJZMjBTM1VpLUVGZEZCRHdDWmNhQkNHZ0xxbE9OU1dNNk5PVF9KWQ?oc=5|Stock Market Today (LIVE): VSEC Jumps 15%, Though $2B Bet Looms; Axon Whipsaws\u2014What Changed? - fool.com> _(fool.com \u00b7 2026-04-08)_\n\u2022 <https://news.google.com/rss/articles/CBMiowFBVV95cUxORDJRWWFrZVN6SWNVZmpxMmozNTlodTUzS09FckF4X3B6NTlqNjNzcExUdGE2bzRieDZNWl9pZjlHdUt6VWxMMHlfYTd4RUhBbzc1bTBGRFBkYVJleDlhOFExNVpQZkxRUmxBbUhhbGgzeHVHYzJuMV9yS0VGazI4OENfZ0ZqQ1hiVi1EV0d6X1QwRFZhMk5IczVZeTAxZ3VDT2xR?oc=5|Dow Climbs 1,325 Points in Relief Rally: Stock Market Today - Kiplinger> _(Kiplinger \u00b7 2026-04-08)_\n\u2022 <https://news.google.com/rss/articles/CBMi4gFBVV95cUxPb3ItZm9PUVdxaURyeGZ0NXp2R2l4ZGNzNC0xN21tZHVfVlBWV1FraUZpWkJZblVlaWY2cjVnUjVHOUphX0hoMjFxRU5GZmNUSzVtR09IcXVRQjEtSW54U3pqUGkzUEc1aXhSRDJxbHVKM28xZlVGVnVFMHRYUmVuOWN2ZllvMzZsaHg1WFpSdDRTRGd6RkdxWmw5a0pNVThlbVJTRWs2dnl4NXBEWlU1QlRwei1HeG9SQW9LLWp4MUhKZzBLcGtFLXlDdzRzTm5ndmtoNGQySlRqNkVjVE40TDJB?oc=5|Stock Market Today, April 8: Intel Surges After Joining Elon Musk Terafab AI Chip Project - fool.com> _(fool.com \u00b7 2026-04-08)_\n\u2022 <https://news.google.com/rss/articles/CBMihwFBVV95cUxOekFBTlczWjZmYzNsbER5MHo1WlN3d2ZoR3VTQ1owcDBwZEZfeDNhcjJubXBXWDhNY2tYNUhoTWUzWjR6Zkp3d1p5dmhxUXAxYmpQM1ZlMDZuSDZlVXlmYThWeGNzdnlzR3h2S09ZQThEbzRnX0pncEdQanRPVzF1OVIxVTBSUmc?oc=5|Tom Lee: The stock market bottom is in - CNBC> _(CNBC \u00b7 2026-04-08)_\n\u2022 <https://news.google.com/rss/articles/CBMikgFBVV95cUxQcVdXRnlNM0pIaXluQjB5V1JwbjhORnlkTmliLTg5bjI0MEJScmxDRnhwTlFpbUFPSnd0d1pyTW1sd3hSZ0dlWEduLU1xNXgzMzg0UE8yaklYbFMzTkJvSEJrZExMOWMwRWo1akh2dFJTNllLOFFUTVNPOFJuX2M2ZkJmODJuYmNWOEVlRU5CeTRrQQ?oc=5|Here's Why QXO Stock Outpaced the Market Today - fool.com> _(fool.com \u00b7 2026-04-08)_\n\u2022 <https://news.google.com/rss/articles/CBMiwAFBVV95cUxPT05LQlFWbjBVYlNmbmJSTXVhaUc3U1lkc0RJVlZEbVlZVUlnVWpScEtmS2pXdTIxNGNMLWhnSWw3M05UMUdxY0lraHJqbHFCYXJjVTdDV2xUdTZxSGxhd3U5ZHhPQ2NBeUo0NjhYbVFFQ0d5cmlsVnFXQm1CQTl6S1JSbElhX2JseGthd2pES1Z3LURQbTJPQk5MOWFscVlMT2g4a0IzcFFCS2ZaR2IyOEZ4dWhsVkpvYXlEaGxFeUE?oc=5|Applied Optoelectronics (AAOI) climbs 20% on higher 800G transceiver demand - MSN> _(MSN \u00b7 2026-04-08)_\n\u2022 <https://news.google.com/rss/articles/CBMid0FVX3lxTE8zdGl1MmxTM2JJa2pLNlFSWVhuZUd1ekRIeVpDcGVqckVJcloxaWlnRHJ3b0hqb291NXk4dlo0SmRQNlhDaGpubDh6ZWNTUHZiYVhjOVJINUxSYXE0NHRiNVE2OW51R2h4N1daaXRIdzVBR1UxT0g4?oc=5|Stock Market Today: Stock Market News And Analysis - Investor's Business Daily> _(Investor's Business Daily \u00b7 2026-04-08)_","thread_id":"thr_0a6a7f6b2a53749c5a","ticker":"AAOI"}
TEXT NOT NULL
threshold
NULL
TEXT
direction
NULL
TEXT
severity
NULL
TEXT
window
NULL
TEXT
source
capability:market
TEXT NOT NULL
reason_trace
{}
TEXT
dedupe_key
market_analysis:AAOI:2026-04-08
TEXT NOT NULL
throttle_s
INTEGER (default 0
created_at
2026-04-08T23:27:56.046664+00:00
TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')
Update
Cancel