PREVIEW / etf_daily / 2024-06-18
file: by_date/etf_daily/2024/2024-06-18.parquet size: 122 KB rows: 3,421
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-06-18 | SPY | ETF | 547.16 | 548.62 | 546.73 | 548.49 | 41376400.0 |
| 2024-06-18 | QQQ | ETF | 485.01 | 485.9 | 483.43 | 485.21 | 24438565.0 |
| 2024-06-18 | IWM | ETF | 200.46 | 201.69 | 200.03 | 200.75 | 25446900.0 |
| 2024-06-18 | DIA | ETF | 388.91 | 390.19 | 388.02 | 389.14 | 1848700.0 |
| 2024-06-18 | GLD | ETF | 214.38 | 215.83 | 214.04 | 215.47 | 4921400.0 |
| 2024-06-18 | TLT | ETF | 93.89 | 94.6 | 93.73 | 94.59 | 26881000.0 |
| 2024-06-18 | AAA | ETF | 25.13 | 25.21 | 25.1 | 25.155 | 5300.0 |
| 2024-06-18 | AAAU | ETF | 22.94 | 23.09 | 22.9 | 23.06 | 1304600.0 |
| 2024-06-18 | AADR | ETF | 62.86 | 62.86 | 62.86 | 62.86 | 200.0 |
| 2024-06-18 | AAPB | ETF | 27.2 | 27.409 | 26.05 | 26.37 | 299828.0 |
| 2024-06-18 | AAPD | ETF | 17.84 | 18.215 | 17.755 | 18.1 | 343602.0 |
| 2024-06-18 | AAPR | ETF | 25.27 | 25.27 | 25.2209 | 25.2572 | 7296.0 |
| 2024-06-18 | AAPU | ETF | 35.14 | 35.43 | 33.62 | 34.07 | 1696487.0 |
| 2024-06-18 | AAPX | ETF | 31.74 | 31.9231 | 30.35 | 30.71 | 69196.0 |
| 2024-06-18 | AAPY | ETF | 26.42 | 26.65 | 26.42 | 26.5727 | 1407.0 |
| 2024-06-18 | AAXJ | ETF | 72.28 | 72.79 | 72.24 | 72.68 | 180600.0 |
| 2024-06-18 | ABCS | ETF | 26.15 | 26.15 | 26.03 | 26.04 | 1443.0 |
| 2024-06-18 | ABEQ | ETF | 30.09 | 30.09 | 29.97 | 30.059 | 4600.0 |
| 2024-06-18 | ACES | ETF | 29.31 | 29.595 | 29.3 | 29.44 | 298300.0 |
| 2024-06-18 | ACIO | ETF | 37.63 | 37.7 | 37.595 | 37.66 | 114100.0 |
| 2024-06-18 | ACSI | ETF | 54.94 | 54.973 | 54.94 | 54.973 | 2100.0 |
| 2024-06-18 | ACT | ETF | 29.91 | 30.12 | 29.74 | 30.11 | 153583.0 |
| 2024-06-18 | ACTV | ETF | 31.78 | 31.86 | 31.72 | 31.78 | 11400.0 |
| 2024-06-18 | ACVF | ETF | 41.47 | 41.74 | 41.47 | 41.667 | 10300.0 |
| 2024-06-18 | ACWF | ETF | 42.49 | 42.55 | 42.4691 | 42.5042 | 7403.0 |
| 2024-06-18 | ACWI | ETF | 112.37 | 112.83 | 112.37 | 112.83 | 2895100.0 |
| 2024-06-18 | ACWV | ETF | 104.1 | 104.47 | 104.1 | 104.44 | 145300.0 |
| 2024-06-18 | ACWX | ETF | 52.95 | 53.28 | 52.92 | 53.2 | 2674900.0 |
| 2024-06-18 | ADFI | ETF | 8.505 | 8.57 | 8.481 | 8.56 | 18200.0 |
| 2024-06-18 | ADIV | ETF | 14.9 | 14.965 | 14.9 | 14.965 | 400.0 |
| 2024-06-18 | ADME | ETF | 43.84 | 43.85 | 43.74 | 43.839 | 25800.0 |
| 2024-06-18 | ADPV | ETF | 30.0054 | 30.239 | 29.98 | 30.1998 | 7654.0 |
| 2024-06-18 | AEMB | ETF | 38.655 | 38.655 | 38.655 | 38.655 | 100.0 |
| 2024-06-18 | AESR | ETF | 16.46 | 16.51 | 16.45 | 16.494 | 17300.0 |
| 2024-06-18 | AETH | ETF | 44.1701 | 44.81 | 44.1 | 44.482 | 4174.0 |
| 2024-06-18 | AFIF | ETF | 9.12 | 9.12 | 9.1 | 9.11 | 10500.0 |
| 2024-06-18 | AFK | ETF | 15.79 | 15.91 | 15.33 | 15.85 | 32400.0 |
| 2024-06-18 | AFLG | ETF | 31.87 | 31.925 | 31.841 | 31.918 | 1300.0 |
| 2024-06-18 | AFMC | ETF | 29.08 | 29.39 | 29.08 | 29.357 | 500.0 |
| 2024-06-18 | AFSM | ETF | 28.086 | 28.086 | 28.086 | 28.086 | 100.0 |
| 2024-06-18 | AFTY | ETF | 14.15 | 14.15 | 14.145 | 14.145 | 1200.0 |
| 2024-06-18 | AGG | ETF | 97.7 | 98.04 | 97.68 | 97.92 | 7030700.0 |
| 2024-06-18 | AGGH | ETF | 21.11 | 21.2 | 21.04 | 21.2 | 55522.0 |
| 2024-06-18 | AGGY | ETF | 43.31 | 43.43 | 43.31 | 43.37 | 50100.0 |
| 2024-06-18 | AGMI | ETF | 25.76 | 25.7845 | 25.76 | 25.7845 | 100.0 |
| 2024-06-18 | AGNG | ETF | 30.05 | 30.1 | 29.97 | 30.055 | 4600.0 |
| 2024-06-18 | AGOX | ETF | 28.07 | 28.81 | 27.999 | 28.32 | 141200.0 |
| 2024-06-18 | AGQ | ETF | 37.57 | 38.6 | 37.52 | 38.46 | 1122100.0 |
| 2024-06-18 | AGQI | ETF | 14.38 | 14.45 | 14.35 | 14.415 | 28465.0 |
| 2024-06-18 | AGRH | ETF | 25.93 | 25.96 | 25.89 | 25.9044 | 1577.0 |
> showing 50 of 3,421 rows — these rows as CSV