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.

474,253 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts474,253 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 = USO×

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

94c553c8-4b7d-4d56-abed-775ab8696667	2026-09-10 12:02	2026-09-10 12:02	2026-09-10 12:02	USO	USO260911C00157000	call	157.0000	2026-09-11	2.3600	2.3400	2.4600	156.7110	31210.00	0.00	31210.00	132	5	1010	416	2.42788461538462	0.767638202056371	0.761524754339737	true	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	ETF	Financial Services	1228364647.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-10T16:13:08.333814Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
947c2f3c-e203-453d-9971-4ec9033fb7d6	2026-09-10 12:02	2026-09-10 12:02	2026-09-10 12:02	USO	USO260911C00157000	call	157.0000	2026-09-11	2.3600	2.3500	2.4600	156.7110	53594.00	24546.00	29048.00	227	5	1237	416	2.97355769230769	0.764581487287624	0.761524754339737	false	false	false	true
5dc9523d-a117-4b5a-bee9-910bb49e6993	2026-09-10 11:56	2026-09-10 11:56	2026-09-10 11:56	USO	USO260918C00170000	call	170.0000	2026-09-18	1.8900	1.7900	1.8900	156.5900	38909.00	37411.00	1498.00	206	36	2040	3603	0.566194837635304	0.67206973603355	0.67206973603355	true	false	false	true
009e8713-09df-42ba-9c68-d7550ed5949f	2026-09-10 11:54	2026-09-10 11:54	2026-09-10 11:54	USO	USO261218P00140000	put	140.0000	2026-12-18	8.0000	8.0000	8.1500	156.4700	12806.00	0.00	12806.00	16	5	619	4130	0.149878934624697	0.503831630493612	0.503831630493612	false	false	false	true
7a1a70a4-4132-4739-8528-6117389a142d	2026-09-10 11:51	2026-09-10 11:51	2026-09-10 11:51	USO	USO261016P00150000	put	150.0000	2026-10-16	7.1700	7.0500	7.5000	156.1950	10756.00	8602.00	2154.00	15	5	327	735	0.444897959183673	0.534111772356946	0.53302582175134	false	false	false	true
1a1936a4-f650-445f-98f7-ab188ee64cf4	2026-09-10 11:47	2026-09-10 11:47	2026-09-10 11:47	USO	USO270319P00150000	put	150.0000	2027-03-19	16.5300	16.5000	17.1500	155.8800	39660.00	4965.00	31385.00	24	10	228	833	0.273709483793517	0.473895348302499	0.472715781041705	false	false	false	true
db3c3866-d437-4ba7-9e1b-e88d78184c30	2026-09-10 11:47	2026-09-10 11:47	2026-09-10 11:47	USO	USO260911C00155000	call	155.0000	2026-09-11	2.7600	2.7000	2.8000	155.7900	53269.00	52993.00	276.00	193	8	3336	6460	0.51640866873065	0.722743386755351	0.719631661780659	true	false	false	true
fc811951-4a8a-4f39-9218-49074f0daf9f	2026-09-10 11:42	2026-09-10 11:42	2026-09-10 11:42	USO	USO261218C00220000	call	220.0000	2026-12-18	3.8000	3.7500	3.9000	155.2800	81990.00	0.00	81990.00	216	10	222	796	0.278894472361809	0.587033685113328	0.584592419578279	false	false	false	true
9ec49864-22d7-4b85-8247-849501e13432	2026-09-10 11:07	2026-09-10 11:07	2026-09-10 11:07	USO	USO260911P00150000	put	150.0000	2026-09-11	0.4700	0.4600	0.5200	154.6400	23466.00	0.00	23466.00	500	5	4819	308	15.6461038961039	0.625217987287464	0.625217987287464	false	false	false	true
02601ecb-7081-434f-ae5b-17ec22f39a23	2026-09-10 09:51	2026-09-10 09:51	2026-09-10 09:51	USO	USO260918C00160000	call	160.0000	2026-09-18	2.5200	2.3900	2.5500	153.8377	33555.00	23635.00	9920.00	133	5	4093	7867	0.520274564637092	0.539546766432613	0.531039001686989	true	false	false	true
577457ad-4865-4132-b196-5b5a76f5eb49	2026-09-10 09:50	2026-09-10 09:50	2026-09-10 09:50	USO	USO261002C00190000	call	190.0000	2026-10-02	1.0100	0.6800	1.4400	153.6200	10088.00	0.00	10088.00	100	9	100	151	0.662251655629139	0.62914456277837	0.62914456277837	false	false	false	true
f12de625-246d-495d-baab-30244f783b12	2026-09-10 09:49	2026-09-10 09:49	2026-09-10 09:49	USO	USO261120P00155000	put	155.0000	2026-11-20	13.8800	13.8000	14.0000	153.6100	12490.00	2775.00	4160.00	9	9	39	13	3	0.511250820761087	0.509390329324885	false	false	false	true
f6b157de-0d0d-434f-b952-e94c7c5bbea2	2026-09-10 09:45	2026-09-10 09:45	2026-09-10 09:45	USO	USO260918P00155000	put	155.0000	2026-09-18	5.1400	5.0500	5.8000	153.8400	50401.00	0.00	50401.00	98	5	796	528	1.50757575757576	0.507597938615864	0.507597938615864	false	false	false	true
cfd58fe8-8245-4d35-8653-6683f9a2703e	2026-09-10 09:31	2026-09-10 09:31	2026-09-10 09:31	USO	USO260911C00150000	call	150.0000	2026-09-11	5.0500	5.0500	5.2000	154.5410	101008.00	0.00	101008.00	200	10	493	4361	0.113047466177482	0.63296621138876	0.628220780559232	true	false	false	true
fb51b4e9-f265-4f3d-9909-2d3259a96f41	2026-09-09 16:00	2026-09-09 15:59	2026-09-09 15:59	USO	USO261016P00125000	put	125.0000	2026-10-16	1.1100	1.0500	1.1100	149.9350	110631.00	107001.00	0.00	1000	38	4258	7750	0.54941935483871	0.477442763985491	0.477442763985491	false	false	false	true
dfe49190-1768-4f33-8ccd-de2599fc59ac	2026-09-09 15:41	2026-09-09 15:41	2026-09-09 15:41	USO	USO270115P00100000	put	100.0000	2027-01-15	1.2200	1.1700	1.2300	149.6100	12834.00	12834.00	0.00	105	15	2916	13010	0.22413528055342	0.494653326298509	0.492706059148898	false	false	false	true
cfc5a543-9df7-495e-8394-a15ff64f22e0	2026-09-09 14:51	2026-09-09 14:51	2026-09-09 14:51	USO	USO260918C00155000	call	155.0000	2026-09-18	2.2500	2.0900	2.2500	149.5600	42523.00	42299.00	224.00	189	11	986	3062	0.322011757021555	0.461579459335592	0.460401362088798	true	false	false	true
d3c0126f-4389-48a2-8e27-6d2ccf3037ab	2026-09-09 13:33	2026-09-09 13:32	2026-09-09 13:32	USO	USO261218P00146000	put	146.0000	2026-12-18	12.5300	12.5000	12.9500	148.7242	13785.00	0.00	13785.00	11	5	17	70	0.242857142857143	0.478662953504073	0.477004712406227	false	false	false	true
1c384d07-498e-4bbf-899c-c86af492a842	2026-09-09 12:58	2026-09-09 12:58	2026-09-09 12:58	USO	USO261016P00125000	put	125.0000	2026-10-16	1.1900	1.1600	1.2100	148.0000	11890.00	11295.00	595.00	100	8	3067	7750	0.395741935483871	0.469101103442771	0.469101103442771	true	false	false	true
62536b15-0709-4c04-b0bc-10dbe30a7c0d	2026-09-09 12:21	2026-09-09 12:21	2026-09-09 12:21	USO	USO260918C00153000	call	153.0000	2026-09-18	2.9800	2.9800	3.1500	149.3001	30697.00	0.00	30697.00	103	18	222	3483	0.0637381567614126	0.48074849456491	0.479638257829966	true	false	false	true
71df2122-663b-4a58-8a0d-80f5e8465e83	2026-09-09 12:15	2026-09-09 12:15	2026-09-09 12:15	USO	USO261218C00140000	call	140.0000	2026-12-18	19.9900	19.7500	20.0500	149.5300	1001704.00	1001704.00	0.00	501	30	2052	6459	0.31769623780771	0.460928350880022	0.45916456661898	true	false	false	true
8508c8c5-ca5c-4321-b30c-a9c314560d1e	2026-09-09 11:47	2026-09-09 11:47	2026-09-09 11:47	USO	USO261218C00145000	call	145.0000	2026-12-18	17.1900	16.9000	17.2000	149.3400	859603.00	687603.00	0.00	500	24	1147	6994	0.16399771232485	0.460420123706235	0.460420123706235	true	false	false	true
ef5b103d-5ac7-4296-9287-a2cc86b9ff89	2026-09-09 10:32	2026-09-09 10:32	2026-09-09 10:32	USO	USO261016P00140000	put	140.0000	2026-10-16	4.5100	4.4000	4.5500	148.0000	60910.00	60910.00	0.00	135	6	503	2454	0.204971475142624	0.459585125710256	0.45837396100947	false	false	false	true
f53b9ea7-0c4a-4fa3-9354-a9c09cc8c227	2026-09-09 10:31	2026-09-09 10:30	2026-09-09 10:30	USO	USO270319P00120000	put	120.0000	2027-03-19	5.9100	5.7500	6.0500	148.0000	29574.00	20694.00	8880.00	50	5	285	13966	0.0204067019905485	0.453867040954604	0.453522028988274	false	false	false	true
49df104c-59d3-4a7f-a435-e24c6fe954ed	2026-09-09 09:37	2026-09-09 09:37	2026-09-09 09:37	USO	USO270917P00100000	put	100.0000	2027-09-17	5.1700	4.9000	5.6500	148.8100	25846.00	0.00	25846.00	50	15	270	440	0.613636363636364	0.467288967911044	0.467288967911044	false	false	false	true
e31b7875-d32b-4fd6-b9fd-5fbbaf743a1c	2026-09-09 09:35	2026-09-09 09:35	2026-09-09 09:35	USO	USO261218C00140000	call	140.0000	2026-12-18	19.2400	18.8500	19.2500	148.5800	1923940.00	1923940.00	0.00	1000	5	1018	6459	0.157609537080043	0.454902885932885	0.449043841978207	false	false	false	true
c18f7674-a6f5-43ea-aaeb-77701e75218c	2026-09-09 09:30	2026-09-09 09:30	2026-09-09 09:30	USO	USO260909C00149000	call	149.0000	2026-09-09	1.0300	0.9900	1.1200	148.8324	13267.00	8217.00	5050.00	129	10	272	468	0.581196581196581	0.698487668483866	0.692294780366224	true	false	false	true
84703f45-97cf-4d01-9635-6168e8f1045d	2026-09-09 09:30	2026-09-09 09:30	2026-09-09 09:30	USO	USO260909C00149000	call	149.0000	2026-09-09	1.0200	0.9800	1.1500	148.8462	12452.00	103.00	12349.00	122	32	142	468	0.303418803418803	0.706738239246495	0.675783785243645	true	false	false	true
1afaec95-b629-45fa-a988-c6fc383ece98	2026-09-09 09:30	2026-09-09 09:30	2026-09-09 09:30	USO	USO260909C00150000	call	150.0000	2026-09-09	0.7200	0.6800	0.8000	148.8201	31533.00	2880.00	28653.00	439	11	563	4164	0.135206532180596	0.750890147022344	0.744250362779784	true	false	false	true
011cc4d3-1f1f-4735-b6c5-392f839ebd1a	2026-09-08 15:56	2026-09-08 15:56	2026-09-08 15:56	USO	USO261218P00140000	put	140.0000	2026-12-18	10.5200	10.2000	10.6000	145.7900	25240.00	10550.00	10450.00	24	6	1513	2587	0.58484731349053	0.46935256833518	0.464170495681829	true	false	false	true
4e8f20e3-d085-4c61-a498-ea244b80f26a	2026-09-08 15:53	2026-09-08 15:52	2026-09-08 15:52	USO	USO260918C00153000	call	153.0000	2026-09-18	1.7300	1.7100	1.7400	145.8550	22680.00	6960.00	9804.00	131	9	3401	138	24.6449275362319	0.443704183293347	0.441214755557323	false	false	false	true
000f40a8-986c-423d-9259-2b51f70f7c60	2026-09-08 15:17	2026-09-08 15:17	2026-09-08 15:17	USO	USO260909C00146000	call	146.0000	2026-09-09	1.3500	1.2600	1.3800	145.5800	13588.00	7289.00	6299.00	101	56	6359	114	55.780701754386	0.50720805431889	0.50720805431889	false	false	false	true
ae823f34-331b-4df6-890e-19d85894f1f7	2026-09-08 14:48	2026-09-08 14:48	2026-09-08 14:48	USO	USO261009C00143500	call	143.5000	2026-10-09	8.5900	7.8000	8.6500	145.4100	19760.00	16330.00	1710.00	23	15	25	0	0	0.438436197224596	0.438436197224596	true	false	false	true
b2f893fe-be4e-47f5-9303-b0c09e69a6e8	2026-09-08 14:34	2026-09-08 14:34	2026-09-08 14:34	USO	USO260911C00137000	call	137.0000	2026-09-11	7.7300	7.7000	8.5000	144.4600	10051.00	0.00	10051.00	13	5	186	357	0.521008403361345	0.440651538719059	0.440651538719059	false	false	false	true
2e4f3eac-f409-4c4e-8a26-79627db973d2	2026-09-08 14:20	2026-09-08 14:20	2026-09-08 14:20	USO	USO261016C00148000	call	148.0000	2026-10-16	7.0000	6.7500	7.0000	144.4399	349877.00	349877.00	0.00	500	42	555	677	0.819793205317578	0.447466194775458	0.447466194775458	true	false	false	true
9813784c-1f25-4e61-8a78-f2e420fea2fd	2026-09-08 10:50	2026-09-08 10:50	2026-09-08 10:50	USO	USO270319C00193000	call	193.0000	2027-03-19	6.9000	6.8500	7.3500	144.3850	42115.00	0.00	42115.00	61	9	61	2	30.5	0.472698490200601	0.472698490200601	false	false	false	true
2073dce9-5964-4741-9320-e2b499eada04	2026-09-08 10:35	2026-09-08 10:34	2026-09-08 10:34	USO	USO281215P00139000	put	139.0000	2028-12-15	24.9400	24.3000	25.0000	144.7150	29930.00	27440.00	2490.00	12	9	12	11	1.09090909090909	0.419841591595508	0.419841591595508	false	false	false	true
d6faff5c-1ca1-40ff-bfe7-0f01991a0daa	2026-09-08 10:33	2026-09-08 10:33	2026-09-08 10:33	USO	USO270319C00170000	call	170.0000	2027-03-19	10.9200	10.8500	11.3500	144.8750	83005.00	0.00	83005.00	76	5	79	323	0.244582043343653	0.444601725522389	0.442623129049245	true	false	false	true
2059c80f-633e-48db-8871-d454745c7ef6	2026-09-08 10:16	2026-09-08 10:15	2026-09-08 10:15	USO	USO280616C00230000	call	230.0000	2028-06-16	11.4700	11.3500	11.8500	145.1700	33257.00	0.00	33257.00	29	6	31	112	0.276785714285714	0.382876149291331	0.382876149291331	false	false	false	true
d7b7b0ae-75e8-44a1-8824-44b6d5cd019b	2026-09-08 10:08	2026-09-08 10:08	2026-09-08 10:08	USO	USO270115P00135000	put	135.0000	2027-01-15	9.4700	9.3500	9.7500	145.0200	32185.00	0.00	32185.00	34	6	184	1184	0.155405405405405	0.44637857084728	0.44637857084728	false	false	false	true
c4aaebe4-9e1f-48c0-9a52-71870e8b23e7	2026-09-08 09:57	2026-09-08 09:56	2026-09-08 09:56	USO	USO261218C00145000	call	145.0000	2026-12-18	14.0000	13.7500	14.0000	144.8199	699941.00	692941.00	0.00	500	19	503	7230	0.0695712309820194	0.440094775711415	0.440094775711415	true	false	false	true
6a746780-d135-4be9-b749-c22e5c135ad6	2026-09-08 09:37	2026-09-08 09:37	2026-09-08 09:37	USO	USO261218P00130000	put	130.0000	2026-12-18	6.2000	6.0500	6.4500	145.1800	15507.00	0.00	15507.00	25	6	284	4051	0.0701061466304616	0.448694812578833	0.448694812578833	false	false	false	true
651fb9f8-9eb5-4ea2-a0f5-8bd3e3dfc004	2026-09-08 09:37	2026-09-08 09:36	2026-09-08 09:36	USO	USO261218P00130000	put	130.0000	2026-12-18	6.1900	6.0500	6.4500	145.1447	22919.00	0.00	22919.00	37	7	259	4051	0.0639348309059491	0.448722673672415	0.448722673672415	false	false	false	true
ee525d74-82ca-41ef-a5ed-28e2ba7e2b34	2026-09-04 14:36	2026-09-04 14:36	2026-09-04 14:36	USO	USO281215C00166000	call	166.0000	2028-12-15	26.5300	26.4500	27.3500	142.2300	116750.00	2670.00	90230.00	44	9	63	212	0.297169811320755	0.349317345535257	0.348726682583767	true	false	false	true
23d9d966-d303-47e4-9eb0-71853845ad73	2026-09-04 14:36	2026-09-04 14:36	2026-09-04 14:36	USO	USO281215C00168000	call	168.0000	2028-12-15	25.9800	24.4500	27.2000	142.2300	103905.00	23370.00	80535.00	40	12	40	3	13.3333333333333	0.350934269171966	0.347990601929117	false	false	false	true
322f075f-5246-4edd-8117-7a5d1726c18a	2026-09-04 13:58	2026-09-04 13:58	2026-09-04 13:58	USO	USO261016C00132000	call	132.0000	2026-10-16	13.6200	13.1500	13.6500	141.3200	275085.00	186725.00	88360.00	202	13	206	684	0.301169590643275	0.417789447823183	0.40220890454145	true	false	false	true
ca2be845-35f0-4046-98bf-065be6ac2e86	2026-09-04 13:56	2026-09-04 13:56	2026-09-04 13:56	USO	USO260909C00144000	call	144.0000	2026-09-09	1.4800	1.2600	1.5800	141.3400	14681.00	13181.00	1500.00	99	32	462	144	3.20833333333333	0.388887541747784	0.385633677948054	false	false	false	true
f5bb5dc7-d624-405f-8ffd-a7bd5017a4c4	2026-09-04 12:43	2026-09-04 12:43	2026-09-04 12:43	USO	USO260904C00141000	call	141.0000	2026-09-04	0.6100	0.5200	0.6600	141.1550	23690.00	23690.00	0.00	390	6	2191	457	4.79431072210066	0.484785123817582	0.475533437708566	false	false	false	true
3909d05c-022b-4886-a61e-850494773bda	2026-09-04 12:04	2026-09-04 12:04	2026-09-04 12:04	USO	USO261218C00150000	call	150.0000	2026-12-18	10.3700	10.1500	10.4500	141.3000	44604.00	44604.00	0.00	43	9	432	5173	0.0835105354726464	0.439715023780318	0.439715023780318	false	false	false	true
bc2d42c2-7f95-47a8-823b-0cb6ec3c8342	2026-09-04 11:51	2026-09-04 11:50	2026-09-04 11:50	USO	USO280317C00156000	call	156.0000	2028-03-17	23.4800	23.3500	24.2500	141.2599	131484.00	0.00	131484.00	56	7	56	2	28	0.3668444298427	0.3668444298427	false	false	false	true