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

85b9131f-475b-452f-9b2d-2ceb79c52688	2026-08-26 11:40	2026-08-26 11:40	2026-08-26 11:40	SPXW	SPXW260827C07670000	call	7670.0000	2026-08-27	28.2400	28.0000	28.3000	7674.0000	141190.00	141190.00	0.00	50	10	1072	559	1.91771019677996	0.16062129774734	0.16062129774734	false	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-26T15:48:55.759300Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
e624e40f-8fb2-40e8-bfdf-a456b23e6a48	2026-08-26 11:44	2026-08-26 11:44	2026-08-26 11:44	SPXW	SPXW260827C07670000	call	7670.0000	2026-08-27	30.4700	30.4000	30.7000	7677.9500	149280.00	0.00	149280.00	49	10	1151	559	2.05903398926655	0.161586964760383	0.161586964760383	false	false	false	true	false
a5fbc3f7-5647-4565-b09e-3ac3dc04005a	2026-08-26 11:51	2026-08-26 11:51	2026-08-26 11:51	SPXW	SPXW260826P07685000	put	7685.0000	2026-08-26	14.0000	13.1000	14.0000	7677.3800	168000.00	168000.00	0.00	120	6	22473	515	43.6368932038835	0.147255702870187	0.147255702870187	false	false	false	true	false
4352db70-356e-4172-854b-d7f6dfa84e33	2026-08-26 11:51	2026-08-26 11:51	2026-08-26 11:51	SPXW	SPXW260826P07675000	put	7675.0000	2026-08-26	7.0900	5.7000	8.0000	7677.3800	158000.00	156520.00	1480.00	223	26	48476	2552	18.9952978056426	0.12315216260529	0.132229536658206	false	false	false	true	false
b25cdb7a-19f6-465a-a59e-29a3bc2a9d4e	2026-08-26 11:56	2026-08-26 11:55	2026-08-26 11:55	SPXW	SPXW260828C07715000	call	7715.0000	2026-08-28	17.5800	17.4000	17.8000	7673.0800	109000.00	1750.00	107250.00	62	13	289	554	0.521660649819495	0.149773163808965	0.149280782703426	false	false	false	true	false
9662b45b-e874-4c0a-ba46-fb582534c94a	2026-08-26 12:06	2026-08-26 12:06	2026-08-26 12:06	SPXW	SPXW260826P07685000	put	7685.0000	2026-08-26	15.6000	15.5000	15.9000	7671.1400	416580.00	321360.00	92080.00	267	21	24108	515	46.8116504854369	0.10521078740569	0.0996403372790046	false	false	false	true	false
10fde0c9-8b6f-4659-8762-9a3e4447aded	2026-08-26 12:08	2026-08-26 12:08	2026-08-26 12:08	SPXW	SPXW260826C07660000	call	7660.0000	2026-08-26	14.7900	14.5000	14.9000	7672.4900	375750.00	272270.00	88800.00	254	52	7048	571	12.3432574430823	0.10181052823002	0.104055543280746	true	false	false	true	false
45824f20-2b26-4562-a733-879179fcf25f	2026-08-26 12:11	2026-08-26 12:10	2026-08-26 12:10	SPXW	SPXW260826P07680000	put	7680.0000	2026-08-26	14.0000	14.0000	14.1000	7668.7400	340200.00	0.00	340200.00	243	12	39672	2547	15.5759717314488	0.110841375642459	0.110841375642459	false	false	false	true	false
e1d2a273-ddb5-440b-9349-dba156d53bbc	2026-08-26 12:12	2026-08-26 12:12	2026-08-26 12:12	SPXW	SPXW260826P07680000	put	7680.0000	2026-08-26	12.1000	12.0000	12.2000	7671.0100	292800.00	266200.00	2400.00	242	53	39986	2547	15.6992540243424	0.106185787170264	0.104381813526502	false	false	false	true	false
5c6768dd-f301-4491-af65-1d48b95bb13d	2026-08-26 12:13	2026-08-26 12:12	2026-08-26 12:12	SPXW	SPXW260826C07660000	call	7660.0000	2026-08-26	13.2000	13.0000	13.3000	7670.6500	248160.00	1320.00	246840.00	188	19	7495	571	13.1260945709282	0.101103455986635	0.101103455986635	false	false	false	true	false
f571e4d0-d588-4057-a9d7-ca3075f05f06	2026-08-26 12:20	2026-08-26 12:19	2026-08-26 12:19	SPXW	SPXW260930C07675000	call	7675.0000	2026-09-30	127.8800	127.4000	128.0000	7667.8700	319710.00	319710.00	0.00	25	5	25	2044	0.0122309197651663	0.123808797389393	0.123808797389393	false	false	false	true	false
5ec7196c-5220-48d6-aa59-b9b84d4e6ef1	2026-08-26 12:21	2026-08-26 12:21	2026-08-26 12:21	SPXW	SPXW260826C07665000	call	7665.0000	2026-08-26	7.5000	7.4000	7.6000	7667.3500	112500.00	80250.00	0.00	150	27	16853	733	22.9918144611187	0.0991225010013833	0.0991225010013833	false	false	false	true	false
3a2940ad-2f67-44ad-8e96-15f47c8b96f3	2026-08-26 12:24	2026-08-26 12:24	2026-08-26 12:24	SPXW	SPXW260826P07670000	put	7670.0000	2026-08-26	7.5000	7.4000	7.6000	7667.8400	139500.00	0.00	81000.00	186	30	76190	2418	31.509511993383	0.103814944695716	0.103814944695716	true	false	false	true	false
ef932a1a-ce52-43b8-8cfc-1d55e4be9d9f	2026-08-26 12:26	2026-08-26 12:26	2026-08-26 12:26	SPXW	SPXW260826P07665000	put	7665.0000	2026-08-26	5.6000	5.5000	5.6000	7666.9800	109760.00	109760.00	0.00	196	26	65702	1337	49.1413612565445	0.108031697655768	0.106934005093325	false	false	false	true	false
701954d4-ed06-4021-a68f-f12886de725f	2026-08-26 12:27	2026-08-26 12:27	2026-08-26 12:27	SPXW	SPXW260826C07665000	call	7665.0000	2026-08-26	6.9000	6.8000	7.0000	7666.3300	102810.00	0.00	102120.00	149	17	18396	733	25.0968622100955	0.0999660819422201	0.0999660819422201	false	false	false	true	false
a6862808-0e05-49f7-b625-93ca9a271cb5	2026-08-26 12:31	2026-08-26 12:31	2026-08-26 12:31	SPXW	SPXW260831P07675000	put	7675.0000	2026-08-31	44.7000	44.6000	44.9000	7666.5500	183270.00	84930.00	98340.00	41	10	264	787	0.335451080050826	0.118493766030013	0.118493766030013	false	false	false	true	false
1344dd0a-5889-4865-9954-4a96ae28c93e	2026-08-26 12:31	2026-08-26 12:31	2026-08-26 12:31	SPXW	SPXW260831C07700000	call	7700.0000	2026-08-31	27.9000	27.8000	27.9000	7666.5600	184140.00	184140.00	0.00	66	6	451	5730	0.0787085514834206	0.114171731872645	0.114171731872645	false	false	false	true	false
d70e1e01-2f00-46f9-a907-36d4599d603e	2026-08-26 12:31	2026-08-26 12:31	2026-08-26 12:31	SPXW	SPXW260831P07675000	put	7675.0000	2026-08-31	44.6000	44.5000	44.6000	7666.9200	263140.00	263140.00	0.00	59	8	323	787	0.410419313850064	0.118745064723078	0.118745064723078	false	false	false	true	false
5a8687ea-670d-422c-87e6-5c48fd6bbcce	2026-08-26 12:32	2026-08-26 12:32	2026-08-26 12:32	SPXW	SPXW260826C07670000	call	7670.0000	2026-08-26	4.0200	3.9000	4.2000	7665.6700	201200.00	0.00	182320.00	500	71	47961	2542	18.8674272226593	0.0982870077813704	0.096573582832325	false	false	false	true	false
bdb0544d-3205-4912-8327-0ddc9ddceb7c	2026-08-26 12:36	2026-08-26 12:36	2026-08-26 12:36	SPXW	SPXW260826C07670000	call	7670.0000	2026-08-26	4.0100	3.9000	4.2000	7666.1400	100290.00	0.00	94620.00	250	60	49233	2542	19.36782061369	0.0960211031352027	0.0925822228728846	false	false	false	true	false
f303571c-3a7f-4b77-ae18-7464d1109b12	2026-08-26 12:38	2026-08-26 12:38	2026-08-26 12:38	SPXW	SPXW260909C07740000	call	7740.0000	2026-09-09	34.7300	33.6000	35.3000	7662.4700	138910.00	121560.00	17350.00	40	5	42	73	0.575342465753425	0.103822818561961	0.103640852028659	false	false	false	true	false
ec9050a1-369e-4cac-a33c-8554c30eaa11	2026-08-26 12:38	2026-08-26 12:38	2026-08-26 12:38	SPXW	SPXW260828C07780000	call	7780.0000	2026-08-28	2.9000	2.8500	3.0000	7662.4700	145000.00	137170.00	7830.00	500	9	1352	1642	0.823386114494519	0.143273826283504	0.143273826283504	false	false	false	true	false
bb134eba-aa0d-41b1-9eef-eb5abf4b2816	2026-08-26 12:38	2026-08-26 12:38	2026-08-26 12:38	SPXW	SPXW260904C07740000	call	7740.0000	2026-09-04	26.9000	26.8000	27.2000	7662.4700	532620.00	486890.00	45730.00	198	6	252	424	0.594339622641509	0.114178486685574	0.114178486685574	false	false	false	true	false
9d9f52e5-3179-4ae9-974d-3c72dd1c227d	2026-08-26 12:38	2026-08-26 12:38	2026-08-26 12:38	SPXW	SPXW260831C07755000	call	7755.0000	2026-08-31	9.3000	9.2000	9.5000	7662.4600	465000.00	53940.00	411060.00	500	13	634	877	0.722919042189282	0.106608830897492	0.106608830897492	false	false	false	true	false
8eb77865-df22-4534-8ddb-0fb6b9d3ccf3	2026-08-26 12:38	2026-08-26 12:38	2026-08-26 12:38	SPXW	SPXW260831C07770000	call	7770.0000	2026-08-31	6.5000	6.4000	6.7000	7662.3700	293150.00	247650.00	45500.00	451	10	1317	699	1.88412017167382	0.104502775759793	0.104502775759793	false	false	false	true	false
3bf81a8b-5e4a-4f68-994d-11738b0ad3f9	2026-08-26 12:38	2026-08-26 12:38	2026-08-26 12:38	SPXW	SPXW260828C07735000	call	7735.0000	2026-08-28	9.5000	9.4000	9.7000	7662.4600	152950.00	125400.00	27550.00	161	7	332	359	0.924791086350975	0.148479827109425	0.148479827109425	false	false	false	true	false
2a1686c2-2393-49cc-9efd-09cd997f1f33	2026-08-26 12:38	2026-08-26 12:38	2026-08-26 12:38	SPXW	SPXW260908C07760000	call	7760.0000	2026-09-08	24.8000	24.6000	24.8000	7662.4600	545600.00	545600.00	0.00	220	6	222	334	0.664670658682635	0.10045358304221	0.10045358304221	false	false	false	true	false
a1ab7639-6860-4bf2-aa15-db7c1c327b9e	2026-08-26 12:40	2026-08-26 12:40	2026-08-26 12:40	SPXW	SPXW260827C07750000	call	7750.0000	2026-08-27	2.0000	1.9500	2.1000	7659.3300	100000.00	76000.00	24000.00	500	15	3671	2116	1.73487712665406	0.153089385990265	0.153089385990265	false	false	false	true	false
c520c087-b440-4e97-8a68-8528726a2291	2026-08-26 12:41	2026-08-26 12:41	2026-08-26 12:41	SPXW	SPXW260826C07660000	call	7660.0000	2026-08-26	6.8800	6.7000	7.0000	7660.3100	103130.00	98990.00	4140.00	150	46	11370	571	19.9124343257443	0.110899685363267	0.112583575467245	true	false	false	true	false
a52d92a5-24d8-47fa-9aaa-4070bbd064b8	2026-08-26 12:43	2026-08-26 12:43	2026-08-26 12:43	SPXW	SPXW260827P07660000	put	7660.0000	2026-08-27	26.9000	26.6000	26.9000	7659.4900	134500.00	134500.00	0.00	50	8	1105	287	3.85017421602787	0.169079804401225	0.169079804401225	false	false	false	true	false
959321ee-29c7-4a92-943b-03e8d39fb601	2026-08-26 12:43	2026-08-26 12:43	2026-08-26 12:43	SPXW	SPXW260826P07660000	put	7660.0000	2026-08-26	8.1000	8.1000	8.3000	7658.1500	125580.00	830.00	124750.00	155	24	75516	2665	28.3362101313321	0.123534360780748	0.1218334213732	false	false	false	true	false
a9f8ec35-1598-4afe-9171-198029f002fa	2026-08-26 12:44	2026-08-26 12:43	2026-08-26 12:43	SPXW	SPXW260826P07655000	put	7655.0000	2026-08-26	6.3000	6.2000	6.4000	7657.6800	115350.00	60540.00	54810.00	183	42	51211	4474	11.4463567277604	0.129480174269286	0.130739692681148	false	false	false	true	false
669fbce9-ef6e-438d-b3a8-45ac0283c74a	2026-08-26 12:44	2026-08-26 12:43	2026-08-26 12:43	SPXW	SPXW260826P07655000	put	7655.0000	2026-08-26	6.3000	6.1000	6.4000	7657.6100	166430.00	12800.00	153010.00	264	17	51515	4474	11.5143048725972	0.13021994596696	0.126795138212823	false	false	false	true	false
20b6c823-9d55-48b9-88bd-71c81985e3db	2026-08-26 12:44	2026-08-26 12:44	2026-08-26 12:44	SPXW	SPXW260826P07670000	put	7670.0000	2026-08-26	14.7000	14.6000	14.8000	7657.8500	142590.00	141120.00	0.00	97	8	81389	2418	33.6596360628619	0.120801866403818	0.120801866403818	false	false	false	true	false
ff701188-dffc-497e-ba7b-19a50626c481	2026-08-26 12:46	2026-08-26 12:46	2026-08-26 12:46	SPXW	SPXW260826C07665000	call	7665.0000	2026-08-26	3.5100	3.4000	3.7000	7657.8300	166190.00	3600.00	139820.00	474	66	27257	733	37.1855388813097	0.111871344249158	0.109498756852269	false	false	false	true	false
a86dd44b-aae5-47a7-8062-032bd8433c93	2026-08-26 12:59	2026-08-26 12:59	2026-08-26 12:59	SPXW	SPXW260826P07660000	put	7660.0000	2026-08-26	3.9000	3.7000	4.0000	7664.8000	174540.00	4400.00	169760.00	448	49	83932	2665	31.4941838649156	0.108344753202753	0.104559330702131	false	false	false	true	false
48221d5f-c8f9-4c9a-b08e-6e118c04dd06	2026-08-26 13:08	2026-08-26 13:08	2026-08-26 13:08	SPXW	SPXW260828C07585000	call	7585.0000	2026-08-28	96.1000	95.5000	96.5000	7668.0800	144150.00	144150.00	0.00	15	5	163	96	1.69791666666667	0.179555805879646	0.179555805879646	false	false	false	true	false
5a7c2ef5-ed32-4f25-8e96-670c9c488b72	2026-08-26 13:14	2026-08-26 13:14	2026-08-26 13:14	SPXW	SPXW260826C07680000	call	7680.0000	2026-08-26	1.3000	1.2500	1.3500	7668.8300	199810.00	199160.00	0.00	1537	15	107410	3968	27.0690524193548	0.0920423182154441	0.0920423182154441	false	false	false	true	false
c4be1716-77f9-4135-9142-5edde6fdf832	2026-08-26 13:15	2026-08-26 13:15	2026-08-26 13:15	SPXW	SPXW260826C07675000	call	7675.0000	2026-08-26	3.0000	2.9500	3.1000	7669.4400	126460.00	125860.00	600.00	421	38	86963	2650	32.8162264150943	0.0989390271258286	0.0975763761931842	false	false	false	true	false
5fc5bbd7-8faf-4dce-b57c-2add5f3edd42	2026-08-26 13:15	2026-08-26 13:15	2026-08-26 13:15	SPXW	SPXW260826C07670000	call	7670.0000	2026-08-26	5.5000	5.4000	5.6000	7670.3800	103990.00	103990.00	0.00	189	27	73792	2542	29.0291109362707	0.0972129895915872	0.0990618879769772	false	false	false	true	false
5def8aed-a9c9-4ef8-aa10-397ba0314d55	2026-08-26 13:15	2026-08-26 13:15	2026-08-26 13:15	SPXW	SPXW260826C07670000	call	7670.0000	2026-08-26	5.8100	5.7000	6.0000	7671.2200	119620.00	2910.00	115530.00	206	52	74328	2542	29.2399685287175	0.0980832209269878	0.0927688177280242	true	false	false	true	false
cd306c35-cef8-42d2-b930-407d1f32747d	2026-08-26 13:16	2026-08-26 13:16	2026-08-26 13:16	SPXW	SPXW260827P07585000	put	7585.0000	2026-08-27	4.0300	3.9000	4.2000	7671.4300	185160.00	0.00	130910.00	459	42	1496	305	4.90491803278689	0.182332017656665	0.181038496352316	false	false	false	true	false
fc7466af-c1dc-48e5-8279-6c66c3d6e558	2026-08-26 13:17	2026-08-26 13:16	2026-08-26 13:16	SPXW	SPXW260826P07680000	put	7680.0000	2026-08-26	10.2400	10.2000	10.5000	7672.3300	207860.00	0.00	205780.00	203	27	43147	2547	16.9403219473891	0.108334313463905	0.106209788375009	false	false	false	true	false
9bed9842-eb83-43e0-8d55-d425c0a3ed83	2026-08-26 13:17	2026-08-26 13:16	2026-08-26 13:16	SPXW	SPXW260826P07680000	put	7680.0000	2026-08-26	10.2000	10.1000	10.3000	7672.6800	102000.00	21420.00	0.00	100	8	43369	2547	17.0274833137024	0.109267883291442	0.109267883291442	false	false	false	true	false
8eed4d2a-aeeb-47a4-8101-41c7669527c6	2026-08-26 13:23	2026-08-26 13:22	2026-08-26 13:22	SPXW	SPXW260827P07595000	put	7595.0000	2026-08-27	4.7000	4.6000	4.9000	7671.8600	114680.00	0.00	102460.00	244	24	870	242	3.59504132231405	0.175021251842136	0.175021251842136	false	false	false	true	false
c9c4f354-0e56-47e8-8e21-f5be0845c8d7	2026-08-26 13:34	2026-08-26 13:34	2026-08-26 13:34	SPXW	SPXW260826P07675000	put	7675.0000	2026-08-26	4.8300	4.7000	5.0000	7675.2500	121680.00	990.00	108190.00	252	67	66267	2552	25.9666927899687	0.0995000749156126	0.0995000749156126	true	false	false	true	false
4f30f9be-d786-484e-a6b5-0cf66b112f4c	2026-08-26 13:34	2026-08-26 13:34	2026-08-26 13:34	SPXW	SPXW260827C07690000	call	7690.0000	2026-08-27	18.2000	18.1000	18.3000	7675.0500	134680.00	132860.00	0.00	74	5	1416	300	4.72	0.153549592750598	0.153549592750598	false	false	false	true	false
a704f2de-3312-4eeb-8697-b516f71e3210	2026-08-26 13:36	2026-08-26 13:36	2026-08-26 13:36	SPXW	SPXW260826C07675000	call	7675.0000	2026-08-26	5.6000	5.4000	5.7000	7675.8500	143360.00	89040.00	54320.00	256	36	102648	2650	38.7350943396226	0.10105980536033	0.10105980536033	false	false	false	true	false
31cd824f-3eb3-4d62-a32e-3adb707c3355	2026-08-26 13:36	2026-08-26 13:36	2026-08-26 13:36	SPXW	SPXW260826C07670000	call	7670.0000	2026-08-26	7.8100	7.7000	8.0000	7675.3000	117120.00	0.00	63210.00	150	27	83914	2542	33.0110149488592	0.0936075556969892	0.0914096314425682	true	false	false	true	false
7003ed35-fc00-4d6b-90cd-4382205c94dc	2026-08-26 13:38	2026-08-26 13:38	2026-08-26 13:38	SPXW	SPXW260826C07670000	call	7670.0000	2026-08-26	8.0700	7.9000	8.1000	7675.1200	116980.00	84180.00	0.00	145	37	84386	2542	33.1966955153422	0.0989533786047263	0.101119074620027	true	false	false	true	false