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.

425,429 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts425,429 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:alert_rule = RepeatedHits×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

c307e86f-6c5f-4d48-84f7-9a8544e38a4f	2026-09-14 13:32	2026-09-14 13:32	2026-09-14 13:32	AS	AS261002C00027000	call	27.0000	2026-10-02	1.5600	1.5500	1.6000	27.7450	12792.00	0.00	12792.00	82	5	10019	17971	0.557509320572033	0.461531317274191	0.461531317274191	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-09-14T17:44:35.656770Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
b53e476d-a1d4-4c30-b6db-2dcec2a70676	2026-09-14 13:30	2026-09-14 13:30	2026-09-14 13:30	AS	AS261002C00027000	call	27.0000	2026-10-02	1.6000	1.6000	1.6500	27.8001	11040.00	0.00	11040.00	69	11	9937	17971	0.552946413666463	0.463701508548468	0.463701508548468	false	false	false	true
91786d17-1303-47b0-9b6f-a89053ce2aad	2026-09-14 13:14	2026-09-14 13:13	2026-09-14 13:13	AS	AS261002C00027000	call	27.0000	2026-10-02	1.6200	1.6000	1.7000	27.8350	11664.00	0.00	11664.00	72	6	9196	17971	0.511713315897835	0.462684116755747	0.462684116755747	false	false	false	true
2680cd78-81e6-447b-904f-97c68ae81442	2026-09-14 12:56	2026-09-14 12:56	2026-09-14 12:56	AS	AS261002C00027000	call	27.0000	2026-10-02	1.7000	1.7000	1.7500	27.9450	11390.00	0.00	11390.00	67	24	8387	17971	0.466696344109955	0.466411540621628	0.466411540621628	false	false	false	true
4df9cd83-b918-400d-a3d3-b70576e6b962	2026-09-14 12:51	2026-09-14 12:51	2026-09-14 12:51	AS	AS261002C00027000	call	27.0000	2026-10-02	1.7100	1.7000	1.8000	27.9700	13509.00	0.00	13509.00	79	5	8110	17971	0.451282622002114	0.463581724198646	0.463581724198646	false	false	false	true
34259416-d04f-46bb-94c2-505d9ffe757a	2026-09-14 12:44	2026-09-14 12:44	2026-09-14 12:44	AS	AS261002C00027000	call	27.0000	2026-10-02	1.6100	1.6000	1.7000	27.8200	10626.00	0.00	10626.00	66	5	7815	17971	0.434867286183295	0.462522714486619	0.462522714486619	false	false	false	true
84f37688-ddd3-4a1c-a1d1-63d62bb9222b	2026-09-14 12:33	2026-09-14 12:33	2026-09-14 12:33	AS	AS261002C00027000	call	27.0000	2026-10-02	1.6500	1.6500	1.7000	27.8650	10560.00	0.00	10560.00	64	19	7340	17971	0.408435813254688	0.467315854160921	0.467315854160921	false	false	false	true
8622a308-fc14-4623-94e1-e38854363bb7	2026-09-14 12:06	2026-09-14 12:06	2026-09-14 12:06	AS	AS261002C00027000	call	27.0000	2026-10-02	1.6000	1.6000	1.6500	27.7750	10560.00	0.00	10560.00	66	17	6171	17971	0.343386567247232	0.470585325009277	0.470585325009277	false	false	false	true
a93e769d-98a4-4e23-adc2-b080ef5a7941	2026-09-14 11:59	2026-09-14 11:58	2026-09-14 11:58	AS	AS261002C00027000	call	27.0000	2026-10-02	1.6100	1.6000	1.7000	27.8100	10465.00	0.00	10465.00	65	5	5775	17971	0.321351065605698	0.46529174761833	0.46529174761833	false	false	false	true
d531e59a-3937-4ac2-8859-2c7eaa077973	2026-09-14 11:45	2026-09-14 11:45	2026-09-14 11:45	AS	AS261002C00027000	call	27.0000	2026-10-02	1.6700	1.6500	1.8000	27.9000	10354.00	0.00	10354.00	62	5	5153	17971	0.286739747370764	0.466148568572953	0.466148568572953	false	false	false	true
a9b78fcf-109d-4210-a07a-b48474e63d20	2026-09-14 11:29	2026-09-14 11:29	2026-09-14 11:29	AS	AS261002C00027000	call	27.0000	2026-10-02	1.6100	1.6000	1.7000	27.7800	10304.00	0.00	10304.00	64	6	4436	17971	0.246842134550109	0.47352807599647	0.47352807599647	false	false	false	true
d1c2651d-af9e-41bb-bc59-068889be2a6c	2026-09-11 15:16	2026-09-11 15:16	2026-09-11 15:16	AS	AS261016C00027500	call	27.5000	2026-10-16	1.9500	1.9500	2.0000	28.1350	15795.00	0.00	15795.00	81	12	1466	135	10.8592592592593	0.454029052684046	0.454029052684046	false	false	false	true
5e83189e-a38c-4520-9ab5-3b926b525657	2026-09-11 11:57	2026-09-11 11:57	2026-09-11 11:57	AS	AS261218P00027500	put	27.5000	2026-12-18	2.3000	2.2000	2.3500	28.0950	14260.00	6670.00	7590.00	62	10	97	326	0.297546012269939	0.47521966884204	0.47521966884204	false	false	false	true
ec6b7dc5-f1ae-4ec3-a2b2-49a2fe0c4a7e	2026-09-11 11:51	2026-09-11 11:51	2026-09-11 11:51	AS	AS261002C00027000	call	27.0000	2026-10-02	2.0000	1.7500	2.0000	28.0100	300000.00	300000.00	0.00	1500	34	11558	6530	1.76998468606432	0.533414744099667	0.533414744099667	false	false	false	true
99a09449-c8e9-4b79-909b-dbf07c48d58b	2026-09-11 09:59	2026-09-11 09:59	2026-09-11 09:59	AS	AS261002C00027000	call	27.0000	2026-10-02	1.9000	1.6000	1.9500	28.0000	576645.00	563540.00	12535.00	3035	74	6036	6530	0.924349157733538	0.485445917315384	0.490724389901096	false	false	false	true
d7edba94-a29a-40b3-9690-a1e1a88390fb	2026-09-11 09:45	2026-09-11 09:45	2026-09-11 09:45	AS	AS260918C00029500	call	29.5000	2026-09-18	0.3500	0.2500	0.4000	27.9700	26460.00	17605.00	6615.00	756	8	876	3938	0.222447943118334	0.575464010790054	0.575464010790054	false	false	false	true
b98fc242-b04f-4436-a3c2-786864028093	2026-09-11 09:31	2026-09-11 09:30	2026-09-11 09:30	AS	AS261002C00027000	call	27.0000	2026-10-02	2.0000	2.0000	2.1000	28.0000	43800.00	0.00	43800.00	219	12	3000	6530	0.459418070444104	0.4938007702335	0.4938007702335	false	false	false	true
eb9283ed-d61e-42b4-a9be-3362f1c21a3c	2026-09-11 09:30	2026-09-11 09:30	2026-09-11 09:30	AS	AS261002C00027000	call	27.0000	2026-10-02	1.9500	1.9500	2.0000	28.0600	140400.00	0.00	140400.00	720	17	760	6530	0.116385911179173	0.500335541787823	0.500335541787823	true	false	false	true
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
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
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
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	false
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
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
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