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.

609,118 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts609,118 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

c8d43bb1-ca22-4084-b12a-d56f0cdbd3a7	2026-09-30 15:11	2026-09-30 15:11	2026-09-30 15:11	SPY	SPY260930P00766000	put	766.0000	2026-09-30	0.5000	0.4900	0.5000	766.6200	10000.00	10000.00	0.00	200	5	522241	3414	152.970415934388	0.261640019175412	0.261640019175412	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	811183218780.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-30T19:16:05.592005Z"}	2026-09-30	2026-09-30 21:15	2026-09-30 21:15
2e32d11e-dee3-4d62-bda4-7e3eaeb1525c	2026-09-30 15:11	2026-09-30 15:10	2026-09-30 15:10	SPY	SPY260930P00769000	put	769.0000	2026-09-30	2.5100	2.5100	2.5200	766.6100	31375.00	0.00	31375.00	125	6	217680	3350	64.9791044776119	0.2759733991327	0.2759733991327	false	false	false	true
7d00ec86-acb9-4f27-8ba3-9cea5b2a4ac3	2026-09-30 15:11	2026-09-30 15:10	2026-09-30 15:10	SPY	SPY261001P00766000	put	766.0000	2026-10-01	1.9600	1.9500	1.9600	766.6200	39200.00	39200.00	0.00	200	6	56781	1063	53.4158043273754	0.143441735724815	0.143441735724815	false	false	false	true
5a132aa9-9886-4097-8168-404546c53263	2026-09-30 15:10	2026-09-30 15:10	2026-09-30 15:10	SPY	SPY261001C00763000	call	763.0000	2026-10-01	4.6400	4.6400	4.6700	766.5850	18570.00	4650.00	13920.00	40	5	3959	1031	3.83996120271581	0.148184726601483	0.148184726601483	false	false	false	true
bea630a6-5db4-4263-95a9-25d8b6869883	2026-09-30 15:10	2026-09-30 15:10	2026-09-30 15:10	SPY	SPY261120P00765000	put	765.0000	2026-11-20	13.3000	13.2900	13.3300	766.7400	509390.00	63840.00	445550.00	383	6	10914	13010	0.838893159108378	0.142358417979314	0.142358417979314	false	false	false	true
3691818d-c145-4739-ae20-17ef99885915	2026-09-30 15:10	2026-09-30 15:09	2026-09-30 15:09	SPY	SPY260930C00760000	call	760.0000	2026-09-30	6.7800	6.7700	6.7800	766.7200	230520.00	230520.00	0.00	340	5	7470	4741	1.57561695844758	0.507406376673953	0.507406376673953	false	false	false	true
e2b2a9fc-a40d-43b2-8ac0-c659de1a5a57	2026-09-30 15:09	2026-09-30 15:08	2026-09-30 15:08	SPY	SPY261130P00701000	put	701.0000	2026-11-30	3.6100	3.6100	3.6400	766.7500	340062.00	0.00	340062.00	942	15	952	56	17	0.20243564610593	0.20243564610593	false	false	false	true
1c71af6a-23e3-4708-80a3-c27b2ee088a6	2026-09-30 15:09	2026-09-30 15:08	2026-09-30 15:08	SPY	SPY261130P00700000	put	700.0000	2026-11-30	3.5500	3.5500	3.5700	766.7500	170400.00	0.00	170400.00	480	14	1247	5370	0.232216014897579	0.20356957005894	0.20356957005894	false	false	false	true
f43890d9-5c8a-4ed5-a549-ce437e065ceb	2026-09-30 15:08	2026-09-30 15:08	2026-09-30 15:08	SPY	SPY261001P00766000	put	766.0000	2026-10-01	1.8800	1.8700	1.8800	766.8050	17672.00	17672.00	0.00	94	7	56282	1063	52.9463781749765	0.143570212352887	0.143570212352887	false	false	false	true
923fc5de-74fd-43fe-95ec-69dedc7000d4	2026-09-30 15:08	2026-09-30 15:08	2026-09-30 15:08	SPY	SPY261009C00769000	call	769.0000	2026-10-09	5.1800	5.1500	5.1800	766.7800	68376.00	68376.00	0.00	132	6	3536	1798	1.96662958843159	0.122267269806616	0.122267269806616	false	false	false	true
0afa6f2a-6cd7-42d8-9c91-1ac2b7eecb06	2026-09-30 15:08	2026-09-30 15:08	2026-09-30 15:08	SPY	SPY260930C00767000	call	767.0000	2026-09-30	0.6500	0.6400	0.6600	766.8050	17485.00	2990.00	845.00	269	6	397264	9657	41.1374132753443	0.249625888694038	0.245818004457283	false	false	false	true
376afe64-db16-4513-bac7-e773bb11f1ee	2026-09-30 15:08	2026-09-30 15:07	2026-09-30 15:07	SPY	SPY260930C00767000	call	767.0000	2026-09-30	0.6400	0.6400	0.6500	766.7400	10560.00	0.00	10560.00	165	6	395510	9657	40.9557833695765	0.248626431746463	0.250110123760374	false	false	false	true
1000de96-b9ad-44aa-8072-1c7f2bcf97d5	2026-09-30 15:07	2026-09-30 15:07	2026-09-30 15:07	SPY	SPY261005C00759000	call	759.0000	2026-10-05	9.5400	9.5400	9.7600	766.7700	10494.00	0.00	10494.00	11	5	135	183	0.737704918032787	0.119251742304563	0.119251742304563	false	false	false	true
d7612fba-ef39-48f7-836c-fcd3a73b4e16	2026-09-30 15:07	2026-09-30 15:07	2026-09-30 15:07	SPY	SPY261130P00660000	put	660.0000	2026-11-30	1.9000	1.9000	1.9200	766.7450	21470.00	0.00	21470.00	113	9	117	1682	0.0695600475624257	0.248538609750617	0.248538609750617	false	false	false	true
196cd534-5141-45b4-ac93-400f7c2908de	2026-09-30 15:07	2026-09-30 15:07	2026-09-30 15:07	SPY	SPY261130P00663000	put	663.0000	2026-11-30	1.9800	1.9800	2.0000	766.7450	52668.00	0.00	52668.00	266	8	266	2	133	0.245018520891846	0.245018520891846	false	false	false	true
165567a5-b608-4e69-90c0-aaaec73d897c	2026-09-30 15:07	2026-09-30 15:07	2026-09-30 15:07	SPY	SPY260930P00773000	put	773.0000	2026-09-30	6.2800	6.2700	6.2900	766.7600	86664.00	52124.00	34540.00	138	5	5948	1084	5.48708487084871	0.410881135217143	0.440409915212064	false	false	false	true
90db8b7f-9f05-46dd-905e-6eb775a321c1	2026-09-30 15:07	2026-09-30 15:07	2026-09-30 15:07	SPY	SPY261005C00767000	call	767.0000	2026-10-05	4.0500	4.0400	4.0500	766.6900	52245.00	52245.00	0.00	129	6	4059	1048	3.87309160305344	0.111536871749119	0.111536871749119	false	false	false	true
47ba275d-35a0-4b0c-9596-e81a7324585c	2026-09-30 15:07	2026-09-30 15:07	2026-09-30 15:07	SPY	SPY261006P00765000	put	765.0000	2026-10-06	3.6300	3.6000	3.6300	766.6700	21780.00	21780.00	0.00	60	9	1000	1345	0.743494423791822	0.118436365580182	0.118436365580182	false	false	false	true
bde1dc49-a83c-4ddf-9b9a-410640b57561	2026-09-30 15:07	2026-09-30 15:07	2026-09-30 15:07	SPY	SPY261016P00765000	put	765.0000	2026-10-16	6.8300	6.8200	6.8500	766.6800	88790.00	1366.00	87424.00	130	7	3109	16526	0.188127798620356	0.129080597721116	0.129218697222042	true	false	false	true
01bafceb-8ce3-4755-b711-b16b9cd6245e	2026-09-30 15:07	2026-09-30 15:07	2026-09-30 15:07	SPY	SPY261218C00766000	call	766.0000	2026-12-18	24.2100	24.1300	24.2300	766.6500	1888380.00	1888380.00	0.00	780	42	989	360	2.74722222222222	0.142326244326197	0.142326244326197	true	false	false	true
e2d296a8-47b2-4616-bf5f-cec50f304d45	2026-09-30 15:06	2026-09-30 15:06	2026-09-30 15:06	SPY	SPY270115P00775000	put	775.0000	2027-01-15	23.7600	23.7600	23.8100	766.7300	111672.00	0.00	111672.00	47	6	183	7251	0.025237898220935	0.147944711124058	0.147944711124058	false	false	false	true
1dec8364-2a91-4f4e-a8d0-39d9c9f9bcf6	2026-09-30 15:06	2026-09-30 15:06	2026-09-30 15:06	SPY	SPY260930C00766000	call	766.0000	2026-09-30	1.1800	1.1800	1.1900	766.7450	14514.00	0.00	14514.00	123	6	156748	14331	10.9376875305282	0.24276992003501	0.24276992003501	false	false	false	true
bae53682-3e4a-457b-a9ef-e519a9a5e78c	2026-09-30 15:06	2026-09-30 15:06	2026-09-30 15:06	SPY	SPY260930C00766000	call	766.0000	2026-09-30	1.1700	1.1700	1.1800	766.7300	36621.00	0.00	36621.00	313	6	156599	14331	10.9272904891494	0.242399292645467	0.242399292645467	true	false	false	true
f06b8c7d-7d66-413f-be4f-949c35983d55	2026-09-30 15:06	2026-09-30 15:06	2026-09-30 15:06	SPY	SPY260930P00766000	put	766.0000	2026-09-30	0.4600	0.4500	0.4700	766.7700	22264.00	1426.00	20838.00	484	5	516171	3414	151.19244288225	0.253311619750797	0.255137335970642	false	false	false	true
6fde7c59-102b-451c-97c9-f14252a33026	2026-09-30 15:06	2026-09-30 15:06	2026-09-30 15:06	SPY	SPY260930C00767000	call	767.0000	2026-09-30	0.6400	0.6300	0.6400	766.7550	18880.00	18880.00	0.00	295	5	393358	9657	40.7329398363881	0.244565483648654	0.244565483648654	false	false	false	true
0da934ba-50d7-41b6-9435-2a7d5efe22ca	2026-09-30 15:06	2026-09-30 15:06	2026-09-30 15:06	SPY	SPY260930C00769000	call	769.0000	2026-09-30	0.1300	0.1300	0.1400	766.7000	11687.00	0.00	11687.00	899	11	661847	9944	66.5574215607401	0.26066539707628	0.26066539707628	true	false	false	true
7377738b-e394-4747-8905-40a2a25aa6a4	2026-09-30 15:06	2026-09-30 15:06	2026-09-30 15:06	SPY	SPY261014C00770000	call	770.0000	2026-10-14	6.1400	6.1200	6.1500	766.7100	39910.00	39910.00	0.00	65	7	1082	0	0	0.119027838185233	0.119027838185233	false	false	false	true
1fee91ee-d5fa-4333-9294-e10f33aa4a0f	2026-09-30 15:06	2026-09-30 15:06	2026-09-30 15:06	SPY	SPY261023C00772000	call	772.0000	2026-10-23	7.8800	7.8500	7.8900	766.7100	40188.00	40188.00	0.00	51	5	415	1518	0.273386034255599	0.122821364115894	0.122821364115894	false	false	false	true
d8f1710e-8302-48ee-bc5b-6be086b1ecf5	2026-09-30 15:06	2026-09-30 15:05	2026-09-30 15:05	SPY	SPY261016C00770000	call	770.0000	2026-10-16	7.0400	7.0100	7.0400	766.6850	22528.00	22528.00	0.00	32	6	11706	20377	0.574471217549198	0.124431095292401	0.124431095292401	false	false	false	true
d28ff628-f441-414b-b9d0-498e46bc69b2	2026-09-30 15:06	2026-09-30 15:05	2026-09-30 15:05	SPY	SPY261016C00772000	call	772.0000	2026-10-16	6.0200	6.0000	6.0200	766.6850	36120.00	36120.00	0.00	60	8	783	5134	0.152512660693416	0.122064037681695	0.122064037681695	true	false	false	true
12c933ca-7bc1-4ceb-a3bb-8503f5a221b9	2026-09-30 15:06	2026-09-30 15:05	2026-09-30 15:05	SPY	SPY261016C00774000	call	774.0000	2026-10-16	5.0900	5.0700	5.1000	766.6850	93147.00	93147.00	0.00	183	6	917	3714	0.246903607969844	0.119784300157793	0.119784300157793	true	false	false	true
b5a53c20-9b23-46f9-8f0d-2f1d3acbe5b1	2026-09-30 15:05	2026-09-30 15:05	2026-09-30 15:05	SPY	SPY261009C00770000	call	770.0000	2026-10-09	4.6200	4.6000	4.6200	766.6701	30030.00	30030.00	0.00	65	7	6582	5514	1.1936887921654	0.120810705208123	0.120810705208123	false	false	false	true
067d2977-ceaa-40af-ba38-4a4b67d2ad79	2026-09-30 15:05	2026-09-30 15:05	2026-09-30 15:05	SPY	SPY261006C00770000	call	770.0000	2026-10-06	3.0500	3.0300	3.0600	766.6701	12200.00	11590.00	0.00	40	6	1761	1001	1.75924075924076	0.109799186388716	0.109799186388716	false	false	false	true
5fad9008-1f82-42c2-ac58-9f2f7689e754	2026-09-30 15:05	2026-09-30 15:05	2026-09-30 15:05	SPY	SPY261002C00775000	call	775.0000	2026-10-02	0.5400	0.5300	0.5400	766.6400	18090.00	18090.00	0.00	335	12	18896	15240	1.23989501312336	0.132803445531822	0.132803445531822	false	false	false	true
3d8006f4-b497-49e0-afb8-73c06c9846cb	2026-09-30 15:05	2026-09-30 15:05	2026-09-30 15:05	SPY	SPY261002C00769000	call	769.0000	2026-10-02	2.2400	2.2300	2.2400	766.6400	27552.00	27552.00	0.00	123	6	14924	3788	3.93980992608237	0.141893833879347	0.141893833879347	false	false	false	true
3a2aeec7-4d85-4eba-81ba-f8e25d79819c	2026-09-30 15:05	2026-09-30 15:05	2026-09-30 15:05	SPY	SPY261001C00770000	call	770.0000	2026-10-01	0.9000	0.9000	0.9100	766.6700	18000.00	0.00	18000.00	200	7	61765	3765	16.4050464807437	0.13356945767713	0.13356945767713	false	false	false	true
8580b7e5-5de4-4e2b-aa0e-8f2af05505d6	2026-09-30 15:05	2026-09-30 15:05	2026-09-30 15:05	SPY	SPY261002P00765000	put	765.0000	2026-10-02	2.3900	2.3900	2.4000	766.7000	23900.00	0.00	23900.00	100	8	22232	15059	1.47632644929942	0.143240224976486	0.143240224976486	false	false	false	true
ccf5f2e0-559e-47f4-a095-d54228333bb2	2026-09-30 15:05	2026-09-30 15:05	2026-09-30 15:05	SPY	SPY261001C00765000	call	765.0000	2026-10-01	3.3200	3.3100	3.3200	766.6900	33532.00	33532.00	0.00	101	7	12773	3520	3.62869318181818	0.145438576769149	0.145438576769149	true	false	false	true
502530e6-8a6c-4ae6-908a-4f01abcec9d7	2026-09-30 15:05	2026-09-30 15:05	2026-09-30 15:05	SPY	SPY261001C00770000	call	770.0000	2026-10-01	0.9100	0.9100	0.9200	766.6900	18200.00	0.00	18200.00	200	9	61565	3765	16.3519256308101	0.133905666443582	0.133905666443582	false	false	false	true
fdbf8001-bad0-4903-83d9-a7975d2811d4	2026-09-30 15:04	2026-09-30 15:04	2026-09-30 15:04	SPY	SPY261009P00764000	put	764.0000	2026-10-09	4.4500	4.4500	4.4700	766.7500	18245.00	0.00	18245.00	41	8	1369	960	1.42604166666667	0.126030300212822	0.12611703118295	true	false	false	true
2f10dd05-d87c-4ba1-bf3a-665a37bde8a4	2026-09-30 15:04	2026-09-30 15:04	2026-09-30 15:04	SPY	SPY261009P00760000	put	760.0000	2026-10-09	3.2600	3.2600	3.2800	766.7500	13040.00	0.00	13040.00	40	5	5677	6545	0.867379679144385	0.132078917100198	0.132152443622691	false	false	false	true
831a9cb9-56d8-4699-b92f-10a887eadb8b	2026-09-30 15:03	2026-09-30 15:03	2026-09-30 15:03	SPY	SPY261005P00761000	put	761.0000	2026-10-05	1.9200	1.9000	1.9200	766.7600	10176.00	10176.00	0.00	53	5	598	590	1.0135593220339	0.12132684797504	0.12132684797504	false	false	false	true
98e4270f-4336-490d-9326-6eaac3167408	2026-09-30 15:03	2026-09-30 15:02	2026-09-30 15:02	SPY	SPY260930C00767000	call	767.0000	2026-09-30	0.6500	0.6400	0.6500	766.7700	59605.00	59605.00	0.00	917	8	387620	9657	40.1387594491043	0.237788448643506	0.237788448643506	false	false	false	true
5a558ee7-bebb-4c71-a08d-55ea910e1d90	2026-09-30 15:02	2026-09-30 15:02	2026-09-30 15:02	SPY	SPY260930C00766000	call	766.0000	2026-09-30	1.2000	1.1900	1.2100	766.7600	11640.00	11160.00	480.00	97	7	153650	14331	10.72151280441	0.237254632578051	0.237254632578051	false	false	false	true
1adf4dc6-0e34-4fc8-b3a4-9f3e23a62c12	2026-09-30 15:02	2026-09-30 15:02	2026-09-30 15:02	SPY	SPY260930P00766000	put	766.0000	2026-09-30	0.4700	0.4600	0.4700	766.7300	15698.00	15698.00	0.00	334	8	509063	3414	149.110427650849	0.244705737402462	0.244705737402462	false	false	false	true
2d402ad0-28cd-4c12-9ff3-443760782170	2026-09-30 15:01	2026-09-30 15:01	2026-09-30 15:01	SPY	SPY261002C00772000	call	772.0000	2026-10-02	1.1900	1.1800	1.1900	766.6900	12614.00	12614.00	0.00	106	8	10870	15323	0.709391111401162	0.136751096317084	0.136751096317084	false	false	false	true
e23473b2-dce3-4e10-8d4c-66153e4fbc94	2026-09-30 15:01	2026-09-30 15:01	2026-09-30 15:01	SPY	SPY261001C00769000	call	769.0000	2026-10-01	1.2600	1.2500	1.2700	766.6600	56700.00	52038.00	0.00	450	12	50423	2153	23.4198792382722	0.137630693246961	0.137630693246961	false	false	false	true
dda80aa9-3501-407a-8f68-699e8e9a9c0a	2026-09-30 15:01	2026-09-30 15:01	2026-09-30 15:01	SPY	SPY261016C00783000	call	783.0000	2026-10-16	2.1200	2.1100	2.1200	766.6800	10600.00	10600.00	0.00	50	5	1118	7745	0.144351194318915	0.112611681245329	0.112520940247842	false	false	false	true
0347fb87-c41b-4701-a2b3-1c7ecf25ec5c	2026-09-30 15:01	2026-09-30 15:01	2026-09-30 15:01	SPY	SPY260930C00767000	call	767.0000	2026-09-30	0.6000	0.5900	0.6000	766.6600	16019.00	15960.00	59.00	267	12	383079	9657	39.6685305995651	0.237196838305957	0.234496426908546	false	false	false	true
92e39935-83ea-4e11-aabf-2df0e95c76d9	2026-09-30 15:01	2026-09-30 15:01	2026-09-30 15:01	SPY	SPY260930C00766000	call	766.0000	2026-09-30	1.1300	1.1200	1.1300	766.6100	10170.00	10170.00	0.00	90	8	151568	14331	10.5762333403112	0.243221865104446	0.243221865104446	false	false	false	true