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:alert_rule = RepeatedHits×ticker = XP×

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

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	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Financial Services	8809962131.00	2026-11-16	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-22T14:56:01.933088Z"}	2026-09-22	2026-09-22 21:15	2026-09-22 21:15
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	true
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	true
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	true
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	true
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	true	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	true	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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
404c9239-738c-41b8-8ff2-b8cd4f70d532	2026-09-02 13:08	2026-09-02 13:08	2026-09-02 13:08	XP	XP270219C00021000	call	21.0000	2027-02-19	2.1500	2.1500	2.2500	19.8250	116315.00	0.00	116315.00	541	36	3825	69	55.4347826086956	0.463183267561339	0.463183267561339	false	false	false	true
5b9b46a9-852c-4e82-94a4-1831b648f17d	2026-09-02 12:45	2026-09-02 12:45	2026-09-02 12:45	XP	XP260925C00021500	call	21.5000	2026-09-25	0.2500	0.2500	0.4000	19.7950	12028.00	0.00	12028.00	481	24	967	15	64.4666666666667	0.400734443734761	0.400734443734761	false	false	false	true
e224d7f0-a5bf-42eb-90ae-88695a3d1ace	2026-09-02 12:44	2026-09-02 12:43	2026-09-02 12:43	XP	XP270219C00021000	call	21.0000	2027-02-19	2.2000	2.1000	2.2000	19.8200	285560.00	285560.00	0.00	1298	9	3250	69	47.1014492753623	0.472927645430001	0.472927645430001	false	false	false	true
0034c4c7-4091-4f60-915d-737fd5522bd6	2026-09-02 12:42	2026-09-02 12:42	2026-09-02 12:42	XP	XP270219C00021000	call	21.0000	2027-02-19	2.2000	1.9500	2.2000	19.8000	240460.00	240460.00	0.00	1093	7	1951	69	28.2753623188406	0.474832050125345	0.474832050125345	false	false	false	true
d3e0c382-ceb4-4b48-acec-285ad0cf65d1	2026-09-02 12:18	2026-09-02 12:18	2026-09-02 12:18	XP	XP261120P00020000	put	20.0000	2026-11-20	2.0000	1.9000	2.1000	19.8250	38600.00	1000.00	37600.00	193	22	835	39	21.4102564102564	0.544096946954407	0.544096946954407	false	false	false	true
74621081-d7cd-4862-b8a3-0dace6696ddf	2026-09-02 12:16	2026-09-02 12:16	2026-09-02 12:16	XP	XP270115C00020000	call	20.0000	2027-01-15	2.4000	2.3000	2.4000	19.7950	33600.00	33600.00	0.00	140	7	802	40992	0.0195647931303669	0.496045933506528	0.496045933506528	false	false	false	true
db224d93-43e5-46af-9c78-d478c4818cff	2026-09-02 10:59	2026-09-02 10:59	2026-09-02 10:59	XP	XP261016C00022000	call	22.0000	2026-10-16	0.6000	0.5000	0.6500	19.8000	41820.00	37740.00	4080.00	697	20	698	1	698	0.490706301330742	0.48817237390315	true	false	false	true
a191e0cd-6372-41c4-b40a-6d7f2bd0a3d1	2026-09-01 13:33	2026-09-01 13:33	2026-09-01 13:33	XP	XP270115C00020000	call	20.0000	2027-01-15	1.7500	1.7500	1.8500	18.8900	10150.00	0.00	10150.00	58	12	378	40920	0.0092375366568915	0.455363954450151	0.455363954450151	false	false	false	true
940ed84d-9555-4db9-8653-03a7d1f42723	2026-09-01 10:34	2026-09-01 10:34	2026-09-01 10:34	XP	XP270115C00022000	call	22.0000	2027-01-15	1.2000	1.0000	1.2500	19.0250	16560.00	6000.00	10560.00	138	6	138	14251	0.00968353098028209	0.463240054494615	0.463240054494615	false	false	false	true
d3bae909-7709-4748-8a1a-2b9e04a5f51e	2026-08-31 15:53	2026-08-31 15:53	2026-08-31 15:53	XP	XP260918C00018500	call	18.5000	2026-09-18	0.5500	0.5000	0.5500	18.3850	41910.00	41910.00	0.00	762	6	1546	11	140.545454545455	0.361014681286147	0.361014681286147	false	false	false	true
b944a19c-90f4-4bc3-860d-ebbe04e7005d	2026-08-27 12:02	2026-08-27 12:02	2026-08-27 12:02	XP	XP270219P00020000	put	20.0000	2027-02-19	3.7000	3.5000	3.8000	17.6200	25530.00	7030.00	18500.00	69	5	94	133	0.706766917293233	0.502193277175128	0.502193277175128	false	false	false	true
c61b3104-f68e-41fb-9ed8-7ab81867352f	2026-08-27 11:58	2026-08-27 11:58	2026-08-27 11:58	XP	XP261120P00018000	put	18.0000	2026-11-20	1.9000	1.7500	1.9500	17.6400	18810.00	9500.00	9310.00	99	18	193	1069	0.180542563143124	0.527375563844526	0.528065677051782	false	false	false	true
ad05e480-26a5-427f-b8e6-d4373d171b4b	2026-08-27 10:14	2026-08-27 10:14	2026-08-27 10:14	XP	XP261016P00019000	put	19.0000	2026-10-16	2.0000	1.7500	2.3000	17.6900	12200.00	10000.00	2200.00	61	7	61	76	0.802631578947368	0.484235976683902	0.484235976683902	false	false	false	true
3eb68627-deef-4dcb-96ef-8ad629fc9711	2026-08-27 10:13	2026-08-27 10:13	2026-08-27 10:13	XP	XP261120P00019000	put	19.0000	2026-11-20	2.4500	2.3000	2.5500	17.6900	22295.00	4655.00	17640.00	91	5	91	190	0.478947368421053	0.520194558340735	0.520194558340735	false	false	false	true
7d347f04-5208-4647-b84e-5f46bf1983b9	2026-08-26 14:54	2026-08-26 14:54	2026-08-26 14:54	XP	XP270115C00025000	call	25.0000	2027-01-15	0.4000	0.3500	0.4000	17.8700	35996.00	35996.00	0.00	900	48	1000	21636	0.0462192641893141	0.461437419143303	0.461138575117889	false	false	false	true
53937624-1538-4bb6-b399-e8d5632f98f9	2026-08-26 12:11	2026-08-26 12:11	2026-08-26 12:11	XP	XP261016P00019000	put	19.0000	2026-10-16	1.9000	1.8000	1.9500	17.8450	14250.00	9500.00	4560.00	75	14	75	1	75	0.477314649947221	0.477314649947221	false	false	false	true	false
3187997d-5ca8-491a-b67b-d60eda2a2ab9	2026-08-26 11:54	2026-08-26 11:54	2026-08-26 11:54	XP	XP270219P00020000	put	20.0000	2027-02-19	3.6000	2.1500	4.0000	17.8100	13320.00	5400.00	7920.00	37	9	37	6	6.16666666666667	0.502006784803717	0.502006784803717	false	false	false	true
54715aa7-9b6b-4d53-95e0-c2017ee7135d	2026-08-25 14:52	2026-08-25 14:52	2026-08-25 14:52	XP	XP260918C00017000	call	17.0000	2026-09-18	1.0000	1.0000	1.0500	17.5600	15400.00	0.00	15400.00	154	25	555	5861	0.0946937382699198	0.371321787424605	0.371321787424605	false	false	false	true
c23b22ed-646a-42bd-805e-5643636a0899	2026-08-25 11:57	2026-08-25 11:57	2026-08-25 11:57	XP	XP280121P00020000	put	20.0000	2028-01-21	5.2000	4.5000	5.4500	17.4150	244400.00	244400.00	0.00	470	10	470	94	5	0.527365139796906	0.527365139796906	false	false	false	true	false
4232469b-26a7-4f5a-8f9c-df7abcd07755	2026-08-25 11:57	2026-08-25 11:57	2026-08-25 11:57	XP	XP280121P00020000	put	20.0000	2028-01-21	5.2000	4.5000	5.2000	17.4150	11960.00	11960.00	0.00	23	5	493	94	5.24468085106383	0.527365139796906	0.527365139796906	false	false	false	true
eb7b7884-cbb9-4a6a-a0ed-7425777b0612	2026-08-25 11:24	2026-08-25 11:24	2026-08-25 11:24	XP	XP261120P00018000	put	18.0000	2026-11-20	2.1000	2.0000	2.1500	17.1600	15120.00	10500.00	4620.00	72	12	72	997	0.0722166499498496	0.512516907344605	0.512516907344605	false	false	false	true
da7e5abd-b822-4306-ad8e-26bc4a801218	2026-08-25 11:06	2026-08-25 11:06	2026-08-25 11:06	XP	XP261016P00017000	put	17.0000	2026-10-16	1.1000	0.9000	1.1500	17.1550	20240.00	110.00	20130.00	184	6	184	16	11.5	0.476128327004566	0.476128327004566	false	false	false	true
23b80764-d9ba-4535-8d17-67cf7201119a	2026-08-24 14:39	2026-08-24 14:39	2026-08-24 14:39	XP	XP261120P00017000	put	17.0000	2026-11-20	1.5500	1.5500	1.6000	17.1350	10385.00	0.00	10385.00	67	16	420	70	6	0.509967208578467	0.509967208578467	false	false	false	true	false
3a6a5231-ee46-4947-abc4-02b97f251e82	2026-08-24 13:31	2026-08-24 13:31	2026-08-24 13:31	XP	XP270219P00017000	put	17.0000	2027-02-19	2.1600	2.0000	2.2500	17.2150	12942.00	1505.00	11437.00	60	9	126	51	2.47058823529412	0.512062587231352	0.512062587231352	false	false	false	true
098dddfb-17eb-45d5-9f47-38063e0bc277	2026-08-24 13:20	2026-08-24 13:19	2026-08-24 13:19	XP	XP270219P00019000	put	19.0000	2027-02-19	3.3000	3.3000	3.4000	17.2500	18814.00	0.00	18814.00	57	9	71	48	1.47916666666667	0.51117502050605	0.51117502050605	false	false	false	true
ad839ae9-1d3f-4958-9058-374f0ece66a8	2026-08-24 10:42	2026-08-24 10:42	2026-08-24 10:42	XP	XP260918C00018000	call	18.0000	2026-09-18	0.4500	0.3500	0.4500	17.3600	22005.00	22005.00	0.00	489	9	657	4537	0.144809345382411	0.383917358237475	0.383917358237475	true	false	false	true