PREVIEW / etf_daily / 2024-09-24
file: by_date/etf_daily/2024/2024-09-24.parquet size: 135 KB rows: 3,549
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-09-24 | SPY | ETF | 570.48 | 571.36 | 567.6 | 571.3 | 47439363.0 |
| 2024-09-24 | QQQ | ETF | 484.46 | 486.33 | 480.17 | 485.37 | 25952637.0 |
| 2024-09-24 | IWM | ETF | 221.63 | 221.93 | 219.5 | 221.13 | 20902097.0 |
| 2024-09-24 | DIA | ETF | 421.67 | 422.65 | 420.38 | 422.13 | 2789479.0 |
| 2024-09-24 | GLD | ETF | 243.39 | 246.19 | 243.15 | 246.07 | 8271441.0 |
| 2024-09-24 | TLT | ETF | 98.0 | 98.89 | 97.85 | 98.65 | 30964144.0 |
| 2024-09-24 | AAA | ETF | 25.15 | 25.15 | 25.03 | 25.095 | 10125.0 |
| 2024-09-24 | AAAU | ETF | 26.06 | 26.3507 | 26.035 | 26.34 | 1964009.0 |
| 2024-09-24 | AADR | ETF | 63.95 | 63.95 | 63.95 | 63.95 | 103.0 |
| 2024-09-24 | AAPB | ETF | 28.87 | 29.0606 | 28.21 | 28.65 | 135710.0 |
| 2024-09-24 | AAPD | ETF | 16.74 | 16.95 | 16.695 | 16.84 | 180318.0 |
| 2024-09-24 | AAPR | ETF | 26.2 | 26.2057 | 26.1401 | 26.2057 | 5533.0 |
| 2024-09-24 | AAPU | ETF | 36.68 | 36.9 | 35.78 | 36.28 | 540886.0 |
| 2024-09-24 | AAPX | ETF | 33.56 | 33.56 | 32.65 | 32.9269 | 16545.0 |
| 2024-09-24 | AAPY | ETF | 27.51 | 27.555 | 27.4835 | 27.4835 | 1481.0 |
| 2024-09-24 | AAXJ | ETF | 76.71 | 77.6 | 76.37 | 77.46 | 368132.0 |
| 2024-09-24 | ABCS | ETF | 28.2701 | 28.3301 | 28.27 | 28.2794 | 1743.0 |
| 2024-09-24 | ABEQ | ETF | 32.8358 | 32.8358 | 32.73 | 32.76 | 2118.0 |
| 2024-09-24 | ABNY | ETF | 81.25 | 83.2325 | 81.25 | 83.2325 | 317.0 |
| 2024-09-24 | ACES | ETF | 29.18 | 29.25 | 28.9207 | 29.06 | 47488.0 |
| 2024-09-24 | ACIO | ETF | 39.7 | 39.829 | 39.48 | 39.7 | 439107.0 |
| 2024-09-24 | ACSI | ETF | 57.87 | 57.9482 | 57.8454 | 57.9482 | 966.0 |
| 2024-09-24 | ACT | ETF | 36.51 | 36.51 | 35.845 | 35.94 | 350136.0 |
| 2024-09-24 | ACTV | ETF | 33.545 | 33.62 | 33.48 | 33.5 | 9296.0 |
| 2024-09-24 | ACVF | ETF | 43.42 | 43.52 | 43.3865 | 43.5 | 11827.0 |
| 2024-09-24 | ACWI | ETF | 118.73 | 119.06 | 118.2601 | 119.02 | 1765890.0 |
| 2024-09-24 | ACWV | ETF | 114.66 | 114.67 | 114.175 | 114.61 | 105404.0 |
| 2024-09-24 | ACWX | ETF | 56.57 | 56.885 | 56.42 | 56.87 | 573074.0 |
| 2024-09-24 | ADFI | ETF | 8.79 | 8.81 | 8.77 | 8.8051 | 7254.0 |
| 2024-09-24 | ADIV | ETF | 16.09 | 16.2208 | 16.09 | 16.2208 | 2702.0 |
| 2024-09-24 | ADME | ETF | 45.83 | 46.11 | 45.83 | 46.0692 | 4950.0 |
| 2024-09-24 | ADPV | ETF | 32.05 | 32.05 | 31.73 | 31.8441 | 18524.0 |
| 2024-09-24 | AEMB | ETF | 39.33 | 39.4443 | 39.33 | 39.4443 | 150.0 |
| 2024-09-24 | AESR | ETF | 16.8506 | 16.9 | 16.8506 | 16.8888 | 7867.0 |
| 2024-09-24 | AETH | ETF | 34.1 | 34.192 | 33.45 | 34.192 | 3260.0 |
| 2024-09-24 | AFIF | ETF | 9.16 | 9.2299 | 9.16 | 9.2 | 11350.0 |
| 2024-09-24 | AFK | ETF | 17.0 | 17.13 | 16.83 | 16.95 | 20557.0 |
| 2024-09-24 | AFLG | ETF | 33.95 | 33.95 | 33.91 | 33.93 | 2023.0 |
| 2024-09-24 | AFMC | ETF | 32.06 | 32.06 | 32.0493 | 32.0493 | 259.0 |
| 2024-09-24 | AFSM | ETF | 30.7 | 30.7 | 30.55 | 30.6154 | 13239.0 |
| 2024-09-24 | AFTY | ETF | 14.9 | 15.0022 | 14.83 | 15.0022 | 4710.0 |
| 2024-09-24 | AGG | ETF | 101.27 | 101.619 | 101.22 | 101.58 | 5803321.0 |
| 2024-09-24 | AGGH | ETF | 21.75 | 21.88 | 21.7138 | 21.84 | 61032.0 |
| 2024-09-24 | AGGY | ETF | 44.9 | 45.0599 | 44.89 | 45.04 | 65476.0 |
| 2024-09-24 | AGIX | ETF | 25.09 | 25.37 | 25.04 | 25.3466 | 2744.0 |
| 2024-09-24 | AGMI | ETF | 28.8 | 30.1015 | 28.8 | 30.1015 | 642.0 |
| 2024-09-24 | AGNG | ETF | 33.08 | 33.08 | 32.805 | 32.97 | 20955.0 |
| 2024-09-24 | AGOX | ETF | 28.57 | 29.2099 | 28.57 | 29.0 | 40621.0 |
| 2024-09-24 | AGQ | ETF | 40.18 | 43.555 | 39.93 | 43.4 | 3381564.0 |
| 2024-09-24 | AGQI | ETF | 14.69 | 14.715 | 14.64 | 14.715 | 31499.0 |
> showing 50 of 3,549 rows — these rows as CSV