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:alert_rule = RepeatedHits×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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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