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

01690adf-2fa6-4056-8017-1313f4f5db95	2026-08-28 12:28	2026-08-28 12:28	2026-08-28 12:28	AGNC	AGNC260918P00010500	put	10.5000	2026-09-18	0.0800	0.0600	0.0800	10.9300	23328.00	23328.00	0.00	2916	25	4290	591	7.25888324873096	0.236270473661158	0.236270473661158	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Real Estate	11961507800.00	2026-10-19	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-28T16:48:38.038469Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
c31e68a0-4008-41c8-8697-f3736782918a	2026-08-28 12:26	2026-08-28 12:26	2026-08-28 12:26	CSGP	CSGP260918C00030000	call	30.0000	2026-09-18	2.9800	2.5500	3.2000	32.4300	17854.00	17854.00	0.00	60	9	60	432	0.138888888888889	0.470858354939871	0.470858354939871	false	false	false	true	false
5f690b18-4043-4872-915b-4521c4869769	2026-08-28 12:01	2026-08-28 12:01	2026-08-28 12:01	OPEN	OPEN270115C00004000	call	4.0000	2027-01-15	0.5000	0.5000	0.5500	3.0000	25000.00	0.00	25000.00	500	20	509	9666	0.0526588040554521	0.877700343000204	0.877700343000204	false	false	false	true	false
0f9c6e1b-03e6-428a-a6a6-139d884bdc44	2026-08-28 11:42	2026-08-28 11:42	2026-08-28 11:42	IRM	IRM260918C00125000	call	125.0000	2026-09-18	1.5000	1.3500	1.5000	120.0000	24750.00	6450.00	0.00	165	9	165	289	0.570934256055363	0.279958692569441	0.279958692569441	false	false	false	true	false
f4c371a2-4b5b-4152-9e70-ace0ca4482c2	2026-08-28 11:37	2026-08-28 11:37	2026-08-28 11:37	DX	DX261218P00012500	put	12.5000	2026-12-18	0.4500	0.4500	0.5000	12.0000	60930.00	0.00	60930.00	1354	21	1356	788	1.72081218274112	0.254585746987404	0.254585746987404	false	false	false	true	false
bb7f8352-c271-4e89-bbb0-5b6a3ee465cd	2026-08-28 11:12	2026-08-28 11:12	2026-08-28 11:12	OPEN	OPEN261120C00004000	call	4.0000	2026-11-20	0.3400	0.3400	0.3600	3.3689	33184.00	0.00	33184.00	976	24	1003	16358	0.0613155642499083	0.849503020561714	0.849503020561714	false	false	false	true	false
c28ba3c3-3850-455f-a274-5a2b6ca12af9	2026-08-28 11:12	2026-08-28 11:11	2026-08-28 11:11	MPT	MPT281215P00002500	put	2.5000	2028-12-15	0.3900	0.3800	0.3900	4.0899	19500.00	19500.00	0.00	500	5	2243	4630	0.484449244060475	0.576102226806345	0.576102226806345	false	false	false	true	false
a9d3c2ff-34ea-4d0c-b3bd-0c9de400649a	2026-08-28 11:12	2026-08-28 11:11	2026-08-28 11:11	MPT	MPT281215P00002500	put	2.5000	2028-12-15	0.3900	0.3800	0.3900	4.0900	19500.00	19500.00	0.00	500	6	1743	4630	0.37645788336933	0.57611228907596	0.57611228907596	false	false	false	true	false
19cb0edd-099d-473f-9501-8cbe8637a06a	2026-08-28 11:11	2026-08-28 11:11	2026-08-28 11:11	MPT	MPT281215P00002500	put	2.5000	2028-12-15	0.3900	0.3800	0.3900	4.0900	19500.00	19500.00	0.00	500	19	1243	4630	0.268466522678186	0.57611228907596	0.57611228907596	true	false	false	true	false
3b651288-6aa4-456f-af3d-d1e1a60f6eea	2026-08-28 11:09	2026-08-28 11:09	2026-08-28 11:09	UNIT	UNIT261120C00011000	call	11.0000	2026-11-20	0.8500	0.8500	0.9500	10.3300	15980.00	0.00	15980.00	188	9	251	5420	0.046309963099631	0.549600603456816	0.549600603456816	false	false	false	true	false
25658256-5e38-4e16-82f0-4b709a68eca1	2026-08-28 11:04	2026-08-28 11:04	2026-08-28 11:04	CCI	CCI270917P00075000	put	75.0000	2027-09-17	8.9000	8.8000	10.7000	76.1800	3651670.00	0.00	3651670.00	4103	1	4512	0	0	0.364303401673533	0.364303401673533	false	true	false	true	true
2341aefd-abc2-4b0c-9e69-8dbd6a2324c3	2026-08-28 10:59	2026-08-28 10:59	2026-08-28 10:59	CCI	CCI270917P00075000	put	75.0000	2027-09-17	9.0000	9.0000	10.7000	76.2100	315000.00	0.00	241200.00	350	11	350	0	0	0.36807793900445	0.36807793900445	false	false	false	true	false
ec116205-c086-49ee-9f21-263a63e31df2	2026-08-28 10:37	2026-08-28 10:37	2026-08-28 10:37	MAA	MAA261218P00130000	put	130.0000	2026-12-18	6.0000	6.0000	6.4000	129.5300	12000.00	0.00	12000.00	20	8	100	155	0.645161290322581	0.229161797526384	0.229161797526384	true	false	false	true	false
a7381271-add9-4bc1-b9e1-981ea6108aaf	2026-08-28 10:34	2026-08-28 10:34	2026-08-28 10:34	MAA	MAA261218P00130000	put	130.0000	2026-12-18	6.0000	6.0000	6.1000	129.5700	12000.00	0.00	12000.00	20	6	60	155	0.387096774193548	0.229793011556864	0.229793011556864	false	false	false	true	false
1cee2c71-e216-44fd-b2fc-03f327a7ab08	2026-08-28 10:27	2026-08-28 10:27	2026-08-28 10:27	CBRE	CBRE261218C00160000	call	160.0000	2026-12-18	7.7600	5.8000	8.6000	149.8500	1552000.00	1552000.00	0.00	2000	2	2000	2027	0.986679822397632	0.33729650502999	0.33729650502999	false	true	false	true	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	false
04702a19-d2c3-4735-aa2d-e07a6302a71b	2026-08-28 10:18	2026-08-28 10:17	2026-08-28 10:17	MPT	MPT261016P00004500	put	4.5000	2026-10-16	0.5400	0.4800	0.5400	4.0900	15768.00	15768.00	0.00	292	10	400	2217	0.18042399639152	0.493945798068454	0.493945798068454	false	false	false	true	false
22c04ae9-bfb7-419b-8e97-2282470dfb2a	2026-08-28 10:15	2026-08-28 10:15	2026-08-28 10:15	MPT	MPT261009P00004500	put	4.5000	2026-10-09	0.5900	0.4100	0.5900	4.1100	46816.00	46762.00	54.00	794	47	802	0	0	0.648331215930351	0.648331215930351	true	false	false	true	false
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	true	false
b7d4b6da-1873-4724-98ac-a1de7013a388	2026-08-28 09:33	2026-08-28 09:33	2026-08-28 09:33	OPEN	OPEN260828C00003500	call	3.5000	2026-08-28	0.0200	0.0100	0.0200	3.3900	10000.00	10000.00	0.00	5000	26	6144	16082	0.382042034572814	1.5962630222226	1.5962630222226	false	false	false	true	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	true	false
a34ab4f9-48b1-4b1f-9ed6-2e74c327edde	2026-08-27 15:57	2026-08-27 15:57	2026-08-27 15:57	FRMI	FRMI260925P00005000	put	5.0000	2026-09-25	0.3500	0.3000	0.4000	5.4650	14700.00	6300.00	0.00	420	7	1135	146	7.77397260273973	0.952298550758193	0.952298550758193	false	false	false	true	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	true	false
6d4047f2-bf33-425b-84bc-bf63f20c4502	2026-08-27 15:52	2026-08-27 15:52	2026-08-27 15:52	UNIT	UNIT261120C00011000	call	11.0000	2026-11-20	0.8000	0.8000	0.9000	10.1850	20000.00	0.00	20000.00	250	12	1007	4420	0.227828054298643	0.555392316518033	0.555392316518033	false	false	false	true	false
3b434649-8ce4-434b-bd5b-b5cc6f719a51	2026-08-27 15:41	2026-08-27 15:41	2026-08-27 15:41	RITM	RITM260918P00011000	put	11.0000	2026-09-18	0.9500	0.9000	1.0000	10.0550	24795.00	570.00	17575.00	261	18	2810	66	42.5757575757576	0.269332225277459	0.269332225277459	false	false	false	true	false
2aa5fd85-6cb8-4297-bd0a-89f3b0a26bc8	2026-08-27 15:19	2026-08-27 15:19	2026-08-27 15:19	LODE	LODE270416C00005000	call	5.0000	2027-04-16	0.6500	0.6000	0.6500	3.0000	13000.00	13000.00	0.00	200	5	401	10	40.1	0.911798740449905	0.911798740449905	false	false	false	true	false
795b8a41-1432-45a5-9fc9-8fcbd4867ec9	2026-08-27 14:52	2026-08-27 14:52	2026-08-27 14:52	WELL	WELL261016P00250000	put	250.0000	2026-10-16	14.3000	13.5000	14.3000	238.8000	71496.00	64346.00	0.00	50	12	205	0	0	0.234051625211173	0.234051625211173	true	false	false	true	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	true	false
a10152c5-83b9-46e9-aa1f-fbd70e7bc147	2026-08-27 14:21	2026-08-27 14:20	2026-08-27 14:20	OPEN	OPEN270115C00004000	call	4.0000	2027-01-15	0.5500	0.5500	0.5800	3.3800	27390.00	0.00	27390.00	498	17	1567	9025	0.173628808864266	0.895049871847274	0.895049871847274	false	false	false	true	false
4460d3c0-bf9a-41b1-9e2a-91fb019d03ef	2026-08-27 14:15	2026-08-27 14:14	2026-08-27 14:14	NLY	NLY260918P00022500	put	22.5000	2026-09-18	0.2000	0.1600	0.2100	23.0210	100000.00	100000.00	0.00	5000	1	5000	92	54.3478260869565	0.191570190319391	0.191570190319391	false	true	false	true	true
6a6cbcd9-4a22-490a-9ed6-3e9b6a10fedf	2026-08-27 14:10	2026-08-27 14:10	2026-08-27 14:10	OPEN	OPEN261120C00003000	call	3.0000	2026-11-20	0.7600	0.7200	0.7800	3.3850	11400.00	7600.00	3800.00	150	6	326	3281	0.0993599512343798	0.871586791932118	0.871586791932118	false	false	false	true	false
9ef5c501-e46a-4635-b260-309e773b152b	2026-08-27 14:05	2026-08-27 14:05	2026-08-27 14:05	PLD	PLD270319P00125000	put	125.0000	2027-03-19	4.0000	3.6000	4.4000	141.6000	51200.00	50800.00	0.00	128	8	300	0	0	0.280152089890848	0.280152089890848	false	false	false	true	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	true	false
e2fb25bd-b957-46a6-872a-1aa603e1e03b	2026-08-27 13:02	2026-08-27 13:01	2026-08-27 13:01	RITM	RITM260918P00011000	put	11.0000	2026-09-18	0.9000	0.8500	0.9500	10.1177	12150.00	0.00	4680.00	135	9	1409	66	21.3484848484848	0.281330666225547	0.281330666225547	false	false	false	true	false
922c8804-466c-4a71-91b7-0ecfad8393ce	2026-08-27 12:54	2026-08-27 12:54	2026-08-27 12:54	UNIT	UNIT261120C00011000	call	11.0000	2026-11-20	0.8500	0.8500	0.9500	10.2400	12750.00	0.00	5780.00	150	9	757	4420	0.171266968325792	0.568097908003877	0.568097908003877	false	false	false	true	false
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
d87fde14-7695-42c4-9591-fc7557d15dcf	2026-08-27 12:47	2026-08-27 12:47	2026-08-27 12:47	PLD	PLD270617P00125000	put	125.0000	2027-06-17	5.8000	5.4000	6.3000	142.2400	52200.00	46980.00	5220.00	90	14	90	539	0.166975881261596	0.292771723917852	0.292771723917852	false	false	false	true	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false