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.

375,978 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts375,978 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:alert_rule = RepeatedHits×sector = Basic Materials×ticker = FNV×

iduuid	created_at ↓timestamp with time zone	start_timetimestamp with time zone	end_timetimestamp with time zone	tickertext	option_symboltext	option_typetext	strikenumeric	expiry

1ddb1256-1895-461c-a5e8-fd4a1e8aa0fd	2026-09-23 15:38	2026-09-23 15:37	2026-09-23 15:37	FNV	FNV261218C00250000	call	250.0000	2026-12-18	25.3000	25.3000	27.1000	259.8000	40480.00	0.00	40480.00	16	12	16	0	0	0.378042817538398	0.378042817538398	true	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Basic Materials	50303106730.00	2026-11-02	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-23T19:42:45.926021Z"}	2026-09-23	2026-09-23 21:15	2026-09-23 21:15
985ab6f1-393d-4b80-82d4-dc167fb84bb0	2026-09-22 14:57	2026-09-22 14:57	2026-09-22 14:57	FNV	FNV270115P00270000	put	270.0000	2027-01-15	22.9000	22.0000	23.4000	266.7300	233580.00	22900.00	210680.00	102	18	102	55	1.85454545454545	0.387152130269439	0.387152130269439	false	false	false
6e4ef1e9-a7d4-42a9-9add-8c32ed2e6886	2026-09-21 15:49	2026-09-21 15:49	2026-09-21 15:49	FNV	FNV261120P00220000	put	220.0000	2026-11-20	2.3000	1.8500	2.3000	262.0000	17250.00	17250.00	0.00	75	24	77	5	15.4	0.387660686907883	0.387660686907883	false	false	false	true
1b0c8849-6162-48a7-aed9-644c9b3ed590	2026-09-17 10:08	2026-09-17 10:08	2026-09-17 10:08	FNV	FNV261016P00260000	put	260.0000	2026-10-16	8.1000	7.5000	8.1000	266.6300	119066.00	119066.00	0.00	147	39	147	73	2.01369863013699	0.387166700646374	0.387166700646374	false	false	false	true
31946bd5-06a5-420e-b2a1-daeeb34aabec	2026-09-16 12:08	2026-09-16 12:08	2026-09-16 12:08	FNV	FNV261016C00280000	call	280.0000	2026-10-16	5.6000	5.0000	5.8000	262.8600	68320.00	68320.00	0.00	122	10	123	179	0.687150837988827	0.387930860751255	0.387930860751255	false	false	false
077fae3f-48f3-4ab3-872b-581cc23b0285	2026-09-09 12:15	2026-09-09 12:15	2026-09-09 12:15	FNV	FNV261016P00240000	put	240.0000	2026-10-16	4.1000	3.7000	4.1000	266.8250	54940.00	54940.00	0.00	134	36	149	140	1.06428571428571	0.428719804166775	0.428719804166775	false	false	false	true
d3b79da0-752a-4468-b363-8e0f258d7c74	2026-09-01 09:40	2026-09-01 09:40	2026-09-01 09:40	FNV	FNV270416C00290000	call	290.0000	2027-04-16	22.0000	20.8000	23.9000	255.8450	220000.00	140800.00	33000.00	100	6	100	17	5.88235294117647	0.404252476255744	0.404252476255744	false	false	false
7e2ef6bc-7acb-4a83-a65d-352fe324b9fb	2026-08-28 10:31	2026-08-28 10:31	2026-08-28 10:31	FNV	FNV270416C00280000	call	280.0000	2027-04-16	32.0000	30.9000	33.7000	267.9750	640000.00	409600.00	230400.00	200	6	200	8	25	0.402749466898237	0.402749466898237	false	false	false	true
f2f01c44-3b09-4b5e-a977-82c0b813dbdf	2026-08-25 15:23	2026-08-25 15:23	2026-08-25 15:23	FNV	FNV260918C00260000	call	260.0000	2026-09-18	17.5000	17.5000	19.5000	272.5300	175000.00	0.00	175000.00	100	18	102	285	0.357894736842105	0.349081697778925	0.349081697778925	false	false	false
ba3b8aa9-ad1c-4ba1-aa1c-82e0a634a82a	2026-08-25 10:25	2026-08-25 10:25	2026-08-25 10:25	FNV	FNV260918C00230000	call	230.0000	2026-09-18	41.6000	38.7000	41.6000	270.0000	95680.00	95680.00	0.00	23	6	85	246	0.345528455284553	0.450135583889278	0.450135583889278	false	false	false
c54e8c0a-74a9-4696-872f-33395ddc1287	2026-08-25 10:13	2026-08-25 10:13	2026-08-25 10:13	FNV	FNV260918C00230000	call	230.0000	2026-09-18	41.0900	38.8000	41.1000	269.7600	106840.00	106840.00	0.00	26	8	51	246	0.207317073170732	0.418744745052652	0.418744745052652	false	false	false
93c5ac55-3cee-4cd1-9eed-856065309f0c	2026-08-24 15:09	2026-08-24 15:09	2026-08-24 15:09	FNV	FNV261016P00270000	put	270.0000	2026-10-16	17.8000	16.7000	17.8000	269.0350	113920.00	113920.00	0.00	64	22	64	21	3.04761904761905	0.442508929631551	0.442508929631551	false	false	false
6978fdbb-a3c1-4fb3-a813-aa54635590ad	2026-08-21 15:29	2026-08-21 15:29	2026-08-21 15:29	FNV	FNV260918C00270000	call	270.0000	2026-09-18	9.3000	9.3000	10.3000	264.1800	63240.00	0.00	63240.00	68	20	108	244	0.442622950819672	0.395349853222408	0.395349853222408	false	false	false
dd555588-70ad-4058-b397-d76a9cbf852b	2026-08-21 14:59	2026-08-21 14:59	2026-08-21 14:59	FNV	FNV260918C00260000	call	260.0000	2026-09-18	14.0000	13.6000	14.0000	264.5500	238000.00	18200.00	0.00	170	17	202	127	1.59055118110236	0.385365325519855	0.385365325519855	false	false	false
f747c37f-e50f-4332-984a-83e3202f6765	2026-08-21 12:57	2026-08-21 12:57	2026-08-21 12:57	FNV	FNV270115C00320000	call	320.0000	2027-01-15	10.7000	10.7000	11.8000	266.1250	21400.00	0.00	21400.00	20	8	20	153	0.130718954248366	0.392929377746109	0.392929377746109	false	false	false
f0ce9e96-2a69-420a-af0e-fabc6c1b707c	2026-08-20 15:30	2026-08-20 15:29	2026-08-20 15:29	FNV	FNV270115C00270000	call	270.0000	2027-01-15	22.0000	21.0000	22.0000	256.0900	11000.00	11000.00	0.00	5	5	6	409	0.0146699266503667	0.401529513997831	0.401529513997831	false	false	false