PREVIEW / etf_daily / 2024-12-06
file: by_date/etf_daily/2024/2024-12-06.parquet size: 146 KB rows: 3,813
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-12-06 | SPY | ETF | 607.44 | 609.07 | 607.02 | 607.81 | 30832998.0 |
| 2024-12-06 | QQQ | ETF | 522.48 | 526.72 | 522.35 | 526.48 | 23762611.0 |
| 2024-12-06 | IWM | ETF | 239.79 | 239.89 | 238.38 | 238.93 | 20085230.0 |
| 2024-12-06 | DIA | ETF | 449.49 | 449.96 | 446.78 | 447.15 | 1927641.0 |
| 2024-12-06 | GLD | ETF | 242.79 | 243.86 | 242.435 | 242.95 | 3505039.0 |
| 2024-12-06 | TLT | ETF | 94.72 | 94.85 | 94.02 | 94.39 | 29263330.0 |
| 2024-12-06 | AAA | ETF | 25.04 | 25.14 | 25.04 | 25.1111 | 9790.0 |
| 2024-12-06 | AAAU | ETF | 26.0 | 26.1101 | 25.96 | 26.015 | 2658607.0 |
| 2024-12-06 | AADR | ETF | 69.39 | 69.5142 | 69.3433 | 69.5142 | 1809.0 |
| 2024-12-06 | AAPB | ETF | 31.97 | 32.43 | 31.94 | 31.94 | 38620.0 |
| 2024-12-06 | AAPD | ETF | 15.86 | 15.92 | 15.766 | 15.89 | 206026.0 |
| 2024-12-06 | AAPR | ETF | 26.51 | 26.5431 | 26.51 | 26.5431 | 141.0 |
| 2024-12-06 | AAPU | ETF | 40.48 | 41.039 | 40.26 | 40.44 | 299587.0 |
| 2024-12-06 | AAPX | ETF | 36.8 | 37.29 | 36.71 | 36.71 | 12763.0 |
| 2024-12-06 | AAPY | ETF | 28.2551 | 28.259 | 28.21 | 28.21 | 3458.0 |
| 2024-12-06 | AAXJ | ETF | 75.46 | 75.49 | 75.07 | 75.1 | 214798.0 |
| 2024-12-06 | ABCS | ETF | 30.45 | 30.45 | 30.2861 | 30.33 | 1105.0 |
| 2024-12-06 | ABEQ | ETF | 32.9 | 32.9 | 32.88 | 32.8881 | 694.0 |
| 2024-12-06 | ABNY | ETF | 80.1 | 80.4 | 78.873 | 79.65 | 4566.0 |
| 2024-12-06 | ACES | ETF | 27.54 | 27.7 | 27.35 | 27.55 | 65855.0 |
| 2024-12-06 | ACIO | ETF | 41.3 | 41.4386 | 41.2445 | 41.32 | 123500.0 |
| 2024-12-06 | ACSI | ETF | 63.1877 | 63.1877 | 63.1877 | 63.1877 | 12.0 |
| 2024-12-06 | ACT | ETF | 35.45 | 35.585 | 34.96 | 35.08 | 179591.0 |
| 2024-12-06 | ACTV | ETF | 34.25 | 34.25 | 34.07 | 34.11 | 22394.0 |
| 2024-12-06 | ACVF | ETF | 46.04 | 46.0771 | 45.9497 | 45.9565 | 6532.0 |
| 2024-12-06 | ACWI | ETF | 123.2 | 123.38 | 122.96 | 123.12 | 1420529.0 |
| 2024-12-06 | ACWV | ETF | 115.52 | 115.635 | 114.91 | 114.93 | 58966.0 |
| 2024-12-06 | ACWX | ETF | 55.35 | 55.63 | 55.02 | 55.09 | 949461.0 |
| 2024-12-06 | ADFI | ETF | 8.62 | 8.68 | 8.62 | 8.6316 | 45504.0 |
| 2024-12-06 | ADIV | ETF | 15.795 | 15.795 | 15.795 | 15.795 | 99.0 |
| 2024-12-06 | ADME | ETF | 48.46 | 48.46 | 48.28 | 48.3727 | 14520.0 |
| 2024-12-06 | ADPV | ETF | 37.93 | 38.31 | 37.8378 | 38.2918 | 14441.0 |
| 2024-12-06 | ADVE | ETF | 34.49 | 34.506 | 34.46 | 34.506 | 4466.0 |
| 2024-12-06 | AESR | ETF | 18.0 | 18.077 | 17.9946 | 18.0478 | 27708.0 |
| 2024-12-06 | AETH | ETF | 49.71 | 51.9965 | 49.485 | 51.1033 | 17399.0 |
| 2024-12-06 | AFIF | ETF | 9.2091 | 9.21 | 9.2 | 9.205 | 83150.0 |
| 2024-12-06 | AFIX | ETF | 25.1599 | 25.1599 | 25.159 | 25.159 | 513.0 |
| 2024-12-06 | AFK | ETF | 16.37 | 16.39 | 16.0701 | 16.38 | 12670.0 |
| 2024-12-06 | AFLG | ETF | 36.47 | 36.47 | 36.3308 | 36.3396 | 5286.0 |
| 2024-12-06 | AFMC | ETF | 34.22 | 34.22 | 34.01 | 34.13 | 7096.0 |
| 2024-12-06 | AFSM | ETF | 32.71 | 32.718 | 32.5382 | 32.6281 | 5610.0 |
| 2024-12-06 | AGG | ETF | 99.4 | 99.44 | 99.1397 | 99.33 | 12860910.0 |
| 2024-12-06 | AGGH | ETF | 21.04 | 21.04 | 20.9507 | 21.0 | 42462.0 |
| 2024-12-06 | AGGS | ETF | 41.73 | 41.73 | 41.73 | 41.73 | 8.0 |
| 2024-12-06 | AGGY | ETF | 44.16 | 44.16 | 44.0244 | 44.12 | 70307.0 |
| 2024-12-06 | AGIH | ETF | 24.772 | 24.772 | 24.772 | 24.772 | 4.0 |
| 2024-12-06 | AGIX | ETF | 29.96 | 30.15 | 29.96 | 30.13 | 2895.0 |
| 2024-12-06 | AGMI | ETF | 27.6819 | 27.6819 | 27.6819 | 27.6819 | 1.0 |
| 2024-12-06 | AGNG | ETF | 31.68 | 31.68 | 31.55 | 31.6365 | 6018.0 |
| 2024-12-06 | AGOX | ETF | 29.6 | 29.93 | 29.6 | 29.8602 | 26096.0 |
> showing 50 of 3,813 rows — these rows as CSV