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

ead3c256-46d9-4a30-bd79-2a6bf1651906	2026-08-17 12:03	2026-08-17 12:03	2026-08-17 12:03	CXW	CXW270115C00034000	call	34.0000	2027-01-15	4.2000	4.0000	4.3000	33.8750	101220.00	420.00	100800.00	241	6	2268	1040	2.18076923076923	0.462873604488095	0.462873604488095	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Real Estate	3385124128.00	2026-11-04	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-17T16:27:21.112559Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
38383eb8-28ff-4341-ac28-e141477f4fcf	2026-08-17 11:50	2026-08-17 11:50	2026-08-17 11:50	IIPR	IIPR261016P00055000	put	55.0000	2026-10-16	3.3500	2.6500	3.8000	55.3100	29815.00	29815.00	0.00	89	6	95	499	0.190380761523046	0.412861368476988	0.412861368476988	false	false	false	true	false
2c788377-3860-400d-b62b-3e4730c17fcb	2026-08-17 11:15	2026-08-17 11:15	2026-08-17 11:15	IRM	IRM261016C00130000	call	130.0000	2026-10-16	4.8000	4.5000	4.8000	127.2200	14400.00	9600.00	0.00	30	5	101	133	0.759398496240602	0.27649274266714	0.27649274266714	false	false	false	true	false
8f90e1c4-90cb-40b6-b1b6-7ede4947d30a	2026-08-17 11:11	2026-08-17 11:10	2026-08-17 11:10	OPEN	OPEN260925C00003500	call	3.5000	2026-09-25	0.5200	0.4500	0.5200	3.6850	12116.00	12116.00	0.00	233	7	246	1023	0.240469208211144	0.88612587090298	0.88612587090298	false	false	false	true	false
8518399b-6847-494c-8557-2185936af74b	2026-08-17 11:10	2026-08-17 11:10	2026-08-17 11:10	AGNC	AGNC260904P00011000	put	11.0000	2026-09-04	0.2600	0.2500	0.2600	10.9750	10504.00	10504.00	0.00	404	20	404	167	2.41916167664671	0.265089365042968	0.265089365042968	false	false	false	true	false
f72d184b-96a4-4fa2-bf6c-bc0b95304f43	2026-08-17 11:10	2026-08-17 11:10	2026-08-17 11:10	ACR	ACR260918P00015000	put	15.0000	2026-09-18	1.3000	1.3000	1.4500	14.0700	23400.00	0.00	23400.00	180	5	180	29	6.20689655172414	0.457063810544842	0.457063810544842	false	false	false	true	false
cf9317bd-91d4-433b-9e0e-53802e3e49bf	2026-08-17 11:05	2026-08-17 11:05	2026-08-17 11:05	SPG	SPG261218C00240000	call	240.0000	2026-12-18	3.6000	3.3000	3.6000	218.8600	235800.00	235800.00	0.00	655	43	657	498	1.31927710843373	0.192623974740978	0.192623974740978	false	false	false	true	false
42a7806d-5ce0-4602-9bac-b43ae8a04e24	2026-08-17 10:57	2026-08-17 10:57	2026-08-17 10:57	OPEN	OPEN260821C00003500	call	3.5000	2026-08-21	0.1800	0.1700	0.1900	3.6200	10152.00	3222.00	6930.00	564	39	4741	8440	0.561729857819905	0.731140298141013	0.731140298141013	false	false	false	true	false
8e4eab72-acfa-470b-9741-919cec81b11c	2026-08-17 10:56	2026-08-17 10:56	2026-08-17 10:56	OPEN	OPEN260828C00003500	call	3.5000	2026-08-28	0.2500	0.2400	0.2600	3.6150	50925.00	50625.00	300.00	2037	24	3087	2204	1.40063520871143	0.749562863533432	0.749562863533432	false	false	false	true	false
e756e5e7-1b2d-4116-80fb-a17e9a9ca65f	2026-08-17 10:37	2026-08-17 10:37	2026-08-17 10:37	REAX	REAX270115C00002500	call	2.5000	2027-01-15	0.5400	0.3000	0.5500	2.4100	10790.00	10790.00	0.00	200	7	1350	2488	0.542604501607717	0.849818427656552	0.933268008550286	false	false	false	true	false
47788fe6-7c76-4013-98dc-22e17e856ec0	2026-08-17 10:32	2026-08-17 10:32	2026-08-17 10:32	REAX	REAX270115C00002500	call	2.5000	2027-01-15	0.5500	0.5000	0.5500	2.4000	11000.00	11000.00	0.00	200	5	1125	2488	0.452170418006431	0.943410413994698	0.943410413994698	false	false	false	true	false
f2159a5e-2c3b-48a7-97b5-9e122d0f619f	2026-08-17 10:23	2026-08-17 10:22	2026-08-17 10:22	HST	HST270115P00022280	put	22.2800	2027-01-15	1.4000	1.1000	1.7500	22.5950	224000.00	0.00	224000.00	1600	2	1601	744	2.15188172043011	0.301122540763459	0.301122540763459	false	true	true	false	true
75317a20-d4fa-41e1-b5c8-191393ff1b89	2026-08-17 10:11	2026-08-17 10:11	2026-08-17 10:11	CXW	CXW270115C00034000	call	34.0000	2027-01-15	4.0000	3.8000	4.2000	33.5800	214900.00	0.00	98500.00	537	7	941	1040	0.904807692307692	0.460458616738812	0.460308895039165	false	false	false	true	false
9ab623b6-d2a9-42f2-a08c-956baf75936c	2026-08-17 10:05	2026-08-17 10:05	2026-08-17 10:05	REAX	REAX270115C00002500	call	2.5000	2027-01-15	0.5500	0.4000	0.5500	2.3950	11000.00	11000.00	0.00	200	17	700	2488	0.281350482315113	0.948486522937331	0.948486522937331	false	false	false	true	false
0892acb2-385b-4800-83d8-80610681df2d	2026-08-17 09:45	2026-08-17 09:45	2026-08-17 09:45	FRMI	FRMI270115C00007500	call	7.5000	2027-01-15	1.3000	1.3000	1.5500	6.1800	26000.00	0.00	26000.00	200	8	200	6469	0.0309166795486165	1.08034648426967	1.08034648426967	false	false	false	true	false
b936dc0c-be67-42e0-9a62-c42200e84fef	2026-08-17 09:42	2026-08-17 09:42	2026-08-17 09:42	IRM	IRM261016C00130000	call	130.0000	2026-10-16	5.1000	4.7000	5.7000	127.6800	15300.00	6630.00	3060.00	30	5	30	133	0.225563909774436	0.280462136282918	0.280462136282918	false	false	false	true	false
e04f3d25-b87c-4de7-b3d4-21b25295028d	2026-08-17 09:40	2026-08-17 09:40	2026-08-17 09:40	OPEN	OPEN260821C00003500	call	3.5000	2026-08-21	0.1600	0.1600	0.1900	3.5950	16000.00	0.00	16000.00	1000	8	1128	8440	0.133649289099526	0.707626982968082	0.707626982968082	false	false	false	true	false
e40b524a-4abc-4f3d-af15-98907b2dbd97	2026-08-17 09:38	2026-08-17 09:38	2026-08-17 09:38	FRMI	FRMI270115P00006000	put	6.0000	2027-01-15	1.4500	1.4500	1.6000	6.3400	29000.00	0.00	29000.00	200	9	200	5886	0.0339789330615019	1.07816217762759	1.07816217762759	false	false	false	true	false
ae9a2850-6992-4322-be20-0ca32279b0cf	2026-08-14 15:58	2026-08-14 15:58	2026-08-14 15:58	CBRE	CBRE260918C00170000	call	170.0000	2026-09-18	0.9500	0.7500	1.3000	152.7200	95000.00	0.00	95000.00	1000	1	1000	1460	0.684931506849315	0.2957015990282	0.2957015990282	false	true	false	true	false