PREVIEW / etf_daily / 2024-11-08
file: by_date/etf_daily/2024/2024-11-08.parquet size: 144 KB rows: 3,758
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-11-08 | SPY | ETF | 596.17 | 599.64 | 596.165 | 598.19 | 46041044.0 |
| 2024-11-08 | QQQ | ETF | 513.035 | 514.9175 | 512.41 | 514.14 | 22924483.0 |
| 2024-11-08 | IWM | ETF | 235.93 | 238.465 | 235.65 | 238.12 | 26313798.0 |
| 2024-11-08 | DIA | ETF | 438.3 | 441.7 | 437.4 | 440.11 | 4964346.0 |
| 2024-11-08 | GLD | ETF | 249.07 | 249.35 | 247.78 | 247.96 | 6166592.0 |
| 2024-11-08 | TLT | ETF | 92.0 | 92.5955 | 91.84 | 92.49 | 56621980.0 |
| 2024-11-08 | AAA | ETF | 25.065 | 25.08 | 25.06 | 25.08 | 6448.0 |
| 2024-11-08 | AAAU | ETF | 26.67 | 26.695 | 26.52 | 26.55 | 1174301.0 |
| 2024-11-08 | AADR | ETF | 65.68 | 65.95 | 65.68 | 65.95 | 147.0 |
| 2024-11-08 | AAPB | ETF | 28.24 | 28.51 | 28.0599 | 28.21 | 47270.0 |
| 2024-11-08 | AAPD | ETF | 16.89 | 16.95 | 16.8 | 16.9 | 122751.0 |
| 2024-11-08 | AAPR | ETF | 26.38 | 26.405 | 26.36 | 26.395 | 23338.0 |
| 2024-11-08 | AAPU | ETF | 35.75 | 36.16 | 35.4531 | 35.71 | 384677.0 |
| 2024-11-08 | AAPX | ETF | 32.51 | 32.85 | 32.2952 | 32.4501 | 10920.0 |
| 2024-11-08 | AAPY | ETF | 27.24 | 27.2401 | 27.2019 | 27.2019 | 853.0 |
| 2024-11-08 | AAXJ | ETF | 77.24 | 77.31 | 76.2 | 76.52 | 598060.0 |
| 2024-11-08 | ABCS | ETF | 29.7847 | 29.84 | 29.7413 | 29.7413 | 1102.0 |
| 2024-11-08 | ABEQ | ETF | 32.71 | 32.77 | 32.71 | 32.7478 | 2780.0 |
| 2024-11-08 | ABNY | ETF | 84.15 | 84.5 | 82.0 | 82.994 | 7193.0 |
| 2024-11-08 | ACES | ETF | 27.52 | 27.64 | 27.3192 | 27.64 | 182743.0 |
| 2024-11-08 | ACIO | ETF | 40.95 | 41.16 | 40.9261 | 41.085 | 137139.0 |
| 2024-11-08 | ACSI | ETF | 60.8034 | 60.8034 | 60.8034 | 60.8034 | 64.0 |
| 2024-11-08 | ACT | ETF | 33.63 | 33.9428 | 33.3601 | 33.76 | 390527.0 |
| 2024-11-08 | ACTV | ETF | 33.58 | 33.97 | 33.58 | 33.8762 | 7856.0 |
| 2024-11-08 | ACVF | ETF | 45.47 | 45.72 | 45.37 | 45.593 | 10305.0 |
| 2024-11-08 | ACWI | ETF | 121.28 | 121.49 | 121.005 | 121.3 | 1200413.0 |
| 2024-11-08 | ACWV | ETF | 114.32 | 114.9 | 114.32 | 114.7 | 74123.0 |
| 2024-11-08 | ACWX | ETF | 54.97 | 54.9801 | 54.5201 | 54.78 | 459462.0 |
| 2024-11-08 | ADFI | ETF | 8.56 | 8.62 | 8.56 | 8.59 | 18366.0 |
| 2024-11-08 | ADIV | ETF | 15.87 | 15.92 | 15.74 | 15.76 | 4056.0 |
| 2024-11-08 | ADME | ETF | 47.785 | 47.9599 | 47.785 | 47.8151 | 4892.0 |
| 2024-11-08 | ADPV | ETF | 35.46 | 36.0852 | 35.46 | 36.0831 | 4685.0 |
| 2024-11-08 | ADVE | ETF | 34.8611 | 34.8611 | 34.8611 | 34.8611 | 3.0 |
| 2024-11-08 | AESR | ETF | 17.781 | 17.86 | 17.781 | 17.84 | 25031.0 |
| 2024-11-08 | AETH | ETF | 37.86 | 38.2287 | 37.0708 | 37.73 | 15481.0 |
| 2024-11-08 | AFIF | ETF | 9.18 | 9.1901 | 9.1718 | 9.185 | 209270.0 |
| 2024-11-08 | AFK | ETF | 16.71 | 16.77 | 16.28 | 16.329 | 12999.0 |
| 2024-11-08 | AFLG | ETF | 35.5 | 35.62 | 35.49 | 35.56 | 19699.0 |
| 2024-11-08 | AFMC | ETF | 34.0205 | 34.09 | 33.99 | 34.06 | 152149.0 |
| 2024-11-08 | AFSM | ETF | 32.75 | 32.96 | 32.68 | 32.89 | 18744.0 |
| 2024-11-08 | AGG | ETF | 98.48 | 98.715 | 98.3748 | 98.5 | 6182055.0 |
| 2024-11-08 | AGGH | ETF | 20.9 | 20.92 | 20.7601 | 20.83 | 35673.0 |
| 2024-11-08 | AGGS | ETF | 41.4 | 41.4 | 41.3532 | 41.3532 | 102.0 |
| 2024-11-08 | AGGY | ETF | 43.7 | 43.8179 | 43.6721 | 43.735 | 171996.0 |
| 2024-11-08 | AGIH | ETF | 24.7729 | 24.7729 | 24.7729 | 24.7729 | 2.0 |
| 2024-11-08 | AGIX | ETF | 27.87 | 27.9 | 27.73 | 27.9 | 6114.0 |
| 2024-11-08 | AGMI | ETF | 29.29 | 29.5253 | 29.29 | 29.5253 | 194.0 |
| 2024-11-08 | AGNG | ETF | 32.16 | 32.37 | 32.16 | 32.19 | 2617.0 |
| 2024-11-08 | AGOX | ETF | 29.61 | 29.65 | 29.45 | 29.49 | 14191.0 |
| 2024-11-08 | AGQ | ETF | 41.25 | 41.46 | 39.76 | 39.93 | 1854822.0 |
> showing 50 of 3,758 rows — these rows as CSV