PREVIEW / etf_daily / 2024-03-14
file: by_date/etf_daily/2024/2024-03-14.parquet size: 117 KB rows: 3,269
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-03-14 | SPY | ETF | 516.97 | 517.13 | 511.82 | 514.95 | 110171800.0 |
| 2024-03-14 | QQQ | ETF | 441.5 | 442.03 | 436.39 | 439.14 | 52195208.0 |
| 2024-03-14 | IWM | ETF | 205.05 | 205.28 | 200.17 | 202.03 | 47509100.0 |
| 2024-03-14 | DIA | ETF | 392.17 | 392.41 | 387.84 | 390.07 | 4471900.0 |
| 2024-03-14 | GLD | ETF | 200.37 | 200.47 | 199.34 | 200.35 | 6865000.0 |
| 2024-03-14 | TLT | ETF | 93.73 | 93.75 | 92.86 | 92.97 | 58365600.0 |
| 2024-03-14 | AAA | ETF | 25.104 | 25.104 | 25.08 | 25.08 | 1200.0 |
| 2024-03-14 | AAAU | ETF | 21.43 | 21.43 | 21.31 | 21.42 | 2853000.0 |
| 2024-03-14 | AADR | ETF | 60.64 | 60.95 | 60.58 | 60.6 | 5200.0 |
| 2024-03-14 | AAPB | ETF | 18.02 | 18.299 | 17.83 | 18.05 | 141671.0 |
| 2024-03-14 | AAPD | ETF | 22.71 | 22.731 | 22.4688 | 22.61 | 305678.0 |
| 2024-03-14 | AAPU | ETF | 23.0 | 23.24 | 22.815 | 22.99 | 410308.0 |
| 2024-03-14 | AAPX | ETF | 21.0 | 21.33 | 20.895 | 21.05 | 43840.0 |
| 2024-03-14 | AAPY | ETF | 24.0 | 24.0538 | 24.0 | 24.0538 | 536.0 |
| 2024-03-14 | AAXJ | ETF | 68.38 | 68.46 | 67.79 | 67.97 | 392300.0 |
| 2024-03-14 | ABCS | ETF | 26.22 | 26.22 | 26.01 | 26.1425 | 4126.0 |
| 2024-03-14 | ABEQ | ETF | 29.48 | 29.489 | 29.48 | 29.489 | 600.0 |
| 2024-03-14 | ACES | ETF | 28.41 | 28.41 | 27.3 | 27.54 | 197900.0 |
| 2024-03-14 | ACIO | ETF | 35.67 | 35.695 | 35.39 | 35.5 | 95800.0 |
| 2024-03-14 | ACSI | ETF | 50.217 | 50.217 | 50.217 | 50.217 | 100.0 |
| 2024-03-14 | ACT | ETF | 29.49 | 29.54 | 28.99 | 29.19 | 228820.0 |
| 2024-03-14 | ACTV | ETF | 33.54 | 33.589 | 33.377 | 33.589 | 2000.0 |
| 2024-03-14 | ACVF | ETF | 39.88 | 39.88 | 39.415 | 39.549 | 5800.0 |
| 2024-03-14 | ACWF | ETF | 40.89 | 40.89 | 40.58 | 40.6179 | 2544.0 |
| 2024-03-14 | ACWI | ETF | 108.95 | 108.95 | 107.8 | 108.37 | 3938900.0 |
| 2024-03-14 | ACWV | ETF | 104.89 | 104.89 | 103.99 | 104.33 | 153500.0 |
| 2024-03-14 | ACWX | ETF | 53.27 | 53.27 | 52.7 | 52.91 | 1823100.0 |
| 2024-03-14 | ADFI | ETF | 8.47 | 8.48 | 8.465 | 8.465 | 14100.0 |
| 2024-03-14 | ADIV | ETF | 14.181 | 14.181 | 14.181 | 14.181 | 100.0 |
| 2024-03-14 | ADME | ETF | 41.44 | 41.51 | 41.29 | 41.404 | 10100.0 |
| 2024-03-14 | ADPV | ETF | 28.6 | 28.6 | 28.53 | 28.5406 | 1195.0 |
| 2024-03-14 | ADVE | ETF | 32.5 | 32.5243 | 32.43 | 32.4869 | 820.0 |
| 2024-03-14 | AEMB | ETF | 38.222 | 38.222 | 38.222 | 38.222 | 100.0 |
| 2024-03-14 | AESR | ETF | 15.27 | 15.29 | 15.18 | 15.266 | 19700.0 |
| 2024-03-14 | AETH | ETF | 53.41 | 53.41 | 50.4604 | 51.1493 | 15231.0 |
| 2024-03-14 | AFIF | ETF | 9.07 | 9.11 | 9.07 | 9.09 | 15700.0 |
| 2024-03-14 | AFK | ETF | 13.99 | 13.99 | 13.94 | 13.94 | 4600.0 |
| 2024-03-14 | AFLG | ETF | 30.074 | 30.074 | 30.074 | 30.074 | 100.0 |
| 2024-03-14 | AFMC | ETF | 29.45 | 29.45 | 28.9 | 28.954 | 3300.0 |
| 2024-03-14 | AFSM | ETF | 27.962 | 27.962 | 27.924 | 27.924 | 2300.0 |
| 2024-03-14 | AFTY | ETF | 14.03 | 14.03 | 14.01 | 14.01 | 500.0 |
| 2024-03-14 | AGG | ETF | 97.48 | 97.48 | 97.1 | 97.11 | 10541000.0 |
| 2024-03-14 | AGGH | ETF | 21.5 | 21.5 | 21.3 | 21.43 | 82806.0 |
| 2024-03-14 | AGGY | ETF | 43.3 | 43.3 | 43.14 | 43.158 | 164800.0 |
| 2024-03-14 | AGNG | ETF | 29.84 | 29.96 | 29.76 | 29.85 | 7500.0 |
| 2024-03-14 | AGOX | ETF | 25.646 | 25.73 | 25.495 | 25.69 | 24400.0 |
| 2024-03-14 | AGQ | ETF | 29.34 | 29.39 | 28.58 | 28.82 | 1444100.0 |
| 2024-03-14 | AGQI | ETF | 13.89 | 13.91 | 13.78 | 13.8206 | 25767.0 |
| 2024-03-14 | AGRH | ETF | 25.87 | 25.87 | 25.85 | 25.85 | 825.0 |
| 2024-03-14 | AGZ | ETF | 107.33 | 107.74 | 107.33 | 107.56 | 12200.0 |
> showing 50 of 3,269 rows — these rows as CSV