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 = RepeatedHitsDescendingFill×ticker = CORN×

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
1ac605b9-542f-4abd-ab56-fc8a7b6d3d7a	2026-09-18 14:32	2026-09-18 14:32	2026-09-18 14:32	CORN	CORN270319C00022000	call	22.0000	2027-03-19	0.5000	0.5000	0.5500	19.7150	10040.00	0.00	10040.00	200	6	452	1657	0.272782136391068	0.209679145155262	0.209679145155262	false	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	ETF	—	56640071.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-18T18:43:10.830314Z"}	2026-09-18	2026-09-18 21:15	2026-09-18 21:15
74e4da9c-6ccd-487b-8d7b-fac8f2d182e9	2026-09-18 14:32	2026-09-18 14:32	2026-09-18 14:32	CORN	CORN270319C00022000	call	22.0000	2027-03-19	0.5000	0.5000	0.5500	19.7150	10072.00	0.00	10072.00	200	6	252	1657	0.152082076041038	0.209679145155262	0.209679145155262	false	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	ETF	—	56640071.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-18T18:43:10.830314Z"}	2026-09-18	2026-09-18 21:15	2026-09-18 21:15
c652ba18-027f-4952-aee6-bb61e26075f4	2026-09-14 15:00	2026-09-14 15:00	2026-09-14 15:00	CORN	CORN261120C00019000	call	19.0000	2026-11-20	1.3500	1.3500	1.4000	20.0002	33891.00	0.00	33891.00	251	5	538	4208	0.127851711026616	0.190351791716979	0.186421392178593	false	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	ETF	—	56640071.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-14T19:19:00.930033Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
482b8c28-e5ac-4b86-be34-c4764b72bbec	2026-09-09 12:18	2026-09-09 12:18	2026-09-09 12:18	CORN	CORN261120C00017000	call	17.0000	2026-11-20	2.9900	2.9500	3.1000	19.8600	10161.00	0.00	10161.00	34	5	74	2401	0.0308204914618909	0.172707869137795	0.285534699536763	false	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	ETF	—	56640071.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-09T16:21:26.040266Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
7164394b-ed8d-453a-bdc5-ee3be91fbbe9	2026-08-26 13:53	2026-08-26 13:53	2026-08-26 13:53	CORN	CORN260918P00021000	put	21.0000	2026-09-18	1.0800	0.8500	1.1500	20.0700	107958.00	107853.00	0.00	1000	6	1010	0	0	0.256827818896123	0.256827818896123	true	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	ETF	—	56640071.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-26T18:03:36.899464Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45