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 = BAC×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
8898e1a7-945b-466f-a52d-efe0bf9032a1	2026-08-18 10:33	2026-08-18 10:33	2026-08-18 10:33	BAC	BAC261016P00062500	put	62.5000	2026-10-16	1.6700	1.6400	1.6800	64.0800	63115.00	59777.00	1167.00	378	59	387	5724	0.0676100628930818	0.250684354695433	0.250311358462585	true	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	Common Stock	Financial Services	415858745267.00	2026-10-14	premarket	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-18T14:49:07.673043Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
420af78f-1909-4fcf-b727-c3d623bf5d1c	2026-08-19 14:18	2026-08-19 14:18	2026-08-19 14:18	BAC	BAC261016P00062500	put	62.5000	2026-10-16	1.9600	1.9500	1.9800	63.1550	58726.00	0.00	58726.00	300	14	2101	12913	0.162704251529466	0.245241587212075	0.244222006460244	false	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	Common Stock	Financial Services	415858745267.00	2026-10-14	premarket	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-19T18:37:13.611011Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
5494f3d5-2590-40aa-a988-8c31fc0eaa49	2026-08-27 09:34	2026-08-27 09:34	2026-08-27 09:34	BAC	BAC261120P00067500	put	67.5000	2026-11-20	6.5000	6.5000	6.9500	61.4725	116410.00	0.00	116410.00	179	5	334	475	0.703157894736842	0.247336512361044	0.247336512361044	false	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	Common Stock	Financial Services	415858745267.00	2026-10-14	premarket	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-27T13:38:22.111482Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
26acffc8-2589-4595-9025-eec4664db38e	2026-08-28 09:33	2026-08-28 09:32	2026-08-28 09:32	BAC	BAC261016P00062500	put	62.5000	2026-10-16	2.6700	2.6000	2.6700	61.4700	196724.00	18423.00	85652.00	738	25	738	14701	0.0502006666213183	0.254472549988943	0.253356336128551	false	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	Common Stock	Financial Services	415858745267.00	2026-10-14	premarket	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-28T13:45:11.106617Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
2df3b25a-3c99-4401-82cd-65a2d6cf5c3d	2026-08-31 11:51	2026-08-31 11:51	2026-08-31 11:51	BAC	BAC260918P00060000	put	60.0000	2026-09-18	0.4400	0.4300	0.4600	62.1150	110645.00	29260.00	69235.00	2491	49	2681	18879	0.14200964034112	0.233808346104975	0.231431892786957	true	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	Common Stock	Financial Services	415858745267.00	2026-10-14	premarket	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-31T16:06:41.823379Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
ee478795-ce33-4b7a-8b90-bdda07f7c9a4	2026-09-02 13:04	2026-09-02 13:04	2026-09-02 13:04	BAC	BAC280121C00065000	call	65.0000	2028-01-21	7.2500	7.1000	7.2500	62.3050	128320.00	128320.00	0.00	177	15	178	6734	0.0264330264330264	0.23048994807717	0.23048994807717	true	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	Common Stock	Financial Services	415858745267.00	2026-10-14	premarket	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-02T17:36:40.694178Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
68994526-2c22-4f02-b257-0103e2370be3	2026-09-10 12:06	2026-09-10 12:05	2026-09-10 12:05	BAC	BAC261218P00065000	put	65.0000	2026-12-18	4.4800	4.4000	4.5000	62.3850	67238.00	67238.00	0.00	150	7	477	1766	0.270101925254813	0.263581644993051	0.262020913915347	false	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	Common Stock	Financial Services	415858745267.00	2026-10-14	premarket	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-10T16:13:08.333814Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
4c923196-5fdb-487c-81b5-fe8d97cda5d4	2026-09-21 15:40	2026-09-21 15:40	2026-09-21 15:40	BAC	BAC270319C00062500	call	62.5000	2027-03-19	2.5500	2.4900	2.5700	58.0220	15817.00	15306.00	511.00	62	11	243	2308	0.10528596187175	0.237638077983723	0.237638077983723	false	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	Common Stock	Financial Services	405299695235.00	2026-10-14	premarket	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-21T19:43:03.886437Z"}	2026-09-21	2026-09-21 21:15	2026-09-21 21:15