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.

425,429 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts425,429 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:option_symbol = XOP261016P00190000×sorted by created_at ↑×

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

18df4a9c-07c1-42f6-af18-d1a0eb0d5a11	2026-08-19 10:50	2026-08-19 10:50	2026-08-19 10:50	XOP	XOP261016P00190000	put	190.0000	2026-10-16	10.9500	10.9500	11.5000	187.1699	49275.00	0.00	49275.00	45	12	45	15	3	0.337644679686563	0.337644679686563	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	4170340047.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-19T15:01:13.058297Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
ef5dfb42-9bae-47bd-a1e5-b53d63a51faf	2026-08-20 15:20	2026-08-20 15:20	2026-08-20 15:20	XOP	XOP261016P00190000	put	190.0000	2026-10-16	11.1500	11.0500	11.1500	187.0900	15610.00	15610.00	0.00	14	11	25	86	0.290697674418605	0.345592046712974	0.345592046712974	false	false	false	true
786fd77d-c33a-420b-8120-95ef7892af4c	2026-09-10 14:31	2026-09-10 14:31	2026-09-10 14:31	XOP	XOP261016P00190000	put	190.0000	2026-10-16	5.4000	5.1500	5.4000	196.4650	13500.00	13500.00	0.00	25	6	212	132	1.60606060606061	0.352828315704932	0.352828315704932	false	false	false	true
49337207-5441-43ca-9284-cb751176ac08	2026-09-10 14:32	2026-09-10 14:31	2026-09-10 14:31	XOP	XOP261016P00190000	put	190.0000	2026-10-16	5.4000	5.1500	5.4000	196.4650	13500.00	13500.00	0.00	25	10	237	132	1.79545454545455	0.352828315704932	0.352828315704932	false	false	false	true
a4a0f7b3-3c82-4be2-85b1-60916323d0b7	2026-09-10 14:32	2026-09-10 14:32	2026-09-10 14:32	XOP	XOP261016P00190000	put	190.0000	2026-10-16	5.4000	5.1500	5.4500	196.4950	11880.00	2700.00	1620.00	22	10	281	132	2.12878787878788	0.353285400437013	0.353285400437013	false	false	false	true
d64253f6-904d-4004-93bb-8194094e8b89	2026-09-10 14:33	2026-09-10 14:33	2026-09-10 14:33	XOP	XOP261016P00190000	put	190.0000	2026-10-16	5.4000	5.4000	5.5000	196.4600	54540.00	0.00	54540.00	101	6	425	132	3.21969696969697	0.352752097938454	0.352752097938454	false	false	false	true
05108d42-273d-4f9a-8ffa-6524bda5bb75	2026-09-10 14:37	2026-09-10 14:37	2026-09-10 14:37	XOP	XOP261016P00190000	put	190.0000	2026-10-16	5.4000	5.4000	5.4500	196.4550	54000.00	0.00	54000.00	100	5	813	132	6.15909090909091	0.352675869592309	0.352675869592309	false	false	false	true
8ab9d5f3-0d85-4b96-a78e-e74f35f3a8f0	2026-09-10 15:00	2026-09-10 14:59	2026-09-10 14:59	XOP	XOP261016P00190000	put	190.0000	2026-10-16	5.4000	5.4000	5.4500	196.5750	99900.00	0.00	99900.00	185	7	1221	132	9.25	0.354502440937502	0.354502440937502	false	false	false	true	false
c161cf34-ada4-4cfc-a721-0229f8876fa5	2026-09-10 15:00	2026-09-10 15:00	2026-09-10 15:00	XOP	XOP261016P00190000	put	190.0000	2026-10-16	5.4000	5.4000	5.4500	196.5750	75600.00	0.00	75600.00	140	5	1384	132	10.4848484848485	0.354502440937502	0.354502440937502	false	false	false	true
a706a5e4-43d0-4a8a-8968-6b0941b2c34c	2026-09-10 15:00	2026-09-10 15:00	2026-09-10 15:00	XOP	XOP261016P00190000	put	190.0000	2026-10-16	5.4000	5.4000	5.4500	196.5750	67500.00	0.00	67500.00	125	5	1509	132	11.4318181818182	0.354502440937502	0.354502440937502	false	false	false	true
7f07c645-6562-4422-b9a9-68abeff5e906	2026-09-10 15:01	2026-09-10 15:01	2026-09-10 15:01	XOP	XOP261016P00190000	put	190.0000	2026-10-16	5.4000	5.4000	5.4500	196.8700	102600.00	0.00	102600.00	190	11	1852	132	14.030303030303	0.358364000398094	0.358967313290698	false	false	false	true
f6e76c76-fef8-4ce4-8278-b1d68684c126	2026-09-10 15:04	2026-09-10 15:03	2026-09-10 15:03	XOP	XOP261016P00190000	put	190.0000	2026-10-16	5.4000	5.4000	5.4500	196.8500	55080.00	0.00	55080.00	102	7	2606	132	19.7424242424242	0.358665738187727	0.358665738187727	false	false	false	true
6127aef9-2900-40d0-9d92-5e94fce7b3b3	2026-09-14 10:28	2026-09-14 10:27	2026-09-14 10:27	XOP	XOP261016P00190000	put	190.0000	2026-10-16	4.5000	3.9500	4.5000	198.4100	404985.00	404985.00	0.00	900	64	903	3528	0.255952380952381	0.360895848057873	0.360895848057873	true	false	false	true
c67c83a9-5ff8-4c8f-8da1-9ac2117d03d8	2026-09-15 11:13	2026-09-15 11:12	2026-09-15 11:12	XOP	XOP261016P00190000	put	190.0000	2026-10-16	4.7000	4.6500	5.1000	197.7800	292810.00	291870.00	470.00	623	6	1410	4266	0.330520393811533	0.366356081071799	0.366356081071799	false	false	false	true
846a6058-faa9-4b5c-bcec-4819628c86fb	2026-09-17 12:08	2026-09-17 12:08	2026-09-17 12:08	XOP	XOP261016P00190000	put	190.0000	2026-10-16	6.6000	6.6000	6.8000	191.4600	31020.00	0.00	31020.00	47	17	74	5150	0.014368932038835	0.354312166428295	0.354312166428295	false	false	false	true
2a7e8090-aa97-41d0-a719-3b380f2ed9b3	2026-09-17 14:55	2026-09-17 14:55	2026-09-17 14:55	XOP	XOP261016P00190000	put	190.0000	2026-10-16	6.2000	6.0500	6.2000	192.5950	309997.00	309997.00	0.00	500	51	817	5150	0.158640776699029	0.358236257746621	0.358236257746621	false	false	false	true
55effd1a-36b5-40e3-b56c-8ef963ad52ab	2026-09-18 10:48	2026-09-18 10:48	2026-09-18 10:48	XOP	XOP261016P00190000	put	190.0000	2026-10-16	5.7000	5.5500	5.8500	193.0994	11408.00	7423.00	1705.00	20	7	29	5747	0.00504611101444232	0.349032048323938	0.349032048323938	false	false	false	true