PREVIEW / etf_daily / 2024-10-16
file: by_date/etf_daily/2024/2024-10-16.parquet size: 142 KB rows: 3,743
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-16 | SPY | ETF | 579.78 | 582.83 | 578.96 | 582.3 | 30756316.0 |
| 2024-10-16 | QQQ | ETF | 491.18 | 491.69 | 487.57 | 490.91 | 22996776.0 |
| 2024-10-16 | IWM | ETF | 224.89 | 227.17 | 224.39 | 226.74 | 27558758.0 |
| 2024-10-16 | DIA | ETF | 427.18 | 431.08 | 426.92 | 430.72 | 2581451.0 |
| 2024-10-16 | GLD | ETF | 247.62 | 248.09 | 246.36 | 247.15 | 5426838.0 |
| 2024-10-16 | TLT | ETF | 95.39 | 95.62 | 95.14 | 95.31 | 31476384.0 |
| 2024-10-16 | AAA | ETF | 25.11 | 25.11 | 25.0501 | 25.09 | 3411.0 |
| 2024-10-16 | AAAU | ETF | 26.52 | 26.554 | 26.375 | 26.455 | 2015676.0 |
| 2024-10-16 | AADR | ETF | 65.59 | 65.59 | 65.0939 | 65.0939 | 389.0 |
| 2024-10-16 | AAPB | ETF | 29.53 | 29.59 | 29.05 | 29.49 | 92863.0 |
| 2024-10-16 | AAPD | ETF | 16.54 | 16.66 | 16.52 | 16.54 | 178710.0 |
| 2024-10-16 | AAPR | ETF | 26.2 | 26.265 | 26.2 | 26.255 | 12600.0 |
| 2024-10-16 | AAPU | ETF | 37.375 | 37.49 | 36.76 | 37.35 | 538294.0 |
| 2024-10-16 | AAPX | ETF | 34.005 | 34.09 | 33.5 | 34.0246 | 9267.0 |
| 2024-10-16 | AAPY | ETF | 27.7564 | 27.7564 | 27.7564 | 27.7564 | 183.0 |
| 2024-10-16 | AAXJ | ETF | 77.69 | 78.16 | 77.69 | 77.92 | 355360.0 |
| 2024-10-16 | ABCS | ETF | 28.695 | 28.8013 | 28.695 | 28.8013 | 1514.0 |
| 2024-10-16 | ABEQ | ETF | 32.9406 | 33.03 | 32.94 | 32.9478 | 5985.0 |
| 2024-10-16 | ABNY | ETF | 85.1 | 86.15 | 84.9005 | 85.5 | 4422.0 |
| 2024-10-16 | ACES | ETF | 28.56 | 29.13 | 28.53 | 29.12 | 59043.0 |
| 2024-10-16 | ACIO | ETF | 40.2 | 40.34 | 40.085 | 40.31 | 153088.0 |
| 2024-10-16 | ACSI | ETF | 58.6569 | 58.6569 | 58.6569 | 58.6569 | 15.0 |
| 2024-10-16 | ACT | ETF | 36.62 | 36.86 | 36.54 | 36.7 | 187511.0 |
| 2024-10-16 | ACTV | ETF | 34.485 | 34.65 | 34.485 | 34.65 | 6114.0 |
| 2024-10-16 | ACTX | ETF | 0.0001 | 0.0001 | 0.0001 | 0.0001 | 860.0 |
| 2024-10-16 | ACVF | ETF | 44.28 | 45.0 | 44.26 | 44.4384 | 4355.0 |
| 2024-10-16 | ACWI | ETF | 119.57 | 120.09 | 119.51 | 120.0 | 1472165.0 |
| 2024-10-16 | ACWV | ETF | 114.66 | 115.27 | 114.65 | 115.13 | 56438.0 |
| 2024-10-16 | ACWX | ETF | 55.9 | 56.05 | 55.9 | 56.02 | 303659.0 |
| 2024-10-16 | ADFI | ETF | 8.66 | 8.71 | 8.66 | 8.7 | 7695.0 |
| 2024-10-16 | ADIV | ETF | 16.1101 | 16.15 | 16.1101 | 16.15 | 2941.0 |
| 2024-10-16 | ADME | ETF | 46.57 | 46.93 | 46.57 | 46.91 | 15950.0 |
| 2024-10-16 | ADPV | ETF | 33.39 | 33.39 | 33.3733 | 33.3812 | 625.0 |
| 2024-10-16 | ADVE | ETF | 35.266 | 35.266 | 35.266 | 35.266 | 55.0 |
| 2024-10-16 | AESR | ETF | 17.2 | 17.25 | 17.14 | 17.24 | 15407.0 |
| 2024-10-16 | AETH | ETF | 33.72 | 33.8258 | 33.435 | 33.5956 | 21824.0 |
| 2024-10-16 | AFIF | ETF | 9.2087 | 9.21 | 9.2 | 9.205 | 9990.0 |
| 2024-10-16 | AFK | ETF | 16.8 | 16.8 | 16.49 | 16.57 | 5548.0 |
| 2024-10-16 | AFLG | ETF | 34.57 | 34.69 | 34.53 | 34.6864 | 5119.0 |
| 2024-10-16 | AFMC | ETF | 32.95 | 32.95 | 32.9094 | 32.9094 | 1946.0 |
| 2024-10-16 | AFSM | ETF | 31.275 | 31.588 | 31.275 | 31.5 | 54807.0 |
| 2024-10-16 | AGG | ETF | 99.96 | 100.04 | 99.87 | 99.94 | 4734080.0 |
| 2024-10-16 | AGGH | ETF | 21.37 | 21.37 | 21.21 | 21.33 | 109581.0 |
| 2024-10-16 | AGGS | ETF | 41.9451 | 41.9451 | 41.9451 | 41.9451 | 0.0 |
| 2024-10-16 | AGGY | ETF | 44.34 | 44.37 | 44.31 | 44.37 | 80830.0 |
| 2024-10-16 | AGIH | ETF | 24.9791 | 24.9791 | 24.9791 | 24.9791 | 10.0 |
| 2024-10-16 | AGIX | ETF | 26.16 | 26.16 | 25.97 | 26.0692 | 4593.0 |
| 2024-10-16 | AGMI | ETF | 30.27 | 30.27 | 29.96 | 29.96 | 105.0 |
| 2024-10-16 | AGNG | ETF | 32.862 | 32.862 | 32.76 | 32.76 | 65830.0 |
| 2024-10-16 | AGOX | ETF | 29.245 | 29.49 | 29.22 | 29.411 | 17277.0 |
> showing 50 of 3,743 rows — these rows as CSV