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 rows

Sources in this table

uw_flow_alerts728,802 rows

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:endpoint = /api/option-trades/flow-alerts×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	expiry

37708343-7980-45be-935a-3c8fbd8e7b8a	2026-09-23 10:03	2026-09-23 10:03	2026-09-23 10:03	SOXX	SOXX281215P00200000	put	200.0000	2028-12-15	8.6200	5.4000	11.2000	564.0600	13795.00	10335.00	0.00	16	5	16	68	0.235294117647059	0.540975483432973	0.540975483432973	false	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	ETF	—	48453532778.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-23T14:04:12.048624Z"}	2026-09-23	2026-09-23 21:15	2026-09-23 21:15
81ba3ffd-2dec-4458-9014-3c753915fd6b	2026-09-23 10:02	2026-09-23 10:02	2026-09-23 10:02	SOXX	SOXX261009C00535000	call	535.0000	2026-10-09	36.0000	36.0000	37.7000	563.9900	21600.00	0.00	21600.00	6	6	6	122	0.0491803278688525	0.371263889651103	0.371263889651103	true	false	false	true
fdff52a9-7c1c-40c7-8c4b-12ede064fd31	2026-09-23 09:58	2026-09-23 09:57	2026-09-23 09:57	SOXX	SOXX261218C00580000	call	580.0000	2026-12-18	38.2100	36.9000	40.0000	563.1300	909318.00	0.00	909318.00	238	16	487	9033	0.0539134285397985	0.397760652825032	0.397760652825032	false	false	false
4429ce8b-d90c-4251-8a84-b294b7aa5e43	2026-09-23 09:54	2026-09-23 09:54	2026-09-23 09:54	SOXX	SOXX261030C00590000	call	590.0000	2026-10-30	17.7400	16.8000	19.4000	562.8450	30155.00	8855.00	15975.00	17	5	21	53	0.39622641509434	0.389207761892502	0.389207761892502	false	false	false
a65a40fd-1103-41e3-bed8-0f6927e9b342	2026-09-23 09:48	2026-09-23 09:48	2026-09-23 09:48	SOXX	SOXX261002P00560000	put	560.0000	2026-10-02	10.5900	10.4000	11.0000	563.0000	56106.00	0.00	56106.00	53	14	257	772	0.332901554404145	0.355438611072637	0.355438611072637	false	false	false	true
a2d67f42-659d-4b5e-9d37-df97475c30b2	2026-09-23 09:48	2026-09-23 09:48	2026-09-23 09:48	SOXX	SOXX261002P00560000	put	560.0000	2026-10-02	10.5000	9.7000	10.5000	563.0000	18900.00	18900.00	0.00	18	5	204	772	0.264248704663212	0.352751412731005	0.353127860138374	false	false	false	true
78d3845d-067d-4308-b9d4-0078b1066ab7	2026-09-23 09:48	2026-09-23 09:47	2026-09-23 09:47	SOXX	SOXX261002C00565000	call	565.0000	2026-10-02	12.2000	11.4000	12.2000	563.0000	61000.00	61000.00	0.00	50	5	50	163	0.306748466257669	0.358502324612898	0.358502324612898	false	false	false
7f94405f-ce7d-41bc-8ddc-ccb741fa423a	2026-09-23 09:41	2026-09-23 09:41	2026-09-23 09:41	SOXX	SOXX261002P00545000	put	545.0000	2026-10-02	5.5000	5.1000	5.5000	564.7000	12100.00	12100.00	0.00	22	8	22	27	0.814814814814815	0.380833873440026	0.380833873440026	false	false	false	true
e43b7635-48f7-4a45-8952-51b76e3ed286	2026-09-23 09:40	2026-09-23 09:40	2026-09-23 09:40	SOXX	SOXX261120P00560000	put	560.0000	2026-11-20	32.0000	29.6000	32.0000	565.2000	16000.00	16000.00	0.00	5	5	5	385	0.012987012987013	0.406848516022974	0.406848516022974	false	false	false	true
d9df3042-4b04-4888-aade-6c465f08e288	2026-09-23 09:38	2026-09-23 09:38	2026-09-23 09:38	SOXX	SOXX261009P00565000	put	565.0000	2026-10-09	16.2000	13.8000	16.2000	565.9100	27540.00	27540.00	0.00	17	5	17	7	2.42857142857143	0.363083969708758	0.363083969708758	true	false	false	true
58ff8228-8538-4eb7-a4af-caf27fd8d6ae	2026-09-23 09:35	2026-09-23 09:35	2026-09-23 09:35	SOXX	SOXX260925P00565000	put	565.0000	2026-09-25	4.8000	4.8000	5.6000	568.5200	15850.00	490.00	15360.00	33	18	34	98	0.346938775510204	0.382706862577608	0.385945078128022	true	false	false	true
33f8b733-d080-4877-806d-2883a1892a35	2026-09-23 09:33	2026-09-23 09:33	2026-09-23 09:33	SOXX	SOXX261030C00555000	call	555.0000	2026-10-30	35.6000	35.6000	39.9000	566.7900	32040.00	0.00	32040.00	9	5	9	14	0.642857142857143	0.394028328982864	0.394028328982864	false	false	false	true
0697b34d-6441-4f00-b154-397910d56146	2026-09-23 09:33	2026-09-23 09:33	2026-09-23 09:33	SOXX	SOXX261016P00590000	put	590.0000	2026-10-16	33.9000	30.4000	33.9000	567.0800	44070.00	44070.00	0.00	13	5	13	36	0.361111111111111	0.37168064846276	0.37168064846276	false	false	false	true
8959807b-f146-4558-98a3-39ecf4a2a7df	2026-09-23 09:30	2026-09-23 09:30	2026-09-23 09:30	SOXX	SOXX261120P00460000	put	460.0000	2026-11-20	6.0000	3.8000	6.9000	570.3240	10200.00	4800.00	4800.00	17	5	17	800	0.02125	0.481026500997947	0.481026500997947	false	false	false	true
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
fda37ca5-3aa0-44d8-91c8-46186445c336	2026-09-22 15:52	2026-09-22 15:52	2026-09-22 15:52	SOXX	SOXX260925P00570000	put	570.0000	2026-09-25	6.0000	5.4000	6.0000	572.6500	21610.00	21610.00	0.00	36	6	118	28	4.21428571428571	0.35581321806977	0.354833487444799	false	false	false	true
4e6b8702-4c50-4d90-97d5-c05437f945e6	2026-09-22 15:42	2026-09-22 15:42	2026-09-22 15:42	SOXX	SOXX261016C00600000	call	600.0000	2026-10-16	11.0400	10.8000	11.6000	571.3600	165553.00	0.00	165553.00	150	6	1552	13585	0.114243651085756	0.368061191763129	0.368061191763129	false	false	false
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
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
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
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
bf3b1ddc-f160-4e85-a59f-33cc8275e5f9	2026-09-22 13:53	2026-09-22 13:52	2026-09-22 13:52	SOXX	SOXX261009C00595000	call	595.0000	2026-10-09	7.9300	6.9000	8.1000	568.8300	12696.00	12696.00	0.00	16	6	19	71	0.267605633802817	0.354068435157467	0.354068435157467	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
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
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
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
ccc2d871-cee4-476d-bca4-f1c57e1d1c2d	2026-09-22 13:21	2026-09-22 13:21	2026-09-22 13:21	SOXX	SOXX261016C00600000	call	600.0000	2026-10-16	9.5500	9.3000	9.8000	567.2600	19096.00	8619.00	9522.00	20	7	282	13585	0.0207581891792418	0.364147426132698	0.364147426132698	false	false	false
f28f718d-46db-46c3-ab49-3339d884a35e	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
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
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
5e0ffb86-a4e2-4df9-8f4e-e520bdb410f1	2026-09-22 10:41	2026-09-22 10:41	2026-09-22 10:41	SOXX	SOXX261120C00540000	call	540.0000	2026-11-20	53.0500	53.0000	56.1000	564.9201	127310.00	5310.00	122000.00	24	11	30	59	0.508474576271186	0.419789407514053	0.419789407514053	true	false	false
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
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
f04dbbee-b784-462a-8e39-17cf45e454fb	2026-09-22 10:30	2026-09-22 10:30	2026-09-22 10:30	SOXX	SOXX261120C00575000	call	575.0000	2026-11-20	35.3300	33.3000	35.5000	566.8800	28265.00	28265.00	0.00	8	5	10	62	0.161290322580645	0.410468065010886	0.410468065010886	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
388c7ae0-3739-43aa-8f4e-45392dc77085	2026-09-22 10:10	2026-09-22 10:10	2026-09-22 10:10	SOXX	SOXX260925C00555000	call	555.0000	2026-09-25	13.7600	12.0000	13.8000	564.5000	22017.00	22017.00	0.00	16	5	33	210	0.157142857142857	0.397760678674035	0.393875659931989	false	false	false
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
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
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