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×sector = Real Estate×source = uw_flow_alerts×

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
4e1ae9b7-5fee-46cc-b968-a1d4834e4f49	2026-09-22 15:16	2026-09-22 15:16	2026-09-22 15:16	CSGP	CSGP280121C00030000	call	30.0000	2028-01-21	7.0000	7.0000	7.4000	28.8395	16802.00	0.00	16802.00	24	5	45	539	0.0834879406307978	0.516242707207291	0.514647884411964	false	false	false
5c27619f-d4a8-42b7-9b35-d99b82077d8e	2026-09-22 15:14	2026-09-22 15:14	2026-09-22 15:14	GEO	GEO261016C00031000	call	31.0000	2026-10-16	0.8900	0.8000	0.9000	29.5000	13348.00	13348.00	0.00	150	8	817	1926	0.424195223260644	0.483708504379549	0.480222485535923	false	false	false
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
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
ad464d2e-caf3-475d-9784-4f6d21c451be	2026-09-22 14:25	2026-09-22 14:25	2026-09-22 14:25	CCI	CCI261120P00070000	put	70.0000	2026-11-20	2.1500	2.0500	2.1500	72.9000	44930.00	44930.00	0.00	209	35	210	6	35	0.31392791606036	0.31392791606036	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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
b1a34690-012a-449d-a308-f418ea4c0c41	2026-09-21 15:38	2026-09-21 15:38	2026-09-21 15:38	FRMI	FRMI261218P00005000	put	5.0000	2026-12-18	0.9700	0.9000	1.0500	5.0950	10128.00	10128.00	0.00	104	5	133	18540	0.00717367853290183	1.0805826237467	1.07004152984395	false	false	false
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
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
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
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
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
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
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
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
84083b23-64f5-4a7e-bf32-97843d3165c3	2026-09-21 13:27	2026-09-21 13:27	2026-09-21 13:27	SPG	SPG270115C00220000	call	220.0000	2027-01-15	4.5800	4.4000	5.7000	205.1050	24708.00	0.00	24708.00	54	5	54	348	0.155172413793103	0.197480771665172	0.197480771665172	false	false	false
40a27c8d-07f8-41c7-b56b-c0dafd673dd2	2026-09-21 13:25	2026-09-21 13:25	2026-09-21 13:25	WELL	WELL270319P00190000	put	190.0000	2027-03-19	3.6700	2.5000	3.9000	232.0900	42983.00	40463.00	2520.00	117	35	117	2	58.5	0.312274353454073	0.30937482621934	true	false	false
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
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
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