PREVIEW / etf_daily / 2024-08-13
file: by_date/etf_daily/2024/2024-08-13.parquet size: 131 KB rows: 3,420
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-13 | SPY | ETF | 536.53 | 542.28 | 536.28 | 542.04 | 50135345.0 |
| 2024-08-13 | QQQ | ETF | 455.82 | 462.85 | 455.68 | 462.58 | 40084457.0 |
| 2024-08-13 | IWM | ETF | 206.09 | 208.38 | 204.86 | 207.97 | 23652109.0 |
| 2024-08-13 | DIA | ETF | 395.07 | 398.13 | 394.07 | 397.79 | 3508762.0 |
| 2024-08-13 | GLD | ETF | 228.07 | 228.87 | 227.59 | 228.06 | 6631146.0 |
| 2024-08-13 | TLT | ETF | 97.3 | 97.36 | 96.98 | 97.28 | 30327650.0 |
| 2024-08-13 | AAA | ETF | 25.08 | 25.08 | 25.0 | 25.065 | 4466.0 |
| 2024-08-13 | AAAU | ETF | 24.42 | 24.49 | 24.3599 | 24.4 | 1288202.0 |
| 2024-08-13 | AADR | ETF | 60.34 | 60.6 | 60.34 | 60.6 | 261.0 |
| 2024-08-13 | AAPB | ETF | 26.96 | 27.63 | 26.96 | 27.47 | 61621.0 |
| 2024-08-13 | AAPD | ETF | 17.53 | 17.53 | 17.3101 | 17.36 | 474389.0 |
| 2024-08-13 | AAPR | ETF | 25.4 | 25.5 | 25.4 | 25.5 | 5124.0 |
| 2024-08-13 | AAPU | ETF | 34.57 | 35.42 | 34.57 | 35.21 | 592359.0 |
| 2024-08-13 | AAPX | ETF | 31.61 | 32.0329 | 31.58 | 31.86 | 58125.0 |
| 2024-08-13 | AAPY | ETF | 26.86 | 26.9686 | 26.86 | 26.9452 | 795.0 |
| 2024-08-13 | AAXJ | ETF | 71.02 | 71.74 | 71.02 | 71.69 | 279864.0 |
| 2024-08-13 | ABCS | ETF | 26.365 | 26.67 | 26.365 | 26.653 | 2394.0 |
| 2024-08-13 | ABEQ | ETF | 31.1 | 31.26 | 31.1 | 31.2414 | 4155.0 |
| 2024-08-13 | ABNY | ETF | 78.825 | 79.342 | 78.825 | 79.1675 | 400.0 |
| 2024-08-13 | ACES | ETF | 27.14 | 28.07 | 27.14 | 28.0 | 80061.0 |
| 2024-08-13 | ACIO | ETF | 37.81 | 38.0099 | 37.715 | 37.97 | 137084.0 |
| 2024-08-13 | ACSI | ETF | 55.2385 | 55.2385 | 55.2385 | 55.2385 | 22.0 |
| 2024-08-13 | ACT | ETF | 33.19 | 33.35 | 33.04 | 33.34 | 208742.0 |
| 2024-08-13 | ACTV | ETF | 30.94 | 31.3 | 30.94 | 31.2873 | 4008.0 |
| 2024-08-13 | ACVF | ETF | 40.7 | 41.19 | 40.7 | 41.121 | 6878.0 |
| 2024-08-13 | ACWI | ETF | 111.25 | 112.4 | 111.18 | 112.31 | 2892454.0 |
| 2024-08-13 | ACWV | ETF | 108.48 | 108.81 | 108.17 | 108.76 | 249063.0 |
| 2024-08-13 | ACWX | ETF | 52.95 | 53.475 | 52.95 | 53.44 | 458747.0 |
| 2024-08-13 | ADFI | ETF | 8.66 | 8.73 | 8.6301 | 8.73 | 17193.0 |
| 2024-08-13 | ADIV | ETF | 14.72 | 14.72 | 14.72 | 14.72 | 8.0 |
| 2024-08-13 | ADME | ETF | 43.67 | 43.9593 | 43.64 | 43.9255 | 4060.0 |
| 2024-08-13 | ADPV | ETF | 30.14 | 30.204 | 30.14 | 30.204 | 365.0 |
| 2024-08-13 | AEMB | ETF | 38.99 | 39.3 | 38.99 | 39.2027 | 3002.0 |
| 2024-08-13 | AESR | ETF | 15.92 | 16.1418 | 15.92 | 16.1418 | 26424.0 |
| 2024-08-13 | AETH | ETF | 34.32 | 35.2432 | 34.24 | 35.2226 | 2860.0 |
| 2024-08-13 | AFIF | ETF | 9.19 | 9.19 | 9.17 | 9.185 | 23191.0 |
| 2024-08-13 | AFK | ETF | 15.63 | 15.729 | 15.5 | 15.7 | 13884.0 |
| 2024-08-13 | AFLG | ETF | 31.64 | 31.83 | 31.64 | 31.819 | 1495.0 |
| 2024-08-13 | AFMC | ETF | 29.8 | 29.9858 | 29.8 | 29.9858 | 422.0 |
| 2024-08-13 | AFSM | ETF | 28.84 | 28.8686 | 28.47 | 28.8686 | 3600.0 |
| 2024-08-13 | AFTY | ETF | 13.9701 | 13.9701 | 13.9701 | 13.9701 | 0.0 |
| 2024-08-13 | AGG | ETF | 100.04 | 100.12 | 99.93 | 100.12 | 3901539.0 |
| 2024-08-13 | AGGH | ETF | 21.69 | 21.69 | 21.505 | 21.61 | 68745.0 |
| 2024-08-13 | AGGY | ETF | 44.19 | 44.2421 | 44.15 | 44.24 | 37315.0 |
| 2024-08-13 | AGIX | ETF | 23.6301 | 23.9362 | 23.6301 | 23.9362 | 4272.0 |
| 2024-08-13 | AGMI | ETF | 24.81 | 25.3078 | 24.81 | 25.3078 | 102.0 |
| 2024-08-13 | AGNG | ETF | 31.28 | 31.74 | 31.28 | 31.646 | 16979.0 |
| 2024-08-13 | AGOX | ETF | 27.32 | 28.09 | 27.32 | 28.0551 | 32776.0 |
| 2024-08-13 | AGQ | ETF | 32.61 | 33.18 | 32.33 | 33.14 | 1305916.0 |
| 2024-08-13 | AGQI | ETF | 14.0 | 14.1148 | 14.0 | 14.1148 | 7233.0 |
> showing 50 of 3,420 rows — these rows as CSV