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.

425,429 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts425,429 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 = CHRW×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

5e1949c6-c418-4a04-9d48-5a9128d5cfa4	2026-08-17 11:34	2026-08-17 11:34	2026-08-17 11:34	CHRW	CHRW260918C00150000	call	150.0000	2026-09-18	4.5000	4.4000	4.5000	147.0050	31050.00	31050.00	0.00	69	12	172	290	0.593103448275862	0.323341268239154	0.323341268239154	true	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Industrials	18381871396.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
f6540680-b0c8-4990-beb6-61c3cfa9060f	2026-08-17 14:18	2026-08-17 14:18	2026-08-17 14:18	CHRW	CHRW261120P00125000	put	125.0000	2026-11-20	4.1000	3.8000	4.3000	145.8600	11070.00	11070.00	0.00	27	9	37	57	0.649122807017544	0.441833021095068	0.441833021095068	false	false	false	true
38e42f20-4d67-4e71-8ff4-7086012e4b0d	2026-08-17 15:45	2026-08-17 15:45	2026-08-17 15:45	CHRW	CHRW260918C00155000	call	155.0000	2026-09-18	1.9500	1.8500	2.3500	144.2100	107055.00	0.00	0.00	549	8	578	1770	0.326553672316384	0.321402911774075	0.321402911774075	false	false	false	true
22012bbc-c793-48fe-8d4a-c38909230bef	2026-08-17 15:45	2026-08-17 15:45	2026-08-17 15:45	CHRW	CHRW260918C00150000	call	150.0000	2026-09-18	3.5000	3.2000	3.8000	144.2100	192500.00	0.00	0.00	550	8	744	290	2.56551724137931	0.332372834124642	0.332372834124642	false	false	false	true
b2d527d9-dd01-47ef-a56b-90bba7ecd7ee	2026-08-19 10:55	2026-08-19 10:55	2026-08-19 10:55	CHRW	CHRW261120C00155000	call	155.0000	2026-11-20	8.5000	8.4000	9.1000	145.9800	62080.00	2580.00	53550.00	73	9	73	65	1.12307692307692	0.394514939763029	0.394514939763029	false	false	false	true
ebbee9b8-b884-48b1-bfbd-6973f07349fc	2026-08-19 13:36	2026-08-19 13:36	2026-08-19 13:36	CHRW	CHRW261120C00175000	call	175.0000	2026-11-20	3.0000	3.0000	3.3000	144.9500	13500.00	0.00	13500.00	45	7	46	708	0.0649717514124294	0.385927811436819	0.385927811436819	false	false	false	true
4f9ad9fc-6e1b-4c61-99ed-4ab9be116799	2026-08-19 13:42	2026-08-19 13:42	2026-08-19 13:42	CHRW	CHRW270115C00160000	call	160.0000	2027-01-15	8.5700	7.8000	8.9000	144.9400	13710.00	13710.00	0.00	16	7	31	217	0.142857142857143	0.363572931380515	0.360785714008178	false	false	false	true
f33c5a3e-3eb1-4d6d-848b-c2155535a5f4	2026-08-20 13:33	2026-08-20 13:32	2026-08-20 13:32	CHRW	CHRW270219C00180000	call	180.0000	2027-02-19	5.7000	5.3000	5.7000	145.0600	11400.00	11400.00	0.00	20	5	48	509	0.0943025540275049	0.375966858160745	0.375966858160745	false	false	false	true
40a12b0b-55bb-4cdd-9047-3fd87e3c5197	2026-08-24 12:42	2026-08-24 12:41	2026-08-24 12:41	CHRW	CHRW260918C00155000	call	155.0000	2026-09-18	1.1000	1.0500	1.4000	142.7050	22000.00	1540.00	20460.00	200	21	209	1602	0.130461922596754	0.317333971312241	0.317333971312241	false	false	false	true
b54f74a3-4bca-4022-9aa1-c530ca2456a7	2026-08-25 13:31	2026-08-25 13:30	2026-08-25 13:30	CHRW	CHRW270115C00150000	call	150.0000	2027-01-15	10.7000	10.6000	11.3000	142.7300	12840.00	10700.00	2140.00	12	7	12	69	0.173913043478261	0.361582422503428	0.36015466681463	false	false	false	true
b8e4982f-9b1a-4428-b1ca-444804bb612c	2026-08-25 13:44	2026-08-25 13:44	2026-08-25 13:44	CHRW	CHRW280121C00145000	call	145.0000	2028-01-21	25.5000	25.3000	26.6000	142.7001	17850.00	12750.00	5100.00	7	7	74	3	24.6666666666667	0.339877748821181	0.339877748821181	false	false	false	true
3993af16-a3fa-4c2e-bf62-710d19731001	2026-08-25 13:44	2026-08-25 13:44	2026-08-25 13:44	CHRW	CHRW280121C00145000	call	145.0000	2028-01-21	25.5000	24.9000	26.0500	142.7001	63750.00	61200.00	2550.00	25	25	60	3	20	0.339877748821181	0.339877748821181	false	false	false	true
28bf189c-8402-49fc-9b30-b9240b7c6bb8	2026-08-25 13:44	2026-08-25 13:44	2026-08-25 13:44	CHRW	CHRW280121C00145000	call	145.0000	2028-01-21	25.5000	25.4000	26.6000	142.7001	38250.00	33150.00	5100.00	15	15	89	3	29.6666666666667	0.339877748821181	0.339877748821181	false	false	false	true
af182202-1f3f-4520-a73b-f57f05b6f7c5	2026-08-25 13:44	2026-08-25 13:44	2026-08-25 13:44	CHRW	CHRW280121C00145000	call	145.0000	2028-01-21	25.5000	25.4000	26.5000	142.7001	15300.00	5100.00	10200.00	6	6	121	3	40.3333333333333	0.339877748821181	0.339877748821181	false	false	false	true
989ba337-d1c9-42da-ab9c-8d4af6bccc91	2026-08-25 13:44	2026-08-25 13:44	2026-08-25 13:44	CHRW	CHRW280121C00145000	call	145.0000	2028-01-21	25.5000	25.4000	26.5000	142.7001	20400.00	12750.00	7650.00	8	8	115	3	38.3333333333333	0.339877748821181	0.339877748821181	false	false	false	true
b4108e42-c2ae-4e07-afef-5751131d763e	2026-08-25 13:44	2026-08-25 13:44	2026-08-25 13:44	CHRW	CHRW280121C00145000	call	145.0000	2028-01-21	25.5000	25.4000	26.5000	142.7001	20400.00	12750.00	7650.00	8	8	141	3	47	0.339877748821181	0.339877748821181	false	false	false	true
b1586283-32ed-4373-8424-852036017fb8	2026-08-25 13:44	2026-08-25 13:44	2026-08-25 13:44	CHRW	CHRW280121C00145000	call	145.0000	2028-01-21	25.5000	25.4000	25.5000	142.7001	12750.00	12750.00	0.00	5	5	133	3	44.3333333333333	0.339877748821181	0.339877748821181	false	false	false	true
4abc6a8c-b56d-4dbb-8211-90ac885fc53f	2026-08-25 13:44	2026-08-25 13:44	2026-08-25 13:44	CHRW	CHRW280121C00145000	call	145.0000	2028-01-21	25.5000	25.4000	25.5000	142.7001	17850.00	17850.00	0.00	7	7	128	3	42.6666666666667	0.339877748821181	0.339877748821181	false	false	false	true
bbefe56f-c7f0-47cf-8a6b-854c6767d908	2026-08-25 13:45	2026-08-25 13:44	2026-08-25 13:44	CHRW	CHRW280121C00145000	call	145.0000	2028-01-21	25.5000	25.4000	26.5000	142.7001	12750.00	10200.00	2550.00	5	5	166	3	55.3333333333333	0.339877748821181	0.339877748821181	false	false	false	true
a321efec-d46e-4954-a9a0-2e81dec21115	2026-08-25 13:45	2026-08-25 13:44	2026-08-25 13:44	CHRW	CHRW280121C00145000	call	145.0000	2028-01-21	25.5000	25.3000	26.5000	142.7001	35700.00	22950.00	12750.00	14	14	155	3	51.6666666666667	0.339877748821181	0.339877748821181	false	false	false	true
8e534b14-305c-44c5-aed1-94b0056f2853	2026-08-25 13:45	2026-08-25 13:44	2026-08-25 13:44	CHRW	CHRW280121C00145000	call	145.0000	2028-01-21	25.5000	25.4000	26.5000	142.7001	20400.00	12750.00	7650.00	8	8	175	3	58.3333333333333	0.339877748821181	0.339877748821181	false	false	false	true
5893ccef-076f-48d3-8c53-4ed8da47be73	2026-08-25 13:50	2026-08-25 13:50	2026-08-25 13:50	CHRW	CHRW261120P00145000	put	145.0000	2026-11-20	12.0000	11.7000	12.1000	142.5500	10800.00	2400.00	8400.00	9	6	9	96	0.09375	0.410828117478434	0.410828117478434	true	false	false	true
77c54eeb-5d9a-484a-871e-6c00ffa44eff	2026-08-26 10:00	2026-08-26 10:00	2026-08-26 10:00	CHRW	CHRW260918C00150000	call	150.0000	2026-09-18	3.8000	3.8000	4.3000	147.4800	24700.00	0.00	24700.00	65	13	76	1427	0.0532585844428872	0.322986474918666	0.322986474918666	false	false	false	true
d7b12447-78c3-4725-a9a0-d386b7708a2c	2026-08-26 10:01	2026-08-26 10:00	2026-08-26 10:00	CHRW	CHRW260918C00150000	call	150.0000	2026-09-18	4.1000	4.1000	4.3000	148.0100	32800.00	0.00	32800.00	80	16	181	1427	0.126839523475823	0.327028208632611	0.327028208632611	false	false	false	true
3fa6ae47-a9e2-44bd-b1d6-090223588abb	2026-08-26 12:27	2026-08-26 12:27	2026-08-26 12:27	CHRW	CHRW260918C00160000	call	160.0000	2026-09-18	2.0500	1.7500	2.1500	151.5800	19065.00	19065.00	0.00	93	24	95	315	0.301587301587302	0.326901457295973	0.326901457295973	false	false	false	true
bb3bb146-8c09-44ff-bdf2-a0cc29795a6b	2026-08-26 15:40	2026-08-26 15:40	2026-08-26 15:40	CHRW	CHRW260918P00150000	put	150.0000	2026-09-18	4.9000	4.7000	4.9000	151.2150	30380.00	30380.00	0.00	62	6	78	229	0.34061135371179	0.375299994578089	0.375299994578089	true	false	false	true
7eef8c73-7d24-4083-8a8f-0b5872313974	2026-08-27 10:15	2026-08-27 10:15	2026-08-27 10:15	CHRW	CHRW260918P00145000	put	145.0000	2026-09-18	2.9500	2.9500	3.4000	150.3900	15045.00	0.00	15045.00	51	15	51	745	0.0684563758389262	0.368999014152069	0.368999014152069	false	false	false	true
3b8a7f70-7c42-4950-91ba-e306888c212d	2026-08-28 14:07	2026-08-28 14:07	2026-08-28 14:07	CHRW	CHRW261016P00150000	put	150.0000	2026-10-16	6.8500	6.8000	7.2000	150.4900	30130.00	14490.00	15640.00	44	11	44	4	11	0.338521923971259	0.338521923971259	false	false	false	true
be3f1138-e84a-4019-af09-395348196b55	2026-08-28 15:16	2026-08-28 15:16	2026-08-28 15:16	CHRW	CHRW261016P00150000	put	150.0000	2026-10-16	6.8000	6.8000	7.4000	150.7000	32640.00	0.00	32640.00	48	14	92	4	23	0.342818373423271	0.342818373423271	false	false	false	true
33fb4ad2-0e41-4720-8c5d-3d836016b61f	2026-09-04 12:02	2026-09-04 12:02	2026-09-04 12:02	CHRW	CHRW260918P00145000	put	145.0000	2026-09-18	2.7500	2.7500	3.2000	146.2150	75626.00	0.00	75626.00	275	36	276	782	0.352941176470588	0.300580072631541	0.300580072631541	false	false	false	true
f34689cd-20cf-4fdb-93ae-77d9ec6fd8ed	2026-09-04 13:34	2026-09-04 13:34	2026-09-04 13:34	CHRW	CHRW261120P00155000	put	155.0000	2026-11-20	14.3000	14.3000	15.0000	146.9100	124410.00	0.00	124410.00	87	24	88	44	2	0.381028051191889	0.383172933590298	false	false	false	true
9cca75a2-d98a-4f65-8bb4-0cbbac77cd37	2026-09-10 12:00	2026-09-10 12:00	2026-09-10 12:00	CHRW	CHRW260918P00140000	put	140.0000	2026-09-18	0.3500	0.2500	0.4000	152.1800	13753.00	13648.00	105.00	393	64	405	876	0.462328767123288	0.417765187153015	0.415017686088854	true	false	false	true
d5b4b954-5135-47c7-9c09-61ded1fe40af	2026-09-11 11:23	2026-09-11 11:23	2026-09-11 11:23	CHRW	CHRW270115P00155000	put	155.0000	2027-01-15	13.8000	13.8000	14.5000	152.3500	92460.00	0.00	92460.00	67	22	67	266	0.25187969924812	0.375994310743322	0.375994310743322	false	false	false	true
023a6d89-e3da-4f81-ad86-a634df3e41d2	2026-09-11 11:23	2026-09-11 11:23	2026-09-11 11:23	CHRW	CHRW270115P00150000	put	150.0000	2027-01-15	11.3000	11.3000	12.1000	152.3500	70060.00	0.00	70060.00	62	20	63	41	1.53658536585366	0.3784054561914	0.3784054561914	false	false	false	true
83b9617d-f3ef-477c-86dc-f66ac34e458d	2026-09-15 13:44	2026-09-15 13:44	2026-09-15 13:44	CHRW	CHRW270115P00145000	put	145.0000	2027-01-15	7.6000	7.6000	8.3000	156.7500	62320.00	0.00	62320.00	82	9	82	38	2.15789473684211	0.387849859028333	0.387849859028333	false	false	false	true
177aecde-f010-48ca-9603-6a3e8f8500be	2026-09-16 11:23	2026-09-16 11:23	2026-09-16 11:23	CHRW	CHRW270115P00155000	put	155.0000	2027-01-15	12.9000	12.9000	13.4000	153.7300	79980.00	0.00	79980.00	62	9	62	254	0.244094488188976	0.379153430508299	0.379153430508299	false	false	false	true
599e0eed-6b14-45a5-b9dc-ca174bd15b5c	2026-09-16 11:41	2026-09-16 11:41	2026-09-16 11:41	CHRW	CHRW261016P00145000	put	145.0000	2026-10-16	2.5000	2.5000	2.9000	153.9700	23250.00	0.00	5250.00	93	18	93	258	0.36046511627907	0.357080623760871	0.357080623760871	true	false	false	true
c2ae8fb2-4b5f-4bfd-b3c1-908934001755	2026-09-17 11:51	2026-09-17 11:51	2026-09-17 11:51	CHRW	CHRW270115P00150000	put	150.0000	2027-01-15	10.7000	10.7000	11.4000	153.0500	69550.00	0.00	69550.00	65	17	140	74	1.89189189189189	0.381466830419303	0.381466830419303	false	false	false	true
156ecfa9-1c2c-4952-8ba2-879c3af1b0dd	2026-09-22 12:14	2026-09-22 12:14	2026-09-22 12:14	CHRW	CHRW261120P00135000	put	135.0000	2026-11-20	3.3000	3.1000	3.3000	152.1100	20130.00	20130.00	0.00	61	18	62	97	0.639175257731959	0.426954474123822	0.426954474123822	false	false	false	true