PREVIEW / etf_daily / 2024-01-18
file: by_date/etf_daily/2024/2024-01-18.parquet size: 115 KB rows: 3,199
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-18 | SPY | ETF | 474.01 | 477.06 | 472.42 | 476.49 | 91856200.0 |
| 2024-01-18 | QQQ | ETF | 410.52 | 413.575 | 409.1601 | 412.99 | 59562505.0 |
| 2024-01-18 | IWM | ETF | 190.71 | 191.17 | 188.21 | 190.6 | 41760000.0 |
| 2024-01-18 | DIA | ETF | 372.23 | 375.33 | 371.36 | 374.81 | 3953400.0 |
| 2024-01-18 | GLD | ETF | 186.36 | 187.4 | 186.3 | 187.37 | 4685200.0 |
| 2024-01-18 | TLT | ETF | 94.46 | 94.58 | 93.51 | 93.79 | 77339100.0 |
| 2024-01-18 | AAA | ETF | 25.12 | 25.18 | 25.04 | 25.105 | 11000.0 |
| 2024-01-18 | AAAU | ETF | 19.92 | 20.03 | 19.92 | 20.03 | 1630800.0 |
| 2024-01-18 | AADR | ETF | 54.12 | 54.44 | 54.12 | 54.44 | 500.0 |
| 2024-01-18 | AAPB | ETF | 21.46 | 22.05 | 21.46 | 21.98 | 87373.0 |
| 2024-01-18 | AAPD | ETF | 20.93 | 20.93 | 20.56 | 20.6134 | 324140.0 |
| 2024-01-18 | AAPU | ETF | 25.9 | 26.53 | 25.8666 | 26.42 | 211302.0 |
| 2024-01-18 | AAPX | ETF | 25.53 | 25.69 | 25.16 | 25.5918 | 9654.0 |
| 2024-01-18 | AAPY | ETF | 25.98 | 26.2593 | 25.98 | 26.2593 | 717.0 |
| 2024-01-18 | AAXJ | ETF | 62.27 | 62.47 | 62.15 | 62.41 | 748700.0 |
| 2024-01-18 | ABCS | ETF | 24.45 | 24.59 | 24.37 | 24.5691 | 11676.0 |
| 2024-01-18 | ABEQ | ETF | 28.035 | 28.16 | 28.01 | 28.142 | 8500.0 |
| 2024-01-18 | ACES | ETF | 29.59 | 29.59 | 28.8 | 29.16 | 29100.0 |
| 2024-01-18 | ACIO | ETF | 33.23 | 33.33 | 33.11 | 33.31 | 102400.0 |
| 2024-01-18 | ACSI | ETF | 49.042 | 49.042 | 49.042 | 49.042 | 100.0 |
| 2024-01-18 | ACT | ETF | 27.91 | 28.07 | 27.7101 | 28.07 | 165527.0 |
| 2024-01-18 | ACTV | ETF | 31.96 | 31.99 | 31.73 | 31.98 | 10000.0 |
| 2024-01-18 | ACVF | ETF | 36.45 | 36.69 | 36.36 | 36.69 | 32400.0 |
| 2024-01-18 | ACWF | ETF | 37.7075 | 37.8079 | 37.65 | 37.8079 | 7788.0 |
| 2024-01-18 | ACWI | ETF | 100.15 | 100.72 | 99.89 | 100.66 | 5332200.0 |
| 2024-01-18 | ACWV | ETF | 100.32 | 100.74 | 100.07 | 100.68 | 100000.0 |
| 2024-01-18 | ACWX | ETF | 49.23 | 49.41 | 49.11 | 49.39 | 1653600.0 |
| 2024-01-18 | ADFI | ETF | 8.52 | 8.52 | 8.5 | 8.51 | 14500.0 |
| 2024-01-18 | ADIV | ETF | 13.3 | 13.36 | 13.3 | 13.357 | 400.0 |
| 2024-01-18 | ADME | ETF | 38.35 | 38.609 | 38.35 | 38.609 | 83400.0 |
| 2024-01-18 | ADPV | ETF | 24.32 | 24.57 | 24.32 | 24.5386 | 82784.0 |
| 2024-01-18 | ADVE | ETF | 30.7196 | 30.7791 | 30.7196 | 30.7791 | 105.0 |
| 2024-01-18 | AEMB | ETF | 37.51 | 37.55 | 37.51 | 37.55 | 100.0 |
| 2024-01-18 | AESR | ETF | 13.84 | 13.96 | 13.8 | 13.95 | 29800.0 |
| 2024-01-18 | AETH | ETF | 35.2 | 35.2 | 33.26 | 33.33 | 9748.0 |
| 2024-01-18 | AFIF | ETF | 9.08 | 9.09 | 9.05 | 9.07 | 14500.0 |
| 2024-01-18 | AFK | ETF | 13.34 | 13.71 | 13.34 | 13.56 | 3300.0 |
| 2024-01-18 | AFLG | ETF | 27.42 | 27.453 | 27.42 | 27.453 | 500.0 |
| 2024-01-18 | AFMC | ETF | 26.332 | 26.332 | 26.332 | 26.332 | 300.0 |
| 2024-01-18 | AFSM | ETF | 26.51 | 26.51 | 26.441 | 26.441 | 400.0 |
| 2024-01-18 | AFTY | ETF | 12.735 | 12.735 | 12.735 | 12.735 | 100.0 |
| 2024-01-18 | AGG | ETF | 98.16 | 98.2 | 97.89 | 98.0 | 10575100.0 |
| 2024-01-18 | AGGH | ETF | 21.96 | 21.96 | 21.67 | 21.78 | 104565.0 |
| 2024-01-18 | AGGY | ETF | 43.52 | 43.58 | 43.451 | 43.51 | 146300.0 |
| 2024-01-18 | AGNG | ETF | 28.13 | 28.28 | 28.0 | 28.28 | 1600.0 |
| 2024-01-18 | AGOX | ETF | 23.94 | 24.1 | 23.87 | 24.019 | 27900.0 |
| 2024-01-18 | AGQ | ETF | 24.0 | 24.63 | 23.92 | 24.6 | 1530700.0 |
| 2024-01-18 | AGQI | ETF | 13.09 | 13.18 | 13.08 | 13.17 | 103399.0 |
| 2024-01-18 | AGZ | ETF | 108.15 | 108.21 | 108.07 | 108.11 | 12500.0 |
| 2024-01-18 | AGZD | ETF | 21.91 | 21.98 | 21.87 | 21.94 | 102400.0 |
> showing 50 of 3,199 rows — these rows as CSV