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.

728,802 rows

Sources in this table

uw_flow_alerts728,802 rows

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:alert_rule = RepeatedHits×endpoint = /api/option-trades/flow-alerts×ticker = W×

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

2024c845-25c1-4bfc-848a-d1b13d219ec0	2026-10-02 15:38	2026-10-02 15:38	2026-10-02 15:38	W	W261120P00115000	put	115.0000	2026-11-20	19.3000	19.3000	20.1000	100.6150	11580.00	0.00	11580.00	6	5	12	2456	0.00488599348534202	0.705946081609884	0.709218030293808	true	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Consumer Cyclical	11744004308.00	2026-11-04	premarket	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-10-02T19:39:36.083365Z"}	2026-10-02	2026-10-02 21:15	2026-10-02 21:15
9a8449d9-02c8-4276-85ba-974a6403226f	2026-10-01 13:50	2026-10-01 13:49	2026-10-01 13:49	W	W261009P00097000	put	97.0000	2026-10-09	1.9000	1.5200	2.3900	101.0000	19000.00	570.00	2280.00	100	20	604	59	10.2372881355932	0.644765162568782	0.644765162568782	false	false	false
4d0c3346-9db1-460b-a901-44d83b937c83	2026-10-01 13:47	2026-10-01 13:47	2026-10-01 13:47	W	W261009P00099000	put	99.0000	2026-10-09	2.4600	2.3200	2.6000	101.8300	17712.00	0.00	7872.00	72	18	116	1	116	0.630980662890828	0.630980662890828	false	false	false
34a98ade-b325-4638-9733-a704aacae156	2026-10-01 11:57	2026-10-01 11:57	2026-10-01 11:57	W	W261030P00099000	put	99.0000	2026-10-30	5.7500	5.5500	5.8500	100.1200	17825.00	575.00	17250.00	31	12	34	18	1.88888888888889	0.576999782775853	0.576999782775853	false	false	false
255ed26f-6d71-4791-9d48-db53827dc606	2026-10-01 11:57	2026-10-01 11:57	2026-10-01 11:57	W	W261030P00100000	put	100.0000	2026-10-30	6.2500	6.2500	6.3500	100.1200	41250.00	0.00	41250.00	66	17	99	2224	0.0445143884892086	0.576308842355791	0.576308842355791	false	false	false
f3b02c7e-773a-4513-a84d-92b22004d8ec	2026-09-30 14:53	2026-09-30 14:53	2026-09-30 14:53	W	W261120P00095000	put	95.0000	2026-11-20	6.4000	6.4000	6.5500	103.0000	67862.00	0.00	67862.00	106	23	338	587	0.575809199318569	0.696651510813949	0.696651510813949	false	false	false
7a48042c-97fd-4a99-93e9-5268fa1d953c	2026-09-30 14:42	2026-09-30 14:41	2026-09-30 14:41	W	W261002P00103000	put	103.0000	2026-10-02	1.8000	1.8000	2.2600	103.5600	33660.00	0.00	33660.00	187	5	188	5	37.6	0.682704701658794	0.681602461924208	false	false	false
b2ad163b-3f3f-4e86-8939-9643901b2452	2026-09-30 12:27	2026-09-30 12:27	2026-09-30 12:27	W	W261120C00115000	call	115.0000	2026-11-20	6.9000	6.9000	7.0000	104.0750	15180.00	0.00	15180.00	22	7	28	106	0.264150943396226	0.696039589974448	0.696039589974448	false	false	false
7544f9d5-2fc0-4c2a-b729-e8cc6b4a5fb4	2026-09-30 11:37	2026-09-30 11:36	2026-09-30 11:36	W	W261120P00095000	put	95.0000	2026-11-20	6.2500	6.2500	6.3000	103.8750	52536.00	0.00	52536.00	84	22	225	587	0.383304940374787	0.697948686568615	0.697948686568615	false	false	false
1f88c840-7ae3-49ee-ab7c-8645b84c52a2	2026-09-30 11:36	2026-09-30 11:36	2026-09-30 11:36	W	W261120C00110000	call	110.0000	2026-11-20	8.6000	8.5000	8.6000	103.8750	108350.00	107500.00	850.00	126	6	145	675	0.214814814814815	0.702059148355834	0.695589263063622	false	false	false
895ba022-30e2-4159-a357-f1a8b0ace5f6	2026-09-30 10:12	2026-09-30 10:12	2026-09-30 10:12	W	W261120C00100000	call	100.0000	2026-11-20	14.0500	13.5500	14.1500	105.0000	514225.00	504395.00	9830.00	366	50	373	273	1.36630036630037	0.704883364556215	0.704883364556215	false	false	false
38ba7a3d-60a6-4e5e-8e3f-0c1efdaf72d9	2026-09-29 14:38	2026-09-29 14:38	2026-09-29 14:38	W	W261218C00110000	call	110.0000	2026-12-18	8.8000	8.5000	8.8500	100.0000	81835.00	80960.00	875.00	93	20	95	200	0.475	0.641055745458189	0.638380346991574	false	false	false
6fe99e25-500d-44f8-b40a-631de1e5d728	2026-09-29 10:31	2026-09-29 10:31	2026-09-29 10:31	W	W270219P00100000	put	100.0000	2027-02-19	14.6000	14.3500	14.9000	99.7195	14600.00	8760.00	5840.00	10	5	20	22	0.909090909090909	0.623045864438547	0.623045864438547	false	false	false
eaed390c-246b-4c7f-9522-109a9444d528	2026-09-28 15:38	2026-09-28 15:38	2026-09-28 15:38	W	W261016C00111000	call	111.0000	2026-10-16	1.5400	1.3500	1.5400	99.0000	96712.00	96712.00	0.00	628	52	628	14	44.8571428571429	0.590228603611226	0.590228603611226	false	false	false
692d5217-a3c5-4ca9-a85e-fbf26578fd0e	2026-09-28 10:58	2026-09-28 10:58	2026-09-28 10:58	W	W270115P00090000	put	90.0000	2027-01-15	8.4000	8.0500	8.6000	97.4600	28560.00	25200.00	3360.00	34	5	72	1005	0.0716417910447761	0.605248602418107	0.605248602418107	false	false	false
ba2296a7-d9c8-4068-9a33-684281cefa48	2026-09-25 13:38	2026-09-25 13:38	2026-09-25 13:38	W	W270115C00105000	call	105.0000	2027-01-15	11.0000	10.8000	11.1500	98.0000	70400.00	5500.00	64900.00	64	5	1372	9645	0.142249870399171	0.603730102363973	0.603730102363973	false	false	false
7931f6f5-d3b4-4c57-802d-1f1971a15561	2026-09-25 13:38	2026-09-25 13:38	2026-09-25 13:38	W	W270115C00105000	call	105.0000	2027-01-15	11.0000	10.8000	11.1500	98.0000	170500.00	61600.00	108900.00	155	5	1308	9645	0.135614307931571	0.602567290993617	0.602567290993617	false	false	false
0c63cfe0-024f-481c-8511-0eba2910d2f0	2026-09-25 13:20	2026-09-25 13:20	2026-09-25 13:20	W	W270115C00105000	call	105.0000	2027-01-15	11.0000	11.0000	11.3500	98.0000	196900.00	0.00	196900.00	179	6	481	9645	0.0498703991705547	0.602334697971273	0.602799873720821	false	false	false
295e53bd-d8b8-4d78-b046-5f9e6e7036c2	2026-09-25 12:59	2026-09-25 12:59	2026-09-25 12:59	W	W270115C00105000	call	105.0000	2027-01-15	11.0000	10.8000	11.7000	98.4950	299200.00	53900.00	150700.00	272	9	300	9645	0.031104199066874	0.603148728583305	0.603148728583305	false	false	false
65d2fb0d-45db-420a-852c-4db30afe2128	2026-09-25 12:31	2026-09-25 12:31	2026-09-25 12:31	W	W270115C00140000	call	140.0000	2027-01-15	3.3500	3.1000	3.3500	99.7400	15075.00	15075.00	0.00	45	8	104	894	0.116331096196868	0.600278792055587	0.600278792055587	true	false	false
64b95c93-b6f3-4dd2-a772-ce65961811b1	2026-09-25 12:25	2026-09-25 12:25	2026-09-25 12:25	W	W261016C00103000	call	103.0000	2026-10-16	3.7500	3.5000	3.7500	99.2900	15744.00	15744.00	0.00	42	13	44	3	14.6666666666667	0.549359969907158	0.549359969907158	false	false	false
14b1652e-501a-420a-848b-94cb59e05672	2026-09-24 12:00	2026-09-24 12:00	2026-09-24 12:00	W	W260925C00099000	call	99.0000	2026-09-25	0.5600	0.5600	0.7400	96.1400	15625.00	57.00	15568.00	279	35	283	16	17.6875	0.783567504480873	0.783567504480873	false	false	false
5c269374-f16b-4edf-9b1d-4a9857fff693	2026-09-24 11:54	2026-09-24 11:54	2026-09-24 11:54	W	W260925P00096000	put	96.0000	2026-09-25	1.4800	1.4800	1.6600	96.1700	14060.00	0.00	14060.00	95	19	146	136	1.07352941176471	0.781889860535457	0.781889860535457	false	false	false
da35432e-5558-4612-a6c3-d8ce688dce79	2026-09-24 11:21	2026-09-24 11:20	2026-09-24 11:20	W	W261016C00105000	call	105.0000	2026-10-16	2.5200	2.5200	2.8800	96.8377	31501.00	0.00	31501.00	125	26	126	668	0.188622754491018	0.569051037554938	0.569051037554938	false	false	false
bef2a0bd-a5ca-45f7-911d-71d0d653baf6	2026-09-24 09:36	2026-09-24 09:36	2026-09-24 09:36	W	W260925C00098000	call	98.0000	2026-09-25	2.5900	2.0300	2.5900	99.3850	98937.00	98937.00	0.00	382	7	390	9	43.3333333333333	0.876973689500447	0.876973689500447	true	false	false
7442bbb3-eb4b-40cf-aefb-571de6b51acb	2026-09-23 15:53	2026-09-23 15:52	2026-09-23 15:52	W	W270115P00090000	put	90.0000	2027-01-15	8.0000	8.0000	9.2500	99.2700	14400.00	0.00	14400.00	18	6	31	968	0.0320247933884297	0.601624470551292	0.601624470551292	false	false	false
8a465066-a5f8-4c60-a0dc-6332f5f1b2f1	2026-09-23 15:28	2026-09-23 15:28	2026-09-23 15:28	W	W261002C00104000	call	104.0000	2026-10-02	1.7400	1.7400	2.1000	99.0000	21054.00	0.00	21054.00	121	38	124	21	5.90476190476191	0.573480267282088	0.573480267282088	false	false	false
394ca6bb-8170-4ac0-a6cd-13ecab72845f	2026-09-23 14:36	2026-09-23 14:36	2026-09-23 14:36	W	W270820P00100000	put	100.0000	2027-08-20	21.3500	20.9000	22.4000	99.9600	187880.00	40565.00	147315.00	88	9	88	21	4.19047619047619	0.633902935409112	0.633902935409112	false	false	false
d34ed91d-2362-4e47-94db-fbfce6d1ff33	2026-09-23 12:18	2026-09-23 12:18	2026-09-23 12:18	W	W261120P00095000	put	95.0000	2026-11-20	8.2000	8.1500	8.8000	99.0600	83640.00	61500.00	22140.00	102	5	624	146	4.27397260273973	0.676379854392761	0.676379854392761	false	false	false
33930cb4-2df5-4407-bb5a-c22562e5a48a	2026-09-23 12:17	2026-09-23 12:16	2026-09-23 12:16	W	W261120C00105000	call	105.0000	2026-11-20	8.5500	8.5000	9.0000	99.0600	41045.00	855.00	40190.00	48	10	51	1135	0.0449339207048458	0.681202895452436	0.681202895452436	true	false	false
5124af6b-7286-4d1b-9c25-0a48a53475a2	2026-09-23 11:01	2026-09-23 11:01	2026-09-23 11:01	W	W261016C00110000	call	110.0000	2026-10-16	2.5500	2.2200	2.5500	101.0200	27284.00	27284.00	0.00	107	7	668	132	5.06060606060606	0.560905651294849	0.559775645686649	false	false	false
18bf59a5-055d-4049-88cc-5b9f005b965e	2026-09-23 11:00	2026-09-23 11:00	2026-09-23 11:00	W	W261016P00097500	put	97.5000	2026-10-16	3.9500	3.7500	4.1000	101.0000	40685.00	3555.00	37130.00	103	14	268	423	0.633569739952719	0.569449973913522	0.569449973913522	true	false	false
60a89c37-67cf-4a4a-aed2-687dba24000f	2026-09-23 10:54	2026-09-23 10:54	2026-09-23 10:54	W	W261120C00110000	call	110.0000	2026-11-20	7.5500	7.5500	7.7000	100.0000	65685.00	0.00	65685.00	87	18	388	448	0.866071428571429	0.694323166016727	0.694323166016727	true	false	false
6f1eba8a-2db4-4f49-8fa9-4fe0b9b91cd8	2026-09-23 10:41	2026-09-23 10:41	2026-09-23 10:41	W	W261009C00112000	call	112.0000	2026-10-09	1.0300	0.9100	1.0300	98.2400	12360.00	12360.00	0.00	120	5	120	3	40	0.599014717741087	0.599014717741087	false	false	false
6d6195dc-9f04-4500-b70b-cb5599e19527	2026-09-23 10:41	2026-09-23 10:41	2026-09-23 10:41	W	W261016C00109000	call	109.0000	2026-10-16	2.1200	2.0000	2.1200	98.2400	94128.00	68688.00	0.00	444	6	509	0	0	0.575194180943632	0.575194180943632	true	false	false
21bacb5e-f8e2-4e27-ae6f-6a7a949ac895	2026-09-23 10:41	2026-09-23 10:41	2026-09-23 10:41	W	W261009C00108000	call	108.0000	2026-10-09	1.7200	1.6000	1.7200	98.2400	80668.00	80668.00	0.00	469	7	469	15	31.2666666666667	0.59955564580759	0.59955564580759	true	false	false
6e5298d1-72b4-48db-bac4-04cd16f908ba	2026-09-23 10:41	2026-09-23 10:41	2026-09-23 10:41	W	W261120P00097500	put	97.5000	2026-11-20	10.2000	9.6500	10.2000	98.3350	204000.00	204000.00	0.00	200	24	207	46	4.5	0.705719142609277	0.705719142609277	true	false	false
2b191a90-90df-4682-b9bc-0aa1c8e10c79	2026-09-23 10:35	2026-09-23 10:35	2026-09-23 10:35	W	W261120P00100000	put	100.0000	2026-11-20	11.2000	10.7500	11.4000	98.2700	134400.00	134400.00	0.00	120	21	142	1000	0.142	0.679836231296306	0.679836231296306	true	false	false
6ea127aa-9386-41d5-9cce-23387f039317	2026-09-23 10:35	2026-09-23 10:35	2026-09-23 10:35	W	W261120P00105000	put	105.0000	2026-11-20	14.1000	13.5000	14.1000	98.4300	12690.00	11280.00	0.00	9	7	12	883	0.0135900339750849	0.678543681491056	0.678543681491056	true	false	false
2dcb4908-acd6-462b-8786-7098d18bca12	2026-09-23 09:50	2026-09-23 09:50	2026-09-23 09:50	W	W261120P00095000	put	95.0000	2026-11-20	6.9000	6.9000	7.0000	102.5300	69000.00	0.00	12420.00	100	20	419	146	2.86986301369863	0.671226661393078	0.671226661393078	true	false	false
9f2a7cba-8ed2-438b-8e36-e7814de2e66c	2026-09-23 09:50	2026-09-23 09:50	2026-09-23 09:50	W	W261120P00095000	put	95.0000	2026-11-20	6.9000	6.9000	7.0000	102.2350	54510.00	0.00	54510.00	79	18	319	146	2.18493150684932	0.66463445730726	0.66463445730726	true	false	false
d45efa0e-8952-4229-be74-5cda1ea4724a	2026-09-23 09:49	2026-09-23 09:49	2026-09-23 09:49	W	W261120P00095000	put	95.0000	2026-11-20	6.9000	6.9000	7.0000	102.2300	45540.00	0.00	24840.00	66	14	227	146	1.55479452054795	0.664522218252821	0.664522218252821	false	false	false
8084bb92-b5cc-492a-8525-3ad38c88f78e	2026-09-23 09:49	2026-09-23 09:49	2026-09-23 09:49	W	W261120P00095000	put	95.0000	2026-11-20	6.7500	6.7500	7.0000	102.2500	66150.00	0.00	59400.00	98	22	120	146	0.821917808219178	0.654827415670138	0.654827415670138	false	false	false
2e13a2d5-9be9-435b-8a70-90a88ad01fbc	2026-09-23 09:49	2026-09-23 09:49	2026-09-23 09:49	W	W261120P00095000	put	95.0000	2026-11-20	6.7000	6.7000	7.0000	102.2350	12730.00	0.00	12060.00	19	5	22	146	0.150684931506849	0.651107717764344	0.651107717764344	false	false	false
b085f3c7-eebb-4c46-9df1-79db4bec009e	2026-09-23 09:40	2026-09-23 09:40	2026-09-23 09:40	W	W261218P00090000	put	90.0000	2026-12-18	5.5000	5.2000	5.5000	103.9000	14300.00	14300.00	0.00	26	6	41	71	0.577464788732394	0.613283062058852	0.613283062058852	true	false	false
ccb9181d-db88-43dd-a317-ef71880321bf	2026-09-22 13:03	2026-09-22 13:03	2026-09-22 13:03	W	W260925P00105000	put	105.0000	2026-09-25	1.4400	1.2300	1.4400	107.0000	20592.00	20592.00	0.00	143	6	147	15	9.8	0.616074399100387	0.616074399100387	true	false	false
24e252e4-cd3c-4bcc-baa6-39158141f756	2026-09-22 12:15	2026-09-22 12:14	2026-09-22 12:14	W	W261030P00100000	put	100.0000	2026-10-30	4.9500	3.9500	5.9500	107.3450	11880.00	7425.00	0.00	24	5	24	2033	0.0118052139695032	0.621598371634139	0.621598371634139	false	false	false
15cbfc6f-45e0-440f-bffb-1058be06b43d	2026-09-21 13:13	2026-09-21 13:13	2026-09-21 13:13	W	W261016C00115000	call	115.0000	2026-10-16	2.8500	2.8000	2.9400	106.3050	40470.00	32490.00	7980.00	142	5	353	444	0.795045045045045	0.534160523325766	0.534160523325766	false	false	false
0a5e0531-5afc-4ee7-9ef9-4f6979d77d07	2026-09-21 10:49	2026-09-21 10:49	2026-09-21 10:49	W	W261120C00110000	call	110.0000	2026-11-20	9.7000	9.7000	10.0500	106.0900	48500.00	0.00	48500.00	50	5	52	447	0.116331096196868	0.645781236747775	0.645781236747775	false	false	false
e6d6ce98-733d-4fe0-b46c-63a8a7ab0417	2026-09-18 15:05	2026-09-18 15:05	2026-09-18 15:05	W	W260925P00101000	put	101.0000	2026-09-25	2.3700	2.3700	2.6400	102.5100	111153.00	0.00	111153.00	469	8	469	6	78.1666666666667	0.551608676962152	0.551608676962152	false	false	false