PREVIEW / etf_daily / 2024-05-14
file: by_date/etf_daily/2024/2024-05-14.parquet size: 120 KB rows: 3,343
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-05-14 | SPY | ETF | 521.11 | 523.83 | 520.56 | 523.3 | 57535900.0 |
| 2024-05-14 | QQQ | ETF | 442.65 | 446.465 | 442.46 | 445.93 | 34478321.0 |
| 2024-05-14 | IWM | ETF | 207.13 | 207.74 | 205.91 | 206.86 | 33169000.0 |
| 2024-05-14 | DIA | ETF | 394.54 | 396.25 | 393.81 | 395.58 | 2702700.0 |
| 2024-05-14 | GLD | ETF | 217.31 | 218.38 | 216.98 | 218.09 | 4662700.0 |
| 2024-05-14 | TLT | ETF | 90.65 | 90.92 | 90.42 | 90.86 | 25746400.0 |
| 2024-05-14 | AAA | ETF | 25.06 | 25.13 | 25.06 | 25.085 | 1800.0 |
| 2024-05-14 | AAAU | ETF | 23.25 | 23.36 | 23.21 | 23.33 | 2173600.0 |
| 2024-05-14 | AADR | ETF | 64.31 | 64.77 | 64.31 | 64.77 | 300.0 |
| 2024-05-14 | AAPB | ETF | 20.61 | 20.73 | 20.3298 | 20.55 | 111905.0 |
| 2024-05-14 | AAPD | ETF | 20.68 | 20.845 | 20.64 | 20.72 | 167550.0 |
| 2024-05-14 | AAPR | ETF | 24.74 | 24.78 | 24.7 | 24.75 | 58717.0 |
| 2024-05-14 | AAPU | ETF | 26.55 | 26.702 | 26.1804 | 26.47 | 628852.0 |
| 2024-05-14 | AAPX | ETF | 23.88 | 24.13 | 23.691 | 23.9826 | 13578.0 |
| 2024-05-14 | AAPY | ETF | 25.15 | 25.23 | 25.15 | 25.2019 | 487.0 |
| 2024-05-14 | AAXJ | ETF | 71.6 | 72.06 | 71.6 | 72.01 | 353800.0 |
| 2024-05-14 | ABCS | ETF | 26.755 | 26.83 | 26.6734 | 26.779 | 2100.0 |
| 2024-05-14 | ABEQ | ETF | 30.73 | 30.759 | 30.63 | 30.759 | 3900.0 |
| 2024-05-14 | ACES | ETF | 30.2 | 30.511 | 29.75 | 29.95 | 668700.0 |
| 2024-05-14 | ACIO | ETF | 36.061 | 36.22 | 36.0 | 36.19 | 102600.0 |
| 2024-05-14 | ACSI | ETF | 53.564 | 53.564 | 53.564 | 53.564 | 100.0 |
| 2024-05-14 | ACT | ETF | 31.6 | 31.61 | 31.32 | 31.54 | 160317.0 |
| 2024-05-14 | ACTV | ETF | 33.76 | 34.05 | 33.76 | 33.97 | 9500.0 |
| 2024-05-14 | ACVF | ETF | 39.6 | 39.746 | 39.55 | 39.746 | 3500.0 |
| 2024-05-14 | ACWF | ETF | 41.6 | 41.79 | 41.59 | 41.7825 | 4128.0 |
| 2024-05-14 | ACWI | ETF | 110.37 | 110.92 | 110.35 | 110.86 | 1106900.0 |
| 2024-05-14 | ACWV | ETF | 105.35 | 105.35 | 104.71 | 105.08 | 120300.0 |
| 2024-05-14 | ACWX | ETF | 54.36 | 54.52 | 54.29 | 54.48 | 300000.0 |
| 2024-05-14 | ADFI | ETF | 8.431 | 8.49 | 8.431 | 8.49 | 29700.0 |
| 2024-05-14 | ADIV | ETF | 14.77 | 14.77 | 14.77 | 14.77 | 200.0 |
| 2024-05-14 | ADME | ETF | 41.785 | 41.92 | 41.67 | 41.893 | 6700.0 |
| 2024-05-14 | ADPV | ETF | 30.56 | 30.96 | 30.56 | 30.9562 | 14724.0 |
| 2024-05-14 | AEMB | ETF | 38.445 | 38.445 | 38.445 | 38.445 | 100.0 |
| 2024-05-14 | AESR | ETF | 15.425 | 15.54 | 15.35 | 15.54 | 42400.0 |
| 2024-05-14 | AETH | ETF | 38.26 | 38.26 | 37.9 | 37.9907 | 3253.0 |
| 2024-05-14 | AFIF | ETF | 9.12 | 9.13 | 9.11 | 9.12 | 15100.0 |
| 2024-05-14 | AFK | ETF | 15.62 | 15.75 | 15.6 | 15.69 | 4900.0 |
| 2024-05-14 | AFLG | ETF | 30.763 | 30.763 | 30.763 | 30.763 | 100.0 |
| 2024-05-14 | AFMC | ETF | 30.13 | 30.15 | 29.99 | 30.15 | 700.0 |
| 2024-05-14 | AFSM | ETF | 29.09 | 29.14 | 29.0 | 29.123 | 1500.0 |
| 2024-05-14 | AFTY | ETF | 14.55 | 14.559 | 14.55 | 14.559 | 300.0 |
| 2024-05-14 | AGG | ETF | 96.5 | 96.64 | 96.42 | 96.55 | 5243300.0 |
| 2024-05-14 | AGGH | ETF | 20.89 | 20.9299 | 20.86 | 20.92 | 43023.0 |
| 2024-05-14 | AGGY | ETF | 42.81 | 42.86 | 42.78 | 42.839 | 69800.0 |
| 2024-05-14 | AGMI | ETF | 27.147 | 27.2095 | 27.0 | 27.2095 | 301.0 |
| 2024-05-14 | AGNG | ETF | 29.763 | 29.86 | 29.67 | 29.86 | 2700.0 |
| 2024-05-14 | AGOX | ETF | 24.73 | 25.33 | 24.73 | 25.15 | 13600.0 |
| 2024-05-14 | AGQ | ETF | 36.8 | 37.56 | 36.44 | 37.21 | 916400.0 |
| 2024-05-14 | AGQI | ETF | 14.23 | 14.33 | 14.23 | 14.32 | 27162.0 |
| 2024-05-14 | AGZ | ETF | 107.23 | 107.27 | 107.12 | 107.12 | 17900.0 |
> showing 50 of 3,343 rows — these rows as CSV