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:endpoint = /api/option-trades/flow-alerts×ticker = DVN×

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

59ab56c6-e99d-4d03-bce2-ff22733a7dc4	2026-09-25 13:00	2026-09-25 13:00	2026-09-25 13:00	DVN	DVN261002P00047500	put	47.5000	2026-10-02	1.0000	0.9400	1.0500	47.2850	20000.00	13600.00	6400.00	200	8	493	125	3.944	0.346942468788982	0.346942468788982	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Energy	51755000000.00	2026-11-04	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-25T17:04:49.737352Z"}	2026-09-25	2026-09-25 21:15	2026-09-25 21:15
ec1763a5-967e-422a-a56f-343361faea51	2026-09-25 12:59	2026-09-25 12:59	2026-09-25 12:59	DVN	DVN261002P00047500	put	47.5000	2026-10-02	1.0000	0.9400	1.0600	47.2800	20000.00	17900.00	2100.00	200	5	293	125	2.344	0.345941420345124	0.345941420345124	false	false	false	true
72fb456f-96fb-45c4-acc2-871387079b22	2026-09-25 12:37	2026-09-25 12:37	2026-09-25 12:37	DVN	DVN281215C00060000	call	60.0000	2028-12-15	6.4000	5.1500	7.6000	47.2300	17920.00	640.00	17280.00	28	5	28	760	0.0368421052631579	0.313716505494815	0.313716505494815	false	false	false	true
b97000f5-f12a-4b66-9c5b-449393cb56b3	2026-09-25 10:44	2026-09-25 10:44	2026-09-25 10:44	DVN	DVN261016C00048500	call	48.5000	2026-10-16	1.3300	1.2900	1.3900	47.6800	23142.00	14364.00	8778.00	174	7	185	392	0.471938775510204	0.36129587994418	0.36129587994418	true	false	false	true
372ca665-7cd3-446e-b221-0be59e6bf332	2026-09-25 10:33	2026-09-25 10:33	2026-09-25 10:33	DVN	DVN261120P00047500	put	47.5000	2026-11-20	2.5700	2.5700	2.6600	47.5900	10286.00	0.00	10286.00	40	7	40	9502	0.00420964007577352	0.377401427082557	0.373333078629836	false	false	false	true
4e656405-07a9-4c80-be26-53cbcfdbdf69	2026-09-24 14:59	2026-09-24 14:59	2026-09-24 14:59	DVN	DVN261016C00048000	call	48.0000	2026-10-16	2.0500	1.9000	2.1300	48.4450	61500.00	61500.00	0.00	300	6	625	35	17.8571428571429	0.372294368036087	0.372294368036087	false	false	false	true
e9adb53a-4866-4eac-8a15-3eb5e72aba06	2026-09-24 14:54	2026-09-24 14:54	2026-09-24 14:54	DVN	DVN261016C00048000	call	48.0000	2026-10-16	2.1400	2.0200	2.2000	48.5750	42800.00	7918.00	21828.00	200	7	325	35	9.28571428571429	0.375581921892346	0.375581921892346	false	false	false	true
e8e63b05-024b-45fe-85bb-3b37b4f1dcce	2026-09-24 14:53	2026-09-24 14:53	2026-09-24 14:53	DVN	DVN261016C00048000	call	48.0000	2026-10-16	2.1800	1.9800	2.3400	48.6099	22622.00	17360.00	862.00	104	14	125	35	3.57142857142857	0.384105206082869	0.375520222191701	true	false	false	true
795af004-cb03-4d04-98f5-4c3fb2b306da	2026-09-24 14:51	2026-09-24 14:51	2026-09-24 14:51	DVN	DVN261002C00050000	call	50.0000	2026-10-02	0.5700	0.5100	0.6200	48.0000	50331.00	47367.00	2964.00	883	5	2662	743	3.58277254374159	0.399206210415999	0.399206210415999	true	false	false	true
c37a8e81-ac43-4438-bf87-165500a056ce	2026-09-24 13:58	2026-09-24 13:58	2026-09-24 13:58	DVN	DVN270115C00055000	call	55.0000	2027-01-15	2.0500	2.0500	2.1600	49.4550	41000.00	0.00	35055.00	200	5	342	8620	0.0396751740139211	0.348809943531187	0.348809943531187	false	false	false	true
c7c8c09b-cae7-4f6e-8026-41a2ed28e6e6	2026-09-24 13:55	2026-09-24 13:55	2026-09-24 13:55	DVN	DVN261002C00050000	call	50.0000	2026-10-02	0.8400	0.7700	0.8900	49.2692	63168.00	45360.00	17808.00	752	9	1572	743	2.1157469717362	0.392884569822039	0.392884569822039	true	false	false	true
69587dd1-52f0-48e6-811e-3ce2e576c532	2026-09-24 13:51	2026-09-24 13:51	2026-09-24 13:51	DVN	DVN261002C00050000	call	50.0000	2026-10-02	0.8800	0.7500	0.8800	49.0000	44170.00	44170.00	0.00	502	19	571	743	0.768506056527591	0.39260089966029	0.403106504783924	false	false	false	true
2f1188c5-08e2-4e4f-a56d-ce2792e0e0d0	2026-09-24 13:39	2026-09-24 13:39	2026-09-24 13:39	DVN	DVN261120C00050000	call	50.0000	2026-11-20	2.7200	2.6100	2.7300	49.2500	18224.00	18224.00	0.00	67	11	354	26189	0.0135171255107106	0.376120216663125	0.376120216663125	true	false	false	true
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
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
fb7684c6-255d-43b6-96c5-cae0ac4cb37b	2026-09-23 12:46	2026-09-23 12:46	2026-09-23 12:46	DVN	DVN261002P00048000	put	48.0000	2026-10-02	0.8700	0.7500	1.0000	48.5150	12354.00	12006.00	348.00	142	25	144	1085	0.132718894009217	0.380512057214489	0.373630764231846	false	false	false	true
74e54e9d-68c3-4aca-af15-ccd36e0c702e	2026-09-23 12:46	2026-09-23 12:46	2026-09-23 12:46	DVN	DVN261002P00049500	put	49.5000	2026-10-02	1.6800	1.5000	1.6800	48.5150	31920.00	31920.00	0.00	190	11	190	31	6.12903225806452	0.385817595530768	0.375367354512501	false	false	false	true
d1f18a0a-db22-45fc-85e9-01d8560ae37d	2026-09-23 11:24	2026-09-23 11:24	2026-09-23 11:24	DVN	DVN261009C00052000	call	52.0000	2026-10-09	0.4200	0.3700	0.4400	48.4900	29064.00	4326.00	24738.00	692	7	698	177	3.94350282485876	0.375281424261668	0.375281424261668	false	false	false	true
aaf5595b-c30a-422d-aa38-77d8f5179dde	2026-09-23 10:53	2026-09-23 10:53	2026-09-23 10:53	DVN	DVN261023C00048000	call	48.0000	2026-10-23	2.0800	2.0600	2.0800	48.1400	196352.00	196352.00	0.00	944	5	944	44	21.4545454545455	0.351433982369844	0.351433982369844	false	false	false	true
7c9b1408-e3ed-4ea0-9d3b-e8c817ce20cc	2026-09-23 10:17	2026-09-23 10:17	2026-09-23 10:17	DVN	DVN261016C00047500	call	47.5000	2026-10-16	2.3500	2.2700	2.4100	48.4600	93060.00	93060.00	0.00	396	5	491	11936	0.0411360589812332	0.366525587248723	0.366525587248723	false	false	false	true
1a88712f-ba1a-45c5-aca5-d9f17c5a5695	2026-09-23 10:03	2026-09-23 10:03	2026-09-23 10:03	DVN	DVN261120C00052500	call	52.5000	2026-11-20	1.3700	1.3700	1.5400	48.3100	49183.00	0.00	49183.00	359	24	369	1583	0.233101705622236	0.363138059361389	0.363138059361389	false	false	false	true
6d343706-fc3b-49dd-ac36-3c3908b02baf	2026-09-23 09:53	2026-09-23 09:53	2026-09-23 09:53	DVN	DVN261016C00048500	call	48.5000	2026-10-16	1.8000	1.8000	1.8700	48.3550	71640.00	0.00	71640.00	398	11	500	13	38.4615384615385	0.374209349815807	0.374209349815807	true	false	false	true
e119a52a-4548-447f-bfa8-89b4c55137e5	2026-09-23 09:53	2026-09-23 09:53	2026-09-23 09:53	DVN	DVN261016C00048500	call	48.5000	2026-10-16	1.7500	1.7500	1.8700	48.3160	17850.00	0.00	17850.00	102	7	102	13	7.84615384615385	0.368022895047238	0.368022895047238	true	false	false	true
ec9edc6b-35b6-40d3-9d33-957c0d5247e7	2026-09-22 13:57	2026-09-22 13:57	2026-09-22 13:57	DVN	DVN260925P00046500	put	46.5000	2026-09-25	0.5000	0.4200	0.5000	46.9000	33800.00	33800.00	0.00	676	25	751	476	1.57773109243697	0.407257328004685	0.407257328004685	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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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