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.

728,802 rows

Sources in this table

uw_flow_alerts728,802 rows

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:alert_rule = RepeatedHits×sector = Technology×ticker = SONY×

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

c3f5874d-f0b3-4751-a83b-bcdbc5b4dade	2026-10-02 15:11	2026-10-02 15:11	2026-10-02 15:11	SONY	SONY261009C00024000	call	24.0000	2026-10-09	0.2200	0.2000	0.2500	23.7550	11000.00	0.00	11000.00	500	5	561	27	20.7777777777778	0.243084127652321	0.243084127652321	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ADR	Technology	140720633990.00	2026-11-10	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-10-02T19:15:21.750665Z"}	2026-10-02	2026-10-02 21:15	2026-10-02 21:15
71bb6e5d-9b11-4bd7-b4a1-b46de932d1a3	2026-09-24 15:06	2026-09-24 15:06	2026-09-24 15:06	SONY	SONY261218C00025000	call	25.0000	2026-12-18	0.7400	0.7000	0.8000	22.9550	14948.00	0.00	14948.00	202	5	514	25617	0.020064800718273	0.320224366320979	0.320224366320979	false	false	false	true
cf69bf5f-a952-40ad-a662-6bb59e5d90c1	2026-09-23 14:18	2026-09-23 14:17	2026-09-23 14:17	SONY	SONY261218C00027500	call	27.5000	2026-12-18	0.4000	0.2500	0.4500	23.2600	25800.00	25800.00	0.00	645	7	646	15833	0.0408008589654519	0.347789737586263	0.347789737586263	false	false	false	true
2371a040-2d77-4f23-9577-153e2df7eecf	2026-09-22 11:57	2026-09-22 11:57	2026-09-22 11:57	SONY	SONY270115C00022500	call	22.5000	2027-01-15	2.2500	2.2500	2.6500	23.4550	31500.00	0.00	31500.00	140	14	142	4262	0.0333176912247771	0.302082042200338	0.302082042200338	false	false	false	true
b9340d5f-04ca-4776-a149-8114b2cf3601	2026-09-01 09:34	2026-09-01 09:34	2026-09-01 09:34	SONY	SONY261218C00025000	call	25.0000	2026-12-18	1.9000	1.8000	1.9000	24.9450	76950.00	76950.00	0.00	405	7	450	24887	0.0180817294169647	0.330721877011237	0.330721877011237	false	false	false	true
5f16c758-d3aa-4a6a-8f07-9c43363786cb	2026-08-26 11:03	2026-08-26 11:03	2026-08-26 11:03	SONY	SONY280121C00027500	call	27.5000	2028-01-21	2.9000	2.6500	3.2000	24.1650	101501.00	14500.00	87001.00	350	20	350	903	0.387596899224806	0.315609398737997	0.315784171890179	false	false	false	true
6eff7f49-9dd5-47b2-b09b-8b45a6e0fdff	2026-08-20 13:56	2026-08-20 13:56	2026-08-20 13:56	SONY	SONY270115C00025000	call	25.0000	2027-01-15	1.4500	1.4500	1.5500	23.6450	101067.00	0.00	101067.00	697	40	1035	15892	0.0651271079788573	0.307535346512068	0.309072056493398	true	false	false	true
d2982494-8c50-4146-ac80-849ca6e10c3b	2026-08-17 11:00	2026-08-17 11:00	2026-08-17 11:00	SONY	SONY261218P00022500	put	22.5000	2026-12-18	1.1000	1.1000	1.2000	23.6350	64900.00	0.00	64900.00	590	15	3313	259	12.7915057915058	0.325078020171589	0.325078020171589	false	false	false	true