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.

658,639 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts658,639 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:alert_rule = RepeatedHitsDescendingFill×endpoint = /api/option-trades/flow-alerts×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	strike

10359c6f-3155-4572-8d8f-915046d2c447	2026-10-01 15:40	2026-10-01 15:40	2026-10-01 15:40	WELL	WELL270115P00200000	put	200.0000	2027-01-15	3.5000	2.9500	3.5000	227.4700	13292.00	13292.00	0.00	38	10	574	700	0.82	0.296527897755832	0.296527897755832	false	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	Common Stock	Real Estate	163565859180.00	2026-10-26	postmarket	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-10-01T19:42:36.719976Z"}	2026-10-01	2026-10-01 21:15	2026-10-01 21:15
4fc2b0a4-a2ce-4805-88d2-9e4491df09e2	2026-10-01 12:05	2026-10-01 12:04	2026-10-01 12:04	NLY	NLY270416P00016000	put	16.0000	2027-04-16	0.6200	0.6200	0.6800	18.7100	11798.00	1071.00	10727.00	190	31	321	461	0.696312364425163	0.352328446041207	0.349753504043826	false	false
2192da38-fc91-40e1-98ae-228fa274d1e4	2026-10-01 11:21	2026-10-01 11:21	2026-10-01 11:21	RYN	RYN270521C00017500	call	17.5000	2027-05-21	1.8500	1.8000	1.8500	17.9300	13684.00	13684.00	0.00	74	15	74	29	2.55172413793103	0.240762350086989	0.240762350086989	true	false
2405c2ea-9111-4e00-971d-c3470201ffd9	2026-10-01 10:54	2026-10-01 10:54	2026-10-01 10:54	PLD	PLD261120P00125000	put	125.0000	2026-11-20	3.3000	2.8500	3.5000	127.3900	45529.00	44539.00	990.00	138	20	149	1973	0.0755195134313229	0.252929799423284	0.252402798297721	false	false
2ee612b5-a60a-4552-9a7b-c7d2069d9dd8	2026-10-01 10:24	2026-10-01 10:24	2026-10-01 10:24	FRMI	FRMI261002P00004500	put	4.5000	2026-10-02	0.5700	0.4000	0.6000	4.0100	10445.00	6375.00	1815.00	183	11	402	3944	0.101926977687627	3.29819629225098	2.54446810315354	false	false
ef60f251-3740-4b4b-99bd-6aa9e4c48539	2026-10-01 09:54	2026-10-01 09:54	2026-10-01 09:54	RYN	RYN270115P00017500	put	17.5000	2027-01-15	0.8000	0.7000	0.8000	18.1000	24697.00	24697.00	0.00	309	11	310	720	0.430555555555556	0.307143067213553	0.306170121504892	false	false
1b61977d-73f5-487e-b3be-2e22801296da	2026-10-01 09:54	2026-10-01 09:54	2026-10-01 09:54	RYN	RYN270115P00017500	put	17.5000	2027-01-15	0.8000	0.7000	0.8000	18.0950	15278.00	15278.00	0.00	191	25	501	720	0.695833333333333	0.305677857292636	0.305677857292636	false	false
2680512d-8b1c-4ed4-b0e6-07836aa2e74f	2026-09-30 15:48	2026-09-30 15:48	2026-09-30 15:48	AGNC	AGNC270115P00010000	put	10.0000	2027-01-15	1.2500	1.1800	1.2900	9.0750	18806.00	18806.00	0.00	150	6	766	13707	0.0558838549646166	0.390446568003373	0.390446568003373	false	false
c531b1e1-c36d-45ab-98fb-ba437b3126bc	2026-09-30 15:36	2026-09-30 15:36	2026-09-30 15:36	SBAC	SBAC270319P00155000	put	155.0000	2027-03-19	9.7300	7.8000	9.7000	161.5100	145940.00	132360.00	0.00	150	14	150	16	9.375	0.329915762485957	0.329915762485957	true	false
755fe27a-1f5c-4340-831a-c33868c4a65d	2026-09-30 15:12	2026-09-30 15:12	2026-09-30 15:12	SPG	SPG261016P00200000	put	200.0000	2026-10-16	2.5000	2.2500	2.5000	201.8450	112498.00	112498.00	0.00	450	27	631	908	0.694933920704846	0.208144468617293	0.208144468617293	false	false
ee5a6678-68aa-497b-a2ba-5dcbaa2693c8	2026-09-30 12:53	2026-09-30 12:53	2026-09-30 12:53	EQIX	EQIX261016P01000000	put	1000.0000	2026-10-16	18.6200	14.2000	19.3000	1005.0000	11170.00	9300.00	1870.00	6	5	8	226	0.0353982300884956	0.283729582763921	0.282515790515999	false	false
c934303b-0511-40d3-aac3-b950b374611d	2026-09-30 12:18	2026-09-30 12:18	2026-09-30 12:18	FRMI	FRMI261002C00005000	call	5.0000	2026-10-02	0.1000	0.0500	0.1500	4.3600	24995.00	24971.00	14.00	2501	51	13173	826	15.9479418886199	2.35182511047842	2.35182511047842	true	false
7caca290-1256-431b-8408-e3b0b6590cb9	2026-09-30 10:08	2026-09-30 10:08	2026-09-30 10:08	AMT	AMT261218P00155000	put	155.0000	2026-12-18	3.6200	3.6000	4.3000	165.0000	15550.00	0.00	15180.00	43	19	43	152	0.282894736842105	0.279666291384156	0.275683527341894	false	false
93f0984b-9b93-4ffb-90e6-ffea8067c8cc	2026-09-29 11:23	2026-09-29 11:23	2026-09-29 11:23	DLR	DLR261002P00180000	put	180.0000	2026-10-02	4.0000	3.6000	4.5000	177.2150	147581.00	147191.00	390.00	369	47	372	230	1.61739130434783	0.370796001637644	0.353543362650245	false	false
48a989c0-7d75-43d8-8e10-76eb45e51695	2026-09-28 14:43	2026-09-28 14:43	2026-09-28 14:43	CCI	CCI270115C00067500	call	67.5000	2027-01-15	4.3100	3.9000	4.5000	67.0000	24108.00	24108.00	0.00	56	13	64	2	32	0.284137212317439	0.284137212317439	false	false
ae6fc710-51b5-4a00-b8a4-608d49d1fa87	2026-09-28 13:49	2026-09-28 13:49	2026-09-28 13:49	MRP	MRP261120P00025000	put	25.0000	2026-11-20	0.6500	0.5000	0.6500	26.6950	39950.00	39950.00	0.00	615	52	630	442	1.42533936651584	0.353046653305543	0.353046653305543	false	false
c55c3728-268c-46c5-add2-5cfd819429f4	2026-09-28 11:49	2026-09-28 11:49	2026-09-28 11:49	ABR	ABR270115P00004000	put	4.0000	2027-01-15	0.4500	0.4500	0.5500	3.9350	11950.00	0.00	11950.00	263	16	275	569	0.483304042179262	0.540852032481061	0.529089717188742	false	false
901e00f9-2cd9-40f6-a04c-9876f8db57f9	2026-09-28 10:48	2026-09-28 10:48	2026-09-28 10:48	NLY	NLY261016P00020000	put	20.0000	2026-10-16	0.5300	0.5100	0.5500	20.0000	10275.00	4922.00	5353.00	195	10	347	2239	0.154979901741849	0.421113595794044	0.421113595794044	true	false
8f876d8d-486f-452a-80c7-61da5557acbe	2026-09-25 15:01	2026-09-25 15:01	2026-09-25 15:01	WY	WY261016P00019000	put	19.0000	2026-10-16	0.1500	0.0500	0.1500	19.0000	17717.00	17717.00	0.00	1182	49	1188	135	8.8	0.270572589312492	0.270572589312492	false	false
be1374a2-7bb1-4148-b051-758ef8aa87e1	2026-09-25 11:27	2026-09-25 11:27	2026-09-25 11:27	PSA	PSA261016P00280000	put	280.0000	2026-10-16	3.8100	3.8000	4.4000	284.0000	33150.00	0.00	33150.00	87	17	89	385	0.231168831168831	0.226019150968187	0.225232024590295	false	false
54ed3c03-bb46-4527-90b1-7e4a46f644b3	2026-09-25 10:20	2026-09-25 10:20	2026-09-25 10:20	O	O261016C00057500	call	57.5000	2026-10-16	0.3200	0.1500	0.2500	55.4800	479125.00	479125.00	0.00	15000	32	15009	3257	4.60822843107154	0.178221365373139	0.178508187733782	true	false
4821081a-3e44-48dd-9588-91b09a4c54b1	2026-09-24 14:34	2026-09-24 14:34	2026-09-24 14:34	CCI	CCI261120P00065000	put	65.0000	2026-11-20	1.9500	1.9000	1.9500	68.0650	49118.00	49118.00	0.00	252	39	261	56	4.66071428571429	0.326541837288404	0.326541837288404	false	false
d807ee5d-a7d1-4743-a5cb-ea453d23599c	2026-09-24 12:26	2026-09-24 12:26	2026-09-24 12:26	O	O261120C00055000	call	55.0000	2026-11-20	1.8500	1.8500	2.0000	55.4600	95910.00	2850.00	93060.00	518	9	598	694	0.861671469740634	0.168102900550674	0.168102900550674	false	false
e8749747-9ae7-414f-8941-a56ea37cf48b	2026-09-24 12:26	2026-09-24 12:26	2026-09-24 12:26	O	O261016C00055000	call	55.0000	2026-10-16	1.1000	1.0500	1.1000	55.4300	23974.00	23974.00	0.00	218	37	383	804	0.47636815920398	0.14575033331575	0.14575033331575	false	false
0d26cf1a-7a91-42d5-b471-8fc6cfe1d800	2026-09-24 12:16	2026-09-24 12:16	2026-09-24 12:16	CBRE	CBRE261016P00135000	put	135.0000	2026-10-16	4.4900	3.8000	4.5000	136.6500	34120.00	31040.00	3080.00	76	20	501	4514	0.110988037217545	0.410777094212809	0.40123256598295	true	false
e16581b6-ad80-4d62-b3a3-dadd62cd3935	2026-09-24 12:16	2026-09-24 12:16	2026-09-24 12:16	CBRE	CBRE261016P00135000	put	135.0000	2026-10-16	4.4600	3.2000	4.8000	136.0000	15160.00	8550.00	6610.00	34	9	400	4514	0.0886132033673017	0.402539024421442	0.394930336548546	false	false
c5f0dd13-94e7-4976-9af7-5dbb2efa14a6	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.6500	1.0000	6.7500	40591.00	31921.00	6375.00	478	62	478	136	3.51470588235294	0.516747363085543	0.508855255361923	true	false
92913d1c-d41a-43be-8c62-5aadf3cd8dad	2026-09-23 13:20	2026-09-23 13:20	2026-09-23 13:20	WELL	WELL270115P00210000	put	210.0000	2027-01-15	4.9200	4.8000	5.3000	229.6950	18700.00	11500.00	7200.00	38	7	62	1537	0.0403383214053351	0.274180290666937	0.268990138214678	false	false
e9f115c6-dafa-467c-ac6d-e7d15ac49954	2026-09-23 13:13	2026-09-23 13:13	2026-09-23 13:13	STWD	STWD261218P00014000	put	14.0000	2026-12-18	0.4500	0.3000	0.5000	14.0000	44665.00	44620.00	0.00	993	34	997	136	7.33088235294118	0.298640732987615	0.298640732987615	true	false
104ae18b-96e4-4e0f-8325-886f69e32963	2026-09-23 12:04	2026-09-23 12:04	2026-09-23 12:04	REAX	REAX270416C00022500	call	22.5000	2027-04-16	2.0100	2.0000	2.4500	16.1800	20459.00	0.00	20459.00	102	8	427	102	4.18627450980392	0.777717753347428	0.771342565618088	false	false
76d49b16-f8bd-4fd7-99cf-6351ab010006	2026-09-23 11:03	2026-09-23 11:03	2026-09-23 11:03	BEKE	BEKE261120C00016000	call	16.0000	2026-11-20	1.4500	1.2500	1.4500	16.5500	59133.00	59133.00	0.00	408	29	408	11	37.0909090909091	0.423897373790908	0.419893531775612	false	false
4e1ae9b7-5fee-46cc-b968-a1d4834e4f49	2026-09-22 15:16	2026-09-22 15:16	2026-09-22 15:16	CSGP	CSGP280121C00030000	call	30.0000	2028-01-21	7.0000	7.0000	7.4000	28.8395	16802.00	0.00	16802.00	24	5	45	539	0.0834879406307978	0.516242707207291	0.514647884411964	false	false
5c27619f-d4a8-42b7-9b35-d99b82077d8e	2026-09-22 15:14	2026-09-22 15:14	2026-09-22 15:14	GEO	GEO261016C00031000	call	31.0000	2026-10-16	0.8900	0.8000	0.9000	29.5000	13348.00	13348.00	0.00	150	8	817	1926	0.424195223260644	0.483708504379549	0.480222485535923	false	false
ad464d2e-caf3-475d-9784-4f6d21c451be	2026-09-22 14:25	2026-09-22 14:25	2026-09-22 14:25	CCI	CCI261120P00070000	put	70.0000	2026-11-20	2.1500	2.0500	2.1500	72.9000	44930.00	44930.00	0.00	209	35	210	6	35	0.31392791606036	0.31392791606036	false	false
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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