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.

281,039 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts281,039 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:alert_rule = RepeatedHitsDescendingFill×ticker = PEP×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
a7cbee04-f096-422e-b7a4-bb200a64032b	2026-09-16 11:50	2026-09-16 11:50	2026-09-16 11:50	PEP	PEP261016P00135000	put	135.0000	2026-10-16	3.4800	3.4500	3.5000	135.1000	131902.00	80842.00	51060.00	379	22	483	2814	0.171641791044776	0.243975287708318	0.243975287708318	false	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	Common Stock	Consumer Defensive	183359531902.00	2026-10-08	premarket	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-16T16:04:58.541898Z"}	2026-09-16	2026-09-16 21:15	2026-09-16 21:15
966036ea-8ac6-4e63-abf1-983139f78ee1	2026-09-16 12:50	2026-09-16 12:50	2026-09-16 12:50	PEP	PEP261016P00135000	put	135.0000	2026-10-16	3.5100	3.5000	3.5500	135.1300	79643.00	14193.00	65450.00	227	11	718	2814	0.255152807391613	0.248127391775331	0.248127391775331	false	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	Common Stock	Consumer Defensive	183359531902.00	2026-10-08	premarket	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-16T17:08:32.093964Z"}	2026-09-16	2026-09-16 21:15	2026-09-16 21:15
b6309627-0c6c-4211-bfd0-7e0cca46324b	2026-09-18 14:19	2026-09-18 14:19	2026-09-18 14:19	PEP	PEP260918P00145000	put	145.0000	2026-09-18	14.7900	14.7500	15.0000	130.1600	167134.00	0.00	167134.00	113	5	259	1142	0.226795096322242	4.56998501610046	4.59671567126774	false	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	Common Stock	Consumer Defensive	177094679651.00	2026-10-08	premarket	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-18T18:22:45.408265Z"}	2026-09-18	2026-09-18 21:15	2026-09-18 21:15
4e13bed2-1105-4922-9b8c-f5614fff5a01	2026-09-21 10:18	2026-09-21 10:18	2026-09-21 10:18	PEP	PEP261016C00130000	call	130.0000	2026-10-16	2.9500	2.9500	3.0000	128.5600	14752.00	0.00	14752.00	50	9	693	981	0.706422018348624	0.257960664247742	0.257212553118499	false	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	Common Stock	Consumer Defensive	176876297001.00	2026-10-08	premarket	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-21T14:20:57.602674Z"}	2026-09-21	2026-09-21 21:15	2026-09-21 21:15