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

d3c82c68-236e-4571-b182-3a7a10d8b991	2026-09-01 10:44	2026-09-01 10:44	2026-09-01 10:44	DLR	DLR260904C00185000	call	185.0000	2026-09-04	1.4000	1.0000	1.4000	183.0300	58660.00	58660.00	0.00	419	43	420	9	46.6666666666667	0.334592250059893	0.334592250059893	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:59:17.018627Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
becbbeb0-73f7-4ac3-bdf5-494c532090e8	2026-09-01 10:44	2026-09-01 10:44	2026-09-01 10:44	DLR	DLR270319P00160000	put	160.0000	2027-03-19	6.9000	6.9000	7.1000	183.2900	51060.00	0.00	51060.00	74	12	120	900	0.133333333333333	0.342990261503974	0.342990261503974	false	false	false	true
59017133-a5b9-4e52-a7da-52e694f63f9c	2026-09-01 10:34	2026-09-01 10:34	2026-09-01 10:34	DLR	DLR280121P00160000	put	160.0000	2028-01-21	14.4000	14.4000	14.7000	182.9700	115200.00	0.00	115200.00	80	7	258	310	0.832258064516129	0.355679498911882	0.355679498911882	false	false	false	true
efe070aa-fc8b-42ee-9402-570684aef41c	2026-09-01 10:30	2026-09-01 10:30	2026-09-01 10:30	DLR	DLR280121P00160000	put	160.0000	2028-01-21	14.4000	14.4000	15.1000	182.9100	112320.00	0.00	7200.00	78	34	78	310	0.251612903225806	0.355460389436322	0.355460389436322	false	false	false	true
d0d05333-32f6-410a-ad83-e0b14059e51e	2026-09-01 10:17	2026-09-01 10:17	2026-09-01 10:17	DLR	DLR270617P00160000	put	160.0000	2027-06-17	9.8000	9.8000	10.3000	182.9500	113680.00	0.00	105840.00	116	42	116	800	0.145	0.351309088054898	0.351309088054898	false	false	false	true
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
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
2a9d3383-7eb3-4633-9a47-f3517d3f3bcf	2026-08-31 15:20	2026-08-31 15:20	2026-08-31 15:20	VICI	VICI270319P00025000	put	25.0000	2027-03-19	1.5000	1.5000	1.6000	25.7250	16055.00	0.00	16055.00	107	19	122	632	0.193037974683544	0.281459358263226	0.281459358263226	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
745dc5d5-3abf-4db9-aff1-40fe9af00b70	2026-08-31 13:48	2026-08-31 13:48	2026-08-31 13:48	PSA	PSA270521P00280000	put	280.0000	2027-05-21	13.1000	12.0000	13.3000	306.0000	196500.00	196500.00	0.00	150	1	151	0	0	0.276664525131208	0.276664525131208	false	true	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
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	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
c220e9d4-4140-454e-b075-6efe7e6f5274	2026-08-31 09:49	2026-08-31 09:49	2026-08-31 09:49	IRM	IRM261218P00110000	put	110.0000	2026-12-18	6.4600	6.3000	6.6000	114.5000	29050.00	16890.00	0.00	45	34	88	107	0.822429906542056	0.370559697531524	0.37482854696223	false	false	false	true
5f830812-87cc-4824-bf3a-54f5379c0526	2026-08-31 09:49	2026-08-31 09:49	2026-08-31 09:49	IRM	IRM261218P00110000	put	110.0000	2026-12-18	6.4100	6.1000	6.8000	114.5000	24350.00	6460.00	640.00	38	38	43	107	0.401869158878505	0.366288124637283	0.37482854696223	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