PREVIEW / etf_daily / 2024-12-03
file: by_date/etf_daily/2024/2024-12-03.parquet size: 145 KB rows: 3,800
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-12-03 | SPY | ETF | 603.39 | 604.16 | 602.341 | 603.91 | 26658215.0 |
| 2024-12-03 | QQQ | ETF | 513.95 | 517.15 | 513.37 | 516.87 | 18597900.0 |
| 2024-12-03 | IWM | ETF | 241.54 | 242.14 | 239.37 | 240.03 | 21380465.0 |
| 2024-12-03 | DIA | ETF | 449.15 | 449.6 | 446.61 | 447.89 | 1650696.0 |
| 2024-12-03 | GLD | ETF | 244.96 | 245.18 | 243.3 | 243.93 | 3537441.0 |
| 2024-12-03 | TLT | ETF | 93.93 | 94.03 | 92.99 | 93.06 | 32404526.0 |
| 2024-12-03 | AAA | ETF | 25.07 | 25.1186 | 25.07 | 25.095 | 9539.0 |
| 2024-12-03 | AAAU | ETF | 26.225 | 26.24 | 26.0594 | 26.12 | 2115912.0 |
| 2024-12-03 | AADR | ETF | 69.67 | 69.67 | 69.03 | 69.03 | 1609.0 |
| 2024-12-03 | AAPB | ETF | 31.28 | 32.0 | 31.0524 | 31.96 | 62108.0 |
| 2024-12-03 | AAPD | ETF | 16.06 | 16.1192 | 15.87 | 15.88 | 188343.0 |
| 2024-12-03 | AAPR | ETF | 26.44 | 26.5118 | 26.44 | 26.495 | 23710.0 |
| 2024-12-03 | AAPU | ETF | 39.55 | 40.46 | 39.21 | 40.44 | 759266.0 |
| 2024-12-03 | AAPX | ETF | 35.86 | 36.7125 | 35.691 | 36.7125 | 45288.0 |
| 2024-12-03 | AAPY | ETF | 27.89 | 28.1299 | 27.89 | 28.1043 | 1852.0 |
| 2024-12-03 | AAXJ | ETF | 74.28 | 74.735 | 73.94 | 74.72 | 780813.0 |
| 2024-12-03 | ABCS | ETF | 30.505 | 30.5499 | 30.4551 | 30.4551 | 1141.0 |
| 2024-12-03 | ABEQ | ETF | 33.23 | 33.23 | 33.1066 | 33.1066 | 677.0 |
| 2024-12-03 | ABNY | ETF | 78.55 | 79.725 | 78.55 | 79.311 | 3718.0 |
| 2024-12-03 | ACES | ETF | 28.29 | 28.29 | 27.71 | 27.76 | 61559.0 |
| 2024-12-03 | ACIO | ETF | 41.2 | 41.2 | 41.0701 | 41.19 | 276509.0 |
| 2024-12-03 | ACSI | ETF | 62.8509 | 62.87 | 62.8509 | 62.8654 | 2002.0 |
| 2024-12-03 | ACT | ETF | 35.48 | 35.56 | 34.99 | 35.36 | 549926.0 |
| 2024-12-03 | ACTV | ETF | 34.235 | 34.3485 | 34.155 | 34.288 | 6372.0 |
| 2024-12-03 | ACVF | ETF | 45.86 | 45.86 | 45.715 | 45.8143 | 8017.0 |
| 2024-12-03 | ACWI | ETF | 122.11 | 122.335 | 121.8733 | 122.25 | 1089437.0 |
| 2024-12-03 | ACWV | ETF | 115.44 | 115.58 | 115.16 | 115.24 | 59033.0 |
| 2024-12-03 | ACWX | ETF | 54.79 | 54.9099 | 54.5551 | 54.81 | 707856.0 |
| 2024-12-03 | ADFI | ETF | 8.59 | 8.64 | 8.55 | 8.55 | 16149.0 |
| 2024-12-03 | ADIV | ETF | 15.71 | 15.71 | 15.71 | 15.71 | 246.0 |
| 2024-12-03 | ADME | ETF | 47.98 | 48.1699 | 47.98 | 48.13 | 150937.0 |
| 2024-12-03 | ADPV | ETF | 37.7 | 37.93 | 37.5401 | 37.8947 | 10552.0 |
| 2024-12-03 | ADVE | ETF | 34.46 | 34.5856 | 34.46 | 34.5856 | 141.0 |
| 2024-12-03 | AESR | ETF | 17.86 | 17.94 | 17.86 | 17.94 | 27566.0 |
| 2024-12-03 | AETH | ETF | 45.2 | 45.7546 | 44.85 | 45.7546 | 5399.0 |
| 2024-12-03 | AFIF | ETF | 9.19 | 9.21 | 9.18 | 9.185 | 102123.0 |
| 2024-12-03 | AFK | ETF | 16.25 | 16.34 | 16.04 | 16.31 | 13012.0 |
| 2024-12-03 | AFLG | ETF | 36.17 | 36.27 | 36.1315 | 36.26 | 40723.0 |
| 2024-12-03 | AFMC | ETF | 34.73 | 34.73 | 34.48 | 34.51 | 11641.0 |
| 2024-12-03 | AFSM | ETF | 33.14 | 33.14 | 32.7572 | 32.7871 | 5008.0 |
| 2024-12-03 | AGG | ETF | 98.97 | 99.06 | 98.67 | 98.71 | 6876008.0 |
| 2024-12-03 | AGGH | ETF | 20.85 | 20.9482 | 20.85 | 20.86 | 122448.0 |
| 2024-12-03 | AGGS | ETF | 41.61 | 41.63 | 41.5 | 41.5 | 804.0 |
| 2024-12-03 | AGGY | ETF | 43.98 | 44.0 | 43.84 | 43.86 | 51837.0 |
| 2024-12-03 | AGIH | ETF | 24.69 | 24.69 | 24.69 | 24.69 | 1.0 |
| 2024-12-03 | AGIX | ETF | 28.63 | 28.89 | 28.53 | 28.89 | 5429.0 |
| 2024-12-03 | AGMI | ETF | 28.0791 | 28.0791 | 28.0791 | 28.0791 | 29.0 |
| 2024-12-03 | AGNG | ETF | 31.865 | 31.9071 | 31.73 | 31.73 | 1088.0 |
| 2024-12-03 | AGOX | ETF | 29.55 | 29.74 | 29.31 | 29.5589 | 19652.0 |
| 2024-12-03 | AGQ | ETF | 39.03 | 39.29 | 38.37 | 39.12 | 1150006.0 |
> showing 50 of 3,800 rows — these rows as CSV