PREVIEW / etf_daily / 2024-07-30
file: by_date/etf_daily/2024/2024-07-30.parquet size: 132 KB rows: 3,427
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-07-30 | SPY | ETF | 546.26 | 547.34 | 538.515 | 542.0 | 46331728.0 |
| 2024-07-30 | QQQ | ETF | 465.85 | 466.561 | 454.15 | 457.53 | 41317210.0 |
| 2024-07-30 | IWM | ETF | 222.72 | 224.46 | 221.11 | 222.57 | 26806621.0 |
| 2024-07-30 | DIA | ETF | 405.87 | 408.72 | 405.28 | 407.41 | 2549681.0 |
| 2024-07-30 | GLD | ETF | 221.41 | 222.92 | 220.355 | 222.52 | 4822453.0 |
| 2024-07-30 | TLT | ETF | 93.75 | 94.05 | 93.3 | 93.85 | 28095287.0 |
| 2024-07-30 | AAA | ETF | 25.1037 | 25.1944 | 25.1001 | 25.1188 | 2423.0 |
| 2024-07-30 | AAAU | ETF | 23.69 | 23.8509 | 23.575 | 23.815 | 3047913.0 |
| 2024-07-30 | AADR | ETF | 60.9481 | 61.111 | 60.72 | 60.72 | 242.0 |
| 2024-07-30 | AAPB | ETF | 27.14 | 27.39 | 26.38 | 27.01 | 61109.0 |
| 2024-07-30 | AAPD | ETF | 17.56 | 17.8 | 17.47 | 17.59 | 181426.0 |
| 2024-07-30 | AAPR | ETF | 25.43 | 25.43 | 25.3 | 25.3506 | 1650.0 |
| 2024-07-30 | AAPU | ETF | 34.78 | 35.13 | 33.81 | 34.6 | 517393.0 |
| 2024-07-30 | AAPX | ETF | 31.505 | 31.82 | 30.65 | 31.4 | 18723.0 |
| 2024-07-30 | AAPY | ETF | 26.5902 | 26.6321 | 26.5902 | 26.6321 | 372.0 |
| 2024-07-30 | AAXJ | ETF | 71.01 | 71.04 | 70.4 | 70.62 | 428952.0 |
| 2024-07-30 | ABCS | ETF | 27.71 | 27.71 | 27.535 | 27.6508 | 2400.0 |
| 2024-07-30 | ABEQ | ETF | 31.3701 | 31.39 | 31.3701 | 31.3847 | 392.0 |
| 2024-07-30 | ABNY | ETF | 96.65 | 97.1715 | 96.6 | 97.1715 | 175.0 |
| 2024-07-30 | ACES | ETF | 29.9 | 30.01 | 29.28 | 29.53 | 39422.0 |
| 2024-07-30 | ACIO | ETF | 37.92 | 38.02 | 37.6 | 37.7 | 65279.0 |
| 2024-07-30 | ACSI | ETF | 55.6595 | 55.6595 | 55.6595 | 55.6595 | 58.0 |
| 2024-07-30 | ACT | ETF | 34.33 | 34.49 | 34.16 | 34.29 | 142104.0 |
| 2024-07-30 | ACTV | ETF | 34.14 | 34.3422 | 34.14 | 34.3422 | 5972.0 |
| 2024-07-30 | ACVF | ETF | 41.43 | 41.51 | 41.0 | 41.13 | 7895.0 |
| 2024-07-30 | ACWI | ETF | 112.9 | 113.15 | 111.69 | 112.29 | 2302624.0 |
| 2024-07-30 | ACWV | ETF | 107.9 | 108.24 | 107.75 | 108.05 | 110350.0 |
| 2024-07-30 | ACWX | ETF | 53.49 | 53.6 | 53.23 | 53.41 | 440575.0 |
| 2024-07-30 | ADFI | ETF | 8.55 | 8.7344 | 8.52 | 8.56 | 11328.0 |
| 2024-07-30 | ADIV | ETF | 14.34 | 14.34 | 14.3076 | 14.3076 | 498.0 |
| 2024-07-30 | ADME | ETF | 43.8598 | 43.8598 | 43.49 | 43.639 | 9674.0 |
| 2024-07-30 | ADPV | ETF | 30.885 | 30.885 | 30.76 | 30.8597 | 4209.0 |
| 2024-07-30 | AEMB | ETF | 38.7688 | 38.7688 | 38.7688 | 38.7688 | 40.0 |
| 2024-07-30 | AESR | ETF | 15.87 | 15.94 | 15.87 | 15.9274 | 7142.0 |
| 2024-07-30 | AETH | ETF | 43.4 | 43.56 | 42.43 | 42.5845 | 5491.0 |
| 2024-07-30 | AFIF | ETF | 9.14 | 9.15 | 9.14 | 9.145 | 20991.0 |
| 2024-07-30 | AFK | ETF | 15.82 | 16.05 | 15.811 | 16.0 | 71768.0 |
| 2024-07-30 | AFLG | ETF | 31.9 | 31.9 | 31.83 | 31.84 | 9162.0 |
| 2024-07-30 | AFMC | ETF | 31.46 | 31.46 | 31.27 | 31.3157 | 1077.0 |
| 2024-07-30 | AFSM | ETF | 30.7601 | 31.08 | 30.6279 | 30.7531 | 17205.0 |
| 2024-07-30 | AFTY | ETF | 13.805 | 13.805 | 13.805 | 13.805 | 286.0 |
| 2024-07-30 | AGG | ETF | 98.52 | 98.64 | 98.38 | 98.58 | 5825061.0 |
| 2024-07-30 | AGGH | ETF | 21.01 | 21.14 | 21.01 | 21.11 | 97000.0 |
| 2024-07-30 | AGGY | ETF | 43.52 | 43.52 | 43.44 | 43.48 | 48497.0 |
| 2024-07-30 | AGIX | ETF | 24.26 | 24.29 | 23.39 | 23.4636 | 44664.0 |
| 2024-07-30 | AGMI | ETF | 26.99 | 27.0978 | 26.99 | 27.0978 | 601.0 |
| 2024-07-30 | AGNG | ETF | 31.19 | 31.19 | 31.0483 | 31.1465 | 1901.0 |
| 2024-07-30 | AGOX | ETF | 27.41 | 27.86 | 27.41 | 27.7494 | 56227.0 |
| 2024-07-30 | AGQ | ETF | 33.78 | 34.74 | 33.24 | 34.51 | 1195486.0 |
| 2024-07-30 | AGQI | ETF | 14.27 | 14.2704 | 14.14 | 14.2095 | 13402.0 |
> showing 50 of 3,427 rows — these rows as CSV