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.

523,327 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts523,327 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

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

33e677ac-59fe-4fc1-84a8-0ad36213beee	2026-09-28 15:53	2026-09-28 15:53	2026-09-28 15:53	MCD	MCD261016C00235000	call	235.0000	2026-10-16	4.1500	4.1500	4.2500	233.6900	12450.00	0.00	2490.00	30	10	204	544	0.375	0.219820415633337	0.219820415633337	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Consumer Cyclical	165305061642.00	2026-11-04	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-28T19:53:15.788869Z"}	2026-09-28	2026-09-28 21:15	2026-09-28 21:15
7efaba80-7f16-416a-97a7-1cd0872eab35	2026-09-28 14:47	2026-09-28 14:47	2026-09-28 14:47	MCD	MCD270115C00300000	call	300.0000	2027-01-15	0.7000	0.7000	0.7500	234.3600	10990.00	0.00	10990.00	157	16	804	15686	0.0512558969781971	0.254673422963867	0.254673422963867	false	false	false
b3784c85-3ee0-43b1-83f0-0325e2fc3015	2026-09-28 13:44	2026-09-28 13:43	2026-09-28 13:43	MCD	MCD261120C00245000	call	245.0000	2026-11-20	4.9400	4.8500	5.0000	234.7800	143260.00	114840.00	28420.00	290	2	331	481	0.688149688149688	0.237242930268984	0.237242930268984	false	true	false
aa7f3672-79b8-497a-8f48-040eff506e37	2026-09-28 13:39	2026-09-28 13:39	2026-09-28 13:39	MCD	MCD261120C00240000	call	240.0000	2026-11-20	6.7500	6.5000	6.7500	234.0000	202500.00	202500.00	0.00	300	6	434	1201	0.361365528726062	0.239075067890108	0.239075067890108	false	false	false
3088e5b1-a31e-4966-b463-8177785130d3	2026-09-28 12:37	2026-09-28 12:37	2026-09-28 12:37	MCD	MCD270115C00250000	call	250.0000	2027-01-15	6.6000	6.4000	6.6000	234.2001	199980.00	199980.00	0.00	303	36	464	1476	0.314363143631436	0.226165734493833	0.226165734493833	false	false	false
77ef2fff-6e2e-4bbd-8a47-f0a53477095e	2026-09-28 11:54	2026-09-28 11:54	2026-09-28 11:54	MCD	MCD261120C00240000	call	240.0000	2026-11-20	6.4000	6.4000	6.5500	234.2800	14726.00	0.00	14726.00	23	8	74	1201	0.0616153205661948	0.232645896695727	0.232645896695727	false	false	false
e07b440d-2b48-4c0f-8e4b-e2940b12ffc6	2026-09-28 11:52	2026-09-28 11:52	2026-09-28 11:52	MCD	MCD261120P00235000	put	235.0000	2026-11-20	7.6500	7.6500	7.8000	234.5100	29835.00	0.00	29835.00	39	6	401	2381	0.168416631667367	0.228037424056908	0.228037424056908	false	false	false
b640db46-d65a-4490-90f5-bbf9f93378a5	2026-09-28 11:49	2026-09-28 11:49	2026-09-28 11:49	MCD	MCD261016C00240000	call	240.0000	2026-10-16	2.4700	2.4700	2.5000	234.5700	11115.00	0.00	11115.00	45	6	463	964	0.480290456431535	0.215318309977792	0.215318309977792	false	false	false
68471feb-2927-4351-baf6-1fa89b110805	2026-09-28 11:49	2026-09-28 11:49	2026-09-28 11:49	MCD	MCD261016C00240000	call	240.0000	2026-10-16	2.4600	2.4600	2.5000	234.5700	16236.00	0.00	16236.00	66	8	418	964	0.433609958506224	0.214794139409437	0.214794139409437	false	false	false
6338ba9c-9ed3-45e5-a6c5-20a239ad8404	2026-09-28 11:49	2026-09-28 11:49	2026-09-28 11:49	MCD	MCD261016C00240000	call	240.0000	2026-10-16	2.4500	2.4250	2.4800	234.5441	16170.00	0.00	16170.00	66	12	352	964	0.365145228215768	0.214730051386116	0.214730051386116	false	false	false
51fe76f3-dca3-48ff-bd05-9c71a1b6bf86	2026-09-28 11:15	2026-09-28 11:14	2026-09-28 11:14	MCD	MCD280121C00280000	call	280.0000	2028-01-21	14.0000	14.0000	14.1500	234.0000	61600.00	0.00	61600.00	44	9	51	1109	0.0459873760144274	0.225535427491158	0.225535427491158	false	false	false
73f2f67e-bf42-4008-b6b8-f45ea83d9af0	2026-09-28 11:05	2026-09-28 11:04	2026-09-28 11:04	MCD	MCD261218P00235000	put	235.0000	2026-12-18	9.7000	9.5500	9.7000	235.1100	22310.00	22310.00	0.00	23	5	58	1197	0.0484544695071011	0.246139660951848	0.246139660951848	true	false	false
790ced8e-43d3-4456-b5cd-cad97dd59152	2026-09-28 10:49	2026-09-28 10:49	2026-09-28 10:49	MCD	MCD261030C00250000	call	250.0000	2026-10-30	1.5600	1.5600	1.8000	235.0000	17160.00	0.00	17160.00	110	15	522	997	0.523570712136409	0.209399888184765	0.209399888184765	false	false	false
5189287c-0e9d-457e-949b-0b3b76af63fe	2026-09-28 10:28	2026-09-28 10:28	2026-09-28 10:28	MCD	MCD261009P00242500	put	242.5000	2026-10-09	7.5000	7.4500	8.0500	235.0000	21750.00	1500.00	20250.00	29	6	68	87	0.781609195402299	0.215487389969823	0.215487389969823	true	false	false
ca470f40-9aee-4e01-a972-dbb2d8c45f1c	2026-09-28 10:18	2026-09-28 10:18	2026-09-28 10:18	MCD	MCD261030C00250000	call	250.0000	2026-10-30	1.7000	1.7000	1.9900	236.1550	24480.00	0.00	9180.00	144	7	368	997	0.369107321965898	0.213155434481486	0.213155434481486	false	false	false
80056e6c-ff33-4348-8bfa-22bbe27ed976	2026-09-28 10:18	2026-09-28 10:18	2026-09-28 10:18	MCD	MCD280121C00250000	call	250.0000	2028-01-21	24.4000	24.1500	24.9000	236.0450	107360.00	24400.00	82960.00	44	5	58	1240	0.0467741935483871	0.220780010879431	0.220780010879431	false	false	false
2d249d88-5077-45ed-80d9-ec78dc985c3c	2026-09-25 15:34	2026-09-25 15:34	2026-09-25 15:34	MCD	MCD261120C00225000	call	225.0000	2026-11-20	16.9000	16.4000	16.9000	237.0400	33800.00	33800.00	0.00	20	8	47	19	2.47368421052632	0.236839871886591	0.236839871886591	true	false	false
58f4e262-16ed-47be-b5ce-676362e971eb	2026-09-25 14:04	2026-09-25 14:04	2026-09-25 14:04	MCD	MCD261218P00240000	put	240.0000	2026-12-18	11.2000	11.1000	11.3000	237.0000	11200.00	2240.00	8960.00	10	5	100	1550	0.0645161290322581	0.244695211624823	0.244695211624823	false	false	false
8041bd3e-5f1c-4f70-a1e0-abd62c485dbd	2026-09-25 14:03	2026-09-25 14:03	2026-09-25 14:03	MCD	MCD270319C00230000	call	230.0000	2027-03-19	20.8000	20.3500	21.0500	237.0000	95680.00	95680.00	0.00	46	6	71	352	0.201704545454545	0.217225212092974	0.217225212092974	false	false	false
de5b26f3-2bc3-4d7c-8e1c-ddfc666f2eef	2026-09-25 13:02	2026-09-25 13:02	2026-09-25 13:02	MCD	MCD271217P00200000	put	200.0000	2027-12-17	9.0000	8.9500	9.0000	236.7800	32400.00	32400.00	0.00	36	8	88	309	0.284789644012945	0.283832874520999	0.283832874520999	false	false	false
db68b3cc-b0d0-4db6-bb0d-7221aabe75cb	2026-09-25 12:53	2026-09-25 12:53	2026-09-25 12:53	MCD	MCD261218P00240000	put	240.0000	2026-12-18	11.7000	11.6750	11.7500	236.6950	11700.00	1170.00	7020.00	10	7	88	1550	0.0567741935483871	0.24701297456157	0.24701297456157	false	false	false
9a13e5d9-c3c9-4b8b-b338-f710f165d737	2026-09-25 12:32	2026-09-25 12:32	2026-09-25 12:32	MCD	MCD260925C00237500	call	237.5000	2026-09-25	0.4400	0.3400	0.4400	237.2754	15708.00	15708.00	0.00	357	36	7671	1089	7.04407713498623	0.288762313857759	0.288762313857759	false	false	false
f6be0a4e-c892-47db-9345-bc3b00b67f3c	2026-09-25 12:07	2026-09-25 12:07	2026-09-25 12:07	MCD	MCD260925C00237500	call	237.5000	2026-09-25	0.4600	0.4200	0.4600	237.2550	11500.00	11500.00	0.00	250	5	6832	1089	6.27364554637282	0.287199273443878	0.287199273443878	false	false	false
64413d8d-e590-4def-ad30-b283debabd00	2026-09-25 12:05	2026-09-25 12:05	2026-09-25 12:05	MCD	MCD261002P00237500	put	237.5000	2026-10-02	2.8000	2.7500	2.8000	236.9650	28000.00	28000.00	0.00	100	8	707	747	0.946452476572959	0.199985445700013	0.199985445700013	true	false	false
a8b20aa2-51d3-47cb-8afa-9cc5f6cf8422	2026-09-25 10:56	2026-09-25 10:56	2026-09-25 10:56	MCD	MCD261218P00220000	put	220.0000	2026-12-18	3.8000	3.7500	3.8500	236.0300	23180.00	22420.00	0.00	61	22	85	1393	0.0610193826274228	0.24133232566546	0.24133232566546	true	false	false
c6fa4218-d555-42c5-96e0-8c017896265e	2026-09-25 09:45	2026-09-25 09:45	2026-09-25 09:45	MCD	MCD261120P00260000	put	260.0000	2026-11-20	23.8000	23.4500	23.8000	236.8900	47600.00	47600.00	0.00	20	19	90	1063	0.0846660395108184	0.244350070918091	0.244350070918091	true	false	false
b5d3a6ad-a65d-40a6-83af-061a17a2d571	2026-09-25 09:33	2026-09-25 09:33	2026-09-25 09:33	MCD	MCD261009C00237500	call	237.5000	2026-10-09	3.3900	2.7500	3.4000	235.7200	13560.00	13560.00	0.00	40	5	50	251	0.199203187250996	0.219711566069503	0.219711566069503	false	false	false
8699df76-3e94-414c-8e98-b45ffabbe0b4	2026-09-25 09:32	2026-09-25 09:32	2026-09-25 09:32	MCD	MCD270617C00300000	call	300.0000	2027-06-17	4.2500	4.0000	4.5500	235.8000	28900.00	6800.00	5525.00	68	5	71	6616	0.0107315598548972	0.239090441217703	0.239090441217703	false	false	false
8923612c-0210-4809-ad90-d59c28e003a9	2026-09-24 14:35	2026-09-24 14:35	2026-09-24 14:35	MCD	MCD261120C00240000	call	240.0000	2026-11-20	8.8000	8.6000	8.8000	238.6000	13200.00	13200.00	0.00	15	6	1069	1018	1.05009823182711	0.233303107588235	0.233303107588235	false	false	false
e490f44e-d931-4b52-953a-31da4f1808a3	2026-09-24 14:34	2026-09-24 14:34	2026-09-24 14:34	MCD	MCD270617P00250000	put	250.0000	2027-06-17	24.1500	23.9000	24.3500	238.6300	60375.00	57960.00	2415.00	25	9	180	1761	0.10221465076661	0.274963848638084	0.274963848638084	false	false	false
9df31757-c92a-42e5-b9b9-a8e923157986	2026-09-24 14:26	2026-09-24 14:26	2026-09-24 14:26	MCD	MCD270617P00250000	put	250.0000	2027-06-17	23.9000	23.8500	24.2500	239.0100	35850.00	0.00	33460.00	15	7	82	1761	0.0465644520159001	0.274109808939582	0.274109808939582	false	false	false
6875eedc-c995-4f7e-bed5-0bbf8962eaf9	2026-09-24 14:16	2026-09-24 14:16	2026-09-24 14:16	MCD	MCD261120C00275000	call	275.0000	2026-11-20	0.9600	0.9600	1.0800	239.2883	24000.00	0.00	24000.00	250	24	1482	3983	0.372081345719307	0.244529944540679	0.244529944540679	false	false	false
9697d688-94ad-4c5e-909c-192e3e553e00	2026-09-24 14:08	2026-09-24 14:08	2026-09-24 14:08	MCD	MCD261120C00255000	call	255.0000	2026-11-20	3.7500	3.7500	3.9000	239.2900	18750.00	0.00	18750.00	50	11	213	918	0.23202614379085	0.234788026297563	0.234788026297563	false	false	false
1ee38a33-157a-47bb-b65a-e6ef0c12fdd4	2026-09-24 14:02	2026-09-24 14:02	2026-09-24 14:02	MCD	MCD261120C00240000	call	240.0000	2026-11-20	9.1500	8.9500	9.1500	239.0000	20130.00	20130.00	0.00	22	10	1016	1018	0.99803536345776	0.232963582687903	0.232963582687903	true	false	false
9d9fa813-060d-49d6-b0b9-47f967c3bca8	2026-09-24 14:01	2026-09-24 14:00	2026-09-24 14:00	MCD	MCD270319P00250000	put	250.0000	2027-03-19	20.5000	20.0000	20.7500	239.4800	24605.00	4100.00	20505.00	12	5	33	1080	0.0305555555555556	0.263932743801303	0.263932743801303	true	false	false
53c242aa-14d5-4bb9-bb10-a092340e7f29	2026-09-24 14:00	2026-09-24 14:00	2026-09-24 14:00	MCD	MCD270115C00250000	call	250.0000	2027-01-15	8.6000	8.6000	8.8500	239.5800	15485.00	2595.00	12890.00	18	6	416	1344	0.30952380952381	0.219120922112291	0.220076193360321	false	false	false
6d7c4e76-2b66-4242-ad3d-ac9da352bcb6	2026-09-24 13:21	2026-09-24 13:21	2026-09-24 13:21	MCD	MCD261009P00235000	put	235.0000	2026-10-09	1.8900	1.8900	2.1600	239.4700	18900.00	0.00	18900.00	100	11	169	234	0.722222222222222	0.200276348218693	0.200276348218693	false	false	false
e64e4707-791b-4198-9992-a8b65bb6a64c	2026-09-24 13:15	2026-09-24 13:15	2026-09-24 13:15	MCD	MCD261023C00250000	call	250.0000	2026-10-23	2.4000	2.4000	2.5000	239.9100	104401.00	0.00	104401.00	435	5	1515	1172	1.29266211604096	0.215486664601022	0.215486664601022	false	false	false
4318d8f2-dfcb-4d54-afff-739b97579c31	2026-09-24 12:43	2026-09-24 12:43	2026-09-24 12:43	MCD	MCD261218C00300000	call	300.0000	2026-12-18	0.5000	0.5000	0.6100	240.9200	14650.00	0.00	14650.00	293	30	421	3548	0.118658399098083	0.246275782409063	0.246560857663844	false	false	false
713af513-ca5f-4e52-b0af-8f77e2bd1d33	2026-09-24 12:18	2026-09-24 12:18	2026-09-24 12:18	MCD	MCD261023C00260000	call	260.0000	2026-10-23	1.0000	0.8900	1.0100	241.0000	34800.00	34800.00	0.00	348	8	422	176	2.39772727272727	0.21694292246304	0.21694292246304	false	false	false
f04a673f-a4be-4b9a-a99f-c0483658ee48	2026-09-24 11:21	2026-09-24 11:21	2026-09-24 11:21	MCD	MCD260925C00240000	call	240.0000	2026-09-25	1.9000	1.6700	1.9000	240.5900	242819.00	242630.00	189.00	1278	51	2437	1577	1.54533925174382	0.313450041906808	0.313450041906808	false	false	false
9a573d4a-65aa-4cdb-ad7c-acc33fc5e780	2026-09-24 11:21	2026-09-24 11:21	2026-09-24 11:21	MCD	MCD261120P00260000	put	260.0000	2026-11-20	20.6500	20.2000	20.8500	240.6500	37170.00	8260.00	4130.00	18	18	89	1074	0.0828677839851024	0.234864611261734	0.234864611261734	false	false	false
6f31570d-fa14-4122-8e55-8fd5a1bd2c72	2026-09-24 11:15	2026-09-24 11:15	2026-09-24 11:15	MCD	MCD261120C00240000	call	240.0000	2026-11-20	10.2000	9.9500	10.2000	240.9400	11220.00	11220.00	0.00	11	5	317	1018	0.31139489194499	0.235854027125545	0.235854027125545	false	false	false
f86e5c1d-92ca-40ca-b3f6-62d51ae89e64	2026-09-24 11:00	2026-09-24 11:00	2026-09-24 11:00	MCD	MCD261218C00255000	call	255.0000	2026-12-18	5.7500	5.7500	6.0000	241.1300	21275.00	0.00	21275.00	37	7	74	1015	0.0729064039408867	0.220603339355591	0.220603339355591	false	false	false
c96f6373-cd86-4cc4-8041-8fa5faae2c5d	2026-09-24 10:31	2026-09-24 10:31	2026-09-24 10:31	MCD	MCD260925C00237500	call	237.5000	2026-09-25	3.5000	3.2500	4.0500	240.4699	10500.00	4200.00	6300.00	30	6	661	1586	0.416771752837327	0.314069753171697	0.314069753171697	false	false	false
06aafaf2-7fb5-4c36-9287-e649bf364090	2026-09-24 10:22	2026-09-24 10:22	2026-09-24 10:22	MCD	MCD261016P00242500	put	242.5000	2026-10-16	5.3800	4.9000	5.4000	241.3500	16140.00	16140.00	0.00	30	5	33	201	0.164179104477612	0.21599529459505	0.21599529459505	false	false	false
0e1a779b-7abc-42ea-b12e-9f1d334ab284	2026-09-24 10:22	2026-09-24 10:22	2026-09-24 10:22	MCD	MCD261016P00255000	put	255.0000	2026-10-16	13.9000	13.9000	14.5000	241.3700	13900.00	0.00	13900.00	10	6	42	1512	0.0277777777777778	0.199757622153518	0.199757622153518	false	false	false
02258bb0-cd4e-418c-b045-0cfdc95f445e	2026-09-24 10:15	2026-09-24 10:15	2026-09-24 10:15	MCD	MCD261030C00250000	call	250.0000	2026-10-30	3.5000	3.4500	3.6000	241.1200	35000.00	0.00	35000.00	100	5	164	288	0.569444444444444	0.218750285127727	0.218750285127727	false	false	false
5dbc2bd3-cf17-403b-850e-d2343aba00f1	2026-09-24 10:13	2026-09-24 10:13	2026-09-24 10:13	MCD	MCD261016C00252500	call	252.5000	2026-10-16	1.5500	1.4100	1.6500	240.9800	11625.00	11625.00	0.00	75	8	105	823	0.127582017010936	0.222110251920542	0.220375393227108	false	false	false
0a041a68-4103-43ce-82ac-7130211f6d5a	2026-09-24 10:10	2026-09-24 10:10	2026-09-24 10:10	MCD	MCD261016P00250000	put	250.0000	2026-10-16	10.5000	10.3000	10.5000	240.9400	10500.00	10500.00	0.00	10	10	36	4233	0.00850460666194188	0.217214543505291	0.217214543505291	false	false	false