PREVIEW / etf_daily / 2024-03-18
file: by_date/etf_daily/2024/2024-03-18.parquet size: 118 KB rows: 3,309
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-03-18 | SPY | ETF | 514.0 | 515.48 | 512.44 | 512.86 | 88893300.0 |
| 2024-03-18 | QQQ | ETF | 438.73 | 441.04 | 437.24 | 437.48 | 47323802.0 |
| 2024-03-18 | IWM | ETF | 202.91 | 203.18 | 200.91 | 201.25 | 32405100.0 |
| 2024-03-18 | DIA | ETF | 388.35 | 388.86 | 387.48 | 387.73 | 2060600.0 |
| 2024-03-18 | GLD | ETF | 199.66 | 200.15 | 199.51 | 200.03 | 7206800.0 |
| 2024-03-18 | TLT | ETF | 92.73 | 92.99 | 92.5 | 92.66 | 29519500.0 |
| 2024-03-18 | AAA | ETF | 25.08 | 25.117 | 25.08 | 25.1 | 2500.0 |
| 2024-03-18 | AAAU | ETF | 21.35 | 21.4 | 21.33 | 21.39 | 1540600.0 |
| 2024-03-18 | AADR | ETF | 60.36 | 61.24 | 60.36 | 60.7 | 1300.0 |
| 2024-03-18 | AAPB | ETF | 18.55 | 18.95 | 18.12 | 18.13 | 294642.0 |
| 2024-03-18 | AAPD | ETF | 22.31 | 22.56 | 22.0239 | 22.54 | 251847.0 |
| 2024-03-18 | AAPU | ETF | 23.52 | 23.9 | 23.08 | 23.12 | 593322.0 |
| 2024-03-18 | AAPX | ETF | 21.68 | 22.12 | 21.21 | 21.21 | 36602.0 |
| 2024-03-18 | AAPY | ETF | 24.3 | 24.6 | 24.1711 | 24.1711 | 711.0 |
| 2024-03-18 | AAXJ | ETF | 67.84 | 67.99 | 67.59 | 67.65 | 399800.0 |
| 2024-03-18 | ABCS | ETF | 26.1992 | 26.24 | 26.14 | 26.1857 | 2902.0 |
| 2024-03-18 | ABEQ | ETF | 29.57 | 29.57 | 29.459 | 29.483 | 3700.0 |
| 2024-03-18 | ACES | ETF | 27.82 | 27.98 | 27.45 | 27.78 | 62400.0 |
| 2024-03-18 | ACIO | ETF | 35.545 | 35.64 | 35.45 | 35.45 | 110000.0 |
| 2024-03-18 | ACSI | ETF | 50.44 | 50.44 | 50.379 | 50.379 | 100.0 |
| 2024-03-18 | ACT | ETF | 29.21 | 29.44 | 29.07 | 29.32 | 243944.0 |
| 2024-03-18 | ACTV | ETF | 33.56 | 33.59 | 33.39 | 33.39 | 13100.0 |
| 2024-03-18 | ACVF | ETF | 39.73 | 39.73 | 39.5 | 39.5 | 4600.0 |
| 2024-03-18 | ACWF | ETF | 40.53 | 40.5383 | 40.53 | 40.5383 | 264.0 |
| 2024-03-18 | ACWI | ETF | 108.54 | 108.66 | 108.19 | 108.26 | 1913200.0 |
| 2024-03-18 | ACWV | ETF | 104.35 | 104.71 | 104.24 | 104.32 | 64600.0 |
| 2024-03-18 | ACWX | ETF | 52.98 | 53.02 | 52.77 | 52.82 | 605500.0 |
| 2024-03-18 | ADFI | ETF | 8.48 | 8.48 | 8.42 | 8.43 | 20000.0 |
| 2024-03-18 | ADIV | ETF | 14.196 | 14.196 | 14.196 | 14.196 | 100.0 |
| 2024-03-18 | ADME | ETF | 41.45 | 41.46 | 41.336 | 41.336 | 4600.0 |
| 2024-03-18 | ADPV | ETF | 28.87 | 28.87 | 28.7379 | 28.7379 | 175.0 |
| 2024-03-18 | ADVE | ETF | 32.55 | 32.55 | 32.476 | 32.476 | 281.0 |
| 2024-03-18 | AEMB | ETF | 38.217 | 38.217 | 38.157 | 38.157 | 1100.0 |
| 2024-03-18 | AESR | ETF | 15.29 | 15.34 | 15.26 | 15.26 | 31200.0 |
| 2024-03-18 | AETH | ETF | 48.22 | 48.4 | 46.99 | 47.0622 | 16546.0 |
| 2024-03-18 | AFIF | ETF | 9.1 | 9.11 | 9.09 | 9.1 | 13900.0 |
| 2024-03-18 | AFK | ETF | 14.08 | 14.08 | 13.72 | 13.92 | 10300.0 |
| 2024-03-18 | AFLG | ETF | 30.145 | 30.2 | 30.095 | 30.095 | 500.0 |
| 2024-03-18 | AFMC | ETF | 29.2 | 29.2 | 28.869 | 28.869 | 400.0 |
| 2024-03-18 | AFSM | ETF | 28.13 | 28.13 | 27.881 | 27.881 | 1900.0 |
| 2024-03-18 | AFTY | ETF | 14.125 | 14.14 | 14.112 | 14.121 | 1000.0 |
| 2024-03-18 | AGG | ETF | 97.07 | 97.12 | 96.92 | 97.0 | 5227200.0 |
| 2024-03-18 | AGGH | ETF | 21.49 | 21.49 | 21.2509 | 21.32 | 37387.0 |
| 2024-03-18 | AGGY | ETF | 43.11 | 43.15 | 43.06 | 43.11 | 77900.0 |
| 2024-03-18 | AGNG | ETF | 29.887 | 29.887 | 29.75 | 29.75 | 1600.0 |
| 2024-03-18 | AGOX | ETF | 25.77 | 25.77 | 25.38 | 25.38 | 45700.0 |
| 2024-03-18 | AGQ | ETF | 29.85 | 29.88 | 29.14 | 29.27 | 559600.0 |
| 2024-03-18 | AGQI | ETF | 13.78 | 13.8003 | 13.77 | 13.7701 | 11025.0 |
| 2024-03-18 | AGRH | ETF | 25.86 | 25.86 | 25.82 | 25.835 | 2585.0 |
| 2024-03-18 | AGZ | ETF | 107.58 | 107.58 | 107.41 | 107.46 | 11700.0 |
> showing 50 of 3,309 rows — these rows as CSV