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.

523,327 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts523,327 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:alert_rule = RepeatedHitsDescendingFill×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	expiry

bed42c32-9317-4e89-9ec4-d349eb968f91	2026-09-28 12:38	2026-09-28 12:38	2026-09-28 12:38	SPXW	SPXW260928P07700000	put	7700.0000	2026-09-28	8.8400	8.8000	8.9000	7705.0600	45090.00	18690.00	26400.00	51	9	53822	3222	16.7045313469894	0.188895652731171	0.186267231329577	false	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	—	—	—	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-28T16:39:53.834597Z"}	2026-09-28	2026-09-28 21:15	2026-09-28 21:15
63368dc9-a42f-4234-8333-430744e56c48	2026-09-28 12:38	2026-09-28 12:38	2026-09-28 12:38	SPXW	SPXW260928C07730000	call	7730.0000	2026-09-28	2.9600	2.9000	3.1000	7705.9800	148075.00	0.00	148075.00	500	49	50298	1033	48.6911907066796	0.184113932739732	0.182722273014514	false	false	false	true
8754485d-2b77-4d45-b62b-d3a646182519	2026-09-28 12:38	2026-09-28 12:38	2026-09-28 12:38	SPXW	SPXW260929C07730000	call	7730.0000	2026-09-29	13.6500	13.5000	13.8000	7706.3500	24570.00	5480.00	13650.00	18	6	1604	338	4.74556213017751	0.14487854001793	0.14487854001793	false	false	false	true
0726ccb8-0bf9-4ae7-b762-7387cea815ff	2026-09-28 12:38	2026-09-28 12:38	2026-09-28 12:38	SPXW	SPXW260928P07710000	put	7710.0000	2026-09-28	13.0000	12.9000	13.1000	7706.4400	55880.00	42900.00	2580.00	43	8	24315	1846	13.1717226435536	0.185874604567027	0.184201735906566	false	false	false	true
10faeac4-8863-4262-8dae-9dc22527970a	2026-09-28 12:38	2026-09-28 12:38	2026-09-28 12:38	SPXW	SPXW260928C07710000	call	7710.0000	2026-09-28	9.2900	9.2000	9.4000	7707.4100	16720.00	13950.00	1840.00	18	8	70379	508	138.541338582677	0.17410101402823	0.172433747556875	false	false	false	true
4cf74386-1485-4d30-899c-e1500b3134a1	2026-09-28 12:37	2026-09-28 12:37	2026-09-28 12:37	SPXW	SPXW260928C07735000	call	7735.0000	2026-09-28	3.0000	3.0000	3.1000	7710.8300	12010.00	310.00	11700.00	40	15	33557	1277	26.2779953014879	0.186176141418537	0.18379189378201	false	false	false	true
d5b9153a-ea84-4944-af82-92c139170913	2026-09-28 12:36	2026-09-28 12:36	2026-09-28 12:36	SPXW	SPXW260928C07715000	call	7715.0000	2026-09-28	9.3300	9.3000	9.5000	7710.1700	31730.00	0.00	30790.00	34	11	54370	745	72.9798657718121	0.191822896805346	0.191822896805346	false	false	false	true
bcd220da-6c4a-4add-9b01-6f1ca2639a9b	2026-09-28 12:36	2026-09-28 12:36	2026-09-28 12:36	SPXW	SPXW260928C07720000	call	7720.0000	2026-09-28	7.3100	7.3000	7.4000	7710.1700	19000.00	1480.00	17520.00	26	11	56700	505	112.277227722772	0.191955092638243	0.190207001613931	false	false	false	true
d749036e-ebb0-4113-a762-af581a1cc65f	2026-09-28 12:36	2026-09-28 12:36	2026-09-28 12:36	SPXW	SPXW260928C07710000	call	7710.0000	2026-09-28	11.3000	11.3000	11.5000	7710.1300	40690.00	0.00	39550.00	36	6	69354	508	136.523622047244	0.18632744915891	0.184674705742142	false	false	false	true
5cead4e4-472b-4e07-8d8c-a4d0700910f5	2026-09-28 12:36	2026-09-28 12:36	2026-09-28 12:36	SPXW	SPXW260928P07710000	put	7710.0000	2026-09-28	10.9300	10.8000	11.1000	7709.8100	33880.00	6540.00	14160.00	31	8	23756	1846	12.8689057421452	0.181150178312	0.179498137659278	false	false	false	true
aea946db-f1ae-421e-8e45-14818c8f8e24	2026-09-28 12:36	2026-09-28 12:36	2026-09-28 12:36	SPXW	SPXW260928P07710000	put	7710.0000	2026-09-28	11.7000	11.6000	11.8000	7708.9700	97120.00	1180.00	94770.00	83	13	23443	1846	12.6993499458288	0.187259450282166	0.185614723482408	false	false	false	true
ae8bc93c-c0ab-4fd6-a419-59bcf0881a4b	2026-09-28 12:35	2026-09-28 12:35	2026-09-28 12:35	SPXW	SPXW260928C07710000	call	7710.0000	2026-09-28	10.7700	10.7000	10.9000	7708.5100	25840.00	0.00	25840.00	24	6	69019	508	135.864173228346	0.189188016866156	0.187536923391426	false	false	false	true
acc360fd-1aa8-4c55-b628-4161fcf5a843	2026-09-28 12:35	2026-09-28 12:35	2026-09-28 12:35	SPXW	SPXW260928C07740000	call	7740.0000	2026-09-28	2.0500	2.0500	2.1500	7707.6800	10680.00	0.00	10470.00	52	9	40983	1956	20.9524539877301	0.194820308048419	0.194820308048419	false	false	false	true
8b42ce70-3419-4655-90dc-b122d4dd41a6	2026-09-28 12:35	2026-09-28 12:34	2026-09-28 12:34	SPXW	SPXW260928P07710000	put	7710.0000	2026-09-28	12.5700	12.5000	12.7000	7707.5700	18850.00	1260.00	6250.00	15	5	23124	1846	12.5265438786566	0.187795745698189	0.186144238197998	true	false	false	true
247d13f9-27f7-4ff5-af0b-32a987bf0747	2026-09-28 12:34	2026-09-28 12:34	2026-09-28 12:34	SPXW	SPXW260928P07690000	put	7690.0000	2026-09-28	4.6900	4.6000	4.8000	7708.4300	32350.00	0.00	32350.00	69	14	37645	1292	29.1369969040248	0.192937944894086	0.192937944894086	false	false	false	true
0b6a5a2b-12e1-4aba-9157-473432c34727	2026-09-28 12:34	2026-09-28 12:33	2026-09-28 12:33	SPXW	SPXW260928C07710000	call	7710.0000	2026-09-28	10.0100	10.0000	10.1000	7707.5700	13010.00	1010.00	12000.00	13	5	68363	508	134.572834645669	0.184186759080839	0.182539010951285	false	false	false	true
120d3b3a-1974-4a14-a83c-119f0b733838	2026-09-28 12:33	2026-09-28 12:33	2026-09-28 12:33	SPXW	SPXW260928C07710000	call	7710.0000	2026-09-28	10.1800	10.1000	10.3000	7707.6200	20350.00	0.00	7090.00	20	5	68339	508	134.525590551181	0.185433231002765	0.185433231002765	false	false	false	true
1f627630-c0c9-4f71-b134-8662bda0f3f9	2026-09-28 12:33	2026-09-28 12:33	2026-09-28 12:33	SPXW	SPXW260928C07710000	call	7710.0000	2026-09-28	10.7100	10.5000	10.8000	7708.1300	20350.00	6470.00	10700.00	19	6	68148	508	134.149606299213	0.191190673597843	0.187910947084683	false	false	false	true
a522a951-5aa7-4571-be17-91b7935de1ec	2026-09-28 12:33	2026-09-28 12:33	2026-09-28 12:33	SPXW	SPXW260928P07700000	put	7700.0000	2026-09-28	8.7400	8.5000	9.4000	7706.2400	21850.00	860.00	20990.00	25	11	51624	3222	16.0223463687151	0.197076408109415	0.188681060146595	false	false	false	true
3906ef1f-5ffb-4010-aa90-5ea0824d2589	2026-09-28 12:33	2026-09-28 12:33	2026-09-28 12:33	SPXW	SPXW260928P07700000	put	7700.0000	2026-09-28	9.2900	9.0000	9.6000	7705.5600	14860.00	0.00	14860.00	16	8	51588	3222	16.0111731843575	0.197317062529011	0.192305194106305	false	false	false	true
a687f42b-a1ca-4389-942d-46b19ba76990	2026-09-28 12:33	2026-09-28 12:33	2026-09-28 12:33	SPXW	SPXW260928P07720000	put	7720.0000	2026-09-28	20.8400	20.7000	21.1000	7705.3100	18760.00	6300.00	12460.00	9	6	9262	1544	5.99870466321244	0.200931069936307	0.20276213859396	false	false	false	true
918386b5-dabb-40bb-8874-ae7e9883e3bf	2026-09-28 12:33	2026-09-28 12:33	2026-09-28 12:33	SPXW	SPXW260928P07705000	put	7705.0000	2026-09-28	12.0800	12.0000	12.2000	7705.1100	15700.00	0.00	14490.00	13	5	29269	1442	20.2975034674064	0.200304798000785	0.19866504454939	false	false	false	true
20f9dc96-143b-4869-92e3-8c721be71859	2026-09-28 12:33	2026-09-28 12:32	2026-09-28 12:32	SPXW	SPXW260928P07710000	put	7710.0000	2026-09-28	12.9700	12.9000	13.2000	7706.9100	64870.00	0.00	64870.00	50	10	22395	1846	12.1316359696641	0.189305595177416	0.189305595177416	false	false	false	true
93f9f0d4-5299-468f-8289-d8b25d14b8e2	2026-09-28 12:32	2026-09-28 12:32	2026-09-28 12:32	SPXW	SPXW260928P07680000	put	7680.0000	2026-09-28	3.3700	3.1000	3.5000	7706.7000	14850.00	10740.00	4110.00	44	17	71196	1391	51.1833213515457	0.204950795679592	0.197747705328308	false	false	false	true
e7324174-4e2b-408e-8f39-c521fdfeb3c0	2026-09-28 12:32	2026-09-28 12:32	2026-09-28 12:32	SPXW	SPXW260928C07715000	call	7715.0000	2026-09-28	8.2300	7.7000	8.9000	7710.1900	31270.00	1780.00	29490.00	38	6	52920	745	71.0335570469799	0.181472267545297	0.166509862000508	false	false	false	true
620587de-cde6-4a71-a128-1856a1412725	2026-09-28 12:32	2026-09-28 12:32	2026-09-28 12:32	SPXW	SPXW260928C07710000	call	7710.0000	2026-09-28	10.4000	10.1000	11.1000	7710.1900	84200.00	2140.00	82060.00	81	8	67067	508	132.021653543307	0.177546289373432	0.162808207682652	false	false	false	true
1a805fe3-efb8-4a5f-8d90-994e6ff4c0fe	2026-09-28 12:32	2026-09-28 12:32	2026-09-28 12:32	SPXW	SPXW260928C07685000	call	7685.0000	2026-09-28	27.3100	25.9000	27.8000	7710.1900	103760.00	0.00	103760.00	38	7	30056	138	217.797101449275	0.167735383369278	0.123524633685719	false	false	false	true
f018780a-b17c-436e-82cf-3100a0910858	2026-09-28 12:32	2026-09-28 12:32	2026-09-28 12:32	SPXW	SPXW260929P07710000	put	7710.0000	2026-09-29	23.4200	23.4000	23.6000	7711.5100	11710.00	0.00	9360.00	5	5	1046	292	3.58219178082192	0.153187021276752	0.153187021276752	false	false	false	true
59280715-7862-4849-bc70-ac2dc899b358	2026-09-28 12:31	2026-09-28 12:31	2026-09-28 12:31	SPXW	SPXW260928P07715000	put	7715.0000	2026-09-28	13.1100	13.1000	13.3000	7711.9100	17040.00	0.00	15720.00	13	5	10445	1067	9.78912839737582	0.190322742938944	0.188681499724413	false	false	false	true
570f52c6-b883-4567-acc6-af2d77a4e7b6	2026-09-28 12:31	2026-09-28 12:31	2026-09-28 12:31	SPXW	SPXW260928C07720000	call	7720.0000	2026-09-28	7.7100	7.6000	7.8000	7711.4600	15410.00	780.00	3080.00	20	6	54438	505	107.79801980198	0.187983912771541	0.186281024800258	false	false	false	true
f0729fd7-9972-4e18-8af3-02145d955179	2026-09-28 12:30	2026-09-28 12:30	2026-09-28 12:30	SPXW	SPXW260928C07715000	call	7715.0000	2026-09-28	9.9900	9.9000	10.0000	7690.0000	30980.00	29000.00	1980.00	31	9	52188	745	70.0510067114094	0.182048928712768	0.182429744022243	false	false	false	true
3f3f7fde-1d47-4856-b363-bc2fb8449be6	2026-09-28 12:30	2026-09-28 12:30	2026-09-28 12:30	SPXW	SPXW260928C07730000	call	7730.0000	2026-09-28	4.7100	4.7000	4.8000	7690.0000	10840.00	1440.00	9400.00	23	7	46334	1033	44.8538238141336	0.183435599184698	0.183435599184698	false	false	false	true
7225d3d4-9880-49e4-9966-c2cd640a675b	2026-09-28 12:30	2026-09-28 12:30	2026-09-28 12:30	SPXW	SPXW260928C07715000	call	7715.0000	2026-09-28	10.8600	10.7000	11.0000	7690.0000	14120.00	6540.00	2140.00	13	5	51935	745	69.7114093959731	0.186369342061308	0.183111260160868	false	false	false	true
daa4948b-f1e8-415a-9055-75fed13b8e0e	2026-09-28 12:30	2026-09-28 12:30	2026-09-28 12:30	SPXW	SPXW260928P07710000	put	7710.0000	2026-09-28	10.3900	10.3000	10.5000	7690.0000	66520.00	50960.00	5160.00	64	14	21063	1846	11.4100758396533	0.202145681945423	0.202145681945423	false	false	false	true
ea624b39-2e6e-4d42-b320-ff9dbbabc840	2026-09-28 12:30	2026-09-28 12:30	2026-09-28 12:30	SPXW	SPXW260928P07715000	put	7715.0000	2026-09-28	12.1500	12.1000	12.3000	7695.0000	15800.00	3660.00	9700.00	13	8	9937	1067	9.31302717900656	0.202317470831637	0.200690371804096	false	false	false	true
94cd1352-7a62-4baf-9db4-1efdc9a16392	2026-09-28 12:30	2026-09-28 12:29	2026-09-28 12:29	SPXW	SPXW260928C07720000	call	7720.0000	2026-09-28	9.9800	9.9000	10.1000	7695.0000	19950.00	15000.00	4950.00	20	7	53639	505	106.215841584158	0.189120941543765	0.187484954454096	false	false	false	true
49fc309d-9e83-449d-9018-89a582ff614d	2026-09-28 12:29	2026-09-28 12:29	2026-09-28 12:29	SPXW	SPXW260929C07705000	call	7705.0000	2026-09-29	30.8400	30.7000	31.1000	7695.0000	30840.00	0.00	18480.00	10	7	2394	336	7.125	0.147443799778662	0.147443799778662	false	false	false	true
df7d95b1-65e7-428d-8a44-ad14d1d3b5e7	2026-09-28 12:29	2026-09-28 12:29	2026-09-28 12:29	SPXW	SPXW260928C07720000	call	7720.0000	2026-09-28	10.4800	10.3000	10.6000	7695.0000	10480.00	0.00	9440.00	10	7	53403	505	105.748514851485	0.181123207580258	0.179498296177767	false	false	false	true
77fd2ddc-d09e-4c2c-ba99-67419bcba29d	2026-09-28 12:29	2026-09-28 12:29	2026-09-28 12:29	SPXW	SPXW260928C07735000	call	7735.0000	2026-09-28	5.0500	4.9000	5.2000	7695.0000	11620.00	5120.00	6500.00	23	6	31227	1277	24.4534064212999	0.185927923935267	0.184026079756294	false	false	false	true
75fb21ef-6c85-4ce7-8689-21a9a194ce09	2026-09-28 12:29	2026-09-28 12:29	2026-09-28 12:29	SPXW	SPXW260928C07725000	call	7725.0000	2026-09-28	8.7800	8.7000	8.9000	7695.0000	14920.00	10560.00	3480.00	17	7	46644	869	53.6754890678941	0.188405216765923	0.18675519979023	false	false	false	true
359ff672-44a1-4eb6-89ea-278d7c34a7f3	2026-09-28 12:29	2026-09-28 12:28	2026-09-28 12:28	SPXW	SPXW260928P07715000	put	7715.0000	2026-09-28	10.5000	10.4000	10.6000	7695.0000	17850.00	4210.00	4190.00	17	10	9499	1067	8.90253045923149	0.199543965164042	0.196279542703248	false	false	false	true
eaab4fc8-4222-4870-8b96-cfc51bf6c516	2026-09-28 12:28	2026-09-28 12:28	2026-09-28 12:28	SPXW	SPXW260928C07750000	call	7750.0000	2026-09-28	2.8500	2.7500	2.9000	7700.0000	31580.00	1140.00	30160.00	111	19	33566	2974	11.2864828513786	0.194101632635028	0.194109333961503	false	false	false	true
1fe04a80-ba3d-4a88-a71b-40c04c8a1bf9	2026-09-28 12:28	2026-09-28 12:28	2026-09-28 12:28	SPXW	SPXW260930C07770000	call	7770.0000	2026-09-30	12.4500	12.4000	12.8000	7700.0000	18680.00	0.00	18680.00	15	6	757	3509	0.215730977486463	0.13484187437215	0.13484187437215	false	false	false	true
9018d346-dbcb-4f80-85ce-2eef8d052d47	2026-09-28 12:28	2026-09-28 12:28	2026-09-28 12:28	SPXW	SPXW260928C07730000	call	7730.0000	2026-09-28	7.9200	7.9000	8.1000	7720.8300	15840.00	0.00	15040.00	20	13	45100	1033	43.6592449177154	0.193809914061297	0.193809914061297	false	false	false	true
d6726190-fcde-49df-a735-7dcc4430c5a4	2026-09-28 12:28	2026-09-28 12:28	2026-09-28 12:28	SPXW	SPXW260928P07700000	put	7700.0000	2026-09-28	4.0300	4.0000	4.2000	7722.4600	40340.00	0.00	40340.00	100	14	48574	3222	15.0757293606456	0.197776422477133	0.197776422477133	false	false	false	true
6ff20c65-7142-4629-8ab5-6a0fb4b4ad30	2026-09-28 12:28	2026-09-28 12:28	2026-09-28 12:28	SPXW	SPXW260928C07725000	call	7725.0000	2026-09-28	10.3500	10.2000	10.6000	7722.4100	19660.00	3140.00	16520.00	19	12	46012	869	52.9482163406214	0.189044326498905	0.184175591730019	false	false	false	true
5b24092a-b396-4e46-b747-b826102412e8	2026-09-28 12:28	2026-09-28 12:28	2026-09-28 12:28	SPXW	SPXW260928P07720000	put	7720.0000	2026-09-28	11.0000	11.0000	11.2000	7722.4600	23110.00	0.00	22000.00	21	8	7443	1544	4.82059585492228	0.199755645547165	0.198132459683013	false	false	false	true
023fc312-955f-4268-8654-436f314b6908	2026-09-28 12:28	2026-09-28 12:28	2026-09-28 12:28	SPXW	SPXW260928P07720000	put	7720.0000	2026-09-28	11.9200	11.8000	12.1000	7720.1200	51250.00	3570.00	15550.00	43	14	7328	1544	4.74611398963731	0.196062317207047	0.192827508669498	false	false	false	true
185b8875-1d25-4fef-a9bc-eece4b73bd0e	2026-09-28 12:27	2026-09-28 12:27	2026-09-28 12:27	SPXW	SPXW260928C07750000	call	7750.0000	2026-09-28	3.1000	3.0000	3.3000	7720.1600	34420.00	0.00	33170.00	111	14	32699	2974	10.9949562878278	0.209636566893461	0.207179479085779	true	false	false	true
acbf1747-ed3c-47a1-929b-cd422e5e1c10	2026-09-28 12:27	2026-09-28 12:27	2026-09-28 12:27	SPXW	SPXW260928P07720000	put	7720.0000	2026-09-28	12.6200	12.6000	12.8000	7719.4600	23980.00	1280.00	21430.00	19	7	7076	1544	4.58290155440415	0.201863174939013	0.200254856944986	false	false	false	true