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.

609,118 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts609,118 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:alert_rule = RepeatedHitsAscendingFill×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

cdca5fc5-e9c2-4408-90d4-d006b93a223d	2026-09-17 14:49	2026-09-17 14:49	2026-09-17 14:49	USO	USO261002P00144000	put	144.0000	2026-10-02	1.6800	1.6300	1.6900	156.1400	14614.00	14448.00	166.00	87	14	240	533	0.450281425891182	0.486322115865189	0.488664960129767	false	false	false	true	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	ETF	Financial Services	1228364647.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-17T19:06:51.574572Z"}	2026-09-17	2026-09-17 21:15	2026-09-17 21:15
ee3b3e33-05fb-41f5-8545-8e63875dbfc2	2026-09-17 14:48	2026-09-17 14:48	2026-09-17 14:48	USO	USO261016C00160000	call	160.0000	2026-10-16	7.2500	7.2000	7.4500	156.1350	158073.00	0.00	158073.00	218	28	858	4713	0.182049649904519	0.497959921807174	0.497959921807174	true	false	false	true
be8ce415-70c5-443f-986a-a38a153271ee	2026-09-17 14:47	2026-09-17 14:47	2026-09-17 14:47	USO	USO261023P00135000	put	135.0000	2026-10-23	2.2100	2.2000	2.3000	156.0639	38238.00	667.00	36908.00	173	29	234	296	0.790540540540541	0.510920087870108	0.510920087870108	true	false	false	true
97b3b204-59d2-459e-9aa8-4718b906443a	2026-09-17 14:47	2026-09-17 14:47	2026-09-17 14:47	USO	USO261023P00137000	put	137.0000	2026-10-23	2.6100	2.6000	2.7100	156.0639	12269.00	2089.00	10180.00	47	18	50	59	0.847457627118644	0.509301813502995	0.510081983593369	true	false	false	true
91ad2ca9-acee-40c1-a330-5d9fe7d4ebad	2026-09-17 14:42	2026-09-17 14:42	2026-09-17 14:42	USO	USO270917C00210000	call	210.0000	2027-09-17	13.6600	13.6500	14.4000	156.0700	336093.00	0.00	336093.00	246	17	339	186	1.82258064516129	0.441836000663839	0.441836000663839	false	false	false	true
363ef4e2-7962-4d86-b51f-6f0b985bd633	2026-09-17 14:06	2026-09-17 14:06	2026-09-17 14:06	USO	USO280616C00190000	call	190.0000	2028-06-16	25.3000	24.9500	26.2500	156.1700	83505.00	2540.00	78430.00	33	11	67	1289	0.051978277734678	0.392365487614831	0.393580578148764	false	false	false	true
fcb9ed84-0181-42b5-955f-8f17bfcabfd3	2026-09-17 13:42	2026-09-17 13:42	2026-09-17 13:42	USO	USO261016P00140000	put	140.0000	2026-10-16	2.7000	2.6000	2.7000	156.2431	63690.00	63690.00	0.00	236	9	1624	7131	0.227738045154957	0.516248011377583	0.51706356788302	true	false	false	true
5cd3177f-199d-4bde-8759-4952cb7f768d	2026-09-17 13:31	2026-09-17 13:31	2026-09-17 13:31	USO	USO260923C00159000	call	159.0000	2026-09-23	2.7900	2.7600	3.0500	156.3400	20669.00	2240.00	17869.00	74	19	111	879	0.126279863481229	0.488413641904644	0.489696896109061	true	false	false	true
9de3b382-565f-4b2c-a4c0-ea1c575a4f8d	2026-09-17 13:09	2026-09-17 13:09	2026-09-17 13:09	USO	USO261016P00159000	put	159.0000	2026-10-16	10.3700	10.0000	10.4000	156.4200	10370.00	10370.00	0.00	10	6	14	247	0.0566801619433198	0.524167163046495	0.527010083516666	true	false	false	true
abf197f6-2f61-4fe9-b87f-39b028e4eb48	2026-09-17 12:41	2026-09-17 12:41	2026-09-17 12:41	USO	USO260923C00163000	call	163.0000	2026-09-23	1.4200	1.4200	1.5300	155.3977	39640.00	143.00	38210.00	279	22	334	663	0.503770739064857	0.507592302995372	0.509188749698081	true	false	false	true
d7f30d90-1a9e-49d0-90e1-a14df6181279	2026-09-17 12:34	2026-09-17 12:33	2026-09-17 12:33	USO	USO261016C00161000	call	161.0000	2026-10-16	6.9000	6.5500	6.9500	155.6500	22755.00	16555.00	1370.00	33	11	36	110	0.327272727272727	0.510565388161197	0.513450260720186	false	false	false	true
5806639b-a29b-44f1-a869-3402c18b25c5	2026-09-17 12:31	2026-09-17 12:31	2026-09-17 12:31	USO	USO261002C00160000	call	160.0000	2026-10-02	4.4500	4.1000	4.5000	155.3800	14682.00	10232.00	4450.00	33	8	276	1321	0.20893262679788	0.49965151125104	0.502098299257945	true	false	false	true
3797bc12-4b96-4824-87a7-017309d14be5	2026-09-17 12:15	2026-09-17 12:15	2026-09-17 12:15	USO	USO261002C00158000	call	158.0000	2026-10-02	4.9500	4.6500	4.9500	154.8950	11870.00	10890.00	980.00	24	7	31	61	0.508196721311475	0.492266728001584	0.496292896061649	false	false	false	true
4f7dcd3d-15a6-4d65-a485-3071170e6364	2026-09-17 12:01	2026-09-17 12:00	2026-09-17 12:00	USO	USO261016C00180000	call	180.0000	2026-10-16	2.3100	2.3100	2.4200	154.6450	28649.00	235.00	28414.00	124	13	578	2864	0.201815642458101	0.549116511966207	0.552504314227129	false	false	false	true
9cd01607-8541-465a-8b3d-7ed8be05916f	2026-09-17 11:12	2026-09-17 11:12	2026-09-17 11:12	USO	USO260925P00152000	put	152.0000	2026-09-25	2.9500	2.7100	2.9800	154.9200	99721.00	76458.00	23263.00	338	35	451	499	0.903807615230461	0.475280629105159	0.476430089156455	true	false	false	true
62876b7c-8e84-4f11-ae45-190bd3f5abfa	2026-09-17 10:18	2026-09-17 10:18	2026-09-17 10:18	USO	USO261016C00165000	call	165.0000	2026-10-16	4.7400	4.5500	4.7500	154.0200	36481.00	36481.00	0.00	77	6	278	3462	0.0803004043905257	0.50380344587648	0.50380344587648	false	false	false	true
c76cb531-f40a-4da5-849c-bd43d6171947	2026-09-17 10:14	2026-09-17 10:14	2026-09-17 10:14	USO	USO261016P00165000	put	165.0000	2026-10-16	15.5400	15.2000	15.5500	153.8600	136722.00	136722.00	0.00	88	5	193	34	5.67647058823529	0.518387730428844	0.518387730428844	false	false	false	true
e603e277-5ab3-41c6-a5be-f3c5ca5b0393	2026-09-17 10:14	2026-09-17 10:13	2026-09-17 10:13	USO	USO261009P00148000	put	148.0000	2026-10-09	4.6100	4.6000	5.5000	153.9900	57117.00	0.00	57117.00	124	17	124	60	2.06666666666667	0.497243507449384	0.497243507449384	false	false	false	true
a8bc6a08-94e7-437d-80ec-e0f5ea50d50b	2026-09-17 10:12	2026-09-17 10:11	2026-09-17 10:11	USO	USO261120P00126000	put	126.0000	2026-11-20	2.5700	2.4800	2.6900	154.0900	25654.00	0.00	25654.00	100	6	100	866	0.115473441108545	0.509017290626719	0.509017290626719	false	false	false	true
e9b67b4e-5ffd-4d09-9d47-0a35975e1e5d	2026-09-17 10:01	2026-09-17 10:01	2026-09-17 10:01	USO	USO260930P00147000	put	147.0000	2026-09-30	2.7100	2.7000	3.0500	154.2400	12456.00	0.00	12456.00	46	14	46	482	0.0954356846473029	0.499870909355007	0.499870909355007	false	false	false	true
8f89aae0-2f85-4fa0-a442-d89ecb6b3c96	2026-09-17 09:52	2026-09-17 09:52	2026-09-17 09:52	USO	USO261030C00169000	call	169.0000	2026-10-30	5.9500	5.9000	6.6000	153.8300	15480.00	0.00	15480.00	26	13	37	0	0	0.534611291777046	0.537175885670932	true	false	false	true
f0086cab-1588-48bb-824b-867d5bc8263c	2026-09-17 09:50	2026-09-17 09:50	2026-09-17 09:50	USO	USO261016C00175000	call	175.0000	2026-10-16	2.9600	2.9600	3.1500	154.0300	29602.00	594.00	29008.00	100	23	104	1978	0.0525783619817998	0.544134632561634	0.544484461044894	false	false	false	true
ac84eb89-78d2-4d0d-8114-0e4064eb3c42	2026-09-17 09:43	2026-09-17 09:43	2026-09-17 09:43	USO	USO261030P00150000	put	150.0000	2026-10-30	8.3000	8.2000	8.7500	154.9000	47330.00	2490.00	44840.00	57	5	61	292	0.208904109589041	0.522182848942025	0.523128659541016	false	false	false	true
7984d507-2fe7-4e44-b140-a422d4450658	2026-09-17 09:36	2026-09-17 09:35	2026-09-17 09:35	USO	USO260923C00155000	call	155.0000	2026-09-23	3.5800	3.0000	3.7000	154.0240	35829.00	35829.00	0.00	100	5	146	281	0.519572953736655	0.504136412486986	0.504136412486986	false	false	false	true
234e3211-5ea8-4468-8fb1-a41a304c623a	2026-09-17 09:32	2026-09-17 09:32	2026-09-17 09:32	USO	USO260918P00153000	put	153.0000	2026-09-18	1.3200	1.3100	1.4200	154.0565	61653.00	1064.00	60589.00	467	18	472	1438	0.328233657858136	0.563401533907644	0.566609669543092	true	false	false	true
c31c04a5-1f0a-4d11-ae3a-077d6644fcfb	2026-09-16 15:56	2026-09-16 15:56	2026-09-16 15:56	USO	USO280317C00210000	call	210.0000	2028-03-17	17.2700	16.4000	17.7000	155.0000	51825.00	51825.00	0.00	30	6	64	335	0.191044776119403	0.392814987977286	0.396854967593708	false	false	false	true
9e6f94f7-61ab-400f-85f5-0891c512829b	2026-09-16 15:34	2026-09-16 15:34	2026-09-16 15:34	USO	USO260930C00169000	call	169.0000	2026-09-30	2.4500	2.4400	2.6600	156.4850	11265.00	0.00	11265.00	46	7	47	8	5.875	0.544168115463024	0.545180899794706	false	false	false	true
d4458e8d-f912-427c-ad41-1b568e0cd55d	2026-09-16 15:00	2026-09-16 15:00	2026-09-16 15:00	USO	USO280616C00310000	call	310.0000	2028-06-16	7.9100	6.8500	8.0500	157.1400	11075.00	9475.00	1600.00	14	8	16	43	0.372093023255814	0.413845892059042	0.415526305806676	false	false	false	true
af92561d-dead-4d3d-ab6a-19bbc5448390	2026-09-16 12:36	2026-09-16 12:36	2026-09-16 12:36	USO	USO260923C00160000	call	160.0000	2026-09-23	3.3000	3.0500	3.3000	156.8800	32964.00	32964.00	0.00	100	6	704	484	1.45454545454545	0.525244866104948	0.529975796953276	false	false	false	true
d4af37fb-ebd6-40d1-a2f9-6bc57ae23489	2026-09-16 12:35	2026-09-16 12:34	2026-09-16 12:34	USO	USO270115C00200000	call	200.0000	2027-01-15	7.5900	7.2000	7.7500	156.7707	14426.00	14426.00	0.00	19	11	259	4655	0.0556390977443609	0.550793146754331	0.551119001874946	false	false	false	true
32c3e883-0e73-488a-b14f-2f2529135f29	2026-09-16 11:51	2026-09-16 11:51	2026-09-16 11:51	USO	USO270617P00150000	put	150.0000	2027-06-17	19.8600	19.7500	21.3500	156.1600	83395.00	3980.00	79415.00	42	14	54	1753	0.0308043354249857	0.483351602381983	0.485346194345952	true	false	false	true
de306055-c2fd-49eb-9f17-7522cec32870	2026-09-16 11:50	2026-09-16 11:50	2026-09-16 11:50	USO	USO260923P00150000	put	150.0000	2026-09-23	2.1200	1.8600	2.5000	156.0287	14637.00	2856.00	11781.00	69	6	320	1623	0.197165742452249	0.535422093540388	0.553168298540813	false	false	false	true
8d3d8ec4-11a7-4217-bfec-380d7f3769a1	2026-09-16 11:50	2026-09-16 11:50	2026-09-16 11:50	USO	USO260923P00151000	put	151.0000	2026-09-23	2.4700	2.3900	3.9000	156.0287	18045.00	5060.00	12985.00	73	6	125	366	0.341530054644809	0.538990438252641	0.538990438252641	true	false	false	true
405eb3b8-37d9-4394-b767-f2abadb6ae4c	2026-09-16 11:29	2026-09-16 11:29	2026-09-16 11:29	USO	USO261016P00150000	put	150.0000	2026-10-16	6.4700	6.4000	6.5500	156.0600	20051.00	0.00	20051.00	31	31	1989	4753	0.418472543656638	0.53684201202085	0.53684201202085	false	false	false	true
44b84cc7-9d40-4d67-97cb-9e27ec699e77	2026-09-16 11:21	2026-09-16 11:20	2026-09-16 11:20	USO	USO260923P00160000	put	160.0000	2026-09-23	7.1400	6.9500	7.1500	155.6000	29255.00	29255.00	0.00	41	6	125	136	0.919117647058823	0.537458590374859	0.537458590374859	false	false	false	true
274c7820-9806-47ff-bba4-300d96309226	2026-09-16 11:11	2026-09-16 11:11	2026-09-16 11:11	USO	USO260930C00161000	call	161.0000	2026-09-30	4.3200	4.2000	5.4000	155.3150	14245.00	3870.00	6895.00	33	9	34	7	4.85714285714286	0.54056965577963	0.54056965577963	false	false	false	true
15efaca4-4791-42ed-ab31-6b69920a4851	2026-09-16 11:10	2026-09-16 11:10	2026-09-16 11:10	USO	USO261016P00150000	put	150.0000	2026-10-16	6.5200	6.4500	6.6500	155.5550	26066.00	0.00	26066.00	40	40	1706	4753	0.358931201346518	0.528850352009798	0.528850352009798	false	false	false	true
9356eb82-cd20-4aed-b4e3-7435ec010b18	2026-09-16 10:57	2026-09-16 10:57	2026-09-16 10:57	USO	USO261016C00210000	call	210.0000	2026-10-16	1.0100	0.9500	1.0600	157.4366	108270.00	102.00	108168.00	1072	34	1295	581	2.2289156626506	0.661345363553648	0.664321428110245	false	false	false	true
1a3e4341-7299-435e-904d-51f0fc21aa3b	2026-09-16 10:50	2026-09-16 10:50	2026-09-16 10:50	USO	USO261016C00140000	call	140.0000	2026-10-16	20.5500	20.5000	21.2000	157.3993	238355.00	71925.00	166430.00	116	6	133	5770	0.023050259965338	0.52264219490105	0.526716664948263	false	false	false	true
e2922a05-e7cf-426c-be84-25b7dcf5d501	2026-09-16 10:22	2026-09-16 10:22	2026-09-16 10:22	USO	USO270115P00154000	put	154.0000	2027-01-15	15.7500	15.4000	16.0000	158.0000	107090.00	25200.00	78750.00	68	8	69	496	0.139112903225806	0.525714538192452	0.527147970206305	false	false	false	true
aaa466b0-87d1-43b8-9f18-65ed6772e01e	2026-09-16 10:02	2026-09-16 10:02	2026-09-16 10:02	USO	USO290119C00280000	call	280.0000	2029-01-19	14.0900	13.8000	15.6000	158.4299	30993.00	2840.00	28153.00	22	6	78	0	0	0.383057552162389	0.379552879311511	false	false	false	true
57467a45-f691-49ea-a058-266cb76ef87d	2026-09-16 09:59	2026-09-16 09:59	2026-09-16 09:59	USO	USO260930C00168000	call	168.0000	2026-09-30	3.3000	3.3000	4.4500	158.3800	24108.00	0.00	24108.00	73	18	73	8	9.125	0.550669675581607	0.551575753367662	true	false	false	true
60e92b24-8fee-4e8a-af70-f56ce4f66cc1	2026-09-16 09:53	2026-09-16 09:53	2026-09-16 09:53	USO	USO260923P00155000	put	155.0000	2026-09-23	2.8400	2.6800	2.8600	158.4800	31517.00	31233.00	284.00	111	15	264	444	0.594594594594595	0.512798767064354	0.509218101988587	true	false	false	true
903d1306-f2e1-4b35-b2bc-31367157b928	2026-09-16 09:47	2026-09-16 09:47	2026-09-16 09:47	USO	USO260923P00155000	put	155.0000	2026-09-23	2.8100	2.6700	3.0000	158.6401	38763.00	36799.00	1964.00	138	21	153	444	0.344594594594595	0.511306961409033	0.508859158488106	true	false	false	true
d188ee33-92ee-48a8-ba40-30ca6ca9d704	2026-09-16 09:40	2026-09-16 09:40	2026-09-16 09:40	USO	USO260930C00165000	call	165.0000	2026-09-30	4.2500	4.2500	4.5500	158.7590	19566.00	430.00	19136.00	46	9	52	45	1.15555555555556	0.540912379471415	0.545122836594894	true	false	false	true
cf31ed70-bc54-46d3-a438-4016afaf3d25	2026-09-16 09:38	2026-09-16 09:38	2026-09-16 09:38	USO	USO261016P00145000	put	145.0000	2026-10-16	3.8500	3.7500	3.9500	158.7701	38542.00	16212.00	0.00	100	5	110	3751	0.0293255131964809	0.536149777061735	0.536149777061735	false	false	false	true
f5f68acf-5630-471c-abdc-b3c40be2e64a	2026-09-16 09:36	2026-09-16 09:36	2026-09-16 09:36	USO	USO261016C00190000	call	190.0000	2026-10-16	2.6000	2.5600	2.6400	158.9750	26509.00	23140.00	3369.00	102	24	111	1675	0.0662686567164179	0.616020831118607	0.616020831118607	true	false	false	true
1fcc88c6-8fa4-4a28-8fbb-b484a9a9f744	2026-09-16 09:35	2026-09-16 09:35	2026-09-16 09:35	USO	USO260930P00150000	put	150.0000	2026-09-30	3.0000	2.7900	3.0000	158.9400	29065.00	18900.00	4484.00	97	11	513	31	16.5483870967742	0.546237840852099	0.545268401376361	false	false	false	true
b476dbdc-a3f9-4e6e-9f9c-43756a8035c2	2026-09-16 09:32	2026-09-16 09:32	2026-09-16 09:32	USO	USO260918C00165000	call	165.0000	2026-09-18	0.9100	0.8400	1.0100	159.0827	85537.00	91.00	85446.00	940	12	963	6595	0.146019711902957	0.612043698084787	0.620652837925028	true	false	false	true
ac811d08-32e2-4b45-8dda-7ef190e42e4e	2026-09-16 09:30	2026-09-16 09:30	2026-09-16 09:30	USO	USO260916P00158000	put	158.0000	2026-09-16	0.7400	0.7300	0.8900	159.3200	10964.00	1155.00	9809.00	149	32	191	802	0.238154613466334	0.745978753602086	0.745978753602086	true	false	false	true