PREVIEW / etf_daily / 2024-01-12
file: by_date/etf_daily/2024/2024-01-12.parquet size: 116 KB rows: 3,218
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-01-12 | SPY | ETF | 477.84 | 478.6 | 475.23 | 476.68 | 57944000.0 |
| 2024-01-12 | QQQ | ETF | 410.4 | 411.25 | 408.15 | 409.56 | 39594952.0 |
| 2024-01-12 | IWM | ETF | 195.89 | 197.1 | 192.64 | 193.23 | 42726100.0 |
| 2024-01-12 | DIA | ETF | 377.48 | 378.25 | 374.73 | 375.91 | 3816700.0 |
| 2024-01-12 | GLD | ETF | 190.67 | 191.08 | 189.16 | 189.71 | 6831400.0 |
| 2024-01-12 | TLT | ETF | 96.78 | 97.27 | 96.27 | 96.52 | 38867100.0 |
| 2024-01-12 | AAA | ETF | 25.03 | 25.13 | 25.03 | 25.085 | 14100.0 |
| 2024-01-12 | AAAU | ETF | 20.37 | 20.42 | 20.22 | 20.28 | 2559500.0 |
| 2024-01-12 | AADR | ETF | 55.35 | 55.35 | 55.35 | 55.35 | 300.0 |
| 2024-01-12 | AAPB | ETF | 21.41 | 21.6 | 21.32 | 21.46 | 24734.0 |
| 2024-01-12 | AAPD | ETF | 20.9 | 21.0 | 20.8511 | 20.93 | 178507.0 |
| 2024-01-12 | AAPU | ETF | 25.9 | 26.03 | 25.7501 | 25.88 | 91666.0 |
| 2024-01-12 | AAXJ | ETF | 64.9 | 64.98 | 64.44 | 64.54 | 1021200.0 |
| 2024-01-12 | ABCS | ETF | 25.0 | 25.0 | 24.8324 | 24.8324 | 15791.0 |
| 2024-01-12 | ABEQ | ETF | 28.63 | 28.68 | 28.519 | 28.521 | 3900.0 |
| 2024-01-12 | ACES | ETF | 32.07 | 32.39 | 31.19 | 31.27 | 91300.0 |
| 2024-01-12 | ACIO | ETF | 33.335 | 33.35 | 33.22 | 33.33 | 276300.0 |
| 2024-01-12 | ACSI | ETF | 49.167 | 49.167 | 49.167 | 49.167 | 100.0 |
| 2024-01-12 | ACT | ETF | 28.39 | 28.43 | 28.05 | 28.2 | 242368.0 |
| 2024-01-12 | ACTV | ETF | 32.74 | 32.836 | 32.43 | 32.504 | 9600.0 |
| 2024-01-12 | ACVF | ETF | 36.615 | 36.67 | 36.53 | 36.64 | 4400.0 |
| 2024-01-12 | ACWF | ETF | 38.2 | 38.28 | 38.0897 | 38.0897 | 10416.0 |
| 2024-01-12 | ACWI | ETF | 101.72 | 101.97 | 101.27 | 101.45 | 3336100.0 |
| 2024-01-12 | ACWV | ETF | 101.19 | 101.59 | 101.19 | 101.52 | 153700.0 |
| 2024-01-12 | ACWX | ETF | 50.65 | 50.77 | 50.39 | 50.43 | 1396500.0 |
| 2024-01-12 | ADFI | ETF | 8.6 | 8.6 | 8.583 | 8.595 | 5700.0 |
| 2024-01-12 | ADIV | ETF | 13.662 | 13.662 | 13.662 | 13.662 | 100.0 |
| 2024-01-12 | ADME | ETF | 38.52 | 38.63 | 38.49 | 38.627 | 11600.0 |
| 2024-01-12 | ADPV | ETF | 24.64 | 24.69 | 24.4795 | 24.4795 | 1628.0 |
| 2024-01-12 | AEMB | ETF | 37.973 | 37.98 | 37.895 | 37.895 | 3300.0 |
| 2024-01-12 | AESR | ETF | 13.87 | 13.93 | 13.82 | 13.84 | 18000.0 |
| 2024-01-12 | AETH | ETF | 37.78 | 37.78 | 35.3377 | 35.3377 | 34455.0 |
| 2024-01-12 | AFIF | ETF | 9.1 | 9.1 | 9.05 | 9.08 | 12400.0 |
| 2024-01-12 | AFK | ETF | 13.86 | 14.02 | 13.81 | 13.9 | 9800.0 |
| 2024-01-12 | AFLG | ETF | 27.441 | 27.441 | 27.441 | 27.441 | 100.0 |
| 2024-01-12 | AFTY | ETF | 12.865 | 12.865 | 12.865 | 12.865 | 100.0 |
| 2024-01-12 | AGG | ETF | 99.14 | 99.36 | 98.96 | 99.1 | 6359400.0 |
| 2024-01-12 | AGGH | ETF | 22.05 | 22.09 | 21.92 | 21.92 | 130876.0 |
| 2024-01-12 | AGGY | ETF | 43.94 | 44.04 | 43.88 | 43.93 | 375600.0 |
| 2024-01-12 | AGNG | ETF | 28.97 | 28.97 | 28.84 | 28.87 | 4500.0 |
| 2024-01-12 | AGOX | ETF | 23.9 | 24.16 | 23.89 | 24.05 | 18500.0 |
| 2024-01-12 | AGQ | ETF | 26.05 | 26.4 | 25.36 | 25.55 | 1938000.0 |
| 2024-01-12 | AGQI | ETF | 13.28 | 13.28 | 13.23 | 13.26 | 9914.0 |
| 2024-01-12 | AGZ | ETF | 108.58 | 108.75 | 108.58 | 108.64 | 33300.0 |
| 2024-01-12 | AGZD | ETF | 21.9 | 21.99 | 21.86 | 21.88 | 134100.0 |
| 2024-01-12 | AHLT | ETF | 22.08 | 22.08 | 22.04 | 22.0537 | 13409.0 |
| 2024-01-12 | AHYB | ETF | 45.536 | 45.59 | 45.536 | 45.55 | 2900.0 |
| 2024-01-12 | AIA | ETF | 55.25 | 55.56 | 55.01 | 55.11 | 48600.0 |
| 2024-01-12 | AIEQ | ETF | 35.14 | 35.273 | 34.84 | 34.92 | 10300.0 |
| 2024-01-12 | AIQ | ETF | 30.92 | 31.04 | 30.8 | 30.87 | 351200.0 |
> showing 50 of 3,218 rows — these rows as CSV