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:alert_rule = RepeatedHitsAscendingFill×ticker = XOM×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

9f3d6e5a-67ac-435a-90cc-b3e50bc7691b	2026-08-17 15:34	2026-08-17 15:33	2026-08-17 15:33	XOM	XOM261016P00160000	put	160.0000	2026-10-16	6.1000	5.9500	6.2000	161.3700	376388.00	31110.00	345278.00	617	58	711	912	0.779605263157895	0.27850396195485	0.278919145752805	false	false	false	true	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	Common Stock	Energy	678794426357.00	2026-10-30	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-17T19:39:36.389012Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
8f94bb85-e9ec-4606-b49d-70041c0d6e68	2026-08-18 09:45	2026-08-18 09:45	2026-08-18 09:45	XOM	XOM270617C00170000	call	170.0000	2027-06-17	15.1000	14.8500	15.8500	163.0000	791037.00	35040.00	755997.00	524	24	525	1533	0.342465753424658	0.254999737952273	0.257786360553131	false	false	false	true
ea54afb7-c01f-462a-9ab0-41a73963bc21	2026-08-18 09:49	2026-08-18 09:49	2026-08-18 09:49	XOM	XOM270617C00170000	call	170.0000	2027-06-17	14.8800	14.8500	15.4500	163.0000	744116.00	0.00	744116.00	500	17	1045	1533	0.681669928245271	0.255708942260054	0.261906392323958	false	false	false	true
e0f30529-23c0-4c9e-bb0f-008881a2a5bc	2026-08-18 13:59	2026-08-18 13:59	2026-08-18 13:59	XOM	XOM261120C00175000	call	175.0000	2026-11-20	6.0500	5.9500	6.0500	165.0753	120385.00	120385.00	0.00	199	5	225	1777	0.126617895329207	0.279999378535087	0.279999378535087	false	false	false	true
e100b1ea-779d-476a-acb6-1f13bbd87908	2026-08-19 11:28	2026-08-19 11:28	2026-08-19 11:28	XOM	XOM261016P00170000	put	170.0000	2026-10-16	8.3000	8.3000	8.6000	167.3800	789459.00	0.00	789459.00	951	49	976	154	6.33766233766234	0.27973205076674	0.27973205076674	false	false	false	true
019d14f8-339f-4452-8515-22e53de8bf29	2026-08-19 13:33	2026-08-19 13:33	2026-08-19 13:33	XOM	XOM270617C00180000	call	180.0000	2027-06-17	12.4000	12.4000	12.6500	166.1500	212101.00	1250.00	210851.00	171	14	319	1103	0.28921124206709	0.261188607804194	0.261854099778502	false	false	false	true
4ae2fb20-cc22-4481-b677-ef77336950b7	2026-08-19 14:25	2026-08-19 14:25	2026-08-19 14:25	XOM	XOM261218P00165000	put	165.0000	2026-12-18	9.7500	9.7500	9.9000	165.7800	446562.00	0.00	446562.00	458	66	541	367	1.47411444141689	0.295770115246592	0.295770115246592	false	false	false	true
6a7fdfaf-c153-43d1-bace-32ee83d1b146	2026-08-19 15:32	2026-08-19 15:32	2026-08-19 15:32	XOM	XOM261120P00165000	put	165.0000	2026-11-20	8.8500	8.8000	9.0000	165.1450	484126.00	6195.00	477931.00	547	59	609	121	5.03305785123967	0.293773849684036	0.293773849684036	false	false	false	true
98f2e146-3394-4881-97dc-3fe1ef7b97e1	2026-08-20 12:42	2026-08-20 12:41	2026-08-20 12:41	XOM	XOM261002C00170000	call	170.0000	2026-10-02	5.7200	5.3000	5.9000	167.5100	114354.00	114354.00	0.00	200	7	208	116	1.79310344827586	0.283691399482895	0.283691399482895	false	false	false	true
4c8adb45-9744-48fc-8043-c60a3aad7712	2026-09-01 09:51	2026-09-01 09:51	2026-09-01 09:51	XOM	XOM260918C00160000	call	160.0000	2026-09-18	5.7200	5.3500	6.0500	162.9500	245826.00	32515.00	213311.00	430	35	575	11509	0.0499609001650882	0.275457249822711	0.282336484099076	true	false	false	true
a87d33a7-fb11-4f89-a6b4-3af613ed4fa1	2026-09-14 11:10	2026-09-14 11:10	2026-09-14 11:10	XOM	XOM261016C00175000	call	175.0000	2026-10-16	2.6500	2.5500	2.8900	166.0600	375359.00	107444.00	253340.00	1415	44	1578	10067	0.156749776497467	0.293587978346317	0.295336142239812	true	false	false
cfc69e11-5b5e-4ca1-b6e3-10aca74597ff	2026-09-15 13:20	2026-09-15 13:20	2026-09-15 13:20	XOM	XOM261016C00185000	call	185.0000	2026-10-16	1.3500	1.3000	1.4300	169.1700	131761.00	3240.00	128521.00	974	34	1258	1854	0.678532901833873	0.301888073844499	0.301888073844499	true	false	false	true
d9c33287-0f5e-4245-9287-da2fd88523e6	2026-09-16 12:32	2026-09-16 12:32	2026-09-16 12:32	XOM	XOM271217C00200000	call	200.0000	2027-12-17	10.7000	10.5000	10.8000	164.4650	122030.00	74900.00	46060.00	114	29	114	260	0.438461538461538	0.262309222294971	0.262309222294971	false	false	false	true
80a69c29-bb40-4f0e-ba66-83d7f33b5785	2026-09-16 14:23	2026-09-16 14:23	2026-09-16 14:23	XOM	XOM270617C00150000	call	150.0000	2027-06-17	25.8000	25.8000	26.3000	164.8500	366388.00	0.00	366388.00	142	21	152	1381	0.110065170166546	0.257625060893465	0.257625060893465	false	false	false	true
0e72fe8b-ebeb-433b-acc4-c2159de88f28	2026-09-18 09:33	2026-09-18 09:33	2026-09-18 09:33	XOM	XOM280121P00180000	put	180.0000	2028-01-21	28.3500	28.3500	29.0500	163.2500	144605.00	5685.00	138920.00	51	11	51	151	0.337748344370861	0.3319805139867	0.3319805139867	false	false	false	true
b53f1976-4e1d-4545-8aab-f126536d7ef4	2026-09-18 10:02	2026-09-18 10:01	2026-09-18 10:01	XOM	XOM281215C00180000	call	180.0000	2028-12-15	23.1400	22.4000	23.3500	162.6900	141138.00	141138.00	0.00	61	6	121	1183	0.102282333051564	0.235754552253188	0.235754552253188	false	false	false	true
3182a20d-9d10-4f31-9337-3462ff640e0f	2026-09-18 10:02	2026-09-18 10:02	2026-09-18 10:02	XOM	XOM281215C00180000	call	180.0000	2028-12-15	23.1800	22.4000	23.3500	162.7100	254935.00	236475.00	18460.00	110	14	231	1183	0.195266272189349	0.235739013296201	0.237099775211483	true	false	false	true
34067a8f-e1e7-4912-a295-845ac4e578a5	2026-09-21 12:23	2026-09-21 12:22	2026-09-21 12:22	XOM	XOM261218C00175000	call	175.0000	2026-12-18	3.5300	3.5000	3.6000	158.3400	19085.00	9585.00	5950.00	54	8	103	3962	0.0259969712266532	0.279848839476556	0.281760872742659	false	false	false	true
c8662108-9ce0-48f7-bbea-3a2cd95c9008	2026-09-21 13:07	2026-09-21 13:07	2026-09-21 13:07	XOM	XOM281215C00220000	call	220.0000	2028-12-15	10.6500	10.6500	11.0500	158.2650	55390.00	1070.00	54320.00	52	6	144	228	0.631578947368421	0.244617642816152	0.245197516401791	false	false	false	true
b662823b-0425-437f-8b86-264edbc7dedf	2026-09-21 13:56	2026-09-21 13:56	2026-09-21 13:56	XOM	XOM270319P00125000	put	125.0000	2027-03-19	2.1600	2.1500	2.3600	158.8700	10563.00	880.00	9683.00	49	5	62	1582	0.0391908975979772	0.333062918255184	0.335567633322067	false	false	false	true
9404a6e2-b313-498a-ac40-f52cd3d0c4da	2026-09-21 15:27	2026-09-21 15:27	2026-09-21 15:27	XOM	XOM260925P00155000	put	155.0000	2026-09-25	0.8000	0.7300	0.8200	158.6600	27720.00	24561.00	3159.00	346	33	2038	1317	1.54745634016705	0.333439462421073	0.333969467466245	false	false	false	true
a06cc04d-00e8-4387-8003-e76bf60a1ead	2026-09-22 11:06	2026-09-22 11:06	2026-09-22 11:06	XOM	XOM290119P00160000	put	160.0000	2029-01-19	23.2000	22.9500	23.6500	159.0000	18558.00	0.00	18558.00	8	6	36	23	1.56521739130435	0.335870178505754	0.33598500987461	true	false	false	true
7e2795e7-b747-44df-b892-3623711f9275	2026-09-22 12:02	2026-09-22 12:02	2026-09-22 12:02	XOM	XOM270115C00190000	call	190.0000	2027-01-15	2.3200	2.2800	2.4200	159.8550	45242.00	233.00	45009.00	195	31	245	2580	0.0949612403100775	0.284993905294125	0.285418583518275	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