PREVIEW / stock_daily / 2022-12-08
file: by_date/stock_daily/2022/2022-12-08.parquet size: 251 KB rows: 7,805 symbols: 2,054
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-12-08 | AAPL | Stock | 142.36 | 143.52 | 141.1 | 142.65 | 62128300.0 |
| 2022-12-08 | MSFT | Stock | 244.84 | 248.74 | 243.06 | 247.4 | 22611800.0 |
| 2022-12-08 | NVDA | Stock | 16.273 | 17.179 | 15.959 | 17.169 | 515456000.0 |
| 2022-12-08 | AMZN | Stock | 89.24 | 90.86 | 87.88 | 90.35 | 73305900.0 |
| 2022-12-08 | GOOGL | Stock | 95.38 | 95.58 | 93.45 | 93.71 | 32213288.0 |
| 2022-12-08 | META | Stock | 116.39 | 117.34 | 114.59 | 115.33 | 30619400.0 |
| 2022-12-08 | TSLA | Stock | 172.2 | 175.2 | 169.06 | 173.44 | 97624500.0 |
| 2022-12-08 | TLT | Stock | 108.7 | 109.45 | 108.47 | 109.17 | 13377290.0 |
| 2022-12-08 | ES | Stock | 83.76 | 84.67 | 83.59 | 84.59 | 1342700.0 |
| 2022-12-08 | CL | Stock | 77.38 | 78.17 | 77.06 | 78.14 | 2672300.0 |
| 2022-12-08 | A | Stock | 154.42 | 156.99 | 153.48 | 156.28 | 1289900.0 |
| 2022-12-08 | AA | Stock | 48.39 | 48.46 | 47.05 | 47.28 | 2601900.0 |
| 2022-12-08 | AAC-DELISTED | Stock | 10.05 | 10.07 | 10.05 | 10.06 | 392917.0 |
| 2022-12-08 | AACG | Stock | 1.52 | 1.71 | 1.4 | 1.52 | 22200.0 |
| 2022-12-08 | AACIW-DELISTED | Stock | 0.0275 | 0.03 | 0.0275 | 0.03 | 10350.0 |
| 2022-12-08 | AAIC-DELISTED | Stock | 3.01 | 3.01 | 2.97 | 2.99 | 72376.0 |
| 2022-12-08 | AAL | Stock | 13.65 | 13.8 | 13.38 | 13.6 | 25300900.0 |
| 2022-12-08 | AAM.A-DELISTED | Stock | 23.84 | 24.05 | 23.655 | 23.655 | 18128.0 |
| 2022-12-08 | AAM.B-DELISTED | Stock | 24.96 | 25.1 | 24.6377 | 24.66 | 8942.0 |
| 2022-12-08 | AAMC-DELISTED | Stock | 6.8235 | 7.0294 | 6.5206 | 6.6176 | 29029.0 |
| 2022-12-08 | AAME | Stock | 2.62 | 2.69 | 2.52 | 2.59 | 13800.0 |
| 2022-12-08 | AAMI | Stock | 19.62 | 19.87 | 19.362 | 19.6 | 73300.0 |
| 2022-12-08 | AAN-DELISTED | Stock | 12.04 | 12.085 | 11.78 | 11.85 | 270100.0 |
| 2022-12-08 | AAOI | Stock | 2.13 | 2.18 | 2.1 | 2.18 | 77900.0 |
| 2022-12-08 | AAON | Stock | 52.3067 | 53.3333 | 52.0067 | 53.28 | 252300.0 |
| 2022-12-08 | AAP | Stock | 146.37 | 148.53 | 146.07 | 146.59 | 773000.0 |
| 2022-12-08 | AAQC-DELISTED | Stock | 10.08 | 10.09 | 10.08 | 10.085 | 11889.0 |
| 2022-12-08 | AAT | Stock | 27.06 | 27.48 | 27.06 | 27.14 | 177600.0 |
| 2022-12-08 | AATC | Stock | 5.06 | 5.2 | 4.9201 | 5.2 | 16356.0 |
| 2022-12-08 | AAU-DELISTED | Stock | 0.244 | 0.248 | 0.235 | 0.2438 | 73605.0 |
| 2022-12-08 | AAUAF-DELISTED | Stock | 0.244 | 0.248 | 0.235 | 0.24 | 76438.0 |
| 2022-12-08 | AAWW-DELISTED | Stock | 100.8 | 100.82 | 100.4 | 100.66 | 75016.0 |
| 2022-12-08 | AAXJ | Stock | 66.53 | 66.955 | 66.41 | 66.86 | 723615.0 |
| 2022-12-08 | AB | Stock | 39.38 | 39.74 | 38.87 | 39.2 | 200100.0 |
| 2022-12-08 | ABB-DELISTED | Stock | 30.57 | 30.83 | 30.54 | 30.805 | 866599.0 |
| 2022-12-08 | ABBNY-DELISTED | Stock | 30.57 | 30.83 | 30.54 | 30.82 | 994079.0 |
| 2022-12-08 | ABBV | Stock | 165.4 | 166.23 | 164.28 | 165.99 | 4274400.0 |
| 2022-12-08 | ABC-DELISTED | Stock | 171.02 | 171.69 | 169.63 | 170.51 | 565854.0 |
| 2022-12-08 | ABCB | Stock | 50.54 | 51.04 | 50.0 | 50.32 | 362000.0 |
| 2022-12-08 | ABCL | Stock | 11.23 | 11.264 | 10.91 | 11.14 | 2658200.0 |
| 2022-12-08 | ABCM-DELISTED | Stock | 15.4 | 15.71 | 15.3 | 15.52 | 226759.0 |
| 2022-12-08 | ABEO | Stock | 3.24 | 3.41 | 3.1 | 3.13 | 146800.0 |
| 2022-12-08 | ABEV | Stock | 3.01 | 3.02 | 2.96 | 2.97 | 13592500.0 |
| 2022-12-08 | ABG | Stock | 179.6 | 181.76 | 178.75 | 181.54 | 106600.0 |
| 2022-12-08 | ABGI-DELISTED | Stock | 10.05 | 10.05 | 10.05 | 10.05 | 1588.0 |
| 2022-12-08 | ABM | Stock | 45.51 | 45.68 | 44.78 | 45.19 | 306000.0 |
| 2022-12-08 | ABMD-DELISTED | Stock | 381.85 | 381.85 | 380.25 | 380.8 | 1073734.0 |
| 2022-12-08 | ABNB | Stock | 92.97 | 95.61 | 91.75 | 94.83 | 6115700.0 |
| 2022-12-08 | ABOS | Stock | 5.35 | 5.75 | 5.18 | 5.72 | 90900.0 |
| 2022-12-08 | ABR | Stock | 14.02 | 14.28 | 13.89 | 13.93 | 2990700.0 |
> showing 50 of 7,805 rows — these rows as CSV