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 = FloorTradeMidCap×ticker = HIMS×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
348946d4-a758-44af-90e7-1e6cdfe679bb	2026-08-17 10:34	2026-08-17 10:34	2026-08-17 10:34	HIMS	HIMS280121C00040000	call	40.0000	2028-01-21	8.1200	8.0000	8.3000	27.9900	162400.00	0.00	162400.00	200	2	2020	6934	0.291318142486299	0.82780807287929	0.82780807287929	false	true	true	false	false	FloorTradeMidCap	d9769fb4-003b-49e4-9181-c78c9cc101f5	2	Common Stock	Consumer Defensive	6480400110.00	2026-11-02	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-17T14:42:42.502476Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45