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:sector = Financial Services×source = uw_flow_alerts×ticker = HSBC×

iduuid	created_at ↓timestamp with time zone	start_timetimestamp with time zone	end_timetimestamp with time zone	tickertext	option_symboltext	option_typetext	strikenumeric	expiry

9ed75e4f-9b61-4266-a15c-d4d663687408	2026-09-28 14:13	2026-09-28 14:13	2026-09-28 14:13	HSBC	HSBC261016C00102000	call	102.0000	2026-10-16	1.9500	1.8500	2.0000	101.3900	53040.00	43095.00	9945.00	272	30	275	15	18.3333333333333	0.236463665212458	0.238610681499824	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ADR	Financial Services	347558153807.00	2026-10-27	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-28T18:20:46.234036Z"}	2026-09-28	2026-09-28 21:15	2026-09-28 21:15
2a8d631a-a265-4983-bd5e-334cc6db7df2	2026-09-28 12:09	2026-09-28 12:08	2026-09-28 12:08	HSBC	HSBC261016C00100000	call	100.0000	2026-10-16	2.8500	2.7000	2.8500	100.9700	17100.00	17100.00	0.00	60	15	60	39	1.53846153846154	0.249273893036633	0.249273893036633	false	false	false
5e88f118-0320-40b8-80f0-2d545331f4a4	2026-09-25 12:24	2026-09-25 12:24	2026-09-25 12:24	HSBC	HSBC261120C00110000	call	110.0000	2026-11-20	1.1000	1.1000	1.1500	100.8900	24860.00	0.00	24860.00	226	21	227	18	12.6111111111111	0.241559810832202	0.241559810832202	false	false	false
0ef5a795-391d-446c-b4d6-c75488f2c187	2026-09-01 11:53	2026-09-01 11:53	2026-09-01 11:53	HSBC	HSBC261218P00100000	put	100.0000	2026-12-18	3.6000	3.6000	3.8000	103.9200	88200.00	0.00	88200.00	245	7	245	1090	0.224770642201835	0.263171596590693	0.263498037125071	false	false	false
f0376fb3-1797-442e-9c8d-f0dc88817fc4	2026-08-28 10:09	2026-08-28 10:09	2026-08-28 10:09	HSBC	HSBC260918C00099000	call	99.0000	2026-09-18	5.8800	5.8000	6.1000	103.6800	92390.00	26550.00	65840.00	157	11	157	0	0	0.288698343109246	0.288698343109246	false	false	false	true
31e83f3a-3c88-4fef-82e0-9ba33920e7c5	2026-08-24 13:20	2026-08-24 13:19	2026-08-24 13:19	HSBC	HSBC260918P00105000	put	105.0000	2026-09-18	2.6000	2.4500	2.6000	104.5400	64995.00	64740.00	255.00	250	28	251	212	1.18396226415094	0.229366512089825	0.229366512089825	false	false	false
080a111e-96bb-43ba-8fc6-d905e4533c78	2026-08-20 10:53	2026-08-20 10:53	2026-08-20 10:53	HSBC	HSBC270319C00105000	call	105.0000	2027-03-19	7.9000	7.7000	8.0000	103.2600	146939.00	116129.00	30810.00	186	13	881	887	0.993235625704622	0.24266145389463	0.24266145389463	false	false	false
7dd03f09-4f79-4344-8289-974984b41e13	2026-08-20 10:39	2026-08-20 10:39	2026-08-20 10:39	HSBC	HSBC270319C00105000	call	105.0000	2027-03-19	7.9000	7.7000	7.9000	103.1100	158000.00	158000.00	0.00	200	6	632	887	0.712514092446449	0.245313235614076	0.245313235614076	false	false	false
d31158ae-6f8d-45b6-a7a8-3c5c28efc046	2026-08-20 09:58	2026-08-20 09:57	2026-08-20 09:57	HSBC	HSBC270319C00105000	call	105.0000	2027-03-19	7.8000	7.5000	8.0000	102.9600	60052.00	55372.00	3900.00	77	24	332	887	0.374295377677565	0.244379740418275	0.244730757799651	true	false	false
b88bcc3f-5943-48e8-baa0-34c9ed8cd211	2026-08-19 11:20	2026-08-19 11:20	2026-08-19 11:20	HSBC	HSBC270319C00105000	call	105.0000	2027-03-19	7.7000	7.4000	7.7000	102.5000	154000.00	154000.00	0.00	200	23	950	227	4.18502202643172	0.248851704013777	0.248851704013777	false	false	false
367900f0-fd2f-42f4-9c95-169eef77f5aa	2026-08-19 10:05	2026-08-19 10:05	2026-08-19 10:05	HSBC	HSBC270319P00100000	put	100.0000	2027-03-19	6.8000	6.8000	6.9000	103.3600	68000.00	0.00	68000.00	100	11	327	228	1.43421052631579	0.306834615444971	0.306834615444971	false	false	false
4f9afd4f-d221-4e1b-bffa-f242dbf16066	2026-08-19 10:05	2026-08-19 10:04	2026-08-19 10:04	HSBC	HSBC270319P00100000	put	100.0000	2027-03-19	6.8000	6.5000	6.9000	103.3400	103360.00	68680.00	34680.00	152	6	227	228	0.995614035087719	0.306590031445652	0.306590031445652	false	false	false
58d072ce-0276-4769-a77f-d07118658595	2026-08-19 10:04	2026-08-19 10:04	2026-08-19 10:04	HSBC	HSBC270319C00105000	call	105.0000	2027-03-19	8.1000	7.8000	8.2000	103.3400	166842.00	166842.00	0.00	206	23	650	227	2.86343612334802	0.247012250017272	0.247012250017272	false	false	false
44cef705-6eb9-4171-b48d-bac99859b5bd	2026-08-19 09:56	2026-08-19 09:56	2026-08-19 09:56	HSBC	HSBC270319C00105000	call	105.0000	2027-03-19	8.0000	7.9000	8.1000	103.3900	60800.00	7200.00	35200.00	76	13	291	227	1.28193832599119	0.242914050467015	0.242914050467015	true	false	false
193e70e4-117f-4491-8e88-80512a809c20	2026-08-18 14:23	2026-08-18 14:23	2026-08-18 14:23	HSBC	HSBC270617P00090000	put	90.0000	2027-06-17	4.6000	4.5000	4.9000	103.0000	64860.00	50140.00	14720.00	141	12	441	604	0.730132450331126	0.312724767587309	0.312724767587309	false	false	false
3bd9cc3d-62a3-4f57-83c9-49ad33d6bad8	2026-08-18 11:10	2026-08-18 11:09	2026-08-18 11:09	HSBC	HSBC261218C00110000	call	110.0000	2026-12-18	3.4900	3.0000	3.5000	103.1400	69854.00	69854.00	0.00	200	23	502	429	1.17016317016317	0.234861331752478	0.238278662185164	false	false	false