PREVIEW / etf_daily / 2024-05-23
file: by_date/etf_daily/2024/2024-05-23.parquet size: 120 KB rows: 3,356
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-23 | SPY | ETF | 532.96 | 533.07 | 524.72 | 525.96 | 57211200.0 |
| 2024-05-23 | QQQ | ETF | 460.55 | 460.58 | 451.8503 | 453.66 | 40899230.0 |
| 2024-05-23 | IWM | ETF | 207.51 | 207.62 | 202.35 | 203.19 | 34039800.0 |
| 2024-05-23 | DIA | ETF | 397.06 | 397.09 | 390.25 | 390.66 | 3361200.0 |
| 2024-05-23 | GLD | ETF | 218.78 | 219.23 | 215.66 | 215.72 | 9537900.0 |
| 2024-05-23 | TLT | ETF | 91.8 | 91.8 | 90.82 | 91.11 | 51294700.0 |
| 2024-05-23 | AAA | ETF | 25.165 | 25.18 | 25.146 | 25.146 | 13800.0 |
| 2024-05-23 | AAAU | ETF | 23.4 | 23.45 | 23.07 | 23.08 | 3770300.0 |
| 2024-05-23 | AADR | ETF | 63.72 | 63.99 | 63.26 | 63.26 | 300.0 |
| 2024-05-23 | AAPB | ETF | 21.28 | 21.28 | 20.29 | 20.33 | 79469.0 |
| 2024-05-23 | AAPD | ETF | 20.36 | 20.83 | 20.36 | 20.82 | 134522.0 |
| 2024-05-23 | AAPR | ETF | 24.9 | 24.91 | 24.7697 | 24.84 | 52430.0 |
| 2024-05-23 | AAPU | ETF | 27.4 | 27.4 | 26.18 | 26.26 | 448405.0 |
| 2024-05-23 | AAPX | ETF | 24.86 | 24.86 | 23.65 | 23.65 | 19900.0 |
| 2024-05-23 | AAPY | ETF | 25.15 | 25.155 | 25.018 | 25.018 | 946.0 |
| 2024-05-23 | AAXJ | ETF | 72.82 | 72.88 | 71.82 | 72.0 | 310300.0 |
| 2024-05-23 | ABCS | ETF | 26.4771 | 26.48 | 26.23 | 26.27 | 2103.0 |
| 2024-05-23 | ABEQ | ETF | 30.438 | 30.438 | 30.263 | 30.263 | 3300.0 |
| 2024-05-23 | ACES | ETF | 31.06 | 31.06 | 29.92 | 30.15 | 875900.0 |
| 2024-05-23 | ACIO | ETF | 36.73 | 36.74 | 36.34 | 36.4 | 152200.0 |
| 2024-05-23 | ACSI | ETF | 53.077 | 53.077 | 53.077 | 53.077 | 100.0 |
| 2024-05-23 | ACT | ETF | 31.36 | 31.38 | 30.59 | 30.66 | 187573.0 |
| 2024-05-23 | ACTV | ETF | 33.71 | 33.71 | 32.98 | 33.109 | 7800.0 |
| 2024-05-23 | ACVF | ETF | 40.277 | 40.39 | 39.84 | 39.855 | 25500.0 |
| 2024-05-23 | ACWF | ETF | 42.455 | 42.455 | 41.91 | 41.91 | 1544.0 |
| 2024-05-23 | ACWI | ETF | 112.49 | 112.49 | 110.74 | 110.98 | 1731900.0 |
| 2024-05-23 | ACWV | ETF | 105.64 | 105.64 | 104.58 | 104.64 | 152300.0 |
| 2024-05-23 | ACWX | ETF | 54.96 | 55.0 | 54.08 | 54.2 | 686300.0 |
| 2024-05-23 | ADFI | ETF | 8.42 | 8.44 | 8.4 | 8.439 | 31700.0 |
| 2024-05-23 | ADIV | ETF | 14.74 | 14.74 | 14.74 | 14.74 | 100.0 |
| 2024-05-23 | ADME | ETF | 42.54 | 42.54 | 42.05 | 42.132 | 7000.0 |
| 2024-05-23 | ADPV | ETF | 31.4521 | 31.4521 | 30.845 | 30.8462 | 8013.0 |
| 2024-05-23 | AEMB | ETF | 38.46 | 38.46 | 38.4 | 38.4 | 1300.0 |
| 2024-05-23 | AESR | ETF | 15.8 | 15.84 | 15.62 | 15.66 | 46300.0 |
| 2024-05-23 | AETH | ETF | 50.84 | 50.84 | 48.855 | 49.828 | 44465.0 |
| 2024-05-23 | AFIF | ETF | 9.1 | 9.1 | 9.09 | 9.1 | 4700.0 |
| 2024-05-23 | AFK | ETF | 15.94 | 15.94 | 15.55 | 15.55 | 11000.0 |
| 2024-05-23 | AFLG | ETF | 30.801 | 30.808 | 30.801 | 30.808 | 200.0 |
| 2024-05-23 | AFMC | ETF | 29.88 | 29.88 | 29.596 | 29.596 | 600.0 |
| 2024-05-23 | AFSM | ETF | 28.726 | 28.726 | 28.726 | 28.726 | 100.0 |
| 2024-05-23 | AFTY | ETF | 14.57 | 14.6 | 14.57 | 14.6 | 800.0 |
| 2024-05-23 | AGG | ETF | 96.83 | 96.83 | 96.37 | 96.47 | 5094900.0 |
| 2024-05-23 | AGGH | ETF | 21.03 | 21.03 | 20.8395 | 20.96 | 110271.0 |
| 2024-05-23 | AGGS | ETF | 40.605 | 40.605 | 40.5982 | 40.5982 | 100.0 |
| 2024-05-23 | AGGY | ETF | 42.96 | 42.98 | 42.81 | 42.84 | 96000.0 |
| 2024-05-23 | AGMI | ETF | 28.0711 | 28.0711 | 27.686 | 27.686 | 274.0 |
| 2024-05-23 | AGNG | ETF | 30.11 | 30.11 | 29.62 | 29.62 | 4000.0 |
| 2024-05-23 | AGOX | ETF | 26.29 | 26.49 | 25.772 | 26.13 | 17300.0 |
| 2024-05-23 | AGQ | ETF | 42.75 | 43.25 | 40.75 | 40.98 | 2115800.0 |
| 2024-05-23 | AGQI | ETF | 14.43 | 14.43 | 14.25 | 14.271 | 34184.0 |
> showing 50 of 3,356 rows — these rows as CSV