PREVIEW / stock_daily / 2005-10-20
file: by_date/stock_daily/2005/2005-10-20.parquet size: 140 KB rows: 4,189 symbols: 2,630
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 |
|---|---|---|---|---|---|---|---|
| 2005-10-20 | AAPL | Stock | 1.9454 | 2.0179 | 1.9411 | 2.005 | 1357762000.0 |
| 2005-10-20 | MSFT | Stock | 25.05 | 25.13 | 24.74 | 24.79 | 58830600.0 |
| 2005-10-20 | NVDA | Stock | 0.2632 | 0.2702 | 0.2621 | 0.2647 | 359520000.0 |
| 2005-10-20 | AMZN | Stock | 2.295 | 2.3035 | 2.234 | 2.2505 | 118584000.0 |
| 2005-10-20 | CL | Stock | 26.31 | 26.445 | 26.005 | 26.045 | 2731600.0 |
| 2005-10-20 | A | Stock | 22.3176 | 22.6037 | 21.9528 | 22.0458 | 3658426.0 |
| 2005-10-20 | AABA-DELISTED | Stock | 35.9000015258789 | 36.939998626709 | 35.0499992370605 | 35.2599983215332 | 29267000.0 |
| 2005-10-20 | AACC-DELISTED | Stock | 25.6 | 25.75 | 24.32 | 24.71 | 308880.0 |
| 2005-10-20 | AACQ-DELISTED | Stock | 5.15 | 5.23 | 5.15 | 5.2 | 7000.0 |
| 2005-10-20 | AAI-DELISTED | Stock | 14.09 | 14.09 | 13.35 | 13.47 | 2010200.0 |
| 2005-10-20 | AAIC-DELISTED | Stock | 186.6 | 190.402 | 185.2 | 186.4 | 1779300.0 |
| 2005-10-20 | AAME | Stock | 2.62 | 2.75 | 2.55 | 2.72 | 2400.0 |
| 2005-10-20 | AAON | Stock | 2.2281 | 2.2545 | 2.1873 | 2.2071 | 88847.0 |
| 2005-10-20 | AAP | Stock | 37.57 | 38.47 | 37.29 | 37.49 | 902700.0 |
| 2005-10-20 | AATI-DELISTED | Stock | 11.3 | 11.5 | 11.3 | 11.42 | 42917.0 |
| 2005-10-20 | AAV-DELISTED | Stock | 16.3 | 17.08 | 12.21 | 16.3 | 45100.0 |
| 2005-10-20 | AAXN-DELISTED | Stock | 5.84999990463257 | 5.90000009536743 | 5.57999992370605 | 5.6100001335144 | 1687800.0 |
| 2005-10-20 | ABAX-DELISTED | Stock | 14.25 | 14.25 | 13.96 | 14.12 | 102046.0 |
| 2005-10-20 | ABB-DELISTED | Stock | 7.02 | 7.04 | 6.94 | 6.95 | 732100.0 |
| 2005-10-20 | ABBC-DELISTED | Stock | 12.0 | 12.06 | 11.95 | 12.06 | 1350.0 |
| 2005-10-20 | ABC-DELISTED | Stock | 18.96 | 19.2 | 18.74 | 18.84 | 3820800.0 |
| 2005-10-20 | ABCB | Stock | 17.5172 | 17.6437 | 17.1477 | 17.4103 | 9150.0 |
| 2005-10-20 | ABCO-DELISTED | Stock | 24.31 | 24.44 | 23.66 | 24.12 | 134686.0 |
| 2005-10-20 | ABCW-DELISTED | Stock | 30.56 | 30.71 | 30.14 | 30.36 | 82890.0 |
| 2005-10-20 | ABD-DELISTED | Stock | 24.19 | 24.29 | 24.04 | 24.21 | 464960.0 |
| 2005-10-20 | ABE-DELISTED | Stock | 10.64 | 10.73 | 10.52 | 10.52 | 25200.0 |
| 2005-10-20 | ABFS-DELISTED | Stock | 33.85 | 34.13 | 32.7 | 33.16 | 433220.0 |
| 2005-10-20 | ABG | Stock | 16.71 | 16.87 | 16.37 | 16.55 | 67800.0 |
| 2005-10-20 | ABK-DELISTED | Stock | 69.3 | 70.9 | 68.81 | 69.1 | 593300.0 |
| 2005-10-20 | ABM | Stock | 20.1 | 20.12 | 19.36 | 19.71 | 152300.0 |
| 2005-10-20 | ABMD-DELISTED | Stock | 8.65 | 8.66 | 8.34 | 8.49 | 79828.0 |
| 2005-10-20 | ABP-DELISTED | Stock | 7.08 | 7.08 | 6.37 | 6.49 | 1226200.0 |
| 2005-10-20 | ABR | Stock | 27.73 | 27.85 | 26.78 | 26.97 | 100600.0 |
| 2005-10-20 | ABT | Stock | 20.9912 | 21.0632 | 20.6842 | 20.7561 | 14535223.0 |
| 2005-10-20 | ABTL-DELISTED | Stock | 23.02 | 23.52 | 21.58 | 22.73 | 23084.0 |
| 2005-10-20 | ABV-DELISTED | Stock | 34.25 | 35.03 | 33.19 | 33.27 | 632200.0 |
| 2005-10-20 | ABVA-DELISTED | Stock | 16.6 | 16.6 | 16.6 | 16.6 | 200.0 |
| 2005-10-20 | ABX-DELISTED | Stock | 26.21 | 26.49 | 25.27 | 25.43 | 2759900.0 |
| 2005-10-20 | ACAD | Stock | 11.41 | 11.43 | 11.13 | 11.19 | 19000.0 |
| 2005-10-20 | ACAP-DELISTED | Stock | 44.86 | 45.95 | 44.7 | 45.07 | 94846.0 |
| 2005-10-20 | ACAS-DELISTED | Stock | 36.95 | 37.04 | 36.33 | 36.44 | 527393.0 |
| 2005-10-20 | ACAT-DELISTED | Stock | 18.71 | 20.14 | 18.57 | 19.0 | 233997.0 |
| 2005-10-20 | ACC-DELISTED | Stock | 23.95 | 24.01 | 22.9 | 23.14 | 57200.0 |
| 2005-10-20 | ACCL-DELISTED | Stock | 6.45 | 6.6801 | 6.3 | 6.55 | 61548.0 |
| 2005-10-20 | ACCO | Stock | 24.2 | 24.31 | 24.05 | 24.2 | 466100.0 |
| 2005-10-20 | ACE-DELISTED | Stock | 50.18 | 50.23 | 48.57 | 48.75 | 1682400.0 |
| 2005-10-20 | ACF-DELISTED | Stock | 22.89 | 23.03 | 22.5 | 22.56 | 1125600.0 |
| 2005-10-20 | ACFC-DELISTED | Stock | 70.31 | 70.31 | 69.75 | 70.15 | 118.0 |
| 2005-10-20 | ACG-DELISTED | Stock | 8.16 | 8.19 | 8.14 | 8.15 | 293300.0 |
| 2005-10-20 | ACGL | Stock | 5.2256 | 5.2744 | 5.1456 | 5.2111 | 973800.0 |
> showing 50 of 4,189 rows — these rows as CSV