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:ticker = FRO×

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

90a9757b-8279-4426-99ba-328c2376c618	2026-09-16 11:43	2026-09-16 11:43	2026-09-16 11:43	FRO	FRO261016C00055000	call	55.0000	2026-10-16	1.8600	1.6500	1.8500	54.1450	558000.00	558000.00	0.00	3000	2	4897	7906	0.619402985074627	0.348704097525224	0.348704097525224	false	true	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Energy	11948170453.00	2026-11-20	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-16T16:04:58.541898Z"}	2026-09-16	2026-09-16 21:15	2026-09-16 21:15
5e7bf1f6-e316-43d6-bba6-13ebc039c3a1	2026-09-16 11:43	2026-09-16 11:42	2026-09-16 11:42	FRO	FRO261016C00055000	call	55.0000	2026-10-16	1.8500	1.6500	1.8500	54.0400	92491.00	92491.00	0.00	500	26	1897	7906	0.239944346066279	0.356662100504215	0.356662100504215	false	false	false	true	false
db9150d9-abfc-401a-8529-39173300d075	2026-09-16 11:42	2026-09-16 11:42	2026-09-16 11:42	FRO	FRO261016C00055000	call	55.0000	2026-10-16	1.8500	1.6500	1.8500	54.0300	18500.00	18500.00	0.00	100	9	1397	7906	0.176701239564887	0.3574160587838	0.3574160587838	false	false	false	true	false
4eb39521-56d4-4f55-9cd5-55cbda6e177d	2026-09-16 11:42	2026-09-16 11:42	2026-09-16 11:42	FRO	FRO261120C00050000	call	50.0000	2026-11-20	5.1000	4.9000	5.5000	54.0600	131070.00	19890.00	107610.00	257	19	292	15437	0.0189155924078513	0.252177667113395	0.254718471939395	false	false	false	true	false
af414527-05af-4f44-b303-061b87732e5d	2026-09-16 11:34	2026-09-16 11:34	2026-09-16 11:34	FRO	FRO270115P00050000	put	50.0000	2027-01-15	5.8000	5.6000	5.8000	53.9700	11600.00	11600.00	0.00	20	7	41	815	0.0503067484662577	0.671541558848211	0.671541558848211	false	false	false	true	false
468c77fe-a1ad-4d1f-94b3-a6e432cfb4db	2026-09-16 10:31	2026-09-16 10:30	2026-09-16 10:30	FRO	FRO280121P00045000	put	45.0000	2028-01-21	8.7000	8.7000	9.8000	53.0000	40910.00	0.00	40910.00	47	17	58	230	0.252173913043478	0.631468085303452	0.631468085303452	false	false	false	true	false
f7eff75d-800d-4bd7-999d-e710cbe8d9e7	2026-09-16 10:31	2026-09-16 10:30	2026-09-16 10:30	FRO	FRO261016C00050000	call	50.0000	2026-10-16	3.8000	3.8000	4.0000	53.0000	86260.00	0.00	86260.00	227	15	663	3829	0.173152259075477	0.201623291248918	0.201623291248918	false	false	false	true	false
a0f6941f-e5b4-4d24-a79e-fc5bb933dbbf	2026-09-16 10:30	2026-09-16 10:30	2026-09-16 10:30	FRO	FRO261016C00050000	call	50.0000	2026-10-16	4.0000	4.0000	4.2000	53.0000	11601.00	0.00	11601.00	29	8	436	3829	0.113867850613737	0.146175131934318	0.146175131934318	false	false	false	true	false
7ff1a9b5-f2bb-4e10-bee4-26b99ebddb55	2026-09-16 10:11	2026-09-16 10:11	2026-09-16 10:11	FRO	FRO270115C00050000	call	50.0000	2027-01-15	5.8000	5.4000	6.0000	53.6800	11600.00	9860.00	1740.00	20	5	34	3789	0.0089733438902085	0.266430586701516	0.266430586701516	false	false	false	true	false
e8856801-4384-42a7-9426-fb53abb0484a	2026-09-15 15:32	2026-09-15 15:32	2026-09-15 15:32	FRO	FRO261120C00055000	call	55.0000	2026-11-20	1.9100	1.9000	2.0000	51.6400	114742.00	0.00	114742.00	600	6	768	6026	0.12744772651842	0.354603037504376	0.354603037504376	false	false	false	true	false
e0960ebf-a591-4595-886c-0fa18fea4ea7	2026-09-15 12:17	2026-09-15 12:17	2026-09-15 12:17	FRO	FRO270115C00055000	call	55.0000	2027-01-15	3.0000	2.8500	3.0000	51.5200	101400.00	101400.00	0.00	338	35	938	1732	0.541570438799076	0.346668280983422	0.346668280983422	false	false	false	true	false
756c26cb-99ea-45bd-83a4-8dd2d13fe82a	2026-09-15 11:13	2026-09-15 11:13	2026-09-15 11:13	FRO	FRO270115P00040000	put	40.0000	2027-01-15	1.9500	1.5500	2.0500	52.5200	33540.00	390.00	33150.00	172	6	585	5398	0.108373471656169	0.620372237981395	0.620372237981395	false	false	false	true	false
c5c4536e-4351-4e0f-b9a8-5e55a06859eb	2026-09-15 11:02	2026-09-15 11:02	2026-09-15 11:02	FRO	FRO261016P00048000	put	48.0000	2026-10-16	1.8500	1.6500	1.9500	52.0000	121142.00	120957.00	185.00	655	48	659	59	11.1694915254237	0.651724092467108	0.651724092467108	false	false	false	true	false
4cc3bf11-a7bb-42ad-93b0-927b15250983	2026-09-15 10:51	2026-09-15 10:51	2026-09-15 10:51	FRO	FRO280121P00040000	put	40.0000	2028-01-21	6.8000	6.8000	7.0000	52.8300	24480.00	0.00	24480.00	36	5	36	319	0.112852664576803	0.642674900473628	0.642674900473628	false	false	false	true	false
64794090-e159-434c-a8cd-8e699153b974	2026-09-15 10:25	2026-09-15 10:25	2026-09-15 10:25	FRO	FRO280121P00035000	put	35.0000	2028-01-21	4.7900	4.3000	7.0000	52.7300	17740.00	940.00	16800.00	37	12	47	500	0.094	0.643671658364168	0.630066138885805	true	false	false	true	false
8b5e16fe-c077-41a1-81b0-b10d81fdb878	2026-09-15 09:54	2026-09-15 09:53	2026-09-15 09:53	FRO	FRO270115P00040000	put	40.0000	2027-01-15	2.0500	1.8500	2.0500	52.5900	75850.00	75850.00	0.00	370	39	371	5398	0.0687291589477584	0.635138293457651	0.635138293457651	false	false	false	true	false
7f43ecbb-b97b-42f7-a7b6-96c250f418a8	2026-09-15 09:35	2026-09-15 09:35	2026-09-15 09:35	FRO	FRO261120C00050000	call	50.0000	2026-11-20	3.7000	3.7000	3.9000	51.6100	55500.00	0.00	55500.00	150	10	152	15426	0.00985349410086866	0.301895178001277	0.301895178001277	false	false	false	true	false
7167068e-f057-41c7-8475-1f59997684af	2026-09-14 14:35	2026-09-14 14:35	2026-09-14 14:35	FRO	FRO261016P00045000	put	45.0000	2026-10-16	1.3500	1.2000	1.3500	50.5650	32119.00	32119.00	0.00	238	35	274	357	0.76750700280112	0.621112980923369	0.621112980923369	false	false	false	true	false
093b7140-3223-4e4f-bb26-043a30365fb9	2026-09-14 14:21	2026-09-14 14:20	2026-09-14 14:20	FRO	FRO260918P00055000	put	55.0000	2026-09-18	7.1200	7.0000	9.2000	50.4850	17800.00	0.00	17800.00	25	5	38	689	0.0551523947750363	2.04968526656121	2.09906504702673	false	false	false	true	false
9b93a2d9-7a7b-4a3c-8913-7b6373d6a095	2026-09-14 12:48	2026-09-14 12:48	2026-09-14 12:48	FRO	FRO260918C00045000	call	45.0000	2026-09-18	4.8000	4.8000	5.3000	49.9699	28805.00	0.00	28805.00	60	12	106	1686	0.062870699881376	0.913341620029338	0.629629103560168	false	false	false	true	false
0e6e2f1c-1fed-49bb-82df-39b6f3b9633a	2026-09-14 12:48	2026-09-14 12:48	2026-09-14 12:48	FRO	FRO261016C00045000	call	45.0000	2026-10-16	4.8000	4.8000	5.4000	49.9699	114248.00	0.00	114248.00	238	15	326	253	1.28853754940711	0.315969698120616	0.241969144968069	false	false	false	true	false
093d95e0-8bd0-4a32-930e-8cbc3e1b6ae0	2026-09-14 12:48	2026-09-14 12:48	2026-09-14 12:48	FRO	FRO260918C00043000	call	43.0000	2026-09-18	6.8000	6.8000	7.4000	49.9699	223720.00	0.00	223720.00	329	22	350	2072	0.168918918918919	1.28595671025118	0.784159177470511	false	false	false	true	false
39576a27-9350-467b-8311-e9cee705f5c8	2026-09-14 12:34	2026-09-14 12:33	2026-09-14 12:33	FRO	FRO261120C00055000	call	55.0000	2026-11-20	1.4500	1.3500	1.4500	50.1800	17658.00	17658.00	0.00	122	19	315	5818	0.0541423169474046	0.350543640537961	0.355779610780501	false	false	false	true	false
96e85b08-b4a8-4569-aa59-d03d561b8a4b	2026-09-14 10:04	2026-09-14 10:04	2026-09-14 10:04	FRO	FRO270115C00045000	call	45.0000	2027-01-15	6.3000	5.7000	6.4000	50.0500	679768.00	679138.00	630.00	1079	45	1105	2382	0.463895885810243	0.254236365422228	0.238040751901843	false	false	false	true	false
109e55a6-4d6d-42c5-82d3-46cfafe5a09e	2026-09-14 10:04	2026-09-14 10:04	2026-09-14 10:04	FRO	FRO270115C00060000	call	60.0000	2027-01-15	1.5000	1.0500	1.6500	50.0500	62100.00	60300.00	1800.00	414	27	417	288	1.44791666666667	0.381519599645646	0.377292022171306	false	false	false	true	false
d85f3cb4-33e2-4e39-9d41-a27e519ef80a	2026-09-11 15:45	2026-09-11 15:44	2026-09-11 15:44	FRO	FRO270115C00045000	call	45.0000	2027-01-15	5.5000	5.3000	5.5000	48.8500	30800.00	30800.00	0.00	56	16	84	2318	0.0362381363244176	0.246482904424272	0.246482904424272	false	false	false	true	false
5805ed70-de28-4a5a-8d42-c6029222c813	2026-09-11 15:04	2026-09-11 15:04	2026-09-11 15:04	FRO	FRO270115C00050000	call	50.0000	2027-01-15	3.2000	3.1000	3.2000	48.4850	24000.00	24000.00	0.00	75	11	1759	1967	0.89425521098119	0.3140457522	0.3140457522	false	false	false	true	false
39fb96a2-e086-481f-a554-2c9345fc7a5b	2026-09-11 14:41	2026-09-11 14:41	2026-09-11 14:41	FRO	FRO261120P00043000	put	43.0000	2026-11-20	2.3000	2.1500	2.3500	48.5050	21390.00	20930.00	0.00	93	19	94	398	0.236180904522613	0.584447304106831	0.584447304106831	false	false	false	true	false
23266ec4-1a9b-4720-8ce9-666fb7fee9bd	2026-09-11 13:00	2026-09-11 13:00	2026-09-11 13:00	FRO	FRO261120C00050000	call	50.0000	2026-11-20	2.5000	2.4000	2.6000	48.9850	44500.00	0.00	4500.00	178	5	1135	15344	0.0739702815432742	0.327401538477595	0.327401538477595	true	false	false	true	false
48e3460c-de3b-4a85-bbcb-b8f986e59568	2026-09-11 12:45	2026-09-11 12:44	2026-09-11 12:44	FRO	FRO270115C00050000	call	50.0000	2027-01-15	3.4000	3.2000	3.4000	49.0600	502520.00	502520.00	0.00	1478	34	1629	1967	0.828164717844433	0.305748528648781	0.305748528648781	false	false	false	true	false
a6274896-8cc3-4944-bf0a-b0f3eb57b63a	2026-09-11 11:45	2026-09-11 11:45	2026-09-11 11:45	FRO	FRO261120C00050000	call	50.0000	2026-11-20	2.4000	2.3500	2.4000	48.9400	47040.00	47040.00	0.00	196	9	895	15344	0.0583289885297185	0.318280505178855	0.318280505178855	false	false	false	true	false
f64c4351-8a20-4f2d-9eae-af41c69f6d32	2026-09-11 10:18	2026-09-11 10:18	2026-09-11 10:18	FRO	FRO280121P00040000	put	40.0000	2028-01-21	8.1000	7.2000	9.4000	49.4000	81000.00	0.00	81000.00	100	10	100	321	0.311526479750779	0.671245422212406	0.671245422212406	false	false	false	true	false
766353b0-5083-476a-bfb6-769ac8663caf	2026-09-11 10:12	2026-09-11 10:12	2026-09-11 10:12	FRO	FRO280121P00035000	put	35.0000	2028-01-21	4.4000	3.2000	4.4000	49.3800	18920.00	16720.00	0.00	43	8	43	450	0.0955555555555556	0.575988367646315	0.575988367646315	false	false	false	true	false
91eb3cae-789c-4404-b4f8-6705f9fa85b0	2026-09-11 10:11	2026-09-11 10:11	2026-09-11 10:11	FRO	FRO261120C00050000	call	50.0000	2026-11-20	2.5400	2.5000	2.7000	49.4200	25410.00	0.00	25410.00	100	5	177	15344	0.0115354535974974	0.307807255471494	0.306648410692782	false	false	false	true	false
3bc4e7d9-6733-4195-8e4c-03a788bdfd31	2026-09-11 09:44	2026-09-11 09:44	2026-09-11 09:44	FRO	FRO260918P00049000	put	49.0000	2026-09-18	2.8800	2.6500	4.1000	49.0600	14396.00	0.00	14396.00	50	5	50	16	3.125	1.08585257238028	1.08585257238028	false	false	false	true	false
3b5a6d38-c0ac-450d-910b-a782606d3e9b	2026-09-11 09:39	2026-09-11 09:39	2026-09-11 09:39	FRO	FRO261120C00045000	call	45.0000	2026-11-20	4.7000	4.3000	4.8000	48.9200	187526.00	187056.00	470.00	399	40	409	2148	0.190409683426443	0.231012687153587	0.227966351560508	false	false	false	true	false
37517295-bc46-433d-b9de-13c41c614eff	2026-09-10 15:11	2026-09-10 15:11	2026-09-10 15:11	FRO	FRO261120C00050000	call	50.0000	2026-11-20	2.1000	2.0000	2.1000	48.3500	21210.00	21210.00	0.00	101	9	630	15344	0.0410583941605839	0.31307134728515	0.31307134728515	false	false	false	true	false
9b305a67-9ed1-4c00-afa1-2bfda656a632	2026-09-10 12:31	2026-09-10 12:31	2026-09-10 12:31	FRO	FRO261120C00045000	call	45.0000	2026-11-20	4.3000	4.1000	4.5000	48.4084	29670.00	13330.00	16340.00	69	7	342	2106	0.162393162393162	0.228807014538662	0.228807014538662	false	false	false	true	false
5c6b0158-5d52-42c8-81fd-66ddf1ff12db	2026-09-10 12:30	2026-09-10 12:30	2026-09-10 12:30	FRO	FRO261120C00045000	call	45.0000	2026-11-20	4.3000	3.9000	4.5000	48.4600	85570.00	13760.00	58480.00	199	22	273	2106	0.12962962962963	0.221730300625277	0.221730300625277	false	false	false	true	false
f34e9ab0-0e39-4982-9edb-47506546e4d7	2026-09-10 11:42	2026-09-10 11:42	2026-09-10 11:42	FRO	FRO270219C00046000	call	46.0000	2027-02-19	4.7000	4.6000	5.1000	48.0100	12690.00	8930.00	3760.00	27	6	30	58	0.517241379310345	0.253763259773385	0.253763259773385	false	false	false	true	false
172b48d1-545f-4467-a51f-353355e40223	2026-09-10 11:25	2026-09-10 11:25	2026-09-10 11:25	FRO	FRO270115C00050000	call	50.0000	2027-01-15	2.8500	2.7000	2.9500	48.0600	70110.00	69255.00	285.00	246	26	280	1742	0.160734787600459	0.303366774952076	0.302945752127952	false	false	false	true	false
50e9ebba-41d0-4c8f-b816-923c3934bba1	2026-09-10 11:00	2026-09-10 11:00	2026-09-10 11:00	FRO	FRO261120P00050000	put	50.0000	2026-11-20	6.1200	5.8000	7.4000	48.2650	30602.00	0.00	30602.00	50	12	150	3117	0.0481231953801732	0.631798512517712	0.631798512517712	false	false	false	true	false
e7719708-322e-4adb-b476-1f178dc9de9c	2026-09-10 10:59	2026-09-10 10:59	2026-09-10 10:59	FRO	FRO261120P00050000	put	50.0000	2026-11-20	6.1400	5.9000	7.4000	48.3050	30716.00	0.00	30716.00	50	14	50	3117	0.0160410651267244	0.637611673998861	0.637611673998861	false	false	false	true	false
bd796c0e-f64e-427b-87d3-443ad5ba43c8	2026-09-10 10:05	2026-09-10 10:05	2026-09-10 10:05	FRO	FRO261120C00050000	call	50.0000	2026-11-20	1.7000	1.6000	1.9000	47.2700	25500.00	5100.00	20400.00	150	16	207	15344	0.0134906152241919	0.319710056639342	0.319710056639342	false	false	false	true	false
5822bb44-ee05-4ac2-a355-3be7dc267ccb	2026-09-09 13:18	2026-09-09 13:18	2026-09-09 13:18	FRO	FRO260918C00042000	call	42.0000	2026-09-18	5.4000	5.0000	5.4000	47.3100	41580.00	41580.00	0.00	77	6	79	1413	0.0559094125973107	0.438585188420357	0.438585188420357	false	false	false	true	false
1042b38a-7435-481e-85ab-0c101d07e8a6	2026-09-09 13:18	2026-09-09 13:18	2026-09-09 13:18	FRO	FRO270115C00045000	call	45.0000	2027-01-15	4.3000	4.0000	4.5000	47.3100	198230.00	197800.00	430.00	461	18	479	1952	0.245389344262295	0.23748380869976	0.23748380869976	false	false	false	true	false
1b157218-1e59-4a98-b8ec-88b0734c1a09	2026-09-09 11:31	2026-09-09 11:31	2026-09-09 11:31	FRO	FRO260918C00050000	call	50.0000	2026-09-18	0.3500	0.1500	0.4500	47.0500	34125.00	1750.00	32375.00	975	27	983	1726	0.569524913093859	0.438381559501992	0.436446004809603	false	false	false	true	false
50c25735-7537-4912-879c-c27153edb6f6	2026-09-09 10:30	2026-09-09 10:30	2026-09-09 10:30	FRO	FRO261120C00050000	call	50.0000	2026-11-20	1.6000	1.4000	1.6500	46.0000	63680.00	63040.00	160.00	398	16	524	15249	0.0343629090432159	0.31984027288587	0.31984027288587	false	false	false	true	false
75bc01b7-2808-4f47-aa7c-3ccfd7b33677	2026-09-09 10:24	2026-09-09 10:24	2026-09-09 10:24	FRO	FRO261120P00042000	put	42.0000	2026-11-20	2.2500	2.2500	2.8000	46.0000	11250.00	0.00	11250.00	50	9	100	677	0.147710487444609	0.553682753596829	0.553682753596829	false	false	false	true	false
38b4c61f-9ec1-4c35-9e45-fe2b504da30b	2026-09-09 09:45	2026-09-09 09:45	2026-09-09 09:45	FRO	FRO270219C00048000	call	48.0000	2027-02-19	3.1000	3.0000	3.7000	46.4700	10540.00	5270.00	5270.00	34	7	260	58	4.48275862068965	0.275192054751936	0.275192054751936	false	false	false	true	false