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:alert_rule = RepeatedHitsDescendingFill×option_symbol = AAPL261002C00335000×

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

4965f5fa-91e9-47aa-a3e2-dc3ea0bd136c	2026-10-02 10:26	2026-10-02 10:26	2026-10-02 10:26	AAPL	AAPL261002C00335000	call	335.0000	2026-10-02	0.8000	0.8000	0.8400	334.4800	15768.00	84.00	15684.00	197	9	92262	19105	4.82920701387071	0.320102404662464	0.30798305803577	true	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	Common Stock	Technology	4869931924200.00	2026-10-29	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-10-02T14:27:01.813357Z"}	2026-10-02	2026-10-02 21:15	2026-10-02 21:15
674e60b5-0f67-48bf-9f32-088af4d731f0	2026-10-02 10:22	2026-10-02 10:22	2026-10-02 10:22	AAPL	AAPL261002C00335000	call	335.0000	2026-10-02	0.7600	0.7200	0.7800	334.0000	27356.00	375.00	26531.00	361	46	88201	19105	4.61664485736718	0.321301550028857	0.321545802765724	true	false	false
a108758f-2b2c-4f31-a361-25169493c634	2026-10-02 10:21	2026-10-02 10:21	2026-10-02 10:21	AAPL	AAPL261002C00335000	call	335.0000	2026-10-02	0.8900	0.8900	0.9000	334.0000	24265.00	5130.00	19135.00	272	32	85479	19105	4.47416906568961	0.329650173720539	0.329658338849536	false	false	false
d6182384-7c88-420c-9039-583644d7d05a	2026-10-02 10:19	2026-10-02 10:19	2026-10-02 10:19	AAPL	AAPL261002C00335000	call	335.0000	2026-10-02	0.8600	0.8600	0.8800	334.0000	17547.00	0.00	17286.00	204	15	81997	19105	4.29191311175085	0.327482019544919	0.325125259414935	false	false	false
a73029b9-a3be-49fe-ba35-6da7092b05a9	2026-10-02 10:18	2026-10-02 10:18	2026-10-02 10:18	AAPL	AAPL261002C00335000	call	335.0000	2026-10-02	0.8500	0.8400	0.8800	334.0000	10376.00	440.00	9766.00	122	17	80659	19105	4.22187908924365	0.329569885603531	0.328866703374553	false	false	false
dd2dc2d7-d1fa-402f-8807-6d0610a9a64b	2026-10-02 10:16	2026-10-02 10:16	2026-10-02 10:16	AAPL	AAPL261002C00335000	call	335.0000	2026-10-02	0.7600	0.7500	0.7700	334.1000	10926.00	0.00	10926.00	144	7	74843	19105	3.91745616330803	0.337142724609533	0.334069385993608	true	false	false
4e18769a-f541-4590-b955-264f8253f63e	2026-10-02 10:15	2026-10-02 10:15	2026-10-02 10:15	AAPL	AAPL261002C00335000	call	335.0000	2026-10-02	0.8500	0.8300	0.8700	334.2900	11473.00	3887.00	5532.00	135	20	72936	19105	3.81763936142371	0.340190339966715	0.335472589748208	false	false	false
065cfdee-97b7-4077-99f8-8b01ed8f3ae2	2026-10-02 10:15	2026-10-02 10:15	2026-10-02 10:15	AAPL	AAPL261002C00335000	call	335.0000	2026-10-02	0.8400	0.8200	0.8500	334.2600	27797.00	85.00	27546.00	331	23	73311	19105	3.83726773096048	0.340279459050948	0.339135938221349	true	false	false
f907b65e-656f-42c3-81ac-60afe2910fbc	2026-10-02 10:15	2026-10-02 10:15	2026-10-02 10:15	AAPL	AAPL261002C00335000	call	335.0000	2026-10-02	0.8600	0.8400	0.8700	334.3200	11643.00	5339.00	6304.00	136	22	72453	19105	3.79235802146035	0.33793458499591	0.334764359420188	false	false	false
83da9f89-1557-4712-af86-2af3d518f479	2026-10-02 10:14	2026-10-02 10:14	2026-10-02 10:14	AAPL	AAPL261002C00335000	call	335.0000	2026-10-02	0.7100	0.6700	0.7500	333.9100	11817.00	569.00	10568.00	166	41	69553	19105	3.64056529704266	0.337257030054406	0.33330079913761	true	false	false
a9113cd7-6dab-4168-aaf7-50637b85cec9	2026-10-02 10:14	2026-10-02 10:14	2026-10-02 10:14	AAPL	AAPL261002C00335000	call	335.0000	2026-10-02	0.7500	0.7300	0.7500	334.0650	18865.00	16275.00	2590.00	252	14	68786	19105	3.60041873855012	0.333314593445306	0.337375365043007	false	false	false
ee81b45d-d39e-4c66-abb8-1ae726be0697	2026-10-02 10:09	2026-10-02 10:09	2026-10-02 10:09	AAPL	AAPL261002C00335000	call	335.0000	2026-10-02	0.6800	0.6600	0.7000	333.7799	16929.00	3916.00	9127.00	249	44	52840	19105	2.76576812352787	0.346827992680485	0.341767160358296	true	false	false
1647d04c-99dc-48dc-bd51-cde0e120cd88	2026-10-02 10:01	2026-10-02 10:01	2026-10-02 10:01	AAPL	AAPL261002C00335000	call	335.0000	2026-10-02	0.3600	0.3600	0.3800	332.6550	15338.00	38.00	15300.00	426	14	37388	19105	1.9569746139754	0.346435911503753	0.338621536061661	false	false	false
ff1c4797-4ef4-4b3b-abc4-6867d54c2493	2026-10-02 09:36	2026-10-02 09:36	2026-10-02 09:36	AAPL	AAPL261002C00335000	call	335.0000	2026-10-02	0.5000	0.4900	0.5200	332.6000	11948.00	0.00	11948.00	239	10	10210	19105	0.534415074587804	0.381112743034017	0.37931269201647	false	false	false
8c0b52a5-805e-4b58-a462-e7071fd5a590	2026-10-02 09:30	2026-10-02 09:30	2026-10-02 09:30	AAPL	AAPL261002C00335000	call	335.0000	2026-10-02	0.7900	0.7300	0.8900	332.8000	11416.00	7120.00	4296.00	144	10	812	19105	0.0425019628369537	0.429631032505874	0.438553813172801	false	false	false
7c8cbbbe-d30d-4180-be12-df9b0036747c	2026-10-02 09:30	2026-10-02 09:30	2026-10-02 09:30	AAPL	AAPL261002C00335000	call	335.0000	2026-10-02	0.7500	0.7500	0.8000	333.1900	14403.00	0.00	14403.00	192	5	407	19105	0.0213033237372416	0.414671044374428	0.407379315415059	false	false	false
e5240b14-8d61-4bcd-aeca-0cb3ec8c6f85	2026-10-01 09:45	2026-10-01 09:45	2026-10-01 09:45	AAPL	AAPL261002C00335000	call	335.0000	2026-10-02	1.2200	1.2200	1.2600	332.0500	12725.00	1008.00	11717.00	104	9	10999	5747	1.91386810509831	0.346330864897627	0.351161435575606	false	false	false
18f23490-805c-41bb-9dcf-79a4f1ae78a7	2026-10-01 09:31	2026-10-01 09:30	2026-10-01 09:30	AAPL	AAPL261002C00335000	call	335.0000	2026-10-02	0.7500	0.7500	0.7900	329.9950	12008.00	158.00	11850.00	160	5	841	5747	0.146337219418827	0.36542356522018	0.357552917407291	false	false	false
55ddc074-8015-4842-a5de-69997521e326	2026-09-30 15:54	2026-09-30 15:54	2026-09-30 15:54	AAPL	AAPL261002C00335000	call	335.0000	2026-10-02	2.3900	2.3500	2.4700	334.0600	17957.00	0.00	17957.00	75	5	22237	9663	2.30125219911001	0.282878751627813	0.279552600582782	false	false	false
e4a38079-384f-419c-b0ff-3d572266c963	2026-09-30 10:10	2026-09-30 10:10	2026-09-30 10:10	AAPL	AAPL261002C00335000	call	335.0000	2026-10-02	5.4100	5.3500	5.6500	338.8000	16782.00	565.00	15117.00	31	16	13500	9663	1.39708165166097	0.321711386126948	0.324707696986478	false	false	false
6591d5a2-c5c5-4c64-8236-0cda0c1a2877	2026-09-30 09:54	2026-09-30 09:54	2026-09-30 09:54	AAPL	AAPL261002C00335000	call	335.0000	2026-10-02	2.7000	2.6500	2.7400	334.5500	28610.00	27540.00	1070.00	106	6	7517	9663	0.777915761150781	0.293719690027379	0.290746022276067	false	false	false
79527506-3c9b-424d-a006-1c0d4b53f306	2026-09-30 09:50	2026-09-30 09:50	2026-09-30 09:50	AAPL	AAPL261002C00335000	call	335.0000	2026-10-02	2.2400	2.1500	2.2500	333.0000	13441.00	11250.00	2191.00	60	8	4680	9663	0.484321639242471	0.29326809704394	0.289768159854078	false	false	false
684f6f81-befc-4606-856f-f4db9e76db5b	2026-09-29 11:17	2026-09-29 11:17	2026-09-29 11:17	AAPL	AAPL261002C00335000	call	335.0000	2026-10-02	2.1200	2.0700	2.1400	332.2900	109923.00	109285.00	638.00	518	17	9933	4274	2.32405240992045	0.270720463817407	0.270720463817407	true	false	false
b212205b-cfd7-4435-ad6b-f91db2ece2f7	2026-09-29 11:04	2026-09-29 11:04	2026-09-29 11:04	AAPL	AAPL261002C00335000	call	335.0000	2026-10-02	2.0900	2.0800	2.1500	332.2000	20916.00	19228.00	1688.00	100	6	7893	4274	1.84674777725784	0.271288187476587	0.270197428280581	true	false	false
7bf764e6-a55a-4883-8f5f-c9f800769240	2026-09-25 10:39	2026-09-25 10:39	2026-09-25 10:39	AAPL	AAPL261002C00335000	call	335.0000	2026-10-02	5.5100	5.4500	5.5500	337.1200	27532.00	17632.00	0.00	50	5	1080	4104	0.263157894736842	0.227117395269276	0.227117395269276	false	false	false