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.

375,978 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts375,978 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:alert_rule = RepeatedHits×source = uw_flow_alerts×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	expiry

30793b4a-4f5b-4709-8326-45a8f4828721	2026-09-23 16:36	2026-09-23 16:25	2026-09-23 16:25	SPX	SPX261218C08350000	call	8350.0000	2026-12-18	21.7000	21.3000	21.9000	7685.0000	32550.00	32550.00	0.00	15	5	1067	6304	0.169257614213198	0.11461511467253	0.11461511467253	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-23	2026-09-23 21:15	2026-09-23 21:15
a8be7695-3660-42cb-bbb7-eeb18de629c4	2026-09-23 16:10	2026-09-23 16:10	2026-09-23 16:10	SPX	SPX261218P07770000	put	7770.0000	2026-12-18	203.0000	201.8000	202.7000	7685.0000	11266500.00	0.00	0.00	555	15	3919	1321	2.9666919000757	0.140093681993585	0.140093681993585	false	false	false
a647d9f3-0c87-4f02-934a-c54138bef58d	2026-09-23 16:10	2026-09-23 16:10	2026-09-23 16:10	SPX	SPX261218C07770000	call	7770.0000	2026-12-18	204.0000	203.8000	204.8000	7685.0000	11322000.00	0.00	0.00	555	13	3906	1363	2.86573734409391	0.132833603757698	0.132833603757698	false	false	false
4c90b40d-31db-4884-9a4e-874589049c60	2026-09-23 16:10	2026-09-23 16:10	2026-09-23 16:10	SPX	SPX270115P07050000	put	7050.0000	2027-01-15	77.4000	76.8000	77.4000	7685.0000	11610000.00	0.00	0.00	1500	15	1514	5727	0.264361795006111	0.197687456428912	0.197687456428912	false	false	false
1b91799e-c5ad-4e89-b569-155584dd18a3	2026-09-23 16:10	2026-09-23 16:10	2026-09-23 16:10	SPX	SPX261120P07800000	put	7800.0000	2026-11-20	183.4000	182.7000	183.5000	7685.0000	27510000.00	0.00	0.00	1500	13	2259	4430	0.509932279909707	0.130815925187237	0.130815925187237	false	false	false
7329889d-aefa-4e3a-9131-58c03a8a4fd9	2026-09-23 16:07	2026-09-23 16:07	2026-09-23 16:07	SPX	SPX261218P07140000	put	7140.0000	2026-12-18	66.5000	66.5000	67.1000	7685.0000	219450.00	0.00	219450.00	33	5	84	2138	0.039289055191768	0.192445811666197	0.192445811666197	true	false	false	true
2743784a-6a66-4f64-b6cd-449d4de2f770	2026-09-23 16:07	2026-09-23 16:07	2026-09-23 16:07	SPX	SPX261218P07140000	put	7140.0000	2026-12-18	66.5000	66.5000	67.1000	7685.0000	332500.00	0.00	332500.00	50	6	51	2138	0.0238540692235734	0.192445811666197	0.192445811666197	true	false	false
762fcbd4-d38e-4cf9-abfe-634687a9e127	2026-09-23 16:05	2026-09-23 16:05	2026-09-23 16:05	SPX	SPX261016P06400000	put	6400.0000	2026-10-16	2.7000	2.7000	2.9000	7685.0000	13500.00	0.00	13500.00	50	7	350	15623	0.0224028675670486	0.337010192688336	0.337010192688336	true	false	false	true
07f7ce83-cd14-4b2e-a881-200277dadeee	2026-09-23 16:05	2026-09-23 16:05	2026-09-23 16:05	SPX	SPX261016P06750000	put	6750.0000	2026-10-16	4.8000	4.5000	4.8000	7685.0000	24000.00	24000.00	0.00	50	6	154	7287	0.021133525456292	0.275416014309999	0.275416014309999	true	false	false	true
79a30d52-6aff-4d37-b39e-b2fba163281a	2026-09-23 16:05	2026-09-23 16:05	2026-09-23 16:05	SPX	SPX261016P06790000	put	6790.0000	2026-10-16	5.1000	4.9000	5.1000	7685.0000	25500.00	25500.00	0.00	50	5	50	534	0.0936329588014981	0.267828443104984	0.267828443104984	true	false	false	true
6db9d4a7-71c8-40f1-b429-b001297b827c	2026-09-23 16:05	2026-09-23 16:05	2026-09-23 16:05	SPX	SPX261016P06750000	put	6750.0000	2026-10-16	4.8000	4.5000	4.8000	7685.0000	24000.00	24000.00	0.00	50	5	104	7287	0.0142719912172362	0.275416014309999	0.275416014309999	true	false	false	true
025c9055-b3aa-46c4-ac17-3b139fbe2ba4	2026-09-23 16:04	2026-09-23 16:04	2026-09-23 16:04	SPX	SPX261016P06400000	put	6400.0000	2026-10-16	2.6500	2.6500	2.8000	7685.0000	13250.00	0.00	13250.00	50	9	250	15623	0.0160020482621776	0.336166450924141	0.336166450924141	true	false	false	true
ccda55ba-7d78-4076-9ca1-3a398f8a7cf9	2026-09-23 16:04	2026-09-23 16:04	2026-09-23 16:04	SPX	SPX261016P06400000	put	6400.0000	2026-10-16	2.6500	2.6500	2.8500	7685.0000	13250.00	0.00	13250.00	50	8	200	15623	0.012801638609742	0.336164475364707	0.336164475364707	true	false	false	true
49ec35d8-bdd2-4d18-b120-4c4312e72d72	2026-09-23 16:04	2026-09-23 16:04	2026-09-23 16:04	SPX	SPX261120P05875000	put	5875.0000	2026-11-20	7.2000	7.2000	7.4000	7685.0000	15120.00	0.00	15120.00	21	9	777	2144	0.36240671641791	0.343483663404942	0.343483663404942	false	false	false	true
be3c0f3d-55f4-4b62-8593-a80213060891	2026-09-23 16:04	2026-09-23 16:04	2026-09-23 16:04	SPX	SPX261218P05650000	put	5650.0000	2026-12-18	11.8000	11.5000	11.8000	7685.0000	34220.00	34220.00	0.00	29	6	110	5670	0.0194003527336861	0.345215155015234	0.345215155015234	true	false	false
93d082f4-0c93-4f09-afcb-99d7e498da14	2026-09-23 16:04	2026-09-23 16:04	2026-09-23 16:04	SPX	SPX261218P05850000	put	5850.0000	2026-12-18	14.3000	14.0000	14.3000	7685.0000	34320.00	34320.00	0.00	24	7	24	4392	0.00546448087431694	0.323488467939012	0.323488467939012	true	false	false
368ab7ab-6b56-423c-a53f-9f1af5acf9f8	2026-09-23 16:04	2026-09-23 16:04	2026-09-23 16:04	SPX	SPX270319P05825000	put	5825.0000	2027-03-19	37.9000	37.4000	37.9000	7685.0000	26530.00	26530.00	0.00	7	6	18	444	0.0405405405405405	0.286184322657426	0.286184322657426	true	false	false	true
3371a70b-daaa-4093-b073-c4df9819ca67	2026-09-23 16:04	2026-09-23 16:04	2026-09-23 16:04	SPX	SPX261218P05400000	put	5400.0000	2026-12-18	9.3000	9.0000	9.3000	7685.0000	36270.00	36270.00	0.00	39	6	39	14727	0.00264819718883683	0.372590718193627	0.372590718193627	true	false	false	true
1a9e8089-b198-4445-b734-a1e6813caaca	2026-09-23 16:04	2026-09-23 16:04	2026-09-23 16:04	SPX	SPX261218P06600000	put	6600.0000	2026-12-18	32.1000	31.7000	32.1000	7685.0000	115560.00	115560.00	0.00	36	6	137	31491	0.00435044933473056	0.245334210423837	0.245334210423837	true	false	false
b8ac662c-c6c7-477d-9b5d-a495764ad425	2026-09-23 16:03	2026-09-23 16:03	2026-09-23 16:03	SPX	SPX261016P06400000	put	6400.0000	2026-10-16	2.7000	2.7000	2.9000	7685.0000	13500.00	0.00	13500.00	50	5	50	15623	0.00320040965243551	0.337033944463683	0.337033944463683	true	false	false	true
8c60ef9a-8e85-44b2-8c28-3a09835ea11a	2026-09-23 16:03	2026-09-23 16:03	2026-09-23 16:03	SPX	SPX261016P07150000	put	7150.0000	2026-10-16	10.2000	10.2000	10.5000	7685.0000	17340.00	0.00	17340.00	17	7	102	8966	0.0113763105063574	0.201292473213296	0.201292473213296	true	false	false
5d4d2df1-c2d5-4c6b-bdfc-8e7815036c17	2026-09-23 16:03	2026-09-23 16:03	2026-09-23 16:03	SPX	SPX261120P06950000	put	6950.0000	2026-11-20	29.0000	29.0000	29.5000	7685.0000	20300.00	0.00	20300.00	7	6	23	4499	0.0051122471660369	0.213778038786113	0.213778038786113	true	false	false	true
e0b74b97-35cb-41a9-90c0-f889673aead5	2026-09-23 16:03	2026-09-23 16:03	2026-09-23 16:03	SPX	SPX270115P07060000	put	7060.0000	2027-01-15	77.7000	77.7000	78.6000	7685.0000	202020.00	0.00	202020.00	26	7	38	3	12.6666666666667	0.196232805990132	0.196232805990132	true	false	false	true
1953c57f-7676-4957-90b8-dca3b8a88999	2026-09-23 16:03	2026-09-23 16:03	2026-09-23 16:03	SPX	SPX261016P06450000	put	6450.0000	2026-10-16	2.9000	2.9000	3.1000	7685.0000	14500.00	0.00	14500.00	50	5	54	10283	0.00525138578235923	0.328031579777404	0.328031579777404	true	false	false	true
247f4b48-1a29-4b4a-8759-92f5c5753f20	2026-09-23 16:00	2026-09-23 16:00	2026-09-23 16:00	SPX	SPX261218C07580000	call	7580.0000	2026-12-18	332.1000	330.9000	332.1000	7685.0000	664200.00	664200.00	0.00	20	5	20	294	0.0680272108843537	0.14764603584568	0.14764603584568	false	false	false
cca10e0e-79dc-4a33-9b2f-e33c194fbd1b	2026-09-23 15:58	2026-09-23 15:58	2026-09-23 15:58	SPX	SPX270917C08900000	call	8900.0000	2027-09-17	142.8000	142.0000	142.8000	7680.0000	85680.00	85680.00	0.00	6	5	554	3678	0.150625339858619	0.135547213072355	0.135547213072355	false	false	false
99612bcf-1c03-4cdf-be6d-76f212d2094f	2026-09-23 15:58	2026-09-23 15:58	2026-09-23 15:58	SPX	SPX270917C08900000	call	8900.0000	2027-09-17	142.8000	142.1000	142.8000	7680.0000	114240.00	114240.00	0.00	8	5	548	3678	0.148994018488309	0.135519539658619	0.135519539658619	false	false	false
775a43e4-7394-4748-97fc-5d4547ddf133	2026-09-23 15:58	2026-09-23 15:58	2026-09-23 15:58	SPX	SPX270617C08650000	call	8650.0000	2027-06-17	118.9000	118.9000	119.6000	7680.0000	83230.00	0.00	83230.00	7	5	1065	3988	0.267051153460381	0.130951544865729	0.130951544865729	false	false	false
58d06548-410b-4afa-b040-500850807fe3	2026-09-23 15:58	2026-09-23 15:58	2026-09-23 15:58	SPX	SPX270917C08900000	call	8900.0000	2027-09-17	142.6000	141.8000	142.6000	7680.0000	114080.00	114080.00	0.00	8	5	518	3678	0.140837411636759	0.13543262434594	0.13543262434594	false	false	false
c06cb7d0-6d75-414f-9127-25e7c18811ac	2026-09-23 15:58	2026-09-23 15:58	2026-09-23 15:58	SPX	SPX270917C08900000	call	8900.0000	2027-09-17	142.7000	142.0000	142.7000	7685.0000	156970.00	156970.00	0.00	11	6	510	3678	0.138662316476346	0.135460713116418	0.135460713116418	false	false	false
fcfb5e87-86a1-4d4e-bd3d-f86056f2d417	2026-09-23 15:58	2026-09-23 15:58	2026-09-23 15:58	SPX	SPX270917C08900000	call	8900.0000	2027-09-17	142.7000	142.0000	142.7000	7685.0000	128430.00	128430.00	0.00	9	6	499	3678	0.135671560630778	0.135445340827766	0.135445340827766	false	false	false
12f7d447-a6ad-4370-8084-d0f5f82f506c	2026-09-23 15:58	2026-09-23 15:58	2026-09-23 15:58	SPX	SPX270917C08900000	call	8900.0000	2027-09-17	142.7000	142.0000	142.7000	7685.0000	156970.00	156970.00	0.00	11	5	490	3678	0.133224578575313	0.135434067702688	0.135434067702688	false	false	false
dea8150f-fdcb-4d17-9531-800b80c2b966	2026-09-23 15:58	2026-09-23 15:57	2026-09-23 15:57	SPX	SPX270917C08900000	call	8900.0000	2027-09-17	142.6000	142.5000	142.7000	7685.0000	156860.00	42780.00	14260.00	11	5	463	3678	0.125883632408918	0.1353721685683	0.1353721685683	false	false	false
d01c2b55-51ed-4b8f-9c62-657120326a17	2026-09-23 15:57	2026-09-23 15:57	2026-09-23 15:57	SPX	SPX270617C08650000	call	8650.0000	2027-06-17	118.7000	118.7000	119.5000	7703.9200	130570.00	0.00	130570.00	11	5	972	3988	0.243731193580742	0.130834935351608	0.130834935351608	false	false	false
8da5396c-16a8-4804-8c17-967109f14d68	2026-09-23 15:57	2026-09-23 15:57	2026-09-23 15:57	SPX	SPX270917C08900000	call	8900.0000	2027-09-17	142.5000	141.7000	142.5000	7703.9200	228000.00	228000.00	0.00	16	5	419	3678	0.113920609026645	0.135421940606782	0.135421940606782	false	false	false
73cb673b-6370-429a-a417-3b25fbd3aa38	2026-09-23 15:56	2026-09-23 15:56	2026-09-23 15:56	SPX	SPX270917C08900000	call	8900.0000	2027-09-17	141.8000	141.0000	141.8000	7701.3600	184340.00	184340.00	0.00	13	7	342	3678	0.0929853181076672	0.135393748038898	0.135393748038898	false	false	false
a0a06b16-757f-43fb-843e-dd975e5f845e	2026-09-23 15:56	2026-09-23 15:56	2026-09-23 15:56	SPX	SPX270617C08650000	call	8650.0000	2027-06-17	118.3000	118.3000	119.0000	7702.2200	130130.00	0.00	130130.00	11	5	857	3988	0.214894684052156	0.130842845735322	0.130842845735322	false	false	false
5a0f1d4a-d08d-489a-a309-eb9ee7df262d	2026-09-23 15:56	2026-09-23 15:56	2026-09-23 15:56	SPX	SPX261218P06400000	put	6400.0000	2026-12-18	25.6000	25.3000	25.6000	7702.2200	128000.00	128000.00	0.00	50	6	2773	19690	0.140832910106653	0.265579480474657	0.265579480474657	true	false	false
deb53e35-f2bb-4563-b0d9-f99310ca8c6f	2026-09-23 15:56	2026-09-23 15:56	2026-09-23 15:56	SPX	SPX261218P06400000	put	6400.0000	2026-12-18	25.6000	25.2000	25.6000	7702.3300	128000.00	128000.00	0.00	50	6	2723	19690	0.138293550025394	0.265594157769029	0.265594157769029	true	false	false
aeb47fb6-65bf-4384-8891-2a4ce6be9a2c	2026-09-23 15:56	2026-09-23 15:55	2026-09-23 15:55	SPX	SPX270917C08900000	call	8900.0000	2027-09-17	142.2000	141.4000	142.2000	7702.9200	142200.00	142200.00	0.00	10	6	279	3678	0.0758564437194127	0.135400027214616	0.135400027214616	false	false	false
83fd6ab9-5bfe-4964-8571-3db77dfc017e	2026-09-23 15:50	2026-09-23 15:50	2026-09-23 15:50	SPX	SPX261120P07300000	put	7300.0000	2026-11-20	56.2000	57.1000	57.8000	7700.7900	2810000.00	0.00	0.00	500	8	1088	12503	0.087019115412301	0.174810378281428	0.174810378281428	false	false	false
6e300ce1-3851-4232-9c06-2c48ce075294	2026-09-23 15:50	2026-09-23 15:50	2026-09-23 15:50	SPX	SPX261218P07770000	put	7770.0000	2026-12-18	202.0000	205.2000	205.9000	7700.7900	10908000.00	0.00	0.00	540	8	1873	1321	1.41786525359576	0.137735896070418	0.137735896070418	false	false	false
60bfc7b0-a8e8-4113-91f8-bf01892f122d	2026-09-23 15:50	2026-09-23 15:50	2026-09-23 15:50	SPX	SPX261218C07770000	call	7770.0000	2026-12-18	206.0000	201.6000	202.5000	7700.7900	11124000.00	0.00	0.00	540	8	1870	1363	1.37197358767425	0.136006139617051	0.136006139617051	false	false	false
33a60ddd-66c3-4687-94f5-f208b266a94c	2026-09-23 15:50	2026-09-23 15:50	2026-09-23 15:50	SPX	SPX261120C07800000	call	7800.0000	2026-11-20	136.1800	132.5000	133.3000	7700.7900	13618000.00	0.00	0.00	1000	8	2409	8483	0.283979724154191	0.129713917933937	0.129713917933937	false	false	false
5571180f-41aa-420e-b5aa-656fad97ba58	2026-09-23 15:49	2026-09-23 15:49	2026-09-23 15:49	SPX	SPX261218P07555000	put	7555.0000	2026-12-18	133.0000	133.0000	133.6000	7709.5800	319200.00	0.00	319200.00	24	6	103	40	2.575	0.155935234868623	0.155935234868623	true	false	false	true
cd792b95-2817-45d0-bc3c-f1282e86a220	2026-09-23 15:48	2026-09-23 15:48	2026-09-23 15:48	SPX	SPX261218P06000000	put	6000.0000	2026-12-18	16.4000	16.2000	16.5000	7708.3000	32800.00	27880.00	3280.00	20	16	658	153915	0.00427508689861287	0.307008174137976	0.307010586176207	false	false	false
af2cec85-65ee-418d-bd98-57b0b994650c	2026-09-23 15:48	2026-09-23 15:48	2026-09-23 15:48	SPX	SPX261218P06000000	put	6000.0000	2026-12-18	16.4000	16.2000	16.5000	7708.5800	16400.00	16400.00	0.00	10	5	636	153915	0.00413215086248904	0.30704435362754	0.30704435362754	false	false	false
fb52f7eb-80de-458e-98f4-7d426690a3dc	2026-09-23 15:48	2026-09-23 15:48	2026-09-23 15:48	SPX	SPX261218P06300000	put	6300.0000	2026-12-18	22.5000	22.3000	22.6000	7708.6900	18000.00	18000.00	0.00	8	8	820	26413	0.031045318593117	0.275676304092293	0.275676304092293	false	false	false
5646e3d7-d50b-492e-a67b-dba21593916b	2026-09-23 15:44	2026-09-23 15:44	2026-09-23 15:44	SPX	SPX261016P06025000	put	6025.0000	2026-10-16	1.7500	1.6000	1.7500	7685.0000	70000.00	70000.00	0.00	400	5	440	2028	0.216962524654832	0.407982725379545	0.407982725379545	false	false	false	true
b3d28b88-2f2f-4a98-84a1-6bacdcf73ac2	2026-09-23 15:44	2026-09-23 15:44	2026-09-23 15:44	SPX	SPX261016P06050000	put	6050.0000	2026-10-16	1.8000	1.6500	1.8000	7685.0000	36000.00	36000.00	0.00	200	7	200	4987	0.0401042711048727	0.403203361989897	0.403203361989897	false	false	false	true