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 = RepeatedHits×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

2dea71c5-b1ee-48ca-b47e-304a81af9d73	2026-09-25 15:59	2026-09-25 15:59	2026-09-25 15:59	USO	USO261016P00149000	put	149.0000	2026-10-16	7.8500	7.8000	7.8500	148.0000	54950.00	51025.00	0.00	70	13	185	326	0.567484662576687	0.54125438709404	0.54125438709404	true	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	Financial Services	1228364647.00	—	—	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500}	2026-09-25	2026-09-25 21:15	2026-09-25 21:15
d5b0cabb-9be7-401d-8f64-d47f08ba780d	2026-09-25 15:55	2026-09-25 15:55	2026-09-25 15:55	USO	USO261016C00140000	call	140.0000	2026-10-16	12.5500	12.4500	12.7000	148.4200	47690.00	1255.00	46435.00	38	6	235	5388	0.043615441722346	0.535075290107578	0.535075290107578	true	false	false	true
33d760c6-0a4b-4264-b3fa-a9f7a6b95c0f	2026-09-25 15:37	2026-09-25 15:37	2026-09-25 15:37	USO	USO260930C00159000	call	159.0000	2026-09-30	0.6600	0.6500	0.6600	148.0000	42900.00	42900.00	0.00	650	7	745	541	1.37707948243993	0.513396802438108	0.513396802438108	true	false	false	true
93c9a6b8-b0bb-4dfd-873c-af081db5a30a	2026-09-25 15:33	2026-09-25 15:33	2026-09-25 15:33	USO	USO261016P00150000	put	150.0000	2026-10-16	8.0500	7.9500	8.0500	149.0050	12880.00	12880.00	0.00	16	7	600	4119	0.145666423889294	0.540702745925297	0.540702745925297	true	false	false	true
af191b27-934c-47eb-bdbc-b655fd99de3f	2026-09-25 15:30	2026-09-25 15:30	2026-09-25 15:30	USO	USO280121P00121000	put	121.0000	2028-01-21	12.9000	11.5500	12.9000	148.9700	12900.00	12900.00	0.00	10	7	25	561	0.0445632798573975	0.456846597408609	0.456846597408609	true	false	false	true
466c45b5-6dc8-4344-b901-35e9082138d2	2026-09-25 15:28	2026-09-25 15:28	2026-09-25 15:28	USO	USO261023P00148000	put	148.0000	2026-10-23	8.0500	7.9000	8.1500	149.0600	23345.00	23345.00	0.00	29	7	157	311	0.504823151125402	0.536696274094041	0.536696274094041	false	false	false	true
8d3e85d4-20f3-4f73-aac1-0f67b9271346	2026-09-25 15:16	2026-09-25 15:16	2026-09-25 15:16	USO	USO260930P00128000	put	128.0000	2026-09-30	0.1400	0.0800	0.1400	149.1800	14000.00	14000.00	0.00	1000	9	3688	384	9.60416666666667	0.706075038572014	0.706075038572014	true	false	false	true
a228b19c-cfb5-48f5-83b8-7c7b7bbb0768	2026-09-25 15:16	2026-09-25 15:16	2026-09-25 15:16	USO	USO260925C00147000	call	147.0000	2026-09-25	2.0500	1.3000	2.0500	149.0201	24600.00	24600.00	0.00	120	6	846	746	1.13404825737265	0.939034186644863	0.939034186644863	false	false	false	true
87468b1b-8903-40cc-b7e6-74c366e4c708	2026-09-25 15:09	2026-09-25 15:08	2026-09-25 15:08	USO	USO261002C00155000	call	155.0000	2026-10-02	2.1500	2.1000	2.1500	148.0000	10750.00	10750.00	0.00	50	16	2562	1155	2.21818181818182	0.546759471401305	0.546759471401305	false	false	false	true
e2e6172b-c8a3-49a4-bcfc-c4ca163430c2	2026-09-25 15:01	2026-09-25 15:01	2026-09-25 15:01	USO	USO261120P00120000	put	120.0000	2026-11-20	2.0000	2.0000	2.0300	148.0000	20000.00	0.00	20000.00	100	7	430	3588	0.11984392419175	0.526778339575985	0.526778339575985	false	false	false	true
591aa0e6-f1a7-443e-ac5e-47963cf0effd	2026-09-25 14:57	2026-09-25 14:57	2026-09-25 14:57	USO	USO261120C00150000	call	150.0000	2026-11-20	11.2000	11.0000	11.4500	148.0000	22400.00	3360.00	19040.00	20	5	1007	4633	0.217353766458019	0.499821701567504	0.498678369637995	false	false	false	true
662b0363-6c0c-47d7-b5c3-25520ffa8d7a	2026-09-25 14:39	2026-09-25 14:39	2026-09-25 14:39	USO	USO260925C00150000	call	150.0000	2026-09-25	0.0600	0.0500	0.0600	148.4290	10488.00	10488.00	0.00	1748	42	7021	4563	1.53868069252685	0.669157051970127	0.669157051970127	false	false	false	true
d8a64cfe-de65-4e4a-ae32-2af6558a1427	2026-09-25 14:37	2026-09-25 14:37	2026-09-25 14:37	USO	USO261030P00139000	put	139.0000	2026-10-30	5.2500	5.2500	5.4500	148.2500	22050.00	0.00	22050.00	42	12	82	202	0.405940594059406	0.528559892040633	0.528559892040633	false	false	false	true
0c359c04-1e65-4f0a-9414-09da15361835	2026-09-25 14:35	2026-09-25 14:35	2026-09-25 14:35	USO	USO260930P00140000	put	140.0000	2026-09-30	1.0900	1.0300	1.1400	148.1950	16350.00	11772.00	0.00	150	5	1950	5296	0.368202416918429	0.581658068150406	0.581658068150406	true	false	false	true
48e24b31-c409-419f-91fe-4bd9ff256bd7	2026-09-25 14:29	2026-09-25 14:29	2026-09-25 14:29	USO	USO260930P00141000	put	141.0000	2026-09-30	1.2000	1.1700	1.2500	148.5850	21098.00	0.00	18480.00	176	19	1653	2572	0.642690513219285	0.575439267429506	0.575439267429506	true	false	false	true
fcee7021-8acd-4411-a2ab-c3b75b206fd0	2026-09-25 14:27	2026-09-25 14:27	2026-09-25 14:27	USO	USO261120C00150000	call	150.0000	2026-11-20	11.3000	11.2500	11.3000	148.5800	58760.00	58760.00	0.00	52	5	861	4633	0.185840707964602	0.496578599238722	0.496578599238722	false	false	false	true
c3447ea8-61e6-4f8b-9cbf-641886280451	2026-09-25 14:27	2026-09-25 14:27	2026-09-25 14:27	USO	USO261120C00150000	call	150.0000	2026-11-20	11.2500	11.2500	11.6000	148.5800	76500.00	0.00	76500.00	68	6	929	4633	0.200518022879344	0.494417974177791	0.494417974177791	false	false	false	true
a30a1270-7bd1-4079-abd3-ef64f520bfba	2026-09-25 14:27	2026-09-25 14:27	2026-09-25 14:27	USO	USO261120C00150000	call	150.0000	2026-11-20	11.3000	11.2500	11.7000	148.5800	183060.00	51980.00	126560.00	162	12	292	4633	0.0630261169868336	0.496578599238722	0.496578599238722	false	false	false	true
04f14fb6-67f0-47ad-9414-6658c1dbea32	2026-09-25 14:27	2026-09-25 14:27	2026-09-25 14:27	USO	USO261120C00150000	call	150.0000	2026-11-20	11.3000	11.3000	11.6000	148.5800	194360.00	0.00	194360.00	172	7	464	4633	0.100151090006475	0.496578599238722	0.496578599238722	false	false	false	true
9ada2f8e-8ea3-4997-b595-b26b43578dc5	2026-09-25 14:00	2026-09-25 14:00	2026-09-25 14:00	USO	USO261016C00170000	call	170.0000	2026-10-16	1.5500	1.5500	1.6100	148.0000	20150.00	0.00	20150.00	130	8	2762	7077	0.390278366539494	0.539229823936438	0.539229823936438	false	false	false	true
0c89b825-fc83-4a6b-9471-3262eafad210	2026-09-25 13:57	2026-09-25 13:57	2026-09-25 13:57	USO	USO261120P00115000	put	115.0000	2026-11-20	1.3700	1.3000	1.3700	148.2500	13700.00	13700.00	0.00	100	8	2224	2735	0.813162705667276	0.532191003958065	0.532191003958065	false	false	false	true
f215cd83-08c3-4e00-b9a2-326f3b5090f8	2026-09-25 13:53	2026-09-25 13:53	2026-09-25 13:53	USO	USO260930P00130000	put	130.0000	2026-09-30	0.2100	0.1500	0.2200	148.2500	21000.00	17472.00	3528.00	1000	59	5230	8482	0.616599858523933	0.671454549000759	0.671454549000759	true	false	false	true
59ab3fb4-ce1f-4e69-a282-d0c88f4a1e3a	2026-09-25 13:52	2026-09-25 13:52	2026-09-25 13:52	USO	USO261016C00170000	call	170.0000	2026-10-16	1.6200	1.5800	1.6200	148.3600	17820.00	972.00	0.00	110	7	2582	7077	0.364843860392822	0.54184185751847	0.54184185751847	false	false	false	true
58c4c9b3-2cb6-49be-9e8f-4939561f9b67	2026-09-25 13:52	2026-09-25 13:52	2026-09-25 13:52	USO	USO261016C00170000	call	170.0000	2026-10-16	1.6100	1.5800	1.6300	148.3700	25760.00	22057.00	1288.00	160	16	2472	7077	0.349300551080967	0.540531197107849	0.540531197107849	false	false	false	true
bd520742-57d9-4c5f-89c9-f61e3c612e27	2026-09-25 13:46	2026-09-25 13:46	2026-09-25 13:46	USO	USO261016P00143000	put	143.0000	2026-10-16	5.0000	5.0000	5.1500	148.3700	12000.00	0.00	12000.00	24	6	182	789	0.230671736375158	0.539623022068241	0.539623022068241	false	false	false	true
7b3ff409-43a8-4f73-8d73-6204b1953c4f	2026-09-25 13:42	2026-09-25 13:42	2026-09-25 13:42	USO	USO261016P00140000	put	140.0000	2026-10-16	4.1000	4.1000	4.1500	147.9900	11480.00	0.00	11480.00	28	7	794	8698	0.0912853529547022	0.54825180911882	0.54825180911882	true	false	false	true
16f20277-9c79-43ac-a910-73b47fd9480a	2026-09-25 13:39	2026-09-25 13:39	2026-09-25 13:39	USO	USO261016P00131000	put	131.0000	2026-10-16	1.6800	1.5700	1.6800	148.0000	18144.00	18144.00	0.00	108	8	136	803	0.169364881693649	0.560399202739707	0.560399202739707	false	false	false	true
be56485a-7170-4672-808e-26d92d0cf7c9	2026-09-25 13:37	2026-09-25 13:37	2026-09-25 13:37	USO	USO261016C00145000	call	145.0000	2026-10-16	9.6500	9.5000	9.9500	148.0000	91675.00	14475.00	77200.00	95	6	200	3549	0.0563539025077487	0.527850888054828	0.526730348360725	false	false	false	true
5b72c1ad-e0be-48f9-847a-88c4c1576fd8	2026-09-25 13:31	2026-09-25 13:31	2026-09-25 13:31	USO	USO261016P00140000	put	140.0000	2026-10-16	4.0500	4.0000	4.1000	147.9743	11745.00	0.00	9720.00	29	5	684	8698	0.0786387675327661	0.543851713318505	0.543851713318505	false	false	false	true
b27896df-b15b-4185-a0b6-438b3e2c50b9	2026-09-25 13:27	2026-09-25 13:27	2026-09-25 13:27	USO	USO261023C00157500	call	157.5000	2026-10-23	5.0000	5.0000	5.1500	148.1900	26500.00	0.00	26500.00	53	13	69	209	0.330143540669856	0.51719459395478	0.51719459395478	true	false	false	true
c51c492f-71c9-4071-8b16-1c166fce5c25	2026-09-25 13:22	2026-09-25 13:22	2026-09-25 13:22	USO	USO261016C00165000	call	165.0000	2026-10-16	2.2800	2.2600	2.3200	148.0000	27360.00	0.00	27360.00	120	8	346	4305	0.0803716608594657	0.529253951639329	0.529253951639329	false	false	false	true
14124b9c-d7be-4427-ad9f-fee5c8e534ca	2026-09-25 12:54	2026-09-25 12:54	2026-09-25 12:54	USO	USO270115P00105000	put	105.0000	2027-01-15	1.8400	1.7400	1.8900	148.1101	46000.00	3128.00	18584.00	250	32	272	5436	0.0500367917586461	0.520888443974372	0.520888443974372	false	false	false	true
908f7d51-bc21-4511-8f0a-fcf8b4d60c8c	2026-09-25 12:51	2026-09-25 12:51	2026-09-25 12:51	USO	USO261009P00145000	put	145.0000	2026-10-09	4.7000	4.7000	5.4000	148.0748	13160.00	0.00	13160.00	28	9	236	569	0.414762741652021	0.54308575702294	0.54308575702294	true	false	false	true
97f7dad6-e119-4d4a-a68f-cd923d45e1c3	2026-09-25 12:47	2026-09-25 12:47	2026-09-25 12:47	USO	USO261016C00154000	call	154.0000	2026-10-16	5.0500	5.0500	5.7500	148.0100	16665.00	0.00	16665.00	33	9	114	215	0.530232558139535	0.522448511413689	0.522448511413689	false	false	false	true
c5ae427f-2ad1-40df-b3bc-b20613478455	2026-09-25 12:45	2026-09-25 12:45	2026-09-25 12:45	USO	USO261016C00153000	call	153.0000	2026-10-16	5.4500	5.4500	6.4000	148.0150	14170.00	0.00	14170.00	26	7	83	612	0.13562091503268	0.524590431820791	0.524590431820791	true	false	false	true
5fe90753-2b30-4292-9d72-66a9b733e092	2026-09-25 12:35	2026-09-25 12:34	2026-09-25 12:34	USO	USO261009C00151000	call	151.0000	2026-10-09	5.0500	4.9000	5.8000	148.3300	40415.00	30300.00	10115.00	80	5	119	108	1.10185185185185	0.530245442354494	0.530245442354494	false	false	false	true
3dbbd1a9-a1c3-4cab-ae02-d831597c69cf	2026-09-25 12:34	2026-09-25 12:34	2026-09-25 12:34	USO	USO261016C00127000	call	127.0000	2026-10-16	22.2500	21.0000	22.2500	148.6000	22250.00	22250.00	0.00	10	5	10	125	0.08	0.42589345814872	0.42589345814872	false	false	false	true
31c51ba1-8ebb-4e9d-bf04-da07d776af4e	2026-09-25 12:31	2026-09-25 12:31	2026-09-25 12:31	USO	USO261120P00115000	put	115.0000	2026-11-20	1.4400	1.3200	1.4400	147.3900	72000.00	70128.00	0.00	500	8	975	2735	0.356489945155393	0.531396039144492	0.531396039144492	false	false	false	true
e304b072-f1eb-45a6-aaed-bb34a695ed2d	2026-09-25 12:28	2026-09-25 12:27	2026-09-25 12:27	USO	USO261120P00137000	put	137.0000	2026-11-20	6.4500	6.4500	6.6500	147.0000	13551.00	0.00	13551.00	21	5	50	183	0.273224043715847	0.509164678877653	0.509164678877653	false	false	false	true
91c2b2cc-7ec3-4b85-a860-22aa7d1eaaee	2026-09-25 12:23	2026-09-25 12:23	2026-09-25 12:23	USO	USO261002C00155000	call	155.0000	2026-10-02	2.0800	2.0400	2.0900	148.4900	48464.00	5200.00	0.00	233	13	1689	1155	1.46233766233766	0.547230155111558	0.547230155111558	false	false	false	true
b869a388-9d9c-471e-99e3-a0741463ebcf	2026-09-25 12:23	2026-09-25 12:23	2026-09-25 12:23	USO	USO261002C00155000	call	155.0000	2026-10-02	2.0800	2.0400	2.0800	148.4900	46592.00	21424.00	0.00	224	12	1456	1155	1.26060606060606	0.547230155111558	0.547230155111558	true	false	false	true
a246a119-5696-428a-a89f-7d0c5ce50385	2026-09-25 12:23	2026-09-25 12:23	2026-09-25 12:23	USO	USO261002C00155000	call	155.0000	2026-10-02	2.0800	2.0300	2.0900	148.4900	94848.00	19968.00	41184.00	456	21	1232	1155	1.06666666666667	0.547230155111558	0.547230155111558	true	false	false	true
2e6cd169-ca0d-4517-bcfb-e80fe10dbf79	2026-09-25 12:23	2026-09-25 12:23	2026-09-25 12:23	USO	USO261002C00155000	call	155.0000	2026-10-02	2.0600	2.0600	2.1000	148.5100	29870.00	0.00	17510.00	145	10	657	1155	0.568831168831169	0.543598716828972	0.543598716828972	true	false	false	true
128ddfe5-440f-4712-80b4-094de83b20f8	2026-09-25 12:23	2026-09-25 12:23	2026-09-25 12:23	USO	USO261002C00155000	call	155.0000	2026-10-02	2.0700	2.0100	2.1900	148.5100	52164.00	1035.00	51129.00	252	6	512	1155	0.443290043290043	0.544993637524177	0.544993637524177	true	false	false	true
10d4e0d6-fe0b-459b-b7aa-655336553313	2026-09-25 12:21	2026-09-25 12:21	2026-09-25 12:21	USO	USO260930C00151000	call	151.0000	2026-09-30	2.4700	2.4600	2.5500	148.1400	10374.00	0.00	10374.00	42	9	374	300	1.24666666666667	0.529128415752997	0.529128415752997	true	false	false	true
d8241638-99e9-419c-b71c-a67a84ff4225	2026-09-25 12:19	2026-09-25 12:19	2026-09-25 12:19	USO	USO261120P00137000	put	137.0000	2026-11-20	6.3500	6.3500	6.5500	147.0000	18421.00	0.00	18421.00	29	9	29	183	0.158469945355191	0.50912214376478	0.510604509393751	false	false	false	true
df70e984-99ed-4f11-ab83-603fa4b0a517	2026-09-25 12:18	2026-09-25 12:18	2026-09-25 12:18	USO	USO261016P00140000	put	140.0000	2026-10-16	4.0500	4.0000	4.2000	147.0000	12555.00	405.00	12150.00	31	6	326	8698	0.0374798804322833	0.541654628506981	0.541654628506981	true	false	false	true
7bad1a96-712d-45ec-ac66-0a81c835b9ab	2026-09-25 12:16	2026-09-25 12:16	2026-09-25 12:16	USO	USO260930P00145000	put	145.0000	2026-09-30	2.6700	2.6400	2.7200	147.6519	13350.00	1335.00	12015.00	50	6	747	1683	0.443850267379679	0.568731567359517	0.568731567359517	false	false	false	true
bc4d5b21-db46-4f68-b737-777233d1e949	2026-09-25 12:15	2026-09-25 12:15	2026-09-25 12:15	USO	USO260925P00150000	put	150.0000	2026-09-25	2.7500	2.5600	2.8200	147.4400	11000.00	8800.00	2200.00	40	6	4604	4354	1.05741846577859	0.803982032144974	0.803982032144974	false	false	false	true
c6027ce2-8446-446b-b0e5-5a8240c90c7f	2026-09-25 12:14	2026-09-25 12:14	2026-09-25 12:14	USO	USO261016C00151000	call	151.0000	2026-10-16	5.9500	5.9000	6.1000	147.5895	11900.00	0.00	11900.00	20	6	146	14501	0.0100682711537135	0.517559790873777	0.517559790873777	true	false	false	true