PREVIEW / etf_daily / 2024-04-22
file: by_date/etf_daily/2024/2024-04-22.parquet size: 119 KB rows: 3,329
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-04-22 | SPY | ETF | 497.83 | 502.38 | 495.43 | 499.72 | 67961000.0 |
| 2024-04-22 | QQQ | ETF | 417.31 | 421.18 | 413.94 | 418.82 | 47807663.0 |
| 2024-04-22 | IWM | ETF | 194.21 | 196.3 | 192.9 | 195.3 | 31553000.0 |
| 2024-04-22 | DIA | ETF | 381.73 | 384.44 | 379.81 | 382.37 | 4129000.0 |
| 2024-04-22 | GLD | ETF | 216.35 | 216.96 | 215.14 | 215.57 | 13404300.0 |
| 2024-04-22 | TLT | ETF | 88.68 | 89.12 | 88.65 | 89.0 | 24969000.0 |
| 2024-04-22 | AAA | ETF | 25.15 | 25.15 | 25.14 | 25.145 | 4200.0 |
| 2024-04-22 | AAAU | ETF | 23.14 | 23.2 | 23.01 | 23.06 | 3709600.0 |
| 2024-04-22 | AADR | ETF | 60.17 | 60.91 | 60.17 | 60.77 | 600.0 |
| 2024-04-22 | AAPB | ETF | 16.18 | 16.45 | 16.04 | 16.25 | 41248.0 |
| 2024-04-22 | AAPD | ETF | 23.52 | 23.6297 | 23.28 | 23.46 | 136702.0 |
| 2024-04-22 | AAPR | ETF | 24.36 | 24.41 | 24.2741 | 24.34 | 79572.0 |
| 2024-04-22 | AAPU | ETF | 20.86 | 21.2699 | 20.71 | 20.94 | 277827.0 |
| 2024-04-22 | AAPX | ETF | 18.8 | 19.2099 | 18.69 | 18.93 | 13363.0 |
| 2024-04-22 | AAPY | ETF | 23.01 | 23.09 | 23.0099 | 23.0554 | 968.0 |
| 2024-04-22 | AAXJ | ETF | 65.84 | 66.46 | 65.65 | 66.35 | 596000.0 |
| 2024-04-22 | ABCS | ETF | 25.53 | 25.84 | 25.53 | 25.7403 | 1700.0 |
| 2024-04-22 | ABEQ | ETF | 29.67 | 29.683 | 29.562 | 29.675 | 1200.0 |
| 2024-04-22 | ACES | ETF | 25.91 | 26.29 | 25.55 | 26.13 | 111100.0 |
| 2024-04-22 | ACIO | ETF | 34.84 | 35.06 | 34.72 | 34.863 | 115200.0 |
| 2024-04-22 | ACSI | ETF | 50.184 | 50.184 | 50.184 | 50.184 | 200.0 |
| 2024-04-22 | ACT | ETF | 29.92 | 30.075 | 29.78 | 29.94 | 162636.0 |
| 2024-04-22 | ACTV | ETF | 32.65 | 32.954 | 32.65 | 32.804 | 3900.0 |
| 2024-04-22 | ACVF | ETF | 37.98 | 38.38 | 37.94 | 38.194 | 5500.0 |
| 2024-04-22 | ACWF | ETF | 39.68 | 39.86 | 39.68 | 39.8059 | 764.0 |
| 2024-04-22 | ACWI | ETF | 105.05 | 106.06 | 104.78 | 105.6 | 2442700.0 |
| 2024-04-22 | ACWV | ETF | 102.28 | 102.99 | 102.24 | 102.57 | 245500.0 |
| 2024-04-22 | ACWX | ETF | 51.43 | 51.88 | 51.31 | 51.74 | 799700.0 |
| 2024-04-22 | ADFI | ETF | 8.36 | 8.36 | 8.32 | 8.355 | 13600.0 |
| 2024-04-22 | ADIV | ETF | 13.66 | 13.66 | 13.66 | 13.66 | 100.0 |
| 2024-04-22 | ADME | ETF | 40.0 | 40.47 | 40.0 | 40.229 | 6000.0 |
| 2024-04-22 | ADPV | ETF | 27.75 | 27.89 | 27.61 | 27.8674 | 3889.0 |
| 2024-04-22 | AEMB | ETF | 38.08 | 38.108 | 38.08 | 38.108 | 300.0 |
| 2024-04-22 | AESR | ETF | 14.65 | 14.78 | 14.59 | 14.69 | 6200.0 |
| 2024-04-22 | AETH | ETF | 42.35 | 42.413 | 42.12 | 42.2151 | 4540.0 |
| 2024-04-22 | AFIF | ETF | 9.05 | 9.06 | 9.04 | 9.05 | 8500.0 |
| 2024-04-22 | AFK | ETF | 14.74 | 14.85 | 14.54 | 14.82 | 12100.0 |
| 2024-04-22 | AFLG | ETF | 29.23 | 29.41 | 29.23 | 29.326 | 2500.0 |
| 2024-04-22 | AFMC | ETF | 28.266 | 28.266 | 28.266 | 28.266 | 100.0 |
| 2024-04-22 | AFSM | ETF | 27.24 | 27.6 | 27.24 | 27.55 | 4000.0 |
| 2024-04-22 | AFTY | ETF | 14.07 | 14.095 | 14.07 | 14.095 | 300.0 |
| 2024-04-22 | AGG | ETF | 95.33 | 95.53 | 95.32 | 95.44 | 9029000.0 |
| 2024-04-22 | AGGH | ETF | 20.65 | 20.7499 | 20.65 | 20.7183 | 37916.0 |
| 2024-04-22 | AGGY | ETF | 42.33 | 42.41 | 42.322 | 42.41 | 71000.0 |
| 2024-04-22 | AGNG | ETF | 28.54 | 28.615 | 28.03 | 28.58 | 9000.0 |
| 2024-04-22 | AGOX | ETF | 24.285 | 24.44 | 24.2 | 24.23 | 16500.0 |
| 2024-04-22 | AGQ | ETF | 34.16 | 34.87 | 33.69 | 34.02 | 2154100.0 |
| 2024-04-22 | AGQI | ETF | 13.52 | 13.6351 | 13.51 | 13.5946 | 7832.0 |
| 2024-04-22 | AGRH | ETF | 25.89 | 25.89 | 25.89 | 25.89 | 230.0 |
| 2024-04-22 | AGZ | ETF | 106.68 | 106.8 | 106.68 | 106.69 | 10100.0 |
> showing 50 of 3,329 rows — these rows as CSV