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.

728,802 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts728,802 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

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	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	ADR	Real Estate	18001535976.00	2026-11-09	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-19T13:40:44.275238Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
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
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
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
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
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
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
32b372ea-69c1-41a4-b35e-d303a0722cf5	2026-08-18 12:13	2026-08-18 12:13	2026-08-18 12:13	ARE	ARE261016C00052500	call	52.5000	2026-10-16	0.8000	0.8000	0.9000	46.5550	29440.00	0.00	29440.00	368	9	369	461	0.800433839479393	0.346882670895517	0.346882670895517	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
07467522-741f-4d88-a53d-97b0f7fcdf71	2026-08-18 10:35	2026-08-18 10:35	2026-08-18 10:35	PLD	PLD260918P00135000	put	135.0000	2026-09-18	1.7500	1.3000	2.0000	140.1450	130375.00	1750.00	128625.00	745	20	746	1119	0.666666666666667	0.245927384332619	0.245927384332619	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
2f9bdc6a-2804-46ab-9b0c-0a56ca5fdbc4	2026-08-17 15:47	2026-08-17 15:47	2026-08-17 15:47	IRM	IRM261016C00130000	call	130.0000	2026-10-16	5.8000	5.2000	6.0000	129.2100	22620.00	9860.00	4640.00	39	5	303	133	2.2781954887218	0.277169704732427	0.277169704732427	false	false	false	true
c876331f-5ae6-4cb0-883d-41a56e9a25ab	2026-08-17 15:39	2026-08-17 15:39	2026-08-17 15:39	IRM	IRM260821C00132000	call	132.0000	2026-08-21	0.7000	0.5500	0.7000	129.0300	10780.00	10780.00	0.00	154	31	168	27	6.22222222222222	0.32907030084255	0.32907030084255	false	false	false	true
cda849fc-1623-4ae0-bcb7-62f080b61062	2026-08-17 15:22	2026-08-17 15:22	2026-08-17 15:22	OPEN	OPEN270115C00003000	call	3.0000	2027-01-15	0.9900	0.9700	1.0300	3.4750	16434.00	12474.00	3960.00	166	6	336	3027	0.111000991080278	0.848685519112447	0.85815935177047	false	false	false	true
f2223364-7eff-462b-aa75-22327f2fbb07	2026-08-17 15:14	2026-08-17 15:13	2026-08-17 15:13	CBRE	CBRE261218C00155000	call	155.0000	2026-12-18	9.7000	9.2000	9.7000	148.6350	70810.00	70810.00	0.00	73	24	73	4	18.25	0.336497395514464	0.336497395514464	false	false	false	true
48e836c4-2863-4f87-a18e-0a94c7f8a671	2026-08-17 15:00	2026-08-17 15:00	2026-08-17 15:00	FRMI	FRMI261016C00010000	call	10.0000	2026-10-16	0.2600	0.2500	0.3000	6.1350	13054.00	0.00	13054.00	503	16	589	7741	0.0760883606769151	1.12033510454828	1.12322147200969	false	false	false	true
ec5e159f-0b20-4c52-ba29-a1c5f0d49803	2026-08-17 14:58	2026-08-17 14:58	2026-08-17 14:58	OPEN	OPEN280121C00015000	call	15.0000	2028-01-21	0.4400	0.4400	0.4900	3.4800	14675.00	0.00	14405.00	333	7	907	28430	0.0319029194512839	1.00530611930538	0.998217367246282	false	false	false	true