PREVIEW / stock_daily / 2001-12-27
file: by_date/stock_daily/2001/2001-12-27.parquet size: 106 KB rows: 3,069 symbols: 1,913
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 |
|---|---|---|---|---|---|---|---|
| 2001-12-27 | AAPL | Stock | 0.3854 | 0.3973 | 0.3854 | 0.3941 | 191508800.0 |
| 2001-12-27 | MSFT | Stock | 33.99 | 34.355 | 33.63 | 33.925 | 32406600.0 |
| 2001-12-27 | NVDA | Stock | 0.57 | 0.5807 | 0.5692 | 0.5782 | 730152000.0 |
| 2001-12-27 | AMZN | Stock | 0.5665 | 0.5745 | 0.5285 | 0.53 | 216802000.0 |
| 2001-12-27 | CL | Stock | 28.95 | 29.1 | 28.875 | 29.08 | 1187800.0 |
| 2001-12-27 | A | Stock | 20.0358 | 20.7225 | 20.0358 | 20.6295 | 1909948.0 |
| 2001-12-27 | AABA-DELISTED | Stock | 8.97500038146973 | 9.04500007629395 | 8.77000045776367 | 8.88500022888184 | 15643400.0 |
| 2001-12-27 | AAI-DELISTED | Stock | 6.0 | 6.18 | 5.99 | 6.14 | 119300.0 |
| 2001-12-27 | AAIC-DELISTED | Stock | 108.0 | 108.0 | 105.0 | 108.0 | 62100.0 |
| 2001-12-27 | AAME | Stock | 2.18 | 2.69 | 2.16 | 2.21 | 10200.0 |
| 2001-12-27 | AAON | Stock | 1.9139 | 1.9929 | 1.9139 | 1.9384 | 239203.0 |
| 2001-12-27 | AAP | Stock | 15.75 | 15.8833 | 15.4 | 15.65 | 349200.0 |
| 2001-12-27 | AAXN-DELISTED | Stock | 1.01916670799255 | 1.03416669368744 | 1.01333332061768 | 1.03083336353302 | 158400.0 |
| 2001-12-27 | ABAX-DELISTED | Stock | 5.27 | 5.3 | 5.05 | 5.29 | 14700.0 |
| 2001-12-27 | ABB-DELISTED | Stock | 9.7 | 9.71 | 9.57 | 9.69 | 22700.0 |
| 2001-12-27 | ABC-DELISTED | Stock | 15.89 | 15.92 | 15.6 | 15.7 | 2224800.0 |
| 2001-12-27 | ABCB | Stock | 10.9422 | 10.9422 | 10.8207 | 10.8774 | 8760.0 |
| 2001-12-27 | ABCO-DELISTED | Stock | 13.16 | 13.44 | 13.095 | 13.44 | 136400.0 |
| 2001-12-27 | ABCW-DELISTED | Stock | 17.95 | 18.0 | 17.65 | 18.0 | 20800.0 |
| 2001-12-27 | ABE-DELISTED | Stock | 6.95 | 6.98 | 6.92 | 6.92 | 26000.0 |
| 2001-12-27 | ABFS-DELISTED | Stock | 30.25 | 30.25 | 29.03 | 29.69 | 166300.0 |
| 2001-12-27 | ABK-DELISTED | Stock | 56.9 | 56.9 | 56.25 | 56.79 | 349900.0 |
| 2001-12-27 | ABM | Stock | 16.075 | 16.4 | 16.06 | 16.375 | 88200.0 |
| 2001-12-27 | ABMD-DELISTED | Stock | 16.34 | 16.6 | 15.98 | 16.2 | 168600.0 |
| 2001-12-27 | ABP-DELISTED | Stock | 1.34 | 1.34 | 1.22 | 1.26 | 136600.0 |
| 2001-12-27 | ABT | Stock | 25.309 | 25.5021 | 25.2552 | 25.3629 | 4176200.0 |
| 2001-12-27 | ABTL-DELISTED | Stock | 8.8 | 9.25 | 8.6 | 8.85 | 21400.0 |
| 2001-12-27 | ABV-DELISTED | Stock | 20.85 | 20.95 | 20.7 | 20.78 | 201400.0 |
| 2001-12-27 | ABX-DELISTED | Stock | 15.9 | 16.09 | 15.82 | 15.87 | 1979700.0 |
| 2001-12-27 | ACAP-DELISTED | Stock | 21.6 | 21.73 | 21.48 | 21.67 | 155900.0 |
| 2001-12-27 | ACAS-DELISTED | Stock | 28.25 | 28.75 | 28.0 | 28.7 | 220800.0 |
| 2001-12-27 | ACAT-DELISTED | Stock | 17.29 | 17.71 | 16.77 | 17.4 | 144600.0 |
| 2001-12-27 | ACCL-DELISTED | Stock | 9.74656009674072 | 10.1738004684448 | 9.74656009674072 | 10.1738004684448 | 90700.0 |
| 2001-12-27 | ACE-DELISTED | Stock | 39.99 | 40.11 | 39.81 | 39.95 | 1306356.0 |
| 2001-12-27 | ACF-DELISTED | Stock | 30.25 | 31.75 | 30.25 | 31.16 | 997000.0 |
| 2001-12-27 | ACG-DELISTED | Stock | 7.3 | 7.33 | 7.25 | 7.31 | 1733300.0 |
| 2001-12-27 | ACGL | Stock | 2.7667 | 2.9756 | 2.7456 | 2.8444 | 137700.0 |
| 2001-12-27 | ACGN-DELISTED | Stock | 1915.3288 | 1983.3288 | 1870.0 | 1870.0 | 58300.0 |
| 2001-12-27 | ACH | Stock | 12.5667 | 12.6467 | 12.4933 | 12.5333 | 112950.0 |
| 2001-12-27 | ACH-DELISTED | Stock | 4.2745 | 4.337 | 4.2745 | 4.287 | 712482.0 |
| 2001-12-27 | ACLS | Stock | 53.16 | 54.4 | 53.16 | 54.2 | 305325.0 |
| 2001-12-27 | ACO-DELISTED | Stock | 6.5 | 7.05 | 6.47 | 6.91 | 113000.0 |
| 2001-12-27 | ACPW-DELISTED | Stock | 30.55 | 32.75 | 29.35 | 32.15 | 63660.0 |
| 2001-12-27 | ACS-DELISTED | Stock | 51.98 | 52.4 | 51.955 | 52.225 | 368400.0 |
| 2001-12-27 | ACTA-DELISTED | Stock | 22.6 | 23.8 | 21.8 | 22.8 | 194000.0 |
| 2001-12-27 | ACTT-DELISTED | Stock | 7.75 | 8.18 | 7.7 | 7.98 | 50400.0 |
| 2001-12-27 | ACTU-DELISTED | Stock | 5.25 | 5.54 | 5.25 | 5.4 | 577900.0 |
| 2001-12-27 | ACXM-DELISTED | Stock | 17.9 | 18.08 | 17.82 | 17.97 | 964100.0 |
| 2001-12-27 | AD | Stock | 29.1667 | 29.3333 | 29.1667 | 29.3067 | 106650.0 |
| 2001-12-27 | ADAT-DELISTED | Stock | 67.68 | 71.1 | 65.7 | 67.68 | 2764.0 |
> showing 50 of 3,069 rows — these rows as CSV