PREVIEW / etf_daily / 2024-07-12
file: by_date/etf_daily/2024/2024-07-12.parquet size: 132 KB rows: 3,428
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-12 | SPY | ETF | 557.63 | 563.67 | 557.15 | 559.99 | 51994655.0 |
| 2024-07-12 | QQQ | ETF | 492.51 | 499.62 | 492.04 | 494.82 | 37109399.0 |
| 2024-07-12 | IWM | ETF | 212.92 | 214.94 | 212.66 | 213.14 | 50761295.0 |
| 2024-07-12 | DIA | ETF | 398.86 | 402.69 | 398.12 | 400.32 | 4710394.0 |
| 2024-07-12 | GLD | ETF | 222.03 | 223.62 | 221.86 | 223.11 | 5169602.0 |
| 2024-07-12 | TLT | ETF | 93.53 | 93.94 | 93.34 | 93.94 | 27587130.0 |
| 2024-07-12 | AAA | ETF | 25.11 | 25.11 | 25.0401 | 25.084 | 4384.0 |
| 2024-07-12 | AAAU | ETF | 23.755 | 23.927 | 23.74 | 23.87 | 2067033.0 |
| 2024-07-12 | AADR | ETF | 63.59 | 63.6 | 63.57 | 63.6 | 277.0 |
| 2024-07-12 | AAPB | ETF | 29.78 | 30.7099 | 29.77 | 30.23 | 217346.0 |
| 2024-07-12 | AAPD | ETF | 16.79 | 16.8 | 16.52 | 16.66 | 246832.0 |
| 2024-07-12 | AAPR | ETF | 25.58 | 25.596 | 25.5434 | 25.5434 | 1526.0 |
| 2024-07-12 | AAPU | ETF | 38.22 | 39.43 | 38.13 | 38.74 | 1267818.0 |
| 2024-07-12 | AAPX | ETF | 34.6 | 35.7 | 34.6 | 35.2 | 33177.0 |
| 2024-07-12 | AAPY | ETF | 27.61 | 27.6165 | 27.61 | 27.6165 | 557.0 |
| 2024-07-12 | AAXJ | ETF | 75.31 | 75.6 | 75.23 | 75.25 | 618540.0 |
| 2024-07-12 | ABCS | ETF | 26.75 | 26.815 | 26.7323 | 26.7323 | 2200.0 |
| 2024-07-12 | ABEQ | ETF | 30.85 | 31.05 | 30.85 | 30.98 | 4384.0 |
| 2024-07-12 | ABNY | ETF | 101.35 | 101.8 | 100.45 | 100.627 | 1713.0 |
| 2024-07-12 | ACES | ETF | 31.35 | 32.38 | 31.33 | 32.24 | 195057.0 |
| 2024-07-12 | ACIO | ETF | 38.44 | 38.79 | 38.44 | 38.57 | 66204.0 |
| 2024-07-12 | ACSI | ETF | 56.07 | 56.53 | 56.07 | 56.3075 | 579.0 |
| 2024-07-12 | ACT | ETF | 31.57 | 31.89 | 31.37 | 31.61 | 125802.0 |
| 2024-07-12 | ACTV | ETF | 32.78 | 33.09 | 32.78 | 32.8708 | 6409.0 |
| 2024-07-12 | ACVF | ETF | 42.3 | 42.52 | 42.2772 | 42.2772 | 10933.0 |
| 2024-07-12 | ACWI | ETF | 115.69 | 116.805 | 115.69 | 116.19 | 1776472.0 |
| 2024-07-12 | ACWV | ETF | 106.88 | 107.51 | 106.88 | 107.22 | 337791.0 |
| 2024-07-12 | ACWX | ETF | 55.25 | 55.57 | 55.25 | 55.41 | 782242.0 |
| 2024-07-12 | ADFI | ETF | 8.56 | 8.59 | 8.56 | 8.565 | 4376.0 |
| 2024-07-12 | ADIV | ETF | 15.1294 | 15.1294 | 15.1294 | 15.1294 | 63.0 |
| 2024-07-12 | ADME | ETF | 44.676 | 45.1801 | 44.676 | 44.865 | 7418.0 |
| 2024-07-12 | ADPV | ETF | 31.265 | 31.3 | 31.2335 | 31.2335 | 649.0 |
| 2024-07-12 | AEMB | ETF | 39.04 | 39.04 | 38.988 | 38.988 | 217.0 |
| 2024-07-12 | AESR | ETF | 16.69 | 16.882 | 16.69 | 16.7593 | 12998.0 |
| 2024-07-12 | AETH | ETF | 40.869 | 41.15 | 40.7784 | 40.7784 | 2606.0 |
| 2024-07-12 | AFIF | ETF | 9.17 | 9.18 | 9.165 | 9.165 | 2683.0 |
| 2024-07-12 | AFK | ETF | 16.75 | 16.85 | 16.51 | 16.82 | 12811.0 |
| 2024-07-12 | AFLG | ETF | 32.58 | 32.6635 | 32.4769 | 32.4769 | 1173.0 |
| 2024-07-12 | AFMC | ETF | 30.28 | 30.4 | 30.16 | 30.2177 | 4312.0 |
| 2024-07-12 | AFSM | ETF | 29.42 | 29.5116 | 29.28 | 29.3517 | 19247.0 |
| 2024-07-12 | AFTY | ETF | 14.24 | 14.24 | 14.2 | 14.2099 | 750.0 |
| 2024-07-12 | AGG | ETF | 98.17 | 98.39 | 98.1302 | 98.39 | 6302832.0 |
| 2024-07-12 | AGGH | ETF | 21.13 | 21.15 | 21.06 | 21.11 | 144722.0 |
| 2024-07-12 | AGGS | ETF | 41.41 | 41.41 | 41.3791 | 41.3791 | 161.0 |
| 2024-07-12 | AGGY | ETF | 43.57 | 43.66 | 43.53 | 43.66 | 158188.0 |
| 2024-07-12 | AGMI | ETF | 28.88 | 29.25 | 28.88 | 29.25 | 2586.0 |
| 2024-07-12 | AGNG | ETF | 31.14 | 31.24 | 31.14 | 31.18 | 2733.0 |
| 2024-07-12 | AGOX | ETF | 28.67 | 28.99 | 28.63 | 28.75 | 27925.0 |
| 2024-07-12 | AGQ | ETF | 40.82 | 41.7276 | 40.66 | 41.19 | 1439136.0 |
| 2024-07-12 | AGQI | ETF | 14.79 | 14.79 | 14.71 | 14.71 | 12250.0 |
> showing 50 of 3,428 rows — these rows as CSV