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 = XOM×

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

115d8b82-a7bc-4fe7-98e8-e764e047f154	2026-09-24 10:04	2026-09-24 10:04	2026-09-24 10:04	XOM	XOM261120P00165000	put	165.0000	2026-11-20	8.4100	8.2500	8.5000	163.3800	21865.00	3380.00	845.00	26	6	34	1044	0.0325670498084291	0.316593644577533	0.316593644577533	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Energy	662963565311.00	2026-10-30	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-24T14:06:35.686187Z"}	2026-09-24	2026-09-24 21:15	2026-09-24 21:15
d317f09a-5416-48aa-933b-6b33f5f2204c	2026-09-24 09:56	2026-09-24 09:56	2026-09-24 09:56	XOM	XOM261016P00172500	put	172.5000	2026-10-16	10.0000	9.5000	11.2500	163.8800	23000.00	3000.00	20000.00	23	5	23	50	0.46	0.293567937609449	0.293567937609449	false	false	false	true
ba9f1d05-cd5d-4271-a9ef-da3d99868d2f	2026-09-24 09:55	2026-09-24 09:55	2026-09-24 09:55	XOM	XOM260925C00160000	call	160.0000	2026-09-25	4.1300	3.9000	4.3500	163.7500	12390.00	12390.00	0.00	30	6	108	1189	0.0908326324642557	0.467842000310885	0.467842000310885	false	false	false	true
5b8e89d2-9d64-456b-babc-30a09fc5e901	2026-09-24 09:52	2026-09-24 09:52	2026-09-24 09:52	XOM	XOM261002C00167500	call	167.5000	2026-10-02	1.4400	1.4100	1.6000	163.8500	22611.00	146.00	22465.00	157	22	306	1145	0.267248908296943	0.290977330875696	0.294388100388525	true	false	false	true
a73f6367-eb09-4c8f-a470-156020a38a7c	2026-09-24 09:41	2026-09-24 09:41	2026-09-24 09:41	XOM	XOM261002C00165000	call	165.0000	2026-10-02	2.3300	2.2800	2.4300	163.6100	18600.00	4931.00	9280.00	80	6	206	1714	0.120186697782964	0.299038998475869	0.29799250268316	true	false	false	true
7f8be3a1-5e8d-45c3-9098-8670f472b3a8	2026-09-24 09:40	2026-09-24 09:40	2026-09-24 09:40	XOM	XOM260925P00162500	put	162.5000	2026-09-25	0.9700	0.8100	0.9700	163.7750	14550.00	14550.00	0.00	150	17	172	645	0.266666666666667	0.449253615016665	0.449253615016665	false	false	false	true
d7599df9-1518-4789-8967-823c32ad3724	2026-09-24 09:35	2026-09-24 09:35	2026-09-24 09:35	XOM	XOM261016C00155000	call	155.0000	2026-10-16	10.0000	9.7500	10.0000	162.8900	15000.00	15000.00	0.00	15	5	196	9247	0.0211960635881908	0.307169121326966	0.307169121326966	false	false	false	true
bb66ee78-bdda-45f5-b98a-f1aa0bbe1f3c	2026-09-24 09:34	2026-09-24 09:34	2026-09-24 09:34	XOM	XOM261120C00145000	call	145.0000	2026-11-20	19.7200	17.1000	20.0000	162.3700	27615.00	27615.00	0.00	14	9	14	1924	0.00727650727650728	0.314801629745125	0.29438343442529	false	false	false	true
a058e0cb-5734-4bd5-ac39-38f53f3e0f1c	2026-09-24 09:34	2026-09-24 09:34	2026-09-24 09:34	XOM	XOM261016C00155000	call	155.0000	2026-10-16	9.4400	9.1500	9.9500	162.3525	11333.00	0.00	11333.00	12	7	145	9247	0.0156807613279983	0.295830296735842	0.29015123212769	false	false	false	true
74aee151-52ae-49a9-b1a6-26aab18367e9	2026-09-24 09:34	2026-09-24 09:34	2026-09-24 09:34	XOM	XOM261016C00155000	call	155.0000	2026-10-16	9.2900	8.7000	12.9250	162.3200	115210.00	3760.00	111450.00	124	36	124	9247	0.0134097545149778	0.230060160466543	0.28972999316424	false	false	false	true
139dee0a-6f4f-4ffc-9ba4-f1cd542a2da8	2026-09-23 15:40	2026-09-23 15:40	2026-09-23 15:40	XOM	XOM261016P00145000	put	145.0000	2026-10-16	0.4500	0.4500	0.5000	161.1450	20790.00	0.00	20790.00	462	39	595	9286	0.0640749515399526	0.31064082300174	0.31064082300174	false	false	false	true
474f24f8-6785-4ddb-8fd4-4e4b64f02dcb	2026-09-23 15:21	2026-09-23 15:20	2026-09-23 15:20	XOM	XOM261218C00175000	call	175.0000	2026-12-18	4.2500	4.2000	4.2500	160.9500	12742.00	12742.00	0.00	30	5	86	4123	0.0208585981081737	0.282567532479001	0.281923277200818	false	false	false	true
c3c43d86-3014-4901-b07c-5bc7a2f989a6	2026-09-23 15:07	2026-09-23 15:07	2026-09-23 15:07	XOM	XOM261002P00155000	put	155.0000	2026-10-02	0.9000	0.9000	0.9900	161.0400	22770.00	0.00	22770.00	253	25	596	1020	0.584313725490196	0.30788644232992	0.30788644232992	false	false	false	true
789ff24e-bb6f-4e13-b765-6bcb076d1033	2026-09-23 15:04	2026-09-23 15:04	2026-09-23 15:04	XOM	XOM261120C00145000	call	145.0000	2026-11-20	18.5100	18.5000	18.6000	160.9100	24060.00	0.00	24060.00	13	5	1211	1049	1.15443279313632	0.293985277659049	0.293985277659049	false	false	false	true
201d2973-3d6b-48be-a47b-96587afa07bb	2026-09-23 14:19	2026-09-23 14:19	2026-09-23 14:19	XOM	XOM261120C00145000	call	145.0000	2026-11-20	18.8000	18.8000	18.8500	161.0000	35720.00	0.00	35720.00	19	6	630	1049	0.600571973307912	0.29758649809747	0.29758649809747	false	false	false	true
6b43d67f-1475-47cb-b850-35eb5e3441f5	2026-09-23 14:16	2026-09-23 14:16	2026-09-23 14:16	XOM	XOM261120C00145000	call	145.0000	2026-11-20	18.8000	18.7500	18.8500	161.1400	16920.00	0.00	0.00	9	5	521	1049	0.496663489037178	0.300836012552709	0.300836012552709	false	false	false	true
6399a53b-da31-4b41-a399-9c451df1f0f0	2026-09-23 14:16	2026-09-23 14:16	2026-09-23 14:16	XOM	XOM261120C00145000	call	145.0000	2026-11-20	18.7800	18.7500	18.8500	161.1800	37564.00	15052.00	22512.00	20	6	494	1049	0.470924690181125	0.296085759336721	0.299319763222368	false	false	false	true
8d74c5e1-b54d-4f9b-a0ac-6324ac637079	2026-09-23 14:02	2026-09-23 14:02	2026-09-23 14:02	XOM	XOM261218P00155000	put	155.0000	2026-12-18	6.2000	6.2000	6.2500	161.3200	16740.00	0.00	16740.00	27	6	315	2844	0.110759493670886	0.315736353387513	0.315736353387513	false	false	false	true
9ef36ea0-07fc-47dd-b976-1c62cf633f4d	2026-09-23 14:01	2026-09-23 14:01	2026-09-23 14:01	XOM	XOM261009C00165000	call	165.0000	2026-10-09	2.5200	2.4300	2.5400	161.2900	10085.00	10085.00	0.00	40	6	691	371	1.86253369272237	0.295462307816611	0.291566970326128	false	false	false	true
ef197903-1259-4a58-b710-073f7a452a31	2026-09-23 13:59	2026-09-23 13:59	2026-09-23 13:59	XOM	XOM261218P00155000	put	155.0000	2026-12-18	6.2500	6.2500	6.4000	161.2109	16250.00	0.00	16250.00	26	5	238	2844	0.0836849507735584	0.316165119170629	0.316165119170629	false	false	false	true
886b6da9-c365-4e77-b216-29cf643b107d	2026-09-23 13:54	2026-09-23 13:54	2026-09-23 13:54	XOM	XOM261023C00170000	call	170.0000	2026-10-23	2.2300	2.1000	2.2400	161.1600	113060.00	109270.00	3790.00	507	53	542	87	6.22988505747126	0.285230817178675	0.285230817178675	false	false	false	true
38396193-f4bf-4646-bf8d-cd9c698d70a4	2026-09-23 13:45	2026-09-23 13:45	2026-09-23 13:45	XOM	XOM261218C00165000	call	165.0000	2026-12-18	7.7500	7.7500	7.9500	161.0000	10850.00	0.00	10850.00	14	14	169	6733	0.0251002524877469	0.278800410114062	0.278800410114062	true	false	false	true
61ac46ea-1175-4483-9f46-611851eca5f6	2026-09-23 13:18	2026-09-23 13:18	2026-09-23 13:18	XOM	XOM261009P00157500	put	157.5000	2026-10-09	2.5400	2.5200	2.6400	160.0000	26709.00	6141.00	15666.00	105	11	721	106	6.80188679245283	0.301665892955085	0.29689165788796	true	false	false	true
4e213c82-463d-4747-962c-3de2076ebb0d	2026-09-23 13:18	2026-09-23 13:18	2026-09-23 13:18	XOM	XOM261009P00157500	put	157.5000	2026-10-09	2.5400	2.5100	2.7200	160.0000	22604.00	3052.00	19552.00	89	21	616	106	5.81132075471698	0.297687930514319	0.297687930514319	true	false	false	true
f54fd19f-30bf-4ba0-9fdc-4aa2f54a9ec9	2026-09-23 12:50	2026-09-23 12:50	2026-09-23 12:50	XOM	XOM260925P00160000	put	160.0000	2026-09-25	1.5700	1.3700	1.6300	160.3100	18997.00	18997.00	0.00	121	5	1235	1395	0.885304659498208	0.367308218319726	0.367308218319726	false	false	false	true
d599325a-bf98-4027-8cc0-bdc9c98629ff	2026-09-23 12:46	2026-09-23 12:46	2026-09-23 12:46	XOM	XOM261218C00155000	call	155.0000	2026-12-18	12.4100	12.4000	13.1500	160.9500	393256.00	0.00	393256.00	317	5	323	4346	0.0743212149102623	0.267278550066493	0.267630557797311	false	false	false	true
80fa7173-a827-4b91-86e4-d854c29addfd	2026-09-23 12:46	2026-09-23 12:46	2026-09-23 12:46	XOM	XOM261218P00170000	put	170.0000	2026-12-18	14.6500	13.8500	14.6500	160.9500	147965.00	147965.00	0.00	101	5	101	434	0.232718894009217	0.331129059871229	0.331129059871229	false	false	false	true
3bf35c38-64d7-49c6-b37f-60ffc993a54c	2026-09-23 12:46	2026-09-23 12:46	2026-09-23 12:46	XOM	XOM261120C00155000	call	155.0000	2026-11-20	10.9000	10.9000	11.8000	160.7100	331365.00	1095.00	330270.00	304	7	320	4156	0.0769971126082772	0.274523200602811	0.281499244759137	true	false	false
e10ffa58-18f1-4634-bef4-d18b2510091a	2026-09-23 12:40	2026-09-23 12:40	2026-09-23 12:40	XOM	XOM270319P00165000	put	165.0000	2027-03-19	14.5500	14.4500	14.6500	161.0000	17460.00	16005.00	1455.00	12	5	30	1846	0.0162513542795233	0.318595317353811	0.318595317353811	false	false	false	true
54a102c9-5036-433c-9639-e32194010b84	2026-09-23 12:34	2026-09-23 12:34	2026-09-23 12:34	XOM	XOM290119C00160000	call	160.0000	2029-01-19	30.6000	30.6000	31.7000	161.0500	21420.00	0.00	21420.00	7	6	18	67	0.26865671641791	0.223530691605535	0.223530691605535	false	false	false	true
e244dc19-b09d-4620-9147-7cfc68d1b75f	2026-09-23 12:10	2026-09-23 12:10	2026-09-23 12:10	XOM	XOM261009P00162500	put	162.5000	2026-10-09	4.6000	4.5500	4.8000	161.0250	24840.00	0.00	24840.00	54	10	76	216	0.351851851851852	0.291919165433402	0.294525896853861	true	false	false	true
72408673-ea43-4e79-bdc4-f54c72b89fc1	2026-09-23 12:10	2026-09-23 12:10	2026-09-23 12:10	XOM	XOM261009P00157500	put	157.5000	2026-10-09	2.3400	2.2900	2.4300	160.9600	103899.00	236.00	103663.00	444	44	522	106	4.92452830188679	0.295640820506023	0.297258325059752	false	false	false	true
5f4938fb-d40e-4bf5-b9de-245862486bdd	2026-09-23 11:48	2026-09-23 11:48	2026-09-23 11:48	XOM	XOM261009P00160000	put	160.0000	2026-10-09	3.2000	3.1000	3.3000	161.0000	27178.00	26858.00	320.00	85	24	143	296	0.483108108108108	0.295924898135427	0.295125813944098	true	false	false	true
dab4542e-f00f-41c9-a81e-bf273f8a14d9	2026-09-23 11:34	2026-09-23 11:33	2026-09-23 11:33	XOM	XOM270319P00160000	put	160.0000	2027-03-19	11.7100	11.5250	12.2500	161.6150	18735.00	0.00	18735.00	16	11	18	1313	0.0137090632140137	0.318595059862614	0.317446270242108	false	false	false	true
52d297c2-da95-4538-a05f-d733c07a1b8c	2026-09-23 10:56	2026-09-23 10:56	2026-09-23 10:56	XOM	XOM260925P00157500	put	157.5000	2026-09-25	0.6400	0.5300	0.6400	160.4500	19455.00	19455.00	0.00	304	31	727	2124	0.342278719397363	0.370695082718025	0.367997987606918	true	false	false	true
5843def0-353b-4825-b2a7-502f1b9656de	2026-09-23 10:51	2026-09-23 10:51	2026-09-23 10:51	XOM	XOM260925P00160000	put	160.0000	2026-09-25	1.1700	1.0200	1.1700	161.0200	11349.00	11349.00	0.00	97	14	379	1395	0.27168458781362	0.358764324623487	0.346846486324643	true	false	false	true
809de7a5-084d-41f6-890b-26efa11badf4	2026-09-23 10:49	2026-09-23 10:49	2026-09-23 10:49	XOM	XOM261009C00165000	call	165.0000	2026-10-09	2.5700	2.5600	2.6700	161.4500	11044.00	0.00	11044.00	43	11	521	371	1.40431266846361	0.293054170503324	0.293054170503324	true	false	false	true
fd44ca18-58ae-4abb-82df-8831ce4a36ea	2026-09-23 10:46	2026-09-23 10:46	2026-09-23 10:46	XOM	XOM270319P00140000	put	140.0000	2027-03-19	4.4500	4.3500	4.4500	161.7750	18245.00	18245.00	0.00	41	15	54	3563	0.0151557676115633	0.321516195197525	0.321516195197525	false	false	false	true
319f1512-9c0c-4677-ab59-94d4cf97e548	2026-09-23 10:31	2026-09-23 10:31	2026-09-23 10:31	XOM	XOM280121C00175000	call	175.0000	2028-01-21	17.9000	17.6000	18.1500	162.0450	110990.00	109200.00	1790.00	62	5	64	4384	0.0145985401459854	0.255803534803221	0.254673334155317	false	false	false
ca963789-b7f6-413e-913a-2c6b77791f60	2026-09-23 10:25	2026-09-23 10:25	2026-09-23 10:25	XOM	XOM280121C00165000	call	165.0000	2028-01-21	21.5500	21.1500	21.6500	161.0000	10775.00	10775.00	0.00	5	5	134	856	0.156542056074766	0.249354474651657	0.249354474651657	false	false	false	true
9aee1d61-d6eb-4744-9785-7648746db9e2	2026-09-23 10:22	2026-09-23 10:22	2026-09-23 10:22	XOM	XOM270617C00190000	call	190.0000	2027-06-17	7.3200	7.2000	7.4500	161.7700	11710.00	2940.00	8770.00	16	5	89	818	0.10880195599022	0.272291877774805	0.273287118723791	false	false	false	true
6637214a-21b3-4f89-b59f-7f295208c87b	2026-09-23 10:10	2026-09-23 10:10	2026-09-23 10:10	XOM	XOM261016C00160000	call	160.0000	2026-10-16	5.5500	5.3000	5.6500	161.2191	28860.00	4440.00	24420.00	52	8	123	5500	0.0223636363636364	0.292410179385592	0.292410179385592	false	false	false	true
7376a0f6-1aaf-44fc-8c46-682220ae2e4d	2026-09-23 10:09	2026-09-23 10:08	2026-09-23 10:08	XOM	XOM260925C00165000	call	165.0000	2026-09-25	0.4300	0.4300	0.5000	160.9600	15910.00	0.00	15910.00	370	41	973	3002	0.324117255163225	0.363573363357255	0.363573363357255	false	false	false	true
d7a5e58c-f402-4ea1-a4e9-ff0d0d8bfeab	2026-09-23 10:05	2026-09-23 10:05	2026-09-23 10:05	XOM	XOM261016P00150000	put	150.0000	2026-10-16	1.0000	0.9900	1.0500	161.0000	28700.00	9300.00	19400.00	287	59	435	8970	0.048494983277592	0.300576616207422	0.300576616207422	false	false	false	true
27056b2b-d013-4089-b60d-05ad63176624	2026-09-23 09:51	2026-09-23 09:51	2026-09-23 09:51	XOM	XOM270319C00180000	call	180.0000	2027-03-19	6.8500	6.3000	6.8500	161.5700	36300.00	36300.00	0.00	53	5	53	2981	0.0177792687017779	0.275578656097816	0.275578656097816	false	false	false	true
a192b49f-14e2-4db9-b8ac-fa634e9183c9	2026-09-22 15:29	2026-09-22 15:29	2026-09-22 15:29	XOM	XOM261009P00150000	put	150.0000	2026-10-09	1.0400	0.9800	1.0500	158.0000	30576.00	27456.00	3120.00	294	16	1293	143	9.04195804195804	0.305923451513398	0.305524751641646	true	false	false	true
83ab0bf9-f73c-4ce0-bea2-ef5c99c1bd0b	2026-09-22 15:29	2026-09-22 15:29	2026-09-22 15:29	XOM	XOM261120P00155000	put	155.0000	2026-11-20	5.7500	5.6500	5.7500	158.0000	25875.00	25875.00	0.00	45	15	146	2333	0.0625803686240892	0.317140811861572	0.317140811861572	false	false	false	true
6dc31be5-4cb9-4d9c-8ca4-035e762df585	2026-09-22 15:29	2026-09-22 15:29	2026-09-22 15:29	XOM	XOM261009P00150000	put	150.0000	2026-10-09	1.0100	0.9600	1.0200	158.0000	30581.00	30480.00	101.00	302	19	943	143	6.59440559440559	0.304329521843277	0.305461340538056	false	false	false	true
c5a0489d-5b59-4300-9133-e11386e68a99	2026-09-22 14:20	2026-09-22 14:20	2026-09-22 14:20	XOM	XOM261016C00165000	call	165.0000	2026-10-16	2.5600	2.3800	2.6000	159.3000	47615.00	47104.00	511.00	186	6	970	9224	0.105160450997398	0.285990999463831	0.285324157093226	true	false	false	true
36c93622-8f66-4bd5-8e1d-b375269c9b39	2026-09-22 14:07	2026-09-22 14:07	2026-09-22 14:07	XOM	XOM260925P00157500	put	157.5000	2026-09-25	1.4200	1.2600	1.4200	158.8500	22720.00	22720.00	0.00	160	5	957	1608	0.595149253731343	0.357483281823812	0.357483281823812	false	false	false	true