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 = Energy×ticker = TPL×

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

aeeed1ba-571d-4105-907d-8993a4bb04b9	2026-09-22 10:29	2026-09-22 10:29	2026-09-22 10:29	TPL	TPL261120C00390000	call	390.0000	2026-11-20	17.5400	16.9000	19.0000	361.2500	28060.00	14140.00	13920.00	16	6	27	98	0.275510204081633	0.477291463626163	0.477291463626163	false	false	false	true	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	Common Stock	Energy	24502566389.00	2026-11-04	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-22T14:31:31.654153Z"}	2026-09-22	2026-09-22 21:15	2026-09-22 21:15
fa4738db-76fa-4a82-804c-563d4a2fa182	2026-09-21 10:06	2026-09-21 10:06	2026-09-21 10:06	TPL	TPL261016C00360000	call	360.0000	2026-10-16	10.6100	10.2000	14.2000	347.0000	58340.00	1060.00	57280.00	55	21	60	162	0.37037037037037	0.43147405369993	0.4337490391972	true	false	false	true	false
a0b55677-36b9-4891-9e5c-5f1387141d55	2026-09-18 14:36	2026-09-18 14:36	2026-09-18 14:36	TPL	TPL261016C00360000	call	360.0000	2026-10-16	15.1600	14.6000	15.4000	356.7650	39426.00	39426.00	0.00	26	7	124	61	2.0327868852459	0.413435270512354	0.413435270512354	false	false	false	true	false
7540e0d6-54e6-46f0-ba73-12daebddac88	2026-09-18 14:36	2026-09-18 14:36	2026-09-18 14:36	TPL	TPL261016C00360000	call	360.0000	2026-10-16	15.2300	14.5000	15.8000	356.4100	108110.00	93510.00	14600.00	71	9	98	61	1.60655737704918	0.410818929726562	0.420738100090464	false	false	false	true	false
ad9b2840-6b75-46d4-ae1c-e4a45fa7b457	2026-09-18 09:55	2026-09-18 09:55	2026-09-18 09:55	TPL	TPL270115P00300000	put	300.0000	2027-01-15	12.5000	10.5000	12.5000	351.1700	125000.00	125000.00	0.00	100	6	102	1225	0.083265306122449	0.450674329044365	0.450674329044365	false	false	false	true	false
95371cb5-1de2-485e-b43c-cdaa9e455a18	2026-09-18 09:51	2026-09-18 09:51	2026-09-18 09:51	TPL	TPL270115P00400000	put	400.0000	2027-01-15	64.0000	62.2000	64.0000	349.2400	652800.00	652800.00	0.00	102	9	102	411	0.248175182481752	0.438929678720199	0.438929678720199	false	false	false	true	false
42d11716-6621-4d85-b58e-f10336234e5f	2026-09-17 12:22	2026-09-17 12:22	2026-09-17 12:22	TPL	TPL270115P00300000	put	300.0000	2027-01-15	12.9000	12.7000	13.6000	347.7400	65790.00	0.00	65790.00	51	21	61	1165	0.0523605150214592	0.443121504879333	0.443121504879333	false	false	false	true	false
b04096a0-711b-4661-9972-81fb5f93be0d	2026-09-17 11:52	2026-09-17 11:52	2026-09-17 11:52	TPL	TPL261016C00390000	call	390.0000	2026-10-16	4.1000	4.0000	5.0000	346.6172	13940.00	410.00	13530.00	34	18	44	147	0.299319727891156	0.43030643828573	0.43030643828573	false	false	false	true	false
d0c83963-1382-4c3a-abdb-b53a196cbe24	2026-09-16 15:22	2026-09-16 15:22	2026-09-16 15:22	TPL	TPL261016C00370000	call	370.0000	2026-10-16	9.3000	9.3000	11.0000	347.6450	26040.00	0.00	26040.00	28	16	35	134	0.261194029850746	0.4380171716003	0.4380171716003	false	false	false	true	false
63424f05-7c4a-49ce-ae6f-25187a12a9c8	2026-09-16 11:27	2026-09-16 11:26	2026-09-16 11:26	TPL	TPL270115P00350000	put	350.0000	2027-01-15	32.9300	28.0000	33.6000	351.7138	65856.00	65856.00	0.00	20	8	20	1611	0.0124146492861577	0.460729798190342	0.439506879062649	false	false	false	true	false
6afae401-18d2-4dc7-aabb-b5e4c4468c92	2026-09-15 10:17	2026-09-15 10:17	2026-09-15 10:17	TPL	TPL260918C00350000	call	350.0000	2026-09-18	24.0000	24.0000	28.0000	373.8000	117601.00	0.00	117601.00	49	22	50	24	2.08333333333333	0.355823267269197	0.355823267269197	false	false	false	true	false
e8a7ba48-6411-4f9d-b2c1-457c502f12ca	2026-09-11 14:17	2026-09-11 14:17	2026-09-11 14:17	TPL	TPL270115C00460000	call	460.0000	2027-01-15	12.0000	11.6000	13.5000	370.0800	12000.00	0.00	12000.00	10	5	12	30	0.4	0.426090415827307	0.426090415827307	false	false	false	true	false
c722d3ec-6aed-4635-be46-6f25edd876bf	2026-09-10 10:18	2026-09-10 10:18	2026-09-10 10:18	TPL	TPL261016C00410000	call	410.0000	2026-10-16	6.6000	6.4000	8.7000	367.1400	36300.00	0.00	36300.00	55	10	56	64	0.875	0.436056529839171	0.436056529839171	false	false	false	true	false
3b373d04-972d-4a47-ae61-77a85baf0587	2026-09-09 12:39	2026-09-09 12:38	2026-09-09 12:38	TPL	TPL261016C00410000	call	410.0000	2026-10-16	10.0000	10.0000	11.7000	378.2650	16000.00	0.00	16000.00	16	5	19	70	0.271428571428571	0.437572512662976	0.437572512662976	false	false	false	true	false
ff8205c3-91bb-435d-bb63-334d4891d2f5	2026-09-09 10:13	2026-09-09 10:13	2026-09-09 10:13	TPL	TPL261016P00300000	put	300.0000	2026-10-16	1.4000	1.4000	1.5500	381.0000	11060.00	0.00	11060.00	79	10	786	1246	0.630818619582664	0.494012647855007	0.494012647855007	true	false	false	true	false
fba9c5c0-5cb1-4b0b-bad9-d3eaa54ba6a9	2026-09-09 10:05	2026-09-09 10:05	2026-09-09 10:05	TPL	TPL261016P00400000	put	400.0000	2026-10-16	30.0000	28.6000	30.0000	383.5200	57000.00	57000.00	0.00	19	12	462	1411	0.327427356484763	0.4382639373371	0.4382639373371	false	false	false	true	false
57f4ea79-ea59-40a0-a61f-3d237256d052	2026-09-09 09:33	2026-09-09 09:33	2026-09-09 09:33	TPL	TPL261016P00380000	put	380.0000	2026-10-16	16.7000	15.5000	16.7000	387.7900	227120.00	227120.00	0.00	136	11	136	190	0.715789473684211	0.43229565510611	0.43229565510611	true	false	false	true	false
567fdd82-a944-4284-8a1f-0a985c53464b	2026-09-08 15:24	2026-09-08 15:24	2026-09-08 15:24	TPL	TPL261016P00400000	put	400.0000	2026-10-16	32.0000	30.2000	32.0000	380.2700	537600.00	537600.00	0.00	168	22	189	1411	0.133947554925585	0.434572628279898	0.434572628279898	true	false	false	true	false
e5884de4-d2e6-48cd-a6a3-f04982dbad83	2026-09-08 15:24	2026-09-08 15:24	2026-09-08 15:24	TPL	TPL261016P00400000	put	400.0000	2026-10-16	32.0000	30.2000	32.0000	380.7600	67200.00	67200.00	0.00	21	7	21	1411	0.0148830616583983	0.440775948956065	0.440775948956065	true	false	false	true	false
f613cac3-74f0-4acc-b48d-b92c19f66650	2026-09-04 14:43	2026-09-04 14:43	2026-09-04 14:43	TPL	TPL261016C00400000	call	400.0000	2026-10-16	8.0000	8.0000	8.9000	361.8900	67200.00	0.00	67200.00	84	32	85	82	1.03658536585366	0.417549342952461	0.417549342952461	false	false	false	true	false
b7d0b5ed-29f2-48f3-bb36-fa90cb5fff5c	2026-09-01 11:12	2026-09-01 11:12	2026-09-01 11:12	TPL	TPL261016P00400000	put	400.0000	2026-10-16	41.2000	39.1000	41.2000	368.4500	288400.00	288400.00	0.00	70	13	80	1411	0.0566973777462792	0.437634290608698	0.437634290608698	false	false	false	true	false
dbe117d2-d002-4155-8f2e-3834c3bf1d42	2026-08-28 13:25	2026-08-28 13:24	2026-08-28 13:24	TPL	TPL260918C00420000	call	420.0000	2026-09-18	1.4000	1.2000	1.7000	362.7731	11340.00	140.00	11200.00	81	30	90	38	2.36842105263158	0.424446544859048	0.424446544859048	false	false	false	true	false
287498ad-8574-4625-821c-56b2e45138c3	2026-08-27 15:39	2026-08-27 15:39	2026-08-27 15:39	TPL	TPL261016P00400000	put	400.0000	2026-10-16	42.0000	39.3000	42.0000	369.5850	680400.00	680400.00	0.00	162	9	562	1714	0.327887981330222	0.448114697742466	0.448114697742466	false	false	false	true	false
684c9b4c-b8d3-4fed-9471-8cfedba28fd7	2026-08-27 13:15	2026-08-27 13:15	2026-08-27 13:15	TPL	TPL261016P00400000	put	400.0000	2026-10-16	44.0000	41.1000	44.0000	366.0900	83600.00	83600.00	0.00	19	5	393	1714	0.22928821470245	0.442465570561668	0.442465570561668	false	false	false	true	false
baff032a-9be3-4725-833a-a37a224d0ad3	2026-08-27 13:11	2026-08-27 13:11	2026-08-27 13:11	TPL	TPL261016P00400000	put	400.0000	2026-10-16	44.0000	41.1000	44.0000	367.7000	633600.00	633600.00	0.00	144	11	344	1714	0.200700116686114	0.463578737566238	0.463578737566238	false	false	false	true	false
c996ac73-b6c2-4ef3-aa13-8de9c1d3018f	2026-08-27 10:10	2026-08-27 10:10	2026-08-27 10:10	TPL	TPL261016P00400000	put	400.0000	2026-10-16	45.0000	41.0000	45.0000	365.6501	900000.00	900000.00	0.00	200	14	200	1714	0.116686114352392	0.45679292433045	0.45679292433045	false	false	false	true	false
83ffd4a5-9930-4500-a364-5d97a5ac35a9	2026-08-27 09:52	2026-08-27 09:52	2026-08-27 09:52	TPL	TPL261016C00500000	call	500.0000	2026-10-16	1.5000	1.5000	3.0000	367.2100	16500.00	0.00	16500.00	110	7	110	504	0.218253968253968	0.489509030023832	0.489509030023832	false	false	false	true	false
42a0fba4-14c2-4192-ac9f-e33fa55c8212	2026-08-26 15:32	2026-08-26 15:32	2026-08-26 15:32	TPL	TPL261016P00400000	put	400.0000	2026-10-16	42.0000	40.4000	42.0000	368.8000	432600.00	432600.00	0.00	103	8	103	1907	0.0540115364446775	0.434390514109098	0.434390514109098	false	false	false	true	false
000fc516-439a-4f3e-941b-faff1df7c3ed	2026-08-26 14:52	2026-08-26 14:51	2026-08-26 14:51	TPL	TPL260918P00340000	put	340.0000	2026-09-18	5.4000	4.8000	5.4000	368.6500	33480.00	33480.00	0.00	62	20	82	68	1.20588235294118	0.451849081496833	0.451849081496833	false	false	false	true	false
b59d1482-0458-4941-a972-105b2b4aa73b	2026-08-26 11:40	2026-08-26 11:40	2026-08-26 11:40	TPL	TPL261016C00500000	call	500.0000	2026-10-16	1.6000	1.6000	3.1000	372.5500	23040.00	0.00	23040.00	144	8	144	504	0.285714285714286	0.47141142240665	0.47141142240665	false	false	false	true	false
a4399df4-80c9-49e3-9f2e-970ccd26b856	2026-08-25 10:05	2026-08-25 10:05	2026-08-25 10:05	TPL	TPL261016C00500000	call	500.0000	2026-10-16	1.6500	1.6500	3.2000	369.1000	19305.00	0.00	19305.00	117	8	117	602	0.194352159468439	0.482145382333844	0.482145382333844	false	false	false	true	false
a4a32a51-488a-455b-b959-58b2c0c00a8d	2026-08-21 10:58	2026-08-21 10:58	2026-08-21 10:58	TPL	TPL260918C00380000	call	380.0000	2026-09-18	17.8800	17.7000	18.5000	379.5600	60780.00	18300.00	42480.00	34	17	88	110	0.8	0.414638307977843	0.428983280272205	false	false	false	true	false
1428c4ea-5e4d-4f14-a537-7f7273f441b7	2026-08-21 10:56	2026-08-21 10:56	2026-08-21 10:56	TPL	TPL260918C00380000	call	380.0000	2026-09-18	18.5000	18.5000	19.7000	379.4900	99900.00	0.00	99900.00	54	39	54	110	0.490909090909091	0.433131707159338	0.434651535191415	false	false	false	true	false
f7ee7523-2154-407f-9e8f-690c316db092	2026-08-21 10:20	2026-08-21 10:20	2026-08-21 10:20	TPL	TPL270115C00600000	call	600.0000	2027-01-15	3.9000	3.3000	3.9000	384.9200	11700.00	9750.00	0.00	30	9	68	122	0.557377049180328	0.448143305774099	0.448143305774099	false	false	false	true	false
974db48f-32b6-4ed7-8df7-2e37ba95c526	2026-08-21 10:19	2026-08-21 10:19	2026-08-21 10:19	TPL	TPL270115C00600000	call	600.0000	2027-01-15	4.1000	3.7000	4.1000	384.5200	15580.00	3280.00	0.00	38	14	38	122	0.311475409836066	0.454178548804259	0.454178548804259	false	false	false	true	false
d99cd556-ee39-49bb-a240-fcfa898e463b	2026-08-17 14:23	2026-08-17 14:23	2026-08-17 14:23	TPL	TPL260918C00380000	call	380.0000	2026-09-18	11.1000	11.1000	12.0000	360.1600	117660.00	0.00	117660.00	106	34	106	39	2.71794871794872	0.43476984962355	0.43476984962355	false	false	false	true	false