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:endpoint = /api/option-trades/flow-alerts×ticker = PRU×

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

72a2698b-c6dc-4adb-a902-c25bbec5967d	2026-09-24 15:55	2026-09-24 15:55	2026-09-24 15:55	PRU	PRU261016P00115000	put	115.0000	2026-10-16	1.4000	1.3500	1.4000	118.9700	26038.00	26038.00	0.00	186	10	324	223	1.45291479820628	0.266013319800535	0.268052616392256	true	false	false	true	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	Common Stock	Financial Services	40568550000.00	2026-11-04	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-24T19:58:08.680508Z"}	2026-09-24	2026-09-24 21:15	2026-09-24 21:15
4211859e-a21c-426b-a326-c42c428f060c	2026-09-24 15:25	2026-09-24 15:25	2026-09-24 15:25	PRU	PRU261218P00105000	put	105.0000	2026-12-18	1.8500	1.3000	2.0500	119.3300	57715.00	57715.00	0.00	312	37	312	349	0.893982808022923	0.327184438206293	0.326834137869001	true	false	false	true
6f0362df-5880-4fe2-bb48-3f90e6f931d6	2026-09-22 09:45	2026-09-22 09:45	2026-09-22 09:45	PRU	PRU290119C00120000	call	120.0000	2029-01-19	15.8000	15.8000	20.0000	118.0000	25280.00	0.00	25280.00	16	7	16	4	4	0.138378389353931	0.138378389353931	false	false	false	true
27c6991a-ceda-4f5d-ad9f-73f5fb22aab4	2026-09-21 10:58	2026-09-21 10:57	2026-09-21 10:57	PRU	PRU261120P00120000	put	120.0000	2026-11-20	5.8000	5.7000	6.1000	118.5500	167040.00	166460.00	580.00	288	19	291	50	5.82	0.284753530678171	0.284753530678171	false	false	false	true
76abc27b-c418-412a-820c-144330ce8001	2026-09-18 11:56	2026-09-18 11:56	2026-09-18 11:56	PRU	PRU261016C00120000	call	120.0000	2026-10-16	2.1000	2.0000	2.1500	117.4300	11550.00	1680.00	9870.00	55	5	86	184	0.467391304347826	0.235034360521884	0.235034360521884	false	false	false	true
eaf88a96-d422-4402-b8f5-1a1653f9ba5e	2026-09-16 14:54	2026-09-16 14:54	2026-09-16 14:54	PRU	PRU261120P00110000	put	110.0000	2026-11-20	2.5500	1.8000	2.6000	117.4500	65515.00	45370.00	18360.00	257	9	261	15	17.4	0.303715533243288	0.302254710719971	false	false	false	true
98e75196-3659-41b6-a000-cae8d9f87654	2026-09-15 15:30	2026-09-15 15:30	2026-09-15 15:30	PRU	PRU260918C00120000	call	120.0000	2026-09-18	1.2000	1.2000	1.3000	119.4600	35400.00	0.00	35400.00	295	5	761	1940	0.392268041237113	0.331834572466708	0.331834572466708	false	false	false	true
1b2c2371-06b8-4861-82e7-50388f7b62ab	2026-09-11 10:47	2026-09-11 10:47	2026-09-11 10:47	PRU	PRU270115C00135000	call	135.0000	2027-01-15	1.6000	1.2000	1.6000	117.6700	24960.00	24960.00	0.00	156	6	158	526	0.300380228136882	0.22703080191041	0.22703080191041	false	false	false	true
6955faa3-c87f-4b2a-850c-42f667594e8f	2026-09-10 10:34	2026-09-10 10:34	2026-09-10 10:34	PRU	PRU280121P00125000	put	125.0000	2028-01-21	17.8900	15.6000	18.6000	118.7400	21470.00	21470.00	0.00	12	6	17	174	0.0977011494252874	0.324952973783178	0.322605297930243	true	false	false	true
93e04566-010d-47ce-8f14-a94f91ccd815	2026-09-09 15:33	2026-09-09 15:33	2026-09-09 15:33	PRU	PRU261120P00120000	put	120.0000	2026-11-20	6.8000	6.8000	7.7000	117.7000	10880.00	0.00	10880.00	16	8	32	34	0.941176470588235	0.290531379748088	0.290531379748088	false	false	false	true
456e2eb6-14f9-4336-9e15-dc476e1a1e01	2026-09-09 15:33	2026-09-09 15:32	2026-09-09 15:32	PRU	PRU261120P00120000	put	120.0000	2026-11-20	6.8000	6.8000	7.7000	117.5800	10880.00	0.00	10880.00	16	6	16	34	0.470588235294118	0.28758266534163	0.28758266534163	false	false	false	true
7dfd303a-88f4-448e-9257-7c15e858bdbd	2026-09-09 13:48	2026-09-09 13:48	2026-09-09 13:48	PRU	PRU261120C00115000	call	115.0000	2026-11-20	7.6000	7.1000	8.2000	117.8100	12160.00	9120.00	3040.00	16	6	60	0	0	0.270539948956521	0.270539948956521	false	false	false	true
6c781b03-2097-4ac1-8fd6-cb1dd55cdee5	2026-09-09 10:34	2026-09-09 10:33	2026-09-09 10:33	PRU	PRU260918P00120000	put	120.0000	2026-09-18	2.2300	2.2000	2.2500	119.0000	39293.00	26973.00	12320.00	176	25	176	480	0.366666666666667	0.267157426672991	0.267157426672991	false	false	false	true
2a610f7f-2f70-4aad-975d-4f33082e1da2	2026-09-09 10:34	2026-09-09 10:33	2026-09-09 10:33	PRU	PRU261016P00125000	put	125.0000	2026-10-16	7.0700	7.0000	7.1000	119.0000	70000.00	49700.00	20300.00	99	21	99	52	1.90384615384615	0.261742949559062	0.261742949559062	false	false	false	true
5b9768c1-38cf-4a27-af8f-0f98c66ef9db	2026-09-02 10:11	2026-09-02 10:11	2026-09-02 10:11	PRU	PRU270917P00120000	put	120.0000	2027-09-17	12.8600	12.8000	13.2000	119.6200	27010.00	0.00	27010.00	21	6	39	94	0.414893617021277	0.321574060826956	0.319429909650833	false	false	false	true
eeb06c1e-b99b-4f39-9549-f05beb198385	2026-09-01 14:42	2026-09-01 14:42	2026-09-01 14:42	PRU	PRU261120C00125000	call	125.0000	2026-11-20	2.3000	2.3000	2.6000	116.8300	23922.00	0.00	23922.00	104	6	107	2	53.5	0.226171231395768	0.226171231395768	false	false	false	true
9e879530-1e20-4f13-82a1-1a2aaab4d774	2026-09-01 13:49	2026-09-01 13:49	2026-09-01 13:49	PRU	PRU271217C00120000	call	120.0000	2027-12-17	12.8000	12.3000	12.8000	117.0600	37120.00	37120.00	0.00	29	11	29	157	0.184713375796178	0.208979661526036	0.208979661526036	true	false	false	true
b975705b-fe43-4530-a366-33b0364d72ff	2026-08-31 14:01	2026-08-31 14:00	2026-08-31 14:00	PRU	PRU280121C00145000	call	145.0000	2028-01-21	5.2900	4.7000	5.9000	117.0000	23270.00	15850.00	7420.00	44	8	50	69	0.72463768115942	0.209482140991912	0.209482140991912	false	false	false	true
db6d84d0-f395-4321-b019-8a5fbd013337	2026-08-25 13:20	2026-08-25 13:20	2026-08-25 13:20	PRU	PRU261218C00125000	call	125.0000	2026-12-18	4.1000	3.9000	4.1000	119.1900	22550.00	22550.00	0.00	55	12	75	1996	0.0375751503006012	0.220997947645581	0.220997947645581	false	false	false	true
72b2e4b5-084e-4883-b993-bfc93517026f	2026-08-25 10:47	2026-08-25 10:47	2026-08-25 10:47	PRU	PRU261016C00125000	call	125.0000	2026-10-16	1.7000	1.5500	1.7000	118.0900	44710.00	44710.00	0.00	263	40	449	61	7.36065573770492	0.223788849615126	0.223788849615126	false	false	false	true
d71a58fa-3344-4ca2-b3f9-82c4d70a27b0	2026-08-25 10:28	2026-08-25 10:28	2026-08-25 10:28	PRU	PRU261218C00105000	call	105.0000	2026-12-18	16.0200	15.6000	16.2000	118.4813	11214.00	11214.00	0.00	7	5	33	1224	0.0269607843137255	0.239014451440438	0.239014451440438	false	false	false	true
71543f42-3c18-486e-b135-3a7eb4dc927c	2026-08-25 10:12	2026-08-25 10:12	2026-08-25 10:12	PRU	PRU261016C00125000	call	125.0000	2026-10-16	1.7000	1.7000	1.8250	118.5000	14280.00	0.00	14280.00	84	6	113	61	1.85245901639344	0.216028987122068	0.216028987122068	false	false	false	true
3a2093bc-5f33-4181-97a4-46aecbcbbe06	2026-08-24 14:20	2026-08-24 14:20	2026-08-24 14:20	PRU	PRU270115C00130000	call	130.0000	2027-01-15	3.5000	3.1000	3.5000	121.8550	89250.00	89250.00	0.00	255	31	257	1964	0.130855397148676	0.194438080292935	0.194438080292935	false	false	false	true
bddd4d5b-e6de-414d-b4ce-cc22cc6bc30d	2026-08-21 15:11	2026-08-21 15:11	2026-08-21 15:11	PRU	PRU261218C00135000	call	135.0000	2026-12-18	1.7000	1.4000	1.7000	121.0200	14110.00	14110.00	0.00	83	28	97	476	0.203781512605042	0.204737846834404	0.204737846834404	false	false	false	true
7800ee57-ab29-4e01-aa4a-a268e27e4b12	2026-08-21 12:37	2026-08-21 12:37	2026-08-21 12:37	PRU	PRU261218C00125000	call	125.0000	2026-12-18	4.5000	4.2000	4.5000	121.3450	34200.00	34200.00	0.00	76	22	84	992	0.0846774193548387	0.196635371240313	0.196635371240313	false	false	false	true
9d23e32c-0700-4fab-88d5-e785d0caa714	2026-08-20 14:16	2026-08-20 14:15	2026-08-20 14:15	PRU	PRU260918P00120000	put	120.0000	2026-09-18	2.6000	2.5000	2.7000	121.5200	20280.00	260.00	20020.00	78	7	164	299	0.548494983277592	0.25512633006831	0.25512633006831	false	false	false	true
08d66b13-3e26-4186-b5b5-54f1cbc77770	2026-08-20 12:14	2026-08-20 12:14	2026-08-20 12:14	PRU	PRU260918P00120000	put	120.0000	2026-09-18	2.5000	2.3000	2.8500	121.7100	19250.00	8000.00	11250.00	77	9	83	299	0.277591973244147	0.253248641374305	0.253248641374305	false	false	false	true
ff3756ca-3dd2-4f87-a31e-955c6383c9af	2026-08-19 15:09	2026-08-19 15:09	2026-08-19 15:09	PRU	PRU270617C00160000	call	160.0000	2027-06-17	1.6500	0.7000	1.6500	122.7850	13200.00	13200.00	0.00	80	9	151	0	0	0.218797898588373	0.218797898588373	false	false	false	true
1c797b77-236d-467c-8e80-2121bb2cd950	2026-08-19 13:45	2026-08-19 13:45	2026-08-19 13:45	PRU	PRU280121C00125000	call	125.0000	2028-01-21	13.7000	13.7000	14.0000	122.8100	26030.00	0.00	26030.00	19	6	45	261	0.172413793103448	0.192309881272154	0.192309881272154	false	false	false	true
30749b4f-b1e0-44f5-ba36-f69c6509e9ce	2026-08-18 14:13	2026-08-18 14:13	2026-08-18 14:13	PRU	PRU280121C00120000	call	120.0000	2028-01-21	17.7000	17.0000	17.7000	125.4600	28320.00	28320.00	0.00	16	7	59	222	0.265765765765766	0.182063602328485	0.182063602328485	false	false	false	true
9f4fb35b-b7df-4c3a-9673-db7e65c2ce29	2026-08-18 10:26	2026-08-18 10:26	2026-08-18 10:26	PRU	PRU260918P00120000	put	120.0000	2026-09-18	1.5500	1.4500	1.6000	125.3750	11625.00	11315.00	155.00	75	5	204	264	0.772727272727273	0.26327327300361	0.26327327300361	true	false	false	true
46fc3dac-e2d4-4592-98fe-6e80ce74b295	2026-08-17 14:40	2026-08-17 14:40	2026-08-17 14:40	PRU	PRU270617C00125000	call	125.0000	2027-06-17	10.3800	10.2000	11.5000	124.9100	33212.00	0.00	33212.00	32	9	35	161	0.217391304347826	0.180113292531672	0.191991243438068	false	false	false	true