PREVIEW / etf_daily / 2024-07-01
file: by_date/etf_daily/2024/2024-07-01.parquet size: 125 KB rows: 3,398
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-07-01 | SPY | ETF | 545.63 | 545.88 | 542.52 | 545.34 | 39936800.0 |
| 2024-07-01 | QQQ | ETF | 480.04 | 482.49 | 476.255 | 481.92 | 24898336.0 |
| 2024-07-01 | IWM | ETF | 203.52 | 203.82 | 200.48 | 201.19 | 21837500.0 |
| 2024-07-01 | DIA | ETF | 392.08 | 394.26 | 390.26 | 391.35 | 2289033.0 |
| 2024-07-01 | GLD | ETF | 215.25 | 216.0 | 214.49 | 215.57 | 3698000.0 |
| 2024-07-01 | TLT | ETF | 90.42 | 91.08 | 89.82 | 89.91 | 49457800.0 |
| 2024-07-01 | AAA | ETF | 25.06 | 25.07 | 25.0315 | 25.06 | 2889.0 |
| 2024-07-01 | AAAU | ETF | 23.04 | 23.1 | 22.945 | 22.9757 | 447475.0 |
| 2024-07-01 | AAPB | ETF | 25.67 | 26.98 | 25.65 | 26.82 | 204266.0 |
| 2024-07-01 | AAPD | ETF | 18.11 | 18.11 | 17.65 | 17.71 | 407548.0 |
| 2024-07-01 | AAPR | ETF | 25.3 | 25.3 | 25.2061 | 25.29 | 37957.0 |
| 2024-07-01 | AAPU | ETF | 33.01 | 34.66 | 32.99 | 34.44 | 1194722.0 |
| 2024-07-01 | AAPX | ETF | 29.84 | 31.4396 | 29.84 | 31.24 | 33120.0 |
| 2024-07-01 | AAPY | ETF | 26.42 | 26.7 | 26.3801 | 26.6192 | 1282.0 |
| 2024-07-01 | AAXJ | ETF | 72.36 | 72.49 | 72.025 | 72.05 | 94973.0 |
| 2024-07-01 | ABCS | ETF | 25.8578 | 25.92 | 25.75 | 25.7819 | 2506.0 |
| 2024-07-01 | ABNY | ETF | 105.4 | 105.4 | 101.35 | 101.9385 | 537.0 |
| 2024-07-01 | ACES | ETF | 28.21 | 28.225 | 28.05 | 28.05 | 6969.0 |
| 2024-07-01 | ACIO | ETF | 37.71 | 37.7738 | 37.615 | 37.6425 | 11543.0 |
| 2024-07-01 | ACT | ETF | 30.85 | 31.08 | 30.54 | 31.01 | 177319.0 |
| 2024-07-01 | ACTV | ETF | 32.21 | 32.21 | 32.04 | 32.04 | 327.0 |
| 2024-07-01 | ACVF | ETF | 41.45 | 41.13 | 41.13 | 41.13 | 1113.0 |
| 2024-07-01 | ACWI | ETF | 112.81 | 112.865 | 112.16 | 112.24 | 613828.0 |
| 2024-07-01 | ACWV | ETF | 104.75 | 105.2 | 104.57 | 104.61 | 107850.0 |
| 2024-07-01 | ACWX | ETF | 53.36 | 53.51 | 53.11 | 53.16 | 450539.0 |
| 2024-07-01 | ADFI | ETF | 8.43 | 8.43 | 8.43 | 8.43 | 3106.0 |
| 2024-07-01 | ADIV | ETF | 14.72 | 14.72 | 14.72 | 14.72 | 208.0 |
| 2024-07-01 | ADME | ETF | 43.9 | 43.84 | 43.74 | 43.74 | 1398.0 |
| 2024-07-01 | ADPV | ETF | 30.35 | 30.35 | 30.26 | 30.287 | 5072.0 |
| 2024-07-01 | ADVE | ETF | 32.69 | 32.69 | 32.6432 | 32.6432 | 122032.0 |
| 2024-07-01 | AESR | ETF | 16.41 | 16.41 | 16.41 | 16.41 | 428.0 |
| 2024-07-01 | AETH | ETF | 45.36 | 45.61 | 45.1973 | 45.3194 | 2484.0 |
| 2024-07-01 | AFIF | ETF | 9.11 | 9.11 | 9.11 | 9.11 | 341.0 |
| 2024-07-01 | AFK | ETF | 15.84 | 15.87 | 15.51 | 15.51 | 5369.0 |
| 2024-07-01 | AFMC | ETF | 29.1 | 29.1 | 29.1 | 29.1 | 101.0 |
| 2024-07-01 | AGG | ETF | 96.43 | 96.66 | 96.23 | 96.265 | 2167791.0 |
| 2024-07-01 | AGGH | ETF | 20.79 | 20.79 | 20.58 | 20.69 | 89324.0 |
| 2024-07-01 | AGGS | ETF | 40.56 | 40.56 | 40.5399 | 40.5399 | 625.0 |
| 2024-07-01 | AGGY | ETF | 42.81 | 42.86 | 42.74 | 42.74 | 13084.0 |
| 2024-07-01 | AGMI | ETF | 25.69 | 25.69 | 25.3837 | 25.3837 | 100.0 |
| 2024-07-01 | AGOX | ETF | 27.9 | 28.03 | 27.8407 | 27.92 | 4025.0 |
| 2024-07-01 | AGQ | ETF | 37.44 | 38.028 | 37.11 | 37.354 | 434901.0 |
| 2024-07-01 | AGQI | ETF | 14.36 | 14.37 | 14.27 | 14.3035 | 14317.0 |
| 2024-07-01 | AGZ | ETF | 107.22 | 107.41 | 107.3 | 107.3 | 1752.0 |
| 2024-07-01 | AGZD | ETF | 22.11 | 22.26 | 22.11 | 22.26 | 4070.0 |
| 2024-07-01 | AHLT | ETF | 25.3415 | 25.456 | 25.3415 | 25.456 | 2250.0 |
| 2024-07-01 | AHYB | ETF | 45.07 | 45.07 | 45.04 | 45.04 | 414.0 |
| 2024-07-01 | AIA | ETF | 67.56 | 67.56 | 67.14 | 67.14 | 2438.0 |
| 2024-07-01 | AIBU | ETF | 28.84 | 28.934 | 27.95 | 28.934 | 8204.0 |
| 2024-07-01 | AIEQ | ETF | 36.32 | 36.4302 | 36.14 | 36.155 | 2987.0 |
> showing 50 of 3,398 rows — these rows as CSV