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 = RepeatedHits×ticker = FRVO×sorted by created_at ↑×

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

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	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-08-17T16:56:51.972483Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
a57a21d5-4e5a-4006-a724-f3dca51a8746	2026-09-02 11:03	2026-09-02 11:02	2026-09-02 11:02	FRVO	FRVO261016C00020000	call	20.0000	2026-10-16	1.5500	1.3500	1.5500	17.2222	23250.00	23250.00	0.00	150	6	301	531	0.566854990583804	1.05025790030694	1.05025790030694	false	false	false	true
080a76c8-3815-4e89-a6fb-83953d7c4eb1	2026-09-03 10:43	2026-09-03 10:43	2026-09-03 10:43	FRVO	FRVO260918C00060000	call	60.0000	2026-09-18	0.0500	0.0000	0.0500	17.6450	14999.00	14999.00	0.00	3000	34	5082	515	9.86796116504854	2.55335374320123	2.55335374320123	false	false	false	true
29be2447-2a96-4a45-aef1-ae196a9c6716	2026-09-04 14:40	2026-09-04 14:40	2026-09-04 14:40	FRVO	FRVO261218C00030000	call	30.0000	2026-12-18	1.2000	1.1000	1.3500	18.1100	48600.00	120.00	48480.00	405	15	437	2211	0.197648123021257	1.00711297110188	1.00711297110188	false	false	false	true
1e47a09a-0e64-4d8d-a320-cc821f37b3ad	2026-09-08 10:06	2026-09-08 10:05	2026-09-08 10:05	FRVO	FRVO270115C00025000	call	25.0000	2027-01-15	2.7500	2.4500	2.7500	18.6000	23925.00	23925.00	0.00	87	5	233	1574	0.148030495552732	1.04244631056245	1.04244631056245	false	false	false	true
aef0ef55-f223-4026-b3fb-6357e25d2650	2026-09-08 11:58	2026-09-08 11:58	2026-09-08 11:58	FRVO	FRVO270319C00025000	call	25.0000	2027-03-19	4.2000	4.0000	4.2000	19.0200	71400.00	71400.00	0.00	170	6	2609	107	24.3831775700935	1.07585765515479	1.07585765515479	false	false	false	true
8fccf5a5-da08-4b96-a46e-8ebeb5bc404c	2026-09-08 13:12	2026-09-08 13:12	2026-09-08 13:12	FRVO	FRVO261218C00020000	call	20.0000	2026-12-18	4.0000	3.8000	4.2000	19.1000	142000.00	126000.00	2000.00	355	14	478	209	2.28708133971292	1.0777139817121	1.0777139817121	false	false	false	true
5ed0034e-b789-480f-b977-bd3252ee9b91	2026-09-08 13:12	2026-09-08 13:12	2026-09-08 13:12	FRVO	FRVO261218C00020000	call	20.0000	2026-12-18	4.1000	4.1000	4.2000	19.2300	56170.00	0.00	2870.00	137	6	624	209	2.98564593301435	1.08366466231376	1.08366466231376	false	false	false	true
d370bbb1-1758-4ba1-a882-e06fad29d5e8	2026-09-08 13:23	2026-09-08 13:23	2026-09-08 13:23	FRVO	FRVO261218C00020000	call	20.0000	2026-12-18	4.1000	4.1000	4.2000	19.1000	11890.00	0.00	11890.00	29	5	662	209	3.16746411483254	1.10329772049225	1.10329772049225	false	false	false	true
4076964d-e8f4-44f5-9505-04dffc85c83b	2026-09-09 15:05	2026-09-09 15:05	2026-09-09 15:05	FRVO	FRVO261016P00012500	put	12.5000	2026-10-16	0.3000	0.2000	0.4000	17.4831	30000.00	0.00	26640.00	1000	7	1020	297	3.43434343434343	0.959330910606238	0.959330910606238	true	false	false	true
96789d31-76ca-4016-a305-0fd9b0938aa4	2026-09-09 15:13	2026-09-09 15:13	2026-09-09 15:13	FRVO	FRVO261016C00020000	call	20.0000	2026-10-16	1.3500	1.3500	1.5000	17.4900	10125.00	0.00	10125.00	75	8	168	787	0.213468869123253	1.00304631862283	1.00304631862283	false	false	false	true
836155eb-5866-49d2-8507-5f91aa7ccfd8	2026-09-10 09:37	2026-09-10 09:37	2026-09-10 09:37	FRVO	FRVO270115P00012500	put	12.5000	2027-01-15	1.5000	1.4500	1.5000	17.2415	10500.00	7500.00	0.00	70	18	283	104	2.72115384615385	1.00091146005378	1.00091146005378	false	false	false	true
72872edd-582b-448f-a5a6-e0c300107868	2026-09-10 15:04	2026-09-10 15:04	2026-09-10 15:04	FRVO	FRVO261016P00015000	put	15.0000	2026-10-16	1.4500	1.4000	1.5000	16.0550	10295.00	10005.00	0.00	71	20	531	5678	0.0935188446636139	1.01138215397929	1.01138215397929	true	false	false	true
2a401f25-b98f-4da4-9c37-bcd499099e50	2026-09-10 15:04	2026-09-10 15:04	2026-09-10 15:04	FRVO	FRVO261016P00015000	put	15.0000	2026-10-16	1.4500	1.4000	1.4500	16.0550	16675.00	15950.00	0.00	115	8	646	5678	0.11377245508982	1.01138215397929	1.01138215397929	true	false	false	true
103f5dcc-ad2c-4e47-ab9b-ba6594b42821	2026-09-11 09:47	2026-09-11 09:47	2026-09-11 09:47	FRVO	FRVO260918C00017500	call	17.5000	2026-09-18	0.3000	0.2500	0.3500	15.0000	10290.00	9960.00	330.00	343	19	469	8399	0.0558399809501131	1.17765213287823	1.17029723854151	false	false	false	true
6844b6ac-1d57-404f-92ff-e1bdb8cd2fe0	2026-09-11 09:51	2026-09-11 09:51	2026-09-11 09:51	FRVO	FRVO260918C00017500	call	17.5000	2026-09-18	0.3000	0.2500	0.3500	15.0000	15000.00	14670.00	0.00	500	8	1634	8399	0.194546969877366	1.18628483513845	1.18628483513845	false	false	false	true
4eaa3957-bbbb-495b-ba99-7d94be248e5b	2026-09-11 09:53	2026-09-11 09:53	2026-09-11 09:53	FRVO	FRVO260918C00017500	call	17.5000	2026-09-18	0.3000	0.2500	0.3000	15.0000	15000.00	15000.00	0.00	500	9	2134	8399	0.254077866412668	1.22535108495497	1.22535108495497	false	false	false	true
bd917550-56e4-450d-9fc3-9506cb5abebe	2026-09-11 09:53	2026-09-11 09:53	2026-09-11 09:53	FRVO	FRVO260918C00017500	call	17.5000	2026-09-18	0.3000	0.2500	0.3500	15.0000	12420.00	11940.00	330.00	414	10	2548	8399	0.303369448743898	1.21114676382134	1.21114676382134	false	false	false	true
5aa7dc75-0b0a-4344-8c13-1f7074a41777	2026-09-11 10:01	2026-09-11 10:01	2026-09-11 10:01	FRVO	FRVO260918C00017500	call	17.5000	2026-09-18	0.3500	0.2500	0.4000	15.1600	17500.00	17115.00	385.00	500	23	4138	8399	0.492677699726158	1.29860688028643	1.29126520709431	false	false	false	true
6f0e973b-fa9f-4819-9640-bd2796dbb283	2026-09-11 10:18	2026-09-11 10:18	2026-09-11 10:18	FRVO	FRVO270416P00015000	put	15.0000	2027-04-16	4.1000	4.1000	4.6000	15.1400	82000.00	0.00	82000.00	200	16	204	288	0.708333333333333	0.963890024597496	0.963890024597496	false	false	false	true
76aeec59-3890-4ffa-b7db-54ab91742d1b	2026-09-11 14:31	2026-09-11 14:31	2026-09-11 14:31	FRVO	FRVO270416P00010000	put	10.0000	2027-04-16	1.2000	1.2000	2.0000	15.5100	12000.00	0.00	12000.00	100	8	105	54	1.94444444444444	0.87957091863085	0.87957091863085	false	false	false	true
e4ee0052-91eb-453a-9ae7-3e4e1aacd17c	2026-09-11 14:40	2026-09-11 14:40	2026-09-11 14:40	FRVO	FRVO270416C00022500	call	22.5000	2027-04-16	3.2000	2.9000	3.2000	15.5900	32000.00	32000.00	0.00	100	6	600	130	4.61538461538461	1.05217144119395	1.05217144119395	false	false	false	true
9cec3b0a-6161-4031-965a-a716612df585	2026-09-11 14:43	2026-09-11 14:42	2026-09-11 14:42	FRVO	FRVO270416C00040000	call	40.0000	2027-04-16	1.1500	1.1500	1.5000	15.6100	18125.00	875.00	17250.00	157	12	158	229	0.689956331877729	1.03304582147838	1.060662336465	false	false	false	true
af72d248-af48-47c2-a280-88415c4ed508	2026-09-11 14:45	2026-09-11 14:45	2026-09-11 14:45	FRVO	FRVO270416C00035000	call	35.0000	2027-04-16	1.5400	1.4500	1.9000	15.6000	23145.00	0.00	23145.00	150	9	150	59	2.54237288135593	1.02235229202429	1.02235229202429	false	false	false	true
6612c7e4-da8b-4605-ac9c-1d7142681fec	2026-09-14 09:57	2026-09-14 09:57	2026-09-14 09:57	FRVO	FRVO270319C00025000	call	25.0000	2027-03-19	2.5000	2.3500	2.6500	15.3100	27750.00	0.00	24000.00	111	7	521	3431	0.151850772369572	1.10990351085113	1.10990351085113	true	false	false	true
2e51a80d-1218-4cb6-8da2-6285b5193cd4	2026-09-14 10:04	2026-09-14 10:04	2026-09-14 10:04	FRVO	FRVO270319C00025000	call	25.0000	2027-03-19	2.6500	2.4000	2.8000	15.5400	32595.00	32065.00	530.00	123	26	644	3431	0.18770037889828	1.12192511564399	1.12192511564399	true	false	false	true
17e32b31-c588-41ff-baa2-22784d8880f0	2026-09-14 10:09	2026-09-14 10:09	2026-09-14 10:09	FRVO	FRVO270115C00025000	call	25.0000	2027-01-15	1.7500	1.7500	1.9000	15.7400	74200.00	0.00	71925.00	424	12	576	3641	0.158198297171107	1.10544409126036	1.10544409126036	false	false	false	true