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:endpoint = /api/option-trades/flow-alerts×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	expiry

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
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
19ccd70d-b68d-4879-bf72-12d52bca7808	2026-08-19 09:35	2026-08-19 09:35	2026-08-19 09:35	MAGS	MAGS260918C00068000	call	68.0000	2026-09-18	1.2000	1.2000	1.3000	66.9400	143660.00	0.00	143660.00	1197	27	1197	1839	0.65089722675367	0.206212702012354	0.206212702012354	false	false	false
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
78051645-9d44-468c-84f5-867c1c278963	2026-08-20 15:47	2026-08-20 15:47	2026-08-20 15:47	MAGS	MAGS261016P00065000	put	65.0000	2026-10-16	1.5800	1.4000	1.6000	66.9150	47451.00	47451.00	0.00	300	25	306	0	0	0.249868772727316	0.247810920795743	false	false	false
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
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
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
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
44935ea9-3ccb-48c2-94e8-06e6c6d765bc	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.2000	0.3000	67.5500	31277.00	950.00	30327.00	1251	43	2748	5685	0.483377308707124	0.196365599119338	0.196365599119338	false	false	false
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
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
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
50a9e895-eeab-4906-bff7-8b008c63dbd4	2026-08-21 11:58	2026-08-21 11:57	2026-08-21 11:57	MAGS	MAGS260918C00074000	call	74.0000	2026-09-18	0.0500	0.0500	0.2000	67.5050	15602.00	0.00	15602.00	3120	10	3668	8821	0.415825870082757	0.190250025598974	0.190250025598974	false	false	false
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
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
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
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
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
88a65111-6463-4bdb-914d-8197cf71df66	2026-08-28 11:05	2026-08-28 11:05	2026-08-28 11:05	MAGS	MAGS260918C00070500	call	70.5000	2026-09-18	1.0500	0.1500	1.0500	69.7864	209980.00	209980.00	0.00	2000	67	2000	5	400	0.195581756432552	0.195581756432552	true	false	false
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
d805b739-d5e9-4e1a-91e7-951778e0baf2	2026-08-28 11:16	2026-08-28 11:16	2026-08-28 11:16	MAGS	MAGS260918C00070000	call	70.0000	2026-09-18	1.1200	0.9500	1.2500	69.6300	10046.00	10046.00	0.00	90	5	305	7840	0.0389030612244898	0.183711270604755	0.183711270604755	false	false	false
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
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
6fe350c8-53a8-497d-855a-505d619198af	2026-08-28 12:00	2026-08-28 12:00	2026-08-28 12:00	MAGS	MAGS270115C00069000	call	69.0000	2027-01-15	4.4400	3.6000	4.9000	69.0000	22220.00	22220.00	0.00	50	6	50	186	0.268817204301075	0.225460326288704	0.225460326288704	false	false	false
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
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
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
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
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
73475a51-55dc-4a00-8dc4-a53918575f2c	2026-09-03 09:59	2026-09-03 09:59	2026-09-03 09:59	MAGS	MAGS261218P00065000	put	65.0000	2026-12-18	1.4900	1.4000	1.5000	70.2750	14905.00	14905.00	0.00	100	6	352	1484	0.237196765498652	0.261305828731538	0.260455201396887	false	false	false
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
d7faa4c0-1553-4959-a759-95e64a24616c	2026-09-03 11:39	2026-09-03 11:39	2026-09-03 11:39	MAGS	MAGS261218P00065000	put	65.0000	2026-12-18	1.3900	1.3500	1.4000	70.7400	13941.00	13941.00	0.00	100	10	471	1484	0.317385444743935	0.262012266006208	0.261138793291111	false	false	false
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
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
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
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
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
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
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
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
937acc26-cfc3-4d80-891f-5826235477d9	2026-09-11 09:39	2026-09-11 09:39	2026-09-11 09:39	MAGS	MAGS270115C00073000	call	73.0000	2027-01-15	2.6900	2.2000	2.9000	70.2262	10760.00	10760.00	0.00	40	13	40	75	0.533333333333333	0.211241577452233	0.211241577452233	false	false	false
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
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
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
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
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
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
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