PREVIEW / etf_daily / 2024-05-07
file: by_date/etf_daily/2024/2024-05-07.parquet size: 120 KB rows: 3,320
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-05-07 | SPY | ETF | 517.56 | 518.57 | 516.45 | 517.14 | 52561300.0 |
| 2024-05-07 | QQQ | ETF | 440.7 | 441.97 | 439.58 | 440.32 | 30996094.0 |
| 2024-05-07 | IWM | ETF | 204.77 | 206.15 | 204.5 | 204.97 | 20116900.0 |
| 2024-05-07 | DIA | ETF | 389.17 | 389.75 | 388.34 | 388.74 | 2428600.0 |
| 2024-05-07 | GLD | ETF | 214.52 | 214.93 | 213.88 | 214.21 | 5660700.0 |
| 2024-05-07 | TLT | ETF | 90.9 | 91.24 | 90.61 | 90.74 | 30525800.0 |
| 2024-05-07 | AAA | ETF | 25.15 | 25.15 | 25.03 | 25.09 | 3300.0 |
| 2024-05-07 | AAAU | ETF | 22.95 | 22.99 | 22.87 | 22.91 | 2093100.0 |
| 2024-05-07 | AADR | ETF | 64.06 | 64.1 | 63.62 | 63.85 | 1800.0 |
| 2024-05-07 | AAPB | ETF | 19.7 | 19.96 | 19.25 | 19.45 | 188605.0 |
| 2024-05-07 | AAPD | ETF | 21.15 | 21.41 | 21.015 | 21.31 | 204444.0 |
| 2024-05-07 | AAPR | ETF | 24.69 | 24.7 | 24.61 | 24.62 | 41744.0 |
| 2024-05-07 | AAPU | ETF | 25.41 | 25.7701 | 24.8 | 25.09 | 659081.0 |
| 2024-05-07 | AAPX | ETF | 23.0 | 23.21 | 22.41 | 22.7014 | 20196.0 |
| 2024-05-07 | AAPY | ETF | 24.79 | 24.79 | 24.66 | 24.7405 | 575.0 |
| 2024-05-07 | AAXJ | ETF | 70.43 | 70.52 | 70.28 | 70.33 | 826500.0 |
| 2024-05-07 | ABCS | ETF | 26.465 | 26.465 | 26.3912 | 26.3912 | 2001.0 |
| 2024-05-07 | ABEQ | ETF | 30.34 | 30.38 | 30.28 | 30.354 | 5700.0 |
| 2024-05-07 | ACES | ETF | 29.31 | 29.39 | 28.88 | 28.88 | 72300.0 |
| 2024-05-07 | ACIO | ETF | 35.81 | 35.93 | 35.79 | 35.88 | 157700.0 |
| 2024-05-07 | ACSI | ETF | 52.808 | 52.808 | 52.808 | 52.808 | 100.0 |
| 2024-05-07 | ACT | ETF | 31.38 | 31.81 | 31.38 | 31.48 | 169757.0 |
| 2024-05-07 | ACTV | ETF | 34.077 | 34.188 | 33.965 | 33.965 | 9900.0 |
| 2024-05-07 | ACVF | ETF | 39.39 | 39.39 | 39.25 | 39.298 | 5800.0 |
| 2024-05-07 | ACWF | ETF | 41.23 | 41.23 | 41.07 | 41.14 | 2781.0 |
| 2024-05-07 | ACWI | ETF | 109.56 | 109.7 | 109.3 | 109.44 | 2224000.0 |
| 2024-05-07 | ACWV | ETF | 103.72 | 104.1 | 103.72 | 104.08 | 184500.0 |
| 2024-05-07 | ACWX | ETF | 53.79 | 53.83 | 53.62 | 53.68 | 2470100.0 |
| 2024-05-07 | ADFI | ETF | 8.479 | 8.489 | 8.455 | 8.47 | 12500.0 |
| 2024-05-07 | ADIV | ETF | 14.57 | 14.57 | 14.57 | 14.57 | 100.0 |
| 2024-05-07 | ADME | ETF | 41.46 | 41.56 | 41.42 | 41.55 | 14800.0 |
| 2024-05-07 | ADPV | ETF | 30.24 | 30.24 | 29.8874 | 29.8874 | 6090.0 |
| 2024-05-07 | AEMB | ETF | 42.24 | 42.24 | 38.52 | 38.52 | 400.0 |
| 2024-05-07 | AESR | ETF | 15.3 | 15.33 | 15.25 | 15.28 | 99700.0 |
| 2024-05-07 | AETH | ETF | 40.4701 | 40.4701 | 39.951 | 40.1539 | 4656.0 |
| 2024-05-07 | AFIF | ETF | 9.11 | 9.11 | 9.1 | 9.11 | 39300.0 |
| 2024-05-07 | AFK | ETF | 15.5 | 15.56 | 15.44 | 15.51 | 9700.0 |
| 2024-05-07 | AFLG | ETF | 30.286 | 30.286 | 30.286 | 30.286 | 100.0 |
| 2024-05-07 | AFSM | ETF | 28.796 | 28.796 | 28.796 | 28.796 | 100.0 |
| 2024-05-07 | AFTY | ETF | 14.74 | 14.76 | 14.74 | 14.75 | 900.0 |
| 2024-05-07 | AGG | ETF | 96.53 | 96.67 | 96.38 | 96.46 | 7687000.0 |
| 2024-05-07 | AGGH | ETF | 20.92 | 20.9433 | 20.7957 | 20.84 | 115959.0 |
| 2024-05-07 | AGGS | ETF | 40.63 | 40.63 | 40.535 | 40.535 | 100000.0 |
| 2024-05-07 | AGGY | ETF | 42.8 | 43.02 | 42.795 | 43.02 | 49600.0 |
| 2024-05-07 | AGMI | ETF | 25.87 | 25.9556 | 25.87 | 25.9556 | 104.0 |
| 2024-05-07 | AGNG | ETF | 29.22 | 29.498 | 29.22 | 29.43 | 2300.0 |
| 2024-05-07 | AGOX | ETF | 25.204 | 25.326 | 25.1 | 25.184 | 18700.0 |
| 2024-05-07 | AGQ | ETF | 34.16 | 34.34 | 33.75 | 33.87 | 635700.0 |
| 2024-05-07 | AGQI | ETF | 14.02 | 14.025 | 13.98 | 14.0203 | 4773.0 |
| 2024-05-07 | AGRH | ETF | 25.93 | 25.93 | 25.895 | 25.895 | 129.0 |
> showing 50 of 3,320 rows — these rows as CSV