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 = RepeatedHitsDescendingFill×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

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	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	ETF	—	684331200.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-20T19:59:19.634890Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
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
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	true
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	true
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	true
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	true
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	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
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
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
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
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
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
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