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.

425,429 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts425,429 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

96ff306d-ad36-460a-af34-8d65d5b2781c	2026-08-24 14:30	2026-08-24 14:30	2026-08-24 14:30	SPXW	SPXW260825P07665000	put	7665.0000	2026-08-25	15.1500	15.1000	15.4000	7668.0000	151540.00	0.00	142420.00	100	21	2241	730	3.06986301369863	0.106394346456675	0.106394346456675	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-08-24T18:49:58.488781Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
3b15dafb-c2f9-492e-af61-d941d3958393	2026-08-24 14:31	2026-08-24 14:31	2026-08-24 14:31	SPXW	SPXW260825P07675000	put	7675.0000	2026-08-25	20.0200	19.8000	20.1000	7667.6300	100080.00	76080.00	24000.00	50	9	1419	1212	1.17079207920792	0.10305096525192	0.103683135442523	true	false	false	true	false
5076b07b-3805-4c1e-96c0-6251b89e03bd	2026-08-24 14:34	2026-08-24 14:34	2026-08-24 14:34	SPXW	SPXW260824C07640000	call	7640.0000	2026-08-24	25.1600	25.1000	25.5000	7665.0500	100640.00	0.00	100640.00	40	6	12468	281	44.3701067615658	0.143366513675236	0.143366513675236	false	false	false	true	false
bdd65766-8c3e-4275-bae7-4a9640395389	2026-08-24 14:36	2026-08-24 14:36	2026-08-24 14:36	SPXW	SPXW260825P07650000	put	7650.0000	2026-08-25	11.4000	11.3000	11.5000	7663.5200	125400.00	93480.00	30780.00	110	11	8283	1678	4.93623361144219	0.110345403130029	0.110345403130029	false	false	false	true	false
c171b575-d72c-40ce-a1df-5074af71808a	2026-08-24 14:39	2026-08-24 14:38	2026-08-24 14:38	SPXW	SPXW260825P07660000	put	7660.0000	2026-08-25	15.9600	15.8000	16.0000	7660.9000	159620.00	131000.00	0.00	100	20	4357	349	12.4842406876791	0.104624035119351	0.105249725924212	false	false	false	true	false
cf40978d-ba87-413d-8a61-5889e90054ad	2026-08-24 14:47	2026-08-24 14:47	2026-08-24 14:47	SPXW	SPXW260825P07660000	put	7660.0000	2026-08-25	16.1000	16.0000	16.3000	7660.1700	161000.00	51520.00	109480.00	100	19	4776	349	13.6848137535817	0.103654984439905	0.103654984439905	false	false	false	true	false
05fb67ff-bf61-481e-8792-30d43577bf57	2026-08-24 14:52	2026-08-24 14:52	2026-08-24 14:52	SPXW	SPXW260824P07720000	put	7720.0000	2026-08-24	59.1000	59.1000	59.5000	7660.3800	295500.00	0.00	295500.00	50	5	254	418	0.607655502392344	0.267510639720168	0.267510639720168	false	false	false	true	false
b7c10382-53f8-4d1b-a34c-ed4a654cfd5a	2026-08-24 14:52	2026-08-24 14:52	2026-08-24 14:52	SPXW	SPXW260825P07660000	put	7660.0000	2026-08-25	16.4900	16.2000	16.6000	7659.3700	164880.00	164880.00	0.00	100	24	4932	349	14.1318051575931	0.10306239399217	0.10306239399217	false	false	false	true	false
fc96d767-7620-4314-819e-bfe8ccd0a5a4	2026-08-24 14:59	2026-08-24 14:59	2026-08-24 14:59	SPXW	SPXW260825P07660000	put	7660.0000	2026-08-25	16.9200	16.8000	17.1000	7658.5700	169160.00	23660.00	121750.00	100	20	5184	349	14.8538681948424	0.104307241803669	0.103681892966508	false	false	false	true	false
f8c0ef7f-f10c-405e-b528-f0941ffefdc1	2026-08-24 15:01	2026-08-24 15:01	2026-08-24 15:01	SPXW	SPXW260825P07655000	put	7655.0000	2026-08-25	15.8600	15.6000	15.9000	7656.9400	158620.00	158620.00	0.00	100	19	4843	222	21.8153153153153	0.107179065891657	0.107805877739233	false	false	false	true	false
2fd50b57-39e2-428e-89eb-8a63cf018498	2026-08-24 15:13	2026-08-24 15:13	2026-08-24 15:13	SPXW	SPXW260825P07655000	put	7655.0000	2026-08-25	14.1800	14.1000	14.4000	7659.0300	141790.00	0.00	141790.00	100	19	5181	222	23.3378378378378	0.103208677265061	0.102578915310207	false	false	false	true	false
a421edca-0767-4e69-bd33-6d1bd0413f91	2026-08-24 15:13	2026-08-24 15:13	2026-08-24 15:13	SPXW	SPXW260826C07700000	call	7700.0000	2026-08-26	7.1000	6.9000	7.2000	7659.4300	142000.00	68870.00	73130.00	200	12	3285	1081	3.03885291396855	0.09306187732539	0.09306187732539	false	false	false	true	false
0fbd6e4a-1062-45bb-844b-31b5dae66373	2026-08-24 15:22	2026-08-24 15:21	2026-08-24 15:21	SPXW	SPXW260825C07650000	call	7650.0000	2026-08-25	22.2100	22.1000	22.4000	7659.3700	111060.00	39960.00	57720.00	50	9	6821	1589	4.29263687853996	0.104655821977713	0.104011388404755	false	false	false	true	false
5dd425aa-f51d-43a3-9cfe-7a9324c775d3	2026-08-24 15:26	2026-08-24 15:26	2026-08-24 15:26	SPXW	SPXW260826C07650000	call	7650.0000	2026-08-26	28.9400	28.8000	29.2000	7659.3300	263380.00	2890.00	260490.00	91	17	885	3747	0.236188951160929	0.102330583303776	0.101880197180213	false	false	false	true	false
795574c8-f493-4212-9bb8-ec36b40dc7bc	2026-08-24 15:28	2026-08-24 15:28	2026-08-24 15:28	SPXW	SPXW260824P07670000	put	7670.0000	2026-08-24	11.4000	11.2000	11.6000	7658.1800	107160.00	106020.00	1140.00	94	17	27685	1469	18.8461538461538	0	0.117921130310945	false	false	false	true	false
3e7a952c-5edd-4d3e-adfe-731f3547f620	2026-08-24 15:34	2026-08-24 15:34	2026-08-24 15:34	SPXW	SPXW260827P07620000	put	7620.0000	2026-08-27	20.7000	20.5000	20.8000	7656.5600	103500.00	103500.00	0.00	50	10	173	195	0.887179487179487	0.133817810739585	0.133778080471077	false	false	false	true	false
36ef91ef-e03f-4e48-8eab-8ebab081645e	2026-08-24 15:35	2026-08-24 15:35	2026-08-24 15:35	SPXW	SPXW260825P07655000	put	7655.0000	2026-08-25	15.6300	15.4000	15.7000	7655.5500	156320.00	156320.00	0.00	100	17	5760	222	25.9459459459459	0.101751689844331	0.102377633568024	false	false	false	true	false
045f1612-bb97-4496-a58b-e5936efd3c06	2026-08-24 15:41	2026-08-24 15:41	2026-08-24 15:41	SPXW	SPXW260825C07655000	call	7655.0000	2026-08-25	16.1000	16.0000	16.3000	7654.8300	106260.00	0.00	106260.00	66	12	4024	105	38.3238095238095	0.0987532874216522	0.0987532874216522	false	false	false	true	false
0bb59630-1215-45b2-a0b3-a1d41de500b2	2026-08-24 15:44	2026-08-24 15:44	2026-08-24 15:44	SPXW	SPXW260827P07700000	put	7700.0000	2026-08-27	58.3600	57.9000	58.4000	7655.0300	519370.00	519370.00	0.00	89	17	1096	3004	0.364846870838882	0.117387212145728	0.118211542669512	false	false	false	true	false
e262744d-10d8-401e-92b1-5da8e45448a9	2026-08-24 15:45	2026-08-24 15:45	2026-08-24 15:45	SPXW	SPXW260902P07550000	put	7550.0000	2026-09-02	23.0500	23.0000	23.3000	7654.6300	1383000.00	0.00	0.00	600	8	662	1712	0.386682242990654	0.13463409453009	0.134409464945845	false	false	false	true	false
2c7319ef-2165-4f66-b171-52812e2b84a5	2026-08-24 15:45	2026-08-24 15:45	2026-08-24 15:45	SPXW	SPXW260902P07350000	put	7350.0000	2026-09-02	5.2000	5.0000	5.2500	7654.9800	780000.00	0.00	0.00	1500	8	1510	99	15.2525252525253	0.170494908535941	0.170494908535941	false	false	false	true	false
41964e69-43e3-4bb4-a768-a566c2c90abb	2026-08-24 15:46	2026-08-24 15:46	2026-08-24 15:46	SPXW	SPXW260824P07655000	put	7655.0000	2026-08-24	3.6700	3.5000	3.9000	7653.4500	226300.00	130310.00	88790.00	616	262	150406	845	177.995266272189	0.190082234122395	0.188716251694312	false	false	false	true	false
7dd5f43f-9aba-450a-86e2-61e1e6da2058	2026-08-24 15:47	2026-08-24 15:47	2026-08-24 15:47	SPXW	SPXW260825P07655000	put	7655.0000	2026-08-25	16.4000	16.3000	16.6000	7653.1900	137760.00	0.00	137760.00	84	16	6643	222	29.9234234234234	0.0994130861057585	0.0994130861057585	false	false	false	true	false
b868a3ce-e43b-47c2-a920-450ece15c45a	2026-08-24 15:50	2026-08-24 15:50	2026-08-24 15:50	SPXW	SPXW260826P07660000	put	7660.0000	2026-08-26	23.6300	23.5000	23.9000	7656.0000	122880.00	21330.00	101550.00	52	12	1042	267	3.90262172284644	0.0994005937624032	0.0994005937624032	true	false	false	true	false
c2b16ac0-06d9-4d44-a3a0-8127c2117fb6	2026-08-24 15:52	2026-08-24 15:51	2026-08-24 15:51	SPXW	SPXW260831C07700000	call	7700.0000	2026-08-31	28.2000	28.1000	28.4000	7653.9500	211500.00	101520.00	109980.00	75	11	1432	3428	0.417736289381564	0.10754285105616	0.10754285105616	false	false	false	true	false
e5a26eba-583f-4b48-aaf4-986b8fc12afd	2026-08-24 15:52	2026-08-24 15:52	2026-08-24 15:52	SPXW	SPXW260825P07655000	put	7655.0000	2026-08-25	16.6700	16.4000	16.8000	7653.0600	166700.00	166700.00	0.00	100	18	6857	222	30.8873873873874	0.100250191765864	0.101502104534485	false	false	false	true	false
195fef91-390a-4600-aa27-6322712d165e	2026-08-24 15:55	2026-08-24 15:54	2026-08-24 15:54	SPXW	SPXW260825P07655000	put	7655.0000	2026-08-25	15.1000	15.1000	15.2000	7655.0300	122310.00	0.00	122310.00	81	5	7137	222	32.1486486486486	0.0970339711428939	0.0970339711428939	false	false	false	true	false
50bb85b6-d96e-44f1-bf91-caac2d7d410b	2026-08-24 15:55	2026-08-24 15:55	2026-08-24 15:55	SPXW	SPXW260825P07655000	put	7655.0000	2026-08-25	16.2700	16.1000	16.6000	7652.0200	118770.00	0.00	118770.00	73	14	7232	222	32.5765765765766	0.0961917986619476	0.0950102169110751	false	false	false	true	false
b3744dc0-a7e0-4357-adad-0640097b5156	2026-08-24 15:56	2026-08-24 15:56	2026-08-24 15:56	SPXW	SPXW260825C07665000	call	7665.0000	2026-08-25	11.1000	11.0000	11.1000	7654.5700	101010.00	101010.00	0.00	91	7	8274	1149	7.20104438642298	0.0969273506765367	0.0965381835039488	false	false	false	true	false
f0ba56d8-806b-424b-9597-8f4417aa563b	2026-08-25 09:30	2026-08-24 16:13	2026-08-24 16:13	SPXW	SPXW260825C07680000	call	7680.0000	2026-08-25	5.1200	5.0000	5.4000	7652.8600	153680.00	102000.00	44260.00	300	25	5171	194	26.6546391752577	0.0931672077192296	0.091558813795053	false	false	false	true	false
033f07c5-7103-4e14-ba72-27d94b3e9ddf	2026-08-25 09:30	2026-08-25 09:30	2026-08-25 09:30	SPXW	SPXW260825C07660000	call	7660.0000	2026-08-25	25.0100	0.0000	0.0000	7682.9900	185090.00	185090.00	0.00	74	14	121	1192	0.101510067114094	0.112369795303306	0.10838191182901	false	false	false	true	false
af8788ad-0799-4b23-b46b-072133cee8dc	2026-08-25 09:39	2026-08-25 09:39	2026-08-25 09:39	SPXW	SPXW260825C07670000	call	7670.0000	2026-08-25	17.3500	0.0000	0.0000	7682.2900	124910.00	124910.00	0.00	72	21	384	1445	0.265743944636678	0.117699568697495	0.120462721267036	false	false	false	true	false
5258bb3f-be53-4503-9a9d-ff25da98462b	2026-08-25 09:40	2026-08-25 09:40	2026-08-25 09:40	SPXW	SPXW260825C07700000	call	7700.0000	2026-08-25	3.5000	0.0000	0.0000	7682.6600	171850.00	171850.00	0.00	491	30	3113	3502	0.888920616790405	0.118511615187695	0.118511615187695	false	false	false	true	false
0c8710e4-a0f4-49a8-86c1-ca67b52972aa	2026-08-25 09:41	2026-08-25 09:40	2026-08-25 09:40	SPXW	SPXW260825C07700000	call	7700.0000	2026-08-25	3.8000	0.0000	0.0000	7682.8600	190000.00	190000.00	0.00	500	35	3630	3502	1.03655054254712	0.122376063835358	0.122376063835358	false	false	false	true	false
b50fa281-a320-4a66-95de-5086e3afc2a9	2026-08-25 09:44	2026-08-25 09:44	2026-08-25 09:44	SPXW	SPXW260825C07685000	call	7685.0000	2026-08-25	7.4500	7.3000	7.5000	7680.0900	149070.00	135010.00	0.00	200	35	3008	1876	1.60341151385928	0.116817526798218	0.118061925728105	false	false	false	true	false
f2fe7402-5f02-4ddc-89f0-0e3aed939aec	2026-08-25 09:45	2026-08-25 09:45	2026-08-25 09:45	SPXW	SPXW260826C07680000	call	7680.0000	2026-08-26	19.5400	19.5000	19.9000	7682.9700	127040.00	0.00	127040.00	65	16	429	1535	0.279478827361564	0.110056770286337	0.109431023378332	false	false	false	true	false
944d78d3-befb-4fbf-95d1-4e45ac3d1322	2026-08-25 09:47	2026-08-25 09:47	2026-08-25 09:47	SPXW	SPXW260826C07685000	call	7685.0000	2026-08-26	16.8000	16.6000	17.0000	7682.7400	126000.00	47040.00	78960.00	75	9	185	398	0.464824120603015	0.10920598429766	0.10920598429766	false	false	false	true	false
0a741b96-631d-4c32-b7bf-a57f7789327e	2026-08-25 09:55	2026-08-25 09:55	2026-08-25 09:55	SPXW	SPXW260825P07725000	put	7725.0000	2026-08-25	47.5100	47.4000	48.2000	7678.6700	142520.00	0.00	142520.00	30	8	103	612	0.168300653594771	0.170675888114913	0.170675888114913	false	false	false	true	false
bc9aa771-2556-48ee-892d-e2449a453e32	2026-08-25 09:57	2026-08-25 09:57	2026-08-25 09:57	SPXW	SPXW260825P07725000	put	7725.0000	2026-08-25	49.5900	49.0000	49.7000	7675.2500	148780.00	39660.00	109120.00	30	8	140	612	0.228758169934641	0.101128206531883	0.127974623797743	false	false	false	true	false
1091103b-df2c-4af5-a90c-d310e01e69b6	2026-08-25 09:57	2026-08-25 09:57	2026-08-25 09:57	SPXW	SPXW260825P07670000	put	7670.0000	2026-08-25	7.5600	7.4000	7.7000	7675.7000	133740.00	132980.00	0.00	177	73	5901	750	7.868	0.127823745391211	0.127908192049671	false	false	false	true	false
15664441-9003-4730-94fa-5bc02a98fc21	2026-08-25 10:02	2026-08-25 10:01	2026-08-25 10:01	SPXW	SPXW260825C07670000	call	7670.0000	2026-08-25	12.1000	11.9000	12.2000	7675.8300	129470.00	26620.00	102850.00	107	13	2635	1445	1.82352941176471	0.107456023544599	0.109612146878499	false	false	false	true	false
acc20181-08c5-4f99-b011-c1b0f8ecf22e	2026-08-25 10:02	2026-08-25 10:02	2026-08-25 10:02	SPXW	SPXW260825P07725000	put	7725.0000	2026-08-25	50.4000	50.0000	50.5000	7675.8100	136080.00	25200.00	110880.00	27	7	201	612	0.32843137254902	0.178229130894455	0.178229130894455	false	false	false	true	false
680a1e29-0df0-4ad1-8b8e-c16ecbbaa522	2026-08-25 10:03	2026-08-25 10:03	2026-08-25 10:03	SPXW	SPXW260825P07670000	put	7670.0000	2026-08-25	8.2700	8.1000	8.4000	7673.0400	165470.00	165470.00	0.00	200	40	8577	750	11.436	0.122034156222077	0.124563479975464	false	false	false	true	false
8f7d28bb-1474-4286-99b3-80ae232cd581	2026-08-25 10:03	2026-08-25 10:03	2026-08-25 10:03	SPXW	SPXW260831C07785000	call	7785.0000	2026-08-31	8.1000	8.0000	8.3000	7674.6200	262440.00	217890.00	44550.00	324	15	335	783	0.427841634738186	0.103590327924821	0.103590327924821	false	false	false	true	false
67db9830-9750-4f3e-8ac7-4317e047172b	2026-08-25 10:04	2026-08-25 10:04	2026-08-25 10:04	SPXW	SPXW260825P07650000	put	7650.0000	2026-08-25	3.2000	3.1000	3.3000	7671.2400	119040.00	44160.00	74240.00	372	48	13819	2660	5.19511278195489	0.134177962655053	0.134177962655053	false	false	false	true	false
2a9be7c6-b0f4-4f21-a8f8-0018711badf1	2026-08-25 10:10	2026-08-25 10:10	2026-08-25 10:10	SPXW	SPXW260825P07725000	put	7725.0000	2026-08-25	54.1000	53.5000	54.2000	7671.8900	135240.00	70320.00	64920.00	25	9	337	612	0.550653594771242	0.17956266957256	0.183272149656345	false	false	false	true	false
080fa575-4f6c-4f2a-be5c-c3979939d724	2026-08-25 10:11	2026-08-25 10:11	2026-08-25 10:11	SPXW	SPXW260930P07600000	put	7600.0000	2026-09-30	89.2000	88.9000	89.3000	7672.4000	892000.00	713600.00	178400.00	100	6	107	7797	0.0137232268821342	0.139994352808761	0.139920711167369	false	false	false	true	false
00189ba7-38fd-47c2-835d-4b82246c3602	2026-08-25 10:11	2026-08-25 10:11	2026-08-25 10:11	SPXW	SPXW260930P07450000	put	7450.0000	2026-09-30	55.8000	55.7000	56.0000	7672.3000	558000.00	78120.00	479880.00	100	6	104	5005	0.0207792207792208	0.157148228334386	0.157148228334386	false	false	false	true	false
cdaf9899-564c-49e5-9e35-7418df0b75aa	2026-08-25 10:13	2026-08-25 10:13	2026-08-25 10:13	SPXW	SPXW260825P07680000	put	7680.0000	2026-08-25	13.6300	13.5000	13.8000	7672.2600	133570.00	1380.00	118490.00	98	37	12031	479	25.1169102296451	0.120117457875228	0.11743991365058	false	false	false	true	false
682a3515-1857-4454-b599-94c50951d75c	2026-08-25 10:14	2026-08-25 10:14	2026-08-25 10:14	SPXW	SPXW260904P07500000	put	7500.0000	2026-09-04	18.4000	18.0000	18.3000	7671.5400	1932000.00	0.00	0.00	1050	5	1083	6117	0.177047572339382	0.153893987106883	0.153893987106883	false	false	false	true	false