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.

566,287 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts566,287 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:option_symbol = SPXW260930C07700000×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

31016bdf-b7eb-4e39-bf2b-6d2e91ce9d42	2026-08-27 11:14	2026-08-27 11:14	2026-08-27 11:14	SPXW	SPXW260930C07700000	call	7700.0000	2026-09-30	139.0000	138.9000	139.4000	7724.7100	347490.00	0.00	347490.00	25	6	93	2067	0.0449927431059507	0.118544077984822	0.118544077984822	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	—	—	—	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-27T15:23:19.203737Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
8dc94e77-88d5-431e-a940-92f93c1b9503	2026-09-16 12:11	2026-09-16 12:11	2026-09-16 12:11	SPXW	SPXW260930C07700000	call	7700.0000	2026-09-30	40.5000	40.1000	40.6000	7614.4900	405000.00	182250.00	222750.00	100	11	156	2819	0.0553387726144023	0.119532754837184	0.119532754837184	false	false	false	true
56bad94e-5243-4930-aeff-df476ad83bbd	2026-09-23 12:20	2026-09-23 12:19	2026-09-23 12:19	SPXW	SPXW260930C07700000	call	7700.0000	2026-09-30	55.3200	55.1000	55.4000	7713.2700	110650.00	110650.00	0.00	20	7	492	5332	0.0922730682670668	0.105944132211081	0.105944132211081	false	false	false	true
d607607c-da83-4f13-a769-aeb3cd420d29	2026-09-23 12:29	2026-09-23 12:28	2026-09-23 12:28	SPXW	SPXW260930C07700000	call	7700.0000	2026-09-30	55.5000	55.4000	55.5000	7713.3200	111000.00	111000.00	0.00	20	14	512	5332	0.0960240060015004	0.106352893637267	0.106352893637267	false	false	false	true
eaf311a4-6cd5-4452-8cc0-b4a7f9c86d61	2026-09-23 13:42	2026-09-23 13:42	2026-09-23 13:42	SPXW	SPXW260930C07700000	call	7700.0000	2026-09-30	54.0000	53.9000	54.0000	7685.0000	81000.00	81000.00	0.00	15	10	730	5332	0.136909227306827	0.111419734646425	0.111419734646425	false	false	false	true
2eded756-fa09-473b-97ce-a2b0f8cb7d18	2026-09-24 09:58	2026-09-24 09:58	2026-09-24 09:58	SPXW	SPXW260930C07700000	call	7700.0000	2026-09-30	37.3000	37.3000	37.4000	7681.8100	37300.00	0.00	37300.00	10	5	125	5436	0.0229948491537896	0.110757398975242	0.110757398975242	false	false	false	true
8955efef-eb27-4f87-9258-706d0cbbf4e9	2026-09-24 11:17	2026-09-24 11:17	2026-09-24 11:17	SPXW	SPXW260930C07700000	call	7700.0000	2026-09-30	32.4000	32.3000	32.6000	7669.6600	32400.00	0.00	32400.00	10	6	390	5436	0.0717439293598234	0.111698859607005	0.111698859607005	false	false	false	true
96ff583a-21ee-43e0-985e-11a93aecbb18	2026-09-24 11:54	2026-09-24 11:54	2026-09-24 11:54	SPXW	SPXW260930C07700000	call	7700.0000	2026-09-30	32.7000	32.6000	32.8000	7672.1700	32700.00	0.00	0.00	10	5	505	5436	0.0928991905813098	0.109761406575101	0.109761406575101	false	false	false	true
6f711932-34f2-47a6-9e57-1695d8beb4f4	2026-09-24 12:04	2026-09-24 12:04	2026-09-24 12:04	SPXW	SPXW260930C07700000	call	7700.0000	2026-09-30	32.2000	32.1000	32.3000	7670.0100	32200.00	0.00	0.00	10	5	527	5436	0.0969462840323767	0.110799463573634	0.110799463573634	false	false	false	true
db225ace-f503-4e8f-9d09-c64b5436cc2e	2026-09-24 12:46	2026-09-24 12:46	2026-09-24 12:46	SPXW	SPXW260930C07700000	call	7700.0000	2026-09-30	49.8000	49.7000	49.8000	7704.5900	224100.00	224100.00	0.00	45	9	1018	5436	0.187270051508462	0.113793606631644	0.113793606631644	false	false	false	true
4750c918-9506-4c73-87fd-063fa8d6037e	2026-09-28 09:58	2026-09-28 09:58	2026-09-28 09:58	SPXW	SPXW260930C07700000	call	7700.0000	2026-09-30	38.0000	37.8000	38.1000	7690.0000	38000.00	38000.00	0.00	10	6	135	5269	0.0256215600683242	0.140122235447154	0.140122235447154	false	false	false	true
73cc0798-e510-46da-ac55-92269f21b6f2	2026-09-28 11:08	2026-09-28 11:08	2026-09-28 11:08	SPXW	SPXW260930C07700000	call	7700.0000	2026-09-30	24.8000	24.6000	24.9000	7682.4300	54560.00	54560.00	0.00	22	6	768	5269	0.145758208388689	0.141393950572014	0.141393950572014	true	false	false	true
b0589392-b67c-4c5e-8277-8063841f3950	2026-09-28 11:10	2026-09-28 11:10	2026-09-28 11:10	SPXW	SPXW260930C07700000	call	7700.0000	2026-09-30	26.3000	26.2000	26.5000	7686.2400	120980.00	0.00	120980.00	46	7	827	5269	0.156955779085215	0.140723554960776	0.140723554960776	true	false	false	true
1419b90b-68f3-4329-bc75-6ecc0c5a8731	2026-09-28 11:17	2026-09-28 11:16	2026-09-28 11:16	SPXW	SPXW260930C07700000	call	7700.0000	2026-09-30	23.5000	23.4000	23.7000	7655.0000	16450.00	0.00	16450.00	7	5	863	5269	0.163788195103435	0.142424071616447	0.142424071616447	false	false	false	true
d0192f9d-a86c-42ca-a15d-fc74800ca139	2026-09-28 12:08	2026-09-28 12:07	2026-09-28 12:07	SPXW	SPXW260930C07700000	call	7700.0000	2026-09-30	25.2000	25.1000	25.3000	7684.4900	20160.00	0.00	0.00	8	5	1042	5269	0.197760485860695	0.139232648669953	0.139232648669953	false	false	false	true
60011ce4-fc0b-442b-a6a4-343a90f15746	2026-09-28 12:22	2026-09-28 12:22	2026-09-28 12:22	SPXW	SPXW260930C07700000	call	7700.0000	2026-09-30	34.1000	33.8000	34.2000	7704.3500	109120.00	109120.00	0.00	32	5	1119	5269	0.212374264566331	0.136213832896149	0.136213832896149	false	false	false	true
a25c0b5f-b4cb-43f8-9ec0-7da4f45dfa3d	2026-09-28 14:51	2026-09-28 14:51	2026-09-28 14:51	SPXW	SPXW260930C07700000	call	7700.0000	2026-09-30	30.6800	30.6000	30.9000	7698.4100	92050.00	0.00	92050.00	30	6	2201	5269	0.417726323780604	0.134788739690815	0.134788739690815	false	false	false	true
2fd6b8d2-029e-4bd3-af43-c6a9d3f8225c	2026-09-29 09:46	2026-09-29 09:46	2026-09-29 09:46	SPXW	SPXW260930C07700000	call	7700.0000	2026-09-30	18.0000	18.0000	18.1000	7681.8200	237600.00	0.00	237600.00	132	16	573	5282	0.108481635744036	0.160292494330217	0.160292494330217	false	false	false	true
1ad6d719-b449-4733-8668-dbdcdcc458af	2026-09-29 10:10	2026-09-29 10:10	2026-09-29 10:10	SPXW	SPXW260930C07700000	call	7700.0000	2026-09-30	16.4000	16.2000	16.4000	7660.0000	16400.00	16400.00	0.00	10	5	1079	5282	0.204278682317304	0.1544434292632	0.1544434292632	false	false	false	true
37803097-53e4-47a6-847e-d4f006cf3891	2026-09-29 10:11	2026-09-29 10:11	2026-09-29 10:11	SPXW	SPXW260930C07700000	call	7700.0000	2026-09-30	15.8000	15.7000	16.0000	7660.0000	15800.00	0.00	15800.00	10	6	1104	5282	0.209011737978039	0.150915980367771	0.150915980367771	false	false	false	true
513ecb3c-a54b-4ae8-b627-8bbd1b7f9795	2026-09-29 10:31	2026-09-29 10:31	2026-09-29 10:31	SPXW	SPXW260930C07700000	call	7700.0000	2026-09-30	17.8000	17.7000	17.9000	7685.8300	17800.00	16020.00	0.00	10	5	1345	5282	0.25463839454752	0.148601632513475	0.148601632513475	false	false	false	true
35a13153-ec02-4215-85db-e070cb9e8c67	2026-09-29 11:12	2026-09-29 11:12	2026-09-29 11:12	SPXW	SPXW260930C07700000	call	7700.0000	2026-09-30	12.0000	11.9000	12.1000	7645.0000	20400.00	0.00	19200.00	17	5	1803	5282	0.341347974252177	0.150587812354053	0.150587812354053	false	false	false	true
779bf064-b24e-439d-8e08-4d3e599b677a	2026-09-29 11:15	2026-09-29 11:14	2026-09-29 11:14	SPXW	SPXW260930C07700000	call	7700.0000	2026-09-30	12.8000	12.6000	12.8000	7671.0700	12800.00	12800.00	0.00	10	5	1867	5282	0.353464596743658	0.151437195591827	0.151437195591827	false	false	false	true
2e6a9899-097e-4918-924b-cc50e6811a28	2026-09-29 11:44	2026-09-29 11:44	2026-09-29 11:44	SPXW	SPXW260930C07700000	call	7700.0000	2026-09-30	11.8000	11.7000	11.8000	7667.6600	11800.00	11800.00	0.00	10	5	4249	5282	0.804430140098448	0.151937529229121	0.151937529229121	false	false	false	true
acc8ee33-a17f-469d-a071-2da081f0bc57	2026-09-29 12:42	2026-09-29 12:41	2026-09-29 12:41	SPXW	SPXW260930C07700000	call	7700.0000	2026-09-30	9.0000	9.0000	9.1000	7659.4000	13500.00	0.00	13500.00	15	11	4952	5282	0.937523665278304	0.148253238956142	0.148253238956142	false	false	false	true
0e4b0955-78a7-433e-a7b6-04cd498d349f	2026-09-29 13:10	2026-09-29 13:10	2026-09-29 13:10	SPXW	SPXW260930C07700000	call	7700.0000	2026-09-30	8.1000	8.0000	8.2000	7655.0800	29160.00	4050.00	25110.00	36	5	5471	5282	1.03578190079515	0.149449488328912	0.149449488328912	false	false	false	true
dd67967b-678b-42a1-bf6f-63b0400f54cc	2026-09-29 14:04	2026-09-29 14:04	2026-09-29 14:04	SPXW	SPXW260930C07700000	call	7700.0000	2026-09-30	10.0000	9.9000	10.0000	7665.1800	10000.00	10000.00	0.00	10	6	6250	5282	1.18326391518364	0.144144190251964	0.144144190251964	false	false	false	true
a20bc817-9f6e-4396-bec4-3ad94417c20e	2026-09-29 14:28	2026-09-29 14:28	2026-09-29 14:28	SPXW	SPXW260930C07700000	call	7700.0000	2026-09-30	10.6000	10.5000	10.7000	7650.0000	33920.00	27560.00	5300.00	32	7	8609	5282	1.62987504733056	0.136245664555831	0.136245664555831	false	false	false	true
21bbdd62-ffdd-4491-afbb-c293eb149cef	2026-09-29 14:30	2026-09-29 14:30	2026-09-29 14:30	SPXW	SPXW260930C07700000	call	7700.0000	2026-09-30	10.8800	10.7000	11.3000	7650.0000	11970.00	10900.00	1070.00	11	7	8672	5282	1.64180234759561	0.141064682034384	0.140349075748287	false	false	false	true
2fc2cbc9-f174-48f2-8310-6ac7a7213129	2026-09-29 14:41	2026-09-29 14:41	2026-09-29 14:41	SPXW	SPXW260930C07700000	call	7700.0000	2026-09-30	14.0000	13.8000	14.1000	7680.7400	138600.00	2800.00	135800.00	99	8	8999	5282	1.70371071563802	0.136935931205191	0.136935931205191	false	false	false	true
8ae7fa4a-f3a9-430f-80b9-9a02cab03526	2026-09-29 14:42	2026-09-29 14:42	2026-09-29 14:42	SPXW	SPXW260930C07700000	call	7700.0000	2026-09-30	13.2000	13.2000	13.4000	7679.4900	33000.00	0.00	33000.00	25	6	9073	5282	1.71772056039379	0.134662584542177	0.134662584542177	false	false	false	true
02de30ad-15f5-4099-b28c-ea940d080171	2026-09-29 15:09	2026-09-29 15:09	2026-09-29 15:09	SPXW	SPXW260930C07700000	call	7700.0000	2026-09-30	12.1000	12.0000	12.1000	7677.6200	12100.00	12100.00	0.00	10	5	9615	5282	1.82033320711852	0.131696139182239	0.131696139182239	false	false	false	true
9b92bbe4-8760-4f24-9a00-dacce6bdad92	2026-09-29 15:35	2026-09-29 15:35	2026-09-29 15:35	SPXW	SPXW260930C07700000	call	7700.0000	2026-09-30	10.9000	10.7000	10.9000	7674.5100	10900.00	10900.00	0.00	10	5	10092	5282	1.91063990912533	0.13055073759641	0.13055073759641	false	false	false	true
be319355-10e7-41c1-b727-445a2e93d381	2026-09-29 15:37	2026-09-29 15:37	2026-09-29 15:37	SPXW	SPXW260930C07700000	call	7700.0000	2026-09-30	11.3700	11.0000	11.2000	7655.0000	3411000.00	0.00	0.00	3000	22	13157	5282	2.49091253313139	0.13164581078862	0.13164581078862	false	false	false	true
2527b96b-c393-4db5-9892-456fcc7e87b8	2026-09-29 15:44	2026-09-29 15:44	2026-09-29 15:44	SPXW	SPXW260930C07700000	call	7700.0000	2026-09-30	9.5000	9.4000	9.5000	7670.4000	48450.00	48450.00	0.00	51	6	13951	5282	2.64123438091632	0.129545479434305	0.129545479434305	false	false	false	true
516c7a09-8c45-4a94-8582-a8c0f19881e6	2026-09-29 16:08	2026-09-29 16:08	2026-09-29 16:08	SPXW	SPXW260930C07700000	call	7700.0000	2026-09-30	10.3000	10.3000	10.5000	7650.0000	36050.00	0.00	36050.00	35	5	15692	5282	2.97084437712987	0.134366006298144	0.134366006298144	false	false	false	true