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.

728,802 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts728,802 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

6992d1c7-e82d-45c5-9879-0fc6778061c5	2026-08-25 11:24	2026-08-25 11:24	2026-08-25 11:24	UNIT	UNIT270219C00011000	call	11.0000	2027-02-19	1.1000	0.9000	1.3500	9.8950	25740.00	19690.00	5940.00	234	48	430	1	430	0.525658827043387	0.525658827043387	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Real Estate	2359288312.00	2026-11-03	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-25T15:37:01.391907Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
dd463888-2f78-447d-b473-8d6d1d71549e	2026-08-25 11:24	2026-08-25 11:24	2026-08-25 11:24	UNIT	UNIT270219C00011000	call	11.0000	2027-02-19	1.0500	1.0500	1.3500	9.8950	20580.00	0.00	20580.00	196	14	196	1	196	0.507488801804553	0.507488801804553	false	false	false	true
59135c22-d29d-45fb-876f-2bfc92f14e5c	2026-08-25 11:03	2026-08-25 11:03	2026-08-25 11:03	PLD	PLD260918C00145000	call	145.0000	2026-09-18	2.1000	2.0000	2.1000	143.2200	86940.00	3780.00	0.00	414	21	638	2020	0.315841584158416	0.186894839684189	0.186894839684189	false	false	false	true
ab5758e4-21bf-42dd-b35f-c285f697390b	2026-08-25 10:46	2026-08-25 10:46	2026-08-25 10:46	OPEN	OPEN260911C00004000	call	4.0000	2026-09-11	0.0800	0.0700	0.0800	3.5500	27272.00	27272.00	0.00	3409	37	3940	3377	1.16671602013622	0.737526033415509	0.737526033415509	false	false	false	true
b110e2db-61c6-4a7a-84f2-4f786cb7b566	2026-08-25 10:45	2026-08-25 10:45	2026-08-25 10:45	EQIX	EQIX260918C01150000	call	1150.0000	2026-09-18	8.9000	7.5000	9.0000	1079.9300	57850.00	56960.00	890.00	65	23	66	313	0.210862619808307	0.279625254265359	0.279625254265359	false	false	false	true
6f67e785-773e-4181-aa39-bd3bb3e8f97b	2026-08-25 10:43	2026-08-25 10:43	2026-08-25 10:43	AGNC	AGNC261218P00011000	put	11.0000	2026-12-18	0.7500	0.7400	0.7700	10.8950	15150.00	2025.00	13125.00	202	7	380	4638	0.0819318671841311	0.314217686732558	0.314217686732558	false	false	false	true
db9d5381-1587-48de-b85a-9b8bfee35de9	2026-08-25 10:37	2026-08-25 10:37	2026-08-25 10:37	EQIX	EQIX261218C01140000	call	1140.0000	2026-12-18	54.8000	50.5000	54.8000	1076.1400	443880.00	443880.00	0.00	81	29	81	25	3.24	0.315869706923504	0.313604219956311	false	false	false	true
1c6c871d-dcc6-406e-a3e0-d525f29597ea	2026-08-25 09:58	2026-08-25 09:58	2026-08-25 09:58	GEO	GEO270115C00030000	call	30.0000	2027-01-15	5.3000	5.2000	5.5000	31.8950	31800.00	0.00	27030.00	60	12	65	7292	0.00891387822270982	0.525671263883005	0.525671263883005	false	false	false	true
566361b9-7adb-460c-8098-a731b561d58a	2026-08-25 09:49	2026-08-25 09:49	2026-08-25 09:49	VICI	VICI270617P00027500	put	27.5000	2027-06-17	2.9500	2.6000	2.9500	26.5350	13570.00	13570.00	0.00	46	9	76	4436	0.0171325518485122	0.30582289805703	0.30582289805703	false	false	false	true
79e0ad36-5496-4ecb-af1c-fd92d447788e	2026-08-25 09:38	2026-08-25 09:38	2026-08-25 09:38	OPEN	OPEN261120C00004000	call	4.0000	2026-11-20	0.4400	0.4000	0.4600	3.4901	39512.00	34760.00	4752.00	898	5	918	12772	0.0718759787034137	0.903058284362367	0.903058284362367	false	false	false	true
f564b74a-ae62-4f7c-a089-3e16cfbf53d5	2026-08-25 09:32	2026-08-25 09:32	2026-08-25 09:32	CSGP	CSGP270319P00035000	put	35.0000	2027-03-19	6.1000	6.0000	6.5000	32.2950	122000.00	14640.00	1220.00	200	7	200	917	0.218102508178844	0.513499735216888	0.513499735216888	false	false	false	true
adbc3ccc-5b81-4cef-bb76-1fc9a594ccb3	2026-08-24 15:48	2026-08-24 15:48	2026-08-24 15:48	FRMI	FRMI280121C00015000	call	15.0000	2028-01-21	1.4000	1.4000	1.4500	5.5450	10920.00	0.00	2240.00	78	7	102	3857	0.0264454239045891	1.08986023558894	1.08986023558894	false	false	false	true
e62f4076-86a4-4923-ba58-f48eced41b5f	2026-08-24 14:45	2026-08-24 14:44	2026-08-24 14:44	AGNC	AGNC260918C00011000	call	11.0000	2026-09-18	0.1800	0.1700	0.1800	10.9850	10584.00	10584.00	0.00	588	8	6468	22833	0.283274208382604	0.151045292830877	0.151045292830877	false	false	false	true
7e5e3409-8012-435f-8e14-781c243badbd	2026-08-24 14:40	2026-08-24 14:39	2026-08-24 14:39	CBRE	CBRE260918C00170000	call	170.0000	2026-09-18	0.5000	0.4500	0.6000	151.2700	20100.00	0.00	20100.00	402	17	2749	3461	0.794279110083791	0.314891412670234	0.314891412670234	false	false	false	true
564143b2-d0f8-481a-94b0-14cc81af896f	2026-08-24 14:40	2026-08-24 14:39	2026-08-24 14:39	CBRE	CBRE260918C00170000	call	170.0000	2026-09-18	0.5000	0.5000	0.6000	151.2700	13950.00	0.00	13950.00	279	5	3028	3461	0.874891649812193	0.314891412670234	0.314891412670234	false	false	false	true
0731a34f-e375-471c-b3bd-7353289ba9b9	2026-08-24 14:12	2026-08-24 14:12	2026-08-24 14:12	IRM	IRM260918P00120000	put	120.0000	2026-09-18	4.2000	4.2000	4.7000	120.1700	20160.00	0.00	20160.00	48	5	199	898	0.221603563474388	0.354460459474789	0.354460459474789	false	false	false	true
97924770-2a9c-4e54-ad26-5aa5efda113d	2026-08-24 14:12	2026-08-24 14:12	2026-08-24 14:12	VICI	VICI270617P00027500	put	27.5000	2027-06-17	2.8500	2.5500	2.8500	26.7050	15957.00	15957.00	0.00	56	7	840	4049	0.207458631760929	0.302788604901031	0.302788604901031	false	false	false	true
b8688c9c-128d-4ffe-a7e9-347a92b179b2	2026-08-24 14:08	2026-08-24 14:08	2026-08-24 14:08	OPEN	OPEN270115C00004000	call	4.0000	2027-01-15	0.5800	0.5800	0.6400	3.4900	29000.00	0.00	29000.00	500	6	1718	8753	0.196275562664229	0.853284764649039	0.853284764649039	false	false	false	true
65318da0-95bd-4964-b5ca-9bf065f3b215	2026-08-24 13:45	2026-08-24 13:45	2026-08-24 13:45	GEO	GEO280121C00045000	call	45.0000	2028-01-21	5.0000	5.0000	5.2000	32.1800	65030.00	0.00	65030.00	130	5	131	4026	0.0325384997516145	0.533866824405991	0.533866824405991	false	false	false	true
d2982fc1-94dc-42a6-b148-1c2c0d62d36f	2026-08-24 13:39	2026-08-24 13:39	2026-08-24 13:39	OPEN	OPEN270115P00003000	put	3.0000	2027-01-15	0.4500	0.4200	0.4500	3.4900	21555.00	21555.00	0.00	479	23	1011	3223	0.31368290412659	0.860880035793685	0.860880035793685	false	false	false	true
9e35b904-a74a-47c6-9248-753d95f2f30d	2026-08-24 13:36	2026-08-24 13:36	2026-08-24 13:36	CPT	CPT261016C00115000	call	115.0000	2026-10-16	1.0000	0.8000	1.0000	108.1450	11100.00	11100.00	0.00	111	13	476	11	43.2727272727273	0.188798984562079	0.188798984562079	false	false	false	true
59d57515-ef67-421f-8c78-be3ab2ff7cd5	2026-08-24 13:34	2026-08-24 13:34	2026-08-24 13:34	CPT	CPT261016C00115000	call	115.0000	2026-10-16	0.9500	0.8000	0.9500	107.9800	17860.00	17860.00	0.00	188	26	254	11	23.0909090909091	0.187760940968229	0.187760940968229	false	false	false	true
7f4f329b-5775-47d7-a8fc-accbf163cd8a	2026-08-24 13:19	2026-08-24 13:19	2026-08-24 13:19	DLR	DLR261016C00175000	call	175.0000	2026-10-16	16.2000	15.0000	16.2000	188.6600	87480.00	87480.00	0.00	54	18	60	16	3.75	0.232328134079467	0.232328134079467	false	false	false	true
6407d5d4-2c4f-439f-ac5d-62c2a0334dd2	2026-08-24 12:32	2026-08-24 12:32	2026-08-24 12:32	CCI	CCI270617P00075000	put	75.0000	2027-06-17	7.8000	7.7000	8.5000	76.6900	28080.00	0.00	26520.00	36	19	105	20	5.25	0.363486324213556	0.363486324213556	true	false	false	true
6ae00637-c969-4a34-9ffa-65a55edfcc55	2026-08-24 12:23	2026-08-24 12:23	2026-08-24 12:23	CSGP	CSGP261016C00035000	call	35.0000	2026-10-16	1.5500	1.4500	1.6000	32.5000	16275.00	15965.00	0.00	105	20	137	510	0.268627450980392	0.497143239654562	0.497143239654562	false	false	false	true
b85d0b81-e186-48ea-bb42-944ba2fa1fd3	2026-08-24 12:03	2026-08-24 12:03	2026-08-24 12:03	AMT	AMT261218C00200000	call	200.0000	2026-12-18	3.8000	3.5000	4.2000	178.5800	97280.00	4940.00	92340.00	256	11	294	503	0.584493041749503	0.253771270910929	0.253771270910929	false	false	false	true
45d599ba-0c93-4877-9fcc-030724094e63	2026-08-24 11:40	2026-08-24 11:40	2026-08-24 11:40	RYN	RYN270219C00022500	call	22.5000	2027-02-19	0.8000	0.8000	0.8500	21.1791	14240.00	0.00	14240.00	178	5	443	146	3.03424657534247	0.197535714340733	0.197535714340733	false	false	false	true
e3d2ffe2-36ca-41aa-9da7-7f38eb6b2049	2026-08-24 11:40	2026-08-24 11:39	2026-08-24 11:39	WY	WY261016C00027000	call	27.0000	2026-10-16	0.1500	0.1500	0.2500	24.4410	14925.00	0.00	14925.00	995	37	1105	580	1.9051724137931	0.224287964172287	0.224287964172287	false	false	false	true
1fea440f-49e9-497c-8d28-378d806928eb	2026-08-24 11:35	2026-08-24 11:35	2026-08-24 11:35	FRMI	FRMI261016P00006000	put	6.0000	2026-10-16	1.0500	1.0500	1.2000	5.6750	10500.00	0.00	10500.00	100	5	102	2168	0.0470479704797048	1.0196324044235	1.0196324044235	false	false	false	true
c0b47080-9bb1-42df-90d3-a8fcc0c3ee46	2026-08-24 11:32	2026-08-24 11:32	2026-08-24 11:32	VICI	VICI270617P00027500	put	27.5000	2027-06-17	2.7500	2.5000	2.7500	26.8010	15395.00	15395.00	0.00	56	5	278	4049	0.0686589281304026	0.296702330987352	0.296702330987352	false	false	false	true
0ceff789-7bf2-4cc9-9a05-998edbc2156f	2026-08-24 11:15	2026-08-24 11:15	2026-08-24 11:15	AGNC	AGNC260918C00011000	call	11.0000	2026-09-18	0.1600	0.1500	0.1600	10.9299	23632.00	23632.00	0.00	1477	50	2395	22833	0.104892042219594	0.157438774619099	0.157438774619099	false	false	false	true
a3f3e1db-c70b-4881-99ea-a2f919661858	2026-08-24 10:46	2026-08-24 10:46	2026-08-24 10:46	UNIT	UNIT270115C00010000	call	10.0000	2027-01-15	1.3000	1.2000	1.3000	9.7300	33800.00	33800.00	0.00	260	24	260	23239	0.0111880889883386	0.556074276248496	0.556074276248496	false	false	false	true
beada02f-956f-4db3-807d-0634afc56123	2026-08-24 10:22	2026-08-24 10:22	2026-08-24 10:22	CBRE	CBRE261016P00155000	put	155.0000	2026-10-16	7.7000	7.3000	7.7000	153.7300	15400.00	15400.00	0.00	20	14	21	0	0	0.320242954948741	0.320242954948741	false	false	false	true
d39803cb-b62a-4325-a396-ce2fa5107cd1	2026-08-24 10:16	2026-08-24 10:16	2026-08-24 10:16	CIM	CIM261218C00012000	call	12.0000	2026-12-18	0.2500	0.2500	0.3000	11.5900	15000.00	0.00	15000.00	600	23	815	121	6.73553719008264	0.138980745957751	0.138980745957751	false	false	false	true
134c3f6b-7f77-4063-bc91-33bc622eb836	2026-08-24 10:11	2026-08-24 10:11	2026-08-24 10:11	MPT	MPT270115C00005000	call	5.0000	2027-01-15	0.0800	0.0700	0.0900	4.1100	21312.00	0.00	21272.00	2664	15	2700	19096	0.141390867197319	0.305173035076524	0.305173035076524	false	false	false	true
a113385d-04c4-4914-bfba-1e857c3d3af1	2026-08-24 09:49	2026-08-24 09:49	2026-08-24 09:49	GEO	GEO270115C00037000	call	37.0000	2027-01-15	3.1000	2.6500	3.1000	33.0808	77500.00	77500.00	0.00	250	5	751	1290	0.582170542635659	0.528767871839747	0.528767871839747	false	false	false	true
2c7c7c86-ed8f-41e4-92bb-0c751656696a	2026-08-24 09:45	2026-08-24 09:45	2026-08-24 09:45	FRMI	FRMI260828C00005500	call	5.5000	2026-08-28	0.3000	0.3000	0.5500	5.6200	22200.00	0.00	22200.00	740	12	1162	1600	0.72625	1.00751757147387	1.00751757147387	false	false	false	true
cf16de44-b0f3-4e15-be94-57ac745b973a	2026-08-24 09:42	2026-08-24 09:42	2026-08-24 09:42	GEO	GEO270115C00037000	call	37.0000	2027-01-15	3.1000	2.6500	3.1000	33.0700	77500.00	77500.00	0.00	250	8	251	1290	0.194573643410853	0.529359484898865	0.529359484898865	false	false	false	true
1333bdbd-28c4-416b-a2e2-1618938fee4c	2026-08-21 15:53	2026-08-21 15:53	2026-08-21 15:53	ARE	ARE260918P00052500	put	52.5000	2026-09-18	1.8500	1.7500	1.9000	53.0600	12025.00	11655.00	0.00	65	23	168	51	3.29411764705882	0.374401954134987	0.375887778884465	false	false	false	true
9f35a60b-2ad3-4e27-9498-d875f604e1a5	2026-08-21 15:44	2026-08-21 15:44	2026-08-21 15:44	MRP	MRP260918C00030000	call	30.0000	2026-09-18	1.0000	1.0000	1.1500	30.4550	11000.00	0.00	11000.00	110	13	402	730	0.550684931506849	0.208555749003084	0.208555749003084	false	false	false	true
bf894287-beda-47bd-8835-891866381a3b	2026-08-21 15:43	2026-08-21 15:43	2026-08-21 15:43	GEO	GEO260918C00031000	call	31.0000	2026-09-18	2.7000	2.6500	2.8000	32.7200	78841.00	55080.00	23761.00	292	36	21890	1130	19.3716814159292	0.466467754322157	0.466467754322157	false	false	false	true
8ef3967e-13b0-4f40-9273-aee9b96b7ba1	2026-08-21 15:41	2026-08-21 15:41	2026-08-21 15:41	GEO	GEO260918C00032000	call	32.0000	2026-09-18	2.1500	2.0000	2.2500	32.8350	37625.00	32680.00	4300.00	175	11	432	2153	0.200650255457501	0.460083749870751	0.460083749870751	false	false	false	true
5f215779-cdf2-4f7d-86c5-14b89decf686	2026-08-21 15:40	2026-08-21 15:39	2026-08-21 15:39	GEO	GEO270115C00040000	call	40.0000	2027-01-15	2.1500	1.8000	2.1500	32.8250	53750.00	53750.00	0.00	250	6	558	9622	0.0579921014342133	0.520010963299235	0.520010963299235	false	false	false	true
5c8ce63e-7585-4f83-98f8-05be3b153d7f	2026-08-21 15:40	2026-08-21 15:40	2026-08-21 15:40	CXW	CXW260821C00032000	call	32.0000	2026-08-21	2.0000	2.0000	2.1000	33.9750	48800.00	0.00	16200.00	244	74	383	3830	0.1	6.81603197669789	5.89902081611275	false	false	false	true
2389b2b5-9eec-4040-9bfb-bacc66428471	2026-08-21 15:38	2026-08-21 15:38	2026-08-21 15:38	GEO	GEO270115C00040000	call	40.0000	2027-01-15	2.1500	1.8000	2.1500	32.8100	53750.00	53750.00	0.00	250	13	308	9622	0.0320099771357306	0.520691138594445	0.520691138594445	false	false	false	true
be34c78d-551c-4a4e-a39c-c97c445ce1cb	2026-08-21 15:36	2026-08-21 15:36	2026-08-21 15:36	OPEN	OPEN261120C00003000	call	3.0000	2026-11-20	0.8500	0.8500	0.8800	3.5050	13515.00	0.00	13515.00	159	8	516	2625	0.196571428571429	0.848061848033688	0.848061848033688	true	false	false	true
a1b67f3a-cba0-480a-9198-b033c02a7fe8	2026-08-21 15:23	2026-08-21 15:23	2026-08-21 15:23	ARE	ARE261016P00050000	put	50.0000	2026-10-16	2.1000	1.7500	2.1000	53.1400	21000.00	1260.00	0.00	100	7	121	1601	0.075577763897564	0.443086610850519	0.443086610850519	false	false	false	true
3cba90a2-e627-4b06-97fb-cf76337ae575	2026-08-21 15:15	2026-08-21 15:15	2026-08-21 15:15	GEO	GEO260918C00031000	call	31.0000	2026-09-18	2.7000	2.6500	2.7000	32.6650	27000.00	27000.00	0.00	100	7	20995	1130	18.5796460176991	0.47832603963824	0.47832603963824	false	false	false	true
49ca02bb-eb07-4072-a249-f15ca486c824	2026-08-21 14:49	2026-08-21 14:49	2026-08-21 14:49	GEO	GEO260918C00031000	call	31.0000	2026-09-18	2.5000	2.4500	2.5000	32.4100	75000.00	75000.00	0.00	300	19	20409	1130	18.0610619469027	0.469794306041064	0.469794306041064	false	false	false	true
c7576407-089a-45a4-8859-6fffc16cef7e	2026-08-21 14:44	2026-08-21 14:43	2026-08-21 14:43	GEO	GEO260918C00035000	call	35.0000	2026-09-18	0.7000	0.6000	0.7000	32.3100	21000.00	21000.00	0.00	300	9	20678	2370	8.72489451476793	0.455059650495724	0.455059650495724	false	false	false	true