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

4fdb1aa1-8477-4016-997c-405354af8c23	2026-09-08 11:28	2026-09-08 11:28	2026-09-08 11:28	FRO	FRO270219C00050000	call	50.0000	2027-02-19	2.5000	2.4500	2.8000	46.1800	12250.00	0.00	11000.00	49	21	209	256	0.81640625	0.297844069987077	0.297844069987077	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Energy	11246908352.00	2026-11-20	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-08T15:43:32.720264Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
6e0e2f0e-f18b-4fd1-8e46-430e02ea3226	2026-09-08 11:00	2026-09-08 11:00	2026-09-08 11:00	FRO	FRO280121C00045000	call	45.0000	2028-01-21	6.2300	6.2000	7.2000	46.2400	31126.00	0.00	31126.00	50	10	365	216	1.68981481481481	0.199121807574948	0.199121807574948	false	false	false	true	false
bc129998-1753-41a6-93bf-d36ba2465fa3	2026-09-08 09:57	2026-09-08 09:57	2026-09-08 09:57	FRO	FRO261120C00045000	call	45.0000	2026-11-20	3.1000	2.8500	3.1000	46.2400	34720.00	34720.00	0.00	112	26	115	2042	0.0563173359451518	0.274738689126907	0.274738689126907	false	false	false	true	false
c09eb0bb-78fd-45ff-a2e8-7a7ccc3e4622	2026-09-04 10:46	2026-09-04 10:46	2026-09-04 10:46	FRO	FRO260918C00046000	call	46.0000	2026-09-18	1.9000	1.9000	2.0500	46.9001	24130.00	0.00	24130.00	127	20	287	4411	0.0650646111992745	0.375613545879145	0.375613545879145	false	false	false	true	false
c71142fd-faba-4002-997e-25ef73271397	2026-09-04 09:47	2026-09-04 09:47	2026-09-04 09:47	FRO	FRO260918C00040000	call	40.0000	2026-09-18	6.8000	6.8000	7.2000	46.6800	25840.00	0.00	25840.00	38	10	223	1616	0.137995049504951	0.453664201970285	0.453664201970285	true	false	false	true	false
28e2ef12-cd53-434a-920a-35e11ffa207f	2026-09-04 09:47	2026-09-04 09:47	2026-09-04 09:47	FRO	FRO260918C00040000	call	40.0000	2026-09-18	6.8000	6.8000	7.2000	46.6900	111520.00	0.00	111520.00	164	18	185	1616	0.114480198019802	0.439600464973155	0.439600464973155	false	false	false	true	false
d9b69d09-f002-41ab-ad27-d89866d8e977	2026-09-01 13:51	2026-09-01 13:51	2026-09-01 13:51	FRO	FRO260918C00048000	call	48.0000	2026-09-18	0.5500	0.5500	0.6500	44.7900	11550.00	0.00	11550.00	210	23	222	1469	0.151123213070116	0.418013335390442	0.418013335390442	false	false	false	true	false
0898b542-61ba-4885-806b-a0f7fe4a2dac	2026-09-01 12:15	2026-09-01 12:15	2026-09-01 12:15	FRO	FRO260918C00047000	call	47.0000	2026-09-18	0.7500	0.7500	0.9000	44.6500	44045.00	0.00	44045.00	587	31	588	475	1.23789473684211	0.416379625403852	0.416379625403852	false	false	false	true	false
2097bad1-c43a-41a0-ad85-536c2a61916b	2026-08-31 15:49	2026-08-31 15:49	2026-08-31 15:49	FRO	FRO261016P00036000	put	36.0000	2026-10-16	0.7000	0.5000	0.8000	43.5500	36520.00	36450.00	70.00	522	46	526	105	5.00952380952381	0.568962594974546	0.567328379455504	false	false	false	true	false
1e6e844a-797a-4b46-a15d-4490e247dd34	2026-08-31 15:00	2026-08-31 15:00	2026-08-31 15:00	FRO	FRO260918C00041000	call	41.0000	2026-09-18	3.1000	2.9500	3.2000	43.5553	18910.00	1860.00	930.00	61	15	97	1438	0.0674547983310153	0.376843102593571	0.376843102593571	true	false	false	true	false
59312b38-c78e-44de-87a9-2bfd8f402dd9	2026-08-31 14:56	2026-08-31 14:56	2026-08-31 14:56	FRO	FRO270115C00050000	call	50.0000	2027-01-15	1.6000	1.4000	1.6000	43.6300	16480.00	15680.00	0.00	103	56	105	1463	0.0717703349282297	0.332341769107822	0.332341769107822	false	false	false	true	false
d646337a-4bf0-4c47-a8ef-a890c4baeaf3	2026-08-31 14:09	2026-08-31 14:09	2026-08-31 14:09	FRO	FRO261120P00040000	put	40.0000	2026-11-20	2.5000	2.3500	2.5000	44.0000	29750.00	29750.00	0.00	119	26	123	493	0.249492900608519	0.561949212121262	0.561949212121262	false	false	false	true	false
20b171da-72cc-4cd0-ac75-60d9f8f26372	2026-08-31 10:08	2026-08-31 10:08	2026-08-31 10:08	FRO	FRO261120C00050000	call	50.0000	2026-11-20	1.1500	0.7000	1.1500	44.4600	17250.00	17250.00	0.00	150	31	169	11716	0.0144247183339024	0.345597306451629	0.345597306451629	false	false	false	true	false
1d108ad3-c59f-4532-8a5b-c73ee41405c7	2026-08-31 10:07	2026-08-31 10:07	2026-08-31 10:07	FRO	FRO270115C00045000	call	45.0000	2027-01-15	3.1000	2.6000	3.1000	44.4658	16740.00	16740.00	0.00	54	21	54	1634	0.0330477356181151	0.27954673131668	0.27954673131668	false	false	false	true	false
0afd1e4f-20cc-4dd9-a6f2-394affbe900c	2026-08-31 09:47	2026-08-31 09:47	2026-08-31 09:47	FRO	FRO261120C00055000	call	55.0000	2026-11-20	0.5500	0.4500	0.6000	44.4200	89980.00	880.00	87505.00	1636	45	2505	8311	0.301407772831188	0.379777999758946	0.379777999758946	false	false	false	true	false
8b87f0b3-0909-4c40-b2ef-6a1223f8a2d3	2026-08-31 09:46	2026-08-31 09:45	2026-08-31 09:45	FRO	FRO261120C00055000	call	55.0000	2026-11-20	0.6000	0.5500	0.6500	44.4600	14760.00	12540.00	60.00	246	16	866	8311	0.104199254000722	0.388825108605284	0.388825108605284	false	false	false	true	false
d0248268-d513-4e2e-8604-2157930e4707	2026-08-31 09:45	2026-08-31 09:45	2026-08-31 09:45	FRO	FRO261120C00055000	call	55.0000	2026-11-20	0.5500	0.5000	0.6000	44.3200	11110.00	10340.00	770.00	202	9	608	8311	0.0731560582360727	0.382822358929151	0.382822358929151	false	false	false	true	false
f5075336-d2d6-4c7c-9e21-8661a0d9985c	2026-08-28 14:44	2026-08-28 14:44	2026-08-28 14:44	FRO	FRO260918C00041000	call	41.0000	2026-09-18	3.2100	3.0000	3.4000	43.6950	32080.00	7680.00	17920.00	100	14	240	1198	0.200333889816361	0.342185041925153	0.375357461815618	false	false	false	true	false
1aa64657-ab29-41d4-8759-301e6e940b33	2026-08-28 14:15	2026-08-28 14:15	2026-08-28 14:15	FRO	FRO261120C00055000	call	55.0000	2026-11-20	0.5500	0.5000	0.6500	43.7950	15124.00	488.00	14576.00	275	42	2290	7496	0.305496264674493	0.402013366407713	0.38931793996084	false	false	false	true	false
068c6f2e-9363-4e67-8359-e8f68e087317	2026-08-28 12:01	2026-08-28 12:01	2026-08-28 12:01	FRO	FRO261120C00055000	call	55.0000	2026-11-20	0.5500	0.5500	0.6500	43.0000	33437.00	0.00	33437.00	607	37	1872	7496	0.249733191035219	0.393990549998098	0.393990549998098	false	false	false	true	false
83587bd9-8cbd-40f7-b991-cdfd7dcfd1cb	2026-08-28 11:59	2026-08-28 11:59	2026-08-28 11:59	FRO	FRO280121C00065000	call	65.0000	2028-01-21	2.3000	1.0000	3.1000	43.0000	111780.00	102350.00	9430.00	486	27	487	104	4.68269230769231	0.338308716878159	0.338308716878159	false	false	false	true	false
3d38018f-c72a-4566-99f9-64c8d28e69c2	2026-08-28 10:47	2026-08-28 10:47	2026-08-28 10:47	FRO	FRO261120C00050000	call	50.0000	2026-11-20	1.0500	0.9500	1.0500	43.7000	14910.00	14910.00	0.00	142	6	6768	2190	3.09041095890411	0.35389824421641	0.35389824421641	false	false	false	true	false
b6150cd6-ed2c-4c31-b52e-eab1b12ac52d	2026-08-28 10:46	2026-08-28 10:46	2026-08-28 10:46	FRO	FRO261120C00050000	call	50.0000	2026-11-20	1.0500	0.9500	1.0500	43.6950	16485.00	16485.00	0.00	157	52	6626	2190	3.02557077625571	0.354087929547435	0.354087929547435	false	false	false	true	false
d901e015-45b9-40f4-8c4b-fd7bc26b8e26	2026-08-28 10:46	2026-08-28 10:46	2026-08-28 10:46	FRO	FRO261120C00050000	call	50.0000	2026-11-20	1.0500	0.9500	1.0500	43.7700	10605.00	7245.00	0.00	101	6	6469	2190	2.95388127853881	0.351242148155289	0.351242148155289	false	false	false	true	false
f7206bb4-9982-4be0-826a-54d1dce4af94	2026-08-28 10:43	2026-08-28 10:43	2026-08-28 10:43	FRO	FRO261120C00050000	call	50.0000	2026-11-20	1.0000	0.8500	1.0000	43.7900	201400.00	201400.00	0.00	2014	6	6213	2190	2.83698630136986	0.343060611100809	0.343060611100809	false	false	false	true	false
dee26cce-f7da-49cb-96dd-06814dc0c917	2026-08-28 10:41	2026-08-28 10:41	2026-08-28 10:41	FRO	FRO261120C00050000	call	50.0000	2026-11-20	1.0000	0.8500	1.0000	43.8600	50000.00	50000.00	0.00	500	6	3477	2190	1.58767123287671	0.34043130135098	0.34043130135098	false	false	false	true	false
0ab0d9ee-88d3-49a8-9ae1-62485d51b559	2026-08-28 10:39	2026-08-28 10:39	2026-08-28 10:39	FRO	FRO261120C00050000	call	50.0000	2026-11-20	1.0000	0.8500	1.0000	43.8000	50000.00	50000.00	0.00	500	6	2976	2190	1.35890410958904	0.342685059370616	0.342685059370616	false	false	false	true	false
7198e8f9-3dbd-4081-8068-ce4cb32280ee	2026-08-28 10:39	2026-08-28 10:39	2026-08-28 10:39	FRO	FRO261120C00050000	call	50.0000	2026-11-20	1.0900	0.8500	1.1000	43.7800	23786.00	23786.00	0.00	219	14	2131	2190	0.973059360730594	0.349384228404303	0.358205791905027	false	false	false	true	false
a24b5874-b367-4346-81db-13095951b1ff	2026-08-28 10:39	2026-08-28 10:38	2026-08-28 10:38	FRO	FRO261120C00050000	call	50.0000	2026-11-20	1.1000	0.9500	1.1000	43.9850	110000.00	7700.00	0.00	1000	6	1912	2190	0.873059360730594	0.350341094505428	0.350341094505428	false	false	false	true	false
b1c2b279-a11c-43ee-b326-f021cfd918c0	2026-08-28 10:38	2026-08-28 10:38	2026-08-28 10:38	FRO	FRO261120C00050000	call	50.0000	2026-11-20	1.1000	0.8500	1.1000	44.1500	99000.00	4730.00	0.00	900	6	912	2190	0.416438356164384	0.344003296922915	0.344003296922915	false	false	false	true	false
3ac221d9-2d9c-40c7-9020-813db79616f2	2026-08-28 10:21	2026-08-28 10:21	2026-08-28 10:21	FRO	FRO280121P00045000	put	45.0000	2028-01-21	12.4500	10.1000	12.6000	44.5100	14940.00	12460.00	2480.00	12	6	106	133	0.796992481203007	0.674248191894925	0.671076550261388	true	false	false	true	false
de3b6a22-8989-4c76-9481-3e3eb42ab7b2	2026-08-27 15:52	2026-08-27 15:52	2026-08-27 15:52	FRO	FRO260918C00043000	call	43.0000	2026-09-18	2.1500	1.9000	2.3500	43.7200	31390.00	215.00	31175.00	146	15	290	2188	0.13254113345521	0.40322520716373	0.40322520716373	false	false	false	true	false
f946d0b2-71cc-421e-a0c9-64de0b87a46f	2026-08-27 15:42	2026-08-27 15:42	2026-08-27 15:42	FRO	FRO260918P00043000	put	43.0000	2026-09-18	2.6500	2.6500	2.8500	43.7100	17490.00	0.00	17490.00	66	17	106	518	0.204633204633205	0.716982022885919	0.716982022885919	false	false	false	true	false
60003262-4c29-4b46-afc4-4d8f7b683b6a	2026-08-27 15:16	2026-08-27 15:15	2026-08-27 15:15	FRO	FRO261016P00038000	put	38.0000	2026-10-16	1.1500	1.1500	1.4000	43.0000	14261.00	0.00	14261.00	124	42	127	63	2.01587301587302	0.550793071206964	0.551240221803909	false	false	false	true	false
1d9398c1-a2fc-4463-bed7-ae8bf87bc784	2026-08-27 15:10	2026-08-27 15:09	2026-08-27 15:09	FRO	FRO261120C00060000	call	60.0000	2026-11-20	0.6500	0.3000	0.6500	43.7350	28600.00	28600.00	0.00	440	44	540	8649	0.0624349635796046	0.513594642614827	0.513594642614827	false	false	false	true	false
026a13f2-b44d-4397-898a-805ead9b7011	2026-08-27 14:29	2026-08-27 14:29	2026-08-27 14:29	FRO	FRO261016C00043000	call	43.0000	2026-10-16	2.6000	2.3000	2.8500	43.7800	33554.00	525.00	33029.00	129	36	190	227	0.837004405286344	0.322508944028771	0.322508944028771	true	false	false	true	false
12fb4530-9b0d-4d33-9851-38c5fd44b4b4	2026-08-27 14:25	2026-08-27 14:25	2026-08-27 14:25	FRO	FRO260918C00043000	call	43.0000	2026-09-18	2.2500	2.2000	2.4500	43.7800	15978.00	450.00	15528.00	71	18	132	2188	0.0603290676416819	0.416501810716024	0.418663509558321	true	false	false	true	false
36b9182c-0134-4453-b023-92f0e8da8897	2026-08-27 14:06	2026-08-27 14:06	2026-08-27 14:06	FRO	FRO260918C00044000	call	44.0000	2026-09-18	1.8000	1.7000	2.0000	43.8490	15120.00	180.00	14940.00	84	15	3392	3571	0.949873984878185	0.424902961988548	0.424902961988548	true	false	false	true	false
a50cb181-4be0-4844-8c9e-8ff14b0fc088	2026-08-27 13:26	2026-08-27 13:25	2026-08-27 13:25	FRO	FRO260918C00044000	call	44.0000	2026-09-18	1.7000	1.6500	1.7000	43.7450	14960.00	12410.00	0.00	88	11	259	3571	0.0725287034444133	0.413986598576256	0.413986598576256	false	false	false	true	false
1155963b-6e8e-4ea3-aa1f-65b45883475d	2026-08-27 12:36	2026-08-27 12:36	2026-08-27 12:36	FRO	FRO260918P00040000	put	40.0000	2026-09-18	1.1500	1.1500	1.3000	43.6800	41315.00	0.00	41315.00	359	40	881	1949	0.452026680348897	0.639755435095544	0.639755435095544	false	false	false	true	false
ea2a6e22-5f26-44ae-a428-abad1041c935	2026-08-27 11:23	2026-08-27 11:23	2026-08-27 11:23	FRO	FRO261120P00041000	put	41.0000	2026-11-20	3.4800	2.7500	3.5000	43.4500	17394.00	17394.00	0.00	50	5	200	268	0.746268656716418	0.588513924308938	0.588513924308938	false	false	false	true	false
0925826d-140f-43a4-963c-5cd495532201	2026-08-27 10:45	2026-08-27 10:45	2026-08-27 10:45	FRO	FRO270219C00040000	call	40.0000	2027-02-19	5.8000	5.7000	6.4000	43.7100	21460.00	16820.00	4640.00	37	7	38	58	0.655172413793103	0.267441407404861	0.267441407404861	false	false	false	true	false
9802f42d-4ee7-425d-b0ce-0da7ea7377fe	2026-08-26 15:17	2026-08-26 15:17	2026-08-26 15:17	FRO	FRO260918C00042000	call	42.0000	2026-09-18	1.5500	1.5000	1.8500	41.3200	46965.00	465.00	46500.00	303	15	747	814	0.917690417690418	0.438256937558522	0.438256937558522	false	false	false	true	false
43908d3c-71bd-4bd5-9ca3-1722640df1d0	2026-08-26 15:16	2026-08-26 15:15	2026-08-26 15:15	FRO	FRO260918C00040000	call	40.0000	2026-09-18	2.5000	2.4000	2.9500	41.3100	36745.00	495.00	36250.00	147	19	280	1285	0.217898832684825	0.421428558230912	0.406726665867039	true	false	false	true	false
d04af763-79e9-4b7b-b538-bafe3d98f7a7	2026-08-26 15:13	2026-08-26 15:13	2026-08-26 15:13	FRO	FRO260918C00042000	call	42.0000	2026-09-18	1.5500	1.5000	1.8000	41.3800	23097.00	310.00	22787.00	149	33	414	814	0.508599508599509	0.431380779038181	0.431380779038181	false	false	false	true	false
f2638ed2-767a-45cd-8591-828cc8ad80e7	2026-08-26 15:12	2026-08-26 15:12	2026-08-26 15:12	FRO	FRO261016P00041000	put	41.0000	2026-10-16	3.7000	3.2000	3.8000	41.3650	17020.00	370.00	16650.00	46	17	101	123	0.821138211382114	0.652104886150832	0.652104886150832	false	false	false	true	false
ec12d39e-58ea-426f-b99d-3aae2764a37a	2026-08-26 14:29	2026-08-26 14:29	2026-08-26 14:29	FRO	FRO261120C00043000	call	43.0000	2026-11-20	2.4000	1.8500	3.6000	41.5700	11760.00	10560.00	1200.00	49	8	50	98	0.510204081632653	0.355099116872508	0.355099116872508	false	false	false	true	false
87e2ca41-fb16-45cd-88a1-1b7fb5c81f88	2026-08-26 14:06	2026-08-26 14:06	2026-08-26 14:06	FRO	FRO260918C00041000	call	41.0000	2026-09-18	2.0000	2.0000	2.3000	41.4500	56005.00	0.00	56005.00	280	43	469	773	0.606727037516171	0.415410697338684	0.415410697338684	false	false	false	true	false
f9326aa5-e970-4c55-b0aa-701049015478	2026-08-26 14:00	2026-08-26 14:00	2026-08-26 14:00	FRO	FRO260918C00042000	call	42.0000	2026-09-18	1.6000	1.5000	2.0000	41.4150	12480.00	2080.00	10400.00	78	21	185	814	0.227272727272727	0.438840761642241	0.439420226259656	true	false	false	true	false
c95365b5-0121-479e-a9f6-42cfbf1a14a7	2026-08-26 13:52	2026-08-26 13:52	2026-08-26 13:52	FRO	FRO261016P00041000	put	41.0000	2026-10-16	3.7000	3.1000	5.7000	41.4450	20350.00	370.00	19980.00	55	7	55	123	0.447154471544715	0.657730892611	0.657730892611	false	false	false	true	false