PREVIEW / etf_daily / 2023-10-10
file: by_date/etf_daily/2023/2023-10-10.parquet size: 109 KB rows: 3,064
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-10-10 | SPY | ETF | 432.94 | 437.22 | 432.53 | 434.54 | 78607300.0 |
| 2023-10-10 | QQQ | ETF | 366.9 | 371.28 | 366.39 | 368.59 | 46968806.0 |
| 2023-10-10 | IWM | ETF | 174.31 | 177.04 | 174.28 | 175.97 | 31585000.0 |
| 2023-10-10 | DIA | ETF | 337.2 | 339.01 | 336.03 | 337.45 | 3769400.0 |
| 2023-10-10 | GLD | ETF | 172.08 | 172.8 | 171.9 | 172.53 | 5844000.0 |
| 2023-10-10 | TLT | ETF | 85.85 | 87.17 | 85.52 | 86.66 | 54743900.0 |
| 2023-10-10 | AAA | ETF | 24.81 | 24.81 | 24.81 | 24.81 | 400.0 |
| 2023-10-10 | AAAU | ETF | 18.38 | 18.45 | 18.36 | 18.43 | 1368800.0 |
| 2023-10-10 | AADR | ETF | 49.0 | 49.33 | 48.97 | 49.18 | 2800.0 |
| 2023-10-10 | AAPB | ETF | 24.5084 | 24.7971 | 24.44 | 24.51 | 8957.0 |
| 2023-10-10 | AAPD | ETF | 21.89 | 21.89 | 21.6442 | 21.81 | 148787.0 |
| 2023-10-10 | AAPU | ETF | 25.17 | 25.27 | 24.91 | 25.02 | 146399.0 |
| 2023-10-10 | AAXJ | ETF | 63.81 | 64.35 | 63.67 | 64.25 | 344900.0 |
| 2023-10-10 | ABEQ | ETF | 27.35 | 27.45 | 27.35 | 27.384 | 22200.0 |
| 2023-10-10 | ACES | ETF | 33.16 | 34.985 | 33.16 | 34.94 | 83900.0 |
| 2023-10-10 | ACIO | ETF | 30.6 | 30.938 | 30.6 | 30.81 | 93800.0 |
| 2023-10-10 | ACSI | ETF | 45.07 | 45.13 | 44.937 | 44.937 | 3300.0 |
| 2023-10-10 | ACT | ETF | 28.1 | 28.44 | 27.94 | 27.97 | 268261.0 |
| 2023-10-10 | ACTV | ETF | 29.35 | 29.75 | 29.35 | 29.577 | 40800.0 |
| 2023-10-10 | ACVF | ETF | 33.48 | 33.63 | 33.42 | 33.455 | 17800.0 |
| 2023-10-10 | ACWF | ETF | 34.85 | 35.009 | 34.8421 | 34.8421 | 3890.0 |
| 2023-10-10 | ACWI | ETF | 93.24 | 94.06 | 93.13 | 93.59 | 4807300.0 |
| 2023-10-10 | ACWV | ETF | 95.78 | 96.33 | 95.55 | 96.05 | 320600.0 |
| 2023-10-10 | ACWX | ETF | 47.07 | 47.42 | 47.06 | 47.31 | 1220200.0 |
| 2023-10-10 | ADFI | ETF | 8.22 | 8.24 | 8.2 | 8.215 | 11900.0 |
| 2023-10-10 | ADIV | ETF | 13.446 | 13.45 | 13.446 | 13.45 | 500.0 |
| 2023-10-10 | ADME | ETF | 35.45 | 35.73 | 35.45 | 35.572 | 17700.0 |
| 2023-10-10 | ADPV | ETF | 24.72 | 24.75 | 24.3987 | 24.3987 | 1178.0 |
| 2023-10-10 | AEMB | ETF | 35.374 | 35.374 | 35.374 | 35.374 | 100.0 |
| 2023-10-10 | AESR | ETF | 12.504 | 12.58 | 12.44 | 12.48 | 57100.0 |
| 2023-10-10 | AETH | ETF | 23.5441 | 23.5441 | 23.33 | 23.3347 | 1846.0 |
| 2023-10-10 | AFIF | ETF | 8.9 | 8.92 | 8.89 | 8.9 | 40700.0 |
| 2023-10-10 | AFK | ETF | 14.12 | 14.12 | 14.04 | 14.11 | 1400.0 |
| 2023-10-10 | AFLG | ETF | 25.183 | 25.194 | 25.109 | 25.109 | 600.0 |
| 2023-10-10 | AFMC | ETF | 23.95 | 23.957 | 23.95 | 23.957 | 400.0 |
| 2023-10-10 | AFSM | ETF | 24.23 | 24.23 | 24.147 | 24.147 | 200.0 |
| 2023-10-10 | AFTY | ETF | 14.58 | 14.61 | 14.58 | 14.61 | 200.0 |
| 2023-10-10 | AGG | ETF | 93.39 | 93.81 | 93.26 | 93.62 | 14553600.0 |
| 2023-10-10 | AGGH | ETF | 21.25 | 21.31 | 21.215 | 21.265 | 207963.0 |
| 2023-10-10 | AGGY | ETF | 41.26 | 41.46 | 41.23 | 41.39 | 108000.0 |
| 2023-10-10 | AGNG | ETF | 26.135 | 26.14 | 26.135 | 26.14 | 400.0 |
| 2023-10-10 | AGOV | ETF | 73.2363 | 73.495 | 72.61 | 73.495 | 982.0 |
| 2023-10-10 | AGOX | ETF | 22.73 | 23.04 | 22.73 | 22.89 | 63800.0 |
| 2023-10-10 | AGQ | ETF | 23.62 | 23.83 | 23.37 | 23.66 | 800400.0 |
| 2023-10-10 | AGZ | ETF | 105.46 | 105.71 | 105.46 | 105.55 | 113900.0 |
| 2023-10-10 | AGZD | ETF | 22.12 | 22.17 | 22.06 | 22.15 | 63400.0 |
| 2023-10-10 | AHLT | ETF | 26.3223 | 26.36 | 26.2672 | 26.2672 | 1233.0 |
| 2023-10-10 | AHYB | ETF | 43.17 | 43.195 | 43.157 | 43.157 | 1100.0 |
| 2023-10-10 | AIA | ETF | 55.83 | 56.55 | 55.83 | 56.49 | 52300.0 |
| 2023-10-10 | AIEQ | ETF | 29.56 | 30.04 | 29.56 | 29.883 | 8800.0 |
> showing 50 of 3,064 rows — these rows as CSV