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.

658,639 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts658,639 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:er_time = unknown×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

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	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Real Estate	40801159488.00	2026-10-22	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-19T19:47:06.720571Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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