PREVIEW / stock_daily / 2006-04-11
file: by_date/stock_daily/2006/2006-04-11.parquet size: 147 KB rows: 4,388 symbols: 2,770
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-04-11 | AAPL | Stock | 2.4639 | 2.475 | 2.3954 | 2.4282 | 939316000.0 |
| 2006-04-11 | MSFT | Stock | 27.29 | 27.32 | 27.0 | 27.13 | 42953400.0 |
| 2006-04-11 | NVDA | Stock | 0.5017 | 0.5017 | 0.4848 | 0.4878 | 702072000.0 |
| 2006-04-11 | AMZN | Stock | 1.8305 | 1.8375 | 1.776 | 1.803 | 132112000.0 |
| 2006-04-11 | CL | Stock | 28.775 | 28.86 | 28.405 | 28.53 | 4133600.0 |
| 2006-04-11 | A | Stock | 26.5379 | 26.6452 | 26.073 | 26.4449 | 2249242.0 |
| 2006-04-11 | AABA-DELISTED | Stock | 32.4500007629395 | 32.5999984741211 | 31.1499996185303 | 31.3899993896484 | 22105600.0 |
| 2006-04-11 | AACC-DELISTED | Stock | 20.05 | 20.27 | 19.95 | 20.05 | 223452.0 |
| 2006-04-11 | AACQ-DELISTED | Stock | 5.45 | 5.45 | 5.45 | 5.45 | 54250.0 |
| 2006-04-11 | AACQU-DELISTED | Stock | 6.75 | 6.8 | 6.75 | 6.8 | 3000.0 |
| 2006-04-11 | AACQW-DELISTED | Stock | 0.71 | 0.74 | 0.71 | 0.71 | 72500.0 |
| 2006-04-11 | AAI-DELISTED | Stock | 16.7 | 16.8 | 16.0 | 16.17 | 1989400.0 |
| 2006-04-11 | AAIC-DELISTED | Stock | 182.0 | 183.2 | 178.2 | 178.4 | 472300.0 |
| 2006-04-11 | AAME | Stock | 3.0 | 3.0 | 3.0 | 3.0 | 900.0 |
| 2006-04-11 | AAON | Stock | 3.2079 | 3.2158 | 3.146 | 3.1842 | 104034.0 |
| 2006-04-11 | AAP | Stock | 40.45 | 40.46 | 38.61 | 39.41 | 3111500.0 |
| 2006-04-11 | AATI-DELISTED | Stock | 11.14 | 11.14 | 10.79 | 10.8 | 130361.0 |
| 2006-04-11 | AAU-DELISTED | Stock | 3.03 | 3.19 | 3.0 | 3.03 | 149300.0 |
| 2006-04-11 | AAUAF-DELISTED | Stock | 3.03 | 3.19 | 3.0 | 3.03 | 149300.0 |
| 2006-04-11 | AAV-DELISTED | Stock | 19.31 | 19.4 | 19.19 | 19.32 | 195200.0 |
| 2006-04-11 | AAWW-DELISTED | Stock | 45.0 | 45.5 | 45.0 | 45.5 | 700.0 |
| 2006-04-11 | AAXN-DELISTED | Stock | 10.2399997711182 | 10.3199996948242 | 9.75 | 9.77999973297119 | 1918900.0 |
| 2006-04-11 | AB | Stock | 67.75 | 68.15 | 67.64 | 67.86 | 145300.0 |
| 2006-04-11 | ABAX-DELISTED | Stock | 25.85 | 25.87 | 24.1 | 24.5 | 622033.0 |
| 2006-04-11 | ABB-DELISTED | Stock | 12.84 | 12.89 | 12.64 | 12.68 | 782700.0 |
| 2006-04-11 | ABBC-DELISTED | Stock | 13.51 | 13.58 | 13.51 | 13.53 | 19992.0 |
| 2006-04-11 | ABC-DELISTED | Stock | 23.36 | 23.4 | 22.76 | 22.89 | 3104000.0 |
| 2006-04-11 | ABCB | Stock | 21.6608 | 21.6608 | 20.8048 | 20.9312 | 13571.0 |
| 2006-04-11 | ABCO-DELISTED | Stock | 27.66 | 27.66 | 26.83 | 26.98 | 107217.0 |
| 2006-04-11 | ABCW-DELISTED | Stock | 29.25 | 29.25 | 28.58 | 28.64 | 47400.0 |
| 2006-04-11 | ABD-DELISTED | Stock | 22.51 | 22.72 | 22.05 | 22.19 | 88200.0 |
| 2006-04-11 | ABE-DELISTED | Stock | 13.02 | 13.05 | 12.92 | 12.93 | 18600.0 |
| 2006-04-11 | ABFS-DELISTED | Stock | 39.82 | 39.98 | 38.8 | 39.01 | 333979.0 |
| 2006-04-11 | ABG | Stock | 18.55 | 18.74 | 18.03 | 18.63 | 102700.0 |
| 2006-04-11 | ABK-DELISTED | Stock | 77.75 | 78.27 | 76.95 | 77.42 | 464200.0 |
| 2006-04-11 | ABM | Stock | 17.35 | 17.68 | 17.35 | 17.63 | 258700.0 |
| 2006-04-11 | ABMD-DELISTED | Stock | 13.5 | 13.74 | 12.65 | 13.17 | 122189.0 |
| 2006-04-11 | ABP-DELISTED | Stock | 5.29 | 5.39 | 5.15 | 5.25 | 468500.0 |
| 2006-04-11 | ABR | Stock | 26.2 | 26.2 | 25.76 | 25.98 | 109100.0 |
| 2006-04-11 | ABT | Stock | 20.1564 | 20.2332 | 19.6958 | 19.8877 | 12608378.0 |
| 2006-04-11 | ABTL-DELISTED | Stock | 22.8 | 23.1 | 22.0 | 22.0 | 30074.0 |
| 2006-04-11 | ABV-DELISTED | Stock | 45.2 | 45.41 | 44.44 | 44.66 | 623100.0 |
| 2006-04-11 | ABX-DELISTED | Stock | 29.54 | 29.69 | 28.47 | 28.61 | 4943600.0 |
| 2006-04-11 | ACAD | Stock | 15.25 | 15.36 | 14.67 | 14.71 | 475100.0 |
| 2006-04-11 | ACAP-DELISTED | Stock | 47.11 | 47.38 | 46.75 | 47.12 | 18749.0 |
| 2006-04-11 | ACAS-DELISTED | Stock | 34.8 | 34.81 | 34.1 | 34.55 | 969591.0 |
| 2006-04-11 | ACAT-DELISTED | Stock | 21.99 | 22.15 | 21.3 | 21.35 | 82381.0 |
| 2006-04-11 | ACC-DELISTED | Stock | 23.65 | 24.35 | 23.65 | 24.25 | 168200.0 |
| 2006-04-11 | ACCL-DELISTED | Stock | 7.24 | 7.33 | 7.06 | 7.26 | 95954.0 |
| 2006-04-11 | ACCO | Stock | 22.51 | 22.72 | 22.05 | 22.19 | 88500.0 |
> showing 50 of 4,388 rows — these rows as CSV