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.

566,287 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts566,287 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:alert_rule = RepeatedHits×ticker = SPX×

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

ab884180-80c1-4543-a3a7-85dd2f358a04	2026-09-28 15:59	2026-09-28 15:59	2026-09-28 15:59	SPX	SPX261016P06850000	put	6850.0000	2026-10-16	4.0000	3.8000	4.0000	7665.0000	20000.00	20000.00	0.00	50	8	150	4726	0.0317393144308083	0.267903751173196	0.267903751173196	true	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	—	—	—	—	—	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500}	2026-09-28	2026-09-28 21:15	2026-09-28 21:15
7f9b9195-5ab6-475f-8a49-313b7c77f6c0	2026-09-28 15:59	2026-09-28 15:59	2026-09-28 15:59	SPX	SPX261016P06850000	put	6850.0000	2026-10-16	4.0000	3.8000	4.0000	7665.0000	20000.00	20000.00	0.00	50	8	200	4726	0.0423190859077444	0.267903751173196	0.267903751173196	true	false	false	true
8d6361f4-b01b-4007-b26c-b45b5d0ccf84	2026-09-28 15:58	2026-09-28 15:58	2026-09-28 15:58	SPX	SPX261120P07505000	put	7505.0000	2026-11-20	90.3000	90.3000	90.5000	7660.0000	460530.00	0.00	460530.00	51	5	175	857	0.204200700116686	0.157137648980154	0.157137648980154	false	false	false	true
49bafee6-0711-4b24-8fc1-4db6940895d1	2026-09-28 15:58	2026-09-28 15:58	2026-09-28 15:58	SPX	SPX270617C08675000	call	8675.0000	2027-06-17	102.5000	102.5000	103.1000	7660.0000	61500.00	0.00	61500.00	6	5	570	1093	0.521500457456542	0.128837267449832	0.128837267449832	false	false	false	true
af65fb64-0a79-48dc-859d-f36ff69528a5	2026-09-28 15:58	2026-09-28 15:58	2026-09-28 15:58	SPX	SPX270917C08800000	call	8800.0000	2027-09-17	155.2000	154.5000	155.2000	7660.0000	155200.00	155200.00	0.00	10	5	1472	5442	0.270488790885704	0.135290167766153	0.135290167766153	false	false	false	true
ae0e5b98-0d8d-4ecc-9687-2bf0f49ce264	2026-09-28 15:58	2026-09-28 15:58	2026-09-28 15:58	SPX	SPX270617C08675000	call	8675.0000	2027-06-17	102.2000	102.2000	102.7000	7660.0000	112420.00	0.00	112420.00	11	5	503	1093	0.460201280878317	0.1287793694073	0.1287793694073	false	false	false	true
6b3413c4-f649-45c7-8ade-91390df25a65	2026-09-28 15:58	2026-09-28 15:57	2026-09-28 15:57	SPX	SPX270617C08675000	call	8675.0000	2027-06-17	102.2100	102.2000	102.7000	7660.0000	143100.00	0.00	143100.00	14	7	492	1093	0.450137236962489	0.128828733356218	0.128828733356218	false	false	false	true
f1b1c6a5-68be-4401-853b-b5123184477f	2026-09-28 15:57	2026-09-28 15:57	2026-09-28 15:57	SPX	SPX270617C08675000	call	8675.0000	2027-06-17	102.2000	102.1000	102.3000	7660.0000	81760.00	0.00	71540.00	8	5	458	1093	0.419030192131747	0.128871207453434	0.128871207453434	false	false	false	true
f8e06239-41c4-40b2-a17c-3f79d795cf16	2026-09-28 15:57	2026-09-28 15:57	2026-09-28 15:57	SPX	SPX270617C08675000	call	8675.0000	2027-06-17	102.0500	102.0000	102.7000	7682.0600	153070.00	0.00	153070.00	15	5	433	1093	0.39615736505032	0.128806038156623	0.128857570087159	false	false	false	true
e146e344-0d28-4491-bdb4-9ca9478253f3	2026-09-28 15:57	2026-09-28 15:57	2026-09-28 15:57	SPX	SPX270917C08800000	call	8800.0000	2027-09-17	154.7000	154.0000	154.7000	7681.1900	108290.00	108290.00	0.00	7	5	1387	5442	0.254869533259831	0.135265395169753	0.135265395169753	false	false	false	true
2e369dd7-d903-475e-b3b0-c293ef0dc894	2026-09-28 15:57	2026-09-28 15:57	2026-09-28 15:57	SPX	SPX270917C08800000	call	8800.0000	2027-09-17	154.4000	153.6000	154.4000	7680.6300	200720.00	200720.00	0.00	13	5	1378	5442	0.253215729511209	0.135204323819104	0.135204323819104	false	false	false	true
e84a31df-d538-4e08-879b-3efb0102a2d3	2026-09-28 15:57	2026-09-28 15:57	2026-09-28 15:57	SPX	SPX270617C08675000	call	8675.0000	2027-06-17	101.6000	101.6000	102.2000	7680.6500	193040.00	0.00	193040.00	19	6	407	1093	0.372369624885636	0.128761416862865	0.128761416862865	false	false	false	true
5731d977-f04a-4f6e-bbfe-4660d9adadb5	2026-09-28 15:56	2026-09-28 15:56	2026-09-28 15:56	SPX	SPX270617C08675000	call	8675.0000	2027-06-17	101.6000	101.6000	102.2000	7680.8900	101600.00	0.00	101600.00	10	6	388	1093	0.354986276303751	0.128733904739967	0.128733904739967	false	false	false	true
2bac4873-27a6-448d-a742-5d02ce20b724	2026-09-28 15:56	2026-09-28 15:56	2026-09-28 15:56	SPX	SPX261218P07400000	put	7400.0000	2026-12-18	104.3000	103.7000	104.3000	7679.2000	521500.00	521500.00	0.00	50	6	734	32615	0.0225049823700751	0.169706989776586	0.169706989776586	false	false	false	true
5337a8e8-7faa-4126-8125-a6d615d451be	2026-09-28 15:55	2026-09-28 15:55	2026-09-28 15:55	SPX	SPX270917C08800000	call	8800.0000	2027-09-17	153.8000	153.1000	153.8000	7678.9900	230700.00	230700.00	0.00	15	6	1248	5442	0.229327453142227	0.135137452755559	0.135137452755559	false	false	false	true
c5f60f54-f4ad-403d-b699-53b254af5673	2026-09-28 15:55	2026-09-28 15:55	2026-09-28 15:55	SPX	SPX270617C08675000	call	8675.0000	2027-06-17	101.4000	101.3000	101.5000	7680.0800	243360.00	0.00	212940.00	24	7	226	1093	0.206770356816102	0.128723448131478	0.128723448131478	false	false	false	true
7f7fddf7-0655-4975-b095-7a17a6e96bc6	2026-09-28 15:54	2026-09-28 15:54	2026-09-28 15:54	SPX	SPX270416P03000000	put	3000.0000	2027-04-16	5.1000	5.0000	5.1000	7680.5200	52530.00	52530.00	0.00	103	7	105	279	0.376344086021505	0.543043123814723	0.543043123814723	false	false	false	true
92702d7b-d90b-4c58-a7f6-98cc1e9e4d47	2026-09-28 15:52	2026-09-28 15:52	2026-09-28 15:52	SPX	SPX261120C07875000	call	7875.0000	2026-11-20	83.5000	83.1000	83.8000	7681.8800	835000.00	384100.00	450900.00	100	5	250	1245	0.200803212851406	0.12273613900937	0.12273613900937	false	false	false	true
4849d4d2-aa70-4faa-b144-7279d9183bbb	2026-09-28 15:50	2026-09-28 15:50	2026-09-28 15:50	SPX	SPX270319P06975000	put	6975.0000	2027-03-19	113.1600	112.9000	113.7000	7681.9400	79210.00	0.00	79210.00	7	6	74	1877	0.0394246137453383	0.203039062594031	0.203039062594031	false	false	false	true
c11aa372-3339-4bcc-a4d8-62bf9efd3cf0	2026-09-28 15:45	2026-09-28 15:45	2026-09-28 15:45	SPX	SPX261218P07740000	put	7740.0000	2026-12-18	196.5000	195.9000	196.6000	7684.0300	4126500.00	0.00	0.00	210	6	1854	878	2.11161731207289	0.141895704540455	0.141895704540455	false	false	false	true
946abc2b-cc35-4ea7-b92a-eb63935d910d	2026-09-28 15:45	2026-09-28 15:45	2026-09-28 15:45	SPX	SPX261218C07740000	call	7740.0000	2026-12-18	202.5000	202.2000	203.1000	7684.0300	4252500.00	0.00	0.00	210	6	1864	884	2.10859728506787	0.13459756042603	0.13459756042603	false	false	false	true
3a28858a-9da4-4a87-af59-df2d24c3ef93	2026-09-28 15:44	2026-09-28 15:44	2026-09-28 15:44	SPX	SPX270319P07625000	put	7625.0000	2027-03-19	237.6000	237.6000	238.4000	7683.2100	142560.00	0.00	142560.00	6	5	22	2102	0.0104662226450999	0.160570767338407	0.160570767338407	false	false	false	true
d9ac3e1c-097c-4f2c-af5a-bdb2e828a817	2026-09-28 15:36	2026-09-28 15:36	2026-09-28 15:36	SPX	SPX261218P05500000	put	5500.0000	2026-12-18	9.5000	9.3000	9.6000	7686.2800	10450.00	8550.00	1900.00	11	9	45	36807	0.00122259352840492	0.365671407737751	0.365671407737751	false	false	false	true
177a2fbf-8e51-42fb-9973-b9422c7eb9f0	2026-09-28 15:35	2026-09-28 15:35	2026-09-28 15:35	SPX	SPX261218P07300000	put	7300.0000	2026-12-18	85.5000	84.9000	85.5000	7689.1600	256500.00	256500.00	0.00	30	5	2286	28674	0.0797237915881984	0.178827191809604	0.178827191809604	false	false	false	true
2e13c5d8-be39-4909-aa44-a87128f3adbd	2026-09-28 15:14	2026-09-28 15:14	2026-09-28 15:14	SPX	SPX261218P06350000	put	6350.0000	2026-12-18	22.9000	22.6000	22.9000	7688.4600	263350.00	263350.00	0.00	115	6	513	5401	0.0949824106646917	0.273327904467399	0.273327904467399	false	false	false	true
207015cf-b225-46f8-8fd8-2997111d1514	2026-09-28 15:14	2026-09-28 15:13	2026-09-28 15:13	SPX	SPX261218P06350000	put	6350.0000	2026-12-18	22.9000	22.6000	22.9000	7688.4000	206100.00	206100.00	0.00	90	6	398	5401	0.0736900573967784	0.273319798997132	0.273319798997132	false	false	false	true
bd3a309d-6ff5-49fa-ae79-5e1cb2c6c2cc	2026-09-28 14:47	2026-09-28 14:46	2026-09-28 14:46	SPX	SPX261120P06750000	put	6750.0000	2026-11-20	19.4000	19.2000	19.5000	7698.3500	11640.00	9700.00	0.00	6	6	95	12792	0.00742651657285804	0.240946791616129	0.240946791616129	false	false	false	true
3ac3c668-fdbf-4244-99ce-f96305159628	2026-09-28 14:46	2026-09-28 14:46	2026-09-28 14:46	SPX	SPX261120P06750000	put	6750.0000	2026-11-20	19.4000	19.2000	19.5000	7698.6600	42680.00	29100.00	5820.00	22	6	87	12792	0.00680112570356473	0.241000259900341	0.241000259900341	false	false	false	true
3f8ee7cd-d34f-4b5b-9300-31f1d7f88a49	2026-09-28 14:46	2026-09-28 14:46	2026-09-28 14:46	SPX	SPX261120P07365000	put	7365.0000	2026-11-20	61.9000	61.8000	62.3000	7698.6700	142370.00	12380.00	129990.00	23	13	23	563	0.0408525754884547	0.171389632290694	0.171389632290694	false	false	false	true
fe053584-f3b7-4ac9-99ce-ee5dff45d272	2026-09-28 13:33	2026-09-28 13:33	2026-09-28 13:33	SPX	SPX261120P07100000	put	7100.0000	2026-11-20	35.3000	35.1000	35.6000	7680.0000	35300.00	0.00	35300.00	10	5	26	13134	0.00197959494441906	0.200571232231256	0.200571232231256	false	false	false	true
f35149eb-9f9c-4dac-99b5-03e43f13f03c	2026-09-28 12:52	2026-09-28 12:51	2026-09-28 12:51	SPX	SPX270319P04750000	put	4750.0000	2027-03-19	16.6000	16.2000	16.6000	7697.6400	24900.00	24900.00	0.00	15	6	15	426	0.0352112676056338	0.382735445487849	0.382735445487849	false	false	false	true
9d2d47d5-5fdd-429e-af15-d9df250c72ae	2026-09-28 12:47	2026-09-28 12:47	2026-09-28 12:47	SPX	SPX261218P07765000	put	7765.0000	2026-12-18	200.0000	199.3000	200.4000	7680.0000	11000000.00	0.00	0.00	550	10	2871	3936	0.729420731707317	0.141145592587717	0.141145592587717	false	false	false	true
47342051-c7b8-4b9e-9d39-d4d4621b8bbb	2026-09-28 12:47	2026-09-28 12:47	2026-09-28 12:47	SPX	SPX261218C07765000	call	7765.0000	2026-12-18	197.0000	196.0000	197.0000	7680.0000	10835000.00	0.00	0.00	550	10	2858	3769	0.75829132395861	0.133334498316202	0.133334498316202	false	false	false	true
1ac77ce8-d067-49c6-9cac-02bf68dd45a4	2026-09-28 12:47	2026-09-28 12:47	2026-09-28 12:47	SPX	SPX261120P07650000	put	7650.0000	2026-11-20	123.9500	123.5000	124.3000	7680.0000	12395000.00	0.00	0.00	1000	10	1038	5977	0.17366571858792	0.144482526331088	0.144482526331088	false	false	false	true
15131142-d6f0-4a02-8dde-93df9a0125d0	2026-09-28 12:39	2026-09-28 12:39	2026-09-28 12:39	SPX	SPX261218P07780000	put	7780.0000	2026-12-18	202.5000	203.7000	204.6000	7704.4000	810000.00	0.00	0.00	40	6	73	3137	0.0232706407395601	0.138907922064843	0.138907922064843	false	false	false	true
dc0f157e-6797-4371-85af-9b8f78cb4879	2026-09-28 12:27	2026-09-28 12:27	2026-09-28 12:27	SPX	SPX261218P07600000	put	7600.0000	2026-12-18	136.0000	135.5000	136.7000	7723.3700	95200.00	0.00	95200.00	7	5	1730	33534	0.0515894316216377	0.153337819891357	0.153337819891357	false	false	false	true
722fc6d4-b179-4335-8ca0-21346a71cb73	2026-09-28 12:26	2026-09-28 12:26	2026-09-28 12:26	SPX	SPX261120C08100000	call	8100.0000	2026-11-20	29.1000	29.0000	29.5000	7710.9300	436500.00	52380.00	384120.00	150	56	1105	16578	0.0666546024852214	0.114263894953228	0.114263894953228	false	false	false	true
c83e88b2-2567-4357-baa3-2f5c1117c050	2026-09-28 12:23	2026-09-28 12:23	2026-09-28 12:23	SPX	SPX261218C08500000	call	8500.0000	2026-12-18	9.3000	9.1000	9.5000	7701.7400	1209000.00	0.00	0.00	1300	4	3178	15411	0.206216338978652	0.115581716426107	0.115581716426107	false	true	false	true
1cc8d6db-1171-42ab-a534-6b7fdd97a5c2	2026-09-28 12:22	2026-09-28 12:22	2026-09-28 12:22	SPX	SPX261218C08500000	call	8500.0000	2026-12-18	9.3000	9.1000	9.5000	7704.2900	465000.00	0.00	0.00	500	4	1878	15411	0.121861008370644	0.115236108363684	0.115236108363684	false	true	false	true
15378e90-8790-4f16-b36d-f53c8daa3e0f	2026-09-28 12:21	2026-09-28 12:21	2026-09-28 12:21	SPX	SPX261218C08500000	call	8500.0000	2026-12-18	9.3000	9.1000	9.5000	7703.5500	930000.00	0.00	0.00	1000	2	1178	15411	0.0764389072740251	0.115336407279761	0.115336407279761	false	true	false	true
60578b23-7eff-44b4-b429-00a74fcefca4	2026-09-28 12:18	2026-09-28 12:18	2026-09-28 12:18	SPX	SPX261120C08000000	call	8000.0000	2026-11-20	47.0000	46.7000	47.0000	7694.0400	173900.00	173900.00	0.00	37	5	512	78102	0.0065555299480167	0.117330678670584	0.117330678670584	false	false	false	true
18001386-3048-4952-b6ec-820955589f7b	2026-09-28 11:43	2026-09-28 11:43	2026-09-28 11:43	SPX	SPX261218P04200000	put	4200.0000	2026-12-18	2.8000	2.6500	2.8500	7677.2200	28000.00	28000.00	0.00	100	7	200	7573	0.0264096130991681	0.52104759159934	0.52104759159934	false	false	false	true
4a828a81-6e79-4648-b9b6-ef585c7993ba	2026-09-28 11:42	2026-09-28 11:41	2026-09-28 11:41	SPX	SPX261218P04200000	put	4200.0000	2026-12-18	2.8000	2.6000	2.8500	7678.3500	28000.00	20160.00	7840.00	100	8	100	7573	0.013204806549584	0.521154186018275	0.521154186018275	false	false	false	true
02a3f8e4-32c0-4a45-9b03-592be7f6b3e1	2026-09-28 11:35	2026-09-28 11:35	2026-09-28 11:35	SPX	SPX261016C08000000	call	8000.0000	2026-10-16	4.3000	4.0000	4.3000	7679.9200	120400.00	120400.00	0.00	280	7	6545	193500	0.0338242894056848	0.108697729864408	0.108697729864408	false	false	false	true
c66b5c59-b2e8-4a47-a65b-084acd2941d2	2026-09-28 11:27	2026-09-28 11:27	2026-09-28 11:27	SPX	SPX261120C09400000	call	9400.0000	2026-11-20	0.1500	0.0500	0.2000	7678.4800	70500.00	70500.00	0.00	4700	10	4700	544	8.63970588235294	0.166716257404275	0.166716257404275	false	true	false	true
ac021a81-72f8-46c8-8f77-a68ebc842123	2026-09-28 11:24	2026-09-28 11:24	2026-09-28 11:24	SPX	SPX261120C07750000	call	7750.0000	2026-11-20	140.6000	139.6000	140.6000	7655.0000	140600.00	140600.00	0.00	10	5	84	5324	0.0157776108189331	0.131250665214562	0.131250665214562	false	false	false	true
1edbf42c-4817-423a-88c5-b75ba4c11de7	2026-09-28 11:17	2026-09-28 11:17	2026-09-28 11:17	SPX	SPX261016P07475000	put	7475.0000	2026-10-16	30.2000	30.2000	30.3000	7655.0000	126840.00	0.00	126840.00	42	6	268	3434	0.0780430984274898	0.157075378526038	0.157075378526038	false	false	false	true
ca172507-0732-470c-9d0c-73227bb7f27e	2026-09-28 11:08	2026-09-28 11:08	2026-09-28 11:08	SPX	SPX270319C08600000	call	8600.0000	2027-03-19	45.6000	45.3000	46.1000	7682.0700	15048000.00	0.00	15048000.00	3300	8	3300	3772	0.874867444326617	0.121804051949853	0.121804051949853	false	true	false	true
5b8d2a6d-132d-4a62-9242-11103b69ac1c	2026-09-28 10:51	2026-09-28 10:51	2026-09-28 10:51	SPX	SPX261016P07500000	put	7500.0000	2026-10-16	33.8000	33.8000	34.4000	7676.3600	486720.00	0.00	486720.00	144	5	247	35951	0.00687046257405914	0.152201182160535	0.152201182160535	false	false	false	true
bdec918a-7bda-452f-9fac-071604e1e761	2026-09-28 10:50	2026-09-28 10:50	2026-09-28 10:50	SPX	SPX270219C08400000	call	8400.0000	2027-02-19	54.0000	52.8000	54.0000	7650.0000	135000.00	135000.00	0.00	25	5	27	2457	0.010989010989011	0.121285716241794	0.121285716241794	false	false	false	true