PREVIEW / etf_daily / 2024-05-09
file: by_date/etf_daily/2024/2024-05-09.parquet size: 119 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-05-09 | SPY | ETF | 517.38 | 520.21 | 516.71 | 520.17 | 43643700.0 |
| 2024-05-09 | QQQ | ETF | 440.33 | 441.6 | 438.46 | 441.02 | 24580121.0 |
| 2024-05-09 | IWM | ETF | 203.97 | 205.99 | 203.41 | 205.86 | 22914300.0 |
| 2024-05-09 | DIA | ETF | 390.11 | 394.26 | 390.01 | 394.0 | 4141200.0 |
| 2024-05-09 | GLD | ETF | 214.48 | 216.95 | 214.44 | 216.95 | 7732500.0 |
| 2024-05-09 | TLT | ETF | 89.87 | 90.77 | 89.82 | 90.63 | 39606700.0 |
| 2024-05-09 | AAA | ETF | 25.13 | 25.13 | 25.02 | 25.063 | 23800.0 |
| 2024-05-09 | AAAU | ETF | 22.94 | 23.21 | 22.94 | 23.2 | 3080400.0 |
| 2024-05-09 | AADR | ETF | 63.76 | 63.76 | 63.72 | 63.72 | 300.0 |
| 2024-05-09 | AAPB | ETF | 19.48 | 19.92 | 19.4 | 19.9 | 231846.0 |
| 2024-05-09 | AAPD | ETF | 21.29 | 21.34 | 21.0597 | 21.07 | 128884.0 |
| 2024-05-09 | AAPR | ETF | 24.67 | 24.71 | 24.6375 | 24.69 | 103533.0 |
| 2024-05-09 | AAPU | ETF | 25.09 | 25.68 | 25.0 | 25.66 | 307660.0 |
| 2024-05-09 | AAPX | ETF | 22.79 | 23.26 | 22.66 | 23.26 | 17360.0 |
| 2024-05-09 | AAPY | ETF | 24.84 | 24.94 | 24.84 | 24.9275 | 2235.0 |
| 2024-05-09 | AAXJ | ETF | 70.43 | 70.69 | 70.33 | 70.65 | 600000.0 |
| 2024-05-09 | ABCS | ETF | 26.3544 | 26.5683 | 26.3544 | 26.5683 | 1750.0 |
| 2024-05-09 | ABEQ | ETF | 30.55 | 30.617 | 30.5 | 30.617 | 4000.0 |
| 2024-05-09 | ACES | ETF | 28.8 | 29.37 | 28.8 | 29.37 | 84400.0 |
| 2024-05-09 | ACIO | ETF | 35.862 | 36.01 | 35.79 | 35.97 | 186600.0 |
| 2024-05-09 | ACSI | ETF | 53.273 | 53.273 | 53.273 | 53.273 | 100.0 |
| 2024-05-09 | ACT | ETF | 31.58 | 31.76 | 31.47 | 31.74 | 136914.0 |
| 2024-05-09 | ACTV | ETF | 33.43 | 33.657 | 33.31 | 33.657 | 2500.0 |
| 2024-05-09 | ACVF | ETF | 39.39 | 39.452 | 39.36 | 39.45 | 1300.0 |
| 2024-05-09 | ACWF | ETF | 41.19 | 41.34 | 41.19 | 41.34 | 2017.0 |
| 2024-05-09 | ACWI | ETF | 109.45 | 110.05 | 109.32 | 110.04 | 925400.0 |
| 2024-05-09 | ACWV | ETF | 103.82 | 104.51 | 103.82 | 104.48 | 163300.0 |
| 2024-05-09 | ACWX | ETF | 53.62 | 53.96 | 53.62 | 53.95 | 1906600.0 |
| 2024-05-09 | ADFI | ETF | 8.43 | 8.49 | 8.43 | 8.49 | 26900.0 |
| 2024-05-09 | ADIV | ETF | 14.58 | 14.58 | 14.58 | 14.58 | 100.0 |
| 2024-05-09 | ADME | ETF | 41.465 | 41.7 | 41.465 | 41.662 | 5400.0 |
| 2024-05-09 | ADPV | ETF | 30.71 | 31.0099 | 30.6262 | 30.9333 | 18820.0 |
| 2024-05-09 | AEMB | ETF | 38.52 | 38.6 | 38.52 | 38.561 | 1100.0 |
| 2024-05-09 | AESR | ETF | 15.32 | 15.379 | 15.32 | 15.36 | 19400.0 |
| 2024-05-09 | AETH | ETF | 39.02 | 39.79 | 38.9099 | 39.7067 | 2502.0 |
| 2024-05-09 | AFIF | ETF | 9.12 | 9.12 | 9.1 | 9.1 | 58100.0 |
| 2024-05-09 | AFK | ETF | 15.23 | 15.47 | 15.12 | 15.39 | 8300.0 |
| 2024-05-09 | AFLG | ETF | 30.595 | 30.595 | 30.595 | 30.595 | 100.0 |
| 2024-05-09 | AFMC | ETF | 29.8 | 29.924 | 29.8 | 29.924 | 200.0 |
| 2024-05-09 | AFSM | ETF | 28.81 | 28.935 | 28.81 | 28.935 | 200.0 |
| 2024-05-09 | AFTY | ETF | 14.74 | 14.78 | 14.74 | 14.78 | 1300.0 |
| 2024-05-09 | AGG | ETF | 96.2 | 96.53 | 96.19 | 96.44 | 6732500.0 |
| 2024-05-09 | AGGH | ETF | 20.87 | 20.94 | 20.7067 | 20.94 | 18897.0 |
| 2024-05-09 | AGGS | ETF | 40.4597 | 40.5399 | 40.4597 | 40.5399 | 205.0 |
| 2024-05-09 | AGGY | ETF | 42.72 | 42.84 | 42.71 | 42.81 | 79000.0 |
| 2024-05-09 | AGMI | ETF | 26.04 | 27.2478 | 26.04 | 27.2478 | 352.0 |
| 2024-05-09 | AGNG | ETF | 29.439 | 29.5 | 29.43 | 29.49 | 5300.0 |
| 2024-05-09 | AGOX | ETF | 24.97 | 25.17 | 24.97 | 25.04 | 24100.0 |
| 2024-05-09 | AGQ | ETF | 34.92 | 36.44 | 34.91 | 36.41 | 1780800.0 |
| 2024-05-09 | AGQI | ETF | 14.04 | 14.155 | 14.04 | 14.151 | 11088.0 |
> showing 50 of 3,309 rows — these rows as CSV