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.

658,639 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts658,639 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

76c01713-bd9e-442d-8634-389929ffe263	2026-10-01 15:38	2026-10-01 15:37	2026-10-01 15:37	SPXW	SPXW261001C07670000	call	7670.0000	2026-10-01	5.2000	5.1000	5.3000	7672.7600	22360.00	520.00	21320.00	43	14	122408	929	131.763186221744	0.183774629628908	0.183774629628908	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-10-01T19:42:36.719976Z"}	2026-10-01	2026-10-01 21:15	2026-10-01 21:15
c820e65c-28b4-48c6-ad93-4cdc6006977c	2026-10-01 15:37	2026-10-01 15:37	2026-10-01 15:37	SPXW	SPXW261001P07675000	put	7675.0000	2026-10-01	5.8000	5.7000	5.9000	7672.1200	17980.00	0.00	16820.00	31	8	50037	2224	22.4986510791367	0.210771298301736	0.210771298301736	false	false	false	true
78b3b8c1-266f-4ced-91fa-22bd9c77e8e1	2026-10-01 15:37	2026-10-01 15:36	2026-10-01 15:36	SPXW	SPXW261001P07680000	put	7680.0000	2026-10-01	10.0000	9.9000	10.1000	7671.7900	10000.00	9000.00	0.00	10	8	25340	1065	23.7934272300469	0.238250204774336	0.238250204774336	false	false	false	true
0e475070-7bc6-443a-9595-a2eb3750f811	2026-10-01 15:37	2026-10-01 15:36	2026-10-01 15:36	SPXW	SPXW261001P07670000	put	7670.0000	2026-10-01	3.6000	3.5000	3.6000	7671.6300	18000.00	18000.00	0.00	50	20	72537	1738	41.7359033371692	0.215614182406771	0.215614182406771	false	false	false	true
ba345d40-4c62-42e0-9c55-f0db429b3323	2026-10-01 15:36	2026-10-01 15:36	2026-10-01 15:36	SPXW	SPXW261001C07665000	call	7665.0000	2026-10-01	8.1000	8.1000	8.2000	7671.6800	20250.00	0.00	20250.00	25	6	89206	556	160.442446043165	0.189386750347909	0.189386750347909	false	false	false	true
99f1a8e1-2467-4822-819f-9440c1c82575	2026-10-01 15:36	2026-10-01 15:36	2026-10-01 15:36	SPXW	SPXW261001P07670000	put	7670.0000	2026-10-01	3.7000	3.6000	3.7000	7671.9000	12950.00	12950.00	0.00	35	12	72268	1738	41.5811277330265	0.224564347875629	0.224564347875629	false	false	false	true
23cb97bd-641f-476a-980f-6b2a7d86ce55	2026-10-01 15:36	2026-10-01 15:36	2026-10-01 15:36	SPXW	SPXW261001P07685000	put	7685.0000	2026-10-01	13.8000	13.8000	14.1000	7672.1800	35880.00	0.00	35880.00	26	5	9747	1922	5.07127991675338	0.243119375930213	0.243119375930213	false	false	false	true
3074875b-c7f9-4054-aab7-d6acb25d13c9	2026-10-01 15:36	2026-10-01 15:36	2026-10-01 15:36	SPXW	SPXW261001C07675000	call	7675.0000	2026-10-01	2.3500	2.3250	2.4500	7671.7600	11045.00	0.00	11045.00	47	8	125481	1662	75.5	0.181558788008461	0.181558788008461	false	false	false	true
f7babb26-a545-4f55-9aa5-4afa72ece85a	2026-10-01 15:36	2026-10-01 15:36	2026-10-01 15:36	SPXW	SPXW261001P07670000	put	7670.0000	2026-10-01	3.5000	3.4000	3.6000	7672.2200	16090.00	15050.00	340.00	46	19	71759	1738	41.2882623705408	0.219493589045241	0.214550922108185	false	false	false	true
38563024-cc6f-4998-b29c-cf1304abf30a	2026-10-01 15:36	2026-10-01 15:36	2026-10-01 15:36	SPXW	SPXW261001C07670000	call	7670.0000	2026-10-01	4.9000	4.7000	4.9000	7672.1800	19110.00	19110.00	0.00	39	10	121693	929	130.993541442411	0.179290127068859	0.179290127068859	false	false	false	true
fdb4c2e0-eb63-4e08-aa0e-ddc9420b1406	2026-10-01 15:36	2026-10-01 15:36	2026-10-01 15:36	SPXW	SPXW261001P07675000	put	7675.0000	2026-10-01	6.0000	5.9000	6.0000	7672.3500	17400.00	17400.00	0.00	29	6	49606	2224	22.3048561151079	0.220879866827933	0.220879866827933	false	false	false	true
8aec47fc-98cb-4280-972c-a781fa00e0a5	2026-10-01 15:36	2026-10-01 15:35	2026-10-01 15:35	SPXW	SPXW261001P07680000	put	7680.0000	2026-10-01	9.2000	9.0000	9.3000	7672.5000	27600.00	22080.00	5520.00	30	8	25189	1065	23.6516431924883	0.217063179527476	0.217063179527476	false	false	false	true
deb9fc5f-e825-47f1-b727-a9a814edc2e2	2026-10-01 15:35	2026-10-01 15:35	2026-10-01 15:35	SPXW	SPXW261001C07655000	call	7655.0000	2026-10-01	17.8000	17.7000	18.1000	7672.5500	10680.00	0.00	10680.00	6	5	70899	375	189.064	0.207387801056414	0.207387801056414	false	false	false	true
ffd0c7c1-2c6f-42fe-ab5f-bf7ee7120dd9	2026-10-01 15:35	2026-10-01 15:35	2026-10-01 15:35	SPXW	SPXW261001P07670000	put	7670.0000	2026-10-01	3.1000	3.0000	3.1000	7672.1500	20150.00	20150.00	0.00	65	16	71314	1738	41.0322209436133	0.196552202852254	0.196552202852254	false	false	false	true
688dace9-0ab0-4cf7-a743-1437fba3f8f1	2026-10-01 15:35	2026-10-01 15:35	2026-10-01 15:35	SPXW	SPXW261001P07680000	put	7680.0000	2026-10-01	9.1000	9.0000	9.1000	7672.1500	15470.00	15470.00	0.00	17	5	25153	1065	23.6178403755869	0.19328809812785	0.19328809812785	false	false	false	true
2a360bf3-3b23-49ef-bb58-63a203496951	2026-10-01 15:35	2026-10-01 15:35	2026-10-01 15:35	SPXW	SPXW261001C07670000	call	7670.0000	2026-10-01	5.7000	5.6000	5.8000	7673.1000	57000.00	0.00	10260.00	100	5	121514	929	130.800861141012	0.189376614917365	0.189376614917365	false	false	false	true
0bb78908-b3b8-4dce-8458-5b065ea5bed8	2026-10-01 15:35	2026-10-01 15:35	2026-10-01 15:35	SPXW	SPXW261001P07670000	put	7670.0000	2026-10-01	2.9500	2.8500	2.9500	7673.3400	29500.00	29500.00	0.00	100	10	70832	1738	40.7548906789413	0.210765685043051	0.210765685043051	false	false	false	true
d435ec3e-3101-4efd-9f8e-d24de331c4be	2026-10-01 15:35	2026-10-01 15:35	2026-10-01 15:35	SPXW	SPXW261001C07680000	call	7680.0000	2026-10-01	1.3500	1.3500	1.4000	7673.1100	11340.00	0.00	11340.00	84	10	137610	862	159.640371229698	0.182827862022658	0.182827862022658	false	false	false	true
92d4406c-bff7-4e72-bcd1-70b875aa6f6c	2026-10-01 15:35	2026-10-01 15:35	2026-10-01 15:35	SPXW	SPXW261001P07690000	put	7690.0000	2026-10-01	17.8000	17.7000	17.8000	7673.4900	24920.00	24920.00	0.00	14	6	5068	1552	3.26546391752577	0.306487773296033	0.306487773296033	false	false	false	true
877158e1-7939-47ad-8340-8b744ab15b6c	2026-10-01 15:35	2026-10-01 15:35	2026-10-01 15:35	SPXW	SPXW261001P07670000	put	7670.0000	2026-10-01	3.0000	2.9500	3.1000	7673.4900	25495.00	24600.00	895.00	85	24	70654	1738	40.6524741081703	0.215451795972119	0.215451795972119	false	false	false	true
0d6f79e8-c5af-44cf-ae85-6dd48af0c50e	2026-10-01 15:35	2026-10-01 15:35	2026-10-01 15:35	SPXW	SPXW261001C07675000	call	7675.0000	2026-10-01	3.1000	3.0000	3.2000	7673.5100	11160.00	0.00	10540.00	36	8	124677	1662	75.0162454873646	0.17959285927521	0.17959285927521	false	false	false	true
ca00d63d-6912-4ace-9ddd-002d746d6998	2026-10-01 15:34	2026-10-01 15:34	2026-10-01 15:34	SPXW	SPXW261005C07725000	call	7725.0000	2026-10-05	13.7000	13.6000	13.7000	7673.1600	36990.00	36990.00	0.00	27	8	1071	319	3.35736677115987	0.100495772920132	0.100495772920132	false	false	false	true
2f116ed3-cfe3-4dc4-a4f9-344aedc64721	2026-10-01 15:34	2026-10-01 15:34	2026-10-01 15:34	SPXW	SPXW261002P07680000	put	7680.0000	2026-10-02	28.3100	28.1000	28.5000	7673.1600	50950.00	48110.00	0.00	18	6	1402	1146	1.22338568935428	0.157149473928949	0.157776153417046	false	false	false	true
107a32d0-650e-4e0e-be8a-32f64ff411a4	2026-10-01 15:34	2026-10-01 15:34	2026-10-01 15:34	SPXW	SPXW261001P07690000	put	7690.0000	2026-10-01	18.0000	17.8000	18.2000	7672.9900	23400.00	18000.00	5400.00	13	8	5043	1552	3.24935567010309	0.285092060777972	0.285092060777972	false	false	false	true
fa5759ba-beb8-4606-ba44-8aee00917479	2026-10-01 15:34	2026-10-01 15:34	2026-10-01 15:34	SPXW	SPXW261001P07675000	put	7675.0000	2026-10-01	5.4000	5.4000	5.6000	7672.8900	22680.00	0.00	22680.00	42	15	49045	2224	22.0526079136691	0.200811691539864	0.200811691539864	false	false	false	true
faf72336-e5e0-4249-8605-3170b9dd8a1f	2026-10-01 15:34	2026-10-01 15:34	2026-10-01 15:34	SPXW	SPXW261001P07675000	put	7675.0000	2026-10-01	5.3000	5.2000	5.3000	7672.8900	46110.00	46110.00	0.00	87	6	48995	2224	22.0301258992806	0.195952610085127	0.195952610085127	false	false	false	true
c0c6e80a-2c1a-4446-bdf0-c77e046d0dcf	2026-10-01 15:34	2026-10-01 15:34	2026-10-01 15:34	SPXW	SPXW261001P07675000	put	7675.0000	2026-10-01	5.0000	4.9000	5.0000	7674.4100	13000.00	13000.00	0.00	26	8	48856	2224	21.9676258992806	0.221069725009899	0.221069725009899	false	false	false	true
345a1ec4-9fd8-418d-a810-2e72767db0cc	2026-10-01 15:34	2026-10-01 15:34	2026-10-01 15:34	SPXW	SPXW261001P07675000	put	7675.0000	2026-10-01	4.0000	4.0000	4.1000	7675.5400	12800.00	0.00	12800.00	32	10	48226	2224	21.6843525179856	0.199512094523905	0.199512094523905	false	false	false	true
91354fe3-7699-4b22-b474-4cd3339de5da	2026-10-01 15:34	2026-10-01 15:34	2026-10-01 15:34	SPXW	SPXW261001C07675000	call	7675.0000	2026-10-01	4.0000	4.0000	4.1000	7675.2700	12000.00	0.00	12000.00	30	6	124153	1662	74.7009626955475	0.179909434738496	0.179909434738496	false	false	false	true
f3125850-a13d-48f3-8dff-4fb57207a4ea	2026-10-01 15:34	2026-10-01 15:34	2026-10-01 15:34	SPXW	SPXW261001P07680000	put	7680.0000	2026-10-01	7.3000	7.1000	7.3000	7675.2000	14600.00	14600.00	0.00	20	7	24946	1065	23.4234741784038	0.209602340046447	0.209602340046447	false	false	false	true
843522a2-50be-45d9-973b-ec296a25cc25	2026-10-01 15:34	2026-10-01 15:34	2026-10-01 15:34	SPXW	SPXW261001C07675000	call	7675.0000	2026-10-01	3.6000	3.5000	3.6000	7674.1600	16200.00	16200.00	0.00	45	14	123914	1662	74.5571600481348	0.185699557639027	0.185699557639027	false	false	false	true
d7edb5d2-86ee-4506-add4-dc88f96e2039	2026-10-01 15:33	2026-10-01 15:33	2026-10-01 15:33	SPXW	SPXW261001C07670000	call	7670.0000	2026-10-01	7.0000	6.9000	7.1000	7675.1100	10500.00	7700.00	0.00	15	5	120908	929	130.148546824543	0.181225707169013	0.181225707169013	false	false	false	true
2e910393-4da1-4848-86e3-403fe76340d2	2026-10-01 15:33	2026-10-01 15:33	2026-10-01 15:33	SPXW	SPXW261001C07675000	call	7675.0000	2026-10-01	3.6000	3.5000	3.6000	7674.2400	21600.00	21600.00	0.00	60	18	123705	1662	74.4314079422383	0.182548123911573	0.182548123911573	false	false	false	true
d8db8bc3-ca81-4f88-a0a7-de521e3dbff3	2026-10-01 15:33	2026-10-01 15:33	2026-10-01 15:33	SPXW	SPXW261001P07675000	put	7675.0000	2026-10-01	4.5000	4.4000	4.6000	7674.1600	12150.00	0.00	11700.00	27	9	47911	2224	21.5427158273381	0.187302713705659	0.187302713705659	false	false	false	true
36c161c7-f28e-44c8-a03c-c1b5591fe2c0	2026-10-01 15:33	2026-10-01 15:33	2026-10-01 15:33	SPXW	SPXW261001P07675000	put	7675.0000	2026-10-01	4.5000	4.5000	4.6000	7674.1600	29700.00	0.00	29700.00	66	18	47883	2224	21.5301258992806	0.187302713705659	0.187302713705659	false	false	false	true
6f9a1b88-b137-47a4-bf0a-4420caef2846	2026-10-01 15:33	2026-10-01 15:33	2026-10-01 15:33	SPXW	SPXW261001C07675000	call	7675.0000	2026-10-01	3.5000	3.5000	3.6000	7674.2200	12600.00	0.00	12600.00	36	5	123583	1662	74.3580024067389	0.177853650388009	0.177853650388009	false	false	false	true
b7d8baf8-cdc7-46d8-b0be-41a70ed93391	2026-10-01 15:33	2026-10-01 15:33	2026-10-01 15:33	SPXW	SPXW261001P07675000	put	7675.0000	2026-10-01	4.7000	4.7000	4.8000	7674.1200	16450.00	0.00	16450.00	35	8	47776	2224	21.4820143884892	0.195301101433509	0.195301101433509	false	false	false	true
f425fdf9-55e1-4b5b-9fb9-2cbcfbb2f61d	2026-10-01 15:33	2026-10-01 15:33	2026-10-01 15:33	SPXW	SPXW261001P07675000	put	7675.0000	2026-10-01	4.5000	4.4000	4.5500	7674.3000	37800.00	37800.00	0.00	84	20	47707	2224	21.4509892086331	0.19024032900486	0.19024032900486	false	false	false	true
92c7fbc1-73cf-4cbf-9bfd-8ec1b09d0589	2026-10-01 15:33	2026-10-01 15:33	2026-10-01 15:33	SPXW	SPXW261001P07685000	put	7685.0000	2026-10-01	11.8000	11.7000	11.9000	7674.1500	66080.00	64900.00	0.00	56	9	9537	1922	4.96201873048907	0.202457588689769	0.202457588689769	false	false	false	true
9b922660-5c5b-49b5-9e1e-e8b0c6cd70e4	2026-10-01 15:32	2026-10-01 15:32	2026-10-01 15:32	SPXW	SPXW261001C07675000	call	7675.0000	2026-10-01	3.9000	3.8000	3.9000	7674.5500	11700.00	11700.00	0.00	30	6	123288	1662	74.1805054151625	0.186523037200521	0.186523037200521	false	false	false	true
12b4060d-92d3-4c02-82b2-37767c9d9b2b	2026-10-01 15:32	2026-10-01 15:32	2026-10-01 15:32	SPXW	SPXW261001C07670000	call	7670.0000	2026-10-01	6.7000	6.6000	6.8000	7674.3100	16080.00	13400.00	0.00	24	15	120729	929	129.955866523143	0.189658575269579	0.189658575269579	false	false	false	true
efa24a6e-fa3e-4dad-abfb-9e2eefd939d2	2026-10-01 15:32	2026-10-01 15:32	2026-10-01 15:32	SPXW	SPXW261001P07675000	put	7675.0000	2026-10-01	4.8000	4.7000	4.8000	7674.4400	17280.00	17280.00	0.00	36	12	47232	2224	21.2374100719424	0.20453128466497	0.20453128466497	false	false	false	true
811960e9-2048-47f5-8ce2-b9a5fd583341	2026-10-01 15:32	2026-10-01 15:32	2026-10-01 15:32	SPXW	SPXW261001P07680000	put	7680.0000	2026-10-01	7.7000	7.5000	7.7000	7674.3200	15400.00	15400.00	0.00	20	7	24726	1065	23.2169014084507	0.193576302994929	0.193576302994929	false	false	false	true
d75c378e-d921-4a4a-9d32-1dd7e1ad3b4c	2026-10-01 15:32	2026-10-01 15:32	2026-10-01 15:32	SPXW	SPXW261001P07675000	put	7675.0000	2026-10-01	4.5000	4.5000	4.6000	7674.4900	17100.00	0.00	17100.00	38	8	47098	2224	21.1771582733813	0.191544372976531	0.191544372976531	false	false	false	true
5da30e0b-c28b-4542-99f6-fdbba95ef13e	2026-10-01 15:32	2026-10-01 15:32	2026-10-01 15:32	SPXW	SPXW261001P07675000	put	7675.0000	2026-10-01	4.6000	4.5000	4.6000	7674.6200	14720.00	14720.00	0.00	32	11	47053	2224	21.1569244604317	0.199020153798768	0.199020153798768	false	false	false	true
2927fa95-1a5d-4840-9be0-05c8ec642b55	2026-10-01 15:32	2026-10-01 15:32	2026-10-01 15:32	SPXW	SPXW261001P07670000	put	7670.0000	2026-10-01	2.5000	2.4500	2.5000	7674.4900	11000.00	11000.00	0.00	44	15	68101	1738	39.1835443037975	0.200097880713961	0.19793080206427	false	false	false	true
b3dca973-57da-49ae-8fc1-69fabf08cbc9	2026-10-01 15:32	2026-10-01 15:32	2026-10-01 15:32	SPXW	SPXW261001P07675000	put	7675.0000	2026-10-01	4.3000	4.2000	4.4000	7674.9400	39130.00	0.00	38700.00	91	20	46792	2224	21.0395683453237	0.192119918574424	0.192119918574424	false	false	false	true
427067ec-e947-436a-948f-8d7822e31bd1	2026-10-01 15:32	2026-10-01 15:31	2026-10-01 15:31	SPXW	SPXW261001P07675000	put	7675.0000	2026-10-01	4.0000	3.9000	4.0000	7675.9900	31600.00	31600.00	0.00	79	17	46559	2224	20.9348021582734	0.200331271686853	0.200331271686853	false	false	false	true
d6f4aea6-8235-40f8-9a7b-53fbcbcf0d94	2026-10-01 15:31	2026-10-01 15:31	2026-10-01 15:31	SPXW	SPXW261001P07675000	put	7675.0000	2026-10-01	3.7000	3.6000	3.7000	7676.3400	11100.00	11100.00	0.00	30	17	46322	2224	20.8282374100719	0.192962192922917	0.192962192922917	false	false	false	true
f5f2690e-cdfe-4418-a411-e03069345ba8	2026-10-01 15:31	2026-10-01 15:31	2026-10-01 15:31	SPXW	SPXW261001C07675000	call	7675.0000	2026-10-01	4.9000	4.8000	5.0000	7676.1500	10780.00	10290.00	0.00	22	6	122290	1662	73.5800240673887	0.190208807961686	0.190208807961686	false	false	false	true