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

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	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	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-31T14:02:22.723941Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
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
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
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
2425c556-7e96-4f84-9755-565620691683	2026-08-28 10:18	2026-08-28 10:17	2026-08-28 10:17	MPT	MPT261009P00004500	put	4.5000	2026-10-09	0.5900	0.4100	0.5900	4.0900	143003.00	143003.00	0.00	2444	29	3716	0	0	0.605863598659298	0.624959466763404	true	false	false	true
70f3039c-38fc-40cb-b4c5-4a8a23a8f331	2026-08-28 09:36	2026-08-28 09:36	2026-08-28 09:36	BEKE	BEKE261016P00018000	put	18.0000	2026-10-16	0.7000	0.6000	0.7000	18.4360	42050.00	42050.00	0.00	601	37	601	5027	0.119554406206485	0.35061559451877	0.354485666486382	false	false	false
690d5eee-6b38-4f96-9143-2dd2595a0092	2026-08-28 09:33	2026-08-28 09:33	2026-08-28 09:33	RITM	RITM260918P00011000	put	11.0000	2026-09-18	0.9000	0.9000	0.9500	10.1000	22596.00	94.00	22502.00	251	12	367	2688	0.136532738095238	0.250693393913111	0.250693393913111	false	false	false
06badad6-4403-42f7-ad7f-ddf67f75f012	2026-08-27 15:57	2026-08-27 15:56	2026-08-27 15:56	VICI	VICI260918P00025000	put	25.0000	2026-09-18	0.2500	0.2000	0.2500	25.7750	22880.00	22814.00	66.00	917	28	1531	3797	0.40321306294443	0.216024208893686	0.216024208893686	false	false	false
c5bd4fc9-fe73-4323-baca-67c6108fe22c	2026-08-27 14:41	2026-08-27 14:41	2026-08-27 14:41	FRMI	FRMI270219C00010000	call	10.0000	2027-02-19	0.7700	0.7000	0.8000	5.4600	77289.00	77289.00	0.00	1000	35	1017	752	1.35239361702128	1.1479002363209	1.18269283511126	true	false	false
d8f5f004-f8f7-4ed9-9765-80d3e342be9f	2026-08-27 13:45	2026-08-27 13:45	2026-08-27 13:45	STWD	STWD270319P00016000	put	16.0000	2027-03-19	1.1900	1.0000	1.2500	15.9850	26460.00	23485.00	2975.00	222	13	694	1793	0.387060791968767	0.28107593807974	0.287505568440147	false	false	false
3d845f3c-c014-4084-a24d-ee47238da2fe	2026-08-27 09:55	2026-08-27 09:55	2026-08-27 09:55	CCI	CCI260918P00085000	put	85.0000	2026-09-18	10.9600	9.9000	12.1000	75.1200	16444.00	0.00	16444.00	15	7	15	266	0.056390977443609	0.583725089228049	0.583725089228049	false	false	false	true
5fb5a890-c2d4-44bd-96d8-fafb09d11581	2026-08-26 13:50	2026-08-26 13:50	2026-08-26 13:50	WELL	WELL270521P00220000	put	220.0000	2027-05-21	8.8200	8.8000	10.2000	241.9100	149081.00	2880.00	146201.00	169	28	847	21	40.3333333333333	0.25534505316199	0.267432535960572	true	false	false
aa769c4e-c4ba-48d1-a943-3ae05567a7bb	2026-08-26 13:43	2026-08-26 13:42	2026-08-26 13:42	WELL	WELL270521C00230000	call	230.0000	2027-05-21	28.6300	28.6000	30.1000	242.2400	246180.00	2940.00	243240.00	86	24	102	5	20.4	0.220792839308646	0.231975092785743	true	false	false
4584e9b2-9f00-41da-a1a0-054e8ef76d5b	2026-08-26 13:43	2026-08-26 13:42	2026-08-26 13:42	WELL	WELL270319C00220000	call	220.0000	2027-03-19	32.4200	32.2000	34.5000	242.2550	324243.00	39690.00	284553.00	100	24	112	2	56	0.21937710345331	0.226949473987435	true	false	false	true
a951bbdd-b6e9-4e6b-a1f4-72b641205e6b	2026-08-26 11:41	2026-08-26 11:41	2026-08-26 11:41	WELL	WELL270521P00220000	put	220.0000	2027-05-21	8.9100	8.9000	10.2000	242.0100	95320.00	970.00	94350.00	107	22	209	21	9.95238095238095	0.257244399014163	0.269316019870491	true	false	false
e01d2e6d-1bd8-4882-8e57-faa40d81cb2a	2026-08-26 11:37	2026-08-26 11:37	2026-08-26 11:37	WELL	WELL270319P00230000	put	230.0000	2027-03-19	10.2100	10.2000	11.6000	241.7500	103110.00	1100.00	102010.00	101	21	207	2	103.5	0.249140727743553	0.261524083113248	true	false	false	true
3dc84d56-364b-46e8-afba-903714dc9f06	2026-08-26 11:36	2026-08-26 11:36	2026-08-26 11:36	WELL	WELL270521P00240000	put	240.0000	2027-05-21	17.0300	16.9000	18.3000	241.4500	315000.00	52860.00	262140.00	185	15	512	0	0	0.258879756999199	0.262501586525095	true	false	false	true
ae741c45-7e56-41fb-ad5e-bff3527b5430	2026-08-26 11:35	2026-08-26 11:34	2026-08-26 11:35	WELL	WELL270521P00240000	put	240.0000	2027-05-21	17.2500	17.1000	18.3000	241.6050	391602.00	40510.00	351092.00	227	35	327	0	0	0.262330711527597	0.264523727626239	true	false	false	true
797b3878-9798-4515-a9bf-d2b4bb424ef0	2026-08-26 11:33	2026-08-26 11:33	2026-08-26 11:33	WELL	WELL270319C00240000	call	240.0000	2027-03-19	19.5500	19.5000	22.7000	241.5950	219000.00	10300.00	208700.00	112	22	112	74	1.51351351351351	0.222029875943891	0.237763419662143	true	false	false
812d9829-7651-4074-8dbd-16e5bd6d3edb	2026-08-26 11:32	2026-08-26 11:32	2026-08-26 11:32	WELL	WELL270521C00250000	call	250.0000	2027-05-21	18.5400	18.5000	21.2000	241.6000	172442.00	5940.00	166502.00	93	20	108	80	1.35	0.230701244736895	0.246490945861154	true	false	false
12a74b95-1ae4-47f7-ae48-a379132b2608	2026-08-26 11:32	2026-08-26 11:32	2026-08-26 11:32	WELL	WELL270319P00240000	put	240.0000	2027-03-19	14.8000	14.2000	16.7000	241.6000	118431.00	48050.00	70381.00	80	10	80	54	1.48148148148148	0.246934502231815	0.264066664538352	true	false	false
f59d960a-2450-4b50-a221-c7b66d4f5cea	2026-08-26 11:02	2026-08-26 11:02	2026-08-26 11:02	CXW	CXW261218P00034000	put	34.0000	2026-12-18	3.4000	3.4000	3.6000	33.4800	125820.00	0.00	125820.00	370	35	370	3	123.333333333333	0.448562584618653	0.448562584618653	false	false	false	true
781f8330-244a-4224-b82e-c91b65547160	2026-08-25 11:41	2026-08-25 11:41	2026-08-25 11:41	OPEN	OPEN260904C00003500	call	3.5000	2026-09-04	0.2100	0.1900	0.2100	3.5650	20999.00	20999.00	0.00	1000	29	2723	2594	1.0497301464919	0.701251753153791	0.74479395465024	false	false	false
db412985-56f6-4dfd-a597-3e95df57a933	2026-08-25 10:37	2026-08-25 10:37	2026-08-25 10:37	OPEN	OPEN270115C00005000	call	5.0000	2027-01-15	0.4500	0.3900	0.4500	3.5400	22264.00	21424.00	0.00	498	28	523	29461	0.0177522826787957	0.938132457314056	0.926388854548121	false	false	false
80fc95cf-32f7-46a7-8204-5cfed0b101d3	2026-08-25 10:10	2026-08-25 10:10	2026-08-25 10:10	FRMI	FRMI261016C00007000	call	7.0000	2026-10-16	0.5100	0.5000	0.6500	5.7200	20213.00	0.00	20213.00	400	9	424	3885	0.109137709137709	1.0562351175405	1.07067003819261	false	false	false
04646d73-b124-47c8-bc08-ddc772f4307c	2026-08-24 14:38	2026-08-24 14:37	2026-08-24 14:37	O	O260918C00062500	call	62.5000	2026-09-18	1.0500	1.0500	1.1000	62.8900	105004.00	0.00	105004.00	1000	47	1250	6977	0.179160097463093	0.111385014407992	0.113390269873197	true	false	false	true
076279af-25c2-4159-a05f-035252e71f28	2026-08-24 14:19	2026-08-24 14:19	2026-08-24 14:19	OHI	OHI270115C00050000	call	50.0000	2027-01-15	1.3000	1.3000	1.4500	46.7100	13002.00	0.00	13002.00	100	5	117	834	0.140287769784173	0.195414998743483	0.19632823846313	false	false	false	true
d9ac207f-e9a5-4e33-86e3-6ea7d86dd751	2026-08-24 11:37	2026-08-24 11:37	2026-08-24 11:37	VICI	VICI270617P00027500	put	27.5000	2027-06-17	2.8000	2.6000	2.8000	26.7599	28545.00	28545.00	0.00	102	9	389	4049	0.0960731044702396	0.294812775200692	0.300067379118562	false	false	false
a1172083-8aa3-4212-8741-bceb1c765474	2026-08-21 14:49	2026-08-21 14:49	2026-08-21 14:49	GEO	GEO260821C00029000	call	29.0000	2026-08-21	3.3800	3.3000	3.5000	32.4100	110870.00	67320.00	1675.00	328	42	2548	2530	1.00711462450593	2.23060611870082	6.84595359111676	false	false	false
13f55f7b-6fd1-469a-831c-bfaaf536ef68	2026-08-21 14:48	2026-08-21 14:47	2026-08-21 14:47	GEO	GEO260821C00029000	call	29.0000	2026-08-21	3.3700	3.3000	3.4000	32.3900	66410.00	28220.00	0.00	197	16	2220	2530	0.877470355731225	4.45728642291986	4.45728642291986	false	false	false
72e642cc-c313-4b81-9976-41758e542c8d	2026-08-21 14:47	2026-08-21 14:47	2026-08-21 14:47	GEO	GEO260821C00029000	call	29.0000	2026-08-21	3.3700	3.3000	3.4000	32.3900	55930.00	21760.00	0.00	166	10	1931	2530	0.763241106719368	4.45418505836468	4.45418505836468	false	false	false
45153c33-8c60-4695-a6e1-28f428974466	2026-08-21 14:47	2026-08-21 14:47	2026-08-21 14:47	GEO	GEO260821C00029000	call	29.0000	2026-08-21	3.3800	3.3000	3.4000	32.4000	31125.00	20740.00	0.00	92	5	2023	2530	0.799604743083004	1.93211433629042	1.93211433629042	false	false	false	true
6b55f193-6456-4236-90d1-61fd563d15cb	2026-08-21 14:47	2026-08-21 14:47	2026-08-21 14:47	GEO	GEO260821C00029000	call	29.0000	2026-08-21	3.3700	3.3000	3.4000	32.3950	56940.00	22100.00	0.00	169	12	1765	2530	0.697628458498024	4.04745099450866	4.04745099450866	false	false	false
0c09dee8-06d6-4e30-a09b-021430378e93	2026-08-21 11:22	2026-08-21 11:21	2026-08-21 11:21	GEO	GEO280121C00045000	call	45.0000	2028-01-21	5.2000	4.6000	5.2000	32.0000	207971.00	207971.00	0.00	400	7	400	3226	0.123992560446373	0.550499187179075	0.551160077169795	false	false	false
07311a76-884c-4829-9de0-83797d400b42	2026-08-21 11:21	2026-08-21 11:21	2026-08-21 11:21	VICI	VICI260918C00027500	call	27.5000	2026-09-18	0.1500	0.1500	0.2000	26.5810	30011.00	0.00	30011.00	2000	62	2037	10084	0.202003173343911	0.15011757426563	0.151053550543596	false	false	false
41046e8e-3b0f-44bd-8b20-c3592e4fc8b7	2026-08-20 14:44	2026-08-20 14:44	2026-08-20 14:44	ARE	ARE261016P00050000	put	50.0000	2026-10-16	2.5000	2.3000	2.5000	51.6600	32485.00	31750.00	735.00	130	9	1216	3849	0.315926214601195	0.418223893166361	0.424675618743649	false	false	false
fd33694f-fca6-4e7c-a582-4223afd887f9	2026-08-20 11:55	2026-08-20 11:55	2026-08-20 11:55	SPG	SPG261016P00210000	put	210.0000	2026-10-16	3.2000	3.2000	3.6000	221.4650	101132.00	0.00	101132.00	316	43	316	1133	0.278905560458959	0.236054874837067	0.236054874837067	false	false	false
63f54bd8-1861-412e-828c-749d0cad4fd1	2026-08-20 10:14	2026-08-20 10:14	2026-08-20 10:14	CSGP	CSGP270319C00045000	call	45.0000	2027-03-19	1.7300	1.7000	1.8000	32.1177	101195.00	52850.00	46070.00	586	25	16985	14624	1.16144693654267	0.509798366439815	0.515982468987948	false	false	false
febe589a-3a9a-433d-bca2-3421e36f9c1c	2026-08-20 10:13	2026-08-20 10:13	2026-08-20 10:13	CSGP	CSGP270319C00045000	call	45.0000	2027-03-19	1.7200	1.7000	1.8000	32.1400	108535.00	41825.00	64260.00	631	23	14225	14624	0.972716083150985	0.509054584939513	0.515233172972567	false	false	false
3c00efae-e405-4e9c-851a-2d2e729a687d	2026-08-20 10:07	2026-08-20 10:07	2026-08-20 10:07	CSGP	CSGP270319C00045000	call	45.0000	2027-03-19	1.8100	1.8000	2.1000	32.3800	46102.00	370.00	39072.00	255	61	2039	14624	0.139428336980306	0.513268292026144	0.519303112395561	false	false	false
7bd8f385-f66b-434d-a4c3-fd7d9a569d94	2026-08-20 10:07	2026-08-20 10:07	2026-08-20 10:07	CSGP	CSGP270319C00045000	call	45.0000	2027-03-19	1.9000	1.9000	2.0000	32.4100	73726.00	0.00	73726.00	388	24	1784	14624	0.12199124726477	0.524275160753558	0.524275160753558	false	false	false
689ed5a1-de75-4ac9-b4b3-0d18e7d36ac7	2026-08-20 09:42	2026-08-20 09:42	2026-08-20 09:42	AGNC	AGNC261016C00011000	call	11.0000	2026-10-16	0.5100	0.1600	0.5500	11.0700	35101.00	30040.00	5061.00	682	22	6331	0	0	0.237436726157826	0.247418380804679	true	false	false	true
221c0985-341d-4918-ba8d-9c86b632535d	2026-08-19 13:15	2026-08-19 13:15	2026-08-19 13:15	FRMI	FRMI280121C00020000	call	20.0000	2028-01-21	1.1300	1.0500	1.1500	5.6800	11282.00	11282.00	0.00	100	6	304	2832	0.107344632768362	1.08190759331043	1.08190759331043	false	false	false
5c89cf7c-8e60-42ae-8e29-63c6fa97969c	2026-08-19 11:21	2026-08-19 11:21	2026-08-19 11:21	GEO	GEO260918C00030000	call	30.0000	2026-09-18	1.8600	1.8500	2.2000	30.5800	22301.00	0.00	22301.00	120	8	148	2597	0.0569888332691567	0.424688830892045	0.439682517626272	false	false	false
6706bdb9-e0ad-4ad4-80bb-ddf33d18516a	2026-08-19 10:54	2026-08-19 10:54	2026-08-19 10:54	VICI	VICI280121P00025000	put	25.0000	2028-01-21	2.5000	2.5000	2.6500	26.1650	20003.00	0.00	20003.00	80	22	141	1789	0.0788149804359978	0.311208506581262	0.311208506581262	false	false	false
79325a14-1e97-4374-91ca-868aa5d1288d	2026-08-18 15:17	2026-08-18 15:17	2026-08-18 15:17	ARE	ARE260918P00042500	put	42.5000	2026-09-18	0.6500	0.6000	0.7000	46.0550	19684.00	69.00	19615.00	302	8	315	413	0.76271186440678	0.383655033439532	0.393896384796413	false	false	false	true
e756e5e7-1b2d-4116-80fb-a17e9a9ca65f	2026-08-17 10:37	2026-08-17 10:37	2026-08-17 10:37	REAX	REAX270115C00002500	call	2.5000	2027-01-15	0.5400	0.3000	0.5500	2.4100	10790.00	10790.00	0.00	200	7	1350	2488	0.542604501607717	0.849818427656552	0.933268008550286	false	false	false
75317a20-d4fa-41e1-b5c8-191393ff1b89	2026-08-17 10:11	2026-08-17 10:11	2026-08-17 10:11	CXW	CXW270115C00034000	call	34.0000	2027-01-15	4.0000	3.8000	4.2000	33.5800	214900.00	0.00	98500.00	537	7	941	1040	0.904807692307692	0.460458616738812	0.460308895039165	false	false	false