PREVIEW / etf_daily / 2024-04-09
file: by_date/etf_daily/2024/2024-04-09.parquet size: 119 KB rows: 3,325
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-09 | SPY | ETF | 520.5 | 520.75 | 514.35 | 519.32 | 68124400.0 |
| 2024-04-09 | QQQ | ETF | 442.96 | 443.24 | 437.44 | 442.23 | 39521568.0 |
| 2024-04-09 | IWM | ETF | 206.22 | 206.97 | 204.47 | 206.38 | 23330900.0 |
| 2024-04-09 | DIA | ETF | 389.62 | 389.98 | 385.73 | 388.84 | 4004700.0 |
| 2024-04-09 | GLD | ETF | 217.81 | 218.86 | 216.45 | 217.67 | 13079300.0 |
| 2024-04-09 | TLT | ETF | 91.87 | 92.36 | 91.84 | 92.23 | 32537000.0 |
| 2024-04-09 | AAA | ETF | 25.07 | 25.07 | 25.06 | 25.07 | 9200.0 |
| 2024-04-09 | AAAU | ETF | 23.3 | 23.4 | 23.15 | 23.28 | 4797700.0 |
| 2024-04-09 | AADR | ETF | 62.78 | 62.78 | 62.22 | 62.22 | 900.0 |
| 2024-04-09 | AAPB | ETF | 16.93 | 17.1801 | 16.8813 | 17.14 | 95949.0 |
| 2024-04-09 | AAPD | ETF | 23.1 | 23.1324 | 22.91 | 22.96 | 106050.0 |
| 2024-04-09 | AAPR | ETF | 24.74 | 24.74 | 24.65 | 24.74 | 36240.0 |
| 2024-04-09 | AAPU | ETF | 21.82 | 22.179 | 21.73 | 22.07 | 277221.0 |
| 2024-04-09 | AAPX | ETF | 19.77 | 20.09 | 19.69 | 20.0 | 27271.0 |
| 2024-04-09 | AAPY | ETF | 23.47 | 23.47 | 23.43 | 23.4628 | 316.0 |
| 2024-04-09 | AAXJ | ETF | 68.68 | 68.89 | 68.47 | 68.83 | 489200.0 |
| 2024-04-09 | ABCS | ETF | 26.7625 | 26.89 | 26.75 | 26.89 | 2559.0 |
| 2024-04-09 | ABEQ | ETF | 30.08 | 30.106 | 29.97 | 30.106 | 5800.0 |
| 2024-04-09 | ACES | ETF | 29.1 | 29.64 | 29.1 | 29.64 | 53700.0 |
| 2024-04-09 | ACIO | ETF | 35.83 | 35.847 | 35.54 | 35.75 | 69200.0 |
| 2024-04-09 | ACSI | ETF | 51.154 | 51.154 | 51.154 | 51.154 | 200.0 |
| 2024-04-09 | ACT | ETF | 30.68 | 30.845 | 30.37 | 30.57 | 290781.0 |
| 2024-04-09 | ACTV | ETF | 34.52 | 34.52 | 34.27 | 34.407 | 6300.0 |
| 2024-04-09 | ACVF | ETF | 40.01 | 40.01 | 39.508 | 39.788 | 15600.0 |
| 2024-04-09 | ACWF | ETF | 41.32 | 41.32 | 41.055 | 41.2013 | 3408.0 |
| 2024-04-09 | ACWI | ETF | 109.93 | 109.97 | 108.77 | 109.62 | 1983600.0 |
| 2024-04-09 | ACWV | ETF | 104.05 | 104.23 | 103.59 | 104.12 | 86700.0 |
| 2024-04-09 | ACWX | ETF | 53.62 | 53.7 | 53.22 | 53.47 | 1155900.0 |
| 2024-04-09 | ADFI | ETF | 8.49 | 8.55 | 8.475 | 8.5 | 34800.0 |
| 2024-04-09 | ADIV | ETF | 14.19 | 14.19 | 14.19 | 14.19 | 100.0 |
| 2024-04-09 | ADME | ETF | 41.75 | 41.75 | 41.36 | 41.671 | 3100.0 |
| 2024-04-09 | ADPV | ETF | 30.22 | 30.22 | 29.77 | 29.9932 | 4027.0 |
| 2024-04-09 | AEMB | ETF | 38.474 | 38.98 | 38.474 | 38.88 | 2100.0 |
| 2024-04-09 | AESR | ETF | 15.48 | 15.48 | 15.3 | 15.386 | 24600.0 |
| 2024-04-09 | AETH | ETF | 48.23 | 48.37 | 45.88 | 46.71 | 26090.0 |
| 2024-04-09 | AFIF | ETF | 9.1 | 9.12 | 9.1 | 9.12 | 6600.0 |
| 2024-04-09 | AFK | ETF | 15.11 | 15.49 | 15.1 | 15.48 | 7500.0 |
| 2024-04-09 | AFLG | ETF | 30.75 | 30.75 | 30.38 | 30.548 | 2400.0 |
| 2024-04-09 | AFMC | ETF | 29.47 | 29.554 | 29.47 | 29.554 | 1000.0 |
| 2024-04-09 | AFSM | ETF | 28.648 | 28.648 | 28.55 | 28.576 | 2000.0 |
| 2024-04-09 | AFTY | ETF | 13.981 | 13.981 | 13.981 | 13.981 | 100.0 |
| 2024-04-09 | AGG | ETF | 96.83 | 96.98 | 96.83 | 96.92 | 5736500.0 |
| 2024-04-09 | AGGH | ETF | 21.12 | 21.12 | 21.03 | 21.075 | 49495.0 |
| 2024-04-09 | AGGY | ETF | 42.96 | 43.06 | 42.96 | 43.05 | 65400.0 |
| 2024-04-09 | AGNG | ETF | 29.49 | 29.53 | 29.39 | 29.53 | 2600.0 |
| 2024-04-09 | AGOX | ETF | 25.13 | 25.15 | 24.97 | 25.15 | 84500.0 |
| 2024-04-09 | AGQ | ETF | 36.63 | 37.05 | 35.24 | 36.55 | 2105000.0 |
| 2024-04-09 | AGQI | ETF | 13.95 | 13.97 | 13.86 | 13.935 | 34166.0 |
| 2024-04-09 | AGZ | ETF | 107.32 | 107.45 | 107.16 | 107.16 | 15800.0 |
| 2024-04-09 | AGZD | ETF | 22.23 | 22.23 | 22.1 | 22.13 | 28300.0 |
> showing 50 of 3,325 rows — these rows as CSV