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

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	true	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	Common Stock	Real Estate	3234360107.00	2026-11-09	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-02T15:49:54.253343Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
47167975-66cb-4222-8b41-d510e5524f84	2026-09-02 11:25	2026-09-02 11:24	2026-09-02 11:24	FRMI	FRMI270617C00012000	call	12.0000	2027-06-17	0.6000	0.6000	0.6500	4.5399	60000.00	0.00	60000.00	1000	13	1016	1034	0.982591876208897	1.10650385192663	1.10650385192663	true	false	false	true
1471097d-b23f-4350-b6f9-675aa1959a74	2026-09-02 11:22	2026-09-02 11:21	2026-09-02 11:21	WY	WY280121C00030000	call	30.0000	2028-01-21	1.2500	1.0500	1.2500	23.3400	24930.00	24930.00	0.00	200	9	200	661	0.302571860816944	0.264617712980184	0.257346897366024	false	false	false	true
c5d11d25-5dbb-4b13-bdfc-e0b941768f0b	2026-09-02 11:16	2026-09-02 11:16	2026-09-02 11:16	VICI	VICI261218P00027500	put	27.5000	2026-12-18	2.5000	2.4500	2.6000	25.6500	17505.00	250.00	17255.00	70	6	147	2096	0.0701335877862595	0.284313081460194	0.284313081460194	false	false	false	true
b3fbb838-bad6-4e76-92ce-0575186dd40f	2026-09-02 11:15	2026-09-02 11:15	2026-09-02 11:15	AGNC	AGNC261218P00009000	put	9.0000	2026-12-18	0.1000	0.0900	0.1300	10.5790	51840.00	0.00	51840.00	5184	45	5936	31829	0.186496591159006	0.286838318356555	0.286838318356555	false	false	false	true
330be413-64d8-44e9-92c5-2cfb22893348	2026-09-02 11:01	2026-09-02 11:01	2026-09-02 11:01	AGNC	AGNC270115P00009000	put	9.0000	2027-01-15	0.1400	0.1400	0.1700	10.6150	44352.00	0.00	44352.00	3168	15	3171	1136	2.79137323943662	0.292170822180946	0.292170822180946	false	false	false	true
26a917ff-d49d-4c03-946e-4f64cf314601	2026-09-02 10:16	2026-09-02 10:16	2026-09-02 10:16	NLY	NLY280121C00022000	call	22.0000	2028-01-21	1.3300	1.3000	1.8900	22.6400	13433.00	11438.00	1995.00	101	13	302	1607	0.187927815805849	0.123697714199623	0	false	false	false	true
aa50f614-4685-4e60-9d7e-7720909c9711	2026-09-02 10:01	2026-09-02 10:01	2026-09-02 10:01	OPEN	OPEN260904P00003500	put	3.5000	2026-09-04	0.4500	0.4100	0.4500	3.0750	13725.00	13725.00	0.00	305	9	626	4526	0.138311975254088	1.57437126832743	1.57437126832743	false	false	false	true
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	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
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	true
cc119f73-e0b6-41c3-ad31-57a17afcd1e2	2026-09-01 15:48	2026-09-01 15:48	2026-09-01 15:48	EXR	EXR261016P00130000	put	130.0000	2026-10-16	1.2500	1.1000	1.5500	139.2300	214375.00	0.00	214375.00	1715	2	1715	5	343	0.244059334081018	0.244059334081018	false	true	true	false
fcb41e15-61a8-4221-92d1-2e016ac080a7	2026-09-01 14:23	2026-09-01 14:23	2026-09-01 14:23	IRM	IRM261016C00120000	call	120.0000	2026-10-16	2.5000	2.0000	2.8500	113.9400	515935.00	512750.00	3185.00	2064	6	2117	26	81.4230769230769	0.287728394439331	0.291141391370966	false	false	false	true
843306af-ba51-4a6d-a13b-af24d4d4a7de	2026-09-01 14:09	2026-09-01 14:09	2026-09-01 14:09	IRM	IRM260904C00115000	call	115.0000	2026-09-04	1.2000	1.0000	1.2000	114.1600	20277.00	20277.00	0.00	169	33	170	1	170	0.37879677611749	0.37879677611749	false	false	false	true
0cd1202b-af9e-4d93-8147-f4658f73830f	2026-09-01 14:04	2026-09-01 14:04	2026-09-01 14:04	BEKE	BEKE270115C00019000	call	19.0000	2027-01-15	1.3500	1.3000	1.3500	17.7350	27945.00	27945.00	0.00	207	5	207	845	0.244970414201183	0.406575912995051	0.406575912995051	false	false	false	true
8010da11-30dc-4be2-9429-54d326fe866e	2026-09-01 13:11	2026-09-01 13:11	2026-09-01 13:11	VICI	VICI261016P00025000	put	25.0000	2026-10-16	0.5000	0.4500	0.5000	25.5699	11892.00	11798.00	94.00	238	18	263	2334	0.112682090831191	0.225820064430572	0.225820064430572	false	false	false	true
e556af15-46c0-477f-94eb-4ac089e951de	2026-09-01 13:08	2026-09-01 13:08	2026-09-01 13:08	FRMI	FRMI280121C00010000	call	10.0000	2028-01-21	1.3000	1.3000	1.4000	4.7100	25350.00	0.00	25350.00	195	18	551	6119	0.0900473933649289	1.03073489123868	1.03073489123868	false	false	false	true
50045dfa-ac45-446b-8b4d-40447906f845	2026-09-01 12:58	2026-09-01 12:58	2026-09-01 12:58	CBRE	CBRE260918P00155000	put	155.0000	2026-09-18	11.3000	10.0000	11.8000	144.2400	339000.00	339000.00	0.00	300	2	300	656	0.457317073170732	0.31734787871666	0.31734787871666	false	true	true	false
2e065c66-ab32-4748-a3c4-fd4774a9bc94	2026-09-01 12:50	2026-09-01 12:50	2026-09-01 12:50	UNIT	UNIT261120C00013000	call	13.0000	2026-11-20	0.2000	0.1000	0.2000	9.5500	36420.00	36420.00	0.00	1821	49	1821	9956	0.182904781036561	0.578101930805474	0.576615998067718	false	false	false	true
92209ed9-a945-4bc3-a763-a99d54c9f14d	2026-09-01 12:30	2026-09-01 12:30	2026-09-01 12:30	NLY	NLY270115P00022000	put	22.0000	2027-01-15	1.1900	1.1500	1.2000	22.7150	23800.00	2856.00	20944.00	200	5	205	1655	0.123867069486405	0.30730331313108	0.30730331313108	false	false	false	true
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
0c87ee0c-fae8-47fd-b044-3b5541d72c9c	2026-09-01 12:23	2026-09-01 12:23	2026-09-01 12:23	AGNC	AGNC261218P00009000	put	9.0000	2026-12-18	0.1100	0.0900	0.1200	10.6400	127798.00	95535.00	12804.00	11618	51	11619	18810	0.617703349282297	0.300166459281239	0.29964852285981	false	false	false	true
5c655abf-62d5-41a8-9327-944aab39ad0b	2026-09-01 12:11	2026-09-01 12:11	2026-09-01 12:11	GEO	GEO270115P00028000	put	28.0000	2027-01-15	2.4500	2.2500	2.5000	30.3550	77420.00	77420.00	0.00	316	31	898	62	14.4838709677419	0.522684037668239	0.522684037668239	false	false	false	true
a8e08373-7b85-4769-95ee-07c49e56ba6c	2026-09-01 12:06	2026-09-01 12:06	2026-09-01 12:06	GEO	GEO270115P00028000	put	28.0000	2027-01-15	2.4000	2.0000	2.4000	30.5300	129120.00	129120.00	0.00	538	31	538	62	8.67741935483871	0.523583176391891	0.523583176391891	true	false	false	true
246ce462-1220-4045-90b7-4ef3841d943f	2026-09-01 12:04	2026-09-01 12:04	2026-09-01 12:04	NLY	NLY261120P00020000	put	20.0000	2026-11-20	0.1700	0.1700	0.2200	22.7797	13379.00	0.00	13379.00	787	40	808	31	26.0645161290323	0.262936534899229	0.262936534899229	false	false	false	true
1052a8b2-f867-4611-bf5c-5bcaf4def47c	2026-09-01 12:03	2026-09-01 12:03	2026-09-01 12:03	SLG	SLG261016P00047500	put	47.5000	2026-10-16	0.6500	0.6500	0.9000	55.3000	16380.00	0.00	16380.00	252	15	252	2	126	0.442756026728972	0.442756026728972	false	false	false	true
5a2cca61-8a76-4d31-9a40-2ea861bf333f	2026-09-01 11:45	2026-09-01 11:45	2026-09-01 11:45	OPEN	OPEN280121C00010000	call	10.0000	2028-01-21	0.5500	0.5300	0.5600	3.1100	22000.00	18480.00	3520.00	400	15	438	43702	0.010022424602993	1.01562727454901	1.01562727454901	false	false	false	true
494d2daf-1cfb-4cfd-853c-75d59bb4d746	2026-09-01 11:38	2026-09-01 11:38	2026-09-01 11:38	OPEN	OPEN271217C00003000	call	3.0000	2027-12-17	1.3300	1.3200	1.3600	3.1100	19019.00	0.00	19019.00	143	7	211	3984	0.0529618473895582	0.929689236754071	0.929689236754071	false	false	false	true
d3d8ad3c-5062-4a48-a1fa-c1e3b07f1df4	2026-09-01 11:35	2026-09-01 11:35	2026-09-01 11:35	IRM	IRM261218P00110000	put	110.0000	2026-12-18	6.2000	5.9000	7.3000	115.0400	31620.00	17980.00	13640.00	51	14	61	196	0.311224489795918	0.373141597064658	0.370114759799397	false	false	false	true
0af7b2ca-bd6d-41f9-a766-ec9b3b59f5f0	2026-09-01 11:25	2026-09-01 11:25	2026-09-01 11:25	WELL	WELL271119P00240000	put	240.0000	2027-11-19	22.0000	21.1000	23.0000	241.7050	541200.00	407000.00	134200.00	246	39	246	202	1.21782178217822	0.276737620750524	0.276901182162188	true	false	false	true
973d3168-b838-4b9f-b0f3-7e52f4a3cf36	2026-09-01 11:08	2026-09-01 11:08	2026-09-01 11:08	OPEN	OPEN260904C00003000	call	3.0000	2026-09-04	0.1400	0.1200	0.1500	3.0900	13482.00	13104.00	378.00	963	22	1461	2543	0.574518285489579	0.790981488743435	0.790981488743435	true	false	false	true
5b19c031-07d2-4a12-b694-6bc2b7a8c81f	2026-09-01 10:50	2026-09-01 10:50	2026-09-01 10:50	OPEN	OPEN271217C00004000	call	4.0000	2027-12-17	1.0700	1.0700	1.1000	3.1050	32956.00	0.00	32956.00	308	7	342	2648	0.129154078549849	0.93548363087016	0.93548363087016	false	false	false	true
d3c82c68-236e-4571-b182-3a7a10d8b991	2026-09-01 10:44	2026-09-01 10:44	2026-09-01 10:44	DLR	DLR260904C00185000	call	185.0000	2026-09-04	1.4000	1.0000	1.4000	183.0300	58660.00	58660.00	0.00	419	43	420	9	46.6666666666667	0.334592250059893	0.334592250059893	false	false	false	true
becbbeb0-73f7-4ac3-bdf5-494c532090e8	2026-09-01 10:44	2026-09-01 10:44	2026-09-01 10:44	DLR	DLR270319P00160000	put	160.0000	2027-03-19	6.9000	6.9000	7.1000	183.2900	51060.00	0.00	51060.00	74	12	120	900	0.133333333333333	0.342990261503974	0.342990261503974	false	false	false	true
59017133-a5b9-4e52-a7da-52e694f63f9c	2026-09-01 10:34	2026-09-01 10:34	2026-09-01 10:34	DLR	DLR280121P00160000	put	160.0000	2028-01-21	14.4000	14.4000	14.7000	182.9700	115200.00	0.00	115200.00	80	7	258	310	0.832258064516129	0.355679498911882	0.355679498911882	false	false	false	true
efe070aa-fc8b-42ee-9402-570684aef41c	2026-09-01 10:30	2026-09-01 10:30	2026-09-01 10:30	DLR	DLR280121P00160000	put	160.0000	2028-01-21	14.4000	14.4000	15.1000	182.9100	112320.00	0.00	7200.00	78	34	78	310	0.251612903225806	0.355460389436322	0.355460389436322	false	false	false	true
d0d05333-32f6-410a-ad83-e0b14059e51e	2026-09-01 10:17	2026-09-01 10:17	2026-09-01 10:17	DLR	DLR270617P00160000	put	160.0000	2027-06-17	9.8000	9.8000	10.3000	182.9500	113680.00	0.00	105840.00	116	42	116	800	0.145	0.351309088054898	0.351309088054898	false	false	false	true
06ad3477-a1ad-4c43-8508-65d200a8940a	2026-09-01 10:06	2026-09-01 10:05	2026-09-01 10:05	DLR	DLR270917P00160000	put	160.0000	2027-09-17	11.5000	11.5000	12.5000	184.5100	115000.00	0.00	5750.00	100	33	100	502	0.199203187250996	0.352979830831119	0.352979830831119	false	false	false	true
e8c84072-ae65-4c2f-b916-a98d57b21c20	2026-09-01 09:54	2026-09-01 09:54	2026-09-01 09:54	AGNC	AGNC261002P00010000	put	10.0000	2026-10-02	0.0900	0.0600	0.0900	10.7105	18774.00	18774.00	0.00	2086	10	7594	271	28.0221402214022	0.282685927512062	0.282685927512062	false	false	false	true
89e0da49-34e9-42a3-99f9-25e30a1fce95	2026-09-01 09:54	2026-09-01 09:54	2026-09-01 09:54	AGNC	AGNC261002P00010000	put	10.0000	2026-10-02	0.0900	0.0800	0.0900	10.7100	13941.00	13941.00	0.00	1549	6	5508	271	20.3247232472325	0.282575875550963	0.282575875550963	false	false	false	true
762348db-aa15-4a22-8239-97f7da9f7930	2026-09-01 09:50	2026-09-01 09:50	2026-09-01 09:50	OPEN	OPEN270115P00003000	put	3.0000	2027-01-15	0.5500	0.5200	0.5500	3.0400	55495.00	55495.00	0.00	1009	6	1009	4415	0.228539071347678	0.814855276485436	0.814855276485436	false	false	false	true
f22a3c60-95f5-40ba-8af3-67925e80115b	2026-09-01 09:41	2026-09-01 09:41	2026-09-01 09:41	FRMI	FRMI280121C00010000	call	10.0000	2028-01-21	1.4500	1.4000	1.4500	4.7914	46400.00	46400.00	0.00	320	6	333	6119	0.0544206569700931	1.07876448045924	1.07876448045924	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	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
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
84ee73db-3a5a-49b9-82db-970412437b21	2026-08-31 14:48	2026-08-31 14:48	2026-08-31 14:48	ESS	ESS270416C00290000	call	290.0000	2027-04-16	15.6000	14.8000	15.6000	282.7800	12480.00	12480.00	0.00	8	5	8	0	0	0.174447664426754	0.17403107432767	false	false	false	true
664d5c11-ce9a-4624-b226-c066a07e2ef9	2026-08-31 14:20	2026-08-31 14:20	2026-08-31 14:20	EQIX	EQIX261120C01170000	call	1170.0000	2026-11-20	23.1000	21.2000	23.1000	1035.0000	127050.00	127050.00	0.00	55	11	59	34	1.73529411764706	0.319854835667542	0.319854835667542	false	false	false	true
4a01ccbe-3f03-4ec2-8ac5-eb358d5833df	2026-08-31 14:04	2026-08-31 14:04	2026-08-31 14:04	CXW	CXW261120C00034000	call	34.0000	2026-11-20	2.9000	2.8000	3.1000	33.0000	162400.00	131080.00	31320.00	560	5	600	192	3.125	0.485744485712853	0.485744485712853	false	false	false	true
f604c99c-6e7b-42cb-87e0-4b0d8c6039dd	2026-08-31 14:04	2026-08-31 14:04	2026-08-31 14:04	FRMI	FRMI261016C00008000	call	8.0000	2026-10-16	0.1700	0.1000	0.2000	4.0000	11815.00	11815.00	0.00	695	5	1078	4305	0.250406504065041	1.19240830947136	1.19240830947136	false	false	false	true
745dc5d5-3abf-4db9-aff1-40fe9af00b70	2026-08-31 13:48	2026-08-31 13:48	2026-08-31 13:48	PSA	PSA270521P00280000	put	280.0000	2027-05-21	13.1000	12.0000	13.3000	306.0000	196500.00	196500.00	0.00	150	1	151	0	0	0.276664525131208	0.276664525131208	false	true	false	true