PREVIEW / etf_daily / 2024-06-12
file: by_date/etf_daily/2024/2024-06-12.parquet size: 122 KB rows: 3,401
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-12 | SPY | ETF | 541.63 | 544.12 | 540.3 | 541.36 | 63251300.0 |
| 2024-06-12 | QQQ | ETF | 471.99 | 476.5 | 471.29 | 474.15 | 34532585.0 |
| 2024-06-12 | IWM | ETF | 205.87 | 207.27 | 203.1 | 203.72 | 43668700.0 |
| 2024-06-12 | DIA | ETF | 391.58 | 391.91 | 386.69 | 387.69 | 3866700.0 |
| 2024-06-12 | GLD | ETF | 216.47 | 216.55 | 214.2 | 214.72 | 5911900.0 |
| 2024-06-12 | TLT | ETF | 93.02 | 93.57 | 92.49 | 92.52 | 42554600.0 |
| 2024-06-12 | AAA | ETF | 25.09 | 25.09 | 25.0 | 25.075 | 33400.0 |
| 2024-06-12 | AAAU | ETF | 23.17 | 23.17 | 22.91 | 22.97 | 2282800.0 |
| 2024-06-12 | AADR | ETF | 63.93 | 64.01 | 63.31 | 63.31 | 3000.0 |
| 2024-06-12 | AAPB | ETF | 24.8 | 27.78 | 24.72 | 26.1 | 937262.0 |
| 2024-06-12 | AAPD | ETF | 18.7 | 18.73 | 17.56 | 18.2 | 2155882.0 |
| 2024-06-12 | AAPR | ETF | 25.13 | 25.19 | 25.1198 | 25.14 | 24690.0 |
| 2024-06-12 | AAPU | ETF | 32.03 | 35.92 | 31.83 | 33.72 | 4777604.0 |
| 2024-06-12 | AAPX | ETF | 28.93 | 32.38 | 28.87 | 30.43 | 213944.0 |
| 2024-06-12 | AAPY | ETF | 26.5301 | 26.6 | 26.4996 | 26.4996 | 3358.0 |
| 2024-06-12 | AAXJ | ETF | 71.99 | 72.22 | 71.66 | 71.75 | 451000.0 |
| 2024-06-12 | ABCS | ETF | 26.525 | 26.525 | 26.3106 | 26.3106 | 1500.0 |
| 2024-06-12 | ABEQ | ETF | 30.33 | 30.34 | 30.229 | 30.229 | 1000.0 |
| 2024-06-12 | ACES | ETF | 32.14 | 32.5 | 31.355 | 31.46 | 55700.0 |
| 2024-06-12 | ACIO | ETF | 37.32 | 37.37 | 37.133 | 37.21 | 81500.0 |
| 2024-06-12 | ACSI | ETF | 54.56 | 54.56 | 54.56 | 54.56 | 100.0 |
| 2024-06-12 | ACT | ETF | 29.73 | 30.28 | 29.73 | 30.12 | 218659.0 |
| 2024-06-12 | ACTV | ETF | 32.79 | 32.94 | 32.484 | 32.484 | 8600.0 |
| 2024-06-12 | ACVF | ETF | 40.79 | 41.03 | 40.79 | 40.93 | 13700.0 |
| 2024-06-12 | ACWF | ETF | 42.23 | 42.3642 | 42.13 | 42.17 | 7924.0 |
| 2024-06-12 | ACWI | ETF | 112.41 | 112.8 | 111.98 | 112.22 | 3698100.0 |
| 2024-06-12 | ACWV | ETF | 104.64 | 104.64 | 103.61 | 103.77 | 85100.0 |
| 2024-06-12 | ACWX | ETF | 53.81 | 53.97 | 53.55 | 53.63 | 870000.0 |
| 2024-06-12 | ADFI | ETF | 8.52 | 8.639 | 8.52 | 8.53 | 15400.0 |
| 2024-06-12 | ADIV | ETF | 14.76 | 14.832 | 14.755 | 14.755 | 800.0 |
| 2024-06-12 | ADME | ETF | 43.09 | 43.43 | 43.09 | 43.259 | 230200.0 |
| 2024-06-12 | ADPV | ETF | 30.5208 | 30.5208 | 30.19 | 30.2478 | 4875.0 |
| 2024-06-12 | AEMB | ETF | 38.62 | 38.62 | 38.48 | 38.48 | 300.0 |
| 2024-06-12 | AESR | ETF | 16.261 | 16.28 | 16.24 | 16.25 | 14400.0 |
| 2024-06-12 | AETH | ETF | 47.0 | 47.52 | 46.02 | 46.02 | 5230.0 |
| 2024-06-12 | AFIF | ETF | 9.14 | 9.15 | 9.12 | 9.14 | 34600.0 |
| 2024-06-12 | AFK | ETF | 15.41 | 15.71 | 15.26 | 15.41 | 28300.0 |
| 2024-06-12 | AFLG | ETF | 31.71 | 31.71 | 31.582 | 31.582 | 900.0 |
| 2024-06-12 | AFMC | ETF | 29.514 | 29.514 | 29.514 | 29.514 | 100.0 |
| 2024-06-12 | AFSM | ETF | 28.556 | 28.556 | 28.556 | 28.556 | 100.0 |
| 2024-06-12 | AFTY | ETF | 14.11 | 14.22 | 14.11 | 14.13 | 500.0 |
| 2024-06-12 | AGG | ETF | 97.6 | 97.81 | 97.31 | 97.33 | 7627000.0 |
| 2024-06-12 | AGGH | ETF | 20.99 | 21.11 | 20.92 | 21.04 | 38952.0 |
| 2024-06-12 | AGGY | ETF | 43.26 | 43.365 | 43.18 | 43.21 | 78900.0 |
| 2024-06-12 | AGMI | ETF | 26.47 | 26.47 | 25.77 | 25.9033 | 3137.0 |
| 2024-06-12 | AGNG | ETF | 30.35 | 30.489 | 29.43 | 30.32 | 4400.0 |
| 2024-06-12 | AGOX | ETF | 27.65 | 27.73 | 27.335 | 27.38 | 64000.0 |
| 2024-06-12 | AGQ | ETF | 40.1 | 40.26 | 38.44 | 38.7 | 2260200.0 |
| 2024-06-12 | AGQI | ETF | 14.57 | 14.62 | 14.55 | 14.556 | 13880.0 |
| 2024-06-12 | AGZ | ETF | 107.81 | 107.97 | 107.69 | 107.76 | 9700.0 |
> showing 50 of 3,401 rows — these rows as CSV