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 = LNG×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	expiry

a1deadfd-30c8-4d8b-9f62-884354a67361	2026-08-18 10:32	2026-08-18 10:32	2026-08-18 10:32	LNG	LNG260918P00270000	put	270.0000	2026-09-18	6.9000	6.9000	7.3000	274.4400	75900.00	0.00	75900.00	110	19	112	594	0.188552188552189	0.294958575682624	0.294958575682624	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Energy	56648188856.00	2026-10-29	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-18T14:49:07.673043Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
342cbc5f-95ff-41ad-a7b6-5f65aeed9d73	2026-08-20 15:51	2026-08-20 15:51	2026-08-20 15:51	LNG	LNG260904C00280000	call	280.0000	2026-09-04	7.3600	5.5000	7.8000	279.6900	147100.00	147100.00	0.00	200	8	200	29	6.89655172413793	0.319675666692808	0.319675666692808	false	false	false
97aae8a1-8d26-4ab2-a4a3-9a37ea03498e	2026-08-25 11:56	2026-08-25 11:56	2026-08-25 11:56	LNG	LNG261016P00300000	put	300.0000	2026-10-16	25.3000	25.3000	26.4000	279.2450	58190.00	0.00	58190.00	23	10	45	0	0	0.31421439297828	0.31421439297828	true	false	false	true
aef124c6-2b5f-4ce1-b777-6d163f898192	2026-08-25 11:57	2026-08-25 11:57	2026-08-25 11:57	LNG	LNG261016P00300000	put	300.0000	2026-10-16	25.1000	24.3000	26.2000	279.6600	50200.00	0.00	50200.00	20	5	86	0	0	0.316510623377169	0.316510623377169	true	false	false	true
184f75d4-9598-47ec-8adf-40e1cd11d0cb	2026-08-25 12:07	2026-08-25 12:07	2026-08-25 12:07	LNG	LNG270319C00280000	call	280.0000	2027-03-19	29.2000	28.4000	30.1000	279.1100	58400.00	8760.00	49640.00	20	6	41	242	0.169421487603306	0.319471473844623	0.319471473844623	false	false	false
c43bfac0-f07f-479a-ae2c-e6d26e101435	2026-08-26 12:42	2026-08-26 12:42	2026-08-26 12:42	LNG	LNG270115C00330000	call	330.0000	2027-01-15	8.8000	8.0000	8.8000	283.1600	52800.00	52800.00	0.00	60	9	101	118	0.855932203389831	0.320437995309916	0.320437995309916	false	false	false
e666e617-b63f-4310-8bed-e070ff0d5dc8	2026-08-28 15:11	2026-08-28 15:11	2026-08-28 15:11	LNG	LNG260904P00282500	put	282.5000	2026-09-04	5.6000	3.6000	5.9000	282.4200	272720.00	51520.00	221200.00	487	8	532	36	14.7777777777778	0.358988014919167	0.363059090965862	false	false	false
c534830e-ef57-4775-9541-732952a2a1cf	2026-08-28 15:11	2026-08-28 15:11	2026-08-28 15:11	LNG	LNG260904C00282500	call	282.5000	2026-09-04	5.6500	5.4000	5.9000	282.2900	101120.00	20520.00	80600.00	179	19	239	16	14.9375	0.365636519161193	0.365636519161193	true	false	false
d2dfbea3-7d20-4d7d-bdeb-757c39e03538	2026-08-31 09:37	2026-08-31 09:37	2026-08-31 09:37	LNG	LNG260911C00290000	call	290.0000	2026-09-11	6.0000	5.9000	6.6000	288.1500	52820.00	8680.00	39180.00	88	17	89	183	0.486338797814208	0.346451272849626	0.346451272849626	false	false	false
a58ba134-e1bc-4e3d-8f29-1898b22293ab	2026-08-31 11:41	2026-08-31 11:41	2026-08-31 11:41	LNG	LNG260904C00292500	call	292.5000	2026-09-04	3.3000	3.3000	3.6000	287.7700	82500.00	0.00	82500.00	250	6	300	18	16.6666666666667	0.436487257039046	0.436487257039046	false	false	false
c0a7382d-9135-4c47-bb7f-61e8a445c535	2026-09-01 09:57	2026-09-01 09:56	2026-09-01 09:56	LNG	LNG260911C00300000	call	300.0000	2026-09-11	4.7000	4.7000	5.2000	293.2150	253330.00	0.00	253330.00	539	7	553	79	7	0.383033553467906	0.383033553467906	false	false	false
1ae4900a-3e2a-4e41-894f-92cd560775d0	2026-09-01 09:57	2026-09-01 09:56	2026-09-01 09:56	LNG	LNG260904P00300000	put	300.0000	2026-09-04	9.7000	9.7000	11.0000	293.2150	154230.00	0.00	154230.00	159	6	159	13	12.2307692307692	0.53566247289825	0.53566247289825	false	false	false
64b1d333-14e9-4b54-8186-038faa17de6d	2026-09-01 11:33	2026-09-01 11:33	2026-09-01 11:33	LNG	LNG261016C00290000	call	290.0000	2026-10-16	12.9000	12.1000	12.9000	288.5150	121260.00	121260.00	0.00	94	7	95	570	0.166666666666667	0.321225025845854	0.321225025845854	false	false	false
b22957e4-897c-4370-a4c9-b5c13c65091c	2026-09-01 12:22	2026-09-01 12:22	2026-09-01 12:22	LNG	LNG260918C00290000	call	290.0000	2026-09-18	8.6000	8.0000	8.6000	289.4600	172860.00	172860.00	0.00	201	12	215	3819	0.0562974600680807	0.351909243317431	0.345743293167155	false	false	false
814da7f5-bbc9-4d38-a218-d69a21163fbb	2026-09-02 10:50	2026-09-02 10:49	2026-09-02 10:49	LNG	LNG260911C00295000	call	295.0000	2026-09-11	6.6000	6.6000	7.1000	292.3600	99000.00	0.00	91080.00	150	17	174	34	5.11764705882353	0.42004808874399	0.42004808874399	false	false	false
da1046bd-31ce-4f0b-8a45-94c3c6c2c581	2026-09-02 10:53	2026-09-02 10:53	2026-09-02 10:53	LNG	LNG260911C00295000	call	295.0000	2026-09-11	7.0000	7.0000	7.3000	292.6400	57400.00	0.00	57400.00	82	10	324	34	9.52941176470588	0.434765762931806	0.434765762931806	false	false	false
c14a743c-cc23-4f2b-96ac-dbb3dc6d6980	2026-09-02 10:58	2026-09-02 10:58	2026-09-02 10:58	LNG	LNG260911C00295000	call	295.0000	2026-09-11	7.0000	7.0000	8.2000	292.4000	98700.00	0.00	90300.00	141	18	641	34	18.8529411764706	0.440942055150684	0.440942055150684	false	false	false
18aa429b-591d-4483-ad63-2e113f2bb264	2026-09-02 11:03	2026-09-02 11:03	2026-09-02 11:03	LNG	LNG260918C00295000	call	295.0000	2026-09-18	8.5000	8.3000	8.9000	292.4000	126609.00	38249.00	88360.00	149	22	180	714	0.252100840336134	0.388275414988221	0.388275414988221	false	false	false
addcc954-80ea-4176-8463-4d0f79898ae7	2026-09-02 11:09	2026-09-02 11:09	2026-09-02 11:09	LNG	LNG260911C00295000	call	295.0000	2026-09-11	7.9000	7.9000	8.8000	293.5100	56880.00	0.00	52930.00	72	11	986	34	29	0.460965756268501	0.460965756268501	false	false	false
1b41e340-01b7-4fda-9b7c-a61367001efb	2026-09-02 11:16	2026-09-02 11:16	2026-09-02 11:16	LNG	LNG260904C00302500	call	302.5000	2026-09-04	3.1000	2.3500	3.4000	293.3800	154070.00	22010.00	132060.00	497	7	527	27	19.5185185185185	0.758699987417314	0.758699987417314	false	false	false
a4c115c3-6d9b-4e03-9876-df56012d0c86	2026-09-02 12:45	2026-09-02 12:45	2026-09-02 12:45	LNG	LNG260904C00300000	call	300.0000	2026-09-04	4.3000	4.3000	4.4000	294.6300	855270.00	0.00	855270.00	1989	7	2364	474	4.9873417721519	0.75390649861281	0.75390649861281	false	false	false
da221f62-7833-40ef-9c3e-96f6771ef306	2026-09-02 13:58	2026-09-02 13:57	2026-09-02 13:57	LNG	LNG261016P00290000	put	290.0000	2026-10-16	10.8000	9.9000	10.8000	294.7800	118800.00	118800.00	0.00	110	16	123	9	13.6666666666667	0.338013951338553	0.338013951338553	false	false	false
af59d09d-831c-4b6a-bb38-1e9b3b47b96a	2026-09-02 14:43	2026-09-02 14:42	2026-09-02 14:42	LNG	LNG261016P00300000	put	300.0000	2026-10-16	15.3000	14.8000	15.3000	295.9350	136170.00	136170.00	0.00	89	11	97	508	0.190944881889764	0.338478927771585	0.338478927771585	false	false	false
e9fa91ed-f631-449f-b971-4446c932df57	2026-09-02 14:59	2026-09-02 14:59	2026-09-02 14:59	LNG	LNG260918C00310000	call	310.0000	2026-09-18	5.3000	4.4000	5.4000	297.5200	203450.00	3110.00	200340.00	384	19	470	262	1.79389312977099	0.401424738489821	0.406191432271902	true	false	false
bc0f79c6-e7b2-49fe-8204-87717e789137	2026-09-03 11:29	2026-09-03 11:29	2026-09-03 11:29	LNG	LNG270115C00290000	call	290.0000	2027-01-15	28.0000	28.0000	29.0000	294.6600	70000.00	0.00	64400.00	25	10	25	1232	0.0202922077922078	0.332537695340401	0.332537695340401	false	false	false
1a4ac5f9-9763-4b5f-882c-9bc65fa4ff0c	2026-09-03 11:39	2026-09-03 11:39	2026-09-03 11:39	LNG	LNG270617C00370000	call	370.0000	2027-06-17	14.5000	14.5000	14.5000	294.0500	72500.00	0.00	0.00	50	6	50	6	8.33333333333333	0.33435012164933	0.33435012164933	false	false	false
ac02e752-4f8a-4a4d-a88c-f294e127b890	2026-09-03 11:45	2026-09-03 11:45	2026-09-03 11:45	LNG	LNG261016P00260000	put	260.0000	2026-10-16	2.5900	2.0500	2.7500	293.3800	206311.00	206311.00	0.00	798	16	800	33	24.2424242424242	0.352188036130334	0.352188036130334	true	false	false
390c4029-b23b-4141-a0f4-c3d554b9add6	2026-09-04 09:53	2026-09-04 09:53	2026-09-04 09:53	LNG	LNG260918C00300000	call	300.0000	2026-09-18	5.3800	4.3000	5.6000	288.0800	107528.00	107528.00	0.00	200	20	242	5042	0.0479968266560889	0.425551021659181	0.450707136716605	false	false	false
bc78e2a0-5395-4c61-8675-16a5d62d8780	2026-09-04 10:37	2026-09-04 10:37	2026-09-04 10:37	LNG	LNG260925C00290000	call	290.0000	2026-09-25	10.4000	9.5000	11.7000	289.0000	206960.00	204880.00	2080.00	199	19	209	30	6.96666666666667	0.382462720584358	0.382462720584358	true	false	false
73b43ac7-979f-4060-afae-b8d0efc96be9	2026-09-04 10:45	2026-09-04 10:45	2026-09-04 10:45	LNG	LNG260918C00300000	call	300.0000	2026-09-18	5.5600	5.5000	5.7000	289.1400	106780.00	60480.00	46300.00	192	9	1418	5042	0.281237604125347	0.433005744811598	0.433005744811598	true	false	false
c3dbf4c2-ff93-4bdc-b2b0-82638cb128c4	2026-09-04 11:44	2026-09-04 11:44	2026-09-04 11:44	LNG	LNG260904C00290000	call	290.0000	2026-09-04	6.3700	6.3000	6.8000	289.8900	149160.00	6400.00	142760.00	234	17	402	673	0.597325408618128	2.53162477572508	2.53162477572508	true	false	false
bda5434a-c2b1-4c99-a777-0fd4da671469	2026-09-04 14:05	2026-09-04 14:05	2026-09-04 14:05	LNG	LNG261016C00300000	call	300.0000	2026-10-16	9.9000	9.6000	10.4000	289.3500	61380.00	2970.00	58410.00	62	6	67	535	0.125233644859813	0.35374563063638	0.35374563063638	false	false	false
d20d4033-3406-4b98-b022-8fed02ece926	2026-09-04 14:11	2026-09-04 14:11	2026-09-04 14:11	LNG	LNG260918C00300000	call	300.0000	2026-09-18	5.9000	5.9000	6.3000	289.6450	211220.00	0.00	211220.00	358	11	2098	5042	0.416104720349068	0.438617908704972	0.438617908704972	true	false	false
463b9539-fec5-4ba6-bd43-a526051936c8	2026-09-04 15:28	2026-09-04 15:28	2026-09-04 15:28	LNG	LNG261016C00320000	call	320.0000	2026-10-16	4.9000	4.8000	5.3000	290.8700	120540.00	490.00	120050.00	246	31	437	444	0.984234234234234	0.359514367314835	0.359514367314835	false	false	false
2af4ca7c-db5d-4df5-9780-d10f2a05de3e	2026-09-04 15:51	2026-09-04 15:51	2026-09-04 15:51	LNG	LNG260904C00300000	call	300.0000	2026-09-04	3.4000	3.3000	3.7000	291.7350	116620.00	5100.00	111520.00	343	9	650	2874	0.226165622825331	14.304662854126	14.304662854126	false	false	false
5797b191-5274-46f3-b421-87302d2288eb	2026-09-08 09:30	2026-09-08 09:30	2026-09-08 09:30	LNG	LNG260918C00295000	call	295.0000	2026-09-18	1.4000	1.2500	1.4000	277.5900	67850.00	16800.00	650.00	485	10	485	983	0.493387589013225	0.359106967869728	0.350207705551228	false	false	false
8cf02de2-d80f-475f-874a-f4939eb85678	2026-09-08 09:31	2026-09-08 09:31	2026-09-08 09:31	LNG	LNG260911P00270000	put	270.0000	2026-09-11	2.1000	0.5500	2.1000	275.8900	72240.00	72240.00	0.00	344	9	346	42	8.23809523809524	0.452490519399475	0.452490519399475	true	false	false
cd2ed2f0-99a7-4525-b91c-378aba7a32fa	2026-09-09 15:41	2026-09-09 15:41	2026-09-09 15:41	LNG	LNG261016C00300000	call	300.0000	2026-10-16	3.5700	3.4000	3.9000	276.2000	326450.00	4900.00	321550.00	914	43	1449	590	2.45593220338983	0.31371248932568	0.315167470157918	false	false	false
28acf0e6-18fe-43eb-905f-a3dc8b8f3211	2026-09-11 12:38	2026-09-11 12:38	2026-09-11 12:38	LNG	LNG270115P00270000	put	270.0000	2027-01-15	15.4000	15.4000	15.7000	277.1700	90860.00	0.00	90860.00	59	10	73	618	0.118122977346278	0.320900077609561	0.320900077609561	false	false	false
ce206a04-3d42-453d-8a78-e5aec5d9c78d	2026-09-16 12:49	2026-09-16 12:49	2026-09-16 12:49	LNG	LNG280121P00250000	put	250.0000	2028-01-21	25.2000	25.2000	27.2000	270.9700	63000.00	0.00	37800.00	25	10	25	224	0.111607142857143	0.35118437441196	0.35118437441196	true	false	false
02f753ff-567b-4593-ade2-6709e32f500d	2026-09-17 09:59	2026-09-17 09:59	2026-09-17 09:59	LNG	LNG261218P00270000	put	270.0000	2026-12-18	17.1300	17.0000	19.0000	267.5650	250150.00	27840.00	222310.00	146	10	151	170	0.888235294117647	0.321876235361006	0.329371708135737	true	false	false
308a2031-38f7-4782-bdb5-a313c4d8c83c	2026-09-17 13:01	2026-09-17 13:01	2026-09-17 13:01	LNG	LNG270115C00280000	call	280.0000	2027-01-15	17.0000	17.0000	17.7000	270.2500	151300.00	0.00	151300.00	89	18	93	2608	0.035659509202454	0.320753012802131	0.320753012802131	false	false	false
2d0c8d8e-0149-4f26-86a6-7e3e4910f967	2026-09-21 10:28	2026-09-21 10:27	2026-09-21 10:27	LNG	LNG261002C00280000	call	280.0000	2026-10-02	3.4000	2.9500	3.4000	271.9000	11220.00	11220.00	0.00	33	8	247	205	1.20487804878049	0.343793888037977	0.343793888037977	false	false	false
9fe0c27a-359b-477a-ac0e-e07149445391	2026-09-21 10:42	2026-09-21 10:42	2026-09-21 10:42	LNG	LNG270617C00300000	call	300.0000	2027-06-17	22.3000	21.0000	22.7000	271.0950	13380.00	2230.00	11150.00	6	6	6	745	0.00805369127516779	0.323534547948534	0.323361309454464	false	false	false
cea29f64-b65d-4a75-9880-580c9739c7fb	2026-09-21 11:47	2026-09-21 11:47	2026-09-21 11:47	LNG	LNG261120C00300000	call	300.0000	2026-11-20	5.3000	5.2000	5.3000	271.0950	13780.00	1060.00	0.00	26	18	37	241	0.153526970954357	0.328210696575556	0.328210696575556	false	false	false
229fdb3d-f4cc-4ab4-b3f9-7103a64cbf6a	2026-09-21 12:16	2026-09-21 12:16	2026-09-21 12:16	LNG	LNG261002C00280000	call	280.0000	2026-10-02	3.7000	3.1000	3.7000	271.7150	16280.00	16280.00	0.00	44	14	396	205	1.93170731707317	0.364884136733048	0.364884136733048	true	false	false
ea8a041a-a5ca-4feb-901b-7f0f1e90cbaa	2026-09-21 12:22	2026-09-21 12:22	2026-09-21 12:22	LNG	LNG260925P00272500	put	272.5000	2026-09-25	5.2000	4.5000	5.3000	271.5200	97240.00	5200.00	92040.00	187	5	196	33	5.93939393939394	0.418862274282075	0.418862274282075	false	false	false
80f82edb-b824-4512-a068-72bdfc825fa9	2026-09-21 12:36	2026-09-21 12:36	2026-09-21 12:36	LNG	LNG261002C00277500	call	277.5000	2026-10-02	5.3000	5.3000	5.6000	272.6600	127730.00	0.00	127730.00	241	5	500	1	500	0.385314599445135	0.385314599445135	false	false	false
527b870c-5061-473a-a586-42f24cf5355e	2026-09-21 13:19	2026-09-21 13:19	2026-09-21 13:19	LNG	LNG261016C00275000	call	275.0000	2026-10-16	10.5000	9.7000	10.5000	275.0000	157500.00	1050.00	0.00	150	12	186	0	0	0.346820147661638	0.346820147661638	false	false	false
c63feae3-4429-4d7a-a81a-fff8df08df63	2026-09-21 13:20	2026-09-21 13:20	2026-09-21 13:20	LNG	LNG261016C00275000	call	275.0000	2026-10-16	10.5000	10.5000	10.5000	275.0000	157500.00	0.00	0.00	150	9	336	0	0	0.347567681250824	0.347567681250824	false	false	false	true