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:source = uw_flow_alerts×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

e65b84bc-3c3b-45c4-9398-d104acf4993e	2026-08-17 10:09	2026-08-17 10:09	2026-08-17 10:09	NAIL	NAIL260918C00040000	call	40.0000	2026-09-18	4.2800	3.9000	4.5000	40.5550	14114.00	14114.00	0.00	33	5	33	143	0.230769230769231	0.828687071362611	0.828687071362611	false	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	ETF	—	545868000.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-17T14:25:15.386684Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
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
69972ab2-b099-4846-b47a-6cb548f41846	2026-08-19 14:02	2026-08-19 14:02	2026-08-19 14:02	NAIL	NAIL270319C00060000	call	60.0000	2027-03-19	6.1500	6.0000	6.7000	42.5950	28284.00	0.00	28284.00	46	8	46	33	1.39393939393939	0.841961148719278	0.841961148719278	false	false	false	true
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
dde9c65a-e834-48cb-9eae-393f399680b9	2026-09-01 13:46	2026-09-01 13:46	2026-09-01 13:46	NAIL	NAIL260925P00030000	put	30.0000	2026-09-25	1.0200	1.0000	1.3500	33.8650	20405.00	0.00	20405.00	200	14	242	97	2.49484536082474	0.765336157299445	0.784068334894237	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
67024f7c-3514-4f87-bea6-bae437768233	2026-09-10 09:46	2026-09-10 09:46	2026-09-10 09:46	NAIL	NAIL261016P00030000	put	30.0000	2026-10-16	3.8300	3.5000	3.9000	28.7800	11504.00	11504.00	0.00	30	7	45	436	0.103211009174312	0.878514129685991	0.878514129685991	false	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
d3e8e03e-21bc-431d-b072-e2d2c574d5cf	2026-09-18 09:37	2026-09-18 09:37	2026-09-18 09:37	NAIL	NAIL260925P00029000	put	29.0000	2026-09-25	1.4100	1.1500	1.5500	29.1250	14146.00	14146.00	0.00	100	5	100	85	1.17647058823529	0.93046651870763	0.93046651870763	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