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.

474,253 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts474,253 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:ticker = SPXW×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	price

b0d64e6c-1977-46d6-8680-7fa094972722	2026-08-27 10:37	2026-08-27 10:37	2026-08-27 10:37	SPXW	SPXW260831C07650000	call	7650.0000	2026-08-31	77.3200	77.3000	82.1000	7716.6600	5048996.00	0.00	0.00	653	14	709	3627	0.195478356768679	0.0950701437106993	0.0950701437106993	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	—	—	—	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-27T14:49:52.356548Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
4d777358-51d6-40da-8ddd-fc0da8fcb0ad	2026-08-27 10:39	2026-08-27 10:39	2026-08-27 10:39	SPXW	SPXW260827C07710000	call	7710.0000	2026-08-27	12.9900	12.7000	13.1000	7712.5700	149370.00	149370.00	0.00	115	37	29174	1324	22.0347432024169	0.15097952018685	0.153623093764447	false	false	false	true	false
20e779db-a650-4cf9-ab47-9e90bdc8405c	2026-08-27 10:39	2026-08-27 10:39	2026-08-27 10:39	SPXW	SPXW260827C07710000	call	7710.0000	2026-08-27	12.3000	12.2000	12.4000	7711.9500	119310.00	29520.00	30750.00	97	12	29486	1324	22.2703927492447	0.147559828996722	0.147559828996722	false	false	false	true	false
46aac436-09a2-4a7e-951a-6d7c9e7486fe	2026-08-27 10:40	2026-08-27 10:39	2026-08-27 10:39	SPXW	SPXW260827C07710000	call	7710.0000	2026-08-27	12.0500	11.8000	12.1000	7711.2400	120460.00	120460.00	0.00	100	17	29626	1324	22.3761329305136	0.148574691781229	0.148574691781229	false	false	false	true	false
5076e423-ebcb-4f06-bade-2b042b0271a8	2026-08-27 10:40	2026-08-27 10:40	2026-08-27 10:40	SPXW	SPXW260918P07700000	put	7700.0000	2026-09-18	77.0000	76.9000	77.4000	7711.5800	746900.00	400400.00	346500.00	97	6	1017	800	1.27125	0.120519489131812	0.120519489131812	false	false	false	true	false
25c3cab0-869c-4482-866c-aec34df7934b	2026-08-27 10:41	2026-08-27 10:41	2026-08-27 10:41	SPXW	SPXW260827P07710000	put	7710.0000	2026-08-27	9.5000	9.3000	9.6000	7713.1000	190000.00	163400.00	0.00	200	32	16085	202	79.6287128712871	0.146050948056093	0.146050948056093	false	false	false	true	false
0ebe1129-eb68-47e1-8c5c-99cc5d0d8d0e	2026-08-27 10:41	2026-08-27 10:41	2026-08-27 10:41	SPXW	SPXW260827C07710000	call	7710.0000	2026-08-27	13.0000	12.9000	13.2000	7713.8600	128700.00	57200.00	71500.00	99	29	29987	1324	22.6487915407855	0.143440394906244	0.143440394906244	false	false	false	true	false
4ef84851-6891-4a99-b263-f014e39eee17	2026-08-27 10:41	2026-08-27 10:41	2026-08-27 10:41	SPXW	SPXW260827C07710000	call	7710.0000	2026-08-27	12.7800	12.7000	12.9000	7713.5100	127790.00	78080.00	34350.00	100	12	30096	1324	22.7311178247734	0.143415536604464	0.143415536604464	false	false	false	true	false
cee0c617-9fe0-4f33-9dd0-fdb15cbb750f	2026-08-27 10:50	2026-08-27 10:49	2026-08-27 10:49	SPXW	SPXW260918P07700000	put	7700.0000	2026-09-18	73.4000	73.2000	73.6000	7720.7500	484440.00	0.00	440400.00	66	5	1261	800	1.57625	0.121045376348328	0.121045376348328	false	false	false	true	false
05fb376d-811e-4fb7-95a7-ae763f06fe62	2026-08-27 10:50	2026-08-27 10:50	2026-08-27 10:50	SPXW	SPXW260827C07720000	call	7720.0000	2026-08-27	10.1900	10.0000	10.3000	7720.1900	156980.00	118320.00	38660.00	154	39	28122	1141	24.646801051709	0.134023572391407	0.131347635278442	false	false	false	true	false
bcc279a3-e8f1-4447-a932-7e80a55c1715	2026-08-27 10:57	2026-08-27 10:57	2026-08-27 10:57	SPXW	SPXW260831P07720000	put	7720.0000	2026-08-31	30.6400	30.6000	31.0000	7717.1700	168510.00	0.00	168510.00	55	13	390	328	1.1890243902439	0.0958262168858464	0.0955159260212335	false	false	false	true	false
7490caef-5f17-492f-807a-7eedb9ded2ea	2026-08-27 10:59	2026-08-27 10:58	2026-08-27 10:58	SPXW	SPXW260904P07650000	put	7650.0000	2026-09-04	25.2400	24.2000	24.4000	7719.5400	2524000.00	0.00	0.00	1000	9	2187	3441	0.635571054925894	0.121389139082842	0.121389139082842	false	false	false	true	false
1ae9f025-9cd1-44aa-adae-a37c68b07d34	2026-08-27 10:59	2026-08-27 10:59	2026-08-27 10:59	SPXW	SPXW260827C07690000	call	7690.0000	2026-08-27	33.9200	33.6000	34.0000	7720.7600	101750.00	101750.00	0.00	30	15	5154	1186	4.34569983136594	0.174375424221526	0.176530092840138	true	false	false	true	false
a47e001a-3ee6-4c5f-b6bd-b5dd29653d0a	2026-08-27 11:00	2026-08-27 11:00	2026-08-27 11:00	SPXW	SPXW260827C07680000	call	7680.0000	2026-08-27	42.7300	42.5000	42.8000	7721.2500	119650.00	102610.00	0.00	28	9	2442	1148	2.12717770034843	0.164449803593259	0.171164201753067	false	false	false	true	false
80b876c8-9724-4530-94d2-e3c8755ea15f	2026-08-27 11:00	2026-08-27 11:00	2026-08-27 11:00	SPXW	SPXW260930C07875000	call	7875.0000	2026-09-30	49.5000	50.0000	50.3000	7722.1800	4950000.00	0.00	0.00	1000	8	1004	798	1.25814536340852	0.105287312704363	0.105287312704363	false	false	false	true	false
ecf6f717-9016-4d23-8dba-1b9da0dec87b	2026-08-27 11:00	2026-08-27 11:00	2026-08-27 11:00	SPXW	SPXW260827C07680000	call	7680.0000	2026-08-27	44.3700	44.1000	44.5000	7722.1200	115370.00	115370.00	0.00	26	6	2474	1148	2.15505226480836	0.192861350750613	0.192861350750613	false	false	false	true	false
5aa03cad-a87a-4828-9e36-d8c8dc19eb04	2026-08-27 11:01	2026-08-27 11:01	2026-08-27 11:01	SPXW	SPXW260827C07720000	call	7720.0000	2026-08-27	11.7000	11.6000	11.7000	7722.9500	128680.00	126360.00	2320.00	110	8	32962	1141	28.8886941279579	0.135757599979022	0.137130515472698	false	false	false	true	false
31016bdf-b7eb-4e39-bf2b-6d2e91ce9d42	2026-08-27 11:14	2026-08-27 11:14	2026-08-27 11:14	SPXW	SPXW260930C07700000	call	7700.0000	2026-09-30	139.0000	138.9000	139.4000	7724.7100	347490.00	0.00	347490.00	25	6	93	2067	0.0449927431059507	0.118544077984822	0.118544077984822	false	false	false	true	false
1144ebe0-1d92-404c-87e9-276c4959b836	2026-08-27 11:15	2026-08-27 11:15	2026-08-27 11:15	SPXW	SPXW260930C07850000	call	7850.0000	2026-09-30	59.8400	60.7000	61.0000	7726.3600	8976000.00	0.00	0.00	1500	14	1643	2106	0.780151946818613	0.106284062534169	0.106284062534169	false	false	false	true	false
fb9f48a8-7533-473c-80e3-8a606a99cdcb	2026-08-27 11:16	2026-08-27 11:16	2026-08-27 11:16	SPXW	SPXW260827C07730000	call	7730.0000	2026-08-27	8.2600	8.1000	8.3000	7728.0800	132210.00	132210.00	0.00	160	32	48740	2566	18.9945440374123	0.126394065907611	0.126394065907611	false	false	false	true	false
43c165d7-19cc-4e3e-af19-2d57ba9210fc	2026-08-27 11:21	2026-08-27 11:21	2026-08-27 11:21	SPXW	SPXW260827P07715000	put	7715.0000	2026-08-27	5.0000	4.9000	5.1000	7726.3100	100500.00	92500.00	500.00	201	39	18815	3110	6.04983922829582	0.136468192617573	0.136468192617573	false	false	false	true	false
8f6a8320-ad0e-4aab-b25f-639c52c508c1	2026-08-27 11:23	2026-08-27 11:23	2026-08-27 11:23	SPXW	SPXW260831P07665000	put	7665.0000	2026-08-31	11.1200	11.0000	11.3000	7725.6700	112350.00	17920.00	85470.00	101	15	160	633	0.252764612954186	0.105834152727077	0.105421700628918	false	false	false	true	false
8849ce99-c3ea-445d-ac95-585829a59ad6	2026-08-27 11:25	2026-08-27 11:25	2026-08-27 11:25	SPXW	SPXW260827P07725000	put	7725.0000	2026-08-27	9.1000	9.0000	9.2000	7724.4000	107380.00	75530.00	910.00	118	23	10053	2146	4.68452935694315	0.125974151484591	0.125974151484591	false	false	false	true	false
4a6b0714-be5b-4500-b193-5095089d3a2f	2026-08-27 11:25	2026-08-27 11:25	2026-08-27 11:25	SPXW	SPXW260827P07725000	put	7725.0000	2026-08-27	9.5400	9.5000	9.7000	7723.4800	156440.00	60480.00	95960.00	164	38	10415	2146	4.85321528424977	0.127316951560395	0.125001075570648	false	false	false	true	false
4771e480-a27f-4ac7-9091-40c577147c6e	2026-08-27 11:29	2026-08-27 11:29	2026-08-27 11:29	SPXW	SPXW260827P07725000	put	7725.0000	2026-08-27	10.1000	10.0000	10.1000	7721.7200	117160.00	117160.00	0.00	116	18	11776	2146	5.48741845293569	0.12023391217771	0.120800138664921	false	false	false	true	false
783c18ea-8edf-4f5c-9f80-a07872ea1782	2026-08-27 11:30	2026-08-27 11:30	2026-08-27 11:30	SPXW	SPXW260827P07720000	put	7720.0000	2026-08-27	8.1700	8.1000	8.3000	7720.7700	115950.00	3280.00	109390.00	142	37	17938	256	70.0703125	0.123974293738918	0.12254383310018	true	false	false	true	false
40918f7f-c0bd-46ed-863d-893e8e019c30	2026-08-27 11:32	2026-08-27 11:32	2026-08-27 11:32	SPXW	SPXW260914P07475000	put	7475.0000	2026-09-14	16.2000	16.0000	16.2000	7720.4000	110160.00	110160.00	0.00	68	5	288	349	0.825214899713467	0.139963151826702	0.139963151826702	false	false	false	true	false
03c67fc8-0430-4ede-a3f3-00109b245f59	2026-08-27 11:33	2026-08-27 11:33	2026-08-27 11:33	SPXW	SPXW260828C07720000	call	7720.0000	2026-08-28	25.9000	25.9000	26.1000	7723.3300	103600.00	0.00	103600.00	40	9	1723	1919	0.897863470557582	0.147464577336771	0.147464577336771	false	false	false	true	false
4a1acc27-e129-48b1-b916-53bcd6aefc0d	2026-08-27 11:36	2026-08-27 11:36	2026-08-27 11:36	SPXW	SPXW260828P07715000	put	7715.0000	2026-08-28	20.6200	20.6000	20.9000	7718.9900	113430.00	0.00	113430.00	55	11	1165	469	2.48400852878465	0.142844731119837	0.142221973508832	false	false	false	true	false
330e0d9a-e7cc-498f-b9e1-69555faa418a	2026-08-27 11:37	2026-08-27 11:37	2026-08-27 11:37	SPXW	SPXW260827P07700000	put	7700.0000	2026-08-27	3.6300	3.5000	3.7000	7718.9600	112390.00	108160.00	3510.00	310	52	43738	2552	17.1387147335423	0.149130346989115	0.152656496309029	false	false	false	true	false
c30563fd-366d-453e-bd60-a00788617941	2026-08-27 11:41	2026-08-27 11:41	2026-08-27 11:41	SPXW	SPXW260901C07675000	call	7675.0000	2026-09-01	66.1800	66.1000	66.5000	7720.0800	125750.00	0.00	125750.00	19	8	93	316	0.294303797468354	0.10206021266633	0.10206021266633	false	false	false	true	false
54f0542f-04d0-437c-84e2-b896b77c1118	2026-08-27 11:43	2026-08-27 11:43	2026-08-27 11:43	SPXW	SPXW260827P07750000	put	7750.0000	2026-08-27	33.7800	33.7000	34.2000	7716.9100	162140.00	3400.00	158740.00	48	11	1672	253	6.60869565217391	0.141134678440999	0.144775606029388	true	false	false	true	false
86ec6fc4-a71a-4473-915d-2936c6ef111f	2026-08-27 11:44	2026-08-27 11:44	2026-08-27 11:44	SPXW	SPXW260827P07705000	put	7705.0000	2026-08-27	5.7000	5.6000	5.8000	7714.6100	114570.00	43320.00	71250.00	201	33	29108	139	209.410071942446	0.144805453629212	0.144805453629212	false	false	false	true	false
cec58ade-eec0-4526-8957-c2ff77c63fbb	2026-08-27 11:45	2026-08-27 11:45	2026-08-27 11:45	SPXW	SPXW260827P07705000	put	7705.0000	2026-08-27	6.1000	6.0000	6.2000	7713.6800	123210.00	122000.00	600.00	202	33	29529	139	212.438848920863	0.144519530896495	0.146094157739214	false	false	false	true	false
59ebf21f-b1d6-42c9-bf9f-13632fba8a5a	2026-08-27 11:45	2026-08-27 11:45	2026-08-27 11:45	SPXW	SPXW260827P07720000	put	7720.0000	2026-08-27	12.4500	12.3000	12.7000	7713.6800	124530.00	5000.00	94530.00	100	22	24584	256	96.03125	0.133960612103945	0.133960612103945	true	false	false	true	false
112ae5bd-03d3-4550-b111-6cca13042906	2026-08-27 11:46	2026-08-27 11:46	2026-08-27 11:46	SPXW	SPXW260827P07705000	put	7705.0000	2026-08-27	6.6000	6.5000	6.6000	7712.6600	132000.00	132000.00	0.00	200	11	30618	139	220.273381294964	0.148337690761307	0.148337690761307	false	false	false	true	false
56384186-9e33-4138-9fa7-ac62b04c79c9	2026-08-27 11:48	2026-08-27 11:48	2026-08-27 11:48	SPXW	SPXW260827C07730000	call	7730.0000	2026-08-27	2.9800	2.9000	3.1000	7714.1500	107310.00	85435.00	15000.00	360	38	65309	2566	25.4516757599376	0.127927830170534	0.130809354350682	false	false	false	true	false
efaa7dd0-5b97-4b1a-9796-16badf75f7ec	2026-08-27 11:50	2026-08-27 11:49	2026-08-27 11:49	SPXW	SPXW260904P07710000	put	7710.0000	2026-09-04	44.8500	44.5000	45.0000	7714.7500	201820.00	201820.00	0.00	45	12	153	604	0.253311258278146	0.110224430266148	0.110224430266148	false	false	false	true	false
8df6a70d-477d-4ab2-8301-14552678d762	2026-08-27 11:52	2026-08-27 11:52	2026-08-27 11:52	SPXW	SPXW260827C07690000	call	7690.0000	2026-08-27	34.5700	34.3000	34.7000	7722.6200	103710.00	100270.00	0.00	30	8	5855	1186	4.93676222596965	0.166749214344782	0.166749214344782	false	false	false	true	false
e48fa969-a9c9-4d22-97a9-2ecc01fac96b	2026-08-27 11:53	2026-08-27 11:53	2026-08-27 11:53	SPXW	SPXW260827C07715000	call	7715.0000	2026-08-27	14.3400	14.3000	14.5000	7723.8000	116160.00	0.00	116160.00	81	12	41860	1803	23.2168607875763	0.138616354720437	0.137001423090447	false	false	false	true	false
a38ff90e-9062-446c-ac5d-48a19bacc6d0	2026-08-27 11:53	2026-08-27 11:53	2026-08-27 11:53	SPXW	SPXW260827C07690000	call	7690.0000	2026-08-27	35.8000	35.7000	36.0000	7724.3500	110990.00	0.00	107400.00	31	6	5897	1186	4.97217537942664	0.162648219017954	0.165963541332081	false	false	false	true	false
184b7d94-665c-4156-8112-68aa064d9f54	2026-08-27 11:54	2026-08-27 11:54	2026-08-27 11:54	SPXW	SPXW260827C07735000	call	7735.0000	2026-08-27	4.0200	3.9000	4.1000	7724.2200	100550.00	98550.00	0.00	250	41	57397	3669	15.6437721449986	0.123733104699906	0.123733104699906	false	false	false	true	false
2cbb629c-d1b4-4bd5-9be0-b5aeda0048a9	2026-08-27 11:55	2026-08-27 11:55	2026-08-27 11:55	SPXW	SPXW260831C07730000	call	7730.0000	2026-08-31	28.1200	28.1000	28.4000	7724.6200	182750.00	0.00	182750.00	65	15	525	525	1	0.0907375104748547	0.0904274367840661	true	false	false	true	false
70bbd4ee-ea7c-46e6-8335-c9704f016573	2026-08-27 12:02	2026-08-27 12:02	2026-08-27 12:02	SPXW	SPXW260828C07700000	call	7700.0000	2026-08-28	39.7000	39.6000	39.8000	7724.9300	150860.00	142920.00	7940.00	38	5	4810	5440	0.884191176470588	0.153589642344501	0.153589642344501	false	false	false	true	false
bfce043c-901b-4c77-a840-36ade4e8d1d8	2026-08-27 12:18	2026-08-27 12:18	2026-08-27 12:18	SPXW	SPXW260904C07800000	call	7800.0000	2026-09-04	18.5000	18.3000	18.5000	7724.2000	177600.00	0.00	0.00	96	6	442	2159	0.204724409448819	0.0979799242544777	0.0979799242544777	false	false	false	true	false
a7d868ed-ef5b-474a-b263-f7523e71eaeb	2026-08-27 12:18	2026-08-27 12:18	2026-08-27 12:18	SPXW	SPXW260911P07500000	put	7500.0000	2026-09-11	15.2000	15.3000	15.5000	7724.2000	112480.00	0.00	0.00	74	6	160	1368	0.116959064327485	0.140504669435702	0.140504669435702	false	false	false	true	false
76e7d067-89fd-4e4d-8f76-411d6f05f2f2	2026-08-27 12:18	2026-08-27 12:18	2026-08-27 12:18	SPXW	SPXW260930P07000000	put	7000.0000	2026-09-30	11.9000	11.6000	11.9000	7724.2500	118990.00	118990.00	0.00	100	6	1181	20674	0.0571248911676502	0.21252182886239	0.21252182886239	false	false	false	true	false
f845ab87-65b3-49a6-8487-4238ca04fc6d	2026-08-27 12:20	2026-08-27 12:20	2026-08-27 12:20	SPXW	SPXW260827P07765000	put	7765.0000	2026-08-27	40.9000	40.8000	41.5000	7724.0500	233130.00	0.00	233130.00	57	7	219	80	2.7375	0.113755443439814	0.113755443439814	false	false	false	true	false
1a645738-0404-41ef-b1d6-d79d9798d5c9	2026-08-27 12:20	2026-08-27 12:20	2026-08-27 12:20	SPXW	SPXW261030P07200000	put	7200.0000	2026-10-30	47.9700	47.8000	48.3000	7724.1300	479660.00	0.00	479660.00	100	6	118	1606	0.0734744707347447	0.184368655951488	0.184236033750568	false	false	false	true	false
5658348c-8dd5-48b7-9193-2a63eb57d737	2026-08-27 12:22	2026-08-27 12:22	2026-08-27 12:22	SPXW	SPXW261030P07750000	put	7750.0000	2026-10-30	161.5000	160.6000	163.4000	7721.9700	1614950.00	1048650.00	566300.00	100	8	101	2442	0.0413595413595414	0.134251742456835	0.134796291461826	false	false	false	true	false