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:er_time = unknown×ticker = MPT×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	expirydate

ba66f582-aa2c-4a00-a9a6-ca9ea44e6bfc	2026-08-18 09:47	2026-08-18 09:47	2026-08-18 09:47	MPT	MPT270319P00004000	put	4.0000	2027-03-19	0.5200	0.4700	0.5200	4.0000	10380.00	6963.00	3417.00	201	6	302	15626	0.0193267630871624	0.471402400849822	0.479841726097357	true	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Real Estate	2137976000.00	2026-10-29	unknown	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-18T13:50:18.630361Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
0a6f641e-9093-4d2a-8485-cb2dde9230d3	2026-08-18 11:55	2026-08-18 11:55	2026-08-18 11:55	MPT	MPT270115P00003000	put	3.0000	2027-01-15	0.1000	0.0800	0.1000	4.0250	10000.00	10000.00	0.00	1000	37	1855	14419	0.128649698314724	0.505327171197599	0.505327171197599	false	false	false	true
4ad44d02-39fd-468f-ace3-0c1e6bb74d3b	2026-08-18 11:56	2026-08-18 11:55	2026-08-18 11:55	MPT	MPT270115P00003000	put	3.0000	2027-01-15	0.1000	0.0800	0.1100	4.0200	27760.00	24900.00	2860.00	2776	62	4631	14419	0.321173451695679	0.505327171197599	0.504130824084298	false	false	false	true
f33c4488-e78a-4e79-b522-8910cdddf688	2026-08-18 12:31	2026-08-18 12:31	2026-08-18 12:31	MPT	MPT270115P00003000	put	3.0000	2027-01-15	0.1100	0.1000	0.1100	4.0300	46244.00	46244.00	0.00	4204	26	8855	14419	0.614120257992926	0.524438675519623	0.524438675519623	false	false	false	true
134c3f6b-7f77-4063-bc91-33bc622eb836	2026-08-24 10:11	2026-08-24 10:11	2026-08-24 10:11	MPT	MPT270115C00005000	call	5.0000	2027-01-15	0.0800	0.0700	0.0900	4.1100	21312.00	0.00	21272.00	2664	15	2700	19096	0.141390867197319	0.305173035076524	0.305173035076524	false	false	false	true
97658733-63cf-4207-8f76-149ba88d901b	2026-08-26 15:26	2026-08-26 15:26	2026-08-26 15:26	MPT	MPT270617P00002500	put	2.5000	2027-06-17	0.1400	0.0700	0.1600	4.1201	140000.00	140000.00	0.00	10000	1	10312	417	24.7290167865707	0.593176324047319	0.593176324047319	false	true	false	true
1e967156-7942-4970-b7a3-3ffc65aa2157	2026-08-27 10:51	2026-08-27 10:51	2026-08-27 10:51	MPT	MPT270617P00002500	put	2.5000	2027-06-17	0.1400	0.1100	0.1500	4.0699	21980.00	19908.00	252.00	1570	32	1629	20920	0.077868068833652	0.586201541851117	0.586201541851117	false	false	false	true
aed74492-4c6e-43de-8537-7af38c6f00d3	2026-08-27 10:53	2026-08-27 10:53	2026-08-27 10:53	MPT	MPT270617P00002500	put	2.5000	2027-06-17	0.1300	0.1100	0.1400	4.0550	13169.00	10556.00	377.00	1013	13	2714	20920	0.129732313575526	0.568807779958338	0.568807779958338	false	false	false	true
22c04ae9-bfb7-419b-8e97-2282470dfb2a	2026-08-28 10:15	2026-08-28 10:15	2026-08-28 10:15	MPT	MPT261009P00004500	put	4.5000	2026-10-09	0.5900	0.4100	0.5900	4.1100	46816.00	46762.00	54.00	794	47	802	0	0	0.648331215930351	0.648331215930351	true	false	false	true
2425c556-7e96-4f84-9755-565620691683	2026-08-28 10:18	2026-08-28 10:17	2026-08-28 10:17	MPT	MPT261009P00004500	put	4.5000	2026-10-09	0.5900	0.4100	0.5900	4.0900	143003.00	143003.00	0.00	2444	29	3716	0	0	0.605863598659298	0.624959466763404	true	false	false	true
04702a19-d2c3-4735-aa2d-e07a6302a71b	2026-08-28 10:18	2026-08-28 10:17	2026-08-28 10:17	MPT	MPT261016P00004500	put	4.5000	2026-10-16	0.5400	0.4800	0.5400	4.0900	15768.00	15768.00	0.00	292	10	400	2217	0.18042399639152	0.493945798068454	0.493945798068454	false	false	false	true
19cb0edd-099d-473f-9501-8cbe8637a06a	2026-08-28 11:11	2026-08-28 11:11	2026-08-28 11:11	MPT	MPT281215P00002500	put	2.5000	2028-12-15	0.3900	0.3800	0.3900	4.0900	19500.00	19500.00	0.00	500	19	1243	4630	0.268466522678186	0.57611228907596	0.57611228907596	true	false	false	true
c28ba3c3-3850-455f-a274-5a2b6ca12af9	2026-08-28 11:12	2026-08-28 11:11	2026-08-28 11:11	MPT	MPT281215P00002500	put	2.5000	2028-12-15	0.3900	0.3800	0.3900	4.0899	19500.00	19500.00	0.00	500	5	2243	4630	0.484449244060475	0.576102226806345	0.576102226806345	false	false	false	true
a9d3c2ff-34ea-4d0c-b3bd-0c9de400649a	2026-08-28 11:12	2026-08-28 11:11	2026-08-28 11:11	MPT	MPT281215P00002500	put	2.5000	2028-12-15	0.3900	0.3800	0.3900	4.0900	19500.00	19500.00	0.00	500	6	1743	4630	0.37645788336933	0.57611228907596	0.57611228907596	false	false	false	true
0830db88-25ff-41a7-aaa9-b3dc2e0b1b96	2026-08-31 10:41	2026-08-31 10:41	2026-08-31 10:41	MPT	MPT281215P00002500	put	2.5000	2028-12-15	0.4200	0.3200	0.4400	4.0050	93534.00	79590.00	11676.00	2227	20	3230	7597	0.425167829406345	0.603560773098439	0.602526354127496	false	false	false	true
922c1cec-769e-49df-a751-a2bbc41810b3	2026-08-31 10:42	2026-08-31 10:42	2026-08-31 10:42	MPT	MPT281215P00002500	put	2.5000	2028-12-15	0.4200	0.3200	0.4400	4.0000	168000.00	164052.00	3948.00	4000	47	8003	7597	1.0534421482164	0.602526354127496	0.602007692095239	false	false	false	true
bd3f8097-e0dd-4341-9f43-a0cd7e7eaa54	2026-08-31 12:42	2026-08-31 12:42	2026-08-31 12:42	MPT	MPT261016P00004000	put	4.0000	2026-10-16	0.2300	0.2200	0.2300	3.9850	25737.00	25737.00	0.00	1119	17	1248	2325	0.536774193548387	0.412018772036445	0.412018772036445	false	false	false	true
1d8542cd-ff7d-4220-bdbe-8a550bade94a	2026-08-31 13:17	2026-08-31 13:17	2026-08-31 13:17	MPT	MPT280121P00004000	put	4.0000	2028-01-21	0.8500	0.8200	0.8500	3.9600	17000.00	16915.00	0.00	200	17	200	5958	0.0335683115139309	0.527788852512959	0.527788852512959	true	false	false	true
ddbc9be0-d572-4a2a-940d-9bcf8fbd5842	2026-08-31 13:19	2026-08-31 13:18	2026-08-31 13:18	MPT	MPT280121P00004000	put	4.0000	2028-01-21	0.8500	0.8200	0.8500	3.9650	11475.00	11475.00	0.00	135	10	336	5958	0.0563947633434038	0.52879404386985	0.52879404386985	false	false	false	true
7e84b1d0-8a4d-489f-90bf-2cf5fc746ba5	2026-08-31 15:02	2026-08-31 15:02	2026-08-31 15:02	MPT	MPT270115C00005000	call	5.0000	2027-01-15	0.0600	0.0500	0.0600	3.9550	13524.00	13524.00	0.00	2254	26	2793	22501	0.124127816541487	0.325170987306525	0.325170987306525	false	false	false	true
c8903470-c353-4863-8583-e5de41df4342	2026-08-31 15:03	2026-08-31 15:03	2026-08-31 15:03	MPT	MPT270115C00005000	call	5.0000	2027-01-15	0.0600	0.0500	0.0600	3.9550	24660.00	24660.00	0.00	4110	61	6903	22501	0.306786365050442	0.325170987306525	0.325170987306525	false	false	false	true
389f1599-8ac1-4ab9-94e7-cffc8991c8a5	2026-09-01 15:55	2026-09-01 15:55	2026-09-01 15:55	MPT	MPT271217P00003000	put	3.0000	2027-12-17	0.3900	0.3300	0.4000	4.0200	46254.00	46254.00	0.00	1186	1	1250	3914	0.319366377107818	0.564611099668156	0.564611099668156	false	true	false	true
56522d20-31ac-435e-ac06-015232cfb9a4	2026-09-02 11:59	2026-09-02 11:59	2026-09-02 11:59	MPT	MPT281215P00002500	put	2.5000	2028-12-15	0.4000	0.3300	0.4700	4.1250	18600.00	800.00	17800.00	465	5	490	15027	0.032607972316497	0.601146812476072	0.601146812476072	false	false	false	true
d70e31ef-ba30-4f3c-ae09-7b7b594b621d	2026-09-02 12:01	2026-09-02 12:01	2026-09-02 12:01	MPT	MPT281215P00002500	put	2.5000	2028-12-15	0.4000	0.3500	0.4100	4.1100	97200.00	79720.00	10760.00	2430	21	6148	15027	0.409130232248619	0.599657505054771	0.599657505054771	false	false	false	true
88444682-4f22-4a4d-823d-d4a576a8946f	2026-09-02 12:01	2026-09-02 12:01	2026-09-02 12:01	MPT	MPT281215P00002500	put	2.5000	2028-12-15	0.4000	0.2000	0.4100	4.0950	29640.00	29240.00	400.00	741	14	7160	15027	0.476475677114527	0.598160106378416	0.598160106378416	false	false	false	true
7bf97349-fd4f-4f1b-991a-5d7791f0a970	2026-09-02 12:02	2026-09-02 12:02	2026-09-02 12:02	MPT	MPT281215P00002500	put	2.5000	2028-12-15	0.4100	0.2100	0.4100	4.0950	33210.00	33210.00	0.00	810	34	8001	15027	0.532441605110801	0.605633473574471	0.605633473574471	false	false	false	true
69f243a8-7e25-4098-9f0c-0f4b4d5185dd	2026-09-03 11:14	2026-09-03 11:14	2026-09-03 11:14	MPT	MPT270617P00002500	put	2.5000	2027-06-17	0.1500	0.1100	0.1500	4.0150	10500.00	10500.00	0.00	700	17	1228	26123	0.0470083834169123	0.598596477719587	0.598596477719587	false	false	false	true
93aa6933-00f6-4aa3-bd0f-6e5f2f60fb15	2026-09-08 12:29	2026-09-08 12:29	2026-09-08 12:29	MPT	MPT270115P00003000	put	3.0000	2027-01-15	0.1000	0.0700	0.1000	3.9690	10000.00	10000.00	0.00	1000	5	3000	25177	0.11915637288001	0.525971460304524	0.525971460304524	true	false	false	true
b7654a94-bca4-4886-83fa-b32f3ad6d99b	2026-09-09 09:45	2026-09-09 09:45	2026-09-09 09:45	MPT	MPT270617P00002500	put	2.5000	2027-06-17	0.1400	0.1100	0.1600	3.9750	11102.00	9226.00	0.00	793	13	793	27567	0.0287662785214205	0.587001498278715	0.587001498278715	true	false	false	true
f899562f-675e-4dc0-8538-06d129763193	2026-09-09 09:45	2026-09-09 09:45	2026-09-09 09:45	MPT	MPT270617P00002500	put	2.5000	2027-06-17	0.1500	0.1400	0.1500	3.9700	16470.00	16470.00	0.00	1098	14	4239	27567	0.153770812928501	0.601117080575858	0.601117080575858	false	false	false	true
85db8706-0d03-4a90-99da-f200dc9bb5af	2026-09-09 09:45	2026-09-09 09:45	2026-09-09 09:45	MPT	MPT270617P00002500	put	2.5000	2027-06-17	0.1500	0.1500	0.1700	3.9650	11415.00	0.00	11415.00	761	5	5000	27567	0.181376283237204	0.600266136817707	0.600266136817707	false	false	false	true
c38197e8-4acd-4ca5-8163-91b937fb6c51	2026-09-09 09:46	2026-09-09 09:46	2026-09-09 09:46	MPT	MPT270617P00002500	put	2.5000	2027-06-17	0.1600	0.1400	0.1600	3.9650	20959.00	20944.00	0.00	1310	9	7140	27567	0.259005332462727	0.600266136817707	0.614921671669877	false	false	false	true
5693a652-02e8-40e5-ad76-6ae93ea55c16	2026-09-09 09:46	2026-09-09 09:46	2026-09-09 09:46	MPT	MPT270617P00002500	put	2.5000	2027-06-17	0.1600	0.1400	0.1600	3.9650	18080.00	18080.00	0.00	1130	14	8270	27567	0.299996372474335	0.614921671669877	0.614921671669877	false	false	false	true
0a8c8a33-8b5b-4d7d-b4d6-da7cd2ff5946	2026-09-09 09:46	2026-09-09 09:46	2026-09-09 09:46	MPT	MPT270617P00002500	put	2.5000	2027-06-17	0.1600	0.1400	0.1600	3.9650	18768.00	18768.00	0.00	1173	7	9443	27567	0.342547248521783	0.614921671669877	0.614921671669877	false	false	false	true
09e17890-0cf9-4c99-ab93-df2e052535cf	2026-09-09 10:39	2026-09-09 10:39	2026-09-09 10:39	MPT	MPT270617P00002500	put	2.5000	2027-06-17	0.1500	0.1300	0.1600	3.0000	21165.00	19455.00	0.00	1411	28	21572	27567	0.782529836398593	0.594262338861873	0.594262338861873	true	false	false	true
63c74a84-9dc5-4d29-8856-e3565cdb49a6	2026-09-09 10:41	2026-09-09 10:41	2026-09-09 10:41	MPT	MPT270617P00002500	put	2.5000	2027-06-17	0.1600	0.1500	0.1600	3.9200	83488.00	83488.00	0.00	5218	44	35220	27567	1.27761453912286	0.607126687145868	0.607126687145868	false	false	false	true
a5e36808-98c3-4485-b3ed-662b222ef96f	2026-09-09 10:47	2026-09-09 10:47	2026-09-09 10:47	MPT	MPT270617P00002500	put	2.5000	2027-06-17	0.1700	0.1600	0.1700	3.9250	13141.00	13141.00	0.00	773	21	35999	27567	1.30587296405122	0.622343413891272	0.622343413891272	false	false	false	true
bb665074-3b28-419e-b6db-8fc764efaa05	2026-09-10 10:21	2026-09-10 10:21	2026-09-10 10:21	MPT	MPT270115P00004000	put	4.0000	2027-01-15	0.5000	0.4900	0.5300	3.7650	11250.00	0.00	11250.00	225	5	543	14915	0.0364063023801542	0.443657124481707	0.446593865468852	false	false	false	true
15ad1211-3659-4ce3-ad34-eba897021ab1	2026-09-11 14:46	2026-09-11 14:46	2026-09-11 14:46	MPT	MPT281215P00004000	put	4.0000	2028-12-15	1.1700	1.0600	1.1700	3.6750	29250.00	29250.00	0.00	250	9	250	2286	0.109361329833771	0.54149436026201	0.54149436026201	false	false	false	true
e7ca71cc-fcf8-4973-9790-f8370c46c67e	2026-09-14 15:42	2026-09-14 15:42	2026-09-14 15:42	MPT	MPT270917C00005500	call	5.5000	2027-09-17	0.1500	0.1300	0.1500	3.5700	45555.00	45555.00	0.00	3037	25	3068	1382	2.21997105643994	0.402149346375684	0.402149346375684	false	false	false	true
ffa25181-aa72-4577-9179-7521c2887d10	2026-09-16 15:18	2026-09-16 15:18	2026-09-16 15:18	MPT	MPT270917C00004000	call	4.0000	2027-09-17	0.3800	0.3200	0.3800	3.4150	19000.00	19000.00	0.00	500	8	1410	140	10.0714285714286	0.389208512563706	0.389208512563706	false	false	false	true
7a792c28-b7ba-4d7e-ac51-cff0c4727a79	2026-09-18 12:35	2026-09-18 12:35	2026-09-18 12:35	MPT	MPT270115C00003500	call	3.5000	2027-01-15	0.3200	0.3200	0.3500	3.4450	16000.00	0.00	8000.00	500	5	865	2214	0.390695573622403	0.416415036720832	0.416415036720832	false	false	false	true