SQLite Web: event

id

Primary key. TEXT

event_id

TEXT NOT NULL

watcher_id

TEXT

signal_type

TEXT NOT NULL

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

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_2c61300c9189 in signals