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

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	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-03T16:58:53.831299Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
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
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	false
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
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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
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	false
ccf3f93f-b40f-473d-bace-c6eeb05dfba1	2026-09-11 09:30	2026-09-11 09:30	2026-09-11 09:30	AS	AS261002C00027000	call	27.0000	2026-10-02	2.0000	1.7000	2.0500	28.0000	395959.00	387959.00	8000.00	1981	76	2741	6530	0.419754977029096	0.492262536400206	0.509919211196692	false	false	false	true	false
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	false
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	false
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	false
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	false
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	false
0643e8a9-38e3-495f-8fab-5c27719a24ff	2026-09-11 13:36	2026-09-11 13:36	2026-09-11 13:36	AS	AS261016C00027500	call	27.5000	2026-10-16	1.9500	1.9500	2.0000	28.1450	11511.00	0.00	11511.00	59	10	1203	135	8.91111111111111	0.452236866094336	0.452236866094336	false	false	false	true	false
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	false
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	false
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	false
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	false
389ab986-9900-4821-8d96-d3c0ac57155e	2026-09-14 12:00	2026-09-14 12:00	2026-09-14 12:00	AS	AS261002C00027000	call	27.0000	2026-10-02	1.6000	1.6000	1.7000	27.8000	10908.00	0.00	10908.00	68	7	5843	17971	0.325134939624951	0.472365102052037	0.472365102052037	false	false	false	true	false
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	false
429f1e9e-e653-483d-a6cf-bdb6bcca3080	2026-09-14 12:08	2026-09-14 12:08	2026-09-14 12:08	AS	AS261002C00027000	call	27.0000	2026-10-02	1.6000	1.5500	1.6500	27.7900	10258.00	2898.00	0.00	64	5	6235	17971	0.346947860441823	0.470794177134931	0.466480300340563	false	false	false	true	false
8cc75f43-d3b3-40a8-9391-e26ec5ee1373	2026-09-14 12:20	2026-09-14 12:19	2026-09-14 12:19	AS	AS261002C00027000	call	27.0000	2026-10-02	1.6200	1.6000	1.7000	27.8200	10825.00	0.00	10825.00	67	9	6717	17971	0.373768849813589	0.466851052052614	0.466851052052614	false	false	false	true	false
e8a2d966-f2da-436c-a8de-944c89e51d66	2026-09-14 12:21	2026-09-14 12:21	2026-09-14 12:21	AS	AS261002C00027000	call	27.0000	2026-10-02	1.6200	1.6000	1.7000	27.8450	10072.00	0.00	10072.00	62	9	6779	17971	0.377218852595849	0.464231299088627	0.459890710999125	false	false	false	true	false
bee181b4-59ca-4b04-bd56-1d515e3a230c	2026-09-14 12:31	2026-09-14 12:30	2026-09-14 12:30	AS	AS261002C00027000	call	27.0000	2026-10-02	1.6300	1.6000	1.7000	27.8450	12560.00	0.00	12560.00	77	5	7201	17971	0.400701129597685	0.468567919800479	0.468567919800479	false	false	false	true	false
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	false
d3b3d191-ec55-4a66-b745-060e7470490f	2026-09-14 12:35	2026-09-14 12:35	2026-09-14 12:35	AS	AS261002C00027000	call	27.0000	2026-10-02	1.6300	1.6000	1.7000	27.8497	10603.00	0.00	10603.00	65	5	7407	17971	0.412164042067776	0.467256880235009	0.467256880235009	false	false	false	true	false
54c20708-78f4-4729-9c5e-b5174c25466a	2026-09-14 12:37	2026-09-14 12:37	2026-09-14 12:37	AS	AS261002C00027000	call	27.0000	2026-10-02	1.6200	1.6000	1.7000	27.8450	10558.00	0.00	10558.00	65	7	7472	17971	0.415780980468533	0.464231299088627	0.464231299088627	false	false	false	true	false
2de29829-6747-4697-a449-056248df98bd	2026-09-14 12:38	2026-09-14 12:38	2026-09-14 12:38	AS	AS261002C00027000	call	27.0000	2026-10-02	1.6200	1.6000	1.7000	27.8450	10558.00	0.00	10558.00	65	8	7537	17971	0.419397918869289	0.468567919800479	0.468567919800479	false	false	false	true	false
41b7dd21-e2bf-442b-82a9-f3eb23256578	2026-09-14 12:39	2026-09-14 12:39	2026-09-14 12:39	AS	AS261016C00032500	call	32.5000	2026-10-16	0.2500	0.2500	0.3500	27.8700	16863.00	0.00	16863.00	674	45	1660	6277	0.264457543412458	0.445181148833786	0.445181148833786	false	false	false	true	false
0a6ad91b-b100-482b-baf2-c81cae1d75ef	2026-09-14 12:43	2026-09-14 12:43	2026-09-14 12:43	AS	AS261002C00027000	call	27.0000	2026-10-02	1.6200	1.6000	1.7000	27.8400	11673.00	0.00	11673.00	72	6	7749	17971	0.431194702576373	0.465626272053524	0.465626272053524	false	false	false	true	false
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	false
d12e1704-940e-4548-b848-66fa8639dfda	2026-09-14 12:46	2026-09-14 12:46	2026-09-14 12:46	AS	AS261002C00027000	call	27.0000	2026-10-02	1.6100	1.6000	1.7000	27.8200	10638.00	0.00	10638.00	66	6	7881	17971	0.438539869790218	0.466851052052614	0.466851052052614	false	false	false	true	false