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

83787fe0-3bd4-4a0c-9548-1a03679c5b2e	2026-09-22 15:37	2026-09-22 15:37	2026-09-22 15:37	WPC	WPC270115C00070000	call	70.0000	2027-01-15	1.3500	1.2500	1.3500	67.1900	13500.00	13500.00	0.00	100	9	992	286	3.46853146853147	0.142018889436809	0.141622512079299	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Real Estate	15238671036.00	2026-10-27	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-22T19:40:59.804437Z"}	2026-09-22	2026-09-22 21:15	2026-09-22 21:15
81e63318-8ea3-49b2-be68-b8897490363c	2026-09-22 15:21	2026-09-22 15:21	2026-09-22 15:21	PSA	PSA261016P00280000	put	280.0000	2026-10-16	2.9000	2.9000	3.9000	290.3000	126730.00	0.00	6090.00	437	19	447	64	6.984375	0.243484609218997	0.243484609218997	false	false	false	true
0eaa3e9d-70de-47b8-8630-c078e520375f	2026-09-22 15:10	2026-09-22 15:10	2026-09-22 15:10	PLD	PLD261016C00140000	call	140.0000	2026-10-16	1.7000	1.6000	1.7000	135.4217	34000.00	34000.00	0.00	200	22	246	996	0.246987951807229	0.241700932491473	0.241700932491473	false	false	false	true
9447e9c2-019b-4809-9283-acb17461f9e7	2026-09-22 15:01	2026-09-22 15:01	2026-09-22 15:01	O	O280121P00057500	put	57.5000	2028-01-21	5.3000	5.3000	5.4000	56.6450	26500.00	0.00	26500.00	50	14	101	538	0.187732342007435	0.258319896312244	0.258319896312244	false	false	false	true
6785842c-6d9e-457c-a97c-dc50ae7e32c7	2026-09-22 14:57	2026-09-22 14:57	2026-09-22 14:57	BXP	BXP261120C00075000	call	75.0000	2026-11-20	0.3000	0.1000	0.3500	63.8550	30161.00	29801.00	360.00	1006	40	1122	4479	0.250502344273275	0.279926425999507	0.279162832657385	false	false	false	true
50de49fd-2f6d-4800-9880-f708d733f519	2026-09-22 14:34	2026-09-22 14:34	2026-09-22 14:34	WELL	WELL261218C00270000	call	270.0000	2026-12-18	1.3500	1.2000	1.3500	230.9250	58185.00	5535.00	0.00	431	35	838	775	1.08129032258065	0.234338897916295	0.234338897916295	false	false	false	true
3a5f7659-2a40-4e8c-95f7-d876cb85fd2f	2026-09-22 14:30	2026-09-22 14:30	2026-09-22 14:30	OHI	OHI261120P00044000	put	44.0000	2026-11-20	0.8500	0.8500	1.2000	46.4883	26350.00	0.00	25500.00	310	15	317	10	31.7	0.266946359280081	0.266946359280081	false	false	false	true
e67ebfbd-9d07-4a9f-bdfc-6561d93d575a	2026-09-22 14:17	2026-09-22 14:16	2026-09-22 14:16	O	O261120P00055000	put	55.0000	2026-11-20	0.9000	0.8500	0.9500	56.6150	17460.00	14400.00	0.00	194	5	270	233	1.1587982832618	0.191750298148855	0.191750298148855	false	false	false	true
3157f17d-5bb6-49ef-b9f5-fee515b5d3e0	2026-09-22 14:04	2026-09-22 14:04	2026-09-22 14:04	CBRE	CBRE261016P00135000	put	135.0000	2026-10-16	2.4500	2.4500	2.8000	141.3200	35770.00	0.00	35770.00	146	27	149	97	1.5360824742268	0.362027793596107	0.362027793596107	false	false	false	true
5f78af89-96dc-48ec-9025-978bf2a3162c	2026-09-22 14:03	2026-09-22 14:03	2026-09-22 14:03	CBRE	CBRE261218C00145000	call	145.0000	2026-12-18	8.5000	8.5000	8.8000	141.0650	19550.00	0.00	850.00	23	13	23	18	1.27777777777778	0.350348599716561	0.350348599716561	false	false	false	true
ec970f91-028c-44ab-8f2d-be0ece3cfa10	2026-09-22 13:50	2026-09-22 13:50	2026-09-22 13:50	FRMI	FRMI270219C00009000	call	9.0000	2027-02-19	0.5500	0.5000	0.6500	5.0950	11000.00	1210.00	9790.00	200	6	200	326	0.613496932515337	1.08618121547493	1.08618121547493	false	false	false	true
beb6864f-8448-4e70-8c1e-07b5f83bef94	2026-09-22 13:33	2026-09-22 13:32	2026-09-22 13:32	DEI	DEI261120C00011000	call	11.0000	2026-11-20	0.3500	0.2500	0.3500	10.0000	31255.00	31255.00	0.00	893	7	897	1250	0.7176	0.340480809829238	0.340480809829238	false	false	false	true
13664d98-ca35-4c88-aa9a-e3f12f94e716	2026-09-22 13:24	2026-09-22 13:24	2026-09-22 13:24	FRMI	FRMI270115P00004000	put	4.0000	2027-01-15	0.5500	0.5000	0.5500	5.1150	16500.00	16500.00	0.00	300	6	562	10620	0.0529190207156309	1.03578177688459	1.03578177688459	false	false	false	true
e9fb388f-a6e6-44b5-96dd-02665630e14a	2026-09-22 13:17	2026-09-22 13:17	2026-09-22 13:17	EQIX	EQIX261016P00990000	put	990.0000	2026-10-16	8.6000	8.5000	9.7000	1051.8850	30960.00	860.00	30100.00	36	13	38	14	2.71428571428571	0.293771464348654	0.293771464348654	false	false	false	true
ba7422c7-011c-42f2-9b53-f5de9835add5	2026-09-22 13:17	2026-09-22 13:17	2026-09-22 13:17	EQIX	EQIX261016P00980000	put	980.0000	2026-10-16	6.9000	6.9000	8.9000	1051.8850	26220.00	0.00	26220.00	38	14	39	21	1.85714285714286	0.297176672735797	0.297176672735797	false	false	false	true
4b58f0d4-8d60-40a7-b7c3-2b3fe1413dd1	2026-09-22 12:42	2026-09-22 12:41	2026-09-22 12:41	JOE	JOE261120C00065000	call	65.0000	2026-11-20	3.5000	3.4000	4.2000	65.9400	25200.00	2100.00	23100.00	72	13	200	101	1.98019801980198	0.263969092843605	0.263969092843605	true	false	false	true
55df1789-22b0-4dc4-a5e4-89dbda62220a	2026-09-22 12:26	2026-09-22 12:26	2026-09-22 12:26	GEO	GEO261120P00031000	put	31.0000	2026-11-20	3.4000	3.3000	3.4000	29.7100	325040.00	325040.00	0.00	956	35	957	185	5.17297297297297	0.58343752465996	0.58343752465996	false	false	false	true
51588e19-161b-4361-ae4d-3dc9dc8b1077	2026-09-22 12:26	2026-09-22 12:26	2026-09-22 12:26	GEO	GEO261120P00029000	put	29.0000	2026-11-20	2.3000	2.2500	2.3000	29.7100	18400.00	18400.00	0.00	80	14	81	123	0.658536585365854	0.582470379602384	0.582470379602384	false	false	false	true
dcf321c2-54b2-4ef3-b4cc-4197bddeb395	2026-09-22 12:05	2026-09-22 12:05	2026-09-22 12:05	OPEN	OPEN271217C00004000	call	4.0000	2027-12-17	0.8700	0.8500	0.8700	2.7450	85260.00	85260.00	0.00	980	16	1401	3293	0.425447919829942	0.965813507636859	0.965813507636859	true	false	false	true
e61dab50-4986-40f6-a6fb-75f553cbe8f1	2026-09-22 11:19	2026-09-22 11:19	2026-09-22 11:19	JOE	JOE261120C00065000	call	65.0000	2026-11-20	3.5000	3.4000	3.5000	65.5000	23100.00	16800.00	0.00	66	5	83	101	0.821782178217822	0.288964707341027	0.288964707341027	false	false	false	true
9789331a-328e-47ac-a693-bbf39c964ab3	2026-09-22 11:09	2026-09-22 11:09	2026-09-22 11:09	VICI	VICI280121P00022500	put	22.5000	2028-01-21	1.8500	1.7000	2.0000	23.0000	46250.00	10915.00	35335.00	250	27	300	484	0.619834710743802	0.2981747082293	0.2981747082293	false	false	false	true
b68fb356-b0fd-4ee5-b09c-fb246f0be413	2026-09-22 10:51	2026-09-22 10:51	2026-09-22 10:51	NLY	NLY260925C00021500	call	21.5000	2026-09-25	0.1300	0.1300	0.1700	21.4300	10153.00	0.00	10153.00	781	22	1015	1394	0.728120516499283	0.205519369824499	0.205519369824499	false	false	false	true
2a25fcc6-08b3-4cae-85fc-f79dba47b706	2026-09-22 10:42	2026-09-22 10:42	2026-09-22 10:42	CCI	CCI270917C00082500	call	82.5000	2027-09-17	4.9000	4.9000	5.5000	72.9800	10780.00	0.00	10780.00	22	6	25	446	0.0560538116591928	0.250397118947004	0.250397118947004	false	false	false	true
1394de13-d4b7-4196-9790-a9d3593d3e0b	2026-09-22 10:24	2026-09-22 10:23	2026-09-22 10:23	CBRE	CBRE261120P00130000	put	130.0000	2026-11-20	3.6000	3.6000	3.8000	140.0000	46085.00	0.00	46085.00	128	30	184	0	0	0.378401917038262	0.378401917038262	false	false	false	true
5dfe9a06-a15e-4b93-b76c-ea48ecf34795	2026-09-22 10:08	2026-09-22 10:08	2026-09-22 10:08	EPR	EPR270115P00060000	put	60.0000	2027-01-15	5.1000	3.9000	5.1000	57.6600	15300.00	15300.00	0.00	30	7	30	37	0.810810810810811	0.3280518094865	0.3280518094865	false	false	false	true
002aa70a-697d-4c2c-aa69-15d15a486244	2026-09-22 09:58	2026-09-22 09:58	2026-09-22 09:58	VICI	VICI270319P00022500	put	22.5000	2027-03-19	0.7000	0.6500	0.7500	24.0600	16100.00	14280.00	1820.00	230	10	248	218	1.13761467889908	0.23347221786397	0.233956595311376	true	false	false	true
d0b5da5c-6200-441d-bd85-6f0f247b1afa	2026-09-22 09:56	2026-09-22 09:56	2026-09-22 09:56	WELL	WELL261016P00240000	put	240.0000	2026-10-16	10.6000	10.5000	11.2000	231.1400	30740.00	6360.00	7420.00	29	10	205	523	0.391969407265774	0.230020046201308	0.230020046201308	false	false	false	true
ef24482d-a4b5-45b1-9f95-805d8d7f4f7c	2026-09-22 09:56	2026-09-22 09:56	2026-09-22 09:56	WELL	WELL261016P00240000	put	240.0000	2026-10-16	11.0000	10.4000	11.0000	230.4950	39600.00	39600.00	0.00	36	7	36	523	0.0688336520076482	0.226663136771535	0.226663136771535	false	false	false	true
7228ffe3-4002-442c-9cc4-a8b5ec6ec112	2026-09-21 15:54	2026-09-21 15:54	2026-09-21 15:54	SBAC	SBAC261016P00175000	put	175.0000	2026-10-16	3.8000	3.5000	4.0000	176.0000	12540.00	12540.00	0.00	33	12	33	791	0.0417193426042984	0.257268349900734	0.257268349900734	true	false	false	true
de1f4091-79a6-4546-a1d3-ba936a954188	2026-09-21 15:54	2026-09-21 15:54	2026-09-21 15:54	CBRE	CBRE261016C00150000	call	150.0000	2026-10-16	2.2000	1.9500	2.2000	143.0000	16500.00	3520.00	0.00	75	5	2467	191	12.9162303664921	0.30979381532213	0.30979381532213	false	false	false	true
db58ce79-aa25-441c-be83-4f585faf1bf3	2026-09-21 15:29	2026-09-21 15:29	2026-09-21 15:29	OPEN	OPEN261218C00004000	call	4.0000	2026-12-18	0.1900	0.1600	0.1900	2.7099	19000.00	19000.00	0.00	1000	31	1179	5427	0.217247097844113	0.979729772353186	0.979729772353186	true	false	false	true
1b8c58be-a5e1-46fc-a278-d8b4d7c3f24f	2026-09-21 15:23	2026-09-21 15:23	2026-09-21 15:23	CBRE	CBRE270115C00160000	call	160.0000	2027-01-15	5.4000	5.4000	5.7000	142.7150	28080.00	0.00	22140.00	52	13	91	105	0.866666666666667	0.338329816079021	0.338329816079021	false	false	false	true
e0e19f3d-631c-49c4-aa0f-274775c84169	2026-09-21 14:44	2026-09-21 14:44	2026-09-21 14:44	WELL	WELL270115C00270000	call	270.0000	2027-01-15	2.5000	2.2000	2.9500	231.7900	35500.00	22500.00	13000.00	142	5	146	170	0.858823529411765	0.235390936984984	0.235390936984984	false	false	false	true
d241265f-b731-46c0-bb6b-f504e87aca38	2026-09-21 14:21	2026-09-21 14:21	2026-09-21 14:21	GEO	GEO261016C00031000	call	31.0000	2026-10-16	1.2000	1.1500	1.2500	30.1900	15360.00	13800.00	1560.00	128	7	830	546	1.52014652014652	0.487499223694356	0.481754565081306	false	false	false	true
2159599c-ed62-4a9c-b2fd-14fda3d0e5f7	2026-09-21 14:09	2026-09-21 14:09	2026-09-21 14:09	GEO	GEO261120P00028000	put	28.0000	2026-11-20	1.7000	1.6500	1.7500	30.0000	38080.00	37740.00	0.00	224	27	267	250	1.068	0.576836088985542	0.576836088985542	true	false	false	true
feea9509-bfc6-4c33-a1c2-55807406017e	2026-09-21 13:51	2026-09-21 13:51	2026-09-21 13:51	VICI	VICI261218P00025000	put	25.0000	2026-12-18	1.6000	1.5500	1.6000	23.9850	23840.00	18560.00	0.00	149	5	155	7292	0.0212561711464619	0.246771101836598	0.246771101836598	false	false	false	true
fc21f98f-da61-45be-a1a2-53d43681f01f	2026-09-21 13:32	2026-09-21 13:32	2026-09-21 13:32	WELL	WELL270319P00190000	put	190.0000	2027-03-19	4.0000	3.4000	4.0000	231.6700	309200.00	309200.00	0.00	773	6	1423	2	711.5	0.319200464278914	0.319200464278914	true	false	false	true
beb78acc-c8d4-457e-9f27-9f192cc1cd94	2026-09-21 13:30	2026-09-21 13:30	2026-09-21 13:30	WELL	WELL270521P00185000	put	185.0000	2027-05-21	4.7000	4.0000	4.7000	231.7100	49770.00	49770.00	0.00	106	19	106	1	106	0.32240143146439	0.32240143146439	true	false	false	true
f6d92fc7-bc6e-4881-8d49-eb7726b3be88	2026-09-21 13:27	2026-09-21 13:27	2026-09-21 13:27	WELL	WELL270319P00190000	put	190.0000	2027-03-19	3.6000	2.9500	3.6000	231.9500	87480.00	87480.00	0.00	243	29	360	2	180	0.308845568170991	0.308845568170991	true	false	false	true
2409c36e-dcf0-4bcc-87d1-da45b6b192b1	2026-09-21 13:18	2026-09-21 13:18	2026-09-21 13:18	IRM	IRM270115C00140000	call	140.0000	2027-01-15	1.8000	1.5000	1.8000	116.0000	14400.00	14400.00	0.00	80	8	83	225	0.368888888888889	0.306018390323483	0.306018390323483	false	false	false	true
eba20ad9-00fe-4e1b-a416-c69010523906	2026-09-21 13:09	2026-09-21 13:09	2026-09-21 13:09	NLY	NLY260925C00021500	call	21.5000	2026-09-25	0.1700	0.1200	0.1700	21.4150	17000.00	17000.00	0.00	1000	11	1505	729	2.06447187928669	0.229500576992961	0.229500576992961	false	false	false	true
0eb871d1-2075-48a5-a683-731f91aed6de	2026-09-21 12:55	2026-09-21 12:55	2026-09-21 12:55	IRM	IRM270115C00130000	call	130.0000	2027-01-15	3.5000	3.4000	3.8000	115.0000	28000.00	0.00	28000.00	80	5	87	211	0.412322274881517	0.299980249507868	0.299980249507868	false	false	false	true
cecd3ad8-406a-4e00-a7db-9a0e7893d030	2026-09-21 12:52	2026-09-21 12:52	2026-09-21 12:52	EXR	EXR261218P00125000	put	125.0000	2026-12-18	2.0500	2.0500	2.1000	137.0000	24395.00	0.00	24395.00	119	27	136	159	0.855345911949686	0.271749713111531	0.271749713111531	false	false	false	true
49b59cdb-ca3b-4886-a6cd-73c1625aa576	2026-09-21 12:45	2026-09-21 12:45	2026-09-21 12:45	RITM	RITM261218C00009000	call	9.0000	2026-12-18	0.7000	0.6000	0.7000	9.5050	35000.00	35000.00	0.00	500	5	532	162	3.28395061728395	0.176625130885805	0.176625130885805	false	false	false	true
73cc84be-237f-4102-b7cc-c6c6ded0901b	2026-09-21 12:39	2026-09-21 12:39	2026-09-21 12:39	SUI	SUI261016C00115000	call	115.0000	2026-10-16	1.5000	1.5000	1.9500	113.8700	38850.00	0.00	38850.00	259	24	343	35	9.8	0.156130914378371	0.157629665250944	false	false	false	true
3934898b-eba9-4e19-8d46-10cf95d9b2b4	2026-09-21 12:37	2026-09-21 12:37	2026-09-21 12:37	EQIX	EQIX261218C01160000	call	1160.0000	2026-12-18	25.7500	23.0000	29.1000	1053.1600	121030.00	0.00	121030.00	47	2	47	24	1.95833333333333	0.288784237187004	0.288784237187004	false	true	false	true
c3335ea0-ef75-411e-9550-456f115bad46	2026-09-21 12:35	2026-09-21 12:35	2026-09-21 12:35	AGNC	AGNC261023P00009500	put	9.5000	2026-10-23	0.1200	0.1200	0.1300	10.0200	14220.00	0.00	14220.00	1185	10	1260	888	1.41891891891892	0.282156220895857	0.282156220895857	false	false	false	true
3998a2f3-8698-4916-ad1c-d3bebf8ce565	2026-09-21 12:12	2026-09-21 12:12	2026-09-21 12:12	WELL	WELL261120P00230000	put	230.0000	2026-11-20	8.4000	8.1000	8.4000	232.5899	184794.00	184794.00	0.00	220	32	223	11	20.2727272727273	0.277359479102679	0.277359479102679	false	false	false	true
b87d8fc9-4961-48b2-a0ee-d659c7c5ae92	2026-09-21 12:03	2026-09-21 12:03	2026-09-21 12:03	O	O261016C00057500	call	57.5000	2026-10-16	0.7500	0.7000	0.7500	57.1600	21374.00	21374.00	0.00	285	26	1085	2093	0.518394648829431	0.140320251922181	0.140320251922181	false	false	false	true
29e7e53c-e351-4a7d-8a19-998390f42fd0	2026-09-21 11:52	2026-09-21 11:52	2026-09-21 11:52	PSA	PSA261016C00300000	call	300.0000	2026-10-16	5.9000	4.8000	6.1500	297.9200	36580.00	32450.00	0.00	62	10	64	53	1.20754716981132	0.208972697789972	0.208972697789972	false	false	false	true