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

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

a21a02ac-5050-41ee-ac22-1b2028a4be82	2026-09-28 15:40	2026-09-28 15:40	2026-09-28 15:40	SPXW	SPXW260928P07710000	put	7710.0000	2026-09-28	27.7000	27.6500	28.1000	7660.0000	27700.00	0.00	27700.00	10	7	37910	1846	20.5362946912243	0.208405530863211	0.208405530863211	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	—	—	—	—	—	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-28T19:41:20.736872Z"}	2026-09-28	2026-09-28 21:15	2026-09-28 21:15
e8581c90-0b28-454e-817b-81b5a8e83701	2026-09-28 14:58	2026-09-28 14:57	2026-09-28 14:57	SPXW	SPXW260928P07710000	put	7710.0000	2026-09-28	13.0000	12.9000	13.0000	7699.3400	39000.00	39000.00	0.00	30	5	36704	1846	19.8829902491874	0.18905207871914	0.18905207871914	false	false	false	true	false
5cba8109-fbd5-4e86-acca-1c902d97e4d4	2026-09-28 14:51	2026-09-28 14:51	2026-09-28 14:51	SPXW	SPXW260928P07710000	put	7710.0000	2026-09-28	13.5000	13.4000	13.5000	7699.1400	40500.00	40500.00	0.00	30	6	36295	1846	19.6614301191766	0.192163205484034	0.192163205484034	false	false	false	true
ddfcf64c-3e55-4cc0-8031-6d555aad1c51	2026-09-28 14:51	2026-09-28 14:51	2026-09-28 14:51	SPXW	SPXW260928P07710000	put	7710.0000	2026-09-28	12.9900	12.7000	13.0000	7700.0300	38960.00	38960.00	0.00	30	9	36257	1846	19.6408450704225	0.193546151484548	0.193546151484548	false	false	false	true
bf09a69d-d3f9-45e1-bf95-e3a6e5ef0533	2026-09-28 14:50	2026-09-28 14:50	2026-09-28 14:50	SPXW	SPXW260928P07710000	put	7710.0000	2026-09-28	12.1000	12.1000	12.3000	7701.0100	30260.00	0.00	29040.00	25	5	36126	1846	19.5698808234019	0.188749133764154	0.191990656262954	false	false	false	true
94266fcc-7fe5-4b2f-82df-80236c45a699	2026-09-28 14:50	2026-09-28 14:49	2026-09-28 14:49	SPXW	SPXW260928P07710000	put	7710.0000	2026-09-28	12.2300	12.2000	12.4000	7701.2100	12230.00	0.00	8540.00	10	5	36097	1846	19.5541711809317	0.199602899825881	0.196414727304482	false	false	false	true
0bb54d68-3d45-45f2-9e10-5c9b9340255f	2026-09-28 14:45	2026-09-28 14:45	2026-09-28 14:45	SPXW	SPXW260928P07710000	put	7710.0000	2026-09-28	13.3000	13.0000	13.3000	7699.2000	53200.00	53200.00	0.00	40	7	35939	1846	19.4685807150596	0.179868265079407	0.179868265079407	false	false	false	true
31601190-61ef-4b51-90a8-9ed11d726e0a	2026-09-28 14:23	2026-09-28 14:23	2026-09-28 14:23	SPXW	SPXW260928P07710000	put	7710.0000	2026-09-28	12.8000	12.7000	12.9000	7700.6900	12800.00	2560.00	0.00	10	6	34966	1846	18.9414951245937	0.17386476046664	0.17386476046664	false	false	false	true	false
a0aaa453-afe3-4273-bb40-19cf2d5b421c	2026-09-28 14:11	2026-09-28 14:11	2026-09-28 14:11	SPXW	SPXW260928P07710000	put	7710.0000	2026-09-28	11.7000	11.7000	11.9000	7702.3500	23400.00	0.00	23400.00	20	5	34288	1846	18.5742145178765	0.164951756096415	0.164951756096415	false	false	false	true
8eb52585-319c-4a92-aaca-607cbdf75298	2026-09-28 14:09	2026-09-28 14:09	2026-09-28 14:09	SPXW	SPXW260928P07710000	put	7710.0000	2026-09-28	12.0000	11.9000	12.1000	7680.0000	12000.00	0.00	10800.00	10	6	34138	1846	18.4929577464789	0.16470528758842	0.16470528758842	false	false	false	true	false
e876c7f3-cd73-46a2-a2a2-7c95f4ebc901	2026-09-28 14:09	2026-09-28 14:09	2026-09-28 14:09	SPXW	SPXW260928P07710000	put	7710.0000	2026-09-28	12.1900	12.0000	12.3000	7680.0000	12190.00	9750.00	0.00	10	5	34127	1846	18.4869989165764	0.162793510303706	0.167759080639939	false	false	false	true
fc50dba6-4bc7-420b-a3bc-174f2d927ac5	2026-09-28 14:06	2026-09-28 14:06	2026-09-28 14:06	SPXW	SPXW260928P07710000	put	7710.0000	2026-09-28	12.8000	12.8000	13.0000	7680.0000	12800.00	0.00	12800.00	10	5	34000	1846	18.4182015167931	0.173984834186818	0.173984834186818	false	false	false	true
e44377b6-47ae-4b1f-8e50-96cf90bdf67f	2026-09-28 14:06	2026-09-28 14:06	2026-09-28 14:06	SPXW	SPXW260928P07710000	put	7710.0000	2026-09-28	13.0000	12.9000	13.0000	7680.0000	39000.00	39000.00	0.00	30	10	33985	1846	18.4100758396533	0.180518047880325	0.180531156235351	false	false	false	true
6993351f-adc3-4e6d-b708-5280661abb5b	2026-09-28 14:05	2026-09-28 14:05	2026-09-28 14:05	SPXW	SPXW260928P07710000	put	7710.0000	2026-09-28	11.8000	11.6000	11.8000	7680.0000	11800.00	11800.00	0.00	10	5	33898	1846	18.3629469122427	0.174671260499731	0.174671260499731	false	false	false	true
71079cae-f25a-4ed9-9afb-b6ef5460a7ed	2026-09-28 13:56	2026-09-28 13:56	2026-09-28 13:56	SPXW	SPXW260928P07710000	put	7710.0000	2026-09-28	12.5200	12.4000	12.8000	7702.4600	20040.00	7540.00	0.00	16	6	33378	1846	18.0812567713976	0.174901925465175	0.179430395705988	false	false	false	true
6a5b4e4f-3619-4c51-a1b7-a77aedf057cb	2026-09-28 13:55	2026-09-28 13:55	2026-09-28 13:55	SPXW	SPXW260928P07710000	put	7710.0000	2026-09-28	14.0400	13.0000	15.0000	7701.6200	61780.00	61780.00	0.00	44	5	33279	1846	18.0276273022752	0.191221135814796	0.195734895584704	false	false	false	true
946fdab7-3545-46d6-ba74-faa50538156f	2026-09-28 13:52	2026-09-28 13:52	2026-09-28 13:52	SPXW	SPXW260928P07710000	put	7710.0000	2026-09-28	12.9000	12.7000	12.9000	7702.1100	25800.00	25800.00	0.00	20	6	33052	1846	17.9046587215601	0.175910500549838	0.175910500549838	false	false	false	true
5421758a-c66f-4ca9-866e-7604477698fa	2026-09-28 13:51	2026-09-28 13:51	2026-09-28 13:51	SPXW	SPXW260928P07710000	put	7710.0000	2026-09-28	12.6000	12.5000	12.6000	7701.9500	37800.00	37800.00	0.00	30	10	33008	1846	17.8808234019502	0.166369507654896	0.166369507654896	false	false	false	true
8100d04d-f532-49d0-90ce-5fc4da8a32ed	2026-09-28 13:49	2026-09-28 13:49	2026-09-28 13:49	SPXW	SPXW260928P07710000	put	7710.0000	2026-09-28	12.8700	12.7000	13.0000	7701.9400	15440.00	9030.00	1290.00	12	5	32832	1846	17.7854821235103	0.171456021365624	0.169232031740997	false	false	false	true
326aa04a-67f9-4d67-89ff-4c806becabc5	2026-09-28 13:49	2026-09-28 13:49	2026-09-28 13:49	SPXW	SPXW260928P07710000	put	7710.0000	2026-09-28	12.8000	12.7000	12.9000	7701.9400	28160.00	14080.00	0.00	22	6	32854	1846	17.7973997833153	0.169242696124024	0.169242696124024	true	false	false	true
111f9b39-e0a6-4ba3-aaab-0042d56712e3	2026-09-28 13:42	2026-09-28 13:42	2026-09-28 13:42	SPXW	SPXW260928P07710000	put	7710.0000	2026-09-28	14.5000	14.4000	14.5000	7700.9100	18850.00	18850.00	0.00	13	5	32461	1846	17.5845070422535	0.187205603802726	0.187205603802726	false	false	false	true
a48e8b0f-aff0-41a9-9470-419029d49238	2026-09-28 13:42	2026-09-28 13:42	2026-09-28 13:42	SPXW	SPXW260928P07710000	put	7710.0000	2026-09-28	13.7000	13.5000	13.7000	7701.3900	30140.00	30140.00	0.00	22	7	32444	1846	17.5752979414951	0.176536687947364	0.176536687947364	false	false	false	true
24eb0d9b-09a4-4cdc-b4c3-0b768377f9ad	2026-09-28 13:33	2026-09-28 13:32	2026-09-28 13:32	SPXW	SPXW260928P07710000	put	7710.0000	2026-09-28	13.2000	13.1000	13.2000	7703.2200	13200.00	13200.00	0.00	10	5	31981	1846	17.3244853737811	0.184335736090441	0.184335736090441	false	false	false	true
acc2ffc6-8ca0-45a8-8042-7277829085b1	2026-09-28 13:32	2026-09-28 13:32	2026-09-28 13:32	SPXW	SPXW260928P07710000	put	7710.0000	2026-09-28	12.9000	12.8000	13.0000	7703.3100	36120.00	27090.00	0.00	28	7	31934	1846	17.2990249187432	0.179075767805691	0.179075767805691	false	false	false	true
4baebe5e-dd9a-44ee-a435-f4316dc4d71d	2026-09-28 13:29	2026-09-28 13:29	2026-09-28 13:29	SPXW	SPXW260928P07710000	put	7710.0000	2026-09-28	15.4200	15.2000	15.6000	7700.0200	21590.00	21590.00	0.00	14	7	31707	1846	17.1760563380282	0.183781983673444	0.190051415787507	false	false	false	true
7a7e4f3f-3435-4640-a195-60259b0ec85d	2026-09-28 13:22	2026-09-28 13:22	2026-09-28 13:22	SPXW	SPXW260928P07710000	put	7710.0000	2026-09-28	13.0000	12.9000	13.1000	7703.2500	13000.00	1300.00	0.00	10	8	31187	1846	16.8943661971831	0.174482114873623	0.174482114873623	false	false	false	true
ce9b8056-0fef-4107-8d32-e4538ff3eb0e	2026-09-28 13:21	2026-09-28 13:21	2026-09-28 13:21	SPXW	SPXW260928P07710000	put	7710.0000	2026-09-28	14.2700	14.3000	14.5000	7701.8800	28530.00	0.00	28530.00	20	8	31071	1846	16.8315276273023	0.18293967850349	0.18293967850349	false	false	false	true
2a173eae-c04a-4878-b2ab-54285f575b4c	2026-09-28 13:21	2026-09-28 13:21	2026-09-28 13:21	SPXW	SPXW260928P07710000	put	7710.0000	2026-09-28	14.8000	14.8000	14.9000	7701.4000	14800.00	0.00	14800.00	10	6	31042	1846	16.8158179848321	0.186676904666283	0.186676904666283	false	false	false	true
ce3cb8d9-599e-4da5-b24f-0fb7ca19fc2b	2026-09-28 13:19	2026-09-28 13:19	2026-09-28 13:19	SPXW	SPXW260928P07710000	put	7710.0000	2026-09-28	13.0100	13.0000	13.2000	7704.8000	14310.00	0.00	13000.00	11	7	30851	1846	16.7123510292524	0.18909756479206	0.192535761957431	false	false	false	true
0c107c88-8509-45b4-be36-339ad628cad7	2026-09-28 13:19	2026-09-28 13:18	2026-09-28 13:18	SPXW	SPXW260928P07710000	put	7710.0000	2026-09-28	12.3400	12.2000	12.5000	7706.9800	28380.00	28380.00	0.00	23	7	30728	1846	16.6457204767064	0.200147546025023	0.203884160937038	false	false	false	true
4743eb33-3075-48a6-9356-452d2f2cffef	2026-09-28 13:19	2026-09-28 13:18	2026-09-28 13:18	SPXW	SPXW260928P07710000	put	7710.0000	2026-09-28	12.2600	12.1000	12.3000	7706.9800	13490.00	11060.00	1210.00	11	6	30703	1846	16.6321776814735	0.198268777248847	0.196400052253844	false	false	false	true
6b752222-29f2-45ee-a25d-41b87155d1af	2026-09-28 13:18	2026-09-28 13:18	2026-09-28 13:18	SPXW	SPXW260928P07710000	put	7710.0000	2026-09-28	12.0000	11.9000	12.0000	7707.2400	13200.00	13200.00	0.00	11	7	30641	1846	16.5985915492958	0.197039493945341	0.197039493945341	false	false	false	true
f262c468-1056-414b-bf91-45cde5f80c24	2026-09-28 13:18	2026-09-28 13:18	2026-09-28 13:18	SPXW	SPXW260928P07710000	put	7710.0000	2026-09-28	10.9500	10.9000	11.1000	7707.6400	21900.00	0.00	21900.00	20	5	30594	1846	16.5731310942579	0.18236386565189	0.180500051291004	false	false	false	true
1a919a4e-6428-4cc0-b916-ccfff80d8dc6	2026-09-28 13:18	2026-09-28 13:18	2026-09-28 13:18	SPXW	SPXW260928P07710000	put	7710.0000	2026-09-28	11.9300	11.8000	12.0000	7707.5700	23850.00	6000.00	0.00	20	5	30520	1846	16.5330444203684	0.200135090225211	0.200135090225211	false	false	false	true
128acc20-6d8d-4dd1-9fb0-109c4d8842d1	2026-09-28 13:18	2026-09-28 13:18	2026-09-28 13:18	SPXW	SPXW260928P07710000	put	7710.0000	2026-09-28	11.6000	11.4000	11.6000	7708.5600	23200.00	23200.00	0.00	20	12	30425	1846	16.4815817984832	0.20227034137891	0.20227034137891	false	false	false	true
e1df98a3-7e05-419d-b4ba-a5b87668c437	2026-09-28 13:18	2026-09-28 13:18	2026-09-28 13:18	SPXW	SPXW260928P07710000	put	7710.0000	2026-09-28	11.4300	11.1000	11.5000	7708.6200	11430.00	11430.00	0.00	10	5	30395	1846	16.4653304442037	0.200076609493421	0.200971705049237	false	false	false	true
8cd652a8-cb71-4167-90c5-14ccc39bc288	2026-09-28 13:17	2026-09-28 13:17	2026-09-28 13:17	SPXW	SPXW260928P07710000	put	7710.0000	2026-09-28	10.9600	10.5000	11.3000	7708.4200	16440.00	3300.00	6540.00	15	5	30205	1846	16.3624052004334	0.187630022137751	0.189483392293754	false	false	false	true
74ebf064-d298-4674-a35f-f45d5754a3d0	2026-09-28 13:17	2026-09-28 13:17	2026-09-28 13:17	SPXW	SPXW260928P07710000	put	7710.0000	2026-09-28	10.5900	9.9000	12.0000	7708.0800	33900.00	33900.00	0.00	32	12	30182	1846	16.3499458288191	0.173174747195163	0.186162540825704	false	false	false	true
33a8396d-f4f8-48c5-aec0-bc55fc0d1064	2026-09-28 13:17	2026-09-28 13:17	2026-09-28 13:17	SPXW	SPXW260928P07710000	put	7710.0000	2026-09-28	8.0000	7.9000	8.1000	7714.2500	18410.00	810.00	12000.00	23	9	30019	1846	16.2616468039003	0.187075986745467	0.18520076439734	false	false	false	true
2818ab6e-a3ef-4da0-9202-dd4718849f1b	2026-09-28 13:17	2026-09-28 13:17	2026-09-28 13:17	SPXW	SPXW260928P07710000	put	7710.0000	2026-09-28	8.6100	8.5000	8.8000	7714.2300	11190.00	0.00	6880.00	13	5	29985	1846	16.2432286023835	0.198072832933595	0.196201631400213	false	false	false	true	false
6a394fa9-5f56-42b7-abb5-8a7cc8614ad5	2026-09-28 13:16	2026-09-28 13:16	2026-09-28 13:16	SPXW	SPXW260928P07710000	put	7710.0000	2026-09-28	8.5000	8.5000	8.6000	7713.7300	14450.00	0.00	14450.00	17	6	29676	1846	16.0758396533044	0.189713315865093	0.189713315865093	false	false	false	true	false
f99042ca-27fe-47a3-a5e9-e9693f752049	2026-09-28 13:15	2026-09-28 13:15	2026-09-28 13:15	SPXW	SPXW260928P07710000	put	7710.0000	2026-09-28	8.8900	8.7000	8.9000	7712.4500	11560.00	10680.00	0.00	13	5	29509	1846	15.9853737811484	0.186140500247062	0.18614986083359	false	false	false	true	false
cbe9d208-cb9c-4feb-885c-cf4f271028a0	2026-09-28 13:15	2026-09-28 13:15	2026-09-28 13:15	SPXW	SPXW260928P07710000	put	7710.0000	2026-09-28	10.4600	10.3000	10.5000	7710.2300	17780.00	11550.00	1030.00	17	5	29295	1846	15.8694474539545	0.196032612790306	0.192355419418225	false	false	false	true
d3fd8b7f-cbb6-44f9-ab60-c4d64de428e9	2026-09-28 13:15	2026-09-28 13:15	2026-09-28 13:15	SPXW	SPXW260928P07710000	put	7710.0000	2026-09-28	10.5400	10.4000	10.6000	7710.0800	17920.00	7420.00	0.00	17	6	29272	1846	15.8569880823402	0.196484796363461	0.194656244856174	false	false	false	true
93e8152c-e866-4995-8fab-00247620a989	2026-09-28 13:14	2026-09-28 13:13	2026-09-28 13:14	SPXW	SPXW260928P07710000	put	7710.0000	2026-09-28	7.6000	7.4000	7.7000	7717.3900	76000.00	4560.00	71440.00	100	19	28623	1846	15.5054171180932	0.200009551062046	0.200019517762649	false	false	false	true
5f974514-b115-4fc3-9c33-2b88561b5556	2026-09-28 13:13	2026-09-28 13:13	2026-09-28 13:13	SPXW	SPXW260928P07710000	put	7710.0000	2026-09-28	7.8800	7.7000	7.9000	7716.5500	11820.00	9480.00	780.00	15	8	28483	1846	15.4295774647887	0.197426528585431	0.199309953726069	false	false	false	true
9345a2dc-7182-43e9-a8aa-1c55eed652eb	2026-09-28 13:13	2026-09-28 13:13	2026-09-28 13:13	SPXW	SPXW260928P07710000	put	7710.0000	2026-09-28	7.6300	7.3000	7.7000	7716.5000	19830.00	19830.00	0.00	26	5	28317	1846	15.339653304442	0.191183146706007	0.193067192781033	false	false	false	true	false
bfa395ad-7e45-4b3e-9f1c-793367d7dada	2026-09-28 13:13	2026-09-28 13:13	2026-09-28 13:13	SPXW	SPXW260928P07710000	put	7710.0000	2026-09-28	8.0000	8.0000	8.1000	7715.8400	18400.00	0.00	18400.00	23	9	28270	1846	15.3141928494041	0.195521313962627	0.195521313962627	false	false	false	true	false
b868b3f3-b345-4f15-bb76-e77e05f9a2b0	2026-09-28 13:13	2026-09-28 13:13	2026-09-28 13:13	SPXW	SPXW260928P07710000	put	7710.0000	2026-09-28	8.6400	8.5000	8.7000	7715.0500	13820.00	6080.00	6880.00	16	9	28139	1846	15.2432286023835	0.200315169686922	0.200325093997659	false	false	false	true
62164f3f-c2b5-46b1-8b9e-96e0e1c740d3	2026-09-28 13:13	2026-09-28 13:12	2026-09-28 13:12	SPXW	SPXW260928P07710000	put	7710.0000	2026-09-28	9.0700	8.9000	9.2000	7714.4300	19040.00	5520.00	11720.00	21	7	28061	1846	15.2009750812568	0.206369457566813	0.202675960843376	false	false	false	true