PREVIEW / etf_daily / 2024-06-04
file: by_date/etf_daily/2024/2024-06-04.parquet size: 120 KB rows: 3,381
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-06-04 | SPY | ETF | 526.46 | 529.15 | 524.96 | 528.39 | 34632700.0 |
| 2024-06-04 | QQQ | ETF | 452.87 | 455.575 | 451.1311 | 454.37 | 23767436.0 |
| 2024-06-04 | IWM | ETF | 203.15 | 204.5 | 201.65 | 201.97 | 27098900.0 |
| 2024-06-04 | DIA | ETF | 385.0 | 388.38 | 384.54 | 387.51 | 2822500.0 |
| 2024-06-04 | GLD | ETF | 216.24 | 216.24 | 214.2 | 215.27 | 5509400.0 |
| 2024-06-04 | TLT | ETF | 92.2 | 92.8 | 91.99 | 92.67 | 42581500.0 |
| 2024-06-04 | AAA | ETF | 25.05 | 25.105 | 25.03 | 25.08 | 5400.0 |
| 2024-06-04 | AAAU | ETF | 23.14 | 23.14 | 22.92 | 23.03 | 1839900.0 |
| 2024-06-04 | AADR | ETF | 63.27 | 63.27 | 63.14 | 63.14 | 600.0 |
| 2024-06-04 | AAPB | ETF | 22.01 | 22.13 | 21.64 | 21.91 | 86072.0 |
| 2024-06-04 | AAPD | ETF | 20.02 | 20.1808 | 19.9504 | 20.06 | 198165.0 |
| 2024-06-04 | AAPR | ETF | 24.86 | 24.93 | 24.82 | 24.91 | 23376.0 |
| 2024-06-04 | AAPU | ETF | 28.41 | 28.5876 | 27.9203 | 28.31 | 318523.0 |
| 2024-06-04 | AAPX | ETF | 25.284 | 25.819 | 25.24 | 25.55 | 10138.0 |
| 2024-06-04 | AAPY | ETF | 25.5 | 25.59 | 25.5 | 25.59 | 1041.0 |
| 2024-06-04 | AAXJ | ETF | 70.14 | 70.24 | 69.74 | 70.2 | 948600.0 |
| 2024-06-04 | ABCS | ETF | 26.344 | 26.44 | 26.2102 | 26.2102 | 1800.0 |
| 2024-06-04 | ABEQ | ETF | 30.45 | 30.45 | 30.31 | 30.389 | 500.0 |
| 2024-06-04 | ACES | ETF | 31.38 | 31.38 | 31.07 | 31.13 | 30100.0 |
| 2024-06-04 | ACIO | ETF | 36.33 | 36.53 | 36.27 | 36.5 | 148600.0 |
| 2024-06-04 | ACSI | ETF | 53.691 | 53.691 | 53.691 | 53.691 | 100.0 |
| 2024-06-04 | ACT | ETF | 30.8 | 31.14 | 30.55 | 30.68 | 186389.0 |
| 2024-06-04 | ACTV | ETF | 33.15 | 33.15 | 32.835 | 32.85 | 4800.0 |
| 2024-06-04 | ACVF | ETF | 39.89 | 40.013 | 39.785 | 40.013 | 4700.0 |
| 2024-06-04 | ACWF | ETF | 41.79 | 41.98 | 41.64 | 41.89 | 27177.0 |
| 2024-06-04 | ACWI | ETF | 110.91 | 111.28 | 110.5 | 111.15 | 1941400.0 |
| 2024-06-04 | ACWV | ETF | 104.54 | 105.07 | 104.4 | 104.94 | 338700.0 |
| 2024-06-04 | ACWX | ETF | 54.14 | 54.18 | 53.86 | 54.12 | 958700.0 |
| 2024-06-04 | ADFI | ETF | 8.47 | 8.519 | 8.47 | 8.519 | 29600.0 |
| 2024-06-04 | ADIV | ETF | 14.62 | 14.62 | 14.596 | 14.596 | 200.0 |
| 2024-06-04 | ADME | ETF | 42.06 | 42.33 | 42.015 | 42.251 | 6900.0 |
| 2024-06-04 | ADPV | ETF | 30.3 | 30.3 | 29.76 | 29.8588 | 7434.0 |
| 2024-06-04 | AEMB | ETF | 38.43 | 38.452 | 38.43 | 38.452 | 400.0 |
| 2024-06-04 | AESR | ETF | 15.76 | 15.8 | 15.69 | 15.8 | 31000.0 |
| 2024-06-04 | AETH | ETF | 49.67 | 50.28 | 49.531 | 49.8476 | 3978.0 |
| 2024-06-04 | AFIF | ETF | 9.12 | 9.13 | 9.11 | 9.13 | 10700.0 |
| 2024-06-04 | AFK | ETF | 15.85 | 15.94 | 15.49 | 15.49 | 11700.0 |
| 2024-06-04 | AFLG | ETF | 30.85 | 30.93 | 30.77 | 30.904 | 13300.0 |
| 2024-06-04 | AFMC | ETF | 29.29 | 29.29 | 29.233 | 29.233 | 300.0 |
| 2024-06-04 | AFSM | ETF | 28.606 | 28.606 | 28.38 | 28.459 | 17700.0 |
| 2024-06-04 | AFTY | ETF | 14.538 | 14.538 | 14.538 | 14.538 | 100.0 |
| 2024-06-04 | AGG | ETF | 97.0 | 97.24 | 96.94 | 97.15 | 3979100.0 |
| 2024-06-04 | AGGH | ETF | 20.98 | 20.99 | 20.8801 | 20.89 | 52113.0 |
| 2024-06-04 | AGGY | ETF | 43.05 | 43.16 | 43.04 | 43.16 | 80600.0 |
| 2024-06-04 | AGMI | ETF | 27.46 | 27.46 | 26.607 | 26.607 | 711.0 |
| 2024-06-04 | AGNG | ETF | 29.91 | 30.169 | 29.91 | 30.12 | 2200.0 |
| 2024-06-04 | AGOX | ETF | 26.5 | 26.53 | 26.34 | 26.48 | 16500.0 |
| 2024-06-04 | AGQ | ETF | 40.0 | 40.0 | 38.54 | 39.0 | 2387100.0 |
| 2024-06-04 | AGQI | ETF | 14.25 | 14.3241 | 14.24 | 14.3241 | 11060.0 |
| 2024-06-04 | AGZ | ETF | 107.43 | 108.07 | 107.43 | 107.75 | 78500.0 |
> showing 50 of 3,381 rows — these rows as CSV