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.

326,449 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts326,449 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:alert_rule = RepeatedHits×sector = Real Estate×sorted by created_at ↑×

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

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	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-17T13:42:20.529509Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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