SQLite Web: event

seq

Primary key. INTEGER

id

TEXT NOT NULL

kind

TEXT NOT NULL

ts

TEXT NOT NULL

actor

TEXT

subject_entity_ids

TEXT

payload

{"created_at":"2026-04-07T23:23:54.391414+00:00","dedupe_key":"signal_enriched:discovery_sector_rotation_delta:ed7272516c228ec8","evidence_event_ids":["evt_eeff3c5cb671"],"signal_type":"discovery_sector_rotation_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMiY0FVX3lxTE1BTGxpelQwajVteHEtU3pPTVpUSDJYQjQyaTNKRVJoY25nbzVzTF9IUnJEZmFsUGZYajVLeDNIbHFsSHpyOWcyak50dS1DQ25WUjdROUtsZW91VUo4ZHAtQm5Jd9IBY0FVX3lxTE1BTGxpelQwajVteHEtU3pPTVpUSDJYQjQyaTNKRVJoY25nbzVzTF9IUnJEZmFsUGZYajVLeDNIbHFsSHpyOWcyak50dS1DQ25WUjdROUtsZW91VUo4ZHAtQm5Jdw?oc=5","as_of":"2026-04-07T23:23:54.391414+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/CBMiY0FVX3lxTE1BTGxpelQwajVteHEtU3pPTVpUSDJYQjQyaTNKRVJoY25nbzVzTF9IUnJEZmFsUGZYajVLeDNIbHFsSHpyOWcyak50dS1DQ25WUjdROUtsZW91VUo4ZHAtQm5Jd9IBY0FVX3lxTE1BTGxpelQwajVteHEtU3pPTVpUSDJYQjQyaTNKRVJoY25nbzVzTF9IUnJEZmFsUGZYajVLeDNIbHFsSHpyOWcyak50dS1DQ25WUjdROUtsZW91VUo4ZHAtQm5Jdw?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_6ed1f482fe46b8c6","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-08T00:50:42.752594+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiY0FVX3lxTE1BTGxpelQwajVteHEtU3pPTVpUSDJYQjQyaTNKRVJoY25nbzVzTF9IUnJEZmFsUGZYajVLeDNIbHFsSHpyOWcyak50dS1DQ25WUjdROUtsZW91VUo4ZHAtQm5Jd9IBY0FVX3lxTE1BTGxpelQwajVteHEtU3pPTVpUSDJYQjQyaTNKRVJoY25nbzVzTF9IUnJEZmFsUGZYajVLeDNIbHFsSHpyOWcyak50dS1DQ25WUjdROUtsZW91VUo4ZHAtQm5Jdw?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"gstatic.com","publisher_resolution":"canonical_aggregator_unresolved","requested_url":"https://news.google.com/rss/articles/CBMiY0FVX3lxTE1BTGxpelQwajVteHEtU3pPTVpUSDJYQjQyaTNKRVJoY25nbzVzTF9IUnJEZmFsUGZYajVLeDNIbHFsSHpyOWcyak50dS1DQ25WUjdROUtsZW91VUo4ZHAtQm5Jd9IBY0FVX3lxTE1BTGxpelQwajVteHEtU3pPTVpUSDJYQjQyaTNKRVJoY25nbzVzTF9IUnJEZmFsUGZYajVLeDNIbHFsSHpyOWcyak50dS1DQ25WUjdROUtsZW91VUo4ZHAtQm5Jdw?oc=5","source_event_id":"evt_eeff3c5cb671","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"205906ff3a2b3cde","kind":"sector_rotation","published_at":"2026-04-04T02:32:03+00:00","publisher_domain":"gstatic.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.78,"dates_mentioned":["24 hours"],"entities":[{"asset_class":"crypto","name":"ESIM (Depinsim)","relevance":"high","symbol":"ESIM","type":"asset"},{"asset_class":"crypto_sector_theme","name":"DePIN sector","relevance":"high","symbol":"","type":"sector/theme"},{"asset_class":"exchange","name":"Bitget","relevance":"medium","symbol":"","type":"publisher/exchange"}],"event_type":"price_action","information_gaps":["No explicit list of which specific sectors are gaining vs losing; only \u201cDePIN sector rotation\u201d is mentioned.","No directionality is provided (e.g., whether ESIM was net up or down), only \u201cfluctuated.\u201d","No macro driver beyond \u201cDePIN sector rotation\u201d and \u201cincreased trading volume\u201d is specified.","No evidence in the provided text to determine whether this is a regime shift vs short-term rebalancing beyond the 24-hour framing."],"key_facts":["ESIM (Depinsim) fluctuated by 86.7% in 24 hours.","The movement is attributed to DePIN sector rotation.","The movement is also attributed to increased trading volume.","Source is attributed to Bitget."],"numeric_claims":[{"label":"ESIM fluctuation (24h)","value":"86.7%"}],"primary_claim":"ESIM (Depinsim) fluctuated by 86.7% in 24 hours, driven by DePIN sector rotation and increased trading volume (Bitget).","relevance_score":0.62,"sentiment":"mixed","source_quality":"high","summary":"ESIM (Depinsim) saw an 86.7% fluctuation over 24 hours, attributed to DePIN sector rotation alongside increased trading volume. The signal suggests active short-term rotation within the DePIN theme rather than a clearly specified broad market regime change.","topics":["DePIN","sector rotation","trading volume","ESIM price fluctuation"]},"source":"Bitget","source_domain":"gstatic.com","summary":"ESIM (Depinsim) fluctuated by 86.7% in 24 hours: DePIN sector rotation and increased trading volume drive movement Bitget","tickers":[],"title":"ESIM (Depinsim) fluctuated by 86.7% in 24 hours: DePIN sector rotation and increased trading volume drive movement - Bitget","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

source_ref

TEXT

confidence

REAL (default 0.0

dedupe_key

TEXT

episode_id

TEXT

created_at

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

event_store.db — events

Update row 2616 in events