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.

609,118 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts609,118 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:endpoint = /api/option-trades/flow-alerts×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	expiry

8ec3b5f5-2381-4205-a23c-f38ee9ae0e2a	2026-09-30 15:55	2026-09-30 15:55	2026-09-30 15:55	SPXW	SPXW260930P07665000	put	7665.0000	2026-09-30	3.5300	3.4000	3.8000	7664.6100	42340.00	41260.00	350.00	120	24	57216	1372	41.7026239067055	0.372594574071825	0.395181007277518	false	false	false	true	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	—	—	—	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-30T19:56:14.102421Z"}	2026-09-30	2026-09-30 21:15	2026-09-30 21:15
daa6006b-3840-45b6-a98f-a61665be9217	2026-09-30 15:55	2026-09-30 15:55	2026-09-30 15:55	SPXW	SPXW260930P07670000	put	7670.0000	2026-09-30	6.8200	6.6000	7.2000	7664.7600	30020.00	15310.00	11930.00	44	22	88657	1547	57.3089851325145	0.399617682822467	0.42571721684545	false	false	false
ed35a38e-093b-4004-b7b1-88449d91abea	2026-09-30 15:55	2026-09-30 15:55	2026-09-30 15:55	SPXW	SPXW260930P07665000	put	7665.0000	2026-09-30	3.5000	3.4000	3.6000	7664.9000	13990.00	13650.00	340.00	40	12	56659	1372	41.2966472303207	0.38288615350695	0.372470666343401	false	false	false
6d9c2562-7246-4f94-a4af-4719d32f8729	2026-09-30 15:55	2026-09-30 15:55	2026-09-30 15:55	SPXW	SPXW260930C07670000	call	7670.0000	2026-09-30	2.1000	2.1000	2.1500	7664.9000	11340.00	0.00	11340.00	54	8	7097	956	7.42364016736402	0.462388478397828	0.462388478397828	false	false	false
b1695b4f-6458-4a49-afe2-e68a67e75f0b	2026-09-30 15:55	2026-09-30 15:55	2026-09-30 15:55	SPXW	SPXW260930P07670000	put	7670.0000	2026-09-30	6.0600	5.8000	6.2000	7665.0400	10900.00	9740.00	1160.00	18	12	88573	1547	57.2546864899806	0.28782688812201	0.330432407621454	false	false	false
066dad11-7940-4622-8288-e43127757dfe	2026-09-30 15:55	2026-09-30 15:55	2026-09-30 15:55	SPXW	SPXW260930C07665000	call	7665.0000	2026-09-30	4.5600	4.5000	4.7000	7665.0400	16420.00	0.00	11820.00	36	10	2923	919	3.18063112078346	0.506126968359059	0.495072733828782	false	false	false
d6b8b6d5-1946-49e8-b542-128c933a131e	2026-09-30 15:55	2026-09-30 15:55	2026-09-30 15:55	SPXW	SPXW260930P07665000	put	7665.0000	2026-09-30	3.5000	3.4000	3.5000	7664.7600	17150.00	17150.00	0.00	49	11	56505	1372	41.1844023323615	0.37296598993301	0.37296598993301	false	false	false	true
7419c186-0767-4197-a367-93bb4efb5593	2026-09-30 15:55	2026-09-30 15:55	2026-09-30 15:55	SPXW	SPXW260930P07670000	put	7670.0000	2026-09-30	6.0000	5.9000	6.2000	7665.3300	28780.00	25200.00	3580.00	48	11	88520	1547	57.2204266321913	0.344407727850229	0.344407727850229	false	false	false
70d934e9-2e48-423a-9825-62d42c3256e8	2026-09-30 15:55	2026-09-30 15:55	2026-09-30 15:55	SPXW	SPXW260930P07680000	put	7680.0000	2026-09-30	13.8000	13.7000	14.5000	7664.7600	15180.00	8280.00	6900.00	11	7	129828	2220	58.4810810810811	0	0	false	false	false	true
9974b886-4496-4e78-b82b-6c49754351a7	2026-09-30 15:55	2026-09-30 15:55	2026-09-30 15:55	SPXW	SPXW260930P07670000	put	7670.0000	2026-09-30	6.4600	6.3000	6.7000	7664.6400	20030.00	16760.00	0.00	31	16	88320	1547	57.0911441499677	0.326095418822252	0.353724927953617	false	false	false
907a7f57-1273-459a-b93e-761b6a84d8a7	2026-09-30 15:55	2026-09-30 15:55	2026-09-30 15:55	SPXW	SPXW260930P07670000	put	7670.0000	2026-09-30	6.3000	6.2000	6.3000	7664.6400	44100.00	44100.00	0.00	70	11	88264	1547	57.0549450549451	0.311835508627634	0.311835508627634	false	false	false
36747c52-ef29-45db-8597-e25dcd178b03	2026-09-30 15:55	2026-09-30 15:55	2026-09-30 15:55	SPXW	SPXW260930P07675000	put	7675.0000	2026-09-30	10.0000	9.8000	10.1000	7664.6000	25010.00	21010.00	0.00	25	6	97416	5093	19.1274298056156	0	0	false	false	false	true
21986277-214e-4305-87f4-f1294bff81b9	2026-09-30 15:55	2026-09-30 15:55	2026-09-30 15:55	SPXW	SPXW260930P07670000	put	7670.0000	2026-09-30	6.3100	6.2000	6.5000	7664.6400	15770.00	13250.00	2520.00	25	7	88289	1547	57.071105365223	0.297200011843527	0.326095418822252	false	false	false
ad312ac9-b251-4ac4-9042-73d0285286a0	2026-09-30 15:55	2026-09-30 15:55	2026-09-30 15:55	SPXW	SPXW260930P07670000	put	7670.0000	2026-09-30	6.2900	6.1000	6.3000	7664.9700	96880.00	88200.00	8680.00	154	37	87892	1547	56.814479638009	0.344433280151248	0.344433280151248	false	false	false
8a54af7a-1999-446d-badc-82fe82bbd9d3	2026-09-30 15:55	2026-09-30 15:55	2026-09-30 15:55	SPXW	SPXW260930P07670000	put	7670.0000	2026-09-30	6.2900	6.1000	6.3000	7664.5700	91260.00	86940.00	4320.00	145	37	88053	1547	56.9185520361991	0.344433280151248	0.27239982870108	true	false	false
ce96c627-d77a-47c9-a2cd-76ad9f7dd530	2026-09-30 15:55	2026-09-30 15:55	2026-09-30 15:55	SPXW	SPXW260930P07680000	put	7680.0000	2026-09-30	13.8400	13.7000	14.4000	7664.0800	138380.00	0.00	138380.00	100	10	129591	2220	58.3743243243243	0	0	false	false	false	true
77a84a54-9072-4188-9849-c3152c741c49	2026-09-30 15:55	2026-09-30 15:55	2026-09-30 15:55	SPXW	SPXW260930P07675000	put	7675.0000	2026-09-30	10.1100	9.6000	10.3000	7664.3900	16170.00	12250.00	3920.00	16	9	97313	5093	19.107205968977	0	0	false	false	false	true
ea5095a9-5f03-4fca-8629-31620c184e90	2026-09-30 15:55	2026-09-30 15:55	2026-09-30 15:55	SPXW	SPXW260930P07670000	put	7670.0000	2026-09-30	6.3000	6.2000	6.5000	7664.0600	18260.00	17640.00	620.00	29	7	87516	1547	56.5714285714286	0.230656644292776	0.230656644292776	false	false	false
32202f4d-7c17-4822-8d69-e54037daa6b2	2026-09-30 15:55	2026-09-30 15:55	2026-09-30 15:55	SPXW	SPXW260930P07675000	put	7675.0000	2026-09-30	10.4800	9.9000	10.6000	7663.4700	10480.00	9480.00	1000.00	10	6	97198	5093	19.0846259571962	0	0	false	false	false	true
225e22fb-8343-45af-a225-d8de006f87c3	2026-09-30 15:55	2026-09-30 15:55	2026-09-30 15:55	SPXW	SPXW260930P07670000	put	7670.0000	2026-09-30	6.5100	5.9000	6.7000	7663.4700	21490.00	15660.00	5830.00	33	16	87477	1547	56.546218487395	0.166338217494763	0.201077204136765	false	false	false
f0e9926e-f1b8-4c16-a700-298560317cba	2026-09-30 15:55	2026-09-30 15:55	2026-09-30 15:55	SPXW	SPXW260930C07670000	call	7670.0000	2026-09-30	2.1300	2.1000	2.3500	7664.1300	19975.00	235.00	19740.00	94	8	6320	956	6.61087866108787	0.488179159954777	0.475868308633763	false	false	false
86a8be6d-b0b2-480d-bf53-baad5f7fc0d1	2026-09-30 15:55	2026-09-30 15:55	2026-09-30 15:55	SPXW	SPXW260930P07680000	put	7680.0000	2026-09-30	15.0300	14.9000	15.7000	7664.0600	90170.00	15000.00	75170.00	60	7	129479	2220	58.3238738738739	0	0	false	false	false	true
55fd29bd-6680-4923-bff1-0dce64e5ef5d	2026-09-30 15:55	2026-09-30 15:55	2026-09-30 15:55	SPXW	SPXW260930P07670000	put	7670.0000	2026-09-30	6.9000	6.8000	7.3000	7664.0600	16550.00	1440.00	12980.00	24	11	87420	1547	56.5093729799612	0.37115593655045	0.357406303914071	false	false	false
430c48dd-54f4-43b1-8e02-799ed97464ea	2026-09-30 15:55	2026-09-30 15:55	2026-09-30 15:55	SPXW	SPXW260930P07670000	put	7670.0000	2026-09-30	6.8600	6.7000	7.2000	7664.1300	42540.00	6300.00	36240.00	62	17	87395	1547	56.4932126696833	0.321884474332077	0.336273678374238	true	false	false
062e8159-d80d-403f-a081-efa2efcb7c2e	2026-09-30 15:55	2026-09-30 15:55	2026-09-30 15:55	SPXW	SPXW260930P07665000	put	7665.0000	2026-09-30	4.2200	4.1000	4.4000	7664.1300	18570.00	4300.00	14270.00	44	7	55848	1372	40.7055393586006	0.392295701659538	0.40309045522091	false	false	false
cb29dd61-26a1-4b07-9ba5-331d4db669de	2026-09-30 15:55	2026-09-30 15:55	2026-09-30 15:55	SPXW	SPXW260930P07660000	put	7660.0000	2026-09-30	2.2600	2.2500	2.3500	7664.1200	10835.00	705.00	9900.00	48	9	52731	1447	36.441603317208	0.432576111984913	0.438402072067483	false	false	false
b038fa82-0d81-4c7d-a36b-ef1985742434	2026-09-30 15:55	2026-09-30 15:55	2026-09-30 15:55	SPXW	SPXW260930P07675000	put	7675.0000	2026-09-30	10.2900	10.2000	10.9000	7664.1200	34970.00	2160.00	32810.00	34	7	97154	5093	19.0759866483409	0	0	false	false	false	true
963c43b9-97ca-44df-9bcb-759e021dd05b	2026-09-30 15:55	2026-09-30 15:55	2026-09-30 15:55	SPXW	SPXW260930P07670000	put	7670.0000	2026-09-30	6.7900	6.6000	6.9000	7664.9400	185960.00	172730.00	11890.00	274	54	87270	1547	56.4124111182935	0.400455181499571	0.412785178807186	true	false	false
5dfa6e93-2f1f-4d58-a733-8763e389c201	2026-09-30 15:55	2026-09-30 15:55	2026-09-30 15:55	SPXW	SPXW260930P07680000	put	7680.0000	2026-09-30	15.4900	14.6000	15.5000	7664.9400	15490.00	15490.00	0.00	10	5	129398	2220	58.2873873873874	0.443928310631571	0.443928310631571	false	false	false
41d65bb6-f792-4dfb-9854-34fac08f3649	2026-09-30 15:55	2026-09-30 15:55	2026-09-30 15:55	SPXW	SPXW260930C07670000	call	7670.0000	2026-09-30	2.2500	2.1500	2.5000	7664.1200	30765.00	6970.00	23795.00	137	34	6188	956	6.47280334728034	0.462045003122739	0.50600471533733	true	false	false
3309d312-2421-4b5f-9009-fb8c9c5e18ab	2026-09-30 15:55	2026-09-30 15:55	2026-09-30 15:55	SPXW	SPXW260930P07660000	put	7660.0000	2026-09-30	2.3700	2.3000	2.4000	7664.9400	15660.00	7200.00	8460.00	66	11	52646	1447	36.3828610919143	0.469853235964684	0.475772660951025	false	false	false
09cf0bce-ca62-4d80-bbf9-f91fbc689900	2026-09-30 15:55	2026-09-30 15:55	2026-09-30 15:55	SPXW	SPXW260930P07670000	put	7670.0000	2026-09-30	6.8100	6.7000	7.2000	7664.1200	17020.00	9580.00	6740.00	25	16	87312	1547	56.4395604395604	0.320194225905276	0.305373716546752	true	false	false
08e340a6-fdb5-43bf-a61b-70c2270f88ea	2026-09-30 15:55	2026-09-30 15:55	2026-09-30 15:55	SPXW	SPXW260930P07675000	put	7675.0000	2026-09-30	10.3300	9.9000	10.7000	7664.1200	13430.00	3070.00	10360.00	13	7	97120	5093	19.0693108187709	0	0	false	false	false	true
fcbd255d-8571-4898-8ae8-1c35898e90ac	2026-09-30 15:55	2026-09-30 15:55	2026-09-30 15:55	SPXW	SPXW260930P07675000	put	7675.0000	2026-09-30	9.6600	9.4000	10.4000	7665.1000	14490.00	4780.00	9710.00	15	10	97099	5093	19.0651875122717	0.313328101849733	0.246539656218915	false	false	false
fa15eee3-c565-41b5-b202-b42c4a9a06ea	2026-09-30 15:55	2026-09-30 15:55	2026-09-30 15:55	SPXW	SPXW260930P07670000	put	7670.0000	2026-09-30	6.5500	6.3000	6.6000	7665.1000	21610.00	20350.00	1260.00	33	9	86984	1547	56.2275371687136	0.351385061067088	0.3889950336205	false	false	false
42b6c733-a60e-49a1-9fe3-2d36f5c688dc	2026-09-30 15:55	2026-09-30 15:55	2026-09-30 15:55	SPXW	SPXW260930P07670000	put	7670.0000	2026-09-30	6.4900	6.2000	6.6000	7665.1000	125250.00	116350.00	6300.00	193	39	86949	1547	56.2049127343245	0.376591014545089	0.338546377693087	false	false	false
d01b3d6f-2c57-4f78-978b-53d2b91d2c23	2026-09-30 15:55	2026-09-30 15:55	2026-09-30 15:55	SPXW	SPXW260930P07665000	put	7665.0000	2026-09-30	4.3900	4.1000	4.6000	7662.9500	17990.00	12950.00	5040.00	41	21	55506	1372	40.4562682215743	0.506410113664168	0.315435205861182	false	false	false
8b1a37cf-4087-4cef-bcb3-514c689a292a	2026-09-30 15:55	2026-09-30 15:55	2026-09-30 15:55	SPXW	SPXW260930P07655000	put	7655.0000	2026-09-30	1.2100	1.1500	1.5000	7664.2100	15510.00	8280.00	7230.00	128	20	34081	1510	22.5701986754967	0.469925166636627	0.462332226597055	false	false	false
3bd8b27d-853b-42b4-af9b-e5c518d21d4b	2026-09-30 15:55	2026-09-30 15:55	2026-09-30 15:55	SPXW	SPXW260930P07660000	put	7660.0000	2026-09-30	2.7600	2.2500	3.2000	7662.9500	34995.00	13685.00	21310.00	127	48	52350	1447	36.1782999308915	0.586480441735389	0.398329936399846	false	false	false
10ded77f-0c1d-464d-a836-55ace3c66be9	2026-09-30 15:55	2026-09-30 15:55	2026-09-30 15:55	SPXW	SPXW260930P07665000	put	7665.0000	2026-09-30	4.0600	3.7000	4.2000	7664.2100	24750.00	17350.00	3800.00	61	18	55620	1372	40.5393586005831	0.304368781884703	0.382870382235196	false	false	false
f77f3c2a-1d30-4086-8391-3abe940f7aea	2026-09-30 15:55	2026-09-30 15:55	2026-09-30 15:55	SPXW	SPXW260930P07670000	put	7670.0000	2026-09-30	6.9500	6.3000	7.4000	7662.9500	15290.00	2900.00	12390.00	22	12	86706	1547	56.0478345184228	0.51939322673979	0	true	false	false	true
f14a2be5-af23-4a31-a6a5-8d8e590c98ce	2026-09-30 15:55	2026-09-30 15:55	2026-09-30 15:55	SPXW	SPXW260930P07665000	put	7665.0000	2026-09-30	4.4100	4.2000	5.0000	7666.4000	45020.00	23850.00	21170.00	102	18	55456	1372	40.4198250728863	0.549158965265538	0.527790037152956	false	false	false
e98fb09e-5d7e-4542-977c-dd21ddd02f37	2026-09-30 15:55	2026-09-30 15:55	2026-09-30 15:55	SPXW	SPXW260930P07670000	put	7670.0000	2026-09-30	6.7700	6.3000	7.2000	7666.4000	29130.00	14610.00	13180.00	43	25	86665	1547	56.0213316095669	0.45247313673594	0.45247313673594	false	false	false
db5ff6d9-0890-42bc-8136-2cec7b509dd7	2026-09-30 15:55	2026-09-30 15:55	2026-09-30 15:55	SPXW	SPXW260930P07655000	put	7655.0000	2026-09-30	1.8900	1.1000	3.0000	7666.4000	27930.00	12415.00	15515.00	148	67	33841	1510	22.4112582781457	0.637584933583874	0.549366234190889	false	false	false
79878dc4-cd31-4f0e-b927-9eb011d1994a	2026-09-30 15:55	2026-09-30 15:55	2026-09-30 15:55	SPXW	SPXW261001C07700000	call	7700.0000	2026-10-01	10.0000	9.5000	10.2000	7666.4000	24000.00	1000.00	23000.00	24	5	7288	1072	6.79850746268657	0.141605688668276	0.141605688668276	false	false	false
729f5f26-8ef7-4da3-9a71-f5a2f501bc83	2026-09-30 15:55	2026-09-30 15:54	2026-09-30 15:55	SPXW	SPXW260930P07665000	put	7665.0000	2026-09-30	3.4600	3.0000	3.6000	7666.1900	23160.00	22230.00	620.00	67	27	55288	1372	40.2973760932945	0.413837667037879	0.442032490790154	false	false	false
62023b9f-366c-452a-b095-30c77113a2b1	2026-09-30 15:55	2026-09-30 15:55	2026-09-30 15:55	SPXW	SPXW260930P07670000	put	7670.0000	2026-09-30	5.9800	5.4000	6.0000	7666.1900	11360.00	11360.00	0.00	19	13	86612	1547	55.9870717517776	0.355985516770833	0.402391658791543	false	false	false
1e7019ba-6e7f-4bda-a9ca-6f07e4cb4949	2026-09-30 15:55	2026-09-30 15:55	2026-09-30 15:55	SPXW	SPXW260930P07660000	put	7660.0000	2026-09-30	2.5500	2.5000	3.0000	7666.4000	14300.00	1455.00	12845.00	56	14	52180	1447	36.0608154803041	0.580562408636383	0.586480441735389	false	false	false
3f6bb122-3fd3-44a2-8528-3d13b62f882a	2026-09-30 15:55	2026-09-30 15:54	2026-09-30 15:54	SPXW	SPXW260930P07670000	put	7670.0000	2026-09-30	5.4300	5.3000	5.7000	7666.5100	30940.00	21220.00	9170.00	57	27	86591	1547	55.9734970911441	0.368445054288135	0.391257764432583	false	false	false
97805a56-30dc-4252-94ed-2d7724f5be0d	2026-09-30 15:55	2026-09-30 15:54	2026-09-30 15:54	SPXW	SPXW260930P07675000	put	7675.0000	2026-09-30	8.9000	8.6000	9.1000	7667.5400	22240.00	7140.00	15100.00	25	9	96864	5093	19.0190457490673	0.437287109685128	0.395260682710823	false	false	false