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.

523,327 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts523,327 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

dd68d687-09ec-40ff-b9b5-8027eb16996c	2026-09-28 15:35	2026-09-28 15:35	2026-09-28 15:35	SOXX	SOXX261016C00575000	call	575.0000	2026-10-16	12.3000	12.3000	14.1000	560.8700	60270.00	0.00	60270.00	49	5	61	268	0.227611940298507	0.359303451356547	0.359303451356547	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	48898875541.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-28T19:36:53.342339Z"}	2026-09-28	2026-09-28 21:15	2026-09-28 21:15
fa22e494-2430-4e9d-85f5-46dc839e5da6	2026-09-28 15:15	2026-09-28 15:15	2026-09-28 15:15	SOXX	SOXX261002P00560000	put	560.0000	2026-10-02	9.2000	8.5000	9.2000	560.2800	45080.00	45080.00	0.00	49	11	100	461	0.216919739696312	0.404578486464173	0.404578486464173	true	false	false	true
b3bc0030-74bb-462e-8729-dfe68c2831be	2026-09-28 15:06	2026-09-28 15:06	2026-09-28 15:06	SOXX	SOXX261002P00555000	put	555.0000	2026-10-02	7.0000	6.1000	7.0000	560.5000	14000.00	11200.00	0.00	20	10	145	86	1.68604651162791	0.41228093426571	0.41228093426571	true	false	false	true
b901eac4-48a2-43ae-a999-aa6b7674fa39	2026-09-28 14:52	2026-09-28 14:52	2026-09-28 14:52	SOXX	SOXX261002P00550000	put	550.0000	2026-10-02	4.9000	4.7000	5.6000	560.9721	56350.00	490.00	55860.00	115	15	265	906	0.292494481236203	0.408343716252485	0.408343716252485	true	false	false	true
0819a5bd-5b61-4d10-9421-3e5835f6e69c	2026-09-28 14:39	2026-09-28 14:39	2026-09-28 14:39	SOXX	SOXX261023C00495000	call	495.0000	2026-10-23	69.2000	66.4000	73.3000	559.0000	62280.00	6920.00	55360.00	9	8	9	0	0	0.42087011608001	0.42087011608001	true	false	false	true
87b5093e-e4ca-4a2f-beec-413c094f2121	2026-09-28 13:18	2026-09-28 13:18	2026-09-28 13:18	SOXX	SOXX261030C00560000	call	560.0000	2026-10-30	27.0000	27.0000	28.8000	561.0400	13500.00	0.00	13500.00	5	5	13	36	0.361111111111111	0.384852470517504	0.384852470517504	false	false	false	true
dd7a6e08-21e6-4c69-975f-eb7574654cd6	2026-09-28 13:15	2026-09-28 13:14	2026-09-28 13:14	SOXX	SOXX261120C00560000	call	560.0000	2026-11-20	37.5000	35.0000	38.3000	562.5350	18750.00	18750.00	0.00	5	5	31	1654	0.0187424425634825	0.405373377267944	0.405373377267944	false	false	false	true
32d10043-92bb-4756-b5eb-c750e442214e	2026-09-28 13:08	2026-09-28 13:08	2026-09-28 13:08	SOXX	SOXX261030P00550000	put	550.0000	2026-10-30	20.6000	18.8000	21.2000	558.6000	12360.00	2060.00	2060.00	6	6	18	3038	0.00592495062541146	0.391319498146756	0.391319498146756	false	false	false	true
e0678cef-8a78-4ba3-b913-2930a6c0c40a	2026-09-28 12:51	2026-09-28 12:50	2026-09-28 12:50	SOXX	SOXX261009C00525000	call	525.0000	2026-10-09	38.8200	38.8000	43.1000	559.7600	108690.00	0.00	108690.00	28	8	40	1593	0.0251098556183302	0.395759655004932	0.395759655004932	false	false	false	true
f44549a8-0fee-42df-b082-d607f4ff1fc7	2026-09-28 12:34	2026-09-28 12:34	2026-09-28 12:34	SOXX	SOXX270115P00500000	put	500.0000	2027-01-15	22.4000	22.4000	22.8000	561.5100	22400.00	0.00	22400.00	10	8	1316	3260	0.403680981595092	0.428147437446584	0.428147437446584	false	false	false	true
17df40e7-3437-4017-9147-87ef2aa22fdc	2026-09-28 12:32	2026-09-28 12:32	2026-09-28 12:32	SOXX	SOXX261009C00547500	call	547.5000	2026-10-09	23.0000	23.0000	25.4000	561.6700	156400.00	0.00	156400.00	68	11	90	2	45	0.374729821354548	0.374729821354548	true	false	false	true
fde53420-0ab0-4e68-ac02-868a3184cbf6	2026-09-28 12:26	2026-09-28 12:26	2026-09-28 12:26	SOXX	SOXX270115P00470000	put	470.0000	2027-01-15	14.8000	14.3000	16.6000	563.2100	29600.00	0.00	29600.00	20	17	20	644	0.031055900621118	0.443056744671207	0.443056744671207	false	false	false	true
b3ee62bd-8a66-488c-a8bb-57bc32a5fa53	2026-09-28 12:26	2026-09-28 12:26	2026-09-28 12:26	SOXX	SOXX261218C00640000	call	640.0000	2026-12-18	17.4000	15.8000	18.4000	563.2000	24360.00	24360.00	0.00	14	6	1154	1807	0.638627559490869	0.392786276248315	0.39251394078047	true	false	false	true
99bb4938-4fed-4790-b220-51035387706e	2026-09-28 12:26	2026-09-28 12:26	2026-09-28 12:26	SOXX	SOXX261009C00600000	call	600.0000	2026-10-09	3.1000	2.2500	3.1000	562.8300	11150.00	10850.00	300.00	36	9	89	118	0.754237288135593	0.364047417399626	0.359953348227482	true	false	false	true
9c780429-7e4b-4464-bcfc-a26ebdf033da	2026-09-28 12:26	2026-09-28 12:26	2026-09-28 12:26	SOXX	SOXX261016C00520000	call	520.0000	2026-10-16	48.8000	43.1000	48.8000	562.0000	785680.00	785680.00	0.00	161	8	187	496	0.377016129032258	0.432051578008384	0.428092879789775	false	false	false	true
5449a421-b0ed-4df7-9ac2-0096fb5c2c02	2026-09-28 12:26	2026-09-28 12:26	2026-09-28 12:26	SOXX	SOXX261218C00580000	call	580.0000	2026-12-18	37.1000	35.5000	37.1000	561.8350	719740.00	719740.00	0.00	194	10	217	6135	0.0353708231458843	0.404883411088089	0.404883411088089	false	false	false	true
0d5e36ff-f3a2-4d11-99a4-c39da4b5392a	2026-09-28 12:26	2026-09-28 12:26	2026-09-28 12:26	SOXX	SOXX261002C00550000	call	550.0000	2026-10-02	17.3900	13.1000	17.4000	561.8350	165220.00	165220.00	0.00	95	9	214	224	0.955357142857143	0.441572555787419	0.441572555787419	false	false	false	true
803b4199-e832-4bc4-ab16-78c6d3b34a5c	2026-09-28 12:18	2026-09-28 12:18	2026-09-28 12:18	SOXX	SOXX261218C00700000	call	700.0000	2026-12-18	7.2000	7.2000	7.9000	559.0950	53280.00	0.00	53280.00	74	6	80	1478	0.054127198917456	0.397179230211036	0.397179230211036	false	false	false	true
04814f76-8358-4705-92de-1357bcb60c79	2026-09-28 11:56	2026-09-28 11:56	2026-09-28 11:56	SOXX	SOXX261016C00520000	call	520.0000	2026-10-16	44.0000	42.9000	44.0000	557.1400	44000.00	44000.00	0.00	10	6	20	496	0.0403225806451613	0.402234057799324	0.402234057799324	false	false	false	true
328ab431-fb37-4ed9-a849-a0757240e3fe	2026-09-28 11:56	2026-09-28 11:55	2026-09-28 11:55	SOXX	SOXX261009C00547500	call	547.5000	2026-10-09	19.7800	16.8000	19.8000	556.6650	43510.00	43510.00	0.00	22	6	22	2	11	0.375658225394254	0.375658225394254	true	false	false	true
ae384a04-baf3-434a-8559-26de94ed8a75	2026-09-28 11:37	2026-09-28 11:37	2026-09-28 11:37	SOXX	SOXX261016C00515000	call	515.0000	2026-10-16	47.1000	43.3000	47.1000	555.7000	108330.00	108330.00	0.00	23	9	26	26	1	0.412947070290556	0.412947070290556	false	false	false	true
33022f99-7772-4083-8a56-0698a5ce9e68	2026-09-28 11:07	2026-09-28 11:07	2026-09-28 11:07	SOXX	SOXX261009C00550000	call	550.0000	2026-10-09	17.3000	16.0000	17.3000	554.8000	141860.00	141860.00	0.00	82	18	112	185	0.605405405405405	0.376708105443677	0.376708105443677	false	false	false	true
2fcfa179-3dd1-4346-9676-0614cf831f57	2026-09-28 10:47	2026-09-28 10:47	2026-09-28 10:47	SOXX	SOXX261023P00555000	put	555.0000	2026-10-23	21.6000	16.8000	21.6000	553.4500	38880.00	38880.00	0.00	18	6	49	15	3.26666666666667	0.373803910712239	0.373803910712239	true	false	false	true
cab5a561-5139-4371-b6bb-e0ad62f6149a	2026-09-28 10:41	2026-09-28 10:41	2026-09-28 10:41	SOXX	SOXX261120C00525000	call	525.0000	2026-11-20	55.0000	53.7000	57.3000	557.3700	44000.00	38500.00	5500.00	8	5	8	137	0.0583941605839416	0.419089796228822	0.419089796228822	false	false	false	true
4fe9ad58-e3d6-42a6-913b-749a4d91643a	2026-09-28 10:21	2026-09-28 10:21	2026-09-28 10:21	SOXX	SOXX261218C00640000	call	640.0000	2026-12-18	16.7000	16.7000	17.4000	560.1600	45090.00	0.00	31730.00	27	8	474	1807	0.262313226342003	0.39447398396525	0.394442280233002	false	false	false	true
45040f20-85fa-4090-977b-126dc9833f86	2026-09-28 10:11	2026-09-28 10:11	2026-09-28 10:11	SOXX	SOXX261218C00640000	call	640.0000	2026-12-18	16.3000	15.9000	17.0000	559.4012	89644.00	0.00	89644.00	55	9	271	1807	0.149972329828445	0.392746686896579	0.393021388557359	false	false	false	true
ca286b02-420b-473e-bf48-cfcb9ac42f14	2026-09-28 10:10	2026-09-28 10:10	2026-09-28 10:10	SOXX	SOXX270617P00350000	put	350.0000	2027-06-17	10.1000	9.2000	11.2000	559.8000	29290.00	1010.00	28280.00	29	7	29	735	0.0394557823129252	0.494262789914573	0.494115536276596	false	false	false	true
776f9b54-5e93-48c7-b3c8-bea0f628ac55	2026-09-28 10:10	2026-09-28 10:10	2026-09-28 10:10	SOXX	SOXX261023C00552500	call	552.5000	2026-10-23	26.9000	26.9000	31.6000	560.7200	18830.00	0.00	18830.00	7	6	7	0	0	0.373707593493404	0.373707593493404	false	false	false	true
fff869c2-5fd1-4eaa-a01a-de08debecdb1	2026-09-28 09:53	2026-09-28 09:53	2026-09-28 09:53	SOXX	SOXX270617C00500000	call	500.0000	2027-06-17	120.9000	118.9000	123.3000	562.0000	120900.00	96720.00	24180.00	10	5	10	528	0.0189393939393939	0.430327701776941	0.430327701776941	false	false	false	true
7582066d-d47c-420f-b2eb-b62cb0b9b349	2026-09-28 09:51	2026-09-28 09:51	2026-09-28 09:51	SOXX	SOXX261023C00555000	call	555.0000	2026-10-23	26.1000	26.1000	30.9000	561.3600	15660.00	0.00	15660.00	6	6	6	55	0.109090909090909	0.376929782941415	0.376929782941415	false	false	false	true
23403bfb-f525-4632-ac23-68bbaf0e8910	2026-09-28 09:46	2026-09-28 09:46	2026-09-28 09:46	SOXX	SOXX261002P00555000	put	555.0000	2026-10-02	6.5000	5.5000	7.0000	562.2900	65000.00	7800.00	57200.00	100	10	102	86	1.18604651162791	0.420641361537995	0.420641361537995	false	false	false	true
414262d9-94a5-40d2-a7c4-3c8128f360c8	2026-09-28 09:45	2026-09-28 09:45	2026-09-28 09:45	SOXX	SOXX261120P00515000	put	515.0000	2026-11-20	15.3000	15.1000	15.6000	562.3350	47430.00	41310.00	6120.00	31	8	940	73	12.8767123287671	0.42795676119321	0.42795676119321	true	false	false	true
d105c4c5-7f69-409a-8067-45c3891057b4	2026-09-28 09:45	2026-09-28 09:45	2026-09-28 09:45	SOXX	SOXX261016P00535000	put	535.0000	2026-10-16	8.0000	7.6000	8.5000	562.1200	68000.00	52000.00	12000.00	85	14	391	870	0.449425287356322	0.388080300418497	0.388080300418497	false	false	false	true
99c4cd74-31c6-4ca5-94f6-486b8d4e8b21	2026-09-28 09:45	2026-09-28 09:45	2026-09-28 09:45	SOXX	SOXX261016P00535000	put	535.0000	2026-10-16	8.0000	7.9000	8.5000	562.1200	72000.00	68000.00	4000.00	90	16	481	870	0.552873563218391	0.388080300418497	0.388080300418497	false	false	false	true
5e337431-eddb-4d00-8256-4be557665ed1	2026-09-28 09:45	2026-09-28 09:45	2026-09-28 09:45	SOXX	SOXX261016P00535000	put	535.0000	2026-10-16	8.0000	7.9000	8.0000	562.1200	68000.00	56000.00	0.00	85	15	306	870	0.351724137931034	0.388080300418497	0.388080300418497	false	false	false	true
52b4c394-eb2c-48b4-9b14-21e60e71f349	2026-09-28 09:45	2026-09-28 09:45	2026-09-28 09:45	SOXX	SOXX261016P00535000	put	535.0000	2026-10-16	8.0000	6.4000	8.0000	562.1200	140000.00	140000.00	0.00	175	40	221	870	0.254022988505747	0.392954332971664	0.388080300418497	true	false	false	true
30e4d134-78f1-407e-8307-9fcb20eec2df	2026-09-28 09:45	2026-09-28 09:45	2026-09-28 09:45	SOXX	SOXX261016P00535000	put	535.0000	2026-10-16	8.0000	7.9000	8.0000	562.1200	12000.00	12000.00	0.00	15	14	496	870	0.570114942528736	0.388080300418497	0.388080300418497	false	false	false	true
981dc3a7-92e6-4ee2-88d6-489552f778da	2026-09-28 09:45	2026-09-28 09:45	2026-09-28 09:45	SOXX	SOXX261023P00555000	put	555.0000	2026-10-23	18.2000	14.6000	18.2000	562.3500	56420.00	56420.00	0.00	31	6	31	15	2.06666666666667	0.384058688171726	0.384058688171726	true	false	false	true
7ddb6b90-db53-49ca-adf4-ec2c114caf22	2026-09-28 09:45	2026-09-28 09:45	2026-09-28 09:45	SOXX	SOXX261218P00545000	put	545.0000	2026-12-18	32.9000	32.7000	32.9000	562.1100	46060.00	46060.00	0.00	14	5	14	9	1.55555555555556	0.417836216419049	0.416931222144515	true	false	false	true
6786e09f-db85-4065-81e1-8af71bebda5c	2026-09-28 09:45	2026-09-28 09:45	2026-09-28 09:45	SOXX	SOXX261218P00555000	put	555.0000	2026-12-18	37.3000	33.0000	37.3000	562.1100	182770.00	182770.00	0.00	49	10	49	37	1.32432432432432	0.414861544643926	0.413895125121123	true	false	false	true
a7f84383-3314-493f-9fb2-a07d05a24b95	2026-09-28 09:45	2026-09-28 09:45	2026-09-28 09:45	SOXX	SOXX261002P00547500	put	547.5000	2026-10-02	4.3000	2.2500	4.3000	562.6599	13760.00	13760.00	0.00	32	6	38	71	0.535211267605634	0.44038577451717	0.44038577451717	true	false	false	true
d61fc849-8c20-4257-a5d9-729ce37fb34f	2026-09-28 09:44	2026-09-28 09:44	2026-09-28 09:44	SOXX	SOXX261016P00562500	put	562.5000	2026-10-16	18.0000	14.6000	18.0000	562.5300	12600.00	12600.00	0.00	7	7	7	0	0	0.374802023548305	0.373090441812078	true	false	false	true
a24a0e0f-67b7-4da3-a650-69cdd75314eb	2026-09-28 09:44	2026-09-28 09:44	2026-09-28 09:44	SOXX	SOXX261023P00562500	put	562.5000	2026-10-23	21.3000	17.7000	21.3000	562.9800	21300.00	21300.00	0.00	10	5	10	0	0	0.382648436817823	0.380268444217283	false	false	false	true
1a16107f-f9ee-4c10-b4ac-c668bbbdd127	2026-09-28 09:38	2026-09-28 09:38	2026-09-28 09:38	SOXX	SOXX261023C00600000	call	600.0000	2026-10-23	9.8000	9.7000	10.6000	564.9294	15680.00	5880.00	9800.00	16	7	31	67	0.462686567164179	0.37407975926547	0.37407975926547	false	false	false	true
0c93b9a0-aafa-4226-bdf6-0944e29a9c1c	2026-09-28 09:38	2026-09-28 09:38	2026-09-28 09:38	SOXX	SOXX261120P00515000	put	515.0000	2026-11-20	14.9000	14.6000	15.2000	565.5600	35760.00	0.00	25330.00	24	6	76	73	1.04109589041096	0.433932422443186	0.433932422443186	false	false	false	true
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
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
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