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.

281,039 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts281,039 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:alert_rule = RepeatedHitsDescendingFill×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

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	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	Common Stock	Real Estate	3240764781.00	2026-11-09	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-21T19:39:27.785314Z"}	2026-09-21	2026-09-21 21:15	2026-09-21 21:15
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	true
acb065dd-5bd2-4672-945b-496cc60811fd	2026-09-21 10:52	2026-09-21 10:52	2026-09-21 10:52	OPEN	OPEN261030C00003000	call	3.0000	2026-10-30	0.1600	0.1400	0.1800	2.6750	15493.00	13147.00	2016.00	973	53	1281	901	1.42175360710322	0.795497128001562	0.787477369890855	true	false	false
82fe5a75-140b-4f16-8e79-87ab83b00585	2026-09-21 10:37	2026-09-21 10:37	2026-09-21 10:37	VTR	VTR261016C00087500	call	87.5000	2026-10-16	1.7800	1.7000	2.0500	87.2100	32760.00	4900.00	20160.00	184	38	184	62	2.96774193548387	0.192643636569004	0.195019472125863	true	false	false
00fe92b5-5808-4f12-ac43-4db8faf97c6c	2026-09-18 15:41	2026-09-18 15:41	2026-09-18 15:41	GEO	GEO280121C00045000	call	45.0000	2028-01-21	4.0900	4.0000	4.1000	31.5700	163601.00	163601.00	0.00	400	5	2235	8119	0.275280206922035	0.50298522344039	0.500415739891619	false	false	false
8df737e6-841b-485f-9c67-4c538e912674	2026-09-18 13:34	2026-09-18 13:34	2026-09-18 13:34	WELL	WELL261016P00230000	put	230.0000	2026-10-16	6.1000	5.6000	6.2000	228.7348	118934.00	118934.00	0.00	195	39	199	196	1.01530612244898	0.229742226467902	0.229742226467902	false	false	false
6902438b-c918-4323-a4c8-ea2120571eeb	2026-09-18 11:56	2026-09-18 11:56	2026-09-18 11:56	IIPR	IIPR261218P00060000	put	60.0000	2026-12-18	7.7000	7.0000	7.7000	55.4450	54665.00	54665.00	0.00	71	23	72	122	0.590163934426229	0.483754120666639	0.483754120666639	true	false	false
0224f992-cca0-4e0a-b81c-696476c10ab0	2026-09-18 11:09	2026-09-18 11:09	2026-09-18 11:09	VTR	VTR261016C00092500	call	92.5000	2026-10-16	0.3600	0.2000	1.0000	86.9900	17943.00	0.00	17943.00	500	5	500	4	125	0.214797459894416	0.214797459894416	false	false	false	true
d72dda13-39eb-4b96-88e9-e7f2567dd7d2	2026-09-17 15:49	2026-09-17 15:49	2026-09-17 15:49	MAA	MAA261016C00120000	call	120.0000	2026-10-16	3.6000	3.0000	3.8000	121.0000	21218.00	21218.00	0.00	59	5	59	63	0.936507936507937	0.194954519790505	0.194190229684817	false	false	false
20458e9f-d4e5-49cc-be6d-9156e948e51f	2026-09-17 14:58	2026-09-17 14:58	2026-09-17 14:58	PLD	PLD261016P00135000	put	135.0000	2026-10-16	3.5000	3.3000	3.5000	134.9300	117929.00	117929.00	0.00	337	38	382	1306	0.29249617151608	0.242527854951506	0.242527854951506	false	false	false
29cde6ba-0ddc-4289-a994-043e03d2d982	2026-09-17 10:11	2026-09-17 10:11	2026-09-17 10:11	JLL	JLL261016P00380000	put	380.0000	2026-10-16	39.1100	38.6000	40.9000	341.1000	62568.00	0.00	62568.00	16	5	20	5	4	0.290938714714611	0.290938714714611	false	false	false	true
a76461fa-3beb-49dc-b163-ccbd290a14ba	2026-09-16 12:06	2026-09-16 12:06	2026-09-16 12:06	GEO	GEO260918C00030000	call	30.0000	2026-09-18	1.7700	1.7500	2.1000	31.7500	17165.00	0.00	17165.00	97	10	152	1764	0.0861678004535147	0.476698793869279	0.541895664423149	true	false	false
2ef4532b-930c-4494-8cd6-b4bfbad4c695	2026-09-16 10:04	2026-09-16 10:04	2026-09-16 10:04	AGNC	AGNC280121P00008000	put	8.0000	2028-01-21	0.6000	0.6000	0.6500	10.0150	30136.00	0.00	30136.00	500	13	1500	1732	0.866050808314088	0.391038399705996	0.391038399705996	false	false	false
39b9a83d-7456-4954-bc1a-84110eba6d7f	2026-09-15 09:40	2026-09-15 09:39	2026-09-15 09:39	FRMI	FRMI261120C00008000	call	8.0000	2026-11-20	0.3000	0.2500	0.4000	5.0250	22742.00	0.00	22742.00	750	6	750	6051	0.123946455131383	1.18661757735279	1.18661757735279	false	false	false
f32c3245-c606-43ba-a9bc-a33dca2cc738	2026-09-10 11:26	2026-09-10 11:26	2026-09-10 11:26	FRMI	FRMI280121C00017500	call	17.5000	2028-01-21	1.1500	0.9500	1.1500	5.4250	11470.00	11470.00	0.00	100	14	100	4118	0.0242836328314716	1.10498119143437	1.09278917067329	false	false	false
ced1072c-4624-4292-a74e-2ab21fcc5e37	2026-09-09 15:25	2026-09-09 15:24	2026-09-09 15:24	CCI	CCI260918C00075000	call	75.0000	2026-09-18	1.2000	1.2000	1.6500	75.2500	114364.00	0.00	114364.00	953	7	4553	5257	0.866083317481453	0.220132977685733	0.219374034972861	false	false	false
f2323f00-7585-4cb4-bb61-84a9da44de9a	2026-09-09 14:17	2026-09-09 14:17	2026-09-09 14:17	BEKE	BEKE270115C00018000	call	18.0000	2027-01-15	1.2000	1.2000	1.3000	16.8800	56238.00	0.00	56238.00	468	14	560	1880	0.297872340425532	0.393920723956113	0.391400628622583	false	false	false
301d2ed0-7f36-4f69-a1b7-5010ed579bad	2026-09-09 11:26	2026-09-09 11:26	2026-09-09 11:26	FRMI	FRMI270219C00007000	call	7.0000	2027-02-19	1.3000	1.2000	1.3000	5.5150	64800.00	64800.00	0.00	500	9	1050	1484	0.707547169811321	1.1876066306784	1.16023253591812	false	false	false
88548fc4-8798-4ebf-aefa-aae7006a6610	2026-09-09 10:26	2026-09-09 10:25	2026-09-09 10:25	CBRE	CBRE270115C00155000	call	155.0000	2027-01-15	7.4000	6.8000	7.4000	141.0000	275994.00	275994.00	0.00	373	49	374	70	5.34285714285714	0.347322419834547	0.347322419834547	false	false	false
8e2180ef-8856-4562-8d9c-6d69fa7d6ecc	2026-09-08 15:44	2026-09-08 15:44	2026-09-08 15:44	FRMI	FRMI261016C00008000	call	8.0000	2026-10-16	0.2500	0.2500	0.3000	5.7714	13761.00	0.00	13761.00	550	7	724	6428	0.112632233976353	1.14253854419085	1.12535372919734	false	false	false
8954ce23-e036-49ce-810b-f449f63c1a2e	2026-09-08 13:09	2026-09-08 13:09	2026-09-08 13:09	GEO	GEO270115C00040000	call	40.0000	2027-01-15	1.4300	1.3500	1.4500	31.5500	19065.00	18785.00	140.00	133	14	179	9793	0.0182783620953742	0.513648155802458	0.505717748429957	false	false	false
a9ddde04-ceb1-47b9-8cb1-4010de7e5444	2026-09-08 12:15	2026-09-08 12:15	2026-09-08 12:15	FRMI	FRMI261218C00005000	call	5.0000	2026-12-18	1.6900	1.4500	1.8000	5.7750	25324.00	25324.00	0.00	150	9	172	1542	0.111543450064851	1.12372043971877	1.12372043971877	false	false	false
1fa79c23-525c-4d53-ba45-0724f2d576d0	2026-09-08 11:37	2026-09-08 11:37	2026-09-08 11:37	CSGP	CSGP260918P00030000	put	30.0000	2026-09-18	1.0000	0.9500	1.0500	29.8600	13301.00	1100.00	10701.00	133	6	3652	5161	0.707614803332687	0.483374758884145	0.4783030511705	false	false	false
46090efc-0500-4e50-a025-c5d0383ae743	2026-09-08 10:06	2026-09-08 10:06	2026-09-08 10:06	WY	WY280121C00025000	call	25.0000	2028-01-21	2.2100	1.7500	2.5000	22.8000	18783.00	18783.00	0.00	85	10	85	878	0.0968109339407745	0.241724825106074	0.241724825106074	false	false	false	true
4a74be8e-5763-4e00-9419-d1b1e99310b6	2026-09-04 12:36	2026-09-04 12:36	2026-09-04 12:36	FRMI	FRMI260911C00005000	call	5.0000	2026-09-11	0.2400	0.2000	0.3000	4.9850	12584.00	150.00	2434.00	520	8	565	367	1.53950953678474	0.927748220546385	0.927748220546385	false	false	false
04592747-0dc3-4d8f-a695-32e8a2ed53f2	2026-09-04 12:34	2026-09-04 12:34	2026-09-04 12:34	FRMI	FRMI261218C00007500	call	7.5000	2026-12-18	0.5500	0.5000	0.5500	4.9250	97606.00	97606.00	0.00	1775	33	1785	13402	0.133189076257275	1.14824033832086	1.14824033832086	false	false	false
d1a0ba98-a18d-4c23-be2e-52b1208c8c72	2026-09-03 15:02	2026-09-03 15:01	2026-09-03 15:01	GEO	GEO261120P00025000	put	25.0000	2026-11-20	0.7000	0.5500	0.7000	31.6400	77722.00	77722.00	0.00	1111	52	1245	1162	1.07142857142857	0.569072682277509	0.569072682277509	true	false	false
9d03cc70-cfeb-4eed-9431-298526c25f3d	2026-09-03 12:45	2026-09-03 12:45	2026-09-03 12:45	GEO	GEO280121C00045000	call	45.0000	2028-01-21	4.3000	3.3000	4.3000	31.5700	128866.00	128866.00	0.00	300	12	300	6382	0.0470072077718584	0.510765314982741	0.498288571595249	false	false	false
0e5fa0d6-9c99-4008-bc02-2ac9dfc3a6fb	2026-09-03 09:34	2026-09-03 09:33	2026-09-03 09:33	AGNC	AGNC261023C00011000	call	11.0000	2026-10-23	0.2600	0.0900	0.2900	10.7350	15744.00	15697.00	47.00	606	8	611	0	0	0.221737150460782	0.208858462666909	true	false	false	true
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
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
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
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
fc3e06dc-eb5f-4f2b-adc1-022d6850681f	2026-08-31 13:04	2026-08-31 13:04	2026-08-31 13:04	SPG	SPG260918C00210000	call	210.0000	2026-09-18	3.8000	3.4000	3.8000	210.8600	90051.00	90051.00	0.00	237	31	255	607	0.420098846787479	0.168131249635553	0.168131249635553	false	false	false
4d869dcb-dbc1-4d24-a910-be51d91ce7d3	2026-08-28 14:26	2026-08-28 14:26	2026-08-28 14:26	PLD	PLD260918C00145000	call	145.0000	2026-09-18	1.1000	0.7500	1.1000	141.0400	89740.00	89740.00	0.00	816	44	852	2771	0.307470227354746	0.183801019465175	0.183801019465175	false	false	false
118425b1-02ce-4052-8c8e-54ea25cebc39	2026-08-28 13:58	2026-08-28 13:58	2026-08-28 13:58	CCI	CCI260918C00075000	call	75.0000	2026-09-18	2.0300	1.8000	2.0500	75.4700	203150.00	203150.00	0.00	1000	10	1003	153	6.55555555555556	0.246335063858831	0.22714916783301	false	false	false
c31e68a0-4008-41c8-8697-f3736782918a	2026-08-28 12:26	2026-08-28 12:26	2026-08-28 12:26	CSGP	CSGP260918C00030000	call	30.0000	2026-09-18	2.9800	2.5500	3.2000	32.4300	17854.00	17854.00	0.00	60	9	60	432	0.138888888888889	0.470858354939871	0.470858354939871	false	false	false
22c04ae9-bfb7-419b-8e97-2282470dfb2a	2026-08-28 10:15	2026-08-28 10:15	2026-08-28 10:15	MPT	MPT261009P00004500	put	4.5000	2026-10-09	0.5900	0.4100	0.5900	4.1100	46816.00	46762.00	54.00	794	47	802	0	0	0.648331215930351	0.648331215930351	true	false	false	true
4d1d83f8-03bc-4a08-b75e-ca2e4737c1e9	2026-08-27 12:13	2026-08-27 12:13	2026-08-27 12:13	FRMI	FRMI261016C00006000	call	6.0000	2026-10-16	0.6900	0.6500	0.7000	5.5300	17366.00	17366.00	0.00	250	8	368	1689	0.217880402605092	1.07364893407802	1.05832705525905	false	false	false
473bbdf4-999f-4824-b1e6-03eded6ad02b	2026-08-27 12:07	2026-08-27 12:07	2026-08-27 12:07	WELL	WELL261016P00250000	put	250.0000	2026-10-16	14.0000	13.0000	14.0000	239.4800	69991.00	62991.00	0.00	50	18	100	0	0	0.238576719824565	0.238576719824565	true	false	false	true
f072e7e7-5f99-4b8e-9099-406118907176	2026-08-27 10:38	2026-08-27 10:38	2026-08-27 10:38	VICI	VICI260918C00025000	call	25.0000	2026-09-18	1.0600	1.0000	1.1000	25.8900	14675.00	6380.00	8295.00	139	5	840	1010	0.831683168316832	0.178905461309405	0.167092226838081	true	false	false
dacbae12-6df0-4904-811e-14b71bf61a11	2026-08-26 14:12	2026-08-26 14:12	2026-08-26 14:12	VICI	VICI270617P00027500	put	27.5000	2027-06-17	3.2000	3.0000	3.3000	26.0700	18865.00	18233.00	632.00	59	6	557	4671	0.119246414044102	0.309511870259171	0.309511870259171	false	false	false
9ff089da-f6a5-44b5-95b4-37d7d0a7da16	2026-08-26 11:02	2026-08-26 11:02	2026-08-26 11:02	VICI	VICI280121P00025000	put	25.0000	2028-01-21	2.4400	2.4000	2.5000	26.1300	16810.00	12250.00	4560.00	69	10	199	2044	0.0973581213307241	0.306743874300193	0.302235438109546	false	false	false
43b903a0-67c5-40fb-b948-fb2914c81a4c	2026-08-25 13:35	2026-08-25 13:35	2026-08-25 13:35	FRMI	FRMI260828C00006000	call	6.0000	2026-08-28	0.2500	0.2000	0.3000	6.0100	10565.00	10425.00	140.00	423	11	2752	2517	1.09336511720302	1.12419915594269	1.12419915594269	false	false	false
c2313c48-b03b-4e8f-a77a-51ae7ed11416	2026-08-25 12:05	2026-08-25 12:05	2026-08-25 12:05	DLR	DLR261016P00190000	put	190.0000	2026-10-16	6.3000	5.9000	6.3000	192.9300	200326.00	200326.00	0.00	318	43	319	227	1.40528634361233	0.282723665874125	0.282723665874125	false	false	false
270848dc-a6a9-4a24-aed3-e135d0e139ab	2026-08-25 10:14	2026-08-25 10:14	2026-08-25 10:14	VICI	VICI260918P00027500	put	27.5000	2026-09-18	1.5000	1.2500	1.5000	26.4500	14091.00	14091.00	0.00	94	9	275	1897	0.144965735371639	0.336786388179833	0.332811621201571	false	false	false
772b3abf-22d2-4aa4-a728-d0456cdee32c	2026-08-24 14:42	2026-08-24 14:42	2026-08-24 14:42	O	O260918P00062500	put	62.5000	2026-09-18	0.8100	0.8000	0.9000	62.8950	81012.00	172.00	80840.00	1000	7	1401	3326	0.421226698737222	0.17081966357098	0.17081966357098	false	false	false	true
df69fdc8-3554-4497-81d4-5f2d143001d3	2026-08-24 13:59	2026-08-24 13:59	2026-08-24 13:59	OPEN	OPEN270115C00004000	call	4.0000	2027-01-15	0.6400	0.5900	0.6400	3.4800	31900.00	31900.00	0.00	500	8	1218	8753	0.139152290643208	0.928140837891308	0.905144030050411	false	false	false
0ec8dc24-93e8-4653-afe1-ff8343c2fa8c	2026-08-24 09:43	2026-08-24 09:43	2026-08-24 09:43	FRMI	FRMI260828C00005500	call	5.5000	2026-08-28	0.3300	0.3000	0.5500	5.6750	14038.00	0.00	14038.00	420	9	422	1600	0.26375	1.07854303394546	1.07854303394546	false	false	false	true