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:sector = Consumer Defensive×ticker = SAM×

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
94010ed8-62e9-4871-8d28-e651ffb9f836	2026-09-21 10:29	2026-09-21 10:29	2026-09-21 10:29	SAM	SAM270319C00150000	call	150.0000	2027-03-19	32.2000	30.6000	33.9000	169.4250	8091860.00	0.00	8091860.00	2513	10	2515	3	838.333333333333	0.428759727715005	0.428759727715005	false	true	true	false	false	LowHistoricVolumeFloor	b356ec2b-92e1-458a-934a-7719f71c40bc	1	Common Stock	Consumer Defensive	1409538923.00	2026-10-22	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-21T14:32:01.820117Z"}	2026-09-21	2026-09-21 21:15	2026-09-21 21:15
a1025ba4-fbde-4f20-be46-b28a472a8b16	2026-09-14 13:36	2026-09-14 13:35	2026-09-14 13:35	SAM	SAM270319C00210000	call	210.0000	2027-03-19	10.6100	7.3000	12.6000	170.7950	31820.00	26420.00	5400.00	30	7	31	3	10.3333333333333	0.456537214306325	0.44467211419775	false	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	Common Stock	Consumer Defensive	1409045503.00	2026-10-22	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-14T17:44:35.656770Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
c639cf3a-6a86-49af-a1b0-71443bf06857	2026-09-08 11:43	2026-09-08 11:43	2026-09-08 11:43	SAM	SAM270319P00150000	put	150.0000	2027-03-19	10.5000	10.5000	13.3000	169.3200	31500.00	0.00	31500.00	30	10	30	4	7.5	0.43461962951048	0.43461962951048	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Consumer Defensive	1409045503.00	2026-10-22	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-08T16:00:45.446709Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
f5f7deaa-de97-4a52-b85b-b6f70c479f68	2026-09-01 10:56	2026-09-01 10:56	2026-09-01 10:56	SAM	SAM261218C00200000	call	200.0000	2026-12-18	7.2400	3.1000	7.4000	174.0500	21734.00	15209.00	0.00	30	5	30	62	0.483870967741935	0.408735656174673	0.40844115412282	false	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	Common Stock	Consumer Defensive	1409045503.00	2026-10-22	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-01T14:59:17.018627Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45