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.

474,253 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts474,253 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:er_time = unknown×sector = Real Estate×

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

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	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Real Estate	2137976000.00	2026-10-29	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-09T14:59:53.339088Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
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
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
3e02c2e3-f76e-4d0e-a86b-0c6c9a634ada	2026-09-09 10:35	2026-09-09 10:35	2026-09-09 10:35	BXP	BXP261016P00062500	put	62.5000	2026-10-16	1.5000	1.5000	1.6000	65.0000	12600.00	0.00	12600.00	84	14	91	48	1.89583333333333	0.340113744623758	0.340113744623758	false	false	false	true
88548fc4-8798-4ebf-aefa-aae7006a6610	2026-09-09 10:26	2026-09-09 10:25	2026-09-09 10:25	CBRE	CBRE270115C00155000	call	155.0000	2027-01-15	7.4000	6.8000	7.4000	141.0000	275994.00	275994.00	0.00	373	49	374	70	5.34285714285714	0.347322419834547	0.347322419834547	false	false	false	true
13cdc9e2-0c48-4a26-926d-f274762abedc	2026-09-09 10:18	2026-09-09 10:18	2026-09-09 10:18	AGNC	AGNC270115P00010000	put	10.0000	2027-01-15	0.3600	0.3400	0.3600	10.6950	27000.00	27000.00	0.00	750	7	750	20411	0.0367448924599481	0.28855608310861	0.28855608310861	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
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
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
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
8e2180ef-8856-4562-8d9c-6d69fa7d6ecc	2026-09-08 15:44	2026-09-08 15:44	2026-09-08 15:44	FRMI	FRMI261016C00008000	call	8.0000	2026-10-16	0.2500	0.2500	0.3000	5.7714	13761.00	0.00	13761.00	550	7	724	6428	0.112632233976353	1.14253854419085	1.12535372919734	false	false	false	true
405f468d-93fc-4892-b133-219881f87318	2026-09-08 15:43	2026-09-08 15:43	2026-09-08 15:43	CXW	CXW261120C00040000	call	40.0000	2026-11-20	1.5500	1.5500	1.7000	35.0200	57970.00	0.00	57970.00	374	12	377	121	3.11570247933884	0.509576466293134	0.509576466293134	false	false	false	true
a0960488-5fb9-4cfe-b740-edfb7f06cb2e	2026-09-08 15:19	2026-09-08 15:19	2026-09-08 15:19	FRMI	FRMI261218C00010000	call	10.0000	2026-12-18	0.5100	0.5000	0.5500	5.8350	10200.00	0.00	10200.00	200	5	2200	8703	0.252786395495806	1.18696318265111	1.18696318265111	false	false	false	true
943db3a5-50ed-4d72-aa42-00a46df623a3	2026-09-08 15:14	2026-09-08 15:13	2026-09-08 15:13	OPEN	OPEN280121P00003000	put	3.0000	2028-01-21	1.1000	1.0500	1.1000	3.1050	55000.00	55000.00	0.00	500	13	1250	1065	1.17370892018779	0.93730322733111	0.93730322733111	false	false	false	true
670691d0-4719-49de-a452-a4392928ba8d	2026-09-08 15:03	2026-09-08 15:03	2026-09-08 15:03	GEO	GEO270115C00031000	call	31.0000	2027-01-15	4.5000	4.4000	4.7000	31.8500	157950.00	53550.00	900.00	351	6	354	344	1.02906976744186	0.518800073491689	0.518800073491689	false	false	false	true
6c082e07-910a-4278-9dc0-7e12ca4d940f	2026-09-08 15:02	2026-09-08 15:02	2026-09-08 15:02	FRMI	FRMI270115P00005000	put	5.0000	2027-01-15	1.0000	0.9000	1.0000	5.8726	33300.00	33300.00	0.00	333	21	395	14314	0.027595361184854	1.13552276588446	1.13380029433607	false	false	false	true
4ff0a7e8-85ff-428f-ab4b-f46cbfb6d682	2026-09-08 14:47	2026-09-08 14:47	2026-09-08 14:47	AGNC	AGNC270115P00010000	put	10.0000	2027-01-15	0.3400	0.3200	0.3400	10.7350	17000.00	17000.00	0.00	500	5	1051	19411	0.0541445572098295	0.283463680878296	0.283463680878296	false	false	false	true
ee1cb5ef-3754-4354-8dba-fb767cd69e73	2026-09-08 14:20	2026-09-08 14:20	2026-09-08 14:20	GEO	GEO261120C00032000	call	32.0000	2026-11-20	3.2000	3.0000	3.4000	31.9300	17280.00	12480.00	1600.00	54	9	60	343	0.174927113702624	0.549849667654639	0.549849667654639	true	false	false	true
5f4d53f3-6f45-47e9-b80c-eb0334d7ee08	2026-09-08 14:11	2026-09-08 14:11	2026-09-08 14:11	OPEN	OPEN280121C00010000	call	10.0000	2028-01-21	0.5400	0.5100	0.5400	3.1050	13500.00	13500.00	0.00	250	8	575	45033	0.0127684142739769	1.01246405399288	1.01246405399288	false	false	false	true
8954ce23-e036-49ce-810b-f449f63c1a2e	2026-09-08 13:09	2026-09-08 13:09	2026-09-08 13:09	GEO	GEO270115C00040000	call	40.0000	2027-01-15	1.4300	1.3500	1.4500	31.5500	19065.00	18785.00	140.00	133	14	179	9793	0.0182783620953742	0.513648155802458	0.505717748429957	false	false	false	true
3e39f858-04bc-4a5e-b133-6d5905a7631c	2026-09-08 13:09	2026-09-08 13:09	2026-09-08 13:09	GEO	GEO270115C00040000	call	40.0000	2027-01-15	1.4400	1.4000	1.4500	31.6350	32199.00	32199.00	0.00	223	9	402	9793	0.04104972939855	0.50671887488714	0.509870570562753	false	false	false	true
142c1061-3526-4e3a-bd97-39ff1e9b6b7d	2026-09-08 12:51	2026-09-08 12:51	2026-09-08 12:51	OPEN	OPEN280121C00003000	call	3.0000	2028-01-21	1.3600	1.3600	1.4000	3.1201	27744.00	0.00	27744.00	204	8	387	3794	0.102003162888772	0.911762542708795	0.911762542708795	false	false	false	true
f7f3038a-b5ce-4a55-93b6-3a5b7942926d	2026-09-08 12:39	2026-09-08 12:39	2026-09-08 12:39	CXW	CXW260918C00031000	call	31.0000	2026-09-18	4.0000	3.9000	4.3000	34.8800	24375.00	0.00	12775.00	61	8	61	209	0.291866028708134	0.364930103264533	0.494883779094973	false	false	false	true
a083119e-780c-45cc-a035-82893b2162f5	2026-09-08 12:30	2026-09-08 12:30	2026-09-08 12:30	OPEN	OPEN280121C00004000	call	4.0000	2028-01-21	1.1200	1.0800	1.1400	3.1150	22400.00	19712.00	2688.00	200	5	310	11783	0.0263090893660358	0.932202842571692	0.932202842571692	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
a9ddde04-ceb1-47b9-8cb1-4010de7e5444	2026-09-08 12:15	2026-09-08 12:15	2026-09-08 12:15	FRMI	FRMI261218C00005000	call	5.0000	2026-12-18	1.6900	1.4500	1.8000	5.7750	25324.00	25324.00	0.00	150	9	172	1542	0.111543450064851	1.12372043971877	1.12372043971877	false	false	false	true
3daf3d17-b630-4fb6-a6c5-22b3385c60fa	2026-09-08 12:03	2026-09-08 12:03	2026-09-08 12:03	CSGP	CSGP260918C00030000	call	30.0000	2026-09-18	0.8500	0.7500	0.8500	29.6650	16235.00	16235.00	0.00	191	20	211	375	0.562666666666667	0.5052799315993	0.5052799315993	false	false	false	true
14905f21-4e1d-4cac-b500-48c2c6ea7aa5	2026-09-08 12:02	2026-09-08 12:01	2026-09-08 12:01	FRMI	FRMI261016C00005000	call	5.0000	2026-10-16	1.1600	1.1500	1.3000	5.7900	18025.00	0.00	18025.00	155	7	263	915	0.287431693989071	0.970681710625158	1.03601433585135	false	false	false	true
b4d44d22-2b66-47d9-ad1f-8af9bfe77875	2026-09-08 12:01	2026-09-08 12:01	2026-09-08 12:01	CXW	CXW260918C00035000	call	35.0000	2026-09-18	0.9000	0.8500	1.0000	34.7800	31500.00	6660.00	18540.00	350	5	507	6010	0.0843594009983361	0.429640595450014	0.429640595450014	false	false	false	true
6f1f842c-dd5c-44f5-a26c-62f73dca5ab6	2026-09-08 12:00	2026-09-08 12:00	2026-09-08 12:00	CXW	CXW260918C00035000	call	35.0000	2026-09-18	0.9500	0.9000	1.0000	34.8700	14250.00	3040.00	2470.00	150	5	157	6010	0.0261231281198003	0.432129057946706	0.432129057946706	false	false	false	true
8a1ff645-c01b-4bf6-aacb-4a5c717f9839	2026-09-08 11:49	2026-09-08 11:49	2026-09-08 11:49	OPEN	OPEN280915P00003000	put	3.0000	2028-09-15	1.2500	1.2500	1.2800	3.1299	25000.00	0.00	25000.00	200	11	205	739	0.277401894451962	0.923693013256407	0.923693013256407	false	false	false	true
1fa79c23-525c-4d53-ba45-0724f2d576d0	2026-09-08 11:37	2026-09-08 11:37	2026-09-08 11:37	CSGP	CSGP260918P00030000	put	30.0000	2026-09-18	1.0000	0.9500	1.0500	29.8600	13301.00	1100.00	10701.00	133	6	3652	5161	0.707614803332687	0.483374758884145	0.4783030511705	false	false	false	true
09755f52-af24-44ad-b517-3a1ab809d1d4	2026-09-08 11:33	2026-09-08 11:32	2026-09-08 11:32	FRMI	FRMI260918C00005000	call	5.0000	2026-09-18	0.8500	0.7500	0.9500	5.7150	12750.00	0.00	10880.00	150	5	770	1493	0.515740120562626	1.10099553186773	1.10099553186773	false	false	false	true
6c80a7b6-afd7-44f7-8106-86d7e418d300	2026-09-08 11:16	2026-09-08 11:16	2026-09-08 11:16	BXP	BXP261016C00067500	call	67.5000	2026-10-16	2.0700	1.2000	3.0000	66.6300	318780.00	0.00	318780.00	1540	2	1540	70	22	0.27358863755895	0.27358863755895	false	true	true	false
be65f0cd-838c-4c0c-b7f5-19b64ca6072a	2026-09-08 11:01	2026-09-08 11:01	2026-09-08 11:01	EQIX	EQIX261016P01120000	put	1120.0000	2026-10-16	86.2000	81.0000	86.2000	1044.4650	422380.00	422380.00	0.00	49	18	49	0	0	0.29779172232222	0.29779172232222	false	false	false	true
1c9f9437-9180-4bde-9459-ddb6f9225ab0	2026-09-08 10:54	2026-09-08 10:54	2026-09-08 10:54	CSGP	CSGP260918P00030000	put	30.0000	2026-09-18	0.7500	0.7000	0.9500	30.1900	148350.00	450.00	147900.00	1978	12	3090	5161	0.598721178066266	0.431069658141382	0.431069658141382	false	false	false	true
2bd54c2f-9f45-4d86-85b5-4eb1556d77d2	2026-09-08 10:53	2026-09-08 10:53	2026-09-08 10:53	CSGP	CSGP260918P00030000	put	30.0000	2026-09-18	0.7500	0.7000	0.9500	30.1900	28500.00	20775.00	7575.00	380	18	973	5161	0.188529354776206	0.4321951438852	0.431069658141382	false	false	false	true
a202206e-c470-47e1-a799-e2693737ed28	2026-09-08 10:53	2026-09-08 10:53	2026-09-08 10:53	CSGP	CSGP260918P00030000	put	30.0000	2026-09-18	0.7500	0.7000	0.9500	30.1800	28950.00	16650.00	12300.00	386	25	592	5161	0.114706452237938	0.442236921450977	0.428812678800034	true	false	false	true
857021a7-1694-4648-8925-413a520fd8ac	2026-09-08 10:48	2026-09-08 10:48	2026-09-08 10:48	GEO	GEO270115C00027000	call	27.0000	2027-01-15	6.2700	6.0000	6.6000	31.0500	31338.00	0.00	25038.00	50	15	50	1792	0.0279017857142857	0.528207070544758	0.528207070544758	false	false	false	true
930c523e-7ce6-4b54-a4cd-8372c2ccd6fb	2026-09-08 10:14	2026-09-08 10:14	2026-09-08 10:14	WY	WY280121C00030000	call	30.0000	2028-01-21	1.0500	0.9500	1.4000	22.8250	40425.00	12600.00	27825.00	385	28	385	1159	0.332182916307161	0.255158169379595	0.255158169379595	true	false	false	true
ed2972b5-2b2f-4b92-b1cb-bbbf0e0d61ec	2026-09-08 10:12	2026-09-08 10:11	2026-09-08 10:11	OPEN	OPEN280121P00003000	put	3.0000	2028-01-21	1.0500	1.0400	1.1500	3.1197	10483.00	0.00	10483.00	100	5	749	1065	0.703286384976526	0.890376068547541	0.90701592648759	false	false	false	true
46090efc-0500-4e50-a025-c5d0383ae743	2026-09-08 10:06	2026-09-08 10:06	2026-09-08 10:06	WY	WY280121C00025000	call	25.0000	2028-01-21	2.2100	1.7500	2.5000	22.8000	18783.00	18783.00	0.00	85	10	85	878	0.0968109339407745	0.241724825106074	0.241724825106074	false	false	false	true
424b2fd0-d245-4e84-932a-49ef980043ca	2026-09-08 09:55	2026-09-08 09:55	2026-09-08 09:55	OPEN	OPEN280915C00007000	call	7.0000	2028-09-15	1.0000	0.9800	1.0400	3.1050	20000.00	17400.00	2600.00	200	15	1012	16912	0.0598391674550615	0.949201791719464	0.949201791719464	false	false	false	true
550de3a9-79c7-4c30-a7b4-b31fe928c04e	2026-09-08 09:49	2026-09-08 09:49	2026-09-08 09:49	GEO	GEO270319P00033000	put	33.0000	2027-03-19	5.3000	4.9000	5.3000	31.2900	30738.00	30738.00	0.00	58	5	115	2	57.5	0.522030926688533	0.523141738520008	false	false	false	true
1ad52bf5-4769-480d-b13e-cd7fa1adab65	2026-09-08 09:36	2026-09-08 09:36	2026-09-08 09:36	RITM	RITM270219C00009000	call	9.0000	2027-02-19	1.2000	1.2000	1.5000	10.1009	300296.00	0.00	300296.00	2500	31	2500	2535	0.986193293885602	0.271693256826847	0.248942738811966	true	false	false	true
f732ae44-315a-4f69-a03c-74f54941ea95	2026-09-04 15:49	2026-09-04 15:49	2026-09-04 15:49	WELL	WELL260918C00240000	call	240.0000	2026-09-18	2.8500	2.8500	3.0000	236.5000	50445.00	0.00	50445.00	177	34	1133	1301	0.87086856264412	0.227922513274766	0.227922513274766	false	false	false	true
e3cb1bcc-5c2c-4de6-a754-6845df22b1af	2026-09-04 15:35	2026-09-04 15:35	2026-09-04 15:35	GEO	GEO261120C00035000	call	35.0000	2026-11-20	1.9000	1.8000	1.9000	31.7000	53580.00	53580.00	0.00	282	20	283	2353	0.12027199320017	0.524660369000994	0.524660369000994	false	false	false	true
9ac6708b-02f6-40bc-83f3-a42f35351ae5	2026-09-04 15:25	2026-09-04 15:25	2026-09-04 15:25	FRMI	FRMI270115C00010000	call	10.0000	2027-01-15	0.6000	0.4500	1.2500	5.1699	67920.00	1200.00	3960.00	1132	5	10168	70816	0.143583370989607	1.28376323672974	1.28376323672974	false	false	false	true