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

44e715ad-feff-4a36-a196-de9324e87f01	2026-08-19 11:04	2026-08-19 11:04	2026-08-19 11:04	ABR	ABR270115C00005000	call	5.0000	2027-01-15	0.7000	0.6500	0.7500	5.2500	16844.00	16774.00	0.00	241	21	842	1177	0.715378079864061	0.401273636390924	0.401273636390924	true	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Real Estate	867494900.00	2026-10-30	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-19T15:17:48.302096Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
220ae0c7-340c-4a7e-bd5e-28b5c4bf61e6	2026-08-19 11:02	2026-08-19 11:02	2026-08-19 11:02	HHH	HHH261016C00075000	call	75.0000	2026-10-16	1.1000	1.1000	2.5500	67.6800	16500.00	0.00	11000.00	150	7	150	874	0.17162471395881	0.31145304702035	0.31145304702035	false	false	false	true	false
4418ce8e-b649-4168-a83d-f80303781636	2026-08-19 11:01	2026-08-19 11:01	2026-08-19 11:01	CSGP	CSGP270319C00045000	call	45.0000	2027-03-19	2.5000	2.5000	2.5500	33.6100	38750.00	0.00	4500.00	155	16	3043	11689	0.260330224997861	0.548822530128855	0.548822530128855	false	false	false	true	false
858f5ef3-c8dc-4420-873c-4f2eabe55eea	2026-08-19 11:01	2026-08-19 11:01	2026-08-19 11:01	CSGP	CSGP270319C00045000	call	45.0000	2027-03-19	2.4000	2.2000	2.4000	33.5800	84795.00	77040.00	7755.00	354	19	2888	11689	0.247069894772863	0.539094450692146	0.533662958696721	false	false	false	true	false
92ec51c6-dc66-427d-ab57-356fb4c54468	2026-08-19 11:01	2026-08-19 11:01	2026-08-19 11:01	CSGP	CSGP270319C00045000	call	45.0000	2027-03-19	2.3000	2.3000	2.4000	33.5400	27600.00	0.00	3450.00	120	8	2534	11689	0.21678501154932	0.529607948916756	0.529607948916756	false	false	false	true	false
6e0f4de8-e8f3-4313-bbef-38f6178db3bf	2026-08-19 11:01	2026-08-19 11:01	2026-08-19 11:01	CSGP	CSGP270319C00045000	call	45.0000	2027-03-19	2.3800	2.2500	2.4500	33.5200	78810.00	1680.00	30405.00	331	26	2404	11689	0.205663444263838	0.541217036743902	0.535773444198979	false	false	false	true	false
86092fae-a889-485c-bfa0-c22fc969f284	2026-08-19 11:01	2026-08-19 11:01	2026-08-19 11:01	CSGP	CSGP270319C00045000	call	45.0000	2027-03-19	2.3000	2.3000	2.3500	33.5350	17250.00	0.00	6900.00	75	5	2073	11689	0.177346222944649	0.52978284604177	0.52978284604177	false	false	false	true	false
b4a39b01-b76c-470d-92df-9dbfb92e825f	2026-08-19 11:01	2026-08-19 11:00	2026-08-19 11:00	CSGP	CSGP270319C00045000	call	45.0000	2027-03-19	2.3500	2.2000	2.4000	33.5350	68095.00	1880.00	12635.00	290	24	1998	11689	0.170929934126101	0.535245593257358	0.52978284604177	false	false	false	true	false
fd2261a5-3954-4938-b98f-d91a5717ba0d	2026-08-19 11:00	2026-08-19 11:00	2026-08-19 11:00	CSGP	CSGP270319C00045000	call	45.0000	2027-03-19	2.2500	2.2500	2.3000	33.5100	14625.00	0.00	8775.00	65	5	1705	11689	0.145863632474976	0.525166523308337	0.525166523308337	false	false	false	true	false
3ec08cc4-200b-4cbd-8860-16cbb36f0c40	2026-08-19 11:00	2026-08-19 11:00	2026-08-19 11:00	CSGP	CSGP270319C00045000	call	45.0000	2027-03-19	2.3000	2.3000	2.3500	33.4900	27600.00	0.00	9200.00	120	6	1640	11689	0.140302848832235	0.531357680680273	0.531357680680273	false	false	false	true	false
972ff7ad-596d-4cdc-9825-fc97601c9bed	2026-08-19 11:00	2026-08-19 11:00	2026-08-19 11:00	CSGP	CSGP270319C00045000	call	45.0000	2027-03-19	2.2000	2.2000	2.2500	33.4300	32120.00	0.00	7920.00	146	17	1520	11689	0.13003678672256	0.522420014943127	0.522420014943127	false	false	false	true	false
9ddf6f9a-a9fc-4867-ba7b-64e59c5f1b87	2026-08-19 11:00	2026-08-19 11:00	2026-08-19 11:00	CSGP	CSGP270319C00045000	call	45.0000	2027-03-19	2.2500	2.2500	2.3000	33.4400	43650.00	0.00	5850.00	194	14	1246	11689	0.106595944905467	0.527603602499942	0.527603602499942	false	false	false	true	false
60236bf8-b758-4181-9e52-2583eecba084	2026-08-19 11:00	2026-08-19 11:00	2026-08-19 11:00	CSGP	CSGP270319C00045000	call	45.0000	2027-03-19	2.2000	2.2000	2.2500	33.4400	28160.00	0.00	15840.00	128	13	1374	11689	0.117546411155787	0.522073679249988	0.522073679249988	false	false	false	true	false
24a9ede1-fb22-4ed5-90c7-86fd51ec0cb0	2026-08-19 11:00	2026-08-19 11:00	2026-08-19 11:00	CSGP	CSGP270319C00045000	call	45.0000	2027-03-19	2.2000	2.2000	2.3500	33.4400	15400.00	0.00	4400.00	70	8	1052	11689	0.0899991444948242	0.522073679249988	0.522073679249988	false	false	false	true	false
9cab2999-49b0-4bf1-ab47-5940415c8156	2026-08-19 11:00	2026-08-19 11:00	2026-08-19 11:00	CSGP	CSGP270319C00045000	call	45.0000	2027-03-19	2.2000	2.2000	2.3000	33.3775	45980.00	0.00	4180.00	209	11	979	11689	0.0837539567114381	0.52423938324187	0.52423938324187	false	false	false	true	false
ce3bb6e2-41bc-4db3-b3d9-37fa51e26169	2026-08-19 11:00	2026-08-19 10:59	2026-08-19 10:59	CSGP	CSGP270319C00045000	call	45.0000	2027-03-19	2.2000	2.0500	2.3000	33.3700	17605.00	3085.00	14520.00	80	8	770	11689	0.0658738985370862	0.524499445239267	0.524499445239267	false	false	false	true	false
d0710229-c20c-4853-9e34-80d3881d6693	2026-08-19 10:59	2026-08-19 10:59	2026-08-19 10:59	CSGP	CSGP270319C00045000	call	45.0000	2027-03-19	2.3000	2.2500	2.3500	33.3800	80855.00	0.00	9325.00	352	20	675	11689	0.0577465993669262	0.535213089682498	0.529695171173916	false	false	false	true	false
9a1e787f-348c-42ac-aea8-23d11039ac2b	2026-08-19 10:59	2026-08-19 10:59	2026-08-19 10:59	CSGP	CSGP270319C00045000	call	45.0000	2027-03-19	2.2500	2.2500	2.3500	33.3800	15750.00	0.00	9000.00	70	7	323	11689	0.0276328171785439	0.529695171173916	0.529695171173916	false	false	false	true	false
040715cc-659f-4f5e-813c-40c26f93717d	2026-08-19 10:59	2026-08-19 10:59	2026-08-19 10:59	CSGP	CSGP270319C00045000	call	45.0000	2027-03-19	2.2000	2.1500	2.4000	33.3700	52800.00	3300.00	6600.00	240	16	248	11689	0.0212165283599966	0.524499445239267	0.524499445239267	false	false	false	true	false
cb0651ea-ced4-4ba4-bdfb-772a79bd1df7	2026-08-19 10:59	2026-08-19 10:59	2026-08-19 10:59	DLR	DLR260918P00190000	put	190.0000	2026-09-18	5.8000	5.3000	5.8000	189.9600	52198.00	52198.00	0.00	90	20	94	108	0.87037037037037	0.279898294961754	0.279898294961754	false	false	false	true	false
79e8a057-fd44-4731-be8b-44e81eab6e0c	2026-08-19 10:58	2026-08-19 10:58	2026-08-19 10:58	PLD	PLD260918C00140000	call	140.0000	2026-09-18	4.0000	4.0000	4.4000	140.9800	57200.00	0.00	28000.00	143	61	748	616	1.21428571428571	0.202225493845643	0.202225493845643	true	false	false	true	false
a8270651-aaca-4f82-8e3e-88311beffcbe	2026-08-19 10:58	2026-08-19 10:57	2026-08-19 10:57	PLD	PLD260918C00140000	call	140.0000	2026-09-18	4.0000	3.9000	4.4000	141.0400	80000.00	22800.00	35600.00	200	99	603	616	0.978896103896104	0.200012646205328	0.200012646205328	true	false	false	true	false
6706bdb9-e0ad-4ad4-80bb-ddf33d18516a	2026-08-19 10:54	2026-08-19 10:54	2026-08-19 10:54	VICI	VICI280121P00025000	put	25.0000	2028-01-21	2.5000	2.5000	2.6500	26.1650	20003.00	0.00	20003.00	80	22	141	1789	0.0788149804359978	0.311208506581262	0.311208506581262	false	false	false	true	false
77f88eba-d7ef-451d-ae7f-db4f5eb385b3	2026-08-19 10:50	2026-08-19 10:50	2026-08-19 10:50	OPEN	OPEN260911C00003500	call	3.5000	2026-09-11	0.3300	0.3000	0.3300	3.6050	16500.00	16500.00	0.00	500	6	3041	247	12.3117408906883	0.776989580686606	0.759780499276991	false	false	false	true	false
a00b78ac-5f5f-4b77-b5ae-b8ea26c190e1	2026-08-19 10:50	2026-08-19 10:50	2026-08-19 10:50	OPEN	OPEN260911C00003500	call	3.5000	2026-09-11	0.3300	0.3200	0.3300	3.6000	16500.00	16500.00	0.00	500	14	2541	247	10.2874493927126	0.768409562794009	0.768409562794009	false	false	false	true	false
1f17cfa5-8c97-479b-bea3-83d9165459bb	2026-08-19 10:46	2026-08-19 10:46	2026-08-19 10:46	OPEN	OPEN260911C00003500	call	3.5000	2026-09-11	0.3100	0.2600	0.3100	3.5601	15500.00	15500.00	0.00	500	14	541	247	2.19028340080972	0.770345856421325	0.778466447679146	false	false	false	true	false
af9a1a81-ddb1-4bd8-8191-71b00d915cce	2026-08-19 10:32	2026-08-19 10:32	2026-08-19 10:32	IRM	IRM260918P00120000	put	120.0000	2026-09-18	4.4000	3.6000	4.7000	120.7600	374000.00	374000.00	0.00	850	1	853	156	5.46794871794872	0.359915155632997	0.359915155632997	false	true	false	true	true
43ff2a39-9d77-4da3-b49e-4ee2ab76cfa5	2026-08-19 10:26	2026-08-19 10:26	2026-08-19 10:26	FRMI	FRMI270115C00010000	call	10.0000	2027-01-15	0.6500	0.6000	0.7000	5.4550	43875.00	38415.00	5460.00	675	6	21836	49428	0.441773893339807	1.17462821300623	1.17462821300623	false	false	false	true	false
cea6a69f-cb9e-4d3b-98c1-41b73698b84b	2026-08-19 10:26	2026-08-19 10:26	2026-08-19 10:26	PLD	PLD260918C00140000	call	140.0000	2026-09-18	4.3000	4.0000	4.6000	141.4000	86000.00	1290.00	76110.00	200	20	202	616	0.327922077922078	0.202858749090036	0.205547527755649	true	false	false	true	false
82d7fa37-e498-4c4c-b5e1-109218b85cb7	2026-08-19 09:58	2026-08-19 09:58	2026-08-19 09:58	OPEN	OPEN260821C00003500	call	3.5000	2026-08-21	0.0900	0.0800	0.0900	3.5000	15543.00	15543.00	0.00	1727	6	5306	12709	0.417499409867023	0.867482522888655	0.867482522888655	true	false	false	true	false
a42ff167-7b0a-4da3-98a3-c9da45824c6b	2026-08-19 09:51	2026-08-19 09:51	2026-08-19 09:51	FRMI	FRMI260918P00005000	put	5.0000	2026-09-18	0.3500	0.3000	0.3500	5.5250	28490.00	28490.00	0.00	814	7	1794	857	2.09334889148191	0.97014301326855	0.97014301326855	false	false	false	true	false
c08b543a-8360-4291-bf39-dd600da7df50	2026-08-19 09:49	2026-08-19 09:49	2026-08-19 09:49	FRMI	FRMI270115C00010000	call	10.0000	2027-01-15	0.7000	0.6000	0.7500	5.5450	962286.00	959626.00	0.00	13756	98	20054	49428	0.405721453427207	1.18907807641185	1.18907807641185	false	false	false	true	false
0612a684-0dca-4ab4-ae12-95389588ad4c	2026-08-19 09:48	2026-08-19 09:48	2026-08-19 09:48	FRMI	FRMI270115C00010000	call	10.0000	2027-01-15	0.6500	0.6000	0.7000	5.5275	399136.00	395762.00	3374.00	6144	60	6198	49428	0.125394513231367	1.16570242094966	1.15544113348618	false	false	false	true	false
768bdd91-c97d-49b7-9ffa-f44de3b38f68	2026-08-19 09:39	2026-08-19 09:39	2026-08-19 09:39	OPEN	OPEN270219C00006000	call	6.0000	2027-02-19	0.4300	0.3500	0.4300	3.5400	12780.00	12780.00	0.00	300	10	302	938	0.321961620469083	0.994127172891679	0.961920916764973	false	false	false	true	false
b63bdaea-5a5a-405b-b29d-f265c10e971a	2026-08-19 09:33	2026-08-19 09:33	2026-08-19 09:33	BEKE	BEKE280121C00015000	call	15.0000	2028-01-21	4.7500	4.7000	5.1000	17.1700	18994.00	0.00	18994.00	40	8	90	211	0.42654028436019	0.409126161978137	0.409126161978137	false	false	false	true	false
9f885fae-3ab7-4bea-94ae-fccbccde96eb	2026-08-18 15:36	2026-08-18 15:36	2026-08-18 15:36	FRMI	FRMI260821C00005500	call	5.5000	2026-08-21	0.4000	0.3500	0.4000	5.7850	19995.00	19995.00	0.00	500	56	516	65	7.93846153846154	1.14067856851862	1.12110954938917	false	false	false	true	false
022edca1-9521-4d94-9c9f-7edb3b5010c8	2026-08-18 15:35	2026-08-18 15:34	2026-08-18 15:34	OPEN	OPEN261016C00004000	call	4.0000	2026-10-16	0.2500	0.2400	0.2500	3.4170	12500.00	12500.00	0.00	500	19	1958	4653	0.42080378250591	0.81178377486437	0.81178377486437	true	false	false	true	false
b91b4fdb-c2bb-4c7e-a621-7fd00a3be655	2026-08-18 15:31	2026-08-18 15:31	2026-08-18 15:31	CCI	CCI270115C00075000	call	75.0000	2027-01-15	5.3000	5.0000	5.7000	74.3250	24380.00	19080.00	5300.00	46	8	59	122	0.483606557377049	0.265852204084057	0.265852204084057	false	false	false	true	false
82515ab6-4b88-4859-b7e7-d7ebd2027eec	2026-08-18 15:31	2026-08-18 15:31	2026-08-18 15:31	CCI	CCI270115C00077500	call	77.5000	2027-01-15	4.2000	4.0000	4.7000	74.3250	19320.00	15120.00	4200.00	46	6	62	192	0.322916666666667	0.26550437897109	0.26550437897109	false	false	false	true	false
eb21000d-e91c-4caf-b34f-266262fee943	2026-08-18 15:23	2026-08-18 15:23	2026-08-18 15:23	SLG	SLG261016P00055000	put	55.0000	2026-10-16	2.7500	2.7500	2.8000	56.9100	16775.00	0.00	16775.00	61	20	63	2	31.5	0.421674630380477	0.421674630380477	false	false	false	true	false
79325a14-1e97-4374-91ca-868aa5d1288d	2026-08-18 15:17	2026-08-18 15:17	2026-08-18 15:17	ARE	ARE260918P00042500	put	42.5000	2026-09-18	0.6500	0.6000	0.7000	46.0550	19684.00	69.00	19615.00	302	8	315	413	0.76271186440678	0.383655033439532	0.393896384796413	false	false	false	true	false
d8f801c1-7fd2-42ca-aee2-48ee4fb2d01c	2026-08-18 15:05	2026-08-18 15:05	2026-08-18 15:05	CCI	CCI270115C00082500	call	82.5000	2027-01-15	2.5500	2.5000	2.6000	74.3500	18361.00	255.00	18106.00	72	27	75	149	0.503355704697987	0.265679524551559	0.265679524551559	false	false	false	true	false
9d9dc528-2800-478b-b122-6f14d804b34d	2026-08-18 15:03	2026-08-18 15:03	2026-08-18 15:03	PLD	PLD270617P00125000	put	125.0000	2027-06-17	6.5000	6.2000	7.0000	140.2350	55250.00	50050.00	5200.00	85	13	85	344	0.247093023255814	0.298627755138087	0.298627755138087	false	false	false	true	false
f8fb112b-1ce5-42f0-a4e7-f085fc28968b	2026-08-18 14:58	2026-08-18 14:57	2026-08-18 14:57	CBRE	CBRE261218C00160000	call	160.0000	2026-12-18	7.9000	7.5000	7.9000	148.9900	67938.00	67938.00	0.00	86	27	2114	7	302	0.334744406114826	0.334744406114826	false	false	false	true	false
749506b7-0372-49b5-985f-b6906c5f85fc	2026-08-18 14:37	2026-08-18 14:37	2026-08-18 14:37	OPEN	OPEN280121C00005000	call	5.0000	2028-01-21	1.1900	1.1700	1.1900	3.4100	52174.00	52174.00	0.00	439	13	879	35971	0.0244363515053793	0.973446936406397	0.971452806638371	true	false	false	true	false
edded55c-f58d-479f-8260-f022edb6e0ba	2026-08-18 14:23	2026-08-18 14:23	2026-08-18 14:23	FRMI	FRMI260918C00006000	call	6.0000	2026-09-18	0.6000	0.5500	0.6500	5.8650	12780.00	5040.00	7740.00	213	6	1839	1372	1.34037900874636	0.956001196954687	0.956001196954687	false	false	false	true	false
6f135f42-e722-416d-83c7-e6910c4147df	2026-08-18 14:19	2026-08-18 14:19	2026-08-18 14:19	FRMI	FRMI261120P00006000	put	6.0000	2026-11-20	1.3000	1.2000	1.3500	5.8560	14430.00	14170.00	260.00	111	7	131	9171	0.0142841565805256	1.06593303695115	1.06593303695115	false	false	false	true	false
6015e747-44af-45af-816c-0fc740c51ae9	2026-08-18 13:40	2026-08-18 13:40	2026-08-18 13:40	REAX	REAX260918C00002500	call	2.5000	2026-09-18	0.3100	0.3000	0.3500	2.6000	31415.00	3605.00	27810.00	1030	2	6247	72	86.7638888888889	0.992717746100579	0.992717746100579	false	true	false	true	false
5e5f41e6-1bbe-40a0-85f0-3b31fb547913	2026-08-18 13:26	2026-08-18 13:26	2026-08-18 13:26	ABR	ABR270115C00006000	call	6.0000	2027-01-15	0.2000	0.1500	0.2500	4.9205	14600.00	13820.00	0.00	730	24	855	4578	0.186762778505898	0.405211674144429	0.406408595919998	true	false	false	true	false
339be8cf-7af5-45a9-b026-4e4d6cacdc51	2026-08-18 13:24	2026-08-18 13:24	2026-08-18 13:24	NLY	NLY260918C00024000	call	24.0000	2026-09-18	0.1900	0.1800	0.2000	23.3750	50331.00	380.00	49951.00	2649	18	3233	3105	1.04122383252818	0.147809742668574	0.147809742668574	false	false	false	true	false