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.

375,978 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts375,978 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:option_symbol = CCJ261120P00085000×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	expiry

34b14d00-6019-4646-b0a0-e95464e54006	2026-09-14 09:37	2026-09-14 09:37	2026-09-14 09:37	CCJ	CCJ261120P00085000	put	85.0000	2026-11-20	4.0000	3.5500	4.0000	92.6750	25600.00	25600.00	0.00	64	8	117	21	5.57142857142857	0.490547652314724	0.490547652314724	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-09-14T13:38:30.454841Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
b2ebcfde-37e8-4a1a-87a2-5f8e1261cbcc	2026-09-14 09:38	2026-09-14 09:38	2026-09-14 09:38	CCJ	CCJ261120P00085000	put	85.0000	2026-11-20	4.0000	3.5500	4.0000	92.5150	20000.00	20000.00	0.00	50	10	175	21	8.33333333333333	0.487114435383961	0.487114435383961	false	false	false	true
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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