PREVIEW / etf_daily / 2024-02-20
file: by_date/etf_daily/2024/2024-02-20.parquet size: 117 KB rows: 3,264
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-02-20 | SPY | ETF | 497.72 | 498.41 | 494.45 | 496.76 | 71736700.0 |
| 2024-02-20 | QQQ | ETF | 428.55 | 430.08 | 423.5 | 427.32 | 53999452.0 |
| 2024-02-20 | IWM | ETF | 199.15 | 199.72 | 198.01 | 198.88 | 30547500.0 |
| 2024-02-20 | DIA | ETF | 385.51 | 386.57 | 384.54 | 385.69 | 3295700.0 |
| 2024-02-20 | GLD | ETF | 187.96 | 188.03 | 187.4 | 187.47 | 5531200.0 |
| 2024-02-20 | TLT | ETF | 92.79 | 93.19 | 92.72 | 92.84 | 24469300.0 |
| 2024-02-20 | AAA | ETF | 25.12 | 25.15 | 25.11 | 25.15 | 2400.0 |
| 2024-02-20 | AAAU | ETF | 20.09 | 20.1 | 20.03 | 20.05 | 1716200.0 |
| 2024-02-20 | AADR | ETF | 57.21 | 57.59 | 56.91 | 57.13 | 7000.0 |
| 2024-02-20 | AAPB | ETF | 20.11 | 20.11 | 19.75 | 20.09 | 25114.0 |
| 2024-02-20 | AAPD | ETF | 21.49 | 21.685 | 21.408 | 21.5 | 294141.0 |
| 2024-02-20 | AAPU | ETF | 24.93 | 25.02 | 24.54 | 24.84 | 119063.0 |
| 2024-02-20 | AAPX | ETF | 23.36 | 23.43 | 23.08 | 23.37 | 13767.0 |
| 2024-02-20 | AAPY | ETF | 25.25 | 25.25 | 25.2218 | 25.2218 | 730.0 |
| 2024-02-20 | AAXJ | ETF | 66.07 | 66.3 | 65.77 | 65.92 | 782400.0 |
| 2024-02-20 | ABCS | ETF | 25.36 | 25.39 | 25.3234 | 25.3234 | 388.0 |
| 2024-02-20 | ABEQ | ETF | 28.94 | 28.94 | 28.88 | 28.88 | 27500.0 |
| 2024-02-20 | ACES | ETF | 31.27 | 31.32 | 30.575 | 30.89 | 110800.0 |
| 2024-02-20 | ACIO | ETF | 34.54 | 34.57 | 34.37 | 34.47 | 91200.0 |
| 2024-02-20 | ACSI | ETF | 49.22 | 49.22 | 49.22 | 49.22 | 500.0 |
| 2024-02-20 | ACT | ETF | 27.05 | 27.13 | 26.85 | 26.93 | 254708.0 |
| 2024-02-20 | ACTV | ETF | 33.06 | 33.14 | 33.035 | 33.083 | 16800.0 |
| 2024-02-20 | ACVF | ETF | 38.37 | 38.37 | 38.02 | 38.132 | 7600.0 |
| 2024-02-20 | ACWF | ETF | 39.55 | 39.55 | 39.35 | 39.3906 | 6391.0 |
| 2024-02-20 | ACWI | ETF | 105.16 | 105.25 | 104.48 | 104.89 | 3328500.0 |
| 2024-02-20 | ACWV | ETF | 102.74 | 103.24 | 102.74 | 102.87 | 109000.0 |
| 2024-02-20 | ACWX | ETF | 51.52 | 51.56 | 51.27 | 51.38 | 1254200.0 |
| 2024-02-20 | ADFI | ETF | 8.45 | 8.51 | 8.45 | 8.5 | 10800.0 |
| 2024-02-20 | ADIV | ETF | 14.056 | 14.056 | 14.056 | 14.056 | 100.0 |
| 2024-02-20 | ADME | ETF | 40.3 | 40.3 | 39.94 | 40.035 | 13900.0 |
| 2024-02-20 | ADPV | ETF | 26.62 | 26.7119 | 26.62 | 26.7119 | 2909.0 |
| 2024-02-20 | ADVE | ETF | 31.75 | 31.75 | 31.6 | 31.66 | 2501.0 |
| 2024-02-20 | AEMB | ETF | 37.64 | 37.67 | 37.46 | 37.555 | 2200.0 |
| 2024-02-20 | AESR | ETF | 14.7 | 14.7 | 14.61 | 14.66 | 21200.0 |
| 2024-02-20 | AETH | ETF | 40.53 | 40.855 | 39.69 | 40.7879 | 7616.0 |
| 2024-02-20 | AFIF | ETF | 9.02 | 9.09 | 9.02 | 9.09 | 95000.0 |
| 2024-02-20 | AFK | ETF | 13.16 | 13.23 | 13.01 | 13.06 | 5200.0 |
| 2024-02-20 | AFLG | ETF | 28.68 | 28.749 | 28.68 | 28.749 | 600.0 |
| 2024-02-20 | AFMC | ETF | 27.359 | 27.359 | 27.359 | 27.359 | 300.0 |
| 2024-02-20 | AFSM | ETF | 27.442 | 27.442 | 27.442 | 27.442 | 100.0 |
| 2024-02-20 | AFTY | ETF | 13.6 | 13.6 | 13.564 | 13.564 | 600.0 |
| 2024-02-20 | AGG | ETF | 97.23 | 97.36 | 97.16 | 97.19 | 8735700.0 |
| 2024-02-20 | AGGH | ETF | 21.53 | 21.55 | 21.49 | 21.5 | 58625.0 |
| 2024-02-20 | AGGY | ETF | 43.13 | 43.23 | 43.13 | 43.175 | 123500.0 |
| 2024-02-20 | AGNG | ETF | 29.34 | 29.5 | 29.119 | 29.19 | 5600.0 |
| 2024-02-20 | AGOX | ETF | 24.35 | 24.54 | 24.33 | 24.404 | 13400.0 |
| 2024-02-20 | AGQ | ETF | 25.22 | 25.25 | 24.86 | 24.93 | 799400.0 |
| 2024-02-20 | AGQI | ETF | 13.49 | 13.52 | 13.475 | 13.495 | 18902.0 |
| 2024-02-20 | AGRH | ETF | 25.8999 | 25.91 | 25.8645 | 25.8747 | 2955.0 |
| 2024-02-20 | AGZ | ETF | 107.72 | 107.74 | 107.6 | 107.6 | 18800.0 |
> showing 50 of 3,264 rows — these rows as CSV