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/swarms","as_of":"2026-04-09T01:43:26.310695+00:00","canonical_url":"https://www.coingecko.com/en/coins/swarms","enrichment":{"aggregator_url":"https://www.coingecko.com/en/coins/swarms","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_77e015dae16effc5","canonical_host":"coingecko.com","canonical_is_aggregator":false,"canonical_url":"https://www.coingecko.com/en/coins/swarms","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-09T23:47:33.394703+00:00","extraction_method":"heuristic","fetched_description":"Track the latest Swarms price, market cap, trading volume, news and more with CoinGecko's live SWARMS/USD price chart and popular cryptocurrency price tracker.","fetched_title":"Swarms Price: SWARMS/USD Live Price Chart, Market Cap & News Today | CoinGecko","final_url":"https://www.coingecko.com/en/coins/swarms","html_truncated":true,"paywall_likely":false,"publisher_domain":"coingecko.com","publisher_resolution":"canonical_url","requested_url":"https://www.coingecko.com/en/coins/swarms","source_event_id":"evt_7c4e1fc653e0","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"ae3676693823e061","kind":"crypto_extremes","published_at":"2026-04-09T01:43:33.203651+00:00","publisher_domain":"coingecko.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.72,"dates_mentioned":[],"entities":[{"asset_class":"crypto","name":"Swarms","relevance":"high","symbol":"SWARMS","type":"cryptocurrency"}],"event_type":"price_action","information_gaps":["The cleaned article text does not include the specific SWARMS price, 24h volume, or 24h change; only the global CoinGecko page header content is present.","No timestamp for when the trend score/rank were observed is included in the provided text.","The article text contains unrelated UI/global metrics (e.g., total market cap, BTC dominance) but does not tie them to SWARMS specifically."],"key_facts":["Signal headline: \"Trending: Swarms (SWARMS)\".","Provided signal metadata: market cap rank 929.","Provided signal metadata: trend score 10.","Publisher domain indicated as coingecko.com; source quality hint indicates high."],"numeric_claims":[{"label":"market_cap_rank","value":"929"},{"label":"trend_score","value":"10"}],"primary_claim":"Swarms (SWARMS) is listed as trending on CoinGecko with market cap rank 929 and trend score 10.","relevance_score":0.55,"sentiment":"neutral","source_quality":"high","summary":"CoinGecko is showing Swarms (SWARMS) as a trending cryptocurrency. The signal indicates a market-cap rank of 929 and a trend score of 10.","topics":["crypto trending","CoinGecko","market cap rank","trend score"]},"source":"CoinGecko Trending","source_domain":"coingecko.com","summary":"Market cap rank 929, trend score 10","tickers":["SWARMS","SWARMSUSD"],"title":"Trending: Swarms (SWARMS)","url":"https://www.coingecko.com/en/coins/swarms"}

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