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:endpoint = /api/option-trades/flow-alerts×ticker = SPYM×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	expiry

87f985fe-ba01-4979-9b8c-aab82384f84c	2026-08-18 13:46	2026-08-18 13:46	2026-08-18 13:46	SPYM	SPYM261218P00091000	put	91.0000	2026-12-18	3.1000	3.0000	3.1000	90.4150	122760.00	122760.00	0.00	396	11	397	72	5.51388888888889	0.163440559431469	0.163440559431469	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	987630000.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-18T17:51:56.571434Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
5fcfe63b-c4bc-48b6-b751-ee3bfcd591e0	2026-08-21 15:32	2026-08-21 15:32	2026-08-21 15:32	SPYM	SPYM260821C00088000	call	88.0000	2026-08-21	2.1600	2.1500	2.2000	90.1850	10571.00	0.00	10571.00	49	12	69	464	0.148706896551724	1.82960419144351	1.83015940143787	false	false	false
cb6ad830-f42e-4dbd-a3cb-6c9501550672	2026-08-25 10:30	2026-08-25 10:30	2026-08-25 10:30	SPYM	SPYM260918C00085000	call	85.0000	2026-09-18	5.3000	5.3000	5.5000	90.0000	59360.00	0.00	59360.00	112	8	112	102	1.09803921568627	0.150312608990086	0.150312608990086	false	false	false
6582f1e0-3e1f-454b-acda-10bafa8eb181	2026-08-25 10:30	2026-08-25 10:30	2026-08-25 10:30	SPYM	SPYM260918P00093000	put	93.0000	2026-09-18	3.2000	2.9000	3.2000	90.0000	76480.00	76480.00	0.00	239	11	240	12	20	0.149971737357786	0.149971737357786	false	false	false
20589da0-02ff-4aec-8997-cd535db3edbc	2026-08-25 10:30	2026-08-25 10:30	2026-08-25 10:30	SPYM	SPYM260918C00089000	call	89.0000	2026-09-18	1.8500	1.8500	2.1000	90.0000	14430.00	0.00	14430.00	78	15	89	207	0.429951690821256	0.124271528618564	0.124271528618564	false	false	false
df09be99-59e7-45a2-819c-39c004464b31	2026-08-31 15:57	2026-08-31 15:57	2026-08-31 15:57	SPYM	SPYM270115P00086000	put	86.0000	2027-01-15	1.6600	1.4000	1.7000	90.3235	143225.00	135140.00	0.00	861	7	861	394	2.18527918781726	0.179729020524825	0.178617741342995	true	false	false
ce625470-878e-4091-9fa7-b924655a04a9	2026-09-01 12:27	2026-09-01 12:26	2026-09-01 12:26	SPYM	SPYM260918P00091000	put	91.0000	2026-09-18	1.7000	1.5000	1.7000	89.7850	40970.00	40970.00	0.00	241	14	256	287	0.89198606271777	0.140773232150518	0.140773232150518	false	false	false
5430843c-9d58-44c2-b09b-4cc25757174e	2026-09-01 12:27	2026-09-01 12:26	2026-09-01 12:26	SPYM	SPYM260918C00084000	call	84.0000	2026-09-18	5.9000	5.9000	6.1000	89.7850	49565.00	0.00	49565.00	84	17	88	344	0.255813953488372	0.22957462133151	0.22957462133151	false	false	false
4c171133-ddb4-4779-98de-46404f79e1bf	2026-09-01 12:27	2026-09-01 12:26	2026-09-01 12:26	SPYM	SPYM260918C00090000	call	90.0000	2026-09-18	0.8000	0.8000	0.8500	89.7850	11600.00	0.00	11600.00	145	8	195	601	0.324459234608985	0.106901639373157	0.106901639373157	false	false	false
e4b6a065-e3fc-4f52-914f-4ce1fc2634f7	2026-09-01 13:25	2026-09-01 13:25	2026-09-01 13:25	SPYM	SPYM260918P00091000	put	91.0000	2026-09-18	1.8000	1.6500	1.8000	89.6400	10620.00	10620.00	0.00	59	6	316	287	1.10104529616725	0.141515338597558	0.141515338597558	false	false	false
b50f382d-5d18-4296-84e3-eab2af9c5ccd	2026-09-01 13:25	2026-09-01 13:25	2026-09-01 13:25	SPYM	SPYM260918P00092000	put	92.0000	2026-09-18	2.6000	2.4000	2.6000	89.5800	22880.00	22880.00	0.00	88	10	93	52	1.78846153846154	0.153003496594129	0.145064354629301	false	false	false
28b503c3-c3f1-4fd3-9ead-a3067359b49a	2026-09-10 09:35	2026-09-10 09:35	2026-09-10 09:35	SPYM	SPYM270115P00090000	put	90.0000	2027-01-15	3.2200	3.1000	3.4000	89.2350	12894.00	0.00	12894.00	40	7	106	61	1.73770491803279	0.165073442839528	0.165073442839528	false	false	false
a1ece56d-f1a2-46d9-aaea-4f23dad7da3c	2026-09-10 12:34	2026-09-10 12:34	2026-09-10 12:34	SPYM	SPYM260918C00083000	call	83.0000	2026-09-18	6.2000	6.2000	6.4000	89.2400	32241.00	0.00	32241.00	52	19	54	125	0.432	0.298658956982074	0.254024882688165	false	false	false
34b84e5f-add5-4ab0-8e6a-d680dd4b0875	2026-09-10 12:34	2026-09-10 12:34	2026-09-10 12:34	SPYM	SPYM261016P00092000	put	92.0000	2026-10-16	3.2000	2.9500	3.2000	89.2400	36480.00	36480.00	0.00	114	29	124	20	6.2	0.153272580661418	0.152185837735959	false	false	false
3f790261-3811-4818-8855-4f637f7c6561	2026-09-10 14:04	2026-09-10 14:03	2026-09-10 14:03	SPYM	SPYM260918C00078000	call	78.0000	2026-09-18	11.5000	11.0000	11.7000	89.2100	235750.00	235750.00	0.00	205	1	407	202	2.01485148514851	0.611816506982184	0.611816506982184	false	true	false
8ed15835-f9d2-489d-a675-0ca742082121	2026-09-10 14:56	2026-09-10 14:56	2026-09-10 14:56	SPYM	SPYM261218P00082000	put	82.0000	2026-12-18	1.0000	1.0000	1.0500	89.2301	31100.00	0.00	31100.00	311	18	314	71	4.42253521126761	0.210167798801939	0.210167798801939	false	false	false
7c625cbc-acd3-418b-a21e-20e5b8e8ff54	2026-09-10 15:19	2026-09-10 15:19	2026-09-10 15:19	SPYM	SPYM260918C00078000	call	78.0000	2026-09-18	11.6000	11.0000	11.7000	89.1601	290000.00	290000.00	0.00	250	1	657	202	3.25247524752475	0.69092344496307	0.69092344496307	false	true	false
267bef91-bb65-42cf-af8c-40512d8ba146	2026-09-10 15:19	2026-09-10 15:19	2026-09-10 15:19	SPYM	SPYM260918C00079000	call	79.0000	2026-09-18	10.4000	10.1000	10.4000	89.1601	208000.00	208000.00	0.00	200	1	576	184	3.1304347826087	0.532407270028626	0.532407270028626	false	true	false
bc6da2d1-98b5-43e4-851d-952bb24cd219	2026-09-14 14:42	2026-09-14 14:42	2026-09-14 14:42	SPYM	SPYM261218P00085000	put	85.0000	2026-12-18	1.2500	1.2500	1.3000	89.5100	32126.00	0.00	32126.00	257	16	260	453	0.573951434878587	0.185292063935826	0.185292063935826	false	false	false
ebaa85f5-1f29-4849-a135-b78b220d5c7b	2026-09-21 12:39	2026-09-21 12:39	2026-09-21 12:39	SPYM	SPYM261016P00092000	put	92.0000	2026-10-16	1.6000	1.6000	1.6500	90.8750	12960.00	0.00	12960.00	81	6	230	784	0.293367346938776	0.116207732993575	0.116207732993575	false	false	false
f13a3c2b-fe5b-437d-a9b1-8ae1796a9554	2026-09-22 10:35	2026-09-22 10:35	2026-09-22 10:35	SPYM	SPYM261016P00092000	put	92.0000	2026-10-16	1.4500	1.4000	1.4500	91.0501	29580.00	29580.00	0.00	204	9	219	447	0.48993288590604	0.113031054374324	0.113031054374324	false	false	false
6e8f22e1-61ec-4837-bedd-f698a1796ea8	2026-09-22 10:35	2026-09-22 10:35	2026-09-22 10:35	SPYM	SPYM261016C00087000	call	87.0000	2026-10-16	4.5000	4.5000	4.7000	91.0501	35550.00	0.00	35550.00	79	10	79	14	5.64285714285714	0.161583854381328	0.161583854381328	false	false	false
004e804e-5eee-4c5e-a440-f7ee4d58425a	2026-09-22 10:35	2026-09-22 10:35	2026-09-22 10:35	SPYM	SPYM261016C00090000	call	90.0000	2026-10-16	1.9000	1.9000	2.1000	91.0501	11780.00	0.00	11780.00	62	9	93	403	0.230769230769231	0.123833332669523	0.123833332669523	false	false	false