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:alert_rule = RepeatedHits×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	expirydate

74bba13e-ee7e-4cff-9e55-56365193a47d	2026-09-25 15:58	2026-09-25 15:58	2026-09-25 15:58	SPXW	SPXW260925P07750000	put	7750.0000	2026-09-25	4.4000	4.1000	4.5000	7745.3400	18920.00	18480.00	440.00	43	7	40105	4237	9.46542364880812	0	0	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-09-25T19:58:21.779683Z"}	2026-09-25	2026-09-25 21:15	2026-09-25 21:15
2c8c6bcb-97ff-473f-85ad-e18fa981d376	2026-09-25 15:58	2026-09-25 15:58	2026-09-25 15:58	SPXW	SPXW260928P07725000	put	7725.0000	2026-09-28	13.1000	12.9000	13.2000	7745.5600	64190.00	30130.00	34060.00	49	8	3298	1201	2.74604496253122	0.0815654252620908	0.0815654252620908	false	false	false	true
b6200847-66d6-4f99-b553-e76ffb7832b8	2026-09-25 15:57	2026-09-25 15:57	2026-09-25 15:57	SPXW	SPXW260929C07780000	call	7780.0000	2026-09-29	14.5000	14.4000	14.5000	7744.4500	50750.00	50750.00	0.00	35	6	1174	3444	0.340882694541231	0.0853007972181101	0.0853007972181101	false	false	false	true
4e3ca64f-38a6-48f6-8eef-5327640c41bf	2026-09-25 15:57	2026-09-25 15:57	2026-09-25 15:57	SPXW	SPXW260929P07750000	put	7750.0000	2026-09-29	30.5000	30.4000	30.5000	7744.3900	106750.00	106750.00	0.00	35	9	618	238	2.59663865546218	0.0908395264040658	0.0908395264040658	false	false	false	true
6a4396d8-ce39-482a-9298-1d9668625777	2026-09-25 15:57	2026-09-25 15:57	2026-09-25 15:57	SPXW	SPXW260928C07785000	call	7785.0000	2026-09-28	6.8000	6.7000	6.9000	7744.4500	68000.00	14960.00	53040.00	100	8	2187	435	5.02758620689655	0.0726961991442026	0.0726961991442026	false	false	false	true
7136f30e-f656-4b7d-ad24-648f108b1bd2	2026-09-25 15:57	2026-09-25 15:57	2026-09-25 15:57	SPXW	SPXW261002C07750000	call	7750.0000	2026-10-02	47.3000	47.5000	47.8000	7744.8400	6243600.00	0.00	6243600.00	1320	7	2677	3704	0.722732181425486	0.109616156176449	0.109616156176449	false	true	false	true
ea9807ca-220c-419a-8ca2-f8d95e649f10	2026-09-25 15:57	2026-09-25 15:57	2026-09-25 15:57	SPXW	SPXW261002C07800000	call	7800.0000	2026-10-02	25.7000	25.4000	25.7000	7745.4300	102800.00	102800.00	0.00	40	6	2178	5674	0.38385618611209	0.107072861518132	0.107072861518132	false	false	false	true
4e75fd74-acad-4e71-9bd8-38752b8e4b6b	2026-09-25 15:57	2026-09-25 15:57	2026-09-25 15:57	SPXW	SPXW260928P07740000	put	7740.0000	2026-09-28	18.7000	18.6000	18.9000	7744.4100	18700.00	0.00	18700.00	10	7	5052	292	17.3013698630137	0.0785979662967929	0.0785979662967929	false	false	false	true
0797f4cb-a22c-4939-84fa-9c05ebb1eeb1	2026-09-25 15:57	2026-09-25 15:57	2026-09-25 15:57	SPXW	SPXW261001C07875000	call	7875.0000	2026-10-01	5.0000	4.9000	5.1000	7744.2700	30000.00	20000.00	6500.00	60	8	314	5376	0.0584077380952381	0.0998971026915552	0.0998971026915552	false	false	false	true
9da4252d-cd73-41b9-8f09-349f40f55818	2026-09-25 15:57	2026-09-25 15:57	2026-09-25 15:57	SPXW	SPXW261102C08100000	call	8100.0000	2026-11-02	16.4000	16.4000	16.5000	7744.3600	246000.00	0.00	246000.00	150	6	522	7	74.5714285714286	0.10753611649719	0.10753611649719	false	false	false	true
282b9ae8-f0ae-4e94-9a82-59ce7b538dc8	2026-09-25 15:57	2026-09-25 15:57	2026-09-25 15:57	SPXW	SPXW260925C07740000	call	7740.0000	2026-09-25	5.8000	5.6000	5.9000	7744.4600	13340.00	13340.00	0.00	23	5	202143	3681	54.9152404237979	0.416726371919509	0.416726371919509	false	false	false	true
d6642dc7-28f3-4444-bf08-381359105b73	2026-09-25 15:56	2026-09-25 15:56	2026-09-25 15:56	SPXW	SPXW261002C07800000	call	7800.0000	2026-10-02	24.9000	24.8000	25.1000	7743.6500	74700.00	17430.00	57270.00	30	8	2138	5674	0.376806485724357	0.106557425052015	0.106557425052015	false	false	false	true
51cac936-3c60-4b38-a022-b39e04792b1f	2026-09-25 15:56	2026-09-25 15:56	2026-09-25 15:56	SPXW	SPXW260925P07750000	put	7750.0000	2026-09-25	6.0000	5.9000	6.0000	7743.8100	13800.00	13800.00	0.00	23	16	39323	4237	9.28085909841869	0	0	false	false	false	true
b43a25f6-ac10-4d7a-beb1-e5188a588c4b	2026-09-25 15:56	2026-09-25 15:56	2026-09-25 15:56	SPXW	SPXW260928C07800000	call	7800.0000	2026-09-28	3.8000	3.6000	3.8000	7744.1200	11400.00	11400.00	0.00	30	6	9117	2655	3.43389830508475	0.0718055431494661	0.0718055431494661	false	false	false	true
7bf8e369-2318-459e-bf62-7ba781a9e510	2026-09-25 15:56	2026-09-25 15:56	2026-09-25 15:56	SPXW	SPXW261002C07700000	call	7700.0000	2026-10-02	78.5000	78.4000	78.5000	7743.9600	157000.00	157000.00	0.00	20	5	3220	8228	0.391346621293145	0.116363293844285	0.116363293844285	false	false	false	true
5c4c28a5-15c3-4874-9fdf-9d96a98f25a8	2026-09-25 15:56	2026-09-25 15:56	2026-09-25 15:56	SPXW	SPXW260928C07800000	call	7800.0000	2026-09-28	3.8000	3.6000	3.8000	7744.0800	26600.00	26600.00	0.00	70	10	9087	2655	3.4225988700565	0.071841927334724	0.071841927334724	false	false	false	true
3494d02b-add8-4517-8cd5-3660fcad40d5	2026-09-25 15:56	2026-09-25 15:56	2026-09-25 15:56	SPXW	SPXW260928C07765000	call	7765.0000	2026-09-28	12.1000	12.1000	12.2000	7743.7900	24200.00	0.00	24200.00	20	6	2007	256	7.83984375	0.0715417453527392	0.0715417453527392	false	false	false	true
5637e37e-cef5-4e6a-afd7-c87cdf40caa7	2026-09-25 15:56	2026-09-25 15:56	2026-09-25 15:56	SPXW	SPXW260925P07750000	put	7750.0000	2026-09-25	6.0000	5.7000	6.0000	7743.7800	33000.00	33000.00	0.00	55	6	39058	4237	9.21831484540949	0	0	false	false	false	true
4c830d6c-83e1-4a2b-bedd-ffa24a6b04bd	2026-09-25 15:56	2026-09-25 15:56	2026-09-25 15:56	SPXW	SPXW260925C07740000	call	7740.0000	2026-09-25	5.2000	5.2000	5.3000	7744.7200	52000.00	0.00	52000.00	100	9	201522	3681	54.7465362673187	0.24143570344217	0.24143570344217	false	false	false	true
ff9085f7-8a4a-4fc1-b90a-c17cd6586bf6	2026-09-25 15:56	2026-09-25 15:56	2026-09-25 15:56	SPXW	SPXW260925P07750000	put	7750.0000	2026-09-25	5.1200	4.8000	5.2000	7745.1300	14860.00	11830.00	1500.00	29	10	38714	4237	9.13712532452207	0.191734537573544	0.16521260165693	false	false	false	true
4c434456-3467-4954-b9f3-b949d98bb2e4	2026-09-25 15:56	2026-09-25 15:56	2026-09-25 15:56	SPXW	SPXW260928P07735000	put	7735.0000	2026-09-28	16.5000	16.4000	16.7000	7745.1300	19800.00	0.00	19800.00	12	6	2398	196	12.234693877551	0.0795561823373093	0.0795561823373093	true	false	false	true
347aa65b-cd96-464e-abb1-110aafb31c4d	2026-09-25 15:56	2026-09-25 15:56	2026-09-25 15:56	SPXW	SPXW260925P07750000	put	7750.0000	2026-09-25	5.0000	4.8000	5.0000	7745.0900	33000.00	33000.00	0.00	66	21	38685	4237	9.13028085909842	0.152424728274892	0.152424728274892	false	false	false	true
c152d78c-c716-48da-add5-20f6da273808	2026-09-25 15:56	2026-09-25 15:55	2026-09-25 15:55	SPXW	SPXW260925P07750000	put	7750.0000	2026-09-25	4.5000	4.4000	4.6000	7746.3900	10800.00	10360.00	440.00	24	12	38516	4237	9.09039414680198	0.262902682518807	0.248404624001195	false	false	false	true
91e5607f-b9ca-4b69-a3d3-99058e610760	2026-09-25 15:56	2026-09-25 15:55	2026-09-25 15:55	SPXW	SPXW260928P07730000	put	7730.0000	2026-09-28	14.5000	14.4000	14.5000	7746.5800	20300.00	20300.00	0.00	14	5	3318	636	5.21698113207547	0.0814720207336031	0.0814720207336031	false	false	false	true
29b3abb4-19c4-4ed8-8aed-d6b5de1251f7	2026-09-25 15:55	2026-09-25 15:55	2026-09-25 15:55	SPXW	SPXW260925P07750000	put	7750.0000	2026-09-25	4.0000	3.9000	4.0000	7747.0800	14400.00	14400.00	0.00	36	20	37790	4237	8.91904649516167	0.245206713158453	0.245206713158453	false	false	false	true
5962d13f-6e44-41f7-8b71-4b08230c65b9	2026-09-25 15:55	2026-09-25 15:55	2026-09-25 15:55	SPXW	SPXW260925P07755000	put	7755.0000	2026-09-25	6.9000	6.6000	7.0000	7748.0100	12420.00	9660.00	2760.00	18	5	9836	370	26.5837837837838	0.116593665502697	0.130247770030607	false	false	false	true
f86537ed-cbb3-4379-8081-68807dbd6338	2026-09-25 15:55	2026-09-25 15:54	2026-09-25 15:54	SPXW	SPXW260929P07750000	put	7750.0000	2026-09-29	29.2000	29.1000	29.4000	7747.6500	143080.00	105120.00	37960.00	49	6	510	238	2.14285714285714	0.0918718611168424	0.0918718611168424	false	false	false	true
ab6178ed-b9fb-4693-8213-35652c47e612	2026-09-25 15:55	2026-09-25 15:54	2026-09-25 15:54	SPXW	SPXW260929P07750000	put	7750.0000	2026-09-29	29.2000	29.1000	29.2000	7747.5500	148920.00	148920.00	0.00	51	8	561	238	2.35714285714286	0.0917195636044488	0.0917195636044488	false	false	false	true
7bcf01fc-0356-4a5b-a4c2-333373eca021	2026-09-25 15:55	2026-09-25 15:54	2026-09-25 15:54	SPXW	SPXW260929C07780000	call	7780.0000	2026-09-29	15.5000	15.4000	15.7000	7747.6400	155000.00	85250.00	69750.00	100	11	978	3444	0.28397212543554	0.0851085619210414	0.0851085619210414	false	false	false	true
dece48da-50ad-4fb3-b7cf-46098270aab3	2026-09-25 15:54	2026-09-25 15:54	2026-09-25 15:54	SPXW	SPXW260928C07785000	call	7785.0000	2026-09-28	7.4000	7.3000	7.4000	7748.0300	119140.00	119140.00	0.00	161	5	2042	435	4.69425287356322	0.0715229105639552	0.0715229105639552	false	false	false	true
d67cd2f5-4810-45af-8f95-7fbd8482e478	2026-09-25 15:54	2026-09-25 15:54	2026-09-25 15:54	SPXW	SPXW260928C07785000	call	7785.0000	2026-09-28	7.4000	7.3000	7.6000	7747.8100	31080.00	0.00	31080.00	42	9	1784	435	4.10114942528736	0.0717683492523779	0.0717683492523779	false	false	false	true
c96321eb-c109-4b44-b7d1-c4b5ea762b8d	2026-09-25 15:54	2026-09-25 15:54	2026-09-25 15:54	SPXW	SPXW260928C07785000	call	7785.0000	2026-09-28	7.4000	7.4000	7.5000	7748.0500	31820.00	0.00	31820.00	43	7	1854	435	4.26206896551724	0.0715005836792542	0.0715005836792542	false	false	false	true
9c6aaa01-2b8c-4f77-9756-0d95780a51bc	2026-09-25 15:54	2026-09-25 15:54	2026-09-25 15:54	SPXW	SPXW260928C07785000	call	7785.0000	2026-09-28	7.4000	7.3000	7.5000	7748.0500	15540.00	0.00	11840.00	21	5	1881	435	4.32413793103448	0.0715005836792542	0.0715005836792542	false	false	false	true
7218b2f5-d4fc-49c5-b2a9-bedd3372769a	2026-09-25 15:54	2026-09-25 15:54	2026-09-25 15:54	SPXW	SPXW260928C07785000	call	7785.0000	2026-09-28	7.4000	7.4000	7.6000	7748.0500	19980.00	0.00	19980.00	27	5	1811	435	4.1632183908046	0.0715005836792542	0.0715005836792542	false	false	false	true
d8579b36-7c9c-4907-8f3a-355deea585df	2026-09-25 15:54	2026-09-25 15:54	2026-09-25 15:54	SPXW	SPXW260928C07755000	call	7755.0000	2026-09-28	18.2000	18.0000	18.2000	7748.2700	18200.00	18200.00	0.00	10	5	2203	564	3.90602836879433	0.0721286217831857	0.0721286217831857	false	false	false	true
2032a0f9-0699-4331-9a3a-9a4513352d2e	2026-09-25 15:54	2026-09-25 15:54	2026-09-25 15:54	SPXW	SPXW260928P07720000	put	7720.0000	2026-09-28	10.8000	10.7000	11.0000	7748.4900	38880.00	5400.00	33480.00	36	8	3774	423	8.92198581560284	0.0824953836188295	0.0824953836188295	false	false	false	true
f1d973f7-09e7-49b4-87f1-861500acca0b	2026-09-25 15:54	2026-09-25 15:54	2026-09-25 15:54	SPXW	SPXW260928C07795000	call	7795.0000	2026-09-28	5.7000	5.6000	5.8000	7749.4300	17100.00	12540.00	0.00	30	6	3143	654	4.80581039755352	0.072503584678825	0.072503584678825	false	false	false	true
51b332cf-9dd7-4469-a39e-ee5ee423eea5	2026-09-25 15:54	2026-09-25 15:54	2026-09-25 15:54	SPXW	SPXW260928C07795000	call	7795.0000	2026-09-28	5.7000	5.5000	5.7000	7749.4300	30210.00	30210.00	0.00	53	11	3113	654	4.75993883792049	0.072503584678825	0.072503584678825	false	false	false	true
7dad493d-64dc-4583-b906-3b6abd7bfbad	2026-09-25 15:54	2026-09-25 15:53	2026-09-25 15:53	SPXW	SPXW260925P07750000	put	7750.0000	2026-09-25	2.4500	2.4500	2.5500	7749.4000	12005.00	0.00	12005.00	49	16	36435	4237	8.59924474864291	0.204162353704546	0.204162353704546	false	false	false	true
4e9c3633-e449-48ac-b0f4-367f12e88bda	2026-09-25 15:53	2026-09-25 15:53	2026-09-25 15:53	SPXW	SPXW260925C07745000	call	7745.0000	2026-09-25	5.2000	5.1000	5.4000	7748.7600	13000.00	12480.00	520.00	25	8	180099	4815	37.403738317757	0.284863326148402	0.274707374233716	false	false	false	true
17724dce-fe33-4d6d-870b-c84c10ca6b46	2026-09-25 15:53	2026-09-25 15:53	2026-09-25 15:53	SPXW	SPXW261030C08200000	call	8200.0000	2026-10-30	7.1000	7.1000	7.2000	7748.6200	116440.00	0.00	116440.00	164	6	229	3481	0.0657856937661592	0.109769752536972	0.109769752536972	false	false	false	true
b4631f73-544b-4bbb-8fc9-db72770be5ff	2026-09-25 15:53	2026-09-25 15:53	2026-09-25 15:53	SPXW	SPXW260928P07725000	put	7725.0000	2026-09-28	12.4000	12.4000	12.5000	7748.0500	12400.00	0.00	12400.00	10	6	3192	1201	2.65778517901749	0.0820834173774813	0.0820834173774813	false	false	false	true
bf3c425c-a03d-4893-9327-08e9634a9fc6	2026-09-25 15:53	2026-09-25 15:53	2026-09-25 15:53	SPXW	SPXW261002C07805000	call	7805.0000	2026-10-02	24.6000	24.5000	24.7000	7748.5700	34440.00	31980.00	2460.00	14	5	281	281	1	0.105783993195985	0.105783993195985	false	false	false	true
09a68ffd-d3d0-4aaa-a1e0-e51e28abceb6	2026-09-25 15:53	2026-09-25 15:53	2026-09-25 15:53	SPXW	SPXW260928P07700000	put	7700.0000	2026-09-28	6.7000	6.6000	6.7000	7748.6300	44220.00	44220.00	0.00	66	6	6187	1749	3.53744997141224	0.0863859524314142	0.0863859524314142	false	false	false	true
01604538-4722-46a4-bf20-2dd850425c2d	2026-09-25 15:53	2026-09-25 15:53	2026-09-25 15:53	SPXW	SPXW260925P07745000	put	7745.0000	2026-09-25	1.0000	0.9500	1.0500	7748.6300	10405.00	105.00	10300.00	104	6	55112	491	112.244399185336	0.217169723573483	0.222605149541405	false	false	false	true
2d336001-9e83-4e11-8447-30a96ba3e84b	2026-09-25 15:53	2026-09-25 15:53	2026-09-25 15:53	SPXW	SPXW260928P07700000	put	7700.0000	2026-09-28	6.7000	6.6000	6.7000	7748.5500	14740.00	14740.00	0.00	22	5	6121	1749	3.49971412235563	0.0863049588561833	0.0863049588561833	false	false	false	true
d235ae54-b23e-4c18-8d68-a4ddaa11cbfd	2026-09-25 15:53	2026-09-25 15:53	2026-09-25 15:53	SPXW	SPXW260928P07700000	put	7700.0000	2026-09-28	6.6000	6.4000	6.6000	7749.0600	37620.00	37620.00	0.00	57	11	6051	1749	3.45969125214408	0.0863065338951399	0.0863065338951399	false	false	false	true
2c5873ad-3735-4342-934b-39c5883622a9	2026-09-25 15:53	2026-09-25 15:53	2026-09-25 15:53	SPXW	SPXW260925C07750000	call	7750.0000	2026-09-25	2.0000	1.9000	2.0000	7749.0400	14000.00	14000.00	0.00	70	8	223754	8398	26.6437246963563	0.220442258949474	0.220442258949474	false	false	false	true
001e4cb3-b052-4a43-ba6c-abf626ffbcd0	2026-09-25 15:53	2026-09-25 15:53	2026-09-25 15:53	SPXW	SPXW260928P07700000	put	7700.0000	2026-09-28	6.7000	6.6000	6.8000	7749.0400	17420.00	16750.00	0.00	26	6	6097	1749	3.48599199542596	0.0868006583396387	0.0868006583396387	false	false	false	true
879827ed-98ef-432b-8d21-7afb4b18ced6	2026-09-25 15:53	2026-09-25 15:53	2026-09-25 15:53	SPXW	SPXW260928P07700000	put	7700.0000	2026-09-28	6.6000	6.5000	6.7000	7748.4700	18480.00	12540.00	0.00	28	6	5992	1749	3.42595769010863	0.0857112699545439	0.0857112699545439	false	false	false	true