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/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

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