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×

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

aed74492-4c6e-43de-8537-7af38c6f00d3	2026-08-27 10:53	2026-08-27 10:53	2026-08-27 10:53	MPT	MPT270617P00002500	put	2.5000	2027-06-17	0.1300	0.1100	0.1400	4.0550	13169.00	10556.00	377.00	1013	13	2714	20920	0.129732313575526	0.568807779958338	0.568807779958338	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Real Estate	2137976000.00	2026-10-29	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-27T15:06:04.251678Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
1e967156-7942-4970-b7a3-3ffc65aa2157	2026-08-27 10:51	2026-08-27 10:51	2026-08-27 10:51	MPT	MPT270617P00002500	put	2.5000	2027-06-17	0.1400	0.1100	0.1500	4.0699	21980.00	19908.00	252.00	1570	32	1629	20920	0.077868068833652	0.586201541851117	0.586201541851117	false	false	false	true	false
952a849a-e3bb-4a88-a6b8-a447a0b249aa	2026-08-27 10:47	2026-08-27 10:46	2026-08-27 10:46	STWD	STWD261218C00016000	call	16.0000	2026-12-18	0.5000	0.4500	0.5000	15.8750	14350.00	14350.00	0.00	287	26	416	1501	0.277148567621586	0.132614482381121	0.132614482381121	false	false	false	true	false
2c1b271b-a176-4110-83e4-524afc845e30	2026-08-27 10:43	2026-08-27 10:43	2026-08-27 10:43	UNIT	UNIT270219C00011000	call	11.0000	2027-02-19	1.3000	1.3000	1.5000	10.2600	52000.00	0.00	52000.00	400	9	400	602	0.664451827242525	0.535380399075227	0.535380399075227	false	false	false	true	false
f072e7e7-5f99-4b8e-9099-406118907176	2026-08-27 10:38	2026-08-27 10:38	2026-08-27 10:38	VICI	VICI260918C00025000	call	25.0000	2026-09-18	1.0600	1.0000	1.1000	25.8900	14675.00	6380.00	8295.00	139	5	840	1010	0.831683168316832	0.178905461309405	0.167092226838081	true	false	false	true	false
7aaf0f05-2096-47ac-8a2b-5b4424aef091	2026-08-27 10:21	2026-08-27 10:21	2026-08-27 10:21	UNIT	UNIT261120C00011000	call	11.0000	2026-11-20	0.8000	0.6500	0.9000	10.1715	40560.00	560.00	5440.00	507	29	507	4420	0.114705882352941	0.558524793758017	0.558524793758017	false	false	false	true	false
cb67dbde-a10c-41ad-9bcf-2bc6dd5c5a6d	2026-08-27 10:20	2026-08-27 10:20	2026-08-27 10:20	EXR	EXR261016P00140000	put	140.0000	2026-10-16	2.7500	2.7500	3.0000	144.1800	24200.00	0.00	24200.00	88	28	88	84	1.04761904761905	0.229968906011274	0.229968906011274	false	false	false	true	false
f2cec544-355d-4ab9-99b9-ef71db7595c4	2026-08-27 10:15	2026-08-27 10:15	2026-08-27 10:15	FRMI	FRMI261218P00005000	put	5.0000	2026-12-18	0.9000	0.9000	1.0000	5.6050	10980.00	0.00	10980.00	122	11	122	16018	0.00761643151454614	1.04392566154674	1.04392566154674	false	false	false	true	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	false
638b76bb-e114-4ac0-a500-ff1f4b10246d	2026-08-27 09:36	2026-08-27 09:36	2026-08-27 09:36	FRMI	FRMI280121C00007500	call	7.5000	2028-01-21	2.4000	2.2500	2.4000	5.7250	12000.00	10080.00	0.00	50	5	100	5267	0.0189861401177141	1.07250662478814	1.07250662478814	false	false	false	true	false
fa287e9d-4b53-455f-88a1-370a65cbb4cc	2026-08-27 09:34	2026-08-27 09:34	2026-08-27 09:34	OPEN	OPEN260918C00003500	call	3.5000	2026-09-18	0.2000	0.2000	0.2800	3.4150	10000.00	0.00	10000.00	500	7	1003	1893	0.529846804014791	0.700096509769888	0.700096509769888	false	false	false	true	false
97658733-63cf-4207-8f76-149ba88d901b	2026-08-26 15:26	2026-08-26 15:26	2026-08-26 15:26	MPT	MPT270617P00002500	put	2.5000	2027-06-17	0.1400	0.0700	0.1600	4.1201	140000.00	140000.00	0.00	10000	1	10312	417	24.7290167865707	0.593176324047319	0.593176324047319	false	true	false	true	true
1222b7b7-30fc-4ea9-8999-79293aab5aac	2026-08-26 15:16	2026-08-26 15:16	2026-08-26 15:16	WELL	WELL261218C00250000	call	250.0000	2026-12-18	10.7000	10.7000	11.7000	242.6600	95230.00	0.00	95230.00	89	15	89	416	0.213942307692308	0.233649277933421	0.233649277933421	false	false	false	true	false
5f3455c2-f140-4996-87b8-dd46a083bb61	2026-08-26 15:06	2026-08-26 15:06	2026-08-26 15:06	FRMI	FRMI261120C00006000	call	6.0000	2026-11-20	1.0500	1.0500	1.1500	5.6650	10500.00	0.00	10500.00	100	5	148	8461	0.0174920222195958	1.066120661229	1.066120661229	false	false	false	true	false
6e9061e3-8e05-4315-b7f0-97aff8f7e76f	2026-08-26 14:48	2026-08-26 14:48	2026-08-26 14:48	AGNC	AGNC261002C00011000	call	11.0000	2026-10-02	0.1400	0.1400	0.1800	10.8400	13986.00	0.00	13986.00	999	11	1100	4022	0.273495773247141	0.13981619597219	0.13981619597219	false	false	false	true	false
dacbae12-6df0-4904-811e-14b71bf61a11	2026-08-26 14:12	2026-08-26 14:12	2026-08-26 14:12	VICI	VICI270617P00027500	put	27.5000	2027-06-17	3.2000	3.0000	3.3000	26.0700	18865.00	18233.00	632.00	59	6	557	4671	0.119246414044102	0.309511870259171	0.309511870259171	false	false	false	true	false
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	true	false
1e670b57-1433-4112-8dcf-3e6596e72118	2026-08-26 13:49	2026-08-26 13:49	2026-08-26 13:49	WELL	WELL270521C00230000	call	230.0000	2027-05-21	29.2000	29.2000	30.2000	242.0950	151840.00	0.00	151840.00	52	25	160	5	32	0.230609964416302	0.230609964416302	true	false	false	true	false
ca178da6-0ed8-4ec3-a906-726e791d1a10	2026-08-26 13:44	2026-08-26 13:44	2026-08-26 13:44	WELL	WELL270319C00220000	call	220.0000	2027-03-19	32.6000	32.6000	34.2000	242.1000	146700.00	0.00	146700.00	45	21	157	2	78.5	0.227349311872208	0.227349311872208	true	false	false	true	false
0fcf7615-c57a-44bf-be3c-b5e64e14bb1b	2026-08-26 13:43	2026-08-26 13:43	2026-08-26 13:43	FRMI	FRMI261120C00015000	call	15.0000	2026-11-20	0.1200	0.1000	0.2000	5.7273	13441.00	0.00	13441.00	1126	7	1127	48055	0.0234522942461763	1.17527170965676	1.2410530395286	false	false	false	true	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	true	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	false
61d54708-cf8e-42ae-8c4e-ff0fb650f726	2026-08-26 13:10	2026-08-26 13:10	2026-08-26 13:10	O	O261016P00060000	put	60.0000	2026-10-16	0.6500	0.6000	0.7000	62.4750	74360.00	130.00	74230.00	1144	33	1201	428	2.80607476635514	0.185868245424183	0.185868245424183	false	false	false	true	false
18626589-071f-418d-8719-1fdecda6db9b	2026-08-26 13:06	2026-08-26 13:06	2026-08-26 13:06	WELL	WELL261218C00260000	call	260.0000	2026-12-18	6.8000	6.8000	8.8000	241.8900	103360.00	0.00	103360.00	152	15	153	172	0.88953488372093	0.232787940794407	0.232787940794407	false	false	false	true	false
7be8378c-3a4a-4536-8cf4-0f659a683883	2026-08-26 13:06	2026-08-26 13:05	2026-08-26 13:05	OPEN	OPEN280915C00007000	call	7.0000	2028-09-15	1.2100	1.2000	1.2800	3.4200	12221.00	0.00	12221.00	101	11	563	7288	0.0772502744237102	0.963067452773444	0.963067452773444	true	false	false	true	false
117426bb-fb99-4376-a984-e8bf5da0868c	2026-08-26 13:06	2026-08-26 13:05	2026-08-26 13:05	OPEN	OPEN280915C00007000	call	7.0000	2028-09-15	1.2100	1.1900	1.2800	3.4300	12221.00	1210.00	11011.00	101	11	674	7288	0.0924807903402854	0.959985043984324	0.959985043984324	true	false	false	true	false
9b07b044-ba5b-4a17-b5fe-8db277d19d8d	2026-08-26 13:06	2026-08-26 13:05	2026-08-26 13:05	OPEN	OPEN280915C00007000	call	7.0000	2028-09-15	1.2100	1.1600	1.2900	3.4300	14520.00	1210.00	13310.00	120	12	453	7288	0.0621569703622393	0.959985043984324	0.959985043984324	true	false	false	true	false
aef72b7a-54c7-4581-8aa2-e584aafa535c	2026-08-26 12:04	2026-08-26 12:04	2026-08-26 12:04	BEKE	BEKE261218P00020000	put	20.0000	2026-12-18	2.7500	2.6000	2.7500	17.9250	46475.00	46475.00	0.00	169	6	169	260	0.65	0.39760860506005	0.39760860506005	false	false	false	true	false
f3fa89d3-4ed0-4da5-b002-2f1a03b72b44	2026-08-26 11:57	2026-08-26 11:57	2026-08-26 11:57	OPEN	OPEN260828C00003000	call	3.0000	2026-08-28	0.4300	0.4300	0.4500	3.4300	12384.00	0.00	12384.00	288	8	908	1202	0.75540765391015	1.49454377921652	1.49454377921652	false	false	false	true	false
cfd32bc6-4e9a-47a0-b9f7-975ea6f15673	2026-08-26 11:47	2026-08-26 11:47	2026-08-26 11:47	WELL	WELL270521P00220000	put	220.0000	2027-05-21	9.2000	9.2000	9.9000	241.7300	57980.00	940.00	57040.00	63	6	498	21	23.7142857142857	0.260264030459757	0.263737078707971	true	false	false	true	false
2c1d6699-fdb0-4780-a116-d56737689ef6	2026-08-26 11:45	2026-08-26 11:45	2026-08-26 11:45	EQIX	EQIX261120C01170000	call	1170.0000	2026-11-20	35.6000	33.7000	35.6000	1078.2675	121040.00	121040.00	0.00	34	13	34	0	0	0.317445065292623	0.317445065292623	false	false	false	true	false
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	true	false
396d0ba5-910f-401b-b24f-d2297e8f6232	2026-08-26 11:39	2026-08-26 11:39	2026-08-26 11:39	IRM	IRM261016C00135000	call	135.0000	2026-10-16	1.5000	1.3000	1.5000	121.6250	45750.00	45750.00	0.00	305	34	307	765	0.401307189542484	0.301504059576064	0.301504059576064	false	false	false	true	false
a605d4d8-ccb5-4c4c-9dd6-964147100d86	2026-08-26 11:37	2026-08-26 11:37	2026-08-26 11:37	WELL	WELL270521P00220000	put	220.0000	2027-05-21	9.1000	9.1000	10.7000	241.7750	52780.00	0.00	52780.00	58	13	99	21	4.71428571428571	0.259383215187811	0.259383215187811	true	false	false	true	false
32183c8f-5eab-4107-88e5-d023a89a9f0c	2026-08-26 11:37	2026-08-26 11:37	2026-08-26 11:37	WELL	WELL270521P00240000	put	240.0000	2027-05-21	16.2100	16.2000	17.9000	241.8250	121550.00	0.00	121550.00	75	21	587	0	0	0.250518980833683	0.250518980833683	true	false	false	true	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	false
b558e2c4-40a1-4a21-9f4c-4808e97e6e82	2026-08-26 11:36	2026-08-26 11:36	2026-08-26 11:36	WELL	WELL270319C00230000	call	230.0000	2027-03-19	25.9000	25.9000	27.6000	241.4800	176120.00	0.00	176120.00	68	11	70	3	23.3333333333333	0.233760221954196	0.233760221954196	true	false	false	true	false
787a39d1-ace1-4e04-a20b-5f163dd84b3a	2026-08-26 11:36	2026-08-26 11:36	2026-08-26 11:36	WELL	WELL270521C00250000	call	250.0000	2027-05-21	18.8000	18.8000	20.1000	241.4800	295160.00	0.00	295160.00	157	20	268	80	3.35	0.235116890203204	0.235116890203204	true	false	false	true	false
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	false
0a0a51b2-3481-464a-ada3-f37b41c65cf4	2026-08-26 11:36	2026-08-26 11:36	2026-08-26 11:36	WELL	WELL270319P00230000	put	230.0000	2027-03-19	10.8000	10.8000	11.8000	241.4800	64800.00	0.00	64800.00	60	12	106	2	53	0.257101824558185	0.257101824558185	true	false	false	true	false
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	false
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	true	false
b67d26fb-2322-4a89-8376-481fe3d00c99	2026-08-26 11:32	2026-08-26 11:32	2026-08-26 11:32	WELL	WELL270521P00240000	put	240.0000	2027-05-21	16.8000	16.8000	19.1000	241.6000	164640.00	0.00	164640.00	98	15	98	0	0	0.256957931271017	0.256957931271017	true	false	false	true	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	true	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	true	false
51587f52-7877-476d-8a70-ef5f50e685a3	2026-08-26 11:10	2026-08-26 11:10	2026-08-26 11:10	UNIT	UNIT260918C00012000	call	12.0000	2026-09-18	0.1000	0.0500	0.1000	10.1200	34320.00	34320.00	0.00	3432	28	3433	2	1716.5	0.592476839673341	0.582545942359776	false	false	false	true	false
bd9a25cc-744f-44b1-97fb-e5613e5a19ae	2026-08-26 11:04	2026-08-26 11:04	2026-08-26 11:04	REAX	REAX270115C00030000	call	30.0000	2027-01-15	4.0000	3.8000	4.8000	26.4450	50000.00	0.00	50000.00	125	28	137	0	0	0.784958320136674	0.784958320136674	true	false	false	true	false
9ff089da-f6a5-44b5-95b4-37d7d0a7da16	2026-08-26 11:02	2026-08-26 11:02	2026-08-26 11:02	VICI	VICI280121P00025000	put	25.0000	2028-01-21	2.4400	2.4000	2.5000	26.1300	16810.00	12250.00	4560.00	69	10	199	2044	0.0973581213307241	0.306743874300193	0.302235438109546	false	false	false	true	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	false
6443b818-eafa-4e60-a610-625859136876	2026-08-26 10:21	2026-08-26 10:20	2026-08-26 10:20	STWD	STWD261218P00017000	put	17.0000	2026-12-18	1.4000	1.3500	1.4000	16.0650	19600.00	1680.00	0.00	140	18	210	4218	0.0497866287339972	0.271322332061382	0.271322332061382	false	false	false	true	false