PREVIEW / etf_daily / 2024-11-14
file: by_date/etf_daily/2024/2024-11-14.parquet size: 145 KB rows: 3,781
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-14 | SPY | ETF | 597.32 | 597.81 | 592.65 | 593.35 | 38573389.0 |
| 2024-11-14 | QQQ | ETF | 511.91 | 512.79 | 507.77 | 508.69 | 28679519.0 |
| 2024-11-14 | IWM | ETF | 235.95 | 236.43 | 231.21 | 231.94 | 29107484.0 |
| 2024-11-14 | DIA | ETF | 440.59 | 440.94 | 437.101 | 437.7 | 2354190.0 |
| 2024-11-14 | GLD | ETF | 236.57 | 237.9886 | 236.1326 | 237.01 | 8250166.0 |
| 2024-11-14 | TLT | ETF | 90.56 | 91.025 | 90.27 | 90.32 | 53115066.0 |
| 2024-11-14 | AAA | ETF | 25.1 | 25.145 | 25.0625 | 25.12 | 15600.0 |
| 2024-11-14 | AAAU | ETF | 25.33 | 25.472 | 25.28 | 25.375 | 2447381.0 |
| 2024-11-14 | AADR | ETF | 65.16 | 65.4 | 65.0 | 65.0 | 2352.0 |
| 2024-11-14 | AAPB | ETF | 27.86 | 28.541 | 27.77 | 28.41 | 62496.0 |
| 2024-11-14 | AAPD | ETF | 17.05 | 17.07 | 16.79 | 16.82 | 199789.0 |
| 2024-11-14 | AAPR | ETF | 26.34 | 26.34 | 26.315 | 26.315 | 10947.0 |
| 2024-11-14 | AAPU | ETF | 35.02 | 36.14 | 35.01 | 35.94 | 355711.0 |
| 2024-11-14 | AAPX | ETF | 32.0204 | 32.835 | 32.0204 | 32.76 | 11501.0 |
| 2024-11-14 | AAPY | ETF | 27.34 | 27.3457 | 27.3322 | 27.3457 | 1362.0 |
| 2024-11-14 | AAXJ | ETF | 73.87 | 74.01 | 73.43 | 73.48 | 342187.0 |
| 2024-11-14 | ABCS | ETF | 29.77 | 29.77 | 29.4977 | 29.4977 | 1220.0 |
| 2024-11-14 | ABEQ | ETF | 32.435 | 32.5199 | 32.39 | 32.4156 | 3053.0 |
| 2024-11-14 | ABNY | ETF | 78.0 | 79.535 | 77.5 | 78.5495 | 3755.0 |
| 2024-11-14 | ACES | ETF | 27.08 | 27.27 | 26.73 | 26.9 | 61308.0 |
| 2024-11-14 | ACIO | ETF | 41.02 | 41.02 | 40.72 | 40.78 | 143523.0 |
| 2024-11-14 | ACSI | ETF | 61.1172 | 61.1172 | 60.8917 | 60.8917 | 298.0 |
| 2024-11-14 | ACT | ETF | 34.35 | 34.52 | 34.01 | 34.14 | 285909.0 |
| 2024-11-14 | ACTV | ETF | 33.45 | 33.45 | 33.2272 | 33.2272 | 4958.0 |
| 2024-11-14 | ACVF | ETF | 45.6 | 45.6 | 45.23 | 45.25 | 4639.0 |
| 2024-11-14 | ACWI | ETF | 120.41 | 120.62 | 119.65 | 119.75 | 1081928.0 |
| 2024-11-14 | ACWV | ETF | 113.54 | 113.58 | 112.54 | 112.54 | 72052.0 |
| 2024-11-14 | ACWX | ETF | 53.77 | 53.805 | 53.405 | 53.44 | 942704.0 |
| 2024-11-14 | ADFI | ETF | 8.53 | 8.53 | 8.49 | 8.51 | 11839.0 |
| 2024-11-14 | ADIV | ETF | 15.59 | 15.59 | 15.45 | 15.45 | 2176.0 |
| 2024-11-14 | ADME | ETF | 47.708 | 47.75 | 47.42 | 47.4407 | 9271.0 |
| 2024-11-14 | ADPV | ETF | 35.93 | 35.94 | 35.7137 | 35.7137 | 8874.0 |
| 2024-11-14 | ADVE | ETF | 33.88 | 33.88 | 33.7679 | 33.7679 | 299.0 |
| 2024-11-14 | AESR | ETF | 17.701 | 17.701 | 17.574 | 17.5961 | 11775.0 |
| 2024-11-14 | AETH | ETF | 40.8 | 40.8 | 39.1704 | 39.6138 | 18812.0 |
| 2024-11-14 | AFIF | ETF | 9.15 | 9.15 | 9.14 | 9.15 | 27233.0 |
| 2024-11-14 | AFK | ETF | 15.67 | 15.98 | 15.55 | 15.67 | 16296.0 |
| 2024-11-14 | AFLG | ETF | 35.51 | 35.51 | 35.19 | 35.23 | 367624.0 |
| 2024-11-14 | AFMC | ETF | 33.81 | 33.81 | 33.375 | 33.41 | 5656.0 |
| 2024-11-14 | AFSM | ETF | 32.2088 | 32.2088 | 31.758 | 31.83 | 25004.0 |
| 2024-11-14 | AGG | ETF | 97.85 | 97.99 | 97.57 | 97.65 | 7306518.0 |
| 2024-11-14 | AGGH | ETF | 20.88 | 20.88 | 20.7316 | 20.81 | 122678.0 |
| 2024-11-14 | AGGS | ETF | 41.1 | 41.1001 | 41.05 | 41.06 | 1141.0 |
| 2024-11-14 | AGGY | ETF | 43.41 | 43.4578 | 43.29 | 43.32 | 72770.0 |
| 2024-11-14 | AGIH | ETF | 24.575 | 24.575 | 24.575 | 24.575 | 4.0 |
| 2024-11-14 | AGIX | ETF | 28.09 | 28.09 | 27.78 | 27.78 | 2586.0 |
| 2024-11-14 | AGMI | ETF | 27.54 | 27.54 | 27.4755 | 27.4755 | 100.0 |
| 2024-11-14 | AGNG | ETF | 31.4 | 31.52 | 31.11 | 31.11 | 6543.0 |
| 2024-11-14 | AGOX | ETF | 29.21 | 29.31 | 28.9164 | 29.04 | 25141.0 |
| 2024-11-14 | AGQ | ETF | 37.39 | 38.3197 | 37.17 | 38.0 | 1683989.0 |
> showing 50 of 3,781 rows — these rows as CSV