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.

474,253 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts474,253 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:source = uw_flow_alerts×ticker = LRCX×

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

26952411-fdce-4c12-907e-8c689f7780f4	2026-08-31 11:37	2026-08-31 11:37	2026-08-31 11:37	LRCX	LRCX280121C00350000	call	350.0000	2028-01-21	73.5300	73.5000	75.9500	299.7500	183830.00	14780.00	169050.00	25	7	106	457	0.231947483588621	0.607269789562272	0.604361752090723	true	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	Common Stock	Technology	342223780290.00	2026-10-28	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-31T16:06:41.823379Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
d3cee2b6-a4ab-4d9e-9ae4-4a386c0e6934	2026-08-31 10:56	2026-08-31 10:55	2026-08-31 10:55	LRCX	LRCX261120P00290000	put	290.0000	2026-11-20	26.3600	25.9000	27.5500	302.0800	50085.00	2650.00	47435.00	19	11	68	1122	0.0606060606060606	0.600120799323518	0.602898470093265	false	false	false	true
c05e7e2f-867d-4fc0-aefb-d4d1c765d4c3	2026-08-31 10:51	2026-08-31 10:50	2026-08-31 10:50	LRCX	LRCX270617C00410000	call	410.0000	2027-06-17	35.8900	35.9000	36.2000	301.6400	53830.00	0.00	53830.00	15	5	46	277	0.166064981949458	0.606256825775837	0.606736181810211	false	false	false	true
0f76b51b-7e0f-4685-b3c4-d8030122f0ec	2026-08-31 10:35	2026-08-31 10:35	2026-08-31 10:35	LRCX	LRCX281215C00450000	call	450.0000	2028-12-15	82.1500	79.0000	82.4000	301.1500	139655.00	131515.00	8140.00	17	10	17	85	0.2	0.627191436838176	0.622741753623875	false	false	false	true
4fe13d35-296e-4f07-b30d-ccb5330aec9f	2026-08-31 10:09	2026-08-31 10:09	2026-08-31 10:09	LRCX	LRCX270617P00270000	put	270.0000	2027-06-17	42.7500	42.4000	43.4500	299.5900	106875.00	25650.00	81225.00	25	5	522	490	1.06530612244898	0.609907553851303	0.609907553851303	false	false	false	true
4c2c9f6b-e452-4859-a08d-b2af3d20c7d5	2026-08-31 10:05	2026-08-31 10:05	2026-08-31 10:05	LRCX	LRCX261120P00310000	put	310.0000	2026-11-20	38.4000	38.2500	38.4000	299.9000	322560.00	15360.00	0.00	84	5	107	584	0.183219178082192	0.609959863110467	0.607760012927423	false	false	false	true
02523711-a045-4c16-9a52-9fb60d77d0d5	2026-08-31 10:05	2026-08-31 10:05	2026-08-31 10:05	LRCX	LRCX261120P00290000	put	290.0000	2026-11-20	27.8900	27.6500	29.1000	300.0150	58560.00	2785.00	55775.00	21	6	23	1122	0.0204991087344029	0.616117232612989	0.613341056186412	true	false	false	true
cd888147-919a-4f3f-be88-fa787fc90c02	2026-08-28 15:52	2026-08-28 15:51	2026-08-28 15:51	LRCX	LRCX261016C00320000	call	320.0000	2026-10-16	19.0300	19.0000	19.8500	303.7600	57085.00	11430.00	45655.00	30	11	111	368	0.301630434782609	0.565115160330079	0.56624981011242	false	false	false	true
912d1771-e791-43c7-8457-e42a150fe320	2026-08-28 15:50	2026-08-28 15:50	2026-08-28 15:50	LRCX	LRCX260918C00310000	call	310.0000	2026-09-18	14.0000	12.8000	14.0000	304.7000	58800.00	58800.00	0.00	42	6	76	1482	0.0512820512820513	0.552040060643104	0.552040060643104	false	false	false	true
45ac1329-6e14-4fa9-a996-c20a8f88715b	2026-08-28 15:00	2026-08-28 15:00	2026-08-28 15:00	LRCX	LRCX270617P00300000	put	300.0000	2027-06-17	58.0500	56.7500	58.1000	304.7900	174165.00	174165.00	0.00	30	10	90	200	0.45	0.619113739423658	0.61928842101934	false	false	false	true
d99e4844-68a4-4d24-baea-8b38b18731c6	2026-08-28 14:59	2026-08-28 14:59	2026-08-28 14:59	LRCX	LRCX270617P00300000	put	300.0000	2027-06-17	58.1000	56.7000	58.6250	304.9600	104580.00	104580.00	0.00	18	6	48	200	0.24	0.619884627999581	0.619884627999581	false	false	false	true
9d212711-6ec4-4be1-af6f-aeda891c47ad	2026-08-28 14:59	2026-08-28 14:59	2026-08-28 14:59	LRCX	LRCX270617P00300000	put	300.0000	2027-06-17	58.1000	56.7000	58.1000	304.9600	104580.00	104580.00	0.00	18	6	30	200	0.15	0.620059828395732	0.619884627999581	false	false	false	true
93c9a0f9-8fe8-4779-bd8d-3f92ce8a65f1	2026-08-28 14:56	2026-08-28 14:56	2026-08-28 14:56	LRCX	LRCX261120P00300000	put	300.0000	2026-11-20	31.8500	31.5000	31.8500	304.4200	50960.00	50960.00	0.00	16	8	39	682	0.0571847507331378	0.614685055725579	0.614685055725579	false	false	false	true
1149b744-ee35-45a2-b19b-4e9d48cdff69	2026-08-28 14:30	2026-08-28 14:30	2026-08-28 14:30	LRCX	LRCX261016P00280000	put	280.0000	2026-10-16	13.3500	13.2000	13.9500	305.0000	449946.00	2700.00	447246.00	337	45	2390	673	3.55126300148588	0.571490021144693	0.577962901172463	true	false	false	true
833c67c0-9789-42ef-ab20-e18d1dfb207c	2026-08-28 14:15	2026-08-28 14:15	2026-08-28 14:15	LRCX	LRCX280121C00500000	call	500.0000	2028-01-21	46.0300	45.8000	48.0000	305.3650	69048.00	13820.00	55228.00	15	11	21	557	0.0377019748653501	0.620832589961573	0.620832589961573	true	false	false	true
f386f54b-2dfb-4d3d-8799-9bc76569d2a0	2026-08-28 12:46	2026-08-28 12:46	2026-08-28 12:46	LRCX	LRCX261120C00340000	call	340.0000	2026-11-20	24.0500	24.0500	25.2000	305.4400	84175.00	0.00	84175.00	35	7	53	634	0.083596214511041	0.616837707862115	0.616837707862115	false	false	false	true
d2048068-f99a-42b7-994f-2afe43fd4ced	2026-08-28 11:46	2026-08-28 11:45	2026-08-28 11:45	LRCX	LRCX261218C00320000	call	320.0000	2026-12-18	38.5500	38.5500	40.1000	310.0000	111795.00	0.00	111795.00	29	8	214	652	0.328220858895706	0.603743386567524	0.603743386567524	false	false	false	true
992995a9-da0b-4cc2-a2ea-5c2081425501	2026-08-28 11:41	2026-08-28 11:41	2026-08-28 11:41	LRCX	LRCX260918C00335000	call	335.0000	2026-09-18	7.5100	7.2000	9.2500	310.0000	102935.00	43245.00	59690.00	137	26	137	109	1.25688073394495	0.531739130627942	0.547052731626492	true	false	false	true
f702bb16-27ac-4d60-901f-b842e6ecc26f	2026-08-28 11:14	2026-08-28 11:14	2026-08-28 11:14	LRCX	LRCX270319P00260000	put	260.0000	2027-03-19	27.8300	26.9000	28.3000	313.3550	211480.00	119825.00	91655.00	76	22	91	495	0.183838383838384	0.625117308196473	0.626470275922344	false	false	false	true
024c3289-548c-4726-aa26-91bc16a9ea6e	2026-08-28 10:56	2026-08-28 10:56	2026-08-28 10:56	LRCX	LRCX261218C00320000	call	320.0000	2026-12-18	42.2000	42.2000	43.7500	315.7050	523285.00	0.00	519060.00	124	34	165	652	0.253067484662577	0.610910556033271	0.610910556033271	false	false	false	true
1b05b267-3d35-4f62-b2ee-3a6428ca49b6	2026-08-28 10:18	2026-08-28 10:18	2026-08-28 10:18	LRCX	LRCX261016P00310000	put	310.0000	2026-10-16	23.1500	23.1000	24.0000	315.6600	76390.00	9280.00	67110.00	33	26	36	634	0.056782334384858	0.584642685392186	0.584642685392186	true	false	false	true
dd0c1c66-d612-4bc3-aa36-d3a8adfdcff3	2026-08-28 10:07	2026-08-28 10:07	2026-08-28 10:07	LRCX	LRCX261218C00320000	call	320.0000	2026-12-18	42.2500	42.2500	44.5500	314.9550	173225.00	0.00	173225.00	41	7	41	652	0.0628834355828221	0.617791430497706	0.617791430497706	false	false	false	true
45d4c537-2c14-444d-949d-3de5eb5228e3	2026-08-28 09:36	2026-08-28 09:36	2026-08-28 09:36	LRCX	LRCX261016C00330000	call	330.0000	2026-10-16	20.1500	20.1000	21.5500	311.6300	513831.00	0.00	473531.00	255	47	255	913	0.279299014238773	0.593487684960923	0.593487684960923	false	false	false	true
beeb6eee-4b6f-49e4-bf16-5e36b6c504af	2026-08-28 09:31	2026-08-28 09:31	2026-08-28 09:31	LRCX	LRCX270319C00400000	call	400.0000	2027-03-19	34.3400	33.1000	34.8500	314.5700	243845.00	13735.00	230110.00	71	26	462	374	1.23529411764706	0.633639607334604	0.633091676655499	false	false	false	true
999f57bf-47c7-486b-be09-574be0e8a9ba	2026-08-28 09:31	2026-08-28 09:31	2026-08-28 09:31	LRCX	LRCX270319C00400000	call	400.0000	2027-03-19	34.4000	34.4000	34.9000	314.5700	192640.00	0.00	192640.00	56	18	391	374	1.04545454545455	0.632250163713476	0.634187463829272	false	false	false	true
ec8cbfc6-0ebd-445f-81c0-e019329e595c	2026-08-28 09:31	2026-08-28 09:31	2026-08-28 09:31	LRCX	LRCX270319C00400000	call	400.0000	2027-03-19	34.4500	34.4500	34.9500	315.0000	82680.00	0.00	72345.00	24	8	335	374	0.89572192513369	0.632797105326492	0.632797105326492	false	false	false	true
6e44e4bc-6452-41e7-9bae-b42a1981ca0a	2026-08-28 09:31	2026-08-28 09:31	2026-08-28 09:31	LRCX	LRCX270319C00400000	call	400.0000	2027-03-19	34.4500	34.4500	34.9500	315.2600	137800.00	0.00	137800.00	40	6	311	374	0.831550802139037	0.631625969949914	0.631625969949914	false	false	false	true
7f349113-6354-4c89-85f6-24278655b2f1	2026-08-28 09:31	2026-08-28 09:30	2026-08-28 09:30	LRCX	LRCX270319C00400000	call	400.0000	2027-03-19	34.4300	34.4000	35.3500	315.3750	585350.00	0.00	337310.00	170	30	266	374	0.711229946524064	0.631108150310801	0.630561940666924	false	false	false	true
3d09aa10-4020-48d9-b229-09db6b462c93	2026-08-28 09:30	2026-08-28 09:30	2026-08-28 09:30	LRCX	LRCX270319C00400000	call	400.0000	2027-03-19	34.0800	33.3500	35.6500	313.8500	306730.00	10230.00	40875.00	90	26	90	374	0.240641711229947	0.634138125034185	0.633588400887879	false	false	false	true
3d0ca67b-e4f5-47f6-b9e1-bece0873cbf2	2026-08-27 15:50	2026-08-27 15:50	2026-08-27 15:50	LRCX	LRCX260828C00290000	call	290.0000	2026-08-28	25.6500	25.6000	27.1500	315.3900	128250.00	0.00	128250.00	50	14	479	529	0.905482041587902	0.900528316808449	0.874101049376371	true	false	false	true
3b409594-a2e3-4465-b3d9-ae236ad2b03b	2026-08-27 15:30	2026-08-27 15:30	2026-08-27 15:30	LRCX	LRCX260828C00290000	call	290.0000	2026-08-28	25.0000	24.8000	26.7000	314.0000	62500.00	0.00	62500.00	25	8	354	529	0.669187145557656	0.817780098910103	0.817780098910103	true	false	false	true
6c196513-b30f-40a2-9fb1-0f805bc78322	2026-08-27 15:30	2026-08-27 15:30	2026-08-27 15:30	LRCX	LRCX260828C00290000	call	290.0000	2026-08-28	25.2000	25.2000	26.7000	315.0000	63000.00	0.00	63000.00	25	8	329	529	0.621928166351607	0.846283836230723	0.846283836230723	false	false	false	true
c172679c-c8db-484a-b4e0-3ee0e84719c5	2026-08-27 11:25	2026-08-27 11:25	2026-08-27 11:25	LRCX	LRCX270617C00400000	call	400.0000	2027-06-17	47.1500	46.7500	47.1500	314.9050	61295.00	61295.00	0.00	13	5	101	889	0.113610798650169	0.634940089489518	0.634960836646207	false	false	false	true
2a7370c5-aff6-4678-be21-0c79c7b429e4	2026-08-27 11:13	2026-08-27 11:13	2026-08-27 11:13	LRCX	LRCX261120P00280000	put	280.0000	2026-11-20	20.7800	20.1500	22.1000	315.1650	168280.00	79040.00	89240.00	81	7	213	752	0.283244680851064	0.643103656752811	0.6440697566919	false	false	false	true
bcf463a7-9c2e-4220-afa4-f49165e6389b	2026-08-27 10:44	2026-08-27 10:44	2026-08-27 10:44	LRCX	LRCX270319P00280000	put	280.0000	2027-03-19	37.3500	37.3500	38.9000	313.5625	56025.00	0.00	56025.00	15	13	15	925	0.0162162162162162	0.62999713901967	0.62999713901967	false	false	false	true
7a6b0741-1892-4c88-b222-fba9c8c8e218	2026-08-26 11:30	2026-08-26 11:30	2026-08-26 11:30	LRCX	LRCX260918C00300000	call	300.0000	2026-09-18	26.0000	25.3000	27.0500	313.0600	156020.00	0.00	156020.00	60	22	72	1211	0.0594549958711808	0.596238571829407	0.596238571829407	false	false	false	true
fcb67c67-de5e-448b-a460-522d703ac2d3	2026-08-26 11:29	2026-08-26 11:28	2026-08-26 11:28	LRCX	LRCX270319C00450000	call	450.0000	2027-03-19	24.3500	23.8000	25.2500	313.0200	976435.00	370120.00	606315.00	401	29	401	88	4.55681818181818	0.63719468993166	0.636928842493245	false	false	false	true
2b388c3c-8df5-4104-af81-0ab390ee7d15	2026-08-26 10:49	2026-08-26 10:49	2026-08-26 10:49	LRCX	LRCX270115P00280000	put	280.0000	2027-01-15	30.3500	29.9500	30.7000	312.1000	66770.00	63735.00	3035.00	22	8	25	1109	0.0225428313796213	0.637769591868285	0.637769591868285	false	false	false	true
e784daf8-87bb-437c-a85f-db88ab92d52f	2026-08-25 14:04	2026-08-25 14:04	2026-08-25 14:04	LRCX	LRCX260918C00400000	call	400.0000	2026-09-18	1.6500	1.4500	1.6600	311.0000	64845.00	64515.00	165.00	393	29	495	5517	0.0897226753670473	0.638508746183577	0.638508746183577	true	false	false	true
f84f4bbc-30b6-4887-940f-d3cb090167ed	2026-08-25 09:40	2026-08-25 09:40	2026-08-25 09:40	LRCX	LRCX261016P00300000	put	300.0000	2026-10-16	20.9000	20.7500	21.2500	314.8500	313500.00	296780.00	16720.00	150	14	394	399	0.987468671679198	0.61828583688544	0.616167628865098	false	false	false	true
1953e2e5-9cb7-4b34-bde0-a369cfa008c3	2026-08-25 09:40	2026-08-25 09:40	2026-08-25 09:40	LRCX	LRCX261016P00300000	put	300.0000	2026-10-16	20.9800	20.7500	21.0500	314.7700	195140.00	195140.00	0.00	93	7	217	399	0.543859649122807	0.620628939845964	0.61663466166429	false	false	false	true
908d67ac-91f9-43f4-8d21-9a8c71a80bf2	2026-08-24 12:41	2026-08-24 12:41	2026-08-24 12:41	LRCX	LRCX261016P00340000	put	340.0000	2026-10-16	49.1500	48.3500	49.7000	305.7900	78640.00	4915.00	73725.00	16	16	19	142	0.133802816901408	0.62046340239084	0.62046340239084	false	false	false	true
85f66b49-1ab0-4c9a-85b2-bb8e514e59de	2026-08-24 12:05	2026-08-24 12:05	2026-08-24 12:05	LRCX	LRCX270617P00250000	put	250.0000	2027-06-17	36.2700	35.6000	36.3500	306.0800	50775.00	25445.00	25330.00	14	6	195	3347	0.0582611293695847	0.654099192444966	0.652761571029888	false	false	false	true
3488cf82-d59c-4863-98b0-3b8e5a23a344	2026-08-24 12:04	2026-08-24 12:04	2026-08-24 12:04	LRCX	LRCX270617P00280000	put	280.0000	2027-06-17	49.9300	49.8500	50.0000	305.8100	94875.00	54940.00	24950.00	19	7	303	718	0.422005571030641	0.645543887960567	0.644330471917964	false	false	false	true
5e5f569e-cf5c-4609-86af-a1303b6c8891	2026-08-24 12:04	2026-08-24 12:03	2026-08-24 12:03	LRCX	LRCX270617C00300000	call	300.0000	2027-06-17	76.3500	76.1500	76.7500	306.2200	99255.00	53445.00	45810.00	13	5	362	153	2.36601307189542	0.643891182523704	0.643574508691918	false	false	false	true
51b08e15-a89b-462d-a258-406068549bd2	2026-08-24 12:03	2026-08-24 12:03	2026-08-24 12:03	LRCX	LRCX270617C00300000	call	300.0000	2027-06-17	76.4500	76.1500	76.6000	306.1400	107035.00	107035.00	0.00	14	6	339	153	2.2156862745098	0.644893365724945	0.64456936066254	false	false	false	true
3d08adac-e771-47f9-8a76-3e82988e56f0	2026-08-24 12:02	2026-08-24 12:02	2026-08-24 12:02	LRCX	LRCX260918C00320000	call	320.0000	2026-09-18	14.3300	14.0000	14.9500	306.6700	63055.00	10045.00	53010.00	44	10	62	1320	0.046969696969697	0.61070381216799	0.61228801333517	false	false	false	true
7b3e41ce-2e9e-4caf-b2f7-1a3290db71f7	2026-08-21 15:44	2026-08-21 15:43	2026-08-21 15:43	LRCX	LRCX270115C00420000	call	420.0000	2027-01-15	21.1500	20.7000	21.1500	312.5300	270720.00	270720.00	0.00	128	6	145	289	0.501730103806228	0.641863751614824	0.641863751614824	false	false	false	true
459233c5-2c1f-4c8f-a80c-49260f743a6a	2026-08-21 15:40	2026-08-21 15:40	2026-08-21 15:40	LRCX	LRCX260918P00310000	put	310.0000	2026-09-18	18.5500	18.4000	18.5500	313.1100	96460.00	96460.00	0.00	52	10	79	870	0.0908045977011494	0.596860202535848	0.596860202535848	false	false	false	true
aaeffed5-c14b-4323-b1d7-a247e719f312	2026-08-21 15:23	2026-08-21 15:23	2026-08-21 15:23	LRCX	LRCX261218C00350000	call	350.0000	2026-12-18	33.7500	33.7500	34.7000	313.8000	128250.00	0.00	128250.00	38	5	57	363	0.15702479338843	0.642982933108501	0.642982933108501	false	false	false	true