PREVIEW / stock_daily / 2006-06-08
file: by_date/stock_daily/2006/2006-06-08.parquet size: 148 KB rows: 4,442 symbols: 2,807
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-06-08 | AAPL | Stock | 2.0871 | 2.1761 | 2.0411 | 2.17 | 1397482800.0 |
| 2006-06-08 | MSFT | Stock | 22.03 | 22.21 | 21.97 | 22.11 | 104126900.0 |
| 2006-06-08 | NVDA | Stock | 0.3595 | 0.3642 | 0.3427 | 0.357 | 730572000.0 |
| 2006-06-08 | AMZN | Stock | 1.6775 | 1.703 | 1.621 | 1.6775 | 166220000.0 |
| 2006-06-08 | CL | Stock | 30.3 | 30.55 | 30.16 | 30.535 | 7099600.0 |
| 2006-06-08 | A | Stock | 24.1059 | 24.1202 | 23.4621 | 23.97 | 4266696.0 |
| 2006-06-08 | AABA-DELISTED | Stock | 30.4300003051758 | 30.9899997711182 | 29.8299999237061 | 30.4500007629395 | 20538600.0 |
| 2006-06-08 | AACC-DELISTED | Stock | 17.03 | 17.66 | 16.83 | 17.44 | 134427.0 |
| 2006-06-08 | AACQ-DELISTED | Stock | 5.37 | 5.4 | 5.3 | 5.4 | 429289.0 |
| 2006-06-08 | AACQU-DELISTED | Stock | 6.2 | 6.2 | 6.2 | 6.2 | 800.0 |
| 2006-06-08 | AACQW-DELISTED | Stock | 0.47 | 0.48 | 0.45 | 0.48 | 23000.0 |
| 2006-06-08 | AAI-DELISTED | Stock | 12.6 | 12.6 | 11.86 | 12.43 | 2287600.0 |
| 2006-06-08 | AAIC-DELISTED | Stock | 206.4 | 207.0 | 196.2 | 205.6 | 1705300.0 |
| 2006-06-08 | AAON | Stock | 3.0288 | 3.1381 | 2.8444 | 2.9116 | 152634.0 |
| 2006-06-08 | AAP | Stock | 37.07 | 38.12 | 36.68 | 37.9 | 1056200.0 |
| 2006-06-08 | AATI-DELISTED | Stock | 10.91 | 10.91 | 10.53 | 10.69 | 108522.0 |
| 2006-06-08 | AAU-DELISTED | Stock | 2.38 | 2.42 | 2.25 | 2.39 | 98400.0 |
| 2006-06-08 | AAUAF-DELISTED | Stock | 2.38 | 2.42 | 2.25 | 2.39 | 98400.0 |
| 2006-06-08 | AAV-DELISTED | Stock | 18.0 | 18.0019 | 17.25 | 17.84 | 626700.0 |
| 2006-06-08 | AAWW-DELISTED | Stock | 50.75 | 51.0 | 48.76 | 49.47 | 150629.0 |
| 2006-06-08 | AAXN-DELISTED | Stock | 9.22000026702881 | 9.30000019073486 | 8.69999980926514 | 9.18000030517578 | 817300.0 |
| 2006-06-08 | AB | Stock | 62.88 | 62.97 | 60.31 | 62.75 | 335800.0 |
| 2006-06-08 | ABAX-DELISTED | Stock | 17.72 | 18.23 | 17.21 | 17.75 | 457115.0 |
| 2006-06-08 | ABB-DELISTED | Stock | 11.17 | 11.19 | 10.77 | 11.07 | 6503300.0 |
| 2006-06-08 | ABBC-DELISTED | Stock | 14.5908 | 14.6 | 14.5108 | 14.59 | 16868.0 |
| 2006-06-08 | ABC-DELISTED | Stock | 21.62 | 21.62 | 21.03 | 21.3 | 4388800.0 |
| 2006-06-08 | ABCB | Stock | 20.4352 | 20.9507 | 20.0851 | 20.9312 | 16656.0 |
| 2006-06-08 | ABCO-DELISTED | Stock | 24.3 | 24.76 | 23.59 | 24.56 | 385129.0 |
| 2006-06-08 | ABCW-DELISTED | Stock | 28.58 | 29.4 | 28.53 | 29.29 | 59340.0 |
| 2006-06-08 | ABD-DELISTED | Stock | 22.32 | 22.55 | 22.15 | 22.45 | 466400.0 |
| 2006-06-08 | ABE-DELISTED | Stock | 12.14 | 12.6399 | 11.83 | 12.11 | 55000.0 |
| 2006-06-08 | ABFS-DELISTED | Stock | 42.07 | 42.81 | 40.97 | 42.48 | 579566.0 |
| 2006-06-08 | ABG | Stock | 21.38 | 21.58 | 21.26 | 21.38 | 221900.0 |
| 2006-06-08 | ABK-DELISTED | Stock | 79.44 | 79.6 | 78.77 | 79.44 | 873100.0 |
| 2006-06-08 | ABM | Stock | 17.75 | 18.22 | 17.7 | 18.17 | 397600.0 |
| 2006-06-08 | ABMD-DELISTED | Stock | 13.05 | 13.19 | 12.81 | 13.11 | 95960.0 |
| 2006-06-08 | ABP-DELISTED | Stock | 4.49 | 4.63 | 4.16 | 4.53 | 285500.0 |
| 2006-06-08 | ABR | Stock | 24.07 | 24.36 | 23.87 | 24.35 | 192000.0 |
| 2006-06-08 | ABT | Stock | 20.3915 | 20.7226 | 20.2763 | 20.713 | 12869112.0 |
| 2006-06-08 | ABTL-DELISTED | Stock | 14.6 | 15.4 | 14.35 | 15.2 | 81252.0 |
| 2006-06-08 | ABV-DELISTED | Stock | 41.21 | 41.21 | 38.93 | 39.74 | 1324500.0 |
| 2006-06-08 | ABVA-DELISTED | Stock | 16.75 | 16.75 | 16.5 | 16.51 | 11098.0 |
| 2006-06-08 | ABX-DELISTED | Stock | 28.3 | 28.51 | 27.0 | 28.19 | 8506800.0 |
| 2006-06-08 | ACAD | Stock | 9.74 | 9.99 | 8.97 | 9.22 | 298700.0 |
| 2006-06-08 | ACAP-DELISTED | Stock | 44.84 | 46.57 | 44.68 | 46.47 | 47338.0 |
| 2006-06-08 | ACAS-DELISTED | Stock | 34.0 | 34.06 | 33.55 | 33.63 | 1013296.0 |
| 2006-06-08 | ACAT-DELISTED | Stock | 17.72 | 18.5 | 17.72 | 18.24 | 87078.0 |
| 2006-06-08 | ACC-DELISTED | Stock | 24.12 | 24.83 | 23.97 | 24.78 | 97500.0 |
| 2006-06-08 | ACCL-DELISTED | Stock | 7.2 | 7.33 | 7.01 | 7.26 | 72700.0 |
| 2006-06-08 | ACCO | Stock | 22.32 | 22.55 | 22.15 | 22.45 | 466400.0 |
> showing 50 of 4,442 rows — these rows as CSV