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.

231,528 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts231,528 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 = ROL×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	pricenumeric	bidnumeric	asknumeric	underlying_pricenumeric	total_premiumnumeric	total_ask_side_premnumeric	total_bid_side_premnumeric	total_sizebigint	trade_countinteger	volumebigint	open_interestbigint	volume_oi_rationumeric	iv_startnumeric	iv_endnumeric	has_sweepboolean	has_floorboolean	has_multilegboolean	has_singlelegboolean	all_opening_tradesboolean	alert_ruletext	rule_iduuid	expiry_countinteger	issue_typetext	sectortext	marketcapnumeric	next_earnings_datedate	er_timetext	missing_periscopeboolean	sourcetext	endpointtext	request_paramsjsonb	as_ofdate	vintage_tstimestamp with time zone	retrieved_attimestamp with time zone
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	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Consumer Cyclical	16989244215.00	2026-11-04	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-19T14:50:22.027850Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
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	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Consumer Cyclical	16989244215.00	2026-11-04	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-31T15:33:38.203445Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
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	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Consumer Cyclical	16989244215.00	2026-11-04	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-03T14:57:35.447301Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
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	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Consumer Cyclical	16989244215.00	2026-11-04	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-03T14:57:35.447301Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
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	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Consumer Cyclical	16989244215.00	2026-11-04	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-03T14:57:35.447301Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
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	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Consumer Cyclical	16989244215.00	2026-11-04	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-03T15:27:44.291947Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
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	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Consumer Cyclical	16989244215.00	2026-11-04	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-03T15:27:44.291947Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
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	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Consumer Cyclical	16989244215.00	2026-11-04	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-03T15:27:44.291947Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
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	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Consumer Cyclical	16132805396.00	2026-11-04	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-16T14:55:35.772586Z"}	2026-09-16	2026-09-16 21:15	2026-09-16 21:15