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

06ad3477-a1ad-4c43-8508-65d200a8940a	2026-09-01 10:06	2026-09-01 10:05	2026-09-01 10:05	DLR	DLR270917P00160000	put	160.0000	2027-09-17	11.5000	11.5000	12.5000	184.5100	115000.00	0.00	5750.00	100	33	100	502	0.199203187250996	0.352979830831119	0.352979830831119	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Real Estate	66288280569.00	2026-10-22	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-01T14:20:18.853903Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
e8c84072-ae65-4c2f-b916-a98d57b21c20	2026-09-01 09:54	2026-09-01 09:54	2026-09-01 09:54	AGNC	AGNC261002P00010000	put	10.0000	2026-10-02	0.0900	0.0600	0.0900	10.7105	18774.00	18774.00	0.00	2086	10	7594	271	28.0221402214022	0.282685927512062	0.282685927512062	false	false	false	true
89e0da49-34e9-42a3-99f9-25e30a1fce95	2026-09-01 09:54	2026-09-01 09:54	2026-09-01 09:54	AGNC	AGNC261002P00010000	put	10.0000	2026-10-02	0.0900	0.0800	0.0900	10.7100	13941.00	13941.00	0.00	1549	6	5508	271	20.3247232472325	0.282575875550963	0.282575875550963	false	false	false	true
762348db-aa15-4a22-8239-97f7da9f7930	2026-09-01 09:50	2026-09-01 09:50	2026-09-01 09:50	OPEN	OPEN270115P00003000	put	3.0000	2027-01-15	0.5500	0.5200	0.5500	3.0400	55495.00	55495.00	0.00	1009	6	1009	4415	0.228539071347678	0.814855276485436	0.814855276485436	false	false	false	true
f22a3c60-95f5-40ba-8af3-67925e80115b	2026-09-01 09:41	2026-09-01 09:41	2026-09-01 09:41	FRMI	FRMI280121C00010000	call	10.0000	2028-01-21	1.4500	1.4000	1.4500	4.7914	46400.00	46400.00	0.00	320	6	333	6119	0.0544206569700931	1.07876448045924	1.07876448045924	false	false	false	true
c8903470-c353-4863-8583-e5de41df4342	2026-08-31 15:03	2026-08-31 15:03	2026-08-31 15:03	MPT	MPT270115C00005000	call	5.0000	2027-01-15	0.0600	0.0500	0.0600	3.9550	24660.00	24660.00	0.00	4110	61	6903	22501	0.306786365050442	0.325170987306525	0.325170987306525	false	false	false	true
7e84b1d0-8a4d-489f-90bf-2cf5fc746ba5	2026-08-31 15:02	2026-08-31 15:02	2026-08-31 15:02	MPT	MPT270115C00005000	call	5.0000	2027-01-15	0.0600	0.0500	0.0600	3.9550	13524.00	13524.00	0.00	2254	26	2793	22501	0.124127816541487	0.325170987306525	0.325170987306525	false	false	false	true
84ee73db-3a5a-49b9-82db-970412437b21	2026-08-31 14:48	2026-08-31 14:48	2026-08-31 14:48	ESS	ESS270416C00290000	call	290.0000	2027-04-16	15.6000	14.8000	15.6000	282.7800	12480.00	12480.00	0.00	8	5	8	0	0	0.174447664426754	0.17403107432767	false	false	false	true
664d5c11-ce9a-4624-b226-c066a07e2ef9	2026-08-31 14:20	2026-08-31 14:20	2026-08-31 14:20	EQIX	EQIX261120C01170000	call	1170.0000	2026-11-20	23.1000	21.2000	23.1000	1035.0000	127050.00	127050.00	0.00	55	11	59	34	1.73529411764706	0.319854835667542	0.319854835667542	false	false	false	true
4a01ccbe-3f03-4ec2-8ac5-eb358d5833df	2026-08-31 14:04	2026-08-31 14:04	2026-08-31 14:04	CXW	CXW261120C00034000	call	34.0000	2026-11-20	2.9000	2.8000	3.1000	33.0000	162400.00	131080.00	31320.00	560	5	600	192	3.125	0.485744485712853	0.485744485712853	false	false	false	true
f604c99c-6e7b-42cb-87e0-4b0d8c6039dd	2026-08-31 14:04	2026-08-31 14:04	2026-08-31 14:04	FRMI	FRMI261016C00008000	call	8.0000	2026-10-16	0.1700	0.1000	0.2000	4.0000	11815.00	11815.00	0.00	695	5	1078	4305	0.250406504065041	1.19240830947136	1.19240830947136	false	false	false	true
e5b2939a-f208-476b-bd77-9884f5e4635a	2026-08-31 13:32	2026-08-31 13:32	2026-08-31 13:32	IRM	IRM261016P00115000	put	115.0000	2026-10-16	5.5000	5.5000	5.6000	114.3500	45102.00	0.00	45102.00	82	24	101	27	3.74074074074074	0.336832389507253	0.336832389507253	false	false	false	true
7c30b19c-8c9f-45d4-be57-950a29c3a6f4	2026-08-31 13:32	2026-08-31 13:31	2026-08-31 13:31	VICI	VICI270617P00027500	put	27.5000	2027-06-17	3.3000	3.1000	3.3000	25.7650	17160.00	17160.00	0.00	52	5	443	5267	0.0841086007214733	0.307985749544037	0.307985749544037	false	false	false	true
ddbc9be0-d572-4a2a-940d-9bcf8fbd5842	2026-08-31 13:19	2026-08-31 13:18	2026-08-31 13:18	MPT	MPT280121P00004000	put	4.0000	2028-01-21	0.8500	0.8200	0.8500	3.9650	11475.00	11475.00	0.00	135	10	336	5958	0.0563947633434038	0.52879404386985	0.52879404386985	false	false	false	true
1d8542cd-ff7d-4220-bdbe-8a550bade94a	2026-08-31 13:17	2026-08-31 13:17	2026-08-31 13:17	MPT	MPT280121P00004000	put	4.0000	2028-01-21	0.8500	0.8200	0.8500	3.9600	17000.00	16915.00	0.00	200	17	200	5958	0.0335683115139309	0.527788852512959	0.527788852512959	true	false	false	true
7c6bb3cc-c33e-4f4f-9c5a-cdc48f66aef6	2026-08-31 13:17	2026-08-31 13:17	2026-08-31 13:17	FRMI	FRMI261016C00006000	call	6.0000	2026-10-16	0.4200	0.3500	0.4500	4.9450	12306.00	12306.00	0.00	293	5	339	2249	0.15073365940418	1.08959577256055	1.08959577256055	false	false	false	true
3f6f9a3b-f6ea-4626-acd9-adcf37dd7f6f	2026-08-31 13:14	2026-08-31 13:13	2026-08-31 13:13	IRM	IRM261016C00130000	call	130.0000	2026-10-16	0.8500	0.7500	0.8500	114.2200	12325.00	12325.00	0.00	145	19	187	660	0.283333333333333	0.308778020701476	0.308778020701476	false	false	false	true
588a6ca4-c8a2-4e27-a204-b67157882194	2026-08-31 12:58	2026-08-31 12:58	2026-08-31 12:58	GEO	GEO260918C00033000	call	33.0000	2026-09-18	0.8000	0.8000	0.8000	31.9950	24000.00	0.00	0.00	300	10	1618	2288	0.707167832167832	0.422076361877833	0.422076361877833	false	false	false	true
bd3f8097-e0dd-4341-9f43-a0cd7e7eaa54	2026-08-31 12:42	2026-08-31 12:42	2026-08-31 12:42	MPT	MPT261016P00004000	put	4.0000	2026-10-16	0.2300	0.2200	0.2300	3.9850	25737.00	25737.00	0.00	1119	17	1248	2325	0.536774193548387	0.412018772036445	0.412018772036445	false	false	false	true
8e6d2be4-77cf-4f57-97bf-582903269e17	2026-08-31 12:32	2026-08-31 12:32	2026-08-31 12:32	GEO	GEO260918C00033000	call	33.0000	2026-09-18	0.7500	0.7500	0.7500	31.8200	30000.00	0.00	0.00	400	15	1278	2288	0.558566433566434	0.428567194478649	0.428567194478649	false	false	false	true
c565527d-9e72-4cfd-85b4-2b56bc1d8ccf	2026-08-31 12:04	2026-08-31 12:04	2026-08-31 12:04	OPEN	OPEN261120C00004000	call	4.0000	2026-11-20	0.2600	0.2600	0.3000	3.1999	39468.00	0.00	39468.00	1518	6	3015	15588	0.193418013856813	0.843028460771985	0.843028460771985	false	false	false	true
2406aa66-20e9-405d-87b4-eb82e80187fe	2026-08-31 12:01	2026-08-31 12:00	2026-08-31 12:00	GEO	GEO260918C00033000	call	33.0000	2026-09-18	0.7500	0.7000	0.8000	31.7600	22575.00	2775.00	0.00	301	14	865	2288	0.378059440559441	0.432769488571149	0.436958973728207	false	false	false	true
292c6d5c-bf2f-4d46-82f0-bd3e1f8795a4	2026-08-31 12:00	2026-08-31 11:59	2026-08-31 11:59	BXP	BXP260918C00065000	call	65.0000	2026-09-18	4.0000	4.0000	4.2000	68.3400	126000.00	0.00	126000.00	315	33	315	10	31.5	0.296641501616717	0.296641501616717	false	false	false	true
a59f90c9-a7cf-41b8-a0b1-ec1a4f11a952	2026-08-31 11:45	2026-08-31 11:44	2026-08-31 11:44	OPEN	OPEN280121C00010000	call	10.0000	2028-01-21	0.5700	0.5600	0.5900	3.1800	13110.00	12825.00	285.00	230	6	355	42346	0.00838331837717848	1.0058482464476	1.0058482464476	false	false	false	true
6b0c3b6d-2c96-49e0-8c34-62cadbeb5eda	2026-08-31 11:39	2026-08-31 11:39	2026-08-31 11:39	IRM	IRM260918P00115000	put	115.0000	2026-09-18	3.9000	3.6000	3.9000	114.4000	38220.00	38220.00	0.00	98	24	116	4842	0.0239570425444031	0.365116850749098	0.365116850749098	false	false	false	true
4d0e5634-3839-4614-b69c-6b187c1671ff	2026-08-31 11:26	2026-08-31 11:26	2026-08-31 11:26	AGNC	AGNC260911C00010500	call	10.5000	2026-09-11	0.3500	0.3500	0.4200	10.7800	16485.00	0.00	16485.00	471	9	550	9	61.1111111111111	0.223265239340813	0.223265239340813	false	false	false	true
f5b9aee7-346d-4fcb-bebc-66b2eaee3442	2026-08-31 11:25	2026-08-31 11:25	2026-08-31 11:25	GEO	GEO260918C00033000	call	33.0000	2026-09-18	0.8000	0.8000	0.8000	31.9200	21040.00	0.00	0.00	263	8	524	2288	0.229020979020979	0.432884247313272	0.432884247313272	false	false	false	true
363332d5-1658-4704-bdd3-98cb9ff4afcf	2026-08-31 11:11	2026-08-31 11:11	2026-08-31 11:11	WELL	WELL270521P00210000	put	210.0000	2027-05-21	7.7000	7.7000	7.9000	234.2050	75462.00	0.00	75462.00	98	9	798	14	57	0.25965413806454	0.25965413806454	true	false	false	true
af3d29ee-a86b-444b-86ef-bfb03f057296	2026-08-31 11:08	2026-08-31 11:08	2026-08-31 11:08	WELL	WELL270521P00210000	put	210.0000	2027-05-21	7.4000	7.4000	7.9000	234.6300	66600.00	0.00	66600.00	90	5	635	14	45.3571428571429	0.256262466529566	0.256262466529566	true	false	false	true
fa399bd4-7226-4e52-864c-dcc0fdea9751	2026-08-31 10:58	2026-08-31 10:57	2026-08-31 10:57	VICI	VICI260918P00025000	put	25.0000	2026-09-18	0.2200	0.2000	0.2500	25.8150	21516.00	0.00	21516.00	978	6	1224	4868	0.251437962202136	0.242967668865176	0.242967668865176	false	false	false	true
b55600e2-8e43-40c8-9065-1e05e129669c	2026-08-31 10:57	2026-08-31 10:57	2026-08-31 10:57	FRMI	FRMI270115C00010000	call	10.0000	2027-01-15	0.4000	0.4000	0.4500	4.9150	17760.00	0.00	17760.00	444	9	485	70522	0.00687728652051842	1.14715770662839	1.14715770662839	false	false	false	true
df23d270-2bd5-45ea-a22d-436c63de6aaa	2026-08-31 10:46	2026-08-31 10:46	2026-08-31 10:46	WELL	WELL270521P00210000	put	210.0000	2027-05-21	7.5000	7.5000	9.9000	235.0000	131250.00	0.00	131250.00	175	24	175	14	12.5	0.25932838460954	0.25932838460954	true	false	false	true
922c1cec-769e-49df-a751-a2bbc41810b3	2026-08-31 10:42	2026-08-31 10:42	2026-08-31 10:42	MPT	MPT281215P00002500	put	2.5000	2028-12-15	0.4200	0.3200	0.4400	4.0000	168000.00	164052.00	3948.00	4000	47	8003	7597	1.0534421482164	0.602526354127496	0.602007692095239	false	false	false	true
0830db88-25ff-41a7-aaa9-b3dc2e0b1b96	2026-08-31 10:41	2026-08-31 10:41	2026-08-31 10:41	MPT	MPT281215P00002500	put	2.5000	2028-12-15	0.4200	0.3200	0.4400	4.0050	93534.00	79590.00	11676.00	2227	20	3230	7597	0.425167829406345	0.603560773098439	0.602526354127496	false	false	false	true
39461b9c-080a-48ee-8c20-925d73c621ae	2026-08-31 10:33	2026-08-31 10:33	2026-08-31 10:33	INVH	INVH270115C00030000	call	30.0000	2027-01-15	1.1000	0.7000	1.1000	28.9250	22000.00	18700.00	0.00	200	14	200	187	1.06951871657754	0.197323883099728	0.197323883099728	false	false	false	true
dc4c4801-9dee-45ed-b5d6-cf212b4cbf69	2026-08-31 10:31	2026-08-31 10:31	2026-08-31 10:31	CXW	CXW261120C00033000	call	33.0000	2026-11-20	3.4000	3.2000	3.9000	33.4700	42840.00	25500.00	17340.00	126	6	150	1860	0.0806451612903226	0.484692096086908	0.484692096086908	false	false	false	true
15932662-3a62-4f88-b9e2-d6ec6d2571e6	2026-08-31 10:24	2026-08-31 10:24	2026-08-31 10:24	CXW	CXW261120P00029000	put	29.0000	2026-11-20	1.1000	0.8500	1.3000	33.7200	67980.00	55000.00	12980.00	618	15	618	1	618	0.503210373977494	0.503210373977494	false	false	false	true
d5e60c25-b1bc-4bfb-93f7-7676f26fddfa	2026-08-31 10:19	2026-08-31 10:19	2026-08-31 10:19	RYN	RYN270219P00020000	put	20.0000	2027-02-19	1.2000	1.2000	1.2500	20.3550	12000.00	0.00	12000.00	100	15	117	600	0.195	0.278054607775569	0.278054607775569	false	false	false	true
f389b34e-255d-4e17-a8ec-cd3ca706952a	2026-08-31 10:18	2026-08-31 10:18	2026-08-31 10:18	EQIX	EQIX261120C01060000	call	1060.0000	2026-11-20	58.1000	54.4000	58.8000	1034.8400	557760.00	546140.00	11620.00	96	33	96	3	32	0.336104797786704	0.336104797786704	false	false	false	true
2bdc363f-7be7-47a6-a6f5-bebe9c322e42	2026-08-31 09:42	2026-08-31 09:42	2026-08-31 09:42	NLY	NLY270416P00023000	put	23.0000	2027-04-16	2.3000	2.2000	2.3500	22.8650	23000.00	4600.00	18400.00	100	6	400	114	3.50877192982456	0.354249431952988	0.354249431952988	false	false	false	true
ce3c3404-f163-461c-9e42-d134d81e7665	2026-08-31 09:40	2026-08-31 09:40	2026-08-31 09:40	OPEN	OPEN280616C00004000	call	4.0000	2028-06-16	1.4500	1.4500	1.5100	3.2250	10585.00	0.00	10585.00	73	15	180	35	5.14285714285714	0.965087175641716	0.972159933018366	false	false	false	true
2e37cbee-13e5-4d3e-83ff-b8d16a29fe68	2026-08-31 09:39	2026-08-31 09:39	2026-08-31 09:39	OPEN	OPEN280616C00004000	call	4.0000	2028-06-16	1.4500	1.4150	1.5200	3.2450	14790.00	0.00	12035.00	102	7	107	35	3.05714285714286	0.962676988772194	0.962676988772194	false	false	false	true
a3d93024-fe32-44ad-8a5c-4428917868b2	2026-08-31 09:36	2026-08-31 09:36	2026-08-31 09:36	WPC	WPC261016P00070000	put	70.0000	2026-10-16	1.8000	1.7000	1.8500	70.0000	21413.00	17273.00	0.00	119	18	350	949	0.368809272918862	0.198750135644055	0.198750135644055	false	false	false	true
7d2086d5-f981-4197-9323-0e5de59b8569	2026-08-31 09:34	2026-08-31 09:34	2026-08-31 09:34	OPEN	OPEN260911P00003000	put	3.0000	2026-09-11	0.0700	0.0700	0.1000	3.2300	15022.00	0.00	15022.00	2146	5	2151	1531	1.40496407576747	0.744941507552831	0.744941507552831	false	false	false	true
122af8a6-c744-4c48-8eb2-7e3446bd2c4d	2026-08-28 15:33	2026-08-28 15:33	2026-08-28 15:33	CIGI	CIGI261016P00105000	put	105.0000	2026-10-16	5.2000	4.6000	5.2000	103.0050	32240.00	32240.00	0.00	62	17	62	1	62	0.292445365958319	0.292445365958319	false	false	false	true
d7ecc13d-319d-4c74-a995-5b773d139e0b	2026-08-28 15:06	2026-08-28 15:05	2026-08-28 15:05	CCI	CCI260918C00075000	call	75.0000	2026-09-18	2.3000	2.1000	2.3000	75.8600	230000.00	69000.00	0.00	1000	6	2004	153	13.0980392156863	0.2413824594858	0.2413824594858	false	false	false	true
57465618-e0b2-40eb-b64d-8707f0533af5	2026-08-28 14:18	2026-08-28 14:18	2026-08-28 14:18	AGNC	AGNC260918P00010500	put	10.5000	2026-09-18	0.1000	0.0900	0.1100	10.9150	10730.00	4530.00	0.00	1073	11	18563	591	31.409475465313	0.256969838171354	0.256969838171354	false	false	false	true
424a1971-56a9-460e-a188-9f8fb352bae5	2026-08-28 13:33	2026-08-28 13:32	2026-08-28 13:32	ESS	ESS261016P00280000	put	280.0000	2026-10-16	7.7000	7.7000	8.1000	282.0800	67760.00	0.00	67760.00	88	23	88	16	5.5	0.228246316071	0.228246316071	false	false	false	true
2b6d9c93-fc6b-49c4-9b5a-9c4b170a2748	2026-08-28 13:30	2026-08-28 13:30	2026-08-28 13:30	ESS	ESS270416P00290000	put	290.0000	2027-04-16	22.9000	21.3000	23.6000	282.0600	80149.00	41219.00	38930.00	35	11	35	0	0	0.252487629402214	0.252487629402214	false	false	false	true
5e973132-40d5-47ea-b53f-e64bc85baaa9	2026-08-28 13:07	2026-08-28 13:07	2026-08-28 13:07	RITM	RITM260918C00010000	call	10.0000	2026-09-18	0.2500	0.2500	0.3000	10.0800	20250.00	0.00	20250.00	810	9	1053	8101	0.129983952598445	0.20303020906462	0.20303020906462	false	false	false	true