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

9277e10c-7fd5-43e4-8432-a5d290681747	2026-08-21 15:32	2026-08-21 15:32	2026-08-21 15:32	FRMI	FRMI260821C00005500	call	5.5000	2026-08-21	0.4000	0.4000	0.4500	5.9250	12850.00	0.00	12850.00	321	19	754	785	0.960509554140127	9.14943661371336	9.14943661371336	false	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	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-21T19:32:44.160800Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
a1b67f3a-cba0-480a-9198-b033c02a7fe8	2026-08-21 15:23	2026-08-21 15:23	2026-08-21 15:23	ARE	ARE261016P00050000	put	50.0000	2026-10-16	2.1000	1.7500	2.1000	53.1400	21000.00	1260.00	0.00	100	7	121	1601	0.075577763897564	0.443086610850519	0.443086610850519	false	false	false	true	false
3cba90a2-e627-4b06-97fb-cf76337ae575	2026-08-21 15:15	2026-08-21 15:15	2026-08-21 15:15	GEO	GEO260918C00031000	call	31.0000	2026-09-18	2.7000	2.6500	2.7000	32.6650	27000.00	27000.00	0.00	100	7	20995	1130	18.5796460176991	0.47832603963824	0.47832603963824	false	false	false	true	false
a1172083-8aa3-4212-8741-bceb1c765474	2026-08-21 14:49	2026-08-21 14:49	2026-08-21 14:49	GEO	GEO260821C00029000	call	29.0000	2026-08-21	3.3800	3.3000	3.5000	32.4100	110870.00	67320.00	1675.00	328	42	2548	2530	1.00711462450593	2.23060611870082	6.84595359111676	false	false	false	true	false
49ca02bb-eb07-4072-a249-f15ca486c824	2026-08-21 14:49	2026-08-21 14:49	2026-08-21 14:49	GEO	GEO260918C00031000	call	31.0000	2026-09-18	2.5000	2.4500	2.5000	32.4100	75000.00	75000.00	0.00	300	19	20409	1130	18.0610619469027	0.469794306041064	0.469794306041064	false	false	false	true	false
13f55f7b-6fd1-469a-831c-bfaaf536ef68	2026-08-21 14:48	2026-08-21 14:47	2026-08-21 14:47	GEO	GEO260821C00029000	call	29.0000	2026-08-21	3.3700	3.3000	3.4000	32.3900	66410.00	28220.00	0.00	197	16	2220	2530	0.877470355731225	4.45728642291986	4.45728642291986	false	false	false	true	false
72e642cc-c313-4b81-9976-41758e542c8d	2026-08-21 14:47	2026-08-21 14:47	2026-08-21 14:47	GEO	GEO260821C00029000	call	29.0000	2026-08-21	3.3700	3.3000	3.4000	32.3900	55930.00	21760.00	0.00	166	10	1931	2530	0.763241106719368	4.45418505836468	4.45418505836468	false	false	false	true	false
45153c33-8c60-4695-a6e1-28f428974466	2026-08-21 14:47	2026-08-21 14:47	2026-08-21 14:47	GEO	GEO260821C00029000	call	29.0000	2026-08-21	3.3800	3.3000	3.4000	32.4000	31125.00	20740.00	0.00	92	5	2023	2530	0.799604743083004	1.93211433629042	1.93211433629042	false	false	false	true	false
6b55f193-6456-4236-90d1-61fd563d15cb	2026-08-21 14:47	2026-08-21 14:47	2026-08-21 14:47	GEO	GEO260821C00029000	call	29.0000	2026-08-21	3.3700	3.3000	3.4000	32.3950	56940.00	22100.00	0.00	169	12	1765	2530	0.697628458498024	4.04745099450866	4.04745099450866	false	false	false	true	false
524cf2a8-29a1-419e-a180-644bc55734dc	2026-08-21 14:47	2026-08-21 14:47	2026-08-21 14:47	GEO	GEO260821C00029000	call	29.0000	2026-08-21	3.3700	3.1000	3.4000	32.4000	180490.00	88365.00	0.00	536	48	1575	2530	0.622529644268775	4.94846925357097	1.93211433629042	false	false	false	true	false
c7576407-089a-45a4-8859-6fffc16cef7e	2026-08-21 14:44	2026-08-21 14:43	2026-08-21 14:43	GEO	GEO260918C00035000	call	35.0000	2026-09-18	0.7000	0.6000	0.7000	32.3100	21000.00	21000.00	0.00	300	9	20678	2370	8.72489451476793	0.455059650495724	0.455059650495724	false	false	false	true	false
c03b39bf-8434-4302-97b1-28da3e79ce99	2026-08-21 14:35	2026-08-21 14:34	2026-08-21 14:34	BXP	BXP261016P00065000	put	65.0000	2026-10-16	1.6200	1.1500	2.1500	67.5200	375840.00	0.00	375840.00	2320	2	2320	404	5.74257425742574	0.274878484571177	0.274878484571177	false	true	true	false	true
4d2e88e8-d0d4-4a08-930f-a247ca2bf366	2026-08-21 14:27	2026-08-21 14:27	2026-08-21 14:27	HST	HST260821P00024280	put	24.2800	2026-08-21	1.1000	0.9000	1.2500	23.1600	21012.00	3190.00	17822.00	191	36	968	4364	0.221814848762603	3.96560253668176	2.31728243448955	false	false	false	true	false
00e5c865-d065-40db-8863-0960ea403a1d	2026-08-21 14:21	2026-08-21 14:20	2026-08-21 14:20	HST	HST260821P00024280	put	24.2800	2026-08-21	1.1000	1.0000	1.1000	23.0000	27500.00	27500.00	0.00	250	18	376	4364	0.0861594867094409	1.07833297296526	1.07833297296526	false	false	false	true	false
4572c917-103a-4381-8988-15b96612559f	2026-08-21 14:12	2026-08-21 14:12	2026-08-21 14:12	GEO	GEO260918C00031000	call	31.0000	2026-09-18	2.4900	2.2500	2.5000	32.0000	4980000.00	4980000.00	0.00	20000	4	20006	1130	17.7044247787611	0.472831992653652	0.472831992653652	false	true	true	false	true
9e2bc405-7e7a-4d43-97d9-d95de8cd7051	2026-08-21 14:09	2026-08-21 14:09	2026-08-21 14:09	AGNT	AGNT261016C00005000	call	5.0000	2026-10-16	0.2000	0.2000	0.3000	4.0000	10020.00	0.00	10020.00	501	5	501	0	0	0.548938502905146	0.548938502905146	false	false	false	true	false
eff34245-750e-451b-bde0-ba37dc9f0171	2026-08-21 14:04	2026-08-21 14:04	2026-08-21 14:04	WELL	WELL270521C00220000	call	220.0000	2027-05-21	35.5000	35.5000	37.6000	239.0000	71000.00	0.00	71000.00	20	7	31	18	1.72222222222222	0.258350821377233	0.258350821377233	false	false	false	true	false
cb778b52-e5b2-4225-98c1-3a2a26206e7e	2026-08-21 14:01	2026-08-21 14:01	2026-08-21 14:01	GEO	GEO260821C00029000	call	29.0000	2026-08-21	3.4000	3.4000	3.4000	32.5300	60870.00	3410.00	0.00	179	19	226	2530	0.0893280632411067	1.09723600550926	1.09723600550926	false	false	false	true	false
256025c4-ef84-45d5-a59a-0703f4da4ef0	2026-08-21 14:01	2026-08-21 14:01	2026-08-21 14:01	GEO	GEO260821C00029000	call	29.0000	2026-08-21	3.4000	3.2000	3.6000	32.4400	276471.00	48840.00	198391.00	812	60	1038	2530	0.410276679841897	5.40699772302236	1.09723600550926	true	false	false	true	false
454edcf1-fbca-4f24-a35e-4d28346991f7	2026-08-21 13:43	2026-08-21 13:42	2026-08-21 13:42	CXW	CXW260821C00030000	call	30.0000	2026-08-21	3.8000	2.9000	4.3000	33.7800	1900000.00	1900000.00	0.00	5000	6	5000	9504	0.526094276094276	3.7984564345704	3.7984564345704	false	true	true	false	false
ab557b32-e8c7-4f61-89b2-550e735822bc	2026-08-21 11:44	2026-08-21 11:43	2026-08-21 11:43	FRMI	FRMI261016C00006000	call	6.0000	2026-10-16	1.0500	1.0000	1.0500	6.0650	20019.00	20019.00	0.00	191	13	369	916	0.402838427947598	1.07170760466387	1.06010901389655	false	false	false	true	false
aa18c851-99b4-4fb5-a044-960687c97f8c	2026-08-21 11:32	2026-08-21 11:32	2026-08-21 11:32	O	O270319P00067500	put	67.5000	2027-03-19	6.6000	6.4000	6.6000	62.7950	89759.00	89759.00	0.00	136	24	229	3	76.3333333333333	0.249475557281663	0.249324613408048	false	false	false	true	false
9d9c8300-7e3d-4326-8fba-428bc27e2459	2026-08-21 11:27	2026-08-21 11:26	2026-08-21 11:26	EQIX	EQIX261016C01120000	call	1120.0000	2026-10-16	26.1000	23.5000	26.1000	1061.1700	180090.00	180090.00	0.00	69	25	76	1	76	0.281385662740497	0.281385662740497	false	false	false	true	false
0c09dee8-06d6-4e30-a09b-021430378e93	2026-08-21 11:22	2026-08-21 11:21	2026-08-21 11:21	GEO	GEO280121C00045000	call	45.0000	2028-01-21	5.2000	4.6000	5.2000	32.0000	207971.00	207971.00	0.00	400	7	400	3226	0.123992560446373	0.550499187179075	0.551160077169795	false	false	false	true	false
07311a76-884c-4829-9de0-83797d400b42	2026-08-21 11:21	2026-08-21 11:21	2026-08-21 11:21	VICI	VICI260918C00027500	call	27.5000	2026-09-18	0.1500	0.1500	0.2000	26.5810	30011.00	0.00	30011.00	2000	62	2037	10084	0.202003173343911	0.15011757426563	0.151053550543596	false	false	false	true	false
9d5d6520-979b-4f05-be21-98e065fc79ea	2026-08-21 10:39	2026-08-21 10:39	2026-08-21 10:39	REAX	REAX260821C00002500	call	2.5000	2026-08-21	0.3000	0.2000	0.3000	2.7350	11940.00	11940.00	0.00	398	27	2169	5940	0.365151515151515	6.01954673480573	6.01954673480573	false	false	false	true	false
1ee78b7e-ed39-4e04-a464-1c497e7eed96	2026-08-21 10:08	2026-08-21 10:08	2026-08-21 10:08	REAX	REAX260821C00002500	call	2.5000	2026-08-21	0.3000	0.1500	0.3500	2.7150	18870.00	18870.00	0.00	629	22	1151	5940	0.193771043771044	6.38497727638453	6.38497727638453	false	false	false	true	false
1af5e372-5623-4ca9-be62-7aed342377fd	2026-08-21 09:46	2026-08-21 09:45	2026-08-21 09:45	SLG	SLG260821C00052500	call	52.5000	2026-08-21	5.8700	5.1000	7.4000	58.8700	82138.00	0.00	82138.00	140	14	140	653	0.214395099540582	5.53624726147049	5.53624726147049	false	false	false	true	false
0fb6466e-884e-43c5-9104-c76f5de25a99	2026-08-21 09:43	2026-08-21 09:43	2026-08-21 09:43	OPEN	OPEN280915C00007000	call	7.0000	2028-09-15	1.2500	1.2300	1.3700	3.4900	21193.00	1750.00	19443.00	170	5	180	5549	0.0324382771670571	0.960410871367283	0.943462787578497	true	false	false	true	false
4533a56c-a5d5-467d-9a63-c7c0ef770ab4	2026-08-21 09:39	2026-08-21 09:39	2026-08-21 09:39	OPEN	OPEN270115C00004000	call	4.0000	2027-01-15	0.6200	0.5500	0.6200	3.4750	31000.00	31000.00	0.00	500	9	503	8146	0.0617480972256322	0.89846485575037	0.89846485575037	false	false	false	true	false
d4df7ee2-8275-4a85-870f-bfa78fbd2033	2026-08-20 15:47	2026-08-20 15:47	2026-08-20 15:47	ABR	ABR270115C00005000	call	5.0000	2027-01-15	0.6500	0.6000	0.7000	5.1900	13130.00	11635.00	0.00	202	40	203	3126	0.0649392194497761	0.393548321218232	0.393548321218232	true	false	false	true	false
5c4fc790-72d3-4a83-ac69-25d31540ab0a	2026-08-20 15:14	2026-08-20 15:14	2026-08-20 15:14	AGNC	AGNC261016P00011000	put	11.0000	2026-10-16	0.4700	0.4600	0.5100	10.9350	16168.00	799.00	14241.00	344	22	6176	0	0	0.272841726266699	0.272841726266699	false	false	false	true	false
785624cd-4318-4b71-b34c-53278a700a49	2026-08-20 15:10	2026-08-20 15:10	2026-08-20 15:10	ARE	ARE261016P00050000	put	50.0000	2026-10-16	2.5000	2.2500	2.5000	51.8400	22250.00	22250.00	0.00	89	6	3001	3849	0.77968303455443	0.433355470707927	0.433355470707927	false	false	false	true	false
5f51e5cc-f086-4ec8-a74b-265d97330e22	2026-08-20 15:10	2026-08-20 15:10	2026-08-20 15:10	ARE	ARE261016P00050000	put	50.0000	2026-10-16	2.5000	2.2500	2.5000	51.8400	25500.00	25500.00	0.00	102	9	3103	3849	0.806183424266043	0.433355470707927	0.433355470707927	false	false	false	true	false
fa5c7ddc-5499-49b7-9828-b233bce4dca8	2026-08-20 14:48	2026-08-20 14:48	2026-08-20 14:48	ARE	ARE261016P00050000	put	50.0000	2026-10-16	2.5000	2.2500	2.5000	51.7925	78500.00	78500.00	0.00	314	10	1903	3849	0.49441413354118	0.43287676388592	0.431077984526874	false	false	false	true	false
09a1ee20-214e-49c7-a978-f410f70a53b4	2026-08-20 14:44	2026-08-20 14:44	2026-08-20 14:44	ARE	ARE261016P00050000	put	50.0000	2026-10-16	2.5000	2.3000	2.5000	51.6800	23250.00	13750.00	0.00	93	22	1465	3849	0.380618342426604	0.425646743490968	0.425646743490968	true	false	false	true	false
14aea226-bed3-412d-8ec2-7f9198eed8c8	2026-08-20 14:44	2026-08-20 14:44	2026-08-20 14:44	ARE	ARE261016P00050000	put	50.0000	2026-10-16	2.5000	2.3000	2.5000	51.6500	32500.00	32500.00	0.00	130	8	1346	3849	0.349701221096389	0.424189416993373	0.424189416993373	false	false	false	true	false
41046e8e-3b0f-44bd-8b20-c3592e4fc8b7	2026-08-20 14:44	2026-08-20 14:44	2026-08-20 14:44	ARE	ARE261016P00050000	put	50.0000	2026-10-16	2.5000	2.3000	2.5000	51.6600	32485.00	31750.00	735.00	130	9	1216	3849	0.315926214601195	0.418223893166361	0.424675618743649	false	false	false	true	false
0a869f14-0ba0-4572-80ff-63ab19d19551	2026-08-20 14:44	2026-08-20 14:43	2026-08-20 14:43	ARE	ARE261016P00050000	put	50.0000	2026-10-16	2.4900	2.3000	2.5000	51.6600	32428.00	32428.00	0.00	130	15	1086	3849	0.282151208106002	0.424675618743649	0.423385641438778	false	false	false	true	false
5a900aa4-087e-4d0a-820b-29e48e54c453	2026-08-20 14:43	2026-08-20 14:43	2026-08-20 14:43	AGNC	AGNC261016C00011000	call	11.0000	2026-10-16	0.2700	0.2000	0.2700	10.9200	12204.00	12204.00	0.00	452	8	10994	0	0	0.160998869720323	0.160998869720323	false	false	false	true	false
952e711f-bd9a-4b47-8e6b-57f9b74e45ed	2026-08-20 14:10	2026-08-20 14:10	2026-08-20 14:10	ARE	ARE261016C00055000	call	55.0000	2026-10-16	1.3600	1.3000	1.5000	51.0900	372640.00	0.00	295920.00	2740	2	3639	638	5.70376175548589	0.340959382005655	0.340959382005655	false	true	false	true	false
dcedb8ee-0b8d-4bd8-8185-9ec1007f8038	2026-08-20 13:53	2026-08-20 13:53	2026-08-20 13:53	GEO	GEO260821C00030000	call	30.0000	2026-08-21	1.8500	1.4000	2.0000	31.8400	27750.00	3330.00	24420.00	150	6	770	3067	0.251059667427454	0.706871854510544	0.558639056966902	false	false	false	true	false
ca62682b-5b1c-49b9-a77c-39447762754d	2026-08-20 13:49	2026-08-20 13:48	2026-08-20 13:48	ARE	ARE261016C00055000	call	55.0000	2026-10-16	1.3500	1.3500	1.5000	51.0400	15390.00	0.00	15390.00	114	6	311	638	0.487460815047022	0.336359979165216	0.336359979165216	true	false	false	true	false
2b8a7cfe-71f9-41ff-b939-bba78ff2e55e	2026-08-20 13:41	2026-08-20 13:41	2026-08-20 13:41	FRMI	FRMI261218C00019000	call	19.0000	2026-12-18	0.2000	0.1500	0.2500	5.7350	20960.00	20480.00	0.00	1048	32	1066	2190	0.48675799086758	1.33881381053339	1.33881381053339	false	false	false	true	false
392e5f81-530c-43b8-848f-4ce2d5a81212	2026-08-20 13:35	2026-08-20 13:34	2026-08-20 13:34	TWO	TWO261218P00013000	put	13.0000	2026-12-18	1.1500	1.1500	4.0000	12.0250	10236.00	0.00	10236.00	89	11	251	714	0.351540616246499	0.235265982711894	0.235265982711894	true	false	false	true	false
754ed118-55c1-4bf9-ad22-4e92f3e1e53b	2026-08-20 13:34	2026-08-20 13:33	2026-08-20 13:33	NLY	NLY260918C00023000	call	23.0000	2026-09-18	0.7400	0.7300	0.7700	23.3897	64750.00	0.00	62382.00	875	21	898	2203	0.407625964593736	0.182808642983428	0.182808642983428	false	false	false	true	false
d6f69fc7-73d6-4178-9bdb-0be7a3a00817	2026-08-20 13:29	2026-08-20 13:29	2026-08-20 13:29	IRM	IRM261016P00125000	put	125.0000	2026-10-16	7.1000	7.0000	8.2000	122.6700	66740.00	15620.00	51120.00	94	74	109	117	0.931623931623932	0.322542716307292	0.322542716307292	false	false	false	true	false
e7f7959c-2cbb-4786-a9f4-ef5a629c4191	2026-08-20 13:29	2026-08-20 13:29	2026-08-20 13:29	IRM	IRM261016P00125000	put	125.0000	2026-10-16	7.1000	7.0000	8.2000	122.7200	10650.00	0.00	10650.00	15	15	15	117	0.128205128205128	0.323872360182862	0.323872360182862	false	false	false	true	false
5c3e2a9f-eaa1-489e-8bd6-f12b506256e2	2026-08-20 13:20	2026-08-20 13:20	2026-08-20 13:20	OPEN	OPEN270115C00004000	call	4.0000	2027-01-15	0.5700	0.5600	0.5700	3.4450	28500.00	28500.00	0.00	500	26	539	7117	0.0757341576506955	0.856053503671567	0.856053503671567	false	false	false	true	false
1bdbc974-be5e-4853-8d71-f68b04f7bf10	2026-08-20 13:18	2026-08-20 13:18	2026-08-20 13:18	FRMI	FRMI260828C00005500	call	5.5000	2026-08-28	0.4500	0.4000	0.5000	5.6850	33300.00	28305.00	4995.00	740	8	1094	756	1.44708994708995	1.05220429783038	1.05220429783038	false	false	false	true	false