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:sector = Consumer Cyclical×ticker = AS×

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

c88b46cb-4c07-4412-a45a-0ba6240b0b4b	2026-09-10 13:53	2026-09-10 13:53	2026-09-10 13:53	AS	AS260918C00029000	call	29.0000	2026-09-18	0.3500	0.2500	0.3500	27.4300	24740.00	24530.00	0.00	712	25	1105	3985	0.277289836888331	0.555324758372974	0.555324758372974	true	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	Common Stock	Consumer Cyclical	15363736512.00	2026-11-17	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-10T18:09:00.187388Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
702e0a4b-8d31-45f5-81bb-f8ed1dad5b1f	2026-09-08 14:51	2026-09-08 14:51	2026-09-08 14:51	AS	AS260911C00028500	call	28.5000	2026-09-11	0.6500	0.6500	0.7500	28.8100	11310.00	0.00	11310.00	174	11	751	751	1	0.457055856857155	0.457055856857155	false	false	false	true
d0779380-30f4-4d99-9973-1e51726b7934	2026-09-08 14:51	2026-09-08 14:51	2026-09-08 14:51	AS	AS260911C00028500	call	28.5000	2026-09-11	0.7000	0.7000	0.7500	28.8350	14562.00	0.00	14562.00	208	29	366	751	0.487350199733688	0.491720204520843	0.491720204520843	false	false	false	true
483f025c-d25d-4c8d-99be-2c5fa691ef9c	2026-09-08 13:53	2026-09-08 13:53	2026-09-08 13:53	AS	AS260918C00029000	call	29.0000	2026-09-18	0.9000	0.8500	0.9500	28.8000	21330.00	0.00	13860.00	237	8	386	3076	0.125487646293888	0.515324626661545	0.515324626661545	false	false	false	true
033e2982-be73-4009-acc0-af4e9da545a4	2026-09-04 15:20	2026-09-04 15:20	2026-09-04 15:20	AS	AS260918C00030000	call	30.0000	2026-09-18	0.9500	0.9500	1.0000	29.6100	25840.00	0.00	25840.00	272	5	327	15781	0.0207211203345796	0.479100927986803	0.479100927986803	false	false	false	true
f298dd46-acfd-4ec0-8d3d-1ec42097d9f3	2026-09-04 15:10	2026-09-04 15:10	2026-09-04 15:10	AS	AS261002C00027000	call	27.0000	2026-10-02	3.2000	3.1000	3.2000	29.6350	134400.00	134400.00	0.00	420	6	5286	11690	0.452181351582549	0.467443571472343	0.467443571472343	false	false	false	true
4326f7d7-d33a-40e4-9025-b8275b013f08	2026-09-04 14:58	2026-09-04 14:58	2026-09-04 14:58	AS	AS261002C00027000	call	27.0000	2026-10-02	3.2000	3.1000	3.2000	29.6250	27520.00	27520.00	0.00	86	16	4795	11690	0.410179640718563	0.470770302630846	0.470770302630846	true	false	false	true
1390b5bf-1620-4eaa-972b-0b5fefc68cef	2026-09-04 14:36	2026-09-04 14:36	2026-09-04 14:36	AS	AS261002C00027000	call	27.0000	2026-10-02	3.2000	3.1000	3.2000	29.5950	13760.00	13760.00	0.00	43	7	3713	11690	0.317621899059025	0.480591327177518	0.480591327177518	false	false	false	true
195e5347-efe4-4d27-a74b-7c75de77ff73	2026-09-04 12:16	2026-09-04 12:16	2026-09-04 12:16	AS	AS261002C00027000	call	27.0000	2026-10-02	3.2000	3.2000	3.3000	29.5900	1010435.00	4564.00	998721.00	3157	56	3578	11690	0.306073567151411	0.474430875852569	0.482206041538029	false	false	false	true
3e8030ed-fac4-4736-9a03-9765526100e7	2026-09-04 09:57	2026-09-04 09:57	2026-09-04 09:57	AS	AS261218C00040000	call	40.0000	2026-12-18	0.6000	0.3500	0.6500	28.9800	30000.00	25500.00	4500.00	500	14	1000	3388	0.295159386068477	0.513285927956959	0.513285927956959	false	false	false	true
80bf7779-03b3-4cc7-84b8-cf79364c5881	2026-09-04 09:57	2026-09-04 09:57	2026-09-04 09:57	AS	AS261218C00040000	call	40.0000	2026-12-18	0.6000	0.5500	0.6000	28.9400	30000.00	26700.00	0.00	500	11	500	3388	0.147579693034238	0.516000150870273	0.514981835401642	false	false	false	true
7c87e191-eb37-4955-8f3e-8ddd389194a0	2026-09-03 15:13	2026-09-03 15:13	2026-09-03 15:13	AS	AS261218P00025000	put	25.0000	2026-12-18	1.2700	1.2500	1.3500	28.5400	649860.00	0.00	383750.00	5117	2	5249	238	22.0546218487395	0.482854483323675	0.482854483323675	false	true	false	true
6c0f61f6-1b35-42a1-8c20-bdf0cbcec9e5	2026-09-03 14:56	2026-09-03 14:56	2026-09-03 14:56	AS	AS260918C00029000	call	29.0000	2026-09-18	1.0500	0.9500	1.0500	28.5950	10455.00	10455.00	0.00	100	13	1890	1603	1.17903930131004	0.516393275089212	0.525060170061524	false	false	false	true
10b1acb5-3a92-49b1-9101-bd442deb5afa	2026-09-03 14:06	2026-09-03 14:06	2026-09-03 14:06	AS	AS261016C00030000	call	30.0000	2026-10-16	1.3400	1.2500	1.3500	28.6700	13012.00	13012.00	0.00	97	5	2030	1335	1.52059925093633	0.461036830335259	0.468797466733165	false	false	false	true
bf311759-85d4-4248-9467-8d8273f240db	2026-09-03 13:49	2026-09-03 13:49	2026-09-03 13:49	AS	AS261218C00040000	call	40.0000	2026-12-18	0.6000	0.5000	0.6000	28.6550	29990.00	26880.00	0.00	500	12	503	1939	0.259412068076328	0.525900787108471	0.510834029381903	false	false	false	true
f242830f-237a-46ee-a811-64635b30b97d	2026-09-03 13:13	2026-09-03 13:13	2026-09-03 13:13	AS	AS260911C00028500	call	28.5000	2026-09-11	0.8000	0.7000	0.9000	28.5550	60800.00	43040.00	17760.00	760	62	808	13	62.1538461538462	0.459112625707449	0.45127568957956	false	false	false	true
acb62f3a-f6f8-4e10-a809-3e098307ed5f	2026-09-03 13:08	2026-09-03 13:08	2026-09-03 13:08	AS	AS261218C00045000	call	45.0000	2026-12-18	0.2500	0.2000	0.3000	28.5750	16150.00	13425.00	2275.00	646	32	2058	13364	0.153995809637833	0.524050688548226	0.523531608808899	true	false	false	true
b770d93f-ee43-4a5d-92ab-41095191696e	2026-09-03 13:07	2026-09-03 13:07	2026-09-03 13:07	AS	AS261218C00045000	call	45.0000	2026-12-18	0.2500	0.2000	0.3000	28.5550	33840.00	33340.00	500.00	1355	66	1412	13364	0.105656988925471	0.524919805469182	0.524223767104456	true	false	false	true
b4f402a1-76a8-4f05-b298-09067adfe9ef	2026-09-03 13:03	2026-09-03 13:03	2026-09-03 13:03	AS	AS260911C00029500	call	29.5000	2026-09-11	0.4000	0.3000	0.4000	28.5200	35040.00	35040.00	0.00	876	16	909	36	25.25	0.459726838314859	0.459726838314859	false	false	false	true
8baa06ab-60f2-4932-96e5-0231926527c3	2026-09-03 13:02	2026-09-03 13:02	2026-09-03 13:02	AS	AS261002C00027000	call	27.0000	2026-10-02	2.4500	2.4000	2.5000	28.5600	649005.00	0.00	324380.00	2649	6	10410	0	0	0.477204917491722	0.477204917491722	false	false	false	true
52b2328f-33c8-4b9b-9c10-cde0cec4c62a	2026-09-03 12:45	2026-09-03 12:45	2026-09-03 12:45	AS	AS260918C00028500	call	28.5000	2026-09-18	1.2500	1.2000	1.3500	28.6000	19125.00	6250.00	3250.00	153	5	503	0	0	0.51002331676617	0.51002331676617	false	false	false	true
ae3ac82f-a864-4861-afb5-10e3639accde	2026-09-03 12:45	2026-09-03 12:45	2026-09-03 12:45	AS	AS260918C00028500	call	28.5000	2026-09-18	1.2100	1.2000	1.2500	28.6100	38220.00	7500.00	30720.00	316	9	350	0	0	0.507673259659584	0.507673259659584	false	false	false	true
3881cd6e-0d52-4f4c-bc46-ab895df57ce1	2026-09-03 12:44	2026-09-03 12:44	2026-09-03 12:44	AS	AS260911C00029000	call	29.0000	2026-09-11	0.5500	0.5000	0.5500	28.5900	48180.00	36135.00	0.00	876	22	877	0	0	0.42749841847687	0.42749841847687	false	false	false	true	false
1a28a2ff-5b50-4813-a0d5-149aeb0bf88f	2026-09-03 12:43	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.5950	14790.00	11390.00	0.00	87	12	648	406	1.59605911330049	0.485329525549378	0.485329525549378	true	false	false	true
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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