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.

474,253 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts474,253 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:endpoint = /api/option-trades/flow-alerts×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	expiry

4038a592-4b19-4796-8587-661d5b3e7632	2026-09-25 14:38	2026-09-25 14:38	2026-09-25 14:38	FRMI	FRMI270219C00005000	call	5.0000	2027-02-19	1.0000	1.0000	1.0500	4.4900	29500.00	0.00	29500.00	295	9	523	351	1.49002849002849	1.02649428180442	1.02649428180442	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Real Estate	2894912413.00	2026-11-09	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-25T18:38:37.498256Z"}	2026-09-25	2026-09-25 21:15	2026-09-25 21:15
96fd7b28-f5ec-47e5-9e37-b9722e9fb1e8	2026-09-25 11:51	2026-09-25 11:51	2026-09-25 11:51	FRMI	FRMI270219C00005000	call	5.0000	2027-02-19	1.0000	1.0000	1.0500	4.0000	17400.00	0.00	17400.00	174	10	174	351	0.495726495726496	1.02906599938519	1.02906599938519	false	false	false	true
d66b29c0-1d25-43c0-be27-9ae9c1aaad9f	2026-09-25 11:26	2026-09-25 11:25	2026-09-25 11:25	FRMI	FRMI261023C00005000	call	5.0000	2026-10-23	0.3400	0.3000	0.3500	4.0000	34000.00	34000.00	0.00	1000	6	1000	332	3.01204819277108	1.03865612054034	1.03865612054034	false	false	false	true
4c0b0002-8c86-4b29-b108-8a7d0bc6ee8c	2026-09-24 15:58	2026-09-24 15:58	2026-09-24 15:58	FRMI	FRMI270617C00005000	call	5.0000	2027-06-17	1.5000	1.4500	1.5500	4.0000	12000.00	0.00	0.00	80	11	160	389	0.411311053984576	1.04914314463918	1.04914314463918	true	false	false	true
f7a2f9d5-10c5-4058-a655-4fa1f644d151	2026-09-24 15:55	2026-09-24 15:55	2026-09-24 15:55	FRMI	FRMI280121C00005000	call	5.0000	2028-01-21	1.9500	1.9500	2.0500	4.5450	23400.00	0.00	23400.00	120	14	705	3578	0.197037451089994	1.00656487794384	1.00656487794384	false	false	false	true
74891bb9-94ad-4c9e-9e01-2fd1b2b46314	2026-09-24 13:18	2026-09-24 13:18	2026-09-24 13:18	FRMI	FRMI281215C00005000	call	5.0000	2028-12-15	2.5500	2.4500	2.5500	4.6499	11475.00	11475.00	0.00	45	5	153	1016	0.150590551181102	0.990709104519341	0.990709104519341	false	false	false	true
0abddd06-5d5c-4dde-8439-c9787cdead05	2026-09-24 12:43	2026-09-24 12:43	2026-09-24 12:43	FRMI	FRMI261218P00004000	put	4.0000	2026-12-18	0.5900	0.5000	0.6000	4.5850	236000.00	192000.00	0.00	4000	2	6418	12620	0.508557844690967	1.07986172925815	1.01424853769724	false	true	false	true
b97ba1e5-c57b-4f84-8a17-5d34b7667a82	2026-09-24 11:11	2026-09-24 11:11	2026-09-24 11:11	FRMI	FRMI261023P00004500	put	4.5000	2026-10-23	0.4000	0.3500	0.4500	4.0000	10240.00	2600.00	0.00	256	5	455	1318	0.345220030349014	0.892755305420156	0.892755305420156	false	false	false	true
4383ad19-e9ba-444a-8dbc-fe5e0779bd5b	2026-09-24 09:49	2026-09-24 09:49	2026-09-24 09:49	FRMI	FRMI280121C00010000	call	10.0000	2028-01-21	1.2000	1.2000	1.3500	4.7400	40560.00	0.00	40560.00	338	6	340	12200	0.0278688524590164	0.999794367974539	0.999794367974539	false	false	false	true
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
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
b1a34690-012a-449d-a308-f418ea4c0c41	2026-09-21 15:38	2026-09-21 15:38	2026-09-21 15:38	FRMI	FRMI261218P00005000	put	5.0000	2026-12-18	0.9700	0.9000	1.0500	5.0950	10128.00	10128.00	0.00	104	5	133	18540	0.00717367853290183	1.0805826237467	1.07004152984395	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
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
0303bdfc-0655-4e0c-b428-bd510a222f93	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.7050	13104.00	13104.00	0.00	245	6	954	10011	0.0952951753071621	1.16457153463856	1.16457153463856	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
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
39b9a83d-7456-4954-bc1a-84110eba6d7f	2026-09-15 09:40	2026-09-15 09:39	2026-09-15 09:39	FRMI	FRMI261120C00008000	call	8.0000	2026-11-20	0.3000	0.2500	0.4000	5.0250	22742.00	0.00	22742.00	750	6	750	6051	0.123946455131383	1.18661757735279	1.18661757735279	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
f32c3245-c606-43ba-a9bc-a33dca2cc738	2026-09-10 11:26	2026-09-10 11:26	2026-09-10 11:26	FRMI	FRMI280121C00017500	call	17.5000	2028-01-21	1.1500	0.9500	1.1500	5.4250	11470.00	11470.00	0.00	100	14	100	4118	0.0242836328314716	1.10498119143437	1.09278917067329	false	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
301d2ed0-7f36-4f69-a1b7-5010ed579bad	2026-09-09 11:26	2026-09-09 11:26	2026-09-09 11:26	FRMI	FRMI270219C00007000	call	7.0000	2027-02-19	1.3000	1.2000	1.3000	5.5150	64800.00	64800.00	0.00	500	9	1050	1484	0.707547169811321	1.1876066306784	1.16023253591812	false	false	false	true
8e2180ef-8856-4562-8d9c-6d69fa7d6ecc	2026-09-08 15:44	2026-09-08 15:44	2026-09-08 15:44	FRMI	FRMI261016C00008000	call	8.0000	2026-10-16	0.2500	0.2500	0.3000	5.7714	13761.00	0.00	13761.00	550	7	724	6428	0.112632233976353	1.14253854419085	1.12535372919734	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
a9ddde04-ceb1-47b9-8cb1-4010de7e5444	2026-09-08 12:15	2026-09-08 12:15	2026-09-08 12:15	FRMI	FRMI261218C00005000	call	5.0000	2026-12-18	1.6900	1.4500	1.8000	5.7750	25324.00	25324.00	0.00	150	9	172	1542	0.111543450064851	1.12372043971877	1.12372043971877	false	false	false	true
14905f21-4e1d-4cac-b500-48c2c6ea7aa5	2026-09-08 12:02	2026-09-08 12:01	2026-09-08 12:01	FRMI	FRMI261016C00005000	call	5.0000	2026-10-16	1.1600	1.1500	1.3000	5.7900	18025.00	0.00	18025.00	155	7	263	915	0.287431693989071	0.970681710625158	1.03601433585135	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
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
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
4a74be8e-5763-4e00-9419-d1b1e99310b6	2026-09-04 12:36	2026-09-04 12:36	2026-09-04 12:36	FRMI	FRMI260911C00005000	call	5.0000	2026-09-11	0.2400	0.2000	0.3000	4.9850	12584.00	150.00	2434.00	520	8	565	367	1.53950953678474	0.927748220546385	0.927748220546385	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