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: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

b5c6a079-d810-4306-9137-4516492353bc	2026-09-18 11:56	2026-09-18 11:56	2026-09-18 11:56	O	O270115P00062500	put	62.5000	2027-01-15	6.2000	6.2000	6.5000	56.7150	83700.00	0.00	83700.00	135	24	1045	2872	0.363857938718663	0.233158867293709	0.233158867293709	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Real Estate	53612713750.00	2026-11-02	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-18T16:02:16.049420Z"}	2026-09-18	2026-09-18 21:15	2026-09-18 21:15
92e39153-9f06-4753-9749-714917e4697f	2026-09-18 11:51	2026-09-18 11:51	2026-09-18 11:51	STWD	STWD270319P00015000	put	15.0000	2027-03-19	1.1500	1.0000	1.1500	14.9650	28750.00	11500.00	0.00	250	5	253	3792	0.0667194092827004	0.309632071721391	0.309632071721391	false	false	false	true
35aebd23-21a3-4233-b8e6-e280f89329e2	2026-09-18 11:37	2026-09-18 11:37	2026-09-18 11:37	BEKE	BEKE261120C00018000	call	18.0000	2026-11-20	0.5000	0.4500	0.5500	16.3050	11750.00	11700.00	0.00	235	29	235	0	0	0.394141691328729	0.393486410409103	false	false	false	true
6f434e53-8945-4396-831e-3bfb7000cdd2	2026-09-18 11:37	2026-09-18 11:37	2026-09-18 11:37	BEKE	BEKE261016C00017000	call	17.0000	2026-10-16	0.4000	0.3500	0.4500	16.3000	10000.00	9720.00	0.00	250	17	250	346	0.722543352601156	0.367792477871103	0.367792477871103	false	false	false	true
43c879ce-0605-4473-ab85-9cb245b7494e	2026-09-18 10:56	2026-09-18 10:56	2026-09-18 10:56	AMT	AMT270917P00150000	put	150.0000	2027-09-17	8.3000	7.6000	10.6000	174.2902	110390.00	0.00	110390.00	133	14	133	8	16.625	0.318608705445913	0.318608705445913	true	false	false	true
b408a3c0-4d71-4247-897f-b8acf84a6bf2	2026-09-18 10:55	2026-09-18 10:55	2026-09-18 10:55	FRMI	FRMI261120C00005000	call	5.0000	2026-11-20	0.8500	0.8500	0.9000	4.9250	18700.00	0.00	18700.00	220	16	220	3851	0.0571280186964425	1.06985409094156	1.06985409094156	false	false	false	true
213efefb-7357-4bdd-802b-ea6e6162ea47	2026-09-18 10:41	2026-09-18 10:41	2026-09-18 10:41	CSGP	CSGP270319P00020000	put	20.0000	2027-03-19	0.7000	0.7000	0.7500	29.7700	10920.00	0.00	10920.00	156	8	664	24	27.6666666666667	0.560909386608104	0.560635368109861	false	false	false	true
8f3f04b9-89e5-4a02-9896-a5e4a1c9aee7	2026-09-18 10:13	2026-09-18 10:13	2026-09-18 10:13	CXW	CXW261120C00038000	call	38.0000	2026-11-20	2.1500	1.9500	2.6000	35.9300	63210.00	215.00	62995.00	294	23	294	592	0.496621621621622	0.486432703753218	0.486432703753218	false	false	false	true
6e1afcd7-885b-4328-98c5-44056bbf0239	2026-09-18 10:13	2026-09-18 10:13	2026-09-18 10:13	CXW	CXW261120C00039000	call	39.0000	2026-11-20	1.8500	1.8500	2.2000	35.9300	125800.00	0.00	123025.00	680	39	1181	2	590.5	0.493300302099759	0.493300302099759	false	false	false	true
be14bf79-db7f-431f-b927-f183ad633028	2026-09-18 10:10	2026-09-18 10:10	2026-09-18 10:10	AMT	AMT261016P00170000	put	170.0000	2026-10-16	3.9000	3.9000	4.3000	173.3800	164580.00	0.00	164580.00	422	41	424	241	1.75933609958506	0.297598855572663	0.297598855572663	false	false	false	true
018bc6a8-8c38-4a43-b0f8-6b1565551595	2026-09-18 10:04	2026-09-18 10:03	2026-09-18 10:03	BEKE	BEKE270416C00017000	call	17.0000	2027-04-16	1.8500	1.8000	1.9000	16.3000	11285.00	3330.00	3330.00	61	10	201	1	201	0.400513243112415	0.400513243112415	false	false	false	true
604260ad-ad78-43f4-a431-85bc3b725ba5	2026-09-18 09:41	2026-09-18 09:41	2026-09-18 09:41	CPT	CPT270219C00110000	call	110.0000	2027-02-19	1.1500	1.1500	3.9000	100.1900	13685.00	0.00	13685.00	119	6	119	6	19.8333333333333	0.143984547590437	0.143984547590437	false	false	false	true
642f244d-f8a9-4931-a6aa-0b0a177eb294	2026-09-18 09:35	2026-09-18 09:35	2026-09-18 09:35	CIGI	CIGI260918P00100000	put	100.0000	2026-09-18	12.0000	12.0000	12.6000	88.1150	25200.00	0.00	19200.00	21	7	37	120	0.308333333333333	2.70800827808236	2.70800827808236	false	false	false	true
dcf4a5b0-f65b-41c2-9eb7-faf931214c16	2026-09-17 15:52	2026-09-17 15:51	2026-09-17 15:51	CBRE	CBRE261016C00145000	call	145.0000	2026-10-16	3.5000	3.5000	4.6000	139.0000	10500.00	0.00	10500.00	30	7	87	79	1.10126582278481	0.3490242504334	0.3490242504334	true	false	false	true
793c57a7-2ca0-423b-ba88-ae5680eeb601	2026-09-17 15:47	2026-09-17 15:47	2026-09-17 15:47	IRM	IRM261120C00115000	call	115.0000	2026-11-20	6.9000	6.5000	7.3000	114.3800	126960.00	126270.00	690.00	184	37	184	0	0	0.358168705358614	0.356204990728755	false	false	false	true
073ebac3-f529-4367-9d19-29011fe1b1ba	2026-09-17 15:45	2026-09-17 15:45	2026-09-17 15:45	AGNC	AGNC261002P00010000	put	10.0000	2026-10-02	0.2300	0.2200	0.2500	9.9750	109204.00	0.00	109204.00	4748	7	10034	10039	0.999501942424544	0.279570584119487	0.279570584119487	false	false	false	true
f335bd32-5594-4e70-9321-038c493bb9bf	2026-09-17 15:40	2026-09-17 15:39	2026-09-17 15:39	EQIX	EQIX261016C01060000	call	1060.0000	2026-10-16	19.6000	19.6000	21.2000	1026.0600	98000.00	0.00	98000.00	50	21	53	8	6.625	0.278886153807402	0.278886153807402	false	false	false	true
3daccd2d-5d23-478b-813b-6e1612068b19	2026-09-17 15:11	2026-09-17 15:10	2026-09-17 15:10	AGNC	AGNC261002P00010000	put	10.0000	2026-10-02	0.2500	0.2400	0.2500	9.9600	17875.00	17875.00	0.00	715	16	5097	10039	0.507719892419564	0.295086988508152	0.295086988508152	true	false	false	true
391ab5f3-63e0-4e0b-94f0-7369ca2d629e	2026-09-17 14:33	2026-09-17 14:33	2026-09-17 14:33	OPEN	OPEN280915C00007000	call	7.0000	2028-09-15	0.7100	0.6800	0.7100	2.5750	12425.00	12425.00	0.00	175	13	619	21201	0.0291967360030187	0.945660579182437	0.945660579182437	false	false	false	true
d0fd84b3-3c8b-4b98-b02d-a2fcdf8b545b	2026-09-17 14:19	2026-09-17 14:18	2026-09-17 14:18	GEO	GEO261016C00033000	call	33.0000	2026-10-16	1.1500	1.0000	1.2000	31.8000	34270.00	11155.00	23115.00	298	5	304	1039	0.292589027911453	0.451250378832311	0.451250378832311	false	false	false	true
5cfe8113-f608-4716-8c41-43d717ea48ff	2026-09-17 13:43	2026-09-17 13:43	2026-09-17 13:43	EQIX	EQIX270917P01000000	put	1000.0000	2027-09-17	101.8000	99.0000	103.4000	1025.6800	71260.00	71260.00	0.00	7	7	26	1	26	0.339557616141854	0.339557616141854	false	false	false	true
dee07626-2ae0-4752-b00d-c9272a75ed33	2026-09-17 13:29	2026-09-17 13:29	2026-09-17 13:29	SPG	SPG261016C00210000	call	210.0000	2026-10-16	3.4000	3.2000	3.6000	205.8400	149940.00	0.00	149260.00	441	20	454	445	1.02022471910112	0.212285361246117	0.212285361246117	false	false	false	true
323f80ed-fa8d-445c-8415-18f85b447acd	2026-09-17 13:23	2026-09-17 13:23	2026-09-17 13:23	CCI	CCI270115C00085000	call	85.0000	2027-01-15	1.7500	1.6500	1.7500	73.8001	17500.00	17500.00	0.00	100	12	409	16142	0.0253376285466485	0.296279101393698	0.296279101393698	false	false	false	true
3edf786c-01d8-4f99-bd66-6d34f83c31d4	2026-09-17 13:06	2026-09-17 13:06	2026-09-17 13:06	CXW	CXW261016P00036000	put	36.0000	2026-10-16	2.1500	2.0000	2.1500	35.2000	11180.00	11180.00	0.00	52	8	55	0	0	0.447045909452203	0.447045909452203	false	false	false	true
c7d25756-d2f2-40e1-96d1-84fb73ef6079	2026-09-17 12:30	2026-09-17 12:30	2026-09-17 12:30	IRM	IRM261016C00125000	call	125.0000	2026-10-16	0.8500	0.8000	0.9500	114.3000	12070.00	170.00	11900.00	142	9	152	247	0.615384615384615	0.305328292728258	0.305328292728258	false	false	false	true
629530fd-3243-4be6-892b-87ce2a5abddb	2026-09-17 12:22	2026-09-17 12:22	2026-09-17 12:22	AMT	AMT261016P00185000	put	185.0000	2026-10-16	11.3000	11.1000	11.4000	176.7050	71190.00	71190.00	0.00	63	13	65	20	3.25	0.332803859917299	0.332803859917299	false	false	false	true
6400a7fe-09b5-4c08-88c0-7f12c3e5b059	2026-09-17 12:17	2026-09-17 12:17	2026-09-17 12:17	WELL	WELL261016P00250000	put	250.0000	2026-10-16	18.2000	17.5000	18.2000	232.3600	187460.00	187460.00	0.00	103	22	108	200	0.54	0.244867322799657	0.244867322799657	false	false	false	true
3895fc31-da42-42d9-9fe5-fc4a2f53afc5	2026-09-17 12:17	2026-09-17 12:17	2026-09-17 12:17	WELL	WELL261016P00240000	put	240.0000	2026-10-16	10.1000	9.6000	10.1000	232.3600	284820.00	284820.00	0.00	282	38	368	116	3.17241379310345	0.227956460887289	0.227956460887289	false	false	false	true
ef32ba36-b4d0-4477-b710-6f72e62ec53b	2026-09-17 12:04	2026-09-17 12:04	2026-09-17 12:04	JOE	JOE261120C00065000	call	65.0000	2026-11-20	3.0100	3.0000	3.1000	64.7050	29220.00	3720.00	25500.00	97	8	100	0	0	0.269872486645512	0.269872486645512	false	false	false	true
ab122e4f-ba37-4cbe-9b2c-1e17e81ba836	2026-09-17 11:51	2026-09-17 11:51	2026-09-17 11:51	AGNC	AGNC261002P00010000	put	10.0000	2026-10-02	0.2500	0.2400	0.2500	9.9700	27075.00	27075.00	0.00	1083	14	4104	10039	0.408805657934057	0.301295621880637	0.301295621880637	true	false	false	true
1e8c52b3-73a8-4a20-94f2-f03b2c6e01af	2026-09-17 11:43	2026-09-17 11:43	2026-09-17 11:43	IRS	IRS270115C00015000	call	15.0000	2027-01-15	2.3500	0.2000	2.3500	15.8806	18800.00	18800.00	0.00	80	12	80	449	0.178173719376392	0.501443880619977	0.501443880619977	false	false	false	true
5745a0fd-217f-4813-a170-735e4857c766	2026-09-17 11:40	2026-09-17 11:40	2026-09-17 11:40	CBRE	CBRE261016C00145000	call	145.0000	2026-10-16	3.5000	3.3000	3.9000	139.9800	16100.00	0.00	16100.00	46	14	47	79	0.594936708860759	0.342878380408317	0.342878380408317	false	false	false	true
9913e534-784e-4612-8162-ecf3145c3602	2026-09-17 11:38	2026-09-17 11:37	2026-09-17 11:37	AGNC	AGNC261002P00010000	put	10.0000	2026-10-02	0.2500	0.2400	0.2500	9.9750	56750.00	56750.00	0.00	2270	25	2732	10039	0.272138659229007	0.304365097037194	0.304365097037194	true	false	false	true
42d00d48-269d-4cc5-bb36-e4aeee6068cc	2026-09-17 11:32	2026-09-17 11:32	2026-09-17 11:32	VICI	VICI270115C00025000	call	25.0000	2027-01-15	0.7000	0.7000	0.7500	24.1337	94500.00	0.00	94500.00	1350	9	1791	605	2.9603305785124	0.16803325379204	0.16803325379204	false	false	false	true
a23375cb-b961-4bf4-8799-7db95c1d2605	2026-09-17 11:31	2026-09-17 11:31	2026-09-17 11:31	O	O261218P00057500	put	57.5000	2026-12-18	2.2500	2.2000	2.2500	57.0700	180675.00	180675.00	0.00	803	21	1120	1403	0.798289379900214	0.201423043670039	0.201423043670039	false	false	false	true
e9095685-825f-4b72-8be4-f5e09da271c7	2026-09-17 10:34	2026-09-17 10:34	2026-09-17 10:34	CCI	CCI280121P00075000	put	75.0000	2028-01-21	11.8000	10.0000	11.8000	72.9750	35400.00	35400.00	0.00	30	5	30	350	0.0857142857142857	0.397428671100477	0.397428671100477	false	false	false	true
f67faac9-b9fc-45fb-af74-14f88917ee5c	2026-09-17 10:25	2026-09-17 10:25	2026-09-17 10:25	WELL	WELL261016P00240000	put	240.0000	2026-10-16	9.7000	9.3000	9.7000	233.2800	58200.00	49470.00	0.00	60	16	80	116	0.689655172413793	0.236077124605785	0.236077124605785	false	false	false	true
f3de7539-072e-453c-84b5-c9e4c94d1d01	2026-09-17 10:15	2026-09-17 10:15	2026-09-17 10:15	GEO	GEO260918C00031000	call	31.0000	2026-09-18	0.8500	0.8500	1.1000	31.7300	18275.00	0.00	18275.00	215	11	254	25692	0.00988634594426281	0.571903047188264	0.571903047188264	false	false	false	true
d2196eb3-ca4f-4812-9e04-ac8042dbef06	2026-09-17 10:14	2026-09-17 10:14	2026-09-17 10:14	DLR	DLR290119P00150000	put	150.0000	2029-01-19	15.5000	15.5000	15.7000	182.8400	354950.00	0.00	6200.00	229	18	400	0	0	0.363774516785429	0.363774516785429	false	false	false	true
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
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
ae316a8f-69d8-45f9-9362-13218a25f06b	2026-09-16 15:22	2026-09-16 15:22	2026-09-16 15:22	SLG	SLG261218C00050000	call	50.0000	2026-12-18	4.4000	3.5000	4.4000	50.2450	35198.00	35198.00	0.00	80	22	120	424	0.283018867924528	0.399095298429596	0.399095298429596	false	false	false	true
a9b0499b-1876-4fe4-b0d3-82bd6f3aa440	2026-09-16 15:20	2026-09-16 15:20	2026-09-16 15:20	SLG	SLG270115C00052500	call	52.5000	2027-01-15	3.1000	3.1000	3.9000	50.4000	21701.00	0.00	21701.00	70	21	70	1107	0.0632339656729901	0.31996569387563	0.31996569387563	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
3d9c5f63-6c3e-47d4-a6fd-2c58a39670dd	2026-09-16 15:13	2026-09-16 15:13	2026-09-16 15:13	SLG	SLG270219C00057500	call	57.5000	2027-02-19	2.0500	2.0500	3.0000	50.7600	10250.00	0.00	10250.00	50	19	51	15	3.4	0.309902369973381	0.309902369973381	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