PREVIEW / etf_daily / 2024-12-05
file: by_date/etf_daily/2024/2024-12-05.parquet size: 145 KB rows: 3,821
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-05 | SPY | ETF | 607.66 | 608.48 | 606.305 | 606.66 | 28650195.0 |
| 2024-12-05 | QQQ | ETF | 523.31 | 524.0399 | 521.42 | 521.81 | 18169632.0 |
| 2024-12-05 | IWM | ETF | 240.52 | 240.86 | 237.735 | 238.08 | 20377944.0 |
| 2024-12-05 | DIA | ETF | 450.48 | 451.48 | 448.35 | 448.67 | 1870217.0 |
| 2024-12-05 | GLD | ETF | 244.16 | 244.38 | 242.15 | 242.86 | 4727766.0 |
| 2024-12-05 | TLT | ETF | 93.72 | 94.39 | 93.655 | 94.25 | 23583479.0 |
| 2024-12-05 | AAA | ETF | 25.12 | 25.12 | 25.04 | 25.0923 | 5771.0 |
| 2024-12-05 | AAAU | ETF | 26.15 | 26.17 | 25.93 | 26.005 | 2758018.0 |
| 2024-12-05 | AADR | ETF | 68.86 | 69.67 | 68.86 | 69.18 | 1055.0 |
| 2024-12-05 | AAPB | ETF | 32.3 | 32.3 | 31.8641 | 32.07 | 45618.0 |
| 2024-12-05 | AAPD | ETF | 15.79 | 15.91 | 15.76 | 15.84 | 112072.0 |
| 2024-12-05 | AAPR | ETF | 26.48 | 26.491 | 26.47 | 26.47 | 17879.0 |
| 2024-12-05 | AAPU | ETF | 40.81 | 41.0 | 40.25 | 40.52 | 318092.0 |
| 2024-12-05 | AAPX | ETF | 37.19 | 37.19 | 36.57 | 36.741 | 24314.0 |
| 2024-12-05 | AAPY | ETF | 28.2 | 28.26 | 28.0872 | 28.1458 | 3651.0 |
| 2024-12-05 | AAXJ | ETF | 75.07 | 75.295 | 75.05 | 75.24 | 229360.0 |
| 2024-12-05 | ABCS | ETF | 30.49 | 30.49 | 30.2341 | 30.2341 | 1246.0 |
| 2024-12-05 | ABEQ | ETF | 33.04 | 33.06 | 33.04 | 33.0491 | 3408.0 |
| 2024-12-05 | ABNY | ETF | 80.279 | 80.65 | 78.75 | 78.8425 | 2869.0 |
| 2024-12-05 | ACES | ETF | 27.48 | 27.81 | 27.2877 | 27.3006 | 78916.0 |
| 2024-12-05 | ACIO | ETF | 41.4 | 41.4 | 41.275 | 41.3 | 123581.0 |
| 2024-12-05 | ACSI | ETF | 63.0605 | 63.0605 | 62.9139 | 62.9139 | 104.0 |
| 2024-12-05 | ACT | ETF | 35.18 | 35.57 | 35.15 | 35.33 | 283432.0 |
| 2024-12-05 | ACTV | ETF | 34.53 | 34.53 | 34.3214 | 34.3214 | 7965.0 |
| 2024-12-05 | ACVF | ETF | 46.1 | 46.1 | 45.9 | 45.9 | 15330.0 |
| 2024-12-05 | ACWI | ETF | 122.99 | 123.27 | 122.68 | 122.97 | 1599297.0 |
| 2024-12-05 | ACWV | ETF | 115.29 | 115.494 | 115.1601 | 115.275 | 122194.0 |
| 2024-12-05 | ACWX | ETF | 55.15 | 55.27 | 55.1 | 55.19 | 1863770.0 |
| 2024-12-05 | ADFI | ETF | 8.62 | 8.66 | 8.56 | 8.66 | 27742.0 |
| 2024-12-05 | ADIV | ETF | 15.74 | 15.7645 | 15.74 | 15.7645 | 727.0 |
| 2024-12-05 | ADME | ETF | 48.42 | 48.43 | 48.2539 | 48.295 | 11898.0 |
| 2024-12-05 | ADPV | ETF | 37.98 | 38.24 | 37.8402 | 37.8402 | 68413.0 |
| 2024-12-05 | ADVE | ETF | 34.53 | 34.57 | 34.53 | 34.54 | 3333.0 |
| 2024-12-05 | AESR | ETF | 18.0 | 18.04 | 17.97 | 17.97 | 40031.0 |
| 2024-12-05 | AETH | ETF | 49.82 | 50.24 | 48.063 | 48.4284 | 11998.0 |
| 2024-12-05 | AFIF | ETF | 9.17 | 9.23 | 9.17 | 9.19 | 11353.0 |
| 2024-12-05 | AFIX | ETF | 25.01 | 25.1 | 25.01 | 25.0383 | 7104.0 |
| 2024-12-05 | AFK | ETF | 16.33 | 16.44 | 16.22 | 16.4 | 9819.0 |
| 2024-12-05 | AFLG | ETF | 36.48 | 36.5343 | 36.4 | 36.4 | 20887.0 |
| 2024-12-05 | AFMC | ETF | 34.57 | 34.57 | 34.2054 | 34.22 | 14334.0 |
| 2024-12-05 | AFSM | ETF | 32.85 | 32.865 | 32.6304 | 32.6304 | 4936.0 |
| 2024-12-05 | AGG | ETF | 98.96 | 99.11 | 98.85 | 99.05 | 8524879.0 |
| 2024-12-05 | AGGH | ETF | 20.88 | 20.97 | 20.88 | 20.97 | 46153.0 |
| 2024-12-05 | AGGS | ETF | 41.625 | 41.77 | 41.59 | 41.7116 | 7252.0 |
| 2024-12-05 | AGGY | ETF | 43.91 | 44.05 | 43.91 | 44.03 | 99998.0 |
| 2024-12-05 | AGIH | ETF | 24.71 | 24.7292 | 24.62 | 24.7292 | 2719.0 |
| 2024-12-05 | AGIX | ETF | 29.91 | 29.99 | 29.845 | 29.87 | 7374.0 |
| 2024-12-05 | AGMI | ETF | 28.1063 | 28.1063 | 28.1063 | 28.1063 | 3.0 |
| 2024-12-05 | AGNG | ETF | 31.76 | 31.76 | 31.62 | 31.62 | 2494.0 |
| 2024-12-05 | AGOX | ETF | 30.07 | 30.1061 | 29.56 | 29.61 | 28953.0 |
> showing 50 of 3,821 rows — these rows as CSV