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

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

2497b61d-526e-4208-8929-e5cc3fed045e	2026-09-23 10:08	2026-09-23 10:08	2026-09-23 10:08	SPXW	SPXW260923P07730000	put	7730.0000	2026-09-23	9.7100	9.6000	9.8000	7731.0700	10680.00	10680.00	0.00	11	5	26313	2418	10.8821339950372	0.129378559711439	0.130633104044593	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-23T14:09:27.878659Z"}	2026-09-23	2026-09-23 21:15	2026-09-23 21:15
1d33940b-57bc-4c94-b381-239866fe51a4	2026-09-23 10:08	2026-09-23 10:08	2026-09-23 10:08	SPXW	SPXW260923P07730000	put	7730.0000	2026-09-23	9.7200	9.7000	9.9000	7731.0300	28200.00	4920.00	23280.00	29	14	26366	2418	10.904052936311	0.130395195537165	0.129140706165562	false	false	false	true
c4c7f751-9ad2-402e-9b87-d28e677d2ae9	2026-09-23 10:08	2026-09-23 10:08	2026-09-23 10:08	SPXW	SPXW260923P07730000	put	7730.0000	2026-09-23	9.7000	9.7000	9.8000	7731.4300	12610.00	0.00	12610.00	13	5	26250	2418	10.8560794044665	0.131530991335038	0.131530991335038	false	false	false	true	false
267a2c38-c7d7-414f-82f8-9a0a49395832	2026-09-23 10:08	2026-09-23 10:08	2026-09-23 10:08	SPXW	SPXW260923P07730000	put	7730.0000	2026-09-23	9.7000	9.6000	9.8000	7731.5800	26190.00	14550.00	0.00	27	6	26174	2418	10.8246484698098	0.13241969590316	0.13241969590316	false	false	false	true	false
808d8a59-7b48-4d9f-9440-6e0f8612034d	2026-09-23 10:08	2026-09-23 10:07	2026-09-23 10:07	SPXW	SPXW260923P07730000	put	7730.0000	2026-09-23	9.5100	9.4000	9.6000	7732.0500	13310.00	13310.00	0.00	14	13	26117	2418	10.8010752688172	0.132666878016319	0.133927288362667	false	false	false	true	false
89af083f-e7e4-49a8-9598-8387c4aa98c5	2026-09-23 10:07	2026-09-23 10:07	2026-09-23 10:07	SPXW	SPXW260923P07730000	put	7730.0000	2026-09-23	9.1000	9.0000	9.1000	7732.0600	18200.00	18200.00	0.00	20	8	26059	2418	10.777088502895	0.127683310997676	0.127683310997676	false	false	false	true	false
9dc16814-a7ec-4323-9212-2847ee9a3f7a	2026-09-23 10:07	2026-09-23 10:07	2026-09-23 10:07	SPXW	SPXW260923P07730000	put	7730.0000	2026-09-23	9.3100	9.2000	9.4000	7732.7100	10240.00	10240.00	0.00	11	8	25972	2418	10.7411083540116	0.133939485455383	0.135199245196631	false	false	false	true	false
20ad7767-499e-4852-a277-00ef70f14a70	2026-09-23 10:07	2026-09-23 10:07	2026-09-23 10:07	SPXW	SPXW260923P07730000	put	7730.0000	2026-09-23	9.0600	8.9000	9.2000	7732.7100	17220.00	15420.00	1800.00	19	13	25960	2418	10.7361455748553	0.131527650405888	0.13267958555992	false	false	false	true
cf0b2020-cf61-423d-8f72-a8382e8365ae	2026-09-23 10:07	2026-09-23 10:07	2026-09-23 10:07	SPXW	SPXW260923P07730000	put	7730.0000	2026-09-23	9.2000	9.0000	9.2000	7710.0000	23000.00	23000.00	0.00	25	6	25802	2418	10.6708023159636	0.131922275906241	0.131922275906241	false	false	false	true	false
596097a1-8a4f-4057-85c5-1561158201b5	2026-09-23 10:07	2026-09-23 10:07	2026-09-23 10:07	SPXW	SPXW260923P07730000	put	7730.0000	2026-09-23	9.1000	9.0000	9.1000	7710.0000	10010.00	10010.00	0.00	11	7	25766	2418	10.6559139784946	0.127649806394428	0.127649806394428	false	false	false	true	false
5861a685-c060-4b21-bcac-079ff9434fae	2026-09-23 10:07	2026-09-23 10:07	2026-09-23 10:07	SPXW	SPXW260923P07730000	put	7730.0000	2026-09-23	9.1900	9.1000	9.3000	7710.0000	10110.00	1840.00	8270.00	11	8	25741	2418	10.6455748552523	0.129247233859053	0.12925023103554	false	false	false	true
5574e367-bd47-43c5-b422-de1eb0cad8bd	2026-09-23 10:07	2026-09-23 10:07	2026-09-23 10:07	SPXW	SPXW260923P07730000	put	7730.0000	2026-09-23	9.2300	9.1000	9.3000	7710.0000	10150.00	4630.00	4600.00	11	9	25697	2418	10.6273779983457	0.132345635010756	0.128765913672651	false	false	false	true
d53f082a-c0fc-4d9c-a52c-6e35920fdf84	2026-09-23 10:07	2026-09-23 10:07	2026-09-23 10:07	SPXW	SPXW260923P07730000	put	7730.0000	2026-09-23	9.3000	9.2000	9.4000	7710.0000	10230.00	9300.00	0.00	11	6	25624	2418	10.5971877584781	0.131754818656876	0.131754818656876	false	false	false	true	false
a544064d-5191-46ab-9847-7d0dfb011bfc	2026-09-23 10:07	2026-09-23 10:07	2026-09-23 10:07	SPXW	SPXW260923P07730000	put	7730.0000	2026-09-23	9.1600	9.1000	9.3000	7710.0000	21070.00	10120.00	10030.00	23	13	25578	2418	10.5781637717122	0.132106374706395	0.13084778775986	false	false	false	true
7802f4d3-e618-4afc-89e1-65b24aa72017	2026-09-23 10:07	2026-09-23 10:07	2026-09-23 10:07	SPXW	SPXW260923P07730000	put	7730.0000	2026-09-23	8.8100	8.7000	8.9000	7710.0000	14970.00	890.00	13200.00	17	5	25497	2418	10.5446650124069	0.131421021458478	0.132683767797743	false	false	false	true
f642ee83-88aa-4307-876e-e7e8ceca97cc	2026-09-23 10:07	2026-09-23 10:06	2026-09-23 10:07	SPXW	SPXW260923P07730000	put	7730.0000	2026-09-23	8.4000	8.3000	8.5000	7710.0000	15960.00	13440.00	2520.00	19	6	25456	2418	10.5277088502895	0.129415397512055	0.129418398725018	false	false	false	true
a6d66c38-cae3-4638-a296-03a02540dcfb	2026-09-23 10:07	2026-09-23 10:06	2026-09-23 10:06	SPXW	SPXW260923P07730000	put	7730.0000	2026-09-23	8.1000	8.0000	8.1000	7710.0000	25920.00	25920.00	0.00	32	5	25377	2418	10.4950372208437	0.125600951425257	0.125600951425257	false	false	false	true	false
9bc54218-e01e-49ca-909d-da112a89b150	2026-09-23 10:07	2026-09-23 10:06	2026-09-23 10:06	SPXW	SPXW260923P07730000	put	7730.0000	2026-09-23	8.0000	8.0000	8.1000	7710.0000	14400.00	0.00	14400.00	18	11	25395	2418	10.5024813895782	0.12542883520603	0.12542883520603	false	false	false	true	false
794f390c-5838-43aa-adfd-f10155deb9a4	2026-09-23 10:06	2026-09-23 10:06	2026-09-23 10:06	SPXW	SPXW260923P07730000	put	7730.0000	2026-09-23	8.6000	8.5000	8.7000	7710.0000	21500.00	18920.00	1720.00	25	8	25113	2418	10.3858560794045	0.131970874031767	0.131970874031767	false	false	false	true
dd43e8cd-b50c-4867-8db6-e572ea9c2d2e	2026-09-23 10:06	2026-09-23 10:06	2026-09-23 10:06	SPXW	SPXW260923P07730000	put	7730.0000	2026-09-23	8.5100	8.5000	8.7000	7710.0000	13610.00	0.00	13610.00	16	9	25053	2418	10.3610421836228	0.131353042642796	0.130087909032689	false	false	false	true	false
a002aaa5-3fca-4523-b75a-87d9d0f37618	2026-09-23 10:06	2026-09-23 10:06	2026-09-23 10:06	SPXW	SPXW260923P07730000	put	7730.0000	2026-09-23	8.7000	8.6000	8.7000	7710.0000	43500.00	43500.00	0.00	50	13	25016	2418	10.3457402812242	0.133165713908241	0.133165713908241	false	false	false	true
e22087d5-14f2-4ec7-be15-f54e456c7180	2026-09-23 10:06	2026-09-23 10:06	2026-09-23 10:06	SPXW	SPXW260923P07730000	put	7730.0000	2026-09-23	9.2000	9.1000	9.2000	7710.0000	20240.00	20240.00	0.00	22	7	24802	2418	10.2572373862696	0.137828600488407	0.137828600488407	false	false	false	true	false
9bad103d-e591-48d4-8672-7dc406be6712	2026-09-23 10:06	2026-09-23 10:06	2026-09-23 10:06	SPXW	SPXW260923P07730000	put	7730.0000	2026-09-23	9.3000	9.2000	9.3000	7710.0000	36260.00	35340.00	920.00	39	11	24665	2418	10.2005789909016	0.136518244715287	0.135259080593707	false	false	false	true
054c428d-0701-4ba3-a5d5-cf89cf6c5e48	2026-09-23 10:05	2026-09-23 10:05	2026-09-23 10:05	SPXW	SPXW260923P07730000	put	7730.0000	2026-09-23	8.9000	8.8000	8.9000	7710.0000	22250.00	22250.00	0.00	25	8	24530	2418	10.1447477253929	0.130718915349632	0.130718915349632	false	false	false	true	false
7e26c624-d468-443b-ac57-952267efd8e1	2026-09-23 10:05	2026-09-23 10:05	2026-09-23 10:05	SPXW	SPXW260923P07730000	put	7730.0000	2026-09-23	8.9000	8.8000	9.0000	7710.0000	29370.00	11570.00	17800.00	33	14	24483	2418	10.1253101736973	0.131613060850425	0.131613060850425	false	false	false	true
935ab5fd-aef9-467b-94e9-7d7f19b487bd	2026-09-23 10:05	2026-09-23 10:05	2026-09-23 10:05	SPXW	SPXW260923P07730000	put	7730.0000	2026-09-23	8.7000	8.6000	8.8000	7710.0000	24370.00	880.00	14790.00	28	10	24443	2418	10.1087675765095	0.127110665127679	0.128371705972204	false	false	false	true
7e3701c3-842d-4d2f-87a0-6c713024d7f3	2026-09-23 10:05	2026-09-23 10:05	2026-09-23 10:05	SPXW	SPXW260923P07730000	put	7730.0000	2026-09-23	9.2200	9.1000	9.3000	7710.0000	12910.00	7390.00	5520.00	14	6	24367	2418	10.0773366418528	0.129253806085864	0.129253806085864	false	false	false	true
3c9362f6-481b-4cda-9bcf-822ddd7b0c9f	2026-09-23 10:05	2026-09-23 10:05	2026-09-23 10:05	SPXW	SPXW260923P07730000	put	7730.0000	2026-09-23	9.1600	9.1000	9.3000	7710.0000	10080.00	0.00	10080.00	11	6	24378	2418	10.0818858560794	0.129253806085864	0.127999584491726	false	false	false	true	false
d75cd28a-b232-45e9-9b24-415477aa1d4b	2026-09-23 10:05	2026-09-23 10:05	2026-09-23 10:05	SPXW	SPXW260923P07730000	put	7730.0000	2026-09-23	9.1600	9.0000	9.2000	7710.0000	51270.00	28520.00	22750.00	56	22	24326	2418	10.0603804797353	0.13297884482757	0.13326993649216	false	false	false	true
8780388c-ad23-47c6-ac08-1124b58e25c4	2026-09-23 10:05	2026-09-23 10:05	2026-09-23 10:05	SPXW	SPXW260923P07730000	put	7730.0000	2026-09-23	9.0000	8.9000	9.1000	7710.0000	281710.00	279910.00	1800.00	313	29	24260	2418	10.0330851943755	0.131720712069771	0.13297884482757	false	false	false	true
bfcb651a-2acb-421c-9be5-03652519cc9e	2026-09-23 10:05	2026-09-23 10:05	2026-09-23 10:05	SPXW	SPXW260923P07730000	put	7730.0000	2026-09-23	8.9100	8.8000	9.0000	7710.0000	12470.00	5350.00	1780.00	14	5	23712	2418	9.80645161290323	0.134026246190405	0.134026246190405	false	false	false	true
c8601382-8ca0-4a15-a181-d602e2b2e50f	2026-09-23 10:05	2026-09-23 10:05	2026-09-23 10:05	SPXW	SPXW260923P07730000	put	7730.0000	2026-09-23	8.5000	8.4000	8.5000	7715.0000	13600.00	13600.00	0.00	16	5	23521	2418	9.72746071133168	0.135049612796695	0.135049612796695	false	false	false	true	false
91996b1b-6208-4a45-a66c-d3321aa935a1	2026-09-23 10:05	2026-09-23 10:05	2026-09-23 10:05	SPXW	SPXW260923P07730000	put	7730.0000	2026-09-23	8.4000	8.3000	8.4000	7715.0000	11760.00	11760.00	0.00	14	5	23499	2418	9.71836228287841	0.133776670219727	0.133776670219727	false	false	false	true	false
7ab3c08a-a264-4780-9c44-7a7984618eef	2026-09-23 10:05	2026-09-23 10:05	2026-09-23 10:05	SPXW	SPXW260923P07730000	put	7730.0000	2026-09-23	8.0000	7.9000	8.0000	7715.0000	11200.00	11200.00	0.00	14	5	23424	2418	9.68734491315137	0.131125186277818	0.131125186277818	false	false	false	true	false
8bc5bfe4-5717-4b6b-8a3c-bee83e99ecf5	2026-09-23 10:04	2026-09-23 10:04	2026-09-23 10:04	SPXW	SPXW260923P07730000	put	7730.0000	2026-09-23	7.9800	7.8000	8.0000	7715.0000	10370.00	10370.00	0.00	13	7	23182	2418	9.58726220016543	0.128512653792237	0.129785044563079	false	false	false	true	false
48b12dc2-39c7-4d5f-b545-24f179104cc7	2026-09-23 10:04	2026-09-23 10:04	2026-09-23 10:04	SPXW	SPXW260923P07730000	put	7730.0000	2026-09-23	7.7100	7.7000	7.8000	7715.0000	11560.00	780.00	10780.00	15	5	23133	2418	9.56699751861042	0.126314918985989	0.128172690108996	false	false	false	true
0dd37e3c-8e58-41ec-a35a-f4c35b6dd1c6	2026-09-23 10:04	2026-09-23 10:04	2026-09-23 10:04	SPXW	SPXW260923P07730000	put	7730.0000	2026-09-23	7.7000	7.7000	7.8000	7710.0000	10780.00	0.00	10780.00	14	5	23090	2418	9.54921422663358	0.122075227771677	0.122075227771677	false	false	false	true	false
625dab53-4731-45db-b877-b5fa8d651138	2026-09-23 10:04	2026-09-23 10:04	2026-09-23 10:04	SPXW	SPXW260923P07730000	put	7730.0000	2026-09-23	8.0000	8.0000	8.1000	7710.0000	152000.00	0.00	152000.00	190	21	23023	2418	9.52150537634409	0.122976087262363	0.122535872002	false	false	false	true
1e00fc99-03bd-4e2b-8e30-59dd34890768	2026-09-23 10:04	2026-09-23 10:04	2026-09-23 10:04	SPXW	SPXW260923P07730000	put	7730.0000	2026-09-23	8.2000	8.0000	8.2000	7710.0000	24600.00	24600.00	0.00	30	7	22815	2418	9.43548387096774	0.125329884856746	0.125329884856746	false	false	false	true	false
e254eb1b-81ab-4311-ad1c-20c989588d56	2026-09-23 10:04	2026-09-23 10:04	2026-09-23 10:04	SPXW	SPXW260923P07730000	put	7730.0000	2026-09-23	8.0000	8.0000	8.1000	7710.0000	16810.00	810.00	16000.00	21	7	22758	2418	9.41191066997519	0.12179903394	0.123060087767338	false	false	false	true	false
ff0eb7fb-9409-4895-bf02-55f19f4d8f2f	2026-09-23 10:04	2026-09-23 10:04	2026-09-23 10:04	SPXW	SPXW260923P07730000	put	7730.0000	2026-09-23	8.3000	8.3000	8.4000	7710.0000	22410.00	0.00	22410.00	27	6	22733	2418	9.40157154673284	0.126187440838218	0.126187440838218	false	false	false	true	false
b55bf52d-8220-4153-92fc-c25be6481c55	2026-09-23 10:04	2026-09-23 10:04	2026-09-23 10:04	SPXW	SPXW260923P07730000	put	7730.0000	2026-09-23	8.3000	8.3000	8.4000	7710.0000	14940.00	0.00	14940.00	18	7	22631	2418	9.35938792390405	0.126187440838218	0.126187440838218	false	false	false	true	false
69c3d713-03bd-44b1-8bc3-f531a30988c4	2026-09-23 10:04	2026-09-23 10:04	2026-09-23 10:04	SPXW	SPXW260923P07730000	put	7730.0000	2026-09-23	8.3000	8.2000	8.4000	7710.0000	62260.00	9970.00	52290.00	75	13	22706	2418	9.3904052936311	0.126187440838218	0.127448263372817	false	false	false	true
0e169c96-5c5e-462d-ac3f-648c8cb59027	2026-09-23 10:04	2026-09-23 10:04	2026-09-23 10:04	SPXW	SPXW260923P07730000	put	7730.0000	2026-09-23	8.3000	8.3000	8.4000	7710.0000	22410.00	0.00	22410.00	27	5	22559	2418	9.32961124896609	0.123953375336637	0.123953375336637	false	false	false	true	false
444e2d23-b91f-4f24-adc1-6d96967015a6	2026-09-23 10:04	2026-09-23 10:04	2026-09-23 10:04	SPXW	SPXW260923P07730000	put	7730.0000	2026-09-23	8.1000	8.1000	8.2000	7734.1800	11340.00	0.00	11340.00	14	8	22363	2418	9.24855252274607	0.126359799525603	0.126359799525603	false	false	false	true	false
38392e21-c994-4f7b-b50c-4b88117e2342	2026-09-23 10:04	2026-09-23 10:04	2026-09-23 10:04	SPXW	SPXW260923P07730000	put	7730.0000	2026-09-23	8.1000	8.0000	8.2000	7733.9400	40500.00	4860.00	12960.00	50	6	22413	2418	9.26923076923077	0.125048571152422	0.125048571152422	false	false	false	true
2ef231da-e0f0-4147-a5e2-e9e4c9050dbc	2026-09-23 10:04	2026-09-23 10:03	2026-09-23 10:03	SPXW	SPXW260923P07730000	put	7730.0000	2026-09-23	8.1000	8.1000	8.2000	7734.4100	17820.00	0.00	17820.00	22	13	22283	2418	9.21546732837055	0.127591806702537	0.127591806702537	false	false	false	true
e83a1687-0d7e-496e-ba6b-b978db730c87	2026-09-23 10:03	2026-09-23 10:03	2026-09-23 10:03	SPXW	SPXW260923P07730000	put	7730.0000	2026-09-23	8.1100	8.1000	8.2000	7734.2300	13780.00	820.00	12960.00	17	6	22181	2418	9.17328370554177	0.127188867343553	0.126591287459873	false	false	false	true
da972748-6bc0-42a1-af8b-331cadeaa6f9	2026-09-23 10:03	2026-09-23 10:03	2026-09-23 10:03	SPXW	SPXW260923P07730000	put	7730.0000	2026-09-23	8.0500	7.9000	8.1000	7734.5800	19330.00	18530.00	0.00	24	12	22051	2418	9.11952026468155	0.127185256777709	0.128451957574526	false	false	false	true
0283c5b2-8a35-47f7-acfd-0db51112e753	2026-09-23 10:03	2026-09-23 10:03	2026-09-23 10:03	SPXW	SPXW260923P07730000	put	7730.0000	2026-09-23	8.0000	7.9000	8.0000	7735.2800	20790.00	20000.00	790.00	26	14	21868	2418	9.04383788254756	0.129597432959335	0.13086932012563	false	false	false	true