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

ad8d5e83-c48f-42a2-b89d-2839f8532a1a	2026-09-22 15:57	2026-09-22 15:57	2026-09-22 15:57	MCD	MCD261002C00215000	call	215.0000	2026-10-02	35.6500	35.6500	37.5500	250.3500	163990.00	0.00	163990.00	46	21	46	4	11.5	0.411642851556946	0.411642851556946	true	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Consumer Cyclical	177158057286.00	2026-11-04	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-22T19:58:44.027893Z"}	2026-09-22	2026-09-22 21:15	2026-09-22 21:15
d5ed64f9-110b-4031-8a74-9251a6bfc5d6	2026-09-22 15:55	2026-09-22 15:55	2026-09-22 15:55	MCD	MCD270115C00300000	call	300.0000	2027-01-15	1.9200	1.7500	1.9200	250.5200	38400.00	38400.00	0.00	200	30	884	11740	0.0752981260647359	0.2407599082624	0.2407599082624	false	false	false	true
32a21d89-411e-429e-9364-77a6e25cda2f	2026-09-22 15:33	2026-09-22 15:33	2026-09-22 15:33	MCD	MCD270115P00230000	put	230.0000	2027-01-15	4.6000	4.4000	4.6000	251.0560	17020.00	17020.00	0.00	37	14	108	1550	0.0696774193548387	0.249509339793257	0.249509339793257	false	false	false	true	false
8c4bb363-5017-4eaf-be22-a9e5318903fa	2026-09-22 15:24	2026-09-22 15:24	2026-09-22 15:24	MCD	MCD290119P00230000	put	230.0000	2029-01-19	21.8000	21.5000	22.4500	251.0450	61040.00	4360.00	56680.00	28	7	32	24	1.33333333333333	0.294146711323353	0.294146711323353	false	false	false	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	false	true
1bcca70e-9a25-4cc6-8c81-350dfdada001	2026-09-22 14:32	2026-09-22 14:32	2026-09-22 14:32	MCD	MCD270319P00220000	put	220.0000	2027-03-19	4.8500	4.7000	4.8500	250.8500	16005.00	16005.00	0.00	33	10	37	286	0.129370629370629	0.262498275459273	0.262498275459273	false	false	false	true	false
7c207dcd-821c-4773-9bb4-727528761241	2026-09-22 14:26	2026-09-22 14:26	2026-09-22 14:26	MCD	MCD260925P00247500	put	247.5000	2026-09-25	1.5600	1.4300	1.6500	251.0500	14182.00	4368.00	9814.00	91	6	656	1380	0.47536231884058	0.336840361773656	0.336840361773656	true	false	false	true	false
e9aebdda-2d62-44ec-85a2-e94b3774cc8f	2026-09-22 14:01	2026-09-22 14:01	2026-09-22 14:01	MCD	MCD270319P00260000	put	260.0000	2027-03-19	20.7100	20.2000	20.9000	250.6900	20714.00	20714.00	0.00	10	6	20	1157	0.017286084701815	0.265724587222375	0.265724587222375	false	false	false	true	false
0692cfec-bf78-404d-9e5f-5ccf91e71324	2026-09-22 13:20	2026-09-22 13:20	2026-09-22 13:20	MCD	MCD270115P00240000	put	240.0000	2027-01-15	7.6500	7.5500	7.8000	251.0200	42075.00	39015.00	3060.00	55	7	123	2097	0.0586552217453505	0.249143829721514	0.249143829721514	false	false	false	true
31c36edd-333d-4991-bba2-c3855777d734	2026-09-22 13:17	2026-09-22 13:17	2026-09-22 13:17	MCD	MCD261016C00252500	call	252.5000	2026-10-16	5.2000	5.2000	5.4000	251.0105	15080.00	0.00	15080.00	29	7	139	13	10.6923076923077	0.218009522008514	0.218009522008514	false	false	false	true	false
51b1bdf8-0b43-4d97-9f97-d2b630b5aa80	2026-09-22 13:13	2026-09-22 13:13	2026-09-22 13:13	MCD	MCD270319P00225000	put	225.0000	2027-03-19	5.9500	5.7500	5.9500	251.1110	17845.00	17845.00	0.00	30	11	138	755	0.182781456953642	0.261174969404342	0.261174969404342	false	false	false	true	false
e5c99273-8e4b-4394-ae2a-5ba80da00bf5	2026-09-22 13:06	2026-09-22 13:06	2026-09-22 13:06	MCD	MCD270319P00225000	put	225.0000	2027-03-19	5.9000	5.7500	5.9000	251.4300	20650.00	20650.00	0.00	35	5	108	755	0.143046357615894	0.261504718230507	0.261504718230507	false	false	false	true	false
9e6defd6-41a9-482c-99f1-63994112913c	2026-09-22 12:21	2026-09-22 12:21	2026-09-22 12:21	MCD	MCD260925C00255000	call	255.0000	2026-09-25	1.5100	1.3900	1.5800	250.7350	13741.00	6493.00	7248.00	91	15	880	1272	0.691823899371069	0.346919681454992	0.346919681454992	true	false	false	true
820fa100-82f4-4331-8f96-b4ed3add69d7	2026-09-22 12:16	2026-09-22 12:16	2026-09-22 12:16	MCD	MCD261016C00260000	call	260.0000	2026-10-16	2.5400	2.5400	2.6300	250.8950	16256.00	0.00	13970.00	64	8	630	2130	0.295774647887324	0.222571315153493	0.222571315153493	false	false	false	true
4b0f8058-1052-4725-be8e-7005521927d0	2026-09-22 12:16	2026-09-22 12:16	2026-09-22 12:16	MCD	MCD261016C00260000	call	260.0000	2026-10-16	2.5500	2.5500	2.5900	250.8900	12750.00	0.00	11475.00	50	5	507	2130	0.238028169014084	0.223090518941562	0.223090518941562	false	false	false	true
b1304cf8-f34a-46f6-a1a3-af08c8c783f7	2026-09-22 12:16	2026-09-22 12:16	2026-09-22 12:16	MCD	MCD270115C00260000	call	260.0000	2027-01-15	10.2000	10.2000	10.5000	250.9800	158100.00	0.00	158100.00	155	20	436	1680	0.25952380952381	0.225158105343389	0.225158105343389	false	false	false	true
64529357-9215-43a9-abf2-9f3acd06cb9a	2026-09-22 12:15	2026-09-22 12:15	2026-09-22 12:15	MCD	MCD261016P00252500	put	252.5000	2026-10-16	6.0000	6.0000	6.1500	251.0106	12000.00	0.00	12000.00	20	6	40	52	0.769230769230769	0.216730145560976	0.216730145560976	false	false	false	true	false
402531cb-0ca8-4ee9-9bbf-d911ddf6786d	2026-09-22 12:07	2026-09-22 12:07	2026-09-22 12:07	MCD	MCD270917C00270000	call	270.0000	2027-09-17	19.1400	18.7000	19.4500	250.7900	61255.00	57425.00	3830.00	32	9	58	652	0.0889570552147239	0.226078189912245	0.226078189912245	true	false	false	true
23718a0a-0cd3-4af8-bdfe-b463764a9f88	2026-09-22 11:49	2026-09-22 11:49	2026-09-22 11:49	MCD	MCD261120P00260000	put	260.0000	2026-11-20	13.8500	13.7000	14.1000	250.7200	12465.00	1385.00	11080.00	9	8	15	1070	0.014018691588785	0.23477299697569	0.235241328046072	false	false	false	true
679e00fe-1462-42e7-8dd2-f10f1b3a6686	2026-09-22 11:44	2026-09-22 11:44	2026-09-22 11:44	MCD	MCD261016P00245000	put	245.0000	2026-10-16	2.9700	2.9100	2.9700	250.6000	11880.00	11880.00	0.00	40	7	109	3010	0.0362126245847176	0.218820938267547	0.218820938267547	false	false	false	true	false
dfef26d7-64f0-4266-8b85-4a2b5e13d54d	2026-09-22 11:39	2026-09-22 11:39	2026-09-22 11:39	MCD	MCD270617P00220000	put	220.0000	2027-06-17	7.2400	7.2000	7.7500	250.4000	181000.00	0.00	181000.00	250	2	261	271	0.96309963099631	0.264340070939285	0.264340070939285	false	true	false	true	false
8b16a215-c05d-4b08-aa33-4cdbd7f65ec2	2026-09-22 11:33	2026-09-22 11:33	2026-09-22 11:33	MCD	MCD290119P00250000	put	250.0000	2029-01-19	30.7000	29.3500	33.0000	250.0000	42980.00	0.00	42980.00	14	9	15	120	0.125	0.299058169219547	0.299058169219547	false	false	false	true	false
098929c5-4419-4946-9486-3c80693cf238	2026-09-22 11:28	2026-09-22 11:28	2026-09-22 11:28	MCD	MCD270115C00250000	call	250.0000	2027-01-15	14.9000	14.9000	15.3000	251.0000	211580.00	0.00	211580.00	142	20	196	962	0.203742203742204	0.224024071238564	0.224024071238564	false	false	false	true
11449e2b-8c43-4a04-8f66-c169b68e119e	2026-09-22 11:08	2026-09-22 11:08	2026-09-22 11:08	MCD	MCD261120C00255000	call	255.0000	2026-11-20	8.6500	8.5000	9.0500	251.0000	12110.00	0.00	12110.00	14	5	81	798	0.101503759398496	0.241455767500278	0.241455767500278	true	false	false	true	false
5878bc0c-e4ac-4368-af95-2c9931015026	2026-09-22 11:08	2026-09-22 11:08	2026-09-22 11:08	MCD	MCD261218C00265000	call	265.0000	2026-12-18	6.5000	6.4500	6.7500	251.0000	543400.00	24050.00	519350.00	836	20	1544	973	1.58684480986639	0.225474396732276	0.225474396732276	false	false	false	true
d0bcfe0b-c869-4c04-b298-04a4ea33c29a	2026-09-22 11:07	2026-09-22 11:07	2026-09-22 11:07	MCD	MCD261218C00265000	call	265.0000	2026-12-18	6.6000	6.5500	6.6000	251.0000	462000.00	462000.00	0.00	700	14	708	973	0.727646454265159	0.227723049333896	0.227723049333896	false	false	false	true
1c495d5f-8e0a-42bb-b746-46a0894e6afe	2026-09-22 11:03	2026-09-22 11:03	2026-09-22 11:03	MCD	MCD270319P00225000	put	225.0000	2027-03-19	6.1000	5.8000	6.1000	251.0400	14640.00	14640.00	0.00	24	5	60	755	0.0794701986754967	0.263840670983496	0.263840670983496	false	false	false	true	false
d07402f8-c7ee-472d-b175-0c17f92f7336	2026-09-22 10:54	2026-09-22 10:54	2026-09-22 10:54	MCD	MCD260925P00252500	put	252.5000	2026-09-25	3.7500	3.7500	4.2000	250.9700	26250.00	0.00	26250.00	70	11	421	393	1.07124681933842	0.326280274632509	0.326280274632509	false	false	false	true	false
35c9037b-6068-49b4-a7f1-08ce44896f56	2026-09-22 10:51	2026-09-22 10:51	2026-09-22 10:51	MCD	MCD270319P00250000	put	250.0000	2027-03-19	15.1500	14.7000	15.4000	251.2350	16660.00	9090.00	7570.00	11	7	20	961	0.0208116545265349	0.263254231187711	0.263254231187711	false	false	false	true
3cb76156-194b-4510-b22b-5e7aaa02d9ee	2026-09-22 10:51	2026-09-22 10:50	2026-09-22 10:50	MCD	MCD270319P00225000	put	225.0000	2027-03-19	6.0000	5.7500	6.0000	251.2000	16800.00	16800.00	0.00	28	6	34	755	0.0450331125827815	0.262534045564863	0.262534045564863	false	false	false	true	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	false	true	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	false	true
cf2e340c-733f-4595-b33b-1f46fdcc5ea8	2026-09-22 10:38	2026-09-22 10:38	2026-09-22 10:38	MCD	MCD270115C00300000	call	300.0000	2027-01-15	1.9600	1.9600	2.0000	251.8350	20982.00	1970.00	19012.00	107	16	269	11740	0.0229131175468484	0.236511879528594	0.236511879528594	false	false	false	true
cf84783f-38b4-485c-848e-cf8925dbda6f	2026-09-22 10:24	2026-09-22 10:24	2026-09-22 10:24	MCD	MCD261120C00250000	call	250.0000	2026-11-20	11.1500	10.8500	11.2500	251.0000	18955.00	5575.00	13380.00	17	13	129	2096	0.0615458015267176	0.242218279007423	0.242218279007423	false	false	false	true
92b8be5b-01b8-4b51-8033-7bcd873f359a	2026-09-22 10:10	2026-09-22 10:10	2026-09-22 10:10	MCD	MCD270319C00250000	call	250.0000	2027-03-19	18.9500	18.6000	19.3000	250.8000	75800.00	56850.00	18950.00	40	10	113	326	0.346625766871166	0.229038789820102	0.229038789820102	false	false	false	true
b360f924-4870-4fbb-9d55-071acff1f904	2026-09-22 10:10	2026-09-22 10:10	2026-09-22 10:10	MCD	MCD261023C00270000	call	270.0000	2026-10-23	1.2400	0.9400	1.3900	251.0400	12200.00	6151.00	6049.00	98	6	116	109	1.06422018348624	0.224932069486354	0.223770187862189	false	false	false	true
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	false	true
9e3dc106-509e-4a81-bbdf-689ae9a91f0e	2026-09-22 09:51	2026-09-22 09:51	2026-09-22 09:51	MCD	MCD260925C00247500	call	247.5000	2026-09-25	5.1700	5.0500	5.7000	251.0100	144243.00	0.00	144243.00	279	5	401	1525	0.262950819672131	0.337704508821555	0.337704508821555	false	false	false	true
86c1c3d3-d4cd-4309-b338-ee5864f6adaa	2026-09-22 09:51	2026-09-22 09:51	2026-09-22 09:51	MCD	MCD260925C00247500	call	247.5000	2026-09-25	5.2200	5.0500	5.7000	251.0500	37069.00	0.00	37069.00	71	11	122	1525	0.08	0.342976339133939	0.342976339133939	false	false	false	true	false
de931fb2-4ebe-4e88-a8ee-1e238ae17e07	2026-09-22 09:48	2026-09-22 09:48	2026-09-22 09:48	MCD	MCD270319C00260000	call	260.0000	2027-03-19	14.2500	14.1000	14.5500	251.0900	95475.00	81225.00	14250.00	67	10	239	757	0.315719947159841	0.226340125428938	0.226836913028853	true	false	false	true
ffab00d9-0812-4555-b2fa-43d6ae5b1d7e	2026-09-22 09:48	2026-09-22 09:48	2026-09-22 09:48	MCD	MCD270319C00285000	call	285.0000	2027-03-19	6.5000	5.8500	6.8500	251.1450	162500.00	1300.00	161200.00	250	32	250	320	0.78125	0.229799528348882	0.229799528348882	true	false	false	true	false
c547af16-2097-42f3-8f96-ad6643ebfa7e	2026-09-22 09:48	2026-09-22 09:48	2026-09-22 09:48	MCD	MCD270319C00260000	call	260.0000	2027-03-19	14.2500	14.0500	14.6000	251.0550	71250.00	62700.00	8550.00	50	10	60	757	0.0792602377807133	0.227085152553699	0.227085152553699	true	false	false	true
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	false	true
9fcf7812-1ac4-4915-86fb-27fa58d6cc1c	2026-09-22 09:41	2026-09-22 09:41	2026-09-22 09:41	MCD	MCD260925C00255000	call	255.0000	2026-09-25	1.5500	1.2000	1.5500	250.7000	31465.00	31465.00	0.00	203	32	327	1272	0.257075471698113	0.353280054673911	0.353280054673911	false	false	false	true
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	false	true
be738220-8d20-4a69-8d34-226cbc1fc51b	2026-09-21 15:55	2026-09-21 15:55	2026-09-21 15:55	MCD	MCD261016C00232500	call	232.5000	2026-10-16	17.3500	17.3500	18.3000	248.0000	60725.00	0.00	60725.00	35	14	35	0	0	0.235177307577909	0.241459258235496	true	false	false	true	false
c6a3175f-a4dc-4a97-b482-51df47b5c867	2026-09-21 15:51	2026-09-21 15:51	2026-09-21 15:51	MCD	MCD270115C00300000	call	300.0000	2027-01-15	1.6700	1.5500	1.7900	248.4100	18370.00	15698.00	0.00	110	5	791	11135	0.07103726986978	0.239426156594296	0.239426156594296	false	false	false	true
ed30e710-14bb-4991-a4ee-5deeaeb24929	2026-09-21 15:33	2026-09-21 15:33	2026-09-21 15:33	MCD	MCD261218P00235000	put	235.0000	2026-12-18	5.5500	5.4000	5.5500	248.0000	25528.00	25528.00	0.00	46	21	78	1055	0.0739336492890995	0.251960415312357	0.251960415312357	false	false	false	true	false
b3bb8964-f1c4-40d1-bbea-37f1f7ecacaa	2026-09-21 15:16	2026-09-21 15:16	2026-09-21 15:16	MCD	MCD270115C00280000	call	280.0000	2027-01-15	4.0500	3.9000	4.2500	248.6300	34020.00	20655.00	13365.00	84	18	227	2814	0.0806680881307747	0.231400567652768	0.231400567652768	true	false	false	true
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	false	true