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

5b5e6b21-1012-410b-88ed-60f93d84edb5	2026-08-20 11:46	2026-08-20 11:46	2026-08-20 11:46	SPXW	SPXW260904P07580000	put	7580.0000	2026-09-04	45.0800	44.7000	45.1000	7671.4900	414770.00	414770.00	0.00	92	11	118	221	0.53393665158371	0.141263331047402	0.141444811069859	false	false	false	true	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	—	—	—	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-20T15:52:12.298393Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
67f5706f-747e-47fb-8f57-f3915786ab73	2026-08-20 11:52	2026-08-20 11:52	2026-08-20 11:52	SPXW	SPXW260820C07675000	call	7675.0000	2026-08-20	11.1500	11.0000	11.2000	7677.9400	111520.00	104860.00	0.00	100	20	11390	248	45.9274193548387	0.142555164201363	0.142555164201363	false	false	false	true	false
a41ce275-7e9f-4b2c-82f6-6e8647a5421a	2026-08-20 12:00	2026-08-20 12:00	2026-08-20 12:00	SPXW	SPXW260820P07785000	put	7785.0000	2026-08-20	111.4500	109.7000	113.8000	7675.7100	222900.00	100140.00	122760.00	20	7	104	194	0.536082474226804	0.431897653727733	0.455015449390172	false	false	false	true	false
8773f56c-5ada-4e89-b790-e3420a1bb886	2026-08-20 12:02	2026-08-20 12:02	2026-08-20 12:02	SPXW	SPXW260820P07670000	put	7670.0000	2026-08-20	6.8100	6.8000	7.0000	7674.7400	136270.00	0.00	136270.00	200	42	41969	1635	25.6691131498471	0.14017721214249	0.138606184758528	false	false	false	true	false
4b681126-7f9a-40e5-bcff-783d8a1ace16	2026-08-20 12:14	2026-08-20 12:14	2026-08-20 12:14	SPXW	SPXW261030P07250000	put	7250.0000	2026-10-30	73.5100	73.7000	74.2000	7673.7400	9409280.00	0.00	0.00	1280	6	1284	953	1.34732423924449	0.184094343228917	0.184094343228917	false	false	false	true	false
c7b1ee28-db6e-45ff-b63f-24a9e7f2d152	2026-08-20 12:16	2026-08-20 12:16	2026-08-20 12:16	SPXW	SPXW260820C07670000	call	7670.0000	2026-08-20	10.8100	10.6000	10.9000	7674.3100	136220.00	17420.00	118800.00	126	5	8130	145	56.0689655172414	0.134697876995861	0.131457533425139	false	false	false	true	false
ad9114c9-96fc-4559-be84-759a5a263434	2026-08-20 12:18	2026-08-20 12:18	2026-08-20 12:18	SPXW	SPXW261231C08210000	call	8210.0000	2026-12-31	86.5700	86.2000	86.8000	7673.7600	129855000.00	0.00	0.00	15000	11	15000	133	112.781954887218	0.126582600250774	0.126582600250774	false	false	false	true	false
917aae7e-471a-424a-a533-8df3203f6a6f	2026-08-20 12:18	2026-08-20 12:18	2026-08-20 12:18	SPXW	SPXW261231C08170000	call	8170.0000	2026-12-31	97.7000	97.3000	97.9000	7673.7600	244250000.00	0.00	0.00	25000	11	25000	22517	1.11027223875294	0.127624812847536	0.127624812847536	false	false	false	true	false
26faf017-0f53-40be-9f16-8b6dfd200343	2026-08-20 12:18	2026-08-20 12:18	2026-08-20 12:18	SPXW	SPXW261231C08190000	call	8190.0000	2026-12-31	92.0100	91.6000	92.2000	7673.7600	368040000.00	0.00	0.00	40000	11	40000	42713	0.936483037950975	0.127096745940565	0.127096745940565	false	false	false	true	false
4fd9e03c-79e5-4fa0-a48c-d7b55fae1066	2026-08-20 12:24	2026-08-20 12:24	2026-08-20 12:24	SPXW	SPXW260821P07700000	put	7700.0000	2026-08-21	31.3100	31.2000	31.5000	7678.1500	112720.00	18800.00	87640.00	36	11	3924	3382	1.16026020106446	0.118655346667149	0.117968518348768	false	false	false	true	false
05d0262b-a342-467e-8ca7-ea4aa15559c4	2026-08-20 12:24	2026-08-20 12:24	2026-08-20 12:24	SPXW	SPXW260820C07680000	call	7680.0000	2026-08-20	7.5000	7.4000	7.8000	7678.5100	262670.00	0.00	262670.00	350	60	33588	151	222.437086092715	0.133376385865604	0.130142664679845	false	false	false	true	false
824aef00-05b4-4d8b-8b83-8b91b811cfe3	2026-08-20 12:33	2026-08-20 12:33	2026-08-20 12:33	SPXW	SPXW260820P07695000	put	7695.0000	2026-08-20	21.0300	21.0000	21.4000	7675.2400	105150.00	0.00	105150.00	50	11	14795	1964	7.53309572301426	0.126758136622059	0.121095603553488	false	false	false	true	false
ccbeda56-e64f-4c5a-8b73-55d2ebb154b4	2026-08-20 12:34	2026-08-20 12:34	2026-08-20 12:34	SPXW	SPXW260820C07675000	call	7675.0000	2026-08-20	10.5100	10.5000	10.7000	7679.9800	105050.00	0.00	100810.00	100	17	19403	248	78.2379032258064	0.128748647149177	0.127037955090025	true	false	false	true	false
bf3cbce3-3c32-4647-b78a-006ef7cd1b75	2026-08-20 12:37	2026-08-20 12:36	2026-08-20 12:36	SPXW	SPXW260828P07700000	put	7700.0000	2026-08-28	59.7300	59.7000	60.1000	7680.6300	119460.00	0.00	119460.00	20	6	526	5218	0.100804906094289	0.116827680879809	0.116827680879809	false	false	false	true	false
b0d189bb-db07-47bb-8402-1ddeb34333f7	2026-08-20 12:38	2026-08-20 12:38	2026-08-20 12:38	SPXW	SPXW260828P07505000	put	7505.0000	2026-08-28	13.3100	12.3000	13.6000	7680.5900	362140.00	231420.00	130720.00	272	19	324	200	1.62	0.155240344923029	0.154855767518316	false	false	false	true	false
4d814992-2361-485f-b7c4-6846f73d0942	2026-08-20 12:44	2026-08-20 12:44	2026-08-20 12:44	SPXW	SPXW260820C07600000	call	7600.0000	2026-08-20	83.0000	82.7000	83.0000	7682.5200	166000.00	166000.00	0.00	20	5	378	295	1.28135593220339	0.28311887554693	0.28311887554693	false	false	false	true	false
394395eb-3e6a-422a-a6b3-5308b7e02a70	2026-08-20 12:44	2026-08-20 12:44	2026-08-20 12:44	SPXW	SPXW260820C07675000	call	7675.0000	2026-08-20	13.0000	12.9000	13.0000	7683.7300	109170.00	105300.00	3870.00	84	6	20741	248	83.633064516129	0.130187930421129	0.132066689531999	false	false	false	true	false
ce0d035d-851a-42d9-88cd-b2277c0df3de	2026-08-20 12:52	2026-08-20 12:52	2026-08-20 12:52	SPXW	SPXW260820P07780000	put	7780.0000	2026-08-20	100.1200	99.2000	103.7000	7680.3000	200240.00	170120.00	30120.00	20	6	89	360	0.247222222222222	0.33893665080294	0.380478441815394	false	false	false	true	false
799748dd-8d3c-4c08-bfee-ec51c3a43d49	2026-08-20 13:00	2026-08-20 13:00	2026-08-20 13:00	SPXW	SPXW260825P07680000	put	7680.0000	2026-08-25	31.9000	31.8000	31.9000	7682.0000	200970.00	200970.00	0.00	63	6	338	244	1.38524590163934	0.0970606595240834	0.0970606595240834	false	false	false	true	false
0fdf0926-5973-4eb4-8b28-d2b0c838aad9	2026-08-20 13:01	2026-08-20 13:00	2026-08-20 13:00	SPXW	SPXW260821P07655000	put	7655.0000	2026-08-21	10.9000	10.8000	11.0000	7681.3600	149330.00	45780.00	7630.00	137	10	1709	1120	1.52589285714286	0.136423786940291	0.136423786940291	false	false	false	true	false
6e57518a-4fc6-4556-b379-057eefe08e83	2026-08-20 13:01	2026-08-20 13:01	2026-08-20 13:01	SPXW	SPXW260821P07655000	put	7655.0000	2026-08-21	11.1000	11.0000	11.2000	7680.9200	209790.00	111000.00	0.00	189	16	1990	1120	1.77678571428571	0.136870574810089	0.136870574810089	false	false	false	true	false
7194eaad-7caa-47ba-9209-89834a9dc35e	2026-08-20 13:02	2026-08-20 13:02	2026-08-20 13:02	SPXW	SPXW260831C07685000	call	7685.0000	2026-08-31	60.5200	60.0000	62.0000	7679.9100	484150.00	459870.00	24280.00	80	12	149	73	2.04109589041096	0.110134299558662	0.110322421580204	false	false	false	true	false
554d14af-eb11-439b-864b-fb3fbdfe5dd6	2026-08-20 13:03	2026-08-20 13:03	2026-08-20 13:03	SPXW	SPXW260820C07685000	call	7685.0000	2026-08-20	3.9000	3.8000	4.0000	7678.6800	113490.00	63180.00	50310.00	291	42	44553	165	270.018181818182	0.11653822217059	0.11653822217059	false	false	false	true	false
1465617a-9b46-40fa-8392-c2b3b753e548	2026-08-20 13:15	2026-08-20 13:15	2026-08-20 13:15	SPXW	SPXW260820P07675000	put	7675.0000	2026-08-20	7.9500	7.8000	8.1000	7672.7400	109710.00	109710.00	0.00	138	34	60419	2900	20.8341379310345	0.123381634052179	0.126790221444852	true	false	false	true	false
ab5b5581-10fc-426f-a842-7ecac534d16d	2026-08-20 13:20	2026-08-20 13:20	2026-08-20 13:20	SPXW	SPXW260820P07680000	put	7680.0000	2026-08-20	15.0000	14.7000	15.0000	7667.2500	523410.00	521920.00	1490.00	349	46	66328	1657	40.028968014484	0.129237432176438	0.12677484802311	false	false	false	true	false
8b49bb91-3649-42f8-ba40-ec033708d6ed	2026-08-20 13:20	2026-08-20 13:20	2026-08-20 13:20	SPXW	SPXW260821P07700000	put	7700.0000	2026-08-21	37.9500	37.8000	39.3000	7667.0500	519970.00	405530.00	114440.00	137	10	4499	3382	1.33027794204613	0.110060846695789	0.107611608176881	false	false	false	true	false
e4e2b459-e125-46b0-9953-bd8ad46e0e49	2026-08-20 13:21	2026-08-20 13:21	2026-08-20 13:21	SPXW	SPXW260827P07675000	put	7675.0000	2026-08-27	49.0000	48.9000	49.0000	7668.7300	147000.00	147000.00	0.00	30	5	234	385	0.607792207792208	0.114794504865488	0.114794504865488	false	false	false	true	false
1a3c22ba-ff96-4451-a468-7feb0d167cef	2026-08-20 13:23	2026-08-20 13:22	2026-08-20 13:22	SPXW	SPXW260828C07675000	call	7675.0000	2026-08-28	56.3000	56.0000	56.4000	7670.3300	563000.00	563000.00	0.00	100	9	245	586	0.418088737201365	0.122439403232821	0.122439403232821	true	false	false	true	false
b0343c36-5d83-4141-bda5-161626a71d77	2026-08-20 13:30	2026-08-20 13:29	2026-08-20 13:29	SPXW	SPXW260828C07690000	call	7690.0000	2026-08-28	45.9000	45.7000	46.0000	7666.3100	224910.00	45900.00	179010.00	49	6	163	141	1.15602836879433	0.119409959243959	0.119409959243959	false	false	false	true	false
c13d7350-4982-4c01-bfb3-fd1a53e8cdb6	2026-08-20 13:35	2026-08-20 13:34	2026-08-20 13:34	SPXW	SPXW260930C07665000	call	7665.0000	2026-09-30	147.3000	147.2000	147.3000	7664.7900	1399350.00	1399350.00	0.00	95	6	218	51	4.27450980392157	0.127512988009656	0.127512988009656	false	false	false	true	false
41548e1a-26a5-4fed-a06e-bdfdd42f4b1c	2026-08-20 13:35	2026-08-20 13:34	2026-08-20 13:34	SPXW	SPXW260930C07665000	call	7665.0000	2026-09-30	147.3000	147.2000	147.8000	7664.7900	1738140.00	0.00	1738140.00	118	8	123	51	2.41176470588235	0.127512988009656	0.127512988009656	false	false	false	true	false
f6c50787-93c4-46a6-bfda-015c7b54da45	2026-08-20 13:36	2026-08-20 13:36	2026-08-20 13:36	SPXW	SPXW260820P07660000	put	7660.0000	2026-08-20	4.1000	3.9000	4.2000	7665.4600	111500.00	61910.00	49590.00	272	34	59662	2452	24.3319738988581	0.126551592678145	0.128651591257743	false	false	false	true	false
579116f5-9b85-4e0b-89ed-a069f231b65d	2026-08-20 13:45	2026-08-20 13:45	2026-08-20 13:45	SPXW	SPXW260824C07625000	call	7625.0000	2026-08-24	57.9900	57.7000	58.1000	7663.2200	226150.00	191350.00	34800.00	39	9	75	599	0.125208681135225	0.104002240685197	0.104356623098263	false	false	false	true	false
7ed50cc6-22ba-40ed-bcf8-503939cf214c	2026-08-20 13:45	2026-08-20 13:45	2026-08-20 13:45	SPXW	SPXW260820P07660000	put	7660.0000	2026-08-20	4.5600	4.4000	4.7000	7663.7600	124460.00	63190.00	61270.00	273	47	65711	2452	26.7989396411093	0.129641193615416	0.127532558298246	false	false	false	true	false
13f64a46-b90e-4415-8d2d-7da37b1c10eb	2026-08-20 13:47	2026-08-20 13:47	2026-08-20 13:47	SPXW	SPXW260828C07690000	call	7690.0000	2026-08-28	45.2000	45.2000	45.3000	7665.4800	226000.00	0.00	226000.00	50	5	267	141	1.8936170212766	0.11859559696914	0.118685760770657	false	false	false	true	false
0ca141b2-890a-4156-bde5-b8044390bbad	2026-08-20 13:48	2026-08-20 13:48	2026-08-20 13:48	SPXW	SPXW260820P07660000	put	7660.0000	2026-08-20	3.8000	3.7000	3.9000	7665.3200	105260.00	380.00	104880.00	277	40	66955	2452	27.3062805872757	0.12589557265643	0.126373250860067	false	false	false	true	false
8e54ee77-103e-483c-907c-1e728ae8532c	2026-08-20 13:58	2026-08-20 13:58	2026-08-20 13:58	SPXW	SPXW260828P07640000	put	7640.0000	2026-08-28	42.2000	42.1000	42.2000	7665.5700	147700.00	147700.00	0.00	35	7	467	948	0.492616033755274	0.12554385147414	0.12554385147414	false	false	false	true	false
55159338-8c61-4d1c-93f1-fe05280f4b20	2026-08-20 14:02	2026-08-20 14:01	2026-08-20 14:01	SPXW	SPXW260820P07660000	put	7660.0000	2026-08-20	5.5900	5.4000	5.8000	7660.8000	177610.00	100060.00	74160.00	318	54	74204	2452	30.2626427406199	0.133702507094	0.129327896448222	false	false	false	true	false
e8617a29-1179-47ab-8932-952493f680ca	2026-08-20 14:02	2026-08-20 14:02	2026-08-20 14:02	SPXW	SPXW260828C07780000	call	7780.0000	2026-08-28	11.5000	11.4000	11.7000	7660.8100	119600.00	0.00	119600.00	104	6	658	446	1.47533632286996	0.106055505542014	0.106055505542014	false	false	false	true	false
1e2060e5-d9f1-4212-8056-1f3c744b8298	2026-08-20 14:02	2026-08-20 14:02	2026-08-20 14:02	SPXW	SPXW260831P07600000	put	7600.0000	2026-08-31	37.8000	37.5000	37.9000	7660.7100	756000.00	211680.00	544320.00	200	15	629	6712	0.0937127532777116	0.126529023686786	0.126529023686786	false	false	false	true	false
8b2d8689-c244-4027-bb0a-acaddda60dc9	2026-08-20 14:03	2026-08-20 14:02	2026-08-20 14:02	SPXW	SPXW260820P07660000	put	7660.0000	2026-08-20	6.5100	6.4000	6.7000	7659.6000	101480.00	100200.00	1280.00	156	43	75061	2452	30.6121533442088	0.138796656444256	0.140989559535411	false	false	false	true	false
b38bffbc-660f-493f-97f8-aa1b8e450f2b	2026-08-20 14:03	2026-08-20 14:03	2026-08-20 14:03	SPXW	SPXW260831P07600000	put	7600.0000	2026-08-31	38.3000	38.2000	38.4000	7659.2800	160860.00	0.00	153200.00	42	5	673	6712	0.100268176400477	0.126566232823753	0.126566232823753	false	false	false	true	false
198aed85-f3a9-4a8d-9c15-1ab944073815	2026-08-20 14:06	2026-08-20 14:05	2026-08-20 14:05	SPXW	SPXW260820P07645000	put	7645.0000	2026-08-20	3.3200	3.2000	3.5000	7656.2200	108830.00	20740.00	87760.00	328	143	39951	4293	9.30607966457023	0.181917782209196	0.167509894619516	false	false	false	true	false
60910b28-80c8-4f35-a4a2-da82ca0f77a4	2026-08-20 14:06	2026-08-20 14:06	2026-08-20 14:06	SPXW	SPXW260820P07660000	put	7660.0000	2026-08-20	7.8700	7.7000	8.1000	7656.8700	157370.00	0.00	157370.00	200	35	78132	2452	31.8646003262643	0.141177780471022	0.136644143524899	true	false	false	true	false
c85e2baa-b8fb-4031-952d-75ce5a55581b	2026-08-20 14:08	2026-08-20 14:08	2026-08-20 14:08	SPXW	SPXW260825C07665000	call	7665.0000	2026-08-25	33.4000	33.2000	33.5000	7654.7000	106880.00	66800.00	40080.00	32	9	680	10	68	0.102033556727811	0.102033556727811	false	false	false	true	false
18da2157-e083-4c51-b2d1-c9366fbf1c33	2026-08-20 14:10	2026-08-20 14:10	2026-08-20 14:10	SPXW	SPXW260821P07660000	put	7660.0000	2026-08-21	23.8000	23.7000	23.9000	7654.4600	116620.00	107100.00	0.00	49	10	2650	1244	2.13022508038585	0.133479231747122	0.133479231747122	false	false	false	true	false
179bbc4c-e77a-4b4d-aa42-82242394e737	2026-08-20 14:10	2026-08-20 14:10	2026-08-20 14:10	SPXW	SPXW260820P07660000	put	7660.0000	2026-08-20	10.0000	9.9000	10.0000	7653.7800	156000.00	156000.00	0.00	156	24	80536	2452	32.8450244698206	0.14654138900903	0.14654138900903	false	false	false	true	false
95e91181-00ee-4bec-b5b0-052ec5ba6d82	2026-08-20 14:14	2026-08-20 14:14	2026-08-20 14:14	SPXW	SPXW260825C07665000	call	7665.0000	2026-08-25	33.3000	33.2000	33.3000	7654.3700	213120.00	213120.00	0.00	64	6	810	10	81	0.102191783009625	0.102191783009625	false	false	false	true	false
bb313f46-c086-415a-93e2-acd770b9d70f	2026-08-20 14:16	2026-08-20 14:16	2026-08-20 14:16	SPXW	SPXW260820P07665000	put	7665.0000	2026-08-20	14.2000	14.1000	14.2000	7652.4800	137740.00	137740.00	0.00	97	7	78957	1673	47.1948595337717	0.140363289519179	0.140363289519179	false	false	false	true	false
6d680294-ef92-4bb6-91d4-d51c6cee80ab	2026-08-20 14:17	2026-08-20 14:16	2026-08-20 14:16	SPXW	SPXW260820C07635000	call	7635.0000	2026-08-20	18.4000	18.3000	18.4000	7650.1100	121440.00	121440.00	0.00	66	8	1750	64	27.34375	0.20660662114708	0.20660662114708	false	false	false	true	false