PREVIEW / etf_daily / 2024-12-10
file: by_date/etf_daily/2024/2024-12-10.parquet size: 146 KB rows: 3,815
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-10 | SPY | ETF | 605.37 | 605.8 | 602.13 | 602.8 | 36743023.0 |
| 2024-12-10 | QQQ | ETF | 523.62 | 525.38 | 519.16 | 520.6 | 24350040.0 |
| 2024-12-10 | IWM | ETF | 237.58 | 238.815 | 235.92 | 236.7 | 19733345.0 |
| 2024-12-10 | DIA | ETF | 444.51 | 445.8 | 442.95 | 443.69 | 2403616.0 |
| 2024-12-10 | GLD | ETF | 247.86 | 248.86 | 247.83 | 248.59 | 4483052.0 |
| 2024-12-10 | TLT | ETF | 93.02 | 93.3 | 92.905 | 93.08 | 26458565.0 |
| 2024-12-10 | AAA | ETF | 25.13 | 25.15 | 25.08 | 25.105 | 3592.0 |
| 2024-12-10 | AAAU | ETF | 26.54 | 26.6499 | 26.5379 | 26.615 | 1017231.0 |
| 2024-12-10 | AADR | ETF | 70.5 | 70.5 | 69.32 | 69.32 | 798.0 |
| 2024-12-10 | AAPB | ETF | 33.2 | 33.398 | 32.66 | 33.2432 | 50744.0 |
| 2024-12-10 | AAPD | ETF | 15.59 | 15.72 | 15.545 | 15.57 | 284353.0 |
| 2024-12-10 | AAPR | ETF | 26.47 | 26.4783 | 26.45 | 26.4752 | 13129.0 |
| 2024-12-10 | AAPU | ETF | 41.78 | 42.1959 | 41.255 | 42.05 | 699806.0 |
| 2024-12-10 | AAPX | ETF | 37.7 | 38.2705 | 37.545 | 38.24 | 16955.0 |
| 2024-12-10 | AAPY | ETF | 28.48 | 28.5657 | 28.48 | 28.5657 | 592.0 |
| 2024-12-10 | AAXJ | ETF | 75.83 | 75.95 | 75.32 | 75.36 | 443320.0 |
| 2024-12-10 | ABCS | ETF | 29.9362 | 30.08 | 29.9312 | 29.9312 | 1702.0 |
| 2024-12-10 | ABEQ | ETF | 32.64 | 32.68 | 32.55 | 32.55 | 5827.0 |
| 2024-12-10 | ABNY | ETF | 79.0 | 80.1995 | 79.0 | 79.75 | 4399.0 |
| 2024-12-10 | ACES | ETF | 28.12 | 28.12 | 27.71 | 27.77 | 32908.0 |
| 2024-12-10 | ACGR | ETF | 59.2021 | 59.2021 | 59.2021 | 59.2021 | 41.0 |
| 2024-12-10 | ACIO | ETF | 41.17 | 41.17 | 40.95 | 41.02 | 88287.0 |
| 2024-12-10 | ACLC | ETF | 73.165 | 73.165 | 72.86 | 72.86 | 488.0 |
| 2024-12-10 | ACSI | ETF | 63.3026 | 63.3026 | 63.3026 | 63.3026 | 37.0 |
| 2024-12-10 | ACT | ETF | 33.85 | 34.29 | 33.44 | 34.21 | 248971.0 |
| 2024-12-10 | ACTV | ETF | 34.09 | 34.37 | 34.09 | 34.1668 | 10702.0 |
| 2024-12-10 | ACVF | ETF | 45.57 | 45.57 | 45.23 | 45.23 | 10281.0 |
| 2024-12-10 | ACWI | ETF | 122.89 | 122.89 | 121.965 | 122.1 | 2294352.0 |
| 2024-12-10 | ACWV | ETF | 114.35 | 114.35 | 113.72 | 113.99 | 206381.0 |
| 2024-12-10 | ACWX | ETF | 55.14 | 55.26 | 54.795 | 54.82 | 1026400.0 |
| 2024-12-10 | ADFI | ETF | 8.605 | 8.62 | 8.6 | 8.61 | 2929.0 |
| 2024-12-10 | ADIV | ETF | 15.93 | 15.93 | 15.7983 | 15.7983 | 657.0 |
| 2024-12-10 | ADME | ETF | 48.25 | 48.25 | 47.96 | 48.0026 | 12574.0 |
| 2024-12-10 | ADPV | ETF | 37.06 | 37.0601 | 36.3966 | 36.3966 | 5544.0 |
| 2024-12-10 | ADVE | ETF | 34.5 | 34.517 | 34.3796 | 34.3796 | 649.0 |
| 2024-12-10 | AESR | ETF | 17.85 | 17.85 | 17.73 | 17.74 | 17446.0 |
| 2024-12-10 | AETH | ETF | 47.12 | 47.12 | 44.51 | 46.2 | 14720.0 |
| 2024-12-10 | AFIF | ETF | 9.21 | 9.21 | 9.18 | 9.19 | 725431.0 |
| 2024-12-10 | AFIX | ETF | 25.06 | 25.0629 | 25.06 | 25.0629 | 100.0 |
| 2024-12-10 | AFK | ETF | 16.6 | 16.6521 | 16.45 | 16.6 | 16947.0 |
| 2024-12-10 | AFLG | ETF | 35.828 | 35.8993 | 35.6638 | 35.68 | 18536.0 |
| 2024-12-10 | AFMC | ETF | 33.7302 | 33.74 | 33.5231 | 33.54 | 14366.0 |
| 2024-12-10 | AFSM | ETF | 32.28 | 32.43 | 32.1713 | 32.1939 | 9020.0 |
| 2024-12-10 | AGG | ETF | 98.87 | 98.99 | 98.804 | 98.92 | 5606643.0 |
| 2024-12-10 | AGGH | ETF | 21.04 | 21.04 | 20.975 | 21.04 | 31932.0 |
| 2024-12-10 | AGGS | ETF | 41.5672 | 41.5672 | 41.5672 | 41.5672 | 7.0 |
| 2024-12-10 | AGGY | ETF | 43.9 | 43.9706 | 43.8841 | 43.94 | 80934.0 |
| 2024-12-10 | AGIH | ETF | 24.7298 | 24.7298 | 24.7298 | 24.7298 | 3.0 |
| 2024-12-10 | AGIX | ETF | 29.81 | 29.9398 | 29.25 | 29.39 | 8155.0 |
| 2024-12-10 | AGMI | ETF | 28.79 | 28.79 | 28.49 | 28.49 | 1396.0 |
> showing 50 of 3,815 rows — these rows as CSV