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 = UPST×

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

98c87b7b-0121-4549-ab1e-ca01c3fc4791	2026-08-24 11:28	2026-08-24 11:28	2026-08-24 11:28	UPST	UPST260918C00040000	call	40.0000	2026-09-18	0.1400	0.1400	0.1500	29.9600	11200.00	0.00	11200.00	800	6	2961	7318	0.404618748291883	0.680550403099375	0.680550403099375	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Financial Services	2539870501.00	2026-11-03	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-24T15:29:12.492303Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
5495f3e6-425a-4965-ae52-6b9dd8b69081	2026-08-24 11:14	2026-08-24 11:14	2026-08-24 11:14	UPST	UPST261218C00032500	call	32.5000	2026-12-18	3.8500	3.7500	3.8500	29.8400	24255.00	24255.00	0.00	63	22	101	713	0.141654978962132	0.708068193442626	0.708068193442626	false	false	false	true
0c400a11-8951-4ca0-8326-73e5883435d4	2026-08-24 10:09	2026-08-24 10:09	2026-08-24 10:09	UPST	UPST261218C00040000	call	40.0000	2026-12-18	2.0100	1.9000	2.0100	29.7400	25125.00	25125.00	0.00	125	19	128	1709	0.07489760093622	0.727419483411547	0.727419483411547	false	false	false	true
82684afe-113b-451d-8e1f-2c1e749dfc82	2026-08-21 15:38	2026-08-21 15:38	2026-08-21 15:38	UPST	UPST261218C00035000	call	35.0000	2026-12-18	3.4000	3.2500	3.4500	30.4600	87008.00	85648.00	1360.00	256	9	643	1205	0.533609958506224	0.70636886436663	0.707158516612426	true	false	false	true
391dc459-c439-4bbf-bc9c-788f4aa2696a	2026-08-21 15:01	2026-08-21 15:01	2026-08-21 15:01	UPST	UPST260918P00030000	put	30.0000	2026-09-18	1.7500	1.6600	1.7500	30.5300	10500.00	10500.00	0.00	60	16	761	6737	0.112958290040077	0.612811972882092	0.612811972882092	false	false	false	true
7ef1d192-3660-4ef9-817b-0b1bd9518307	2026-08-21 14:46	2026-08-21 14:45	2026-08-21 14:45	UPST	UPST260918P00030000	put	30.0000	2026-09-18	1.8000	1.7600	1.8300	30.4200	12420.00	10800.00	1260.00	69	22	624	6737	0.0926228291524417	0.61386666419817	0.61386666419817	false	false	false	true
341b9de5-204a-4f8f-b529-7693bca57512	2026-08-21 13:25	2026-08-21 13:25	2026-08-21 13:25	UPST	UPST261218C00045000	call	45.0000	2026-12-18	1.4100	1.3100	1.4200	30.1600	13112.00	12972.00	140.00	93	19	104	963	0.107995846313603	0.726576408177617	0.724013403176476	false	false	false	true
00ebe5d5-36e7-43f7-87f5-16f3e9c69db0	2026-08-21 11:27	2026-08-21 11:26	2026-08-21 11:26	UPST	UPST270115C00030000	call	30.0000	2027-01-15	5.3500	5.3000	5.5000	29.8800	12840.00	9630.00	3210.00	24	7	80	2406	0.0332502078137988	0.693291455184794	0.693291455184794	false	false	false	true
01ca1c0c-4157-4454-8336-4fa05e54c190	2026-08-21 11:19	2026-08-21 11:19	2026-08-21 11:19	UPST	UPST270115C00030000	call	30.0000	2027-01-15	5.2500	5.2000	5.3000	29.7500	12600.00	7875.00	4725.00	24	6	56	2406	0.0232751454696592	0.690209695836062	0.690209695836062	false	false	false	true
df2d227c-092d-475d-bc6d-d4b1d1a84a67	2026-08-21 11:18	2026-08-21 11:18	2026-08-21 11:18	UPST	UPST261016P00027500	put	27.5000	2026-10-16	1.6700	1.6300	1.6700	29.8000	88009.00	79659.00	0.00	527	33	561	1008	0.556547619047619	0.612203535628738	0.612203535628738	false	false	false	true
ac3aa412-a7ac-4f5e-a6a1-55ff95a741e0	2026-08-21 10:48	2026-08-21 10:48	2026-08-21 10:48	UPST	UPST261016C00027500	call	27.5000	2026-10-16	4.1000	3.8000	4.1500	29.7350	52070.00	52070.00	0.00	127	5	187	235	0.795744680851064	0.615787519224763	0.615787519224763	false	false	false	true
5cb60360-ffb8-4f64-acdc-c9302071597c	2026-08-21 10:36	2026-08-21 10:36	2026-08-21 10:36	UPST	UPST260828P00028500	put	28.5000	2026-08-28	0.5500	0.5500	0.5600	29.6000	29315.00	0.00	550.00	533	6	549	66	8.31818181818182	0.63187237164725	0.63187237164725	false	false	false	true	false
d2d7382d-e7e2-4ba9-bcf4-0fea8e688d3a	2026-08-21 10:09	2026-08-21 10:09	2026-08-21 10:09	UPST	UPST280121C00035000	call	35.0000	2028-01-21	9.3000	9.1000	9.3000	29.6700	74400.00	74400.00	0.00	80	5	130	1317	0.0987091875474563	0.755929694134902	0.755929694134902	false	false	false	true
f5e9aae9-3e71-4c20-85d3-7e056832580a	2026-08-20 11:46	2026-08-20 11:46	2026-08-20 11:46	UPST	UPST280121C00030000	call	30.0000	2028-01-21	9.6000	9.5000	9.7500	27.9700	10565.00	960.00	9605.00	11	5	47	1414	0.0332390381895332	0.754085119997583	0.753258018162376	false	false	false	true
7b590179-c100-4e3d-811c-87ff16f682c1	2026-08-20 11:05	2026-08-20 11:04	2026-08-20 11:04	UPST	UPST260918P00025000	put	25.0000	2026-09-18	0.6200	0.5800	0.6200	28.2300	68820.00	68820.00	0.00	1110	46	2015	3937	0.511811023622047	0.608181067878379	0.608181067878379	false	false	false	true
73161230-0e56-4578-a4b2-1aa4d4aed627	2026-08-20 11:03	2026-08-20 11:03	2026-08-20 11:03	UPST	UPST260828P00027000	put	27.0000	2026-08-28	0.5400	0.5200	0.5900	28.1083	22842.00	54.00	22788.00	423	21	543	65	8.35384615384615	0.616855176067872	0.618611237057109	false	false	false	true
684d883b-95af-4b66-a2ef-1ba8b9132ad3	2026-08-20 11:02	2026-08-20 11:02	2026-08-20 11:02	UPST	UPST260821P00028500	put	28.5000	2026-08-21	0.6700	0.6700	0.8100	28.1400	11725.00	0.00	11725.00	175	27	542	184	2.94565217391304	0.794966460744059	0.794966460744059	false	false	false	true
6ed9de9e-1ffe-4efe-8cf4-f83ac8099961	2026-08-20 10:59	2026-08-20 10:59	2026-08-20 10:59	UPST	UPST270219C00037500	call	37.5000	2027-02-19	2.9500	2.9500	3.0000	28.0200	10620.00	0.00	10620.00	36	6	189	508	0.372047244094488	0.710169410661381	0.710169410661381	false	false	false	true
1fdacdcd-2c76-4478-9d96-7cc7011e0159	2026-08-20 10:28	2026-08-20 10:28	2026-08-20 10:28	UPST	UPST260918P00025000	put	25.0000	2026-09-18	0.6100	0.5400	0.6300	28.1950	27114.00	27114.00	0.00	444	23	602	3937	0.152908305816612	0.601969885424539	0.604980652024381	false	false	false	true
61152e7d-3a73-47ac-b4c5-e470b52b0d91	2026-08-20 10:18	2026-08-20 10:18	2026-08-20 10:18	UPST	UPST270219C00037500	call	37.5000	2027-02-19	2.9900	2.9900	3.6000	28.1850	20935.00	1500.00	19435.00	70	6	133	508	0.261811023622047	0.707015599893201	0.707015599893201	false	false	false	true
9e450404-7095-40a2-8afb-bcec78372d69	2026-08-20 10:18	2026-08-20 10:18	2026-08-20 10:18	UPST	UPST270219C00037500	call	37.5000	2027-02-19	3.0000	3.0000	3.6000	28.1805	11706.00	0.00	11706.00	39	8	39	508	0.0767716535433071	0.708550898369091	0.708550898369091	false	false	false	true
4aa16e74-6722-4b17-8042-c3d24b14e3c0	2026-08-20 10:17	2026-08-20 10:17	2026-08-20 10:17	UPST	UPST260828C00028000	call	28.0000	2026-08-28	1.2500	1.1500	1.2500	28.3150	15500.00	15500.00	0.00	124	12	132	59	2.23728813559322	0.645399989317927	0.645399989317927	false	false	false	true
2780261e-9c6b-42fc-b1ef-7cb03b2c0b99	2026-08-20 10:17	2026-08-20 10:17	2026-08-20 10:17	UPST	UPST260828P00027500	put	27.5000	2026-08-28	0.6900	0.5900	0.6900	28.3150	21804.00	21804.00	0.00	316	37	326	126	2.58730158730159	0.641482065750429	0.641482065750429	false	false	false	true
214e6ba9-986c-420e-808b-79549c4066e4	2026-08-20 10:14	2026-08-20 10:13	2026-08-20 10:13	UPST	UPST270115P00027500	put	27.5000	2027-01-15	4.1000	3.9000	4.1500	28.5400	63550.00	63140.00	410.00	155	9	174	9898	0.0175793089513033	0.6854523878287	0.6854523878287	true	false	false	true
23d68c4b-78a2-4e36-9762-04d301fc6078	2026-08-20 10:01	2026-08-20 10:01	2026-08-20 10:01	UPST	UPST270219C00040000	call	40.0000	2027-02-19	2.8500	2.8200	2.9000	29.0000	15108.00	287.00	14821.00	53	8	53	746	0.0710455764075067	0.714904231223846	0.717491832016482	true	false	false	true
86cdaff8-e2b5-416a-b9ac-e1a9a0b8e68c	2026-08-20 09:54	2026-08-20 09:54	2026-08-20 09:54	UPST	UPST260828P00029000	put	29.0000	2026-08-28	1.0100	0.8800	1.0900	29.0950	66761.00	64539.00	0.00	661	14	1164	82	14.1951219512195	0.621889432900899	0.623245947606501	true	false	false	true
9377cd4a-3d2a-45b4-9ccd-3ac173dbaad6	2026-08-20 09:49	2026-08-20 09:49	2026-08-20 09:49	UPST	UPST260828P00029000	put	29.0000	2026-08-28	0.9000	0.8500	0.9000	29.3600	43830.00	43830.00	0.00	487	20	500	82	6.09756097560976	0.627813100490199	0.627813100490199	false	false	false	true
9217eae0-1f30-4691-b3ea-35f8b083af6d	2026-08-20 09:49	2026-08-20 09:48	2026-08-20 09:48	UPST	UPST260828C00029500	call	29.5000	2026-08-28	1.0500	1.0100	1.1600	29.4400	27720.00	0.00	27720.00	264	35	275	20	13.75	0.613901499286692	0.613901499286692	false	false	false	true	false
3d9911b6-fc8a-4014-92f1-67e04f491f52	2026-08-19 15:51	2026-08-19 15:51	2026-08-19 15:51	UPST	UPST261016C00032500	call	32.5000	2026-10-16	2.3000	2.3000	2.3600	30.7450	40480.00	0.00	40480.00	176	8	1093	425	2.57176470588235	0.603034506389824	0.603034506389824	false	false	false	true
d04f0883-e95f-499b-8bc8-1fb4f2781a65	2026-08-19 13:59	2026-08-19 13:59	2026-08-19 13:59	UPST	UPST261016C00035000	call	35.0000	2026-10-16	1.8100	1.8100	1.8800	31.5250	16109.00	0.00	16109.00	89	17	321	893	0.35946248600224	0.604784488049047	0.604784488049047	false	false	false	true
88f9fe84-b352-45bd-ae49-d5e48ca335e3	2026-08-19 12:15	2026-08-19 12:15	2026-08-19 12:15	UPST	UPST260918P00030000	put	30.0000	2026-09-18	1.4000	1.3500	1.4000	31.4300	70000.00	70000.00	0.00	500	44	621	6543	0.0949105914718019	0.591858582339293	0.591858582339293	false	false	false	true
469f1b26-f40e-4341-8bff-bac54cf15953	2026-08-19 12:12	2026-08-19 12:12	2026-08-19 12:12	UPST	UPST270319C00032500	call	32.5000	2027-03-19	6.5500	6.5500	6.8000	31.4550	43885.00	0.00	43885.00	67	6	93	594	0.156565656565657	0.70557086072435	0.70557086072435	false	false	false	true
8414e6dd-7f2d-4cd5-ae9a-73bd342c4697	2026-08-19 12:11	2026-08-19 12:11	2026-08-19 12:11	UPST	UPST270319C00032500	call	32.5000	2027-03-19	6.6000	6.6000	6.8000	31.4900	13860.00	0.00	13860.00	21	10	22	594	0.037037037037037	0.708700678293635	0.708700678293635	false	false	false	true
5badbe09-6fb6-4657-834f-ed45fca34268	2026-08-19 11:23	2026-08-19 11:23	2026-08-19 11:23	UPST	UPST260821P00030000	put	30.0000	2026-08-21	0.1800	0.1500	0.2100	31.3200	20160.00	12240.00	0.00	1120	7	1349	3214	0.419726197884256	0.700978386059772	0.700978386059772	false	false	false	true
0db1c9d8-dcda-415c-9cc6-7522be98a738	2026-08-19 10:59	2026-08-19 10:59	2026-08-19 10:59	UPST	UPST280121C00050000	call	50.0000	2028-01-21	6.9500	6.7500	6.9500	31.4220	53515.00	53515.00	0.00	77	12	101	2751	0.0367139222101054	0.747927247206562	0.747927247206562	false	false	false	true
3965ab56-bc4b-488f-8275-5baf99bbd3fc	2026-08-19 10:52	2026-08-19 10:52	2026-08-19 10:52	UPST	UPST280121C00032500	call	32.5000	2028-01-21	11.0000	10.6000	11.0000	31.2200	60495.00	60495.00	0.00	55	5	55	272	0.202205882352941	0.750900308408689	0.750900308408689	true	false	false	true
286daa5f-799c-4018-98b2-b63a4da5dadd	2026-08-19 10:47	2026-08-19 10:47	2026-08-19 10:47	UPST	UPST261218C00040000	call	40.0000	2026-12-18	2.3600	2.2600	2.5100	30.9200	17666.00	11558.00	6108.00	75	9	106	1560	0.0679487179487179	0.702314019819795	0.703840134627474	true	false	false	true
bcf8a9ea-56e6-46e8-baf3-7e688fbe0481	2026-08-19 10:46	2026-08-19 10:46	2026-08-19 10:46	UPST	UPST270115P00035000	put	35.0000	2027-01-15	7.6500	7.5500	7.6500	30.8500	14534.00	14534.00	0.00	19	7	22	2680	0.0082089552238806	0.688098256224777	0.688098256224777	false	false	false	true
d2d950b8-8ed4-45ba-bf94-51633aff2851	2026-08-19 10:45	2026-08-19 10:44	2026-08-19 10:44	UPST	UPST261016C00032500	call	32.5000	2026-10-16	2.3100	2.2000	2.3300	30.7350	34650.00	34650.00	0.00	150	5	515	425	1.21176470588235	0.60604426641894	0.60604426641894	false	false	false	true
b7aa7224-b900-4373-a34b-cbc3bf2a6e2a	2026-08-19 10:44	2026-08-19 10:44	2026-08-19 10:44	UPST	UPST260918C00030000	call	30.0000	2026-09-18	2.4300	2.1900	2.4600	30.6599	121500.00	43254.00	78246.00	500	35	689	11594	0.0594272899775746	0.58893799263414	0.587206060601158	false	false	false	true
309c01c4-89a2-4379-8654-5db55ba0efa3	2026-08-19 10:31	2026-08-19 10:31	2026-08-19 10:31	UPST	UPST261016C00032500	call	32.5000	2026-10-16	2.2200	2.2100	2.2200	30.6000	50616.00	50616.00	0.00	228	8	283	425	0.665882352941176	0.600347004778964	0.600347004778964	false	false	false	true
9c58fe03-e2db-46da-9eeb-113480bde783	2026-08-19 10:06	2026-08-19 10:06	2026-08-19 10:06	UPST	UPST270115C00035000	call	35.0000	2027-01-15	3.7500	3.6500	3.7500	30.3100	20625.00	20625.00	0.00	55	5	62	1925	0.0322077922077922	0.681693662497377	0.681693662497377	false	false	false	true
cacf78a9-9bba-40ae-931f-49a2c359cdce	2026-08-18 15:58	2026-08-18 15:58	2026-08-18 15:58	UPST	UPST280121P00025000	put	25.0000	2028-01-21	6.5000	6.4500	6.6000	29.0000	10400.00	650.00	9750.00	16	5	535	237	2.25738396624473	0.744415484286403	0.744482986001438	true	false	false	true
18892834-8074-4a74-9913-2c053c6e409f	2026-08-18 15:56	2026-08-18 15:56	2026-08-18 15:56	UPST	UPST280121P00025000	put	25.0000	2028-01-21	6.5000	6.4000	6.6500	29.0000	11050.00	0.00	11050.00	17	5	478	237	2.0168776371308	0.744482986001438	0.744482986001438	false	false	false	true
855d3a8a-053a-42ff-b7a1-7690733b8cc3	2026-08-18 15:56	2026-08-18 15:56	2026-08-18 15:56	UPST	UPST280121P00025000	put	25.0000	2028-01-21	6.5000	6.4000	6.6500	29.0000	14950.00	0.00	14950.00	23	5	461	237	1.94514767932489	0.744145353803385	0.744145353803385	false	false	false	true
0a2b0367-999b-4aaa-9645-9e26e2c3578a	2026-08-18 14:24	2026-08-18 14:24	2026-08-18 14:24	UPST	UPST270521C00030000	call	30.0000	2027-05-21	7.0500	7.0500	7.2500	28.9400	49356.00	0.00	49356.00	70	6	140	107	1.30841121495327	0.720022607802493	0.720022607802493	false	false	false	true
d641fe24-a20a-4c46-823c-38772e1a5edc	2026-08-18 11:12	2026-08-18 11:12	2026-08-18 11:12	UPST	UPST280121C00035000	call	35.0000	2028-01-21	8.9000	8.9000	9.1000	29.1650	22250.00	0.00	22250.00	25	8	63	1169	0.0538922155688623	0.747207212055362	0.747207212055362	false	false	false	true
512fecb0-84eb-4509-8da6-4486a4801356	2026-08-18 11:12	2026-08-18 11:12	2026-08-18 11:12	UPST	UPST280121C00045000	call	45.0000	2028-01-21	6.6500	6.6500	7.1500	29.1650	23940.00	0.00	23940.00	36	8	61	802	0.0760598503740648	0.743455836578579	0.743455836578579	false	false	false	true
df8d3c96-7e05-4d13-a693-b5da1ecdf0fe	2026-08-18 11:11	2026-08-18 11:11	2026-08-18 11:11	UPST	UPST280121P00020000	put	20.0000	2028-01-21	4.0500	4.0500	4.7000	29.1300	40500.00	0.00	40500.00	100	10	200	546	0.366300366300366	0.751989173942838	0.751989173942838	false	false	false	true
c1e4ad63-f8ff-4517-97b2-2d327ddafbcd	2026-08-18 11:11	2026-08-18 11:11	2026-08-18 11:11	UPST	UPST280121P00020000	put	20.0000	2028-01-21	4.0500	4.0500	4.7000	29.1300	20250.00	0.00	20250.00	50	8	100	546	0.183150183150183	0.751989173942838	0.751989173942838	false	false	false	true