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.

566,287 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts566,287 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

7736868f-11b2-4c17-ac0d-b3c971c894d4	2026-09-29 15:42	2026-09-29 15:42	2026-09-29 15:42	SPXW	SPXW261001C07725000	call	7725.0000	2026-10-01	10.5000	10.5000	10.7000	7650.0000	10500.00	0.00	10500.00	10	5	413	877	0.470923603192702	0.127462881975898	0.127462881975898	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	—	—	—	—	—	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-29T19:43:26.980226Z"}	2026-09-29	2026-09-29 21:15	2026-09-29 21:15
9de32828-a1c2-4fa5-884d-fa42912c06ea	2026-09-29 15:42	2026-09-29 15:42	2026-09-29 15:42	SPXW	SPXW261016P07550000	put	7550.0000	2026-10-16	42.1000	41.8000	42.2000	7650.0000	1052500.00	951460.00	101040.00	250	9	2556	1870	1.3668449197861	0.145770619083175	0.145770619083175	false	false	false	true
e10df535-20eb-4e95-8a9a-06327877f2b6	2026-09-29 15:42	2026-09-29 15:42	2026-09-29 15:42	SPXW	SPXW260930P07675000	put	7675.0000	2026-09-30	21.3000	21.2000	21.4000	7650.0000	129930.00	0.00	44730.00	61	7	3879	4553	0.851965736876785	0.12946525279979	0.12946525279979	false	false	false	true
cc852e09-b615-4090-98e5-806a6c06cbb3	2026-09-29 15:42	2026-09-29 15:42	2026-09-29 15:42	SPXW	SPXW260929P07680000	put	7680.0000	2026-09-29	7.4000	7.3000	7.5000	7650.0000	14800.00	0.00	8880.00	20	5	60483	1535	39.4026058631922	0.145853955289998	0.145853955289998	false	false	false	true
81352dcf-9afd-41e2-bcf9-00261782ae4a	2026-09-29 15:42	2026-09-29 15:42	2026-09-29 15:42	SPXW	SPXW260929P07700000	put	7700.0000	2026-09-29	26.6000	26.4000	26.7000	7650.0000	18620.00	18620.00	0.00	7	5	11003	3257	3.37826220448265	0.233163620030009	0.233163620030009	false	false	false	true
26a6aa98-c335-47d1-b94e-0bc5f9a00860	2026-09-29 15:42	2026-09-29 15:42	2026-09-29 15:42	SPXW	SPXW260930P07680000	put	7680.0000	2026-09-30	23.8000	23.8000	24.0000	7650.0000	47600.00	0.00	47600.00	20	6	4599	1082	4.25046210720887	0.128489790770841	0.128489790770841	false	false	false	true
d234d913-c770-42f1-ba68-868c27061bb3	2026-09-29 15:42	2026-09-29 15:42	2026-09-29 15:42	SPXW	SPXW260929C07675000	call	7675.0000	2026-09-29	2.4000	2.3000	2.4000	7650.0000	12000.00	12000.00	0.00	50	17	116550	1911	60.989010989011	0.188279501308634	0.188279501308634	false	false	false	true
5509aad2-322c-456c-a02d-0380a3d50427	2026-09-29 15:42	2026-09-29 15:42	2026-09-29 15:42	SPXW	SPXW260930P07675000	put	7675.0000	2026-09-30	21.5000	21.5000	21.6000	7650.0000	51600.00	0.00	51600.00	24	6	3813	4553	0.837469800131781	0.129793772817536	0.129793772817536	false	false	false	true
1b5cd3d7-de4a-49e4-88bd-ad826e83e26c	2026-09-29 15:42	2026-09-29 15:42	2026-09-29 15:42	SPXW	SPXW260929P07675000	put	7675.0000	2026-09-29	4.2000	4.2000	4.3000	7650.0000	17220.00	0.00	17220.00	41	22	77218	1977	39.0581689428427	0.162519114676454	0.162519114676454	false	false	false	true
5bc5705a-fa84-4ca0-b41b-015b5448bf51	2026-09-29 15:42	2026-09-29 15:42	2026-09-29 15:42	SPXW	SPXW261016P07550000	put	7550.0000	2026-10-16	42.2000	41.9000	42.3000	7650.0000	1055000.00	742720.00	312280.00	250	12	2306	1870	1.2331550802139	0.145840549172575	0.145840549172575	false	false	false	true
06a8d9cd-fdf5-4107-9b9e-c5af5fbdd76a	2026-09-29 15:42	2026-09-29 15:42	2026-09-29 15:42	SPXW	SPXW260929C07675000	call	7675.0000	2026-09-29	2.3100	2.2500	2.3500	7650.0000	10385.00	3945.00	6440.00	45	8	116316	1911	60.8665620094192	0.183709276098781	0.186618939197493	false	false	false	true
0e516892-2ae3-4552-a3d2-63e389fe319e	2026-09-29 15:42	2026-09-29 15:41	2026-09-29 15:41	SPXW	SPXW261016P07550000	put	7550.0000	2026-10-16	42.0000	41.8000	42.1000	7650.0000	1050000.00	373800.00	676200.00	250	13	2056	1870	1.09946524064171	0.145680489713954	0.145680489713954	false	false	false	true
454ea7df-5937-46eb-bd6d-25dd86da4121	2026-09-29 15:41	2026-09-29 15:41	2026-09-29 15:41	SPXW	SPXW261016P07550000	put	7550.0000	2026-10-16	42.0000	41.7000	42.1000	7650.0000	1050000.00	541800.00	508200.00	250	8	1306	1870	0.698395721925134	0.145325361748704	0.145325361748704	false	false	false	true
44f02de4-9ed2-4e96-aa2d-bb580d6ac427	2026-09-29 15:41	2026-09-29 15:41	2026-09-29 15:41	SPXW	SPXW260929C07670000	call	7670.0000	2026-09-29	4.7000	4.5000	4.7000	7650.0000	12210.00	11750.00	460.00	26	15	105728	266	397.473684210526	0.146951199282273	0.16953760564759	false	false	false	true
fe1bb324-4c4e-4b0b-8dfe-0cc74240ea18	2026-09-29 15:41	2026-09-29 15:40	2026-09-29 15:40	SPXW	SPXW261016P07550000	put	7550.0000	2026-10-16	41.4000	41.1000	41.5000	7650.0000	1035000.00	248400.00	786600.00	250	9	806	1870	0.431016042780749	0.144901967763416	0.14493683755117	false	false	false	true
47ff6723-6495-4c32-ab83-133185a513aa	2026-09-29 15:40	2026-09-29 15:40	2026-09-29 15:40	SPXW	SPXW260929P07675000	put	7675.0000	2026-09-29	3.8000	3.7000	3.9000	7650.0000	11780.00	10640.00	0.00	31	8	76025	1977	38.4547293879616	0.167894072708765	0.167894072708765	false	false	false	true
deb34449-3134-432e-8c13-bbd38950f876	2026-09-29 15:40	2026-09-29 15:40	2026-09-29 15:40	SPXW	SPXW260929P07675000	put	7675.0000	2026-09-29	3.7000	3.5000	3.7000	7650.0000	19970.00	19610.00	0.00	54	14	75943	1977	38.4132524026302	0.156285423217568	0.156285423217568	false	false	false	true
d9c598e1-65b9-47e6-bf53-475458251043	2026-09-29 15:40	2026-09-29 15:40	2026-09-29 15:40	SPXW	SPXW260929P07675000	put	7675.0000	2026-09-29	3.5000	3.5000	3.6000	7650.0000	21000.00	0.00	21000.00	60	17	75810	1977	38.3459787556904	0.151458491071621	0.151458491071621	false	false	false	true
92faed9d-790c-4401-8d50-e99037cac880	2026-09-29 15:40	2026-09-29 15:40	2026-09-29 15:40	SPXW	SPXW260929P07680000	put	7680.0000	2026-09-29	6.8000	6.7000	6.8000	7655.0000	10880.00	10880.00	0.00	16	7	59959	1535	39.0612377850163	0.174219771658371	0.174219771658371	false	false	false	true
098f87f5-fe6a-4872-99c4-721dd1803c0e	2026-09-29 15:40	2026-09-29 15:40	2026-09-29 15:40	SPXW	SPXW260929P07670000	put	7670.0000	2026-09-29	1.4500	1.4000	1.4500	7655.0000	18995.00	18995.00	0.00	131	15	94276	1317	71.5839028094153	0.172480013241083	0.172480013241083	false	false	false	true
df6a35ba-80c4-4a75-8478-59cc24ac92d2	2026-09-29 15:40	2026-09-29 15:40	2026-09-29 15:40	SPXW	SPXW260929P07695000	put	7695.0000	2026-09-29	20.3000	20.1000	20.3000	7655.0000	22330.00	22330.00	0.00	11	6	10669	1045	10.2095693779904	0.192985382852941	0.192985382852941	false	false	false	true
c6922258-d234-4266-9f65-f11c630c301e	2026-09-29 15:40	2026-09-29 15:40	2026-09-29 15:40	SPXW	SPXW260929C07675000	call	7675.0000	2026-09-29	3.3000	3.2000	3.4000	7655.0000	10890.00	7590.00	3300.00	33	13	114667	1911	60.003663003663	0.182084826421206	0.182084826421206	false	false	false	true
208d69ec-598b-47bf-a398-ee9391740ade	2026-09-29 15:40	2026-09-29 15:40	2026-09-29 15:40	SPXW	SPXW260929C07665000	call	7665.0000	2026-09-29	10.5000	10.4000	10.6000	7655.0000	11550.00	0.00	10500.00	11	6	78309	290	270.031034482759	0.208254984551354	0.208254984551354	false	false	false	true
3ce15f34-3066-44f1-aef7-4045c5490fa6	2026-09-29 15:40	2026-09-29 15:39	2026-09-29 15:39	SPXW	SPXW260929C07680000	call	7680.0000	2026-09-29	1.4000	1.4000	1.4500	7655.0000	12180.00	0.00	12180.00	87	26	144989	720	201.373611111111	0.178983810137438	0.179058416458032	false	false	false	true
50d3e5c3-c3b1-4800-b303-de9e29b8a9dd	2026-09-29 15:39	2026-09-29 15:39	2026-09-29 15:39	SPXW	SPXW260929C07645000	call	7645.0000	2026-09-29	30.6000	30.3000	30.7000	7655.0000	24480.00	12240.00	12240.00	8	5	5793	195	29.7076923076923	0.37732862941054	0.37732862941054	false	false	false	true
8e3f8c36-baac-4dea-a4bc-3dd431de3fe4	2026-09-29 15:39	2026-09-29 15:39	2026-09-29 15:39	SPXW	SPXW261016P07630000	put	7630.0000	2026-10-16	61.1000	61.1000	61.3000	7655.0000	61100.00	0.00	61100.00	10	8	189	272	0.694852941176471	0.133477871254288	0.133477871254288	false	false	false	true
b9ba301c-1814-46cc-a06d-912f1247c8c0	2026-09-29 15:39	2026-09-29 15:39	2026-09-29 15:39	SPXW	SPXW260929C07645000	call	7645.0000	2026-09-29	31.3000	31.1000	31.4000	7655.0000	18780.00	18780.00	0.00	6	5	5785	195	29.6666666666667	0.416592928545111	0.416592928545111	false	false	false	true
e097a069-def8-4fc9-ae15-e3e5721d55d2	2026-09-29 15:39	2026-09-29 15:39	2026-09-29 15:39	SPXW	SPXW260929C07675000	call	7675.0000	2026-09-29	3.8000	3.8000	4.0000	7655.0000	19380.00	0.00	19380.00	51	15	114177	1911	59.7472527472527	0.187911192825633	0.187911192825633	false	false	false	true
c1b9ad30-fccb-47d7-97e0-37fd707bd73d	2026-09-29 15:39	2026-09-29 15:39	2026-09-29 15:39	SPXW	SPXW260929C07685000	call	7685.0000	2026-09-29	0.7000	0.7000	0.7500	7655.0000	21000.00	0.00	21000.00	300	35	125297	847	147.930342384888	0.184342560570228	0.184342560570228	true	false	false	true
f50875ed-7d26-4628-8274-15b5b7ad49ec	2026-09-29 15:39	2026-09-29 15:38	2026-09-29 15:38	SPXW	SPXW261002C07675000	call	7675.0000	2026-10-02	41.4000	41.4000	41.6000	7655.0000	78660.00	0.00	78660.00	19	6	658	572	1.15034965034965	0.143455783097624	0.143455783097624	false	false	false	true
0a94be10-9586-4ab7-89d5-aaa968811320	2026-09-29 15:38	2026-09-29 15:38	2026-09-29 15:38	SPXW	SPXW260930P07680000	put	7680.0000	2026-09-30	23.0000	22.8000	23.0000	7655.0000	64400.00	64400.00	0.00	28	5	4512	1082	4.17005545286507	0.131409087732351	0.131409087732351	false	false	false	true
d90d220b-e924-44b7-b53e-b8beed40c1af	2026-09-29 15:38	2026-09-29 15:38	2026-09-29 15:38	SPXW	SPXW260929P07670000	put	7670.0000	2026-09-29	1.3000	1.2500	1.3500	7655.0000	16380.00	12350.00	0.00	126	13	93014	1317	70.6256643887623	0.165730584764342	0.165730584764342	false	false	false	true
721e5fcc-7f15-472e-9a6c-5c74f95922b3	2026-09-29 15:38	2026-09-29 15:38	2026-09-29 15:38	SPXW	SPXW260929C07680000	call	7680.0000	2026-09-29	1.8000	1.8000	1.8500	7655.0000	16020.00	0.00	16020.00	89	20	143815	720	199.743055555556	0.182200075203926	0.182200075203926	false	false	false	true
0f2c745d-a2e2-4239-87f3-c0f0dc13f41f	2026-09-29 15:38	2026-09-29 15:38	2026-09-29 15:38	SPXW	SPXW260929C07675000	call	7675.0000	2026-09-29	4.0000	3.9000	4.0000	7655.0000	12800.00	12800.00	0.00	32	19	113749	1911	59.523286237572	0.191994199520638	0.191994199520638	false	false	false	true
0191c258-d3b6-40fc-9fd5-9527bc35105b	2026-09-29 15:38	2026-09-29 15:38	2026-09-29 15:38	SPXW	SPXW260929C07680000	call	7680.0000	2026-09-29	1.7000	1.7000	1.7500	7655.0000	10030.00	0.00	10030.00	59	16	143529	720	199.345833333333	0.179138408286674	0.179138408286674	false	false	false	true
be319355-10e7-41c1-b727-445a2e93d381	2026-09-29 15:37	2026-09-29 15:37	2026-09-29 15:37	SPXW	SPXW260930C07700000	call	7700.0000	2026-09-30	11.3700	11.0000	11.2000	7655.0000	3411000.00	0.00	0.00	3000	22	13157	5282	2.49091253313139	0.13164581078862	0.13164581078862	false	false	false	true
bb576783-9179-439a-a2ab-dddd0b8c4d28	2026-09-29 15:37	2026-09-29 15:37	2026-09-29 15:37	SPXW	SPXW260930C07675000	call	7675.0000	2026-09-30	22.4700	22.0000	22.2000	7655.0000	6741000.00	0.00	0.00	3000	22	7462	3758	1.98563065460351	0.136051753920801	0.136051753920801	false	false	false	true
3b3e8280-3e19-4dff-815c-ab010ee94736	2026-09-29 15:37	2026-09-29 15:37	2026-09-29 15:37	SPXW	SPXW260930C07690000	call	7690.0000	2026-09-30	15.1200	14.8000	15.0000	7655.0000	9072000.00	0.00	0.00	6000	22	9117	306	29.7941176470588	0.132546973237235	0.132546973237235	false	false	false	true
e43949c5-5c7e-4bc1-92fe-fc036f9007b2	2026-09-29 15:37	2026-09-29 15:37	2026-09-29 15:37	SPXW	SPXW260929C07680000	call	7680.0000	2026-09-29	1.6500	1.6000	1.7000	7655.0000	23430.00	16995.00	6435.00	142	20	143088	720	198.733333333333	0.184521656558837	0.184521656558837	false	false	false	true
6667bf9b-22f7-45a3-965e-d5520bcb04e3	2026-09-29 15:37	2026-09-29 15:37	2026-09-29 15:37	SPXW	SPXW261002C07900000	call	7900.0000	2026-10-02	0.7000	0.6500	0.7000	7655.0000	12530.00	12530.00	0.00	179	5	13345	19306	0.691235885217031	0.150559384524281	0.150559384524281	false	false	false	true
44def487-79a8-4bd9-98f2-4835095dca86	2026-09-29 15:37	2026-09-29 15:37	2026-09-29 15:37	SPXW	SPXW260929C07675000	call	7675.0000	2026-09-29	3.5000	3.5000	3.6000	7655.0000	11550.00	0.00	11550.00	33	10	113341	1911	59.3097854526426	0.174080566744573	0.174080566744573	false	false	false	true
fc1e8ee1-89a7-4e78-bd2b-87f9a2e353bd	2026-09-29 15:37	2026-09-29 15:37	2026-09-29 15:37	SPXW	SPXW260929C07670000	call	7670.0000	2026-09-29	6.7000	6.6000	6.7000	7655.0000	10050.00	10050.00	0.00	15	10	104983	266	394.672932330827	0.192623145411174	0.192623145411174	false	false	false	true
e137f50c-3994-4f99-81b3-3d4b9d4e0c79	2026-09-29 15:37	2026-09-29 15:37	2026-09-29 15:37	SPXW	SPXW261002P07385000	put	7385.0000	2026-10-02	0.8000	0.8000	0.9000	7655.0000	68000.00	0.00	0.00	850	5	1624	439	3.69931662870159	0.200209510717745	0.200209510717745	false	false	false	true
89784de0-b555-4b5c-9c90-b26fff2692ec	2026-09-29 15:36	2026-09-29 15:36	2026-09-29 15:36	SPXW	SPXW260930P07680000	put	7680.0000	2026-09-30	23.8000	23.6000	23.8000	7673.7700	23800.00	23800.00	0.00	10	5	4473	1082	4.13401109057301	0.131009950068397	0.131009950068397	false	false	false	true
8a507f2c-fd6f-4d4f-b169-d45c4b80d82d	2026-09-29 15:36	2026-09-29 15:35	2026-09-29 15:35	SPXW	SPXW260929C07675000	call	7675.0000	2026-09-29	3.1000	3.0000	3.2000	7674.3900	10540.00	0.00	10230.00	34	12	112606	1911	58.9251700680272	0.163603889598172	0.163603889598172	false	false	false	true
9b92bbe4-8760-4f24-9a00-dacce6bdad92	2026-09-29 15:35	2026-09-29 15:35	2026-09-29 15:35	SPXW	SPXW260930C07700000	call	7700.0000	2026-09-30	10.9000	10.7000	10.9000	7674.5100	10900.00	10900.00	0.00	10	5	10092	5282	1.91063990912533	0.13055073759641	0.13055073759641	false	false	false	true
efa734e1-5b9e-4f30-bad6-376e3e899f84	2026-09-29 15:35	2026-09-29 15:35	2026-09-29 15:35	SPXW	SPXW260929C07680000	call	7680.0000	2026-09-29	1.5000	1.5000	1.5500	7674.8200	15000.00	0.00	15000.00	100	24	141473	720	196.490277777778	0.166977835910868	0.166977835910868	false	false	false	true
274ce94e-2d53-49cf-a6d9-e6730f523cca	2026-09-29 15:35	2026-09-29 15:35	2026-09-29 15:35	SPXW	SPXW261005C07840000	call	7840.0000	2026-10-05	2.9000	2.8500	2.9500	7674.4500	11600.00	2320.00	9280.00	40	6	246	539	0.456400742115028	0.105677369544876	0.105677369544876	false	false	false	true
8baccf1d-b7dc-4754-9bdd-0b7ed0437eab	2026-09-29 15:35	2026-09-29 15:34	2026-09-29 15:34	SPXW	SPXW260929P07680000	put	7680.0000	2026-09-29	6.5000	6.5000	6.6000	7674.3100	40950.00	0.00	40950.00	63	9	59251	1535	38.6	0.131933124894972	0.131933124894972	false	false	false	true
8465f594-5205-4f7e-b6b2-c06b90896efb	2026-09-29 15:34	2026-09-29 15:34	2026-09-29 15:34	SPXW	SPXW260929C07645000	call	7645.0000	2026-09-29	30.2000	29.9000	30.3000	7674.5400	24160.00	24160.00	0.00	8	6	5766	195	29.5692307692308	0.377935958249098	0.377935958249098	false	false	false	true