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

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	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Real Estate	3234360107.00	2026-11-09	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-04T19:30:40.028430Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
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
5b4c47df-7b46-40db-9f5b-b126f2d84c23	2026-09-04 14:11	2026-09-04 14:10	2026-09-04 14:10	AGNC	AGNC270115C00010000	call	10.0000	2027-01-15	0.8200	0.8100	0.9000	10.6800	16339.00	0.00	16339.00	200	18	200	8563	0.0233563003620227	0.144657235864761	0.0779410469666412	false	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
a642bd99-6098-466c-b1fb-4c8bc2d5a1ca	2026-09-04 13:31	2026-09-04 13:30	2026-09-04 13:30	BXDC	BXDC261218C00020000	call	20.0000	2026-12-18	1.4500	1.2500	1.9500	20.3600	145000.00	0.00	145000.00	1000	1	1000	15	66.6666666666667	0.263803606857579	0.263803606857579	false	true	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
4a74be8e-5763-4e00-9419-d1b1e99310b6	2026-09-04 12:36	2026-09-04 12:36	2026-09-04 12:36	FRMI	FRMI260911C00005000	call	5.0000	2026-09-11	0.2400	0.2000	0.3000	4.9850	12584.00	150.00	2434.00	520	8	565	367	1.53950953678474	0.927748220546385	0.927748220546385	false	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
04592747-0dc3-4d8f-a695-32e8a2ed53f2	2026-09-04 12:34	2026-09-04 12:34	2026-09-04 12:34	FRMI	FRMI261218C00007500	call	7.5000	2026-12-18	0.5500	0.5000	0.5500	4.9250	97606.00	97606.00	0.00	1775	33	1785	13402	0.133189076257275	1.14824033832086	1.14824033832086	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
d150d7de-5c78-4dae-a9e4-58581f0b961d	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	75400.00	0.00	75400.00	251	6	343	445	0.770786516853933	0.185174934161877	0.185174934161877	false	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
d1a0ba98-a18d-4c23-be2e-52b1208c8c72	2026-09-03 15:02	2026-09-03 15:01	2026-09-03 15:01	GEO	GEO261120P00025000	put	25.0000	2026-11-20	0.7000	0.5500	0.7000	31.6400	77722.00	77722.00	0.00	1111	52	1245	1162	1.07142857142857	0.569072682277509	0.569072682277509	true	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
c1c3cc51-2fb7-457b-a1ea-90f18b54c49c	2026-09-03 14:38	2026-09-03 14:38	2026-09-03 14:38	AMT	AMT261120P00170000	put	170.0000	2026-11-20	5.2000	4.9000	6.0000	178.8600	197620.00	1060.00	196560.00	380	25	383	13	29.4615384615385	0.295732205517799	0.299166049651267	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
cbfdd2a0-55f5-4e94-a21a-96aea2f36c63	2026-09-03 13:10	2026-09-03 13:10	2026-09-03 13:10	GEO	GEO260918C00032000	call	32.0000	2026-09-18	0.9000	0.8000	0.9500	31.6251	43560.00	1800.00	0.00	484	90	1002	1809	0.553897180762852	0.410249069392863	0.410249069392863	false	false	false	true
e030da61-2d3b-4b68-812b-ad0fb3546442	2026-09-03 13:04	2026-09-03 13:04	2026-09-03 13:04	SUI	SUI261218C00125000	call	125.0000	2026-12-18	3.5000	2.4000	5.7000	119.8600	471100.00	0.00	471100.00	1346	2	1346	3	448.666666666667	0.196363975422162	0.196363975422162	false	true	true	false
9d03cc70-cfeb-4eed-9431-298526c25f3d	2026-09-03 12:45	2026-09-03 12:45	2026-09-03 12:45	GEO	GEO280121C00045000	call	45.0000	2028-01-21	4.3000	3.3000	4.3000	31.5700	128866.00	128866.00	0.00	300	12	300	6382	0.0470072077718584	0.510765314982741	0.498288571595249	false	false	false	true
47813b1c-25ad-41b1-97c2-7727e1ad8b79	2026-09-03 12:45	2026-09-03 12:45	2026-09-03 12:45	OPEN	OPEN270115C00005000	call	5.0000	2027-01-15	0.2700	0.2500	0.2800	3.1150	17550.00	8613.00	2565.00	650	12	778	30076	0.0258678015693576	0.955814067860947	0.955814067860947	true	false	false	true
4ca98812-5124-4d39-9ae1-87f2e0862269	2026-09-03 12:05	2026-09-03 12:05	2026-09-03 12:05	OPEN	OPEN280121C00007000	call	7.0000	2028-01-21	0.7000	0.7000	0.7500	3.1150	15680.00	0.00	15680.00	224	9	299	31144	0.00960056511687644	0.951665480158848	0.951665480158848	false	false	false	true
ec4c4294-0388-42bc-8c4f-f53114874212	2026-09-03 11:55	2026-09-03 11:55	2026-09-03 11:55	SBAC	SBAC261120C00210000	call	210.0000	2026-11-20	3.8000	2.7000	3.8000	192.0300	44080.00	44080.00	0.00	116	25	143	111	1.28828828828829	0.268208278443545	0.268208278443545	true	false	false	true
a3d949e5-5c53-445f-9deb-b8b19f3f8888	2026-09-03 11:18	2026-09-03 11:18	2026-09-03 11:18	IRM	IRM261016C00120000	call	120.0000	2026-10-16	2.3500	2.3500	2.5500	114.2200	16220.00	0.00	16220.00	69	21	84	2358	0.0356234096692112	0.280753745931535	0.280753745931535	false	false	false	true
69f243a8-7e25-4098-9f0c-0f4b4d5185dd	2026-09-03 11:14	2026-09-03 11:14	2026-09-03 11:14	MPT	MPT270617P00002500	put	2.5000	2027-06-17	0.1500	0.1100	0.1500	4.0150	10500.00	10500.00	0.00	700	17	1228	26123	0.0470083834169123	0.598596477719587	0.598596477719587	false	false	false	true
ac11923e-496b-421b-9318-959fffdbf2a6	2026-09-03 10:48	2026-09-03 10:48	2026-09-03 10:48	FRMI	FRMI261009C00006000	call	6.0000	2026-10-09	0.2500	0.2500	0.3000	4.8100	97760.00	0.00	97760.00	3905	35	4000	31	129.032258064516	1.00323105224011	1.01465886371832	false	false	false	true
92c30d79-78df-4636-a671-999645608de6	2026-09-03 09:54	2026-09-03 09:54	2026-09-03 09:54	DLR	DLR280121P00160000	put	160.0000	2028-01-21	14.0000	12.0000	14.0000	182.4000	116200.00	93800.00	0.00	83	6	83	607	0.13673805601318	0.348840799362723	0.348840799362723	false	false	false	true
3d4a95fd-7d2c-4889-a45b-28c0a0f59ae7	2026-09-03 09:53	2026-09-03 09:53	2026-09-03 09:53	LODE	LODE270416C00003000	call	3.0000	2027-04-16	1.0900	1.0500	1.1000	3.3350	10920.00	10920.00	0.00	100	6	209	707	0.295615275813296	0.923163323728497	0.912103337998633	false	false	false	true
d919dc5a-dd3e-47ec-a363-72a14fbc975f	2026-09-03 09:43	2026-09-03 09:43	2026-09-03 09:43	NNN	NNN270319C00050000	call	50.0000	2027-03-19	0.5000	0.5000	0.7000	44.9200	13150.00	0.00	13150.00	263	27	266	418	0.636363636363636	0.13424303459318	0.13424303459318	false	false	false	true
0e5fa0d6-9c99-4008-bc02-2ac9dfc3a6fb	2026-09-03 09:34	2026-09-03 09:33	2026-09-03 09:33	AGNC	AGNC261023C00011000	call	11.0000	2026-10-23	0.2600	0.0900	0.2900	10.7350	15744.00	15697.00	47.00	606	8	611	0	0	0.221737150460782	0.208858462666909	true	false	false	true
dd5a300c-3955-4724-b15b-a934663352b0	2026-09-02 15:37	2026-09-02 15:37	2026-09-02 15:37	OPEN	OPEN270115C00004000	call	4.0000	2027-01-15	0.4000	0.3600	0.4200	3.0650	40268.00	40268.00	0.00	1000	32	1252	9786	0.127937870427141	0.909177503531147	0.936452641505996	true	false	false	true
4ae18237-85f7-4c86-827a-acb23a246ab7	2026-09-02 15:31	2026-09-02 15:31	2026-09-02 15:31	NLY	NLY260925P00023000	put	23.0000	2026-09-25	0.5300	0.5000	0.5300	22.7050	13250.00	13250.00	0.00	250	38	318	3113	0.102152264696434	0.174575012926228	0.174575012926228	false	false	false	true