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×source = uw_flow_alerts×

iduuid	created_at ↓timestamp with time zone	start_timetimestamp with time zone	end_timetimestamp with time zone	tickertext	option_symboltext	option_typetext	strikenumeric	expiry

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	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Real Estate	203661366.00	2026-10-29	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-04T13:56:18.493427Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
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
505eb2a8-d3b5-444f-93bb-f2759f323dd0	2026-09-02 15:12	2026-09-02 15:12	2026-09-02 15:12	FRMI	FRMI270115C00005000	call	5.0000	2027-01-15	1.2000	1.1500	1.2000	4.7450	60000.00	60000.00	0.00	500	11	538	3274	0.164324984728161	1.11982614879446	1.11982614879446	true	false	false	true
30e92078-2a92-4c7f-8820-5aa0ff977435	2026-09-02 14:55	2026-09-02 14:55	2026-09-02 14:55	GEO	GEO280121C00045000	call	45.0000	2028-01-21	3.8600	3.7000	3.9000	30.6300	96536.00	96536.00	0.00	250	16	1300	5139	0.252967503405332	0.508280537205565	0.507991147263609	false	false	false	true
9ba61db4-fedf-4c0a-b3bf-a45937e7ccb1	2026-09-02 14:50	2026-09-02 14:49	2026-09-02 14:49	CBRE	CBRE261016C00145000	call	145.0000	2026-10-16	5.5000	5.1000	5.5000	142.2200	26400.00	26400.00	0.00	48	16	75	1	75	0.327561747170596	0.327561747170596	false	false	false	true
b318f956-3fb5-4377-8455-3420ce513dfd	2026-09-02 14:25	2026-09-02 14:25	2026-09-02 14:25	GEO	GEO280121C00045000	call	45.0000	2028-01-21	3.8000	3.7000	3.8000	30.4850	171000.00	171000.00	0.00	450	16	1050	5139	0.204319906596614	0.504991268982633	0.504991268982633	false	false	false	true
557c5357-865f-44b4-bb7e-04ff03cc5763	2026-09-02 14:24	2026-09-02 14:24	2026-09-02 14:24	FRMI	FRMI280121C00010000	call	10.0000	2028-01-21	1.3500	1.2500	1.3500	4.7180	10125.00	8100.00	0.00	75	5	278	6428	0.0432482887367766	1.05218956295572	1.05218956295572	false	false	false	true
7bdaa028-2f9f-416b-ac8f-7325d65165bd	2026-09-02 14:23	2026-09-02 14:23	2026-09-02 14:23	GEO	GEO280121C00045000	call	45.0000	2028-01-21	3.7000	3.4000	3.7000	30.3900	66598.00	66598.00	0.00	180	7	400	5139	0.0778361548939482	0.499754912884244	0.499754912884244	false	false	false	true
f4f53fae-17bf-4332-8ae0-5f79749bb73f	2026-09-02 13:56	2026-09-02 13:56	2026-09-02 13:56	EQIX	EQIX270917P01080000	put	1080.0000	2027-09-17	151.4400	149.5000	151.7000	1011.1650	75720.00	75720.00	0.00	5	5	72	0	0	0.341244548462038	0.338065155878797	false	false	false	true
069309d0-cdf0-44aa-af49-c9b18c3fb15b	2026-09-02 13:56	2026-09-02 13:56	2026-09-02 13:56	EQIX	EQIX270917C01080000	call	1080.0000	2027-09-17	109.5000	105.2000	109.5000	1011.1650	54750.00	54750.00	0.00	5	5	73	0	0	0.288477027212769	0.288477027212769	false	false	false	true
2b50f043-62b8-46f5-b82f-010a55c1984c	2026-09-02 13:56	2026-09-02 13:56	2026-09-02 13:56	EQIX	EQIX270917C01080000	call	1080.0000	2027-09-17	109.5400	105.1000	110.0000	1011.1650	76680.00	76680.00	0.00	7	7	23	0	0	0.28969560479558	0.285796462903006	false	false	false	true
cbc5b0c1-a102-4367-8358-f2cd807b7c80	2026-09-02 13:24	2026-09-02 13:24	2026-09-02 13:24	CBRE	CBRE261016C00150000	call	150.0000	2026-10-16	3.8000	3.5000	3.8000	143.1812	18240.00	18240.00	0.00	48	20	90	73	1.23287671232877	0.316096695390289	0.316096695390289	false	false	false	true
44817cf7-0a71-492e-a1a5-4aad64b3c69c	2026-09-02 13:18	2026-09-02 13:18	2026-09-02 13:18	FRMI	FRMI270617C00007000	call	7.0000	2027-06-17	1.2500	1.1000	1.2500	4.5799	25000.00	25000.00	0.00	200	8	312	655	0.476335877862595	1.14077590600427	1.14077590600427	false	false	false	true
2ae99303-dc57-4f49-aa3e-ab848e72688d	2026-09-02 12:31	2026-09-02 12:30	2026-09-02 12:30	CBRE	CBRE261016C00150000	call	150.0000	2026-10-16	3.7000	3.3000	3.7000	142.4500	11100.00	11100.00	0.00	30	9	31	73	0.424657534246575	0.325075073567159	0.325075073567159	false	false	false	true
7bf97349-fd4f-4f1b-991a-5d7791f0a970	2026-09-02 12:02	2026-09-02 12:02	2026-09-02 12:02	MPT	MPT281215P00002500	put	2.5000	2028-12-15	0.4100	0.2100	0.4100	4.0950	33210.00	33210.00	0.00	810	34	8001	15027	0.532441605110801	0.605633473574471	0.605633473574471	false	false	false	true
88444682-4f22-4a4d-823d-d4a576a8946f	2026-09-02 12:01	2026-09-02 12:01	2026-09-02 12:01	MPT	MPT281215P00002500	put	2.5000	2028-12-15	0.4000	0.2000	0.4100	4.0950	29640.00	29240.00	400.00	741	14	7160	15027	0.476475677114527	0.598160106378416	0.598160106378416	false	false	false	true
d70e31ef-ba30-4f3c-ae09-7b7b594b621d	2026-09-02 12:01	2026-09-02 12:01	2026-09-02 12:01	MPT	MPT281215P00002500	put	2.5000	2028-12-15	0.4000	0.3500	0.4100	4.1100	97200.00	79720.00	10760.00	2430	21	6148	15027	0.409130232248619	0.599657505054771	0.599657505054771	false	false	false	true
56522d20-31ac-435e-ac06-015232cfb9a4	2026-09-02 11:59	2026-09-02 11:59	2026-09-02 11:59	MPT	MPT281215P00002500	put	2.5000	2028-12-15	0.4000	0.3300	0.4700	4.1250	18600.00	800.00	17800.00	465	5	490	15027	0.032607972316497	0.601146812476072	0.601146812476072	false	false	false	true
5593f961-8afe-4011-9803-52fb319c7a74	2026-09-02 11:49	2026-09-02 11:49	2026-09-02 11:49	CSGP	CSGP261218C00035000	call	35.0000	2026-12-18	2.3500	2.2500	2.4000	31.5500	425350.00	413365.00	11985.00	1810	20	1933	223	8.66816143497758	0.516264132040746	0.516264132040746	false	false	false	true
ca4216bb-8e34-4584-9357-2cf6cbbeedf5	2026-09-02 11:34	2026-09-02 11:34	2026-09-02 11:34	NLY	NLY261016C00023000	call	23.0000	2026-10-16	0.2900	0.2500	0.2900	22.6267	51272.00	51272.00	0.00	1768	45	1798	3655	0.491928864569083	0.129813528836134	0.129813528836134	false	false	false	true
8a72561b-d671-465c-ac11-623b9ce0978e	2026-09-02 11:29	2026-09-02 11:29	2026-09-02 11:29	AGNC	AGNC261218C00010000	call	10.0000	2026-12-18	0.7500	0.7500	0.7600	10.5800	29100.00	0.00	29100.00	388	9	483	5821	0.0829754337742656	0.122879852536287	0.122879852536287	true	false	false	true