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

0a0ecebc-5511-4b52-8100-6799e24540f6	2026-08-18 11:45	2026-08-18 11:45	2026-08-18 11:45	SPXW	SPXW260818P07700000	put	7700.0000	2026-08-18	7.1500	7.0000	7.4000	7701.4000	285950.00	0.00	277310.00	400	66	67228	3928	17.1150712830957	0.117502845931639	0.116019761988271	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-18T15:49:10.773359Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
17f92bee-c6e2-41af-8dc0-22a8be1cfadc	2026-08-18 11:45	2026-08-18 11:45	2026-08-18 11:45	SPXW	SPXW260819P07685000	put	7685.0000	2026-08-19	12.9000	12.8000	12.9000	7702.2300	116100.00	116100.00	0.00	90	8	882	390	2.26153846153846	0.12870218880105	0.12870218880105	false	false	false	true	false
c12c9bcf-fa71-4868-bbee-88a6cbe0a8a8	2026-08-18 11:56	2026-08-18 11:56	2026-08-18 11:56	SPXW	SPXW260818C07700000	call	7700.0000	2026-08-18	9.7500	9.5000	9.8000	7702.8200	195040.00	195040.00	0.00	200	32	33668	515	65.3747572815534	0.123013482869836	0.123013482869836	false	false	false	true	false
80244625-ea58-4db3-ac51-4b7bcb348a67	2026-08-18 11:59	2026-08-18 11:58	2026-08-18 11:58	SPXW	SPXW260819P07675000	put	7675.0000	2026-08-19	10.1000	10.0000	10.2000	7701.3300	147460.00	71710.00	52520.00	146	11	2506	789	3.17617237008872	0.130352553596889	0.130352553596889	false	false	false	true	false
34dc5566-fe95-4979-8813-20067b1eedab	2026-08-18 11:59	2026-08-18 11:58	2026-08-18 11:59	SPXW	SPXW260819C07715000	call	7715.0000	2026-08-19	12.3000	12.2000	12.5000	7701.2500	143910.00	47970.00	72570.00	117	14	1742	62	28.0967741935484	0.11208397702335	0.11208397702335	false	false	false	true	false
2f21858d-7d7a-44a3-9190-2aa6c7c47d4e	2026-08-18 12:02	2026-08-18 12:02	2026-08-18 12:02	SPXW	SPXW260818C07700000	call	7700.0000	2026-08-18	11.0000	10.9000	11.0000	7704.8900	211200.00	211200.00	0.00	192	8	35220	515	68.3883495145631	0.126305763486985	0.126305763486985	false	false	false	true	false
9daee144-feff-49db-b2ae-3528b267f536	2026-08-18 12:08	2026-08-18 12:08	2026-08-18 12:08	SPXW	SPXW260911C07980000	call	7980.0000	2026-09-11	9.4400	9.4000	9.6000	7705.3000	119000.00	0.00	119000.00	126	5	129	1352	0.095414201183432	0.0989758332148885	0.0992591036378816	false	false	false	true	false
fac04b5c-6044-4cae-8902-a006af8add15	2026-08-18 12:12	2026-08-18 12:11	2026-08-18 12:11	SPXW	SPXW260818P07700000	put	7700.0000	2026-08-18	4.9000	4.8000	5.0000	7705.8500	185670.00	0.00	185670.00	379	71	76627	3928	19.5078920570265	0.11736518359897	0.1157211916968	false	false	false	true	false
3117f314-4d43-484a-b727-951d4f194913	2026-08-18 12:21	2026-08-18 12:21	2026-08-18 12:21	SPXW	SPXW260821P07665000	put	7665.0000	2026-08-21	17.1300	16.9000	17.2000	7705.8100	128510.00	128510.00	0.00	75	17	386	2480	0.155645161290323	0.124062361343963	0.124469885048955	false	false	false	true	false
39f38f35-9adc-496f-8615-0c332beae8de	2026-08-18 12:25	2026-08-18 12:25	2026-08-18 12:25	SPXW	SPXW260820C07710000	call	7710.0000	2026-08-20	23.4000	23.4000	23.5000	7705.9800	175500.00	0.00	175500.00	75	6	534	182	2.93406593406593	0.108042643212036	0.108042643212036	false	false	false	true	false
dbecc9a4-69c4-4764-ad19-fc54eb1bc90d	2026-08-18 12:25	2026-08-18 12:25	2026-08-18 12:25	SPXW	SPXW260818C07700000	call	7700.0000	2026-08-18	11.5000	11.4000	11.6000	7706.5700	105800.00	21850.00	0.00	92	10	39158	515	76.0349514563107	0.122553569001703	0.124086250108667	false	false	false	true	false
628c2451-d3d9-4d1f-92fd-1d5fa0227f4e	2026-08-18 12:32	2026-08-18 12:31	2026-08-18 12:31	SPXW	SPXW260818P07700000	put	7700.0000	2026-08-18	6.6900	6.5000	6.8000	7701.2400	224200.00	1340.00	222860.00	335	62	84185	3928	21.4320264765784	0.120368698254929	0.117087780906997	false	false	false	true	false
dd7f21ed-3ba0-4ab0-8c8a-eb39d70ceec8	2026-08-18 12:32	2026-08-18 12:32	2026-08-18 12:32	SPXW	SPXW260818P07705000	put	7705.0000	2026-08-18	8.4500	8.2000	8.5000	7702.7100	169050.00	169050.00	0.00	200	34	44381	1159	38.2924935289042	0.118846665381388	0.118846665381388	false	false	false	true	false
e7f11c74-5b9c-4b26-b097-c116309cd435	2026-08-18 12:32	2026-08-18 12:32	2026-08-18 12:32	SPXW	SPXW260818P07710000	put	7710.0000	2026-08-18	11.0000	10.9000	11.1000	7702.6600	221100.00	0.00	118800.00	201	23	30449	2468	12.3375202593193	0.11114043029152	0.11114043029152	false	false	false	true	false
e0ce0328-fddf-4535-a5a7-885dd75f54b7	2026-08-18 12:40	2026-08-18 12:40	2026-08-18 12:40	SPXW	SPXW260818C07700000	call	7700.0000	2026-08-18	10.5000	10.3000	10.6000	7705.7300	149080.00	133350.00	2080.00	142	28	41746	515	81.0601941747573	0.120457273102794	0.120457273102794	false	false	false	true	false
abe14da4-1c68-42eb-98c6-710477c94aff	2026-08-18 12:40	2026-08-18 12:40	2026-08-18 12:40	SPXW	SPXW260825C07745000	call	7745.0000	2026-08-25	23.5000	23.3000	23.6000	7706.1800	235000.00	141000.00	94000.00	100	5	265	19	13.9473684210526	0.0885957299143611	0.0885957299143611	false	false	false	true	false
0dea9305-ceed-4380-bbfa-1caf1343af54	2026-08-18 12:48	2026-08-18 12:47	2026-08-18 12:47	SPXW	SPXW260818C07700000	call	7700.0000	2026-08-18	11.0000	10.9000	11.0000	7706.2500	223300.00	223300.00	0.00	203	18	43154	515	83.7941747572816	0.125756177652627	0.125756177652627	false	false	false	true	false
5a155876-014f-4dcf-9fbe-a7c3b2b53679	2026-08-18 12:48	2026-08-18 12:48	2026-08-18 12:48	SPXW	SPXW260818P07700000	put	7700.0000	2026-08-18	3.7500	3.6000	3.9000	7707.1400	189460.00	2340.00	154070.00	505	77	90731	3928	23.0985234215886	0.118086840340377	0.114357655471038	false	false	false	true	false
7f2ab4d9-1795-45df-8e49-c72d7881c98d	2026-08-18 12:51	2026-08-18 12:51	2026-08-18 12:51	SPXW	SPXW260818C07700000	call	7700.0000	2026-08-18	11.5000	11.5000	11.7000	7707.9300	174820.00	0.00	172500.00	152	14	44016	515	85.4679611650485	0.1176584074996	0.115737082291945	false	false	false	true	false
e5a2965e-14ee-408e-8030-659c2989c301	2026-08-18 12:53	2026-08-18 12:53	2026-08-18 12:53	SPXW	SPXW260818P07700000	put	7700.0000	2026-08-18	3.5000	3.4000	3.6000	7708.1200	175010.00	113760.00	61250.00	500	71	92758	3928	23.6145621181263	0.120143923363159	0.118208536368332	false	false	false	true	false
86995c35-cec2-41cd-92b1-a783a6e89f9e	2026-08-18 12:55	2026-08-18 12:55	2026-08-18 12:55	SPXW	SPXW260818C07710000	call	7710.0000	2026-08-18	5.7900	5.7000	5.9000	7708.5400	207990.00	1760.00	206230.00	359	27	66106	119	555.512605042017	0.113630679852211	0.110157162638558	false	false	false	true	false
7a545c6f-070f-45ba-b5a3-1edf0dd07509	2026-08-18 12:57	2026-08-18 12:57	2026-08-18 12:57	SPXW	SPXW260828P07625000	put	7625.0000	2026-08-28	31.1000	30.9000	31.2000	7706.9000	236360.00	236360.00	0.00	76	8	212	326	0.650306748466258	0.131625432782596	0.131625432782596	false	false	false	true	false
b6ab9e91-5c43-4df5-a5b9-abf56a58687e	2026-08-18 13:03	2026-08-18 13:02	2026-08-18 13:02	SPXW	SPXW260818C07700000	call	7700.0000	2026-08-18	10.0000	9.9000	10.0000	7705.5700	128000.00	128000.00	0.00	128	9	45543	515	88.4330097087379	0.120442438786671	0.120442438786671	false	false	false	true	false
dffa677b-6c60-47e6-a464-990d219d0622	2026-08-18 13:09	2026-08-18 13:09	2026-08-18 13:09	SPXW	SPXW260818P07705000	put	7705.0000	2026-08-18	4.9000	4.9000	5.0000	7706.5900	110740.00	0.00	110740.00	226	21	53878	1159	46.4866264020707	0.102904014222845	0.102904014222845	false	false	false	true	false
06382f29-c68b-4c2c-981c-43e5619336a3	2026-08-18 13:24	2026-08-18 13:24	2026-08-18 13:24	SPXW	SPXW260818P07705000	put	7705.0000	2026-08-18	6.3000	6.2000	6.3000	7702.8400	263340.00	263340.00	0.00	418	30	57625	1159	49.7195858498706	0.0983397641128281	0.0983397641128281	false	false	false	true	false
a255266e-66c4-47de-b7ee-924b8cfca187	2026-08-18 13:25	2026-08-18 13:25	2026-08-18 13:25	SPXW	SPXW260821C07705000	call	7705.0000	2026-08-21	30.6000	30.4000	30.7000	7701.1700	306000.00	156060.00	149940.00	100	7	638	327	1.95107033639144	0.112398981356012	0.112398981356012	false	false	false	true	false
56da9852-37a8-4f58-8e70-91b86e20edd9	2026-08-18 13:30	2026-08-18 13:30	2026-08-18 13:30	SPXW	SPXW260818P07700000	put	7700.0000	2026-08-18	4.0000	3.9000	4.1000	7702.7600	226000.00	400.00	225600.00	565	43	108208	3928	27.5478615071283	0.102357681121454	0.102363318167192	false	false	false	true	false
be2e7ba7-b469-409b-ae47-bc55a185c406	2026-08-18 13:55	2026-08-18 13:55	2026-08-18 13:55	SPXW	SPXW260818P07700000	put	7700.0000	2026-08-18	4.8000	4.7000	4.8000	7699.7800	230880.00	230880.00	0.00	481	7	119742	3928	30.484215885947	0.0999519790337364	0.0999519790337364	false	false	false	true	false
a8185d52-41f6-4b49-a512-a013929c572d	2026-08-18 13:58	2026-08-18 13:58	2026-08-18 13:58	SPXW	SPXW260828C07875000	call	7875.0000	2026-08-28	5.1000	4.9000	5.2000	7697.8300	202980.00	45900.00	157080.00	398	16	769	1010	0.761386138613861	0.0970907849960027	0.0970907849960027	false	false	false	true	false
f38282d4-2f1b-46e1-9aef-a248997f2c0c	2026-08-18 14:00	2026-08-18 13:59	2026-08-18 13:59	SPXW	SPXW260818C07680000	call	7680.0000	2026-08-18	18.3000	18.1000	18.4000	7696.3000	151890.00	1830.00	150060.00	83	6	4413	119	37.0840336134454	0.159923107873295	0.159923107873295	false	false	false	true	false
9585da88-46b9-4031-876c-03443f9f3df5	2026-08-18 14:00	2026-08-18 14:00	2026-08-18 14:00	SPXW	SPXW260818P07705000	put	7705.0000	2026-08-18	10.0000	9.9000	10.3000	7695.8600	120000.00	0.00	120000.00	120	26	64700	1159	55.8239861949957	0.0871028701428072	0.0838360401285886	false	false	false	true	false
480a58d4-b77e-4a36-98ca-e10f90b11240	2026-08-18 14:02	2026-08-18 14:02	2026-08-18 14:02	SPXW	SPXW260818C07680000	call	7680.0000	2026-08-18	18.7000	18.6000	18.9000	7696.8200	187000.00	164560.00	22440.00	100	12	4603	119	38.6806722689076	0.160927566166048	0.160927566166048	false	false	false	true	false
4b92ead8-8a92-4fec-b3a3-8686e73afcdb	2026-08-18 14:05	2026-08-18 14:05	2026-08-18 14:05	SPXW	SPXW260820C07725000	call	7725.0000	2026-08-20	12.4000	12.4000	12.5000	7696.5700	116560.00	0.00	116560.00	94	7	507	144	3.52083333333333	0.102810849388785	0.102810849388785	false	false	false	true	false
9587472f-47f8-4f91-aac2-850ae047bf27	2026-08-18 14:06	2026-08-18 14:05	2026-08-18 14:05	SPXW	SPXW260818P07700000	put	7700.0000	2026-08-18	7.0600	6.7000	7.2000	7695.7200	247150.00	245050.00	0.00	350	49	128003	3928	32.5873217922607	0.0966239901213019	0.106080825114612	false	false	false	true	false
2932bbff-be86-42ce-aa6b-342c4216533f	2026-08-18 14:10	2026-08-18 14:09	2026-08-18 14:09	SPXW	SPXW260828P07600000	put	7600.0000	2026-08-28	29.1000	28.9000	29.2000	7694.4600	582000.00	87300.00	494700.00	200	15	807	1157	0.697493517718237	0.135613714998167	0.135613714998167	false	false	false	true	false
f1c0847c-123a-4752-9997-873ff78e1178	2026-08-18 14:10	2026-08-18 14:10	2026-08-18 14:10	SPXW	SPXW260818P07700000	put	7700.0000	2026-08-18	7.3000	7.1000	7.4000	7694.7400	150380.00	35770.00	114610.00	206	26	129802	3928	33.0453156822811	0.0946754425099443	0.0946754425099443	false	false	false	true	false
b4112b92-77c1-44dc-a0f5-258872f4fedd	2026-08-18 14:10	2026-08-18 14:10	2026-08-18 14:10	SPXW	SPXW260818P07700000	put	7700.0000	2026-08-18	7.4000	7.4000	7.5000	7694.7000	189460.00	1500.00	187960.00	256	6	130161	3928	33.1367107942974	0.0991114358963572	0.0965768848903304	false	false	false	true	false
fab0da46-9e0e-4ba0-96be-bdbf97da9c22	2026-08-18 14:13	2026-08-18 14:13	2026-08-18 14:13	SPXW	SPXW260824P07715000	put	7715.0000	2026-08-24	42.7200	42.7000	43.0000	7698.7500	153780.00	0.00	153780.00	36	7	451	160	2.81875	0.0931136727480598	0.0931136727480598	true	false	false	true	false
f34f14a3-fb84-4f18-9fce-1ca97408a9df	2026-08-18 14:13	2026-08-18 14:13	2026-08-18 14:13	SPXW	SPXW260824P07715000	put	7715.0000	2026-08-24	42.9000	42.8000	43.2000	7698.7500	540480.00	0.00	540480.00	126	5	415	160	2.59375	0.0931628123939264	0.093369400938218	true	false	false	true	false
67883cd7-7136-441e-9122-ae6cf1691ee8	2026-08-18 14:14	2026-08-18 14:14	2026-08-18 14:14	SPXW	SPXW260828C07700000	call	7700.0000	2026-08-28	63.1000	63.1000	63.2000	7699.7900	435390.00	0.00	435390.00	69	5	464	2395	0.193736951983299	0.116352694362381	0.116352694362381	false	false	false	true	false
2af7550d-dd2f-4bd1-9cf4-7f7ee077e63c	2026-08-18 14:14	2026-08-18 14:14	2026-08-18 14:14	SPXW	SPXW260828C07700000	call	7700.0000	2026-08-28	63.2000	62.9000	63.2000	7699.7900	113760.00	113760.00	0.00	18	5	482	2395	0.20125260960334	0.116549752648947	0.116549752648947	false	false	false	true	false
19d7fa44-8277-4348-a3bf-0e52e616ca76	2026-08-18 14:15	2026-08-18 14:14	2026-08-18 14:14	SPXW	SPXW260828C07700000	call	7700.0000	2026-08-28	63.5000	63.3000	63.5000	7700.2300	241300.00	241300.00	0.00	38	8	533	2395	0.222546972860125	0.116685453265503	0.116685453265503	false	false	false	true	false
8d2d3b2a-a29a-46a1-9e0b-a4480a749935	2026-08-18 14:17	2026-08-18 14:17	2026-08-18 14:17	SPXW	SPXW260818P07700000	put	7700.0000	2026-08-18	3.8300	3.8000	4.0000	7701.2100	134410.00	400.00	134010.00	351	66	133874	3928	34.0819755600815	0.107228440933827	0.102542804977383	false	false	false	true	false
4c28ddb1-ae1a-42aa-b858-95301c3605fc	2026-08-18 14:22	2026-08-18 14:22	2026-08-18 14:22	SPXW	SPXW260818C07705000	call	7705.0000	2026-08-18	5.0000	5.0000	5.1000	7705.2500	100550.00	2550.00	98000.00	201	22	81164	174	466.459770114943	0.115539817106639	0.115539817106639	false	false	false	true	false
4c88f60c-0c3b-4c10-97cd-832cee759603	2026-08-18 14:22	2026-08-18 14:22	2026-08-18 14:22	SPXW	SPXW260818C07705000	call	7705.0000	2026-08-18	5.0000	5.0000	5.1000	7704.9400	128500.00	0.00	128500.00	257	6	81530	174	468.563218390805	0.11929434379278	0.11929434379278	false	false	false	true	false
3f45b90e-63bf-4c27-ac6f-bdb7945093ab	2026-08-18 14:23	2026-08-18 14:23	2026-08-18 14:23	SPXW	SPXW260828C07825000	call	7825.0000	2026-08-28	13.4000	13.2000	13.5000	7702.8300	201000.00	83080.00	117920.00	150	14	812	1052	0.771863117870722	0.100617655508581	0.100617655508581	false	false	false	true	false
0aab9dd8-da4d-45c0-8a23-e5413473f04a	2026-08-18 14:23	2026-08-18 14:23	2026-08-18 14:23	SPXW	SPXW260828C07825000	call	7825.0000	2026-08-28	13.4000	13.2000	13.5000	7702.5000	134000.00	131320.00	2680.00	100	9	912	1052	0.866920152091255	0.100799203829406	0.100799203829406	false	false	false	true	false
a88e5bf2-98f1-48c1-b953-593e99bc620f	2026-08-18 14:37	2026-08-18 14:37	2026-08-18 14:37	SPXW	SPXW260818P07700000	put	7700.0000	2026-08-18	2.4500	2.4500	2.5000	7703.3300	108540.00	250.00	108290.00	443	25	149233	3928	37.9921079429735	0.101302839623881	0.101302839623881	false	false	false	true	false
b660fe6b-0d10-4c3d-95fc-7df8be9c8850	2026-08-18 14:49	2026-08-18 14:49	2026-08-18 14:49	SPXW	SPXW260818P07705000	put	7705.0000	2026-08-18	5.9000	5.7000	6.0000	7700.4200	118000.00	71390.00	46610.00	200	26	77230	1159	66.6350301984469	0.0874679321594298	0.0874679321594298	false	false	false	true	false
0008bd70-fc4a-4c2a-98b6-f72531dac70d	2026-08-18 14:55	2026-08-18 14:55	2026-08-18 14:55	SPXW	SPXW260828C07700000	call	7700.0000	2026-08-28	61.5400	61.3000	62.0000	7697.5600	861520.00	0.00	861520.00	140	23	682	2395	0.284759916492693	0.116083966165007	0.115493100419362	false	false	false	true	false