PREVIEW / etf_daily / 2024-07-10
file: by_date/etf_daily/2024/2024-07-10.parquet size: 132 KB rows: 3,415
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-07-10 | SPY | ETF | 557.07 | 561.67 | 556.77 | 561.32 | 38305152.0 |
| 2024-07-10 | QQQ | ETF | 499.71 | 503.52 | 498.39 | 502.96 | 28046901.0 |
| 2024-07-10 | IWM | ETF | 202.29 | 203.59 | 201.49 | 203.37 | 19341307.0 |
| 2024-07-10 | DIA | ETF | 392.94 | 397.46 | 392.6303 | 397.26 | 4231845.0 |
| 2024-07-10 | GLD | ETF | 220.14 | 220.71 | 219.16 | 219.36 | 5507489.0 |
| 2024-07-10 | TLT | ETF | 92.45 | 92.68 | 92.2603 | 92.64 | 23515422.0 |
| 2024-07-10 | AAA | ETF | 25.03 | 25.0999 | 25.03 | 25.07 | 6585.0 |
| 2024-07-10 | AAAU | ETF | 23.55 | 23.615 | 23.445 | 23.46 | 1206960.0 |
| 2024-07-10 | AADR | ETF | 63.0 | 63.2194 | 63.0 | 63.19 | 728.0 |
| 2024-07-10 | AAPB | ETF | 29.96 | 30.89 | 29.95 | 30.88 | 185558.0 |
| 2024-07-10 | AAPD | ETF | 16.76 | 16.76 | 16.49 | 16.51 | 267144.0 |
| 2024-07-10 | AAPR | ETF | 25.465 | 25.515 | 25.46 | 25.515 | 8977.0 |
| 2024-07-10 | AAPU | ETF | 38.41 | 39.67 | 38.39 | 39.61 | 1238809.0 |
| 2024-07-10 | AAPX | ETF | 34.88 | 35.97 | 34.88 | 35.97 | 32258.0 |
| 2024-07-10 | AAPY | ETF | 27.6 | 27.75 | 27.6 | 27.7479 | 809.0 |
| 2024-07-10 | AAXJ | ETF | 74.32 | 74.52 | 74.18 | 74.49 | 367962.0 |
| 2024-07-10 | ABCS | ETF | 25.75 | 25.96 | 25.75 | 25.96 | 1300.0 |
| 2024-07-10 | ABEQ | ETF | 30.328 | 30.4244 | 30.3161 | 30.4244 | 8771.0 |
| 2024-07-10 | ABNY | ETF | 107.45 | 107.45 | 102.928 | 103.691 | 534.0 |
| 2024-07-10 | ACES | ETF | 29.42 | 29.97 | 29.3067 | 29.96 | 22031.0 |
| 2024-07-10 | ACIO | ETF | 38.44 | 38.675 | 38.3859 | 38.675 | 64196.0 |
| 2024-07-10 | ACSI | ETF | 56.5314 | 56.5314 | 56.5314 | 56.5314 | 47.0 |
| 2024-07-10 | ACT | ETF | 30.28 | 30.68 | 30.28 | 30.59 | 149090.0 |
| 2024-07-10 | ACTV | ETF | 31.66 | 31.66 | 31.46 | 31.6564 | 8668.0 |
| 2024-07-10 | ACVF | ETF | 41.8655 | 42.1364 | 41.8515 | 42.1364 | 6169.0 |
| 2024-07-10 | ACWI | ETF | 115.0 | 115.885 | 115.0 | 115.8 | 1685811.0 |
| 2024-07-10 | ACWV | ETF | 105.26 | 106.035 | 105.26 | 105.97 | 303406.0 |
| 2024-07-10 | ACWX | ETF | 54.41 | 54.72 | 54.38 | 54.7 | 512484.0 |
| 2024-07-10 | ADFI | ETF | 8.5 | 8.53 | 8.4901 | 8.5147 | 19567.0 |
| 2024-07-10 | ADIV | ETF | 14.88 | 14.89 | 14.8785 | 14.8822 | 2245.0 |
| 2024-07-10 | ADME | ETF | 44.75 | 45.0919 | 44.7101 | 45.0919 | 14472.0 |
| 2024-07-10 | ADPV | ETF | 30.52 | 30.7959 | 30.48 | 30.7959 | 2444.0 |
| 2024-07-10 | AEMB | ETF | 38.587 | 38.6008 | 38.587 | 38.6008 | 172.0 |
| 2024-07-10 | AESR | ETF | 16.78 | 16.911 | 16.77 | 16.911 | 31067.0 |
| 2024-07-10 | AETH | ETF | 40.72 | 41.04 | 40.54 | 40.62 | 4943.0 |
| 2024-07-10 | AFIF | ETF | 9.148 | 9.16 | 9.148 | 9.16 | 38453.0 |
| 2024-07-10 | AFK | ETF | 16.24 | 16.49 | 16.24 | 16.3794 | 22933.0 |
| 2024-07-10 | AFLG | ETF | 32.105 | 32.3284 | 32.038 | 32.3284 | 2648.0 |
| 2024-07-10 | AFMC | ETF | 28.9628 | 29.2 | 28.88 | 29.2 | 41437.0 |
| 2024-07-10 | AFSM | ETF | 28.0719 | 28.1794 | 27.97 | 28.1794 | 935.0 |
| 2024-07-10 | AFTY | ETF | 14.01 | 14.01 | 13.99 | 13.99 | 620.0 |
| 2024-07-10 | AGG | ETF | 97.61 | 97.67 | 97.485 | 97.62 | 4536517.0 |
| 2024-07-10 | AGGH | ETF | 21.0 | 21.0 | 20.89 | 20.95 | 99493.0 |
| 2024-07-10 | AGGS | ETF | 41.06 | 41.0776 | 41.06 | 41.0776 | 2062.0 |
| 2024-07-10 | AGGY | ETF | 43.29 | 43.34 | 43.254 | 43.32 | 158705.0 |
| 2024-07-10 | AGMI | ETF | 27.48 | 28.3172 | 27.48 | 28.3172 | 103.0 |
| 2024-07-10 | AGNG | ETF | 30.35 | 30.6566 | 30.35 | 30.6566 | 3106.0 |
| 2024-07-10 | AGOX | ETF | 28.89 | 28.9598 | 28.645 | 28.9598 | 40728.0 |
| 2024-07-10 | AGQ | ETF | 41.78 | 42.299 | 40.83 | 41.37 | 1407045.0 |
| 2024-07-10 | AGQI | ETF | 14.56 | 14.65 | 14.55 | 14.6488 | 14624.0 |
> showing 50 of 3,415 rows — these rows as CSV