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.

523,327 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts523,327 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:ticker = XYZ×

iduuid	created_at ↓timestamp with time zone	start_timetimestamp with time zone	end_timetimestamp with time zone	tickertext	option_symboltext	option_typetext	strikenumeric	expirydate	price

ccaf526b-9be6-4b6e-b0ad-a958073e41c9	2026-08-19 11:28	2026-08-19 11:28	2026-08-19 11:28	XYZ	XYZ260918C00085000	call	85.0000	2026-09-18	1.9300	1.9300	1.9400	81.1200	30108.00	0.00	30108.00	156	6	1262	6588	0.191560412871888	0.362084425031649	0.362907323709143	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Technology	42989463840.00	2026-11-05	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-19T15:33:41.628321Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
2a9f1bd9-be3b-4268-a9ad-5dc620ec6bd8	2026-08-19 11:28	2026-08-19 11:28	2026-08-19 11:28	XYZ	XYZ260918C00085000	call	85.0000	2026-09-18	1.9300	1.8300	1.9400	81.1800	67936.00	27406.00	40530.00	352	16	723	6588	0.109744990892532	0.362084425031649	0.360437042888371	false	false	false	true	false
92ed5c0e-b51d-48e9-ba53-e7fc0882ad64	2026-08-19 11:25	2026-08-19 11:25	2026-08-19 11:25	XYZ	XYZ261120C00095000	call	95.0000	2026-11-20	2.8100	2.8100	2.9400	81.0600	231263.00	0.00	231263.00	823	40	1621	2516	0.644276629570747	0.433198649565034	0.433198649565034	false	false	false	true	false
4555a901-0d17-4f00-bf42-6a8150728560	2026-08-19 11:01	2026-08-19 11:01	2026-08-19 11:01	XYZ	XYZ261120C00095000	call	95.0000	2026-11-20	3.0000	2.9600	3.0500	81.6700	36600.00	34800.00	1800.00	122	18	765	2516	0.304054054054054	0.434126833739098	0.434126833739098	false	false	false	true	false
5d5d809f-1862-4134-98e9-5137e082405a	2026-08-19 10:56	2026-08-19 10:56	2026-08-19 10:56	XYZ	XYZ261120C00095000	call	95.0000	2026-11-20	3.0000	2.9900	3.0000	81.7000	35700.00	12600.00	0.00	119	15	616	2516	0.24483306836248	0.433503235070235	0.433503235070235	false	false	false	true	false
4c573f92-ce56-40d9-889e-f7eda9366fcc	2026-08-19 10:56	2026-08-19 10:56	2026-08-19 10:56	XYZ	XYZ261120C00095000	call	95.0000	2026-11-20	3.0000	2.9950	3.0500	81.7000	12600.00	0.00	12600.00	42	6	497	2516	0.197535771065183	0.433503235070235	0.433503235070235	false	false	false	true	false
ed821ad6-bc3d-43ef-a0b8-9545c08656cf	2026-08-19 10:56	2026-08-19 10:56	2026-08-19 10:56	XYZ	XYZ261120C00095000	call	95.0000	2026-11-20	3.0000	2.9900	3.0250	81.7000	63900.00	40500.00	3300.00	213	20	455	2516	0.180842607313196	0.433503235070235	0.433503235070235	true	false	false	true	false
7bf53212-17a9-4ca2-be1a-c0166c744ae6	2026-08-19 10:56	2026-08-19 10:56	2026-08-19 10:56	XYZ	XYZ260911C00082000	call	82.0000	2026-09-11	2.8400	2.7500	2.8500	81.6500	21585.00	21585.00	0.00	76	11	79	37	2.13513513513514	0.356497563420475	0.357720877544742	true	false	false	true	false
06d169d3-c054-4403-919d-a3a02d783d65	2026-08-19 10:56	2026-08-19 10:56	2026-08-19 10:56	XYZ	XYZ261120C00095000	call	95.0000	2026-11-20	3.0000	2.9700	3.2500	81.6500	68700.00	65100.00	3600.00	229	18	242	2516	0.0961844197138315	0.434542563697829	0.434542563697829	false	false	false	true	false
e161d7e3-7a67-4c1a-bee0-fc4e1ff12d4c	2026-08-19 10:14	2026-08-19 10:14	2026-08-19 10:14	XYZ	XYZ260918C00085000	call	85.0000	2026-09-18	1.7100	1.5200	1.8000	80.7700	15561.00	9918.00	5643.00	91	7	208	6588	0.0315725561627201	0.351354116074193	0.351354116074193	false	false	false	true	false
58bff0e0-ec1b-43a0-ba3e-6af68ad733c1	2026-08-19 09:35	2026-08-19 09:35	2026-08-19 09:35	XYZ	XYZ261120C00075000	call	75.0000	2026-11-20	10.5000	9.2500	10.5000	80.4250	32550.00	32550.00	0.00	31	11	31	488	0.0635245901639344	0.45004048739526	0.45004048739526	false	false	false	true	false
be8ee886-ee22-43df-92ef-0c8a50145184	2026-08-18 15:04	2026-08-18 15:04	2026-08-18 15:04	XYZ	XYZ280121P00075000	put	75.0000	2028-01-21	12.4500	12.4500	12.7000	80.2000	70965.00	0.00	70965.00	57	7	523	308	1.69805194805195	0.474118690464537	0.474118690464537	false	false	false	true	false
d735f5c7-8e2d-4dae-ae67-4d15a6eabefd	2026-08-18 14:39	2026-08-18 14:39	2026-08-18 14:39	XYZ	XYZ280121P00075000	put	75.0000	2028-01-21	12.5000	12.4500	12.7000	80.1250	326250.00	0.00	326250.00	261	41	423	308	1.37337662337662	0.474922841310955	0.474922841310955	false	false	false	true	false
3f2f7314-1952-452a-9f89-862cc083b921	2026-08-18 13:44	2026-08-18 13:44	2026-08-18 13:44	XYZ	XYZ260918C00080000	call	80.0000	2026-09-18	3.7000	3.6500	3.8000	80.5100	56610.00	740.00	53280.00	153	12	593	4655	0.127389903329753	0.354528767618804	0.354528767618804	false	false	false	true	false
e23fa991-9c75-45fa-83b5-7022bdf3fe03	2026-08-18 12:17	2026-08-18 12:17	2026-08-18 12:17	XYZ	XYZ260918C00090000	call	90.0000	2026-09-18	0.7600	0.7600	0.8700	81.0450	12464.00	0.00	12464.00	164	15	437	12601	0.0346797873184668	0.354942959545381	0.354942959545381	false	false	false	true	false
4b578be1-60a6-4d50-b403-8ea0f21d643a	2026-08-18 10:20	2026-08-18 10:20	2026-08-18 10:20	XYZ	XYZ260918C00085000	call	85.0000	2026-09-18	1.8200	1.8200	1.9700	80.8800	13104.00	0.00	13104.00	72	11	99	6645	0.0148984198645598	0.353640689457218	0.353640689457218	false	false	false	true	false
ab574a00-d807-4657-ba9b-1c2bf823080d	2026-08-18 09:34	2026-08-18 09:34	2026-08-18 09:34	XYZ	XYZ261002C00077000	call	77.0000	2026-10-02	5.8000	4.2500	5.8000	79.9700	25520.00	25520.00	0.00	44	8	44	1	44	0.356788431319975	0.356788431319975	false	false	false	true	false
15e909f4-60ae-48b2-a797-74f82573b62d	2026-08-17 14:07	2026-08-17 14:07	2026-08-17 14:07	XYZ	XYZ270617C00100000	call	100.0000	2027-06-17	7.6000	7.5500	7.6500	80.0000	134520.00	127680.00	6840.00	177	5	726	2087	0.347867752755151	0.447362791505142	0.447362791505142	false	false	false	true	false
e9d7e90c-6707-414d-a452-1bb77ad68aef	2026-08-17 13:52	2026-08-17 13:52	2026-08-17 13:52	XYZ	XYZ270115C00145000	call	145.0000	2027-01-15	0.3200	0.2700	0.3200	80.0000	14720.00	14720.00	0.00	460	45	464	23292	0.0199210029194573	0.462733100663715	0.462733100663715	false	false	false	true	false
6c824f0d-852b-4272-96a9-5071b153f51a	2026-08-17 12:44	2026-08-17 12:44	2026-08-17 12:44	XYZ	XYZ270617C00100000	call	100.0000	2027-06-17	7.5000	7.3000	7.5500	80.2200	105000.00	86250.00	18750.00	140	11	392	2087	0.187829420220412	0.447158398506463	0.447158398506463	false	false	false	true	false
3e55f05d-0c36-4e5e-92b2-d4198e8ceec0	2026-08-17 12:22	2026-08-17 12:22	2026-08-17 12:22	XYZ	XYZ281215C00115000	call	115.0000	2028-12-15	14.8500	14.8500	16.1000	79.9600	120300.00	1495.00	118805.00	81	17	81	3821	0.0211986390997121	0.460645843408323	0.462699538988797	false	false	false	true	false
2dde2d52-9538-47d9-879b-f7b9a2671be4	2026-08-17 12:17	2026-08-17 12:17	2026-08-17 12:17	XYZ	XYZ261218C00115000	call	115.0000	2026-12-18	0.9100	0.9100	1.0000	80.1600	84994.00	0.00	84994.00	934	49	942	214	4.4018691588785	0.433273976656758	0.433273976656758	false	false	false	true	false
4fa8ebd6-352d-40f8-a582-07ab6a936ccd	2026-08-17 11:27	2026-08-17 11:27	2026-08-17 11:27	XYZ	XYZ260918C00080000	call	80.0000	2026-09-18	3.5000	3.3500	3.5500	80.1473	17500.00	17500.00	0.00	50	5	52	4551	0.011426060206548	0.348440549150924	0.348440549150924	false	false	false	true	false
7d22526a-e639-4996-8fe6-f786aa25fade	2026-08-17 11:06	2026-08-17 11:06	2026-08-17 11:06	XYZ	XYZ260821C00081000	call	81.0000	2026-08-21	1.1100	1.1100	1.2100	80.4900	39405.00	0.00	39405.00	355	36	399	312	1.27884615384615	0.395903274913875	0.395903274913875	false	false	false	true	false
4760da1d-d131-437b-b44e-5d09ea43bfdc	2026-08-17 10:21	2026-08-17 10:21	2026-08-17 10:21	XYZ	XYZ261120P00080000	put	80.0000	2026-11-20	6.3400	6.1500	6.4500	80.8700	72319.00	47624.00	24695.00	114	10	114	1515	0.0752475247524752	0.440240240612938	0.437137722473381	false	false	false	true	false