PREVIEW / etf_daily / 2024-01-19
file: by_date/etf_daily/2024/2024-01-19.parquet size: 116 KB rows: 3,229
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-19 | SPY | ETF | 477.65 | 482.72 | 476.54 | 482.43 | 110733300.0 |
| 2024-01-19 | QQQ | ETF | 415.22 | 421.34 | 414.625 | 421.18 | 70325123.0 |
| 2024-01-19 | IWM | ETF | 191.29 | 192.85 | 189.23 | 192.43 | 63291200.0 |
| 2024-01-19 | DIA | ETF | 375.78 | 379.37 | 374.46 | 378.6 | 5217800.0 |
| 2024-01-19 | GLD | ETF | 188.26 | 188.3 | 187.44 | 187.93 | 5719100.0 |
| 2024-01-19 | TLT | ETF | 93.71 | 94.17 | 93.26 | 94.09 | 47020300.0 |
| 2024-01-19 | AAA | ETF | 25.11 | 25.159 | 25.07 | 25.12 | 3100.0 |
| 2024-01-19 | AAAU | ETF | 20.13 | 20.13 | 20.04 | 20.09 | 2129500.0 |
| 2024-01-19 | AADR | ETF | 53.88 | 54.69 | 53.88 | 54.69 | 600.0 |
| 2024-01-19 | AAPB | ETF | 22.13 | 22.6 | 22.0 | 22.56 | 43061.0 |
| 2024-01-19 | AAPD | ETF | 20.53 | 20.59 | 20.26 | 20.29 | 262463.0 |
| 2024-01-19 | AAPU | ETF | 26.55 | 27.11 | 26.46 | 27.02 | 133987.0 |
| 2024-01-19 | AAPX | ETF | 25.81 | 26.3516 | 25.68 | 26.3516 | 1270.0 |
| 2024-01-19 | AAPY | ETF | 26.35 | 26.68 | 26.35 | 26.6248 | 1237.0 |
| 2024-01-19 | AAXJ | ETF | 62.7 | 63.24 | 62.38 | 63.17 | 646400.0 |
| 2024-01-19 | ABCS | ETF | 24.55 | 24.81 | 24.55 | 24.7701 | 1473.0 |
| 2024-01-19 | ABEQ | ETF | 28.238 | 28.41 | 28.238 | 28.311 | 13100.0 |
| 2024-01-19 | ACES | ETF | 29.2 | 29.2 | 28.38 | 29.14 | 119900.0 |
| 2024-01-19 | ACIO | ETF | 33.45 | 33.66 | 33.367 | 33.6 | 74300.0 |
| 2024-01-19 | ACSI | ETF | 49.401 | 49.401 | 49.401 | 49.401 | 100.0 |
| 2024-01-19 | ACT | ETF | 28.13 | 28.16 | 27.83 | 28.06 | 377236.0 |
| 2024-01-19 | ACTV | ETF | 32.05 | 32.413 | 32.02 | 32.33 | 4600.0 |
| 2024-01-19 | ACVF | ETF | 36.71 | 37.13 | 36.71 | 37.13 | 11800.0 |
| 2024-01-19 | ACWF | ETF | 37.84 | 38.19 | 37.74 | 38.1438 | 14041.0 |
| 2024-01-19 | ACWI | ETF | 100.81 | 101.69 | 100.56 | 101.67 | 3887700.0 |
| 2024-01-19 | ACWV | ETF | 100.86 | 101.22 | 100.55 | 101.05 | 219800.0 |
| 2024-01-19 | ACWX | ETF | 49.32 | 49.67 | 49.18 | 49.65 | 1821100.0 |
| 2024-01-19 | ADFI | ETF | 8.51 | 8.56 | 8.5 | 8.54 | 33200.0 |
| 2024-01-19 | ADIV | ETF | 13.515 | 13.515 | 13.515 | 13.515 | 100.0 |
| 2024-01-19 | ADME | ETF | 38.63 | 39.02 | 38.63 | 38.99 | 8300.0 |
| 2024-01-19 | ADPV | ETF | 24.585 | 24.9574 | 24.585 | 24.9574 | 2032.0 |
| 2024-01-19 | AEMB | ETF | 37.504 | 37.504 | 37.504 | 37.504 | 200.0 |
| 2024-01-19 | AESR | ETF | 14.01 | 14.16 | 14.01 | 14.11 | 29000.0 |
| 2024-01-19 | AETH | ETF | 34.78 | 34.78 | 33.35 | 34.2989 | 8191.0 |
| 2024-01-19 | AFIF | ETF | 9.09 | 9.09 | 9.05 | 9.07 | 26400.0 |
| 2024-01-19 | AFK | ETF | 13.59 | 13.71 | 13.5 | 13.68 | 5800.0 |
| 2024-01-19 | AFLG | ETF | 27.761 | 27.761 | 27.761 | 27.761 | 100.0 |
| 2024-01-19 | AFMC | ETF | 26.635 | 26.635 | 26.635 | 26.635 | 100.0 |
| 2024-01-19 | AFSM | ETF | 26.8 | 26.8 | 26.534 | 26.764 | 1200.0 |
| 2024-01-19 | AFTY | ETF | 12.78 | 12.92 | 12.78 | 12.92 | 300.0 |
| 2024-01-19 | AGG | ETF | 97.89 | 98.02 | 97.67 | 98.02 | 9126000.0 |
| 2024-01-19 | AGGH | ETF | 21.87 | 21.87 | 21.6227 | 21.71 | 56119.0 |
| 2024-01-19 | AGGY | ETF | 43.49 | 43.51 | 43.375 | 43.5 | 140500.0 |
| 2024-01-19 | AGNG | ETF | 28.24 | 28.31 | 28.02 | 28.31 | 3200.0 |
| 2024-01-19 | AGOX | ETF | 24.17 | 24.25 | 23.97 | 24.134 | 46300.0 |
| 2024-01-19 | AGQ | ETF | 24.47 | 24.47 | 23.99 | 24.25 | 1520500.0 |
| 2024-01-19 | AGQI | ETF | 13.17 | 13.24 | 13.131 | 13.2399 | 36503.0 |
| 2024-01-19 | AGZ | ETF | 107.98 | 108.05 | 107.95 | 108.02 | 24900.0 |
| 2024-01-19 | AGZD | ETF | 21.92 | 21.99 | 21.88 | 21.99 | 15000.0 |
| 2024-01-19 | AHLT | ETF | 21.92 | 22.12 | 21.92 | 22.09 | 5928.0 |
> showing 50 of 3,229 rows — these rows as CSV