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/centrifuge-2","as_of":"2026-04-10T02:03:25.344037+00:00","canonical_url":"https://www.coingecko.com/en/coins/centrifuge","enrichment":{"aggregator_url":"https://www.coingecko.com/en/coins/centrifuge-2","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_e92a7f5d6e20bd05","canonical_host":"coingecko.com","canonical_is_aggregator":false,"canonical_url":"https://www.coingecko.com/en/coins/centrifuge","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-10T02:08:34.200357+00:00","extraction_method":"heuristic","fetched_description":"Track the latest Centrifuge price, market cap, trading volume, news and more with CoinGecko's live CFG/USD price chart and popular cryptocurrency price tracker.","fetched_title":"Centrifuge Price: CFG/USD Live Price Chart, Market Cap & News Today | CoinGecko","final_url":"https://www.coingecko.com/en/coins/centrifuge","html_truncated":true,"paywall_likely":false,"publisher_domain":"coingecko.com","publisher_resolution":"canonical_url","requested_url":"https://www.coingecko.com/en/coins/centrifuge-2","source_event_id":"evt_8aaa0796493c","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"5d0edaffd0cb928e","kind":"crypto_extremes","published_at":"2026-04-10T02:03:34.183183+00:00","publisher_domain":"coingecko.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.7,"dates_mentioned":[],"entities":[{"asset_class":"crypto","name":"Centrifuge","relevance":"primary","symbol":"CFG","type":"cryptocurrency"}],"event_type":"price_action","information_gaps":["The provided article text does not include the specific lines showing \u201cMarket cap rank 232\u201d and \u201ctrend score 7\u201d; only the external signal metadata contains these values.","No CFG price, 24h change, or other measurable performance metrics for CFG are present in the cleaned article text.","No timestamp for when the trend score/rank were observed is included."],"key_facts":["Signal indicates CoinGecko \u201cTrending: Centrifuge (CFG)\u201d.","Market cap rank: 232.","Trend score: 7."],"numeric_claims":[{"label":"market_cap_rank","value":"232"},{"label":"trend_score","value":"7"}],"primary_claim":"Centrifuge (CFG) is trending on CoinGecko with market cap rank 232 and trend score 7.","relevance_score":0.45,"sentiment":"neutral","source_quality":"high","summary":"CoinGecko\u2019s \u201cTrending\u201d section shows Centrifuge (CFG) with a market cap rank of 232 and a trend score of 7.","topics":["crypto trending","market cap rank","trend score","CFG/USD"]},"source":"CoinGecko Trending","source_domain":"coingecko.com","summary":"Market cap rank 232, trend score 7","tickers":["CFG","CFGUSD"],"title":"Trending: Centrifuge (CFG)","url":"https://www.coingecko.com/en/coins/centrifuge"}

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