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:er_time = unknown×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	expirydate

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	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	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-02T19:37:03.508091Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
30e92078-2a92-4c7f-8820-5aa0ff977435	2026-09-02 14:55	2026-09-02 14:55	2026-09-02 14:55	GEO	GEO280121C00045000	call	45.0000	2028-01-21	3.8600	3.7000	3.9000	30.6300	96536.00	96536.00	0.00	250	16	1300	5139	0.252967503405332	0.508280537205565	0.507991147263609	false	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
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	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
2b50f043-62b8-46f5-b82f-010a55c1984c	2026-09-02 13:56	2026-09-02 13:56	2026-09-02 13:56	EQIX	EQIX270917C01080000	call	1080.0000	2027-09-17	109.5400	105.1000	110.0000	1011.1650	76680.00	76680.00	0.00	7	7	23	0	0	0.28969560479558	0.285796462903006	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
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
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
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