PREVIEW / etf_daily / 2024-09-30
file: by_date/etf_daily/2024/2024-09-30.parquet size: 137 KB rows: 3,592
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-30 | SPY | ETF | 570.42 | 574.38 | 568.08 | 573.76 | 62442720.0 |
| 2024-09-30 | QQQ | ETF | 485.78 | 488.41 | 482.92 | 488.07 | 30330605.0 |
| 2024-09-30 | IWM | ETF | 219.42 | 221.59 | 218.58 | 220.89 | 22094478.0 |
| 2024-09-30 | DIA | ETF | 422.42 | 423.3 | 419.08 | 423.12 | 3818895.0 |
| 2024-09-30 | GLD | ETF | 243.97 | 244.08 | 242.5 | 243.06 | 6800824.0 |
| 2024-09-30 | TLT | ETF | 98.64 | 98.71 | 97.8839 | 98.1 | 33819327.0 |
| 2024-09-30 | AAA | ETF | 25.02 | 25.05 | 25.02 | 25.03 | 11591.0 |
| 2024-09-30 | AAAU | ETF | 26.13 | 26.13 | 25.965 | 26.025 | 2425205.0 |
| 2024-09-30 | AADR | ETF | 64.14 | 64.14 | 63.64 | 63.64 | 274.0 |
| 2024-09-30 | AAPB | ETF | 29.25 | 30.0 | 29.23 | 30.0 | 107678.0 |
| 2024-09-30 | AAPD | ETF | 16.65 | 16.68 | 16.44 | 16.44 | 444271.0 |
| 2024-09-30 | AAPR | ETF | 26.23 | 26.24 | 26.2 | 26.22 | 12487.0 |
| 2024-09-30 | AAPU | ETF | 37.12 | 38.05 | 36.98 | 38.05 | 1060656.0 |
| 2024-09-30 | AAPX | ETF | 33.72 | 34.66 | 33.72 | 34.6 | 22311.0 |
| 2024-09-30 | AAPY | ETF | 27.6999 | 27.8321 | 27.6999 | 27.8321 | 369.0 |
| 2024-09-30 | AAXJ | ETF | 79.4 | 79.49 | 78.29 | 78.45 | 1208361.0 |
| 2024-09-30 | ABCS | ETF | 28.3 | 28.41 | 28.19 | 28.3792 | 3208.0 |
| 2024-09-30 | ABEQ | ETF | 32.6201 | 32.755 | 32.62 | 32.755 | 20565.0 |
| 2024-09-30 | ABNY | ETF | 81.05 | 81.7 | 81.005 | 81.3765 | 1439.0 |
| 2024-09-30 | ACES | ETF | 29.58 | 29.83 | 29.28 | 29.41 | 23539.0 |
| 2024-09-30 | ACIO | ETF | 39.52 | 39.75 | 39.45 | 39.74 | 251920.0 |
| 2024-09-30 | ACSI | ETF | 58.58 | 58.7043 | 58.58 | 58.7043 | 1070.0 |
| 2024-09-30 | ACT | ETF | 36.17 | 36.46 | 36.06 | 36.33 | 266722.0 |
| 2024-09-30 | ACTV | ETF | 33.84 | 33.84 | 33.62 | 33.74 | 6975.0 |
| 2024-09-30 | ACVF | ETF | 43.5 | 43.6473 | 43.35 | 43.6473 | 3721.0 |
| 2024-09-30 | ACWI | ETF | 119.43 | 119.635 | 118.63 | 119.55 | 3406077.0 |
| 2024-09-30 | ACWV | ETF | 114.67 | 114.72 | 113.97 | 114.53 | 529887.0 |
| 2024-09-30 | ACWX | ETF | 57.47 | 57.47 | 56.91 | 57.22 | 1868363.0 |
| 2024-09-30 | ADFI | ETF | 8.7798 | 8.81 | 8.755 | 8.765 | 5182.0 |
| 2024-09-30 | ADIV | ETF | 16.44 | 17.0 | 16.135 | 16.271 | 10470.0 |
| 2024-09-30 | ADME | ETF | 45.91 | 46.2 | 45.71 | 46.2 | 11333.0 |
| 2024-09-30 | ADPV | ETF | 31.73 | 32.0 | 31.69 | 31.95 | 8250.0 |
| 2024-09-30 | ADVE | ETF | 36.4289 | 36.4289 | 36.2099 | 36.261 | 1080.0 |
| 2024-09-30 | AESR | ETF | 16.93 | 16.9926 | 16.89 | 16.9926 | 3036.0 |
| 2024-09-30 | AETH | ETF | 33.8 | 33.8999 | 33.2819 | 33.42 | 2935.0 |
| 2024-09-30 | AFIF | ETF | 9.21 | 9.22 | 9.21 | 9.22 | 15232.0 |
| 2024-09-30 | AFK | ETF | 17.1 | 17.19 | 16.72 | 16.79 | 12249.0 |
| 2024-09-30 | AFLG | ETF | 33.939 | 34.13 | 33.939 | 34.12 | 14403.0 |
| 2024-09-30 | AFMC | ETF | 32.15 | 32.2002 | 32.0052 | 32.2002 | 2633.0 |
| 2024-09-30 | AFSM | ETF | 30.66 | 30.848 | 30.5841 | 30.8305 | 9065.0 |
| 2024-09-30 | AFTY | ETF | 16.71 | 16.775 | 16.52 | 16.52 | 101127.0 |
| 2024-09-30 | AGG | ETF | 101.44 | 101.4794 | 101.14 | 101.27 | 8440784.0 |
| 2024-09-30 | AGGH | ETF | 21.73 | 21.73 | 21.5953 | 21.71 | 83691.0 |
| 2024-09-30 | AGGY | ETF | 44.83 | 44.85 | 44.71 | 44.71 | 278658.0 |
| 2024-09-30 | AGIX | ETF | 25.31 | 25.4028 | 25.24 | 25.4028 | 3125.0 |
| 2024-09-30 | AGMI | ETF | 28.965 | 29.07 | 28.965 | 29.07 | 221.0 |
| 2024-09-30 | AGNG | ETF | 32.85 | 32.86 | 32.611 | 32.8328 | 3423.0 |
| 2024-09-30 | AGOX | ETF | 29.0 | 29.0 | 28.5842 | 28.8525 | 18588.0 |
| 2024-09-30 | AGQ | ETF | 40.73 | 40.8087 | 39.762 | 40.44 | 2022046.0 |
| 2024-09-30 | AGQI | ETF | 14.67 | 14.67 | 14.55 | 14.6293 | 15745.0 |
> showing 50 of 3,592 rows — these rows as CSV