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: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

dd69340a-84d0-495c-98e5-c0fce9d790f5	2026-08-19 12:54	2026-08-19 12:53	2026-08-19 12:53	CCJ	CCJ261016C00110000	call	110.0000	2026-10-16	2.7500	2.6200	2.9000	97.0300	92400.00	0.00	92400.00	336	6	1871	478	3.91422594142259	0.446857415071194	0.446857415071194	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-19T17:16:43.855599Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
fb61328a-5d8f-4681-b8e5-a5c557e5c0cc	2026-08-19 11:40	2026-08-19 11:40	2026-08-19 11:40	CCJ	CCJ260918C00115000	call	115.0000	2026-09-18	0.6400	0.5000	0.6400	97.4500	13504.00	13504.00	0.00	211	13	221	1273	0.173605655930872	0.44345431155485	0.44345431155485	false	false	false	true
9cb1b927-ca49-4f3b-a755-8b8de59117d8	2026-08-19 10:32	2026-08-19 10:31	2026-08-19 10:31	CCJ	CCJ260918P00105000	put	105.0000	2026-09-18	9.4000	8.9000	9.4000	97.4400	11280.00	1880.00	0.00	12	12	13	1261	0.0103092783505155	0.430214184433595	0.430214184433595	false	false	false	true
eefa5b0d-d551-490c-aa3b-ee3dc2f4df48	2026-08-19 10:09	2026-08-19 10:09	2026-08-19 10:09	CCJ	CCJ260918C00100000	call	100.0000	2026-09-18	3.9500	3.7000	3.9500	97.4000	99540.00	99540.00	0.00	252	37	407	8442	0.0482113243307273	0.444995991110926	0.444995991110926	false	false	false	true
64ec7794-4c5b-4bf9-b3ce-0e563cf65dc0	2026-08-19 10:06	2026-08-19 10:05	2026-08-19 10:05	CCJ	CCJ260918P00100000	put	100.0000	2026-09-18	5.9500	5.6500	6.6000	97.5500	69615.00	58310.00	11305.00	117	11	123	4764	0.0258186397984887	0.426229092476404	0.426229092476404	false	false	false	true
abaa69a0-56aa-4ced-b0ec-774f0a972ce3	2026-08-19 10:05	2026-08-19 10:04	2026-08-19 10:04	CCJ	CCJ260918C00100000	call	100.0000	2026-09-18	3.8500	3.8500	4.0000	97.5100	53130.00	0.00	53130.00	138	8	155	8442	0.0183605780620706	0.431458690208344	0.431458690208344	false	false	false	true
f91d0adc-09af-4c3a-821d-330cb7b7e978	2026-08-19 09:51	2026-08-19 09:51	2026-08-19 09:51	CCJ	CCJ261016C00110000	call	110.0000	2026-10-16	2.7500	2.5100	2.9900	96.9200	78376.00	7151.00	70400.00	285	7	1362	478	2.84937238493724	0.449225041207947	0.449993955968269	false	false	false	true
f7aa4221-c121-4bcc-9a9a-7e61703d9b80	2026-08-19 09:51	2026-08-19 09:51	2026-08-19 09:51	CCJ	CCJ261016C00110000	call	110.0000	2026-10-16	2.7500	2.5600	2.9900	97.0100	79750.00	0.00	79750.00	290	11	1020	478	2.13389121338912	0.447287947284374	0.447287947284374	false	false	false	true
f83152ec-e826-4974-8965-3c707fd64099	2026-08-19 09:49	2026-08-19 09:49	2026-08-19 09:49	CCJ	CCJ261016C00110000	call	110.0000	2026-10-16	2.7500	2.7500	3.3000	97.0000	53900.00	0.00	53900.00	196	6	262	478	0.548117154811716	0.447503204155438	0.447503204155438	true	false	false	true
4d1bdb6d-c35e-4cde-9c0b-4120249caf2d	2026-08-19 09:49	2026-08-19 09:49	2026-08-19 09:49	CCJ	CCJ261016C00110000	call	110.0000	2026-10-16	2.7500	2.7500	3.3000	97.1350	17050.00	0.00	17050.00	62	5	66	478	0.138075313807531	0.444596708475885	0.444596708475885	false	false	false	true
6d188060-4027-4726-8982-1d5e0c877b4b	2026-08-18 15:03	2026-08-18 15:03	2026-08-18 15:03	CCJ	CCJ261016P00095000	put	95.0000	2026-10-16	6.0500	6.0500	6.1500	95.4200	12705.00	0.00	12705.00	21	5	196	253	0.774703557312253	0.430124468573034	0.430124468573034	true	false	false	true
302798b5-6a96-44a4-a4ff-b0982374f572	2026-08-18 11:50	2026-08-18 11:50	2026-08-18 11:50	CCJ	CCJ260918C00100000	call	100.0000	2026-09-18	2.7000	2.7000	2.8100	94.4300	44550.00	0.00	44550.00	165	14	208	8293	0.025081393946702	0.432970696064837	0.432970696064837	false	false	false	true
6e07bda7-e6d1-4437-b26f-66ca1fdbe795	2026-08-18 10:05	2026-08-18 10:05	2026-08-18 10:05	CCJ	CCJ261218P00080000	put	80.0000	2026-12-18	3.4500	2.9900	3.5000	95.8700	145494.00	145494.00	0.00	422	23	422	1209	0.349048800661704	0.482404605320125	0.484319143763344	false	false	false	true
c3512d21-ca42-47de-926e-41735baf2a3b	2026-08-18 10:03	2026-08-18 10:03	2026-08-18 10:03	CCJ	CCJ270115C00100000	call	100.0000	2027-01-15	9.7500	9.7500	11.6500	96.2560	13650.00	0.00	13650.00	14	7	15	1275	0.0117647058823529	0.434659221698439	0.434659221698439	false	false	false	true
d25f9476-e923-410c-86ea-caedaf985f13	2026-08-17 15:31	2026-08-17 15:31	2026-08-17 15:31	CCJ	CCJ270319C00105000	call	105.0000	2027-03-19	12.7500	12.7500	13.9500	98.6002	29325.00	0.00	29325.00	23	5	23	28	0.821428571428571	0.479623898743464	0.479623898743464	false	false	false	true
4a9eb8b0-586b-493c-93c8-d4aa5646f8c9	2026-08-17 15:26	2026-08-17 15:26	2026-08-17 15:26	CCJ	CCJ260821C00095000	call	95.0000	2026-08-21	4.5000	4.4000	4.7000	98.8700	76500.00	1800.00	74700.00	170	27	348	1180	0.294915254237288	0.482848097695981	0.482848097695981	false	false	false	true
7679c9d0-6927-4da3-985a-5d156f5c9146	2026-08-17 15:01	2026-08-17 15:01	2026-08-17 15:01	CCJ	CCJ260918P00090000	put	90.0000	2026-09-18	1.6000	1.6000	1.7200	98.8000	11360.00	0.00	11360.00	71	12	314	3598	0.0872707059477487	0.436438511176698	0.436438511176698	false	false	false	true
99a863ba-bf24-48b3-8cba-9d936ade891f	2026-08-17 13:20	2026-08-17 13:20	2026-08-17 13:20	CCJ	CCJ260828P00098000	put	98.0000	2026-08-28	2.3400	2.2000	2.3400	99.4050	58734.00	58734.00	0.00	251	9	251	16	15.6875	0.444851841483114	0.444851841483114	false	false	false	true
1076a050-970c-4e3a-802b-0ba6eaa7d72c	2026-08-17 12:08	2026-08-17 12:08	2026-08-17 12:08	CCJ	CCJ260918P00090000	put	90.0000	2026-09-18	1.3600	1.3600	1.4900	100.2800	16048.00	0.00	16048.00	118	17	230	3598	0.0639244024458032	0.442194423003943	0.442194423003943	false	false	false	true
4955a2ec-737a-419e-a4ca-97da5ad205fa	2026-08-17 11:56	2026-08-17 11:56	2026-08-17 11:56	CCJ	CCJ280121C00120000	call	120.0000	2028-01-21	19.4500	17.9000	19.4500	100.5800	29175.00	29175.00	0.00	15	5	30	1799	0.0166759310728182	0.502451113442922	0.502451113442922	false	false	false	true
c70addc6-92eb-486f-b013-4e2b9b7e0cad	2026-08-17 11:25	2026-08-17 11:25	2026-08-17 11:25	CCJ	CCJ270115P00100000	put	100.0000	2027-01-15	11.4500	11.0500	11.7000	99.9400	21755.00	1145.00	20610.00	19	5	115	1493	0.0770261219022103	0.48198758634681	0.48198758634681	false	false	false	true