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:source = uw_flow_alerts×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

0966aeb6-22ad-4367-9be8-cefc7b272d58	2026-09-03 11:52	2026-09-03 11:52	2026-09-03 11:52	UPST	UPST270115C00030000	call	30.0000	2027-01-15	4.1000	4.0000	4.1000	28.2100	47550.00	47145.00	405.00	116	22	861	2427	0.354758961681088	0.686991424411402	0.679628899890569	false	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	Common Stock	Financial Services	2539870501.00	2026-11-03	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-03T16:03:37.205690Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
42dfa082-394d-45f6-8ac9-a5ad4849ee6c	2026-09-03 11:51	2026-09-03 11:51	2026-09-03 11:51	UPST	UPST270115C00030000	call	30.0000	2027-01-15	4.1000	4.1000	4.1500	28.2200	151700.00	0.00	7790.00	370	6	715	2427	0.294602389781623	0.686200961671608	0.686200961671608	false	false	false	true
8efc9e9a-6f5b-4bc8-b571-08179f0c9487	2026-09-03 11:51	2026-09-03 11:51	2026-09-03 11:51	UPST	UPST270115C00030000	call	30.0000	2027-01-15	4.1000	4.0500	4.1000	28.2400	127100.00	16400.00	0.00	310	75	345	2427	0.142150803461063	0.684619927735974	0.684619927735974	false	false	false	true
7504c1a2-eed6-4520-8b4b-95ae4e617657	2026-09-03 10:52	2026-09-03 10:52	2026-09-03 10:52	UPST	UPST260918P00030000	put	30.0000	2026-09-18	2.4600	2.3600	2.4600	28.2435	139974.00	139974.00	0.00	569	55	572	7513	0.0761346998535871	0.615525049252758	0.615525049252758	false	false	false	true
795d3314-16f7-4f02-bd0d-7f328246abb3	2026-09-03 10:21	2026-09-03 10:21	2026-09-03 10:21	UPST	UPST260904C00028000	call	28.0000	2026-09-04	0.6500	0.6500	0.7000	28.3550	18720.00	0.00	18720.00	288	40	368	997	0.369107321965898	0.762371076212046	0.762371076212046	false	false	false	true
4824cc42-39de-4559-b8d3-84cb3a385354	2026-09-03 09:54	2026-09-03 09:54	2026-09-03 09:54	UPST	UPST261218C00035000	call	35.0000	2026-12-18	2.2800	2.2600	2.2800	28.5100	17784.00	1368.00	0.00	78	18	448	2009	0.222996515679443	0.702117019502437	0.702117019502437	false	false	false	true
1205eec5-220e-4460-aed8-199a6431c1f4	2026-09-03 09:54	2026-09-03 09:53	2026-09-03 09:53	UPST	UPST261218C00035000	call	35.0000	2026-12-18	2.3000	2.2700	2.3000	28.5400	24610.00	17940.00	0.00	107	20	370	2009	0.184171229467397	0.703627646783605	0.703627646783605	false	false	false	true
f739fb02-dd11-489f-ba74-56b703404ee5	2026-09-03 09:53	2026-09-03 09:53	2026-09-03 09:53	UPST	UPST261218C00035000	call	35.0000	2026-12-18	2.3200	2.2400	2.3200	28.5650	30392.00	7192.00	0.00	131	23	196	2009	0.0975609756097561	0.705448034944456	0.705448034944456	false	false	false	true
7c6b2f61-7d31-448d-9a0d-b8d99af519bf	2026-09-03 09:53	2026-09-03 09:53	2026-09-03 09:53	UPST	UPST261218C00035000	call	35.0000	2026-12-18	2.3500	2.2400	2.3500	28.6050	15275.00	7285.00	0.00	65	12	65	2009	0.0323544051767048	0.707997466678363	0.707997466678363	false	false	false	true
e52dd6d3-ef7f-4d10-9982-d2cc9ce9a1cf	2026-09-02 15:49	2026-09-02 15:49	2026-09-02 15:49	UPST	UPST260904C00028000	call	28.0000	2026-09-04	0.7000	0.6300	0.7400	28.1700	14000.00	840.00	630.00	200	19	804	416	1.93269230769231	0.73324978875117	0.73324978875117	false	false	false	true
9cb99e7e-7050-4762-ad80-2caf1f6bd01d	2026-09-02 10:44	2026-09-02 10:44	2026-09-02 10:44	UPST	UPST260904C00028000	call	28.0000	2026-09-04	0.7800	0.7800	0.7900	28.2800	14430.00	0.00	14430.00	185	27	499	416	1.19951923076923	0.754327296393616	0.754327296393616	false	false	false	true
66561494-70f6-4e90-814f-728f9fd31e4d	2026-09-02 10:44	2026-09-02 10:44	2026-09-02 10:44	UPST	UPST260904C00028000	call	28.0000	2026-09-04	0.7600	0.7600	0.7800	28.2300	10731.00	1078.00	1444.00	141	11	231	416	0.555288461538462	0.765107168808598	0.777288709417242	false	false	false	true
5522ef53-d17f-43bd-bea9-2d5ce58d48b9	2026-09-02 10:43	2026-09-02 10:43	2026-09-02 10:43	UPST	UPST260911C00028500	call	28.5000	2026-09-11	0.9100	0.8400	0.9800	28.1700	47136.00	89.00	47047.00	518	46	536	3	178.666666666667	0.587877728089214	0.583249641605505	false	false	false	true
d674155a-3d0b-495d-89f9-785017652c4f	2026-09-02 10:32	2026-09-02 10:32	2026-09-02 10:32	UPST	UPST270219C00030000	call	30.0000	2027-02-19	5.1000	4.9500	5.1000	28.1700	29059.00	29059.00	0.00	57	16	64	163	0.392638036809816	0.736499075879495	0.736499075879495	false	false	false	true
fe998133-8ea6-495c-b37f-b5b3712cbe17	2026-09-01 14:35	2026-09-01 14:35	2026-09-01 14:35	UPST	UPST260911P00027500	put	27.5000	2026-09-11	1.1700	1.0400	1.1700	27.3100	26325.00	26325.00	0.00	225	24	247	34	7.26470588235294	0.601569749050541	0.601569749050541	false	false	false	true
d950dd8a-d8d9-4ae6-ae57-1c7755ec27e6	2026-09-01 14:35	2026-09-01 14:35	2026-09-01 14:35	UPST	UPST260918P00027500	put	27.5000	2026-09-18	1.4800	1.2800	1.5600	27.2950	52978.00	52831.00	147.00	358	44	378	4664	0.0810463121783876	0.597910630347655	0.590519871035092	true	false	false	true
cfc90374-78ee-4c19-ac84-c62b79c975c9	2026-09-01 14:35	2026-09-01 14:35	2026-09-01 14:35	UPST	UPST260918P00025500	put	25.5000	2026-09-18	0.6300	0.5400	0.6600	27.2950	12728.00	12663.00	65.00	202	30	207	6	34.5	0.600012273730619	0.608124508645609	true	false	false	true
f5c93dcf-5207-4960-858e-63490e3188b2	2026-09-01 12:49	2026-09-01 12:49	2026-09-01 12:49	UPST	UPST260904C00028000	call	28.0000	2026-09-04	0.5000	0.5000	0.5300	27.5800	17100.00	0.00	17100.00	342	43	432	48	9	0.682799960206276	0.682799960206276	false	false	false	true
f41574f8-cdbe-4703-8299-09368db1890d	2026-09-01 10:28	2026-09-01 10:28	2026-09-01 10:28	UPST	UPST270115P00027500	put	27.5000	2027-01-15	4.1500	4.0000	4.1500	28.2700	11620.00	11620.00	0.00	28	5	29	9975	0.00290726817042607	0.704882893089183	0.704882893089183	false	false	false	true
61e12fe9-0bb9-45b6-afe6-599890011183	2026-08-31 15:42	2026-08-31 15:42	2026-08-31 15:42	UPST	UPST270521P00030000	put	30.0000	2027-05-21	7.2000	7.1000	7.3000	28.7350	36000.00	0.00	0.00	50	5	90	418	0.215311004784689	0.726783008540511	0.726783008540511	false	false	false	true
79e39cc5-9101-4860-b714-1000564662d5	2026-08-31 14:03	2026-08-31 14:02	2026-08-31 14:02	UPST	UPST280121C00062500	call	62.5000	2028-01-21	4.1500	3.8000	4.1500	28.0000	14108.00	14108.00	0.00	34	7	35	298	0.11744966442953	0.753290146248159	0.753290146248159	false	false	false	true
8c530130-5596-4489-b65d-101f27a0aaf5	2026-08-31 12:00	2026-08-31 12:00	2026-08-31 12:00	UPST	UPST260918P00032500	put	32.5000	2026-09-18	4.1000	4.0500	4.1000	28.8204	46740.00	46740.00	0.00	114	22	124	904	0.13716814159292	0.634317720403003	0.634317720403003	false	false	false	true
acda5aa5-d6da-45da-a179-d4cf8bc8f1e2	2026-08-31 09:58	2026-08-31 09:58	2026-08-31 09:58	UPST	UPST260904P00026000	put	26.0000	2026-09-04	0.1500	0.1500	0.1800	28.1483	18315.00	0.00	18315.00	1221	47	1350	152	8.88157894736842	0.717554632664802	0.717554632664802	false	false	false	true
12a91601-7ffd-4259-b04d-15d15e128fcd	2026-08-31 09:35	2026-08-31 09:35	2026-08-31 09:35	UPST	UPST261016C00025000	call	25.0000	2026-10-16	4.5000	4.3000	4.5000	28.2900	179099.00	18449.00	0.00	398	21	500	148	3.37837837837838	0.640002820940384	0.645501842196228	true	false	false	true
3d4d6fb8-f4f0-4974-afb5-9721b47d92c0	2026-08-28 15:44	2026-08-28 15:44	2026-08-28 15:44	UPST	UPST270521C00032500	call	32.5000	2027-05-21	6.3000	6.3000	6.5000	29.1200	56702.00	0.00	56702.00	90	17	151	665	0.227067669172932	0.733751661701348	0.733751661701348	false	false	false	true
2382050d-0a44-421e-9619-64cb44b2548a	2026-08-28 15:40	2026-08-28 15:40	2026-08-28 15:40	UPST	UPST270219C00037500	call	37.5000	2027-02-19	3.4000	3.4000	3.6500	29.1550	26180.00	0.00	26180.00	77	5	81	593	0.136593591905565	0.726731304086471	0.726731304086471	false	false	false	true
72944a6a-013b-4e2b-80b4-64bf7643bbfc	2026-08-28 15:21	2026-08-28 15:21	2026-08-28 15:21	UPST	UPST260904P00025000	put	25.0000	2026-09-04	0.0400	0.0200	0.0400	29.1800	4000.00	4000.00	0.00	1000	1	1449	355	4.08169014084507	0.644865497808047	0.644865497808047	false	true	false	true
bb9bf9dc-eae5-4e32-95d6-b3166edaefed	2026-08-28 13:35	2026-08-28 13:35	2026-08-28 13:35	UPST	UPST270319C00040000	call	40.0000	2027-03-19	3.3000	3.3000	3.5000	29.2300	17825.00	335.00	17490.00	54	6	107	751	0.142476697736352	0.720359344071211	0.720359344071211	false	false	false	true
3bf7d9ce-e4cc-4d82-9edb-55600b53ec24	2026-08-28 13:09	2026-08-28 13:09	2026-08-28 13:09	UPST	UPST281215C00040000	call	40.0000	2028-12-15	10.5700	10.3500	11.3000	29.3400	19020.00	4215.00	14805.00	18	6	268	10	26.8	0.736832250951571	0.724806296522012	false	false	false	true
5625a058-c65c-4710-ab11-d4a4296e00d1	2026-08-28 12:19	2026-08-28 12:19	2026-08-28 12:19	UPST	UPST260918P00032500	put	32.5000	2026-09-18	3.6500	3.5000	3.6500	29.5600	60590.00	60590.00	0.00	166	10	168	906	0.185430463576159	0.633952673053385	0.633952673053385	false	false	false	true
75967405-28de-422d-ab92-75f04785ab60	2026-08-28 11:54	2026-08-28 11:54	2026-08-28 11:54	UPST	UPST260925P00030000	put	30.0000	2026-09-25	2.0000	1.8200	2.0000	29.0000	11200.00	11200.00	0.00	56	20	59	72	0.819444444444444	0.598352210455652	0.598352210455652	true	false	false	true
bce74777-9648-4185-8602-d5dd91cdc265	2026-08-28 11:40	2026-08-28 11:40	2026-08-28 11:40	UPST	UPST281215C00040000	call	40.0000	2028-12-15	11.0500	11.0500	11.4500	30.0000	28731.00	0.00	28731.00	26	7	201	10	20.1	0.731171692553125	0.731171692553125	false	false	false	true
ab4c513f-15c6-4345-81fd-8de147ed0336	2026-08-28 11:20	2026-08-28 11:20	2026-08-28 11:20	UPST	UPST281215C00040000	call	40.0000	2028-12-15	11.4600	11.4500	12.4000	30.4201	11456.00	0.00	11456.00	10	6	83	10	8.3	0.745576174160542	0.742625198337762	false	false	false	true
5cb6493e-67ad-4171-8b58-cabfcbba3d32	2026-08-28 11:20	2026-08-28 11:20	2026-08-28 11:20	UPST	UPST281215C00040000	call	40.0000	2028-12-15	11.4500	11.4500	12.4000	30.4201	24045.00	0.00	24045.00	21	5	105	10	10.5	0.742625198337762	0.742625198337762	false	false	false	true
018341ae-8ea8-4cf7-96f2-5fd80d07e9f8	2026-08-28 11:11	2026-08-28 11:11	2026-08-28 11:11	UPST	UPST261016P00030000	put	30.0000	2026-10-16	2.4200	2.4000	2.4800	30.4400	16715.00	6063.00	10652.00	69	31	497	1714	0.289964994165694	0.615512575873583	0.615512575873583	false	false	false	true
acf5063c-3ef3-4a33-9bbc-e14b86c7fa36	2026-08-28 09:42	2026-08-28 09:42	2026-08-28 09:42	UPST	UPST261016P00030000	put	30.0000	2026-10-16	2.1900	2.0700	2.1900	31.1039	90009.00	90009.00	0.00	411	45	412	1714	0.240373395565928	0.624002619448802	0.624002619448802	false	false	false	true
45975fad-45e2-4c6e-8957-1d7595f55d35	2026-08-27 14:46	2026-08-27 14:46	2026-08-27 14:46	UPST	UPST270219C00030000	call	30.0000	2027-02-19	6.1500	6.1500	6.3000	30.0800	26455.00	0.00	26455.00	43	5	44	64	0.6875	0.713503810571991	0.714755999565968	false	false	false	true
41517fea-aa4b-470a-a652-ca1a72280a0c	2026-08-27 11:35	2026-08-27 11:34	2026-08-27 11:34	UPST	UPST270115C00032500	call	32.5000	2027-01-15	4.9500	4.9000	5.0000	31.0700	12375.00	0.00	8910.00	25	6	35	1091	0.0320806599450046	0.69680074981669	0.69680074981669	false	false	false	true
d992fdb9-150d-4f6b-babb-62113426319b	2026-08-27 10:56	2026-08-27 10:55	2026-08-27 10:55	UPST	UPST280121C00030000	call	30.0000	2028-01-21	11.9000	11.5500	12.0500	31.2950	38095.00	4760.00	33335.00	32	7	33	1491	0.0221327967806841	0.759048204202807	0.759840205803532	false	false	false	true
e7cc61c2-2864-486e-b549-bf0f880420f4	2026-08-27 10:36	2026-08-27 10:36	2026-08-27 10:36	UPST	UPST260918C00035000	call	35.0000	2026-09-18	0.6600	0.6200	0.6600	31.1700	36564.00	36564.00	0.00	554	53	597	7481	0.0798021654858976	0.619303553056161	0.619303553056161	false	false	false	true
141a8b6e-2df7-4fc5-a384-187da52c58cf	2026-08-26 15:44	2026-08-26 15:44	2026-08-26 15:44	UPST	UPST260904C00030000	call	30.0000	2026-09-04	1.3600	1.3600	1.4000	30.3400	25160.00	0.00	25160.00	185	29	226	201	1.12437810945274	0.617895114182154	0.617895114182154	false	false	false	true
cc85f90f-cb65-476d-aa90-80ba27904152	2026-08-26 13:48	2026-08-26 13:48	2026-08-26 13:48	UPST	UPST260904P00028000	put	28.0000	2026-09-04	0.3000	0.2500	0.3600	30.3900	15211.00	481.00	14730.00	507	55	517	104	4.97115384615385	0.606616033469752	0.61094506005405	false	false	false	true
c2235dae-003f-423e-8e79-ba980b4aeaa0	2026-08-26 11:54	2026-08-26 11:53	2026-08-26 11:53	UPST	UPST260828P00029500	put	29.5000	2026-08-28	0.3600	0.3600	0.4200	30.1900	19368.00	0.00	19368.00	538	52	551	145	3.8	0.737225803924332	0.737225803924332	false	false	false	true
b3f8a510-d3c3-4faa-8583-d8e12db84b8b	2026-08-26 10:56	2026-08-26 10:56	2026-08-26 10:56	UPST	UPST270219C00032500	call	32.5000	2027-02-19	5.3500	5.3500	5.5500	30.2800	19795.00	0.00	19795.00	37	7	37	968	0.0382231404958678	0.716064387560143	0.716064387560143	false	false	false	true
8702073e-9c41-439a-b5f7-0fdd2d6446fa	2026-08-26 09:45	2026-08-26 09:45	2026-08-26 09:45	UPST	UPST260918C00035000	call	35.0000	2026-09-18	0.7500	0.7400	0.7800	31.2300	208050.00	150.00	207900.00	2774	5	2779	4610	0.602819956616052	0.634736052708516	0.634736052708516	false	false	false	true
27066939-e77f-4f7d-bd3e-96e69ffa4550	2026-08-25 15:59	2026-08-25 15:59	2026-08-25 15:59	UPST	UPST260918C00030000	call	30.0000	2026-09-18	2.2500	2.2500	2.3300	30.5600	38250.00	0.00	38250.00	170	6	689	11628	0.0592535259717922	0.619969296285639	0.619969296285639	false	false	false	true
58b6b6a4-68fb-46a9-8c9a-04089ccfb330	2026-08-25 15:55	2026-08-25 15:55	2026-08-25 15:55	UPST	UPST260918C00030000	call	30.0000	2026-09-18	2.2700	2.1800	2.4400	30.5700	39498.00	16798.00	22700.00	174	9	308	11628	0.0264877880976952	0.624600954081066	0.624600954081066	false	false	false	true
1d46b159-cdb3-43d2-9adc-5342ef643dc0	2026-08-25 11:02	2026-08-25 11:02	2026-08-25 11:02	UPST	UPST261016C00030000	call	30.0000	2026-10-16	2.9900	2.9200	3.0000	30.1300	33488.00	33488.00	0.00	112	21	140	1374	0.101892285298399	0.630870896300578	0.630870896300578	false	false	false	true
7c1b5cec-d515-4a21-8928-64c779bc60a4	2026-08-24 13:57	2026-08-24 13:57	2026-08-24 13:57	UPST	UPST261218C00050000	call	50.0000	2026-12-18	0.9100	0.8400	0.9100	29.8000	57057.00	57057.00	0.00	627	44	629	474	1.32700421940928	0.751699492825172	0.750911042305412	false	false	false	true
6bbadcef-1fcd-4868-9af6-37f05a817432	2026-08-24 12:05	2026-08-24 12:04	2026-08-24 12:04	UPST	UPST261016C00032500	call	32.5000	2026-10-16	1.9600	1.8800	1.9600	29.9200	177184.00	177184.00	0.00	904	44	944	697	1.35437589670014	0.637990546903839	0.637990546903839	false	false	false	true