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:alert_rule = RepeatedHitsDescendingFill×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

5608eb8c-5824-423e-9ca7-0b209723750c	2026-09-21 14:27	2026-09-21 14:27	2026-09-21 14:27	FRO	FRO261016C00054200	call	54.2000	2026-10-16	1.3000	1.3000	1.4500	50.3400	10043.00	0.00	10043.00	77	15	649	14957	0.04339105435582	0.515137318216586	0.510901761487778	false	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	Common Stock	Energy	11088846101.00	2026-11-20	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-21T18:28:37.842583Z"}	2026-09-21	2026-09-21 21:15	2026-09-21 21:15
24c460a0-3584-4e84-ac67-73afe9886836	2026-09-18 11:52	2026-09-18 11:52	2026-09-18 11:52	FRO	FRO261016C00054200	call	54.2000	2026-10-16	1.6500	1.5500	1.7000	51.1800	66141.00	33141.00	33000.00	401	21	2616	0	0	0.495542202913629	0.491340505393406	true	false	false	true
ccd3c82b-a34b-4570-85d8-518a18222969	2026-09-18 11:42	2026-09-18 11:42	2026-09-18 11:42	FRO	FRO261016C00054200	call	54.2000	2026-10-16	1.5500	1.3500	1.6000	50.8900	34078.00	34078.00	0.00	220	11	2175	0	0	0.497050365970479	0.492318979821138	true	false	false	true
427e6291-9f92-4089-8d0b-51012db4417d	2026-09-17 11:18	2026-09-17 11:18	2026-09-17 11:18	FRO	FRO270115P00045000	put	45.0000	2027-01-15	3.2200	3.2000	3.3000	54.3000	10620.00	0.00	6720.00	33	14	282	1209	0.233250620347395	0.635344439932063	0.635344439932063	false	false	false	true
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
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
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
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
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
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
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
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
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
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
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
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
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
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
32340fb8-d7b7-4fc6-82f1-1e3a941ac99a	2026-08-24 13:51	2026-08-24 13:51	2026-08-24 13:51	FRO	FRO260918P00044000	put	44.0000	2026-09-18	3.6100	3.6000	4.1000	43.8500	10100.00	0.00	10100.00	28	7	150	109	1.37614678899083	0.805427200647862	0.783475374017299	false	false	false	true
e1e28fa4-ed4a-496f-9f8e-675c60ad34bd	2026-08-24 13:50	2026-08-24 13:50	2026-08-24 13:50	FRO	FRO260918P00044000	put	44.0000	2026-09-18	3.6000	3.6000	4.2000	43.8379	19820.00	0.00	19820.00	55	12	122	109	1.11926605504587	0.804205491754621	0.782250866682226	false	false	false	true
165353cc-b7f3-42b9-bcfa-4f8bdca68190	2026-08-24 12:52	2026-08-24 12:52	2026-08-24 12:52	FRO	FRO261016C00049000	call	49.0000	2026-10-16	1.0400	0.9000	1.0500	43.6200	32790.00	30690.00	2100.00	314	20	617	233	2.6480686695279	0.41703008627322	0.41703008627322	false	false	false	true
debaa1aa-11c4-410d-863c-57b088399678	2026-08-24 12:44	2026-08-24 12:44	2026-08-24 12:44	FRO	FRO260918P00040000	put	40.0000	2026-09-18	1.5500	1.4000	1.6000	43.5500	12707.00	12707.00	0.00	82	38	409	1337	0.305908750934929	0.697730118316595	0.697730118316595	false	false	false	true
f3e87087-753c-4fcc-a9cb-c42be9d5d8f5	2026-08-19 09:32	2026-08-19 09:32	2026-08-19 09:32	FRO	FRO261120C00055000	call	55.0000	2026-11-20	0.9800	0.9500	1.1000	45.0700	41950.00	3870.00	38080.00	427	12	599	8015	0.0747348721147848	0.410056148456565	0.414626820137593	false	false	false	true