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.

281,039 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts281,039 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:alert_rule = RepeatedHitsAscendingFill×ticker = CF×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
35b537b5-d045-4382-9638-9247df050def	2026-08-31 11:53	2026-08-31 11:53	2026-08-31 11:53	CF	CF261016C00120000	call	120.0000	2026-10-16	12.2800	11.3000	13.0000	127.8050	49112.00	49112.00	0.00	40	6	81	205	0.395121951219512	0.418967664055695	0.418967664055695	false	false	false	true	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	Common Stock	Basic Materials	19861616181.00	2026-11-04	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-31T16:06:41.823379Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
64c6f010-91d9-4e81-b34f-f767dfca15a6	2026-09-01 15:05	2026-09-01 15:05	2026-09-01 15:05	CF	CF261016C00140000	call	140.0000	2026-10-16	6.0700	5.6000	6.2000	134.4900	182092.00	111292.00	0.00	300	5	333	175	1.90285714285714	0.422340381529734	0.422340381529734	false	false	false	true	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	Common Stock	Basic Materials	19861616181.00	2026-11-04	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-01T19:21:20.162349Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
6b9986b3-72ce-4ee3-a234-bd2cf154ef2c	2026-09-04 14:20	2026-09-04 14:20	2026-09-04 14:20	CF	CF261016C00140000	call	140.0000	2026-10-16	6.0000	5.8000	6.0000	134.4100	30586.00	30586.00	0.00	51	19	109	518	0.21042471042471	0.439929534136304	0.445503762142908	false	false	false	true	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	Common Stock	Basic Materials	19861616181.00	2026-11-04	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-04T18:34:11.376593Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
2d150e52-0009-4837-a446-58f618adf2eb	2026-09-04 14:21	2026-09-04 14:20	2026-09-04 14:20	CF	CF261016C00140000	call	140.0000	2026-10-16	5.9900	5.8000	6.1000	134.4100	31770.00	31770.00	0.00	53	8	162	518	0.312741312741313	0.439929534136304	0.445503762142908	false	false	false	true	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	Common Stock	Basic Materials	19861616181.00	2026-11-04	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-04T18:34:11.376593Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
059f6a98-d80a-40b0-a712-2d9b633d7ce3	2026-09-04 14:21	2026-09-04 14:20	2026-09-04 14:20	CF	CF261016C00140000	call	140.0000	2026-10-16	6.0800	5.8000	6.1000	134.4100	17010.00	17010.00	0.00	28	7	227	518	0.438223938223938	0.445503762142908	0.451074377351778	false	false	false	true	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	Common Stock	Basic Materials	19861616181.00	2026-11-04	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-04T18:34:11.376593Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
c8f04829-803f-44b0-8c7f-279c2cb68dab	2026-09-04 15:50	2026-09-04 15:49	2026-09-04 15:49	CF	CF280121C00120000	call	120.0000	2028-01-21	36.6700	36.3000	37.1000	133.6000	645452.00	0.00	80272.00	176	6	520	64	8.125	0.435324225051321	0.435324225051321	false	false	false	true	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	Common Stock	Basic Materials	19861616181.00	2026-11-04	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-04T20:00:02.053596Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
f14002a3-d7d6-4698-a60c-e675f3ec1def	2026-09-08 10:15	2026-09-08 10:15	2026-09-08 10:15	CF	CF270115C00140000	call	140.0000	2027-01-15	13.8500	13.3000	14.3000	135.9750	27700.00	27700.00	0.00	20	6	22	2059	0.0106847984458475	0.457857748041465	0.457857748041465	false	false	false	true	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	Common Stock	Basic Materials	19861616181.00	2026-11-04	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-08T14:28:51.897139Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
2dc5bc80-86cf-4e8e-903b-fc3c0eabcc9c	2026-09-18 15:46	2026-09-18 15:46	2026-09-18 15:46	CF	CF270115C00150000	call	150.0000	2027-01-15	5.8600	5.6000	6.0000	127.7150	20514.00	20514.00	0.00	35	8	43	889	0.0483689538807649	0.436535540604645	0.436535540604645	false	false	false	true	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	Common Stock	Basic Materials	19325879201.00	2026-11-04	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-18T19:51:24.020322Z"}	2026-09-18	2026-09-18 21:15	2026-09-18 21:15