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:option_symbol = ASHR260904C00033000×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
b5b39741-c079-4a32-8dbf-802ee808273e	2026-09-02 15:56	2026-09-02 15:56	2026-09-02 15:56	ASHR	ASHR260904C00033000	call	33.0000	2026-09-04	1.0400	1.0300	1.0400	34.0005	17368.00	17368.00	0.00	167	10	1436	0	0	0.306000165074098	0.306000165074098	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	1114374024.00	—	—	—	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
8a3da8b2-cc94-4977-ad10-fe7e4fc76f28	2026-09-02 15:56	2026-09-02 15:56	2026-09-02 15:56	ASHR	ASHR260904C00033000	call	33.0000	2026-09-04	1.0400	1.0300	1.0400	34.0005	26200.00	25376.00	824.00	252	10	1688	0	0	0.306000165074098	0.279486605945105	false	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	ETF	—	1114374024.00	—	—	—	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
0cdecc28-bd99-4969-b9c5-47eba3a86755	2026-09-02 15:56	2026-09-02 15:56	2026-09-02 15:56	ASHR	ASHR260904C00033000	call	33.0000	2026-09-04	1.0400	0.9800	1.0400	34.0005	52000.00	52000.00	0.00	500	12	2188	0	0	0.306000165074098	0.306000165074098	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	1114374024.00	—	—	—	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
2011acec-09d3-4b03-821d-ae1e2545e8a7	2026-09-02 16:00	2026-09-02 15:59	2026-09-02 15:59	ASHR	ASHR260904C00033000	call	33.0000	2026-09-04	1.0400	0.9600	1.0400	34.0050	52000.00	52000.00	0.00	500	32	3092	0	0	0.295602826610189	0.295602826610189	true	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	1114374024.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-03T13:35:49.066709Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
ae55a542-e660-4a4f-a4f9-53dc020809c4	2026-09-03 15:10	2026-09-03 15:10	2026-09-03 15:10	ASHR	ASHR260904C00033000	call	33.0000	2026-09-04	1.0900	1.0900	1.1800	34.1050	19075.00	0.00	19075.00	175	5	554	3092	0.179172056921087	0.580097415897303	0.580097415897303	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	1114374024.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-03T19:29:59.445996Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
3353e18a-58f3-4ac0-a964-def0180a45e6	2026-09-03 15:28	2026-09-03 15:28	2026-09-03 15:28	ASHR	ASHR260904C00033000	call	33.0000	2026-09-04	1.0800	1.0800	1.1500	34.0900	32400.00	0.00	32400.00	300	5	1681	3092	0.54366106080207	0.534615035266214	0.534615035266214	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	1114374024.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-03T19:29:59.445996Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
d66b69ba-bf63-4c65-aa66-eb16a90c907a	2026-09-03 15:57	2026-09-03 15:57	2026-09-03 15:57	ASHR	ASHR260904C00033000	call	33.0000	2026-09-04	1.0900	1.0800	1.1500	34.1050	52974.00	0.00	52974.00	486	19	2167	3092	0.700840879689521	0.494488055283662	0.494488055283662	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	1114374024.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-04T13:30:32.030452Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
992990c7-2987-4828-950d-8a9e7782c717	2026-09-04 13:14	2026-09-04 13:14	2026-09-04 13:14	ASHR	ASHR260904C00033000	call	33.0000	2026-09-04	1.1700	0.7600	1.1700	34.1750	71721.00	71721.00	0.00	613	7	914	1537	0.594664931685101	0.341066063691212	0.341066063691212	true	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	1114374024.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-04T17:34:11.817020Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45