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.

609,118 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts609,118 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:alert_rule = RepeatedHits×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	expiry

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	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ADR	Real Estate	18001535976.00	2026-11-09	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-28T17:15:24.821907Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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