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.

658,639 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts658,639 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:endpoint = /api/option-trades/flow-alerts×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

76d49b16-f8bd-4fd7-99cf-6351ab010006	2026-09-23 11:03	2026-09-23 11:03	2026-09-23 11:03	BEKE	BEKE261120C00016000	call	16.0000	2026-11-20	1.4500	1.2500	1.4500	16.5500	59133.00	59133.00	0.00	408	29	408	11	37.0909090909091	0.423897373790908	0.419893531775612	false	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	ADR	Real Estate	17882962985.00	2026-11-09	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-23T15:04:15.950179Z"}	2026-09-23	2026-09-23 21:15	2026-09-23 21:15
21288034-982b-48c1-9429-ccd7d3038e8b	2026-09-23 11:02	2026-09-23 11:02	2026-09-23 11:02	O	O280121P00052500	put	52.5000	2028-01-21	3.7000	3.5000	3.8000	55.3750	15170.00	12950.00	2220.00	41	11	92	671	0.137108792846498	0.261732994187356	0.261732994187356	false	false	false
5471a1b4-993c-4b98-b6d0-3175e2e0fe6d	2026-09-23 10:59	2026-09-23 10:58	2026-09-23 10:58	PLD	PLD261016C00140000	call	140.0000	2026-10-16	1.2500	1.2500	1.5000	134.0000	14125.00	0.00	14125.00	113	26	116	1214	0.0955518945634267	0.225000077632885	0.225000077632885	false	false	false
a721c38d-7c73-46f5-8157-a49e63ff31aa	2026-09-23 10:52	2026-09-23 10:52	2026-09-23 10:52	JLL	JLL261120C00350000	call	350.0000	2026-11-20	10.0000	9.8000	12.4000	330.1200	1100000.00	0.00	1100000.00	1100	1	1100	85	12.9411764705882	0.323253409244007	0.323253409244007	false	true	false
60dc56a0-c56c-4f1c-9ff7-2477f47b9de1	2026-09-23 10:50	2026-09-23 10:49	2026-09-23 10:49	DLR	DLR261218P00160000	put	160.0000	2026-12-18	3.0000	2.4500	3.0000	183.0100	39300.00	39300.00	0.00	131	12	143	10898	0.0131216737015966	0.341968792880151	0.341968792880151	false	false	false
07875051-eea5-45f9-b57a-dbfabeb6e6f9	2026-09-23 10:39	2026-09-23 10:39	2026-09-23 10:39	CSGP	CSGP270319C00035000	call	35.0000	2027-03-19	2.1500	2.1000	2.2000	28.4000	11180.00	7095.00	4085.00	52	17	52	82	0.634146341463415	0.520296814207413	0.520296814207413	true	false	false
c212cfae-1d3f-435d-afbb-4215473781ba	2026-09-23 10:37	2026-09-23 10:37	2026-09-23 10:37	PLD	PLD270115P00150000	put	150.0000	2027-01-15	16.4000	14.2000	16.5000	134.8300	100040.00	9840.00	90200.00	61	5	669	692	0.966763005780347	0.259469032146373	0.259469032146373	false	false	false
80ea0f32-0714-49fb-8a1f-883f336af726	2026-09-23 10:37	2026-09-23 10:37	2026-09-23 10:37	PLD	PLD270115P00150000	put	150.0000	2027-01-15	16.4000	16.4000	16.6000	134.8100	364080.00	0.00	364080.00	222	12	608	692	0.878612716763006	0.258907514930717	0.258907514930717	false	false	false
bbecd1f1-e738-42a7-8eba-df0c182dddd2	2026-09-23 10:33	2026-09-23 10:33	2026-09-23 10:33	FRMI	FRMI280121P00002500	put	2.5000	2028-01-21	0.5500	0.5500	0.6500	4.9250	27500.00	0.00	27500.00	500	7	500	4050	0.123456790123457	0.987590026045053	0.987590026045053	false	false	false
1044d571-93d4-486c-b916-d4a9db10debf	2026-09-23 10:31	2026-09-23 10:31	2026-09-23 10:31	PSA	PSA270319P00270000	put	270.0000	2027-03-19	10.0000	10.0000	11.5000	289.1400	10000.00	0.00	10000.00	10	5	10	42	0.238095238095238	0.259987059594729	0.259987059594729	false	false	false
5bea5016-7de5-4757-ae6d-e48260863e7f	2026-09-23 10:30	2026-09-23 10:30	2026-09-23 10:30	PLD	PLD270115P00150000	put	150.0000	2027-01-15	16.3000	16.3000	16.6000	134.8350	163000.00	0.00	163000.00	100	5	333	692	0.48121387283237	0.255682846386652	0.255682846386652	false	false	false
ec155f60-f194-488e-a1e3-be721493a24a	2026-09-23 10:30	2026-09-23 10:30	2026-09-23 10:30	PLD	PLD270115P00150000	put	150.0000	2027-01-15	16.3000	16.3000	16.7000	134.8400	218420.00	0.00	218420.00	134	7	157	692	0.226878612716763	0.255824493533875	0.255824493533875	false	false	false
1995aa9e-3fd9-4977-8ed0-70d9dd3fc485	2026-09-23 10:10	2026-09-23 10:10	2026-09-23 10:10	AGNC	AGNC261030C00010500	call	10.5000	2026-10-30	0.0800	0.0600	0.1000	9.9913	80000.00	0.00	0.00	10000	1	10001	12066	0.828857947952926	0.189234468429768	0.189234468429768	false	true	false
35620a8f-ee64-4a41-bf87-42870ca42f63	2026-09-23 09:48	2026-09-23 09:48	2026-09-23 09:48	LAMR	LAMR261120C00150000	call	150.0000	2026-11-20	3.0000	3.0000	3.7000	144.0000	15000.00	0.00	15000.00	50	6	58	233	0.248927038626609	0.209561955537135	0.209561955537135	false	false	false
83787fe0-3bd4-4a0c-9548-1a03679c5b2e	2026-09-22 15:37	2026-09-22 15:37	2026-09-22 15:37	WPC	WPC270115C00070000	call	70.0000	2027-01-15	1.3500	1.2500	1.3500	67.1900	13500.00	13500.00	0.00	100	9	992	286	3.46853146853147	0.142018889436809	0.141622512079299	false	false	false
81e63318-8ea3-49b2-be68-b8897490363c	2026-09-22 15:21	2026-09-22 15:21	2026-09-22 15:21	PSA	PSA261016P00280000	put	280.0000	2026-10-16	2.9000	2.9000	3.9000	290.3000	126730.00	0.00	6090.00	437	19	447	64	6.984375	0.243484609218997	0.243484609218997	false	false	false
4e1ae9b7-5fee-46cc-b968-a1d4834e4f49	2026-09-22 15:16	2026-09-22 15:16	2026-09-22 15:16	CSGP	CSGP280121C00030000	call	30.0000	2028-01-21	7.0000	7.0000	7.4000	28.8395	16802.00	0.00	16802.00	24	5	45	539	0.0834879406307978	0.516242707207291	0.514647884411964	false	false	false
5c27619f-d4a8-42b7-9b35-d99b82077d8e	2026-09-22 15:14	2026-09-22 15:14	2026-09-22 15:14	GEO	GEO261016C00031000	call	31.0000	2026-10-16	0.8900	0.8000	0.9000	29.5000	13348.00	13348.00	0.00	150	8	817	1926	0.424195223260644	0.483708504379549	0.480222485535923	false	false	false
0eaa3e9d-70de-47b8-8630-c078e520375f	2026-09-22 15:10	2026-09-22 15:10	2026-09-22 15:10	PLD	PLD261016C00140000	call	140.0000	2026-10-16	1.7000	1.6000	1.7000	135.4217	34000.00	34000.00	0.00	200	22	246	996	0.246987951807229	0.241700932491473	0.241700932491473	false	false	false
9447e9c2-019b-4809-9283-acb17461f9e7	2026-09-22 15:01	2026-09-22 15:01	2026-09-22 15:01	O	O280121P00057500	put	57.5000	2028-01-21	5.3000	5.3000	5.4000	56.6450	26500.00	0.00	26500.00	50	14	101	538	0.187732342007435	0.258319896312244	0.258319896312244	false	false	false
6785842c-6d9e-457c-a97c-dc50ae7e32c7	2026-09-22 14:57	2026-09-22 14:57	2026-09-22 14:57	BXP	BXP261120C00075000	call	75.0000	2026-11-20	0.3000	0.1000	0.3500	63.8550	30161.00	29801.00	360.00	1006	40	1122	4479	0.250502344273275	0.279926425999507	0.279162832657385	false	false	false
50de49fd-2f6d-4800-9880-f708d733f519	2026-09-22 14:34	2026-09-22 14:34	2026-09-22 14:34	WELL	WELL261218C00270000	call	270.0000	2026-12-18	1.3500	1.2000	1.3500	230.9250	58185.00	5535.00	0.00	431	35	838	775	1.08129032258065	0.234338897916295	0.234338897916295	false	false	false
3a5f7659-2a40-4e8c-95f7-d876cb85fd2f	2026-09-22 14:30	2026-09-22 14:30	2026-09-22 14:30	OHI	OHI261120P00044000	put	44.0000	2026-11-20	0.8500	0.8500	1.2000	46.4883	26350.00	0.00	25500.00	310	15	317	10	31.7	0.266946359280081	0.266946359280081	false	false	false
ad464d2e-caf3-475d-9784-4f6d21c451be	2026-09-22 14:25	2026-09-22 14:25	2026-09-22 14:25	CCI	CCI261120P00070000	put	70.0000	2026-11-20	2.1500	2.0500	2.1500	72.9000	44930.00	44930.00	0.00	209	35	210	6	35	0.31392791606036	0.31392791606036	false	false	false
e67ebfbd-9d07-4a9f-bdfc-6561d93d575a	2026-09-22 14:17	2026-09-22 14:16	2026-09-22 14:16	O	O261120P00055000	put	55.0000	2026-11-20	0.9000	0.8500	0.9500	56.6150	17460.00	14400.00	0.00	194	5	270	233	1.1587982832618	0.191750298148855	0.191750298148855	false	false	false
3157f17d-5bb6-49ef-b9f5-fee515b5d3e0	2026-09-22 14:04	2026-09-22 14:04	2026-09-22 14:04	CBRE	CBRE261016P00135000	put	135.0000	2026-10-16	2.4500	2.4500	2.8000	141.3200	35770.00	0.00	35770.00	146	27	149	97	1.5360824742268	0.362027793596107	0.362027793596107	false	false	false
5f78af89-96dc-48ec-9025-978bf2a3162c	2026-09-22 14:03	2026-09-22 14:03	2026-09-22 14:03	CBRE	CBRE261218C00145000	call	145.0000	2026-12-18	8.5000	8.5000	8.8000	141.0650	19550.00	0.00	850.00	23	13	23	18	1.27777777777778	0.350348599716561	0.350348599716561	false	false	false
ec970f91-028c-44ab-8f2d-be0ece3cfa10	2026-09-22 13:50	2026-09-22 13:50	2026-09-22 13:50	FRMI	FRMI270219C00009000	call	9.0000	2027-02-19	0.5500	0.5000	0.6500	5.0950	11000.00	1210.00	9790.00	200	6	200	326	0.613496932515337	1.08618121547493	1.08618121547493	false	false	false
beb6864f-8448-4e70-8c1e-07b5f83bef94	2026-09-22 13:33	2026-09-22 13:32	2026-09-22 13:32	DEI	DEI261120C00011000	call	11.0000	2026-11-20	0.3500	0.2500	0.3500	10.0000	31255.00	31255.00	0.00	893	7	897	1250	0.7176	0.340480809829238	0.340480809829238	false	false	false
13664d98-ca35-4c88-aa9a-e3f12f94e716	2026-09-22 13:24	2026-09-22 13:24	2026-09-22 13:24	FRMI	FRMI270115P00004000	put	4.0000	2027-01-15	0.5500	0.5000	0.5500	5.1150	16500.00	16500.00	0.00	300	6	562	10620	0.0529190207156309	1.03578177688459	1.03578177688459	false	false	false
c7f9c4fa-d2d5-465d-9593-6dff4e256cb2	2026-09-22 13:23	2026-09-22 13:23	2026-09-22 13:23	JOE	JOE261218C00070000	call	70.0000	2026-12-18	2.0000	1.9500	4.0000	65.9200	20016.00	4800.00	15216.00	100	10	105	65	1.61538461538462	0.260767200899954	0.260767200899954	true	false	false
e9fb388f-a6e6-44b5-96dd-02665630e14a	2026-09-22 13:17	2026-09-22 13:17	2026-09-22 13:17	EQIX	EQIX261016P00990000	put	990.0000	2026-10-16	8.6000	8.5000	9.7000	1051.8850	30960.00	860.00	30100.00	36	13	38	14	2.71428571428571	0.293771464348654	0.293771464348654	false	false	false
ba7422c7-011c-42f2-9b53-f5de9835add5	2026-09-22 13:17	2026-09-22 13:17	2026-09-22 13:17	EQIX	EQIX261016P00980000	put	980.0000	2026-10-16	6.9000	6.9000	8.9000	1051.8850	26220.00	0.00	26220.00	38	14	39	21	1.85714285714286	0.297176672735797	0.297176672735797	false	false	false
4b58f0d4-8d60-40a7-b7c3-2b3fe1413dd1	2026-09-22 12:42	2026-09-22 12:41	2026-09-22 12:41	JOE	JOE261120C00065000	call	65.0000	2026-11-20	3.5000	3.4000	4.2000	65.9400	25200.00	2100.00	23100.00	72	13	200	101	1.98019801980198	0.263969092843605	0.263969092843605	true	false	false
55df1789-22b0-4dc4-a5e4-89dbda62220a	2026-09-22 12:26	2026-09-22 12:26	2026-09-22 12:26	GEO	GEO261120P00031000	put	31.0000	2026-11-20	3.4000	3.3000	3.4000	29.7100	325040.00	325040.00	0.00	956	35	957	185	5.17297297297297	0.58343752465996	0.58343752465996	false	false	false
51588e19-161b-4361-ae4d-3dc9dc8b1077	2026-09-22 12:26	2026-09-22 12:26	2026-09-22 12:26	GEO	GEO261120P00029000	put	29.0000	2026-11-20	2.3000	2.2500	2.3000	29.7100	18400.00	18400.00	0.00	80	14	81	123	0.658536585365854	0.582470379602384	0.582470379602384	false	false	false
dcf321c2-54b2-4ef3-b4cc-4197bddeb395	2026-09-22 12:05	2026-09-22 12:05	2026-09-22 12:05	OPEN	OPEN271217C00004000	call	4.0000	2027-12-17	0.8700	0.8500	0.8700	2.7450	85260.00	85260.00	0.00	980	16	1401	3293	0.425447919829942	0.965813507636859	0.965813507636859	true	false	false
e61dab50-4986-40f6-a6fb-75f553cbe8f1	2026-09-22 11:19	2026-09-22 11:19	2026-09-22 11:19	JOE	JOE261120C00065000	call	65.0000	2026-11-20	3.5000	3.4000	3.5000	65.5000	23100.00	16800.00	0.00	66	5	83	101	0.821782178217822	0.288964707341027	0.288964707341027	false	false	false
9789331a-328e-47ac-a693-bbf39c964ab3	2026-09-22 11:09	2026-09-22 11:09	2026-09-22 11:09	VICI	VICI280121P00022500	put	22.5000	2028-01-21	1.8500	1.7000	2.0000	23.0000	46250.00	10915.00	35335.00	250	27	300	484	0.619834710743802	0.2981747082293	0.2981747082293	false	false	false
b68fb356-b0fd-4ee5-b09c-fb246f0be413	2026-09-22 10:51	2026-09-22 10:51	2026-09-22 10:51	NLY	NLY260925C00021500	call	21.5000	2026-09-25	0.1300	0.1300	0.1700	21.4300	10153.00	0.00	10153.00	781	22	1015	1394	0.728120516499283	0.205519369824499	0.205519369824499	false	false	false
2a25fcc6-08b3-4cae-85fc-f79dba47b706	2026-09-22 10:42	2026-09-22 10:42	2026-09-22 10:42	CCI	CCI270917C00082500	call	82.5000	2027-09-17	4.9000	4.9000	5.5000	72.9800	10780.00	0.00	10780.00	22	6	25	446	0.0560538116591928	0.250397118947004	0.250397118947004	false	false	false
1394de13-d4b7-4196-9790-a9d3593d3e0b	2026-09-22 10:24	2026-09-22 10:23	2026-09-22 10:23	CBRE	CBRE261120P00130000	put	130.0000	2026-11-20	3.6000	3.6000	3.8000	140.0000	46085.00	0.00	46085.00	128	30	184	0	0	0.378401917038262	0.378401917038262	false	false	false
5dfe9a06-a15e-4b93-b76c-ea48ecf34795	2026-09-22 10:08	2026-09-22 10:08	2026-09-22 10:08	EPR	EPR270115P00060000	put	60.0000	2027-01-15	5.1000	3.9000	5.1000	57.6600	15300.00	15300.00	0.00	30	7	30	37	0.810810810810811	0.3280518094865	0.3280518094865	false	false	false
ff5bbe84-3baa-4e92-8b66-34a12a4210b1	2026-09-22 10:01	2026-09-22 10:01	2026-09-22 10:01	IIPR	IIPR261218C00060000	call	60.0000	2026-12-18	1.7500	1.5500	2.1000	56.3900	14702.00	6825.00	7877.00	84	11	86	880	0.0977272727272727	0.25929133151403	0.268213700614461	true	false	false
002aa70a-697d-4c2c-aa69-15d15a486244	2026-09-22 09:58	2026-09-22 09:58	2026-09-22 09:58	VICI	VICI270319P00022500	put	22.5000	2027-03-19	0.7000	0.6500	0.7500	24.0600	16100.00	14280.00	1820.00	230	10	248	218	1.13761467889908	0.23347221786397	0.233956595311376	true	false	false
d0b5da5c-6200-441d-bd85-6f0f247b1afa	2026-09-22 09:56	2026-09-22 09:56	2026-09-22 09:56	WELL	WELL261016P00240000	put	240.0000	2026-10-16	10.6000	10.5000	11.2000	231.1400	30740.00	6360.00	7420.00	29	10	205	523	0.391969407265774	0.230020046201308	0.230020046201308	false	false	false
b2cb6c0f-a69a-4ff9-86ed-4508b7d28c2b	2026-09-22 09:56	2026-09-22 09:56	2026-09-22 09:56	WELL	WELL261016P00240000	put	240.0000	2026-10-16	10.7200	10.5000	11.4000	230.8700	69710.00	9640.00	60070.00	65	9	101	523	0.193116634799235	0.225302089917424	0.230341623464301	false	false	false
ef24482d-a4b5-45b1-9f95-805d8d7f4f7c	2026-09-22 09:56	2026-09-22 09:56	2026-09-22 09:56	WELL	WELL261016P00240000	put	240.0000	2026-10-16	11.0000	10.4000	11.0000	230.4950	39600.00	39600.00	0.00	36	7	36	523	0.0688336520076482	0.226663136771535	0.226663136771535	false	false	false
7228ffe3-4002-442c-9cc4-a8b5ec6ec112	2026-09-21 15:54	2026-09-21 15:54	2026-09-21 15:54	SBAC	SBAC261016P00175000	put	175.0000	2026-10-16	3.8000	3.5000	4.0000	176.0000	12540.00	12540.00	0.00	33	12	33	791	0.0417193426042984	0.257268349900734	0.257268349900734	true	false	false
de1f4091-79a6-4546-a1d3-ba936a954188	2026-09-21 15:54	2026-09-21 15:54	2026-09-21 15:54	CBRE	CBRE261016C00150000	call	150.0000	2026-10-16	2.2000	1.9500	2.2000	143.0000	16500.00	3520.00	0.00	75	5	2467	191	12.9162303664921	0.30979381532213	0.30979381532213	false	false	false