PREVIEW / etf_daily / 2024-03-19
file: by_date/etf_daily/2024/2024-03-19.parquet size: 117 KB rows: 3,277
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-03-19 | SPY | ETF | 512.15 | 516.0 | 511.12 | 515.71 | 60755300.0 |
| 2024-03-19 | QQQ | ETF | 435.45 | 438.98 | 433.33 | 438.57 | 43004105.0 |
| 2024-03-19 | IWM | ETF | 199.78 | 202.75 | 199.66 | 202.1 | 29864100.0 |
| 2024-03-19 | DIA | ETF | 388.16 | 391.09 | 387.47 | 390.9 | 3303800.0 |
| 2024-03-19 | GLD | ETF | 199.62 | 199.81 | 198.94 | 199.8 | 4657500.0 |
| 2024-03-19 | TLT | ETF | 92.85 | 93.27 | 92.69 | 92.92 | 26953100.0 |
| 2024-03-19 | AAA | ETF | 25.14 | 25.15 | 25.12 | 25.14 | 11600.0 |
| 2024-03-19 | AAAU | ETF | 21.34 | 21.37 | 21.27 | 21.36 | 2176300.0 |
| 2024-03-19 | AADR | ETF | 61.12 | 61.12 | 61.02 | 61.02 | 400.0 |
| 2024-03-19 | AAPB | ETF | 18.18 | 18.73 | 17.98 | 18.64 | 120819.0 |
| 2024-03-19 | AAPD | ETF | 22.32 | 22.47 | 22.01 | 22.08 | 123382.0 |
| 2024-03-19 | AAPU | ETF | 23.12 | 23.59 | 22.89 | 23.51 | 326542.0 |
| 2024-03-19 | AAPX | ETF | 21.27 | 21.82 | 21.065 | 21.7534 | 17691.0 |
| 2024-03-19 | AAXJ | ETF | 67.04 | 67.28 | 66.83 | 67.21 | 231800.0 |
| 2024-03-19 | ABCS | ETF | 26.25 | 26.3659 | 26.16 | 26.3659 | 2201.0 |
| 2024-03-19 | ABEQ | ETF | 29.54 | 29.62 | 29.53 | 29.607 | 3500.0 |
| 2024-03-19 | ACES | ETF | 27.54 | 27.82 | 27.463 | 27.62 | 52400.0 |
| 2024-03-19 | ACIO | ETF | 35.42 | 35.656 | 35.4 | 35.656 | 62500.0 |
| 2024-03-19 | ACSI | ETF | 50.726 | 50.726 | 50.726 | 50.726 | 100.0 |
| 2024-03-19 | ACT | ETF | 29.27 | 29.69 | 29.26 | 29.61 | 159129.0 |
| 2024-03-19 | ACTV | ETF | 33.41 | 33.63 | 33.35 | 33.57 | 11100.0 |
| 2024-03-19 | ACVF | ETF | 39.47 | 39.756 | 39.435 | 39.756 | 13000.0 |
| 2024-03-19 | ACWF | ETF | 40.5294 | 40.81 | 40.5294 | 40.81 | 3716.0 |
| 2024-03-19 | ACWI | ETF | 108.07 | 108.73 | 107.84 | 108.64 | 3858000.0 |
| 2024-03-19 | ACWV | ETF | 104.23 | 104.7 | 104.19 | 104.67 | 142200.0 |
| 2024-03-19 | ACWX | ETF | 52.71 | 52.94 | 52.59 | 52.8 | 635900.0 |
| 2024-03-19 | ADFI | ETF | 8.48 | 8.58 | 8.47 | 8.51 | 220700.0 |
| 2024-03-19 | ADIV | ETF | 14.092 | 14.092 | 14.092 | 14.092 | 100.0 |
| 2024-03-19 | ADME | ETF | 41.371 | 41.58 | 41.371 | 41.58 | 2900.0 |
| 2024-03-19 | ADPV | ETF | 28.42 | 28.9592 | 28.42 | 28.9592 | 6928.0 |
| 2024-03-19 | AEMB | ETF | 38.29 | 38.32 | 38.29 | 38.32 | 3800.0 |
| 2024-03-19 | AESR | ETF | 15.2 | 15.333 | 15.2 | 15.333 | 59100.0 |
| 2024-03-19 | AETH | ETF | 44.57 | 45.37 | 43.614 | 45.1308 | 27691.0 |
| 2024-03-19 | AFIF | ETF | 9.06 | 9.1 | 9.05 | 9.1 | 24100.0 |
| 2024-03-19 | AFK | ETF | 13.9 | 13.91 | 13.9 | 13.91 | 1600.0 |
| 2024-03-19 | AFLG | ETF | 30.328 | 30.328 | 30.328 | 30.328 | 100.0 |
| 2024-03-19 | AFMC | ETF | 28.89 | 29.16 | 28.89 | 29.121 | 3100.0 |
| 2024-03-19 | AFSM | ETF | 28.21 | 28.27 | 28.121 | 28.169 | 22700.0 |
| 2024-03-19 | AFTY | ETF | 14.105 | 14.105 | 14.105 | 14.105 | 100.0 |
| 2024-03-19 | AGG | ETF | 97.15 | 97.34 | 97.11 | 97.24 | 5076600.0 |
| 2024-03-19 | AGGH | ETF | 21.34 | 21.38 | 21.29 | 21.35 | 58328.0 |
| 2024-03-19 | AGGY | ETF | 43.13 | 43.26 | 43.13 | 43.24 | 82200.0 |
| 2024-03-19 | AGNG | ETF | 29.715 | 29.86 | 29.67 | 29.83 | 14300.0 |
| 2024-03-19 | AGOX | ETF | 25.31 | 25.46 | 25.25 | 25.415 | 9700.0 |
| 2024-03-19 | AGQ | ETF | 28.95 | 29.08 | 28.52 | 28.96 | 589200.0 |
| 2024-03-19 | AGQI | ETF | 13.77 | 13.8 | 13.76 | 13.7967 | 6954.0 |
| 2024-03-19 | AGRH | ETF | 25.93 | 25.93 | 25.85 | 25.86 | 782.0 |
| 2024-03-19 | AGZ | ETF | 107.59 | 107.68 | 107.54 | 107.65 | 12700.0 |
| 2024-03-19 | AGZD | ETF | 22.2 | 22.25 | 22.04 | 22.18 | 38100.0 |
| 2024-03-19 | AHLT | ETF | 23.63 | 23.775 | 23.63 | 23.7632 | 27040.0 |
> showing 50 of 3,277 rows — these rows as CSV