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:alert_rule = RepeatedHits×ticker = CCJ×

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

d9dacc02-c33b-406a-9328-2c26ea0a45c5	2026-09-18 10:13	2026-09-18 10:13	2026-09-18 10:13	CCJ	CCJ261016C00100000	call	100.0000	2026-10-16	1.7500	1.7500	1.7600	91.2800	28350.00	0.00	25550.00	162	19	3348	1825	1.83452054794521	0.459089453182238	0.459089453182238	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Energy	39896659944.00	2026-11-04	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-18T14:19:45.885567Z"}	2026-09-18	2026-09-18 21:15	2026-09-18 21:15
e13cd48d-ca9d-4b21-a22e-5935f59b2f04	2026-09-18 10:13	2026-09-18 10:13	2026-09-18 10:13	CCJ	CCJ261016C00100000	call	100.0000	2026-10-16	1.7500	1.7500	1.8000	91.3300	14000.00	0.00	14000.00	80	6	3127	1825	1.71342465753425	0.454771776146733	0.457490961262437	true	false	false	true
b525a7a8-2484-4279-bbc7-7f9617248384	2026-09-18 10:12	2026-09-18 10:12	2026-09-18 10:12	CCJ	CCJ261016C00100000	call	100.0000	2026-10-16	1.7400	1.7400	1.8200	91.4700	13920.00	0.00	13920.00	80	10	3046	1825	1.66904109589041	0.451808594598511	0.451808594598511	false	false	false	true
f363ecc1-86fa-49a7-8c07-5e9aa31131df	2026-09-18 10:12	2026-09-18 10:12	2026-09-18 10:12	CCJ	CCJ261016C00100000	call	100.0000	2026-10-16	1.7500	1.6900	1.7500	91.5000	15050.00	14875.00	0.00	86	5	2559	1825	1.40219178082192	0.45205033998344	0.45205033998344	false	false	false	true
29d2e449-1c88-419f-b2f1-3c228677ce36	2026-09-18 10:09	2026-09-18 10:08	2026-09-18 10:08	CCJ	CCJ261016C00100000	call	100.0000	2026-10-16	1.7500	1.6300	1.9600	91.4400	23450.00	0.00	23450.00	134	9	2225	1825	1.21917808219178	0.453971589974088	0.453971589974088	true	false	false	true
046751c6-e93e-4d5e-b282-9445689b7faa	2026-09-18 10:09	2026-09-18 10:08	2026-09-18 10:08	CCJ	CCJ261016C00100000	call	100.0000	2026-10-16	1.7500	1.6700	1.8000	91.4429	24325.00	10150.00	14175.00	139	9	2089	1825	1.14465753424658	0.453878755707925	0.453878755707925	false	false	false	true
2edfdceb-00c7-44af-870a-e242b15e5e55	2026-09-18 10:08	2026-09-18 10:08	2026-09-18 10:08	CCJ	CCJ261016C00100000	call	100.0000	2026-10-16	1.7500	1.7000	1.8300	91.4400	15575.00	700.00	14175.00	89	6	1807	1825	0.99013698630137	0.453971589974088	0.453971589974088	false	false	false	true
64f80385-1ac9-4dd3-a489-95b0cc42f7d8	2026-09-18 10:08	2026-09-18 10:07	2026-09-18 10:07	CCJ	CCJ261016C00100000	call	100.0000	2026-10-16	1.7500	1.6900	1.8100	91.4400	16275.00	350.00	15400.00	93	13	1637	1825	0.896986301369863	0.453971589974088	0.453971589974088	false	false	false	true
a8cc48e3-6bfe-42c6-9c85-82618dc23453	2026-09-18 10:08	2026-09-18 10:07	2026-09-18 10:07	CCJ	CCJ261016C00100000	call	100.0000	2026-10-16	1.7500	1.6600	1.8100	91.4800	30625.00	1925.00	28700.00	175	6	1535	1825	0.841095890410959	0.45269088344778	0.45269088344778	false	false	false	true
d5f4e0ea-7100-4176-bc49-69d91eb7b595	2026-09-18 10:07	2026-09-18 10:07	2026-09-18 10:07	CCJ	CCJ261016C00100000	call	100.0000	2026-10-16	1.7500	1.6600	1.8400	91.4800	28875.00	2625.00	25725.00	165	9	1360	1825	0.745205479452055	0.45269088344778	0.45269088344778	false	false	false	true
d46a1f57-fcca-4d84-99be-164061954164	2026-09-18 10:07	2026-09-18 10:07	2026-09-18 10:07	CCJ	CCJ261016C00100000	call	100.0000	2026-10-16	1.7500	1.6600	1.8500	91.4800	19950.00	0.00	19950.00	114	15	1195	1825	0.654794520547945	0.45269088344778	0.45269088344778	false	false	false	true
4513d1a0-7a20-483c-b637-f7e8525be126	2026-09-18 10:06	2026-09-18 10:06	2026-09-18 10:06	CCJ	CCJ261016C00100000	call	100.0000	2026-10-16	1.7500	1.6900	1.8900	91.4900	40250.00	875.00	39025.00	230	17	767	1825	0.42027397260274	0.452370627644158	0.452370627644158	true	false	false	true
760fc0f7-fe2f-492f-b8f8-b9240bd37904	2026-09-18 10:05	2026-09-18 10:05	2026-09-18 10:05	CCJ	CCJ261016C00100000	call	100.0000	2026-10-16	1.7500	1.6900	1.9500	91.6000	70700.00	5775.00	64925.00	404	9	486	1825	0.266301369863014	0.448845690332123	0.448845690332123	false	false	false	true
b94b6d51-2d3d-4263-b3eb-5cd840d5eb76	2026-09-18 10:04	2026-09-18 10:04	2026-09-18 10:04	CCJ	CCJ261016C00100000	call	100.0000	2026-10-16	1.7500	1.7500	1.9700	91.7101	14175.00	0.00	14175.00	81	7	82	1825	0.0449315068493151	0.445313560793277	0.445313560793277	false	false	false	true
0679e3f4-01a8-4426-8bff-1dd2b968e548	2026-09-18 09:51	2026-09-18 09:51	2026-09-18 09:51	CCJ	CCJ270115P00090000	put	90.0000	2027-01-15	7.5500	7.3500	7.8500	92.8000	10570.00	1510.00	755.00	14	14	70	3729	0.0187717886832931	0.457345354839512	0.457345354839512	false	false	false	true
a4d573d4-21d3-4066-a89e-9c4c806e64cf	2026-09-18 09:51	2026-09-18 09:51	2026-09-18 09:51	CCJ	CCJ270115P00090000	put	90.0000	2027-01-15	7.5500	7.3000	7.7000	92.8000	12080.00	755.00	755.00	16	16	47	3729	0.0126039152587825	0.457345354839512	0.457345354839512	false	false	false	true
4e24ea99-43a8-49b6-836b-87c9c0291ffe	2026-09-17 15:28	2026-09-17 15:28	2026-09-17 15:28	CCJ	CCJ261120C00090000	call	90.0000	2026-11-20	9.0500	8.8500	9.2500	92.9000	44345.00	0.00	41630.00	49	8	59	22	2.68181818181818	0.469481420605111	0.469481420605111	false	false	false	true
ea080e86-bb05-4bed-b898-cc430d202096	2026-09-17 13:25	2026-09-17 13:24	2026-09-17 13:24	CCJ	CCJ261002P00084000	put	84.0000	2026-10-02	0.4900	0.4300	0.4900	92.5700	10045.00	10045.00	0.00	205	31	205	13	15.7692307692308	0.429968595102187	0.429171260104227	false	false	false	true
12e30c76-091b-43cf-a5db-f645c28701b7	2026-09-17 12:49	2026-09-17 12:49	2026-09-17 12:49	CCJ	CCJ270115C00100000	call	100.0000	2027-01-15	7.4500	7.4500	7.6500	92.7300	43955.00	0.00	43955.00	59	8	63	2269	0.0277655354781842	0.464010004085045	0.464010004085045	false	false	false	true
31853fb3-0397-44e1-9425-f22cda926c2c	2026-09-17 11:27	2026-09-17 11:27	2026-09-17 11:27	CCJ	CCJ270319P00085000	put	85.0000	2027-03-19	7.4500	7.4500	7.7500	92.3800	37250.00	0.00	37250.00	50	13	50	548	0.0912408759124088	0.465903127120885	0.466038429130714	false	false	false	true
9f508142-1b7a-4827-8c72-6bdfca3c6b70	2026-09-17 11:27	2026-09-17 11:26	2026-09-17 11:26	CCJ	CCJ270617P00085000	put	85.0000	2027-06-17	9.6000	9.5500	9.8500	92.2500	26880.00	0.00	26880.00	28	11	60	396	0.151515151515152	0.470560070856405	0.470560070856405	false	false	false	true
751405ce-9cba-47b7-a02d-7531119430d8	2026-09-17 11:14	2026-09-17 11:14	2026-09-17 11:14	CCJ	CCJ261016P00080000	put	80.0000	2026-10-16	0.6600	0.5900	0.7000	91.7700	17688.00	17490.00	198.00	268	34	293	46443	0.00630880864715888	0.435585981701289	0.435585981701289	false	false	false	true
c936a722-c5b2-4ade-9840-a8b8f3e7ad5f	2026-09-17 10:58	2026-09-17 10:58	2026-09-17 10:58	CCJ	CCJ260918P00105000	put	105.0000	2026-09-18	13.3000	13.3000	13.6000	91.8400	13300.00	0.00	6650.00	10	10	30	973	0.0308324768756423	1.52428899786649	1.52428899786649	false	false	false	true
d4ee70cc-4edb-446e-a402-a679c1b65dac	2026-09-17 10:53	2026-09-17 10:53	2026-09-17 10:53	CCJ	CCJ261016P00105000	put	105.0000	2026-10-16	13.9000	13.2500	13.9000	91.6450	13900.00	5560.00	0.00	10	10	40	261	0.153256704980843	0.439088905383236	0.439088905383236	false	false	false	true
287da781-82c5-45db-9d6e-20cd8d9f3f3e	2026-09-17 10:49	2026-09-17 10:49	2026-09-17 10:49	CCJ	CCJ260918P00105000	put	105.0000	2026-09-18	13.2000	12.8000	13.8000	91.8900	13200.00	1320.00	3960.00	10	10	20	973	0.0205549845837616	1.40854046064837	1.40854046064837	false	false	false	true
c8b019e1-2e3c-4081-b49d-b171495c4bc6	2026-09-17 10:36	2026-09-17 10:35	2026-09-17 10:35	CCJ	CCJ260918P00100000	put	100.0000	2026-09-18	8.0000	8.0000	8.3500	92.0300	14400.00	0.00	800.00	18	16	24	4306	0.00557361820715281	0.816915935219211	0.816915935219211	false	false	false	true
2d973bd4-f4c6-4619-becc-b53c4d3a4ef1	2026-09-17 10:35	2026-09-17 10:35	2026-09-17 10:35	CCJ	CCJ260918C00093000	call	93.0000	2026-09-18	0.7700	0.7700	0.9700	92.0100	14707.00	0.00	14707.00	191	29	192	73	2.63013698630137	0.619569038146702	0.619569038146702	false	false	false	true
6b39a0de-e0fe-426f-839f-5ff85cc3163f	2026-09-17 10:33	2026-09-17 10:33	2026-09-17 10:33	CCJ	CCJ261016P00100000	put	100.0000	2026-10-16	9.5000	9.3500	9.7500	92.0450	19000.00	950.00	950.00	20	18	23	915	0.0251366120218579	0.436798656192106	0.439279057802799	false	false	false	true
67cb7e3b-a730-45a2-9e8a-ce3f5f2d86d7	2026-09-16 15:18	2026-09-16 15:18	2026-09-16 15:18	CCJ	CCJ260925C00095000	call	95.0000	2026-09-25	0.9600	0.9500	1.0700	89.9700	16032.00	0.00	15935.00	167	27	208	24	8.66666666666667	0.472242806942485	0.473343578653698	false	false	false	true
9ac675d6-eca3-456e-a799-68fa4eea0570	2026-09-16 15:17	2026-09-16 15:17	2026-09-16 15:17	CCJ	CCJ270115P00075000	put	75.0000	2027-01-15	3.0000	2.8600	3.0500	90.0650	16800.00	6600.00	10200.00	56	5	153	1164	0.131443298969072	0.470294121916845	0.470294121916845	false	false	false	true
198a3300-54c3-441d-8f63-c674a7faea21	2026-09-16 14:58	2026-09-16 14:58	2026-09-16 14:58	CCJ	CCJ261120P00085000	put	85.0000	2026-11-20	4.3500	4.3000	4.3500	90.2950	33495.00	33495.00	0.00	77	7	1520	3138	0.484384958572339	0.470792572249823	0.470792572249823	false	false	false	true
91366600-f577-431c-bb51-e5700077aa5c	2026-09-16 14:57	2026-09-16 14:57	2026-09-16 14:57	CCJ	CCJ261120P00085000	put	85.0000	2026-11-20	4.3500	4.3000	4.3500	90.3375	70470.00	70470.00	0.00	162	24	1443	3138	0.459847036328872	0.471807773584494	0.471807773584494	false	false	false	true
a28ebe2c-4b8c-41f3-b1ac-a4a2eb38f077	2026-09-16 14:57	2026-09-16 14:57	2026-09-16 14:57	CCJ	CCJ261120P00085000	put	85.0000	2026-11-20	4.3500	4.2000	4.3500	90.4300	18270.00	18270.00	0.00	42	7	1225	3138	0.390376035691523	0.474011453191228	0.474011453191228	true	false	false	true
ed7f8529-ee69-4e45-b47b-832217e70eca	2026-09-16 14:56	2026-09-16 14:56	2026-09-16 14:56	CCJ	CCJ261120P00085000	put	85.0000	2026-11-20	4.3500	4.2000	4.3500	90.4500	24360.00	24360.00	0.00	56	7	1183	3138	0.376991714467814	0.474486872318708	0.474486872318708	false	false	false	true
e1c94a52-5d79-4f88-9abe-6048abcef7f7	2026-09-16 14:56	2026-09-16 14:55	2026-09-16 14:55	CCJ	CCJ261120P00085000	put	85.0000	2026-11-20	4.3500	4.2500	4.3500	90.4600	66990.00	66990.00	0.00	154	19	1127	3138	0.359145952836201	0.474724442290719	0.474724442290719	false	false	false	true
2f691b30-807a-4f2a-878c-c21684694278	2026-09-16 14:54	2026-09-16 14:54	2026-09-16 14:54	CCJ	CCJ261120P00085000	put	85.0000	2026-11-20	4.3500	4.2000	4.3500	90.4550	25230.00	25230.00	0.00	58	7	973	3138	0.310070108349267	0.474605668925643	0.474605668925643	false	false	false	true
6c516764-588a-4519-9e46-4d3da15d5dc7	2026-09-16 14:54	2026-09-16 14:53	2026-09-16 14:53	CCJ	CCJ261120P00085000	put	85.0000	2026-11-20	4.3500	4.2000	4.3500	90.4200	18270.00	18270.00	0.00	42	5	915	3138	0.291586998087954	0.473773603810389	0.473773603810389	false	false	false	true
a3e335a9-8829-43ea-8096-79c579864bd8	2026-09-16 14:53	2026-09-16 14:53	2026-09-16 14:53	CCJ	CCJ261120P00085000	put	85.0000	2026-11-20	4.3500	4.1500	4.3500	90.4550	364092.00	364092.00	0.00	837	51	873	3138	0.278202676864245	0.475910900717907	0.473879862282082	false	false	false	true
2ccc1925-486f-4791-a90e-524b79bbe8e9	2026-09-16 14:31	2026-09-16 14:31	2026-09-16 14:31	CCJ	CCJ261120P00075000	put	75.0000	2026-11-20	1.4200	1.2700	1.4200	90.8700	10082.00	10082.00	0.00	71	19	71	16227	0.0043754236765884	0.47916633214491	0.47916633214491	false	false	false	true
5b6ea9d6-dd61-4964-bdba-50e9ed0889cb	2026-09-16 10:18	2026-09-16 10:18	2026-09-16 10:18	CCJ	CCJ261030P00095000	put	95.0000	2026-10-30	7.6500	7.6500	8.0500	91.0000	16065.00	0.00	16065.00	21	5	21	4	5.25	0.486459394710552	0.486459394710552	true	false	false	true
c8ba9440-69ab-41a2-bd07-f13e91e0d519	2026-09-16 10:06	2026-09-16 10:06	2026-09-16 10:06	CCJ	CCJ261218P00080000	put	80.0000	2026-12-18	3.2000	3.1000	3.5500	92.0200	13760.00	0.00	13760.00	43	21	49	1652	0.0296610169491525	0.469115661652901	0.469115661652901	false	false	false	true
597f58db-40ca-42e7-b7d7-ea47b42d27c1	2026-09-16 10:06	2026-09-16 10:06	2026-09-16 10:06	CCJ	CCJ261218P00080000	put	80.0000	2026-12-18	3.2000	3.2000	3.4000	92.0200	17920.00	0.00	17920.00	56	15	105	1652	0.0635593220338983	0.469115661652901	0.469115661652901	false	false	false	true
246ae851-7ce1-4850-9d03-4367a694521b	2026-09-16 10:06	2026-09-16 10:06	2026-09-16 10:06	CCJ	CCJ270319P00080000	put	80.0000	2027-03-19	5.7000	5.7000	5.9500	92.0700	27360.00	0.00	27360.00	48	23	48	289	0.166089965397924	0.471276735035941	0.471276735035941	false	false	false	true
06f90b8e-3c5a-46f8-8e4e-17a48c7ec5f6	2026-09-16 09:55	2026-09-16 09:55	2026-09-16 09:55	CCJ	CCJ260918P00095000	put	95.0000	2026-09-18	3.3500	3.3500	3.5500	92.4150	88775.00	0.00	8710.00	265	72	267	11984	0.0222797062750334	0.64405611769343	0.64405611769343	true	false	false	true
8eefd130-db2d-49f9-a7f4-1863988073b8	2026-09-15 15:33	2026-09-15 15:33	2026-09-15 15:33	CCJ	CCJ270115P00080000	put	80.0000	2027-01-15	4.3000	4.1000	4.3000	91.4650	56760.00	56760.00	0.00	132	10	176	2884	0.0610263522884882	0.470654321428276	0.470654321428276	false	false	false	true
576bc1c3-7243-48d6-9974-c997ba9e9148	2026-09-15 14:32	2026-09-15 14:32	2026-09-15 14:32	CCJ	CCJ261218P00075000	put	75.0000	2026-12-18	2.2500	2.1300	2.2500	91.1900	19800.00	19800.00	0.00	88	22	132	612	0.215686274509804	0.483701914869343	0.483701914869343	false	false	false	true
24a41de8-7f2f-4db0-9896-90743730401b	2026-09-15 13:12	2026-09-15 13:12	2026-09-15 13:12	CCJ	CCJ260918P00095000	put	95.0000	2026-09-18	4.2000	4.2000	4.4000	91.4000	91560.00	0.00	11760.00	218	45	488	12003	0.0406565025410314	0.566019067061127	0.566019067061127	true	false	false	true
b58a57f0-d456-46ad-aec8-bffaeadf7f02	2026-09-15 13:12	2026-09-15 13:12	2026-09-15 13:12	CCJ	CCJ260918P00095000	put	95.0000	2026-09-18	4.1000	4.1000	4.5500	91.5000	91840.00	0.00	5740.00	224	51	270	12003	0.0224943764058985	0.556762768919691	0.556762768919691	true	false	false	true
be485ae2-d027-4d68-b802-962814a3ee3f	2026-09-15 11:24	2026-09-15 11:24	2026-09-15 11:24	CCJ	CCJ261016C00100000	call	100.0000	2026-10-16	2.1500	2.1500	2.2500	91.7800	10750.00	0.00	10750.00	50	5	117	1002	0.116766467065868	0.464266326625949	0.464266326625949	false	false	false	true
507ac4dd-d13e-4c5c-b6dd-1020cad2e43c	2026-09-15 10:40	2026-09-15 10:40	2026-09-15 10:40	CCJ	CCJ261120P00085000	put	85.0000	2026-11-20	3.9500	3.9000	4.2000	92.0400	14220.00	2765.00	11455.00	36	6	93	3029	0.0307032023770221	0.478212533761478	0.478212533761478	false	false	false	true