PREVIEW / stock_daily / 2023-11-10
file: by_date/stock_daily/2023/2023-11-10.parquet size: 232 KB rows: 7,294 symbols: 1,285
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-11-10 | AAPL | Stock | 183.97 | 186.57 | 183.53 | 186.4 | 66133400.0 |
| 2023-11-10 | MSFT | Stock | 361.49 | 370.1 | 361.07 | 369.67 | 28042100.0 |
| 2023-11-10 | NVDA | Stock | 47.5 | 48.472 | 47.283 | 48.335 | 421245000.0 |
| 2023-11-10 | AMZN | Stock | 140.46 | 143.65 | 139.91 | 143.56 | 49287800.0 |
| 2023-11-10 | GOOGL | Stock | 130.105 | 132.8 | 129.41 | 132.59 | 26927826.0 |
| 2023-11-10 | META | Stock | 319.94 | 329.1 | 319.46 | 328.77 | 19096200.0 |
| 2023-11-10 | TSLA | Stock | 210.03 | 215.38 | 205.69 | 214.65 | 130994000.0 |
| 2023-11-10 | TLT | Stock | 88.225 | 88.425 | 87.7749 | 87.99 | 36594021.0 |
| 2023-11-10 | ES | Stock | 54.57 | 54.75 | 53.63 | 53.8 | 2398300.0 |
| 2023-11-10 | CL | Stock | 75.31 | 75.6 | 74.67 | 75.43 | 3667800.0 |
| 2023-11-10 | A | Stock | 107.72 | 108.48 | 104.09 | 108.47 | 1847800.0 |
| 2023-11-10 | AA | Stock | 24.7 | 24.89 | 24.28 | 24.64 | 3039400.0 |
| 2023-11-10 | AACG | Stock | 0.95 | 0.95 | 0.85 | 0.85 | 5400.0 |
| 2023-11-10 | AACIW-DELISTED | Stock | 0.045 | 0.0579 | 0.0151 | 0.0579 | 10308.0 |
| 2023-11-10 | AAIC-DELISTED | Stock | 4.46 | 4.545 | 4.43 | 4.53 | 68509.0 |
| 2023-11-10 | AAL | Stock | 11.67 | 11.85 | 11.51 | 11.8 | 31056200.0 |
| 2023-11-10 | AAMC-DELISTED | Stock | 3.295 | 3.51 | 2.73 | 3.51 | 30600.0 |
| 2023-11-10 | AAME | Stock | 1.6 | 1.71 | 1.55 | 1.6 | 16000.0 |
| 2023-11-10 | AAMI | Stock | 15.99 | 16.25 | 15.79 | 16.21 | 413800.0 |
| 2023-11-10 | AAN-DELISTED | Stock | 6.88 | 7.05 | 6.72 | 7.03 | 506400.0 |
| 2023-11-10 | AAOI | Stock | 9.29 | 9.88 | 8.36 | 9.365 | 3479600.0 |
| 2023-11-10 | AAON | Stock | 57.79 | 58.98 | 57.35 | 58.71 | 404300.0 |
| 2023-11-10 | AAP | Stock | 56.42 | 56.94 | 55.21 | 56.13 | 1577800.0 |
| 2023-11-10 | AAT | Stock | 18.64 | 18.66 | 18.3 | 18.4 | 301800.0 |
| 2023-11-10 | AATC | Stock | 6.0 | 6.395 | 6.0 | 6.39 | 41987.0 |
| 2023-11-10 | AAU-DELISTED | Stock | 0.139 | 0.1391 | 0.135 | 0.1361 | 71191.0 |
| 2023-11-10 | AAUAF-DELISTED | Stock | 0.139 | 0.1391 | 0.135 | 0.1361 | 72246.0 |
| 2023-11-10 | AAXJ | Stock | 63.51 | 63.9 | 63.37 | 63.86 | 354462.0 |
| 2023-11-10 | AB | Stock | 27.1 | 27.18 | 26.55 | 26.62 | 504700.0 |
| 2023-11-10 | ABAT | Stock | 4.4 | 4.4 | 4.11 | 4.15 | 271852.0 |
| 2023-11-10 | ABBNY-DELISTED | Stock | 35.77 | 35.86 | 35.54 | 35.86 | 317355.0 |
| 2023-11-10 | ABBV | Stock | 138.65 | 139.36 | 136.4 | 138.59 | 4586400.0 |
| 2023-11-10 | ABCB | Stock | 39.44 | 39.74 | 38.71 | 39.45 | 244900.0 |
| 2023-11-10 | ABCL | Stock | 4.07 | 4.08 | 3.89 | 4.04 | 1136200.0 |
| 2023-11-10 | ABCM-DELISTED | Stock | 23.1 | 23.13 | 23.0525 | 23.13 | 3284304.0 |
| 2023-11-10 | ABEO | Stock | 3.89 | 4.13 | 3.78 | 4.09 | 156700.0 |
| 2023-11-10 | ABEV | Stock | 2.72 | 2.73 | 2.7 | 2.72 | 5993000.0 |
| 2023-11-10 | ABG | Stock | 199.73 | 202.95 | 198.37 | 201.62 | 95700.0 |
| 2023-11-10 | ABLLW | Stock | 0.33 | 0.33 | 0.3225 | 0.33 | 13011.0 |
| 2023-11-10 | ABLV | Stock | 1.72 | 1.73 | 1.6 | 1.68 | 14500.0 |
| 2023-11-10 | ABM | Stock | 39.83 | 40.11 | 39.41 | 39.99 | 444000.0 |
| 2023-11-10 | ABNB | Stock | 114.525 | 118.54 | 114.17 | 118.15 | 4773500.0 |
| 2023-11-10 | ABOS | Stock | 1.87 | 1.93 | 1.81 | 1.9 | 526700.0 |
| 2023-11-10 | ABR | Stock | 12.98 | 13.13 | 12.79 | 13.06 | 2903200.0 |
| 2023-11-10 | ABR.D | Stock | 16.675 | 16.78 | 16.59 | 16.62 | 17394.0 |
| 2023-11-10 | ABR.E | Stock | 16.29 | 16.5 | 16.26 | 16.42 | 14108.0 |
| 2023-11-10 | ABR.F | Stock | 17.91 | 17.91 | 17.66 | 17.66 | 6861.0 |
| 2023-11-10 | ABSI | Stock | 1.29 | 1.29 | 1.18 | 1.27 | 192300.0 |
| 2023-11-10 | ABT | Stock | 93.7 | 94.22 | 92.43 | 93.97 | 5479100.0 |
| 2023-11-10 | ABTC | Stock | 390.0 | 397.5 | 331.5 | 375.0 | 128.06666666666666 |
> showing 50 of 7,294 rows — these rows as CSV