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 = RepeatedHitsAscendingFill×endpoint = /api/option-trades/flow-alerts×ticker = MCD×

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

998bce29-c1fe-4239-ae17-dd285e838c62	2026-10-02 10:30	2026-10-02 10:30	2026-10-02 10:30	MCD	MCD261218C00235000	call	235.0000	2026-12-18	8.9400	8.8500	9.3500	231.8750	29505.00	0.00	24135.00	33	6	203	485	0.418556701030928	0.221857745448026	0.222563845593202	true	false	false	true	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	Common Stock	Consumer Cyclical	164094994624.00	2026-11-04	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-10-02T14:31:51.668156Z"}	2026-10-02	2026-10-02 21:15	2026-10-02 21:15
ec70ea33-9a79-41a3-ab04-b22d6e1f6961	2026-10-02 09:37	2026-10-02 09:37	2026-10-02 09:37	MCD	MCD261002C00230000	call	230.0000	2026-10-02	1.8600	1.8300	2.2400	231.6201	171414.00	19264.00	151776.00	921	48	945	310	3.04838709677419	0.208446849061471	0.342085469326305	false	false
08c6c4bb-42fd-49da-9ec8-0250ba1543ae	2026-10-01 12:15	2026-10-01 12:14	2026-10-01 12:14	MCD	MCD290119P00240000	put	240.0000	2029-01-19	33.0300	33.0000	34.1500	231.5000	300560.00	9960.00	290600.00	91	16	91	50	1.82	0.306136803513096	0.307680360374595	false	false
ee5a5b77-f418-417c-b746-5bd276def941	2026-10-01 10:02	2026-10-01 10:02	2026-10-01 10:02	MCD	MCD261002C00232500	call	232.5000	2026-10-02	0.7500	0.7100	0.9000	230.9450	39823.00	16797.00	23026.00	528	33	755	839	0.899880810488677	0.285667187755014	0.290216931740268	true	false
bdbbb109-6754-444f-a1db-914a31ecde0b	2026-10-01 09:45	2026-10-01 09:45	2026-10-01 09:45	MCD	MCD261218C00250000	call	250.0000	2026-12-18	4.0000	3.8500	4.1000	232.0000	80018.00	60000.00	20018.00	200	13	228	2012	0.113320079522863	0.225335705671978	0.225335705671978	false	false
04b99a3a-53d4-43d6-b178-6b35d8d7cfd4	2026-09-30 10:16	2026-09-30 10:15	2026-09-30 10:15	MCD	MCD261002C00235000	call	235.0000	2026-10-02	1.3400	1.3200	1.5500	233.8200	163141.00	134.00	162872.00	1216	46	1456	602	2.41860465116279	0.268426409464855	0.267214172830191	true	false
e535955e-01f2-4838-909d-184624a491eb	2026-09-29 12:40	2026-09-29 12:40	2026-09-29 12:40	MCD	MCD290119C00350000	call	350.0000	2029-01-19	10.4000	10.4000	11.1000	234.4300	68660.00	2100.00	66560.00	66	23	66	17	3.88235294117647	0.226054128647049	0.227411566887031	false	false
edcfd220-8022-4a98-b79c-04da9bf740c1	2026-09-28 14:08	2026-09-28 14:07	2026-09-28 14:07	MCD	MCD261120C00260000	call	260.0000	2026-11-20	1.6600	1.6600	1.7800	234.0000	82016.00	1837.00	80179.00	494	34	614	1244	0.493569131832797	0.239774253684561	0.240244148289368	false	false
e4cfdeb0-5615-4946-b5cc-f533f39b582b	2026-09-28 12:20	2026-09-28 12:20	2026-09-28 12:20	MCD	MCD261218C00250000	call	250.0000	2026-12-18	4.5900	4.5000	4.6500	233.8750	34404.00	34404.00	0.00	75	6	468	1359	0.344370860927152	0.221341311883165	0.221083835919515	false	false
b96723ad-fa29-47b6-9a09-b808c94c5f8e	2026-09-28 11:07	2026-09-28 11:07	2026-09-28 11:07	MCD	MCD261218C00235000	call	235.0000	2026-12-18	10.7800	10.6500	10.9000	235.0400	16168.00	7552.00	8616.00	15	7	55	260	0.211538461538462	0.218653786903851	0.218653786903851	false	false
aaf6d9ba-c112-456f-b89a-6c0f041457d3	2026-09-25 14:24	2026-09-25 14:24	2026-09-25 14:24	MCD	MCD261002P00245000	put	245.0000	2026-10-02	8.1300	8.1000	8.5000	236.9900	40655.00	0.00	40655.00	50	10	79	360	0.219444444444444	0.181139725074751	0.192697979711143	false	false
21f5e858-8f94-4cbf-9ced-19e4d98be9da	2026-09-25 10:28	2026-09-25 10:28	2026-09-25 10:28	MCD	MCD261016P00250000	put	250.0000	2026-10-16	13.3600	12.8500	13.5500	237.2250	14692.00	13355.00	1337.00	11	5	86	4179	0.0205790859057191	0.217015203158834	0.219777378629544	false	false
e65baf9a-a307-445b-98f6-5e32309e2e51	2026-09-24 13:15	2026-09-24 13:14	2026-09-24 13:14	MCD	MCD261120C00240000	call	240.0000	2026-11-20	9.5700	9.4000	9.6500	240.1200	96630.00	12389.00	84241.00	101	6	759	1018	0.745579567779961	0.230141055866784	0.231471616865173	false	false
1f2123cf-2596-4865-b5ef-165e0dabcd18	2026-09-24 13:13	2026-09-24 13:13	2026-09-24 13:13	MCD	MCD261120C00240000	call	240.0000	2026-11-20	9.6300	9.5000	9.7500	240.1850	192642.00	8667.00	183975.00	200	5	658	1018	0.646365422396857	0.231852900289441	0.232385162269171	true	false
2249d735-0fba-4578-b568-86143880f378	2026-09-24 11:45	2026-09-24 11:45	2026-09-24 11:45	MCD	MCD271217P00180000	put	180.0000	2027-12-17	4.3000	4.1500	4.9000	240.7200	48987.00	3900.00	45087.00	114	39	114	65	1.75384615384615	0.282486574174141	0.283414120201938	false	false
304ba53a-edd9-4f03-b008-244c2ad5a8e0	2026-09-24 11:21	2026-09-24 11:21	2026-09-24 11:21	MCD	MCD280121C00300000	call	300.0000	2028-01-21	11.6500	11.6500	11.8500	240.6500	17481.00	0.00	17481.00	15	8	341	5462	0.0624313438300989	0.228812693543596	0.228812693543596	true	false
89c83eb4-5d56-45bb-9188-b0132e055d4b	2026-09-24 10:31	2026-09-24 10:31	2026-09-24 10:31	MCD	MCD260925C00242500	call	242.5000	2026-09-25	0.6900	0.6400	0.8600	240.4950	24250.00	3864.00	20386.00	350	28	2100	2147	0.978108989287378	0.292046368036499	0.296615272329526	false	false
a16cd852-31ef-4d09-837f-3bea915c3e29	2026-09-24 10:22	2026-09-24 10:22	2026-09-24 10:22	MCD	MCD260925C00237500	call	237.5000	2026-09-25	4.2000	4.2000	4.3500	241.3300	128951.00	0.00	128951.00	307	40	623	1586	0.39281210592686	0.315151315564876	0.315151315564876	false	false
00302403-f80a-469e-95b8-d0f9f05a4ecd	2026-09-24 09:32	2026-09-24 09:31	2026-09-24 09:31	MCD	MCD260925C00242500	call	242.5000	2026-09-25	1.0000	0.9300	1.0100	240.7600	13698.00	13698.00	0.00	137	7	339	2147	0.157894736842105	0.351947694611532	0.343629776823575	false	false
3a87cdb0-5035-48a3-929b-9669a3bdcc85	2026-09-24 09:30	2026-09-24 09:30	2026-09-24 09:30	MCD	MCD261002C00242500	call	242.5000	2026-10-02	2.2300	2.2300	2.2500	239.2701	15644.00	3825.00	0.00	70	6	148	438	0.337899543378995	0.248661288104906	0.25015136262456	false	false
b77060d9-3834-490d-908b-6af8f7ac0692	2026-09-23 15:01	2026-09-23 15:01	2026-09-23 15:01	MCD	MCD290119P00200000	put	200.0000	2029-01-19	14.7600	14.5500	15.3000	237.5800	28035.00	26555.00	1480.00	19	8	37	21	1.76190476190476	0.294644071901423	0.29452196895533	false	false
683964e0-bb51-40bd-bacd-3a0ad5af535d	2026-09-23 13:59	2026-09-23 13:59	2026-09-23 13:59	MCD	MCD261016C00245000	call	245.0000	2026-10-16	2.7000	2.6800	2.8000	237.6850	147998.00	58619.00	89379.00	548	19	2787	45	61.9333333333333	0.22387216755894	0.225276506020129	true	false
2c99eb0c-587e-4a2e-a560-7008448b46a5	2026-09-23 12:31	2026-09-23 12:31	2026-09-23 12:31	MCD	MCD260925C00235000	call	235.0000	2026-09-25	2.2800	2.2000	2.4700	234.8600	20985.00	2283.00	18702.00	92	12	1505	143	10.5244755244755	0.335049936402072	0.336491766245513	true	false
9104c7ba-488c-427d-bd56-206eea855169	2026-09-23 12:26	2026-09-23 12:26	2026-09-23 12:26	MCD	MCD260925P00232500	put	232.5000	2026-09-25	1.0000	0.9800	1.0700	235.1950	11964.00	0.00	11964.00	120	8	13292	163	81.5460122699387	0.299720443240947	0.304707238469579	false	false
a7dfd10d-c996-4b05-bd3f-8ff4ba1e61c8	2026-09-23 11:43	2026-09-23 11:42	2026-09-23 11:42	MCD	MCD271217C00250000	call	250.0000	2027-12-17	23.7800	23.7000	24.9500	236.0000	713412.00	0.00	713412.00	300	6	762	474	1.60759493670886	0.224731613505456	0.226582871225101	false	false
8039d612-fca3-4d08-b685-7a872b5753e5	2026-09-23 11:37	2026-09-23 11:37	2026-09-23 11:37	MCD	MCD270115C00300000	call	300.0000	2027-01-15	1.0500	1.0000	1.0800	237.2301	30614.00	2369.00	28245.00	292	7	2621	12121	0.216236284134972	0.258026074446725	0.259124114227159	true	false
d9b6e1bc-eb12-4c5a-81c0-f00931131392	2026-09-23 10:53	2026-09-23 10:53	2026-09-23 10:53	MCD	MCD261016C00250000	call	250.0000	2026-10-16	2.0000	1.9600	2.0900	239.6450	15017.00	204.00	14813.00	75	9	925	1321	0.700227100681302	0.227258792605891	0.229339142492952	true	false
2d7c54c8-50ce-4f38-8647-f3bbc21fc31c	2026-09-23 10:46	2026-09-23 10:46	2026-09-23 10:46	MCD	MCD270115P00230000	put	230.0000	2027-01-15	7.7000	7.6500	7.9500	239.9400	743053.00	2310.00	740743.00	965	43	1136	1593	0.713119899560578	0.253618372469078	0.253618372469078	false	false
7ad160ac-3250-4255-b107-7faa6bbd12e6	2026-09-23 10:15	2026-09-23 10:15	2026-09-23 10:15	MCD	MCD280121C00270000	call	270.0000	2028-01-21	19.6500	19.1000	19.9500	239.3500	11790.00	3950.00	7840.00	6	5	39	766	0.0509138381201044	0.231154573396568	0.231154573396568	false	false
81344873-c9d5-411c-abd0-22029d973d0b	2026-09-23 09:54	2026-09-23 09:54	2026-09-23 09:54	MCD	MCD260925P00265000	put	265.0000	2026-09-25	25.1300	25.1000	26.8000	239.6200	198540.00	125750.00	72790.00	79	5	79	170	0.464705882352941	1.20872716085215	0.382979013222508	true	false
840364ca-0d50-4ed6-81d7-771376921a79	2026-09-23 09:54	2026-09-23 09:54	2026-09-23 09:54	MCD	MCD270617C00280000	call	280.0000	2027-06-17	9.0100	8.4500	9.1000	239.4912	18016.00	18016.00	0.00	20	5	80	5432	0.0147275405007364	0.240727283477941	0.24058869265531	true	false
dbc1c8b5-6b88-4939-a0b2-64e9d13fc62e	2026-09-23 09:54	2026-09-23 09:54	2026-09-23 09:54	MCD	MCD260925P00237500	put	237.5000	2026-09-25	1.5700	1.5400	1.7500	239.7200	26373.00	10697.00	15676.00	168	19	640	382	1.67539267015707	0.359892064500071	0.359892064500071	true	false
35ed7e5d-d791-4723-a97c-6cdd6172a80e	2026-09-23 09:48	2026-09-23 09:48	2026-09-23 09:48	MCD	MCD270115P00220000	put	220.0000	2027-01-15	4.0000	3.5500	4.2500	242.0000	12815.00	12410.00	405.00	32	10	40	985	0.0406091370558376	0.252114028498497	0.253443096835034	false	false
d569ded0-9da5-4de5-b089-6830b96cb124	2026-09-23 09:37	2026-09-23 09:36	2026-09-23 09:36	MCD	MCD260925P00245000	put	245.0000	2026-09-25	3.1200	2.4900	3.2000	244.0700	22180.00	11025.00	11155.00	71	5	286	2243	0.127507802050825	0.347970924532581	0.365424796046713	true	false
05408d6b-88a1-4dc8-9e4c-1cc1753973ff	2026-09-23 09:37	2026-09-23 09:36	2026-09-23 09:36	MCD	MCD261009P00240000	put	240.0000	2026-10-09	2.6900	2.2700	2.7200	243.9724	36648.00	18495.00	18153.00	136	5	149	291	0.512027491408935	0.224902391047824	0.226502235469016	true	false
e9375332-c1bc-45e1-ae8d-fbbc6124b5b0	2026-09-23 09:36	2026-09-23 09:36	2026-09-23 09:36	MCD	MCD260925P00245000	put	245.0000	2026-09-25	2.9400	2.4300	3.1500	244.2150	12634.00	7687.00	4947.00	43	8	209	2243	0.0931787784217566	0.349920296956629	0.349920296956629	true	false
b31c5157-5406-4978-a5b6-9211f0d645ce	2026-09-23 09:36	2026-09-23 09:36	2026-09-23 09:36	MCD	MCD260925P00242500	put	242.5000	2026-09-25	1.7200	1.2100	1.8100	244.2900	16713.00	8768.00	7945.00	97	5	197	1300	0.151538461538462	0.352499644757372	0.354261603131029	true	false
49b6a3ff-d717-4f7f-9902-56e535886d91	2026-09-22 14:41	2026-09-22 14:41	2026-09-22 14:41	MCD	MCD270917P00250000	put	250.0000	2027-09-17	21.3100	20.8000	21.6500	250.6000	57545.00	21300.00	36245.00	27	10	78	258	0.302325581395349	0.274841575985549	0.275369304125384	false	false
b5c81f4c-2a74-4811-852f-e9d038fb6205	2026-09-22 10:39	2026-09-22 10:39	2026-09-22 10:39	MCD	MCD261023C00260000	call	260.0000	2026-10-23	3.7000	3.2500	3.8500	251.9500	18494.00	18494.00	0.00	50	5	177	166	1.06626506024096	0.223573500293255	0.223573500293255	false	false
8ae265b0-c29e-469f-888c-da3c16ae1ed8	2026-09-22 10:39	2026-09-22 10:39	2026-09-22 10:39	MCD	MCD261023C00260000	call	260.0000	2026-10-23	3.6900	3.2500	3.9000	251.9400	36926.00	36212.00	714.00	100	5	127	166	0.765060240963855	0.220001581090717	0.220001581090717	false	false
2b79f33e-9863-4dab-a06a-3644e1368c59	2026-09-22 09:54	2026-09-22 09:54	2026-09-22 09:54	MCD	MCD270617C00300000	call	300.0000	2027-06-17	7.0800	7.0000	7.2500	250.2350	16286.00	5043.00	11243.00	23	19	57	5428	0.0105011053795136	0.231965280933878	0.231965280933878	false	false
bcdcf76c-4869-4fda-84aa-20795df14dc1	2026-09-22 09:46	2026-09-22 09:46	2026-09-22 09:46	MCD	MCD270319C00280000	call	280.0000	2027-03-19	7.7300	7.1000	7.8500	251.0000	10051.00	10051.00	0.00	13	8	43	814	0.0528255528255528	0.230116478777777	0.230116478777777	false	false
2de901c5-329e-430b-81bb-32474232da30	2026-09-22 09:35	2026-09-22 09:34	2026-09-22 09:34	MCD	MCD270115C00260000	call	260.0000	2027-01-15	10.4800	10.1500	10.5000	251.2600	59742.00	59742.00	0.00	57	9	80	1680	0.0476190476190476	0.226082911878215	0.228226199478286	false	false
69ed65ec-2fed-402c-b2e1-d0f5cf840381	2026-09-21 14:53	2026-09-21 14:53	2026-09-21 14:53	MCD	MCD270115C00260000	call	260.0000	2027-01-15	9.1200	8.9500	9.1500	248.1000	100284.00	100284.00	0.00	110	9	340	1168	0.291095890410959	0.226872387306095	0.227968593289981	false	false
eaefe027-e2f5-4604-aae4-7ae089070a47	2026-09-21 13:50	2026-09-21 13:50	2026-09-21 13:50	MCD	MCD260925C00235000	call	235.0000	2026-09-25	13.0800	12.5500	13.2000	247.6899	32694.00	32694.00	0.00	25	6	184	7	26.2857142857143	0.346029230577444	0.346029230577444	false	false
3cbda6d8-ef74-404e-924d-45ca31ed94c7	2026-09-21 13:49	2026-09-21 13:49	2026-09-21 13:49	MCD	MCD260925C00247500	call	247.5000	2026-09-25	3.2100	3.0000	3.3000	247.5900	16050.00	16050.00	0.00	50	5	1891	71	26.6338028169014	0.299950729393067	0.301886572387798	false	false
fc2f8412-f7d7-4caf-bf35-8db7d7ab8b5a	2026-09-21 13:46	2026-09-21 13:46	2026-09-21 13:46	MCD	MCD260925C00247500	call	247.5000	2026-09-25	3.2700	3.0000	3.3000	247.7000	16330.00	16330.00	0.00	50	7	1791	71	25.2253521126761	0.300230070920597	0.300230070920597	false	false
67531293-46df-4f2c-aad6-35ab6f8d1c6c	2026-09-21 13:46	2026-09-21 13:46	2026-09-21 13:46	MCD	MCD260925C00247500	call	247.5000	2026-09-25	3.2200	3.0000	3.3000	247.6500	16075.00	16075.00	0.00	50	6	1691	71	23.8169014084507	0.296942425551637	0.299846511363791	false	false
110baf0c-550f-4ee9-9b79-d182d272a397	2026-09-21 12:34	2026-09-21 12:34	2026-09-21 12:34	MCD	MCD260925C00250000	call	250.0000	2026-09-25	2.4100	2.2500	2.5000	248.6799	12070.00	12070.00	0.00	50	6	924	1146	0.806282722513089	0.28591510206592	0.28591510206592	false	false
34bd2a78-80cf-42b5-9de4-2a9017a59ccb	2026-09-14 10:35	2026-09-14 10:35	2026-09-14 10:35	MCD	MCD271217C00270000	call	270.0000	2027-12-17	26.2000	25.6500	26.4500	257.6800	70735.00	60235.00	10500.00	27	8	60	397	0.151133501259446	0.21555254567107	0.21643243295673	true	false