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:sector = Real Estate×source = uw_flow_alerts×

iduuid	created_at ↓timestamp with time zone	start_timetimestamp with time zone	end_timetimestamp with time zone	tickertext	option_symboltext	option_typetext	strikenumeric	expiry

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	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Real Estate	33360577113.00	2026-11-04	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-31T17:45:10.653528Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
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
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
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	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
0e242ff8-b539-4ec6-8d29-d58c97b3873f	2026-08-28 14:13	2026-08-28 14:13	2026-08-28 14:13	OPEN	OPEN270219C00005000	call	5.0000	2027-02-19	0.4300	0.4000	0.4400	3.3150	53518.00	22396.00	0.00	1250	8	1391	4192	0.331822519083969	0.930158302426743	0.952844140235226	false	false	false	true
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	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
e1c189d4-3a66-4962-96ec-ead8290d5ee8	2026-08-28 12:57	2026-08-28 12:57	2026-08-28 12:57	BEKE	BEKE270115P00017000	put	17.0000	2027-01-15	1.1000	1.0000	1.1500	18.1100	10890.00	10780.00	110.00	99	7	99	816	0.121323529411765	0.392812844499043	0.392812844499043	false	false	false	true
b8251302-a5c0-45de-a605-1c322c5b688f	2026-08-28 12:45	2026-08-28 12:45	2026-08-28 12:45	PLD	PLD261120P00130000	put	130.0000	2026-11-20	2.2500	2.2500	2.4500	140.7300	327619.00	0.00	327619.00	1456	51	1456	438	3.32420091324201	0.253970664903334	0.253970664903334	false	false	false	true
a572e5e3-285c-4eac-8b7f-910491855d40	2026-08-28 12:34	2026-08-28 12:34	2026-08-28 12:34	IRM	IRM260911P00114000	put	114.0000	2026-09-11	1.0500	1.0500	1.3500	118.5100	13860.00	0.00	13860.00	132	6	146	22	6.63636363636364	0.307014943207731	0.307014943207731	false	false	false	true
bb689c2f-4fdc-416c-b1ac-0f000ab7f3d9	2026-08-28 12:33	2026-08-28 12:33	2026-08-28 12:33	AGNC	AGNC260918P00010500	put	10.5000	2026-09-18	0.1000	0.0900	0.1000	10.9150	24070.00	24070.00	0.00	2407	31	12598	591	21.3164128595601	0.256969838171354	0.256969838171354	false	false	false	true
d0c08c02-cba6-49ff-8a38-72fe5541acf9	2026-08-28 12:28	2026-08-28 12:28	2026-08-28 12:28	AGNC	AGNC260918P00010500	put	10.5000	2026-09-18	0.0900	0.0800	0.0900	10.9300	47502.00	47502.00	0.00	5278	53	9571	591	16.1945854483926	0.248997100867737	0.248997100867737	false	false	false	true