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:option_symbol = CCJ261016C00100000×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

cd108daf-3780-49bb-b913-0b8b57f62b51	2026-08-21 09:50	2026-08-21 09:50	2026-08-21 09:50	CCJ	CCJ261016C00100000	call	100.0000	2026-10-16	8.5000	7.3500	8.6000	101.4239	23795.00	23795.00	0.00	28	9	57	483	0.118012422360248	0.475798817158957	0.472580093037456	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Energy	40610811028.00	2026-11-04	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-21T13:52:23.943774Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
a0f43919-4d6d-46c8-997d-6095f77942ce	2026-09-02 11:30	2026-09-02 11:30	2026-09-02 11:30	CCJ	CCJ261016C00100000	call	100.0000	2026-10-16	4.3000	4.2000	4.3500	95.4700	21500.00	21500.00	0.00	50	5	132	686	0.192419825072886	0.453522737349825	0.453522737349825	false	false	false	true
58e943fc-2d1a-4312-bbd9-d50697297b45	2026-09-02 14:42	2026-09-02 14:42	2026-09-02 14:42	CCJ	CCJ261016C00100000	call	100.0000	2026-10-16	4.4000	4.4000	4.5500	95.8500	25520.00	0.00	25520.00	58	8	196	686	0.285714285714286	0.448648585813844	0.448648585813844	false	false	false	true
f0ce56f5-06c7-447a-9d4c-b182a9c9e677	2026-09-11 10:30	2026-09-11 10:30	2026-09-11 10:30	CCJ	CCJ261016C00100000	call	100.0000	2026-10-16	4.4000	4.4000	4.6000	96.9300	39600.00	0.00	39600.00	90	11	106	848	0.125	0.466054071899998	0.466054071899998	false	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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
541d2c32-87f4-40e4-98d5-543485c4c59d	2026-09-18 15:47	2026-09-18 15:47	2026-09-18 15:47	CCJ	CCJ261016C00100000	call	100.0000	2026-10-16	1.9500	1.8900	2.0600	91.8100	49530.00	49335.00	195.00	254	7	5419	1825	2.96931506849315	0.465608382779188	0.465608382779188	false	false	false	true
e6c5ecd3-60a9-4834-8122-49342a1f5fc5	2026-09-22 10:13	2026-09-22 10:13	2026-09-22 10:13	CCJ	CCJ261016C00100000	call	100.0000	2026-10-16	2.2100	2.1400	2.2800	93.6200	11050.00	0.00	6630.00	50	6	201	6318	0.0318138651471985	0.469829621879543	0.469829621879543	false	false	false	true
25af0a53-2ca9-4fb1-94f9-9fe6894bd7c8	2026-09-22 11:47	2026-09-22 11:47	2026-09-22 11:47	CCJ	CCJ261016C00100000	call	100.0000	2026-10-16	2.5900	2.3900	2.5900	94.5399	61642.00	61642.00	0.00	238	26	603	6318	0.0954415954415954	0.47775557126215	0.47775557126215	false	false	false	true