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:ticker = SPXW×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	price

a80dc204-0958-46a1-8da9-684bf7900c61	2026-09-02 10:38	2026-09-02 10:38	2026-09-02 10:38	SPXW	SPXW260909P07670000	put	7670.0000	2026-09-09	40.2200	40.2000	40.5000	7672.2900	100560.00	0.00	100560.00	25	7	178	223	0.798206278026906	0.10424058233968	0.104003924106724	false	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	—	—	—	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-02T14:46:18.296261Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
a5565cd3-a5ac-4375-ba24-f3855045e500	2026-09-02 10:40	2026-09-02 10:39	2026-09-02 10:39	SPXW	SPXW260904C07625000	call	7625.0000	2026-09-04	66.1000	65.6000	66.5000	7675.4700	231350.00	132200.00	0.00	35	8	647	1450	0.446206896551724	0.151204119542973	0.149997339076041	false	false	false	true	false
893e58f5-08d9-4df5-bd5e-bcca4d4f97f0	2026-09-02 10:40	2026-09-02 10:39	2026-09-02 10:39	SPXW	SPXW260904C07625000	call	7625.0000	2026-09-04	66.1000	65.6000	66.7000	7675.1600	1176580.00	548630.00	462700.00	178	24	612	1450	0.422068965517241	0.151204119542973	0.151204119542973	false	false	false	true	false
8986efc8-b2dd-4577-baca-58c401591d2d	2026-09-02 10:40	2026-09-02 10:40	2026-09-02 10:40	SPXW	SPXW260904C07625000	call	7625.0000	2026-09-04	66.1000	65.8000	66.7000	7675.7400	264400.00	99150.00	165250.00	40	8	717	1450	0.49448275862069	0.148937300383923	0.148937300383923	false	false	false	true	false
1c904b29-1ea3-4124-9285-7ae127b26a74	2026-09-02 10:40	2026-09-02 10:40	2026-09-02 10:40	SPXW	SPXW260904C07625000	call	7625.0000	2026-09-04	66.1000	65.8000	66.7000	7675.7400	264400.00	33050.00	231350.00	40	8	757	1450	0.522068965517241	0.148937300383923	0.148937300383923	false	false	false	true	false
b0251334-9bf4-4bbc-b1e4-f17189751103	2026-09-02 10:40	2026-09-02 10:40	2026-09-02 10:40	SPXW	SPXW260902P07655000	put	7655.0000	2026-09-02	3.9900	3.9000	4.1000	7676.8200	128130.00	7600.00	101330.00	321	47	13354	413	32.3341404358354	0.157945243631968	0.157945243631968	false	false	false	true	false
937bae1b-697e-487a-81c4-7c15c7b4277d	2026-09-02 10:41	2026-09-02 10:40	2026-09-02 10:40	SPXW	SPXW260904C07625000	call	7625.0000	2026-09-04	67.1000	66.6000	67.7000	7677.0100	201300.00	33550.00	33550.00	30	7	1109	1450	0.764827586206897	0.149284809068727	0.149284809068727	false	false	false	true	false
1cb1040c-4432-414b-a585-96c9e3e07e9e	2026-09-02 10:41	2026-09-02 10:40	2026-09-02 10:40	SPXW	SPXW260904C07625000	call	7625.0000	2026-09-04	67.1000	66.5000	67.7000	7676.9500	234850.00	33550.00	167750.00	35	8	1074	1450	0.740689655172414	0.149524532617389	0.149524532617389	false	false	false	true	false
d704f0d8-be71-48e8-ba8f-989f786297e8	2026-09-02 10:41	2026-09-02 10:41	2026-09-02 10:41	SPXW	SPXW260911C07675000	call	7675.0000	2026-09-11	58.3000	58.0000	58.4000	7677.8600	145750.00	58300.00	87450.00	25	5	163	419	0.389021479713604	0.110421548498292	0.110421548498292	false	false	false	true	false
0b1edda4-7c45-4705-87d2-68403e93f009	2026-09-02 10:42	2026-09-02 10:42	2026-09-02 10:42	SPXW	SPXW260904C07625000	call	7625.0000	2026-09-04	67.1000	66.5000	67.7000	7677.3400	637450.00	161040.00	442860.00	95	14	1209	1450	0.833793103448276	0.149204802885218	0.147958322692076	false	false	false	true	false
ca32d096-c8e7-4e8b-99e9-a647e85f77ee	2026-09-02 10:42	2026-09-02 10:42	2026-09-02 10:42	SPXW	SPXW260904C07625000	call	7625.0000	2026-09-04	68.1000	67.6000	68.4000	7678.4900	170250.00	40860.00	129390.00	25	8	1264	1450	0.871724137931035	0.14874986980166	0.14874986980166	false	false	false	true	false
9ddcadbb-e01f-400a-a001-cf7b6b543ca7	2026-09-02 10:42	2026-09-02 10:42	2026-09-02 10:42	SPXW	SPXW260904C07625000	call	7625.0000	2026-09-04	68.1000	67.5000	68.4000	7678.4200	136200.00	68100.00	68100.00	20	6	1239	1450	0.85448275862069	0.149035497837246	0.149035497837246	false	false	false	true	false
fa499d36-9a41-4dee-b6f2-d7d8402c208d	2026-09-02 10:42	2026-09-02 10:42	2026-09-02 10:42	SPXW	SPXW260903C07720000	call	7720.0000	2026-09-03	6.0000	5.9000	6.0000	7678.8000	128400.00	128400.00	0.00	214	15	1543	1244	1.2403536977492	0.124685387754335	0.124685387754335	false	false	false	true	false
720b593e-166d-4311-ae45-dd9a770aebd1	2026-09-02 10:42	2026-09-02 10:42	2026-09-02 10:42	SPXW	SPXW260911C07675000	call	7675.0000	2026-09-11	58.7000	58.6000	59.0000	7679.0200	146750.00	0.00	146750.00	25	6	188	419	0.448687350835322	0.10995958330173	0.10995958330173	false	false	false	true	false
2ae760ea-4008-4603-bf89-29e1fb761bb9	2026-09-02 10:43	2026-09-02 10:43	2026-09-02 10:43	SPXW	SPXW260911C07700000	call	7700.0000	2026-09-11	44.2000	44.0000	44.3000	7678.2800	154700.00	154700.00	0.00	35	5	572	2659	0.215118465588567	0.106103604579378	0.106103604579378	false	false	false	true	false
35c68a81-5aeb-4b33-8222-188c9f049ee6	2026-09-02 10:44	2026-09-02 10:44	2026-09-02 10:44	SPXW	SPXW260902C07690000	call	7690.0000	2026-09-02	5.5600	5.4000	5.7000	7678.7900	221350.00	164560.00	51290.00	398	53	28669	1911	15.0020931449503	0.135516838003534	0.135429591873628	false	false	false	true	false
c32d1991-36dd-42c6-a6a5-d4bb181f180e	2026-09-02 10:44	2026-09-02 10:44	2026-09-02 10:44	SPXW	SPXW260902C07680000	call	7680.0000	2026-09-02	10.0000	9.9000	10.1000	7679.5500	100000.00	74000.00	26000.00	100	11	32506	3405	9.54654919236417	0.134992810776064	0.134992810776064	false	false	false	true	false
af522b9e-fdb8-4c04-aef2-02e59bfa3085	2026-09-02 10:47	2026-09-02 10:47	2026-09-02 10:47	SPXW	SPXW260902P07675000	put	7675.0000	2026-09-02	9.9000	9.9000	10.0000	7676.0900	114840.00	0.00	114840.00	116	11	8302	818	10.1491442542787	0.140393818055705	0.1408447556759	false	false	false	true	false
a8ffa88e-8fcd-452b-9126-665851883ffd	2026-09-02 10:48	2026-09-02 10:48	2026-09-02 10:48	SPXW	SPXW260902P07640000	put	7640.0000	2026-09-02	2.2000	2.1500	2.2500	7675.8500	100540.00	55660.00	44880.00	457	51	31634	1080	29.2907407407407	0.174459886821049	0.174459886821049	false	false	false	true	false
7f89c0b2-5a6d-481d-99d0-b2287ec239da	2026-09-02 10:48	2026-09-02 10:48	2026-09-02 10:48	SPXW	SPXW260902P07640000	put	7640.0000	2026-09-02	2.3000	2.2000	2.3500	7675.8100	107570.00	66635.00	37490.00	468	44	32165	1080	29.7824074074074	0.175695417712006	0.176786848638337	false	false	false	true	false
10287584-3c6f-4cdf-95d6-03273606a505	2026-09-02 10:48	2026-09-02 10:48	2026-09-02 10:48	SPXW	SPXW260902C07655000	call	7655.0000	2026-09-02	23.7000	23.6000	24.0000	7675.6100	118520.00	23700.00	94820.00	50	11	25002	719	34.7732962447844	0.137294450177758	0.135417695154865	false	false	false	true	false
60d36a84-58ea-473f-9e44-f8e08ec505d0	2026-09-02 10:49	2026-09-02 10:49	2026-09-02 10:49	SPXW	SPXW260902C07690000	call	7690.0000	2026-09-02	3.4500	3.4000	3.6000	7674.2800	151880.00	360.00	150470.00	440	57	32121	1911	16.8084772370487	0.124578431326832	0.124440920751575	false	false	false	true	false
76e8a9c1-8466-4928-8519-f51aac554928	2026-09-02 10:49	2026-09-02 10:49	2026-09-02 10:49	SPXW	SPXW260903C07720000	call	7720.0000	2026-09-03	4.6000	4.5000	4.7000	7673.8200	339020.00	276000.00	11500.00	737	12	2606	1244	2.09485530546624	0.120746888692456	0.120746888692456	false	false	false	true	false
c98c5643-9fad-4036-ba52-38c3959444c2	2026-09-02 10:49	2026-09-02 10:49	2026-09-02 10:49	SPXW	SPXW260902P07675000	put	7675.0000	2026-09-02	10.3000	10.2000	10.4000	7674.0400	110210.00	0.00	109180.00	107	8	9574	818	11.7041564792176	0.133142967426294	0.133142967426294	false	false	false	true	false
b5ea2ca8-0877-4104-b4bb-97f9e32dbb2d	2026-09-02 10:51	2026-09-02 10:50	2026-09-02 10:50	SPXW	SPXW260902C07685000	call	7685.0000	2026-09-02	4.3600	4.3000	4.5000	7672.8700	175090.00	880.00	169370.00	402	41	32810	1931	16.991196271362	0.124194714328043	0.121814236918859	false	false	false	true	false
051a227a-5bb0-4497-b2a7-f12633a8e9d8	2026-09-02 10:51	2026-09-02 10:51	2026-09-02 10:51	SPXW	SPXW260902P07670000	put	7670.0000	2026-09-02	9.3800	9.2000	9.5000	7672.3900	191450.00	172730.00	3720.00	204	42	16204	650	24.9292307692308	0.142021074130086	0.143375847556896	false	false	false	true	false
e27e8bee-9f70-442b-9c37-bbfa20acc867	2026-09-02 10:51	2026-09-02 10:51	2026-09-02 10:51	SPXW	SPXW260902P07655000	put	7655.0000	2026-09-02	4.5000	4.4000	4.6000	7671.9700	114290.00	9000.00	99890.00	254	49	16653	413	40.3220338983051	0.148726312657873	0.148726312657873	false	false	false	true	false
e5f3f884-a9f9-4401-be09-c35f2a088443	2026-09-02 10:51	2026-09-02 10:51	2026-09-02 10:51	SPXW	SPXW260902P07660000	put	7660.0000	2026-09-02	5.5800	5.5000	5.7000	7672.7300	125020.00	0.00	123900.00	224	39	22522	703	32.0369843527738	0.146533665097411	0.145021012926283	true	false	false	true	false
91a07ebc-5d96-4b80-b7b1-dfea9c271832	2026-09-02 10:53	2026-09-02 10:52	2026-09-02 10:52	SPXW	SPXW260902P07660000	put	7660.0000	2026-09-02	5.3100	5.2000	5.5000	7672.7900	103610.00	10070.00	93540.00	195	38	23024	703	32.75106685633	0.144071492683348	0.144071492683348	false	false	false	true	false
3a3ee0a3-7d7f-4f91-955e-ce7d8dc67af7	2026-09-02 10:53	2026-09-02 10:53	2026-09-02 10:53	SPXW	SPXW260902P07660000	put	7660.0000	2026-09-02	5.5000	5.4000	5.5000	7672.6900	100100.00	100100.00	0.00	182	27	23235	703	33.0512091038407	0.145148428294911	0.145148428294911	false	false	false	true	false
f44cb6b7-a2f2-4b54-b025-3af955cee229	2026-09-02 10:53	2026-09-02 10:53	2026-09-02 10:53	SPXW	SPXW260902P07660000	put	7660.0000	2026-09-02	5.6700	5.6000	5.8000	7671.5400	114480.00	0.00	114480.00	202	43	23528	703	33.4679943100996	0.142692648053431	0.142692648053431	true	false	false	true	false
3ddecaec-debc-4e52-a730-8bbc7c123c9e	2026-09-02 10:53	2026-09-02 10:53	2026-09-02 10:53	SPXW	SPXW260902P07660000	put	7660.0000	2026-09-02	5.9000	5.8000	6.0000	7670.7000	119180.00	12980.00	105610.00	202	46	23785	703	33.8335704125178	0.14155154722618	0.141555352432056	false	false	false	true	false
763b44a3-aa2f-4bde-8007-481f0dc3ae14	2026-09-02 10:54	2026-09-02 10:54	2026-09-02 10:54	SPXW	SPXW260902P07660000	put	7660.0000	2026-09-02	5.8000	5.7000	5.9000	7671.2000	116580.00	27840.00	40600.00	201	31	24084	703	34.2588904694168	0.142635719500558	0.142635719500558	false	false	false	true	false
cf7c6759-ebad-494d-86af-80e7fc726ad4	2026-09-02 10:54	2026-09-02 10:54	2026-09-02 10:54	SPXW	SPXW260902P07660000	put	7660.0000	2026-09-02	5.8000	5.7000	5.9000	7671.3700	118320.00	117740.00	0.00	204	5	24378	703	34.6770981507824	0.143564528212677	0.143564528212677	false	false	false	true	false
5adad556-a969-4447-8630-586657adb246	2026-09-02 10:54	2026-09-02 10:54	2026-09-02 10:54	SPXW	SPXW260902P07660000	put	7660.0000	2026-09-02	5.7600	5.7000	5.9000	7671.3300	115840.00	590.00	113510.00	201	35	24582	703	34.9672830725462	0.143370842570659	0.141878984135427	true	false	false	true	false
48f0355a-365a-45f7-9b26-6a27b692afd1	2026-09-02 10:54	2026-09-02 10:54	2026-09-02 10:54	SPXW	SPXW260902C07670000	call	7670.0000	2026-09-02	10.2600	10.0000	10.3000	7671.4900	142590.00	142590.00	0.00	139	36	38969	2579	15.1101202016285	0.126734803550482	0.128094249662849	false	false	false	true	false
467b6611-3370-4e6b-94e3-ff2ca696dab8	2026-09-02 10:54	2026-09-02 10:54	2026-09-02 10:54	SPXW	SPXW260902C07670000	call	7670.0000	2026-09-02	10.2500	10.1000	10.3000	7671.4900	113810.00	106670.00	0.00	111	8	39080	2579	15.153160139589	0.126734803550482	0.126734803550482	false	false	false	true	false
4249364a-b37c-482f-bec8-eb612808e6c2	2026-09-02 10:54	2026-09-02 10:54	2026-09-02 10:54	SPXW	SPXW260902P07680000	put	7680.0000	2026-09-02	15.0000	14.9000	15.0000	7670.9300	183000.00	183000.00	0.00	122	16	5417	412	13.1480582524272	0.134487653987237	0.134491240103741	false	false	false	true	false
20705e83-7928-4a7a-a823-11e77f95ba38	2026-09-02 10:55	2026-09-02 10:54	2026-09-02 10:54	SPXW	SPXW260902P07660000	put	7660.0000	2026-09-02	5.9500	5.8000	6.1000	7669.9600	221240.00	91210.00	106920.00	372	120	25257	703	35.927453769559	0.139555500666262	0.13809158964836	true	false	false	true	false
3846d2ae-0caa-40db-94e4-6b4355c861de	2026-09-02 10:55	2026-09-02 10:55	2026-09-02 10:55	SPXW	SPXW260902P07675000	put	7675.0000	2026-09-02	10.9000	10.8000	11.0000	7671.9200	216910.00	154780.00	61040.00	199	24	11885	818	14.5293398533007	0.125645699414031	0.127151998018293	false	false	false	true	false
15c540bc-cc99-4853-963f-9372f2f997eb	2026-09-02 10:55	2026-09-02 10:55	2026-09-02 10:55	SPXW	SPXW260902P07660000	put	7660.0000	2026-09-02	5.5600	5.5000	5.7000	7671.7500	111160.00	0.00	94360.00	200	32	25619	703	36.4423897581792	0.143705661036421	0.141125905637078	true	false	false	true	false
26b35f9c-9683-467e-8fc8-eb69191d6555	2026-09-02 10:55	2026-09-02 10:55	2026-09-02 10:55	SPXW	SPXW260902P07660000	put	7660.0000	2026-09-02	5.5000	5.4000	5.7000	7671.9200	111070.00	0.00	105000.00	202	42	26095	703	37.1194879089616	0.143559105871534	0.140535405989472	true	false	false	true	false
a88af62f-5adc-47a8-adb4-93aa7d16b56a	2026-09-02 10:56	2026-09-02 10:55	2026-09-02 10:55	SPXW	SPXW260902P07660000	put	7660.0000	2026-09-02	5.5600	5.5000	5.7000	7672.2300	115110.00	560.00	103350.00	207	43	26331	703	37.4551920341394	0.145107011624369	0.145107011624369	false	false	false	true	false
94af0eed-e96e-4316-b310-44a35027b0f7	2026-09-02 10:56	2026-09-02 10:56	2026-09-02 10:56	SPXW	SPXW260902C07670000	call	7670.0000	2026-09-02	10.5000	10.5000	10.7000	7672.2800	105000.00	0.00	105000.00	100	25	39740	2579	15.4090732842187	0.125339270841017	0.125339270841017	false	false	false	true	false
9317c792-35ef-472d-b629-e7f17eb553a1	2026-09-02 10:56	2026-09-02 10:56	2026-09-02 10:56	SPXW	SPXW260902P07660000	put	7660.0000	2026-09-02	5.7000	5.6000	5.7000	7671.8800	116260.00	115140.00	1120.00	204	20	26771	703	38.0810810810811	0.14498405756707	0.14498405756707	false	false	false	true	false
74232d27-69e7-4bab-8254-ef3273fa3cc4	2026-09-02 10:56	2026-09-02 10:56	2026-09-02 10:56	SPXW	SPXW260902P07660000	put	7660.0000	2026-09-02	5.5000	5.4000	5.5000	7672.2700	107800.00	107800.00	0.00	196	18	26558	703	37.778093883357	0.143851574367619	0.143855475195357	false	false	false	true	false
bb7a6bf0-d062-42b2-911a-92575ffef582	2026-09-02 10:57	2026-09-02 10:56	2026-09-02 10:56	SPXW	SPXW260902P07675000	put	7675.0000	2026-09-02	11.9300	11.8000	12.0000	7670.9800	299410.00	245880.00	2360.00	251	45	12722	818	15.5525672371638	0.134084845055689	0.132707582790094	false	false	false	true	false
0984b461-7263-4b12-9f85-60ea71207771	2026-09-02 10:57	2026-09-02 10:57	2026-09-02 10:57	SPXW	SPXW260902C07665000	call	7665.0000	2026-09-02	12.9000	12.7000	13.0000	7671.0600	107060.00	99330.00	6450.00	83	41	28983	1192	24.3145973154362	0.128918124977013	0.128921756573356	false	false	false	true	false
da451b58-6791-46fb-83d9-74d623ff1251	2026-09-02 10:58	2026-09-02 10:58	2026-09-02 10:58	SPXW	SPXW260902P07665000	put	7665.0000	2026-09-02	6.8900	6.7000	7.0000	7672.2800	117200.00	94480.00	13750.00	170	81	17899	727	24.6203576341128	0.137632409638805	0.139060052553268	false	false	false	true	false
f4f68bdd-f0d5-421a-b5d2-41097df1a329	2026-09-02 11:00	2026-09-02 11:00	2026-09-02 11:00	SPXW	SPXW260902P07675000	put	7675.0000	2026-09-02	12.7900	12.6000	12.9000	7669.0200	162460.00	103680.00	6300.00	127	16	13854	818	16.9364303178484	0.128772121557137	0.131591544238829	false	false	false	true	false