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.

708,051 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts708,051 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

d74bfbda-ccfb-430f-8018-a787c188fa5d	2026-10-02 13:28	2026-10-02 13:28	2026-10-02 13:28	SPY	SPY261002P00769000	put	769.0000	2026-10-02	1.2000	1.1900	1.2100	768.0000	37560.00	1800.00	35760.00	313	23	584836	3044	192.127463863338	0.172485409925745	0.172494788588513	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	817569476132.00	—	—	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-10-02T17:33:01.807894Z"}	2026-10-02	2026-10-02 21:15	2026-10-02 21:15
bcf8a793-8365-45ce-803b-1ace5545d123	2026-10-02 13:28	2026-10-02 13:28	2026-10-02 13:28	SPY	SPY261002C00768000	call	768.0000	2026-10-02	1.2000	1.2000	1.2100	768.0000	37800.00	0.00	37680.00	315	8	110842	9985	11.1008512769154	0.178668254321153	0.178668254321153	false	false	false	true
b8482f67-78cf-4481-a4e8-1a60cf2bd42f	2026-10-02 13:28	2026-10-02 13:28	2026-10-02 13:28	SPY	SPY261002C00769000	call	769.0000	2026-10-02	0.6600	0.6600	0.6700	768.0000	44353.00	67.00	44286.00	672	29	287970	5858	49.1584158415842	0.170642972096092	0.170642972096092	false	false	false	true
65051aaf-9dc5-494e-bc64-8b97eabf3ec8	2026-10-02 13:28	2026-10-02 13:28	2026-10-02 13:28	SPY	SPY261002P00768000	put	768.0000	2026-10-02	0.7100	0.7100	0.7200	768.0000	22648.00	0.00	22648.00	319	19	479622	3948	121.484802431611	0.176325023762728	0.176325023762728	true	false	false	true
59503e8e-29a0-4c6a-a17c-d39dae4c6a1e	2026-10-02 13:28	2026-10-02 13:28	2026-10-02 13:28	SPY	SPY261002C00767000	call	767.0000	2026-10-02	1.8700	1.8600	1.8700	768.0000	16082.00	16082.00	0.00	86	6	43189	8148	5.30056455571919	0.188507140407976	0.188507140407976	false	false	false	true
31f497a9-5cd4-4f20-ba64-38b5474278d5	2026-10-02 13:28	2026-10-02 13:28	2026-10-02 13:28	SPY	SPY261002C00769000	call	769.0000	2026-10-02	0.6600	0.6500	0.6700	768.0000	16963.00	16963.00	0.00	257	13	287298	5858	49.0437009218163	0.174673647950612	0.172613107940106	true	false	false	true
3011817d-58a4-4229-855e-2020549103d2	2026-10-02 13:28	2026-10-02 13:28	2026-10-02 13:28	SPY	SPY261002C00768000	call	768.0000	2026-10-02	1.1900	1.1800	1.1900	768.0000	40936.00	40936.00	0.00	344	13	110527	9985	11.0693039559339	0.182400419877263	0.182400419877263	false	false	false	true
fece3181-07c0-4e1d-8f8a-258b374df670	2026-10-02 13:28	2026-10-02 13:28	2026-10-02 13:28	SPY	SPY261002P00771000	put	771.0000	2026-10-02	2.6700	2.6700	2.6800	768.0000	21360.00	0.00	21360.00	80	6	296563	1555	190.71575562701	0.169298643561873	0.169298643561873	false	false	false	true
51a31541-67d1-4cc5-a4eb-41de19e95475	2026-10-02 13:28	2026-10-02 13:28	2026-10-02 13:28	SPY	SPY261005P00764000	put	764.0000	2026-10-05	1.0200	1.0100	1.0200	768.0000	20400.00	20400.00	0.00	200	6	18520	2478	7.47376916868442	0.0995064230523454	0.0995064230523454	false	false	false	true
e53c9a0c-a70b-47e5-81f3-32a46642cce8	2026-10-02 13:28	2026-10-02 13:28	2026-10-02 13:28	SPY	SPY261002C00768000	call	768.0000	2026-10-02	1.1700	1.1600	1.1700	768.0000	11700.00	11700.00	0.00	100	8	109861	9985	11.0026039058588	0.181021881678835	0.181021881678835	true	false	false	true
dd67d660-4e70-4e35-a936-efe3f42306ba	2026-10-02 13:28	2026-10-02 13:28	2026-10-02 13:28	SPY	SPY261005C00771000	call	771.0000	2026-10-05	1.3300	1.3200	1.3300	768.0000	13300.00	13300.00	0.00	100	8	37259	2095	17.7847255369928	0.0831815682887642	0.0831815682887642	false	false	false	true
ec66aae8-4cdb-4525-bd7c-2f6a60df9e51	2026-10-02 13:28	2026-10-02 13:27	2026-10-02 13:27	SPY	SPY261002P00768000	put	768.0000	2026-10-02	0.7200	0.7100	0.7300	768.0000	15047.00	0.00	15047.00	209	8	475301	3948	120.390324214792	0.177068840557713	0.175115061396766	true	false	false	true
fb6d7fe2-995c-4cdc-8780-063f6c46e1c0	2026-10-02 13:27	2026-10-02 13:27	2026-10-02 13:27	SPY	SPY261016P00742000	put	742.0000	2026-10-16	1.4000	1.3900	1.4000	768.0000	140000.00	140000.00	0.00	1000	13	2134	8685	0.245710995970063	0.159220883832076	0.159220883832076	false	false	false	true
2a88fbf4-cfbd-4298-a5c7-ae58972f4f7e	2026-10-02 13:27	2026-10-02 13:27	2026-10-02 13:27	SPY	SPY261002P00769000	put	769.0000	2026-10-02	1.2500	1.2400	1.2500	768.0000	13625.00	13625.00	0.00	109	6	581995	3044	191.194152431012	0.177106398373334	0.177106398373334	false	false	false	true
b0297dec-841c-486a-b0ed-bacf9a256b39	2026-10-02 13:27	2026-10-02 13:27	2026-10-02 13:27	SPY	SPY261002P00769000	put	769.0000	2026-10-02	1.2500	1.2400	1.2500	768.0000	65375.00	65375.00	0.00	523	11	581239	3044	190.94579500657	0.176972562094192	0.176972562094192	false	false	false	true
763404b8-4849-4711-8b98-926b8aa7a05b	2026-10-02 13:27	2026-10-02 13:27	2026-10-02 13:27	SPY	SPY261005C00771000	call	771.0000	2026-10-05	1.3400	1.3200	1.3300	768.0000	10050.00	10050.00	0.00	75	9	36786	2095	17.5589498806683	0.0838399945307416	0.0838399945307416	false	false	false	true
fa8ee1bd-7a88-48db-8a49-54b52113e460	2026-10-02 13:27	2026-10-02 13:27	2026-10-02 13:27	SPY	SPY261005C00768000	call	768.0000	2026-10-05	2.7700	2.7700	2.7800	768.0000	13296.00	0.00	13296.00	48	8	12551	1767	7.10299943406904	0.0871972091829231	0.0871972091829231	false	false	false	true
4a8d8a89-65c1-4cf0-9506-71bb56956ead	2026-10-02 13:27	2026-10-02 13:27	2026-10-02 13:27	SPY	SPY261002P00767000	put	767.0000	2026-10-02	0.4500	0.4400	0.4500	768.0000	17460.00	17460.00	0.00	388	8	350165	5049	69.3533372945138	0.192403521039403	0.192403521039403	false	false	false	true
c5e0fd57-2672-4422-8f1a-dc60d8105f6b	2026-10-02 13:27	2026-10-02 13:27	2026-10-02 13:27	SPY	SPY270319C00820000	call	820.0000	2027-03-19	13.3800	13.3700	13.3900	768.0000	12042.00	0.00	9366.00	9	6	4202	28831	0.145745898512018	0.129771501320789	0.129771501320789	true	false	false	true
c2611440-d251-49a3-ac5b-6ac6648a1701	2026-10-02 13:27	2026-10-02 13:27	2026-10-02 13:27	SPY	SPY261002C00768000	call	768.0000	2026-10-02	1.2300	1.2300	1.2400	768.0000	11439.00	0.00	11439.00	93	10	109143	9985	10.9306960440661	0.179145308234302	0.17972581201697	false	false	false	true
5f8e1762-505b-4b1b-944d-8d5c18669f56	2026-10-02 13:27	2026-10-02 13:27	2026-10-02 13:27	SPY	SPY261005P00769000	put	769.0000	2026-10-05	2.6300	2.6300	2.6400	768.0000	11309.00	0.00	11309.00	43	5	47725	1739	27.4439332949971	0.0907141063481985	0.090529764476637	false	false	false	true
05ec4af6-7d7f-4df4-8a7e-785f0dce9007	2026-10-02 13:27	2026-10-02 13:27	2026-10-02 13:27	SPY	SPY261002P00768000	put	768.0000	2026-10-02	0.7100	0.7100	0.7300	768.0000	10781.00	73.00	10708.00	151	6	471523	3948	119.433383991895	0.18315483316091	0.18315483316091	true	false	false	true
54c3d306-b2bb-4ea0-a77f-33390ede45de	2026-10-02 13:27	2026-10-02 13:27	2026-10-02 13:27	SPY	SPY261002P00768000	put	768.0000	2026-10-02	0.7200	0.7100	0.7300	768.0000	19148.00	144.00	19004.00	266	5	471298	3948	119.376393110436	0.182739499667465	0.183144927705612	false	false	false	true
2d76785f-e694-46ac-8fb0-9d4fac558a61	2026-10-02 13:26	2026-10-02 13:26	2026-10-02 13:26	SPY	SPY290119C01370000	call	1370.0000	2029-01-19	1.6900	1.5900	3.1200	768.0000	44109.00	0.00	36504.00	261	14	379	130	2.91538461538462	0.151275190293434	0.151275190293434	false	false	false	true
f7436dc8-33d2-4152-b17d-aa4aec91be29	2026-10-02 13:26	2026-10-02 13:26	2026-10-02 13:26	SPY	SPY261002P00769000	put	769.0000	2026-10-02	1.2300	1.2200	1.2400	768.0000	14514.00	0.00	6150.00	118	6	578274	3044	189.971747700394	0.177351573639671	0.177351573639671	false	false	false	true
da4bd4b6-ee59-498c-9a8d-1269dec85640	2026-10-02 13:26	2026-10-02 13:26	2026-10-02 13:26	SPY	SPY261002P00769000	put	769.0000	2026-10-02	1.1300	1.1300	1.1400	768.0000	23052.00	0.00	23052.00	204	9	577835	3044	189.82752956636	0.173718689308987	0.173718689308987	false	false	false	true
fb89d2b5-47eb-48c1-9003-00e46f9db34a	2026-10-02 13:26	2026-10-02 13:26	2026-10-02 13:26	SPY	SPY261002P00770000	put	770.0000	2026-10-02	1.7200	1.7100	1.7200	768.0000	12556.00	12556.00	0.00	73	6	446250	4172	106.963087248322	0.168872106322066	0.168872106322066	false	false	false	true
fb163e1b-b3ac-4438-8acf-eec2d9c2bd4d	2026-10-02 13:26	2026-10-02 13:26	2026-10-02 13:26	SPY	SPY261002P00769000	put	769.0000	2026-10-02	1.0900	1.0800	1.0900	768.0000	18530.00	18530.00	0.00	170	7	577227	3044	189.627792378449	0.17247443156618	0.17247443156618	false	false	false	true
8317b197-bf7a-49f2-a63a-0af5ffb561ea	2026-10-02 13:26	2026-10-02 13:26	2026-10-02 13:26	SPY	SPY261002P00769000	put	769.0000	2026-10-02	1.1000	1.1000	1.1100	768.0000	11990.00	0.00	11990.00	109	5	576644	3044	189.436268068331	0.172185624826936	0.172185624826936	false	false	false	true
6c1ad96a-f41e-4dad-ad2f-2edc73cc0784	2026-10-02 13:26	2026-10-02 13:26	2026-10-02 13:26	SPY	SPY261002P00770000	put	770.0000	2026-10-02	1.7000	1.6900	1.7000	768.0000	10540.00	10540.00	0.00	62	6	446008	4172	106.905081495686	0.17245802489191	0.17245802489191	false	false	false	true
6ea8a57b-8a1a-4851-9eed-c14375a7157e	2026-10-02 13:26	2026-10-02 13:26	2026-10-02 13:26	SPY	SPY261002C00769000	call	769.0000	2026-10-02	0.7400	0.7400	0.7500	768.0000	10434.00	0.00	10434.00	141	5	278999	5858	47.6270058040287	0.169142203455167	0.169142203455167	false	false	false	true
08899454-37fe-442f-b00c-f00edd3462bc	2026-10-02 13:26	2026-10-02 13:26	2026-10-02 13:26	SPY	SPY261002P00767000	put	767.0000	2026-10-02	0.3600	0.3500	0.3600	768.0000	15588.00	15588.00	0.00	433	8	345597	5049	68.4486036838978	0.188737595334849	0.187550864355427	false	false	false	true
b25990bb-c610-40e7-bc83-570158483f9c	2026-10-02 13:25	2026-10-02 13:25	2026-10-02 13:25	SPY	SPY261002C00769000	call	769.0000	2026-10-02	0.7700	0.7600	0.7700	768.0000	13860.00	13860.00	0.00	180	5	277972	5858	47.4516899965859	0.16674969349319	0.16674969349319	false	false	false	true
46b93888-504f-4643-8ecd-d5cc59d18988	2026-10-02 13:25	2026-10-02 13:25	2026-10-02 13:25	SPY	SPY261002C00769000	call	769.0000	2026-10-02	0.7700	0.7700	0.7800	768.0000	10395.00	0.00	10395.00	135	6	277261	5858	47.3303175145101	0.163977935273593	0.163977935273593	false	false	false	true
02f858ed-30f6-477f-b20a-f17a38e73e6e	2026-10-02 13:25	2026-10-02 13:25	2026-10-02 13:25	SPY	SPY261002P00768000	put	768.0000	2026-10-02	0.5400	0.5400	0.5500	768.0000	11125.00	55.00	11070.00	206	7	464951	3948	117.76874366768	0.173742068464435	0.17375137236048	false	false	false	true
b791a899-64b9-4552-b618-b80a3fa9bb94	2026-10-02 13:25	2026-10-02 13:25	2026-10-02 13:25	SPY	SPY261002P00769000	put	769.0000	2026-10-02	1.0000	1.0000	1.0100	768.0000	10800.00	0.00	10800.00	108	13	573524	3044	188.411300919842	0.168241091279367	0.168241091279367	true	false	false	true
817f1832-9ab8-4d5a-97ce-cb91b329971c	2026-10-02 13:25	2026-10-02 13:25	2026-10-02 13:25	SPY	SPY261002C00768000	call	768.0000	2026-10-02	1.3400	1.3300	1.3400	768.0000	13400.00	13400.00	0.00	100	13	107339	9985	10.7500250375563	0.174226165383125	0.174226165383125	true	false	false	true
909c367c-859d-4f4e-a629-db640be26be5	2026-10-02 13:24	2026-10-02 13:24	2026-10-02 13:24	SPY	SPY261002P00769000	put	769.0000	2026-10-02	1.0100	1.0100	1.0200	768.0000	50500.00	0.00	50500.00	500	10	572436	3044	188.053876478318	0.166900542660425	0.166900542660425	false	false	false	true
7c91639a-3637-410f-8de7-cb9a4ad7fbfe	2026-10-02 13:24	2026-10-02 13:24	2026-10-02 13:24	SPY	SPY261002P00768000	put	768.0000	2026-10-02	0.6000	0.5900	0.6100	768.0000	15960.00	15900.00	0.00	266	7	460922	3948	116.748226950355	0.178906986543058	0.178906986543058	false	false	false	true
2e955017-3293-4e29-ad75-3e1cc16fca53	2026-10-02 13:24	2026-10-02 13:24	2026-10-02 13:24	SPY	SPY261002C00769000	call	769.0000	2026-10-02	0.7900	0.7800	0.7900	768.0000	72364.00	72364.00	0.00	916	23	274871	5858	46.9223284397405	0.167259796076519	0.165479696541972	true	false	false	true
b8896765-2b53-43c5-9316-7098d16311dc	2026-10-02 13:24	2026-10-02 13:24	2026-10-02 13:24	SPY	SPY261005P00769000	put	769.0000	2026-10-05	2.5300	2.5200	2.5400	768.0000	101200.00	45287.00	0.00	400	7	46638	1739	26.8188614146061	0.0910228590455584	0.0910228590455584	false	false	false	true
af5915d9-17c4-4422-b24b-896e78b69279	2026-10-02 13:24	2026-10-02 13:24	2026-10-02 13:24	SPY	SPY261005C00773000	call	773.0000	2026-10-05	0.7800	0.7800	0.7900	768.0000	15600.00	0.00	15600.00	200	10	29526	1644	17.9598540145985	0.0800640141064708	0.0800640141064708	false	false	false	true
fd79ffce-a024-43c0-8762-f745c9bfbf20	2026-10-02 13:24	2026-10-02 13:24	2026-10-02 13:24	SPY	SPY261005C00770000	call	770.0000	2026-10-05	1.8600	1.8600	1.8700	768.0000	18600.00	0.00	18600.00	100	9	45920	3563	12.8880157170923	0.0836474381812374	0.0836474381812374	false	false	false	true
5a3fa028-cfc1-497a-a895-72695c879295	2026-10-02 13:24	2026-10-02 13:24	2026-10-02 13:24	SPY	SPY261106P00765000	put	765.0000	2026-11-06	10.2000	10.1500	10.2000	768.7500	62220.00	62220.00	0.00	61	5	2006	469	4.2771855010661	0.1409974960493	0.140819989675237	true	false	false	true
948c425d-386a-47a3-afec-c16552036dc9	2026-10-02 13:24	2026-10-02 13:23	2026-10-02 13:23	SPY	SPY261005C00770000	call	770.0000	2026-10-05	1.9100	1.9000	1.9100	768.8300	34380.00	34380.00	0.00	180	7	45647	3563	12.811394891945	0.0840380351917349	0.0840380351917349	false	false	false	true
f1dd6b8c-8074-49ca-81c6-2cc3fe39edf5	2026-10-02 13:23	2026-10-02 13:23	2026-10-02 13:23	SPY	SPY261002C00769000	call	769.0000	2026-10-02	0.8500	0.8500	0.8600	768.9800	35275.00	0.00	35275.00	415	8	271274	5858	46.3082963468761	0.161778273725066	0.161778273725066	false	false	false	true
7f92ce6e-89c4-42b3-836f-0dfefe269dbb	2026-10-02 13:23	2026-10-02 13:23	2026-10-02 13:23	SPY	SPY261002C00770000	call	770.0000	2026-10-02	0.4600	0.4500	0.4600	769.0750	13800.00	13800.00	0.00	300	5	489015	18665	26.1995713903027	0.158441248527855	0.158441248527855	false	false	false	true
74ac71a1-6b86-47e0-be3e-ac1f1975e29e	2026-10-02 13:23	2026-10-02 13:23	2026-10-02 13:23	SPY	SPY261030C00785000	call	785.0000	2026-10-30	4.7600	4.7400	4.7600	769.1000	23800.00	23800.00	0.00	50	5	867	11137	0.0778486127323337	0.117758236343233	0.117758236343233	false	false	false	true
15217c81-aed5-450e-bb6c-984824a2be08	2026-10-02 13:23	2026-10-02 13:23	2026-10-02 13:23	SPY	SPY270617P00600000	put	600.0000	2027-06-17	7.3000	7.2800	7.3000	769.1400	145270.00	145270.00	0.00	199	9	473	7255	0.0651964162646451	0.263820828186896	0.263820828186896	false	false	false	true
ade72095-c679-4b94-8c55-74c0bde72736	2026-10-02 13:23	2026-10-02 13:22	2026-10-02 13:22	SPY	SPY261002C00769000	call	769.0000	2026-10-02	0.9000	0.8900	0.9100	769.0675	11880.00	2070.00	9810.00	132	7	269626	5858	46.0269716626835	0.161151709586147	0.162368836710263	true	false	false	true