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

c3a5f33c-316a-4ec0-881d-34facec0ad3a	2026-09-25 16:43	2026-09-25 16:42	2026-09-25 16:42	SPXW	SPXW260928C07805000	call	7805.0000	2026-09-28	3.5000	3.3000	3.6000	7720.0000	35000.00	15750.00	19250.00	100	11	5148	1867	2.75736475629352	0.0749425646120211	0.0749425646120211	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-25	2026-09-25 21:15	2026-09-25 21:15
60509fc0-2249-4e4b-9269-e06f5f4f3cc2	2026-09-25 16:28	2026-09-25 16:24	2026-09-25 16:24	SPXW	SPXW261001P07585000	put	7585.0000	2026-10-01	6.6000	6.3000	6.6000	7720.0000	29700.00	29700.00	0.00	45	6	118	150	0.786666666666667	0.133012802723693	0.133012802723693	false	false	false	true
22f9fce7-394a-492a-bbd2-343a7c00520c	2026-09-25 16:24	2026-09-25 16:21	2026-09-25 16:21	SPXW	SPXW261002C07950000	call	7950.0000	2026-10-02	2.4500	2.4000	2.6500	7720.0000	49000.00	0.00	49000.00	200	5	1728	7630	0.226474442988204	0.111343753914342	0.111343753914342	false	false	false	true
3fa44478-3374-4e23-a7b6-f1ca2a84f01a	2026-09-25 16:14	2026-09-25 16:14	2026-09-25 16:14	SPXW	SPXW260928C07800000	call	7800.0000	2026-09-28	3.8000	3.7000	3.9000	7720.0000	15200.00	3800.00	9120.00	40	5	10062	2655	3.78983050847458	0.0724506762613646	0.0724506762613646	false	false	false	true
f518de6d-26fc-4ae6-a581-3ab39daada98	2026-09-25 16:14	2026-09-25 16:14	2026-09-25 16:14	SPXW	SPXW260928P07740000	put	7740.0000	2026-09-28	20.0000	19.9000	20.2000	7720.0000	370000.00	368000.00	2000.00	185	20	5630	292	19.2808219178082	0.0816442284583998	0.0816442284583998	false	false	false	true
15fb8a36-fc7f-403e-be94-99f3b08f3000	2026-09-25 16:14	2026-09-25 16:14	2026-09-25 16:14	SPXW	SPXW260928P07740000	put	7740.0000	2026-09-28	20.0000	19.9000	20.0000	7720.0000	10000.00	10000.00	0.00	5	5	5445	292	18.6472602739726	0.0816442284583998	0.0816442284583998	false	false	false	true
5bb3e075-f400-4d79-bfe7-3bfeff559762	2026-09-25 16:13	2026-09-25 16:13	2026-09-25 16:13	SPXW	SPXW261009P07310000	put	7310.0000	2026-10-09	4.8000	4.7000	5.0000	7720.0000	123360.00	35520.00	87840.00	257	10	1597	92	17.3586956521739	0.17774988787638	0.17774988787638	false	false	false	true
e1648d0d-297d-4ab1-a420-61424319440a	2026-09-25 16:13	2026-09-25 16:13	2026-09-25 16:13	SPXW	SPXW261009P07310000	put	7310.0000	2026-10-09	4.8000	4.8000	5.1000	7720.0000	24000.00	0.00	24000.00	50	5	1340	92	14.5652173913043	0.17774988787638	0.17774988787638	false	false	false	true
c9300b98-db6e-47ca-9ded-26afe761719e	2026-09-25 16:11	2026-09-25 16:11	2026-09-25 16:11	SPXW	SPXW261002P07750000	put	7750.0000	2026-10-02	49.3000	49.2000	49.3000	7720.0000	98600.00	98600.00	0.00	20	5	570	1898	0.30031612223393	0.114495762601127	0.114495762601127	false	false	false	true
0068c0ea-497f-457c-a6e9-f86c05a7299d	2026-09-25 16:11	2026-09-25 16:11	2026-09-25 16:11	SPXW	SPXW261001P07470000	put	7470.0000	2026-10-01	2.1000	2.0000	2.1500	7720.0000	19110.00	10710.00	8400.00	91	7	241	317	0.760252365930599	0.157205240728738	0.157205240728738	false	false	false	true
98a0d143-bad2-48ee-86eb-b0bff50ee609	2026-09-25 16:11	2026-09-25 16:11	2026-09-25 16:11	SPXW	SPXW260928P07630000	put	7630.0000	2026-09-28	1.3500	1.2500	1.4000	7720.0000	13500.00	13500.00	0.00	100	11	2548	713	3.57363253856942	0.0994066883591062	0.0994066883591062	false	false	false	true
9553e1a6-aea9-4520-9a80-db1abad8bdf6	2026-09-25 16:10	2026-09-25 16:10	2026-09-25 16:10	SPXW	SPXW260930P07735000	put	7735.0000	2026-09-30	31.6000	31.5000	31.6000	7720.0000	135880.00	135880.00	0.00	43	5	505	2036	0.24803536345776	0.104052346692635	0.104052346692635	false	false	false	true
83b430ce-40bc-4cc4-a333-7c835f92b872	2026-09-25 16:10	2026-09-25 16:10	2026-09-25 16:10	SPXW	SPXW261002P07400000	put	7400.0000	2026-10-02	2.0000	1.9500	2.1000	7720.0000	50000.00	18800.00	31200.00	250	14	1302	2460	0.529268292682927	0.174872980554737	0.174872980554737	false	false	false	true
99898a2a-b85a-45e6-86af-8a59b71f77de	2026-09-25 16:09	2026-09-25 16:09	2026-09-25 16:09	SPXW	SPXW260928P07655000	put	7655.0000	2026-09-28	2.4000	2.3500	2.4500	7720.0000	27120.00	3360.00	18000.00	113	7	2253	423	5.32624113475177	0.0932449906003953	0.0932449906003953	false	false	false	true
9a880c53-7399-4618-860c-14ae61ca7692	2026-09-25 16:09	2026-09-25 16:08	2026-09-25 16:08	SPXW	SPXW260928C07755000	call	7755.0000	2026-09-28	16.8000	16.8000	17.0000	7720.0000	10080.00	0.00	10080.00	6	5	2589	564	4.59042553191489	0.0749708990002889	0.0749708990002889	false	false	false	true
2a1d77f0-2181-42fd-9f00-d06071e235e0	2026-09-25 16:07	2026-09-25 16:07	2026-09-25 16:07	SPXW	SPXW260928P07750000	put	7750.0000	2026-09-28	23.9000	23.7000	23.9000	7720.0000	14340.00	14340.00	0.00	6	6	2942	623	4.7223113964687	0.0778999430868986	0.0778999430868986	false	false	false	true
daa93339-06f6-4e7e-a3cb-6565eb82ab84	2026-09-25 16:06	2026-09-25 16:06	2026-09-25 16:06	SPXW	SPXW260928C07760000	call	7760.0000	2026-09-28	14.4000	14.3000	14.5000	7720.0000	24480.00	4320.00	15840.00	17	5	4522	2350	1.92425531914894	0.0737116982473403	0.0737116982473403	false	false	false	true
246f55a2-6226-49dd-9be1-b38be6170bac	2026-09-25 16:06	2026-09-25 16:06	2026-09-25 16:06	SPXW	SPXW260928P07750000	put	7750.0000	2026-09-28	23.8000	23.7000	24.0000	7720.0000	26180.00	9520.00	14280.00	11	5	2925	623	4.69502407704655	0.0775419944867491	0.0775419944867491	false	false	false	true
9a9ac8bf-e1b6-4ccc-bb83-91b57f4c3569	2026-09-25 16:06	2026-09-25 16:06	2026-09-25 16:06	SPXW	SPXW260930P07550000	put	7550.0000	2026-09-30	2.8000	2.7000	2.8000	7720.0000	11200.00	11200.00	0.00	40	7	868	6429	0.135013221340799	0.137300564221971	0.137300564221971	false	false	false	true
0cd1d5bd-6ec4-4e8e-8824-8a17089fdd7c	2026-09-25 16:04	2026-09-25 16:04	2026-09-25 16:04	SPXW	SPXW260928C07840000	call	7840.0000	2026-09-28	1.1000	1.0000	1.1000	7720.0000	11000.00	11000.00	0.00	100	7	2604	994	2.61971830985915	0.0796004639609727	0.0796004639609727	false	false	false	true
565496a0-8644-43e0-b987-ca35ff7b5162	2026-09-25 16:03	2026-09-25 16:03	2026-09-25 16:03	SPXW	SPXW261002P07560000	put	7560.0000	2026-10-02	7.3000	7.2000	7.4000	7720.0000	55480.00	0.00	0.00	76	6	1667	868	1.9205069124424	0.141057484475185	0.141057484475185	false	false	false	true
a70a78de-34eb-4eef-bed5-bc867e9121a3	2026-09-25 16:01	2026-09-25 16:01	2026-09-25 16:01	SPXW	SPXW261002C07900000	call	7900.0000	2026-10-02	5.4000	5.2000	5.4000	7720.0000	13500.00	13500.00	0.00	25	7	2805	8578	0.326999300536256	0.107572667160623	0.107572667160623	false	false	false	true
1d84615c-6e6b-4777-bf6d-e39abb824884	2026-09-25 16:01	2026-09-25 16:01	2026-09-25 16:01	SPXW	SPXW261023C07890000	call	7890.0000	2026-10-23	43.0000	43.4000	43.7000	7720.0000	1161000.00	0.00	1161000.00	270	4	567	92	6.16304347826087	0.106012746277039	0.106012746277039	false	true	false	true
7916b268-8867-4332-bbd1-1286cbbb7b9f	2026-09-25 16:00	2026-09-25 16:00	2026-09-25 16:00	SPXW	SPXW260928P07745000	put	7745.0000	2026-09-28	21.7000	21.6000	21.9000	7720.0000	141050.00	0.00	141050.00	65	6	2266	119	19.0420168067227	0.0793514964464877	0.0793514964464877	false	false	false	true
51586f7c-4f6b-4991-9648-e944fbfdf45d	2026-09-25 16:00	2026-09-25 16:00	2026-09-25 16:00	SPXW	SPXW260928P07680000	put	7680.0000	2026-09-28	4.6000	4.4000	4.7000	7720.0000	42780.00	23920.00	18860.00	93	10	2871	432	6.64583333333333	0.0889660944307106	0.0889660944307106	false	false	false	true
a81586ba-b378-4056-9e64-0870f9e4a4c0	2026-09-25 16:00	2026-09-25 15:59	2026-09-25 15:59	SPXW	SPXW260928C07820000	call	7820.0000	2026-09-28	1.6500	1.6500	1.7500	7720.0000	14355.00	0.00	14355.00	87	5	5188	2157	2.40519239684747	0.0732274876665914	0.0732274876665914	false	false	false	true
f596f123-df9f-4614-b272-4ceea1eed38b	2026-09-25 16:00	2026-09-25 15:59	2026-09-25 15:59	SPXW	SPXW261002C07800000	call	7800.0000	2026-10-02	24.4000	24.3000	24.7000	7720.0000	263520.00	90280.00	173240.00	108	11	2299	5674	0.405181529784984	0.106419537310074	0.106419537310074	false	false	false	true
648517f9-0777-4b1a-a090-1ad76da158df	2026-09-25 15:59	2026-09-25 15:59	2026-09-25 15:59	SPXW	SPXW260928C07785000	call	7785.0000	2026-09-28	6.4000	6.2000	6.4000	7720.0000	14080.00	14080.00	0.00	22	5	2286	435	5.2551724137931	0.0724948535922482	0.0724948535922482	true	false	false	true
a9f5d3d7-0e77-428f-a058-3c0316fd0123	2026-09-25 15:59	2026-09-25 15:59	2026-09-25 15:59	SPXW	SPXW260928C07755000	call	7755.0000	2026-09-28	16.3000	16.2000	16.5000	7720.0000	24450.00	1630.00	22820.00	15	5	2352	564	4.17021276595745	0.0733470496100232	0.0733470496100232	false	false	false	true
5bfd7fb7-39d1-4aba-89da-91440eaeb538	2026-09-25 15:59	2026-09-25 15:59	2026-09-25 15:59	SPXW	SPXW260925C07740000	call	7740.0000	2026-09-25	4.0000	3.3000	4.0000	7720.0000	10000.00	10000.00	0.00	25	10	203903	3681	55.3933713664765	1.05933094857602	1.05933094857602	false	false	false	true
49500743-9f45-4683-bbc2-6891a06af6c6	2026-09-25 15:59	2026-09-25 15:59	2026-09-25 15:59	SPXW	SPXW260925P07745000	put	7745.0000	2026-09-25	1.5000	1.5000	2.0000	7720.0000	16800.00	0.00	16800.00	112	5	74159	491	151.0366598778	0.089894489977958	0.089894489977958	false	false	false	true
b364a93d-4cde-4c68-bdd6-123599c1c023	2026-09-25 15:59	2026-09-25 15:59	2026-09-25 15:59	SPXW	SPXW260928C07770000	call	7770.0000	2026-09-28	10.4000	10.2000	10.4000	7720.0000	23920.00	23920.00	0.00	23	5	4195	1397	3.00286327845383	0.0734234509156713	0.0734234509156713	true	false	false	true
65a64183-bcf3-4441-be93-33ef46dec60a	2026-09-25 15:59	2026-09-25 15:59	2026-09-25 15:59	SPXW	SPXW261002P07600000	put	7600.0000	2026-10-02	10.8000	10.8000	11.0000	7720.0000	63720.00	0.00	63720.00	59	8	2502	3196	0.782853566958698	0.133229362731411	0.133229362731411	false	false	false	true
25f55630-e16f-45ee-a7d8-ad9b7713e37f	2026-09-25 15:59	2026-09-25 15:59	2026-09-25 15:59	SPXW	SPXW260925P07745000	put	7745.0000	2026-09-25	2.5000	2.1000	2.5000	7720.0000	16500.00	16500.00	0.00	66	11	73687	491	150.075356415479	0	0	false	false	false	true
2f1bc99b-2a0d-49e6-9f55-3807ec9ae3d5	2026-09-25 15:59	2026-09-25 15:59	2026-09-25 15:59	SPXW	SPXW260928P07650000	put	7650.0000	2026-09-28	2.2500	2.1500	2.2500	7720.0000	11250.00	11250.00	0.00	50	5	5883	996	5.9066265060241	0.0947615704757764	0.0947615704757764	false	false	false	true
d9d30d1f-aceb-4d71-a5ce-1ce12277b514	2026-09-25 15:59	2026-09-25 15:59	2026-09-25 15:59	SPXW	SPXW260928C07765000	call	7765.0000	2026-09-28	12.3000	12.1000	12.3000	7720.0000	25830.00	25830.00	0.00	21	5	2170	256	8.4765625	0.0729458480209104	0.0729458480209104	true	false	false	true
933446ab-15a4-4824-ad85-a279f46d16a4	2026-09-25 15:59	2026-09-25 15:59	2026-09-25 15:59	SPXW	SPXW260925P07755000	put	7755.0000	2026-09-25	11.0000	10.6000	11.1000	7720.0000	11000.00	11000.00	0.00	10	5	10265	370	27.7432432432432	0.497955031668264	0.497955031668264	false	false	false	true
e4dc505c-ee4e-4840-9035-550d233647de	2026-09-25 15:59	2026-09-25 15:59	2026-09-25 15:59	SPXW	SPXW261001C07880000	call	7880.0000	2026-10-01	4.5000	4.4000	4.5000	7725.0000	18000.00	18000.00	0.00	40	6	437	1876	0.232942430703625	0.0995961180528242	0.0995961180528242	false	false	false	true
73487d78-7692-42f0-b4f9-447e284a6e2e	2026-09-25 15:58	2026-09-25 15:58	2026-09-25 15:58	SPXW	SPXW260925P07745000	put	7745.0000	2026-09-25	1.1600	1.1000	1.2500	7720.0000	10535.00	4800.00	4125.00	91	21	70348	491	143.274949083503	0.0754130385016277	0.0962066794642437	false	false	false	true
beaf5be0-a521-4e78-8dc4-f619c10ec561	2026-09-25 15:58	2026-09-25 15:58	2026-09-25 15:58	SPXW	SPXW260925P07750000	put	7750.0000	2026-09-25	5.0000	4.7000	5.1000	7725.0000	11010.00	11010.00	0.00	22	11	40339	4237	9.52065140429549	0.0937730685355438	0.0937730685355438	false	false	false	true
8dfb6893-ae1f-4b58-995f-8309de1cf56d	2026-09-25 15:58	2026-09-25 15:58	2026-09-25 15:58	SPXW	SPXW260928P07730000	put	7730.0000	2026-09-28	15.3000	15.2000	15.3000	7725.0000	10710.00	10710.00	0.00	7	7	3376	636	5.30817610062893	0.0817934438326803	0.0817934438326803	false	false	false	true
c37ad114-e8ed-447f-8914-3083f7d27d59	2026-09-25 15:58	2026-09-25 15:58	2026-09-25 15:58	SPXW	SPXW261102C08100000	call	8100.0000	2026-11-02	16.6000	16.5000	19.5000	7725.0000	244020.00	46480.00	197540.00	147	6	895	7	127.857142857143	0.107788048128503	0.107788048128503	false	false	false	true
eb04f608-2434-420b-a87f-753347c9a08b	2026-09-25 15:58	2026-09-25 15:58	2026-09-25 15:58	SPXW	SPXW260930C07915000	call	7915.0000	2026-09-30	1.3000	1.2000	1.3500	7725.0000	19890.00	14820.00	5070.00	153	9	863	1037	0.832208293153327	0.100272859918344	0.100272859918344	false	false	false	true
b6b5e3bd-4c39-41ec-a8be-e7615f17491a	2026-09-25 15:58	2026-09-25 15:58	2026-09-25 15:58	SPXW	SPXW260930C07915000	call	7915.0000	2026-09-30	1.3000	1.2000	1.3000	7725.0000	14430.00	14430.00	0.00	111	6	674	1037	0.649951783992285	0.100127111667217	0.100127111667217	false	false	false	true
98078edf-4f97-43a2-89a9-2fb408d9032d	2026-09-25 15:58	2026-09-25 15:58	2026-09-25 15:58	SPXW	SPXW260928P07725000	put	7725.0000	2026-09-28	13.4000	13.4000	13.5000	7725.0000	67000.00	0.00	67000.00	50	5	3476	1201	2.89425478767694	0.0824348164895527	0.0824348164895527	false	false	false	true
4d222f10-31da-4160-9cc8-43f296571d87	2026-09-25 15:58	2026-09-25 15:58	2026-09-25 15:58	SPXW	SPXW260928P07725000	put	7725.0000	2026-09-28	13.4000	13.2000	13.5000	7725.0000	119260.00	25460.00	93800.00	89	10	3421	1201	2.84845961698585	0.0827144816444876	0.0827144816444876	false	false	false	true
f95207aa-2963-4f00-ab1a-e1d11fa01e52	2026-09-25 15:58	2026-09-25 15:58	2026-09-25 15:58	SPXW	SPXW260930C07915000	call	7915.0000	2026-09-30	1.3000	1.2000	1.3000	7745.6000	11700.00	11700.00	0.00	90	6	457	1037	0.44069431051109	0.0999612272235762	0.0999612272235762	false	false	false	true
67bdecb5-461c-4f88-b803-339697498287	2026-09-25 15:58	2026-09-25 15:58	2026-09-25 15:58	SPXW	SPXW260928P07685000	put	7685.0000	2026-09-28	4.8000	4.7000	4.9000	7745.6000	48480.00	28800.00	19680.00	101	11	2412	415	5.81204819277108	0.0875126689993039	0.0875126689993039	false	false	false	true
607ee375-9a58-4373-a611-2673e7718243	2026-09-25 15:58	2026-09-25 15:58	2026-09-25 15:58	SPXW	SPXW260928C07725000	call	7725.0000	2026-09-28	34.8000	34.8000	34.9000	7745.6000	73080.00	0.00	73080.00	21	5	4278	472	9.0635593220339	0.075975652657681	0.075975652657681	false	false	false	true
51c82687-ecf5-47e3-bed7-bafb5a8e638c	2026-09-25 15:58	2026-09-25 15:58	2026-09-25 15:58	SPXW	SPXW260928C07725000	call	7725.0000	2026-09-28	34.8000	34.5000	34.9000	7745.6000	163560.00	24360.00	139200.00	47	7	4257	472	9.01906779661017	0.075975652657681	0.075975652657681	false	false	false	true