PREVIEW / etf_daily / 2024-01-22
file: by_date/etf_daily/2024/2024-01-22.parquet size: 117 KB rows: 3,249
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-01-22 | SPY | ETF | 484.01 | 485.22 | 482.78 | 483.45 | 75844900.0 |
| 2024-01-22 | QQQ | ETF | 423.41 | 424.7275 | 421.12 | 421.73 | 44880639.0 |
| 2024-01-22 | IWM | ETF | 194.15 | 196.82 | 194.09 | 196.54 | 42379500.0 |
| 2024-01-22 | DIA | ETF | 379.69 | 381.08 | 379.08 | 380.07 | 5433400.0 |
| 2024-01-22 | GLD | ETF | 187.23 | 187.76 | 186.85 | 187.22 | 4397500.0 |
| 2024-01-22 | TLT | ETF | 94.82 | 95.08 | 94.39 | 94.65 | 35756400.0 |
| 2024-01-22 | AAA | ETF | 25.12 | 25.17 | 25.12 | 25.13 | 2400.0 |
| 2024-01-22 | AAAU | ETF | 20.0 | 20.07 | 19.97 | 20.01 | 3069400.0 |
| 2024-01-22 | AADR | ETF | 54.39 | 54.39 | 54.39 | 54.39 | 3100.0 |
| 2024-01-22 | AAPB | ETF | 22.7 | 23.39 | 22.7 | 23.1 | 65179.0 |
| 2024-01-22 | AAPD | ETF | 20.2 | 20.215 | 19.91 | 20.05 | 325417.0 |
| 2024-01-22 | AAPU | ETF | 27.24 | 27.8173 | 27.19 | 27.51 | 186958.0 |
| 2024-01-22 | AAPX | ETF | 26.62 | 27.24 | 26.62 | 26.9585 | 2512.0 |
| 2024-01-22 | AAPY | ETF | 26.92 | 26.92 | 26.86 | 26.869 | 970.0 |
| 2024-01-22 | AAXJ | ETF | 62.22 | 62.61 | 62.17 | 62.49 | 515100.0 |
| 2024-01-22 | ABCS | ETF | 24.99 | 25.08 | 24.99 | 25.0146 | 3322.0 |
| 2024-01-22 | ABEQ | ETF | 28.47 | 28.5 | 28.44 | 28.474 | 7700.0 |
| 2024-01-22 | ACES | ETF | 29.28 | 30.74 | 29.28 | 29.92 | 185700.0 |
| 2024-01-22 | ACIO | ETF | 33.76 | 33.77 | 33.655 | 33.684 | 44800.0 |
| 2024-01-22 | ACSI | ETF | 49.57 | 49.59 | 49.57 | 49.579 | 1000.0 |
| 2024-01-22 | ACT | ETF | 28.26 | 28.49 | 28.1 | 28.43 | 925494.0 |
| 2024-01-22 | ACTV | ETF | 32.55 | 32.93 | 32.55 | 32.88 | 15700.0 |
| 2024-01-22 | ACVF | ETF | 37.41 | 37.41 | 37.18 | 37.218 | 7000.0 |
| 2024-01-22 | ACWF | ETF | 38.3 | 38.38 | 38.3 | 38.3217 | 4891.0 |
| 2024-01-22 | ACWI | ETF | 101.87 | 102.15 | 101.68 | 101.83 | 17480900.0 |
| 2024-01-22 | ACWV | ETF | 100.94 | 101.17 | 100.94 | 101.04 | 69800.0 |
| 2024-01-22 | ACWX | ETF | 49.54 | 49.78 | 49.54 | 49.64 | 1610800.0 |
| 2024-01-22 | ADFI | ETF | 8.55 | 8.56 | 8.535 | 8.55 | 6400.0 |
| 2024-01-22 | ADIV | ETF | 13.41 | 13.45 | 13.382 | 13.45 | 1100.0 |
| 2024-01-22 | ADME | ETF | 39.16 | 39.18 | 39.04 | 39.07 | 16700.0 |
| 2024-01-22 | ADPV | ETF | 25.32 | 25.32 | 25.24 | 25.2639 | 2446.0 |
| 2024-01-22 | ADVE | ETF | 30.9065 | 30.9073 | 30.9065 | 30.9073 | 2910.0 |
| 2024-01-22 | AEMB | ETF | 37.75 | 37.86 | 37.572 | 37.572 | 1500.0 |
| 2024-01-22 | AESR | ETF | 14.22 | 14.23 | 14.19 | 14.2 | 18100.0 |
| 2024-01-22 | AETH | ETF | 32.92 | 32.92 | 31.7201 | 32.0772 | 7795.0 |
| 2024-01-22 | AFIF | ETF | 9.09 | 9.09 | 9.03 | 9.08 | 39400.0 |
| 2024-01-22 | AFK | ETF | 13.41 | 13.7 | 13.27 | 13.27 | 9100.0 |
| 2024-01-22 | AFLG | ETF | 27.905 | 27.905 | 27.905 | 27.905 | 100.0 |
| 2024-01-22 | AFMC | ETF | 26.963 | 27.01 | 26.963 | 27.01 | 1000.0 |
| 2024-01-22 | AFSM | ETF | 27.125 | 27.237 | 27.125 | 27.237 | 1600.0 |
| 2024-01-22 | AFTY | ETF | 12.81 | 12.853 | 12.81 | 12.853 | 100.0 |
| 2024-01-22 | AGG | ETF | 98.26 | 98.36 | 98.1 | 98.2 | 8712600.0 |
| 2024-01-22 | AGGH | ETF | 21.7 | 21.8 | 21.67 | 21.67 | 89639.0 |
| 2024-01-22 | AGGY | ETF | 43.65 | 43.67 | 43.575 | 43.59 | 104700.0 |
| 2024-01-22 | AGIH | ETF | 24.49 | 24.49 | 24.49 | 24.49 | 100.0 |
| 2024-01-22 | AGNG | ETF | 28.44 | 28.52 | 28.4 | 28.43 | 1200.0 |
| 2024-01-22 | AGOX | ETF | 24.2 | 24.3 | 24.05 | 24.249 | 16700.0 |
| 2024-01-22 | AGQ | ETF | 22.91 | 23.62 | 22.82 | 23.11 | 1571700.0 |
| 2024-01-22 | AGQI | ETF | 13.21 | 13.26 | 13.21 | 13.22 | 22212.0 |
| 2024-01-22 | AGZ | ETF | 108.11 | 108.25 | 108.1 | 108.1 | 37200.0 |
> showing 50 of 3,249 rows — these rows as CSV