PREVIEW / etf_daily / 2024-08-09
file: by_date/etf_daily/2024/2024-08-09.parquet size: 132 KB rows: 3,432
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-08-09 | SPY | ETF | 529.81 | 534.51 | 528.56 | 532.99 | 45442812.0 |
| 2024-08-09 | QQQ | ETF | 446.74 | 452.06 | 445.61 | 450.41 | 33573976.0 |
| 2024-08-09 | IWM | ETF | 207.05 | 207.12 | 204.94 | 206.46 | 21111538.0 |
| 2024-08-09 | DIA | ETF | 394.18 | 396.49 | 392.415 | 395.15 | 3379752.0 |
| 2024-08-09 | GLD | ETF | 224.82 | 225.28 | 223.82 | 224.56 | 4436681.0 |
| 2024-08-09 | TLT | ETF | 96.51 | 96.54 | 96.0906 | 96.26 | 32064395.0 |
| 2024-08-09 | AAA | ETF | 24.96 | 25.02 | 24.96 | 24.96 | 1888.0 |
| 2024-08-09 | AAAU | ETF | 24.055 | 24.105 | 23.95 | 24.03 | 1557037.0 |
| 2024-08-09 | AADR | ETF | 59.44 | 59.44 | 59.44 | 59.44 | 25.0 |
| 2024-08-09 | AAPB | ETF | 25.2 | 26.3091 | 25.2 | 26.21 | 49594.0 |
| 2024-08-09 | AAPD | ETF | 18.13 | 18.13 | 17.74 | 17.79 | 466765.0 |
| 2024-08-09 | AAPR | ETF | 25.3695 | 25.4099 | 25.31 | 25.33 | 6209.0 |
| 2024-08-09 | AAPU | ETF | 32.3 | 33.77 | 32.3 | 33.63 | 730557.0 |
| 2024-08-09 | AAPX | ETF | 29.18 | 30.5399 | 29.18 | 30.4 | 28697.0 |
| 2024-08-09 | AAPY | ETF | 26.3 | 26.3535 | 26.3 | 26.3535 | 1549.0 |
| 2024-08-09 | AAXJ | ETF | 70.47 | 70.73 | 70.16 | 70.63 | 100031.0 |
| 2024-08-09 | ABCS | ETF | 26.4 | 26.5313 | 26.37 | 26.5313 | 6722.0 |
| 2024-08-09 | ABEQ | ETF | 31.06 | 31.08 | 30.94 | 31.05 | 16418.0 |
| 2024-08-09 | ABNY | ETF | 77.4 | 78.1205 | 77.0005 | 78.1205 | 1116.0 |
| 2024-08-09 | ACES | ETF | 27.9 | 27.9 | 27.16 | 27.37 | 39602.0 |
| 2024-08-09 | ACIO | ETF | 37.395 | 37.62 | 37.31 | 37.502 | 103735.0 |
| 2024-08-09 | ACSI | ETF | 54.7 | 54.7 | 54.7 | 54.7 | 779.0 |
| 2024-08-09 | ACT | ETF | 33.22 | 33.27 | 33.0 | 33.26 | 142958.0 |
| 2024-08-09 | ACTV | ETF | 31.64 | 31.64 | 31.52 | 31.6257 | 2468.0 |
| 2024-08-09 | ACVF | ETF | 40.39 | 40.624 | 40.32 | 40.4863 | 14421.0 |
| 2024-08-09 | ACWI | ETF | 109.93 | 110.75 | 109.64 | 110.53 | 1569467.0 |
| 2024-08-09 | ACWV | ETF | 107.94 | 108.49 | 107.55 | 108.21 | 166909.0 |
| 2024-08-09 | ACWX | ETF | 52.35 | 52.6599 | 52.21 | 52.63 | 444424.0 |
| 2024-08-09 | ADFI | ETF | 8.6524 | 8.7299 | 8.6202 | 8.67 | 14383.0 |
| 2024-08-09 | ADIV | ETF | 14.4109 | 14.4109 | 14.4109 | 14.4109 | 18.0 |
| 2024-08-09 | ADME | ETF | 43.1414 | 43.41 | 43.13 | 43.291 | 10613.0 |
| 2024-08-09 | ADPV | ETF | 29.65 | 29.95 | 29.65 | 29.9009 | 6424.0 |
| 2024-08-09 | AEMB | ETF | 38.897 | 39.0244 | 38.79 | 38.9718 | 995.0 |
| 2024-08-09 | AESR | ETF | 15.77 | 15.84 | 15.7272 | 15.83 | 17153.0 |
| 2024-08-09 | AETH | ETF | 34.0 | 34.28 | 33.545 | 33.6478 | 3172.0 |
| 2024-08-09 | AFIF | ETF | 9.16 | 9.18 | 9.15 | 9.16 | 27246.0 |
| 2024-08-09 | AFK | ETF | 15.24 | 15.4123 | 15.1 | 15.2471 | 7097.0 |
| 2024-08-09 | AFLG | ETF | 31.37 | 31.45 | 31.36 | 31.45 | 3538.0 |
| 2024-08-09 | AFMC | ETF | 29.8 | 29.95 | 29.78 | 29.92 | 9191.0 |
| 2024-08-09 | AFSM | ETF | 28.74 | 28.74 | 28.6853 | 28.6853 | 1500.0 |
| 2024-08-09 | AFTY | ETF | 13.8641 | 13.8641 | 13.8641 | 13.8641 | 12.0 |
| 2024-08-09 | AGG | ETF | 99.64 | 99.7 | 99.48 | 99.55 | 3866268.0 |
| 2024-08-09 | AGGH | ETF | 21.46 | 21.46 | 21.3754 | 21.4 | 39427.0 |
| 2024-08-09 | AGGS | ETF | 41.82 | 41.82 | 41.81 | 41.81 | 1001.0 |
| 2024-08-09 | AGGY | ETF | 44.07 | 44.07 | 43.93 | 43.98 | 125638.0 |
| 2024-08-09 | AGIX | ETF | 23.24 | 23.24 | 23.1927 | 23.1927 | 294.0 |
| 2024-08-09 | AGMI | ETF | 24.6 | 24.6 | 24.4968 | 24.4968 | 150.0 |
| 2024-08-09 | AGNG | ETF | 31.18 | 31.5 | 31.18 | 31.302 | 2008.0 |
| 2024-08-09 | AGOX | ETF | 27.21 | 27.39 | 27.03 | 27.2442 | 23145.0 |
| 2024-08-09 | AGQ | ETF | 32.36 | 32.697 | 31.75 | 32.12 | 1124225.0 |
> showing 50 of 3,432 rows — these rows as CSV