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.

326,449 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts326,449 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

ccff98de-6c78-41c4-be96-c36dbef82572	2026-09-22 15:56	2026-09-22 15:56	2026-09-22 15:56	SOXX	SOXX261120C00575000	call	575.0000	2026-11-20	38.1000	36.6000	39.6000	572.6900	217170.00	45720.00	171450.00	57	5	75	62	1.20967741935484	0.407611120408342	0.407611120408342	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	48453532778.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-22T19:58:44.027893Z"}	2026-09-22	2026-09-22 21:15	2026-09-22 21:15
509d2bf1-80df-4cb2-9fc1-a3a820585259	2026-09-22 15:15	2026-09-22 15:15	2026-09-22 15:15	SOXX	SOXX261002C00560000	call	560.0000	2026-10-02	20.0000	19.7000	20.2000	570.6112	56000.00	52000.00	4000.00	28	5	142	312	0.455128205128205	0.366315706972381	0.366315706972381	false	false	false	true
99dfed01-e6fc-431a-a673-6de0c7cd9542	2026-09-22 15:04	2026-09-22 15:04	2026-09-22 15:04	SOXX	SOXX261030P00515000	put	515.0000	2026-10-30	8.9000	8.7000	8.9000	570.0500	13350.00	13350.00	0.00	15	5	285	110	2.59090909090909	0.416165504937329	0.416165504937329	true	false	false	true
f7803e06-8077-4af5-90ff-6194ba132e83	2026-09-22 14:51	2026-09-22 14:51	2026-09-22 14:51	SOXX	SOXX261218C00580000	call	580.0000	2026-12-18	41.8000	41.3000	41.8000	569.1200	20900.00	20900.00	0.00	5	5	44	9021	0.00487750803680302	0.398699050450394	0.398699050450394	false	false	false	true
e280c7b1-5e01-4794-aa38-2996746daa86	2026-09-22 14:23	2026-09-22 14:23	2026-09-22 14:23	SOXX	SOXX260925P00555000	put	555.0000	2026-09-25	2.2000	1.6500	2.5000	569.8700	83160.00	82940.00	220.00	378	7	435	60	7.25	0.364877512310265	0.364877512310265	false	false	false	true
58d07cb5-0c35-4980-b232-9d65b2644ba1	2026-09-22 14:07	2026-09-22 14:07	2026-09-22 14:07	SOXX	SOXX261016C00600000	call	600.0000	2026-10-16	9.9000	9.9000	10.5000	568.6700	13860.00	0.00	13860.00	14	6	957	13585	0.0704453441295547	0.362030698002761	0.362030698002761	false	false	false	true
672a7007-7b27-4d89-a87b-1d6c69a4fa25	2026-09-22 13:53	2026-09-22 13:53	2026-09-22 13:53	SOXX	SOXX261009C00595000	call	595.0000	2026-10-09	8.1000	6.9000	8.1000	569.0800	17010.00	17010.00	0.00	21	5	40	71	0.563380281690141	0.356284562421403	0.356284562421403	false	false	false	true
db809386-3e4f-4fdf-ac7e-2f177293c14b	2026-09-22 13:52	2026-09-22 13:52	2026-09-22 13:52	SOXX	SOXX261218C00570000	call	570.0000	2026-12-18	46.3000	44.9000	46.3000	568.1100	564860.00	564860.00	0.00	122	17	145	48	3.02083333333333	0.403402134089571	0.403251030854156	false	false	false	true
b086d3a4-6a15-437a-be19-dc2f3bcef3fa	2026-09-22 13:52	2026-09-22 13:52	2026-09-22 13:52	SOXX	SOXX261218C00545000	call	545.0000	2026-12-18	60.1000	57.0000	60.1000	568.1100	811350.00	811350.00	0.00	135	16	135	10	13.5	0.412575505997587	0.412390873203116	false	false	false	true
262bd0e4-64de-4711-88a9-4f1ea1e860c6	2026-09-22 13:35	2026-09-22 13:34	2026-09-22 13:34	SOXX	SOXX261016C00600000	call	600.0000	2026-10-16	9.5000	9.4000	9.5000	567.0000	349600.00	318250.00	0.00	368	8	788	13585	0.0580051527419948	0.361793822362166	0.361793822362166	false	false	false	true
5b64a7bd-65af-4fcd-af82-2fbeaf5f1d6a	2026-09-22 13:34	2026-09-22 13:34	2026-09-22 13:34	SOXX	SOXX261016C00600000	call	600.0000	2026-10-16	9.6000	9.4000	9.6000	567.0000	69120.00	24000.00	0.00	72	5	420	13585	0.0309164519690835	0.364009693282064	0.364009693282064	false	false	false	true
84a3cda0-4b87-469a-b9b8-39276c1ea8e5	2026-09-22 13:21	2026-09-22 13:21	2026-09-22 13:21	SOXX	SOXX261030C00570000	call	570.0000	2026-10-30	28.0000	28.0000	29.5000	567.2800	67200.00	0.00	67200.00	24	6	32	13	2.46153846153846	0.385593227450704	0.385593227450704	true	false	false	true
96d7ef1e-a6a7-4cab-a08a-e3b2c2dabb21	2026-09-22 13:21	2026-09-22 13:21	2026-09-22 13:21	SOXX	SOXX270319P00450000	put	450.0000	2027-03-19	18.2500	17.6000	18.4000	567.3750	273750.00	273750.00	0.00	150	2	177	768	0.23046875	0.445699702638363	0.445699702638363	false	true	false	true
e03e40ef-283b-4abb-a18e-7110a03dd09c	2026-09-22 13:15	2026-09-22 13:15	2026-09-22 13:15	SOXX	SOXX290119C00540000	call	540.0000	2029-01-19	179.9000	174.0000	181.7000	567.7000	719600.00	449750.00	269850.00	40	6	40	0	0	0.425529823431917	0.425529823431917	false	false	false	true
574295d3-478e-4633-ae11-574c06a61fc2	2026-09-22 12:28	2026-09-22 12:28	2026-09-22 12:28	SOXX	SOXX261002P00555000	put	555.0000	2026-10-02	8.4300	7.7000	9.4000	565.8400	15180.00	13480.00	1700.00	18	7	21	38	0.552631578947368	0.363818860052184	0.360952302688837	true	false	false	true
900e7992-ae47-4a76-a57b-c187fea544ef	2026-09-22 12:06	2026-09-22 12:06	2026-09-22 12:06	SOXX	SOXX261023C00610000	call	610.0000	2026-10-23	10.1000	8.7000	11.6000	567.3900	36360.00	1010.00	35350.00	36	6	37	8	4.625	0.371655418488668	0.371655418488668	false	false	false	true
2ec20968-6e6d-4f5f-86ac-db5a9727da03	2026-09-22 11:18	2026-09-22 11:17	2026-09-22 11:17	SOXX	SOXX261002C00565000	call	565.0000	2026-10-02	14.3000	14.0000	14.8000	565.5400	114385.00	85800.00	28585.00	80	5	191	61	3.13114754098361	0.367007945745675	0.367713356668871	false	false	false	true
8507edd0-4130-4ed6-8b4a-c61b70d20353	2026-09-22 10:42	2026-09-22 10:42	2026-09-22 10:42	SOXX	SOXX261030C00520000	call	520.0000	2026-10-30	58.2000	58.2000	62.0000	564.2750	58200.00	0.00	58200.00	10	8	15	19	0.789473684210526	0.420833906512805	0.420833906512805	true	false	false	true
c41565f1-ea2d-4697-9ec2-706ba56ef361	2026-09-22 10:41	2026-09-22 10:41	2026-09-22 10:41	SOXX	SOXX261002C00552500	call	552.5000	2026-10-02	21.7000	21.7000	24.0000	565.1600	106330.00	0.00	106330.00	49	13	49	8	6.125	0.382086507635758	0.382086507635758	false	false	false	true
05c57500-ee0b-4a44-b076-80d4ff616506	2026-09-22 10:40	2026-09-22 10:39	2026-09-22 10:39	SOXX	SOXX260925C00555000	call	555.0000	2026-09-25	14.6000	14.6000	16.7000	565.7900	24820.00	0.00	24820.00	17	6	51	210	0.242857142857143	0.38718198223906	0.39173070782358	false	false	false	true
fcc80410-9ada-451a-825f-a6dd3863ad8e	2026-09-22 10:35	2026-09-22 10:35	2026-09-22 10:35	SOXX	SOXX260925C00570000	call	570.0000	2026-09-25	6.7000	6.6000	7.4000	567.1500	36180.00	670.00	35510.00	54	10	115	112	1.02678571428571	0.387231883951774	0.387231883951774	true	false	false	true
1d3fc516-d7c1-4ec9-833a-b0ad3f170204	2026-09-22 10:32	2026-09-22 10:32	2026-09-22 10:32	SOXX	SOXX260925C00500000	call	500.0000	2026-09-25	68.2000	64.4000	69.4000	567.8200	34100.00	6820.00	27280.00	5	5	5	53	0.0943396226415094	0.673580963762296	0.673580963762296	false	false	false	true
5752f54b-e147-420e-9666-8d9c0c042c6d	2026-09-22 10:15	2026-09-22 10:15	2026-09-22 10:15	SOXX	SOXX261030P00560000	put	560.0000	2026-10-30	25.4000	24.7000	25.4000	564.9750	276860.00	276860.00	0.00	109	5	109	1	109	0.400709225576608	0.400709225576608	false	false	false	true
9bb680d0-41d9-465f-aa88-507a07ba573d	2026-09-22 10:15	2026-09-22 10:15	2026-09-22 10:15	SOXX	SOXX261009C00550000	call	550.0000	2026-10-09	27.2000	27.2000	28.3000	565.0499	73440.00	0.00	73440.00	27	16	182	50	3.64	0.376337459020287	0.376337459020287	true	false	false	true
fc5cd7ee-6cf5-4da4-9219-68fc67f1683d	2026-09-22 10:10	2026-09-22 10:10	2026-09-22 10:10	SOXX	SOXX260925C00555000	call	555.0000	2026-09-25	13.6800	12.0000	13.8000	564.3700	21885.00	21885.00	0.00	16	5	17	210	0.080952380952381	0.397187872607577	0.394421037792469	false	false	false	true
aa099924-8b30-44d1-a7c7-5addeb344de0	2026-09-22 09:56	2026-09-22 09:56	2026-09-22 09:56	SOXX	SOXX260925C00560000	call	560.0000	2026-09-25	9.2000	9.1000	9.2000	562.3850	202400.00	202400.00	0.00	220	5	382	354	1.07909604519774	0.3868194378688	0.3868194378688	false	false	false	true
3e0b768c-ba4f-430b-a5c8-f589952f411f	2026-09-22 09:44	2026-09-22 09:44	2026-09-22 09:44	SOXX	SOXX261218C00600000	call	600.0000	2026-12-18	29.5000	27.6000	29.5000	561.0000	56050.00	56050.00	0.00	19	5	19	2279	0.00833698990785432	0.392517970755078	0.392517970755078	false	false	false	true
23a80286-4a61-4147-b74a-3bd062b3d2fc	2026-09-22 09:35	2026-09-22 09:35	2026-09-22 09:35	SOXX	SOXX261002C00505000	call	505.0000	2026-10-02	57.6000	53.3000	57.6000	560.8500	120960.00	120960.00	0.00	21	5	30	185	0.162162162162162	0.435564365112207	0.435564365112207	false	false	false	true
1226ae93-dae2-4b87-9ec7-884f7552df27	2026-09-22 09:35	2026-09-22 09:35	2026-09-22 09:35	SOXX	SOXX261009C00575000	call	575.0000	2026-10-09	11.5000	9.7000	11.5000	560.3300	24150.00	24150.00	0.00	21	5	21	24	0.875	0.359198862612982	0.35784806793986	true	false	false	true
3343a81c-b445-4c22-ba7e-fd4d455948e1	2026-09-22 09:35	2026-09-22 09:35	2026-09-22 09:35	SOXX	SOXX260925C00567500	call	567.5000	2026-09-25	4.8000	3.4000	4.8000	560.1900	88800.00	88800.00	0.00	185	15	185	22	8.40909090909091	0.385206623964745	0.385206623964745	true	false	false	true
0cc85051-1d57-4dd5-a58d-6154a9bad86b	2026-09-22 09:35	2026-09-22 09:35	2026-09-22 09:35	SOXX	SOXX260925C00560000	call	560.0000	2026-09-25	7.9000	6.3000	7.9000	560.0000	109020.00	109020.00	0.00	138	16	149	354	0.42090395480226	0.385611928801659	0.385611928801659	true	false	false	true
e7adc578-f1ff-4bb7-837f-c1bf64fe3fbd	2026-09-22 09:33	2026-09-22 09:33	2026-09-22 09:33	SOXX	SOXX261002C00560000	call	560.0000	2026-10-02	13.0000	12.5000	13.6000	558.2300	77995.00	0.00	77995.00	60	12	60	312	0.192307692307692	0.367899233754508	0.367899233754508	false	false	false	true
658be974-2067-432f-9f3a-c34ff0f92f7b	2026-09-22 09:33	2026-09-22 09:33	2026-09-22 09:33	SOXX	SOXX261120C00580000	call	580.0000	2026-11-20	28.0000	25.5000	28.7000	558.5800	14000.00	11200.00	2800.00	5	5	5	1626	0.0030750307503075	0.397304044258388	0.397304044258388	false	false	false	true
1e41eb23-3540-4d38-afba-973c2590979b	2026-09-22 09:32	2026-09-22 09:32	2026-09-22 09:32	SOXX	SOXX260925P00547500	put	547.5000	2026-09-25	3.7000	3.7000	4.3000	557.8400	29235.00	0.00	29235.00	79	12	87	32	2.71875	0.39309093130522	0.393594293519163	true	false	false	true
98d98c2f-ff28-433f-a1c1-5f2dd043225c	2026-09-22 09:31	2026-09-22 09:31	2026-09-22 09:31	SOXX	SOXX260925P00565000	put	565.0000	2026-09-25	12.1000	12.1000	15.4000	557.2700	38720.00	0.00	38720.00	32	5	32	0	0	0.379518364312443	0.381924438959084	true	false	false	true
66d0b86f-0cf3-4a79-9d6c-254b96573383	2026-09-22 09:31	2026-09-22 09:31	2026-09-22 09:31	SOXX	SOXX260925P00552500	put	552.5000	2026-09-25	5.7000	5.6000	8.3000	557.2700	42750.00	0.00	39900.00	75	7	75	20	3.75	0.393816381334751	0.395238585039468	true	false	false	true
f2a988be-abd1-4395-a9af-464e2f31c2b9	2026-09-22 09:30	2026-09-22 09:30	2026-09-22 09:30	SOXX	SOXX261218C00580000	call	580.0000	2026-12-18	35.1000	34.5000	35.8000	555.8850	21060.00	7020.00	3510.00	6	6	20	9021	0.00221704910763773	0.397490556097112	0.397490556097112	false	false	false	true
6ae91965-5715-4208-b078-80c2f60132ff	2026-09-22 09:30	2026-09-22 09:30	2026-09-22 09:30	SOXX	SOXX261218P00505000	put	505.0000	2026-12-18	20.4000	19.5000	21.5000	555.5100	40800.00	0.00	40800.00	20	5	20	44	0.454545454545455	0.414667632170584	0.414667632170584	false	false	false	true
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
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