PREVIEW / etf_daily / 2024-10-07
file: by_date/etf_daily/2024/2024-10-07.parquet size: 142 KB rows: 3,741
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-10-07 | SPY | ETF | 571.3 | 571.9599 | 566.63 | 567.8 | 49791417.0 |
| 2024-10-07 | QQQ | ETF | 485.39 | 486.57 | 480.87 | 482.1 | 24975119.0 |
| 2024-10-07 | IWM | ETF | 218.64 | 218.66 | 215.87 | 217.43 | 14548002.0 |
| 2024-10-07 | DIA | ETF | 422.11 | 422.93 | 418.26 | 419.61 | 2627308.0 |
| 2024-10-07 | GLD | ETF | 244.58 | 244.82 | 243.81 | 244.17 | 3836236.0 |
| 2024-10-07 | TLT | ETF | 94.98 | 95.2672 | 94.76 | 94.83 | 42236367.0 |
| 2024-10-07 | AAA | ETF | 25.05 | 25.07 | 25.0 | 25.04 | 17483.0 |
| 2024-10-07 | AAAU | ETF | 26.19 | 26.205 | 26.0962 | 26.14 | 2720014.0 |
| 2024-10-07 | AADR | ETF | 63.2871 | 63.59 | 63.2871 | 63.59 | 380.0 |
| 2024-10-07 | AAPB | ETF | 27.87 | 28.0497 | 27.01 | 27.06 | 113375.0 |
| 2024-10-07 | AAPD | ETF | 17.08 | 17.3 | 16.98 | 17.28 | 206228.0 |
| 2024-10-07 | AAPR | ETF | 26.09 | 26.09 | 26.064 | 26.064 | 2260.0 |
| 2024-10-07 | AAPU | ETF | 35.22 | 35.5695 | 34.225 | 34.32 | 458008.0 |
| 2024-10-07 | AAPX | ETF | 32.18 | 32.31 | 31.2399 | 31.2399 | 27444.0 |
| 2024-10-07 | AAPY | ETF | 26.9613 | 26.9613 | 26.6325 | 26.6325 | 1270.0 |
| 2024-10-07 | AAXJ | ETF | 81.55 | 82.25 | 81.22 | 82.16 | 905823.0 |
| 2024-10-07 | ABCS | ETF | 28.006 | 28.06 | 27.835 | 27.9699 | 1200.0 |
| 2024-10-07 | ABEQ | ETF | 32.33 | 32.33 | 32.15 | 32.17 | 1788.0 |
| 2024-10-07 | ABNY | ETF | 83.4 | 83.4 | 82.6505 | 83.05 | 458.0 |
| 2024-10-07 | ACES | ETF | 28.92 | 29.13 | 28.59 | 28.85 | 22830.0 |
| 2024-10-07 | ACIO | ETF | 39.71 | 39.73 | 39.4427 | 39.5 | 405155.0 |
| 2024-10-07 | ACSI | ETF | 57.1375 | 57.1375 | 57.1375 | 57.1375 | 67.0 |
| 2024-10-07 | ACT | ETF | 36.19 | 36.19 | 35.55 | 35.74 | 300503.0 |
| 2024-10-07 | ACTV | ETF | 33.64 | 33.64 | 33.22 | 33.4607 | 5361.0 |
| 2024-10-07 | ACVF | ETF | 43.53 | 43.55 | 43.2253 | 43.2797 | 7852.0 |
| 2024-10-07 | ACWI | ETF | 119.35 | 119.38 | 118.395 | 118.73 | 2220202.0 |
| 2024-10-07 | ACWV | ETF | 114.135 | 114.135 | 113.3419 | 113.65 | 131021.0 |
| 2024-10-07 | ACWX | ETF | 57.13 | 57.16 | 56.73 | 56.98 | 439191.0 |
| 2024-10-07 | ADFI | ETF | 8.64 | 8.68 | 8.64 | 8.65 | 8958.0 |
| 2024-10-07 | ADIV | ETF | 16.96 | 17.6 | 16.9308 | 17.0486 | 4726.0 |
| 2024-10-07 | ADME | ETF | 46.14 | 46.14 | 45.75 | 45.8 | 16201.0 |
| 2024-10-07 | ADPV | ETF | 31.85 | 31.85 | 31.63 | 31.68 | 2966.0 |
| 2024-10-07 | ADVE | ETF | 37.0529 | 37.0529 | 37.0529 | 37.0529 | 76.0 |
| 2024-10-07 | AESR | ETF | 16.98 | 17.01 | 16.81 | 16.86 | 11833.0 |
| 2024-10-07 | AETH | ETF | 31.7201 | 32.3889 | 31.3599 | 31.3767 | 10412.0 |
| 2024-10-07 | AFIF | ETF | 9.21 | 9.21 | 9.1912 | 9.2 | 13422.0 |
| 2024-10-07 | AFK | ETF | 16.87 | 16.92 | 16.64 | 16.66 | 4168.0 |
| 2024-10-07 | AFLG | ETF | 34.07 | 34.07 | 33.79 | 33.8387 | 791420.0 |
| 2024-10-07 | AFMC | ETF | 31.89 | 31.89 | 31.81 | 31.8461 | 398.0 |
| 2024-10-07 | AFSM | ETF | 30.31 | 30.37 | 30.22 | 30.31 | 2503.0 |
| 2024-10-07 | AFTY | ETF | 16.4 | 16.43 | 16.312 | 16.4 | 115066.0 |
| 2024-10-07 | AGG | ETF | 99.64 | 99.765 | 99.58 | 99.62 | 6381931.0 |
| 2024-10-07 | AGGH | ETF | 21.4 | 21.4 | 21.2 | 21.2 | 63851.0 |
| 2024-10-07 | AGGS | ETF | 41.8233 | 41.8233 | 41.8233 | 41.8233 | 6.0 |
| 2024-10-07 | AGGY | ETF | 44.24 | 44.25 | 44.16 | 44.16 | 83713.0 |
| 2024-10-07 | AGIH | ETF | 24.8782 | 24.8782 | 24.8782 | 24.8782 | 8.0 |
| 2024-10-07 | AGIX | ETF | 25.47 | 25.53 | 25.3271 | 25.345 | 5484.0 |
| 2024-10-07 | AGMI | ETF | 29.442 | 29.5513 | 29.442 | 29.5513 | 169.0 |
| 2024-10-07 | AGNG | ETF | 32.48 | 32.48 | 32.2 | 32.28 | 2195.0 |
| 2024-10-07 | AGOX | ETF | 28.8 | 29.28 | 28.5901 | 29.0261 | 26152.0 |
> showing 50 of 3,741 rows — these rows as CSV