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.

523,327 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts523,327 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

11fb1a16-fad1-4526-abe1-ac100c37d1b9	2026-08-28 13:19	2026-08-28 13:19	2026-08-28 13:19	SPXW	SPXW260828C07710000	call	7710.0000	2026-08-28	10.1400	10.0000	10.2000	7710.4300	101350.00	92260.00	0.00	100	27	14588	1438	10.144645340751	0.183029708725525	0.184890562147132	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-28T17:47:47.104019Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
bedd41d1-2da5-4ccb-90bf-0ff0ff53e61c	2026-08-28 13:21	2026-08-28 13:21	2026-08-28 13:21	SPXW	SPXW260828P07710000	put	7710.0000	2026-08-28	13.0800	12.9000	13.1000	7706.1600	130840.00	115240.00	0.00	100	26	61530	1732	35.5254041570439	0.206453025621416	0.206453025621416	false	false	false	true	false
da6c2f1b-044a-484a-a687-dac1098b518c	2026-08-28 13:23	2026-08-28 13:23	2026-08-28 13:23	SPXW	SPXW260831C07700000	call	7700.0000	2026-08-31	26.9500	26.7000	27.0000	7706.5100	269540.00	269540.00	0.00	100	23	2095	7862	0.266471635716103	0.0795295928381093	0.0798932151224621	false	false	false	true	false
ba48b897-0184-4cc1-9bd7-3cdb313f6ff7	2026-08-28 13:25	2026-08-28 13:25	2026-08-28 13:25	SPXW	SPXW260828C07705000	call	7705.0000	2026-08-28	11.5400	11.4000	11.6000	7707.8000	115440.00	115440.00	0.00	100	30	9189	1015	9.05320197044335	0.189290138574266	0.191197353517798	true	false	false	true	false
19e27108-b14c-4621-9674-e21b0238906d	2026-08-28 13:27	2026-08-28 13:27	2026-08-28 13:27	SPXW	SPXW260828P07710000	put	7710.0000	2026-08-28	11.4000	11.3000	11.5000	7707.8100	114000.00	86640.00	0.00	100	10	62432	1732	36.0461893764434	0.196696734658934	0.196696734658934	false	false	false	true	false
f9b8d8eb-66e8-47c6-a894-55bb9c344e8c	2026-08-28 13:28	2026-08-28 13:28	2026-08-28 13:28	SPXW	SPXW260831C07720000	call	7720.0000	2026-08-31	16.5000	16.4000	16.5000	7708.4700	123750.00	123750.00	0.00	75	5	2175	706	3.08073654390935	0.0743414366345248	0.0743414366345248	false	false	false	true	false
ee0da2ea-8b88-4bcd-b9b1-292a995c35d9	2026-08-28 13:28	2026-08-28 13:28	2026-08-28 13:28	SPXW	SPXW260828C07705000	call	7705.0000	2026-08-28	12.2000	12.1000	12.2000	7709.1600	124440.00	124440.00	0.00	102	7	9860	1015	9.71428571428571	0.190087517410504	0.190087517410504	false	false	false	true	false
da717b27-e41c-4a3c-aeb2-6a994cb638fa	2026-08-28 13:28	2026-08-28 13:28	2026-08-28 13:28	SPXW	SPXW260828C07705000	call	7705.0000	2026-08-28	12.5000	12.4000	12.6000	7710.5900	193750.00	187500.00	0.00	155	18	10197	1015	10.0463054187192	0.179998126838219	0.179998126838219	false	false	false	true	false
466436c6-4707-40bc-99d9-57bd985604a1	2026-08-28 13:29	2026-08-28 13:29	2026-08-28 13:29	SPXW	SPXW260828P07710000	put	7710.0000	2026-08-28	10.6800	10.5000	10.8000	7709.1000	160200.00	153840.00	0.00	150	35	63125	1732	36.4463048498845	0.195721818319498	0.199566378632505	false	false	false	true	false
46d0ac02-b246-41a6-ab40-8c0e961139d2	2026-08-28 13:30	2026-08-28 13:29	2026-08-28 13:29	SPXW	SPXW260828P07710000	put	7710.0000	2026-08-28	11.8000	11.7000	11.8000	7707.0600	178180.00	178180.00	0.00	151	13	63464	1732	36.6420323325635	0.19842482579995	0.19842482579995	false	false	false	true	false
85f62596-d823-42fd-a861-90cf9a18fbfc	2026-08-28 13:31	2026-08-28 13:31	2026-08-28 13:31	SPXW	SPXW260831C07705000	call	7705.0000	2026-08-31	23.5000	23.5000	23.6000	7707.4900	202100.00	0.00	202100.00	86	10	783	409	1.91442542787286	0.075204350508507	0.075204350508507	false	false	false	true	false
d9fe4f56-ad10-4c31-a211-64159bb6a5ae	2026-08-28 13:32	2026-08-28 13:32	2026-08-28 13:32	SPXW	SPXW260828C07705000	call	7705.0000	2026-08-28	11.5000	11.4000	11.5000	7708.6700	113850.00	113850.00	0.00	99	10	11093	1015	10.9290640394089	0.184746350525021	0.184746350525021	false	false	false	true	false
c16739c5-cbde-447d-8027-ddef3f8fbcb3	2026-08-28 13:32	2026-08-28 13:32	2026-08-28 13:32	SPXW	SPXW260831C07705000	call	7705.0000	2026-08-31	24.6000	24.5000	24.8000	7708.6700	206640.00	34440.00	172200.00	84	9	884	409	2.16136919315403	0.076863151099011	0.076863151099011	false	false	false	true	false
ef589c3f-ad02-474e-81d9-b8378d2016f2	2026-08-28 13:33	2026-08-28 13:33	2026-08-28 13:33	SPXW	SPXW260828C07710000	call	7710.0000	2026-08-28	10.0500	9.9000	10.1000	7711.8200	150780.00	119780.00	0.00	150	38	19140	1438	13.3101529902643	0.175485393255873	0.177438357980878	false	false	false	true	false
85938c24-fabe-4e88-be16-b22a662b39b2	2026-08-28 13:33	2026-08-28 13:33	2026-08-28 13:33	SPXW	SPXW260831C07730000	call	7730.0000	2026-08-31	12.9100	12.8000	13.2000	7711.9400	258210.00	3870.00	254340.00	200	22	7116	687	10.3580786026201	0.0710837782488201	0.0707073788248065	true	false	false	true	false
e02d2eb8-9f57-42f4-8b39-07d22f7d5249	2026-08-28 13:34	2026-08-28 13:34	2026-08-28 13:34	SPXW	SPXW260904P07575000	put	7575.0000	2026-09-04	10.8600	10.4000	10.5000	7711.4600	1303200.00	0.00	0.00	1200	9	3171	1041	3.04610951008646	0.1303573642609	0.1303573642609	false	false	false	true	false
1ee82eb6-32f6-4ee4-9fe7-1b23420898c2	2026-08-28 13:34	2026-08-28 13:34	2026-08-28 13:34	SPXW	SPXW260904P07700000	put	7700.0000	2026-09-04	40.2900	38.0000	38.3000	7711.4600	3223200.00	0.00	0.00	800	11	3181	2704	1.17640532544379	0.113620348186436	0.113620348186436	false	false	false	true	false
9fd0e02b-4614-4cd2-bb2a-ef65707c5f0b	2026-08-28 13:35	2026-08-28 13:35	2026-08-28 13:35	SPXW	SPXW260831C07710000	call	7710.0000	2026-08-31	22.6000	22.6000	22.7000	7711.9400	203400.00	0.00	203400.00	90	5	1255	907	1.38368246968026	0.0729754024422578	0.0729754024422578	false	false	false	true	false
469a22c8-8965-4880-9c9a-dd97c8bc8757	2026-08-28 13:37	2026-08-28 13:36	2026-08-28 13:36	SPXW	SPXW260828C07720000	call	7720.0000	2026-08-28	4.8000	4.7000	4.9000	7712.3500	102720.00	6240.00	83040.00	214	24	38483	1978	19.4555106167846	0.15797834756783	0.15797834756783	false	false	false	true	false
e7b9481e-cb87-4626-a999-07d80de66040	2026-08-28 13:39	2026-08-28 13:38	2026-08-28 13:38	SPXW	SPXW260828P07710000	put	7710.0000	2026-08-28	9.6300	9.4000	9.7000	7710.1800	146450.00	140750.00	0.00	152	36	66174	1732	38.2066974595843	0.191072448934431	0.195041416371633	false	false	false	true	false
d2b34f98-9cfa-4e6b-a3f3-b9ef4d2f56e7	2026-08-28 13:40	2026-08-28 13:40	2026-08-28 13:40	SPXW	SPXW260831C07730000	call	7730.0000	2026-08-31	10.8000	10.6000	10.9000	7704.8500	216000.00	32400.00	183600.00	200	11	7379	687	10.7409024745269	0.0722344995813229	0.0722344995813229	false	false	false	true	false
e5a1ce13-d965-4595-8543-49ee79a2650d	2026-08-28 13:40	2026-08-28 13:40	2026-08-28 13:40	SPXW	SPXW260828P07800000	put	7800.0000	2026-08-28	94.0000	94.0000	94.6000	7705.3800	178600.00	0.00	178600.00	19	8	1919	1185	1.61940928270042	0.290863082248131	0.290863082248131	false	false	false	true	false
054c3146-5fb1-4c78-8899-196aec10b11f	2026-08-28 13:41	2026-08-28 13:41	2026-08-28 13:41	SPXW	SPXW260828P07705000	put	7705.0000	2026-08-28	8.5000	8.5000	8.6000	7706.6400	180200.00	0.00	180200.00	212	18	56886	1002	56.7724550898204	0.18694568605293	0.18694568605293	false	false	false	true	false
e3d12df0-a88f-4c4a-b09e-68c15356035b	2026-08-28 13:42	2026-08-28 13:42	2026-08-28 13:42	SPXW	SPXW260828C07710000	call	7710.0000	2026-08-28	7.9500	7.8000	8.0000	7707.9400	119280.00	110590.00	0.00	150	30	22444	1438	15.6077885952712	0.178194556222857	0.180214573386893	false	false	false	true	false
49e17bdd-1872-43ad-bb1a-3d2eb89c21d4	2026-08-28 13:43	2026-08-28 13:43	2026-08-28 13:43	SPXW	SPXW260828C07710000	call	7710.0000	2026-08-28	8.2000	8.0000	8.2000	7708.3700	162360.00	162360.00	0.00	198	37	22820	1438	15.8692628650904	0.180371057861431	0.180466618277121	false	false	false	true	false
eaebcad6-bcf2-4dd0-b755-69a50fb8e109	2026-08-28 13:44	2026-08-28 13:43	2026-08-28 13:43	SPXW	SPXW260828P07710000	put	7710.0000	2026-08-28	10.0700	9.9000	10.2000	7708.4700	151110.00	145110.00	0.00	150	38	67870	1732	39.1859122401848	0.186992047565299	0.191040771658887	false	false	false	true	false
a9b90ccb-6e5c-4682-abd7-7daa53a119b2	2026-08-28 13:46	2026-08-28 13:46	2026-08-28 13:46	SPXW	SPXW260828C07710000	call	7710.0000	2026-08-28	9.1900	9.0000	9.3000	7711.2800	185730.00	178470.00	1800.00	202	46	23895	1438	16.6168289290681	0.171312091877255	0.169269669539692	false	false	false	true	false
802a165b-d621-4aa4-bcb7-9d7fededebce	2026-08-28 13:46	2026-08-28 13:46	2026-08-28 13:46	SPXW	SPXW260828P07710000	put	7710.0000	2026-08-28	7.2500	7.2000	7.5000	7712.6900	108710.00	0.00	108710.00	150	40	68705	1732	39.6680138568129	0.175614807375665	0.173558575835851	false	false	false	true	false
d436da7d-9bc8-4a29-bd9b-b96ca15e3f1d	2026-08-28 13:47	2026-08-28 13:47	2026-08-28 13:47	SPXW	SPXW260831C07730000	call	7730.0000	2026-08-31	12.4000	12.3000	12.6000	7712.8400	248000.00	40920.00	207080.00	200	14	7813	687	11.372634643377	0.0675463093042109	0.0675463093042109	false	false	false	true	false
6d0443b7-3b92-4a03-8c7f-1b9bd7811494	2026-08-28 13:48	2026-08-28 13:47	2026-08-28 13:47	SPXW	SPXW260828P07710000	put	7710.0000	2026-08-28	7.9400	7.7000	8.0000	7712.4200	161980.00	161190.00	0.00	204	42	69411	1732	40.0756351039261	0.184350586077352	0.186413211399998	false	false	false	true	false
38187067-dbf4-4701-9e41-e7644523735f	2026-08-28 13:48	2026-08-28 13:48	2026-08-28 13:48	SPXW	SPXW260828P07705000	put	7705.0000	2026-08-28	5.1600	5.1000	5.4000	7713.3000	106220.00	0.00	106220.00	206	41	60172	1002	60.0518962075848	0.182123588932592	0.177704463414651	false	false	false	true	false
23eb6d10-5013-472f-9ecd-e649b32f1328	2026-08-28 13:49	2026-08-28 13:49	2026-08-28 13:49	SPXW	SPXW260828P07710000	put	7710.0000	2026-08-28	6.3600	6.3000	6.5000	7714.3600	127160.00	0.00	127160.00	200	40	70103	1732	40.4751732101617	0.173843692024036	0.173843692024036	false	false	false	true	false
c5e26a4e-d486-430a-83cc-418e145f6701	2026-08-28 13:49	2026-08-28 13:49	2026-08-28 13:49	SPXW	SPXW260831P07650000	put	7650.0000	2026-08-31	4.4100	4.3000	4.6000	7714.5500	225380.00	153670.00	69010.00	511	29	7344	5955	1.23324937027708	0.0895012350364266	0.0895012350364266	false	false	false	true	false
2638ac76-5250-4832-ba35-ea4ec5a50fa9	2026-08-28 13:49	2026-08-28 13:49	2026-08-28 13:49	SPXW	SPXW260831C07730000	call	7730.0000	2026-08-31	13.1000	13.0000	13.3000	7714.5400	123140.00	28820.00	94320.00	94	8	7934	687	11.5487627365357	0.0677115054311273	0.0677115054311273	false	false	false	true	false
60dc8949-f68e-487b-85c1-d9a1a6689479	2026-08-28 13:50	2026-08-28 13:50	2026-08-28 13:50	SPXW	SPXW260828P07715000	put	7715.0000	2026-08-28	9.1500	8.9000	9.2000	7713.5300	182970.00	182970.00	0.00	200	45	67829	1492	45.4617962466488	0.171432790339243	0.171432790339243	false	false	false	true	false
0d4e5981-c1b3-4349-bac1-8f789b868897	2026-08-28 13:52	2026-08-28 13:52	2026-08-28 13:52	SPXW	SPXW260828P07715000	put	7715.0000	2026-08-28	8.4300	8.3000	8.6000	7714.2700	168580.00	0.00	168580.00	200	48	68368	1492	45.8230563002681	0.17029915816488	0.168212713502203	false	false	false	true	false
f76ef518-dc02-445d-bec8-84987ed0549f	2026-08-28 13:53	2026-08-28 13:52	2026-08-28 13:52	SPXW	SPXW260828C07715000	call	7715.0000	2026-08-28	7.5300	7.3000	7.5000	7714.9200	152180.00	152180.00	0.00	202	49	28502	1006	28.3320079522863	0.154613716630393	0.154613716630393	false	false	false	true	false
d93de314-ea6d-4050-9f96-d54385b56595	2026-08-28 13:55	2026-08-28 13:55	2026-08-28 13:55	SPXW	SPXW260828C07715000	call	7715.0000	2026-08-28	6.3800	6.3000	6.6000	7713.2100	133270.00	0.00	133270.00	209	45	29343	1006	29.1679920477137	0.154404893396601	0.150171708752138	false	false	false	true	false
c6ca3d10-1197-4036-88b5-f03fbf359dc5	2026-08-28 13:55	2026-08-28 13:55	2026-08-28 13:55	SPXW	SPXW260911P07625000	put	7625.0000	2026-09-11	31.5000	31.8000	32.1000	7713.0500	201600.00	0.00	0.00	64	6	271	316	0.857594936708861	0.117299040565892	0.117299040565892	false	false	false	true	false
c12d8ca0-8bb4-44fb-a2b7-95dcd68a307c	2026-08-28 13:55	2026-08-28 13:55	2026-08-28 13:55	SPXW	SPXW260911C07850000	call	7850.0000	2026-09-11	12.4000	11.8000	12.1000	7713.0500	116560.00	0.00	0.00	94	6	568	934	0.60813704496788	0.0875298502540305	0.0875298502540305	false	false	false	true	false
bd95087f-1f63-4931-9e15-e5e88b7dd6b0	2026-08-28 13:55	2026-08-28 13:55	2026-08-28 13:55	SPXW	SPXW260911C07750000	call	7750.0000	2026-09-11	45.8000	45.0000	45.4000	7713.0500	1062560.00	0.00	0.00	232	6	975	1258	0.775039745627981	0.0956100566417379	0.0956100566417379	false	false	false	true	false
5052d134-27ab-4f32-9c4d-1e63e2531368	2026-08-28 13:55	2026-08-28 13:55	2026-08-28 13:55	SPXW	SPXW260911C07975000	call	7975.0000	2026-09-11	1.3000	1.1500	1.3000	7713.0500	113880.00	0.00	0.00	876	6	1080	819	1.31868131868132	0.0842208622056696	0.0842208622056696	false	false	false	true	false
4e3d3e48-8f9e-44e6-9dbd-e6cb76ba7837	2026-08-28 13:55	2026-08-28 13:55	2026-08-28 13:55	SPXW	SPXW260904C07775000	call	7775.0000	2026-09-04	17.1400	16.7000	16.9000	7713.0500	164544.00	0.00	0.00	96	6	396	1392	0.28448275862069	0.0911551763667711	0.0911551763667711	false	false	false	true	false
0d27479a-5214-40b4-a77b-629edc957323	2026-08-28 13:55	2026-08-28 13:55	2026-08-28 13:55	SPXW	SPXW260904C07650000	call	7650.0000	2026-09-04	88.2000	87.1000	87.4000	7713.0500	1358280.00	0.00	0.00	154	6	213	1194	0.178391959798995	0.108330693247307	0.108330693247307	false	false	false	true	false
c59a20db-e04d-4312-9c55-b76bd4257abd	2026-08-28 13:55	2026-08-28 13:55	2026-08-28 13:55	SPXW	SPXW260828P07715000	put	7715.0000	2026-08-28	9.7200	9.5000	9.8000	7712.6400	194410.00	192490.00	0.00	200	49	69159	1492	46.3532171581769	0.177183461740589	0.177183461740589	false	false	false	true	false
ff518e4f-c951-4f70-b981-d5d8374adafa	2026-08-28 13:56	2026-08-28 13:56	2026-08-28 13:56	SPXW	SPXW260831C07730000	call	7730.0000	2026-08-31	11.2000	11.0000	11.3000	7709.6000	221760.00	92960.00	128800.00	198	6	8285	687	12.0596797671033	0.067489496248487	0.067489496248487	false	false	false	true	false
2d6f0a46-c11c-4222-8548-1fb32aec67f1	2026-08-28 13:56	2026-08-28 13:56	2026-08-28 13:56	SPXW	SPXW260828P07715000	put	7715.0000	2026-08-28	11.2900	11.1000	11.6000	7709.3900	225770.00	0.00	223470.00	200	39	69712	1492	46.7238605898123	0.178792254643534	0.174404892761791	false	false	false	true	false
ded8e4e8-17ea-41b9-b39c-812af7c23f45	2026-08-28 13:57	2026-08-28 13:57	2026-08-28 13:57	SPXW	SPXW260828C07710000	call	7710.0000	2026-08-28	8.6600	8.4000	8.7000	7711.5600	173240.00	173240.00	0.00	200	44	27869	1438	19.3803894297636	0.16530062935652	0.167438556729329	false	false	false	true	false
14eaf250-fa63-4944-8fd3-7c50c8015f75	2026-08-28 13:59	2026-08-28 13:59	2026-08-28 13:59	SPXW	SPXW260828C07710000	call	7710.0000	2026-08-28	9.1000	9.0000	9.3000	7712.6800	193870.00	910.00	154740.00	213	34	28528	1438	19.8386648122392	0.166193700199359	0.164038536204531	false	false	false	true	false
cdb6a98d-7fd7-4587-97b2-815b5f6ddd11	2026-08-28 14:00	2026-08-28 13:59	2026-08-28 14:00	SPXW	SPXW260831P07700000	put	7700.0000	2026-08-31	14.9100	14.7000	15.3000	7713.3200	319130.00	0.00	319130.00	214	42	7546	8015	0.941484716157205	0.0792260727282529	0.0784785569102845	false	false	false	true	false