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×ticker = DVN×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	price

2967dbb8-8286-418b-8cb1-811c5f30cb98	2026-08-14 15:59	2026-08-14 15:59	2026-08-14 15:59	DVN	DVN261016C00052500	call	52.5000	2026-10-16	0.6600	0.6600	0.6600	45.8650	14454.00	0.00	0.00	219	5	298	1316	0.22644376899696	0.336031305104053	0.336031305104053	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Energy	54703000000.00	2026-11-04	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-17T13:32:33.788843Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
04a25731-3e93-4dc6-9ab9-fd2734bdd739	2026-08-17 11:43	2026-08-17 11:43	2026-08-17 11:43	DVN	DVN260918C00045000	call	45.0000	2026-09-18	2.7000	2.5300	2.7000	46.5650	108000.00	108000.00	0.00	400	5	476	6832	0.069672131147541	0.316343643765728	0.316343643765728	false	false	false	true
870a24a5-7904-4848-9d86-39328a5f0ddd	2026-08-18 11:06	2026-08-18 11:06	2026-08-18 11:06	DVN	DVN260904C00049000	call	49.0000	2026-09-04	1.0700	0.9600	1.2500	47.9700	280126.00	273278.00	6848.00	2618	58	2627	143	18.3706293706294	0.358466945825393	0.358466945825393	false	false	false	true
a627dfad-0494-4c7b-9958-b3ea6ea0b750	2026-08-19 13:46	2026-08-19 13:46	2026-08-19 13:46	DVN	DVN261016P00047500	put	47.5000	2026-10-16	2.0100	2.0100	2.0600	48.5800	125826.00	0.00	125826.00	626	55	702	389	1.80462724935733	0.346568938141407	0.346568938141407	false	false	false	true
6ebd34af-6790-41ff-a624-cf23426d8065	2026-08-20 10:54	2026-08-20 10:54	2026-08-20 10:54	DVN	DVN260918C00050000	call	50.0000	2026-09-18	1.6100	1.5500	1.6200	49.4600	71324.00	71163.00	161.00	443	25	731	9819	0.0744474997453916	0.322639129478132	0.324003637178315	true	false	false	true
9722fa52-6c39-4176-952f-bcd2ee19fba1	2026-08-20 11:01	2026-08-20 11:00	2026-08-20 11:00	DVN	DVN261016P00050000	put	50.0000	2026-10-16	2.9000	2.8400	2.9400	49.5000	87000.00	65250.00	21750.00	300	17	384	1012	0.379446640316206	0.357995392144755	0.357995392144755	false	false	false	true
2d99412f-0a9e-4801-92e6-f5813d6a2433	2026-08-20 12:24	2026-08-20 12:23	2026-08-20 12:23	DVN	DVN261218C00052500	call	52.5000	2026-12-18	2.7700	2.7700	2.8500	49.3400	68142.00	0.00	68142.00	246	27	257	711	0.361462728551336	0.336816656048332	0.336816656048332	false	false	false	true
bf712079-2926-4025-9b42-fe1bc91cf461	2026-08-20 12:34	2026-08-20 12:34	2026-08-20 12:34	DVN	DVN270617C00050000	call	50.0000	2027-06-17	6.2000	6.2000	6.5500	49.1900	221960.00	0.00	221960.00	358	34	366	4566	0.0801576872536137	0.328199160794553	0.328532282171561	false	false	false	true
0aa93a7e-1c34-4fa4-86cf-32ce8b688822	2026-08-20 12:40	2026-08-20 12:40	2026-08-20 12:40	DVN	DVN260904C00044000	call	44.0000	2026-09-04	5.3000	5.1000	5.6500	49.1150	53000.00	42930.00	10070.00	100	6	101	280	0.360714285714286	0.379185051720139	0.379185051720139	true	false	false	true
7ca5a352-a9a0-497a-b073-21ce8914cf59	2026-08-24 12:06	2026-08-24 12:06	2026-08-24 12:06	DVN	DVN260918C00045000	call	45.0000	2026-09-18	3.2500	3.2500	3.7000	47.6905	65000.00	0.00	65000.00	200	5	230	6161	0.0373316020126603	0.295718039125941	0.295718039125941	false	false	false	true
3a7df6c8-2071-4779-9cdc-a544fc5e0b44	2026-08-25 13:04	2026-08-25 13:04	2026-08-25 13:04	DVN	DVN261016P00045000	put	45.0000	2026-10-16	1.4700	1.4100	1.4800	47.1700	84196.00	79086.00	5110.00	573	59	662	2003	0.330504243634548	0.360545529981316	0.360545529981316	false	false	false	true
2b7aaf62-a08b-4a1c-b51d-77aea6189854	2026-08-26 09:51	2026-08-26 09:51	2026-08-26 09:51	DVN	DVN270917P00052500	put	52.5000	2027-09-17	9.6500	9.6000	10.3500	47.0700	60795.00	0.00	56935.00	63	21	63	0	0	0.40083986987126	0.401835879256782	true	false	false	true	false
27c9dbab-752c-481e-bc83-483353141cab	2026-08-26 10:13	2026-08-26 10:13	2026-08-26 10:13	DVN	DVN260918C00047500	call	47.5000	2026-09-18	1.4300	1.2600	1.4700	47.1200	222792.00	221362.00	1430.00	1561	48	2328	49299	0.047222053185663	0.328931622112989	0.329694416456562	true	false	false	true
0df6ef6e-2605-418c-b8eb-651b4267bac5	2026-08-26 10:16	2026-08-26 10:16	2026-08-26 10:16	DVN	DVN270917P00052500	put	52.5000	2027-09-17	9.5500	9.5000	10.3500	47.2800	96455.00	2865.00	93590.00	101	21	164	0	0	0.401855099649207	0.401855099649207	true	false	false	true
2646ff8d-b9b2-476b-a713-094d7c5ae3aa	2026-08-26 12:32	2026-08-26 12:32	2026-08-26 12:32	DVN	DVN261016P00047500	put	47.5000	2026-10-16	2.4900	2.4700	2.5700	47.3000	83664.00	0.00	83664.00	336	31	338	1034	0.326885880077369	0.357112767917364	0.357112767917364	false	false	false	true
5034aca2-9e70-42cb-b0fc-f202622f89b8	2026-08-26 12:57	2026-08-26 12:56	2026-08-26 12:56	DVN	DVN260918P00047000	put	47.0000	2026-09-18	1.6200	1.5500	1.6300	47.1000	80190.00	59940.00	20250.00	495	6	657	40	16.425	0.369884467297809	0.366451558883287	false	false	false	true
83fb6214-3011-4ecb-b7dd-c0ec9a210cd2	2026-08-27 10:08	2026-08-27 10:08	2026-08-27 10:08	DVN	DVN261016C00047500	call	47.5000	2026-10-16	1.8800	1.8000	1.8800	46.5100	112210.00	106596.00	4862.00	597	57	603	8691	0.0693821194338971	0.32263598584533	0.32263598584533	false	false	false	true
028e92f0-1ce8-4fca-abc3-c75b33a845c3	2026-08-27 12:00	2026-08-27 12:00	2026-08-27 12:00	DVN	DVN281215C00050000	call	50.0000	2028-12-15	8.5000	8.5000	8.9500	46.5450	85000.00	0.00	85000.00	100	8	100	405	0.246913580246914	0.286519605162876	0.286519605162876	false	false	false	true
f9d7ff00-5b77-4ba5-afbf-2b2a1affef6e	2026-08-27 14:05	2026-08-27 14:05	2026-08-27 14:05	DVN	DVN260918C00047500	call	47.5000	2026-09-18	1.3500	1.2600	1.3800	47.1600	211288.00	211288.00	0.00	1562	71	1662	59561	0.0279041654774097	0.311606079928086	0.320317717017777	true	false	false	true
3a155936-d105-4217-bf30-f0055764f83f	2026-08-27 14:06	2026-08-27 14:06	2026-08-27 14:06	DVN	DVN260918C00047000	call	47.0000	2026-09-18	1.6300	1.5200	1.6300	47.1800	63244.00	63244.00	0.00	388	41	1437	406	3.53940886699507	0.321733380388907	0.321733380388907	false	false	false	true
aa8ad513-a643-476b-8781-919589f392ae	2026-08-27 15:28	2026-08-27 15:28	2026-08-27 15:28	DVN	DVN261016C00050000	call	50.0000	2026-10-16	1.2500	1.2200	1.2500	47.0000	52125.00	52125.00	0.00	417	26	644	3972	0.162134944612286	0.326306798087379	0.325495535037991	false	false	false	true
a2e654fd-3c8c-48d9-a6c1-7b66ba349c03	2026-08-28 15:15	2026-08-28 15:14	2026-08-28 15:14	DVN	DVN261016C00047500	call	47.5000	2026-10-16	2.0700	2.0600	2.1500	47.1700	64585.00	0.00	64377.00	312	42	410	8553	0.0479363965859932	0.30641399379199	0.30641399379199	false	false	false	true
8089c31b-6d25-4bde-99d5-66e9d155cc09	2026-08-28 15:57	2026-08-28 15:57	2026-08-28 15:57	DVN	DVN261016C00050000	call	50.0000	2026-10-16	1.2600	1.2100	1.2600	47.3950	90216.00	90216.00	0.00	716	28	853	4408	0.193511796733212	0.315997187383347	0.315997187383347	false	false	false	true
1444d410-f417-44f0-9f2e-b9f05ab15dc5	2026-09-02 15:32	2026-09-02 15:32	2026-09-02 15:32	DVN	DVN261016P00047500	put	47.5000	2026-10-16	1.4800	1.4700	1.5500	49.2294	96940.00	148.00	96792.00	655	12	714	1392	0.512931034482759	0.347313391601822	0.348380087304275	false	false	false	true
7d176693-7b0a-44b2-b36b-7eb8bec82d10	2026-09-04 09:51	2026-09-04 09:51	2026-09-04 09:51	DVN	DVN260918C00047500	call	47.5000	2026-09-18	1.2000	1.1100	1.3800	47.6350	2544000.00	0.00	2544000.00	21200	1	21223	61802	0.343403126112424	0.294776572365695	0.294776572365695	false	true	false	true
cc3b3cbb-f5e7-41df-a6f5-b56135043b12	2026-09-04 12:40	2026-09-04 12:39	2026-09-04 12:39	DVN	DVN260925C00047000	call	47.0000	2026-09-25	2.0600	1.9700	2.0600	48.2200	125042.00	125042.00	0.00	607	22	631	535	1.17943925233645	0.283940422199741	0.283940422199741	false	false	false	true
efb04572-3d36-4a9f-ac9e-90c04979c993	2026-09-11 12:25	2026-09-11 12:24	2026-09-11 12:24	DVN	DVN270115C00057500	call	57.5000	2027-01-15	1.6200	1.6100	1.6600	49.9199	69826.00	16686.00	53140.00	431	13	772	6016	0.128324468085106	0.335926245483459	0.336922238218456	false	false	false	true
33a17273-a897-4342-9506-c6fa9e9cc512	2026-09-11 13:12	2026-09-11 13:12	2026-09-11 13:12	DVN	DVN261016C00045000	call	45.0000	2026-10-16	5.1000	5.0000	5.4000	49.7000	52020.00	41310.00	10710.00	102	6	166	9638	0.0172234903506952	0.274407485219083	0.277594605693864	false	false	false	true
11c0729d-bdc1-4a2c-86be-9742d52e874c	2026-09-11 14:40	2026-09-11 14:40	2026-09-11 14:40	DVN	DVN261016P00047500	put	47.5000	2026-10-16	1.1300	1.1000	1.1600	49.8600	151985.00	151872.00	113.00	1345	25	1428	2564	0.556942277691108	0.361479020407111	0.361479020407111	false	false	false	true
0fa8838a-6d4f-467f-880d-a228e77fc7d3	2026-09-15 09:34	2026-09-15 09:34	2026-09-15 09:34	DVN	DVN260918P00051000	put	51.0000	2026-09-18	1.1100	1.1100	1.7600	50.4401	91798.00	0.00	91686.00	827	18	827	10	82.7	0.441357257224164	0.447007102493788	false	false	false	true
150c1bd6-71d7-47ee-8e59-d9a4b7e70b92	2026-09-15 09:45	2026-09-15 09:45	2026-09-15 09:45	DVN	DVN261002C00053000	call	53.0000	2026-10-02	0.6800	0.6300	0.9100	50.6000	67668.00	0.00	67668.00	1000	8	1001	1931	0.51838425686173	0.368393384892151	0.368393384892151	false	false	false	true
730200a0-5bdc-4112-a15d-02721ece90a7	2026-09-15 14:39	2026-09-15 14:39	2026-09-15 14:39	DVN	DVN261218P00052500	put	52.5000	2026-12-18	4.2500	4.2500	4.3000	51.3050	249050.00	0.00	249050.00	586	9	589	122	4.82786885245902	0.376180265106746	0.376180265106746	false	false	false	true
d9cccb1c-a037-4644-8bf4-222552e1c2a5	2026-09-16 15:59	2026-09-16 15:59	2026-09-16 15:59	DVN	DVN261016C00050000	call	50.0000	2026-10-16	1.4500	1.3500	1.4700	48.0000	349764.00	346164.00	3600.00	2414	90	5197	6163	0.843258153496674	0.366428702438808	0.372671162845753	true	false	false	true
a4cfe865-d993-4663-8165-a3ee0a799251	2026-09-17 09:45	2026-09-17 09:45	2026-09-17 09:45	DVN	DVN261016C00052500	call	52.5000	2026-10-16	0.6900	0.6900	0.7500	48.3150	243984.00	0.00	243984.00	3536	64	3558	6555	0.54279176201373	0.372615442400116	0.375172830883515	false	false	false	true
017986c7-5bf1-426b-810a-ba6d7791338e	2026-09-21 10:38	2026-09-21 10:38	2026-09-21 10:38	DVN	DVN260925C00047500	call	47.5000	2026-09-25	0.8300	0.8300	0.9300	47.5200	16600.00	0.00	16600.00	200	6	703	9	78.1111111111111	0.408102602043627	0.408102602043627	false	false	false	true
251306bc-cb06-4e31-8ba5-ea8bab6606e8	2026-09-21 11:13	2026-09-21 11:13	2026-09-21 11:13	DVN	DVN261016C00047500	call	47.5000	2026-10-16	1.7200	1.6300	1.7300	47.2500	11840.00	11840.00	0.00	69	6	297	8634	0.0343988881167477	0.358430018492131	0.360457468077883	false	false	false	true
ae901486-a340-40a8-aea7-f9600a7f6e45	2026-09-21 11:14	2026-09-21 11:14	2026-09-21 11:14	DVN	DVN261016C00047500	call	47.5000	2026-10-16	1.7000	1.6300	1.7200	47.2300	16662.00	16662.00	0.00	98	5	516	8634	0.0597637248088951	0.358458139017624	0.358458139017624	false	false	false	true
a670b87d-a621-4ad3-a22a-b5b5278a533b	2026-09-21 11:15	2026-09-21 11:15	2026-09-21 11:15	DVN	DVN261016C00047500	call	47.5000	2026-10-16	1.7100	1.6400	1.7100	47.2400	15374.00	15374.00	0.00	90	6	606	8634	0.0701876302988186	0.357431097930122	0.357431097930122	false	false	false	true
598bc770-55cd-456a-94f7-00e449192b72	2026-09-21 11:21	2026-09-21 11:21	2026-09-21 11:21	DVN	DVN261016C00047500	call	47.5000	2026-10-16	1.7300	1.6400	1.7300	47.2650	16423.00	16423.00	0.00	95	8	720	8634	0.0833912439193885	0.358910888728103	0.358910888728103	false	false	false	true
74d1e88b-e1ac-460d-a61d-f79038cb673e	2026-09-21 11:54	2026-09-21 11:54	2026-09-21 11:54	DVN	DVN261120C00050000	call	50.0000	2026-11-20	1.8800	1.8100	1.8800	47.2900	18769.00	18769.00	0.00	100	17	6615	18914	0.349740932642487	0.371857924807577	0.372125123105196	false	false	false	true
1fad091d-0fce-435d-99b7-8ae9a2548655	2026-09-21 12:20	2026-09-21 12:20	2026-09-21 12:20	DVN	DVN261120C00050000	call	50.0000	2026-11-20	1.8100	1.7600	1.8100	47.0000	18070.00	18070.00	0.00	100	22	6816	18914	0.360367981389447	0.370954194913924	0.372317137253055	false	false	false	true
13d9e035-181d-4d49-8fc3-1d60cf4d7fd6	2026-09-21 13:24	2026-09-21 13:24	2026-09-21 13:24	DVN	DVN261120C00050000	call	50.0000	2026-11-20	1.8400	1.7800	1.8400	47.0000	18372.00	18372.00	0.00	100	26	6920	18914	0.365866553875436	0.369142231299499	0.370497094256356	false	false	false	true
afc2ebd5-0ce2-44b0-b114-0aa9b8431170	2026-09-21 13:25	2026-09-21 13:24	2026-09-21 13:24	DVN	DVN261120C00050000	call	50.0000	2026-11-20	1.8500	1.7800	1.8500	47.2300	18463.00	18463.00	0.00	100	18	7020	18914	0.371153642804272	0.369959079291982	0.371312838604245	false	false	false	true
2bf70bc3-35b9-47ff-8f4e-ebb53f55cf2d	2026-09-21 13:25	2026-09-21 13:25	2026-09-21 13:25	DVN	DVN261120C00050000	call	50.0000	2026-11-20	1.8400	1.7800	1.8500	47.2300	19157.00	18973.00	0.00	104	14	7124	18914	0.376652215290261	0.369959079291982	0.369959079291982	false	false	false	true
6dd883eb-5d41-4466-b05d-0f0ee91b41a5	2026-09-21 13:26	2026-09-21 13:26	2026-09-21 13:26	DVN	DVN261120C00050000	call	50.0000	2026-11-20	1.8900	1.8700	1.9000	47.2850	16632.00	3402.00	10584.00	88	5	7408	18914	0.391667547848155	0.373744515012452	0.373744515012452	false	false	false	true
b4a2baa3-830e-4a1d-a584-14b75b45adac	2026-09-21 13:26	2026-09-21 13:26	2026-09-21 13:26	DVN	DVN261120C00050000	call	50.0000	2026-11-20	1.8900	1.8600	1.9000	47.2962	10962.00	8694.00	0.00	58	12	7466	18914	0.39473405942688	0.373137303606149	0.373137303606149	false	false	false	true
8221c97e-2801-4c99-937d-55646acd0938	2026-09-21 14:56	2026-09-21 14:56	2026-09-21 14:56	DVN	DVN261016C00055000	call	55.0000	2026-10-16	0.1600	0.1500	0.1900	47.6800	29072.00	16.00	29040.00	1817	62	2067	3400	0.607941176470588	0.368114986420279	0.368114986420279	false	false	false	true
a0924218-684f-4efe-8f91-d6f155bf3f79	2026-09-21 14:56	2026-09-21 14:56	2026-09-21 14:56	DVN	DVN261016C00055000	call	55.0000	2026-10-16	0.1500	0.1500	0.1600	47.6800	146610.00	0.00	146610.00	9774	9	11845	3400	3.48382352941176	0.362630206215553	0.362630206215553	false	false	false	true