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:er_time = unknown×ticker = OKE×

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

d0c71464-e750-4224-b508-86a1d84d1220	2026-09-24 15:12	2026-09-24 15:12	2026-09-24 15:12	OKE	OKE261120C00095000	call	95.0000	2026-11-20	2.4500	2.3000	2.6000	90.9800	53155.00	50950.00	2205.00	217	32	391	299	1.30769230769231	0.268614193055831	0.268614193055831	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Energy	57073669650.00	2026-10-27	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-24T19:15:33.602136Z"}	2026-09-24	2026-09-24 21:15	2026-09-24 21:15
c571ab46-0af3-484b-a458-5e26c4da9cca	2026-09-24 13:51	2026-09-24 13:51	2026-09-24 13:51	OKE	OKE261218P00090000	put	90.0000	2026-12-18	4.6000	4.5000	4.6000	91.0000	78200.00	78200.00	0.00	170	5	171	393	0.435114503816794	0.319868736502599	0.319868736502599	true	false	false	true	false
c486355c-083b-4cad-9416-aac92d167681	2026-09-24 13:49	2026-09-24 13:49	2026-09-24 13:49	OKE	OKE261120C00095000	call	95.0000	2026-11-20	2.5000	2.4500	2.5000	91.0000	28750.00	28750.00	0.00	115	34	166	299	0.555183946488294	0.268168706407705	0.268168706407705	false	false	false	true	false
d3ec8b36-babb-4891-aff1-ac554fd46426	2026-09-24 13:06	2026-09-24 13:06	2026-09-24 13:06	OKE	OKE261120C00100000	call	100.0000	2026-11-20	1.1400	1.0500	1.2500	90.9500	215540.00	0.00	62590.00	1899	2	3034	561	5.40819964349376	0.269331803006452	0.269331803006452	false	true	false	true
5776178d-9f20-4ece-be65-fdb3b5e57325	2026-09-24 13:06	2026-09-24 13:06	2026-09-24 13:06	OKE	OKE261120C00100000	call	100.0000	2026-11-20	1.1400	1.0500	1.2500	90.9500	215540.00	0.00	62590.00	1899	2	3034	561	5.40819964349376	0.269331803006452	0.269331803006452	false	true	false	true
ec22f1cb-4c45-4056-a7b5-c470e3267c13	2026-09-24 13:04	2026-09-24 13:04	2026-09-24 13:04	OKE	OKE261120C00100000	call	100.0000	2026-11-20	1.1500	1.1500	1.3000	90.9600	57528.00	0.00	57528.00	500	62	568	561	1.01247771836007	0.267785843116593	0.269125738601249	false	false	false	true	false
30a596f3-2740-4e49-aa2f-c8c8eb9feca6	2026-09-23 14:59	2026-09-23 14:59	2026-09-23 14:59	OKE	OKE261016C00090000	call	90.0000	2026-10-16	2.9000	2.8000	2.9000	90.4100	16820.00	16820.00	0.00	58	10	85	1517	0.0560316413974951	0.284922910884315	0.284922910884315	false	false	false	true	false
c5f6d5e1-848f-4e83-99d2-81381c821d20	2026-09-23 12:49	2026-09-23 12:49	2026-09-23 12:49	OKE	OKE261016P00090000	put	90.0000	2026-10-16	1.8000	1.7000	1.8000	91.5750	10980.00	10980.00	0.00	61	22	167	2245	0.0743875278396437	0.28655631742682	0.28655631742682	false	false	false	true	false
6d60e86b-0863-4fc2-bd68-a34b41ff0a67	2026-09-23 11:48	2026-09-23 11:48	2026-09-23 11:48	OKE	OKE261218P00085000	put	85.0000	2026-12-18	2.5000	2.4500	2.5000	91.0000	17500.00	17500.00	0.00	70	20	104	790	0.131645569620253	0.319057313094053	0.319057313094053	false	false	false	true	false
ba9c69e2-3cd5-421f-a3be-d2dce0da91df	2026-09-22 15:16	2026-09-22 15:16	2026-09-22 15:16	OKE	OKE280121C00125000	call	125.0000	2028-01-21	3.3200	3.0000	3.3000	90.6700	14940.00	14940.00	0.00	45	9	45	219	0.205479452054795	0.260748299671882	0.259208024734804	false	false	false	true	false
ac9e7089-ea4c-406b-bf0b-90349f23a058	2026-09-22 15:16	2026-09-22 15:16	2026-09-22 15:16	OKE	OKE280121C00125000	call	125.0000	2028-01-21	3.2900	3.0000	3.3000	90.6896	18075.00	18075.00	0.00	55	5	100	219	0.45662100456621	0.258446146308653	0.258446146308653	false	false	false	true	false
5c8cea2d-41cb-4d22-9f98-14b3b7c0370b	2026-09-22 15:00	2026-09-22 15:00	2026-09-22 15:00	OKE	OKE261016P00090000	put	90.0000	2026-10-16	2.1000	1.9500	2.1000	90.8100	19740.00	19740.00	0.00	94	13	147	2166	0.0678670360110803	0.280324638653965	0.280324638653965	false	false	false	true	false
f00052d1-398d-47b2-893a-c7f2ee5bdfd0	2026-09-22 11:24	2026-09-22 11:23	2026-09-22 11:23	OKE	OKE270115P00090000	put	90.0000	2027-01-15	4.6000	4.4000	4.6000	92.0000	50140.00	50140.00	0.00	109	20	109	497	0.219315895372233	0.3125059924721	0.3125059924721	false	false	false	true	false
1916d861-47c8-407d-b754-c4419cf1a4ba	2026-09-22 11:11	2026-09-22 11:11	2026-09-22 11:11	OKE	OKE280121P00100000	put	100.0000	2028-01-21	16.2000	15.6000	16.3000	92.6100	77760.00	74520.00	3240.00	48	24	105	25	4.2	0.365409932256568	0.365409932256568	false	false	false	true	false
63a024e4-9a7a-4323-91d8-01089b8162a6	2026-09-22 10:51	2026-09-22 10:51	2026-09-22 10:51	OKE	OKE280121P00100000	put	100.0000	2028-01-21	16.4000	15.8000	16.4000	92.4000	19680.00	19680.00	0.00	12	9	29	25	1.16	0.368028528745458	0.368028528745458	false	false	false	true	false
e75a2ab9-0773-4e97-8e7b-1160c7759376	2026-09-21 14:52	2026-09-21 14:52	2026-09-21 14:52	OKE	OKE261016C00095000	call	95.0000	2026-10-16	1.6500	1.6500	1.7500	92.3900	57090.00	0.00	57090.00	346	38	538	4370	0.123112128146453	0.272601864043932	0.272601864043932	true	false	false	true
aa1d9b01-285e-41af-b19a-736a78307374	2026-09-14 15:04	2026-09-14 15:04	2026-09-14 15:04	OKE	OKE260918C00085000	call	85.0000	2026-09-18	11.1000	11.1000	12.1000	96.4100	101022.00	0.00	101022.00	91	15	104	654	0.159021406727829	1.06826503726834	0.825888032892794	false	false	false	true
fd7f2101-b2fb-45e0-8512-0eee922c5ef5	2026-09-02 14:54	2026-09-02 14:54	2026-09-02 14:54	OKE	OKE270319P00095000	put	95.0000	2027-03-19	7.1000	7.1000	7.6000	96.2733	83093.00	720.00	82373.00	117	9	117	40	2.925	0.313664291738634	0.314031047757257	false	false	false	true	false
61362593-3b11-4e13-8510-8f9bb6c73780	2026-09-02 14:54	2026-09-02 14:54	2026-09-02 14:54	OKE	OKE270319P00100000	put	100.0000	2027-03-19	9.8000	9.8000	10.3000	96.2733	142100.00	0.00	142100.00	145	6	145	11	13.1818181818182	0.31779348447584	0.31779348447584	false	false	false	true	false
36529f4b-f86b-4fa1-a0c7-8e4801f58277	2026-09-01 10:27	2026-09-01 10:27	2026-09-01 10:27	OKE	OKE270416C00110000	call	110.0000	2027-04-16	3.4000	3.4000	4.0000	95.5200	57496.00	0.00	57496.00	169	10	179	0	0	0.252346179214053	0.252723039211554	false	false	false	true	false
f59bbd06-e947-481c-a6aa-ea167d09a812	2026-08-26 10:36	2026-08-26 10:36	2026-08-26 10:36	OKE	OKE261016C00090000	call	90.0000	2026-10-16	6.7000	6.1000	6.8000	94.2800	95140.00	84420.00	10720.00	142	17	194	1299	0.149345650500385	0.282212222874582	0.282212222874582	false	false	false	true
0e9ff26d-41fe-40b4-9b58-f95db34b073d	2026-08-24 14:12	2026-08-24 14:12	2026-08-24 14:12	OKE	OKE261016C00100000	call	100.0000	2026-10-16	1.7000	1.7000	1.8000	93.5400	186490.00	0.00	186490.00	1097	23	1299	2215	0.586455981941309	0.271221274845688	0.271221274845688	false	false	false	true
d165175c-a147-4571-97bf-d6bc75a25950	2026-08-21 13:43	2026-08-21 13:42	2026-08-21 13:42	OKE	OKE261218C00100000	call	100.0000	2026-12-18	3.5000	3.3000	3.5000	93.5700	361522.00	361522.00	0.00	1033	61	1092	1394	0.783357245337159	0.261361351693982	0.261361351693982	false	false	false	true
c63c5677-792b-48a2-96ae-767bdff42101	2026-08-20 13:34	2026-08-20 13:34	2026-08-20 13:34	OKE	OKE270416C00090000	call	90.0000	2027-04-16	10.7000	10.7000	13.2000	94.6910	108070.00	0.00	108070.00	101	7	101	0	0	0.224867044416452	0.224867044416452	false	false	false	true	false
9e4f82a7-a9d1-4e30-b973-2c4725b036e1	2026-08-20 13:30	2026-08-20 13:30	2026-08-20 13:30	OKE	OKE260918C00095000	call	95.0000	2026-09-18	2.8500	2.8500	2.9500	94.8000	51079.00	0.00	51079.00	179	6	427	3424	0.124707943925234	0.267315605656218	0.267315605656218	false	false	false	true
c5816570-d2e6-4529-b150-4b5c3ff023fe	2026-08-17 15:32	2026-08-17 15:32	2026-08-17 15:32	OKE	OKE260918C00085000	call	85.0000	2026-09-18	11.1000	10.5000	11.1000	95.1100	72131.00	72131.00	0.00	65	6	68	780	0.0871794871794872	0.36273294271015	0.36273294271015	false	false	false	true	false
a78bc3f6-4803-48ee-ba1b-d28f4f185032	2026-08-17 13:13	2026-08-17 13:13	2026-08-17 13:13	OKE	OKE270115C00092500	call	92.5000	2027-01-15	8.0000	7.6000	8.6000	94.7600	68000.00	0.00	52000.00	85	5	100	454	0.220264317180617	0.249191395764203	0.249191395764203	false	false	false	true	false