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

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

8709e745-552f-4723-962e-baac1e2087a8	2026-10-02 15:41	2026-10-02 15:41	2026-10-02 15:41	SPXW	SPXW261002C07700000	call	7700.0000	2026-10-02	25.7000	25.4000	25.9000	7725.7400	25700.00	15420.00	0.00	10	5	17427	7148	2.43802462227196	0.236074594741287	0.298120445226083	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-10-02T19:44:29.221756Z"}	2026-10-02	2026-10-02 21:15	2026-10-02 21:15
8804aff2-09ae-4ec0-8496-1a82315f2fd2	2026-10-02 15:38	2026-10-02 15:38	2026-10-02 15:38	SPXW	SPXW261002C07700000	call	7700.0000	2026-10-02	26.7000	26.7000	27.1000	7727.5700	26700.00	0.00	26700.00	10	5	17352	7148	2.42753217683268	0.217965192937549	0.217965192937549	false	false	false	true
7777ce60-f437-4d2d-9f76-3eddfaba1288	2026-10-02 15:34	2026-10-02 15:34	2026-10-02 15:34	SPXW	SPXW261002C07700000	call	7700.0000	2026-10-02	24.8200	24.6000	24.9000	7705.0000	12410.00	12410.00	0.00	5	5	17181	7148	2.40360940123111	0.186023108819045	0.186023108819045	false	false	false	true
7199f00e-59cc-4165-b69a-e9d474477179	2026-10-02 15:33	2026-10-02 15:33	2026-10-02 15:33	SPXW	SPXW261002C07700000	call	7700.0000	2026-10-02	22.2000	22.2000	22.5000	7700.0000	22200.00	0.00	22200.00	10	7	17156	7148	2.40011191941802	0.230973480010926	0.230973480010926	false	false	false	true
2eea5ea7-210d-4633-8be5-0f6fec6b2f09	2026-10-02 15:26	2026-10-02 15:26	2026-10-02 15:26	SPXW	SPXW261002C07700000	call	7700.0000	2026-10-02	23.0000	22.7000	23.1000	7723.1900	23000.00	23000.00	0.00	10	6	16935	7148	2.36919418019026	0.17719795005833	0.17719795005833	false	false	false	true
a8d27a97-bb47-4b1f-b896-4cb3cc60eabb	2026-10-02 15:18	2026-10-02 15:18	2026-10-02 15:18	SPXW	SPXW261002C07700000	call	7700.0000	2026-10-02	21.7000	21.7000	22.0000	7721.1300	21700.00	0.00	21700.00	10	7	16685	7148	2.33421936205932	0.219687953203837	0.219687953203837	false	false	false	true
4228e28c-f7e7-42f7-a1fc-a377d58ce03f	2026-10-02 15:16	2026-10-02 15:16	2026-10-02 15:16	SPXW	SPXW261002C07700000	call	7700.0000	2026-10-02	20.1000	20.0000	20.3000	7719.9300	20100.00	0.00	20100.00	10	5	16614	7148	2.32428651371013	0.154904060647244	0.154904060647244	false	false	false	true
784ba4a2-88fc-4dd9-9429-0cb773909864	2026-10-02 15:15	2026-10-02 15:15	2026-10-02 15:15	SPXW	SPXW261002C07700000	call	7700.0000	2026-10-02	20.1000	19.9000	20.2000	7719.7200	20100.00	20100.00	0.00	10	6	16591	7148	2.32106883044208	0.182540637652981	0.182540637652981	false	false	false	true
eeaa10d2-787a-4d75-8cf7-94dcdc9bb876	2026-10-02 15:15	2026-10-02 15:14	2026-10-02 15:14	SPXW	SPXW261002C07700000	call	7700.0000	2026-10-02	20.2200	20.1000	20.4000	7720.0600	20220.00	0.00	16160.00	10	5	16575	7148	2.3188304420817	0.164943800258424	0.164943800258424	false	false	false	true
8199d16e-af23-4cb4-87c4-c2d546589cd6	2026-10-02 14:59	2026-10-02 14:59	2026-10-02 14:59	SPXW	SPXW261002C07700000	call	7700.0000	2026-10-02	22.1000	22.1000	22.4000	7721.5900	22100.00	0.00	22100.00	10	7	16180	7148	2.26357022943481	0.178207771827797	0.178207771827797	false	false	false	true
f89814bb-e0a4-4f7d-91a4-abaf72edcb3d	2026-10-02 14:52	2026-10-02 14:52	2026-10-02 14:52	SPXW	SPXW261002C07700000	call	7700.0000	2026-10-02	21.8200	21.7000	22.0000	7721.5300	45820.00	28380.00	17440.00	21	9	16043	7148	2.24440402909905	0.16308727665869	0.165327823861273	true	false	false	true
187bd9e2-3d05-493b-adf2-3b3637a1e293	2026-10-02 14:47	2026-10-02 14:47	2026-10-02 14:47	SPXW	SPXW261002C07700000	call	7700.0000	2026-10-02	21.2000	21.0000	21.2000	7700.0000	21200.00	21200.00	0.00	10	6	15909	7148	2.22565752658086	0.148394381365639	0.148394381365639	false	false	false	true
37e99e7d-db75-46ca-96ce-88f16d9ded92	2026-10-02 14:44	2026-10-02 14:44	2026-10-02 14:44	SPXW	SPXW261002C07700000	call	7700.0000	2026-10-02	20.9000	20.7000	20.9000	7700.0000	20900.00	20900.00	0.00	10	5	15809	7148	2.21166759932848	0.165183276991161	0.165183276991161	false	false	false	true
38ac0f5b-4ce0-402e-892f-5f67cf935d27	2026-10-02 14:33	2026-10-02 14:32	2026-10-02 14:32	SPXW	SPXW261002C07700000	call	7700.0000	2026-10-02	20.9400	20.8000	21.1000	7719.8800	29320.00	12600.00	16720.00	14	9	15407	7148	2.15542809177392	0.174314223509009	0.169307399183961	false	false	false	true
b45eda9a-efe8-44cd-a955-d510f831c492	2026-10-02 14:28	2026-10-02 14:28	2026-10-02 14:28	SPXW	SPXW261002C07700000	call	7700.0000	2026-10-02	17.3800	17.3000	17.8000	7715.8000	34770.00	0.00	34770.00	20	7	15166	7148	2.12171236709569	0.168161050257019	0.168161050257019	false	false	false	true
df41258f-743a-45bf-9ab9-2dab3d9486d5	2026-10-02 14:25	2026-10-02 14:25	2026-10-02 14:25	SPXW	SPXW261002C07700000	call	7700.0000	2026-10-02	16.5000	16.4500	16.6000	7714.7000	33000.00	0.00	33000.00	20	10	15007	7148	2.09946838276441	0.161788693764213	0.161788693764213	false	false	false	true
5548e396-5073-4227-8b68-f46374a15e20	2026-10-02 14:22	2026-10-02 14:21	2026-10-02 14:21	SPXW	SPXW261002C07700000	call	7700.0000	2026-10-02	18.0100	18.0000	18.2000	7716.9600	19810.00	0.00	18000.00	11	5	14730	7148	2.06071628427532	0.147831297511333	0.143421891245585	false	false	false	true
9e97c176-f29c-4099-9ed7-611650d8f028	2026-10-02 13:51	2026-10-02 13:51	2026-10-02 13:51	SPXW	SPXW261002C07700000	call	7700.0000	2026-10-02	22.5000	22.5000	22.7000	7720.9300	47250.00	0.00	47250.00	21	8	13610	7148	1.90402909904869	0.165037367906772	0.165037367906772	false	false	false	true
417a4c31-c3a8-4e5d-b30c-6d11b11b5297	2026-10-02 13:50	2026-10-02 13:49	2026-10-02 13:49	SPXW	SPXW261002C07700000	call	7700.0000	2026-10-02	21.7100	21.7000	22.0000	7719.9600	45600.00	0.00	45600.00	21	8	13490	7148	1.88724118634583	0.168356023838517	0.168356023838517	false	false	false	true
370da06b-004d-4eb5-917f-7641cb5afa64	2026-10-02 13:50	2026-10-02 13:49	2026-10-02 13:49	SPXW	SPXW261002C07700000	call	7700.0000	2026-10-02	22.0000	21.9000	22.2000	7719.9100	44000.00	30800.00	13200.00	20	6	13469	7148	1.88430330162283	0.176231036546794	0.176231036546794	false	false	false	true
a3a74ddd-0cdd-4b72-9aa7-06ed9beaec38	2026-10-02 13:48	2026-10-02 13:48	2026-10-02 13:48	SPXW	SPXW261002C07700000	call	7700.0000	2026-10-02	20.9000	20.7000	20.9000	7718.6700	29260.00	29260.00	0.00	14	5	13414	7148	1.87660884163402	0.172808200597907	0.172808200597907	false	false	false	true
25f23a93-33af-45d5-a1b3-0923ebbc409a	2026-10-02 13:33	2026-10-02 13:33	2026-10-02 13:33	SPXW	SPXW261002C07700000	call	7700.0000	2026-10-02	20.7000	20.5000	20.8000	7718.0500	12420.00	12420.00	0.00	6	5	12997	7148	1.81827084499161	0.171891708055103	0.171901715755341	true	false	false	true
15dafd0b-3c35-411c-a21e-d6ef0237d54e	2026-10-02 13:31	2026-10-02 13:31	2026-10-02 13:31	SPXW	SPXW261002C07700000	call	7700.0000	2026-10-02	19.0000	18.9000	19.0000	7695.0000	17100.00	17100.00	0.00	9	6	12875	7148	1.8012031337437	0.192124243965387	0.192124243965387	false	false	false	true
b35c10e9-ed95-4117-98b5-9084169bca0e	2026-10-02 12:35	2026-10-02 12:35	2026-10-02 12:35	SPXW	SPXW261002C07700000	call	7700.0000	2026-10-02	24.7000	24.6000	24.7000	7700.0000	12350.00	12350.00	0.00	5	5	11154	7148	1.56043648573027	0.171824754274447	0.171824754274447	false	false	false	true
99020a07-1fa6-4e70-9107-a45acdfd104d	2026-10-02 12:06	2026-10-02 12:06	2026-10-02 12:06	SPXW	SPXW261002C07700000	call	7700.0000	2026-10-02	27.3000	27.2000	27.5000	7723.8300	27300.00	0.00	27300.00	10	6	10521	7148	1.47188024622272	0.17854832537211	0.17854832537211	false	false	false	true
71122640-bf70-4fc8-9b4a-79efdfe55f03	2026-10-02 12:01	2026-10-02 12:01	2026-10-02 12:01	SPXW	SPXW261002C07700000	call	7700.0000	2026-10-02	28.4000	28.2000	28.5000	7726.0000	28400.00	8520.00	19880.00	10	6	10243	7148	1.43298824846111	0.161114264403084	0.161114264403084	false	false	false	true
474a717b-2aa5-4b4a-a8f9-aaba59e7b2b0	2026-10-02 12:01	2026-10-02 12:00	2026-10-02 12:00	SPXW	SPXW261002C07700000	call	7700.0000	2026-10-02	26.0000	25.8000	26.0000	7722.3000	23400.00	23400.00	0.00	9	5	10190	7148	1.42557358701735	0.174443622156168	0.174443622156168	false	false	false	true
acaf2bb4-cb87-406b-ae4d-1d67b54a9290	2026-10-02 11:58	2026-10-02 11:58	2026-10-02 11:58	SPXW	SPXW261002C07700000	call	7700.0000	2026-10-02	23.9400	23.9000	24.1000	7719.3200	16760.00	4800.00	9560.00	7	7	10061	7148	1.40752658086178	0.176952540420883	0.178838411240037	false	false	false	true
094b2d63-5e5a-4d33-abbe-bbca106ea876	2026-10-02 11:55	2026-10-02 11:55	2026-10-02 11:55	SPXW	SPXW261002C07700000	call	7700.0000	2026-10-02	20.7000	20.6000	20.9000	7715.0000	12420.00	0.00	12420.00	6	5	9954	7148	1.39255735870173	0.174555583446551	0.174555583446551	false	false	false	true
4e70d4c0-42f6-4dfb-a764-a1e24b900480	2026-10-02 11:54	2026-10-02 11:54	2026-10-02 11:54	SPXW	SPXW261002C07700000	call	7700.0000	2026-10-02	21.9300	21.9000	22.1000	7716.5600	21930.00	0.00	21930.00	10	5	9918	7148	1.38752098489088	0.177606856316591	0.175841632906232	false	false	false	true
dfb486bc-9aab-4715-84e6-dd0ee3a679c0	2026-10-02 11:40	2026-10-02 11:39	2026-10-02 11:39	SPXW	SPXW261002C07700000	call	7700.0000	2026-10-02	25.5000	25.5000	25.7000	7720.8300	25500.00	0.00	25500.00	10	6	9333	7148	1.30567991046447	0.17910371065441	0.17910371065441	false	false	false	true
58d5b07b-b8ee-41b0-9a1c-612159eca092	2026-10-02 11:40	2026-10-02 11:39	2026-10-02 11:39	SPXW	SPXW261002C07700000	call	7700.0000	2026-10-02	25.5000	25.5000	25.7000	7720.8300	25500.00	0.00	25500.00	10	5	9323	7148	1.30428091773923	0.17910371065441	0.17910371065441	false	false	false	true
9bc4abaf-f52f-4412-8495-201aae06d6be	2026-10-02 11:38	2026-10-02 11:38	2026-10-02 11:38	SPXW	SPXW261002C07700000	call	7700.0000	2026-10-02	24.8000	24.8000	25.0000	7700.0000	24800.00	0.00	24800.00	10	5	9189	7148	1.28553441522104	0.174116959001224	0.174116959001224	false	false	false	true
1a847bcf-d590-436c-a8fa-63d04109a633	2026-10-02 11:37	2026-10-02 11:37	2026-10-02 11:37	SPXW	SPXW261002C07700000	call	7700.0000	2026-10-02	25.2100	25.2000	25.4000	7700.0000	25210.00	0.00	22680.00	10	6	9145	7148	1.27937884722999	0.172724029728107	0.172724029728107	false	false	false	true
2c4628dd-cd98-4967-b313-e8dd5c8560db	2026-10-02 11:33	2026-10-02 11:33	2026-10-02 11:33	SPXW	SPXW261002C07700000	call	7700.0000	2026-10-02	25.5000	25.4000	25.5000	7700.0000	104550.00	104550.00	0.00	41	15	8902	7148	1.24538332400672	0.195381700659756	0.195381700659756	false	false	false	true
ae84b524-a74f-4dcc-a3b8-a8182823d995	2026-10-02 11:29	2026-10-02 11:29	2026-10-02 11:29	SPXW	SPXW261002C07700000	call	7700.0000	2026-10-02	22.4000	22.2000	22.4000	7695.0000	22400.00	22400.00	0.00	10	7	8218	7148	1.14969222160045	0.194943439760409	0.194943439760409	false	false	false	true
a4690906-1b39-45f1-b4a8-ab295f16b966	2026-10-02 11:28	2026-10-02 11:28	2026-10-02 11:28	SPXW	SPXW261002C07700000	call	7700.0000	2026-10-02	22.0000	21.8000	22.0000	7690.0000	17600.00	17600.00	0.00	8	6	8139	7148	1.13864017907107	0.207275129445477	0.207275129445477	false	false	false	true
a24bcd21-1625-41e1-9029-57ae726a5de7	2026-10-02 11:28	2026-10-02 11:28	2026-10-02 11:28	SPXW	SPXW261002C07700000	call	7700.0000	2026-10-02	21.7000	21.7000	21.9000	7690.0000	10850.00	0.00	10850.00	5	5	8130	7148	1.13738108561835	0.202674867085969	0.202674867085969	false	false	false	true
31787eee-aff9-4242-993b-a18475e5fb96	2026-10-02 11:27	2026-10-02 11:27	2026-10-02 11:27	SPXW	SPXW261002C07700000	call	7700.0000	2026-10-02	21.7400	21.7000	21.9000	7712.5300	108700.00	0.00	65100.00	50	8	7999	7148	1.11905428091774	0.208471212692973	0.20695226706908	false	false	false	true
46d5f5eb-6447-48d3-90f2-0f428c246747	2026-10-02 11:27	2026-10-02 11:27	2026-10-02 11:27	SPXW	SPXW261002C07700000	call	7700.0000	2026-10-02	21.7000	21.6000	21.9000	7711.9500	13020.00	0.00	13020.00	6	5	7947	7148	1.1117795187465	0.212474318296837	0.212474318296837	false	false	false	true
3a916c20-c1e9-454b-a2ea-b82079184177	2026-10-02 11:27	2026-10-02 11:27	2026-10-02 11:27	SPXW	SPXW261002C07700000	call	7700.0000	2026-10-02	21.0300	21.0000	21.2000	7711.6200	71500.00	21100.00	50400.00	34	9	7878	7148	1.10212646894236	0.204992735925464	0.206499884017016	false	false	false	true
b96f5f10-e2f1-483f-9ddb-638203f513a4	2026-10-02 11:26	2026-10-02 11:26	2026-10-02 11:26	SPXW	SPXW261002C07700000	call	7700.0000	2026-10-02	19.6800	19.6000	20.0000	7708.6900	47220.00	3960.00	43260.00	24	9	7656	7148	1.07106883044208	0.21347958378459	0.212011847586148	false	false	false	true
99ff7bc9-8162-4762-8646-c1aaa96f3779	2026-10-02 11:26	2026-10-02 11:26	2026-10-02 11:26	SPXW	SPXW261002C07700000	call	7700.0000	2026-10-02	18.9900	18.9000	19.1000	7706.7100	43680.00	39900.00	3780.00	23	6	7608	7148	1.06435366536094	0.218608657241118	0.217158419076285	false	false	false	true
e94d1a66-fcf6-416f-929e-f50f27bfa3a8	2026-10-02 11:26	2026-10-02 11:26	2026-10-02 11:26	SPXW	SPXW261002C07700000	call	7700.0000	2026-10-02	18.4000	18.2000	18.4000	7705.9300	92000.00	92000.00	0.00	50	10	7527	7148	1.05302182428651	0.216186686678792	0.216186686678792	false	false	false	true
81ba7810-9ec2-4b91-95bb-cffe9aa68cc9	2026-10-02 11:26	2026-10-02 11:26	2026-10-02 11:26	SPXW	SPXW261002C07700000	call	7700.0000	2026-10-02	17.5800	17.5000	17.7000	7704.8300	22850.00	3520.00	19330.00	13	6	7316	7148	1.023503077784	0.213391466898525	0.213391466898525	true	false	false	true
93996c0d-caa1-44bd-9c06-df2d06a34806	2026-10-02 11:25	2026-10-02 11:25	2026-10-02 11:25	SPXW	SPXW261002C07700000	call	7700.0000	2026-10-02	16.2000	16.1000	16.3000	7701.9700	17820.00	0.00	14580.00	11	5	7184	7148	1.00503637381086	0.21530427079592	0.21530427079592	false	false	false	true
6e709407-27b4-4400-871b-8a11b164ad26	2026-10-02 11:25	2026-10-02 11:25	2026-10-02 11:25	SPXW	SPXW261002C07700000	call	7700.0000	2026-10-02	16.0700	15.9000	16.2000	7702.3500	64290.00	0.00	59490.00	40	8	7035	7148	0.984191382204813	0.210901518577727	0.209474121707518	false	false	false	true
1f8ad3a3-0443-4b09-a87d-d73d0b993f3f	2026-10-02 11:25	2026-10-02 11:25	2026-10-02 11:25	SPXW	SPXW261002C07700000	call	7700.0000	2026-10-02	16.3000	16.3000	16.4000	7702.5900	32600.00	0.00	32600.00	20	5	6965	7148	0.974398433128148	0.211924196275994	0.211924196275994	false	false	false	true
76ac8740-747b-41ca-8507-dccd4d4d0d60	2026-10-02 11:25	2026-10-02 11:25	2026-10-02 11:25	SPXW	SPXW261002C07700000	call	7700.0000	2026-10-02	15.5100	15.5000	15.8000	7701.2900	69790.00	1580.00	66650.00	45	11	6850	7148	0.958310016787913	0.211516202354468	0.214364764705657	false	false	false	true
2377088b-be63-43da-ac7d-c5829c9136e4	2026-10-02 11:24	2026-10-02 11:24	2026-10-02 11:24	SPXW	SPXW261002C07700000	call	7700.0000	2026-10-02	17.8000	17.7000	17.8000	7706.1600	53400.00	53400.00	0.00	30	5	6738	7148	0.942641298265249	0.204971170253496	0.204971170253496	false	false	false	true