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 = RepeatedHitsAscendingFill×ticker = MCD×sorted by created_at ↑×

iduuid	created_at ↑timestamp with time zone	start_timetimestamp with time zone	end_timetimestamp with time zone	tickertext	option_symboltext	option_typetext	strikenumeric	expiry

76f16b2e-cb78-4d76-834c-e9790b71a9af	2026-08-18 10:59	2026-08-18 10:59	2026-08-18 10:59	MCD	MCD280121P00200000	put	200.0000	2028-01-21	5.5500	5.5000	5.8000	269.3800	53255.00	16950.00	36305.00	96	22	161	469	0.343283582089552	0.280968772504572	0.28089649652132	false	false	false	true	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	Common Stock	Consumer Cyclical	182210617817.00	2026-11-04	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-18T15:04:03.259366Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
f158ccf3-236c-4b90-9af5-0f2b527ffc87	2026-08-19 09:33	2026-08-19 09:33	2026-08-19 09:33	MCD	MCD260918P00265000	put	265.0000	2026-09-18	5.5000	4.9000	6.0000	266.9300	55048.00	6600.00	4448.00	100	5	102	1506	0.0677290836653386	0.223019734296198	0.225516745934472	false	false	false	true
dbfaa65e-e2b0-432d-9809-4a8e527e0315	2026-08-26 12:15	2026-08-26 12:15	2026-08-26 12:15	MCD	MCD270115C00280000	call	280.0000	2027-01-15	9.7800	9.6500	9.8500	266.9000	97752.00	97752.00	0.00	100	7	139	1528	0.0909685863874346	0.203457996526	0.203457996526	false	false	false	true
87160bdd-9c7b-462c-b07d-4403cfc4883a	2026-08-27 09:44	2026-08-27 09:44	2026-08-27 09:44	MCD	MCD270617P00240000	put	240.0000	2027-06-17	10.6000	9.7000	11.0000	263.5500	188640.00	83050.00	4230.00	178	92	178	477	0.373165618448637	0.253472124749647	0.256086827933808	true	false	false	true
3854784e-3749-4019-847e-454b29ee2538	2026-08-27 09:44	2026-08-27 09:44	2026-08-27 09:44	MCD	MCD270917P00240000	put	240.0000	2027-09-17	12.9400	12.8500	13.4500	263.4500	143670.00	1300.00	141070.00	111	63	206	8	25.75	0.256388254005834	0.258079239209302	true	false	false	true
0ddb8a0b-d518-4a03-8e22-868db3498730	2026-08-27 09:46	2026-08-27 09:46	2026-08-27 09:46	MCD	MCD270319P00245000	put	245.0000	2027-03-19	8.9900	8.2500	9.5500	263.8600	175250.00	58750.00	2680.00	195	71	195	138	1.41304347826087	0.244639536225864	0.246925433989726	false	false	false	true
4a4246e5-45bf-4473-9601-3fb0623c31b2	2026-08-27 09:46	2026-08-27 09:46	2026-08-27 09:46	MCD	MCD270319P00245000	put	245.0000	2027-03-19	8.9200	8.9000	9.2500	263.9600	82975.00	1790.00	48070.00	93	25	300	138	2.17391304347826	0.245055281127578	0.245818179684584	false	false	false	true
185e61f0-194d-4755-ae57-2c17fbe51aa2	2026-08-27 09:47	2026-08-27 09:47	2026-08-27 09:47	MCD	MCD271217P00240000	put	240.0000	2027-12-17	14.9800	14.5500	15.7000	264.2400	187255.00	42065.00	1495.00	125	80	125	586	0.213310580204778	0.261130591169405	0.263151858812361	false	false	false	true
2b8d4fce-772b-404d-9d15-80f024f983f8	2026-08-28 11:56	2026-08-28 11:56	2026-08-28 11:56	MCD	MCD270319C00315000	call	315.0000	2027-03-19	3.9000	3.6500	3.9000	263.0000	207845.00	24940.00	385.00	533	22	533	28	19.0357142857143	0.21048273348521	0.21048273348521	false	false	false	true
b3401f17-c8a8-4e03-b630-342f44d7a82e	2026-08-31 15:41	2026-08-31 15:41	2026-08-31 15:41	MCD	MCD271217C00270000	call	270.0000	2027-12-17	28.9100	28.3500	29.7000	265.5000	72280.00	2895.00	69385.00	25	7	44	203	0.216748768472906	0.209269939628198	0.209697187956529	false	false	false	true
d7bbf05b-3bd9-4427-97ab-639ae61d0f73	2026-09-08 10:08	2026-09-08 10:08	2026-09-08 10:08	MCD	MCD270319C00300000	call	300.0000	2027-03-19	5.0000	4.7500	5.1000	256.1200	99988.00	99988.00	0.00	200	5	424	2287	0.185395714910363	0.224164921634635	0.224164921634635	false	false	false	true
9b9d0bcb-883e-4e15-af1d-5ce4c5651db1	2026-09-08 12:50	2026-09-08 12:50	2026-09-08 12:50	MCD	MCD271217P00250000	put	250.0000	2027-12-17	21.0200	21.0000	21.6000	256.0000	874582.00	34160.00	840422.00	416	47	817	255	3.20392156862745	0.269402754613246	0.271042612940063	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
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
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
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
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
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
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
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
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
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
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
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
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