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.

566,287 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts566,287 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:endpoint = /api/option-trades/flow-alerts×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

6c5c5212-853f-4cee-bd06-c9b629b66420	2026-09-29 15:59	2026-09-29 15:59	2026-09-29 15:59	SPXW	SPXW260929P07670000	put	7670.0000	2026-09-29	1.7900	1.5000	1.9500	7645.0000	14515.00	9360.00	4815.00	81	40	133152	1317	101.102505694761	0.343938656856526	0.302744858270541	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-29	2026-09-29 21:15	2026-09-29 21:15
0971031d-2923-477e-a289-a716282e9c66	2026-09-29 15:59	2026-09-29 15:59	2026-09-29 15:59	SPXW	SPXW260929P07670000	put	7670.0000	2026-09-29	1.8900	1.6000	2.0500	7650.0000	10380.00	5625.00	4385.00	55	40	133067	1317	101.037965072134	0.36641541393206	0.36909360382486	true	false	false
d4abc6fa-3e26-4655-9c7a-5a29bb6a34af	2026-09-29 15:59	2026-09-29 15:59	2026-09-29 15:59	SPXW	SPXW260929P07670000	put	7670.0000	2026-09-29	1.6200	1.4000	1.9500	7650.0000	10535.00	9465.00	750.00	65	43	132793	1317	100.829916476841	0.477387015878678	0.586195288959047	false	false	false
90ee9274-3a7d-42ad-8271-13caa1c0cc78	2026-09-29 15:59	2026-09-29 15:59	2026-09-29 15:59	SPXW	SPXW260929P07670000	put	7670.0000	2026-09-29	1.9800	1.7500	2.0500	7650.0000	12265.00	12070.00	195.00	62	29	132891	1317	100.904328018223	0.572283084030992	0.548076798601465	false	false	false
07445767-cc0a-4b06-b6fc-46d480d097f6	2026-09-29 15:59	2026-09-29 15:59	2026-09-29 15:59	SPXW	SPXW260929P07670000	put	7670.0000	2026-09-29	1.2900	1.1500	1.4000	7650.0000	10705.00	10470.00	115.00	83	29	132721	1317	100.775246772969	0.391898276283506	0.453061941588682	false	false	false
3ada29ae-f088-44ac-9b0e-1e4a89e42778	2026-09-29 15:59	2026-09-29 15:58	2026-09-29 15:58	SPXW	SPXW260929C07670000	call	7670.0000	2026-09-29	1.7700	1.6500	1.8500	7650.0000	17865.00	10415.00	4650.00	101	43	122992	266	462.375939849624	0	0.197253774437184	true	false	false	true
16365647-d00c-4e32-ab5f-f818474e3621	2026-09-29 15:58	2026-09-29 15:58	2026-09-29 15:58	SPXW	SPXW260929P07670000	put	7670.0000	2026-09-29	0.8000	0.7500	0.8500	7650.0000	12735.00	2895.00	9760.00	159	70	131457	1317	99.8154897494305	0.274621267829827	0.285711133252012	false	false	false
ebadf8da-4c0c-4b56-850c-db41a6ae1b7b	2026-09-29 15:58	2026-09-29 15:58	2026-09-29 15:58	SPXW	SPXW260929P07670000	put	7670.0000	2026-09-29	1.0000	0.9000	1.0500	7650.0000	11860.00	5100.00	6475.00	119	23	131021	1317	99.4844343204252	0.322343564359328	0.322343564359328	true	false	false
900cd64e-2b0d-457e-aaaf-10d737fb6bfb	2026-09-29 15:58	2026-09-29 15:58	2026-09-29 15:58	SPXW	SPXW260929P07670000	put	7670.0000	2026-09-29	1.0000	0.9000	1.0500	7650.0000	10195.00	3500.00	5295.00	102	12	130808	1317	99.3227031131359	0.31706811400027	0.327642015069316	false	false	false
904a7a35-d8ff-40a0-a2da-ecee9ab1de05	2026-09-29 15:58	2026-09-29 15:58	2026-09-29 15:58	SPXW	SPXW260930C07685000	call	7685.0000	2026-09-30	15.9000	15.7000	15.9000	7650.0000	31800.00	31800.00	0.00	20	5	4390	777	5.64993564993565	0.134654444999123	0.134654444999123	false	false	false
f7daa0fd-f5a1-4e47-b530-1d22f0614088	2026-09-29 15:58	2026-09-29 15:58	2026-09-29 15:58	SPXW	SPXW260929C07670000	call	7670.0000	2026-09-29	2.5900	2.5500	2.7000	7650.0000	18155.00	2700.00	15455.00	70	14	122224	266	459.488721804511	0.280667787538441	0.247443104595777	false	false	false
c933780b-52c5-49b3-a58f-f7952f9fc06f	2026-09-29 15:58	2026-09-29 15:58	2026-09-29 15:58	SPXW	SPXW260930C07720000	call	7720.0000	2026-09-30	5.3000	5.1000	5.4000	7650.0000	86390.00	53000.00	33390.00	163	12	5440	1124	4.83985765124555	0.130671484221556	0.130671484221556	false	false	false
1003f2cc-a08c-4313-bb7f-b1ce4149db26	2026-09-29 15:58	2026-09-29 15:58	2026-09-29 15:58	SPXW	SPXW260929P07670000	put	7670.0000	2026-09-29	0.9200	0.8500	1.0000	7650.0000	10005.00	3825.00	2930.00	109	20	130244	1317	98.8944570994685	0.30389233630441	0.293784163996639	true	false	false
7bfd57e4-666a-43d7-a601-989cc8ed98fd	2026-09-29 15:58	2026-09-29 15:58	2026-09-29 15:58	SPXW	SPXW260929C07670000	call	7670.0000	2026-09-29	2.6000	2.4000	2.7000	7650.0000	10155.00	2565.00	5475.00	39	15	121990	266	458.609022556391	0.238713014138713	0.251986209639978	false	false	false
78d97516-43da-4dc3-b660-aecf9dc4f27d	2026-09-29 15:58	2026-09-29 15:58	2026-09-29 15:58	SPXW	SPXW260929C07670000	call	7670.0000	2026-09-29	2.6000	2.5500	2.6000	7650.0000	13000.00	13000.00	0.00	50	9	121844	266	458.06015037594	0.21773302507167	0.21773302507167	false	false	false
6affaaa5-b541-47b9-b48f-4d544f186228	2026-09-29 15:58	2026-09-29 15:58	2026-09-29 15:58	SPXW	SPXW260929P07670000	put	7670.0000	2026-09-29	0.8200	0.7000	0.9000	7650.0000	16485.00	5050.00	10985.00	200	41	129344	1317	98.211085801063	0.275609046204451	0.262904696035431	false	false	false
b8d6d5e7-ca80-454e-9df3-e8f03a07c40f	2026-09-29 15:58	2026-09-29 15:58	2026-09-29 15:58	SPXW	SPXW260929C07665000	call	7665.0000	2026-09-29	7.0100	7.0000	7.6000	7650.0000	14730.00	0.00	14000.00	21	6	82638	290	284.958620689655	0.226949100926508	0.399754455852387	false	false	false
028b0fba-a785-48d0-8095-e03d7cde1fc3	2026-09-29 15:58	2026-09-29 15:58	2026-09-29 15:58	SPXW	SPXW260929P07675000	put	7675.0000	2026-09-29	3.5000	3.1000	3.5000	7650.0000	11540.00	11540.00	0.00	33	7	89381	1977	45.2104198280223	0.307375365532204	0.287071688459146	false	false	false
c69bbc47-77c6-4e04-ac25-7d0653d5fcf7	2026-09-29 15:58	2026-09-29 15:57	2026-09-29 15:57	SPXW	SPXW260929C07670000	call	7670.0000	2026-09-29	2.9700	2.9500	3.1000	7650.0000	17235.00	7500.00	9735.00	58	22	121648	266	457.323308270677	0.304875215803204	0.304875215803204	false	false	false
33288101-8632-490f-bc74-5f3f75b800a4	2026-09-29 15:58	2026-09-29 15:57	2026-09-29 15:57	SPXW	SPXW260929C07670000	call	7670.0000	2026-09-29	2.9000	2.8500	3.0000	7650.0000	12755.00	12180.00	575.00	44	8	121585	266	457.086466165414	0.286070299413631	0.295160860058925	false	false	false
fbbd45a9-af9f-428f-a97a-7f7e97bd499c	2026-09-29 15:57	2026-09-29 15:57	2026-09-29 15:57	SPXW	SPXW260929P07670000	put	7670.0000	2026-09-29	1.3500	1.3000	1.4000	7650.0000	15120.00	4725.00	1620.00	112	12	127727	1317	96.9832953682612	0.247705055479437	0.247705055479437	false	false	false
5417e50e-2963-487b-8767-aa14a7bbfa1a	2026-09-29 15:57	2026-09-29 15:57	2026-09-29 15:57	SPXW	SPXW260929P07670000	put	7670.0000	2026-09-29	1.3500	1.3000	1.4000	7650.0000	14400.00	9045.00	2520.00	107	14	127615	1317	96.8982536066818	0.247705055479437	0.247705055479437	false	false	false
9674575e-a8b0-4ab2-86bc-8a1cb53a5f6b	2026-09-29 15:57	2026-09-29 15:57	2026-09-29 15:57	SPXW	SPXW260929P07670000	put	7670.0000	2026-09-29	1.3000	1.2250	1.3500	7650.0000	13000.00	6890.00	2080.00	100	19	127335	1317	96.6856492027335	0.246520596822179	0.247329556786897	false	false	false
14f8ddbc-1008-45ef-93b2-ea31a335223e	2026-09-29 15:57	2026-09-29 15:57	2026-09-29 15:57	SPXW	SPXW260929C07670000	call	7670.0000	2026-09-29	1.9000	1.8500	1.9500	7650.0000	21855.00	19385.00	2470.00	115	11	120573	266	453.281954887218	0.229066226685075	0.236482041243494	false	false	false
a909a1c9-14ab-42c4-adc8-fe0b36c4d6e5	2026-09-29 15:57	2026-09-29 15:57	2026-09-29 15:57	SPXW	SPXW260929C07670000	call	7670.0000	2026-09-29	1.8500	1.8000	2.0000	7670.7900	26115.00	12400.00	13715.00	141	26	120284	266	452.195488721805	0.216798094363943	0.197843910754498	false	false	false
a2192df6-37e9-4a99-a7ed-f277bbe5211e	2026-09-29 15:57	2026-09-29 15:57	2026-09-29 15:57	SPXW	SPXW260929P07670000	put	7670.0000	2026-09-29	1.1800	1.1000	1.2500	7670.0200	12350.00	10800.00	1550.00	105	23	126481	1317	96.037205770691	0.157628972505148	0.15918438228031	false	false	false
4afd09e2-5724-41d0-91e1-614d5c1ac168	2026-09-29 15:57	2026-09-29 15:57	2026-09-29 15:57	SPXW	SPXW260929C07670000	call	7670.0000	2026-09-29	2.0000	1.9500	2.0000	7669.8100	14600.00	14600.00	0.00	73	11	119978	266	451.045112781955	0.299018046944064	0.299018046944064	false	false	false
addada2e-0340-40ec-accc-843faf4e7e8f	2026-09-29 15:57	2026-09-29 15:57	2026-09-29 15:57	SPXW	SPXW260929C07665000	call	7665.0000	2026-09-29	3.9200	3.8000	4.3000	7668.5900	12930.00	400.00	12530.00	33	8	82311	290	283.831034482759	0.221886095711467	0.221886095711467	false	false	false
066b0474-2548-4053-9265-116e6777c4f0	2026-09-29 15:57	2026-09-29 15:57	2026-09-29 15:57	SPXW	SPXW260929P07675000	put	7675.0000	2026-09-29	6.7000	6.2000	6.8000	7668.5900	14070.00	14070.00	0.00	21	5	89052	1977	45.0440060698027	0.292403773619557	0.292403773619557	false	false	false
2ee996de-1303-485c-be8d-6190f7dc723d	2026-09-29 15:57	2026-09-29 15:57	2026-09-29 15:57	SPXW	SPXW260929C07670000	call	7670.0000	2026-09-29	1.1000	1.0500	1.2000	7669.0500	22000.00	18150.00	3850.00	200	20	119064	266	447.609022556391	0.209548245146053	0.209548245146053	false	false	false
498746ff-b892-4b7a-b5e9-cc0613145d08	2026-09-29 15:57	2026-09-29 15:56	2026-09-29 15:56	SPXW	SPXW260929C07670000	call	7670.0000	2026-09-29	1.1500	1.1000	1.2000	7668.7600	12085.00	240.00	11730.00	105	8	118775	266	446.522556390977	0.238722536970885	0.23161531834999	false	false	false
c4175dda-051f-4cec-b61e-c6d83dd6c664	2026-09-29 15:56	2026-09-29 15:56	2026-09-29 15:56	SPXW	SPXW260929P07665000	put	7665.0000	2026-09-29	0.4700	0.4000	0.5500	7668.6900	10890.00	9490.00	50.00	234	32	111907	952	117.549369747899	0.22487955103936	0.23442972530868	true	false	false	true
075a199a-c1d6-4f7d-ad29-c26707aa76fd	2026-09-29 15:56	2026-09-29 15:56	2026-09-29 15:56	SPXW	SPXW260929P07670000	put	7670.0000	2026-09-29	2.4500	2.3500	2.4500	7668.7300	15900.00	15180.00	480.00	65	12	125576	1317	95.3500379650721	0.223964986766874	0.223964986766874	false	false	false
fabe1a90-55c2-4928-817e-84c5d9f5124e	2026-09-29 15:56	2026-09-29 15:56	2026-09-29 15:56	SPXW	SPXW261001C07750000	call	7750.0000	2026-10-01	5.5700	5.4000	5.6000	7668.3000	55650.00	55650.00	0.00	100	13	3500	2013	1.73869846000994	0.131466893595787	0.131466893595787	false	false	false
95817778-7b71-41b9-a76c-2457b26e0122	2026-09-29 15:56	2026-09-29 15:56	2026-09-29 15:56	SPXW	SPXW260929P07670000	put	7670.0000	2026-09-29	2.5000	2.4000	2.6500	7668.3000	26715.00	2265.00	16950.00	107	29	125446	1317	95.2513287775247	0.211691064264016	0.182564423277211	false	false	false
9006675f-d512-40fa-89ff-6d743b7f0649	2026-09-29 15:56	2026-09-29 15:56	2026-09-29 15:56	SPXW	SPXW260929C07670000	call	7670.0000	2026-09-29	0.9900	0.9000	1.0000	7668.1700	17750.00	15780.00	1115.00	179	31	117920	266	443.308270676692	0.219886738872246	0.23146911268236	false	false	false
1e99a24c-3df1-435f-bf54-ddcafd133501	2026-09-29 15:56	2026-09-29 15:56	2026-09-29 15:56	SPXW	SPXW260929C07670000	call	7670.0000	2026-09-29	1.0000	0.9500	1.0500	7668.3000	26000.00	25900.00	0.00	260	19	118206	266	444.383458646617	0.225698520064781	0.225698520064781	false	false	false
0c19fe2a-dc5f-4eb0-a3a3-ab503386798f	2026-09-29 15:56	2026-09-29 15:56	2026-09-29 15:56	SPXW	SPXW260929P07670000	put	7670.0000	2026-09-29	2.5600	2.5000	2.6000	7668.1700	13055.00	9230.00	0.00	51	11	125279	1317	95.1245254365983	0.19858984971194	0.191044422695995	false	false	false
84ac839b-8088-4b63-8919-f775b3a6ecb5	2026-09-29 15:56	2026-09-29 15:56	2026-09-29 15:56	SPXW	SPXW260929P07670000	put	7670.0000	2026-09-29	2.6400	2.5500	2.7500	7668.2500	10830.00	6650.00	2855.00	41	13	125228	1317	95.085801063022	0.213017739221202	0.220162578333991	true	false	false
54663de9-d147-4f2e-bd6b-25d77d723f98	2026-09-29 15:56	2026-09-29 15:56	2026-09-29 15:56	SPXW	SPXW260930C07670000	call	7670.0000	2026-09-30	21.0000	20.9000	21.2000	7667.7000	12600.00	0.00	12600.00	6	5	4239	316	13.4145569620253	0.13562743179963	0.13562743179963	false	false	false
cbe50208-d43c-43c1-bc4c-0df4055ec939	2026-09-29 15:56	2026-09-29 15:56	2026-09-29 15:56	SPXW	SPXW260929C07665000	call	7665.0000	2026-09-29	3.4200	3.3000	3.7000	7667.0700	10260.00	1080.00	8480.00	30	13	82044	290	282.910344827586	0.299497742822785	0.285687862534284	false	false	false
a0945542-f2ac-4a36-85d6-75a215538138	2026-09-29 15:56	2026-09-29 15:56	2026-09-29 15:56	SPXW	SPXW260929P07670000	put	7670.0000	2026-09-29	3.0800	2.9000	3.4000	7667.4700	19375.00	5500.00	12960.00	63	38	125022	1317	94.9293849658314	0.176217660456678	0.170625308577036	false	false	false
20626483-cbf1-4ea1-8da8-b67e58a445e7	2026-09-29 15:56	2026-09-29 15:56	2026-09-29 15:56	SPXW	SPXW260929P07675000	put	7675.0000	2026-09-29	7.3000	7.2000	7.6000	7667.0700	16050.00	730.00	15320.00	22	9	88901	1977	44.9676277187658	0	0	false	false	false	true
d7025ba8-7c52-43aa-acbc-7b5c923e2489	2026-09-29 15:56	2026-09-29 15:56	2026-09-29 15:56	SPXW	SPXW260929P07670000	put	7670.0000	2026-09-29	3.4800	3.2000	3.9000	7667.3100	34070.00	15110.00	17930.00	98	49	124908	1317	94.8428246013667	0.29513546552442	0.207663178853602	true	false	false
7f090eb6-7b41-4c2c-a471-e50de4d1819d	2026-09-29 15:56	2026-09-29 15:56	2026-09-29 15:56	SPXW	SPXW260930P07670000	put	7670.0000	2026-09-30	22.0000	21.8000	22.1000	7667.2900	22000.00	17600.00	0.00	10	6	4428	617	7.17666126418152	0.13150008089732	0.13150008089732	false	false	false	true
6b347b17-e34f-4d08-9a53-4762d36a6e26	2026-09-29 15:56	2026-09-29 15:56	2026-09-29 15:56	SPXW	SPXW260929P07670000	put	7670.0000	2026-09-29	3.7000	3.4000	3.9000	7667.2900	32580.00	16660.00	15920.00	88	37	124808	1317	94.7668944570995	0.220649710514009	0.266076367534576	false	false	false
4803287c-d352-42c0-9ba8-a819c633ffa9	2026-09-29 15:56	2026-09-29 15:56	2026-09-29 15:56	SPXW	SPXW260929P07675000	put	7675.0000	2026-09-29	8.2300	8.0000	8.4000	7667.2900	13990.00	4980.00	1630.00	17	12	88850	1977	44.9418310571573	0.361767397525868	0.384284988969984	false	false	false
c65c5653-ccfa-430e-818e-083bf8c2b3cc	2026-09-29 15:56	2026-09-29 15:56	2026-09-29 15:56	SPXW	SPXW260929P07675000	put	7675.0000	2026-09-29	7.8800	7.5000	8.0000	7667.9800	42540.00	24630.00	12450.00	54	45	88739	1977	44.8856853818918	0.39557780676043	0.432441397721934	true	false	false
c0d3c282-98f9-4339-98a5-9f17e477424b	2026-09-29 15:56	2026-09-29 15:56	2026-09-29 15:56	SPXW	SPXW260929P07675000	put	7675.0000	2026-09-29	7.2900	7.0000	7.4000	7667.9800	16040.00	12480.00	2840.00	22	19	88645	1977	44.838138593829	0.294887054030004	0.28441798052336	true	false	false
7c89c3c9-1426-4d29-b5bb-7a0b2bb1b8bf	2026-09-29 15:56	2026-09-29 15:56	2026-09-29 15:56	SPXW	SPXW260929P07670000	put	7670.0000	2026-09-29	3.0700	2.9500	3.4000	7667.9800	18120.00	14920.00	3200.00	59	43	124479	1317	94.5170842824601	0.231043086594485	0.286154464493455	false	false	false