Options flow alerts (market-wide)

core.flow_alerts

Every UW flow alert, on every ticker - untracked ones included, which is the point. Keyed on the vendor's alert id. `ticker` is verbatim (SPX weeklies arrive as SPXW). Not exportable: each alert carries the contract's bid and ask.

231,528 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts231,528 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:alert_rule = RepeatedHitsAscendingFill×ticker = CG×sorted by created_at ↑×

iduuid	created_at ↑timestamp with time zone	start_timetimestamp with time zone	end_timetimestamp with time zone	tickertext	option_symboltext	option_typetext	strikenumeric	expirydate	pricenumeric	bidnumeric	asknumeric	underlying_pricenumeric	total_premiumnumeric	total_ask_side_premnumeric	total_bid_side_premnumeric	total_sizebigint	trade_countinteger	volumebigint	open_interestbigint	volume_oi_rationumeric	iv_startnumeric	iv_endnumeric	has_sweepboolean	has_floorboolean	has_multilegboolean	has_singlelegboolean	all_opening_tradesboolean	alert_ruletext	rule_iduuid	expiry_countinteger	issue_typetext	sectortext	marketcapnumeric	next_earnings_datedate	er_timetext	missing_periscopeboolean	sourcetext	endpointtext	request_paramsjsonb	as_ofdate	vintage_tstimestamp with time zone	retrieved_attimestamp with time zone
3f397751-cb89-4593-b2f9-3754ef385d23	2026-08-18 10:05	2026-08-18 10:05	2026-08-18 10:05	CG	CG260918C00050000	call	50.0000	2026-09-18	1.3500	1.3500	1.5500	47.9300	52021.00	0.00	52021.00	385	32	444	28259	0.01571180862734	0.382406415697509	0.382406415697509	false	false	false	true	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	Common Stock	Financial Services	14901837612.00	2026-11-06	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-18T14:15:30.654866Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
ac7a7562-69e4-41b7-a60a-5c39914b26ab	2026-08-31 10:22	2026-08-31 10:21	2026-08-31 10:21	CG	CG260918C00050000	call	50.0000	2026-09-18	1.1500	1.0000	1.3000	48.7450	34440.00	18860.00	15580.00	300	10	301	29697	0.0101357039431592	0.376684907660664	0.381448538934493	false	false	false	true	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	Common Stock	Financial Services	14901837612.00	2026-11-06	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-31T14:41:39.850499Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
ff35543d-2e1d-4d84-bf9e-24d7128638c8	2026-09-09 13:08	2026-09-09 13:08	2026-09-09 13:08	CG	CG270115C00052500	call	52.5000	2027-01-15	1.6500	1.6000	1.8500	44.0000	164926.00	8250.00	156676.00	999	27	1001	1039	0.963426371511068	0.391240210523257	0.391240210523257	true	false	false	true	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	Common Stock	Financial Services	14901837612.00	2026-11-06	unknown	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-09T17:13:29.226295Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
dfec0acb-e147-45af-b499-c650ea9cbf90	2026-09-09 14:08	2026-09-09 14:08	2026-09-09 14:08	CG	CG270115C00052500	call	52.5000	2027-01-15	1.7000	1.6500	1.9000	44.4350	64977.00	0.00	64977.00	382	30	2234	1039	2.15014436958614	0.391942865580093	0.391942865580093	true	false	false	true	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	Common Stock	Financial Services	14901837612.00	2026-11-06	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-09T18:27:25.894507Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45