PREVIEW / etf_daily / 2024-03-21
file: by_date/etf_daily/2024/2024-03-21.parquet size: 118 KB rows: 3,302
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-21 | SPY | ETF | 523.39 | 524.11 | 521.91 | 522.2 | 60256100.0 |
| 2024-03-21 | QQQ | ETF | 448.88 | 449.34 | 445.67 | 445.87 | 39345652.0 |
| 2024-03-21 | IWM | ETF | 207.0 | 208.95 | 206.84 | 207.94 | 43067300.0 |
| 2024-03-21 | DIA | ETF | 396.31 | 398.82 | 395.81 | 397.75 | 4348400.0 |
| 2024-03-21 | GLD | ETF | 203.88 | 203.92 | 200.6 | 201.97 | 7396500.0 |
| 2024-03-21 | TLT | ETF | 93.27 | 93.43 | 92.73 | 93.09 | 34276600.0 |
| 2024-03-21 | AAA | ETF | 25.2 | 25.2 | 25.1 | 25.1 | 14300.0 |
| 2024-03-21 | AAAU | ETF | 21.8 | 21.8 | 21.45 | 21.6 | 3734300.0 |
| 2024-03-21 | AADR | ETF | 61.85 | 62.31 | 61.85 | 62.31 | 1600.0 |
| 2024-03-21 | AAPB | ETF | 18.84 | 18.89 | 17.49 | 17.59 | 639598.0 |
| 2024-03-21 | AAPD | ETF | 21.93 | 22.73 | 21.929 | 22.65 | 487333.0 |
| 2024-03-21 | AAPU | ETF | 23.72 | 23.77 | 22.43 | 22.54 | 928162.0 |
| 2024-03-21 | AAPX | ETF | 21.92 | 22.02 | 20.43 | 20.51 | 67192.0 |
| 2024-03-21 | AAPY | ETF | 23.67 | 23.75 | 23.5672 | 23.6542 | 1842.0 |
| 2024-03-21 | AAXJ | ETF | 68.31 | 68.37 | 67.93 | 67.93 | 437100.0 |
| 2024-03-21 | ABCS | ETF | 26.9177 | 26.9835 | 26.9177 | 26.9348 | 4392.0 |
| 2024-03-21 | ABEQ | ETF | 29.78 | 29.825 | 29.78 | 29.796 | 800.0 |
| 2024-03-21 | ACES | ETF | 28.74 | 29.24 | 28.73 | 28.73 | 88500.0 |
| 2024-03-21 | ACIO | ETF | 36.06 | 36.1 | 35.969 | 36.02 | 95600.0 |
| 2024-03-21 | ACSI | ETF | 51.378 | 51.378 | 51.378 | 51.378 | 100.0 |
| 2024-03-21 | ACT | ETF | 30.41 | 30.72 | 30.41 | 30.68 | 208440.0 |
| 2024-03-21 | ACTV | ETF | 34.53 | 34.63 | 34.52 | 34.54 | 13800.0 |
| 2024-03-21 | ACVF | ETF | 40.53 | 40.64 | 40.326 | 40.415 | 33400.0 |
| 2024-03-21 | ACWF | ETF | 41.41 | 41.46 | 41.355 | 41.3774 | 3228.0 |
| 2024-03-21 | ACWI | ETF | 110.26 | 110.37 | 109.94 | 109.98 | 4229400.0 |
| 2024-03-21 | ACWV | ETF | 105.23 | 105.23 | 104.96 | 105.02 | 164100.0 |
| 2024-03-21 | ACWX | ETF | 53.55 | 53.59 | 53.37 | 53.39 | 2119800.0 |
| 2024-03-21 | ADFI | ETF | 8.53 | 8.53 | 8.518 | 8.52 | 2200.0 |
| 2024-03-21 | ADIV | ETF | 14.43 | 14.43 | 14.29 | 14.29 | 300.0 |
| 2024-03-21 | ADME | ETF | 42.04 | 42.1 | 41.98 | 42.002 | 20000.0 |
| 2024-03-21 | ADPV | ETF | 30.0835 | 30.35 | 30.0835 | 30.2358 | 1957.0 |
| 2024-03-21 | ADVE | ETF | 32.82 | 32.82 | 32.7551 | 32.7551 | 2367.0 |
| 2024-03-21 | AEMB | ETF | 38.65 | 38.912 | 38.53 | 38.912 | 1300.0 |
| 2024-03-21 | AESR | ETF | 15.59 | 15.67 | 15.59 | 15.593 | 12900.0 |
| 2024-03-21 | AETH | ETF | 48.06 | 48.06 | 46.17 | 46.4768 | 19807.0 |
| 2024-03-21 | AFIF | ETF | 9.12 | 9.12 | 9.07 | 9.11 | 48000.0 |
| 2024-03-21 | AFK | ETF | 14.35 | 14.35 | 14.05 | 14.11 | 7800.0 |
| 2024-03-21 | AFLG | ETF | 30.91 | 30.91 | 30.825 | 30.825 | 400.0 |
| 2024-03-21 | AFMC | ETF | 29.85 | 30.05 | 29.85 | 29.985 | 1600.0 |
| 2024-03-21 | AFSM | ETF | 29.0 | 29.06 | 28.992 | 29.037 | 4800.0 |
| 2024-03-21 | AFTY | ETF | 14.07 | 14.09 | 14.07 | 14.09 | 700.0 |
| 2024-03-21 | AGG | ETF | 97.62 | 97.68 | 97.41 | 97.51 | 10100300.0 |
| 2024-03-21 | AGGH | ETF | 21.46 | 21.46 | 21.38 | 21.43 | 32061.0 |
| 2024-03-21 | AGGY | ETF | 43.38 | 43.389 | 43.275 | 43.31 | 71300.0 |
| 2024-03-21 | AGNG | ETF | 29.85 | 29.99 | 29.85 | 29.85 | 4600.0 |
| 2024-03-21 | AGOX | ETF | 25.75 | 25.85 | 25.59 | 25.65 | 147100.0 |
| 2024-03-21 | AGQ | ETF | 29.86 | 29.89 | 28.3 | 28.56 | 1573900.0 |
| 2024-03-21 | AGQI | ETF | 13.91 | 13.94 | 13.9002 | 13.9002 | 17322.0 |
| 2024-03-21 | AGRH | ETF | 25.965 | 25.965 | 25.89 | 25.935 | 48054.0 |
| 2024-03-21 | AGZ | ETF | 107.85 | 107.97 | 107.82 | 107.95 | 20900.0 |
> showing 50 of 3,302 rows — these rows as CSV