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:source = uw_flow_alerts×ticker = CAPR×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

29cdc895-15eb-4274-aa40-58e08b5c37e8	2026-08-14 15:58	2026-08-14 15:58	2026-08-14 15:58	CAPR	CAPR261218C00010000	call	10.0000	2026-12-18	2.2000	2.2000	2.9000	6.6650	33000.00	0.00	33000.00	150	9	168	28	6	1.97375471658925	1.97375471658925	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Healthcare	512204493.00	2026-11-09	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-17T13:32:33.788843Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
5a3b9fa2-a033-4504-be5a-3d514e1599b3	2026-08-17 10:27	2026-08-17 10:27	2026-08-17 10:27	CAPR	CAPR260918P00005000	put	5.0000	2026-09-18	1.0000	0.7000	1.0000	7.1900	18099.00	18099.00	0.00	181	16	570	6885	0.0827886710239651	2.75090410730059	2.75090410730059	false	false	false	true
c7c2c854-50b9-41ec-a99f-8b7109925ccd	2026-08-17 11:40	2026-08-17 11:40	2026-08-17 11:40	CAPR	CAPR260821C00015000	call	15.0000	2026-08-21	0.2000	0.0500	0.2500	6.8500	11397.00	9917.00	1160.00	570	80	722	7466	0.0967050629520493	5.34751857188486	5.33034046444911	true	false	false	true
897fa279-adeb-41c4-8dd8-32770aa65411	2026-08-18 13:15	2026-08-18 13:15	2026-08-18 13:15	CAPR	CAPR260918C00006000	call	6.0000	2026-09-18	2.5000	2.5000	2.7000	6.9700	70000.00	0.00	70000.00	280	9	287	458	0.626637554585153	2.68305346370919	2.68305346370919	false	false	false	true
db941fbb-925f-48c6-b810-fafac0e88180	2026-08-19 09:35	2026-08-19 09:35	2026-08-19 09:35	CAPR	CAPR260821C00008000	call	8.0000	2026-08-21	0.7300	0.7000	0.8500	7.3925	21755.00	0.00	21755.00	300	24	414	5079	0.0815121086828116	4.49382868564754	4.30213438314956	false	false	false	true
d0fab4b9-6991-4820-aef2-f1523b9ac51f	2026-08-19 12:40	2026-08-19 12:40	2026-08-19 12:40	CAPR	CAPR260821C00010000	call	10.0000	2026-08-21	0.3500	0.2500	0.5000	7.2100	13788.00	11933.00	700.00	394	70	505	12205	0.0413764850471118	5.19539211993409	5.16569064626515	true	false	false	true
06fd3e85-36e4-422c-b384-b542bdb5e0f2	2026-08-19 15:13	2026-08-19 15:13	2026-08-19 15:13	CAPR	CAPR260821P00007000	put	7.0000	2026-08-21	0.6500	0.6000	0.8000	7.5900	19508.00	3900.00	15608.00	300	33	1729	1590	1.0874213836478	4.27005410465248	4.27005410465248	false	false	false	true
f382a67e-0c4a-4d94-b13e-f506eba00910	2026-08-19 15:18	2026-08-19 15:18	2026-08-19 15:18	CAPR	CAPR260821P00007000	put	7.0000	2026-08-21	0.6000	0.6000	0.7000	7.6700	18000.00	0.00	18000.00	300	8	2029	1590	1.27610062893082	4.15599455699841	4.15599455699841	false	false	false	true
482703aa-4360-4de2-bcd5-7a915d6cf3bd	2026-08-19 15:18	2026-08-19 15:18	2026-08-19 15:18	CAPR	CAPR260821P00007000	put	7.0000	2026-08-21	0.6000	0.5500	0.7000	7.7500	18006.00	0.00	18006.00	300	26	2329	1590	1.46477987421384	4.21923473607252	4.28156432266378	false	false	false	true
1f9cfc23-a22f-4cf7-9d99-f555d80b600d	2026-08-19 15:33	2026-08-19 15:33	2026-08-19 15:33	CAPR	CAPR260918C00012000	call	12.0000	2026-09-18	1.5500	1.5500	1.6000	7.8400	25265.00	0.00	25265.00	163	8	1342	60	22.3666666666667	2.9509253812027	2.9509253812027	false	false	false	true
123f9eef-07b6-4eb9-b633-2abd88131e69	2026-08-19 15:33	2026-08-19 15:33	2026-08-19 15:33	CAPR	CAPR260918C00012000	call	12.0000	2026-09-18	1.5900	1.2500	1.6000	7.8100	53082.00	53082.00	0.00	334	23	1179	60	19.65	2.91053471408059	3.02281552339931	false	false	false	true
ae6177bc-ef34-4505-963e-8045b0dd7416	2026-08-19 15:34	2026-08-19 15:34	2026-08-19 15:34	CAPR	CAPR260821P00007000	put	7.0000	2026-08-21	0.5500	0.5500	0.6500	7.8450	11000.00	0.00	11000.00	200	11	2830	1590	1.77987421383648	4.17935314044272	4.17935314044272	false	false	false	true
a6b5690a-e6e2-4bda-b384-ece545c0d444	2026-08-19 15:34	2026-08-19 15:34	2026-08-19 15:34	CAPR	CAPR260821C00010000	call	10.0000	2026-08-21	0.4500	0.4000	0.5000	7.8799	14715.00	0.00	5310.00	327	10	1513	12205	0.123965587873822	4.70359603253144	4.70359603253144	false	false	false	true
6fd0ee18-564d-46e6-a731-d29f8558228e	2026-08-19 15:34	2026-08-19 15:34	2026-08-19 15:34	CAPR	CAPR260918C00011000	call	11.0000	2026-09-18	1.8500	1.8500	2.0000	7.8650	42735.00	0.00	42735.00	231	5	280	484	0.578512396694215	3.05781222738718	3.05781222738718	false	false	false	true
04c88f18-7d54-40d8-bf00-07a41660ba29	2026-08-19 15:57	2026-08-19 15:57	2026-08-19 15:57	CAPR	CAPR260918C00012000	call	12.0000	2026-09-18	1.8400	1.7500	1.8500	7.9100	87210.00	82170.00	0.00	473	8	2352	60	39.2	3.19092955094241	3.24620224426575	false	false	false	true
c4cc3f85-ad50-4325-b5c1-da292d7baeca	2026-08-19 15:57	2026-08-19 15:57	2026-08-19 15:57	CAPR	CAPR260918C00011000	call	11.0000	2026-09-18	2.1500	1.8500	2.2000	7.9600	18275.00	4300.00	0.00	85	6	770	484	1.59090909090909	3.33408148292509	3.33408148292509	false	false	false	true
a6a9a6c1-57ee-43ab-89c9-accbea552f6d	2026-08-19 15:57	2026-08-19 15:57	2026-08-19 15:57	CAPR	CAPR260918C00011000	call	11.0000	2026-09-18	2.1500	1.8500	2.1500	7.9400	14405.00	1290.00	0.00	67	5	685	484	1.41528925619835	3.34645542451359	3.34645542451359	false	false	false	true
595f94bc-6398-48cd-b6ee-6ab6df609136	2026-08-19 15:58	2026-08-19 15:57	2026-08-19 15:57	CAPR	CAPR260918P00006000	put	6.0000	2026-09-18	1.5500	1.0500	1.6000	7.9700	13020.00	13020.00	0.00	84	20	98	222	0.441441441441441	3.15187103716525	3.15187103716525	false	false	false	true
a29a0dfc-c48b-4343-a67c-8af0c75ac995	2026-08-20 14:36	2026-08-20 14:36	2026-08-20 14:36	CAPR	CAPR261218P00004000	put	4.0000	2026-12-18	1.0500	1.0000	1.3500	7.0750	10500.00	8400.00	2100.00	100	5	100	220	0.454545454545455	1.95703113458218	1.95703113458218	false	false	false	true
5f476694-fa66-475c-aa28-1948df6c47f0	2026-08-20 15:45	2026-08-20 15:45	2026-08-20 15:45	CAPR	CAPR260918C00012000	call	12.0000	2026-09-18	1.5500	1.2000	1.6500	7.1050	30999.00	28054.00	1085.00	200	30	1845	2400	0.76875	3.41621025535878	3.41621025535878	false	false	false	true
8e1005fc-812a-430d-b02b-5158473cc653	2026-08-20 15:45	2026-08-20 15:45	2026-08-20 15:45	CAPR	CAPR260918C00012000	call	12.0000	2026-09-18	1.5500	1.2500	1.7000	7.1050	21545.00	10075.00	6510.00	139	24	1984	2400	0.826666666666667	3.41621025535878	3.41621025535878	false	false	false	true
051e9981-e653-4f18-83ff-d5d0451776b3	2026-08-20 15:46	2026-08-20 15:46	2026-08-20 15:46	CAPR	CAPR260918C00012000	call	12.0000	2026-09-18	1.5500	1.4000	1.7000	7.1069	13640.00	0.00	11935.00	88	14	2149	2400	0.895416666666667	3.41507598079691	3.41507598079691	false	false	false	true
01fa0277-de50-42df-b1fb-bf935d7f23dd	2026-08-20 15:46	2026-08-20 15:46	2026-08-20 15:46	CAPR	CAPR260918C00012000	call	12.0000	2026-09-18	1.5500	1.4000	1.7000	7.1069	10385.00	0.00	9300.00	67	9	2216	2400	0.923333333333333	3.41507598079691	3.41507598079691	false	false	false	true
2a2c1572-04f1-4c3a-b585-050555d633d5	2026-08-20 15:46	2026-08-20 15:46	2026-08-20 15:46	CAPR	CAPR260918C00012000	call	12.0000	2026-09-18	1.5500	1.4000	1.7000	7.1050	13330.00	0.00	10695.00	86	13	2331	2400	0.97125	3.41621025535878	3.41621025535878	false	false	false	true
dfbb7ce7-5626-4199-966f-0078659f7470	2026-08-20 15:51	2026-08-20 15:51	2026-08-20 15:51	CAPR	CAPR260918C00012000	call	12.0000	2026-09-18	1.6000	1.1000	1.8500	6.9900	12960.00	1440.00	8000.00	81	22	3033	2400	1.26375	3.54922068499912	3.54922068499912	false	false	false	true
ea2776c3-ebe3-4ebb-9701-ca0870086e66	2026-08-21 12:01	2026-08-21 12:01	2026-08-21 12:01	CAPR	CAPR260918C00007000	call	7.0000	2026-09-18	2.2000	2.1500	2.2000	6.5500	66000.00	13200.00	0.00	300	7	516	951	0.542586750788643	3.3387836330483	3.3387836330483	false	false	false	true
eef2b9f8-a77a-4d9a-8a22-0ddd2e1db0bc	2026-08-21 12:04	2026-08-21 12:04	2026-08-21 12:04	CAPR	CAPR260821P00007000	put	7.0000	2026-08-21	0.7500	0.5500	0.7500	6.5018	22275.00	22275.00	0.00	297	14	683	4936	0.138371150729336	8.05764637949759	8.05764637949759	false	false	false	true
1d05fcd2-df1d-4544-85fd-26c055cf3dc2	2026-08-21 12:08	2026-08-21 12:08	2026-08-21 12:08	CAPR	CAPR260918P00005000	put	5.0000	2026-09-18	1.3500	1.3500	1.4000	6.4300	33480.00	0.00	33480.00	248	6	808	8764	0.0921953445915107	3.28077849041426	3.28077849041426	false	false	false	true
711a79fc-6bf2-4a57-8c1d-26626e92fa24	2026-08-21 12:22	2026-08-21 12:22	2026-08-21 12:22	CAPR	CAPR260918C00010000	call	10.0000	2026-09-18	1.6000	1.6000	1.8000	6.3600	18720.00	0.00	18720.00	117	5	259	4393	0.0589574322786251	3.60874972972938	3.60874972972938	true	false	false	true
e767834d-31d4-4900-8cfd-3e3a2bc02e69	2026-08-21 13:07	2026-08-21 13:07	2026-08-21 13:07	CAPR	CAPR260918P00005000	put	5.0000	2026-09-18	1.4000	1.4000	1.4500	6.2650	12040.00	0.00	12040.00	86	11	2484	8764	0.283432222729347	3.30136454400961	3.30136454400961	false	false	false	true
2b52142f-8fbc-40e6-aa66-6a1978a8668d	2026-08-21 13:07	2026-08-21 13:07	2026-08-21 13:07	CAPR	CAPR260918P00005000	put	5.0000	2026-09-18	1.4000	1.4000	1.4500	6.2655	15960.00	0.00	15960.00	114	9	2398	8764	0.273619351894112	3.29735703583802	3.30158688835883	false	false	false	true
966dd713-6b63-43d6-bf04-bc0ffed1103d	2026-08-21 13:15	2026-08-21 13:15	2026-08-21 13:15	CAPR	CAPR260918P00005000	put	5.0000	2026-09-18	1.4000	1.4000	1.4500	6.2250	17361.00	0.00	17361.00	124	11	2784	8764	0.317663167503423	3.28347579963774	3.28347579963774	false	false	false	true
38c9ca2d-8fdf-4590-aa9c-a1638fd64720	2026-08-21 13:15	2026-08-21 13:15	2026-08-21 13:15	CAPR	CAPR260918P00005000	put	5.0000	2026-09-18	1.4000	1.4000	1.4500	6.2250	24640.00	0.00	24640.00	176	10	2660	8764	0.303514376996805	3.28347579963774	3.28347579963774	false	false	false	true
a843971f-a97f-4589-8e5e-210e7bdf560f	2026-08-21 13:23	2026-08-21 13:22	2026-08-21 13:22	CAPR	CAPR260918C00010000	call	10.0000	2026-09-18	1.5000	1.5000	1.5500	6.2100	77700.00	0.00	77700.00	518	5	888	4393	0.202139767812429	3.57562163526407	3.57562163526407	false	false	false	true
e76147f2-6b4f-4903-b69d-642240d3dfe6	2026-08-21 13:31	2026-08-21 13:31	2026-08-21 13:31	CAPR	CAPR260918P00007000	put	7.0000	2026-09-18	2.9000	2.7000	3.1000	6.2500	89609.00	43499.00	46110.00	309	97	389	433	0.89838337182448	3.60542140502398	3.59184092534526	true	false	false	true
262b3cd4-c493-4bed-ba4c-59b660555641	2026-08-21 13:31	2026-08-21 13:31	2026-08-21 13:31	CAPR	CAPR260918P00007000	put	7.0000	2026-09-18	2.9000	2.9000	3.1000	6.2000	13920.00	0.00	13920.00	48	16	437	433	1.00923787528868	3.5643401487364	3.5643401487364	true	false	false	true
cdbbbd2f-face-4194-8ff5-fefd036a9626	2026-08-21 13:54	2026-08-21 13:54	2026-08-21 13:54	CAPR	CAPR260918P00005000	put	5.0000	2026-09-18	1.4000	1.3500	1.4000	6.2300	21420.00	21420.00	0.00	153	11	2966	8764	0.338429940666362	3.28572289756743	3.28572289756743	false	false	false	true
07b7cc7e-05c8-4820-b951-3f2e47651b1f	2026-08-21 15:58	2026-08-21 15:57	2026-08-21 15:57	CAPR	CAPR260918C00010000	call	10.0000	2026-09-18	1.5500	1.5500	1.6500	6.2350	28985.00	0.00	28985.00	187	24	5800	4393	1.32028226724334	3.62979962365219	3.62979962365219	false	false	false	true
d639d346-6a8f-4a72-a89e-8e1e5899066e	2026-08-21 15:59	2026-08-21 15:59	2026-08-21 15:59	CAPR	CAPR260918C00010000	call	10.0000	2026-09-18	1.6000	1.5500	1.7000	6.2850	32880.00	800.00	31920.00	206	28	6096	4393	1.38766218984748	3.66470073640791	3.66470073640791	true	false	false	true
ed03a9f1-8a45-4247-b961-577aae3f2ce9	2026-08-24 09:39	2026-08-24 09:39	2026-08-24 09:39	CAPR	CAPR260918P00006000	put	6.0000	2026-09-18	0.6500	0.6000	0.8000	6.6350	11192.00	10920.00	272.00	172	29	331	1001	0.330669330669331	1.48422240464281	1.4360579258537	true	false	false	true
c55433b2-2a9f-4a5f-ac1d-5d4c877d43c3	2026-08-24 09:40	2026-08-24 09:39	2026-08-24 09:39	CAPR	CAPR260918P00006000	put	6.0000	2026-09-18	0.6500	0.6000	0.6500	6.6665	12935.00	12935.00	0.00	199	46	555	1001	0.554445554445554	1.45224587116867	1.45224587116867	true	false	false	true
2124f288-5b6c-4020-ba90-7389043199d6	2026-08-24 09:41	2026-08-24 09:41	2026-08-24 09:41	CAPR	CAPR260918P00006000	put	6.0000	2026-09-18	0.6000	0.5000	0.8000	6.6550	45120.00	1920.00	24600.00	752	67	1834	1001	1.83216783216783	1.36589354170321	1.36589354170321	true	false	false	true
b6269148-67ca-41e7-b402-7bfe2268cdc3	2026-08-24 09:45	2026-08-24 09:45	2026-08-24 09:45	CAPR	CAPR261218C00010000	call	10.0000	2026-12-18	2.1000	2.1000	2.6000	6.4050	10500.00	0.00	10500.00	50	5	50	259	0.193050193050193	2.09624641771775	2.09624641771775	false	false	false	true
e2ffa0b8-d097-4b68-9bb8-51533da70d9f	2026-08-24 12:50	2026-08-24 12:50	2026-08-24 12:50	CAPR	CAPR280121C00007000	call	7.0000	2028-01-21	4.3500	3.8000	4.6000	7.0800	47899.00	47899.00	0.00	110	19	114	7427	0.015349400834792	1.48510283881714	1.48510283881714	false	false	false	true
b6cc3970-f568-45f8-910a-9f442d5fee25	2026-08-25 12:12	2026-08-25 12:12	2026-08-25 12:12	CAPR	CAPR260918P00008000	put	8.0000	2026-09-18	1.1000	0.9000	1.1000	7.7000	12760.00	12760.00	0.00	116	10	304	462	0.658008658008658	1.19352881348209	1.19352881348209	false	false	false	true
e7d4affc-ef8d-44a1-97c4-a72ecdcef04d	2026-08-25 12:36	2026-08-25 12:36	2026-08-25 12:36	CAPR	CAPR261218P00007000	put	7.0000	2026-12-18	3.3000	3.2000	3.3000	7.9600	12540.00	12540.00	0.00	38	11	38	76	0.5	2.46963169591045	2.46963169591045	false	false	false	true
819dfdc8-41ea-41c5-98ec-155ffdf7cd62	2026-08-25 12:36	2026-08-25 12:36	2026-08-25 12:36	CAPR	CAPR261218C00008000	call	8.0000	2026-12-18	4.0000	3.3000	4.0000	7.9600	189194.00	189194.00	0.00	473	30	505	132	3.82575757575758	2.40717904065093	2.3930497800506	false	false	false	true
4c785618-4777-4a40-9d0a-44d6c7e50fd0	2026-08-25 12:36	2026-08-25 12:36	2026-08-25 12:36	CAPR	CAPR261218C00010000	call	10.0000	2026-12-18	3.5000	3.1000	3.7000	7.9600	27997.00	27647.00	350.00	80	14	232	275	0.843636363636364	2.37188778549977	2.37188778549977	false	false	false	true
eebb1bb6-05b0-4273-947b-be6ae37a3a00	2026-08-25 13:47	2026-08-25 13:47	2026-08-25 13:47	CAPR	CAPR261218C00010000	call	10.0000	2026-12-18	3.8000	3.5500	3.9000	8.1300	16340.00	1520.00	6840.00	43	19	286	275	1.04	2.48734681991378	2.48734681991378	false	false	false	true
ff17d797-3a68-4047-9dac-476e9eb6098d	2026-08-25 13:47	2026-08-25 13:47	2026-08-25 13:47	CAPR	CAPR261218C00010000	call	10.0000	2026-12-18	3.9000	3.5000	3.9000	8.1250	163410.00	163410.00	0.00	419	41	743	275	2.70181818181818	2.55428302354348	2.55428302354348	true	false	false	true