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

3b867f63-34fd-456d-93b4-c3fce316c7aa	2026-08-17 13:26	2026-08-17 13:26	2026-08-17 13:26	PSX	PSX270219C00280000	call	280.0000	2027-02-19	12.2500	12.2000	12.3000	240.0901	84550.00	45510.00	39040.00	69	11	69	8	8.625	0.355236947389885	0.355236947389885	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Energy	102572316667.00	2026-11-04	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-17T17:44:03.146928Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
6d12971c-edbb-47b2-b96d-ac9fad0422c9	2026-08-17 14:24	2026-08-17 14:24	2026-08-17 14:24	PSX	PSX270115C00260000	call	260.0000	2027-01-15	15.6000	15.2000	15.7000	239.6600	113880.00	113880.00	0.00	73	23	232	126	1.84126984126984	0.358976165253493	0.358976165253493	false	false	false
20ab817b-7b9b-44a1-b032-b4a4a1bec819	2026-08-18 13:34	2026-08-18 13:34	2026-08-18 13:34	PSX	PSX261120C00250000	call	250.0000	2026-11-20	15.8000	15.4000	16.0000	240.9600	67920.00	63200.00	4720.00	43	13	59	180	0.327777777777778	0.382728988145207	0.378625584445902	true	false	false
2388310c-cb08-4cb6-99fc-66116ea7fec6	2026-08-19 12:41	2026-08-19 12:41	2026-08-19 12:41	PSX	PSX260918C00260000	call	260.0000	2026-09-18	4.0000	3.9000	4.3000	242.0050	120400.00	96400.00	24000.00	301	7	1034	606	1.70627062706271	0.363682207859189	0.363682207859189	false	false	false
d66488f9-9fa8-42af-8dca-326f8f35a771	2026-08-20 09:42	2026-08-20 09:42	2026-08-20 09:42	PSX	PSX260821C00240000	call	240.0000	2026-08-21	6.0000	4.8000	6.0000	245.5400	75000.00	75000.00	0.00	125	13	125	443	0.282167042889391	0.428630583799802	0.428630583799802	false	false	false
7ea7933b-3b93-45d2-9ba7-02ee19dcc659	2026-08-20 10:01	2026-08-20 10:01	2026-08-20 10:01	PSX	PSX261218C00290000	call	290.0000	2026-12-18	8.5000	7.9000	8.5000	245.8500	95200.00	95200.00	0.00	112	26	112	176	0.636363636363636	0.385496511170833	0.385496511170833	false	false	false
79ddfa42-3fd6-4d94-ada8-d1551fe1d536	2026-08-21 10:44	2026-08-21 10:43	2026-08-21 10:43	PSX	PSX270115P00230000	put	230.0000	2027-01-15	15.9000	14.8000	17.0000	243.6400	55650.00	50880.00	0.00	35	7	35	66	0.53030303030303	0.396692257263222	0.396692257263222	false	false	false
b1c78485-34c7-4b87-87f3-0aad118aee30	2026-08-21 13:42	2026-08-21 13:42	2026-08-21 13:42	PSX	PSX261218C00290000	call	290.0000	2026-12-18	7.7000	7.3000	7.7000	242.8400	157080.00	157080.00	0.00	204	23	204	278	0.733812949640288	0.387660237368699	0.387660237368699	false	false	false
cb831c71-cd54-4a70-95fe-0a879a72f60d	2026-08-24 12:13	2026-08-24 12:13	2026-08-24 12:13	PSX	PSX261016P00200000	put	200.0000	2026-10-16	1.7500	1.6000	1.7500	240.8500	208075.00	208075.00	0.00	1189	26	2000	141	14.1843971631206	0.405616491886681	0.405582887565798	false	false	false
0de4ecc3-7cd2-4ff2-9e27-495e4c94b5ef	2026-08-31 13:09	2026-08-31 13:09	2026-08-31 13:09	PSX	PSX270617P00240000	put	240.0000	2027-06-17	28.2900	27.9000	28.8000	244.6300	161260.00	152770.00	8490.00	57	16	57	215	0.265116279069767	0.405056245990774	0.405056245990774	false	false	false
0efb027f-6a48-47c0-87db-82d9ae8ffd3a	2026-09-01 12:43	2026-09-01 12:43	2026-09-01 12:43	PSX	PSX280121P00270000	put	270.0000	2028-01-21	50.5000	48.5000	50.5000	248.8000	55550.00	55550.00	0.00	11	5	11	0	0	0.407695763287116	0.407695763287116	false	false	false	true
c77144af-c918-47a9-9856-1ff1ba10d5a3	2026-09-02 14:08	2026-09-02 14:08	2026-09-02 14:08	PSX	PSX270617P00250000	put	250.0000	2027-06-17	29.4000	28.3000	29.4000	257.6050	82320.00	82320.00	0.00	28	13	34	41	0.829268292682927	0.417461749011996	0.417461749011996	false	false	false
fefb2e38-772b-4e93-929b-a724d1e4599b	2026-09-03 10:59	2026-09-03 10:59	2026-09-03 10:59	PSX	PSX260911C00257500	call	257.5000	2026-09-11	6.7100	6.1000	8.3000	259.8000	152940.00	51810.00	101130.00	228	6	374	18	20.7777777777778	0.350204232530817	0.350273570908346	false	false	false
4243c1c7-34c7-475a-b99c-6ed6f780299c	2026-09-03 12:17	2026-09-03 12:17	2026-09-03 12:17	PSX	PSX260918C00257500	call	257.5000	2026-09-18	8.5000	8.5000	9.6000	258.2650	90100.00	0.00	90100.00	106	8	107	10	10.7	0.379238387362575	0.379238387362575	false	false	false
c198b04c-0228-46ae-ad49-7dbc8d1ac240	2026-09-03 13:31	2026-09-03 13:31	2026-09-03 13:31	PSX	PSX261120C00260000	call	260.0000	2026-11-20	19.8000	19.3000	19.8000	258.4650	69300.00	69300.00	0.00	35	11	60	331	0.181268882175227	0.409816711485855	0.409816711485855	false	false	false
791b66b8-5ee3-414e-862e-1019a0349440	2026-09-03 14:21	2026-09-03 14:21	2026-09-03 14:21	PSX	PSX270617P00280000	put	280.0000	2027-06-17	47.5000	46.5000	47.5000	256.1700	85500.00	85500.00	0.00	18	7	23	0	0	0.427902039045534	0.427902039045534	false	false	false	true
9ace7aad-b635-45d2-9e23-7302dc3e53c0	2026-09-04 11:34	2026-09-04 11:34	2026-09-04 11:34	PSX	PSX261120C00280000	call	280.0000	2026-11-20	10.9000	10.3000	11.4000	256.4150	71940.00	71940.00	0.00	66	20	73	264	0.276515151515151	0.404354891366465	0.404354891366465	false	false	false
3983b522-41ee-425e-a1fd-19bd9234386c	2026-09-08 11:04	2026-09-08 11:04	2026-09-08 11:04	PSX	PSX261218C00220000	call	220.0000	2026-12-18	47.4300	46.4000	48.5000	258.7400	109081.00	0.00	37906.00	23	10	37	855	0.0432748538011696	0.412071331163781	0.412071331163781	false	false	false
6d05544f-dc48-4c1d-b587-cc3dcd12fb9f	2026-09-10 11:24	2026-09-10 11:24	2026-09-10 11:24	PSX	PSX280121C00300000	call	300.0000	2028-01-21	37.5000	34.5000	37.5000	261.3400	375000.00	375000.00	0.00	100	25	100	6	16.6666666666667	0.385465377727697	0.385465377727697	true	false	false
299c9023-333e-426a-bac6-09c40f7ec4ce	2026-09-10 14:51	2026-09-10 14:51	2026-09-10 14:51	PSX	PSX261218P00240000	put	240.0000	2026-12-18	12.4000	12.1000	12.5000	261.0200	52080.00	40920.00	0.00	42	42	107	632	0.169303797468354	0.43104211246693	0.43104211246693	false	false	false
b91d8d6c-158d-4614-9c82-4ffa275cd177	2026-09-14 11:06	2026-09-14 11:06	2026-09-14 11:06	PSX	PSX270319C00230000	call	230.0000	2027-03-19	47.7000	47.7000	50.2000	259.8600	162180.00	0.00	162180.00	34	9	34	135	0.251851851851852	0.398723778854911	0.398723778854911	false	false	false
557315bc-0c9b-4a0a-aa5e-01c8b250d593	2026-09-14 11:06	2026-09-14 11:06	2026-09-14 11:06	PSX	PSX261218C00240000	call	240.0000	2026-12-18	33.3000	33.3000	35.8000	259.3250	163170.00	0.00	163170.00	49	10	60	92	0.652173913043478	0.406818769330318	0.406818769330318	false	false	false
4c8ab2ad-2ed5-4e0c-9346-de0146ba7f18	2026-09-14 11:06	2026-09-14 11:06	2026-09-14 11:06	PSX	PSX261218C00230000	call	230.0000	2026-12-18	39.7000	39.7000	42.4000	259.3250	154830.00	0.00	154830.00	39	5	39	272	0.143382352941176	0.402711000164568	0.402711000164568	false	false	false
a76f2ccd-cec7-4564-887a-46e0fc49f62f	2026-09-14 13:13	2026-09-14 13:13	2026-09-14 13:13	PSX	PSX270319P00230000	put	230.0000	2027-03-19	16.6000	16.6000	17.2000	255.0000	84660.00	0.00	84660.00	51	19	92	33	2.78787878787879	0.423356881608374	0.423356881608374	true	false	false
dcf5e8da-6acc-45da-a1b6-2b8542aad9c7	2026-09-15 11:52	2026-09-15 11:52	2026-09-15 11:52	PSX	PSX261218P00260000	put	260.0000	2026-12-18	20.4000	19.5000	20.4000	263.7250	81600.00	81600.00	0.00	40	18	53	224	0.236607142857143	0.446828240424817	0.446828240424817	false	false	false
c385001d-cb98-4580-b259-65318000331d	2026-09-15 12:11	2026-09-15 12:10	2026-09-15 12:10	PSX	PSX270115P00250000	put	250.0000	2027-01-15	18.1000	18.1000	18.2000	263.9000	237110.00	0.00	215390.00	131	11	154	65	2.36923076923077	0.436989018969446	0.436989018969446	false	false	false
dbcb2daa-00ae-4c99-a026-1b442229fdd4	2026-09-15 12:11	2026-09-15 12:11	2026-09-15 12:11	PSX	PSX270115P00250000	put	250.0000	2027-01-15	18.3000	17.6000	18.3000	263.5000	188442.00	188442.00	0.00	103	20	280	65	4.30769230769231	0.436634812009962	0.438050857639149	false	false	false
06f8615e-9638-4780-a864-40ffaef2d169	2026-09-15 13:00	2026-09-15 13:00	2026-09-15 13:00	PSX	PSX261120C00280000	call	280.0000	2026-11-20	14.7000	14.4000	14.7000	265.8000	144060.00	144060.00	0.00	98	10	99	319	0.310344827586207	0.438403375664931	0.438403375664931	false	false	false
04dc0a25-7a8d-4649-beb9-a43bc9b7a33b	2026-09-15 14:03	2026-09-15 14:03	2026-09-15 14:03	PSX	PSX261218P00260000	put	260.0000	2026-12-18	19.8000	19.7000	20.2000	265.5100	69300.00	13860.00	55440.00	35	13	121	224	0.540178571428571	0.449215623502401	0.449215623502401	false	false	false
353ec7f0-38da-479f-a8ba-93fc5f4ad9d4	2026-09-17 09:30	2026-09-17 09:30	2026-09-17 09:30	PSX	PSX260918C00230000	call	230.0000	2026-09-18	34.6300	29.6500	34.6500	261.1100	110800.00	110800.00	0.00	32	12	37	490	0.0755102040816327	2.69481352445989	2.69481352445989	true	false	false
f0b100de-a025-4de8-bcc1-e09d7eb33d1f	2026-09-17 15:25	2026-09-17 15:25	2026-09-17 15:25	PSX	PSX261120P00270000	put	270.0000	2026-11-20	18.3000	17.8000	18.8000	272.2700	65880.00	64050.00	1830.00	36	10	165	122	1.35245901639344	0.451409077652092	0.451409077652092	false	false	false
65276bbf-3341-4e19-a798-55fa0ffe200b	2026-09-18 13:46	2026-09-18 13:46	2026-09-18 13:46	PSX	PSX261120C00270000	call	270.0000	2026-11-20	21.5000	20.7000	21.5000	271.7400	51593.00	51593.00	0.00	24	12	39	297	0.131313131313131	0.439170796997983	0.439170796997983	false	false	false
f240acd8-d02f-4b0a-8eef-4bc96058d740	2026-09-21 10:29	2026-09-21 10:29	2026-09-21 10:29	PSX	PSX260925C00275000	call	275.0000	2026-09-25	2.4000	2.4000	2.6500	267.7450	12960.00	0.00	12960.00	54	11	119	116	1.02586206896552	0.459755218619182	0.459755218619182	true	false	false
625582e3-aec2-4ae2-a08b-c91562e93f71	2026-09-21 10:42	2026-09-21 10:42	2026-09-21 10:42	PSX	PSX260925C00280000	call	280.0000	2026-09-25	1.4000	1.3000	1.8000	268.2970	11480.00	1680.00	8400.00	82	13	654	553	1.18264014466546	0.462518026111492	0.462518026111492	true	false	false
2cae9d63-3937-4252-a487-eeb2a4f7be5b	2026-09-21 10:49	2026-09-21 10:49	2026-09-21 10:49	PSX	PSX260925P00250000	put	250.0000	2026-09-25	0.8000	0.7000	1.0000	266.9800	48560.00	0.00	40960.00	607	50	613	104	5.89423076923077	0.526833857306581	0.526833857306581	false	false	false
2bd04150-1293-4612-a33f-dce231896663	2026-09-21 12:22	2026-09-21 12:21	2026-09-21 12:21	PSX	PSX261218C00290000	call	290.0000	2026-12-18	14.1500	13.8000	14.4000	265.7550	42450.00	25470.00	0.00	30	5	49	600	0.0816666666666667	0.431115289483578	0.431115289483578	false	false	false
c4c9cd10-aef7-404d-b528-347a9d7135b5	2026-09-21 14:02	2026-09-21 14:02	2026-09-21 14:02	PSX	PSX260925P00250000	put	250.0000	2026-09-25	0.6300	0.4500	0.9500	265.0000	20003.00	943.00	19060.00	317	64	1337	104	12.8557692307692	0.476239012534961	0.465915487540837	true	false	false
9f44e4cc-e8ac-4de2-9a8f-0de6ebd1e31c	2026-09-21 15:30	2026-09-21 15:30	2026-09-21 15:30	PSX	PSX261016P00245000	put	245.0000	2026-10-16	5.2000	4.7000	5.2000	259.0000	28080.00	28080.00	0.00	54	8	72	0	0	0.431109913558331	0.430325894037313	false	false	false	true
50007b6f-ff04-499e-9788-818a9d313c54	2026-09-21 15:30	2026-09-21 15:30	2026-09-21 15:30	PSX	PSX261002P00257500	put	257.5000	2026-10-02	6.7000	5.9000	6.7000	259.0000	11390.00	11390.00	0.00	17	5	18	8	2.25	0.447165059803619	0.445586481247176	false	false	false	true
06f740c0-3a71-4ce9-90df-e0d9ac0bb05a	2026-09-22 10:01	2026-09-22 10:00	2026-09-22 10:00	PSX	PSX261016P00250000	put	250.0000	2026-10-16	7.8000	7.8000	8.9000	257.0000	10920.00	0.00	10920.00	14	5	38	392	0.0969387755102041	0.438886781087394	0.438886781087394	false	false	false
efc13582-4937-412f-a63d-a257253dc5ed	2026-09-22 10:12	2026-09-22 10:12	2026-09-22 10:12	PSX	PSX261009P00230000	put	230.0000	2026-10-09	1.4000	1.3500	1.7000	258.4055	12180.00	3500.00	8680.00	87	15	180	10	18	0.462039744300247	0.462039744300247	false	false	false	true
9d643d41-0ec9-47fd-97e3-063248323f88	2026-09-22 10:21	2026-09-22 10:21	2026-09-22 10:21	PSX	PSX261016C00270000	call	270.0000	2026-10-16	7.2000	6.4000	7.3000	258.7500	30956.00	30956.00	0.00	43	7	51	636	0.080188679245283	0.43446532939284	0.43446532939284	true	false	false
e8351697-4fb9-4129-8683-fc3d47f93467	2026-09-22 13:54	2026-09-22 13:54	2026-09-22 13:54	PSX	PSX260925P00257500	put	257.5000	2026-09-25	3.3000	2.2500	3.3000	261.9300	115500.00	115500.00	0.00	350	16	363	63	5.76190476190476	0.559189348889006	0.559189348889006	false	false	false
fe92e83b-72f9-4712-a320-393b822f5ab5	2026-09-22 14:07	2026-09-22 14:07	2026-09-22 14:07	PSX	PSX260925P00250000	put	250.0000	2026-09-25	1.5000	1.2000	1.5000	260.9150	10200.00	10200.00	0.00	68	23	1026	1165	0.88068669527897	0.570755269384589	0.570755269384589	false	false	false
3de4dc8e-2bc1-48ea-884b-5a7b0f23f29b	2026-09-22 14:08	2026-09-22 14:08	2026-09-22 14:08	PSX	PSX261120C00260000	call	260.0000	2026-11-20	19.1000	18.6000	20.4000	260.0100	13370.00	0.00	9550.00	7	5	70	631	0.110935023771791	0.438991797231934	0.438991797231934	false	false	false
b982d767-f8cc-4cf7-a617-7545510f7a80	2026-09-22 15:10	2026-09-22 15:10	2026-09-22 15:10	PSX	PSX261218C00290000	call	290.0000	2026-12-18	11.5900	11.4000	12.3000	258.6350	34768.00	0.00	34768.00	30	21	95	737	0.128900949796472	0.438317137816609	0.438317137816609	false	false	false
85eb8385-090a-4b23-8911-88696ae34ca3	2026-09-22 15:16	2026-09-22 15:16	2026-09-22 15:16	PSX	PSX261218C00290000	call	290.0000	2026-12-18	11.6600	11.5000	12.0000	258.8150	19826.00	0.00	19826.00	17	7	147	737	0.199457259158752	0.436113326230839	0.436753191030947	false	false	false
7688efc1-0213-4124-8361-5bfe4da5cfd0	2026-09-22 15:37	2026-09-22 15:37	2026-09-22 15:37	PSX	PSX270617C00300000	call	300.0000	2027-06-17	24.8000	23.6000	25.2000	257.3750	96720.00	81840.00	12400.00	39	11	40	14	2.85714285714286	0.420384156439677	0.420384156439677	false	false	false
987fb677-df1f-49aa-898c-185f0d90afd7	2026-09-22 15:49	2026-09-22 15:49	2026-09-22 15:49	PSX	PSX261120P00260000	put	260.0000	2026-11-20	19.5000	19.5000	20.1000	257.4300	21450.00	0.00	21450.00	11	5	79	256	0.30859375	0.461766638859179	0.461766638859179	false	false	false