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.

474,253 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts474,253 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

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

06cbabef-a3dc-443c-9145-60cf7466eaaf	2026-09-25 15:42	2026-09-25 15:42	2026-09-25 15:42	ALLY	ALLY261016C00039000	call	39.0000	2026-10-16	1.0500	0.9000	1.1000	38.0000	32970.00	10500.00	22470.00	314	16	391	48	8.14583333333333	0.288246565194889	0.288246565194889	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Financial Services	11799906091.00	2026-10-20	premarket	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-25T19:44:21.808017Z"}	2026-09-25	2026-09-25 21:15	2026-09-25 21:15
241439ae-1a98-4554-8d8c-024acbb671f7	2026-09-25 11:18	2026-09-25 11:18	2026-09-25 11:18	ALLY	ALLY261218P00039000	put	39.0000	2026-12-18	2.4000	2.2000	2.4500	38.5500	21600.00	21360.00	240.00	90	6	90	61	1.47540983606557	0.320464001163656	0.320464001163656	false	false	false	true
124cab38-1e0d-426d-a67c-7bc05d53dd99	2026-09-25 10:44	2026-09-25 10:44	2026-09-25 10:44	ALLY	ALLY261218P00037000	put	37.0000	2026-12-18	1.5900	1.2000	1.9000	38.4600	17340.00	17030.00	310.00	109	5	109	118	0.923728813559322	0.330102176952683	0.334489279162152	false	false	false
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
4c2abf7d-9dca-4e01-bedf-6f4700c17b7d	2026-08-25 14:12	2026-08-25 14:12	2026-08-25 14:12	ALLY	ALLY270115C00049000	call	49.0000	2027-01-15	0.9500	0.8500	1.0000	42.0000	19093.00	18998.00	0.00	201	35	201	93	2.16129032258065	0.261915623660696	0.261592202741729	true	false	false
a623ed6d-9010-497a-9060-b15dba771e46	2026-08-24 15:51	2026-08-24 15:51	2026-08-24 15:51	ALLY	ALLY261120P00041000	put	41.0000	2026-11-20	1.7000	1.5500	1.7000	42.5100	35700.00	35700.00	0.00	210	5	642	22	29.1818181818182	0.311628593725778	0.311628593725778	false	false	false	true
b63070fb-bec6-4ccb-b584-d9dfc6b74f1b	2026-08-24 15:31	2026-08-24 15:31	2026-08-24 15:31	ALLY	ALLY261120P00041000	put	41.0000	2026-11-20	1.6000	1.2000	1.8500	42.4900	62080.00	2400.00	52640.00	388	6	388	22	17.6363636363636	0.297819229203891	0.297819229203891	false	false	false
0593c957-cb10-4c0f-b820-f44fdd477e79	2026-08-21 09:39	2026-08-21 09:39	2026-08-21 09:39	ALLY	ALLY261016C00038000	call	38.0000	2026-10-16	5.3000	5.3000	5.9000	42.9400	104411.00	0.00	104411.00	197	35	197	0	0	0.235458634961497	0.235458634961497	true	false	false	true