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

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	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-01T19:16:50.147697Z"}	2026-10-01	2026-10-01 21:15	2026-10-01 21:15
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
a8c631fc-0b7d-4750-bcc0-5bffd57f6f0f	2026-10-01 11:14	2026-10-01 11:14	2026-10-01 11:14	VXX	VXX261009C00019500	call	19.5000	2026-10-09	0.1300	0.1300	0.1800	18.0051	13144.00	0.00	13144.00	1000	10	3607	1120	3.22053571428571	0.557556818627082	0.557556818627082	false	false	false	true
a0dc53d7-4998-471f-91c7-a0c223cf1db3	2026-10-01 10:16	2026-10-01 10:16	2026-10-01 10:16	VXX	VXX261030C00018000	call	18.0000	2026-10-30	1.1700	1.0800	1.2000	17.9700	11656.00	11656.00	0.00	100	8	107	1008	0.106150793650794	0.588157790789218	0.568281200959886	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
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
7685acda-dfff-4504-9ab3-348379843902	2026-09-30 09:43	2026-09-30 09:43	2026-09-30 09:43	VXX	VXX261009P00017500	put	17.5000	2026-10-09	0.5200	0.5200	0.6200	17.2700	28182.00	0.00	28182.00	539	22	1005	354	2.83898305084746	0.371991275431898	0.381380865305668	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
7d927deb-e2e6-4f90-8422-62aaae7eb8c5	2026-09-25 15:15	2026-09-25 15:15	2026-09-25 15:15	VXX	VXX260925C00015500	call	15.5000	2026-09-25	1.8000	1.8000	1.9500	17.3450	16225.00	0.00	16225.00	90	12	180	2	90	10.7859450116755	10.7859450116755	false	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
365e025e-41c2-4033-85c5-7ea2bb4a2748	2026-09-24 13:42	2026-09-24 13:42	2026-09-24 13:42	VXX	VXX261002C00019000	call	19.0000	2026-10-02	0.1500	0.1500	0.2100	17.6300	30000.00	0.00	30000.00	2000	7	3414	1181	2.89077053344623	0.553830227000286	0.553830227000286	false	false	false	true
13c6345c-2ff6-405f-93c2-e89903292518	2026-09-24 12:16	2026-09-24 12:16	2026-09-24 12:16	VXX	VXX261218P00017000	put	17.0000	2026-12-18	1.7300	1.6900	2.0300	17.0000	23182.00	0.00	23182.00	134	31	154	347	0.443804034582133	0.629620560251155	0.629620560251155	true	false	false	true
d77a60be-30f6-4a5d-8bb4-36da95836ec4	2026-09-24 12:15	2026-09-24 12:15	2026-09-24 12:15	VXX	VXX261030P00017000	put	17.0000	2026-10-30	0.9100	0.7100	0.9400	17.6400	19747.00	19110.00	637.00	217	24	259	624	0.415064102564103	0.570600807576512	0.569708782494487	true	false	false	true
d4bf2c6d-d95c-41f9-8c45-e40180308bb0	2026-09-24 10:37	2026-09-24 10:36	2026-09-24 10:36	VXX	VXX261002C00017500	call	17.5000	2026-10-02	0.4500	0.4500	0.5000	17.5600	17235.00	0.00	17235.00	383	46	4011	386	10.3911917098446	0.397441463010513	0.397441463010513	true	false	false	true
b9db5d66-6c15-4fde-a0ec-d5435e45c9b9	2026-09-24 10:09	2026-09-24 10:09	2026-09-24 10:09	VXX	VXX261002P00017500	put	17.5000	2026-10-02	0.4000	0.4000	0.4500	17.5300	74520.00	0.00	74520.00	1863	49	4004	375	10.6773333333333	0.408431675395813	0.408431675395813	true	false	false	true
b5854fb8-8df5-4624-ab36-47bfc055e1e4	2026-09-24 10:05	2026-09-24 10:05	2026-09-24 10:05	VXX	VXX261002C00017500	call	17.5000	2026-10-02	0.4600	0.4600	0.5000	17.5505	35604.00	0.00	35604.00	774	22	1995	386	5.16839378238342	0.412091052697515	0.412091052697515	true	false	false	true
c97e9d99-17e0-4778-8fe8-8ebffc193cc6	2026-09-24 09:50	2026-09-24 09:50	2026-09-24 09:50	VXX	VXX261016C00020000	call	20.0000	2026-10-16	0.4100	0.4100	0.5000	17.5950	46412.00	0.00	2214.00	1132	11	1132	13520	0.0837278106508876	0.681938002450015	0.681938002450015	true	false	false	true
0611e4a9-db88-4b7f-a5a5-61f9bce4cbaf	2026-09-23 11:30	2026-09-23 11:30	2026-09-23 11:30	VXX	VXX261002C00020000	call	20.0000	2026-10-02	0.1100	0.1100	0.1500	17.0000	15565.00	0.00	15565.00	1415	10	2784	6625	0.42022641509434	0.739324163122146	0.739324163122146	true	false	false	true
cf5d40d1-e06d-438d-b3ed-2fe3bf435dbd	2026-09-23 11:30	2026-09-23 11:29	2026-09-23 11:29	VXX	VXX261002C00019500	call	19.5000	2026-10-02	0.1200	0.1200	0.2200	17.0000	24000.00	0.00	24000.00	2000	50	2011	209	9.62200956937799	0.663812036495488	0.663812036495488	true	false	false	true
e9cb2d46-dc2b-4db9-a977-19e9ba06c98d	2026-09-23 10:46	2026-09-23 10:46	2026-09-23 10:46	VXX	VXX261218C00020000	call	20.0000	2026-12-18	1.7000	1.3400	1.7000	17.3450	17000.00	17000.00	0.00	100	15	120	1087	0.110395584176633	0.772125589446742	0.772125589446742	false	false	false	true
285bc2cc-dd3e-471d-8064-c3af2134903d	2026-09-23 09:47	2026-09-23 09:47	2026-09-23 09:47	VXX	VXX261016C00017000	call	17.0000	2026-10-16	1.0000	0.8700	1.0000	17.0000	74900.00	74900.00	0.00	749	23	750	1094	0.685557586837294	0.509342500035075	0.509342500035075	true	false	false	true
7e90fe93-e42b-494b-a485-aad1c6a8d693	2026-09-22 15:53	2026-09-22 15:53	2026-09-22 15:53	VXX	VXX261016C00020000	call	20.0000	2026-10-16	0.3200	0.3100	0.3700	17.0000	31136.00	1568.00	29568.00	973	47	1446	15202	0.0951190632811472	0.655983039508838	0.656811773774036	false	false	false	true
74618acf-1733-4849-b6a9-d635e4ffa55a	2026-09-22 09:37	2026-09-22 09:37	2026-09-22 09:37	VXX	VXX261002C00020000	call	20.0000	2026-10-02	0.1700	0.1200	0.2000	17.5150	13498.00	13498.00	0.00	794	5	799	4193	0.190555688051514	0.746941725118268	0.746941725118268	false	false	false	true
9acdc382-6a98-4086-b976-0b5e0cc752c3	2026-09-09 15:12	2026-09-09 15:12	2026-09-09 15:12	VXX	VXX270115C00020000	call	20.0000	2027-01-15	2.6000	2.6000	2.8800	18.2200	260000.00	0.00	161980.00	1000	6	1000	656	1.52439024390244	0.743981553047751	0.743981553047751	false	false	false	true
c715ab1c-5919-4053-a72a-ae32145258cb	2026-08-31 09:56	2026-08-31 09:56	2026-08-31 09:56	VXX	VXX261016C00018000	call	18.0000	2026-10-16	1.8000	1.6500	1.9300	18.3900	180000.00	69480.00	24840.00	1000	10	1002	3241	0.309163838321506	0.603998255432727	0.603998255432727	false	false	false	true