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.

425,429 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts425,429 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

eafaa9b7-db10-434d-b1af-21e1f8e5e8fa	2026-09-09 15:24	2026-09-09 15:24	2026-09-09 15:24	CCI	CCI260918C00075000	call	75.0000	2026-09-18	1.2500	1.2000	1.5500	75.3800	110290.00	71640.00	38525.00	881	30	3067	5257	0.583412592733498	0.214287248986136	0.214287248986136	false	false	false	true	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	Common Stock	Real Estate	31556029911.00	2026-10-28	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-09T19:27:55.926703Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
60c2ad6f-6b71-40a5-9407-8d0b5c835f79	2026-09-09 15:24	2026-09-09 15:24	2026-09-09 15:24	CCI	CCI260918C00075000	call	75.0000	2026-09-18	1.2500	1.2000	1.7500	75.2700	53875.00	0.00	53875.00	431	5	3498	5257	0.665398516264029	0.227701820434381	0.227701820434381	false	false	false	true
e834f1da-aa55-4839-922b-856bdad17caa	2026-09-09 15:20	2026-09-09 15:19	2026-09-09 15:19	CCI	CCI261016P00070000	put	70.0000	2026-10-16	1.2000	1.2000	1.3500	75.1950	51360.00	0.00	51360.00	428	21	477	637	0.748822605965463	0.350632631435583	0.350632631435583	false	false	false	true
8beece6a-cbaa-4972-a84d-11d1d47c8f69	2026-09-09 14:46	2026-09-09 14:46	2026-09-09 14:46	LODE	LODE270416C00003000	call	3.0000	2027-04-16	0.9000	0.8500	0.9000	3.0450	12060.00	12060.00	0.00	134	9	619	1609	0.384711000621504	0.929482677394487	0.929482677394487	false	false	false	true
ee121f40-5a4a-43e2-a4f0-f20578d1f709	2026-09-09 14:42	2026-09-09 14:42	2026-09-09 14:42	CSGP	CSGP280121C00085000	call	85.0000	2028-01-21	0.6000	0.5500	0.6000	29.6250	30000.00	30000.00	0.00	500	5	1500	1943	0.772002058672156	0.51785136072793	0.51785136072793	false	false	false	true
ad218d84-3aba-4c39-b107-48db7ba75739	2026-09-09 14:27	2026-09-09 14:27	2026-09-09 14:27	IRS	IRS261016C00015000	call	15.0000	2026-10-16	1.0500	0.9500	1.2500	15.4500	10500.00	2520.00	7980.00	100	18	100	140	0.714285714285714	0.398541908722297	0.398541908722297	false	false	false	true
f2323f00-7585-4cb4-bb61-84a9da44de9a	2026-09-09 14:17	2026-09-09 14:17	2026-09-09 14:17	BEKE	BEKE270115C00018000	call	18.0000	2027-01-15	1.2000	1.2000	1.3000	16.8800	56238.00	0.00	56238.00	468	14	560	1880	0.297872340425532	0.393920723956113	0.391400628622583	false	false	false	true
2d637b0c-501c-4c06-b7ca-0c7d621fb71d	2026-09-09 13:20	2026-09-09 13:20	2026-09-09 13:20	EQIX	EQIX260918P01050000	put	1050.0000	2026-09-18	24.7000	22.7000	24.7000	1040.1500	98800.00	98800.00	0.00	40	20	40	176	0.227272727272727	0.304985196342552	0.304985196342552	false	false	false	true
5c6ae20e-8fe2-4aaf-9237-3a24ddbb0344	2026-09-09 12:04	2026-09-09 12:04	2026-09-09 12:04	FRMI	FRMI270115C00007500	call	7.5000	2027-01-15	0.9200	0.9000	1.0000	5.5350	184000.00	0.00	184000.00	2000	6	2003	12126	0.165182253010061	1.13506157075492	1.13506157075492	false	false	false	true
f5548750-15e0-4d58-bece-3b641c77aa66	2026-09-09 11:45	2026-09-09 11:45	2026-09-09 11:45	BXP	BXP261016P00062500	put	62.5000	2026-10-16	1.5000	1.3500	1.6000	65.0700	31050.00	300.00	30750.00	207	18	313	48	6.52083333333333	0.331145178930352	0.331145178930352	false	false	false	true
6f896f00-eb3d-483e-8aac-2e4f3e362f8a	2026-09-09 11:28	2026-09-09 11:28	2026-09-09 11:28	CSGP	CSGP270319P00030000	put	30.0000	2027-03-19	4.3000	4.3000	4.5000	29.6800	38270.00	0.00	38270.00	89	17	283	313	0.904153354632588	0.52678274238487	0.52678274238487	false	false	false	true
301d2ed0-7f36-4f69-a1b7-5010ed579bad	2026-09-09 11:26	2026-09-09 11:26	2026-09-09 11:26	FRMI	FRMI270219C00007000	call	7.0000	2027-02-19	1.3000	1.2000	1.3000	5.5150	64800.00	64800.00	0.00	500	9	1050	1484	0.707547169811321	1.1876066306784	1.16023253591812	false	false	false	true
04b3487c-070f-457b-8b0b-2c0889ed6fe8	2026-09-09 11:12	2026-09-09 11:12	2026-09-09 11:12	OPEN	OPEN270115C00003000	call	3.0000	2027-01-15	0.6400	0.6400	0.6600	3.0299	21248.00	0.00	21248.00	332	11	550	6064	0.0906992084432718	0.864956215654848	0.864956215654848	false	false	false	true
82ca78dd-5094-4ad0-b95a-0a4e27ab6c61	2026-09-09 11:10	2026-09-09 11:10	2026-09-09 11:10	AGNC	AGNC260925C00010500	call	10.5000	2026-09-25	0.2900	0.2900	0.3200	10.6550	32219.00	0.00	32219.00	1111	11	1120	1421	0.788177339901478	0.216957372203884	0.216957372203884	false	false	false	true
a5e36808-98c3-4485-b3ed-662b222ef96f	2026-09-09 10:47	2026-09-09 10:47	2026-09-09 10:47	MPT	MPT270617P00002500	put	2.5000	2027-06-17	0.1700	0.1600	0.1700	3.9250	13141.00	13141.00	0.00	773	21	35999	27567	1.30587296405122	0.622343413891272	0.622343413891272	false	false	false	true
63c74a84-9dc5-4d29-8856-e3565cdb49a6	2026-09-09 10:41	2026-09-09 10:41	2026-09-09 10:41	MPT	MPT270617P00002500	put	2.5000	2027-06-17	0.1600	0.1500	0.1600	3.9200	83488.00	83488.00	0.00	5218	44	35220	27567	1.27761453912286	0.607126687145868	0.607126687145868	false	false	false	true
09e17890-0cf9-4c99-ab93-df2e052535cf	2026-09-09 10:39	2026-09-09 10:39	2026-09-09 10:39	MPT	MPT270617P00002500	put	2.5000	2027-06-17	0.1500	0.1300	0.1600	3.0000	21165.00	19455.00	0.00	1411	28	21572	27567	0.782529836398593	0.594262338861873	0.594262338861873	true	false	false	true
3e02c2e3-f76e-4d0e-a86b-0c6c9a634ada	2026-09-09 10:35	2026-09-09 10:35	2026-09-09 10:35	BXP	BXP261016P00062500	put	62.5000	2026-10-16	1.5000	1.5000	1.6000	65.0000	12600.00	0.00	12600.00	84	14	91	48	1.89583333333333	0.340113744623758	0.340113744623758	false	false	false	true
88548fc4-8798-4ebf-aefa-aae7006a6610	2026-09-09 10:26	2026-09-09 10:25	2026-09-09 10:25	CBRE	CBRE270115C00155000	call	155.0000	2027-01-15	7.4000	6.8000	7.4000	141.0000	275994.00	275994.00	0.00	373	49	374	70	5.34285714285714	0.347322419834547	0.347322419834547	false	false	false	true
13cdc9e2-0c48-4a26-926d-f274762abedc	2026-09-09 10:18	2026-09-09 10:18	2026-09-09 10:18	AGNC	AGNC270115P00010000	put	10.0000	2027-01-15	0.3600	0.3400	0.3600	10.6950	27000.00	27000.00	0.00	750	7	750	20411	0.0367448924599481	0.28855608310861	0.28855608310861	false	false	false	true
0a8c8a33-8b5b-4d7d-b4d6-da7cd2ff5946	2026-09-09 09:46	2026-09-09 09:46	2026-09-09 09:46	MPT	MPT270617P00002500	put	2.5000	2027-06-17	0.1600	0.1400	0.1600	3.9650	18768.00	18768.00	0.00	1173	7	9443	27567	0.342547248521783	0.614921671669877	0.614921671669877	false	false	false	true
c38197e8-4acd-4ca5-8163-91b937fb6c51	2026-09-09 09:46	2026-09-09 09:46	2026-09-09 09:46	MPT	MPT270617P00002500	put	2.5000	2027-06-17	0.1600	0.1400	0.1600	3.9650	20959.00	20944.00	0.00	1310	9	7140	27567	0.259005332462727	0.600266136817707	0.614921671669877	false	false	false	true
5693a652-02e8-40e5-ad76-6ae93ea55c16	2026-09-09 09:46	2026-09-09 09:46	2026-09-09 09:46	MPT	MPT270617P00002500	put	2.5000	2027-06-17	0.1600	0.1400	0.1600	3.9650	18080.00	18080.00	0.00	1130	14	8270	27567	0.299996372474335	0.614921671669877	0.614921671669877	false	false	false	true
f899562f-675e-4dc0-8538-06d129763193	2026-09-09 09:45	2026-09-09 09:45	2026-09-09 09:45	MPT	MPT270617P00002500	put	2.5000	2027-06-17	0.1500	0.1400	0.1500	3.9700	16470.00	16470.00	0.00	1098	14	4239	27567	0.153770812928501	0.601117080575858	0.601117080575858	false	false	false	true
85db8706-0d03-4a90-99da-f200dc9bb5af	2026-09-09 09:45	2026-09-09 09:45	2026-09-09 09:45	MPT	MPT270617P00002500	put	2.5000	2027-06-17	0.1500	0.1500	0.1700	3.9650	11415.00	0.00	11415.00	761	5	5000	27567	0.181376283237204	0.600266136817707	0.600266136817707	false	false	false	true
b7654a94-bca4-4886-83fa-b32f3ad6d99b	2026-09-09 09:45	2026-09-09 09:45	2026-09-09 09:45	MPT	MPT270617P00002500	put	2.5000	2027-06-17	0.1400	0.1100	0.1600	3.9750	11102.00	9226.00	0.00	793	13	793	27567	0.0287662785214205	0.587001498278715	0.587001498278715	true	false	false	true
8e2180ef-8856-4562-8d9c-6d69fa7d6ecc	2026-09-08 15:44	2026-09-08 15:44	2026-09-08 15:44	FRMI	FRMI261016C00008000	call	8.0000	2026-10-16	0.2500	0.2500	0.3000	5.7714	13761.00	0.00	13761.00	550	7	724	6428	0.112632233976353	1.14253854419085	1.12535372919734	false	false	false	true
405f468d-93fc-4892-b133-219881f87318	2026-09-08 15:43	2026-09-08 15:43	2026-09-08 15:43	CXW	CXW261120C00040000	call	40.0000	2026-11-20	1.5500	1.5500	1.7000	35.0200	57970.00	0.00	57970.00	374	12	377	121	3.11570247933884	0.509576466293134	0.509576466293134	false	false	false	true
a0960488-5fb9-4cfe-b740-edfb7f06cb2e	2026-09-08 15:19	2026-09-08 15:19	2026-09-08 15:19	FRMI	FRMI261218C00010000	call	10.0000	2026-12-18	0.5100	0.5000	0.5500	5.8350	10200.00	0.00	10200.00	200	5	2200	8703	0.252786395495806	1.18696318265111	1.18696318265111	false	false	false	true
943db3a5-50ed-4d72-aa42-00a46df623a3	2026-09-08 15:14	2026-09-08 15:13	2026-09-08 15:13	OPEN	OPEN280121P00003000	put	3.0000	2028-01-21	1.1000	1.0500	1.1000	3.1050	55000.00	55000.00	0.00	500	13	1250	1065	1.17370892018779	0.93730322733111	0.93730322733111	false	false	false	true
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
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
8954ce23-e036-49ce-810b-f449f63c1a2e	2026-09-08 13:09	2026-09-08 13:09	2026-09-08 13:09	GEO	GEO270115C00040000	call	40.0000	2027-01-15	1.4300	1.3500	1.4500	31.5500	19065.00	18785.00	140.00	133	14	179	9793	0.0182783620953742	0.513648155802458	0.505717748429957	false	false	false	true
3e39f858-04bc-4a5e-b133-6d5905a7631c	2026-09-08 13:09	2026-09-08 13:09	2026-09-08 13:09	GEO	GEO270115C00040000	call	40.0000	2027-01-15	1.4400	1.4000	1.4500	31.6350	32199.00	32199.00	0.00	223	9	402	9793	0.04104972939855	0.50671887488714	0.509870570562753	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
f7f3038a-b5ce-4a55-93b6-3a5b7942926d	2026-09-08 12:39	2026-09-08 12:39	2026-09-08 12:39	CXW	CXW260918C00031000	call	31.0000	2026-09-18	4.0000	3.9000	4.3000	34.8800	24375.00	0.00	12775.00	61	8	61	209	0.291866028708134	0.364930103264533	0.494883779094973	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
a9ddde04-ceb1-47b9-8cb1-4010de7e5444	2026-09-08 12:15	2026-09-08 12:15	2026-09-08 12:15	FRMI	FRMI261218C00005000	call	5.0000	2026-12-18	1.6900	1.4500	1.8000	5.7750	25324.00	25324.00	0.00	150	9	172	1542	0.111543450064851	1.12372043971877	1.12372043971877	false	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
14905f21-4e1d-4cac-b500-48c2c6ea7aa5	2026-09-08 12:02	2026-09-08 12:01	2026-09-08 12:01	FRMI	FRMI261016C00005000	call	5.0000	2026-10-16	1.1600	1.1500	1.3000	5.7900	18025.00	0.00	18025.00	155	7	263	915	0.287431693989071	0.970681710625158	1.03601433585135	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
1fa79c23-525c-4d53-ba45-0724f2d576d0	2026-09-08 11:37	2026-09-08 11:37	2026-09-08 11:37	CSGP	CSGP260918P00030000	put	30.0000	2026-09-18	1.0000	0.9500	1.0500	29.8600	13301.00	1100.00	10701.00	133	6	3652	5161	0.707614803332687	0.483374758884145	0.4783030511705	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
6c80a7b6-afd7-44f7-8106-86d7e418d300	2026-09-08 11:16	2026-09-08 11:16	2026-09-08 11:16	BXP	BXP261016C00067500	call	67.5000	2026-10-16	2.0700	1.2000	3.0000	66.6300	318780.00	0.00	318780.00	1540	2	1540	70	22	0.27358863755895	0.27358863755895	false	true	true	false