PREVIEW / etf_daily / 2024-09-13
file: by_date/etf_daily/2024/2024-09-13.parquet size: 133 KB rows: 3,493
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-13 | SPY | ETF | 559.71 | 563.03 | 559.45 | 562.01 | 39261640.0 |
| 2024-09-13 | QQQ | ETF | 472.48 | 476.53 | 472.25 | 475.34 | 29111849.0 |
| 2024-09-13 | IWM | ETF | 214.03 | 217.25 | 213.94 | 216.83 | 37729546.0 |
| 2024-09-13 | DIA | ETF | 412.59 | 416.31 | 412.35 | 414.94 | 5259116.0 |
| 2024-09-13 | GLD | ETF | 238.13 | 238.98 | 237.7575 | 238.68 | 7292419.0 |
| 2024-09-13 | TLT | ETF | 100.46 | 100.61 | 100.02 | 100.41 | 25695087.0 |
| 2024-09-13 | AAA | ETF | 25.0 | 25.065 | 25.0 | 25.0563 | 2733.0 |
| 2024-09-13 | AAAU | ETF | 25.5 | 25.5799 | 25.45 | 25.545 | 1358833.0 |
| 2024-09-13 | AADR | ETF | 63.0 | 63.1032 | 63.0 | 63.1032 | 315.0 |
| 2024-09-13 | AAPB | ETF | 27.83 | 27.9048 | 27.49 | 27.53 | 79433.0 |
| 2024-09-13 | AAPD | ETF | 17.26 | 17.41 | 17.2499 | 17.38 | 292155.0 |
| 2024-09-13 | AAPR | ETF | 25.99 | 25.99 | 25.97 | 25.9796 | 4307.0 |
| 2024-09-13 | AAPU | ETF | 35.59 | 35.69 | 35.041 | 35.2 | 543341.0 |
| 2024-09-13 | AAPX | ETF | 32.15 | 32.2299 | 31.83 | 31.86 | 12018.0 |
| 2024-09-13 | AAPY | ETF | 26.98 | 26.98 | 26.9176 | 26.9176 | 1926.0 |
| 2024-09-13 | AAXJ | ETF | 72.12 | 72.26 | 72.03 | 72.18 | 445649.0 |
| 2024-09-13 | ABCS | ETF | 27.54 | 27.6469 | 27.54 | 27.6469 | 2301.0 |
| 2024-09-13 | ABEQ | ETF | 32.52 | 32.53 | 32.41 | 32.4569 | 10178.0 |
| 2024-09-13 | ABNY | ETF | 79.7 | 80.2 | 79.55 | 79.955 | 1100.0 |
| 2024-09-13 | ACES | ETF | 28.48 | 28.75 | 28.39 | 28.51 | 104072.0 |
| 2024-09-13 | ACIO | ETF | 39.14 | 39.25 | 39.08 | 39.2 | 128493.0 |
| 2024-09-13 | ACSI | ETF | 57.2517 | 57.2517 | 57.2517 | 57.2517 | 94.0 |
| 2024-09-13 | ACT | ETF | 35.74 | 36.23 | 35.74 | 36.1 | 211125.0 |
| 2024-09-13 | ACTV | ETF | 32.63 | 32.64 | 32.491 | 32.62 | 9226.0 |
| 2024-09-13 | ACVF | ETF | 42.74 | 42.82 | 42.74 | 42.82 | 1776.0 |
| 2024-09-13 | ACWI | ETF | 115.91 | 116.39 | 115.77 | 116.21 | 1014918.0 |
| 2024-09-13 | ACWV | ETF | 113.23 | 113.6399 | 112.93 | 113.6 | 159444.0 |
| 2024-09-13 | ACWX | ETF | 55.0 | 55.16 | 54.904 | 55.0 | 385579.0 |
| 2024-09-13 | ADFI | ETF | 8.83 | 8.85 | 8.82 | 8.835 | 16421.0 |
| 2024-09-13 | ADIV | ETF | 15.15 | 15.1899 | 15.15 | 15.1899 | 285.0 |
| 2024-09-13 | ADME | ETF | 45.4 | 45.54 | 45.35 | 45.4343 | 12255.0 |
| 2024-09-13 | ADPV | ETF | 31.41 | 31.61 | 31.4 | 31.5349 | 14926.0 |
| 2024-09-13 | AEMB | ETF | 39.59 | 39.694 | 39.48 | 39.692 | 18192.0 |
| 2024-09-13 | AESR | ETF | 16.53 | 16.679 | 16.42 | 16.57 | 33634.0 |
| 2024-09-13 | AETH | ETF | 30.24 | 31.36 | 30.24 | 31.18 | 5251.0 |
| 2024-09-13 | AFIF | ETF | 9.2275 | 9.25 | 9.2275 | 9.235 | 9949.0 |
| 2024-09-13 | AFK | ETF | 16.2 | 16.29 | 15.93 | 15.93 | 6177.0 |
| 2024-09-13 | AFLG | ETF | 33.03 | 33.16 | 32.97 | 33.12 | 5645.0 |
| 2024-09-13 | AFMC | ETF | 30.84 | 31.02 | 30.84 | 30.9827 | 1079.0 |
| 2024-09-13 | AFSM | ETF | 29.8199 | 29.824 | 29.8199 | 29.824 | 5451.0 |
| 2024-09-13 | AFTY | ETF | 13.48 | 13.48 | 13.47 | 13.47 | 402.0 |
| 2024-09-13 | AGG | ETF | 101.76 | 101.82 | 101.62 | 101.74 | 5293442.0 |
| 2024-09-13 | AGGH | ETF | 21.88 | 21.92 | 21.83 | 21.9 | 68116.0 |
| 2024-09-13 | AGGY | ETF | 45.01 | 45.065 | 44.99 | 45.025 | 557131.0 |
| 2024-09-13 | AGIX | ETF | 24.58 | 24.65 | 24.58 | 24.6284 | 337.0 |
| 2024-09-13 | AGMI | ETF | 27.21 | 27.869 | 27.21 | 27.869 | 1280.0 |
| 2024-09-13 | AGNG | ETF | 32.9 | 33.0 | 32.9 | 32.94 | 1077.0 |
| 2024-09-13 | AGOX | ETF | 28.45 | 28.9 | 28.4011 | 28.4011 | 16398.0 |
| 2024-09-13 | AGQ | ETF | 39.18 | 40.1109 | 38.91 | 39.65 | 3030260.0 |
| 2024-09-13 | AGQI | ETF | 14.5 | 14.515 | 14.48 | 14.4915 | 9497.0 |
> showing 50 of 3,493 rows — these rows as CSV