PREVIEW / etf_daily / 2025-01-27
file: by_date/etf_daily/2025/2025-01-27.parquet size: 147 KB rows: 3,895
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-27 | SPY | ETF | 594.81 | 599.69 | 594.64 | 599.37 | 68570536.0 |
| 2025-01-27 | QQQ | ETF | 511.0 | 517.99 | 510.15 | 514.21 | 60771695.0 |
| 2025-01-27 | IWM | ETF | 226.71 | 229.62 | 225.21 | 226.5 | 27265964.0 |
| 2025-01-27 | DIA | ETF | 440.64 | 447.31 | 440.54 | 447.12 | 3706915.0 |
| 2025-01-27 | GLD | ETF | 253.86 | 254.26 | 251.92 | 252.99 | 5774116.0 |
| 2025-01-27 | TLT | ETF | 88.155 | 88.43 | 87.85 | 88.25 | 41872104.0 |
| 2025-01-27 | AAA | ETF | 25.18 | 25.1869 | 25.1101 | 25.16 | 10515.0 |
| 2025-01-27 | AAAU | ETF | 27.26 | 27.26 | 27.0 | 27.105 | 1032197.0 |
| 2025-01-27 | AADR | ETF | 72.97 | 73.0 | 72.97 | 73.0 | 1022.0 |
| 2025-01-27 | AAPB | ETF | 26.785 | 28.62 | 26.67 | 28.13 | 914952.0 |
| 2025-01-27 | AAPD | ETF | 17.05 | 17.05 | 16.4481 | 16.61 | 1456040.0 |
| 2025-01-27 | AAPR | ETF | 26.62 | 26.62 | 26.5301 | 26.57 | 1352.0 |
| 2025-01-27 | AAPU | ETF | 29.8 | 31.9 | 29.8 | 31.31 | 4800810.0 |
| 2025-01-27 | AAPX | ETF | 25.39 | 27.3 | 25.39 | 26.86 | 295789.0 |
| 2025-01-27 | AAPY | ETF | 23.74 | 25.05 | 23.74 | 24.8101 | 13658.0 |
| 2025-01-27 | AAXJ | ETF | 71.72 | 71.97 | 71.42 | 71.6 | 626873.0 |
| 2025-01-27 | ABCS | ETF | 29.6782 | 29.85 | 29.6782 | 29.85 | 3709.0 |
| 2025-01-27 | ABEQ | ETF | 32.63 | 32.8399 | 32.62 | 32.8261 | 7356.0 |
| 2025-01-27 | ABFL | ETF | 68.4171 | 68.6332 | 68.32 | 68.5632 | 11356.0 |
| 2025-01-27 | ABHY | ETF | 19.15 | 19.17 | 19.15 | 19.1678 | 3811.0 |
| 2025-01-27 | ABLD | ETF | 29.15 | 29.21 | 29.14 | 29.202 | 35763.0 |
| 2025-01-27 | ABLG | ETF | 29.68 | 29.813 | 29.68 | 29.813 | 10821.0 |
| 2025-01-27 | ABNY | ETF | 70.6 | 72.05 | 70.3 | 72.05 | 3638.0 |
| 2025-01-27 | ABOT | ETF | 36.85 | 37.1 | 36.71 | 36.8099 | 7923.0 |
| 2025-01-27 | ACES | ETF | 25.62 | 26.05 | 25.48 | 25.7 | 110192.0 |
| 2025-01-27 | ACGR | ETF | 58.0625 | 58.12 | 57.77 | 57.9969 | 1893.0 |
| 2025-01-27 | ACIO | ETF | 40.77 | 40.97 | 40.55 | 40.95 | 208807.0 |
| 2025-01-27 | ACLC | ETF | 71.7901 | 71.9723 | 71.63 | 71.9723 | 5510.0 |
| 2025-01-27 | ACSI | ETF | 63.031 | 63.2398 | 63.031 | 63.2398 | 211.0 |
| 2025-01-27 | ACT | ETF | 33.29 | 34.1075 | 33.29 | 34.0 | 248673.0 |
| 2025-01-27 | ACTV | ETF | 33.13 | 33.37 | 33.07 | 33.1857 | 11694.0 |
| 2025-01-27 | ACVF | ETF | 44.75 | 44.885 | 44.626 | 44.7467 | 13580.0 |
| 2025-01-27 | ACWI | ETF | 119.78 | 120.735 | 119.78 | 120.6 | 5934799.0 |
| 2025-01-27 | ACWV | ETF | 110.66 | 112.03 | 110.65 | 112.03 | 178561.0 |
| 2025-01-27 | ACWX | ETF | 53.87 | 53.87 | 53.5625 | 53.83 | 2029576.0 |
| 2025-01-27 | ADFI | ETF | 8.46 | 8.47 | 8.431 | 8.47 | 59769.0 |
| 2025-01-27 | ADIV | ETF | 15.65 | 15.65 | 15.54 | 15.56 | 1705.0 |
| 2025-01-27 | ADME | ETF | 47.68 | 47.7705 | 47.5574 | 47.7705 | 16071.0 |
| 2025-01-27 | ADPV | ETF | 37.62 | 37.68 | 37.12 | 37.45 | 21924.0 |
| 2025-01-27 | ADVE | ETF | 31.913 | 31.913 | 31.913 | 31.913 | 78.0 |
| 2025-01-27 | AESR | ETF | 17.71 | 17.7328 | 17.572 | 17.6445 | 54440.0 |
| 2025-01-27 | AETH | ETF | 32.7 | 32.79 | 32.7 | 32.7293 | 2864.0 |
| 2025-01-27 | AFIF | ETF | 9.1968 | 9.1968 | 9.1669 | 9.1669 | 265486.0 |
| 2025-01-27 | AFIX | ETF | 24.642 | 24.642 | 24.642 | 24.642 | 6.0 |
| 2025-01-27 | AFK | ETF | 16.48 | 16.48 | 16.0579 | 16.21 | 9588.0 |
| 2025-01-27 | AFLG | ETF | 35.41 | 35.41 | 35.2201 | 35.3587 | 43223.0 |
| 2025-01-27 | AFMC | ETF | 33.04 | 33.07 | 32.909 | 32.995 | 79617.0 |
| 2025-01-27 | AFSM | ETF | 30.91 | 30.91 | 30.6101 | 30.6866 | 4623.0 |
| 2025-01-27 | AGG | ETF | 97.49 | 97.56 | 97.31 | 97.55 | 7599719.0 |
| 2025-01-27 | AGGH | ETF | 20.5 | 20.84 | 20.5 | 20.84 | 55306.0 |
> showing 50 of 3,895 rows — these rows as CSV