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:source = uw_flow_alerts×ticker = MAGS×

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

46c98841-824f-4c8f-a1c0-1f5336a1bc74	2026-09-22 15:55	2026-09-22 15:55	2026-09-22 15:55	MAGS	MAGS261218C00068000	call	68.0000	2026-12-18	6.8000	6.8000	7.2000	72.0000	10200.00	0.00	10200.00	15	11	432	2084	0.207293666026871	0.254934397850272	0.254934397850272	true	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	684331200.00	—	—	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-22T19:55:34.426688Z"}	2026-09-22	2026-09-22 21:15	2026-09-22 21:15
d09d27c7-ddd6-4071-a96b-cbe623ac9973	2026-09-22 13:53	2026-09-22 13:53	2026-09-22 13:53	MAGS	MAGS261218C00072000	call	72.0000	2026-12-18	4.0600	4.0000	4.4000	72.8330	20281.00	0.00	17446.00	50	5	65	230	0.282608695652174	0.229451773687287	0.230178580531825	false	false	false	true
94b66735-cfe7-4622-97a1-eaa1db8cc3e8	2026-09-22 13:49	2026-09-22 13:48	2026-09-22 13:48	MAGS	MAGS261120P00073000	put	73.0000	2026-11-20	2.5500	2.4500	2.6000	72.7300	612488.00	612233.00	255.00	2402	25	2424	0	0	0.227985294090824	0.227985294090824	false	false	false	true
07eee62d-fd24-46c3-9159-b187722987cd	2026-09-22 13:11	2026-09-22 13:11	2026-09-22 13:11	MAGS	MAGS261016P00073500	put	73.5000	2026-10-16	1.7000	1.5500	1.7000	72.8000	375360.00	375360.00	0.00	2208	20	2215	0	0	0.191525964834052	0.191525964834052	false	false	false	true
0e082958-4608-4d29-89a7-f5b721aa2c24	2026-09-22 10:12	2026-09-22 10:12	2026-09-22 10:12	MAGS	MAGS261002C00073000	call	73.0000	2026-10-02	1.1000	1.0000	1.2000	73.1300	27500.00	22770.00	0.00	250	8	270	34	7.94117647058824	0.205711017447392	0.205711017447392	false	false	false	true
c42f6f44-b1d6-4b93-af18-eb70f2d8abaa	2026-09-22 09:56	2026-09-22 09:55	2026-09-22 09:55	MAGS	MAGS261016C00072000	call	72.0000	2026-10-16	2.1000	2.1000	2.5000	73.0020	210000.00	0.00	210000.00	1000	2	1010	5675	0.177973568281938	0.19270867364896	0.19270867364896	false	true	true	false
03a8d582-6bd5-4fea-9539-3334c5de29aa	2026-09-22 09:30	2026-09-22 09:30	2026-09-22 09:30	MAGS	MAGS261218P00071000	put	71.0000	2026-12-18	2.2500	1.6000	3.8000	72.9600	13275.00	8550.00	450.00	59	6	59	87	0.67816091954023	0.245126975164023	0.245126975164023	false	false	false	true
63618fe7-5027-4d03-b80b-40bb34baafcc	2026-09-21 15:14	2026-09-21 15:14	2026-09-21 15:14	MAGS	MAGS261016C00073000	call	73.0000	2026-10-16	1.6500	1.5500	1.6500	72.9500	24750.00	24750.00	0.00	150	6	1031	4556	0.226294995610184	0.20699229652876	0.20699229652876	false	false	false	true
0003fcff-6762-41d7-afd5-7d43302aa2aa	2026-09-21 14:54	2026-09-21 14:54	2026-09-21 14:54	MAGS	MAGS261002C00071000	call	71.0000	2026-10-02	2.3000	2.1000	2.3000	72.9550	22080.00	22080.00	0.00	96	41	145	169	0.857988165680473	0.191096101523404	0.191096101523404	true	false	false	true
e7db75ae-c7c9-4944-a5d2-a76faeea814f	2026-09-21 14:19	2026-09-21 14:19	2026-09-21 14:19	MAGS	MAGS261016C00071000	call	71.0000	2026-10-16	2.7000	2.7000	2.8500	72.8000	27000.00	0.00	27000.00	100	9	333	901	0.369589345172031	0.199768391207174	0.199768391207174	false	false	false	true
129f377c-923f-4413-be93-46d4eddb219c	2026-09-21 12:49	2026-09-21 12:48	2026-09-21 12:48	MAGS	MAGS261218C00068000	call	68.0000	2026-12-18	6.7100	6.5000	6.8000	72.4800	335416.00	335416.00	0.00	500	5	517	1626	0.317958179581796	0.258049005100005	0.258049005100005	false	false	false	true
ad981f75-d93b-4a7a-b36a-da9bfa4837f4	2026-09-21 12:42	2026-09-21 12:41	2026-09-21 12:41	MAGS	MAGS261016C00070000	call	70.0000	2026-10-16	3.2000	3.2000	3.4000	72.4439	36480.00	0.00	36480.00	114	7	371	3809	0.0974008926227356	0.207046812500152	0.207046812500152	true	false	false	true
58d898f4-d4bb-4706-86ee-8f5bcbd823fc	2026-09-21 12:12	2026-09-21 12:11	2026-09-21 12:11	MAGS	MAGS260925C00072500	call	72.5000	2026-09-25	0.5500	0.4500	0.5500	72.3100	30085.00	30085.00	0.00	547	26	589	16	36.8125	0.207083380676658	0.207083380676658	false	false	false	true
92e096c8-8bfd-4786-b035-d4064db422b8	2026-09-21 11:56	2026-09-21 11:56	2026-09-21 11:56	MAGS	MAGS270115P00067000	put	67.0000	2027-01-15	1.8300	1.8000	1.9000	72.1800	26200.00	0.00	3495.00	143	38	308	82	3.75609756097561	0.271104792075034	0.26728678572092	false	false	false	true
fac7981f-1975-40ae-b5c3-3e30ee887bed	2026-09-21 11:56	2026-09-21 11:56	2026-09-21 11:56	MAGS	MAGS270115P00067000	put	67.0000	2027-01-15	1.7200	1.5000	2.1500	72.1800	18450.00	350.00	9700.00	107	31	107	82	1.30487804878049	0.263450418099201	0.259594667108821	false	false	false	true
df089782-efaa-463d-85cd-3f420aa0dc9a	2026-09-21 11:43	2026-09-21 11:43	2026-09-21 11:43	MAGS	MAGS261016C00071000	call	71.0000	2026-10-16	2.2000	1.9500	2.2000	72.0700	26620.00	26620.00	0.00	121	8	164	901	0.182019977802442	0.198974251237893	0.198974251237893	false	false	false	true
6b60267c-bd2c-40ff-86d8-694312f5d226	2026-09-18 13:05	2026-09-18 13:05	2026-09-18 13:05	MAGS	MAGS261016C00072000	call	72.0000	2026-10-16	0.8500	0.8500	0.9500	70.4250	85098.00	0.00	85098.00	1000	42	1010	6639	0.152131345082091	0.184348506028008	0.181615046882983	false	false	false	true
8cbd60a3-5bd0-49ad-82f4-b77d73db2867	2026-09-18 10:58	2026-09-18 10:58	2026-09-18 10:58	MAGS	MAGS261120P00069000	put	69.0000	2026-11-20	1.7500	1.6000	1.9000	70.6700	10850.00	0.00	10675.00	62	19	103	6	17.1666666666667	0.233582446755698	0.233582446755698	true	false	false	true
76e64f3e-a697-4d79-83d3-6aca348e17cc	2026-09-17 15:42	2026-09-17 15:42	2026-09-17 15:42	MAGS	MAGS261120C00072000	call	72.0000	2026-11-20	2.2900	2.0500	2.4500	70.6850	22932.00	22932.00	0.00	100	8	106	0	0	0.222249235294693	0.222249235294693	false	false	false	true
3b5c7b74-f950-4301-951f-77e4533c21ce	2026-09-17 11:05	2026-09-17 11:05	2026-09-17 11:05	MAGS	MAGS270115C00070000	call	70.0000	2027-01-15	4.2000	4.1000	4.2000	70.3600	545160.00	545160.00	0.00	1298	20	1302	2095	0.621479713603819	0.219397825388074	0.219397825388074	false	false	false	true
165218b5-1a58-46cf-9046-a80fa44a8b2d	2026-09-17 09:41	2026-09-17 09:40	2026-09-17 09:40	MAGS	MAGS261009C00070000	call	70.0000	2026-10-09	1.6300	1.6000	1.8500	70.3180	39132.00	0.00	39132.00	240	5	540	585	0.923076923076923	0.201679039575544	0.201679039575544	false	false	false	true
6649761a-e76c-43ba-a4c6-8e955f413e7b	2026-09-17 09:36	2026-09-17 09:36	2026-09-17 09:36	MAGS	MAGS261009C00070000	call	70.0000	2026-10-09	1.6800	1.6500	1.8500	70.3800	33520.00	0.00	33520.00	200	9	200	585	0.341880341880342	0.205326285383081	0.205326285383081	false	false	false	true
7450322f-53a3-4e06-8964-946af45fe4ba	2026-09-16 15:12	2026-09-16 15:12	2026-09-16 15:12	MAGS	MAGS260918P00069000	put	69.0000	2026-09-18	0.4000	0.3500	0.4000	69.3350	15720.00	15720.00	0.00	393	25	446	360	1.23888888888889	0.272996817068747	0.272996817068747	false	false	false	true
5bda7240-42c6-4b4e-be7e-f4637d4d9187	2026-09-16 14:57	2026-09-16 14:57	2026-09-16 14:57	MAGS	MAGS261002C00070000	call	70.0000	2026-10-02	1.0600	1.0500	1.3000	69.5950	26511.00	0.00	26511.00	250	21	545	156	3.49358974358974	0.203767319739904	0.203767319739904	false	false	false	true
77f26882-9118-4e1d-8d2a-ce2a391b479d	2026-09-16 11:50	2026-09-16 11:49	2026-09-16 11:49	MAGS	MAGS261030C00071500	call	71.5000	2026-10-30	1.6500	1.5500	1.7000	70.1100	15343.00	15343.00	0.00	93	11	98	1	98	0.217786470387249	0.217786470387249	true	false	false	true
176825af-2383-424e-8bb5-555be06dce67	2026-09-16 11:23	2026-09-16 11:23	2026-09-16 11:23	MAGS	MAGS261030C00066500	call	66.5000	2026-10-30	4.8000	4.8000	5.0000	70.0799	13441.00	0.00	13441.00	28	8	29	7	4.14285714285714	0.24911901372948	0.24911901372948	true	false	false	true
b6f48c4a-bc9d-4988-a369-9b8acc55c3b7	2026-09-16 10:09	2026-09-16 10:09	2026-09-16 10:09	MAGS	MAGS261016C00070000	call	70.0000	2026-10-16	1.8500	1.8000	1.8500	70.0350	113588.00	113588.00	0.00	614	32	677	2445	0.276891615541922	0.213468458953881	0.214722111011957	false	false	false	true
6a757410-7b58-4938-8cbc-b8510dc01b5d	2026-09-15 15:43	2026-09-15 15:43	2026-09-15 15:43	MAGS	MAGS261030P00072000	put	72.0000	2026-10-30	3.5000	2.8000	3.5000	69.4250	12600.00	12600.00	0.00	36	9	36	0	0	0.222402681506729	0.222402681506729	true	false	false	true
70e280e1-c751-447b-b1ff-02948ab4083a	2026-09-15 15:20	2026-09-15 15:20	2026-09-15 15:20	MAGS	MAGS261218C00070000	call	70.0000	2026-12-18	3.6000	3.4000	3.6000	69.5700	31680.00	31680.00	0.00	88	9	206	1740	0.118390804597701	0.247970173468673	0.247970173468673	false	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
709fe7cc-c62f-4c5f-a272-4015772f7ea2	2026-09-15 12:08	2026-09-15 12:08	2026-09-15 12:08	MAGS	MAGS261016P00062000	put	62.0000	2026-10-16	0.2500	0.2000	0.2500	69.7150	10160.00	10160.00	0.00	407	37	412	1014	0.406311637080868	0.309573458687089	0.309573458687089	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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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	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
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