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.

658,639 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts658,639 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:alert_rule = RepeatedHitsDescendingFill×endpoint = /api/option-trades/flow-alerts×ticker = USO×

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

e35b361d-a5b1-4faf-b8cd-df18c9eaf621	2026-10-01 15:59	2026-10-01 15:59	2026-10-01 15:59	USO	USO270319C00170000	call	170.0000	2027-03-19	12.0800	12.0000	12.5000	150.0000	35033.00	0.00	35033.00	29	7	42	490	0.0857142857142857	0.450201501282617	0.450201501282617	false	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	ETF	Financial Services	1228364647.00	—	—	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500}	2026-10-01	2026-10-01 21:15	2026-10-01 21:15
e34c2de6-3d80-43d2-8608-a8016c118790	2026-10-01 15:29	2026-10-01 15:29	2026-10-01 15:29	USO	USO261023P00135000	put	135.0000	2026-10-23	2.1700	2.0700	2.1800	149.0000	22382.00	22382.00	0.00	103	9	154	1171	0.131511528608027	0.533495186691277	0.532491523542493	true	false
4ed3702b-570a-4260-b9e4-37aff589fef7	2026-10-01 14:08	2026-10-01 14:08	2026-10-01 14:08	USO	USO270115P00145000	put	145.0000	2027-01-15	11.9200	11.8500	12.2500	149.9100	131080.00	54740.00	44210.00	110	19	745	3579	0.208158703548477	0.479568470207537	0.477942531776852	true	false
abc4af51-3ce1-4fc3-9d28-3395da1cf2cd	2026-10-01 14:07	2026-10-01 14:06	2026-10-01 14:06	USO	USO261106P00120000	put	120.0000	2026-11-06	1.0100	0.8800	1.0100	149.9100	25849.00	25750.00	99.00	256	26	1119	131	8.54198473282443	0.54814600753592	0.546718898929034	false	false
aa2df7bb-3658-41b1-adbc-748f486a552c	2026-10-01 13:59	2026-10-01 13:59	2026-10-01 13:59	USO	USO261218P00150000	put	150.0000	2026-12-18	12.7900	12.3500	13.9500	150.0000	15350.00	11515.00	2560.00	12	8	131	1933	0.0677703052250388	0.49489693880282	0.496009583189019	true	false
6b664e4a-94ec-44a4-ad27-a070a0e90b48	2026-10-01 13:59	2026-10-01 13:59	2026-10-01 13:59	USO	USO261023C00147000	call	147.0000	2026-10-23	9.1400	8.0000	9.3500	150.0000	16460.00	13725.00	2735.00	18	12	20	404	0.0495049504950495	0.504264882958972	0.504264882958972	true	false
d8b4b664-c389-486f-a0b2-02f756a3e030	2026-10-01 13:55	2026-10-01 13:55	2026-10-01 13:55	USO	USO261030C00147000	call	147.0000	2026-10-30	9.6900	8.2500	9.9000	149.0000	10655.00	9690.00	965.00	11	11	11	24	0.458333333333333	0.4955611959911	0.492520294069527	true	false
932be90c-debe-41a0-bc23-96082664d340	2026-10-01 13:17	2026-10-01 13:16	2026-10-01 13:16	USO	USO261007C00156000	call	156.0000	2026-10-07	1.0500	1.0200	1.0600	147.0000	10545.00	8637.00	0.00	100	8	205	73	2.80821917808219	0.485452394431483	0.483618806166148	false	false
e4c33aca-83fd-4d34-bb5f-d372f6fd5d1b	2026-10-01 12:35	2026-10-01 12:34	2026-10-01 12:34	USO	USO261030C00150000	call	150.0000	2026-10-30	7.3600	7.2000	7.5000	147.6000	18391.00	11776.00	0.00	25	5	40	521	0.0767754318618042	0.496370836564428	0.496370836564428	false	false
f462b2a0-51ce-4c1b-8e56-43b77dbee2bd	2026-10-01 12:12	2026-10-01 12:11	2026-10-01 12:11	USO	USO270319P00150000	put	150.0000	2027-03-19	18.8300	18.6500	19.9000	147.7002	22590.00	0.00	22590.00	12	5	184	1700	0.108235294117647	0.481533730615231	0.481533730615231	false	false
9d45e371-d0f5-449f-b472-f4ef919eaea1	2026-10-01 11:32	2026-10-01 11:32	2026-10-01 11:32	USO	USO261014P00151000	put	151.0000	2026-10-14	6.5000	6.2000	6.6000	148.9600	39675.00	36425.00	3250.00	61	8	105	10	10.5	0.495652015252448	0.491177950343507	true	false
5a236fdf-3062-4efe-ba6a-3b0a783d52e1	2026-10-01 10:46	2026-10-01 10:46	2026-10-01 10:46	USO	USO261014P00144000	put	144.0000	2026-10-14	3.5700	3.5500	4.3000	148.2850	31768.00	0.00	31768.00	89	5	92	2	46	0.502960162966582	0.502960162966582	false	false	false
cd7adb10-25f7-423a-a7ba-7e68dcc046aa	2026-09-30 15:18	2026-09-30 15:18	2026-09-30 15:18	USO	USO260930P00146000	put	146.0000	2026-09-30	0.4300	0.4200	0.5000	145.0000	12011.00	2507.00	2280.00	278	17	5535	629	8.79968203497615	0.537243781535316	0.51632880033515	true	false
55ac5a9d-831c-4218-8ea3-18022ba8041d	2026-09-30 15:12	2026-09-30 15:12	2026-09-30 15:12	USO	USO280317P00128000	put	128.0000	2028-03-17	16.7900	16.2000	17.1500	145.7800	16785.00	8390.00	8395.00	10	5	15	287	0.0522648083623693	0.446721294746498	0.446546457821423	false	false
b3834b8e-6516-4523-ac99-95a5039dd596	2026-09-30 14:48	2026-09-30 14:48	2026-09-30 14:48	USO	USO261023P00142500	put	142.5000	2026-10-23	5.7500	5.6000	5.7500	145.0000	30456.00	30456.00	0.00	53	24	80	86	0.930232558139535	0.516712593229662	0.516712593229662	true	false
6d281149-774e-44b5-ae61-bf475e05674b	2026-09-30 10:53	2026-09-30 10:52	2026-09-30 10:52	USO	USO261016C00145000	call	145.0000	2026-10-16	7.4100	7.4000	7.6500	146.0000	21480.00	0.00	21480.00	29	7	63	3807	0.016548463356974	0.51370764152356	0.51370764152356	false	false
3202bb7e-d527-46fb-9f4d-307912d0f2a7	2026-09-30 09:52	2026-09-30 09:52	2026-09-30 09:52	USO	USO280317P00130000	put	130.0000	2028-03-17	17.3100	17.2500	17.9500	146.0000	27690.00	20760.00	6930.00	16	5	163	1125	0.144888888888889	0.445324514598599	0.443605874134531	false	false
970613af-1637-428f-a00b-06f0233890b7	2026-09-29 15:31	2026-09-29 15:31	2026-09-29 15:31	USO	USO261120P00148000	put	148.0000	2026-11-20	13.0100	13.0000	13.2000	143.6650	41642.00	0.00	41642.00	32	6	333	234	1.42307692307692	0.512837859977565	0.512837859977565	false	false
7d864362-8b00-45fd-9091-787160fcf669	2026-09-29 14:28	2026-09-29 14:27	2026-09-29 14:27	USO	USO260930P00140000	put	140.0000	2026-09-30	0.6400	0.6000	0.6500	143.0000	15205.00	15205.00	0.00	236	48	1420	14130	0.100495399858457	0.684690385153581	0.680159510024832	false	false
8dddb9cf-deb4-48c1-b0a3-8e0384137493	2026-09-29 11:47	2026-09-29 11:47	2026-09-29 11:47	USO	USO261002P00140000	put	140.0000	2026-10-02	1.4200	1.3400	1.5000	145.4900	14227.00	7226.00	7001.00	100	8	402	4653	0.0863958736299162	0.700309038890306	0.679068528131287	false	false
40e5136f-e0f1-4d9a-8a5e-42fdef910840	2026-09-29 11:00	2026-09-29 11:00	2026-09-29 11:00	USO	USO261002P00145000	put	145.0000	2026-10-02	2.5700	2.5700	2.6100	146.8850	14137.00	0.00	14137.00	55	15	685	3925	0.174522292993631	0.655899763664359	0.653956295966018	false	false
5e2ed258-9bb5-4ccf-8035-f6bba83b958e	2026-09-29 10:51	2026-09-29 10:51	2026-09-29 10:51	USO	USO261016P00139000	put	139.0000	2026-10-16	3.6500	3.5000	3.6500	146.8850	182398.00	180238.00	2160.00	500	60	505	3280	0.153963414634146	0.568184293737818	0.568184293737818	true	false
164e25fb-05c1-486e-aa7f-dc709dd960b4	2026-09-29 10:40	2026-09-29 10:40	2026-09-29 10:40	USO	USO270115P00120000	put	120.0000	2027-01-15	4.3500	4.2000	4.3500	147.0400	167838.00	167838.00	0.00	386	34	2552	5903	0.432322547857022	0.500714165405583	0.499264953893905	false	false
1e82f544-ed1e-4ab7-841d-6a33a56aee55	2026-09-29 09:41	2026-09-29 09:41	2026-09-29 09:41	USO	USO261016C00145000	call	145.0000	2026-10-16	7.2600	7.0500	7.6500	145.8100	11610.00	2165.00	9445.00	16	8	147	3595	0.0408901251738526	0.539587422600544	0.531561945608835	true	false
7f9860cc-510c-4afc-8046-e5fe44d730fe	2026-09-29 09:40	2026-09-29 09:40	2026-09-29 09:40	USO	USO261016P00146000	put	146.0000	2026-10-16	6.7500	6.6000	6.7500	145.8400	83658.00	76908.00	0.00	124	25	128	606	0.211221122112211	0.542643441268602	0.542643441268602	true	false
089bec41-d01a-4669-b96e-0620d2316020	2026-09-29 09:31	2026-09-29 09:31	2026-09-29 09:31	USO	USO261023P00144000	put	144.0000	2026-10-23	7.3500	7.0000	7.3500	145.5300	52170.00	51445.00	725.00	71	21	71	310	0.229032258064516	0.559719240293162	0.552911212661522	true	false
abfbfb52-aa44-4e9f-b991-3baecb2b4af4	2026-09-28 15:53	2026-09-28 15:53	2026-09-28 15:53	USO	USO261002P00135000	put	135.0000	2026-10-02	0.4900	0.4600	0.4900	149.3000	48524.00	48524.00	0.00	1000	49	4862	5723	0.84955442949502	0.738168056210304	0.734174807302727	true	false
88894d2a-d837-4a9c-92c8-3e6cb314b085	2026-09-28 15:50	2026-09-28 15:50	2026-09-28 15:50	USO	USO261002P00130000	put	130.0000	2026-10-02	0.2100	0.1400	0.2100	149.3050	20994.00	20994.00	0.00	1000	31	4963	3164	1.56858407079646	0.781950552942496	0.774591946460312	true	false
6924a4f8-5325-4149-8d82-644aad06a055	2026-09-28 14:53	2026-09-28 14:53	2026-09-28 14:53	USO	USO261016P00139000	put	139.0000	2026-10-16	3.3500	3.3500	3.5500	148.5600	44238.00	0.00	44238.00	132	17	408	3108	0.131274131274131	0.571363888674185	0.568627531109366	false	false
155e018a-bac2-4e59-ac24-fcb8fb99ce42	2026-09-28 14:02	2026-09-28 14:01	2026-09-28 14:01	USO	USO261120P00120000	put	120.0000	2026-11-20	1.8600	1.8100	2.0000	149.0000	11138.00	0.00	11138.00	60	5	404	3726	0.108427267847558	0.535576182647295	0.535576182647295	false	false
e6813cc9-a542-4d3e-aef2-21ba2e6fefd3	2026-09-28 13:55	2026-09-28 13:55	2026-09-28 13:55	USO	USO261023P00140000	put	140.0000	2026-10-23	4.3600	4.2000	4.5500	148.8300	15255.00	1740.00	13515.00	35	7	320	764	0.418848167539267	0.545033514980427	0.541348497012431	false	false
ea754a33-40e2-453a-9914-322ae64294b6	2026-09-28 13:45	2026-09-28 13:44	2026-09-28 13:44	USO	USO260930C00149000	call	149.0000	2026-09-30	3.1400	3.0000	3.1500	149.0000	31442.00	20417.00	0.00	100	5	373	408	0.91421568627451	0.712296317097842	0.712296317097842	false	false
1b44bb4c-a3f5-4fd6-83cb-fbeb4412bd93	2026-09-28 13:17	2026-09-28 13:17	2026-09-28 13:17	USO	USO261106P00149000	put	149.0000	2026-11-06	10.7800	10.6000	10.9000	147.4900	107830.00	107830.00	0.00	100	5	219	3	73	0.537964579390408	0.537964579390408	false	false
ee794f3a-78a0-44cf-9775-19def3f1dcd2	2026-09-28 13:14	2026-09-28 13:14	2026-09-28 13:14	USO	USO260930C00150000	call	150.0000	2026-09-30	2.0400	1.9600	2.1500	147.4000	25549.00	10492.00	15057.00	125	5	909	953	0.953830010493179	0.72865415857384	0.712326999850728	true	false
98b5d70a-8c44-4aa2-9631-926abdab8147	2026-09-28 13:13	2026-09-28 13:13	2026-09-28 13:13	USO	USO261002C00149000	call	149.0000	2026-10-02	3.5000	3.3000	3.5000	147.5500	12603.00	12603.00	0.00	36	5	734	698	1.05157593123209	0.676226983631959	0.671335554053662	false	false
a04b5147-97c3-4733-96d2-5155915b386c	2026-09-28 13:11	2026-09-28 13:11	2026-09-28 13:11	USO	USO261023P00140000	put	140.0000	2026-10-23	4.6000	3.8000	4.6000	148.0005	43661.00	43661.00	0.00	95	18	233	764	0.304973821989529	0.544841807489229	0.540966671770449	true	false
322d11ac-3f2c-40c2-8a22-486c4fa22d49	2026-09-28 13:11	2026-09-28 13:11	2026-09-28 13:11	USO	USO261016P00145000	put	145.0000	2026-10-16	5.5800	5.4000	5.7500	148.2300	17300.00	5600.00	8340.00	31	15	272	4786	0.0568324279147514	0.55735183697666	0.557037977077666	true	false
045d1fe2-ed41-4412-8934-be9a0bd3b653	2026-09-28 13:02	2026-09-28 13:02	2026-09-28 13:02	USO	USO270115C00150000	call	150.0000	2027-01-15	16.1700	15.8500	16.2000	149.8850	456092.00	452872.00	3220.00	282	7	510	5083	0.100334448160535	0.471733959567986	0.4676937378592	true	false
bd392023-71bb-428b-b9b6-4e3ffae9fe0e	2026-09-28 12:41	2026-09-28 12:41	2026-09-28 12:41	USO	USO261002P00145000	put	145.0000	2026-10-02	2.2100	2.1700	2.2800	149.0000	27816.00	14119.00	12157.00	126	8	5601	4146	1.35094066570188	0.669668020532563	0.669668020532563	false	false
3e626d11-a946-47d1-9738-adf8df006c8b	2026-09-28 12:41	2026-09-28 12:40	2026-09-28 12:40	USO	USO261009C00152000	call	152.0000	2026-10-09	4.6700	4.5500	4.7000	149.0000	18695.00	18695.00	0.00	40	7	188	349	0.538681948424069	0.557475925316357	0.552612120860395	false	false
082378cb-6457-493b-a5ad-4507990e8786	2026-09-28 12:33	2026-09-28 12:33	2026-09-28 12:33	USO	USO261002P00145000	put	145.0000	2026-10-02	2.2600	2.1800	2.3900	149.4650	56376.00	0.00	56376.00	250	5	5457	4146	1.31620839363242	0.672991706828829	0.672991706828829	false	false
a3aadcf8-4592-47b6-8f81-d22c2e8e932f	2026-09-28 12:31	2026-09-28 12:31	2026-09-28 12:31	USO	USO260930C00151000	call	151.0000	2026-09-30	2.0600	1.9200	2.0500	148.9050	12350.00	11942.00	408.00	60	10	563	404	1.39356435643564	0.671228079299466	0.670292425142188	false	false
ad2bb0b1-78ce-4ce8-b954-d6b4c08d0812	2026-09-28 12:31	2026-09-28 12:30	2026-09-28 12:30	USO	USO261009C00156000	call	156.0000	2026-10-09	2.8700	2.0400	2.9900	148.0000	13210.00	11494.00	1716.00	46	10	53	301	0.176079734219269	0.548533799385645	0.545311510977415	false	false
919526bf-66e5-4321-b18f-9c4cce735b2f	2026-09-28 12:30	2026-09-28 12:30	2026-09-28 12:30	USO	USO261120P00160000	put	160.0000	2026-11-20	18.5300	17.1500	18.5500	148.0000	61135.00	31535.00	29600.00	33	12	49	437	0.112128146453089	0.529411852367374	0.527119336118747	true	false
57429c53-a0f3-4828-b63f-c0e9c620fb7d	2026-09-28 12:30	2026-09-28 12:30	2026-09-28 12:30	USO	USO261120P00161000	put	161.0000	2026-11-20	19.2200	17.0000	19.2500	148.0000	67285.00	67285.00	0.00	35	5	35	205	0.170731707317073	0.530511054346325	0.530511054346325	false	false
9b18b8a1-904f-4d09-b9c7-ea03a2374ae4	2026-09-28 12:26	2026-09-28 12:26	2026-09-28 12:26	USO	USO261002P00160000	put	160.0000	2026-10-02	11.4700	10.1000	11.5500	149.3000	25229.00	18449.00	6780.00	22	9	77	310	0.248387096774194	0.684451167242698	0.599528462469987	false	false
47fb71b5-41c2-4b03-9416-326ea6ff444b	2026-09-28 12:23	2026-09-28 12:22	2026-09-28 12:22	USO	USO261007C00152000	call	152.0000	2026-10-07	4.5200	4.5000	6.4000	150.2766	35681.00	0.00	35681.00	79	7	125	6	20.8333333333333	0.558004300789684	0.558004300789684	false	false
902bf032-270f-4308-926b-1b5f737f8200	2026-09-28 12:19	2026-09-28 12:19	2026-09-28 12:19	USO	USO261002C00152000	call	152.0000	2026-10-02	3.6300	3.4000	4.6500	151.3050	27192.00	0.00	27192.00	75	10	564	464	1.21551724137931	0.62485665421066	0.62485665421066	false	false
72530d39-deab-4c19-8d48-c98d595936c1	2026-09-28 11:25	2026-09-28 11:25	2026-09-28 11:25	USO	USO261009P00130000	put	130.0000	2026-10-09	0.4500	0.4200	0.4500	153.0000	18605.00	18605.00	0.00	414	6	720	814	0.884520884520885	0.640622727003046	0.640622727003046	false	false
800cf09e-e02e-41cb-b37e-47cde01447b8	2026-09-28 11:22	2026-09-28 11:22	2026-09-28 11:22	USO	USO260930C00150000	call	150.0000	2026-09-30	4.8900	4.6500	5.3500	153.0000	24440.00	0.00	24440.00	50	5	255	953	0.267576075550892	0.648743847133223	0.648743847133223	false	false