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/usd-coin","as_of":"2026-04-09T21:31:27.529333+00:00","canonical_url":"https://www.coingecko.com/en/coins/usdc","enrichment":{"aggregator_url":"https://www.coingecko.com/en/coins/usd-coin","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_5d3f10a3a0267725","canonical_host":"coingecko.com","canonical_is_aggregator":false,"canonical_url":"https://www.coingecko.com/en/coins/usdc","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-10T01:56:27.239949+00:00","extraction_method":"heuristic","fetched_description":"Track the latest USDC price, market cap, trading volume, news and more with CoinGecko's live USDC/USD price chart and popular cryptocurrency price tracker.","fetched_title":"USDC Price: USDC/USD Live Price Chart, Market Cap & News Today | CoinGecko","final_url":"https://www.coingecko.com/en/coins/usdc","html_truncated":true,"paywall_likely":false,"publisher_domain":"coingecko.com","publisher_resolution":"canonical_url","requested_url":"https://www.coingecko.com/en/coins/usd-coin","source_event_id":"evt_608b614f6afe","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"a04747715d7cc805","kind":"crypto_extremes","published_at":"2026-04-09T21:31:34.005569+00:00","publisher_domain":"coingecko.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.78,"dates_mentioned":[],"entities":[{"asset_class":"crypto","name":"USD Coin","relevance":"high","symbol":"USDC","type":"cryptocurrency"}],"event_type":"price_action","information_gaps":["No explicit USDC/USD live price is present in the provided excerpt.","No explicit USDC 24h volume or 24h percentage change for USDC is shown in the provided excerpt.","The excerpt contains extensive unrelated page navigation and other embedded data; USDC-specific metrics beyond rank and trend score are not visible.","The time window/definition for \u201ctrend score\u201d is not provided in the text."],"key_facts":["Signal headline: \u201cTrending: USDC (USDC)\u201d.","CoinGecko source summary: \u201cMarket cap rank 6, trend score 11\u201d.","Article text includes site-wide market data (e.g., total market cap, dominance), but no explicit USDC-specific price/change values are shown in the provided excerpt."],"numeric_claims":[{"label":"market_cap_rank","value":"6"},{"label":"trend_score","value":"11"}],"primary_claim":"USDC has a market cap rank of 6 and a trend score of 11 on CoinGecko\u2019s trending signal.","relevance_score":0.55,"sentiment":"neutral","source_quality":"high","summary":"CoinGecko\u2019s page indicates USDC is currently trending, with market cap rank 6 and a trend score of 11. The provided text does not include a specific USDC price or 24h change for USDC itself.","topics":["crypto trending","USDC","market cap rank","trend score"]},"source":"CoinGecko Trending","source_domain":"coingecko.com","summary":"Market cap rank 6, trend score 11","tickers":["USDC","USDCUSD"],"title":"Trending: USDC (USDC)","url":"https://www.coingecko.com/en/coins/usdc"}

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