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×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	expiry

c7f9c4fa-d2d5-465d-9593-6dff4e256cb2	2026-09-22 13:23	2026-09-22 13:23	2026-09-22 13:23	JOE	JOE261218C00070000	call	70.0000	2026-12-18	2.0000	1.9500	4.0000	65.9200	20016.00	4800.00	15216.00	100	10	105	65	1.61538461538462	0.260767200899954	0.260767200899954	true	false	false	true	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	Common Stock	Real Estate	3769365161.00	2026-11-04	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-22T17:23:35.118331Z"}	2026-09-22	2026-09-22 21:15	2026-09-22 21:15
ff5bbe84-3baa-4e92-8b66-34a12a4210b1	2026-09-22 10:01	2026-09-22 10:01	2026-09-22 10:01	IIPR	IIPR261218C00060000	call	60.0000	2026-12-18	1.7500	1.5500	2.1000	56.3900	14702.00	6825.00	7877.00	84	11	86	880	0.0977272727272727	0.25929133151403	0.268213700614461	true	false	false
b2cb6c0f-a69a-4ff9-86ed-4508b7d28c2b	2026-09-22 09:56	2026-09-22 09:56	2026-09-22 09:56	WELL	WELL261016P00240000	put	240.0000	2026-10-16	10.7200	10.5000	11.4000	230.8700	69710.00	9640.00	60070.00	65	9	101	523	0.193116634799235	0.225302089917424	0.230341623464301	false	false	false
11288563-04ee-4807-a3a1-f5260dc741ac	2026-09-21 14:14	2026-09-21 14:13	2026-09-21 14:13	STWD	STWD280121P00015000	put	15.0000	2028-01-21	2.2800	1.9500	2.3000	15.0750	108790.00	108790.00	0.00	477	15	666	1083	0.614958448753463	0.408866740198222	0.416609234386424	false	false	false
6be5017b-0282-45c1-94e8-b4c1fbfd2172	2026-09-21 13:02	2026-09-21 13:02	2026-09-21 13:02	CSGP	CSGP270115P00030000	put	30.0000	2027-01-15	3.5000	3.4000	3.5000	29.5150	88821.00	88821.00	0.00	254	20	255	2275	0.112087912087912	0.517540144363267	0.522102139492999	true	false	false
217e3f70-139c-444c-acde-2084a140d16b	2026-09-21 10:47	2026-09-21 10:47	2026-09-21 10:47	CXW	CXW261218C00037000	call	37.0000	2026-12-18	1.8700	1.8500	2.0000	33.5300	11206.00	0.00	11206.00	60	5	190	192	0.989583333333333	0.454309497053224	0.466169400274325	false	false	false	true
c2809f9d-d24b-4b51-8570-cf8cd097251a	2026-09-18 15:42	2026-09-18 15:42	2026-09-18 15:42	GEO	GEO280121C00045000	call	45.0000	2028-01-21	4.1700	4.0000	4.2000	31.6200	125035.00	122985.00	0.00	300	21	3435	8119	0.423081660302993	0.49992247216256	0.507346974128677	true	false	false
f5b3427f-a9e0-49a5-a878-1d55724c5fcf	2026-09-18 14:08	2026-09-18 14:08	2026-09-18 14:08	CCI	CCI261218P00080000	put	80.0000	2026-12-18	8.6400	8.6000	8.7000	73.7000	21591.00	0.00	17266.00	25	6	150	350	0.428571428571429	0.360023608277637	0.360023608277637	false	false	false	true
e1ea7866-4556-470a-b2b2-a6190f832134	2026-09-18 09:46	2026-09-18 09:46	2026-09-18 09:46	CXW	CXW261016C00040000	call	40.0000	2026-10-16	0.7000	0.4000	0.7000	36.3950	20981.00	20981.00	0.00	300	6	325	526	0.61787072243346	0.462303869968816	0.468426001318603	false	false	false	true
619b0847-a752-445b-9c65-06a6017a1539	2026-09-17 15:06	2026-09-17 15:06	2026-09-17 15:06	WELL	WELL260918C00220000	call	220.0000	2026-09-18	12.8900	11.4000	14.0000	232.6600	116034.00	116034.00	0.00	90	5	107	339	0.315634218289086	0.685578260423503	0.685578260423503	false	false	false
0303bdfc-0655-4e0c-b428-bd510a222f93	2026-09-15 14:51	2026-09-15 14:51	2026-09-15 14:51	FRMI	FRMI261120C00006000	call	6.0000	2026-11-20	0.5300	0.5000	0.5500	4.7050	13104.00	13104.00	0.00	245	6	954	10011	0.0952951753071621	1.16457153463856	1.16457153463856	false	false	false
a3cd8dd9-da55-4d51-8f01-493acd6a43f3	2026-09-15 14:24	2026-09-15 14:24	2026-09-15 14:24	WELL	WELL261016P00250000	put	250.0000	2026-10-16	18.2000	17.9000	18.5000	232.4300	387573.00	40040.00	347533.00	213	45	620	520	1.19230769230769	0.23375669496271	0.243999008646456	false	false	false
5251bc49-75ca-4521-97cd-9ed3410c0dbe	2026-09-14 10:07	2026-09-14 10:06	2026-09-14 10:06	CBRE	CBRE260918C00140000	call	140.0000	2026-09-18	2.6000	2.2000	3.1000	140.6150	116495.00	0.00	116495.00	448	37	771	2837	0.271765949947127	0.383657188751795	0.383657188751795	false	false	false
a5030405-5098-4a85-9456-e9deeb41064e	2026-09-11 15:12	2026-09-11 15:11	2026-09-11 15:11	CBRE	CBRE260918C00140000	call	140.0000	2026-09-18	3.0000	3.0000	3.5000	140.9100	18330.00	930.00	17400.00	61	14	67	3349	0.02000597193192	0.316949104466481	0.330386598940626	false	false	false
02108bf0-8fef-4042-a68a-6b814f6057df	2026-09-11 11:12	2026-09-11 11:11	2026-09-11 11:11	WELL	WELL261016P00250000	put	250.0000	2026-10-16	16.8300	16.4000	16.9000	234.7500	57210.00	15210.00	3360.00	34	14	60	270	0.222222222222222	0.254965923018713	0.259378448446591	false	false	false
7e4494b2-e028-43ca-abc2-247fbd98d954	2026-09-11 10:58	2026-09-11 10:58	2026-09-11 10:58	OHI	OHI270115P00047000	put	47.0000	2027-01-15	2.3600	2.3500	2.5000	47.1700	11781.00	0.00	11781.00	50	8	62	144	0.430555555555556	0.247247709418438	0.248167467136147	false	false	false	true
50976efe-0806-4c93-a5c2-44e3ab817c97	2026-09-10 13:39	2026-09-10 13:39	2026-09-10 13:39	WELL	WELL270319P00220000	put	220.0000	2027-03-19	8.5200	8.4000	8.9000	236.0675	74960.00	39260.00	35700.00	88	5	218	302	0.721854304635762	0.260747892441779	0.267708927915376	false	false	false
df515675-c2b5-4824-8ea6-64e4b91662ca	2026-09-10 13:38	2026-09-10 13:38	2026-09-10 13:38	WELL	WELL270319C00240000	call	240.0000	2027-03-19	16.4100	16.4000	18.2000	236.1100	100130.00	0.00	100130.00	61	18	165	234	0.705128205128205	0.232799158012011	0.234280556216623	true	false	false
40db7928-70e4-4f2b-92fe-6ef8d15ced09	2026-09-10 13:38	2026-09-10 13:38	2026-09-10 13:38	WELL	WELL270319P00220000	put	220.0000	2027-03-19	8.3200	8.1000	9.5000	236.1100	106520.00	3560.00	102960.00	128	30	130	302	0.43046357615894	0.257458043907764	0.267917577834165	true	false	false
f11155f5-be6a-470b-81dd-248b3be761e1	2026-09-10 13:37	2026-09-10 13:36	2026-09-10 13:36	WELL	WELL270521P00230000	put	230.0000	2027-05-21	13.5800	13.4000	15.0000	236.1100	119530.00	44160.00	75370.00	88	16	88	183	0.480874316939891	0.250335740538002	0.255791647050659	true	false	false
7e4c7427-8c23-4328-acd7-c1b7b6b50f1f	2026-09-10 13:37	2026-09-10 13:36	2026-09-10 13:36	WELL	WELL270521P00220000	put	220.0000	2027-05-21	10.4500	9.8000	11.3000	236.1100	96110.00	41180.00	54930.00	92	16	92	1226	0.0750407830342577	0.253955992387651	0.259964650019573	true	false	false
e2ced37e-94f0-4e76-a7e5-9a6539c11090	2026-09-10 13:00	2026-09-10 13:00	2026-09-10 13:00	GEO	GEO261120P00032000	put	32.0000	2026-11-20	3.3300	3.3000	3.4000	31.0000	16672.00	0.00	16672.00	50	6	64	165	0.387878787878788	0.560290107858377	0.560290107858377	false	false	false	true
6de8ef10-6f0b-48da-a0ba-6686ed4401ad	2026-09-09 15:25	2026-09-09 15:24	2026-09-09 15:24	CCI	CCI260918C00075000	call	75.0000	2026-09-18	1.2200	1.2000	1.6500	75.2100	14000.00	0.00	14000.00	115	7	4668	5257	0.887958911926955	0.220563360371519	0.234797228431762	true	false	false
eafaa9b7-db10-434d-b1af-21e1f8e5e8fa	2026-09-09 15:24	2026-09-09 15:24	2026-09-09 15:24	CCI	CCI260918C00075000	call	75.0000	2026-09-18	1.2500	1.2000	1.5500	75.3800	110290.00	71640.00	38525.00	881	30	3067	5257	0.583412592733498	0.214287248986136	0.214287248986136	false	false	false
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
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
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
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
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
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
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
5b4c47df-7b46-40db-9f5b-b126f2d84c23	2026-09-04 14:11	2026-09-04 14:10	2026-09-04 14:10	AGNC	AGNC270115C00010000	call	10.0000	2027-01-15	0.8200	0.8100	0.9000	10.6800	16339.00	0.00	16339.00	200	18	200	8563	0.0233563003620227	0.144657235864761	0.0779410469666412	false	false	false
d150d7de-5c78-4dae-a9e4-58581f0b961d	2026-09-03 15:47	2026-09-03 15:47	2026-09-03 15:47	RYN	RYN270115C00017500	call	17.5000	2027-01-15	3.0000	3.0000	3.1000	20.2750	75400.00	0.00	75400.00	251	6	343	445	0.770786516853933	0.185174934161877	0.185174934161877	false	false	false
c1c3cc51-2fb7-457b-a1ea-90f18b54c49c	2026-09-03 14:38	2026-09-03 14:38	2026-09-03 14:38	AMT	AMT261120P00170000	put	170.0000	2026-11-20	5.2000	4.9000	6.0000	178.8600	197620.00	1060.00	196560.00	380	25	383	13	29.4615384615385	0.295732205517799	0.299166049651267	false	false	false
dd5a300c-3955-4724-b15b-a934663352b0	2026-09-02 15:37	2026-09-02 15:37	2026-09-02 15:37	OPEN	OPEN270115C00004000	call	4.0000	2027-01-15	0.4000	0.3600	0.4200	3.0650	40268.00	40268.00	0.00	1000	32	1252	9786	0.127937870427141	0.909177503531147	0.936452641505996	true	false	false
7bdaa028-2f9f-416b-ac8f-7325d65165bd	2026-09-02 14:23	2026-09-02 14:23	2026-09-02 14:23	GEO	GEO280121C00045000	call	45.0000	2028-01-21	3.7000	3.4000	3.7000	30.3900	66598.00	66598.00	0.00	180	7	400	5139	0.0778361548939482	0.499754912884244	0.499754912884244	false	false	false
1e9113e8-3e49-4f87-a1b9-7167447ee5cd	2026-09-02 11:25	2026-09-02 11:25	2026-09-02 11:25	FRMI	FRMI280121C00022000	call	22.0000	2028-01-21	0.5500	0.5500	0.6000	4.5350	52703.00	58.00	52645.00	958	33	960	11603	0.0827372231319486	1.04578928754831	1.04578928754831	true	false	false
85534d0d-bdfd-471e-bd1b-7194b1742386	2026-09-02 09:57	2026-09-02 09:56	2026-09-02 09:56	VICI	VICI261218P00027500	put	27.5000	2026-12-18	2.7000	2.7000	2.8500	25.4001	10272.00	0.00	10272.00	38	8	55	2096	0.0262404580152672	0.29258452020118	0.296453965102601	false	false	false
993b7a18-c942-43b4-ba0c-f7e7a5f3cacb	2026-09-01 15:52	2026-09-01 15:52	2026-09-01 15:52	FRMI	FRMI261002P00004500	put	4.5000	2026-10-02	0.4500	0.4000	0.5000	4.6150	24918.00	3228.00	9000.00	556	11	1445	316	4.57278481012658	0.932710473709865	0.971084165777245	false	false	false
fcb9efc2-c587-4773-99fd-7c16f8af3b3b	2026-09-01 12:29	2026-09-01 12:29	2026-09-01 12:29	SPG	SPG261120P00210000	put	210.0000	2026-11-20	7.8000	7.8000	8.3000	212.5600	60080.00	0.00	59290.00	77	26	79	0	0	0.250140716369495	0.250140716369495	false	false	false	true
2a9d3383-7eb3-4633-9a47-f3517d3f3bcf	2026-08-31 15:20	2026-08-31 15:20	2026-08-31 15:20	VICI	VICI270319P00025000	put	25.0000	2027-03-19	1.5000	1.5000	1.6000	25.7250	16055.00	0.00	16055.00	107	19	122	632	0.193037974683544	0.281459358263226	0.281459358263226	false	false	false
c220e9d4-4140-454e-b075-6efe7e6f5274	2026-08-31 09:49	2026-08-31 09:49	2026-08-31 09:49	IRM	IRM261218P00110000	put	110.0000	2026-12-18	6.4600	6.3000	6.6000	114.5000	29050.00	16890.00	0.00	45	34	88	107	0.822429906542056	0.370559697531524	0.37482854696223	false	false	false	true
5f830812-87cc-4824-bf3a-54f5379c0526	2026-08-31 09:49	2026-08-31 09:49	2026-08-31 09:49	IRM	IRM261218P00110000	put	110.0000	2026-12-18	6.4100	6.1000	6.8000	114.5000	24350.00	6460.00	640.00	38	38	43	107	0.401869158878505	0.366288124637283	0.37482854696223	false	false	false	true
0e242ff8-b539-4ec6-8d29-d58c97b3873f	2026-08-28 14:13	2026-08-28 14:13	2026-08-28 14:13	OPEN	OPEN270219C00005000	call	5.0000	2027-02-19	0.4300	0.4000	0.4400	3.3150	53518.00	22396.00	0.00	1250	8	1391	4192	0.331822519083969	0.930158302426743	0.952844140235226	false	false	false
b8251302-a5c0-45de-a605-1c322c5b688f	2026-08-28 12:45	2026-08-28 12:45	2026-08-28 12:45	PLD	PLD261120P00130000	put	130.0000	2026-11-20	2.2500	2.2500	2.4500	140.7300	327619.00	0.00	327619.00	1456	51	1456	438	3.32420091324201	0.253970664903334	0.253970664903334	false	false	false
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
70f3039c-38fc-40cb-b4c5-4a8a23a8f331	2026-08-28 09:36	2026-08-28 09:36	2026-08-28 09:36	BEKE	BEKE261016P00018000	put	18.0000	2026-10-16	0.7000	0.6000	0.7000	18.4360	42050.00	42050.00	0.00	601	37	601	5027	0.119554406206485	0.35061559451877	0.354485666486382	false	false	false
690d5eee-6b38-4f96-9143-2dd2595a0092	2026-08-28 09:33	2026-08-28 09:33	2026-08-28 09:33	RITM	RITM260918P00011000	put	11.0000	2026-09-18	0.9000	0.9000	0.9500	10.1000	22596.00	94.00	22502.00	251	12	367	2688	0.136532738095238	0.250693393913111	0.250693393913111	false	false	false
06badad6-4403-42f7-ad7f-ddf67f75f012	2026-08-27 15:57	2026-08-27 15:56	2026-08-27 15:56	VICI	VICI260918P00025000	put	25.0000	2026-09-18	0.2500	0.2000	0.2500	25.7750	22880.00	22814.00	66.00	917	28	1531	3797	0.40321306294443	0.216024208893686	0.216024208893686	false	false	false