Top 20 high vol summary

top_etfs %>%
  select(rank, stock_code, stock_short_name, issuer, asset_class,
         avg_volume, total_volume, median_volume, trading_frequency) %>%
  gt() %>%
  tab_header(
    title = paste("Top", TOP_N, "Highest Volume ETFs"),
    subtitle = "Ranked by Average Daily Volume"
  ) %>%
  fmt_number(columns = avg_volume, decimals = 0, use_seps = TRUE) %>%
  fmt_number(columns = total_volume, decimals = 0, use_seps = TRUE) %>%
  fmt_number(columns = median_volume, decimals = 0, use_seps = TRUE) %>%
  fmt_number(columns = trading_frequency, decimals = 3) %>%
  cols_label(
    rank = "Rank",
    stock_code = "Stock Code",
    stock_short_name = "Name",
    issuer = "Issuer",
    asset_class = "Asset Class",
    avg_volume = "Avg Volume",
    total_volume = "Total Volume",
    median_volume = "Median Volume",
    trading_frequency = "Trading Frequency"
  ) %>%
  tab_style(
    style = cell_text(weight = "bold"),
    locations = cells_column_labels()
  ) %>%
  tab_style(
    style = cell_text(align = "right"),
    locations = cells_body(columns = c(rank, avg_volume, total_volume, median_volume, trading_frequency))
  ) %>%
  opt_table_font(font = "Arial") %>%
  tab_options(
    table.width = pct(100),
    column_labels.background.color = "#f8f9fa",
    table_body.hlines.color = "#e9ecef",
    heading.border.bottom.color = "#dee2e6"
  )
Top 20 Highest Volume ETFs
Ranked by Average Daily Volume
Rank Stock Code Name Issuer Asset Class Avg Volume Total Volume Median Volume Trading Frequency
1 3033 CSOP HS TECH CSOP Asset Management Limited Equity 1,434,752,089 88,954,629,524 1,318,512,941 1.000
2 7552 XI2CSOPHSTECH CSOP Asset Management Limited Equity 562,372,849 34,867,116,647 491,870,900 1.000
3 2800 TRACKER FUND Hang Seng Investment Management Limited Equity 542,322,622 33,624,002,548 496,805,896 1.000
4 7226 XL2CSOPHSTECH CSOP Asset Management Limited Equity 223,523,023 13,858,427,422 209,774,798 1.000
5 7500 FI2 CSOP HSI CSOP Asset Management Limited Equity 173,662,682 10,767,086,302 157,387,955 1.000
6 2828 HSCEI ETF Hang Seng Investment Management Limited Equity 85,373,378 5,293,149,424 79,694,464 1.000
7 7200 FL2 CSOP HSI CSOP Asset Management Limited Equity 40,908,678 2,536,338,028 37,532,950 1.000
8 3032 HSTECH ETF Hang Seng Investment Management Limited Equity 39,231,854 2,432,374,964 36,311,571 1.000
9 3067 ISHARESHSTECH BlackRock Asset Management North Asia Limited Equity 35,560,440 2,204,747,299 28,141,806 1.000
10 3416 A GX HSCEICC Mirae Asset Global Investments (Hong Kong) Limited Equity 28,158,498 1,745,826,876 20,831,648 1.000
11 7709 XL2CSOPHYNIX CSOP Asset Management Limited Equity 22,699,288 976,069,365 20,252,100 1.000
12 7568 FI2CSOPNASDAQ CSOP Asset Management Limited Equity 7,350,925 455,757,324 5,321,500 1.000
13 3417 A GX HSTCC Mirae Asset Global Investments (Hong Kong) Limited Equity 6,605,045 409,512,776 5,250,750 1.000
14 2823 ISHARES A50 BlackRock Asset Management North Asia Limited Equity 6,191,583 383,878,158 4,943,147 1.000
15 3088 CAM HS TECH China Asset Management (Hong Kong) Limited Equity 5,657,584 350,770,205 626,400 1.000
16 3466 HS HIGH DIV Hang Seng Investment Management Limited Equity 4,639,109 287,624,764 3,969,902 1.000
17 2802 A CSOP HSCEICC CSOP Asset Management Limited Equity 3,527,000 14,108,000 2,920,300 1.000
18 2822 CSOP A50 ETF CSOP Asset Management Limited Equity 2,790,672 173,021,649 2,526,355 1.000
19 7288 FL2 CSOP HSCEI CSOP Asset Management Limited Equity 2,557,689 158,576,700 2,234,250 1.000
20 7588 FI2 CSOP HSCEI CSOP Asset Management Limited Equity 2,435,639 151,009,600 2,309,300 1.000

