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 = HIVE×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
50756024-aaf9-4935-9f70-fd09fb74219f	2026-08-17 09:56	2026-08-17 09:56	2026-08-17 09:56	HIVE	HIVE260821C00003000	call	3.0000	2026-08-21	0.1500	0.1000	0.1500	2.9550	10337.00	10337.00	0.00	690	7	2493	7354	0.338999184117487	1.21435051702578	1.37654935137862	false	false	false	true	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	Common Stock	Financial Services	820089241.00	2026-11-13	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-17T14:09:25.911404Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
91fc3107-90a6-43cc-b3e2-cc4bc635521f	2026-08-21 13:05	2026-08-21 13:05	2026-08-21 13:05	HIVE	HIVE270115C00003500	call	3.5000	2027-01-15	0.6400	0.5500	0.6500	2.9750	13490.00	13490.00	0.00	210	5	344	2806	0.122594440484676	1.06033745703873	1.06033745703873	false	false	false	true	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	Common Stock	Financial Services	820089241.00	2026-11-13	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-21T17:09:02.511847Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
165f7aab-0725-48f2-ac3f-e54f1e9846bb	2026-09-02 15:49	2026-09-02 15:49	2026-09-02 15:49	HIVE	HIVE270115C00004000	call	4.0000	2027-01-15	0.3000	0.2500	0.3000	2.7050	45477.00	45477.00	0.00	1518	16	1708	13737	0.124335735604572	0.940652522189514	0.973120168211278	true	false	false	true	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	Common Stock	Financial Services	820089241.00	2026-11-13	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-02T19:59:06.148248Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
bb26cf26-ecea-44e6-a597-29be35f8728c	2026-09-08 11:17	2026-09-08 11:17	2026-09-08 11:17	HIVE	HIVE280121C00003000	call	3.0000	2028-01-21	1.4000	1.4000	1.4500	3.1950	14012.00	572.00	13440.00	100	10	125	10811	0.011562297659791	0.90747549145471	0.932196787516442	false	false	false	true	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	Common Stock	Financial Services	820089241.00	2026-11-13	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-08T15:26:49.659255Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45