PREVIEW / etf_daily / 2024-09-03
file: by_date/etf_daily/2024/2024-09-03.parquet size: 133 KB rows: 3,497
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-03 | SPY | ETF | 560.47 | 560.81 | 549.51 | 552.08 | 60466736.0 |
| 2024-09-03 | QQQ | ETF | 473.2 | 473.33 | 459.4101 | 461.81 | 44985219.0 |
| 2024-09-03 | IWM | ETF | 218.13 | 219.37 | 212.91 | 213.35 | 31155580.0 |
| 2024-09-03 | DIA | ETF | 414.19 | 415.18 | 408.62 | 410.25 | 3749591.0 |
| 2024-09-03 | GLD | ETF | 230.38 | 230.54 | 228.52 | 230.29 | 6319287.0 |
| 2024-09-03 | TLT | ETF | 97.56 | 98.06 | 97.42 | 97.75 | 48876776.0 |
| 2024-09-03 | AAA | ETF | 25.0 | 25.11 | 25.0 | 25.07 | 4107.0 |
| 2024-09-03 | AAAU | ETF | 24.66 | 24.675 | 24.465 | 24.655 | 2458244.0 |
| 2024-09-03 | AADR | ETF | 62.0179 | 62.0179 | 61.97 | 61.97 | 159.0 |
| 2024-09-03 | AAPB | ETF | 29.1 | 29.27 | 27.38 | 27.65 | 143689.0 |
| 2024-09-03 | AAPD | ETF | 16.87 | 17.405 | 16.85 | 17.32 | 653825.0 |
| 2024-09-03 | AAPR | ETF | 25.86 | 25.86 | 25.7564 | 25.7564 | 5275.0 |
| 2024-09-03 | AAPU | ETF | 37.31 | 37.45 | 34.9 | 35.38 | 790528.0 |
| 2024-09-03 | AAPX | ETF | 33.27 | 33.48 | 31.72 | 32.09 | 33517.0 |
| 2024-09-03 | AAPY | ETF | 27.335 | 27.335 | 26.8284 | 26.8284 | 1196.0 |
| 2024-09-03 | AAXJ | ETF | 72.36 | 72.36 | 71.38 | 71.51 | 198239.0 |
| 2024-09-03 | ABCS | ETF | 28.0 | 28.0 | 26.315 | 26.315 | 1441.0 |
| 2024-09-03 | ABEQ | ETF | 32.4301 | 32.65 | 32.4301 | 32.4836 | 3464.0 |
| 2024-09-03 | ABNY | ETF | 81.75 | 81.75 | 79.5 | 79.6225 | 2701.0 |
| 2024-09-03 | ACES | ETF | 28.7 | 28.7 | 27.46 | 27.53 | 38080.0 |
| 2024-09-03 | ACIO | ETF | 39.15 | 39.15 | 38.615 | 38.74 | 98199.0 |
| 2024-09-03 | ACSI | ETF | 56.7199 | 56.7199 | 56.5635 | 56.5635 | 175.0 |
| 2024-09-03 | ACT | ETF | 35.41 | 35.83 | 35.18 | 35.27 | 200381.0 |
| 2024-09-03 | ACTV | ETF | 32.85 | 32.85 | 32.47 | 32.5509 | 6316.0 |
| 2024-09-03 | ACVF | ETF | 42.81 | 42.81 | 41.91 | 42.0486 | 6661.0 |
| 2024-09-03 | ACWI | ETF | 116.38 | 116.38 | 114.27 | 114.74 | 1723700.0 |
| 2024-09-03 | ACWV | ETF | 113.29 | 113.64 | 112.94 | 113.2 | 327034.0 |
| 2024-09-03 | ACWX | ETF | 55.44 | 55.44 | 54.685 | 54.81 | 710975.0 |
| 2024-09-03 | ADFI | ETF | 8.69 | 8.76 | 8.69 | 8.72 | 13867.0 |
| 2024-09-03 | ADIV | ETF | 15.16 | 15.21 | 15.06 | 15.0917 | 5699.0 |
| 2024-09-03 | ADME | ETF | 45.55 | 45.55 | 44.67 | 44.77 | 12189.0 |
| 2024-09-03 | ADPV | ETF | 32.09 | 32.09 | 31.4593 | 31.4593 | 5128.0 |
| 2024-09-03 | AEMB | ETF | 43.32 | 43.32 | 39.16 | 39.2485 | 1696.0 |
| 2024-09-03 | AESR | ETF | 16.59 | 16.59 | 16.22 | 16.27 | 19596.0 |
| 2024-09-03 | AETH | ETF | 32.02 | 32.02 | 31.53 | 31.5796 | 2912.0 |
| 2024-09-03 | AFIF | ETF | 9.1795 | 9.21 | 9.17 | 9.185 | 10598.0 |
| 2024-09-03 | AFK | ETF | 16.19 | 16.25 | 15.62 | 15.62 | 21768.0 |
| 2024-09-03 | AFLG | ETF | 32.8639 | 32.9 | 32.5648 | 32.5648 | 9407.0 |
| 2024-09-03 | AFMC | ETF | 30.81 | 30.81 | 30.6653 | 30.6653 | 673.0 |
| 2024-09-03 | AFSM | ETF | 30.45 | 30.45 | 29.48 | 29.5202 | 5847.0 |
| 2024-09-03 | AFTY | ETF | 13.9368 | 13.9368 | 13.9368 | 13.9368 | 15.0 |
| 2024-09-03 | AGG | ETF | 100.32 | 100.53 | 100.23 | 100.36 | 6825936.0 |
| 2024-09-03 | AGGH | ETF | 21.38 | 21.8178 | 21.38 | 21.61 | 52690.0 |
| 2024-09-03 | AGGY | ETF | 44.37 | 44.43 | 44.3301 | 44.36 | 49005.0 |
| 2024-09-03 | AGIX | ETF | 24.48 | 24.48 | 23.5279 | 23.5279 | 1827.0 |
| 2024-09-03 | AGMI | ETF | 25.73 | 25.73 | 24.8 | 24.8 | 113.0 |
| 2024-09-03 | AGNG | ETF | 33.0 | 33.08 | 32.79 | 32.79 | 3320.0 |
| 2024-09-03 | AGOX | ETF | 28.24 | 28.24 | 27.61 | 27.7549 | 52968.0 |
| 2024-09-03 | AGQ | ETF | 33.89 | 33.91 | 32.391 | 33.17 | 1624470.0 |
| 2024-09-03 | AGQI | ETF | 14.53 | 14.53 | 14.385 | 14.3931 | 7209.0 |
> showing 50 of 3,497 rows — these rows as CSV