PREVIEW / etf_daily / 2025-01-22
file: by_date/etf_daily/2025/2025-01-22.parquet size: 147 KB rows: 3,887
schema
date DATE symbol VARCHAR asset_type VARCHAR open DOUBLE high DOUBLE low DOUBLE close DOUBLE volume DOUBLE
sample rows
| date | symbol | asset_type | open | high | low | close | volume |
|---|---|---|---|---|---|---|---|
| 2025-01-22 | SPY | ETF | 605.92 | 607.82 | 605.36 | 606.44 | 46966354.0 |
| 2025-01-22 | QQQ | ETF | 529.57 | 533.82 | 529.26 | 531.51 | 33592988.0 |
| 2025-01-22 | IWM | ETF | 229.35 | 229.85 | 227.83 | 228.29 | 19764093.0 |
| 2025-01-22 | DIA | ETF | 441.49 | 442.0 | 440.3501 | 441.28 | 3207409.0 |
| 2025-01-22 | GLD | ETF | 254.29 | 254.68 | 253.7801 | 254.43 | 5209316.0 |
| 2025-01-22 | TLT | ETF | 87.87 | 87.98 | 87.32 | 87.51 | 24560488.0 |
| 2025-01-22 | AAA | ETF | 25.16 | 25.24 | 25.16 | 25.195 | 58597.0 |
| 2025-01-22 | AAAU | ETF | 27.32 | 27.32 | 27.19 | 27.255 | 1726060.0 |
| 2025-01-22 | AADR | ETF | 75.27 | 75.27 | 74.17 | 74.58 | 2074.0 |
| 2025-01-22 | AAPB | ETF | 25.8 | 26.78 | 25.8 | 26.74 | 369974.0 |
| 2025-01-22 | AAPD | ETF | 17.38 | 17.38 | 17.055 | 17.07 | 907956.0 |
| 2025-01-22 | AAPR | ETF | 26.62 | 26.66 | 26.62 | 26.655 | 1554.0 |
| 2025-01-22 | AAPU | ETF | 28.73 | 29.8 | 28.73 | 29.76 | 3381933.0 |
| 2025-01-22 | AAPX | ETF | 24.6 | 25.53 | 24.6 | 25.44 | 159324.0 |
| 2025-01-22 | AAPY | ETF | 24.36 | 24.5507 | 24.3 | 24.5507 | 8501.0 |
| 2025-01-22 | AAXJ | ETF | 72.6 | 72.65 | 72.33 | 72.49 | 268758.0 |
| 2025-01-22 | ABCS | ETF | 29.705 | 29.74 | 29.6432 | 29.6432 | 2168.0 |
| 2025-01-22 | ABEQ | ETF | 32.62 | 32.62 | 32.43 | 32.43 | 2696.0 |
| 2025-01-22 | ABFL | ETF | 68.78 | 68.78 | 68.6811 | 68.6811 | 5128.0 |
| 2025-01-22 | ABHY | ETF | 19.12 | 19.12 | 19.105 | 19.105 | 315.0 |
| 2025-01-22 | ABLD | ETF | 29.3457 | 29.3457 | 29.3457 | 29.3457 | 382.0 |
| 2025-01-22 | ABLG | ETF | 29.5 | 29.54 | 29.4396 | 29.4396 | 3144.0 |
| 2025-01-22 | ABNY | ETF | 73.95 | 74.5695 | 73.25 | 73.25 | 654.0 |
| 2025-01-22 | ABOT | ETF | 37.26 | 37.26 | 37.2494 | 37.2494 | 158.0 |
| 2025-01-22 | ACES | ETF | 26.22 | 26.22 | 25.47 | 25.47 | 92914.0 |
| 2025-01-22 | ACGR | ETF | 59.82 | 60.665 | 59.57 | 59.57 | 25044.0 |
| 2025-01-22 | ACIO | ETF | 41.205 | 41.34 | 41.175 | 41.25 | 108266.0 |
| 2025-01-22 | ACLC | ETF | 73.08 | 73.195 | 73.0234 | 73.0234 | 1133.0 |
| 2025-01-22 | ACSI | ETF | 62.1392 | 62.1392 | 62.1392 | 62.1392 | 14.0 |
| 2025-01-22 | ACT | ETF | 32.9 | 33.33 | 32.765 | 33.1 | 267923.0 |
| 2025-01-22 | ACTV | ETF | 33.12 | 33.12 | 32.7 | 32.73 | 9447.0 |
| 2025-01-22 | ACVF | ETF | 45.83 | 45.87 | 45.61 | 45.7566 | 18430.0 |
| 2025-01-22 | ACWI | ETF | 121.69 | 121.695 | 121.31 | 121.4 | 2222967.0 |
| 2025-01-22 | ACWV | ETF | 110.35 | 110.35 | 110.04 | 110.05 | 173658.0 |
| 2025-01-22 | ACWX | ETF | 53.71 | 53.71 | 53.509 | 53.52 | 653934.0 |
| 2025-01-22 | ADFI | ETF | 8.4397 | 8.4397 | 8.39 | 8.4 | 16899.0 |
| 2025-01-22 | ADIV | ETF | 15.5617 | 15.5617 | 15.525 | 15.525 | 342.0 |
| 2025-01-22 | ADME | ETF | 48.3 | 48.38 | 48.2675 | 48.28 | 7907.0 |
| 2025-01-22 | ADPV | ETF | 38.11 | 38.14 | 37.8899 | 38.0533 | 14883.0 |
| 2025-01-22 | ADVE | ETF | 32.0698 | 32.0698 | 32.0698 | 32.0698 | 4.0 |
| 2025-01-22 | AESR | ETF | 18.07 | 18.19 | 18.07 | 18.1 | 17594.0 |
| 2025-01-22 | AETH | ETF | 32.69 | 32.7498 | 32.69 | 32.7498 | 813.0 |
| 2025-01-22 | AFIF | ETF | 9.2 | 9.2 | 9.17 | 9.18 | 47238.0 |
| 2025-01-22 | AFIX | ETF | 24.56 | 24.57 | 24.5395 | 24.5395 | 3143.0 |
| 2025-01-22 | AFK | ETF | 16.45 | 16.45 | 16.16 | 16.26 | 6484.0 |
| 2025-01-22 | AFLG | ETF | 35.86 | 35.87 | 35.746 | 35.77 | 123808.0 |
| 2025-01-22 | AFMC | ETF | 33.395 | 33.41 | 33.23 | 33.29 | 42459.0 |
| 2025-01-22 | AFSM | ETF | 31.42 | 31.42 | 31.1 | 31.1099 | 7221.0 |
| 2025-01-22 | AGG | ETF | 97.21 | 97.25 | 96.96 | 97.01 | 7197547.0 |
| 2025-01-22 | AGGH | ETF | 20.71 | 20.7297 | 20.6157 | 20.7 | 58659.0 |
> showing 50 of 3,887 rows — these rows as CSV