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: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

2d33b4df-dc77-444c-927d-8003c0b98d9b	2026-08-18 10:13	2026-08-18 10:13	2026-08-18 10:13	SPXW	SPXW260818P07700000	put	7700.0000	2026-08-18	11.5700	11.4000	11.6000	7698.9400	158450.00	158450.00	0.00	137	24	25532	3928	6.5	0.140284390099315	0.141553318184419	true	false	false	true	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	—	—	—	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-18T14:15:30.654866Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
698f45b0-7c1d-4a2f-9a71-0c474f884bfc	2026-08-18 10:14	2026-08-18 10:14	2026-08-18 10:14	SPXW	SPXW260818P07700000	put	7700.0000	2026-08-18	11.5500	11.4000	11.7000	7699.4100	214780.00	211300.00	3480.00	186	39	26042	3928	6.62983706720978	0.143410113410156	0.143410113410156	false	false	false	true	false
fdfeb690-83fa-4c18-aa5c-ffc63d48f809	2026-08-18 10:17	2026-08-18 10:17	2026-08-18 10:17	SPXW	SPXW260818C07700000	call	7700.0000	2026-08-18	15.3000	15.2000	15.4000	7705.5000	114750.00	3060.00	104040.00	75	19	9558	515	18.5592233009709	0.156005833904046	0.156009693890154	false	false	false	true	false
f35bbe25-3be4-463d-8678-93ceb01f29d6	2026-08-18 10:17	2026-08-18 10:17	2026-08-18 10:17	SPXW	SPXW260818C07700000	call	7700.0000	2026-08-18	15.3000	15.2000	15.4000	7705.7200	179010.00	0.00	116280.00	117	21	9678	515	18.7922330097087	0.154365463033865	0.154369283893738	false	false	false	true	false
cc9e6e3f-7d6c-499a-ac89-61f8ab50ff34	2026-08-18 10:21	2026-08-18 10:21	2026-08-18 10:21	SPXW	SPXW260821P07700000	put	7700.0000	2026-08-21	30.2000	30.1000	30.4000	7702.3600	120800.00	0.00	120800.00	40	6	657	2809	0.233891064435742	0.116785395407613	0.116785395407613	false	false	false	true	false
4b8b41be-5ec2-4be2-96c4-ef0326773de2	2026-08-18 10:22	2026-08-18 10:22	2026-08-18 10:22	SPXW	SPXW260818C07700000	call	7700.0000	2026-08-18	12.9000	12.8000	13.0000	7701.9700	243810.00	242520.00	0.00	189	35	10700	515	20.7766990291262	0.15137498386145	0.15137498386145	false	false	false	true	false
ab437554-c179-4244-92bc-50ed1949bc4a	2026-08-18 10:24	2026-08-18 10:24	2026-08-18 10:24	SPXW	SPXW260818P07700000	put	7700.0000	2026-08-18	8.9000	8.8000	9.0000	7704.2100	179780.00	40050.00	8900.00	202	18	32382	3928	8.2438900203666	0.141125799470498	0.141125799470498	false	false	false	true	false
940e86a2-5b07-475c-87ba-902db6fe709e	2026-08-18 10:25	2026-08-18 10:25	2026-08-18 10:25	SPXW	SPXW260818P07700000	put	7700.0000	2026-08-18	7.5000	7.4500	7.6000	7708.0700	232500.00	0.00	232500.00	310	44	33380	3928	8.4979633401222	0.143686303248877	0.143686303248877	false	false	false	true	false
cace27a7-b46d-49d6-90c2-4f61e79c7247	2026-08-18 10:25	2026-08-18 10:25	2026-08-18 10:25	SPXW	SPXW260818P07700000	put	7700.0000	2026-08-18	7.3000	7.2000	7.4000	7709.1600	141620.00	0.00	135050.00	194	29	33709	3928	8.58172097759674	0.146611561866079	0.146611561866079	false	false	false	true	false
b65aaf0c-1a91-4255-b30b-8db2c926face	2026-08-18 10:27	2026-08-18 10:27	2026-08-18 10:27	SPXW	SPXW260930P07700000	put	7700.0000	2026-09-30	123.3800	123.4000	124.0000	7707.9800	24676000.00	0.00	0.00	2000	10	2013	21599	0.0931987592018149	0.13649732086589	0.13649732086589	false	false	false	true	false
7d2f0ce2-e872-4c4c-9b78-b10946bb0128	2026-08-18 10:27	2026-08-18 10:27	2026-08-18 10:27	SPXW	SPXW260930P07450000	put	7450.0000	2026-09-30	62.3000	62.1000	62.5000	7707.9800	12460000.00	0.00	0.00	2000	10	2182	3949	0.552544948088124	0.163895111382673	0.163895111382673	false	false	false	true	false
0f2d5288-5b90-4598-96d6-1b48ed985ae7	2026-08-18 10:29	2026-08-18 10:29	2026-08-18 10:29	SPXW	SPXW260818P07710000	put	7710.0000	2026-08-18	12.2000	12.0000	12.2000	7707.3500	104920.00	104920.00	0.00	86	14	13992	2468	5.66936790923825	0.141561975596994	0.141561975596994	false	false	false	true	false
c9e7aee8-c1f1-4749-9d62-e523db3c792f	2026-08-18 10:30	2026-08-18 10:29	2026-08-18 10:29	SPXW	SPXW260818P07725000	put	7725.0000	2026-08-18	21.3000	21.2000	21.4000	7706.9100	106500.00	0.00	25560.00	50	6	3048	2913	1.04634397528321	0.127942681520192	0.127942681520192	false	false	false	true	false
f204f894-c327-4734-9b7b-6dfebb6729ab	2026-08-18 10:31	2026-08-18 10:31	2026-08-18 10:31	SPXW	SPXW260818P07700000	put	7700.0000	2026-08-18	6.5000	6.4000	6.5000	7710.4100	130000.00	130000.00	0.00	200	11	36115	3928	9.19424643584521	0.142972293450763	0.142972293450763	false	false	false	true	false
5d0bc186-7784-4112-b3eb-924a7b92b8cd	2026-08-18 10:33	2026-08-18 10:33	2026-08-18 10:33	SPXW	SPXW260818P07700000	put	7700.0000	2026-08-18	6.0000	5.9000	6.1000	7711.5800	106800.00	106200.00	0.00	178	29	37351	3928	9.50891038696538	0.141962851156252	0.141962851156252	false	false	false	true	false
6083bb83-a792-415b-95c3-a3da8613b67f	2026-08-18 10:34	2026-08-18 10:33	2026-08-18 10:33	SPXW	SPXW260818C07710000	call	7710.0000	2026-08-18	11.6000	11.5000	11.7000	7711.3400	232000.00	0.00	183280.00	200	41	23225	119	195.168067226891	0.141246142550081	0.141249815352715	false	false	false	true	false
d8d0d996-47e8-46ee-8ea7-9f081ba1a9c1	2026-08-18 10:35	2026-08-18 10:35	2026-08-18 10:35	SPXW	SPXW260818C07715000	call	7715.0000	2026-08-18	8.5500	8.4000	8.6000	7710.2600	170970.00	170970.00	0.00	200	40	16390	119	137.731092436975	0.138968971560933	0.138968971560933	false	false	false	true	false
9c3bd5e8-52c4-46c5-8447-9d0106141f5e	2026-08-18 10:42	2026-08-18 10:42	2026-08-18 10:42	SPXW	SPXW260901P07685000	put	7685.0000	2026-09-01	55.7000	55.5000	55.7000	7707.0400	194950.00	194950.00	0.00	35	5	275	36	7.63888888888889	0.118283319525489	0.118283319525489	false	false	false	true	false
873152a2-15a4-440d-8775-85a813dfe46c	2026-08-18 10:44	2026-08-18 10:44	2026-08-18 10:44	SPXW	SPXW260818P07700000	put	7700.0000	2026-08-18	7.6000	7.5000	7.7000	7705.4200	294120.00	293360.00	0.00	387	11	41027	3928	10.4447556008147	0.136215344138496	0.134761679911462	false	false	false	true	false
0be58301-3faf-4599-a22a-908e216dfe2f	2026-08-18 10:45	2026-08-18 10:44	2026-08-18 10:44	SPXW	SPXW260819P07700000	put	7700.0000	2026-08-19	17.9000	17.9000	18.0000	7703.8000	100240.00	0.00	100240.00	56	12	2706	1184	2.28547297297297	0.125748177767179	0.125085206136395	false	false	false	true	false
c0d1f636-d1f7-4a34-9986-4d2d193eb6c5	2026-08-18 10:45	2026-08-18 10:45	2026-08-18 10:45	SPXW	SPXW260818P07710000	put	7710.0000	2026-08-18	12.5000	12.4000	12.7000	7704.4500	206250.00	0.00	206250.00	165	13	18215	2468	7.38047001620746	0.128126938529418	0.127326956628982	false	false	false	true	false
fad87a95-e2b0-469a-93a3-c7a1d58122c9	2026-08-18 10:51	2026-08-18 10:51	2026-08-18 10:51	SPXW	SPXW260818P07705000	put	7705.0000	2026-08-18	8.9700	8.8000	9.1000	7706.3200	147050.00	0.00	130850.00	164	27	24041	1159	20.7428817946506	0.130675614505489	0.1293296999794	false	false	false	true	false
56d8c219-4377-4de2-a8cc-afee29b7b78c	2026-08-18 10:52	2026-08-18 10:52	2026-08-18 10:52	SPXW	SPXW260818P07705000	put	7705.0000	2026-08-18	8.9000	8.8000	9.0000	7706.6400	162870.00	154860.00	0.00	183	8	24464	1159	21.1078515962036	0.131469681572604	0.131469681572604	false	false	false	true	false
b67c57d2-7188-4da0-9cb1-1a70f8effeb5	2026-08-18 10:52	2026-08-18 10:52	2026-08-18 10:52	SPXW	SPXW260818P07710000	put	7710.0000	2026-08-18	11.3200	11.2000	11.6000	7706.4500	226340.00	0.00	226340.00	200	43	19478	2468	7.89222042139384	0.129250215307514	0.129250215307514	false	false	false	true	false
7548ac24-8dee-40b9-a9cf-02a901b449fd	2026-08-18 10:53	2026-08-18 10:53	2026-08-18 10:53	SPXW	SPXW260818P07700000	put	7700.0000	2026-08-18	8.6600	8.4000	8.8000	7702.6700	187040.00	178540.00	8500.00	216	26	44682	3928	11.3752545824847	0.132805997702582	0.136874790579996	false	false	false	true	false
93e611e3-777f-48e2-8ff3-501337509551	2026-08-18 10:55	2026-08-18 10:54	2026-08-18 10:54	SPXW	SPXW260818P07700000	put	7700.0000	2026-08-18	10.2400	10.0000	10.3000	7699.6700	258030.00	254970.00	0.00	252	43	46164	3928	11.7525458248472	0.13673844852393	0.138089714821031	true	false	false	true	false
441603ac-fcdb-49bc-a0cb-23d1c3b3dfc0	2026-08-18 10:55	2026-08-18 10:55	2026-08-18 10:55	SPXW	SPXW260818P07700000	put	7700.0000	2026-08-18	10.5400	10.4000	10.6000	7698.9900	161270.00	161270.00	0.00	153	37	46408	3928	11.8146639511202	0.136164188159616	0.137520255449577	false	false	false	true	false
ddc4575a-aa0f-4c11-9c43-4d29ce8fdbc3	2026-08-18 10:56	2026-08-18 10:56	2026-08-18 10:56	SPXW	SPXW260821P07650000	put	7650.0000	2026-08-21	16.7700	16.5000	16.8000	7698.5000	109000.00	109000.00	0.00	65	9	1737	4625	0.375567567567568	0.132102939033474	0.132522776120122	false	false	false	true	false
c21b9ea9-52e5-4106-91ce-44f8c48ed770	2026-08-18 10:56	2026-08-18 10:56	2026-08-18 10:56	SPXW	SPXW260818P07700000	put	7700.0000	2026-08-18	10.4600	10.2000	10.5000	7698.6900	193480.00	187300.00	0.00	185	43	47789	3928	12.1662423625255	0.131742812075371	0.131742812075371	false	false	false	true	false
32debe26-2228-427a-9f41-bcb0ea31216f	2026-08-18 11:00	2026-08-18 11:00	2026-08-18 11:00	SPXW	SPXW260818P07700000	put	7700.0000	2026-08-18	11.5000	11.3000	11.6000	7697.4100	220850.00	220850.00	0.00	192	25	49593	3928	12.6255091649695	0.139698038199552	0.141067970192261	false	false	false	true	false
add6329d-8a1e-4ae0-90cf-78f886f64fed	2026-08-18 11:01	2026-08-18 11:01	2026-08-18 11:01	SPXW	SPXW260818P07700000	put	7700.0000	2026-08-18	12.0400	12.0000	12.3000	7696.2300	361290.00	0.00	360070.00	300	47	50231	3928	12.787932790224	0.14059524071851	0.14059524071851	false	false	false	true	false
20f5ed62-92c9-46d2-aecc-5f7437b3fe88	2026-08-18 11:01	2026-08-18 11:01	2026-08-18 11:01	SPXW	SPXW260818P07700000	put	7700.0000	2026-08-18	12.2600	12.2000	12.4000	7695.7700	104190.00	0.00	104190.00	85	21	50464	3928	12.847250509165	0.138506114016473	0.138506114016473	false	false	false	true	false
33d5d082-ce60-4b02-b764-e8d30f785471	2026-08-18 11:03	2026-08-18 11:03	2026-08-18 11:03	SPXW	SPXW260818P07700000	put	7700.0000	2026-08-18	11.2000	11.0000	11.3000	7697.2400	113110.00	67200.00	0.00	101	15	51533	3928	13.119399185336	0.133576184054772	0.134954230561761	false	false	false	true	false
28f69bf2-a4fc-44bb-b950-eb07fff54b89	2026-08-18 11:05	2026-08-18 11:05	2026-08-18 11:05	SPXW	SPXW260818P07700000	put	7700.0000	2026-08-18	9.0000	8.9000	9.1000	7701.9500	102610.00	102610.00	0.00	114	12	52808	3928	13.4439918533605	0.137768373236744	0.139147950292316	false	false	false	true	false
9bb45c0e-b7e2-4ba2-9329-411dc414905d	2026-08-18 11:06	2026-08-18 11:06	2026-08-18 11:06	SPXW	SPXW260818C07710000	call	7710.0000	2026-08-18	6.5000	6.4000	6.7000	7702.2400	130650.00	16250.00	114400.00	201	31	33126	119	278.36974789916	0.135265729901632	0.135265729901632	false	false	false	true	false
7f3d9050-b1de-4906-a9a9-9f9c3b56a6eb	2026-08-18 11:08	2026-08-18 11:07	2026-08-18 11:07	SPXW	SPXW260818C07710000	call	7710.0000	2026-08-18	6.6000	6.4000	6.7000	7702.2600	132000.00	99660.00	32340.00	200	33	33634	119	282.638655462185	0.137066609667703	0.137066609667703	false	false	false	true	false
fc9a03f8-b402-490a-bfe3-8a3141c792d0	2026-08-18 11:09	2026-08-18 11:09	2026-08-18 11:09	SPXW	SPXW260818P07725000	put	7725.0000	2026-08-18	28.1000	28.0000	28.4000	7697.2600	140520.00	98370.00	42150.00	50	5	4336	2913	1.48849982835565	0.100723406471105	0.108686122289296	false	false	false	true	false
c47a83f9-2e12-46fe-bdec-ab0928ae889f	2026-08-18 11:14	2026-08-18 11:14	2026-08-18 11:14	SPXW	SPXW260818P07695000	put	7695.0000	2026-08-18	8.7900	8.6000	8.8000	7697.1400	114260.00	114260.00	0.00	130	14	28575	1623	17.6062846580407	0.137055330564754	0.138459009688439	false	false	false	true	false
3e044e2c-cd18-4a5a-934f-4feea308bc0e	2026-08-18 11:17	2026-08-18 11:17	2026-08-18 11:17	SPXW	SPXW260818P07700000	put	7700.0000	2026-08-18	11.0900	10.9000	11.3000	7696.1900	333780.00	311790.00	1090.00	301	77	57346	3928	14.5992871690428	0.127913702535014	0.130123588261673	true	false	false	true	false
e94e9398-bf2b-4779-8836-d84ef78c4154	2026-08-18 11:22	2026-08-18 11:22	2026-08-18 11:22	SPXW	SPXW260818P07700000	put	7700.0000	2026-08-18	12.7200	12.5000	12.9000	7694.1700	319210.00	305350.00	7560.00	251	44	59500	3928	15.1476578411405	0.134457762295598	0.137374437005279	false	false	false	true	false
8f5e3b07-3b44-43b4-81fb-83ae562de102	2026-08-18 11:22	2026-08-18 11:22	2026-08-18 11:22	SPXW	SPXW260818P07700000	put	7700.0000	2026-08-18	12.2500	12.0000	12.3000	7694.8800	183790.00	177690.00	0.00	150	32	59760	3928	15.213849287169	0.134780655050398	0.136228425759576	false	false	false	true	false
d6c413a9-0726-4d00-ab12-f81dc1a8e386	2026-08-18 11:28	2026-08-18 11:28	2026-08-18 11:28	SPXW	SPXW260818P07695000	put	7695.0000	2026-08-18	8.0000	8.0000	8.1000	7696.8400	103200.00	0.00	103200.00	129	38	32536	1623	20.0468268638324	0.128330448379816	0.128330448379816	false	false	false	true	false
ad020eaf-8738-4ce6-b241-084f835f5bc9	2026-08-18 11:28	2026-08-18 11:28	2026-08-18 11:28	SPXW	SPXW260819P07700000	put	7700.0000	2026-08-19	20.8800	20.9000	21.2000	7697.1200	198390.00	0.00	198390.00	95	15	3904	1184	3.2972972972973	0.12405928542581	0.12405928542581	false	false	false	true	false
1ec9bb80-f5ac-45ac-a988-9e4bdbe32ecf	2026-08-18 11:29	2026-08-18 11:29	2026-08-18 11:29	SPXW	SPXW260818P07690000	put	7690.0000	2026-08-18	5.0200	5.0000	5.2000	7700.0900	101810.00	510.00	101300.00	203	42	33199	1555	21.3498392282958	0.13408641316666	0.13408641316666	false	false	false	true	false
81d06e63-ba23-4b72-bcf5-6393b647ce9f	2026-08-18 11:35	2026-08-18 11:35	2026-08-18 11:35	SPXW	SPXW260818P07700000	put	7700.0000	2026-08-18	10.0300	10.0000	10.2000	7696.8000	131380.00	1020.00	130360.00	131	33	64115	3928	16.3225560081466	0.123162891012498	0.124629075363962	true	false	false	true	false
78952184-cbab-4163-bfc2-0678f674ebb2	2026-08-18 11:37	2026-08-18 11:37	2026-08-18 11:37	SPXW	SPXW260819P07690000	put	7690.0000	2026-08-19	16.6000	16.6000	16.7000	7697.4600	156040.00	0.00	156040.00	94	12	1849	646	2.86222910216718	0.127387229795089	0.127387229795089	false	false	false	true	false
b34383c5-3a7e-4712-8eba-7de69a3a2022	2026-08-18 11:37	2026-08-18 11:37	2026-08-18 11:37	SPXW	SPXW260828P07620000	put	7620.0000	2026-08-28	33.4000	33.2000	33.5000	7697.8500	156980.00	156980.00	0.00	47	7	88	360	0.244444444444444	0.134190825728573	0.134190825728573	false	false	false	true	false
bc3a55ca-3fb9-4905-8616-af083ea9735e	2026-08-18 11:42	2026-08-18 11:42	2026-08-18 11:42	SPXW	SPXW260820C07615000	call	7615.0000	2026-08-20	94.0000	93.4000	94.5000	7701.9900	188000.00	188000.00	0.00	20	7	274	3	91.3333333333333	0.141265851448738	0.141265851448738	false	false	false	true	false
fa4a67b8-a24a-4733-b618-ff005c2b15ef	2026-08-18 11:43	2026-08-18 11:43	2026-08-18 11:43	SPXW	SPXW260819C07700000	call	7700.0000	2026-08-19	20.3000	20.3000	20.4000	7700.1800	136010.00	0.00	136010.00	67	7	2481	655	3.78778625954198	0.123188279686568	0.123188279686568	false	false	false	true	false
559d9020-667a-4d66-9358-dd1d8dfcc8dc	2026-08-18 11:45	2026-08-18 11:45	2026-08-18 11:45	SPXW	SPXW260819C07700000	call	7700.0000	2026-08-19	20.5000	20.4000	20.7000	7700.7100	184500.00	159900.00	24600.00	90	7	2604	655	3.97557251908397	0.122746614742215	0.122746614742215	false	false	false	true	false