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.

326,449 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts326,449 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:alert_rule = RepeatedHits×ticker = NAIL×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

9a321210-70cc-4d1a-8c83-236f8b124101	2026-08-17 13:50	2026-08-17 13:50	2026-08-17 13:50	NAIL	NAIL260918P00036000	put	36.0000	2026-09-18	1.7500	1.7500	2.0000	40.0000	19250.00	0.00	19250.00	110	17	113	125	0.904	0.811147545964183	0.811147545964183	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	545868000.00	—	—	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-17T18:13:23.978459Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
72672338-1d04-4cba-bc7c-ad6dde91e400	2026-08-28 11:16	2026-08-28 11:16	2026-08-28 11:16	NAIL	NAIL261218P00036000	put	36.0000	2026-12-18	5.9000	5.9000	6.3000	37.4801	29500.00	0.00	29500.00	50	5	51	56	0.910714285714286	0.850139366456982	0.850139366456982	false	false	false	true
5fae1809-1ba9-4c60-98c3-eb7f80099b90	2026-08-28 15:32	2026-08-28 15:32	2026-08-28 15:32	NAIL	NAIL260904P00037000	put	37.0000	2026-09-04	0.8000	0.8000	0.9500	38.2250	16000.00	0.00	13120.00	200	9	255	238	1.07142857142857	0.642208235618658	0.642208235618658	false	false	false	true
2f803543-6963-4c35-a72a-5ea0b7c52ceb	2026-08-28 15:34	2026-08-28 15:34	2026-08-28 15:34	NAIL	NAIL260904P00037000	put	37.0000	2026-09-04	0.8000	0.8000	0.9500	38.2500	16000.00	0.00	16000.00	200	23	455	238	1.91176470588235	0.646563169964408	0.646563169964408	false	false	false	true
4d047ca4-6422-4a74-88ac-94bc32caf9a8	2026-09-01 11:01	2026-09-01 11:01	2026-09-01 11:01	NAIL	NAIL280121C00040000	call	40.0000	2028-01-21	12.8000	10.8000	13.8000	35.0835	38400.00	11520.00	26880.00	30	5	71	524	0.135496183206107	0.857029392493778	0.857029392493778	false	false	false	true
95e3bc7a-c0a9-4cff-8b44-5e21abc58fa7	2026-09-04 10:23	2026-09-04 10:23	2026-09-04 10:23	NAIL	NAIL260911P00033500	put	33.5000	2026-09-11	0.9500	0.9500	1.1000	34.9550	10070.00	0.00	10070.00	106	7	107	13	8.23076923076923	0.83689814067722	0.83689814067722	true	false	false	true
ca6ca8fe-42b6-4d8c-9238-b3600e8ce772	2026-09-14 11:24	2026-09-14 11:24	2026-09-14 11:24	NAIL	NAIL261218P00020000	put	20.0000	2026-12-18	1.1000	1.0500	1.3000	29.9100	22000.00	3740.00	18260.00	200	9	200	566	0.353356890459364	0.896917494064471	0.896917494064471	false	false	false	true
75dcd6a6-1aa2-4154-96f0-6dc255dccd8b	2026-09-14 14:36	2026-09-14 14:36	2026-09-14 14:36	NAIL	NAIL261030P00028000	put	28.0000	2026-10-30	2.5000	2.5000	3.3000	30.9250	10000.00	0.00	10000.00	40	7	40	44	0.909090909090909	0.926319784150428	0.926319784150428	false	false	false	true
13125138-c3a3-4966-9dcc-6fece5e04852	2026-09-18 10:24	2026-09-18 10:24	2026-09-18 10:24	NAIL	NAIL270319C00045000	call	45.0000	2027-03-19	2.9500	2.9500	3.1000	28.7200	59000.00	0.00	6195.00	200	11	200	268	0.746268656716418	0.854774674761985	0.854774674761985	false	false	false	true
60a6afc4-fefb-4030-8515-ddcdefa24bf6	2026-09-22 13:56	2026-09-22 13:56	2026-09-22 13:56	NAIL	NAIL261218C00041000	call	41.0000	2026-12-18	2.7000	2.0500	2.9500	32.3400	101790.00	101790.00	0.00	377	5	378	115	3.28695652173913	0.845377699918807	0.845377699918807	false	false	false	true