PREVIEW / stock_daily / 2022-02-03
file: by_date/stock_daily/2022/2022-02-03.parquet size: 258 KB rows: 7,988 symbols: 2,507
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 |
|---|---|---|---|---|---|---|---|
| 2022-02-03 | AAPL | Stock | 174.48 | 176.24 | 172.12 | 172.9 | 89418100.0 |
| 2022-02-03 | MSFT | Stock | 309.49 | 311.23 | 299.96 | 301.25 | 43730000.0 |
| 2022-02-03 | NVDA | Stock | 24.458 | 25.077 | 23.78 | 23.948 | 410178000.0 |
| 2022-02-03 | AMZN | Stock | 141.7375 | 144.2475 | 138.333 | 138.8455 | 225532000.0 |
| 2022-02-03 | GOOGL | Stock | 145.7055 | 149.675 | 142.6653 | 143.09 | 71517220.0 |
| 2022-02-03 | META | Stock | 244.65 | 248.0 | 235.75 | 237.76 | 188119900.0 |
| 2022-02-03 | TSLA | Stock | 294.0 | 312.3333 | 293.5067 | 297.0467 | 78855600.0 |
| 2022-02-03 | TLT | Stock | 140.44 | 141.48 | 140.18 | 141.09 | 17234053.0 |
| 2022-02-03 | ES | Stock | 88.66 | 89.27 | 87.78 | 88.07 | 1970500.0 |
| 2022-02-03 | CL | Stock | 82.78 | 83.27 | 82.38 | 82.73 | 4292100.0 |
| 2022-02-03 | A | Stock | 142.0 | 143.78 | 141.01 | 141.79 | 914300.0 |
| 2022-02-03 | AA | Stock | 58.9 | 63.36 | 58.33 | 62.74 | 8076600.0 |
| 2022-02-03 | AAC-DELISTED | Stock | 9.76 | 9.77 | 9.74 | 9.77 | 35700.0 |
| 2022-02-03 | AACG | Stock | 1.6 | 1.64 | 1.54 | 1.54 | 32400.0 |
| 2022-02-03 | AACIW-DELISTED | Stock | 0.35 | 0.35 | 0.35 | 0.35 | 1245.0 |
| 2022-02-03 | AAIC-DELISTED | Stock | 3.4 | 3.43 | 3.4 | 3.42 | 84470.0 |
| 2022-02-03 | AAIC.C-DELISTED | Stock | 24.91 | 24.91 | 24.82 | 24.82 | 300.0 |
| 2022-02-03 | AAL | Stock | 16.65 | 17.18 | 16.55 | 16.57 | 30642800.0 |
| 2022-02-03 | AAM.A-DELISTED | Stock | 25.21 | 25.25 | 25.18 | 25.24 | 68751.0 |
| 2022-02-03 | AAM.B-DELISTED | Stock | 25.89 | 25.93 | 25.78 | 25.86 | 53810.0 |
| 2022-02-03 | AAME | Stock | 2.55 | 2.65 | 2.47 | 2.51 | 5800.0 |
| 2022-02-03 | AAMI | Stock | 21.72 | 23.47 | 21.72 | 22.68 | 1625000.0 |
| 2022-02-03 | AAN-DELISTED | Stock | 20.91 | 21.61 | 20.91 | 21.31 | 350500.0 |
| 2022-02-03 | AAOI | Stock | 3.91 | 3.953 | 3.83 | 3.85 | 207900.0 |
| 2022-02-03 | AAON | Stock | 41.5267 | 42.6733 | 40.64 | 40.7533 | 205950.0 |
| 2022-02-03 | AAP | Stock | 235.99 | 235.99 | 232.17 | 232.49 | 521500.0 |
| 2022-02-03 | AAQC-DELISTED | Stock | 9.7 | 9.73 | 9.7 | 9.72 | 2752.0 |
| 2022-02-03 | AAT | Stock | 35.62 | 35.9 | 35.05 | 35.15 | 154700.0 |
| 2022-02-03 | AATC | Stock | 6.88 | 6.88 | 6.7001 | 6.83 | 15502.0 |
| 2022-02-03 | AAU-DELISTED | Stock | 0.3 | 0.3072 | 0.295 | 0.3025 | 220406.0 |
| 2022-02-03 | AAUAF-DELISTED | Stock | 0.3 | 0.3072 | 0.295 | 0.3003 | 223560.0 |
| 2022-02-03 | AAWW-DELISTED | Stock | 80.49 | 82.31 | 79.49 | 79.88 | 563158.0 |
| 2022-02-03 | AAXJ | Stock | 81.1 | 81.51 | 80.8 | 81.07 | 699670.0 |
| 2022-02-03 | AB | Stock | 46.65 | 47.19 | 45.79 | 45.79 | 386100.0 |
| 2022-02-03 | ABB-DELISTED | Stock | 34.33 | 34.775 | 34.23 | 34.28 | 1656273.0 |
| 2022-02-03 | ABBNY-DELISTED | Stock | 34.33 | 34.775 | 34.23 | 34.29 | 1886398.0 |
| 2022-02-03 | ABBV | Stock | 139.5 | 141.71 | 139.04 | 140.73 | 10272700.0 |
| 2022-02-03 | ABC-DELISTED | Stock | 137.09 | 139.315 | 135.25 | 137.87 | 833740.0 |
| 2022-02-03 | ABCB | Stock | 49.18 | 49.9 | 48.43 | 48.52 | 363300.0 |
| 2022-02-03 | ABCL | Stock | 9.1 | 9.55 | 8.95 | 9.34 | 2552400.0 |
| 2022-02-03 | ABCM-DELISTED | Stock | 17.8 | 17.82 | 17.37 | 17.63 | 113945.0 |
| 2022-02-03 | ABEO | Stock | 6.25 | 6.5 | 6.0 | 6.25 | 75864.0 |
| 2022-02-03 | ABEV | Stock | 2.75 | 2.76 | 2.71 | 2.71 | 17951700.0 |
| 2022-02-03 | ABG | Stock | 169.59 | 171.5 | 163.6 | 164.03 | 236900.0 |
| 2022-02-03 | ABGI-DELISTED | Stock | 9.71 | 9.71 | 9.7 | 9.7 | 18563.0 |
| 2022-02-03 | ABM | Stock | 41.71 | 42.02 | 41.18 | 41.33 | 263400.0 |
| 2022-02-03 | ABMD-DELISTED | Stock | 296.0 | 305.09 | 285.85 | 290.51 | 474910.0 |
| 2022-02-03 | ABNB | Stock | 147.97 | 152.18 | 146.68 | 149.57 | 4577100.0 |
| 2022-02-03 | ABOS | Stock | 4.86 | 4.98 | 4.62 | 4.79 | 142300.0 |
| 2022-02-03 | ABR | Stock | 17.22 | 17.35 | 17.06 | 17.06 | 2037100.0 |
> showing 50 of 7,988 rows — these rows as CSV