PREVIEW / etf_daily / 2024-06-25
file: by_date/etf_daily/2024/2024-06-25.parquet size: 121 KB rows: 3,403
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-06-25 | SPY | ETF | 543.99 | 545.2 | 542.44 | 544.83 | 38273300.0 |
| 2024-06-25 | QQQ | ETF | 476.07 | 479.68 | 475.12 | 479.38 | 29250209.0 |
| 2024-06-25 | IWM | ETF | 201.13 | 201.16 | 199.82 | 200.56 | 16150600.0 |
| 2024-06-25 | DIA | ETF | 393.56 | 394.11 | 389.82 | 391.02 | 2923900.0 |
| 2024-06-25 | GLD | ETF | 214.96 | 215.31 | 214.12 | 214.56 | 3847700.0 |
| 2024-06-25 | TLT | ETF | 94.07 | 94.55 | 94.04 | 94.5 | 23160000.0 |
| 2024-06-25 | AAA | ETF | 25.155 | 25.17 | 25.12 | 25.15 | 3000.0 |
| 2024-06-25 | AAAU | ETF | 23.0 | 23.03 | 22.91 | 22.95 | 1266900.0 |
| 2024-06-25 | AADR | ETF | 62.25 | 62.25 | 62.1 | 62.18 | 700.0 |
| 2024-06-25 | AAPB | ETF | 25.05 | 25.58 | 24.93 | 25.03 | 155926.0 |
| 2024-06-25 | AAPD | ETF | 18.36 | 18.39 | 18.16 | 18.36 | 197851.0 |
| 2024-06-25 | AAPR | ETF | 25.27 | 25.28 | 25.2061 | 25.23 | 11380.0 |
| 2024-06-25 | AAPU | ETF | 32.18 | 32.83 | 31.99 | 32.14 | 684388.0 |
| 2024-06-25 | AAPX | ETF | 29.16 | 29.75 | 29.1 | 29.23 | 25382.0 |
| 2024-06-25 | AAPY | ETF | 26.5842 | 26.66 | 26.58 | 26.58 | 915.0 |
| 2024-06-25 | AAXJ | ETF | 71.95 | 71.98 | 71.75 | 71.96 | 304800.0 |
| 2024-06-25 | ABCS | ETF | 26.185 | 26.25 | 26.0428 | 26.0428 | 3600.0 |
| 2024-06-25 | ABEQ | ETF | 30.49 | 30.49 | 30.311 | 30.349 | 2200.0 |
| 2024-06-25 | ABNY | ETF | 101.3 | 101.5 | 101.175 | 101.175 | 925.0 |
| 2024-06-25 | ACES | ETF | 28.57 | 28.73 | 28.272 | 28.341 | 33000.0 |
| 2024-06-25 | ACIO | ETF | 37.64 | 37.719 | 37.57 | 37.689 | 78800.0 |
| 2024-06-25 | ACSI | ETF | 55.026 | 55.026 | 55.026 | 55.026 | 100.0 |
| 2024-06-25 | ACT | ETF | 30.71 | 30.74 | 30.49 | 30.6 | 94133.0 |
| 2024-06-25 | ACTV | ETF | 32.28 | 32.28 | 31.79 | 31.79 | 7700.0 |
| 2024-06-25 | ACVF | ETF | 41.48 | 41.48 | 41.27 | 41.42 | 17100.0 |
| 2024-06-25 | ACWF | ETF | 42.3 | 42.3858 | 42.27 | 42.3858 | 2840.0 |
| 2024-06-25 | ACWI | ETF | 112.36 | 112.66 | 112.16 | 112.59 | 3248600.0 |
| 2024-06-25 | ACWV | ETF | 105.23 | 105.36 | 104.86 | 104.95 | 123800.0 |
| 2024-06-25 | ACWX | ETF | 53.24 | 53.34 | 53.12 | 53.29 | 559500.0 |
| 2024-06-25 | ADFI | ETF | 8.5 | 8.569 | 8.5 | 8.52 | 20300.0 |
| 2024-06-25 | ADIV | ETF | 14.8 | 14.8 | 14.8 | 14.8 | 100.0 |
| 2024-06-25 | ADME | ETF | 43.79 | 43.79 | 43.63 | 43.749 | 22600.0 |
| 2024-06-25 | ADPV | ETF | 30.1792 | 30.2039 | 30.1 | 30.2039 | 4919.0 |
| 2024-06-25 | AEMB | ETF | 38.69 | 39.44 | 38.565 | 38.585 | 3500.0 |
| 2024-06-25 | AESR | ETF | 16.33 | 16.389 | 16.32 | 16.37 | 20200.0 |
| 2024-06-25 | AETH | ETF | 44.07 | 44.5879 | 44.07 | 44.5879 | 3149.0 |
| 2024-06-25 | AFIF | ETF | 9.12 | 9.13 | 9.1 | 9.13 | 10600.0 |
| 2024-06-25 | AFK | ETF | 15.71 | 15.72 | 15.56 | 15.69 | 6400.0 |
| 2024-06-25 | AFLG | ETF | 31.69 | 31.83 | 31.69 | 31.767 | 305500.0 |
| 2024-06-25 | AFMC | ETF | 29.091 | 29.16 | 29.091 | 29.147 | 400.0 |
| 2024-06-25 | AFSM | ETF | 28.005 | 28.029 | 27.962 | 27.962 | 500.0 |
| 2024-06-25 | AFTY | ETF | 14.0 | 14.0 | 13.95 | 13.96 | 2700.0 |
| 2024-06-25 | AGG | ETF | 97.78 | 97.88 | 97.71 | 97.83 | 5701700.0 |
| 2024-06-25 | AGGH | ETF | 20.97 | 20.97 | 20.85 | 20.85 | 31432.0 |
| 2024-06-25 | AGGS | ETF | 41.2 | 41.2361 | 41.2 | 41.2361 | 120.0 |
| 2024-06-25 | AGGY | ETF | 43.24 | 43.27 | 43.2 | 43.27 | 130100.0 |
| 2024-06-25 | AGMI | ETF | 25.8 | 25.8 | 25.5553 | 25.5553 | 103.0 |
| 2024-06-25 | AGNG | ETF | 30.37 | 30.37 | 30.23 | 30.28 | 1200.0 |
| 2024-06-25 | AGOX | ETF | 28.46 | 28.46 | 28.06 | 28.317 | 28200.0 |
| 2024-06-25 | AGQ | ETF | 37.75 | 37.77 | 36.43 | 36.6 | 1317700.0 |
> showing 50 of 3,403 rows — these rows as CSV