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:sector = Consumer Defensive×source = uw_flow_alerts×ticker = LW×

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

4740b5bf-d42d-4d9a-aa5d-a329fbc89eda	2026-09-21 12:21	2026-09-21 12:21	2026-09-21 12:21	LW	LW270115P00040000	put	40.0000	2027-01-15	1.3200	1.3000	1.6500	47.2600	33000.00	0.00	33000.00	250	6	500	1704	0.293427230046948	0.417056069020176	0.425539346254753	false	false	false	true	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	Common Stock	Consumer Defensive	6501477010.00	2026-10-06	premarket	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-21T16:25:44.384112Z"}	2026-09-21	2026-09-21 21:15	2026-09-21 21:15
41c2aee6-98c6-4731-a358-1aad5243d97c	2026-09-21 12:21	2026-09-21 12:21	2026-09-21 12:21	LW	LW270115P00040000	put	40.0000	2027-01-15	1.3200	1.2500	1.6500	47.0000	33000.00	3900.00	29100.00	250	15	250	1704	0.146713615023474	0.415739498563257	0.43079222972524	false	false	false	true
b4135f25-f8d4-4e8f-9314-b22c63966b94	2026-09-18 09:52	2026-09-18 09:52	2026-09-18 09:52	LW	LW261016P00037500	put	37.5000	2026-10-16	0.2100	0.2000	0.3500	46.1200	296730.00	0.00	296730.00	14130	2	14130	240	58.875	0.524699014693951	0.524699014693951	false	true	false	true
3bef91ff-8c41-45bf-b1bc-03810c89b783	2026-09-18 09:52	2026-09-18 09:52	2026-09-18 09:52	LW	LW261016P00037500	put	37.5000	2026-10-16	0.2100	0.2000	0.3500	46.1200	296730.00	0.00	296730.00	14130	2	14130	240	58.875	0.524699014693951	0.524699014693951	false	true	false	true
71c76b72-06c8-4ff8-9559-759e5c99bc9f	2026-09-03 11:03	2026-09-03 11:03	2026-09-03 11:03	LW	LW270115P00040000	put	40.0000	2027-01-15	1.0500	0.9500	1.7500	50.4000	26250.00	0.00	26250.00	250	5	250	1452	0.172176308539945	0.426969263532616	0.426969263532616	false	false	false	true
ed983e53-8f2c-4507-93e1-07ba32fd9eef	2026-09-03 10:46	2026-09-03 10:46	2026-09-03 10:46	LW	LW270115P00042500	put	42.5000	2027-01-15	1.5500	1.4000	1.7500	50.4950	38750.00	3875.00	34875.00	250	5	260	1342	0.193740685543964	0.417886881535622	0.417886881535622	false	false	false	true
010dc3bc-2d9c-42a5-acfd-0c076c29b5ae	2026-09-02 15:42	2026-09-02 15:41	2026-09-02 15:41	LW	LW270115C00065000	call	65.0000	2027-01-15	1.1000	1.1000	1.2500	52.3500	19910.00	0.00	19910.00	181	10	250	4143	0.0603427468018344	0.346607039636629	0.346607039636629	false	false	false	true
57fd761e-1870-483c-85b7-cffaa8cd00d5	2026-09-02 10:29	2026-09-02 10:29	2026-09-02 10:29	LW	LW270115P00042500	put	42.5000	2027-01-15	1.2500	1.2500	1.7500	52.4101	28500.00	0.00	28500.00	228	13	229	1093	0.209515096065874	0.420816456499875	0.420816456499875	false	false	false	true
ea908010-05eb-46d8-ab28-0f243687e10a	2026-09-02 10:18	2026-09-02 10:18	2026-09-02 10:18	LW	LW270115P00040000	put	40.0000	2027-01-15	0.8500	0.6000	1.4000	52.5028	21250.00	7820.00	13430.00	250	5	250	1201	0.208159866777685	0.435436036034004	0.435436036034004	false	false	false	true
fa171d4e-f4bb-47c0-b604-c2a7f5cf1fb4	2026-09-01 15:45	2026-09-01 15:45	2026-09-01 15:45	LW	LW270115P00040000	put	40.0000	2027-01-15	0.8000	0.7500	0.8500	52.8850	12000.00	1840.00	10160.00	150	7	258	957	0.269592476489028	0.431004521108353	0.431004521108353	false	false	false	true
1815c103-34dc-42aa-873d-4d6a25f34c2c	2026-09-01 15:28	2026-09-01 15:28	2026-09-01 15:28	LW	LW280121P00060000	put	60.0000	2028-01-21	12.4000	11.9000	12.4000	52.9600	28519.00	28519.00	0.00	23	10	23	2	11.5	0.398580860997987	0.398580860997987	false	false	false	true
d4efe676-09f1-4c5f-8750-3b5891f9899d	2026-09-01 10:18	2026-09-01 10:18	2026-09-01 10:18	LW	LW270115C00065000	call	65.0000	2027-01-15	1.7500	1.7500	1.8000	54.8850	43750.00	0.00	43750.00	250	5	250	3643	0.0686247598133407	0.352825901643686	0.352825901643686	false	false	false	true
89d3f1ed-d10e-4b3a-b5cd-ab8bf2c971de	2026-08-28 15:24	2026-08-28 15:23	2026-08-28 15:23	LW	LW270115C00065000	call	65.0000	2027-01-15	1.9000	1.9000	2.8000	55.3500	28500.00	0.00	25080.00	150	6	301	3295	0.091350531107739	0.347650136792982	0.347650136792982	false	false	false	true
7c28b153-cfaf-43e9-b20c-795041ccf45c	2026-08-27 11:25	2026-08-27 11:25	2026-08-27 11:25	LW	LW270115C00065000	call	65.0000	2027-01-15	1.9000	1.8500	2.7500	55.2500	37816.00	0.00	37816.00	199	6	650	2676	0.242899850523169	0.350235490497904	0.350235490497904	false	false	false	true
54206222-8209-4bd3-887a-bc8207db1715	2026-08-27 10:24	2026-08-27 10:24	2026-08-27 10:24	LW	LW270115C00065000	call	65.0000	2027-01-15	1.7500	1.7000	1.8500	55.1300	35006.00	4550.00	30456.00	200	19	204	2676	0.0762331838565022	0.340083069243051	0.340083069243051	false	false	false
1aedf5c0-47b9-4d61-a86a-2e4fef1fdd1f	2026-08-26 14:24	2026-08-26 14:24	2026-08-26 14:24	LW	LW270115P00042500	put	42.5000	2027-01-15	1.0000	0.8500	1.7000	54.8550	15000.00	12700.00	2300.00	150	6	150	387	0.387596899224806	0.423344792513733	0.423344792513733	false	false	false	true
a93dee57-3d64-4d9e-a0a8-35354fae3a60	2026-08-25 09:58	2026-08-25 09:58	2026-08-25 09:58	LW	LW270115P00042500	put	42.5000	2027-01-15	1.1000	0.9000	1.4500	53.7700	16500.00	0.00	16500.00	150	18	150	275	0.545454545454545	0.416274840284727	0.416274840284727	false	false	false	true
93ce6f7c-31ff-409f-94fe-f21f6ff2a3cc	2026-08-24 14:27	2026-08-24 14:27	2026-08-24 14:27	LW	LW270115C00065000	call	65.0000	2027-01-15	1.9000	1.9000	2.0000	55.0550	28500.00	0.00	28500.00	150	17	502	1992	0.252008032128514	0.349359077877161	0.349359077877161	false	false	false	true
27c06caa-3614-45b8-a1d0-9a7143f8894d	2026-08-21 15:51	2026-08-21 15:51	2026-08-21 15:51	LW	LW270115C00065000	call	65.0000	2027-01-15	1.6500	1.1500	1.7500	53.6300	34320.00	8250.00	22770.00	208	6	752	1241	0.605962933118453	0.357006078102342	0.357006078102342	false	false	false	true
859b8d92-9147-40d2-b0fd-936eaabe66b1	2026-08-21 15:16	2026-08-21 15:16	2026-08-21 15:16	LW	LW270115P00040000	put	40.0000	2027-01-15	0.8500	0.8500	0.9500	53.6475	25500.00	0.00	25500.00	300	7	501	346	1.44797687861272	0.43823018002565	0.43823018002565	false	false	false	true
9c2f5922-9801-4287-a309-b358a0b50f63	2026-08-21 11:09	2026-08-21 11:08	2026-08-21 11:08	LW	LW270115C00065000	call	65.0000	2027-01-15	1.8000	1.8000	1.9000	54.0900	27000.00	0.00	27000.00	150	5	265	1241	0.213537469782434	0.359744800383484	0.359744800383484	false	false	false	true
a8f76478-a814-405f-bcb9-a2ae5ecef4af	2026-08-19 14:12	2026-08-19 14:11	2026-08-19 14:11	LW	LW261016C00057500	call	57.5000	2026-10-16	2.0500	2.0000	2.2000	53.6500	30135.00	26445.00	3690.00	147	27	157	324	0.484567901234568	0.400988762686349	0.400988762686349	false	false	false	true
321e9fa8-9445-4646-8ab6-a3f6376bb545	2026-08-19 13:49	2026-08-19 13:49	2026-08-19 13:49	LW	LW270115C00065000	call	65.0000	2027-01-15	1.6500	1.4000	1.7000	53.1800	24750.00	4950.00	19800.00	150	5	307	209	1.4688995215311	0.364768132736554	0.364768132736554	false	false	false	true
77d1dffb-680d-43c2-9d32-060dfe850a9f	2026-08-19 12:51	2026-08-19 12:51	2026-08-19 12:51	LW	LW270115C00065000	call	65.0000	2027-01-15	1.6500	1.3500	1.7000	53.0550	15180.00	2805.00	10395.00	92	6	92	209	0.440191387559809	0.367661309338259	0.367661309338259	false	false	false	true