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 = EL×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
6e2a6b60-7cc6-4024-9d7a-1b7bf31fd611	2026-08-21 10:51	2026-08-21 10:51	2026-08-21 10:51	EL	EL260918C00105000	call	105.0000	2026-09-18	1.9700	1.9500	2.0000	100.5300	41090.00	19300.00	21790.00	209	14	236	772	0.305699481865285	0.327986264402203	0.327986264402203	false	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	Common Stock	Consumer Defensive	24288943923.00	2026-10-29	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-21T15:04:10.571442Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
e2e0de6b-8ecb-4f1d-9817-e25c1f87ceed	2026-08-24 14:45	2026-08-24 14:45	2026-08-24 14:45	EL	EL260918C00105000	call	105.0000	2026-09-18	2.9000	2.9000	3.2000	103.7150	37142.00	300.00	36842.00	128	9	234	827	0.282950423216445	0.320148846216003	0.310887159949081	false	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	Common Stock	Consumer Defensive	24288943923.00	2026-10-29	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-24T18:49:58.488781Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
6734820e-3183-41ca-933d-95581d493382	2026-08-25 11:10	2026-08-25 11:10	2026-08-25 11:10	EL	EL260918C00100000	call	100.0000	2026-09-18	4.9100	4.9000	5.6000	103.4400	12271.00	0.00	12271.00	25	5	28	1723	0.016250725478816	0.258090054485395	0.255848527002582	false	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	Common Stock	Consumer Defensive	24288943923.00	2026-10-29	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-25T15:21:33.843586Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
e8ad2bcd-4a0e-4632-9d92-14f2f1ce392a	2026-08-27 10:09	2026-08-27 10:08	2026-08-27 10:08	EL	EL261016P00120000	put	120.0000	2026-10-16	14.7000	13.8000	15.1000	106.2635	29394.00	29394.00	0.00	20	8	1102	500	2.204	0.360564540766357	0.359682334719928	false	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	Common Stock	Consumer Defensive	24288943923.00	2026-10-29	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-27T14:11:49.813441Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
a8fb13f7-b43d-4b8a-bc21-16828429f9c8	2026-08-27 11:34	2026-08-27 11:34	2026-08-27 11:34	EL	EL270319P00080000	put	80.0000	2027-03-19	2.9000	2.6000	2.9500	106.9400	87132.00	87132.00	0.00	300	11	300	1022	0.293542074363992	0.452228558363632	0.449942246812744	true	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	Common Stock	Consumer Defensive	24288943923.00	2026-10-29	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-27T15:44:11.413260Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
d43fdea7-715d-4538-860c-31b6f53a3a58	2026-08-28 11:41	2026-08-28 11:41	2026-08-28 11:41	EL	EL260918P00099000	put	99.0000	2026-09-18	1.5500	1.3500	1.5500	103.0000	76860.00	76860.00	0.00	496	41	496	118	4.20338983050847	0.335034340630645	0.335034340630645	false	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	Common Stock	Consumer Defensive	24288943923.00	2026-10-29	unknown	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-28T15:52:06.240394Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
bcb9c97e-fb11-4160-8b39-9bd52c193cfc	2026-08-31 13:48	2026-08-31 13:47	2026-08-31 13:47	EL	EL280121C00115000	call	115.0000	2028-01-21	16.9400	16.6000	17.5000	102.0000	33889.00	18636.00	8473.00	20	9	21	1264	0.0166139240506329	0.403613832583632	0.403404604729114	false	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	Common Stock	Consumer Defensive	24288943923.00	2026-10-29	unknown	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-31T18:25:38.432903Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
fcb1428f-3b95-4cbc-8328-6a9f8a1ee3c5	2026-09-02 11:36	2026-09-02 11:36	2026-09-02 11:36	EL	EL261218P00100000	put	100.0000	2026-12-18	7.3900	7.2000	7.4000	101.7500	12569.00	11839.00	0.00	17	9	29	411	0.0705596107055961	0.405985012599085	0.401299927296819	false	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	Common Stock	Consumer Defensive	24288943923.00	2026-10-29	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-02T15:49:54.253343Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
9d020b6f-e0b5-4298-84aa-a3915cc2bb66	2026-09-04 14:12	2026-09-04 14:11	2026-09-04 14:11	EL	EL261016C00115000	call	115.0000	2026-10-16	1.3000	1.2000	1.3000	104.0100	18052.00	18052.00	0.00	139	24	141	257	0.54863813229572	0.327544458376099	0.327544458376099	false	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	Common Stock	Consumer Defensive	24288943923.00	2026-10-29	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-04T18:34:11.376593Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
3d6fa672-a279-4823-b094-388f0673e4c3	2026-09-09 14:59	2026-09-09 14:58	2026-09-09 14:58	EL	EL260918P00097000	put	97.0000	2026-09-18	1.5500	1.2500	1.5500	98.8000	13630.00	13480.00	0.00	88	26	188	8	23.5	0.389672150814001	0.37920855116961	true	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	Common Stock	Consumer Defensive	24288943923.00	2026-10-29	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-09T19:27:55.926703Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
4b269db6-db4e-49ca-8a8a-b8d90edadebd	2026-09-15 15:48	2026-09-15 15:48	2026-09-15 15:48	EL	EL270319P00085000	put	85.0000	2027-03-19	5.6800	5.2000	5.7000	96.0000	27260.00	27260.00	0.00	48	14	137	107	1.2803738317757	0.436153461783787	0.436153461783787	false	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	Common Stock	Consumer Defensive	24288943923.00	2026-10-29	unknown	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500}	2026-09-15	2026-09-15 21:15	2026-09-15 21:15