PREVIEW / etf_daily / 2024-04-24
file: by_date/etf_daily/2024/2024-04-24.parquet size: 119 KB rows: 3,313
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-04-24 | SPY | ETF | 506.56 | 507.37 | 503.13 | 505.41 | 55928100.0 |
| 2024-04-24 | QQQ | ETF | 428.2 | 429.73 | 424.2 | 426.51 | 48440305.0 |
| 2024-04-24 | IWM | ETF | 198.17 | 198.91 | 196.46 | 197.68 | 28791700.0 |
| 2024-04-24 | DIA | ETF | 384.87 | 385.47 | 383.02 | 384.44 | 3575800.0 |
| 2024-04-24 | GLD | ETF | 214.76 | 216.35 | 214.36 | 214.64 | 5741100.0 |
| 2024-04-24 | TLT | ETF | 88.56 | 88.63 | 87.5 | 88.4 | 48986800.0 |
| 2024-04-24 | AAA | ETF | 25.14 | 25.14 | 25.14 | 25.14 | 200.0 |
| 2024-04-24 | AAAU | ETF | 22.97 | 23.14 | 22.93 | 22.96 | 3350200.0 |
| 2024-04-24 | AADR | ETF | 60.14 | 60.27 | 60.14 | 60.27 | 200.0 |
| 2024-04-24 | AAPB | ETF | 16.34 | 16.909 | 16.34 | 16.86 | 157211.0 |
| 2024-04-24 | AAPD | ETF | 23.38 | 23.3817 | 23.0 | 23.05 | 270032.0 |
| 2024-04-24 | AAPR | ETF | 24.47 | 24.47 | 24.38 | 24.4427 | 63568.0 |
| 2024-04-24 | AAPU | ETF | 21.09 | 21.796 | 21.03 | 21.73 | 461643.0 |
| 2024-04-24 | AAPX | ETF | 19.13 | 19.69 | 19.119 | 19.67 | 20976.0 |
| 2024-04-24 | AAXJ | ETF | 67.5 | 67.62 | 67.18 | 67.41 | 418300.0 |
| 2024-04-24 | ABCS | ETF | 26.02 | 26.031 | 25.935 | 26.031 | 1701.0 |
| 2024-04-24 | ABEQ | ETF | 29.64 | 29.783 | 29.64 | 29.783 | 1700.0 |
| 2024-04-24 | ACES | ETF | 26.86 | 27.05 | 26.39 | 26.69 | 29800.0 |
| 2024-04-24 | ACIO | ETF | 35.32 | 35.32 | 35.083 | 35.24 | 196900.0 |
| 2024-04-24 | ACSI | ETF | 50.839 | 50.839 | 50.839 | 50.839 | 100.0 |
| 2024-04-24 | ACT | ETF | 29.92 | 30.03 | 29.76 | 30.0 | 169436.0 |
| 2024-04-24 | ACTV | ETF | 32.92 | 32.92 | 32.67 | 32.883 | 4100.0 |
| 2024-04-24 | ACVF | ETF | 38.78 | 38.795 | 38.54 | 38.695 | 3800.0 |
| 2024-04-24 | ACWF | ETF | 40.24 | 40.24 | 40.01 | 40.1679 | 2911.0 |
| 2024-04-24 | ACWI | ETF | 107.05 | 107.13 | 106.27 | 106.72 | 2191900.0 |
| 2024-04-24 | ACWV | ETF | 102.72 | 102.95 | 102.41 | 102.82 | 115400.0 |
| 2024-04-24 | ACWX | ETF | 52.42 | 52.42 | 51.99 | 52.17 | 1060100.0 |
| 2024-04-24 | ADFI | ETF | 8.36 | 8.37 | 8.34 | 8.37 | 18300.0 |
| 2024-04-24 | ADIV | ETF | 13.82 | 13.85 | 13.82 | 13.85 | 200.0 |
| 2024-04-24 | ADME | ETF | 40.69 | 40.76 | 40.52 | 40.75 | 5800.0 |
| 2024-04-24 | ADPV | ETF | 28.77 | 28.77 | 28.53 | 28.5864 | 888.0 |
| 2024-04-24 | AEMB | ETF | 37.894 | 37.894 | 37.894 | 37.894 | 100.0 |
| 2024-04-24 | AESR | ETF | 15.05 | 15.05 | 14.84 | 14.922 | 9000.0 |
| 2024-04-24 | AETH | ETF | 43.18 | 43.18 | 41.3531 | 41.3531 | 2417.0 |
| 2024-04-24 | AFIF | ETF | 9.07 | 9.07 | 9.04 | 9.06 | 18900.0 |
| 2024-04-24 | AFK | ETF | 14.57 | 14.63 | 14.55 | 14.6 | 1800.0 |
| 2024-04-24 | AFLG | ETF | 29.46 | 29.671 | 29.46 | 29.671 | 100.0 |
| 2024-04-24 | AFMC | ETF | 28.79 | 28.79 | 28.77 | 28.77 | 300.0 |
| 2024-04-24 | AFSM | ETF | 27.88 | 28.03 | 27.88 | 28.03 | 400.0 |
| 2024-04-24 | AFTY | ETF | 13.98 | 14.045 | 13.98 | 14.03 | 900.0 |
| 2024-04-24 | AGG | ETF | 95.38 | 95.47 | 95.2 | 95.39 | 7961000.0 |
| 2024-04-24 | AGGH | ETF | 20.6858 | 20.74 | 20.655 | 20.675 | 30896.0 |
| 2024-04-24 | AGGY | ETF | 42.24 | 42.24 | 42.13 | 42.21 | 48500.0 |
| 2024-04-24 | AGNG | ETF | 28.82 | 28.867 | 28.76 | 28.76 | 59400.0 |
| 2024-04-24 | AGOX | ETF | 25.01 | 25.01 | 24.594 | 24.7 | 17500.0 |
| 2024-04-24 | AGQ | ETF | 33.97 | 34.4 | 33.68 | 33.96 | 884900.0 |
| 2024-04-24 | AGQI | ETF | 13.74 | 13.75 | 13.655 | 13.725 | 24506.0 |
| 2024-04-24 | AGZ | ETF | 106.73 | 106.79 | 106.65 | 106.79 | 13100.0 |
| 2024-04-24 | AGZD | ETF | 22.1 | 22.21 | 22.1 | 22.13 | 32700.0 |
| 2024-04-24 | AHLT | ETF | 25.32 | 25.46 | 25.2543 | 25.2543 | 5340.0 |
> showing 50 of 3,313 rows — these rows as CSV