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:alert_rule = RepeatedHits×ticker = VXX×

iduuid	created_at ↓timestamp with time zone	start_timetimestamp with time zone	end_timetimestamp with time zone	tickertext	option_symboltext	option_typetext	strikenumeric	expirydate

82b16be7-617b-497b-835f-f1601c4bbc3e	2026-10-02 15:36	2026-10-02 15:36	2026-10-02 15:36	VXX	VXX261002P00017500	put	17.5000	2026-10-02	0.1000	0.0700	0.1400	17.3900	12510.00	290.00	9180.00	1251	90	12948	16715	0.774633562668262	1.54247192910903	0.337714514920001	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Structured Product	—	0.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-10-02T19:39:36.083365Z"}	2026-10-02	2026-10-02 21:15	2026-10-02 21:15
aea7d551-b422-4efd-a567-777a6364c57a	2026-10-02 15:31	2026-10-02 15:30	2026-10-02 15:30	VXX	VXX261002P00017500	put	17.5000	2026-10-02	0.1000	0.0900	0.1000	17.0000	12840.00	12840.00	0.00	1284	9	9813	16715	0.587077475321567	0	0	false	false	false	true	false
4d8bac78-4724-4d4f-95e3-c37858fd7360	2026-10-02 15:30	2026-10-02 15:30	2026-10-02 15:30	VXX	VXX261002P00017500	put	17.5000	2026-10-02	0.1000	0.0900	0.1300	17.3900	20170.00	2790.00	17380.00	2017	62	8528	16715	0.510200418785522	1.14811756131366	0.700697940851321	false	false	false	true
27b725b2-dd62-442e-aa5d-78cf0ce7a38c	2026-10-02 15:25	2026-10-02 15:25	2026-10-02 15:25	VXX	VXX261002P00017500	put	17.5000	2026-10-02	0.1000	0.0900	0.1000	17.3900	44770.00	44770.00	0.00	4477	47	5655	16715	0.338318875261741	0	0	false	false	false	true	false
ac92637f-9be8-4757-b931-c21bef72d430	2026-10-02 14:15	2026-10-02 14:15	2026-10-02 14:15	VXX	VXX261009C00018500	call	18.5000	2026-10-09	0.1100	0.1000	0.1400	17.0000	12078.00	11308.00	770.00	1098	20	8787	467	18.8158458244111	0.446947163688292	0.446947163688292	true	false	false	true
a503ff8e-5224-4596-8c9f-9069d360d761	2026-10-02 14:15	2026-10-02 14:15	2026-10-02 14:15	VXX	VXX261009C00018500	call	18.5000	2026-10-09	0.1100	0.1000	0.1400	17.0000	22000.00	12309.00	9691.00	2000	44	7689	467	16.4646680942184	0.445499717666302	0.445499717666302	true	false	false	true
f62067e2-c572-4914-b8ba-57cfae1ffe49	2026-10-02 13:19	2026-10-02 13:19	2026-10-02 13:19	VXX	VXX261009C00019000	call	19.0000	2026-10-09	0.0800	0.0800	0.1400	17.5650	12256.00	0.00	12256.00	1532	5	6777	842	8.04869358669834	0.494601794027243	0.494601794027243	false	false	false	true
cc777faf-e5a1-4315-a810-57330a8e97c0	2026-10-02 11:46	2026-10-02 11:46	2026-10-02 11:46	VXX	VXX261009C00018500	call	18.5000	2026-10-09	0.1200	0.1200	0.1500	17.0000	10356.00	0.00	10356.00	863	50	1149	467	2.46038543897216	0.454595005242341	0.454595005242341	true	false	false	true
c6a91764-7002-4a05-8aeb-eb2df4b4ba46	2026-10-02 10:15	2026-10-02 10:15	2026-10-02 10:15	VXX	VXX261009C00017500	call	17.5000	2026-10-09	0.3600	0.3600	0.4100	17.5600	28080.00	0.00	28080.00	780	57	10096	5566	1.81386992454186	0.332481384393789	0.332481384393789	true	false	false	true
00c98ffe-a619-4104-a973-739821a1f5a0	2026-10-02 10:14	2026-10-02 10:14	2026-10-02 10:14	VXX	VXX261009P00017500	put	17.5000	2026-10-09	0.2800	0.2800	0.3200	17.5701	22960.00	0.00	22960.00	820	8	9982	5515	1.80997280145059	0.330597835073981	0.330597835073981	false	false	false	true
a31421d8-495b-4c4c-a8d7-b8582dc65bdf	2026-10-02 10:12	2026-10-02 10:12	2026-10-02 10:12	VXX	VXX261009C00017500	call	17.5000	2026-10-09	0.3600	0.3600	0.4500	17.5650	24482.00	0.00	24482.00	680	9	9111	5566	1.63690262306863	0.329643885992652	0.350399540884695	true	false	false	true
9bf708b9-05b0-41a6-9509-2fd8b8d65f35	2026-10-02 10:12	2026-10-02 10:12	2026-10-02 10:12	VXX	VXX261009P00017500	put	17.5000	2026-10-09	0.2900	0.2900	0.3600	17.5650	23780.00	0.00	23780.00	820	7	9144	5515	1.65802357207616	0.338591655940518	0.338591655940518	false	false	false	true
b1083a73-b2f7-48af-938a-6de13af67ddd	2026-10-02 10:08	2026-10-02 10:08	2026-10-02 10:08	VXX	VXX261009C00017500	call	17.5000	2026-10-09	0.3600	0.3600	0.4100	17.5690	30240.00	0.00	30240.00	840	6	7571	5566	1.3602227811714	0.327362589901937	0.327362589901937	false	false	false	true
cd0367c2-e04f-46a8-8b45-33cb6410b2a2	2026-10-02 10:05	2026-10-02 10:05	2026-10-02 10:05	VXX	VXX261009C00017500	call	17.5000	2026-10-09	0.3200	0.3200	0.3600	17.4700	25600.00	0.00	25600.00	800	7	6001	5566	1.07815307222422	0.339836301390543	0.339836301390543	false	false	false	true
0837880f-3927-4679-900d-92df04b5da3a	2026-10-02 09:58	2026-10-02 09:58	2026-10-02 09:58	VXX	VXX261009P00017500	put	17.5000	2026-10-09	0.3200	0.3200	0.3500	17.5200	14720.00	0.00	14720.00	460	8	4438	5515	0.804714415231188	0.348059135980348	0.348059135980348	false	false	false	true
50b49120-532d-45f2-a553-8a65c801e972	2026-10-02 09:53	2026-10-02 09:53	2026-10-02 09:53	VXX	VXX261009C00017500	call	17.5000	2026-10-09	0.3800	0.3800	0.4300	17.0000	11780.00	0.00	11780.00	310	33	2679	5566	0.481315127560187	0.350399540884695	0.350399540884695	true	false	false	true
6a4a85d8-469f-4587-901c-b216cb1024f5	2026-10-02 09:48	2026-10-02 09:48	2026-10-02 09:48	VXX	VXX261009P00017500	put	17.5000	2026-10-09	0.3200	0.3200	0.3500	17.0000	16000.00	0.00	16000.00	500	17	1142	5515	0.207071622846782	0.372069065462219	0.372069065462219	true	false	false	true
c281496b-d944-4017-bfc5-0847d415dc7b	2026-10-02 09:46	2026-10-02 09:46	2026-10-02 09:46	VXX	VXX261009C00017500	call	17.5000	2026-10-09	0.3800	0.3800	0.4300	17.0000	19760.00	0.00	19760.00	520	22	850	5566	0.152712899748473	0.361626523203683	0.361626523203683	true	false	false	true
4a75a176-2e91-479b-ab02-d04d7a0715f5	2026-10-01 15:11	2026-10-01 15:11	2026-10-01 15:11	VXX	VXX261120C00035000	call	35.0000	2026-11-20	0.2900	0.2300	0.2900	17.7650	12702.00	12702.00	0.00	438	12	34397	256	134.36328125	1.18402611914283	1.18402611914283	false	false	false	true
46fccc99-b4c5-42b8-b79a-1b83618c5e75	2026-10-01 15:11	2026-10-01 15:11	2026-10-01 15:11	VXX	VXX261120C00035000	call	35.0000	2026-11-20	0.2900	0.2300	0.2900	17.7650	65134.00	65134.00	0.00	2246	56	33959	256	132.65234375	1.18402611914283	1.18402611914283	false	false	false	true
4421c3a3-7252-4a00-b3a0-c90c155e1995	2026-10-01 15:11	2026-10-01 15:11	2026-10-01 15:11	VXX	VXX261120C00035000	call	35.0000	2026-11-20	0.2900	0.2800	0.2900	17.7574	136097.00	136097.00	0.00	4693	44	31713	256	123.87890625	1.18467450316316	1.18467450316316	false	false	false	true
8fd02ced-fc99-4a98-8b50-f2724b574304	2026-10-01 14:09	2026-10-01 14:09	2026-10-01 14:09	VXX	VXX261120C00035000	call	35.0000	2026-11-20	0.2700	0.2700	0.2800	17.9400	27000.00	0.00	27000.00	1000	15	25589	256	99.95703125	1.15092028637897	1.15092028637897	false	false	false	true
81330d01-02a4-4870-a54e-9c1b761dbaf9	2026-10-01 14:06	2026-10-01 14:06	2026-10-01 14:06	VXX	VXX261120C00035000	call	35.0000	2026-11-20	0.2700	0.2700	0.2800	17.9300	27000.00	0.00	27000.00	1000	15	24589	256	96.05078125	1.15175450338894	1.15175450338894	false	false	false	true
4661b3fb-3adf-4054-8370-6a9919f80cce	2026-10-01 13:49	2026-10-01 13:49	2026-10-01 13:49	VXX	VXX261120C00035000	call	35.0000	2026-11-20	0.2700	0.2100	0.2800	17.0000	33561.00	864.00	30672.00	1243	6	23316	256	91.078125	1.16516426797078	1.16516426797078	true	false	false	true
f36969ab-82aa-4227-91c1-addb02ce2d87	2026-10-01 13:49	2026-10-01 13:49	2026-10-01 13:49	VXX	VXX261120C00035000	call	35.0000	2026-11-20	0.2700	0.2100	0.2800	17.0000	51246.00	15903.00	35343.00	1898	19	22073	256	86.22265625	1.16516426797078	1.16516426797078	false	false	false	true
b95dd531-a883-40e9-a4bf-6bd383428de5	2026-10-01 13:49	2026-10-01 13:49	2026-10-01 13:49	VXX	VXX261120C00035000	call	35.0000	2026-11-20	0.2700	0.2600	0.2700	17.0000	164403.00	164403.00	0.00	6089	49	20174	256	78.8046875	1.16600630240941	1.16600630240941	false	false	false	true
04aa06e8-693c-45ed-808d-01219d1667f3	2026-10-01 13:25	2026-10-01 13:25	2026-10-01 13:25	VXX	VXX261218C00017000	call	17.0000	2026-12-18	2.4400	2.4400	2.6000	17.7900	12688.00	0.00	12688.00	52	13	55	265	0.207547169811321	0.607219872492162	0.607219872492162	true	false	false	true
3f93fcb1-714d-49f7-a77e-e6ff10400049	2026-10-01 11:51	2026-10-01 11:50	2026-10-01 11:50	VXX	VXX261120C00035000	call	35.0000	2026-11-20	0.2700	0.2600	0.3100	18.0100	35991.00	35856.00	135.00	1333	14	11334	256	44.2734375	1.14509345801449	1.14509345801449	false	false	false	true
932ee981-fd39-40e1-b588-e1cdb54d5716	2026-10-01 11:49	2026-10-01 11:49	2026-10-01 11:49	VXX	VXX261120C00035000	call	35.0000	2026-11-20	0.2700	0.2600	0.3100	18.0000	211248.00	27.00	210843.00	7824	11	10001	256	39.06640625	1.14592450650208	1.14509345801449	false	false	false	true
76ea25a5-ee53-410a-97b4-919d50be7163	2026-10-01 11:49	2026-10-01 11:49	2026-10-01 11:49	VXX	VXX261120C00035000	call	35.0000	2026-11-20	0.2700	0.2600	0.3900	18.0000	58752.00	31752.00	27000.00	2176	44	2177	256	8.50390625	1.14592450650208	1.14592450650208	false	false	false	true
5143be19-2004-46c3-9918-e74ebc5deb95	2026-10-01 10:08	2026-10-01 10:08	2026-10-01 10:08	VXX	VXX261002C00018000	call	18.0000	2026-10-02	0.2400	0.2000	0.2600	17.9600	16680.00	720.00	15360.00	695	26	1533	10924	0.14033321127792	0.68875150607878	0.68875150607878	true	false	false	true
0d17c9f2-b9a2-4bcb-9cf8-ffafc5d1d935	2026-10-01 09:34	2026-10-01 09:34	2026-10-01 09:34	VXX	VXX261002C00017500	call	17.5000	2026-10-02	0.3000	0.2900	0.3000	17.7050	10140.00	10140.00	0.00	338	6	352	6837	0.0514845692555214	0.483488882118538	0.483488882118538	false	false	false	true
74f08112-3be1-4444-9fad-abad110a745a	2026-09-30 15:55	2026-09-30 15:55	2026-09-30 15:55	VXX	VXX261002P00017500	put	17.5000	2026-10-02	0.1600	0.1500	0.1700	17.6000	24976.00	21376.00	2880.00	1561	10	2026	5814	0.348469212246302	0.401046106458479	0.401046106458479	false	false	false	true
771b6a1d-881a-458d-9ec1-3e6e4d361b2b	2026-09-30 10:03	2026-09-30 10:03	2026-09-30 10:03	VXX	VXX261009P00017500	put	17.5000	2026-10-09	0.5600	0.5600	0.6300	17.2550	53424.00	0.00	53424.00	954	82	4916	354	13.8870056497175	0.401529149746567	0.401529149746567	true	false	false	true
5002434c-5578-426a-964b-62b8556749fe	2026-09-30 09:57	2026-09-30 09:57	2026-09-30 09:57	VXX	VXX261009P00017500	put	17.5000	2026-10-09	0.5400	0.5400	0.6300	17.2600	24030.00	0.00	24030.00	445	9	2929	354	8.27401129943503	0.385414365612963	0.385414365612963	false	false	false	true
e01e7522-67e3-4d34-b73c-caea4a47580b	2026-09-30 09:54	2026-09-30 09:54	2026-09-30 09:54	VXX	VXX261009P00017500	put	17.5000	2026-10-09	0.5300	0.5300	0.6300	17.2600	26659.00	0.00	26659.00	503	12	2484	354	7.01694915254237	0.376007116353367	0.376007116353367	true	false	false	true
1def54d0-acfe-4407-9463-2ca79e417906	2026-09-30 09:47	2026-09-30 09:46	2026-09-30 09:46	VXX	VXX261009P00017500	put	17.5000	2026-10-09	0.5400	0.5400	0.6400	17.3200	20520.00	0.00	20520.00	380	5	1385	354	3.91242937853107	0.41663368152222	0.41663368152222	true	false	false	true
ec9b5a8e-9403-4e5d-8a44-0626d41010cf	2026-09-29 11:58	2026-09-29 11:57	2026-09-29 11:57	VXX	VXX261002C00018000	call	18.0000	2026-10-02	0.1300	0.1100	0.1300	17.5000	14950.00	14950.00	0.00	1150	9	3065	6527	0.469587865788264	0.495158333875842	0.495158333875842	true	false	false	true
a00bb1f2-7a00-4e87-b5e6-b8e1b4de0697	2026-09-28 13:16	2026-09-28 13:16	2026-09-28 13:16	VXX	VXX261002C00018000	call	18.0000	2026-10-02	0.1300	0.1000	0.1300	17.3050	12181.00	12181.00	0.00	937	16	5377	2751	1.95456197746274	0.513473611230399	0.513473611230399	false	false	false	true
bde97325-db6f-4147-9fe3-0732a9a84974	2026-09-28 13:16	2026-09-28 13:16	2026-09-28 13:16	VXX	VXX261002C00018000	call	18.0000	2026-10-02	0.1300	0.1000	0.1300	17.3050	12038.00	12038.00	0.00	926	7	4377	2751	1.59105779716467	0.513473611230399	0.513473611230399	false	false	false	true
56cfd226-60fa-4c88-aa1e-eb49da2c4e3c	2026-09-28 11:24	2026-09-28 11:23	2026-09-28 11:23	VXX	VXX261002C00020000	call	20.0000	2026-10-02	0.0500	0.0100	0.0600	17.0000	20540.00	16455.00	4085.00	4108	49	4145	13111	0.316146747006331	0.811218245715172	0.811218245715172	true	false	false	true
1f0064d8-261e-479b-9c06-ca6215f3c66e	2026-09-28 11:21	2026-09-28 11:21	2026-09-28 11:21	VXX	VXX261002C00018500	call	18.5000	2026-10-02	0.1100	0.1100	0.1400	17.0000	11000.00	0.00	11000.00	1000	6	6133	5387	1.13848152960832	0.525745685576794	0.525745685576794	false	false	false	true
bf5418b7-0070-45ce-ab24-4d42d0f8aecc	2026-09-28 11:20	2026-09-28 11:20	2026-09-28 11:20	VXX	VXX261002C00018500	call	18.5000	2026-10-02	0.1100	0.1100	0.1400	17.0000	11000.00	0.00	11000.00	1000	6	5133	5387	0.952849452385372	0.529658281085435	0.529658281085435	false	false	false	true
60065a4b-5edb-47d3-8221-8e8515cae544	2026-09-28 10:54	2026-09-28 10:54	2026-09-28 10:54	VXX	VXX261023C00020000	call	20.0000	2026-10-23	0.5000	0.4900	0.5000	17.7400	12550.00	12550.00	0.00	251	21	353	219	1.61187214611872	0.672419194892422	0.672419194892422	false	false	false	true
fc42023c-b9f8-43fc-82f8-b9bbe4c49697	2026-09-28 10:53	2026-09-28 10:53	2026-09-28 10:53	VXX	VXX261016C00020000	call	20.0000	2026-10-16	0.3500	0.3100	0.3600	17.7150	45500.00	2520.00	5040.00	1300	6	1318	14466	0.0911101894096502	0.68272599117578	0.68272599117578	false	false	false	true
b91c3596-5776-4f9e-abb6-9759d7e790e1	2026-09-28 10:48	2026-09-28 10:47	2026-09-28 10:47	VXX	VXX261002C00018500	call	18.5000	2026-10-02	0.1300	0.1200	0.1300	17.6800	16796.00	16796.00	0.00	1292	24	3570	5387	0.662706515685911	0.550635399986819	0.550635399986819	false	false	false	true
5dbdb3dd-326e-49a7-89f1-97de2ba1de0c	2026-09-28 09:51	2026-09-28 09:51	2026-09-28 09:51	VXX	VXX261002C00018500	call	18.5000	2026-10-02	0.0900	0.0900	0.1100	17.0000	14139.00	0.00	14139.00	1571	45	2023	5387	0.375533692222016	0.56650409478347	0.56650409478347	true	false	false	true
b67cdc44-fceb-4c38-9f60-894d9ce0cceb	2026-09-25 11:54	2026-09-25 11:54	2026-09-25 11:54	VXX	VXX260925C00015500	call	15.5000	2026-09-25	2.0000	1.9700	2.5500	17.0000	14400.00	0.00	14400.00	72	11	90	2	45	9.14613820187431	9.14644925985493	false	false	false	true
c33a076e-5a34-4537-9ee3-5cefd6eedf6d	2026-09-24 14:24	2026-09-24 14:24	2026-09-24 14:24	VXX	VXX261218C00019000	call	19.0000	2026-12-18	1.8000	1.6500	1.9100	17.5700	18720.00	18360.00	0.00	104	6	104	187	0.556149732620321	0.680225971414559	0.680225971414559	true	false	false	true
eec266f2-7bdb-4c16-8d7d-86e4f1001548	2026-09-24 13:43	2026-09-24 13:42	2026-09-24 13:42	VXX	VXX261002C00019500	call	19.5000	2026-10-02	0.1100	0.1000	0.1800	17.6300	22891.00	220.00	22671.00	2000	38	3847	2714	1.4174649963154	0.604441380032801	0.604441380032801	true	false	false	true