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

583cfe60-7611-4d63-a70f-8375227e02f9	2026-09-24 13:48	2026-09-24 13:48	2026-09-24 13:48	CBRE	CBRE261016P00135000	put	135.0000	2026-10-16	4.0000	3.9000	4.2000	137.0000	27200.00	0.00	27200.00	68	6	1506	4514	0.333628710677891	0.402187443994286	0.402187443994286	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Real Estate	39500966400.00	2026-10-22	unknown	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-24T17:55:11.953323Z"}	2026-09-24	2026-09-24 21:15	2026-09-24 21:15
a5a4a8c7-e271-4896-9364-768f9b63e58a	2026-09-24 13:48	2026-09-24 13:48	2026-09-24 13:48	CBRE	CBRE261016P00135000	put	135.0000	2026-10-16	4.0000	3.9000	4.2000	137.0000	24400.00	0.00	24400.00	61	5	1438	4514	0.31856446610545	0.402187443994286	0.402187443994286	false	false	false	true
925118da-7599-4763-a0b0-b24dc836a05b	2026-09-24 13:43	2026-09-24 13:42	2026-09-24 13:42	MAA	MAA261218P00110000	put	110.0000	2026-12-18	2.1000	1.7500	2.1500	117.8500	84000.00	33810.00	50190.00	400	9	412	503	0.819085487077535	0.249216863240572	0.249216863240572	false	false	false	true
74891bb9-94ad-4c9e-9e01-2fd1b2b46314	2026-09-24 13:18	2026-09-24 13:18	2026-09-24 13:18	FRMI	FRMI281215C00005000	call	5.0000	2028-12-15	2.5500	2.4500	2.5500	4.6499	11475.00	11475.00	0.00	45	5	153	1016	0.150590551181102	0.990709104519341	0.990709104519341	false	false	false	true
089315c3-0d19-4110-8ff4-5aee12955109	2026-09-24 13:18	2026-09-24 13:18	2026-09-24 13:18	TRTX	TRTX270115P00007000	put	7.0000	2027-01-15	0.9000	0.9000	0.9500	6.6750	14670.00	0.00	90.00	163	28	2163	136	15.9044117647059	0.518110467087836	0.518110467087836	false	false	false	true
659fbf37-c0c2-440d-85e3-a739b3ca8079	2026-09-24 13:15	2026-09-24 13:15	2026-09-24 13:15	CBRE	CBRE261016P00135000	put	135.0000	2026-10-16	4.0000	4.0000	4.2000	137.6100	12800.00	0.00	12800.00	32	13	1326	4514	0.293752769162605	0.400597662841301	0.400597662841301	false	false	false	true
ce9cc676-5f1c-419f-9cc8-a3e76f3a1619	2026-09-24 13:13	2026-09-24 13:13	2026-09-24 13:13	WELL	WELL261016C00250000	call	250.0000	2026-10-16	0.9500	0.9500	1.1000	235.1300	11205.00	0.00	11205.00	118	21	302	1430	0.211188811188811	0.222756603033794	0.218950719632186	true	false	false	true
0b2b4db2-6f10-40ed-930e-af657f8ec925	2026-09-24 13:12	2026-09-24 13:12	2026-09-24 13:12	WELL	WELL261016C00240000	call	240.0000	2026-10-16	3.4000	3.3000	3.4000	235.2050	19720.00	6120.00	0.00	58	19	301	530	0.567924528301887	0.225534297605292	0.225534297605292	false	false	false	true
2a98800a-a3ff-4d79-ac5b-53e8385afe8b	2026-09-24 13:10	2026-09-24 13:10	2026-09-24 13:10	WELL	WELL261016C00240000	call	240.0000	2026-10-16	3.7000	3.6000	3.7000	235.7200	15910.00	15910.00	0.00	43	9	243	530	0.458490566037736	0.229915535488348	0.229915535488348	false	false	false	true
3766407b-30c0-4ef6-a653-7bc27583201c	2026-09-24 13:07	2026-09-24 13:07	2026-09-24 13:07	WELL	WELL261016C00240000	call	240.0000	2026-10-16	3.7000	3.6000	3.7000	235.7300	14430.00	14430.00	0.00	39	8	152	530	0.286792452830189	0.229735910763859	0.229735910763859	false	false	false	true
74a98819-276e-4040-8fdb-5dab90ae8558	2026-09-24 13:07	2026-09-24 13:07	2026-09-24 13:07	WELL	WELL261016C00240000	call	240.0000	2026-10-16	3.7000	3.6000	3.7000	235.7799	13690.00	13690.00	0.00	37	10	101	530	0.190566037735849	0.228838707890026	0.228838707890026	false	false	false	true
1873f5a2-a9a9-4458-93d9-ec85f5f1a7bb	2026-09-24 13:04	2026-09-24 13:04	2026-09-24 13:04	IRM	IRM261009C00115000	call	115.0000	2026-10-09	2.8500	2.4000	2.8500	114.5800	95760.00	95760.00	0.00	336	22	949	36	26.3611111111111	0.319631329230784	0.319631329230784	false	false	false	true
28ba8288-1837-4be0-8fe7-7bf7fceb017a	2026-09-24 12:47	2026-09-24 12:47	2026-09-24 12:47	OPEN	OPEN271217C00005000	call	5.0000	2027-12-17	0.5900	0.5800	0.6400	2.5650	29314.00	0.00	29314.00	500	13	601	14667	0.0409763414467853	0.935824195510109	0.935824195510109	true	false	false	true
0abddd06-5d5c-4dde-8439-c9787cdead05	2026-09-24 12:43	2026-09-24 12:43	2026-09-24 12:43	FRMI	FRMI261218P00004000	put	4.0000	2026-12-18	0.5900	0.5000	0.6000	4.5850	236000.00	192000.00	0.00	4000	2	6418	12620	0.508557844690967	1.07986172925815	1.01424853769724	false	true	false	true
0d1f354d-57ac-4f24-9ca5-cf44ca659750	2026-09-24 12:41	2026-09-24 12:41	2026-09-24 12:41	IRM	IRM261009C00115000	call	115.0000	2026-10-09	2.9500	2.4500	3.0000	114.5700	69620.00	69325.00	0.00	236	34	613	36	17.0277777777778	0.330963646823076	0.330963646823076	false	false	false	true
47362605-2cb5-45e4-aaa7-96a925de1265	2026-09-24 12:41	2026-09-24 12:41	2026-09-24 12:41	IRM	IRM261009C00115000	call	115.0000	2026-10-09	2.9000	2.9000	2.9500	114.5700	23490.00	0.00	23490.00	81	5	377	36	10.4722222222222	0.325567417245542	0.325567417245542	false	false	false	true
8bcf579e-4840-439e-82ec-f836bb727b11	2026-09-24 12:40	2026-09-24 12:40	2026-09-24 12:40	IRM	IRM261009C00115000	call	115.0000	2026-10-09	2.7000	2.3500	2.9000	114.2250	21330.00	21060.00	270.00	79	30	260	36	7.22222222222222	0.322263136086878	0.322263136086878	false	false	false	true
a3f61904-4ee6-4e9b-91f8-a7f7c74f1dcf	2026-09-24 12:40	2026-09-24 12:40	2026-09-24 12:40	IRM	IRM261009C00115000	call	115.0000	2026-10-09	2.6000	2.6000	2.7000	114.2250	33020.00	0.00	33020.00	127	8	181	36	5.02777777777778	0.311425797497186	0.311425797497186	false	false	false	true
a39a2d1b-3596-45ff-ba99-cd0227d3853a	2026-09-24 12:29	2026-09-24 12:28	2026-09-24 12:28	SBAC	SBAC261120P00175000	put	175.0000	2026-11-20	11.9000	11.4000	14.1000	167.5100	16660.00	0.00	16660.00	14	5	33	0	0	0.309709405133179	0.309709405133179	false	false	false	true
7b46dbf8-790c-4079-b482-9bebef2171ce	2026-09-24 12:18	2026-09-24 12:18	2026-09-24 12:18	CBRE	CBRE261016P00135000	put	135.0000	2026-10-16	4.4000	3.8000	4.4000	137.0000	29920.00	29920.00	0.00	68	16	1094	4514	0.24235711120957	0.413477699456478	0.413477699456478	false	false	false	true
29cf5383-012e-44e5-82f1-690a52065453	2026-09-24 12:18	2026-09-24 12:18	2026-09-24 12:18	CBRE	CBRE261016P00135000	put	135.0000	2026-10-16	4.4000	3.8000	4.4000	136.0000	35640.00	35640.00	0.00	81	8	949	4514	0.210234824988923	0.412059498425784	0.412059498425784	false	false	false	true
0c07cc26-3a8d-403a-b713-1df33cfbedf5	2026-09-24 12:18	2026-09-24 12:17	2026-09-24 12:17	CBRE	CBRE261016P00135000	put	135.0000	2026-10-16	4.5000	4.0000	4.5000	136.7800	16200.00	16200.00	0.00	36	10	850	4514	0.188303057155516	0.413018321804365	0.413018321804365	false	false	false	true
634226b1-e0bb-4a1a-840b-4ad455fbba95	2026-09-24 12:17	2026-09-24 12:17	2026-09-24 12:17	CBRE	CBRE261016P00135000	put	135.0000	2026-10-16	4.5000	3.6000	4.5000	136.7200	22950.00	22950.00	0.00	51	12	814	4514	0.180327868852459	0.411097792544499	0.411097792544499	false	false	false	true
e9149273-5869-411b-97f5-26d9fe960f93	2026-09-24 12:17	2026-09-24 12:17	2026-09-24 12:17	CBRE	CBRE261016P00135000	put	135.0000	2026-10-16	4.4800	3.6000	4.5000	136.7400	39830.00	30150.00	9680.00	89	16	763	4514	0.169029685423128	0.411738664796214	0.404118101552423	false	false	false	true
ff89da33-2ea7-4fc3-855c-3eb48724b272	2026-09-24 12:17	2026-09-24 12:16	2026-09-24 12:16	CBRE	CBRE261016P00135000	put	135.0000	2026-10-16	4.5000	3.8000	4.5000	136.6500	16200.00	16200.00	0.00	36	7	537	4514	0.118963225520603	0.408849210217935	0.408849210217935	false	false	false	true
939b52be-e2b0-438d-8f24-9e94080af740	2026-09-24 12:16	2026-09-24 12:16	2026-09-24 12:16	PLD	PLD261016P00135000	put	135.0000	2026-10-16	3.5000	3.3000	3.5000	134.2300	104640.00	104640.00	0.00	299	20	308	1302	0.236559139784946	0.248528882229028	0.248528882229028	false	false	false	true
9a922784-ef9b-471b-b07f-26b18657b460	2026-09-24 12:09	2026-09-24 12:09	2026-09-24 12:09	EQIX	EQIX261218P00800000	put	800.0000	2026-12-18	5.0000	5.0000	6.5000	1030.0000	21500.00	0.00	21500.00	43	16	50	65	0.769230769230769	0.376225773588418	0.376225773588418	false	false	false	true
a1fd923c-4d69-4b35-9dbb-ca64b1aa290d	2026-09-24 11:52	2026-09-24 11:52	2026-09-24 11:52	CCI	CCI270319P00065000	put	65.0000	2027-03-19	4.6000	4.3000	4.6000	67.9100	42780.00	42320.00	0.00	93	29	104	275	0.378181818181818	0.357925456496201	0.357925456496201	true	false	false	true
f4b0db90-f92c-4e02-b82d-f00432e0f958	2026-09-24 11:44	2026-09-24 11:44	2026-09-24 11:44	JLL	JLL261120P00350000	put	350.0000	2026-11-20	31.6000	31.6000	34.4000	322.9450	41080.00	0.00	41080.00	13	5	13	1	13	0.307971422032641	0.307971422032641	false	false	false	true
16f087c7-7e8d-416c-ba43-e5b099ccf2cb	2026-09-24 11:42	2026-09-24 11:42	2026-09-24 11:42	CXW	CXW270319C00040000	call	40.0000	2027-03-19	2.7000	2.4500	2.7000	34.2100	111510.00	111510.00	0.00	413	11	413	113	3.65486725663717	0.472929115864924	0.472929115864924	false	false	false	true
b97ba1e5-c57b-4f84-8a17-5d34b7667a82	2026-09-24 11:11	2026-09-24 11:11	2026-09-24 11:11	FRMI	FRMI261023P00004500	put	4.5000	2026-10-23	0.4000	0.3500	0.4500	4.0000	10240.00	2600.00	0.00	256	5	455	1318	0.345220030349014	0.892755305420156	0.892755305420156	false	false	false	true
5837f37d-a238-4faf-ba8b-f7e01bfb24c3	2026-09-24 10:49	2026-09-24 10:49	2026-09-24 10:49	ARR	ARR270416P00013000	put	13.0000	2027-04-16	0.9000	0.8500	0.9000	14.0000	19530.00	19530.00	0.00	217	6	1515	134	11.3059701492537	0.395135447931253	0.395135447931253	true	false	false	true
c5b3b90e-7ee0-4e48-a6c7-054110f5d9f7	2026-09-24 10:40	2026-09-24 10:40	2026-09-24 10:40	STWD	STWD280121P00013000	put	13.0000	2028-01-21	1.3500	1.3500	1.6500	14.5650	27952.00	0.00	27952.00	207	15	1192	459	2.59694989106754	0.386372085236405	0.386372085236405	false	false	false	true
60f7c36b-2a4a-44b1-aedb-6cac420d4720	2026-09-24 10:40	2026-09-24 10:40	2026-09-24 10:40	STWD	STWD280121P00013000	put	13.0000	2028-01-21	1.3600	1.3000	1.6000	14.5450	38525.00	0.00	38525.00	284	12	985	459	2.14596949891068	0.385402635708483	0.385402635708483	false	false	false	true
3b4a3459-f128-429a-a9a5-159b825c3fd7	2026-09-24 10:26	2026-09-24 10:26	2026-09-24 10:26	OPEN	OPEN280915C00007000	call	7.0000	2028-09-15	0.7000	0.7000	0.7100	2.5550	39410.00	0.00	25340.00	563	6	2087	26311	0.0793204363194101	0.949669292234223	0.949669292234223	true	false	false	true
b500b7af-3a3c-4005-81e5-d58be299b87d	2026-09-24 10:17	2026-09-24 10:17	2026-09-24 10:17	CCI	CCI261016P00070000	put	70.0000	2026-10-16	2.6500	2.4500	2.7000	68.6350	23055.00	22790.00	0.00	87	26	92	1484	0.0619946091644205	0.294232712061022	0.294232712061022	false	false	false	true
c524a8c5-1d44-48c0-be80-c4eb503e9fa6	2026-09-24 10:07	2026-09-24 10:07	2026-09-24 10:07	ARR	ARR270416P00013000	put	13.0000	2027-04-16	0.8500	0.7000	0.9000	14.3900	108205.00	99450.00	8755.00	1273	44	1274	134	9.50746268656716	0.389975618578054	0.388045690029913	true	false	false	true
bd5f18da-6487-44b4-b439-eef11483ba87	2026-09-24 10:04	2026-09-24 10:04	2026-09-24 10:04	ARR	ARR270115P00013000	put	13.0000	2027-01-15	0.4500	0.3500	0.4500	14.4250	60120.00	60120.00	0.00	1336	25	1500	1166	1.28644939965695	0.352427739952939	0.352427739952939	true	false	false	true
de471d8d-10fa-46f1-b23d-903662d0fc9d	2026-09-24 10:03	2026-09-24 10:03	2026-09-24 10:03	TRTX	TRTX270115P00007000	put	7.0000	2027-01-15	0.9000	0.7000	0.9000	6.6900	93690.00	93690.00	0.00	1041	49	2000	136	14.7058823529412	0.523045806624957	0.523045806624957	true	false	false	true
f4f52d92-549c-4753-b480-99bfb4771546	2026-09-24 09:56	2026-09-24 09:56	2026-09-24 09:56	TRTX	TRTX270115P00007000	put	7.0000	2027-01-15	0.8500	0.8500	0.9000	6.7350	18955.00	0.00	85.00	223	37	959	136	7.05147058823529	0.504057111313082	0.504057111313082	false	false	false	true
4383ad19-e9ba-444a-8dbc-fe5e0779bd5b	2026-09-24 09:49	2026-09-24 09:49	2026-09-24 09:49	FRMI	FRMI280121C00010000	call	10.0000	2028-01-21	1.2000	1.2000	1.3500	4.7400	40560.00	0.00	40560.00	338	6	340	12200	0.0278688524590164	0.999794367974539	0.999794367974539	false	false	false	true
18f29eb5-d6e3-4bc7-a2cb-b1abaeb83b43	2026-09-24 09:47	2026-09-24 09:47	2026-09-24 09:47	TRTX	TRTX270115P00007000	put	7.0000	2027-01-15	0.8500	0.8500	1.0000	6.7350	21930.00	0.00	21930.00	258	12	736	136	5.41176470588235	0.504057111313082	0.504057111313082	false	false	false	true
e8a5f5ba-507f-442d-a05f-91e3691f8b52	2026-09-23 15:45	2026-09-23 15:45	2026-09-23 15:45	DLR	DLR261218P00160000	put	160.0000	2026-12-18	3.0000	2.9000	3.0000	182.0000	26400.00	26400.00	0.00	88	7	5060	10898	0.464305377133419	0.336412376176676	0.336412376176676	false	false	false	true
90f99015-622c-41f8-b4e9-182e1aae56ba	2026-09-23 15:42	2026-09-23 15:42	2026-09-23 15:42	DLR	DLR261218P00160000	put	160.0000	2026-12-18	3.0000	2.8500	3.0000	182.0000	92400.00	92400.00	0.00	308	20	4674	10898	0.428886034134704	0.337558723381689	0.337558723381689	false	false	false	true
488e7484-e6f8-4f98-b164-b6fa58890d99	2026-09-23 15:39	2026-09-23 15:39	2026-09-23 15:39	CCI	CCI261016P00070000	put	70.0000	2026-10-16	1.8000	1.6000	1.8000	70.3300	26100.00	26100.00	0.00	145	36	288	1416	0.203389830508475	0.291111442548232	0.291111442548232	false	false	false	true
8c8b0cd1-a8ba-442d-8f98-c1bacb289290	2026-09-23 15:34	2026-09-23 15:34	2026-09-23 15:34	CCI	CCI270319P00065000	put	65.0000	2027-03-19	3.7000	3.4000	3.7000	70.4350	29230.00	29230.00	0.00	79	27	109	27	4.03703703703704	0.351853247030862	0.351853247030862	true	false	false	true
9dc0392e-0ba9-4d6b-85ad-b68b7f741911	2026-09-23 15:32	2026-09-23 15:32	2026-09-23 15:32	VICI	VICI261120C00025000	call	25.0000	2026-11-20	0.3500	0.2000	0.3500	23.7150	17500.00	17500.00	0.00	500	6	768	848	0.905660377358491	0.204042983534519	0.204042983534519	false	false	false	true
ae1dfcf0-e366-4370-a764-4d98375ceec4	2026-09-23 15:02	2026-09-23 15:02	2026-09-23 15:02	PSA	PSA261016P00280000	put	280.0000	2026-10-16	3.2000	2.9500	3.2000	287.9900	26880.00	24640.00	0.00	84	7	128	465	0.275268817204301	0.234610361610063	0.234610361610063	false	false	false	true
d1e04e3d-8b71-4d1a-ad1d-675949ac3b6d	2026-09-23 14:59	2026-09-23 14:58	2026-09-23 14:58	FRMI	FRMI270115C00007500	call	7.5000	2027-01-15	0.5000	0.5000	0.5500	4.8850	13950.00	0.00	13950.00	279	17	410	8590	0.0477299185098952	1.06455910968671	1.06455910968671	false	false	false	true
b26b543b-5d22-4830-981c-57f6bfd712ce	2026-09-23 14:51	2026-09-23 14:50	2026-09-23 14:50	DLR	DLR261218P00160000	put	160.0000	2026-12-18	3.0000	2.9000	3.0000	182.5300	85800.00	85800.00	0.00	286	16	4301	10898	0.394659570563406	0.338321619101121	0.338321619101121	false	false	false	true