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.

474,253 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts474,253 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

e15cb91a-049a-4394-a99e-46e2fa75a7d0	2026-08-27 14:02	2026-08-27 14:01	2026-08-27 14:01	SPXW	SPXW260827P07720000	put	7720.0000	2026-08-27	4.5000	4.2000	4.6000	7725.2400	125050.00	4950.00	118780.00	278	179	67087	256	262.05859375	0.145602421268209	0.145602421268209	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-08-27T18:14:24.609292Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
ba1bd65f-fac4-40b9-9a40-f84ca561265a	2026-08-27 14:02	2026-08-27 14:01	2026-08-27 14:01	SPXW	SPXW260827P07715000	put	7715.0000	2026-08-27	3.2300	2.8500	3.4000	7725.2400	107890.00	35420.00	71190.00	334	146	56515	3110	18.1720257234727	0.152809333410149	0.161311604867286	false	false	false	true	false
a0543a66-d1d7-4f08-81a4-1d09db9ae361	2026-08-27 14:02	2026-08-27 14:01	2026-08-27 14:01	SPXW	SPXW260827P07730000	put	7730.0000	2026-08-27	9.0400	8.7000	9.5000	7725.2400	201600.00	23960.00	169480.00	223	143	56759	148	383.506756756757	0.139461863339829	0.135826211421533	true	false	false	true	false
44e8fba3-dee6-4f56-821f-9af9f6509238	2026-08-27 14:02	2026-08-27 14:01	2026-08-27 14:01	SPXW	SPXW260827P07725000	put	7725.0000	2026-08-27	6.3700	6.2000	7.0000	7725.1200	195550.00	25280.00	169630.00	307	87	61332	2146	28.5796831314073	0.142733749417892	0.138403199177278	false	false	false	true	false
90a1bb0a-2008-4c4a-bf05-fce5faa9a72c	2026-08-27 14:04	2026-08-27 14:04	2026-08-27 14:04	SPXW	SPXW260828P07725000	put	7725.0000	2026-08-28	21.8000	21.6000	21.8000	7724.7100	132980.00	132980.00	0.00	61	13	2986	1539	1.94022092267706	0.136741153587351	0.136741153587351	false	false	false	true	false
a8fae9d9-76dd-4def-89f0-48098e59d89d	2026-08-27 14:06	2026-08-27 14:06	2026-08-27 14:06	SPXW	SPXW260828C07740000	call	7740.0000	2026-08-28	16.0500	15.8000	16.3000	7725.4500	104310.00	24000.00	80310.00	65	11	2906	904	3.2146017699115	0.13812116822648	0.137482732982103	false	false	false	true	false
83d30883-ac8e-4249-bf60-f643e84bef7e	2026-08-27 14:07	2026-08-27 14:06	2026-08-27 14:06	SPXW	SPXW260901C07730000	call	7730.0000	2026-09-01	32.7000	32.6000	32.7000	7724.3200	327000.00	327000.00	0.00	100	7	331	87	3.80459770114943	0.0929634134693977	0.0929634134693977	false	false	false	true	false
7e7dc0ba-e785-4eea-9c7b-c4d7e527206c	2026-08-27 14:07	2026-08-27 14:07	2026-08-27 14:07	SPXW	SPXW260827P07740000	put	7740.0000	2026-08-27	17.7000	17.7000	17.9000	7722.7000	102660.00	0.00	102660.00	58	8	27127	149	182.060402684564	0.109614438981662	0.109614438981662	false	false	false	true	false
1d9dbf39-c670-46e4-b6db-d88cef670a47	2026-08-27 14:10	2026-08-27 14:10	2026-08-27 14:10	SPXW	SPXW260827P07720000	put	7720.0000	2026-08-27	5.6000	5.4000	5.8000	7721.8000	151730.00	47550.00	90200.00	271	51	75637	256	295.45703125	0.149545661360543	0.148387314868777	false	false	false	true	false
9b7b3e4a-1965-4f44-a61d-7d1e93db0a34	2026-08-27 14:13	2026-08-27 14:13	2026-08-27 14:13	SPXW	SPXW260901C07725000	call	7725.0000	2026-09-01	34.3000	34.2000	34.4000	7722.2400	301840.00	0.00	291550.00	88	7	464	169	2.74556213017751	0.0934063957265288	0.0934063957265288	false	false	false	true	false
0f91e636-21b4-4206-a968-84fd256f6634	2026-08-27 14:13	2026-08-27 14:13	2026-08-27 14:13	SPXW	SPXW260827P07740000	put	7740.0000	2026-08-27	18.7000	18.5000	18.7000	7722.5700	235620.00	235620.00	0.00	126	14	27551	149	184.906040268456	0.153182715930509	0.153182715930509	false	false	false	true	false
9ca53584-da25-481a-b39f-80656540d3c1	2026-08-27 14:13	2026-08-27 14:13	2026-08-27 14:13	SPXW	SPXW260828P07690000	put	7690.0000	2026-08-28	11.1000	11.0000	11.1000	7720.9000	111000.00	111000.00	0.00	100	6	2263	1433	1.57920446615492	0.146972211994351	0.146972211994351	false	false	false	true	false
ab07e99a-6088-4e67-8955-c14e40a6ee49	2026-08-27 14:14	2026-08-27 14:14	2026-08-27 14:14	SPXW	SPXW260827P07725000	put	7725.0000	2026-08-27	9.6000	9.5000	9.7000	7719.4200	108470.00	0.00	108470.00	113	14	70865	2146	33.0219012115564	0.147921207159979	0.145495341495372	false	false	false	true	false
d9c17faf-7e4d-478a-9b1d-1fb783f777c1	2026-08-27 14:15	2026-08-27 14:15	2026-08-27 14:15	SPXW	SPXW260827P07725000	put	7725.0000	2026-08-27	8.4000	8.3000	8.4000	7720.8100	104160.00	104160.00	0.00	124	13	71508	2146	33.3215284249767	0.140395514765413	0.140395514765413	false	false	false	true	false
aa6e2889-34b2-4f0d-b890-c2f8b99325a8	2026-08-27 14:17	2026-08-27 14:16	2026-08-27 14:16	SPXW	SPXW260901P07720000	put	7720.0000	2026-09-01	33.7000	33.5000	33.8000	7719.5300	337000.00	337000.00	0.00	100	9	186	89	2.08988764044944	0.0983327572002	0.0983327572002	false	false	false	true	false
fc8c96d4-2662-4cdd-b65b-4e6ff0faf9d1	2026-08-27 14:18	2026-08-27 14:17	2026-08-27 14:17	SPXW	SPXW260827C07720000	call	7720.0000	2026-08-27	6.4800	6.3000	6.6000	7720.5400	141950.00	107570.00	29900.00	219	47	68410	1141	59.9561787905346	0.141103943218315	0.144400527775276	false	false	false	true	false
219f6042-f8e2-45e9-9be0-ecd9ef3127df	2026-08-27 14:18	2026-08-27 14:18	2026-08-27 14:18	SPXW	SPXW260827C07700000	call	7700.0000	2026-08-27	23.0000	22.9000	23.1000	7721.5500	103500.00	13800.00	9200.00	45	5	28037	4053	6.91759190722921	0.184940289184184	0.184940289184184	false	false	false	true	false
1d6f9bd6-8be2-4c55-ad6e-f3e2dcb8f9fa	2026-08-27 14:19	2026-08-27 14:18	2026-08-27 14:18	SPXW	SPXW260827C07720000	call	7720.0000	2026-08-27	6.7000	6.6000	6.7000	7721.3100	159460.00	159460.00	0.00	238	5	69186	1141	60.6362839614373	0.140226087589399	0.140226087589399	false	false	false	true	false
0f1c5ea6-ed19-446c-ad85-3a7cae078806	2026-08-27 14:22	2026-08-27 14:22	2026-08-27 14:22	SPXW	SPXW260901P07725000	put	7725.0000	2026-09-01	35.3000	35.2000	35.5000	7721.0100	349470.00	208270.00	141200.00	99	8	650	214	3.03738317757009	0.0979287354894836	0.0979287354894836	false	false	false	true	false
f36c1e71-e8af-467d-9cbb-a7f01c848638	2026-08-27 14:23	2026-08-27 14:23	2026-08-27 14:23	SPXW	SPXW260827C07700000	call	7700.0000	2026-08-27	21.0200	20.9000	21.3000	7719.7300	105080.00	0.00	105080.00	50	9	28330	4053	6.98988403651616	0.175876301187641	0.175876301187641	false	false	false	true	false
7244a2ea-8cb2-4f00-8e80-33fc6ed88b1c	2026-08-27 14:24	2026-08-27 14:24	2026-08-27 14:24	SPXW	SPXW260827P07720000	put	7720.0000	2026-08-27	6.2500	6.1000	6.4000	7718.6700	140020.00	140020.00	0.00	224	47	87627	256	342.29296875	0.13327493981816	0.13327493981816	false	false	false	true	false
51d71b6a-e429-401a-8c13-df4d88077508	2026-08-27 14:28	2026-08-27 14:28	2026-08-27 14:28	SPXW	SPXW260827P07720000	put	7720.0000	2026-08-27	10.7200	10.6000	11.0000	7712.6300	183260.00	5440.00	169180.00	171	93	91412	256	357.078125	0.156325660310532	0.157080013539141	false	false	false	true	false
c9084301-1384-4d9b-a968-3394b8476b4f	2026-08-27 14:28	2026-08-27 14:28	2026-08-27 14:28	SPXW	SPXW260827C07700000	call	7700.0000	2026-08-27	15.8500	15.7000	16.1000	7713.7400	126820.00	74920.00	50310.00	80	12	28940	4053	7.14038983469035	0.16753899341279	0.16408940105033	false	false	false	true	false
1c24e57e-b87c-4360-9bed-15524b22bb13	2026-08-27 14:31	2026-08-27 14:31	2026-08-27 14:31	SPXW	SPXW260828C07720000	call	7720.0000	2026-08-28	21.0000	20.9000	21.0000	7714.5600	210000.00	210000.00	0.00	100	14	4572	1919	2.38249088066701	0.144221470307077	0.1442507187356	false	false	false	true	false
2dfebd16-7416-4e88-b438-019bf39961fe	2026-08-27 14:32	2026-08-27 14:31	2026-08-27 14:31	SPXW	SPXW260901C07715000	call	7715.0000	2026-09-01	36.4000	36.3000	36.6000	7715.8700	254800.00	120120.00	134680.00	70	5	528	64	8.25	0.0941599761747416	0.0941599761747416	false	false	false	true	false
6c032e71-d8cf-4f18-970b-37d7f266e018	2026-08-27 14:32	2026-08-27 14:32	2026-08-27 14:32	SPXW	SPXW260827P07735000	put	7735.0000	2026-08-27	18.3200	18.2000	18.7000	7716.5700	100780.00	0.00	100780.00	55	6	48230	2113	22.8253667770942	0.0758138083860997	0.0758138083860997	false	false	false	true	false
15f99bdd-b04c-4cd4-bbd7-6aa6b601d24e	2026-08-27 14:33	2026-08-27 14:33	2026-08-27 14:33	SPXW	SPXW260828P07725000	put	7725.0000	2026-08-28	26.2000	26.2000	26.3000	7716.2100	104800.00	0.00	104800.00	40	7	3559	1539	2.31254061078622	0.136322890935951	0.136322890935951	false	false	false	true	false
38ad4a93-ba5e-41b4-b571-6f6c7f48e435	2026-08-27 14:34	2026-08-27 14:34	2026-08-27 14:34	SPXW	SPXW260901P07720000	put	7720.0000	2026-09-01	37.4800	37.4000	37.9000	7712.8400	374780.00	0.00	374780.00	100	21	723	89	8.12359550561798	0.0999323060758524	0.0993767168638527	false	false	false	true	false
3bf26157-524c-4149-903f-de5a526177e6	2026-08-27 14:35	2026-08-27 14:34	2026-08-27 14:34	SPXW	SPXW260901C07715000	call	7715.0000	2026-09-01	35.9900	35.7000	36.1000	7713.8400	359940.00	97140.00	262800.00	100	15	628	64	9.8125	0.0957051183809063	0.0959829619437592	false	false	false	true	false
c31bd76e-3e56-4b0f-b0d9-82b8722bc268	2026-08-27 14:35	2026-08-27 14:35	2026-08-27 14:35	SPXW	SPXW260901C07715000	call	7715.0000	2026-09-01	36.1000	36.0000	36.3000	7713.9800	361000.00	292410.00	68590.00	100	11	728	64	11.375	0.096060247232054	0.096060247232054	false	false	false	true	false
c9f91443-9805-46f1-b8eb-8d1370dbb94c	2026-08-27 14:38	2026-08-27 14:38	2026-08-27 14:38	SPXW	SPXW260901P07720000	put	7720.0000	2026-09-01	35.0000	34.8000	35.1000	7717.8900	350000.00	192500.00	49000.00	100	10	871	89	9.78651685393258	0.0997309854173824	0.0997309854173824	false	false	false	true	false
c20aca60-e151-49ff-8f20-3383f98de775	2026-08-27 14:39	2026-08-27 14:38	2026-08-27 14:38	SPXW	SPXW260827P07715000	put	7715.0000	2026-08-27	4.5000	4.4000	4.6000	7717.8000	101700.00	101250.00	0.00	226	6	85753	3110	27.5733118971061	0.15191474898224	0.151930240968632	false	false	false	true	false
832bafa4-38a9-4cfc-ac84-55b467444a44	2026-08-27 14:40	2026-08-27 14:40	2026-08-27 14:40	SPXW	SPXW260827C07700000	call	7700.0000	2026-08-27	19.3800	19.1000	19.5000	7718.4200	108510.00	108510.00	0.00	56	9	29985	4053	7.39822353811991	0.160296069414694	0.165655749899631	false	false	false	true	false
e3a8f4be-5da2-4750-897c-a5607016e8ad	2026-08-27 14:43	2026-08-27 14:43	2026-08-27 14:43	SPXW	SPXW260901P07720000	put	7720.0000	2026-09-01	35.5800	35.3000	35.7000	7717.3100	355820.00	298860.00	56960.00	100	21	1071	89	12.0337078651685	0.100329015903483	0.100606587294634	false	false	false	true	false
67aedcfe-33fa-49a6-bcee-1d2c7e9a80a8	2026-08-27 14:48	2026-08-27 14:48	2026-08-27 14:48	SPXW	SPXW260827C07715000	call	7715.0000	2026-08-27	7.3000	7.2000	7.5000	7718.3500	148960.00	138730.00	0.00	204	23	61753	1803	34.2501386577926	0.15105834952564	0.153921906753472	false	false	false	true	false
545970e3-6aa0-4e3f-8bb1-fd31b963e7a7	2026-08-27 14:48	2026-08-27 14:48	2026-08-27 14:48	SPXW	SPXW260903P07425000	put	7425.0000	2026-09-03	2.6000	2.4500	2.6000	7717.9500	703040.00	0.00	0.00	2704	7	3004	175	17.1657142857143	0.160897588852453	0.160897588852453	false	false	false	true	false
40444174-86f0-478a-911b-b2b18fb43031	2026-08-27 14:50	2026-08-27 14:50	2026-08-27 14:50	SPXW	SPXW260828C07730000	call	7730.0000	2026-08-28	15.6000	15.6000	15.7000	7712.8100	149760.00	0.00	149760.00	96	5	6926	2596	2.66795069337442	0.141816380475312	0.141816380475312	false	false	false	true	false
0dce93c9-d06c-401a-833a-3359545e48b8	2026-08-27 14:51	2026-08-27 14:51	2026-08-27 14:51	SPXW	SPXW260901C07715000	call	7715.0000	2026-09-01	35.4900	35.2000	35.7000	7713.8600	354870.00	259020.00	95850.00	100	14	1030	64	16.09375	0.0942872400804825	0.0945650898395018	false	false	false	true	false
d3cf24a8-756d-43aa-9c1e-0661154061b6	2026-08-27 14:55	2026-08-27 14:55	2026-08-27 14:55	SPXW	SPXW260915P07710000	put	7710.0000	2026-09-15	70.1000	70.0000	70.5000	7712.0100	259370.00	0.00	259370.00	37	5	155	30	5.16666666666667	0.111793023017771	0.111793023017771	false	false	false	true	false
5fda9f43-27f4-4ff9-a866-9cd8c8556f2b	2026-08-27 15:04	2026-08-27 15:04	2026-08-27 15:04	SPXW	SPXW260901P07715000	put	7715.0000	2026-09-01	31.9000	31.8000	32.0000	7717.9800	319000.00	252010.00	0.00	100	5	377	96	3.92708333333333	0.0979357885099536	0.0979357885099536	false	false	false	true	false
946a886d-f4be-46c3-ab43-0c9c791ed809	2026-08-27 15:05	2026-08-27 15:05	2026-08-27 15:05	SPXW	SPXW260828C07730000	call	7730.0000	2026-08-28	17.0000	16.9000	17.0000	7717.9000	134300.00	134300.00	0.00	79	9	7252	2596	2.79352850539291	0.13759768907286	0.13759768907286	false	false	false	true	false
bb2fabe4-ebd5-4a19-b2fd-2486eabf3d77	2026-08-27 15:05	2026-08-27 15:05	2026-08-27 15:05	SPXW	SPXW260827C07720000	call	7720.0000	2026-08-27	4.1500	3.7000	4.7000	7718.6600	139700.00	122600.00	0.00	337	108	104962	1141	91.9912357581069	0.140689351046643	0.166281156261632	false	false	false	true	false
fabd9da7-b0f7-4690-8995-179e6cce62fd	2026-08-27 15:07	2026-08-27 15:07	2026-08-27 15:07	SPXW	SPXW260828C07730000	call	7730.0000	2026-08-28	17.2300	17.1000	17.4000	7718.6200	172320.00	27520.00	89440.00	100	15	7418	2596	2.85747303543914	0.137566680400896	0.136935302339062	false	false	false	true	false
186a44f7-64af-43f4-b490-4371cde7c290	2026-08-27 15:07	2026-08-27 15:07	2026-08-27 15:07	SPXW	SPXW260901C07720000	call	7720.0000	2026-09-01	34.6100	34.5000	34.9000	7718.5900	346060.00	152240.00	193820.00	100	14	1243	130	9.56153846153846	0.092415886291772	0.092387317668023	false	false	false	true	false
00ec07b9-8e15-4db9-8591-6830836bf694	2026-08-27 15:08	2026-08-27 15:08	2026-08-27 15:08	SPXW	SPXW260925C07720000	call	7720.0000	2026-09-25	110.6000	110.2000	110.6000	7716.4600	608300.00	608300.00	0.00	55	6	241	95	2.53684210526316	0.115961874578433	0.115961874578433	false	false	false	true	false
68279ae2-123f-4609-9dd1-659e77ed73f4	2026-08-27 15:09	2026-08-27 15:09	2026-08-27 15:09	SPXW	SPXW260828C07730000	call	7730.0000	2026-08-28	17.6500	17.6000	17.9000	7719.9100	176480.00	0.00	176480.00	100	18	7556	2596	2.91063174114022	0.136589465508872	0.136589465508872	false	false	false	true	false
d32f82ac-6e71-4efa-988f-4aa125f91d84	2026-08-27 15:10	2026-08-27 15:10	2026-08-27 15:10	SPXW	SPXW260827C07700000	call	7700.0000	2026-08-27	20.2000	20.1000	20.6000	7720.5800	228260.00	177760.00	50500.00	113	11	31638	4053	7.8060695780903	0.153664422020737	0.153664422020737	false	false	false	true	false
7fcab5cc-83d1-4c38-aecb-0a49f40124e8	2026-08-27 15:14	2026-08-27 15:14	2026-08-27 15:14	SPXW	SPXW260901P07720000	put	7720.0000	2026-09-01	32.9000	32.8000	33.0000	7700.0000	167790.00	23030.00	23030.00	51	7	1538	89	17.2808988764045	0.0979985355435947	0.0979985355435947	false	false	false	true	false
53b98e29-bc0d-4e8c-98b5-48e592d9a443	2026-08-27 15:18	2026-08-27 15:17	2026-08-27 15:17	SPXW	SPXW260901C07725000	call	7725.0000	2026-09-01	31.9000	31.6000	32.0000	7695.0000	319000.00	232870.00	86130.00	100	13	982	169	5.81065088757396	0.0911496090623451	0.0911496090623451	false	false	false	true	false
d2d1ef98-fa6d-4292-8d97-c4a6eb68a0c7	2026-08-27 15:18	2026-08-27 15:18	2026-08-27 15:18	SPXW	SPXW260828P07650000	put	7650.0000	2026-08-28	4.6700	4.5000	4.8000	7695.0000	232780.00	209630.00	7050.00	498	29	5516	3833	1.43908165927472	0.159886085508478	0.161106202869811	false	false	false	true	false