PREVIEW / etf_daily / 2024-09-19
file: by_date/etf_daily/2024/2024-09-19.parquet size: 136 KB rows: 3,541
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-09-19 | SPY | ETF | 571.01 | 572.88 | 568.08 | 570.98 | 74712142.0 |
| 2024-09-19 | QQQ | ETF | 482.61 | 486.23 | 480.49 | 483.36 | 52782523.0 |
| 2024-09-19 | IWM | ETF | 224.66 | 224.68 | 221.5 | 223.97 | 34775941.0 |
| 2024-09-19 | DIA | ETF | 421.98 | 422.78 | 419.38 | 421.41 | 4141267.0 |
| 2024-09-19 | GLD | ETF | 238.24 | 239.515 | 237.39 | 239.17 | 6106090.0 |
| 2024-09-19 | TLT | ETF | 98.92 | 99.31 | 98.77 | 99.26 | 39173096.0 |
| 2024-09-19 | AAA | ETF | 25.11 | 25.11 | 25.04 | 25.06 | 3038.0 |
| 2024-09-19 | AAAU | ETF | 25.51 | 25.6399 | 25.4151 | 25.6 | 2739337.0 |
| 2024-09-19 | AADR | ETF | 63.27 | 64.33 | 63.27 | 64.25 | 2388.0 |
| 2024-09-19 | AAPB | ETF | 28.07 | 29.2299 | 28.03 | 29.05 | 77086.0 |
| 2024-09-19 | AAPD | ETF | 17.16 | 17.18 | 16.79 | 16.85 | 453563.0 |
| 2024-09-19 | AAPR | ETF | 26.12 | 26.16 | 26.12 | 26.1543 | 1765.0 |
| 2024-09-19 | AAPU | ETF | 35.95 | 37.4105 | 35.8 | 37.12 | 936844.0 |
| 2024-09-19 | AAPX | ETF | 32.46 | 33.79 | 32.46 | 33.575 | 19285.0 |
| 2024-09-19 | AAPY | ETF | 27.74 | 27.88 | 27.6101 | 27.6883 | 2443.0 |
| 2024-09-19 | AAXJ | ETF | 73.54 | 74.07 | 73.22 | 73.92 | 333802.0 |
| 2024-09-19 | ABCS | ETF | 28.42 | 28.42 | 28.3957 | 28.3957 | 1100.0 |
| 2024-09-19 | ABEQ | ETF | 32.63 | 32.67 | 32.03 | 32.03 | 14884.0 |
| 2024-09-19 | ABNY | ETF | 82.1995 | 82.1995 | 81.75 | 82.1445 | 1817.0 |
| 2024-09-19 | ACES | ETF | 29.57 | 29.57 | 28.93 | 28.9804 | 8610.0 |
| 2024-09-19 | ACIO | ETF | 39.56 | 39.84 | 39.4592 | 39.64 | 171725.0 |
| 2024-09-19 | ACSI | ETF | 57.7 | 57.83 | 57.5166 | 57.5166 | 683.0 |
| 2024-09-19 | ACT | ETF | 36.87 | 37.085 | 36.35 | 36.99 | 405706.0 |
| 2024-09-19 | ACTV | ETF | 33.81 | 34.025 | 33.681 | 33.71 | 9497.0 |
| 2024-09-19 | ACVF | ETF | 43.34 | 43.4898 | 43.2701 | 43.3222 | 6698.0 |
| 2024-09-19 | ACWI | ETF | 118.19 | 118.5726 | 117.55 | 118.23 | 2830527.0 |
| 2024-09-19 | ACWV | ETF | 113.96 | 113.96 | 113.23 | 113.51 | 146283.0 |
| 2024-09-19 | ACWX | ETF | 56.12 | 56.245 | 55.71 | 56.14 | 363967.0 |
| 2024-09-19 | ADFI | ETF | 8.8 | 8.82 | 8.79 | 8.82 | 10811.0 |
| 2024-09-19 | ADIV | ETF | 15.54 | 15.54 | 15.525 | 15.525 | 596.0 |
| 2024-09-19 | ADME | ETF | 45.84 | 46.12 | 45.84 | 45.9849 | 5882.0 |
| 2024-09-19 | ADPV | ETF | 32.1 | 32.3 | 32.1 | 32.256 | 914.0 |
| 2024-09-19 | AEMB | ETF | 39.01 | 39.3775 | 39.01 | 39.3775 | 4009.0 |
| 2024-09-19 | AESR | ETF | 16.78 | 16.92 | 16.78 | 16.859 | 34996.0 |
| 2024-09-19 | AETH | ETF | 31.539 | 32.0 | 31.3399 | 31.7488 | 6584.0 |
| 2024-09-19 | AFIF | ETF | 9.21 | 9.21 | 9.1701 | 9.21 | 65186.0 |
| 2024-09-19 | AFK | ETF | 16.88 | 16.88 | 16.47 | 16.82 | 11005.0 |
| 2024-09-19 | AFLG | ETF | 33.69 | 33.77 | 33.612 | 33.69 | 14935.0 |
| 2024-09-19 | AFMC | ETF | 31.87 | 31.9834 | 31.83 | 31.9834 | 774.0 |
| 2024-09-19 | AFSM | ETF | 30.8599 | 30.97 | 30.8001 | 30.97 | 11338.0 |
| 2024-09-19 | AFTY | ETF | 13.6 | 13.64 | 13.57 | 13.6091 | 2327.0 |
| 2024-09-19 | AGG | ETF | 101.41 | 101.6101 | 101.3701 | 101.57 | 4902848.0 |
| 2024-09-19 | AGGH | ETF | 21.81 | 21.98 | 21.7787 | 21.98 | 233546.0 |
| 2024-09-19 | AGGS | ETF | 42.635 | 42.635 | 42.62 | 42.6275 | 301.0 |
| 2024-09-19 | AGGY | ETF | 44.97 | 45.036 | 44.94 | 45.01 | 69485.0 |
| 2024-09-19 | AGIX | ETF | 24.9 | 25.19 | 24.9 | 25.09 | 5207.0 |
| 2024-09-19 | AGMI | ETF | 27.75 | 27.9329 | 27.72 | 27.9329 | 385.0 |
| 2024-09-19 | AGNG | ETF | 33.01 | 33.12 | 33.0099 | 33.12 | 2301.0 |
| 2024-09-19 | AGOX | ETF | 28.93 | 29.15 | 28.66 | 28.66 | 25614.0 |
| 2024-09-19 | AGQ | ETF | 40.21 | 40.6 | 39.28 | 39.81 | 2330132.0 |
> showing 50 of 3,541 rows — these rows as CSV