PREVIEW / etf_daily / 2024-10-09
file: by_date/etf_daily/2024/2024-10-09.parquet size: 143 KB rows: 3,738
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-09 | SPY | ETF | 573.16 | 577.71 | 572.55 | 577.14 | 37809403.0 |
| 2024-10-09 | QQQ | ETF | 489.0 | 493.73 | 487.95 | 493.15 | 24994950.0 |
| 2024-10-09 | IWM | ETF | 217.53 | 219.61 | 216.92 | 218.06 | 18192922.0 |
| 2024-10-09 | DIA | ETF | 420.89 | 425.66 | 420.03 | 425.05 | 3933291.0 |
| 2024-10-09 | GLD | ETF | 241.16 | 241.84 | 240.64 | 241.05 | 4107594.0 |
| 2024-10-09 | TLT | ETF | 94.67 | 94.905 | 94.23 | 94.45 | 35725464.0 |
| 2024-10-09 | AAA | ETF | 25.0795 | 25.09 | 25.0301 | 25.07 | 3848.0 |
| 2024-10-09 | AAAU | ETF | 25.82 | 25.89 | 25.76 | 25.805 | 2536381.0 |
| 2024-10-09 | AADR | ETF | 62.805 | 63.6465 | 62.805 | 63.6465 | 859.0 |
| 2024-10-09 | AAPB | ETF | 27.94 | 29.07 | 27.93 | 28.98 | 132534.0 |
| 2024-10-09 | AAPD | ETF | 17.01 | 17.03 | 16.67 | 16.69 | 257808.0 |
| 2024-10-09 | AAPR | ETF | 26.13 | 26.19 | 26.13 | 26.19 | 6111.0 |
| 2024-10-09 | AAPU | ETF | 35.39 | 36.83 | 35.29 | 36.77 | 455410.0 |
| 2024-10-09 | AAPX | ETF | 32.26 | 33.52 | 32.26 | 33.52 | 12605.0 |
| 2024-10-09 | AAPY | ETF | 27.17 | 27.509 | 27.17 | 27.509 | 2299.0 |
| 2024-10-09 | AAXJ | ETF | 78.21 | 79.12 | 78.12 | 78.91 | 813316.0 |
| 2024-10-09 | ABCS | ETF | 28.1321 | 28.2321 | 28.01 | 28.2192 | 2200.0 |
| 2024-10-09 | ABEQ | ETF | 32.24 | 32.3811 | 32.24 | 32.3811 | 2488.0 |
| 2024-10-09 | ABNY | ETF | 84.5 | 85.3 | 84.203 | 85.292 | 543.0 |
| 2024-10-09 | ACES | ETF | 28.85 | 29.13 | 28.68 | 28.93 | 77740.0 |
| 2024-10-09 | ACIO | ETF | 39.82 | 40.07 | 39.795 | 40.06 | 89548.0 |
| 2024-10-09 | ACSI | ETF | 57.9936 | 57.9936 | 57.9936 | 57.9936 | 51.0 |
| 2024-10-09 | ACT | ETF | 36.27 | 36.57 | 35.91 | 36.1 | 249510.0 |
| 2024-10-09 | ACTV | ETF | 33.5707 | 33.5707 | 33.435 | 33.4579 | 4557.0 |
| 2024-10-09 | ACVF | ETF | 43.85 | 44.0908 | 43.81 | 44.0908 | 3347.0 |
| 2024-10-09 | ACWI | ETF | 118.7 | 119.64 | 118.61 | 119.53 | 1163028.0 |
| 2024-10-09 | ACWV | ETF | 113.2 | 114.13 | 113.18 | 114.04 | 44794.0 |
| 2024-10-09 | ACWX | ETF | 56.14 | 56.46 | 56.0001 | 56.38 | 707939.0 |
| 2024-10-09 | ADFI | ETF | 8.65 | 8.69 | 8.61 | 8.69 | 18719.0 |
| 2024-10-09 | ADIV | ETF | 16.05 | 16.3 | 16.04 | 16.19 | 26881.0 |
| 2024-10-09 | ADME | ETF | 46.93 | 46.93 | 46.2502 | 46.5634 | 8522.0 |
| 2024-10-09 | ADPV | ETF | 31.97 | 32.16 | 31.97 | 32.1368 | 2441.0 |
| 2024-10-09 | ADVE | ETF | 35.8397 | 35.8397 | 35.8397 | 35.8397 | 6.0 |
| 2024-10-09 | AESR | ETF | 17.09 | 17.22 | 17.09 | 17.22 | 28203.0 |
| 2024-10-09 | AETH | ETF | 31.285 | 31.76 | 30.92 | 31.0418 | 4238.0 |
| 2024-10-09 | AFIF | ETF | 9.2 | 9.2002 | 9.19 | 9.2002 | 7662.0 |
| 2024-10-09 | AFK | ETF | 16.51 | 16.55 | 16.29 | 16.54 | 5704.0 |
| 2024-10-09 | AFLG | ETF | 34.055 | 34.26 | 34.055 | 34.26 | 13626.0 |
| 2024-10-09 | AFMC | ETF | 31.82 | 32.13 | 31.82 | 32.003 | 6549.0 |
| 2024-10-09 | AFSM | ETF | 30.385 | 30.63 | 30.385 | 30.47 | 8522.0 |
| 2024-10-09 | AFTY | ETF | 16.26 | 16.3 | 16.26 | 16.2876 | 37867.0 |
| 2024-10-09 | AGG | ETF | 99.64 | 99.67 | 99.47 | 99.53 | 8199574.0 |
| 2024-10-09 | AGGH | ETF | 21.35 | 21.35 | 21.21 | 21.21 | 78973.0 |
| 2024-10-09 | AGGS | ETF | 41.7633 | 41.7633 | 41.7633 | 41.7633 | 4.0 |
| 2024-10-09 | AGGY | ETF | 44.15 | 44.1736 | 44.0925 | 44.14 | 68024.0 |
| 2024-10-09 | AGIH | ETF | 24.8993 | 24.8993 | 24.8993 | 24.8993 | 5.0 |
| 2024-10-09 | AGIX | ETF | 25.92 | 26.092 | 25.92 | 26.092 | 1939.0 |
| 2024-10-09 | AGMI | ETF | 28.55 | 29.0916 | 28.55 | 29.0916 | 100.0 |
| 2024-10-09 | AGNG | ETF | 32.35 | 32.56 | 32.35 | 32.56 | 1955.0 |
| 2024-10-09 | AGOX | ETF | 29.42 | 29.54 | 29.1808 | 29.5209 | 38755.0 |
> showing 50 of 3,738 rows — these rows as CSV