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-21T19:57:20.275338+00:00","dedupe_key":"signal_enriched:discovery_crypto_extremes_delta:5436ac79ff8ece52","evidence_event_ids":["evt_22b24aa387ea"],"signal_type":"discovery_crypto_extremes_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://www.coingecko.com/en/coins/make-aliens-great-again","as_of":"2026-04-21T19:57:20.275338+00:00","canonical_url":"https://www.coingecko.com/en/coins/make-aliens-great-again","enrichment":{"aggregator_url":"https://www.coingecko.com/en/coins/make-aliens-great-again","article_chars":604,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_3933569c0a1660da","canonical_host":"coingecko.com","canonical_is_aggregator":false,"canonical_url":"https://www.coingecko.com/en/coins/make-aliens-great-again","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-21T23:28:00.136850+00:00","extraction_method":"trafilatura","fetched_description":"Track the latest Make Aliens Great Again price, market cap, trading volume, news and more with CoinGecko's live MAGA/USD price chart and popular cryptocurrency price tracker.","fetched_title":"Make Aliens Great Again Price: MAGA/USD Live Price Chart, Market Cap & News Today | CoinGecko","final_url":"https://www.coingecko.com/en/coins/make-aliens-great-again","html_truncated":true,"paywall_likely":false,"publisher_domain":"coingecko.com","publisher_resolution":"canonical_url","requested_url":"https://www.coingecko.com/en/coins/make-aliens-great-again","source_event_id":"evt_22b24aa387ea","source_quality":"low","status_code":200,"version":"signal_enrichment_v2"},"fp":"45f7e7fa10b7c374","kind":"crypto_extremes","published_at":"2026-04-21T19:57:30.656668+00:00","publisher_domain":"coingecko.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.52,"dates_mentioned":[],"entities":[{"asset_class":"cryptocurrency","name":"Make Aliens Great Again (MAGA)","relevance":"high","symbol":"MAGA","type":"cryptoasset"},{"asset_class":"platform","name":"CoinGecko","relevance":"medium","symbol":"","type":"publisher"},{"asset_class":"website","name":"Rugcheck.xyz","relevance":"high","symbol":"","type":"risk_source"}],"event_type":"other","information_gaps":["The article text does not clearly specify the full 24h range endpoints (only one value $0.02173 is shown).","The article does not provide the exact concentration percentage or wallet concentration details from Rugcheck.xyz.","No timestamp for the quoted price/BTC values is provided in the cleaned text.","The signal headline (\u201cTrending: Make Aliens Great Again (MAGA)\u201d) and the provided market cap rank/trend score are not fully explained in the article text beyond the signal metadata."],"key_facts":["CoinGecko states MAGA\u2019s price is calculated in real time by aggregating the latest data across 2 exchanges and 3 markets.","CoinGecko states the aggregation uses a global volume-weighted average formula.","The text includes a BTC reference value: 0.062858 BTC.","The text includes a USD reference value: $0.004960.","The text includes a 24h range value: $0.02173.","The text says Rugcheck.xyz reports a risk of market manipulation due to large concentration of tokens held in one or more unidentified wallets.","The article advises: \u201cPlease exercise caution.\u201d"],"numeric_claims":[{"label":"Market cap rank","value":"994"},{"label":"Trend score","value":"2"},{"label":"BTC reference","value":"0.062858 BTC"},{"label":"USD reference","value":"0.004960"},{"label":"24h range (as shown)","value":"0.02173"}],"primary_claim":"MAGA\u2019s price is calculated in real time by aggregating the latest data across 2 exchanges and 3 markets using a global volume-weighted average formula.","relevance_score":0.42,"sentiment":"mixed","source_quality":"low","summary":"CoinGecko describes how the MAGA (Make Aliens Great Again) price is calculated using real-time, volume-weighted data across multiple exchanges/markets. The article also flags a potential market manipulation risk based on Rugcheck.xyz due to token concentration in unidentified wallets.","topics":["price_calculation_method","market_data_aggregation","market_manipulation_risk","token_concentration","alerts"]},"source":"CoinGecko Trending","source_domain":"coingecko.com","summary":"Market cap rank 994, trend score 2","tickers":["MAGA","MAGAUSD"],"title":"Trending: Make Aliens Great Again (MAGA)","url":"https://www.coingecko.com/en/coins/make-aliens-great-again"}}

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