Closing Price plots

# Get stock codes for top ETFs
top_stock_codes <- top_etfs$stock_code

# Load closing price data for top ETFs
closing_price_data <- etf_daily %>%
  filter(stock_code %in% top_stock_codes) %>%
  select(stock_code, trade_date, closing_price) %>%
  collect() %>%
  mutate(
    trade_date = as.Date(trade_date)
  ) %>%
  filter(!is.na(closing_price)) %>%
  arrange(stock_code, trade_date) %>%
  # Join with master data to get names for labels
  left_join(
    top_etfs %>% select(stock_code, stock_short_name, rank),
    by = "stock_code"
  ) %>%
  # Create label for facet
  mutate(
    etf_label = paste0(rank, ". ", stock_code, " - ", stock_short_name)
  ) %>%
  # Order by rank
  arrange(rank, trade_date)

# Create faceted plot - use 3 columns for better mobile viewing
ggplot(closing_price_data, aes(x = trade_date, y = closing_price)) +
  geom_line(color = "#007bff", size = 0.6) +
  geom_point(color = "#007bff", size = 0.3, alpha = 0.5) +
  facet_wrap(~ reorder(etf_label, rank), scales = "free_y", ncol = 3) +
  labs(
    title = paste("Closing Price Trends - Top", TOP_N, "Highest Volume ETFs"),
    subtitle = "Each panel shows the price trend for one ETF",
    x = "Date",
    y = "Closing Price (HKD)",
    caption = "ETFs are ordered by average daily volume (highest to lowest)"
  ) +
  theme_minimal() +
  theme(
    plot.title = element_text(size = 16, face = "bold"),
    plot.subtitle = element_text(size = 12, color = "gray50"),
    axis.title = element_text(size = 11),
    axis.text = element_text(size = 8),
    axis.text.x = element_text(angle = 45, hjust = 1),
    plot.caption = element_text(size = 9, color = "gray60", hjust = 0),
    panel.grid.minor = element_blank(),
    strip.text = element_text(size = 8, face = "bold"),
    strip.background = element_rect(fill = "#f8f9fa", color = "#e9ecef")
  ) +
  scale_x_date(date_labels = "%Y-%m", date_breaks = "6 months") +
  scale_y_continuous(labels = scales::number_format(accuracy = 0.01))

Detailed Statistics Table

top_etfs %>%
  select(rank, stock_code, stock_short_name, issuer, asset_class, 
         geographic_focus, investment_focus,
         avg_volume, median_volume, max_volume, min_volume,
         total_days, days_with_volume, trading_frequency) %>%
  gt() %>%
  tab_header(
    title = paste("Detailed Statistics - Top", TOP_N, "Highest Volume ETFs")
  ) %>%
  fmt_number(columns = c(avg_volume, median_volume, max_volume, min_volume), 
             decimals = 0, use_seps = TRUE) %>%
  fmt_number(columns = c(total_days, days_with_volume), 
             decimals = 0, use_seps = FALSE) %>%
  fmt_number(columns = trading_frequency, decimals = 3) %>%
  cols_label(
    rank = "Rank",
    stock_code = "Stock Code",
    stock_short_name = "Name",
    issuer = "Issuer",
    asset_class = "Asset Class",
    geographic_focus = "Geographic Focus",
    investment_focus = "Investment Focus",
    avg_volume = "Avg Volume",
    median_volume = "Median Volume",
    max_volume = "Max Volume",
    min_volume = "Min Volume",
    total_days = "Total Days",
    days_with_volume = "Days w/ Volume",
    trading_frequency = "Trading Frequency"
  ) %>%
  tab_style(
    style = cell_text(weight = "bold"),
    locations = cells_column_labels()
  ) %>%
  tab_style(
    style = cell_text(align = "right"),
    locations = cells_body(columns = c(rank, avg_volume, median_volume, max_volume, 
                                       min_volume, total_days, days_with_volume, trading_frequency))
  ) %>%
  opt_table_font(font = "Arial") %>%
  tab_options(
    table.width = pct(100),
    column_labels.background.color = "#f8f9fa",
    table_body.hlines.color = "#e9ecef",
    heading.border.bottom.color = "#dee2e6",
    table.font.size = px(11)
  )
