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

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	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-18T13:59:27.968934Z"}	2026-09-18	2026-09-18 21:15	2026-09-18 21:15
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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
f67625e5-4a75-4c6e-9ed3-dbf2501a3bca	2026-09-18 10:27	2026-09-18 10:27	2026-09-18 10:27	CCJ	CCJ261016C00100000	call	100.0000	2026-10-16	1.7500	1.7500	1.8300	91.2400	25725.00	0.00	25725.00	147	5	3734	1825	2.04602739726027	0.460367707585326	0.460367707585326	true	false	false	true	false
c0a08b13-8450-4a15-910a-b94df2a22acc	2026-09-18 10:27	2026-09-18 10:27	2026-09-18 10:27	CCJ	CCJ261016C00100000	call	100.0000	2026-10-16	1.7500	1.7500	1.8300	91.2600	11900.00	0.00	11900.00	68	11	3587	1825	1.96547945205479	0.459728639867716	0.459728639867716	true	false	false	true	false
b33e3728-f26e-48d1-af30-bf64cd80c683	2026-09-18 10:28	2026-09-18 10:28	2026-09-18 10:28	CCJ	CCJ261016C00100000	call	100.0000	2026-10-16	1.7500	1.7500	1.8000	91.2150	12250.00	0.00	12250.00	70	5	3922	1825	2.14904109589041	0.461166376022802	0.461166376022802	false	false	false	true	false
860a4730-4688-4531-b283-2b386143f6d3	2026-09-18 10:28	2026-09-18 10:28	2026-09-18 10:28	CCJ	CCJ261016C00100000	call	100.0000	2026-10-16	1.7500	1.6500	1.8000	91.1700	24150.00	175.00	23975.00	138	9	4060	1825	2.22465753424658	0.462603518019684	0.462603518019684	false	false	false	true	false
0a3ff3a8-5bec-4728-a424-866bf699f2a4	2026-09-18 10:28	2026-09-18 10:28	2026-09-18 10:28	CCJ	CCJ261016C00100000	call	100.0000	2026-10-16	1.7500	1.6500	1.7800	91.1700	17325.00	4725.00	12600.00	99	9	4159	1825	2.27890410958904	0.462603518019684	0.462603518019684	false	false	false	true	false
fc0e262e-31af-49f5-befa-487f16fb4068	2026-09-18 10:29	2026-09-18 10:29	2026-09-18 10:29	CCJ	CCJ261016C00100000	call	100.0000	2026-10-16	1.7500	1.7500	1.7700	91.1400	16275.00	0.00	16275.00	93	12	4256	1825	2.33205479452055	0.463561286570436	0.463561286570436	true	false	false	true	false
4ff21a2d-273e-48d3-b392-11bb5c66e9ea	2026-09-18 10:31	2026-09-18 10:31	2026-09-18 10:31	CCJ	CCJ261016C00100000	call	100.0000	2026-10-16	1.7500	1.5500	1.8000	91.3600	17500.00	4550.00	12950.00	100	5	4505	1825	2.46849315068493	0.456531502347266	0.456531502347266	false	false	false	true	false
909fc43e-70d0-4cfa-a93f-903d659830ce	2026-09-18 10:32	2026-09-18 10:32	2026-09-18 10:32	CCJ	CCJ261016C00100000	call	100.0000	2026-10-16	1.7500	1.7500	1.8100	91.3500	17500.00	0.00	17500.00	100	10	4605	1825	2.52328767123288	0.456851352511624	0.456851352511624	false	false	false	true	false
3da38fed-e83b-4f82-90fa-1cfa42b31cd9	2026-09-18 10:32	2026-09-18 10:32	2026-09-18 10:32	CCJ	CCJ261016P00090000	put	90.0000	2026-10-16	3.6000	3.6000	3.7000	91.2900	53640.00	0.00	53640.00	149	7	247	2949	0.0837572058324856	0.433946707421078	0.433946707421078	true	false	false	true	false
46ce1379-ecb3-4171-a64b-1895deab9e71	2026-09-18 12:28	2026-09-18 12:28	2026-09-18 12:28	CCJ	CCJ290119C00120000	call	120.0000	2029-01-19	21.3000	21.0000	23.0000	91.3600	14910.00	6420.00	8490.00	7	5	7	30	0.233333333333333	0.479009257434324	0.486262858638706	false	false	false	true	false
1526dbd9-3a84-4267-9bf8-de04d0218c35	2026-09-18 13:32	2026-09-18 13:31	2026-09-18 13:31	CCJ	CCJ260925C00091000	call	91.0000	2026-09-25	2.4400	1.9100	2.5700	91.0300	20701.00	15137.00	5564.00	85	7	92	2	46	0.488947665351781	0.41585803819919	true	false	false	true	false
275b9d33-957c-46d9-ba12-816fe6f0e44c	2026-09-18 13:32	2026-09-18 13:31	2026-09-18 13:31	CCJ	CCJ260918P00097000	put	97.0000	2026-09-18	4.3000	4.3000	7.0000	92.7200	28810.00	0.00	28810.00	67	9	115	150	0.766666666666667	6.51697310986756	1.37664164356847	false	false	false	true	false
efee2d06-6de6-48a8-b09d-6549cf4da27a	2026-09-18 13:33	2026-09-18 13:33	2026-09-18 13:33	CCJ	CCJ261016C00090000	call	90.0000	2026-10-16	7.0000	6.2000	8.3500	94.0300	140000.00	84000.00	56000.00	200	7	423	559	0.756708407871199	0.446223416731761	0.446223416731761	true	false	false	true	false
52ab764f-b45d-4062-abba-ac5209baa4b3	2026-09-18 13:34	2026-09-18 13:34	2026-09-18 13:34	CCJ	CCJ261016C00110000	call	110.0000	2026-10-16	0.9900	0.7950	1.0400	93.8750	88664.00	60500.00	28164.00	893	46	995	21248	0.046827936746988	0.513164268433658	0.513164268433658	false	false	false	true	false
7e91152a-c768-44b6-a52f-156bd24d4723	2026-09-18 13:37	2026-09-18 13:37	2026-09-18 13:37	CCJ	CCJ261016C00095000	call	95.0000	2026-10-16	5.5500	4.6500	5.8000	95.5100	14430.00	555.00	13875.00	26	5	97	2459	0.0394469296461976	0.48953595518613	0.48953595518613	false	false	false	true	false
9bb5562b-f813-4c0b-acdd-1bb79525736a	2026-09-18 13:48	2026-09-18 13:48	2026-09-18 13:48	CCJ	CCJ270319C00100000	call	100.0000	2027-03-19	10.9600	10.3500	12.5500	93.5200	109580.00	0.00	109580.00	100	16	124	406	0.305418719211823	0.483304120259694	0.483304120259694	false	false	false	true	false
057558f7-7371-409d-94e3-b87f945909c6	2026-09-18 14:33	2026-09-18 14:32	2026-09-18 14:32	CCJ	CCJ261120C00100000	call	100.0000	2026-11-20	4.7500	4.7500	4.8000	92.1850	12350.00	0.00	12350.00	26	6	105	538	0.195167286245353	0.492208091653939	0.492208091653939	true	false	false	true	false
fe4b329e-8777-47c3-8dff-b10dc0c0dd71	2026-09-18 14:33	2026-09-18 14:33	2026-09-18 14:33	CCJ	CCJ261120C00100000	call	100.0000	2026-11-20	4.9300	4.6000	5.0000	92.5200	72991.00	69526.00	0.00	148	15	290	538	0.539033457249071	0.493271234030009	0.496627684515941	false	false	false	true	false
b2c789d6-ab97-4fce-98a8-2b46c6c1b17f	2026-09-18 14:33	2026-09-18 14:33	2026-09-18 14:33	CCJ	CCJ261120C00100000	call	100.0000	2026-11-20	5.0000	4.6000	5.1000	92.6800	86010.00	63500.00	22005.00	172	53	463	538	0.860594795539034	0.495615540111808	0.495615540111808	true	false	false	true	false
d22dc7d1-4b24-4932-9db9-906e8c233722	2026-09-18 14:35	2026-09-18 14:35	2026-09-18 14:35	CCJ	CCJ261120C00100000	call	100.0000	2026-11-20	5.0500	5.0500	5.2000	92.7600	17675.00	0.00	17675.00	35	8	637	538	1.18401486988848	0.496767757358045	0.496767757358045	true	false	false	true	false
61803a28-6173-4cce-8e15-19343fc5f58d	2026-09-18 14:36	2026-09-18 14:35	2026-09-18 14:35	CCJ	CCJ261120C00100000	call	100.0000	2026-11-20	5.1000	5.1000	5.2000	92.8599	43350.00	0.00	43350.00	85	17	732	538	1.36059479553903	0.4973602606525	0.4973602606525	true	false	false	true	false
607c485a-d0ae-4079-997a-1cf168f9c6fe	2026-09-18 14:36	2026-09-18 14:36	2026-09-18 14:36	CCJ	CCJ261120C00100000	call	100.0000	2026-11-20	5.1500	5.1500	5.3500	93.0000	174070.00	0.00	174070.00	338	18	1082	538	2.01115241635688	0.497104312588235	0.496828659744621	false	false	false	true	false
a7559733-45d1-46ed-a59a-c3a767c29384	2026-09-18 14:54	2026-09-18 14:54	2026-09-18 14:54	CCJ	CCJ261120C00100000	call	100.0000	2026-11-20	5.0000	5.0000	5.1000	92.8100	39000.00	0.00	5500.00	78	15	1160	538	2.15613382899628	0.492063111600552	0.492063111600552	false	false	false	true	false
dfcda919-cedd-4d78-b7df-1ca5e04e69fc	2026-09-18 15:00	2026-09-18 15:00	2026-09-18 15:00	CCJ	CCJ261120C00100000	call	100.0000	2026-11-20	5.0000	5.0000	5.1500	92.8400	11000.00	0.00	11000.00	22	18	1204	538	2.23791821561338	0.491242677382684	0.491242677382684	false	false	false	true	false
fd500a68-edf7-4c74-80d5-567ac9ff067e	2026-09-18 15:16	2026-09-18 15:15	2026-09-18 15:15	CCJ	CCJ261120C00100000	call	100.0000	2026-11-20	4.8000	4.8000	4.9500	92.3350	27840.00	0.00	27840.00	58	12	1313	538	2.44052044609665	0.491547375879406	0.491547375879406	false	false	false	true	false
a3c89d3b-1d22-47e9-b94d-e6b6182d0ec1	2026-09-18 15:16	2026-09-18 15:15	2026-09-18 15:15	CCJ	CCJ261120C00100000	call	100.0000	2026-11-20	4.8000	4.6500	4.9500	92.2700	20160.00	0.00	17280.00	42	17	1355	538	2.5185873605948	0.493300907873124	0.493300907873124	false	false	false	true	false
0606f52e-b442-45a9-a782-b9bd286b673a	2026-09-18 15:28	2026-09-18 15:28	2026-09-18 15:28	CCJ	CCJ261120C00100000	call	100.0000	2026-11-20	4.8000	4.5000	4.8500	92.2400	18240.00	6240.00	960.00	38	17	1393	538	2.58921933085502	0.494109887500259	0.494109887500259	false	false	false	true	false
204f22b7-2352-4bee-9b42-e156aa3e5178	2026-09-18 15:33	2026-09-18 15:33	2026-09-18 15:33	CCJ	CCJ260918P00095000	put	95.0000	2026-09-18	3.0000	3.0000	3.6500	92.0900	63600.00	0.00	1200.00	212	56	829	11830	0.0700760777683855	3.26849014473297	3.26849014473297	true	false	false	true	false
b2d7af85-f9ef-42dc-bb63-51fec5cc65d7	2026-09-18 15:37	2026-09-18 15:37	2026-09-18 15:37	CCJ	CCJ261016P00085000	put	85.0000	2026-10-16	1.6700	1.5700	1.7500	91.7300	41583.00	13193.00	26720.00	249	12	346	10270	0.0336903602726388	0.44037962931716	0.44037962931716	false	false	false	true	false
80f6b9e8-c154-41f1-b94a-d36b0d7f3477	2026-09-18 15:38	2026-09-18 15:38	2026-09-18 15:38	CCJ	CCJ261016P00085000	put	85.0000	2026-10-16	1.6200	1.5200	1.6200	91.7600	11340.00	11340.00	0.00	70	6	546	10270	0.0531645569620253	0.434914019935301	0.434914019935301	false	false	false	true	false
c15b81d6-e629-4dba-95b6-92e70b851a3d	2026-09-18 15:38	2026-09-18 15:38	2026-09-18 15:38	CCJ	CCJ261016P00085000	put	85.0000	2026-10-16	1.6200	1.5400	1.7200	91.8100	19926.00	19764.00	162.00	123	12	773	10270	0.0752677702044791	0.436418501237197	0.436418501237197	true	false	false	true	false
e60b0607-8676-4a57-90ee-84194091a404	2026-09-18 15:39	2026-09-18 15:38	2026-09-18 15:38	CCJ	CCJ261016P00085000	put	85.0000	2026-10-16	1.6200	1.5300	1.7900	91.8000	17334.00	12798.00	4536.00	107	9	1019	10270	0.0992210321324245	0.436117842115828	0.436117842115828	false	false	false	true	false
1e0e15c9-4c5a-44f1-85c6-e396de5fe19b	2026-09-18 15:39	2026-09-18 15:39	2026-09-18 15:39	CCJ	CCJ261016P00085000	put	85.0000	2026-10-16	1.6200	1.5200	1.6200	91.8250	12474.00	12474.00	0.00	77	8	1119	10270	0.108958130477118	0.436869268265674	0.436869268265674	false	false	false	true	false
b2dd325d-f973-475a-b936-c1bb53c1ce0c	2026-09-18 15:39	2026-09-18 15:39	2026-09-18 15:39	CCJ	CCJ261016P00085000	put	85.0000	2026-10-16	1.6200	1.5200	1.6800	91.7750	16848.00	16848.00	0.00	104	7	1253	10270	0.122005842259007	0.435365675929702	0.435365675929702	false	false	false	true	false