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 = SPXW×

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

23b061fa-9f5c-4ba5-98b8-c07c092ce878	2026-09-28 15:47	2026-09-28 15:47	2026-09-28 15:47	SPXW	SPXW260928P07700000	put	7700.0000	2026-09-28	14.8000	14.8000	15.1000	7685.1600	37000.00	0.00	37000.00	25	8	116840	3222	36.2631905648665	0.258373687001991	0.234309249493695	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	—	—	—	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-28T19:53:15.788869Z"}	2026-09-28	2026-09-28 21:15	2026-09-28 21:15
ed6cf177-448d-46f4-96e6-14f97129cb58	2026-09-28 15:47	2026-09-28 15:47	2026-09-28 15:47	SPXW	SPXW261002P07650000	put	7650.0000	2026-10-02	29.5000	29.4000	29.6000	7684.9500	35400.00	0.00	17700.00	12	9	1367	2542	0.537765538945712	0.144176649677928	0.144176649677928	false	false	false	true
5bd425ca-28e0-4929-961c-5f09190cb43b	2026-09-28 15:47	2026-09-28 15:47	2026-09-28 15:47	SPXW	SPXW261130P06500000	put	6500.0000	2026-11-30	17.6000	17.5000	17.8000	7684.9500	14080.00	0.00	14080.00	8	5	45	5582	0.00806162665711215	0.262132583680759	0.262132583680759	false	false	false	true
e903e8fb-7979-4207-93fa-45da8486f47c	2026-09-28 15:47	2026-09-28 15:47	2026-09-28 15:47	SPXW	SPXW260928C07690000	call	7690.0000	2026-09-28	1.5000	1.4500	1.5500	7685.6000	17100.00	0.00	13050.00	114	18	77158	402	191.935323383085	0.213023372636027	0.213023372636027	false	false	false	true
d1c9198f-6498-4acf-aa9a-53a8170da8b8	2026-09-28 15:47	2026-09-28 15:47	2026-09-28 15:47	SPXW	SPXW261005P07600000	put	7600.0000	2026-10-05	21.6000	21.5000	21.7000	7685.4600	15120.00	4320.00	0.00	7	7	573	1851	0.309562398703404	0.132189012251873	0.132144346409563	false	false	false	true
c0b3a8f1-8a93-4609-9112-955a5270e326	2026-09-28 15:47	2026-09-28 15:46	2026-09-28 15:47	SPXW	SPXW261005P07600000	put	7600.0000	2026-10-05	21.6000	21.5000	21.7000	7685.5500	34560.00	2160.00	0.00	16	13	566	1851	0.305780659103187	0.132211342946332	0.132211342946332	false	false	false	true
fcfed523-1346-4ed2-bcf2-67f8b51fec84	2026-09-28 15:46	2026-09-28 15:46	2026-09-28 15:46	SPXW	SPXW260928P07690000	put	7690.0000	2026-09-28	5.8900	5.8000	6.0000	7685.8500	10610.00	3540.00	580.00	18	6	109802	1292	84.9860681114551	0.221688133699971	0.221688133699971	false	false	false	true
ff9fcc87-b32b-430f-8af0-8ccec69e8f79	2026-09-28 15:46	2026-09-28 15:46	2026-09-28 15:46	SPXW	SPXW260928P07685000	put	7685.0000	2026-09-28	3.0000	2.9500	3.1000	7684.5700	12300.00	300.00	12000.00	41	23	116144	1431	81.162823200559	0.178843092628252	0.178843092628252	false	false	false	true
7207238c-3615-420f-a89a-36765ecbad8e	2026-09-28 15:46	2026-09-28 15:46	2026-09-28 15:46	SPXW	SPXW261005C07775000	call	7775.0000	2026-10-05	16.6000	16.5000	16.8000	7684.9200	19920.00	1660.00	14940.00	12	8	972	212	4.58490566037736	0.110548127041658	0.110548127041658	false	false	false	true
a252ef9c-0b26-4e9f-a0f0-5059833fb89b	2026-09-28 15:46	2026-09-28 15:46	2026-09-28 15:46	SPXW	SPXW260928C07685000	call	7685.0000	2026-09-28	3.5000	3.4000	3.6000	7685.2100	36050.00	0.00	33600.00	103	6	47911	138	347.18115942029	0.216169099458079	0.216169099458079	false	false	false	true
bf192e3a-c259-4408-9be4-5f96f280716f	2026-09-28 15:46	2026-09-28 15:46	2026-09-28 15:46	SPXW	SPXW260929C07690000	call	7690.0000	2026-09-29	19.8000	19.8000	20.0000	7685.1600	19800.00	0.00	19800.00	10	6	2917	113	25.8141592920354	0.13541151188185	0.13541151188185	false	false	false	true
05b6956a-7f96-49f6-aed4-5f05fd0378bf	2026-09-28 15:46	2026-09-28 15:46	2026-09-28 15:46	SPXW	SPXW260928P07685000	put	7685.0000	2026-09-28	3.2000	3.0000	3.3000	7685.3100	12480.00	12160.00	0.00	39	6	115905	1431	80.9958071278826	0.213025177533886	0.213152855519703	false	false	false	true
476c4049-2f9e-4190-a0e0-46c1c1c9516b	2026-09-28 15:45	2026-09-28 15:45	2026-09-28 15:45	SPXW	SPXW260929C07685000	call	7685.0000	2026-09-29	22.0000	21.9000	22.0000	7683.9100	17600.00	17600.00	0.00	8	5	2417	66	36.6212121212121	0.137855400281603	0.137855400281603	false	false	false	true
0c3e4008-6b5f-4671-81c1-70482ddea0a5	2026-09-28 15:45	2026-09-28 15:45	2026-09-28 15:45	SPXW	SPXW260930P07400000	put	7400.0000	2026-09-30	0.6500	0.6000	0.7000	7684.2800	16250.00	8710.00	4290.00	250	12	740	10296	0.0718725718725719	0.23358666322471	0.23358666322471	false	false	false	true
aa4b9071-b9d3-4f6e-950c-6eccdff491d7	2026-09-28 15:45	2026-09-28 15:45	2026-09-28 15:45	SPXW	SPXW260929P07650000	put	7650.0000	2026-09-29	9.0400	8.8000	9.0000	7684.0300	1356000.00	0.00	0.00	1500	6	7707	2886	2.67047817047817	0.139093234607005	0.139093234607005	false	false	false	true
6c8b7b76-81f4-4b1c-937c-0d196ddc9b3b	2026-09-28 15:45	2026-09-28 15:45	2026-09-28 15:45	SPXW	SPXW260929P07700000	put	7700.0000	2026-09-29	28.5200	28.1000	28.3000	7684.0300	2852000.00	0.00	0.00	1000	6	8208	3364	2.43995243757432	0.124905128081834	0.124905128081834	false	false	false	true
2bf69e35-7f19-42de-a4f6-97f5a8973e8d	2026-09-28 15:44	2026-09-28 15:44	2026-09-28 15:44	SPXW	SPXW260928P07685000	put	7685.0000	2026-09-28	4.1000	4.1000	4.2000	7682.9300	12300.00	0.00	12300.00	30	7	115109	1431	80.4395527603075	0.17681320338052	0.17681320338052	false	false	false	true
096fdaac-7f1d-43cf-a13f-a4f7a4b6b9dc	2026-09-28 15:44	2026-09-28 15:44	2026-09-28 15:44	SPXW	SPXW260928C07690000	call	7690.0000	2026-09-28	1.2500	1.2000	1.2500	7682.9300	16125.00	16125.00	0.00	129	7	74635	402	185.6592039801	0.22565505524163	0.22565505524163	false	false	false	true
10f313f4-1571-414e-8d5f-af507601ec56	2026-09-28 15:44	2026-09-28 15:44	2026-09-28 15:44	SPXW	SPXW260928P07685000	put	7685.0000	2026-09-28	4.4000	4.3000	4.5000	7682.8600	47520.00	45320.00	0.00	108	11	114976	1431	80.3466107617051	0.191676691981526	0.191777394192795	false	false	false	true
2b20e447-4082-4c7c-a795-f84203d6edeb	2026-09-28 15:44	2026-09-28 15:44	2026-09-28 15:44	SPXW	SPXW260928P07685000	put	7685.0000	2026-09-28	4.3000	4.3000	4.4000	7682.8700	12900.00	0.00	12900.00	30	6	114835	1431	80.2480782669462	0.185594843007474	0.185594843007474	false	false	false	true
85db2475-24a5-4012-a884-5dab7c628838	2026-09-28 15:44	2026-09-28 15:44	2026-09-28 15:44	SPXW	SPXW260928P07690000	put	7690.0000	2026-09-28	7.7000	7.6000	7.8000	7683.2300	19250.00	8470.00	8470.00	25	7	109294	1292	84.5928792569659	0.192980452795576	0.192980452795576	false	false	false	true
2430a993-c471-4287-a291-8ae548ddb8ee	2026-09-28 15:44	2026-09-28 15:43	2026-09-28 15:43	SPXW	SPXW260928P07680000	put	7680.0000	2026-09-28	2.0000	1.9500	2.0500	7683.4700	11395.00	5800.00	5595.00	57	15	147247	1391	105.856937455068	0.205071556270834	0.204631359769267	false	false	false	true
7f1d7a10-bd72-413d-be8f-7374a41fff39	2026-09-28 15:43	2026-09-28 15:43	2026-09-28 15:43	SPXW	SPXW260928P07685000	put	7685.0000	2026-09-28	3.8000	3.7000	3.8000	7684.3800	11400.00	11400.00	0.00	30	6	114564	1431	80.0587002096436	0.204516999886755	0.204516999886755	false	false	false	true
a3f47234-114f-4229-87a3-eb218e06922a	2026-09-28 15:43	2026-09-28 15:43	2026-09-28 15:43	SPXW	SPXW260928C07685000	call	7685.0000	2026-09-28	3.7000	3.6000	3.8000	7684.1000	11100.00	9990.00	370.00	30	12	45699	138	331.152173913043	0.240676348849265	0.240676348849265	false	false	false	true
5d94b977-91bf-4d10-a9d7-4f1484f68d79	2026-09-28 15:43	2026-09-28 15:43	2026-09-28 15:43	SPXW	SPXW260928P07685000	put	7685.0000	2026-09-28	3.4000	3.4000	3.5000	7684.5800	12930.00	350.00	12580.00	38	10	114406	1431	79.9482879105521	0.170948843806335	0.185936407505521	false	false	false	true
1cc33ce9-9ce7-4fae-bc8d-fb6d87de334a	2026-09-28 15:43	2026-09-28 15:43	2026-09-28 15:43	SPXW	SPXW260928P07685000	put	7685.0000	2026-09-28	4.1000	4.1000	4.2000	7683.6100	12300.00	0.00	12300.00	30	6	114177	1431	79.7882599580713	0.194829448776064	0.194829448776064	false	false	false	true
5d6e8b5e-e103-4863-8f32-8e393f28e2a5	2026-09-28 15:43	2026-09-28 15:43	2026-09-28 15:43	SPXW	SPXW260928P07685000	put	7685.0000	2026-09-28	4.2000	4.0000	4.2000	7683.3300	42000.00	42000.00	0.00	100	18	114142	1431	79.7638015373864	0.191098314193572	0.191098314193572	false	false	false	true
480ef38c-8baa-4eb5-ab8f-83fa4da928b9	2026-09-28 15:43	2026-09-28 15:43	2026-09-28 15:43	SPXW	SPXW260928C07680000	call	7680.0000	2026-09-28	5.5000	5.4000	5.6000	7683.6300	17050.00	0.00	3850.00	31	5	40973	759	53.9828722002635	0.195016098142227	0.195016098142227	false	false	false	true
464ca33d-fe05-4176-ae17-de98446f49e9	2026-09-28 15:43	2026-09-28 15:43	2026-09-28 15:43	SPXW	SPXW260928C07680000	call	7680.0000	2026-09-28	5.7000	5.7000	5.9000	7683.8100	12540.00	0.00	12540.00	22	5	40937	759	53.935441370224	0.199880662217074	0.199880662217074	false	false	false	true
edde5fa8-06c1-4825-a701-a88c8e2d25ca	2026-09-28 15:43	2026-09-28 15:43	2026-09-28 15:43	SPXW	SPXW260928P07700000	put	7700.0000	2026-09-28	15.5000	15.5000	15.7000	7684.4000	80600.00	0.00	80600.00	52	7	116578	3222	36.1818746120422	0.194562655745085	0.139493449495618	false	false	false	true
e72b7ada-bb72-40fe-bd9c-7b8b7b2ceb8c	2026-09-28 15:43	2026-09-28 15:43	2026-09-28 15:43	SPXW	SPXW260928P07685000	put	7685.0000	2026-09-28	3.8000	3.7000	3.9000	7684.5300	10260.00	3420.00	6840.00	27	9	113808	1431	79.5303983228512	0.204483817668834	0.204483817668834	false	false	false	true
9444b387-8706-4274-86c0-e630b022f551	2026-09-28 15:43	2026-09-28 15:43	2026-09-28 15:43	SPXW	SPXW260928C07685000	call	7685.0000	2026-09-28	3.4000	3.3000	3.5000	7684.3500	12570.00	7820.00	4410.00	37	17	45299	138	328.253623188406	0.207927126811393	0.212854290158916	false	false	false	true
eadbbd96-11db-46af-a2e2-ba52118cbef4	2026-09-28 15:42	2026-09-28 15:42	2026-09-28 15:42	SPXW	SPXW260928C07685000	call	7685.0000	2026-09-28	3.2000	3.1000	3.2000	7683.6400	11200.00	11200.00	0.00	35	19	44843	138	324.949275362319	0.218807463651225	0.218807463651225	false	false	false	true
ddb2f4a3-34ad-4fa0-b98e-3a0abe44fd9a	2026-09-28 15:42	2026-09-28 15:42	2026-09-28 15:42	SPXW	SPXW260929C07685000	call	7685.0000	2026-09-29	22.0000	21.9000	22.0000	7683.6400	19800.00	19800.00	0.00	9	5	2353	66	35.6515151515151	0.138694702733913	0.138694702733913	false	false	false	true
2e32803c-f6de-4822-a8a6-8e4325dbb5cb	2026-09-28 15:42	2026-09-28 15:42	2026-09-28 15:42	SPXW	SPXW260928C07680000	call	7680.0000	2026-09-28	6.0000	5.9000	6.1000	7683.3500	10800.00	8400.00	1800.00	18	7	40697	759	53.6192358366271	0.234037102689043	0.234037102689043	false	false	false	true
6ea5b31d-a36a-4c86-b7f4-5dfbf191f772	2026-09-28 15:42	2026-09-28 15:42	2026-09-28 15:42	SPXW	SPXW260928C07685000	call	7685.0000	2026-09-28	3.1000	3.0000	3.2000	7683.3500	11160.00	9300.00	0.00	36	9	44796	138	324.608695652174	0.220272019507189	0.220272019507189	false	false	false	true
2023c655-51dd-4969-9006-788fbbb5caa7	2026-09-28 15:42	2026-09-28 15:42	2026-09-28 15:42	SPXW	SPXW260928C07685000	call	7685.0000	2026-09-28	2.9500	2.9500	3.1000	7683.2900	10325.00	0.00	10325.00	35	14	44738	138	324.188405797101	0.21287935896943	0.21287935896943	false	false	false	true
5e74804e-31b9-484c-84ce-bb1fd7474392	2026-09-28 15:42	2026-09-28 15:42	2026-09-28 15:42	SPXW	SPXW260928C07680000	call	7680.0000	2026-09-28	5.6000	5.5000	5.7000	7683.3200	14000.00	10080.00	0.00	25	9	40644	759	53.5494071146245	0.210278015440383	0.210278015440383	false	false	false	true
ffbea795-c38e-42c5-baac-e742d7f3a8f8	2026-09-28 15:42	2026-09-28 15:42	2026-09-28 15:42	SPXW	SPXW260928C07680000	call	7680.0000	2026-09-28	6.0000	5.9000	6.1000	7683.4300	11400.00	10200.00	0.00	19	8	40532	759	53.4018445322793	0.229219482616513	0.229219482616513	false	false	false	true
27e9fa8d-6144-4202-b87a-0aee0cead723	2026-09-28 15:42	2026-09-28 15:42	2026-09-28 15:42	SPXW	SPXW260928C07680000	call	7680.0000	2026-09-28	5.9000	5.8000	6.0000	7683.0800	12980.00	11210.00	0.00	22	11	40511	759	53.3741765480896	0.236166654436618	0.236166654436618	false	false	false	true
70200e32-024b-4c99-afc0-3a02f342f01c	2026-09-28 15:42	2026-09-28 15:42	2026-09-28 15:42	SPXW	SPXW260930C07685000	call	7685.0000	2026-09-30	31.0000	31.0000	31.1000	7682.4100	77500.00	0.00	77500.00	25	7	385	118	3.26271186440678	0.138585395397645	0.138585395397645	false	false	false	true
961c9b7e-2f51-4643-952f-a7e5488e8704	2026-09-28 15:42	2026-09-28 15:42	2026-09-28 15:42	SPXW	SPXW260928C07685000	call	7685.0000	2026-09-28	2.8000	2.7000	2.8000	7682.6000	14000.00	14000.00	0.00	50	10	44350	138	321.376811594203	0.218014291888051	0.218014291888051	false	false	false	true
190e3298-3959-4d52-8718-8b00033c9b4d	2026-09-28 15:42	2026-09-28 15:42	2026-09-28 15:42	SPXW	SPXW260928P07680000	put	7680.0000	2026-09-28	2.6000	2.5500	2.7000	7682.5000	12985.00	4170.00	8815.00	50	8	145143	1391	104.344356578001	0.20877173237178	0.205861677678424	false	false	false	true
04c22ced-9e68-41e3-9751-a871338f5891	2026-09-28 15:42	2026-09-28 15:42	2026-09-28 15:42	SPXW	SPXW260928C07680000	call	7680.0000	2026-09-28	5.5000	5.4000	5.6000	7683.0200	13200.00	0.00	11000.00	24	6	40354	759	53.167325428195	0.212131511967428	0.212131511967428	false	false	false	true
2c45f41c-6ea4-4a96-8dfd-647e27e33b3a	2026-09-28 15:42	2026-09-28 15:42	2026-09-28 15:42	SPXW	SPXW260928P07680000	put	7680.0000	2026-09-28	2.2000	2.1500	2.2500	7682.9000	35860.00	220.00	35640.00	163	12	144884	1391	104.158159597412	0.193338991206846	0.193338991206846	false	false	false	true
d44d0766-d838-4fe9-ada9-219f6f1934ce	2026-09-28 15:42	2026-09-28 15:42	2026-09-28 15:42	SPXW	SPXW260928P07680000	put	7680.0000	2026-09-28	2.3500	2.3000	2.3500	7682.8400	14335.00	14335.00	0.00	61	12	144681	1391	104.012221423436	0.200577946685829	0.200577946685829	false	false	false	true
328679eb-8062-4378-83a3-f85f15c8b76c	2026-09-28 15:42	2026-09-28 15:41	2026-09-28 15:41	SPXW	SPXW260928P07685000	put	7685.0000	2026-09-28	4.8000	4.6000	4.9000	7682.8700	10070.00	0.00	9600.00	21	6	112938	1431	78.9224318658281	0.202587837683271	0.196869980745945	false	false	false	true
c3776af1-349b-468a-a43c-ac008c2107c6	2026-09-28 15:41	2026-09-28 15:41	2026-09-28 15:41	SPXW	SPXW261002P07600000	put	7600.0000	2026-10-02	17.8000	17.6000	17.8000	7683.1300	89000.00	89000.00	0.00	50	9	1716	3965	0.432786885245902	0.155081336267189	0.155081336267189	false	false	false	true
94736c32-cf86-4cef-9a01-054e91c26541	2026-09-28 15:41	2026-09-28 15:41	2026-09-28 15:41	SPXW	SPXW260929P07680000	put	7680.0000	2026-09-29	19.3000	19.3000	19.4000	7682.7700	27020.00	0.00	27020.00	14	5	3197	472	6.77330508474576	0.131307828595909	0.131307828595909	false	false	false	true
7ebef925-4218-43cc-96c7-68447ccca277	2026-09-28 15:41	2026-09-28 15:41	2026-09-28 15:41	SPXW	SPXW261005C07775000	call	7775.0000	2026-10-05	16.5000	16.4000	16.6000	7682.6500	11550.00	1650.00	0.00	7	7	936	212	4.41509433962264	0.111890541260874	0.111890541260874	false	false	false	true