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.

523,327 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts523,327 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 = 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

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	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Energy	11246908352.00	2026-11-20	unknown	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-28T16:07:30.029075Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
fbd0b75c-8985-4d90-a71b-c6b4975e6926	2026-08-26 13:13	2026-08-26 13:13	2026-08-26 13:13	FRO	FRO261120P00025000	put	25.0000	2026-11-20	0.3000	0.0500	0.3000	41.4400	15180.00	15180.00	0.00	506	43	506	253	2	0.697039153344297	0.697039153344297	false	false	false	true
9f086a4c-aa9b-4831-b109-54ee7a1fb440	2026-08-26 12:32	2026-08-26 12:31	2026-08-26 12:31	FRO	FRO260918C00041000	call	41.0000	2026-09-18	2.4500	2.1500	2.8000	42.0800	27931.00	245.00	27686.00	114	17	164	773	0.212160413971539	0.433473669876443	0.433473669876443	true	false	false	true
75feb6d0-5d28-421d-9a8a-505b47fc2c49	2026-08-26 12:20	2026-08-26 12:20	2026-08-26 12:20	FRO	FRO260918C00042000	call	42.0000	2026-09-18	1.9000	1.5000	2.0000	41.9700	11780.00	570.00	11020.00	62	13	103	814	0.126535626535627	0.444252763104997	0.444252763104997	true	false	false	true
f3793680-c193-4b0d-93a4-e409383b29d1	2026-08-26 10:17	2026-08-26 10:17	2026-08-26 10:17	FRO	FRO280121P00045000	put	45.0000	2028-01-21	13.0000	11.5000	14.1000	41.9000	13000.00	10400.00	2600.00	10	5	227	27	8.40740740740741	0.654274985748391	0.654274985748391	false	false	false	true
4e78ac9e-a873-4c65-b247-dab8278f7beb	2026-08-26 10:14	2026-08-26 10:14	2026-08-26 10:14	FRO	FRO270115P00040000	put	40.0000	2027-01-15	5.2000	4.6000	5.7000	41.8600	11440.00	2080.00	9360.00	22	7	73	4878	0.0149651496514965	0.633320810791347	0.633320810791347	false	false	false	true
d8fd6d31-d307-459b-8efa-40bd66da8fe3	2026-08-26 10:06	2026-08-26 10:06	2026-08-26 10:06	FRO	FRO270115P00040000	put	40.0000	2027-01-15	5.3000	3.9000	5.7000	41.6900	11130.00	1590.00	9540.00	21	8	21	4878	0.0043050430504305	0.637206317906948	0.637206317906948	false	false	false	true
96f7a889-22aa-455f-b515-63c4c8161f60	2026-08-26 09:50	2026-08-26 09:50	2026-08-26 09:50	FRO	FRO270115P00045000	put	45.0000	2027-01-15	8.4000	7.1000	8.8000	42.0600	15960.00	2520.00	13440.00	19	10	29	932	0.0311158798283262	0.674951167158341	0.676738862272113	false	false	false	true
28235e2c-5524-41b1-b762-b712dd2daa4f	2026-08-25 14:55	2026-08-25 14:55	2026-08-25 14:55	FRO	FRO261016P00042000	put	42.0000	2026-10-16	2.9500	2.9000	3.0000	43.7350	10325.00	295.00	10030.00	35	15	800	70	11.4285714285714	0.59965971914758	0.59965971914758	false	false	false	true
359aa96b-bb7e-4887-9b20-393a2db5affd	2026-08-25 14:43	2026-08-25 14:43	2026-08-25 14:43	FRO	FRO261016P00043000	put	43.0000	2026-10-16	3.6000	3.6000	3.9000	43.5900	20520.00	0.00	20520.00	57	7	1068	32	33.375	0.616250108614507	0.616250108614507	false	false	false	true
f595c759-c144-44f6-8cd2-7624163fb982	2026-08-25 14:43	2026-08-25 14:43	2026-08-25 14:43	FRO	FRO261016P00043000	put	43.0000	2026-10-16	3.6000	3.5000	3.9000	43.5900	20880.00	1800.00	19080.00	58	11	1011	32	31.59375	0.616250108614507	0.616250108614507	false	false	false	true
e7b06dad-03bd-4393-a051-07a7c1e4ed67	2026-08-25 14:35	2026-08-25 14:35	2026-08-25 14:35	FRO	FRO261016P00043000	put	43.0000	2026-10-16	3.6000	3.3000	3.9000	43.6300	18000.00	720.00	12960.00	50	5	822	32	25.6875	0.618864343431828	0.618864343431828	false	false	false	true
d374f1a0-dc09-4204-b8c7-7b40ea23227c	2026-08-25 14:35	2026-08-25 14:35	2026-08-25 14:35	FRO	FRO261016P00043000	put	43.0000	2026-10-16	3.6000	3.4000	3.9000	43.6300	18000.00	720.00	12960.00	50	5	772	32	24.125	0.618864343431828	0.618864343431828	false	false	false	true
8a98bfab-99d5-455b-8d72-714e268cd337	2026-08-25 14:35	2026-08-25 14:35	2026-08-25 14:35	FRO	FRO261016P00043000	put	43.0000	2026-10-16	3.6000	3.4000	3.9000	43.6050	18360.00	360.00	18000.00	51	5	722	32	22.5625	0.617231638603909	0.617231638603909	false	false	false	true
0e732526-f2ff-4206-99e2-3fd19353b33c	2026-08-25 14:35	2026-08-25 14:35	2026-08-25 14:35	FRO	FRO261016P00043000	put	43.0000	2026-10-16	3.6000	1.7000	4.1000	43.6000	37850.00	720.00	35280.00	105	26	650	32	20.3125	0.616904621340455	0.616904621340455	true	false	false	true
3e247722-d4bf-43d9-8a1b-5ba8dc95d3c3	2026-08-25 14:13	2026-08-25 14:13	2026-08-25 14:13	FRO	FRO261016P00040000	put	40.0000	2026-10-16	2.0500	1.5500	2.3000	43.0000	10455.00	2460.00	7995.00	51	5	772	0	0	0.581848900816373	0.581848900816373	false	false	false	true
31a12eb3-bd20-423c-955d-c4bf820640a4	2026-08-25 14:03	2026-08-25 14:03	2026-08-25 14:03	FRO	FRO270115P00040000	put	40.0000	2027-01-15	4.6000	3.8000	4.7000	43.0000	11500.00	920.00	10580.00	25	9	25	4845	0.00515995872033024	0.631131580896447	0.631131580896447	false	false	false	true
1c7c25c4-177e-46c0-bfa5-a196d73e6042	2026-08-25 14:03	2026-08-25 14:03	2026-08-25 14:03	FRO	FRO261016P00040000	put	40.0000	2026-10-16	2.0500	0.4000	2.3000	43.0000	15170.00	5125.00	10045.00	74	5	633	0	0	0.582110714634731	0.582110714634731	false	false	false	true
103d7d86-8bbf-4040-9882-4d762188e6ef	2026-08-25 14:03	2026-08-25 14:02	2026-08-25 14:02	FRO	FRO261016P00040000	put	40.0000	2026-10-16	2.0500	0.4500	2.3500	43.0000	104960.00	26240.00	78720.00	512	26	525	0	0	0.580276044123304	0.581324991608212	false	false	false	true
e1804f68-c50a-47d0-a07a-b5194c18af63	2026-08-25 14:01	2026-08-25 14:00	2026-08-25 14:00	FRO	FRO261016P00041000	put	41.0000	2026-10-16	2.5000	1.2500	2.8500	43.0000	17500.00	3250.00	14250.00	70	22	72	0	0	0.588555216532676	0.589448623370712	true	false	false	true
51364208-566d-48e4-bdd5-176144868637	2026-08-25 13:55	2026-08-25 13:55	2026-08-25 13:55	FRO	FRO270219P00050000	put	50.0000	2027-02-19	11.7500	10.0000	12.4000	43.6001	11750.00	11750.00	0.00	10	5	402	45	8.93333333333333	0.686124676252015	0.686124676252015	false	false	false	true
bd6b5311-b918-4bae-b85a-d86d5094c5b5	2026-08-25 13:51	2026-08-25 13:51	2026-08-25 13:51	FRO	FRO261120C00060000	call	60.0000	2026-11-20	0.7000	0.2000	0.8500	43.5500	269220.00	266560.00	2660.00	3846	59	3847	3959	0.971710027784794	0.523567684385623	0.523567684385623	false	false	false	true
1f228604-7793-49b7-bee5-72dc4bc469bc	2026-08-25 13:47	2026-08-25 13:46	2026-08-25 13:46	FRO	FRO261016P00043000	put	43.0000	2026-10-16	3.7000	3.0000	3.8000	43.4650	11840.00	370.00	11470.00	32	12	430	32	13.4375	0.623559115692651	0.623559115692651	false	false	false	true
7d89daa7-5b47-49c0-8e79-354c577fb725	2026-08-25 12:50	2026-08-25 12:50	2026-08-25 12:50	FRO	FRO260918P00043000	put	43.0000	2026-09-18	3.1000	3.1000	3.8000	43.1400	34720.00	0.00	34720.00	112	20	164	452	0.36283185840708	0.733267861044872	0.733267861044872	false	false	false	true
305edc8f-d66a-4500-a3e3-885717ed725d	2026-08-25 12:41	2026-08-25 12:41	2026-08-25 12:41	FRO	FRO261016P00043000	put	43.0000	2026-10-16	3.9000	3.4000	3.9000	43.2400	37823.00	37823.00	0.00	97	18	279	32	8.71875	0.640971181143518	0.639620861715709	false	false	false	true