PREVIEW / stock_daily / 2006-08-11
file: by_date/stock_daily/2006/2006-08-11.parquet size: 147 KB rows: 4,425 symbols: 2,779
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-08-11 | AAPL | Stock | 2.2582 | 2.2904 | 2.235 | 2.2732 | 777529200.0 |
| 2006-08-11 | MSFT | Stock | 24.43 | 24.45 | 24.2 | 24.43 | 30255500.0 |
| 2006-08-11 | NVDA | Stock | 0.3733 | 0.4002 | 0.372 | 0.39 | 1603272000.0 |
| 2006-08-11 | AMZN | Stock | 1.3215 | 1.3215 | 1.288 | 1.3035 | 102318000.0 |
| 2006-08-11 | CL | Stock | 29.8 | 29.87 | 29.505 | 29.755 | 3201600.0 |
| 2006-08-11 | A | Stock | 19.7783 | 19.7997 | 19.3848 | 19.4564 | 2291042.0 |
| 2006-08-11 | AABA-DELISTED | Stock | 27.5200004577637 | 27.7199993133545 | 27.3999996185303 | 27.5 | 9252200.0 |
| 2006-08-11 | AACC-DELISTED | Stock | 15.75 | 15.75 | 15.14 | 15.28 | 91650.0 |
| 2006-08-11 | AACQ-DELISTED | Stock | 5.35 | 5.35 | 5.34 | 5.34 | 10000.0 |
| 2006-08-11 | AACQW-DELISTED | Stock | 0.41 | 0.42 | 0.41 | 0.42 | 4500.0 |
| 2006-08-11 | AAI-DELISTED | Stock | 11.67 | 11.88 | 10.78 | 10.92 | 2177900.0 |
| 2006-08-11 | AAIC-DELISTED | Stock | 177.2 | 177.8 | 173.8 | 174.6 | 1068800.0 |
| 2006-08-11 | AAME | Stock | 2.75 | 2.75 | 2.72 | 2.72 | 5100.0 |
| 2006-08-11 | AAON | Stock | 2.9695 | 2.9761 | 2.9063 | 2.9156 | 212625.0 |
| 2006-08-11 | AAP | Stock | 28.9 | 29.18 | 28.6 | 28.94 | 2124200.0 |
| 2006-08-11 | AATI-DELISTED | Stock | 8.86 | 8.86 | 8.61 | 8.7 | 65871.0 |
| 2006-08-11 | AAU-DELISTED | Stock | 2.6 | 2.75 | 2.5 | 2.6999 | 87700.0 |
| 2006-08-11 | AAUAF-DELISTED | Stock | 2.6 | 2.75 | 2.5 | 2.6999 | 87700.0 |
| 2006-08-11 | AAV-DELISTED | Stock | 16.19 | 16.42 | 16.15 | 16.34 | 438400.0 |
| 2006-08-11 | AAWW-DELISTED | Stock | 35.99 | 38.4 | 35.87 | 37.67 | 155584.0 |
| 2006-08-11 | AAXN-DELISTED | Stock | 6.94000005722046 | 7.03000020980835 | 6.86999988555908 | 6.90000009536743 | 463900.0 |
| 2006-08-11 | AB | Stock | 66.0 | 67.02 | 65.74 | 66.49 | 147900.0 |
| 2006-08-11 | ABAX-DELISTED | Stock | 21.79 | 22.04 | 21.26 | 21.48 | 109317.0 |
| 2006-08-11 | ABB-DELISTED | Stock | 12.85 | 12.9 | 12.68 | 12.72 | 2345100.0 |
| 2006-08-11 | ABBC-DELISTED | Stock | 14.65 | 14.72 | 14.65 | 14.65 | 2248.0 |
| 2006-08-11 | ABC-DELISTED | Stock | 21.57 | 21.68 | 21.46 | 21.64 | 1997800.0 |
| 2006-08-11 | ABCB | Stock | 25.3178 | 25.8042 | 25.0456 | 25.1136 | 11618.0 |
| 2006-08-11 | ABCO-DELISTED | Stock | 24.09 | 24.29 | 23.79 | 23.95 | 222896.0 |
| 2006-08-11 | ABCW-DELISTED | Stock | 28.38 | 28.77 | 28.16 | 28.41 | 46820.0 |
| 2006-08-11 | ABD-DELISTED | Stock | 18.335 | 18.345 | 18.185 | 18.265 | 126100.0 |
| 2006-08-11 | ABE-DELISTED | Stock | 12.9 | 12.99 | 12.9 | 12.95 | 14400.0 |
| 2006-08-11 | ABFS-DELISTED | Stock | 42.88 | 43.16 | 41.53 | 41.76 | 416610.0 |
| 2006-08-11 | ABG | Stock | 19.91 | 20.01 | 19.73 | 19.87 | 67700.0 |
| 2006-08-11 | ABK-DELISTED | Stock | 82.9 | 83.21 | 82.67 | 82.99 | 659100.0 |
| 2006-08-11 | ABM | Stock | 16.38 | 16.42 | 16.25 | 16.34 | 69200.0 |
| 2006-08-11 | ABMD-DELISTED | Stock | 13.06 | 13.18 | 12.94 | 12.94 | 47379.0 |
| 2006-08-11 | ABP-DELISTED | Stock | 3.89 | 4.04 | 3.76 | 4.03 | 378900.0 |
| 2006-08-11 | ABR | Stock | 24.67 | 24.85 | 24.11 | 24.41 | 55900.0 |
| 2006-08-11 | ABT | Stock | 22.7905 | 22.8817 | 22.5698 | 22.7473 | 5203627.0 |
| 2006-08-11 | ABTL-DELISTED | Stock | 15.375 | 15.375 | 14.925 | 14.925 | 23664.0 |
| 2006-08-11 | ABV-DELISTED | Stock | 41.16 | 41.43 | 40.69 | 40.91 | 412700.0 |
| 2006-08-11 | ABVA-DELISTED | Stock | 16.65 | 16.7 | 16.239 | 16.7 | 1700.0 |
| 2006-08-11 | ABX-DELISTED | Stock | 32.06 | 32.21 | 31.15 | 31.16 | 3652954.0 |
| 2006-08-11 | ACAD | Stock | 5.27 | 5.47 | 5.26 | 5.39 | 152700.0 |
| 2006-08-11 | ACAP-DELISTED | Stock | 46.78 | 47.49 | 46.74 | 46.9 | 28876.0 |
| 2006-08-11 | ACAS-DELISTED | Stock | 37.06 | 37.26 | 36.83 | 37.23 | 867507.0 |
| 2006-08-11 | ACAT-DELISTED | Stock | 18.005 | 18.26 | 17.66 | 18.23 | 53624.0 |
| 2006-08-11 | ACC-DELISTED | Stock | 25.08 | 25.11 | 24.68 | 24.72 | 108300.0 |
| 2006-08-11 | ACCL-DELISTED | Stock | 6.31 | 6.31 | 6.18 | 6.26 | 9245.0 |
| 2006-08-11 | ACCO | Stock | 18.35 | 18.36 | 18.2 | 18.25 | 137400.0 |
> showing 50 of 4,425 rows — these rows as CSV