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.

728,802 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts728,802 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:option_symbol = XOM261016C00155000×source = uw_flow_alerts×

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

9ff37347-29c1-48ee-857e-0e8de96fb035	2026-10-02 10:21	2026-10-02 10:20	2026-10-02 10:20	XOM	XOM261016C00155000	call	155.0000	2026-10-16	8.4500	8.0500	8.4500	162.0000	12675.00	12675.00	0.00	15	5	701	8192	0.0855712890625	0.290199298269637	0.290199298269637	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Energy	674394680560.00	2026-10-30	unknown	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-10-02T14:21:45.747207Z"}	2026-10-02	2026-10-02 21:15	2026-10-02 21:15
3e77eec9-cf24-48e8-9c92-49cda9c6a057	2026-10-02 09:40	2026-10-02 09:40	2026-10-02 09:40	XOM	XOM261016C00155000	call	155.0000	2026-10-16	9.1500	8.9500	9.4000	163.1900	10065.00	6405.00	3660.00	11	5	625	8192	0.0762939453125	0.281221914704953	0.27305713613619	true	false	false	true
caf5ca15-b847-4c0a-acf5-ae36c813989a	2026-10-02 09:36	2026-10-02 09:35	2026-10-02 09:35	XOM	XOM261016C00155000	call	155.0000	2026-10-16	9.0000	8.9000	9.2500	163.0200	63900.00	30600.00	28800.00	71	18	576	8192	0.0703125	0.272201511827541	0.272201511827541	false	false	false	true
93ed0754-f5f9-4f70-8b47-7359f83316aa	2026-10-02 09:35	2026-10-02 09:35	2026-10-02 09:35	XOM	XOM261016C00155000	call	155.0000	2026-10-16	8.7500	8.6000	9.0000	162.7150	49875.00	15750.00	34125.00	57	15	500	8192	0.06103515625	0.273448961104861	0.272886565986469	false	false	false	true
b7927284-307d-4a5f-8769-52e2b964d80b	2026-10-02 09:35	2026-10-02 09:35	2026-10-02 09:35	XOM	XOM261016C00155000	call	155.0000	2026-10-16	8.7500	8.5000	9.0000	162.7096	14875.00	12250.00	0.00	17	7	443	8192	0.0540771484375	0.273448961104861	0.273448961104861	false	false	false	true
ced935a5-c7ef-44f0-8525-ad125b5b8902	2026-10-02 09:34	2026-10-02 09:34	2026-10-02 09:34	XOM	XOM261016C00155000	call	155.0000	2026-10-16	8.5500	8.4000	8.6500	162.4000	21375.00	8550.00	11970.00	25	7	424	8192	0.0517578125	0.280187821001586	0.280187821001586	false	false	false	true
5391272a-99f4-4231-8a28-21202065d88a	2026-10-02 09:33	2026-10-02 09:33	2026-10-02 09:33	XOM	XOM261016C00155000	call	155.0000	2026-10-16	8.4700	8.0000	8.7500	162.3400	55895.00	29700.00	26195.00	66	14	399	8192	0.0487060546875	0.277183783956739	0.280068972039327	false	false	false	true
0b7a4c80-364b-4377-a7d6-b5095ae77fcd	2026-10-02 09:33	2026-10-02 09:33	2026-10-02 09:33	XOM	XOM261016C00155000	call	155.0000	2026-10-16	8.4500	7.9500	8.4500	162.1950	12675.00	12675.00	0.00	15	5	324	8192	0.03955078125	0.287911269173068	0.287911269173068	false	false	false	true
3c0af30c-7e33-497c-9dcc-615b89ade6b3	2026-10-02 09:33	2026-10-02 09:33	2026-10-02 09:33	XOM	XOM261016C00155000	call	155.0000	2026-10-16	8.3500	8.1000	8.5000	162.2200	12525.00	1670.00	2505.00	15	5	309	8192	0.0377197265625	0.273906291189293	0.273906291189293	false	false	false	true
95fc8e4f-a1da-420b-bd33-873f0ef30786	2026-10-02 09:31	2026-10-02 09:31	2026-10-02 09:31	XOM	XOM261016C00155000	call	155.0000	2026-10-16	8.2600	6.7500	8.7500	162.6100	240360.00	81800.00	153700.00	291	35	291	8192	0.0355224609375	0.275683446714561	0.245234697024523	false	false	false	true
22bd7f96-4ab8-420d-ae02-5d626a1fe356	2026-10-01 15:56	2026-10-01 15:56	2026-10-01 15:56	XOM	XOM261016C00155000	call	155.0000	2026-10-16	10.0000	9.8000	10.0000	163.9700	17000.00	17000.00	0.00	17	5	4487	8979	0.499721572558191	0.286406739584879	0.286406739584879	false	false	false	true
ac2b25e3-3307-43f6-a0a9-ecd7444eb852	2026-10-01 15:55	2026-10-01 15:55	2026-10-01 15:55	XOM	XOM261016C00155000	call	155.0000	2026-10-16	10.0000	10.0000	10.1000	164.0400	262000.00	0.00	262000.00	262	23	4438	8979	0.494264394698742	0.278659470322283	0.278659470322283	false	false	false	true
90578db3-4fde-48ac-b24c-49e6a717d55d	2026-10-01 15:55	2026-10-01 15:55	2026-10-01 15:55	XOM	XOM261016C00155000	call	155.0000	2026-10-16	10.0000	9.9500	10.1000	164.0400	167000.00	0.00	97000.00	167	8	4176	8979	0.465085198797193	0.278659470322283	0.278659470322283	true	false	false	true
3132486e-da35-47fa-8a94-f17b1874e72f	2026-10-01 15:55	2026-10-01 15:55	2026-10-01 15:55	XOM	XOM261016C00155000	call	155.0000	2026-10-16	10.0000	9.9500	10.0000	164.0750	223000.00	70000.00	0.00	223	11	4009	8979	0.446486245684375	0.274648129022442	0.274648129022442	true	false	false	true
86db6a9a-2228-475d-9739-9c40a21481f0	2026-10-01 15:55	2026-10-01 15:55	2026-10-01 15:55	XOM	XOM261016C00155000	call	155.0000	2026-10-16	10.0000	9.9500	10.2000	164.0750	174000.00	47000.00	17000.00	174	12	3786	8979	0.421650517875042	0.278092366826146	0.274648129022442	false	false	false	true
faddb81b-08f1-45fe-adb7-d22741fef1c4	2026-10-01 15:55	2026-10-01 15:55	2026-10-01 15:55	XOM	XOM261016C00155000	call	155.0000	2026-10-16	10.0000	10.0000	10.3500	164.0600	63000.00	0.00	63000.00	63	9	3612	8979	0.402271967925159	0.276379306834918	0.276379306834918	false	false	false	true
d8f43d87-ad92-4176-b959-7ad1877dbf5b	2026-10-01 15:55	2026-10-01 15:54	2026-10-01 15:54	XOM	XOM261016C00155000	call	155.0000	2026-10-16	10.0000	9.9500	10.2000	164.0200	205000.00	46000.00	87000.00	205	6	3414	8979	0.380220514533912	0.280908896624334	0.280908896624334	false	false	false	true
e50b1e91-6b09-4069-844a-82f17b39da0b	2026-10-01 15:54	2026-10-01 15:54	2026-10-01 15:54	XOM	XOM261016C00155000	call	155.0000	2026-10-16	10.0000	10.0000	10.3000	164.0500	59000.00	0.00	59000.00	59	17	3058	8979	0.340572446820359	0.277523320374019	0.277523320374019	false	false	false	true
4b8416ce-6dac-4782-bea3-7d21aee832fd	2026-10-01 15:54	2026-10-01 15:54	2026-10-01 15:54	XOM	XOM261016C00155000	call	155.0000	2026-10-16	10.0500	10.0000	10.0500	164.0500	151755.00	151755.00	0.00	151	6	3209	8979	0.357389464305602	0.284093649072258	0.284093649072258	false	false	false	true
eb4e7028-b57a-437d-a60d-8bed202e0d2a	2026-10-01 15:52	2026-10-01 15:52	2026-10-01 15:52	XOM	XOM261016C00155000	call	155.0000	2026-10-16	10.0000	9.4000	10.3000	163.9900	822000.00	773000.00	49000.00	822	12	2812	8979	0.313175186546386	0.284228373122194	0.284228373122194	false	false	false	true
c9ffe02a-12dc-483b-9e80-94f1dc418a9f	2026-10-01 14:31	2026-10-01 14:30	2026-10-01 14:30	XOM	XOM261016C00155000	call	155.0000	2026-10-16	10.0000	9.9000	10.1000	163.9800	189000.00	186000.00	0.00	189	9	1743	8979	0.194119612429001	0.286406739584879	0.285320919367829	false	false	false	true
17c5195c-2953-4ac0-b92b-a3bc983adac4	2026-10-01 14:30	2026-10-01 14:30	2026-10-01 14:30	XOM	XOM261016C00155000	call	155.0000	2026-10-16	10.0000	9.9000	10.0000	163.9500	27000.00	27000.00	0.00	27	5	1510	8979	0.168170174852433	0.2885587595541	0.2885587595541	false	false	false	true
c2d165b5-2b25-4cb1-9def-5e101d0501cf	2026-10-01 14:30	2026-10-01 14:30	2026-10-01 14:30	XOM	XOM261016C00155000	call	155.0000	2026-10-16	10.0000	9.9000	10.0000	163.9450	54000.00	54000.00	0.00	54	13	1483	8979	0.1651631584809	0.289625226532539	0.289092774780637	false	false	false	true
2b921f81-5ef2-4f11-9fd5-ead046a39aa8	2026-10-01 14:30	2026-10-01 14:30	2026-10-01 14:30	XOM	XOM261016C00155000	call	155.0000	2026-10-16	10.0000	9.8500	10.0000	163.9100	171000.00	171000.00	0.00	171	28	1429	8979	0.159149125737833	0.292787968425864	0.292787968425864	false	false	false	true
df62b18c-7cd1-4759-ac1a-bb7de0af469b	2026-10-01 14:27	2026-10-01 14:27	2026-10-01 14:27	XOM	XOM261016C00155000	call	155.0000	2026-10-16	10.0000	9.7000	10.0000	163.9400	187000.00	187000.00	0.00	187	5	1256	8979	0.139881946764673	0.289625226532539	0.289625226532539	false	false	false	true
7e24d261-0e43-421b-9e93-767ba485b9aa	2026-10-01 14:27	2026-10-01 14:27	2026-10-01 14:27	XOM	XOM261016C00155000	call	155.0000	2026-10-16	10.0000	9.7000	10.1000	163.9100	353000.00	353000.00	0.00	353	8	1069	8979	0.119055574117385	0.292787968425864	0.292787968425864	false	false	false	true
f595f19a-bba6-4f5d-a367-493ee07bcdb9	2026-10-01 14:13	2026-10-01 14:12	2026-10-01 14:12	XOM	XOM261016C00155000	call	155.0000	2026-10-16	10.0000	9.9000	10.0000	163.8650	185000.00	185000.00	0.00	185	9	713	8979	0.0794075064038312	0.297434518700356	0.297434518700356	false	false	false	true
4dd55a53-f6a9-4539-a0e0-6ff642566e87	2026-10-01 14:12	2026-10-01 14:11	2026-10-01 14:11	XOM	XOM261016C00155000	call	155.0000	2026-10-16	10.0000	9.6500	10.1000	163.8700	387000.00	387000.00	0.00	387	8	527	8979	0.0586925047332665	0.296923762992348	0.296923762992348	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
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
934ed49b-f6cc-4c6a-870f-c4fa93e29f15	2026-09-21 09:37	2026-09-21 09:37	2026-09-21 09:37	XOM	XOM261016C00155000	call	155.0000	2026-10-16	8.2300	8.1500	9.3000	160.4100	13984.00	0.00	13984.00	17	10	42	10377	0.0040474125469789	0.300171194452569	0.296223609557854	false	false	false	true
eb2fd49c-c51e-4b25-af0d-cd90541d9c7e	2026-09-15 09:57	2026-09-15 09:57	2026-09-15 09:57	XOM	XOM261016C00155000	call	155.0000	2026-10-16	14.9800	14.5000	14.8000	167.3850	7250975.00	7250975.00	0.00	4839	37	5307	6437	0.824452384651235	0.340232228949867	0.340232228949867	true	true	false	true
43bb967a-5f2f-4fe3-9d47-3f972dc6219a	2026-09-15 09:44	2026-09-15 09:44	2026-09-15 09:44	XOM	XOM261016C00155000	call	155.0000	2026-10-16	14.2500	14.2500	14.8000	166.8900	229425.00	0.00	229425.00	161	6	411	6437	0.0638496193879136	0.328948078379863	0.328948078379863	false	false	false	true