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.

728,802 rows

Sources in this table

uw_flow_alerts728,802 rows

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:endpoint = /api/option-trades/flow-alerts×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	expiry

50607ff3-8ba0-40da-99e1-0229ecc580ba	2026-10-02 14:22	2026-10-02 14:22	2026-10-02 14:22	SPY	SPY261002C00770000	call	770.0000	2026-10-02	0.2000	0.1900	0.2100	768.6500	12261.00	0.00	12261.00	619	7	611718	18665	32.7735333511921	0.15777099856536	0.156541389243608	true	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	ETF	—	817569476132.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-10-02T18:24:45.274853Z"}	2026-10-02	2026-10-02 21:15	2026-10-02 21:15
120af60f-4c9e-4461-ba88-09ec9adf9235	2026-10-02 14:22	2026-10-02 14:22	2026-10-02 14:22	SPY	SPY261009P00765000	put	765.0000	2026-10-09	3.0200	2.9900	3.0200	768.7100	377500.00	377500.00	0.00	1250	10	10410	2256	4.61436170212766	0.115067869857048	0.115067869857048	false	false	false	true
a0c5dbdf-6c76-43e4-a2fe-87e66738acef	2026-10-02 14:22	2026-10-02 14:22	2026-10-02 14:22	SPY	SPY261006P00768000	put	768.0000	2026-10-06	2.6000	2.6000	2.6200	768.7000	130052.00	0.00	130052.00	500	15	11643	472	24.6673728813559	0.0967235147790193	0.0964089888457004	false	false	false	true
74a6a048-0a0e-441b-b972-4f7402895e86	2026-10-02 14:22	2026-10-02 14:22	2026-10-02 14:22	SPY	SPY261002P00769000	put	769.0000	2026-10-02	0.8100	0.8100	0.8200	768.7300	30222.00	14022.00	16200.00	371	15	712915	3044	234.203350854139	0.160230994887466	0.162667003287213	false	false	false	true
23afe265-cc23-48c3-85da-cf2665e1079d	2026-10-02 14:22	2026-10-02 14:22	2026-10-02 14:22	SPY	SPY261002P00770000	put	770.0000	2026-10-02	1.4900	1.4800	1.4900	768.7300	74500.00	74500.00	0.00	500	12	484081	4172	116.03092042186	0.162292953596773	0.162292953596773	false	false	false	true
db4af824-193f-4502-b12e-97d1014b8c7b	2026-10-02 14:22	2026-10-02 14:22	2026-10-02 14:22	SPY	SPY261009P00765000	put	765.0000	2026-10-09	3.0100	2.9900	3.0100	768.7400	376250.00	376250.00	0.00	1250	9	9160	2256	4.06028368794326	0.115087085966341	0.115087085966341	false	false	false	true
c8dc7663-2cfb-4973-b556-16f4066a16a8	2026-10-02 14:22	2026-10-02 14:22	2026-10-02 14:22	SPY	SPY261002P00769000	put	769.0000	2026-10-02	0.8100	0.8000	0.8200	768.7400	41542.00	405.00	20725.00	516	15	712502	3044	234.067674113009	0.161533934022833	0.159127807492619	false	false	false	true
d5959de7-8605-4869-bcdc-f5c52f6faa89	2026-10-02 14:22	2026-10-02 14:22	2026-10-02 14:22	SPY	SPY261002P00769000	put	769.0000	2026-10-02	0.8100	0.8000	0.8200	768.7400	44467.00	34911.00	160.00	549	7	711770	3044	233.827201051248	0.161452077211008	0.161452077211008	false	false	false	true
42bbbf17-b08b-4b28-9be4-e768da6bb1c7	2026-10-02 14:22	2026-10-02 14:22	2026-10-02 14:22	SPY	SPY261005C00771000	call	771.0000	2026-10-05	1.2400	1.2400	1.2500	768.7350	57040.00	0.00	57040.00	460	19	43815	2095	20.9140811455847	0.0751591215698306	0.0751591215698306	false	false	false	true
c4c92fab-5175-40ee-bec8-d6375ff6b8a3	2026-10-02 14:22	2026-10-02 14:22	2026-10-02 14:22	SPY	SPY261002P00771000	put	771.0000	2026-10-02	2.3300	2.3300	2.3400	768.7500	11650.00	0.00	11650.00	50	6	306102	1555	196.850160771704	0.168348053454095	0.168348053454095	false	false	false	true
9330c41e-816e-476a-8f1e-b45faf6f52b0	2026-10-02 14:22	2026-10-02 14:22	2026-10-02 14:22	SPY	SPY261006P00768000	put	768.0000	2026-10-06	2.5800	2.5800	2.6000	768.7700	31992.00	0.00	31992.00	124	5	11134	472	23.5889830508475	0.0967552245661655	0.0967552245661655	false	false	false	true
301a49d0-72da-41da-982c-a1e9d267f2c3	2026-10-02 14:22	2026-10-02 14:22	2026-10-02 14:22	SPY	SPY261002C00769000	call	769.0000	2026-10-02	0.5500	0.5300	0.5500	768.7450	16635.00	13858.00	2777.00	304	25	383595	5858	65.4822465005121	0.156701726688552	0.156962672017376	true	false	false	true
3c88bbb3-d047-497d-967b-ae456084e7c0	2026-10-02 14:22	2026-10-02 14:22	2026-10-02 14:22	SPY	SPY261002P00769000	put	769.0000	2026-10-02	0.8000	0.7900	0.8100	768.7700	16653.00	16334.00	79.00	208	15	710776	3044	233.500657030223	0.162909953840525	0.165318800670388	true	false	false	true
b889c051-392f-4aae-94df-a93ccd0e6211	2026-10-02 14:21	2026-10-02 14:21	2026-10-02 14:21	SPY	SPY261002P00770000	put	770.0000	2026-10-02	1.4000	1.4000	1.4300	768.8000	85645.00	0.00	74165.00	610	14	483225	4172	115.825743048897	0.156362712325033	0.150111381594154	true	false	false	true
4d086100-0e4d-4d22-8863-30461d262b66	2026-10-02 14:21	2026-10-02 14:21	2026-10-02 14:21	SPY	SPY261002P00769000	put	769.0000	2026-10-02	0.7700	0.7700	0.7800	768.7925	10780.00	0.00	10780.00	140	5	709779	3044	233.173127463863	0.158040525108196	0.158040525108196	false	false	false	true
6be0672c-b5ea-4c25-afcd-83e90649b210	2026-10-02 14:21	2026-10-02 14:21	2026-10-02 14:21	SPY	SPY261002P00769000	put	769.0000	2026-10-02	0.7900	0.7900	0.8000	768.7600	11060.00	0.00	11060.00	140	5	709288	3044	233.011826544021	0.161082931768385	0.158432482869356	false	false	false	true
525c3d15-c63c-4c40-9c29-7bd42fbe0d37	2026-10-02 14:21	2026-10-02 14:21	2026-10-02 14:21	SPY	SPY261002P00768000	put	768.0000	2026-10-02	0.3900	0.3900	0.4000	768.7600	39120.00	120.00	39000.00	1003	5	601608	3948	152.382978723404	0.16843461623315	0.171042053908497	false	false	false	true
80ceafb1-6549-447f-9626-08b989759e2d	2026-10-02 14:21	2026-10-02 14:21	2026-10-02 14:21	SPY	SPY261002C00769000	call	769.0000	2026-10-02	0.5600	0.5500	0.5700	768.7800	13216.00	11312.00	1904.00	236	10	380998	5858	65.0389211334927	0.156147256122929	0.157238864446543	false	false	false	true
2ab2ec31-6a14-43a2-ad17-de2462b0b6a7	2026-10-02 14:20	2026-10-02 14:20	2026-10-02 14:20	SPY	SPY261002P00769000	put	769.0000	2026-10-02	0.7600	0.7400	0.7600	768.8400	11912.00	10562.00	1350.00	157	16	708730	3044	232.828515111695	0.161425413505051	0.159042236510009	true	false	false	true
aa515727-ce74-4c49-b634-9feb1329353a	2026-10-02 14:20	2026-10-02 14:20	2026-10-02 14:20	SPY	SPY261002C00767000	call	767.0000	2026-10-02	2.0200	2.0000	2.0100	768.8500	20163.00	20163.00	0.00	100	6	51869	8148	6.36585665193913	0.175674123031637	0.179552605932986	true	false	false	true
59e8ca15-be66-4240-b7d0-b2be5f937e64	2026-10-02 14:20	2026-10-02 14:20	2026-10-02 14:20	SPY	SPY261002P00769000	put	769.0000	2026-10-02	0.7100	0.7000	0.7200	768.9200	78455.00	3479.00	0.00	1105	8	708427	3044	232.728975032852	0.159349636649464	0.159349636649464	false	false	false	true
4a89e4d4-30ff-492e-a858-c656fedc563e	2026-10-02 14:20	2026-10-02 14:20	2026-10-02 14:20	SPY	SPY261005C00769000	call	769.0000	2026-10-05	2.2500	2.2500	2.2600	768.9150	29250.00	0.00	29250.00	130	5	33267	1938	17.1656346749226	0.0777910574595855	0.0777910574595855	false	false	false	true
270591c8-9253-4dc3-abc6-010f81579a32	2026-10-02 14:20	2026-10-02 14:20	2026-10-02 14:20	SPY	SPY261002P00770000	put	770.0000	2026-10-02	1.3600	1.3400	1.3600	768.8900	16883.00	12193.00	4690.00	124	9	481732	4172	115.467881112176	0.160674460250532	0.151826667910976	true	false	false	true
04d33804-1ab4-46c0-97a6-3b503109cbef	2026-10-02 14:20	2026-10-02 14:20	2026-10-02 14:20	SPY	SPY261002P00768000	put	768.0000	2026-10-02	0.3600	0.3500	0.3700	768.8700	20515.00	13320.00	7195.00	570	6	599228	3948	151.780141843972	0.168955638497439	0.168955638497439	false	false	false	true
8b983020-94ff-46f3-af68-d8c41ba40fc3	2026-10-02 14:19	2026-10-02 14:19	2026-10-02 14:19	SPY	SPY261005C00770000	call	770.0000	2026-10-05	1.7200	1.7200	1.7300	768.8600	17200.00	0.00	17200.00	100	6	55966	3563	15.7075498175695	0.0766428346236193	0.0766428346236193	false	false	false	true
b3c862e6-92ab-41f7-9b9c-4cee413db210	2026-10-02 14:19	2026-10-02 14:19	2026-10-02 14:19	SPY	SPY261002C00767000	call	767.0000	2026-10-02	2.0100	2.0000	2.0200	768.8500	21105.00	0.00	19095.00	105	7	51524	8148	6.32351497299951	0.174332371179047	0.174332371179047	false	false	false	true
325be9d3-9899-455b-b93d-62c2dd9e0e53	2026-10-02 14:19	2026-10-02 14:19	2026-10-02 14:19	SPY	SPY261006C00772000	call	772.0000	2026-10-06	1.5800	1.5700	1.5800	768.8500	13904.00	13904.00	0.00	88	7	7690	774	9.93540051679587	0.0857739171375433	0.0857739171375433	false	false	false	true
0292f7a8-e1c2-40ff-8bb3-c0e854b800e1	2026-10-02 14:19	2026-10-02 14:19	2026-10-02 14:19	SPY	SPY261005P00766000	put	766.0000	2026-10-05	1.2300	1.2200	1.2300	768.8700	12300.00	12300.00	0.00	100	8	26086	1919	13.5935383011985	0.0895986869525508	0.0895986869525508	true	false	false	true
bc8b312a-7254-4494-a35b-0398fdd7c43c	2026-10-02 14:18	2026-10-02 14:18	2026-10-02 14:18	SPY	SPY261002C00770000	call	770.0000	2026-10-02	0.2500	0.2400	0.2500	768.8850	25000.00	25000.00	0.00	1000	18	603935	18665	32.3565496919368	0.155372408317628	0.155372408317628	true	false	false	true
e4c0bdf4-29a7-4027-8f72-c4c341384944	2026-10-02 14:18	2026-10-02 14:18	2026-10-02 14:18	SPY	SPY261002C00769000	call	769.0000	2026-10-02	0.6200	0.6100	0.6200	768.8850	13144.00	13144.00	0.00	212	9	377210	5858	64.3922840559918	0.15797062208196	0.15797062208196	false	false	false	true
84db1bc1-b921-43b6-a758-8b15413919c8	2026-10-02 14:18	2026-10-02 14:18	2026-10-02 14:18	SPY	SPY261002C00768000	call	768.0000	2026-10-02	1.2500	1.2300	1.2600	768.9200	19984.00	0.00	19488.00	160	6	135612	9985	13.5815723585378	0.16208122336346	0.15936587459878	true	false	false	true
b82f33ed-8634-45f1-850d-6d1d555790a4	2026-10-02 14:18	2026-10-02 14:18	2026-10-02 14:18	SPY	SPY261005P00766000	put	766.0000	2026-10-05	1.2000	1.1900	1.2000	768.9200	12000.00	12000.00	0.00	100	5	25783	1919	13.4356435643564	0.0889934060540423	0.0889934060540423	true	false	false	true
7583ded6-b995-4d7a-a1cd-4ceb71e047b6	2026-10-02 14:18	2026-10-02 14:18	2026-10-02 14:18	SPY	SPY261002P00770000	put	770.0000	2026-10-02	1.3400	1.3500	1.3600	768.8850	67126.00	0.00	67126.00	501	13	480878	4172	115.263183125599	0.152455998322678	0.152455998322678	true	false	false	true
f9af71ff-274b-4489-994e-e870b7b12889	2026-10-02 14:18	2026-10-02 14:18	2026-10-02 14:18	SPY	SPY261002P00769000	put	769.0000	2026-10-02	0.7300	0.7300	0.7400	768.8850	10950.00	0.00	10950.00	150	7	704764	3044	231.525624178712	0.158044115969106	0.158044115969106	false	false	false	true
879702b8-2c1a-4bc9-866e-cfd1efb2fb44	2026-10-02 14:18	2026-10-02 14:18	2026-10-02 14:18	SPY	SPY261002P00769000	put	769.0000	2026-10-02	0.7500	0.7500	0.7700	768.8200	31520.00	532.00	30000.00	420	15	704561	3044	231.458935611038	0.15691221950021	0.15691221950021	false	false	false	true
76f95371-f65d-4a6d-989f-c5d3e824f4e1	2026-10-02 14:18	2026-10-02 14:18	2026-10-02 14:18	SPY	SPY261002P00766000	put	766.0000	2026-10-02	0.1000	0.0900	0.1100	768.8300	14465.00	1470.00	12245.00	1499	20	296767	4897	60.6017970185828	0.204751198467715	0.19917138017885	false	false	false	true
12d2b0ed-1d1f-49f7-bea3-608ce251f6fc	2026-10-02 14:18	2026-10-02 14:18	2026-10-02 14:18	SPY	SPY261005P00769000	put	769.0000	2026-10-05	2.2800	2.2800	2.2900	768.7900	23028.00	0.00	23028.00	101	6	55914	1739	32.1529614721104	0.0828353808509426	0.0828353808509426	true	false	false	true
08af247e-40ff-4a87-95e4-5a40f00a22f7	2026-10-02 14:18	2026-10-02 14:18	2026-10-02 14:18	SPY	SPY261002P00769000	put	769.0000	2026-10-02	0.7800	0.7600	0.7900	768.7900	15734.00	5984.00	9750.00	201	15	704089	3044	231.303876478318	0.160100352171158	0.155379066204258	false	false	false	true
a93a14c2-c75f-4cf6-a637-356e369e4bf4	2026-10-02 14:18	2026-10-02 14:18	2026-10-02 14:18	SPY	SPY261005C00772000	call	772.0000	2026-10-05	0.9100	0.9100	0.9200	768.7700	18200.00	0.00	18200.00	200	7	43583	1312	33.21875	0.074115630669403	0.074115630669403	false	false	false	true
095c72bd-555e-47a6-a2d3-b02c66d7ee9f	2026-10-02 14:18	2026-10-02 14:18	2026-10-02 14:18	SPY	SPY261002C00769000	call	769.0000	2026-10-02	0.5700	0.5600	0.5700	768.7600	10830.00	10830.00	0.00	190	5	376036	5858	64.1918743598498	0.158889339970357	0.159416989471081	false	false	false	true
75b103b4-88f9-4932-9068-a39cfc6d1ef7	2026-10-02 14:18	2026-10-02 14:18	2026-10-02 14:18	SPY	SPY261002C00768000	call	768.0000	2026-10-02	1.2000	1.2000	1.2200	768.8300	11165.00	484.00	10681.00	93	8	135006	9985	13.520881321983	0.165877515577069	0.165028377100985	true	false	false	true
edbb0c5f-eca2-48c2-b8fa-e016319dc8a4	2026-10-02 14:18	2026-10-02 14:18	2026-10-02 14:18	SPY	SPY261002C00769000	call	769.0000	2026-10-02	0.6000	0.5900	0.6000	768.8400	14455.00	14160.00	295.00	241	12	375358	5858	64.0761351997269	0.157804119602613	0.157804119602613	false	false	false	true
00d230a6-0171-4421-a327-02873e43bbfc	2026-10-02 14:18	2026-10-02 14:18	2026-10-02 14:18	SPY	SPY261005P00769000	put	769.0000	2026-10-05	2.2700	2.2700	2.2800	768.8450	56750.00	0.00	56750.00	250	6	55763	1739	32.066129959747	0.0834517600060217	0.0834517600060217	false	false	false	true
bdd54047-8535-4f91-a9a1-7cff883f16a9	2026-10-02 14:18	2026-10-02 14:17	2026-10-02 14:17	SPY	SPY261002C00768000	call	768.0000	2026-10-02	1.2400	1.2300	1.2600	768.8700	56525.00	11160.00	45365.00	455	11	134727	9985	13.4929394091137	0.163473981023865	0.168189531172047	false	false	false
35b6190e-fb0b-4194-a5b0-c8e911c3a55b	2026-10-02 14:18	2026-10-02 14:17	2026-10-02 14:17	SPY	SPY261007C00772000	call	772.0000	2026-10-07	2.1800	2.1800	2.2000	768.8700	43601.00	0.00	43601.00	200	8	6068	834	7.2757793764988	0.0934017200284482	0.0934017200284482	true	false	false	true
f84d9c8a-fbb5-44a5-b5cd-0e9ad647f3be	2026-10-02 14:17	2026-10-02 14:17	2026-10-02 14:17	SPY	SPY261002P00769000	put	769.0000	2026-10-02	0.6900	0.6800	0.7100	768.9400	13292.00	1838.00	0.00	192	8	702148	3044	230.666228646518	0.157350950592734	0.159656908240518	false	false	false	true
7e5855e5-4560-483c-abea-cf0417491e1e	2026-10-02 14:17	2026-10-02 14:17	2026-10-02 14:17	SPY	SPY261006C00769000	call	769.0000	2026-10-06	3.0600	3.0500	3.0600	769.0000	45288.00	45288.00	0.00	148	5	9393	963	9.75389408099688	0.089874148204528	0.089874148204528	false	false	false	true
034219bb-06c8-4fec-a653-140dbda43f58	2026-10-02 14:17	2026-10-02 14:16	2026-10-02 14:16	SPY	SPY261002P00769000	put	769.0000	2026-10-02	0.7100	0.7000	0.7200	768.9400	16121.00	15980.00	141.00	227	6	699798	3044	229.894218134034	0.158913411579421	0.158913411579421	false	false	false	true
b16e690f-449f-46ac-8b6b-773703d88492	2026-10-02 14:16	2026-10-02 14:16	2026-10-02 14:16	SPY	SPY261009C00783000	call	783.0000	2026-10-09	0.4600	0.4500	0.4600	768.9200	47564.00	47564.00	0.00	1034	13	3925	7607	0.515972130932036	0.0958259780236447	0.0958259780236447	false	false	false	true
98ee088b-5053-4d7a-8bfb-8b92d10bacfe	2026-10-02 14:16	2026-10-02 14:16	2026-10-02 14:16	SPY	SPY261009C00785000	call	785.0000	2026-10-09	0.3000	0.2900	0.3000	768.9200	61290.00	61290.00	0.00	2043	21	22154	104934	0.21112318219071	0.0957262176436201	0.0957262176436201	false	false	false