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.

326,449 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts326,449 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:er_time = unknown×ticker = FRMI×

iduuid	created_at ↓timestamp with time zone	start_timetimestamp with time zone	end_timetimestamp with time zone	tickertext	option_symboltext	option_typetext	strikenumeric	expirydate

e556af15-46c0-477f-94eb-4ac089e951de	2026-09-01 13:08	2026-09-01 13:08	2026-09-01 13:08	FRMI	FRMI280121C00010000	call	10.0000	2028-01-21	1.3000	1.3000	1.4000	4.7100	25350.00	0.00	25350.00	195	18	551	6119	0.0900473933649289	1.03073489123868	1.03073489123868	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Real Estate	3234360107.00	2026-11-09	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-01T17:20:15.685951Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
f22a3c60-95f5-40ba-8af3-67925e80115b	2026-09-01 09:41	2026-09-01 09:41	2026-09-01 09:41	FRMI	FRMI280121C00010000	call	10.0000	2028-01-21	1.4500	1.4000	1.4500	4.7914	46400.00	46400.00	0.00	320	6	333	6119	0.0544206569700931	1.07876448045924	1.07876448045924	false	false	false	true
f604c99c-6e7b-42cb-87e0-4b0d8c6039dd	2026-08-31 14:04	2026-08-31 14:04	2026-08-31 14:04	FRMI	FRMI261016C00008000	call	8.0000	2026-10-16	0.1700	0.1000	0.2000	4.0000	11815.00	11815.00	0.00	695	5	1078	4305	0.250406504065041	1.19240830947136	1.19240830947136	false	false	false	true
7c6bb3cc-c33e-4f4f-9c5a-cdc48f66aef6	2026-08-31 13:17	2026-08-31 13:17	2026-08-31 13:17	FRMI	FRMI261016C00006000	call	6.0000	2026-10-16	0.4200	0.3500	0.4500	4.9450	12306.00	12306.00	0.00	293	5	339	2249	0.15073365940418	1.08959577256055	1.08959577256055	false	false	false	true
b55600e2-8e43-40c8-9065-1e05e129669c	2026-08-31 10:57	2026-08-31 10:57	2026-08-31 10:57	FRMI	FRMI270115C00010000	call	10.0000	2027-01-15	0.4000	0.4000	0.4500	4.9150	17760.00	0.00	17760.00	444	9	485	70522	0.00687728652051842	1.14715770662839	1.14715770662839	false	false	false	true
a34ab4f9-48b1-4b1f-9ed6-2e74c327edde	2026-08-27 15:57	2026-08-27 15:57	2026-08-27 15:57	FRMI	FRMI260925P00005000	put	5.0000	2026-09-25	0.3500	0.3000	0.4000	5.4650	14700.00	6300.00	0.00	420	7	1135	146	7.77397260273973	0.952298550758193	0.952298550758193	false	false	false	true
c5bd4fc9-fe73-4323-baca-67c6108fe22c	2026-08-27 14:41	2026-08-27 14:41	2026-08-27 14:41	FRMI	FRMI270219C00010000	call	10.0000	2027-02-19	0.7700	0.7000	0.8000	5.4600	77289.00	77289.00	0.00	1000	35	1017	752	1.35239361702128	1.1479002363209	1.18269283511126	true	false	false	true
4d1d83f8-03bc-4a08-b75e-ca2e4737c1e9	2026-08-27 12:13	2026-08-27 12:13	2026-08-27 12:13	FRMI	FRMI261016C00006000	call	6.0000	2026-10-16	0.6900	0.6500	0.7000	5.5300	17366.00	17366.00	0.00	250	8	368	1689	0.217880402605092	1.07364893407802	1.05832705525905	false	false	false	true
31f746bd-b543-468a-8828-bbde57e97d02	2026-08-27 11:58	2026-08-27 11:58	2026-08-27 11:58	FRMI	FRMI270115C00005000	call	5.0000	2027-01-15	1.7500	1.6500	1.8000	5.5350	15400.00	3850.00	7700.00	88	7	89	2832	0.0314265536723164	1.12165855108347	1.12165855108347	false	false	false	true
c2c27d5b-a5ef-4295-b937-438f4f98d390	2026-08-27 11:35	2026-08-27 11:35	2026-08-27 11:35	FRMI	FRMI261016P00006000	put	6.0000	2026-10-16	1.0500	1.0500	1.1500	5.5350	10500.00	0.00	10500.00	100	7	100	2329	0.04293688278231	0.964888715046069	0.964888715046069	false	false	false	true
a545f2a6-47db-4844-9646-755a05369f60	2026-08-27 10:55	2026-08-27 10:55	2026-08-27 10:55	FRMI	FRMI260918C00005500	call	5.5000	2026-09-18	0.6000	0.5500	0.6000	5.5850	12000.00	10440.00	0.00	200	35	202	127	1.59055118110236	1.01666812184281	1.01666812184281	true	false	false	true
f2cec544-355d-4ab9-99b9-ef71db7595c4	2026-08-27 10:15	2026-08-27 10:15	2026-08-27 10:15	FRMI	FRMI261218P00005000	put	5.0000	2026-12-18	0.9000	0.9000	1.0000	5.6050	10980.00	0.00	10980.00	122	11	122	16018	0.00761643151454614	1.04392566154674	1.04392566154674	false	false	false	true
638b76bb-e114-4ac0-a500-ff1f4b10246d	2026-08-27 09:36	2026-08-27 09:36	2026-08-27 09:36	FRMI	FRMI280121C00007500	call	7.5000	2028-01-21	2.4000	2.2500	2.4000	5.7250	12000.00	10080.00	0.00	50	5	100	5267	0.0189861401177141	1.07250662478814	1.07250662478814	false	false	false	true
5f3455c2-f140-4996-87b8-dd46a083bb61	2026-08-26 15:06	2026-08-26 15:06	2026-08-26 15:06	FRMI	FRMI261120C00006000	call	6.0000	2026-11-20	1.0500	1.0500	1.1500	5.6650	10500.00	0.00	10500.00	100	5	148	8461	0.0174920222195958	1.066120661229	1.066120661229	false	false	false	true
0fcf7615-c57a-44bf-be3c-b5e64e14bb1b	2026-08-26 13:43	2026-08-26 13:43	2026-08-26 13:43	FRMI	FRMI261120C00015000	call	15.0000	2026-11-20	0.1200	0.1000	0.2000	5.7273	13441.00	0.00	13441.00	1126	7	1127	48055	0.0234522942461763	1.17527170965676	1.2410530395286	false	false	false	true
e5619a2e-3a65-46fe-8683-f6d5c73477e1	2026-08-25 15:57	2026-08-25 15:57	2026-08-25 15:57	FRMI	FRMI261016C00007000	call	7.0000	2026-10-16	0.6500	0.6000	0.6500	5.9750	26000.00	26000.00	0.00	400	5	1249	3885	0.321492921492921	1.11086611693659	1.11086611693659	false	false	false	true
b8a322cc-beb9-45a5-9c0c-d9c268aa5cbe	2026-08-25 15:10	2026-08-25 15:10	2026-08-25 15:10	FRMI	FRMI261120P00006000	put	6.0000	2026-11-20	1.2000	1.2000	1.3000	5.9850	11520.00	0.00	11520.00	96	6	513	9201	0.0557548092598631	1.06182111895973	1.06182111895973	false	false	false	true
223579a2-55f2-4748-885a-6c0056d03c94	2026-08-25 13:57	2026-08-25 13:57	2026-08-25 13:57	FRMI	FRMI261120P00006000	put	6.0000	2026-11-20	1.2500	1.2500	1.3000	5.9650	10750.00	0.00	10750.00	86	5	307	9201	0.0333659384849473	1.09942304332232	1.09942304332232	false	false	false	true
43b903a0-67c5-40fb-b948-fb2914c81a4c	2026-08-25 13:35	2026-08-25 13:35	2026-08-25 13:35	FRMI	FRMI260828C00006000	call	6.0000	2026-08-28	0.2500	0.2000	0.3000	6.0100	10565.00	10425.00	140.00	423	11	2752	2517	1.09336511720302	1.12419915594269	1.12419915594269	false	false	false	true
5d90e244-687e-4964-ba3e-8c862908c81f	2026-08-25 11:39	2026-08-25 11:38	2026-08-25 11:38	FRMI	FRMI261120C00006000	call	6.0000	2026-11-20	1.2000	1.2000	1.2500	5.8800	12000.00	0.00	12000.00	100	9	127	8330	0.0152460984393758	1.08247711861891	1.08247711861891	false	false	false	true
80fc95cf-32f7-46a7-8204-5cfed0b101d3	2026-08-25 10:10	2026-08-25 10:10	2026-08-25 10:10	FRMI	FRMI261016C00007000	call	7.0000	2026-10-16	0.5100	0.5000	0.6500	5.7200	20213.00	0.00	20213.00	400	9	424	3885	0.109137709137709	1.0562351175405	1.07067003819261	false	false	false	true
adbc3ccc-5b81-4cef-bb76-1fc9a594ccb3	2026-08-24 15:48	2026-08-24 15:48	2026-08-24 15:48	FRMI	FRMI280121C00015000	call	15.0000	2028-01-21	1.4000	1.4000	1.4500	5.5450	10920.00	0.00	2240.00	78	7	102	3857	0.0264454239045891	1.08986023558894	1.08986023558894	false	false	false	true
1fea440f-49e9-497c-8d28-378d806928eb	2026-08-24 11:35	2026-08-24 11:35	2026-08-24 11:35	FRMI	FRMI261016P00006000	put	6.0000	2026-10-16	1.0500	1.0500	1.2000	5.6750	10500.00	0.00	10500.00	100	5	102	2168	0.0470479704797048	1.0196324044235	1.0196324044235	false	false	false	true
5f4218ec-5769-423c-a0a6-08371892d9af	2026-08-24 09:51	2026-08-24 09:50	2026-08-24 09:50	FRMI	FRMI260911P00004500	put	4.5000	2026-09-11	0.0700	0.0500	0.2500	5.6500	112050.00	0.00	112050.00	16007	2	16007	220	72.7590909090909	1.04837324988768	1.04837324988768	false	true	false	true
2c7c7c86-ed8f-41e4-92bb-0c751656696a	2026-08-24 09:45	2026-08-24 09:45	2026-08-24 09:45	FRMI	FRMI260828C00005500	call	5.5000	2026-08-28	0.3000	0.3000	0.5500	5.6200	22200.00	0.00	22200.00	740	12	1162	1600	0.72625	1.00751757147387	1.00751757147387	false	false	false	true	false
0ec8dc24-93e8-4653-afe1-ff8343c2fa8c	2026-08-24 09:43	2026-08-24 09:43	2026-08-24 09:43	FRMI	FRMI260828C00005500	call	5.5000	2026-08-28	0.3300	0.3000	0.5500	5.6750	14038.00	0.00	14038.00	420	9	422	1600	0.26375	1.07854303394546	1.07854303394546	false	false	false	true	false
b7d5278a-894c-4a84-b15c-092d66a4b936	2026-08-21 15:51	2026-08-21 15:51	2026-08-21 15:51	FRMI	FRMI260904P00005500	put	5.5000	2026-09-04	0.2100	0.2000	0.2500	5.9499	21002.00	0.00	21002.00	1000	8	2011	150	13.4066666666667	0.916294114292504	0.916294114292504	false	false	false	true
9277e10c-7fd5-43e4-8432-a5d290681747	2026-08-21 15:32	2026-08-21 15:32	2026-08-21 15:32	FRMI	FRMI260821C00005500	call	5.5000	2026-08-21	0.4000	0.4000	0.4500	5.9250	12850.00	0.00	12850.00	321	19	754	785	0.960509554140127	9.14943661371336	9.14943661371336	false	false	false	true
ab557b32-e8c7-4f61-89b2-550e735822bc	2026-08-21 11:44	2026-08-21 11:43	2026-08-21 11:43	FRMI	FRMI261016C00006000	call	6.0000	2026-10-16	1.0500	1.0000	1.0500	6.0650	20019.00	20019.00	0.00	191	13	369	916	0.402838427947598	1.07170760466387	1.06010901389655	false	false	false	true
2b8a7cfe-71f9-41ff-b939-bba78ff2e55e	2026-08-20 13:41	2026-08-20 13:41	2026-08-20 13:41	FRMI	FRMI261218C00019000	call	19.0000	2026-12-18	0.2000	0.1500	0.2500	5.7350	20960.00	20480.00	0.00	1048	32	1066	2190	0.48675799086758	1.33881381053339	1.33881381053339	false	false	false	true
1bdbc974-be5e-4853-8d71-f68b04f7bf10	2026-08-20 13:18	2026-08-20 13:18	2026-08-20 13:18	FRMI	FRMI260828C00005500	call	5.5000	2026-08-28	0.4500	0.4000	0.5000	5.6850	33300.00	28305.00	4995.00	740	8	1094	756	1.44708994708995	1.05220429783038	1.05220429783038	false	false	false	true
b4b4f95e-28f7-4601-9e36-f6d0e825086e	2026-08-20 12:15	2026-08-20 12:15	2026-08-20 12:15	FRMI	FRMI261016C00007000	call	7.0000	2026-10-16	0.5500	0.5500	0.6000	5.7150	11000.00	0.00	11000.00	200	15	1748	1491	1.17236753856472	1.06985099140949	1.06985099140949	false	false	false	true
7bf401df-387e-48d6-b3b7-f55ebbfcd7bc	2026-08-20 10:56	2026-08-20 10:56	2026-08-20 10:56	FRMI	FRMI261016C00007000	call	7.0000	2026-10-16	0.6000	0.5500	0.6500	5.7150	14940.00	7140.00	3720.00	249	5	922	1491	0.618376928236083	1.12692410726281	1.12692410726281	false	false	false	true
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
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
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
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
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
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
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
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
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
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
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