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:ticker = BTU×

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

44cde8b2-95e5-4263-94f1-e0a25241b51c	2026-09-22 11:48	2026-09-22 11:48	2026-09-22 11:48	BTU	BTU260925P00025500	put	25.5000	2026-09-25	0.2700	0.2300	0.2700	26.3700	13014.00	13014.00	0.00	482	37	485	138	3.51449275362319	0.652070002391353	0.652070002391353	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Energy	3265701000.00	2026-10-29	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-22T15:49:01.734970Z"}	2026-09-22	2026-09-22 21:15	2026-09-22 21:15
423382f6-8259-4c31-9f55-92f21e5d8a12	2026-09-18 14:52	2026-09-18 14:52	2026-09-18 14:52	BTU	BTU261009P00023000	put	23.0000	2026-10-09	0.4000	0.3100	0.4000	25.1950	16879.00	16879.00	0.00	422	36	427	5	85.4	0.523712865927695	0.517952927492353	false	false	false	true	false
b1c2f50f-5849-4cb3-86c7-949e4f64d3e5	2026-09-17 11:11	2026-09-17 11:11	2026-09-17 11:11	BTU	BTU261009C00027500	call	27.5000	2026-10-09	1.5000	1.4900	1.6100	27.5200	30450.00	0.00	30450.00	203	18	203	1	203	0.541724525436532	0.541724525436532	false	false	false	true	false
d9cf7896-aa52-4cc3-8ecb-94437fcd60f9	2026-09-16 10:18	2026-09-16 10:18	2026-09-16 10:18	BTU	BTU260925P00028500	put	28.5000	2026-09-25	1.3300	1.1800	1.3300	27.0000	92967.00	92967.00	0.00	699	28	699	3	233	0.561810110981439	0.561810110981439	false	false	false	true	false
9b71f359-95de-4c9d-885d-82975cb35093	2026-09-16 09:55	2026-09-16 09:54	2026-09-16 09:54	BTU	BTU261120C00034000	call	34.0000	2026-11-20	0.8900	0.5300	0.8900	27.8300	31239.00	31239.00	0.00	351	5	351	120	2.925	0.57290218068904	0.57290218068904	false	false	false	true	false
17b74104-f2c1-4b0e-a1e0-48ab358c8f65	2026-09-15 11:55	2026-09-15 11:55	2026-09-15 11:55	BTU	BTU260925P00027000	put	27.0000	2026-09-25	1.0400	0.9800	1.1500	26.8200	14872.00	14768.00	104.00	143	24	198	727	0.272352132049519	0.541873529725098	0.541873529725098	false	false	false	true	false
fd88e087-f669-4cc6-b7de-3a1663a01cb1	2026-09-15 11:10	2026-09-15 11:10	2026-09-15 11:10	BTU	BTU260918P00026500	put	26.5000	2026-09-18	0.4600	0.3600	0.4600	26.7900	11316.00	11316.00	0.00	246	25	249	72	3.45833333333333	0.620150232589411	0.620150232589411	false	false	false	true	false
8899d631-5039-453f-aca7-e523b14edb98	2026-09-14 12:45	2026-09-14 12:45	2026-09-14 12:45	BTU	BTU260925C00026500	call	26.5000	2026-09-25	1.5400	1.4000	1.7400	27.3700	11396.00	11242.00	154.00	74	15	75	8	9.375	0.565925913340522	0.5511268098896	false	false	false	true	false
8556e88a-fcb4-4a5f-af16-6ebf8066f052	2026-09-08 13:12	2026-09-08 13:12	2026-09-08 13:12	BTU	BTU260918P00032000	put	32.0000	2026-09-18	2.7500	2.7500	3.0500	29.5400	29150.00	0.00	18150.00	106	8	113	1043	0.108341323106424	0.567879222250609	0.567879222250609	false	false	false	true	false
d7166ce0-a048-4f61-9fa1-04cb972bf26e	2026-09-04 15:49	2026-09-04 15:48	2026-09-04 15:48	BTU	BTU260911C00029500	call	29.5000	2026-09-11	0.4900	0.4600	0.5300	28.7550	44002.00	43512.00	490.00	898	14	1209	33	36.6363636363636	0.497563872712732	0.497563872712732	false	false	false	true	false
022e9b9e-b6e1-43af-8ae4-7037f9b5c341	2026-09-04 15:49	2026-09-04 15:48	2026-09-04 15:48	BTU	BTU260911C00029500	call	29.5000	2026-09-11	0.5000	0.4600	0.5700	28.8500	13917.00	3009.00	10908.00	277	8	1750	33	53.030303030303	0.489504044630956	0.480433941554639	false	false	false	true	false
24588842-48ba-4739-bed8-a9e690c4a19f	2026-09-04 12:16	2026-09-04 12:15	2026-09-04 12:15	BTU	BTU270115C00045000	call	45.0000	2027-01-15	0.7000	0.5300	0.7000	29.1100	35980.00	35980.00	0.00	514	16	557	1487	0.37457969065232	0.581384862103178	0.581384862103178	false	false	false	true	false
01448277-3b1c-402c-898a-d7f3fffb8ee7	2026-09-03 15:48	2026-09-03 15:48	2026-09-03 15:48	BTU	BTU270416C00025000	call	25.0000	2027-04-16	6.3000	6.3000	6.7500	27.6200	31500.00	0.00	15750.00	50	5	50	405	0.123456790123457	0.556236542688814	0.556236542688814	false	false	false	true	false
c858fb87-224a-4ff4-b08a-70caadf9064b	2026-09-02 11:07	2026-09-02 11:07	2026-09-02 11:07	BTU	BTU261120P00027000	put	27.0000	2026-11-20	1.7800	1.7800	1.8300	29.7000	11598.00	0.00	11598.00	65	14	112	97	1.15463917525773	0.579970241813655	0.580795539962249	false	false	false	true	false
b157c82c-14be-4bbe-85bc-0f8785da9712	2026-09-01 15:40	2026-09-01 15:39	2026-09-01 15:39	BTU	BTU261016P00027000	put	27.0000	2026-10-16	1.1100	1.0700	1.1100	29.0926	20424.00	20424.00	0.00	184	27	184	105	1.75238095238095	0.518429048282282	0.518429048282282	false	false	false	true	false
7465acfb-eaca-47bf-b208-2b0625da646b	2026-09-01 14:47	2026-09-01 14:47	2026-09-01 14:47	BTU	BTU270416C00025000	call	25.0000	2027-04-16	7.3500	7.3500	7.4000	29.0400	58800.00	0.00	44100.00	80	5	405	1	405	0.565467084826125	0.565467084826125	false	false	false	true	false
ec2ecce6-469e-4833-90b8-e3a3c5bf8d0b	2026-08-31 14:40	2026-08-31 14:40	2026-08-31 14:40	BTU	BTU280121C00032000	call	32.0000	2028-01-21	6.9000	6.1500	7.6500	29.5700	11040.00	2070.00	8970.00	16	5	16	89	0.179775280898876	0.518672648267481	0.518672648267481	false	false	false	true	false
fe06393b-3cd5-40df-bec7-798ea530556f	2026-08-31 10:07	2026-08-31 10:07	2026-08-31 10:07	BTU	BTU260918C00030000	call	30.0000	2026-09-18	1.3900	1.3600	1.4800	29.9600	12051.00	1524.00	554.00	87	38	219	1214	0.180395387149918	0.51718691247237	0.524736817080183	false	false	false	true	false
6d01e3a4-29c2-49d5-b6c0-b7c6c17a632c	2026-08-28 14:52	2026-08-28 14:52	2026-08-28 14:52	BTU	BTU261120P00026000	put	26.0000	2026-11-20	1.6200	1.4500	1.6200	28.9650	40240.00	34767.00	5473.00	249	20	279	14	19.9285714285714	0.562603026333096	0.558361288122057	true	false	false	true	false
152790c4-845c-419a-9c6d-0de17aecce86	2026-08-28 12:00	2026-08-28 12:00	2026-08-28 12:00	BTU	BTU261016C00030000	call	30.0000	2026-10-16	1.7900	1.7500	1.8200	28.0000	10907.00	2136.00	8771.00	61	7	173	1121	0.154326494201606	0.516108641971179	0.513739012660192	false	false	false	true	false
f37a774b-34c9-4543-a598-2c14a85a006d	2026-08-27 15:14	2026-08-27 15:14	2026-08-27 15:14	BTU	BTU260918C00030500	call	30.5000	2026-09-18	1.0200	0.8400	1.0500	29.0000	13971.00	13768.00	101.00	137	18	223	1	223	0.519818362848409	0.512369133753049	true	false	false	true	false
1a3b20e6-0cc5-46e6-9e4e-42bfa33e4e2e	2026-08-27 15:14	2026-08-27 15:14	2026-08-27 15:14	BTU	BTU261016C00030000	call	30.0000	2026-10-16	2.0100	1.9200	2.0300	29.0000	24864.00	12665.00	12199.00	124	5	154	1067	0.144329896907216	0.52109123741018	0.52109123741018	false	false	false	true	false
509c3c7e-2088-4faa-b11a-603089bc19f0	2026-08-27 15:14	2026-08-27 15:13	2026-08-27 15:13	BTU	BTU260918C00032000	call	32.0000	2026-09-18	0.5700	0.5100	0.5700	29.0000	11626.00	11626.00	0.00	204	17	333	526	0.633079847908745	0.512296977072928	0.514264445550671	true	false	false	true	false
3b4b6ac1-2ceb-4918-b964-5cfacf259280	2026-08-27 14:22	2026-08-27 14:22	2026-08-27 14:22	BTU	BTU260918C00028500	call	28.5000	2026-09-18	1.6400	1.6300	1.6400	28.9100	20008.00	20008.00	0.00	122	18	122	0	0	0.495099478294152	0.495099478294152	false	false	false	true	false
37bd388c-0e84-4874-bb3a-89304f4cf0d3	2026-08-27 14:22	2026-08-27 14:22	2026-08-27 14:22	BTU	BTU260918C00030000	call	30.0000	2026-09-18	0.9600	0.9600	1.1600	28.9000	32859.00	11834.00	21025.00	341	29	439	1290	0.34031007751938	0.494088348638207	0.495575704368085	true	false	false	true	false
bf83c4c7-765d-40c6-bd09-b0a83992c6af	2026-08-27 14:22	2026-08-27 14:22	2026-08-27 14:22	BTU	BTU260918C00028000	call	28.0000	2026-09-18	1.9100	1.9100	1.9200	28.9000	38829.00	10752.00	28077.00	203	8	221	567	0.389770723104056	0.495555281586837	0.49792583536891	false	false	false	true	false
3694e766-09c0-4cbb-ad94-9c4350ed84a5	2026-08-26 15:36	2026-08-26 15:36	2026-08-26 15:36	BTU	BTU261016C00030000	call	30.0000	2026-10-16	1.1200	0.9700	1.2500	27.3000	55982.00	31784.00	0.00	500	11	501	70	7.15714285714286	0.512529847531442	0.512529847531442	false	false	false	true	false
f851b846-3cd9-4fea-8e87-be177d5070fd	2026-08-25 11:40	2026-08-25 11:40	2026-08-25 11:40	BTU	BTU261120C00030000	call	30.0000	2026-11-20	2.0700	1.8200	2.1300	27.2400	41400.00	41400.00	0.00	200	5	206	110	1.87272727272727	0.569557625586739	0.569557625586739	false	false	false	true	false
b9fe3b38-1774-4978-aa54-22d406163177	2026-08-24 14:33	2026-08-24 14:33	2026-08-24 14:33	BTU	BTU260918C00025000	call	25.0000	2026-09-18	3.5000	3.4500	3.6000	28.0301	18900.00	0.00	18900.00	54	8	77	5242	0.0146890499809233	0.528720019616685	0.528720019616685	false	false	false	true	false
2293e1f0-5072-4750-a18a-b7bc4e6fbb25	2026-08-21 12:49	2026-08-21 12:49	2026-08-21 12:49	BTU	BTU260918C00025000	call	25.0000	2026-09-18	3.1500	3.1500	3.2500	27.5550	157500.00	0.00	157500.00	500	17	679	4886	0.138968481375358	0.51111197758008	0.51111197758008	false	false	false	true	false
e5c0655b-1202-4e61-928e-77d29efa4d04	2026-08-19 10:47	2026-08-19 10:47	2026-08-19 10:47	BTU	BTU260821C00023000	call	23.0000	2026-08-21	3.1000	3.1000	3.2500	26.1500	16430.00	0.00	16430.00	53	8	59	1349	0.0437361008154188	1.28583593769423	1.28583593769423	true	false	false	true	false
87133082-f2cf-4cac-b10b-1da25e222b33	2026-08-18 15:08	2026-08-18 15:08	2026-08-18 15:08	BTU	BTU270115C00027000	call	27.0000	2027-01-15	2.9800	2.9400	3.0500	25.2150	17582.00	13112.00	4470.00	59	5	173	525	0.329523809523809	0.548917852854581	0.548917852854581	false	false	false	true	false
562b5569-e8c4-4a8e-9100-87add9c47acd	2026-08-18 09:52	2026-08-18 09:52	2026-08-18 09:52	BTU	BTU260821C00026000	call	26.0000	2026-08-21	0.2100	0.1100	0.5000	25.1669	40762.00	31.00	40731.00	1930	9	1933	2125	0.909647058823529	0.691564979901074	0.691564979901074	false	false	false	true	false
4716d90e-f16f-4984-83e2-0840a1f4181e	2026-08-17 15:44	2026-08-17 15:44	2026-08-17 15:44	BTU	BTU260918C00026000	call	26.0000	2026-09-18	1.5400	1.5000	1.6000	25.8300	15400.00	10780.00	4620.00	100	5	123	586	0.209897610921502	0.517937378472227	0.517937378472227	false	false	false	true	false
04efe004-756d-4ec0-bec9-3ea0895d39f2	2026-08-17 11:36	2026-08-17 11:36	2026-08-17 11:36	BTU	BTU261016C00025000	call	25.0000	2026-10-16	2.5300	2.4200	2.6600	25.5300	22517.00	0.00	22517.00	89	14	90	526	0.171102661596958	0.533655761663837	0.533655761663837	false	false	false	true	false
d084815a-d50d-4b43-8841-166a6bcc2dae	2026-08-14 15:59	2026-08-14 15:59	2026-08-14 15:59	BTU	BTU260918C00024000	call	24.0000	2026-09-18	2.4500	2.2200	2.4500	25.4300	73500.00	73500.00	0.00	300	5	380	428	0.88785046728972	0.517939550757439	0.517939550757439	false	false	false	true	false