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

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

732a8226-47d6-4bf5-9796-57dfe4128a53	2026-09-17 14:47	2026-09-17 14:47	2026-09-17 14:47	XYL	XYL270115C00115000	call	115.0000	2027-01-15	4.7000	4.7000	4.9000	107.8100	33370.00	0.00	33370.00	71	18	71	35	2.02857142857143	0.283090266533574	0.283090266533574	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Industrials	25123180971.00	2026-10-27	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-17T19:06:51.574572Z"}	2026-09-17	2026-09-17 21:15	2026-09-17 21:15
dda46a9d-d1c3-4cec-b01f-392752481221	2026-09-09 15:56	2026-09-09 15:56	2026-09-09 15:56	XYL	XYL261016P00100000	put	100.0000	2026-10-16	1.2500	1.0000	1.2500	107.4500	12500.00	12500.00	0.00	100	11	102	4891	0.020854630954815	0.305184297915972	0.305184297915972	true	false	false	true
5c4caf54-f933-436c-8cb8-4238f53d2013	2026-09-09 13:19	2026-09-09 13:19	2026-09-09 13:19	XYL	XYL270115C00110000	call	110.0000	2027-01-15	6.6000	6.4000	6.6000	107.2250	122100.00	122100.00	0.00	185	31	268	18	14.8888888888889	0.285660554677134	0.285660554677134	false	false	false	true
42057742-2199-472c-87c1-16be48f26a8d	2026-09-09 11:22	2026-09-09 11:22	2026-09-09 11:22	XYL	XYL270115C00110000	call	110.0000	2027-01-15	6.5000	6.3000	6.5000	106.9800	53300.00	53300.00	0.00	82	20	83	18	4.61111111111111	0.286557072096033	0.286557072096033	false	false	false	true
82fb3058-5236-4ebc-91c5-d18c47ca941d	2026-09-08 11:39	2026-09-08 11:39	2026-09-08 11:39	XYL	XYL261016P00110000	put	110.0000	2026-10-16	4.0000	3.7000	4.0000	109.2650	22000.00	22000.00	0.00	55	13	58	119	0.487394957983193	0.273716440902474	0.273716440902474	false	false	false	true
2c26fce2-a106-4de2-ba2f-5660129935da	2026-09-08 10:59	2026-09-08 10:59	2026-09-08 10:59	XYL	XYL270115C00140000	call	140.0000	2027-01-15	0.9000	0.8500	0.9500	109.7050	16740.00	14310.00	0.00	186	9	341	4171	0.0817549748261808	0.290154334079733	0.290154334079733	false	false	false	true
0ba55bc6-d44c-4a83-981c-13f6d25b038a	2026-09-02 10:19	2026-09-02 10:19	2026-09-02 10:19	XYL	XYL261016C00110000	call	110.0000	2026-10-16	2.7500	2.5500	2.7500	106.8900	41525.00	41525.00	0.00	151	35	152	16	9.5	0.261119176291574	0.261119176291574	false	false	false	true
493e3700-424c-41ed-9a43-d74c6f087905	2026-09-02 09:32	2026-09-02 09:32	2026-09-02 09:32	XYL	XYL261218P00110000	put	110.0000	2026-12-18	7.5000	7.1000	7.5000	106.6100	19500.00	17250.00	0.00	26	16	26	428	0.0607476635514019	0.274834821520467	0.274834821520467	false	false	false	true
231bfd23-73bf-45ed-b183-944002164b54	2026-09-01 15:59	2026-09-01 15:59	2026-09-01 15:59	XYL	XYL270115C00140000	call	140.0000	2027-01-15	0.6500	0.6500	0.7000	106.7700	34916.00	680.00	34236.00	536	36	896	3849	0.232787737074565	0.284259821099137	0.284259821099137	false	false	false	true
0dc20d3f-9081-41dc-b1ee-9b1a6d21f4dc	2026-08-27 15:13	2026-08-27 15:13	2026-08-27 15:13	XYL	XYL261218C00115000	call	115.0000	2026-12-18	6.6000	6.3000	6.7000	112.0000	200640.00	199980.00	660.00	304	32	304	60	5.06666666666667	0.276387419174013	0.276387419174013	false	false	false	true
81c7636d-7044-40ce-be5f-02615850f3b5	2026-08-27 10:48	2026-08-27 10:48	2026-08-27 10:48	XYL	XYL261016P00100000	put	100.0000	2026-10-16	0.8200	0.7500	1.1000	111.3100	260800.00	0.00	260800.00	3200	2	3200	32	100	0.28895607960664	0.28895607960664	false	true	false	true
c8be8194-10b9-4046-87f3-c03f54ded94e	2026-08-27 10:26	2026-08-27 10:26	2026-08-27 10:26	XYL	XYL260918C00130000	call	130.0000	2026-09-18	0.1500	0.0000	0.3000	111.3100	105000.00	0.00	0.00	7000	1	7000	7065	0.990799716914367	0.347914745405698	0.347914745405698	false	true	true	false
b851a2ab-97ca-4bfa-9b4d-97aab2d517a9	2026-08-27 10:26	2026-08-27 10:26	2026-08-27 10:26	XYL	XYL260918C00120000	call	120.0000	2026-09-18	0.4600	0.4000	0.6000	111.3100	441600.00	0.00	441600.00	9600	1	9606	8839	1.08677452200475	0.259132338826908	0.259132338826908	false	true	true	false
1d21fb77-a9c1-40d0-940e-b916f87ac175	2026-08-24 10:43	2026-08-24 10:43	2026-08-24 10:43	XYL	XYL260918C00115000	call	115.0000	2026-09-18	2.9000	2.6500	3.1000	114.5800	13050.00	11890.00	1160.00	45	6	61	40	1.525	0.247352729737283	0.247352729737283	false	false	false	true
41a002d9-ff1a-414f-9224-55eae576a37b	2026-08-24 10:04	2026-08-24 10:04	2026-08-24 10:04	XYL	XYL260918C00120000	call	120.0000	2026-09-18	1.2500	0.9500	1.4500	114.5800	625000.00	625000.00	0.00	5000	2	5012	1791	2.79843662758236	0.259364733180919	0.259364733180919	false	true	true	false
a3fd6594-090e-4c04-8be5-00d1567cbbed	2026-08-20 14:01	2026-08-20 14:00	2026-08-20 14:00	XYL	XYL270115C00140000	call	140.0000	2027-01-15	1.3500	1.3000	1.4500	113.6000	17677.00	13635.00	1747.00	131	17	7774	6258	1.24224992010227	0.266522296545841	0.265918636320771	false	false	false	true
b8a8aa61-0bf2-404a-820e-e8600e8dc51d	2026-08-20 10:38	2026-08-20 10:38	2026-08-20 10:38	XYL	XYL270115C00140000	call	140.0000	2027-01-15	1.4500	1.4000	1.5000	114.3800	54085.00	37845.00	16240.00	373	11	7379	6258	1.17913071268776	0.265497237881902	0.265497237881902	false	false	false	true
fe2cbe62-e50a-4b22-9f82-18e3d814a441	2026-08-20 10:38	2026-08-20 10:38	2026-08-20 10:38	XYL	XYL270115C00140000	call	140.0000	2027-01-15	1.4500	1.4500	1.5000	114.4800	47885.00	1050.00	46835.00	330	5	7006	6258	1.11952700543305	0.264604852054423	0.267465048578326	false	false	false	true
c65177ab-6294-4f61-9bc1-4cc69266e778	2026-08-20 10:38	2026-08-20 10:38	2026-08-20 10:38	XYL	XYL270115C00140000	call	140.0000	2027-01-15	1.4500	1.4500	1.5000	114.3400	42195.00	0.00	42195.00	291	5	6676	6258	1.06679450303611	0.265854255801198	0.265854255801198	false	false	false	true
efaeb075-5aa1-4bf8-9f60-df5ec05c74b8	2026-08-20 10:38	2026-08-20 10:37	2026-08-20 10:37	XYL	XYL270115C00140000	call	140.0000	2027-01-15	1.4500	1.4500	1.5000	114.3400	30595.00	0.00	30595.00	211	8	5948	6258	0.950463406839246	0.265854255801198	0.265854255801198	false	false	false	true
b520f5d2-563c-47ec-b3ee-f200fc010866	2026-08-20 10:38	2026-08-20 10:37	2026-08-20 10:37	XYL	XYL270115C00140000	call	140.0000	2027-01-15	1.4500	1.4500	1.5000	114.3400	63365.00	0.00	63365.00	437	5	6385	6258	1.02029402364973	0.265854255801198	0.265854255801198	false	false	false	true
e23e29fd-c06c-4697-81a3-9bff60ecea2a	2026-08-20 10:38	2026-08-20 10:37	2026-08-20 10:37	XYL	XYL270115C00140000	call	140.0000	2027-01-15	1.4500	1.4250	1.4750	114.3300	36395.00	36250.00	0.00	251	5	5737	6258	0.916746564397571	0.265943516008055	0.265943516008055	false	false	false	true
19e0a570-f5fb-4202-8634-16dbd34b6f61	2026-08-20 10:38	2026-08-20 10:37	2026-08-20 10:37	XYL	XYL270115C00140000	call	140.0000	2027-01-15	1.4500	1.4000	1.5000	114.4100	51765.00	48720.00	0.00	357	17	5486	6258	0.876637903483541	0.265229498385189	0.265229498385189	false	false	false	true
8b452098-0276-4c1e-95f1-dc92e3d3e14f	2026-08-20 10:37	2026-08-20 10:37	2026-08-20 10:37	XYL	XYL270115C00140000	call	140.0000	2027-01-15	1.4500	1.4000	1.5000	114.3400	74240.00	5655.00	58870.00	512	7	5077	6258	0.811281559603707	0.265229498385189	0.265854255801198	false	false	false	true
628a0120-3dc9-438f-846e-eaa8b37a5dc8	2026-08-20 10:36	2026-08-20 10:36	2026-08-20 10:36	XYL	XYL270115C00140000	call	140.0000	2027-01-15	1.4000	1.3500	1.4500	114.3250	43680.00	35000.00	6160.00	312	5	4185	6258	0.668744007670182	0.263080890785324	0.263080890785324	false	false	false	true
4f31bc31-0654-4793-b271-9f722625d39b	2026-08-20 10:36	2026-08-20 10:36	2026-08-20 10:36	XYL	XYL270115C00140000	call	140.0000	2027-01-15	1.4000	1.3500	1.5000	114.3250	36540.00	0.00	36260.00	261	15	3640	6258	0.58165548098434	0.263080890785324	0.263080890785324	false	false	false	true
1698349e-c31d-4f94-bb4f-5392f92de37f	2026-08-20 10:36	2026-08-20 10:36	2026-08-20 10:36	XYL	XYL270115C00140000	call	140.0000	2027-01-15	1.4000	1.3500	1.5000	114.4920	18620.00	0.00	17500.00	133	12	3275	6258	0.523330137424097	0.261600654811901	0.261600654811901	false	false	false	true
70ea7505-37cc-4de4-84be-5fd2c7f178ed	2026-08-20 10:36	2026-08-20 10:35	2026-08-20 10:35	XYL	XYL270115C00140000	call	140.0000	2027-01-15	1.4000	1.3000	1.4000	114.4920	58240.00	58240.00	0.00	416	17	3061	6258	0.489133908596996	0.261600654811901	0.261600654811901	false	false	false	true
800ce31a-1ab5-4ae9-b6d3-3aefe4d459d2	2026-08-20 10:35	2026-08-20 10:35	2026-08-20 10:35	XYL	XYL270115C00140000	call	140.0000	2027-01-15	1.4000	1.3000	1.5000	114.4920	36680.00	34580.00	0.00	262	17	2645	6258	0.4226589964845	0.261600654811901	0.261600654811901	false	false	false	true
14314ee9-ef27-431b-b5f5-f75772b7504f	2026-08-20 10:35	2026-08-20 10:35	2026-08-20 10:35	XYL	XYL270115C00140000	call	140.0000	2027-01-15	1.4500	1.3000	1.4500	114.4920	36250.00	36250.00	0.00	250	15	2383	6258	0.380792585490572	0.264497780881152	0.264497780881152	false	false	false	true
36c95a08-3e14-4cc1-bfd8-67d007d2a3c1	2026-08-20 10:34	2026-08-20 10:34	2026-08-20 10:34	XYL	XYL270115C00140000	call	140.0000	2027-01-15	1.4500	1.3000	1.4500	114.5050	16385.00	16385.00	0.00	113	29	2133	6258	0.340843720038351	0.264381790740872	0.264381790740872	false	false	false	true
bbd5fca9-ec45-4401-93fc-3e925c1b66bc	2026-08-20 10:34	2026-08-20 10:34	2026-08-20 10:34	XYL	XYL270115C00140000	call	140.0000	2027-01-15	1.3200	1.2500	1.4250	114.6700	80255.00	3120.00	39495.00	610	30	1964	6258	0.313838286992649	0.254129214141157	0.257097548117333	false	false	false	true
af124e82-e6e4-4152-aab8-905302218a1b	2026-08-20 10:34	2026-08-20 10:34	2026-08-20 10:34	XYL	XYL270115C00140000	call	140.0000	2027-01-15	1.4500	1.2500	1.4500	115.0900	41820.00	41820.00	0.00	289	19	1337	6258	0.213646532438479	0.256305149678163	0.259165999521018	false	false	false	true
6b00a484-031e-4f7d-90d7-5f09b4b089af	2026-08-20 10:34	2026-08-20 10:34	2026-08-20 10:34	XYL	XYL270115C00140000	call	140.0000	2027-01-15	1.3800	1.3000	1.4000	115.0900	69010.00	42010.00	0.00	501	27	998	6258	0.159475870885267	0.253405153419067	0.256305149678163	false	false	false	true
067432da-2f26-4f86-a6b5-78912a67519d	2026-08-20 10:34	2026-08-20 10:34	2026-08-20 10:34	XYL	XYL270115C00140000	call	140.0000	2027-01-15	1.5500	1.5000	1.5500	115.1300	31465.00	8990.00	0.00	203	7	495	6258	0.0790987535953979	0.264418118396867	0.264418118396867	false	false	false	true
cc751110-9528-49ad-98ed-d75e9e556b53	2026-08-20 10:34	2026-08-20 10:33	2026-08-20 10:33	XYL	XYL270115C00140000	call	140.0000	2027-01-15	1.7000	1.6000	1.7000	115.2550	48280.00	14450.00	0.00	284	16	284	6258	0.0453819111537232	0.271439508695075	0.271439508695075	false	false	false	true