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.

728,802 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts728,802 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

ad265ec2-f6c2-4bf5-8592-8c713a27340f	2026-09-17 09:54	2026-09-17 09:54	2026-09-17 09:54	SOXX	SOXX261016C00490000	call	490.0000	2026-10-16	40.8000	38.5000	40.8000	519.8000	48960.00	48960.00	0.00	12	6	12	268	0.0447761194029851	0.381529887890857	0.381529887890857	true	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	42262911204.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-17T13:57:31.198579Z"}	2026-09-17	2026-09-17 21:15	2026-09-17 21:15
2fda4593-4cd5-47dc-babe-052da07092c9	2026-09-17 09:54	2026-09-17 09:54	2026-09-17 09:54	SOXX	SOXX260925C00525000	call	525.0000	2026-09-25	8.2000	6.9000	8.4000	519.4750	10660.00	10660.00	0.00	13	5	26	213	0.122065727699531	0.341946781816277	0.341946781816277	true	false	false	true
0f69bcb1-a526-4f7f-8aa4-d8fc7f83bfba	2026-09-17 09:48	2026-09-17 09:48	2026-09-17 09:48	SOXX	SOXX261120C00530000	call	530.0000	2026-11-20	29.8000	27.8000	29.8000	518.5100	113240.00	113240.00	0.00	38	8	40	92	0.434782608695652	0.3842144384481	0.3842144384481	true	false	false	true
571866ff-24ba-4479-8817-b2784ecce28d	2026-09-17 09:47	2026-09-17 09:46	2026-09-17 09:46	SOXX	SOXX260918P00517500	put	517.5000	2026-09-18	4.4000	4.2000	4.9000	517.9900	14960.00	4840.00	9680.00	34	9	40	484	0.0826446280991736	0.431800303211681	0.431800303211681	false	false	false	true
69e8fa74-164b-4077-a1d2-b7b40b1dc242	2026-09-17 09:46	2026-09-17 09:46	2026-09-17 09:46	SOXX	SOXX260918C00510000	call	510.0000	2026-09-18	9.5000	8.1000	10.0000	517.3250	21850.00	21850.00	0.00	23	5	95	1843	0.0515463917525773	0.462548554976747	0.462548554976747	false	false	false	true
0ebdbcef-f1e5-45be-be3e-31eb50ce3cfb	2026-09-17 09:44	2026-09-17 09:44	2026-09-17 09:44	SOXX	SOXX260925C00520000	call	520.0000	2026-09-25	9.4000	8.3000	9.4000	516.9050	28200.00	28200.00	0.00	30	6	41	107	0.383177570093458	0.348641052328119	0.348641052328119	true	false	false	true
dc90dd16-c8e5-4e62-b4da-03a91064074c	2026-09-17 09:43	2026-09-17 09:43	2026-09-17 09:43	SOXX	SOXX261016C00500000	call	500.0000	2026-10-16	31.8000	29.9000	31.8000	516.8000	47700.00	47700.00	0.00	15	6	16	476	0.0336134453781513	0.374592840768434	0.374592840768434	false	false	false	true
7f15b839-07f6-4270-a4bb-9511f5d9f5b0	2026-09-17 09:39	2026-09-17 09:39	2026-09-17 09:39	SOXX	SOXX260918P00515000	put	515.0000	2026-09-18	4.6000	3.5000	4.6000	515.4600	21620.00	21620.00	0.00	47	7	72	1350	0.0533333333333333	0.451159860092448	0.451159860092448	true	false	false	true
2027253a-f2d1-41e0-9d14-830631b4c0ca	2026-09-17 09:39	2026-09-17 09:39	2026-09-17 09:39	SOXX	SOXX260918P00512500	put	512.5000	2026-09-18	3.6000	3.2000	3.7000	515.2400	18360.00	18360.00	0.00	51	8	51	38	1.34210526315789	0.45394816845187	0.45394816845187	true	false	false	true
0aaa048f-59c8-4dfe-a8d9-9e91a30e488e	2026-09-17 09:31	2026-09-17 09:30	2026-09-17 09:30	SOXX	SOXX260925P00505000	put	505.0000	2026-09-25	5.5000	5.3000	7.2000	517.6209	82500.00	0.00	82500.00	150	18	150	35	4.28571428571429	0.357720706854846	0.357720706854846	true	false	false	true
6d37bd69-578c-4030-b03b-1b824f22f6fe	2026-09-16 15:55	2026-09-16 15:55	2026-09-16 15:55	SOXX	SOXX261016P00525000	put	525.0000	2026-10-16	34.6500	34.6000	36.3000	500.0000	24255.00	0.00	24255.00	7	7	211	451	0.467849223946785	0.369558632192285	0.368961707155587	false	false	false	true
3956db6c-0d7f-4a19-8249-50041f166852	2026-09-16 15:54	2026-09-16 15:54	2026-09-16 15:54	SOXX	SOXX261016P00465000	put	465.0000	2026-10-16	8.6000	8.4000	8.6000	500.0000	15480.00	15480.00	0.00	18	12	3194	1353	2.36067997043607	0.406631660055206	0.406872336899919	false	false	false	true
0be9ca51-4a0b-46c2-b695-0285cd5d5d8e	2026-09-16 15:50	2026-09-16 15:50	2026-09-16 15:50	SOXX	SOXX261120P00500000	put	500.0000	2026-11-20	31.0300	30.0000	33.4000	501.0000	335130.00	0.00	335130.00	108	2	112	199	0.562814070351759	0.400148078724781	0.400148078724781	false	true	false	true
108f90e7-3bba-42dc-aec5-e8e1e675269f	2026-09-16 15:47	2026-09-16 15:46	2026-09-16 15:46	SOXX	SOXX261218P00430000	put	430.0000	2026-12-18	12.9000	12.3000	13.5000	500.0000	72240.00	14190.00	42570.00	56	5	68	421	0.161520190023753	0.427915535641127	0.427915535641127	false	false	false	true
937243a6-9db1-4e47-b3ae-ef184d970a3f	2026-09-16 15:46	2026-09-16 15:46	2026-09-16 15:46	SOXX	SOXX261016P00565000	put	565.0000	2026-10-16	66.0000	66.0000	70.4000	501.0000	85800.00	0.00	85800.00	13	5	13	36	0.361111111111111	0.370142639757346	0.370142639757346	false	false	false	true
834b688f-b304-4843-a856-e2628bffe7a9	2026-09-16 15:42	2026-09-16 15:42	2026-09-16 15:42	SOXX	SOXX261016P00495000	put	495.0000	2026-10-16	18.9000	17.0000	18.9000	499.3500	56700.00	56700.00	0.00	30	6	135	738	0.182926829268293	0.382813604211027	0.383199619122879	false	false	false	true
6bc1f291-914c-4ea9-8fa4-98ddecf7f8d7	2026-09-16 15:32	2026-09-16 15:32	2026-09-16 15:32	SOXX	SOXX260925P00505000	put	505.0000	2026-09-25	14.1000	14.1000	15.1000	499.9750	11280.00	0.00	11280.00	8	8	37	36	1.02777777777778	0.371677629394794	0.371677629394794	true	false	false	true
9b8d48e5-a214-4f2d-81a1-58855b56ec1f	2026-09-16 15:30	2026-09-16 15:30	2026-09-16 15:30	SOXX	SOXX261016P00465000	put	465.0000	2026-10-16	8.9000	8.6000	9.3000	499.2900	48060.00	12460.00	24030.00	54	5	684	1353	0.505543237250554	0.407086813762433	0.407086813762433	false	false	false	true
ab2b20db-56e3-4742-a19a-0cbd745ed56b	2026-09-16 15:30	2026-09-16 15:30	2026-09-16 15:30	SOXX	SOXX260925P00490000	put	490.0000	2026-09-25	7.7000	7.7000	9.1000	499.3000	28490.00	0.00	28490.00	37	7	127	1418	0.0895627644569817	0.386125759535843	0.386125759535843	true	false	false	true
66bcb0e2-4eb9-4891-8a63-3f6dac2c8684	2026-09-16 15:29	2026-09-16 15:29	2026-09-16 15:29	SOXX	SOXX261016P00465000	put	465.0000	2026-10-16	8.9000	8.9000	9.3000	498.9900	62300.00	0.00	62300.00	70	6	630	1353	0.465631929046563	0.405293543001493	0.405456754004137	false	false	false	true
1e74bfa7-1972-4b40-81c0-1b0998d6b50f	2026-09-16 15:29	2026-09-16 15:29	2026-09-16 15:29	SOXX	SOXX260918P00495000	put	495.0000	2026-09-18	4.9000	4.9000	5.6000	498.7600	25970.00	0.00	25970.00	53	13	485	2405	0.201663201663202	0.453636846249532	0.453636846249532	true	false	false	true
735f4104-0e74-4e3e-8d43-64fc415cda8f	2026-09-16 15:20	2026-09-16 15:20	2026-09-16 15:20	SOXX	SOXX260918P00475000	put	475.0000	2026-09-18	0.9000	0.9000	0.9500	497.8800	12240.00	0.00	12240.00	136	21	490	2853	0.171749036102348	0.506175717914906	0.506175717914906	false	false	false	true
b9d25dc5-7d17-4978-8e68-96db8c7b0ff2	2026-09-16 15:20	2026-09-16 15:20	2026-09-16 15:20	SOXX	SOXX260918C00515000	call	515.0000	2026-09-18	1.2500	1.2500	1.7000	498.1750	12500.00	0.00	12500.00	100	5	123	1059	0.11614730878187	0.429818388650122	0.429818388650122	false	false	false	true
7829b04e-8e7a-4501-b9a5-64339c68f860	2026-09-16 15:03	2026-09-16 15:03	2026-09-16 15:03	SOXX	SOXX260925P00450000	put	450.0000	2026-09-25	1.0000	0.9500	1.2500	500.8400	116600.00	0.00	78500.00	1166	13	1203	375	3.208	0.458464266268646	0.458464266268646	false	false	false	true
54ebdda1-cb68-4920-9ea4-628e5d9b4bd5	2026-09-16 14:48	2026-09-16 14:48	2026-09-16 14:48	SOXX	SOXX261120C00560000	call	560.0000	2026-11-20	13.8000	13.6000	14.1000	503.5800	19320.00	1380.00	17940.00	14	5	19	74	0.256756756756757	0.378569890593719	0.378569890593719	false	false	false	true
e5480c70-cf19-4523-8ac8-7fcb05b1e6eb	2026-09-16 14:35	2026-09-16 14:35	2026-09-16 14:35	SOXX	SOXX260918P00485000	put	485.0000	2026-09-18	1.4000	1.0500	1.4000	503.8300	15400.00	15400.00	0.00	110	10	162	2009	0.0806371329019413	0.497037675626875	0.497037675626875	false	false	false	true
fce987cb-03c4-47e7-b313-c68f0ca5e868	2026-09-16 13:56	2026-09-16 13:55	2026-09-16 13:55	SOXX	SOXX260918P00480000	put	480.0000	2026-09-18	0.6000	0.6000	0.8000	507.0000	70860.00	0.00	70860.00	1181	39	2975	8017	0.371086441312212	0.516189699418223	0.516189699418223	false	false	false	true
69e5e3b1-5b90-46c6-88a9-d355e95d2ad9	2026-09-16 12:16	2026-09-16 12:16	2026-09-16 12:16	SOXX	SOXX281215P00450000	put	450.0000	2028-12-15	74.5000	73.9000	75.9000	508.7000	745000.00	588550.00	156450.00	100	33	200	274	0.72992700729927	0.446059466585601	0.446059466585601	false	false	false	true
7ccb3f6b-4524-4a6a-bee0-bf66ff2e9d08	2026-09-16 12:04	2026-09-16 12:04	2026-09-16 12:04	SOXX	SOXX281215P00450000	put	450.0000	2028-12-15	74.5100	71.9000	76.1000	508.2550	558800.00	59600.00	499200.00	75	11	100	274	0.364963503649635	0.445600297833831	0.445600297833831	false	false	false	true
6c78c52f-decd-4f2c-84f1-5c1a293a6d5f	2026-09-16 12:00	2026-09-16 12:00	2026-09-16 12:00	SOXX	SOXX260918P00480000	put	480.0000	2026-09-18	0.6000	0.6000	0.7000	508.4000	33720.00	0.00	33720.00	562	32	776	8017	0.0967943120868155	0.528599067719109	0.528599067719109	false	false	false	true
d8abf848-c70b-4e00-b38e-84ae12fdc5b5	2026-09-16 11:11	2026-09-16 11:11	2026-09-16 11:11	SOXX	SOXX270617P00450000	put	450.0000	2027-06-17	37.5000	36.8000	38.3000	508.4100	281250.00	0.00	281250.00	75	5	100	2879	0.0347342827370615	0.419037581541878	0.419037581541878	false	false	false	true
5e3cc89f-dc8d-489e-8e7e-0daf3d0d4970	2026-09-16 11:08	2026-09-16 11:08	2026-09-16 11:08	SOXX	SOXX261002C00505000	call	505.0000	2026-10-02	18.3000	17.5000	18.7000	508.8900	86010.00	86010.00	0.00	47	13	99	32	3.09375	0.373712262994556	0.373712262994556	true	false	false	true
47d6937d-ee4a-4160-b751-0ade214bf46d	2026-09-16 11:08	2026-09-16 11:08	2026-09-16 11:08	SOXX	SOXX261002C00525000	call	525.0000	2026-10-02	9.0000	8.0000	9.0000	508.8900	10800.00	10800.00	0.00	12	6	21	27	0.777777777777778	0.357669138706018	0.357669138706018	true	false	false	true
0aa2721c-7514-46a8-a915-ffd960e83861	2026-09-16 10:59	2026-09-16 10:59	2026-09-16 10:59	SOXX	SOXX261016C00600000	call	600.0000	2026-10-16	1.4000	1.3000	1.4000	508.3400	51240.00	51240.00	0.00	366	26	371	8723	0.0425312392525507	0.359924097984444	0.359924097984444	false	false	false	true
759cfb50-e142-4d5c-85d7-fee3ce7570c2	2026-09-16 10:43	2026-09-16 10:42	2026-09-16 10:42	SOXX	SOXX260918C00500000	call	500.0000	2026-09-18	11.0000	11.0000	12.6000	507.3650	99000.00	0.00	99000.00	90	6	393	2717	0.144644828855355	0.443914589411418	0.443914589411418	false	false	false	true
d5a4270b-f418-4635-938c-1dfdb13e6492	2026-09-16 10:37	2026-09-16 10:37	2026-09-16 10:37	SOXX	SOXX260925P00502500	put	502.5000	2026-09-25	9.2000	7.9000	9.2000	507.1300	11040.00	11040.00	0.00	12	7	13	9	1.44444444444444	0.366372381259873	0.366372381259873	false	false	false	true
168d0f67-b640-47c2-9563-b0f65a74434e	2026-09-16 10:24	2026-09-16 10:24	2026-09-16 10:24	SOXX	SOXX260918C00527500	call	527.5000	2026-09-18	0.9500	0.8500	1.0500	508.0000	19000.00	15960.00	0.00	200	6	206	88	2.34090909090909	0.413804663068814	0.413804663068814	false	false	false	true
7a60643c-a5d8-4eb0-bcf2-5086650f5972	2026-09-16 10:09	2026-09-16 10:09	2026-09-16 10:09	SOXX	SOXX261016C00550000	call	550.0000	2026-10-16	6.9000	6.5000	6.9000	508.6300	59340.00	59340.00	0.00	86	21	94	3291	0.0285627468854452	0.348252300863878	0.348252300863878	false	false	false	true
80f187d6-30e8-4a86-801e-a92a57749d57	2026-09-16 09:58	2026-09-16 09:58	2026-09-16 09:58	SOXX	SOXX260925P00460000	put	460.0000	2026-09-25	1.1000	0.9500	1.1000	509.0300	116050.00	116050.00	0.00	1055	28	1166	1130	1.03185840707965	0.447306401161022	0.447306401161022	false	false	false	true
6aa5c0be-a597-4242-8cfb-33e000798b14	2026-09-16 09:45	2026-09-16 09:45	2026-09-16 09:45	SOXX	SOXX260918P00495000	put	495.0000	2026-09-18	2.4500	2.4500	2.8000	507.2400	24500.00	0.00	24500.00	100	6	205	2405	0.0852390852390852	0.465237437157523	0.469512613532002	false	false	false	true
c01680e4-a5dc-4fe5-9772-937d8128e8fa	2026-09-16 09:34	2026-09-16 09:34	2026-09-16 09:34	SOXX	SOXX260918C00500000	call	500.0000	2026-09-18	10.0000	10.0000	11.0000	505.5625	55000.00	0.00	55000.00	55	9	248	2717	0.0912771439087229	0.457498681074617	0.457498681074617	false	false	false	true
c961c90c-dc75-4582-b7f4-4f0befba7aa1	2026-09-16 09:33	2026-09-16 09:33	2026-09-16 09:33	SOXX	SOXX260925C00500000	call	500.0000	2026-09-25	14.8000	14.8000	17.0000	505.7500	10360.00	0.00	10360.00	7	5	7	43	0.162790697674419	0.362514553558645	0.362514553558645	false	false	false	true
b7b82aaf-72a8-44a0-b9d5-88aebcf40a67	2026-09-16 09:33	2026-09-16 09:33	2026-09-16 09:33	SOXX	SOXX260918C00492500	call	492.5000	2026-09-18	15.7000	15.7000	18.6000	505.8800	50240.00	0.00	50240.00	32	17	32	110	0.290909090909091	0.473625264738769	0.473625264738769	true	false	false	true
a6dd49b8-01af-4739-8a37-d4c632c1bafa	2026-09-16 09:33	2026-09-16 09:33	2026-09-16 09:33	SOXX	SOXX260925C00492500	call	492.5000	2026-09-25	19.9000	19.9000	22.7000	505.8800	41800.00	2000.00	39800.00	21	9	21	3	7	0.369902921772461	0.374012927534723	true	false	false	true
7d2d961f-d581-46f8-be42-66d5d9edd7d8	2026-09-15 15:47	2026-09-15 15:46	2026-09-15 15:46	SOXX	SOXX261016C00550000	call	550.0000	2026-10-16	5.1000	4.7000	5.1000	499.0000	165240.00	165240.00	0.00	324	26	350	3102	0.112830431979368	0.348454623889502	0.348454623889502	false	false	false	true
2db6cfc9-abca-4131-b998-c55b3988c160	2026-09-15 15:47	2026-09-15 15:46	2026-09-15 15:46	SOXX	SOXX261016C00510000	call	510.0000	2026-10-16	16.9000	16.3000	16.9000	499.0000	1252290.00	1252290.00	0.00	741	22	776	2072	0.374517374517374	0.362125232529691	0.362125232529691	false	false	false	true
82e06778-9d17-4472-a122-4a47567a5c7c	2026-09-15 15:29	2026-09-15 15:29	2026-09-15 15:29	SOXX	SOXX261016C00560000	call	560.0000	2026-10-16	3.6000	3.5000	3.7000	498.4500	91800.00	91440.00	360.00	255	8	269	343	0.784256559766764	0.349014421956502	0.349014421956502	false	false	false	true
1ece31d7-8a01-409d-a62c-02188b6f0ac2	2026-09-15 15:08	2026-09-15 15:08	2026-09-15 15:08	SOXX	SOXX261016C00500000	call	500.0000	2026-10-16	21.3000	20.5000	21.3000	498.2500	97980.00	97980.00	0.00	46	13	96	391	0.245524296675192	0.368109906906855	0.368109906906855	false	false	false	true
40c348d8-5902-4288-b30b-6a353f0f4566	2026-09-15 14:37	2026-09-15 14:37	2026-09-15 14:37	SOXX	SOXX261016P00480000	put	480.0000	2026-10-16	13.3000	13.0000	13.3000	497.5900	38570.00	38570.00	0.00	29	9	431	4639	0.0929079543004958	0.380433572656525	0.380433572656525	true	false	false	true
f63487af-6ed1-409e-9d92-5759669fd97c	2026-09-15 14:01	2026-09-15 14:01	2026-09-15 14:01	SOXX	SOXX260918C00500000	call	500.0000	2026-09-18	6.6000	6.4000	6.6000	498.2500	341220.00	341220.00	0.00	517	13	1752	1116	1.56989247311828	0.408171306997727	0.408171306997727	false	false	false	true