PREVIEW / etf_daily / 2024-08-23
file: by_date/etf_daily/2024/2024-08-23.parquet size: 133 KB rows: 3,463
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-08-23 | SPY | ETF | 559.53 | 563.09 | 557.29 | 562.13 | 49729736.0 |
| 2024-08-23 | QQQ | ETF | 479.24 | 482.74 | 475.28 | 480.0 | 36061508.0 |
| 2024-08-23 | IWM | ETF | 215.18 | 221.08 | 214.79 | 220.38 | 39870750.0 |
| 2024-08-23 | DIA | ETF | 409.29 | 412.32 | 408.56 | 411.83 | 3814880.0 |
| 2024-08-23 | GLD | ETF | 231.04 | 232.73 | 230.5199 | 232.02 | 5401311.0 |
| 2024-08-23 | TLT | ETF | 98.19 | 98.67 | 97.96 | 98.39 | 31946533.0 |
| 2024-08-23 | AAA | ETF | 25.06 | 25.15 | 25.0302 | 25.11 | 4195.0 |
| 2024-08-23 | AAAU | ETF | 24.74 | 24.905 | 24.675 | 24.835 | 2089440.0 |
| 2024-08-23 | AADR | ETF | 62.545 | 62.555 | 62.545 | 62.555 | 274.0 |
| 2024-08-23 | AAPB | ETF | 28.59 | 29.11 | 28.22 | 28.79 | 44635.0 |
| 2024-08-23 | AAPD | ETF | 17.03 | 17.15 | 16.8687 | 16.98 | 122637.0 |
| 2024-08-23 | AAPR | ETF | 25.78 | 25.9 | 25.78 | 25.9 | 3264.0 |
| 2024-08-23 | AAPU | ETF | 36.51 | 37.2894 | 36.06 | 36.85 | 429960.0 |
| 2024-08-23 | AAPX | ETF | 33.12 | 33.54 | 32.6925 | 33.4012 | 12720.0 |
| 2024-08-23 | AAPY | ETF | 27.29 | 27.3286 | 27.29 | 27.3268 | 961.0 |
| 2024-08-23 | AAXJ | ETF | 73.17 | 73.805 | 72.985 | 73.65 | 222953.0 |
| 2024-08-23 | ABCS | ETF | 27.78 | 27.9234 | 27.78 | 27.9234 | 1328.0 |
| 2024-08-23 | ABEQ | ETF | 32.24 | 32.2825 | 32.21 | 32.2825 | 4181.0 |
| 2024-08-23 | ABNY | ETF | 79.9 | 81.15 | 79.65 | 79.8685 | 917.0 |
| 2024-08-23 | ACES | ETF | 28.4 | 29.61 | 28.4 | 29.57 | 26967.0 |
| 2024-08-23 | ACIO | ETF | 39.09 | 39.23 | 38.9401 | 39.2 | 129760.0 |
| 2024-08-23 | ACSI | ETF | 56.69 | 56.7642 | 56.69 | 56.7642 | 145.0 |
| 2024-08-23 | ACT | ETF | 35.0 | 35.505 | 34.85 | 35.2 | 252391.0 |
| 2024-08-23 | ACTV | ETF | 32.42 | 33.0 | 32.42 | 32.999 | 20543.0 |
| 2024-08-23 | ACVF | ETF | 42.63 | 42.7996 | 42.575 | 42.7996 | 8685.0 |
| 2024-08-23 | ACWI | ETF | 116.1 | 116.98 | 116.01 | 116.9 | 2063284.0 |
| 2024-08-23 | ACWV | ETF | 112.33 | 112.69 | 112.09 | 112.57 | 149747.0 |
| 2024-08-23 | ACWX | ETF | 55.27 | 55.9 | 55.27 | 55.86 | 605815.0 |
| 2024-08-23 | ADFI | ETF | 8.74 | 8.78 | 8.7 | 8.7 | 3634.0 |
| 2024-08-23 | ADIV | ETF | 15.38 | 15.41 | 15.38 | 15.385 | 1591.0 |
| 2024-08-23 | ADME | ETF | 45.36 | 45.42 | 45.175 | 45.4143 | 17551.0 |
| 2024-08-23 | ADPV | ETF | 31.39 | 31.7976 | 31.39 | 31.7976 | 1096.0 |
| 2024-08-23 | AEMB | ETF | 39.8501 | 39.8501 | 39.8501 | 39.8501 | 37.0 |
| 2024-08-23 | AESR | ETF | 16.63 | 16.76 | 16.59 | 16.73 | 12970.0 |
| 2024-08-23 | AETH | ETF | 34.8939 | 35.67 | 34.359 | 35.6679 | 3819.0 |
| 2024-08-23 | AFIF | ETF | 9.22 | 9.22 | 9.15 | 9.17 | 21317.0 |
| 2024-08-23 | AFK | ETF | 16.32 | 16.78 | 16.2 | 16.78 | 20898.0 |
| 2024-08-23 | AFLG | ETF | 33.0 | 33.1157 | 32.945 | 33.1157 | 1391.0 |
| 2024-08-23 | AFMC | ETF | 31.34 | 31.5265 | 31.29 | 31.5265 | 5136.0 |
| 2024-08-23 | AFSM | ETF | 30.29 | 30.52 | 30.25 | 30.52 | 8865.0 |
| 2024-08-23 | AFTY | ETF | 14.3109 | 14.3109 | 14.3109 | 14.3109 | 4.0 |
| 2024-08-23 | AGG | ETF | 100.52 | 100.81 | 100.43 | 100.77 | 6176491.0 |
| 2024-08-23 | AGGH | ETF | 21.56 | 22.24 | 21.56 | 22.19 | 77226.0 |
| 2024-08-23 | AGGS | ETF | 42.33 | 42.3399 | 42.32 | 42.32 | 844.0 |
| 2024-08-23 | AGGY | ETF | 44.5 | 44.62 | 44.47 | 44.62 | 80216.0 |
| 2024-08-23 | AGIX | ETF | 25.0 | 25.0 | 24.72 | 24.97 | 574.0 |
| 2024-08-23 | AGMI | ETF | 27.07 | 27.16 | 27.07 | 27.08 | 294.0 |
| 2024-08-23 | AGNG | ETF | 32.77 | 32.87 | 32.6727 | 32.87 | 1930.0 |
| 2024-08-23 | AGOX | ETF | 29.12 | 29.4 | 29.0 | 29.0 | 35584.0 |
| 2024-08-23 | AGQ | ETF | 36.4 | 37.9899 | 36.23 | 37.87 | 2464750.0 |
> showing 50 of 3,463 rows — these rows as CSV