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 = RepeatedHits×ticker = XYL×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	expirydate

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	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Industrials	25097497422.00	2026-10-27	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-20T14:48:30.894899Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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