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.

658,639 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts658,639 rowsrestricted — hover for the licence

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

fadc3ea1-b711-4e9c-825e-8aa877ed9736	2026-09-30 10:05	2026-09-30 10:05	2026-09-30 10:05	AAPL	AAPL260930C00337500	call	337.5000	2026-09-30	2.0400	2.0100	2.0800	338.6300	13891.00	8975.00	3685.00	68	13	58084	14542	3.99422362811168	0.403353682369174	0.396048406032748	false	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	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:07:13.593922Z"}	2026-09-30	2026-09-30 21:15	2026-09-30 21:15
e53b9418-c8f4-4ce1-84e0-241b6553e490	2026-09-30 10:05	2026-09-30 10:05	2026-09-30 10:05	AAPL	AAPL260930C00337500	call	337.5000	2026-09-30	2.0500	2.0100	2.0700	338.6200	20704.00	20297.00	407.00	101	7	57971	14542	3.98645303259524	0.407693011062912	0.397925625086963	false	false	false	true
7677161d-7b85-4a7a-8f1e-baa784ca44ce	2026-09-30 10:05	2026-09-30 10:05	2026-09-30 10:05	AAPL	AAPL260930C00340000	call	340.0000	2026-09-30	0.8600	0.8500	0.8700	338.6150	20491.00	5655.00	11826.00	239	39	44891	11310	3.96914235190097	0.41420196586531	0.40808500117523	true	false	false	true
2bf85d94-5a3b-4277-be0e-2377a4aebd4e	2026-09-30 10:05	2026-09-30 10:05	2026-09-30 10:05	AAPL	AAPL260930C00335000	call	335.0000	2026-09-30	3.8500	3.7500	4.0000	338.6150	17326.00	12824.00	4502.00	45	5	86367	11968	7.21649398395722	0.416327059943391	0.392071235726825	false	false	false	true
33fbe730-f76b-4177-b1ff-88d3bc7f5923	2026-09-30 10:05	2026-09-30 10:05	2026-09-30 10:05	AAPL	AAPL260930C00340000	call	340.0000	2026-09-30	0.8500	0.8200	0.8700	338.6100	17764.00	11898.00	5780.00	210	40	44652	11310	3.94801061007958	0.41518049979885	0.41167660207775	true	false	false	true
0caed8ef-75b2-44dd-ba3c-08e606f18723	2026-09-30 10:05	2026-09-30 10:05	2026-09-30 10:05	AAPL	AAPL260930C00340000	call	340.0000	2026-09-30	0.8300	0.8000	0.8700	338.5264	32583.00	13814.00	15623.00	392	74	44367	11310	3.92281167108753	0.412198001491865	0.408333136288513	true	false	false	true
55822104-7ebb-4f44-8d36-5add36698776	2026-09-30 10:05	2026-09-30 10:05	2026-09-30 10:05	AAPL	AAPL261002P00340000	put	340.0000	2026-10-02	3.7500	3.7000	3.8500	338.5950	37875.00	0.00	37500.00	101	8	560	3920	0.142857142857143	0.29959482025328	0.303334074338372	false	false	false	true
a22bce16-3b9b-45b3-8a04-0c0525dfdcf9	2026-09-30 10:05	2026-09-30 10:05	2026-09-30 10:05	AAPL	AAPL260930C00335000	call	335.0000	2026-09-30	4.0000	3.9500	4.0000	338.6900	17200.00	17200.00	0.00	43	10	86299	11968	7.2108121657754	0.419480971499636	0.419480971499636	false	false	false	true
377d1ac3-ff68-41a9-9422-f06ec557cdf4	2026-09-30 10:05	2026-09-30 10:05	2026-09-30 10:05	AAPL	AAPL260930C00332500	call	332.5000	2026-09-30	6.2900	6.1500	6.3000	338.6699	12576.00	12576.00	0.00	20	6	41291	9581	4.30967539922764	0.47303476074041	0.433939957526456	false	false	false	true
0fd5b223-ceab-4d0a-9e1b-70a685f4c8d3	2026-09-30 10:05	2026-09-30 10:05	2026-09-30 10:05	AAPL	AAPL260930C00337500	call	337.5000	2026-09-30	2.0000	1.9200	2.0000	338.5900	29193.00	29193.00	0.00	146	19	57514	14542	3.95502681886948	0.381611822111598	0.391431510806167	false	false	false	true
5fce72b1-c029-4d00-aeea-7cff1e8220f3	2026-09-30 10:05	2026-09-30 10:05	2026-09-30 10:05	AAPL	AAPL261016C00350000	call	350.0000	2026-10-16	2.5000	2.4600	2.5000	338.5350	33000.00	33000.00	0.00	132	9	1524	32992	0.0461930164888458	0.227748684109934	0.227748684109934	false	false	false	true
99ac760f-b295-4447-a038-01c53ed38897	2026-09-30 10:05	2026-09-30 10:05	2026-09-30 10:05	AAPL	AAPL260930C00340000	call	340.0000	2026-09-30	0.7500	0.7300	0.7500	338.3900	11664.00	9519.00	2145.00	156	26	42294	11310	3.7395225464191	0.397330274705801	0.40057404990029	true	false	false	true
43c7d5cd-62e0-4050-b80b-d8c392e9488a	2026-09-30 10:05	2026-09-30 10:05	2026-09-30 10:05	AAPL	AAPL260930C00340000	call	340.0000	2026-09-30	0.7400	0.7200	0.7500	338.2990	12662.00	1122.00	10060.00	171	23	42478	11310	3.75579133510168	0.40057404990029	0.406742873411068	false	false	false	true
80d658f0-6c64-418d-87cc-20f3a2a08ff7	2026-09-30 10:05	2026-09-30 10:05	2026-09-30 10:05	AAPL	AAPL260930C00340000	call	340.0000	2026-09-30	0.7500	0.7300	0.7500	338.3712	19189.00	18600.00	219.00	256	31	41995	11310	3.7130857648099	0.401495129165007	0.402491329863415	true	false	false	true
7869b5ad-5b67-4c42-87f5-5c7ade26c85b	2026-09-30 10:05	2026-09-30 10:05	2026-09-30 10:05	AAPL	AAPL260930C00337500	call	337.5000	2026-09-30	1.8500	1.8200	1.8700	338.3404	28381.00	19054.00	9327.00	153	29	56778	14542	3.90441479851465	0.382828117236145	0.401025065802863	false	false	false	true
a274b30c-f37c-409b-82b9-0494af60bbc2	2026-09-30 10:05	2026-09-30 10:05	2026-09-30 10:05	AAPL	AAPL260930C00332500	call	332.5000	2026-09-30	6.0000	5.7500	6.0000	338.3790	13800.00	13800.00	0.00	23	5	41203	9581	4.3004905542219	0.447641610071563	0.447641610071563	false	false	false	true
9b4787d7-2cd9-4cf9-877c-c80b1090d88f	2026-09-30 10:05	2026-09-30 10:05	2026-09-30 10:05	AAPL	AAPL260930C00340000	call	340.0000	2026-09-30	0.7200	0.6900	0.7300	338.3790	17848.00	10224.00	284.00	249	22	41183	11310	3.64129089301503	0.398930320406345	0.392113979812133	false	false	false	true
af29fed9-fb04-4557-8744-14120e3cf4d4	2026-09-30 10:05	2026-09-30 10:04	2026-09-30 10:04	AAPL	AAPL260930P00337500	put	337.5000	2026-09-30	1.1300	1.1000	1.1300	338.0750	12995.00	12995.00	0.00	115	5	2577	2108	1.22248576850095	0.400534130603357	0.400534130603357	false	false	false	true
fb3c647e-f1ed-4df9-8c66-3899d4e0bb5f	2026-09-30 10:04	2026-09-30 10:04	2026-09-30 10:04	AAPL	AAPL260930C00337500	call	337.5000	2026-09-30	1.5600	1.5500	1.6000	337.9200	15759.00	15759.00	0.00	101	6	55956	14542	3.84788887360748	0.389628143448924	0.380993472350964	false	false	false	true
2e97e09c-cc15-49ad-b71c-f291a4f92228	2026-09-30 10:04	2026-09-30 10:04	2026-09-30 10:04	AAPL	AAPL260930C00337500	call	337.5000	2026-09-30	1.5800	1.5400	1.6200	337.9400	16572.00	10720.00	5852.00	105	11	55720	14542	3.83166001925457	0.372018928266431	0.372018928266431	false	false	false	true
cd5ffbba-3523-4ee8-b600-7eafb8e965e7	2026-09-30 10:04	2026-09-30 10:04	2026-09-30 10:04	AAPL	AAPL260930C00335000	call	335.0000	2026-09-30	3.0600	3.0000	3.1500	337.5701	16499.00	7084.00	9110.00	54	14	85812	11968	7.17012032085561	0.375463063039708	0.400577784061058	false	false	false	true
737be6b9-296c-4177-b85a-22ff6861449c	2026-09-30 10:04	2026-09-30 10:04	2026-09-30 10:04	AAPL	AAPL270617C00330000	call	330.0000	2027-06-17	39.9000	39.8500	40.1500	337.8400	99750.00	39900.00	59850.00	25	17	225	6798	0.0330979699911739	0.269855265075954	0.269795171909301	false	false	false	true
6274d44f-b311-4222-adf3-f4aea2db0596	2026-09-30 10:04	2026-09-30 10:04	2026-09-30 10:04	AAPL	AAPL261005C00340000	call	340.0000	2026-10-05	2.6900	2.6300	2.7500	337.7450	16140.00	0.00	4304.00	60	5	1205	1601	0.7526545908807	0.229498708369998	0.229498708369998	false	false	false	true
7b3b6031-d239-4c91-9f59-f775f651958d	2026-09-30 10:04	2026-09-30 10:04	2026-09-30 10:04	AAPL	AAPL261016C00345000	call	345.0000	2026-10-16	3.8500	3.7500	3.8500	337.7450	11550.00	11550.00	0.00	30	7	904	28767	0.0314248965828901	0.23349330044884	0.23349330044884	false	false	false	true
e4f1251a-0271-40f1-a386-a259fd301d21	2026-09-30 10:04	2026-09-30 10:04	2026-09-30 10:04	AAPL	AAPL270617C00330000	call	330.0000	2027-06-17	39.9000	38.8500	39.9000	337.7500	215460.00	215460.00	0.00	54	32	155	6798	0.0228008237716976	0.270545216001115	0.27033574948149	false	false	false	true
a50eace4-efae-45f5-b737-b1e5b8f568a3	2026-09-30 10:04	2026-09-30 10:03	2026-09-30 10:03	AAPL	AAPL260930C00340000	call	340.0000	2026-09-30	0.5600	0.5500	0.5800	337.7900	17901.00	5600.00	12301.00	320	14	36812	11310	3.25481874447392	0.392838802923636	0.392232703214228	false	false	false	true
43711a9b-9127-4664-9ffc-30a7417dd8f7	2026-09-30 10:04	2026-09-30 10:03	2026-09-30 10:03	AAPL	AAPL260930C00337500	call	337.5000	2026-09-30	1.5400	1.5100	1.5500	337.8150	10749.00	8784.00	1812.00	70	5	54328	14542	3.73593728510521	0.385552210910053	0.394157057276368	false	false	false	true
f1ecb2e4-bdae-46e7-9b96-d7a2ec3b9ec6	2026-09-30 10:03	2026-09-30 10:03	2026-09-30 10:03	AAPL	AAPL260930C00340000	call	340.0000	2026-09-30	0.5900	0.5700	0.6100	337.8900	37344.00	35056.00	1510.00	633	21	35975	11310	3.18081343943413	0.394627151703246	0.40341522485338	false	false	false	true
972da6f3-0454-46e4-872d-c4a1a384e66f	2026-09-30 10:03	2026-09-30 10:03	2026-09-30 10:03	AAPL	AAPL261002P00337500	put	337.5000	2026-10-02	2.8500	2.8400	2.9400	337.7300	25081.00	286.00	24795.00	88	8	1622	1830	0.886338797814208	0.300927551644981	0.301931543308812	false	false	false	true
62d41045-f103-4266-9419-7b593ecb95ce	2026-09-30 10:03	2026-09-30 10:03	2026-09-30 10:03	AAPL	AAPL261002P00330000	put	330.0000	2026-10-02	0.7000	0.6200	0.7000	337.8750	14000.00	14000.00	0.00	200	11	6177	6359	0.971379147664727	0.327853436317391	0.327853436317391	false	false	false	true
383bb3c8-7b4e-46ff-be0e-8f3a49468cd0	2026-09-30 10:03	2026-09-30 10:03	2026-09-30 10:03	AAPL	AAPL260930C00340000	call	340.0000	2026-09-30	0.5700	0.5400	0.5800	337.8500	10628.00	3596.00	6086.00	188	27	35342	11310	3.12484526967286	0.401752089448485	0.396960443303706	false	false	false	true
fdfb68c7-bb5e-4ec4-a518-16caa57398a8	2026-09-30 10:03	2026-09-30 10:03	2026-09-30 10:03	AAPL	AAPL260930C00337500	call	337.5000	2026-09-30	1.5100	1.4400	1.5100	337.6850	10388.00	9653.00	735.00	69	7	53978	14542	3.71186906890386	0.398172082664773	0.402389605490787	false	false	false	true
968786fc-f3a5-4536-a3fa-47cf73f3db27	2026-09-30 10:03	2026-09-30 10:03	2026-09-30 10:03	AAPL	AAPL261030C00350000	call	350.0000	2026-10-30	5.6000	5.5000	5.9500	337.7500	56000.00	0.00	56000.00	100	7	764	3165	0.241390205371248	0.259868877752212	0.259868877752212	true	false	false	true
6a839721-27a7-450f-a930-3b34cded55a2	2026-09-30 10:03	2026-09-30 10:03	2026-09-30 10:03	AAPL	AAPL260930C00337500	call	337.5000	2026-09-30	1.5700	1.5100	1.6000	337.7450	62942.00	152.00	62637.00	401	5	53827	14542	3.70148535277128	0.38808288755409	0.396182295256294	false	false	false	true
b199edc9-a72f-49d3-b387-b0c8bc78d11a	2026-09-30 10:03	2026-09-30 10:03	2026-09-30 10:03	AAPL	AAPL260930C00337500	call	337.5000	2026-09-30	1.6300	1.5800	1.6700	337.9035	19842.00	3267.00	16415.00	122	23	53253	14542	3.66201347820107	0.400252879312323	0.394540712823597	false	false	false	true
12443b31-5aa1-4502-9449-1d679c350be5	2026-09-30 10:03	2026-09-30 10:03	2026-09-30 10:03	AAPL	AAPL260930C00337500	call	337.5000	2026-09-30	1.6600	1.6300	1.6700	337.9410	22898.00	18801.00	3767.00	138	31	53131	14542	3.6536239856966	0.393867467692676	0.400093954588084	false	false	false	true
efd5050f-2322-4c48-9e1a-e162506e7577	2026-09-30 10:03	2026-09-30 10:03	2026-09-30 10:03	AAPL	AAPL260930C00337500	call	337.5000	2026-09-30	1.7500	1.6300	1.7800	338.0600	85979.00	69724.00	15098.00	491	44	52763	14542	3.62831797551919	0.399728093140277	0.392391858774174	true	false	false	true
6e1cdffb-4918-486a-94c1-32602fec2358	2026-09-30 10:03	2026-09-30 10:03	2026-09-30 10:03	AAPL	AAPL260930C00340000	call	340.0000	2026-09-30	0.6600	0.6300	0.7100	337.9701	35056.00	7417.00	17950.00	530	97	34430	11310	3.04420866489832	0.40393645924823	0.409106349787212	true	false	false	true
30f71e0b-cadd-496b-9327-c8b1f0a42ca0	2026-09-30 10:03	2026-09-30 10:03	2026-09-30 10:03	AAPL	AAPL260930C00337500	call	337.5000	2026-09-30	1.6500	1.6300	1.7100	338.0100	26917.00	23927.00	2990.00	163	14	52942	14542	3.64062714894788	0.394765396515924	0.386115562672065	false	false	false	true
7f008a10-02bc-4d61-b705-50cc649572f0	2026-09-30 10:03	2026-09-30 10:03	2026-09-30 10:03	AAPL	AAPL261002C00340000	call	340.0000	2026-10-02	2.2400	2.2000	2.3000	338.1400	13244.00	224.00	12795.00	59	6	11522	14358	0.802479453962948	0.303511872003142	0.300497866171087	false	false	false	true
7b1b573a-00e5-4adb-8919-3ea128300cf3	2026-09-30 10:03	2026-09-30 10:03	2026-09-30 10:03	AAPL	AAPL261016C00345000	call	345.0000	2026-10-16	4.0000	3.9000	4.0500	338.1900	10800.00	1200.00	9200.00	27	5	850	28767	0.0295477456808148	0.232986217273033	0.233123127316909	true	false	false	true
11f80a3b-41bc-4d0a-81c7-6681fc76102d	2026-09-30 10:03	2026-09-30 10:03	2026-09-30 10:03	AAPL	AAPL260930C00340000	call	340.0000	2026-09-30	0.7100	0.6900	0.7300	338.1900	16362.00	5598.00	5909.00	230	58	33900	11310	2.9973474801061	0.407709323926229	0.407158369981488	false	false	false	true
6853f1a7-118c-4630-aa8f-fada084588db	2026-09-30 10:03	2026-09-30 10:03	2026-09-30 10:03	AAPL	AAPL260930C00340000	call	340.0000	2026-09-30	0.7200	0.7000	0.7400	338.2300	17018.00	4895.00	10237.00	236	71	33612	11310	2.97188328912467	0.405498375307675	0.409543734485328	false	false	false	true
79bffc4a-76a5-4366-9c44-ec3077e63d9f	2026-09-30 10:03	2026-09-30 10:03	2026-09-30 10:03	AAPL	AAPL260930C00340000	call	340.0000	2026-09-30	0.7000	0.7000	0.7200	338.2344	14845.00	2231.00	11620.00	211	41	33306	11310	2.9448275862069	0.406601912793954	0.405873971830852	true	false	false	true
cd061ef1-4beb-46fc-bac1-f399f4209f8a	2026-09-30 10:03	2026-09-30 10:03	2026-09-30 10:03	AAPL	AAPL261002C00340000	call	340.0000	2026-10-02	2.1500	2.1500	2.2000	338.0300	33562.00	1094.00	32468.00	156	10	11352	14358	0.790639364814041	0.302015058401726	0.304092233237165	false	false	false	true
ba7b67f8-4862-472c-9b8f-550da8530128	2026-09-30 10:03	2026-09-30 10:03	2026-09-30 10:03	AAPL	AAPL261002P00340000	put	340.0000	2026-10-02	4.0000	4.0000	4.1000	338.0150	10000.00	0.00	10000.00	25	5	269	3920	0.0686224489795918	0.294428092127405	0.294428092127405	false	false	false	true
e0662da4-9c04-4653-b4ad-3958cacb4837	2026-09-30 10:03	2026-09-30 10:03	2026-09-30 10:03	AAPL	AAPL260930C00337500	call	337.5000	2026-09-30	1.6000	1.5900	1.6400	338.0000	16976.00	816.00	16160.00	106	5	51519	14542	3.5427726585064	0.39042519775864	0.378907800208969	false	false	false	true
9a2ac2f7-799b-47ad-a259-e3d51c6d4ab0	2026-09-30 10:03	2026-09-30 10:03	2026-09-30 10:03	AAPL	AAPL260930C00340000	call	340.0000	2026-09-30	0.5800	0.5600	0.5900	337.9200	16617.00	5900.00	10253.00	287	33	31899	11310	2.82042440318302	0.386733268949676	0.386733268949676	false	false	false	true
97d640b3-ce23-4ffd-820e-a6abe1d9766e	2026-09-30 10:03	2026-09-30 10:03	2026-09-30 10:03	AAPL	AAPL261009C00335000	call	335.0000	2026-10-09	7.0000	6.6000	7.0000	337.9700	20300.00	20300.00	0.00	29	5	1012	2517	0.402065951529599	0.245952916832188	0.245952916832188	false	false	false	true
96d3af64-0c32-4fdc-8b1d-c99a2cc0fdc5	2026-09-30 10:03	2026-09-30 10:03	2026-09-30 10:03	AAPL	AAPL260930C00337500	call	337.5000	2026-09-30	1.5900	1.5500	1.6000	337.9200	10681.00	8790.00	1733.00	67	9	51336	14542	3.53018841974969	0.384446191724658	0.383094074178268	false	false	false	true