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-09T04:42:09.468703+00:00","dedupe_key":"signal_enriched:discovery_crypto_extremes_delta:e2b4b9ad7c902a2b","evidence_event_ids":["evt_30a62d8e24ab"],"signal_type":"discovery_crypto_extremes_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://www.coingecko.com/en/coins/aerodrome-finance","as_of":"2026-04-09T04:42:09.468703+00:00","canonical_url":"https://www.coingecko.com/en/coins/aerodrome-finance","enrichment":{"aggregator_url":"https://www.coingecko.com/en/coins/aerodrome-finance","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_714e649d4d50d2b8","canonical_host":"coingecko.com","canonical_is_aggregator":false,"canonical_url":"https://www.coingecko.com/en/coins/aerodrome-finance","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-09T23:53:19.850385+00:00","extraction_method":"heuristic","fetched_description":"Track the latest Aerodrome Finance price, market cap, trading volume, news and more with CoinGecko's live AERO/USD price chart and popular cryptocurrency price tracker.","fetched_title":"Aerodrome Finance Price: AERO/USD Live Price Chart, Market Cap & News Today | CoinGecko","final_url":"https://www.coingecko.com/en/coins/aerodrome-finance","html_truncated":true,"paywall_likely":false,"publisher_domain":"coingecko.com","publisher_resolution":"canonical_url","requested_url":"https://www.coingecko.com/en/coins/aerodrome-finance","source_event_id":"evt_30a62d8e24ab","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"31144ec32f6e6b2e","kind":"crypto_extremes","published_at":"2026-04-09T04:42:15.243906+00:00","publisher_domain":"coingecko.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.78,"dates_mentioned":[],"entities":[{"asset_class":"cryptocurrency","name":"Aerodrome Finance","relevance":"primary","symbol":"AERO","type":"crypto_asset"},{"asset_class":"website","name":"CoinGecko","relevance":"context","symbol":"","type":"publisher"}],"event_type":"price_action","information_gaps":["No AERO/USD live price is shown in the provided text excerpt.","No AERO 24h price change percentage is provided in the excerpt.","No timeframe definition for \"trend score\" is included in the provided text.","The excerpt contains unrelated \"Trending NFTs\" search redirect data for other coins, but not AERO-specific details."],"key_facts":["The signal headline states: \"Trending: Aerodrome Finance (AERO)\".","The source summary states: \"Market cap rank 130, trend score 9\".","The article text includes CoinGecko site-wide market data (e.g., total market cap and 24h volume), but no AERO-specific numeric price/change is present in the provided excerpt."],"numeric_claims":[{"label":"market_cap_rank","value":"130"},{"label":"trend_score","value":"9"}],"primary_claim":"Aerodrome Finance (AERO) is listed as trending on CoinGecko with market cap rank 130 and trend score 9.","relevance_score":0.55,"sentiment":"neutral","source_quality":"high","summary":"CoinGecko\u2019s page for Aerodrome Finance (AERO) shows the asset as trending, with a market cap rank of 130 and a trend score of 9. The provided text does not include the AERO price or 24h change values.","topics":["crypto trending","market cap ranking","trend score","AERO"]},"source":"CoinGecko Trending","source_domain":"coingecko.com","summary":"Market cap rank 130, trend score 9","tickers":["AERO","AEROUSD"],"title":"Trending: Aerodrome Finance (AERO)","url":"https://www.coingecko.com/en/coins/aerodrome-finance"}}

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 10538 in events