PREVIEW / etf_daily / 2024-11-07
file: by_date/etf_daily/2024/2024-11-07.parquet size: 144 KB rows: 3,777
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-11-07 | SPY | ETF | 593.08 | 596.65 | 592.9999 | 595.61 | 46280045.0 |
| 2024-11-07 | QQQ | ETF | 508.4 | 514.33 | 508.34 | 513.54 | 32853120.0 |
| 2024-11-07 | IWM | ETF | 236.89 | 238.49 | 235.4 | 236.38 | 34824137.0 |
| 2024-11-07 | DIA | ETF | 437.53 | 438.2471 | 436.43 | 437.39 | 3914909.0 |
| 2024-11-07 | GLD | ETF | 248.29 | 250.24 | 248.12 | 249.65 | 8532972.0 |
| 2024-11-07 | TLT | ETF | 90.75 | 91.62 | 90.65 | 91.33 | 56149680.0 |
| 2024-11-07 | AAA | ETF | 25.07 | 25.07 | 25.02 | 25.03 | 16745.0 |
| 2024-11-07 | AAAU | ETF | 26.585 | 26.79 | 26.57 | 26.735 | 1733772.0 |
| 2024-11-07 | AADR | ETF | 65.97 | 66.53 | 65.91 | 66.24 | 6712.0 |
| 2024-11-07 | AAPB | ETF | 27.51 | 28.3 | 27.51 | 28.24 | 171716.0 |
| 2024-11-07 | AAPD | ETF | 17.1 | 17.1 | 16.86 | 16.87 | 395801.0 |
| 2024-11-07 | AAPR | ETF | 26.35 | 26.3667 | 26.3406 | 26.35 | 2351.0 |
| 2024-11-07 | AAPU | ETF | 34.9 | 35.85 | 34.875 | 35.78 | 547531.0 |
| 2024-11-07 | AAPX | ETF | 31.67 | 32.58 | 31.67 | 32.58 | 17479.0 |
| 2024-11-07 | AAPY | ETF | 27.194 | 27.194 | 27.194 | 27.194 | 218.0 |
| 2024-11-07 | AAXJ | ETF | 78.07 | 78.76 | 78.0 | 78.61 | 509166.0 |
| 2024-11-07 | ABCS | ETF | 29.75 | 29.83 | 29.69 | 29.72 | 1224.0 |
| 2024-11-07 | ABEQ | ETF | 32.6309 | 32.77 | 32.62 | 32.7444 | 2781.0 |
| 2024-11-07 | ABNY | ETF | 85.6495 | 87.85 | 85.55 | 87.395 | 2470.0 |
| 2024-11-07 | ACES | ETF | 27.67 | 27.905 | 27.36 | 27.66 | 132871.0 |
| 2024-11-07 | ACIO | ETF | 40.72 | 40.98 | 40.68 | 40.93 | 216656.0 |
| 2024-11-07 | ACSI | ETF | 60.4451 | 60.4451 | 60.4451 | 60.4451 | 29.0 |
| 2024-11-07 | ACT | ETF | 34.2 | 34.33 | 33.12 | 33.47 | 366115.0 |
| 2024-11-07 | ACTV | ETF | 33.75 | 33.82 | 33.49 | 33.5264 | 18810.0 |
| 2024-11-07 | ACVF | ETF | 45.31 | 45.82 | 45.26 | 45.82 | 11764.0 |
| 2024-11-07 | ACWI | ETF | 121.15 | 121.855 | 121.07 | 121.62 | 1067877.0 |
| 2024-11-07 | ACWV | ETF | 114.44 | 114.81 | 114.26 | 114.6 | 107518.0 |
| 2024-11-07 | ACWX | ETF | 55.47 | 55.78 | 55.38 | 55.69 | 814187.0 |
| 2024-11-07 | ADFI | ETF | 8.53 | 8.58 | 8.53 | 8.57 | 11622.0 |
| 2024-11-07 | ADIV | ETF | 16.21 | 16.2546 | 16.21 | 16.2546 | 222.0 |
| 2024-11-07 | ADME | ETF | 47.47 | 47.719 | 47.3919 | 47.5889 | 13472.0 |
| 2024-11-07 | ADPV | ETF | 35.24 | 35.43 | 35.24 | 35.3776 | 6975.0 |
| 2024-11-07 | ADVE | ETF | 35.2 | 35.33 | 35.2 | 35.2933 | 2944.0 |
| 2024-11-07 | AESR | ETF | 17.67 | 17.81 | 17.67 | 17.75 | 28943.0 |
| 2024-11-07 | AETH | ETF | 36.15 | 37.1614 | 35.84 | 37.1614 | 16840.0 |
| 2024-11-07 | AFIF | ETF | 9.17 | 9.2385 | 9.106 | 9.175 | 22916.0 |
| 2024-11-07 | AFK | ETF | 16.79 | 16.81 | 16.46 | 16.81 | 13971.0 |
| 2024-11-07 | AFLG | ETF | 35.2755 | 35.42 | 35.2755 | 35.41 | 8219.0 |
| 2024-11-07 | AFMC | ETF | 34.01 | 34.01 | 33.8194 | 33.899 | 2879.0 |
| 2024-11-07 | AFSM | ETF | 32.8 | 32.9 | 32.6854 | 32.75 | 33638.0 |
| 2024-11-07 | AGG | ETF | 97.96 | 98.54 | 97.9 | 98.33 | 17393741.0 |
| 2024-11-07 | AGGH | ETF | 20.6455 | 20.85 | 20.6455 | 20.85 | 29291.0 |
| 2024-11-07 | AGGS | ETF | 41.19 | 41.28 | 41.19 | 41.2565 | 507.0 |
| 2024-11-07 | AGGY | ETF | 43.43 | 43.6778 | 43.43 | 43.64 | 65578.0 |
| 2024-11-07 | AGIH | ETF | 24.7084 | 24.7084 | 24.7084 | 24.7084 | 16.0 |
| 2024-11-07 | AGIX | ETF | 27.32 | 27.93 | 27.32 | 27.87 | 2026.0 |
| 2024-11-07 | AGMI | ETF | 30.21 | 30.5895 | 30.21 | 30.5895 | 167.0 |
| 2024-11-07 | AGNG | ETF | 32.03 | 32.22 | 31.94 | 32.2 | 11642.0 |
| 2024-11-07 | AGOX | ETF | 29.16 | 29.6 | 29.16 | 29.6 | 24905.0 |
| 2024-11-07 | AGQ | ETF | 41.16 | 42.25 | 40.8102 | 41.76 | 1478356.0 |
> showing 50 of 3,777 rows — these rows as CSV