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

da71d928-e57e-44e4-a7f6-c6f2f596929a	2026-10-02 14:28	2026-10-02 14:28	2026-10-02 14:28	SPY	SPY261005P00769000	put	769.0000	2026-10-05	2.2800	2.2700	2.3000	768.8700	231191.00	0.00	231191.00	1014	28	58292	1739	33.5204140310523	0.0842527356738111	0.0838930169557884	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	817569476132.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-10-02T18:32:38.589422Z"}	2026-10-02	2026-10-02 21:15	2026-10-02 21:15
2247ece1-6909-41ce-8c01-0abd4ed9953d	2026-10-02 14:28	2026-10-02 14:28	2026-10-02 14:28	SPY	SPY261005C00771000	call	771.0000	2026-10-05	1.2800	1.2800	1.2900	768.8700	71552.00	0.00	71552.00	559	16	45182	2095	21.5665871121718	0.0748453467062796	0.0748453467062796	false	false	false	true
1abd3aa4-6f8a-4380-b96f-d13333dd546a	2026-10-02 14:28	2026-10-02 14:28	2026-10-02 14:28	SPY	SPY261005C00769000	call	769.0000	2026-10-05	2.2200	2.2200	2.2300	768.8700	76368.00	0.00	76368.00	344	5	34795	1938	17.9540763673891	0.0775412872590292	0.0775412872590292	false	false	false	true
5deaedad-964d-4072-8a3f-14fdf4b2813a	2026-10-02 14:28	2026-10-02 14:28	2026-10-02 14:28	SPY	SPY261005P00767000	put	767.0000	2026-10-05	1.5400	1.5400	1.5500	768.7850	10780.00	0.00	10780.00	70	7	25241	1195	21.1221757322176	0.0873308377355997	0.0873308377355997	false	false	false	true
337d6686-8346-4f80-b954-f5dde7db39e9	2026-10-02 14:28	2026-10-02 14:28	2026-10-02 14:28	SPY	SPY261002P00770000	put	770.0000	2026-10-02	1.5000	1.5000	1.5200	768.7100	73650.00	0.00	73650.00	491	5	489185	4172	117.254314477469	0.165254259952294	0.165254259952294	true	false	false	true
ee1c88f4-344e-471a-8660-3889897be839	2026-10-02 14:27	2026-10-02 14:27	2026-10-02 14:27	SPY	SPY261002P00766000	put	766.0000	2026-10-02	0.1100	0.1100	0.1200	768.5700	10989.00	0.00	10989.00	999	8	318853	4897	65.1119052481111	0.205893783630064	0.205893783630064	false	false	false	true
fb24a0af-486d-417f-b955-cd2d9e6d316b	2026-10-02 14:27	2026-10-02 14:27	2026-10-02 14:27	SPY	SPY261002C00769000	call	769.0000	2026-10-02	0.4500	0.4400	0.4500	768.5200	11113.00	11025.00	88.00	247	14	398770	5858	68.07272106521	0.162603150923443	0.162603150923443	true	false	false	true
8265ab66-ffbc-4e15-86f3-c09ee35637ad	2026-10-02 14:27	2026-10-02 14:27	2026-10-02 14:27	SPY	SPY261005P00768000	put	768.0000	2026-10-05	2.0200	2.0100	2.0200	768.5200	16559.00	15554.00	1005.00	82	5	40578	1461	27.7741273100616	0.0859583058704869	0.0859583058704869	false	false	false	true
59af318e-9a4e-4f67-9e44-07b84f093585	2026-10-02 14:27	2026-10-02 14:27	2026-10-02 14:27	SPY	SPY261006C00770000	call	770.0000	2026-10-06	2.3100	2.3200	2.3300	768.5200	11562.00	0.00	11562.00	50	5	6889	2074	3.32160077145612	0.0885006683548641	0.0885006683548641	true	false	false	true
0d0cba51-cae9-4d04-937e-85a0dc73399c	2026-10-02 14:27	2026-10-02 14:27	2026-10-02 14:27	SPY	SPY261002P00769000	put	769.0000	2026-10-02	0.9400	0.9300	0.9400	768.5200	13905.00	13254.00	651.00	148	7	724376	3044	237.968462549277	0.166480222554439	0.166495108711914	false	false	false	true
3571d52c-4e79-4e04-9f0b-567fb56bcea3	2026-10-02 14:27	2026-10-02 14:27	2026-10-02 14:27	SPY	SPY261030P00765000	put	765.0000	2026-10-30	8.6500	8.6300	8.6500	768.5450	13840.00	13840.00	0.00	16	8	3088	4106	0.752070141256697	0.134382986415908	0.134382986415908	false	false	false	true
029fbc77-210b-4638-a584-b1c4df4e0d13	2026-10-02 14:27	2026-10-02 14:27	2026-10-02 14:27	SPY	SPY261009C00775000	call	775.0000	2026-10-09	2.0500	2.0500	2.0600	768.6700	20500.00	0.00	20500.00	100	5	9946	11236	0.885190459238163	0.101429579311603	0.101429579311603	true	false	false	true
48fa5764-99a7-4e5f-ab22-e65e78427fa4	2026-10-02 14:27	2026-10-02 14:27	2026-10-02 14:27	SPY	SPY261002C00768000	call	768.0000	2026-10-02	1.1200	1.1400	1.1600	768.7500	12441.00	0.00	12441.00	111	5	141305	9985	14.1517275913871	0.161416448957691	0.168912482293998	true	false	false	true
9de7b34e-9c7d-4599-bc12-a515251bc733	2026-10-02 14:26	2026-10-02 14:26	2026-10-02 14:26	SPY	SPY261002P00769000	put	769.0000	2026-10-02	0.7700	0.7600	0.7700	768.8050	23480.00	23100.00	380.00	305	7	722526	3044	237.360709592641	0.164173635767907	0.164173635767907	false	false	false	true
9c06285c-bec3-412b-b23a-d082c6bbd7f4	2026-10-02 14:26	2026-10-02 14:26	2026-10-02 14:26	SPY	SPY261002P00768000	put	768.0000	2026-10-02	0.3700	0.3600	0.3700	768.8300	12160.00	10360.00	1800.00	330	5	619055	3948	156.802178318136	0.173997398820224	0.171276475539944	false	false	false	true
86afe66c-51a9-4853-b83d-d3de7a399d6e	2026-10-02 14:26	2026-10-02 14:26	2026-10-02 14:26	SPY	SPY261120P00750000	put	750.0000	2026-11-20	8.2900	8.2700	8.2900	768.7900	35647.00	35647.00	0.00	43	5	5652	41039	0.137722654060771	0.157282612213149	0.157282612213149	false	false	false	true
002493a1-2775-4c1b-8e9f-d31d681c9319	2026-10-02 14:26	2026-10-02 14:26	2026-10-02 14:26	SPY	SPY261120P00750000	put	750.0000	2026-11-20	8.2800	8.2800	8.2900	768.8000	41400.00	0.00	8280.00	50	5	5609	41039	0.136674870245376	0.157208881400019	0.157208881400019	false	false	false	true
7f8c043d-2b79-444b-bb6d-dc1be0582d1a	2026-10-02 14:26	2026-10-02 14:26	2026-10-02 14:26	SPY	SPY261002P00770000	put	770.0000	2026-10-02	1.3800	1.3800	1.3900	768.8300	69691.00	139.00	69552.00	505	5	487994	4172	116.968839884947	0.159758195478076	0.158129831566428	false	false	false	true
62202c73-b0d7-4e7c-929d-dd9c54206abc	2026-10-02 14:26	2026-10-02 14:26	2026-10-02 14:26	SPY	SPY261002C00769000	call	769.0000	2026-10-02	0.5600	0.5600	0.5700	768.8300	19218.00	570.00	18648.00	343	15	395116	5858	67.4489586889723	0.155938954511533	0.15839258695075	false	false	false	true
9c989a15-23d5-43f5-bd32-db8686ac3153	2026-10-02 14:26	2026-10-02 14:25	2026-10-02 14:25	SPY	SPY261005C00772000	call	772.0000	2026-10-05	0.9000	0.9000	0.9100	768.7700	61380.00	0.00	61380.00	682	17	45196	1312	34.4481707317073	0.0736919099503548	0.0736919099503548	false	false	false	true
78cd97b0-19a4-4e93-a6a7-8c1deab0970b	2026-10-02 14:25	2026-10-02 14:25	2026-10-02 14:25	SPY	SPY261002C00769000	call	769.0000	2026-10-02	0.5400	0.5300	0.5500	768.7695	13458.00	768.00	7776.00	249	11	393969	5858	67.2531580744281	0.156479892771545	0.157412142570033	false	false	false	true
c54a9df4-746f-4500-8752-02297d7affe4	2026-10-02 14:25	2026-10-02 14:25	2026-10-02 14:25	SPY	SPY261002C00768000	call	768.0000	2026-10-02	1.1500	1.1500	1.1600	768.7800	10236.00	116.00	10120.00	89	7	140477	9985	14.0688032048072	0.169980394580272	0.16728248132086	false	false	false	true
6618b5f3-b44a-4e32-87a9-153a8f34e4c7	2026-10-02 14:25	2026-10-02 14:25	2026-10-02 14:25	SPY	SPY261002C00769000	call	769.0000	2026-10-02	0.5500	0.5400	0.5500	768.7950	11978.00	11330.00	648.00	218	10	393354	5858	67.1481734380335	0.156892794355035	0.156892794355035	false	false	false	true
aea54199-6e23-40d7-9770-03c76e086e48	2026-10-02 14:25	2026-10-02 14:25	2026-10-02 14:25	SPY	SPY261002C00768000	call	768.0000	2026-10-02	1.1600	1.1500	1.1700	768.8100	28189.00	28189.00	0.00	243	5	140342	9985	14.0552829243866	0.164360288832848	0.16708860660735	true	false	false	true
ab7fd5b7-d1b7-434b-9d03-eef709da4b1d	2026-10-02 14:25	2026-10-02 14:25	2026-10-02 14:25	SPY	SPY261005P00765000	put	765.0000	2026-10-05	1.0100	1.0100	1.0200	768.7600	30300.00	0.00	30300.00	300	19	47559	2714	17.5235814296242	0.0910903609929654	0.0910903609929654	true	false	false	true
1572822c-dde8-4c51-b8af-5a1efac4d86b	2026-10-02 14:25	2026-10-02 14:25	2026-10-02 14:25	SPY	SPY261002C00769000	call	769.0000	2026-10-02	0.5400	0.5400	0.5500	768.7650	13923.00	2475.00	11448.00	257	5	391927	5858	66.9045749402526	0.157539501937235	0.159993719628529	false	false	false	true
ba059f88-4faa-4b94-b94a-c0ec985b2f9b	2026-10-02 14:25	2026-10-02 14:25	2026-10-02 14:25	SPY	SPY261002P00769000	put	769.0000	2026-10-02	0.8000	0.7700	0.8100	768.7700	50512.00	937.00	49575.00	635	16	720389	3044	236.658672798949	0.164300672739335	0.160754965435642	true	false	false	true
30a8448a-62ec-4482-9a3c-38a9334a89e8	2026-10-02 14:25	2026-10-02 14:25	2026-10-02 14:25	SPY	SPY261005P00766000	put	766.0000	2026-10-05	1.2700	1.2700	1.2800	768.6750	31750.00	0.00	31750.00	250	10	26909	1919	14.0224075039083	0.0887581571251167	0.0887581571251167	true	false	false	true
d0e0c4d0-de0f-463c-8f29-6c15cc64369e	2026-10-02 14:25	2026-10-02 14:25	2026-10-02 14:25	SPY	SPY261002P00765000	put	765.0000	2026-10-02	0.0600	0.0600	0.0700	768.6600	12000.00	0.00	12000.00	2000	14	417109	11850	35.1990717299578	0.228183805370696	0.228183805370696	true	false	false	true
47e00456-7abb-4943-9c3b-ccb1e153f7c4	2026-10-02 14:25	2026-10-02 14:25	2026-10-02 14:25	SPY	SPY261002P00771000	put	771.0000	2026-10-02	2.4100	2.4100	2.4200	768.6400	18075.00	0.00	18075.00	75	6	306599	1555	197.169774919614	0.158648842943515	0.158648842943515	false	false	false	true
8c56f7d7-a76e-4239-ad98-85fc2ae57b29	2026-10-02 14:24	2026-10-02 14:24	2026-10-02 14:24	SPY	SPY261005P00766000	put	766.0000	2026-10-05	1.3000	1.3000	1.3100	768.6000	32500.00	0.00	32500.00	250	8	26632	1919	13.8780614903596	0.089004067953468	0.089004067953468	true	false	false	true
0cbf5afe-cee7-43d5-833c-2f653ffdc67b	2026-10-02 14:24	2026-10-02 14:24	2026-10-02 14:24	SPY	SPY261009C00785000	call	785.0000	2026-10-09	0.2900	0.2800	0.2900	768.6000	78909.00	78909.00	0.00	2721	28	24925	104934	0.237530257113995	0.0965424394736271	0.0965424394736271	false	false	false
ecb18ca8-4938-4568-b4db-ffa88bc197c0	2026-10-02 14:24	2026-10-02 14:24	2026-10-02 14:24	SPY	SPY261002C00768000	call	768.0000	2026-10-02	1.0300	1.0200	1.0300	768.5800	24720.00	24720.00	0.00	240	13	139128	9985	13.9337005508262	0.172351948963437	0.16914386415297	false	false	false	true
637165e4-c93e-4228-a40f-115279db4527	2026-10-02 14:24	2026-10-02 14:24	2026-10-02 14:24	SPY	SPY261002C00767000	call	767.0000	2026-10-02	1.7900	1.7800	1.7900	768.5600	89500.00	89500.00	0.00	500	8	53419	8148	6.55608738340697	0.185538748477435	0.185538748477435	false	false	false	true
1099273d-2205-4a2c-8e5d-7895fa2ac73c	2026-10-02 14:24	2026-10-02 14:24	2026-10-02 14:24	SPY	SPY261002C00769000	call	769.0000	2026-10-02	0.4800	0.4700	0.4800	768.5800	17616.00	17616.00	0.00	367	17	390106	5858	66.5937179924889	0.163372422490081	0.161369569463387	false	false	false	true
fa99cd89-e26b-45ba-8583-c555393d4aba	2026-10-02 14:24	2026-10-02 14:24	2026-10-02 14:24	SPY	SPY261005P00768000	put	768.0000	2026-10-05	1.9700	1.9600	1.9800	768.6000	19090.00	15366.00	3724.00	97	5	39978	1461	27.3634496919918	0.085432405865943	0.0850687109923245	true	false	false	true
e0ed00c6-491c-4b77-ae0a-4117932493c3	2026-10-02 14:24	2026-10-02 14:24	2026-10-02 14:24	SPY	SPY261005C00772000	call	772.0000	2026-10-05	0.8600	0.8500	0.8700	768.5500	18662.00	18576.00	0.00	217	9	44046	1312	33.5716463414634	0.0745887507384817	0.0745887507384817	true	false	false	true
f2986437-d3b6-4265-92c3-abd837366324	2026-10-02 14:24	2026-10-02 14:24	2026-10-02 14:24	SPY	SPY261005P00768000	put	768.0000	2026-10-05	2.0000	1.9900	2.0000	768.5500	20000.00	20000.00	0.00	100	5	39859	1461	27.2819986310746	0.0857177156997788	0.0857177156997788	false	false	false	true
6f854a64-9061-476e-a5e9-2ea8e7bbde6c	2026-10-02 14:23	2026-10-02 14:23	2026-10-02 14:23	SPY	SPY261002P00768000	put	768.0000	2026-10-02	0.4800	0.4800	0.4900	768.5500	13200.00	0.00	13200.00	275	6	611802	3948	154.965045592705	0.174662748907374	0.174662748907374	false	false	false	true
c718e1f5-7431-466c-a289-f20089e49b1d	2026-10-02 14:23	2026-10-02 14:23	2026-10-02 14:23	SPY	SPY261030P00765000	put	765.0000	2026-10-30	8.6500	8.6300	8.6700	768.5200	248255.00	14705.00	233550.00	287	7	3052	4106	0.743302484169508	0.13440777705914	0.134258993253834	true	false	false	true
b46ae7fa-861c-4f30-8b0a-3cb891ab5837	2026-10-02 14:23	2026-10-02 14:23	2026-10-02 14:23	SPY	SPY261014P00769000	put	769.0000	2026-10-14	6.0500	6.0400	6.0500	768.5200	635250.00	635250.00	0.00	1050	8	15479	1	15479	0.113973275939944	0.113713016213764	true	false	false	true
e14ba244-72ab-46a0-b8a2-17d4835a9425	2026-10-02 14:23	2026-10-02 14:23	2026-10-02 14:23	SPY	SPY261002P00768000	put	768.0000	2026-10-02	0.4700	0.4700	0.4800	768.5600	12085.00	288.00	11797.00	257	13	610076	3948	154.527862208713	0.170955804074291	0.175393811500287	false	false	false	true
38846d08-68c3-4c49-a3d9-fa22bf90792f	2026-10-02 14:23	2026-10-02 14:23	2026-10-02 14:23	SPY	SPY261002P00768000	put	768.0000	2026-10-02	0.4300	0.4300	0.4400	768.6600	18920.00	0.00	18920.00	440	6	609193	3948	154.304204660588	0.171890030322339	0.171890030322339	false	false	false	true
2e7557d8-cb79-49c8-8127-23015dd7a404	2026-10-02 14:23	2026-10-02 14:23	2026-10-02 14:23	SPY	SPY261002P00768000	put	768.0000	2026-10-02	0.4400	0.4300	0.4500	768.6150	17162.00	11737.00	5425.00	386	34	609600	3948	154.407294832827	0.174482103220244	0.170327628295903	true	false	false	true
7784c061-59aa-4cdb-9e47-a5e6b0eb671c	2026-10-02 14:23	2026-10-02 14:23	2026-10-02 14:23	SPY	SPY261002C00767000	call	767.0000	2026-10-02	1.8600	1.8600	1.8700	768.6600	11904.00	0.00	11904.00	64	8	52530	8148	6.44698085419735	0.180718388212528	0.180718388212528	true	false	false	true
779c49b6-6510-40a6-a299-f07d4ed6692e	2026-10-02 14:23	2026-10-02 14:23	2026-10-02 14:23	SPY	SPY261002P00768000	put	768.0000	2026-10-02	0.4200	0.4000	0.4300	768.7500	12618.00	492.00	12126.00	304	9	607429	3948	153.857396149949	0.172187620219804	0.174500015015524	true	false	false	true
261e1b42-eeeb-48be-a928-f2d2cfffcdd1	2026-10-02 14:23	2026-10-02 14:23	2026-10-02 14:23	SPY	SPY261002P00768000	put	768.0000	2026-10-02	0.4000	0.4000	0.4200	768.7100	10842.00	0.00	10842.00	271	6	607755	3948	153.939969604863	0.170951020963884	0.168342817731946	false	false	false	true
f95e9fdb-e21e-42d4-8753-1b0f9c0a428b	2026-10-02 14:23	2026-10-02 14:23	2026-10-02 14:23	SPY	SPY261002P00769000	put	769.0000	2026-10-02	0.8800	0.8700	0.8900	768.6200	14872.00	4136.00	10736.00	169	8	715126	3044	234.929697766097	0.162395933041637	0.162395933041637	false	false	false	true
6b23c281-8881-4314-a0e3-59e0ec24f605	2026-10-02 14:23	2026-10-02 14:22	2026-10-02 14:22	SPY	SPY261002P00769000	put	769.0000	2026-10-02	0.8300	0.8300	0.8400	768.6900	11538.00	84.00	11454.00	139	5	714380	3044	234.684625492773	0.16001452262552	0.16001452262552	false	false	false	true
59436335-d24f-4525-bc01-78f391882cbc	2026-10-02 14:23	2026-10-02 14:22	2026-10-02 14:22	SPY	SPY261002P00768000	put	768.0000	2026-10-02	0.4400	0.4400	0.4500	768.6300	11535.00	315.00	11220.00	262	13	605832	3948	153.452887537994	0.171189686574917	0.171189686574917	false	false	false	true