PREVIEW / etf_daily / 2024-08-15
file: by_date/etf_daily/2024/2024-08-15.parquet size: 132 KB rows: 3,444
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-08-15 | SPY | ETF | 549.5 | 553.36 | 548.88 | 553.07 | 60675769.0 |
| 2024-08-15 | QQQ | ETF | 468.76 | 474.82 | 468.38 | 474.42 | 38280565.0 |
| 2024-08-15 | IWM | ETF | 211.26 | 213.1 | 209.91 | 212.04 | 42506831.0 |
| 2024-08-15 | DIA | ETF | 404.74 | 406.14 | 403.18 | 405.88 | 3759553.0 |
| 2024-08-15 | GLD | ETF | 226.51 | 227.5 | 225.12 | 226.91 | 5163352.0 |
| 2024-08-15 | TLT | ETF | 96.405 | 97.1 | 96.21 | 97.1 | 38592158.0 |
| 2024-08-15 | AAA | ETF | 25.045 | 25.0636 | 25.02 | 25.04 | 3970.0 |
| 2024-08-15 | AAAU | ETF | 24.24 | 24.35 | 24.09 | 24.28 | 1288297.0 |
| 2024-08-15 | AADR | ETF | 62.07 | 62.195 | 61.99 | 61.99 | 3450.0 |
| 2024-08-15 | AAPB | ETF | 28.32 | 28.48 | 27.94 | 28.325 | 61937.0 |
| 2024-08-15 | AAPD | ETF | 17.09 | 17.24 | 17.0413 | 17.09 | 665927.0 |
| 2024-08-15 | AAPR | ETF | 25.62 | 25.67 | 25.62 | 25.6526 | 1826.0 |
| 2024-08-15 | AAPU | ETF | 36.29 | 36.49 | 35.71 | 36.28 | 375447.0 |
| 2024-08-15 | AAPX | ETF | 32.73 | 32.98 | 32.36 | 32.88 | 13857.0 |
| 2024-08-15 | AAPY | ETF | 27.3601 | 27.44 | 27.3393 | 27.3393 | 2088.0 |
| 2024-08-15 | AAXJ | ETF | 71.47 | 72.1 | 71.47 | 71.95 | 139459.0 |
| 2024-08-15 | ABCS | ETF | 27.1104 | 27.204 | 27.06 | 27.1411 | 2401.0 |
| 2024-08-15 | ABEQ | ETF | 31.38 | 31.485 | 31.38 | 31.47 | 10635.0 |
| 2024-08-15 | ABNY | ETF | 81.3 | 81.3 | 79.4865 | 79.905 | 659.0 |
| 2024-08-15 | ACES | ETF | 27.89 | 28.45 | 27.89 | 28.24 | 25766.0 |
| 2024-08-15 | ACIO | ETF | 38.43 | 38.7099 | 38.39 | 38.7 | 97736.0 |
| 2024-08-15 | ACSI | ETF | 55.857 | 55.857 | 55.857 | 55.857 | 28.0 |
| 2024-08-15 | ACT | ETF | 33.68 | 33.97 | 33.565 | 33.94 | 185431.0 |
| 2024-08-15 | ACTV | ETF | 32.02 | 32.2 | 31.995 | 32.11 | 13589.0 |
| 2024-08-15 | ACVF | ETF | 41.73 | 42.0 | 41.728 | 41.9846 | 3388.0 |
| 2024-08-15 | ACWI | ETF | 113.68 | 114.42 | 113.67 | 114.4 | 859658.0 |
| 2024-08-15 | ACWV | ETF | 109.93 | 110.11 | 109.6892 | 109.92 | 107341.0 |
| 2024-08-15 | ACWX | ETF | 53.99 | 54.26 | 53.9183 | 54.18 | 734912.0 |
| 2024-08-15 | ADFI | ETF | 8.6699 | 8.69 | 8.64 | 8.69 | 5067.0 |
| 2024-08-15 | ADIV | ETF | 14.88 | 14.88 | 14.88 | 14.88 | 437.0 |
| 2024-08-15 | ADME | ETF | 44.5528 | 44.8199 | 44.5528 | 44.7348 | 4015.0 |
| 2024-08-15 | ADPV | ETF | 30.72 | 30.8658 | 30.72 | 30.7978 | 1690.0 |
| 2024-08-15 | AEMB | ETF | 39.45 | 39.46 | 39.2727 | 39.2727 | 200.0 |
| 2024-08-15 | AESR | ETF | 16.38 | 16.49 | 16.38 | 16.49 | 17910.0 |
| 2024-08-15 | AETH | ETF | 34.4 | 34.4626 | 32.75 | 33.13 | 6544.0 |
| 2024-08-15 | AFIF | ETF | 9.1 | 9.1652 | 9.1 | 9.155 | 7149.0 |
| 2024-08-15 | AFK | ETF | 15.88 | 16.02 | 15.75 | 16.02 | 23503.0 |
| 2024-08-15 | AFLG | ETF | 32.32 | 32.4594 | 32.23 | 32.381 | 13133.0 |
| 2024-08-15 | AFMC | ETF | 30.4335 | 30.53 | 30.35 | 30.4381 | 1144.0 |
| 2024-08-15 | AFSM | ETF | 29.37 | 29.59 | 29.22 | 29.432 | 2911.0 |
| 2024-08-15 | AFTY | ETF | 13.97 | 13.9851 | 13.97 | 13.9851 | 136.0 |
| 2024-08-15 | AGG | ETF | 99.7 | 99.9 | 99.65 | 99.88 | 8617198.0 |
| 2024-08-15 | AGGH | ETF | 21.59 | 21.59 | 21.4 | 21.42 | 88995.0 |
| 2024-08-15 | AGGY | ETF | 44.14 | 44.24 | 44.13 | 44.24 | 67914.0 |
| 2024-08-15 | AGIX | ETF | 24.555 | 24.75 | 24.55 | 24.7475 | 7276.0 |
| 2024-08-15 | AGMI | ETF | 25.887 | 25.887 | 25.887 | 25.887 | 46.0 |
| 2024-08-15 | AGNG | ETF | 31.9382 | 32.08 | 31.8771 | 31.96 | 3831.0 |
| 2024-08-15 | AGOX | ETF | 28.13 | 29.25 | 28.13 | 29.1345 | 86156.0 |
| 2024-08-15 | AGQ | ETF | 34.06 | 34.6584 | 33.255 | 34.22 | 2077638.0 |
| 2024-08-15 | AGQI | ETF | 14.201 | 14.27 | 14.201 | 14.2599 | 4976.0 |
> showing 50 of 3,444 rows — these rows as CSV