PREVIEW / etf_daily / 2024-11-19
file: by_date/etf_daily/2024/2024-11-19.parquet size: 144 KB rows: 3,788
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-19 | SPY | ETF | 584.71 | 591.045 | 584.03 | 590.3 | 47973160.0 |
| 2024-11-19 | QQQ | ETF | 497.42 | 503.9536 | 497.08 | 503.46 | 24523020.0 |
| 2024-11-19 | IWM | ETF | 226.59 | 230.82 | 226.4 | 230.63 | 25858057.0 |
| 2024-11-19 | DIA | ETF | 430.73 | 434.12 | 429.6401 | 432.84 | 2798505.0 |
| 2024-11-19 | GLD | ETF | 242.75 | 243.31 | 242.03 | 243.25 | 6476774.0 |
| 2024-11-19 | TLT | ETF | 90.82 | 91.07 | 90.62 | 90.7 | 29620320.0 |
| 2024-11-19 | AAA | ETF | 25.1511 | 25.16 | 25.105 | 25.105 | 4608.0 |
| 2024-11-19 | AAAU | ETF | 25.99 | 26.05 | 25.9101 | 26.04 | 2676498.0 |
| 2024-11-19 | AADR | ETF | 66.52 | 66.86 | 66.52 | 66.83 | 1657.0 |
| 2024-11-19 | AAPB | ETF | 27.98 | 28.82 | 27.98 | 28.39 | 26775.0 |
| 2024-11-19 | AAPD | ETF | 16.9 | 16.92 | 16.6999 | 16.84 | 198346.0 |
| 2024-11-19 | AAPR | ETF | 25.89 | 26.295 | 25.89 | 26.295 | 9571.0 |
| 2024-11-19 | AAPU | ETF | 35.42 | 36.52 | 35.42 | 35.91 | 289164.0 |
| 2024-11-19 | AAPX | ETF | 32.58 | 33.2 | 32.42 | 32.57 | 14794.0 |
| 2024-11-19 | AAPY | ETF | 27.2465 | 27.2465 | 27.0193 | 27.0193 | 1638.0 |
| 2024-11-19 | AAXJ | ETF | 74.1 | 74.5299 | 74.055 | 74.38 | 784650.0 |
| 2024-11-19 | ABCS | ETF | 29.25 | 29.35 | 29.25 | 29.33 | 1037.0 |
| 2024-11-19 | ABEQ | ETF | 32.53 | 32.6 | 32.515 | 32.5925 | 2521.0 |
| 2024-11-19 | ABNY | ETF | 76.15 | 77.65 | 76.15 | 77.1 | 2090.0 |
| 2024-11-19 | ACES | ETF | 26.4 | 26.6575 | 26.25 | 26.56 | 195469.0 |
| 2024-11-19 | ACIO | ETF | 40.2 | 40.51 | 40.18 | 40.48 | 294034.0 |
| 2024-11-19 | ACSI | ETF | 60.7306 | 60.7306 | 60.7306 | 60.7306 | 22.0 |
| 2024-11-19 | ACT | ETF | 33.54 | 34.0 | 33.54 | 33.94 | 211578.0 |
| 2024-11-19 | ACTV | ETF | 32.205 | 32.3 | 32.18 | 32.2535 | 13822.0 |
| 2024-11-19 | ACVF | ETF | 44.52 | 44.8507 | 44.46 | 44.8507 | 4989.0 |
| 2024-11-19 | ACWI | ETF | 118.47 | 119.715 | 118.26 | 119.56 | 2084989.0 |
| 2024-11-19 | ACWV | ETF | 112.12 | 112.53 | 111.85 | 112.28 | 174803.0 |
| 2024-11-19 | ACWX | ETF | 53.49 | 53.79 | 53.295 | 53.73 | 2495562.0 |
| 2024-11-19 | ADFI | ETF | 8.49 | 8.56 | 8.47 | 8.5037 | 21214.0 |
| 2024-11-19 | ADIV | ETF | 15.55 | 15.55 | 15.5381 | 15.5381 | 558.0 |
| 2024-11-19 | ADME | ETF | 46.73 | 47.2099 | 46.73 | 47.1625 | 21540.0 |
| 2024-11-19 | ADPV | ETF | 36.11 | 36.71 | 36.0758 | 36.6989 | 10706.0 |
| 2024-11-19 | ADVE | ETF | 33.9211 | 33.9211 | 33.9211 | 33.9211 | 42.0 |
| 2024-11-19 | AESR | ETF | 17.37 | 17.445 | 17.37 | 17.4295 | 27009.0 |
| 2024-11-19 | AETH | ETF | 39.64 | 40.1114 | 39.52 | 39.5576 | 16238.0 |
| 2024-11-19 | AFIF | ETF | 9.16 | 9.17 | 9.16 | 9.1643 | 15366.0 |
| 2024-11-19 | AFK | ETF | 15.94 | 16.1436 | 15.88 | 16.08 | 13614.0 |
| 2024-11-19 | AFLG | ETF | 34.81 | 35.17 | 34.81 | 35.16 | 19408.0 |
| 2024-11-19 | AFMC | ETF | 32.97 | 33.16 | 32.925 | 33.1342 | 4503.0 |
| 2024-11-19 | AFSM | ETF | 31.2 | 31.7 | 31.2 | 31.7 | 2747.0 |
| 2024-11-19 | AGG | ETF | 97.95 | 98.045 | 97.87 | 97.89 | 4730797.0 |
| 2024-11-19 | AGGH | ETF | 20.87 | 20.87 | 20.7208 | 20.81 | 42263.0 |
| 2024-11-19 | AGGS | ETF | 41.1279 | 41.1279 | 41.1279 | 41.1279 | 2.0 |
| 2024-11-19 | AGGY | ETF | 43.46 | 43.5 | 43.43 | 43.45 | 93145.0 |
| 2024-11-19 | AGIH | ETF | 24.6 | 24.6 | 24.6 | 24.6 | 2.0 |
| 2024-11-19 | AGIX | ETF | 27.15 | 27.61 | 27.13 | 27.61 | 1250.0 |
| 2024-11-19 | AGMI | ETF | 28.8832 | 28.8832 | 28.8832 | 28.8832 | 2.0 |
| 2024-11-19 | AGNG | ETF | 30.54 | 30.86 | 30.54 | 30.69 | 4939.0 |
| 2024-11-19 | AGOX | ETF | 28.9 | 29.0699 | 28.65 | 28.88 | 39602.0 |
| 2024-11-19 | AGQ | ETF | 39.69 | 39.97 | 39.27 | 39.84 | 1061882.0 |
> showing 50 of 3,788 rows — these rows as CSV