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

622a02b2-aefe-4f44-95c0-aa48bc1391cb	2026-09-30 11:00	2026-09-30 11:00	2026-09-30 11:00	AAPL	AAPL260930P00337500	put	337.5000	2026-09-30	0.8100	0.8000	0.8100	338.1900	12959.00	12879.00	80.00	160	9	39234	2108	18.611954459203	0.351619073887081	0.349695019859187	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Technology	4807322892000.00	2026-10-29	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-30T15:01:09.896408Z"}	2026-09-30	2026-09-30 21:15	2026-09-30 21:15
e46bfb6b-d6b3-4ac9-aced-359e7e0a5485	2026-09-30 11:00	2026-09-30 11:00	2026-09-30 11:00	AAPL	AAPL270416C00330000	call	330.0000	2027-04-16	35.0000	34.7000	35.4500	338.3800	28000.00	0.00	28000.00	8	8	29	188	0.154255319148936	0.267817828746372	0.267817828746372	false	false	false	true
0ec97bc1-a9c3-4d0b-9214-c19db745ef1c	2026-09-30 11:00	2026-09-30 11:00	2026-09-30 11:00	AAPL	AAPL261002C00340000	call	340.0000	2026-10-02	2.2400	2.2400	2.2800	338.3700	18592.00	0.00	18592.00	83	7	24388	14358	1.69856525978549	0.294799060359216	0.294799060359216	true	false	false	true
e8533501-3ee2-44e8-b8db-03a3b409ae15	2026-09-30 10:59	2026-09-30 10:59	2026-09-30 10:59	AAPL	AAPL260930C00340000	call	340.0000	2026-09-30	0.4800	0.4700	0.5000	338.4000	24001.00	23952.00	49.00	500	27	145978	11310	12.9069849690539	0.341381865559122	0.342966970363415	false	false	false	true
96f064f7-eaa3-4bca-aca0-471582b50267	2026-09-30 10:59	2026-09-30 10:59	2026-09-30 10:59	AAPL	AAPL260930C00332500	call	332.5000	2026-09-30	5.8100	5.8000	6.0500	338.3700	40674.00	0.00	40674.00	70	5	45861	9581	4.78666110009394	0.538408945750902	0.442734063423174	false	false	false	true
2d6341b3-38d4-43d3-8fc6-c6804b243cc2	2026-09-30 10:59	2026-09-30 10:59	2026-09-30 10:59	AAPL	AAPL261005C00345000	call	345.0000	2026-10-05	1.1600	1.1600	1.2700	338.3800	14736.00	0.00	14736.00	127	14	1849	523	3.53537284894837	0.217367160525894	0.217367160525894	false	false	false	true
206e2a43-8173-480e-b15f-f1f7394022aa	2026-09-30 10:58	2026-09-30 10:58	2026-09-30 10:58	AAPL	AAPL260930P00340000	put	340.0000	2026-09-30	1.9500	1.9000	1.9600	338.6150	15028.00	15028.00	0.00	77	5	8756	292	29.986301369863	0.347725049325684	0.35217596027716	true	false	false	true
60e9f848-7603-40b3-97e5-9559845710d3	2026-09-30 10:57	2026-09-30 10:57	2026-09-30 10:57	AAPL	AAPL260930C00342500	call	342.5000	2026-09-30	0.1500	0.1400	0.1600	338.7400	11982.00	32.00	3490.00	802	27	63399	8320	7.62007211538462	0.365394819319427	0.359339552122055	true	false	false	true
b53e545c-0c92-4aad-a4f7-2b642bc96197	2026-09-30 10:57	2026-09-30 10:57	2026-09-30 10:57	AAPL	AAPL261002C00340000	call	340.0000	2026-10-02	2.3500	2.3200	2.3700	338.6700	32195.00	31960.00	235.00	137	12	24166	14358	1.68310349630868	0.292904560133221	0.292904560133221	true	false	false	true
f51efb67-02c7-4439-86ab-f38366b7d5c9	2026-09-30 10:57	2026-09-30 10:57	2026-09-30 10:57	AAPL	AAPL260930P00337500	put	337.5000	2026-09-30	0.6800	0.6700	0.6950	338.0000	21698.00	21698.00	0.00	319	5	36868	2108	17.4895635673624	0.362163271586248	0.355061889503687	false	false	false	true
45faeea3-2df1-4c9a-a646-9154797ef6a8	2026-09-30 10:56	2026-09-30 10:56	2026-09-30 10:56	AAPL	AAPL261002P00337500	put	337.5000	2026-10-02	2.3300	2.3000	2.3400	338.0000	24209.00	18640.00	5569.00	104	6	7503	1830	4.1	0.296061276508873	0.296061276508873	false	false	false	true
ab455968-cbd3-49e9-b660-d0e9e9b01f97	2026-09-30 10:56	2026-09-30 10:56	2026-09-30 10:56	AAPL	AAPL260930C00340000	call	340.0000	2026-09-30	0.6100	0.6000	0.6100	338.0000	43310.00	43310.00	0.00	710	11	140968	11310	12.4640141467728	0.340711943528831	0.340711943528831	true	false	false	true
22d86766-a2e9-47e7-80b8-cf8423810003	2026-09-30 10:56	2026-09-30 10:56	2026-09-30 10:56	AAPL	AAPL260930C00340000	call	340.0000	2026-09-30	0.6100	0.6100	0.6400	338.0000	30499.00	62.00	18979.00	497	33	140234	11310	12.399115826702	0.345183779068456	0.341819758416642	true	false	false	true
e11b3b4f-5da3-4e82-913e-f847ada7fd0c	2026-09-30 10:56	2026-09-30 10:55	2026-09-30 10:55	AAPL	AAPL260930C00340000	call	340.0000	2026-09-30	0.5900	0.5700	0.6100	338.0000	20772.00	640.00	20073.00	353	26	139230	11310	12.3103448275862	0.342766649809636	0.349169041923128	true	false	false	true
03b05246-76a7-43de-ad4c-1f7edcc7e19a	2026-09-30 10:55	2026-09-30 10:55	2026-09-30 10:55	AAPL	AAPL261002C00340000	call	340.0000	2026-10-02	2.4700	2.4700	2.5100	338.0000	37050.00	0.00	37050.00	150	16	23731	14358	1.65280679760412	0.296542665418587	0.296542665418587	false	false	false	true
53d490cb-ea0d-4e36-a06c-564e20efaf09	2026-09-30 10:55	2026-09-30 10:55	2026-09-30 10:55	AAPL	AAPL260930C00335000	call	335.0000	2026-09-30	4.0600	3.9500	4.1500	338.0000	10554.00	405.00	10149.00	26	14	94979	11968	7.93607954545455	0.338540310877173	0.355135317891829	false	false	false	true
71e1241f-b711-44c4-983a-f390629b0a7f	2026-09-30 10:55	2026-09-30 10:54	2026-09-30 10:54	AAPL	AAPL261002P00340000	put	340.0000	2026-10-02	3.4500	3.4000	3.5000	338.0000	13444.00	0.00	3784.00	39	6	6059	3920	1.54566326530612	0.292564181992545	0.292564181992545	false	false	false	true
202e4e68-0a49-40b5-a0ef-d23f8b16b6af	2026-09-30 10:54	2026-09-30 10:53	2026-09-30 10:53	AAPL	AAPL261002C00330000	call	330.0000	2026-10-02	9.6500	9.5500	9.7500	339.0000	18335.00	965.00	7720.00	19	5	6572	5892	1.11541072640869	0.327061877938755	0.327061877938755	false	false	false	true
5e3bbd4a-079d-4c5a-b214-72028f8b495f	2026-09-30 10:53	2026-09-30 10:53	2026-09-30 10:53	AAPL	AAPL261002P00340000	put	340.0000	2026-10-02	3.5000	3.4500	3.5500	338.0000	88200.00	0.00	15050.00	252	6	6000	3920	1.53061224489796	0.293597421936153	0.294709842432259	false	false	false	true
a7798890-5091-4df1-9b96-f2566e6748e9	2026-09-30 10:53	2026-09-30 10:53	2026-09-30 10:53	AAPL	AAPL261218P00320000	put	320.0000	2026-12-18	7.7800	7.6000	7.9500	338.0000	11670.00	11670.00	0.00	15	5	558	4137	0.134880348078318	0.270122658705475	0.270122658705475	false	false	false	true
6ae45e22-8539-4390-8b24-56f30d49dd2f	2026-09-30 10:52	2026-09-30 10:52	2026-09-30 10:52	AAPL	AAPL260930C00340000	call	340.0000	2026-09-30	0.6200	0.6200	0.6400	338.0000	13706.00	0.00	13454.00	221	15	136466	11310	12.0659593280283	0.346049420998824	0.350872829017827	false	false	false	true
9b717ee9-1fc1-4366-8201-edb19cbc33c9	2026-09-30 10:52	2026-09-30 10:52	2026-09-30 10:52	AAPL	AAPL260930C00340000	call	340.0000	2026-09-30	0.6200	0.6100	0.6500	338.0000	17287.00	378.00	16909.00	278	15	136213	11310	12.0435897435897	0.349834402098009	0.346477755772805	true	false	false	true
43eb5883-c207-46a9-bba1-eb6f27dd6ca1	2026-09-30 10:51	2026-09-30 10:51	2026-09-30 10:51	AAPL	AAPL261002C00340000	call	340.0000	2026-10-02	2.5300	2.5000	2.5400	338.0000	50650.00	31750.00	0.00	200	5	23255	14358	1.61965454798718	0.30042215771981	0.298409229477135	false	false	false	true
77e894ce-da09-4c3b-bb61-6192c623614a	2026-09-30 10:51	2026-09-30 10:51	2026-09-30 10:51	AAPL	AAPL260930C00340000	call	340.0000	2026-09-30	0.8200	0.7900	0.8200	339.0000	11115.00	10878.00	237.00	136	11	134380	11310	11.8815207780725	0.356931432071218	0.355723985153171	false	false	false	true
aa387c96-67aa-4afa-840f-c7cfedeefecc	2026-09-30 10:51	2026-09-30 10:50	2026-09-30 10:50	AAPL	AAPL260930C00340000	call	340.0000	2026-09-30	0.6800	0.6300	0.7600	338.0000	14104.00	1087.00	12947.00	207	74	133167	11310	11.7742705570292	0.355751973141606	0.366611928841308	true	false	false	true
2ae8ef4b-51b4-4def-b3fa-099397e6d4af	2026-09-30 10:50	2026-09-30 10:50	2026-09-30 10:50	AAPL	AAPL260930C00340000	call	340.0000	2026-09-30	0.8100	0.8000	0.8200	339.1200	10283.00	972.00	320.00	127	7	131402	11310	11.6182139699381	0.361026003602389	0.363486197559817	false	false	false	true
e67015f6-265e-45ff-9d30-f91fc3c9908a	2026-09-30 10:49	2026-09-30 10:49	2026-09-30 10:49	AAPL	AAPL260930C00337500	call	337.5000	2026-09-30	2.1400	2.0900	2.1600	339.0500	220609.00	59985.00	160624.00	1030	11	87819	14542	6.03899051024618	0.373166124103091	0.356773135839374	false	false	false	true
37f49d15-6b56-425e-a56a-854302b3e74a	2026-09-30 10:49	2026-09-30 10:49	2026-09-30 10:49	AAPL	AAPL260930C00340000	call	340.0000	2026-09-30	0.7800	0.7300	0.8000	338.9900	74074.00	58995.00	11774.00	954	75	130340	11310	11.5243147656941	0.351372319495372	0.356677756680317	true	false	false	true
b3f125f9-0813-4f81-a9d5-161a343482e5	2026-09-30 10:49	2026-09-30 10:49	2026-09-30 10:49	AAPL	AAPL261016C00340000	call	340.0000	2026-10-16	6.5000	6.4000	6.5500	339.1200	25350.00	25350.00	0.00	39	11	3598	107357	0.0335143493204914	0.234284464499885	0.234284464499885	false	false	false	true
e53d83e8-8a9e-4c1e-89ee-41b49cc169a2	2026-09-30 10:49	2026-09-30 10:49	2026-09-30 10:49	AAPL	AAPL261016C00300000	call	300.0000	2026-10-16	40.0000	39.3000	40.2500	339.0800	20000.00	20000.00	0.00	5	5	54	14113	0.00382625947707787	0.343056642983984	0.343056642983984	false	false	false	true
ab639afc-3956-466f-80ba-a9aa13956e87	2026-09-30 10:49	2026-09-30 10:49	2026-09-30 10:49	AAPL	AAPL261014P00340000	put	340.0000	2026-10-14	6.3300	5.9000	7.0500	338.8600	29750.00	0.00	29750.00	47	5	50	2	25	0.227880640684569	0.227880640684569	false	false	false	true
535db376-1be1-4cd0-8ff2-ea04131f9882	2026-09-30 10:49	2026-09-30 10:49	2026-09-30 10:49	AAPL	AAPL260930P00337500	put	337.5000	2026-09-30	0.6800	0.6700	0.6900	338.7100	14618.00	0.00	14618.00	215	6	32328	2108	15.3358633776091	0.35423637325131	0.359988085944203	false	false	false	true
528776a9-9cc7-4ec3-abf3-fb252ec9dd49	2026-09-30 10:47	2026-09-30 10:47	2026-09-30 10:47	AAPL	AAPL281215P00270000	put	270.0000	2028-12-15	17.1500	16.7000	17.2000	338.6100	34300.00	34300.00	0.00	20	7	40	830	0.0481927710843374	0.304991608702939	0.304991608702939	false	false	false	true
b4975b7a-f431-4b12-bf8b-4d1d8d019982	2026-09-30 10:45	2026-09-30 10:45	2026-09-30 10:45	AAPL	AAPL270917C00370000	call	370.0000	2027-09-17	29.0000	28.8500	29.2000	338.6100	31900.00	29000.00	2900.00	11	11	23	1004	0.0229083665338645	0.267483860491267	0.267483860491267	false	false	false	true
e15c7e28-4637-4f03-8a14-aa2c85ed1947	2026-09-30 10:43	2026-09-30 10:43	2026-09-30 10:43	AAPL	AAPL260930P00337500	put	337.5000	2026-09-30	0.8500	0.8200	0.8600	338.2300	12224.00	10534.00	1095.00	144	20	29747	2108	14.1114800759013	0.362634296680688	0.360822546644804	true	false	false	true
4a51720a-1670-4fb8-9aea-fafdf8b9841a	2026-09-30 10:43	2026-09-30 10:43	2026-09-30 10:43	AAPL	AAPL260930P00340000	put	340.0000	2026-09-30	2.2800	2.2400	2.3000	338.2300	16434.00	15066.00	1368.00	72	6	7000	292	23.972602739726	0.370605696034483	0.368397896878794	true	false	false	true
42769f86-887c-4158-96f7-643c4da5ccd2	2026-09-30 10:43	2026-09-30 10:43	2026-09-30 10:43	AAPL	AAPL260930C00340000	call	340.0000	2026-09-30	0.6100	0.6000	0.6300	338.5500	35259.00	122.00	35137.00	578	28	122763	11310	10.8543766578249	0.359896982943851	0.359747486453971	false	false	false	true
e42c06f3-c6cc-4c6c-b1cc-06f32d6859cf	2026-09-30 10:43	2026-09-30 10:43	2026-09-30 10:43	AAPL	AAPL261002P00337500	put	337.5000	2026-10-02	2.3900	2.3900	2.4000	338.6400	23900.00	0.00	23900.00	100	5	6644	1830	3.63060109289617	0.296300402040595	0.296300402040595	false	false	false	true
225a3590-9392-4071-a16e-b371700f4f85	2026-09-30 10:42	2026-09-30 10:42	2026-09-30 10:42	AAPL	AAPL261002C00340000	call	340.0000	2026-10-02	2.4400	2.3900	2.4500	338.7200	48861.00	48861.00	0.00	200	28	22063	14358	1.53663462877838	0.300802006122182	0.299791180991919	true	false	false	true
baa9706f-84ab-48da-9b7e-c69b2701a4e6	2026-09-30 10:42	2026-09-30 10:42	2026-09-30 10:42	AAPL	AAPL260930P00337500	put	337.5000	2026-09-30	0.7600	0.7500	0.7600	338.5450	12616.00	12616.00	0.00	166	7	28808	2108	13.6660341555977	0.366623582298706	0.366623582298706	true	false	false	true
95cb90a3-9b18-4682-a1f6-0a7941523b52	2026-09-30 10:42	2026-09-30 10:42	2026-09-30 10:42	AAPL	AAPL260930C00337500	call	337.5000	2026-09-30	1.8400	1.7900	1.8700	338.6100	17074.00	13800.00	1444.00	93	8	85396	14542	5.87236968780085	0.348802559845107	0.358536132548594	true	false	false	true
ef690fd9-f243-4276-88ba-f7405c727dc3	2026-09-30 10:42	2026-09-30 10:42	2026-09-30 10:42	AAPL	AAPL260930C00340000	call	340.0000	2026-09-30	0.6500	0.6400	0.6800	338.6800	13745.00	670.00	13075.00	212	19	119804	11310	10.5927497789567	0.355283252653948	0.365204072234342	true	false	false	true
384fa536-5e4e-4fe3-87b5-7cdfea599625	2026-09-30 10:42	2026-09-30 10:42	2026-09-30 10:42	AAPL	AAPL260930C00340000	call	340.0000	2026-09-30	0.6500	0.6300	0.7000	338.6800	21781.00	5984.00	15599.00	336	57	119591	11310	10.57391688771	0.364088928060145	0.36189334159943	true	false	false	true
ab569d6a-5253-423b-9141-ee921adfc86c	2026-09-30 10:42	2026-09-30 10:42	2026-09-30 10:42	AAPL	AAPL260930C00340000	call	340.0000	2026-09-30	0.7100	0.6900	0.7200	338.7650	27497.00	22504.00	4993.00	385	30	119101	11310	10.5305923961096	0.366082943172702	0.362270259007319	true	false	false	true
d30aaa71-11c2-4db9-abd2-9620a7c8f288	2026-09-30 10:42	2026-09-30 10:42	2026-09-30 10:42	AAPL	AAPL260930C00340000	call	340.0000	2026-09-30	0.7100	0.7000	0.7400	338.7850	12841.00	576.00	11900.00	180	22	118643	11310	10.4900972590628	0.371291893742103	0.363258434696963	true	false	false	true
b57fc976-40bc-48e5-97ff-0f145e6962fa	2026-09-30 10:42	2026-09-30 10:42	2026-09-30 10:42	AAPL	AAPL261005P00330000	put	330.0000	2026-10-05	0.8800	0.8800	0.9900	338.8350	29304.00	0.00	29304.00	333	25	635	624	1.01762820512821	0.243702157428574	0.243702157428574	false	false	false	true
10ff0079-ecad-4225-adf1-372eb1d9574d	2026-09-30 10:42	2026-09-30 10:42	2026-09-30 10:42	AAPL	AAPL270115C00360000	call	360.0000	2027-01-15	11.2500	11.1500	11.4500	339.0100	225000.00	0.00	225000.00	200	5	883	35444	0.0249125380882519	0.244402638795393	0.244512391021392	false	false	false	true
ea649b25-dd66-4859-ad65-18916738ed9f	2026-09-30 10:42	2026-09-30 10:42	2026-09-30 10:42	AAPL	AAPL261002C00352500	call	352.5000	2026-10-02	0.1300	0.1100	0.1300	339.1202	18252.00	18252.00	0.00	1404	42	6477	4943	1.31033785150718	0.300161619034766	0.300161619034766	false	false	false	true
9e939cf7-36b9-478e-9a07-3d34a189dce9	2026-09-30 10:42	2026-09-30 10:42	2026-09-30 10:42	AAPL	AAPL261002C00350000	call	350.0000	2026-10-02	0.2700	0.2500	0.2700	339.1202	14904.00	14904.00	0.00	552	20	8557	9180	0.932135076252723	0.299161636917792	0.299161636917792	false	false	false	true
60ee8e20-4c6e-48ed-aee3-30d9d77864b5	2026-09-30 10:42	2026-09-30 10:41	2026-09-30 10:41	AAPL	AAPL261002C00340000	call	340.0000	2026-10-02	2.6700	2.6200	2.6700	339.0601	39985.00	39985.00	0.00	150	10	21704	14358	1.51163114639922	0.307067923057947	0.307525203105111	false	false	false	true