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.

326,449 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts326,449 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

027f1e18-89fa-4340-99f3-f35ab1ebdd43	2026-09-17 10:12	2026-09-17 10:12	2026-09-17 10:12	DLR	DLR290119P00150000	put	150.0000	2029-01-19	15.3000	15.3000	16.2000	182.9000	177480.00	0.00	15300.00	116	24	148	0	0	0.361390814791985	0.361390814791985	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Real Estate	68182865790.00	2026-10-22	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-17T14:19:06.318420Z"}	2026-09-17	2026-09-17 21:15	2026-09-17 21:15
29cde6ba-0ddc-4289-a994-043e03d2d982	2026-09-17 10:11	2026-09-17 10:11	2026-09-17 10:11	JLL	JLL261016P00380000	put	380.0000	2026-10-16	39.1100	38.6000	40.9000	341.1000	62568.00	0.00	62568.00	16	5	20	5	4	0.290938714714611	0.290938714714611	false	false	false	true
7b4f23e0-7194-4fd0-aba0-41a8b8f334ff	2026-09-17 09:55	2026-09-17 09:54	2026-09-17 09:54	NLY	NLY261120P00019000	put	19.0000	2026-11-20	0.2400	0.2300	0.2900	21.4800	10224.00	9984.00	168.00	426	18	426	67	6.35820895522388	0.321128318734651	0.321128318734651	false	false	false	true
6c4e6523-8b10-450c-93d7-9d21aa519453	2026-09-16 15:41	2026-09-16 15:41	2026-09-16 15:41	NNN	NNN270319C00040000	call	40.0000	2027-03-19	3.0000	2.1000	3.0000	41.4500	18000.00	18000.00	0.00	60	16	60	211	0.28436018957346	0.137763360785563	0.137763360785563	false	false	false	true
ffa25181-aa72-4577-9179-7521c2887d10	2026-09-16 15:18	2026-09-16 15:18	2026-09-16 15:18	MPT	MPT270917C00004000	call	4.0000	2027-09-17	0.3800	0.3200	0.3800	3.4150	19000.00	19000.00	0.00	500	8	1410	140	10.0714285714286	0.389208512563706	0.389208512563706	false	false	false	true
4170e35d-35fc-4405-89dc-b69bb605add4	2026-09-16 15:18	2026-09-16 15:17	2026-09-16 15:17	STWD	STWD270319P00015000	put	15.0000	2027-03-19	1.2000	1.1000	1.2500	14.9500	12000.00	1800.00	10200.00	100	5	900	3024	0.297619047619048	0.318799755472897	0.318799755472897	false	false	false	true
3919b7dc-27a6-4e4d-b74d-21240038ce15	2026-09-16 15:02	2026-09-16 15:02	2026-09-16 15:02	ARR	ARR261016P00014000	put	14.0000	2026-10-16	0.2000	0.1500	0.2000	14.7500	20000.00	20000.00	0.00	1000	24	1024	59	17.3559322033898	0.304910722501475	0.304910722501475	true	false	false	true
f565483d-5e8a-4264-9493-948c521562fe	2026-09-16 14:58	2026-09-16 14:57	2026-09-16 14:57	AGNC	AGNC260918P00010000	put	10.0000	2026-09-18	0.1600	0.1600	0.1700	9.8601	12800.00	0.00	12800.00	800	8	15802	57960	0.27263630089717	0.241513974018127	0.241513974018127	true	false	false	true
f37828b3-1f1f-49e0-96d1-753230113550	2026-09-16 14:41	2026-09-16 14:41	2026-09-16 14:41	AGNC	AGNC280121P00008000	put	8.0000	2028-01-21	0.6000	0.5900	0.6200	9.9150	30000.00	2220.00	27780.00	500	9	10103	1732	5.83314087759815	0.378662543184691	0.378662543184691	true	false	false	true
4b984ebb-ced1-4c94-b1eb-55e4326b76ee	2026-09-16 14:37	2026-09-16 14:36	2026-09-16 14:36	CCI	CCI270115C00085000	call	85.0000	2027-01-15	1.8500	1.8000	1.9000	74.3200	84175.00	83250.00	925.00	455	7	18639	544	34.2628676470588	0.292699545916264	0.292699545916264	true	false	false	true
5a6d13c9-ab58-42f2-8c7b-9de56401fa36	2026-09-16 14:27	2026-09-16 14:27	2026-09-16 14:27	IRM	IRM260918P00114000	put	114.0000	2026-09-18	1.3000	1.0500	1.3000	114.0475	11570.00	11570.00	0.00	89	20	89	75	1.18666666666667	0.396736251529116	0.396736251529116	false	false	false	true
8b689ba3-9393-4a35-90ea-1160dac8261c	2026-09-16 14:06	2026-09-16 14:06	2026-09-16 14:06	OPEN	OPEN271217C00010000	call	10.0000	2027-12-17	0.3500	0.3000	0.4100	2.6150	18060.00	14910.00	3010.00	516	25	523	13342	0.0391995203117973	1.03655125038318	1.03655125038318	false	false	false	true
b4a1cf3b-0992-4970-a2bb-0abc2c5d9580	2026-09-16 14:01	2026-09-16 14:01	2026-09-16 14:01	AGNC	AGNC280121P00008000	put	8.0000	2028-01-21	0.6000	0.5800	0.6000	9.0000	62400.00	62400.00	0.00	1040	6	8101	1732	4.67725173210162	0.380509152868841	0.380509152868841	false	false	false	true
a182b784-1071-41c8-9b13-ac4312899b9b	2026-09-16 13:58	2026-09-16 13:58	2026-09-16 13:58	OPEN	OPEN260918C00002500	call	2.5000	2026-09-18	0.1400	0.1200	0.1500	2.0000	11606.00	4410.00	7196.00	829	25	2828	5824	0.485576923076923	1.00653114546963	1.00653114546963	false	false	false	true
05f6040c-8089-4912-b736-e6f6a2f0bb23	2026-09-16 13:37	2026-09-16 13:37	2026-09-16 13:37	AGNC	AGNC260918C00010000	call	10.0000	2026-09-18	0.0800	0.0600	0.1000	9.9600	40000.00	0.00	0.00	5000	1	5691	1123	5.06767586821015	0.331748648234941	0.331748648234941	false	true	false	true
de17633f-a184-487d-afb3-2437e4e687f9	2026-09-16 13:27	2026-09-16 13:27	2026-09-16 13:27	AGNC	AGNC261030C00009000	call	9.0000	2026-10-30	0.9900	0.9800	1.0900	9.9550	69003.00	0.00	69003.00	697	6	697	10	69.7	0.314436812862422	0.301958137578838	false	false	false	true
60803cbd-99e4-4ba8-bc06-cc709d78a29f	2026-09-16 13:03	2026-09-16 13:03	2026-09-16 13:03	FRMI	FRMI261023P00004500	put	4.5000	2026-10-23	0.4500	0.4000	0.4500	4.9350	16830.00	16830.00	0.00	374	5	753	611	1.23240589198036	1.09627967551974	1.09627967551974	false	false	false	true
3b105036-6ee6-45c6-bed7-40aa88ea51d8	2026-09-16 12:57	2026-09-16 12:57	2026-09-16 12:57	CSGP	CSGP270115P00030000	put	30.0000	2027-01-15	2.9500	2.9500	3.0000	30.9420	24780.00	0.00	24780.00	84	17	85	2271	0.0374284456186702	0.517883355588088	0.517883355588088	false	false	false	true
8f9c12fb-4733-4b16-b348-ecaa804e7134	2026-09-16 12:27	2026-09-16 12:26	2026-09-16 12:26	AGNC	AGNC261009C00009000	call	9.0000	2026-10-09	1.0100	1.0000	1.1000	9.9900	25553.00	0.00	25553.00	253	5	288	21	13.7142857142857	0.431683767144939	0.431683767144939	false	false	false	true
07b352e4-cc1a-4316-a801-8c74f4de7599	2026-09-16 12:08	2026-09-16 12:08	2026-09-16 12:08	GEO	GEO261120C00034000	call	34.0000	2026-11-20	2.1000	2.1000	2.2000	31.6800	35700.00	0.00	35700.00	170	15	173	683	0.253294289897511	0.550406177782672	0.550406177782672	false	false	false	true
a76461fa-3beb-49dc-b163-ccbd290a14ba	2026-09-16 12:06	2026-09-16 12:06	2026-09-16 12:06	GEO	GEO260918C00030000	call	30.0000	2026-09-18	1.7700	1.7500	2.1000	31.7500	17165.00	0.00	17165.00	97	10	152	1764	0.0861678004535147	0.476698793869279	0.541895664423149	true	false	false	true
2b41f137-59d2-4623-bcee-73333faa87f6	2026-09-16 11:31	2026-09-16 11:31	2026-09-16 11:31	CCI	CCI270115C00085000	call	85.0000	2027-01-15	1.8500	1.8000	1.9000	74.5200	86950.00	82325.00	1480.00	470	12	17385	544	31.9577205882353	0.288922257715278	0.288922257715278	false	false	false	true
5057f9df-2397-4808-a0f5-fbd7988d1664	2026-09-16 11:31	2026-09-16 11:30	2026-09-16 11:30	CCI	CCI270115C00085000	call	85.0000	2027-01-15	1.8500	1.8000	1.8500	74.5150	21275.00	21275.00	0.00	115	7	16912	544	31.0882352941176	0.289016727115569	0.289016727115569	false	false	false	true
4c0aa07c-d428-44de-853a-92fcaa465896	2026-09-16 11:14	2026-09-16 11:14	2026-09-16 11:14	CCI	CCI270115C00085000	call	85.0000	2027-01-15	1.7500	1.7000	1.8000	74.3600	17675.00	350.00	17325.00	101	6	15514	544	28.5183823529412	0.284762281964675	0.284762281964675	false	false	false	true
f6fd7c69-ea79-43d0-ae7f-1b0f0c40523c	2026-09-16 11:13	2026-09-16 11:13	2026-09-16 11:13	CCI	CCI270115C00085000	call	85.0000	2027-01-15	1.9100	1.3000	1.9500	74.3450	2865000.00	2865000.00	0.00	15000	2	15000	544	27.5735294117647	0.295786826110548	0.295786826110548	false	true	false	true
192249c4-1ffe-4290-914e-f0e81fc54ee5	2026-09-16 11:13	2026-09-16 11:13	2026-09-16 11:13	CCI	CCI270115C00085000	call	85.0000	2027-01-15	1.9100	1.3000	1.9500	74.3450	2865000.00	2865000.00	0.00	15000	2	15000	544	27.5735294117647	0.295786826110548	0.295786826110548	false	true	false	true
87ec90b0-8dce-46d8-a6ed-842a766454d6	2026-09-16 10:20	2026-09-16 10:20	2026-09-16 10:20	AGNC	AGNC280121P00008000	put	8.0000	2028-01-21	0.6000	0.5900	0.6500	9.0000	30000.00	60.00	29940.00	500	20	5000	1732	2.88683602771363	0.383259448957517	0.383259448957517	true	false	false	true
3ce8729d-202d-437a-94fc-743a27286d09	2026-09-16 10:16	2026-09-16 10:16	2026-09-16 10:16	BXP	BXP260918P00067500	put	67.5000	2026-09-18	3.3000	2.7000	4.4000	63.0000	132000.00	0.00	132000.00	400	2	400	453	0.883002207505519	1.09342079583141	1.09342079583141	false	true	true	false
88bcb274-2c15-4642-b52b-c177fb936dd6	2026-09-16 10:12	2026-09-16 10:11	2026-09-16 10:11	AGNC	AGNC280121P00008000	put	8.0000	2028-01-21	0.6000	0.5800	0.6500	10.0187	30000.00	20880.00	9120.00	500	16	3000	1732	1.73210161662818	0.385001407658129	0.385001407658129	true	false	false	true
709f61ad-7314-4bae-a4f0-a073712d9f81	2026-09-16 10:10	2026-09-16 10:09	2026-09-16 10:09	AGNC	AGNC280121P00008000	put	8.0000	2028-01-21	0.6100	0.6000	0.6500	10.0000	30542.00	0.00	30542.00	500	5	2500	1732	1.44341801385681	0.390125141301553	0.390125141301553	false	false	false	true
2ef4532b-930c-4494-8cd6-b4bfbad4c695	2026-09-16 10:04	2026-09-16 10:04	2026-09-16 10:04	AGNC	AGNC280121P00008000	put	8.0000	2028-01-21	0.6000	0.6000	0.6500	10.0150	30136.00	0.00	30136.00	500	13	1500	1732	0.866050808314088	0.391038399705996	0.391038399705996	false	false	false	true
771fd509-c8b3-4181-9e1b-b9359cbad33e	2026-09-16 10:01	2026-09-16 10:01	2026-09-16 10:01	AGNC	AGNC280121P00008000	put	8.0000	2028-01-21	0.6000	0.6000	0.6500	10.0450	30000.00	0.00	30000.00	500	10	1000	1732	0.577367205542725	0.386589523194929	0.386589523194929	true	false	false	true
471d5cf7-b3ae-4018-8e5e-1002b31f4343	2026-09-15 15:53	2026-09-15 15:52	2026-09-15 15:52	ARR	ARR270115P00013000	put	13.0000	2027-01-15	0.3000	0.2000	0.3000	15.0000	29700.00	29700.00	0.00	990	30	1000	231	4.32900432900433	0.336280120964025	0.336280120964025	true	false	false	true
1066d337-1288-48a2-8585-dc9b352510b8	2026-09-15 15:41	2026-09-15 15:41	2026-09-15 15:41	UNIT	UNIT261120C00011000	call	11.0000	2026-11-20	0.4500	0.3500	0.4500	9.6399	87975.00	87975.00	0.00	1955	55	2000	5980	0.334448160535117	0.560580969435583	0.550437643242444	false	false	false	true
33305049-66a9-4223-84ca-b14240d914d3	2026-09-15 15:40	2026-09-15 15:40	2026-09-15 15:40	IRM	IRM270115C00115000	call	115.0000	2027-01-15	7.6000	7.2000	8.2000	111.9400	18240.00	15200.00	3040.00	24	7	24	82	0.292682926829268	0.320299098241401	0.320299098241401	false	false	false	true
971e37d7-94e8-4c6f-a7fc-37668bc54ace	2026-09-15 15:35	2026-09-15 15:35	2026-09-15 15:35	IRM	IRM261218C00120000	call	120.0000	2026-12-18	4.8000	4.5000	4.8000	112.0700	24480.00	24480.00	0.00	51	15	51	246	0.207317073170732	0.328737405623494	0.328737405623494	false	false	false	true
12d2cd3d-9d34-4187-b49a-2d9bcba78af9	2026-09-15 14:51	2026-09-15 14:51	2026-09-15 14:51	FRMI	FRMI261120C00006000	call	6.0000	2026-11-20	0.5300	0.5000	0.5500	4.7000	25995.00	13255.00	12740.00	486	7	709	10011	0.0708220956947358	1.19291072581418	1.15431986173103	false	false	false	true
0303bdfc-0655-4e0c-b428-bd510a222f93	2026-09-15 14:51	2026-09-15 14:51	2026-09-15 14:51	FRMI	FRMI261120C00006000	call	6.0000	2026-11-20	0.5300	0.5000	0.5500	4.7050	13104.00	13104.00	0.00	245	6	954	10011	0.0952951753071621	1.16457153463856	1.16457153463856	false	false	false	true
70619cd9-3899-4fc3-9942-29ae578ccbae	2026-09-15 14:33	2026-09-15 14:33	2026-09-15 14:33	VMRK	VMRK261218C00072500	call	72.5000	2026-12-18	0.7800	0.3500	0.8000	65.4000	46800.00	46800.00	0.00	600	2	600	26	23.0769230769231	0.20692989840702	0.20692989840702	false	true	false	true
a135ef80-0d8c-45ab-8f04-81c36c41be71	2026-09-15 14:24	2026-09-15 14:24	2026-09-15 14:24	WELL	WELL261016P00250000	put	250.0000	2026-10-16	17.9000	17.8000	18.2000	232.6150	153940.00	44750.00	68020.00	86	17	781	520	1.50192307692308	0.235464147198578	0.235464147198578	false	false	false	true
9cc8e720-5ecd-4838-b03f-017bdee11374	2026-09-15 14:24	2026-09-15 14:24	2026-09-15 14:24	WELL	WELL261016P00250000	put	250.0000	2026-10-16	17.9000	17.8000	18.2000	232.6150	91290.00	1790.00	84130.00	51	15	695	520	1.33653846153846	0.235464147198578	0.235464147198578	false	false	false	true
a3cd8dd9-da55-4d51-8f01-493acd6a43f3	2026-09-15 14:24	2026-09-15 14:24	2026-09-15 14:24	WELL	WELL261016P00250000	put	250.0000	2026-10-16	18.2000	17.9000	18.5000	232.4300	387573.00	40040.00	347533.00	213	45	620	520	1.19230769230769	0.23375669496271	0.243999008646456	false	false	false	true
e15e55a4-db15-4b52-83f4-136cb7515cbe	2026-09-15 14:24	2026-09-15 14:24	2026-09-15 14:24	WELL	WELL261016P00250000	put	250.0000	2026-10-16	18.3000	17.7000	18.5000	232.2250	118950.00	56730.00	62220.00	65	9	407	520	0.782692307692308	0.240634993296581	0.239894664517857	false	false	false	true
cb4ad615-6d18-4d2c-a1d1-d15ba8120e27	2026-09-15 14:07	2026-09-15 14:07	2026-09-15 14:07	WELL	WELL261016P00250000	put	250.0000	2026-10-16	17.9000	17.6000	18.3000	232.6100	245230.00	5370.00	214800.00	137	25	342	520	0.657692307692308	0.23521843668593	0.23521843668593	false	false	false	true
b768eeea-8141-4020-b2eb-a5c60f7ec337	2026-09-15 14:03	2026-09-15 14:02	2026-09-15 14:02	LODE	LODE270416C00003000	call	3.0000	2027-04-16	0.6000	0.5500	0.6000	2.5850	29999.00	29999.00	0.00	500	34	983	3140	0.313057324840764	0.922360989980662	0.922360989980662	false	false	false	true
ec2f8da5-9014-4a63-a8ce-ccb871156da3	2026-09-15 12:53	2026-09-15 12:53	2026-09-15 12:53	IRM	IRM261016P00110000	put	110.0000	2026-10-16	2.8000	2.7000	3.1000	112.8050	109200.00	108640.00	560.00	390	27	410	87	4.71264367816092	0.32506808486984	0.32506808486984	false	false	false	true
8d586b09-24a9-4680-a390-eaeff8c2553d	2026-09-15 12:02	2026-09-15 12:02	2026-09-15 12:02	OPEN	OPEN280915P00003000	put	3.0000	2028-09-15	1.3700	1.3100	1.4100	2.6999	15070.00	137.00	14933.00	110	5	160	1332	0.12012012012012	0.949133015109831	0.949133015109831	false	false	false	true
a2106dd8-654c-4686-ade6-1a634b999a1e	2026-09-15 12:00	2026-09-15 12:00	2026-09-15 12:00	VICI	VICI270319C00025000	call	25.0000	2027-03-19	1.2600	1.1000	1.3000	24.8850	12640.00	12640.00	0.00	100	7	100	169	0.591715976331361	0.153189130885602	0.138266459004857	false	false	false	true
ffda292c-1152-47c7-b851-3fd5c918dc4c	2026-09-15 11:55	2026-09-15 11:55	2026-09-15 11:55	FRMI	FRMI261218P00005000	put	5.0000	2026-12-18	1.1500	1.1000	1.1500	4.7450	13455.00	13455.00	0.00	117	6	258	17752	0.0145335736818387	1.07991756327955	1.07991756327955	false	false	false	true
56d108c6-4133-4344-be93-3062acaf2d73	2026-09-15 11:36	2026-09-15 11:36	2026-09-15 11:36	GEO	GEO261016C00033000	call	33.0000	2026-10-16	1.1000	0.9500	1.1250	31.4900	11000.00	6380.00	2200.00	100	5	136	1091	0.124656278643446	0.45685195734316	0.45685195734316	false	false	false	true