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.

566,287 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts566,287 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

c8b048d3-e5a1-4d00-9636-77374289c882	2026-09-21 15:59	2026-09-21 15:59	2026-09-21 15:59	SOXX	SOXX261016C00575000	call	575.0000	2026-10-16	15.9000	15.9000	17.3000	559.0000	25440.00	0.00	25440.00	16	8	477	582	0.819587628865979	0.374307299478941	0.374307299478941	true	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	45373849185.00	—	—	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500}	2026-09-21	2026-09-21 21:15	2026-09-21 21:15
cee23d2d-1675-455b-88b5-01b790ba22c3	2026-09-21 15:49	2026-09-21 15:49	2026-09-21 15:49	SOXX	SOXX261009C00530000	call	530.0000	2026-10-09	38.5000	38.5000	39.3000	560.0000	481250.00	0.00	481250.00	125	15	231	242	0.954545454545455	0.384873755935636	0.384873755935636	false	false	false	true
d228b9a8-f47e-4af7-a942-9357eab8b9ad	2026-09-21 15:45	2026-09-21 15:45	2026-09-21 15:45	SOXX	SOXX261030P00525000	put	525.0000	2026-10-30	13.7000	13.2000	13.9000	561.2500	34250.00	2740.00	31510.00	25	10	31	5	6.2	0.410611740085962	0.410611740085962	false	false	false	true
ffbd2c5f-70e8-46da-ac22-23b80f8917fb	2026-09-21 15:38	2026-09-21 15:37	2026-09-21 15:37	SOXX	SOXX261016C00545000	call	545.0000	2026-10-16	32.3000	30.4000	32.3000	561.4300	206720.00	206720.00	0.00	64	5	164	72	2.27777777777778	0.385152295542779	0.385152295542779	false	false	false	true
d6d3a4a2-1246-4ba4-8d36-c6b9ba21e9a6	2026-09-21 15:15	2026-09-21 15:15	2026-09-21 15:15	SOXX	SOXX261002C00540000	call	540.0000	2026-10-02	27.0000	25.7000	27.0000	559.8100	45900.00	45900.00	0.00	17	5	32	146	0.219178082191781	0.382131798343404	0.382131798343404	true	false	false	true
03e503bc-2825-4de3-8b07-051fdf38966f	2026-09-21 15:04	2026-09-21 15:04	2026-09-21 15:04	SOXX	SOXX261002C00565000	call	565.0000	2026-10-02	11.2000	11.1500	11.8000	558.0000	44800.00	0.00	44800.00	40	10	68	13	5.23076923076923	0.360479283417211	0.360479283417211	true	false	false	true
b112b206-b2b7-4695-a3d2-82ab884826f4	2026-09-21 14:22	2026-09-21 14:22	2026-09-21 14:22	SOXX	SOXX260925C00565000	call	565.0000	2026-09-25	5.3000	4.4000	5.3000	557.9200	16960.00	16960.00	0.00	32	14	172	166	1.03614457831325	0.352868737813754	0.352868737813754	true	false	false	true
b882ddc7-5273-475d-918a-4878342e13d9	2026-09-21 14:12	2026-09-21 14:12	2026-09-21 14:12	SOXX	SOXX261016C00560000	call	560.0000	2026-10-16	20.9000	20.4000	20.9000	556.9600	73150.00	73150.00	0.00	35	15	112	609	0.183908045977011	0.371966403923321	0.371966403923321	true	false	false	true
96630740-3810-4de1-97da-4a014ca447c6	2026-09-21 14:05	2026-09-21 14:04	2026-09-21 14:04	SOXX	SOXX260925C00555000	call	555.0000	2026-09-25	9.3800	8.7000	9.4000	556.0000	24390.00	24390.00	0.00	26	7	221	195	1.13333333333333	0.35718019050623	0.35284850877185	false	false	false	true
7ee10fbd-76d9-43ee-bd4c-728afc2fb0cc	2026-09-21 13:48	2026-09-21 13:48	2026-09-21 13:48	SOXX	SOXX261023P00510000	put	510.0000	2026-10-23	8.3000	7.8000	8.5000	556.2800	14940.00	4980.00	9960.00	18	5	2963	59	50.2203389830508	0.405166020590089	0.405166020590089	false	false	false	true
8dfd5d93-4e72-4504-b5db-ae8058f80177	2026-09-21 13:40	2026-09-21 13:40	2026-09-21 13:40	SOXX	SOXX261016P00550000	put	550.0000	2026-10-16	18.2000	18.2000	18.6000	555.6800	27300.00	0.00	27300.00	15	5	131	538	0.243494423791822	0.374831609155252	0.374831609155252	false	false	false	true
fa81d362-5f68-4de0-9eb7-48ccafde39a5	2026-09-21 13:37	2026-09-21 13:37	2026-09-21 13:37	SOXX	SOXX270319P00540000	put	540.0000	2027-03-19	49.3000	49.2000	50.0000	555.0000	547229.00	537369.00	9860.00	111	24	111	538	0.20631970260223	0.409172260292439	0.408866535354463	false	false	false	true
b09f7172-dd6d-4d3d-b7d2-03f44e18bf84	2026-09-21 13:37	2026-09-21 13:37	2026-09-21 13:37	SOXX	SOXX270319P00575000	put	575.0000	2027-03-19	66.7000	66.6000	66.7000	555.0000	80040.00	80040.00	0.00	12	5	12	43	0.27906976744186	0.403650791325515	0.403650791325515	false	false	false	true
89b5b4d9-7f62-43be-82ac-13108d162497	2026-09-21 13:37	2026-09-21 13:37	2026-09-21 13:37	SOXX	SOXX270219P00550000	put	550.0000	2027-02-19	49.4000	47.7000	49.4000	555.0000	429780.00	429780.00	0.00	87	9	89	23	3.8695652173913	0.404259037718099	0.404259037718099	false	false	false	true
0096c680-3fe6-469d-8626-bad7b642bc21	2026-09-21 13:24	2026-09-21 13:24	2026-09-21 13:24	SOXX	SOXX261016C00520000	call	520.0000	2026-10-16	44.7000	44.6000	45.8000	554.0000	89400.00	0.00	89400.00	20	11	62	488	0.127049180327869	0.391556382924922	0.391556382924922	false	false	false	true
170db7e2-cfa4-4224-b6a4-2fec51ba6d36	2026-09-21 13:24	2026-09-21 13:24	2026-09-21 13:24	SOXX	SOXX261016C00520000	call	520.0000	2026-10-16	44.7000	44.7000	45.8000	554.0000	53642.00	0.00	53642.00	12	6	42	488	0.0860655737704918	0.392571074649368	0.392571074649368	false	false	false	true
f44232aa-3704-40a2-9cd2-2f94352d0e1a	2026-09-21 13:24	2026-09-21 13:24	2026-09-21 13:24	SOXX	SOXX261002C00530000	call	530.0000	2026-10-02	30.8000	30.8000	32.8000	555.0000	86240.00	0.00	86240.00	28	7	50	105	0.476190476190476	0.385643203896359	0.386959848039612	true	false	false	true
ee1654d1-3947-493e-bc7c-66561bd03dcd	2026-09-21 13:24	2026-09-21 13:24	2026-09-21 13:24	SOXX	SOXX260925C00542500	call	542.5000	2026-09-25	16.5000	16.5000	18.5000	555.0000	18150.00	0.00	18150.00	11	6	167	159	1.05031446540881	0.375013699309152	0.375013699309152	false	false	false	true
62f7ff87-328a-4320-9cb2-560d22d78732	2026-09-21 13:23	2026-09-21 13:23	2026-09-21 13:23	SOXX	SOXX261002P00555000	put	555.0000	2026-10-02	13.5000	12.5000	13.5000	555.0000	40500.00	40500.00	0.00	30	7	43	4	10.75	0.366398096209309	0.366398096209309	false	false	false	true
86d6177b-faae-44ef-8b1b-798fd4985d92	2026-09-21 13:10	2026-09-21 13:10	2026-09-21 13:10	SOXX	SOXX260925P00555000	put	555.0000	2026-09-25	7.7000	7.1000	7.7000	556.0400	13860.00	13860.00	0.00	18	8	73	2	36.5	0.358931672646098	0.358931672646098	false	false	false	true
2ac76f4f-cf4d-4dc0-b35b-1cc86e9e87dd	2026-09-21 13:07	2026-09-21 13:07	2026-09-21 13:07	SOXX	SOXX261218C00580000	call	580.0000	2026-12-18	35.2500	35.2000	35.8000	556.5797	437100.00	218860.00	218240.00	124	12	4437	11716	0.378712871287129	0.393035548078049	0.39395469914416	false	false	false	true
545ce675-b246-431d-a6ff-858229c8e3b7	2026-09-21 13:05	2026-09-21 13:05	2026-09-21 13:05	SOXX	SOXX261218C00580000	call	580.0000	2026-12-18	35.2000	35.2000	35.6000	556.9000	316800.00	0.00	316800.00	90	6	2898	11716	0.247354045749403	0.391639498832846	0.391639498832846	false	false	false	true
d58ec600-8105-4c05-967a-939a9689ddd7	2026-09-21 13:03	2026-09-21 13:03	2026-09-21 13:03	SOXX	SOXX261218C00580000	call	580.0000	2026-12-18	35.2000	35.2000	35.6000	556.9000	24640.00	0.00	24640.00	7	5	1910	11716	0.163024923181973	0.391639498832846	0.391639498832846	false	false	false	true
b48bc6e8-87d8-4c06-af78-8e12596adf0b	2026-09-21 13:02	2026-09-21 13:02	2026-09-21 13:02	SOXX	SOXX261218C00580000	call	580.0000	2026-12-18	35.2500	35.2000	35.9000	556.9800	52870.00	24710.00	28160.00	15	5	1666	11716	0.142198702628884	0.391290588126925	0.392208926982482	false	false	false	true
7a35c631-d5d7-4209-b365-551983d2f70a	2026-09-21 12:33	2026-09-21 12:33	2026-09-21 12:33	SOXX	SOXX270617P00470000	put	470.0000	2027-06-17	34.0000	34.0000	34.8000	556.8300	680000.00	0.00	680000.00	200	5	500	118	4.23728813559322	0.431547835971171	0.431547835971171	false	false	false	true
2bed678b-201b-4ac2-bb7d-4e381c2de437	2026-09-21 12:18	2026-09-21 12:18	2026-09-21 12:18	SOXX	SOXX261002C00525000	call	525.0000	2026-10-02	35.0000	33.9000	36.6000	555.0000	17500.00	0.00	17500.00	5	5	33	88	0.375	0.395148205889607	0.395148205889607	false	false	false	true
df1d458a-1735-43c6-afde-8c5fcd234e93	2026-09-21 12:17	2026-09-21 12:17	2026-09-21 12:17	SOXX	SOXX261002C00535000	call	535.0000	2026-10-02	27.3000	26.9000	28.6000	555.0000	16380.00	0.00	16380.00	6	6	12	40	0.3	0.381967224140329	0.381967224140329	false	false	false	true
6b30350b-0001-4e46-822e-3784001038fe	2026-09-21 12:10	2026-09-21 12:09	2026-09-21 12:09	SOXX	SOXX270617P00470000	put	470.0000	2027-06-17	34.4000	34.0000	37.4000	555.4300	344000.00	0.00	282080.00	100	5	300	118	2.54237288135593	0.432048463592984	0.432048463592984	false	false	false	true
836e7c6f-ada3-403c-9f08-c91e21b2b943	2026-09-21 12:04	2026-09-21 12:04	2026-09-21 12:04	SOXX	SOXX261016P00532500	put	532.5000	2026-10-16	11.9000	11.9000	13.2000	554.9248	35700.00	0.00	35700.00	30	14	107	0	0	0.384519143412965	0.384519143412965	true	false	false	true
67e122e6-e82f-4cb5-b6ab-6f22c28f3563	2026-09-21 11:34	2026-09-21 11:34	2026-09-21 11:34	SOXX	SOXX261023P00510000	put	510.0000	2026-10-23	8.5000	8.5000	8.9000	556.0000	2428450.00	0.00	2428450.00	2857	33	2926	59	49.5932203389831	0.408219792865625	0.408219792865625	false	false	false	true
7f05f01c-442e-4ea6-9a65-335fce399ed5	2026-09-21 11:32	2026-09-21 11:32	2026-09-21 11:32	SOXX	SOXX270115P00460000	put	460.0000	2027-01-15	14.2000	14.2000	14.3000	555.0000	11360.00	0.00	11360.00	8	5	84	1664	0.0504807692307692	0.437029575875636	0.437029575875636	false	false	false	true
e4b707bf-6bac-4fce-8793-be3975799458	2026-09-21 11:12	2026-09-21 11:12	2026-09-21 11:12	SOXX	SOXX261016P00525000	put	525.0000	2026-10-16	9.9000	9.8000	9.9000	555.0000	22770.00	11880.00	0.00	23	6	342	1294	0.264296754250386	0.395210175018033	0.395210175018033	false	false	false	true
92a135e6-8499-46f5-98aa-4824560bd736	2026-09-21 11:12	2026-09-21 11:12	2026-09-21 11:12	SOXX	SOXX261016P00525000	put	525.0000	2026-10-16	9.9000	9.8000	9.9000	555.0000	44550.00	990.00	0.00	45	6	319	1294	0.246522411128284	0.39498629711864	0.39498629711864	false	false	false	true
f89cf2bc-b24d-4afa-85b7-e1908c0f44d0	2026-09-21 11:12	2026-09-21 11:12	2026-09-21 11:12	SOXX	SOXX261016P00525000	put	525.0000	2026-10-16	9.9000	9.6000	10.1000	555.0000	110880.00	83160.00	26730.00	112	6	274	1294	0.211746522411128	0.394706349326396	0.394706349326396	false	false	false	true
edcc548d-72ea-4039-95ba-8f50ca30d7a5	2026-09-21 11:10	2026-09-21 11:10	2026-09-21 11:10	SOXX	SOXX261016P00525000	put	525.0000	2026-10-16	10.1000	10.0500	10.4000	554.0000	26260.00	5050.00	3030.00	26	5	113	1294	0.0873261205564142	0.394566345468181	0.394566345468181	false	false	false	true
8609c19b-f49d-45a2-afd6-7b1ae8838110	2026-09-21 11:10	2026-09-21 11:10	2026-09-21 11:10	SOXX	SOXX261016P00525000	put	525.0000	2026-10-16	10.1000	10.1000	10.4000	554.0000	50500.00	0.00	50500.00	50	6	87	1294	0.0672333848531685	0.394368456008169	0.394368456008169	false	false	false	true
74edea65-906c-4df9-836b-cfb462610afb	2026-09-21 11:09	2026-09-21 11:09	2026-09-21 11:09	SOXX	SOXX261016P00525000	put	525.0000	2026-10-16	10.1000	9.8000	11.4000	554.0000	29290.00	0.00	29290.00	29	7	37	1294	0.0285935085007728	0.395611401436304	0.395611401436304	false	false	false	true
8733d1c2-1d27-42b3-9a37-d051c3a9df59	2026-09-21 10:40	2026-09-21 10:40	2026-09-21 10:40	SOXX	SOXX260925C00560000	call	560.0000	2026-09-25	4.9000	4.9000	5.5000	551.4250	121520.00	0.00	121520.00	248	26	320	129	2.48062015503876	0.362819408447817	0.362819408447817	true	false	false	true
fa64b8d7-e3c3-4f7e-8d78-daa4bccf5e08	2026-09-21 10:34	2026-09-21 10:34	2026-09-21 10:34	SOXX	SOXX261016C00535000	call	535.0000	2026-10-16	31.8000	31.8000	32.6000	551.3499	63600.00	0.00	63600.00	20	5	21	710	0.0295774647887324	0.384214368718829	0.384214368718829	false	false	false	true
af9a1744-fc68-4453-aa4a-2d94435704e7	2026-09-21 10:34	2026-09-21 10:34	2026-09-21 10:34	SOXX	SOXX261016C00535000	call	535.0000	2026-10-16	31.9000	31.9000	32.6000	551.3499	660330.00	0.00	609290.00	207	5	228	710	0.32112676056338	0.386078782485537	0.386078782485537	false	false	false	true
ee01b1df-af6b-4051-8f94-c13cfa134396	2026-09-21 10:28	2026-09-21 10:27	2026-09-21 10:27	SOXX	SOXX261016C00625000	call	625.0000	2026-10-16	3.1000	1.7000	3.1000	551.3600	13640.00	13640.00	0.00	44	7	44	69	0.63768115942029	0.38168984497391	0.38168984497391	true	false	false	true
e11c01e4-9a3c-4199-81e3-cddda045b875	2026-09-21 10:28	2026-09-21 10:27	2026-09-21 10:27	SOXX	SOXX261016C00635000	call	635.0000	2026-10-16	2.3000	1.0000	2.4000	551.3600	56580.00	54970.00	1610.00	246	21	246	35	7.02857142857143	0.384773354860767	0.384773354860767	true	false	false	true
314e3ccc-33c0-42cb-b5f4-7c2b8610057f	2026-09-21 10:28	2026-09-21 10:27	2026-09-21 10:27	SOXX	SOXX261016C00650000	call	650.0000	2026-10-16	1.5500	0.4000	1.5500	551.3600	24180.00	24180.00	0.00	156	11	198	4077	0.0485651214128035	0.394735405266003	0.394735405266003	true	false	false	true
9c931fd8-52ba-49f1-b8c1-7a8738de5aec	2026-09-21 10:26	2026-09-21 10:26	2026-09-21 10:26	SOXX	SOXX261016C00600000	call	600.0000	2026-10-16	6.2000	5.9000	6.2000	550.4100	49600.00	49600.00	0.00	80	6	2324	9087	0.25574997248817	0.375597302855602	0.375597302855602	false	false	false	true
638e4f1c-eba0-4aaf-929d-5639776b26ce	2026-09-21 10:18	2026-09-21 10:17	2026-09-21 10:17	SOXX	SOXX261016C00600000	call	600.0000	2026-10-16	5.8300	5.6000	5.9000	549.6100	13417.00	13417.00	0.00	23	6	852	9087	0.0937603169362826	0.37065388126389	0.37065388126389	false	false	false	true
ae320141-dca7-4ae4-aedc-a61cfdd44503	2026-09-21 10:18	2026-09-21 10:17	2026-09-21 10:17	SOXX	SOXX261120P00580000	put	580.0000	2026-11-20	51.1000	49.3000	53.8000	549.7000	40880.00	35770.00	5110.00	8	6	8	50	0.16	0.400119753264842	0.400119753264842	false	false	false	true
954d0aa5-6642-4857-91b2-f1288f5cdd9a	2026-09-21 10:17	2026-09-21 10:17	2026-09-21 10:17	SOXX	SOXX261016C00560000	call	560.0000	2026-10-16	17.3000	17.2000	17.7000	549.7850	13840.00	6920.00	6920.00	8	5	40	609	0.0656814449917898	0.369453057013275	0.369453057013275	false	false	false	true
ef3585a8-76bd-4582-81d2-aca6324ddd2e	2026-09-21 10:04	2026-09-21 10:04	2026-09-21 10:04	SOXX	SOXX261002C00542500	call	542.5000	2026-10-02	17.6000	17.0000	18.2000	548.5500	246400.00	123200.00	36960.00	140	5	141	2802	0.0503211991434689	0.370746878708205	0.370746878708205	false	false	false	true
fdae1ace-0a74-4f63-8696-96c7e9a74a70	2026-09-18 15:46	2026-09-18 15:46	2026-09-18 15:46	SOXX	SOXX260918C00525000	call	525.0000	2026-09-18	2.4500	2.4500	2.9000	527.1250	15925.00	0.00	15925.00	65	6	217	915	0.237158469945355	1.01575960194584	1.01575960194584	false	false	false	true
6d7b5e7b-2163-4c9d-942d-096712beb3bf	2026-09-18 15:14	2026-09-18 15:14	2026-09-18 15:14	SOXX	SOXX260918P00550000	put	550.0000	2026-09-18	23.3100	23.3000	28.0000	525.6400	23310.00	0.00	20970.00	10	5	10	66	0.151515151515152	6.09414724955158	1.27186163806354	false	false	false	true