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.

375,978 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts375,978 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

af3ab584-1477-4602-b874-fd28dc4971d5	2026-08-21 11:40	2026-08-21 11:40	2026-08-21 11:40	SPXW	SPXW260821C07680000	call	7680.0000	2026-08-21	13.7300	13.6000	14.0000	7689.1800	306120.00	304740.00	1380.00	223	32	55290	1741	31.7576105686387	0.12051494880639	0.122143483442077	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-21T15:55:19.311132Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
7bf6e77f-cf95-4d5c-89ea-97e6a16a19ae	2026-08-21 11:41	2026-08-21 11:41	2026-08-21 11:41	SPXW	SPXW260821C07665000	call	7665.0000	2026-08-21	28.6000	28.6000	28.7000	7692.7300	114400.00	0.00	114400.00	40	8	22207	965	23.0124352331606	0.116808759752999	0.116808759752999	false	false	false	true	false
35618ed5-9ea0-47d2-94d6-b87755b5e9d2	2026-08-21 11:42	2026-08-21 11:42	2026-08-21 11:42	SPXW	SPXW260825C07725000	call	7725.0000	2026-08-25	11.7000	11.5000	11.8000	7692.3500	122850.00	38610.00	84240.00	105	13	738	402	1.83582089552239	0.0731610568785128	0.0731610568785128	false	false	false	true	false
2558ed02-9b88-4b25-81c8-63b6f4b49f49	2026-08-21 11:44	2026-08-21 11:44	2026-08-21 11:44	SPXW	SPXW260824P07690000	put	7690.0000	2026-08-24	19.2000	19.1000	19.3000	7690.9500	178560.00	103680.00	0.00	93	10	738	1008	0.732142857142857	0.0750972927542978	0.0749099368037439	false	false	false	true	false
0d8f546a-75fe-4316-a014-d3d99fc46001	2026-08-21 11:44	2026-08-21 11:44	2026-08-21 11:44	SPXW	SPXW260825P07625000	put	7625.0000	2026-08-25	8.3000	8.1000	8.4000	7690.9300	124500.00	51460.00	73040.00	150	14	353	1085	0.325345622119816	0.0985285033523773	0.0985285033523773	false	false	false	true	false
bbbd3160-d230-4797-88b7-3841bd0fbed4	2026-08-21 11:44	2026-08-21 11:44	2026-08-21 11:44	SPXW	SPXW260827P07690000	put	7690.0000	2026-08-27	39.1000	39.0000	39.3000	7691.9100	383180.00	336260.00	46920.00	98	10	113	213	0.530516431924883	0.107744007584187	0.107744007584187	false	false	false	true	false
6ed1bee7-76de-4003-bea5-da0f212d8f94	2026-08-21 11:45	2026-08-21 11:45	2026-08-21 11:45	SPXW	SPXW260821C07685000	call	7685.0000	2026-08-21	12.2000	12.0000	12.3000	7691.8100	141520.00	28060.00	113460.00	116	15	44356	2194	20.2169553327256	0.1223332288235	0.1223332288235	false	false	false	true	false
3a9a989f-0074-412d-9776-b091770ffa87	2026-08-21 11:52	2026-08-21 11:52	2026-08-21 11:52	SPXW	SPXW260821P07720000	put	7720.0000	2026-08-21	26.0000	25.9000	26.0000	7695.2400	143000.00	143000.00	0.00	55	6	876	871	1.00574052812859	0.129420927319807	0.129420927319807	false	false	false	true	false
c6262b40-5f35-4f1a-95cb-6aec4070ca1d	2026-08-21 11:52	2026-08-21 11:52	2026-08-21 11:52	SPXW	SPXW260821C07675000	call	7675.0000	2026-08-21	22.2500	21.9000	22.3000	7695.0600	222500.00	222500.00	0.00	100	16	43374	1284	33.7803738317757	0.12649822824772	0.131178315352781	false	false	false	true	false
a1b80a1d-b8a2-4aa5-89c8-0c4aac3bbd62	2026-08-21 11:53	2026-08-21 11:52	2026-08-21 11:52	SPXW	SPXW260821C07700000	call	7700.0000	2026-08-21	5.7900	5.6000	5.8000	7695.6900	110070.00	110070.00	0.00	190	41	67874	8404	8.07639219419324	0.114209502801027	0.11574723836848	true	false	false	true	false
4a7eeb73-c485-4902-adf1-009a02b34c9b	2026-08-21 11:53	2026-08-21 11:53	2026-08-21 11:53	SPXW	SPXW260825C07750000	call	7750.0000	2026-08-25	6.5000	6.3000	6.6000	7696.1100	126100.00	31200.00	94900.00	194	14	1135	825	1.37575757575758	0.0734947193505015	0.0734947193505015	false	false	false	true	false
3c45e05f-19d2-4fb0-9a43-ea60d3a7449a	2026-08-21 11:53	2026-08-21 11:53	2026-08-21 11:53	SPXW	SPXW260825P07675000	put	7675.0000	2026-08-25	18.1900	18.0000	18.3000	7695.3300	236530.00	103670.00	132860.00	130	13	1113	553	2.0126582278481	0.0882603525170837	0.0885895114474987	false	false	false	true	false
d5558764-a217-45cf-9177-882f674c191e	2026-08-21 11:53	2026-08-21 11:53	2026-08-21 11:53	SPXW	SPXW260821C07700000	call	7700.0000	2026-08-21	5.5200	5.5000	5.7000	7695.5000	138030.00	0.00	134670.00	250	44	68961	8404	8.20573536411233	0.1140228050984	0.112478342550666	true	false	false	true	false
05a3f118-ab80-4502-bbe5-11099f21fc7e	2026-08-21 11:54	2026-08-21 11:54	2026-08-21 11:54	SPXW	SPXW260821C07685000	call	7685.0000	2026-08-21	15.2900	15.0000	15.4000	7696.8400	105510.00	59660.00	45850.00	69	36	46595	2194	21.2374658158614	0.11742701720277	0.119240902219711	false	false	false	true	false
ade73382-853b-4eaf-b3f6-e44b98e9d557	2026-08-21 11:58	2026-08-21 11:58	2026-08-21 11:58	SPXW	SPXW260821P07685000	put	7685.0000	2026-08-21	5.0000	4.9000	5.2000	7691.2100	101020.00	10000.00	90000.00	202	38	17063	4003	4.26255308518611	0.119598593401396	0.117996816342352	false	false	false	true	false
2816fa4f-c4b4-458c-ba50-2c556f5db53a	2026-08-21 12:00	2026-08-21 11:59	2026-08-21 11:59	SPXW	SPXW260821P07730000	put	7730.0000	2026-08-21	39.7000	39.4000	39.8000	7690.6400	103220.00	103220.00	0.00	26	5	473	885	0.534463276836158	0.143291572626812	0.143291572626812	true	false	false	true	false
06c370d9-c2ff-4afa-b604-fc11b69ef083	2026-08-21 12:02	2026-08-21 12:02	2026-08-21 12:02	SPXW	SPXW260821P07695000	put	7695.0000	2026-08-21	11.0000	10.9000	11.0000	7688.5600	105600.00	105600.00	0.00	96	18	8757	1764	4.96428571428571	0.113707673886449	0.113707673886449	false	false	false	true	false
615c1e41-c627-4de6-9288-9bdd32ccf42e	2026-08-21 12:03	2026-08-21 12:03	2026-08-21 12:03	SPXW	SPXW260821P07685000	put	7685.0000	2026-08-21	6.3700	6.4000	6.5000	7687.4400	128070.00	650.00	127420.00	201	39	20037	4003	5.00549587809143	0.118570174127909	0.115473488958686	false	false	false	true	false
8385a099-5e64-48ce-a83c-ca7e0b03d141	2026-08-21 12:15	2026-08-21 12:15	2026-08-21 12:15	SPXW	SPXW260821C07690000	call	7690.0000	2026-08-21	4.1900	4.1000	4.4000	7680.9000	148250.00	40850.00	103530.00	354	50	63854	2301	27.7505432420687	0.124381708864087	0.122631337348467	false	false	false	true	false
8c99f22a-b486-4ee2-b2d3-c5fa143976d6	2026-08-21 12:29	2026-08-21 12:29	2026-08-21 12:29	SPXW	SPXW260821P07680000	put	7680.0000	2026-08-21	6.0300	5.8000	6.1000	7683.4100	120530.00	120530.00	0.00	200	42	41182	1521	27.0756081525312	0.122696066959001	0.126009661862933	false	false	false	true	false
049883fe-f32c-47e6-a6ae-5a87628e3f65	2026-08-21 12:29	2026-08-21 12:29	2026-08-21 12:29	SPXW	SPXW260821C07680000	call	7680.0000	2026-08-21	9.2900	9.2000	9.5000	7683.1800	117940.00	1880.00	105780.00	127	37	67502	1741	38.771970132108	0.124614304656692	0.12295824996323	false	false	false	true	false
41b6a350-6a3c-4d76-98c1-65c83d6f1994	2026-08-21 12:31	2026-08-21 12:30	2026-08-21 12:30	SPXW	SPXW260824P07670000	put	7670.0000	2026-08-24	14.8900	14.6000	15.0000	7682.2000	148930.00	89330.00	59600.00	100	20	2545	940	2.70744680851064	0.076758157418589	0.0771320470038926	false	false	false	true	false
ec69cc48-e57e-4294-83e3-234c5830060d	2026-08-21 12:34	2026-08-21 12:33	2026-08-21 12:33	SPXW	SPXW260821P07720000	put	7720.0000	2026-08-21	39.2000	39.2000	39.6000	7681.3300	160720.00	0.00	160720.00	41	7	1467	871	1.68427095292767	0.162854054518623	0.162854054518623	false	false	false	true	false
395631e6-62b0-49c5-8891-004393c09247	2026-08-21 12:35	2026-08-21 12:34	2026-08-21 12:34	SPXW	SPXW260825P07685000	put	7685.0000	2026-08-25	28.4100	28.3000	28.7000	7679.6900	184660.00	0.00	184660.00	65	17	433	144	3.00694444444444	0.0855185959623906	0.0848947988368212	false	false	false	true	false
fda65599-259c-4dcb-9a02-2b5c05b18e24	2026-08-21 12:36	2026-08-21 12:36	2026-08-21 12:36	SPXW	SPXW260824P07670000	put	7670.0000	2026-08-24	15.3000	15.2000	15.5000	7680.7100	153000.00	48960.00	104040.00	100	11	2706	940	2.87872340425532	0.0764218625639838	0.0764218625639838	false	false	false	true	false
0d3fe971-63b7-4726-bcd9-f294a05f83fa	2026-08-21 12:51	2026-08-21 12:50	2026-08-21 12:50	SPXW	SPXW260821P07720000	put	7720.0000	2026-08-21	42.7000	42.6000	43.2000	7677.4700	196420.00	0.00	196420.00	46	5	1606	871	1.84385763490241	0.155823129662675	0.155823129662675	false	false	false	true	false
0bd5284c-58d6-4335-b1a8-70ec13ed3002	2026-08-21 13:00	2026-08-21 13:00	2026-08-21 13:00	SPXW	SPXW260831P07670000	put	7670.0000	2026-08-31	46.4000	46.0000	46.5000	7683.1900	116010.00	116010.00	0.00	25	7	172	301	0.571428571428571	0.11123028206296	0.11123028206296	false	false	false	true	false
649cccec-0911-4e9d-bcef-830f62d1fda3	2026-08-21 13:15	2026-08-21 13:15	2026-08-21 13:15	SPXW	SPXW260821C07660000	call	7660.0000	2026-08-21	21.6000	21.5000	21.7000	7680.5800	103680.00	0.00	10800.00	48	5	15142	1554	9.74388674388674	0.125530263754537	0.125530263754537	false	false	false	true	false
6e17790f-1d09-4a97-9d24-51e234df00b8	2026-08-21 13:23	2026-08-21 13:22	2026-08-21 13:22	SPXW	SPXW260824P07680000	put	7680.0000	2026-08-24	20.2000	20.1000	20.5000	7676.3200	111100.00	0.00	111100.00	55	14	2276	503	4.52485089463221	0.0704188251066013	0.0704188251066013	false	false	false	true	false
9c51826a-f497-4d27-85a1-31dcf9a5013b	2026-08-21 13:23	2026-08-21 13:23	2026-08-21 13:23	SPXW	SPXW260821P07720000	put	7720.0000	2026-08-21	43.3000	43.0000	43.3000	7676.8100	445990.00	445990.00	0.00	103	9	2083	871	2.39150401836969	0.164055953628622	0.164055953628622	false	false	false	true	false
39133b00-1391-48fc-83e1-1965f20e0888	2026-08-21 13:25	2026-08-21 13:25	2026-08-21 13:25	SPXW	SPXW260821P07675000	put	7675.0000	2026-08-21	5.0000	4.9000	5.1000	7676.6800	150500.00	0.00	0.00	301	5	58244	2161	26.9523368810736	0.11113133310366	0.11113133310366	false	false	false	true	false
9f6d7f7d-7450-4891-bb56-d78862e1f66c	2026-08-21 13:26	2026-08-21 13:26	2026-08-21 13:26	SPXW	SPXW260821P07690000	put	7690.0000	2026-08-21	15.3600	15.0000	15.5000	7675.9000	155170.00	155170.00	0.00	101	16	22743	1257	18.0930787589499	0.107369274215528	0.116413875018884	true	false	false	true	false
2bab847e-8856-4cf1-ba84-71f8330d4a03	2026-08-21 13:26	2026-08-21 13:26	2026-08-21 13:26	SPXW	SPXW260824P07675000	put	7675.0000	2026-08-24	18.2100	18.1000	18.4000	7675.9600	103810.00	0.00	103810.00	57	13	3628	1094	3.31627056672761	0.0718158574352487	0.0714547592485387	true	false	false	true	false
6d506eb1-2922-4bb5-9e67-70068e1fb800	2026-08-21 13:28	2026-08-21 13:28	2026-08-21 13:28	SPXW	SPXW260821C07645000	call	7645.0000	2026-08-21	34.2300	33.9000	34.3000	7678.0200	102690.00	102690.00	0.00	30	8	2838	425	6.67764705882353	0.188298445362719	0.188298445362719	false	false	false	true	false
fd48e80e-24b3-47b3-956d-047e94a343ab	2026-08-21 13:34	2026-08-21 13:34	2026-08-21 13:34	SPXW	SPXW260824P07675000	put	7675.0000	2026-08-24	18.5500	18.4000	18.6000	7674.9600	109450.00	55800.00	14800.00	59	13	4307	1094	3.93692870201097	0.0711813483480516	0.0708206344491615	false	false	false	true	false
59b1c921-c46e-4554-b039-4abd57960527	2026-08-21 13:35	2026-08-21 13:35	2026-08-21 13:35	SPXW	SPXW260824P07675000	put	7675.0000	2026-08-24	19.1000	19.0000	19.3000	7674.1300	116510.00	0.00	116510.00	61	6	4399	1094	4.02102376599634	0.0715384094066963	0.0715384094066963	false	false	false	true	false
8f7f99df-2929-434a-b2d3-3976fb5b2313	2026-08-21 13:35	2026-08-21 13:35	2026-08-21 13:35	SPXW	SPXW260904P07670000	put	7670.0000	2026-09-04	63.9200	63.5000	64.0000	7674.3100	204530.00	204530.00	0.00	32	9	615	223	2.75784753363229	0.118989105384718	0.118989105384718	false	false	false	true	false
1edc554a-85df-49a1-bd8f-0f39d45a4cb7	2026-08-21 13:36	2026-08-21 13:36	2026-08-21 13:36	SPXW	SPXW260821P07720000	put	7720.0000	2026-08-21	45.6000	45.0000	45.9000	7673.9100	419520.00	4560.00	414960.00	92	18	2506	871	2.87715269804822	0.177116445477839	0.177116445477839	false	false	false	true	false
f9893b6d-a217-491b-bf05-43f7dbef027d	2026-08-21 13:41	2026-08-21 13:41	2026-08-21 13:41	SPXW	SPXW260821P07690000	put	7690.0000	2026-08-21	15.6500	15.6000	15.9000	7674.5800	189390.00	0.00	189390.00	121	14	23610	1257	18.7828162291169	0.0907695552218087	0.0907695552218087	false	false	false	true	false
fea6a8e5-1208-4656-8f8c-34d0e1e86ac2	2026-08-21 13:46	2026-08-21 13:46	2026-08-21 13:46	SPXW	SPXW260824P07665000	put	7665.0000	2026-08-24	14.1000	14.0000	14.3000	7675.1500	212910.00	169200.00	43710.00	151	16	2861	615	4.6520325203252	0.0711725065947976	0.0711725065947976	false	false	false	true	false
889a3a0b-69c6-4a9f-b37c-7fee0ec987a2	2026-08-21 13:48	2026-08-21 13:48	2026-08-21 13:48	SPXW	SPXW260821P07690000	put	7690.0000	2026-08-21	14.1100	14.0000	14.4000	7676.4000	141090.00	0.00	141090.00	100	13	24034	1257	19.1201272871917	0.0943230413665182	0.0943230413665182	false	false	false	true	false
31cbbb1e-f69a-47a3-84bd-a64a2aacda40	2026-08-21 14:07	2026-08-21 14:07	2026-08-21 14:07	SPXW	SPXW260824P07675000	put	7675.0000	2026-08-24	19.7000	19.5000	19.8000	7650.0000	120200.00	86710.00	33490.00	61	13	5171	1094	4.72669104204753	0.0703175986117494	0.0703175986117494	true	false	false	true	false
6706d9e9-11a8-47aa-aa43-12a202d4b48b	2026-08-21 14:07	2026-08-21 14:07	2026-08-21 14:07	SPXW	SPXW260821P07720000	put	7720.0000	2026-08-21	47.5000	47.5000	47.9000	7650.0000	166250.00	0.00	166250.00	35	11	2904	871	3.33409873708381	0.189548222327474	0.189548222327474	false	false	false	true	false
dcb6d0c4-abe9-4844-ad19-bff0b7629566	2026-08-21 14:07	2026-08-21 14:07	2026-08-21 14:07	SPXW	SPXW260821P07720000	put	7720.0000	2026-08-21	47.5000	47.0000	47.7000	7650.0000	308750.00	9500.00	299250.00	65	16	2969	871	3.40872560275545	0.198554130085192	0.166264769230878	false	false	false	true	false
d84595bc-edf6-44f7-a658-0c7d87520f18	2026-08-21 14:08	2026-08-21 14:08	2026-08-21 14:08	SPXW	SPXW260904P07595000	put	7595.0000	2026-09-04	40.5000	40.2000	40.6000	7650.0000	206550.00	206550.00	0.00	51	5	158	118	1.33898305084746	0.128988706246745	0.128988706246745	false	false	false	true	false
673e488c-6818-40d5-ab76-b1ea60f26df5	2026-08-21 14:10	2026-08-21 14:09	2026-08-21 14:09	SPXW	SPXW260824P07660000	put	7660.0000	2026-08-24	13.6000	13.4000	13.7000	7650.0000	136000.00	59840.00	76160.00	100	15	2534	403	6.287841191067	0.0727977986736608	0.0727977986736608	false	false	false	true	false
f760b08f-823c-4db1-9c2f-dd1e3e45f5ef	2026-08-21 14:10	2026-08-21 14:10	2026-08-21 14:10	SPXW	SPXW260828C07700000	call	7700.0000	2026-08-28	35.5400	35.3000	35.5000	7650.0000	3554000.00	0.00	0.00	1000	9	2446	3085	0.792868719611021	0.108171630466926	0.108140979280592	false	false	false	true	false
3ed463ae-8a0e-4f5e-918f-368c5bda03f1	2026-08-21 14:13	2026-08-21 14:12	2026-08-21 14:12	SPXW	SPXW260824P07675000	put	7675.0000	2026-08-24	18.3400	18.2000	18.6000	7650.0000	111880.00	0.00	111880.00	61	17	5522	1094	5.04753199268739	0.0684175094319631	0.0684175094319631	false	false	false	true	false
bd51f8c0-5df5-4d64-9a24-343664f1bdbe	2026-08-21 14:18	2026-08-21 14:18	2026-08-21 14:18	SPXW	SPXW260824P07660000	put	7660.0000	2026-08-24	13.3000	13.2000	13.5000	7650.0000	184870.00	139650.00	45220.00	139	19	2720	403	6.74937965260546	0.0716956511156563	0.0716956511156563	false	false	false	true	false
9ac811e9-0484-4f7d-9284-567f3ab1f497	2026-08-21 14:21	2026-08-21 14:21	2026-08-21 14:21	SPXW	SPXW260821C07675000	call	7675.0000	2026-08-21	4.0100	3.9000	4.1500	7655.0000	120250.00	119850.00	0.00	300	53	70397	1284	54.8263239875389	0.100961762534665	0.103354195174747	false	false	false	true	false