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.

728,802 rows

Sources in this table

uw_flow_alerts728,802 rows

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:alert_rule = RepeatedHits×ticker = GDX×

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

153388bf-1e7f-4326-b0cb-c46bb6aca2d1	2026-08-25 12:23	2026-08-25 12:23	2026-08-25 12:23	GDX	GDX260828C00103000	call	103.0000	2026-08-28	3.3000	3.1500	3.3500	104.9600	26400.00	26400.00	0.00	80	7	572	489	1.16973415132924	0.574350435151792	0.574350435151792	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	52.34	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-25T16:29:52.792110Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
240bbc72-9942-4589-992d-0430962bb355	2026-08-25 12:18	2026-08-25 12:18	2026-08-25 12:18	GDX	GDX260911P00098000	put	98.0000	2026-09-11	1.6300	1.6300	1.7900	105.0150	16463.00	0.00	16463.00	101	7	321	249	1.28915662650602	0.493121385088503	0.493121385088503	true	false	false	true
899e72c0-f0b9-49ab-a3eb-c08cb49080e1	2026-08-25 12:17	2026-08-25 12:17	2026-08-25 12:17	GDX	GDX260918P00099000	put	99.0000	2026-09-18	2.6900	2.5800	2.7000	104.9500	16164.00	16164.00	0.00	60	6	171	1307	0.130833970925784	0.501878507449857	0.501878507449857	false	false	false	true
cd91a4ca-7eed-4f4b-8d62-099ba35903ab	2026-08-25 11:45	2026-08-25 11:45	2026-08-25 11:45	GDX	GDX270115C00110000	call	110.0000	2027-01-15	11.1000	10.9000	11.2500	105.0500	24420.00	9990.00	13320.00	22	5	214	15517	0.0137913256428433	0.47712181185942	0.47712181185942	false	false	false	true
3ff93508-4537-4deb-bf79-a8000f050ff1	2026-08-25 11:42	2026-08-25 11:42	2026-08-25 11:42	GDX	GDX260828C00107000	call	107.0000	2026-08-28	1.5800	1.5800	1.6000	105.1900	44872.00	0.00	44872.00	284	24	830	20143	0.0412053815221169	0.615950266487111	0.615950266487111	true	false	false	true
085d2633-5151-4f69-9549-227700c95dc9	2026-08-25 11:42	2026-08-25 11:42	2026-08-25 11:42	GDX	GDX260828C00107000	call	107.0000	2026-08-28	1.6000	1.5000	1.6000	105.1900	18560.00	18560.00	0.00	116	8	946	20143	0.0469642059276175	0.62140318206069	0.62140318206069	true	false	false	true
adf8d87a-99ff-4ccc-a843-46ab50be5138	2026-08-25 11:35	2026-08-25 11:35	2026-08-25 11:35	GDX	GDX261016C00109000	call	109.0000	2026-10-16	6.4500	6.0500	6.4500	105.0000	23865.00	23865.00	0.00	37	8	41	104	0.394230769230769	0.501225067810835	0.501225067810835	false	false	false	true
993cbac0-094c-415a-ad59-28e2ef08e1ee	2026-08-25 11:33	2026-08-25 11:33	2026-08-25 11:33	GDX	GDX260828C00106000	call	106.0000	2026-08-28	1.6000	1.4800	1.6600	104.5650	20480.00	20480.00	0.00	128	23	415	411	1.00973236009732	0.586130806498435	0.586130806498435	true	false	false	true
74a97af7-81db-4c50-9587-4536aed86988	2026-08-25 11:33	2026-08-25 11:33	2026-08-25 11:33	GDX	GDX260828C00108000	call	108.0000	2026-08-28	0.9700	0.9700	0.9800	104.5650	10961.00	0.00	5529.00	113	9	255	12366	0.0206210577389617	0.592846043424854	0.592846043424854	false	false	false	true
9f9b5ae7-ee8c-4f6d-8c0a-0afa8cbf16a6	2026-08-25 11:30	2026-08-25 11:30	2026-08-25 11:30	GDX	GDX270115C00115000	call	115.0000	2027-01-15	9.1800	8.8000	9.2000	104.4600	45880.00	45880.00	0.00	50	5	270	2549	0.105923891722244	0.484876194068564	0.484876194068564	false	false	false	true
bc22e57a-e812-4e71-a9ca-5390ba6c6b9e	2026-08-25 11:29	2026-08-25 11:29	2026-08-25 11:29	GDX	GDX261016C00100000	call	100.0000	2026-10-16	10.4000	10.3000	10.5000	104.5750	16640.00	14560.00	2080.00	16	7	575	4712	0.122028862478778	0.493543319580216	0.493543319580216	false	false	false	true
3993e44c-ead6-4ee2-9392-d72b7d3addd4	2026-08-25 11:22	2026-08-25 11:22	2026-08-25 11:22	GDX	GDX260828P00096000	put	96.0000	2026-08-28	0.1600	0.1600	0.1800	104.2069	60224.00	0.00	60224.00	3764	33	7949	5560	1.42967625899281	0.604783289406133	0.604783289406133	false	false	false	true
a4e28731-47de-43b0-88a9-a21f0d89b988	2026-08-25 10:55	2026-08-25 10:54	2026-08-25 10:54	GDX	GDX260828C00107000	call	107.0000	2026-08-28	0.9900	0.9900	1.0700	103.6695	36135.00	0.00	36135.00	365	27	394	20143	0.0195601449635109	0.595370834484898	0.595370834484898	true	false	false	true
46e19a25-c63f-43f9-97a3-8f4b1deae47a	2026-08-25 10:53	2026-08-25 10:53	2026-08-25 10:53	GDX	GDX260828P00096000	put	96.0000	2026-08-28	0.2100	0.2100	0.2300	103.8400	30660.00	0.00	30660.00	1460	23	2498	5560	0.449280575539568	0.623890373117452	0.623890373117452	false	false	false	true
53002ae3-e999-49f9-b198-61bc5f335eea	2026-08-25 10:47	2026-08-25 10:47	2026-08-25 10:47	GDX	GDX260828P00101000	put	101.0000	2026-08-28	1.0400	1.0400	1.1500	103.8300	10400.00	0.00	10400.00	100	11	843	685	1.23065693430657	0.588260124055688	0.588260124055688	false	false	false	true
6546132f-7d6b-4459-ad34-d0e8b3777aa3	2026-08-25 10:43	2026-08-25 10:42	2026-08-25 10:42	GDX	GDX260828P00105000	put	105.0000	2026-08-28	3.0000	2.8200	3.1000	103.5500	15000.00	9900.00	1200.00	50	13	152	423	0.359338061465721	0.588736672519098	0.588736672519098	false	false	false	true
8eabe0ba-fb5a-408d-8ff7-39720c1c4e5c	2026-08-25 10:35	2026-08-25 10:35	2026-08-25 10:35	GDX	GDX270115C00113000	call	113.0000	2027-01-15	9.4500	9.0500	9.4500	103.5400	47250.00	47250.00	0.00	50	5	150	28	5.35714285714286	0.484767222247594	0.484767222247594	false	false	false	true
016a3ed6-c227-4254-8327-b11dd00dc441	2026-08-25 10:35	2026-08-25 10:35	2026-08-25 10:35	GDX	GDX260918P00080000	put	80.0000	2026-09-18	0.1500	0.1100	0.1600	103.5500	15000.00	15000.00	0.00	1000	21	2088	67834	0.0307810242651178	0.542678251714379	0.542678251714379	false	false	false	true
3e941e34-1c34-4c93-99c2-0c108af150bf	2026-08-25 10:25	2026-08-25 10:25	2026-08-25 10:25	GDX	GDX260828P00096000	put	96.0000	2026-08-28	0.2500	0.2500	0.2800	103.3700	20950.00	0.00	20950.00	838	9	1008	5560	0.181294964028777	0.624356172139729	0.624356172139729	false	false	false	true
996a15b5-600a-4934-8ad6-12818ef76a37	2026-08-25 10:01	2026-08-25 10:01	2026-08-25 10:01	GDX	GDX260828C00105000	call	105.0000	2026-08-28	1.2500	1.1500	1.3000	102.5200	21250.00	21250.00	0.00	170	6	1213	11467	0.105781808668353	0.602155710516084	0.604165825297811	true	false	false	true
319144d8-4857-447f-84dc-489556a484a2	2026-08-25 09:45	2026-08-25 09:45	2026-08-25 09:45	GDX	GDX260904P00095000	put	95.0000	2026-09-04	0.9000	0.7600	0.9800	102.5300	24750.00	90.00	24660.00	275	15	1251	346	3.61560693641619	0.530300831732148	0.530300831732148	false	false	false	true
3d6788bc-e344-4d1a-9e49-441c50b34a80	2026-08-25 09:42	2026-08-25 09:42	2026-08-25 09:42	GDX	GDX260925P00094000	put	94.0000	2026-09-25	2.3000	2.0700	2.3000	102.5900	11500.00	11500.00	0.00	50	5	50	15	3.33333333333333	0.497830943762451	0.497830943762451	false	false	false	true
a1256b38-0672-4127-a548-0a9c796410b1	2026-08-25 09:37	2026-08-25 09:37	2026-08-25 09:37	GDX	GDX260918C00105000	call	105.0000	2026-09-18	4.4500	4.4500	4.5500	102.7600	12460.00	0.00	12460.00	28	6	81	7689	0.0105345298478346	0.507424584860951	0.507424584860951	false	false	false	true
177a4791-3c1c-463f-8a14-7255e99325b2	2026-08-25 09:36	2026-08-25 09:36	2026-08-25 09:36	GDX	GDX260828C00104000	call	104.0000	2026-08-28	1.6500	1.6400	1.8500	102.6500	13695.00	0.00	13695.00	83	10	265	37483	0.00706987167515941	0.601617186713291	0.601617186713291	false	false	false	true
88744c01-5b62-4086-8f79-33015f3eb1ce	2026-08-25 09:36	2026-08-25 09:36	2026-08-25 09:36	GDX	GDX260828P00101000	put	101.0000	2026-08-28	1.4100	1.3700	1.6200	102.8000	15792.00	141.00	15651.00	112	24	233	685	0.34014598540146	0.598690895728829	0.598690895728829	true	false	false	true
62407611-83f5-4421-b430-85b21aa096cd	2026-08-25 09:36	2026-08-25 09:35	2026-08-25 09:35	GDX	GDX260904P00095000	put	95.0000	2026-09-04	0.8500	0.8500	1.0000	102.6832	82451.00	0.00	82365.00	970	31	973	346	2.8121387283237	0.524962742237494	0.524962742237494	true	false	false	true
b5af9929-f7cc-410f-a391-6fe34f303425	2026-08-25 09:33	2026-08-25 09:33	2026-08-25 09:33	GDX	GDX260911P00094000	put	94.0000	2026-09-11	1.2100	1.2100	1.6700	102.7700	10164.00	0.00	10164.00	84	5	84	14	6	0.505211905024181	0.505211905024181	false	false	false	true
26434136-c813-4fb4-b784-3ed3dfa924ed	2026-08-25 09:33	2026-08-25 09:33	2026-08-25 09:33	GDX	GDX260911P00101000	put	101.0000	2026-09-11	3.5000	3.5000	4.1000	102.7700	65100.00	0.00	65100.00	186	16	186	37	5.02702702702703	0.502946618257931	0.502946618257931	false	false	false	true
a1eb2b60-c086-4996-8d10-30d1545ace97	2026-08-25 09:32	2026-08-25 09:32	2026-08-25 09:32	GDX	GDX261016C00090000	call	90.0000	2026-10-16	15.3000	15.3000	15.8500	102.7200	117810.00	0.00	117810.00	77	12	80	4936	0.0162074554294976	0.46671973991265	0.46671973991265	false	false	false	true
30160120-2e41-413a-8b25-032caa6c4aaa	2026-08-25 09:31	2026-08-25 09:31	2026-08-25 09:31	GDX	GDX260918P00100000	put	100.0000	2026-09-18	4.0500	4.0000	4.3500	102.2550	36450.00	0.00	36450.00	90	10	99	10119	0.00978357545211977	0.503161912763531	0.504266011383403	true	false	false	true
063a0a73-bd26-434e-9994-9d64c5f9c0b8	2026-08-25 09:31	2026-08-25 09:31	2026-08-25 09:31	GDX	GDX261016C00100000	call	100.0000	2026-10-16	9.1000	8.7000	9.1000	102.2550	15470.00	15470.00	0.00	17	13	24	4712	0.00509337860780985	0.503715458230007	0.502601845661288	true	false	false	true
bff8632e-51c8-4b22-b48f-25cad0bfa377	2026-08-25 09:31	2026-08-25 09:31	2026-08-25 09:31	GDX	GDX260828C00104000	call	104.0000	2026-08-28	1.5300	1.5300	1.6600	102.2400	11934.00	0.00	11934.00	78	11	95	37483	0.00253448229864205	0.614432644697407	0.614432644697407	false	false	false	true
f8077f84-351d-49f7-b878-70e2283e9d84	2026-08-25 09:30	2026-08-25 09:30	2026-08-25 09:30	GDX	GDX261218P00091000	put	91.0000	2026-12-18	5.2000	5.2000	6.7500	101.9900	286005.00	0.00	286005.00	550	13	550	5778	0.0951886465905157	0.473092281696039	0.473092281696039	true	false	false	true
994b7de3-e891-4ada-8c92-36e349f161fb	2026-08-24 15:50	2026-08-24 15:49	2026-08-24 15:49	GDX	GDX260918C00110000	call	110.0000	2026-09-18	3.2000	3.2000	3.2500	103.3950	40960.00	0.00	40960.00	128	20	1414	23384	0.0604686965446459	0.523894238249995	0.523894238249995	false	false	false	true
6911fd08-96be-4a18-8833-941f4d5019e5	2026-08-24 15:44	2026-08-24 15:44	2026-08-24 15:44	GDX	GDX261016P00096000	put	96.0000	2026-10-16	4.2000	4.1000	4.2500	103.2750	31920.00	25200.00	6720.00	76	18	182	455	0.4	0.494902576371205	0.494902576371205	false	false	false	true
7817ead9-f26a-4858-8404-7ee64d8499e1	2026-08-24 15:39	2026-08-24 15:39	2026-08-24 15:39	GDX	GDX260828C00105000	call	105.0000	2026-08-28	1.8500	1.7500	1.9400	103.3900	15910.00	11470.00	4440.00	86	5	6053	9461	0.63978437797273	0.587878994611274	0.587878994611274	false	false	false	true
c0376139-bcf7-4992-93e0-120a037efdfa	2026-08-24 15:20	2026-08-24 15:20	2026-08-24 15:20	GDX	GDX260828C00105000	call	105.0000	2026-08-28	1.8000	1.7600	1.8500	103.1950	38340.00	34740.00	3600.00	213	5	5961	9461	0.630060247331149	0.595011537489887	0.595011537489887	false	false	false	true
72780885-6a93-4128-b739-957b3376e3e2	2026-08-24 14:53	2026-08-24 14:53	2026-08-24 14:53	GDX	GDX260918C00121000	call	121.0000	2026-09-18	1.0600	1.0500	1.1000	102.9200	13250.00	1590.00	2120.00	125	8	371	5	74.2	0.545943007007674	0.545943007007674	false	false	false	true
876284f3-aff5-4aa1-a68a-4a0d9fb53c16	2026-08-24 14:46	2026-08-24 14:46	2026-08-24 14:46	GDX	GDX261218C00105000	call	105.0000	2026-12-18	11.0500	10.9000	11.0500	102.8500	12155.00	12155.00	0.00	11	11	94	1008	0.0932539682539683	0.4955601321486	0.4955601321486	false	false	false	true
05fef0f1-884c-41d4-b4c0-ebf8e077a2ed	2026-08-24 14:45	2026-08-24 14:45	2026-08-24 14:45	GDX	GDX260918C00135000	call	135.0000	2026-09-18	0.3100	0.3100	0.3200	102.9300	110732.00	0.00	110732.00	3572	24	6789	2179	3.11564938044975	0.593330949671293	0.593330949671293	false	false	false	true
b3c583a3-1c85-44c1-9bbf-3968e2e9f197	2026-08-24 14:41	2026-08-24 14:41	2026-08-24 14:41	GDX	GDX261016C00115000	call	115.0000	2026-10-16	4.0000	4.0000	4.0500	102.9650	15200.00	0.00	15200.00	38	8	635	1098	0.578324225865209	0.516702178399096	0.516702178399096	false	false	false	true
fae2affd-ffe1-4fa3-bb73-70807ca3bf7d	2026-08-24 14:40	2026-08-24 14:40	2026-08-24 14:40	GDX	GDX260918P00095000	put	95.0000	2026-09-18	2.1000	2.0700	2.1900	102.9250	105000.00	15750.00	89250.00	500	18	1729	8859	0.195168754938481	0.504101210438444	0.504101210438444	false	false	false	true
b9b7c75f-2230-4313-8b3f-206162272a3e	2026-08-24 14:40	2026-08-24 14:40	2026-08-24 14:40	GDX	GDX260911P00100000	put	100.0000	2026-09-11	3.2000	3.1000	3.5000	102.9200	128000.00	0.00	128000.00	400	13	552	569	0.9701230228471	0.511109977815201	0.511109977815201	false	false	false	true
0ca16962-1517-4c0b-a943-7bf01b2422f2	2026-08-24 14:37	2026-08-24 14:37	2026-08-24 14:37	GDX	GDX260918P00088000	put	88.0000	2026-09-18	0.7500	0.7200	0.8000	102.8200	156000.00	0.00	156000.00	2080	14	2177	6539	0.332925523780395	0.513748955772127	0.513748955772127	false	false	false	true
e3456f15-9686-45f8-bc2f-089ec4c470c4	2026-08-24 14:30	2026-08-24 14:30	2026-08-24 14:30	GDX	GDX261120C00120000	call	120.0000	2026-11-20	4.9500	4.9500	5.0000	103.0300	22275.00	0.00	22275.00	45	6	313	1110	0.281981981981982	0.514118988407766	0.514118988407766	false	false	false	true
68ebef24-555e-49c8-9fc8-98d347fda374	2026-08-24 14:23	2026-08-24 14:23	2026-08-24 14:23	GDX	GDX260828P00095000	put	95.0000	2026-08-28	0.3100	0.3100	0.3400	102.8800	70215.00	0.00	70215.00	2265	38	4714	3215	1.46625194401244	0.606652050057539	0.606652050057539	false	false	false	true
f40e6469-8e0e-4d21-b9e1-90111f41060c	2026-08-24 13:55	2026-08-24 13:55	2026-08-24 13:55	GDX	GDX270115C00100000	call	100.0000	2027-01-15	13.9500	13.9500	14.3000	102.6300	13950.00	0.00	13950.00	10	5	2151	16522	0.130190049630795	0.467888881789953	0.467888881789953	false	false	false	true
e72d81c6-b869-46ef-8f25-43935942ec0a	2026-08-24 13:54	2026-08-24 13:53	2026-08-24 13:53	GDX	GDX260918C00135000	call	135.0000	2026-09-18	0.3100	0.3000	0.3400	102.6900	37107.00	0.00	34224.00	1197	11	1407	2179	0.645709040844424	0.597640175336539	0.597640175336539	false	false	false	true
7c14fdd4-505f-4008-bc7a-1b1c2fc90a0b	2026-08-24 13:38	2026-08-24 13:38	2026-08-24 13:38	GDX	GDX260925C00108000	call	108.0000	2026-09-25	4.2000	4.1500	4.2000	102.6900	12600.00	420.00	0.00	30	18	84	56	1.5	0.513502976513236	0.513502976513236	false	false	false	true
a9bd520a-29c2-4024-a194-b000050cc5ae	2026-08-24 13:27	2026-08-24 13:27	2026-08-24 13:27	GDX	GDX260925C00108000	call	108.0000	2026-09-25	4.2000	4.0500	4.2000	102.6100	10500.00	10500.00	0.00	25	18	54	56	0.964285714285714	0.516263780401128	0.516263780401128	false	false	false	true