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.

425,429 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts425,429 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:er_time = unknown×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

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	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-08-26T19:41:15.773512Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
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	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
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
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	false
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	false
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	false
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	false
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	false
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	false
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	false
e01a8328-46a9-4466-bd07-32659d3410cf	2026-08-25 14:54	2026-08-25 14:53	2026-08-25 14:53	FRO	FRO261120C00060000	call	60.0000	2026-11-20	0.6000	0.3500	0.6000	43.6900	55075.00	54780.00	295.00	921	48	4808	3959	1.21444809295277	0.433980790076723	0.497528025976984	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	false
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	false
729f60ff-7945-4eeb-8a7e-bd17901715fc	2026-08-25 14:43	2026-08-25 14:43	2026-08-25 14:43	FRO	FRO261016P00043000	put	43.0000	2026-10-16	3.6200	3.5000	4.1000	43.5850	23190.00	3600.00	19590.00	64	30	913	32	28.53125	0.618211736851836	0.61592261267379	false	false	false	true	false
1712a716-9626-43d1-8022-f13563a7137b	2026-08-25 14:43	2026-08-25 14:43	2026-08-25 14:43	FRO	FRO261016C00043000	call	43.0000	2026-10-16	2.5000	2.1500	2.7000	43.5900	42786.00	2505.00	39501.00	171	29	171	72	2.375	0.313804090290185	0.317478224298673	false	false	false	true	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
4c1b6695-9ae2-4c3d-9241-705dc0fe2289	2026-08-25 13:44	2026-08-25 13:44	2026-08-25 13:44	FRO	FRO261016P00043000	put	43.0000	2026-10-16	3.7200	1.8000	4.3000	43.4731	35720.00	4810.00	30910.00	96	18	376	32	11.75	0.624095447854807	0.624095447854807	false	false	false	true	false
41bb31ca-33b3-4d41-b348-de4b8d43ecb1	2026-08-25 13:44	2026-08-25 13:44	2026-08-25 13:44	FRO	FRO261016P00042000	put	42.0000	2026-10-16	3.1500	2.6000	3.5000	43.4731	13220.00	310.00	12910.00	42	13	670	70	9.57142857142857	0.607654899896343	0.607654899896343	false	false	false	true	false
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	false
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	false
83b0ba9b-68a9-4220-92bc-57b84c609d93	2026-08-25 12:41	2026-08-25 12:41	2026-08-25 12:41	FRO	FRO261016P00042000	put	42.0000	2026-10-16	3.3000	2.8500	3.6000	43.2400	27390.00	1980.00	25410.00	83	17	573	70	8.18571428571429	0.623711905694319	0.624972012626285	true	false	false	true	false
6ff925f6-5f83-43d8-b01b-519de592ebb2	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.2000	4.1000	43.2400	29640.00	4290.00	25350.00	76	10	126	32	3.9375	0.639620861715709	0.639620861715709	false	false	false	true	false
59ecd453-5f86-4382-a492-b5db04215483	2026-08-25 12:37	2026-08-25 12:37	2026-08-25 12:37	FRO	FRO261016P00042000	put	42.0000	2026-10-16	3.3000	2.7000	3.4000	43.2700	25739.00	2639.00	19800.00	78	18	404	70	5.77142857142857	0.627485393410095	0.626857898458604	false	false	false	true	false
32f73889-c1f2-4c12-bf8d-d1b11f3fb46f	2026-08-25 12:35	2026-08-25 12:35	2026-08-25 12:35	FRO	FRO261016P00042000	put	42.0000	2026-10-16	3.3000	2.6500	3.5000	43.2800	31350.00	4290.00	27060.00	95	19	226	70	3.22857142857143	0.627485393410095	0.627485393410095	false	false	false	true	false
87e91775-b452-439b-9415-a191fd289d7b	2026-08-25 12:35	2026-08-25 12:35	2026-08-25 12:35	FRO	FRO261016P00042000	put	42.0000	2026-10-16	3.3000	2.6500	3.4000	43.2700	27060.00	3630.00	23430.00	82	18	131	70	1.87142857142857	0.626857898458604	0.626857898458604	false	false	false	true	false
26cf7bae-dd18-423f-88b8-a8fb8605cffd	2026-08-25 12:15	2026-08-25 12:15	2026-08-25 12:15	FRO	FRO261016P00042000	put	42.0000	2026-10-16	3.2000	2.2000	3.3000	43.4800	15350.00	630.00	14720.00	48	14	48	70	0.685714285714286	0.623644973204163	0.608079428551349	false	false	false	true	false
0ae1b278-e96d-46d6-b151-eb8c82aa5d92	2026-08-25 11:18	2026-08-25 11:18	2026-08-25 11:18	FRO	FRO260918P00040000	put	40.0000	2026-09-18	1.6000	1.6000	1.7500	42.9602	21760.00	0.00	21760.00	136	35	190	1707	0.111306385471588	0.679399511838928	0.679399511838928	false	false	false	true	false
c64f6af2-8533-4e12-a3a0-2479827b62c5	2026-08-25 10:17	2026-08-25 10:17	2026-08-25 10:17	FRO	FRO260918C00043000	call	43.0000	2026-09-18	2.0000	2.0000	2.2000	42.9900	10000.00	0.00	10000.00	50	19	107	2115	0.0505910165484634	0.444394936404006	0.444394936404006	false	false	false	true
831fe0a4-2de2-4433-9f53-f61e9f0dd73e	2026-08-25 10:12	2026-08-25 10:12	2026-08-25 10:12	FRO	FRO261120C00045000	call	45.0000	2026-11-20	2.5000	2.2000	2.5000	42.9800	22500.00	22500.00	0.00	90	26	94	1973	0.0476431829700963	0.38055064072772	0.38055064072772	false	false	false	true	false
71eba5c9-8c26-4dc9-a071-8714c3b38a6f	2026-08-24 15:37	2026-08-24 15:37	2026-08-24 15:37	FRO	FRO261016C00049000	call	49.0000	2026-10-16	1.1500	0.9500	1.3000	43.8000	23230.00	23000.00	230.00	202	17	1659	233	7.12017167381974	0.426097407429411	0.426097407429411	false	false	false	true
695292ce-767e-4d05-8e21-c4d8ac740add	2026-08-24 15:23	2026-08-24 15:23	2026-08-24 15:23	FRO	FRO260918P00044000	put	44.0000	2026-09-18	3.8000	1.9000	4.9000	43.8235	33060.00	32680.00	380.00	87	11	263	109	2.41284403669725	0.824713930698307	0.824713930698307	false	false	false	true	false
5c7f037e-dc2a-4066-8585-22d71cfbd44f	2026-08-24 15:21	2026-08-24 15:21	2026-08-24 15:21	FRO	FRO261016C00049000	call	49.0000	2026-10-16	1.1500	0.9500	1.3500	43.8600	12535.00	12305.00	230.00	109	20	1428	233	6.12875536480687	0.425096188564171	0.423093098030455	false	false	false	true
21db6618-9542-4ef6-a64a-3049610fed9d	2026-08-24 14:47	2026-08-24 14:47	2026-08-24 14:47	FRO	FRO270219P00043000	put	43.0000	2027-02-19	6.6000	6.6000	7.0000	43.9000	23100.00	0.00	23100.00	35	13	82	22	3.72727272727273	0.622987996088375	0.622987996088375	false	false	false	true	false
6aeda1e2-bffd-49f6-a1ff-d145dd919eac	2026-08-24 14:41	2026-08-24 14:41	2026-08-24 14:41	FRO	FRO261016C00045000	call	45.0000	2026-10-16	2.0900	2.0500	2.3500	43.9500	18599.00	0.00	18599.00	89	9	91	50	1.82	0.368223849017641	0.368223849017641	false	false	false	true	false