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.

326,449 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts326,449 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:er_time = unknown×ticker = MCD×

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

1de78c83-062a-4e92-9635-0d553f3bfb22	2026-09-21 14:08	2026-09-21 14:08	2026-09-21 14:08	MCD	MCD261120P00250000	put	250.0000	2026-11-20	9.6500	9.5500	9.6500	247.0000	159225.00	159225.00	0.00	165	29	2282	1219	1.87202625102543	0.232824908473059	0.232824908473059	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Consumer Cyclical	175410182704.00	2026-11-04	unknown	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-21T18:09:57.736377Z"}	2026-09-21	2026-09-21 21:15	2026-09-21 21:15
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	false	true	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	false	true	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	false	true	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	false	true	false
df1988e1-4996-4f34-82df-90b10c3b8f25	2026-09-21 13:45	2026-09-21 13:45	2026-09-21 13:45	MCD	MCD260925C00247500	call	247.5000	2026-09-25	3.1500	2.9200	3.3000	247.0000	22365.00	4410.00	17955.00	71	8	1612	71	22.7042253521127	0.291598891328812	0.291598891328812	false	false	false	true
6eb0efd9-0adf-490a-8a17-a8fc39a3793a	2026-09-21 13:34	2026-09-21 13:34	2026-09-21 13:34	MCD	MCD260925P00247500	put	247.5000	2026-09-25	2.7200	2.5100	2.7200	247.0000	180579.00	172720.00	7859.00	664	52	1175	398	2.95226130653266	0.283471285082999	0.283471285082999	false	false	false	true
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	false	true	false
1d6450fa-208d-49d2-be96-4bc861e1a417	2026-09-21 12:30	2026-09-21 12:30	2026-09-21 12:30	MCD	MCD261016P00250000	put	250.0000	2026-10-16	6.0000	5.9500	6.2000	248.0000	15000.00	600.00	14400.00	25	10	1749	3293	0.531126632250228	0.213843898480007	0.213843898480007	false	false	false	true
fa13eedd-90a6-40a1-a7cc-aa79ad3621bd	2026-09-21 12:24	2026-09-21 12:24	2026-09-21 12:24	MCD	MCD261016P00250000	put	250.0000	2026-10-16	6.1000	5.9500	6.1000	248.3819	181150.00	181150.00	0.00	297	35	1717	3293	0.521409049498937	0.21625100197411	0.21625100197411	false	false	false	true
87ce1b53-a4b0-47a3-9cbb-a0937bb2da5a	2026-09-21 12:15	2026-09-21 12:15	2026-09-21 12:15	MCD	MCD261120C00250000	call	250.0000	2026-11-20	9.6700	9.6000	9.9000	248.6000	10637.00	5806.00	4831.00	11	5	1247	757	1.64729194187583	0.237742846684626	0.238216366260466	false	false	false	true
da7851d5-77f0-4360-84d8-36921edad1b1	2026-09-21 11:37	2026-09-21 11:37	2026-09-21 11:37	MCD	MCD270617C00300000	call	300.0000	2027-06-17	6.3500	6.1500	6.3500	247.0000	33655.00	21590.00	0.00	53	7	401	5216	0.0768788343558282	0.229909018941872	0.229909018941872	false	false	false	true
b88daecd-d2eb-4ef3-9110-349b2fb40e88	2026-09-21 11:27	2026-09-21 11:27	2026-09-21 11:27	MCD	MCD260925P00245000	put	245.0000	2026-09-25	1.6100	1.4500	1.6100	248.0000	127190.00	127190.00	0.00	790	47	1178	1120	1.05178571428571	0.285179588311625	0.282032898728742	false	false	false	true
882075d4-1369-47b8-9ea9-fa4c0dd35c38	2026-09-21 11:13	2026-09-21 11:13	2026-09-21 11:13	MCD	MCD261120C00250000	call	250.0000	2026-11-20	9.4300	9.4000	9.5500	248.0550	13205.00	3780.00	4700.00	14	7	367	757	0.484808454425363	0.238855618398616	0.238791412306392	false	false	false	true
b0483c75-3a6e-41aa-aab8-ffdf62f6d617	2026-09-21 11:12	2026-09-21 11:12	2026-09-21 11:12	MCD	MCD260925C00247500	call	247.5000	2026-09-25	3.0500	2.8300	3.1000	247.0000	93002.00	68297.00	22570.00	305	28	1245	71	17.5352112676056	0.286680205627201	0.285431734735278	true	false	false	true
a678ed6a-9223-42e5-957c-ea7150c1d0cb	2026-09-21 11:11	2026-09-21 11:11	2026-09-21 11:11	MCD	MCD260925C00247500	call	247.5000	2026-09-25	3.0000	2.9100	3.0500	247.0000	22800.00	4200.00	18600.00	76	7	848	71	11.943661971831	0.283583086457875	0.283583086457875	true	false	false	true	false
88490970-448d-4140-8255-5be46d0fd8d4	2026-09-21 11:11	2026-09-21 11:11	2026-09-21 11:11	MCD	MCD260925C00247500	call	247.5000	2026-09-25	3.0000	2.8000	3.1000	247.0000	27000.00	6000.00	21000.00	90	13	772	71	10.8732394366197	0.283583086457875	0.283583086457875	true	false	false	true
db82e9ff-dc83-4079-bb7c-db9797e937d6	2026-09-21 11:05	2026-09-21 11:05	2026-09-21 11:05	MCD	MCD261218C00280000	call	280.0000	2026-12-18	2.3500	2.3200	2.5000	247.5100	36136.00	0.00	36136.00	154	15	163	1325	0.123018867924528	0.227576622507412	0.226594840116512	false	false	false	true
1504ff31-6994-4837-90b1-fbd8a1ca456a	2026-09-21 10:51	2026-09-21 10:51	2026-09-21 10:51	MCD	MCD261016C00275000	call	275.0000	2026-10-16	0.3300	0.3300	0.3900	247.2900	11319.00	0.00	11319.00	343	16	384	1501	0.25582944703531	0.238652624331818	0.238652624331818	false	false	false	true
6bcdb24d-3c7b-477a-9ae0-9f7ed6d4ff9b	2026-09-21 10:23	2026-09-21 10:23	2026-09-21 10:23	MCD	MCD261218P00225000	put	225.0000	2026-12-18	2.9600	2.9600	3.4000	247.0000	30192.00	0.00	30192.00	102	11	104	255	0.407843137254902	0.245382633585584	0.245382633585584	false	false	false	true	false
eb8dc3ed-88c8-4961-a764-11a9d194c592	2026-09-21 10:02	2026-09-21 10:02	2026-09-21 10:02	MCD	MCD261218C00245000	call	245.0000	2026-12-18	13.0500	12.6000	13.2000	246.6400	45675.00	45675.00	0.00	35	16	37	269	0.137546468401487	0.22745256875644	0.22745256875644	true	false	false	true
78eb8a94-81ae-40e3-9c5f-7c0cccb93952	2026-09-18 15:16	2026-09-18 15:16	2026-09-18 15:16	MCD	MCD280121C00300000	call	300.0000	2028-01-21	13.9000	13.9000	14.5000	249.6450	72280.00	0.00	72280.00	52	12	315	4219	0.074662242237497	0.220488029418017	0.220488029418017	false	false	false	true
46305226-b81c-4e21-bf13-92fa09067d89	2026-09-18 11:35	2026-09-18 11:35	2026-09-18 11:35	MCD	MCD270115C00250000	call	250.0000	2027-01-15	14.1500	14.1500	14.3000	249.7950	100465.00	0.00	100465.00	71	24	166	808	0.205445544554455	0.220800684965558	0.220800684965558	false	false	false	true
fd42cee3-6be2-4121-a95e-7f9bc79f37b8	2026-09-17 15:48	2026-09-17 15:48	2026-09-17 15:48	MCD	MCD261120P00250000	put	250.0000	2026-11-20	9.4000	9.0500	9.4000	248.6400	54520.00	54520.00	0.00	58	12	284	934	0.30406852248394	0.231965558630556	0.231965558630556	false	false	false	true	false
e11680cc-2726-49a4-986c-42f3c6385b84	2026-09-17 15:00	2026-09-17 15:00	2026-09-17 15:00	MCD	MCD260918C00250000	call	250.0000	2026-09-18	1.2100	1.1900	1.2500	249.8300	80207.00	48077.00	17850.00	664	17	1349	534	2.52621722846442	0.247241296359367	0.252995859820707	true	false	false	true
83050f6b-fe3a-4293-b74d-add8fbe178a3	2026-09-17 15:00	2026-09-17 15:00	2026-09-17 15:00	MCD	MCD261120C00250000	call	250.0000	2026-11-20	10.7500	10.6000	10.7500	249.8300	88111.00	88111.00	0.00	82	9	92	557	0.165170556552962	0.238316813970611	0.238316813970611	false	false	false	true
6c63433c-68eb-4af8-bdeb-acda32615aef	2026-09-17 15:00	2026-09-17 15:00	2026-09-17 15:00	MCD	MCD260925C00250000	call	250.0000	2026-09-25	3.5000	3.4000	4.2000	250.0150	65450.00	27650.00	37800.00	187	20	669	221	3.02714932126697	0.235641755803066	0.229204182499504	false	false	false	true
537bc154-e819-427c-846f-0f4b6d40d223	2026-09-17 15:00	2026-09-17 15:00	2026-09-17 15:00	MCD	MCD261002C00255000	call	255.0000	2026-10-02	2.6000	2.2600	2.6000	249.8300	54599.00	54599.00	0.00	210	19	255	261	0.977011494252874	0.225118002803869	0.225118002803869	false	false	false	true
ad374807-344a-4812-a6d2-2f441d366495	2026-09-17 14:16	2026-09-17 14:16	2026-09-17 14:16	MCD	MCD280121C00250000	call	250.0000	2028-01-21	32.2500	32.2500	32.6500	249.9100	96750.00	0.00	96750.00	30	15	59	896	0.0658482142857143	0.212857972792183	0.212857972792183	false	false	false	true
05b43bf2-2e6b-4926-8b58-c1b000aa9626	2026-09-17 14:16	2026-09-17 14:16	2026-09-17 14:16	MCD	MCD280121C00250000	call	250.0000	2028-01-21	32.2500	32.2500	32.6500	249.9100	58050.00	0.00	58050.00	18	9	77	896	0.0859375	0.212857972792183	0.212857972792183	false	false	false	true	false
f9666327-f4ee-4d2d-8204-6c2205b245a3	2026-09-17 12:02	2026-09-17 12:02	2026-09-17 12:02	MCD	MCD261218C00250000	call	250.0000	2026-12-18	12.3000	12.1500	12.6000	249.6200	184505.00	6150.00	177120.00	150	34	159	444	0.358108108108108	0.222965641106873	0.223638344851892	true	false	false	true
57befe88-9c37-45fb-a553-eb22b2060f52	2026-09-17 12:02	2026-09-17 12:02	2026-09-17 12:02	MCD	MCD261218C00245000	call	245.0000	2026-12-18	15.0500	14.8500	15.4000	249.6200	373235.00	1495.00	371740.00	248	38	251	62	4.04838709677419	0.223903614988536	0.222588607515315	false	false	false	true
65bb08d7-8668-4bf1-bca0-5b76999050ee	2026-09-17 10:47	2026-09-17 10:47	2026-09-17 10:47	MCD	MCD261016P00250000	put	250.0000	2026-10-16	5.9000	5.7500	5.9000	249.5300	198228.00	198228.00	0.00	336	38	412	2811	0.146567057986482	0.216007158925028	0.216007158925028	false	false	false	true
1d83e579-12d1-4909-80f5-948ec47efba9	2026-09-17 10:47	2026-09-17 10:47	2026-09-17 10:47	MCD	MCD261016P00255000	put	255.0000	2026-10-16	8.7500	8.5500	8.7500	249.5300	110250.00	110250.00	0.00	126	26	133	1357	0.0980103168754606	0.216650052644575	0.216650052644575	false	false	false	true
ffd42421-a2f6-4cbe-837c-479d1b8f4476	2026-09-16 12:51	2026-09-16 12:51	2026-09-16 12:51	MCD	MCD270115C00300000	call	300.0000	2027-01-15	2.0000	1.9900	2.0500	251.6400	53000.00	16600.00	36400.00	265	6	1830	8629	0.212075559160969	0.232329597033057	0.232329597033057	false	false	false	true
6191d14c-6c80-418a-af88-e5488764b118	2026-09-16 11:43	2026-09-16 11:42	2026-09-16 11:42	MCD	MCD270115P00230000	put	230.0000	2027-01-15	4.8000	4.8000	4.9000	250.9100	99360.00	0.00	99360.00	207	24	250	1253	0.19952114924182	0.247778691238416	0.247778691238416	false	false	false	true	false
31ee14a8-6f22-4044-8466-2eb085da1d1e	2026-09-16 10:43	2026-09-16 10:43	2026-09-16 10:43	MCD	MCD270115C00300000	call	300.0000	2027-01-15	1.8600	1.7500	1.8700	249.6300	65348.00	65164.00	184.00	351	17	664	8629	0.0769498203731603	0.236297714521301	0.235946889004217	false	false	false	true
06cede6e-f524-4274-8e33-d91b01ef51c1	2026-09-16 10:29	2026-09-16 10:29	2026-09-16 10:29	MCD	MCD290119C00250000	call	250.0000	2029-01-19	43.8500	42.5000	43.8500	248.0000	877000.00	877000.00	0.00	200	18	203	1	203	0.208216510883203	0.208216510883203	false	false	false	true	false
35a6c23d-ce47-47a7-8189-80f742bb63b8	2026-09-14 12:51	2026-09-14 12:51	2026-09-14 12:51	MCD	MCD270115C00270000	call	270.0000	2027-01-15	9.4500	9.4500	9.8500	257.6420	53865.00	0.00	53865.00	57	8	136	1218	0.111658456486043	0.219807725629263	0.219807725629263	false	false	false	true
9ef94ea4-2587-40a7-8285-93494927e6f8	2026-09-14 12:04	2026-09-14 12:04	2026-09-14 12:04	MCD	MCD261218C00270000	call	270.0000	2026-12-18	7.7000	7.6000	8.0000	257.6330	191730.00	770.00	190960.00	249	35	302	1067	0.283036551077788	0.22411199026991	0.22411199026991	false	false	false	true
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	false	true
d1089c5d-e48a-4d95-9519-5d80e19c09bd	2026-09-14 09:54	2026-09-14 09:54	2026-09-14 09:54	MCD	MCD261016P00260000	put	260.0000	2026-10-16	7.3500	7.2500	7.9500	257.5450	294000.00	0.00	294000.00	400	7	454	2333	0.194599228461209	0.213495974355567	0.213495974355567	false	false	false	true
646281ce-1513-4577-90e8-22c3bcbd177d	2026-09-14 09:45	2026-09-14 09:45	2026-09-14 09:45	MCD	MCD280121C00250000	call	250.0000	2028-01-21	36.9900	35.8500	37.6500	257.0000	81375.00	81375.00	0.00	22	6	26	608	0.0427631578947368	0.212759052683531	0.212664534211572	false	false	false	true
a763a4a1-c1fa-48f5-a14d-ea597593107c	2026-09-14 09:41	2026-09-14 09:41	2026-09-14 09:41	MCD	MCD261016C00260000	call	260.0000	2026-10-16	5.8500	5.6000	6.2000	257.0000	197145.00	52650.00	144495.00	337	8	498	1468	0.339237057220708	0.218237622923534	0.218237622923534	true	false	false	true
8a533c53-3399-43a4-b31b-14e75c22641a	2026-09-11 09:42	2026-09-11 09:42	2026-09-11 09:42	MCD	MCD260918C00255000	call	255.0000	2026-09-18	2.0000	1.9300	2.0000	252.9400	94793.00	94600.00	193.00	474	6	558	1035	0.539130434782609	0.202277300664931	0.197105995433874	false	false	false	true
a143e36a-ad3a-4a08-8927-d26cf075cb96	2026-09-10 11:29	2026-09-10 11:29	2026-09-10 11:29	MCD	MCD270319C00300000	call	300.0000	2027-03-19	4.6000	4.4000	4.7000	253.6400	87328.00	52828.00	2300.00	190	6	262	2780	0.0942446043165468	0.228108403849499	0.228108403849499	false	false	false	true
fbd84ee1-e7ec-4e75-b213-f1d296b90602	2026-09-10 10:09	2026-09-10 10:09	2026-09-10 10:09	MCD	MCD260918C00255000	call	255.0000	2026-09-18	2.6800	2.6800	2.7700	253.5400	84420.00	0.00	84420.00	315	7	379	360	1.05277777777778	0.217560535821746	0.217560535821746	false	false	false	true
7faa98b4-5725-410e-9fdd-a1328b95e688	2026-09-09 14:40	2026-09-09 14:40	2026-09-09 14:40	MCD	MCD280121C00260000	call	260.0000	2028-01-21	30.3400	29.9000	30.7500	255.2000	54620.00	51585.00	3035.00	18	5	35	598	0.0585284280936455	0.213528049003611	0.213089905279168	false	false	false	true
659eac93-3a78-4b8d-a83c-c0291b7cf21f	2026-09-09 14:30	2026-09-09 14:30	2026-09-09 14:30	MCD	MCD270319C00290000	call	290.0000	2027-03-19	6.7500	6.5500	7.1500	255.2800	59400.00	11475.00	47925.00	88	6	110	482	0.228215767634855	0.224306875537019	0.224306875537019	false	false	false	true
f1ec9927-bd6e-4c82-bce9-f1c53876cff9	2026-09-09 12:32	2026-09-09 12:32	2026-09-09 12:32	MCD	MCD261218C00280000	call	280.0000	2026-12-18	4.2000	4.1500	4.5000	253.6100	140700.00	0.00	140700.00	335	32	358	597	0.599664991624791	0.226480040614114	0.227129714931465	false	false	false	true