PREVIEW / etf_daily / 2024-03-27
file: by_date/etf_daily/2024/2024-03-27.parquet size: 118 KB rows: 3,289
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-27 | SPY | ETF | 521.71 | 523.21 | 519.49 | 523.17 | 82999800.0 |
| 2024-03-27 | QQQ | ETF | 446.44 | 446.54 | 441.93 | 444.83 | 41359240.0 |
| 2024-03-27 | IWM | ETF | 206.8 | 209.71 | 206.16 | 209.64 | 35028400.0 |
| 2024-03-27 | DIA | ETF | 395.0 | 397.58 | 394.47 | 397.56 | 4427300.0 |
| 2024-03-27 | GLD | ETF | 202.32 | 203.22 | 202.32 | 203.1 | 6041000.0 |
| 2024-03-27 | TLT | ETF | 93.99 | 94.7 | 93.94 | 94.7 | 50157800.0 |
| 2024-03-27 | AAA | ETF | 25.14 | 25.14 | 25.005 | 25.005 | 13500.0 |
| 2024-03-27 | AAAU | ETF | 21.64 | 21.73 | 21.64 | 21.71 | 2403500.0 |
| 2024-03-27 | AADR | ETF | 61.91 | 62.27 | 61.91 | 62.2 | 3200.0 |
| 2024-03-27 | AAPB | ETF | 17.37 | 17.9903 | 17.35 | 17.96 | 233081.0 |
| 2024-03-27 | AAPD | ETF | 22.83 | 22.83 | 22.3821 | 22.41 | 105615.0 |
| 2024-03-27 | AAPU | ETF | 22.33 | 22.93 | 22.28 | 22.9 | 324554.0 |
| 2024-03-27 | AAPX | ETF | 20.33 | 21.0 | 20.21 | 20.95 | 46642.0 |
| 2024-03-27 | AAPY | ETF | 23.56 | 23.881 | 23.56 | 23.881 | 1410.0 |
| 2024-03-27 | AAXJ | ETF | 67.42 | 67.56 | 67.33 | 67.54 | 885400.0 |
| 2024-03-27 | ABCS | ETF | 26.8501 | 27.21 | 26.85 | 27.1697 | 1646.0 |
| 2024-03-27 | ABEQ | ETF | 29.927 | 30.188 | 29.927 | 30.188 | 4000.0 |
| 2024-03-27 | ACES | ETF | 28.24 | 29.47 | 28.24 | 29.43 | 27500.0 |
| 2024-03-27 | ACIO | ETF | 35.895 | 35.99 | 35.77 | 35.99 | 102300.0 |
| 2024-03-27 | ACSI | ETF | 51.756 | 51.756 | 51.756 | 51.756 | 100.0 |
| 2024-03-27 | ACT | ETF | 30.6 | 30.96 | 30.6 | 30.96 | 138718.0 |
| 2024-03-27 | ACTV | ETF | 34.591 | 34.969 | 34.591 | 34.969 | 5900.0 |
| 2024-03-27 | ACVF | ETF | 40.28 | 40.307 | 40.093 | 40.307 | 7200.0 |
| 2024-03-27 | ACWF | ETF | 41.1302 | 41.2417 | 41.04 | 41.2417 | 2973.0 |
| 2024-03-27 | ACWI | ETF | 109.86 | 110.15 | 109.5 | 110.15 | 1268500.0 |
| 2024-03-27 | ACWV | ETF | 104.93 | 105.34 | 104.85 | 105.34 | 160900.0 |
| 2024-03-27 | ACWX | ETF | 53.23 | 53.42 | 53.15 | 53.42 | 904100.0 |
| 2024-03-27 | ADFI | ETF | 8.55 | 8.555 | 8.51 | 8.555 | 2900.0 |
| 2024-03-27 | ADIV | ETF | 14.17 | 14.23 | 14.17 | 14.23 | 700.0 |
| 2024-03-27 | ADME | ETF | 41.86 | 41.943 | 41.73 | 41.943 | 6500.0 |
| 2024-03-27 | ADPV | ETF | 29.76 | 29.8912 | 29.6781 | 29.8912 | 2039.0 |
| 2024-03-27 | AEMB | ETF | 38.855 | 38.855 | 38.855 | 38.855 | 100.0 |
| 2024-03-27 | AESR | ETF | 15.56 | 15.571 | 15.47 | 15.556 | 16700.0 |
| 2024-03-27 | AETH | ETF | 49.252 | 49.252 | 46.625 | 46.8855 | 5406.0 |
| 2024-03-27 | AFIF | ETF | 9.1 | 9.11 | 9.09 | 9.11 | 19800.0 |
| 2024-03-27 | AFK | ETF | 14.34 | 14.48 | 14.29 | 14.48 | 8800.0 |
| 2024-03-27 | AFLG | ETF | 30.699 | 30.804 | 30.699 | 30.804 | 1800.0 |
| 2024-03-27 | AFMC | ETF | 30.113 | 30.113 | 30.113 | 30.113 | 200.0 |
| 2024-03-27 | AFSM | ETF | 28.91 | 29.06 | 28.73 | 29.044 | 4900.0 |
| 2024-03-27 | AFTY | ETF | 13.95 | 13.95 | 13.95 | 13.95 | 100.0 |
| 2024-03-27 | AGG | ETF | 97.8 | 98.08 | 97.79 | 98.06 | 9366800.0 |
| 2024-03-27 | AGGH | ETF | 21.33 | 21.39 | 21.27 | 21.34 | 52128.0 |
| 2024-03-27 | AGGY | ETF | 43.3 | 43.4 | 43.267 | 43.39 | 91800.0 |
| 2024-03-27 | AGNG | ETF | 29.94 | 30.14 | 29.92 | 30.14 | 2300.0 |
| 2024-03-27 | AGOX | ETF | 25.54 | 25.628 | 25.42 | 25.42 | 17900.0 |
| 2024-03-27 | AGQ | ETF | 27.72 | 28.22 | 27.71 | 28.14 | 475400.0 |
| 2024-03-27 | AGQI | ETF | 13.88 | 13.92 | 13.86 | 13.9197 | 19166.0 |
| 2024-03-27 | AGRH | ETF | 25.96 | 26.03 | 25.96 | 25.995 | 7271.0 |
| 2024-03-27 | AGZ | ETF | 108.1 | 108.22 | 108.05 | 108.18 | 16700.0 |
| 2024-03-27 | AGZD | ETF | 22.06 | 22.14 | 22.06 | 22.06 | 32500.0 |
> showing 50 of 3,289 rows — these rows as CSV