PREVIEW / etf_daily / 2024-01-17
file: by_date/etf_daily/2024/2024-01-17.parquet size: 116 KB rows: 3,230
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 |
|---|---|---|---|---|---|---|---|
| 2024-01-17 | SPY | ETF | 471.82 | 472.79 | 469.87 | 472.29 | 68843900.0 |
| 2024-01-17 | QQQ | ETF | 406.17 | 407.585 | 402.92 | 407.21 | 54385974.0 |
| 2024-01-17 | IWM | ETF | 188.13 | 189.93 | 187.53 | 189.48 | 37787700.0 |
| 2024-01-17 | DIA | ETF | 371.75 | 373.75 | 371.34 | 372.72 | 4361000.0 |
| 2024-01-17 | GLD | ETF | 187.31 | 187.42 | 185.45 | 185.84 | 8643200.0 |
| 2024-01-17 | TLT | ETF | 94.6 | 95.0 | 94.16 | 94.67 | 55506800.0 |
| 2024-01-17 | AAA | ETF | 25.1 | 25.17 | 25.058 | 25.115 | 8900.0 |
| 2024-01-17 | AAAU | ETF | 20.03 | 20.03 | 19.82 | 19.87 | 3328600.0 |
| 2024-01-17 | AADR | ETF | 53.59 | 53.77 | 53.59 | 53.69 | 700.0 |
| 2024-01-17 | AAPB | ETF | 20.45 | 20.79 | 20.38 | 20.79 | 14622.0 |
| 2024-01-17 | AAPD | ETF | 21.47 | 21.5739 | 21.2715 | 21.31 | 374111.0 |
| 2024-01-17 | AAPU | ETF | 24.91 | 25.25 | 24.73 | 25.21 | 87623.0 |
| 2024-01-17 | AAPX | ETF | 23.84 | 24.0923 | 23.77 | 24.0923 | 981.0 |
| 2024-01-17 | AAPY | ETF | 25.4 | 25.5263 | 25.4 | 25.5263 | 261.0 |
| 2024-01-17 | AAXJ | ETF | 61.39 | 61.82 | 61.3 | 61.78 | 896800.0 |
| 2024-01-17 | ABCS | ETF | 24.55 | 24.55 | 24.4565 | 24.4565 | 20113.0 |
| 2024-01-17 | ABEQ | ETF | 28.3 | 28.3 | 28.07 | 28.07 | 3300.0 |
| 2024-01-17 | ACES | ETF | 29.81 | 29.82 | 29.2 | 29.41 | 51400.0 |
| 2024-01-17 | ACIO | ETF | 33.02 | 33.13 | 32.98 | 33.1 | 77100.0 |
| 2024-01-17 | ACSI | ETF | 48.773 | 48.773 | 48.773 | 48.773 | 100.0 |
| 2024-01-17 | ACT | ETF | 27.49 | 27.83 | 27.41 | 27.82 | 192758.0 |
| 2024-01-17 | ACTV | ETF | 31.9 | 31.97 | 31.72 | 31.87 | 9700.0 |
| 2024-01-17 | ACVF | ETF | 36.52 | 36.52 | 36.25 | 36.431 | 10800.0 |
| 2024-01-17 | ACWF | ETF | 37.55 | 37.55 | 37.3695 | 37.5376 | 2334.0 |
| 2024-01-17 | ACWI | ETF | 99.59 | 99.83 | 99.26 | 99.79 | 13827200.0 |
| 2024-01-17 | ACWV | ETF | 99.99 | 100.57 | 99.99 | 100.35 | 125500.0 |
| 2024-01-17 | ACWX | ETF | 48.82 | 48.99 | 48.68 | 48.96 | 2438500.0 |
| 2024-01-17 | ADFI | ETF | 8.525 | 8.54 | 8.5 | 8.515 | 9100.0 |
| 2024-01-17 | ADIV | ETF | 13.22 | 13.225 | 13.18 | 13.225 | 700.0 |
| 2024-01-17 | ADME | ETF | 38.202 | 38.293 | 38.165 | 38.293 | 4800.0 |
| 2024-01-17 | ADPV | ETF | 24.24 | 24.3021 | 24.23 | 24.3021 | 9568.0 |
| 2024-01-17 | AEMB | ETF | 37.52 | 37.556 | 37.52 | 37.556 | 200.0 |
| 2024-01-17 | AESR | ETF | 13.72 | 13.79 | 13.68 | 13.79 | 19800.0 |
| 2024-01-17 | AETH | ETF | 36.21 | 36.21 | 34.8 | 34.9712 | 7880.0 |
| 2024-01-17 | AFIF | ETF | 9.12 | 9.12 | 9.07 | 9.1 | 4700.0 |
| 2024-01-17 | AFK | ETF | 13.48 | 13.73 | 13.37 | 13.39 | 7500.0 |
| 2024-01-17 | AFLG | ETF | 27.07 | 27.226 | 27.07 | 27.226 | 400.0 |
| 2024-01-17 | AFMC | ETF | 26.09 | 26.144 | 26.09 | 26.144 | 9600.0 |
| 2024-01-17 | AFSM | ETF | 25.98 | 26.22 | 25.98 | 26.22 | 1400.0 |
| 2024-01-17 | AFTY | ETF | 12.54 | 12.566 | 12.54 | 12.566 | 300.0 |
| 2024-01-17 | AGG | ETF | 98.16 | 98.21 | 97.94 | 98.09 | 8977500.0 |
| 2024-01-17 | AGGH | ETF | 21.84 | 21.85 | 21.7611 | 21.85 | 48970.0 |
| 2024-01-17 | AGGY | ETF | 43.6 | 43.61 | 43.47 | 43.54 | 118300.0 |
| 2024-01-17 | AGNG | ETF | 28.17 | 28.263 | 28.08 | 28.18 | 2000.0 |
| 2024-01-17 | AGOX | ETF | 23.92 | 23.96 | 23.77 | 23.949 | 24200.0 |
| 2024-01-17 | AGQ | ETF | 24.51 | 24.57 | 24.13 | 24.25 | 1771900.0 |
| 2024-01-17 | AGQI | ETF | 13.01 | 13.02 | 12.956 | 13.02 | 52211.0 |
| 2024-01-17 | AGRH | ETF | 25.8 | 25.8167 | 25.72 | 25.7864 | 2700.0 |
| 2024-01-17 | AGZ | ETF | 108.13 | 108.19 | 108.04 | 108.15 | 84400.0 |
| 2024-01-17 | AGZD | ETF | 21.92 | 21.98 | 21.8 | 21.91 | 24300.0 |
> showing 50 of 3,230 rows — these rows as CSV