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

c5e0f492-805e-4928-9e25-72868c1e42de	2026-08-27 12:53	2026-08-27 12:53	2026-08-27 12:53	WELL	WELL261016P00250000	put	250.0000	2026-10-16	13.8000	13.0000	13.8000	239.8600	75896.00	68996.00	0.00	55	19	155	0	0	0.239955993687557	0.239955993687557	true	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Real Estate	168805674974.00	2026-10-26	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-27T16:57:23.365599Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
15ae21f4-26c0-43b3-9668-67814d8c29ea	2026-08-27 12:18	2026-08-27 12:18	2026-08-27 12:18	GEO	GEO280121C00045000	call	45.0000	2028-01-21	5.0000	4.9000	5.1000	32.3600	225000.00	0.00	194000.00	450	8	660	4099	0.161014881678458	0.531005715684143	0.530707045274984	true	false	false	true
4d1d83f8-03bc-4a08-b75e-ca2e4737c1e9	2026-08-27 12:13	2026-08-27 12:13	2026-08-27 12:13	FRMI	FRMI261016C00006000	call	6.0000	2026-10-16	0.6900	0.6500	0.7000	5.5300	17366.00	17366.00	0.00	250	8	368	1689	0.217880402605092	1.07364893407802	1.05832705525905	false	false	false	true
473bbdf4-999f-4824-b1e6-03eded6ad02b	2026-08-27 12:07	2026-08-27 12:07	2026-08-27 12:07	WELL	WELL261016P00250000	put	250.0000	2026-10-16	14.0000	13.0000	14.0000	239.4800	69991.00	62991.00	0.00	50	18	100	0	0	0.238576719824565	0.238576719824565	true	false	false	true
31f746bd-b543-468a-8828-bbde57e97d02	2026-08-27 11:58	2026-08-27 11:58	2026-08-27 11:58	FRMI	FRMI270115C00005000	call	5.0000	2027-01-15	1.7500	1.6500	1.8000	5.5350	15400.00	3850.00	7700.00	88	7	89	2832	0.0314265536723164	1.12165855108347	1.12165855108347	false	false	false	true
abfda0d6-69da-4022-8024-8b362e6af1b4	2026-08-27 11:47	2026-08-27 11:47	2026-08-27 11:47	VICI	VICI270617P00027500	put	27.5000	2027-06-17	3.3000	3.1000	3.3000	25.9150	33660.00	33660.00	0.00	102	5	227	4934	0.0460072963113093	0.312768270636852	0.312768270636852	false	false	false	true
c2c27d5b-a5ef-4295-b937-438f4f98d390	2026-08-27 11:35	2026-08-27 11:35	2026-08-27 11:35	FRMI	FRMI261016P00006000	put	6.0000	2026-10-16	1.0500	1.0500	1.1500	5.5350	10500.00	0.00	10500.00	100	7	100	2329	0.04293688278231	0.964888715046069	0.964888715046069	false	false	false	true
b86fe20d-800e-46e3-981a-871de8d9797c	2026-08-27 11:10	2026-08-27 11:10	2026-08-27 11:10	GEO	GEO261016C00030000	call	30.0000	2026-10-16	3.3800	3.3000	3.5000	31.9500	26011.00	17679.00	7327.00	77	10	89	110	0.809090909090909	0.478105115557054	0.478001554737794	false	false	false	true
acccab63-4e44-4098-b7f4-6a0c57cfa004	2026-08-27 11:03	2026-08-27 11:03	2026-08-27 11:03	IRM	IRM261218P00115000	put	115.0000	2026-12-18	5.8000	5.5000	5.8000	122.4700	11020.00	5800.00	0.00	19	8	57	274	0.208029197080292	0.366369358789166	0.366369358789166	false	false	false	true
9d1904a1-bf7b-424e-a3d1-471088b6b4e9	2026-08-27 11:03	2026-08-27 11:03	2026-08-27 11:03	BXMT	BXMT270115P00014000	put	14.0000	2027-01-15	1.2100	1.2000	1.3000	13.9850	12050.00	0.00	12050.00	100	7	210	1817	0.11557512383049	0.377213001761206	0.377213001761206	true	false	false	true
c385653d-c35f-4945-b2ea-00e7f4dbbc23	2026-08-27 10:59	2026-08-27 10:59	2026-08-27 10:59	WELL	WELL261016P00250000	put	250.0000	2026-10-16	15.1000	15.1000	15.1000	237.2600	57380.00	0.00	0.00	38	9	47	0	0	0.226070875534005	0.226070875534005	true	false	false	true
0f92cb28-22b4-4241-9ea4-c284a7460d53	2026-08-27 10:57	2026-08-27 10:57	2026-08-27 10:57	PSA	PSA260918C00320000	call	320.0000	2026-09-18	4.0000	3.4000	4.9000	315.7275	58400.00	48000.00	10400.00	146	14	146	329	0.443768996960486	0.179698006699805	0.179867766385645	false	false	false	true
bee7d34d-54e8-4568-9bb5-b993916a53e9	2026-08-27 10:57	2026-08-27 10:57	2026-08-27 10:57	NLY	NLY260925P00023000	put	23.0000	2026-09-25	0.4800	0.3900	0.4800	22.9100	109344.00	109344.00	0.00	2278	58	2293	1019	2.25024533856722	0.182216820696696	0.182216820696696	false	false	false	true
a545f2a6-47db-4844-9646-755a05369f60	2026-08-27 10:55	2026-08-27 10:55	2026-08-27 10:55	FRMI	FRMI260918C00005500	call	5.5000	2026-09-18	0.6000	0.5500	0.6000	5.5850	12000.00	10440.00	0.00	200	35	202	127	1.59055118110236	1.01666812184281	1.01666812184281	true	false	false	true
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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