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.

474,253 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts474,253 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:alert_rule = RepeatedHits×sector = Energy×

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

67b2562f-8083-4025-a57e-585174e879b1	2026-09-24 12:17	2026-09-24 12:17	2026-09-24 12:17	FRO	FRO261016C00048200	call	48.2000	2026-10-16	2.5000	2.5000	2.9000	48.4472	15750.00	0.00	15750.00	63	10	87	434	0.200460829493088	0.489789868561243	0.489789868561243	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Energy	10587944601.00	2026-11-20	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-24T16:18:11.979462Z"}	2026-09-24	2026-09-24 21:15	2026-09-24 21:15
d1895008-859a-4a33-be07-28a271f810e0	2026-09-24 12:17	2026-09-24 12:17	2026-09-24 12:17	DVN	DVN260925C00045000	call	45.0000	2026-09-25	3.8000	3.7500	4.5500	48.8300	38380.00	0.00	38380.00	101	15	101	9	11.2222222222222	2.14423225962947	1.00977580314937	false	false	false	true
ad1bd950-0c1d-4a8e-aea2-6dd69d663852	2026-09-24 12:16	2026-09-24 12:16	2026-09-24 12:16	GLNG	GLNG261218C00055000	call	55.0000	2026-12-18	2.0500	1.7500	2.0500	50.0000	102500.00	102500.00	0.00	500	5	1014	487	2.08213552361396	0.358802426043065	0.358802426043065	false	true	false	true
8e90193f-ecd3-44f2-b997-3432f1c6ebff	2026-09-24 12:15	2026-09-24 12:15	2026-09-24 12:15	SHEL	SHEL261030P00097000	put	97.0000	2026-10-30	3.4000	3.0000	3.4000	96.1800	10880.00	10880.00	0.00	32	14	32	22	1.45454545454545	0.263475893618562	0.263475893618562	false	false	false	true
27c5922f-08d0-4377-81b2-3f4cacdff414	2026-09-24 12:14	2026-09-24 12:14	2026-09-24 12:14	ENB	ENB261218P00045000	put	45.0000	2026-12-18	0.8500	0.7000	0.9000	47.6651	16996.00	6456.00	4505.00	200	9	302	15	20.1333333333333	0.229550921098501	0.229550921098501	true	false	false	true
baf97316-c28e-421f-957a-7d3c4fd822b1	2026-09-24 12:02	2026-09-24 12:02	2026-09-24 12:02	DHT	DHT261016C00023000	call	23.0000	2026-10-16	0.5500	0.4500	0.6000	21.6350	14135.00	14135.00	0.00	257	7	813	12591	0.064569930903026	0.495603405813453	0.495603405813453	false	false	false	true
116bbe3a-e5a8-4a45-a7d9-63a6dd6d5397	2026-09-24 12:00	2026-09-24 12:00	2026-09-24 12:00	PBF	PBF261120C00072500	call	72.5000	2026-11-20	9.0000	8.7000	9.0000	72.9300	78300.00	78300.00	0.00	87	20	88	29	3.03448275862069	0.750634527061549	0.750634527061549	false	false	false	true
1d7bd4e1-4dc9-44be-a9f3-7d4af9d5eeb7	2026-09-24 12:00	2026-09-24 12:00	2026-09-24 12:00	PSX	PSX280121P00185000	put	185.0000	2028-01-21	13.6000	12.9000	14.3000	263.1800	74800.00	17680.00	57120.00	55	9	55	12	4.58333333333333	0.45941603608176	0.45941603608176	true	false	false	true
73e6cd80-878c-44f2-b98b-2daca268f2db	2026-09-24 11:52	2026-09-24 11:52	2026-09-24 11:52	XOM	XOM260925P00165000	put	165.0000	2026-09-25	1.5700	1.3900	1.5700	164.3300	11616.00	11616.00	0.00	74	21	299	297	1.00673400673401	0.353762147622112	0.353762147622112	true	false	false	true
ec2f281c-732a-4589-a31b-bbf8eaa5b8f1	2026-09-24 11:50	2026-09-24 11:50	2026-09-24 11:50	MPC	MPC261016P00380000	put	380.0000	2026-10-16	11.0000	11.0000	11.1000	400.1000	34100.00	0.00	26400.00	31	14	66	1467	0.0449897750511247	0.518160347425775	0.518160347425775	false	false	false	true
b14aa8a1-6fc8-4b55-b700-2d571092c44e	2026-09-24 11:50	2026-09-24 11:50	2026-09-24 11:50	MPC	MPC261016P00380000	put	380.0000	2026-10-16	10.9000	10.9000	11.2000	400.1000	20710.00	0.00	20710.00	19	5	35	1467	0.0238582140422631	0.515284834348448	0.515284834348448	false	false	false	true
992556ed-7600-4e65-9c23-201274e432b9	2026-09-24 11:49	2026-09-24 11:49	2026-09-24 11:49	XOM	XOM261009C00165000	call	165.0000	2026-10-09	3.7500	3.7250	3.9000	164.4500	40875.00	0.00	40875.00	109	5	465	820	0.567073170731707	0.29214843591011	0.29214843591011	false	false	false	true
d45604cb-a2ce-4a91-a174-65c25be29655	2026-09-24 11:46	2026-09-24 11:46	2026-09-24 11:46	PSX	PSX270115C00280000	call	280.0000	2027-01-15	19.4000	19.2000	19.4000	262.9500	32980.00	15520.00	0.00	17	5	144	378	0.380952380952381	0.427497426075908	0.427497426075908	false	false	false	true
3e0b3291-e861-4ade-9c60-97e2d4c90d33	2026-09-24 11:46	2026-09-24 11:46	2026-09-24 11:46	PSX	PSX270115C00280000	call	280.0000	2027-01-15	19.5000	19.5000	20.1000	263.0408	42900.00	0.00	42900.00	22	5	127	378	0.335978835978836	0.428491167804661	0.428491167804661	false	false	false	true
2591a618-a802-4643-9e2c-7f68bf82b935	2026-09-24 11:46	2026-09-24 11:45	2026-09-24 11:45	PSX	PSX270115C00280000	call	280.0000	2027-01-15	19.6000	19.5000	20.1000	263.0000	31360.00	5880.00	5880.00	16	5	105	378	0.277777777777778	0.430536930836401	0.430536930836401	false	false	false	true
90126dac-6fe0-48f3-b668-d723673d7414	2026-09-24 11:45	2026-09-24 11:45	2026-09-24 11:45	PSX	PSX270115C00280000	call	280.0000	2027-01-15	19.5000	19.4000	20.1000	263.0000	42900.00	7800.00	27300.00	22	5	89	378	0.235449735449735	0.428817533054739	0.428817533054739	false	false	false	true
4350e70e-f7bd-48de-976f-b8a396116c93	2026-09-24 11:45	2026-09-24 11:45	2026-09-24 11:45	PSX	PSX270115C00280000	call	280.0000	2027-01-15	19.6000	19.5000	20.1000	263.0000	31360.00	3920.00	15680.00	16	7	67	378	0.177248677248677	0.430536930836401	0.430536930836401	false	false	false	true
6bd71bd2-8e7e-4f56-88aa-f9fcb110c5e2	2026-09-24 11:44	2026-09-24 11:44	2026-09-24 11:44	OXY	OXY261002C00058000	call	58.0000	2026-10-02	1.6000	1.5300	1.6000	58.6700	15999.00	15999.00	0.00	100	6	264	221	1.19457013574661	0.350091315137224	0.347102085880077	false	false	false	true
fb55ad8c-5306-462f-9995-545442198523	2026-09-24 11:43	2026-09-24 11:43	2026-09-24 11:43	PBR	PBR261009C00021500	call	21.5000	2026-10-09	0.8400	0.8100	0.8500	21.2500	11928.00	6888.00	5040.00	142	6	203	1329	0.152746425884123	0.546524972057149	0.546524972057149	false	false	false	true
a2b4ad06-eda7-47d9-84f7-27a433c4f50f	2026-09-24 11:39	2026-09-24 11:39	2026-09-24 11:39	XOM	XOM260925P00160000	put	160.0000	2026-09-25	0.2000	0.2000	0.2800	164.3200	64940.00	0.00	64940.00	3247	54	4065	2299	1.76816006959548	0.424214577719324	0.424214577719324	false	false	false	true
ce859cf6-78ae-4649-848c-40bf99da68dd	2026-09-24 11:37	2026-09-24 11:37	2026-09-24 11:37	VLO	VLO270617P00290000	put	290.0000	2027-06-17	18.2000	18.1000	19.0000	390.0000	70980.00	34580.00	36400.00	39	9	117	604	0.193708609271523	0.507583360357204	0.507583360357204	true	false	false	true
7848b366-c63b-4b6b-95c1-f034fd68c2ad	2026-09-24 11:34	2026-09-24 11:34	2026-09-24 11:34	FANG	FANG261120C00190000	call	190.0000	2026-11-20	12.0000	12.0000	12.5000	191.1250	12000.00	0.00	12000.00	10	5	25	36	0.694444444444444	0.360642133662882	0.360642133662882	false	false	false	true
829c5006-b6b6-4eb4-b493-486670d9e9d6	2026-09-24 11:32	2026-09-24 11:32	2026-09-24 11:32	CHRD	CHRD261016P00140000	put	140.0000	2026-10-16	4.0000	4.0000	4.3000	141.3300	50400.00	0.00	50400.00	126	29	127	23	5.52173913043478	0.347988270553979	0.347988270553979	false	false	false	true
b7ecc9a6-6c22-4b41-8e03-6f2c93c6657a	2026-09-24 11:29	2026-09-24 11:29	2026-09-24 11:29	OXY	OXY261120C00060000	call	60.0000	2026-11-20	2.7500	2.6500	2.7800	58.5200	133925.00	129800.00	3850.00	487	44	909	10918	0.0832570067777981	0.352135547214271	0.351363036817676	true	false	false	true
f9515b22-701c-4996-9cb0-e4b2f9e36574	2026-09-24 11:24	2026-09-24 11:24	2026-09-24 11:24	GLND	GLND261218C00006000	call	6.0000	2026-12-18	0.5000	0.3000	0.8000	4.0000	25011.00	2500.00	22511.00	500	8	1002	0	0	1.10476957199164	1.10476957199164	false	false	false	true
012d3fa8-c28a-40c5-966f-732b7764857f	2026-09-24 11:23	2026-09-24 11:23	2026-09-24 11:23	XOM	XOM261120P00155000	put	155.0000	2026-11-20	4.1000	3.9500	4.1000	163.0000	10660.00	10660.00	0.00	26	15	104	2479	0.0419524001613554	0.324772303796811	0.324772303796811	false	false	false	true
a28c33b2-57ce-4821-9a0c-d7f0abcb69ee	2026-09-24 11:19	2026-09-24 11:19	2026-09-24 11:19	DINO	DINO270115P00110000	put	110.0000	2027-01-15	14.0000	14.0000	14.4000	107.8000	58800.00	0.00	58800.00	42	13	42	351	0.11965811965812	0.569776072266394	0.569776072266394	false	false	false	true
6cd3b9af-3577-4e02-ad1b-3d6d79a82a6c	2026-09-24 11:16	2026-09-24 11:16	2026-09-24 11:16	PAGP	PAGP261120C00024000	call	24.0000	2026-11-20	2.9500	2.9000	3.1000	26.8700	29500.00	4130.00	25370.00	100	5	100	10391	0.0096237128284092	0.214223460189406	0.239433706576339	false	false	false	true
545c07c3-2ba6-4604-8659-0d40bccbc66c	2026-09-24 11:15	2026-09-24 11:15	2026-09-24 11:15	SLB	SLB261120C00055000	call	55.0000	2026-11-20	2.0800	2.0600	2.1300	52.0250	25376.00	208.00	22672.00	122	11	150	8210	0.0182704019488429	0.383796179055816	0.383796179055816	false	false	false	true
99efd09d-8be0-44df-a6ad-95f661d911cd	2026-09-24 11:15	2026-09-24 11:14	2026-09-24 11:14	YPF	YPF270115C00070000	call	70.0000	2027-01-15	1.1000	0.8500	1.1000	54.7900	29040.00	29040.00	0.00	264	18	294	7323	0.040147480540762	0.406237357610591	0.406237357610591	false	false	false	true
aa335962-ebde-4222-8faa-24dfa640ac9a	2026-09-24 11:12	2026-09-24 11:12	2026-09-24 11:12	TPL	TPL261016C00360000	call	360.0000	2026-10-16	6.5200	6.5000	8.0000	341.0000	26090.00	740.00	25350.00	40	11	40	184	0.217391304347826	0.399198912632603	0.399198912632603	false	false	false	true
16fd7cf5-53dc-42e8-b63e-ec2075212e7f	2026-09-24 11:11	2026-09-24 11:11	2026-09-24 11:11	FRO	FRO270219C00054200	call	54.2000	2027-02-19	3.5800	3.2000	3.7000	48.0000	53700.00	53700.00	0.00	150	2	150	907	0.165380374862183	0.429710378829797	0.421499724614283	false	true	false	true
e8c3c0c8-36c7-45df-9e31-763fdce1b5c8	2026-09-24 11:11	2026-09-24 11:11	2026-09-24 11:11	BP	BP280121P00050000	put	50.0000	2028-01-21	8.5500	8.4000	8.5500	45.0000	33345.00	33345.00	0.00	39	5	202	2177	0.0927882406982085	0.370051464005476	0.370051464005476	false	false	false	true
ac05b465-ee2b-4450-976d-fdc1d161bb79	2026-09-24 11:09	2026-09-24 11:09	2026-09-24 11:09	XOM	XOM270115C00180000	call	180.0000	2027-01-15	5.1500	5.1000	5.1500	164.0000	10300.00	2060.00	0.00	20	19	79	35269	0.00223992741501035	0.277602687118268	0.277602687118268	false	false	false	true
5f973ae1-7d2b-40f3-9590-325c43d37b52	2026-09-24 11:07	2026-09-24 11:07	2026-09-24 11:07	EQT	EQT261120P00047500	put	47.5000	2026-11-20	1.0400	0.9800	1.0400	51.2600	25792.00	25792.00	0.00	248	30	286	328	0.871951219512195	0.332621358464095	0.332621358464095	false	false	false	true
e869fa00-c0e0-405d-bfda-5f6066cada06	2026-09-24 11:06	2026-09-24 11:06	2026-09-24 11:06	LEU	LEU270115P00125000	put	125.0000	2027-01-15	13.1000	12.7000	13.7000	145.4800	123140.00	0.00	123140.00	94	21	96	77	1.24675324675325	0.759842260741139	0.759842260741139	false	false	false	true
c0f5f0a2-f2de-4ecb-8ee6-5e75db4aff80	2026-09-24 11:02	2026-09-24 11:02	2026-09-24 11:02	CVX	CVX261218C00210000	call	210.0000	2026-12-18	10.0000	9.8500	10.1000	207.7900	10000.00	9000.00	1000.00	10	5	41	3837	0.0106854313265572	0.252160238287814	0.252160238287814	false	false	false	true
fe9ed7bb-1ef3-4385-906e-a4ff0163e150	2026-09-24 10:57	2026-09-24 10:57	2026-09-24 10:57	VLO	VLO261016P00370000	put	370.0000	2026-10-16	12.2100	12.2000	13.0000	388.0000	12210.00	0.00	12210.00	10	5	28	844	0.033175355450237	0.547213017964894	0.547213017964894	false	false	false	true
c17e4c82-57ac-489e-acfd-4cee3246e940	2026-09-24 10:55	2026-09-24 10:54	2026-09-24 10:54	DVN	DVN261120C00050000	call	50.0000	2026-11-20	2.5200	2.5200	2.6000	48.9600	16632.00	0.00	16632.00	66	12	241	26189	0.0092023368589866	0.368930262803896	0.368930262803896	false	false	false	true
027fcc5e-eea2-49d8-b95e-fc9514c1e320	2026-09-24 10:53	2026-09-24 10:53	2026-09-24 10:53	SU	SU261016C00069000	call	69.0000	2026-10-16	2.4500	2.3500	2.5500	69.4100	10535.00	7595.00	2940.00	43	7	116	0	0	0.317638383619396	0.317638383619396	false	false	false	true
a24fbd6c-fb29-418f-8a16-2976e244b9cb	2026-09-24 10:52	2026-09-24 10:52	2026-09-24 10:52	BP	BP280121P00050000	put	50.0000	2028-01-21	8.6500	8.4500	8.6500	45.2600	25950.00	25950.00	0.00	30	8	128	2177	0.0587965089572807	0.371868385679972	0.371868385679972	false	false	false	true
7849d1d2-b10b-4eaa-852b-18b7b4bd3fa2	2026-09-24 10:51	2026-09-24 10:51	2026-09-24 10:51	VLO	VLO261218P00370000	put	370.0000	2026-12-18	29.6000	29.1000	29.8000	386.0550	186480.00	23680.00	162800.00	63	15	327	683	0.478770131771596	0.533214239081958	0.534953179985499	false	false	false	true
1ee48489-9cca-46a8-bd5c-9ac28b15ddd7	2026-09-24 10:51	2026-09-24 10:51	2026-09-24 10:51	XOM	XOM260925C00160000	call	160.0000	2026-09-25	4.6000	4.5000	4.8000	164.3600	80500.00	18400.00	62100.00	175	6	341	1189	0.286795626576955	0.440431156214192	0.440431156214192	false	false	false	true
c2ed195a-0498-4b7f-a457-2718c551bb2f	2026-09-24 10:51	2026-09-24 10:50	2026-09-24 10:50	BP	BP280121P00050000	put	50.0000	2028-01-21	8.6000	8.4000	8.6000	45.3100	39560.00	39560.00	0.00	46	11	98	2177	0.045016077170418	0.370528333008921	0.370528333008921	false	false	false	true
160544b5-708d-47e0-b450-525927b9cb4c	2026-09-24 10:50	2026-09-24 10:50	2026-09-24 10:50	VLO	VLO261218P00360000	put	360.0000	2026-12-18	25.1000	25.1000	25.3000	385.9100	25100.00	0.00	25100.00	10	6	322	374	0.86096256684492	0.533574332728895	0.533574332728895	false	false	false	true
2c7c8981-3cd5-4315-9471-d0e29ddd6d2c	2026-09-24 10:50	2026-09-24 10:50	2026-09-24 10:50	COP	COP261016C00132000	call	132.0000	2026-10-16	3.4500	3.4500	3.5000	130.0000	26910.00	0.00	26910.00	78	16	544	37	14.7027027027027	0.318180228127079	0.318180228127079	true	false	false	true
c5dc1878-facc-4c37-992c-d41188162c72	2026-09-24 10:49	2026-09-24 10:49	2026-09-24 10:49	COP	COP261016C00132000	call	132.0000	2026-10-16	3.4500	3.4500	3.5000	130.0000	31395.00	0.00	6210.00	91	16	405	37	10.9459459459459	0.318180228127079	0.318180228127079	false	false	false	true
948dd2a1-9be1-4454-a791-7c1ada109088	2026-09-24 10:47	2026-09-24 10:47	2026-09-24 10:47	DHT	DHT261016C00023000	call	23.0000	2026-10-16	0.5500	0.5000	0.5500	21.0000	27390.00	27390.00	0.00	498	6	520	12591	0.0412993407989834	0.510308769574249	0.510308769574249	false	false	false	true
d11d0a5f-a3a0-4b1d-9661-fc6507e40d05	2026-09-24 10:47	2026-09-24 10:47	2026-09-24 10:47	VLO	VLO261218P00360000	put	360.0000	2026-12-18	24.8000	24.8000	25.1000	386.0000	79360.00	0.00	79360.00	32	10	279	374	0.745989304812834	0.533135014806675	0.534253279458617	false	false	false	true
db3714bb-68fe-4080-a4ae-8cda7236a1ab	2026-09-24 10:46	2026-09-24 10:46	2026-09-24 10:46	VLO	VLO261218P00360000	put	360.0000	2026-12-18	24.8000	24.8000	25.2000	386.7650	89280.00	0.00	89280.00	36	11	244	374	0.6524064171123	0.533305319031133	0.533305319031133	false	false	false	true