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 = TRGP×

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

6b5f7447-952d-4db6-88ad-b1fb6ba5052e	2026-09-22 15:23	2026-09-22 15:23	2026-09-22 15:23	TRGP	TRGP261120C00290000	call	290.0000	2026-11-20	13.1600	13.0000	15.4000	284.9200	92104.00	0.00	92104.00	70	8	70	3	23.3333333333333	0.315597134351454	0.321602337908725	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Energy	60501712575.00	2026-11-04	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-22T19:27:59.988967Z"}	2026-09-22	2026-09-22 21:15	2026-09-22 21:15
adeb550a-858d-43c6-8507-7c6d454e1857	2026-09-22 10:05	2026-09-22 10:05	2026-09-22 10:05	TRGP	TRGP261120C00300000	call	300.0000	2026-11-20	11.5400	10.0000	12.8000	291.4500	80780.00	65780.00	15000.00	70	6	70	100	0.7	0.273780861661167	0.317871078476717	false	false	false	true	false
dd618806-d654-4184-bac6-1ef4bd75d29b	2026-09-21 14:35	2026-09-21 14:34	2026-09-21 14:34	TRGP	TRGP261218P00290000	put	290.0000	2026-12-18	17.6000	17.6000	18.0000	290.8350	84480.00	0.00	84480.00	48	23	95	54	1.75925925925926	0.343142873617288	0.343142873617288	false	false	false	true	false
f3ecb8a0-1e6a-47cd-a3d4-b91740fd5931	2026-09-14 11:01	2026-09-14 11:01	2026-09-14 11:01	TRGP	TRGP261016C00320000	call	320.0000	2026-10-16	2.2000	2.0000	3.4000	290.4000	55440.00	8800.00	46640.00	252	39	679	712	0.953651685393258	0.307950502183541	0.307950502183541	true	false	false	true	false
16fea7a4-07f1-4137-99d1-efccc399d26f	2026-09-10 10:47	2026-09-10 10:47	2026-09-10 10:47	TRGP	TRGP270319C00300000	call	300.0000	2027-03-19	26.8700	24.4000	26.9000	290.0100	188060.00	188060.00	0.00	70	5	70	146	0.479452054794521	0.341871021970396	0.338267486686785	false	false	false	true	false
37c7171a-42b5-438a-9339-9b1636b15892	2026-09-03 10:32	2026-09-03 10:32	2026-09-03 10:32	TRGP	TRGP261016C00300000	call	300.0000	2026-10-16	9.9000	9.9000	11.3000	292.3648	90090.00	0.00	90090.00	91	36	91	135	0.674074074074074	0.316224631452663	0.316224631452663	false	false	false	true	false
280a26c9-d1f2-446e-92c4-7416679b4deb	2026-09-01 12:49	2026-09-01 12:48	2026-09-01 12:48	TRGP	TRGP261218C00310000	call	310.0000	2026-12-18	16.5000	16.5000	17.3000	294.8295	54450.00	0.00	54450.00	33	10	53	43	1.23255813953488	0.334582785399773	0.334582785399773	false	false	false	true	false
e7a272f9-01a0-4772-9205-972131bce286	2026-08-31 13:12	2026-08-31 13:12	2026-08-31 13:12	TRGP	TRGP261218P00300000	put	300.0000	2026-12-18	25.8000	25.8000	27.1000	290.4900	152220.00	0.00	152220.00	59	20	113	460	0.245652173913043	0.354927112871139	0.354927112871139	false	false	false	true	false
cca8c1d8-4f1e-4823-9aa1-1d4e83736735	2026-08-31 09:54	2026-08-31 09:54	2026-08-31 09:54	TRGP	TRGP261218P00300000	put	300.0000	2026-12-18	25.0000	25.0000	26.4000	291.9150	77500.00	0.00	77500.00	31	10	41	460	0.0891304347826087	0.353514652862323	0.353514652862323	false	false	false	true	false
ba987621-7cca-41d9-b3d5-55bc2574d3c3	2026-08-27 11:08	2026-08-27 11:08	2026-08-27 11:08	TRGP	TRGP261218C00300000	call	300.0000	2026-12-18	16.2000	16.0000	16.3000	285.2950	208980.00	76140.00	132840.00	129	12	511	275	1.85818181818182	0.330431404946961	0.330431404946961	false	false	false	true	false
44945a81-84f1-4aa7-b1e3-07a0931d6487	2026-08-27 11:08	2026-08-27 11:08	2026-08-27 11:08	TRGP	TRGP270115P00290000	put	290.0000	2027-01-15	24.5900	24.4000	24.9000	285.2950	125426.00	71626.00	53800.00	51	12	70	20	3.5	0.347341584956838	0.347341584956838	false	false	false	true	false
2e9de275-1c2a-4226-96e0-0841716848c8	2026-08-27 11:08	2026-08-27 11:08	2026-08-27 11:08	TRGP	TRGP261218P00290000	put	290.0000	2026-12-18	22.9000	22.8000	23.0000	285.2950	73280.00	38930.00	34350.00	32	13	32	5	6.4	0.351508407885958	0.351508407885958	true	false	false	true	false
1a11b080-6a34-4f03-84dd-4d45ea4c312f	2026-08-27 11:08	2026-08-27 11:08	2026-08-27 11:08	TRGP	TRGP270115C00300000	call	300.0000	2027-01-15	18.6300	18.5000	19.2000	285.2950	484480.00	39480.00	378400.00	260	30	361	75	4.81333333333333	0.327502821908526	0.327502821908526	true	false	false	true	false
1415ef18-2371-4e67-8801-29d6728c26dd	2026-08-27 11:08	2026-08-27 11:08	2026-08-27 11:08	TRGP	TRGP270115P00300000	put	300.0000	2027-01-15	30.5000	30.2000	30.8000	285.2950	179936.00	125046.00	54890.00	59	21	160	1	160	0.349123052011806	0.349123052011806	true	false	false	true	false
99b53c4c-a9cc-4d22-84d8-7c124905d0f2	2026-08-27 11:07	2026-08-27 11:07	2026-08-27 11:07	TRGP	TRGP261218C00300000	call	300.0000	2026-12-18	15.8100	15.1000	16.2000	285.3000	53750.00	27080.00	26670.00	34	8	342	275	1.24363636363636	0.326703050858223	0.32244332323567	false	false	false	true	false
3e459d05-8af7-427d-af3d-6f84c2e1e5ce	2026-08-27 11:07	2026-08-27 11:07	2026-08-27 11:07	TRGP	TRGP261218C00300000	call	300.0000	2026-12-18	16.0000	15.0000	16.1000	285.1500	478383.00	471993.00	0.00	299	62	305	275	1.10909090909091	0.330629791404488	0.328294647498966	false	false	false	true	false
30f6b67e-75ed-47f1-9ea0-92bf568f179d	2026-08-24 13:27	2026-08-24 13:26	2026-08-24 13:26	TRGP	TRGP261218P00300000	put	300.0000	2026-12-18	24.2000	23.7000	24.2000	293.8900	159720.00	159720.00	0.00	66	28	460	9	51.1111111111111	0.346691998084677	0.346691998084677	false	false	false	true	false
e6dc8e14-9f18-4cd0-8b37-6b41fd39b724	2026-08-24 12:26	2026-08-24 12:26	2026-08-24 12:26	TRGP	TRGP261218P00300000	put	300.0000	2026-12-18	24.2000	23.3000	25.9000	293.2300	815526.00	776806.00	36300.00	337	63	394	9	43.7777777777778	0.342652661349455	0.341883517035801	true	false	false	true	false
c3b234c6-cab1-4000-a567-21cd43b63acf	2026-08-24 10:41	2026-08-24 10:41	2026-08-24 10:41	TRGP	TRGP261218P00300000	put	300.0000	2026-12-18	24.0000	21.7000	24.0000	293.1100	136800.00	136800.00	0.00	57	27	57	9	6.33333333333333	0.337966282987495	0.337966282987495	false	false	false	true	false
9c057c0e-13e8-4fd5-a019-9a94a99a43d5	2026-08-21 11:19	2026-08-21 11:19	2026-08-21 11:19	TRGP	TRGP260821C00280000	call	280.0000	2026-08-21	17.8000	15.9000	18.9000	297.8100	250980.00	94340.00	156640.00	141	6	142	762	0.186351706036745	2.25532739540326	2.26531705944657	false	false	false	true	false
84695d26-5df0-4fda-8876-2c9acbf1c801	2026-08-20 11:51	2026-08-20 11:51	2026-08-20 11:51	TRGP	TRGP260821C00290000	call	290.0000	2026-08-21	13.5000	11.7000	15.1000	303.2150	1343250.00	1343250.00	0.00	995	1	1228	1418	0.866008462623413	0.567034496616389	0.567034496616389	false	true	false	true	false
0d81549a-8858-4ad0-a713-ebfe432a8d5d	2026-08-20 11:51	2026-08-20 11:51	2026-08-20 11:51	TRGP	TRGP260821C00290000	call	290.0000	2026-08-21	13.2000	10.7000	13.5000	302.5100	240219.00	238899.00	1320.00	182	43	233	1418	0.164315937940762	0.697980853829629	0.697980853829629	false	false	false	true	false