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

7a6410ff-7a3d-416c-a544-57ff89c14cae	2026-08-20 10:07	2026-08-20 10:06	2026-08-20 10:06	CSGP	CSGP270319C00045000	call	45.0000	2027-03-19	1.9500	1.9000	2.1500	32.4300	95940.00	29250.00	23400.00	492	16	1089	14624	0.0744666301969365	0.529539961788704	0.529539961788704	true	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Real Estate	12771827974.00	2026-10-27	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-20T14:18:56.683244Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
96062a60-2d58-4fa0-9361-edcb67984f8c	2026-08-20 10:06	2026-08-20 10:06	2026-08-20 10:06	CSGP	CSGP270319C00045000	call	45.0000	2027-03-19	1.9500	1.9000	1.9500	32.4800	76830.00	14040.00	0.00	394	16	525	14624	0.0358998905908096	0.527824536258044	0.527824536258044	false	false	false	true	false
55af8fa5-5cbb-46ae-99a4-bb2c9f424a75	2026-08-20 10:06	2026-08-20 10:06	2026-08-20 10:06	CSGP	CSGP270319C00045000	call	45.0000	2027-03-19	2.0500	1.8500	2.0500	32.5300	25830.00	10250.00	0.00	126	9	131	14624	0.00895787746170678	0.537855011257008	0.537855011257008	false	false	false	true	false
3787c05b-93fc-436b-8298-06290241e007	2026-08-20 10:02	2026-08-20 10:02	2026-08-20 10:02	GEO	GEO270115C00037000	call	37.0000	2027-01-15	2.3500	1.7000	2.3500	31.3500	58750.00	58750.00	0.00	250	15	500	961	0.520291363163371	0.517859395543553	0.517859395543553	false	false	false	true	false
c49f435a-0e59-49eb-a648-722855472b01	2026-08-20 10:00	2026-08-20 10:00	2026-08-20 10:00	BEKE	BEKE260821C00016500	call	16.5000	2026-08-21	0.8000	0.7000	0.8000	17.0200	24000.00	24000.00	0.00	300	15	301	0	0	1.41809788667389	1.41809788667389	false	false	false	true	false
94d81fbb-7efe-41a5-8a50-9bf5bf016f8d	2026-08-20 09:51	2026-08-20 09:51	2026-08-20 09:51	AGNC	AGNC261016P00012000	put	12.0000	2026-10-16	1.1800	0.8800	1.3800	11.0700	449343.00	449107.00	236.00	3808	10	3825	0	0	0.373121161680427	0.366822370741853	false	false	false	true	false
689ed5a1-de75-4ac9-b4b3-0d18e7d36ac7	2026-08-20 09:42	2026-08-20 09:42	2026-08-20 09:42	AGNC	AGNC261016C00011000	call	11.0000	2026-10-16	0.5100	0.1600	0.5500	11.0700	35101.00	30040.00	5061.00	682	22	6331	0	0	0.237436726157826	0.247418380804679	true	false	false	true	false
669a0f64-4e8d-4eb9-80cc-a297c9b0c9b7	2026-08-20 09:42	2026-08-20 09:42	2026-08-20 09:42	AGNC	AGNC261016C00011000	call	11.0000	2026-10-16	0.4600	0.1700	0.7000	11.0650	32395.00	6042.00	26353.00	702	12	5397	0	0	0.266511005503409	0.266511005503409	true	false	false	true	false
80b5f0cd-d73c-4684-9444-028760b897fb	2026-08-20 09:42	2026-08-20 09:42	2026-08-20 09:42	OPEN	OPEN260911C00003500	call	3.5000	2026-09-11	0.2400	0.2400	0.2900	3.4900	12000.00	0.00	12000.00	500	5	3503	2733	1.28174167581412	0.705796732626929	0.705796732626929	false	false	false	true	false
5411c56f-c404-4d67-8e62-a678375b91e7	2026-08-20 09:42	2026-08-20 09:42	2026-08-20 09:42	AGNC	AGNC261016C00010000	call	10.0000	2026-10-16	1.1800	0.3400	1.5500	11.0700	20785.00	4522.00	16263.00	176	7	5088	0	0	0.236500048425441	0.268997426881726	true	false	false	true	false
0ad29850-e390-40e6-9ec7-ac89da5edd7e	2026-08-20 09:42	2026-08-20 09:42	2026-08-20 09:42	AGNC	AGNC261218C00010000	call	10.0000	2026-12-18	1.1300	1.0900	1.1300	11.0700	15593.00	15593.00	0.00	138	17	1403	6698	0.209465512093162	0.122639120176442	0.122639120176442	true	false	false	true	false
46df30f3-aa8a-4825-8d6a-f951a3cc85a9	2026-08-20 09:42	2026-08-20 09:42	2026-08-20 09:42	AGNC	AGNC261218C00010000	call	10.0000	2026-12-18	1.1300	1.0900	1.1300	11.0650	11300.00	11300.00	0.00	100	5	1265	6698	0.188862346969245	0.122639120176442	0.122639120176442	true	false	false	true	false
b1863075-903a-42ae-a1f1-69199d19d958	2026-08-20 09:42	2026-08-20 09:41	2026-08-20 09:41	OPEN	OPEN260911C00003500	call	3.5000	2026-09-11	0.2400	0.2300	0.2900	3.4900	12000.00	2640.00	9360.00	500	8	3003	2733	1.09879253567508	0.705796732626929	0.705796732626929	false	false	false	true	false
ae6f40be-5354-421f-89ba-9e054c23fe0c	2026-08-20 09:42	2026-08-20 09:41	2026-08-20 09:41	AGNC	AGNC261218C00010000	call	10.0000	2026-12-18	1.1400	0.9200	1.1800	11.0650	64946.00	64605.00	341.00	569	61	1065	6698	0.159002687369364	0.122639120176442	0.122639120176442	true	false	false	true	false
3b555414-f058-490d-9796-02bc76dd00c1	2026-08-20 09:42	2026-08-20 09:41	2026-08-20 09:41	AGNC	AGNC261016C00010000	call	10.0000	2026-10-16	1.1900	1.1400	1.5400	11.0650	83186.00	28548.00	42738.00	699	45	4307	0	0	0.252650006863596	0.217219868706236	true	false	false	true	false
88b5cffc-3f54-468e-9829-294d65daa05a	2026-08-20 09:41	2026-08-20 09:41	2026-08-20 09:41	OPEN	OPEN260911C00003500	call	3.5000	2026-09-11	0.2400	0.2400	0.2900	3.5060	12072.00	0.00	12072.00	503	11	2503	2733	0.915843395536041	0.680561417318825	0.680561417318825	false	false	false	true	false
c6c5afea-1b1f-426a-89d7-aea93fd45fa6	2026-08-20 09:40	2026-08-20 09:40	2026-08-20 09:40	AGNC	AGNC261218C00010000	call	10.0000	2026-12-18	1.1200	0.9100	1.1200	11.0500	55552.00	55552.00	0.00	496	23	496	6698	0.0740519558077038	0.074343086030269	0.074343086030269	true	false	false	true	false
0148d7f0-f6e9-4b9b-9f7d-b0b455279625	2026-08-20 09:40	2026-08-20 09:40	2026-08-20 09:40	AGNC	AGNC261016C00010000	call	10.0000	2026-10-16	1.1400	1.1400	1.9500	11.0500	57000.00	0.00	57000.00	500	5	1997	0	0	0.207262221710243	0.193855644342671	true	false	false	true	false
93a42978-2206-444c-adc7-9fbc46d44ee4	2026-08-20 09:40	2026-08-20 09:40	2026-08-20 09:40	OPEN	OPEN260911C00003500	call	3.5000	2026-09-11	0.2400	0.2300	0.2900	3.5001	15552.00	0.00	9792.00	648	12	1300	2733	0.475667764361507	0.689912877724894	0.689912877724894	false	false	false	true	false
797373fa-0471-4845-9aec-378729fb8556	2026-08-20 09:40	2026-08-20 09:40	2026-08-20 09:40	OPEN	OPEN260911C00003500	call	3.5000	2026-09-11	0.2500	0.2100	0.4700	3.4950	12500.00	9125.00	3375.00	500	5	500	2733	0.182949140139041	0.719387473166968	0.727290336340938	false	false	false	true	false
5c0c41a5-31ac-4914-b0e4-6f4817ee1135	2026-08-19 15:51	2026-08-19 15:51	2026-08-19 15:51	CBRE	CBRE260918C00160000	call	160.0000	2026-09-18	3.3000	3.0000	3.3000	154.5900	23760.00	9900.00	0.00	72	5	117	649	0.180277349768875	0.301044335805268	0.301044335805268	false	false	false	true	false
ef73aa76-9d5a-414a-b064-bfce7ac9e104	2026-08-19 15:50	2026-08-19 15:50	2026-08-19 15:50	CBRE	CBRE260821C00150000	call	150.0000	2026-08-21	5.4000	5.4000	5.8000	154.7300	31320.00	0.00	13500.00	58	5	468	2677	0.174822562570041	0.504033343150336	0.504033343150336	false	false	false	true	false
a520ea24-7c81-4df3-aadd-63fc15f8f799	2026-08-19 15:49	2026-08-19 15:48	2026-08-19 15:48	FRMI	FRMI270115C00012500	call	12.5000	2027-01-15	0.5500	0.4500	0.5500	5.7850	14132.00	14132.00	0.00	257	29	3417	4251	0.803810868031052	1.21580153730247	1.21580153730247	false	false	false	true	false
8485f920-4811-4dd9-83a0-8a61a214ca66	2026-08-19 15:48	2026-08-19 15:48	2026-08-19 15:48	FRMI	FRMI261218C00015000	call	15.0000	2026-12-18	0.3000	0.2500	0.3000	5.7750	111239.00	111239.00	0.00	3709	40	3710	7480	0.495989304812834	1.27088858029609	1.26677948296697	false	false	false	true	false
fc404c40-8698-445d-9555-aaa877b19618	2026-08-19 15:43	2026-08-19 15:43	2026-08-19 15:43	CXW	CXW261120P00032000	put	32.0000	2026-11-20	3.1000	3.1000	3.3000	31.4350	75640.00	0.00	75640.00	244	16	244	2	122	0.468920188918314	0.468920188918314	false	false	false	true	false
2651164b-43b4-4358-ade5-5d86c03f0d03	2026-08-19 15:41	2026-08-19 15:41	2026-08-19 15:41	CCI	CCI261016P00072500	put	72.5000	2026-10-16	2.6500	2.6500	2.9000	74.7800	30750.00	0.00	30750.00	116	21	119	126	0.944444444444444	0.330689021055191	0.330689021055191	false	false	false	true	false
ac0451ed-652e-4af5-9491-de24b59b7c2b	2026-08-19 15:37	2026-08-19 15:36	2026-08-19 15:36	ARE	ARE260918C00052500	call	52.5000	2026-09-18	1.4500	1.4000	1.4500	50.6400	15948.00	15948.00	0.00	110	26	192	80	2.4	0.3729402689747	0.3729402689747	false	false	false	true	false
25f5de8d-1ea2-4a68-850e-fdbc9e70c932	2026-08-19 15:37	2026-08-19 15:36	2026-08-19 15:36	ARE	ARE261016C00052500	call	52.5000	2026-10-16	2.1800	2.1500	2.2500	50.6400	45461.00	23301.00	22160.00	209	29	323	696	0.464080459770115	0.355791041861623	0.355791041861623	false	false	false	true	false
8a8e9373-33dc-45ff-9f24-1e0272f85d02	2026-08-19 15:33	2026-08-19 15:33	2026-08-19 15:33	FRMI	FRMI260918P00005000	put	5.0000	2026-09-18	0.2500	0.2500	0.3500	5.7150	30800.00	0.00	30800.00	1232	10	3775	857	4.4049008168028	0.883373062601797	0.883373062601797	false	false	false	true	false
6641d187-a951-49f3-88b8-01e94ef312c3	2026-08-19 15:29	2026-08-19 15:29	2026-08-19 15:29	CBRE	CBRE260918C00150000	call	150.0000	2026-09-18	8.2000	7.9000	8.3000	154.1450	33620.00	25420.00	0.00	41	18	173	8746	0.0197804710724903	0.322327280016385	0.322327280016385	false	false	false	true	false
b3a48090-326a-40db-a4ce-d05d48c3756a	2026-08-19 15:17	2026-08-19 15:17	2026-08-19 15:17	OPEN	OPEN260828P00004000	put	4.0000	2026-08-28	0.5000	0.4900	0.5200	3.5400	10800.00	0.00	10800.00	216	5	901	1416	0.636299435028249	0.81160733592924	0.81160733592924	false	false	false	true	false
7daa24c0-dac7-4499-bc31-96c19155fab2	2026-08-19 15:06	2026-08-19 15:06	2026-08-19 15:06	CSGP	CSGP260918P00030000	put	30.0000	2026-09-18	0.7000	0.6000	0.7000	33.6650	17278.00	17278.00	0.00	247	42	909	4651	0.195441840464416	0.566604021619459	0.566604021619459	true	false	false	true	false
12b1d6b3-7c88-4145-8068-4aab6ea7af6d	2026-08-19 14:17	2026-08-19 14:17	2026-08-19 14:17	CSGP	CSGP261016C00040000	call	40.0000	2026-10-16	0.9000	0.8500	0.9500	33.7700	26730.00	4140.00	22590.00	297	13	310	541	0.573012939001848	0.512822579540857	0.512822579540857	false	false	false	true	false
e99accb3-c8c9-42ab-8566-0bef613d267e	2026-08-19 13:58	2026-08-19 13:58	2026-08-19 13:58	ARE	ARE261016C00050000	call	50.0000	2026-10-16	2.7000	2.5000	2.8500	49.6900	14040.00	2970.00	11070.00	52	7	85	662	0.128398791540786	0.342386952536358	0.342386952536358	false	false	false	true	false
1562db2a-a7b9-4f4f-b163-cb711d0264a0	2026-08-19 13:55	2026-08-19 13:55	2026-08-19 13:55	ARE	ARE270115P00037500	put	37.5000	2027-01-15	1.1500	1.1500	1.4500	49.5050	11500.00	0.00	11500.00	100	5	145	133	1.09022556390977	0.476534388135424	0.476534388135424	false	false	false	true	false
221c0985-341d-4918-ba8d-9c86b632535d	2026-08-19 13:15	2026-08-19 13:15	2026-08-19 13:15	FRMI	FRMI280121C00020000	call	20.0000	2028-01-21	1.1300	1.0500	1.1500	5.6800	11282.00	11282.00	0.00	100	6	304	2832	0.107344632768362	1.08190759331043	1.08190759331043	false	false	false	true	false
89526c72-dd01-495f-86c6-b7de557f377b	2026-08-19 12:46	2026-08-19 12:46	2026-08-19 12:46	CSGP	CSGP260918P00030000	put	30.0000	2026-09-18	0.7500	0.6500	0.7500	33.4850	17232.00	17232.00	0.00	230	28	512	4651	0.110083852934853	0.570664816282012	0.570664816282012	true	false	false	true	false
312db73a-833e-4339-81f7-10c9f36d7422	2026-08-19 12:38	2026-08-19 12:38	2026-08-19 12:38	ARE	ARE260918C00050000	call	50.0000	2026-09-18	1.8000	1.7000	1.9000	49.1700	10980.00	9360.00	1440.00	61	18	282	319	0.884012539184953	0.375496089994961	0.374657040272514	false	false	false	true	false
8e7f3ce7-43a5-451a-92f8-ca1729a7251e	2026-08-19 12:10	2026-08-19 12:09	2026-08-19 12:09	SUI	SUI260918C00125000	call	125.0000	2026-09-18	1.7500	0.5000	2.0500	121.8600	10500.00	5600.00	4900.00	60	6	110	1425	0.0771929824561404	0.207365073679726	0.207365073679726	false	false	false	true	false
dc34bb71-5186-48f1-9fe2-9911304ea629	2026-08-19 12:06	2026-08-19 12:05	2026-08-19 12:05	SUI	SUI260918P00120000	put	120.0000	2026-09-18	1.9500	0.7500	2.3500	121.8350	58695.00	54405.00	4290.00	301	14	301	175	1.72	0.211643257563254	0.211643257563254	false	false	false	true	false
6638a0a2-ea71-478e-bb27-b64f5c5f7c6e	2026-08-19 12:03	2026-08-19 12:03	2026-08-19 12:03	AMT	AMT261218C00175000	call	175.0000	2026-12-18	10.8000	10.8000	11.8000	173.4600	78840.00	0.00	78840.00	73	8	73	86	0.848837209302326	0.262590459932596	0.262590459932596	false	false	false	true	false
a26062a9-86b3-4977-aa89-663f1c2364fe	2026-08-19 12:03	2026-08-19 12:02	2026-08-19 12:02	SUI	SUI260918P00125000	put	125.0000	2026-09-18	4.4000	4.3000	5.1000	122.0100	19800.00	9680.00	10120.00	45	11	46	15	3.06666666666667	0.213341750143056	0.20679572563684	false	false	false	true	false
3ecdd3ff-e688-4dd4-874d-17a9f303c783	2026-08-19 11:57	2026-08-19 11:57	2026-08-19 11:57	NLY	NLY270115C00022000	call	22.0000	2027-01-15	2.0200	1.8700	2.0200	23.7550	25855.00	25855.00	0.00	128	10	251	5122	0.0490042951971886	0.128516375090521	0.128516375090521	false	false	false	true	false
ff9eec29-94a6-47d9-9043-3d93f531a645	2026-08-19 11:44	2026-08-19 11:44	2026-08-19 11:44	GEO	GEO260918C00030000	call	30.0000	2026-09-18	2.1700	1.7500	2.2000	30.7900	26070.00	26070.00	0.00	120	11	268	2597	0.103195995379284	0.496722020335047	0.48196603863336	false	false	false	true	false
dd101240-b54b-4b83-9f0d-12291b7ec7f2	2026-08-19 11:35	2026-08-19 11:35	2026-08-19 11:35	OPEN	OPEN260828C00003500	call	3.5000	2026-08-28	0.2400	0.2200	0.2400	3.6137	12000.00	12000.00	0.00	500	23	3145	5540	0.567689530685921	0.787889007342983	0.787889007342983	false	false	false	true	false
cb2e50ba-b7ea-41ff-9714-ca0488fa05cc	2026-08-19 11:35	2026-08-19 11:35	2026-08-19 11:35	OPEN	OPEN260828C00003500	call	3.5000	2026-08-28	0.2400	0.2200	0.2400	3.6150	12000.00	12000.00	0.00	500	17	2645	5540	0.477436823104693	0.784074559869587	0.784074559869587	false	false	false	true	false
5c89cf7c-8e60-42ae-8e29-63c6fa97969c	2026-08-19 11:21	2026-08-19 11:21	2026-08-19 11:21	GEO	GEO260918C00030000	call	30.0000	2026-09-18	1.8600	1.8500	2.2000	30.5800	22301.00	0.00	22301.00	120	8	148	2597	0.0569888332691567	0.424688830892045	0.439682517626272	false	false	false	true	false
2c2edc0c-24a4-4aa2-a197-9f1b1db48aba	2026-08-19 11:17	2026-08-19 11:17	2026-08-19 11:17	VICI	VICI270617P00027500	put	27.5000	2027-06-17	3.1000	2.9500	3.1000	26.1850	12090.00	12090.00	0.00	39	10	287	3642	0.0788028555738605	0.302050947635518	0.302050947635518	false	false	false	true	false
94ea7d7a-b942-4adf-ba71-15d17d9a8cb2	2026-08-19 11:05	2026-08-19 11:04	2026-08-19 11:04	IRM	IRM260821C00122000	call	122.0000	2026-08-21	1.2500	0.9000	1.2500	121.4100	20250.00	20250.00	0.00	162	31	163	1	163	0.42177048672662	0.42177048672662	false	false	false	true	false
06b3abd6-afa8-44ae-a0b8-213852b6e414	2026-08-19 11:04	2026-08-19 11:04	2026-08-19 11:04	ABR	ABR270115C00006000	call	6.0000	2027-01-15	0.3000	0.2500	0.3000	5.2500	22500.00	22500.00	0.00	750	29	761	5306	0.143422540520166	0.40126662692557	0.40126662692557	false	false	false	true	false