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

8ca32bd3-209b-4d36-9f98-4f75be6a3833	2026-08-18 13:20	2026-08-18 13:19	2026-08-18 13:19	FRMI	FRMI260918C00006000	call	6.0000	2026-09-18	0.6500	0.6500	0.7000	5.9950	55835.00	0.00	55835.00	859	7	1500	1372	1.0932944606414	0.926089371100575	0.926089371100575	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-08-18T17:20:11.917066Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
7e5fb167-b3a2-4b7c-9a7d-57214b22f831	2026-08-18 13:19	2026-08-18 13:19	2026-08-18 13:19	FRMI	FRMI260918C00007000	call	7.0000	2026-09-18	0.3500	0.3500	0.4000	6.0205	64155.00	0.00	64155.00	1833	22	2180	17672	0.123358985966501	0.972383798278636	0.972383798278636	false	false	false	true	false
cd420117-a98b-4958-b41a-67ef148fdf24	2026-08-18 13:15	2026-08-18 13:15	2026-08-18 13:15	CBRE	CBRE261218C00160000	call	160.0000	2026-12-18	7.9000	6.8000	8.1000	148.8950	1580000.00	1580000.00	0.00	2000	1	2015	7	287.857142857143	0.335927678843948	0.335927678843948	false	true	false	true	true
3bf36978-31a5-485e-8d43-98f1776d9685	2026-08-18 12:44	2026-08-18 12:44	2026-08-18 12:44	OPEN	OPEN270115C00004000	call	4.0000	2027-01-15	0.5800	0.5600	0.5800	3.4450	15022.00	15022.00	0.00	259	13	1271	6880	0.184738372093023	0.861335632762637	0.861335632762637	false	false	false	true	false
f33c4488-e78a-4e79-b522-8910cdddf688	2026-08-18 12:31	2026-08-18 12:31	2026-08-18 12:31	MPT	MPT270115P00003000	put	3.0000	2027-01-15	0.1100	0.1000	0.1100	4.0300	46244.00	46244.00	0.00	4204	26	8855	14419	0.614120257992926	0.524438675519623	0.524438675519623	false	false	false	true	false
32b372ea-69c1-41a4-b35e-d303a0722cf5	2026-08-18 12:13	2026-08-18 12:13	2026-08-18 12:13	ARE	ARE261016C00052500	call	52.5000	2026-10-16	0.8000	0.8000	0.9000	46.5550	29440.00	0.00	29440.00	368	9	369	461	0.800433839479393	0.346882670895517	0.346882670895517	false	false	false	true	false
61f3d611-014e-46dc-8b5a-df0adf683e4c	2026-08-18 12:10	2026-08-18 12:09	2026-08-18 12:09	CXW	CXW270319P00028000	put	28.0000	2027-03-19	2.0000	2.0000	2.1500	33.2500	19200.00	0.00	19200.00	96	12	208	11334	0.0183518616551968	0.47220975780887	0.47220975780887	false	false	false	true	false
6c3f7f23-98bf-45cb-81f1-86753ddd25e6	2026-08-18 12:00	2026-08-18 11:59	2026-08-18 11:59	OPEN	OPEN270115C00004000	call	4.0000	2027-01-15	0.5800	0.5600	0.5900	3.4350	20358.00	20358.00	0.00	351	11	986	6880	0.143313953488372	0.867176940099163	0.867176940099163	false	false	false	true	false
4ad44d02-39fd-468f-ace3-0c1e6bb74d3b	2026-08-18 11:56	2026-08-18 11:55	2026-08-18 11:55	MPT	MPT270115P00003000	put	3.0000	2027-01-15	0.1000	0.0800	0.1100	4.0200	27760.00	24900.00	2860.00	2776	62	4631	14419	0.321173451695679	0.505327171197599	0.504130824084298	false	false	false	true	false
0a6f641e-9093-4d2a-8485-cb2dde9230d3	2026-08-18 11:55	2026-08-18 11:55	2026-08-18 11:55	MPT	MPT270115P00003000	put	3.0000	2027-01-15	0.1000	0.0800	0.1000	4.0250	10000.00	10000.00	0.00	1000	37	1855	14419	0.128649698314724	0.505327171197599	0.505327171197599	false	false	false	true	false
0d92ecf6-e036-4791-8d08-c5ba5880f055	2026-08-18 11:53	2026-08-18 11:53	2026-08-18 11:53	OPEN	OPEN270115C00004000	call	4.0000	2027-01-15	0.5800	0.5600	0.5800	3.4350	25752.00	25752.00	0.00	444	14	502	6880	0.0729651162790698	0.867176940099163	0.867176940099163	false	false	false	true	false
411ccf99-8dfe-4b58-b1ca-4a2de588521d	2026-08-18 11:35	2026-08-18 11:34	2026-08-18 11:34	RITM	RITM270115C00010000	call	10.0000	2027-01-15	0.7000	0.4500	0.7500	10.2585	12670.00	1330.00	11340.00	181	5	184	8190	0.0224664224664225	0.179170202710136	0.179170202710136	false	false	false	true	false
a5370516-ad00-40a5-b5db-bb18d0eba435	2026-08-18 11:29	2026-08-18 11:29	2026-08-18 11:29	REAX	REAX260918C00002500	call	2.5000	2026-09-18	0.3300	0.2000	0.3500	2.5550	165000.00	165000.00	0.00	5000	2	5006	72	69.5277777777778	1.08661354760856	0.913712214860795	false	true	false	true	false
d32068ff-457b-4ed3-bd3c-ce8e7f0500cf	2026-08-18 11:18	2026-08-18 11:18	2026-08-18 11:18	OPEN	OPEN260821C00003500	call	3.5000	2026-08-21	0.0900	0.0800	0.0900	3.4300	18405.00	18405.00	0.00	2045	39	6840	9852	0.694275274056029	0.968835523476204	0.968835523476204	false	false	false	true	false
73d9ab67-4d5f-44cd-8371-900dbfc7c69f	2026-08-18 10:52	2026-08-18 10:52	2026-08-18 10:52	FRMI	FRMI280121C00010000	call	10.0000	2028-01-21	2.0900	2.0500	2.2000	5.9300	10440.00	0.00	10440.00	50	6	68	5689	0.011952891545087	1.0660701818938	1.0660701818938	false	false	false	true	false
5191c235-1109-41e1-871f-9076cab11d52	2026-08-18 10:37	2026-08-18 10:37	2026-08-18 10:37	HASI	HASI261120C00040000	call	40.0000	2026-11-20	3.6600	3.5000	4.5000	41.7600	25590.00	0.00	25590.00	70	5	70	353	0.198300283286119	0.295341602627734	0.295341602627734	false	false	false	true	false
07467522-741f-4d88-a53d-97b0f7fcdf71	2026-08-18 10:35	2026-08-18 10:35	2026-08-18 10:35	PLD	PLD260918P00135000	put	135.0000	2026-09-18	1.7500	1.3000	2.0000	140.1450	130375.00	1750.00	128625.00	745	20	746	1119	0.666666666666667	0.245927384332619	0.245927384332619	false	false	false	true	false
89f55872-108f-4113-a4c8-1db5b7636acd	2026-08-18 10:06	2026-08-18 10:06	2026-08-18 10:06	CBRE	CBRE260918C00150000	call	150.0000	2026-09-18	5.5500	5.2000	6.2000	149.6300	832500.00	0.00	832500.00	1500	2	1511	10095	0.149678058444775	0.313042812822433	0.313042812822433	false	true	false	true	false
4c5af4e2-abff-4648-8181-06044ce50564	2026-08-18 09:55	2026-08-18 09:55	2026-08-18 09:55	OPEN	OPEN260821C00003500	call	3.5000	2026-08-21	0.0900	0.0900	0.1000	3.4801	18000.00	0.00	18000.00	2000	27	2850	9852	0.289281364190012	0.785544076769827	0.785544076769827	true	false	false	true	false
ba66f582-aa2c-4a00-a9a6-ca9ea44e6bfc	2026-08-18 09:47	2026-08-18 09:47	2026-08-18 09:47	MPT	MPT270319P00004000	put	4.0000	2027-03-19	0.5200	0.4700	0.5200	4.0000	10380.00	6963.00	3417.00	201	6	302	15626	0.0193267630871624	0.471402400849822	0.479841726097357	true	false	false	true	false
610e740f-2bf3-4dde-a109-585f2da0b2a1	2026-08-18 09:47	2026-08-18 09:47	2026-08-18 09:47	O	O280121C00062500	call	62.5000	2028-01-21	5.2000	4.5000	6.3000	62.0000	70200.00	7800.00	62400.00	135	17	135	774	0.174418604651163	0.0955003054111367	0.0955003054111367	false	false	false	true	false
69d2079c-a3cf-4b28-bcbd-1cbcfa682e0b	2026-08-18 09:44	2026-08-18 09:44	2026-08-18 09:44	VICI	VICI270617P00027500	put	27.5000	2027-06-17	3.1000	2.8000	3.1000	26.0000	30378.00	30378.00	0.00	98	11	139	3326	0.0417919422730006	0.30252879578161	0.30252879578161	false	false	false	true	false
1ac023a9-a03e-438b-bb77-bf98b30649f8	2026-08-18 09:44	2026-08-18 09:44	2026-08-18 09:44	FRMI	FRMI261120C00012000	call	12.0000	2026-11-20	0.3000	0.2500	0.3500	5.0000	57000.00	0.00	25290.00	1900	9	2000	5948	0.336247478143914	1.17599838105816	1.17599838105816	false	false	false	true	false
6a33cb71-5400-4bc8-a8e4-dc46b7b43908	2026-08-18 09:42	2026-08-18 09:41	2026-08-18 09:41	FRMI	FRMI261120C00013000	call	13.0000	2026-11-20	0.2500	0.2500	0.3000	5.0000	10010.00	0.00	10010.00	400	27	400	775	0.516129032258065	1.18847943345408	1.18847943345408	true	false	false	true	false
64d801db-d853-433d-be18-a4c099974eea	2026-08-18 09:38	2026-08-18 09:38	2026-08-18 09:38	FRMI	FRMI260918C00008000	call	8.0000	2026-09-18	0.2500	0.2000	0.2500	5.0000	15000.00	15000.00	0.00	600	9	632	9893	0.0638835540281007	1.15281597690516	1.15281597690516	false	false	false	true	false
744a240e-80a5-42ae-b040-4838ea34a57c	2026-08-18 09:38	2026-08-18 09:38	2026-08-18 09:38	FRMI	FRMI260918C00009000	call	9.0000	2026-09-18	0.1500	0.1000	0.2000	5.0000	14880.00	10890.00	3990.00	1000	32	1002	3148	0.318297331639136	1.18773970641413	1.18773970641413	false	false	false	true	false
8e6cd9b7-a2c3-4f8c-8bfe-457bf62fa643	2026-08-17 15:52	2026-08-17 15:52	2026-08-17 15:52	AHR	AHR260918C00055000	call	55.0000	2026-09-18	1.5500	1.5500	1.6000	54.5000	13485.00	0.00	4340.00	87	6	1172	330	3.55151515151515	0.263929976419188	0.263929976419188	false	false	false	true	false
67484013-3ee2-4db4-a888-9dfd10a1f179	2026-08-17 15:52	2026-08-17 15:52	2026-08-17 15:52	AHR	AHR260918C00055000	call	55.0000	2026-09-18	1.6000	1.3000	1.6000	54.5000	10720.00	3680.00	0.00	67	6	1085	330	3.28787878787879	0.271700983444	0.271700983444	false	false	false	true	false
2f9bdc6a-2804-46ab-9b0c-0a56ca5fdbc4	2026-08-17 15:47	2026-08-17 15:47	2026-08-17 15:47	IRM	IRM261016C00130000	call	130.0000	2026-10-16	5.8000	5.2000	6.0000	129.2100	22620.00	9860.00	4640.00	39	5	303	133	2.2781954887218	0.277169704732427	0.277169704732427	false	false	false	true	false
c876331f-5ae6-4cb0-883d-41a56e9a25ab	2026-08-17 15:39	2026-08-17 15:39	2026-08-17 15:39	IRM	IRM260821C00132000	call	132.0000	2026-08-21	0.7000	0.5500	0.7000	129.0300	10780.00	10780.00	0.00	154	31	168	27	6.22222222222222	0.32907030084255	0.32907030084255	false	false	false	true	false
cda849fc-1623-4ae0-bcb7-62f080b61062	2026-08-17 15:22	2026-08-17 15:22	2026-08-17 15:22	OPEN	OPEN270115C00003000	call	3.0000	2027-01-15	0.9900	0.9700	1.0300	3.4750	16434.00	12474.00	3960.00	166	6	336	3027	0.111000991080278	0.848685519112447	0.85815935177047	false	false	false	true	false
f2223364-7eff-462b-aa75-22327f2fbb07	2026-08-17 15:14	2026-08-17 15:13	2026-08-17 15:13	CBRE	CBRE261218C00155000	call	155.0000	2026-12-18	9.7000	9.2000	9.7000	148.6350	70810.00	70810.00	0.00	73	24	73	4	18.25	0.336497395514464	0.336497395514464	false	false	false	true	false
48e836c4-2863-4f87-a18e-0a94c7f8a671	2026-08-17 15:00	2026-08-17 15:00	2026-08-17 15:00	FRMI	FRMI261016C00010000	call	10.0000	2026-10-16	0.2600	0.2500	0.3000	6.1350	13054.00	0.00	13054.00	503	16	589	7741	0.0760883606769151	1.12033510454828	1.12322147200969	false	false	false	true	false
ec5e159f-0b20-4c52-ba29-a1c5f0d49803	2026-08-17 14:58	2026-08-17 14:58	2026-08-17 14:58	OPEN	OPEN280121C00015000	call	15.0000	2028-01-21	0.4400	0.4400	0.4900	3.4800	14675.00	0.00	14405.00	333	7	907	28430	0.0319029194512839	1.00530611930538	0.998217367246282	false	false	false	true	false
9d73efc9-ae34-48f4-83c9-bdf42d51c71c	2026-08-17 14:55	2026-08-17 14:55	2026-08-17 14:55	ARE	ARE260918C00047500	call	47.5000	2026-09-18	1.5000	1.3500	1.5500	46.2050	10500.00	7800.00	2700.00	70	11	227	26	8.73076923076923	0.365361619697458	0.365361619697458	true	false	false	true	false
184b81e5-f16d-42b8-82f7-66a4ad3907dd	2026-08-17 14:29	2026-08-17 14:29	2026-08-17 14:29	WELL	WELL261016C00240000	call	240.0000	2026-10-16	7.4000	7.1000	8.5000	235.1350	51060.00	0.00	51060.00	69	23	74	0	0	0.2346072283742	0.2346072283742	false	false	false	true	false
3bb6fb45-be76-4c3f-a068-825fb6a508b6	2026-08-17 14:21	2026-08-17 14:20	2026-08-17 14:20	IRM	IRM261016C00130000	call	130.0000	2026-10-16	5.5000	5.3000	5.9000	128.6900	18700.00	4400.00	3850.00	34	5	223	133	1.67669172932331	0.275643713439699	0.275643713439699	false	false	false	true	false
bfda78d6-8a32-453c-99a0-57ee178f0257	2026-08-17 14:11	2026-08-17 14:11	2026-08-17 14:11	AGNC	AGNC260911P00010500	put	10.5000	2026-09-11	0.1200	0.1100	0.1200	10.0000	17448.00	17448.00	0.00	1454	41	6647	1445	4.6	0.264367772528582	0.264367772528582	false	false	false	true	false
351efda0-8207-4c90-8373-51ab62e089d2	2026-08-17 14:09	2026-08-17 14:09	2026-08-17 14:09	EQIX	EQIX260918C01080000	call	1080.0000	2026-09-18	46.0000	46.0000	48.6000	1095.0000	142600.00	0.00	142600.00	31	19	32	32	1	0.241804860229276	0.241804860229276	false	false	false	true	false
151c834b-8589-4ec3-978e-f404b8f286e4	2026-08-17 14:09	2026-08-17 14:09	2026-08-17 14:09	AGNC	AGNC260911P00010500	put	10.5000	2026-09-11	0.1100	0.0900	0.1200	10.0000	12837.00	627.00	12210.00	1167	11	3894	1445	2.69480968858131	0.254731584722909	0.254731584722909	true	false	false	true	false
a40a18cd-8147-499d-bf04-e2507f5a0eb2	2026-08-17 14:08	2026-08-17 14:08	2026-08-17 14:08	EPR	EPR261016P00055000	put	55.0000	2026-10-16	0.6000	0.6000	0.7500	60.0000	10150.00	0.00	10150.00	169	22	172	94	1.82978723404255	0.265120773981373	0.265120773981373	false	false	false	true	false
28804177-4524-4738-8851-f39748f27f80	2026-08-17 13:52	2026-08-17 13:52	2026-08-17 13:52	GEO	GEO261120P00027000	put	27.0000	2026-11-20	1.3500	1.3500	1.4500	31.0000	16335.00	0.00	16335.00	121	9	121	12	10.0833333333333	0.542403315613211	0.542403315613211	false	false	false	true	false
8cc86610-9914-4dd2-a98a-781238b34d89	2026-08-17 13:46	2026-08-17 13:46	2026-08-17 13:46	LODE	LODE270115C00004000	call	4.0000	2027-01-15	0.5000	0.5000	0.5500	3.0000	25020.00	0.00	25020.00	500	8	14835	25	593.4	0.815624495143827	0.815624495143827	false	false	false	true	false
cb3b0cfa-b5ae-4b5d-a0e9-9c65427d8e9a	2026-08-17 13:29	2026-08-17 13:29	2026-08-17 13:29	OPEN	OPEN261120C00003000	call	3.0000	2026-11-20	0.8900	0.8900	0.9000	3.5100	12816.00	0.00	12816.00	144	19	1250	1336	0.93562874251497	0.88976261636588	0.88976261636588	true	false	false	true	false
f30316be-90e6-40d0-a132-f6ea33741a66	2026-08-17 13:26	2026-08-17 13:25	2026-08-17 13:25	LODE	LODE270115C00004000	call	4.0000	2027-01-15	0.5400	0.5000	0.6500	3.4250	42393.00	55.00	42338.00	788	29	12511	25	500.44	0.832823004900945	0.778944917617791	true	false	false	true	false
7cf3501b-5af9-4879-90ce-1d435795f9ad	2026-08-17 13:26	2026-08-17 13:25	2026-08-17 13:25	LODE	LODE270115C00004000	call	4.0000	2027-01-15	0.5400	0.5000	0.6500	3.4150	96126.00	77606.00	18520.00	1781	40	14328	25	573.12	0.825833149538906	0.841584373092423	false	false	false	true	false
28c4aac0-4e83-4832-9d72-d7f64d881144	2026-08-17 13:19	2026-08-17 13:19	2026-08-17 13:19	LODE	LODE270115C00004000	call	4.0000	2027-01-15	0.6000	0.6000	0.7500	3.5250	14645.00	0.00	14645.00	244	24	11323	25	452.92	0.889641293181593	0.834189434127765	false	false	false	true	false
e3696318-5971-4f11-a7a4-7fc1714ceb4f	2026-08-17 13:19	2026-08-17 13:19	2026-08-17 13:19	LODE	LODE270115C00004000	call	4.0000	2027-01-15	0.6500	0.6000	0.7500	3.5400	165291.00	0.00	165291.00	2551	17	10953	25	438.12	0.876827712674379	0.825470653470979	true	false	false	true	false
90b6c3a3-2cbf-407d-951e-2689925ed193	2026-08-17 13:11	2026-08-17 13:11	2026-08-17 13:11	GLPI	GLPI261016P00042500	put	42.5000	2026-10-16	2.0000	2.0000	2.1500	42.1400	17400.00	0.00	17400.00	87	19	91	306	0.297385620915033	0.286266779850052	0.286266779850052	false	false	false	true	false
651cc4a9-014c-4f01-b961-fe0f9b00c02e	2026-08-17 12:07	2026-08-17 12:07	2026-08-17 12:07	FRMI	FRMI270219P00006000	put	6.0000	2027-02-19	1.6000	1.6000	1.8000	6.2500	80000.00	0.00	80000.00	500	7	500	636	0.786163522012579	1.05478244751987	1.05478244751987	false	false	false	true	false