Data Snapshot Report

This report summarizes the cached ETF data stored in the package. The targets pipeline only downloads missing data or missing date ranges.

Snapshot Overview

Show Code

if (data_loaded && !is.null(universe)) {
  cat("Snapshot generated at:", format(snapshot_info$generated_at), "\n")
  cat("Source:", snapshot_info$source, "\n\n")
  cat("Tickers:", nrow(universe), "\n")
}

Snapshot generated at: 2025-12-22 16:38:06 
Source: curated 

Tickers: 20

Show Code

if (data_loaded && !is.null(history) && nrow(history) > 0) {
  cat("Total rows:", nrow(history), "\n")
  cat("Date range:", format(min(history$date)), "to", format(max(history$date)), "\n")
}

Total rows: 1432620 
Date range: 2008-01-02 to 2025-12-19

Coverage Summary

Show Code

if (data_loaded && !is.null(history_summary) && nrow(history_summary) > 0) {
  ok_count <- sum(history_summary$ok, na.rm = TRUE)
  total <- nrow(history_summary)
  cat("Complete coverage:", ok_count, "/", total, "\n")
  cat("Missing coverage:", total - ok_count, "\n\n")
  print(head(history_summary, 10))
}

Complete coverage: 0 / 20 
Missing coverage: 20 

# A tibble: 10 × 10
   ticker  rows rows_added min_date   max_date   expected_start expected_end
   <chr>  <int>      <int> <date>     <date>     <date>         <date>      
 1 VUSA.L 71631          0 2008-01-02 2025-12-19 2000-01-01     2025-12-22  
 2 CSPX.L 71631          0 2008-01-02 2025-12-19 2000-01-01     2025-12-22  
 3 INRG.L 71631          0 2008-01-02 2025-12-19 2000-01-01     2025-12-22  
 4 EQQQ.L 71631          0 2008-01-02 2025-12-19 2000-01-01     2025-12-22  
 5 VWRL.L 71631          0 2008-01-02 2025-12-19 2000-01-01     2025-12-22  
 6 ISF.L  71631          0 2008-01-02 2025-12-19 2000-01-01     2025-12-22  
 7 VMID.L 71631          0 2008-01-02 2025-12-19 2000-01-01     2025-12-22  
 8 VFEM.L 71631          0 2008-01-02 2025-12-19 2000-01-01     2025-12-22  
 9 VEVE.L 71631          0 2008-01-02 2025-12-19 2000-01-01     2025-12-22  
10 VGOV.L 71631          0 2008-01-02 2025-12-19 2000-01-01     2025-12-22  
# ℹ 3 more variables: missing_start <date>, missing_end <date>, ok <lgl>

Missing Data

Show Code

if (data_loaded && !is.null(history_summary) && nrow(history_summary) > 0) {
  missing <- history_summary %>%
    dplyr::filter(!.data$ok | .data$rows == 0)
  if (nrow(missing) == 0) {
    print("No missing coverage detected.")
  } else {
    print(head(missing, 20))
  }
}

# A tibble: 20 × 10
   ticker  rows rows_added min_date   max_date   expected_start expected_end
   <chr>  <int>      <int> <date>     <date>     <date>         <date>      
 1 VUSA.L 71631          0 2008-01-02 2025-12-19 2000-01-01     2025-12-22  
 2 CSPX.L 71631          0 2008-01-02 2025-12-19 2000-01-01     2025-12-22  
 3 INRG.L 71631          0 2008-01-02 2025-12-19 2000-01-01     2025-12-22  
 4 EQQQ.L 71631          0 2008-01-02 2025-12-19 2000-01-01     2025-12-22  
 5 VWRL.L 71631          0 2008-01-02 2025-12-19 2000-01-01     2025-12-22  
 6 ISF.L  71631          0 2008-01-02 2025-12-19 2000-01-01     2025-12-22  
 7 VMID.L 71631          0 2008-01-02 2025-12-19 2000-01-01     2025-12-22  
 8 VFEM.L 71631          0 2008-01-02 2025-12-19 2000-01-01     2025-12-22  
 9 VEVE.L 71631          0 2008-01-02 2025-12-19 2000-01-01     2025-12-22  
