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.

523,327 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts523,327 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

570ff570-cd87-4620-9305-389edd72df76	2026-08-28 12:18	2026-08-28 12:18	2026-08-28 12:18	SPXW	SPXW260828C07730000	call	7730.0000	2026-08-28	6.7000	6.7000	6.8000	7718.6300	134000.00	0.00	134000.00	200	47	29551	4131	7.15347373517308	0.181148712105966	0.181148712105966	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-28T16:25:17.992358Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
d9946897-d487-4969-abc8-ffb8340bba28	2026-08-28 12:20	2026-08-28 12:20	2026-08-28 12:20	SPXW	SPXW260828P07720000	put	7720.0000	2026-08-28	12.3100	12.3000	12.5000	7719.5000	112030.00	0.00	99630.00	91	24	62671	2086	30.0436241610738	0.193810571907855	0.193810571907855	false	false	false	true	false
090f35c1-bd9d-4203-991f-51d49d1dff14	2026-08-28 12:20	2026-08-28 12:20	2026-08-28 12:20	SPXW	SPXW260828C07700000	call	7700.0000	2026-08-28	26.2000	26.1000	26.4000	7720.9000	120520.00	55020.00	62880.00	46	10	4810	4549	1.0573752473071	0.208213906636416	0.208213906636416	false	false	false	true	false
2406a53a-ffbe-4c35-9543-7e9cfad846ec	2026-08-28 12:21	2026-08-28 12:21	2026-08-28 12:21	SPXW	SPXW260828C07730000	call	7730.0000	2026-08-28	6.2100	6.2000	6.4000	7715.8400	101860.00	8820.00	93040.00	164	15	31041	4131	7.51416122004357	0.189796897598025	0.191571725485536	false	false	false	true	false
369e1c19-98d3-4b82-b5f2-c7df39f4d050	2026-08-28 12:23	2026-08-28 12:23	2026-08-28 12:23	SPXW	SPXW260828P07710000	put	7710.0000	2026-08-28	11.6000	11.5000	11.7000	7714.5500	174000.00	33640.00	132240.00	150	37	41315	1732	23.8539260969977	0.221115729623089	0.221115729623089	false	false	false	true	false
bc491fe9-b991-422b-a2fe-e172d38f3d7e	2026-08-28 12:24	2026-08-28 12:24	2026-08-28 12:24	SPXW	SPXW260828P07710000	put	7710.0000	2026-08-28	12.9200	12.8000	13.2000	7711.9500	198970.00	91710.00	104660.00	154	33	42064	1732	24.2863741339492	0.224769622159719	0.227992344383795	false	false	false	true	false
9db7339e-21c1-4ee5-aebc-b01a698c7c9c	2026-08-28 12:24	2026-08-28 12:24	2026-08-28 12:24	SPXW	SPXW260828C07700000	call	7700.0000	2026-08-28	20.3800	20.1000	20.5000	7710.3300	105970.00	61130.00	44840.00	52	17	5032	4549	1.1061771817982	0.230800441142392	0.234147658202779	false	false	false	true	false
7ce97af9-3d7f-4e27-bdd0-1a66856cf476	2026-08-28 12:24	2026-08-28 12:24	2026-08-28 12:24	SPXW	SPXW260828P07715000	put	7715.0000	2026-08-28	16.2200	15.9000	16.3000	7710.3300	100550.00	100550.00	0.00	62	12	47768	1492	32.0160857908847	0.219852351148521	0.223088473721801	false	false	false	true	false
3a98d66b-6b8c-47a1-b8ad-ad5bee17832c	2026-08-28 12:24	2026-08-28 12:24	2026-08-28 12:24	SPXW	SPXW260828C07725000	call	7725.0000	2026-08-28	6.8100	6.8000	7.1000	7710.1200	158730.00	0.00	158030.00	233	22	18781	2946	6.37508486082824	0.209637859030131	0.209637859030131	false	false	false	true	false
ef630f3f-2efd-443a-8f98-d87b28dc68a8	2026-08-28 12:24	2026-08-28 12:24	2026-08-28 12:24	SPXW	SPXW260828C07730000	call	7730.0000	2026-08-28	5.2000	5.2000	5.3000	7709.8900	104000.00	0.00	104000.00	200	12	32696	4131	7.91479060760107	0.204970268136931	0.204970268136931	false	false	false	true	false
6186419b-78e3-453d-b21b-cc2f07cba357	2026-08-28 12:26	2026-08-28 12:26	2026-08-28 12:26	SPXW	SPXW260828P07700000	put	7700.0000	2026-08-28	7.5000	7.4000	7.5000	7715.2300	123000.00	123000.00	0.00	164	40	66976	7472	8.96359743040685	0.223276506978504	0.223276506978504	false	false	false	true	false
0b0e32a6-a31f-4750-8a19-338bccd6ae7c	2026-08-28 12:27	2026-08-28 12:27	2026-08-28 12:27	SPXW	SPXW260828P07715000	put	7715.0000	2026-08-28	12.6400	12.6000	12.8000	7714.1600	116320.00	0.00	116320.00	92	20	48844	1492	32.7372654155496	0.199077726735778	0.197544972854036	true	false	false	true	false
21c56d66-cb47-4fa4-9722-9a513f88d5be	2026-08-28 12:27	2026-08-28 12:27	2026-08-28 12:27	SPXW	SPXW260831C07730000	call	7730.0000	2026-08-31	16.5000	16.4000	16.7000	7714.7600	141900.00	79200.00	62700.00	86	7	3985	687	5.80058224163028	0.0799497545836628	0.0799497545836628	false	false	false	true	false
ca80c318-2644-4e06-8207-520adc1b5d23	2026-08-28 12:31	2026-08-28 12:31	2026-08-28 12:31	SPXW	SPXW260828C07730000	call	7730.0000	2026-08-28	6.6900	6.5000	6.7000	7718.7600	113100.00	104520.00	6600.00	169	11	35177	4131	8.51537158073106	0.184142850822393	0.184142850822393	false	false	false	true	false
fa6e3551-ea43-4ecf-9775-6bc79af5a286	2026-08-28 12:31	2026-08-28 12:31	2026-08-28 12:31	SPXW	SPXW260828P07745000	put	7745.0000	2026-08-28	28.0000	28.0000	28.1000	7719.3900	128800.00	0.00	128800.00	46	12	37041	412	89.9053398058252	0.175555540635451	0.175555540635451	false	false	false	true	false
1d3e8a0d-fc19-48d8-ba94-64b10f40e1ec	2026-08-28 12:31	2026-08-28 12:31	2026-08-28 12:31	SPXW	SPXW260925P07740000	put	7740.0000	2026-09-25	101.7400	100.6000	102.4000	7717.0900	610460.00	101600.00	508860.00	60	8	175	211	0.829383886255924	0.119317384278276	0.119200096076788	false	false	false	true	false
be613536-2d64-412d-bd39-75ae2eb0d147	2026-08-28 12:32	2026-08-28 12:32	2026-08-28 12:32	SPXW	SPXW260828C07700000	call	7700.0000	2026-08-28	26.3100	26.2000	26.7000	7721.4200	131570.00	31560.00	100010.00	50	16	5632	4549	1.23807430204441	0.210606657939501	0.208556282241119	false	false	false	true	false
57576fb9-de21-4a3a-99c3-8a4bf16093c9	2026-08-28 12:32	2026-08-28 12:32	2026-08-28 12:32	SPXW	SPXW260828C07720000	call	7720.0000	2026-08-28	12.0100	11.9000	12.1000	7721.4700	121260.00	81760.00	11900.00	101	34	16199	1978	8.18958543983822	0.181274033654238	0.18454872424692	true	false	false	true	false
cad41143-ce80-470a-864a-3a35b3d63275	2026-08-28 12:32	2026-08-28 12:32	2026-08-28 12:32	SPXW	SPXW260828C07700000	call	7700.0000	2026-08-28	26.6100	26.5000	26.9000	7722.2900	101130.00	2660.00	98470.00	38	10	5683	4549	1.24928555726533	0.203195139113684	0.203195139113684	false	false	false	true	false
8e89a4e6-6fdf-48f6-ab59-38da219445f3	2026-08-28 12:36	2026-08-28 12:36	2026-08-28 12:36	SPXW	SPXW260831C07710000	call	7710.0000	2026-08-31	29.5000	29.4000	29.5000	7720.5500	203550.00	203550.00	0.00	69	12	599	907	0.660418963616318	0.0803730331033318	0.0803730331033318	false	false	false	true	false
da317e22-8478-49c0-a627-9f9f36856e47	2026-08-28 12:38	2026-08-28 12:38	2026-08-28 12:38	SPXW	SPXW260828C07730000	call	7730.0000	2026-08-28	7.1000	7.0000	7.2000	7722.5300	142710.00	2130.00	110760.00	201	33	38339	4131	9.28080367949649	0.171621445803149	0.171621445803149	false	false	false	true	false
8de88e2c-2693-49bb-9778-c8a407803ba6	2026-08-28 12:41	2026-08-28 12:40	2026-08-28 12:40	SPXW	SPXW260828C07730000	call	7730.0000	2026-08-28	5.2000	5.1000	5.3000	7716.6800	105030.00	69680.00	510.00	202	17	39437	4131	9.54659888646817	0.174039279756715	0.175235208266494	false	false	false	true	false
dcc2bf16-97af-43cd-8fbb-b1df4342b3fd	2026-08-28 12:41	2026-08-28 12:41	2026-08-28 12:41	SPXW	SPXW260828P07745000	put	7745.0000	2026-08-28	30.7000	30.6000	30.8000	7716.7000	144280.00	0.00	144280.00	47	8	37527	412	91.0849514563107	0.192104381053512	0.189396475929301	false	false	false	true	false
60ca7825-c820-4342-bf90-8f8ceeace0ef	2026-08-28 12:42	2026-08-28 12:42	2026-08-28 12:42	SPXW	SPXW260828C07700000	call	7700.0000	2026-08-28	21.7000	21.7000	21.8000	7716.3100	108500.00	0.00	108500.00	50	14	6126	4549	1.34666959771378	0.196352541202205	0.196352541202205	false	false	false	true	false
ca136d80-998a-4e64-8982-47f66d0609f4	2026-08-28 12:43	2026-08-28 12:42	2026-08-28 12:42	SPXW	SPXW260828P07745000	put	7745.0000	2026-08-28	31.6800	31.6000	32.0000	7715.3700	148910.00	0.00	148910.00	47	11	37590	412	91.2378640776699	0.19215203646712	0.186391795260016	true	false	false	true	false
1f869106-6577-472c-8f00-6f2ce73de1c4	2026-08-28 12:43	2026-08-28 12:43	2026-08-28 12:43	SPXW	SPXW260828P07690000	put	7690.0000	2026-08-28	4.5000	4.5000	4.6000	7714.8500	198450.00	0.00	198450.00	441	53	40218	1809	22.2321724709784	0.22631142922513	0.22632096791323	false	false	false	true	false
f73dcc05-f7a7-46fd-8ef8-fcc541b27213	2026-08-28 12:43	2026-08-28 12:43	2026-08-28 12:43	SPXW	SPXW260828P07690000	put	7690.0000	2026-08-28	4.5000	4.4500	4.6000	7713.9200	211050.00	0.00	211050.00	469	13	40747	1809	22.5245992260918	0.221705750535939	0.221705750535939	false	false	false	true	false
9fca429d-4f26-4804-a397-d3a2ab254193	2026-08-28 12:44	2026-08-28 12:43	2026-08-28 12:43	SPXW	SPXW260828P07690000	put	7690.0000	2026-08-28	4.4000	4.3000	4.5000	7714.3200	145640.00	61600.00	84040.00	331	34	41706	1809	23.0547263681592	0.222468754102492	0.22165812648951	false	false	false	true	false
fa91d0d9-28d0-4b23-88b2-223a6e179fd2	2026-08-28 12:44	2026-08-28 12:44	2026-08-28 12:44	SPXW	SPXW260831C07730000	call	7730.0000	2026-08-31	15.3000	15.1000	15.4000	7714.1600	306000.00	16830.00	289170.00	200	8	4346	687	6.32605531295488	0.0764262959876805	0.0764262959876805	false	false	false	true	false
3c0aeb03-b73f-472c-995a-939b6b21b035	2026-08-28 12:44	2026-08-28 12:44	2026-08-28 12:44	SPXW	SPXW260828P07740000	put	7740.0000	2026-08-28	28.7000	28.6000	28.8000	7714.5300	129160.00	129160.00	0.00	45	5	57448	1348	42.6172106824926	0.201663404438333	0.204055737155441	false	false	false	true	false
bcc16337-5ff0-4eae-92af-f9247a57087c	2026-08-28 12:45	2026-08-28 12:45	2026-08-28 12:45	SPXW	SPXW260828C07700000	call	7700.0000	2026-08-28	24.9900	24.9000	25.3000	7720.1100	124940.00	0.00	124940.00	50	12	6281	4549	1.38074302044405	0.210893021201604	0.210893021201604	false	false	false	true	false
823fe4c0-d9ad-4708-9096-f7f822031d7a	2026-08-28 12:46	2026-08-28 12:46	2026-08-28 12:46	SPXW	SPXW260828C07730000	call	7730.0000	2026-08-28	6.9000	6.8000	6.9000	7722.5700	236670.00	236670.00	0.00	343	16	42091	4131	10.1890583393851	0.171506591059813	0.171506591059813	false	false	false	true	false
81d77813-cdd8-47aa-9cca-fed16503febb	2026-08-28 12:47	2026-08-28 12:47	2026-08-28 12:47	SPXW	SPXW260831C07730000	call	7730.0000	2026-08-31	17.7000	17.6000	17.9000	7721.4700	357540.00	261960.00	84960.00	202	26	4568	687	6.64919941775837	0.0737737526029613	0.0737737526029613	false	false	false	true	false
219bcd0c-aa9f-49d5-85f9-5aa4d78d295c	2026-08-28 12:47	2026-08-28 12:47	2026-08-28 12:47	SPXW	SPXW260828C07730000	call	7730.0000	2026-08-28	6.4000	6.3000	6.4000	7721.6600	202880.00	202880.00	0.00	317	16	42803	4131	10.361413701283	0.169161498975027	0.169168880557203	false	false	false	true	false
e22b2f31-232d-4667-847c-cf43518d2636	2026-08-28 12:48	2026-08-28 12:48	2026-08-28 12:48	SPXW	SPXW260831C07725000	call	7725.0000	2026-08-31	20.6000	20.4000	20.7000	7722.0100	156560.00	156560.00	0.00	76	10	3844	2019	1.90391282813274	0.0747742688671384	0.0747742688671384	true	false	false	true	false
f91055ba-0dca-4540-aa6a-5f7698c23a4e	2026-08-28 12:49	2026-08-28 12:48	2026-08-28 12:48	SPXW	SPXW260828P07750000	put	7750.0000	2026-08-28	29.3200	29.2000	29.6000	7722.7100	146620.00	32340.00	114280.00	50	12	45382	2724	16.6600587371512	0.180078491694888	0.182923034875612	true	false	false	true	false
1fc68e15-cdb9-4669-bb2c-1e134292985e	2026-08-28 12:50	2026-08-28 12:50	2026-08-28 12:50	SPXW	SPXW260828C07720000	call	7720.0000	2026-08-28	10.4600	10.3000	10.5000	7719.8900	107750.00	104630.00	3120.00	103	28	22701	1978	11.4767441860465	0.177979025764518	0.177979025764518	false	false	false	true	false
b9a7052c-fb61-4813-a3ea-cadd50a0273e	2026-08-28 12:51	2026-08-28 12:51	2026-08-28 12:51	SPXW	SPXW260828C07720000	call	7720.0000	2026-08-28	11.4000	11.3000	11.6000	7722.1500	113970.00	0.00	113970.00	100	29	23088	1978	11.6723963599596	0.175513894495909	0.175513894495909	false	false	false	true	false
fb4f5d00-ec65-49f8-8d4e-6ab9ce405381	2026-08-28 12:57	2026-08-28 12:57	2026-08-28 12:57	SPXW	SPXW260828P07740000	put	7740.0000	2026-08-28	25.6000	25.5000	25.6000	7717.1100	204800.00	204800.00	0.00	80	21	58100	1348	43.1008902077151	0.182798873208392	0.182798873208392	false	false	false	true	false
a986aaf3-68a0-4e07-a6d5-ba0d9098e34d	2026-08-28 13:00	2026-08-28 13:00	2026-08-28 13:00	SPXW	SPXW260903P07550000	put	7550.0000	2026-09-03	5.3900	5.2000	5.5000	7710.5100	134770.00	48980.00	82080.00	250	17	1475	5304	0.278092006033183	0.127010055888905	0.127628390638802	false	false	false	true	false
8bbc98b6-e231-40d7-bc70-f9145e78da46	2026-08-28 13:01	2026-08-28 13:01	2026-08-28 13:01	SPXW	SPXW260831C07730000	call	7730.0000	2026-08-31	12.3000	12.1000	12.4000	7706.3200	201640.00	34440.00	157440.00	164	13	5144	687	7.48762736535662	0.0757843954364767	0.0761725175907821	false	false	false	true	false
4ee25493-eb34-41c6-9a37-f22880c272d3	2026-08-28 13:02	2026-08-28 13:02	2026-08-28 13:02	SPXW	SPXW260901C07730000	call	7730.0000	2026-09-01	17.9900	17.7000	18.0000	7707.1300	104330.00	104330.00	0.00	58	12	443	340	1.30294117647059	0.0824567252523541	0.0824567252523541	false	false	false	true	false
8aa50ee9-2206-4cbc-8927-d8041cda0899	2026-08-28 13:03	2026-08-28 13:03	2026-08-28 13:03	SPXW	SPXW260828P07760000	put	7760.0000	2026-08-28	53.3700	52.6000	53.5000	7707.9500	112080.00	112080.00	0.00	21	5	28625	747	38.3199464524766	0.26098367465617	0.265628250532434	false	false	false	true	false
bc34047a-f4bf-48bb-8ba9-124fcc9db0da	2026-08-28 13:04	2026-08-28 13:04	2026-08-28 13:04	SPXW	SPXW260904P07700000	put	7700.0000	2026-09-04	40.1800	39.1000	39.5000	7710.6500	3214400.00	0.00	0.00	800	11	2256	2704	0.834319526627219	0.112510125035977	0.112510125035977	false	false	false	true	false
1050df11-4271-45ee-984f-65670c49e7ba	2026-08-28 13:04	2026-08-28 13:04	2026-08-28 13:04	SPXW	SPXW260904P07575000	put	7575.0000	2026-09-04	10.8600	10.5000	10.7000	7710.6500	1303200.00	0.00	0.00	1200	9	1930	1041	1.85398655139289	0.129869649634173	0.129869649634173	false	false	false	true	false
616d0c41-0946-48cb-80b8-2181cc79107c	2026-08-28 13:06	2026-08-28 13:06	2026-08-28 13:06	SPXW	SPXW260831C07730000	call	7730.0000	2026-08-31	11.7000	11.7000	11.8000	7704.8000	232830.00	0.00	232830.00	199	8	5765	687	8.39155749636099	0.0758516836337217	0.0758516836337217	false	false	false	true	false
afb7dc2d-594a-405b-aa8a-d5881035c722	2026-08-28 13:07	2026-08-28 13:07	2026-08-28 13:07	SPXW	SPXW260831C07720000	call	7720.0000	2026-08-31	15.3000	14.0000	15.4000	7704.3600	110160.00	71910.00	38250.00	72	5	1836	706	2.60056657223796	0.0762320287999677	0.0762320287999677	false	false	false	true	false
cfdd6e87-e661-4762-b543-d380950b1cf5	2026-08-28 13:10	2026-08-28 13:09	2026-08-28 13:09	SPXW	SPXW260828P07705000	put	7705.0000	2026-08-28	12.2000	12.1000	12.2000	7704.1700	102480.00	102480.00	0.00	84	9	46317	1002	46.2245508982036	0.213925394466323	0.213925394466323	false	false	false	true	false
3ed4e51b-2660-4e0a-9f8c-562d4fd057cc	2026-08-28 13:10	2026-08-28 13:10	2026-08-28 13:10	SPXW	SPXW260831C07730000	call	7730.0000	2026-08-31	10.8000	10.6000	10.9000	7702.2900	179330.00	133970.00	45360.00	166	20	5967	687	8.68558951965066	0.0755286827895864	0.0755286827895864	true	false	false	true	false
829c588e-6036-472d-a3c7-cd89483c8f5d	2026-08-28 13:15	2026-08-28 13:15	2026-08-28 13:15	SPXW	SPXW260831C07730000	call	7730.0000	2026-08-31	13.2000	13.1000	13.4000	7710.9100	264000.00	92400.00	171600.00	200	18	6242	687	9.08588064046579	0.0732968923209392	0.0732968923209392	false	false	false	true	false