PREVIEW / stock_daily / 2010-10-12
file: by_date/stock_daily/2010/2010-10-12.parquet size: 192 KB rows: 5,977 symbols: 3,505
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 |
|---|---|---|---|---|---|---|---|
| 2010-10-12 | AAPL | Stock | 10.5504 | 10.6964 | 10.4461 | 10.6621 | 558544000.0 |
| 2010-10-12 | MSFT | Stock | 24.65 | 24.93 | 24.43 | 24.83 | 50141500.0 |
| 2010-10-12 | NVDA | Stock | 0.268 | 0.2768 | 0.2658 | 0.2755 | 605208000.0 |
| 2010-10-12 | AMZN | Stock | 7.6255 | 7.8475 | 7.57 | 7.824 | 105616000.0 |
| 2010-10-12 | TSLA | Stock | 1.3467 | 1.352 | 1.3353 | 1.3493 | 3660000.0 |
| 2010-10-12 | TLT | Stock | 104.41 | 104.76 | 103.18 | 103.21 | 6122694.0 |
| 2010-10-12 | ES | Stock | 30.4 | 30.46 | 30.12 | 30.32 | 1338000.0 |
| 2010-10-12 | CL | Stock | 37.47 | 37.67 | 37.29 | 37.47 | 6356200.0 |
| 2010-10-12 | A | Stock | 24.0415 | 24.2632 | 23.8126 | 24.0916 | 4812196.0 |
| 2010-10-12 | AABA-DELISTED | Stock | 14.37 | 14.47 | 14.27 | 14.44 | 12340283.0 |
| 2010-10-12 | AACC-DELISTED | Stock | 5.68 | 5.68 | 5.47 | 5.48 | 12766.0 |
| 2010-10-12 | AACG | Stock | 3.1 | 3.14 | 3.1 | 3.14 | 500.0 |
| 2010-10-12 | AAI-DELISTED | Stock | 7.34 | 7.36 | 7.33 | 7.35 | 7213665.0 |
| 2010-10-12 | AAIC-DELISTED | Stock | 23.41 | 23.56 | 23.38 | 23.49 | 45756.0 |
| 2010-10-12 | AAME | Stock | 1.66 | 1.66 | 1.66 | 1.66 | 300.0 |
| 2010-10-12 | AAON | Stock | 4.7131 | 4.8474 | 4.7131 | 4.8454 | 106819.0 |
| 2010-10-12 | AAP | Stock | 59.21 | 60.2 | 58.89 | 59.86 | 627500.0 |
| 2010-10-12 | AATI-DELISTED | Stock | 3.43 | 3.45 | 3.33 | 3.43 | 167482.0 |
| 2010-10-12 | AAU-DELISTED | Stock | 2.965 | 3.0599 | 2.95 | 3.03 | 240184.0 |
| 2010-10-12 | AAUAF-DELISTED | Stock | 2.965 | 3.0599 | 2.95 | 3.03 | 241384.0 |
| 2010-10-12 | AAV-DELISTED | Stock | 6.2 | 6.36 | 6.17 | 6.33 | 316256.0 |
| 2010-10-12 | AAWW-DELISTED | Stock | 53.43 | 53.905 | 52.09 | 53.73 | 242086.0 |
| 2010-10-12 | AAXJ | Stock | 62.18 | 62.31 | 61.83 | 62.17 | 732387.0 |
| 2010-10-12 | AAXN-DELISTED | Stock | 4.01 | 4.07 | 3.99 | 4.06 | 358531.0 |
| 2010-10-12 | AB | Stock | 26.98 | 27.18 | 26.61 | 27.09 | 347200.0 |
| 2010-10-12 | ABAC-DELISTED | Stock | 5.49 | 5.9 | 5.26 | 5.4198 | 255101.0 |
| 2010-10-12 | ABAX-DELISTED | Stock | 23.64 | 23.92 | 23.47 | 23.7 | 34193.0 |
| 2010-10-12 | ABB-DELISTED | Stock | 21.89 | 22.0135 | 21.69 | 21.98 | 1670496.0 |
| 2010-10-12 | ABBC-DELISTED | Stock | 10.64 | 10.7 | 10.5899 | 10.69 | 19626.0 |
| 2010-10-12 | ABBNY-DELISTED | Stock | 21.89 | 22.0135 | 21.69 | 21.98 | 1690005.0 |
| 2010-10-12 | ABC-DELISTED | Stock | 31.68 | 32.12 | 31.68 | 32.09 | 2505936.0 |
| 2010-10-12 | ABCB | Stock | 9.52 | 9.65 | 9.37 | 9.61 | 25600.0 |
| 2010-10-12 | ABCD-DELISTED | Stock | 3.16 | 3.16 | 3.03 | 3.05 | 11086.0 |
| 2010-10-12 | ABCO-DELISTED | Stock | 22.69 | 22.81 | 22.25 | 22.55 | 43076.0 |
| 2010-10-12 | ABCW-DELISTED | Stock | 0.69 | 0.6948 | 0.68 | 0.68 | 19960.0 |
| 2010-10-12 | ABD-DELISTED | Stock | 5.855 | 5.915 | 5.6951 | 5.875 | 236770.0 |
| 2010-10-12 | ABE-DELISTED | Stock | 19.24 | 19.25 | 19.02 | 19.1725 | 23422.0 |
| 2010-10-12 | ABEO | Stock | 3287.5 | 3437.5 | 3262.5 | 3350.0 | 107.0 |
| 2010-10-12 | ABFS-DELISTED | Stock | 23.95 | 24.5 | 23.495 | 24.26 | 266807.0 |
| 2010-10-12 | ABG | Stock | 14.3 | 14.67 | 13.97 | 14.56 | 248600.0 |
| 2010-10-12 | ABII-DELISTED | Stock | 76.63 | 77.71 | 76.63 | 77.49 | 58810.0 |
| 2010-10-12 | ABK-DELISTED | Stock | 0.7409 | 0.78 | 0.7396 | 0.7675 | 7512285.0 |
| 2010-10-12 | ABM | Stock | 22.23 | 22.27 | 21.97 | 22.19 | 114600.0 |
| 2010-10-12 | ABMD-DELISTED | Stock | 10.57 | 10.78 | 10.38 | 10.71 | 71150.0 |
| 2010-10-12 | ABR | Stock | 5.28 | 5.44 | 5.05 | 5.41 | 121400.0 |
| 2010-10-12 | ABT | Stock | 25.3334 | 25.7269 | 25.2903 | 25.6741 | 34974364.0 |
| 2010-10-12 | ABTL-DELISTED | Stock | 4.2 | 4.25 | 4.1015 | 4.25 | 9114.0 |
| 2010-10-12 | ABV-DELISTED | Stock | 133.4 | 135.62 | 132.5 | 135.45 | 635489.0 |
| 2010-10-12 | ABVT-DELISTED | Stock | 52.42 | 52.48 | 51.95 | 52.34 | 122415.0 |
| 2010-10-12 | ABX-DELISTED | Stock | 48.43 | 48.51 | 47.75 | 48.38 | 8170529.0 |
> showing 50 of 5,977 rows — these rows as CSV