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.

474,253 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts474,253 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:ticker = SPXW×sorted by created_at ↑×

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

5be665f5-8aad-4bc2-855d-dc76ce748cce	2026-08-26 13:40	2026-08-26 13:40	2026-08-26 13:40	SPXW	SPXW260827C07730000	call	7730.0000	2026-08-27	5.5500	5.5000	5.8000	7674.0700	134350.00	0.00	134350.00	242	27	1455	275	5.29090909090909	0.146729199850216	0.145766425852428	false	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	—	—	—	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-26T18:03:36.899464Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
059d121f-779f-47d2-8a21-0369512c5274	2026-08-26 13:40	2026-08-26 13:40	2026-08-26 13:40	SPXW	SPXW260930C07675000	call	7675.0000	2026-09-30	130.5000	130.5000	130.9000	7675.2300	326250.00	0.00	326250.00	25	5	50	2044	0.0244618395303327	0.122449410709634	0.122449410709634	false	false	false	true	false
480b3aff-579b-41ce-873e-c293edd71d9f	2026-08-26 13:54	2026-08-26 13:54	2026-08-26 13:54	SPXW	SPXW260827P07600000	put	7600.0000	2026-08-27	4.7200	4.7000	4.9000	7675.1300	117920.00	0.00	116000.00	250	24	1589	1747	0.909559244419004	0.173388057135709	0.172241027119864	false	false	false	true	false
bfc34705-9444-4ebf-acea-cdcb5a7f1d21	2026-08-26 13:54	2026-08-26 13:54	2026-08-26 13:54	SPXW	SPXW260827P07600000	put	7600.0000	2026-08-27	4.6600	4.4000	4.9000	7675.0900	107540.00	0.00	90150.00	231	28	1820	1747	1.0417859187178	0.172179241951975	0.169857205993358	false	false	false	true	false
f71239db-b063-4377-a1a1-9c727463121a	2026-08-26 13:54	2026-08-26 13:54	2026-08-26 13:54	SPXW	SPXW260827C07680000	call	7680.0000	2026-08-27	23.0000	22.8000	23.0000	7675.4600	117300.00	117300.00	0.00	51	11	2735	415	6.59036144578313	0.154860684685369	0.154860684685369	false	false	false	true	false
a5e69b3e-8c2c-4c5f-b89f-31be9746fd01	2026-08-26 13:55	2026-08-26 13:55	2026-08-26 13:55	SPXW	SPXW260827P07605000	put	7605.0000	2026-08-27	5.1400	5.0000	5.3000	7675.7900	102770.00	0.00	88730.00	200	25	956	328	2.91463414634146	0.170917110293043	0.169828579110097	false	false	false	true	false
29472821-52a6-4f3e-a49f-b07839ed9a1c	2026-08-26 13:56	2026-08-26 13:56	2026-08-26 13:56	SPXW	SPXW260827C07730000	call	7730.0000	2026-08-27	5.8200	5.7000	6.0000	7675.1800	145600.00	0.00	142060.00	250	33	1748	275	6.35636363636364	0.147681172260784	0.146740321088621	false	false	false	true	false
0e89170c-8c4c-4c35-817b-792212dadbdb	2026-08-26 14:01	2026-08-26 14:01	2026-08-26 14:01	SPXW	SPXW260827C07680000	call	7680.0000	2026-08-27	21.9000	21.9000	22.1000	7673.7400	111690.00	0.00	111690.00	51	10	2848	415	6.86265060240964	0.153057415828173	0.153057415828173	false	false	false	true	false
69380a9c-0f21-48e5-bf1b-984697e2eb72	2026-08-26 14:04	2026-08-26 14:03	2026-08-26 14:03	SPXW	SPXW260826P07700000	put	7700.0000	2026-08-26	26.6000	26.3000	26.6000	7674.1000	132990.00	132990.00	0.00	50	6	9447	2023	4.66979733069698	0.160578227195024	0.160578227195024	false	false	false	true	false
06188633-88cc-425f-81aa-3038f5d729ad	2026-08-26 14:11	2026-08-26 14:11	2026-08-26 14:11	SPXW	SPXW260827C07730000	call	7730.0000	2026-08-27	5.2300	5.1000	5.4000	7673.7300	130740.00	0.00	120140.00	250	33	2038	275	7.41090909090909	0.144293670935438	0.14341208732625	false	false	false	true	false
82e7d51c-3d88-4e7f-86bb-06e4941eb5d0	2026-08-26 14:11	2026-08-26 14:11	2026-08-26 14:11	SPXW	SPXW260827C07730000	call	7730.0000	2026-08-27	5.1100	4.9000	5.4000	7673.4900	127840.00	3120.00	114420.00	250	39	2288	275	8.32	0.143813015181653	0.142823141214599	false	false	false	true	false
2f8e2547-cb19-4c7e-8b4a-e9cea4243826	2026-08-26 14:12	2026-08-26 14:12	2026-08-26 14:12	SPXW	SPXW260827P07670000	put	7670.0000	2026-08-27	23.2000	23.0000	23.2000	7672.6600	113680.00	113680.00	0.00	49	9	2382	463	5.14470842332613	0.155386901880356	0.155386901880356	false	false	false	true	false
fb7c5e24-9db4-415d-9e2b-ff196186896b	2026-08-26 14:20	2026-08-26 14:20	2026-08-26 14:20	SPXW	SPXW260827P07625000	put	7625.0000	2026-08-27	7.8100	7.7000	8.0000	7677.1800	181260.00	0.00	181260.00	232	29	1558	1563	0.996801023672425	0.1648361916167	0.163970984825023	false	false	false	true	false
28e7fa96-a354-4c98-a6d1-8d823127dc5b	2026-08-26 14:23	2026-08-26 14:23	2026-08-26 14:23	SPXW	SPXW260826C07660000	call	7660.0000	2026-08-26	15.9800	15.6000	16.5000	7675.9400	337080.00	6380.00	329120.00	211	29	25495	571	44.6497373029772	0.102046976916743	0.102046976916743	false	false	false	true	false
c3cee271-68d7-490d-9562-df1388eb2ec5	2026-08-26 14:23	2026-08-26 14:23	2026-08-26 14:23	SPXW	SPXW260826C07660000	call	7660.0000	2026-08-26	15.7000	15.6000	15.7000	7675.4500	188400.00	188400.00	0.00	120	25	25695	571	45	0.0905939548233656	0.0905939548233656	false	false	false	true	false
c9c071c8-a042-4abb-8d9e-6957d90e2c15	2026-08-26 14:24	2026-08-26 14:24	2026-08-26 14:24	SPXW	SPXW260827P07665000	put	7665.0000	2026-08-27	20.2000	20.1000	20.3000	7674.4600	404000.00	50500.00	22220.00	200	7	1996	331	6.03021148036254	0.156067376392556	0.156067376392556	false	false	false	true	false
b8a6537d-34c1-4899-869e-9de24d460a0d	2026-08-26 14:25	2026-08-26 14:25	2026-08-26 14:25	SPXW	SPXW260827P07670000	put	7670.0000	2026-08-27	22.7000	22.5000	22.7000	7673.8700	115770.00	115770.00	0.00	51	8	2752	463	5.94384449244061	0.155835374880261	0.155835374880261	false	false	false	true	false
aa09c179-2401-46f9-80fe-8ce4513b7219	2026-08-26 14:25	2026-08-26 14:25	2026-08-26 14:25	SPXW	SPXW260827C07730000	call	7730.0000	2026-08-27	5.0300	4.9000	5.2000	7673.5100	125760.00	0.00	118110.00	250	31	2597	275	9.44363636363636	0.142423640071271	0.141793641838786	false	false	false	true	false
66824aa7-38e8-4f9f-a29c-183f88e7d760	2026-08-26 14:25	2026-08-26 14:25	2026-08-26 14:25	SPXW	SPXW260827P07665000	put	7665.0000	2026-08-27	20.6900	20.5000	20.8000	7673.4200	206940.00	194580.00	0.00	100	17	2096	331	6.33232628398792	0.155725803977416	0.156357070719986	true	false	false	true	false
0495d0c8-4b12-4a92-bb32-5acf63e667de	2026-08-26 14:25	2026-08-26 14:25	2026-08-26 14:25	SPXW	SPXW260827C07730000	call	7730.0000	2026-08-27	5.0000	4.9000	5.2000	7673.3600	115500.00	0.00	107500.00	231	26	2828	275	10.2836363636364	0.142042289699201	0.142042289699201	false	false	false	true	false
b1666a8c-74e9-4843-a0f4-5466cdce5e21	2026-08-26 14:33	2026-08-26 14:33	2026-08-26 14:33	SPXW	SPXW260827P07670000	put	7670.0000	2026-08-27	21.3600	21.3000	21.6000	7675.8900	108940.00	0.00	108940.00	51	10	2848	463	6.1511879049676	0.153535982282928	0.153535982282928	false	false	false	true	false
e58bac06-9136-4c2b-b092-00db5955e328	2026-08-26 14:45	2026-08-26 14:45	2026-08-26 14:45	SPXW	SPXW260826C07680000	call	7680.0000	2026-08-26	3.7200	3.5000	3.9000	7679.6400	181670.00	109690.00	69420.00	489	283	171522	3968	43.226310483871	0.10831301428365	0.105807354811582	false	false	false	true	false
7d775564-07ee-42db-935f-29e220d0403e	2026-08-26 14:47	2026-08-26 14:46	2026-08-26 14:46	SPXW	SPXW260826C07680000	call	7680.0000	2026-08-26	3.8100	3.7000	3.9000	7679.9200	125260.00	37880.00	81680.00	329	64	174796	3968	44.0514112903226	0.102804542230954	0.108344650725624	false	false	false	true	false
f566df4b-be92-48b5-8695-940427a2256c	2026-08-26 14:47	2026-08-26 14:46	2026-08-26 14:47	SPXW	SPXW260826C07680000	call	7680.0000	2026-08-26	4.1100	3.9000	4.3000	7680.6700	181450.00	98440.00	64970.00	441	164	175878	3968	44.3240927419355	0.103107122360248	0.106185492181441	false	false	false	true	false
bfb7c024-bb35-4c98-b435-ec49fae9ce90	2026-08-26 14:47	2026-08-26 14:47	2026-08-26 14:47	SPXW	SPXW260826C07680000	call	7680.0000	2026-08-26	4.6200	4.4000	4.9000	7680.9700	137590.00	29140.00	103860.00	298	116	176472	3968	44.4737903225806	0.113069758438427	0.112870942815403	false	false	false	true	false
5b9f1565-5c67-410b-9126-92e7a292a243	2026-08-26 14:50	2026-08-26 14:50	2026-08-26 14:50	SPXW	SPXW260826C07685000	call	7685.0000	2026-08-26	2.6200	2.5000	2.7000	7681.6300	125445.00	61200.00	60420.00	478	53	137695	1570	87.703821656051	0.113283884594369	0.116275151400463	false	false	false	true	false
5a4029a2-00ac-4b35-8c96-a0de1f905354	2026-08-26 14:52	2026-08-26 14:52	2026-08-26 14:52	SPXW	SPXW260826C07685000	call	7685.0000	2026-08-26	2.3100	2.2000	2.4500	7680.9400	125715.00	50050.00	74980.00	545	59	139564	1570	88.8942675159236	0.113243115669218	0.119463898636899	false	false	false	true	false
941c183e-5a87-4cf6-87c4-0143ec4ab1f8	2026-08-26 14:53	2026-08-26 14:53	2026-08-26 14:53	SPXW	SPXW260831C07770000	call	7770.0000	2026-08-31	9.3000	9.1000	9.4000	7682.5900	465000.00	199020.00	265980.00	500	20	2019	699	2.88841201716738	0.102457271422402	0.102457271422402	false	false	false	true	false
1ba3100f-b333-434c-a8b6-01f2d2e1da4b	2026-08-26 14:55	2026-08-26 14:55	2026-08-26 14:55	SPXW	SPXW260828C07735000	call	7735.0000	2026-08-28	13.8000	13.6000	13.9000	7682.5500	248400.00	111780.00	136620.00	180	13	651	359	1.8133704735376	0.1459161720817	0.1459161720817	false	false	false	true	false
681c3706-d25d-4071-b696-ca0c44958720	2026-08-26 14:58	2026-08-26 14:58	2026-08-26 14:58	SPXW	SPXW260904C07740000	call	7740.0000	2026-09-04	33.2000	33.0000	33.3000	7683.1600	332000.00	26560.00	305440.00	100	5	387	424	0.912735849056604	0.112760463246264	0.112760463246264	false	false	false	true	false
f808f3ae-e7bb-4fee-b3d6-7562ced26f23	2026-08-26 14:59	2026-08-26 14:58	2026-08-26 14:58	SPXW	SPXW260908C07760000	call	7760.0000	2026-09-08	30.6800	30.3000	30.8000	7683.7500	205560.00	202490.00	3070.00	67	7	294	334	0.880239520958084	0.0991710430302486	0.0993619506317955	false	false	false	true	false
ce42ce12-16c5-4c35-b564-1130971e0738	2026-08-26 15:01	2026-08-26 15:00	2026-08-26 15:00	SPXW	SPXW260826C07680000	call	7680.0000	2026-08-26	8.2300	8.0000	8.5000	7686.1400	103660.00	20020.00	82810.00	126	85	188468	3968	47.4969758064516	0.140515878689548	0.140515878689548	true	false	false	true	false
42dcbb34-d9db-4fcb-a7ce-cb6d4c2f5be8	2026-08-26 15:01	2026-08-26 15:00	2026-08-26 15:00	SPXW	SPXW260826C07685000	call	7685.0000	2026-08-26	5.0700	4.9000	5.3000	7686.0900	217140.00	50680.00	140750.00	428	184	149990	1570	95.5350318471338	0.135023442076878	0.145156290091457	false	false	false	true	false
f5af567f-e412-47f8-98b1-dd6f6968eb84	2026-08-26 15:01	2026-08-26 15:01	2026-08-26 15:01	SPXW	SPXW260826C07685000	call	7685.0000	2026-08-26	6.2200	5.7000	7.0000	7687.5500	242520.00	88130.00	112740.00	390	180	151153	1570	96.275796178344	0.141362818276454	0.132000602828812	false	false	false	true	false
8a3dfdaa-0435-48c7-b863-19cc67216ada	2026-08-26 15:01	2026-08-26 15:01	2026-08-26 15:01	SPXW	SPXW260826C07685000	call	7685.0000	2026-08-26	5.0300	4.9000	5.3000	7687.1500	132180.00	520.00	107180.00	263	74	151846	1570	96.7171974522293	0.123821918205137	0.117498638464524	true	false	false	true	false
2c32839d-7f7c-4d27-ab38-a7f9f2166bbf	2026-08-26 15:03	2026-08-26 15:03	2026-08-26 15:03	SPXW	SPXW260831C07755000	call	7755.0000	2026-08-31	14.4000	14.3000	14.6000	7688.5900	144000.00	67680.00	76320.00	100	9	860	877	0.980615735461802	0.104463842361112	0.104463842361112	false	false	false	true	false
c205fb54-8ebd-4ab8-95cd-6472f5faba4e	2026-08-26 15:03	2026-08-26 15:03	2026-08-26 15:03	SPXW	SPXW260827P07630000	put	7630.0000	2026-08-27	6.5700	6.5000	6.8000	7688.8400	131440.00	0.00	131440.00	200	22	1613	498	3.23895582329317	0.164767669348069	0.163825634581228	false	false	false	true	false
52e2902d-02ba-4530-9517-b21f1f1e7f03	2026-08-26 15:03	2026-08-26 15:03	2026-08-26 15:03	SPXW	SPXW260831C07755000	call	7755.0000	2026-08-31	14.6000	14.4000	14.7000	7688.9600	292000.00	166440.00	45260.00	200	14	1060	877	1.20866590649943	0.104824838246242	0.104824838246242	false	false	false	true	false
d7cf7d49-daf3-4b86-9bf0-63996bb8f6b8	2026-08-26 15:04	2026-08-26 15:04	2026-08-26 15:04	SPXW	SPXW260827C07700000	call	7700.0000	2026-08-27	20.0000	20.0000	20.2000	7690.1400	100000.00	0.00	100000.00	50	8	5030	1747	2.87922152261019	0.150995827963013	0.150995827963013	false	false	false	true	false
2452f85b-267e-4a62-9e5b-a43df2a64581	2026-08-26 15:04	2026-08-26 15:04	2026-08-26 15:04	SPXW	SPXW260827C07695000	call	7695.0000	2026-08-27	22.6700	22.4000	22.7000	7690.0600	138290.00	138290.00	0.00	61	13	1658	426	3.89201877934272	0.153247160934382	0.153247160934382	false	false	false	true	false
a0d92d8e-7adb-491a-8ac5-de0705040340	2026-08-26 15:08	2026-08-26 15:08	2026-08-26 15:08	SPXW	SPXW260826C07685000	call	7685.0000	2026-08-26	5.4000	5.3000	5.6000	7688.3400	101070.00	48600.00	49770.00	187	32	158747	1570	101.112738853503	0.117077090398123	0.113562188774083	false	false	false	true	false
9a073036-15c7-4d4b-8c0c-ebaeb478c00f	2026-08-26 15:08	2026-08-26 15:08	2026-08-26 15:08	SPXW	SPXW260827C07745000	call	7745.0000	2026-08-27	4.7500	4.6000	5.0000	7687.2200	166190.00	0.00	131150.00	350	24	1863	215	8.66511627906977	0.141621276355535	0.140598166985325	false	false	false	true	false
db266532-de5e-4c56-96e2-ed3898e57ffb	2026-08-26 15:14	2026-08-26 15:14	2026-08-26 15:14	SPXW	SPXW260826P07690000	put	7690.0000	2026-08-26	5.4000	5.3000	5.4000	7686.8100	104760.00	104760.00	0.00	194	39	19935	522	38.1896551724138	0.125748479587903	0.125748479587903	false	false	false	true	false
3f10de4e-1ba3-48b4-b09e-ce4740b2294b	2026-08-26 15:21	2026-08-26 15:21	2026-08-26 15:21	SPXW	SPXW260827C07695000	call	7695.0000	2026-08-27	20.4000	20.4000	20.6000	7686.3300	124440.00	0.00	124440.00	61	10	1865	426	4.37793427230047	0.150272850309337	0.150272850309337	false	false	false	true	false
50ab1b31-c563-4161-a309-bdd05ffa147d	2026-08-26 15:26	2026-08-26 15:26	2026-08-26 15:26	SPXW	SPXW260827C07690000	call	7690.0000	2026-08-27	24.2400	24.0000	24.3000	7688.5700	172100.00	123700.00	0.00	71	13	2400	300	8	0.152685137555677	0.153308010236351	true	false	false	true	false
f311f5b3-de7b-45bf-b2a2-126ff7c8eaa9	2026-08-26 15:27	2026-08-26 15:26	2026-08-26 15:26	SPXW	SPXW260826C07680000	call	7680.0000	2026-08-26	9.0700	9.5000	9.7000	7688.4900	997700.00	0.00	0.00	1100	8	196641	3968	49.5567036290323	0.129210350311157	0.129210350311157	false	false	false	true	false
8113f591-335a-4235-90e9-ad3baa8122d3	2026-08-26 15:27	2026-08-26 15:26	2026-08-26 15:26	SPXW	SPXW260826C07670000	call	7670.0000	2026-08-26	18.4700	18.9000	19.2000	7688.4900	2031700.00	0.00	0.00	1100	8	103532	2542	40.7285601888277	0.23785164419808	0.23785164419808	false	false	false	true	false
b334ca6d-90b1-498a-a072-734590014bf8	2026-08-26 15:31	2026-08-26 15:30	2026-08-26 15:30	SPXW	SPXW260904C07700000	call	7700.0000	2026-09-04	53.5000	53.2000	53.6000	7685.9500	187250.00	112350.00	74900.00	35	8	641	1855	0.3455525606469	0.118048291364348	0.118048291364348	false	false	false	true	false
20d56f7b-8bc9-4756-b05b-d3f800357eb3	2026-08-26 15:31	2026-08-26 15:31	2026-08-26 15:31	SPXW	SPXW260904P07670000	put	7670.0000	2026-09-04	48.5000	48.3000	48.6000	7685.5100	169750.00	97000.00	72750.00	35	9	463	421	1.09976247030879	0.123033145088415	0.123033145088415	false	false	false	true	false
73ff3d7a-39ea-465c-a13e-2b430d2265e9	2026-08-26 15:33	2026-08-26 15:33	2026-08-26 15:33	SPXW	SPXW260909C07810000	call	7810.0000	2026-09-09	18.4100	17.6000	18.7000	7686.2900	913190.00	732320.00	180870.00	496	14	1102	61	18.0655737704918	0.0962662432490091	0.0960437614002132	false	false	false	true	false