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

a12d5fab-818f-4c54-98a6-a57e7e8b4b94	2026-08-20 10:32	2026-08-20 10:32	2026-08-20 10:32	OSCR	OSCR260821C00035000	call	35.0000	2026-08-21	0.2000	0.0600	0.2000	33.3050	10000.00	10000.00	0.00	500	43	831	2591	0.320725588575839	1.07517160716557	1.07517160716557	false	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-08-20T14:33:56.503993Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
02c68f06-d70e-4d38-bafb-53363693b48a	2026-08-20 10:24	2026-08-20 10:24	2026-08-20 10:24	OSCR	OSCR270115C00034000	call	34.0000	2027-01-15	6.0000	5.8000	6.1500	33.2700	17400.00	3600.00	13800.00	29	9	42	106	0.39622641509434	0.719811374005648	0.725498753028523	false	false	false	true
1d4e75fa-03d3-4ccd-82c3-31c05abfc7c4	2026-08-20 10:23	2026-08-20 10:23	2026-08-20 10:23	OSCR	OSCR261120C00030000	call	30.0000	2026-11-20	6.6500	6.3000	6.6500	33.2900	41230.00	41230.00	0.00	62	13	93	1559	0.0596536241180244	0.759749473403059	0.740621225791241	true	false	false	true
7e379194-9a70-4b0e-9c42-66b4222fccd2	2026-08-20 10:20	2026-08-20 10:20	2026-08-20 10:20	OSCR	OSCR260918C00035000	call	35.0000	2026-09-18	1.8900	1.8800	1.9000	33.2000	10962.00	10206.00	0.00	58	17	5029	6153	0.817324882171299	0.693881327422083	0.693881327422083	true	false	false	true
6f85e961-fff6-4a92-a451-1b2e1110314c	2026-08-20 10:08	2026-08-20 10:08	2026-08-20 10:08	OSCR	OSCR260918C00035000	call	35.0000	2026-09-18	1.8500	1.8500	1.9000	33.1650	42550.00	0.00	42550.00	230	36	3290	6153	0.534698521046644	0.687163746864647	0.687163746864647	false	false	false	true
3246943a-3a05-4d58-b9f2-77346fa18962	2026-08-20 10:07	2026-08-20 10:07	2026-08-20 10:07	OSCR	OSCR260918C00035000	call	35.0000	2026-09-18	1.9000	1.8900	1.9100	33.1750	12720.00	0.00	11770.00	67	7	2877	6153	0.467576791808874	0.69956148227511	0.696847040472523	false	false	false	true
99ea106e-a000-480a-bb70-7b0c9377a8d3	2026-08-20 10:07	2026-08-20 10:07	2026-08-20 10:07	OSCR	OSCR260918C00035000	call	35.0000	2026-09-18	1.9000	1.8800	1.9100	33.1750	19380.00	19190.00	190.00	102	9	2810	6153	0.456687794571754	0.69956148227511	0.69956148227511	false	false	false	true
d1596bef-ca64-46bc-88a4-59455e95314e	2026-08-20 10:06	2026-08-20 10:06	2026-08-20 10:06	OSCR	OSCR260918C00035000	call	35.0000	2026-09-18	1.9000	1.8950	1.9200	33.2400	13110.00	0.00	13110.00	69	12	2247	6153	0.36518771331058	0.691836628464373	0.691836628464373	false	false	false	true
5df06a46-312b-4013-b11c-80c00ac9a35c	2026-08-20 10:05	2026-08-20 10:05	2026-08-20 10:05	OSCR	OSCR270115P00031000	put	31.0000	2027-01-15	4.5000	4.4500	4.9000	33.1650	15300.00	12150.00	3150.00	34	6	34	212	0.160377358490566	0.715081061665892	0.715081061665892	false	false	false	true
fbac143e-2060-4fbc-96fa-813b15991a6f	2026-08-20 10:03	2026-08-20 10:03	2026-08-20 10:03	OSCR	OSCR260821C00033500	call	33.5000	2026-08-21	0.5000	0.5000	0.5400	33.1525	37500.00	0.00	37500.00	750	5	852	259	3.28957528957529	0.94532810821141	0.94532810821141	false	false	false	true
fce5b8f1-6e1d-4179-b419-b1f32d6047d9	2026-08-20 10:00	2026-08-20 10:00	2026-08-20 10:00	OSCR	OSCR270115C00045000	call	45.0000	2027-01-15	2.7000	2.5700	2.7000	33.1500	41850.00	41850.00	0.00	155	13	155	286	0.541958041958042	0.710588393688141	0.710588393688141	false	false	false	true
084ab080-4ff6-45c6-951c-4b78efbd8e90	2026-08-19 15:51	2026-08-19 15:51	2026-08-19 15:51	OSCR	OSCR261016C00041000	call	41.0000	2026-10-16	1.0000	0.8500	1.0000	32.2600	17598.00	17500.00	98.00	176	23	176	22	8	0.666765197678677	0.666765197678677	true	false	false	true
2761c3b3-0b6d-4746-8ff1-8c93c6609693	2026-08-19 15:31	2026-08-19 15:31	2026-08-19 15:31	OSCR	OSCR261016C00035000	call	35.0000	2026-10-16	2.3800	2.3400	2.3900	32.4200	39270.00	37842.00	1190.00	165	20	180	733	0.245566166439291	0.644805115793677	0.644805115793677	false	false	false	true
e8cb0a55-918e-4272-a245-ad2fa27043b9	2026-08-19 14:00	2026-08-19 14:00	2026-08-19 14:00	OSCR	OSCR260918C00034000	call	34.0000	2026-09-18	1.3700	1.3000	1.3700	31.4700	132479.00	132479.00	0.00	967	24	973	412	2.36165048543689	0.64033340972715	0.64033340972715	false	false	false	true
5071c064-5d4c-4840-a1bb-90147caf8561	2026-08-19 13:36	2026-08-19 13:36	2026-08-19 13:36	OSCR	OSCR261016C00030000	call	30.0000	2026-10-16	4.0100	3.9000	4.0500	31.4350	40150.00	40150.00	0.00	100	6	111	1392	0.0797413793103448	0.654181148741802	0.63937690286427	false	false	false	true
30e05b91-dd8b-4c88-bd9a-1d1351b3d97e	2026-08-18 13:45	2026-08-18 13:44	2026-08-18 13:44	OSCR	OSCR270115P00035000	put	35.0000	2027-01-15	7.2500	7.1500	7.3500	31.8100	16675.00	4350.00	12325.00	23	5	38	209	0.181818181818182	0.695852135598535	0.695852135598535	false	false	false	true
013d6f80-9b58-4d27-88b3-e536d1cf51bb	2026-08-18 12:54	2026-08-18 12:54	2026-08-18 12:54	OSCR	OSCR261120C00037000	call	37.0000	2026-11-20	2.9000	2.7400	2.9000	31.8500	46110.00	46110.00	0.00	159	13	164	1158	0.141623488773748	0.71631188495873	0.715647892820195	false	false	false	true
bc7c8ddc-5cb7-49ba-8e09-38167e443b5b	2026-08-18 12:50	2026-08-18 12:50	2026-08-18 12:50	OSCR	OSCR261016C00032000	call	32.0000	2026-10-16	3.2500	3.1500	3.3000	31.7800	12350.00	10075.00	1950.00	38	7	54	812	0.0665024630541872	0.644645017227029	0.641383659317029	false	false	false	true
1e1089a3-b1c3-4916-a799-42c428cff36e	2026-08-18 12:50	2026-08-18 12:50	2026-08-18 12:50	OSCR	OSCR261016C00033000	call	33.0000	2026-10-16	2.8200	2.7300	2.8600	31.7500	53016.00	52452.00	564.00	188	5	189	165	1.14545454545455	0.642655574726877	0.642655574726877	false	false	false	true
7324bc7e-1922-413f-a107-5ea26db245a9	2026-08-18 12:01	2026-08-18 12:00	2026-08-18 12:00	OSCR	OSCR260918P00030000	put	30.0000	2026-09-18	1.5000	1.3000	1.5400	31.7400	27450.00	27450.00	0.00	183	6	635	860	0.738372093023256	0.649798350758174	0.643797468643749	true	false	false	true
d67dcce7-0492-4800-862e-3faea545bc03	2026-08-18 11:52	2026-08-18 11:52	2026-08-18 11:52	OSCR	OSCR270115P00022000	put	22.0000	2027-01-15	1.3900	1.3400	1.3900	31.8200	20016.00	20016.00	0.00	144	11	296	999	0.296296296296296	0.729184309095385	0.729184309095385	false	false	false	true
09f79a2e-cbae-49f6-9fa7-437ca23c76af	2026-08-18 11:21	2026-08-18 11:21	2026-08-18 11:21	OSCR	OSCR270617C00030000	call	30.0000	2027-06-17	9.2000	9.2000	9.4500	31.7100	138002.00	0.00	138002.00	150	6	152	125	1.216	0.718062582841384	0.718062582841384	false	false	false	true
deffdf38-2f6d-4a2d-a26b-876b01dbee35	2026-08-18 10:22	2026-08-18 10:22	2026-08-18 10:22	OSCR	OSCR260918C00033000	call	33.0000	2026-09-18	2.0900	2.0500	2.0900	32.1150	10659.00	10659.00	0.00	51	5	62	974	0.0636550308008214	0.651833279593607	0.651833279593607	false	false	false	true
e1304155-ecdd-4cae-8e3c-122abe58b861	2026-08-18 09:45	2026-08-18 09:45	2026-08-18 09:45	OSCR	OSCR261120C00031000	call	31.0000	2026-11-20	5.2500	5.1000	5.4500	32.0000	84525.00	75075.00	9450.00	161	10	161	79	2.0379746835443	0.717621879483077	0.713628413648435	true	false	false	true
098f3eb3-90cb-48a9-b36c-ad5459d53e21	2026-08-17 10:33	2026-08-17 10:32	2026-08-17 10:32	OSCR	OSCR280121C00030000	call	30.0000	2028-01-21	11.8000	11.7500	12.0000	31.7500	10620.00	2360.00	1180.00	9	6	32	6791	0.00471211898100427	0.717945218040128	0.717945218040128	false	false	false	true
a1753090-cc63-4e6b-bd8f-35cc4a245065	2026-08-17 09:33	2026-08-17 09:33	2026-08-17 09:33	OSCR	OSCR261120P00031000	put	31.0000	2026-11-20	4.0000	3.6500	4.0000	31.6100	10000.00	10000.00	0.00	25	5	25	252	0.0992063492063492	0.705050425570129	0.705050425570129	false	false	false	true