PREVIEW / etf_daily / 2024-04-15
file: by_date/etf_daily/2024/2024-04-15.parquet size: 120 KB rows: 3,361
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-04-15 | SPY | ETF | 515.13 | 515.3 | 503.58 | 504.45 | 92101400.0 |
| 2024-04-15 | QQQ | ETF | 442.06 | 442.15 | 430.21 | 431.06 | 63453622.0 |
| 2024-04-15 | IWM | ETF | 199.37 | 200.23 | 194.98 | 195.78 | 41119300.0 |
| 2024-04-15 | DIA | ETF | 383.33 | 383.82 | 376.6 | 377.31 | 4870700.0 |
| 2024-04-15 | GLD | ETF | 217.94 | 221.03 | 215.16 | 220.95 | 13239000.0 |
| 2024-04-15 | TLT | ETF | 89.22 | 89.26 | 88.52 | 88.89 | 55993100.0 |
| 2024-04-15 | AAA | ETF | 25.07 | 25.15 | 25.07 | 25.115 | 31000.0 |
| 2024-04-15 | AAAU | ETF | 23.31 | 23.64 | 23.01 | 23.63 | 5667300.0 |
| 2024-04-15 | AADR | ETF | 60.46 | 60.61 | 60.04 | 60.04 | 3600.0 |
| 2024-04-15 | AAPB | ETF | 18.22 | 18.47 | 17.63 | 17.65 | 189759.0 |
| 2024-04-15 | AAPD | ETF | 22.21 | 22.555 | 22.0676 | 22.52 | 218402.0 |
| 2024-04-15 | AAPR | ETF | 24.56 | 24.585 | 24.42 | 24.42 | 34635.0 |
| 2024-04-15 | AAPU | ETF | 23.47 | 23.76 | 22.7 | 22.75 | 675203.0 |
| 2024-04-15 | AAPX | ETF | 21.33 | 21.39 | 20.59 | 20.59 | 65689.0 |
| 2024-04-15 | AAPY | ETF | 23.96 | 24.03 | 23.8099 | 23.8099 | 1187.0 |
| 2024-04-15 | AAXJ | ETF | 67.16 | 67.18 | 66.24 | 66.37 | 661900.0 |
| 2024-04-15 | ABCS | ETF | 26.0654 | 26.12 | 25.6094 | 25.6094 | 2300.0 |
| 2024-04-15 | ABEQ | ETF | 29.44 | 29.44 | 29.28 | 29.355 | 2800.0 |
| 2024-04-15 | ACES | ETF | 27.67 | 27.67 | 26.47 | 26.62 | 84300.0 |
| 2024-04-15 | ACIO | ETF | 35.66 | 35.66 | 35.15 | 35.15 | 137500.0 |
| 2024-04-15 | ACSI | ETF | 49.793 | 49.793 | 49.793 | 49.793 | 100.0 |
| 2024-04-15 | ACT | ETF | 29.75 | 29.96 | 29.31 | 29.43 | 136048.0 |
| 2024-04-15 | ACTV | ETF | 33.26 | 33.26 | 32.58 | 32.679 | 7700.0 |
| 2024-04-15 | ACVF | ETF | 39.36 | 39.36 | 38.55 | 38.56 | 9800.0 |
| 2024-04-15 | ACWF | ETF | 40.8 | 40.8 | 40.068 | 40.068 | 5224.0 |
| 2024-04-15 | ACWI | ETF | 108.26 | 108.29 | 106.08 | 106.29 | 5107700.0 |
| 2024-04-15 | ACWV | ETF | 102.41 | 102.59 | 101.41 | 101.52 | 99300.0 |
| 2024-04-15 | ACWX | ETF | 52.51 | 52.51 | 51.63 | 51.72 | 2266400.0 |
| 2024-04-15 | ADFI | ETF | 8.36 | 8.37 | 8.35 | 8.35 | 19100.0 |
| 2024-04-15 | ADIV | ETF | 13.56 | 13.56 | 13.56 | 13.56 | 100.0 |
| 2024-04-15 | ADME | ETF | 41.47 | 41.47 | 40.72 | 40.765 | 13000.0 |
| 2024-04-15 | ADPV | ETF | 29.59 | 29.59 | 28.45 | 28.54 | 6278.0 |
| 2024-04-15 | AEMB | ETF | 37.84 | 37.84 | 37.715 | 37.715 | 4100.0 |
| 2024-04-15 | AESR | ETF | 15.21 | 15.21 | 14.93 | 14.95 | 51300.0 |
| 2024-04-15 | AETH | ETF | 42.8599 | 42.8599 | 41.0401 | 41.1249 | 6131.0 |
| 2024-04-15 | AFIF | ETF | 9.09 | 9.12 | 9.09 | 9.09 | 30000.0 |
| 2024-04-15 | AFK | ETF | 15.22 | 15.42 | 15.0 | 15.09 | 13600.0 |
| 2024-04-15 | AFLG | ETF | 29.698 | 29.698 | 29.698 | 29.698 | 500.0 |
| 2024-04-15 | AFMC | ETF | 28.52 | 28.67 | 28.345 | 28.345 | 2900.0 |
| 2024-04-15 | AFSM | ETF | 27.65 | 27.74 | 27.497 | 27.497 | 1200.0 |
| 2024-04-15 | AFTY | ETF | 13.99 | 14.03 | 13.99 | 14.02 | 600.0 |
| 2024-04-15 | AGG | ETF | 95.47 | 95.53 | 95.21 | 95.38 | 11705300.0 |
| 2024-04-15 | AGGH | ETF | 20.7 | 20.7 | 20.41 | 20.5001 | 112671.0 |
| 2024-04-15 | AGGY | ETF | 42.45 | 42.45 | 42.3 | 42.35 | 112600.0 |
| 2024-04-15 | AGNG | ETF | 28.75 | 28.89 | 28.47 | 28.49 | 5700.0 |
| 2024-04-15 | AGOX | ETF | 24.69 | 24.69 | 24.34 | 24.45 | 17700.0 |
| 2024-04-15 | AGQ | ETF | 37.92 | 38.47 | 36.4 | 38.39 | 2117800.0 |
| 2024-04-15 | AGQI | ETF | 13.76 | 13.76 | 13.54 | 13.5803 | 12745.0 |
| 2024-04-15 | AGZ | ETF | 106.57 | 106.8 | 106.57 | 106.62 | 21500.0 |
| 2024-04-15 | AGZD | ETF | 22.24 | 22.24 | 22.1 | 22.17 | 128300.0 |
> showing 50 of 3,361 rows — these rows as CSV