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.

375,978 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts375,978 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:alert_rule = RepeatedHitsDescendingFill×endpoint = /api/option-trades/flow-alerts×sector = Consumer Defensive×

iduuid	created_at ↓timestamp with time zone	start_timetimestamp with time zone	end_timetimestamp with time zone	tickertext	option_symboltext	option_typetext	strike

91f3fcfb-08e4-4c55-8655-5368d43d67f9	2026-09-23 15:54	2026-09-23 15:54	2026-09-23 15:54	COST	COST270115C00880000	call	880.0000	2027-01-15	65.2600	63.4000	65.3500	902.7650	58730.00	45735.00	12995.00	9	9	9	182	0.0494505494505494	0.233813744431674	0.233548435068901	false	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	Common Stock	Consumer Defensive	401215273979.00	2026-09-24	postmarket	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-23T19:57:58.068578Z"}	2026-09-23	2026-09-23 21:15	2026-09-23 21:15
45c8a13b-0866-45fa-9c90-710ed380c003	2026-09-23 15:54	2026-09-23 15:54	2026-09-23 15:54	COST	COST261218C00880000	call	880.0000	2026-12-18	58.1300	56.5000	59.2000	904.0000	29065.00	23255.00	5810.00	5	5	27	282	0.0957446808510638	0.231393003367246	0.231085627431398	true	false
b206d975-e06b-408d-9071-0b9c17255675	2026-09-23 15:36	2026-09-23 15:36	2026-09-23 15:36	CLX	CLX270115C00090000	call	90.0000	2027-01-15	3.9500	3.9000	4.1000	84.2700	19766.00	0.00	19766.00	50	5	415	753	0.551128818061089	0.310826465427171	0.310826465427171	false	false
ad9e7a60-1c99-4238-8acf-23f5716d821b	2026-09-23 14:53	2026-09-23 14:53	2026-09-23 14:53	COST	COST261023C00920000	call	920.0000	2026-10-23	19.4000	18.9000	19.5000	904.3600	29100.00	19450.00	9650.00	15	5	30	55	0.545454545454545	0.242663738958321	0.242663738958321	true	false
89fb6e9e-84b2-466f-9ed2-251a3f52dfae	2026-09-23 14:46	2026-09-23 14:46	2026-09-23 14:46	COST	COST261023C00950000	call	950.0000	2026-10-23	9.7700	8.4500	10.1000	904.0500	18565.00	6880.00	11685.00	19	7	45	47	0.957446808510638	0.243969262857673	0.242790671072326	true	false
ee8054bb-7a4d-4cd3-8d3a-48fc8937b920	2026-09-23 14:35	2026-09-23 14:35	2026-09-23 14:35	COST	COST261023P00855000	put	855.0000	2026-10-23	6.2800	6.0500	6.6000	902.9300	15060.00	4410.00	10650.00	24	6	32	82	0.390243902439024	0.233498219213829	0.232773423574458	true	false
7ca8b275-7a36-4409-a932-ef8dc6c2ab5e	2026-09-23 14:32	2026-09-23 14:32	2026-09-23 14:32	TGT	TGT260925P00157500	put	157.5000	2026-09-25	1.6200	1.5600	1.7900	157.3650	17169.00	972.00	16197.00	106	22	1058	1384	0.764450867052023	0.33755155986981	0.335399515130932	false	false
77723bf3-aa38-4415-aa1b-67dd8e47c421	2026-09-23 14:32	2026-09-23 14:32	2026-09-23 14:32	TGT	TGT260925P00157500	put	157.5000	2026-09-25	1.6000	1.5000	1.8000	157.4050	23485.00	0.00	23485.00	147	29	747	1384	0.539739884393064	0.339730456010887	0.33542781881772	false	false
315cb46d-94da-4291-b811-066e93da1629	2026-09-23 13:37	2026-09-23 13:37	2026-09-23 13:37	CASY	CASY261016C00660000	call	660.0000	2026-10-16	4.9400	4.9000	5.2000	605.9300	54870.00	8320.00	25970.00	111	13	127	19	6.68421052631579	0.351705208257565	0.351705208257565	false	false
9f523fd2-e1b9-4dd8-83be-62b6dfa23145	2026-09-23 13:28	2026-09-23 13:28	2026-09-23 13:28	VITL	VITL261120P00010000	put	10.0000	2026-11-20	1.0800	0.8000	1.1500	10.0000	10750.00	10750.00	0.00	100	5	215	83	2.59036144578313	0.800431123898093	0.800431123898093	false	false
51a4a096-3cd7-4d45-9764-daabe1835720	2026-09-23 12:35	2026-09-23 12:35	2026-09-23 12:35	APEI	APEI261016C00045000	call	45.0000	2026-10-16	0.6500	0.5500	0.6500	41.7050	12318.00	9728.00	120.00	190	29	1084	0	0	0.418820538961488	0.418820538961488	true	false
9116d1c9-95b7-4820-8ae5-b0f3c88a8ec7	2026-09-23 12:27	2026-09-23 12:27	2026-09-23 12:27	OLLI	OLLI270416C00080000	call	80.0000	2027-04-16	14.4600	13.6000	15.7000	83.3200	115702.00	0.00	115702.00	80	5	80	81	0.987654320987654	0.485260325793474	0.485260325793474	false	false
e0e6873d-e2bd-4a0e-842b-53c48231bc39	2026-09-23 11:55	2026-09-23 11:55	2026-09-23 11:55	PEP	PEP261218C00140000	call	140.0000	2026-12-18	2.5400	2.3500	2.5800	129.8800	28960.00	1270.00	9656.00	114	15	11517	3266	3.5263319044703	0.228103253092115	0.227712705919534	false	false
024e5403-4873-455d-934c-967e82b19331	2026-09-23 11:32	2026-09-23 11:32	2026-09-23 11:32	PEP	PEP261218C00140000	call	140.0000	2026-12-18	2.5300	2.4400	2.5500	129.8400	35981.00	13208.00	18472.00	142	11	10120	3266	3.09859154929577	0.228256402460398	0.227797052758794	false	false
08fc7eaa-e7ff-4f84-aa7d-63dce426fe50	2026-09-23 11:32	2026-09-23 11:31	2026-09-23 11:31	PEP	PEP261218C00140000	call	140.0000	2026-12-18	2.4900	2.4100	2.5100	129.8150	22155.00	1245.00	20910.00	89	7	8703	3266	2.66472749540723	0.226294673903771	0.225833401596482	false	false
476b722c-2d9d-4a00-8599-141f21c9a1b0	2026-09-23 10:45	2026-09-23 10:45	2026-09-23 10:45	PEP	PEP261120C00135000	call	135.0000	2026-11-20	3.5900	3.5500	3.6500	130.9049	62793.00	24838.00	37595.00	175	35	321	1277	0.251370399373532	0.239624597098842	0.239624597098842	false	false
48084f9a-76de-4b7d-9fa4-a776780bdb3e	2026-09-23 10:12	2026-09-23 10:12	2026-09-23 10:12	PEP	PEP261218C00140000	call	140.0000	2026-12-18	2.6400	2.6100	2.6600	130.2800	33579.00	4752.00	1322.00	127	15	5981	3266	1.83129210042866	0.227240093316147	0.226788904814567	false	false
95b686e5-f3db-4e6d-a600-7c78805338ef	2026-09-23 10:05	2026-09-23 10:05	2026-09-23 10:05	WMT	WMT280121C00110000	call	110.0000	2028-01-21	17.2300	16.9000	17.5000	110.0000	53413.00	53413.00	0.00	31	5	93	1225	0.0759183673469388	0.278453117007704	0.271709318047644	false	false
239edc94-b966-41f8-892b-57b2a83d2e1d	2026-09-23 10:03	2026-09-23 10:03	2026-09-23 10:03	CLX	CLX261016C00090000	call	90.0000	2026-10-16	1.3000	1.2500	1.3000	85.9000	12176.00	12176.00	0.00	94	12	136	1450	0.0937931034482759	0.321266138093008	0.318619330714378	false	false
efb48720-3367-42c9-97ad-94ab7d975eaf	2026-09-23 09:55	2026-09-23 09:55	2026-09-23 09:55	WMT	WMT261120C00115000	call	115.0000	2026-11-20	3.3500	3.3500	3.4000	110.5500	16418.00	338.00	16080.00	49	15	1114	9958	0.111869853384214	0.2796115373204	0.27904345459545	false	false
7e85c1d5-fd42-4685-a50a-d0eba6885bd9	2026-09-22 15:54	2026-09-22 15:54	2026-09-22 15:54	PM	PM261120C00185000	call	185.0000	2026-11-20	12.4000	11.8000	13.0000	191.0000	24808.00	2488.00	0.00	20	6	24	463	0.0518358531317495	0.267643944769428	0.266212907995606	false	false
3ae63a8c-3045-408c-856f-66f3e363fc5b	2026-09-22 15:44	2026-09-22 15:44	2026-09-22 15:44	HIMS	HIMS261016P00031000	put	31.0000	2026-10-16	2.2700	2.2000	2.2900	30.7800	17011.00	17011.00	0.00	75	5	193	619	0.311793214862682	0.697918020004481	0.694735648906969	false	false
68181b2d-703e-4273-b3b1-689b9da3e340	2026-09-22 15:39	2026-09-22 15:39	2026-09-22 15:39	ELF	ELF261002C00101000	call	101.0000	2026-10-02	4.2000	4.0500	4.2000	101.7300	85658.00	85658.00	0.00	204	25	208	33	6.3030303030303	0.563052149615865	0.563052149615865	false	false
02ecab11-76bb-4fa5-88b7-bf6c1630e019	2026-09-22 15:39	2026-09-22 15:39	2026-09-22 15:39	ELF	ELF261002C00099000	call	99.0000	2026-10-02	5.3400	5.2000	5.7000	101.8400	58770.00	58235.00	535.00	110	17	110	6	18.3333333333333	0.568239024796106	0.55709410611991	false	false
54070eb9-b673-4562-9161-5befa31d2015	2026-09-22 15:12	2026-09-22 15:12	2026-09-22 15:12	PEP	PEP261218C00140000	call	140.0000	2026-12-18	2.6500	2.6400	2.6700	131.0200	18539.00	0.00	18539.00	70	9	606	940	0.64468085106383	0.215504202369739	0.215063724459459	false	false
a6fb2ac0-4eab-47f9-9f30-db6da421b9a9	2026-09-22 14:53	2026-09-22 14:53	2026-09-22 14:53	COST	COST261002C00935000	call	935.0000	2026-10-02	6.1900	5.3000	6.4500	899.9600	14850.00	14235.00	615.00	24	16	106	130	0.815384615384615	0.30440250475219	0.303317859383407	true	false
813f3751-6e2f-4ccd-94c7-9cdaac03465e	2026-09-22 14:31	2026-09-22 14:31	2026-09-22 14:31	PEP	PEP261120P00135000	put	135.0000	2026-11-20	6.8000	6.7500	6.8500	130.7050	16321.00	15641.00	0.00	24	5	57	2839	0.0200774920746742	0.231872952900577	0.231383229383045	false	false
22e8c5e0-1612-4c34-9919-3c7293f9e915	2026-09-22 13:48	2026-09-22 13:48	2026-09-22 13:48	COST	COST260925P00897500	put	897.5000	2026-09-25	13.5000	13.0000	13.7500	898.2500	22958.00	22958.00	0.00	17	5	42	223	0.188340807174888	0.431973668111935	0.431973668111935	false	false
cb5034d7-6b21-4a42-82b5-496fa579868e	2026-09-22 13:10	2026-09-22 13:10	2026-09-22 13:10	HIMS	HIMS260925C00034000	call	34.0000	2026-09-25	0.2400	0.2400	0.2700	31.3000	25896.00	0.00	25896.00	1062	44	24953	2384	10.4668624161074	0.944975361554754	0.93140736977461	true	false
7a1f19f7-6570-441e-9923-177b10391a71	2026-09-22 13:03	2026-09-22 13:03	2026-09-22 13:03	COST	COST270319C01000000	call	1000.0000	2027-03-19	30.0700	30.0000	30.3500	901.0000	30067.00	3010.00	27057.00	10	5	30	418	0.0717703349282297	0.234641837181611	0.234554686360387	false	false
11a16355-030e-4dc9-a581-a0cc14ff92db	2026-09-22 12:35	2026-09-22 12:35	2026-09-22 12:35	BUD	BUD270115C00090000	call	90.0000	2027-01-15	1.0500	1.0000	1.1000	78.0700	38565.00	660.00	37905.00	367	17	367	1563	0.234804862444018	0.246548826097535	0.24302895083139	false	false
b3e8e169-b64a-43bb-a43d-c238babac143	2026-09-22 11:38	2026-09-22 11:38	2026-09-22 11:38	WMT	WMT261016C00110000	call	110.0000	2026-10-16	2.0900	2.0900	2.1700	108.7150	27380.00	0.00	27380.00	131	8	2282	15291	0.149238113923223	0.229941098264015	0.229034762004624	false	false
5b25fb35-0da2-4596-8980-d832ea5aba36	2026-09-22 11:36	2026-09-22 11:35	2026-09-22 11:35	WMT	WMT270617C00105000	call	105.0000	2027-06-17	13.7500	13.6000	14.0000	108.8151	31632.00	20625.00	9632.00	23	7	54	1496	0.036096256684492	0.271662790163974	0.271370366825508	false	false
80d83dcb-0dd2-4fec-aea3-2b991e1761e9	2026-09-22 11:28	2026-09-22 11:28	2026-09-22 11:28	KR	KR261016P00059000	put	59.0000	2026-10-16	1.1900	1.0600	1.1900	59.0000	12934.00	12244.00	690.00	109	41	109	1	109	0.255877769057631	0.248449554864448	false	false
02ead325-4e75-4366-9b7e-c110b1d1a28c	2026-09-22 11:08	2026-09-22 11:08	2026-09-22 11:08	HIMS	HIMS260925P00033000	put	33.0000	2026-09-25	2.6900	2.6300	2.7400	30.0000	10777.00	8887.00	0.00	40	7	40	130	0.307692307692308	0.893616994825333	0.907885529067254	false	false
256ef0b2-260c-404d-ac7d-73f1e1e2614c	2026-09-22 11:05	2026-09-22 11:05	2026-09-22 11:05	KO	KO261218C00092500	call	92.5000	2026-12-18	1.9100	1.9100	1.9900	88.4200	53321.00	0.00	53321.00	279	10	293	3951	0.0741584409010377	0.186115785762113	0.185500074386658	false	false
027216cf-140a-41ce-8085-50dacfda9d32	2026-09-22 11:02	2026-09-22 11:02	2026-09-22 11:02	ADM	ADM261120P00085000	put	85.0000	2026-11-20	5.4000	5.2000	5.5000	83.3300	185745.00	185745.00	0.00	344	36	356	26	13.6923076923077	0.358966291697084	0.358966291697084	false	false
09c4a8e8-f632-437a-90d8-2c3116277fe9	2026-09-22 10:48	2026-09-22 10:48	2026-09-22 10:48	COST	COST261218C00960000	call	960.0000	2026-12-18	22.1200	21.8000	22.9500	902.3100	11062.00	0.00	11062.00	5	5	17	451	0.0376940133037694	0.232588463472309	0.232588463472309	false	false
dbd38575-c1ec-4cbf-bb25-dfadcee153cc	2026-09-22 10:44	2026-09-22 10:44	2026-09-22 10:44	WMT	WMT260925C00110000	call	110.0000	2026-09-25	0.5000	0.5000	0.5200	108.5950	23330.00	780.00	22550.00	466	18	5427	32451	0.167236756956642	0.270190331749847	0.264405864825021	false	false
e895dc55-c9fd-4a9e-9840-d394f7eb35c3	2026-09-22 10:37	2026-09-22 10:36	2026-09-22 10:36	COCO	COCO261120C00065000	call	65.0000	2026-11-20	3.0500	2.2500	3.4000	59.4700	44490.00	3100.00	35390.00	146	19	148	1	148	0.520017550317954	0.519317033535941	false	false
28d168e4-8dd8-4cc2-8cd9-d9fa2c0140b1	2026-09-22 10:36	2026-09-22 10:36	2026-09-22 10:36	WMT	WMT270115C00097500	call	97.5000	2027-01-15	13.8600	13.8000	14.0500	108.1050	138580.00	0.00	138580.00	100	9	699	1101	0.634877384196185	0.270575439595182	0.270575439595182	false	false
4cd9dd75-ad64-4f8a-a1e0-c9b6525b9d83	2026-09-22 10:29	2026-09-22 10:29	2026-09-22 10:29	HIMS	HIMS260925C00034000	call	34.0000	2026-09-25	0.1300	0.1300	0.1600	30.4250	13444.00	0.00	13444.00	1000	47	17544	2384	7.35906040268456	0.969781274835653	0.950439966615668	true	false
c531d3e9-49e1-44d4-b687-007a4e60f78e	2026-09-22 10:20	2026-09-22 10:20	2026-09-22 10:20	HIMS	HIMS260925C00034000	call	34.0000	2026-09-25	0.1500	0.1400	0.1700	30.4200	20641.00	15.00	20626.00	1376	40	15601	2384	6.54404362416107	1.00127127577381	0.989607993203035	true	false
b0f49fdd-174f-4349-a160-887f65fb8e3c	2026-09-22 10:07	2026-09-22 10:07	2026-09-22 10:07	HIMS	HIMS260925C00027000	call	27.0000	2026-09-25	3.0200	2.9400	3.2000	29.9300	14472.00	0.00	14472.00	48	6	62	205	0.302439024390244	0.82531101733331	0.82531101733331	false	false
53d6904f-cd55-495a-909f-b9cecdb1ee10	2026-09-22 09:55	2026-09-22 09:55	2026-09-22 09:55	COST	COST261023P00880000	put	880.0000	2026-10-23	14.8200	14.0000	15.3500	896.4850	80023.00	49033.00	29500.00	54	7	57	56	1.01785714285714	0.226876135591268	0.228824718314346	true	false
b4a3c284-baac-4ce5-923c-f9c041e98c0e	2026-09-22 09:55	2026-09-22 09:55	2026-09-22 09:55	COST	COST261016P00917500	put	917.5000	2026-10-16	33.3400	32.7500	33.9000	896.6000	23341.00	3345.00	19996.00	7	5	26	0	0	0.248443213740966	0.246737487406869	true	false
c8d0d286-1668-4880-afd4-b58c603ee637	2026-09-22 09:37	2026-09-22 09:37	2026-09-22 09:37	HIMS	HIMS260925C00028000	call	28.0000	2026-09-25	2.2000	2.1500	2.3100	29.9200	16525.00	11221.00	1989.00	75	5	321	8022	0.0400149588631264	0.907328135067069	0.893985973474367	false	false
59f7f786-8a17-4ea1-ad12-a3b7e1bd6121	2026-09-21 15:51	2026-09-21 15:51	2026-09-21 15:51	MO	MO261016P00069000	put	69.0000	2026-10-16	1.6700	1.5300	1.9300	68.5900	27752.00	671.00	2365.00	166	6	192	0	0	0.220126513146852	0.218372885968659	true	false
23fabb1a-bf7f-4b17-8b60-1c5ae642b1c2	2026-09-21 15:33	2026-09-21 15:33	2026-09-21 15:33	SJM	SJM270115P00120000	put	120.0000	2027-01-15	7.1300	7.1000	7.4000	119.0000	52018.00	12958.00	39060.00	73	19	94	150	0.626666666666667	0.297606122524377	0.297606122524377	false	false
3ba4024c-c10b-4e5e-8ea6-c536e7ec2f9e	2026-09-21 15:27	2026-09-21 15:27	2026-09-21 15:27	COST	COST261030P00860000	put	860.0000	2026-10-30	9.8300	9.8000	10.2500	899.2300	237790.00	37810.00	199980.00	242	25	256	38	6.73684210526316	0.227082754110071	0.227082754110071	false	false