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:source = uw_flow_alerts×ticker = GEMI×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

1995c264-4243-48d5-bc08-32ca52d2a65c	2026-08-17 09:41	2026-08-17 09:41	2026-08-17 09:41	GEMI	GEMI280121C00005000	call	5.0000	2028-01-21	1.3500	1.3500	1.6000	3.5800	135000.00	0.00	135000.00	1000	35	1003	929	1.07965554359526	1.00399477923062	1.00399477923062	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	—	Financial Services	262267261.00	2026-11-09	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-17T13:42:20.529509Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
99a6b5a0-2502-4278-9f53-c0e16a78e02a	2026-08-19 13:36	2026-08-19 13:36	2026-08-19 13:36	GEMI	GEMI280121C00022500	call	22.5000	2028-01-21	0.4000	0.4000	0.7000	3.8100	12000.00	0.00	12000.00	300	9	300	1627	0.184388444990781	1.06081141864627	1.06081141864627	false	false	false	true
c5608545-0254-4eab-bed8-f365b1d0dc47	2026-08-19 15:14	2026-08-19 15:14	2026-08-19 15:14	GEMI	GEMI260821C00004000	call	4.0000	2026-08-21	0.1500	0.1000	0.2000	3.8850	15000.00	6045.00	8955.00	1000	5	4503	533	8.4484052532833	1.73625975737586	1.73625975737586	false	false	false	true
28f6b0cd-d6dc-4775-a65a-f40c4e59c3d8	2026-08-20 09:53	2026-08-20 09:53	2026-08-20 09:53	GEMI	GEMI260821C00004000	call	4.0000	2026-08-21	0.1900	0.1500	0.2500	4.1200	10547.00	0.00	8407.00	543	16	906	3706	0.244468429573664	1.17396708778888	1.29098310632392	true	false	false	true
91c49a68-d8e5-4a94-ab9b-551d50a3dc9f	2026-08-27 10:42	2026-08-27 10:42	2026-08-27 10:42	GEMI	GEMI270115C00005000	call	5.0000	2027-01-15	1.2500	1.2000	1.3000	4.9550	11375.00	4500.00	0.00	91	5	165	2867	0.0575514475061039	1.03592530770716	1.0251188480409	false	false	false	true
84b689d5-2905-49c1-a739-9ea4bb705c1e	2026-09-04 15:30	2026-09-04 15:30	2026-09-04 15:30	GEMI	GEMI270115P00005000	put	5.0000	2027-01-15	1.3000	1.2500	1.3500	4.7000	13780.00	1950.00	11830.00	106	8	266	3397	0.0783043862231381	1.03656052986737	1.03656052986737	false	false	false	true
8272126b-5f5a-47b9-8bfc-34ab3c786554	2026-09-11 12:13	2026-09-11 12:13	2026-09-11 12:13	GEMI	GEMI270115P00005000	put	5.0000	2027-01-15	1.2800	1.2500	1.3500	4.5650	12796.00	0.00	12796.00	100	10	100	3619	0.0276319425255595	1.00116798248647	1.00116798248647	false	false	false	true
b4ed436f-325b-4ba9-8a57-c714220409b5	2026-09-14 13:28	2026-09-14 13:28	2026-09-14 13:28	GEMI	GEMI270115P00005000	put	5.0000	2027-01-15	1.2000	1.1500	1.2500	4.7950	54960.00	54120.00	720.00	458	17	509	3713	0.137085914354969	1.01366815407406	1.01366815407406	false	false	false	true
65ff0ece-027b-4aca-af92-f3a23fb2dfc0	2026-09-14 15:14	2026-09-14 15:13	2026-09-14 15:13	GEMI	GEMI270115P00005000	put	5.0000	2027-01-15	1.2000	1.1500	1.2500	4.8400	71160.00	70560.00	0.00	593	8	1102	3713	0.296795044438459	1.03031553770192	1.03031553770192	false	false	false	true
e1af4b17-8b5b-4c73-a034-bf154848d5f9	2026-09-14 15:20	2026-09-14 15:19	2026-09-14 15:19	GEMI	GEMI270115P00005000	put	5.0000	2027-01-15	1.2000	1.1500	1.2500	4.8350	31080.00	30360.00	0.00	259	12	1361	3713	0.3665499596014	1.02848580820736	1.02848580820736	false	false	false	true
5183973f-f6bb-444c-8b6a-a590b5788efa	2026-09-18 10:26	2026-09-18 10:25	2026-09-18 10:25	GEMI	GEMI261016C00005000	call	5.0000	2026-10-16	0.5000	0.4500	0.5500	4.8900	18200.00	15400.00	750.00	364	32	384	1967	0.195221148957804	1.02377651931328	1.00423197084709	false	false	false	true
86bb2273-5e67-4c8f-a5c4-c8cfda875491	2026-09-18 11:18	2026-09-18 11:18	2026-09-18 11:18	GEMI	GEMI261016C00005000	call	5.0000	2026-10-16	0.5000	0.4500	0.5500	4.8650	71900.00	0.00	71250.00	1438	26	2258	1967	1.14794102694459	1.02864932055562	1.02864932055562	true	false	false	true
c2744aee-638f-47e4-be13-f667aa2efe0f	2026-09-18 15:23	2026-09-18 15:22	2026-09-18 15:22	GEMI	GEMI261023C00007000	call	7.0000	2026-10-23	0.3500	0.2000	0.4000	5.7750	28025.00	28025.00	0.00	801	43	1050	142	7.3943661971831	1.03899610830589	1.03899610830589	false	false	false	true
e5481348-d829-49c1-9dcd-d359b6bf718c	2026-09-18 15:24	2026-09-18 15:24	2026-09-18 15:24	GEMI	GEMI270115C00007500	call	7.5000	2027-01-15	0.8500	0.7000	0.8500	5.7784	22525.00	22525.00	0.00	265	21	977	1265	0.772332015810277	1.03606252617987	1.03606252617987	false	false	false	true