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

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	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Basic Materials	51515810502.00	2026-11-02	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-22T19:02:38.336545Z"}	2026-09-22	2026-09-22 21:15	2026-09-22 21:15
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	true
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
90622928-ecb9-45c6-a3c2-879aa6749dec	2026-09-02 11:13	2026-09-02 11:13	2026-09-02 11:13	FNV	FNV260918P00230000	put	230.0000	2026-09-18	0.9500	0.6500	0.9500	257.3500	21558.00	21558.00	0.00	227	40	231	225	1.02666666666667	0.416671626701827	0.416671626701827	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	true
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	true
41defef1-329e-4a8c-85e7-ea97bb4a6756	2026-08-25 09:56	2026-08-25 09:55	2026-08-25 09:55	FNV	FNV260918C00230000	call	230.0000	2026-09-18	39.6900	37.9000	39.7000	267.7000	83349.00	79399.00	3950.00	21	9	25	246	0.101626016260163	0.470984646284209	0.470984646284209	false	false	false	true
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	true
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	true
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	true
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	true
bc4dc97c-a212-49dc-84c5-4f0fe85fc215	2026-08-21 10:35	2026-08-21 10:35	2026-08-21 10:35	FNV	FNV260918P00260000	put	260.0000	2026-09-18	9.4500	8.8000	10.0000	264.2200	28353.00	28353.00	0.00	30	8	56	103	0.543689320388349	0.408664563570712	0.408664563570712	false	false	false	true
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	true
9f37311d-58f8-4ab0-9703-a281639853dc	2026-08-20 11:22	2026-08-20 11:22	2026-08-20 11:22	FNV	FNV270115P00200000	put	200.0000	2027-01-15	4.8600	3.9000	5.2000	255.3800	12152.00	12152.00	0.00	25	13	25	1812	0.0137969094922737	0.407836398178257	0.407836398178257	false	false	false	true
5b42fd92-8e20-424c-82ea-7fe458c3a845	2026-08-17 15:06	2026-08-17 15:06	2026-08-17 15:06	FNV	FNV270115P00200000	put	200.0000	2027-01-15	7.2400	7.0000	7.7000	238.1150	18100.00	0.00	18100.00	25	11	35	1783	0.0196298373527762	0.397443138536562	0.397443138536562	false	false	false	true