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.

281,039 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts281,039 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:ticker = SOXX×sorted by created_at ↑×

iduuid	created_at ↑timestamp with time zone	start_timetimestamp with time zone	end_timetimestamp with time zone	tickertext	option_symboltext	option_typetext	strikenumeric	expirydate	pricenumeric

cea987ad-c776-4f94-a11c-e2d38073882d	2026-08-18 14:53	2026-08-18 14:53	2026-08-18 14:53	SOXX	SOXX260828C00585000	call	585.0000	2026-08-28	1.4000	1.4000	1.8000	527.4300	328311.00	0.00	328311.00	2345	49	2356	63	37.3968253968254	0.43588578928122	0.43588578928122	false	false	false	true	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	ETF	—	41370759630.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-18T19:23:50.384726Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
84d739a6-275b-426b-920a-d29772cc9494	2026-08-18 15:13	2026-08-18 15:13	2026-08-18 15:13	SOXX	SOXX260828P00525000	put	525.0000	2026-08-28	14.7000	13.9000	15.3000	527.5050	117600.00	117600.00	0.00	80	1	122	93	1.31182795698925	0.465943137477803	0.465943137477803	false	true	false	true	false
83713c10-45ff-414c-b284-0f5a76c3149e	2026-08-18 15:26	2026-08-18 15:26	2026-08-18 15:26	SOXX	SOXX270115P00330000	put	330.0000	2027-01-15	5.5200	5.5000	6.0000	528.6300	55201.00	0.00	55201.00	100	6	312	12646	0.024671832990669	0.550348179402444	0.550348179402444	false	false	false	true	false
6c0ef083-0912-4931-a637-0359c3c50b9f	2026-08-18 15:37	2026-08-18 15:37	2026-08-18 15:37	SOXX	SOXX261016C00600000	call	600.0000	2026-10-16	13.7000	13.3000	13.8000	529.4600	12330.00	1370.00	10960.00	9	5	132	4312	0.0306122448979592	0.423769431064577	0.423769431064577	false	false	false	true	false
b0f5d70f-36dc-46c3-99a5-7b74fee7904c	2026-08-18 15:44	2026-08-18 15:44	2026-08-18 15:44	SOXX	SOXX260918C00630000	call	630.0000	2026-09-18	2.4000	2.4000	2.8000	530.0400	556598.00	245.00	556353.00	2319	36	2431	585	4.15555555555556	0.409099991760524	0.409099991760524	false	false	false	true	false
06cc38f4-a74d-4b29-b7bc-e0e1898dab4f	2026-08-18 15:54	2026-08-18 15:54	2026-08-18 15:54	SOXX	SOXX260828P00515000	put	515.0000	2026-08-28	10.2000	8.8000	10.2000	528.0000	10200.00	10200.00	0.00	10	5	57	73	0.780821917808219	0.468083306902949	0.467648160608675	false	false	false	true	false
0ea10566-d6d2-4c30-9d03-835233d4b12c	2026-08-19 09:31	2026-08-19 09:31	2026-08-19 09:31	SOXX	SOXX260828C00550000	call	550.0000	2026-08-28	9.1000	8.4000	9.5000	534.4950	61880.00	6370.00	55510.00	68	9	68	141	0.482269503546099	0.455256504386271	0.455256504386271	false	false	false	true	false
7e98477c-c961-49e0-8d0e-7fded305c294	2026-08-19 09:40	2026-08-19 09:40	2026-08-19 09:40	SOXX	SOXX260821P00515000	put	515.0000	2026-08-21	4.5000	3.0000	4.5000	525.1700	30150.00	30150.00	0.00	67	9	69	2806	0.0245901639344262	0.568547875560509	0.565833265995427	true	false	false	true	false
1e93821f-6127-44b8-93e4-328e11f3b363	2026-08-19 09:40	2026-08-19 09:40	2026-08-19 09:40	SOXX	SOXX260828P00512500	put	512.5000	2026-08-28	9.8000	7.7000	9.8000	525.2900	100940.00	100940.00	0.00	103	5	103	0	0	0.478454226009185	0.478454226009185	false	false	false	true	false
be1df4b2-fb29-4cce-b044-2a0e5884cebd	2026-08-19 09:44	2026-08-19 09:44	2026-08-19 09:44	SOXX	SOXX260918P00500000	put	500.0000	2026-09-18	14.4000	13.8000	14.4000	528.2200	2880000.00	2880000.00	0.00	2000	3	2004	6225	0.321927710843374	0.454962720209615	0.454962720209615	false	true	true	false	false
f52d5497-4ecd-492f-b9ad-8b609a1e59a4	2026-08-19 09:45	2026-08-19 09:45	2026-08-19 09:45	SOXX	SOXX260821P00532500	put	532.5000	2026-08-21	9.9000	9.9000	11.3000	528.5500	14850.00	0.00	14850.00	15	6	16	103	0.155339805825243	0.49991138825476	0.49991138825476	false	false	false	true	false
8efaf6f4-c268-45d4-8904-1e3647344533	2026-08-19 09:48	2026-08-19 09:48	2026-08-19 09:48	SOXX	SOXX260821P00515000	put	515.0000	2026-08-21	3.8000	3.1000	3.8000	527.0500	38000.00	38000.00	0.00	100	8	169	2806	0.0602280826799715	0.554934408859994	0.554934408859994	false	false	false	true	false
96977c30-25ec-4be2-8fea-08aab717a61d	2026-08-19 09:55	2026-08-19 09:55	2026-08-19 09:55	SOXX	SOXX260828P00500000	put	500.0000	2026-08-28	7.2000	6.5000	7.8000	520.5500	316800.00	244800.00	72000.00	440	6	466	2485	0.187525150905433	0.483960004139355	0.485082640119973	false	false	false	true	false
12575119-3745-4ab9-8515-239fb667a8b9	2026-08-19 10:07	2026-08-19 10:06	2026-08-19 10:06	SOXX	SOXX260828C00560000	call	560.0000	2026-08-28	2.8000	2.8000	3.4000	519.5900	452206.00	0.00	452206.00	1615	50	1639	112	14.6339285714286	0.444820257684288	0.444820257684288	false	false	false	true	false
f2083a01-26dc-428e-ac0e-1955b5037684	2026-08-19 10:10	2026-08-19 10:10	2026-08-19 10:10	SOXX	SOXX260918P00480000	put	480.0000	2026-09-18	11.5000	11.5000	12.2000	517.6700	16100.00	0.00	16100.00	14	13	948	2098	0.451858913250715	0.467925056448264	0.467925056448264	false	false	false	true	false
ba6f67aa-6c3f-4f5a-a208-18502f188bb8	2026-08-19 10:10	2026-08-19 10:10	2026-08-19 10:10	SOXX	SOXX260821P00515000	put	515.0000	2026-08-21	7.0000	5.7000	7.0000	517.7100	10500.00	10500.00	0.00	15	8	190	2806	0.067712045616536	0.546554035170909	0.546554035170909	false	false	false	true	false
c8f4026b-75d5-4ea8-9623-ed9438222ee7	2026-08-19 10:19	2026-08-19 10:19	2026-08-19 10:19	SOXX	SOXX260918C00565000	call	565.0000	2026-09-18	9.1000	8.7000	9.4000	515.6817	1326780.00	97370.00	1229410.00	1458	19	1459	405	3.60246913580247	0.427203148909568	0.427203148909568	false	false	false	true	false
5d2e5993-cde6-4c49-b331-da9d03a3c602	2026-08-19 10:21	2026-08-19 10:20	2026-08-19 10:20	SOXX	SOXX260918P00480000	put	480.0000	2026-09-18	11.2000	11.2000	11.6000	517.6700	112000.00	0.00	112000.00	100	8	1053	2098	0.501906577693041	0.461637799643733	0.461637799643733	false	false	false	true	false
427f1a89-c5ed-4960-b472-072a5e5de814	2026-08-19 10:29	2026-08-19 10:29	2026-08-19 10:29	SOXX	SOXX260821C00480000	call	480.0000	2026-08-21	39.9000	39.0000	39.9000	519.0900	35909.00	35909.00	0.00	9	6	19	47	0.404255319148936	0.695317035919562	0.695317035919562	false	false	false	true	false
4374830f-8cff-44c1-93e9-df5bb40a88c0	2026-08-19 10:32	2026-08-19 10:31	2026-08-19 10:31	SOXX	SOXX260918C00535000	call	535.0000	2026-09-18	20.0000	17.7000	20.0000	520.4700	12000.00	12000.00	0.00	6	5	6	64	0.09375	0.43054383572698	0.43054383572698	false	false	false	true	false
96ec5341-52db-4ddb-a5b1-3b1203ddb433	2026-08-19 10:37	2026-08-19 10:36	2026-08-19 10:36	SOXX	SOXX261218P00475000	put	475.0000	2026-12-18	32.0000	30.6000	33.5000	520.6400	16000.00	3200.00	9600.00	5	5	10	454	0.0220264317180617	0.477064522215907	0.477064522215907	false	false	false	true	false
83c80029-87c8-4fed-bbbe-a26ead71a4f9	2026-08-19 10:39	2026-08-19 10:39	2026-08-19 10:39	SOXX	SOXX260918P00520000	put	520.0000	2026-09-18	24.0000	23.1000	24.9000	523.2000	62400.00	0.00	45600.00	26	6	68	2741	0.0248084640642101	0.442449251377005	0.442449251377005	false	false	false	true	false
b31a509c-c62e-4476-8080-50361773520a	2026-08-19 10:39	2026-08-19 10:39	2026-08-19 10:39	SOXX	SOXX260918P00520000	put	520.0000	2026-09-18	24.0000	23.3000	24.9000	523.1400	417600.00	0.00	417600.00	174	5	242	2741	0.0882889456402773	0.441997912848304	0.441997912848304	false	false	false	true	false
3a537dfb-c279-4835-8462-ab56f663464f	2026-08-19 10:42	2026-08-19 10:42	2026-08-19 10:42	SOXX	SOXX260821P00485000	put	485.0000	2026-08-21	0.5000	0.5000	0.7500	522.5950	62633.00	0.00	62633.00	1252	51	1281	785	1.63184713375796	0.620371906079552	0.620371906079552	false	false	false	true	false
91322d2c-71f5-465d-8df4-ac6e1a4f8de5	2026-08-19 10:55	2026-08-19 10:55	2026-08-19 10:55	SOXX	SOXX260821C00550000	call	550.0000	2026-08-21	0.9000	0.7500	0.9000	521.6050	15120.00	15120.00	0.00	168	17	684	13665	0.0500548847420417	0.535124775140991	0.535124775140991	false	false	false	true	false
413ab4d9-88b9-45b5-b7d8-c2fada3b5077	2026-08-19 11:21	2026-08-19 11:21	2026-08-19 11:21	SOXX	SOXX260828P00500000	put	500.0000	2026-08-28	6.3000	6.3000	7.7000	522.2550	20160.00	0.00	20160.00	32	5	564	2485	0.226961770623742	0.46893993008432	0.46893993008432	false	false	false	true	false
fd1cc887-e709-4df6-8884-95d8ab46ed43	2026-08-19 11:41	2026-08-19 11:41	2026-08-19 11:41	SOXX	SOXX260918P00480000	put	480.0000	2026-09-18	10.7600	10.5000	11.5000	520.2500	10758.00	0.00	10758.00	10	6	1711	2098	0.815538608198284	0.465728199425485	0.465728199425485	false	false	false	true	false
f2b31807-dc40-41a0-976d-becd3e122024	2026-08-19 11:46	2026-08-19 11:46	2026-08-19 11:46	SOXX	SOXX261002P00542500	put	542.5000	2026-10-02	41.9000	40.1000	41.9000	521.6750	20950.00	20950.00	0.00	5	5	5	0	0	0.434286354801701	0.434286354801701	false	false	false	true	false
343eff27-43b2-4d98-9e3c-388bf7850ab3	2026-08-19 11:52	2026-08-19 11:52	2026-08-19 11:52	SOXX	SOXX260918P00480000	put	480.0000	2026-09-18	10.8800	10.6000	11.0000	520.3600	13055.00	13055.00	0.00	12	5	1736	2098	0.82745471877979	0.468651052851502	0.468651052851502	false	false	false	true	false
2e0e7149-5b38-4808-9c3b-df3002d5d149	2026-08-19 12:05	2026-08-19 12:05	2026-08-19 12:05	SOXX	SOXX260918P00520000	put	520.0000	2026-09-18	24.0000	23.5000	25.0000	522.7800	72000.00	12000.00	60000.00	30	5	1782	2741	0.65012769062386	0.439282379348069	0.439282379348069	true	false	false	true	false
18a406c0-807d-4dc3-88c4-a24c263a9b62	2026-08-19 12:06	2026-08-19 12:06	2026-08-19 12:06	SOXX	SOXX260918P00520000	put	520.0000	2026-09-18	23.8000	23.8000	25.0000	523.1750	254660.00	0.00	254660.00	107	9	1889	2741	0.689164538489602	0.43888780556447	0.43888780556447	false	false	false	true	false
64f5e71c-aa7b-4e75-bbee-b048b2bb8725	2026-08-19 12:08	2026-08-19 12:08	2026-08-19 12:08	SOXX	SOXX260828C00560000	call	560.0000	2026-08-28	3.4000	2.7000	3.4000	523.6200	60860.00	60860.00	0.00	179	21	1835	112	16.3839285714286	0.441526479862046	0.441526479862046	false	false	false	true	false
ba68fb83-6497-42e2-b450-7d0e4ec696a5	2026-08-19 12:19	2026-08-19 12:19	2026-08-19 12:19	SOXX	SOXX260918P00495000	put	495.0000	2026-09-18	13.9400	12.9000	14.6000	523.7950	29269.00	29269.00	0.00	21	5	433	2364	0.183164128595601	0.453883178412059	0.453883178412059	false	false	false	true	false
b7c836d9-0514-439a-a6f5-819a9e8fc59a	2026-08-19 12:20	2026-08-19 12:20	2026-08-19 12:20	SOXX	SOXX270617P00300000	put	300.0000	2027-06-17	10.5000	8.9000	12.7000	523.8200	31500.00	4200.00	27300.00	30	5	30	1830	0.0163934426229508	0.540186946119682	0.540186946119682	false	false	false	true	false
02a99e28-a994-4838-9240-2b62ca746dad	2026-08-19 12:22	2026-08-19 12:22	2026-08-19 12:22	SOXX	SOXX260918P00495000	put	495.0000	2026-09-18	14.1500	13.0000	14.6000	523.0650	32540.00	32540.00	0.00	23	5	456	2364	0.192893401015228	0.4536810872314	0.4536810872314	false	false	false	true	false
c4c450e0-1ea0-45f1-9ac2-1482fdef6550	2026-08-19 12:39	2026-08-19 12:39	2026-08-19 12:39	SOXX	SOXX260821P00515000	put	515.0000	2026-08-21	4.0000	4.0000	5.0000	523.7100	40800.00	0.00	40800.00	102	6	354	2806	0.12615823235923	0.49624749282725	0.49624749282725	false	false	false	true	false
3886cd8e-507f-4220-af97-0694482884e7	2026-08-19 12:41	2026-08-19 12:40	2026-08-19 12:40	SOXX	SOXX270617P00500000	put	500.0000	2027-06-17	66.6400	66.5000	70.3000	523.7500	666394.00	0.00	666394.00	100	6	106	3549	0.0298675683291068	0.470576572584789	0.469493831969199	false	false	false	true	false
230d3656-9f64-4b8f-a8e1-396a576db01c	2026-08-19 12:52	2026-08-19 12:52	2026-08-19 12:52	SOXX	SOXX260918P00480000	put	480.0000	2026-09-18	10.2600	10.0000	11.1000	522.5150	12312.00	0.00	12312.00	12	6	1888	2098	0.899904671115348	0.466412768415122	0.466412768415122	false	false	false	true	false
da09ac6b-0b5b-48da-b5e8-6cd337978e5e	2026-08-19 13:02	2026-08-19 13:02	2026-08-19 13:02	SOXX	SOXX260828P00460000	put	460.0000	2026-08-28	1.1000	1.1000	1.4000	521.4200	173690.00	0.00	173690.00	1579	45	1588	232	6.8448275862069	0.525056166290678	0.525056166290678	false	false	false	true	false
a9f41321-297b-4676-bd2b-d88c8fe41b10	2026-08-19 13:11	2026-08-19 13:11	2026-08-19 13:11	SOXX	SOXX270917P00400000	put	400.0000	2027-09-17	38.0000	37.4000	40.6000	520.9900	950000.00	0.00	950000.00	250	1	251	5	50.2	0.49552609996199	0.49552609996199	false	true	false	true	true
50822e2c-9d69-41cb-97db-33928fff26c3	2026-08-19 13:12	2026-08-19 13:12	2026-08-19 13:12	SOXX	SOXX280616P00250000	put	250.0000	2028-06-16	17.9000	15.8000	17.9000	520.7400	17900.00	17900.00	0.00	10	6	10	27	0.37037037037037	0.556417388619535	0.556417388619535	false	false	false	true	false
54d1bc88-cf18-4618-bbdc-d47bfc6d4116	2026-08-19 13:19	2026-08-19 13:19	2026-08-19 13:19	SOXX	SOXX260828C00565000	call	565.0000	2026-08-28	2.0500	2.0000	2.4000	520.5200	199277.00	410.00	198867.00	972	43	974	264	3.68939393939394	0.42999257789038	0.42999257789038	false	false	false	true	false
e06e90a8-cfcc-458b-b197-68bd92adc13b	2026-08-19 13:35	2026-08-19 13:35	2026-08-19 13:35	SOXX	SOXX260918P00495000	put	495.0000	2026-09-18	14.8000	14.5000	14.8000	520.1450	34040.00	34040.00	0.00	23	6	977	2364	0.413282571912014	0.448799886000845	0.448799886000845	false	false	false	true	false
e8381881-4bbb-4339-8a82-7fbc2ecce93d	2026-08-19 13:48	2026-08-19 13:48	2026-08-19 13:48	SOXX	SOXX260918P00495000	put	495.0000	2026-09-18	14.7000	14.7000	15.0000	520.0700	35280.00	0.00	17640.00	24	5	1078	2364	0.456006768189509	0.446470768165954	0.446470768165954	false	false	false	true	false
b90e9ce8-b4f1-4093-9482-5b7d3d06f8c4	2026-08-19 13:58	2026-08-19 13:58	2026-08-19 13:58	SOXX	SOXX260918C00580000	call	580.0000	2026-09-18	6.2000	6.2000	6.9000	519.7600	1379500.00	0.00	1379500.00	2225	34	2263	181	12.5027624309392	0.405451368979002	0.405451368979002	false	false	false	true	false
c2f7ae57-42e7-43cc-8da5-1fc047530fcc	2026-08-19 14:24	2026-08-19 14:24	2026-08-19 14:24	SOXX	SOXX261016P00425000	put	425.0000	2026-10-16	8.4000	6.4000	8.4000	517.9300	58800.00	58800.00	0.00	70	9	70	344	0.203488372093023	0.521961733706151	0.521961733706151	false	false	false	true	false
0dca2393-7962-4785-9359-f5be7158915a	2026-08-19 14:31	2026-08-19 14:31	2026-08-19 14:31	SOXX	SOXX261218C00500000	call	500.0000	2026-12-18	66.9500	64.1000	68.2000	520.0750	33475.00	33475.00	0.00	5	5	23	293	0.0784982935153584	0.453103475161076	0.453103475161076	false	false	false	true	false
c39b5b19-2755-405c-b448-ad58078eb8c1	2026-08-19 14:34	2026-08-19 14:34	2026-08-19 14:34	SOXX	SOXX260821P00500000	put	500.0000	2026-08-21	1.2500	1.2500	1.5000	521.2050	71003.00	0.00	71003.00	568	28	799	6167	0.129560564293822	0.50293304224758	0.50293304224758	false	false	false	true	false
5f9fdc90-7f32-4d4f-9d3b-32673a4cf75b	2026-08-19 14:40	2026-08-19 14:40	2026-08-19 14:40	SOXX	SOXX260918C00580000	call	580.0000	2026-09-18	6.2000	6.2000	6.8000	519.6750	14880.00	0.00	14880.00	24	6	2291	181	12.6574585635359	0.405855036165932	0.405855036165932	false	false	false	true	false
102b97bc-d459-48ac-b324-133ade70a989	2026-08-19 14:45	2026-08-19 14:45	2026-08-19 14:45	SOXX	SOXX260904C00610000	call	610.0000	2026-09-04	0.8500	0.8500	1.0500	520.7200	14458.00	0.00	14458.00	170	32	170	17	10	0.430841402203499	0.430841402203499	false	false	false	true	false