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.

728,802 rows

Sources in this table

uw_flow_alerts728,802 rows

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:alert_rule = RepeatedHits×endpoint = /api/option-trades/flow-alerts×ticker = XP×

iduuid	created_at ↓timestamp with time zone	start_timetimestamp with time zone	end_timetimestamp with time zone	tickertext	option_symboltext	option_typetext	strike

e6a53b04-eab9-44c8-8c5a-7d699386e301	2026-10-02 12:57	2026-10-02 12:57	2026-10-02 12:57	XP	XP270115C00022000	call	22.0000	2027-01-15	2.1500	1.9500	2.1500	21.0600	29669.00	29669.00	0.00	138	19	194	16297	0.0119040314168252	0.541788198539963	0.541788198539963	true	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Financial Services	8930418945.00	2026-11-16	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-10-02T17:03:26.112585Z"}	2026-10-02	2026-10-02 21:15	2026-10-02 21:15
86343b3c-cc78-49ab-96ef-a8fc20a3a578	2026-10-02 12:34	2026-10-02 12:34	2026-10-02 12:34	XP	XP261016P00021000	put	21.0000	2026-10-16	1.2000	1.1500	1.2500	20.0000	32993.00	24953.00	2280.00	275	36	352	161	2.18633540372671	0.743937739448029	0.741083056376005	false	false	false
81cbc04c-2644-4b56-863b-c435ef0b2a37	2026-10-02 12:21	2026-10-02 12:21	2026-10-02 12:21	XP	XP261016P00020500	put	20.5000	2026-10-16	0.9500	0.9000	1.0000	20.0000	10735.00	10640.00	0.00	113	35	152	173	0.878612716763006	0.729550882354547	0.729550882354547	false	false	false
7489c7d7-0a2b-44b1-a02b-99088dbc7edd	2026-10-01 13:48	2026-10-01 13:48	2026-10-01 13:48	XP	XP270219P00024000	put	24.0000	2027-02-19	4.5000	4.1000	5.1000	21.1950	22047.00	13047.00	9000.00	49	8	159	0	0	0.570956530523222	0.570956530523222	false	false	false
7f65838b-8009-4667-be68-0464402c9ac0	2026-10-01 13:41	2026-10-01 13:41	2026-10-01 13:41	XP	XP261120C00023000	call	23.0000	2026-11-20	1.2500	1.2500	1.3000	21.1300	43750.00	0.00	43750.00	350	39	3101	846	3.66548463356974	0.615496152917401	0.617513260620954	false	false	false
d30678c7-d4d4-42bd-a28c-91a9e13d45d9	2026-10-01 13:36	2026-10-01 13:36	2026-10-01 13:36	XP	XP261120C00023000	call	23.0000	2026-11-20	1.2500	1.2000	1.3000	21.0800	31250.00	3750.00	27500.00	250	7	2673	846	3.15957446808511	0.6242306019661	0.6242306019661	false	false	false
5f383487-2fce-43e6-a09f-84ac61269075	2026-10-01 13:36	2026-10-01 13:35	2026-10-01 13:35	XP	XP261120C00023000	call	23.0000	2026-11-20	1.2500	1.2500	1.3500	21.0950	31250.00	0.00	31250.00	250	20	2423	846	2.86406619385343	0.622216402968538	0.622216402968538	false	false	false
271ebe56-78b4-4e49-927a-d5dd330867a4	2026-10-01 13:28	2026-10-01 13:28	2026-10-01 13:28	XP	XP270115P00022000	put	22.0000	2027-01-15	2.9000	2.7000	2.9000	21.1100	207910.00	206770.00	1140.00	717	28	717	203	3.5320197044335	0.562344333071387	0.551311239944576	false	false	false
2b705cf8-6292-421d-a30a-ce3f7ebcf70d	2026-10-01 13:10	2026-10-01 13:10	2026-10-01 13:10	XP	XP270219P00024000	put	24.0000	2027-02-19	4.6000	4.0000	6.7000	20.0000	23000.00	14260.00	8740.00	50	11	50	0	0	0.568807782279623	0.568807782279623	true	false	false
eb3cceb1-eb51-4dad-b836-b2dc76b204f2	2026-10-01 12:49	2026-10-01 12:49	2026-10-01 12:49	XP	XP261120C00023000	call	23.0000	2026-11-20	1.1500	1.1000	1.2000	20.8550	18975.00	2990.00	15985.00	165	6	1166	846	1.37825059101655	0.62064520156765	0.62064520156765	false	false	false
296fac9a-eaa2-4b05-9a5d-c259650b56e3	2026-10-01 12:48	2026-10-01 12:48	2026-10-01 12:48	XP	XP261120C00023000	call	23.0000	2026-11-20	1.1500	1.1500	1.2000	20.8800	23000.00	0.00	23000.00	200	13	801	846	0.946808510638298	0.617368722719351	0.617368722719351	false	false	false
61279625-62a5-4005-9455-8fd2bf0da2a4	2026-10-01 12:42	2026-10-01 12:41	2026-10-01 12:41	XP	XP261120C00023000	call	23.0000	2026-11-20	1.1500	1.0500	1.2000	20.7900	41975.00	41285.00	690.00	365	18	391	846	0.462174940898345	0.629155744704184	0.629155744704184	false	false	false
f534b241-8235-4227-ac35-e8770a156886	2026-09-30 15:24	2026-09-30 15:24	2026-09-30 15:24	XP	XP261120C00020000	call	20.0000	2026-11-20	2.6500	2.6500	2.7500	21.2500	48762.00	0.00	48762.00	184	22	312	7824	0.0398773006134969	0.617383359227357	0.617383359227357	false	false	false
6479066f-c8ab-4010-bdaa-bad7b31dd014	2026-09-30 13:50	2026-09-30 13:50	2026-09-30 13:50	XP	XP261002C00021000	call	21.0000	2026-10-02	0.5900	0.4000	0.6000	21.3450	162250.00	162250.00	0.00	2750	2	2821	4853	0.5812899237585	0.555980463330892	0.555980463330892	false	true	false
9ce560fb-d822-495d-af40-60118d0fd948	2026-09-30 12:53	2026-09-30 12:53	2026-09-30 12:53	XP	XP261120P00021000	put	21.0000	2026-11-20	1.7500	1.7500	1.8000	21.0000	15752.00	0.00	15752.00	90	16	91	3098	0.0293737895416398	0.608403737341306	0.60909241381304	false	false	false
37a094d4-9584-470d-b330-82ef5cfe6d44	2026-09-30 12:04	2026-09-30 12:04	2026-09-30 12:04	XP	XP261120P00020000	put	20.0000	2026-11-20	1.3500	1.3500	1.4500	20.9200	12285.00	0.00	12285.00	91	23	138	3063	0.0450538687561214	0.598841959985582	0.600090351473029	false	false	false
b63ce915-e9cd-4188-b0a2-d99ff62f8f4f	2026-09-29 15:20	2026-09-29 15:20	2026-09-29 15:20	XP	XP261120C00018000	call	18.0000	2026-11-20	3.2000	3.2000	3.4000	20.0000	91200.00	0.00	91200.00	285	15	285	533	0.534709193245779	0.622931215522543	0.622931215522543	false	false	false
4beba622-2414-480e-99a8-c7ce13d8a718	2026-09-29 14:51	2026-09-29 14:50	2026-09-29 14:50	XP	XP261120C00022000	call	22.0000	2026-11-20	1.2000	1.2000	1.3000	20.3450	11042.00	0.00	11042.00	92	24	6831	13158	0.519151846785226	0.587817971530158	0.587817971530158	false	false	false
7e08633c-818a-4b28-a9ee-c855c8247577	2026-09-29 10:02	2026-09-29 10:02	2026-09-29 10:02	XP	XP270115C00027000	call	27.0000	2027-01-15	0.5900	0.4000	0.6500	20.4250	476425.00	476425.00	0.00	8075	2	8075	27740	0.291095890410959	0.516788383686931	0.500952789304162	false	true	false
bce2eda9-7d19-4c7b-ac87-82dcc85ef886	2026-09-25 13:34	2026-09-25 13:34	2026-09-25 13:34	XP	XP270115C00022000	call	22.0000	2027-01-15	1.7500	1.6500	1.7500	20.0000	21875.00	21875.00	0.00	125	18	764	15660	0.048786717752235	0.48847870353725	0.48847870353725	false	false	false
3cb5e3fc-2da3-4692-82d2-e9e09b79f8b4	2026-09-25 12:42	2026-09-25 12:42	2026-09-25 12:42	XP	XP270115C00023000	call	23.0000	2027-01-15	1.4500	1.2500	1.4500	20.4900	29000.00	29000.00	0.00	200	11	510	4337	0.117592806087157	0.503571409404655	0.503571409404655	false	false	false
fb788932-24c1-4ed8-8da6-16da3557535b	2026-09-25 12:40	2026-09-25 12:40	2026-09-25 12:40	XP	XP270115C00022000	call	22.0000	2027-01-15	1.7500	1.6000	1.7500	20.4850	17500.00	17500.00	0.00	100	19	200	15660	0.0127713920817369	0.497356470357487	0.497356470357487	false	false	false
94d78d5b-d355-4698-9bb3-730522614642	2026-09-25 12:40	2026-09-25 12:40	2026-09-25 12:40	XP	XP270115C00022000	call	22.0000	2027-01-15	1.7500	1.6000	1.7500	20.4850	17500.00	17500.00	0.00	100	12	100	15660	0.00638569604086846	0.497356470357487	0.497356470357487	false	false	false
09b4339d-ed44-44a6-8697-2f220381502a	2026-09-24 14:20	2026-09-24 14:20	2026-09-24 14:20	XP	XP261120C00020000	call	20.0000	2026-11-20	2.3000	2.3000	2.4000	20.5400	16330.00	0.00	16330.00	71	12	184	7487	0.024575931614799	0.613060633456764	0.613060633456764	false	false	false
67246d7d-0c2a-4e23-8133-6f2526488e2e	2026-09-24 10:57	2026-09-24 10:57	2026-09-24 10:57	XP	XP280121P00010000	put	10.0000	2028-01-21	0.5000	0.3000	0.5500	20.5600	11350.00	11250.00	100.00	227	8	472	490	0.963265306122449	0.570975180711429	0.570975180711429	false	false	false
9cc90a09-c32c-4565-96d4-b110c6995640	2026-09-23 13:28	2026-09-23 13:28	2026-09-23 13:28	XP	XP261016C00023000	call	23.0000	2026-10-16	0.4800	0.4500	0.6000	21.0000	321600.00	0.00	321600.00	6700	2	6700	176	38.0681818181818	0.553726781180508	0.553726781180508	false	true	false
385d169f-374c-45dc-9336-efda42db4427	2026-09-22 10:55	2026-09-22 10:55	2026-09-22 10:55	XP	XP261120P00018000	put	18.0000	2026-11-20	0.8500	0.8500	0.9000	20.5350	31110.00	0.00	31110.00	366	20	423	1597	0.264871634314339	0.615214965235506	0.615214965235506	false	false	false
ba05f7b5-bcc8-48c1-a130-4d41c1ceed70	2026-09-21 14:00	2026-09-21 14:00	2026-09-21 14:00	XP	XP261120C00022000	call	22.0000	2026-11-20	1.4500	1.4500	1.5000	20.5950	24215.00	0.00	24215.00	167	5	644	5588	0.115246957766643	0.588992875321953	0.588992875321953	false	false	false
86afad23-a775-4e19-88cf-69c628769cd3	2026-09-18 13:06	2026-09-18 13:06	2026-09-18 13:06	XP	XP261002C00020500	call	20.5000	2026-10-02	0.5500	0.5000	0.6000	20.2250	13200.00	11935.00	0.00	240	30	347	305	1.13770491803279	0.418304389314323	0.418304389314323	false	false	false
25c21215-5866-42dc-9a15-6ed9314e1c72	2026-09-18 10:46	2026-09-18 10:46	2026-09-18 10:46	XP	XP261009C00019500	call	19.5000	2026-10-09	1.2500	1.2000	1.3000	19.8500	47250.00	1875.00	45375.00	378	14	378	57	6.63157894736842	0.553908459651822	0.553908459651822	false	false	false
f0846403-d3c3-4782-bd8b-eea9ca3d0bad	2026-09-17 13:19	2026-09-17 13:19	2026-09-17 13:19	XP	XP270115P00016000	put	16.0000	2027-01-15	0.8000	0.6500	0.8000	20.2150	27200.00	27200.00	0.00	340	30	344	700	0.491428571428571	0.5866952668599	0.5866952668599	false	false	false
9bcd0445-f177-4a10-9085-cbf667d21ac9	2026-09-17 12:33	2026-09-17 12:33	2026-09-17 12:33	XP	XP270115P00021000	put	21.0000	2027-01-15	2.8000	2.6000	2.8000	20.3000	80080.00	80080.00	0.00	286	13	286	200	1.43	0.554586059894891	0.554586059894891	false	false	false
89f87ea6-2898-46c5-85ff-5809e260c16c	2026-09-16 13:57	2026-09-16 13:56	2026-09-16 13:56	XP	XP261030C00021500	call	21.5000	2026-10-30	0.9000	0.8500	1.0500	19.0000	13770.00	4590.00	9180.00	153	5	153	0	0	0.573186686316402	0.573186686316402	false	false	false
02aa7a84-4d56-4eed-a891-ab2da35332b5	2026-09-16 13:30	2026-09-16 13:30	2026-09-16 13:30	XP	XP261120C00022000	call	22.0000	2026-11-20	1.1400	1.0500	1.1500	19.6500	11335.00	11335.00	0.00	99	7	2348	2585	0.908317214700193	0.592658666662502	0.589497786538988	false	false	false
008be3f2-4b9d-49b7-ac88-c95c71ddb535	2026-09-16 13:18	2026-09-16 13:18	2026-09-16 13:18	XP	XP261120C00026000	call	26.0000	2026-11-20	0.4000	0.3500	0.4000	19.6050	10760.00	10760.00	0.00	269	34	487	318	1.5314465408805	0.600182716113096	0.600182716113096	false	false	false
db4ba669-86a0-40f3-805d-79a1c277016b	2026-09-16 10:38	2026-09-16 10:38	2026-09-16 10:38	XP	XP261120C00020000	call	20.0000	2026-11-20	1.7000	1.6000	1.7500	19.4500	81090.00	81090.00	0.00	477	13	500	6382	0.0783453462864306	0.574259439535098	0.574259439535098	false	false	false
51580240-d543-4bd4-bf14-1d621a20fc35	2026-09-16 10:00	2026-09-16 10:00	2026-09-16 10:00	XP	XP280121P00013000	put	13.0000	2028-01-21	1.1500	0.7000	1.6500	19.3700	10580.00	4715.00	5865.00	92	10	92	707	0.13012729844413	0.51883783470223	0.51883783470223	false	false	false
76c1105c-0a4f-4c73-8b05-e70a19800c99	2026-09-15 15:51	2026-09-15 15:50	2026-09-15 15:50	XP	XP261120C00022000	call	22.0000	2026-11-20	1.0600	0.9000	1.3000	19.0000	122215.00	0.00	96915.00	1153	2	1175	1672	0.702751196172249	0.573465544706863	0.573465544706863	false	true	false
6c1b2820-0ab0-42a9-903a-5d9092ca64ca	2026-09-15 15:10	2026-09-15 15:10	2026-09-15 15:10	XP	XP261016C00020000	call	20.0000	2026-10-16	0.9500	0.9500	1.0000	19.4800	36195.00	0.00	36195.00	381	21	547	839	0.65196662693683	0.508564653244912	0.507528926213654	false	false	false
83d14c08-aa3b-4190-96bf-8abf92590b6c	2026-09-11 13:07	2026-09-11 13:07	2026-09-11 13:07	XP	XP261120P00020000	put	20.0000	2026-11-20	1.8000	1.8000	1.9500	19.8750	11700.00	0.00	11700.00	65	5	71	2561	0.027723545490043	0.523897009197754	0.523897009197754	false	false	false
ebe2749a-9135-42ea-b6e3-9de85dc31957	2026-09-10 11:15	2026-09-10 11:15	2026-09-10 11:15	XP	XP270115C00030000	call	30.0000	2027-01-15	0.3000	0.2000	0.3500	20.0250	25500.00	24000.00	1500.00	850	21	2000	9094	0.219925225423356	0.496299529926479	0.496299529926479	true	false	false
ebbd7809-43d8-465c-9c00-0e169a06b467	2026-09-10 11:13	2026-09-10 11:13	2026-09-10 11:13	XP	XP270115C00030000	call	30.0000	2027-01-15	0.3500	0.2000	0.4500	19.9850	35000.00	28000.00	7000.00	1000	52	1000	9094	0.109962612711678	0.519091808500227	0.519091808500227	true	false	false
ba2168ac-0740-4ee5-8cd1-d856554e85f6	2026-09-09 15:06	2026-09-09 15:06	2026-09-09 15:06	XP	XP261120C00020000	call	20.0000	2026-11-20	1.6000	1.5000	1.6000	19.1050	15973.00	15973.00	0.00	100	7	3610	3077	1.17322066948326	0.567447273960956	0.557134564319692	false	false	false
a83dd55e-59b3-477a-b7e9-76b06ffa40d9	2026-09-09 10:54	2026-09-09 10:54	2026-09-09 10:54	XP	XP270115C00022000	call	22.0000	2027-01-15	1.2500	1.0500	1.2500	19.0550	12500.00	12500.00	0.00	100	6	216	14404	0.0149958344904193	0.489599267860759	0.489599267860759	false	false	false
b4454922-fc70-4adb-9dbc-33c2537d362b	2026-09-09 10:53	2026-09-09 10:53	2026-09-09 10:53	XP	XP270115C00022000	call	22.0000	2027-01-15	1.2500	1.1000	1.2500	19.0450	12500.00	12500.00	0.00	100	6	116	14404	0.0080533185226326	0.490482756140441	0.490482756140441	false	false	false
43e255a5-275e-4154-93d0-e44ca9bf2136	2026-09-04 11:04	2026-09-04 11:04	2026-09-04 11:04	XP	XP261016P00019000	put	19.0000	2026-10-16	0.7500	0.7500	0.8500	19.9500	41325.00	0.00	41325.00	551	26	557	287	1.94076655052265	0.4557742076413	0.4557742076413	false	false	false
6af68fb5-45f2-4ac8-815b-c391768a7e9d	2026-09-04 10:06	2026-09-04 10:06	2026-09-04 10:06	XP	XP261120P00020000	put	20.0000	2026-11-20	2.0000	1.9000	2.0000	19.8100	12800.00	12800.00	0.00	64	6	64	1895	0.0337730870712401	0.548396428269026	0.548396428269026	false	false	false
275a2e73-4c66-41c3-8e39-631360d7b144	2026-09-04 09:42	2026-09-04 09:42	2026-09-04 09:42	XP	XP261120C00020000	call	20.0000	2026-11-20	1.9500	1.7500	1.9500	19.7200	51480.00	51480.00	0.00	264	7	1414	197	7.17766497461929	0.557762862747545	0.555503613766282	false	false	false
d7c85a0d-e210-4a70-b5fa-d7e15d28e842	2026-09-03 13:12	2026-09-03 13:12	2026-09-03 13:12	XP	XP260918C00020000	call	20.0000	2026-09-18	0.5500	0.5500	0.7000	19.9200	11000.00	0.00	11000.00	200	18	224	62	3.61290322580645	0.355908143669715	0.355908143669715	false	false	false
9a5e9a2e-a055-40c1-8a69-e24b05054a0b	2026-09-02 15:16	2026-09-02 15:16	2026-09-02 15:16	XP	XP270219C00021000	call	21.0000	2027-02-19	2.2500	2.2500	2.3000	20.0000	28800.00	0.00	28800.00	128	19	4173	69	60.4782608695652	0.464930419348942	0.464930419348942	false	false	false