PREVIEW / stock_daily / 2006-04-10
file: by_date/stock_daily/2006/2006-04-10.parquet size: 148 KB rows: 4,391 symbols: 2,773
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-10 | AAPL | Stock | 2.5104 | 2.5332 | 2.4446 | 2.4525 | 903515200.0 |
| 2006-04-10 | MSFT | Stock | 27.23 | 27.44 | 27.2 | 27.29 | 39432000.0 |
| 2006-04-10 | NVDA | Stock | 0.5077 | 0.5107 | 0.4962 | 0.5 | 634230000.0 |
| 2006-04-10 | AMZN | Stock | 1.8575 | 1.864 | 1.811 | 1.8305 | 94950000.0 |
| 2006-04-10 | CL | Stock | 28.65 | 28.955 | 28.575 | 28.9 | 2217400.0 |
| 2006-04-10 | A | Stock | 27.01 | 27.1817 | 26.216 | 26.4092 | 3005281.0 |
| 2006-04-10 | AABA-DELISTED | Stock | 32.2799987792969 | 32.6300010681152 | 32.1199989318848 | 32.5499992370605 | 9618000.0 |
| 2006-04-10 | AACC-DELISTED | Stock | 19.68 | 20.92 | 19.68 | 20.08 | 550940.0 |
| 2006-04-10 | AACQ-DELISTED | Stock | 5.44 | 5.44 | 5.44 | 5.44 | 1200.0 |
| 2006-04-10 | AACQW-DELISTED | Stock | 0.7 | 0.7 | 0.7 | 0.7 | 37500.0 |
| 2006-04-10 | AAI-DELISTED | Stock | 17.2 | 17.23 | 16.8 | 16.85 | 1041600.0 |
| 2006-04-10 | AAIC-DELISTED | Stock | 181.4 | 183.2 | 179.0 | 182.0 | 749500.0 |
| 2006-04-10 | AAME | Stock | 2.86 | 3.1 | 2.86 | 3.0 | 2300.0 |
| 2006-04-10 | AAON | Stock | 3.2329 | 3.2435 | 3.1934 | 3.229 | 347034.0 |
| 2006-04-10 | AAP | Stock | 40.95 | 41.31 | 40.58 | 40.59 | 546600.0 |
| 2006-04-10 | AATI-DELISTED | Stock | 11.25 | 11.27 | 11.0 | 11.07 | 108246.0 |
| 2006-04-10 | AAU-DELISTED | Stock | 3.1 | 3.17 | 3.03 | 3.03 | 109700.0 |
| 2006-04-10 | AAUAF-DELISTED | Stock | 3.1 | 3.17 | 3.03 | 3.03 | 109700.0 |
| 2006-04-10 | AAV-DELISTED | Stock | 19.12 | 19.26 | 19.1 | 19.22 | 173800.0 |
| 2006-04-10 | AAXN-DELISTED | Stock | 10.8000001907349 | 10.8699998855591 | 10.0799999237061 | 10.25 | 2161900.0 |
| 2006-04-10 | AB | Stock | 67.77 | 68.14 | 67.49 | 68.11 | 130800.0 |
| 2006-04-10 | ABAX-DELISTED | Stock | 24.45 | 26.59 | 24.41 | 25.24 | 1817484.0 |
| 2006-04-10 | ABB-DELISTED | Stock | 12.89 | 12.91 | 12.76 | 12.82 | 1149300.0 |
| 2006-04-10 | ABBC-DELISTED | Stock | 13.5 | 13.59 | 13.5 | 13.58 | 12500.0 |
| 2006-04-10 | ABC-DELISTED | Stock | 22.98 | 23.35 | 22.85 | 23.3 | 2641800.0 |
| 2006-04-10 | ABCB | Stock | 21.8747 | 21.8747 | 21.4273 | 21.4759 | 19637.0 |
| 2006-04-10 | ABCO-DELISTED | Stock | 27.37 | 27.88 | 27.28 | 27.66 | 103553.0 |
| 2006-04-10 | ABCW-DELISTED | Stock | 29.12 | 29.27 | 29.0 | 29.14 | 37820.0 |
| 2006-04-10 | ABD-DELISTED | Stock | 22.82 | 22.92 | 22.5 | 22.53 | 118500.0 |
| 2006-04-10 | ABE-DELISTED | Stock | 13.03 | 13.1 | 12.95 | 12.97 | 26900.0 |
| 2006-04-10 | ABFS-DELISTED | Stock | 41.05 | 41.05 | 39.65 | 40.01 | 427466.0 |
| 2006-04-10 | ABG | Stock | 18.59 | 18.69 | 18.45 | 18.55 | 79400.0 |
| 2006-04-10 | ABK-DELISTED | Stock | 77.85 | 78.75 | 77.47 | 77.96 | 653100.0 |
| 2006-04-10 | ABM | Stock | 17.74 | 17.75 | 17.37 | 17.47 | 480900.0 |
| 2006-04-10 | ABMD-DELISTED | Stock | 13.72 | 13.75 | 13.3 | 13.5 | 128458.0 |
| 2006-04-10 | ABP-DELISTED | Stock | 5.22 | 5.4 | 5.22 | 5.28 | 453400.0 |
| 2006-04-10 | ABR | Stock | 26.05 | 26.31 | 25.95 | 26.15 | 67100.0 |
| 2006-04-10 | ABT | Stock | 20.2044 | 20.3387 | 20.1132 | 20.238 | 7751563.0 |
| 2006-04-10 | ABTL-DELISTED | Stock | 23.12 | 23.12 | 22.58 | 22.93 | 28288.0 |
| 2006-04-10 | ABV-DELISTED | Stock | 45.6 | 45.6 | 44.6 | 44.84 | 379800.0 |
| 2006-04-10 | ABVA-DELISTED | Stock | 18.759 | 18.759 | 18.665 | 18.691 | 18376.0 |
| 2006-04-10 | ABVT-DELISTED | Stock | 38.0 | 40.0 | 38.0 | 40.0 | 4800.0 |
| 2006-04-10 | ABX-DELISTED | Stock | 29.8 | 29.86 | 29.21 | 29.37 | 3483100.0 |
| 2006-04-10 | ACAD | Stock | 15.3 | 15.54 | 15.16 | 15.26 | 180100.0 |
| 2006-04-10 | ACAP-DELISTED | Stock | 46.98 | 47.83 | 46.85 | 47.28 | 53379.0 |
| 2006-04-10 | ACAS-DELISTED | Stock | 35.0 | 35.18 | 34.5 | 34.64 | 1026068.0 |
| 2006-04-10 | ACAT-DELISTED | Stock | 22.71 | 22.79 | 21.76 | 21.85 | 59335.0 |
| 2006-04-10 | ACC-DELISTED | Stock | 24.14 | 24.42 | 23.59 | 23.61 | 78717.0 |
| 2006-04-10 | ACCL-DELISTED | Stock | 7.2 | 7.31 | 7.18 | 7.25 | 115968.0 |
| 2006-04-10 | ACCO | Stock | 22.82 | 22.92 | 22.5 | 22.53 | 118500.0 |
> showing 50 of 4,391 rows — these rows as CSV