PREVIEW / etf_daily / 2024-03-07
file: by_date/etf_daily/2024/2024-03-07.parquet size: 118 KB rows: 3,291
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-03-07 | SPY | ETF | 513.14 | 515.89 | 509.81 | 514.81 | 58652100.0 |
| 2024-03-07 | QQQ | ETF | 442.42 | 446.72 | 440.86 | 445.45 | 44526666.0 |
| 2024-03-07 | IWM | ETF | 206.7 | 208.1 | 206.4 | 206.96 | 28020200.0 |
| 2024-03-07 | DIA | ETF | 389.07 | 389.72 | 387.83 | 388.45 | 2965700.0 |
| 2024-03-07 | GLD | ETF | 199.54 | 200.11 | 198.91 | 199.94 | 8403700.0 |
| 2024-03-07 | TLT | ETF | 96.36 | 96.4 | 95.48 | 95.9 | 39075000.0 |
| 2024-03-07 | AAA | ETF | 25.153 | 25.16 | 25.02 | 25.07 | 12100.0 |
| 2024-03-07 | AAAU | ETF | 21.34 | 21.4 | 21.27 | 21.37 | 2752600.0 |
| 2024-03-07 | AADR | ETF | 60.37 | 60.66 | 60.37 | 60.6 | 800.0 |
| 2024-03-07 | AAPB | ETF | 17.32 | 17.599 | 17.1532 | 17.3 | 280239.0 |
| 2024-03-07 | AAPD | ETF | 23.11 | 23.21 | 22.9189 | 23.14 | 237466.0 |
| 2024-03-07 | AAPU | ETF | 22.26 | 22.57 | 22.13 | 22.23 | 528757.0 |
| 2024-03-07 | AAPX | ETF | 20.076 | 20.51 | 20.076 | 20.22 | 26689.0 |
| 2024-03-07 | AAPY | ETF | 23.53 | 23.6 | 23.53 | 23.5405 | 671.0 |
| 2024-03-07 | AAXJ | ETF | 67.14 | 67.57 | 67.07 | 67.52 | 680400.0 |
| 2024-03-07 | ABCS | ETF | 26.339 | 26.35 | 26.3177 | 26.3177 | 11000.0 |
| 2024-03-07 | ABEQ | ETF | 29.23 | 29.31 | 29.175 | 29.228 | 2900.0 |
| 2024-03-07 | ACES | ETF | 29.77 | 30.1 | 29.59 | 29.94 | 33100.0 |
| 2024-03-07 | ACIO | ETF | 35.3 | 35.57 | 35.3 | 35.53 | 129900.0 |
| 2024-03-07 | ACSI | ETF | 49.972 | 49.972 | 49.972 | 49.972 | 100.0 |
| 2024-03-07 | ACT | ETF | 28.59 | 28.98 | 28.575 | 28.63 | 174854.0 |
| 2024-03-07 | ACTV | ETF | 33.87 | 33.89 | 33.75 | 33.89 | 10500.0 |
| 2024-03-07 | ACVF | ETF | 39.88 | 39.98 | 39.81 | 39.958 | 3100.0 |
| 2024-03-07 | ACWF | ETF | 40.86 | 41.03 | 40.84 | 40.96 | 3950.0 |
| 2024-03-07 | ACWI | ETF | 108.14 | 108.75 | 107.99 | 108.6 | 2188000.0 |
| 2024-03-07 | ACWV | ETF | 104.12 | 104.45 | 104.12 | 104.29 | 136900.0 |
| 2024-03-07 | ACWX | ETF | 52.87 | 53.18 | 52.83 | 53.14 | 1228100.0 |
| 2024-03-07 | ADFI | ETF | 8.525 | 8.54 | 8.5 | 8.54 | 12400.0 |
| 2024-03-07 | ADIV | ETF | 14.27 | 14.422 | 14.27 | 14.42 | 2300.0 |
| 2024-03-07 | ADME | ETF | 41.09 | 41.45 | 41.09 | 41.42 | 18200.0 |
| 2024-03-07 | AEMB | ETF | 38.49 | 38.55 | 38.182 | 38.55 | 1200.0 |
| 2024-03-07 | AESR | ETF | 15.39 | 15.51 | 15.39 | 15.44 | 22000.0 |
| 2024-03-07 | AETH | ETF | 52.21 | 53.58 | 51.84 | 53.574 | 22328.0 |
| 2024-03-07 | AFIF | ETF | 9.11 | 9.14 | 9.11 | 9.14 | 9200.0 |
| 2024-03-07 | AFK | ETF | 13.43 | 13.5 | 13.35 | 13.5 | 11800.0 |
| 2024-03-07 | AFLG | ETF | 30.155 | 30.155 | 30.155 | 30.155 | 100.0 |
| 2024-03-07 | AFMC | ETF | 29.149 | 29.21 | 29.07 | 29.16 | 800.0 |
| 2024-03-07 | AFSM | ETF | 28.69 | 28.69 | 28.615 | 28.615 | 600.0 |
| 2024-03-07 | AFTY | ETF | 13.87 | 13.897 | 13.87 | 13.897 | 3300.0 |
| 2024-03-07 | AGG | ETF | 98.22 | 98.24 | 97.97 | 98.18 | 7726600.0 |
| 2024-03-07 | AGGH | ETF | 21.73 | 21.73 | 21.54 | 21.54 | 95050.0 |
| 2024-03-07 | AGGY | ETF | 43.6 | 43.6 | 43.495 | 43.575 | 60100.0 |
| 2024-03-07 | AGNG | ETF | 30.24 | 30.44 | 30.19 | 30.39 | 31600.0 |
| 2024-03-07 | AGOX | ETF | 25.92 | 26.184 | 25.86 | 26.18 | 43900.0 |
| 2024-03-07 | AGQ | ETF | 27.44 | 28.1 | 27.4 | 27.67 | 954000.0 |
| 2024-03-07 | AGQI | ETF | 13.81 | 13.92 | 13.81 | 13.89 | 36226.0 |
| 2024-03-07 | AGZ | ETF | 108.22 | 108.23 | 108.13 | 108.18 | 16900.0 |
| 2024-03-07 | AGZD | ETF | 22.0 | 22.11 | 21.99 | 22.02 | 19000.0 |
| 2024-03-07 | AHLT | ETF | 23.14 | 23.22 | 23.14 | 23.1899 | 17642.0 |
| 2024-03-07 | AHOY | ETF | 23.69 | 23.7022 | 23.69 | 23.7022 | 412.0 |
> showing 50 of 3,291 rows — these rows as CSV