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.

523,327 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts523,327 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

670691d0-4719-49de-a452-a4392928ba8d	2026-09-08 15:03	2026-09-08 15:03	2026-09-08 15:03	GEO	GEO270115C00031000	call	31.0000	2027-01-15	4.5000	4.4000	4.7000	31.8500	157950.00	53550.00	900.00	351	6	354	344	1.02906976744186	0.518800073491689	0.518800073491689	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Real Estate	4060464166.00	2026-11-05	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-08T19:30:09.198364Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
6c082e07-910a-4278-9dc0-7e12ca4d940f	2026-09-08 15:02	2026-09-08 15:02	2026-09-08 15:02	FRMI	FRMI270115P00005000	put	5.0000	2027-01-15	1.0000	0.9000	1.0000	5.8726	33300.00	33300.00	0.00	333	21	395	14314	0.027595361184854	1.13552276588446	1.13380029433607	false	false	false	true
4ff0a7e8-85ff-428f-ab4b-f46cbfb6d682	2026-09-08 14:47	2026-09-08 14:47	2026-09-08 14:47	AGNC	AGNC270115P00010000	put	10.0000	2027-01-15	0.3400	0.3200	0.3400	10.7350	17000.00	17000.00	0.00	500	5	1051	19411	0.0541445572098295	0.283463680878296	0.283463680878296	false	false	false	true
ee1cb5ef-3754-4354-8dba-fb767cd69e73	2026-09-08 14:20	2026-09-08 14:20	2026-09-08 14:20	GEO	GEO261120C00032000	call	32.0000	2026-11-20	3.2000	3.0000	3.4000	31.9300	17280.00	12480.00	1600.00	54	9	60	343	0.174927113702624	0.549849667654639	0.549849667654639	true	false	false	true
5f4d53f3-6f45-47e9-b80c-eb0334d7ee08	2026-09-08 14:11	2026-09-08 14:11	2026-09-08 14:11	OPEN	OPEN280121C00010000	call	10.0000	2028-01-21	0.5400	0.5100	0.5400	3.1050	13500.00	13500.00	0.00	250	8	575	45033	0.0127684142739769	1.01246405399288	1.01246405399288	false	false	false	true
142c1061-3526-4e3a-bd97-39ff1e9b6b7d	2026-09-08 12:51	2026-09-08 12:51	2026-09-08 12:51	OPEN	OPEN280121C00003000	call	3.0000	2028-01-21	1.3600	1.3600	1.4000	3.1201	27744.00	0.00	27744.00	204	8	387	3794	0.102003162888772	0.911762542708795	0.911762542708795	false	false	false	true
a083119e-780c-45cc-a035-82893b2162f5	2026-09-08 12:30	2026-09-08 12:30	2026-09-08 12:30	OPEN	OPEN280121C00004000	call	4.0000	2028-01-21	1.1200	1.0800	1.1400	3.1150	22400.00	19712.00	2688.00	200	5	310	11783	0.0263090893660358	0.932202842571692	0.932202842571692	false	false	false	true
93aa6933-00f6-4aa3-bd0f-6e5f2f60fb15	2026-09-08 12:29	2026-09-08 12:29	2026-09-08 12:29	MPT	MPT270115P00003000	put	3.0000	2027-01-15	0.1000	0.0700	0.1000	3.9690	10000.00	10000.00	0.00	1000	5	3000	25177	0.11915637288001	0.525971460304524	0.525971460304524	true	false	false	true
3daf3d17-b630-4fb6-a6c5-22b3385c60fa	2026-09-08 12:03	2026-09-08 12:03	2026-09-08 12:03	CSGP	CSGP260918C00030000	call	30.0000	2026-09-18	0.8500	0.7500	0.8500	29.6650	16235.00	16235.00	0.00	191	20	211	375	0.562666666666667	0.5052799315993	0.5052799315993	false	false	false	true
b4d44d22-2b66-47d9-ad1f-8af9bfe77875	2026-09-08 12:01	2026-09-08 12:01	2026-09-08 12:01	CXW	CXW260918C00035000	call	35.0000	2026-09-18	0.9000	0.8500	1.0000	34.7800	31500.00	6660.00	18540.00	350	5	507	6010	0.0843594009983361	0.429640595450014	0.429640595450014	false	false	false	true
6f1f842c-dd5c-44f5-a26c-62f73dca5ab6	2026-09-08 12:00	2026-09-08 12:00	2026-09-08 12:00	CXW	CXW260918C00035000	call	35.0000	2026-09-18	0.9500	0.9000	1.0000	34.8700	14250.00	3040.00	2470.00	150	5	157	6010	0.0261231281198003	0.432129057946706	0.432129057946706	false	false	false	true
8a1ff645-c01b-4bf6-aacb-4a5c717f9839	2026-09-08 11:49	2026-09-08 11:49	2026-09-08 11:49	OPEN	OPEN280915P00003000	put	3.0000	2028-09-15	1.2500	1.2500	1.2800	3.1299	25000.00	0.00	25000.00	200	11	205	739	0.277401894451962	0.923693013256407	0.923693013256407	false	false	false	true
09755f52-af24-44ad-b517-3a1ab809d1d4	2026-09-08 11:33	2026-09-08 11:32	2026-09-08 11:32	FRMI	FRMI260918C00005000	call	5.0000	2026-09-18	0.8500	0.7500	0.9500	5.7150	12750.00	0.00	10880.00	150	5	770	1493	0.515740120562626	1.10099553186773	1.10099553186773	false	false	false	true
be65f0cd-838c-4c0c-b7f5-19b64ca6072a	2026-09-08 11:01	2026-09-08 11:01	2026-09-08 11:01	EQIX	EQIX261016P01120000	put	1120.0000	2026-10-16	86.2000	81.0000	86.2000	1044.4650	422380.00	422380.00	0.00	49	18	49	0	0	0.29779172232222	0.29779172232222	false	false	false	true
1c9f9437-9180-4bde-9459-ddb6f9225ab0	2026-09-08 10:54	2026-09-08 10:54	2026-09-08 10:54	CSGP	CSGP260918P00030000	put	30.0000	2026-09-18	0.7500	0.7000	0.9500	30.1900	148350.00	450.00	147900.00	1978	12	3090	5161	0.598721178066266	0.431069658141382	0.431069658141382	false	false	false	true
2bd54c2f-9f45-4d86-85b5-4eb1556d77d2	2026-09-08 10:53	2026-09-08 10:53	2026-09-08 10:53	CSGP	CSGP260918P00030000	put	30.0000	2026-09-18	0.7500	0.7000	0.9500	30.1900	28500.00	20775.00	7575.00	380	18	973	5161	0.188529354776206	0.4321951438852	0.431069658141382	false	false	false	true
a202206e-c470-47e1-a799-e2693737ed28	2026-09-08 10:53	2026-09-08 10:53	2026-09-08 10:53	CSGP	CSGP260918P00030000	put	30.0000	2026-09-18	0.7500	0.7000	0.9500	30.1800	28950.00	16650.00	12300.00	386	25	592	5161	0.114706452237938	0.442236921450977	0.428812678800034	true	false	false	true
930c523e-7ce6-4b54-a4cd-8372c2ccd6fb	2026-09-08 10:14	2026-09-08 10:14	2026-09-08 10:14	WY	WY280121C00030000	call	30.0000	2028-01-21	1.0500	0.9500	1.4000	22.8250	40425.00	12600.00	27825.00	385	28	385	1159	0.332182916307161	0.255158169379595	0.255158169379595	true	false	false	true
424b2fd0-d245-4e84-932a-49ef980043ca	2026-09-08 09:55	2026-09-08 09:55	2026-09-08 09:55	OPEN	OPEN280915C00007000	call	7.0000	2028-09-15	1.0000	0.9800	1.0400	3.1050	20000.00	17400.00	2600.00	200	15	1012	16912	0.0598391674550615	0.949201791719464	0.949201791719464	false	false	false	true
f732ae44-315a-4f69-a03c-74f54941ea95	2026-09-04 15:49	2026-09-04 15:49	2026-09-04 15:49	WELL	WELL260918C00240000	call	240.0000	2026-09-18	2.8500	2.8500	3.0000	236.5000	50445.00	0.00	50445.00	177	34	1133	1301	0.87086856264412	0.227922513274766	0.227922513274766	false	false	false	true
e3cb1bcc-5c2c-4de6-a754-6845df22b1af	2026-09-04 15:35	2026-09-04 15:35	2026-09-04 15:35	GEO	GEO261120C00035000	call	35.0000	2026-11-20	1.9000	1.8000	1.9000	31.7000	53580.00	53580.00	0.00	282	20	283	2353	0.12027199320017	0.524660369000994	0.524660369000994	false	false	false	true
9ac6708b-02f6-40bc-83f3-a42f35351ae5	2026-09-04 15:25	2026-09-04 15:25	2026-09-04 15:25	FRMI	FRMI270115C00010000	call	10.0000	2027-01-15	0.6000	0.4500	1.2500	5.1699	67920.00	1200.00	3960.00	1132	5	10168	70816	0.143583370989607	1.28376323672974	1.28376323672974	false	false	false	true
05c38cc3-30b4-431c-b34a-63f7a651d1db	2026-09-04 15:25	2026-09-04 15:25	2026-09-04 15:25	FRMI	FRMI261120C00006000	call	6.0000	2026-11-20	0.7500	0.7500	0.9500	5.1350	40200.00	0.00	40200.00	536	6	651	8910	0.0730639730639731	1.10727784916662	1.10727784916662	false	false	false	true
671e6fb7-aebe-414e-8bfa-c139b28ba0b8	2026-09-04 15:25	2026-09-04 15:24	2026-09-04 15:24	FRMI	FRMI270115C00010000	call	10.0000	2027-01-15	0.5000	0.4000	0.5000	5.0650	432324.00	432324.00	0.00	8652	46	8820	70816	0.124548124717578	1.22229244335772	1.22229244335772	false	false	false	true
cdc62143-6888-44ae-9915-1e55ef85c19d	2026-09-04 15:07	2026-09-04 15:06	2026-09-04 15:06	FRMI	FRMI270617C00007000	call	7.0000	2027-06-17	1.4000	1.4000	1.5000	5.0162	18340.00	0.00	18340.00	131	11	145	847	0.171192443919717	1.0896795481521	1.0896795481521	false	false	false	true
9ae1850b-8edc-4f8a-8cfb-2bf963fd9f88	2026-09-04 14:48	2026-09-04 14:47	2026-09-04 14:47	VNO	VNO270115P00035000	put	35.0000	2027-01-15	2.5000	2.4500	2.5500	36.6434	15750.00	4250.00	9250.00	63	7	197	32	6.15625	0.405841901237161	0.405841901237161	true	false	false	true
4ae0f91e-67fe-49e3-97bd-4f498381cd14	2026-09-04 13:50	2026-09-04 13:50	2026-09-04 13:50	FRMI	FRMI280121C00010000	call	10.0000	2028-01-21	1.5000	1.4500	1.5000	4.9550	60000.00	60000.00	0.00	400	14	402	6652	0.0604329524954901	1.06503976979093	1.06503976979093	false	false	false	true
a9bd51da-50ee-48bd-9f5c-ae827787c5b5	2026-09-04 13:22	2026-09-04 13:22	2026-09-04 13:22	WELL	WELL260918C00240000	call	240.0000	2026-09-18	3.0000	2.9500	3.2000	237.2200	102300.00	100200.00	2100.00	341	24	851	1301	0.654112221368178	0.220101880989065	0.220101880989065	false	false	false	true
99bcb172-fb96-474c-be8d-07402515ca3c	2026-09-04 13:20	2026-09-04 13:20	2026-09-04 13:20	FRMI	FRMI261016C00008000	call	8.0000	2026-10-16	0.1500	0.1000	0.1500	4.9874	31799.00	31799.00	0.00	2120	28	2130	5004	0.425659472422062	1.18907700536287	1.18310921300245	false	false	false	true
62903f57-25f9-4dad-b8ff-eb1b57a35b81	2026-09-04 13:05	2026-09-04 13:05	2026-09-04 13:05	AGNC	AGNC260911C00011000	call	11.0000	2026-09-11	0.0400	0.0300	0.0500	10.6900	13424.00	7364.00	6060.00	3356	47	4487	3626	1.23745173745174	0.238910293927544	0.238910293927544	true	false	false	true
1c3708cf-7042-4272-8bbb-568878a002b3	2026-09-04 12:34	2026-09-04 12:34	2026-09-04 12:34	FRMI	FRMI270115C00007500	call	7.5000	2027-01-15	0.7000	0.6000	0.7000	4.9250	241990.00	241990.00	0.00	3457	34	3475	12369	0.280944296224432	1.14919150191031	1.14919150191031	false	false	false	true
548bb303-bb6a-40d0-b62c-f3b529834e20	2026-09-04 12:32	2026-09-04 12:32	2026-09-04 12:32	CXW	CXW260918P00033000	put	33.0000	2026-09-18	0.5500	0.5500	0.6000	34.2050	33773.00	0.00	33773.00	614	10	614	1104	0.556159420289855	0.40448743036393	0.40448743036393	false	false	false	true
0813d6ad-60c1-46ab-893a-9abf933d7ea5	2026-09-04 11:45	2026-09-04 11:45	2026-09-04 11:45	OPEN	OPEN280121C00015000	call	15.0000	2028-01-21	0.3700	0.3300	0.3700	3.1350	11100.00	11100.00	0.00	300	11	460	31229	0.0147298984917865	1.03453200799553	1.03453200799553	false	false	false	true
e0dff95d-21fe-4d3d-9252-a6eebe1721bd	2026-09-04 10:56	2026-09-04 10:56	2026-09-04 10:56	FRMI	FRMI261009P00004000	put	4.0000	2026-10-09	0.1500	0.1500	0.2000	4.9150	97950.00	0.00	97950.00	6530	38	7000	20	350	0.874908092673446	0.874908092673446	false	false	false	true
395cfa7f-bda4-451d-9d13-8b417fff0e1e	2026-09-04 10:56	2026-09-04 10:56	2026-09-04 10:56	OPEN	OPEN280915C00005000	call	5.0000	2028-09-15	1.2500	1.1900	1.2500	3.1100	24955.00	19375.00	5580.00	200	9	471	1828	0.257658643326039	0.943549309269961	0.943549309269961	false	false	false	true
1c208361-7ac7-49ec-af77-d7738e57d2d9	2026-09-04 10:25	2026-09-04 10:25	2026-09-04 10:25	CSGP	CSGP261218C00040000	call	40.0000	2026-12-18	1.0500	0.9500	1.0500	30.7500	15435.00	15435.00	0.00	147	8	248	718	0.345403899721448	0.537626779144885	0.537626779144885	false	false	false	true
09541442-bc29-4bcc-9b15-3ebaab4088e4	2026-09-04 10:06	2026-09-04 10:06	2026-09-04 10:06	FRMI	FRMI261016C00005000	call	5.0000	2026-10-16	0.7000	0.6000	0.7000	4.9400	10430.00	10430.00	0.00	149	7	182	783	0.232439335887612	1.07683289535799	1.07683289535799	false	false	false	true
b9090577-3bc5-4faa-9be5-c1d56a24c46a	2026-09-04 09:50	2026-09-04 09:50	2026-09-04 09:50	LODE	LODE270416C00003000	call	3.0000	2027-04-16	1.0000	0.9000	1.0000	3.1650	19500.00	19500.00	0.00	195	20	240	1043	0.230105465004794	0.940662778011637	0.940662778011637	false	false	false	true
32e72811-a633-4fb3-b412-3d79ed87d01a	2026-09-03 15:59	2026-09-03 15:59	2026-09-03 15:59	AMT	AMT280121C00200000	call	200.0000	2028-01-21	14.6000	13.6000	14.6000	177.6150	65700.00	65700.00	0.00	45	9	45	81	0.555555555555556	0.22723946586432	0.22723946586432	true	false	false	true
640426a8-16fd-4edc-836e-cc221c674e47	2026-09-03 15:59	2026-09-03 15:59	2026-09-03 15:59	AMT	AMT280121P00175000	put	175.0000	2028-01-21	21.0900	18.5000	21.1000	177.5100	111800.00	111800.00	0.00	53	14	53	15	3.53333333333333	0.339034546751504	0.339034546751504	true	false	false	true
5989bb4b-7482-48fe-a29b-5ae0202b04b0	2026-09-03 15:47	2026-09-03 15:47	2026-09-03 15:47	RYN	RYN270115C00017500	call	17.5000	2027-01-15	3.0000	3.0000	3.1000	20.2750	27600.00	0.00	27600.00	92	11	92	445	0.206741573033708	0.185174934161877	0.185174934161877	false	false	false	true
9bf4ae08-2c60-42fc-a632-5e4cda391463	2026-09-03 15:46	2026-09-03 15:46	2026-09-03 15:46	OPEN	OPEN271217P00003000	put	3.0000	2027-12-17	1.0000	1.0000	1.0300	3.1400	70000.00	0.00	70000.00	700	6	1805	3742	0.482362373062533	0.883739106892012	0.883739106892012	false	false	false	true
6aa5fd69-597a-4906-b4b3-eeef468769e9	2026-09-03 15:40	2026-09-03 15:40	2026-09-03 15:40	BEKE	BEKE261218P00017000	put	17.0000	2026-12-18	1.0000	0.9500	1.0000	17.9350	70100.00	70100.00	0.00	701	34	701	478	1.46652719665272	0.402250936091161	0.402250936091161	false	false	false	true
74dc0ca0-249c-47e5-84e5-96f946f3aec5	2026-09-03 15:28	2026-09-03 15:28	2026-09-03 15:28	FRMI	FRMI270115C00007500	call	7.5000	2027-01-15	0.7000	0.6000	0.7000	4.8800	19250.00	19250.00	0.00	275	20	370	12244	0.030218882718066	1.16041832073649	1.16041832073649	false	false	false	true
958f8ba3-3f2e-42ad-aaa4-833a1a128b7b	2026-09-03 15:04	2026-09-03 15:04	2026-09-03 15:04	CBRE	CBRE270319C00180000	call	180.0000	2027-03-19	5.8000	5.2000	6.0000	149.9500	62050.00	38270.00	23780.00	107	6	108	5	21.6	0.325087912248963	0.325087912248963	false	false	false	true
f9679d5e-00df-4a1d-b140-7225e85305da	2026-09-03 15:03	2026-09-03 15:03	2026-09-03 15:03	HASI	HASI270319P00030000	put	30.0000	2027-03-19	0.8000	0.5500	1.0500	40.0700	21920.00	18160.00	0.00	274	18	274	66	4.15151515151515	0.410335244227054	0.410335244227054	false	false	false	true
b40e11b6-3be5-4f68-af88-4b5bd35f7cb5	2026-09-03 14:55	2026-09-03 14:54	2026-09-03 14:54	CBRE	CBRE261016C00175000	call	175.0000	2026-10-16	0.6000	0.3500	0.6000	149.3200	12360.00	12360.00	0.00	206	32	206	49	4.20408163265306	0.314519373410163	0.314519373410163	false	false	false	true
19bf8b04-0cf7-4e6c-85ce-5675cd87f5e2	2026-09-03 14:43	2026-09-03 14:42	2026-09-03 14:42	MAC	MAC270319C00022000	call	22.0000	2027-03-19	2.7000	2.6000	2.7000	23.1650	14310.00	540.00	0.00	53	7	53	27	1.96296296296296	0.267916122146268	0.267916122146268	false	false	false	true
ef5e580f-c4b4-4e6d-9c04-1299a3e42588	2026-09-03 14:21	2026-09-03 14:21	2026-09-03 14:21	MAC	MAC260918C00021000	call	21.0000	2026-09-18	2.2500	2.1000	2.4000	23.1600	11250.00	9000.00	450.00	50	16	84	263	0.319391634980989	0.349885465935799	0.349885465935799	false	false	false	true
48b29cb9-6fdf-4abd-b468-92772505c031	2026-09-03 13:46	2026-09-03 13:46	2026-09-03 13:46	CSGP	CSGP261218C00040000	call	40.0000	2026-12-18	1.4000	1.1000	1.4000	31.9300	44096.00	44096.00	0.00	315	30	374	355	1.05352112676056	0.543892243620285	0.543892243620285	false	false	false	true