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:option_symbol = AAPL260923C00342500×

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

3c8a3ba4-0526-4873-9f89-04b95c2ec648	2026-09-22 11:04	2026-09-22 11:03	2026-09-22 11:03	AAPL	AAPL260923C00342500	call	342.5000	2026-09-23	2.5500	2.5500	2.6000	343.3050	14036.00	1282.00	5869.00	55	6	65725	6696	9.81556152927121	0.29642714042876	0.293598184044686	true	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	Common Stock	Technology	4958372655000.00	2026-10-29	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-22T15:05:44.724527Z"}	2026-09-22	2026-09-22 21:15	2026-09-22 21:15
0ce9435a-4168-4ba1-a9e3-09b94c293c7a	2026-09-22 11:03	2026-09-22 11:03	2026-09-22 11:03	AAPL	AAPL260923C00342500	call	342.5000	2026-09-23	2.6000	2.5900	2.6400	343.3950	10935.00	524.00	10411.00	42	19	65454	6696	9.77508960573477	0.294427418998847	0.294833934998012	false	false	false	true
20a719b4-0f00-4a8d-9e51-aaa658d3959a	2026-09-22 11:03	2026-09-22 11:03	2026-09-22 11:03	AAPL	AAPL260923C00342500	call	342.5000	2026-09-23	2.5700	2.5500	2.5900	343.3700	10008.00	6425.00	3583.00	39	6	64699	6696	9.66233572281959	0.288751130349271	0.288355068776056	false	false	false	true
f38799a0-84b2-4d73-b80d-33e81e831de7	2026-09-22 11:03	2026-09-22 11:02	2026-09-22 11:02	AAPL	AAPL260923C00342500	call	342.5000	2026-09-23	2.6000	2.5600	2.6000	343.4000	27557.00	27299.00	0.00	106	9	64651	6696	9.65516726403823	0.292601457938235	0.293008676735712	false	false	false	true
4ed60ba0-8c3e-4500-ac48-0454c09944ad	2026-09-22 11:02	2026-09-22 11:02	2026-09-22 11:02	AAPL	AAPL260923C00342500	call	342.5000	2026-09-23	2.4900	2.4600	2.5500	343.3300	16164.00	15665.00	499.00	65	12	64344	6696	9.60931899641577	0.291267297930678	0.28734097019533	false	false	false	true
b4eade5a-75a7-499d-9195-1117575458eb	2026-09-22 11:02	2026-09-22 11:02	2026-09-22 11:02	AAPL	AAPL260923C00342500	call	342.5000	2026-09-23	2.4900	2.4700	2.5000	343.2599	22195.00	15750.00	6445.00	89	18	64261	6696	9.59692353643967	0.290283881851941	0.28589202605087	true	false	false	true
aeda27f0-2aca-4fd7-95f9-e86dc3bba012	2026-09-22 11:02	2026-09-22 11:02	2026-09-22 11:02	AAPL	AAPL260923C00342500	call	342.5000	2026-09-23	2.5000	2.4400	2.5100	343.2400	18217.00	17241.00	976.00	73	34	64055	6696	9.56615890083632	0.291096174511681	0.291715119014326	false	false	false	true
f2355db0-a7cb-46be-9268-aed8f98d10ab	2026-09-22 11:02	2026-09-22 11:02	2026-09-22 11:02	AAPL	AAPL260923C00342500	call	342.5000	2026-09-23	2.4000	2.4000	2.4300	343.1350	13452.00	1452.00	12000.00	56	13	63926	6696	9.54689366786141	0.288700001134855	0.285882062559384	true	false	false	true
334f28a5-6a7b-4992-956c-b9e7d3f6ec70	2026-09-22 11:01	2026-09-22 11:01	2026-09-22 11:01	AAPL	AAPL260923C00342500	call	342.5000	2026-09-23	2.4000	2.3500	2.4000	342.7600	17031.00	16560.00	471.00	71	9	63469	6696	9.47864396654719	0.29179190614026	0.307263888736905	false	false	false	true
72cbc7d5-a244-4be7-bde0-7d7dd11feb6d	2026-09-22 11:01	2026-09-22 11:01	2026-09-22 11:01	AAPL	AAPL260923C00342500	call	342.5000	2026-09-23	2.2000	2.1700	2.2200	342.8100	13861.00	4628.00	9233.00	63	8	63035	6696	9.41382915173238	0.288101589284008	0.285367424503678	false	false	false	true
1ca0ffce-8afe-4f44-b55d-62bc2390174b	2026-09-22 11:01	2026-09-22 11:01	2026-09-22 11:01	AAPL	AAPL260923C00342500	call	342.5000	2026-09-23	2.1400	2.1500	2.2300	342.7600	18392.00	3037.00	15355.00	86	23	62887	6696	9.39172640382318	0.286632138952832	0.280663228671638	true	false	false	true
addf9e60-424d-457f-ace8-781bc4258b00	2026-09-22 11:00	2026-09-22 11:00	2026-09-22 11:00	AAPL	AAPL260923C00342500	call	342.5000	2026-09-23	2.3000	2.2600	2.3000	342.8500	24145.00	24145.00	0.00	105	8	62652	6696	9.35663082437276	0.293599554740805	0.292198130110173	false	false	false	true
86bc3c96-c08d-4fb9-8575-90f66eb31ec0	2026-09-22 11:00	2026-09-22 11:00	2026-09-22 11:00	AAPL	AAPL260923C00342500	call	342.5000	2026-09-23	2.3000	2.2700	2.3100	342.8950	17708.00	17250.00	0.00	77	5	62513	6696	9.33587216248507	0.293688119537573	0.290229457427002	false	false	false	true
61c606ae-c3b8-400a-a34f-1b34bfcb8594	2026-09-22 11:00	2026-09-22 11:00	2026-09-22 11:00	AAPL	AAPL260923C00342500	call	342.5000	2026-09-23	2.3700	2.3300	2.3700	343.0200	15398.00	14693.00	0.00	65	7	62306	6696	9.30495818399044	0.287754919597899	0.287754919597899	true	false	false	true	false
a4f7e236-ae07-4c68-b1a2-4a916b177998	2026-09-22 10:59	2026-09-22 10:59	2026-09-22 10:59	AAPL	AAPL260923C00342500	call	342.5000	2026-09-23	2.0900	2.0400	2.2300	342.5100	17168.00	841.00	16117.00	82	35	61319	6696	9.15755675029868	0.288101589284008	0.284738492125133	true	false	false	true
b7ef65fa-94b1-4d6f-87ec-3df8abe6f43e	2026-09-22 10:59	2026-09-22 10:59	2026-09-22 10:59	AAPL	AAPL260923C00342500	call	342.5000	2026-09-23	2.2000	2.1600	2.2300	342.7900	32997.00	28823.00	3953.00	150	26	60938	6696	9.10065710872163	0.288468191523712	0.28544931810365	false	false	false	true
d5077cdd-e35e-4147-9e76-c316f23c7912	2026-09-22 10:59	2026-09-22 10:58	2026-09-22 10:58	AAPL	AAPL260923C00342500	call	342.5000	2026-09-23	2.1400	2.1100	2.1500	342.6700	11144.00	11144.00	0.00	52	11	60640	6696	9.05615292712067	0.283825623458318	0.285848691835505	false	false	false	true
28d69c7c-d36c-4dd9-87da-f93da9f4170c	2026-09-22 10:58	2026-09-22 10:58	2026-09-22 10:58	AAPL	AAPL260923C00342500	call	342.5000	2026-09-23	2.0700	2.0300	2.1100	342.4900	11571.00	1438.00	10133.00	56	27	60064	6696	8.97013142174433	0.284629030252251	0.283356552334142	true	false	false	true
0af06739-865d-4c81-9128-7fe1923030d9	2026-09-22 10:58	2026-09-22 10:57	2026-09-22 10:57	AAPL	AAPL260923C00342500	call	342.5000	2026-09-23	2.1600	2.1400	2.1600	342.6900	14034.00	12960.00	1074.00	65	6	59571	6696	8.89650537634409	0.284706159038427	0.284393730426249	true	false	false	true
3f835ee9-3583-4bc3-8797-35605af9a6f0	2026-09-22 10:57	2026-09-22 10:57	2026-09-22 10:57	AAPL	AAPL260923C00342500	call	342.5000	2026-09-23	2.1000	2.0300	2.1500	342.7400	35333.00	19114.00	4141.00	168	46	59295	6696	8.85528673835126	0.292467338294511	0.280735113415291	true	false	false	true
31287e30-836d-4ef4-bf9d-8506b199e607	2026-09-22 10:56	2026-09-22 10:56	2026-09-22 10:56	AAPL	AAPL260923C00342500	call	342.5000	2026-09-23	2.0300	2.0200	2.0600	342.4000	26796.00	406.00	26390.00	132	8	58198	6696	8.69145758661888	0.282649697509969	0.286872763978021	false	false	false	true
d0d4396b-2612-49a2-b328-abb4b869a726	2026-09-22 10:56	2026-09-22 10:56	2026-09-22 10:56	AAPL	AAPL260923C00342500	call	342.5000	2026-09-23	2.0400	2.0400	2.0600	342.5150	14484.00	0.00	14484.00	71	15	58015	6696	8.66412783751493	0.281232677454859	0.281587348901433	false	false	false	true
eea8e536-b374-47a0-971d-d2ab9a75d92e	2026-09-22 10:56	2026-09-22 10:56	2026-09-22 10:56	AAPL	AAPL260923C00342500	call	342.5000	2026-09-23	2.0300	1.9700	2.0800	342.3900	10162.00	2673.00	7489.00	50	15	57757	6696	8.62559737156511	0.286116080112249	0.283372834871244	true	false	false	true
ce57a733-44c7-4365-a61a-e9cfe570019b	2026-09-22 10:56	2026-09-22 10:56	2026-09-22 10:56	AAPL	AAPL260923C00342500	call	342.5000	2026-09-23	2.0600	2.0300	2.0900	342.5104	11531.00	9894.00	1429.00	56	15	57702	6696	8.6173835125448	0.278420863121867	0.284710151322529	false	false	false	true
b9a64334-c2ce-4795-97f7-a117e769c17a	2026-09-22 10:56	2026-09-22 10:56	2026-09-22 10:56	AAPL	AAPL260923C00342500	call	342.5000	2026-09-23	2.0400	2.0000	2.1000	342.6000	10201.00	7984.00	2217.00	50	19	57532	6696	8.59199522102748	0.281618008629267	0.274120518119787	true	false	false	true
aa4e3a8f-156f-464d-9d13-0af22d7c2bcd	2026-09-22 10:56	2026-09-22 10:56	2026-09-22 10:56	AAPL	AAPL260923C00342500	call	342.5000	2026-09-23	2.0700	2.0400	2.0900	342.5001	21112.00	10655.00	10457.00	102	11	57636	6696	8.60752688172043	0.2889500562557	0.286837741301922	false	false	false	true
44958306-24a3-48e9-a3f4-192aef0ceff3	2026-09-22 10:56	2026-09-22 10:56	2026-09-22 10:56	AAPL	AAPL260923C00342500	call	342.5000	2026-09-23	1.9900	1.9500	2.0400	342.3800	16734.00	5438.00	10692.00	84	20	56973	6696	8.50851254480287	0.285477305959755	0.279871500349386	true	false	false	true
11219eda-9121-4235-9de5-7b2be49606d5	2026-09-22 10:56	2026-09-22 10:56	2026-09-22 10:56	AAPL	AAPL260923C00342500	call	342.5000	2026-09-23	2.0300	2.0100	2.0400	342.4400	22334.00	1428.00	606.00	110	5	56797	6696	8.48222819593787	0.283383264719811	0.285476131140054	false	false	false	true
f4eee58f-8abd-4ee8-920a-34c9409e668b	2026-09-22 10:56	2026-09-22 10:56	2026-09-22 10:56	AAPL	AAPL260923C00342500	call	342.5000	2026-09-23	2.0100	2.0000	2.0100	342.3832	20292.00	18492.00	1800.00	101	24	56613	6696	8.45474910394265	0.285474118854464	0.286643014150203	false	false	false	true
c032f210-e16b-4dcb-b755-bbc1d1d14e90	2026-09-22 10:56	2026-09-22 10:56	2026-09-22 10:56	AAPL	AAPL260923C00342500	call	342.5000	2026-09-23	2.0000	1.9600	2.0100	342.3808	30794.00	29999.00	0.00	154	43	56444	6696	8.42951015531661	0.286837435733396	0.284012244265796	false	false	false	true
06bbf1e6-521a-40f0-a0d3-43688341ffcb	2026-09-22 10:55	2026-09-22 10:55	2026-09-22 10:55	AAPL	AAPL260923C00342500	call	342.5000	2026-09-23	1.8200	1.8000	1.8500	342.0400	22695.00	4231.00	18464.00	125	9	55256	6696	8.2520908004779	0.284720573863002	0.281859508197008	false	false	false	true
b8e198f8-cf6b-44fe-a594-72b86187afb3	2026-09-22 10:55	2026-09-22 10:55	2026-09-22 10:55	AAPL	AAPL260923C00342500	call	342.5000	2026-09-23	1.8400	1.8000	1.8600	341.9900	15288.00	12223.00	2882.00	83	14	55082	6696	8.22610513739546	0.279141878428753	0.283740004237495	false	false	false	true
26a576cc-9545-4bac-8691-281cf188ad6a	2026-09-22 10:55	2026-09-22 10:55	2026-09-22 10:55	AAPL	AAPL260923C00342500	call	342.5000	2026-09-23	1.8100	1.7800	1.8800	342.0199	23739.00	3956.00	13911.00	131	25	54996	6696	8.21326164874552	0.287557160411725	0.284587681203785	true	false	false	true
559fbf1c-0085-48aa-93d7-31995d154bae	2026-09-22 10:55	2026-09-22 10:55	2026-09-22 10:55	AAPL	AAPL260923C00342500	call	342.5000	2026-09-23	1.9200	1.8400	1.9600	342.0400	23947.00	3093.00	20278.00	125	45	54820	6696	8.18697729988053	0.284981590463413	0.297302806796361	true	false	false	true
d5248494-480e-46b5-b15f-15eb71b48c1c	2026-09-22 10:55	2026-09-22 10:55	2026-09-22 10:55	AAPL	AAPL260923C00342500	call	342.5000	2026-09-23	1.9600	1.9400	1.9900	342.2730	12366.00	1186.00	11180.00	63	12	54646	6696	8.16099163679809	0.286373367572085	0.284442130383899	true	false	false	true
d1970c5e-1d3e-44ca-b2e7-8fba96bc6722	2026-09-22 10:55	2026-09-22 10:54	2026-09-22 10:54	AAPL	AAPL260923C00342500	call	342.5000	2026-09-23	1.9700	1.9500	1.9800	342.2300	12045.00	12045.00	0.00	61	8	54372	6696	8.12007168458781	0.292972309846998	0.291572037494408	false	false	false	true
c1bd4408-f092-4c2d-ab2d-8e124fb3df25	2026-09-22 10:54	2026-09-22 10:54	2026-09-22 10:54	AAPL	AAPL260923C00342500	call	342.5000	2026-09-23	1.9400	1.9100	1.9400	342.1700	59158.00	58006.00	1152.00	305	6	54010	6696	8.06600955794504	0.28940421967171	0.288626467452336	false	false	false	true
e01ecd06-ab01-4f51-a4b5-682015e0b4be	2026-09-22 10:54	2026-09-22 10:54	2026-09-22 10:54	AAPL	AAPL260923C00342500	call	342.5000	2026-09-23	1.8000	1.7500	1.8700	341.9100	13132.00	714.00	12418.00	73	23	53319	6696	7.96281362007168	0.283015514212733	0.281912671737227	true	false	false	true
b1a855ad-93e3-4020-bb2a-c6af50b51aa7	2026-09-22 10:53	2026-09-22 10:53	2026-09-22 10:53	AAPL	AAPL260923C00342500	call	342.5000	2026-09-23	1.7200	1.6800	1.7500	341.8500	18235.00	1035.00	17200.00	106	6	52469	6696	7.83587216248507	0.287918728328648	0.281548675203466	false	false	false	true
a3a84a4c-ca54-4c5f-8f2a-c79da7ce6935	2026-09-22 10:53	2026-09-22 10:53	2026-09-22 10:53	AAPL	AAPL260923C00342500	call	342.5000	2026-09-23	1.6300	1.6000	1.6500	341.6100	24975.00	24975.00	0.00	153	8	52312	6696	7.81242532855436	0.282076991563068	0.286778486253892	false	false	false	true
1c44640f-ab04-43d1-bf63-5ebf9b393d5b	2026-09-22 10:52	2026-09-22 10:52	2026-09-22 10:52	AAPL	AAPL260923C00342500	call	342.5000	2026-09-23	1.5800	1.5700	1.6100	341.4600	33337.00	0.00	33337.00	211	5	51496	6696	7.69056152927121	0.283585986785158	0.284592095714782	false	false	false	true
1a5c076d-33bf-4424-8b69-c7bfd28642cb	2026-09-22 10:50	2026-09-22 10:50	2026-09-22 10:50	AAPL	AAPL260923C00342500	call	342.5000	2026-09-23	1.8600	1.8500	1.8900	342.0450	20289.00	2615.00	16744.00	109	16	49608	6696	7.40860215053763	0.2869760651451	0.288549513128999	false	false	false	true
83fd085d-5e67-4e47-b117-e2dfd6e1a3a0	2026-09-22 10:50	2026-09-22 10:50	2026-09-22 10:50	AAPL	AAPL260923C00342500	call	342.5000	2026-09-23	1.8000	1.7900	1.8300	341.9599	39969.00	37805.00	1440.00	222	13	49253	6696	7.35558542413381	0.287003364749015	0.287113240910912	false	false	false	true
1bc7f62c-9ef7-41f8-ace9-111b22c2bc9f	2026-09-22 10:50	2026-09-22 10:50	2026-09-22 10:50	AAPL	AAPL260923C00342500	call	342.5000	2026-09-23	1.7900	1.7700	1.8000	341.9200	20429.00	12592.00	7658.00	114	13	48876	6696	7.29928315412186	0.285271329319246	0.286895572620429	false	false	false	true
b210d508-8663-43c3-9417-fc9143afab69	2026-09-22 10:50	2026-09-22 10:50	2026-09-22 10:50	AAPL	AAPL260923C00342500	call	342.5000	2026-09-23	1.7700	1.7500	1.7800	341.9050	16638.00	16638.00	0.00	94	5	48572	6696	7.25388291517324	0.287311083879735	0.285051958734828	true	false	false	true	false
3a5ed6fd-31f9-4241-9eac-a20b9ce1fde7	2026-09-22 10:50	2026-09-22 10:50	2026-09-22 10:50	AAPL	AAPL260923C00342500	call	342.5000	2026-09-23	1.7200	1.6800	1.7300	341.7600	12546.00	8988.00	3558.00	73	6	48200	6696	7.19832735961768	0.284785412677156	0.284458981344197	false	false	false	true
63a6c558-89bf-4b32-8190-90bb75f87099	2026-09-22 10:50	2026-09-22 10:50	2026-09-22 10:50	AAPL	AAPL260923C00342500	call	342.5000	2026-09-23	1.7100	1.6800	1.7400	341.7100	18348.00	7089.00	9889.00	107	35	48127	6696	7.18742532855436	0.287192797633342	0.284785412677156	true	false	false	true
f1a05339-8e55-4ec5-9938-34d7da097c4c	2026-09-22 10:50	2026-09-22 10:50	2026-09-22 10:50	AAPL	AAPL260923C00342500	call	342.5000	2026-09-23	1.7400	1.7300	1.7600	341.7700	15500.00	2275.00	13050.00	89	9	47999	6696	7.16830943847073	0.290869183184544	0.29088825357887	false	false	false	true
b99fd042-1623-486c-b53e-c0cadc814d34	2026-09-22 10:50	2026-09-22 10:50	2026-09-22 10:50	AAPL	AAPL260923C00342500	call	342.5000	2026-09-23	1.7500	1.7300	1.7500	341.7900	11370.00	10500.00	0.00	65	13	47685	6696	7.12141577060932	0.288203724002076	0.289615400013314	false	false	false	true
4f2f7604-f009-4095-80d3-a58ea1c34b39	2026-09-22 10:49	2026-09-22 10:49	2026-09-22 10:49	AAPL	AAPL260923C00342500	call	342.5000	2026-09-23	1.7200	1.6800	1.7200	341.7497	35920.00	35920.00	0.00	209	6	47426	6696	7.08273596176822	0.286039686140415	0.287937722723092	false	false	false	true