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.

281,039 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts281,039 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:sector = Energy×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	expirydate	pricenumeric

99a863ba-bf24-48b3-8cba-9d936ade891f	2026-08-17 13:20	2026-08-17 13:20	2026-08-17 13:20	CCJ	CCJ260828P00098000	put	98.0000	2026-08-28	2.3400	2.2000	2.3400	99.4050	58734.00	58734.00	0.00	251	9	251	16	15.6875	0.444851841483114	0.444851841483114	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Energy	40610811028.00	2026-11-04	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-17T17:22:08.033203Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
981429a0-5acd-425d-8b08-728f8f1993e5	2026-08-17 13:24	2026-08-17 13:23	2026-08-17 13:23	LEU	LEU261016C00240000	call	240.0000	2026-10-16	6.6000	6.6000	7.9000	184.6700	16500.00	0.00	16500.00	25	12	27	136	0.198529411764706	0.72942466561739	0.72942466561739	false	false	false	true	false
6544a9e3-b5ef-408d-9355-0cc05379abc2	2026-08-17 13:25	2026-08-17 13:25	2026-08-17 13:25	SM	SM270115C00035000	call	35.0000	2027-01-15	4.4000	4.2000	4.4000	34.5300	11438.00	11438.00	0.00	26	5	79	310	0.254838709677419	0.493848527294033	0.493848527294033	false	false	false	true	false
3b867f63-34fd-456d-93b4-c3fce316c7aa	2026-08-17 13:26	2026-08-17 13:26	2026-08-17 13:26	PSX	PSX270219C00280000	call	280.0000	2027-02-19	12.2500	12.2000	12.3000	240.0901	84550.00	45510.00	39040.00	69	11	69	8	8.625	0.355236947389885	0.355236947389885	false	false	false	true	false
a752ac91-2abb-4640-81b0-c07efa192c2c	2026-08-17 13:27	2026-08-17 13:27	2026-08-17 13:27	FRO	FRO270115C00050000	call	50.0000	2027-01-15	1.7500	1.6000	1.8000	42.3900	19250.00	16800.00	0.00	110	21	151	1204	0.125415282392027	0.369744567701174	0.369744567701174	false	false	false	true	false
db6912d2-c8ae-4310-82a4-7d44edc95af0	2026-08-17 13:27	2026-08-17 13:27	2026-08-17 13:27	FRO	FRO270115C00050000	call	50.0000	2027-01-15	1.7500	1.7000	1.8000	42.3900	10150.00	9975.00	0.00	58	14	291	1204	0.241694352159468	0.369744567701174	0.369744567701174	false	false	false	true	false
1ede3d99-b8e0-4df4-ab39-a815ff9991ad	2026-08-17 13:31	2026-08-17 13:30	2026-08-17 13:30	XOM	XOM270115P00125000	put	125.0000	2027-01-15	1.2000	1.2000	1.2400	161.7800	171720.00	0.00	171720.00	1431	53	1456	5914	0.246195468380115	0.317883087590857	0.318076324100013	false	false	false	true	false
8239cbde-b2a2-4807-8e89-4b242ffc083e	2026-08-17 13:34	2026-08-17 13:34	2026-08-17 13:34	MPC	MPC260918C00320000	call	320.0000	2026-09-18	45.4900	45.1000	47.4000	361.6900	95520.00	59150.00	36370.00	21	7	28	576	0.0486111111111111	0.389911442756304	0.385358890784914	false	false	false	true	false
4dec442e-997d-4728-bf5c-e8619cbcad04	2026-08-17 13:34	2026-08-17 13:34	2026-08-17 13:34	MPC	MPC260918C00320000	call	320.0000	2026-09-18	45.4800	44.0000	45.5000	361.6900	100060.00	100060.00	0.00	22	9	50	576	0.0868055555555556	0.387643174456786	0.387643174456786	false	false	false	true	false
22ea0675-06b7-4c14-bd31-f176af51d50f	2026-08-17 13:34	2026-08-17 13:34	2026-08-17 13:34	WMB	WMB260918P00075000	put	75.0000	2026-09-18	2.7500	2.6500	2.8000	74.3700	128951.00	128676.00	275.00	469	48	624	1139	0.547848990342406	0.290252650896072	0.290252650896072	false	false	false	true	false
ae70dba8-cc2d-4e02-981c-6c6e75834f0a	2026-08-17 13:35	2026-08-17 13:35	2026-08-17 13:35	AR	AR260821P00037000	put	37.0000	2026-08-21	1.0000	0.9500	1.0000	36.2300	42500.00	42500.00	0.00	425	10	540	2216	0.243682310469314	0.353906044341098	0.353906044341098	false	false	false	true	false
d87f30da-a76f-4cd0-9140-b9d14f6d6d84	2026-08-17 13:36	2026-08-17 13:36	2026-08-17 13:36	FTK	FTK260821P00028000	put	28.0000	2026-08-21	1.5000	0.7000	4.8000	28.6500	15000.00	9450.00	5550.00	100	21	120	1	120	1.53348068903749	1.53348068903749	true	false	false	true	false
e37b3ab9-04af-4670-866b-4ba5f2947fa3	2026-08-17 13:49	2026-08-17 13:49	2026-08-17 13:49	EC	EC260918C00018000	call	18.0000	2026-09-18	0.6500	0.5500	0.6500	17.0000	18719.00	18719.00	0.00	288	16	344	891	0.386083052749719	0.383846865223485	0.379010028742517	true	false	false	true	false
128d0275-a24e-4a68-abc7-01f794f2c37e	2026-08-17 13:52	2026-08-17 13:52	2026-08-17 13:52	XOM	XOM260828C00165000	call	165.0000	2026-08-28	1.9200	1.8300	1.9900	161.0000	100031.00	99648.00	192.00	521	36	660	1431	0.461215932914046	0.284278795158498	0.284278795158498	false	false	false	true	false
eb07732a-c5e5-4e28-b556-90fb59dde59d	2026-08-17 14:06	2026-08-17 14:06	2026-08-17 14:06	RIG	RIG280121C00010000	call	10.0000	2028-01-21	0.5900	0.5200	0.6000	5.0000	11800.00	10502.00	1298.00	200	11	1233	22680	0.0543650793650794	0.532840933353759	0.532840933353759	false	false	false	true	false
8b3e9293-2f50-49e1-bc6d-916877746dac	2026-08-17 14:09	2026-08-17 14:09	2026-08-17 14:09	OXY	OXY260918C00060000	call	60.0000	2026-09-18	1.7600	1.7200	1.7600	59.0000	88000.00	73920.00	0.00	500	33	1355	12560	0.107882165605096	0.30157093623881	0.30157093623881	false	false	false	true	false
53d8ee69-413e-4e92-b074-ab31be123c50	2026-08-17 14:15	2026-08-17 14:15	2026-08-17 14:15	DHT	DHT261218P00018000	put	18.0000	2026-12-18	1.6000	1.5000	2.0000	18.7700	32315.00	8155.00	16160.00	202	6	204	12	17	0.489921418219463	0.477747032898818	false	false	false	true	false
aa56f9a9-c86c-4c54-8e86-ec51afe83fe8	2026-08-17 14:17	2026-08-17 14:17	2026-08-17 14:17	CVX	CVX270617C00210000	call	210.0000	2027-06-17	16.8500	16.4000	16.9500	203.0400	84270.00	44070.00	0.00	50	5	61	2041	0.0298873101420872	0.230414227083361	0.230414227083361	false	false	false	true	false
441164e2-8982-46cb-94ad-1326f61d425d	2026-08-17 14:18	2026-08-17 14:18	2026-08-17 14:18	VLO	VLO261218C00440000	call	440.0000	2026-12-18	11.2000	10.5000	11.2000	347.6400	103040.00	103040.00	0.00	92	30	98	31	3.16129032258065	0.451857370926132	0.451857370926132	false	false	false	true	false
e700b422-26ae-421d-9c44-98f1f35f9fc6	2026-08-17 14:23	2026-08-17 14:23	2026-08-17 14:23	CVX	CVX260918C00185000	call	185.0000	2026-09-18	18.4000	18.2000	18.6500	203.2708	51520.00	33120.00	18400.00	28	5	338	5180	0.0652509652509653	0.176191610804111	0.176191610804111	false	false	false	true
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
6d12971c-edbb-47b2-b96d-ac9fad0422c9	2026-08-17 14:24	2026-08-17 14:24	2026-08-17 14:24	PSX	PSX270115C00260000	call	260.0000	2027-01-15	15.6000	15.2000	15.7000	239.6600	113880.00	113880.00	0.00	73	23	232	126	1.84126984126984	0.358976165253493	0.358976165253493	false	false	false	true	false
6c6f40e7-916a-4760-a044-b6ca6dd96a65	2026-08-17 14:25	2026-08-17 14:25	2026-08-17 14:25	MPC	MPC261218C00470000	call	470.0000	2026-12-18	9.4000	8.7000	9.4000	362.7000	85540.00	85540.00	0.00	91	22	93	135	0.688888888888889	0.441322635204687	0.441322635204687	false	false	false	true	false
3b5e2d38-32aa-4523-8db8-f3bada44c02e	2026-08-17 14:28	2026-08-17 14:27	2026-08-17 14:27	STNG	STNG261016C00085000	call	85.0000	2026-10-16	3.2900	3.1000	3.3000	80.7250	12516.00	12516.00	0.00	38	8	396	270	1.46666666666667	0.370016842872471	0.370802664164342	false	false	false	true	false
fc7531c4-5330-433f-8be0-a014b1d8e44c	2026-08-17 14:30	2026-08-17 14:30	2026-08-17 14:30	ASC	ASC260918C00020000	call	20.0000	2026-09-18	0.2500	0.2000	0.2500	18.1000	23274.00	23274.00	0.00	931	15	933	5	186.6	0.395915473360801	0.391693470132597	false	false	false	true	false
752e4ff7-cf85-4625-9861-b632e32020f4	2026-08-17 14:32	2026-08-17 14:32	2026-08-17 14:32	CLMT	CLMT260821C00041000	call	41.0000	2026-08-21	7.2000	7.2000	7.4000	48.1300	10080.00	0.00	10080.00	14	5	34	249	0.136546184738956	0.843067167227051	0.843067167227051	false	false	false	true	false
52d6557f-c5bb-414a-acce-7910c16adcdd	2026-08-17 14:33	2026-08-17 14:33	2026-08-17 14:33	ASC	ASC260918C00020000	call	20.0000	2026-09-18	0.3000	0.2500	0.3500	18.2900	10170.00	0.00	10050.00	339	22	2204	5	440.8	0.395021273664649	0.395021273664649	false	false	false	true	false
6c8a96f5-d8fc-4ebf-b59c-0a38a865bfa8	2026-08-17 14:34	2026-08-17 14:34	2026-08-17 14:34	CVX	CVX261120C00200000	call	200.0000	2026-11-20	12.5500	12.3000	12.7000	203.4000	97890.00	16315.00	81575.00	78	8	112	329	0.340425531914894	0.235269467492801	0.235269467492801	false	false	false	true	false
faea240b-5062-4f47-b33e-4b5b27501c64	2026-08-17 14:37	2026-08-17 14:37	2026-08-17 14:37	LBRT	LBRT260918C00022000	call	22.0000	2026-09-18	1.5000	1.4000	1.5500	22.1300	10050.00	8250.00	1800.00	67	6	136	161	0.84472049689441	0.539189140520255	0.537048987884429	false	false	false	true	false
477700a2-4ae1-4ed2-bf27-31f950a6ff1e	2026-08-17 14:40	2026-08-17 14:40	2026-08-17 14:40	FRO	FRO261120C00055000	call	55.0000	2026-11-20	0.7000	0.6000	0.7500	42.4250	16310.00	630.00	15680.00	233	16	1054	9607	0.109711668574997	0.43602986258812	0.43602986258812	false	false	false	true	false
c639e59b-a35d-43f7-9647-3b00f05fd689	2026-08-17 14:40	2026-08-17 14:40	2026-08-17 14:40	COP	COP270617P00115000	put	115.0000	2027-06-17	7.9000	7.8500	7.9000	127.2700	65570.00	65570.00	0.00	83	8	370	158	2.34177215189873	0.336365954930667	0.336365954930667	false	false	false	true	false
cbf0c006-669e-4bf6-871a-eb17ed0d652f	2026-08-17 14:40	2026-08-17 14:40	2026-08-17 14:40	YPF	YPF261016C00055000	call	55.0000	2026-10-16	2.5500	2.5500	2.6000	52.6500	44880.00	0.00	44880.00	176	8	14817	2740	5.40766423357664	0.399308126372839	0.399308126372839	false	false	false	true	false
ef076240-a474-48bc-b815-fee4dfa1c5c8	2026-08-17 14:43	2026-08-17 14:43	2026-08-17 14:43	LEU	LEU261016C00250000	call	250.0000	2026-10-16	5.0000	4.9000	6.0000	182.7000	127000.00	0.00	126500.00	254	42	256	214	1.19626168224299	0.737709965886681	0.737709965886681	false	false	false	true	false
fef3dd35-0108-4b4e-9b44-c9903866fcd5	2026-08-17 14:44	2026-08-17 14:43	2026-08-17 14:43	CAPL	CAPL261016C00022500	call	22.5000	2026-10-16	2.1900	1.7000	2.6000	24.1550	10960.00	6680.00	4280.00	50	15	57	211	0.270142180094787	0.26476465255758	0.26476465255758	false	false	false	true	false
80729365-3307-4b79-a3c0-e6852bf99d97	2026-08-17 14:44	2026-08-17 14:44	2026-08-17 14:44	SHEL	SHEL260918C00095000	call	95.0000	2026-09-18	1.2000	1.1000	1.2500	91.5600	60240.00	47520.00	12720.00	502	26	603	1919	0.314226159458051	0.222938320684584	0.222938320684584	false	false	false	true
1e166909-a3b6-4b1e-a6d6-0f6009eb7dd1	2026-08-17 14:53	2026-08-17 14:53	2026-08-17 14:53	UUUU	UUUU261016C00018000	call	18.0000	2026-10-16	0.7800	0.7800	0.8000	14.8050	43368.00	0.00	43368.00	556	10	716	2193	0.326493388052896	0.739105746486092	0.740584677634275	false	false	false	true	false
a8d5ae34-2ce1-4326-938d-63dbf872cea0	2026-08-17 14:54	2026-08-17 14:54	2026-08-17 14:54	EC	EC270219C00018000	call	18.0000	2027-02-19	2.0500	1.8000	2.1000	17.6950	14350.00	10250.00	3895.00	70	6	90	208	0.432692307692308	0.403210207028303	0.403210207028303	false	false	false	true	false
f38b81b0-0ec3-48c6-a277-20f44bb3e38e	2026-08-17 14:57	2026-08-17 14:56	2026-08-17 14:56	OXY	OXY260918P00057500	put	57.5000	2026-09-18	1.5100	1.4400	1.5200	59.0501	278595.00	278142.00	0.00	1845	78	4148	2103	1.97242035187827	0.333209580903698	0.331286895207696	false	false	false	true	false
222a924e-c704-488d-b015-58d71d439492	2026-08-17 14:59	2026-08-17 14:58	2026-08-17 14:58	OVV	OVV261016P00055000	put	55.0000	2026-10-16	0.8500	0.7000	0.8500	63.6900	21250.00	21250.00	0.00	250	24	384	4091	0.0938645807870936	0.394137638597265	0.394137638597265	false	false	false	true	false
7679c9d0-6927-4da3-985a-5d156f5c9146	2026-08-17 15:01	2026-08-17 15:01	2026-08-17 15:01	CCJ	CCJ260918P00090000	put	90.0000	2026-09-18	1.6000	1.6000	1.7200	98.8000	11360.00	0.00	11360.00	71	12	314	3598	0.0872707059477487	0.436438511176698	0.436438511176698	false	false	false	true	false
a163adbf-07e8-40bc-89d1-31e113187e62	2026-08-17 15:03	2026-08-17 15:03	2026-08-17 15:03	WTTR	WTTR260918C00022500	call	22.5000	2026-09-18	0.5000	0.1500	0.9000	21.2800	10750.00	0.00	10750.00	215	29	676	30	22.5333333333333	0.374705596575996	0.374705596575996	true	false	false	true	false
4d281c85-146b-4106-a0e6-0416f8f7277f	2026-08-17 15:05	2026-08-17 15:05	2026-08-17 15:05	CVX	CVX261120C00220000	call	220.0000	2026-11-20	4.9000	4.8500	5.0500	203.3800	119568.00	3430.00	103398.00	244	32	393	186	2.11290322580645	0.247119350279055	0.247119350279055	false	false	false	true	false
56a75847-32fc-4e9e-850b-f9d845ac5e99	2026-08-17 15:09	2026-08-17 15:09	2026-08-17 15:09	STNG	STNG280121C00070000	call	70.0000	2028-01-21	21.5000	21.5000	22.9000	80.4800	21500.00	0.00	21500.00	10	5	11	32	0.34375	0.375326625729428	0.375326625729428	false	false	false	true	false
4a9eb8b0-586b-493c-93c8-d4aa5646f8c9	2026-08-17 15:26	2026-08-17 15:26	2026-08-17 15:26	CCJ	CCJ260821C00095000	call	95.0000	2026-08-21	4.5000	4.4000	4.7000	98.8700	76500.00	1800.00	74700.00	170	27	348	1180	0.294915254237288	0.482848097695981	0.482848097695981	false	false	false	true	false
e969e511-08eb-4475-9524-33f945069282	2026-08-17 15:27	2026-08-17 15:27	2026-08-17 15:27	NUAI	NUAI260828C00005500	call	5.5000	2026-08-28	0.5500	0.5500	0.6500	5.3600	11000.00	0.00	11000.00	200	13	442	3481	0.126975007181844	1.64071939234452	1.64071939234452	false	false	false	true	false
e045df29-34c9-4739-9085-1ecf218f4998	2026-08-17 15:27	2026-08-17 15:27	2026-08-17 15:27	SU	SU261218C00070000	call	70.0000	2026-12-18	3.5000	3.3000	3.5000	66.6850	87500.00	87500.00	0.00	250	23	258	973	0.265159301130524	0.292759330740843	0.292759330740843	false	false	false	true	false
0201445e-b2bb-421a-982e-045190e6de7a	2026-08-17 15:28	2026-08-17 15:28	2026-08-17 15:28	CRK	CRK261120P00015000	put	15.0000	2026-11-20	2.3000	2.3000	2.4000	13.4500	16560.00	0.00	16560.00	72	17	73	65	1.12307692307692	0.521952995811597	0.521952995811597	false	false	false	true	false
758626da-0bc8-4cf4-99a8-86aec091fad4	2026-08-17 15:28	2026-08-17 15:28	2026-08-17 15:28	FRO	FRO261120C00042000	call	42.0000	2026-11-20	3.4000	3.4000	3.7000	42.4100	10200.00	0.00	10200.00	30	5	36	506	0.0711462450592885	0.347423170579002	0.347423170579002	false	false	false	true	false
600f5f22-0b51-44c5-b027-a50c42434667	2026-08-17 15:28	2026-08-17 15:28	2026-08-17 15:28	NUAI	NUAI261002C00005500	call	5.5000	2026-10-02	1.2500	1.1000	1.4500	5.3650	25000.00	2625.00	500.00	200	19	214	0	0	1.72511388333036	1.72511388333036	true	false	false	true	false
09768e2f-9ba5-4d25-8806-72e3c25c4ec8	2026-08-17 15:29	2026-08-17 15:29	2026-08-17 15:29	NUAI	NUAI261120C00005500	call	5.5000	2026-11-20	1.7000	1.7000	1.8000	5.3750	13090.00	0.00	12920.00	77	18	152	4125	0.0368484848484848	1.62049948572526	1.62043472280438	false	false	false	true	false