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.

713,305 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts713,305 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

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	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	Common Stock	Real Estate	27570982152.00	2026-10-29	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-19T15:01:13.058297Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
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
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
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
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
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
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
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
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
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
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
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
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
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
8ca32bd3-209b-4d36-9f98-4f75be6a3833	2026-08-18 13:20	2026-08-18 13:19	2026-08-18 13:19	FRMI	FRMI260918C00006000	call	6.0000	2026-09-18	0.6500	0.6500	0.7000	5.9950	55835.00	0.00	55835.00	859	7	1500	1372	1.0932944606414	0.926089371100575	0.926089371100575	false	false	false	true
7e5fb167-b3a2-4b7c-9a7d-57214b22f831	2026-08-18 13:19	2026-08-18 13:19	2026-08-18 13:19	FRMI	FRMI260918C00007000	call	7.0000	2026-09-18	0.3500	0.3500	0.4000	6.0205	64155.00	0.00	64155.00	1833	22	2180	17672	0.123358985966501	0.972383798278636	0.972383798278636	false	false	false	true
cd420117-a98b-4958-b41a-67ef148fdf24	2026-08-18 13:15	2026-08-18 13:15	2026-08-18 13:15	CBRE	CBRE261218C00160000	call	160.0000	2026-12-18	7.9000	6.8000	8.1000	148.8950	1580000.00	1580000.00	0.00	2000	1	2015	7	287.857142857143	0.335927678843948	0.335927678843948	false	true	false	true
3bf36978-31a5-485e-8d43-98f1776d9685	2026-08-18 12:44	2026-08-18 12:44	2026-08-18 12:44	OPEN	OPEN270115C00004000	call	4.0000	2027-01-15	0.5800	0.5600	0.5800	3.4450	15022.00	15022.00	0.00	259	13	1271	6880	0.184738372093023	0.861335632762637	0.861335632762637	false	false	false	true
f33c4488-e78a-4e79-b522-8910cdddf688	2026-08-18 12:31	2026-08-18 12:31	2026-08-18 12:31	MPT	MPT270115P00003000	put	3.0000	2027-01-15	0.1100	0.1000	0.1100	4.0300	46244.00	46244.00	0.00	4204	26	8855	14419	0.614120257992926	0.524438675519623	0.524438675519623	false	false	false	true
61f3d611-014e-46dc-8b5a-df0adf683e4c	2026-08-18 12:10	2026-08-18 12:09	2026-08-18 12:09	CXW	CXW270319P00028000	put	28.0000	2027-03-19	2.0000	2.0000	2.1500	33.2500	19200.00	0.00	19200.00	96	12	208	11334	0.0183518616551968	0.47220975780887	0.47220975780887	false	false	false	true
6c3f7f23-98bf-45cb-81f1-86753ddd25e6	2026-08-18 12:00	2026-08-18 11:59	2026-08-18 11:59	OPEN	OPEN270115C00004000	call	4.0000	2027-01-15	0.5800	0.5600	0.5900	3.4350	20358.00	20358.00	0.00	351	11	986	6880	0.143313953488372	0.867176940099163	0.867176940099163	false	false	false	true
4ad44d02-39fd-468f-ace3-0c1e6bb74d3b	2026-08-18 11:56	2026-08-18 11:55	2026-08-18 11:55	MPT	MPT270115P00003000	put	3.0000	2027-01-15	0.1000	0.0800	0.1100	4.0200	27760.00	24900.00	2860.00	2776	62	4631	14419	0.321173451695679	0.505327171197599	0.504130824084298	false	false	false	true
0a6f641e-9093-4d2a-8485-cb2dde9230d3	2026-08-18 11:55	2026-08-18 11:55	2026-08-18 11:55	MPT	MPT270115P00003000	put	3.0000	2027-01-15	0.1000	0.0800	0.1000	4.0250	10000.00	10000.00	0.00	1000	37	1855	14419	0.128649698314724	0.505327171197599	0.505327171197599	false	false	false	true
0d92ecf6-e036-4791-8d08-c5ba5880f055	2026-08-18 11:53	2026-08-18 11:53	2026-08-18 11:53	OPEN	OPEN270115C00004000	call	4.0000	2027-01-15	0.5800	0.5600	0.5800	3.4350	25752.00	25752.00	0.00	444	14	502	6880	0.0729651162790698	0.867176940099163	0.867176940099163	false	false	false	true
411ccf99-8dfe-4b58-b1ca-4a2de588521d	2026-08-18 11:35	2026-08-18 11:34	2026-08-18 11:34	RITM	RITM270115C00010000	call	10.0000	2027-01-15	0.7000	0.4500	0.7500	10.2585	12670.00	1330.00	11340.00	181	5	184	8190	0.0224664224664225	0.179170202710136	0.179170202710136	false	false	false	true
a5370516-ad00-40a5-b5db-bb18d0eba435	2026-08-18 11:29	2026-08-18 11:29	2026-08-18 11:29	REAX	REAX260918C00002500	call	2.5000	2026-09-18	0.3300	0.2000	0.3500	2.5550	165000.00	165000.00	0.00	5000	2	5006	72	69.5277777777778	1.08661354760856	0.913712214860795	false	true	false	true
d32068ff-457b-4ed3-bd3c-ce8e7f0500cf	2026-08-18 11:18	2026-08-18 11:18	2026-08-18 11:18	OPEN	OPEN260821C00003500	call	3.5000	2026-08-21	0.0900	0.0800	0.0900	3.4300	18405.00	18405.00	0.00	2045	39	6840	9852	0.694275274056029	0.968835523476204	0.968835523476204	false	false	false	true
73d9ab67-4d5f-44cd-8371-900dbfc7c69f	2026-08-18 10:52	2026-08-18 10:52	2026-08-18 10:52	FRMI	FRMI280121C00010000	call	10.0000	2028-01-21	2.0900	2.0500	2.2000	5.9300	10440.00	0.00	10440.00	50	6	68	5689	0.011952891545087	1.0660701818938	1.0660701818938	false	false	false	true
5191c235-1109-41e1-871f-9076cab11d52	2026-08-18 10:37	2026-08-18 10:37	2026-08-18 10:37	HASI	HASI261120C00040000	call	40.0000	2026-11-20	3.6600	3.5000	4.5000	41.7600	25590.00	0.00	25590.00	70	5	70	353	0.198300283286119	0.295341602627734	0.295341602627734	false	false	false	true
89f55872-108f-4113-a4c8-1db5b7636acd	2026-08-18 10:06	2026-08-18 10:06	2026-08-18 10:06	CBRE	CBRE260918C00150000	call	150.0000	2026-09-18	5.5500	5.2000	6.2000	149.6300	832500.00	0.00	832500.00	1500	2	1511	10095	0.149678058444775	0.313042812822433	0.313042812822433	false	true	false	true
4c5af4e2-abff-4648-8181-06044ce50564	2026-08-18 09:55	2026-08-18 09:55	2026-08-18 09:55	OPEN	OPEN260821C00003500	call	3.5000	2026-08-21	0.0900	0.0900	0.1000	3.4801	18000.00	0.00	18000.00	2000	27	2850	9852	0.289281364190012	0.785544076769827	0.785544076769827	true	false	false	true
ba66f582-aa2c-4a00-a9a6-ca9ea44e6bfc	2026-08-18 09:47	2026-08-18 09:47	2026-08-18 09:47	MPT	MPT270319P00004000	put	4.0000	2027-03-19	0.5200	0.4700	0.5200	4.0000	10380.00	6963.00	3417.00	201	6	302	15626	0.0193267630871624	0.471402400849822	0.479841726097357	true	false	false	true
610e740f-2bf3-4dde-a109-585f2da0b2a1	2026-08-18 09:47	2026-08-18 09:47	2026-08-18 09:47	O	O280121C00062500	call	62.5000	2028-01-21	5.2000	4.5000	6.3000	62.0000	70200.00	7800.00	62400.00	135	17	135	774	0.174418604651163	0.0955003054111367	0.0955003054111367	false	false	false	true
69d2079c-a3cf-4b28-bcbd-1cbcfa682e0b	2026-08-18 09:44	2026-08-18 09:44	2026-08-18 09:44	VICI	VICI270617P00027500	put	27.5000	2027-06-17	3.1000	2.8000	3.1000	26.0000	30378.00	30378.00	0.00	98	11	139	3326	0.0417919422730006	0.30252879578161	0.30252879578161	false	false	false	true
1ac023a9-a03e-438b-bb77-bf98b30649f8	2026-08-18 09:44	2026-08-18 09:44	2026-08-18 09:44	FRMI	FRMI261120C00012000	call	12.0000	2026-11-20	0.3000	0.2500	0.3500	5.0000	57000.00	0.00	25290.00	1900	9	2000	5948	0.336247478143914	1.17599838105816	1.17599838105816	false	false	false	true
6a33cb71-5400-4bc8-a8e4-dc46b7b43908	2026-08-18 09:42	2026-08-18 09:41	2026-08-18 09:41	FRMI	FRMI261120C00013000	call	13.0000	2026-11-20	0.2500	0.2500	0.3000	5.0000	10010.00	0.00	10010.00	400	27	400	775	0.516129032258065	1.18847943345408	1.18847943345408	true	false	false	true
64d801db-d853-433d-be18-a4c099974eea	2026-08-18 09:38	2026-08-18 09:38	2026-08-18 09:38	FRMI	FRMI260918C00008000	call	8.0000	2026-09-18	0.2500	0.2000	0.2500	5.0000	15000.00	15000.00	0.00	600	9	632	9893	0.0638835540281007	1.15281597690516	1.15281597690516	false	false	false	true
744a240e-80a5-42ae-b040-4838ea34a57c	2026-08-18 09:38	2026-08-18 09:38	2026-08-18 09:38	FRMI	FRMI260918C00009000	call	9.0000	2026-09-18	0.1500	0.1000	0.2000	5.0000	14880.00	10890.00	3990.00	1000	32	1002	3148	0.318297331639136	1.18773970641413	1.18773970641413	false	false	false	true
8e6cd9b7-a2c3-4f8c-8bfe-457bf62fa643	2026-08-17 15:52	2026-08-17 15:52	2026-08-17 15:52	AHR	AHR260918C00055000	call	55.0000	2026-09-18	1.5500	1.5500	1.6000	54.5000	13485.00	0.00	4340.00	87	6	1172	330	3.55151515151515	0.263929976419188	0.263929976419188	false	false	false	true
67484013-3ee2-4db4-a888-9dfd10a1f179	2026-08-17 15:52	2026-08-17 15:52	2026-08-17 15:52	AHR	AHR260918C00055000	call	55.0000	2026-09-18	1.6000	1.3000	1.6000	54.5000	10720.00	3680.00	0.00	67	6	1085	330	3.28787878787879	0.271700983444	0.271700983444	false	false	false	true