PREVIEW / etf_daily / 2024-03-05
file: by_date/etf_daily/2024/2024-03-05.parquet size: 118 KB rows: 3,273
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-05 | SPY | ETF | 510.24 | 510.7 | 504.91 | 507.18 | 72855600.0 |
| 2024-03-05 | QQQ | ETF | 440.94 | 440.95 | 433.65 | 436.05 | 57917135.0 |
| 2024-03-05 | IWM | ETF | 204.3 | 205.91 | 203.01 | 203.73 | 34163500.0 |
| 2024-03-05 | DIA | ETF | 388.99 | 389.29 | 384.92 | 386.19 | 4132400.0 |
| 2024-03-05 | GLD | ETF | 197.44 | 198.14 | 196.65 | 197.19 | 9672200.0 |
| 2024-03-05 | TLT | ETF | 95.23 | 95.68 | 94.97 | 95.43 | 37721900.0 |
| 2024-03-05 | AAA | ETF | 25.04 | 25.15 | 25.04 | 25.1 | 4000.0 |
| 2024-03-05 | AAAU | ETF | 21.11 | 21.18 | 21.02 | 21.08 | 2796700.0 |
| 2024-03-05 | AADR | ETF | 59.25 | 59.25 | 59.25 | 59.25 | 100.0 |
| 2024-03-05 | AAPB | ETF | 17.61 | 17.89 | 17.42 | 17.5 | 219822.0 |
| 2024-03-05 | AAPD | ETF | 22.93 | 23.03 | 22.736 | 22.97 | 652068.0 |
| 2024-03-05 | AAPU | ETF | 22.57 | 22.84 | 22.3716 | 22.48 | 530364.0 |
| 2024-03-05 | AAPX | ETF | 20.61 | 20.83 | 20.361 | 20.429 | 23093.0 |
| 2024-03-05 | AAXJ | ETF | 66.32 | 66.48 | 65.91 | 66.02 | 781700.0 |
| 2024-03-05 | ABCS | ETF | 26.05 | 26.05 | 25.9499 | 25.9623 | 2895.0 |
| 2024-03-05 | ABEQ | ETF | 29.094 | 29.11 | 28.93 | 29.017 | 15600.0 |
| 2024-03-05 | ACES | ETF | 29.26 | 29.5 | 28.94 | 28.94 | 116300.0 |
| 2024-03-05 | ACIO | ETF | 35.221 | 35.221 | 34.93 | 35.054 | 44200.0 |
| 2024-03-05 | ACSI | ETF | 49.75 | 49.768 | 49.75 | 49.768 | 200.0 |
| 2024-03-05 | ACT | ETF | 27.93 | 28.27 | 27.89 | 28.06 | 180199.0 |
| 2024-03-05 | ACTV | ETF | 33.548 | 33.59 | 33.34 | 33.35 | 5100.0 |
| 2024-03-05 | ACVF | ETF | 39.54 | 39.54 | 39.09 | 39.262 | 5200.0 |
| 2024-03-05 | ACWF | ETF | 40.3028 | 40.48 | 40.08 | 40.1999 | 3845.0 |
| 2024-03-05 | ACWI | ETF | 107.2 | 107.37 | 106.24 | 106.65 | 3913600.0 |
| 2024-03-05 | ACWV | ETF | 103.43 | 103.48 | 102.83 | 103.07 | 71400.0 |
| 2024-03-05 | ACWX | ETF | 52.12 | 52.27 | 51.82 | 51.93 | 904500.0 |
| 2024-03-05 | ADFI | ETF | 8.53 | 8.53 | 8.5 | 8.53 | 18500.0 |
| 2024-03-05 | ADIV | ETF | 13.98 | 13.989 | 13.98 | 13.989 | 700.0 |
| 2024-03-05 | ADME | ETF | 41.026 | 41.026 | 40.66 | 40.82 | 7000.0 |
| 2024-03-05 | ADPV | ETF | 27.99 | 27.99 | 27.9094 | 27.9678 | 628.0 |
| 2024-03-05 | AEMB | ETF | 38.22 | 38.33 | 37.4 | 38.28 | 9500.0 |
| 2024-03-05 | AESR | ETF | 15.24 | 15.27 | 15.1 | 15.166 | 29100.0 |
| 2024-03-05 | AETH | ETF | 51.66 | 52.1436 | 43.94 | 46.5454 | 41823.0 |
| 2024-03-05 | AFIF | ETF | 9.1 | 9.14 | 9.09 | 9.13 | 25200.0 |
| 2024-03-05 | AFK | ETF | 13.49 | 13.5 | 13.27 | 13.42 | 5100.0 |
| 2024-03-05 | AFLG | ETF | 29.655 | 29.655 | 29.655 | 29.655 | 100.0 |
| 2024-03-05 | AFMC | ETF | 28.91 | 28.91 | 28.784 | 28.784 | 400.0 |
| 2024-03-05 | AFSM | ETF | 28.36 | 28.37 | 28.3 | 28.345 | 400.0 |
| 2024-03-05 | AFTY | ETF | 14.0 | 14.0 | 13.95 | 13.95 | 1300.0 |
| 2024-03-05 | AGG | ETF | 97.69 | 97.92 | 97.6 | 97.82 | 6815500.0 |
| 2024-03-05 | AGGH | ETF | 21.68 | 21.68 | 21.48 | 21.54 | 66081.0 |
| 2024-03-05 | AGGY | ETF | 43.38 | 43.47 | 43.351 | 43.42 | 461200.0 |
| 2024-03-05 | AGNG | ETF | 29.88 | 29.88 | 29.64 | 29.685 | 7700.0 |
| 2024-03-05 | AGOX | ETF | 25.51 | 25.51 | 25.25 | 25.51 | 30800.0 |
| 2024-03-05 | AGQ | ETF | 26.98 | 27.23 | 26.22 | 26.25 | 1388300.0 |
| 2024-03-05 | AGQI | ETF | 13.65 | 13.6679 | 13.5699 | 13.5971 | 46749.0 |
| 2024-03-05 | AGRH | ETF | 25.8 | 25.8 | 25.77 | 25.7755 | 433.0 |
| 2024-03-05 | AGZ | ETF | 108.04 | 108.07 | 107.96 | 108.01 | 14500.0 |
| 2024-03-05 | AGZD | ETF | 21.96 | 22.16 | 21.96 | 22.04 | 40200.0 |
| 2024-03-05 | AHLT | ETF | 23.195 | 23.195 | 23.095 | 23.1252 | 512.0 |
> showing 50 of 3,273 rows — these rows as CSV