PREVIEW / etf_daily / 2024-01-31
file: by_date/etf_daily/2024/2024-01-31.parquet size: 118 KB rows: 3,272
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-31 | SPY | ETF | 488.62 | 489.08 | 482.86 | 482.88 | 126011100.0 |
| 2024-01-31 | QQQ | ETF | 420.85 | 422.8699 | 416.79 | 416.97 | 64010649.0 |
| 2024-01-31 | IWM | ETF | 197.21 | 198.94 | 192.71 | 192.88 | 68126700.0 |
| 2024-01-31 | DIA | ETF | 385.21 | 385.82 | 381.34 | 381.37 | 4476600.0 |
| 2024-01-31 | GLD | ETF | 189.37 | 190.46 | 188.13 | 188.45 | 7886100.0 |
| 2024-01-31 | TLT | ETF | 96.22 | 96.91 | 96.0 | 96.66 | 80646700.0 |
| 2024-01-31 | AAA | ETF | 25.065 | 25.12 | 25.0 | 25.065 | 3500.0 |
| 2024-01-31 | AAAU | ETF | 20.24 | 20.36 | 20.11 | 20.15 | 2043600.0 |
| 2024-01-31 | AADR | ETF | 55.97 | 55.97 | 55.97 | 55.97 | 100.0 |
| 2024-01-31 | AAPB | ETF | 21.35 | 21.35 | 20.82 | 20.82 | 67618.0 |
| 2024-01-31 | AAPD | ETF | 20.83 | 21.11 | 20.83 | 21.11 | 288980.0 |
| 2024-01-31 | AAPU | ETF | 25.9 | 25.99 | 25.45 | 25.45 | 168203.0 |
| 2024-01-31 | AAPX | ETF | 24.96 | 24.96 | 24.43 | 24.4955 | 15785.0 |
| 2024-01-31 | AAPY | ETF | 25.63 | 25.78 | 25.5618 | 25.5618 | 434.0 |
| 2024-01-31 | AAXJ | ETF | 63.12 | 63.63 | 62.92 | 63.05 | 995600.0 |
| 2024-01-31 | ABCS | ETF | 25.22 | 25.34 | 24.87 | 24.8744 | 1413.0 |
| 2024-01-31 | ABEQ | ETF | 28.82 | 28.82 | 28.525 | 28.525 | 14700.0 |
| 2024-01-31 | ACES | ETF | 30.34 | 31.44 | 29.98 | 30.05 | 271700.0 |
| 2024-01-31 | ACIO | ETF | 33.94 | 34.05 | 33.72 | 33.72 | 114400.0 |
| 2024-01-31 | ACSI | ETF | 49.247 | 49.247 | 49.247 | 49.247 | 100.0 |
| 2024-01-31 | ACT | ETF | 29.07 | 29.07 | 28.4 | 28.49 | 325897.0 |
| 2024-01-31 | ACTV | ETF | 33.0 | 33.221 | 32.562 | 32.562 | 7200.0 |
| 2024-01-31 | ACVF | ETF | 37.66 | 37.66 | 37.293 | 37.293 | 5700.0 |
| 2024-01-31 | ACWF | ETF | 38.86 | 38.86 | 38.517 | 38.517 | 6820.0 |
| 2024-01-31 | ACWI | ETF | 103.1 | 103.31 | 102.03 | 102.05 | 7041000.0 |
| 2024-01-31 | ACWV | ETF | 102.2 | 102.28 | 101.4 | 101.46 | 124600.0 |
| 2024-01-31 | ACWX | ETF | 50.55 | 50.72 | 50.07 | 50.16 | 2178200.0 |
| 2024-01-31 | ADFI | ETF | 8.61 | 8.61 | 8.56 | 8.57 | 24000.0 |
| 2024-01-31 | ADIV | ETF | 13.681 | 13.681 | 13.62 | 13.62 | 600.0 |
| 2024-01-31 | ADME | ETF | 39.401 | 39.46 | 39.09 | 39.13 | 6100.0 |
| 2024-01-31 | ADPV | ETF | 25.21 | 25.21 | 24.8999 | 24.8999 | 2598.0 |
| 2024-01-31 | AEMB | ETF | 37.973 | 37.973 | 37.807 | 37.807 | 500.0 |
| 2024-01-31 | AESR | ETF | 14.37 | 14.37 | 14.18 | 14.18 | 29300.0 |
| 2024-01-31 | AETH | ETF | 32.1 | 32.1 | 31.388 | 31.388 | 2719.0 |
| 2024-01-31 | AFIF | ETF | 9.12 | 9.12 | 9.03 | 9.11 | 4800.0 |
| 2024-01-31 | AFK | ETF | 13.61 | 13.67 | 13.23 | 13.36 | 10300.0 |
| 2024-01-31 | AFLG | ETF | 27.98 | 27.98 | 27.904 | 27.904 | 400.0 |
| 2024-01-31 | AFMC | ETF | 26.741 | 26.741 | 26.741 | 26.741 | 500.0 |
| 2024-01-31 | AFSM | ETF | 26.948 | 26.948 | 26.948 | 26.948 | 100.0 |
| 2024-01-31 | AFTY | ETF | 12.83 | 12.95 | 12.83 | 12.904 | 1000.0 |
| 2024-01-31 | AGG | ETF | 99.0 | 99.26 | 98.81 | 99.1 | 10829000.0 |
| 2024-01-31 | AGGH | ETF | 21.76 | 21.83 | 21.74 | 21.83 | 61006.0 |
| 2024-01-31 | AGGY | ETF | 43.74 | 43.87 | 43.681 | 43.77 | 118200.0 |
| 2024-01-31 | AGNG | ETF | 28.47 | 28.471 | 28.27 | 28.27 | 3500.0 |
| 2024-01-31 | AGOX | ETF | 24.2 | 24.31 | 23.97 | 24.13 | 28400.0 |
| 2024-01-31 | AGQ | ETF | 25.48 | 25.8 | 24.62 | 24.75 | 1440300.0 |
| 2024-01-31 | AGQI | ETF | 13.59 | 13.59 | 13.42 | 13.42 | 57849.0 |
| 2024-01-31 | AGZ | ETF | 108.58 | 108.79 | 108.46 | 108.59 | 45100.0 |
| 2024-01-31 | AGZD | ETF | 21.92 | 21.97 | 21.89 | 21.93 | 15300.0 |
| 2024-01-31 | AHLT | ETF | 22.1399 | 22.1399 | 22.0757 | 22.0757 | 3159.0 |
> showing 50 of 3,272 rows — these rows as CSV