PREVIEW / etf_daily / 2024-10-08
file: by_date/etf_daily/2024/2024-10-08.parquet size: 143 KB rows: 3,738
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-10-08 | SPY | ETF | 570.42 | 573.78 | 569.5299 | 573.17 | 37336110.0 |
| 2024-10-08 | QQQ | ETF | 484.66 | 489.99 | 483.845 | 489.3 | 28272017.0 |
| 2024-10-08 | IWM | ETF | 217.63 | 218.37 | 216.7 | 217.58 | 18042176.0 |
| 2024-10-08 | DIA | ETF | 420.51 | 421.28 | 418.71 | 420.8 | 1871439.0 |
| 2024-10-08 | GLD | ETF | 243.79 | 244.04 | 240.63 | 242.37 | 7449596.0 |
| 2024-10-08 | TLT | ETF | 94.39 | 95.03 | 94.335 | 94.99 | 33490352.0 |
| 2024-10-08 | AAA | ETF | 25.05 | 25.11 | 25.012 | 25.11 | 4171.0 |
| 2024-10-08 | AAAU | ETF | 26.1 | 26.125 | 25.76 | 25.94 | 3115462.0 |
| 2024-10-08 | AADR | ETF | 62.92 | 63.2859 | 62.92 | 63.2859 | 311.0 |
| 2024-10-08 | AAPB | ETF | 27.68 | 28.1 | 27.47 | 28.02 | 57806.0 |
| 2024-10-08 | AAPD | ETF | 17.09 | 17.15 | 16.95 | 16.97 | 187317.0 |
| 2024-10-08 | AAPR | ETF | 26.1 | 26.155 | 26.1 | 26.155 | 13115.0 |
| 2024-10-08 | AAPU | ETF | 35.11 | 35.63 | 34.82 | 35.56 | 354762.0 |
| 2024-10-08 | AAPX | ETF | 31.88 | 32.4325 | 31.83 | 32.4325 | 7879.0 |
| 2024-10-08 | AAPY | ETF | 26.91 | 27.1075 | 26.91 | 27.1075 | 898.0 |
| 2024-10-08 | AAXJ | ETF | 79.31 | 79.535 | 78.51 | 79.26 | 877779.0 |
| 2024-10-08 | ABCS | ETF | 27.99 | 28.04 | 27.9899 | 28.0071 | 2324.0 |
| 2024-10-08 | ABEQ | ETF | 32.21 | 32.2575 | 32.17 | 32.2575 | 1548.0 |
| 2024-10-08 | ABNY | ETF | 84.671 | 84.671 | 83.75 | 83.773 | 399.0 |
| 2024-10-08 | ACES | ETF | 28.71 | 28.71 | 28.3 | 28.44 | 15747.0 |
| 2024-10-08 | ACIO | ETF | 39.6 | 39.84 | 39.6 | 39.805 | 191386.0 |
| 2024-10-08 | ACSI | ETF | 57.6808 | 57.6808 | 57.6808 | 57.6808 | 58.0 |
| 2024-10-08 | ACT | ETF | 35.95 | 36.45 | 35.75 | 36.21 | 250515.0 |
| 2024-10-08 | ACTV | ETF | 33.4 | 33.54 | 33.4 | 33.4 | 8291.0 |
| 2024-10-08 | ACVF | ETF | 43.39 | 43.7702 | 43.39 | 43.7702 | 2893.0 |
| 2024-10-08 | ACWI | ETF | 118.72 | 119.14 | 118.54 | 119.04 | 1346079.0 |
| 2024-10-08 | ACWV | ETF | 113.34 | 113.68 | 113.2002 | 113.67 | 202120.0 |
| 2024-10-08 | ACWX | ETF | 56.47 | 56.525 | 56.256 | 56.44 | 1031914.0 |
| 2024-10-08 | ADFI | ETF | 8.66 | 8.68 | 8.6404 | 8.68 | 12285.0 |
| 2024-10-08 | ADIV | ETF | 16.93 | 16.93 | 16.22 | 16.3075 | 14782.0 |
| 2024-10-08 | ADME | ETF | 46.12 | 46.26 | 46.01 | 46.26 | 14180.0 |
| 2024-10-08 | ADPV | ETF | 32.01 | 32.17 | 32.01 | 32.0392 | 3104.0 |
| 2024-10-08 | ADVE | ETF | 36.0718 | 36.0718 | 36.0718 | 36.0718 | 1.0 |
| 2024-10-08 | AESR | ETF | 17.02 | 17.1 | 17.01 | 17.092 | 19301.0 |
| 2024-10-08 | AETH | ETF | 31.3253 | 31.465 | 31.07 | 31.3292 | 2140.0 |
| 2024-10-08 | AFIF | ETF | 9.21 | 9.21 | 9.195 | 9.195 | 4070.0 |
| 2024-10-08 | AFK | ETF | 16.66 | 16.77 | 16.3 | 16.3 | 6456.0 |
| 2024-10-08 | AFLG | ETF | 33.89 | 34.07 | 33.89 | 34.05 | 15983.0 |
| 2024-10-08 | AFMC | ETF | 31.8374 | 31.931 | 31.785 | 31.8853 | 1365.0 |
| 2024-10-08 | AFSM | ETF | 30.225 | 30.46 | 30.225 | 30.3881 | 73688.0 |
| 2024-10-08 | AFTY | ETF | 16.36 | 16.368 | 16.27 | 16.35 | 62909.0 |
| 2024-10-08 | AGG | ETF | 99.52 | 99.79 | 99.49 | 99.79 | 7340126.0 |
| 2024-10-08 | AGGH | ETF | 21.34 | 21.35 | 21.22 | 21.35 | 45618.0 |
| 2024-10-08 | AGGS | ETF | 41.86 | 41.8663 | 41.86 | 41.8663 | 179.0 |
| 2024-10-08 | AGGY | ETF | 44.12 | 44.21 | 44.094 | 44.21 | 75767.0 |
| 2024-10-08 | AGIH | ETF | 24.925 | 24.925 | 24.925 | 24.925 | 3.0 |
| 2024-10-08 | AGIX | ETF | 25.69 | 25.7494 | 25.68 | 25.7494 | 762.0 |
| 2024-10-08 | AGMI | ETF | 29.02 | 29.02 | 28.5 | 29.0 | 1770.0 |
| 2024-10-08 | AGNG | ETF | 32.29 | 32.38 | 32.15 | 32.37 | 10329.0 |
| 2024-10-08 | AGOX | ETF | 29.1 | 29.52 | 29.03 | 29.21 | 139436.0 |
> showing 50 of 3,738 rows — these rows as CSV