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: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

4f3f6ed1-c472-4af3-820c-7bec7bca7471	2026-09-25 16:31	2026-09-25 16:30	2026-09-25 16:30	SPXW	SPXW260928P07700000	put	7700.0000	2026-09-28	7.3400	7.2000	7.6000	7720.0000	73370.00	2920.00	69700.00	100	14	8830	1749	5.0485991995426	0.084964588848478	0.0839958900567039	false	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	—	—	—	—	—	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500}	2026-09-25	2026-09-25 21:15	2026-09-25 21:15
3814dfc4-3566-4900-8332-3e626af104f8	2026-09-25 16:30	2026-09-25 16:29	2026-09-25 16:29	SPXW	SPXW260928P07675000	put	7675.0000	2026-09-28	3.8100	3.7000	4.1000	7720.0000	115210.00	65740.00	49470.00	302	18	3830	1138	3.36555360281195	0.0887536909153648	0.0880601529816693	false	false	false	true
59eebeeb-f1bc-4961-83e3-4d9eac2efa7d	2026-09-25 16:29	2026-09-25 16:28	2026-09-25 16:28	SPXW	SPXW260928P07675000	put	7675.0000	2026-09-28	4.0100	3.9000	4.3000	7720.0000	73840.00	28800.00	45040.00	184	14	3521	1138	3.09402460456942	0.0901200055460264	0.089440209657485	false	false	false	true
b0948fb0-5ed5-461b-89c5-6a69a953e10b	2026-09-25 16:11	2026-09-25 16:11	2026-09-25 16:11	SPXW	SPXW260928P07675000	put	7675.0000	2026-09-28	3.9200	3.8000	4.1000	7720.0000	97940.00	25360.00	71780.00	250	22	3278	1138	2.8804920913884	0.089440209657485	0.0887536909153648	false	false	false	true
a285af54-7958-4611-b4f3-f77addfd2432	2026-09-25 16:08	2026-09-25 16:07	2026-09-25 16:07	SPXW	SPXW260929P07660000	put	7660.0000	2026-09-29	6.6300	6.6000	6.8000	7720.0000	19890.00	0.00	13860.00	30	7	1587	4864	0.326274671052632	0.104901727012586	0.104373803819366	false	false	false	true
ca12922d-2713-4d50-8148-96ce70cd595b	2026-09-25 16:04	2026-09-25 16:04	2026-09-25 16:04	SPXW	SPXW260928C07800000	call	7800.0000	2026-09-28	3.8400	3.7000	4.1000	7720.0000	98240.00	760.00	97480.00	256	24	9852	2655	3.71073446327684	0.073070722096456	0.0724506762613646	false	false	false	true
0e1b640a-4997-4494-92d4-6079d9557477	2026-09-25 16:03	2026-09-25 16:02	2026-09-25 16:02	SPXW	SPXW260928C07805000	call	7805.0000	2026-09-28	3.1000	2.6500	3.4000	7720.0000	154930.00	21000.00	133930.00	500	34	4883	1867	2.61542581681843	0.072828500022139	0.0714357335183336	false	false	false	true
d9256845-941d-42e4-953a-d1304b2ddd18	2026-09-25 16:00	2026-09-25 16:00	2026-09-25 16:00	SPXW	SPXW260928C07820000	call	7820.0000	2026-09-28	1.7100	1.7000	1.8500	7720.0000	16955.00	0.00	16955.00	99	8	5307	2157	2.46036161335188	0.0732488914864004	0.0732488914864004	false	false	false	true
f10a0586-2b01-44f5-9d7c-0f8480b8f250	2026-09-25 15:59	2026-09-25 15:59	2026-09-25 15:59	SPXW	SPXW260930C07720000	call	7720.0000	2026-09-30	49.4200	48.2000	49.8000	7720.0000	79070.00	24700.00	54370.00	16	5	682	501	1.36127744510978	0.0966795825456839	0.0958099682868625	false	false	false	true
6b818a6f-409e-4922-bbca-1427551dc611	2026-09-25 15:59	2026-09-25 15:59	2026-09-25 15:59	SPXW	SPXW260925P07745000	put	7745.0000	2026-09-25	2.5700	2.4000	2.7500	7720.0000	11825.00	5685.00	5375.00	46	30	72847	491	148.364562118126	0.174205962860105	0	true	false	false	true
64670a1e-a56f-41ed-b63a-0afca2c9f852	2026-09-25 15:59	2026-09-25 15:59	2026-09-25 15:59	SPXW	SPXW260925P07745000	put	7745.0000	2026-09-25	2.4700	2.4500	2.6000	7720.0000	20750.00	0.00	20750.00	84	30	72736	491	148.13849287169	0	0	false	false	false	true
63ab18f8-76a9-4090-84f2-02c0697f41db	2026-09-25 15:59	2026-09-25 15:59	2026-09-25 15:59	SPXW	SPXW260925C07745000	call	7745.0000	2026-09-25	1.2900	1.2000	1.4500	7725.0000	10550.00	1670.00	8880.00	82	20	188581	4815	39.1653167185877	0.33513268474411	0.312567407613687	false	false	false	true
dd38455f-fb27-467f-9517-a1f525eb8055	2026-09-25 15:58	2026-09-25 15:58	2026-09-25 15:58	SPXW	SPXW260928C07805000	call	7805.0000	2026-09-28	3.1900	2.9500	3.5000	7725.0000	79850.00	0.00	79850.00	250	28	4288	1867	2.29673272629888	0.0715785717913757	0.0715785717913757	false	false	false	true
1df19f7a-a265-4059-bb81-59785c780ad3	2026-09-25 15:58	2026-09-25 15:58	2026-09-25 15:58	SPXW	SPXW260928C07805000	call	7805.0000	2026-09-28	3.2600	3.1000	3.6000	7745.6000	160590.00	54280.00	104270.00	492	33	4038	1867	2.16282806641671	0.0723495078025805	0.0723495078025805	false	false	false	true
d1fff0d0-4d20-4610-931d-2d020e09651f	2026-09-25 15:58	2026-09-25 15:58	2026-09-25 15:58	SPXW	SPXW260925C07740000	call	7740.0000	2026-09-25	6.2000	6.1000	6.7000	7745.4100	52100.00	13640.00	38460.00	84	20	202621	3681	55.0450964411845	0.468873842876499	0.4460081384839	true	false	false	true
ae929888-1752-4f1e-9866-030811d4fb45	2026-09-25 15:57	2026-09-25 15:57	2026-09-25 15:57	SPXW	SPXW260925C07745000	call	7745.0000	2026-09-25	1.9900	1.8500	2.0500	7744.7100	12160.00	190.00	11580.00	61	8	185382	4815	38.5009345794393	0.302037897924149	0.287909802430532	false	false	false	true
e282bf07-984a-4e1c-a686-657f6f40f524	2026-09-25 15:56	2026-09-25 15:56	2026-09-25 15:56	SPXW	SPXW260925P07760000	put	7760.0000	2026-09-25	14.3100	14.2000	14.9000	7744.2300	11450.00	0.00	11450.00	8	5	4867	470	10.3553191489362	0	0	false	false	false	true
83adae0e-907a-4016-b055-31e7671e8415	2026-09-25 15:56	2026-09-25 15:56	2026-09-25 15:56	SPXW	SPXW260925P07745000	put	7745.0000	2026-09-25	1.5100	1.4500	1.6000	7743.9500	25300.00	150.00	24400.00	168	46	66733	491	135.912423625255	0.123465734945193	0.10864979917428	false	false	false	true
7f2e31e4-f706-41e0-9833-ad67ab0a8c4a	2026-09-25 15:56	2026-09-25 15:56	2026-09-25 15:56	SPXW	SPXW260925P07750000	put	7750.0000	2026-09-25	4.6900	4.5000	5.1000	7743.9500	26710.00	0.00	25750.00	57	25	39628	4237	9.35284399339155	0	0	true	false	false	true
88adad9e-1827-4d38-8ec5-3cb4d2067977	2026-09-25 15:56	2026-09-25 15:56	2026-09-25 15:56	SPXW	SPXW260925P07750000	put	7750.0000	2026-09-25	5.8200	5.6000	6.0000	7743.6500	11060.00	7080.00	3980.00	19	9	39349	4237	9.28699551569507	0	0	false	false	false	true
2127ecbb-c950-4f40-9999-ed0b080545a8	2026-09-25 15:56	2026-09-25 15:56	2026-09-25 15:56	SPXW	SPXW260925P07750000	put	7750.0000	2026-09-25	4.9900	4.8000	5.3000	7744.0400	16460.00	10000.00	6460.00	33	15	39271	4237	9.26858626386594	0	0	false	false	false	true
9611fcc2-ca65-4561-a8de-0e69f6090942	2026-09-25 15:56	2026-09-25 15:56	2026-09-25 15:56	SPXW	SPXW260925P07745000	put	7745.0000	2026-09-25	1.8700	1.8000	1.9500	7744.1000	11380.00	1945.00	9250.00	61	16	64938	491	132.256619144603	0.181911097081771	0.175470855577135	false	false	false	true
f9a7e5b9-49ff-48e9-8f69-db57bad5aba2	2026-09-25 15:56	2026-09-25 15:56	2026-09-25 15:56	SPXW	SPXW260925P07745000	put	7745.0000	2026-09-25	1.9200	1.8500	2.0500	7743.6300	12455.00	3900.00	8365.00	65	32	64233	491	130.820773930754	0.138788689966764	0.132201458073791	false	false	false	true
eefdb1c4-4494-483a-9ecc-5221d9143857	2026-09-25 15:56	2026-09-25 15:56	2026-09-25 15:56	SPXW	SPXW260925C07745000	call	7745.0000	2026-09-25	1.4100	1.3500	1.5000	7744.3400	15190.00	300.00	12600.00	108	11	182739	4815	37.9520249221184	0.189952080517528	0.205236599565644	false	false	false	true
210f53bb-f2fb-475f-a88d-d30f30bea8d9	2026-09-25 15:55	2026-09-25 15:55	2026-09-25 15:55	SPXW	SPXW260925P07750000	put	7750.0000	2026-09-25	3.7400	3.5000	3.9000	7746.7700	16070.00	7220.00	8850.00	43	12	38371	4237	9.05617181968374	0.198472814154387	0.182943089980492	false	false	false	true
2785974a-e6ef-4251-8dd9-7dd1fd773e26	2026-09-25 15:55	2026-09-25 15:55	2026-09-25 15:55	SPXW	SPXW260925C07750000	call	7750.0000	2026-09-25	0.9900	0.9000	1.0500	7747.1600	17170.00	200.00	16970.00	173	58	229351	8398	27.3101929030722	0.232118315258233	0.218755871249261	false	false	false	true
fb857ef9-7c2f-4301-9e6f-c3d395da8a78	2026-09-25 15:55	2026-09-25 15:55	2026-09-25 15:55	SPXW	SPXW260925C07740000	call	7740.0000	2026-09-25	8.2400	8.2000	8.6000	7747.2600	24720.00	0.00	24720.00	30	9	200925	3681	54.5843520782396	0.380574495181106	0.366024721091228	false	false	false	true
d58c5cc9-ce27-4980-b468-bd17022b3e5f	2026-09-25 15:55	2026-09-25 15:55	2026-09-25 15:55	SPXW	SPXW260925C07750000	call	7750.0000	2026-09-25	1.4400	1.3000	1.5500	7748.0100	20385.00	1795.00	18590.00	142	26	228664	8398	27.2283877113598	0.249363283662302	0.232539390924228	false	false	false	true
05df88f8-f9a3-4bf2-9e53-e0716944d9a0	2026-09-25 15:55	2026-09-25 15:55	2026-09-25 15:55	SPXW	SPXW260929C07750000	call	7750.0000	2026-09-29	28.4300	28.3000	28.8000	7748.0000	284310.00	127800.00	156510.00	100	15	1095	981	1.11620795107034	0.0862055396451041	0.0855872686792872	false	false	false	true
c0e54468-390e-499b-9aae-aae19ee2b5c0	2026-09-25 15:54	2026-09-25 15:54	2026-09-25 15:54	SPXW	SPXW260925C07750000	call	7750.0000	2026-09-25	1.4600	1.4500	1.5500	7747.8100	15775.00	750.00	14875.00	108	23	226214	8398	26.9366515837104	0.245768433129375	0.240760707050028	false	false	false	true
295bbdd2-bfc4-4fc7-bcb2-8bd4c79441e9	2026-09-25 15:54	2026-09-25 15:54	2026-09-25 15:54	SPXW	SPXW260925C07740000	call	7740.0000	2026-09-25	8.8200	8.7000	9.2000	7748.4100	17630.00	3520.00	14110.00	20	7	200702	3681	54.5237707144798	0.298231903275827	0.278508971560399	false	false	false	true
215ba73a-f119-4c48-8ee8-c79c41e68e3b	2026-09-25 15:54	2026-09-25 15:54	2026-09-25 15:54	SPXW	SPXW260925C07750000	call	7750.0000	2026-09-25	2.1000	2.0500	2.2000	7749.4300	27100.00	215.00	26885.00	129	17	225529	8398	26.855084543939	0.235560549948096	0.231009098717588	false	false	false	true
27655f97-20f3-4b56-bc03-e16637edbe3e	2026-09-25 15:54	2026-09-25 15:54	2026-09-25 15:54	SPXW	SPXW260925C07750000	call	7750.0000	2026-09-25	2.1200	2.0000	2.2500	7749.2700	17780.00	860.00	15670.00	84	19	225261	8398	26.8231721838533	0.245330371005248	0.231943911196148	false	false	false	true
ed50eba6-0df6-4504-b2b8-3d1db033bd38	2026-09-25 15:54	2026-09-25 15:53	2026-09-25 15:53	SPXW	SPXW260925C07750000	call	7750.0000	2026-09-25	2.1900	2.1500	2.2500	7749.3200	10725.00	0.00	5225.00	49	5	224970	8398	26.7885210764468	0.240609086348445	0.235814397125918	true	false	false	true
496c51fb-7016-4f2c-b383-e886d15301f9	2026-09-25 15:53	2026-09-25 15:53	2026-09-25 15:53	SPXW	SPXW260925C07750000	call	7750.0000	2026-09-25	2.0800	2.0000	2.2500	7749.3100	13085.00	225.00	12420.00	63	24	224733	8398	26.7603000714456	0.241024264898736	0.219746821767875	false	false	false	true
4b568d37-6fde-47aa-af87-5e5dede0c5f5	2026-09-25 15:53	2026-09-25 15:52	2026-09-25 15:52	SPXW	SPXW260925P07745000	put	7745.0000	2026-09-25	1.1500	1.1000	1.2000	7748.6800	12640.00	6440.00	450.00	110	30	54172	491	110.329938900204	0.227591155708486	0.227858461933602	false	false	false	true
1658a52d-d795-44f1-9ad8-39610e7e0379	2026-09-25 15:52	2026-09-25 15:52	2026-09-25 15:52	SPXW	SPXW260925P07750000	put	7750.0000	2026-09-25	2.9700	2.9000	3.1000	7749.0900	11580.00	3610.00	7970.00	39	20	35098	4237	8.28369129100779	0.220852393735705	0.216426464336741	false	false	false	true
6d3bab5c-6f31-4731-8259-452fd96a745d	2026-09-25 15:52	2026-09-25 15:52	2026-09-25 15:52	SPXW	SPXW260925C07750000	call	7750.0000	2026-09-25	1.7800	1.7000	1.9000	7749.0700	71305.00	19950.00	37065.00	400	52	222776	8398	26.5272683972374	0.199755261155253	0.190885223782665	false	false	false	true
338e6aab-d9fe-4c4e-9a3f-30b054725b85	2026-09-25 15:52	2026-09-25 15:52	2026-09-25 15:52	SPXW	SPXW260925C07750000	call	7750.0000	2026-09-25	1.8600	1.8500	1.9500	7749.5300	11900.00	2280.00	9620.00	64	7	222285	8398	26.4688020957371	0.185446556987071	0.180668545001438	false	false	false	true
b684347b-1547-4ca5-8c14-75a6532ea269	2026-09-25 15:52	2026-09-25 15:52	2026-09-25 15:52	SPXW	SPXW260925C07750000	call	7750.0000	2026-09-25	2.0800	2.0000	2.3000	7749.9200	13755.00	3310.00	9200.00	66	26	221692	8398	26.3981900452489	0.193723722715826	0.176784782744936	false	false	false	true
9f22cead-4780-4fa2-b958-5984a893859e	2026-09-25 15:52	2026-09-25 15:52	2026-09-25 15:52	SPXW	SPXW260925C07750000	call	7750.0000	2026-09-25	2.2500	2.2000	2.3500	7749.9200	12605.00	2270.00	5160.00	56	22	221625	8398	26.3902119552274	0.198604440850129	0.19795841475124	false	false	false	true
2a146723-9020-41a5-b277-747e314013ce	2026-09-25 15:52	2026-09-25 15:51	2026-09-25 15:52	SPXW	SPXW260925P07750000	put	7750.0000	2026-09-25	2.4100	2.3000	2.5000	7749.9000	16615.00	8400.00	6755.00	69	19	33898	4237	8.00047203209818	0.198933304124629	0.190848552333906	false	false	false	true
140b273b-a486-4c80-b73d-24e9367a491a	2026-09-25 15:52	2026-09-25 15:51	2026-09-25 15:51	SPXW	SPXW261002P07605000	put	7605.0000	2026-10-02	10.6600	10.6000	10.8000	7749.9300	21320.00	0.00	9550.00	20	5	337	396	0.851010101010101	0.134429558973318	0.134429558973318	false	false	false	true
1e455bfd-79be-4f51-b1fe-79a8bb92beb8	2026-09-25 15:52	2026-09-25 15:51	2026-09-25 15:51	SPXW	SPXW260925P07750000	put	7750.0000	2026-09-25	2.3900	2.3000	2.4500	7749.9700	11240.00	480.00	10760.00	47	15	33737	4237	7.96247344819448	0.196695648465091	0.192576112036178	false	false	false	true
c6be888a-43d0-44aa-96a1-5ae6c10d127b	2026-09-25 15:51	2026-09-25 15:51	2026-09-25 15:51	SPXW	SPXW260925C07750000	call	7750.0000	2026-09-25	2.4500	2.4000	2.5500	7749.8400	12265.00	500.00	11030.00	50	16	220744	8398	26.2853060252441	0.212090850247728	0.207974336582499	false	false	false	true
1d64c899-30b5-40b4-9110-91e6cb1f12fb	2026-09-25 15:51	2026-09-25 15:51	2026-09-25 15:51	SPXW	SPXW260925P07745000	put	7745.0000	2026-09-25	0.8900	0.8000	1.0000	7749.5000	32070.00	16055.00	10320.00	362	101	52110	491	106.130346232179	0.212280182152564	0.202969554295684	false	false	false	true
d375d8ba-1b51-4a72-a6f6-a629c8788483	2026-09-25 15:51	2026-09-25 15:51	2026-09-25 15:51	SPXW	SPXW260925P07750000	put	7750.0000	2026-09-25	2.6800	2.6000	2.7500	7749.2400	10705.00	1925.00	8515.00	40	18	33465	4237	7.89827708284163	0.193669041696632	0.184068328443158	false	false	false	true
ad7f2aea-1ef4-4edd-8602-dec6826714a7	2026-09-25 15:51	2026-09-25 15:51	2026-09-25 15:51	SPXW	SPXW260925P07750000	put	7750.0000	2026-09-25	2.5200	2.4000	2.6500	7749.2400	18660.00	505.00	18155.00	74	37	33551	4237	7.91857446306349	0.180126525271627	0.171865197322205	false	false	false	true
e7fdf3e5-8fa1-4301-8c75-3f02c640ef5b	2026-09-25 15:51	2026-09-25 15:51	2026-09-25 15:51	SPXW	SPXW260928C07810000	call	7810.0000	2026-09-28	3.5100	3.4000	3.7000	7749.7700	157000.00	72450.00	80590.00	447	34	2814	599	4.69782971619366	0.0743477448925851	0.0736935557268934	false	false	false	true
6314db44-db5a-4ca5-9840-771b7fa2031a	2026-09-25 15:51	2026-09-25 15:51	2026-09-25 15:51	SPXW	SPXW260925C07740000	call	7740.0000	2026-09-25	10.9900	10.9000	11.5000	7751.5400	86840.00	0.00	86840.00	79	23	199586	3681	54.2205922303722	0	0	true	false	false	true