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.

375,978 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts375,978 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:source = uw_flow_alerts×ticker = ALLY×

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

ab3b899e-2c03-4b55-b96f-cbc3853e15c9	2026-09-23 10:57	2026-09-23 10:57	2026-09-23 10:57	ALLY	ALLY261016P00039000	put	39.0000	2026-10-16	1.2100	1.0000	1.3000	38.0000	12142.00	12142.00	0.00	100	5	201	382	0.526178010471204	0.29641150428258	0.29641150428258	false	false	false	true	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	Common Stock	Financial Services	11736024156.00	2026-10-20	premarket	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-23T15:00:57.901243Z"}	2026-09-23	2026-09-23 21:15	2026-09-23 21:15
7d14e500-0bc9-4692-807f-00ffa7e457c9	2026-09-22 10:34	2026-09-22 10:34	2026-09-22 10:34	ALLY	ALLY261120P00039000	put	39.0000	2026-11-20	1.5500	1.5500	1.7000	40.0200	54560.00	0.00	2480.00	352	5	352	429	0.82051282051282	0.337190688373357	0.337190688373357	false	false	false	true
e8190680-a4d7-46b6-a0e8-f2bed0d8e31d	2026-09-17 14:01	2026-09-17 14:01	2026-09-17 14:01	ALLY	ALLY270115P00037000	put	37.0000	2027-01-15	1.3500	1.2000	1.3500	40.8639	39825.00	39825.00	0.00	295	19	295	875	0.337142857142857	0.345899798715951	0.345899798715951	false	false	false	true
ba12819a-48ed-4a39-b2db-6207e5e80b0b	2026-09-16 14:36	2026-09-16 14:36	2026-09-16 14:36	ALLY	ALLY260918P00041000	put	41.0000	2026-09-18	0.6000	0.4000	0.6500	40.9800	12480.00	3840.00	480.00	208	12	1024	8872	0.115419296663661	0.491123813487524	0.491123813487524	false	false	false	true
3a579fe1-2943-4eac-8b94-ca3a77d57836	2026-09-15 15:13	2026-09-15 15:13	2026-09-15 15:13	ALLY	ALLY260918P00043000	put	43.0000	2026-09-18	1.7100	1.7000	1.7500	41.4000	25610.00	3850.00	21760.00	150	17	190	1890	0.100529100529101	0.394510509499731	0.394510509499731	false	false	false	true
14dcf67e-a47c-4693-a673-28a978d69a0f	2026-09-15 15:13	2026-09-15 15:13	2026-09-15 15:13	ALLY	ALLY260918P00042000	put	42.0000	2026-09-18	0.9500	0.9000	1.0000	41.4000	15503.00	0.00	14933.00	163	24	221	2310	0.0956709956709957	0.406321137262756	0.406321137262756	false	false	false	true
e434872c-9588-4235-9a06-71bde336f558	2026-09-15 09:54	2026-09-15 09:54	2026-09-15 09:54	ALLY	ALLY261120P00045000	put	45.0000	2026-11-20	5.2000	3.7000	5.2000	40.7994	45756.00	45756.00	0.00	88	10	88	318	0.276729559748428	0.395241588605745	0.393638421817588	false	false	false	true
d22abcf5-2047-460e-896e-f0f4ada05f67	2026-09-15 09:54	2026-09-15 09:54	2026-09-15 09:54	ALLY	ALLY261120P00041000	put	41.0000	2026-11-20	2.5500	1.7500	2.5500	40.7994	30345.00	30345.00	0.00	119	7	129	470	0.274468085106383	0.376695848035137	0.376695848035137	false	false	false	true
be3d1beb-dc6a-4fef-8a98-60251e4f5f06	2026-09-15 09:54	2026-09-15 09:54	2026-09-15 09:54	ALLY	ALLY260918P00044000	put	44.0000	2026-09-18	3.5800	2.2500	5.0000	40.4700	256940.00	40940.00	216000.00	717	25	717	140	5.12142857142857	0.880049220971895	0.64245669721603	true	false	false	true
a8ace5cc-c6c2-411a-a17c-6a9184cb7c1f	2026-09-15 09:54	2026-09-15 09:54	2026-09-15 09:54	ALLY	ALLY260918P00045000	put	45.0000	2026-09-18	4.5800	3.1000	5.0000	40.4700	768650.00	145350.00	623300.00	1678	31	1678	864	1.94212962962963	1.04004606093669	0.7706300650184	true	false	false	true
52c32cf2-4eea-4c90-93ac-9eec2a15f25a	2026-09-14 13:02	2026-09-14 13:02	2026-09-14 13:02	ALLY	ALLY260918P00041000	put	41.0000	2026-09-18	0.3000	0.2000	0.3500	42.1800	22281.00	17391.00	150.00	745	67	3102	7908	0.392261001517451	0.403993748413961	0.432941053898805	false	false	false	true
0996a42b-d71d-4bc6-964c-05e6ff6aab7e	2026-09-14 11:23	2026-09-14 11:23	2026-09-14 11:23	ALLY	ALLY260918P00041000	put	41.0000	2026-09-18	0.3500	0.2500	0.4000	41.9300	23030.00	13405.00	6895.00	658	9	2190	7908	0.276934749620637	0.428017508898318	0.420271731004012	false	false	false	true
7a23c64c-4e40-46e0-bde8-77df3c8b6975	2026-09-14 11:06	2026-09-14 11:06	2026-09-14 11:06	ALLY	ALLY260918P00041000	put	41.0000	2026-09-18	0.3000	0.2500	0.3000	42.1050	20210.00	20210.00	0.00	674	36	1530	7908	0.193474962063733	0.419349032925135	0.419349032925135	false	false	false	true
f12e7758-7e8d-49af-8bde-6bbf5ef56882	2026-09-14 10:34	2026-09-14 10:34	2026-09-14 10:34	ALLY	ALLY261218P00040000	put	40.0000	2026-12-18	1.6000	1.5500	1.7000	42.1300	154560.00	9120.00	136160.00	966	55	1000	2842	0.351864883884588	0.321339179612138	0.321339179612138	true	false	false	true
6ac0c630-fab8-4f7e-b113-e6271c9b2d1a	2026-09-11 10:40	2026-09-11 10:40	2026-09-11 10:40	ALLY	ALLY260918P00041000	put	41.0000	2026-09-18	0.5500	0.4500	0.6000	41.4100	157133.00	154273.00	2860.00	2857	46	6013	671	8.96125186289121	0.329543960946475	0.329543960946475	false	false	false	true
71557afc-5be4-43e7-bc0b-fa49a8ea4488	2026-09-11 10:40	2026-09-11 10:40	2026-09-11 10:40	ALLY	ALLY260918P00041000	put	41.0000	2026-09-18	0.5000	0.4000	0.5500	41.5300	80185.00	74535.00	5650.00	1604	58	3155	671	4.70193740685544	0.327872083411309	0.327872083411309	false	false	false	true
849e7475-a7d1-4192-a600-c98b8a531919	2026-09-11 10:40	2026-09-11 10:39	2026-09-11 10:39	ALLY	ALLY260918P00041000	put	41.0000	2026-09-18	0.4500	0.2000	0.5000	41.5400	11295.00	9945.00	1350.00	251	10	1551	671	2.31147540983607	0.306530798839849	0.306530798839849	true	false	false	true
084c17d3-91b3-4e65-a015-f25496e9a44d	2026-09-11 10:39	2026-09-11 10:39	2026-09-11 10:39	ALLY	ALLY260918P00041000	put	41.0000	2026-09-18	0.4500	0.4500	0.5000	41.6700	58500.00	0.00	3690.00	1300	6	1300	671	1.93740685543964	0.328044496016937	0.328044496016937	false	false	false	true
e5ab6564-84da-441e-bf71-1c3428e2a8c3	2026-09-10 10:37	2026-09-10 10:37	2026-09-10 10:37	ALLY	ALLY260918P00042000	put	42.0000	2026-09-18	0.8000	0.6500	1.2000	41.9000	59830.00	1440.00	58390.00	748	10	848	2550	0.332549019607843	0.309760697718395	0.289554580127875	false	false	false	true
490a4858-698d-4b8e-8adb-0e12571416e8	2026-09-10 10:37	2026-09-10 10:37	2026-09-10 10:37	ALLY	ALLY260918P00042000	put	42.0000	2026-09-18	0.8000	0.7500	1.1000	41.8950	60320.00	0.00	60320.00	754	6	1602	2550	0.628235294117647	0.30874047168129	0.30874047168129	false	false	false	true
ed37ec2f-a479-4236-8a0c-e39038a7ae8a	2026-09-10 10:24	2026-09-10 10:24	2026-09-10 10:24	ALLY	ALLY260918C00042000	call	42.0000	2026-09-18	0.8000	0.6500	0.8000	41.8500	45280.00	45280.00	0.00	566	26	2001	6164	0.324626865671642	0.345975112911998	0.345975112911998	false	false	false	true
b1b88a5a-80a2-47e4-9b20-699e10c495a8	2026-09-10 10:22	2026-09-10 10:22	2026-09-10 10:22	ALLY	ALLY260918C00042000	call	42.0000	2026-09-18	0.8000	0.8000	0.8500	41.8600	40160.00	0.00	80.00	502	47	1435	6164	0.232803374432187	0.343993502170803	0.343993502170803	true	false	false	true
5dc391d1-107f-4e89-a4b7-91421be6c1de	2026-09-10 10:21	2026-09-10 10:21	2026-09-10 10:21	ALLY	ALLY260918C00042000	call	42.0000	2026-09-18	0.7500	0.7500	0.7500	41.7800	28650.00	0.00	0.00	382	27	921	6164	0.149415963659961	0.339382957231555	0.339382957231555	true	false	false	true
3bf02733-8b7e-4a4d-b1ac-062af17d5e64	2026-09-10 10:21	2026-09-10 10:21	2026-09-10 10:21	ALLY	ALLY260918C00042000	call	42.0000	2026-09-18	0.7000	0.7000	0.7500	41.7200	37660.00	0.00	7140.00	538	45	539	6164	0.0874432186891629	0.330479631326145	0.330479631326145	true	false	false	true
33e304d2-8473-4b2e-8557-5e7c122ae2ec	2026-09-09 11:25	2026-09-09 11:25	2026-09-09 11:25	ALLY	ALLY261016P00041000	put	41.0000	2026-10-16	1.1000	1.0500	1.1000	41.8100	31680.00	31680.00	0.00	288	31	288	142	2.02816901408451	0.293026434216893	0.293026434216893	false	false	false	true
6d81c937-4e49-4c4d-8ac8-f637870b4510	2026-09-02 10:30	2026-09-02 10:30	2026-09-02 10:30	ALLY	ALLY270115P00038000	put	38.0000	2027-01-15	1.1500	1.1000	1.2500	43.0900	13110.00	12880.00	230.00	114	10	114	9	12.6666666666667	0.330213140904037	0.330213140904037	true	false	false	true
29ea603b-8d43-45ee-bcba-3caf822afb5a	2026-09-02 10:05	2026-09-02 10:05	2026-09-02 10:05	ALLY	ALLY260918C00042000	call	42.0000	2026-09-18	1.5000	1.5000	1.6000	42.8350	10650.00	0.00	10650.00	71	9	5222	7050	0.740709219858156	0.277248694648734	0.277248694648734	false	false	false	true
2f603e60-fb1b-4a00-988f-220bb9ab3c74	2026-09-02 10:05	2026-09-02 10:05	2026-09-02 10:05	ALLY	ALLY260918C00042000	call	42.0000	2026-09-18	1.5500	1.4500	1.6500	42.8300	100905.00	1860.00	99045.00	651	51	5151	7050	0.73063829787234	0.281445330714913	0.293290300902166	false	false	false	true
25aad18e-5749-43c6-9148-6f4f6a8771c5	2026-09-02 10:02	2026-09-02 10:02	2026-09-02 10:02	ALLY	ALLY260918C00042000	call	42.0000	2026-09-18	1.6000	1.5500	1.6000	42.9500	44480.00	32320.00	0.00	278	15	3960	7050	0.561702127659575	0.284543149718939	0.284543149718939	false	false	false	true
34907148-e522-47e0-8cb5-e0b703fd6ebd	2026-09-02 09:44	2026-09-02 09:44	2026-09-02 09:44	ALLY	ALLY260918P00042000	put	42.0000	2026-09-18	0.6500	0.5500	0.6500	42.8850	32500.00	32500.00	0.00	500	6	1502	1054	1.42504743833017	0.299334808842552	0.299334808842552	false	false	false	true
7afeb117-9f37-49ce-8bfc-fa15880ca937	2026-09-01 10:33	2026-09-01 10:33	2026-09-01 10:33	ALLY	ALLY261120P00041000	put	41.0000	2026-11-20	1.8500	1.5000	2.1000	42.2400	118770.00	185.00	13690.00	642	7	642	664	0.966867469879518	0.331993307792317	0.331993307792317	false	false	false	true
4b5c64c7-9baa-4478-923e-a6280101c98a	2026-08-31 15:16	2026-08-31 15:16	2026-08-31 15:16	ALLY	ALLY260918C00042000	call	42.0000	2026-09-18	1.2400	1.0000	1.2500	42.1200	245520.00	245520.00	0.00	1980	2	6980	135	51.7037037037037	0.305613257030931	0.305613257030931	false	true	true	false
139c5aaa-d82e-4c33-87f9-8caed4ea88b7	2026-08-28 12:48	2026-08-28 12:48	2026-08-28 12:48	ALLY	ALLY260918C00043000	call	43.0000	2026-09-18	0.9000	0.7000	0.9500	42.4050	42210.00	31680.00	10530.00	469	23	2305	4761	0.484141986977526	0.282538348857656	0.277593321912743	false	false	false	true
1907587c-54c7-4b60-951d-ca7fc134102c	2026-08-28 12:47	2026-08-28 12:47	2026-08-28 12:47	ALLY	ALLY260918C00043000	call	43.0000	2026-09-18	0.8500	0.7000	0.8500	42.3900	25075.00	25075.00	0.00	295	22	1704	4761	0.357908002520479	0.266776428643212	0.266776428643212	false	false	false	true
b8d33ed6-007a-4977-a8d3-f861d59051ae	2026-08-28 12:47	2026-08-28 12:47	2026-08-28 12:47	ALLY	ALLY260918C00043000	call	43.0000	2026-09-18	0.8000	0.6500	0.8500	42.2450	88640.00	7760.00	53760.00	1108	49	1409	4761	0.295946229783659	0.269792601574083	0.269792601574083	true	false	false	true
ac3a0f8b-d26f-4f97-bb0b-6b74faa0e5c3	2026-08-28 09:39	2026-08-28 09:39	2026-08-28 09:39	ALLY	ALLY260918C00043000	call	43.0000	2026-09-18	1.0500	1.0500	1.2000	42.8100	22680.00	0.00	22680.00	216	30	220	4761	0.0462087796681369	0.267595254980109	0.267595254980109	false	false	false	true
2496d9bb-40a3-47b6-a51d-c1ad747463d1	2026-08-27 15:09	2026-08-27 15:09	2026-08-27 15:09	ALLY	ALLY260918C00043000	call	43.0000	2026-09-18	1.1500	1.0500	1.2000	42.9200	67038.00	67038.00	0.00	583	34	4007	171	23.4327485380117	0.271483842536761	0.271483842536761	true	false	false	true
c1e86107-0124-4c90-b76c-cdce0c0719aa	2026-08-27 11:52	2026-08-27 11:51	2026-08-27 11:51	ALLY	ALLY261016C00045000	call	45.0000	2026-10-16	1.0000	0.9000	1.0000	43.0300	38591.00	38591.00	0.00	386	39	572	153	3.73856209150327	0.267266047335445	0.267266047335445	false	false	false	true
32d6b296-c0c5-46e3-9389-b6a91399ab22	2026-08-27 11:14	2026-08-27 11:14	2026-08-27 11:14	ALLY	ALLY261016C00045000	call	45.0000	2026-10-16	0.9500	0.9000	0.9500	42.8150	17385.00	17385.00	0.00	183	24	184	153	1.20261437908497	0.271718757666852	0.271718757666852	false	false	false	true
0a6fef9d-4f7f-4c99-b31f-56b0083eddab	2026-08-27 10:59	2026-08-27 10:59	2026-08-27 10:59	ALLY	ALLY260918C00043000	call	43.0000	2026-09-18	1.1000	1.0500	1.1000	42.8500	34320.00	34320.00	0.00	312	26	3112	171	18.1988304093567	0.268092390070894	0.268092390070894	false	false	false	true
93af2a81-ca3e-420b-a5e7-89fa8d805827	2026-08-27 10:57	2026-08-27 10:56	2026-08-27 10:56	ALLY	ALLY260918C00043000	call	43.0000	2026-09-18	1.0500	1.0000	1.1000	42.7900	19740.00	14070.00	5670.00	188	28	2780	171	16.2573099415205	0.263342822711629	0.263342822711629	true	false	false	true
0ffb6366-890a-4254-9cf2-66ff4ca3e5df	2026-08-27 10:53	2026-08-27 10:53	2026-08-27 10:53	ALLY	ALLY261218P00040000	put	40.0000	2026-12-18	1.4000	1.3500	1.5000	42.8122	72660.00	2520.00	63980.00	519	60	2001	11	181.909090909091	0.299915618234761	0.299915618234761	true	false	false	true
dc1b7524-2fea-415f-84b8-c47b4bd1824a	2026-08-27 10:46	2026-08-27 10:45	2026-08-27 10:45	ALLY	ALLY261218P00040000	put	40.0000	2026-12-18	1.4000	1.3500	1.4000	42.7800	57540.00	34720.00	0.00	411	62	1475	11	134.090909090909	0.298775482302365	0.298775482302365	true	false	false	true
b85a86ec-d1e7-4bf3-8689-a88b2c5b21d5	2026-08-27 10:43	2026-08-27 10:43	2026-08-27 10:43	ALLY	ALLY261218P00040000	put	40.0000	2026-12-18	1.4500	1.4000	1.6000	42.6500	87435.00	1740.00	58000.00	603	47	1018	11	92.5454545454545	0.300262653006703	0.300262653006703	true	false	false	true
4950da20-9c17-42b2-96ae-827b2a12e92d	2026-08-27 10:43	2026-08-27 10:43	2026-08-27 10:43	ALLY	ALLY261218P00040000	put	40.0000	2026-12-18	1.5000	1.4000	1.5000	42.6200	12300.00	12300.00	0.00	82	16	415	11	37.7272727272727	0.305271967573103	0.305271967573103	false	false	false	true
d9f7369b-05a3-4cb0-81a0-2fd0619d30ca	2026-08-27 10:43	2026-08-27 10:43	2026-08-27 10:43	ALLY	ALLY261218P00040000	put	40.0000	2026-12-18	1.5500	1.5000	1.6500	42.4250	51460.00	155.00	51305.00	332	11	333	11	30.2727272727273	0.304176210456368	0.304176210456368	false	false	false	true
5d6a19e0-e485-43ef-9b9a-21a954e386f2	2026-08-27 10:43	2026-08-27 10:43	2026-08-27 10:43	ALLY	ALLY260918C00043000	call	43.0000	2026-09-18	0.8800	0.7000	0.9500	42.5300	191565.00	107960.00	26995.00	2179	66	2179	171	12.7426900584795	0.251608863186899	0.25713814385259	true	false	false	true
c32d9605-8f39-44fe-a331-f2c2f9a1057f	2026-08-25 15:07	2026-08-25 15:06	2026-08-25 15:06	ALLY	ALLY270115C00040000	call	40.0000	2027-01-15	4.8000	4.6000	4.8000	42.5950	24000.00	24000.00	0.00	50	5	101	372	0.271505376344086	0.285602428815395	0.285602428815395	false	false	false	true
67b7767e-e5af-4527-a6cc-7cff40136002	2026-08-25 14:59	2026-08-25 14:59	2026-08-25 14:59	ALLY	ALLY270115C00042000	call	42.0000	2027-01-15	3.6000	3.3000	3.6000	42.6225	37800.00	37800.00	0.00	105	31	500	77	6.49350649350649	0.279038633186531	0.279038633186531	false	false	false	true
d1d150e9-a372-4e69-9236-efec313999ee	2026-08-25 14:58	2026-08-25 14:58	2026-08-25 14:58	ALLY	ALLY261016C00044000	call	44.0000	2026-10-16	1.2000	1.1000	1.2000	42.6100	27840.00	27840.00	0.00	232	24	232	2	116	0.263844827637562	0.263844827637562	false	false	false	true