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 = MGM×

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

6886d8d5-efdf-4589-b57f-cc656952c2be	2026-09-22 14:00	2026-09-22 14:00	2026-09-22 14:00	MGM	MGM261016C00040000	call	40.0000	2026-10-16	2.0000	1.7000	2.0000	38.6200	34800.00	34800.00	0.00	174	9	6375	18578	0.343147809236732	0.645231476994215	0.645231476994215	true	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Consumer Cyclical	9786958208.00	2026-11-04	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-22T18:03:20.556132Z"}	2026-09-22	2026-09-22 21:15	2026-09-22 21:15
078fddd8-a03f-4d53-b5fe-741ed74d1590	2026-09-22 10:41	2026-09-22 10:41	2026-09-22 10:41	MGM	MGM261016C00040000	call	40.0000	2026-10-16	1.7000	1.5000	1.7000	38.9300	26180.00	26180.00	0.00	154	16	4927	18578	0.265206157821079	0.533324174051315	0.533324174051315	false	false	false	true
e9cea737-e6f7-4751-a7dd-d6083f7dd376	2026-09-22 10:10	2026-09-22 10:09	2026-09-22 10:09	MGM	MGM261016C00040000	call	40.0000	2026-10-16	1.9000	1.9000	1.9500	39.3100	11020.00	0.00	1520.00	58	9	4517	18578	0.243137043815265	0.541060255862941	0.538649406072677	false	false	false	true
7785c26c-6f7b-4bb5-89d8-6460b1ac8d04	2026-09-22 09:57	2026-09-22 09:57	2026-09-22 09:57	MGM	MGM261016C00041000	call	41.0000	2026-10-16	1.3600	1.3500	1.6000	39.3700	26695.00	1820.00	24875.00	197	10	200	1040	0.192307692307692	0.505417852611025	0.543535037682958	false	false	false	true
b9d4ee7d-361c-4d0b-9471-4925fef0aebc	2026-09-21 13:25	2026-09-21 13:25	2026-09-21 13:25	MGM	MGM261120C00040000	call	40.0000	2026-11-20	2.2000	2.0000	2.2000	38.6500	11000.00	11000.00	0.00	50	13	211	286	0.737762237762238	0.427497094322085	0.427497094322085	false	false	false	true
7a164e48-bac7-4e75-abf1-5d25ab7461b0	2026-09-21 11:03	2026-09-21 11:03	2026-09-21 11:03	MGM	MGM261016C00040000	call	40.0000	2026-10-16	1.2100	1.0500	1.3500	38.0300	1128325.00	233125.00	0.00	9325	2	11487	9256	1.24103284356093	0.490619020415299	0.490619020415299	false	true	false	true
8fcae330-1c0f-4439-9f53-f0109c061bf0	2026-09-18 15:30	2026-09-18 15:30	2026-09-18 15:30	MGM	MGM261016C00042000	call	42.0000	2026-10-16	0.5900	0.5000	0.6500	37.6700	147500.00	120000.00	27500.00	2500	2	2505	1062	2.35875706214689	0.467709416736539	0.451586612903616	false	true	false	true
2be3591d-b5d4-48e6-a88a-014a5abb02ad	2026-09-18 12:15	2026-09-18 12:15	2026-09-18 12:15	MGM	MGM270319C00040000	call	40.0000	2027-03-19	3.1000	2.9500	3.5000	37.0000	11470.00	8370.00	3100.00	37	13	76	45	1.68888888888889	0.360558857713971	0.360558857713971	false	false	false	true
7fa0fccb-e14e-4b28-a400-ea63700c51fb	2026-09-18 11:53	2026-09-18 11:53	2026-09-18 11:53	MGM	MGM270319C00040000	call	40.0000	2027-03-19	3.1000	2.8500	3.6000	37.6300	11470.00	7750.00	3720.00	37	12	39	45	0.866666666666667	0.359193722759153	0.358966098293881	false	false	false	true
45708e96-c25a-4bc2-a79a-2ca67b53b0bb	2026-09-18 11:24	2026-09-18 11:24	2026-09-18 11:24	MGM	MGM261120C00041000	call	41.0000	2026-11-20	1.4000	1.3000	1.4000	37.7200	41999.00	41999.00	0.00	300	22	302	59	5.11864406779661	0.405123866449872	0.405123866449872	false	false	false	true
2d739b79-195c-4967-933c-da78d3c87fee	2026-09-17 15:49	2026-09-17 15:49	2026-09-17 15:49	MGM	MGM261016P00039000	put	39.0000	2026-10-16	2.0500	1.8500	2.2000	38.4300	71955.00	7995.00	63960.00	351	22	365	4876	0.074856439704676	0.418384630933408	0.418384630933408	true	false	false	true
3f78c0de-4711-4d4b-bd92-5793661f1989	2026-09-17 13:14	2026-09-17 13:14	2026-09-17 13:14	MGM	MGM261016C00037000	call	37.0000	2026-10-16	2.9000	2.8500	3.1000	38.7900	18560.00	2030.00	15370.00	64	12	250	3	83.3333333333333	0.420452936538158	0.420452936538158	false	false	false	true
91ad01b5-b803-45f6-bb80-52ed2651b9be	2026-09-17 13:14	2026-09-17 13:14	2026-09-17 13:14	MGM	MGM261016C00037000	call	37.0000	2026-10-16	2.9500	2.9000	2.9500	38.8300	38055.00	36580.00	0.00	129	25	151	3	50.3333333333333	0.426264712913877	0.426264712913877	false	false	false	true
c649e3d3-b998-4edd-aa08-855f23c6eab7	2026-09-17 12:19	2026-09-17 12:19	2026-09-17 12:19	MGM	MGM261016C00041000	call	41.0000	2026-10-16	1.1500	1.1500	1.2000	38.9400	15755.00	0.00	15755.00	137	6	224	566	0.395759717314488	0.4386096153407	0.4386096153407	false	false	false	true
ef647136-41ea-4956-ba87-bf34ba6c10e8	2026-09-16 15:48	2026-09-16 15:48	2026-09-16 15:48	MGM	MGM261016C00040000	call	40.0000	2026-10-16	1.4000	1.1500	1.4500	38.0000	60618.00	60338.00	280.00	433	39	4014	562	7.1423487544484	0.473251755989587	0.468462662056106	false	false	false	true
6b0495df-9a29-4b2d-983f-7809c1bdc0f5	2026-09-16 14:49	2026-09-16 14:49	2026-09-16 14:49	MGM	MGM260918P00040000	put	40.0000	2026-09-18	1.7500	1.6000	1.8000	38.3800	10500.00	4200.00	4200.00	60	5	90	1775	0.0507042253521127	0.561821760581507	0.561821760581507	false	false	false	true
df176034-2d0a-4af3-b605-46f0a2400f15	2026-09-16 13:56	2026-09-16 13:56	2026-09-16 13:56	MGM	MGM261016C00039000	call	39.0000	2026-10-16	1.8000	1.6000	1.9500	38.0000	16740.00	11700.00	5040.00	93	8	679	75	9.05333333333333	0.421324741563339	0.421324741563339	false	false	false	true
cd858520-9d24-47da-aef9-522b2bc1e48e	2026-09-16 12:02	2026-09-16 12:02	2026-09-16 12:02	MGM	MGM261120C00046000	call	46.0000	2026-11-20	0.6800	0.4500	0.8000	38.6750	67500.00	67500.00	0.00	1000	2	1000	82	12.1951219512195	0.409635666368162	0.409635666368162	false	true	false	true
17bb3e87-949e-48ad-885f-b2e2b480b7b3	2026-09-16 11:46	2026-09-16 11:46	2026-09-16 11:46	MGM	MGM261016C00039000	call	39.0000	2026-10-16	1.8000	1.6000	1.9500	38.6600	90000.00	63180.00	26820.00	500	6	559	75	7.45333333333333	0.432249667810668	0.429960171034127	false	false	false	true
8172e1c6-1640-46dc-b8d8-66e389265830	2026-09-16 11:39	2026-09-16 11:39	2026-09-16 11:39	MGM	MGM261016C00040000	call	40.0000	2026-10-16	1.3000	1.1500	1.3500	38.6100	28729.00	28729.00	0.00	221	20	2444	562	4.34875444839858	0.415379835612438	0.415379835612438	false	false	false	true
4499b906-5820-4d18-8087-b6622652f131	2026-09-16 11:37	2026-09-16 11:37	2026-09-16 11:37	MGM	MGM261016C00040000	call	40.0000	2026-10-16	1.2800	1.1500	1.3000	38.5700	283900.00	283900.00	0.00	2218	2	2218	562	3.94661921708185	0.419232958126854	0.419232958126854	false	true	false	true
9b4ce11b-e5c0-4683-aa6f-b17fafd18b3b	2026-09-16 10:07	2026-09-16 10:07	2026-09-16 10:07	MGM	MGM260918C00036000	call	36.0000	2026-09-18	2.9500	2.8000	2.9500	38.7700	11210.00	4130.00	0.00	38	6	38	345	0.110144927536232	0.911477905205663	0.911477905205663	false	false	false	true
617e7d31-8e8d-4bf3-848e-07b76c1bed18	2026-09-14 10:15	2026-09-14 10:15	2026-09-14 10:15	MGM	MGM260918P00042000	put	42.0000	2026-09-18	2.4500	2.4500	2.6500	39.0000	14945.00	0.00	14945.00	61	12	298	2546	0.117046347211312	0.502885641734117	0.502885641734117	false	false	false	true
4cdfde15-c428-4abe-9178-3f1bfa0c662e	2026-09-14 10:00	2026-09-14 10:00	2026-09-14 10:00	MGM	MGM260918P00042000	put	42.0000	2026-09-18	2.5500	2.4500	2.7000	39.5680	12240.00	2040.00	10200.00	48	5	159	2546	0.0624509033778476	0.49773511084872	0.49773511084872	false	false	false	true
4f59e88d-c86f-452d-a065-1c472d32e743	2026-09-14 10:00	2026-09-14 10:00	2026-09-14 10:00	MGM	MGM260918P00042000	put	42.0000	2026-09-18	2.5500	2.4500	2.7000	39.5404	21165.00	0.00	21165.00	83	13	111	2546	0.0435978004713276	0.469335205475452	0.469335205475452	false	false	false	true
cfc8df84-264a-40d6-ad67-74eab5fa606d	2026-09-11 15:38	2026-09-11 15:38	2026-09-11 15:38	MGM	MGM280121C00050000	call	50.0000	2028-01-21	2.8500	2.5000	2.8500	40.2000	18810.00	18810.00	0.00	66	5	66	7051	0.0093603744149766	0.286735034614725	0.286735034614725	false	false	false	true
1adbcbf4-2e7e-4505-8008-42cd1145d729	2026-09-11 15:34	2026-09-11 15:34	2026-09-11 15:34	MGM	MGM261016P00040000	put	40.0000	2026-10-16	1.7000	1.6000	1.9500	40.1400	25330.00	4420.00	20910.00	149	13	504	1390	0.362589928057554	0.373244681440548	0.373244681440548	false	false	false	true
7b653afb-1afd-4c8c-9209-f729885cb623	2026-09-11 10:58	2026-09-11 10:58	2026-09-11 10:58	MGM	MGM261016P00040000	put	40.0000	2026-10-16	1.5500	1.2000	1.7500	40.3850	33275.00	6200.00	27075.00	215	18	217	1390	0.156115107913669	0.36472205022058	0.354543252186704	true	false	false	true
91e6bc3c-c848-4658-a591-c614a7866f3e	2026-09-10 11:00	2026-09-10 11:00	2026-09-10 11:00	MGM	MGM280121C00035000	call	35.0000	2028-01-21	10.2000	10.2000	10.8000	40.9700	21420.00	0.00	21420.00	21	8	112	179	0.625698324022346	0.307124382623998	0.307124382623998	false	false	false	true
0aedbcd2-3ecf-4e05-9919-9020377858c3	2026-09-09 15:57	2026-09-09 15:57	2026-09-09 15:57	MGM	MGM260918C00036000	call	36.0000	2026-09-18	4.7000	4.5000	5.0000	40.5700	35250.00	7050.00	28200.00	75	5	235	351	0.66951566951567	0.519417467377535	0.519417467377535	false	false	false	true
5a594252-2b7b-4d1d-a6db-c6c1626badaa	2026-09-09 15:48	2026-09-09 15:47	2026-09-09 15:47	MGM	MGM260918C00036000	call	36.0000	2026-09-18	4.8000	4.6000	4.9000	40.6400	18240.00	14880.00	0.00	38	9	123	351	0.35042735042735	0.560096493599821	0.560096493599821	false	false	false	true
a3d69142-b807-44aa-bcea-990f187b1716	2026-09-09 15:47	2026-09-09 15:47	2026-09-09 15:47	MGM	MGM260918C00036000	call	36.0000	2026-09-18	4.7000	4.5000	4.9000	40.6350	39950.00	0.00	35250.00	85	6	85	351	0.242165242165242	0.418961683582766	0.418961683582766	false	false	false	true
b0b0caa0-8fc2-4d0d-bd1d-86d4e1730a1f	2026-09-09 14:14	2026-09-09 14:14	2026-09-09 14:14	MGM	MGM261016C00043000	call	43.0000	2026-10-16	1.0500	0.8000	1.2000	40.2200	104999.00	47564.00	57435.00	1000	40	2000	2744	0.728862973760933	0.403264359942731	0.398975752009705	false	false	false	true
a61b5d8a-004a-4e61-9f4f-582ec9f82a8b	2026-09-09 10:48	2026-09-09 10:48	2026-09-09 10:48	MGM	MGM260918C00040000	call	40.0000	2026-09-18	1.1000	1.0000	1.2500	40.2000	11000.00	330.00	110.00	100	7	101	6579	0.0153518771849825	0.389018977135486	0.389018977135486	false	false	false	true
2fcdad68-13e2-4b42-bd3d-c90471864e6c	2026-09-09 09:34	2026-09-09 09:34	2026-09-09 09:34	MGM	MGM261016P00040000	put	40.0000	2026-10-16	1.6100	1.0000	1.8000	40.3200	18380.00	5100.00	12320.00	114	22	114	1170	0.0974358974358974	0.359497040521461	0.379275553743068	true	false	false	true
b601a057-893d-438d-ab0d-c1b254bf6506	2026-09-08 14:29	2026-09-08 14:29	2026-09-08 14:29	MGM	MGM260918C00041000	call	41.0000	2026-09-18	1.2000	1.1000	1.3500	41.1350	30000.00	0.00	27600.00	250	46	840	187	4.49197860962567	0.409226785348185	0.409226785348185	true	false	false	true
d95d5959-fc30-4f03-836c-9d440b6f1ab8	2026-09-08 13:55	2026-09-08 13:55	2026-09-08 13:55	MGM	MGM260918C00041000	call	41.0000	2026-09-18	1.0500	1.0500	1.7500	40.9100	11970.00	0.00	11970.00	114	30	570	187	3.04812834224599	0.397245362126637	0.397245362126637	false	false	false	true
109f9cb6-a770-4e1e-a26e-ba47190ac2e3	2026-09-08 13:54	2026-09-08 13:54	2026-09-08 13:54	MGM	MGM260918C00041000	call	41.0000	2026-09-18	1.1000	1.0000	1.1000	40.9450	27500.00	27500.00	0.00	250	5	303	187	1.62032085561497	0.409158386957222	0.409158386957222	true	false	false	true
c198817b-3672-42a3-abbc-e79124d38bda	2026-09-08 11:27	2026-09-08 11:27	2026-09-08 11:27	MGM	MGM260918P00043000	put	43.0000	2026-09-18	2.5500	2.5500	2.7500	40.7600	12495.00	0.00	10455.00	49	5	49	7027	0.0069731037427067	0.408471979199663	0.408471979199663	false	false	false	true
e4be6650-7864-42d0-95c1-29ee09ecdf1a	2026-09-04 15:31	2026-09-04 15:31	2026-09-04 15:31	MGM	MGM260918P00041000	put	41.0000	2026-09-18	1.1000	0.9000	1.1000	41.3800	38500.00	34650.00	0.00	350	69	1194	5686	0.209989447766444	0.40694227423923	0.40694227423923	true	false	false	true
ddc2c303-adc6-459b-9dd4-98407ec27d1e	2026-09-04 14:03	2026-09-04 14:03	2026-09-04 14:03	MGM	MGM260918P00041000	put	41.0000	2026-09-18	1.1000	0.9000	1.2000	41.3000	11000.00	9350.00	440.00	100	6	820	5686	0.14421385860007	0.396017150185596	0.396017150185596	false	false	false	true
f766a730-af6a-419a-916e-207669ad423d	2026-09-04 14:03	2026-09-04 14:03	2026-09-04 14:03	MGM	MGM260918P00041000	put	41.0000	2026-09-18	1.1000	0.9000	1.1000	41.3250	11000.00	11000.00	0.00	100	22	720	5686	0.126626802673233	0.399453043840962	0.399453043840962	false	false	false	true
069ad5d6-111d-4da6-af02-4f10201abcb7	2026-09-04 14:03	2026-09-04 14:03	2026-09-04 14:03	MGM	MGM260918P00041000	put	41.0000	2026-09-18	1.1000	0.9000	1.1000	41.3500	11000.00	11000.00	0.00	100	12	620	5686	0.109039746746395	0.402868943059674	0.402868943059674	false	false	false	true
22fd96f5-658c-43f3-88bc-6c62a434f890	2026-09-04 14:03	2026-09-04 14:03	2026-09-04 14:03	MGM	MGM260918P00041000	put	41.0000	2026-09-18	1.1000	0.8500	1.2000	41.3500	11000.00	110.00	440.00	100	7	520	5686	0.0914526908195568	0.402868943059674	0.402868943059674	false	false	false	true
768428f8-0e5c-4b82-bca3-4759203f360b	2026-09-04 10:47	2026-09-04 10:47	2026-09-04 10:47	MGM	MGM261016C00044000	call	44.0000	2026-10-16	1.2000	0.8500	1.2000	41.5400	30000.00	30000.00	0.00	250	28	875	1032	0.847868217054264	0.372979574864269	0.371613691902861	false	false	false	true
81c289ab-c544-42a0-940f-f00c49456ea6	2026-09-03 10:02	2026-09-03 10:02	2026-09-03 10:02	MGM	MGM260918P00041000	put	41.0000	2026-09-18	1.2000	1.0000	1.2000	41.3650	11999.00	10919.00	0.00	100	27	500	5183	0.0964692263168049	0.422099608531888	0.422099608531888	true	false	false	true
87da9ab4-bf9f-4526-aad7-2ef8b372fb3d	2026-09-03 10:02	2026-09-03 10:02	2026-09-03 10:02	MGM	MGM260918P00041000	put	41.0000	2026-09-18	1.2000	1.0000	1.2000	41.3650	11999.00	10919.00	0.00	100	25	400	5183	0.0771753810534439	0.422099608531888	0.422099608531888	true	false	false	true
18674c30-c00d-4727-a279-a00910d83829	2026-09-03 09:48	2026-09-03 09:47	2026-09-03 09:47	MGM	MGM260918P00041000	put	41.0000	2026-09-18	1.2000	1.0000	1.2000	41.2550	12000.00	10800.00	0.00	100	27	200	5183	0.038587690526722	0.407438143181803	0.407438143181803	true	false	false	true
2e5385cf-d9f6-4197-b097-5b3e0e240ca6	2026-09-02 10:34	2026-09-02 10:34	2026-09-02 10:34	MGM	MGM261016C00045000	call	45.0000	2026-10-16	0.9500	0.6500	1.0500	41.6200	20900.00	13110.00	7790.00	220	44	220	157	1.40127388535032	0.364287232865957	0.364287232865957	true	false	false	true
a4115833-9c0d-4bbb-8c7e-2dbd94c8a53f	2026-09-01 14:44	2026-09-01 14:44	2026-09-01 14:44	MGM	MGM270115C00048000	call	48.0000	2027-01-15	1.0500	1.0500	1.5500	40.9000	18375.00	0.00	18375.00	175	7	175	5282	0.033131389625142	0.309181799889367	0.309181799889367	false	false	false	true