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:alert_rule = RepeatedHits×ticker = SPY×

iduuid	created_at ↓timestamp with time zone	start_timetimestamp with time zone	end_timetimestamp with time zone	tickertext	option_symboltext	option_typetext	strikenumeric	expirydate

d38eb995-d7d8-46b4-817e-3641c0d37699	2026-09-28 15:25	2026-09-28 15:25	2026-09-28 15:25	SPY	SPY260928C00768000	call	768.0000	2026-09-28	0.0800	0.0700	0.0900	766.1200	10216.00	10160.00	0.00	1277	6	698512	6674	104.661672160623	0.243648599688202	0.243648599688202	true	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	817157925289.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-28T19:30:45.639934Z"}	2026-09-28	2026-09-28 21:15	2026-09-28 21:15
8e5abe34-1a56-4fa4-a7d0-f220d436740d	2026-09-28 15:25	2026-09-28 15:25	2026-09-28 15:25	SPY	SPY261023P00770000	put	770.0000	2026-10-23	10.9200	10.9200	10.9600	766.0900	100464.00	0.00	100464.00	92	5	732	2017	0.36291522062469	0.124927505931678	0.124927505931678	false	false	false	true
78639a1d-eb6c-4c6c-9f9b-5a876fd08d63	2026-09-28 15:24	2026-09-28 15:24	2026-09-28 15:24	SPY	SPY261120C00746000	call	746.0000	2026-11-20	33.3600	33.2000	33.3600	765.9800	23352.00	23352.00	0.00	7	7	38	4	9.5	0.162254358849685	0.162254358849685	false	false	false	true
30de753a-8526-44b2-8a94-029bb8a234ca	2026-09-28 15:24	2026-09-28 15:24	2026-09-28 15:24	SPY	SPY260928C00765000	call	765.0000	2026-09-28	1.2000	1.2000	1.2100	765.9800	12000.00	0.00	12000.00	100	5	288803	2108	137.003320683112	0.232807022404872	0.232807022404872	false	false	false	true
ae2ae1f4-b0e9-44ce-8bc6-a86f6683968f	2026-09-28 15:24	2026-09-28 15:24	2026-09-28 15:24	SPY	SPY261016C00765000	call	765.0000	2026-10-16	10.1700	10.1300	10.1700	765.8975	29493.00	29493.00	0.00	29	6	2246	6967	0.322376919764605	0.131491017966204	0.131491017966204	false	false	false	true
edf1117b-7c54-4de2-95a1-81fba41d3911	2026-09-28 15:24	2026-09-28 15:24	2026-09-28 15:24	SPY	SPY261016P00760000	put	760.0000	2026-10-16	5.8800	5.8800	5.9000	765.9200	11760.00	0.00	11760.00	20	6	6249	22495	0.277795065570127	0.135041706717321	0.135041706717321	false	false	false	true
fd46e729-3133-496e-8fb5-1bbfcb4dc692	2026-09-28 15:24	2026-09-28 15:23	2026-09-28 15:23	SPY	SPY261002P00757000	put	757.0000	2026-10-02	1.6100	1.6000	1.6100	765.9300	14329.00	14329.00	0.00	89	7	2343	4376	0.535420475319927	0.154577987195108	0.154577987195108	false	false	false	true
1360d948-5df1-45a5-a47e-1de0b989532d	2026-09-28 15:23	2026-09-28 15:23	2026-09-28 15:23	SPY	SPY260928P00767000	put	767.0000	2026-09-28	1.2900	1.2900	1.3000	765.8800	21673.00	130.00	21543.00	168	5	570696	3308	172.519951632406	0.211453728839397	0.225391212632109	false	false	false	true
2f97426c-f4c9-4929-b25b-b830eeab6174	2026-09-28 15:22	2026-09-28 15:22	2026-09-28 15:22	SPY	SPY260928P00767000	put	767.0000	2026-09-28	1.1800	1.1700	1.1800	766.0431	18054.00	18054.00	0.00	153	5	570120	3308	172.345828295042	0.225116479824979	0.225116479824979	false	false	false	true
af98e0ff-ac39-42c7-8d9e-bff973aaa8c3	2026-09-28 15:22	2026-09-28 15:22	2026-09-28 15:22	SPY	SPY261016C00792000	call	792.0000	2026-10-16	0.9100	0.9000	0.9200	766.0100	14196.00	0.00	14105.00	156	5	1231	3115	0.395184590690209	0.11051028338324	0.11051028338324	false	false	false	true
bc1fd97f-2a17-4d33-9aff-59497a78b1d1	2026-09-28 15:21	2026-09-28 15:21	2026-09-28 15:21	SPY	SPY260928C00766000	call	766.0000	2026-09-28	0.5900	0.5800	0.5900	766.0100	11800.00	11800.00	0.00	200	9	346174	1320	262.25303030303	0.22425675252847	0.22425675252847	false	false	false	true
bec7e32e-76c3-418e-9e16-4fc85efe82de	2026-09-28 15:21	2026-09-28 15:21	2026-09-28 15:21	SPY	SPY260930C00765000	call	765.0000	2026-09-30	3.8800	3.8600	3.8800	765.9800	14744.00	14744.00	0.00	38	6	7226	4636	1.55867126833477	0.14481526961164	0.14481526961164	false	false	false	true
21fa8c62-ab6a-45ff-9384-c1110cbad294	2026-09-28 15:21	2026-09-28 15:21	2026-09-28 15:21	SPY	SPY261006C00765000	call	765.0000	2026-10-06	6.4400	6.3900	6.4400	765.8500	36064.00	36064.00	0.00	56	6	600	77	7.79220779220779	0.125259299035129	0.124894606245089	false	false	false	true
60ede8fc-aa92-4377-bccc-b49b51eff94a	2026-09-28 15:21	2026-09-28 15:21	2026-09-28 15:21	SPY	SPY260928C00767000	call	767.0000	2026-09-28	0.2000	0.1900	0.2000	765.8900	20120.00	20120.00	0.00	1006	5	584200	2600	224.692307692308	0.22689789509236	0.22689789509236	false	false	false	true
cf1e11e2-dfc9-42a5-9f5f-89d1bb319744	2026-09-28 15:21	2026-09-28 15:20	2026-09-28 15:20	SPY	SPY260928P00767000	put	767.0000	2026-09-28	1.2700	1.2700	1.2800	765.8900	12700.00	0.00	12700.00	100	6	568874	3308	171.969165659008	0.207506486494456	0.207506486494456	false	false	false	true
363563ef-0ac6-48c2-ab5c-14fadfbe46ed	2026-09-28 15:21	2026-09-28 15:20	2026-09-28 15:20	SPY	SPY260928P00766000	put	766.0000	2026-09-28	0.6300	0.6200	0.6300	765.8900	63062.00	63000.00	62.00	1001	14	559956	3229	173.414679467327	0.216807298109617	0.214013381905624	false	false	false	true
e02a43d0-f589-4eda-b47c-c19c2b113609	2026-09-28 15:20	2026-09-28 15:20	2026-09-28 15:20	SPY	SPY260928P00766000	put	766.0000	2026-09-28	0.6500	0.6400	0.6500	765.8800	21580.00	21580.00	0.00	332	5	558739	3229	173.037782595231	0.22311980706465	0.22311980706465	false	false	false	true
c3e9032c-814c-48d4-8894-8af4b9722e2f	2026-09-28 15:20	2026-09-28 15:20	2026-09-28 15:20	SPY	SPY260929P00766000	put	766.0000	2026-09-29	2.1700	2.1700	2.1800	765.9600	11068.00	218.00	10850.00	51	5	48635	3222	15.094661700807	0.137071540310475	0.13769679957	false	false	false	true
68c81bd4-6dc8-49ad-93ae-2b3d25230519	2026-09-28 15:20	2026-09-28 15:20	2026-09-28 15:20	SPY	SPY261006C00771000	call	771.0000	2026-10-06	3.4100	3.4100	3.4300	765.9600	13981.00	0.00	13981.00	41	7	252	544	0.463235294117647	0.116969231834943	0.116969231834943	true	false	false	true
cfba5d38-14fd-40a0-a9e0-c27e6ab33d8d	2026-09-28 15:20	2026-09-28 15:19	2026-09-28 15:19	SPY	SPY261007C00777000	call	777.0000	2026-10-07	1.7600	1.7600	1.7700	765.9100	12848.00	0.00	12848.00	73	7	230	148	1.55405405405405	0.112360421161136	0.112391722523885	true	false	false	true
e6d6b44d-69e6-4c06-9285-14977b21ef34	2026-09-28 15:19	2026-09-28 15:19	2026-09-28 15:19	SPY	SPY260929P00770000	put	770.0000	2026-09-29	4.6500	4.6400	4.6600	765.9850	107415.00	106950.00	465.00	231	12	13428	2248	5.97330960854093	0.133059629649237	0.133059629649237	true	false	false	true
0beea159-e016-4bb8-bdf6-8d0b46a54c0b	2026-09-28 15:19	2026-09-28 15:19	2026-09-28 15:19	SPY	SPY260928C00764000	call	764.0000	2026-09-28	2.0900	2.0800	2.0900	765.9800	17556.00	17556.00	0.00	84	5	90806	727	124.905089408528	0.256687423669938	0.256687423669938	false	false	false	true
54b0db9f-74d3-4b22-93f9-6f341a0b8e43	2026-09-28 15:19	2026-09-28 15:18	2026-09-28 15:18	SPY	SPY260929P00764000	put	764.0000	2026-09-29	1.3700	1.3600	1.3700	766.0400	41100.00	41100.00	0.00	300	9	40871	2072	19.7253861003861	0.142499853428652	0.142499853428652	true	false	false	true
23e8ac45-e95b-4748-9e2d-0e5bd637dd1d	2026-09-28 15:19	2026-09-28 15:18	2026-09-28 15:18	SPY	SPY260928C00766000	call	766.0000	2026-09-28	0.6100	0.6100	0.6200	766.0400	36600.00	0.00	36600.00	600	13	340705	1320	258.109848484848	0.217923349602649	0.217923349602649	false	false	false	true
16c33838-e8a4-47d9-99e3-787c21ab0e3c	2026-09-28 15:19	2026-09-28 15:18	2026-09-28 15:18	SPY	SPY260928C00767000	call	767.0000	2026-09-28	0.2400	0.2300	0.2400	766.0300	14808.00	14808.00	0.00	617	16	580591	2600	223.304230769231	0.223625413179686	0.223625413179686	false	false	false	true
b9020374-a827-48b5-b7bb-f9dfc44b83c5	2026-09-28 15:18	2026-09-28 15:18	2026-09-28 15:18	SPY	SPY260928C00766000	call	766.0000	2026-09-28	0.6100	0.6000	0.6100	766.0300	12505.00	12505.00	0.00	205	9	339988	1320	257.566666666667	0.221423672854032	0.219545703314178	false	false	false	true
38a00199-ba64-4dca-b92c-55c067757695	2026-09-28 15:18	2026-09-28 15:18	2026-09-28 15:18	SPY	SPY260928C00764000	call	764.0000	2026-09-28	2.1000	2.0900	2.1000	766.0000	10710.00	10710.00	0.00	51	7	90659	727	124.702888583219	0.249462388004143	0.249462388004143	false	false	false	true
0df27004-f18e-4f68-abdb-d91eac018ff2	2026-09-28 15:18	2026-09-28 15:18	2026-09-28 15:18	SPY	SPY260928P00768000	put	768.0000	2026-09-28	2.0900	2.0900	2.1000	766.0000	28215.00	0.00	28215.00	135	10	273420	7535	36.2866622428666	0.244504178779983	0.244504178779983	true	false	false	true
bf39768a-53ed-42f5-859d-b494cb392dcb	2026-09-28 15:18	2026-09-28 15:18	2026-09-28 15:18	SPY	SPY260928C00765000	call	765.0000	2026-09-28	1.2600	1.2600	1.2700	766.0300	16884.00	0.00	16884.00	134	5	285553	2108	135.461574952562	0.225413592267246	0.225413592267246	false	false	false	true
97c18d37-ea10-4635-baa6-52739f766dfa	2026-09-28 15:18	2026-09-28 15:18	2026-09-28 15:18	SPY	SPY261002C00780000	call	780.0000	2026-10-02	0.5200	0.5100	0.5200	765.9800	20800.00	20800.00	0.00	400	10	13352	11405	1.17071459886015	0.132935370346858	0.132935370346858	false	false	false	true
8f1c84d9-afd3-4fef-8207-368311016b36	2026-09-28 15:18	2026-09-28 15:18	2026-09-28 15:18	SPY	SPY260928C00766000	call	766.0000	2026-09-28	0.5900	0.5800	0.5900	765.9900	12389.00	12331.00	58.00	210	5	339616	1320	257.284848484849	0.219155532128441	0.215508254928326	false	false	false	true
d235324a-17b4-46bb-b36f-ef275bfc7c3c	2026-09-28 15:18	2026-09-28 15:18	2026-09-28 15:18	SPY	SPY260928C00766000	call	766.0000	2026-09-28	0.5900	0.5800	0.6000	765.9900	36167.00	59.00	36108.00	613	7	339406	1320	257.125757575758	0.209831305589765	0.219155532128441	true	false	false	true
930fd1b1-85eb-4d4d-8a86-f48c2db9e2b5	2026-09-28 15:18	2026-09-28 15:18	2026-09-28 15:18	SPY	SPY260928P00766000	put	766.0000	2026-09-28	0.5900	0.5900	0.6000	765.9900	11800.00	0.00	11800.00	200	6	555039	3229	171.891917002168	0.216015660574508	0.216015660574508	false	false	false	true
c34c9a47-d1da-4be0-aa9e-3975f52714fd	2026-09-28 15:18	2026-09-28 15:18	2026-09-28 15:18	SPY	SPY260928C00765000	call	765.0000	2026-09-28	1.2800	1.2800	1.2900	766.0300	19968.00	0.00	19968.00	156	5	285010	2108	135.203984819734	0.226529437301821	0.23343466067128	false	false	false	true
99c2aa7e-270f-4c64-90fd-42bd428f0f3d	2026-09-28 15:18	2026-09-28 15:18	2026-09-28 15:18	SPY	SPY260928P00767000	put	767.0000	2026-09-28	1.2000	1.2000	1.2100	766.0300	13560.00	0.00	13560.00	113	9	566897	3308	171.371523579202	0.218599294416277	0.218599294416277	false	false	false	true
9859d838-e5d9-4d94-a432-8b8d16bd4153	2026-09-28 15:18	2026-09-28 15:18	2026-09-28 15:18	SPY	SPY260928C00765000	call	765.0000	2026-09-28	1.2800	1.2700	1.2800	766.0300	38655.00	38528.00	127.00	302	24	284740	2108	135.075901328273	0.23334064578685	0.228782594137532	false	false	false	true
c62c8690-c235-480c-b92f-e939d7e9ab5c	2026-09-28 15:18	2026-09-28 15:18	2026-09-28 15:18	SPY	SPY260928P00766000	put	766.0000	2026-09-28	0.5800	0.5800	0.5900	766.0050	29116.00	0.00	29116.00	502	5	554490	3229	171.72189532363	0.214278862557072	0.214278862557072	false	false	false	true
7e07e644-3f7e-43ff-ae48-70e02a6b6ed1	2026-09-28 15:18	2026-09-28 15:18	2026-09-28 15:18	SPY	SPY261016P00750000	put	750.0000	2026-10-16	3.5800	3.5800	3.5900	766.0300	35800.00	0.00	35800.00	100	5	6079	66561	0.0913297576659005	0.14893303173006	0.14893303173006	true	false	false	true
51a3ac89-8cf1-4dd4-97d3-96b78e375885	2026-09-28 15:18	2026-09-28 15:18	2026-09-28 15:18	SPY	SPY260928C00766000	call	766.0000	2026-09-28	0.6100	0.6000	0.6200	766.0200	10736.00	10370.00	366.00	176	7	337220	1320	255.469696969697	0.215907937897977	0.219644264897385	false	false	false	true
61434cdb-c8c6-4109-8a1d-98d0f10c470b	2026-09-28 15:18	2026-09-28 15:18	2026-09-28 15:18	SPY	SPY260928C00766000	call	766.0000	2026-09-28	0.6000	0.5900	0.6100	766.0050	13980.00	13500.00	480.00	233	7	336990	1320	255.295454545455	0.219495822158783	0.21857622720014	false	false	false	true
18c2ddba-170c-4df6-bfa0-d934e05a47c6	2026-09-28 15:18	2026-09-28 15:18	2026-09-28 15:18	SPY	SPY261001C00770000	call	770.0000	2026-10-01	2.1500	2.1400	2.1600	766.0050	21500.00	0.00	0.00	100	5	5502	1022	5.38356164383562	0.1341225319223	0.1341225319223	false	false	false	true
87ba65ad-b463-4e9f-9667-9ef64e875094	2026-09-28 15:18	2026-09-28 15:17	2026-09-28 15:17	SPY	SPY260928C00766000	call	766.0000	2026-09-28	0.5800	0.5800	0.5900	765.9450	22852.00	0.00	22852.00	394	13	336015	1320	254.556818181818	0.22154601176806	0.22154601176806	false	false	false	true
94482a11-4e58-404e-bc0d-6d673000ff8f	2026-09-28 15:17	2026-09-28 15:17	2026-09-28 15:17	SPY	SPY261002C00772000	call	772.0000	2026-10-02	2.1400	2.1400	2.1500	765.9500	32100.00	0.00	32100.00	150	5	18634	14788	1.26007573708412	0.13755939596888	0.137668149875111	false	false	false	true
5b658ee6-1ad3-4d77-a7a4-962bcfa1b673	2026-09-28 15:17	2026-09-28 15:17	2026-09-28 15:17	SPY	SPY260929C00765000	call	765.0000	2026-09-29	2.8300	2.8200	2.8300	765.9700	14150.00	14150.00	0.00	50	6	31003	1145	27.0768558951965	0.141624625528099	0.141624625528099	false	false	false	true
b0392a61-1467-400a-baf2-8967ee003b35	2026-09-28 15:17	2026-09-28 15:17	2026-09-28 15:17	SPY	SPY261030C00774000	call	774.0000	2026-10-30	9.2100	9.2100	9.2400	765.9100	12894.00	0.00	12894.00	14	7	575	821	0.700365408038977	0.128283390862494	0.128283390862494	true	false	false	true
8e2e9db5-dcd0-4422-a22b-510074cdd706	2026-09-28 15:17	2026-09-28 15:17	2026-09-28 15:17	SPY	SPY261030C00775000	call	775.0000	2026-10-30	8.7200	8.7200	8.7500	765.9100	35752.00	0.00	35752.00	41	9	846	5536	0.152817919075144	0.127417027175139	0.127417027175139	false	false	false	true
394b586b-0b2a-4240-8669-5a9b2215aa9e	2026-09-28 15:17	2026-09-28 15:17	2026-09-28 15:17	SPY	SPY261030C00773000	call	773.0000	2026-10-30	9.7200	9.7200	9.7500	765.9100	30132.00	0.00	30132.00	31	10	545	469	1.16204690831557	0.129215294647786	0.129215294647786	true	false	false	true
941a9669-c7e3-49a6-8924-4010362a6006	2026-09-28 15:17	2026-09-28 15:17	2026-09-28 15:17	SPY	SPY261023C00770000	call	770.0000	2026-10-23	9.0800	9.0600	9.1000	765.7900	12712.00	8172.00	2724.00	14	6	903	2616	0.345183486238532	0.125992925672081	0.125992925672081	true	false	false	true
0c91760d-883b-4b8c-8717-a3d4141980c5	2026-09-28 15:17	2026-09-28 15:17	2026-09-28 15:17	SPY	SPY261009P00766000	put	766.0000	2026-10-09	6.2700	6.2700	6.2800	765.7900	13167.00	0.00	13167.00	21	5	1178	1068	1.10299625468165	0.124972507797618	0.124972507797618	false	false	false	true
f64135cd-4e8f-4593-8ca9-50a3a6c89f9b	2026-09-28 15:17	2026-09-28 15:17	2026-09-28 15:17	SPY	SPY260928C00765000	call	765.0000	2026-09-28	1.1700	1.1600	1.1700	765.8700	11700.00	11700.00	0.00	100	14	283134	2108	134.314041745731	0.233190205395351	0.233190205395351	false	false	false	true