PREVIEW / etf_daily / 2025-01-02
file: by_date/etf_daily/2025/2025-01-02.parquet size: 146 KB rows: 3,875
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 |
|---|---|---|---|---|---|---|---|
| 2025-01-02 | SPY | ETF | 589.39 | 591.13 | 580.5 | 584.64 | 50364811.0 |
| 2025-01-02 | QQQ | ETF | 514.3 | 516.64 | 505.71 | 510.23 | 36389783.0 |
| 2025-01-02 | IWM | ETF | 222.93 | 224.37 | 219.596 | 221.14 | 29029764.0 |
| 2025-01-02 | DIA | ETF | 428.34 | 428.96 | 421.59 | 423.8 | 4114358.0 |
| 2025-01-02 | GLD | ETF | 244.22 | 245.53 | 244.08 | 245.42 | 6159339.0 |
| 2025-01-02 | TLT | ETF | 87.8 | 88.115 | 87.21 | 87.57 | 27793096.0 |
| 2025-01-02 | AAA | ETF | 25.13 | 25.139 | 25.0601 | 25.1 | 13719.0 |
| 2025-01-02 | AAAU | ETF | 26.16 | 26.3 | 26.149 | 26.285 | 2129127.0 |
| 2025-01-02 | AADR | ETF | 69.64 | 70.4246 | 69.64 | 70.4246 | 11148.0 |
| 2025-01-02 | AAPB | ETF | 33.3 | 33.39 | 31.55 | 31.97 | 127069.0 |
| 2025-01-02 | AAPD | ETF | 15.38 | 15.7994 | 15.37 | 15.68 | 1124274.0 |
| 2025-01-02 | AAPR | ETF | 26.37 | 26.4055 | 26.27 | 26.335 | 19763.0 |
| 2025-01-02 | AAPU | ETF | 37.19 | 37.26 | 35.09 | 35.67 | 581708.0 |
| 2025-01-02 | AAPX | ETF | 31.88 | 31.88 | 30.1 | 30.53 | 34456.0 |
| 2025-01-02 | AAPY | ETF | 26.67 | 26.92 | 26.42 | 26.5887 | 7198.0 |
| 2025-01-02 | AAXJ | ETF | 72.13 | 72.32 | 71.71 | 71.89 | 223439.0 |
| 2025-01-02 | ABCS | ETF | 28.74 | 28.782 | 28.4149 | 28.53 | 1773.0 |
| 2025-01-02 | ABEQ | ETF | 31.57 | 31.65 | 31.51 | 31.6104 | 1868.0 |
| 2025-01-02 | ABFL | ETF | 66.4664 | 67.14 | 66.2599 | 66.5108 | 22215.0 |
| 2025-01-02 | ABHY | ETF | 19.07 | 19.07 | 19.04 | 19.06 | 1317.0 |
| 2025-01-02 | ABLD | ETF | 28.15 | 28.15 | 28.1341 | 28.1341 | 172.0 |
| 2025-01-02 | ABLG | ETF | 28.57 | 28.626 | 28.57 | 28.6257 | 4907.0 |
| 2025-01-02 | ABNY | ETF | 76.15 | 76.35 | 74.153 | 75.2 | 1825.0 |
| 2025-01-02 | ABOT | ETF | 36.5499 | 36.5499 | 36.208 | 36.208 | 1953.0 |
| 2025-01-02 | ACES | ETF | 26.15 | 26.93 | 26.15 | 26.71 | 57152.0 |
| 2025-01-02 | ACGR | ETF | 57.95 | 58.08 | 57.55 | 57.6627 | 943.0 |
| 2025-01-02 | ACIO | ETF | 40.33 | 41.18 | 40.0 | 40.155 | 158553.0 |
| 2025-01-02 | ACLC | ETF | 70.8 | 70.97 | 70.0 | 70.431 | 3778.0 |
| 2025-01-02 | ACSI | ETF | 60.77 | 60.77 | 60.44 | 60.44 | 390.0 |
| 2025-01-02 | ACT | ETF | 32.52 | 32.71 | 32.139 | 32.32 | 267823.0 |
| 2025-01-02 | ACTV | ETF | 32.7287 | 32.7287 | 32.3313 | 32.3641 | 5194.0 |
| 2025-01-02 | ACVF | ETF | 43.97 | 44.0 | 43.4648 | 43.77 | 14065.0 |
| 2025-01-02 | ACWI | ETF | 118.01 | 118.36 | 116.64 | 117.27 | 4049647.0 |
| 2025-01-02 | ACWV | ETF | 109.43 | 109.62 | 108.615 | 108.93 | 98971.0 |
| 2025-01-02 | ACWX | ETF | 52.22 | 52.355 | 51.9 | 52.05 | 1347391.0 |
| 2025-01-02 | ADFI | ETF | 8.39 | 8.41 | 8.35 | 8.37 | 12259.0 |
| 2025-01-02 | ADIV | ETF | 15.33 | 15.33 | 15.2209 | 15.23 | 1136.0 |
| 2025-01-02 | ADME | ETF | 47.13 | 47.13 | 46.496 | 46.66 | 11959.0 |
| 2025-01-02 | ADPV | ETF | 35.81 | 36.2142 | 35.66 | 36.1004 | 15449.0 |
| 2025-01-02 | ADVE | ETF | 32.16 | 32.16 | 31.9674 | 31.9674 | 691.0 |
| 2025-01-02 | AESR | ETF | 17.6 | 17.6 | 17.21 | 17.32 | 19930.0 |
| 2025-01-02 | AETH | ETF | 37.06 | 37.11 | 37.03 | 37.0604 | 4320.0 |
| 2025-01-02 | AFIF | ETF | 9.14 | 9.17 | 9.14 | 9.16 | 83889.0 |
| 2025-01-02 | AFIX | ETF | 24.5247 | 24.5247 | 24.5247 | 24.5247 | 2.0 |
| 2025-01-02 | AFK | ETF | 15.76 | 15.76 | 15.57 | 15.71 | 14339.0 |
| 2025-01-02 | AFLG | ETF | 34.77 | 34.853 | 34.3118 | 34.5 | 82201.0 |
| 2025-01-02 | AFMC | ETF | 31.85 | 31.8899 | 31.52 | 31.6038 | 171007.0 |
| 2025-01-02 | AFSM | ETF | 30.37 | 30.37 | 29.93 | 30.08 | 12888.0 |
| 2025-01-02 | AGG | ETF | 97.07 | 97.205 | 96.78 | 96.91 | 5547581.0 |
| 2025-01-02 | AGGH | ETF | 20.69 | 20.69 | 20.5 | 20.54 | 168171.0 |
> showing 50 of 3,875 rows — these rows as CSV