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.

658,639 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts658,639 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

bf55fe9b-56aa-413f-a7c1-b05da9ecb7ee	2026-10-01 15:31	2026-10-01 15:31	2026-10-01 15:31	SPXW	SPXW261001C07675000	call	7675.0000	2026-10-01	4.8000	4.7000	4.9000	7676.4700	15370.00	980.00	13430.00	32	9	122190	1662	73.5198555956679	0.17759912756776	0.177651112583221	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-10-01T19:36:48.028615Z"}	2026-10-01	2026-10-01 21:15	2026-10-01 21:15
3e210967-2fd4-450b-abcd-f8f7df7f0e01	2026-10-01 15:31	2026-10-01 15:31	2026-10-01 15:31	SPXW	SPXW261001C07675000	call	7675.0000	2026-10-01	4.9000	4.8000	4.9000	7676.2900	11270.00	11270.00	0.00	23	5	122219	1662	73.5373044524669	0.186576155737894	0.186576155737894	false	false	false	true
c2fce660-6aad-4a1a-aade-9b779e575d12	2026-10-01 15:31	2026-10-01 15:31	2026-10-01 15:31	SPXW	SPXW261001C07660000	call	7660.0000	2026-10-01	17.0000	16.8000	17.1000	7676.8100	17000.00	17000.00	0.00	10	7	95495	810	117.895061728395	0.173345911875357	0.173345911875357	false	false	false	true
9f77177c-2350-4b66-8f6b-ed28a948ee4a	2026-10-01 15:31	2026-10-01 15:31	2026-10-01 15:31	SPXW	SPXW261001C07675000	call	7675.0000	2026-10-01	5.0000	4.9000	5.1000	7676.3300	11000.00	10500.00	0.00	22	5	121933	1662	73.3652226233454	0.189613117734342	0.189668373271314	false	false	false	true
e83ac734-979e-4584-9a9e-e8a0e1dff074	2026-10-01 15:31	2026-10-01 15:31	2026-10-01 15:31	SPXW	SPXW261001P07675000	put	7675.0000	2026-10-01	3.8000	3.6000	3.8000	7676.4600	15200.00	15200.00	0.00	40	9	46064	2224	20.7122302158273	0.198521883279164	0.198521883279164	false	false	false	true
9ef05c2a-81d4-463f-b289-a070270898ad	2026-10-01 15:31	2026-10-01 15:31	2026-10-01 15:31	SPXW	SPXW261001C07665000	call	7665.0000	2026-10-01	12.2000	12.1000	12.4000	7676.3100	19520.00	9760.00	9760.00	16	8	88725	556	159.577338129496	0.194334873871077	0.194334873871077	false	false	false	true
1cbdc372-ee8e-4c82-af0d-0d04b6c36da0	2026-10-01 15:31	2026-10-01 15:31	2026-10-01 15:31	SPXW	SPXW261001C07660000	call	7660.0000	2026-10-01	16.7000	16.6000	16.7000	7676.3100	28390.00	28390.00	0.00	17	5	95468	810	117.861728395062	0.198830676344912	0.198830676344912	false	false	false	true
741da9a6-7590-4981-befb-4d9db8e235b0	2026-10-01 15:31	2026-10-01 15:31	2026-10-01 15:31	SPXW	SPXW261001P07675000	put	7675.0000	2026-10-01	3.8000	3.7000	3.9000	7655.0000	26220.00	0.00	25840.00	69	18	45994	2224	20.6807553956835	0.187483955475598	0.193192623047879	false	false	false	true
c22d600e-3d9c-48e8-85a5-94280dc3fe4d	2026-10-01 15:31	2026-10-01 15:31	2026-10-01 15:31	SPXW	SPXW261001P07675000	put	7675.0000	2026-10-01	4.0000	4.0000	4.1000	7655.0000	10000.00	0.00	10000.00	25	12	45861	2224	20.6209532374101	0.183822230033904	0.183822230033904	false	false	false	true
d428de96-b913-4793-99f0-591e8e4888a3	2026-10-01 15:31	2026-10-01 15:31	2026-10-01 15:31	SPXW	SPXW261001C07675000	call	7675.0000	2026-10-01	3.9000	3.8000	3.9000	7655.0000	11700.00	11700.00	0.00	30	6	121583	1662	73.1546329723225	0.179561773043124	0.179561773043124	false	false	false	true
e9eb19ac-92fc-4df2-a3a7-83697cb90029	2026-10-01 15:30	2026-10-01 15:30	2026-10-01 15:30	SPXW	SPXW261005P07400000	put	7400.0000	2026-10-05	0.8000	0.8000	0.9000	7655.0000	192000.00	0.00	0.00	2400	7	2620	1098	2.38615664845173	0.166301929125428	0.166301929125428	false	false	false	true
af6343f3-ac43-4974-877f-8151bb6bc8df	2026-10-01 15:30	2026-10-01 15:30	2026-10-01 15:30	SPXW	SPXW261001C07675000	call	7675.0000	2026-10-01	4.0000	3.9000	4.0000	7655.0000	12000.00	12000.00	0.00	30	21	121436	1662	73.0661853188929	0.176477342510087	0.176477342510087	false	false	false	true
3b1b8a62-1e3d-4aad-a5e1-7d471be757c2	2026-10-01 15:30	2026-10-01 15:30	2026-10-01 15:30	SPXW	SPXW261001C07675000	call	7675.0000	2026-10-01	3.9000	3.8000	3.9000	7655.0000	10140.00	10140.00	0.00	26	6	121401	1662	73.0451263537906	0.173568525919177	0.173568525919177	false	false	false	true
d045020a-d1ea-4539-af0f-484a38c58862	2026-10-01 15:30	2026-10-01 15:30	2026-10-01 15:30	SPXW	SPXW261001C07665000	call	7665.0000	2026-10-01	10.4000	10.3000	10.5000	7655.0000	20800.00	5200.00	15600.00	20	6	88616	556	159.381294964029	0.161708760932774	0.161708760932774	false	false	false	true
72398062-80b2-41cf-b562-4bc646eb504f	2026-10-01 15:30	2026-10-01 15:30	2026-10-01 15:30	SPXW	SPXW261001P07675000	put	7675.0000	2026-10-01	4.5000	4.5000	4.6000	7655.0000	18450.00	0.00	18450.00	41	19	45558	2224	20.4847122302158	0.1905969129396	0.1905969129396	false	false	false	true
c4499eea-ac2b-46a6-9bef-9f38781ca514	2026-10-01 15:30	2026-10-01 15:30	2026-10-01 15:30	SPXW	SPXW261001P07670000	put	7670.0000	2026-10-01	2.4000	2.3750	2.4500	7655.0000	10800.00	0.00	10800.00	45	21	66482	1738	38.2520138089758	0.18558285508216	0.185635322281171	false	false	false	true
e5b4660d-0a6d-464b-a14b-f50123eb9281	2026-10-01 15:30	2026-10-01 15:30	2026-10-01 15:30	SPXW	SPXW261001P07685000	put	7685.0000	2026-10-01	12.1000	12.1000	12.2000	7650.0000	12100.00	0.00	12100.00	10	5	9281	1922	4.82882414151925	0.212070482089068	0.212070482089068	false	false	false	true
60d1b44a-ad9c-44e3-a373-abe084d21ee3	2026-10-01 15:30	2026-10-01 15:30	2026-10-01 15:30	SPXW	SPXW261002P07650000	put	7650.0000	2026-10-02	15.5000	15.3000	15.5000	7650.0000	77500.00	77500.00	0.00	50	6	6774	3173	2.13488811849984	0.162907376994722	0.162907376994722	false	false	false	true
f694655d-c457-4b52-a3b6-16a4ce00d9cd	2026-10-01 15:30	2026-10-01 15:30	2026-10-01 15:30	SPXW	SPXW261016P07600000	put	7600.0000	2026-10-16	49.4000	49.4000	49.5000	7655.0000	98800.00	0.00	98800.00	20	5	287	2412	0.118988391376451	0.139229444765144	0.139229444765144	false	false	false	true
1dd2d5f4-26c4-4e57-85c9-51adfc580362	2026-10-01 15:30	2026-10-01 15:30	2026-10-01 15:30	SPXW	SPXW261009P07630000	put	7630.0000	2026-10-09	37.2000	37.2000	37.3000	7650.0000	186000.00	0.00	186000.00	50	5	314	726	0.432506887052342	0.130906458170746	0.130906458170746	false	false	false	true
76745c22-244f-4a1e-ac7a-eb5bfa9ae8ce	2026-10-01 15:29	2026-10-01 15:29	2026-10-01 15:29	SPXW	SPXW261001P07675000	put	7675.0000	2026-10-01	5.2000	5.1000	5.3000	7650.0000	20800.00	14560.00	0.00	40	7	45041	2224	20.2522482014388	0.202016714390665	0.202016714390665	false	false	false	true
e74cdc75-6f2d-4c68-9ce9-bc6b4bfe75eb	2026-10-01 15:29	2026-10-01 15:28	2026-10-01 15:28	SPXW	SPXW261001P07670000	put	7670.0000	2026-10-01	2.8000	2.8000	2.8500	7650.0000	13440.00	0.00	13440.00	48	20	65192	1738	37.5097813578826	0.192991137420826	0.192991137420826	false	false	false	true
e4653ee0-e40d-442f-b55c-fef8862e8788	2026-10-01 15:29	2026-10-01 15:28	2026-10-01 15:28	SPXW	SPXW261001P07675000	put	7675.0000	2026-10-01	4.9000	4.9000	5.0000	7650.0000	22050.00	0.00	22050.00	45	6	44913	2224	20.1946942446043	0.187385076960282	0.187435084729534	false	false	false	true
960d815d-d72d-4a29-9587-23bf8fabffc9	2026-10-01 15:28	2026-10-01 15:28	2026-10-01 15:28	SPXW	SPXW261002C07705000	call	7705.0000	2026-10-02	12.3000	12.2000	12.3000	7650.0000	20910.00	20910.00	0.00	17	5	4631	823	5.6269744835966	0.152478425642307	0.152478425642307	false	false	false	true
202d051c-b47a-44b5-a622-c0c5c1c29f78	2026-10-01 15:28	2026-10-01 15:28	2026-10-01 15:28	SPXW	SPXW261001P07675000	put	7675.0000	2026-10-01	5.0000	5.0000	5.2000	7650.0000	20000.00	0.00	20000.00	40	17	44706	2224	20.101618705036	0.181479779669718	0.181479779669718	false	false	false	true
0eea9b8d-bac9-4c4c-adcc-07a41f8b64c5	2026-10-01 15:28	2026-10-01 15:28	2026-10-01 15:28	SPXW	SPXW261001P07675000	put	7675.0000	2026-10-01	5.0000	4.8000	5.1000	7650.0000	11000.00	11000.00	0.00	22	8	44661	2224	20.0813848920863	0.181432142719678	0.181432142719678	false	false	false	true
044d8b8c-ade3-4d83-ba57-75402c23d99e	2026-10-01 15:28	2026-10-01 15:28	2026-10-01 15:28	SPXW	SPXW261001P07690000	put	7690.0000	2026-10-01	16.8000	16.6000	17.0000	7650.0000	45360.00	0.00	11760.00	27	5	4910	1552	3.16365979381443	0.177598627113694	0.177598627113694	false	false	false	true
09e7800a-9297-4614-9b36-73e0e2f10084	2026-10-01 15:28	2026-10-01 15:28	2026-10-01 15:28	SPXW	SPXW261001C07660000	call	7660.0000	2026-10-01	13.8600	13.8000	14.1000	7650.0000	69300.00	26410.00	42890.00	50	5	95203	810	117.534567901235	0.169094060207679	0.169094060207679	true	false	false	true
834e6361-06d3-44a0-ac3d-22aca4a61fd6	2026-10-01 15:28	2026-10-01 15:28	2026-10-01 15:28	SPXW	SPXW261001P07670000	put	7670.0000	2026-10-01	3.0000	3.0000	3.1000	7650.0000	13500.00	0.00	13500.00	45	27	64750	1738	37.2554660529344	0.183669383494528	0.184689051380786	false	false	false	true
74eaecb7-d897-4def-aec5-d6553b3cdd5a	2026-10-01 15:28	2026-10-01 15:28	2026-10-01 15:28	SPXW	SPXW261001C07670000	call	7670.0000	2026-10-01	6.0100	5.9000	6.1000	7650.0000	15030.00	10830.00	0.00	25	7	119678	929	128.824542518837	0.18018000877885	0.18455597205173	false	false	false	true
eadf7216-7d4c-4565-9c39-8264ab78c410	2026-10-01 15:28	2026-10-01 15:28	2026-10-01 15:28	SPXW	SPXW261005P07515000	put	7515.0000	2026-10-05	3.4000	3.4000	3.5000	7650.0000	12580.00	0.00	12580.00	37	5	323	190	1.7	0.137061127840472	0.137061127840472	true	false	false	true
d0dfa4e0-f46c-4740-b52c-3a53aba05ca6	2026-10-01 15:28	2026-10-01 15:28	2026-10-01 15:28	SPXW	SPXW261001P07675000	put	7675.0000	2026-10-01	6.2100	6.1000	6.3000	7650.0000	22350.00	1890.00	20460.00	36	11	44497	2224	20.0076438848921	0.187540192479721	0.187540192479721	false	false	false	true
9418cff2-862c-4581-aa2d-a881320f67f7	2026-10-01 15:28	2026-10-01 15:28	2026-10-01 15:28	SPXW	SPXW261002P07650000	put	7650.0000	2026-10-02	16.2900	16.2000	16.4000	7650.0000	17920.00	0.00	17920.00	11	5	6696	3173	2.11030570438071	0.163180283251114	0.162516115178617	false	false	false	true
4f49d4ab-cac4-42e5-86b1-b472cd0990d4	2026-10-01 15:28	2026-10-01 15:27	2026-10-01 15:27	SPXW	SPXW261001C07685000	call	7685.0000	2026-10-01	0.7000	0.6500	0.7000	7650.0000	21000.00	21000.00	0.00	300	17	105510	1038	101.647398843931	0.187975931184	0.187975931184	false	false	false	true
24204391-dfe7-4ec7-ace0-d769c31cdcc0	2026-10-01 15:28	2026-10-01 15:27	2026-10-01 15:27	SPXW	SPXW261001P07680000	put	7680.0000	2026-10-01	10.0000	9.7000	10.0000	7650.0000	20000.00	20000.00	0.00	20	8	24043	1065	22.5755868544601	0.210764426810951	0.210764426810951	false	false	false	true
d857e950-e01c-47b9-ab66-618d054833f8	2026-10-01 15:27	2026-10-01 15:27	2026-10-01 15:27	SPXW	SPXW261007P07380000	put	7380.0000	2026-10-07	2.1000	2.1000	2.2000	7650.0000	10500.00	0.00	10500.00	50	5	107	3095	0.0345718901453958	0.16770171218047	0.16770171218047	true	false	false	true
426a73af-ae58-4f79-9c3a-56339998089b	2026-10-01 15:27	2026-10-01 15:27	2026-10-01 15:27	SPXW	SPXW261001P07670000	put	7670.0000	2026-10-01	3.6000	3.5000	3.7000	7650.0000	10080.00	6480.00	0.00	28	5	64322	1738	37.0092059838895	0.195606890932361	0.195606890932361	false	false	false	true
bf82dcf4-e793-4d47-bd80-c0f22b363780	2026-10-01 15:27	2026-10-01 15:27	2026-10-01 15:27	SPXW	SPXW261001P07670000	put	7670.0000	2026-10-01	3.5000	3.5000	3.7000	7650.0000	10500.00	0.00	10500.00	30	13	64273	1738	36.9810126582278	0.192273310088294	0.192273310088294	false	false	false	true
c77234e0-4190-4c13-8617-2f94bf286296	2026-10-01 15:27	2026-10-01 15:27	2026-10-01 15:27	SPXW	SPXW261001C07665000	call	7665.0000	2026-10-01	9.0000	8.9000	9.0000	7650.0000	36000.00	36000.00	0.00	40	6	88409	556	159.008992805755	0.177546262640092	0.177546262640092	false	false	false	true
7871d621-c7ab-4165-8611-880a0a153a64	2026-10-01 15:27	2026-10-01 15:27	2026-10-01 15:27	SPXW	SPXW261005C07650000	call	7650.0000	2026-10-05	50.0000	50.0000	50.1000	7650.0000	250000.00	0.00	250000.00	50	6	711	239	2.97489539748954	0.11118343001356	0.11118343001356	false	false	false	true
5c1ab97c-bfc5-4a46-9c96-0923aafd0944	2026-10-01 15:27	2026-10-01 15:27	2026-10-01 15:27	SPXW	SPXW261001P07685000	put	7685.0000	2026-10-01	13.7000	13.5000	13.8000	7650.0000	13700.00	13700.00	0.00	10	5	9171	1922	4.77159209157128	0.21006419599052	0.21006419599052	false	false	false	true
25f65c87-e456-484c-b6d8-9b7c6c027a81	2026-10-01 15:27	2026-10-01 15:27	2026-10-01 15:27	SPXW	SPXW261001C07665000	call	7665.0000	2026-10-01	8.6000	8.6000	8.7000	7650.0000	15480.00	0.00	15480.00	18	7	88326	556	158.859712230216	0.180081891252879	0.180081891252879	false	false	false	true
24480183-2305-427d-abdb-243e88411cb7	2026-10-01 15:27	2026-10-01 15:27	2026-10-01 15:27	SPXW	SPXW261001P07675000	put	7675.0000	2026-10-01	6.3000	6.3000	6.4000	7650.0000	20790.00	0.00	20790.00	33	6	44225	2224	19.8853417266187	0.191822548120066	0.191822548120066	false	false	false	true
33f96ab1-73d5-4653-b876-d5ff33c4706c	2026-10-01 15:27	2026-10-01 15:27	2026-10-01 15:27	SPXW	SPXW261001P07675000	put	7675.0000	2026-10-01	6.3000	6.1000	6.4000	7650.0000	20790.00	17640.00	630.00	33	12	44037	2224	19.800809352518	0.198370620318754	0.198370620318754	false	false	false	true
47ce33e4-164f-44c1-8a28-c0b60c81d6ff	2026-10-01 15:27	2026-10-01 15:27	2026-10-01 15:27	SPXW	SPXW261001P07670000	put	7670.0000	2026-10-01	3.6000	3.5000	3.7000	7650.0000	10440.00	10080.00	360.00	29	10	63773	1738	36.6933256616801	0.199107541520635	0.199107541520635	false	false	false	true
1fff0bf2-e59b-40f6-a8e8-5d3d7e8a4557	2026-10-01 15:27	2026-10-01 15:27	2026-10-01 15:27	SPXW	SPXW261001C07660000	call	7660.0000	2026-10-01	12.8000	12.8000	12.9000	7650.0000	12800.00	0.00	12800.00	10	5	95049	810	117.344444444444	0.118147997491375	0.118147997491375	false	false	false	true
4deef05c-9aef-461f-94c2-4175544b9cdc	2026-10-01 15:26	2026-10-01 15:26	2026-10-01 15:26	SPXW	SPXW261001C07660000	call	7660.0000	2026-10-01	14.3000	14.3000	14.4000	7650.0000	42900.00	0.00	42900.00	30	5	95029	810	117.31975308642	0.167492576394655	0.167492576394655	false	false	false	true
9ac85db7-cbfe-4f3e-a770-82a63bc0523e	2026-10-01 15:26	2026-10-01 15:26	2026-10-01 15:26	SPXW	SPXW261001P07675000	put	7675.0000	2026-10-01	5.0000	5.0000	5.1000	7650.0000	10500.00	0.00	10500.00	21	6	43813	2224	19.7000899280576	0.182267489021676	0.181161434471579	false	false	false	true
6a3f86bf-520c-4e2e-8fb0-d61692b60c28	2026-10-01 15:26	2026-10-01 15:26	2026-10-01 15:26	SPXW	SPXW261007C07770000	call	7770.0000	2026-10-07	10.2000	10.0000	10.2000	7650.0000	10200.00	10200.00	0.00	10	5	856	395	2.16708860759494	0.102276935648704	0.102276935648704	false	false	false	true
67494c0f-ebde-4e9c-a61e-8e82d4886d86	2026-10-01 15:26	2026-10-01 15:26	2026-10-01 15:26	SPXW	SPXW261001C07665000	call	7665.0000	2026-10-01	10.0000	10.0000	10.1000	7650.0000	22000.00	0.00	22000.00	22	7	88217	556	158.663669064748	0.158901711025042	0.158901711025042	false	false	false	true