SQLite Web: event

id

Primary key. TEXT

event_id

TEXT NOT NULL

watcher_id

TEXT

signal_type

TEXT NOT NULL

value

{"aggregator_url":"https://news.google.com/rss/articles/CBMimgFBVV95cUxNc3VwWFBOT3B2QjV0WDNyQVo1cmluWWN6b0JhWnFWem5WWl9OQnNDcmJaMTJnTFRXMzROOGJMUV9xVjB3a2ZVbG9fMlJfMVV1ZGhCTFFVSmRkR01GNlFDcDZwMHg1Z0RyLTBtTkdGaFU3UmFCeVQ1aGNSTXc2MmI2Q0tiX3E2aGZIMVlFYXJZMVFuRkk4X3Q3dDdR?oc=5","as_of":"2026-04-13T03:40:40.921775+00:00","canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAIFAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2OYSmDAUDetpsORI83j3dpsv55GJQ/m=syndicationarticleview,_b,_tp","enrichment":{"aggregator_url":"https://news.google.com/rss/articles/CBMimgFBVV95cUxNc3VwWFBOT3B2QjV0WDNyQVo1cmluWWN6b0JhWnFWem5WWl9OQnNDcmJaMTJnTFRXMzROOGJMUV9xVjB3a2ZVbG9fMlJfMVV1ZGhCTFFVSmRkR01GNlFDcDZwMHg1Z0RyLTBtTkdGaFU3UmFCeVQ1aGNSTXc2MmI2Q0tiX3E2aGZIMVlFYXJZMVFuRkk4X3Q3dDdR?oc=5","article_chars":0,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_d283a0d9bf549372","canonical_host":"gstatic.com","canonical_is_aggregator":true,"canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAIFAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2OYSmDAUDetpsORI83j3dpsv55GJQ/m=syndicationarticleview,_b,_tp","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-13T04:23:36.680084+00:00","extraction_method":"none","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMimgFBVV95cUxNc3VwWFBOT3B2QjV0WDNyQVo1cmluWWN6b0JhWnFWem5WWl9OQnNDcmJaMTJnTFRXMzROOGJMUV9xVjB3a2ZVbG9fMlJfMVV1ZGhCTFFVSmRkR01GNlFDcDZwMHg1Z0RyLTBtTkdGaFU3UmFCeVQ1aGNSTXc2MmI2Q0tiX3E2aGZIMVlFYXJZMVFuRkk4X3Q3dDdR?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"aastocks.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMimgFBVV95cUxNc3VwWFBOT3B2QjV0WDNyQVo1cmluWWN6b0JhWnFWem5WWl9OQnNDcmJaMTJnTFRXMzROOGJMUV9xVjB3a2ZVbG9fMlJfMVV1ZGhCTFFVSmRkR01GNlFDcDZwMHg1Z0RyLTBtTkdGaFU3UmFCeVQ1aGNSTXc2MmI2Q0tiX3E2aGZIMVlFYXJZMVFuRkk4X3Q3dDdR?oc=5","source_event_id":"evt_3bd37c5469b3","source_quality":"empty","status_code":200,"version":"signal_enrichment_v2"},"fp":"1ba64c136b85d360","published_at":"2026-04-13T03:23:00+00:00","publisher_domain":"aastocks.com","signal_understanding":{"analysis_basis":"headline_only","claim_confidence":0.55,"dates_mentioned":["last week"],"entities":[{"asset_class":"fund_flow","name":"Southbound funds","relevance":"high","symbol":"","type":"fund_flow_category"},{"asset_class":"equities","name":"Hong Kong stocks","relevance":"high","symbol":"","type":"market"}],"event_type":"other","information_gaps":["No article text is provided, so specific listed stocks/tickers are unknown.","No net buy/sell amounts, rankings, or directionality beyond the existence of \u201cmajor net buys and net sells\u201d are provided.","The exact date of \u201clast week\u201d and the publication date are not provided.","\u201cG Sachs\u201d is mentioned but not fully identified (e.g., firm name/which entity) in the provided text."],"key_facts":["Headline states G Sachs lists major net buys and net sells in HK stocks by Southbound funds last week.","No specific stock tickers, amounts, or names are provided in the provided text."],"numeric_claims":[],"primary_claim":"G Sachs listed major net buys and net sells in HK stocks by Southbound funds last week.","relevance_score":0.35,"sentiment":"neutral","source_quality":"unknown","summary":"The headline reports that G Sachs published data on major net buys and net sells in Hong Kong stocks by Southbound funds for the previous week.","topics":["fund flows","Hong Kong stocks","Southbound funds","net buys","net sells","G Sachs"]},"source":"AASTOCKS.com","source_domain":"aastocks.com","source_url":"http://www.aastocks.com","summary":"","tickers":[],"title":"G Sachs Lists Major Net Buys and Net Sells in HK Stocks by Southbound Funds Last Week - AASTOCKS.com","url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAIFAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2OYSmDAUDetpsORI83j3dpsv55GJQ/m=syndicationarticleview,_b,_tp"}

TEXT NOT NULL

threshold

TEXT

direction

TEXT

severity

TEXT

window

TEXT

source

TEXT NOT NULL

reason_trace

TEXT

dedupe_key

TEXT NOT NULL

throttle_s

INTEGER (default 0

created_at

TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')

event_store.db — signals

Update row sig_05eff202e8aa in signals