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

a927f29c-74be-455b-9697-3040dfc88039	2026-08-25 14:29	2026-08-25 14:29	2026-08-25 14:29	SPXW	SPXW260827P07650000	put	7650.0000	2026-08-27	21.0000	20.9000	21.2000	7645.0000	105000.00	48300.00	56700.00	50	5	487	2337	0.208386820710312	0.131204474010186	0.131204474010186	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	—	—	—	—	—	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-25T18:29:57.396798Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
6e2f6a37-1182-4103-b1a1-80a99e456759	2026-08-25 14:31	2026-08-25 14:30	2026-08-25 14:30	SPXW	SPXW260826C07665000	call	7665.0000	2026-08-26	17.5100	17.4000	17.8000	7669.9700	124310.00	0.00	124310.00	71	14	2535	354	7.16101694915254	0.0907892935323993	0.0901567601565024	true	false	false	true	false
7db65518-9654-48fe-8af9-c7c244d3a590	2026-08-25 14:31	2026-08-25 14:31	2026-08-25 14:31	SPXW	SPXW260831C07680000	call	7680.0000	2026-08-31	40.0000	39.8000	40.1000	7670.1300	100000.00	80000.00	20000.00	25	8	177	237	0.746835443037975	0.108281590177059	0.108281590177059	false	false	false	true	false
b07ad194-5715-4575-a2e0-6326ccae365a	2026-08-25 14:31	2026-08-25 14:31	2026-08-25 14:31	SPXW	SPXW260825P07675000	put	7675.0000	2026-08-25	6.5300	6.4000	6.7000	7670.3000	109650.00	67600.00	26220.00	168	63	52196	1053	49.5688509021842	0.097101405731867	0.0936808027100273	true	false	false	true	false
b7b58cae-818b-4dad-8af2-664f27930262	2026-08-25 14:34	2026-08-25 14:34	2026-08-25 14:34	SPXW	SPXW260828P07670000	put	7670.0000	2026-08-28	34.9000	34.7000	35.0000	7671.5800	111680.00	87250.00	24430.00	32	8	1592	1744	0.912844036697248	0.132846003066784	0.132846003066784	false	false	false	true	false
350341bd-c8dc-4362-b4c0-8c6141b54060	2026-08-25 14:34	2026-08-25 14:34	2026-08-25 14:34	SPXW	SPXW260827C07680000	call	7680.0000	2026-08-27	24.7000	24.6000	24.9000	7671.5500	121030.00	86450.00	34580.00	49	6	824	279	2.95340501792115	0.123492561123963	0.123513083715817	false	false	false	true	false
bdc65d54-d89e-4280-8937-03b543b569df	2026-08-25 14:36	2026-08-25 14:36	2026-08-25 14:36	SPXW	SPXW260831C07680000	call	7680.0000	2026-08-31	40.3000	40.3000	40.6000	7671.1700	100750.00	0.00	100750.00	25	8	203	237	0.856540084388186	0.107758631363166	0.107758631363166	false	false	false	true	false
908eb6ba-ae46-4d1e-a488-0e4389fa42cc	2026-08-25 14:44	2026-08-25 14:44	2026-08-25 14:44	SPXW	SPXW260825C07670000	call	7670.0000	2026-08-25	5.2700	5.2000	5.4000	7673.4700	105910.00	0.00	95840.00	201	47	137049	1445	94.843598615917	0.0886226522249741	0.0856167001416115	true	false	false	true	false
7c500f55-f5cd-42ac-8d63-f870bf28b333	2026-08-25 14:45	2026-08-25 14:45	2026-08-25 14:45	SPXW	SPXW260825C07675000	call	7675.0000	2026-08-25	3.5800	3.3000	3.8000	7674.7300	194560.00	79350.00	107600.00	544	318	134099	1288	104.114130434783	0.0990427948076588	0.10736542415696	false	false	false	true	false
236b7cb9-7e60-4f51-8ff5-4e8d26cc0e20	2026-08-25 14:45	2026-08-25 14:45	2026-08-25 14:45	SPXW	SPXW260825C07675000	call	7675.0000	2026-08-25	3.9000	3.7000	4.0000	7675.1800	132300.00	73620.00	50970.00	339	196	134571	1288	104.480590062112	0.104375138890307	0.106690188560994	false	false	false	true	false
5bed6627-6383-4e13-98bd-19041f7eb4f5	2026-08-25 14:45	2026-08-25 14:45	2026-08-25 14:45	SPXW	SPXW260825C07670000	call	7670.0000	2026-08-25	6.2900	6.2000	6.6000	7675.2100	161120.00	2580.00	148900.00	256	84	138436	1445	95.8034602076125	0.0862874861153258	0.0849178394822157	true	false	false	true	false
95280521-b3ad-49f4-a09a-ecde5ff6528f	2026-08-25 14:46	2026-08-25 14:46	2026-08-25 14:46	SPXW	SPXW260825C07675000	call	7675.0000	2026-08-25	4.5800	4.4000	4.7000	7676.2800	100310.00	49750.00	43670.00	219	90	136994	1288	106.361801242236	0.105644515703118	0.107669237955354	false	false	false	true	false
03ddb42a-7c5f-4077-aa2c-f9a71e5bf072	2026-08-25 14:46	2026-08-25 14:46	2026-08-25 14:46	SPXW	SPXW260825C07665000	call	7665.0000	2026-08-25	11.7000	11.7000	11.9000	7676.0700	125190.00	0.00	125190.00	107	7	69292	3235	21.4194744976816	0.105854192545656	0.105854192545656	false	false	false	true	false
341923f1-3ee2-4554-9bfa-a20c1c50c269	2026-08-25 14:49	2026-08-25 14:49	2026-08-25 14:49	SPXW	SPXW260826P07675000	put	7675.0000	2026-08-26	14.7900	14.5000	14.9000	7676.1100	147870.00	147870.00	0.00	100	17	3972	1250	3.1776	0.0976141003656414	0.0981788794228815	true	false	false	true	false
4356d8bc-564b-4023-b4b4-f36075083389	2026-08-25 14:55	2026-08-25 14:54	2026-08-25 14:54	SPXW	SPXW260918P07660000	put	7660.0000	2026-09-18	84.6000	84.5000	84.9000	7675.4400	177660.00	0.00	177660.00	21	6	95	247	0.384615384615385	0.12881965006565	0.12881965006565	false	false	false	true	false
ef93af68-3c22-4bc9-9aaa-13b99b02ad35	2026-08-25 15:07	2026-08-25 15:06	2026-08-25 15:06	SPXW	SPXW260828P07670000	put	7670.0000	2026-08-28	34.7000	34.6000	34.7000	7672.3100	360880.00	360880.00	0.00	104	11	1888	1744	1.08256880733945	0.133385951690744	0.133385951690744	false	false	false	true	false
8b1053ae-dc44-4895-a821-9f6eb26a8a51	2026-08-25 15:10	2026-08-25 15:10	2026-08-25 15:10	SPXW	SPXW260825C07670000	call	7670.0000	2026-08-25	3.4000	3.3000	3.5000	7670.8600	128520.00	0.00	17000.00	378	21	146608	1445	101.458823529412	0.0990354075620047	0.0990354075620047	false	false	false	true	false
1cb42a4c-4ac0-4e37-a0e2-3cd233d712a8	2026-08-25 15:12	2026-08-25 15:11	2026-08-25 15:11	SPXW	SPXW260825P07675000	put	7675.0000	2026-08-25	5.5000	5.3000	5.5000	7670.6400	155640.00	155100.00	0.00	283	17	70763	1053	67.2013295346629	0.0921847036479911	0.0963440327772001	false	false	false	true	false
e6aacb4e-ca8a-468a-aa26-8844f5a5cd37	2026-08-25 15:12	2026-08-25 15:12	2026-08-25 15:12	SPXW	SPXW260826C07625000	call	7625.0000	2026-08-26	49.0000	48.5000	49.4000	7669.8700	147000.00	147000.00	0.00	30	7	1111	649	1.71186440677966	0.109158311608929	0.109158311608929	false	false	false	true	false
024b0278-4cfd-4858-8cbc-ad41c73790bb	2026-08-25 15:13	2026-08-25 15:13	2026-08-25 15:13	SPXW	SPXW260826C07675000	call	7675.0000	2026-08-26	13.1000	13.1000	13.2000	7670.6400	115280.00	0.00	115280.00	88	12	5022	1315	3.81901140684411	0.0924611237290661	0.0924611237290661	false	false	false	true	false
1abfc41a-e85b-4d3e-98f1-f97c7e47d1b7	2026-08-25 15:17	2026-08-25 15:17	2026-08-25 15:17	SPXW	SPXW260825P07670000	put	7670.0000	2026-08-25	4.3200	4.1000	4.4000	7667.4900	167030.00	55820.00	104790.00	387	91	139992	750	186.656	0.108448866667105	0.0969502577409874	false	false	false	true	false
051b9c23-9d28-4e7c-8210-9f80cc57072a	2026-08-25 15:24	2026-08-25 15:23	2026-08-25 15:23	SPXW	SPXW260828P07775000	put	7775.0000	2026-08-28	108.0000	106.4000	109.7000	7668.1600	216000.00	151200.00	64800.00	20	5	73	673	0.108469539375929	0.114129113683404	0.114129113683404	false	false	false	true	false
6056f5c1-398d-49f5-835f-121dda3880b6	2026-08-25 15:30	2026-08-25 15:30	2026-08-25 15:30	SPXW	SPXW260826C07670000	call	7670.0000	2026-08-26	14.8600	14.7000	14.9000	7670.0400	120330.00	77410.00	32560.00	81	13	5223	707	7.38755304101839	0.0897758387787624	0.0904004068269934	true	false	false	true	false
8713683d-7112-4f39-8eb2-31196a203875	2026-08-25 15:32	2026-08-25 15:32	2026-08-25 15:32	SPXW	SPXW260826C07670000	call	7670.0000	2026-08-26	14.2300	14.2000	14.5000	7669.1100	105320.00	0.00	105320.00	74	19	5344	707	7.55869872701556	0.089586599971218	0.0889621589634276	false	false	false	true	false
7b104698-5083-4226-a8db-8c6600ab5aad	2026-08-25 15:36	2026-08-25 15:36	2026-08-25 15:36	SPXW	SPXW260826P07670000	put	7670.0000	2026-08-26	13.8600	13.8000	14.1000	7670.9900	138630.00	0.00	138630.00	100	19	4853	705	6.88368794326241	0.0922556567890805	0.0916305627456919	false	false	false	true	false
fe752f7e-eeed-4033-8233-fb6712d7584f	2026-08-25 15:38	2026-08-25 15:38	2026-08-25 15:38	SPXW	SPXW260826C07670000	call	7670.0000	2026-08-26	15.7700	15.5000	15.8000	7671.3700	127700.00	127700.00	0.00	81	17	5728	707	8.1018387553041	0.0910996835342108	0.0917251192041518	false	false	false	true	false
4de0409b-c921-44bb-8067-8395d6143c7c	2026-08-25 15:42	2026-08-25 15:42	2026-08-25 15:42	SPXW	SPXW260826C07670000	call	7670.0000	2026-08-26	16.6500	16.6000	16.9000	7673.9300	136560.00	0.00	136560.00	82	22	6012	707	8.5035360678925	0.0887166672462918	0.0880868665848125	false	false	false	true	false
37ad3b3e-2b0e-4d8a-9509-168669628fe2	2026-08-25 15:43	2026-08-25 15:43	2026-08-25 15:43	SPXW	SPXW260918C07905000	call	7905.0000	2026-09-18	16.6500	16.7000	17.0000	7674.2200	2002995.00	0.00	0.00	1203	6	1241	76	16.3289473684211	0.103868278320429	0.103868278320429	false	false	false	true	false
23dea623-5da6-4c07-9761-ba30fbd79cc8	2026-08-25 15:43	2026-08-25 15:43	2026-08-25 15:43	SPXW	SPXW260918C07915000	call	7915.0000	2026-09-18	15.0500	15.0000	15.3000	7674.2200	1810515.00	0.00	0.00	1203	6	1227	56	21.9107142857143	0.103538667567858	0.103538667567858	false	false	false	true	false
ad9e3289-b8cb-4850-b6f2-8ee7997a4c47	2026-08-25 15:53	2026-08-25 15:52	2026-08-25 15:52	SPXW	SPXW260826P07675000	put	7675.0000	2026-08-26	14.9800	14.7000	15.1000	7673.9200	149840.00	118500.00	7500.00	100	15	5901	1250	4.7208	0.0917192300224196	0.0927197881565131	false	false	false	true	false
cd1cfe6c-a25a-4d4f-ade0-12c9020dd1f0	2026-08-25 15:55	2026-08-25 15:55	2026-08-25 15:55	SPXW	SPXW260825C07675000	call	7675.0000	2026-08-25	5.4000	4.8000	6.0000	7679.4200	113920.00	27970.00	85430.00	211	126	206298	1288	160.169254658385	0.276815895869063	0.26380972453962	false	false	false	true	false
bcc5b8f8-3012-40b1-ae26-9f86e10f101f	2026-08-25 15:55	2026-08-25 15:55	2026-08-25 15:55	SPXW	SPXW260825C07670000	call	7670.0000	2026-08-25	7.3400	7.2000	7.9000	7677.4300	143120.00	104390.00	38730.00	195	18	185145	1445	128.128027681661	0.263960767931749	0	false	false	false	true	false
d24411a4-d250-47cd-8252-a9037c6a92b3	2026-08-25 15:56	2026-08-25 15:56	2026-08-25 15:56	SPXW	SPXW260826P07675000	put	7675.0000	2026-08-26	14.2300	14.0000	14.3000	7676.4200	115260.00	105390.00	0.00	81	21	6371	1250	5.0968	0.0947304748159869	0.0959804429430193	false	false	false	true	false
ac8851c2-fe78-48cb-a8d6-5c54f723d1bc	2026-08-25 16:00	2026-08-25 15:59	2026-08-25 15:59	SPXW	SPXW260901P07675000	put	7675.0000	2026-09-01	45.3000	45.3000	45.8000	7676.2100	299000.00	0.00	299000.00	66	6	204	709	0.287729196050776	0.114928334083109	0.114692058796887	false	false	false	true	false
65b41d75-fed3-4cdb-8f41-e1c75934b0ad	2026-08-25 16:00	2026-08-25 16:00	2026-08-25 16:00	SPXW	SPXW260826P07675000	put	7675.0000	2026-08-26	14.0000	13.7000	14.1000	7677.2000	144200.00	144200.00	0.00	103	5	7031	1250	5.6248	0.0957814364558559	0.0970329907773357	false	false	false	true	false
15d4747f-c677-4a79-9c11-34fc0d82137b	2026-08-25 16:04	2026-08-25 16:02	2026-08-25 16:02	SPXW	SPXW260930C07800000	call	7800.0000	2026-09-30	68.8400	69.2000	69.5000	7677.2000	5851400.00	0.00	0.00	850	9	897	2982	0.300804828973843	0.112984393939093	0.112984393939093	false	false	false	true	false
59d106b0-2b38-45f6-bfa4-c3db79b91c2a	2026-08-25 16:06	2026-08-25 16:06	2026-08-25 16:06	SPXW	SPXW260828P07675000	put	7675.0000	2026-08-28	35.5000	35.2000	35.5000	7677.2800	127800.00	127800.00	0.00	36	9	1187	1451	0.818056512749828	0.136135708069126	0.136135708069126	true	false	false	true	false
163ecbdc-a3ac-409c-91ec-847d3412d883	2026-08-25 16:13	2026-08-25 16:12	2026-08-25 16:12	SPXW	SPXW260826C07675000	call	7675.0000	2026-08-26	16.2000	16.1000	16.4000	7677.2800	153900.00	137700.00	16200.00	95	6	7038	1315	5.35209125475285	0.0911521927209001	0.0911521927209001	false	false	false	true	false
3b2bb1b4-4586-41e8-b45d-eb29cc2f40a1	2026-08-25 16:13	2026-08-25 16:13	2026-08-25 16:13	SPXW	SPXW260826C07715000	call	7715.0000	2026-08-26	2.9200	2.8500	3.1000	7677.2800	101135.00	0.00	101135.00	346	43	6900	705	9.78723404255319	0.0908707236530655	0.0898297315508795	false	false	false	true	false
fd6ae84f-cd97-48df-878a-e95ab3e84201	2026-08-26 09:30	2026-08-25 16:40	2026-08-25 16:40	SPXW	SPXW260828C07750000	call	7750.0000	2026-08-28	11.0300	10.9000	11.1000	7677.2800	115815.00	115815.00	0.00	105	8	1181	2524	0.467908082408875	0.127977612142237	0.127977612142237	false	false	false	true	false
c25178c4-eb42-47ec-bed9-1fea20c5402e	2026-08-26 09:30	2026-08-25 16:40	2026-08-25 16:40	SPXW	SPXW260828C07650000	call	7650.0000	2026-08-28	56.0400	56.0000	56.4000	7677.2800	392315.00	0.00	392315.00	70	16	743	1879	0.39542309739223	0.142376851415383	0.142376851415383	false	false	false	true	false
24f7ee7b-15e5-4f51-b767-b982c015bbb8	2026-08-26 09:36	2026-08-26 09:36	2026-08-26 09:36	SPXW	SPXW260827C07670000	call	7670.0000	2026-08-27	26.3300	26.3000	26.7000	7669.4600	184300.00	0.00	184300.00	70	19	311	559	0.556350626118068	0.164046471728559	0.163422038321296	false	false	false	true	false
70cb43aa-c668-4332-a917-8916ad023963	2026-08-26 09:43	2026-08-26 09:43	2026-08-26 09:43	SPXW	SPXW260826P07695000	put	7695.0000	2026-08-26	18.8100	18.7000	19.2000	7680.8800	112870.00	1880.00	110990.00	60	13	343	284	1.20774647887324	0.129525801400577	0.126723648474324	false	false	false	true	false
046da8ec-1f2d-4ce9-8736-c8579d23f6a6	2026-08-26 09:44	2026-08-26 09:44	2026-08-26 09:44	SPXW	SPXW260826C07660000	call	7660.0000	2026-08-26	25.8100	25.4000	26.0000	7683.2300	258060.00	190720.00	67340.00	100	18	1378	571	2.41330998248687	0.118452588010782	0.124169623303175	false	false	false	true	false
33b3d8a1-e389-4e76-9b35-fee8c7058607	2026-08-26 09:44	2026-08-26 09:44	2026-08-26 09:44	SPXW	SPXW260826C07665000	call	7665.0000	2026-08-26	21.3900	21.0000	21.5000	7682.8100	106950.00	106950.00	0.00	50	14	2899	733	3.9549795361528	0.117634502833517	0.117634502833517	false	false	false	true	false
7c47b377-28a2-4069-a3d0-a5c796cc9c20	2026-08-26 09:46	2026-08-26 09:45	2026-08-26 09:45	SPXW	SPXW260826C07660000	call	7660.0000	2026-08-26	26.2100	26.2000	26.5000	7684.8000	131070.00	0.00	131070.00	50	11	1473	571	2.57968476357268	0.104869199258293	0.104869199258293	false	false	false	true	false
66f7a75e-b2e6-4ce1-b885-15cf74f20cf6	2026-08-26 09:46	2026-08-26 09:46	2026-08-26 09:46	SPXW	SPXW260826C07660000	call	7660.0000	2026-08-26	27.0100	26.9000	27.3000	7685.2800	108030.00	0.00	108030.00	40	8	1543	571	2.70227670753065	0.1137385736613	0.111480992348826	false	false	false	true	false
5566ba83-91ad-4d23-adec-9fe77f66db41	2026-08-26 09:49	2026-08-26 09:49	2026-08-26 09:49	SPXW	SPXW260827P07645000	put	7645.0000	2026-08-27	13.5200	13.4000	13.7000	7681.9800	135220.00	1350.00	112110.00	100	11	222	388	0.572164948453608	0.178775320212517	0.178056966629866	false	false	false	true	false
e0b193a7-8122-4251-bf8d-88170a619cb6	2026-08-26 09:54	2026-08-26 09:54	2026-08-26 09:54	SPXW	SPXW260826P07660000	put	7660.0000	2026-08-26	3.1000	3.1000	3.2000	7683.3900	100750.00	0.00	100750.00	325	35	8459	2665	3.17410881801126	0.136279903948886	0.138077271599545	false	false	false	true	false
0e240b84-9459-4465-b6c4-c10f585c2747	2026-08-26 09:54	2026-08-26 09:54	2026-08-26 09:54	SPXW	SPXW260826C07675000	call	7675.0000	2026-08-26	13.3800	13.3000	13.6000	7682.7700	135090.00	0.00	132410.00	101	28	9846	2650	3.71547169811321	0.109584115545904	0.109584115545904	true	false	false	true	false