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-09T16:35:58.987693+00:00","dedupe_key":"signal_enriched:discovery_unusual_volume_delta:3bacd7cc5f088ad6","evidence_event_ids":["evt_de8b20157d91"],"signal_type":"discovery_unusual_volume_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://www.nasdaq.com/articles/what-polkadot-actually-does-and-why-matters-its-long-term-value","as_of":"2026-04-09T16:35:58.987693+00:00","canonical_url":"https://www.fool.com/investing/2026/04/09/what-dot-actually-does-and-why-that-matters/","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/what-polkadot-actually-does-and-why-matters-its-long-term-value","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_ef2dbcf72a8b8a52","canonical_host":"fool.com","canonical_is_aggregator":false,"canonical_url":"https://www.fool.com/investing/2026/04/09/what-dot-actually-does-and-why-that-matters/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-10T01:14:11.144650+00:00","extraction_method":"heuristic","fetched_description":"Key PointsPolkadot is a \"chain of chains\" that lets different blockchains communicate with each other.","fetched_title":"What Polkadot Actually Does -- and Why That Matters for Its Long-Term Value | Nasdaq","final_url":"https://www.nasdaq.com/articles/what-polkadot-actually-does-and-why-matters-its-long-term-value","html_truncated":false,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/what-polkadot-actually-does-and-why-matters-its-long-term-value","source_event_id":"evt_de8b20157d91","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"7ecba392f4eac8e2","kind":"unusual_volume","published_at":"2026-04-09T15:57:00+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.72,"dates_mentioned":["April 09, 2026"],"entities":[{"asset_class":"cryptocurrency","name":"Polkadot","relevance":"high","symbol":"DOT","type":"crypto_network"},{"asset_class":"cryptocurrency","name":"DOT","relevance":"high","symbol":"DOT","type":"token"},{"asset_class":"crypto_service","name":"Chainlink","relevance":"medium","symbol":"","type":"blockchain_service"},{"asset_class":"blockchain","name":"Ethereum","relevance":"medium","symbol":"","type":"blockchain"},{"asset_class":"blockchain","name":"Bitcoin","relevance":"medium","symbol":"","type":"blockchain"},{"asset_class":"media","name":"The Motley Fool","relevance":"medium","symbol":"","type":"publisher"}],"event_type":"other","information_gaps":["No unusual volume delta details are present in the provided text (no ticker-specific volume ratio vs average, no baseline volume, and no direction).","No explicit catalyst for any volume change is stated; the article is explanatory/opinion about Polkadot\u2019s long-term value rather than a market-move report.","The signal type suggests a volume anomaly, but the article text does not confirm or explain such an anomaly."],"key_facts":["Polkadot is described as a \u201cchain of chains\u201d that lets different blockchains communicate with each other.","The DOT token is described as the backbone of Polkadot\u2019s system.","Parachains are described as connected to a hub that can transfer data and monetary value between parachains.","The article claims Polkadot provides a consistent platform for app developers to connect to other blockchains and cryptocurrencies.","The article gives an example of combining Ethereum smart contracts with Bitcoin value management and using Chainlink for weather data.","The article states Polkadot wraps bundled data exchanges in encrypted security layers.","The article describes a web3 vision where users own their data and human networks rather than large corporations.","The article says Polkadot was built to support decentralized alternatives to social media networks.","The article notes early web3 adoption examples: Brave (more than 100 million users) and Human Passport (over 2 million users).","The article says Polkadot was not included in The Motley Fool Stock Advisor\u2019s identified 10 best stocks to buy now."],"numeric_claims":[{"label":"Brave users","value":"more than 100 million"},{"label":"Human Passport users","value":"over 2 million"}],"primary_claim":"Polkadot is a \u201cchain of chains\u201d network where parachains connected to the DOT token can transfer data and value between chains, enabling developers to build interoperable apps.","relevance_score":0.35,"sentiment":"mixed","source_quality":"high","summary":"The article explains Polkadot\u2019s \u201cchain of chains\u201d architecture and argues it could benefit if web3 adoption accelerates. It does not provide any data about unusual trading volume or a specific volume ratio for DOT.","topics":["Polkadot architecture","interoperability","parachains","web3","developer platform","decentralized social networks","DeFi","user-owned data"]},"source":"Nasdaq Markets","source_domain":"fool.com","summary":"Key PointsPolkadot is a \"chain of chains\" that lets different blockchains communicate with each other.","tickers":[],"title":"What Polkadot Actually Does -- and Why That Matters for Its Long-Term Value","url":"https://www.fool.com/investing/2026/04/09/what-dot-actually-does-and-why-that-matters/"}}

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