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.

326,449 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts326,449 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active: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	price

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	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:05:52.049536Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
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	false
ca9d69f3-0969-46e8-a5b9-9d6731347bee	2026-08-20 10:01	2026-08-20 10:01	2026-08-20 10:01	OSCR	OSCR260918C00035000	call	35.0000	2026-09-18	1.8600	1.8000	1.9500	33.3200	49244.00	37367.00	9137.00	265	51	655	6153	0.106452137168861	0.679134376761997	0.682301101381948	false	false	false	true	false
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	false
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	false
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	false
69f7fdfa-781d-40bb-beaf-2a552410b14d	2026-08-19 15:00	2026-08-19 15:00	2026-08-19 15:00	OSCR	OSCR270521C00030000	call	30.0000	2027-05-21	8.9200	8.6000	9.0000	31.8200	89164.00	89164.00	0.00	100	9	102	60	1.7	0.71886125975416	0.71886125975416	false	false	false	true	false
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	false
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	false
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	false
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	false
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	false
3e6195b9-6fa8-4ca8-a786-4434d128a69f	2026-08-18 12:50	2026-08-18 12:50	2026-08-18 12:50	OSCR	OSCR261016C00031000	call	31.0000	2026-10-16	3.7500	3.6000	3.7500	31.7500	14235.00	13495.00	740.00	38	20	38	528	0.071969696969697	0.641165803435368	0.651284951860672	true	false	false	true	false
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	false
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	false
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	false
b6626993-8a2a-494e-b748-84db11afd811	2026-08-18 11:41	2026-08-18 11:41	2026-08-18 11:41	OSCR	OSCR280121C00035000	call	35.0000	2028-01-21	10.1000	9.9000	10.3000	31.8222	726190.00	0.00	0.00	719	2	721	7809	0.0923293635548726	0.711521676622663	0.711521676622663	false	true	true	false	false
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	false
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	false
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	false
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	false
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	false
5e5bc7ec-be3e-45b3-94ce-969b55891fd7	2026-08-14 15:55	2026-08-14 15:55	2026-08-14 15:55	OSCR	OSCR260814C00030500	call	30.5000	2026-08-14	2.2800	2.1500	2.5900	32.7500	15986.00	0.00	15986.00	70	5	231	482	0.479253112033195	14.8264054142155	14.8264054142155	false	false	false	true	false