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.

523,327 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts523,327 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 = SOXX×

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

dd2cad11-f508-4b3a-9103-9290cca1e62b	2026-09-25 12:22	2026-09-25 12:22	2026-09-25 12:22	SOXX	SOXX261002P00420000	put	420.0000	2026-10-02	0.0700	0.0000	0.1000	573.4250	70000.00	40000.00	0.00	10000	2	10025	696	14.4037356321839	0.819624467262604	0.819624467262604	false	true	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	48211317124.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-25T16:23:36.031471Z"}	2026-09-25	2026-09-25 21:15	2026-09-25 21:15
9007c719-8b0f-4da0-8417-268fd18a0ca0	2026-09-25 12:21	2026-09-25 12:21	2026-09-25 12:21	SOXX	SOXX261002P00550000	put	550.0000	2026-10-02	3.7000	3.4000	3.7000	573.1100	42550.00	42550.00	0.00	115	12	195	787	0.247776365946633	0.385741512247763	0.385741512247763	true	false	false	true
84cf39db-a2f7-446e-9ab4-c2eae7121be3	2026-09-25 11:37	2026-09-25 11:36	2026-09-25 11:36	SOXX	SOXX261002P00560000	put	560.0000	2026-10-02	7.0000	5.7000	7.0000	569.9900	17500.00	17500.00	0.00	25	5	49	397	0.123425692695214	0.367476598639876	0.367476598639876	false	false	false	true
fa725a2d-49dc-4930-971e-7e6a2f696cdc	2026-09-25 11:07	2026-09-25 11:07	2026-09-25 11:07	SOXX	SOXX261120C00560000	call	560.0000	2026-11-20	45.2000	42.4000	45.2000	572.8500	67798.00	67798.00	0.00	15	5	18	1659	0.0108499095840868	0.412988095490523	0.412988095490523	false	false	false	true
1b20fd52-5678-4962-8b64-a27921596d8e	2026-09-25 10:26	2026-09-25 10:26	2026-09-25 10:26	SOXX	SOXX261002P00567500	put	567.5000	2026-10-02	10.0000	10.0000	12.2000	570.1150	34000.00	0.00	34000.00	34	8	36	15	2.4	0.364888532926652	0.364888532926652	true	false	false	true
bd75e269-101c-4d53-9d6f-8ed48281c401	2026-09-25 10:06	2026-09-25 10:06	2026-09-25 10:06	SOXX	SOXX261120C00670000	call	670.0000	2026-11-20	7.7000	6.5000	9.1000	570.8700	38500.00	23100.00	15400.00	50	7	50	11	4.54545454545455	0.389309128348334	0.389309128348334	false	false	false	true
4366bf94-bbb5-4037-90f8-d6c4981fc2c2	2026-09-25 10:00	2026-09-25 09:59	2026-09-25 09:59	SOXX	SOXX261002P00542500	put	542.5000	2026-10-02	2.1500	2.1500	2.9000	574.0000	11610.00	0.00	11610.00	54	8	54	111	0.486486486486487	0.387456263167812	0.387456263167812	false	false	false	true
67099892-8895-4069-90e4-6eee76ee08a3	2026-09-25 09:55	2026-09-25 09:55	2026-09-25 09:55	SOXX	SOXX270917P00480000	put	480.0000	2027-09-17	45.0000	45.0000	49.0000	574.2400	450000.00	0.00	297000.00	100	6	101	0	0	0.452826315164329	0.452826315164329	false	false	false	true
d847cc2f-3c30-4274-8804-adfb8e31a06e	2026-09-25 09:49	2026-09-25 09:48	2026-09-25 09:48	SOXX	SOXX270319P00500000	put	500.0000	2027-03-19	31.0000	31.0000	32.6000	571.6500	80600.00	0.00	80600.00	26	5	26	1478	0.0175913396481732	0.437567411190798	0.437567411190798	false	false	false	true
f1a47179-3f4e-4b88-b4c1-96cb04818000	2026-09-24 15:48	2026-09-24 15:48	2026-09-24 15:48	SOXX	SOXX261030P00525000	put	525.0000	2026-10-30	11.6000	11.5000	11.9000	565.2400	17400.00	5800.00	11600.00	15	5	15	102	0.147058823529412	0.408244409829955	0.408244409829955	false	false	false	true
21d50ec1-312d-4597-8c07-793515aeff13	2026-09-24 15:30	2026-09-24 15:29	2026-09-24 15:29	SOXX	SOXX261016P00525000	put	525.0000	2026-10-16	6.5300	6.5000	6.9000	564.4100	44380.00	6030.00	38350.00	68	5	219	1211	0.180842279108175	0.390901120232276	0.39597554643197	false	false	false	true
d9806539-599a-4774-82f2-47f64133879a	2026-09-24 15:30	2026-09-24 15:29	2026-09-24 15:29	SOXX	SOXX261016P00525000	put	525.0000	2026-10-16	6.5000	6.5000	7.0000	564.4100	33800.00	0.00	33800.00	52	6	151	1211	0.124690338563171	0.390901120232276	0.390901120232276	false	false	false	true
947dfa7b-d236-4978-83b7-f388cdcd519b	2026-09-24 15:30	2026-09-24 15:29	2026-09-24 15:29	SOXX	SOXX261016P00525000	put	525.0000	2026-10-16	6.6000	6.4000	7.1000	564.4100	23760.00	16500.00	7260.00	36	5	80	1211	0.0660611065235343	0.39344321872146	0.39344321872146	false	false	false	true
556b2c65-a49e-451b-852f-23df59b4958f	2026-09-24 15:30	2026-09-24 15:29	2026-09-24 15:29	SOXX	SOXX261016P00525000	put	525.0000	2026-10-16	6.4000	6.4000	7.2000	564.4100	26240.00	0.00	14080.00	41	5	44	1211	0.0363336085879438	0.38834898013356	0.38834898013356	false	false	false	true
40c4cfcc-7879-4116-8f39-c82f193064de	2026-09-24 15:23	2026-09-24 15:23	2026-09-24 15:23	SOXX	SOXX270617P00500000	put	500.0000	2027-06-17	44.4000	44.2000	44.4000	565.0500	84360.00	75480.00	0.00	19	12	547	5195	0.105293551491819	0.442255347734785	0.442306557194621	true	false	false	true
6215465d-04de-4c5c-aa15-a2a825140621	2026-09-24 15:23	2026-09-24 15:23	2026-09-24 15:23	SOXX	SOXX270617P00500000	put	500.0000	2027-06-17	44.3000	42.9000	44.4000	565.1100	137330.00	35440.00	101890.00	31	7	438	5195	0.0843118383060635	0.441786984115384	0.441786984115384	true	false	false	true
7272d61a-3dfd-49c4-9f6d-6726274c8510	2026-09-24 15:22	2026-09-24 15:22	2026-09-24 15:22	SOXX	SOXX270617P00500000	put	500.0000	2027-06-17	44.1900	43.3000	44.7000	565.1100	159090.00	97240.00	53010.00	36	29	278	5195	0.0535129932627526	0.441028407906819	0.44116489408819	true	false	false	true
67d599cc-cd0b-4264-96cc-2c9071c3a5c5	2026-09-24 15:12	2026-09-24 15:12	2026-09-24 15:12	SOXX	SOXX261016C00600000	call	600.0000	2026-10-16	7.8000	7.2000	8.4000	563.7600	12480.00	11700.00	780.00	16	5	683	11314	0.0603676860526781	0.364136551699615	0.364136551699615	false	false	false	true
a493b060-81f3-43bd-8e02-1e21274289e6	2026-09-24 15:11	2026-09-24 15:11	2026-09-24 15:11	SOXX	SOXX261218C00565000	call	565.0000	2026-12-18	46.2000	46.2000	48.1000	563.5000	106260.00	0.00	106260.00	23	7	24	45	0.533333333333333	0.409343701142081	0.409343701142081	true	false	false	true
d85f3236-a52c-4c4c-ad79-d9b43d9b7737	2026-09-24 15:09	2026-09-24 15:09	2026-09-24 15:09	SOXX	SOXX261016P00475000	put	475.0000	2026-10-16	1.5000	1.5000	1.5500	564.2100	11850.00	0.00	11850.00	79	7	767	2492	0.307784911717496	0.457345229459301	0.457345229459301	false	false	false	true
f49abc60-759f-4cd5-9abe-ead6abab0f7a	2026-09-24 15:09	2026-09-24 15:09	2026-09-24 15:09	SOXX	SOXX261016P00475000	put	475.0000	2026-10-16	1.5000	1.5000	1.6500	564.2950	19200.00	0.00	19200.00	128	15	686	2492	0.275280898876405	0.457647012442867	0.457647012442867	false	false	false	true
3c0304c0-b36f-4497-9d52-5304a43908da	2026-09-24 15:09	2026-09-24 15:09	2026-09-24 15:09	SOXX	SOXX261016P00475000	put	475.0000	2026-10-16	1.5000	1.5000	1.6000	564.2500	16800.00	0.00	16800.00	112	14	558	2492	0.223916532905297	0.457487256250498	0.457487256250498	false	false	false	true
af7f4d92-2f75-4607-9229-7a4b6a3525d6	2026-09-24 14:49	2026-09-24 14:49	2026-09-24 14:49	SOXX	SOXX270115C00570000	call	570.0000	2027-01-15	51.1000	51.1000	53.3000	563.0000	76650.00	0.00	76650.00	15	7	47	200	0.235	0.403788846863793	0.403788846863793	false	false	false	true
2db534b4-ca7f-4e92-8105-44d85f9ff544	2026-09-24 14:04	2026-09-24 14:04	2026-09-24 14:04	SOXX	SOXX261016C00600000	call	600.0000	2026-10-16	6.8000	5.8000	8.1000	559.0000	12920.00	12240.00	680.00	19	5	663	11314	0.0585999646455719	0.363381874229733	0.363381874229733	false	false	false	true
f3ee5efc-7e1a-4047-9edd-f2b1fd87ef93	2026-09-24 14:03	2026-09-24 14:03	2026-09-24 14:03	SOXX	SOXX270115P00475000	put	475.0000	2027-01-15	16.9000	16.5000	17.0000	560.0000	20280.00	13520.00	0.00	12	5	193	386	0.5	0.438466335631826	0.438466335631826	false	false	false	true
7bbf436d-8e15-402a-94e6-821b8c6a1d04	2026-09-24 13:54	2026-09-24 13:54	2026-09-24 13:54	SOXX	SOXX261030C00555000	call	555.0000	2026-10-30	32.1000	31.8000	35.7000	561.0000	41730.00	0.00	41730.00	13	7	13	18	0.722222222222222	0.393364652361574	0.393364652361574	true	false	false	true
e9c76926-dbe6-4528-93a7-e8deede315df	2026-09-24 13:43	2026-09-24 13:43	2026-09-24 13:43	SOXX	SOXX261218C00525000	call	525.0000	2026-12-18	67.9000	67.0000	72.4000	562.0000	203700.00	33950.00	169750.00	30	8	30	20	1.5	0.419019648703282	0.419019648703282	true	false	false	true
e8334a30-0729-4ff1-94a0-1bb0fd20604b	2026-09-24 13:26	2026-09-24 13:26	2026-09-24 13:26	SOXX	SOXX261002P00565000	put	565.0000	2026-10-02	12.7000	11.8000	12.7000	563.0000	17780.00	17780.00	0.00	14	6	26	52	0.5	0.358393651999297	0.358393651999297	false	false	false	true
2c433a2f-d260-40c8-988c-d137c5ccdfec	2026-09-24 13:00	2026-09-24 13:00	2026-09-24 13:00	SOXX	SOXX261218C00530000	call	530.0000	2026-12-18	66.6000	66.5000	67.6000	564.9700	286380.00	0.00	253080.00	43	12	45	4018	0.0111996017919363	0.416879135301698	0.416879135301698	true	false	false	true
0250659e-828a-43bf-ab0e-3102ca5ff7f8	2026-09-24 12:45	2026-09-24 12:45	2026-09-24 12:45	SOXX	SOXX261016P00590000	put	590.0000	2026-10-16	35.6000	32.7000	35.7000	563.6100	142400.00	142400.00	0.00	40	11	40	49	0.816326530612245	0.368263371905107	0.368263371905107	true	false	false	true
12da32a0-f4e4-42e4-b44f-92cdafeddec1	2026-09-24 12:45	2026-09-24 12:45	2026-09-24 12:45	SOXX	SOXX260925P00565000	put	565.0000	2026-09-25	5.2000	4.3000	5.2000	563.7301	29120.00	29120.00	0.00	56	24	162	189	0.857142857142857	0.402798760831199	0.387860168348594	true	false	false	true
9275e76a-8c6b-41d2-bf4d-8e2ac89a9913	2026-09-24 12:45	2026-09-24 12:44	2026-09-24 12:44	SOXX	SOXX260925P00565000	put	565.0000	2026-09-25	4.9000	3.9000	5.0000	564.4600	13720.00	13720.00	0.00	28	9	106	189	0.560846560846561	0.394939574987446	0.394939574987446	true	false	false	true
5e8ce9ea-b257-4537-9d72-3a54ecc89743	2026-09-24 12:17	2026-09-24 12:17	2026-09-24 12:17	SOXX	SOXX261002C00577500	call	577.5000	2026-10-02	5.7000	4.3000	5.7000	561.0200	17668.00	17668.00	0.00	31	21	71	2	35.5	0.358297071050385	0.357611970531956	true	false	false	true
18f6bcfa-20ae-4729-bec6-4b8848b0fc38	2026-09-24 12:16	2026-09-24 12:16	2026-09-24 12:16	SOXX	SOXX261016C00500000	call	500.0000	2026-10-16	65.0000	60.6000	65.0000	560.0500	123500.00	123500.00	0.00	19	8	29	459	0.0631808278867102	0.42652297977137	0.42652297977137	false	false	false	true
8a1d2e76-ef2d-45a6-b1a4-193c8d5dbaa0	2026-09-24 12:16	2026-09-24 12:16	2026-09-24 12:16	SOXX	SOXX261002P00585000	put	585.0000	2026-10-02	27.8000	27.8000	31.0000	559.0000	27800.00	0.00	27800.00	10	5	10	167	0.0598802395209581	0.33980475817636	0.33980475817636	false	false	false	true
d3869501-a8e0-4a83-bcf0-51e316e3895d	2026-09-24 12:16	2026-09-24 12:16	2026-09-24 12:16	SOXX	SOXX261002C00577500	call	577.5000	2026-10-02	5.0000	4.0000	5.0000	559.0000	15000.00	15000.00	0.00	30	12	39	2	19.5	0.353624302106741	0.352008152161939	true	false	false	true
518083ab-0722-42b4-becf-20858f6b29e3	2026-09-24 11:36	2026-09-24 11:36	2026-09-24 11:36	SOXX	SOXX260925C00555000	call	555.0000	2026-09-25	5.1000	5.1000	5.8000	556.0000	40800.00	0.00	40290.00	80	17	91	182	0.5	0.381877981734095	0.381877981734095	true	false	false	true
b01c1719-d2f7-4577-a6e8-90e6aa38622c	2026-09-24 11:09	2026-09-24 11:09	2026-09-24 11:09	SOXX	SOXX261002P00540000	put	540.0000	2026-10-02	6.0000	5.2000	6.0000	554.0000	18600.00	18600.00	0.00	31	5	51	855	0.0596491228070175	0.37787229267796	0.377559049644759	true	false	false	true
ae10a4b4-3095-4e34-ac7b-119622e463e4	2026-09-24 11:09	2026-09-24 11:09	2026-09-24 11:09	SOXX	SOXX261002P00552500	put	552.5000	2026-10-02	10.5000	8.4000	10.5000	555.0000	15750.00	15750.00	0.00	15	9	20	19	1.05263157894737	0.365178720723185	0.365178720723185	true	false	false	true
02122498-d1d0-414e-9b4c-6a1195a12c25	2026-09-24 10:52	2026-09-24 10:52	2026-09-24 10:52	SOXX	SOXX261002C00537500	call	537.5000	2026-10-02	23.9000	23.9000	28.2000	555.9500	14340.00	0.00	14340.00	6	6	6	19	0.315789473684211	0.377200126260969	0.377200126260969	false	false	false	true
684b5c18-0478-41ce-8cce-10bfa28ce490	2026-09-24 10:51	2026-09-24 10:51	2026-09-24 10:51	SOXX	SOXX261023P00500000	put	500.0000	2026-10-23	5.6000	5.6000	5.9000	556.6300	33040.00	0.00	33040.00	59	10	65	40	1.625	0.41247678735626	0.41247678735626	true	false	false	true
c70e16aa-8a45-433e-8838-18414ca56ab1	2026-09-24 10:28	2026-09-24 10:28	2026-09-24 10:28	SOXX	SOXX261002C00565000	call	565.0000	2026-10-02	9.3900	8.2000	10.4000	558.5500	51665.00	4665.00	47000.00	55	11	58	317	0.182965299684543	0.366289053812556	0.366289053812556	false	false	false	true
7b6b9d9a-9b2b-4f39-a23c-50ab3c471d0b	2026-09-24 10:28	2026-09-24 10:28	2026-09-24 10:28	SOXX	SOXX261002C00565000	call	565.0000	2026-10-02	9.4000	9.4000	9.9000	558.5500	28200.00	0.00	28200.00	30	6	88	317	0.277602523659306	0.366289053812556	0.366289053812556	false	false	false	true
ef9781ca-8431-46fc-b5af-0cd6841120dd	2026-09-24 10:18	2026-09-24 10:18	2026-09-24 10:18	SOXX	SOXX261016C00600000	call	600.0000	2026-10-16	5.7000	5.7000	7.1000	557.0000	57000.00	0.00	57000.00	100	18	129	11314	0.0114018030758352	0.353071421287152	0.353071421287152	false	false	false	true
0f77d12b-8051-490c-a2ec-0af8bab87da2	2026-09-24 10:15	2026-09-24 10:15	2026-09-24 10:15	SOXX	SOXX261009C00545000	call	545.0000	2026-10-09	23.3000	23.3000	25.1000	558.3000	23300.00	0.00	23300.00	10	7	10	16	0.625	0.340122199597516	0.340122199597516	false	false	false	true
6bd3d049-bba5-4750-84eb-6f71495e34f9	2026-09-24 09:58	2026-09-24 09:58	2026-09-24 09:58	SOXX	SOXX270319P00475000	put	475.0000	2027-03-19	27.4000	25.6000	29.3000	557.0300	54800.00	5480.00	2740.00	20	8	20	87	0.229885057471264	0.447462124644082	0.447462124644082	false	false	false	true
b1ed0a3f-2830-4e17-9da5-bd6daf914958	2026-09-24 09:53	2026-09-24 09:53	2026-09-24 09:53	SOXX	SOXX260925P00550000	put	550.0000	2026-09-25	1.9500	1.4500	2.0000	558.4000	27300.00	27300.00	0.00	140	22	469	590	0.794915254237288	0.440987394128523	0.440987394128523	true	false	false	true
4ff6a539-fcab-4e49-8ae8-3305afffb892	2026-09-24 09:47	2026-09-24 09:47	2026-09-24 09:47	SOXX	SOXX261030C00582500	call	582.5000	2026-10-30	19.4000	19.2000	19.4000	561.4800	25220.00	25220.00	0.00	13	5	13	0	0	0.388164456332293	0.388164456332293	false	false	false	true
4ffdd178-3927-43f7-a403-8ebc2258b170	2026-09-24 09:47	2026-09-24 09:46	2026-09-24 09:46	SOXX	SOXX261002C00560000	call	560.0000	2026-10-02	13.0100	12.5000	13.3000	561.1900	24720.00	22120.00	2600.00	19	5	23	270	0.0851851851851852	0.366916395250061	0.366916395250061	false	false	false	true
17ea184d-38ee-4c39-b406-18e3df3743c1	2026-09-24 09:38	2026-09-24 09:38	2026-09-24 09:38	SOXX	SOXX261009C00522500	call	522.5000	2026-10-09	41.3000	36.8000	41.3000	558.0000	94990.00	94990.00	0.00	23	5	23	31	0.741935483870968	0.403637040224155	0.398949335644209	true	false	false	true