PREVIEW / etf_daily / 2021-02-01
file: by_date/etf_daily/2021/2021-02-01.parquet size: 85 KB rows: 2,249
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 |
|---|---|---|---|---|---|---|---|
| 2021-02-01 | SPY | ETF | 373.72 | 377.34 | 370.38 | 376.23 | 75817600.0 |
| 2021-02-01 | QQQ | ETF | 318.11 | 323.54 | 316.02 | 322.42 | 35646008.0 |
| 2021-02-01 | IWM | ETF | 208.17 | 211.57 | 205.76 | 210.61 | 26375100.0 |
| 2021-02-01 | DIA | ETF | 302.28 | 303.35 | 300.14 | 302.02 | 3138600.0 |
| 2021-02-01 | GLD | ETF | 175.02 | 175.26 | 174.06 | 174.23 | 9105500.0 |
| 2021-02-01 | TLT | ETF | 151.66 | 152.36 | 151.49 | 152.0 | 8165500.0 |
| 2021-02-01 | AAA | ETF | 25.1399 | 25.14 | 25.13 | 25.13 | 1300.0 |
| 2021-02-01 | AAAU | ETF | 18.58 | 18.61 | 18.49 | 18.52 | 573400.0 |
| 2021-02-01 | AADR | ETF | 60.06 | 61.95 | 60.06 | 61.88 | 4700.0 |
| 2021-02-01 | AAXJ | ETF | 95.72 | 96.32 | 95.2 | 96.28 | 743400.0 |
| 2021-02-01 | ABEQ | ETF | 25.335 | 25.39 | 25.335 | 25.361 | 700.0 |
| 2021-02-01 | ACES | ETF | 93.69 | 94.48 | 91.57 | 94.4 | 138100.0 |
| 2021-02-01 | ACIO | ETF | 27.265 | 27.44 | 27.25 | 27.32 | 75300.0 |
| 2021-02-01 | ACSI | ETF | 43.39 | 43.39 | 43.39 | 43.39 | 226.0 |
| 2021-02-01 | ACTV | ETF | 32.8464 | 33.4999 | 32.78 | 33.4516 | 2374.0 |
| 2021-02-01 | ACTX | ETF | 4.5 | 4.7 | 4.1 | 4.1 | 1517.0 |
| 2021-02-01 | ACVF | ETF | 27.81 | 27.937 | 27.65 | 27.895 | 3700.0 |
| 2021-02-01 | ACWF | ETF | 34.2101 | 34.5177 | 34.2101 | 34.4951 | 7413.0 |
| 2021-02-01 | ACWI | ETF | 91.49 | 92.12 | 91.02 | 91.98 | 5182200.0 |
| 2021-02-01 | ACWV | ETF | 96.26 | 96.34 | 95.7 | 96.28 | 433600.0 |
| 2021-02-01 | ACWX | ETF | 53.99 | 54.165 | 53.76 | 54.11 | 928720.0 |
| 2021-02-01 | ADFI | ETF | 9.85 | 9.88 | 9.85 | 9.88 | 1500.0 |
| 2021-02-01 | ADME | ETF | 36.02 | 36.02 | 35.7 | 35.86 | 68900.0 |
| 2021-02-01 | ADRE | ETF | 60.39 | 61.25 | 60.04 | 61.25 | 34606.0 |
| 2021-02-01 | AESR | ETF | 11.88 | 11.935 | 11.88 | 11.935 | 4000.0 |
| 2021-02-01 | AFIF | ETF | 9.72 | 9.7599 | 9.72 | 9.755 | 89760.0 |
| 2021-02-01 | AFK | ETF | 20.1 | 20.98 | 19.815 | 20.61 | 46815.0 |
| 2021-02-01 | AFLG | ETF | 22.63 | 22.67 | 22.63 | 22.67 | 300.0 |
| 2021-02-01 | AFSM | ETF | 23.901 | 23.901 | 23.901 | 23.901 | 100.0 |
| 2021-02-01 | AFTY | ETF | 24.14 | 24.28 | 24.14 | 24.26 | 5400.0 |
| 2021-02-01 | AGG | ETF | 117.2 | 117.26 | 117.09 | 117.23 | 6621900.0 |
| 2021-02-01 | AGGY | ETF | 53.16 | 53.28 | 53.16 | 53.23 | 257700.0 |
| 2021-02-01 | AGNG | ETF | 28.64 | 28.67 | 28.341 | 28.67 | 9700.0 |
| 2021-02-01 | AGQ | ETF | 63.88 | 64.32 | 57.01 | 59.45 | 7865700.0 |
| 2021-02-01 | AGZ | ETF | 119.29 | 119.44 | 119.29 | 119.43 | 106200.0 |
| 2021-02-01 | AGZD | ETF | 23.67 | 23.68 | 23.59 | 23.64 | 85000.0 |
| 2021-02-01 | AIA | ETF | 96.02 | 96.78 | 95.7 | 96.78 | 465310.0 |
| 2021-02-01 | AIEQ | ETF | 39.26 | 39.26 | 38.23 | 39.21 | 95500.0 |
| 2021-02-01 | AIQ | ETF | 28.02 | 28.55 | 27.92 | 28.55 | 87672.0 |
| 2021-02-01 | AIRR | ETF | 34.86 | 35.526 | 34.535 | 35.413 | 27000.0 |
| 2021-02-01 | AIVI | ETF | 41.07 | 41.09 | 40.91 | 41.09 | 5600.0 |
| 2021-02-01 | ALTL | ETF | 31.73 | 32.34 | 31.73 | 32.232 | 30486.0 |
| 2021-02-01 | ALTY | ETF | 11.93 | 11.98 | 11.857 | 11.97 | 24700.0 |
| 2021-02-01 | AMJ | ETF | 14.9 | 14.9 | 14.5 | 14.68 | 696067.0 |
| 2021-02-01 | AMLP | ETF | 27.38 | 27.47 | 26.74 | 27.1 | 3085600.0 |
| 2021-02-01 | AMNA | ETF | 26.2933 | 26.2933 | 26.2933 | 26.2933 | 0.0 |
| 2021-02-01 | AMND | ETF | 27.9552 | 27.9552 | 27.9552 | 27.9552 | 0.0 |
| 2021-02-01 | AMOM | ETF | 31.95 | 32.459 | 31.95 | 32.459 | 3600.0 |
| 2021-02-01 | AMPS | ETF | 10.25 | 10.49 | 10.1 | 10.49 | 2131.0 |
| 2021-02-01 | AMTR | ETF | 30.1889 | 30.1889 | 30.1889 | 30.1889 | 1.0 |
> showing 50 of 2,249 rows — these rows as CSV