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

83b52166-0bef-4a42-abba-17203497fbf1	2026-08-28 14:00	2026-08-28 14:00	2026-08-28 14:00	SPXW	SPXW260828P07715000	put	7715.0000	2026-08-28	8.7000	8.4000	8.8000	7713.2700	179200.00	178350.00	0.00	206	46	70547	1492	47.2835120643432	0.165661603436122	0.170874971673777	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-28T18:18:32.282709Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
b565542c-7ffc-40cc-bfff-5cd61d28c29e	2026-08-28 14:00	2026-08-28 14:00	2026-08-28 14:00	SPXW	SPXW260831C07710000	call	7710.0000	2026-08-31	22.8000	22.7000	22.8000	7713.5100	182400.00	182400.00	0.00	80	6	1739	907	1.91730981256891	0.0706281103373295	0.0706281103373295	false	false	false	true	false
5a37faf6-17ae-410e-bdb4-484d41f7b2b0	2026-08-28 14:01	2026-08-28 14:01	2026-08-28 14:01	SPXW	SPXW260828C07675000	call	7675.0000	2026-08-28	36.9700	37.0000	37.4000	7712.0000	114600.00	0.00	114600.00	31	6	1423	2570	0.553696498054475	0.130261764178606	0.130261764178606	false	false	false	true	false
fb7b6366-ff3c-427c-a3c2-d4976b22eee0	2026-08-28 14:02	2026-08-28 14:02	2026-08-28 14:02	SPXW	SPXW260828P07715000	put	7715.0000	2026-08-28	8.9000	8.8000	9.0000	7712.4700	178000.00	121930.00	0.00	200	36	71260	1492	47.7613941018767	0.16499460565627	0.16499460565627	false	false	false	true	false
fa6346c0-f9ea-40e0-b342-c79a02b20122	2026-08-28 14:03	2026-08-28 14:03	2026-08-28 14:03	SPXW	SPXW260828C07710000	call	7710.0000	2026-08-28	10.1000	10.0000	10.2000	7714.7700	188870.00	0.00	115140.00	187	16	30181	1438	20.9881780250348	0.162468242838896	0.162468242838896	false	false	false	true	false
df6ec294-3495-42d1-859e-6c6af9fd94a9	2026-08-28 14:06	2026-08-28 14:06	2026-08-28 14:06	SPXW	SPXW261009C08200000	call	8200.0000	2026-10-09	5.6100	5.4000	5.7000	7712.4600	308550.00	0.00	0.00	550	7	580	41	14.1463414634146	0.101545494928906	0.101545494928906	false	false	false	true	false
dd468ba8-7845-4cd7-b710-383d744865cb	2026-08-28 14:06	2026-08-28 14:06	2026-08-28 14:06	SPXW	SPXW261006P07100000	put	7100.0000	2026-10-06	19.0400	18.8000	19.2000	7712.4600	571200.00	0.00	0.00	300	7	300	0	0	0.195755205414329	0.195755205414329	false	false	false	true	false
9d22ae9c-a5c3-4f41-b14a-52e684684639	2026-08-28 14:06	2026-08-28 14:06	2026-08-28 14:06	SPXW	SPXW261009P07100000	put	7100.0000	2026-10-09	21.9400	21.8000	22.1000	7712.4600	658200.00	0.00	0.00	300	7	352	90	3.91111111111111	0.196210918201117	0.196210918201117	false	false	false	true	false
5c315eba-1502-4677-9994-51788cf486a1	2026-08-28 14:06	2026-08-28 14:06	2026-08-28 14:06	SPXW	SPXW261009P07200000	put	7200.0000	2026-10-09	27.3100	27.1000	27.5000	7712.4600	1502050.00	0.00	0.00	550	7	601	83	7.24096385542169	0.183487318353662	0.183487318353662	false	false	false	true	false
db470909-9151-489f-9355-b3de29503328	2026-08-28 14:08	2026-08-28 14:08	2026-08-28 14:08	SPXW	SPXW260828C07710000	call	7710.0000	2026-08-28	8.3000	8.2000	8.3000	7711.8900	148570.00	148570.00	0.00	179	5	31500	1438	21.9054242002782	0.162531996922997	0.162531996922997	false	false	false	true	false
dbcdb279-80e3-4d49-b68c-f79677fe5a39	2026-08-28 14:09	2026-08-28 14:09	2026-08-28 14:09	SPXW	SPXW260828P07715000	put	7715.0000	2026-08-28	7.6400	7.4000	7.7000	7714.2400	191060.00	191060.00	0.00	250	52	73643	1492	49.3585790884718	0.160171208987126	0.164657692074798	false	false	false	true	false
3f4446e4-9277-4e48-806f-bb6449129c01	2026-08-28 14:13	2026-08-28 14:13	2026-08-28 14:13	SPXW	SPXW260904P07430000	put	7430.0000	2026-09-04	2.4000	2.3000	2.4500	7714.8300	646800.00	0.00	0.00	2695	11	2958	370	7.99459459459459	0.155017428129733	0.155017428129733	false	false	false	true	false
8d608142-cca6-4e99-86a8-fe26efffd87b	2026-08-28 14:14	2026-08-28 14:13	2026-08-28 14:13	SPXW	SPXW260828P07715000	put	7715.0000	2026-08-28	8.3000	8.1000	8.4000	7713.0300	214070.00	207500.00	0.00	258	15	74996	1492	50.2654155495979	0.164795577092645	0.164795577092645	false	false	false	true	false
03805582-c597-494f-a7b1-8f766f31fde2	2026-08-28 14:14	2026-08-28 14:14	2026-08-28 14:14	SPXW	SPXW260828P07715000	put	7715.0000	2026-08-28	9.0700	8.8000	9.1000	7712.1800	226630.00	226630.00	0.00	250	44	75447	1492	50.5676943699732	0.17287203189406	0.17287203189406	false	false	false	true	false
26ca33a9-837f-4b11-9bfa-1364b2756b3e	2026-08-28 14:15	2026-08-28 14:14	2026-08-28 14:14	SPXW	SPXW260828P07715000	put	7715.0000	2026-08-28	10.0000	9.8000	10.3000	7710.2200	252880.00	21820.00	219890.00	253	69	75848	1492	50.8364611260054	0.178954536267364	0.170141303784731	false	false	false	true	false
2ff324e1-db77-4d2c-b678-99c8fd5bb38e	2026-08-28 14:15	2026-08-28 14:15	2026-08-28 14:15	SPXW	SPXW260828P07710000	put	7710.0000	2026-08-28	6.2300	6.0000	6.3000	7711.8400	106460.00	103990.00	0.00	171	37	79676	1732	46.0023094688222	0.161765183437446	0.166407877797322	false	false	false	true	false
a11bf249-400d-47c0-89fc-cb738368f290	2026-08-28 14:17	2026-08-28 14:16	2026-08-28 14:16	SPXW	SPXW260828P07710000	put	7710.0000	2026-08-28	6.3300	6.3000	6.5000	7711.6100	104500.00	0.00	104500.00	165	39	80247	1732	46.3319861431871	0.16708279604953	0.164753157439605	false	false	false	true	false
8f89081a-7591-4e8d-b063-8b93de0767a9	2026-08-28 14:18	2026-08-28 14:18	2026-08-28 14:18	SPXW	SPXW260828P07710000	put	7710.0000	2026-08-28	6.0800	5.9000	6.3000	7712.1500	152110.00	135310.00	0.00	250	51	81379	1732	46.9855658198614	0.164959695205524	0.169676075555617	false	false	false	true	false
c6a5cae9-be27-4cdc-8052-11e53fa054ea	2026-08-28 14:23	2026-08-28 14:23	2026-08-28 14:23	SPXW	SPXW260828P07710000	put	7710.0000	2026-08-28	6.3000	6.2000	6.5000	7710.9800	151870.00	149310.00	0.00	241	18	83017	1732	47.9312933025404	0.163115744957372	0.165517261311895	false	false	false	true	false
9639b79f-8b0f-460f-81b0-e0e93d001374	2026-08-28 14:24	2026-08-28 14:23	2026-08-28 14:23	SPXW	SPXW260911C07800000	call	7800.0000	2026-09-11	23.4000	23.3000	23.7000	7707.3600	140400.00	16380.00	124020.00	60	9	447	1342	0.333084947839046	0.0903459879016942	0.0903459879016942	false	false	false	true	false
23316d76-e530-4917-ba80-9cb30e8a1cee	2026-08-28 14:25	2026-08-28 14:25	2026-08-28 14:25	SPXW	SPXW260828P07710000	put	7710.0000	2026-08-28	8.1500	7.9000	8.3000	7708.0000	203790.00	190900.00	0.00	250	56	84583	1732	48.8354503464203	0.169267172304483	0.17170589694116	false	false	false	true	false
cd8889cf-7353-42b5-9a32-270eab56823e	2026-08-28 14:26	2026-08-28 14:25	2026-08-28 14:25	SPXW	SPXW260831C07730000	call	7730.0000	2026-08-31	10.2000	10.0000	10.3000	7707.7400	153000.00	89760.00	0.00	150	16	9171	687	13.3493449781659	0.0660888647429489	0.0660888647429489	false	false	false	true	false
cd472f45-7d77-428e-a27a-c6d76254bfd7	2026-08-28 14:27	2026-08-28 14:27	2026-08-28 14:27	SPXW	SPXW260828C07705000	call	7705.0000	2026-08-28	10.0100	9.7000	10.1000	7709.9400	112090.00	108090.00	4000.00	112	27	17925	1015	17.6600985221675	0.179789076971796	0.17432783483658	true	false	false	true	false
c6ccde97-c6db-462d-b976-3c2b6495fa66	2026-08-28 14:27	2026-08-28 14:27	2026-08-28 14:27	SPXW	SPXW260828C07705000	call	7705.0000	2026-08-28	9.8600	9.7000	10.0000	7709.7500	124260.00	120340.00	0.00	126	24	17800	1015	17.5369458128079	0.174723458268621	0.174723458268621	true	false	false	true	false
fdad2b01-c779-46ff-b39d-248a4c92806e	2026-08-28 14:29	2026-08-28 14:29	2026-08-28 14:29	SPXW	SPXW260828C07705000	call	7705.0000	2026-08-28	8.7000	8.6000	8.8000	7708.4600	218370.00	214020.00	0.00	251	32	18504	1015	18.2305418719212	0.168812908914484	0.168812908914484	false	false	false	true	false
b381c06d-b649-4206-bf80-2b326b10457e	2026-08-28 14:35	2026-08-28 14:35	2026-08-28 14:35	SPXW	SPXW260828P07675000	put	7675.0000	2026-08-28	0.3000	0.2000	0.2500	7711.4200	108000.00	0.00	0.00	3600	8	60358	3143	19.2039452752148	0.208484155596787	0.208484155596787	false	false	false	true	false
30c0c5da-228c-4ca2-838b-b43d48bc3898	2026-08-28 14:35	2026-08-28 14:35	2026-08-28 14:35	SPXW	SPXW260828P07685000	put	7685.0000	2026-08-28	0.7900	0.5500	0.6000	7711.4200	237000.00	0.00	0.00	3000	8	61803	1850	33.407027027027	0.199530370887839	0.199530370887839	false	false	false	true	false
06898394-6278-4d2b-8d5a-1210abd25209	2026-08-28 14:35	2026-08-28 14:35	2026-08-28 14:35	SPXW	SPXW260828C07690000	call	7690.0000	2026-08-28	23.5000	23.5000	23.7000	7712.7100	119860.00	0.00	117500.00	51	5	3499	847	4.1310507674144	0.18227468877777	0.176272976224108	false	false	false	true	false
c00fcf79-97d4-4724-b284-d3ebd618e268	2026-08-28 14:36	2026-08-28 14:36	2026-08-28 14:36	SPXW	SPXW260828C07690000	call	7690.0000	2026-08-28	21.9600	21.6000	22.0000	7710.7800	109810.00	109810.00	0.00	50	11	3559	847	4.20188902007084	0.178658993234976	0.178658993234976	false	false	false	true	false
75ff1934-7f9f-46bd-921d-df7531cbb1f1	2026-08-28 14:36	2026-08-28 14:36	2026-08-28 14:36	SPXW	SPXW260831P07685000	put	7685.0000	2026-08-31	10.4000	10.2000	10.5000	7710.7700	104000.00	41600.00	1040.00	100	14	1927	580	3.32241379310345	0.0777070485261979	0.0777070485261979	false	false	false	true	false
9e71dc18-841d-445c-bd95-e915226d173e	2026-08-28 14:36	2026-08-28 14:36	2026-08-28 14:36	SPXW	SPXW260828C07690000	call	7690.0000	2026-08-28	21.7900	21.5000	21.9000	7710.7000	154740.00	32660.00	122080.00	71	11	3630	847	4.28571428571429	0.177325820314592	0.182561135708274	false	false	false	true	false
a2e6ee3a-9248-44a5-b22d-7cb8176e502d	2026-08-28 14:36	2026-08-28 14:36	2026-08-28 14:36	SPXW	SPXW260828C07690000	call	7690.0000	2026-08-28	22.2000	22.1000	22.4000	7711.0400	111000.00	86580.00	24420.00	50	6	3714	847	4.38488783943329	0.187858358484086	0.187858358484086	false	false	false	true	false
889111f5-076c-4b09-b0c9-0ae825b4bc99	2026-08-28 14:38	2026-08-28 14:37	2026-08-28 14:37	SPXW	SPXW260925P07550000	put	7550.0000	2026-09-25	46.9000	46.7000	47.1000	7710.1700	117250.00	0.00	42210.00	25	6	266	317	0.839116719242902	0.137723531462529	0.137723531462529	false	false	false	true	false
f3f5337a-961d-44cd-984a-0d4f93fdcae3	2026-08-28 14:38	2026-08-28 14:38	2026-08-28 14:38	SPXW	SPXW260831P07685000	put	7685.0000	2026-08-31	10.9000	10.8000	10.9000	7709.2000	109000.00	109000.00	0.00	100	7	2028	580	3.49655172413793	0.0777896737775577	0.0777896737775577	false	false	false	true	false
daafa773-9244-43ff-bbe1-494bce5369c7	2026-08-28 14:40	2026-08-28 14:40	2026-08-28 14:40	SPXW	SPXW260828C07690000	call	7690.0000	2026-08-28	21.6700	21.6000	21.9000	7710.8100	108340.00	0.00	101800.00	50	8	3882	847	4.58323494687131	0.182175186192726	0.182175186192726	false	false	false	true	false
7c4021bb-d0e5-4085-a11e-679a97b22038	2026-08-28 14:40	2026-08-28 14:40	2026-08-28 14:40	SPXW	SPXW260828C07690000	call	7690.0000	2026-08-28	21.8600	21.8000	22.1000	7710.8600	109280.00	0.00	109280.00	50	7	3932	847	4.64226682408501	0.185356431822458	0.185356431822458	false	false	false	true	false
79aee4f6-5d17-4562-9120-690fe19efc69	2026-08-28 14:42	2026-08-28 14:42	2026-08-28 14:42	SPXW	SPXW260828P07710000	put	7710.0000	2026-08-28	6.3300	6.2000	6.5000	7708.4700	183590.00	0.00	172770.00	290	49	92657	1732	53.4971131639723	0.15455404678375	0.148095171748324	true	false	false	true	false
7e88acf3-9f51-4dd5-8552-d492d1ec9e31	2026-08-28 14:43	2026-08-28 14:43	2026-08-28 14:43	SPXW	SPXW260828P07710000	put	7710.0000	2026-08-28	6.6600	6.4000	6.7000	7708.8800	186390.00	185740.00	0.00	280	51	93131	1732	53.7707852193995	0.159949493829921	0.165343230958851	false	false	false	true	false
6f3f9757-4cc2-4554-868a-fb1edba63cb9	2026-08-28 14:48	2026-08-28 14:48	2026-08-28 14:48	SPXW	SPXW260831C07710000	call	7710.0000	2026-08-31	18.0000	18.0000	18.1000	7706.4700	140400.00	0.00	140400.00	78	8	2615	907	2.88313120176406	0.0665572617691855	0.0665572617691855	false	false	false	true	false
a6af15e3-7881-4bff-87cc-cb99f8eafd06	2026-08-28 14:49	2026-08-28 14:48	2026-08-28 14:48	SPXW	SPXW260904C07710000	call	7710.0000	2026-09-04	42.3000	42.2000	42.3000	7705.5900	105750.00	105750.00	0.00	25	6	413	307	1.34527687296417	0.0979294895342864	0.0979294895342864	false	false	false	true	false
1f09d1b2-fe66-41d8-9fa6-672602ba606d	2026-08-28 14:49	2026-08-28 14:48	2026-08-28 14:48	SPXW	SPXW260904P07675000	put	7675.0000	2026-09-04	29.7000	29.6000	29.8000	7705.5900	109890.00	50490.00	0.00	37	5	913	1867	0.489019817889663	0.107195374703812	0.107195374703812	false	false	false	true	false
398e03cc-6485-4842-ac6a-e2aac2ca0445	2026-08-28 14:49	2026-08-28 14:49	2026-08-28 14:49	SPXW	SPXW260828C07710000	call	7710.0000	2026-08-28	3.8200	3.6000	3.9000	7704.9000	114660.00	109070.00	0.00	300	54	45958	1438	31.9596662030598	0.165721604974899	0.168703733971635	false	false	false	true	false
b88bc3b0-25a1-4c22-9da6-28eed6513720	2026-08-28 14:51	2026-08-28 14:51	2026-08-28 14:51	SPXW	SPXW260828P07710000	put	7710.0000	2026-08-28	10.8800	10.5000	11.1000	7701.6200	123990.00	123990.00	0.00	114	33	96665	1732	55.8112009237875	0.157980814026727	0.168081879245877	false	false	false	true	false
c443de53-1d83-4fff-94cf-ca5f36174762	2026-08-28 14:53	2026-08-28 14:53	2026-08-28 14:53	SPXW	SPXW260831C07730000	call	7730.0000	2026-08-31	8.3000	8.3000	8.4000	7701.5900	141930.00	0.00	141930.00	171	8	10243	687	14.9097525473071	0.0661485736879289	0.0661485736879289	false	false	false	true	false
6e93013e-85b6-4bca-ae51-448ed65d8501	2026-08-28 14:55	2026-08-28 14:55	2026-08-28 14:55	SPXW	SPXW260828C07690000	call	7690.0000	2026-08-28	15.0600	14.7000	15.2000	7702.0300	150570.00	117350.00	33220.00	100	17	4537	847	5.35655253837072	0.215268102345202	0.215268102345202	false	false	false	true	false
7c097ca6-bd4c-4c5a-873d-b008d8db03c0	2026-08-28 14:55	2026-08-28 14:55	2026-08-28 14:55	SPXW	SPXW260828C07690000	call	7690.0000	2026-08-28	14.6000	14.4000	14.7000	7701.4200	145980.00	36480.00	109500.00	100	17	4640	847	5.47815820543093	0.217381403483262	0.220922327458053	false	false	false	true	false
b527167c-3e1e-4e76-ba42-ca5485f83eb0	2026-08-28 14:56	2026-08-28 14:56	2026-08-28 14:56	SPXW	SPXW260828C07690000	call	7690.0000	2026-08-28	15.2900	15.2000	15.6000	7702.9600	238580.00	0.00	238580.00	156	22	4819	847	5.68949232585596	0.20924283855412	0.20924283855412	false	false	false	true	false
d6702da8-535d-480f-90eb-335644ce2716	2026-08-28 14:57	2026-08-28 14:57	2026-08-28 14:57	SPXW	SPXW260828C07700000	call	7700.0000	2026-08-28	8.7000	8.7000	8.9000	7704.6300	109620.00	0.00	109620.00	126	9	19481	4549	4.28247966586063	0.180926971893182	0.180926971893182	false	false	false	true	false
527c2f67-e97a-4df0-968f-67fecf062889	2026-08-28 14:59	2026-08-28 14:59	2026-08-28 14:59	SPXW	SPXW260828P07710000	put	7710.0000	2026-08-28	7.9000	7.8000	8.1000	7705.6200	251140.00	149310.00	91550.00	318	59	99275	1732	57.318129330254	0.165510640514036	0.162315189455486	false	false	false	true	false
47ee544e-7338-4f44-869c-26b07bf0dae2	2026-08-28 15:02	2026-08-28 15:02	2026-08-28 15:02	SPXW	SPXW260828C07705000	call	7705.0000	2026-08-28	6.4700	6.2000	6.6000	7706.5700	226450.00	225160.00	0.00	350	86	27758	1015	27.3477832512315	0.172586968952417	0.175735538171372	false	false	false	true	false