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:sector = Consumer Cyclical×ticker = ROL×

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

fd79e2a5-7a14-4997-9272-116e86c9c83f	2026-09-22 14:36	2026-09-22 14:36	2026-09-22 14:36	ROL	ROL261120C00032500	call	32.5000	2026-11-20	1.8600	1.8500	1.9500	32.6950	13361.00	0.00	13361.00	72	12	272	253	1.07509881422925	0.31434332145899	0.31434332145899	false	false	false	true	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	Common Stock	Consumer Cyclical	15810437975.00	2026-11-04	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-22T18:44:24.241276Z"}	2026-09-22	2026-09-22 21:15	2026-09-22 21:15
ee413e15-bdf1-4ec8-9ba8-b887855e7a18	2026-09-22 14:36	2026-09-22 14:36	2026-09-22 14:36	ROL	ROL261120C00032500	call	32.5000	2026-11-20	1.8500	1.8500	1.9500	32.6950	42183.00	0.00	42183.00	228	7	500	253	1.97628458498024	0.316275681172795	0.31434332145899	false	false	false	true
2a16db2c-7538-4595-a447-84a68cf0ada9	2026-09-22 13:59	2026-09-22 13:59	2026-09-22 13:59	ROL	ROL261016P00035000	put	35.0000	2026-10-16	2.3000	2.2500	2.5500	32.8350	23000.00	0.00	23000.00	100	5	107	1038	0.103082851637765	0.263093899301478	0.263093899301478	false	false	false	true
f99ef88c-ea21-4f08-985f-435fb713b45b	2026-09-22 11:07	2026-09-22 11:07	2026-09-22 11:07	ROL	ROL261016P00032500	put	32.5000	2026-10-16	0.7500	0.7500	0.8500	32.0000	13125.00	0.00	13125.00	175	5	183	405	0.451851851851852	0.280028345965053	0.280028345965053	false	false	false	true
42dd7791-a165-4829-b2f4-5fd9a1b77f84	2026-09-16 10:50	2026-09-16 10:50	2026-09-16 10:50	ROL	ROL261016C00035000	call	35.0000	2026-10-16	0.8500	0.7500	0.9000	34.3800	10710.00	10710.00	0.00	126	5	265	102	2.59803921568627	0.27392283061401	0.27392283061401	false	false	false	true
4d5070e7-cb10-4ed5-9b47-42bc7bb337e7	2026-09-11 12:04	2026-09-11 12:04	2026-09-11 12:04	ROL	ROL261120P00037500	put	37.5000	2026-11-20	3.4700	3.4000	3.5000	34.8100	17356.00	17356.00	0.00	50	5	259	215	1.2046511627907	0.327664392565544	0.327664392565544	false	false	false	true
472e8da0-8fa2-47ff-b02b-c55f4c8c23ae	2026-09-09 10:44	2026-09-09 10:44	2026-09-09 10:44	ROL	ROL261120P00035000	put	35.0000	2026-11-20	2.2100	2.2000	2.4000	34.5700	24476.00	2250.00	22226.00	111	13	126	266	0.473684210526316	0.345573367157317	0.345573367157317	true	false	false	true
c8a98bde-0887-4ad5-a098-ebae60498cf6	2026-09-03 11:12	2026-09-03 11:12	2026-09-03 11:12	ROL	ROL260918P00037500	put	37.5000	2026-09-18	1.7500	1.7000	1.8500	35.8795	26775.00	0.00	26775.00	153	52	1943	3715	0.523014804845222	0.240317899679866	0.240317899679866	true	false	false	true
730ff261-4d24-411e-b60a-9e43d9dac790	2026-09-03 11:12	2026-09-03 11:12	2026-09-03 11:12	ROL	ROL260918P00037500	put	37.5000	2026-09-18	1.7500	1.7500	1.8500	35.8795	26950.00	0.00	26950.00	154	57	1790	3715	0.481830417227456	0.240317899679866	0.240317899679866	false	false	false	true
ebdb4fe3-0d1e-47df-8d9d-0564eb409d74	2026-09-03 11:12	2026-09-03 11:12	2026-09-03 11:12	ROL	ROL260918P00037500	put	37.5000	2026-09-18	1.8000	1.8000	1.9500	35.8250	10800.00	0.00	10800.00	60	30	1636	3715	0.440376850605653	0.243372502089026	0.243372502089026	false	false	false	true
734ca1e2-50ec-4918-9575-dfa7eeb2f81b	2026-09-03 10:45	2026-09-03 10:45	2026-09-03 10:45	ROL	ROL260918P00037500	put	37.5000	2026-09-18	2.0000	2.0000	2.1000	35.5950	11000.00	0.00	11000.00	55	5	231	3715	0.0621803499327052	0.249175449542526	0.249175449542526	false	false	false	true
c4cf2fb4-92bb-4b74-821a-3367bf0690d3	2026-09-03 10:45	2026-09-03 10:45	2026-09-03 10:45	ROL	ROL260918P00037500	put	37.5000	2026-09-18	2.0000	2.0000	2.1000	35.5950	11000.00	0.00	11000.00	55	7	176	3715	0.0473755047106326	0.249175449542526	0.249175449542526	false	false	false	true
93c1c27b-4768-4e92-8452-62ffd89badeb	2026-09-03 10:45	2026-09-03 10:45	2026-09-03 10:45	ROL	ROL260918P00037500	put	37.5000	2026-09-18	2.0000	1.9500	2.2000	35.5650	11000.00	3400.00	1200.00	55	10	66	3715	0.0177658142664872	0.2344038463355	0.2344038463355	false	false	false	true
34219b24-cb45-48f7-bf17-0caf106de9b5	2026-08-31 11:26	2026-08-31 11:26	2026-08-31 11:26	ROL	ROL270219P00035000	put	35.0000	2027-02-19	2.3500	2.2500	2.5000	36.4800	37835.00	35955.00	1880.00	161	8	162	318	0.509433962264151	0.338947605952685	0.338947605952685	false	false	false	true
7850e253-7433-43af-88c0-c177f6209397	2026-08-28 10:53	2026-08-28 10:53	2026-08-28 10:53	ROL	ROL280121C00035000	call	35.0000	2028-01-21	6.8800	6.3000	7.1000	36.3300	16508.00	16508.00	0.00	24	6	75	0	0	0.307505081844745	0.307505081844745	false	false	false	true
af89f2e8-502e-4226-9776-afc4add3ecc9	2026-08-27 15:15	2026-08-27 15:15	2026-08-27 15:15	ROL	ROL270219C00035000	call	35.0000	2027-02-19	3.9800	3.8000	4.1000	35.0000	19878.00	19878.00	0.00	50	6	90	459	0.196078431372549	0.31871955795299	0.31871955795299	false	false	false	true
d802e10e-7249-4ce7-91d8-b2e2ff17dcae	2026-08-19 10:50	2026-08-19 10:49	2026-08-19 10:49	ROL	ROL260918C00037500	call	37.5000	2026-09-18	0.9000	0.8500	1.0000	36.8700	10440.00	720.00	9720.00	116	9	202	2187	0.0923639689071788	0.268171627771354	0.268171627771354	false	false	false	true
878da142-4e3f-4e6b-8bf7-7485c01d1434	2026-08-14 15:59	2026-08-14 15:59	2026-08-14 15:59	ROL	ROL260918C00035000	call	35.0000	2026-09-18	2.0500	1.7000	2.0500	36.1950	23322.00	23322.00	0.00	114	23	154	653	0.23583460949464	0.284660991290456	0.292079505209323	false	false	false	true