PREVIEW / stock_daily / 2006-06-12
file: by_date/stock_daily/2006/2006-06-12.parquet size: 148 KB rows: 4,442 symbols: 2,806
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-12 | AAPL | Stock | 2.1214 | 2.1332 | 2.0343 | 2.0357 | 717785600.0 |
| 2006-06-12 | MSFT | Stock | 21.96 | 22.1 | 21.7 | 21.71 | 74309700.0 |
| 2006-06-12 | NVDA | Stock | 0.3497 | 0.3543 | 0.3342 | 0.3362 | 463230000.0 |
| 2006-06-12 | AMZN | Stock | 1.7 | 1.7225 | 1.6745 | 1.68 | 83916000.0 |
| 2006-06-12 | CL | Stock | 30.8 | 31.16 | 30.65 | 30.66 | 6605200.0 |
| 2006-06-12 | A | Stock | 24.1059 | 24.206 | 23.0186 | 23.319 | 7134553.0 |
| 2006-06-12 | AABA-DELISTED | Stock | 30.3700008392334 | 30.6499996185303 | 29.6599998474121 | 29.7800006866455 | 14344600.0 |
| 2006-06-12 | AACC-DELISTED | Stock | 17.92 | 18.22 | 17.91 | 18.07 | 226569.0 |
| 2006-06-12 | AACQ-DELISTED | Stock | 5.39 | 5.39 | 5.35 | 5.35 | 5500.0 |
| 2006-06-12 | AACQW-DELISTED | Stock | 0.47 | 0.47 | 0.47 | 0.47 | 25000.0 |
| 2006-06-12 | AAI-DELISTED | Stock | 12.25 | 12.25 | 11.59 | 11.63 | 1413000.0 |
| 2006-06-12 | AAIC-DELISTED | Stock | 209.8 | 210.2 | 201.2 | 201.6 | 497000.0 |
| 2006-06-12 | AAME | Stock | 3.05 | 3.05 | 3.04 | 3.04 | 4000.0 |
| 2006-06-12 | AAON | Stock | 2.9393 | 2.963 | 2.8418 | 2.8813 | 213384.0 |
| 2006-06-12 | AAP | Stock | 37.81 | 37.82 | 36.96 | 36.99 | 770800.0 |
| 2006-06-12 | AATI-DELISTED | Stock | 11.05 | 11.05 | 10.3701 | 11.0 | 90989.0 |
| 2006-06-12 | AAU-DELISTED | Stock | 2.58 | 2.58 | 2.35 | 2.4 | 54600.0 |
| 2006-06-12 | AAUAF-DELISTED | Stock | 2.58 | 2.58 | 2.35 | 2.4 | 54600.0 |
| 2006-06-12 | AAV-DELISTED | Stock | 18.2 | 18.37 | 17.66 | 17.66 | 244700.0 |
| 2006-06-12 | AAWW-DELISTED | Stock | 49.48 | 49.75 | 47.75 | 48.42 | 92517.0 |
| 2006-06-12 | AAXN-DELISTED | Stock | 9.0 | 9.14000034332275 | 8.5 | 8.56999969482422 | 1308700.0 |
| 2006-06-12 | AB | Stock | 62.81 | 62.86 | 61.02 | 61.13 | 183000.0 |
| 2006-06-12 | ABAX-DELISTED | Stock | 17.56 | 17.71 | 17.33 | 17.45 | 261272.0 |
| 2006-06-12 | ABB-DELISTED | Stock | 11.15 | 11.16 | 10.69 | 10.74 | 2058200.0 |
| 2006-06-12 | ABBC-DELISTED | Stock | 14.67 | 14.67 | 14.58 | 14.58 | 118729.0 |
| 2006-06-12 | ABC-DELISTED | Stock | 20.9 | 21.1 | 20.6 | 20.62 | 1664400.0 |
| 2006-06-12 | ABCB | Stock | 20.4936 | 20.4936 | 19.978 | 20.1337 | 12132.0 |
| 2006-06-12 | ABCO-DELISTED | Stock | 24.75 | 24.78 | 24.3 | 24.3 | 100656.0 |
| 2006-06-12 | ABCW-DELISTED | Stock | 28.94 | 29.39 | 28.67 | 29.06 | 52700.0 |
| 2006-06-12 | ABD-DELISTED | Stock | 22.12 | 22.28 | 22.12 | 22.2 | 309400.0 |
| 2006-06-12 | ABE-DELISTED | Stock | 11.77 | 11.77 | 11.51 | 11.51 | 29200.0 |
| 2006-06-12 | ABFS-DELISTED | Stock | 43.09 | 43.23 | 41.42 | 41.42 | 316513.0 |
| 2006-06-12 | ABG | Stock | 21.41 | 21.64 | 21.08 | 21.28 | 108800.0 |
| 2006-06-12 | ABK-DELISTED | Stock | 79.7 | 79.7 | 77.78 | 77.85 | 637100.0 |
| 2006-06-12 | ABM | Stock | 17.52 | 17.68 | 17.18 | 17.29 | 233300.0 |
| 2006-06-12 | ABMD-DELISTED | Stock | 12.94 | 12.95 | 12.3 | 12.39 | 106104.0 |
| 2006-06-12 | ABP-DELISTED | Stock | 4.4 | 4.65 | 4.25 | 4.32 | 128800.0 |
| 2006-06-12 | ABR | Stock | 23.98 | 24.21 | 23.92 | 24.0 | 117400.0 |
| 2006-06-12 | ABT | Stock | 20.6314 | 20.7705 | 20.4731 | 20.4971 | 6735515.0 |
| 2006-06-12 | ABTL-DELISTED | Stock | 14.951 | 15.199 | 14.654 | 15.05 | 138351.0 |
| 2006-06-12 | ABV-DELISTED | Stock | 39.0 | 39.4 | 36.951 | 36.98 | 613600.0 |
| 2006-06-12 | ABVA-DELISTED | Stock | 16.61 | 16.61 | 16.6 | 16.6 | 300.0 |
| 2006-06-12 | ABX-DELISTED | Stock | 28.19 | 28.48 | 27.58 | 27.64 | 4045373.0 |
| 2006-06-12 | ACAD | Stock | 9.15 | 9.2 | 8.92 | 9.04 | 150100.0 |
| 2006-06-12 | ACAP-DELISTED | Stock | 44.91 | 45.63 | 44.0 | 45.24 | 39716.0 |
| 2006-06-12 | ACAS-DELISTED | Stock | 33.79 | 33.99 | 32.88 | 32.88 | 1127294.0 |
| 2006-06-12 | ACAT-DELISTED | Stock | 17.73 | 17.73 | 17.3 | 17.52 | 45744.0 |
| 2006-06-12 | ACC-DELISTED | Stock | 25.53 | 25.53 | 24.18 | 24.41 | 113700.0 |
| 2006-06-12 | ACCL-DELISTED | Stock | 7.25 | 7.3 | 7.09 | 7.29 | 111867.0 |
| 2006-06-12 | ACCO | Stock | 22.12 | 22.28 | 22.12 | 22.2 | 312100.0 |
> showing 50 of 4,442 rows — these rows as CSV