PREVIEW / etf_daily / 2024-08-05
file: by_date/etf_daily/2024/2024-08-05.parquet size: 132 KB rows: 3,514
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-05 | SPY | ETF | 511.64 | 523.58 | 510.27 | 517.38 | 145734722.0 |
| 2024-08-05 | QQQ | ETF | 424.71 | 442.29 | 423.45 | 435.37 | 87483452.0 |
| 2024-08-05 | IWM | ETF | 197.9 | 204.74 | 196.7 | 202.2 | 65516099.0 |
| 2024-08-05 | DIA | ETF | 386.515 | 390.3 | 384.9309 | 386.81 | 8666615.0 |
| 2024-08-05 | GLD | ETF | 220.56 | 223.1 | 220.241 | 222.48 | 8906641.0 |
| 2024-08-05 | TLT | ETF | 99.69 | 99.935 | 97.9 | 98.8 | 90389896.0 |
| 2024-08-05 | AAA | ETF | 25.0 | 25.08 | 25.0 | 25.0366 | 3099.0 |
| 2024-08-05 | AAAU | ETF | 23.61 | 23.8774 | 23.57 | 23.82 | 2913195.0 |
| 2024-08-05 | AADR | ETF | 54.57 | 57.1 | 54.57 | 56.73 | 2306.0 |
| 2024-08-05 | AAPB | ETF | 21.95 | 25.54 | 21.38 | 24.54 | 339768.0 |
| 2024-08-05 | AAPD | ETF | 19.18 | 19.41 | 18.04 | 18.37 | 2114837.0 |
| 2024-08-05 | AAPR | ETF | 25.14 | 25.33 | 25.14 | 25.21 | 40900.0 |
| 2024-08-05 | AAPU | ETF | 28.18 | 32.8 | 27.31 | 31.48 | 2005440.0 |
| 2024-08-05 | AAPX | ETF | 25.75 | 29.6 | 24.95 | 28.53 | 86011.0 |
| 2024-08-05 | AAPY | ETF | 24.37 | 25.7 | 24.37 | 25.4099 | 2237.0 |
| 2024-08-05 | AAXJ | ETF | 66.23 | 68.48 | 66.23 | 68.09 | 698329.0 |
| 2024-08-05 | ABCS | ETF | 25.655 | 25.9 | 25.655 | 25.9 | 1318.0 |
| 2024-08-05 | ABEQ | ETF | 30.42 | 30.5899 | 30.42 | 30.582 | 1930.0 |
| 2024-08-05 | ABNY | ETF | 87.75 | 88.5275 | 87.75 | 88.5275 | 677.0 |
| 2024-08-05 | ACES | ETF | 26.26 | 27.73 | 26.135 | 27.18 | 172233.0 |
| 2024-08-05 | ACIO | ETF | 36.64 | 37.08 | 36.42 | 36.82 | 184312.0 |
| 2024-08-05 | ACSI | ETF | 52.884 | 52.9489 | 52.884 | 52.9489 | 635.0 |
| 2024-08-05 | ACT | ETF | 32.58 | 32.58 | 31.69 | 32.3 | 259445.0 |
| 2024-08-05 | ACTV | ETF | 31.27 | 31.8412 | 31.27 | 31.44 | 11353.0 |
| 2024-08-05 | ACVF | ETF | 39.08 | 39.7101 | 39.04 | 39.3016 | 19089.0 |
| 2024-08-05 | ACWI | ETF | 105.31 | 108.235 | 105.31 | 107.24 | 6883522.0 |
| 2024-08-05 | ACWV | ETF | 106.68 | 107.04 | 105.88 | 106.26 | 351712.0 |
| 2024-08-05 | ACWX | ETF | 50.02 | 51.27 | 49.84 | 50.99 | 2100583.0 |
| 2024-08-05 | ADFI | ETF | 8.65 | 8.69 | 8.61 | 8.62 | 13428.0 |
| 2024-08-05 | ADIV | ETF | 14.2 | 14.2 | 13.78 | 13.9167 | 2390.0 |
| 2024-08-05 | ADME | ETF | 43.429 | 43.496 | 42.68 | 42.72 | 466275.0 |
| 2024-08-05 | ADPV | ETF | 28.4 | 28.59 | 27.58 | 28.4292 | 2879.0 |
| 2024-08-05 | ADVE | ETF | 31.47 | 31.47 | 31.4477 | 31.4477 | 213.0 |
| 2024-08-05 | AEMB | ETF | 38.6727 | 38.6727 | 38.6727 | 38.6727 | 146.0 |
| 2024-08-05 | AESR | ETF | 15.01 | 15.42 | 15.01 | 15.26 | 26834.0 |
| 2024-08-05 | AETH | ETF | 28.57 | 32.3096 | 28.33 | 31.31 | 26642.0 |
| 2024-08-05 | AFIF | ETF | 9.1901 | 9.22 | 9.19 | 9.195 | 6787.0 |
| 2024-08-05 | AFK | ETF | 14.56 | 15.0 | 14.45 | 14.88 | 330747.0 |
| 2024-08-05 | AFLG | ETF | 29.94 | 30.63 | 29.94 | 30.43 | 12227.0 |
| 2024-08-05 | AFMC | ETF | 29.16 | 29.28 | 29.15 | 29.2 | 4383.0 |
| 2024-08-05 | AFSM | ETF | 27.81 | 28.401 | 27.31 | 28.15 | 7395.0 |
| 2024-08-05 | AFTY | ETF | 14.06 | 14.06 | 14.06 | 14.06 | 595.0 |
| 2024-08-05 | AGG | ETF | 100.82 | 100.89 | 100.0205 | 100.25 | 12008851.0 |
| 2024-08-05 | AGGH | ETF | 21.78 | 21.78 | 21.3 | 21.56 | 105255.0 |
| 2024-08-05 | AGGS | ETF | 42.31 | 42.34 | 42.1468 | 42.1468 | 425.0 |
| 2024-08-05 | AGGY | ETF | 44.36 | 44.4599 | 44.185 | 44.24 | 100099.0 |
| 2024-08-05 | AGIX | ETF | 22.1 | 22.11 | 21.82 | 22.0545 | 13365.0 |
| 2024-08-05 | AGMI | ETF | 23.7 | 24.4089 | 23.7 | 24.4089 | 441.0 |
| 2024-08-05 | AGNG | ETF | 30.54 | 30.659 | 30.2001 | 30.48 | 4584.0 |
| 2024-08-05 | AGOX | ETF | 26.69 | 27.145 | 26.3983 | 26.6 | 36105.0 |
> showing 50 of 3,514 rows — these rows as CSV