PREVIEW / stock_daily / 2006-10-13
file: by_date/stock_daily/2006/2006-10-13.parquet size: 151 KB rows: 4,519 symbols: 2,853
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-10-13 | AAPL | Stock | 2.7011 | 2.7457 | 2.6693 | 2.6793 | 684196800.0 |
| 2006-10-13 | MSFT | Stock | 28.34 | 28.69 | 28.31 | 28.37 | 129751900.0 |
| 2006-10-13 | NVDA | Stock | 0.5395 | 0.566 | 0.5307 | 0.5628 | 584190000.0 |
| 2006-10-13 | AMZN | Stock | 1.6675 | 1.679 | 1.654 | 1.666 | 81346000.0 |
| 2006-10-13 | CL | Stock | 30.655 | 30.685 | 30.39 | 30.4 | 4668400.0 |
| 2006-10-13 | A | Stock | 23.9628 | 24.7711 | 23.9557 | 24.6781 | 4166180.0 |
| 2006-10-13 | AABA-DELISTED | Stock | 23.8999996185303 | 24.5 | 23.5699996948242 | 24.4200000762939 | 51338900.0 |
| 2006-10-13 | AACC-DELISTED | Stock | 17.1 | 17.62 | 17.07 | 17.54 | 123819.0 |
| 2006-10-13 | AACQ-DELISTED | Stock | 5.36 | 5.36 | 5.35 | 5.35 | 30300.0 |
| 2006-10-13 | AACQU-DELISTED | Stock | 6.02 | 6.08 | 6.02 | 6.08 | 12500.0 |
| 2006-10-13 | AACQW-DELISTED | Stock | 0.35 | 0.37 | 0.35 | 0.37 | 205000.0 |
| 2006-10-13 | AAI-DELISTED | Stock | 10.98 | 11.06 | 10.45 | 10.53 | 2584600.0 |
| 2006-10-13 | AAIC-DELISTED | Stock | 159.8 | 165.6 | 159.8 | 165.2 | 697800.0 |
| 2006-10-13 | AAME | Stock | 2.47 | 2.47 | 2.47 | 2.47 | 300.0 |
| 2006-10-13 | AAON | Stock | 3.1776 | 3.1789 | 3.1473 | 3.1513 | 593072.0 |
| 2006-10-13 | AAP | Stock | 35.0 | 35.5 | 34.88 | 35.46 | 933400.0 |
| 2006-10-13 | AATI-DELISTED | Stock | 5.23 | 5.4 | 5.17 | 5.3401 | 1847053.0 |
| 2006-10-13 | AAU-DELISTED | Stock | 2.33 | 2.51 | 2.33 | 2.42 | 104800.0 |
| 2006-10-13 | AAUAF-DELISTED | Stock | 2.33 | 2.51 | 2.33 | 2.42 | 104800.0 |
| 2006-10-13 | AAV-DELISTED | Stock | 12.21 | 12.35 | 12.16 | 12.35 | 962000.0 |
| 2006-10-13 | AAWW-DELISTED | Stock | 46.84 | 47.07 | 46.45 | 46.55 | 61565.0 |
| 2006-10-13 | AAXN-DELISTED | Stock | 9.53999996185303 | 9.72000026702881 | 9.3100004196167 | 9.63000011444092 | 1185500.0 |
| 2006-10-13 | AB | Stock | 75.21 | 76.84 | 75.06 | 76.09 | 492000.0 |
| 2006-10-13 | ABAX-DELISTED | Stock | 21.76 | 22.11 | 21.18 | 22.11 | 695062.0 |
| 2006-10-13 | ABB-DELISTED | Stock | 13.91 | 13.95 | 13.85 | 13.91 | 1228700.0 |
| 2006-10-13 | ABBC-DELISTED | Stock | 15.5 | 15.68 | 15.5 | 15.6 | 15418.0 |
| 2006-10-13 | ABC-DELISTED | Stock | 23.28 | 23.36 | 23.01 | 23.08 | 2053590.0 |
| 2006-10-13 | ABCB | Stock | 28.0412 | 28.0412 | 27.3993 | 27.7203 | 39789.0 |
| 2006-10-13 | ABCO-DELISTED | Stock | 27.45 | 27.7 | 27.31 | 27.58 | 139703.0 |
| 2006-10-13 | ABCW-DELISTED | Stock | 29.46 | 29.5 | 29.16 | 29.28 | 41260.0 |
| 2006-10-13 | ABD-DELISTED | Stock | 23.31 | 23.54 | 23.1 | 23.12 | 118900.0 |
| 2006-10-13 | ABE-DELISTED | Stock | 14.51 | 14.61 | 14.51 | 14.6 | 41600.0 |
| 2006-10-13 | ABFS-DELISTED | Stock | 48.55 | 49.81 | 47.59 | 48.86 | 488702.0 |
| 2006-10-13 | ABG | Stock | 22.69 | 23.06 | 22.58 | 22.98 | 463100.0 |
| 2006-10-13 | ABK-DELISTED | Stock | 85.24 | 85.4 | 84.82 | 85.05 | 454700.0 |
| 2006-10-13 | ABM | Stock | 19.49 | 19.59 | 19.31 | 19.54 | 169000.0 |
| 2006-10-13 | ABMD-DELISTED | Stock | 13.94 | 14.0 | 13.29 | 13.48 | 324458.0 |
| 2006-10-13 | ABP-DELISTED | Stock | 3.45 | 3.59 | 3.45 | 3.55 | 133100.0 |
| 2006-10-13 | ABR | Stock | 26.77 | 27.17 | 26.74 | 27.02 | 43500.0 |
| 2006-10-13 | ABT | Stock | 22.3587 | 22.565 | 22.2675 | 22.517 | 13642768.0 |
| 2006-10-13 | ABTL-DELISTED | Stock | 15.825 | 15.975 | 15.524 | 15.925 | 9329.0 |
| 2006-10-13 | ABV-DELISTED | Stock | 46.76 | 46.85 | 46.13 | 46.76 | 935700.0 |
| 2006-10-13 | ABVA-DELISTED | Stock | 16.29 | 17.14 | 16.29 | 17.14 | 808.0 |
| 2006-10-13 | ABX-DELISTED | Stock | 29.42 | 29.81 | 29.27 | 29.78 | 4384485.0 |
| 2006-10-13 | ACAD | Stock | 9.87 | 10.33 | 9.85 | 10.1 | 310300.0 |
| 2006-10-13 | ACAP-DELISTED | Stock | 51.32 | 51.32 | 50.5 | 50.97 | 23000.0 |
| 2006-10-13 | ACAS-DELISTED | Stock | 41.44 | 42.0 | 41.15 | 41.89 | 840362.0 |
| 2006-10-13 | ACAT-DELISTED | Stock | 17.18 | 17.18 | 16.74 | 17.07 | 160609.0 |
| 2006-10-13 | ACC-DELISTED | Stock | 26.15 | 26.71 | 26.14 | 26.36 | 81400.0 |
| 2006-10-13 | ACCL-DELISTED | Stock | 5.99 | 6.14 | 5.95 | 6.14 | 96461.0 |
> showing 50 of 4,519 rows — these rows as CSV