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:sector = Utilities×ticker = FRVO×

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

80ac0f00-d260-476c-881e-5073b0cd699a	2026-09-01 15:40	2026-09-01 15:40	2026-09-01 15:40	FRVO	FRVO260918P00020000	put	20.0000	2026-09-18	1.8500	1.7500	1.8500	19.6100	38665.00	38665.00	0.00	209	9	1087	521	2.08637236084453	0.980099817787513	0.980099817787513	true	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Utilities	4293187694.00	2026-11-11	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-01T19:44:53.190071Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
b5c6ca77-f17c-4cbf-a79a-62f68dddad29	2026-09-01 14:39	2026-09-01 14:39	2026-09-01 14:39	FRVO	FRVO260918P00017500	put	17.5000	2026-09-18	0.7200	0.7000	0.8000	19.7100	12940.00	0.00	12940.00	180	8	846	1691	0.500295683027794	1.00061210807305	1.00061210807305	false	false	false	true
33c696bf-9d27-4678-b731-65a177aeaf9a	2026-09-01 14:30	2026-09-01 14:30	2026-09-01 14:30	FRVO	FRVO260918C00020000	call	20.0000	2026-09-18	1.4500	1.4500	1.6000	19.6600	14500.00	0.00	14500.00	100	17	5716	999	5.72172172172172	0.938302578106985	0.938302578106985	false	false	false	true
b1fcd92c-693a-448a-8f68-d3bcd7fe4d9c	2026-09-01 14:09	2026-09-01 14:08	2026-09-01 14:08	FRVO	FRVO270416C00020000	call	20.0000	2027-04-16	5.6100	5.0000	6.1000	19.4100	11222.00	11222.00	0.00	20	16	72	135	0.533333333333333	0.944118314983614	0.944118314983614	false	false	false	true
3618d4a7-3d71-4b8e-bd0d-1c4383524f1d	2026-09-01 13:22	2026-09-01 13:22	2026-09-01 13:22	FRVO	FRVO270416C00030000	call	30.0000	2027-04-16	3.3000	2.8500	3.5000	19.7399	33000.00	21780.00	1980.00	100	7	115	134	0.858208955223881	0.952457677874959	0.952457677874959	false	false	false	true
dfca9e9d-c918-47a2-84dc-1a6fea3f1396	2026-09-01 12:39	2026-09-01 12:39	2026-09-01 12:39	FRVO	FRVO270416C00025000	call	25.0000	2027-04-16	4.1500	3.8000	4.2000	19.2600	20743.00	20743.00	0.00	50	8	84	248	0.338709677419355	0.96903438578798	0.954931915227656	false	false	false	true
5e08e49f-e9cc-4a55-99b2-0d572f390a0e	2026-09-01 12:13	2026-09-01 12:13	2026-09-01 12:13	FRVO	FRVO260918P00020000	put	20.0000	2026-09-18	2.0500	1.8500	2.0500	19.2904	20500.00	20500.00	0.00	100	11	263	521	0.504798464491363	1.00297457672128	1.00297457672128	false	false	false	true
94fe9e0e-5bea-4377-a3ce-33175f84128e	2026-09-01 11:15	2026-09-01 11:14	2026-09-01 11:14	FRVO	FRVO261016C00030000	call	30.0000	2026-10-16	0.4000	0.3500	0.5000	18.7500	10960.00	40.00	10920.00	274	24	615	25	24.6	1.03272429148655	1.03272429148655	false	false	false	true	false
5bca999f-edc8-4be3-b2b6-3de8b1fc06f3	2026-09-01 10:50	2026-09-01 10:50	2026-09-01 10:50	FRVO	FRVO260918C00025000	call	25.0000	2026-09-18	0.3000	0.3000	0.4500	19.3799	15000.00	0.00	15000.00	500	10	5164	3463	1.49119260756569	1.01981350228418	1.01981350228418	false	false	false	true
095cc3dc-697c-42e1-9bf0-4e5b4e346fc8	2026-09-01 10:49	2026-09-01 10:49	2026-09-01 10:49	FRVO	FRVO260918C00025000	call	25.0000	2026-09-18	0.3000	0.3000	0.4000	19.2800	42054.00	0.00	42054.00	1401	39	4058	3463	1.17181634421022	1.03518213990054	1.03518213990054	false	false	false	true
51de0845-2778-4c3a-8696-5fedda8af0ed	2026-09-01 10:48	2026-09-01 10:48	2026-09-01 10:48	FRVO	FRVO260918C00025000	call	25.0000	2026-09-18	0.3500	0.3500	0.4500	19.2600	29785.00	0.00	29785.00	851	34	2320	3463	0.669939358937338	1.08869856686768	1.08869856686768	false	false	false	true
0b814b1b-5fb4-44f1-933a-60b99f2c44a5	2026-09-01 10:27	2026-09-01 10:26	2026-09-01 10:26	FRVO	FRVO260918C00020000	call	20.0000	2026-09-18	1.2000	1.2000	1.4000	18.9399	10560.00	0.00	10560.00	88	7	4014	999	4.01801801801802	0.994755521311063	0.994755521311063	false	false	false	true
05f5efef-4663-4c21-be20-4db92fd6b029	2026-09-01 09:43	2026-09-01 09:43	2026-09-01 09:43	FRVO	FRVO260918C00020000	call	20.0000	2026-09-18	0.5500	0.5500	0.7500	17.2099	11010.00	0.00	11010.00	200	39	1143	999	1.14414414414414	1.01485355276296	0.974825608918973	false	false	false	true
22b8cc9a-d0d3-491f-9790-edf358369a45	2026-09-01 09:33	2026-09-01 09:33	2026-09-01 09:33	FRVO	FRVO260918C00017500	call	17.5000	2026-09-18	1.4000	1.2000	1.5500	17.3400	27440.00	16520.00	0.00	196	8	1108	2246	0.493321460373998	0.978607548400935	0.978607548400935	false	false	false	true
6e6f3996-7c4b-4913-9c46-8e0bf6fd1390	2026-09-01 09:31	2026-09-01 09:31	2026-09-01 09:31	FRVO	FRVO260918C00017500	call	17.5000	2026-09-18	1.5500	1.2500	1.5500	17.4700	84165.00	84165.00	0.00	543	22	725	2246	0.322796081923419	1.03240083373316	1.03240083373316	true	false	false	true
945aae78-881c-437e-b312-965c1bbb792f	2026-09-01 09:31	2026-09-01 09:31	2026-09-01 09:31	FRVO	FRVO260918C00017500	call	17.5000	2026-09-18	1.3500	1.1500	1.4000	17.0900	15795.00	15795.00	0.00	117	10	161	2246	0.0716829919857525	1.03203025817911	1.03203025817911	false	false	false	true
a2c683fc-715e-495b-8876-4e9c572358b0	2026-08-31 13:32	2026-08-31 13:32	2026-08-31 13:32	FRVO	FRVO261016C00017500	call	17.5000	2026-10-16	1.5000	1.0500	1.7000	15.3700	29374.00	22799.00	6575.00	196	39	522	95	5.49473684210526	1.04024308528461	1.03411448547054	true	false	false	true
f494e598-83e3-4dca-89a8-e58cc67c7447	2026-08-31 13:32	2026-08-31 13:32	2026-08-31 13:32	FRVO	FRVO261016C00017500	call	17.5000	2026-10-16	1.5000	1.0500	1.5250	15.3500	16040.00	16040.00	0.00	107	10	326	95	3.43157894736842	1.03818642950337	1.03818642950337	true	false	false	true
4935b9c2-7d0e-42df-a23c-6057176d9931	2026-08-31 13:32	2026-08-31 13:32	2026-08-31 13:32	FRVO	FRVO261016C00017500	call	17.5000	2026-10-16	1.5000	1.0000	1.6500	15.4000	29246.00	12146.00	15450.00	195	25	219	95	2.30526315789474	1.03615035297059	1.02800807484982	true	false	false	true
f1d38391-9c7f-4d3d-bdc4-35b2a8d8592a	2026-08-31 13:28	2026-08-31 13:28	2026-08-31 13:28	FRVO	FRVO260918C00017500	call	17.5000	2026-09-18	0.5500	0.5500	0.6000	15.2450	46970.00	0.00	1870.00	854	36	883	663	1.33182503770739	0.960458126617778	0.960458126617778	false	false	false	true
64b197d7-f5a1-4d7d-9437-67fe91f026cd	2026-08-31 11:49	2026-08-31 11:49	2026-08-31 11:49	FRVO	FRVO261218C00060000	call	60.0000	2026-12-18	0.3000	0.2000	0.4000	15.2700	38280.00	35280.00	3000.00	1276	38	3028	2468	1.22690437601297	1.3736594029769	1.3736594029769	false	false	false	true
8cb1bf81-12cf-4552-b7ef-407387abc5d1	2026-08-28 13:04	2026-08-28 13:04	2026-08-28 13:04	FRVO	FRVO261016P00015000	put	15.0000	2026-10-16	2.0500	2.0000	2.1000	15.0200	10250.00	8200.00	2050.00	50	5	344	5261	0.0653868085915225	0.96361923888072	0.96361923888072	true	false	false	true
b109a218-51ed-462c-8e0f-d9b173551942	2026-08-28 13:02	2026-08-28 13:01	2026-08-28 13:01	FRVO	FRVO261016P00015000	put	15.0000	2026-10-16	2.0500	2.0000	2.0500	14.9800	10250.00	8200.00	0.00	50	6	244	5261	0.0463790153963125	0.955732964872312	0.955732964872312	true	false	false	true
456a1d6d-df05-4bc0-9d64-2dee6694db00	2026-08-28 13:01	2026-08-28 13:01	2026-08-28 13:01	FRVO	FRVO261016P00015000	put	15.0000	2026-10-16	2.0500	2.0500	2.1000	14.9600	10250.00	0.00	10250.00	50	6	194	5261	0.0368751187987075	0.951762410871399	0.951762410871399	false	false	false	true
238e2c73-bda8-4245-b141-feaeba9d3343	2026-08-26 12:23	2026-08-26 12:22	2026-08-26 12:22	FRVO	FRVO270115C00017500	call	17.5000	2027-01-15	3.5000	2.7500	3.5000	15.5300	52500.00	52500.00	0.00	150	12	153	44	3.47727272727273	1.07514786409518	1.07514786409518	false	false	false	true
648ff0e1-f0bd-4e7a-b2b3-602ff438255d	2026-08-26 10:57	2026-08-26 10:57	2026-08-26 10:57	FRVO	FRVO261016P00015000	put	15.0000	2026-10-16	1.9000	1.7500	1.9000	15.5400	54530.00	54530.00	0.00	287	27	5455	44	123.977272727273	0.97226774635906	0.97226774635906	true	false	false	true
5d42b00b-b4ea-4741-9322-9ca9db4ec613	2026-08-25 15:58	2026-08-25 15:58	2026-08-25 15:58	FRVO	FRVO260918C00017500	call	17.5000	2026-09-18	1.0000	0.8500	1.0000	16.4000	10000.00	10000.00	0.00	100	9	748	184	4.06521739130435	0.851040397225685	0.849740104405112	true	false	false	true
b1d96a17-d293-4ad0-b293-8e1f30a51104	2026-08-25 12:59	2026-08-25 12:59	2026-08-25 12:59	FRVO	FRVO260918C00017500	call	17.5000	2026-09-18	1.1000	1.0500	1.1000	16.5000	10670.00	10670.00	0.00	97	23	612	184	3.32608695652174	0.883553247646067	0.883553247646067	true	false	false	true
e847d201-3cdc-4955-8280-be5fdc1b095b	2026-08-18 14:18	2026-08-18 14:18	2026-08-18 14:18	FRVO	FRVO270115C00025000	call	25.0000	2027-01-15	2.6000	2.6000	2.8500	18.3950	16380.00	0.00	16380.00	63	9	101	1043	0.0968360498561841	0.95129308183684	0.95129308183684	false	false	false	true
da835708-ba5d-4478-8c19-17d98c7ee8a8	2026-08-17 12:44	2026-08-17 12:44	2026-08-17 12:44	FRVO	FRVO270115C00025000	call	25.0000	2027-01-15	2.4000	2.3000	2.7000	17.7605	11040.00	5760.00	1440.00	46	7	575	1142	0.503502626970228	0.963071286949918	0.963071286949918	true	false	false	true