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.

425,429 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts425,429 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:alert_rule = RepeatedHits×source = uw_flow_alerts×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	expiry

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	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	49252224379.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-24T19:50:03.728318Z"}	2026-09-24	2026-09-24 21:15	2026-09-24 21:15
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
15814d93-f28a-4cfc-835e-4bf953795adb	2026-09-24 09:38	2026-09-24 09:38	2026-09-24 09:38	SOXX	SOXX260925P00550000	put	550.0000	2026-09-25	2.4500	2.3000	2.4500	557.3400	12250.00	12250.00	0.00	50	6	114	590	0.193220338983051	0.463346934409097	0.463346934409097	false	false	false
f1a68bdc-9ce7-4d6e-bde5-d6964b338a52	2026-09-24 09:33	2026-09-24 09:33	2026-09-24 09:33	SOXX	SOXX261030P00522500	put	522.5000	2026-10-30	14.2000	14.2000	16.0000	553.8000	28400.00	0.00	28400.00	20	9	21	6	3.5	0.413030836606556	0.413030836606556	true	false	false	true
48bd0573-5434-4bfa-ab22-9d00e37523de	2026-09-23 15:54	2026-09-23 15:54	2026-09-23 15:54	SOXX	SOXX261002C00565000	call	565.0000	2026-10-02	12.8000	12.2000	12.9500	563.9900	70400.00	70400.00	0.00	55	11	229	163	1.40490797546012	0.368623811416764	0.368623811416764	false	false	false
a26c453d-c06b-459d-9d10-2a61180bbd0b	2026-09-23 15:45	2026-09-23 15:44	2026-09-23 15:44	SOXX	SOXX261218C00580000	call	580.0000	2026-12-18	40.2000	39.1000	40.7000	564.0000	20100.00	4020.00	16080.00	5	5	3693	9033	0.408834274327466	0.408138700708968	0.408138700708968	false	false	false
10d2442d-05d6-42bc-a468-2f265717e662	2026-09-23 15:34	2026-09-23 15:34	2026-09-23 15:34	SOXX	SOXX281215P00600000	put	600.0000	2028-12-15	132.4000	130.8000	133.9000	564.7000	92680.00	79440.00	13240.00	7	7	15	68	0.220588235294118	0.44675541912542	0.44675541912542	false	false	false
529f12d4-c424-4cfb-98c8-0e09cf19608b	2026-09-23 14:49	2026-09-23 14:49	2026-09-23 14:49	SOXX	SOXX261218C00580000	call	580.0000	2026-12-18	40.2000	39.8000	40.2000	563.8800	225120.00	225120.00	0.00	56	28	3066	9033	0.339422118897376	0.41118311608713	0.41118311608713	false	false	false
10d08d26-25a5-4397-b813-4c22104e1abd	2026-09-23 14:25	2026-09-23 14:25	2026-09-23 14:25	SOXX	SOXX261218P00500000	put	500.0000	2026-12-18	18.4000	18.3000	18.7000	564.0000	92000.00	0.00	92000.00	50	5	667	1146	0.582024432809773	0.437491489034643	0.437491489034643	false	false	false
ecf79ea5-c45e-40d1-85a7-949713edae85	2026-09-23 14:17	2026-09-23 14:17	2026-09-23 14:17	SOXX	SOXX261218P00500000	put	500.0000	2026-12-18	18.4000	18.4000	18.6000	564.3900	108560.00	0.00	108560.00	59	13	545	1146	0.475567190226876	0.437659048528638	0.437812602779568	true	false	false
9219659c-5c08-4f55-bdb4-2736965c032f	2026-09-23 14:17	2026-09-23 14:17	2026-09-23 14:17	SOXX	SOXX261218P00500000	put	500.0000	2026-12-18	18.4000	18.4000	18.6000	564.3200	33120.00	0.00	33120.00	18	6	419	1146	0.365619546247819	0.437617163133635	0.437617163133635	true	false	false