PREVIEW / etf_daily / 2023-11-10
file: by_date/etf_daily/2023/2023-11-10.parquet size: 112 KB rows: 3,111
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 |
|---|---|---|---|---|---|---|---|
| 2023-11-10 | SPY | ETF | 435.98 | 440.93 | 433.83 | 440.61 | 89462200.0 |
| 2023-11-10 | QQQ | ETF | 371.82 | 378.54 | 371.28 | 378.39 | 58368439.0 |
| 2023-11-10 | IWM | ETF | 168.22 | 169.71 | 166.79 | 169.11 | 36121300.0 |
| 2023-11-10 | DIA | ETF | 340.81 | 343.3 | 339.27 | 343.01 | 3268600.0 |
| 2023-11-10 | GLD | ETF | 180.51 | 180.59 | 179.25 | 179.51 | 7606600.0 |
| 2023-11-10 | TLT | ETF | 88.23 | 88.43 | 87.77 | 87.99 | 36516400.0 |
| 2023-11-10 | AAA | ETF | 24.86 | 24.9 | 24.824 | 24.875 | 22400.0 |
| 2023-11-10 | AAAU | ETF | 19.29 | 19.29 | 19.16 | 19.18 | 1743500.0 |
| 2023-11-10 | AADR | ETF | 49.3 | 49.86 | 49.3 | 49.86 | 1700.0 |
| 2023-11-10 | AAPB | ETF | 25.55 | 26.179 | 25.4701 | 26.15 | 112048.0 |
| 2023-11-10 | AAPD | ETF | 21.22 | 21.2518 | 20.9 | 20.92 | 135498.0 |
| 2023-11-10 | AAPU | ETF | 26.0 | 26.6 | 25.985 | 26.56 | 170722.0 |
| 2023-11-10 | AAXJ | ETF | 63.51 | 63.9 | 63.37 | 63.86 | 354500.0 |
| 2023-11-10 | ABEQ | ETF | 27.0 | 27.122 | 27.0 | 27.122 | 36400.0 |
| 2023-11-10 | ACES | ETF | 28.59 | 28.68 | 28.01 | 28.41 | 45800.0 |
| 2023-11-10 | ACIO | ETF | 31.15 | 31.47 | 31.07 | 31.47 | 44700.0 |
| 2023-11-10 | ACSI | ETF | 46.056 | 46.056 | 46.056 | 46.056 | 100.0 |
| 2023-11-10 | ACT | ETF | 27.6 | 27.98 | 27.6 | 27.67 | 687282.0 |
| 2023-11-10 | ACTV | ETF | 28.49 | 28.49 | 27.958 | 28.263 | 8300.0 |
| 2023-11-10 | ACVF | ETF | 33.47 | 33.82 | 33.45 | 33.82 | 11800.0 |
| 2023-11-10 | ACWF | ETF | 34.81 | 35.1614 | 34.76 | 35.1614 | 11432.0 |
| 2023-11-10 | ACWI | ETF | 93.48 | 94.36 | 93.09 | 94.31 | 2003700.0 |
| 2023-11-10 | ACWV | ETF | 96.04 | 96.27 | 95.51 | 96.14 | 154500.0 |
| 2023-11-10 | ACWX | ETF | 47.01 | 47.33 | 46.78 | 47.33 | 1141400.0 |
| 2023-11-10 | ADFI | ETF | 8.24 | 8.25 | 8.22 | 8.221 | 8800.0 |
| 2023-11-10 | ADIV | ETF | 13.34 | 13.425 | 13.34 | 13.425 | 300.0 |
| 2023-11-10 | ADME | ETF | 35.72 | 36.087 | 35.63 | 36.087 | 18300.0 |
| 2023-11-10 | ADPV | ETF | 22.9 | 22.95 | 22.9 | 22.9302 | 3247.0 |
| 2023-11-10 | AEMB | ETF | 35.713 | 35.713 | 35.713 | 35.713 | 100.0 |
| 2023-11-10 | AESR | ETF | 12.45 | 12.63 | 12.45 | 12.6 | 430500.0 |
| 2023-11-10 | AETH | ETF | 31.3211 | 31.7081 | 31.29 | 31.5258 | 3328.0 |
| 2023-11-10 | AFIF | ETF | 8.94 | 8.94 | 8.89 | 8.9 | 38400.0 |
| 2023-11-10 | AFK | ETF | 13.4 | 13.4 | 13.16 | 13.31 | 9800.0 |
| 2023-11-10 | AFLG | ETF | 25.525 | 25.525 | 25.525 | 25.525 | 200.0 |
| 2023-11-10 | AFMC | ETF | 23.4 | 23.471 | 23.4 | 23.471 | 900.0 |
| 2023-11-10 | AGG | ETF | 94.19 | 94.22 | 93.88 | 93.96 | 6102000.0 |
| 2023-11-10 | AGGH | ETF | 21.33 | 21.33 | 21.1938 | 21.25 | 175361.0 |
| 2023-11-10 | AGGY | ETF | 41.73 | 41.73 | 41.6 | 41.64 | 114800.0 |
| 2023-11-10 | AGNG | ETF | 25.2 | 25.4 | 25.2 | 25.4 | 2000.0 |
| 2023-11-10 | AGOV | ETF | 72.5 | 72.5 | 71.91 | 71.91 | 145.0 |
| 2023-11-10 | AGOX | ETF | 22.861 | 23.1 | 22.86 | 23.03 | 13500.0 |
| 2023-11-10 | AGQ | ETF | 24.63 | 24.79 | 24.11 | 24.19 | 1067300.0 |
| 2023-11-10 | AGRH | ETF | 25.53 | 25.56 | 25.43 | 25.5133 | 5684.0 |
| 2023-11-10 | AGZ | ETF | 105.92 | 105.92 | 105.8 | 105.82 | 17900.0 |
| 2023-11-10 | AGZD | ETF | 22.26 | 22.42 | 22.21 | 22.29 | 11500.0 |
| 2023-11-10 | AHLT | ETF | 25.67 | 25.905 | 25.6285 | 25.6285 | 2624.0 |
| 2023-11-10 | AHYB | ETF | 43.553 | 43.645 | 43.553 | 43.645 | 800.0 |
| 2023-11-10 | AIA | ETF | 56.35 | 56.92 | 56.3 | 56.8 | 20000.0 |
| 2023-11-10 | AIEQ | ETF | 29.76 | 29.941 | 29.5 | 29.92 | 22500.0 |
| 2023-11-10 | AIQ | ETF | 27.83 | 28.25 | 27.77 | 28.25 | 216300.0 |
> showing 50 of 3,111 rows — these rows as CSV