PREVIEW / stock_daily / 2006-05-17
file: by_date/stock_daily/2006/2006-05-17.parquet size: 148 KB rows: 4,448 symbols: 2,815
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 |
|---|---|---|---|---|---|---|---|
| 2006-05-17 | AAPL | Stock | 2.3111 | 2.3464 | 2.2882 | 2.3307 | 754194000.0 |
| 2006-05-17 | MSFT | Stock | 22.89 | 23.08 | 22.73 | 22.73 | 98598300.0 |
| 2006-05-17 | NVDA | Stock | 0.432 | 0.4345 | 0.4083 | 0.416 | 841074000.0 |
| 2006-05-17 | AMZN | Stock | 1.6225 | 1.635 | 1.5765 | 1.5805 | 134082000.0 |
| 2006-05-17 | CL | Stock | 30.3 | 31.055 | 30.275 | 30.49 | 16189000.0 |
| 2006-05-17 | A | Stock | 24.8927 | 25.1788 | 24.7425 | 24.8856 | 6133585.0 |
| 2006-05-17 | AABA-DELISTED | Stock | 30.6100006103516 | 31.2600002288818 | 30.0400009155273 | 30.1100006103516 | 39847500.0 |
| 2006-05-17 | AACC-DELISTED | Stock | 18.89 | 18.96 | 17.87 | 18.47 | 199974.0 |
| 2006-05-17 | AACQ-DELISTED | Stock | 5.34 | 5.34 | 5.34 | 5.34 | 1800.0 |
| 2006-05-17 | AACQW-DELISTED | Stock | 0.65 | 0.65 | 0.65 | 0.65 | 10000.0 |
| 2006-05-17 | AAI-DELISTED | Stock | 12.9 | 13.11 | 12.61 | 12.78 | 3108700.0 |
| 2006-05-17 | AAIC-DELISTED | Stock | 206.0 | 206.0 | 196.0 | 199.2 | 1125000.0 |
| 2006-05-17 | AAME | Stock | 3.07 | 3.07 | 2.9 | 3.0 | 2600.0 |
| 2006-05-17 | AAON | Stock | 3.2909 | 3.3396 | 3.1618 | 3.2079 | 262744.0 |
| 2006-05-17 | AAP | Stock | 38.34 | 38.67 | 38.15 | 38.2 | 1220800.0 |
| 2006-05-17 | AATI-DELISTED | Stock | 10.82 | 10.82 | 10.5 | 10.53 | 109539.0 |
| 2006-05-17 | AAU-DELISTED | Stock | 2.73 | 2.73 | 2.6 | 2.62 | 90500.0 |
| 2006-05-17 | AAUAF-DELISTED | Stock | 2.73 | 2.73 | 2.6 | 2.62 | 90500.0 |
| 2006-05-17 | AAV-DELISTED | Stock | 18.98 | 18.98 | 18.01 | 18.25 | 687700.0 |
| 2006-05-17 | AAWW-DELISTED | Stock | 50.0 | 51.0 | 48.5 | 50.0 | 8000.0 |
| 2006-05-17 | AAXN-DELISTED | Stock | 9.75 | 9.78999996185303 | 9.38000011444092 | 9.53999996185303 | 1209100.0 |
| 2006-05-17 | AB | Stock | 66.14 | 66.14 | 64.24 | 64.53 | 284700.0 |
| 2006-05-17 | ABAX-DELISTED | Stock | 18.5 | 18.65 | 17.93 | 18.0 | 453370.0 |
| 2006-05-17 | ABB-DELISTED | Stock | 13.21 | 13.21 | 12.59 | 12.72 | 6325600.0 |
| 2006-05-17 | ABBC-DELISTED | Stock | 13.79 | 13.99 | 13.76 | 13.88 | 7500.0 |
| 2006-05-17 | ABC-DELISTED | Stock | 22.12 | 22.32 | 21.89 | 21.92 | 2215200.0 |
| 2006-05-17 | ABCB | Stock | 20.0461 | 20.0461 | 19.696 | 19.8127 | 10178.0 |
| 2006-05-17 | ABCO-DELISTED | Stock | 25.19 | 25.63 | 24.3 | 25.31 | 271917.0 |
| 2006-05-17 | ABCW-DELISTED | Stock | 28.5 | 29.19 | 28.34 | 28.97 | 47940.0 |
| 2006-05-17 | ABD-DELISTED | Stock | 22.78 | 23.37 | 22.76 | 23.02 | 130200.0 |
| 2006-05-17 | ABE-DELISTED | Stock | 13.23 | 13.2499 | 12.75 | 12.7501 | 42300.0 |
| 2006-05-17 | ABFS-DELISTED | Stock | 42.02 | 42.18 | 41.3 | 42.05 | 427658.0 |
| 2006-05-17 | ABG | Stock | 19.68 | 19.82 | 19.32 | 19.59 | 54500.0 |
| 2006-05-17 | ABK-DELISTED | Stock | 82.8 | 82.95 | 81.52 | 81.53 | 1560400.0 |
| 2006-05-17 | ABM | Stock | 17.25 | 17.38 | 17.17 | 17.25 | 209900.0 |
| 2006-05-17 | ABMD-DELISTED | Stock | 11.66 | 11.81 | 11.58 | 11.71 | 85162.0 |
| 2006-05-17 | ABP-DELISTED | Stock | 4.77 | 4.85 | 4.55 | 4.79 | 480600.0 |
| 2006-05-17 | ABR | Stock | 24.19 | 24.3 | 23.71 | 24.15 | 141200.0 |
| 2006-05-17 | ABT | Stock | 20.6314 | 20.6314 | 20.0508 | 20.07 | 11003752.0 |
| 2006-05-17 | ABTL-DELISTED | Stock | 17.65 | 18.85 | 17.65 | 18.0 | 53210.0 |
| 2006-05-17 | ABV-DELISTED | Stock | 43.8 | 44.06 | 41.75 | 42.15 | 1098900.0 |
| 2006-05-17 | ABVA-DELISTED | Stock | 18.85 | 18.85 | 18.85 | 18.85 | 100.0 |
| 2006-05-17 | ABVT-DELISTED | Stock | 40.0 | 44.0 | 40.0 | 44.0 | 8800.0 |
| 2006-05-17 | ABX-DELISTED | Stock | 32.5 | 33.09 | 30.85 | 30.94 | 9897700.0 |
| 2006-05-17 | ACAD | Stock | 10.92 | 11.0 | 10.24 | 10.61 | 317800.0 |
| 2006-05-17 | ACAP-DELISTED | Stock | 46.5 | 46.82 | 46.12 | 46.56 | 30061.0 |
| 2006-05-17 | ACAS-DELISTED | Stock | 33.85 | 34.04 | 33.55 | 33.65 | 1712472.0 |
| 2006-05-17 | ACAT-DELISTED | Stock | 19.14 | 20.01 | 19.14 | 19.27 | 185761.0 |
| 2006-05-17 | ACC-DELISTED | Stock | 23.4 | 23.4 | 22.51 | 22.82 | 145500.0 |
| 2006-05-17 | ACCL-DELISTED | Stock | 6.87 | 6.93 | 6.7 | 6.7 | 100344.0 |
> showing 50 of 4,448 rows — these rows as CSV