PREVIEW / etf_daily / 2024-08-01
file: by_date/etf_daily/2024/2024-08-01.parquet size: 133 KB rows: 3,460
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-08-01 | SPY | ETF | 552.57 | 554.8688 | 539.43 | 543.01 | 75244132.0 |
| 2024-08-01 | QQQ | ETF | 471.76 | 475.55 | 455.98 | 459.66 | 56653900.0 |
| 2024-08-01 | IWM | ETF | 223.77 | 224.89 | 215.06 | 216.58 | 71407529.0 |
| 2024-08-01 | DIA | ETF | 409.7 | 410.93 | 400.96 | 403.23 | 5483581.0 |
| 2024-08-01 | GLD | ETF | 226.74 | 227.57 | 225.05 | 225.77 | 7107613.0 |
| 2024-08-01 | TLT | ETF | 95.14 | 95.905 | 95.12 | 95.31 | 80208508.0 |
| 2024-08-01 | AAA | ETF | 25.0593 | 25.075 | 25.0301 | 25.0449 | 4428.0 |
| 2024-08-01 | AAAU | ETF | 24.27 | 24.3411 | 24.08 | 24.165 | 3174268.0 |
| 2024-08-01 | AADR | ETF | 59.88 | 60.22 | 59.88 | 60.22 | 202.0 |
| 2024-08-01 | AAPB | ETF | 28.39 | 28.4 | 26.62 | 26.9 | 269689.0 |
| 2024-08-01 | AAPD | ETF | 17.15 | 17.72 | 17.15 | 17.63 | 526188.0 |
| 2024-08-01 | AAPR | ETF | 25.545 | 25.56 | 25.36 | 25.3961 | 5806.0 |
| 2024-08-01 | AAPU | ETF | 36.45 | 36.45 | 34.079 | 34.46 | 1434316.0 |
| 2024-08-01 | AAPX | ETF | 32.87 | 32.87 | 30.93 | 31.29 | 99200.0 |
| 2024-08-01 | AAPY | ETF | 26.93 | 26.95 | 26.4213 | 26.4213 | 929.0 |
| 2024-08-01 | AAXJ | ETF | 71.86 | 72.08 | 70.83 | 71.05 | 375497.0 |
| 2024-08-01 | ABCS | ETF | 27.81 | 27.88 | 27.1471 | 27.32 | 4521.0 |
| 2024-08-01 | ABEQ | ETF | 31.28 | 31.305 | 31.25 | 31.29 | 2801.0 |
| 2024-08-01 | ABNY | ETF | 95.0005 | 95.2 | 93.05 | 94.423 | 2091.0 |
| 2024-08-01 | ACES | ETF | 30.26 | 30.57 | 29.145 | 29.3363 | 18163.0 |
| 2024-08-01 | ACIO | ETF | 38.42 | 38.445 | 37.765 | 37.9 | 86327.0 |
| 2024-08-01 | ACSI | ETF | 55.13 | 55.171 | 55.13 | 55.171 | 153.0 |
| 2024-08-01 | ACT | ETF | 34.7 | 35.41 | 33.235 | 33.49 | 216341.0 |
| 2024-08-01 | ACTV | ETF | 34.34 | 34.34 | 33.4601 | 33.6846 | 3621.0 |
| 2024-08-01 | ACVF | ETF | 41.84 | 41.902 | 41.08 | 41.1336 | 25467.0 |
| 2024-08-01 | ACWI | ETF | 113.98 | 114.41 | 111.47 | 112.1 | 2101464.0 |
| 2024-08-01 | ACWV | ETF | 108.34 | 108.66 | 108.0 | 108.5 | 221034.0 |
| 2024-08-01 | ACWX | ETF | 53.82 | 53.895 | 52.78 | 52.98 | 1231996.0 |
| 2024-08-01 | ADFI | ETF | 8.64 | 8.64 | 8.59 | 8.62 | 14848.0 |
| 2024-08-01 | ADIV | ETF | 14.52 | 14.52 | 14.35 | 14.35 | 164.0 |
| 2024-08-01 | ADME | ETF | 44.52 | 44.52 | 43.67 | 43.85 | 5326.0 |
| 2024-08-01 | ADPV | ETF | 31.44 | 31.44 | 29.8 | 30.0151 | 3426.0 |
| 2024-08-01 | AEMB | ETF | 38.7585 | 38.7585 | 38.7585 | 38.7585 | 69.0 |
| 2024-08-01 | AESR | ETF | 16.09 | 16.11 | 15.9178 | 16.0093 | 14577.0 |
| 2024-08-01 | AETH | ETF | 41.43 | 41.43 | 40.29 | 40.76 | 7327.0 |
| 2024-08-01 | AFIF | ETF | 9.16 | 9.17 | 9.15 | 9.17 | 16765.0 |
| 2024-08-01 | AFK | ETF | 16.09 | 16.28 | 15.8937 | 15.97 | 106820.0 |
| 2024-08-01 | AFLG | ETF | 32.0 | 32.0 | 31.641 | 31.801 | 21949.0 |
| 2024-08-01 | AFMC | ETF | 30.78 | 30.81 | 30.62 | 30.81 | 5112.0 |
| 2024-08-01 | AFSM | ETF | 31.18 | 31.25 | 29.94 | 30.1119 | 12405.0 |
| 2024-08-01 | AFTY | ETF | 13.8828 | 13.8828 | 13.8828 | 13.8828 | 0.0 |
| 2024-08-01 | AGG | ETF | 99.01 | 99.32 | 99.005 | 99.22 | 9642593.0 |
| 2024-08-01 | AGGH | ETF | 21.07 | 21.36 | 21.07 | 21.36 | 69674.0 |
| 2024-08-01 | AGGY | ETF | 43.76 | 43.92 | 43.64 | 43.86 | 49194.0 |
| 2024-08-01 | AGIX | ETF | 24.5 | 24.6205 | 23.3772 | 23.558 | 14640.0 |
| 2024-08-01 | AGMI | ETF | 27.77 | 27.77 | 26.6156 | 26.6156 | 271.0 |
| 2024-08-01 | AGNG | ETF | 31.07 | 31.97 | 31.07 | 31.27 | 38427.0 |
| 2024-08-01 | AGOX | ETF | 28.09 | 28.09 | 27.38 | 27.5148 | 46721.0 |
| 2024-08-01 | AGQ | ETF | 36.35 | 36.4185 | 34.21 | 34.95 | 1644221.0 |
| 2024-08-01 | AGQI | ETF | 14.29 | 14.29 | 14.095 | 14.12 | 15630.0 |
> showing 50 of 3,460 rows — these rows as CSV