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:er_time = unknown×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	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	true	false
80b765aa-ab8c-45ff-9388-19fb88bf413f	2026-09-18 11:32	2026-09-18 11:32	2026-09-18 11:32	XP	XP270115C00027000	call	27.0000	2027-01-15	0.6000	0.4500	0.6500	20.0550	126720.00	126720.00	0.00	2112	1	2112	24017	0.0879377107881917	0.514504395120131	0.514504395120131	false	true	false	true	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	true	false
80e5d5cb-40b0-480b-92de-5b2ea85b2b5f	2026-09-17 14:15	2026-09-17 14:15	2026-09-17 14:15	XP	XP261120C00025000	call	25.0000	2026-11-20	0.6600	0.6500	0.7000	20.2750	1320000.00	0.00	1320000.00	20000	4	71181	122118	0.582887043679065	0.596826720801548	0.596826720801548	false	true	true	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	true	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	true	false
a087c242-ee28-4329-b8f4-a36bfdf0f4dd	2026-09-17 09:54	2026-09-17 09:54	2026-09-17 09:54	XP	XP261120C00022000	call	22.0000	2026-11-20	1.2000	1.0500	1.2000	19.7100	76510.00	67990.00	0.00	638	20	638	4850	0.131546391752577	0.607118516101126	0.602727885489835	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	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	true	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	true	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	true	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	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	true	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	true	false
b21b62e0-02d4-4663-af4a-88b6fb2c9354	2026-09-11 10:24	2026-09-11 10:24	2026-09-11 10:24	XP	XP261120C00025000	call	25.0000	2026-11-20	0.5700	0.5000	0.5500	19.9350	71010.00	71010.00	0.00	1235	2	1600	529	3.02457466918715	0.558696771564003	0.577782318813593	false	true	false	true	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	true	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	true	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	true	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	true	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	true	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	true	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	true	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	true	false
1594d427-3c1a-4cc2-b073-78fa5eba6ccb	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	2.0000	19.7050	224229.00	205509.00	18720.00	1150	54	1150	197	5.83756345177665	0.563023971583988	0.557762862747545	false	false	false	true	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	true	false
ea424c19-af5b-4e94-949b-ff3be1ef4d76	2026-09-03 09:45	2026-09-03 09:45	2026-09-03 09:45	XP	XP260918C00021000	call	21.0000	2026-09-18	0.4000	0.3500	0.4500	20.4100	38333.00	5280.00	33053.00	958	36	1068	118	9.05084745762712	0.382816747061681	0.382816747061681	false	false	false	true	false
10b7df60-b17e-4580-b3a3-64fd4bd861c0	2026-09-03 09:42	2026-09-03 09:41	2026-09-03 09:41	XP	XP261120C00021000	call	21.0000	2026-11-20	1.8700	1.7500	1.9500	20.2900	1870000.00	760000.00	0.00	10000	2	10000	36191	0.276311790224089	0.570591884657632	0.570591884657632	false	true	false	true	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	true	false
86f3f6b7-b50a-4ab5-986d-31dc495cfac1	2026-09-02 13:53	2026-09-02 13:53	2026-09-02 13:53	XP	XP261120P00020000	put	20.0000	2026-11-20	2.0500	2.0000	2.1500	19.7750	183463.00	37298.00	73800.00	895	32	1830	39	46.9230769230769	0.554712303738492	0.55161184038801	false	false	false	true	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
283a88e2-9e2e-408f-80c1-d8d00a7bdbbd	2026-09-02 10:36	2026-09-02 10:36	2026-09-02 10:36	XP	XP260918C00020500	call	20.5000	2026-09-18	0.4000	0.3000	0.4500	19.8700	24233.00	24233.00	0.00	606	41	606	0	0	0.398485041834132	0.389035392077855	true	false	false	true	false
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	false
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	false
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	false
f045c913-a9be-447f-b060-f2b31cbc12bc	2026-08-31 12:09	2026-08-31 12:09	2026-08-31 12:09	XP	XP270115P00021000	put	21.0000	2027-01-15	3.8000	3.8000	3.9000	18.3950	43714.00	0.00	43714.00	115	15	119	1	119	0.518884246919486	0.518884246919486	false	false	false	true	false
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	false
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	false
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	false
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	false
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	false
16c4be1f-f709-4fcc-8f9a-43ab2cfeffa4	2026-08-26 12:19	2026-08-26 12:19	2026-08-26 12:19	XP	XP270219P00019000	put	19.0000	2027-02-19	2.9000	2.9000	3.1000	17.8300	52857.00	0.00	52857.00	182	15	195	134	1.45522388059702	0.490867774263056	0.490867774263056	false	false	false	true	false