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.

523,327 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts523,327 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

fd057d13-ce72-4885-be48-4fa92bd808f5	2026-08-28 15:06	2026-08-28 15:06	2026-08-28 15:06	SPXW	SPXW260828C07705000	call	7705.0000	2026-08-28	6.6000	6.5000	6.6000	7707.3500	184140.00	184140.00	0.00	279	52	29570	1015	29.1330049261084	0.170926674467306	0.170953239477111	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-08-28T19:10:32.565799Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
a4fcc077-ae9e-46d3-8532-add047967a3a	2026-08-28 15:07	2026-08-28 15:07	2026-08-28 15:07	SPXW	SPXW260925P07710000	put	7710.0000	2026-09-25	91.7300	91.6000	92.2000	7705.4700	348560.00	174230.00	174330.00	38	6	434	133	3.26315789473684	0.118217275643489	0.118099371557261	false	false	false	true	false
ab06249b-ec0f-4f06-8702-149b32d96726	2026-08-28 15:08	2026-08-28 15:08	2026-08-28 15:08	SPXW	SPXW260828C07705000	call	7705.0000	2026-08-28	7.6000	7.3000	7.8000	7708.5400	254470.00	252250.00	0.00	335	83	30953	1015	30.4955665024631	0.178887339245569	0.185697834986617	false	false	false	true	false
54d48201-3b90-4c41-bec1-d1ce1e65dc17	2026-08-28 15:09	2026-08-28 15:09	2026-08-28 15:09	SPXW	SPXW260901P07720000	put	7720.0000	2026-09-01	29.1000	29.0000	29.4000	7709.9200	651840.00	608190.00	43650.00	224	9	935	747	1.2516733601071	0.0792370856207712	0.0792370856207712	false	false	false	true	false
069a7a36-01a5-40a0-ad82-4e13b7e786e3	2026-08-28 15:09	2026-08-28 15:09	2026-08-28 15:09	SPXW	SPXW260901P07710000	put	7710.0000	2026-09-01	24.2000	24.1000	24.2000	7710.2000	181500.00	181500.00	0.00	75	6	748	242	3.09090909090909	0.0803693636229034	0.0803693636229034	false	false	false	true	false
d7ca473d-b1e9-426e-98c6-b5ad97457ce4	2026-08-28 15:09	2026-08-28 15:09	2026-08-28 15:09	SPXW	SPXW260828P07715000	put	7715.0000	2026-08-28	7.2000	7.1000	7.4000	7710.7900	235440.00	189360.00	46080.00	327	56	84071	1492	56.347855227882	0.160186636917933	0.160186636917933	false	false	false	true	false
03b4c376-de59-4054-9f3f-58724678aa6d	2026-08-28 15:10	2026-08-28 15:10	2026-08-28 15:10	SPXW	SPXW260831C07730000	call	7730.0000	2026-08-31	10.4000	10.3000	10.6000	7710.9200	306800.00	236080.00	70720.00	295	26	10817	687	15.745269286754	0.0626150342392704	0.0626150342392704	false	false	false	true	false
c593d417-4797-46b1-b20f-a1a5ea9f42d9	2026-08-28 15:12	2026-08-28 15:11	2026-08-28 15:11	SPXW	SPXW260831C07710000	call	7710.0000	2026-08-31	19.1000	19.1000	19.2000	7709.1800	110780.00	0.00	110780.00	58	7	3407	907	3.75633958103638	0.0656104282790905	0.0656104282790905	false	false	false	true	false
44ffb7a5-ba30-4036-9620-4e054b3c51f4	2026-08-28 15:14	2026-08-28 15:14	2026-08-28 15:14	SPXW	SPXW260831C07710000	call	7710.0000	2026-08-31	18.6000	18.6000	18.7000	7708.3600	139500.00	0.00	139500.00	75	5	3506	907	3.86549062844542	0.0653213396695436	0.0653213396695436	false	false	false	true	false
81982cc9-738d-4473-8973-6b21755d4836	2026-08-28 15:20	2026-08-28 15:20	2026-08-28 15:20	SPXW	SPXW260831C07740000	call	7740.0000	2026-08-31	7.0000	6.8000	7.1000	7710.5900	222600.00	66500.00	156100.00	318	20	5462	1267	4.31097079715864	0.0616977328723859	0.0616977328723859	false	false	false	true	false
42d6f274-3937-4a61-9db5-2af371fa03a8	2026-08-28 15:21	2026-08-28 15:21	2026-08-28 15:21	SPXW	SPXW260831C07715000	call	7715.0000	2026-08-31	18.0000	17.8000	18.1000	7712.5000	180000.00	45000.00	135000.00	100	12	2156	1216	1.77302631578947	0.0646796695792735	0.0646796695792735	false	false	false	true	false
f1a111db-0bb5-457d-af25-05b7f9791dc5	2026-08-28 15:21	2026-08-28 15:21	2026-08-28 15:21	SPXW	SPXW260831C07730000	call	7730.0000	2026-08-31	10.2000	10.1000	10.4000	7710.9400	255000.00	213180.00	41820.00	250	18	11211	687	16.3187772925764	0.061817193890239	0.061817193890239	false	false	false	true	false
aa4d52ed-1c45-4de2-8acd-5f2ce5acc735	2026-08-28 15:21	2026-08-28 15:21	2026-08-28 15:21	SPXW	SPXW260831C07710000	call	7710.0000	2026-08-31	20.0000	20.0000	20.1000	7710.8200	210000.00	0.00	210000.00	105	8	4084	907	4.50275633958104	0.0657672968708905	0.0657672968708905	false	false	false	true	false
40ad43c2-bc07-4849-abc5-e1805ef3c0f2	2026-08-28 15:23	2026-08-28 15:23	2026-08-28 15:23	SPXW	SPXW260831C07730000	call	7730.0000	2026-08-31	10.1000	9.9000	10.2000	7710.7500	101000.00	37370.00	37370.00	100	12	11419	687	16.6215429403202	0.061688100139914	0.061688100139914	false	false	false	true	false
67ad0c47-b7c1-457a-a733-3655714a1892	2026-08-28 15:26	2026-08-28 15:26	2026-08-28 15:26	SPXW	SPXW260904C07750000	call	7750.0000	2026-09-04	25.0900	24.8000	25.2000	7712.3300	250870.00	243340.00	7530.00	100	16	1996	3611	0.552755469399058	0.0911749360913728	0.0914220593264219	false	false	false	true	false
695350ee-398d-47fe-b9a6-af2ab95a13e4	2026-08-28 15:33	2026-08-28 15:33	2026-08-28 15:33	SPXW	SPXW260831C07730000	call	7730.0000	2026-08-31	10.4000	10.3000	10.4000	7711.7400	104000.00	104000.00	0.00	100	7	11799	687	17.174672489083	0.0614961847634095	0.0614961847634095	false	false	false	true	false
4dddccaf-bd13-4fd8-909c-10a480a25ebc	2026-08-28 15:41	2026-08-28 15:41	2026-08-28 15:41	SPXW	SPXW260831C07710000	call	7710.0000	2026-08-31	20.7000	20.7000	20.8000	7713.8100	167670.00	0.00	167670.00	81	6	4832	907	5.32745314222712	0.0624327346631272	0.0624327346631272	false	false	false	true	false
7eef31a2-7f17-4543-9396-7c18261efc01	2026-08-28 15:48	2026-08-28 15:48	2026-08-28 15:48	SPXW	SPXW260831C07710000	call	7710.0000	2026-08-31	18.3000	18.2000	18.3000	7708.5200	173850.00	173850.00	0.00	95	12	5130	907	5.65600882028666	0.0639530210742706	0.0639530210742706	false	false	false	true	false
2f7a37cc-c870-441d-b3d9-ecbde91074ac	2026-08-28 15:50	2026-08-28 15:50	2026-08-28 15:50	SPXW	SPXW260831C07710000	call	7710.0000	2026-08-31	20.5000	18.2000	20.5000	7709.9400	157850.00	157850.00	0.00	77	5	5331	907	5.87761852260198	0.0692233221779582	0.0692233221779582	false	false	false	true	false
25eec5be-40dc-49c2-9ccc-3b360208bd8b	2026-08-28 15:56	2026-08-28 15:56	2026-08-28 15:56	SPXW	SPXW260928P07710000	put	7710.0000	2026-09-28	91.0500	89.7000	92.0000	7713.9700	582750.00	281790.00	300960.00	64	6	138	37	3.72972972972973	0.117422286802089	0.117422286802089	false	false	false	true	false
afc26df3-8a59-46f4-898c-3d270212e767	2026-08-28 15:56	2026-08-28 15:56	2026-08-28 15:56	SPXW	SPXW260831C07730000	call	7730.0000	2026-08-31	10.6000	10.5000	10.8000	7714.8600	212000.00	154760.00	57240.00	200	13	12888	687	18.7598253275109	0.0579033236230233	0.0579033236230233	false	false	false	true	false
8a909147-d94c-40ec-8fde-d7432a5f642c	2026-08-28 15:58	2026-08-28 15:57	2026-08-28 15:57	SPXW	SPXW260831C07740000	call	7740.0000	2026-08-31	7.0000	6.9000	7.2000	7715.4300	296100.00	261100.00	35000.00	423	15	6381	1267	5.03630623520126	0.0559753685565862	0.0559753685565862	false	false	false	true	false
8eff9d5a-d99a-49ad-b320-2f8200577d5d	2026-08-28 15:58	2026-08-28 15:58	2026-08-28 15:58	SPXW	SPXW260831C07730000	call	7730.0000	2026-08-31	9.5000	9.4000	9.7000	7712.8700	190000.00	183350.00	6650.00	200	7	13201	687	19.2154294032023	0.0564986733340595	0.0564986733340595	false	false	false	true	false
d17fb442-c0ad-4178-b468-2326c1122dda	2026-08-28 16:00	2026-08-28 16:00	2026-08-28 16:00	SPXW	SPXW260831C07715000	call	7715.0000	2026-08-31	15.1900	14.8000	15.3000	7711.4900	300840.00	57640.00	243200.00	198	20	3656	1216	3.00657894736842	0.0560757193201052	0.0564343737199108	false	false	false	true	false
8ea1417a-89dc-4dfb-b319-a8d8b28c14b6	2026-08-28 16:02	2026-08-28 16:01	2026-08-28 16:01	SPXW	SPXW260831C07715000	call	7715.0000	2026-08-31	15.7000	15.6000	15.9000	7711.4700	315590.00	262210.00	53380.00	201	8	3887	1216	3.19654605263158	0.0589800820250279	0.0582627846216798	false	false	false	true	false
ba76e0fa-b6dc-44a0-8f3b-5f68f21bf45d	2026-08-28 16:05	2026-08-28 16:04	2026-08-28 16:04	SPXW	SPXW260902P07710000	put	7710.0000	2026-09-02	28.0000	27.7000	28.1000	7711.7600	168000.00	33600.00	134400.00	60	11	452	229	1.97379912663755	0.0855825936041248	0.0855825936041248	false	false	false	true	false
ba3b4798-deec-4d26-a662-156e651ea119	2026-08-28 16:08	2026-08-28 16:07	2026-08-28 16:07	SPXW	SPXW260904C07715000	call	7715.0000	2026-09-04	40.0000	38.8000	39.1000	7711.7600	6092000.00	0.00	0.00	1523	8	2431	456	5.33114035087719	0.0910607369740043	0.0910607369740043	false	false	false	true	false
e07bdec9-00b9-4095-9c77-80a15ff595db	2026-08-28 16:15	2026-08-28 16:14	2026-08-28 16:14	SPXW	SPXW260831P07750000	put	7750.0000	2026-08-31	43.0000	42.3000	43.4000	7711.7600	159100.00	116100.00	43000.00	37	9	4937	2198	2.24613284804368	0.0724434027035004	0.0724434027035004	false	false	false	true	false
79397550-5d55-4568-a30c-5ad6d162bd31	2026-08-28 16:49	2026-08-28 16:48	2026-08-28 16:48	SPXW	SPXW260831P07650000	put	7650.0000	2026-08-31	2.9800	2.9500	3.1000	7711.7600	148946.00	0.00	148946.00	500	8	14085	5955	2.36523929471033	0.0764220370242508	0.0766450032433179	false	false	false	true	false
3b0d3347-8365-4496-bbe0-d58bd9c9a281	2026-08-28 16:49	2026-08-28 16:48	2026-08-28 16:48	SPXW	SPXW260831P07700000	put	7700.0000	2026-08-31	12.2600	11.8000	12.3000	7711.7600	306416.00	306416.00	0.00	250	10	11667	8015	1.45564566437929	0.0657427699211423	0.066344683666315	false	false	false	true	false
5f2002d9-a8a4-43b9-91a5-8fe5c23fe1b4	2026-08-31 09:30	2026-08-31 09:30	2026-08-31 09:30	SPXW	SPXW260831C07690000	call	7690.0000	2026-08-31	12.7700	12.5000	12.8000	7692.2900	127720.00	127720.00	0.00	100	27	264	735	0.359183673469388	0.136516845412809	0.136516845412809	false	false	false	true	false
1f80bd1b-c887-45bd-addf-8a72d4f4da26	2026-08-31 09:32	2026-08-31 09:32	2026-08-31 09:32	SPXW	SPXW260831P07680000	put	7680.0000	2026-08-31	9.0000	8.9000	9.0000	7690.0400	196200.00	196200.00	0.00	218	39	832	1920	0.433333333333333	0.163177376638937	0.162317981203192	false	false	false	true	false
7139956e-6ff0-468c-9f98-f889687990b8	2026-08-31 09:33	2026-08-31 09:33	2026-08-31 09:33	SPXW	SPXW260902C07590000	call	7590.0000	2026-09-02	99.1000	98.3000	99.8000	7683.1800	128830.00	128830.00	0.00	13	5	40	4	10	0.138747436891689	0.138747436891689	false	false	false	true	false
29e76e3b-8668-4c2c-beaf-5b2c002a8ad9	2026-08-31 09:35	2026-08-31 09:35	2026-08-31 09:35	SPXW	SPXW260831P07680000	put	7680.0000	2026-08-31	13.0000	12.8000	13.0000	7682.0100	140390.00	139100.00	0.00	108	7	2118	1920	1.103125	0.168632746563606	0.169840992208082	false	false	false	true	false
23b4c135-b61e-4ff5-9dab-776b59dd60f0	2026-08-31 09:35	2026-08-31 09:35	2026-08-31 09:35	SPXW	SPXW260831P07670000	put	7670.0000	2026-08-31	9.9300	9.7000	10.0000	7680.2100	101250.00	96360.00	1950.00	102	23	2064	1788	1.15436241610738	0.172730737774294	0.173989236365911	false	false	false	true	false
14cab8c1-a5c9-4f9b-96b2-73e1ee916771	2026-08-31 09:37	2026-08-31 09:37	2026-08-31 09:37	SPXW	SPXW260918P07550000	put	7550.0000	2026-09-18	40.0000	39.6000	40.1000	7680.8500	1000000.00	140000.00	860000.00	250	9	514	3003	0.171162171162171	0.141733609239953	0.141752655357169	false	false	false	true	false
dd1322a5-1d8d-4982-bf14-66f7e20a4cfd	2026-08-31 09:38	2026-08-31 09:37	2026-08-31 09:37	SPXW	SPXW260901P07680000	put	7680.0000	2026-09-01	21.6000	21.3000	21.7000	7680.5300	108000.00	108000.00	0.00	50	7	257	363	0.707988980716253	0.13882230449774	0.13882230449774	false	false	false	true	false
14c7041c-3de1-4bb7-ab82-474671a1f3d9	2026-08-31 09:39	2026-08-31 09:39	2026-08-31 09:39	SPXW	SPXW260918P07550000	put	7550.0000	2026-09-18	39.9200	39.3000	40.1000	7680.3600	997900.00	497900.00	500000.00	250	17	1514	3003	0.504162504162504	0.140960542116971	0.141519264588806	false	false	false	true	false
81dfeca9-bfa9-4fec-989b-ae2523f71382	2026-08-31 09:41	2026-08-31 09:41	2026-08-31 09:41	SPXW	SPXW260901P07685000	put	7685.0000	2026-09-01	23.8000	23.5000	23.8000	7681.1000	116620.00	116620.00	0.00	49	10	222	253	0.877470355731225	0.138506697409091	0.138506697409091	false	false	false	true	false
8debd8b7-c1c7-4201-93f5-a644f307fb1f	2026-08-31 09:42	2026-08-31 09:42	2026-08-31 09:42	SPXW	SPXW260918P07550000	put	7550.0000	2026-09-18	40.0000	39.5000	40.1000	7679.7400	999980.00	183980.00	816000.00	250	15	1764	3003	0.587412587412587	0.141045622877295	0.141223716527451	false	false	false	true	false
2702a73d-3bac-4312-ac77-ba05722d6c32	2026-08-31 09:44	2026-08-31 09:44	2026-08-31 09:44	SPXW	SPXW260918P07550000	put	7550.0000	2026-09-18	40.9500	40.4000	41.1000	7677.7000	1007290.00	1007290.00	0.00	246	23	2510	3003	0.835830835830836	0.141490711443766	0.14202153005696	false	false	false	true	false
7388e0a3-b647-4307-862d-4fa681a90ea7	2026-08-31 09:45	2026-08-31 09:45	2026-08-31 09:45	SPXW	SPXW260918P07550000	put	7550.0000	2026-09-18	40.7700	40.2000	41.1000	7677.0900	1019190.00	949640.00	57400.00	250	26	3017	3003	1.004662004662	0.140853471988155	0.141728314983759	false	false	false	true	false
d297c1c2-1904-46a9-9482-b3dfe4568a08	2026-08-31 09:45	2026-08-31 09:45	2026-08-31 09:45	SPXW	SPXW260831C07675000	call	7675.0000	2026-08-31	13.9000	13.8000	14.0000	7677.2500	144560.00	0.00	136220.00	104	7	2004	734	2.73024523160763	0.154572711566779	0.154572711566779	false	false	false	true	false
4607d462-5179-441f-91c0-e8faa235e9e3	2026-08-31 09:45	2026-08-31 09:45	2026-08-31 09:45	SPXW	SPXW260831C07675000	call	7675.0000	2026-08-31	13.9000	13.9000	14.0000	7677.2500	145950.00	0.00	145950.00	105	21	1900	734	2.58855585831063	0.154572711566779	0.154572711566779	false	false	false	true	false
c364fec3-9c08-440d-bec6-fe153cfe92fc	2026-08-31 09:45	2026-08-31 09:45	2026-08-31 09:45	SPXW	SPXW260831C07675000	call	7675.0000	2026-08-31	14.3400	14.1000	14.4000	7677.7500	286880.00	286880.00	0.00	200	40	2252	734	3.06811989100817	0.155007746661481	0.155007746661481	false	false	false	true	false
2054f322-d635-40a0-a17a-44a9283019e8	2026-08-31 09:46	2026-08-31 09:45	2026-08-31 09:45	SPXW	SPXW260918P07550000	put	7550.0000	2026-09-18	40.4900	40.1000	40.6000	7678.3400	1012360.00	169960.00	842400.00	250	17	3517	3003	1.17116217116217	0.141265726451022	0.141443116034526	false	false	false	true	false
aa77a000-8a1a-467b-be9e-a81810f7c4a0	2026-08-31 09:46	2026-08-31 09:46	2026-08-31 09:46	SPXW	SPXW260831C07675000	call	7675.0000	2026-08-31	14.2500	14.0000	14.3000	7679.1300	226560.00	205280.00	2820.00	159	36	2476	734	3.3732970027248	0.145717886534048	0.145717886534048	true	false	false	true	false
457af835-2d59-4e96-b2f5-bab0b48705c5	2026-08-31 09:46	2026-08-31 09:46	2026-08-31 09:46	SPXW	SPXW260831C07675000	call	7675.0000	2026-08-31	13.8800	13.7000	14.0000	7678.9900	283070.00	277590.00	5480.00	204	49	2742	734	3.73569482288828	0.141769162245923	0.140531820073414	false	false	false	true	false
e01b121f-752b-4db0-b37e-24953e5f1ee3	2026-08-31 09:46	2026-08-31 09:46	2026-08-31 09:46	SPXW	SPXW260831C07675000	call	7675.0000	2026-08-31	13.3800	13.2000	13.5000	7677.8100	256850.00	192580.00	52240.00	192	29	2966	734	4.0408719346049	0.143639376388033	0.143639376388033	false	false	false	true	false
c70f6804-78ae-4d1e-b5d9-01f102c04ad3	2026-08-31 09:46	2026-08-31 09:46	2026-08-31 09:46	SPXW	SPXW260831C07675000	call	7675.0000	2026-08-31	13.0000	13.0000	13.1000	7677.6100	197600.00	0.00	197600.00	152	14	3235	734	4.40735694822888	0.141345162494383	0.141345162494383	false	false	false	true	false