Detailed Statistics - Top 20 Highest Volume ETFs
Rank Stock Code Name Issuer Asset Class Geographic Focus Investment Focus Avg Volume Median Volume Max Volume Min Volume Total Days Days w/ Volume Trading Frequency
1 3033 CSOP HS TECH CSOP Asset Management Limited Equity China Sector - Technology 1,434,752,089 1,318,512,941 3,737,847,066 619,644,746 62 62 1.000
2 7552 XI2CSOPHSTECH CSOP Asset Management Limited Equity China Sector - Technology 562,372,849 491,870,900 1,642,927,600 204,418,300 62 62 1.000
3 2800 TRACKER FUND Hang Seng Investment Management Limited Equity Hong Kong Broad market 542,322,622 496,805,896 1,317,057,344 164,529,440 62 62 1.000
4 7226 XL2CSOPHSTECH CSOP Asset Management Limited Equity China Sector - Technology 223,523,023 209,774,798 568,560,803 98,927,500 62 62 1.000
5 7500 FI2 CSOP HSI CSOP Asset Management Limited Equity Hong Kong Broad market 173,662,682 157,387,955 513,130,020 77,465,900 62 62 1.000
6 2828 HSCEI ETF Hang Seng Investment Management Limited Equity China Broad market 85,373,378 79,694,464 215,719,406 16,747,067 62 62 1.000
7 7200 FL2 CSOP HSI CSOP Asset Management Limited Equity Hong Kong Broad market 40,908,678 37,532,950 100,193,500 18,005,900 62 62 1.000
8 3032 HSTECH ETF Hang Seng Investment Management Limited Equity China Sector - Technology 39,231,854 36,311,571 112,942,136 12,850,698 62 62 1.000
9 3067 ISHARESHSTECH BlackRock Asset Management North Asia Limited Equity China Sector - Technology 35,560,440 28,141,806 206,309,214 11,363,530 62 62 1.000
10 3416 A GX HSCEICC Mirae Asset Global Investments (Hong Kong) Limited Equity China Strategic beta 28,158,498 20,831,648 141,122,152 6,257,086 62 62 1.000
11 7709 XL2CSOPHYNIX CSOP Asset Management Limited Equity Korea Single Asset 22,699,288 20,252,100 75,195,000 1,651,400 43 43 1.000
12 7568 FI2CSOPNASDAQ CSOP Asset Management Limited Equity United States of America Sector - Technology 7,350,925 5,321,500 30,814,198 1,973,950 62 62 1.000
13 3417 A GX HSTCC Mirae Asset Global Investments (Hong Kong) Limited Equity China Strategic beta 6,605,045 5,250,750 20,898,659 1,218,000 62 62 1.000
14 2823 ISHARES A50 BlackRock Asset Management North Asia Limited Equity China Broad market 6,191,583 4,943,147 33,194,642 870,736 62 62 1.000
15 3088 CAM HS TECH China Asset Management (Hong Kong) Limited Equity China Sector - Technology 5,657,584 626,400 61,255,600 88,829 62 62 1.000
16 3466 HS HIGH DIV Hang Seng Investment Management Limited Equity Hong Kong Strategic beta 4,639,109 3,969,902 13,022,696 2,226,400 62 62 1.000
17 2802 A CSOP HSCEICC CSOP Asset Management Limited Equity China Strategic beta 3,527,000 2,920,300 5,961,800 2,305,600 4 4 1.000
18 2822 CSOP A50 ETF CSOP Asset Management Limited Equity China Broad market 2,790,672 2,526,355 6,652,966 611,683 62 62 1.000
19 7288 FL2 CSOP HSCEI CSOP Asset Management Limited Equity China Broad market 2,557,689 2,234,250 8,617,800 783,200 62 62 1.000
20 7588 FI2 CSOP HSCEI CSOP Asset Management Limited Equity China Broad market 2,435,639 2,309,300 5,516,900 528,000 62 62 1.000

Report generated: 2025-12-17 09:47:49.417622