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:alert_rule = RepeatedHits×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

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	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-17T15:40:30.458422Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
0b064a5a-6eb8-498d-88c3-a906a7cd38ec	2026-08-19 13:09	2026-08-19 13:09	2026-08-19 13:09	CCJ	CCJ261016C00110000	call	110.0000	2026-10-16	2.7500	2.7500	2.8400	96.9200	37675.00	0.00	23650.00	137	10	2361	478	4.93933054393305	0.449225041207947	0.449225041207947	false	false	false	true
8043c9de-9c76-4d72-b063-42188cc3260e	2026-08-19 13:10	2026-08-19 13:09	2026-08-19 13:09	CCJ	CCJ261016C00110000	call	110.0000	2026-10-16	2.7500	2.7500	2.8300	96.9656	55275.00	0.00	55275.00	201	6	2607	478	5.45397489539749	0.448243641236783	0.448243641236783	false	false	false	true
6091d0f8-db8c-486f-85e8-e1d50c188471	2026-08-19 13:12	2026-08-19 13:12	2026-08-19 13:12	CCJ	CCJ261016C00110000	call	110.0000	2026-10-16	2.7500	2.7500	2.8600	97.0000	105325.00	0.00	105325.00	383	6	2990	478	6.25523012552301	0.447503204155438	0.447503204155438	false	false	false	true
7e261312-88c8-4671-94d1-3869cf527b58	2026-08-19 13:30	2026-08-19 13:30	2026-08-19 13:30	CCJ	CCJ260918C00105000	call	105.0000	2026-09-18	2.1900	2.0900	2.1900	97.0700	26280.00	26280.00	0.00	120	19	261	1588	0.164357682619647	0.444172671864705	0.444172671864705	false	false	false	true
14a8e1e7-76b6-4309-bc52-e15707db61d7	2026-08-19 14:12	2026-08-19 14:12	2026-08-19 14:12	CCJ	CCJ261016C00110000	call	110.0000	2026-10-16	2.7500	2.7500	2.9000	96.9650	17050.00	0.00	17050.00	62	5	3073	478	6.42887029288703	0.448256555201398	0.448256555201398	false	false	false	true
63828646-309a-4804-b77e-549e12216724	2026-08-19 14:15	2026-08-19 14:15	2026-08-19 14:15	CCJ	CCJ261016C00110000	call	110.0000	2026-10-16	2.7500	2.7500	2.8400	96.8600	59400.00	0.00	59400.00	216	5	3345	478	6.9979079497908	0.450516170672088	0.450516170672088	false	false	false	true
deec9bf4-561e-4615-b8ee-6abc72617760	2026-08-19 14:15	2026-08-19 14:15	2026-08-19 14:15	CCJ	CCJ261016C00110000	call	110.0000	2026-10-16	2.7500	2.7500	2.8400	96.9000	107525.00	0.00	107525.00	391	6	3742	478	7.82845188284519	0.449655440972182	0.449655440972182	false	false	false	true
74283c9c-9c17-48ae-8dc6-a7482181724f	2026-08-19 14:17	2026-08-19 14:17	2026-08-19 14:17	CCJ	CCJ261016C00110000	call	110.0000	2026-10-16	2.7500	2.7500	2.8700	96.9450	21725.00	0.00	21725.00	79	5	3821	478	7.99372384937239	0.448687008324504	0.448687008324504	false	false	false	true
b91bbdd5-ade5-4d52-bead-49d12c105fab	2026-08-19 15:21	2026-08-19 15:21	2026-08-19 15:21	CCJ	CCJ260918C00095000	call	95.0000	2026-09-18	6.6000	6.4500	6.6000	97.9300	21780.00	21780.00	0.00	33	7	217	2248	0.0965302491103203	0.437583173068998	0.437583173068998	false	false	false	true
42b1ac60-a761-4f59-b2b0-c6adcf2e5dd7	2026-08-20 09:48	2026-08-20 09:48	2026-08-20 09:48	CCJ	CCJ261016C00110000	call	110.0000	2026-10-16	2.5000	2.3100	2.7900	95.9500	50499.00	249.00	50250.00	202	12	205	3963	0.0517284885187989	0.452884124050038	0.453557914150019	false	false	false	true
7997f4fb-8fd0-4573-8b69-360e1de3d935	2026-08-20 09:48	2026-08-20 09:48	2026-08-20 09:48	CCJ	CCJ261016C00110000	call	110.0000	2026-10-16	2.5000	2.5000	2.6500	95.8200	58250.00	0.00	58250.00	233	6	440	3963	0.111026999747666	0.457125223123071	0.457125223123071	false	false	false	true
960292f9-c3fd-4012-affc-6e5d0952d47c	2026-08-20 09:50	2026-08-20 09:50	2026-08-20 09:50	CCJ	CCJ261016C00110000	call	110.0000	2026-10-16	2.5000	2.5000	2.6100	95.6800	45250.00	0.00	1250.00	181	6	1039	3963	0.262175119858693	0.460093241511084	0.460093241511084	false	false	false	true
a3bcf4e1-9fa9-48f7-8807-0dc811dacae1	2026-08-20 10:54	2026-08-20 10:54	2026-08-20 10:54	CCJ	CCJ261218C00100000	call	100.0000	2026-12-18	9.1000	9.1000	9.3500	95.9550	60060.00	0.00	60060.00	66	14	68	1165	0.0583690987124464	0.469851587165426	0.469851587165426	false	false	false	true
9b0e81c0-79fc-4bc9-94fc-cf58772793f8	2026-08-20 13:17	2026-08-20 13:17	2026-08-20 13:17	CCJ	CCJ260918P00095000	put	95.0000	2026-09-18	4.6500	4.4500	4.6500	94.8500	16275.00	16275.00	0.00	35	5	157	20929	0.00750155286922452	0.442826035049384	0.442826035049384	false	false	false	true
8e60968b-bd8e-4986-841d-cb5513401f0f	2026-08-20 14:13	2026-08-20 14:13	2026-08-20 14:13	CCJ	CCJ261016P00085000	put	85.0000	2026-10-16	2.5000	2.4000	2.5000	94.2350	72500.00	72500.00	0.00	290	6	408	2581	0.158078264238667	0.440239361986013	0.440239361986013	false	false	false	true
3722e263-a572-4ade-823b-131c799e1586	2026-08-20 14:13	2026-08-20 14:13	2026-08-20 14:13	CCJ	CCJ261016P00085000	put	85.0000	2026-10-16	2.5000	2.4000	2.5300	94.2350	92500.00	89000.00	3500.00	370	6	778	2581	0.301433552886478	0.440239361986013	0.440239361986013	false	false	false	true
3066d561-2992-48da-ab12-533c7d45af74	2026-08-20 14:16	2026-08-20 14:16	2026-08-20 14:16	CCJ	CCJ261016P00085000	put	85.0000	2026-10-16	2.5000	2.4100	2.5800	94.1300	85750.00	85750.00	0.00	343	6	1457	2581	0.564509879891515	0.438068866491866	0.438068866491866	false	false	false	true
d626c8b1-49cb-42d0-a3b6-4b832aff025f	2026-08-20 14:16	2026-08-20 14:16	2026-08-20 14:16	CCJ	CCJ261016P00085000	put	85.0000	2026-10-16	2.5000	2.4300	2.5000	94.1200	75500.00	75500.00	0.00	302	7	1759	2581	0.681518791166215	0.437861775425708	0.437861775425708	false	false	false	true
31f1e009-376e-4d0b-8007-a12a8659ebf3	2026-08-21 09:30	2026-08-21 09:30	2026-08-21 09:30	CCJ	CCJ260828C00100000	call	100.0000	2026-08-28	1.6100	1.6100	1.7000	97.6800	24633.00	0.00	17710.00	153	40	158	243	0.650205761316872	0.472626581452062	0.472626581452062	false	false	false	true
b8304444-454a-4306-8bd1-85625db55661	2026-08-21 09:40	2026-08-21 09:40	2026-08-21 09:40	CCJ	CCJ260918C00110000	call	110.0000	2026-09-18	2.0000	1.7200	2.0250	100.7200	120754.00	113448.00	7306.00	604	50	941	18395	0.0511552052188095	0.464079398618718	0.459584748325682	true	false	false	true
81ec72d5-5e8e-4879-8165-f954ade61155	2026-08-21 09:40	2026-08-21 09:40	2026-08-21 09:40	CCJ	CCJ260918C00110000	call	110.0000	2026-09-18	2.0100	1.7200	2.0700	100.6310	30397.00	17444.00	12953.00	151	22	1107	18395	0.0601793965751563	0.46652035261784	0.467597667312204	true	false	false	true
30fc7c0e-b7f1-498d-bd76-a04a6d45e586	2026-08-21 09:40	2026-08-21 09:40	2026-08-21 09:40	CCJ	CCJ260918C00100000	call	100.0000	2026-09-18	5.6200	5.0500	5.9000	100.6900	20235.00	17360.00	2875.00	36	9	62	8050	0.00770186335403727	0.460453070099431	0.474068801235272	true	false	false	true
a517f42c-fc7e-47dd-8e64-2057c8c23bcc	2026-08-21 09:41	2026-08-21 09:41	2026-08-21 09:41	CCJ	CCJ260918C00110000	call	110.0000	2026-09-18	2.1000	2.0700	2.1100	100.5250	15330.00	13020.00	2310.00	73	8	1218	18395	0.0662136450122316	0.475037449396623	0.475037449396623	false	false	false	true
878dd73d-5aff-44f7-aa82-7fb0d0ea16a2	2026-08-21 09:41	2026-08-21 09:41	2026-08-21 09:41	CCJ	CCJ260904P00109000	put	109.0000	2026-09-04	9.5500	9.5000	9.6000	100.5250	53470.00	27695.00	6675.00	56	13	61	6	10.1666666666667	0.504841210661261	0.504841210661261	false	false	false	true
ef781de8-285c-4e6f-bed2-b09f98322bc8	2026-08-21 09:42	2026-08-21 09:41	2026-08-21 09:41	CCJ	CCJ261016P00100000	put	100.0000	2026-10-16	6.7500	6.0000	6.7500	100.5201	77625.00	77625.00	0.00	115	17	117	128	0.9140625	0.467105487855452	0.467105487855452	true	false	false	true
433e2e04-1d36-4c09-aec5-991ab7d54a1d	2026-08-21 09:48	2026-08-21 09:48	2026-08-21 09:48	CCJ	CCJ260821C00090000	call	90.0000	2026-08-21	10.6000	10.6000	11.0500	100.5600	106000.00	0.00	19080.00	100	6	119	1987	0.0598892803220936	2.031030483363	2.031030483363	false	false	false	true
d330ac6c-8187-488c-a337-f1792472fb43	2026-08-21 09:48	2026-08-21 09:48	2026-08-21 09:48	CCJ	CCJ260821C00090000	call	90.0000	2026-08-21	10.7500	10.6500	10.9000	100.7100	90300.00	16125.00	12900.00	84	7	252	1987	0.126824358329139	2.05425856400956	2.05425856400956	false	false	false	true
642e8122-5370-4bda-980b-bf7f15f5b4fe	2026-08-21 09:48	2026-08-21 09:48	2026-08-21 09:48	CCJ	CCJ260821C00090000	call	90.0000	2026-08-21	10.8500	10.8500	11.2000	100.8300	71610.00	0.00	71610.00	66	5	318	1987	0.160040261701057	1.86444008293537	1.86444008293537	false	false	false	true
70494cf4-f604-4e3f-b9ab-10090e30aeaf	2026-08-21 09:49	2026-08-21 09:48	2026-08-21 09:48	CCJ	CCJ260821C00090000	call	90.0000	2026-08-21	10.9500	10.9500	11.2000	100.9300	72270.00	0.00	59130.00	66	5	418	1987	0.210367388022144	2.12516712430207	1.87877140815953	false	false	false	true