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 = RepeatedHits×ticker = MAGS×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

e085bbf5-06aa-48f5-8d8a-9ec443adf20d	2026-08-18 14:05	2026-08-18 14:04	2026-08-18 14:04	MAGS	MAGS260918P00065000	put	65.0000	2026-09-18	0.9000	0.8500	0.9500	66.9250	13140.00	11070.00	0.00	146	23	165	1450	0.113793103448276	0.230732099344403	0.230732099344403	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	684331200.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-18T18:16:58.911276Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
359da7de-4815-4c8c-89a1-792f8e9b779d	2026-08-18 14:16	2026-08-18 14:16	2026-08-18 14:16	MAGS	MAGS260918P00065000	put	65.0000	2026-09-18	0.9000	0.8500	0.9000	66.9599	10980.00	10980.00	0.00	122	25	288	1450	0.198620689655172	0.232281663024386	0.232281663024386	false	false	false	true
7df65052-63d6-41df-ad72-788d34f76fbb	2026-08-18 15:50	2026-08-18 15:49	2026-08-18 15:49	MAGS	MAGS260918P00069000	put	69.0000	2026-09-18	2.7500	2.7500	2.8000	66.0000	43176.00	0.00	43176.00	157	26	177	149	1.18791946308725	0.204259728356186	0.204259728356186	false	false	false	true
ed94c223-0c7b-42e0-862c-6b5a30dc64a4	2026-08-19 15:16	2026-08-19 15:16	2026-08-19 15:16	MAGS	MAGS260918C00070000	call	70.0000	2026-09-18	0.7500	0.7000	0.8000	67.6450	138825.00	75.00	66450.00	1851	17	1919	8918	0.215182776407266	0.203170006998181	0.203170006998181	false	false	false	true
10e55439-819d-4f87-bbf8-6db6d6bf5b1a	2026-08-21 10:09	2026-08-21 10:09	2026-08-21 10:09	MAGS	MAGS261218C00069000	call	69.0000	2026-12-18	3.7700	2.6000	3.8000	67.2050	18870.00	18870.00	0.00	50	5	50	32	1.5625	0.275857863103008	0.269325287585785	false	false	false	true
17685a63-5d65-404c-baf2-6409296896c5	2026-08-21 10:11	2026-08-21 10:11	2026-08-21 10:11	MAGS	MAGS261218C00070000	call	70.0000	2026-12-18	2.9500	2.6500	2.9500	67.2234	14750.00	14750.00	0.00	50	8	151	1414	0.106789250353607	0.246451048456066	0.246451048456066	false	false	false	true
09e3c92b-b42c-4b95-bde4-1567bde34dce	2026-08-21 10:20	2026-08-21 10:19	2026-08-21 10:19	MAGS	MAGS261218C00070000	call	70.0000	2026-12-18	2.9000	2.6500	2.9000	67.1700	14500.00	11600.00	0.00	50	5	202	1414	0.142857142857143	0.244732137556029	0.244732137556029	false	false	false	true
46fb97d3-2017-4465-9a42-a9b43de6da52	2026-08-21 11:57	2026-08-21 11:57	2026-08-21 11:57	MAGS	MAGS260918C00072000	call	72.0000	2026-09-18	0.2500	0.2500	0.3000	67.5500	24551.00	0.00	24551.00	982	45	1497	5685	0.263324538258575	0.196365599119338	0.196365599119338	false	false	false	true
1a2e2dba-45d9-41c8-b28a-9c456ff70922	2026-08-21 11:57	2026-08-21 11:57	2026-08-21 11:57	MAGS	MAGS260918C00072000	call	72.0000	2026-09-18	0.2000	0.2000	0.2500	67.5500	15580.00	0.00	15580.00	779	35	3673	5685	0.64608619173263	0.183668275287819	0.183668275287819	false	false	false	true
37f1498e-026f-4b9c-98be-7967be39ceb2	2026-08-21 11:57	2026-08-21 11:57	2026-08-21 11:57	MAGS	MAGS260918C00073000	call	73.0000	2026-09-18	0.1500	0.1000	0.2500	67.5250	34697.00	0.00	34697.00	2313	34	3415	9104	0.375109841827768	0.197663628687	0.197663628687	false	false	false	true
0e70ed88-9059-4345-9f0e-c935efa71c75	2026-08-21 11:57	2026-08-21 11:57	2026-08-21 11:57	MAGS	MAGS260918C00073000	call	73.0000	2026-09-18	0.1000	0.1000	0.2500	67.5150	35870.00	0.00	35870.00	3587	24	7002	9104	0.769112478031634	0.179804790572497	0.179804790572497	false	false	false	true
68ddad88-19c8-413d-be3a-23e9a571d8c7	2026-08-21 11:58	2026-08-21 11:58	2026-08-21 11:58	MAGS	MAGS260918C00074000	call	74.0000	2026-09-18	0.0500	0.0500	0.1000	67.5050	16890.00	0.00	16890.00	3378	9	7047	8821	0.798889014850924	0.178561426028122	0.178561426028122	false	false	false	true
fec69c16-bbd6-44e2-8b2e-6ca4ba34860f	2026-08-21 14:07	2026-08-21 14:07	2026-08-21 14:07	MAGS	MAGS260918P00065000	put	65.0000	2026-09-18	0.7500	0.7000	0.7500	67.0000	14175.00	14175.00	0.00	189	19	189	1785	0.105882352941176	0.234364505628584	0.234364505628584	false	false	false	true
692f1294-095e-44be-a66f-051567950792	2026-08-24 15:46	2026-08-24 15:46	2026-08-24 15:46	MAGS	MAGS260918C00072000	call	72.0000	2026-09-18	0.2000	0.1500	0.2500	67.2550	80120.00	0.00	80080.00	4006	6	4033	4584	0.879799301919721	0.205062277374761	0.205062277374761	false	false	false	true
7356b828-e5dc-4ae5-87bc-a23ea5d226c0	2026-08-25 10:18	2026-08-25 10:18	2026-08-25 10:18	MAGS	MAGS261218C00069000	call	69.0000	2026-12-18	3.1000	3.1000	3.7000	67.4650	18610.00	0.00	18290.00	60	9	62	93	0.666666666666667	0.226369425390067	0.226369425390067	false	false	false	true
61d9cbbb-04d0-4a9c-9aca-8f71c444676b	2026-08-28 10:47	2026-08-28 10:47	2026-08-28 10:47	MAGS	MAGS260828C00069000	call	69.0000	2026-08-28	0.4500	0.4000	0.5000	69.4176	18540.00	18000.00	0.00	412	5	572	313	1.82747603833866	0.238277821412905	0.238277821412905	false	false	false	true
44daa174-c3f6-4260-96d1-5ab5f14302a1	2026-08-28 11:09	2026-08-28 11:09	2026-08-28 11:09	MAGS	MAGS260918C00070500	call	70.5000	2026-09-18	0.9500	0.8500	1.0000	69.6650	10545.00	570.00	570.00	111	17	2126	5	425.2	0.188361744473767	0.188361744473767	false	false	false	true
c27661c6-4938-4c1f-bab4-979d17838b1e	2026-08-28 11:18	2026-08-28 11:18	2026-08-28 11:18	MAGS	MAGS261218C00070000	call	70.0000	2026-12-18	3.8000	3.8000	4.0000	69.5550	15200.00	0.00	15200.00	40	8	63	1729	0.0364372469635627	0.235077341839086	0.235077341839086	false	false	false	true
32407a5c-8316-4b54-ae08-be8035996240	2026-08-28 11:51	2026-08-28 11:51	2026-08-28 11:51	MAGS	MAGS260918C00070500	call	70.5000	2026-09-18	0.8000	0.7000	0.8000	69.0000	228080.00	228080.00	0.00	2851	21	5455	5	1091	0.187184172586214	0.187184172586214	false	false	false	true
aece63a6-5751-4f10-aee2-0068590e3a5f	2026-08-31 11:54	2026-08-31 11:54	2026-08-31 11:54	MAGS	MAGS260904C00068000	call	68.0000	2026-09-04	1.1000	0.9000	1.1000	68.7695	11000.00	11000.00	0.00	100	5	100	86	1.16279069767442	0.217640607036499	0.217640607036499	false	false	false	true
4bba169c-0766-474e-8689-ef57e0d00101	2026-09-01 11:08	2026-09-01 11:07	2026-09-01 11:07	MAGS	MAGS261016C00065000	call	65.0000	2026-10-16	4.3000	4.3000	4.6000	68.1900	11180.00	0.00	11180.00	26	6	26	18	1.44444444444444	0.226026032753088	0.226026032753088	false	false	false	true
b4d3b938-3c94-48b3-840f-c4ad5d78a222	2026-09-03 09:48	2026-09-03 09:48	2026-09-03 09:48	MAGS	MAGS260918C00072000	call	72.0000	2026-09-18	0.5500	0.4000	0.5500	70.5200	269445.00	269445.00	0.00	4899	19	5108	8657	0.590042739979208	0.191224554576746	0.191224554576746	false	false	false	true
42b1fc3c-5057-4564-b4ac-124c8453dbb9	2026-09-03 09:48	2026-09-03 09:48	2026-09-03 09:48	MAGS	MAGS260918C00072000	call	72.0000	2026-09-18	0.5500	0.4000	0.6000	70.5200	11000.00	8250.00	2750.00	200	9	209	8657	0.0241423125794155	0.191224554576746	0.191224554576746	false	false	false	true
ba1c7d57-7660-40ff-b9fb-ddc3218bb842	2026-09-03 09:54	2026-09-03 09:54	2026-09-03 09:54	MAGS	MAGS261218P00065000	put	65.0000	2026-12-18	1.5000	1.4000	1.5000	70.3897	37500.00	37500.00	0.00	250	21	252	1484	0.169811320754717	0.26363613563363	0.26363613563363	false	false	false	true
590ee94e-e94d-48e7-b08e-fbaa54046400	2026-09-03 10:20	2026-09-03 10:20	2026-09-03 10:20	MAGS	MAGS260918C00070500	call	70.5000	2026-09-18	1.1000	1.1000	1.2500	70.4300	11220.00	0.00	11220.00	102	7	163	5526	0.0294969236337315	0.189576066828033	0.189576066828033	false	false	false	true
427dfe64-aa54-44a4-a917-eaea7b79b07f	2026-09-03 11:41	2026-09-03 11:41	2026-09-03 11:41	MAGS	MAGS260918C00070000	call	70.0000	2026-09-18	1.5500	1.5500	1.6000	70.6750	155000.00	0.00	155000.00	1000	13	2513	7959	0.315743183817062	0.195950065479392	0.195950065479392	false	false	false	true
46945ff6-5ead-4e09-beb7-8f103686a14f	2026-09-03 12:01	2026-09-03 12:01	2026-09-03 12:01	MAGS	MAGS260918C00071000	call	71.0000	2026-09-18	1.0500	1.0000	1.0500	70.7598	10500.00	10500.00	0.00	100	14	105	5209	0.0201574198502592	0.194342226269374	0.194342226269374	true	false	false	true
f570129b-1776-4472-9133-e5a87b9d54bc	2026-09-03 12:13	2026-09-03 12:13	2026-09-03 12:13	MAGS	MAGS261218P00065000	put	65.0000	2026-12-18	1.4000	1.3500	1.4000	70.7100	14000.00	14000.00	0.00	100	21	574	1484	0.386792452830189	0.26142051640931	0.26142051640931	false	false	false	true
1d6982bc-657c-4582-a082-c54a4067b9fb	2026-09-03 12:42	2026-09-03 12:41	2026-09-03 12:41	MAGS	MAGS261016C00073000	call	73.0000	2026-10-16	1.0500	1.0000	1.0500	70.6200	12390.00	12390.00	0.00	118	26	761	13	58.5384615384615	0.193771605991509	0.193771605991509	true	false	false	true
09474e1c-b008-44ec-b6bd-a7023cdcaccf	2026-09-03 14:26	2026-09-03 14:26	2026-09-03 14:26	MAGS	MAGS260918C00070000	call	70.0000	2026-09-18	1.5500	1.5500	1.6500	70.7800	62002.00	0.00	62002.00	400	42	4060	7959	0.510114335971856	0.183761012619906	0.183761012619906	true	false	false	true
ce5d3ccf-d2f0-4fff-ac8f-fa5380a5ac51	2026-09-08 13:07	2026-09-08 13:07	2026-09-08 13:07	MAGS	MAGS261218C00070000	call	70.0000	2026-12-18	3.5000	3.4000	3.7000	69.3450	59500.00	35700.00	5950.00	170	6	170	1734	0.0980392156862745	0.236867490530028	0.236867490530028	false	false	false	true
abacaba6-5c95-4139-b3c0-43c932793939	2026-09-09 09:47	2026-09-09 09:46	2026-09-09 09:46	MAGS	MAGS261002C00069000	call	69.0000	2026-10-02	1.8000	1.6500	1.9000	69.4000	329580.00	1980.00	327600.00	1831	16	1831	30	61.0333333333333	0.21678672506232	0.21678672506232	false	false	false	true
afb499d6-e50f-4de4-a8a1-2136625e8194	2026-09-11 09:38	2026-09-11 09:38	2026-09-11 09:38	MAGS	MAGS261016C00070000	call	70.0000	2026-10-16	2.1500	2.0500	2.1500	70.2100	255635.00	255635.00	0.00	1189	7	1243	1086	1.14456721915285	0.219976142845602	0.219976142845602	false	false	false	true
8a103a58-2619-449a-b3cf-bd9bc1d7e51c	2026-09-11 09:53	2026-09-11 09:53	2026-09-11 09:53	MAGS	MAGS261009C00071000	call	71.0000	2026-10-09	1.3500	1.0500	1.3500	70.0000	27000.00	27000.00	0.00	200	6	200	5	40	0.217353936618303	0.217353936618303	false	false	false	true
068dc490-1b01-487b-9169-801d2099a39e	2026-09-11 10:38	2026-09-11 10:37	2026-09-11 10:37	MAGS	MAGS261218C00071000	call	71.0000	2026-12-18	3.3000	3.2000	3.3000	70.0600	37950.00	37950.00	0.00	115	23	247	923	0.267605633802817	0.233243980309001	0.233243980309001	false	false	false	true
9354716f-41a8-4e4b-b781-bf8936498d71	2026-09-14 09:36	2026-09-14 09:36	2026-09-14 09:36	MAGS	MAGS260918C00071000	call	71.0000	2026-09-18	0.1500	0.1500	0.4000	69.5600	11280.00	0.00	11280.00	752	28	768	5402	0.142169566827101	0.20927441405097	0.20927441405097	false	false	false	true
7be4dd8a-068b-4e7c-9856-aba99aedd92a	2026-09-14 10:27	2026-09-14 10:27	2026-09-14 10:27	MAGS	MAGS260918C00071000	call	71.0000	2026-09-18	0.1000	0.1000	0.2000	69.4500	67480.00	0.00	67480.00	6748	31	7551	5402	1.39781562384302	0.191267869047569	0.191267869047569	false	false	false	true
623ea944-91e5-4133-9e5a-a354f874801e	2026-09-14 11:24	2026-09-14 11:24	2026-09-14 11:24	MAGS	MAGS260918C00071000	call	71.0000	2026-09-18	0.2000	0.2000	0.2500	69.8300	178900.00	0.00	178900.00	8945	27	16661	5402	3.08422806368012	0.206597379576188	0.206597379576188	false	false	false	true
7a89d18b-46a4-46c7-828a-0b48da49bcba	2026-09-14 11:45	2026-09-14 11:45	2026-09-14 11:45	MAGS	MAGS261016C00072000	call	72.0000	2026-10-16	1.0000	0.8500	1.0000	70.1500	203500.00	124000.00	0.00	2035	30	2040	212	9.62264150943396	0.201196772486553	0.201196772486553	false	false	false	true
dfc1a1ec-8f01-4296-a055-5fb98dd9c851	2026-09-14 11:50	2026-09-14 11:50	2026-09-14 11:50	MAGS	MAGS261016C00072000	call	72.0000	2026-10-16	1.0000	0.9000	1.0000	70.1399	10900.00	10900.00	0.00	109	8	2151	212	10.1462264150943	0.201666411703067	0.201666411703067	true	false	false	true
efc1d72b-c636-4463-950a-71eb21d8b8d4	2026-09-14 12:37	2026-09-14 12:37	2026-09-14 12:37	MAGS	MAGS260918C00071000	call	71.0000	2026-09-18	0.3000	0.2500	0.3500	70.1600	51240.00	0.00	51210.00	1708	8	19600	5402	3.62828582006664	0.211484857983502	0.211484857983502	false	false	false	true
326ca9c4-f270-4a39-9c8c-6aa856547b69	2026-09-14 13:33	2026-09-14 13:33	2026-09-14 13:33	MAGS	MAGS261016C00072000	call	72.0000	2026-10-16	1.1000	1.0500	1.1500	70.4200	220000.00	137830.00	2860.00	2000	47	4170	212	19.6698113207547	0.201058841149303	0.201058841149303	false	false	false	true
01a63de1-0a68-4756-b1b3-6be318903ab2	2026-09-14 14:01	2026-09-14 14:01	2026-09-14 14:01	MAGS	MAGS261016C00072000	call	72.0000	2026-10-16	1.1000	1.1000	1.2000	70.4600	66770.00	0.00	66770.00	607	23	4777	212	22.5330188679245	0.199117260803363	0.199117260803363	false	false	false	true
68a0dc85-21e2-4360-b7c0-a983ad8f27ca	2026-09-14 14:13	2026-09-14 14:13	2026-09-14 14:13	MAGS	MAGS261218P00070000	put	70.0000	2026-12-18	2.9000	2.6000	3.0000	70.4350	36830.00	14500.00	22330.00	127	7	146	129	1.13178294573643	0.240750737557256	0.240750737557256	false	false	false	true
eeb4a82b-6f3f-465e-91b4-92d18ba80f44	2026-09-14 14:14	2026-09-14 14:14	2026-09-14 14:14	MAGS	MAGS261218P00070000	put	70.0000	2026-12-18	2.9500	2.7500	3.1000	70.4250	132750.00	116820.00	15930.00	450	13	920	129	7.13178294573643	0.243999464942517	0.243999464942517	false	false	false	true
696dd413-b676-44f1-a829-622673755060	2026-09-14 14:17	2026-09-14 14:17	2026-09-14 14:17	MAGS	MAGS261016C00072000	call	72.0000	2026-10-16	1.1000	1.1000	1.2000	70.3950	18590.00	0.00	18590.00	169	10	4946	212	23.3301886792453	0.2022686002758	0.2022686002758	false	false	false	true
d71d466e-b2e7-4ed7-96b6-225e99b7d9c7	2026-09-14 14:17	2026-09-14 14:17	2026-09-14 14:17	MAGS	MAGS261016C00072000	call	72.0000	2026-10-16	1.1000	1.1000	1.1500	70.3600	11660.00	0.00	11660.00	106	5	5101	212	24.061320754717	0.203716604542385	0.203957550630072	false	false	false	true
93726e36-1c8d-42f7-a14a-9d17f4b16de1	2026-09-14 14:17	2026-09-14 14:17	2026-09-14 14:17	MAGS	MAGS261016C00072000	call	72.0000	2026-10-16	1.1000	0.8000	1.1500	70.3600	11440.00	8580.00	2860.00	104	6	5205	212	24.5518867924528	0.203957550630072	0.203957550630072	false	false	false	true
b2e11d6c-29f1-424b-9e57-a780e21bf026	2026-09-14 14:51	2026-09-14 14:51	2026-09-14 14:51	MAGS	MAGS261009C00066000	call	66.0000	2026-10-09	4.8000	4.8000	5.0000	70.3200	15842.00	0.00	15842.00	33	13	42	6	7	0.235216925524904	0.235216925524904	true	false	false	true
809816d2-42b5-4eb9-84c7-92a2dce814c9	2026-09-15 13:28	2026-09-15 13:28	2026-09-15 13:28	MAGS	MAGS261023C00067500	call	67.5000	2026-10-23	3.4000	3.4000	3.5000	69.5300	70040.00	0.00	70040.00	206	19	208	2	104	0.231504415549623	0.231504415549623	true	false	false	true