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.

375,978 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts375,978 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 = OSCR×

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

0308791c-7960-4add-86e0-c91b827c997b	2026-09-09 15:01	2026-09-09 15:01	2026-09-09 15:01	OSCR	OSCR260918P00030500	put	30.5000	2026-09-18	1.1000	1.1000	1.1300	31.3800	10120.00	0.00	10120.00	92	6	401	117	3.42735042735043	0.780506832192379	0.780506832192379	true	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Healthcare	9245986890.00	2026-11-05	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-09T19:27:55.926703Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
37ce5a6f-5aea-4396-b846-d48d464498be	2026-09-09 13:30	2026-09-09 13:30	2026-09-09 13:30	OSCR	OSCR270115P00030000	put	30.0000	2027-01-15	4.1500	4.1000	4.2000	31.4250	13280.00	0.00	10375.00	32	7	89	1102	0.0807622504537205	0.698456530236775	0.698456530236775	false	false	false	true
eb543143-dc42-4541-890c-021d8c3a4278	2026-09-09 09:37	2026-09-09 09:37	2026-09-09 09:37	OSCR	OSCR261016C00032000	call	32.0000	2026-10-16	3.0000	3.0000	3.1000	32.3010	72600.00	0.00	72600.00	242	24	341	1751	0.194745859508852	0.68369816476866	0.68369816476866	false	false	false	true
d4537daf-dcc4-4621-937c-25668d9dead1	2026-09-08 14:56	2026-09-08 14:56	2026-09-08 14:56	OSCR	OSCR261016C00033000	call	33.0000	2026-10-16	2.9000	2.7700	2.9000	32.9300	24650.00	24650.00	0.00	85	7	500	710	0.704225352112676	0.678615412483879	0.678615412483879	false	false	false	true
b34c28ae-b8cf-442e-8af1-2055905ac69c	2026-09-08 14:21	2026-09-08 14:21	2026-09-08 14:21	OSCR	OSCR261016C00032000	call	32.0000	2026-10-16	3.2500	3.2500	3.4000	32.7250	31850.00	0.00	31850.00	98	9	780	985	0.791878172588833	0.674611237512042	0.674611237512042	false	false	false	true
d74973a0-3842-4aa7-836c-19f307fdb856	2026-09-08 13:17	2026-09-08 13:17	2026-09-08 13:17	OSCR	OSCR261023P00037000	put	37.0000	2026-10-23	5.4000	5.2500	5.4000	33.2100	89640.00	89640.00	0.00	166	16	172	0	0	0.671324868923995	0.671324868923995	false	false	false	true
87b79907-efa0-44f9-8cef-2f5e0e31f0f7	2026-09-04 15:30	2026-09-04 15:30	2026-09-04 15:30	OSCR	OSCR270115C00032000	call	32.0000	2027-01-15	5.7500	5.7500	5.9500	32.3600	12650.00	0.00	12650.00	22	8	24	660	0.0363636363636364	0.698053966215836	0.698053966215836	false	false	false	true
e5d2cfc4-b0d8-49f5-a2fe-5cf632d16e9d	2026-09-04 12:32	2026-09-04 12:32	2026-09-04 12:32	OSCR	OSCR261120P00031000	put	31.0000	2026-11-20	3.6000	3.5500	3.6500	31.6450	11880.00	0.00	11160.00	33	13	44	313	0.140575079872204	0.707591851246899	0.707591851246899	false	false	false	true
b7adaa80-b30c-4305-8ea4-111eeff1dae5	2026-09-03 10:50	2026-09-03 10:49	2026-09-03 10:49	OSCR	OSCR261120C00034000	call	34.0000	2026-11-20	3.3000	3.2500	3.4500	31.5100	14520.00	0.00	11220.00	44	11	84	399	0.210526315789474	0.720802037157838	0.720802037157838	false	false	false	true
f8679a67-b427-44d4-82fc-18881512cc42	2026-09-02 15:19	2026-09-02 15:18	2026-09-02 15:18	OSCR	OSCR260918C00034000	call	34.0000	2026-09-18	0.6200	0.6000	0.6700	30.5300	10726.00	0.00	10726.00	173	10	8994	16527	0.544200399346524	0.686132503226316	0.686751392193048	true	false	false	true
a4821a5c-7905-4b42-8c3c-1a256125e4ad	2026-09-02 15:15	2026-09-02 15:15	2026-09-02 15:15	OSCR	OSCR260918C00034000	call	34.0000	2026-09-18	0.6400	0.6200	0.6600	30.5700	39808.00	2560.00	37248.00	622	11	8796	16527	0.532220003630423	0.691512468067019	0.691512468067019	false	false	false	true
32fb93a8-8d15-407d-a6fa-73bc78031901	2026-09-02 15:15	2026-09-02 15:15	2026-09-02 15:15	OSCR	OSCR260918C00034000	call	34.0000	2026-09-18	0.6600	0.6500	0.6700	30.6550	13200.00	1320.00	11880.00	200	9	8167	16527	0.494161069764628	0.690478203643731	0.690478203643731	false	false	false	true
ebb719aa-2953-4e5b-85b3-bd32498c4730	2026-09-02 10:39	2026-09-02 10:39	2026-09-02 10:39	OSCR	OSCR260904C00030000	call	30.0000	2026-09-04	0.7400	0.6200	0.8600	30.0700	17908.00	16428.00	1480.00	242	7	254	293	0.866894197952218	0.790729688843597	0.790729688843597	false	false	false	true
efef7145-821f-473f-bcd5-c8451153f522	2026-09-02 10:30	2026-09-02 10:30	2026-09-02 10:30	OSCR	OSCR260918C00034000	call	34.0000	2026-09-18	0.5400	0.5200	0.5400	29.9750	83268.00	83268.00	0.00	1542	11	4610	16527	0.278937496218309	0.71342217117257	0.71342217117257	true	false	false	true
bdd26017-af2a-4491-a395-05bfdfec6119	2026-09-01 15:45	2026-09-01 15:45	2026-09-01 15:45	OSCR	OSCR260918C00034000	call	34.0000	2026-09-18	0.5500	0.5400	0.5700	29.7350	11000.00	7315.00	3685.00	200	10	13987	1660	8.42590361445783	0.724820646953377	0.724820646953377	false	false	false	true
66c1af12-4999-451b-a35c-d944871875fb	2026-09-01 15:43	2026-09-01 15:43	2026-09-01 15:43	OSCR	OSCR260918C00034000	call	34.0000	2026-09-18	0.5500	0.5500	0.5600	29.7200	30855.00	0.00	30855.00	561	7	13354	1660	8.04457831325301	0.726562339564564	0.726562339564564	false	false	false	true
405a80ec-6bb9-4ac4-91d3-956cd2a30992	2026-09-01 15:43	2026-09-01 15:42	2026-09-01 15:42	OSCR	OSCR260918C00030500	call	30.5000	2026-09-18	1.4800	1.2600	1.5200	29.7000	31672.00	2960.00	28712.00	214	5	255	3	85	0.706953749879465	0.706953749879465	true	false	false	true
7507f8dc-a319-447f-859e-e3cb5e6396ce	2026-08-31 10:29	2026-08-31 10:29	2026-08-31 10:29	OSCR	OSCR280121C00040000	call	40.0000	2028-01-21	7.1000	7.1000	7.7000	29.8650	22010.00	0.00	22010.00	31	5	51	51680	0.000986842105263158	0.684473919467933	0.684473919467933	false	false	false	true
ed9c8023-240b-4069-92f6-16aab34f230d	2026-08-28 14:24	2026-08-28 14:24	2026-08-28 14:24	OSCR	OSCR260918C00032000	call	32.0000	2026-09-18	1.6800	1.6300	1.7300	31.3150	23352.00	23184.00	0.00	139	21	316	1320	0.239393939393939	0.656464382302526	0.652446210829587	false	false	false	true
80cb63d4-b23a-42d3-9879-fa6d41658007	2026-08-28 12:11	2026-08-28 12:10	2026-08-28 12:10	OSCR	OSCR261016P00033000	put	33.0000	2026-10-16	3.9500	3.6000	4.1000	31.0700	27650.00	16985.00	10665.00	70	9	70	1420	0.0492957746478873	0.634478025338838	0.641182091513774	false	false	false	true
889dbf7a-b236-42ad-b4e3-43b50dee52e7	2026-08-28 10:11	2026-08-28 10:11	2026-08-28 10:11	OSCR	OSCR270115P00035000	put	35.0000	2027-01-15	7.7500	7.5500	7.7500	30.4600	10850.00	10850.00	0.00	14	7	25	229	0.109170305676856	0.693201185240042	0.693201185240042	false	false	false	true
b3d1e25c-87f6-460b-8c98-334d89a2996b	2026-08-27 14:01	2026-08-27 14:01	2026-08-27 14:01	OSCR	OSCR260925C00026000	call	26.0000	2026-09-25	4.9500	4.9500	6.2500	30.2400	29700.00	0.00	29700.00	60	6	60	2	30	0.676920028291998	0.676920028291998	false	false	false	true
4d4c78e0-93d1-4c2c-8a31-3ce9130844fd	2026-08-26 09:41	2026-08-26 09:41	2026-08-26 09:41	OSCR	OSCR260918C00035000	call	35.0000	2026-09-18	1.0000	0.9200	1.0400	31.4710	19000.00	19000.00	0.00	190	7	779	8459	0.0920912637427592	0.70198442683942	0.70198442683942	false	false	false	true
82f27540-1b09-4803-9017-b8c4247e0e7b	2026-08-25 15:41	2026-08-25 15:40	2026-08-25 15:40	OSCR	OSCR270115C00034000	call	34.0000	2027-01-15	4.3500	4.3500	4.5500	30.8900	25665.00	0.00	25665.00	59	5	130	133	0.977443609022556	0.696147443342098	0.696147443342098	false	false	false	true
90281d2d-58b1-48b2-a9e7-99c99688ad46	2026-08-25 14:08	2026-08-25 14:08	2026-08-25 14:08	OSCR	OSCR260911C00033000	call	33.0000	2026-09-11	0.8000	0.7000	0.9300	30.0000	30960.00	27760.00	2400.00	387	7	497	562	0.884341637010676	0.643069088369508	0.648447035186536	false	false	false	true
aa5d8a3a-0083-4212-91b0-f16158b1e09a	2026-08-25 10:26	2026-08-25 10:25	2026-08-25 10:25	OSCR	OSCR261120P00032000	put	32.0000	2026-11-20	4.6000	4.6000	4.7000	31.2100	15640.00	0.00	15640.00	34	6	39	420	0.0928571428571429	0.713136564572785	0.713136564572785	false	false	false	true
1dffe9ec-a278-4b9e-9c2a-89271481e92a	2026-08-24 14:57	2026-08-24 14:56	2026-08-24 14:56	OSCR	OSCR261016C00035000	call	35.0000	2026-10-16	2.0400	2.0000	2.0800	31.7500	11012.00	10608.00	404.00	54	8	290	1059	0.273843248347498	0.664220524220014	0.659957558990817	false	false	false	true
3c0ffaf4-6f66-419d-82a7-691169aa35b1	2026-08-24 14:49	2026-08-24 14:49	2026-08-24 14:49	OSCR	OSCR261016P00030000	put	30.0000	2026-10-16	2.1400	2.1300	2.3700	31.7700	10058.00	214.00	9844.00	47	5	65	190	0.342105263157895	0.644429655400266	0.644429655400266	false	false	false	true
fe5cd29a-8c73-4ea6-b6a6-4e6cf85dac8c	2026-08-24 13:29	2026-08-24 13:28	2026-08-24 13:28	OSCR	OSCR261120P00033000	put	33.0000	2026-11-20	4.8500	4.7000	4.8500	32.2600	74690.00	74690.00	0.00	154	18	167	308	0.542207792207792	0.731787360659271	0.731787360659271	false	false	false	true
3a3b38af-d838-4ec8-82cc-ca0db43bb7e8	2026-08-24 13:19	2026-08-24 13:19	2026-08-24 13:19	OSCR	OSCR261120P00028000	put	28.0000	2026-11-20	2.3100	2.3100	2.4000	32.4400	11781.00	0.00	11781.00	51	21	160	1830	0.087431693989071	0.726963662390783	0.726963662390783	false	false	false	true
c054576c-dfa5-45e1-bee5-d6f95e4de71a	2026-08-24 11:02	2026-08-24 11:02	2026-08-24 11:02	OSCR	OSCR260918C00035000	call	35.0000	2026-09-18	1.5400	1.5000	1.5500	32.9500	14014.00	13860.00	154.00	91	11	1126	8069	0.13954641219482	0.678404248303423	0.676583488579761	false	false	false	true
8ee086d1-8a3f-479c-8771-63107bd269ad	2026-08-24 10:30	2026-08-24 10:30	2026-08-24 10:30	OSCR	OSCR261016C00032000	call	32.0000	2026-10-16	3.8000	3.6500	3.9000	32.8800	23180.00	380.00	21280.00	61	7	66	788	0.083756345177665	0.659669628158536	0.661533695411999	false	false	false	true
a9e87f60-2a10-49dd-a774-ef5adf4efd81	2026-08-24 09:36	2026-08-24 09:36	2026-08-24 09:36	OSCR	OSCR261016C00040000	call	40.0000	2026-10-16	1.4000	1.2200	1.4000	33.3500	188720.00	188720.00	0.00	1348	44	1350	958	1.40918580375783	0.682912254994419	0.682912254994419	false	false	false	true
146206ab-2a6e-4b6d-80a9-967579986e35	2026-08-21 15:48	2026-08-21 15:48	2026-08-21 15:48	OSCR	OSCR261120P00033000	put	33.0000	2026-11-20	5.0500	4.9500	5.1000	31.6427	12120.00	5555.00	6060.00	24	5	24	299	0.0802675585284281	0.707857265317898	0.707857265317898	false	false	false	true
0b1aa981-9bbf-4962-a6fa-3b142acbb18b	2026-08-21 13:58	2026-08-21 13:57	2026-08-21 13:57	OSCR	OSCR261120C00033000	call	33.0000	2026-11-20	3.8500	3.7500	3.9000	31.2906	31570.00	2310.00	29260.00	82	14	83	343	0.24198250728863	0.708634801898056	0.711940731792621	false	false	false	true
be18e459-6eba-487d-982e-41c990217ee4	2026-08-21 13:41	2026-08-21 13:41	2026-08-21 13:41	OSCR	OSCR260821C00030000	call	30.0000	2026-08-21	1.2000	1.1900	1.6000	31.2250	18000.00	9000.00	5040.00	150	18	194	2751	0.0705198109778262	0.831006709277504	0.831006709277504	false	false	false	true
df5099b9-61ae-4ea6-a809-74a5add4f162	2026-08-21 10:33	2026-08-21 10:33	2026-08-21 10:33	OSCR	OSCR261016C00035000	call	35.0000	2026-10-16	1.7600	1.7300	1.8100	30.9350	10032.00	0.00	10032.00	57	10	134	1043	0.128475551294343	0.652053418457551	0.653266591312291	true	false	false	true
cf424753-5ee1-4ebd-974b-7e1dd00b6697	2026-08-20 15:21	2026-08-20 15:20	2026-08-20 15:20	OSCR	OSCR260918P00034000	put	34.0000	2026-09-18	3.8000	3.7500	3.8000	31.5000	12540.00	12540.00	0.00	33	6	131	105	1.24761904761905	0.657645003330848	0.657645003330848	false	false	false	true
fbf3ed36-a120-4c2b-9965-3073351f4b6c	2026-08-20 15:20	2026-08-20 15:20	2026-08-20 15:20	OSCR	OSCR260918P00034000	put	34.0000	2026-09-18	3.8000	3.6000	3.8000	31.5200	18620.00	18620.00	0.00	49	6	52	105	0.495238095238095	0.661293613808095	0.661293613808095	false	false	false	true
d68494a8-351e-4c59-b685-427a85548d02	2026-08-20 14:40	2026-08-20 14:39	2026-08-20 14:39	OSCR	OSCR260918C00035000	call	35.0000	2026-09-18	1.6000	1.5500	1.6600	32.6350	22560.00	0.00	22560.00	141	8	17871	6153	2.90443686006826	0.679152202617464	0.679152202617464	false	false	false	true
c42a94fe-b008-47fd-8030-13a6075161a7	2026-08-20 11:45	2026-08-20 11:45	2026-08-20 11:45	OSCR	OSCR260918C00035000	call	35.0000	2026-09-18	1.7000	1.6800	1.7300	32.7100	51000.00	0.00	51000.00	300	21	12666	6153	2.05850804485617	0.698677790564027	0.698677790564027	false	false	false	true
e3022146-15b1-4810-9304-4117c0a3995d	2026-08-20 11:40	2026-08-20 11:40	2026-08-20 11:40	OSCR	OSCR260918C00035000	call	35.0000	2026-09-18	1.7500	1.7300	1.7700	32.8000	18023.00	350.00	17673.00	103	13	12072	6153	1.96196977084349	0.702267697321188	0.699493290094211	false	false	false	true
430fd99a-dfff-463f-8f83-9ef06aaa9103	2026-08-20 11:13	2026-08-20 11:13	2026-08-20 11:13	OSCR	OSCR280121C00035000	call	35.0000	2028-01-21	10.6000	10.6000	11.0000	32.7300	115545.00	1065.00	114480.00	109	6	265	7558	0.0350621857634295	0.706419086014932	0.709916778733951	false	false	false	true
3656029b-6e45-4d39-af6b-b9c87ab03341	2026-08-20 11:11	2026-08-20 11:11	2026-08-20 11:11	OSCR	OSCR260918C00031000	call	31.0000	2026-09-18	3.4000	3.4000	3.5500	32.6100	53380.00	0.00	53380.00	157	18	219	449	0.487750556792873	0.688747823305498	0.688747823305498	false	false	false	true
f5c079f7-9bb5-4070-8c19-7027fc6419f4	2026-08-20 11:11	2026-08-20 11:11	2026-08-20 11:11	OSCR	OSCR261002C00034000	call	34.0000	2026-10-02	2.5600	1.9800	3.1500	32.7200	87039.00	10496.00	76543.00	340	8	340	0	0	0.679859642028583	0.679859642028583	false	false	false	true
3f7be546-09cd-44d4-922e-9fdb2e1ef5c4	2026-08-20 11:11	2026-08-20 11:11	2026-08-20 11:11	OSCR	OSCR261016C00035000	call	35.0000	2026-10-16	2.6200	2.6200	2.7600	32.6600	14410.00	0.00	14410.00	55	10	97	832	0.116586538461538	0.67662524845064	0.67662524845064	true	false	false	true
cdf2e48d-3e7d-4992-a26f-5f1d48237f5f	2026-08-20 10:50	2026-08-20 10:50	2026-08-20 10:50	OSCR	OSCR260821C00033500	call	33.5000	2026-08-21	0.5000	0.3500	0.5300	33.1400	26400.00	26400.00	0.00	528	10	2388	259	9.22007722007722	0.953155679710755	0.953155679710755	false	false	false	true
ec5ebd5e-172a-4ee1-99ba-c9e8cd3851eb	2026-08-20 10:37	2026-08-20 10:37	2026-08-20 10:37	OSCR	OSCR260828C00037000	call	37.0000	2026-08-28	0.3500	0.3500	0.3800	33.1500	21875.00	0.00	21875.00	625	12	1208	207	5.83574879227053	0.761906325596759	0.761906325596759	false	false	false	true
9427d00e-8b25-4730-841d-1b31a7a35f0f	2026-08-20 10:33	2026-08-20 10:33	2026-08-20 10:33	OSCR	OSCR260918C00035000	call	35.0000	2026-09-18	2.0000	1.9900	2.1000	33.3100	10000.00	1200.00	8800.00	50	6	5733	6153	0.931740614334471	0.702605728331484	0.710449158411096	false	false	false	true
c09188ef-b481-4c5b-852c-0376025594a0	2026-08-20 10:33	2026-08-20 10:33	2026-08-20 10:33	OSCR	OSCR260918C00035000	call	35.0000	2026-09-18	2.0000	1.9900	2.0000	33.3550	18800.00	18800.00	0.00	94	11	5632	6153	0.91532585730538	0.705021334615051	0.705021334615051	true	false	false	true