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:option_symbol = SPXW260925P07710000×sorted by created_at ↑×

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

c2d31637-9a13-4427-ae72-04d29d3a0a6e	2026-09-25 11:21	2026-09-25 11:21	2026-09-25 11:21	SPXW	SPXW260925P07710000	put	7710.0000	2026-09-25	7.4000	7.3000	7.5000	7719.1400	15540.00	13320.00	0.00	21	6	33568	1983	16.9278870398386	0.161581129082872	0.161581129082872	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-25T15:25:06.221939Z"}	2026-09-25	2026-09-25 21:15	2026-09-25 21:15
4d3d7f70-5eb8-4f68-8d98-1bf3cab38b85	2026-09-25 11:21	2026-09-25 11:21	2026-09-25 11:21	SPXW	SPXW260925P07710000	put	7710.0000	2026-09-25	7.9000	7.8000	7.9000	7718.3600	39500.00	39500.00	0.00	50	12	33698	1983	16.993444276349	0.16470696769327	0.16470696769327	false	false	false	true
5a835455-cf37-49ca-9e36-f48a268c7637	2026-09-25 11:21	2026-09-25 11:21	2026-09-25 11:21	SPXW	SPXW260925P07710000	put	7710.0000	2026-09-25	7.0100	6.9000	7.1000	7721.5200	14730.00	13340.00	1390.00	21	5	33856	1983	17.0731215330308	0.168561712179027	0.170083643620072	false	false	false	true
ac90c132-6f65-428e-81ed-9a2d1a6fe9b4	2026-09-25 11:21	2026-09-25 11:21	2026-09-25 11:21	SPXW	SPXW260925P07710000	put	7710.0000	2026-09-25	7.2900	7.2000	7.4000	7719.5000	10210.00	0.00	10210.00	14	5	34025	1983	17.1583459404942	0.162301545797022	0.162306354444134	false	false	false	true
0dac5088-bb0c-49d7-bdee-6195d8e75aa3	2026-09-25 11:24	2026-09-25 11:24	2026-09-25 11:24	SPXW	SPXW260925P07710000	put	7710.0000	2026-09-25	8.0000	7.9000	8.0000	7717.9900	10400.00	10400.00	0.00	13	6	34449	1983	17.3721633888048	0.165012371430391	0.165012371430391	false	false	false	true
e8dedc1d-8626-4f8e-b957-fdebbb9d7afb	2026-09-25 11:27	2026-09-25 11:27	2026-09-25 11:27	SPXW	SPXW260925P07710000	put	7710.0000	2026-09-25	7.0000	7.0000	7.1000	7695.0000	21000.00	0.00	21000.00	30	7	34956	1983	17.6278366111952	0.155450451329223	0.155450451329223	false	false	false	true
8518125d-360b-482f-bfeb-fa3766ba4303	2026-09-25 11:30	2026-09-25 11:30	2026-09-25 11:30	SPXW	SPXW260925P07710000	put	7710.0000	2026-09-25	6.0200	5.5000	6.3000	7700.0000	15040.00	0.00	15040.00	25	8	35355	1983	17.8290468986384	0.144883742395004	0.161173163718105	false	false	false	true
3deda28a-2697-411f-a8e8-3e376025297f	2026-09-25 11:30	2026-09-25 11:30	2026-09-25 11:30	SPXW	SPXW260925P07710000	put	7710.0000	2026-09-25	6.1900	5.3000	6.6000	7700.0000	17330.00	5010.00	12320.00	28	12	35447	1983	17.8754412506304	0.162825310454488	0.164408864255029	false	false	false	true
24ed48f9-d5ee-4c2f-bf0d-4d3990effeb1	2026-09-25 11:30	2026-09-25 11:30	2026-09-25 11:30	SPXW	SPXW260925P07710000	put	7710.0000	2026-09-25	6.5600	6.5000	6.7000	7700.0000	13110.00	7260.00	5850.00	20	9	35620	1983	17.9626828038326	0.165712342366468	0.164152700634194	false	false	false	true
b44fdf7a-4030-40b0-b0e5-78c6087b0820	2026-09-25 11:30	2026-09-25 11:30	2026-09-25 11:30	SPXW	SPXW260925P07710000	put	7710.0000	2026-09-25	6.6000	6.5000	6.6000	7700.0000	18480.00	18480.00	0.00	28	6	35671	1983	17.988401412002	0.166799686010735	0.166799686010735	false	false	false	true
c07b9080-daa2-4155-9acd-89855b0d609a	2026-09-25 11:31	2026-09-25 11:31	2026-09-25 11:31	SPXW	SPXW260925P07710000	put	7710.0000	2026-09-25	5.4800	5.4000	5.6000	7705.0000	27940.00	0.00	27940.00	51	6	35994	1983	18.1512859304085	0.159855187081965	0.163497790260241	false	false	false	true
72826782-3ad5-4cf6-9ef3-214e0af01a93	2026-09-25 11:32	2026-09-25 11:32	2026-09-25 11:32	SPXW	SPXW260925P07710000	put	7710.0000	2026-09-25	5.0000	5.0000	5.1000	7705.0000	11000.00	0.00	11000.00	22	5	36223	1983	18.2667675239536	0.166685507804283	0.166685507804283	false	false	false	true
66e02b27-d647-4cc3-814a-98ae53d3931c	2026-09-25 11:32	2026-09-25 11:32	2026-09-25 11:32	SPXW	SPXW260925P07710000	put	7710.0000	2026-09-25	5.2000	5.2000	5.3000	7705.0000	21840.00	0.00	21840.00	42	5	36382	1983	18.3469490670701	0.16762823759618	0.16762823759618	false	false	false	true
533b51c5-fe34-46f7-9053-d084a3370380	2026-09-25 11:32	2026-09-25 11:32	2026-09-25 11:32	SPXW	SPXW260925P07710000	put	7710.0000	2026-09-25	5.1000	5.1000	5.2000	7705.0000	11730.00	0.00	11730.00	23	5	36444	1983	18.3782148260212	0.163102296062453	0.163107331993742	false	false	false	true
fd57b501-1152-44e3-9a0c-0c6100dbdcd5	2026-09-25 11:32	2026-09-25 11:32	2026-09-25 11:32	SPXW	SPXW260925P07710000	put	7710.0000	2026-09-25	5.1000	5.0000	5.2000	7705.0000	104040.00	0.00	102000.00	204	34	36654	1983	18.4841149773071	0.162910866761514	0.162910866761514	false	false	false	true
9f929392-a289-4f47-9e26-797c4c9412a2	2026-09-25 11:33	2026-09-25 11:33	2026-09-25 11:33	SPXW	SPXW260925P07710000	put	7710.0000	2026-09-25	5.5000	5.4000	5.5500	7705.0000	16500.00	16500.00	0.00	30	8	36779	1983	18.547150781644	0.166177431688375	0.166177431688375	false	false	false	true
1774a388-81d4-4385-afa4-b7ac13899a7c	2026-09-25 11:34	2026-09-25 11:34	2026-09-25 11:34	SPXW	SPXW260925P07710000	put	7710.0000	2026-09-25	5.6600	5.1000	6.0000	7725.2000	16980.00	16450.00	0.00	30	11	37033	1983	18.6752395360565	0.164308697146284	0.1742556326477	false	false	false	true
e723b7c0-98f5-40f6-8279-c117172b4ff3	2026-09-25 11:35	2026-09-25 11:35	2026-09-25 11:35	SPXW	SPXW260925P07710000	put	7710.0000	2026-09-25	7.0000	6.9000	7.0000	7721.0300	12600.00	12600.00	0.00	18	7	37460	1983	18.8905698436712	0.17012759768958	0.17012759768958	false	false	false	true
e7d7f6f2-adb7-4d6b-a39a-59433ec64663	2026-09-25 11:35	2026-09-25 11:35	2026-09-25 11:35	SPXW	SPXW260925P07710000	put	7710.0000	2026-09-25	7.3000	7.1000	7.3000	7719.7200	36500.00	36500.00	0.00	50	5	37621	1983	18.9717599596571	0.167598218162356	0.167598218162356	false	false	false	true
d859f2b6-a56c-4269-98df-c0d5c5f50d58	2026-09-25 11:35	2026-09-25 11:35	2026-09-25 11:35	SPXW	SPXW260925P07710000	put	7710.0000	2026-09-25	7.3000	7.1000	7.3000	7719.4800	21900.00	21900.00	0.00	30	16	37750	1983	19.0368129097327	0.166278574725342	0.166278574725342	false	false	false	true
be93dad4-2848-4eaa-8dc9-959fd3e466d0	2026-09-25 11:35	2026-09-25 11:35	2026-09-25 11:35	SPXW	SPXW260925P07710000	put	7710.0000	2026-09-25	7.4000	7.2000	7.4000	7718.9600	37000.00	37000.00	0.00	50	11	37900	1983	19.112455874937	0.164904478963043	0.164904478963043	false	false	false	true
a2f8755c-48b4-4bff-bf32-6f1242faaa40	2026-09-25 11:35	2026-09-25 11:35	2026-09-25 11:35	SPXW	SPXW260925P07710000	put	7710.0000	2026-09-25	7.2000	7.2000	7.4000	7719.0300	36000.00	0.00	36000.00	50	6	37849	1983	19.0867372667675	0.162244274055991	0.162244274055991	false	false	false	true
503b6404-a880-4e16-87ba-3d124ab52bca	2026-09-25 11:35	2026-09-25 11:35	2026-09-25 11:35	SPXW	SPXW260925P07710000	put	7710.0000	2026-09-25	7.5000	7.4000	7.5000	7719.0600	17250.00	17250.00	0.00	23	5	37923	1983	19.1240544629349	0.167004587407348	0.167004587407348	false	false	false	true
56dec17e-1564-45fc-8305-879bf4a2d77f	2026-09-25 11:37	2026-09-25 11:37	2026-09-25 11:37	SPXW	SPXW260925P07710000	put	7710.0000	2026-09-25	9.3900	9.2000	9.4000	7714.9900	21600.00	19740.00	0.00	23	8	38457	1983	19.393343419062	0.171514087337428	0.170037469539191	false	false	false	true
b7a1ac22-fcc9-415d-856d-f6de0979ad7c	2026-09-25 11:38	2026-09-25 11:38	2026-09-25 11:38	SPXW	SPXW260925P07710000	put	7710.0000	2026-09-25	10.6000	10.6000	10.7000	7690.0000	10600.00	0.00	10600.00	10	7	38984	1983	19.6591023701462	0.174988160919858	0.174988160919858	false	false	false	true
bfd3718d-fd8a-434b-b924-90a3909f246d	2026-09-25 11:38	2026-09-25 11:38	2026-09-25 11:38	SPXW	SPXW260925P07710000	put	7710.0000	2026-09-25	10.6100	10.5000	10.7000	7690.0000	11670.00	1070.00	9540.00	11	7	39046	1983	19.6903681290973	0.172650768550999	0.172650768550999	false	false	false	true
26f6cb87-bb45-437b-8bf2-f0033af8a48b	2026-09-25 11:38	2026-09-25 11:38	2026-09-25 11:38	SPXW	SPXW260925P07710000	put	7710.0000	2026-09-25	10.7000	10.6000	10.8000	7690.0000	44940.00	2140.00	42800.00	42	7	39097	1983	19.7160867372668	0.174397144801533	0.174397144801533	false	false	false	true
a35f5751-bd10-489a-ab80-0e01eb2e53ab	2026-09-25 11:39	2026-09-25 11:39	2026-09-25 11:39	SPXW	SPXW260925P07710000	put	7710.0000	2026-09-25	10.5100	10.5000	10.7000	7690.0000	12610.00	0.00	12610.00	12	5	39233	1983	19.7846696923853	0.176540237525367	0.175073628381613	false	false	false	true
f4b1c1e1-6bdd-40f7-badb-da37792dc840	2026-09-25 11:39	2026-09-25 11:39	2026-09-25 11:39	SPXW	SPXW260925P07710000	put	7710.0000	2026-09-25	10.7000	10.6000	10.7000	7690.0000	10700.00	10700.00	0.00	10	6	39255	1983	19.7957639939486	0.176467764718652	0.176467764718652	false	false	false	true
7e40a8c2-4a23-493f-9c70-3a8688917a0e	2026-09-25 11:39	2026-09-25 11:39	2026-09-25 11:39	SPXW	SPXW260925P07710000	put	7710.0000	2026-09-25	10.6600	10.5000	10.7000	7690.0000	12790.00	12790.00	0.00	12	8	39311	1983	19.8240040342915	0.17205360371508	0.173523338551859	false	false	false	true
e5f9a349-59fc-41d6-8001-bfd53176e815	2026-09-25 11:39	2026-09-25 11:39	2026-09-25 11:39	SPXW	SPXW260925P07710000	put	7710.0000	2026-09-25	10.8000	10.7000	10.8000	7690.0000	11880.00	11880.00	0.00	11	6	39455	1983	19.8966212808875	0.171015101151092	0.171015101151092	false	false	false	true
50f71683-a11e-4ed1-9f23-925471546d85	2026-09-25 11:39	2026-09-25 11:39	2026-09-25 11:39	SPXW	SPXW260925P07710000	put	7710.0000	2026-09-25	10.7000	10.7000	10.8000	7690.0000	10700.00	0.00	10700.00	10	6	39518	1983	19.9283913262733	0.169189410240837	0.169189410240837	false	false	false	true
11baccfc-fb63-43ee-bad1-abc4c7bfa2b5	2026-09-25 11:40	2026-09-25 11:40	2026-09-25 11:40	SPXW	SPXW260925P07710000	put	7710.0000	2026-09-25	11.1000	11.0000	11.1000	7690.0000	26640.00	26640.00	0.00	24	7	39755	1983	20.047907211296	0.177231306539005	0.177231306539005	false	false	false	true
fa141642-9723-4b4f-9507-42b1c96a14fd	2026-09-25 11:40	2026-09-25 11:40	2026-09-25 11:40	SPXW	SPXW260925P07710000	put	7710.0000	2026-09-25	11.4000	11.3000	11.4000	7690.0000	28500.00	28500.00	0.00	25	5	39829	1983	20.0852244074634	0.178950340924155	0.178950340924155	false	false	false	true
cd426f3c-97ea-4a3a-9d9c-62c1aacdf388	2026-09-25 11:40	2026-09-25 11:40	2026-09-25 11:40	SPXW	SPXW260925P07710000	put	7710.0000	2026-09-25	10.9000	10.9000	11.0000	7690.0000	22890.00	0.00	22890.00	21	6	39878	1983	20.1099344427635	0.170169409423324	0.170169409423324	false	false	false	true
840b3666-4051-46c1-b27a-9548ff55bccb	2026-09-25 11:40	2026-09-25 11:40	2026-09-25 11:40	SPXW	SPXW260925P07710000	put	7710.0000	2026-09-25	11.2600	11.2000	11.3000	7690.0000	16890.00	10170.00	6720.00	15	5	39851	1983	20.0963187090267	0.177072037527587	0.175607462690149	false	false	false	true
40b37101-c4d3-4821-a840-125368118151	2026-09-25 11:40	2026-09-25 11:40	2026-09-25 11:40	SPXW	SPXW260925P07710000	put	7710.0000	2026-09-25	10.0100	9.8000	10.1000	7690.0000	10010.00	3020.00	5990.00	10	8	40097	1983	20.2203731719617	0.162858964526819	0.16545261331502	false	false	false	true
7a9183c2-e769-42b2-a5de-a5ed306adbeb	2026-09-25 11:41	2026-09-25 11:40	2026-09-25 11:40	SPXW	SPXW260925P07710000	put	7710.0000	2026-09-25	9.5000	9.4000	9.6000	7690.0000	13300.00	12350.00	0.00	14	6	40178	1983	20.261220373172	0.16654959755921	0.16654959755921	false	false	false	true
6e15091e-26ce-46d1-96b7-afa8b8b4039b	2026-09-25 11:41	2026-09-25 11:41	2026-09-25 11:41	SPXW	SPXW260925P07710000	put	7710.0000	2026-09-25	9.6400	9.5000	9.7000	7690.0000	16380.00	5820.00	10560.00	17	6	40420	1983	20.3832576903681	0.168432368360226	0.169912860949918	false	false	false	true
f612670b-183e-4d66-910e-33d64ec5619d	2026-09-25 11:42	2026-09-25 11:42	2026-09-25 11:42	SPXW	SPXW260925P07710000	put	7710.0000	2026-09-25	10.0000	9.9000	10.1000	7690.0000	10000.00	0.00	8000.00	10	5	40682	1983	20.5153807362582	0.167066577692498	0.167066577692498	false	false	false	true
d3bf48e7-8fa2-426a-9cd1-897f3ecf4565	2026-09-25 11:42	2026-09-25 11:42	2026-09-25 11:42	SPXW	SPXW260925P07710000	put	7710.0000	2026-09-25	9.5000	9.4000	9.5000	7713.7900	21850.00	21850.00	0.00	23	11	40760	1983	20.5547150781644	0.166873219035418	0.166873219035418	false	false	false	true
caa0824c-7302-4b86-a83b-ffeece5dff07	2026-09-25 11:42	2026-09-25 11:42	2026-09-25 11:42	SPXW	SPXW260925P07710000	put	7710.0000	2026-09-25	10.3000	10.3000	10.4000	7712.9900	20600.00	0.00	20600.00	20	5	40828	1983	20.5890065557236	0.173470565613833	0.173470565613833	false	false	false	true
f1ae9629-6540-443b-be99-28bdccbada54	2026-09-25 11:43	2026-09-25 11:42	2026-09-25 11:42	SPXW	SPXW260925P07710000	put	7710.0000	2026-09-25	10.6000	10.5000	10.6000	7712.3500	10600.00	10600.00	0.00	10	5	40880	1983	20.6152294503278	0.173574643383429	0.173574643383429	false	false	false	true
4e6fd23f-432f-4c95-8377-6d9aa4197d11	2026-09-25 11:43	2026-09-25 11:43	2026-09-25 11:43	SPXW	SPXW260925P07710000	put	7710.0000	2026-09-25	10.5800	10.3000	10.8000	7712.2700	65580.00	32840.00	21100.00	62	18	41032	1983	20.6918809884014	0.174538672047479	0.171588234854759	false	false	false	true
7faec9cd-5ef2-4ff7-bb61-d1d282ee96ea	2026-09-25 11:43	2026-09-25 11:43	2026-09-25 11:43	SPXW	SPXW260925P07710000	put	7710.0000	2026-09-25	11.1000	11.0000	11.2000	7711.3900	21090.00	19980.00	1110.00	19	9	41266	1983	20.80988401412	0.174538576880622	0.174538576880622	false	false	false	true
72e54009-5f31-46b9-858b-29457675bf24	2026-09-25 11:43	2026-09-25 11:43	2026-09-25 11:43	SPXW	SPXW260925P07710000	put	7710.0000	2026-09-25	11.0000	10.9000	11.0000	7711.7200	14300.00	14300.00	0.00	13	5	41233	1983	20.7932425617751	0.175376680193819	0.175376680193819	false	false	false	true
989a0f4c-a953-4658-8d81-26ca942768b0	2026-09-25 11:44	2026-09-25 11:43	2026-09-25 11:43	SPXW	SPXW260925P07710000	put	7710.0000	2026-09-25	11.4100	11.3000	11.5000	7710.3500	14830.00	3430.00	0.00	13	6	41388	1983	20.8714069591528	0.171591959515956	0.173065247230017	false	false	false	true
5644b6c0-5008-4a44-8e36-ea5bb8e84e73	2026-09-25 11:44	2026-09-25 11:44	2026-09-25 11:44	SPXW	SPXW260925P07710000	put	7710.0000	2026-09-25	11.5500	11.4000	11.6000	7710.2500	28870.00	28870.00	0.00	25	7	41462	1983	20.9087241553202	0.172371990360784	0.173845497027434	false	false	false	true
532316e2-9074-4b66-a7fd-7e9bddb35ef2	2026-09-25 11:44	2026-09-25 11:44	2026-09-25 11:44	SPXW	SPXW260925P07710000	put	7710.0000	2026-09-25	11.6200	11.5000	11.7000	7710.2000	10460.00	2340.00	0.00	9	5	41501	1983	20.9283913262733	0.174960526688846	0.173492578646376	false	false	false	true
48b1239d-215f-4304-856c-f8ce978cd979	2026-09-25 11:44	2026-09-25 11:44	2026-09-25 11:44	SPXW	SPXW260925P07710000	put	7710.0000	2026-09-25	11.5100	11.5000	11.7000	7710.2500	20720.00	2320.00	18400.00	18	7	41492	1983	20.9238527483611	0.173851086619367	0.172377531976539	false	false	false	true