SQLite Web: event

seq

Primary key. INTEGER

id

TEXT NOT NULL

kind

TEXT NOT NULL

ts

TEXT NOT NULL

actor

TEXT

subject_entity_ids

TEXT

payload

{"created_at":"2026-04-08T22:43:46.053448+00:00","dedupe_key":"signal_enriched:discovery_crypto_extremes_delta:23ee27e3cbe16c52","evidence_event_ids":["evt_1b378c1f6a51"],"signal_type":"discovery_crypto_extremes_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://www.coingecko.com/en/coins/redstone-oracles","as_of":"2026-04-08T22:43:46.053448+00:00","canonical_url":"https://www.coingecko.com/en/coins/redstone-oracles","enrichment":{"aggregator_url":"https://www.coingecko.com/en/coins/redstone-oracles","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_cf5ee573a321346c","canonical_host":"coingecko.com","canonical_is_aggregator":false,"canonical_url":"https://www.coingecko.com/en/coins/redstone-oracles","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-09T23:29:52.220893+00:00","extraction_method":"heuristic","fetched_description":"Track the latest RedStone price, market cap, trading volume, news and more with CoinGecko's live RED/USD price chart and popular cryptocurrency price tracker.","fetched_title":"RedStone Price: RED/USD Live Price Chart, Market Cap & News Today | CoinGecko","final_url":"https://www.coingecko.com/en/coins/redstone-oracles","html_truncated":true,"paywall_likely":false,"publisher_domain":"coingecko.com","publisher_resolution":"canonical_url","requested_url":"https://www.coingecko.com/en/coins/redstone-oracles","source_event_id":"evt_1b378c1f6a51","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"4b072834f2a52e0c","kind":"crypto_extremes","published_at":"2026-04-08T22:43:53.749490+00:00","publisher_domain":"coingecko.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.78,"dates_mentioned":[],"entities":[{"asset_class":"crypto","name":"RedStone","relevance":"high","symbol":"RED","type":"cryptocurrency"},{"asset_class":"platform","name":"CoinGecko","relevance":"medium","symbol":"","type":"publisher"}],"event_type":"price_action","information_gaps":["No actual RED price value is provided in the cleaned article text.","No 24h price change percentage, volume, or market cap figure for RED is included in the provided text.","The provided text appears to include unrelated site-wide metrics (e.g., total market cap, BTC dominance) and other UI content, but not specific RED performance beyond rank and trend score.","No timestamp for when the trend score/rank was measured is included."],"key_facts":["Headline states: \u201cTrending: RedStone (RED)\u201d.","Source summary states: \u201cMarket cap rank 376, trend score 11\u201d.","The page section shown includes \u201cRedStone Price: RED/USD Live Price Chart, Market Cap & News Today | CoinGecko\u201d."],"numeric_claims":[{"label":"market_cap_rank","value":"376"},{"label":"trend_score","value":"11"}],"primary_claim":"RedStone (RED) has market cap rank 376 and a trend score of 11 on CoinGecko\u2019s trending section.","relevance_score":0.45,"sentiment":"neutral","source_quality":"high","summary":"The signal indicates that RedStone (RED) is currently trending on CoinGecko, with a market cap rank of 376 and a trend score of 11. No additional price-change or news details for RED are present in the provided text.","topics":["crypto trending","market cap ranking","trend score","RED/USD"]},"source":"CoinGecko Trending","source_domain":"coingecko.com","summary":"Market cap rank 376, trend score 11","tickers":["RED","REDUSD"],"title":"Trending: RedStone (RED)","url":"https://www.coingecko.com/en/coins/redstone-oracles"}}

TEXT NOT NULL

source_ref

TEXT

confidence

REAL (default 0.0

dedupe_key

TEXT

episode_id

TEXT

created_at

TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')

event_store.db — events

Update row 10094 in events