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.

474,253 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts474,253 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 = 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

f8db2aae-54e0-4117-936a-a0535463ec77	2026-09-25 15:43	2026-09-25 15:43	2026-09-25 15:43	SOXX	SOXX261002P00560000	put	560.0000	2026-10-02	5.8000	5.8000	6.0000	572.0000	15080.00	0.00	15080.00	26	12	149	397	0.375314861460957	0.35484096685755	0.35484096685755	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	48211317124.00	—	—	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-25T19:44:21.808017Z"}	2026-09-25	2026-09-25 21:15	2026-09-25 21:15
e32b6a02-c419-4b8d-b3ff-486868f40cf6	2026-09-25 15:35	2026-09-25 15:35	2026-09-25 15:35	SOXX	SOXX261002P00575000	put	575.0000	2026-10-02	12.4000	11.4000	12.4000	571.9200	24800.00	24800.00	0.00	20	9	87	0	0	0.348340117801757	0.348340117801757	false	false	false	true
f75bc270-4c6e-4f95-950a-4645f50790ae	2026-09-25 15:30	2026-09-25 15:30	2026-09-25 15:30	SOXX	SOXX261016C00600000	call	600.0000	2026-10-16	9.5700	9.5000	10.0000	573.0050	37335.00	0.00	37335.00	39	11	1398	9885	0.141426403641882	0.353917242171922	0.353917242171922	false	false	false
a42ea2a0-cf42-42bc-8f1e-355af54465bb	2026-09-25 15:02	2026-09-25 15:01	2026-09-25 15:01	SOXX	SOXX261002C00560000	call	560.0000	2026-10-02	18.8000	18.8000	20.5000	572.0000	13160.00	0.00	13160.00	7	5	47	280	0.167857142857143	0.350877578348098	0.352612835125711	false	false	false	true
45bc11b3-567f-4a66-b87b-e3c69400af95	2026-09-25 13:52	2026-09-25 13:52	2026-09-25 13:52	SOXX	SOXX261002P00570000	put	570.0000	2026-10-02	9.2000	9.2000	9.7000	573.8200	11040.00	0.00	11040.00	12	7	125	68	1.83823529411765	0.354657912414241	0.354657912414241	false	false	false	true
35982616-9474-4cbe-90d9-3b090c2ecf1d	2026-09-25 12:50	2026-09-25 12:50	2026-09-25 12:50	SOXX	SOXX270319P00545000	put	545.0000	2027-03-19	47.3000	47.2000	47.3000	574.1805	52030.00	52030.00	0.00	11	6	54	50	1.08	0.429986537228682	0.429986537228682	false	false	false	true
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
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
6a335e3a-6552-4f67-9324-3aec03aaa599	2026-09-25 12:10	2026-09-25 12:10	2026-09-25 12:10	SOXX	SOXX270319P00610000	put	610.0000	2027-03-19	78.7000	77.1000	81.8000	575.0000	102311.00	0.00	102311.00	13	7	25	135	0.185185185185185	0.415483292605939	0.415483292605939	false	false	false	true
c4c16709-6b36-4d73-8d41-57667d34ed88	2026-09-25 11:51	2026-09-25 11:51	2026-09-25 11:51	SOXX	SOXX261016C00600000	call	600.0000	2026-10-16	8.8500	8.8000	9.4000	569.2150	176970.00	0.00	176970.00	200	15	762	9885	0.0770864946889226	0.362300824557386	0.362300824557386	false	false	false
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
057808cc-636f-4e84-a3cc-911b32db8a87	2026-09-25 11:06	2026-09-25 11:06	2026-09-25 11:06	SOXX	SOXX261016C00600000	call	600.0000	2026-10-16	9.8900	9.5000	10.1000	572.8600	15818.00	15818.00	0.00	16	6	276	9885	0.0279210925644917	0.361171144425915	0.361171144425915	false	false	false
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
d7e3beb4-fab5-43c6-ad75-bef0ce2bcd6f	2026-09-25 10:08	2026-09-25 10:08	2026-09-25 10:08	SOXX	SOXX261002P00565000	put	565.0000	2026-10-02	8.4000	7.8000	9.0000	571.0000	20997.00	10955.00	9202.00	25	10	32	68	0.470588235294118	0.366361033120559	0.366361033120559	false	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
9e36f96d-e62f-42a6-bf79-ac81082c856d	2026-09-25 10:02	2026-09-25 10:02	2026-09-25 10:02	SOXX	SOXX261009C00580000	call	580.0000	2026-10-09	12.6000	12.5000	14.5000	572.0000	15126.00	0.00	15126.00	12	7	18	64	0.28125	0.349174679203423	0.349174679203423	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
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
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
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	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
3121f9cd-b8f5-4b5d-bb8f-d67f3b9c8e60	2026-09-24 15:09	2026-09-24 15:09	2026-09-24 15:09	SOXX	SOXX261016P00475000	put	475.0000	2026-10-16	1.5300	1.5000	1.7000	564.1150	58019.00	0.00	58019.00	379	15	446	2492	0.178972712680578	0.460287076920727	0.457007835484485	true	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
1a514179-dc95-4e26-b683-28b7015ff82e	2026-09-24 14:39	2026-09-24 14:39	2026-09-24 14:39	SOXX	SOXX261023C00490000	call	490.0000	2026-10-23	79.6300	75.0000	79.7000	564.2800	175190.00	175190.00	0.00	22	6	24	1	24	0.43799098067613	0.43799098067613	false	false	false	true
83a84223-b227-4ef5-bd77-6d547261b64d	2026-09-24 14:08	2026-09-24 14:08	2026-09-24 14:08	SOXX	SOXX271217C00580000	call	580.0000	2027-12-17	110.0000	104.5000	112.0000	560.1600	2200000.00	2200000.00	0.00	200	4	300	27	11.1111111111111	0.424550490575147	0.424550490575147	false	true	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	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
3448ddec-6af1-4eef-96b3-132cb3d60bba	2026-09-24 13:05	2026-09-24 13:05	2026-09-24 13:05	SOXX	SOXX261218C00640000	call	640.0000	2026-12-18	19.6600	18.6000	19.7000	566.5750	196625.00	196625.00	0.00	100	17	1609	61	26.3770491803279	0.392466841601801	0.396092100764144	false	false	false
8163f95f-7d7d-48cf-ab7d-b40478d1f980	2026-09-24 13:04	2026-09-24 13:03	2026-09-24 13:03	SOXX	SOXX261218C00640000	call	640.0000	2026-12-18	19.5400	18.6000	19.6000	566.1450	195449.00	195449.00	0.00	100	8	1509	61	24.7377049180328	0.393431725223227	0.396442029094104	false	false	false
ec48f8c3-fa4a-4f6e-87d7-208590e0de18	2026-09-24 13:03	2026-09-24 13:03	2026-09-24 13:03	SOXX	SOXX261218C00640000	call	640.0000	2026-12-18	19.4500	18.6000	19.7000	566.2100	352103.00	344451.00	7652.00	181	18	1409	61	23.0983606557377	0.391351145276531	0.391351145276531	false	false	false
a7bdca0c-971b-4921-b617-d758840099c9	2026-09-24 13:02	2026-09-24 13:02	2026-09-24 13:02	SOXX	SOXX261218C00640000	call	640.0000	2026-12-18	18.8300	18.6000	19.8000	564.7500	16947.00	0.00	16947.00	9	7	1228	61	20.1311475409836	0.392250791448991	0.392250791448991	false	false	false
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
b932a796-8466-41b8-9502-0052848f2f96	2026-09-24 12:59	2026-09-24 12:58	2026-09-24 12:58	SOXX	SOXX261218C00640000	call	640.0000	2026-12-18	19.0500	18.6000	19.4000	565.0000	190479.00	175309.00	11370.00	100	11	1219	61	19.983606557377	0.393698925852234	0.393698925852234	false	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	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