PREVIEW / etf_daily / 2024-03-20
file: by_date/etf_daily/2024/2024-03-20.parquet size: 118 KB rows: 3,283
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-20 | SPY | ETF | 515.77 | 520.62 | 515.08 | 520.48 | 69594600.0 |
| 2024-03-20 | QQQ | ETF | 439.78 | 444.11 | 438.06 | 443.77 | 43653490.0 |
| 2024-03-20 | IWM | ETF | 201.52 | 206.99 | 201.11 | 206.1 | 49609600.0 |
| 2024-03-20 | DIA | ETF | 390.15 | 395.22 | 389.89 | 394.99 | 4823900.0 |
| 2024-03-20 | GLD | ETF | 199.16 | 202.66 | 199.12 | 202.18 | 9593800.0 |
| 2024-03-20 | TLT | ETF | 93.1 | 93.79 | 92.29 | 92.89 | 43460100.0 |
| 2024-03-20 | AAA | ETF | 25.2 | 25.2 | 25.115 | 25.14 | 7000.0 |
| 2024-03-20 | AAAU | ETF | 21.29 | 21.67 | 21.29 | 21.61 | 3271900.0 |
| 2024-03-20 | AADR | ETF | 61.6 | 62.11 | 61.6 | 62.11 | 300.0 |
| 2024-03-20 | AAPB | ETF | 18.5 | 19.16 | 18.43 | 19.13 | 104204.0 |
| 2024-03-20 | AAPD | ETF | 22.13 | 22.2 | 21.77 | 21.78 | 155925.0 |
| 2024-03-20 | AAPU | ETF | 23.38 | 24.01 | 23.3 | 24.0 | 304205.0 |
| 2024-03-20 | AAPX | ETF | 21.68 | 22.37 | 21.67 | 22.37 | 15179.0 |
| 2024-03-20 | AAPY | ETF | 24.2784 | 24.57 | 24.2784 | 24.523 | 6013.0 |
| 2024-03-20 | AAXJ | ETF | 67.5 | 67.89 | 67.21 | 67.83 | 434500.0 |
| 2024-03-20 | ABCS | ETF | 26.445 | 26.683 | 26.445 | 26.683 | 2700.0 |
| 2024-03-20 | ABEQ | ETF | 29.519 | 29.762 | 29.51 | 29.762 | 2800.0 |
| 2024-03-20 | ACES | ETF | 27.65 | 28.58 | 27.4 | 28.48 | 38700.0 |
| 2024-03-20 | ACIO | ETF | 35.68 | 35.92 | 35.609 | 35.91 | 90000.0 |
| 2024-03-20 | ACSI | ETF | 51.222 | 51.222 | 51.222 | 51.222 | 100.0 |
| 2024-03-20 | ACT | ETF | 29.52 | 30.575 | 29.52 | 30.46 | 298860.0 |
| 2024-03-20 | ACTV | ETF | 33.59 | 34.253 | 33.59 | 34.253 | 4400.0 |
| 2024-03-20 | ACVF | ETF | 39.82 | 40.14 | 39.75 | 40.14 | 16000.0 |
| 2024-03-20 | ACWF | ETF | 40.765 | 41.27 | 40.765 | 41.1444 | 3764.0 |
| 2024-03-20 | ACWI | ETF | 108.68 | 109.78 | 108.57 | 109.74 | 2954100.0 |
| 2024-03-20 | ACWV | ETF | 104.78 | 105.01 | 104.47 | 104.97 | 630300.0 |
| 2024-03-20 | ACWX | ETF | 52.82 | 53.43 | 52.77 | 53.38 | 751800.0 |
| 2024-03-20 | ADFI | ETF | 8.5 | 8.53 | 8.47 | 8.52 | 88900.0 |
| 2024-03-20 | ADIV | ETF | 14.125 | 14.224 | 14.12 | 14.224 | 500.0 |
| 2024-03-20 | ADME | ETF | 41.38 | 41.879 | 41.38 | 41.83 | 6600.0 |
| 2024-03-20 | ADPV | ETF | 29.13 | 29.7132 | 29.13 | 29.7132 | 1082.0 |
| 2024-03-20 | AEMB | ETF | 38.445 | 38.445 | 38.445 | 38.445 | 100.0 |
| 2024-03-20 | AESR | ETF | 15.31 | 15.473 | 15.31 | 15.47 | 38400.0 |
| 2024-03-20 | AETH | ETF | 45.26 | 45.88 | 43.1799 | 45.551 | 13554.0 |
| 2024-03-20 | AFIF | ETF | 9.09 | 9.11 | 9.06 | 9.1 | 353100.0 |
| 2024-03-20 | AFK | ETF | 14.0 | 14.3 | 13.88 | 14.3 | 15700.0 |
| 2024-03-20 | AFMC | ETF | 29.16 | 29.62 | 29.16 | 29.567 | 300.0 |
| 2024-03-20 | AFSM | ETF | 28.168 | 28.72 | 28.135 | 28.678 | 2300.0 |
| 2024-03-20 | AFTY | ETF | 14.12 | 14.161 | 14.12 | 14.161 | 400.0 |
| 2024-03-20 | AGG | ETF | 97.29 | 97.63 | 97.13 | 97.44 | 8681200.0 |
| 2024-03-20 | AGGH | ETF | 21.42 | 21.428 | 21.33 | 21.42 | 138140.0 |
| 2024-03-20 | AGGY | ETF | 43.22 | 43.305 | 43.15 | 43.29 | 187200.0 |
| 2024-03-20 | AGNG | ETF | 29.76 | 29.97 | 29.641 | 29.86 | 8700.0 |
| 2024-03-20 | AGOX | ETF | 25.56 | 25.56 | 25.29 | 25.45 | 30600.0 |
| 2024-03-20 | AGQ | ETF | 28.8 | 30.62 | 28.71 | 30.26 | 1147700.0 |
| 2024-03-20 | AGQI | ETF | 13.8 | 13.91 | 13.79 | 13.91 | 11905.0 |
| 2024-03-20 | AGRH | ETF | 25.9273 | 25.9273 | 25.86 | 25.89 | 8710.0 |
| 2024-03-20 | AGZ | ETF | 107.63 | 107.92 | 107.58 | 107.71 | 14600.0 |
| 2024-03-20 | AGZD | ETF | 22.14 | 22.24 | 22.14 | 22.18 | 22400.0 |
| 2024-03-20 | AHLT | ETF | 23.74 | 23.97 | 23.74 | 23.9551 | 2506.0 |
> showing 50 of 3,283 rows — these rows as CSV