PREVIEW / etf_daily / 2023-02-14
file: by_date/etf_daily/2023/2023-02-14.parquet size: 108 KB rows: 2,931
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 |
|---|---|---|---|---|---|---|---|
| 2023-02-14 | SPY | ETF | 411.24 | 415.05 | 408.51 | 412.64 | 88389300.0 |
| 2023-02-14 | QQQ | ETF | 302.89 | 307.72 | 300.91 | 306.75 | 64079057.0 |
| 2023-02-14 | IWM | ETF | 191.28 | 193.95 | 190.08 | 192.51 | 21889600.0 |
| 2023-02-14 | DIA | ETF | 341.52 | 343.53 | 338.41 | 341.14 | 3501100.0 |
| 2023-02-14 | GLD | ETF | 171.97 | 173.51 | 171.41 | 172.61 | 5403100.0 |
| 2023-02-14 | TLT | ETF | 104.2 | 104.83 | 103.14 | 104.02 | 15440300.0 |
| 2023-02-14 | AAA | ETF | 24.65 | 24.65 | 24.65 | 24.65 | 105.0 |
| 2023-02-14 | AAAU | ETF | 18.34 | 18.5 | 18.29 | 18.4 | 2583700.0 |
| 2023-02-14 | AADR | ETF | 49.56 | 49.67 | 49.56 | 49.67 | 1100.0 |
| 2023-02-14 | AAPB | ETF | 19.89 | 20.3 | 19.89 | 20.27 | 2697.0 |
| 2023-02-14 | AAPD | ETF | 25.73 | 25.9186 | 25.4966 | 25.61 | 129033.0 |
| 2023-02-14 | AAPU | ETF | 20.94 | 21.2698 | 20.71 | 21.12 | 81153.0 |
| 2023-02-14 | AAXJ | ETF | 69.35 | 69.74 | 68.98 | 69.53 | 456000.0 |
| 2023-02-14 | ABEQ | ETF | 28.55 | 28.62 | 28.44 | 28.556 | 10300.0 |
| 2023-02-14 | ACES | ETF | 49.92 | 51.07 | 49.43 | 50.94 | 28300.0 |
| 2023-02-14 | ACIO | ETF | 30.25 | 30.25 | 29.895 | 30.11 | 32000.0 |
| 2023-02-14 | ACSI | ETF | 46.18 | 46.2777 | 46.18 | 46.2777 | 1139.0 |
| 2023-02-14 | ACT | ETF | 24.6 | 24.65 | 24.32 | 24.46 | 159258.0 |
| 2023-02-14 | ACTV | ETF | 32.44 | 32.93 | 32.44 | 32.8396 | 6137.0 |
| 2023-02-14 | ACTX | ETF | 0.38 | 0.38 | 0.38 | 0.38 | 359.0 |
| 2023-02-14 | ACVF | ETF | 31.82 | 31.97 | 31.69 | 31.919 | 4600.0 |
| 2023-02-14 | ACWF | ETF | 33.85 | 34.1212 | 33.715 | 33.9836 | 19003.0 |
| 2023-02-14 | ACWI | ETF | 91.41 | 92.29 | 90.97 | 91.81 | 3575700.0 |
| 2023-02-14 | ACWV | ETF | 96.21 | 96.55 | 95.56 | 95.87 | 185600.0 |
| 2023-02-14 | ACWX | ETF | 48.93 | 49.46 | 48.82 | 49.23 | 2716794.0 |
| 2023-02-14 | ADFI | ETF | 8.47 | 8.485 | 8.47 | 8.485 | 500.0 |
| 2023-02-14 | ADIV | ETF | 14.225 | 14.225 | 14.225 | 14.225 | 100.0 |
| 2023-02-14 | ADME | ETF | 34.685 | 34.87 | 34.494 | 34.63 | 17800.0 |
| 2023-02-14 | ADPV | ETF | 25.6399 | 25.6399 | 25.38 | 25.495 | 32296.0 |
| 2023-02-14 | ADRE | ETF | 41.72 | 42.28 | 41.6084 | 42.12 | 14299.0 |
| 2023-02-14 | AEMB | ETF | 38.23 | 38.3 | 38.135 | 38.135 | 49000.0 |
| 2023-02-14 | AESR | ETF | 11.9 | 11.99 | 11.88 | 11.978 | 10200.0 |
| 2023-02-14 | AFIF | ETF | 8.87 | 8.877 | 8.86 | 8.877 | 9479.0 |
| 2023-02-14 | AFK | ETF | 16.8 | 16.94 | 16.75 | 16.92 | 6606.0 |
| 2023-02-14 | AFLG | ETF | 24.662 | 24.662 | 24.662 | 24.662 | 100.0 |
| 2023-02-14 | AFMC | ETF | 24.31 | 24.331 | 24.31 | 24.331 | 100.0 |
| 2023-02-14 | AFSM | ETF | 24.65 | 24.76 | 24.65 | 24.705 | 6000.0 |
| 2023-02-14 | AFTY | ETF | 17.02 | 17.02 | 17.0 | 17.016 | 400.0 |
| 2023-02-14 | AGG | ETF | 98.67 | 98.76 | 98.11 | 98.37 | 9559500.0 |
| 2023-02-14 | AGGY | ETF | 43.49 | 43.53 | 43.29 | 43.4 | 156500.0 |
| 2023-02-14 | AGIH | ETF | 24.46 | 24.475 | 24.442 | 24.475 | 200.0 |
| 2023-02-14 | AGNG | ETF | 27.0 | 27.052 | 27.0 | 27.052 | 600.0 |
| 2023-02-14 | AGOV | ETF | 78.73 | 78.73 | 74.54 | 74.54 | 471.0 |
| 2023-02-14 | AGOX | ETF | 22.195 | 22.42 | 22.16 | 22.362 | 6300.0 |
| 2023-02-14 | AGQ | ETF | 25.7 | 26.45 | 25.5 | 26.18 | 643300.0 |
| 2023-02-14 | AGRH | ETF | 25.6499 | 25.65 | 25.6499 | 25.65 | 1800.0 |
| 2023-02-14 | AGZ | ETF | 107.02 | 107.2 | 107.005 | 107.0784 | 23041.0 |
| 2023-02-14 | AGZD | ETF | 21.98 | 21.995 | 21.935 | 21.99 | 110400.0 |
| 2023-02-14 | AHHX | ETF | 8.57 | 8.66 | 8.57 | 8.66 | 4762.0 |
| 2023-02-14 | AHYB | ETF | 43.51 | 43.742 | 43.51 | 43.715 | 31500.0 |
> showing 50 of 2,931 rows — these rows as CSV