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-08T22:43:46.053448+00:00","dedupe_key":"signal_enriched:discovery_crypto_extremes_delta:3edd7a72c4b2ae0e","evidence_event_ids":["evt_42ccfe2c3bd2"],"signal_type":"discovery_crypto_extremes_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://www.coingecko.com/en/coins/monero","as_of":"2026-04-08T22:43:46.053448+00:00","canonical_url":"https://www.coingecko.com/en/coins/monero","enrichment":{"aggregator_url":"https://www.coingecko.com/en/coins/monero","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_d06be3befd6a3526","canonical_host":"coingecko.com","canonical_is_aggregator":false,"canonical_url":"https://www.coingecko.com/en/coins/monero","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-09T23:30:00.223221+00:00","extraction_method":"heuristic","fetched_description":"Track the latest Monero price, market cap, trading volume, news and more with CoinGecko's live XMR/USD price chart and popular cryptocurrency price tracker.","fetched_title":"Monero Price: XMR/USD Live Price Chart, Market Cap & News Today | CoinGecko","final_url":"https://www.coingecko.com/en/coins/monero","html_truncated":true,"paywall_likely":false,"publisher_domain":"coingecko.com","publisher_resolution":"canonical_url","requested_url":"https://www.coingecko.com/en/coins/monero","source_event_id":"evt_42ccfe2c3bd2","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"061dd7fcb1a5015d","kind":"crypto_extremes","published_at":"2026-04-08T22:43:53.749490+00:00","publisher_domain":"coingecko.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.78,"dates_mentioned":[],"entities":[{"asset_class":"crypto","name":"Monero","relevance":"high","symbol":"XMR","type":"cryptocurrency"}],"event_type":"price_action","information_gaps":["No timestamp/date for when the 24h window ends is provided in the cleaned article text.","The cleaned article text contains extensive CoinGecko page UI content but does not include the specific lines showing the -3.88% and market cap; those values are only explicitly present in the provided signal headline/source summary.","No absolute price level for XMR/USD is included in the provided text (only the 24h percentage change and market cap)."],"key_facts":["XMR/USD 24h change is -3.88% (as stated in the signal headline/source summary).","Monero market cap is reported as $6,072,623,444 (as stated in the signal/source summary)."],"numeric_claims":[{"label":"XMR price change (24h, %)","value":"-3.88%"},{"label":"Monero market cap (USD)","value":"6072623444"}],"primary_claim":"Monero (XMR) moved -3.88% over the last 24 hours and has a reported market cap of $6,072,623,444.","relevance_score":0.62,"sentiment":"negative","source_quality":"high","summary":"Monero (XMR) declined by 3.88% over the past 24 hours, according to the provided CoinGecko signal text. The signal also reports Monero\u2019s market cap as $6,072,623,444.","topics":["crypto price change","Monero","24h performance","market cap"]},"source":"CoinGecko Movers","source_domain":"coingecko.com","summary":"24h change -3.88% \u00b7 mcap 6072623444","tickers":["XMR","XMRUSD"],"title":"Monero (XMR) moved -3.88% (24h)","url":"https://www.coingecko.com/en/coins/monero"}}

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 10109 in events