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.

728,802 rows

Sources in this table

uw_flow_alerts728,802 rows

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:alert_rule = RepeatedHits×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	expiry

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	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Real Estate	15322807184.00	2026-11-04	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-21T18:49:22.677317Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
2f816e4e-1a1e-4f41-a8c3-b971ade5df61	2026-08-20 13:16	2026-08-20 13:16	2026-08-20 13:16	CSGP	CSGP260821C00030000	call	30.0000	2026-08-21	2.2500	2.2500	2.5500	32.2500	22500.00	0.00	19800.00	100	5	120	855	0.140350877192982	1.64023215840299	0.935971955885287	false	false	false	true
de48cad1-78f7-4978-a9ca-ed2686c05318	2026-08-20 13:07	2026-08-20 13:07	2026-08-20 13:07	BXP	BXP261016P00065000	put	65.0000	2026-10-16	1.6500	1.6500	2.0000	67.7000	33000.00	0.00	33000.00	200	7	400	22	18.1818181818182	0.281953687447547	0.281953687447547	false	false	false	true
f17c08a0-e93f-4588-a938-6b75a6a398d9	2026-08-20 12:43	2026-08-20 12:43	2026-08-20 12:43	OPEN	OPEN261120C00005000	call	5.0000	2026-11-20	0.2400	0.2300	0.2500	3.4550	10560.00	9840.00	0.00	440	10	644	7883	0.08169478624889	0.929114028956684	0.929114028956684	false	false	false	true
f5f67925-e6de-4078-b088-cb89763274dd	2026-08-20 12:41	2026-08-20 12:41	2026-08-20 12:41	CBRE	CBRE260918C00170000	call	170.0000	2026-09-18	0.9000	0.8500	1.0500	153.7400	21240.00	90.00	21150.00	236	11	404	2461	0.164160910199106	0.306210183749537	0.306210183749537	false	false	false	true
f68f283e-4bb6-4c6e-9713-9f131679282d	2026-08-20 12:35	2026-08-20 12:34	2026-08-20 12:34	CBRE	CBRE270115C00170000	call	170.0000	2027-01-15	7.5000	7.2000	8.1000	153.5800	17250.00	13500.00	3750.00	23	7	94	184	0.510869565217391	0.325795080687109	0.325795080687109	false	false	false	true
f2a15a7d-f6cc-42a4-aeb0-74f0ba490d44	2026-08-20 12:34	2026-08-20 12:34	2026-08-20 12:34	CBRE	CBRE270115C00170000	call	170.0000	2027-01-15	7.5000	7.2000	7.6000	153.5800	17250.00	17250.00	0.00	23	8	71	184	0.385869565217391	0.325795080687109	0.325795080687109	false	false	false	true
7ba6d2fe-ad5c-4737-ba94-c6350a49e562	2026-08-20 12:34	2026-08-20 12:34	2026-08-20 12:34	CBRE	CBRE270115C00170000	call	170.0000	2027-01-15	7.5000	7.2000	7.6000	153.5800	17250.00	14250.00	3000.00	23	8	48	184	0.260869565217391	0.325795080687109	0.325795080687109	false	false	false	true
b4b4f95e-28f7-4601-9e36-f6d0e825086e	2026-08-20 12:15	2026-08-20 12:15	2026-08-20 12:15	FRMI	FRMI261016C00007000	call	7.0000	2026-10-16	0.5500	0.5500	0.6000	5.7150	11000.00	0.00	11000.00	200	15	1748	1491	1.17236753856472	1.06985099140949	1.06985099140949	false	false	false	true
e9844d63-5dd5-46c9-9d62-c47b96e09cd7	2026-08-20 12:10	2026-08-20 12:10	2026-08-20 12:10	ARE	ARE260821P00050000	put	50.0000	2026-08-21	0.3000	0.2000	0.3500	50.7100	14992.00	13462.00	1530.00	500	13	1484	3425	0.433284671532847	0.56107074279622	0.56107074279622	false	false	false	true
12891074-c0f6-4be8-a5cb-9377e65b55ca	2026-08-20 11:34	2026-08-20 11:34	2026-08-20 11:34	AGNC	AGNC260911C00010500	call	10.5000	2026-09-11	0.4600	0.4400	0.5300	10.9150	62098.00	0.00	62098.00	1350	28	1355	48	28.2291666666667	0.1266638853311	0.0779232993875792	false	false	false	true
d613f46b-5b54-4b74-86e1-fa23a30ef462	2026-08-20 11:34	2026-08-20 11:34	2026-08-20 11:34	AGNC	AGNC261016P00011000	put	11.0000	2026-10-16	0.4800	0.4800	0.5300	10.9250	10368.00	0.00	9504.00	216	8	5449	0	0	0.275863418119616	0.275863418119616	true	false	false	true
55508e31-2826-4e81-9fb5-9e4a3c5fab63	2026-08-20 11:32	2026-08-20 11:32	2026-08-20 11:32	AGNC	AGNC261016C00011000	call	11.0000	2026-10-16	0.2800	0.2400	0.3300	10.9250	44352.00	44324.00	28.00	1584	30	9658	0	0	0.165337665792508	0.165337665792508	true	false	false	true
7bf401df-387e-48d6-b3b7-f55ebbfcd7bc	2026-08-20 10:56	2026-08-20 10:56	2026-08-20 10:56	FRMI	FRMI261016C00007000	call	7.0000	2026-10-16	0.6000	0.5500	0.6500	5.7150	14940.00	7140.00	3720.00	249	5	922	1491	0.618376928236083	1.12692410726281	1.12692410726281	false	false	false	true
e35bc780-2d73-4503-b7ad-01c2254c0a6b	2026-08-20 10:52	2026-08-20 10:52	2026-08-20 10:52	GEO	GEO260918C00032000	call	32.0000	2026-09-18	1.5000	1.3000	1.6000	31.7900	15000.00	3300.00	3000.00	100	5	114	2243	0.050824788230049	0.434892850219687	0.434892850219687	false	false	false	true
e6222bd9-27c8-43ce-98d3-2c327cbefbe2	2026-08-20 10:51	2026-08-20 10:50	2026-08-20 10:50	OHI	OHI260918P00045000	put	45.0000	2026-09-18	0.5000	0.4000	0.5500	46.9550	13200.00	13100.00	100.00	264	5	4005	189	21.1904761904762	0.248636802869062	0.248636802869062	false	false	false	true
d95ccbaf-7040-4f2d-bcde-c77866d45599	2026-08-20 10:48	2026-08-20 10:48	2026-08-20 10:48	CSGP	CSGP261218P00030000	put	30.0000	2026-12-18	2.6500	2.5500	2.6500	31.8500	16960.00	16960.00	0.00	64	19	64	181	0.353591160220994	0.522399275994542	0.522399275994542	false	false	false	true
995f36c8-0a1e-445d-bf13-bd69ee2d7fb1	2026-08-20 10:42	2026-08-20 10:42	2026-08-20 10:42	OHI	OHI260918P00045000	put	45.0000	2026-09-18	0.5000	0.3000	0.6000	46.8500	30150.00	16100.00	13250.00	603	33	3300	189	17.4603174603175	0.24299261521048	0.242394800685124	false	false	false	true
66039f50-8054-4f1e-86e3-535714cc0295	2026-08-20 10:42	2026-08-20 10:42	2026-08-20 10:42	OHI	OHI260918P00045000	put	45.0000	2026-09-18	0.5000	0.3500	0.5500	46.8600	32100.00	26850.00	5000.00	642	38	2695	189	14.2592592592593	0.246564659009395	0.24299261521048	false	false	false	true
25a335c0-6008-4a3b-998b-ce9665c757d1	2026-08-20 10:42	2026-08-20 10:42	2026-08-20 10:42	OHI	OHI260918P00045000	put	45.0000	2026-09-18	0.5000	0.3000	0.5500	46.9500	21295.00	21150.00	145.00	426	19	2044	189	10.8148148148148	0.248341295643909	0.248341295643909	false	false	false	true
ff3753b0-6b90-4de3-a6eb-f3ff4bf115c0	2026-08-20 10:42	2026-08-20 10:42	2026-08-20 10:42	OHI	OHI260918P00045000	put	45.0000	2026-09-18	0.5000	0.3000	0.5500	46.9900	24850.00	5250.00	19550.00	497	44	1615	189	8.54497354497354	0.250700616286049	0.250700616286049	false	false	false	true
7c0577cb-038a-41dd-ba07-139cae43eeb2	2026-08-20 10:42	2026-08-20 10:41	2026-08-20 10:41	CSGP	CSGP270319C00045000	call	45.0000	2027-03-19	1.7500	1.6500	1.8000	31.8500	19425.00	350.00	19075.00	111	6	19777	14624	1.35236597374179	0.525006769975961	0.525006769975961	false	false	false	true
baa9cf4e-da42-4649-9021-867b2075ce6b	2026-08-20 10:34	2026-08-20 10:34	2026-08-20 10:34	VMRK	VMRK270416P00050000	put	50.0000	2027-04-16	0.8500	0.5500	0.8500	65.5800	13515.00	13515.00	0.00	159	20	159	0	0	0.313910634411028	0.313910634411028	true	false	false	true
79d181be-7a43-4cdb-b811-f1ee745776ed	2026-08-20 10:22	2026-08-20 10:22	2026-08-20 10:22	OPEN	OPEN261218C00008000	call	8.0000	2026-12-18	0.1000	0.0900	0.1000	3.4501	12940.00	12940.00	0.00	1294	22	1294	884	1.46380090497738	1.00848398274491	1.00848398274491	false	false	false	true