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:alert_rule = RepeatedHits×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

6eb1764e-8432-43c1-a801-4e4fbb087ed2	2026-09-10 11:25	2026-09-10 11:25	2026-09-10 11:25	LRCX	LRCX280121P00230000	put	230.0000	2028-01-21	37.7500	36.8000	37.7500	303.8603	135900.00	135900.00	0.00	36	7	78	435	0.179310344827586	0.623803650003108	0.623803650003108	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Technology	342223780290.00	2026-10-28	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-10T15:47:40.219521Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
021d7234-83fa-46a4-89ea-d21ee2baae9d	2026-09-10 10:59	2026-09-10 10:58	2026-09-10 10:58	LRCX	LRCX270617P00270000	put	270.0000	2027-06-17	41.8000	41.7000	41.8000	303.9750	71060.00	71060.00	0.00	17	8	22	948	0.0232067510548523	0.623091388723398	0.623091388723398	false	false	false	true
71831297-5ce8-4228-9f91-1d72cf5cd585	2026-09-10 09:54	2026-09-10 09:54	2026-09-10 09:54	LRCX	LRCX270115C00440000	call	440.0000	2027-01-15	11.6000	11.6000	13.8000	299.9900	95130.00	0.00	92810.00	82	10	82	989	0.0829120323559151	0.637921697771945	0.637921697771945	false	false	false	true
ee02aea4-a1a7-4614-b44b-ac08ded2aa2b	2026-09-10 09:53	2026-09-10 09:53	2026-09-10 09:53	LRCX	LRCX270115C00390000	call	390.0000	2027-01-15	18.3000	18.2500	18.3000	299.9400	576450.00	430050.00	0.00	315	7	315	666	0.472972972972973	0.621731418184868	0.621731418184868	false	false	false	true
64bb2700-a3b7-48dc-8bc0-65fed5e5388b	2026-09-10 09:53	2026-09-10 09:53	2026-09-10 09:53	LRCX	LRCX261120C00350000	call	350.0000	2026-11-20	17.3000	17.0500	19.9500	299.9400	190300.00	1730.00	183380.00	110	16	110	638	0.172413793103448	0.637795761977662	0.639120935148686	false	false	false	true
d2cfeaf0-d2e9-46ba-9d68-e1874d902bd5	2026-09-09 14:53	2026-09-09 14:52	2026-09-09 14:52	LRCX	LRCX270617C00460000	call	460.0000	2027-06-17	32.5500	32.5500	34.7000	314.9000	84630.00	0.00	84630.00	26	14	30	394	0.0761421319796954	0.628695380719947	0.628695380719947	false	false	false	true
192ac078-1752-4281-a485-b466645a9408	2026-09-09 13:22	2026-09-09 13:22	2026-09-09 13:22	LRCX	LRCX261218C00410000	call	410.0000	2026-12-18	15.5500	15.5500	15.8500	316.0700	107295.00	0.00	107295.00	69	15	71	411	0.172749391727494	0.636040303770823	0.636040303770823	false	false	false	true
aa1f9514-a0d2-4152-acbb-e7505d62e3fc	2026-09-09 12:46	2026-09-09 12:45	2026-09-09 12:45	LRCX	LRCX261016C00320000	call	320.0000	2026-10-16	22.5500	22.5500	23.5500	315.0000	115005.00	0.00	115005.00	51	6	84	511	0.164383561643836	0.600561255837161	0.600561255837161	false	false	false	true
81d2e7f9-a925-4798-a57e-9df09779a4df	2026-09-09 12:45	2026-09-09 12:45	2026-09-09 12:45	LRCX	LRCX261218C00380000	call	380.0000	2026-12-18	21.5400	21.4500	21.6000	315.0000	118485.00	73440.00	45045.00	55	9	57	519	0.109826589595376	0.633422057390261	0.633422057390261	false	false	false	true
bf3089ed-d2bc-4ad0-a15d-d1a4e213de19	2026-09-09 11:35	2026-09-09 11:35	2026-09-09 11:35	LRCX	LRCX270319C00370000	call	370.0000	2027-03-19	40.5500	38.7500	40.5500	314.5101	478489.00	478489.00	0.00	118	35	122	84	1.45238095238095	0.635692148899968	0.635692148899968	false	false	false	true
63c6ce3d-0274-4453-a871-5c2c554dfec3	2026-09-09 10:56	2026-09-09 10:56	2026-09-09 10:56	LRCX	LRCX270115P00290000	put	290.0000	2027-01-15	30.6500	30.6500	31.3500	316.5900	104210.00	0.00	104210.00	34	19	34	1511	0.0225016545334216	0.626367619375321	0.626367619375321	false	false	false	true
f73b6572-d9bb-4e14-81aa-2f06ad081e89	2026-09-09 10:21	2026-09-09 10:21	2026-09-09 10:21	LRCX	LRCX261016C00360000	call	360.0000	2026-10-16	10.3500	10.3500	10.7500	317.0450	71417.00	0.00	71417.00	69	33	75	742	0.101078167115903	0.607889902947329	0.607889902947329	false	false	false	true
ad4cfbf3-dc91-4d82-ae22-d45a450cdec2	2026-09-09 09:34	2026-09-09 09:34	2026-09-09 09:34	LRCX	LRCX261016P00340000	put	340.0000	2026-10-16	36.7100	35.8500	38.0500	318.8950	91785.00	3705.00	88080.00	25	7	25	142	0.176056338028169	0.614581575044733	0.614581575044733	true	false	false	true
6465ef97-ecb2-45ca-9d5d-3210b13630b8	2026-09-09 09:33	2026-09-09 09:33	2026-09-09 09:33	LRCX	LRCX261218C00400000	call	400.0000	2026-12-18	19.0000	18.2000	21.4000	319.4958	89305.00	7600.00	81705.00	47	19	47	762	0.0616797900262467	0.644467507503395	0.644467507503395	false	false	false	true
44a6d056-6ea0-4f29-9585-670a1493da06	2026-09-09 09:33	2026-09-09 09:33	2026-09-09 09:33	LRCX	LRCX270319C00400000	call	400.0000	2027-03-19	33.7500	33.5000	33.7500	319.1250	270000.00	202500.00	0.00	80	18	462	747	0.618473895582329	0.626317143701326	0.626317143701326	false	false	false	true
471f3774-e14b-4b9e-8d36-0fa42560492b	2026-09-09 09:32	2026-09-09 09:32	2026-09-09 09:32	LRCX	LRCX270319C00400000	call	400.0000	2027-03-19	34.5000	33.7500	34.5000	319.0801	203550.00	203550.00	0.00	59	17	248	747	0.331994645247657	0.634866587696683	0.634866587696683	false	false	false	true
f6959c49-4b51-49a2-890f-415b73fb81f3	2026-09-09 09:32	2026-09-09 09:32	2026-09-09 09:32	LRCX	LRCX270319C00400000	call	400.0000	2027-03-19	34.7500	33.6000	34.7500	319.5500	156375.00	20850.00	0.00	45	17	45	747	0.0602409638554217	0.635474252711747	0.635474252711747	false	false	false	true
98196fd5-0c73-4df1-adc6-c194d42a8984	2026-09-08 15:00	2026-09-08 15:00	2026-09-08 15:00	LRCX	LRCX261016P00300000	put	300.0000	2026-10-16	14.9500	14.5000	14.9500	320.8600	104650.00	104650.00	0.00	70	8	185	1175	0.157446808510638	0.612892569462106	0.612892569462106	true	false	false	true
eb2002e7-de89-42b4-b046-ce280924a8b9	2026-09-08 14:29	2026-09-08 14:29	2026-09-08 14:29	LRCX	LRCX261120C00330000	call	330.0000	2026-11-20	33.8000	33.8000	34.5500	319.8900	74360.00	0.00	74360.00	22	6	49	757	0.0647291941875826	0.651835637078536	0.651835637078536	false	false	false	true
231ddad4-e8c0-4e20-99e7-821232747d94	2026-09-08 14:22	2026-09-08 14:22	2026-09-08 14:22	LRCX	LRCX280121C00580000	call	580.0000	2028-01-21	39.1500	37.0000	39.7000	319.8000	90045.00	86130.00	3915.00	23	16	25	73	0.342465753424658	0.620224769173749	0.620224769173749	true	false	false	true
125810c7-e384-4ba3-8534-e45c68548eab	2026-09-08 12:53	2026-09-08 12:52	2026-09-08 12:52	LRCX	LRCX270115P00320000	put	320.0000	2027-01-15	45.8500	45.5000	46.3000	318.6850	586880.00	371385.00	215495.00	128	8	435	555	0.783783783783784	0.634132418565197	0.634132418565197	false	false	false	true
557e0434-76a8-440f-a3c9-f77e3fe8ef06	2026-09-08 12:17	2026-09-08 12:17	2026-09-08 12:17	LRCX	LRCX261002C00315000	call	315.0000	2026-10-02	22.5500	22.5500	23.4500	319.4400	133045.00	0.00	133045.00	59	12	62	69	0.898550724637681	0.61138999727221	0.612460011436656	true	false	false	true
b6739aa9-0b12-4dbb-8163-d9fd9e1deeeb	2026-09-08 12:10	2026-09-08 12:10	2026-09-08 12:10	LRCX	LRCX261016C00360000	call	360.0000	2026-10-16	12.6000	12.6000	12.9000	320.4400	76880.00	5060.00	71820.00	61	9	198	592	0.334459459459459	0.632937353929071	0.632937353929071	false	false	false	true
b962f6f9-696b-4b03-892e-b87bf1fb1886	2026-09-08 12:02	2026-09-08 12:02	2026-09-08 12:02	LRCX	LRCX270115P00330000	put	330.0000	2027-01-15	50.8000	50.2000	50.9750	320.3750	50800.00	50800.00	0.00	10	7	40	907	0.0441014332965821	0.63382920209906	0.63382920209906	false	false	false	true
08b96065-53e4-4a67-9979-7f3eb7dbf4fe	2026-09-08 12:01	2026-09-08 12:01	2026-09-08 12:01	LRCX	LRCX270115P00320000	put	320.0000	2027-01-15	45.2000	44.7000	45.2000	320.1625	58760.00	58760.00	0.00	13	9	275	555	0.495495495495495	0.633585450995191	0.633585450995191	false	false	false	true
8902c57d-a175-4d20-ac4e-9c18d1ccaa2d	2026-09-08 11:51	2026-09-08 11:50	2026-09-08 11:50	LRCX	LRCX270319C00350000	call	350.0000	2027-03-19	49.5500	48.6000	49.8000	320.4700	69370.00	24775.00	44595.00	14	8	46	180	0.255555555555556	0.630344410544957	0.630344410544957	true	false	false	true
1e9119a1-74b5-49ed-8fad-6b88c46a3e20	2026-09-08 11:51	2026-09-08 11:50	2026-09-08 11:50	LRCX	LRCX270319C00350000	call	350.0000	2027-03-19	49.5500	48.7000	49.7000	320.4700	148650.00	14865.00	133785.00	30	5	77	180	0.427777777777778	0.630344410544957	0.630344410544957	false	false	false	true
486d5aa1-1eb5-4b38-a124-adaeb13ca7e2	2026-09-08 11:01	2026-09-08 11:01	2026-09-08 11:01	LRCX	LRCX261016C00360000	call	360.0000	2026-10-16	11.7000	11.2500	12.8000	318.9900	77244.00	9384.00	17550.00	66	7	131	592	0.221283783783784	0.620737072272239	0.621966920293392	false	false	false	true
899fac89-9ceb-4957-9a57-a9ad6596f7bd	2026-09-08 10:56	2026-09-08 10:56	2026-09-08 10:56	LRCX	LRCX270917C00380000	call	380.0000	2027-09-17	62.3700	59.5000	62.4000	319.5300	118505.00	118505.00	0.00	19	6	19	5	3.8	0.608390322325712	0.604107689536221	false	false	false	true
408e41dc-7f8f-48d5-b286-ddcb7fc5804e	2026-09-04 15:16	2026-09-04 15:16	2026-09-04 15:16	LRCX	LRCX260904C00290000	call	290.0000	2026-09-04	13.0000	13.0000	14.6500	303.0500	130000.00	0.00	130000.00	100	5	178	623	0.285714285714286	5.58375566412913	5.58375566412913	false	false	false	true
d29cdcf1-ce75-4a93-acb8-40b86326745a	2026-09-04 15:09	2026-09-04 15:09	2026-09-04 15:09	LRCX	LRCX261016C00300000	call	300.0000	2026-10-16	26.3500	25.8000	26.3500	303.6100	142290.00	142290.00	0.00	54	5	297	354	0.838983050847458	0.58530520189152	0.5847388701426	true	false	false	true
406959ed-209e-4a45-b9fe-ab59a9e6ba1d	2026-09-04 14:36	2026-09-04 14:36	2026-09-04 14:36	LRCX	LRCX270319C00390000	call	390.0000	2027-03-19	29.6500	29.4000	30.2000	303.7700	53370.00	0.00	53370.00	18	7	26	129	0.201550387596899	0.614429970198742	0.614429970198742	false	false	false	true
c0f9f429-1bb4-425e-a168-d3db5ba77569	2026-09-04 13:57	2026-09-04 13:56	2026-09-04 13:56	LRCX	LRCX270319P00330000	put	330.0000	2027-03-19	66.1800	66.0500	67.0000	303.2900	138985.00	72875.00	66110.00	21	7	28	111	0.252252252252252	0.615717098956233	0.616849299655429	false	false	false	true
12d99cfa-a1fb-4881-9d99-21f296f6f8db	2026-09-04 13:56	2026-09-04 13:56	2026-09-04 13:56	LRCX	LRCX270115C00350000	call	350.0000	2027-01-15	30.0000	28.1500	30.0000	303.4350	186000.00	186000.00	0.00	62	27	213	1112	0.191546762589928	0.618454770030099	0.618454770030099	false	false	false	true
583ddad1-4e5a-4d22-931d-6ae8d5997f85	2026-09-04 12:47	2026-09-04 12:47	2026-09-04 12:47	LRCX	LRCX261016C00340000	call	340.0000	2026-10-16	12.2900	11.9000	12.5000	305.4150	93395.00	89745.00	3650.00	76	13	206	791	0.260429835651075	0.585263862656934	0.589221639916031	true	false	false	true
b730c04f-1819-46af-93c2-043ae67f3076	2026-09-04 12:46	2026-09-04 12:46	2026-09-04 12:46	LRCX	LRCX261023C00315000	call	315.0000	2026-10-23	24.5000	24.1000	24.6000	305.1300	149437.00	149437.00	0.00	61	16	138	1	138	0.630198549809651	0.630198549809651	true	false	false	true
606d7d46-7372-4df0-8747-b99dab95c152	2026-09-04 12:46	2026-09-04 12:46	2026-09-04 12:46	LRCX	LRCX261016C00300000	call	300.0000	2026-10-16	26.8000	26.7500	28.1000	305.0200	147415.00	72360.00	75055.00	55	5	218	354	0.615819209039548	0.575748023390594	0.579459580330374	false	false	false	true
03f6160e-63af-497f-9407-188afc359c74	2026-09-04 12:46	2026-09-04 12:46	2026-09-04 12:46	LRCX	LRCX261016C00320000	call	320.0000	2026-10-16	18.2500	18.1500	19.1500	305.0200	162390.00	102480.00	59910.00	89	6	118	420	0.280952380952381	0.58115404315217	0.58115404315217	false	false	false	true
ee80107c-bfe6-4ca2-9895-89ae4e401f26	2026-09-04 12:46	2026-09-04 12:46	2026-09-04 12:46	LRCX	LRCX260911C00307500	call	307.5000	2026-09-11	7.5500	7.4500	7.7000	304.9100	53605.00	47565.00	6040.00	71	26	146	40	3.65	0.513445826827736	0.513445826827736	true	false	false	true
05e7e0da-44ab-4306-b09a-d2f3c319391d	2026-09-04 11:23	2026-09-04 11:23	2026-09-04 11:23	LRCX	LRCX270115C00320000	call	320.0000	2027-01-15	37.4700	36.5000	37.8500	302.2750	56200.00	7490.00	48710.00	15	11	15	1732	0.00866050808314088	0.59166558941513	0.594349736739941	true	false	false	true
6ad4d1a6-4b8a-436c-8289-48e00c6b3c2d	2026-09-04 11:06	2026-09-04 11:06	2026-09-04 11:06	LRCX	LRCX261016C00330000	call	330.0000	2026-10-16	13.3600	12.9500	13.8000	302.0550	66792.00	66792.00	0.00	50	5	99	1100	0.09	0.582994153287295	0.570588444668348	false	false	false	true
8d9a4bc6-7b56-4405-96f0-eae3b695bb10	2026-09-04 09:44	2026-09-04 09:43	2026-09-04 09:43	LRCX	LRCX260918C00330000	call	330.0000	2026-09-18	4.9000	4.9000	5.0500	304.9900	74970.00	0.00	74970.00	153	17	426	3382	0.125960969840331	0.558975552043109	0.558975552043109	false	false	false	true
177b7bfe-ea7e-44ab-a045-d6e5b69115a8	2026-09-04 09:44	2026-09-04 09:43	2026-09-04 09:43	LRCX	LRCX260918C00330000	call	330.0000	2026-09-18	4.9000	4.5000	5.2000	304.9900	112690.00	40180.00	68590.00	230	29	273	3382	0.0807214665878179	0.558975552043109	0.558975552043109	false	false	false	true
2559872c-0066-4bc6-8665-c9db369bdea9	2026-09-04 09:40	2026-09-04 09:40	2026-09-04 09:40	LRCX	LRCX261016C00350000	call	350.0000	2026-10-16	8.6500	8.6500	8.8500	303.1600	101214.00	0.00	101214.00	117	16	187	1170	0.15982905982906	0.56974443333723	0.56974443333723	false	false	false	true
c9afdf76-3b66-490c-a757-6d573868ba77	2026-09-04 09:36	2026-09-04 09:36	2026-09-04 09:36	LRCX	LRCX261120C00460000	call	460.0000	2026-11-20	3.6000	3.6000	4.6500	301.8500	51480.00	0.00	51480.00	143	7	187	1157	0.161624891961971	0.626824120129516	0.626824120129516	false	false	false	true
bd565db9-0ef5-47da-8013-61c8046e3175	2026-09-03 14:04	2026-09-03 14:04	2026-09-03 14:04	LRCX	LRCX261120C00300000	call	300.0000	2026-11-20	27.7000	27.4000	27.7500	288.4900	243755.00	113565.00	130190.00	88	7	917	351	2.61253561253561	0.595221355436251	0.595221355436251	false	false	false	true
8c66cd22-845e-4cc4-bb00-e33aa425571a	2026-09-03 14:04	2026-09-03 14:04	2026-09-03 14:04	LRCX	LRCX261120C00300000	call	300.0000	2026-11-20	27.6500	27.1000	27.7000	288.4900	141020.00	80195.00	60825.00	51	16	707	351	2.01424501424501	0.594281301650185	0.595221355436251	true	false	false	true
7fff9c01-4a0c-4297-8ee7-df791089f070	2026-09-03 14:04	2026-09-03 14:04	2026-09-03 14:04	LRCX	LRCX261120C00300000	call	300.0000	2026-11-20	27.7000	27.7000	27.7500	288.4900	124650.00	0.00	124650.00	45	7	787	351	2.24216524216524	0.595221355436251	0.595221355436251	false	false	false	true
fb132673-cab1-4ab8-93f8-03fc140935fc	2026-09-03 14:04	2026-09-03 14:04	2026-09-03 14:04	LRCX	LRCX261120C00300000	call	300.0000	2026-11-20	27.4000	26.4500	27.6000	288.2500	84940.00	5480.00	79460.00	31	6	111	351	0.316239316239316	0.591875356956432	0.591875356956432	false	false	false	true
8dc1f77e-a4e2-40a1-8ef0-c7149f08df28	2026-09-03 14:04	2026-09-03 14:04	2026-09-03 14:04	LRCX	LRCX261120C00300000	call	300.0000	2026-11-20	27.4500	27.1000	27.5000	288.2750	194895.00	35685.00	87840.00	71	7	353	351	1.00569800569801	0.592577142677975	0.592577142677975	true	false	false	true