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

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	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	49252224379.00	—	—	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-24T16:16:49.777231Z"}	2026-09-24	2026-09-24 21:15	2026-09-24 21:15
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
e3d8559e-5252-4b4b-9d8d-938db32f3f62	2026-09-23 14:17	2026-09-23 14:16	2026-09-23 14:16	SOXX	SOXX261218P00500000	put	500.0000	2026-12-18	18.4000	18.4000	18.5000	564.3300	46000.00	0.00	46000.00	25	9	354	1146	0.308900523560209	0.437421658475385	0.437645087061962	true	false	false	true
7a8fd5a2-6ad7-4bbb-ac84-04d1e5048c4c	2026-09-23 14:16	2026-09-23 14:16	2026-09-23 14:16	SOXX	SOXX261218P00500000	put	500.0000	2026-12-18	18.4000	18.4000	18.6000	564.2100	42320.00	0.00	42320.00	23	5	273	1146	0.238219895287958	0.437309912314867	0.437309912314867	true	false	false	true
237f5b7a-92c3-4b81-b5ed-5f201dfb5856	2026-09-23 14:16	2026-09-23 14:16	2026-09-23 14:16	SOXX	SOXX270617P00380000	put	380.0000	2027-06-17	13.8000	13.7000	13.8000	564.1900	28980.00	28980.00	0.00	21	5	308	537	0.573556797020484	0.475540971575855	0.475540971575855	true	false	false	true
deec7034-1f09-4aac-a1a0-712b862b6d81	2026-09-23 14:16	2026-09-23 14:16	2026-09-23 14:16	SOXX	SOXX261218P00500000	put	500.0000	2026-12-18	18.3000	18.2000	18.5000	564.1400	71370.00	34770.00	25620.00	39	9	153	1146	0.133507853403141	0.435605844314182	0.435926520275696	true	false	false	true
5b0359ec-6cfa-44f9-95b8-82647ee56793	2026-09-23 14:04	2026-09-23 14:03	2026-09-23 14:03	SOXX	SOXX261009C00565000	call	565.0000	2026-10-09	16.9000	16.8000	17.8000	563.2600	20280.00	0.00	20280.00	12	7	18	18	1	0.365560608263734	0.367053649995159	true	false	false	true
7a33e3ef-7800-45bd-b16a-9b789b1e86fc	2026-09-23 13:33	2026-09-23 13:33	2026-09-23 13:33	SOXX	SOXX261218C00575000	call	575.0000	2026-12-18	40.1000	40.0000	40.1000	560.6000	485210.00	485210.00	0.00	121	17	122	687	0.177583697234352	0.406085489808796	0.406085489808796	false	false	false	true
032e4287-f33c-40a5-a472-91184b5ac57e	2026-09-23 13:33	2026-09-23 13:33	2026-09-23 13:33	SOXX	SOXX261120C00575000	call	575.0000	2026-11-20	32.0300	31.9000	32.3000	560.6200	188970.00	150410.00	38560.00	59	19	106	127	0.834645669291339	0.412621626168861	0.414756710367314	true	false	false	true
4d35ee91-501d-4ede-9ea0-a8997e1792ff	2026-09-23 13:32	2026-09-23 13:32	2026-09-23 13:32	SOXX	SOXX281215C00800000	call	800.0000	2028-12-15	83.8000	80.1000	87.4000	560.3500	150840.00	83800.00	67040.00	18	5	20	149	0.134228187919463	0.40234292362257	0.402349759717605	false	false	false	true
27b8d704-dfb1-4d95-b060-158c8ea9bca5	2026-09-23 13:16	2026-09-23 13:16	2026-09-23 13:16	SOXX	SOXX261218C00560000	call	560.0000	2026-12-18	46.3000	46.3000	47.3000	559.0000	50930.00	0.00	50930.00	11	5	51	209	0.244019138755981	0.404864483569466	0.404864483569466	false	false	false	true
bc4a8bff-d93b-4135-b690-5f07b954e236	2026-09-23 12:20	2026-09-23 12:20	2026-09-23 12:20	SOXX	SOXX261016P00400000	put	400.0000	2026-10-16	0.4100	0.1500	0.7000	561.9800	143500.00	31500.00	112000.00	3500	2	3512	3168	1.10858585858586	0.640158505663233	0.640158505663233	false	true	false	true
659e16c2-febf-4992-b7cc-ac3de4858576	2026-09-23 12:01	2026-09-23 12:01	2026-09-23 12:01	SOXX	SOXX261120P00450000	put	450.0000	2026-11-20	4.9000	4.8000	4.9000	561.2500	346430.00	346430.00	0.00	707	6	1429	1319	1.08339651250948	0.464622713214858	0.464622713214858	false	false	false	true
eb47d08f-3724-4732-8c15-9cce3ed18b9d	2026-09-23 12:01	2026-09-23 12:01	2026-09-23 12:01	SOXX	SOXX261120P00450000	put	450.0000	2026-11-20	4.9000	4.8000	4.9000	561.4600	348880.00	13230.00	0.00	712	7	722	1319	0.547384382107657	0.465147660826289	0.465147660826289	false	false	false	true
da786040-9fdf-47b9-91fb-88b9d62ccae6	2026-09-23 12:01	2026-09-23 12:01	2026-09-23 12:01	SOXX	SOXX261120P00455000	put	455.0000	2026-11-20	5.4000	5.3000	5.7000	561.4600	330480.00	0.00	329940.00	612	8	621	37	16.7837837837838	0.460959473701524	0.460959473701524	false	false	false	true
d40419ce-7d9e-4d78-adc3-8a9984519dd8	2026-09-23 11:53	2026-09-23 11:53	2026-09-23 11:53	SOXX	SOXX270617P00400000	put	400.0000	2027-06-17	17.2000	17.1000	17.3000	561.0000	29240.00	27520.00	0.00	17	9	527	2801	0.188147090324884	0.464108217669055	0.464108217669055	true	false	false	true
a981d1f2-aceb-4ef3-809b-a707270c5a86	2026-09-23 11:53	2026-09-23 11:53	2026-09-23 11:53	SOXX	SOXX270617P00400000	put	400.0000	2027-06-17	17.1600	16.8000	17.3000	561.0000	24030.00	10330.00	13700.00	14	8	398	2801	0.142092109960728	0.463712734812665	0.464704476122001	false	false	false	true
94aa414c-b416-4c1f-a3ff-0804f02dc434	2026-09-23 11:52	2026-09-23 11:52	2026-09-23 11:52	SOXX	SOXX270319P00510000	put	510.0000	2027-03-19	35.8000	35.8000	35.9000	561.0000	78760.00	0.00	78760.00	22	7	180	211	0.853080568720379	0.421930766211372	0.421930766211372	false	false	false	true
8b892acc-ca19-43f4-b11f-60f17e415402	2026-09-23 11:48	2026-09-23 11:48	2026-09-23 11:48	SOXX	SOXX261030C00540000	call	540.0000	2026-10-30	41.9000	41.9000	44.3000	562.0000	62850.00	0.00	62850.00	15	6	16	29	0.551724137931034	0.400193429549167	0.400193429549167	false	false	false	true
b271b5f1-eda9-4c37-91af-3761b0067b3d	2026-09-23 11:45	2026-09-23 11:45	2026-09-23 11:45	SOXX	SOXX270219P00420000	put	420.0000	2027-02-19	10.2000	10.2000	10.4000	563.0000	13260.00	0.00	7140.00	13	13	67	319	0.210031347962382	0.456804669094234	0.456804669094234	false	false	false	true
655f8255-795a-4993-b2ff-f59ad3dc468d	2026-09-23 11:35	2026-09-23 11:35	2026-09-23 11:35	SOXX	SOXX261016C00600000	call	600.0000	2026-10-16	7.9000	7.9000	8.4000	563.6900	613040.00	0.00	613040.00	776	17	2574	11648	0.220982142857143	0.358388660272451	0.358388660272451	false	false	false	true
fda8b52d-961b-4d0b-a940-52334edd3d5b	2026-09-23 11:35	2026-09-23 11:35	2026-09-23 11:35	SOXX	SOXX261016C00600000	call	600.0000	2026-10-16	8.0000	7.8000	8.4000	563.6400	521600.00	96800.00	319200.00	652	8	1786	11648	0.153331043956044	0.36082196677774	0.36082196677774	false	false	false	true
3d8938e0-099a-4afe-9338-c07675b2a1c5	2026-09-23 11:33	2026-09-23 11:33	2026-09-23 11:33	SOXX	SOXX261016C00600000	call	600.0000	2026-10-16	8.1000	7.8000	8.4000	564.0000	745200.00	26730.00	621270.00	920	25	1134	11648	0.0973557692307692	0.360884068096403	0.360884068096403	false	false	false	true
1648a583-1f30-4442-8688-33f834b9d77d	2026-09-23 11:33	2026-09-23 11:33	2026-09-23 11:33	SOXX	SOXX261002P00550000	put	550.0000	2026-10-02	6.8000	6.8000	7.1000	564.0000	396440.00	0.00	396440.00	583	38	762	235	3.24255319148936	0.366354789484934	0.366354789484934	false	false	false	true
f8b9d0e4-a8bd-469f-a0df-a300b029403b	2026-09-23 10:53	2026-09-23 10:53	2026-09-23 10:53	SOXX	SOXX260925C00515000	call	515.0000	2026-09-25	48.9000	43.1000	48.9000	562.4800	474330.00	474330.00	0.00	97	10	97	188	0.515957446808511	0.863404414921457	0.863404414921457	true	false	false	true
e8a25ccf-3c6e-450d-aa65-578377a74d25	2026-09-23 10:53	2026-09-23 10:53	2026-09-23 10:53	SOXX	SOXX261120C00570000	call	570.0000	2026-11-20	34.6000	31.9000	34.6000	562.4800	204140.00	204140.00	0.00	59	8	60	37	1.62162162162162	0.406905792528382	0.406905792528382	false	false	false	true
6b2f9cb6-f904-40fd-850f-e6b554f22c5d	2026-09-23 10:53	2026-09-23 10:53	2026-09-23 10:53	SOXX	SOXX261002P00585000	put	585.0000	2026-10-02	26.0100	26.0000	29.7000	562.4800	434312.00	0.00	434312.00	167	10	170	3	56.6666666666667	0.332894523430788	0.332894523430788	false	false	false	true