PREVIEW / etf_daily / 2024-10-04
file: by_date/etf_daily/2024/2024-10-04.parquet size: 137 KB rows: 3,597
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-04 | SPY | ETF | 572.35 | 573.36 | 568.1 | 572.98 | 42949020.0 |
| 2024-10-04 | QQQ | ETF | 487.45 | 487.88 | 482.385 | 487.32 | 30744909.0 |
| 2024-10-04 | IWM | ETF | 219.29 | 219.98 | 217.29 | 219.15 | 27340790.0 |
| 2024-10-04 | DIA | ETF | 422.37 | 423.61 | 419.66 | 423.41 | 2520263.0 |
| 2024-10-04 | GLD | ETF | 245.0 | 246.69 | 244.045 | 245.0 | 5929331.0 |
| 2024-10-04 | TLT | ETF | 95.44 | 95.96 | 95.4 | 95.55 | 55658138.0 |
| 2024-10-04 | AAA | ETF | 25.05 | 25.065 | 25.0099 | 25.05 | 6386.0 |
| 2024-10-04 | AAAU | ETF | 26.23 | 26.4006 | 26.13 | 26.225 | 2581827.0 |
| 2024-10-04 | AADR | ETF | 63.53 | 64.05 | 63.53 | 64.05 | 426.0 |
| 2024-10-04 | AAPB | ETF | 28.64 | 28.64 | 27.72 | 28.37 | 91705.0 |
| 2024-10-04 | AAPD | ETF | 16.82 | 17.09 | 16.8 | 16.89 | 218609.0 |
| 2024-10-04 | AAPR | ETF | 26.14 | 26.1698 | 26.1 | 26.1698 | 20498.0 |
| 2024-10-04 | AAPU | ETF | 36.3 | 36.3 | 35.12 | 35.94 | 422701.0 |
| 2024-10-04 | AAPX | ETF | 32.85 | 32.91 | 32.02 | 32.78 | 13957.0 |
| 2024-10-04 | AAPY | ETF | 26.93 | 27.1975 | 26.93 | 27.1975 | 884.0 |
| 2024-10-04 | AAXJ | ETF | 80.85 | 81.105 | 80.47 | 81.05 | 751792.0 |
| 2024-10-04 | ABCS | ETF | 28.2 | 28.26 | 28.06 | 28.26 | 2763.0 |
| 2024-10-04 | ABEQ | ETF | 32.4032 | 32.5295 | 32.4032 | 32.5295 | 10133.0 |
| 2024-10-04 | ABNY | ETF | 81.45 | 82.4 | 81.325 | 82.351 | 1280.0 |
| 2024-10-04 | ACES | ETF | 28.49 | 28.7 | 28.32 | 28.61 | 16510.0 |
| 2024-10-04 | ACIO | ETF | 39.74 | 39.8 | 39.49 | 39.76 | 142519.0 |
| 2024-10-04 | ACSI | ETF | 57.9988 | 57.9988 | 57.9988 | 57.9988 | 137.0 |
| 2024-10-04 | ACT | ETF | 36.07 | 36.325 | 35.93 | 36.26 | 309224.0 |
| 2024-10-04 | ACTV | ETF | 33.8201 | 33.8785 | 33.8201 | 33.8785 | 1781.0 |
| 2024-10-04 | ACVF | ETF | 43.61 | 43.62 | 43.38 | 43.5519 | 1576.0 |
| 2024-10-04 | ACWI | ETF | 119.24 | 119.575 | 118.63 | 119.48 | 907121.0 |
| 2024-10-04 | ACWV | ETF | 114.03 | 114.22 | 113.67 | 114.16 | 67225.0 |
| 2024-10-04 | ACWX | ETF | 56.83 | 57.06 | 56.73 | 57.05 | 560479.0 |
| 2024-10-04 | ADFI | ETF | 8.71 | 8.73 | 8.65 | 8.66 | 12781.0 |
| 2024-10-04 | ADIV | ETF | 16.82 | 16.99 | 16.82 | 16.9052 | 7671.0 |
| 2024-10-04 | ADME | ETF | 45.93 | 46.21 | 45.93 | 46.21 | 7345.0 |
| 2024-10-04 | ADPV | ETF | 31.77 | 31.8469 | 31.61 | 31.8469 | 2796.0 |
| 2024-10-04 | AESR | ETF | 16.91 | 17.0148 | 16.91 | 17.0148 | 8684.0 |
| 2024-10-04 | AETH | ETF | 30.62 | 31.315 | 30.54 | 31.1976 | 3001.0 |
| 2024-10-04 | AFIF | ETF | 9.21 | 9.24 | 9.21 | 9.22 | 40707.0 |
| 2024-10-04 | AFK | ETF | 16.88 | 17.1799 | 16.81 | 16.87 | 4220.0 |
| 2024-10-04 | AFLG | ETF | 33.97 | 34.17 | 33.88 | 34.17 | 3957.0 |
| 2024-10-04 | AFMC | ETF | 31.9993 | 32.0888 | 31.9993 | 32.0888 | 349.0 |
| 2024-10-04 | AFSM | ETF | 30.68 | 30.74 | 30.43 | 30.64 | 14187.0 |
| 2024-10-04 | AFTY | ETF | 16.4 | 16.43 | 16.31 | 16.34 | 69402.0 |
| 2024-10-04 | AGG | ETF | 100.1 | 100.14 | 99.8901 | 99.96 | 9629556.0 |
| 2024-10-04 | AGGH | ETF | 21.55 | 21.55 | 21.4 | 21.4 | 70956.0 |
| 2024-10-04 | AGGY | ETF | 44.38 | 44.4292 | 44.335 | 44.35 | 1293247.0 |
| 2024-10-04 | AGIX | ETF | 25.5 | 25.5451 | 25.23 | 25.5451 | 1223.0 |
| 2024-10-04 | AGMI | ETF | 30.05 | 30.05 | 29.8776 | 29.8776 | 194.0 |
| 2024-10-04 | AGNG | ETF | 32.44 | 32.5 | 32.41 | 32.5 | 1372.0 |
| 2024-10-04 | AGOX | ETF | 28.75 | 29.02 | 28.69 | 29.02 | 13809.0 |
| 2024-10-04 | AGQ | ETF | 42.71 | 45.195 | 41.97 | 43.13 | 3478345.0 |
| 2024-10-04 | AGQI | ETF | 14.44 | 14.4814 | 14.43 | 14.4814 | 16563.0 |
| 2024-10-04 | AGRH | ETF | 25.88 | 25.88 | 25.88 | 25.88 | 620.0 |
> showing 50 of 3,597 rows — these rows as CSV