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

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

a9e24981-3b3c-4554-9882-d8fefae28165	2026-09-17 09:58	2026-09-17 09:58	2026-09-17 09:58	FRO	FRO261016C00055000	call	55.0000	2026-10-16	1.6500	1.6500	1.8000	54.2200	19800.00	0.00	19800.00	120	5	210	12565	0.0167130919220056	0.316275760782016	0.316275760782016	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Energy	12028314693.00	2026-11-20	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-17T14:07:38.635762Z"}	2026-09-17	2026-09-17 21:15	2026-09-17 21:15
c0c6d401-3e64-452f-a225-557d82dd48ea	2026-09-17 09:35	2026-09-17 09:35	2026-09-17 09:35	FRO	FRO261120P00050000	put	50.0000	2026-11-20	3.2300	3.2000	3.4000	53.9100	16175.00	0.00	16175.00	50	5	482	3241	0.148719531008948	0.590732271591526	0.589499299610806	false	false	false	true
10543607-060f-461a-b939-5fd40b14daa3	2026-09-17 09:35	2026-09-17 09:34	2026-09-17 09:34	FRO	FRO261120P00050000	put	50.0000	2026-11-20	3.2200	3.2000	3.4000	53.9300	15802.00	0.00	15802.00	49	5	432	3241	0.133292193767356	0.589063270510117	0.590296722365363	false	false	false	true
f4f3db6f-8f9f-4187-9020-3dfc9b7b32d5	2026-09-17 09:34	2026-09-17 09:34	2026-09-17 09:34	FRO	FRO261120P00050000	put	50.0000	2026-11-20	3.2800	2.9500	3.3000	54.1150	19685.00	19685.00	0.00	60	18	334	3241	0.103054612773835	0.605037471980043	0.601334571390969	false	false	false	true
619603b6-4bec-4afc-a937-7948bd6d82f7	2026-09-17 09:34	2026-09-17 09:34	2026-09-17 09:34	FRO	FRO261120P00050000	put	50.0000	2026-11-20	3.3000	3.1000	3.4000	54.1200	17183.00	11893.00	4950.00	52	22	228	3241	0.07034865782166	0.619980877806266	0.604000813962584	false	false	false	true
1ad73910-0b3f-4155-8b80-cd7b0f7e4e9c	2026-09-17 09:34	2026-09-17 09:34	2026-09-17 09:34	FRO	FRO261120P00050000	put	50.0000	2026-11-20	3.4000	2.9500	3.4000	54.1200	10528.00	10528.00	0.00	31	14	259	3241	0.0799136069114471	0.618793810343848	0.618793810343848	false	false	false	true
3ac2e184-815e-42a0-8583-2529bae3c31c	2026-09-17 09:34	2026-09-17 09:34	2026-09-17 09:34	FRO	FRO261120P00050000	put	50.0000	2026-11-20	3.3000	3.1000	3.6000	54.1719	25080.00	15840.00	9240.00	76	15	176	3241	0.0543042270904042	0.608515512267406	0.608515512267406	false	false	false	true
8eabfe1c-823e-4d73-96c9-b8e24410b1d6	2026-09-17 09:34	2026-09-17 09:34	2026-09-17 09:34	FRO	FRO261120P00050000	put	50.0000	2026-11-20	3.3000	3.3000	3.7000	54.1100	16502.00	0.00	16502.00	50	5	100	3241	0.0308546744831842	0.607307198108852	0.607307198108852	false	false	false	true
be290030-1ab9-4e26-899c-bf5f8d1795a2	2026-09-16 13:51	2026-09-16 13:51	2026-09-16 13:51	FRO	FRO261016C00050000	call	50.0000	2026-10-16	4.5100	4.2000	5.0000	54.0000	112630.00	67950.00	44680.00	250	5	2989	3829	0.780621572212066	0.151137563435241	0.314660303993787	false	false	false	true
f06c5dad-4221-4bbb-84cc-85b496b7e1bf	2026-09-16 13:24	2026-09-16 13:24	2026-09-16 13:24	FRO	FRO261016C00050000	call	50.0000	2026-10-16	4.5000	4.2000	5.1000	54.3737	167850.00	67500.00	100350.00	373	5	2732	3829	0.713502219900757	0.152056989184446	0.352274281206428	false	false	false	true
cdadf7dd-7513-4d62-af4a-c85c9407909e	2026-09-16 12:16	2026-09-16 12:16	2026-09-16 12:16	FRO	FRO261016C00055000	call	55.0000	2026-10-16	1.8500	1.8000	1.9500	54.3011	11840.00	0.00	11840.00	64	14	5136	7906	0.649633189982292	0.336724407113031	0.336724407113031	true	false	false	true
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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