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.

425,429 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts425,429 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:source = uw_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	strikenumeric	expirydate

112d3e59-64ab-4b9e-9f7f-681c93b4f857	2026-09-24 10:56	2026-09-24 10:56	2026-09-24 10:56	USO	USO260925C00153000	call	153.0000	2026-09-25	2.0000	1.9000	2.1200	153.4050	14800.00	12400.00	2400.00	74	5	1560	2348	0.664395229982964	0.556829280890472	0.556829280890472	true	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	Financial Services	1228364647.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-24T14:58:33.796895Z"}	2026-09-24	2026-09-24 21:15	2026-09-24 21:15
1507dc78-54a7-47ba-ae0e-5dc30ba1a853	2026-09-24 10:50	2026-09-24 10:50	2026-09-24 10:50	USO	USO261023P00149000	put	149.0000	2026-10-23	6.4500	6.3500	6.5000	153.0000	14835.00	14835.00	0.00	23	5	23	108	0.212962962962963	0.505070735208675	0.505070735208675	true	false	false	true
54bb2b36-d5fe-419f-862a-508542017bf8	2026-09-24 10:48	2026-09-24 10:48	2026-09-24 10:48	USO	USO261120P00150000	put	150.0000	2026-11-20	10.0000	9.8000	10.0500	153.0000	53983.00	52983.00	1000.00	54	12	101	1767	0.057159026598755	0.500510057625927	0.500510057625927	true	false	false	true
e6847536-f791-4f06-94dd-ab8f04dfbf6e	2026-09-24 10:48	2026-09-24 10:48	2026-09-24 10:48	USO	USO270115C00156000	call	156.0000	2027-01-15	15.3000	13.3500	15.6500	153.0000	68835.00	55065.00	13770.00	45	11	46	143	0.321678321678322	0.461628408401068	0.461628408401068	true	false	false	true
c017ad45-396e-40b0-b39a-1f8595421869	2026-09-24 10:46	2026-09-24 10:46	2026-09-24 10:46	USO	USO261030C00155000	call	155.0000	2026-10-30	9.0000	8.5000	9.0000	153.0000	90000.00	90000.00	0.00	100	5	193	477	0.40461215932914	0.494818008425544	0.494818008425544	true	false	false	true
2477a169-e70d-419d-8e7d-85f1b5b23636	2026-09-24 10:46	2026-09-24 10:45	2026-09-24 10:45	USO	USO270115C00149000	call	149.0000	2027-01-15	18.4400	16.9500	18.6000	153.2618	23976.00	22131.00	1845.00	13	10	13	56	0.232142857142857	0.45524755409519	0.45524755409519	false	false	false	true
3d93b71e-5445-42ef-abd5-39a2eddc2778	2026-09-24 10:44	2026-09-24 10:44	2026-09-24 10:44	USO	USO270617C00191000	call	191.0000	2027-06-17	12.1500	11.4500	12.1500	153.1300	36444.00	34020.00	2424.00	30	14	30	78	0.384615384615385	0.435672249933564	0.435672249933564	false	false	false	true
4a71dedf-58a8-4cb8-af7a-c3a45b55aa9f	2026-09-24 10:44	2026-09-24 10:44	2026-09-24 10:44	USO	USO261009P00153000	put	153.0000	2026-10-09	6.0500	5.9000	6.1500	153.1200	26620.00	25410.00	605.00	44	11	121	280	0.432142857142857	0.504210332523393	0.504210332523393	true	false	false	true
b8c9a399-3ce6-49a0-bafa-9b11f90ca2f6	2026-09-24 10:42	2026-09-24 10:42	2026-09-24 10:42	USO	USO261120C00167000	call	167.0000	2026-11-20	7.1000	6.9000	7.2500	153.0300	11360.00	10650.00	710.00	16	9	16	772	0.0207253886010363	0.498529022554163	0.498529022554163	true	false	false	true
42b2fa21-a621-47aa-9ae5-281b76b0632b	2026-09-24 10:42	2026-09-24 10:42	2026-09-24 10:42	USO	USO261030C00155000	call	155.0000	2026-10-30	8.8000	8.5000	8.8500	152.9477	25515.00	24635.00	0.00	29	19	92	477	0.192872117400419	0.493759178338736	0.493759178338736	true	false	false	true
37930fc3-83a2-470f-94c0-da6dcecb4319	2026-09-24 10:42	2026-09-24 10:42	2026-09-24 10:42	USO	USO270617P00141000	put	141.0000	2027-06-17	15.3500	15.3500	15.8500	152.9300	81355.00	0.00	81355.00	53	15	53	15	3.53333333333333	0.462871946652608	0.462871946652608	false	false	false	true
09e2ac81-db7f-4f0d-a9b4-0339aedfba90	2026-09-24 10:40	2026-09-24 10:40	2026-09-24 10:40	USO	USO270115P00145000	put	145.0000	2027-01-15	11.2000	11.0500	11.5000	152.7800	100800.00	95200.00	5600.00	90	17	92	3466	0.0265435660703982	0.475733847454	0.475733847454	false	false	false	true
493cc9f9-b9b1-4c19-ac14-283ecc551180	2026-09-24 10:37	2026-09-24 10:36	2026-09-24 10:36	USO	USO290119C00152000	call	152.0000	2029-01-19	38.1600	37.6000	41.0000	152.6894	38155.00	0.00	38155.00	10	6	25	0	0	0.333713556575639	0.333713556575639	false	false	false	true
84adef9b-d950-4d3d-af02-e5d08d946922	2026-09-24 10:35	2026-09-24 10:35	2026-09-24 10:35	USO	USO261016P00140000	put	140.0000	2026-10-16	2.5600	2.5500	2.5900	152.4600	12800.00	0.00	12800.00	50	8	224	8619	0.025989093862397	0.505784875189949	0.505784875189949	false	false	false	true
67cb9eeb-8167-42d6-8abf-f050abda3bfa	2026-09-24 10:24	2026-09-24 10:24	2026-09-24 10:24	USO	USO261030C00155000	call	155.0000	2026-10-30	8.4000	8.1500	8.4000	152.1750	23520.00	23520.00	0.00	28	7	61	477	0.127882599580713	0.493064784333605	0.493064784333605	true	false	false	true
58bc8767-fa28-4b9a-aaa0-6138993ef299	2026-09-24 10:24	2026-09-24 10:24	2026-09-24 10:24	USO	USO261030C00159000	call	159.0000	2026-10-30	6.8500	6.6500	6.9000	152.1750	18490.00	17805.00	685.00	27	12	27	192	0.140625	0.495460580762734	0.495460580762734	true	false	false	true
1ad57c54-7063-4fe3-9aad-10fbf1104259	2026-09-24 10:24	2026-09-24 10:24	2026-09-24 10:24	USO	USO261023C00157000	call	157.0000	2026-10-23	6.6000	6.4000	6.6000	152.1750	19800.00	19800.00	0.00	30	7	64	103	0.621359223300971	0.49544104563865	0.49544104563865	true	false	false	true
3534eb42-cc8f-4fe9-80e6-a498404d1f8a	2026-09-24 10:18	2026-09-24 10:18	2026-09-24 10:18	USO	USO261016P00153000	put	153.0000	2026-10-16	7.7000	7.6500	7.7000	152.1300	29260.00	29260.00	0.00	38	7	62	583	0.106346483704974	0.499220109510967	0.499220109510967	false	false	false	true
2fba0783-4ac9-457e-bcbe-d118de8883b5	2026-09-24 10:17	2026-09-24 10:17	2026-09-24 10:17	USO	USO261016P00153000	put	153.0000	2026-10-16	7.7500	7.6500	7.7500	151.9900	18600.00	18600.00	0.00	24	6	24	583	0.0411663807890223	0.497991028641136	0.497991028641136	false	false	false	true
fe996147-75fd-4524-9cb2-60d48e9e40c7	2026-09-24 10:17	2026-09-24 10:17	2026-09-24 10:17	USO	USO261002C00158000	call	158.0000	2026-10-02	2.2700	2.1800	2.2800	151.9200	11804.00	11804.00	0.00	52	9	62	329	0.188449848024316	0.508416539377149	0.508416539377149	true	false	false	true
36d6d62c-0233-4c40-8b60-2f4050e00969	2026-09-24 10:17	2026-09-24 10:17	2026-09-24 10:17	USO	USO261002C00157000	call	157.0000	2026-10-02	2.5700	2.4800	2.5700	151.9200	10794.00	10794.00	0.00	42	9	120	968	0.12396694214876	0.50763726284651	0.50763726284651	true	false	false	true
e8b2f046-c1f4-40bf-aaba-72b2d9939d13	2026-09-24 10:16	2026-09-24 10:16	2026-09-24 10:16	USO	USO261016C00161000	call	161.0000	2026-10-16	3.9500	3.8500	3.9500	151.7600	11060.00	11060.00	0.00	28	9	38	241	0.157676348547718	0.495095109684985	0.495095109684985	true	false	false	true
7cb85ff3-f9d4-496a-b9d2-af5ee193f4bb	2026-09-24 10:15	2026-09-24 10:15	2026-09-24 10:15	USO	USO261016C00175000	call	175.0000	2026-10-16	1.3800	1.3800	1.4400	151.6400	13800.00	0.00	13800.00	100	5	161	2013	0.079980129160457	0.516082391536684	0.516082391536684	false	false	false	true
b94b3d27-b839-45bb-92f4-b08771088734	2026-09-24 10:13	2026-09-24 10:13	2026-09-24 10:13	USO	USO261002C00154000	call	154.0000	2026-10-02	3.5000	3.4500	3.5000	151.5475	20650.00	20650.00	0.00	59	12	129	536	0.240671641791045	0.506341540111237	0.506341540111237	true	false	false	true
e0e7ec59-76c8-40f8-b0de-c42f32bafb70	2026-09-24 10:12	2026-09-24 10:12	2026-09-24 10:12	USO	USO261016C00157000	call	157.0000	2026-10-16	5.1000	4.9500	5.1000	151.3200	10710.00	10710.00	0.00	21	10	73	331	0.220543806646526	0.494580690718458	0.494580690718458	false	false	false	true
aacae91e-cb26-483a-bfa8-e1a7e7706453	2026-09-24 10:07	2026-09-24 10:07	2026-09-24 10:07	USO	USO261218P00151000	put	151.0000	2026-12-18	12.9000	12.9000	13.4500	151.2800	10320.00	0.00	10320.00	8	5	13	99	0.131313131313131	0.476095386762146	0.476095386762146	false	false	false	true
9ce36616-5d4f-437c-9672-d8f54bcf3547	2026-09-24 10:06	2026-09-24 10:06	2026-09-24 10:06	USO	USO280616P00120000	put	120.0000	2028-06-16	13.8900	12.3500	13.9000	151.3800	70860.00	70860.00	0.00	51	10	51	492	0.103658536585366	0.448042253164441	0.448042253164441	false	false	false	true
af827106-fa0c-4b35-8174-e5997a79fb00	2026-09-24 10:02	2026-09-24 10:02	2026-09-24 10:02	USO	USO261016P00150000	put	150.0000	2026-10-16	6.6000	6.5000	6.6000	151.2050	11220.00	11220.00	0.00	17	5	64	3312	0.0193236714975845	0.499620382412503	0.499620382412503	false	false	false	true
7c79a683-3b5a-4f30-84ea-197187befa0e	2026-09-24 10:00	2026-09-24 10:00	2026-09-24 10:00	USO	USO261016P00152500	put	152.5000	2026-10-16	7.8000	7.6000	7.8000	151.4100	12480.00	12480.00	0.00	16	5	16	15	1.06666666666667	0.500317131221158	0.500317131221158	false	false	false	true
3003bdae-10bf-4b06-ac5f-6c568fc7a9c1	2026-09-24 09:59	2026-09-24 09:59	2026-09-24 09:59	USO	USO261002P00146000	put	146.0000	2026-10-02	2.3500	2.3500	2.4300	151.3600	12455.00	0.00	12455.00	53	9	67	395	0.169620253164557	0.522014103208189	0.522014103208189	true	false	false	true
8908ea36-6832-4639-b855-29c21767d45a	2026-09-24 09:57	2026-09-24 09:56	2026-09-24 09:56	USO	USO261120P00130000	put	130.0000	2026-11-20	3.1500	3.1500	3.2500	151.1300	31500.00	0.00	31500.00	100	8	208	2931	0.0709655407710679	0.487992211038725	0.487992211038725	false	false	false	true
caabc50a-d381-4e64-9736-c812424772f5	2026-09-24 09:53	2026-09-24 09:53	2026-09-24 09:53	USO	USO261218P00150000	put	150.0000	2026-12-18	12.4000	12.4000	12.9000	151.1000	12400.00	0.00	12400.00	10	6	21	1547	0.0135746606334842	0.47394429020396	0.47394429020396	false	false	false	true
f3f2da2a-fc33-4abe-ad2b-c26dfe8d0f7e	2026-09-24 09:51	2026-09-24 09:51	2026-09-24 09:51	USO	USO261016P00124000	put	124.0000	2026-10-16	0.5400	0.4900	0.5500	151.4701	10840.00	10840.00	0.00	200	10	258	704	0.366477272727273	0.552042939286002	0.54974940651417	false	false	false	true
26e5330f-f231-4998-8dcf-27211d9a0a8e	2026-09-24 09:48	2026-09-24 09:48	2026-09-24 09:48	USO	USO261009C00156000	call	156.0000	2026-10-09	4.3000	4.3000	4.4500	151.5200	16770.00	0.00	16770.00	39	11	176	106	1.66037735849057	0.497952342835966	0.497952342835966	false	false	false	true
350f86f5-a373-46ae-83dd-7e42f9910ab1	2026-09-24 09:45	2026-09-24 09:45	2026-09-24 09:45	USO	USO261030C00161000	call	161.0000	2026-10-30	5.9000	5.8500	6.1000	151.5200	20650.00	1180.00	19470.00	35	11	49	635	0.0771653543307087	0.495525354027945	0.496163453595178	true	false	false	true
2260ac84-ba38-403f-9c5e-f1e216fa68a8	2026-09-24 09:45	2026-09-24 09:45	2026-09-24 09:45	USO	USO261030C00162000	call	162.0000	2026-10-30	5.6000	5.5000	5.8000	151.5500	12320.00	560.00	11760.00	22	6	22	516	0.0426356589147287	0.496708312809684	0.496708312809684	false	false	false	true
eb6b4842-fdfc-4550-93bf-061be9abd832	2026-09-24 09:45	2026-09-24 09:45	2026-09-24 09:45	USO	USO261009C00163000	call	163.0000	2026-10-09	2.4100	2.4000	2.5100	151.6800	16629.00	0.00	15183.00	69	16	77	441	0.174603174603175	0.511257623882812	0.511257623882812	false	false	false	true
60c11be6-aecd-46bd-b079-f97ecf820a6f	2026-09-24 09:44	2026-09-24 09:44	2026-09-24 09:44	USO	USO261120P00170000	put	170.0000	2026-11-20	23.6000	23.4000	24.7000	151.6100	125080.00	0.00	125080.00	53	15	53	68	0.779411764705882	0.523075062813139	0.523075062813139	true	false	false	true
ff1cc9ef-628d-4566-8d3e-04e42e7385d5	2026-09-24 09:44	2026-09-24 09:44	2026-09-24 09:44	USO	USO261016C00157500	call	157.5000	2026-10-16	5.0500	5.0500	5.2500	151.5850	24754.00	0.00	24754.00	49	9	73	175	0.417142857142857	0.496143974554536	0.496143974554536	true	false	false	true
c9b97c07-f56e-41e0-9d6e-60f4897cf90c	2026-09-24 09:44	2026-09-24 09:44	2026-09-24 09:44	USO	USO261023C00161000	call	161.0000	2026-10-23	5.0000	5.0000	5.1000	151.5850	19500.00	0.00	19500.00	39	10	90	159	0.566037735849057	0.498673711997369	0.498673711997369	true	false	false	true
3f75eed0-2e9d-4e03-a54c-6f4bb4d1d65b	2026-09-24 09:44	2026-09-24 09:44	2026-09-24 09:44	USO	USO261016C00165000	call	165.0000	2026-10-16	3.0000	2.9900	3.1500	151.5850	21900.00	300.00	21600.00	73	15	124	4272	0.0290262172284644	0.507680900665424	0.507680900665424	true	false	false	true
ec81df74-06fa-4f36-8732-8a77097117f2	2026-09-24 09:43	2026-09-24 09:43	2026-09-24 09:43	USO	USO261007C00151000	call	151.0000	2026-10-07	6.0000	6.0000	6.7000	151.6101	21612.00	0.00	21612.00	36	10	36	32	1.125	0.490180974234835	0.490180974234835	false	false	false	true
470934db-8002-4c42-a143-1258bec8b522	2026-09-24 09:43	2026-09-24 09:43	2026-09-24 09:43	USO	USO261009C00157500	call	157.5000	2026-10-09	3.8500	3.8500	4.0000	151.6000	19635.00	0.00	19635.00	51	11	53	75	0.706666666666667	0.502436389205185	0.502436389205185	true	false	false	true
01e92835-5b9b-4afc-a76f-9fcce3b0e287	2026-09-24 09:42	2026-09-24 09:42	2026-09-24 09:42	USO	USO261016C00160000	call	160.0000	2026-10-16	4.3000	4.2500	4.4500	151.6890	16770.00	0.00	14620.00	39	6	51	4675	0.0109090909090909	0.499998357903147	0.499998357903147	true	false	false	true
116d1605-cd09-4770-8764-95c2562510d6	2026-09-24 09:42	2026-09-24 09:42	2026-09-24 09:42	USO	USO261009C00160000	call	160.0000	2026-10-09	3.1500	3.0000	3.3000	151.7100	19845.00	1260.00	18585.00	63	11	68	740	0.0918918918918919	0.506613738716674	0.506613738716674	false	false	false	true
35c5756f-ef92-4369-91ce-dfd9f3586da6	2026-09-24 09:42	2026-09-24 09:42	2026-09-24 09:42	USO	USO261009C00156000	call	156.0000	2026-10-09	4.4500	4.4000	4.5500	151.8800	44055.00	0.00	41830.00	99	17	115	106	1.08490566037736	0.497949378280719	0.497949378280719	false	false	false	true
cdb3339c-5de2-4380-a124-52006e94c0a5	2026-09-24 09:40	2026-09-24 09:40	2026-09-24 09:40	USO	USO261002P00151000	put	151.0000	2026-10-02	4.2500	4.2000	4.3500	151.7100	12750.00	6375.00	6375.00	30	5	88	284	0.309859154929577	0.521525744572506	0.521525744572506	false	false	false	true
5b0ea7a0-54fc-4822-a907-a146917a2448	2026-09-24 09:38	2026-09-24 09:38	2026-09-24 09:38	USO	USO261009C00158000	call	158.0000	2026-10-09	3.7000	3.6500	3.8500	151.6600	31080.00	0.00	29970.00	84	15	200	181	1.10497237569061	0.502031868764331	0.502031868764331	false	false	false	true
ce0ad86e-9b23-44ce-9de8-956f60a8dc00	2026-09-24 09:38	2026-09-24 09:38	2026-09-24 09:38	USO	USO261009C00157000	call	157.0000	2026-10-09	4.0500	4.0500	4.2000	151.6886	19440.00	0.00	19440.00	48	12	119	369	0.322493224932249	0.501773048197072	0.501773048197072	false	false	false	true
1d3ab091-c10d-4c0e-9b1c-77972590d0e1	2026-09-24 09:38	2026-09-24 09:38	2026-09-24 09:38	USO	USO261009C00155000	call	155.0000	2026-10-09	4.7500	4.5500	4.9500	151.6886	28975.00	475.00	28500.00	61	14	162	364	0.445054945054945	0.497214345395266	0.497214345395266	false	false	false	true