PREVIEW / etf_daily / 2024-12-09
file: by_date/etf_daily/2024/2024-12-09.parquet size: 145 KB rows: 3,817
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-09 | SPY | ETF | 607.69 | 607.86 | 604.08 | 604.68 | 33961779.0 |
| 2024-12-09 | QQQ | ETF | 525.55 | 526.35 | 521.22 | 522.38 | 20674405.0 |
| 2024-12-09 | IWM | ETF | 240.55 | 241.38 | 237.65 | 237.73 | 16536812.0 |
| 2024-12-09 | DIA | ETF | 447.65 | 448.28 | 444.8005 | 445.08 | 1871100.0 |
| 2024-12-09 | GLD | ETF | 246.28 | 247.11 | 245.2595 | 245.36 | 4603558.0 |
| 2024-12-09 | TLT | ETF | 93.99 | 94.04 | 93.465 | 93.52 | 30316483.0 |
| 2024-12-09 | AAA | ETF | 25.16 | 25.16 | 25.0501 | 25.11 | 10137.0 |
| 2024-12-09 | AAAU | ETF | 26.37 | 26.4616 | 26.265 | 26.275 | 1983178.0 |
| 2024-12-09 | AADR | ETF | 71.06 | 71.06 | 70.2 | 70.2 | 616.0 |
| 2024-12-09 | AAPB | ETF | 31.7 | 33.1299 | 31.7 | 33.02 | 100744.0 |
| 2024-12-09 | AAPD | ETF | 15.94 | 15.94 | 15.59 | 15.62 | 350623.0 |
| 2024-12-09 | AAPR | ETF | 26.49 | 26.4967 | 26.4809 | 26.4967 | 1092.0 |
| 2024-12-09 | AAPU | ETF | 40.09 | 41.91 | 40.0645 | 41.75 | 531631.0 |
| 2024-12-09 | AAPX | ETF | 36.46 | 38.047 | 36.46 | 37.78 | 21752.0 |
| 2024-12-09 | AAPY | ETF | 28.28 | 28.52 | 28.2618 | 28.481 | 2901.0 |
| 2024-12-09 | AAXJ | ETF | 76.89 | 77.51 | 76.8 | 76.86 | 517399.0 |
| 2024-12-09 | ABCS | ETF | 30.35 | 30.52 | 30.1844 | 30.1844 | 1510.0 |
| 2024-12-09 | ABEQ | ETF | 33.01 | 33.01 | 32.7276 | 32.7276 | 770.0 |
| 2024-12-09 | ABNY | ETF | 79.45 | 80.2 | 79.25 | 79.5 | 8426.0 |
| 2024-12-09 | ACES | ETF | 27.78 | 28.86 | 27.78 | 28.32 | 45292.0 |
| 2024-12-09 | ACIO | ETF | 41.29 | 41.29 | 41.04 | 41.0599 | 100947.0 |
| 2024-12-09 | ACSI | ETF | 62.8173 | 62.8173 | 62.8173 | 62.8173 | 29.0 |
| 2024-12-09 | ACT | ETF | 34.8 | 34.87 | 33.66 | 33.95 | 249150.0 |
| 2024-12-09 | ACTV | ETF | 34.66 | 34.7877 | 34.4 | 34.4 | 6295.0 |
| 2024-12-09 | ACVF | ETF | 45.98 | 45.98 | 45.51 | 45.56 | 13234.0 |
| 2024-12-09 | ACWI | ETF | 123.56 | 123.58 | 122.7371 | 122.83 | 4043687.0 |
| 2024-12-09 | ACWV | ETF | 115.41 | 115.41 | 114.66 | 114.74 | 51431.0 |
| 2024-12-09 | ACWX | ETF | 55.68 | 55.8 | 55.375 | 55.38 | 880738.0 |
| 2024-12-09 | ADFI | ETF | 8.6548 | 8.67 | 8.61 | 8.64 | 32285.0 |
| 2024-12-09 | ADIV | ETF | 16.19 | 16.19 | 16.1883 | 16.1883 | 309.0 |
| 2024-12-09 | ADME | ETF | 48.33 | 48.33 | 48.0621 | 48.14 | 9662.0 |
| 2024-12-09 | ADPV | ETF | 38.51 | 38.51 | 36.8687 | 36.8687 | 34880.0 |
| 2024-12-09 | ADVE | ETF | 35.095 | 35.095 | 34.9692 | 34.9692 | 314.0 |
| 2024-12-09 | AESR | ETF | 17.95 | 17.95 | 17.79 | 17.79 | 46936.0 |
| 2024-12-09 | AETH | ETF | 49.24 | 49.48 | 47.34 | 47.34 | 8387.0 |
| 2024-12-09 | AFIF | ETF | 9.22 | 9.22 | 9.2 | 9.205 | 3149.0 |
| 2024-12-09 | AFIX | ETF | 25.12 | 25.12 | 25.0853 | 25.0853 | 514.0 |
| 2024-12-09 | AFK | ETF | 16.63 | 16.7499 | 16.41 | 16.53 | 38645.0 |
| 2024-12-09 | AFLG | ETF | 36.2 | 36.2 | 35.94 | 35.96 | 18002.0 |
| 2024-12-09 | AFMC | ETF | 34.27 | 34.27 | 33.7763 | 33.7763 | 5124.0 |
| 2024-12-09 | AFSM | ETF | 32.6111 | 32.6111 | 32.2769 | 32.2769 | 4072.0 |
| 2024-12-09 | AGG | ETF | 99.2 | 99.22 | 99.03 | 99.04 | 9492018.0 |
| 2024-12-09 | AGGH | ETF | 21.04 | 21.04 | 20.9801 | 21.04 | 75591.0 |
| 2024-12-09 | AGGS | ETF | 41.63 | 41.63 | 41.63 | 41.63 | 60.0 |
| 2024-12-09 | AGGY | ETF | 44.04 | 44.0499 | 43.98 | 44.0 | 88094.0 |
| 2024-12-09 | AGIH | ETF | 24.72 | 24.72 | 24.72 | 24.72 | 4.0 |
| 2024-12-09 | AGIX | ETF | 30.23 | 30.23 | 29.65 | 29.81 | 30156.0 |
| 2024-12-09 | AGMI | ETF | 28.54 | 28.9881 | 28.54 | 28.9881 | 3206.0 |
| 2024-12-09 | AGNG | ETF | 31.64 | 31.67 | 31.5 | 31.5 | 3455.0 |
| 2024-12-09 | AGOX | ETF | 29.64 | 29.9 | 29.23 | 29.433 | 22637.0 |
> showing 50 of 3,817 rows — these rows as CSV