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/templar","as_of":"2026-04-10T01:02:52.094973+00:00","canonical_url":"https://www.coingecko.com/en/coins/templar","enrichment":{"aggregator_url":"https://www.coingecko.com/en/coins/templar","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_a11284881428bafe","canonical_host":"coingecko.com","canonical_is_aggregator":false,"canonical_url":"https://www.coingecko.com/en/coins/templar","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-10T02:06:42.019566+00:00","extraction_method":"heuristic","fetched_description":"Track the latest \u03c4emplar price, market cap, trading volume, news and more with CoinGecko's live SN3/USD price chart and popular cryptocurrency price tracker.","fetched_title":"\u03c4emplar Price: SN3/USD Live Price Chart, Market Cap & News Today | CoinGecko","final_url":"https://www.coingecko.com/en/coins/templar","html_truncated":true,"paywall_likely":false,"publisher_domain":"coingecko.com","publisher_resolution":"canonical_url","requested_url":"https://www.coingecko.com/en/coins/templar","source_event_id":"evt_72a9322eeb95","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"c7c464916bed26af","kind":"crypto_extremes","published_at":"2026-04-10T01:02:59.602816+00:00","publisher_domain":"coingecko.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.78,"dates_mentioned":[],"entities":[{"asset_class":"crypto","name":"\u03c4emplar","relevance":"high","symbol":"SN3","type":"cryptocurrency"}],"event_type":"price_action","information_gaps":["The provided article text is largely CoinGecko site navigation and global market stats; it does not include the specific \u03c4emplar (SN3) details beyond the signal headline/source summary.","No timestamp for the trend score/rank is provided in the extracted text.","No price, 24h change, or volume metrics for \u03c4emplar (SN3) are present in the provided article text."],"key_facts":["Signal indicates \u03c4emplar (SN3) is trending.","Market cap rank: 516 (as provided in the signal headline/source summary).","Trend score: 2 (as provided in the signal headline/source summary)."],"numeric_claims":[{"label":"market_cap_rank","value":"516"},{"label":"trend_score","value":"2"}],"primary_claim":"\u03c4emplar (SN3) has a CoinGecko market cap rank of 516 and a trend score of 2.","relevance_score":0.42,"sentiment":"neutral","source_quality":"high","summary":"CoinGecko shows \u03c4emplar (SN3) as a trending cryptocurrency with market cap rank 516 and a trend score of 2.","topics":["crypto trending","market cap rank","trend score"]},"source":"CoinGecko Trending","source_domain":"coingecko.com","summary":"Market cap rank 516, trend score 2","tickers":["SN3","SN3USD"],"title":"Trending: \u03c4emplar (SN3)","url":"https://www.coingecko.com/en/coins/templar"}

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