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

9e425289-f1c1-4da7-8824-466d1f18175b	2026-09-28 15:59	2026-09-28 15:59	2026-09-28 15:59	SPXW	SPXW260928C07680000	call	7680.0000	2026-09-28	4.4800	3.7000	4.7000	7665.0000	11640.00	11640.00	0.00	26	6	56915	759	74.9868247694335	0	0	false	false	false	true	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	—	—	—	—	—	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500}	2026-09-28	2026-09-28 21:15	2026-09-28 21:15
652fba77-9544-4b91-8637-6c90362963b2	2026-09-28 15:59	2026-09-28 15:59	2026-09-28 15:59	SPXW	SPXW260929C07725000	call	7725.0000	2026-09-29	6.5000	6.3000	6.5000	7660.0000	38990.00	38350.00	0.00	60	10	6404	1036	6.18146718146718	0.127622269194945	0.127622269194945	true	false	false	true
b9cabc1c-0761-4209-961b-6b14849e37f2	2026-09-28 15:59	2026-09-28 15:58	2026-09-28 15:58	SPXW	SPXW260929P07635000	put	7635.0000	2026-09-29	5.3400	5.3000	5.5000	7665.0000	12820.00	0.00	7420.00	24	19	2396	324	7.39506172839506	0.137609186081996	0.138564622980907	false	false	false	true
ae5dc316-14f0-4cad-832d-10b378f58687	2026-09-28 15:59	2026-09-28 15:58	2026-09-28 15:58	SPXW	SPXW260928C07680000	call	7680.0000	2026-09-28	4.9800	4.5000	5.0000	7665.0000	47300.00	45930.00	1370.00	95	27	56060	759	73.8603425559947	0.217241931625454	0.356527440395708	false	false	false	true
5dcf647b-178e-425f-b0e0-5851ae75f873	2026-09-28 15:58	2026-09-28 15:58	2026-09-28 15:58	SPXW	SPXW260928C07685000	call	7685.0000	2026-09-28	1.0100	0.9000	1.2000	7660.0000	35955.00	35265.00	575.00	357	71	71142	138	515.521739130435	0.30404563602749	0.364584681263039	false	false	false	true
68f70415-5b39-42d8-af25-520b01bb6ad4	2026-09-28 15:58	2026-09-28 15:58	2026-09-28 15:58	SPXW	SPXW260928C07680000	call	7680.0000	2026-09-28	4.0600	3.9000	4.2000	7660.0000	21120.00	13740.00	7380.00	52	29	55563	759	73.2055335968379	0.217804668445511	0.260335774112134	false	false	false	true
82972b55-e1ca-4490-a590-4237567c0684	2026-09-28 15:57	2026-09-28 15:57	2026-09-28 15:57	SPXW	SPXW260928C07680000	call	7680.0000	2026-09-28	2.9800	2.8500	3.0000	7660.0000	17305.00	16715.00	590.00	58	34	54156	759	71.3517786561265	0.244570624942933	0.243547616488994	false	false	false	true
9440ed46-fe96-4bed-939e-07353c0098f9	2026-09-28 15:57	2026-09-28 15:57	2026-09-28 15:57	SPXW	SPXW260928C07680000	call	7680.0000	2026-09-28	2.5000	2.4500	2.6000	7681.2200	11510.00	10500.00	0.00	46	21	53565	759	70.5731225296443	0.259526310753316	0.266889748018557	false	false	false	true
1f39636a-3fa9-4930-a961-8a0175247b73	2026-09-28 15:57	2026-09-28 15:57	2026-09-28 15:57	SPXW	SPXW260928P07680000	put	7680.0000	2026-09-28	1.6000	1.5500	1.6500	7680.6300	22090.00	21930.00	160.00	138	12	171198	1391	123.075485262401	0.263876688996418	0.270883727345494	false	false	false	true
7cd9eafc-8c33-4238-a419-a4a5ee997dcf	2026-09-28 15:56	2026-09-28 15:56	2026-09-28 15:56	SPXW	SPXW260928C07680000	call	7680.0000	2026-09-28	1.9700	1.7500	2.1000	7679.9200	19120.00	10780.00	6730.00	97	53	51978	759	68.4822134387352	0.235647866468026	0.258694176264634	false	false	false	true
8f95ad8f-d9e6-40e9-9131-4cd61d7a7a89	2026-09-28 15:56	2026-09-28 15:56	2026-09-28 15:56	SPXW	SPXW260928P07680000	put	7680.0000	2026-09-28	2.7100	2.5500	2.8000	7678.5400	11365.00	2970.00	2115.00	42	12	168716	1391	121.29115744069	0.212464280613635	0.23755256127322	false	false	false	true
022e137f-00ce-4399-9fbc-ca029b094215	2026-09-28 15:56	2026-09-28 15:55	2026-09-28 15:55	SPXW	SPXW261001P07700000	put	7700.0000	2026-10-01	46.6300	46.4000	46.8000	7679.5800	97930.00	97930.00	0.00	21	6	500	1268	0.394321766561514	0.132998442836689	0.132998442836689	false	false	false	true
534edcf4-fc85-40ef-9ec9-d61a5a607b79	2026-09-28 15:55	2026-09-28 15:55	2026-09-28 15:55	SPXW	SPXW260928P07680000	put	7680.0000	2026-09-28	2.5900	2.4500	2.6000	7679.1500	10110.00	9860.00	250.00	39	13	167702	1391	120.562185478073	0.232413329189722	0.243907346763102	false	false	false	true
63430880-431d-4397-b1cf-cb9a0290fb72	2026-09-28 15:55	2026-09-28 15:55	2026-09-28 15:55	SPXW	SPXW260928C07680000	call	7680.0000	2026-09-28	1.7700	1.7500	1.9000	7680.0600	11350.00	2420.00	8930.00	64	7	49056	759	64.6324110671937	0.193705985201096	0.204660486034885	false	false	false	true
a5d837ba-bb08-4034-a987-ea3a3d1c8dd5	2026-09-28 15:55	2026-09-28 15:55	2026-09-28 15:55	SPXW	SPXW260928P07680000	put	7680.0000	2026-09-28	1.9100	1.7500	2.0000	7680.5200	11665.00	11485.00	0.00	61	18	166882	1391	119.972681524083	0.208859030294461	0.244464082905149	false	false	false	true
bba96929-57db-4a9b-b165-ff00f47f08e8	2026-09-28 15:55	2026-09-28 15:55	2026-09-28 15:55	SPXW	SPXW260928P07680000	put	7680.0000	2026-09-28	2.0400	1.8500	2.2500	7680.1900	18395.00	10475.00	7725.00	90	49	166268	1391	119.531272465852	0.224464984631261	0.229685002728643	false	false	false	true
54ba0408-84bf-4bab-bbaf-a4c551134e9f	2026-09-28 15:55	2026-09-28 15:55	2026-09-28 15:55	SPXW	SPXW260928P07680000	put	7680.0000	2026-09-28	2.1500	2.0000	2.2500	7680.0900	26885.00	19620.00	645.00	125	37	166154	1391	119.449317038102	0.223684263705678	0.245445815335393	false	false	false	true
b95de513-bf55-4334-9fc5-aa97247befeb	2026-09-28 15:55	2026-09-28 15:55	2026-09-28 15:55	SPXW	SPXW260928P07680000	put	7680.0000	2026-09-28	2.1100	2.0000	2.2500	7680.0900	10780.00	8680.00	0.00	51	12	166009	1391	119.345075485262	0.216707514197015	0.223684263705678	false	false	false	true
5115d3f0-5f79-4908-9abb-951f21cff0c3	2026-09-28 15:55	2026-09-28 15:55	2026-09-28 15:55	SPXW	SPXW260928P07685000	put	7685.0000	2026-09-28	6.9100	5.9000	8.0000	7678.2500	11750.00	8540.00	3210.00	17	15	123975	1431	86.6352201257862	0.379062328369384	0	false	false	false	true
d041434e-bba2-43b4-926c-e16375ad5638	2026-09-28 15:55	2026-09-28 15:54	2026-09-28 15:54	SPXW	SPXW260928P07680000	put	7680.0000	2026-09-28	3.2500	3.1000	3.4000	7678.1500	21760.00	16070.00	3450.00	67	30	165272	1391	118.815240833932	0.223204769041949	0.22732444181944	false	false	false	true
4a19b1c3-6985-4720-b268-bdddf568120a	2026-09-28 15:55	2026-09-28 15:54	2026-09-28 15:54	SPXW	SPXW260928P07680000	put	7680.0000	2026-09-28	2.9600	2.9500	3.1000	7678.2200	10345.00	0.00	10345.00	35	8	165160	1391	118.734723220705	0.203217859942388	0.203217859942388	false	false	false	true
01262117-24f9-49df-895c-5b34c2027bd6	2026-09-28 15:54	2026-09-28 15:54	2026-09-28 15:54	SPXW	SPXW260928P07675000	put	7675.0000	2026-09-28	1.0200	0.9500	1.0500	7678.0000	11635.00	10645.00	190.00	114	25	132162	2920	45.2609589041096	0.238304509345301	0.227453002086588	true	false	false	true
a9c70111-7d32-4558-83d6-7e0152606cb0	2026-09-28 15:54	2026-09-28 15:54	2026-09-28 15:54	SPXW	SPXW260928P07675000	put	7675.0000	2026-09-28	1.2100	1.1000	1.2500	7678.0400	31420.00	29550.00	1755.00	259	54	131740	2920	45.1164383561644	0.250808704241318	0.257066900979346	true	false	false	true
981d92f5-c128-41f9-90e9-a9cf7dcb32eb	2026-09-28 15:54	2026-09-28 15:54	2026-09-28 15:54	SPXW	SPXW260928P07685000	put	7685.0000	2026-09-28	7.1900	6.9000	7.2000	7678.5200	10060.00	10060.00	0.00	14	11	123653	1431	86.4102026554857	0.280199353073576	0.296007950402711	false	false	false	true
1fef6650-fedc-4b62-a157-3b3e74f4fb52	2026-09-28 15:54	2026-09-28 15:54	2026-09-28 15:54	SPXW	SPXW260928P07685000	put	7685.0000	2026-09-28	7.2300	7.0000	7.4000	7678.1100	65100.00	26980.00	24450.00	90	73	123747	1431	86.475890985325	0.280642437229392	0.254741741688108	false	false	false	true
46c07775-1487-4407-a0db-a47ad26ff0ec	2026-09-28 15:54	2026-09-28 15:54	2026-09-28 15:54	SPXW	SPXW260928P07680000	put	7680.0000	2026-09-28	3.0200	2.9000	3.2000	7678.2000	17525.00	3100.00	13505.00	58	30	164329	1391	118.137311286844	0.20246876115814	0.191763430483873	false	false	false	true
e5c500be-1a46-4dfe-96c4-01b720eb3d8a	2026-09-28 15:54	2026-09-28 15:54	2026-09-28 15:54	SPXW	SPXW260928P07680000	put	7680.0000	2026-09-28	3.0200	2.8000	3.2000	7678.2000	38640.00	33945.00	4105.00	128	57	164268	1391	118.093457943925	0.271628309396144	0.213395513120736	false	false	false	true
dff38d29-aefc-4f47-ba0a-01d383aebf11	2026-09-28 15:54	2026-09-28 15:54	2026-09-28 15:54	SPXW	SPXW260928P07680000	put	7680.0000	2026-09-28	2.7600	2.3500	2.8000	7679.6000	18485.00	18485.00	0.00	67	31	164053	1391	117.938892882818	0.247077331852528	0.266071570517833	false	false	false	true
a80c0f4a-2c6c-4d67-894b-6fb06d03cd34	2026-09-28 15:54	2026-09-28 15:54	2026-09-28 15:54	SPXW	SPXW260928P07680000	put	7680.0000	2026-09-28	2.2200	2.1000	2.4000	7679.6900	12215.00	7895.00	665.00	55	24	163657	1391	117.654205607477	0.200773485058354	0.211184896739463	false	false	false	true
dfb6d4ff-ffb6-4388-a8d9-9fb8cab1b6de	2026-09-28 15:54	2026-09-28 15:54	2026-09-28 15:54	SPXW	SPXW260928P07680000	put	7680.0000	2026-09-28	2.7500	2.7000	2.8500	7678.9400	18175.00	13020.00	4325.00	66	31	162997	1391	117.179726815241	0.214350806326743	0.221552620932256	false	false	false	true
6b15239a-f5b6-43bc-a05f-2d60740607cc	2026-09-28 15:54	2026-09-28 15:54	2026-09-28 15:54	SPXW	SPXW260928P07680000	put	7680.0000	2026-09-28	2.6600	2.6000	2.8000	7679.2600	18635.00	2970.00	13235.00	70	38	162734	1391	116.990654205607	0.231212158974106	0.223608565200888	false	false	false	true
8019de7e-49ec-48c4-874c-35c4fde02139	2026-09-28 15:54	2026-09-28 15:54	2026-09-28 15:54	SPXW	SPXW260928P07680000	put	7680.0000	2026-09-28	2.3700	2.3000	2.4500	7679.6100	13055.00	4080.00	5450.00	55	15	162497	1391	116.820273184759	0.211973212092084	0.221851270893274	false	false	false	true
b89121e6-6b5a-4cff-a14d-7fe453f47d4f	2026-09-28 15:54	2026-09-28 15:54	2026-09-28 15:54	SPXW	SPXW260928P07680000	put	7680.0000	2026-09-28	2.4600	2.3500	2.5500	7679.6100	36165.00	19355.00	14360.00	147	65	162436	1391	116.77641984184	0.224502308809115	0.221531881651456	false	false	false	true
9ff28c44-9b94-436a-80a3-9f597cdccc12	2026-09-28 15:54	2026-09-28 15:54	2026-09-28 15:54	SPXW	SPXW260928P07685000	put	7685.0000	2026-09-28	5.8500	5.7000	6.0000	7679.6100	11120.00	0.00	10540.00	19	10	123044	1431	85.9846261355695	0.205560774184175	0.188035805632185	false	false	false	true
e1935431-2567-4b08-b27f-6ba25bef842b	2026-09-28 15:54	2026-09-28 15:54	2026-09-28 15:54	SPXW	SPXW260928P07680000	put	7680.0000	2026-09-28	2.2600	2.2000	2.3000	7679.8700	10185.00	4790.00	4945.00	45	20	162199	1391	116.606038820992	0.240642735296769	0.214486428531864	false	false	false	true
d9f94c24-19fc-4301-a57e-9497bdd9743d	2026-09-28 15:54	2026-09-28 15:54	2026-09-28 15:54	SPXW	SPXW260928P07680000	put	7680.0000	2026-09-28	2.0000	1.9500	2.0500	7680.5700	11210.00	11210.00	0.00	56	39	162068	1391	116.511861969806	0.222898591519065	0.227821252545557	false	false	false	true
61089eec-ed82-4aab-91d1-279451d7c7ca	2026-09-28 15:54	2026-09-28 15:54	2026-09-28 15:54	SPXW	SPXW260928P07690000	put	7690.0000	2026-09-28	9.5400	9.3000	9.6000	7680.5700	16210.00	16210.00	0.00	17	5	111963	1292	86.6586687306501	0.203892593757805	0.242170154891745	false	false	false	true
9d9523dd-2a77-4179-84ba-6eeda8bd06ce	2026-09-28 15:53	2026-09-28 15:53	2026-09-28 15:53	SPXW	SPXW260928C07680000	call	7680.0000	2026-09-28	3.6800	3.5000	3.7000	7681.6800	11790.00	11070.00	0.00	32	13	44733	759	58.9367588932806	0.246898359923244	0.256416044762604	true	false	false	true
8ae6f9d4-b088-4742-bba8-c5673bbff63c	2026-09-28 15:53	2026-09-28 15:53	2026-09-28 15:53	SPXW	SPXW260928C07680000	call	7680.0000	2026-09-28	3.6000	3.4000	3.7000	7682.0400	21950.00	10440.00	11160.00	61	18	44634	759	58.8063241106719	0.212308576290502	0.221937187873384	false	false	false	true
78b149f9-a2d1-4234-9b69-0449dfbb10d6	2026-09-28 15:52	2026-09-28 15:52	2026-09-28 15:52	SPXW	SPXW260928P07675000	put	7675.0000	2026-09-28	0.7500	0.6500	0.8500	7680.8200	61410.00	29855.00	29455.00	819	96	128565	2920	44.0291095890411	0.228032225009126	0.240374867874521	false	false	false	true
30e16d78-085a-456a-88a7-e9e0d34d3e93	2026-09-28 15:52	2026-09-28 15:52	2026-09-28 15:52	SPXW	SPXW260928P07680000	put	7680.0000	2026-09-28	2.0000	1.9000	2.1000	7680.8200	10020.00	9000.00	820.00	50	24	160172	1391	115.148813803019	0.20076389815286	0.209428378921885	false	false	false	true
84ea927b-259b-4a63-8974-820013a21f92	2026-09-28 15:52	2026-09-28 15:52	2026-09-28 15:52	SPXW	SPXW260928P07685000	put	7685.0000	2026-09-28	5.0000	4.9000	5.0000	7681.1300	13490.00	13000.00	490.00	27	14	121888	1431	85.1767994409504	0.213046744174361	0.223223506785753	false	false	false	true
07f978fd-87d1-4602-aa9e-38d4ec6c6cfd	2026-09-28 15:52	2026-09-28 15:52	2026-09-28 15:52	SPXW	SPXW260928P07680000	put	7680.0000	2026-09-28	2.0000	1.9000	2.0500	7681.8800	10190.00	10000.00	190.00	51	29	159597	1391	114.735442127965	0.231604873075981	0.240370567268036	false	false	false	true
48c8294c-8d23-4cb7-9c51-2f64de8adadf	2026-09-28 15:52	2026-09-28 15:52	2026-09-28 15:52	SPXW	SPXW260928P07675000	put	7675.0000	2026-09-28	0.5400	0.4500	0.6000	7682.6300	43950.00	24920.00	19030.00	809	49	126824	2920	43.4328767123288	0.236517622376897	0.243944475669816	false	false	false	true
b3345cb9-06e7-4394-b57d-ba75bbcefee1	2026-09-28 15:52	2026-09-28 15:52	2026-09-28 15:52	SPXW	SPXW260928C07675000	call	7675.0000	2026-09-28	8.1500	7.9000	8.2000	7683.2500	17930.00	17930.00	0.00	22	5	26381	762	34.6207349081365	0.141941756092858	0.141941756092858	false	false	false	true
d7080b69-a43f-45c3-b41a-a2eb73fc1d6c	2026-09-28 15:51	2026-09-28 15:51	2026-09-28 15:51	SPXW	SPXW260928C07685000	call	7685.0000	2026-09-28	1.9100	1.7000	2.2000	7683.0400	31300.00	28675.00	0.00	164	48	55763	138	404.079710144928	0.216160835131879	0.254836890493555	false	false	false	true
11d3b1da-fcbc-49e1-b472-eabdb9304e12	2026-09-28 15:51	2026-09-28 15:51	2026-09-28 15:51	SPXW	SPXW260929C07700000	call	7700.0000	2026-09-29	14.3400	14.1000	14.4000	7683.0400	15770.00	15770.00	0.00	11	5	9959	1958	5.08631256384065	0.133224294256996	0.133875537448354	false	false	false	true
0468f478-eef1-4b03-bd16-ecdd5d876f45	2026-09-28 15:50	2026-09-28 15:50	2026-09-28 15:50	SPXW	SPXW260928C07685000	call	7685.0000	2026-09-28	2.0400	1.9500	2.0500	7683.1200	13235.00	11465.00	1170.00	65	16	53275	138	386.050724637681	0.219211132890333	0.223403969849416	false	false	false	true
e87bc7bd-5082-4df2-afbb-015d9f2aadf5	2026-09-28 15:50	2026-09-28 15:50	2026-09-28 15:50	SPXW	SPXW260928C07685000	call	7685.0000	2026-09-28	2.5300	2.3500	2.6500	7683.1900	31360.00	25570.00	250.00	124	29	53098	138	384.768115942029	0.251163843015123	0.255317141817225	false	false	false	true
da6d48c3-1a8c-4df1-a756-ca1f050cb1d2	2026-09-28 15:50	2026-09-28 15:50	2026-09-28 15:50	SPXW	SPXW260928P07680000	put	7680.0000	2026-09-28	2.9100	2.5500	3.2000	7680.8700	53560.00	39540.00	12520.00	184	90	155165	1391	111.549245147376	0.276430969363531	0.226740000189564	false	false	false	true