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×er_time = unknown×ticker = MPC×

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

bd87118c-a6b9-49d9-a668-adf4d66c9929	2026-09-17 14:39	2026-09-17 14:39	2026-09-17 14:39	MPC	MPC270416C00450000	call	450.0000	2027-04-16	57.3900	56.9000	58.1000	422.6296	86090.00	22950.00	63140.00	15	6	659	5	131.8	0.501531419101363	0.500412943813836	true	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Energy	118496816995.00	2026-11-03	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-17T18:42:11.317744Z"}	2026-09-17	2026-09-17 21:15	2026-09-17 21:15
598bfe0b-2e21-4442-834a-b6e27f733160	2026-09-17 14:39	2026-09-17 14:39	2026-09-17 14:39	MPC	MPC270416C00450000	call	450.0000	2027-04-16	57.3000	57.1000	58.7000	422.5500	103140.00	5730.00	97410.00	18	5	609	5	121.8	0.500747829358759	0.500747829358759	true	false	false	true
96f305fe-4597-4a22-8ac3-33925da7d0ff	2026-09-17 13:42	2026-09-17 13:42	2026-09-17 13:42	MPC	MPC270917C00470000	call	470.0000	2027-09-17	69.5200	69.3000	72.5000	421.8900	62570.00	27860.00	34710.00	9	7	13	9	1.44444444444444	0.479860687379491	0.481055934396279	false	false	false	true
d0614b5b-d33e-4dac-a595-c3969216a2be	2026-09-17 13:03	2026-09-17 13:02	2026-09-17 13:02	MPC	MPC270319C00440000	call	440.0000	2027-03-19	56.6000	56.3000	56.6000	421.9750	90560.00	90560.00	0.00	16	5	17	67	0.253731343283582	0.506712015386846	0.506712015386846	false	false	false	true
7763260e-a4bb-4f11-a7bf-bccf5fc4fccd	2026-09-17 12:43	2026-09-17 12:43	2026-09-17 12:43	MPC	MPC270115P00350000	put	350.0000	2027-01-15	17.9000	17.0000	18.0000	421.6000	68020.00	42960.00	25060.00	38	10	1094	75	14.5866666666667	0.533588218454562	0.533588218454562	true	false	false	true
8ae5025b-bf6f-48b8-8cf4-297c295b9a57	2026-09-17 11:47	2026-09-17 11:47	2026-09-17 11:47	MPC	MPC261016P00440000	put	440.0000	2026-10-16	35.9000	35.9000	36.3000	419.0001	75390.00	0.00	75390.00	21	8	39	32	1.21875	0.516302374781675	0.516302374781675	true	false	false	true
0cc89920-f21a-4a84-a9da-89ab74df68e4	2026-09-17 10:11	2026-09-17 10:11	2026-09-17 10:11	MPC	MPC261218P00370000	put	370.0000	2026-12-18	22.4000	21.4000	22.4000	413.4700	56000.00	56000.00	0.00	25	5	26	464	0.0560344827586207	0.539096103187376	0.539096103187376	false	false	false	true
55c7b111-35ad-48f8-9f3f-f2dbe70caba6	2026-09-16 15:10	2026-09-16 15:10	2026-09-16 15:10	MPC	MPC261016P00410000	put	410.0000	2026-10-16	22.3000	21.3000	22.3000	413.0000	196240.00	196240.00	0.00	88	6	141	126	1.11904761904762	0.519761571401831	0.519760625105494	false	false	false	true
c2e75413-1d9c-4cac-a1d9-493a1088be3f	2026-09-16 13:52	2026-09-16 13:52	2026-09-16 13:52	MPC	MPC270617C00450000	call	450.0000	2027-06-17	61.1500	60.8000	63.0000	417.0000	97840.00	42870.00	54970.00	16	7	18	144	0.125	0.476316529482511	0.476316529482511	false	false	false	true
b3798e98-7247-4108-a44b-280da3906f7e	2026-09-16 13:49	2026-09-16 13:49	2026-09-16 13:49	MPC	MPC270319P00390000	put	390.0000	2027-03-19	41.6000	40.7000	42.3000	417.0000	62400.00	49920.00	12480.00	15	9	25	10	2.5	0.51457436259373	0.51457436259373	false	false	false	true
1c669ecd-e1f1-4a2c-9439-d29756b8ece3	2026-09-16 13:15	2026-09-16 13:15	2026-09-16 13:15	MPC	MPC270115C00580000	call	580.0000	2027-01-15	11.2000	10.3000	11.2000	418.3100	190400.00	190400.00	0.00	170	42	171	2	85.5	0.521497410047356	0.521497410047356	false	false	false	true
23be70d9-0c9e-4337-af7a-0558a16d1233	2026-09-15 15:24	2026-09-15 15:24	2026-09-15 15:24	MPC	MPC261218C00400000	call	400.0000	2026-12-18	49.2000	49.2000	50.3000	411.4100	59040.00	0.00	59040.00	12	6	49	695	0.0705035971223022	0.50170135393605	0.50170135393605	false	false	false	true
40aaf0d4-2acc-4d83-9b51-9fb4a4824326	2026-09-15 15:23	2026-09-15 15:23	2026-09-15 15:23	MPC	MPC270617P00430000	put	430.0000	2027-06-17	72.8200	72.7000	74.9000	411.7350	94670.00	36400.00	50990.00	13	7	149	68	2.19117647058824	0.485226054386909	0.485226054386909	false	false	false	true
1f44656e-5d18-4408-a29f-756eade152c2	2026-09-15 13:23	2026-09-15 13:23	2026-09-15 13:23	MPC	MPC280121P00300000	put	300.0000	2028-01-21	28.3000	27.3000	29.9000	410.5700	152820.00	33960.00	118860.00	54	27	134	64	2.09375	0.473904079545855	0.473697723054155	false	false	false	true
ad03cb3d-b73d-4b2c-9996-56ddf16be49b	2026-09-15 12:52	2026-09-15 12:52	2026-09-15 12:52	MPC	MPC270617P00430000	put	430.0000	2027-06-17	73.0300	72.8000	74.5000	410.4500	197180.00	29220.00	146060.00	27	9	31	68	0.455882352941176	0.48267873204216	0.48267873204216	false	false	false	true
aa7159dd-ffb8-4d72-91cb-05d7ade6a5d4	2026-09-15 12:20	2026-09-15 12:20	2026-09-15 12:20	MPC	MPC270115C00500000	call	500.0000	2027-01-15	20.0000	18.9000	20.0000	408.0000	112000.00	112000.00	0.00	56	9	56	58	0.96551724137931	0.502373955713335	0.502373955713335	false	false	false	true
6ecbd46a-bf80-424e-b1d5-17ed7dff5ab1	2026-09-15 09:57	2026-09-15 09:57	2026-09-15 09:57	MPC	MPC261218P00370000	put	370.0000	2026-12-18	24.4000	22.0000	24.4000	403.3300	61000.00	61000.00	0.00	25	10	28	224	0.125	0.519784581258396	0.519784581258396	false	false	false	true
d52d0a42-d158-45e8-bc75-0d4a7cf35f22	2026-09-14 15:04	2026-09-14 15:04	2026-09-14 15:04	MPC	MPC261016P00400000	put	400.0000	2026-10-16	27.4000	26.1000	27.4000	391.6150	120560.00	120560.00	0.00	44	10	85	231	0.367965367965368	0.508026064421853	0.508026064421853	true	false	false	true
e45a7d51-09a4-4efd-980f-0a3254018b57	2026-09-14 11:35	2026-09-14 11:34	2026-09-14 11:34	MPC	MPC260918P00400000	put	400.0000	2026-09-18	13.3000	11.8000	13.3000	393.0600	69160.00	69160.00	0.00	52	7	678	455	1.49010989010989	0.575828892379513	0.575828892379513	false	false	false	true
95e0322b-c90d-49a1-bb76-a94e6e9cf1b7	2026-09-14 11:06	2026-09-14 11:06	2026-09-14 11:06	MPC	MPC260918C00350000	call	350.0000	2026-09-18	51.0000	51.0000	54.2000	400.6800	239700.00	0.00	239700.00	47	10	60	463	0.129589632829374	1.07458143767799	0.627467221395997	false	false	false	true
c2c51ec4-b191-43c7-88f9-e9affb30969d	2026-09-14 10:42	2026-09-14 10:41	2026-09-14 10:41	MPC	MPC261016P00410000	put	410.0000	2026-10-16	24.6000	23.8000	24.6000	407.4500	66419.00	66419.00	0.00	27	16	35	13	2.69230769230769	0.498104534613495	0.498104534613495	false	false	false	true
0e025cb0-ffa5-4701-8585-75d36e10b8e9	2026-09-14 10:23	2026-09-14 10:23	2026-09-14 10:23	MPC	MPC260918P00400000	put	400.0000	2026-09-18	6.5000	5.3000	7.3000	406.0000	61100.00	11050.00	50050.00	94	23	314	455	0.69010989010989	0.561092028009973	0.561092028009973	true	false	false	true
ae09e63d-e720-4d76-954b-fbd91c07c2cd	2026-09-14 10:22	2026-09-14 10:22	2026-09-14 10:22	MPC	MPC261218P00370000	put	370.0000	2026-12-18	23.1000	21.1000	23.1000	406.0000	57750.00	57750.00	0.00	25	12	25	196	0.127551020408163	0.509779449234745	0.509779449234745	false	false	false	true
3b5d9ff3-9542-4b65-bea2-535b71ee3edc	2026-09-14 10:08	2026-09-14 10:07	2026-09-14 10:07	MPC	MPC260918C00380000	call	380.0000	2026-09-18	29.0000	26.8000	29.0000	407.5200	116000.00	116000.00	0.00	40	5	100	633	0.157977883096367	0.589367927422331	0.563525441675631	false	false	false	true
cdd5d145-53ec-4277-9edd-e0c0ef3fcd4c	2026-09-14 09:55	2026-09-14 09:55	2026-09-14 09:55	MPC	MPC260918C00380000	call	380.0000	2026-09-18	28.0000	26.6000	28.3000	406.2100	56000.00	50400.00	5600.00	20	6	60	633	0.0947867298578199	0.581541452957945	0.581541452957945	false	false	false	true
486776db-833c-4690-8eaf-0c8ca742855c	2026-09-14 09:50	2026-09-14 09:50	2026-09-14 09:50	MPC	MPC260918C00380000	call	380.0000	2026-09-18	27.5000	25.8000	28.8000	405.4100	55000.00	46750.00	8250.00	20	6	20	633	0.0315955766192733	0.602162269867205	0.602162269867205	false	false	false	true
365e1155-1c90-466b-9e18-3b8b3060e0b7	2026-09-11 13:31	2026-09-11 13:31	2026-09-11 13:31	MPC	MPC280616C00380000	call	380.0000	2028-06-16	113.5000	109.5000	113.5000	402.5800	510750.00	510750.00	0.00	45	15	45	46	0.978260869565217	0.432511589025929	0.432511589025929	false	false	false	true
5eff3933-fcc4-4211-b85c-a320324e431a	2026-09-11 11:37	2026-09-11 11:37	2026-09-11 11:37	MPC	MPC261218P00370000	put	370.0000	2026-12-18	24.3000	22.3000	24.3000	405.4050	60750.00	60750.00	0.00	25	8	25	170	0.147058823529412	0.5168835480822	0.5168835480822	false	false	false	true
ff2ab22b-de0b-425a-9c1f-97b96d6a7170	2026-09-11 11:15	2026-09-11 11:15	2026-09-11 11:15	MPC	MPC261218P00410000	put	410.0000	2026-12-18	42.3000	42.3000	43.9000	403.7500	736020.00	0.00	736020.00	174	38	174	131	1.32824427480916	0.496553285333859	0.496553285333859	false	false	false	true
5717a89d-6868-4dd2-9224-648d25a5beca	2026-09-10 15:59	2026-09-10 15:59	2026-09-10 15:59	MPC	MPC260918C00350000	call	350.0000	2026-09-18	43.1000	43.1000	45.4000	392.4900	116370.00	0.00	116370.00	27	13	27	449	0.0601336302895323	0.402113491856888	0.42812068206556	true	false	false	true
a23224e2-7f8a-436c-938a-cc1b2ac0f5ad	2026-09-10 11:03	2026-09-10 11:02	2026-09-10 11:02	MPC	MPC260918P00400000	put	400.0000	2026-09-18	11.8000	11.2000	11.8000	398.0600	151040.00	151040.00	0.00	128	13	213	72	2.95833333333333	0.46610896142258	0.46610896142258	false	false	false	true
2b30b099-4bc5-4557-8d64-1e8d10b0f64e	2026-09-10 11:01	2026-09-10 11:01	2026-09-10 11:01	MPC	MPC260918C00400000	call	400.0000	2026-09-18	10.5000	9.8000	10.5000	398.0650	162750.00	162750.00	0.00	155	21	192	933	0.205787781350482	0.479028089312371	0.479028089312371	false	false	false	true
b6fdb2da-c215-4798-b2de-182ed64b5eaa	2026-09-10 10:13	2026-09-10 10:13	2026-09-10 10:13	MPC	MPC261218P00370000	put	370.0000	2026-12-18	26.7000	25.8000	26.7000	396.0100	66750.00	66750.00	0.00	25	8	51	122	0.418032786885246	0.506351367495627	0.506351367495627	false	false	false	true
3477a043-d386-461c-94f7-6cad92967c8b	2026-09-10 09:52	2026-09-10 09:52	2026-09-10 09:52	MPC	MPC261218P00370000	put	370.0000	2026-12-18	26.2000	25.0000	26.2000	397.3200	65500.00	65500.00	0.00	25	5	25	122	0.204918032786885	0.505461692490086	0.505461692490086	false	false	false	true
6fb518c2-b9bd-46e6-9d97-9e4a0db68e74	2026-09-10 09:51	2026-09-10 09:50	2026-09-10 09:50	MPC	MPC260918P00390000	put	390.0000	2026-09-18	8.0000	7.3000	8.0000	397.3900	82400.00	82400.00	0.00	103	5	646	347	1.86167146974063	0.492594517427036	0.492594517427036	false	false	false	true
c9372b7b-efc7-45b0-a089-aaced70600e4	2026-09-09 14:40	2026-09-09 14:39	2026-09-09 14:39	MPC	MPC261218P00370000	put	370.0000	2026-12-18	25.9000	24.4000	25.9000	398.5600	64750.00	64750.00	0.00	25	8	76	52	1.46153846153846	0.504326853714197	0.504326853714197	false	false	false	true
4112e4fc-ff81-4b02-b9a5-3986854de19e	2026-09-09 14:32	2026-09-09 14:32	2026-09-09 14:32	MPC	MPC270617P00440000	put	440.0000	2027-06-17	84.4000	82.6000	84.9000	399.7300	143480.00	75960.00	67520.00	17	9	31	5	6.2	0.490932209299334	0.490932209299334	false	false	false	true
2596e8f5-daab-4ba4-8818-d288295745e3	2026-09-09 13:44	2026-09-09 13:44	2026-09-09 13:44	MPC	MPC270617C00450000	call	450.0000	2027-06-17	51.3000	49.5000	51.3000	400.8850	51300.00	51300.00	0.00	10	6	10	28	0.357142857142857	0.463289516543	0.463289516543	false	false	false	true
1560c271-ad3f-47f8-b428-b6111d49dbfd	2026-09-08 13:33	2026-09-08 13:33	2026-09-08 13:33	MPC	MPC270617C00450000	call	450.0000	2027-06-17	48.3100	47.1000	48.4000	395.7050	86950.00	82120.00	4830.00	18	7	29	10	2.9	0.464062271552586	0.464783647691718	true	false	false	true
15ada258-1f35-4142-a811-47b128acdd3c	2026-09-03 15:21	2026-09-03 15:21	2026-09-03 15:21	MPC	MPC261218P00410000	put	410.0000	2026-12-18	50.1000	49.2000	50.1000	389.1700	100199.00	100199.00	0.00	20	13	23	39	0.58974358974359	0.48827928323037	0.48827928323037	false	false	false	true
2309492b-384c-40c3-91f9-342012b6ea91	2026-09-03 12:20	2026-09-03 12:19	2026-09-03 12:19	MPC	MPC261016P00390000	put	390.0000	2026-10-16	23.6000	23.6000	24.1000	391.0900	238360.00	0.00	238360.00	101	16	129	97	1.32989690721649	0.469260770125754	0.469260770125754	false	false	false	true
d75b4ebd-c099-4b74-99e9-9f0089e0dd70	2026-09-03 10:55	2026-09-03 10:55	2026-09-03 10:55	MPC	MPC270115C00470000	call	470.0000	2027-01-15	22.5000	22.0000	22.6000	397.1850	81000.00	20250.00	60750.00	36	10	36	103	0.349514563106796	0.470911901460233	0.470911901460233	false	false	false	true
8dfd534e-5e7f-4a97-8e2e-ba2317167ee2	2026-09-03 10:53	2026-09-03 10:53	2026-09-03 10:53	MPC	MPC270115C00480000	call	480.0000	2027-01-15	20.5000	19.8000	20.8000	398.2300	84050.00	82000.00	2050.00	41	24	42	5	8.4	0.470725096577314	0.470725096577314	true	false	false	true
4d978ab3-51c8-4097-9b9c-95381a2f2e49	2026-09-02 14:51	2026-09-02 14:51	2026-09-02 14:51	MPC	MPC261016P00390000	put	390.0000	2026-10-16	23.3000	23.3000	24.1000	389.8200	53590.00	0.00	51260.00	23	9	59	30	1.96666666666667	0.44798015875321	0.44798015875321	false	false	false	true
2b3a6a7e-bdc3-40d2-abcd-7fb3a5015dc4	2026-09-02 13:43	2026-09-02 13:43	2026-09-02 13:43	MPC	MPC270617P00430000	put	430.0000	2027-06-17	80.8000	78.6000	81.4000	389.4050	355520.00	307040.00	8080.00	44	19	44	0	0	0.470458112172837	0.470458112172837	false	false	false	true
722e13de-c0fa-4e48-a776-f43ad12a4079	2026-09-02 13:22	2026-09-02 13:22	2026-09-02 13:22	MPC	MPC261218C00380000	call	380.0000	2026-12-18	44.3000	44.2000	45.0000	388.8250	53160.00	13290.00	39870.00	12	5	37	276	0.134057971014493	0.453184580685251	0.453184580685251	false	false	false	true
9de01503-5a10-459c-87b7-5d5f44ba5b1f	2026-09-02 12:53	2026-09-02 12:53	2026-09-02 12:53	MPC	MPC261016P00380000	put	380.0000	2026-10-16	19.5000	18.9000	19.5000	388.4450	76050.00	76050.00	0.00	39	19	163	128	1.2734375	0.457590210817891	0.457590210817891	false	false	false	true
fd8c440b-9c73-4946-8aca-29c12aceb432	2026-09-02 10:55	2026-09-02 10:55	2026-09-02 10:55	MPC	MPC260918C00400000	call	400.0000	2026-09-18	8.8000	8.8000	9.5000	385.1000	111760.00	0.00	111760.00	127	41	142	654	0.217125382262997	0.453230320262947	0.453230320262947	true	false	false	true
f16ddca4-799e-4435-93d8-997dcce92d62	2026-09-02 10:01	2026-09-02 10:01	2026-09-02 10:01	MPC	MPC270319C00400000	call	400.0000	2027-03-19	48.3000	46.2000	48.3000	385.6650	62790.00	62790.00	0.00	13	7	22	68	0.323529411764706	0.448441537844884	0.448441537844884	false	false	false	true
ac424388-b38c-4fe8-b964-a1637b31788f	2026-09-01 15:03	2026-09-01 15:03	2026-09-01 15:03	MPC	MPC261218P00380000	put	380.0000	2026-12-18	37.1000	36.9000	37.6000	378.1600	140980.00	0.00	140980.00	38	13	59	95	0.621052631578947	0.470566605853605	0.470566605853605	false	false	false	true