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/fartcoin","as_of":"2026-04-08T21:48:34.772061+00:00","canonical_url":"https://www.coingecko.com/en/coins/fartcoin","enrichment":{"aggregator_url":"https://www.coingecko.com/en/coins/fartcoin","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_075347064d612d82","canonical_host":"coingecko.com","canonical_is_aggregator":false,"canonical_url":"https://www.coingecko.com/en/coins/fartcoin","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-09T23:21:41.968416+00:00","extraction_method":"heuristic","fetched_description":"Track the latest Fartcoin price, market cap, trading volume, news and more with CoinGecko's live FARTCOIN/USD price chart and popular cryptocurrency price tracker.","fetched_title":"Fartcoin Price: FARTCOIN/USD Live Price Chart, Market Cap & News Today | CoinGecko","final_url":"https://www.coingecko.com/en/coins/fartcoin","html_truncated":true,"paywall_likely":false,"publisher_domain":"coingecko.com","publisher_resolution":"canonical_url","requested_url":"https://www.coingecko.com/en/coins/fartcoin","source_event_id":"evt_bf65e6b2f54b","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"da0012d2db69f5ca","kind":"crypto_extremes","published_at":"2026-04-08T21:48:40.172578+00:00","publisher_domain":"coingecko.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.78,"dates_mentioned":[],"entities":[{"asset_class":"crypto","name":"Fartcoin","relevance":"high","symbol":"FARTCOIN","type":"cryptocurrency"}],"event_type":"price_action","information_gaps":["Fartcoin-specific live price (FARTCOIN/USD) is not present in the provided cleaned text.","No Fartcoin 24h volume, 24h price change, or market cap value is provided in the extracted text.","The text does not specify the time window or methodology behind the \u201ctrend score.\u201d","The provided article text does not clearly show the Fartcoin entry details beyond the signal headline/source summary."],"key_facts":["CoinGecko source summary states: \u201cMarket cap rank 161, trend score 9\u201d for Fartcoin (FARTCOIN).","The provided article text is largely CoinGecko site navigation and general market-wide stats, and does not include Fartcoin-specific price or change figures."],"numeric_claims":[{"label":"market_cap_rank","value":"161"},{"label":"trend_score","value":"9"}],"primary_claim":"Fartcoin (FARTCOIN) is trending on CoinGecko with market cap rank 161 and trend score 9.","relevance_score":0.45,"sentiment":"neutral","source_quality":"high","summary":"CoinGecko\u2019s \u201cTrending\u201d section lists Fartcoin (FARTCOIN) with market cap rank 161 and a trend score of 9. No price, 24h change, or other performance metrics for Fartcoin are included in the provided text.","topics":["crypto trending","CoinGecko","market cap rank","trend score"]},"source":"CoinGecko Trending","source_domain":"coingecko.com","summary":"Market cap rank 161, trend score 9","tickers":["FARTCOIN","FARTCOINUSD"],"title":"Trending: Fartcoin (FARTCOIN)","url":"https://www.coingecko.com/en/coins/fartcoin"}

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