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.

609,118 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts609,118 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

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	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Real Estate	4060464166.00	2026-11-05	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-20T18:14:08.178572Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
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
2ac9b650-b38b-4770-8bfb-1ee6bd9f569f	2026-08-20 13:11	2026-08-20 13:11	2026-08-20 13:11	CSGP	CSGP270319P00035000	put	35.0000	2027-03-19	6.1400	6.0000	6.3000	32.2800	80416.00	30800.00	42236.00	131	6	400	118	3.38983050847458	0.513487364239824	0.513487364239824	false	false	false	true
4b755a9c-f467-4f6b-bdd4-51de03d12786	2026-08-20 13:10	2026-08-20 13:10	2026-08-20 13:10	CSGP	CSGP270319P00035000	put	35.0000	2027-03-19	6.1600	6.0000	6.4000	32.2900	83839.00	0.00	83839.00	136	5	200	118	1.69491525423729	0.515001262727215	0.515001262727215	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
fd33694f-fca6-4e7c-a582-4223afd887f9	2026-08-20 11:55	2026-08-20 11:55	2026-08-20 11:55	SPG	SPG261016P00210000	put	210.0000	2026-10-16	3.2000	3.2000	3.6000	221.4650	101132.00	0.00	101132.00	316	43	316	1133	0.278905560458959	0.236054874837067	0.236054874837067	false	false	false	true
878c12d7-1337-405e-b473-b3e2e53847e5	2026-08-20 11:40	2026-08-20 11:40	2026-08-20 11:40	AGNC	AGNC260911P00010500	put	10.5000	2026-09-11	0.1000	0.0700	0.1000	10.9200	50000.00	50000.00	0.00	5000	1	5001	9402	0.531908104658583	0.252829546308195	0.252829546308195	false	true	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
4521c85c-fb8a-4b23-a61a-ee91950eddff	2026-08-20 11:08	2026-08-20 11:08	2026-08-20 11:08	CSGP	CSGP270319C00045000	call	45.0000	2027-03-19	1.7500	1.7000	1.8000	31.8600	74921.00	1246.00	21875.00	428	7	20684	14624	1.41438730853392	0.527716754517745	0.524668677006807	false	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
d02950b9-b7bd-4524-9bdc-7db4fe3ad2b2	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.2500	0.6000	47.0100	55524.00	55524.00	0.00	1111	59	1118	189	5.91534391534392	0.251876251730196	0.251876251730196	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
4c5e6d80-f706-4d7a-be0c-aad8b41e1bf2	2026-08-20 10:34	2026-08-20 10:34	2026-08-20 10:34	CSGP	CSGP270319C00045000	call	45.0000	2027-03-19	1.7600	1.7500	1.8000	31.8200	10392.00	2672.00	7720.00	59	15	19406	14624	1.32699671772429	0.530995186709554	0.530995186709554	false	false	false	true
271c2fcc-41f9-489b-a202-352dfe711e53	2026-08-20 10:30	2026-08-20 10:30	2026-08-20 10:30	CSGP	CSGP270319C00045000	call	45.0000	2027-03-19	1.7600	1.7500	1.8000	31.8800	12839.00	3564.00	9275.00	73	6	19171	14624	1.3109272428884	0.528954572408575	0.523992723552048	false	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
63f54bd8-1861-412e-828c-749d0cad4fd1	2026-08-20 10:14	2026-08-20 10:14	2026-08-20 10:14	CSGP	CSGP270319C00045000	call	45.0000	2027-03-19	1.7300	1.7000	1.8000	32.1177	101195.00	52850.00	46070.00	586	25	16985	14624	1.16144693654267	0.509798366439815	0.515982468987948	false	false	false	true
8aeaedba-197c-4ded-9cf9-278b5a0c173b	2026-08-20 10:14	2026-08-20 10:14	2026-08-20 10:14	CSGP	CSGP270319C00045000	call	45.0000	2027-03-19	1.7500	1.7500	1.8000	32.1300	61250.00	0.00	61250.00	350	5	16064	14624	1.09846827133479	0.515569134183374	0.515569134183374	false	false	false	true
0818cff2-1c1a-433d-b585-e42e14650c7c	2026-08-20 10:13	2026-08-20 10:13	2026-08-20 10:13	CSGP	CSGP270319C00045000	call	45.0000	2027-03-19	1.7500	1.7500	1.9500	32.1350	59500.00	0.00	59500.00	340	5	15464	14624	1.0574398249453	0.5154011442417	0.5154011442417	false	false	false	true
aea4a579-3e3c-4aaa-b8a8-0513fae985a2	2026-08-20 10:13	2026-08-20 10:13	2026-08-20 10:13	CSGP	CSGP270319C00045000	call	45.0000	2027-03-19	1.7500	1.7000	1.8000	32.1500	12075.00	8925.00	0.00	69	6	14422	14624	0.986187089715536	0.514897286400434	0.514897286400434	false	false	false	true
75da75bc-0e32-466a-a609-9abb4ce70817	2026-08-20 10:13	2026-08-20 10:13	2026-08-20 10:13	CSGP	CSGP270319C00045000	call	45.0000	2027-03-19	1.7500	1.7000	1.9500	32.1500	71400.00	0.00	71225.00	408	5	14830	14624	1.01408643326039	0.514897286400434	0.514897286400434	false	false	false	true
febe589a-3a9a-433d-bca2-3421e36f9c1c	2026-08-20 10:13	2026-08-20 10:13	2026-08-20 10:13	CSGP	CSGP270319C00045000	call	45.0000	2027-03-19	1.7200	1.7000	1.8000	32.1400	108535.00	41825.00	64260.00	631	23	14225	14624	0.972716083150985	0.509054584939513	0.515233172972567	false	false	false	true
2fdf98b5-a04f-49ec-b6d4-030db987d70f	2026-08-20 10:13	2026-08-20 10:12	2026-08-20 10:12	CSGP	CSGP270319C00045000	call	45.0000	2027-03-19	1.7500	1.7000	1.8000	32.0500	21875.00	0.00	21350.00	125	5	12735	14624	0.870828774617068	0.518259523223819	0.518259523223819	false	false	false	true
4d29eb14-8cdd-4d27-b0c1-03602a6d9bce	2026-08-20 10:11	2026-08-20 10:11	2026-08-20 10:11	CSGP	CSGP270319C00045000	call	45.0000	2027-03-19	1.7000	1.7000	1.7500	32.1400	61710.00	0.00	61710.00	363	18	9845	14624	0.673208424507659	0.509054584939513	0.509054584939513	false	false	false	true
cf8362b4-ab9f-4489-89ec-8d089590e4f1	2026-08-20 10:11	2026-08-20 10:11	2026-08-20 10:11	CSGP	CSGP270319C00045000	call	45.0000	2027-03-19	1.7500	1.7000	1.7500	32.1300	66500.00	16100.00	0.00	380	16	9311	14624	0.636693107221007	0.515569134183374	0.515569134183374	false	false	false	true
fcbe6b70-160e-4ba6-8f7e-67813f6c8634	2026-08-20 10:11	2026-08-20 10:10	2026-08-20 10:10	CSGP	CSGP270319C00045000	call	45.0000	2027-03-19	1.7500	1.7500	1.8000	32.1700	33600.00	0.00	33600.00	192	9	8921	14624	0.610024617067834	0.514225736760325	0.514225736760325	false	false	false	true