PREVIEW / stock_daily / 2006-07-13
file: by_date/stock_daily/2006/2006-07-13.parquet size: 148 KB rows: 4,453 symbols: 2,811
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-07-13 | AAPL | Stock | 1.8582 | 1.9329 | 1.8361 | 1.8661 | 1249906000.0 |
| 2006-07-13 | MSFT | Stock | 22.37 | 22.61 | 22.25 | 22.26 | 73099500.0 |
| 2006-07-13 | NVDA | Stock | 0.2992 | 0.3067 | 0.2945 | 0.296 | 540582000.0 |
| 2006-07-13 | AMZN | Stock | 1.7165 | 1.7315 | 1.6855 | 1.6865 | 129110000.0 |
| 2006-07-13 | CL | Stock | 30.47 | 30.985 | 30.445 | 30.8 | 3330800.0 |
| 2006-07-13 | A | Stock | 20.3505 | 20.6223 | 20.1788 | 20.3648 | 5448006.0 |
| 2006-07-13 | AABA-DELISTED | Stock | 32.8499984741211 | 33.1599998474121 | 32.0699996948242 | 32.2299995422363 | 19463500.0 |
| 2006-07-13 | AACC-DELISTED | Stock | 19.36 | 19.56 | 18.85 | 18.85 | 115014.0 |
| 2006-07-13 | AACQ-DELISTED | Stock | 5.3 | 5.31 | 5.28 | 5.31 | 60500.0 |
| 2006-07-13 | AACQU-DELISTED | Stock | 6.15 | 6.15 | 6.15 | 6.15 | 11500.0 |
| 2006-07-13 | AACQW-DELISTED | Stock | 0.43 | 0.44 | 0.43 | 0.43 | 12000.0 |
| 2006-07-13 | AAI-DELISTED | Stock | 13.81 | 13.97 | 13.1 | 13.16 | 1226000.0 |
| 2006-07-13 | AAIC-DELISTED | Stock | 210.4 | 210.6 | 199.4 | 200.2 | 2342400.0 |
| 2006-07-13 | AAME | Stock | 2.82 | 2.96 | 2.82 | 2.85 | 1300.0 |
| 2006-07-13 | AAON | Stock | 3.0999 | 3.0999 | 2.9827 | 2.9972 | 124537.0 |
| 2006-07-13 | AAP | Stock | 28.89 | 29.13 | 28.52 | 28.85 | 1215000.0 |
| 2006-07-13 | AATI-DELISTED | Stock | 8.79 | 8.85 | 8.41 | 8.45 | 215634.0 |
| 2006-07-13 | AAU-DELISTED | Stock | 2.53 | 2.57 | 2.43 | 2.43 | 71600.0 |
| 2006-07-13 | AAUAF-DELISTED | Stock | 2.53 | 2.57 | 2.43 | 2.43 | 71600.0 |
| 2006-07-13 | AAV-DELISTED | Stock | 15.47 | 15.57 | 15.45 | 15.54 | 605300.0 |
| 2006-07-13 | AAWW-DELISTED | Stock | 45.37 | 45.37 | 41.7 | 42.38 | 491190.0 |
| 2006-07-13 | AAXN-DELISTED | Stock | 8.25 | 8.28999996185303 | 7.84999990463257 | 7.90000009536743 | 763700.0 |
| 2006-07-13 | AB | Stock | 58.23 | 58.23 | 56.91 | 57.0 | 354400.0 |
| 2006-07-13 | ABAX-DELISTED | Stock | 20.67 | 20.7 | 19.73 | 19.84 | 264241.0 |
| 2006-07-13 | ABB-DELISTED | Stock | 12.09 | 12.233 | 12.02 | 12.02 | 1560500.0 |
| 2006-07-13 | ABBC-DELISTED | Stock | 14.5 | 14.6 | 14.17 | 14.26 | 11667.0 |
| 2006-07-13 | ABC-DELISTED | Stock | 20.85 | 21.04 | 20.79 | 20.79 | 2860800.0 |
| 2006-07-13 | ABCB | Stock | 21.5732 | 21.8844 | 20.62 | 20.62 | 13571.0 |
| 2006-07-13 | ABCO-DELISTED | Stock | 23.99 | 23.99 | 23.57 | 23.62 | 206417.0 |
| 2006-07-13 | ABCW-DELISTED | Stock | 29.04 | 29.49 | 28.59 | 28.67 | 42860.0 |
| 2006-07-13 | ABD-DELISTED | Stock | 20.4 | 20.45 | 20.02 | 20.25 | 355300.0 |
| 2006-07-13 | ABE-DELISTED | Stock | 12.22 | 12.24 | 12.03 | 12.04 | 9400.0 |
| 2006-07-13 | ABFS-DELISTED | Stock | 46.97 | 47.0 | 45.52 | 45.69 | 361269.0 |
| 2006-07-13 | ABG | Stock | 20.3 | 20.45 | 19.75 | 19.81 | 102900.0 |
| 2006-07-13 | ABK-DELISTED | Stock | 83.08 | 83.22 | 82.06 | 82.28 | 787400.0 |
| 2006-07-13 | ABM | Stock | 16.43 | 16.69 | 16.22 | 16.5 | 208600.0 |
| 2006-07-13 | ABMD-DELISTED | Stock | 13.39 | 13.75 | 13.19 | 13.28 | 111033.0 |
| 2006-07-13 | ABP-DELISTED | Stock | 4.39 | 4.47 | 4.31 | 4.39 | 150600.0 |
| 2006-07-13 | ABR | Stock | 24.99 | 25.22 | 24.94 | 25.02 | 67600.0 |
| 2006-07-13 | ABT | Stock | 21.0632 | 21.1976 | 21.0008 | 21.1064 | 16432472.0 |
| 2006-07-13 | ABTL-DELISTED | Stock | 16.424 | 17.376 | 16.424 | 17.276 | 52491.0 |
| 2006-07-13 | ABV-DELISTED | Stock | 39.85 | 40.15 | 38.53 | 39.12 | 535800.0 |
| 2006-07-13 | ABVA-DELISTED | Stock | 16.29 | 16.296 | 16.28 | 16.29 | 785.0 |
| 2006-07-13 | ABX-DELISTED | Stock | 30.26 | 30.33 | 29.22 | 29.33 | 5160400.0 |
| 2006-07-13 | ACAD | Stock | 8.42 | 8.63 | 7.65 | 7.69 | 325000.0 |
| 2006-07-13 | ACAP-DELISTED | Stock | 49.87 | 49.87 | 47.99 | 47.99 | 35069.0 |
| 2006-07-13 | ACAS-DELISTED | Stock | 33.91 | 33.93 | 33.33 | 33.55 | 755400.0 |
| 2006-07-13 | ACAT-DELISTED | Stock | 17.03 | 17.22 | 16.68 | 16.88 | 141088.0 |
| 2006-07-13 | ACC-DELISTED | Stock | 25.3 | 25.45 | 24.25 | 24.33 | 53700.0 |
| 2006-07-13 | ACCL-DELISTED | Stock | 7.12 | 7.23 | 6.71 | 6.71 | 31392.0 |
> showing 50 of 4,453 rows — these rows as CSV