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.

609,118 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts609,118 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

69f243a8-7e25-4098-9f0c-0f4b4d5185dd	2026-09-03 11:14	2026-09-03 11:14	2026-09-03 11:14	MPT	MPT270617P00002500	put	2.5000	2027-06-17	0.1500	0.1100	0.1500	4.0150	10500.00	10500.00	0.00	700	17	1228	26123	0.0470083834169123	0.598596477719587	0.598596477719587	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-03T15:27:44.291947Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
ac11923e-496b-421b-9318-959fffdbf2a6	2026-09-03 10:48	2026-09-03 10:48	2026-09-03 10:48	FRMI	FRMI261009C00006000	call	6.0000	2026-10-09	0.2500	0.2500	0.3000	4.8100	97760.00	0.00	97760.00	3905	35	4000	31	129.032258064516	1.00323105224011	1.01465886371832	false	false	false	true
92c30d79-78df-4636-a671-999645608de6	2026-09-03 09:54	2026-09-03 09:54	2026-09-03 09:54	DLR	DLR280121P00160000	put	160.0000	2028-01-21	14.0000	12.0000	14.0000	182.4000	116200.00	93800.00	0.00	83	6	83	607	0.13673805601318	0.348840799362723	0.348840799362723	false	false	false	true
3d4a95fd-7d2c-4889-a45b-28c0a0f59ae7	2026-09-03 09:53	2026-09-03 09:53	2026-09-03 09:53	LODE	LODE270416C00003000	call	3.0000	2027-04-16	1.0900	1.0500	1.1000	3.3350	10920.00	10920.00	0.00	100	6	209	707	0.295615275813296	0.923163323728497	0.912103337998633	false	false	false	true
d919dc5a-dd3e-47ec-a363-72a14fbc975f	2026-09-03 09:43	2026-09-03 09:43	2026-09-03 09:43	NNN	NNN270319C00050000	call	50.0000	2027-03-19	0.5000	0.5000	0.7000	44.9200	13150.00	0.00	13150.00	263	27	266	418	0.636363636363636	0.13424303459318	0.13424303459318	false	false	false	true
4ae18237-85f7-4c86-827a-acb23a246ab7	2026-09-02 15:31	2026-09-02 15:31	2026-09-02 15:31	NLY	NLY260925P00023000	put	23.0000	2026-09-25	0.5300	0.5000	0.5300	22.7050	13250.00	13250.00	0.00	250	38	318	3113	0.102152264696434	0.174575012926228	0.174575012926228	false	false	false	true
505eb2a8-d3b5-444f-93bb-f2759f323dd0	2026-09-02 15:12	2026-09-02 15:12	2026-09-02 15:12	FRMI	FRMI270115C00005000	call	5.0000	2027-01-15	1.2000	1.1500	1.2000	4.7450	60000.00	60000.00	0.00	500	11	538	3274	0.164324984728161	1.11982614879446	1.11982614879446	true	false	false	true
9ba61db4-fedf-4c0a-b3bf-a45937e7ccb1	2026-09-02 14:50	2026-09-02 14:49	2026-09-02 14:49	CBRE	CBRE261016C00145000	call	145.0000	2026-10-16	5.5000	5.1000	5.5000	142.2200	26400.00	26400.00	0.00	48	16	75	1	75	0.327561747170596	0.327561747170596	false	false	false	true
b318f956-3fb5-4377-8455-3420ce513dfd	2026-09-02 14:25	2026-09-02 14:25	2026-09-02 14:25	GEO	GEO280121C00045000	call	45.0000	2028-01-21	3.8000	3.7000	3.8000	30.4850	171000.00	171000.00	0.00	450	16	1050	5139	0.204319906596614	0.504991268982633	0.504991268982633	false	false	false	true
557c5357-865f-44b4-bb7e-04ff03cc5763	2026-09-02 14:24	2026-09-02 14:24	2026-09-02 14:24	FRMI	FRMI280121C00010000	call	10.0000	2028-01-21	1.3500	1.2500	1.3500	4.7180	10125.00	8100.00	0.00	75	5	278	6428	0.0432482887367766	1.05218956295572	1.05218956295572	false	false	false	true
f4f53fae-17bf-4332-8ae0-5f79749bb73f	2026-09-02 13:56	2026-09-02 13:56	2026-09-02 13:56	EQIX	EQIX270917P01080000	put	1080.0000	2027-09-17	151.4400	149.5000	151.7000	1011.1650	75720.00	75720.00	0.00	5	5	72	0	0	0.341244548462038	0.338065155878797	false	false	false	true
069309d0-cdf0-44aa-af49-c9b18c3fb15b	2026-09-02 13:56	2026-09-02 13:56	2026-09-02 13:56	EQIX	EQIX270917C01080000	call	1080.0000	2027-09-17	109.5000	105.2000	109.5000	1011.1650	54750.00	54750.00	0.00	5	5	73	0	0	0.288477027212769	0.288477027212769	false	false	false	true
cbc5b0c1-a102-4367-8358-f2cd807b7c80	2026-09-02 13:24	2026-09-02 13:24	2026-09-02 13:24	CBRE	CBRE261016C00150000	call	150.0000	2026-10-16	3.8000	3.5000	3.8000	143.1812	18240.00	18240.00	0.00	48	20	90	73	1.23287671232877	0.316096695390289	0.316096695390289	false	false	false	true
44817cf7-0a71-492e-a1a5-4aad64b3c69c	2026-09-02 13:18	2026-09-02 13:18	2026-09-02 13:18	FRMI	FRMI270617C00007000	call	7.0000	2027-06-17	1.2500	1.1000	1.2500	4.5799	25000.00	25000.00	0.00	200	8	312	655	0.476335877862595	1.14077590600427	1.14077590600427	false	false	false	true
2ae99303-dc57-4f49-aa3e-ab848e72688d	2026-09-02 12:31	2026-09-02 12:30	2026-09-02 12:30	CBRE	CBRE261016C00150000	call	150.0000	2026-10-16	3.7000	3.3000	3.7000	142.4500	11100.00	11100.00	0.00	30	9	31	73	0.424657534246575	0.325075073567159	0.325075073567159	false	false	false	true
7bf97349-fd4f-4f1b-991a-5d7791f0a970	2026-09-02 12:02	2026-09-02 12:02	2026-09-02 12:02	MPT	MPT281215P00002500	put	2.5000	2028-12-15	0.4100	0.2100	0.4100	4.0950	33210.00	33210.00	0.00	810	34	8001	15027	0.532441605110801	0.605633473574471	0.605633473574471	false	false	false	true
88444682-4f22-4a4d-823d-d4a576a8946f	2026-09-02 12:01	2026-09-02 12:01	2026-09-02 12:01	MPT	MPT281215P00002500	put	2.5000	2028-12-15	0.4000	0.2000	0.4100	4.0950	29640.00	29240.00	400.00	741	14	7160	15027	0.476475677114527	0.598160106378416	0.598160106378416	false	false	false	true
d70e31ef-ba30-4f3c-ae09-7b7b594b621d	2026-09-02 12:01	2026-09-02 12:01	2026-09-02 12:01	MPT	MPT281215P00002500	put	2.5000	2028-12-15	0.4000	0.3500	0.4100	4.1100	97200.00	79720.00	10760.00	2430	21	6148	15027	0.409130232248619	0.599657505054771	0.599657505054771	false	false	false	true
56522d20-31ac-435e-ac06-015232cfb9a4	2026-09-02 11:59	2026-09-02 11:59	2026-09-02 11:59	MPT	MPT281215P00002500	put	2.5000	2028-12-15	0.4000	0.3300	0.4700	4.1250	18600.00	800.00	17800.00	465	5	490	15027	0.032607972316497	0.601146812476072	0.601146812476072	false	false	false	true
5593f961-8afe-4011-9803-52fb319c7a74	2026-09-02 11:49	2026-09-02 11:49	2026-09-02 11:49	CSGP	CSGP261218C00035000	call	35.0000	2026-12-18	2.3500	2.2500	2.4000	31.5500	425350.00	413365.00	11985.00	1810	20	1933	223	8.66816143497758	0.516264132040746	0.516264132040746	false	false	false	true
ca4216bb-8e34-4584-9357-2cf6cbbeedf5	2026-09-02 11:34	2026-09-02 11:34	2026-09-02 11:34	NLY	NLY261016C00023000	call	23.0000	2026-10-16	0.2900	0.2500	0.2900	22.6267	51272.00	51272.00	0.00	1768	45	1798	3655	0.491928864569083	0.129813528836134	0.129813528836134	false	false	false	true
8a72561b-d671-465c-ac11-623b9ce0978e	2026-09-02 11:29	2026-09-02 11:29	2026-09-02 11:29	AGNC	AGNC261218C00010000	call	10.0000	2026-12-18	0.7500	0.7500	0.7600	10.5800	29100.00	0.00	29100.00	388	9	483	5821	0.0829754337742656	0.122879852536287	0.122879852536287	true	false	false	true
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
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
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
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
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
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