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.

425,429 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts425,429 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:sector = Energy×source = uw_flow_alerts×ticker = SHEL×

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

f3347431-35f8-4fda-a813-dd975bc8d89f	2026-09-24 13:57	2026-09-24 13:57	2026-09-24 13:57	SHEL	SHEL261218C00095000	call	95.0000	2026-12-18	5.2000	5.0000	5.2000	96.0600	21319.00	21319.00	0.00	41	12	93	1746	0.0532646048109966	0.226453047998561	0.225954261932781	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ADR	Energy	271436282117.00	2026-10-29	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-24T18:01:57.698805Z"}	2026-09-24	2026-09-24 21:15	2026-09-24 21:15
c4115397-7eaf-4f8f-81b4-973eceff5f32	2026-09-24 12:56	2026-09-24 12:56	2026-09-24 12:56	SHEL	SHEL261016C00095000	call	95.0000	2026-10-16	3.0000	3.0000	3.1000	96.0000	30600.00	0.00	30600.00	102	12	233	7798	0.0298794562708387	0.248638011518845	0.248638011518845	false	false	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
187f370a-c147-4ef2-a1ae-1bfa2a161dea	2026-09-24 10:21	2026-09-24 10:20	2026-09-24 10:20	SHEL	SHEL280121P00090000	put	90.0000	2028-01-21	6.9200	6.9000	7.1000	96.6800	34605.00	0.00	34605.00	50	7	50	1521	0.0328731097961867	0.293107921925268	0.291782103288129	false	false	false	true
3e4ced31-67ae-4781-82d6-66a6dfd21d3c	2026-09-24 10:16	2026-09-24 10:16	2026-09-24 10:16	SHEL	SHEL270115C00100000	call	100.0000	2027-01-15	4.0000	3.9000	4.0000	96.6750	34800.00	34800.00	0.00	87	12	91	3062	0.0297191378184193	0.227855072789714	0.227855072789714	false	false	false	true
ddf1cc51-5b0a-4d98-9126-f5c04c1db329	2026-09-24 10:00	2026-09-24 10:00	2026-09-24 10:00	SHEL	SHEL261218C00100000	call	100.0000	2026-12-18	3.2000	3.1000	3.3000	96.5850	24960.00	24640.00	320.00	78	5	165	3508	0.0470353477765108	0.229141285236529	0.229141285236529	false	false	false	true
47726a2e-1739-4281-bd43-951ebb7c6033	2026-09-24 09:59	2026-09-24 09:59	2026-09-24 09:59	SHEL	SHEL261218C00095000	call	95.0000	2026-12-18	5.5000	5.5000	5.6000	96.5750	11000.00	0.00	11000.00	20	9	22	1746	0.0126002290950745	0.22525978362923	0.22525978362923	true	false	false	true
4dd32d71-8a74-41fa-96d0-a5ed03c3c15e	2026-09-24 09:44	2026-09-24 09:44	2026-09-24 09:44	SHEL	SHEL270319C00090000	call	90.0000	2027-03-19	10.6000	9.9000	10.7000	96.5350	39220.00	25440.00	13780.00	37	11	37	337	0.109792284866469	0.21154638451738	0.21154638451738	false	false	false	true
a8eff127-564e-4e80-a099-03246f6b042f	2026-09-24 09:37	2026-09-24 09:37	2026-09-24 09:37	SHEL	SHEL270319C00087500	call	87.5000	2027-03-19	12.1000	11.6000	12.2000	96.2300	15730.00	15730.00	0.00	13	5	13	394	0.032994923857868	0.208136210493997	0.208136210493997	false	false	false	true
960d5018-63d7-4cd6-9b9d-c49c832d46ae	2026-09-23 13:48	2026-09-23 13:48	2026-09-23 13:48	SHEL	SHEL270617P00097500	put	97.5000	2027-06-17	8.5000	8.5000	8.8000	95.0000	42500.00	0.00	42500.00	50	6	166	155	1.07096774193548	0.276641938910314	0.276641938910314	false	false	false	true
5f25c9e4-d4c0-4fc4-9a60-f056104f002f	2026-09-23 12:51	2026-09-23 12:51	2026-09-23 12:51	SHEL	SHEL260925C00096000	call	96.0000	2026-09-25	0.3500	0.2000	0.5000	94.3600	14000.00	7000.00	7000.00	400	10	428	103	4.15533980582524	0.337164794488226	0.337164794488226	false	false	false	true
3b6d2067-570e-4171-97e6-c24849d53814	2026-09-23 10:35	2026-09-23 10:35	2026-09-23 10:35	SHEL	SHEL270115C00100000	call	100.0000	2027-01-15	3.2000	3.2000	3.3000	95.0500	16000.00	0.00	16000.00	50	11	70	3012	0.0232403718459495	0.222309856400635	0.222309856400635	false	false	false	true
1a1ff582-faad-4a56-ab11-7693f0d4a9d6	2026-09-23 09:50	2026-09-23 09:50	2026-09-23 09:50	SHEL	SHEL270319C00085000	call	85.0000	2027-03-19	12.9000	12.5000	12.9000	94.9800	14190.00	14190.00	0.00	11	5	28	271	0.103321033210332	0.202531236308074	0.202531236308074	false	false	false	true
36019b9b-e4b9-47b7-9d6c-a019d25fe971	2026-09-23 09:46	2026-09-23 09:46	2026-09-23 09:46	SHEL	SHEL270319C00085000	call	85.0000	2027-03-19	12.8000	12.4000	12.8000	94.0000	20480.00	20480.00	0.00	16	5	16	271	0.0590405904059041	0.204667035425454	0.204667035425454	false	false	false	true
8c14981a-8aab-4533-9b66-ba848c17af9c	2026-09-22 15:24	2026-09-22 15:24	2026-09-22 15:24	SHEL	SHEL261016P00090000	put	90.0000	2026-10-16	0.7800	0.7500	0.9000	93.9500	12388.00	0.00	12388.00	158	5	212	1237	0.171382376717866	0.245061121525374	0.245061121525374	false	false	false	true
9f669d8f-0be0-4526-b3f7-1de9929fdb46	2026-09-22 13:54	2026-09-22 13:54	2026-09-22 13:54	SHEL	SHEL261120C00100000	call	100.0000	2026-11-20	1.5000	1.4500	1.6000	93.6300	15450.00	2100.00	13350.00	103	6	118	302	0.390728476821192	0.237286176179735	0.237286176179735	false	false	false	true
021c5661-e858-487c-af07-a33f194a4210	2026-09-22 09:35	2026-09-22 09:35	2026-09-22 09:35	SHEL	SHEL270319C00090000	call	90.0000	2027-03-19	8.2000	8.0000	8.3000	92.9300	42640.00	36900.00	5740.00	52	5	116	200	0.58	0.21745513847347	0.21745513847347	false	false	false	true
4ff6aeb2-1a87-4345-adcb-c1ab5c66efc6	2026-09-22 09:35	2026-09-22 09:35	2026-09-22 09:35	SHEL	SHEL270319C00090000	call	90.0000	2027-03-19	8.2000	8.0000	8.4000	92.9300	52480.00	47560.00	4920.00	64	22	64	200	0.32	0.21745513847347	0.21745513847347	false	false	false	true
0adbfcf6-3cc7-448c-88cd-b6026e724a53	2026-09-21 15:10	2026-09-21 15:10	2026-09-21 15:10	SHEL	SHEL280121P00105000	put	105.0000	2028-01-21	16.5000	16.1000	16.5000	93.5600	165000.00	165000.00	0.00	100	12	100	66	1.51515151515152	0.315137527570599	0.315137527570599	false	false	false	true
5bb0f492-a4ea-42cd-b48c-e5cf6ffb3df7	2026-09-21 14:57	2026-09-21 14:57	2026-09-21 14:57	SHEL	SHEL261016C00095000	call	95.0000	2026-10-16	1.8500	1.8500	2.0000	93.6600	143375.00	0.00	143375.00	775	7	893	6953	0.128433769595858	0.239129014527452	0.239129014527452	false	true	false	true
96dd0efa-0f96-4d9e-95a2-1d54c4346d08	2026-09-18 15:40	2026-09-18 15:40	2026-09-18 15:40	SHEL	SHEL270319C00087500	call	87.5000	2027-03-19	10.9000	10.6000	11.0000	94.4550	52320.00	44690.00	4360.00	48	20	109	298	0.365771812080537	0.211577897036523	0.2111999102126	false	false	false	true
f9f9d2cb-0a40-4174-b154-ce12b8165fa7	2026-09-17 12:13	2026-09-17 12:13	2026-09-17 12:13	SHEL	SHEL261016C00097500	call	97.5000	2026-10-16	1.8000	1.8000	1.8500	95.5200	79200.00	0.00	79200.00	440	40	467	6787	0.0688080153234124	0.235382349003747	0.235382349003747	false	false	false	true
b2f5ff2a-529d-4bd1-957f-063f9e7e8bee	2026-09-16 09:54	2026-09-16 09:54	2026-09-16 09:54	SHEL	SHEL261002P00098000	put	98.0000	2026-10-02	2.4000	2.1500	2.4000	97.2200	69360.00	69360.00	0.00	289	24	468	472	0.991525423728814	0.255379881612037	0.255379881612037	true	false	false	true
6de8796e-f385-4fde-850c-5442a829af2a	2026-09-15 12:06	2026-09-15 12:06	2026-09-15 12:06	SHEL	SHEL270115C00105000	call	105.0000	2027-01-15	3.3000	3.1000	3.3000	98.5299	69300.00	69300.00	0.00	210	19	652	322	2.02484472049689	0.233808065608161	0.233808065608161	true	false	false	true
fe653e02-46c6-4313-ae25-05ddc3550b5c	2026-09-15 10:25	2026-09-15 10:25	2026-09-15 10:25	SHEL	SHEL261016P00097500	put	97.5000	2026-10-16	2.2500	2.1500	2.3000	98.2500	58500.00	58500.00	0.00	260	21	272	26	10.4615384615385	0.242916991680937	0.242916991680937	false	false	false	true
5bcef744-2f25-46b2-8529-d381849c3e41	2026-09-15 10:14	2026-09-15 10:13	2026-09-15 10:13	SHEL	SHEL261218C00100000	call	100.0000	2026-12-18	4.2000	4.0000	4.3000	98.2800	384295.00	375055.00	9240.00	915	45	927	2883	0.321540062434964	0.22640515564631	0.22640515564631	false	false	false	true
9affb698-dcf9-446d-9e97-a4f32c3a5abf	2026-09-11 09:35	2026-09-11 09:35	2026-09-11 09:35	SHEL	SHEL270617C00095000	call	95.0000	2027-06-17	9.1000	9.0000	9.2000	96.0000	51870.00	0.00	34580.00	57	6	105	1550	0.067741935483871	0.208598387676435	0.208598387676435	false	false	false	true
af0a847c-2ff6-4e62-91ec-5fc949dd5b45	2026-09-10 11:34	2026-09-10 11:34	2026-09-10 11:34	SHEL	SHEL261016C00097500	call	97.5000	2026-10-16	2.3000	2.2500	2.3500	95.8900	52670.00	29670.00	23000.00	229	32	2642	5235	0.504680038204394	0.237035645725639	0.237786667434064	false	false	false	true
21f1a07f-03ee-4600-88e6-48feb19e5895	2026-09-10 11:34	2026-09-10 11:34	2026-09-10 11:34	SHEL	SHEL261016C00097500	call	97.5000	2026-10-16	2.3000	2.3000	2.3500	95.9100	69000.00	0.00	69000.00	300	32	2413	5235	0.460936007640879	0.237035645725639	0.237035645725639	false	false	false	true
ba8aa5fa-1d1f-4499-8f90-847e15ab9d95	2026-09-10 11:34	2026-09-10 11:34	2026-09-10 11:34	SHEL	SHEL261016C00097500	call	97.5000	2026-10-16	2.3000	2.2500	2.3500	95.8800	76590.00	64630.00	0.00	333	32	2113	5235	0.403629417382999	0.238536641896744	0.23816178495888	false	false	false	true
7e69f481-badb-4ef4-a1ab-17b8365f9156	2026-09-10 11:31	2026-09-10 11:31	2026-09-10 11:31	SHEL	SHEL261016C00097500	call	97.5000	2026-10-16	2.3000	2.2500	2.3500	95.8200	58420.00	9430.00	1840.00	254	12	1018	5235	0.194460362941738	0.240407059961409	0.240407059961409	true	false	false	true
f03cce99-d686-48a3-a1be-383aa8e73f65	2026-09-10 09:40	2026-09-10 09:40	2026-09-10 09:40	SHEL	SHEL270115C00100000	call	100.0000	2027-01-15	4.3000	4.1000	4.3000	96.4800	212420.00	212420.00	0.00	494	22	494	2682	0.184190902311708	0.231026737237355	0.231026737237355	false	false	false	true
7009f22a-8614-4e7f-8db2-5b84ed3690aa	2026-09-08 10:53	2026-09-08 10:53	2026-09-08 10:53	SHEL	SHEL260911C00095000	call	95.0000	2026-09-11	1.1000	1.0500	1.4000	95.3950	72491.00	5500.00	66991.00	659	37	2384	2358	1.01102629346904	0.2505208899648	0.253113054526583	false	false	false	true
ad8f934b-0194-4e99-9175-fc91e2163c4b	2026-09-08 10:52	2026-09-08 10:52	2026-09-08 10:52	SHEL	SHEL260911C00095000	call	95.0000	2026-09-11	1.1500	1.0500	1.1500	95.4600	98670.00	98670.00	0.00	858	6	1650	2358	0.699745547073791	0.256632805692479	0.256632805692479	false	false	false	true
77379f2d-6b0b-4d64-b3c5-cb8c9611f3b2	2026-09-08 10:27	2026-09-08 10:27	2026-09-08 10:27	SHEL	SHEL261218C00100000	call	100.0000	2026-12-18	3.1000	3.0000	3.1000	95.5699	72850.00	72850.00	0.00	235	30	237	2559	0.0926143024618992	0.224266000603218	0.224266000603218	false	false	false	true
078e30b5-b3d8-470d-8f2a-8ef55254ae78	2026-09-08 09:42	2026-09-08 09:41	2026-09-08 09:41	SHEL	SHEL260918C00094000	call	94.0000	2026-09-18	2.5000	2.3000	2.6500	95.6000	55500.00	22500.00	30750.00	222	19	239	1250	0.1912	0.242320924498526	0.239920763797655	true	false	false	true
82cfe87c-4a72-4bf6-badc-cdd98139dc3f	2026-09-04 10:09	2026-09-04 10:09	2026-09-04 10:09	SHEL	SHEL270617P00097500	put	97.5000	2027-06-17	10.0400	10.0000	10.3000	92.5650	50197.00	0.00	50197.00	50	5	50	44	1.13636363636364	0.275958884717554	0.275958884717554	false	false	false	true
4b72d47a-9daf-4c79-8a09-0ab048756b6a	2026-09-01 12:36	2026-09-01 12:36	2026-09-01 12:36	SHEL	SHEL261016P00095000	put	95.0000	2026-10-16	3.7000	3.5000	3.7000	93.3700	177220.00	177220.00	0.00	479	33	750	310	2.41935483870968	0.234193774459216	0.233775253282353	false	false	false	true
bcd67579-08ef-4f73-91a7-9e9a401dfc2d	2026-09-01 11:39	2026-09-01 11:39	2026-09-01 11:39	SHEL	SHEL270917C00105000	call	105.0000	2027-09-17	5.1200	5.1000	5.4000	93.0800	51184.00	0.00	51184.00	100	14	120	0	0	0.218171505130103	0.215988638523195	false	false	false	true
839826db-aa10-4bb8-b87c-dda28c5b0b4d	2026-09-01 10:25	2026-09-01 10:25	2026-09-01 10:25	SHEL	SHEL280121C00105000	call	105.0000	2028-01-21	6.5000	6.3000	6.5000	92.7400	52000.00	52000.00	0.00	80	6	90	706	0.127478753541076	0.213813769138628	0.213813769138628	false	false	false	true
6be217f5-e1c1-4df8-8c1d-70803bde51f0	2026-09-01 09:47	2026-09-01 09:47	2026-09-01 09:47	SHEL	SHEL261016P00095000	put	95.0000	2026-10-16	4.2000	4.1000	4.2000	92.5100	113814.00	113814.00	0.00	271	40	271	310	0.874193548387097	0.234782296922472	0.234782296922472	false	false	false	true
2cf9d323-4df9-45b7-b153-b654df36606a	2026-08-27 13:57	2026-08-27 13:57	2026-08-27 13:57	SHEL	SHEL261016C00092500	call	92.5000	2026-10-16	2.6000	2.5000	2.6000	91.0500	98800.00	98800.00	0.00	380	13	419	1065	0.393427230046948	0.226507003404496	0.226507003404496	false	false	false	true
cce7afeb-a4e8-420e-b069-fb1d6aa1dcc5	2026-08-27 12:24	2026-08-27 12:24	2026-08-27 12:24	SHEL	SHEL261218C00092500	call	92.5000	2026-12-18	4.0000	3.9000	4.0000	90.5000	149580.00	149580.00	0.00	374	32	380	441	0.861678004535147	0.219742402243126	0.219742402243126	false	false	false	true
c2f8fbc8-859a-4760-9a5c-b620d369a876	2026-08-25 14:44	2026-08-25 14:43	2026-08-25 14:43	SHEL	SHEL260918C00092500	call	92.5000	2026-09-18	2.2500	2.2000	2.3500	92.5950	141075.00	0.00	141075.00	627	45	642	1681	0.381915526472338	0.220356783508992	0.220356783508992	false	false	false	true
b17b4112-db56-4f1a-aa83-6652f6ac8a92	2026-08-25 12:40	2026-08-25 12:39	2026-08-25 12:39	SHEL	SHEL261016C00092500	call	92.5000	2026-10-16	3.4000	3.4000	3.5000	92.3600	259100.00	0.00	259100.00	762	36	858	827	1.03748488512696	0.231846225831165	0.231846225831165	false	false	false	true
8c95c1b6-2f67-4cbf-ad37-9d3d99cdb1be	2026-08-21 11:15	2026-08-21 11:14	2026-08-21 11:14	SHEL	SHEL261218P00092500	put	92.5000	2026-12-18	4.5000	4.4500	4.6000	93.2700	331200.00	3150.00	328050.00	736	30	736	450	1.63555555555556	0.257615316983121	0.257615316983121	false	false	false	true
f7ecf0d7-43c8-4f24-a9a0-b62e6d1883b2	2026-08-20 13:29	2026-08-20 13:29	2026-08-20 13:29	SHEL	SHEL261016C00100000	call	100.0000	2026-10-16	1.5000	1.4500	1.5500	93.9800	67960.00	0.00	67810.00	453	24	697	1002	0.69560878243513	0.234836241126662	0.234836241126662	false	false	false	true
c5b18f44-2692-4a9d-bd45-54d8cdd1a56f	2026-08-20 12:14	2026-08-20 12:14	2026-08-20 12:14	SHEL	SHEL261218P00087500	put	87.5000	2026-12-18	2.3500	2.3000	2.4000	94.1550	115855.00	0.00	111860.00	493	23	501	1279	0.391712275215012	0.260037021031939	0.260037021031939	false	false	false	true
c96cf74f-8c28-4728-8151-c76be7cb8296	2026-08-20 12:01	2026-08-20 12:01	2026-08-20 12:01	SHEL	SHEL261218C00100000	call	100.0000	2026-12-18	3.3000	3.2000	3.3000	94.3500	107250.00	107250.00	0.00	325	18	869	1061	0.819038642789821	0.235692956965014	0.235692956965014	true	false	false	true
060cd411-9afb-4b25-ad3a-43b3fa0053b4	2026-08-20 10:05	2026-08-20 10:05	2026-08-20 10:05	SHEL	SHEL260821C00094000	call	94.0000	2026-08-21	0.8000	0.7500	0.8500	94.4550	70560.00	70480.00	80.00	882	14	3950	10730	0.368126747437092	0.274089803068233	0.272373143847456	true	false	false	true