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.

326,449 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts326,449 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

ef1e6521-20cc-4168-8c0b-1410d73cc121	2026-08-18 14:59	2026-08-18 14:58	2026-08-18 14:58	SPXW	SPXW260828P07700000	put	7700.0000	2026-08-28	57.0000	56.7000	57.1000	7697.5000	404700.00	404700.00	0.00	71	10	1132	5019	0.225542936840008	0.117506574178634	0.117506574178634	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-18T19:23:50.384726Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
dd21d9ca-39a0-42ed-bfa9-1a1460c046e9	2026-08-18 14:59	2026-08-18 14:58	2026-08-18 14:58	SPXW	SPXW260828P07700000	put	7700.0000	2026-08-28	57.1000	56.7000	57.2000	7697.5300	222690.00	222690.00	0.00	39	5	1195	5019	0.238095238095238	0.117731970800936	0.117731970800936	false	false	false	true	false
8c8f3fb6-5b96-41be-873a-26aa0feaa3be	2026-08-18 15:00	2026-08-18 15:00	2026-08-18 15:00	SPXW	SPXW260818P07700000	put	7700.0000	2026-08-18	5.0100	4.9000	5.3000	7696.6700	279720.00	263620.00	510.00	558	97	166622	3928	42.4190427698574	0.0984865016172314	0.0970404944865458	false	false	false	true	false
77d521c6-b70c-4fdc-8162-7b4f76839518	2026-08-18 15:13	2026-08-18 15:13	2026-08-18 15:13	SPXW	SPXW260818P07730000	put	7730.0000	2026-08-18	32.8000	32.6000	32.9000	7696.5200	127920.00	3280.00	124640.00	39	6	4259	1852	2.29967602591793	0.185811442114147	0.185811442114147	false	false	false	true	false
762f845a-0f03-4941-8e60-85505ed14272	2026-08-18 15:19	2026-08-18 15:18	2026-08-18 15:18	SPXW	SPXW260904C07750000	call	7750.0000	2026-09-04	56.9000	56.6000	57.0000	7697.6100	347090.00	347090.00	0.00	61	6	179	2661	0.0672679443818113	0.112386610326879	0.112386610326879	true	false	false	true	false
d28e61d4-c838-41b9-96de-481e96115834	2026-08-18 15:26	2026-08-18 15:26	2026-08-18 15:26	SPXW	SPXW260824P07700000	put	7700.0000	2026-08-24	34.1400	33.9000	34.3000	7701.2600	191190.00	191190.00	0.00	56	11	1937	1706	1.13540445486518	0.0940914702126524	0.0943459764935793	true	false	false	true	false
30611a3e-e582-4c3a-af9d-b251decc675a	2026-08-18 15:29	2026-08-18 15:29	2026-08-18 15:29	SPXW	SPXW260821C07730000	call	7730.0000	2026-08-21	17.1000	17.0000	17.3000	7700.5100	138510.00	27360.00	111150.00	81	6	1092	535	2.0411214953271	0.102602543709611	0.102602543709611	false	false	false	true	false
c148ce65-5fab-450f-ace3-928d346803f6	2026-08-18 15:39	2026-08-18 15:39	2026-08-18 15:39	SPXW	SPXW260930C08000000	call	8000.0000	2026-09-30	28.2200	28.2000	28.5000	7699.2300	149570.00	31130.00	118440.00	53	7	1757	12575	0.139721669980119	0.107725574800473	0.107583764896372	false	false	false	true	false
c2494717-d539-4a44-ae78-0470df938020	2026-08-18 15:40	2026-08-18 15:40	2026-08-18 15:40	SPXW	SPXW260828P07685000	put	7685.0000	2026-08-28	50.0000	50.0000	50.1000	7699.0900	165000.00	0.00	165000.00	33	5	231	226	1.02212389380531	0.11896226711373	0.11896226711373	false	false	false	true	false
182a2d3d-26c7-4929-8b79-cf7b9991d32e	2026-08-18 15:46	2026-08-18 15:46	2026-08-18 15:46	SPXW	SPXW260819P07685000	put	7685.0000	2026-08-19	11.3000	11.2000	11.5000	7675.0000	113000.00	0.00	96050.00	100	20	2194	390	5.62564102564103	0.108971223077196	0.108971223077196	false	false	false	true	false
dd312eef-1a7f-4158-a48f-77fdc4e0928a	2026-08-18 15:48	2026-08-18 15:48	2026-08-18 15:48	SPXW	SPXW260904P07150000	put	7150.0000	2026-09-04	7.5000	7.5000	7.7000	7675.0000	750000.00	0.00	0.00	1000	5	3227	17813	0.181159827092573	0.21492702193728	0.21492702193728	false	false	false	true	false
8fc0eb07-37ea-47c5-972b-dd5ed5923ff8	2026-08-18 15:50	2026-08-18 15:50	2026-08-18 15:50	SPXW	SPXW260818P07705000	put	7705.0000	2026-08-18	6.5000	6.4000	6.5000	7675.0000	130000.00	130000.00	0.00	200	14	87652	1159	75.6272648835203	0	0	false	false	false	true	false
d153d141-7cdf-49d4-9eee-14194cb422c9	2026-08-18 15:51	2026-08-18 15:51	2026-08-18 15:51	SPXW	SPXW260901P07615000	put	7615.0000	2026-09-01	38.7000	38.4000	38.8000	7675.0000	568890.00	201240.00	367650.00	147	9	248	1	248	0.127572503458874	0.127572503458874	false	false	false	true	false
fd309473-8ea2-4cc2-9cd2-896082d1590c	2026-08-18 15:54	2026-08-18 15:54	2026-08-18 15:54	SPXW	SPXW260821C07710000	call	7710.0000	2026-08-21	25.1000	24.9000	25.1000	7675.0000	110440.00	110440.00	0.00	44	6	808	376	2.14893617021277	0.109814992225599	0.109814992225599	true	false	false	true	false
786d17ff-8a03-49f4-843d-455ab0966bf2	2026-08-18 15:54	2026-08-18 15:54	2026-08-18 15:54	SPXW	SPXW260818P07700000	put	7700.0000	2026-08-18	6.1500	5.8000	6.4000	7670.0000	107050.00	87180.00	14830.00	174	86	207777	3928	52.8963849287169	0	0.187038495866823	false	false	false	true	false
c5fe9d85-b567-4284-b28d-319bddfeaf7b	2026-08-18 15:54	2026-08-18 15:54	2026-08-18 15:54	SPXW	SPXW260818P07695000	put	7695.0000	2026-08-18	2.6600	2.4000	2.9500	7670.0000	126750.00	43795.00	79645.00	476	239	152862	1623	94.184842883549	0.152600187199701	0.200336269529167	false	false	false	true	false
6a37f5c6-d290-47db-9e45-e722c79ed1bc	2026-08-18 15:54	2026-08-18 15:54	2026-08-18 15:54	SPXW	SPXW260818P07700000	put	7700.0000	2026-08-18	7.0100	6.6000	7.5000	7670.0000	135310.00	22680.00	78600.00	193	113	208150	3928	52.9913441955193	0.24666792905199	0.162527468524904	false	false	false	true	false
61624859-d66d-43c0-a41e-ed867b8f44a2	2026-08-18 15:54	2026-08-18 15:54	2026-08-18 15:54	SPXW	SPXW260818P07695000	put	7695.0000	2026-08-18	3.1900	2.8500	3.5000	7670.0000	218785.00	111670.00	103295.00	685	368	153615	1623	94.6487985212569	0.21633584019816	0.177284014584143	true	false	false	true	false
9ddd0c90-77e7-494f-9fc4-901a5d56dda6	2026-08-18 15:57	2026-08-18 15:56	2026-08-18 15:56	SPXW	SPXW261231C07800000	call	7800.0000	2026-12-31	274.3600	273.9000	274.5000	7670.0000	137180.00	137180.00	0.00	5	5	14	3232	0.00433168316831683	0.145256105846839	0.145256105846839	false	false	false	true	false
53792bda-0129-4baa-a934-3892245924f5	2026-08-18 15:57	2026-08-18 15:57	2026-08-18 15:57	SPXW	SPXW260917P07325000	put	7325.0000	2026-09-17	31.0000	30.6000	31.2000	7670.0000	108490.00	92990.00	15500.00	35	9	78	22	3.54545454545455	0.178667967778026	0.17886376991549	false	false	false	true	false
c14f356e-c70f-4834-947c-cd06befa2823	2026-08-18 15:57	2026-08-18 15:57	2026-08-18 15:57	SPXW	SPXW260901P07580000	put	7580.0000	2026-09-01	32.2000	32.1000	32.4000	7670.0000	125580.00	28980.00	96600.00	39	8	101	17	5.94117647058824	0.132864864651681	0.132864864651681	false	false	false	true	false
d81c17cf-0738-4a2d-b4ca-f97b0ee9eee1	2026-08-18 15:58	2026-08-18 15:58	2026-08-18 15:58	SPXW	SPXW260818P07695000	put	7695.0000	2026-08-18	4.0000	3.6000	4.5000	7670.0000	181300.00	64080.00	105840.00	453	223	164033	1623	101.067775723968	0.314863337240292	0.286304543614298	false	false	false	true	false
d7b7e489-8409-42c2-a0a8-52f7cb6668b9	2026-08-18 15:58	2026-08-18 15:58	2026-08-18 15:58	SPXW	SPXW260819C07700000	call	7700.0000	2026-08-19	13.8500	13.6000	13.9000	7670.0000	138510.00	138510.00	0.00	100	16	8284	655	12.6473282442748	0.108671396886222	0.108671396886222	false	false	false	true	false
877bc9ce-e734-405d-aa0f-e138e52250a0	2026-08-18 15:58	2026-08-18 15:58	2026-08-18 15:58	SPXW	SPXW260818P07700000	put	7700.0000	2026-08-18	8.7200	8.3000	9.0000	7670.0000	103790.00	25640.00	78150.00	119	94	211222	3928	53.7734215885947	0.562252361987477	0.47810425417394	false	false	false	true	false
9b2b9da8-a003-42e7-bb7a-19a0fd9309ef	2026-08-18 15:59	2026-08-18 15:58	2026-08-18 15:58	SPXW	SPXW260819C07700000	call	7700.0000	2026-08-19	14.8000	14.8000	15.0000	7670.0000	148000.00	0.00	148000.00	100	10	8499	655	12.975572519084	0.108512217912199	0.108512217912199	false	false	false	true	false
648f006a-8cb9-4cfc-b500-d70d763a4768	2026-08-18 15:59	2026-08-18 15:59	2026-08-18 15:59	SPXW	SPXW260828P07700000	put	7700.0000	2026-08-28	57.2000	57.0000	57.6000	7675.0000	777920.00	589160.00	148720.00	136	10	1688	5019	0.33632197648934	0.116357626661333	0.116357626661333	false	false	false	true	false
e1ccf6c1-9619-47d3-b7ca-8f04a3a99916	2026-08-18 16:01	2026-08-18 16:00	2026-08-18 16:00	SPXW	SPXW260828P07685000	put	7685.0000	2026-08-28	53.0000	52.6000	54.0000	7670.0000	254400.00	243800.00	10600.00	48	5	306	226	1.35398230088496	0.11871172299724	0.11871172299724	false	false	false	true	false
31c83d1a-f122-458f-963f-a1080a5671c7	2026-08-18 16:09	2026-08-18 16:06	2026-08-18 16:06	SPXW	SPXW260820C07730000	call	7730.0000	2026-08-20	9.2000	9.0000	9.3000	7670.0000	184000.00	184000.00	0.00	200	8	464	122	3.80327868852459	0.101145620800249	0.101145620800249	false	false	false	true	false
c6b50d7a-924f-4e6b-b6ca-92765c56e6ad	2026-08-19 09:30	2026-08-19 09:30	2026-08-19 09:30	SPXW	SPXW260819C07700000	call	7700.0000	2026-08-19	29.0000	28.8000	29.5000	7723.4300	504600.00	191400.00	313200.00	174	12	240	2637	0.0910125142207053	0.168952835378206	0.168952835378206	false	false	false	true	false
36928b48-81c3-4d94-b9da-bae438d8d438	2026-08-19 09:31	2026-08-19 09:31	2026-08-19 09:31	SPXW	SPXW260820C07730000	call	7730.0000	2026-08-20	17.6100	17.5000	18.0000	7725.5400	246470.00	221760.00	24710.00	140	7	252	361	0.698060941828255	0.120693585443804	0.120072096450724	false	false	false	true	false
39dd27fc-d5b0-43cd-a45d-760fec82eaf6	2026-08-19 09:32	2026-08-19 09:32	2026-08-19 09:32	SPXW	SPXW260819C07720000	call	7720.0000	2026-08-19	13.9000	13.7000	14.0000	7723.6000	140390.00	41700.00	97300.00	101	23	649	951	0.682439537329127	0.146711619543678	0.142241615615396	false	false	false	true	false
8779c309-cc13-491e-ae53-df7699c342af	2026-08-19 09:33	2026-08-19 09:33	2026-08-19 09:33	SPXW	SPXW260821C07680000	call	7680.0000	2026-08-21	58.3600	56.6000	58.8000	7722.9500	116710.00	17430.00	99280.00	20	6	21	474	0.0443037974683544	0.13513647487758	0.13513647487758	false	false	false	true	false
9e190e8a-1c32-4836-bc14-e61a9d320e68	2026-08-19 09:33	2026-08-19 09:33	2026-08-19 09:33	SPXW	SPXW260819C07720000	call	7720.0000	2026-08-19	13.5000	13.4000	13.7000	7723.4500	334910.00	140400.00	78340.00	248	44	1138	951	1.19663512092534	0.139738488803062	0.1385322098602	false	false	false	true	false
268b5380-6d62-497e-b4b5-4c0b6ecf5015	2026-08-19 09:33	2026-08-19 09:33	2026-08-19 09:33	SPXW	SPXW260819P07750000	put	7750.0000	2026-08-19	30.5000	30.5000	30.6000	7723.0200	301950.00	0.00	301950.00	99	10	258	3907	0.0660353212183261	0.154668366385021	0.154668366385021	false	false	false	true	false
b4326231-840a-41f7-b974-311f91c05899	2026-08-19 09:34	2026-08-19 09:34	2026-08-19 09:34	SPXW	SPXW260820P07700000	put	7700.0000	2026-08-20	12.2000	12.1000	12.4000	7722.1200	173240.00	159820.00	13420.00	142	20	272	1609	0.169049098819142	0.135185515679318	0.135185515679318	false	false	false	true	false
e492c10b-2a13-43bb-b908-d5dabffc8bcb	2026-08-19 09:36	2026-08-19 09:36	2026-08-19 09:36	SPXW	SPXW260819P07715000	put	7715.0000	2026-08-19	11.3500	11.2000	11.4000	7717.2900	113460.00	113460.00	0.00	100	25	1861	537	3.46554934823091	0.15048382776678	0.15169039374545	false	false	false	true	false
a8ef2acf-22ec-4c3f-acc0-e767f72a17ba	2026-08-19 09:44	2026-08-19 09:44	2026-08-19 09:44	SPXW	SPXW260828P07610000	put	7610.0000	2026-08-28	21.6800	21.4000	21.7000	7721.0100	110560.00	110560.00	0.00	51	10	95	513	0.185185185185185	0.133753577834207	0.133753577834207	false	false	false	true	false
1b3b6b63-9550-4a4b-a4fa-c0d59be82eda	2026-08-19 09:47	2026-08-19 09:47	2026-08-19 09:47	SPXW	SPXW260819P07735000	put	7735.0000	2026-08-19	21.5400	21.2000	21.6000	7719.7400	107700.00	107700.00	0.00	50	20	978	3316	0.294933655006031	0.151709169890711	0.151709169890711	false	false	false	true	false
40fa4c07-ed03-4bf0-93e4-975fdda6e8d7	2026-08-19 09:48	2026-08-19 09:48	2026-08-19 09:48	SPXW	SPXW260819P07710000	put	7710.0000	2026-08-19	10.8000	10.7000	11.0000	7713.7400	110160.00	108000.00	1070.00	102	15	5583	646	8.64241486068111	0.154975936471844	0.156207984585755	false	false	false	true	false
dfe2d6c3-0c5d-4f24-9f2e-64c75ebf5573	2026-08-19 09:48	2026-08-19 09:48	2026-08-19 09:48	SPXW	SPXW260819P07705000	put	7705.0000	2026-08-19	10.3000	10.2000	10.5000	7711.1800	107150.00	95820.00	11330.00	104	21	4487	1097	4.09024612579763	0.167469581974121	0.162137626313908	false	false	false	true	false
cb76fc62-7ba8-4997-a8b7-ed1ea9e90353	2026-08-19 09:49	2026-08-19 09:49	2026-08-19 09:49	SPXW	SPXW260819C07745000	call	7745.0000	2026-08-19	3.3600	1.8500	1.9500	7705.7400	100800.00	0.00	0.00	300	9	6542	1561	4.19090326713645	0.192457175164039	0.192457175164039	false	false	false	true	false
ca6ecfdc-e0a3-42ec-949b-950b8385e4be	2026-08-19 09:49	2026-08-19 09:49	2026-08-19 09:49	SPXW	SPXW260819P07750000	put	7750.0000	2026-08-19	43.1000	43.0000	43.1000	7708.7500	405140.00	405140.00	0.00	94	13	770	3907	0.197082160225237	0.170064215926661	0.170064215926661	false	false	false	true	false
e6943823-7b13-4cdc-b32f-47d8025e7de9	2026-08-19 09:50	2026-08-19 09:50	2026-08-19 09:50	SPXW	SPXW260819C07715000	call	7715.0000	2026-08-19	10.0000	9.9000	10.0000	7703.4900	200000.00	200000.00	0.00	200	8	3525	1618	2.17861557478368	0.183585491527555	0.183585491527555	false	false	false	true	false
3ff494f7-df9c-4986-807d-3c08a2962e6e	2026-08-19 09:51	2026-08-19 09:51	2026-08-19 09:51	SPXW	SPXW260819P07695000	put	7695.0000	2026-08-19	11.5700	11.4000	11.6000	7700.6700	100690.00	100690.00	0.00	87	12	7214	2397	3.0095953274927	0.175244069964034	0.17649096323655	true	false	false	true	false
483b9eba-86c1-4aad-803f-8d5f32e4e058	2026-08-19 09:51	2026-08-19 09:51	2026-08-19 09:51	SPXW	SPXW260819P07700000	put	7700.0000	2026-08-19	13.4000	13.3000	13.5000	7700.4600	269340.00	24120.00	237180.00	201	30	10204	4400	2.31909090909091	0.168861039286608	0.168861039286608	false	false	false	true	false
acfc6ecc-110e-4e37-9f20-b589902a9743	2026-08-19 09:52	2026-08-19 09:52	2026-08-19 09:52	SPXW	SPXW260819P07700000	put	7700.0000	2026-08-19	11.0000	10.9000	11.2000	7705.0000	221100.00	218900.00	2200.00	201	38	10819	4400	2.45886363636364	0.165398857432974	0.165398857432974	false	false	false	true	false
ac3e46b5-2bba-4b02-84c9-2da4c722fb98	2026-08-19 09:54	2026-08-19 09:54	2026-08-19 09:54	SPXW	SPXW260819C07735000	call	7735.0000	2026-08-19	4.5000	4.5000	4.6000	7713.0400	198000.00	0.00	198000.00	440	54	12756	1976	6.45546558704453	0.153907391084456	0.153566823221983	false	false	false	true	false
93149298-302e-465c-9f9f-b273af88ff48	2026-08-19 09:56	2026-08-19 09:56	2026-08-19 09:56	SPXW	SPXW260819C07725000	call	7725.0000	2026-08-19	10.0000	9.8000	10.1000	7719.7800	119000.00	1000.00	118000.00	119	25	12822	5879	2.18098316040143	0.152297080979833	0.152297080979833	false	false	false	true	false
fecd47ec-364f-4f31-8a6b-29d1da84f267	2026-08-19 09:57	2026-08-19 09:57	2026-08-19 09:57	SPXW	SPXW260820C07740000	call	7740.0000	2026-08-20	11.0000	11.0000	11.1000	7719.3100	100100.00	0.00	100100.00	91	9	472	1307	0.361132364192808	0.119821539405871	0.119821539405871	false	false	false	true	false
f0d833f1-f052-4ad7-b97c-40dbf7988c01	2026-08-19 09:59	2026-08-19 09:58	2026-08-19 09:58	SPXW	SPXW260819C07670000	call	7670.0000	2026-08-19	54.4000	54.4000	54.5000	7722.6700	108800.00	0.00	108800.00	20	5	266	190	1.4	0.191933363791311	0.191933363791311	false	false	false	true	false