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,438,832,065 90,646,420,097 1,323,135,895 1.000
2 7552 XI2CSOPHSTECH CSOP Asset Management Limited Equity 558,089,312 35,159,626,650 489,593,900 1.000
3 2800 TRACKER FUND Hang Seng Investment Management Limited Equity 541,739,769 34,129,605,433 498,794,543 1.000
4 7226 XL2CSOPHSTECH CSOP Asset Management Limited Equity 222,902,218 14,042,839,713 207,527,646 1.000
5 7500 FI2 CSOP HSI CSOP Asset Management Limited Equity 172,591,598 10,873,270,704 154,560,400 1.000
6 2828 HSCEI ETF Hang Seng Investment Management Limited Equity 85,423,320 5,381,669,175 82,251,450 1.000
7 7200 FL2 CSOP HSI CSOP Asset Management Limited Equity 40,959,594 2,580,454,428 37,657,200 1.000
8 3032 HSTECH ETF Hang Seng Investment Management Limited Equity 39,003,682 2,457,231,949 36,177,238 1.000
9 3067 ISHARESHSTECH BlackRock Asset Management North Asia Limited Equity 35,304,585 2,224,188,855 28,126,427 1.000
10 3416 A GX HSCEICC Mirae Asset Global Investments (Hong Kong) Limited Equity 28,130,622 1,772,229,208 20,933,503 1.000
11 7709 XL2CSOPHYNIX CSOP Asset Management Limited Equity 22,522,740 991,000,565 20,118,806 1.000
12 7568 FI2CSOPNASDAQ CSOP Asset Management Limited Equity 7,342,008 462,546,474 5,337,400 1.000
13 3417 A GX HSTCC Mirae Asset Global Investments (Hong Kong) Limited Equity 6,590,576 415,206,276 5,296,000 1.000
14 2823 ISHARES A50 BlackRock Asset Management North Asia Limited Equity 6,157,102 387,897,412 4,912,431 1.000
15 3088 CAM HS TECH China Asset Management (Hong Kong) Limited Equity 5,573,622 351,138,205 607,200 1.000
16 3466 HS HIGH DIV Hang Seng Investment Management Limited Equity 4,611,235 290,507,815 3,933,205 1.000
17 2802 A CSOP HSCEICC CSOP Asset Management Limited Equity 3,013,900 15,069,500 2,838,400 1.000
18 2822 CSOP A50 ETF CSOP Asset Management Limited Equity 2,790,634 175,809,938 2,532,510 1.000
19 7288 FL2 CSOP HSCEI CSOP Asset Management Limited Equity 2,544,044 160,274,800 2,228,500 1.000
20 7588 FI2 CSOP HSCEI CSOP Asset Management Limited Equity 2,435,730 153,451,004 2,361,400 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,438,832,065 1,323,135,895 3,737,847,066 619,644,746 63 63 1.000
2 7552 XI2CSOPHSTECH CSOP Asset Management Limited Equity China Sector - Technology 558,089,312 489,593,900 1,642,927,600 204,418,300 63 63 1.000
3 2800 TRACKER FUND Hang Seng Investment Management Limited Equity Hong Kong Broad market 541,739,769 498,794,543 1,317,057,344 164,529,440 63 63 1.000
4 7226 XL2CSOPHSTECH CSOP Asset Management Limited Equity China Sector - Technology 222,902,218 207,527,646 568,560,803 98,927,500 63 63 1.000
5 7500 FI2 CSOP HSI CSOP Asset Management Limited Equity Hong Kong Broad market 172,591,598 154,560,400 513,130,020 77,465,900 63 63 1.000
6 2828 HSCEI ETF Hang Seng Investment Management Limited Equity China Broad market 85,423,320 82,251,450 215,719,406 16,747,067 63 63 1.000
7 7200 FL2 CSOP HSI CSOP Asset Management Limited Equity Hong Kong Broad market 40,959,594 37,657,200 100,193,500 18,005,900 63 63 1.000
8 3032 HSTECH ETF Hang Seng Investment Management Limited Equity China Sector - Technology 39,003,682 36,177,238 112,942,136 12,850,698 63 63 1.000
9 3067 ISHARESHSTECH BlackRock Asset Management North Asia Limited Equity China Sector - Technology 35,304,585 28,126,427 206,309,214 11,363,530 63 63 1.000
10 3416 A GX HSCEICC Mirae Asset Global Investments (Hong Kong) Limited Equity China Strategic beta 28,130,622 20,933,503 141,122,152 6,257,086 63 63 1.000
11 7709 XL2CSOPHYNIX CSOP Asset Management Limited Equity Korea Single Asset 22,522,740 20,118,806 75,195,000 1,651,400 44 44 1.000
12 7568 FI2CSOPNASDAQ CSOP Asset Management Limited Equity United States of America Sector - Technology 7,342,008 5,337,400 30,814,198 1,973,950 63 63 1.000
13 3417 A GX HSTCC Mirae Asset Global Investments (Hong Kong) Limited Equity China Strategic beta 6,590,576 5,296,000 20,898,659 1,218,000 63 63 1.000
14 2823 ISHARES A50 BlackRock Asset Management North Asia Limited Equity China Broad market 6,157,102 4,912,431 33,194,642 870,736 63 63 1.000
15 3088 CAM HS TECH China Asset Management (Hong Kong) Limited Equity China Sector - Technology 5,573,622 607,200 61,255,600 88,829 63 63 1.000
16 3466 HS HIGH DIV Hang Seng Investment Management Limited Equity Hong Kong Strategic beta 4,611,235 3,933,205 13,022,696 2,226,400 63 63 1.000
17 2802 A CSOP HSCEICC CSOP Asset Management Limited Equity China Strategic beta 3,013,900 2,838,400 5,961,800 961,500 5 5 1.000
18 2822 CSOP A50 ETF CSOP Asset Management Limited Equity China Broad market 2,790,634 2,532,510 6,652,966 611,683 63 63 1.000
19 7288 FL2 CSOP HSCEI CSOP Asset Management Limited Equity China Broad market 2,544,044 2,228,500 8,617,800 783,200 63 63 1.000
20 7588 FI2 CSOP HSCEI CSOP Asset Management Limited Equity China Broad market 2,435,730 2,361,400 5,516,900 528,000 63 63 1.000

Report generated: 2025-12-18 10:34:46.505118