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.

728,802 rows

Sources in this table

uw_flow_alerts728,802 rows

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:option_symbol = SPXW260925P07670000×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

16471ccd-0982-4938-a8fc-9a2dcfcb06a1	2026-09-25 12:11	2026-09-25 12:11	2026-09-25 12:11	SPXW	SPXW260925P07670000	put	7670.0000	2026-09-25	0.4000	0.4000	0.4500	7725.0000	10000.00	0.00	10000.00	250	13	43805	1979	22.1349166245579	0.245645973724626	0.245645973724626	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	—	—	—	—	—	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-25T16:14:10.282260Z"}	2026-09-25	2026-09-25 21:15	2026-09-25 21:15
8d991ad8-48d3-4fb2-8b3a-0f62eb98ad92	2026-09-25 11:20	2026-09-25 11:20	2026-09-25 11:20	SPXW	SPXW260925P07670000	put	7670.0000	2026-09-25	1.5000	1.5000	1.5500	7715.4000	30000.00	0.00	30000.00	200	13	34027	1979	17.1940373926225	0.194293670676017	0.194293670676017	false	false	false	true
3ddafc3e-30fe-4b31-91a9-8b92338479b8	2026-09-25 11:09	2026-09-25 11:09	2026-09-25 11:09	SPXW	SPXW260925P07670000	put	7670.0000	2026-09-25	1.1000	1.0500	1.1500	7722.4000	13420.00	1980.00	11440.00	122	8	32312	1979	16.3274381000505	0.19683624959936	0.19683624959936	false	false	false	true
22dda801-5790-462b-9f19-fda2df4ac5e7	2026-09-25 11:09	2026-09-25 11:09	2026-09-25 11:09	SPXW	SPXW260925P07670000	put	7670.0000	2026-09-25	1.0500	1.0000	1.1000	7723.0800	14280.00	5565.00	5880.00	136	8	32086	1979	16.2132390096008	0.196545231911943	0.196545231911943	false	false	false	true
3b765fea-ba1d-41f5-b233-e020282fc04f	2026-09-25 10:37	2026-09-25 10:37	2026-09-25 10:37	SPXW	SPXW260925P07670000	put	7670.0000	2026-09-25	2.5000	2.5000	2.5500	7710.6600	10500.00	0.00	10500.00	42	24	25812	1979	13.0429509853461	0.193828297175068	0.193828297175068	false	false	false	true
6e5bed07-620c-4abd-a235-1404e6caec70	2026-09-25 10:36	2026-09-25 10:36	2026-09-25 10:36	SPXW	SPXW260925P07670000	put	7670.0000	2026-09-25	2.8200	2.8000	2.9000	7709.5900	56495.00	0.00	56495.00	200	18	25624	1979	12.9479535118747	0.198261397232287	0.197114731022316	false	false	false	true
80462c7f-dee6-49b9-8e61-d75190496eb8	2026-09-25 10:35	2026-09-25 10:35	2026-09-25 10:35	SPXW	SPXW260925P07670000	put	7670.0000	2026-09-25	3.2000	3.2000	3.3000	7707.7800	10240.00	0.00	10240.00	32	7	25167	1979	12.7170288024255	0.199485539134656	0.199485539134656	false	false	false	true
1091b264-ac2c-4a33-a920-bd53763973a8	2026-09-25 10:16	2026-09-25 10:16	2026-09-25 10:16	SPXW	SPXW260925P07670000	put	7670.0000	2026-09-25	5.8000	5.7000	5.9000	7699.5400	25520.00	580.00	0.00	44	6	20492	1979	10.3547246083881	0.211888911703308	0.211888911703308	false	false	false	true
5f9005c2-1b45-48e6-9247-2548799d5414	2026-09-25 10:15	2026-09-25 10:15	2026-09-25 10:15	SPXW	SPXW260925P07670000	put	7670.0000	2026-09-25	5.1700	5.1000	5.2000	7701.7700	15500.00	10400.00	5100.00	30	6	20081	1979	10.1470439615968	0.210074964220842	0.210074964220842	false	false	false	true
20f1d057-83af-4c10-ad0e-b94ecb7ee746	2026-09-25 10:15	2026-09-25 10:15	2026-09-25 10:15	SPXW	SPXW260925P07670000	put	7670.0000	2026-09-25	7.6500	7.3000	7.7000	7693.0800	23700.00	17640.00	2260.00	31	9	19674	1979	9.94138453764528	0.213334432772812	0.213120103544695	false	false	false	true
5c20e5f6-5255-42f1-815f-ead56898ee8e	2026-09-25 10:15	2026-09-25 10:15	2026-09-25 10:15	SPXW	SPXW260925P07670000	put	7670.0000	2026-09-25	7.4300	7.2000	7.5000	7694.0700	11880.00	11150.00	0.00	16	5	19603	1979	9.9055078322385	0.214332229064325	0.212826983040813	false	false	false	true
04532462-72f0-4791-a2d4-35f29998425d	2026-09-25 10:09	2026-09-25 10:09	2026-09-25 10:09	SPXW	SPXW260925P07670000	put	7670.0000	2026-09-25	4.0000	4.0000	4.1000	7685.0000	18800.00	0.00	18800.00	47	13	17223	1979	8.70288024254674	0.203970035632459	0.203970035632459	false	false	false	true
8fc565fc-09a1-47f8-8112-c8f689a2e880	2026-09-25 10:08	2026-09-25 10:08	2026-09-25 10:08	SPXW	SPXW260925P07670000	put	7670.0000	2026-09-25	5.2000	5.2000	5.3000	7680.0000	10400.00	0.00	10400.00	20	5	16738	1979	8.4578069732188	0.210978183440606	0.211237087136138	false	false	false	true
98930afd-5aa9-45bc-98bd-e8a9e9f892fa	2026-09-25 10:07	2026-09-25 10:07	2026-09-25 10:07	SPXW	SPXW260925P07670000	put	7670.0000	2026-09-25	5.0000	5.0000	5.1000	7680.0000	25510.00	510.00	25000.00	51	8	16491	1979	8.33299646286003	0.206855873114896	0.205140328327523	false	false	false	true
385ffeb4-40ad-4ad6-a6ed-a6f762358b79	2026-09-25 10:06	2026-09-25 10:06	2026-09-25 10:06	SPXW	SPXW260925P07670000	put	7670.0000	2026-09-25	6.5800	6.5000	6.8000	7697.1700	10520.00	1330.00	9190.00	16	5	15660	1979	7.91308741788782	0.21212154965365	0.21212154965365	false	false	false	true
c5be3bd6-0493-48de-92ea-467e6ed71aba	2026-09-25 10:05	2026-09-25 10:05	2026-09-25 10:05	SPXW	SPXW260925P07670000	put	7670.0000	2026-09-25	6.0000	6.0000	6.1000	7699.0400	11400.00	0.00	11400.00	19	8	15245	1979	7.7033855482567	0.209891336334192	0.209891336334192	false	false	false	true
22ea38d0-e6c2-4d69-9d51-659b94d41c2e	2026-09-25 10:05	2026-09-25 10:05	2026-09-25 10:05	SPXW	SPXW260925P07670000	put	7670.0000	2026-09-25	6.2100	6.1000	6.3000	7698.4900	19240.00	1260.00	15500.00	31	6	15205	1979	7.68317331985851	0.212515912764392	0.210933540353407	false	false	false	true
9eb330e9-0f80-4a03-907e-6a29a721fd82	2026-09-25 10:05	2026-09-25 10:05	2026-09-25 10:05	SPXW	SPXW260925P07670000	put	7670.0000	2026-09-25	6.4800	6.3000	6.5000	7699.6400	12320.00	11050.00	1270.00	19	5	15093	1979	7.62657908034361	0.216985709180968	0.220160577403968	false	false	false	true
8ea7b41e-69f7-4863-b923-17384a3f623a	2026-09-25 10:05	2026-09-25 10:05	2026-09-25 10:05	SPXW	SPXW260925P07670000	put	7670.0000	2026-09-25	5.6900	5.6000	5.8000	7700.3100	10820.00	0.00	7400.00	19	5	14876	1979	7.51692774128348	0.209808184327232	0.209808184327232	false	false	false	true
61184639-6c7f-470c-bf68-306a9436c1a4	2026-09-25 10:02	2026-09-25 10:02	2026-09-25 10:02	SPXW	SPXW260925P07670000	put	7670.0000	2026-09-25	2.1000	2.0500	2.1500	7716.3000	10735.00	1290.00	9445.00	51	13	13213	1979	6.67660434562911	0.188602410683613	0.192538252772011	false	false	false	true
ae59a22d-bc9e-401e-8813-a9659f8bc576	2026-09-24 16:12	2026-09-24 16:12	2026-09-24 16:12	SPXW	SPXW260925P07670000	put	7670.0000	2026-09-25	10.5800	10.5000	10.7000	7680.0000	46560.00	0.00	45500.00	44	6	5634	1209	4.66004962779156	0.150557447217857	0.149820860971796	false	false	false	true
68187179-471d-4cf8-a751-8fcbc287105b	2026-09-24 15:36	2026-09-24 15:36	2026-09-24 15:36	SPXW	SPXW260925P07670000	put	7670.0000	2026-09-25	7.9000	7.9000	8.1000	7706.6700	31600.00	0.00	31600.00	40	6	5062	1209	4.18693134822167	0.135094195759517	0.135094195759517	false	false	false	true
f922e58f-2cc7-429c-8e84-45b34c7c77f0	2026-09-24 13:26	2026-09-24 13:26	2026-09-24 13:26	SPXW	SPXW260925P07670000	put	7670.0000	2026-09-25	13.0000	13.0000	13.2000	7696.9200	13000.00	0.00	13000.00	10	7	3317	1209	2.74358974358974	0.152146511008616	0.152146511008616	false	false	false	true
1258f01c-83be-4e91-a61d-d51d7e9efc06	2026-09-24 12:15	2026-09-24 12:15	2026-09-24 12:15	SPXW	SPXW260925P07670000	put	7670.0000	2026-09-25	20.1000	20.0000	21.2000	7671.4400	10050.00	0.00	10050.00	5	5	2187	1209	1.80893300248139	0.132484422604886	0.132484422604886	false	false	false	true
b355f1de-f05c-4565-8bee-09d16b6e3b15	2026-09-24 11:53	2026-09-24 11:53	2026-09-24 11:53	SPXW	SPXW260925P07670000	put	7670.0000	2026-09-25	21.2000	21.0000	21.2000	7672.4400	21200.00	21200.00	0.00	10	6	2001	1209	1.65508684863524	0.142352111316866	0.142352111316866	false	false	false	true
94bf1809-0d3f-49fd-bf6a-16b254ad01b4	2026-09-24 11:27	2026-09-24 11:27	2026-09-24 11:27	SPXW	SPXW260925P07670000	put	7670.0000	2026-09-25	24.7000	24.7000	24.9000	7667.0300	12350.00	0.00	12350.00	5	5	1729	1209	1.43010752688172	0.147505923327352	0.147505923327352	false	false	false	true
b35be90a-69e8-47ee-be48-1811625bf8f9	2026-09-24 11:16	2026-09-24 11:16	2026-09-24 11:16	SPXW	SPXW260925P07670000	put	7670.0000	2026-09-25	23.6000	23.5000	23.6000	7669.2200	25960.00	25960.00	0.00	11	5	1502	1209	1.24234904880066	0.147549151761185	0.147549151761185	false	false	false	true
a07afc87-c049-496f-b93e-a4a9d7645a85	2026-09-24 11:12	2026-09-24 11:11	2026-09-24 11:11	SPXW	SPXW260925P07670000	put	7670.0000	2026-09-25	23.2000	23.2000	23.4000	7650.0000	23200.00	0.00	23200.00	10	6	1313	1209	1.08602150537634	0.148692218718504	0.148692218718504	false	false	false	true
45c024ca-d031-42c8-9da5-cdd8d28bc4f8	2026-09-24 11:07	2026-09-24 11:07	2026-09-24 11:07	SPXW	SPXW260925P07670000	put	7670.0000	2026-09-25	23.0000	22.8000	23.0000	7671.1900	23000.00	23000.00	0.00	10	5	1161	1209	0.96029776674938	0.149848891364809	0.149848891364809	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
a31a3f6c-be05-4163-88d5-2cb557826b47	2026-09-11 10:38	2026-09-11 10:38	2026-09-11 10:38	SPXW	SPXW260925P07670000	put	7670.0000	2026-09-25	74.8000	74.6000	75.0000	7658.0900	142120.00	97240.00	0.00	19	5	245	236	1.03813559322034	0.124664519478094	0.124664519478094	false	false	false	true