PREVIEW / etf_daily / 2024-10-30
file: by_date/etf_daily/2024/2024-10-30.parquet size: 144 KB rows: 3,754
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-30 | SPY | ETF | 581.29 | 583.32 | 579.29 | 580.01 | 40847540.0 |
| 2024-10-30 | QQQ | ETF | 499.39 | 500.35 | 495.89 | 496.38 | 29755960.0 |
| 2024-10-30 | IWM | ETF | 221.07 | 224.48 | 220.9 | 221.44 | 19610234.0 |
| 2024-10-30 | DIA | ETF | 422.02 | 424.6501 | 421.45 | 421.75 | 2750128.0 |
| 2024-10-30 | GLD | ETF | 256.76 | 257.71 | 255.9101 | 257.5 | 6366363.0 |
| 2024-10-30 | TLT | ETF | 92.84 | 93.285 | 92.16 | 92.3 | 41893236.0 |
| 2024-10-30 | AAA | ETF | 25.17 | 25.17 | 25.12 | 25.15 | 6982.0 |
| 2024-10-30 | AAAU | ETF | 27.49 | 27.595 | 27.3903 | 27.57 | 1456953.0 |
| 2024-10-30 | AADR | ETF | 64.59 | 64.7452 | 64.58 | 64.7452 | 560.0 |
| 2024-10-30 | AAPB | ETF | 29.68 | 29.71 | 28.85 | 28.96 | 57864.0 |
| 2024-10-30 | AAPD | ETF | 16.51 | 16.72 | 16.48 | 16.67 | 226622.0 |
| 2024-10-30 | AAPR | ETF | 26.24 | 26.25 | 26.21 | 26.2111 | 6732.0 |
| 2024-10-30 | AAPU | ETF | 37.55 | 37.67 | 36.54 | 36.75 | 662424.0 |
| 2024-10-30 | AAPX | ETF | 34.0 | 34.17 | 33.31 | 33.31 | 9360.0 |
| 2024-10-30 | AAPY | ETF | 27.65 | 27.65 | 27.2759 | 27.2759 | 554.0 |
| 2024-10-30 | AAXJ | ETF | 76.27 | 76.68 | 76.14 | 76.29 | 338173.0 |
| 2024-10-30 | ABCS | ETF | 28.47 | 28.62 | 28.4571 | 28.4571 | 1808.0 |
| 2024-10-30 | ABEQ | ETF | 32.825 | 32.84 | 32.808 | 32.808 | 2450.0 |
| 2024-10-30 | ABNY | ETF | 82.5005 | 82.55 | 82.145 | 82.164 | 2261.0 |
| 2024-10-30 | ACES | ETF | 27.42 | 27.8954 | 27.42 | 27.55 | 27166.0 |
| 2024-10-30 | ACIO | ETF | 40.22 | 40.27 | 40.0519 | 40.1 | 161062.0 |
| 2024-10-30 | ACSI | ETF | 58.714 | 58.714 | 58.714 | 58.714 | 13.0 |
| 2024-10-30 | ACT | ETF | 34.53 | 35.16 | 34.53 | 34.71 | 654171.0 |
| 2024-10-30 | ACTV | ETF | 33.03 | 33.0704 | 32.7366 | 32.7366 | 2357.0 |
| 2024-10-30 | ACVF | ETF | 44.1486 | 44.1659 | 43.983 | 43.983 | 3318.0 |
| 2024-10-30 | ACWI | ETF | 118.9 | 119.495 | 118.71 | 118.84 | 1081884.0 |
| 2024-10-30 | ACWV | ETF | 112.52 | 112.74 | 112.38 | 112.5 | 157098.0 |
| 2024-10-30 | ACWX | ETF | 54.87 | 55.18 | 54.825 | 54.97 | 463150.0 |
| 2024-10-30 | ADFI | ETF | 8.55 | 8.6 | 8.55 | 8.58 | 17250.0 |
| 2024-10-30 | ADIV | ETF | 15.81 | 15.81 | 15.7684 | 15.7684 | 274.0 |
| 2024-10-30 | ADME | ETF | 46.72 | 46.79 | 46.505 | 46.56 | 27304.0 |
| 2024-10-30 | ADPV | ETF | 33.65 | 33.76 | 33.5016 | 33.5016 | 2900.0 |
| 2024-10-30 | ADVE | ETF | 34.84 | 34.84 | 34.7764 | 34.7764 | 112.0 |
| 2024-10-30 | AESR | ETF | 17.25 | 17.32 | 17.2157 | 17.2157 | 18140.0 |
| 2024-10-30 | AETH | ETF | 34.415 | 34.875 | 34.05 | 34.05 | 6928.0 |
| 2024-10-30 | AFIF | ETF | 9.1323 | 9.16 | 9.1323 | 9.155 | 72151.0 |
| 2024-10-30 | AFK | ETF | 16.77 | 16.83 | 16.71 | 16.71 | 2568.0 |
| 2024-10-30 | AFLG | ETF | 34.41 | 34.41 | 34.25 | 34.25 | 9759.0 |
| 2024-10-30 | AFMC | ETF | 32.39 | 32.39 | 32.22 | 32.22 | 3901.0 |
| 2024-10-30 | AFSM | ETF | 30.42 | 30.86 | 30.42 | 30.51 | 8788.0 |
| 2024-10-30 | AGG | ETF | 98.75 | 98.94 | 98.4 | 98.44 | 11185566.0 |
| 2024-10-30 | AGGH | ETF | 20.81 | 20.8291 | 20.6801 | 20.81 | 59380.0 |
| 2024-10-30 | AGGS | ETF | 41.49 | 41.49 | 41.375 | 41.375 | 400.0 |
| 2024-10-30 | AGGY | ETF | 43.67 | 43.84 | 43.53 | 43.54 | 68336.0 |
| 2024-10-30 | AGIH | ETF | 24.665 | 24.665 | 24.665 | 24.665 | 41.0 |
| 2024-10-30 | AGIX | ETF | 26.69 | 26.77 | 26.4711 | 26.4711 | 4807.0 |
| 2024-10-30 | AGMI | ETF | 31.92 | 31.92 | 31.3 | 31.54 | 1413.0 |
| 2024-10-30 | AGNG | ETF | 32.29 | 32.54 | 32.19 | 32.54 | 10858.0 |
| 2024-10-30 | AGOX | ETF | 29.07 | 29.07 | 28.45 | 28.4996 | 19019.0 |
| 2024-10-30 | AGQ | ETF | 46.66 | 47.46 | 45.86 | 46.9 | 2448864.0 |
> showing 50 of 3,754 rows — these rows as CSV