PREVIEW / stock_daily / 2006-10-03
file: by_date/stock_daily/2006/2006-10-03.parquet size: 152 KB rows: 4,539 symbols: 2,873
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-10-03 | AAPL | Stock | 2.6589 | 2.6768 | 2.6139 | 2.6457 | 790708800.0 |
| 2006-10-03 | MSFT | Stock | 27.37 | 27.48 | 27.21 | 27.37 | 39386200.0 |
| 2006-10-03 | NVDA | Stock | 0.4717 | 0.4753 | 0.4612 | 0.4717 | 907692000.0 |
| 2006-10-03 | AMZN | Stock | 1.545 | 1.6 | 1.529 | 1.585 | 160680000.0 |
| 2006-10-03 | CL | Stock | 31.1 | 31.215 | 30.96 | 31.03 | 3125400.0 |
| 2006-10-03 | A | Stock | 22.9399 | 23.3047 | 22.9256 | 23.0615 | 3219734.0 |
| 2006-10-03 | AABA-DELISTED | Stock | 24.8099994659424 | 25.0 | 24.7000007629395 | 24.8400001525879 | 21148300.0 |
| 2006-10-03 | AACC-DELISTED | Stock | 16.25 | 16.91 | 16.25 | 16.62 | 177131.0 |
| 2006-10-03 | AACQ-DELISTED | Stock | 5.4 | 5.4 | 5.36 | 5.36 | 43400.0 |
| 2006-10-03 | AACQU-DELISTED | Stock | 6.2 | 6.2 | 6.12 | 6.15 | 23800.0 |
| 2006-10-03 | AACQW-DELISTED | Stock | 0.45 | 0.45 | 0.39 | 0.39 | 807200.0 |
| 2006-10-03 | AAI-DELISTED | Stock | 10.05 | 10.42 | 10.0 | 10.38 | 2211000.0 |
| 2006-10-03 | AAIC-DELISTED | Stock | 156.4 | 161.2 | 156.0 | 160.8 | 820500.0 |
| 2006-10-03 | AAME | Stock | 2.63 | 2.63 | 2.45 | 2.45 | 1100.0 |
| 2006-10-03 | AAON | Stock | 2.9959 | 3.0802 | 2.9919 | 3.0446 | 63787.0 |
| 2006-10-03 | AAP | Stock | 33.4 | 34.39 | 32.9 | 34.11 | 1946300.0 |
| 2006-10-03 | AATI-DELISTED | Stock | 5.15 | 5.15 | 5.0 | 5.04 | 392650.0 |
| 2006-10-03 | AAU-DELISTED | Stock | 2.29 | 2.4 | 2.24 | 2.35 | 126100.0 |
| 2006-10-03 | AAUAF-DELISTED | Stock | 2.29 | 2.4 | 2.24 | 2.35 | 126100.0 |
| 2006-10-03 | AAV-DELISTED | Stock | 11.51 | 11.93 | 11.3 | 11.35 | 1147800.0 |
| 2006-10-03 | AAWW-DELISTED | Stock | 43.879 | 44.12 | 43.27 | 43.94 | 171515.0 |
| 2006-10-03 | AAXN-DELISTED | Stock | 7.69999980926514 | 7.78999996185303 | 7.6100001335144 | 7.61999988555908 | 610500.0 |
| 2006-10-03 | AB | Stock | 68.75 | 68.98 | 68.27 | 68.69 | 237100.0 |
| 2006-10-03 | ABAX-DELISTED | Stock | 22.91 | 23.97 | 22.7 | 23.42 | 201203.0 |
| 2006-10-03 | ABB-DELISTED | Stock | 13.18 | 13.26 | 13.12 | 13.18 | 1662200.0 |
| 2006-10-03 | ABBC-DELISTED | Stock | 14.91 | 15.05 | 14.9 | 14.93 | 2700.0 |
| 2006-10-03 | ABC-DELISTED | Stock | 22.62 | 22.69 | 22.47 | 22.62 | 1415800.0 |
| 2006-10-03 | ABCB | Stock | 25.0164 | 26.5921 | 25.0164 | 26.4364 | 35882.0 |
| 2006-10-03 | ABCO-DELISTED | Stock | 25.26 | 25.68 | 25.15 | 25.63 | 193421.0 |
| 2006-10-03 | ABCW-DELISTED | Stock | 28.51 | 28.71 | 28.44 | 28.57 | 37940.0 |
| 2006-10-03 | ABD-DELISTED | Stock | 22.22 | 22.47 | 21.8 | 22.41 | 235500.0 |
| 2006-10-03 | ABE-DELISTED | Stock | 14.25 | 14.3399 | 14.1164 | 14.16 | 68500.0 |
| 2006-10-03 | ABFS-DELISTED | Stock | 42.41 | 44.07 | 42.16 | 43.62 | 574024.0 |
| 2006-10-03 | ABG | Stock | 20.74 | 21.07 | 20.6 | 21.05 | 548500.0 |
| 2006-10-03 | ABK-DELISTED | Stock | 83.0 | 83.88 | 82.93 | 83.58 | 522000.0 |
| 2006-10-03 | ABM | Stock | 18.71 | 19.01 | 18.67 | 18.9 | 166100.0 |
| 2006-10-03 | ABMD-DELISTED | Stock | 14.4 | 14.5 | 14.02 | 14.46 | 137864.0 |
| 2006-10-03 | ABP-DELISTED | Stock | 3.09 | 3.09 | 2.93 | 2.97 | 366000.0 |
| 2006-10-03 | ABR | Stock | 24.8 | 25.56 | 24.4 | 25.39 | 138000.0 |
| 2006-10-03 | ABT | Stock | 22.9104 | 22.9536 | 22.445 | 22.8433 | 15023551.0 |
| 2006-10-03 | ABTL-DELISTED | Stock | 14.525 | 14.826 | 14.375 | 14.525 | 6698.0 |
| 2006-10-03 | ABV-DELISTED | Stock | 46.0 | 46.3 | 45.621 | 46.0 | 478500.0 |
| 2006-10-03 | ABVA-DELISTED | Stock | 17.0 | 17.0 | 16.899 | 16.9 | 1792.0 |
| 2006-10-03 | ABX-DELISTED | Stock | 30.02 | 30.02 | 28.4 | 28.58 | 6059700.0 |
| 2006-10-03 | ACAD | Stock | 8.28 | 8.47 | 8.1 | 8.37 | 130700.0 |
| 2006-10-03 | ACAP-DELISTED | Stock | 48.98 | 50.45 | 48.81 | 49.67 | 29527.0 |
| 2006-10-03 | ACAS-DELISTED | Stock | 39.42 | 40.17 | 39.42 | 39.89 | 1263544.0 |
| 2006-10-03 | ACAT-DELISTED | Stock | 16.48 | 16.8 | 16.15 | 16.49 | 72699.0 |
| 2006-10-03 | ACC-DELISTED | Stock | 25.12 | 25.35 | 24.85 | 25.32 | 153089.0 |
| 2006-10-03 | ACCL-DELISTED | Stock | 6.01 | 6.13 | 5.99 | 6.13 | 55761.0 |
> showing 50 of 4,539 rows — these rows as CSV