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:ticker = AS×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	pricenumeric

5baa5572-c098-47e0-9c47-1bad8ef663c4	2026-08-27 14:37	2026-08-27 14:37	2026-08-27 14:37	AS	AS260918C00031000	call	31.0000	2026-09-18	1.1500	1.1000	1.1500	30.3400	19205.00	19205.00	0.00	167	10	585	0	0	0.475334001379845	0.475334001379845	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Consumer Cyclical	15363736512.00	2026-11-17	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-27T18:43:44.836810Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
421e398f-39a9-4331-a49d-220e448fa5c0	2026-08-27 14:37	2026-08-27 14:37	2026-08-27 14:37	AS	AS260918C00030000	call	30.0000	2026-09-18	1.6000	1.5500	1.6000	30.3600	17120.00	17120.00	0.00	107	15	1170	14886	0.0785973397823458	0.469946104310785	0.466044648734734	false	false	false	true	false
b99af803-9f70-44ba-bb82-f70a1a9205b3	2026-08-27 14:40	2026-08-27 14:40	2026-08-27 14:40	AS	AS260918P00030000	put	30.0000	2026-09-18	1.1000	1.1000	1.2000	30.3500	12433.00	0.00	12433.00	113	27	178	7147	0.0249055547782286	0.440053631166955	0.440053631166955	false	false	false	true	false
cc4c908a-5d9f-458b-ad2d-81f4f0f1d2a7	2026-08-27 15:03	2026-08-27 15:03	2026-08-27 15:03	AS	AS260918C00032500	call	32.5000	2026-09-18	0.7500	0.6500	0.7500	30.4800	19650.00	19650.00	0.00	262	6	916	22979	0.0398624831367771	0.497183353155248	0.497183353155248	false	false	false	true	false
59f7aa8b-a75d-4e27-98ea-25d2eab88804	2026-08-27 15:33	2026-08-27 15:33	2026-08-27 15:33	AS	AS260918C00030500	call	30.5000	2026-09-18	1.5500	1.4000	1.5500	30.0000	19529.00	19529.00	0.00	126	34	547	0	0	0.490950851977555	0.490950851977555	true	false	false	true	false
f154938c-e48e-4c29-8a38-a9c619b7d512	2026-08-27 15:51	2026-08-27 15:51	2026-08-27 15:51	AS	AS261016C00032500	call	32.5000	2026-10-16	1.3500	1.2500	1.4000	30.5780	66015.00	60345.00	2835.00	489	16	2515	1151	2.18505647263249	0.455635066274439	0.455635066274439	true	false	false	true	false
a57a7124-0536-46dd-b6ed-8fb5393a26a7	2026-08-27 15:51	2026-08-27 15:51	2026-08-27 15:51	AS	AS261016C00032500	call	32.5000	2026-10-16	1.3500	1.3000	1.4000	30.5800	21735.00	0.00	18900.00	161	8	2676	1151	2.3249348392702	0.455451254108814	0.455451254108814	false	false	false	true	false
db27341c-d184-47a8-a152-45cdba3248c4	2026-08-27 15:51	2026-08-27 15:51	2026-08-27 15:51	AS	AS261016C00032500	call	32.5000	2026-10-16	1.4000	1.3000	1.4250	30.6000	184518.00	182698.00	1820.00	1318	68	4026	1151	3.49782797567333	0.46500018798166	0.46500018798166	true	false	false	true	false
7d4b5dc8-8a38-4a11-9837-35fbd971f7e7	2026-08-27 15:56	2026-08-27 15:56	2026-08-27 15:56	AS	AS260918P00030500	put	30.5000	2026-09-18	1.4500	1.0500	1.4500	30.5650	36250.00	36250.00	0.00	250	17	502	0	0	0.507938965222433	0.507938965222433	true	false	false	true	false
f70d7a2f-438d-4508-9a5d-193c4f68cf90	2026-08-28 11:40	2026-08-28 11:39	2026-08-28 11:39	AS	AS260918P00031000	put	31.0000	2026-09-18	1.4000	1.4000	1.6000	30.0000	14000.00	0.00	14000.00	100	6	308	144	2.13888888888889	0.454841103225027	0.454841103225027	false	false	false	true	false
3e22f311-5e20-4993-9b5f-d93ebf057b38	2026-08-28 11:40	2026-08-28 11:39	2026-08-28 11:39	AS	AS260918P00031000	put	31.0000	2026-09-18	1.4500	1.4500	1.6000	30.0000	13485.00	0.00	13485.00	93	10	208	144	1.44444444444444	0.466789604329752	0.466789604329752	false	false	false	true	false
6ab691fd-24b5-4c8f-be2c-299429621b26	2026-08-28 11:40	2026-08-28 11:40	2026-08-28 11:40	AS	AS260918P00030500	put	30.5000	2026-09-18	1.1500	1.1500	1.3000	30.0000	10695.00	0.00	10695.00	93	5	167	309	0.540453074433657	0.457063154229636	0.457063154229636	false	false	false	true	false
986ece80-5944-4165-99ab-03e098aff6c2	2026-08-28 11:40	2026-08-28 11:40	2026-08-28 11:40	AS	AS260918P00031000	put	31.0000	2026-09-18	1.4000	1.4000	1.6000	30.0000	10926.00	0.00	10926.00	78	12	481	144	3.34027777777778	0.457336112805552	0.464740589949296	false	false	false	true	false
2fba9f6f-73d6-4701-b430-763a1461da7e	2026-08-28 11:43	2026-08-28 11:42	2026-08-28 11:42	AS	AS261016P00030000	put	30.0000	2026-10-16	1.4500	1.4500	1.6000	30.0000	14500.00	0.00	14500.00	100	6	135	444	0.304054054054054	0.433667097586291	0.433667097586291	false	false	false	true	false
65556ac9-f80d-4fdd-84d8-711f49c5b02d	2026-08-28 15:06	2026-08-28 15:06	2026-08-28 15:06	AS	AS261016C00032500	call	32.5000	2026-10-16	1.4000	1.4000	1.4500	30.8700	11760.00	0.00	11760.00	84	7	1015	5111	0.198591273723342	0.44423045806272	0.44423045806272	false	false	false	true	false
eff1db60-3c38-4e27-9817-4e61e5bd2cd5	2026-08-28 15:07	2026-08-28 15:07	2026-08-28 15:07	AS	AS261016P00030000	put	30.0000	2026-10-16	1.5000	1.5000	1.5500	30.8900	12900.00	0.00	12900.00	86	10	511	444	1.1509009009009	0.446117160723857	0.446117160723857	false	false	false	true	false
66bda005-ee04-4ab4-9fc1-897907b6e89b	2026-08-28 15:11	2026-08-28 15:11	2026-08-28 15:11	AS	AS260904C00032000	call	32.0000	2026-09-04	0.4000	0.3500	0.4500	30.8950	28000.00	20960.00	7000.00	700	6	700	0	0	0.478767554798092	0.478767554798092	false	false	false	true	false
54004787-87e2-4549-a2ad-1d809df45202	2026-08-28 15:21	2026-08-28 15:21	2026-08-28 15:21	AS	AS260918C00031000	call	31.0000	2026-09-18	1.4500	1.3500	1.4500	30.8900	11743.00	11743.00	0.00	81	21	397	625	0.6352	0.497591275249337	0.497591275249337	false	false	false	true	false
1310aca7-a2ab-4851-8c01-146280f672c4	2026-08-28 15:21	2026-08-28 15:21	2026-08-28 15:21	AS	AS260918C00031000	call	31.0000	2026-09-18	1.4500	1.4000	1.5000	30.9500	35235.00	11745.00	23490.00	243	18	640	625	1.024	0.494067943023689	0.486984613606167	false	false	false	true	false
20002609-dd26-4e7c-b1d4-9f4daa9e9dca	2026-08-28 15:29	2026-08-28 15:29	2026-08-28 15:29	AS	AS260918P00031000	put	31.0000	2026-09-18	1.3000	1.3000	1.5000	30.9800	13000.00	0.00	13000.00	100	6	798	144	5.54166666666667	0.447107736288847	0.447107736288847	false	false	false	true	false
a888759a-a8f6-4a86-85a4-b365ceab38b1	2026-08-31 09:34	2026-08-31 09:34	2026-08-31 09:34	AS	AS260918C00030000	call	30.0000	2026-09-18	1.7000	1.7000	2.0500	30.4500	85000.00	0.00	9860.00	500	9	500	15782	0.0316816626536561	0.535754332882671	0.535754332882671	false	false	false	true	false
c4a932bf-9074-4e83-ac56-2c4f69b89442	2026-08-31 09:35	2026-08-31 09:35	2026-08-31 09:35	AS	AS260918C00030000	call	30.0000	2026-09-18	1.7500	1.6000	1.9000	30.5000	28525.00	6650.00	5775.00	163	7	663	15782	0.0420098846787479	0.543664475281258	0.543664475281258	false	false	false	true	false
b2aea3ab-6f92-425a-bc7d-29d79328e3e8	2026-08-31 09:35	2026-08-31 09:35	2026-08-31 09:35	AS	AS260918C00030000	call	30.0000	2026-09-18	1.8000	1.6000	1.8000	30.5000	60660.00	60660.00	0.00	337	15	1000	15782	0.0633633253073121	0.562586873017686	0.562586873017686	false	false	false	true	false
52fd8c27-bc1e-4f20-99f6-8eb296f7dc2e	2026-08-31 10:03	2026-08-31 10:02	2026-08-31 10:02	AS	AS261016P00027500	put	27.5000	2026-10-16	0.7500	0.7000	0.8500	30.3700	11250.00	11025.00	225.00	150	10	253	180	1.40555555555556	0.46145107154702	0.46145107154702	false	false	false	true	false
823c10c8-2577-47e3-81da-1d844fdcf9f2	2026-08-31 11:12	2026-08-31 11:12	2026-08-31 11:12	AS	AS260918C00030000	call	30.0000	2026-09-18	1.5000	1.4000	1.5500	30.2500	130350.00	71100.00	50400.00	869	7	1889	15782	0.119693321505513	0.511603520606092	0.503215759089529	false	false	false	true	false
c8550b50-5194-4a75-87c5-30a4b0808ce1	2026-08-31 11:12	2026-08-31 11:12	2026-08-31 11:12	AS	AS260918P00030000	put	30.0000	2026-09-18	1.1500	1.1000	1.1500	30.3300	56924.00	56924.00	0.00	495	16	640	7258	0.0881785615872141	0.50171384534022	0.500084063024283	false	false	false	true	false
e0c7428c-d80f-44d8-b6e0-1075fc9cc11e	2026-08-31 12:34	2026-08-31 12:34	2026-08-31 12:34	AS	AS260918C00030000	call	30.0000	2026-09-18	1.8000	1.7500	1.8000	30.7700	315000.00	315000.00	0.00	1750	2	3736	15782	0.236725383348118	0.500932474756755	0.500932474756755	false	true	true	false	false
0cf7bb1a-9644-47e9-a729-ccd54d202aa7	2026-09-01 11:39	2026-09-01 11:39	2026-09-01 11:39	AS	AS261016P00030000	put	30.0000	2026-10-16	1.7500	1.7500	1.8000	29.9600	17500.00	0.00	17500.00	100	5	317	1168	0.271404109589041	0.430319225558178	0.430319225558178	false	false	false	true	false
4158500f-9440-4b42-99de-68940b1ee37b	2026-09-01 11:41	2026-09-01 11:41	2026-09-01 11:41	AS	AS260918C00030000	call	30.0000	2026-09-18	1.2500	1.2500	1.3000	29.9000	12500.00	0.00	12500.00	100	5	2425	29377	0.0825475712291929	0.49435280235781	0.49435280235781	false	false	false	true	false
d34e5631-8aeb-4f8a-98e5-bf950c853f54	2026-09-01 11:42	2026-09-01 11:41	2026-09-01 11:41	AS	AS260918C00030000	call	30.0000	2026-09-18	1.2000	1.2000	1.3000	29.9000	10560.00	0.00	10560.00	88	5	2513	29377	0.0855431119583347	0.474916374641233	0.474916374641233	false	false	false	true	false
0ac2af37-a37e-4d46-a68c-376e2cc15ea3	2026-09-01 11:42	2026-09-01 11:41	2026-09-01 11:41	AS	AS260918C00030000	call	30.0000	2026-09-18	1.2000	1.2000	1.3000	29.9100	12000.00	0.00	12000.00	100	9	2613	29377	0.0889471355141778	0.472914664081429	0.472914664081429	false	false	false	true	false
8816105d-01ce-4d3b-9091-af66152cefc5	2026-09-02 10:11	2026-09-02 10:11	2026-09-02 10:11	AS	AS260918C00030000	call	30.0000	2026-09-18	1.0000	0.9500	1.0500	29.4400	21500.00	7200.00	14300.00	215	16	602	32841	0.0183307451052039	0.507760130843502	0.49940040012708	true	false	false	true	false
2c521970-398f-4bd7-8675-a1ba9d1de732	2026-09-02 10:25	2026-09-02 10:25	2026-09-02 10:25	AS	AS261016C00030000	call	30.0000	2026-10-16	1.6600	1.5500	1.6500	29.4700	183596.00	183596.00	0.00	1106	2	1106	204	5.42156862745098	0.450284669311805	0.450284669311805	false	true	true	false	true
dc71cf10-69c2-454a-be2a-d7094b5ef744	2026-09-02 11:32	2026-09-02 11:32	2026-09-02 11:32	AS	AS260918P00029000	put	29.0000	2026-09-18	0.9500	0.9500	1.0000	29.2000	14725.00	0.00	14725.00	155	20	165	111	1.48648648648649	0.44068300691191	0.44068300691191	false	false	false	true	false
73c00632-d6b9-4351-922e-80a496cdba94	2026-09-02 11:59	2026-09-02 11:59	2026-09-02 11:59	AS	AS260918C00029000	call	29.0000	2026-09-18	1.1400	1.0500	1.1500	29.0350	17100.00	17100.00	0.00	150	5	150	138	1.08695652173913	0.453383586151737	0.453383586151737	false	false	false	true	false
32dfbae4-369c-4ace-82ca-1483ea3f9e50	2026-09-02 14:19	2026-09-02 14:19	2026-09-02 14:19	AS	AS260918C00029000	call	29.0000	2026-09-18	1.0000	0.9500	1.0500	28.7450	116898.00	96498.00	20400.00	1169	33	1319	138	9.55797101449275	0.45667908919185	0.45667908919185	false	false	false	true	false
0908f6fe-c9dc-4eb8-a5e1-3aef81ff37f3	2026-09-02 14:19	2026-09-02 14:19	2026-09-02 14:19	AS	AS260918C00030000	call	30.0000	2026-09-18	0.7500	0.5500	0.8000	28.8800	19575.00	19500.00	75.00	261	27	15784	32841	0.480618738771657	0.492876347198711	0.492876347198711	true	false	false	true	false
4b0c85e0-d461-4d24-aa67-6cec31c96159	2026-09-02 15:45	2026-09-02 15:45	2026-09-02 15:45	AS	AS260918C00030000	call	30.0000	2026-09-18	0.6000	0.5500	0.6000	28.6050	26040.00	26040.00	0.00	434	19	20853	32841	0.634968484516306	0.470244900970622	0.470244900970622	true	false	false	true	false
f29c1c59-02e3-40c7-9ccd-5dc2817bc587	2026-09-03 09:48	2026-09-03 09:48	2026-09-03 09:48	AS	AS260918C00030000	call	30.0000	2026-09-18	0.5500	0.4500	0.5500	28.3610	14850.00	14850.00	0.00	270	10	350	15416	0.0227036844836533	0.500281785701124	0.500281785701124	true	false	false	true	false
f4a4023c-a098-4d02-ac45-7bf938a9cbc8	2026-09-03 10:57	2026-09-03 10:57	2026-09-03 10:57	AS	AS260918C00029500	call	29.5000	2026-09-18	0.6500	0.5500	0.6500	28.2350	21642.00	21642.00	0.00	333	49	333	2545	0.130844793713163	0.497032692580351	0.497032692580351	true	false	false	true	false
c485517c-4d73-4193-b2f6-2d2253a12985	2026-09-03 10:57	2026-09-03 10:57	2026-09-03 10:57	AS	AS260918C00029500	call	29.5000	2026-09-18	0.7000	0.5500	0.7000	28.2900	73912.00	73847.00	65.00	1056	71	1389	2545	0.545776031434185	0.512743927733024	0.511042392654611	true	false	false	true	false
993def93-6bd4-4762-8ad4-5445211177eb	2026-09-03 11:05	2026-09-03 11:05	2026-09-03 11:05	AS	AS261218C00032500	call	32.5000	2026-12-18	1.5500	1.4500	1.6000	28.5700	46810.00	37510.00	6200.00	302	6	347	406	0.854679802955665	0.461140118097039	0.461140118097039	true	false	false	true	false
8abcf9a7-f45a-4159-b736-a180e9871731	2026-09-03 11:06	2026-09-03 11:06	2026-09-03 11:06	AS	AS261218P00030000	put	30.0000	2026-12-18	3.5000	3.4000	3.5000	28.5600	88200.00	88200.00	0.00	252	32	254	351	0.723646723646724	0.468207786473675	0.468207786473675	true	false	false	true	false
6eca2930-e2f6-4e16-9188-25ba1b9e2077	2026-09-03 11:09	2026-09-03 11:09	2026-09-03 11:09	AS	AS261218P00027500	put	27.5000	2026-12-18	2.2500	2.2000	2.3000	28.4700	11025.00	10350.00	0.00	49	10	49	181	0.270718232044199	0.477528992391757	0.477528992391757	false	false	false	true	false
bb6ccd54-a85c-4f58-85a0-95eb61161c63	2026-09-03 11:10	2026-09-03 11:10	2026-09-03 11:10	AS	AS270115P00027500	put	27.5000	2027-01-15	2.5500	2.4500	2.7000	28.4400	52785.00	52530.00	255.00	207	15	1313	404	3.25	0.474794747273236	0.474794747273236	false	false	false	true	false
2583dc52-3878-4645-9bc6-0dcb139c57a1	2026-09-03 11:49	2026-09-03 11:48	2026-09-03 11:48	AS	AS260918C00029000	call	29.0000	2026-09-18	0.9500	0.8500	0.9500	28.4790	132239.00	132239.00	0.00	1392	34	1415	1603	0.882719900187149	0.50504205655295	0.50504205655295	true	false	false	true	false
603414cf-6f65-46b7-a5b4-eb404ee4d5b2	2026-09-03 12:38	2026-09-03 12:37	2026-09-03 12:37	AS	AS261016C00030000	call	30.0000	2026-10-16	1.1200	1.0500	1.1500	28.3350	11310.00	11200.00	0.00	101	5	1491	1335	1.11685393258427	0.447423087687271	0.44208025663964	false	false	false	true	false
f68b5dd5-f463-4551-8342-ea5e3445ec6d	2026-09-03 12:40	2026-09-03 12:40	2026-09-03 12:40	AS	AS261002C00027000	call	27.0000	2026-10-02	2.3600	2.0000	2.4500	28.4200	1177746.00	833989.00	334122.00	5001	51	5001	0	0	0.485361527951175	0.475900776754573	false	false	false	true	false
618cc997-f898-4e92-8ce2-17c03d4e563f	2026-09-03 12:41	2026-09-03 12:41	2026-09-03 12:41	AS	AS261002C00027000	call	27.0000	2026-10-02	2.4500	2.2000	2.5500	28.4430	575248.00	569368.00	5880.00	2348	56	7349	0	0	0.505305292365669	0.505305292365669	false	false	false	true	false
c3aa0be1-6c0a-40a4-8216-0644af6ee545	2026-09-03 12:42	2026-09-03 12:42	2026-09-03 12:42	AS	AS261218C00032500	call	32.5000	2026-12-18	1.7000	1.6500	1.7500	28.6400	24990.00	19720.00	4930.00	147	12	528	406	1.30049261083744	0.482432033043234	0.482432033043234	true	false	false	true	false