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.

375,978 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts375,978 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:alert_rule = RepeatedHits×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

d1e04e3d-8b71-4d1a-ad1d-675949ac3b6d	2026-09-23 14:59	2026-09-23 14:58	2026-09-23 14:58	FRMI	FRMI270115C00007500	call	7.5000	2027-01-15	0.5000	0.5000	0.5500	4.8850	13950.00	0.00	13950.00	279	17	410	8590	0.0477299185098952	1.06455910968671	1.06455910968671	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Real Estate	3087052617.00	2026-11-09	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-23T19:05:07.702473Z"}	2026-09-23	2026-09-23 21:15	2026-09-23 21:15
bbecd1f1-e738-42a7-8eba-df0c182dddd2	2026-09-23 10:33	2026-09-23 10:33	2026-09-23 10:33	FRMI	FRMI280121P00002500	put	2.5000	2028-01-21	0.5500	0.5500	0.6500	4.9250	27500.00	0.00	27500.00	500	7	500	4050	0.123456790123457	0.987590026045053	0.987590026045053	false	false	false	true
ec970f91-028c-44ab-8f2d-be0ece3cfa10	2026-09-22 13:50	2026-09-22 13:50	2026-09-22 13:50	FRMI	FRMI270219C00009000	call	9.0000	2027-02-19	0.5500	0.5000	0.6500	5.0950	11000.00	1210.00	9790.00	200	6	200	326	0.613496932515337	1.08618121547493	1.08618121547493	false	false	false	true
13664d98-ca35-4c88-aa9a-e3f12f94e716	2026-09-22 13:24	2026-09-22 13:24	2026-09-22 13:24	FRMI	FRMI270115P00004000	put	4.0000	2027-01-15	0.5500	0.5000	0.5500	5.1150	16500.00	16500.00	0.00	300	6	562	10620	0.0529190207156309	1.03578177688459	1.03578177688459	false	false	false	true
8901d8e7-91a5-4f61-aa71-33a598d0ae41	2026-09-18 15:55	2026-09-18 15:55	2026-09-18 15:55	FRMI	FRMI280121C00022000	call	22.0000	2028-01-21	0.6000	0.6000	0.7500	4.0000	90004.00	0.00	90004.00	1500	38	1518	12308	0.123334416639584	1.03061383076688	1.03133337958741	false	false	false	true
e8f3cfcd-cf34-4f2f-b050-41791538187e	2026-09-18 15:53	2026-09-18 15:52	2026-09-18 15:52	FRMI	FRMI270219C00017000	call	17.0000	2027-02-19	0.1500	0.1500	0.2000	4.0000	22500.00	0.00	22500.00	1500	30	1520	102	14.9019607843137	1.16180642165772	1.16180642165772	false	false	false	true
fc7d9bc3-3c16-4654-9caa-97c20ca46639	2026-09-18 12:46	2026-09-18 12:46	2026-09-18 12:46	FRMI	FRMI261120P00005000	put	5.0000	2026-11-20	0.8500	0.8500	0.9000	4.9950	52120.00	0.00	52120.00	613	21	627	2569	0.244063838069288	1.05660810459426	1.05660810459426	false	false	false	true
b408a3c0-4d71-4247-897f-b8acf84a6bf2	2026-09-18 10:55	2026-09-18 10:55	2026-09-18 10:55	FRMI	FRMI261120C00005000	call	5.0000	2026-11-20	0.8500	0.8500	0.9000	4.9250	18700.00	0.00	18700.00	220	16	220	3851	0.0571280186964425	1.06985409094156	1.06985409094156	false	false	false	true
60803cbd-99e4-4ba8-bc06-cc709d78a29f	2026-09-16 13:03	2026-09-16 13:03	2026-09-16 13:03	FRMI	FRMI261023P00004500	put	4.5000	2026-10-23	0.4500	0.4000	0.4500	4.9350	16830.00	16830.00	0.00	374	5	753	611	1.23240589198036	1.09627967551974	1.09627967551974	false	false	false	true
12d2cd3d-9d34-4187-b49a-2d9bcba78af9	2026-09-15 14:51	2026-09-15 14:51	2026-09-15 14:51	FRMI	FRMI261120C00006000	call	6.0000	2026-11-20	0.5300	0.5000	0.5500	4.7000	25995.00	13255.00	12740.00	486	7	709	10011	0.0708220956947358	1.19291072581418	1.15431986173103	false	false	false	true
ffda292c-1152-47c7-b851-3fd5c918dc4c	2026-09-15 11:55	2026-09-15 11:55	2026-09-15 11:55	FRMI	FRMI261218P00005000	put	5.0000	2026-12-18	1.1500	1.1000	1.1500	4.7450	13455.00	13455.00	0.00	117	6	258	17752	0.0145335736818387	1.07991756327955	1.07991756327955	false	false	false	true
6fdb6cb1-1005-46e2-9a45-5d069e52edef	2026-09-15 10:08	2026-09-15 10:08	2026-09-15 10:08	FRMI	FRMI261016C00006000	call	6.0000	2026-10-16	0.2500	0.2500	0.3500	4.9650	100000.00	0.00	100000.00	4000	20	4000	3815	1.04849279161206	0.999506369259885	0.999506369259885	false	false	false	true
a728d2ca-2bb9-437c-9393-89e028136b96	2026-09-15 10:01	2026-09-15 10:01	2026-09-15 10:01	FRMI	FRMI261218P00005000	put	5.0000	2026-12-18	1.0500	1.0500	1.1500	4.9750	10500.00	0.00	10500.00	100	9	108	17752	0.00608382154123479	1.07272984221039	1.07272984221039	false	false	false	true
d536f255-3967-4608-bb0c-ebd0643cc35a	2026-09-15 09:53	2026-09-15 09:53	2026-09-15 09:53	FRMI	FRMI261218C00007500	call	7.5000	2026-12-18	0.5000	0.5000	0.5500	4.9899	100000.00	0.00	100000.00	2000	6	2102	13129	0.160103587478102	1.13649064069171	1.13649064069171	false	false	false	true
d4e0bee4-1378-41e7-86e9-2e73c04e90c1	2026-09-14 10:59	2026-09-14 10:58	2026-09-14 10:58	FRMI	FRMI261218C00009000	call	9.0000	2026-12-18	0.3500	0.3500	0.4500	5.0800	12390.00	0.00	12390.00	354	5	358	7439	0.0481247479499933	1.15301809716884	1.15301809716884	false	false	false	true
da7e4d6a-30b6-4057-9fbd-ddc0266b2c3c	2026-09-11 14:35	2026-09-11 14:35	2026-09-11 14:35	FRMI	FRMI260918C00005500	call	5.5000	2026-09-18	0.3000	0.3000	0.3500	5.5150	18000.00	0.00	18000.00	600	37	728	2367	0.307562315166878	0.955468419477289	0.955468419477289	true	false	false	true
3e7c5a1e-e1ba-492c-bde6-e02f49036edd	2026-09-11 12:30	2026-09-11 12:30	2026-09-11 12:30	FRMI	FRMI261120P00005000	put	5.0000	2026-11-20	0.6500	0.6500	0.8500	5.5150	13000.00	0.00	13000.00	200	8	201	2315	0.0868250539956803	0.9900823638901	0.9900823638901	false	false	false	true
a80383b7-e817-44cb-9e27-a428170a40f7	2026-09-10 14:40	2026-09-10 14:39	2026-09-10 14:39	FRMI	FRMI261002C00006000	call	6.0000	2026-10-02	0.3500	0.3000	0.3500	5.3400	24500.00	24500.00	0.00	700	25	850	830	1.02409638554217	1.13092761118226	1.1231595459084	false	false	false	true
799549ff-65ad-40d3-a672-5fc7093f8ca9	2026-09-10 14:29	2026-09-10 14:29	2026-09-10 14:29	FRMI	FRMI260925C00006000	call	6.0000	2026-09-25	0.2500	0.2000	0.3000	5.3350	10000.00	8750.00	1250.00	400	12	415	1260	0.329365079365079	1.12272220120343	1.12272220120343	true	false	false	true
9e772dad-a560-4784-8939-7563ccb0c448	2026-09-10 11:10	2026-09-10 11:10	2026-09-10 11:10	FRMI	FRMI261120C00008000	call	8.0000	2026-11-20	0.4500	0.4500	0.5000	5.4650	90000.00	0.00	90000.00	2000	24	2134	4109	0.519347773180823	1.16173018532781	1.16173018532781	false	false	false	true
7df779de-c7c8-4967-884c-a4ffde1f1b53	2026-09-10 09:44	2026-09-10 09:44	2026-09-10 09:44	FRMI	FRMI261016C00007000	call	7.0000	2026-10-16	0.2500	0.2500	0.3500	5.3150	17500.00	0.00	17500.00	700	5	700	5606	0.124866214769889	1.08791606599083	1.08791606599083	false	false	false	true
5c6ae20e-8fe2-4aaf-9237-3a24ddbb0344	2026-09-09 12:04	2026-09-09 12:04	2026-09-09 12:04	FRMI	FRMI270115C00007500	call	7.5000	2027-01-15	0.9200	0.9000	1.0000	5.5350	184000.00	0.00	184000.00	2000	6	2003	12126	0.165182253010061	1.13506157075492	1.13506157075492	false	false	false	true
a0960488-5fb9-4cfe-b740-edfb7f06cb2e	2026-09-08 15:19	2026-09-08 15:19	2026-09-08 15:19	FRMI	FRMI261218C00010000	call	10.0000	2026-12-18	0.5100	0.5000	0.5500	5.8350	10200.00	0.00	10200.00	200	5	2200	8703	0.252786395495806	1.18696318265111	1.18696318265111	false	false	false	true
6c082e07-910a-4278-9dc0-7e12ca4d940f	2026-09-08 15:02	2026-09-08 15:02	2026-09-08 15:02	FRMI	FRMI270115P00005000	put	5.0000	2027-01-15	1.0000	0.9000	1.0000	5.8726	33300.00	33300.00	0.00	333	21	395	14314	0.027595361184854	1.13552276588446	1.13380029433607	false	false	false	true
09755f52-af24-44ad-b517-3a1ab809d1d4	2026-09-08 11:33	2026-09-08 11:32	2026-09-08 11:32	FRMI	FRMI260918C00005000	call	5.0000	2026-09-18	0.8500	0.7500	0.9500	5.7150	12750.00	0.00	10880.00	150	5	770	1493	0.515740120562626	1.10099553186773	1.10099553186773	false	false	false	true
9ac6708b-02f6-40bc-83f3-a42f35351ae5	2026-09-04 15:25	2026-09-04 15:25	2026-09-04 15:25	FRMI	FRMI270115C00010000	call	10.0000	2027-01-15	0.6000	0.4500	1.2500	5.1699	67920.00	1200.00	3960.00	1132	5	10168	70816	0.143583370989607	1.28376323672974	1.28376323672974	false	false	false	true
05c38cc3-30b4-431c-b34a-63f7a651d1db	2026-09-04 15:25	2026-09-04 15:25	2026-09-04 15:25	FRMI	FRMI261120C00006000	call	6.0000	2026-11-20	0.7500	0.7500	0.9500	5.1350	40200.00	0.00	40200.00	536	6	651	8910	0.0730639730639731	1.10727784916662	1.10727784916662	false	false	false	true
671e6fb7-aebe-414e-8bfa-c139b28ba0b8	2026-09-04 15:25	2026-09-04 15:24	2026-09-04 15:24	FRMI	FRMI270115C00010000	call	10.0000	2027-01-15	0.5000	0.4000	0.5000	5.0650	432324.00	432324.00	0.00	8652	46	8820	70816	0.124548124717578	1.22229244335772	1.22229244335772	false	false	false	true
cdc62143-6888-44ae-9915-1e55ef85c19d	2026-09-04 15:07	2026-09-04 15:06	2026-09-04 15:06	FRMI	FRMI270617C00007000	call	7.0000	2027-06-17	1.4000	1.4000	1.5000	5.0162	18340.00	0.00	18340.00	131	11	145	847	0.171192443919717	1.0896795481521	1.0896795481521	false	false	false	true
4ae0f91e-67fe-49e3-97bd-4f498381cd14	2026-09-04 13:50	2026-09-04 13:50	2026-09-04 13:50	FRMI	FRMI280121C00010000	call	10.0000	2028-01-21	1.5000	1.4500	1.5000	4.9550	60000.00	60000.00	0.00	400	14	402	6652	0.0604329524954901	1.06503976979093	1.06503976979093	false	false	false	true
99bcb172-fb96-474c-be8d-07402515ca3c	2026-09-04 13:20	2026-09-04 13:20	2026-09-04 13:20	FRMI	FRMI261016C00008000	call	8.0000	2026-10-16	0.1500	0.1000	0.1500	4.9874	31799.00	31799.00	0.00	2120	28	2130	5004	0.425659472422062	1.18907700536287	1.18310921300245	false	false	false	true
1c3708cf-7042-4272-8bbb-568878a002b3	2026-09-04 12:34	2026-09-04 12:34	2026-09-04 12:34	FRMI	FRMI270115C00007500	call	7.5000	2027-01-15	0.7000	0.6000	0.7000	4.9250	241990.00	241990.00	0.00	3457	34	3475	12369	0.280944296224432	1.14919150191031	1.14919150191031	false	false	false	true
e0dff95d-21fe-4d3d-9252-a6eebe1721bd	2026-09-04 10:56	2026-09-04 10:56	2026-09-04 10:56	FRMI	FRMI261009P00004000	put	4.0000	2026-10-09	0.1500	0.1500	0.2000	4.9150	97950.00	0.00	97950.00	6530	38	7000	20	350	0.874908092673446	0.874908092673446	false	false	false	true
09541442-bc29-4bcc-9b15-3ebaab4088e4	2026-09-04 10:06	2026-09-04 10:06	2026-09-04 10:06	FRMI	FRMI261016C00005000	call	5.0000	2026-10-16	0.7000	0.6000	0.7000	4.9400	10430.00	10430.00	0.00	149	7	182	783	0.232439335887612	1.07683289535799	1.07683289535799	false	false	false	true
74dc0ca0-249c-47e5-84e5-96f946f3aec5	2026-09-03 15:28	2026-09-03 15:28	2026-09-03 15:28	FRMI	FRMI270115C00007500	call	7.5000	2027-01-15	0.7000	0.6000	0.7000	4.8800	19250.00	19250.00	0.00	275	20	370	12244	0.030218882718066	1.16041832073649	1.16041832073649	false	false	false	true
ac11923e-496b-421b-9318-959fffdbf2a6	2026-09-03 10:48	2026-09-03 10:48	2026-09-03 10:48	FRMI	FRMI261009C00006000	call	6.0000	2026-10-09	0.2500	0.2500	0.3000	4.8100	97760.00	0.00	97760.00	3905	35	4000	31	129.032258064516	1.00323105224011	1.01465886371832	false	false	false	true
505eb2a8-d3b5-444f-93bb-f2759f323dd0	2026-09-02 15:12	2026-09-02 15:12	2026-09-02 15:12	FRMI	FRMI270115C00005000	call	5.0000	2027-01-15	1.2000	1.1500	1.2000	4.7450	60000.00	60000.00	0.00	500	11	538	3274	0.164324984728161	1.11982614879446	1.11982614879446	true	false	false	true
557c5357-865f-44b4-bb7e-04ff03cc5763	2026-09-02 14:24	2026-09-02 14:24	2026-09-02 14:24	FRMI	FRMI280121C00010000	call	10.0000	2028-01-21	1.3500	1.2500	1.3500	4.7180	10125.00	8100.00	0.00	75	5	278	6428	0.0432482887367766	1.05218956295572	1.05218956295572	false	false	false	true
44817cf7-0a71-492e-a1a5-4aad64b3c69c	2026-09-02 13:18	2026-09-02 13:18	2026-09-02 13:18	FRMI	FRMI270617C00007000	call	7.0000	2027-06-17	1.2500	1.1000	1.2500	4.5799	25000.00	25000.00	0.00	200	8	312	655	0.476335877862595	1.14077590600427	1.14077590600427	false	false	false	true
47167975-66cb-4222-8b41-d510e5524f84	2026-09-02 11:25	2026-09-02 11:24	2026-09-02 11:24	FRMI	FRMI270617C00012000	call	12.0000	2027-06-17	0.6000	0.6000	0.6500	4.5399	60000.00	0.00	60000.00	1000	13	1016	1034	0.982591876208897	1.10650385192663	1.10650385192663	true	false	false	true
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
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
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