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

ce3c3404-f163-461c-9e42-d134d81e7665	2026-08-31 09:40	2026-08-31 09:40	2026-08-31 09:40	OPEN	OPEN280616C00004000	call	4.0000	2028-06-16	1.4500	1.4500	1.5100	3.2250	10585.00	0.00	10585.00	73	15	180	35	5.14285714285714	0.965087175641716	0.972159933018366	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Real Estate	2709344030.00	2026-11-05	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-31T13:47:44.562652Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
2e37cbee-13e5-4d3e-83ff-b8d16a29fe68	2026-08-31 09:39	2026-08-31 09:39	2026-08-31 09:39	OPEN	OPEN280616C00004000	call	4.0000	2028-06-16	1.4500	1.4150	1.5200	3.2450	14790.00	0.00	12035.00	102	7	107	35	3.05714285714286	0.962676988772194	0.962676988772194	false	false	false	true
a3d93024-fe32-44ad-8a5c-4428917868b2	2026-08-31 09:36	2026-08-31 09:36	2026-08-31 09:36	WPC	WPC261016P00070000	put	70.0000	2026-10-16	1.8000	1.7000	1.8500	70.0000	21413.00	17273.00	0.00	119	18	350	949	0.368809272918862	0.198750135644055	0.198750135644055	false	false	false	true
7d2086d5-f981-4197-9323-0e5de59b8569	2026-08-31 09:34	2026-08-31 09:34	2026-08-31 09:34	OPEN	OPEN260911P00003000	put	3.0000	2026-09-11	0.0700	0.0700	0.1000	3.2300	15022.00	0.00	15022.00	2146	5	2151	1531	1.40496407576747	0.744941507552831	0.744941507552831	false	false	false	true
122af8a6-c744-4c48-8eb2-7e3446bd2c4d	2026-08-28 15:33	2026-08-28 15:33	2026-08-28 15:33	CIGI	CIGI261016P00105000	put	105.0000	2026-10-16	5.2000	4.6000	5.2000	103.0050	32240.00	32240.00	0.00	62	17	62	1	62	0.292445365958319	0.292445365958319	false	false	false	true
d7ecc13d-319d-4c74-a995-5b773d139e0b	2026-08-28 15:06	2026-08-28 15:05	2026-08-28 15:05	CCI	CCI260918C00075000	call	75.0000	2026-09-18	2.3000	2.1000	2.3000	75.8600	230000.00	69000.00	0.00	1000	6	2004	153	13.0980392156863	0.2413824594858	0.2413824594858	false	false	false	true
57465618-e0b2-40eb-b64d-8707f0533af5	2026-08-28 14:18	2026-08-28 14:18	2026-08-28 14:18	AGNC	AGNC260918P00010500	put	10.5000	2026-09-18	0.1000	0.0900	0.1100	10.9150	10730.00	4530.00	0.00	1073	11	18563	591	31.409475465313	0.256969838171354	0.256969838171354	false	false	false	true
0e242ff8-b539-4ec6-8d29-d58c97b3873f	2026-08-28 14:13	2026-08-28 14:13	2026-08-28 14:13	OPEN	OPEN270219C00005000	call	5.0000	2027-02-19	0.4300	0.4000	0.4400	3.3150	53518.00	22396.00	0.00	1250	8	1391	4192	0.331822519083969	0.930158302426743	0.952844140235226	false	false	false	true
118425b1-02ce-4052-8c8e-54ea25cebc39	2026-08-28 13:58	2026-08-28 13:58	2026-08-28 13:58	CCI	CCI260918C00075000	call	75.0000	2026-09-18	2.0300	1.8000	2.0500	75.4700	203150.00	203150.00	0.00	1000	10	1003	153	6.55555555555556	0.246335063858831	0.22714916783301	false	false	false	true
424a1971-56a9-460e-a188-9f8fb352bae5	2026-08-28 13:33	2026-08-28 13:32	2026-08-28 13:32	ESS	ESS261016P00280000	put	280.0000	2026-10-16	7.7000	7.7000	8.1000	282.0800	67760.00	0.00	67760.00	88	23	88	16	5.5	0.228246316071	0.228246316071	false	false	false	true
2b6d9c93-fc6b-49c4-9b5a-9c4b170a2748	2026-08-28 13:30	2026-08-28 13:30	2026-08-28 13:30	ESS	ESS270416P00290000	put	290.0000	2027-04-16	22.9000	21.3000	23.6000	282.0600	80149.00	41219.00	38930.00	35	11	35	0	0	0.252487629402214	0.252487629402214	false	false	false	true
5e973132-40d5-47ea-b53f-e64bc85baaa9	2026-08-28 13:07	2026-08-28 13:07	2026-08-28 13:07	RITM	RITM260918C00010000	call	10.0000	2026-09-18	0.2500	0.2500	0.3000	10.0800	20250.00	0.00	20250.00	810	9	1053	8101	0.129983952598445	0.20303020906462	0.20303020906462	false	false	false	true
e1c189d4-3a66-4962-96ec-ead8290d5ee8	2026-08-28 12:57	2026-08-28 12:57	2026-08-28 12:57	BEKE	BEKE270115P00017000	put	17.0000	2027-01-15	1.1000	1.0000	1.1500	18.1100	10890.00	10780.00	110.00	99	7	99	816	0.121323529411765	0.392812844499043	0.392812844499043	false	false	false	true
a572e5e3-285c-4eac-8b7f-910491855d40	2026-08-28 12:34	2026-08-28 12:34	2026-08-28 12:34	IRM	IRM260911P00114000	put	114.0000	2026-09-11	1.0500	1.0500	1.3500	118.5100	13860.00	0.00	13860.00	132	6	146	22	6.63636363636364	0.307014943207731	0.307014943207731	false	false	false	true
bb689c2f-4fdc-416c-b1ac-0f000ab7f3d9	2026-08-28 12:33	2026-08-28 12:33	2026-08-28 12:33	AGNC	AGNC260918P00010500	put	10.5000	2026-09-18	0.1000	0.0900	0.1000	10.9150	24070.00	24070.00	0.00	2407	31	12598	591	21.3164128595601	0.256969838171354	0.256969838171354	false	false	false	true
d0c08c02-cba6-49ff-8a38-72fe5541acf9	2026-08-28 12:28	2026-08-28 12:28	2026-08-28 12:28	AGNC	AGNC260918P00010500	put	10.5000	2026-09-18	0.0900	0.0800	0.0900	10.9300	47502.00	47502.00	0.00	5278	53	9571	591	16.1945854483926	0.248997100867737	0.248997100867737	false	false	false	true
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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