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

375392b8-091a-434a-9c27-6830cb3de4e9	2026-08-25 14:31	2026-08-25 14:31	2026-08-25 14:31	CAPR	CAPR261016C00007000	call	7.0000	2026-10-16	2.2500	1.9000	2.2500	8.1300	11250.00	11250.00	0.00	50	8	63	220	0.286363636363636	1.42682004557073	1.42682004557073	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-25T18:54:14.733334Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
be3a61cc-ebdc-45d6-83c6-61f8699a76d0	2026-08-25 15:53	2026-08-25 15:52	2026-08-25 15:52	CAPR	CAPR261016C00007000	call	7.0000	2026-10-16	2.3000	1.7000	2.3000	8.1850	11500.00	11500.00	0.00	50	18	218	220	0.990909090909091	1.43708868719987	1.43708868719987	false	false	false	true	false
f1331000-a0c6-4fd9-a332-e5048e219cc7	2026-08-26 10:41	2026-08-26 10:41	2026-08-26 10:41	CAPR	CAPR261218C00020000	call	20.0000	2026-12-18	2.7500	2.7500	3.1000	9.3000	11002.00	0.00	11002.00	40	14	262	2163	0.121128062875636	2.32666118439339	2.32666118439339	false	false	false	true	false
4aabba8e-c8d6-46e5-8aee-14eb7cb66416	2026-08-27 10:40	2026-08-27 10:40	2026-08-27 10:40	CAPR	CAPR260918P00006000	put	6.0000	2026-09-18	0.1500	0.0500	0.1500	10.0400	30000.00	30000.00	0.00	2000	40	2113	3886	0.543746783324756	1.65557194252876	1.65557194252876	false	false	false	true	false
07387133-0644-4500-aad3-4b4c537089d3	2026-08-27 11:30	2026-08-27 11:30	2026-08-27 11:30	CAPR	CAPR260918C00012500	call	12.5000	2026-09-18	0.7500	0.6000	0.7500	10.3979	30000.00	30000.00	0.00	400	12	443	0	0	1.41665757652769	1.41665757652769	true	false	false	true	false
819e729b-a7bb-46ac-a3c1-f6bed72520ad	2026-08-27 15:00	2026-08-27 15:00	2026-08-27 15:00	CAPR	CAPR261218P00009000	put	9.0000	2026-12-18	4.5000	4.4500	4.6000	9.7800	17990.00	0.00	17990.00	40	5	1889	135	13.9925925925926	2.58848846197373	2.58848846197373	false	false	false	true	false
0f405294-ae5c-4453-98e4-733ad5424f77	2026-08-31 10:13	2026-08-31 10:13	2026-08-31 10:13	CAPR	CAPR261218P00009000	put	9.0000	2026-12-18	4.5000	4.5000	4.5000	9.7500	40500.00	0.00	0.00	90	5	242	1941	0.124678001030397	2.63036810081824	2.63036810081824	false	false	false	true	false
48c3c223-fa25-493f-98ec-61d1f2b1fcb1	2026-08-31 14:19	2026-08-31 14:19	2026-08-31 14:19	CAPR	CAPR261218P00009000	put	9.0000	2026-12-18	4.6000	4.3000	5.0000	9.0000	22540.00	22080.00	460.00	49	6	702	1941	0.361669242658423	2.70015024506301	2.70015024506301	false	false	false	true	false
2b2521c2-5a81-4bc5-ba7d-6e837eb42351	2026-09-01 12:55	2026-09-01 12:55	2026-09-01 12:55	CAPR	CAPR261218P00009000	put	9.0000	2026-12-18	4.4000	4.2000	4.7000	10.2794	44000.00	33440.00	10120.00	100	11	1009	2664	0.378753753753754	2.64633209521909	2.64633209521909	false	false	false	true	false
3664f314-974b-4b89-adaa-65bd67f388d5	2026-09-03 14:01	2026-09-03 14:01	2026-09-03 14:01	CAPR	CAPR261218P00009000	put	9.0000	2026-12-18	4.6000	4.5000	4.7000	9.3500	13800.00	11040.00	2760.00	30	5	379	3330	0.113813813813814	2.6745371336537	2.6745371336537	false	false	false	true	false
b786dc99-6a33-46b6-835b-432a266b3f38	2026-09-08 09:30	2026-09-08 09:30	2026-09-08 09:30	CAPR	CAPR260911P00009500	put	9.5000	2026-09-11	0.7000	0.5500	0.7000	9.0862	50890.00	50890.00	0.00	727	7	727	13	55.9230769230769	1.3879571384539	1.3879571384539	false	false	false	true	false
fdd18149-44fb-4b07-90ac-919a51926099	2026-09-08 10:01	2026-09-08 10:01	2026-09-08 10:01	CAPR	CAPR260918P00008000	put	8.0000	2026-09-18	0.2500	0.1500	0.6000	8.9700	25003.00	2800.00	4103.00	1000	8	1000	1034	0.967117988394584	1.175304681805	1.11035548255353	false	false	false	true	false
24a92bb6-e419-45bc-b734-f8b88b8e8221	2026-09-08 13:48	2026-09-08 13:48	2026-09-08 13:48	CAPR	CAPR261016C00010000	call	10.0000	2026-10-16	1.3900	1.0500	1.4000	9.1013	10180.00	9505.00	0.00	73	14	155	215	0.720930232558139	1.4793744785403	1.43665478897022	false	false	false	true	false
8565f9a0-3275-4910-9c7b-0fc57660e35c	2026-09-08 13:53	2026-09-08 13:53	2026-09-08 13:53	CAPR	CAPR261016C00010000	call	10.0000	2026-10-16	1.6000	1.1500	1.6000	9.2800	23000.00	22400.00	600.00	144	24	549	215	2.55348837209302	1.56827403604014	1.48411617259861	false	false	false	true	false
6eac6c07-a593-48d1-a6ca-771c1643963f	2026-09-10 12:47	2026-09-10 12:47	2026-09-10 12:47	CAPR	CAPR270319P00005000	put	5.0000	2027-03-19	2.1500	1.7000	2.1500	8.0000	29025.00	29025.00	0.00	135	9	154	153	1.00653594771242	2.14151260646738	2.14151260646738	false	false	false	true	false
96a82039-3588-45d6-b7be-dd6f21b39869	2026-09-11 10:47	2026-09-11 10:47	2026-09-11 10:47	CAPR	CAPR260918C00010000	call	10.0000	2026-09-18	0.1500	0.1500	0.2000	8.3100	22500.00	0.00	22500.00	1500	5	1500	9948	0.150784077201448	1.3804583943077	1.36526599596293	false	false	false	true	false
bdbbae28-ebff-424b-9852-4534b3ee602d	2026-09-14 09:30	2026-09-14 09:30	2026-09-14 09:30	CAPR	CAPR261218C00008000	call	8.0000	2026-12-18	4.7000	4.6000	7.5000	8.9550	17390.00	0.00	17390.00	37	5	47	508	0.0925196850393701	2.60744794500702	2.60744794500702	false	false	false	true	false
8ba96037-84a5-4872-b4ab-244b850f589b	2026-09-14 12:58	2026-09-14 12:58	2026-09-14 12:58	CAPR	CAPR261218P00009000	put	9.0000	2026-12-18	4.4000	4.4000	4.7000	8.8850	11000.00	0.00	11000.00	25	10	25	3931	0.00635970490969219	2.59957628329826	2.59957628329826	true	false	false	true	false
5a512e94-de91-4f9c-a246-3101963106e9	2026-09-15 09:35	2026-09-15 09:35	2026-09-15 09:35	CAPR	CAPR270115P00005000	put	5.0000	2027-01-15	1.7100	1.7000	2.0000	8.6700	10081.00	0.00	10081.00	59	5	60	2232	0.0268817204301075	2.26143878204327	2.27044168743243	false	false	false	true	false
b280b5d5-9e72-449e-a20a-6b8087657cdd	2026-09-16 09:35	2026-09-16 09:34	2026-09-16 09:34	CAPR	CAPR261218P00009000	put	9.0000	2026-12-18	4.5000	4.5000	4.7000	8.4950	16650.00	0.00	16650.00	37	16	50	3952	0.0126518218623482	2.63182592065438	2.63182592065438	true	false	false	true	false
e712b2ed-f4f3-427f-9fff-2eed8052a20e	2026-09-18 09:32	2026-09-18 09:32	2026-09-18 09:32	CAPR	CAPR261218P00009000	put	9.0000	2026-12-18	4.4000	4.3000	4.6000	9.3065	16280.00	440.00	15840.00	37	22	50	4042	0.012370113805047	2.73316265116984	2.73316265116984	true	false	false	true	false
4cc19391-cf12-40c2-a51b-274cc6621f84	2026-09-18 09:47	2026-09-18 09:47	2026-09-18 09:47	CAPR	CAPR261218P00009000	put	9.0000	2026-12-18	4.4000	4.4000	4.7000	9.2000	13200.00	0.00	13200.00	30	5	206	4042	0.0509648688767937	2.71538758318201	2.71538758318201	false	false	false	true	false
6563c896-0a22-4b26-adfc-11f9ae0ebb53	2026-09-18 10:27	2026-09-18 10:27	2026-09-18 10:27	CAPR	CAPR261218P00009000	put	9.0000	2026-12-18	4.4000	4.4000	4.7000	9.1000	81840.00	0.00	81840.00	186	11	1825	4042	0.451509153884216	2.69838451344665	2.69838451344665	true	false	false	true	false
de130c88-6f24-495e-9c04-63999f45c1e0	2026-09-18 11:09	2026-09-18 11:09	2026-09-18 11:09	CAPR	CAPR261218P00009000	put	9.0000	2026-12-18	4.4000	4.3000	4.5000	9.0850	26400.00	0.00	25960.00	60	10	3086	4042	0.763483424047501	2.69580723309959	2.69580723309959	false	false	false	true	false
2e222f09-8125-44b7-8ca5-2d85d6133994	2026-09-18 11:12	2026-09-18 11:11	2026-09-18 11:11	CAPR	CAPR261218P00010000	put	10.0000	2026-12-18	5.0000	4.8000	5.3000	9.1350	40510.00	510.00	40000.00	81	8	83	1802	0.0460599334073252	2.60631324394891	2.60631324394891	false	false	false	true	false
43e0b2fb-d928-471c-b312-de60aef0d24b	2026-09-18 11:12	2026-09-18 11:12	2026-09-18 11:12	CAPR	CAPR261016P00008000	put	8.0000	2026-10-16	0.6000	0.6000	0.8000	9.1400	19982.00	0.00	19982.00	333	14	689	89	7.74157303370786	1.17666172455967	1.153180700656	false	false	false	true	false
a7f5ea6e-c619-4873-8df8-43fb58b3c32a	2026-09-18 11:14	2026-09-18 11:14	2026-09-18 11:14	CAPR	CAPR261218P00009000	put	9.0000	2026-12-18	4.3000	4.1000	4.7000	9.1450	29240.00	430.00	28810.00	68	6	3618	4042	0.895101434933201	2.63657749271032	2.63657749271032	false	false	false	true	false
820d4294-449d-4f65-977f-1598602c6f4b	2026-09-18 15:54	2026-09-18 15:54	2026-09-18 15:54	CAPR	CAPR261218P00010000	put	10.0000	2026-12-18	5.1000	5.1000	5.3000	8.0000	51000.00	0.00	51000.00	100	8	1385	1802	0.768590455049944	2.64006586584701	2.64006586584701	false	false	false	true	false
c8439cca-9a2b-4719-8fb7-c8c2ea69142c	2026-09-21 10:53	2026-09-21 10:53	2026-09-21 10:53	CAPR	CAPR261218C00010000	call	10.0000	2026-12-18	3.9000	3.7000	4.6000	8.9350	12100.00	400.00	11700.00	31	9	31	4726	0.00655945831570038	2.52064840789509	2.52064840789509	false	false	false	true	false
a2f2d310-82ba-43e7-ba2f-5de617cf4719	2026-09-22 10:16	2026-09-22 10:15	2026-09-22 10:15	CAPR	CAPR261218P00006000	put	6.0000	2026-12-18	2.1000	2.1000	2.3000	9.3000	84000.00	0.00	84000.00	400	12	1201	384	3.12760416666667	2.57682505496295	2.57682505496295	false	false	false	true	false
2d28e912-baca-4930-9068-ef4d511a80f5	2026-09-22 11:29	2026-09-22 11:29	2026-09-22 11:29	CAPR	CAPR260925C00010000	call	10.0000	2026-09-25	0.1500	0.0500	0.2500	9.0000	12420.00	12405.00	0.00	828	6	926	205	4.51707317073171	1.05115896089255	1.05115896089255	false	false	false	true	false
f12f8383-d464-497b-97c5-0d7b0e748b05	2026-09-22 12:42	2026-09-22 12:41	2026-09-22 12:41	CAPR	CAPR261218P00010000	put	10.0000	2026-12-18	5.0000	4.3000	5.2000	9.4500	49500.00	39000.00	10500.00	99	5	106	2175	0.048735632183908	2.71935522991317	2.71935522991317	false	false	false	true	false