PREVIEW / etf_daily / 2024-03-22
file: by_date/etf_daily/2024/2024-03-22.parquet size: 117 KB rows: 3,271
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-22 | SPY | ETF | 522.11 | 522.61 | 520.97 | 521.21 | 79023000.0 |
| 2024-03-22 | QQQ | ETF | 445.35 | 447.49 | 444.49 | 446.38 | 28253899.0 |
| 2024-03-22 | IWM | ETF | 207.85 | 208.24 | 205.07 | 205.07 | 28422000.0 |
| 2024-03-22 | DIA | ETF | 397.76 | 398.06 | 394.49 | 394.53 | 3154100.0 |
| 2024-03-22 | GLD | ETF | 201.32 | 201.86 | 199.72 | 200.35 | 6913600.0 |
| 2024-03-22 | TLT | ETF | 94.19 | 94.21 | 93.78 | 93.98 | 30258200.0 |
| 2024-03-22 | AAA | ETF | 25.15 | 25.15 | 25.103 | 25.145 | 6300.0 |
| 2024-03-22 | AAAU | ETF | 21.53 | 21.59 | 21.36 | 21.43 | 2505200.0 |
| 2024-03-22 | AADR | ETF | 62.52 | 62.52 | 62.52 | 62.52 | 100.0 |
| 2024-03-22 | AAPB | ETF | 17.68 | 17.92 | 17.33 | 17.74 | 483872.0 |
| 2024-03-22 | AAPD | ETF | 22.63 | 22.84 | 22.44 | 22.53 | 324416.0 |
| 2024-03-22 | AAPU | ETF | 22.59 | 22.86 | 22.2727 | 22.71 | 336439.0 |
| 2024-03-22 | AAPX | ETF | 20.46 | 20.9499 | 20.28 | 20.7946 | 29883.0 |
| 2024-03-22 | AAPY | ETF | 23.67 | 23.87 | 23.67 | 23.7774 | 1080.0 |
| 2024-03-22 | AAXJ | ETF | 67.56 | 67.6 | 67.39 | 67.46 | 310600.0 |
| 2024-03-22 | ABCS | ETF | 26.92 | 26.92 | 26.7703 | 26.7703 | 2014.0 |
| 2024-03-22 | ABEQ | ETF | 29.77 | 29.78 | 29.678 | 29.678 | 3800.0 |
| 2024-03-22 | ACES | ETF | 28.71 | 28.71 | 28.21 | 28.31 | 140500.0 |
| 2024-03-22 | ACIO | ETF | 36.04 | 36.04 | 35.93 | 36.0 | 114600.0 |
| 2024-03-22 | ACSI | ETF | 51.321 | 51.321 | 51.321 | 51.321 | 100.0 |
| 2024-03-22 | ACT | ETF | 30.76 | 30.76 | 30.41 | 30.43 | 158104.0 |
| 2024-03-22 | ACTV | ETF | 34.48 | 34.48 | 34.09 | 34.1 | 6900.0 |
| 2024-03-22 | ACVF | ETF | 40.49 | 40.49 | 40.27 | 40.335 | 11500.0 |
| 2024-03-22 | ACWF | ETF | 41.34 | 41.34 | 41.23 | 41.2467 | 2920.0 |
| 2024-03-22 | ACWI | ETF | 109.9 | 109.97 | 109.64 | 109.72 | 1712000.0 |
| 2024-03-22 | ACWV | ETF | 104.95 | 105.1 | 104.74 | 104.74 | 143500.0 |
| 2024-03-22 | ACWX | ETF | 53.26 | 53.32 | 53.12 | 53.15 | 564100.0 |
| 2024-03-22 | ADFI | ETF | 8.54 | 8.55 | 8.52 | 8.54 | 18700.0 |
| 2024-03-22 | ADIV | ETF | 14.154 | 14.154 | 14.154 | 14.154 | 100.0 |
| 2024-03-22 | ADME | ETF | 41.94 | 42.06 | 41.92 | 41.92 | 7400.0 |
| 2024-03-22 | ADPV | ETF | 30.0 | 30.0691 | 29.95 | 30.0691 | 3736.0 |
| 2024-03-22 | ADVE | ETF | 32.6399 | 32.64 | 32.6044 | 32.6044 | 300.0 |
| 2024-03-22 | AEMB | ETF | 38.87 | 38.87 | 38.76 | 38.76 | 800.0 |
| 2024-03-22 | AESR | ETF | 15.59 | 15.606 | 15.54 | 15.57 | 61800.0 |
| 2024-03-22 | AETH | ETF | 45.95 | 45.95 | 44.6467 | 45.1805 | 6230.0 |
| 2024-03-22 | AFIF | ETF | 9.12 | 9.12 | 9.08 | 9.1 | 94100.0 |
| 2024-03-22 | AFK | ETF | 14.19 | 14.33 | 14.18 | 14.27 | 5800.0 |
| 2024-03-22 | AFLG | ETF | 30.767 | 30.767 | 30.767 | 30.767 | 100.0 |
| 2024-03-22 | AFMC | ETF | 29.75 | 29.85 | 29.75 | 29.751 | 2300.0 |
| 2024-03-22 | AFSM | ETF | 28.686 | 28.686 | 28.686 | 28.686 | 100.0 |
| 2024-03-22 | AFTY | ETF | 13.905 | 13.905 | 13.905 | 13.905 | 100.0 |
| 2024-03-22 | AGG | ETF | 97.91 | 97.91 | 97.74 | 97.82 | 8359200.0 |
| 2024-03-22 | AGGH | ETF | 21.58 | 21.58 | 21.46 | 21.55 | 54042.0 |
| 2024-03-22 | AGGY | ETF | 43.29 | 43.33 | 43.28 | 43.32 | 298400.0 |
| 2024-03-22 | AGNG | ETF | 29.78 | 29.82 | 29.55 | 29.55 | 11900.0 |
| 2024-03-22 | AGOX | ETF | 25.55 | 25.81 | 25.49 | 25.79 | 34500.0 |
| 2024-03-22 | AGQ | ETF | 28.57 | 28.97 | 28.25 | 28.32 | 888800.0 |
| 2024-03-22 | AGQI | ETF | 13.9 | 13.905 | 13.85 | 13.8748 | 20716.0 |
| 2024-03-22 | AGRH | ETF | 25.98 | 25.98 | 25.955 | 25.955 | 1305.0 |
| 2024-03-22 | AGZ | ETF | 107.94 | 108.07 | 107.93 | 107.99 | 17600.0 |
> showing 50 of 3,271 rows — these rows as CSV