PREVIEW / etf_daily / 2024-10-10
file: by_date/etf_daily/2024/2024-10-10.parquet size: 143 KB rows: 3,746
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-10 | SPY | ETF | 575.77 | 577.58 | 574.49 | 576.13 | 44348254.0 |
| 2024-10-10 | QQQ | ETF | 490.85 | 494.47 | 489.53 | 492.59 | 25750446.0 |
| 2024-10-10 | IWM | ETF | 215.9 | 216.88 | 214.6 | 216.85 | 24507773.0 |
| 2024-10-10 | DIA | ETF | 425.0 | 425.07 | 423.04 | 424.66 | 2176891.0 |
| 2024-10-10 | GLD | ETF | 241.77 | 243.02 | 241.5101 | 242.82 | 4755495.0 |
| 2024-10-10 | TLT | ETF | 93.88 | 94.09 | 93.41 | 94.08 | 52974889.0 |
| 2024-10-10 | AAA | ETF | 25.09 | 25.09 | 25.0101 | 25.0601 | 2640.0 |
| 2024-10-10 | AAAU | ETF | 25.875 | 26.02 | 25.86 | 25.99 | 2381291.0 |
| 2024-10-10 | AADR | ETF | 64.0445 | 64.0445 | 64.0445 | 64.0445 | 14.0 |
| 2024-10-10 | AAPB | ETF | 28.58 | 28.96 | 28.45 | 28.89 | 101198.0 |
| 2024-10-10 | AAPD | ETF | 16.81 | 16.8579 | 16.7 | 16.73 | 173306.0 |
| 2024-10-10 | AAPR | ETF | 26.1682 | 26.2 | 26.1301 | 26.2 | 5610.0 |
| 2024-10-10 | AAPU | ETF | 36.22 | 36.73 | 36.01 | 36.59 | 372840.0 |
| 2024-10-10 | AAPX | ETF | 33.0 | 33.4 | 32.8 | 33.3434 | 2765.0 |
| 2024-10-10 | AAPY | ETF | 27.41 | 27.4681 | 27.3828 | 27.4681 | 984.0 |
| 2024-10-10 | AAXJ | ETF | 79.01 | 79.21 | 78.3 | 78.97 | 325487.0 |
| 2024-10-10 | ABCS | ETF | 28.1 | 28.17 | 28.0975 | 28.0975 | 1702.0 |
| 2024-10-10 | ABEQ | ETF | 32.46 | 32.46 | 32.3576 | 32.4155 | 8857.0 |
| 2024-10-10 | ABNY | ETF | 85.2 | 85.2 | 83.8 | 84.125 | 767.0 |
| 2024-10-10 | ACES | ETF | 28.74 | 28.74 | 28.1796 | 28.24 | 83609.0 |
| 2024-10-10 | ACIO | ETF | 40.03 | 40.09 | 39.93 | 40.03 | 216097.0 |
| 2024-10-10 | ACSI | ETF | 57.8275 | 57.8275 | 57.8275 | 57.8275 | 13.0 |
| 2024-10-10 | ACT | ETF | 36.1 | 36.165 | 35.65 | 35.9 | 264105.0 |
| 2024-10-10 | ACTV | ETF | 33.13 | 33.3541 | 33.13 | 33.295 | 7771.0 |
| 2024-10-10 | ACVF | ETF | 43.96 | 44.04 | 43.8993 | 43.9927 | 2251.0 |
| 2024-10-10 | ACWI | ETF | 119.32 | 119.595 | 118.95 | 119.41 | 653765.0 |
| 2024-10-10 | ACWV | ETF | 114.05 | 114.16 | 113.62 | 113.87 | 248162.0 |
| 2024-10-10 | ACWX | ETF | 56.33 | 56.395 | 56.04 | 56.39 | 546994.0 |
| 2024-10-10 | ADFI | ETF | 8.63 | 8.68 | 8.61 | 8.65 | 16075.0 |
| 2024-10-10 | ADIV | ETF | 16.195 | 16.23 | 16.19 | 16.1926 | 2754.0 |
| 2024-10-10 | ADME | ETF | 46.5 | 46.6 | 46.3801 | 46.53 | 20455.0 |
| 2024-10-10 | ADPV | ETF | 32.028 | 32.19 | 32.028 | 32.19 | 550.0 |
| 2024-10-10 | ADVE | ETF | 35.8315 | 35.8315 | 35.8315 | 35.8315 | 3.0 |
| 2024-10-10 | AESR | ETF | 17.15 | 17.17 | 17.09 | 17.1 | 17456.0 |
| 2024-10-10 | AETH | ETF | 30.501 | 30.84 | 30.0 | 30.3857 | 3761.0 |
| 2024-10-10 | AFIF | ETF | 9.21 | 9.22 | 9.19 | 9.22 | 16283.0 |
| 2024-10-10 | AFK | ETF | 16.67 | 16.76 | 16.53 | 16.7 | 4143.0 |
| 2024-10-10 | AFLG | ETF | 34.22 | 34.22 | 34.1005 | 34.16 | 8183.0 |
| 2024-10-10 | AFMC | ETF | 31.89 | 31.89 | 31.8292 | 31.8292 | 236.0 |
| 2024-10-10 | AFSM | ETF | 30.15 | 30.3297 | 30.15 | 30.3297 | 3004.0 |
| 2024-10-10 | AFTY | ETF | 16.28 | 16.3128 | 16.27 | 16.2826 | 29711.0 |
| 2024-10-10 | AGG | ETF | 99.45 | 99.55 | 99.2338 | 99.47 | 5754027.0 |
| 2024-10-10 | AGGH | ETF | 21.4 | 21.4 | 21.1 | 21.1 | 126378.0 |
| 2024-10-10 | AGGS | ETF | 41.735 | 41.735 | 41.735 | 41.735 | 2.0 |
| 2024-10-10 | AGGY | ETF | 44.06 | 44.13 | 44.02 | 44.13 | 61515.0 |
| 2024-10-10 | AGIH | ETF | 24.93 | 24.93 | 24.93 | 24.93 | 5.0 |
| 2024-10-10 | AGIX | ETF | 26.14 | 26.31 | 26.14 | 26.2624 | 927.0 |
| 2024-10-10 | AGMI | ETF | 29.4 | 29.94 | 29.4 | 29.94 | 281.0 |
| 2024-10-10 | AGNG | ETF | 32.3366 | 32.3366 | 32.301 | 32.33 | 579.0 |
| 2024-10-10 | AGOX | ETF | 29.43 | 29.53 | 29.23 | 29.31 | 15329.0 |
> showing 50 of 3,746 rows — these rows as CSV