10 VGOV.L 71631          0 2008-01-02 2025-12-19 2000-01-01     2025-12-22  
11 IGLT.L 71631          0 2008-01-02 2025-12-19 2000-01-01     2025-12-22  
12 IUHC.L 71631          0 2008-01-02 2025-12-19 2000-01-01     2025-12-22  
13 IITU.L 71631          0 2008-01-02 2025-12-19 2000-01-01     2025-12-22  
14 IWDA.L 71631          0 2008-01-02 2025-12-19 2000-01-01     2025-12-22  
15 EMIM.L 71631          0 2008-01-02 2025-12-19 2000-01-01     2025-12-22  
16 IUSA.L 71631          0 2008-01-02 2025-12-19 2000-01-01     2025-12-22  
17 HMCH.L 71631          0 2008-01-02 2025-12-19 2000-01-01     2025-12-22  
18 SJPA.L 71631          0 2008-01-02 2025-12-19 2000-01-01     2025-12-22  
19 CPXJ.L 71631          0 2008-01-02 2025-12-19 2000-01-01     2025-12-22  
20 VERX.L 71631          0 2008-01-02 2025-12-19 2000-01-01     2025-12-22  
# ℹ 3 more variables: missing_start <date>, missing_end <date>, ok <lgl>

Recently Added Rows

Show Code

if (data_loaded && !is.null(history_summary) && nrow(history_summary) > 0) {
  recent <- history_summary %>%
    dplyr::filter(.data$rows_added > 0) %>%
    dplyr::arrange(dplyr::desc(.data$rows_added))
  if (nrow(recent) == 0) {
    print("No new rows were added in this snapshot.")
  } else {
    print(head(recent, 20))
  }
}

[1] "No new rows were added in this snapshot."

Session Info

Show Code

sessionInfo()

R version 4.6.1 (2026-06-24)
Platform: x86_64-pc-linux-gnu
Running under: Ubuntu 26.04 LTS

Matrix products: default
BLAS:   /usr/lib/x86_64-linux-gnu/openblas-pthread/libblas.so.3 
LAPACK: /usr/lib/x86_64-linux-gnu/openblas-pthread/libopenblasp-r0.3.32.so;  LAPACK version 3.12.0

locale:
 [1] LC_CTYPE=en_US.UTF-8       LC_NUMERIC=C              
 [3] LC_TIME=en_US.UTF-8        LC_COLLATE=en_US.UTF-8    
 [5] LC_MONETARY=en_US.UTF-8    LC_MESSAGES=en_US.UTF-8   
 [7] LC_PAPER=en_US.UTF-8       LC_NAME=C                 
 [9] LC_ADDRESS=C               LC_TELEPHONE=C            
[11] LC_MEASUREMENT=en_US.UTF-8 LC_IDENTIFICATION=C       

time zone: Etc/UTC
tzcode source: system (glibc)

attached base packages:
[1] stats     graphics  grDevices utils     datasets  methods   base     

other attached packages:
[1] readr_2.2.0        dplyr_1.2.1        etfdata_0.0.0.9000

loaded via a namespace (and not attached):
 [1] utf8_1.2.6       generics_0.1.4   xml2_1.6.0       stringi_1.8.7   
 [5] lattice_0.22-9   hms_1.1.4        digest_0.6.39    magrittr_2.0.5  
 [9] evaluate_1.0.5   grid_4.6.1       timechange_0.4.0 fastmap_1.2.0   
[13] jsonlite_2.0.0   httr_1.4.8       rvest_1.0.5      purrr_1.2.2     
[17] httr2_1.3.0      cli_3.6.6        rlang_1.3.0      yaml_2.3.12     
[21] otel_0.2.0       tools_4.6.1      tzdb_0.5.0       curl_7.1.0      
[25] buildtools_1.0.0 vctrs_0.7.3      logger_0.4.2     R6_2.6.1        
[29] zoo_1.8-15       lifecycle_1.0.5  lubridate_1.9.5  snakecase_0.11.1
[33] stringr_1.6.0    janitor_2.2.1    pkgconfig_2.0.3  pillar_1.11.1   
[37] glue_1.8.1       quantmod_0.4.29  xfun_0.60        tibble_3.3.1    
[41] tidyselect_1.2.1 sys_3.4.3        knitr_1.51       htmltools_0.5.9 
[45] rmarkdown_2.31   xts_0.14.2       maketools_1.3.2  compiler_4.6.1  
[49] TTR_0.24.4