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.

326,449 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts326,449 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 = SPXW×

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

6c554b74-eb91-4914-9f0d-5e9bae76853b	2026-09-22 16:59	2026-09-22 16:58	2026-09-22 16:58	SPXW	SPXW260923P07765000	put	7765.0000	2026-09-23	15.7000	15.7000	15.8000	7745.0000	78500.00	0.00	78500.00	50	6	5241	462	11.3441558441558	0.0983146913753458	0.0983146913753458	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	—	—	—	—	—	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500}	2026-09-22	2026-09-22 21:15	2026-09-22 21:15
5583207e-0118-47f7-bf3f-08d712395c6f	2026-09-22 16:34	2026-09-22 16:31	2026-09-22 16:31	SPXW	SPXW260923C07800000	call	7800.0000	2026-09-23	3.2000	2.9500	3.3000	7745.0000	16000.00	16000.00	0.00	50	10	11760	2239	5.25234479678428	0.0879654077343984	0.0879654077343984	false	false	false	true
bb6deb49-5130-40d3-8ffa-18275c5ce6dc	2026-09-22 16:31	2026-09-22 16:30	2026-09-22 16:30	SPXW	SPXW260929P07600000	put	7600.0000	2026-09-29	5.6000	5.4000	5.7000	7745.0000	75600.00	10640.00	64960.00	135	11	1045	1091	0.957836846929423	0.121217276357308	0.121217276357308	false	false	false	true
bdd98ee8-12dc-40aa-855b-5101e777f098	2026-09-22 16:13	2026-09-22 16:13	2026-09-22 16:13	SPXW	SPXW260923C07755000	call	7755.0000	2026-09-23	22.0000	22.0000	22.1000	7745.0000	41800.00	0.00	41800.00	19	5	2069	687	3.01164483260553	0.100127132132015	0.100127132132015	false	false	false	true
32c9e8b1-a212-4709-aaf8-897d2444b2be	2026-09-22 16:13	2026-09-22 16:13	2026-09-22 16:13	SPXW	SPXW260923P07700000	put	7700.0000	2026-09-23	1.6000	1.4500	1.6500	7745.0000	16480.00	16480.00	0.00	103	11	8852	1484	5.96495956873315	0.113633600297985	0.113633600297985	false	false	false	true
da8932e5-d9e1-40e5-9cef-2d19d980183c	2026-09-22 16:13	2026-09-22 16:13	2026-09-22 16:13	SPXW	SPXW260923P07755000	put	7755.0000	2026-09-23	9.6000	9.6000	9.7000	7745.0000	17280.00	0.00	17280.00	18	6	3473	204	17.0245098039216	0.087828528927548	0.087828528927548	false	false	false	true
dd7ab4ba-cbe2-4d41-91a3-55ea62f69787	2026-09-22 16:13	2026-09-22 16:13	2026-09-22 16:13	SPXW	SPXW260923P07700000	put	7700.0000	2026-09-23	1.4500	1.3500	1.5000	7745.0000	13485.00	8555.00	4930.00	93	10	8388	1484	5.65229110512129	0.111011973075138	0.111011973075138	false	false	false	true
761cd0ad-3405-4276-b5de-6e0a70aec248	2026-09-22 16:13	2026-09-22 16:13	2026-09-22 16:13	SPXW	SPXW260923C07760000	call	7760.0000	2026-09-23	18.9000	18.8000	19.0000	7745.0000	94500.00	20790.00	73710.00	50	8	4267	1343	3.17721518987342	0.0987775855103672	0.0987775855103672	false	false	false	true
05873d41-25ad-4738-b7b1-16cd58c6ebd9	2026-09-22 16:13	2026-09-22 16:13	2026-09-22 16:13	SPXW	SPXW260923C07760000	call	7760.0000	2026-09-23	19.0000	18.9000	19.2000	7745.0000	34200.00	0.00	34200.00	18	5	4201	1343	3.12807148175726	0.0994003105109038	0.0994003105109038	false	false	false	true
7e5fd960-a20e-4545-bdc4-d33b8e00f301	2026-09-22 16:13	2026-09-22 16:12	2026-09-22 16:12	SPXW	SPXW260923C07775000	call	7775.0000	2026-09-23	11.5000	11.4000	11.6000	7745.0000	23000.00	17250.00	0.00	20	5	11917	2933	4.06307534947153	0.0974155875789421	0.0974155875789421	false	false	false	true
8639aedc-70b9-412a-8c38-8a196fb52ee1	2026-09-22 16:12	2026-09-22 16:12	2026-09-22 16:12	SPXW	SPXW260928C07775000	call	7775.0000	2026-09-28	32.9000	32.8000	32.9000	7745.0000	197400.00	197400.00	0.00	60	13	524	2239	0.234033050468959	0.0893235165176747	0.0893235165176747	false	false	false	true
7ea563d7-3135-4a44-b55d-2b7fe17fe759	2026-09-22 16:12	2026-09-22 16:11	2026-09-22 16:11	SPXW	SPXW261002C07800000	call	7800.0000	2026-10-02	41.5000	41.5000	41.9000	7745.0000	103750.00	0.00	103750.00	25	5	1049	3970	0.264231738035265	0.104916443841569	0.104916443841569	false	false	false	true
7e4970b1-5e20-495f-b326-ddbfb2e62dfd	2026-09-22 16:12	2026-09-22 16:11	2026-09-22 16:11	SPXW	SPXW260923C07765000	call	7765.0000	2026-09-23	16.2300	16.2000	16.3000	7745.0000	17850.00	4890.00	12960.00	11	5	7270	1175	6.18723404255319	0.0984232301721863	0.09904005432274	false	false	false	true
75c3a950-b951-400f-aaae-4f58fdf8ee44	2026-09-22 16:11	2026-09-22 16:11	2026-09-22 16:11	SPXW	SPXW260923C07765000	call	7765.0000	2026-09-23	16.1000	16.0000	16.2000	7745.0000	11270.00	0.00	0.00	7	5	7257	1175	6.17617021276596	0.0978064054850106	0.0978064054850106	false	false	false	true
02e09871-b31a-4a67-9c24-fa8585a38ca2	2026-09-22 16:11	2026-09-22 16:11	2026-09-22 16:11	SPXW	SPXW260923C07760000	call	7760.0000	2026-09-23	19.0000	19.0000	19.1000	7745.0000	43700.00	0.00	43700.00	23	6	4154	1343	3.09307520476545	0.0994003105109038	0.0994003105109038	false	false	false	true
05cdea9b-05f1-4383-8b2e-4aea75456f4e	2026-09-22 16:11	2026-09-22 16:10	2026-09-22 16:10	SPXW	SPXW260923P07740000	put	7740.0000	2026-09-23	5.4000	5.3000	5.5000	7745.0000	81000.00	69120.00	4860.00	150	6	5432	371	14.6415094339623	0.0912748974481425	0.0912748974481425	false	false	false	true
e4bd9a38-8209-4bbc-add8-e25d683a36c8	2026-09-22 16:10	2026-09-22 16:10	2026-09-22 16:10	SPXW	SPXW260923C07800000	call	7800.0000	2026-09-23	4.3000	4.1000	4.4000	7745.0000	21070.00	19780.00	1290.00	49	8	10436	2239	4.66100937918714	0.0982182657858511	0.0982182657858511	false	false	false	true
a91f7fd1-13ce-46a3-84bf-8ebfa7643d61	2026-09-22 16:09	2026-09-22 16:09	2026-09-22 16:09	SPXW	SPXW260923C07770000	call	7770.0000	2026-09-23	13.7000	13.5000	13.8000	7745.0000	31520.00	28780.00	2740.00	23	6	11036	1547	7.13380736910149	0.0977663377600666	0.0983868883279407	false	false	false	true
69084a50-acff-41b5-b19f-fdacb1f3374d	2026-09-22 16:08	2026-09-22 16:08	2026-09-22 16:08	SPXW	SPXW260923P07765000	put	7765.0000	2026-09-23	13.2000	13.1000	13.3000	7745.0000	47520.00	7920.00	0.00	36	7	4976	462	10.7705627705628	0.082893877088231	0.082893877088231	false	false	false	true
355234a9-df1c-484a-b555-f62db6c7261c	2026-09-22 16:08	2026-09-22 16:08	2026-09-22 16:08	SPXW	SPXW260923C07800000	call	7800.0000	2026-09-23	4.3000	4.2000	4.4000	7745.0000	107500.00	13760.00	75250.00	250	8	10194	2239	4.55292541313086	0.0982182657858511	0.0982182657858511	false	false	false	true
b719b623-7097-4eba-af3c-625b92f6db8a	2026-09-22 16:08	2026-09-22 16:07	2026-09-22 16:07	SPXW	SPXW260925P07600000	put	7600.0000	2026-09-25	1.8500	1.8000	1.9500	7745.0000	14615.00	0.00	14615.00	79	5	1712	4084	0.419196865817826	0.141962778383302	0.141962778383302	false	false	false	true
ad1fa66a-8b9d-4d6e-869a-508050b52d28	2026-09-22 16:06	2026-09-22 16:06	2026-09-22 16:06	SPXW	SPXW260925P07670000	put	7670.0000	2026-09-25	5.0000	4.8000	5.0000	7745.0000	45000.00	45000.00	0.00	90	15	530	1040	0.509615384615385	0.119026427786244	0.119026427786244	false	false	false	true
00ac6d28-b7a4-4fd2-acd2-c1f213efc052	2026-09-22 16:05	2026-09-22 16:05	2026-09-22 16:05	SPXW	SPXW260923P07765000	put	7765.0000	2026-09-23	14.1000	13.9000	14.1000	7745.0000	33840.00	33840.00	0.00	24	6	4544	462	9.83549783549783	0.0884454220938938	0.0884454220938938	false	false	false	true
7b287db8-cb51-47fc-ba37-418c7b385e85	2026-09-22 16:04	2026-09-22 16:04	2026-09-22 16:04	SPXW	SPXW260929C07895000	call	7895.0000	2026-09-29	4.8000	4.7000	4.9000	7745.0000	31680.00	27840.00	0.00	66	8	301	0	0	0.0905517169186067	0.0905517169186067	false	false	false	true
08a077c3-9c14-4a0d-8409-82ab9a43b6f1	2026-09-22 16:03	2026-09-22 16:03	2026-09-22 16:03	SPXW	SPXW260923C07765000	call	7765.0000	2026-09-23	16.0000	15.9000	16.1000	7745.0000	59200.00	0.00	57600.00	37	5	6993	1175	5.95148936170213	0.0967207927042227	0.0967207927042227	false	false	false	true
ad158c95-d0cf-4060-a21b-628414c94864	2026-09-22 16:03	2026-09-22 16:03	2026-09-22 16:03	SPXW	SPXW260924C07950000	call	7950.0000	2026-09-24	0.3000	0.2500	0.3500	7745.0000	10020.00	2280.00	4500.00	334	10	439	396	1.10858585858586	0.137656170080674	0.137656170080674	false	false	false	true
0bb15daf-ee7d-424d-a60b-6427dbdc8193	2026-09-22 16:03	2026-09-22 16:03	2026-09-22 16:03	SPXW	SPXW260923C07825000	call	7825.0000	2026-09-23	1.6000	1.5000	1.6000	7745.0000	16000.00	16000.00	0.00	100	8	4317	676	6.38609467455621	0.104664432129425	0.104664432129425	false	false	false	true
fb24f59e-02da-4551-aa2e-10e86c0e52be	2026-09-22 16:03	2026-09-22 16:02	2026-09-22 16:02	SPXW	SPXW260925C07875000	call	7875.0000	2026-09-25	2.7000	2.6000	2.7500	7745.0000	16200.00	810.00	12420.00	60	6	1015	1039	0.976900866217517	0.107302140496072	0.107302140496072	false	false	false	true
8ac6e445-1002-4747-bf90-1aacb78777ac	2026-09-22 16:03	2026-09-22 16:02	2026-09-22 16:02	SPXW	SPXW260925C07875000	call	7875.0000	2026-09-25	2.7500	2.6500	2.7500	7745.0000	15400.00	15400.00	0.00	56	6	1074	1039	1.03368623676612	0.107780959452571	0.107780959452571	false	false	false	true
9008799d-b81d-4482-98b0-0783f99f74cc	2026-09-22 16:02	2026-09-22 16:02	2026-09-22 16:02	SPXW	SPXW260925C07875000	call	7875.0000	2026-09-25	2.7000	2.7000	2.7500	7745.0000	14040.00	0.00	14040.00	52	9	879	1039	0.846005774783446	0.107302140496072	0.107302140496072	false	false	false	true
9d403a99-bb6f-404e-9780-825b3b9855a0	2026-09-22 16:02	2026-09-22 16:02	2026-09-22 16:02	SPXW	SPXW260923P07765000	put	7765.0000	2026-09-23	14.3000	14.1000	14.3000	7745.0000	35750.00	35750.00	0.00	25	5	4134	462	8.94805194805195	0.0902869488637587	0.0902869488637587	false	false	false	true
9e5cd645-6452-4b12-89b4-6d9f14b46159	2026-09-22 16:01	2026-09-22 16:01	2026-09-22 16:01	SPXW	SPXW260923C07780000	call	7780.0000	2026-09-23	9.9000	9.8000	10.0000	7745.0000	21780.00	0.00	7920.00	22	5	9930	2384	4.16526845637584	0.0989358190735959	0.0989358190735959	false	false	false	true
270945a3-05b4-4ba1-9831-fe2aea63ade2	2026-09-22 16:01	2026-09-22 16:01	2026-09-22 16:01	SPXW	SPXW261021P06925000	put	6925.0000	2026-10-21	6.4000	6.3000	6.6000	7745.0000	21120.00	0.00	21120.00	33	7	48	23	2.08695652173913	0.229140436339932	0.229140436339932	false	false	false	true
fb203e18-04ab-4552-9a08-e739779b6354	2026-09-22 16:00	2026-09-22 16:00	2026-09-22 16:00	SPXW	SPXW260925C07815000	call	7815.0000	2026-09-25	11.5000	11.3000	11.5000	7745.0000	19550.00	19550.00	0.00	17	5	798	944	0.845338983050847	0.104274539792992	0.104274539792992	false	false	false	true
3e353815-4b02-49e0-8914-b1c34e9af5a1	2026-09-22 16:00	2026-09-22 15:59	2026-09-22 15:59	SPXW	SPXW260922P07775000	put	7775.0000	2026-09-22	10.0000	9.6000	10.0000	7745.0000	32000.00	32000.00	0.00	32	11	82892	1241	66.7945205479452	0	0	false	false	false	true
27ff7130-bfda-4f0b-b9be-bc13283778fc	2026-09-22 16:00	2026-09-22 15:59	2026-09-22 15:59	SPXW	SPXW260923P07755000	put	7755.0000	2026-09-23	11.0000	10.9000	11.0000	7745.0000	106700.00	106700.00	0.00	97	5	3010	204	14.7549019607843	0.0972167148458095	0.0972167148458095	false	false	false	true
09669e4f-bd84-4ca1-bedc-a43a6d895458	2026-09-22 16:00	2026-09-22 15:59	2026-09-22 15:59	SPXW	SPXW260923C07770000	call	7770.0000	2026-09-23	14.0000	14.0000	14.3000	7745.0000	49000.00	0.00	49000.00	35	7	10311	1547	6.66515837104072	0.0976332464101654	0.0976332464101654	false	false	false	true
1f2785cd-60ad-4c02-8bb5-08d4e9850369	2026-09-22 15:59	2026-09-22 15:59	2026-09-22 15:59	SPXW	SPXW260923P07700000	put	7700.0000	2026-09-23	1.5000	1.5000	1.5500	7745.0000	10200.00	0.00	10200.00	68	5	7778	1484	5.24123989218329	0.112821066099796	0.112821066099796	false	false	false	true
f2d4628a-899e-4eec-b74e-9e796474c3b4	2026-09-22 15:59	2026-09-22 15:59	2026-09-22 15:59	SPXW	SPXW260929P07765000	put	7765.0000	2026-09-29	35.8000	35.7000	36.1000	7745.0000	236280.00	196900.00	39380.00	66	11	238	15	15.8666666666667	0.0910381862561499	0.0910381862561499	false	false	false	true
c6f898e9-3d28-4c02-aa78-b256b95b0fb6	2026-09-22 15:59	2026-09-22 15:59	2026-09-22 15:59	SPXW	SPXW260929P07765000	put	7765.0000	2026-09-29	35.8000	35.7000	36.1000	7745.0000	268500.00	0.00	268500.00	75	9	339	15	22.6	0.0910381862561499	0.0910381862561499	false	false	false	true
9a353e25-3cb2-450d-bcab-5ecf5532fb3f	2026-09-22 15:59	2026-09-22 15:59	2026-09-22 15:59	SPXW	SPXW260923P07730000	put	7730.0000	2026-09-23	4.2000	4.0000	4.2000	7745.0000	14280.00	14280.00	0.00	34	5	4036	625	6.4576	0.101980549670395	0.101980549670395	false	false	false	true
dc0213c9-8f3c-403d-800d-0ef1685f1e3d	2026-09-22 15:59	2026-09-22 15:59	2026-09-22 15:59	SPXW	SPXW260923C07845000	call	7845.0000	2026-09-23	0.7000	0.7000	0.8000	7745.0000	16380.00	0.00	16380.00	234	7	3185	593	5.37099494097808	0.109389374187649	0.109389374187649	false	false	false	true
00370cba-8b5b-4711-abbc-771b9430fbab	2026-09-22 15:59	2026-09-22 15:59	2026-09-22 15:59	SPXW	SPXW260923C07760000	call	7760.0000	2026-09-23	19.6000	18.9000	19.6000	7745.0000	196000.00	196000.00	0.00	100	2	3699	1343	2.75428145941921	0.102445169791544	0.102445169791544	false	true	false	true
04599532-1245-4465-b1b4-27b6790d1dc7	2026-09-22 15:59	2026-09-22 15:59	2026-09-22 15:59	SPXW	SPXW260923C07770000	call	7770.0000	2026-09-23	14.2000	14.1000	14.3000	7745.0000	28400.00	0.00	12780.00	20	5	10205	1547	6.59663865546218	0.0964157472983545	0.0987859105869296	false	false	false	true
530aeeaf-8c06-446e-822a-831ad89bbf97	2026-09-22 15:59	2026-09-22 15:59	2026-09-22 15:59	SPXW	SPXW260922P07775000	put	7775.0000	2026-09-22	8.7000	8.2000	9.5000	7745.0000	13050.00	0.00	13050.00	15	7	82613	1241	66.5697018533441	0	0	false	false	false	true
148240f2-4c6e-4596-8f44-0250ed229f44	2026-09-22 15:59	2026-09-22 15:59	2026-09-22 15:59	SPXW	SPXW260923C07850000	call	7850.0000	2026-09-23	0.6500	0.6000	0.7000	7745.0000	30290.00	325.00	29185.00	466	10	8383	4935	1.69868287740628	0.113781876258281	0.113915947530875	false	false	false	true
71e802fe-7c35-43e1-a448-143ba6707225	2026-09-22 15:59	2026-09-22 15:59	2026-09-22 15:59	SPXW	SPXW260923P07755000	put	7755.0000	2026-09-23	11.0000	10.9000	11.0000	7745.0000	104500.00	104500.00	0.00	95	18	2896	204	14.1960784313725	0.0969903341359441	0.0969903341359441	false	false	false	true
6acfc04f-a238-4a7d-bfb6-64b0c57085be	2026-09-22 15:59	2026-09-22 15:59	2026-09-22 15:59	SPXW	SPXW260922P07770000	put	7770.0000	2026-09-22	5.0000	4.5000	5.0000	7745.0000	31000.00	31000.00	0.00	62	23	158644	1128	140.641843971631	0	0	false	false	false	true
d120373e-1a94-4c49-95d8-bdb73745f1b3	2026-09-22 15:59	2026-09-22 15:59	2026-09-22 15:59	SPXW	SPXW260922P07775000	put	7775.0000	2026-09-22	9.0000	8.4000	9.0500	7745.0000	17100.00	17100.00	0.00	19	9	82454	1241	66.4415793714746	0	0	false	false	false	true
86ed5f1c-d14d-48bb-a97e-6ad1979f4c3a	2026-09-22 15:59	2026-09-22 15:58	2026-09-22 15:58	SPXW	SPXW260922P07775000	put	7775.0000	2026-09-22	8.0500	7.7000	8.8000	7745.0000	24150.00	0.00	24150.00	30	7	82429	1241	66.4214343271555	0	0	false	false	false	true