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.

326,449 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts326,449 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 = 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

a3ad5e53-1b70-46e3-bf14-e28e80ef4d62	2026-09-17 11:26	2026-09-17 11:26	2026-09-17 11:26	CCJ	CCJ270617P00085000	put	85.0000	2027-06-17	9.6200	9.6000	10.0500	92.2400	22135.00	1930.00	20205.00	23	13	32	396	0.0808080808080808	0.469783665743809	0.472217296133648	true	false	false	true	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	Common Stock	Energy	40410500358.00	2026-11-04	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-17T15:37:51.418712Z"}	2026-09-17	2026-09-17 21:15	2026-09-17 21:15
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	false
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	false
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	false
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	false
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	false
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	false
b7f7bfbe-4f6a-4f32-a044-d5d28419ae35	2026-09-16 15:30	2026-09-16 15:30	2026-09-16 15:30	CCJ	CCJ290119P00050000	put	50.0000	2029-01-19	4.0100	4.0000	4.6000	89.9900	16830.00	830.00	14000.00	42	13	92	0	0	0.475237456100076	0.486036820335663	false	false	false	true	false
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	false
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	false
220dd33f-629c-43b9-9750-889e3854a525	2026-09-16 14:59	2026-09-16 14:59	2026-09-16 14:59	CCJ	CCJ261120P00085000	put	85.0000	2026-11-20	4.3500	4.2500	4.3500	90.2850	214445.00	213585.00	430.00	493	23	2035	3138	0.648502230720204	0.470553452834647	0.466928215382399	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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
7f8062b2-fa44-43b3-bba5-1ff2aafa5bc1	2026-09-16 10:24	2026-09-16 10:24	2026-09-16 10:24	CCJ	CCJ261218C00105000	call	105.0000	2026-12-18	4.7000	4.4500	4.8000	91.0000	23015.00	23015.00	0.00	49	9	400	1314	0.30441400304414	0.484973365770225	0.484973365770225	false	false	false	true	false
4ed420c3-9b2e-4fd4-b186-801943537ef3	2026-09-16 10:24	2026-09-16 10:24	2026-09-16 10:24	CCJ	CCJ261218C00105000	call	105.0000	2026-12-18	4.6800	4.6000	4.7000	91.0000	163852.00	163852.00	0.00	350	16	351	1314	0.267123287671233	0.48663982002608	0.486057176565487	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	false
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	false
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	false
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	false
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	false
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	false
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	false
5e2ac3fe-f5ed-4b8a-8f89-69ae5354af52	2026-09-15 14:12	2026-09-15 14:11	2026-09-15 14:11	CCJ	CCJ261218C00095000	call	95.0000	2026-12-18	7.7400	7.5000	7.8500	91.3300	10835.00	775.00	9290.00	14	5	27	778	0.0347043701799486	0.481772304995114	0.479068139062106	false	false	false	true	false
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	false
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	false
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	false
e05fc410-c2bd-4c57-bba4-7a8cbef7a105	2026-09-15 10:17	2026-09-15 10:17	2026-09-15 10:17	CCJ	CCJ261002C00102000	call	102.0000	2026-10-02	0.9100	0.8900	1.0300	92.2000	23114.00	182.00	22932.00	254	8	259	19	13.6315789473684	0.480851852685394	0.480851852685394	false	false	false	true
051fd999-7240-4021-8e2b-cb93957644a3	2026-09-14 15:26	2026-09-14 15:26	2026-09-14 15:26	CCJ	CCJ261016P00080000	put	80.0000	2026-10-16	0.6600	0.6600	0.6700	93.4200	12804.00	0.00	12804.00	194	16	3789	47207	0.0802635202406423	0.449863653059848	0.450051439028129	true	false	false	true
5df34d41-1a18-4435-bb69-9d8dbf9801ed	2026-09-14 11:47	2026-09-14 11:47	2026-09-14 11:47	CCJ	CCJ260925C00100000	call	100.0000	2026-09-25	1.0000	1.0000	1.0900	93.1601	20500.00	0.00	20500.00	205	5	408	179	2.27932960893855	0.499728114028592	0.499728114028592	false	false	false	true	false
59a4d909-ce4e-4ff7-a1cb-ebb902a6da91	2026-09-14 11:46	2026-09-14 11:46	2026-09-14 11:46	CCJ	CCJ260925C00100000	call	100.0000	2026-09-25	1.0000	1.0000	1.1000	93.1635	10600.00	0.00	10600.00	106	5	181	179	1.01117318435754	0.49957077631241	0.49957077631241	false	false	false	true	false
50aa4044-0051-4937-ac51-21091b20aa88	2026-09-14 11:39	2026-09-14 11:39	2026-09-14 11:39	CCJ	CCJ260918C00098000	call	98.0000	2026-09-18	0.6500	0.5300	0.6600	93.3500	18067.00	17287.00	780.00	277	20	589	62	9.5	0.560771574017594	0.564273274355304	true	false	false	true	false
2e677408-a43c-4738-ac12-1253cabb9e62	2026-09-14 10:10	2026-09-14 10:10	2026-09-14 10:10	CCJ	CCJ261120P00075000	put	75.0000	2026-11-20	1.4300	1.2200	1.7000	92.8200	2316600.00	0.00	2316600.00	16200	1	16202	7	2314.57142857143	0.503026820696767	0.503026820696767	false	true	false	true
4837aa5d-25e6-4e34-bc50-e7d41c8aae83	2026-09-14 10:03	2026-09-14 10:03	2026-09-14 10:03	CCJ	CCJ260925P00085000	put	85.0000	2026-09-25	0.6000	0.4200	0.6000	92.2800	19800.00	19800.00	0.00	330	22	334	1303	0.256331542594014	0.476294535781961	0.476294535781961	false	false	false	true	false
e8ea771f-6fbb-4517-a8c6-33f16da2cfaf	2026-09-14 09:55	2026-09-14 09:55	2026-09-14 09:55	CCJ	CCJ261120P00085000	put	85.0000	2026-11-20	4.0000	3.8500	4.0000	92.2680	85200.00	85200.00	0.00	213	7	3006	21	143.142857142857	0.481777383327186	0.481777383327186	false	false	false	true	false
337e9309-e19c-43fa-ae60-363007332d14	2026-09-14 09:53	2026-09-14 09:53	2026-09-14 09:53	CCJ	CCJ261120P00085000	put	85.0000	2026-11-20	4.0000	3.8500	4.2500	92.3400	95200.00	20000.00	19200.00	238	28	2788	21	132.761904761905	0.483337816948606	0.483337816948606	false	false	false	true
c04167e7-0acb-4808-a559-760022f65038	2026-09-14 09:48	2026-09-14 09:48	2026-09-14 09:48	CCJ	CCJ261120P00085000	put	85.0000	2026-11-20	4.0000	3.8500	4.0000	92.5100	27600.00	27600.00	0.00	69	11	2399	21	114.238095238095	0.48700684602153	0.48700684602153	false	false	false	true	false
3f6a2fcf-394f-4ded-8867-32627f552052	2026-09-14 09:44	2026-09-14 09:43	2026-09-14 09:43	CCJ	CCJ261120P00085000	put	85.0000	2026-11-20	4.0000	3.8000	4.1250	92.0000	86400.00	86400.00	0.00	216	8	2309	21	109.952380952381	0.477684432341748	0.477684432341748	false	false	false	true	false
f2c3040b-e11d-421c-8568-84446d18f14e	2026-09-14 09:43	2026-09-14 09:43	2026-09-14 09:43	CCJ	CCJ261120P00085000	put	85.0000	2026-11-20	4.0000	3.8500	4.0000	92.0000	85600.00	85600.00	0.00	214	26	2093	21	99.6666666666667	0.483337816948606	0.483337816948606	false	false	false	true	false
3890a1e5-b744-42f9-8473-eba748c9612a	2026-09-14 09:42	2026-09-14 09:42	2026-09-14 09:42	CCJ	CCJ261120P00085000	put	85.0000	2026-11-20	4.0000	3.9000	4.3000	92.0000	353200.00	271600.00	8000.00	883	64	1813	21	86.3333333333333	0.478884624477212	0.481712280717458	false	false	false	true
06ad8afd-d2b3-4f59-9777-4b1a9c0aa73c	2026-09-14 09:39	2026-09-14 09:39	2026-09-14 09:39	CCJ	CCJ261120P00085000	put	85.0000	2026-11-20	4.0000	3.9500	4.0000	92.0000	241200.00	29600.00	0.00	603	22	930	21	44.2857142857143	0.486791612183432	0.486791612183432	false	false	false	true	false
ef3b9664-d939-46b1-a98d-beadc5b2b0ea	2026-09-14 09:39	2026-09-14 09:39	2026-09-14 09:39	CCJ	CCJ261120P00085000	put	85.0000	2026-11-20	4.0000	3.7500	4.0000	92.0000	43200.00	43200.00	0.00	108	12	327	21	15.5714285714286	0.487060642998154	0.487060642998154	false	false	false	true	false