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:source = uw_flow_alerts×ticker = AAPL×

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

57e76ea6-a674-4c1d-b6f6-3a89e9c87e31	2026-09-30 10:32	2026-09-30 10:32	2026-09-30 10:32	AAPL	AAPL280616P00140000	put	140.0000	2028-06-16	1.0900	0.8100	1.0900	338.2699	65826.00	64746.00	1080.00	604	25	614	2	307	0.384764357352875	0.385359420876066	false	false	false	true	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	Common Stock	Technology	4807322892000.00	2026-10-29	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-30T14:34:34.200174Z"}	2026-09-30	2026-09-30 21:15	2026-09-30 21:15
8eac045d-9669-4983-b671-9c37923617d8	2026-09-30 10:32	2026-09-30 10:31	2026-09-30 10:31	AAPL	AAPL280121C00350000	call	350.0000	2028-01-21	46.5700	45.1000	47.0000	338.2001	232868.00	232868.00	0.00	50	6	216	8098	0.0266732526549765	0.273421031131595	0.273421031131595	false	false	false	true
70fa4dbd-70f3-4d1b-992c-882ab5053b78	2026-09-30 10:32	2026-09-30 10:31	2026-09-30 10:31	AAPL	AAPL260930C00340000	call	340.0000	2026-09-30	0.5400	0.5300	0.5500	338.2600	30401.00	54.00	30347.00	563	8	95392	11310	8.4343059239611	0.359285717185169	0.35580217713082	true	false	false	true
78603806-d1ff-42b2-b6f0-e7a1fdd2744c	2026-09-30 10:32	2026-09-30 10:31	2026-09-30 10:31	AAPL	AAPL260930C00340000	call	340.0000	2026-09-30	0.5400	0.5300	0.5500	338.2600	10152.00	756.00	540.00	188	7	94817	11310	8.38346595932803	0.359276548289374	0.359276548289374	true	false	false	true
c9522e16-0a43-473c-9996-62a3b2f23e28	2026-09-30 10:31	2026-09-30 10:31	2026-09-30 10:31	AAPL	AAPL260930C00337500	call	337.5000	2026-09-30	1.6400	1.6000	1.6400	338.2150	13933.00	13933.00	0.00	85	16	79262	14542	5.45055700728923	0.363499397645135	0.369601658115822	true	false	false	true
9ccc8616-cbdc-4fea-9ed4-eff3dde596f1	2026-09-30 10:31	2026-09-30 10:31	2026-09-30 10:31	AAPL	AAPL280121C00350000	call	350.0000	2028-01-21	46.5300	45.1000	47.0000	338.2100	349010.00	349010.00	0.00	75	17	91	8098	0.011237342553717	0.272779758385568	0.272779758385568	false	false	false	true
c1f5f333-f2fe-4564-b348-201598ba0451	2026-09-30 10:31	2026-09-30 10:31	2026-09-30 10:31	AAPL	AAPL260930C00340000	call	340.0000	2026-09-30	0.4200	0.4000	0.4200	337.8200	31784.00	31623.00	120.00	757	6	93392	11310	8.25747126436782	0.357096308021704	0.353270244101924	true	false	false	true
6a0a38c3-81db-4b0a-9b8f-81e4ce54f6bb	2026-09-30 10:30	2026-09-30 10:30	2026-09-30 10:30	AAPL	AAPL260930C00332500	call	332.5000	2026-09-30	5.7600	5.7000	5.9500	338.2100	11526.00	0.00	11526.00	20	5	45394	9581	4.73791879762029	0.545238016025321	0.387630563893334	false	false	false	true
a0f4feed-8066-40d9-afb6-4c7776aed564	2026-09-30 10:30	2026-09-30 10:30	2026-09-30 10:30	AAPL	AAPL260930P00335000	put	335.0000	2026-09-30	0.2600	0.2500	0.2600	338.2200	12740.00	12740.00	0.00	490	23	46142	3066	15.0495759947815	0.378814724925449	0.378814724925449	false	false	false	true
62bf5a05-4a6e-4642-b3ea-864329a90660	2026-09-30 10:30	2026-09-30 10:30	2026-09-30 10:30	AAPL	AAPL261009C00335000	call	335.0000	2026-10-09	7.2000	6.9500	7.9000	338.3000	10080.00	3600.00	6480.00	14	5	1200	2517	0.476758045292014	0.247668388571996	0.245845354279242	false	false	false	true
43b07bb2-60ce-439e-8857-2b99be142752	2026-09-30 10:29	2026-09-30 10:28	2026-09-30 10:28	AAPL	AAPL260930C00337500	call	337.5000	2026-09-30	1.2900	1.2700	1.3500	337.6300	14819.00	396.00	14423.00	115	49	77973	14542	5.36191720533627	0.357245011171559	0.360806570367587	false	false	false	true
255f7150-1ec8-4706-aea1-e208aef67dde	2026-09-30 10:28	2026-09-30 10:28	2026-09-30 10:28	AAPL	AAPL261002C00340000	call	340.0000	2026-10-02	2.1600	2.1600	2.1800	338.0500	16417.00	0.00	16417.00	76	5	18167	14358	1.26528764451874	0.301194441088154	0.300164118194931	true	false	false	true
237bbdb6-6234-4104-b6f9-a902a7247798	2026-09-30 10:28	2026-09-30 10:28	2026-09-30 10:28	AAPL	AAPL261002P00340000	put	340.0000	2026-10-02	3.9500	3.8500	3.9500	338.1300	18960.00	18960.00	0.00	48	9	4991	3920	1.27321428571429	0.296320404083035	0.296320404083035	false	false	false	true
7d272509-094b-49b3-805e-914bb8da358d	2026-09-30 10:28	2026-09-30 10:28	2026-09-30 10:28	AAPL	AAPL260930C00335000	call	335.0000	2026-09-30	3.4000	3.3000	3.5000	338.1050	21080.00	4080.00	17000.00	62	6	93222	11968	7.78927139037433	0.385083173346537	0.381172946001211	false	false	false	true
c38d7c26-7db5-4a58-a838-10b198a1c11e	2026-09-30 10:26	2026-09-30 10:26	2026-09-30 10:26	AAPL	AAPL261002C00345000	call	345.0000	2026-10-02	0.6900	0.6700	0.6900	337.7900	12075.00	12075.00	0.00	175	17	10491	13635	0.769416941694169	0.29757957044898	0.29757957044898	false	false	false	true
edede524-f9e2-431a-8443-89032cc9a7c7	2026-09-30 10:26	2026-09-30 10:26	2026-09-30 10:26	AAPL	AAPL260930C00342500	call	342.5000	2026-09-30	0.1300	0.1200	0.1300	337.9200	13013.00	13013.00	0.00	1001	31	43326	8320	5.20745192307692	0.388735177705264	0.388735177705264	true	false	false	true
b5a0c5d1-57ea-48cb-aa65-6f7aa83fc9ff	2026-09-30 10:26	2026-09-30 10:25	2026-09-30 10:25	AAPL	AAPL260930P00337500	put	337.5000	2026-09-30	1.1500	1.1500	1.1700	337.8200	10580.00	0.00	10580.00	92	12	21763	2108	10.3240037950664	0.385105874941423	0.385105874941423	true	false	false	true
ae101b75-c5c9-4ca8-9467-c66d9a8017da	2026-09-30 10:25	2026-09-30 10:25	2026-09-30 10:25	AAPL	AAPL260930P00340000	put	340.0000	2026-09-30	2.6800	2.5900	2.6800	337.8300	13400.00	13400.00	0.00	50	6	4536	292	15.5342465753425	0.389778034653024	0.389778034653024	false	false	false	true
bfab1df7-e857-47ed-9183-2eab7062dc12	2026-09-30 10:25	2026-09-30 10:25	2026-09-30 10:25	AAPL	AAPL280121C00420000	call	420.0000	2028-01-21	20.7500	20.4000	20.7500	337.7100	20750.00	20750.00	0.00	10	6	22	3507	0.00627316794981466	0.259921002519257	0.259921002519257	false	false	false	true
0bb2693f-b949-4ee4-9fae-84da3afc0626	2026-09-30 10:24	2026-09-30 10:24	2026-09-30 10:24	AAPL	AAPL261002P00337500	put	337.5000	2026-10-02	2.8400	2.7800	2.8400	337.7300	23004.00	23004.00	0.00	81	11	5667	1830	3.09672131147541	0.299923554896797	0.299923554896797	false	false	false	true
0e02a77f-5670-4876-9349-51c597138c0c	2026-09-30 10:24	2026-09-30 10:24	2026-09-30 10:24	AAPL	AAPL260930C00340000	call	340.0000	2026-09-30	0.4500	0.4500	0.4700	337.7650	12199.00	0.00	12015.00	271	15	86941	11310	7.68709106984969	0.369932113993311	0.369932113993311	false	false	false	true
283d4dfe-0a13-476e-a9f5-fb7dea6af0df	2026-09-30 10:24	2026-09-30 10:24	2026-09-30 10:24	AAPL	AAPL260930C00337500	call	337.5000	2026-09-30	1.4800	1.4300	1.4900	337.8900	15954.00	14348.00	1606.00	108	10	76357	14542	5.25079081281804	0.367366357563785	0.370327696238448	true	false	false	true
b5a6f00a-ce68-462d-afab-64e86f907e1a	2026-09-30 10:23	2026-09-30 10:23	2026-09-30 10:23	AAPL	AAPL261016P00325000	put	325.0000	2026-10-16	2.1500	2.1500	2.1800	337.7900	17845.00	0.00	17845.00	83	5	383	6361	0.060210658701462	0.24804738541747	0.24804738541747	false	false	false	true
2e161544-30a6-4e42-8fc7-67f3d76ee7bc	2026-09-30 10:23	2026-09-30 10:23	2026-09-30 10:23	AAPL	AAPL261016P00330000	put	330.0000	2026-10-16	3.3000	3.2000	3.3000	338.0900	18810.00	18810.00	0.00	57	12	2048	11182	0.183151493471651	0.242945981940557	0.242945981940557	true	false	false	true
7ceb1599-b46c-40c5-bac0-579622718482	2026-09-30 10:23	2026-09-30 10:23	2026-09-30 10:23	AAPL	AAPL260930C00340000	call	340.0000	2026-09-30	0.6000	0.5800	0.6000	338.0989	17633.00	17399.00	116.00	294	13	84775	11310	7.49557913351017	0.384147713830214	0.391015259824792	false	false	false	true
515a45cc-f264-443c-9020-0176311041d6	2026-09-30 10:22	2026-09-30 10:22	2026-09-30 10:22	AAPL	AAPL261002C00342500	call	342.5000	2026-10-02	1.2700	1.2650	1.3100	337.8900	20955.00	0.00	20955.00	165	16	10725	12295	0.872305815372102	0.299579074947201	0.299579074947201	true	false	false	true
eb4f6d32-74ff-40a1-972c-ed466d05bc59	2026-09-30 10:22	2026-09-30 10:21	2026-09-30 10:21	AAPL	AAPL260930C00340000	call	340.0000	2026-09-30	0.5100	0.5100	0.5300	337.8150	15873.00	53.00	15300.00	311	7	82827	11310	7.32334217506631	0.385867707699753	0.38948730990521	false	false	false	true
f8970478-69ed-48ca-8dfc-30aa9edbc533	2026-09-30 10:22	2026-09-30 10:21	2026-09-30 10:21	AAPL	AAPL261002P00337500	put	337.5000	2026-10-02	2.7600	2.7200	2.7600	337.8750	24012.00	24012.00	0.00	87	11	5495	1830	3.00273224043716	0.29881319504116	0.29881319504116	false	false	false	true
3dee7cc4-047b-4204-8a26-5892fe181e02	2026-09-30 10:21	2026-09-30 10:21	2026-09-30 10:21	AAPL	AAPL261009C00337500	call	337.5000	2026-10-09	5.5000	5.4500	5.6500	337.8110	13750.00	0.00	13750.00	25	5	615	1767	0.34804753820034	0.242576745444355	0.244555830909085	false	false	false	true
8b8dbe87-4c1b-4304-89d9-dafc12d4a920	2026-09-30 10:21	2026-09-30 10:21	2026-09-30 10:21	AAPL	AAPL261016C00330000	call	330.0000	2026-10-16	11.9500	11.8500	11.9500	337.9650	47800.00	47800.00	0.00	40	14	1343	13772	0.0975167005518443	0.245548829335778	0.245548829335778	false	false	false	true
5f442612-a0dc-486a-93e0-8e66c073bb1e	2026-09-30 10:21	2026-09-30 10:21	2026-09-30 10:21	AAPL	AAPL261016P00310000	put	310.0000	2026-10-16	0.5500	0.5400	0.6000	337.9250	25135.00	880.00	23705.00	457	28	724	12337	0.0586852557347816	0.27959665450258	0.27959665450258	false	false	false	true
f8fcdc41-170f-41da-bd88-86e621a550d2	2026-09-30 10:21	2026-09-30 10:21	2026-09-30 10:21	AAPL	AAPL261016P00300000	put	300.0000	2026-10-16	0.2800	0.2800	0.3000	337.8897	10640.00	0.00	10640.00	380	30	721	26059	0.0276679841897233	0.315666464711013	0.315538936983212	false	false	false	true
d3dcf1d0-2990-4e87-8966-2d2c90854bac	2026-09-30 10:21	2026-09-30 10:21	2026-09-30 10:21	AAPL	AAPL261016P00305000	put	305.0000	2026-10-16	0.3800	0.3800	0.4500	337.8650	18963.00	39.00	18924.00	499	53	1403	11858	0.118316748186878	0.295754548163124	0.295754548163124	false	false	false	true
1a1c4b58-2f6d-4e96-bb67-5bd796ecf103	2026-09-30 10:21	2026-09-30 10:21	2026-09-30 10:21	AAPL	AAPL261005P00325000	put	325.0000	2026-10-05	0.4000	0.4000	0.4900	337.8550	13680.00	0.00	13680.00	342	42	885	1497	0.591182364729459	0.249839858963402	0.249839858963402	false	false	false	true
190e9567-a26a-4add-8a2c-f42d857f6223	2026-09-30 10:21	2026-09-30 10:21	2026-09-30 10:21	AAPL	AAPL281215C00600000	call	600.0000	2028-12-15	8.9300	8.5500	9.0000	337.9100	16960.00	8950.00	8010.00	19	7	21	4393	0.00478033234691555	0.259295497747404	0.258877086948765	false	false	false	true
96d1b3c9-dfd4-4bff-80f7-ffdd12c68916	2026-09-30 10:20	2026-09-30 10:20	2026-09-30 10:20	AAPL	AAPL261218P00310000	put	310.0000	2026-12-18	5.5300	5.4000	5.5500	337.7400	49751.00	49751.00	0.00	90	8	306	13544	0.0225930301240402	0.276636997881134	0.27575624061768	false	false	false	true
6a876346-34f6-46c7-a5f4-493c9430e2d4	2026-09-30 10:20	2026-09-30 10:20	2026-09-30 10:20	AAPL	AAPL261005C00345000	call	345.0000	2026-10-05	1.0700	1.0100	1.0700	337.4750	13692.00	13480.00	212.00	128	7	1018	523	1.94646271510516	0.225701785699322	0.22684295680062	false	false	false	true
3e6032cc-9100-4eac-a522-916a95e07739	2026-09-30 10:20	2026-09-30 10:20	2026-09-30 10:20	AAPL	AAPL261007P00330000	put	330.0000	2026-10-07	1.7500	1.6000	1.7500	337.4531	26250.00	26250.00	0.00	150	5	325	241	1.34854771784232	0.250490381698367	0.250490381698367	false	false	false	true
403e3aeb-984a-46b8-a506-e9b4f773e913	2026-09-30 10:20	2026-09-30 10:20	2026-09-30 10:20	AAPL	AAPL260930C00337500	call	337.5000	2026-09-30	1.3300	1.3100	1.3500	337.5450	19950.00	14098.00	5852.00	150	6	71998	14542	4.95103837161326	0.376769194610301	0.38047872761563	false	false	false	true
0f07df67-60a7-4cf0-8f28-980a17ece488	2026-09-30 10:20	2026-09-30 10:19	2026-09-30 10:19	AAPL	AAPL260930P00337500	put	337.5000	2026-09-30	1.3000	1.2900	1.3300	337.5500	18587.00	0.00	18587.00	143	12	20302	2108	9.63092979127135	0.377800769124597	0.385147667184851	true	false	false	true
62fe39d7-4582-4476-b9b0-267ac8194a66	2026-09-30 10:19	2026-09-30 10:19	2026-09-30 10:19	AAPL	AAPL261002C00340000	call	340.0000	2026-10-02	1.9500	1.9100	1.9700	337.4800	19510.00	19510.00	0.00	100	5	16916	14358	1.17815851789943	0.302454225385867	0.301543856464787	false	false	false	true
9809471f-747a-47fd-ad3f-6030953638f7	2026-09-30 10:19	2026-09-30 10:19	2026-09-30 10:19	AAPL	AAPL260930C00340000	call	340.0000	2026-09-30	0.4200	0.4000	0.4300	337.3756	10525.00	10483.00	0.00	253	5	78701	11310	6.95853227232538	0.382956722092357	0.389867471853166	true	false	false	true
39011c4d-819f-4efb-b635-39dfee3053bf	2026-09-30 10:19	2026-09-30 10:19	2026-09-30 10:19	AAPL	AAPL260930P00337500	put	337.5000	2026-09-30	1.3900	1.3800	1.4200	337.2700	18209.00	1390.00	16819.00	131	15	19992	2108	9.48387096774194	0.376262961910035	0.372432690903229	false	false	false	true
a50d9878-3bbb-4f3d-a832-ff207c0f86be	2026-09-30 10:19	2026-09-30 10:19	2026-09-30 10:19	AAPL	AAPL270617C00400000	call	400.0000	2027-06-17	12.1000	11.8500	12.2500	337.2450	12100.00	9680.00	2420.00	10	5	37	5902	0.00626906133514063	0.253886418817417	0.253796216443782	false	false	false	true
add42e79-d4bf-41c0-99bc-e2c87f15d303	2026-09-30 10:19	2026-09-30 10:19	2026-09-30 10:19	AAPL	AAPL261218P00320000	put	320.0000	2026-12-18	8.1500	8.1500	8.2500	337.0700	61940.00	0.00	61940.00	76	5	192	4137	0.0464104423495286	0.267569181076063	0.267569181076063	false	false	false	true
a79e1c56-50af-4c36-8f8c-f7918c9a52ff	2026-09-30 10:18	2026-09-30 10:18	2026-09-30 10:18	AAPL	AAPL281215C00400000	call	400.0000	2028-12-15	45.2000	44.6000	45.6500	337.1700	22600.00	22600.00	0.00	5	5	9	4967	0.00181195892893094	0.270372880676823	0.270372880676823	false	false	false	true
0f60d8a7-acca-4cab-9d2c-39cf60d4128b	2026-09-30 10:17	2026-09-30 10:17	2026-09-30 10:17	AAPL	AAPL261016P00330000	put	330.0000	2026-10-16	3.4100	3.3500	3.5000	337.6400	11596.00	9207.00	2389.00	34	14	1974	11182	0.176533714898945	0.242244240962508	0.241524426871495	false	false	false	true
8e59886f-5e8d-41f8-8bd6-d7424d657b00	2026-09-30 10:17	2026-09-30 10:17	2026-09-30 10:17	AAPL	AAPL260930P00335000	put	335.0000	2026-09-30	0.4300	0.4300	0.4500	337.4450	13294.00	135.00	13159.00	309	8	38771	3066	12.6454664057404	0.383660501169989	0.381565210301996	true	false	false	true
ef7517b1-bed8-40e3-bdbd-b883921fd160	2026-09-30 10:17	2026-09-30 10:17	2026-09-30 10:17	AAPL	AAPL261002C00345000	call	345.0000	2026-10-02	0.6300	0.6100	0.6300	337.3450	56700.00	56700.00	0.00	900	8	9110	13635	0.668133480014668	0.300303813352755	0.299907865706766	false	false	false	true
3c84c64c-67b9-4fa2-8d8f-a00915f55208	2026-09-30 10:17	2026-09-30 10:17	2026-09-30 10:17	AAPL	AAPL260930P00337500	put	337.5000	2026-09-30	1.5200	1.4700	1.5500	337.1600	20228.00	4950.00	1508.00	133	10	19145	2108	9.08206831119545	0.386365799942676	0.386375123759383	true	false	false	true