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.

658,639 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts658,639 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:alert_rule = RepeatedHits×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	expiry

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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
d29f0a31-f6b0-4ee0-903e-517e65d71754	2026-09-30 09:30	2026-09-30 09:30	2026-09-30 09:30	SPXW	SPXW260930C07700000	call	7700.0000	2026-09-30	12.0000	11.9000	12.1000	7693.6000	10800.00	3600.00	7200.00	9	5	186	10804	0.0172158459829693	0.178033939499825	0.178033939499825	false	false	false
587aa128-d364-4b8d-80bc-7b5dd1cd6a87	2026-09-30 09:30	2026-09-30 09:30	2026-09-30 09:30	SPXW	SPXW260930C07700000	call	7700.0000	2026-09-30	11.9000	11.7000	11.9000	7691.2600	15470.00	15470.00	0.00	13	5	252	10804	0.0233246945575713	0.188964561096629	0.188964561096629	false	false	false
3c965e58-451b-43cb-8b1f-1f26338c222e	2026-09-30 09:31	2026-09-30 09:31	2026-09-30 09:31	SPXW	SPXW260930C07700000	call	7700.0000	2026-09-30	11.9000	11.9000	12.1000	7693.9700	11900.00	0.00	11900.00	10	6	529	10804	0.0489633469085524	0.175019279315943	0.175019279315943	false	false	false
aed5dea4-fda6-473a-a00c-152fa7d7793d	2026-09-30 09:31	2026-09-30 09:31	2026-09-30 09:31	SPXW	SPXW260930C07700000	call	7700.0000	2026-09-30	11.7000	11.6000	11.7000	7693.6300	11700.00	11700.00	0.00	10	7	661	10804	0.0611810440577564	0.174456089069094	0.174456089069094	false	false	false
3ead029a-520d-4910-a5d5-2db51c3d76c7	2026-09-30 09:31	2026-09-30 09:31	2026-09-30 09:31	SPXW	SPXW260930C07700000	call	7700.0000	2026-09-30	11.5000	11.3000	11.5000	7692.3600	11500.00	11500.00	0.00	10	5	689	10804	0.0637726767863754	0.178668014975579	0.178668014975579	false	false	false
9dbd8230-1f9e-4e8a-8ee1-e42b4c9201f5	2026-09-30 09:31	2026-09-30 09:31	2026-09-30 09:31	SPXW	SPXW260930C07700000	call	7700.0000	2026-09-30	13.6000	13.4000	13.6000	7697.1100	16320.00	16320.00	0.00	12	5	985	10804	0.091169937060348	0.178391568115857	0.178391568115857	false	false	false
7c7458f9-c5b5-4088-86df-34602711079c	2026-09-30 09:31	2026-09-30 09:31	2026-09-30 09:31	SPXW	SPXW260930C07700000	call	7700.0000	2026-09-30	13.6000	13.4000	13.6000	7697.3300	32640.00	32640.00	0.00	24	5	1051	10804	0.09727878563495	0.177159740277725	0.177159740277725	true	false	false
d410a1cc-06e3-4870-84b7-36932d957f2c	2026-09-30 09:31	2026-09-30 09:31	2026-09-30 09:31	SPXW	SPXW260930C07700000	call	7700.0000	2026-09-30	14.9900	14.9000	15.1000	7698.5700	17990.00	15000.00	1490.00	12	7	1216	10804	0.112550907071455	0.186817253402972	0.185618582263812	false	false	false
3410bc68-8fae-4e71-b775-ce0dafb345bb	2026-09-30 09:32	2026-09-30 09:31	2026-09-30 09:31	SPXW	SPXW260930C07700000	call	7700.0000	2026-09-30	15.1000	15.0000	15.2000	7699.1500	39260.00	0.00	37750.00	26	6	1379	10804	0.127637911884487	0.18462231773003	0.18462231773003	false	false	false
e17cb533-0fb0-42a3-a148-f05804579462	2026-09-30 09:32	2026-09-30 09:32	2026-09-30 09:32	SPXW	SPXW260930C07700000	call	7700.0000	2026-09-30	15.5100	15.4000	15.7000	7699.5900	24820.00	24820.00	0.00	16	7	1424	10804	0.131803035912625	0.186807798928256	0.189204333502809	false	false	false
02347949-7fd5-49c9-984d-de11123969f7	2026-09-30 09:32	2026-09-30 09:32	2026-09-30 09:32	SPXW	SPXW260930C07700000	call	7700.0000	2026-09-30	15.0000	15.0000	15.1000	7700.3300	15000.00	0.00	15000.00	10	9	1617	10804	0.149666790077749	0.176398552704647	0.176398552704647	false	false	false
52f979ab-31c1-49a6-beeb-9556f61c9f7f	2026-09-30 09:32	2026-09-30 09:32	2026-09-30 09:32	SPXW	SPXW260930C07700000	call	7700.0000	2026-09-30	15.2100	15.2000	15.4000	7699.3300	28890.00	1530.00	27360.00	19	5	1714	10804	0.158644946316179	0.184816256594451	0.184816256594451	false	false	false
9cc1273e-9bf0-4e4f-a403-61bb1bca5620	2026-09-30 09:32	2026-09-30 09:32	2026-09-30 09:32	SPXW	SPXW260930C07700000	call	7700.0000	2026-09-30	15.6000	15.4000	15.7000	7700.9800	62400.00	28080.00	34320.00	40	9	1853	10804	0.171510551647538	0.179661055186412	0.179661055186412	false	false	false
83b92c47-1838-4d6d-b667-8a6dced3d1e1	2026-09-30 09:32	2026-09-30 09:32	2026-09-30 09:32	SPXW	SPXW260930C07700000	call	7700.0000	2026-09-30	14.7000	14.5000	14.7000	7699.0200	16170.00	16170.00	0.00	11	7	2047	10804	0.189466864124398	0.180747808365787	0.180747808365787	false	false	false
0c24da17-2632-4bdc-a2d5-77bb04df5e1a	2026-09-30 09:32	2026-09-30 09:32	2026-09-30 09:32	SPXW	SPXW260930C07700000	call	7700.0000	2026-09-30	14.0000	13.8000	14.1000	7698.3200	120400.00	1400.00	119000.00	86	21	2173	10804	0.201129211403184	0.176480954402753	0.176480954402753	false	false	false
8379e5a8-5eb3-409a-99af-e0c6d02588f7	2026-09-30 09:32	2026-09-30 09:32	2026-09-30 09:32	SPXW	SPXW260930C07700000	call	7700.0000	2026-09-30	13.3000	13.1000	13.4000	7696.8600	19950.00	13300.00	0.00	15	5	2199	10804	0.20353572750833	0.176456099435585	0.176456099435585	false	false	false