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 = RepeatedHitsAscendingFill×ticker = FCX×

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

9e4763e8-858f-4129-98a7-65912213f8c3	2026-09-22 13:59	2026-09-22 13:59	2026-09-22 13:59	FCX	FCX261120C00075000	call	75.0000	2026-11-20	5.9000	5.7500	5.9000	74.7400	176996.00	176996.00	0.00	300	7	457	2465	0.185395537525355	0.482124667537378	0.483803767127582	false	false	false	true	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	Common Stock	Basic Materials	106767902835.00	2026-10-22	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-22T18:03:20.556132Z"}	2026-09-22	2026-09-22 21:15	2026-09-22 21:15
a2055219-d0ba-4989-8fc9-886403585c8c	2026-09-22 09:42	2026-09-22 09:42	2026-09-22 09:42	FCX	FCX280121C00085000	call	85.0000	2028-01-21	13.8600	13.3500	14.0000	73.5100	772000.00	772000.00	0.00	557	5	676	12510	0.0540367705835332	0.482551460713085	0.482551460713085	false	false	false	true
0e9f513f-11ff-4f79-921b-ae2d105f4e35	2026-09-17 11:33	2026-09-17 11:33	2026-09-17 11:33	FCX	FCX270219C00075000	call	75.0000	2027-02-19	7.8500	7.1500	7.8500	71.3600	80808.00	80808.00	0.00	103	17	103	323	0.318885448916409	0.475446996902651	0.477066337317439	false	false	false	true
d8fe72db-4dec-4f9c-9197-8153cdda3148	2026-09-16 15:57	2026-09-16 15:57	2026-09-16 15:57	FCX	FCX261016C00080000	call	80.0000	2026-10-16	0.7900	0.6000	0.9000	69.0000	129673.00	129673.00	0.00	1650	24	2119	17515	0.120982015415358	0.474479443550849	0.474479443550849	false	false	false	true
45deb95c-2b04-4a49-96a9-5f3ff778230e	2026-09-15 10:19	2026-09-15 10:19	2026-09-15 10:19	FCX	FCX260925C00069000	call	69.0000	2026-09-25	2.4500	2.4200	2.5700	69.3100	148962.00	982.00	147980.00	608	44	616	125	4.928	0.488287856257755	0.493679219519769	false	false	false	true
604e6de8-42bb-4cf4-ab08-bf66d4d5fb08	2026-09-10 11:00	2026-09-10 11:00	2026-09-10 11:00	FCX	FCX270115P00075000	put	75.0000	2027-01-15	10.2900	10.0500	10.3000	70.8799	278785.00	278785.00	0.00	271	9	294	1775	0.165633802816901	0.509692689913092	0.510891801459803	false	false	false	true
1f20624f-d9da-4b5e-909d-0da98daf4836	2026-09-10 09:31	2026-09-10 09:31	2026-09-10 09:31	FCX	FCX261218P00070000	put	70.0000	2026-12-18	6.5300	6.5000	7.0000	70.5800	68527.00	1340.00	67187.00	105	21	129	5479	0.0235444424164994	0.493862619786257	0.507788681807359	false	false	false	true
9d3e214b-3da9-4f52-b975-87a8e0763a27	2026-09-04 09:50	2026-09-04 09:50	2026-09-04 09:50	FCX	FCX261016C00080000	call	80.0000	2026-10-16	1.9400	1.8600	1.9600	72.2900	83955.00	83955.00	0.00	433	7	481	23425	0.0205336179295624	0.459084221864072	0.459084221864072	false	false	false	true
1bfe6b48-4674-4129-b618-9e827e14cb46	2026-09-03 15:16	2026-09-03 15:16	2026-09-03 15:16	FCX	FCX270219P00075000	put	75.0000	2027-02-19	10.1500	9.7500	10.2000	72.3500	66962.00	37527.00	28420.00	66	11	72	82	0.878048780487805	0.477106409513484	0.477618284274844	true	false	false	true
5dbd4615-846d-4294-b9cb-abc23714a250	2026-09-02 12:18	2026-09-02 12:17	2026-09-02 12:17	FCX	FCX270617C00075000	call	75.0000	2027-06-17	12.4100	12.4000	12.7500	73.2100	136455.00	13695.00	122760.00	110	15	116	1298	0.0893682588597843	0.470924929209536	0.472904139259528	false	false	false	true
10ba5abf-985f-45ae-ae39-6a2d628867ae	2026-09-01 09:45	2026-09-01 09:45	2026-09-01 09:45	FCX	FCX261016C00070000	call	70.0000	2026-10-16	6.9600	6.7000	7.0500	73.6450	69626.00	69626.00	0.00	100	10	102	3062	0.0333115610711953	0.467303939029415	0.467303939029415	false	false	false	true
1a5625ce-c4d2-48c3-8d24-25f37a0473f2	2026-08-28 15:32	2026-08-28 15:32	2026-08-28 15:32	FCX	FCX280121C00080000	call	80.0000	2028-01-21	17.3500	16.9000	17.5500	76.0491	64197.00	64197.00	0.00	37	7	87	2079	0.0418470418470418	0.48280945878285	0.483683669192412	false	false	false	true
0a5a15a2-26c2-42b5-8638-c2baaadc3543	2026-08-28 12:52	2026-08-28 12:52	2026-08-28 12:52	FCX	FCX261120C00080000	call	80.0000	2026-11-20	6.3500	6.2500	6.5000	77.2100	66725.00	0.00	66725.00	105	5	658	3497	0.188161281098084	0.491672842695683	0.492349593432287	false	false	false	true
03438b13-0b57-47d3-a136-90dd3e60704c	2026-08-24 09:53	2026-08-24 09:53	2026-08-24 09:53	FCX	FCX260828C00071000	call	71.0000	2026-08-28	6.7500	6.7500	7.0500	77.5700	1473576.00	0.00	1473576.00	2183	50	2192	1075	2.03906976744186	0.586879325492786	0.586879325492786	false	false	false	true
5029f3a2-0087-42a5-83b2-ad5028a87fab	2026-08-21 13:57	2026-08-21 13:57	2026-08-21 13:57	FCX	FCX261218P00055000	put	55.0000	2026-12-18	1.2700	1.2600	1.2900	76.6000	82720.00	29926.00	52794.00	651	30	1859	11574	0.160618627959219	0.53310640023582	0.53310640023582	false	false	false	true
e3b4efa7-0108-4a8c-809b-505ca29c8fe0	2026-08-21 10:53	2026-08-21 10:53	2026-08-21 10:53	FCX	FCX261218C00080000	call	80.0000	2026-12-18	7.3500	7.3000	7.6500	75.1550	157338.00	13230.00	144108.00	214	19	945	10087	0.0936849410131853	0.522728598687314	0.522728598687314	false	false	false	true
705d4977-4caf-4e94-85ee-73f4f01b327f	2026-08-21 10:39	2026-08-21 10:39	2026-08-21 10:39	FCX	FCX261016C00085000	call	85.0000	2026-10-16	3.0500	3.0500	3.1500	75.2600	270324.00	0.00	270324.00	886	44	1723	1482	1.16261808367072	0.536721892033989	0.536721892033989	true	false	false	true
2272e6f5-f3d9-4504-a790-d5129fd289d9	2026-08-21 10:24	2026-08-21 10:24	2026-08-21 10:24	FCX	FCX261016C00090000	call	90.0000	2026-10-16	2.2500	2.2100	2.3600	75.6852	77852.00	7875.00	58052.00	346	12	1955	286	6.83566433566434	0.554120474303239	0.554120474303239	true	false	false	true
bf41092f-c554-4327-9160-c41eb0bd67cc	2026-08-21 09:55	2026-08-21 09:55	2026-08-21 09:55	FCX	FCX260918C00075000	call	75.0000	2026-09-18	6.0000	5.8500	6.1500	77.2950	60030.00	51255.00	8775.00	100	5	2840	31654	0.0897200985657421	0.533946296770227	0.55595594628464	false	false	false	true
9637f069-31b9-41e1-b4c5-e4ff6c4edbe0	2026-08-21 09:33	2026-08-21 09:32	2026-08-21 09:32	FCX	FCX260918C00075000	call	75.0000	2026-09-18	4.5300	4.4000	4.7000	75.1500	70150.00	910.00	21600.00	155	12	616	31654	0.0194604157452455	0.521177401925922	0.521177401925922	false	false	false	true
c98fa584-16c0-4b7f-b26c-67db622ea12a	2026-08-21 09:31	2026-08-21 09:31	2026-08-21 09:31	FCX	FCX260918C00070000	call	70.0000	2026-09-18	7.3400	7.0000	20.0000	75.5600	86670.00	755.00	85915.00	118	9	120	17428	0.00688547165480835	0.489027579544016	0.509739702711537	true	false	false	true
8efed1fc-6907-414c-add1-70ba5918bc73	2026-08-20 15:39	2026-08-20 15:39	2026-08-20 15:39	FCX	FCX281215C00095000	call	95.0000	2028-12-15	15.5000	15.5000	16.3000	70.9650	249598.00	0.00	249598.00	161	10	806	757	1.06472919418758	0.478339433458495	0.478572288762621	false	false	false	true
3362776a-f1f3-445b-a4bc-c874f9ac1eb0	2026-08-20 14:04	2026-08-20 14:04	2026-08-20 14:04	FCX	FCX261218C00080000	call	80.0000	2026-12-18	5.4000	5.3000	5.6500	71.3900	83707.00	16200.00	67507.00	155	18	6082	4649	1.30823833082383	0.506272039079107	0.506534333732108	false	false	false	true
28a32a70-4c34-4c9f-9641-6e021d0b5840	2026-08-20 13:51	2026-08-20 13:51	2026-08-20 13:51	FCX	FCX261218C00080000	call	80.0000	2026-12-18	5.0500	5.0000	5.2000	70.6300	170221.00	510.00	169711.00	337	20	5641	4649	1.21337922133792	0.504205179666463	0.504205179666463	false	false	false	true
bac11233-2af4-4ea7-bf36-3e81be2eadb0	2026-08-20 12:38	2026-08-20 12:38	2026-08-20 12:38	FCX	FCX261218C00080000	call	80.0000	2026-12-18	5.0500	5.0000	5.0500	70.4100	531165.00	521665.00	9500.00	1052	28	4331	4649	0.931598193159819	0.506671750218875	0.509873654579912	false	false	false	true
17a52dcb-d1bf-496b-a1a6-b8863bfeb12c	2026-08-20 11:30	2026-08-20 11:30	2026-08-20 11:30	FCX	FCX281215C00065000	call	65.0000	2028-12-15	24.0000	24.0000	24.7000	69.9250	244810.00	0.00	244810.00	102	5	104	314	0.331210191082803	0.470151257988453	0.471555928349453	false	false	false	true
b4c37a71-e337-4884-b96e-113cd0ed110e	2026-08-19 13:44	2026-08-19 13:44	2026-08-19 13:44	FCX	FCX261218P00060000	put	60.0000	2026-12-18	3.3500	3.3500	3.5000	68.7800	198999.00	0.00	198999.00	594	42	625	10700	0.058411214953271	0.487760402268807	0.487760402268807	false	false	false	true
712112dd-5c6d-4d1c-8c27-c2f9a89347c4	2026-08-18 14:22	2026-08-18 14:22	2026-08-18 14:22	FCX	FCX261120C00085000	call	85.0000	2026-11-20	1.6100	1.6100	1.7200	66.0700	93876.00	1945.00	91931.00	583	46	585	9292	0.0629573826947912	0.489099319331327	0.491241756790087	false	false	false	true
19ceb0c4-f05c-4d5c-a7c1-abcbf06513a5	2026-08-17 13:04	2026-08-17 13:04	2026-08-17 13:04	FCX	FCX261218C00075000	call	75.0000	2026-12-18	5.7000	5.4500	5.7000	68.7200	113998.00	113998.00	0.00	200	7	2932	4270	0.686651053864169	0.488891825254759	0.490157422368222	false	false	false	true
d9702076-0cd9-4abb-8e2e-3053bc8c80f2	2026-08-17 11:41	2026-08-17 11:41	2026-08-17 11:41	FCX	FCX270617C00080000	call	80.0000	2027-06-17	8.9000	8.4500	8.9000	68.5100	112090.00	112090.00	0.00	126	12	173	540	0.32037037037037	0.48823335322356	0.488634775352923	false	false	false	true