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.

566,287 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts566,287 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:alert_rule = RepeatedHitsDescendingFill×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

6f650e38-205c-4ba4-ae1c-671bc982f64f	2026-09-29 11:47	2026-09-29 11:47	2026-09-29 11:47	SPXW	SPXW260929C07675000	call	7675.0000	2026-09-29	10.7300	10.6000	10.9000	7671.4400	16090.00	2160.00	8570.00	15	8	24657	1911	12.9026687598116	0.185395549084152	0.185395549084152	false	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	—	—	—	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-29T15:50:54.243467Z"}	2026-09-29	2026-09-29 21:15	2026-09-29 21:15
3819ffe5-a1f2-4119-b47b-f9bdff5afdc6	2026-09-29 11:47	2026-09-29 11:47	2026-09-29 11:47	SPXW	SPXW260929C07660000	call	7660.0000	2026-09-29	19.3300	19.4000	19.6000	7671.3900	25130.00	0.00	25130.00	13	11	11651	1351	8.6239822353812	0.191265599796626	0.191265599796626	false	false	false	true
921e675a-a976-4c9e-9e42-3539dc669bf0	2026-09-29 11:47	2026-09-29 11:47	2026-09-29 11:47	SPXW	SPXW260929C07680000	call	7680.0000	2026-09-29	8.2400	8.2000	8.4000	7671.5600	12360.00	2520.00	9840.00	15	6	38914	720	54.0472222222222	0.18030803626734	0.177211180505092	false	false	false	true
80a2a97d-c62e-4708-9361-b753da79e1a5	2026-09-29 11:47	2026-09-29 11:47	2026-09-29 11:47	SPXW	SPXW260929C07680000	call	7680.0000	2026-09-29	8.2400	8.1000	8.3000	7671.5600	10710.00	9090.00	1620.00	13	12	38927	720	54.0652777777778	0.178766083507479	0.177217094163616	false	false	false	true
7b979915-e724-4e40-a54d-0901a3bc3e75	2026-09-29 11:47	2026-09-29 11:47	2026-09-29 11:47	SPXW	SPXW260929C07675000	call	7675.0000	2026-09-29	9.3200	9.1000	9.5000	7668.8200	11180.00	1880.00	0.00	12	5	24425	1911	12.7812663526949	0.172185116105444	0.18156994860807	true	false	false	true
3e1d1291-5c0e-4e25-a232-94c751333d19	2026-09-29 11:47	2026-09-29 11:47	2026-09-29 11:47	SPXW	SPXW260929P07655000	put	7655.0000	2026-09-29	6.9300	6.8000	7.3000	7670.3400	69310.00	0.00	69310.00	100	12	34870	680	51.2794117647059	0.199082578089151	0.199082578089151	false	false	false	true
f071b64c-f5a3-4408-9dea-178079688d99	2026-09-29 11:47	2026-09-29 11:47	2026-09-29 11:47	SPXW	SPXW260929P07665000	put	7665.0000	2026-09-29	10.4200	10.1000	10.6000	7669.8600	17710.00	13570.00	3090.00	17	5	30545	952	32.0850840336134	0.191636984939098	0.188617278013249	false	false	false	true
e049b5b8-d540-468a-bece-ad8246af6f9b	2026-09-29 11:47	2026-09-29 11:47	2026-09-29 11:47	SPXW	SPXW260929P07655000	put	7655.0000	2026-09-29	6.8500	6.7000	6.9000	7669.8600	10960.00	9620.00	1340.00	16	5	34732	680	51.0764705882353	0.194828066378776	0.193168655226531	false	false	false	true
a0e3a6ab-ca37-49ce-92be-9ac72bb42594	2026-09-29 11:47	2026-09-29 11:47	2026-09-29 11:47	SPXW	SPXW260929C07675000	call	7675.0000	2026-09-29	9.3100	9.1000	10.1000	7669.7900	15830.00	940.00	13920.00	17	11	24321	1911	12.7268445839874	0.175234909860386	0.17977084466356	false	false	false	true
42581b52-7240-41bc-b063-a1ef1604f5ab	2026-09-29 11:47	2026-09-29 11:47	2026-09-29 11:47	SPXW	SPXW260929C07680000	call	7680.0000	2026-09-29	7.6900	7.4000	8.3000	7671.3100	21540.00	12320.00	9220.00	28	14	38645	720	53.6736111111111	0.173945897734363	0.169277031412475	false	false	false	true
a936b404-a3ef-43af-abd8-002d6441f22a	2026-09-29 11:47	2026-09-29 11:47	2026-09-29 11:47	SPXW	SPXW260929C07705000	call	7705.0000	2026-09-29	2.4700	2.4000	2.6000	7671.3100	12360.00	0.00	12360.00	50	7	31766	1164	27.2903780068729	0.192909101544304	0.189070125849126	false	false	false	true
02f67fe9-cc78-45f2-b7ae-79d1a8dd742a	2026-09-29 11:47	2026-09-29 11:47	2026-09-29 11:47	SPXW	SPXW260929C07690000	call	7690.0000	2026-09-29	5.3500	5.0000	5.7000	7671.3100	27270.00	12000.00	14730.00	51	25	41798	1049	39.8455672068637	0.188622269473064	0.179721611887699	false	false	false	true
f3b20449-ae76-4477-8cda-b732f6de0dfa	2026-09-29 11:47	2026-09-29 11:47	2026-09-29 11:47	SPXW	SPXW260929P07660000	put	7660.0000	2026-09-29	9.4400	8.7000	10.1000	7665.8500	16040.00	5700.00	10340.00	17	5	42089	5172	8.13785769528229	0.187565961423907	0.17540299769736	false	false	false	true
d2ba7282-6915-420b-b70b-04b70673b41b	2026-09-29 11:47	2026-09-29 11:47	2026-09-29 11:47	SPXW	SPXW260929P07650000	put	7650.0000	2026-09-29	5.9900	5.6000	6.3000	7665.8500	11390.00	0.00	10780.00	19	6	63166	6833	9.24425581735694	0.188387536608673	0.179852721023925	false	false	false	true
58e48215-721c-444b-bba1-96366d8256fc	2026-09-29 11:47	2026-09-29 11:47	2026-09-29 11:47	SPXW	SPXW260929P07665000	put	7665.0000	2026-09-29	11.5100	10.5000	11.7000	7665.8500	14960.00	4580.00	10380.00	13	5	30347	952	31.8771008403361	0.180360374664695	0.171406484115869	false	false	false	true
476d43a5-637f-42ec-986a-f3f2cf972a4a	2026-09-29 11:47	2026-09-29 11:47	2026-09-29 11:47	SPXW	SPXW260929P07650000	put	7650.0000	2026-09-29	6.5200	6.5000	6.7000	7662.9100	18260.00	0.00	18260.00	28	6	63122	6833	9.23781647885263	0.179433821377332	0.177792185451218	false	false	false	true
8e978b9d-d13a-4b2e-b07d-3238eda3cc06	2026-09-29 11:46	2026-09-29 11:46	2026-09-29 11:46	SPXW	SPXW260929C07675000	call	7675.0000	2026-09-29	7.0100	7.0000	7.1000	7664.0600	10510.00	710.00	9800.00	15	10	24008	1911	12.5630559916274	0.174441022540758	0.172846681904948	false	false	false	true
857d4f4d-7e97-4260-b906-75e00ec8e1a7	2026-09-29 11:46	2026-09-29 11:46	2026-09-29 11:46	SPXW	SPXW260929P07650000	put	7650.0000	2026-09-29	6.6000	6.6000	6.7000	7664.5200	44230.00	670.00	43560.00	67	9	62841	6833	9.19669252158642	0.189569474713718	0.187909736753556	false	false	false	true
0fcb6284-7346-417c-a0e8-0995a6e4d6ac	2026-09-29 11:44	2026-09-29 11:44	2026-09-29 11:44	SPXW	SPXW260929P07655000	put	7655.0000	2026-09-29	6.7200	6.7000	6.9000	7667.9400	67210.00	0.00	66530.00	100	13	33771	680	49.6632352941176	0.18187633239458	0.18187633239458	false	false	false	true
edbfd6e5-ae02-4a53-b2e6-5803e75564a9	2026-09-29 11:43	2026-09-29 11:43	2026-09-29 11:43	SPXW	SPXW260929P07655000	put	7655.0000	2026-09-29	7.7000	7.6000	7.9000	7665.3300	144780.00	4640.00	140140.00	188	36	33394	680	49.1088235294118	0.18485049667058	0.181138311282457	false	false	false	true
7f84ab9c-cbf5-4d1a-98c9-880565e77ab8	2026-09-29 11:43	2026-09-29 11:43	2026-09-29 11:43	SPXW	SPXW260929P07665000	put	7665.0000	2026-09-29	12.3300	12.3000	12.4000	7664.9900	11100.00	3720.00	7380.00	9	7	29078	952	30.5441176470588	0.184482698928806	0.183003333011986	false	false	false	true
23bf6a3e-6815-488d-a1fe-323922c17eef	2026-09-29 11:43	2026-09-29 11:43	2026-09-29 11:43	SPXW	SPXW260929P07660000	put	7660.0000	2026-09-29	9.9000	9.7000	10.0000	7665.3000	104920.00	12870.00	91070.00	106	15	40563	5172	7.84280742459397	0.18400367040124	0.182501071724376	false	false	false	true
e513ad68-4b37-4eec-ace8-108e0f367126	2026-09-29 11:42	2026-09-29 11:42	2026-09-29 11:42	SPXW	SPXW260929P07660000	put	7660.0000	2026-09-29	9.1000	9.1000	9.3000	7665.8800	82840.00	0.00	81000.00	91	15	39956	5172	7.72544470224285	0.176916942100831	0.175409148812577	true	false	false	true
e5f06b02-70da-4400-9a6c-42096e084598	2026-09-29 11:42	2026-09-29 11:42	2026-09-29 11:42	SPXW	SPXW260929P07670000	put	7670.0000	2026-09-29	14.0200	13.9000	14.1000	7665.5400	16830.00	4230.00	0.00	12	7	34447	1317	26.1556567957479	0.174503350579568	0.174503350579568	false	false	false	true
0a8936c0-5b1f-40d3-8e5a-34994b3efd3f	2026-09-29 11:42	2026-09-29 11:42	2026-09-29 11:42	SPXW	SPXW260929P07655000	put	7655.0000	2026-09-29	7.4000	7.3000	7.6000	7665.3900	148050.00	0.00	143550.00	200	47	32674	680	48.05	0.177960874366365	0.176389543785159	false	false	false	true
0402c611-63c2-4903-a209-b04fa06b31cf	2026-09-29 11:42	2026-09-29 11:42	2026-09-29 11:42	SPXW	SPXW260929P07640000	put	7640.0000	2026-09-29	3.7000	3.7000	3.8000	7665.1600	11480.00	380.00	11100.00	31	6	42684	3151	13.5461758172009	0.186618457014457	0.184573958609718	false	false	false	true
f34d39d6-2ee4-440a-805e-448462817673	2026-09-29 11:42	2026-09-29 11:42	2026-09-29 11:42	SPXW	SPXW260929P07665000	put	7665.0000	2026-09-29	11.9700	11.9000	12.1000	7664.6300	20350.00	0.00	20350.00	17	8	28735	952	30.1838235294118	0.175572302352242	0.174095701051724	false	false	false	true
a71acc65-a76c-48bf-a6f3-9002041a7bb2	2026-09-29 11:42	2026-09-29 11:42	2026-09-29 11:42	SPXW	SPXW260929P07660000	put	7660.0000	2026-09-29	9.8200	9.8000	10.0000	7664.6300	10800.00	1000.00	9800.00	11	5	39762	5172	7.68793503480278	0.180827906422891	0.17783712710815	false	false	false	true
a5b664b4-6f2e-41de-bf7e-33b562e47d49	2026-09-29 11:42	2026-09-29 11:41	2026-09-29 11:41	SPXW	SPXW260929P07665000	put	7665.0000	2026-09-29	12.3200	12.2000	12.5000	7664.7400	19710.00	2490.00	15990.00	16	9	28584	952	30.0252100840336	0.182428700254468	0.182217338351091	false	false	false	true
6792d668-afd6-49a3-a7cf-94c6cee70c97	2026-09-29 11:41	2026-09-29 11:41	2026-09-29 11:41	SPXW	SPXW260929P07660000	put	7660.0000	2026-09-29	10.2700	10.1000	10.3000	7664.9800	110920.00	94750.00	15150.00	108	21	39621	5172	7.66067285382831	0.187496692249622	0.186001033768238	false	false	false	true
fc95c54e-923b-4067-a559-ec6048daca08	2026-09-29 11:41	2026-09-29 11:41	2026-09-29 11:41	SPXW	SPXW260929P07670000	put	7670.0000	2026-09-29	14.6400	14.5000	14.8000	7665.2100	20490.00	0.00	14650.00	14	9	34279	1317	26.0280941533789	0.180571240850141	0.179084781260632	false	false	false	true
19eed46c-aae6-495d-9605-4ef5fcf35e93	2026-09-29 11:41	2026-09-29 11:41	2026-09-29 11:41	SPXW	SPXW260929P07660000	put	7660.0000	2026-09-29	9.9000	9.8000	10.0000	7665.7700	251440.00	230670.00	1960.00	254	37	39248	5172	7.58855375096674	0.18656447761479	0.18656447761479	false	false	false	true
d4099e93-c758-4d95-be52-b2a75efb489b	2026-09-29 11:40	2026-09-29 11:40	2026-09-29 11:40	SPXW	SPXW260929C07690000	call	7690.0000	2026-09-29	3.8000	3.7000	3.8000	7667.7500	18980.00	18240.00	740.00	50	8	40031	1049	38.161105815062	0.171307520280324	0.171307520280324	false	false	false	true
19352f37-4b78-4732-86a2-1e7fd20a707b	2026-09-29 11:39	2026-09-29 11:39	2026-09-29 11:39	SPXW	SPXW260929C07680000	call	7680.0000	2026-09-29	6.6000	6.6000	6.8000	7669.1800	33670.00	0.00	33000.00	51	6	36637	720	50.8847222222222	0.164820904233361	0.163243998495205	false	false	false	true
b87cb2a1-e893-46c6-9d66-36b62c574cd9	2026-09-29 11:39	2026-09-29 11:39	2026-09-29 11:39	SPXW	SPXW260929C07670000	call	7670.0000	2026-09-29	11.7800	11.6000	11.8000	7669.9300	11780.00	9440.00	2340.00	10	5	18100	266	68.0451127819549	0.172508823895988	0.172508823895988	false	false	false	true
1e4b2549-07dc-4864-b58a-37528a9de773	2026-09-29 11:39	2026-09-29 11:39	2026-09-29 11:39	SPXW	SPXW260929C07680000	call	7680.0000	2026-09-29	7.6000	7.6000	7.8000	7670.2600	21290.00	0.00	20520.00	28	8	36496	720	50.6888888888889	0.17417222462758	0.17262785815793	false	false	false	true
70bad87f-1748-4cb8-a50c-87bb840a18d5	2026-09-29 11:39	2026-09-29 11:39	2026-09-29 11:39	SPXW	SPXW260929P07670000	put	7670.0000	2026-09-29	11.7000	11.7000	11.8000	7669.7500	30430.00	1180.00	29250.00	26	7	33447	1317	25.3963553530752	0.172359201002626	0.17089253771107	false	false	false	true
51fd8ae0-419e-46b9-8971-7048f713d357	2026-09-29 11:37	2026-09-29 11:37	2026-09-29 11:37	SPXW	SPXW260929P07670000	put	7670.0000	2026-09-29	13.2200	13.2000	13.4000	7667.3900	15860.00	0.00	14530.00	12	6	33068	1317	25.1085801063022	0.175970067362903	0.174502721190538	false	false	false	true
9c81a784-85fe-43d3-bc1c-1ea0ccf7d509	2026-09-29 11:37	2026-09-29 11:37	2026-09-29 11:37	SPXW	SPXW260929P07670000	put	7670.0000	2026-09-29	13.9000	13.9000	14.1000	7666.7900	29200.00	0.00	29200.00	21	6	32997	1317	25.0546697038724	0.183945054690512	0.179964210377296	false	false	false	true
5de13e72-133a-4b1a-806d-5bd4ecc52e6a	2026-09-29 11:36	2026-09-29 11:36	2026-09-29 11:36	SPXW	SPXW260929C07670000	call	7670.0000	2026-09-29	10.7400	10.6000	10.9000	7645.0000	18250.00	0.00	9630.00	17	5	16871	266	63.4248120300752	0.17265730359465	0.171194815768506	false	false	false	true
b7aeb16e-c844-4a6a-a650-b601b3986132	2026-09-29 11:36	2026-09-29 11:35	2026-09-29 11:35	SPXW	SPXW260929C07665000	call	7665.0000	2026-09-29	12.9900	12.9000	13.1000	7645.0000	18180.00	0.00	18180.00	14	6	11005	290	37.948275862069	0.166949880721975	0.165483210436068	false	false	false	true
4519cc8a-7b1b-4a8b-a8db-9af82ae6d5fc	2026-09-29 11:35	2026-09-29 11:35	2026-09-29 11:35	SPXW	SPXW260929P07650000	put	7650.0000	2026-09-29	5.9000	5.9000	6.0000	7645.0000	12990.00	600.00	12390.00	22	10	58670	6833	8.58627250109761	0.187887040371301	0.186697482614503	false	false	false	true
39c8ab98-12c0-4b4c-8e0e-7d79e9a1c1df	2026-09-29 11:35	2026-09-29 11:35	2026-09-29 11:35	SPXW	SPXW260929C07675000	call	7675.0000	2026-09-29	8.4100	8.4000	8.6000	7645.0000	12620.00	0.00	11770.00	15	7	21623	1911	11.3150183150183	0.172883496972759	0.172883496972759	false	false	false	true
5790f2a8-1a4e-4b5a-bb16-e3d96ba3a47f	2026-09-29 11:35	2026-09-29 11:35	2026-09-29 11:35	SPXW	SPXW260929C07665000	call	7665.0000	2026-09-29	12.9500	13.0000	13.1000	7645.0000	22010.00	0.00	22010.00	17	9	10871	290	37.4862068965517	0.169093447420239	0.169093447420239	false	false	false	true
b98a84d4-61bd-429e-be00-f228c1c2056c	2026-09-29 11:35	2026-09-29 11:35	2026-09-29 11:35	SPXW	SPXW260929C07670000	call	7670.0000	2026-09-29	10.5200	10.5000	10.7000	7645.0000	17880.00	1070.00	16810.00	17	9	16527	266	62.1315789473684	0.169308855134897	0.17076946174645	false	false	false	true
4eeff36e-b90c-4146-a0f4-5e6fdfa43e9f	2026-09-29 11:35	2026-09-29 11:35	2026-09-29 11:35	SPXW	SPXW260929C07660000	call	7660.0000	2026-09-29	15.9200	15.9000	16.1000	7645.0000	27060.00	0.00	25460.00	17	8	9846	1351	7.2879348630644	0.169511738853419	0.169511738853419	false	false	false	true
b4e6d891-b19f-446e-b0cb-55b2c948914d	2026-09-29 11:35	2026-09-29 11:35	2026-09-29 11:35	SPXW	SPXW260929C07670000	call	7670.0000	2026-09-29	10.7600	10.7000	10.9000	7645.0000	22600.00	0.00	22600.00	21	7	16492	266	62	0.169777615303998	0.170055791407959	false	false	false	true
f69a2d48-3906-4c97-9897-74c86d5797bd	2026-09-29 11:35	2026-09-29 11:34	2026-09-29 11:34	SPXW	SPXW260929C07660000	call	7660.0000	2026-09-29	16.1500	16.1000	16.3000	7645.0000	17770.00	0.00	16150.00	11	8	9737	1351	7.20725388601036	0.171830763907378	0.170320106063523	false	false	false	true
9d69a1a9-5cd8-4020-a639-75a8b12c2d8d	2026-09-29 11:34	2026-09-29 11:34	2026-09-29 11:34	SPXW	SPXW260929C07670000	call	7670.0000	2026-09-29	10.3000	10.3000	10.4000	7645.0000	36060.00	1040.00	35020.00	35	6	16072	266	60.4210526315789	0.169069473916567	0.167609283198742	false	false	false	true
c6520b5c-f676-4340-bd9e-2adcfef54e03	2026-09-29 11:34	2026-09-29 11:34	2026-09-29 11:34	SPXW	SPXW260929C07675000	call	7675.0000	2026-09-29	8.2200	8.2000	8.3000	7645.0000	20540.00	3320.00	17220.00	25	13	21253	1911	11.1214024071167	0.169567188587033	0.168064247819615	false	false	false	true