PREVIEW / stock_daily / 2006-06-30
file: by_date/stock_daily/2006/2006-06-30.parquet size: 150 KB rows: 4,448 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-06-30 | AAPL | Stock | 2.0568 | 2.0625 | 2.0179 | 2.0454 | 739695600.0 |
| 2006-06-30 | MSFT | Stock | 23.54 | 23.65 | 23.3 | 23.3 | 73048800.0 |
| 2006-06-30 | NVDA | Stock | 0.3617 | 0.3673 | 0.3522 | 0.3548 | 468240000.0 |
| 2006-06-30 | AMZN | Stock | 1.929 | 1.942 | 1.8915 | 1.934 | 103824000.0 |
| 2006-06-30 | CL | Stock | 30.15 | 30.16 | 29.875 | 29.95 | 4765200.0 |
| 2006-06-30 | A | Stock | 22.5751 | 22.9685 | 22.5608 | 22.5751 | 5431789.0 |
| 2006-06-30 | AABA-DELISTED | Stock | 33.0099983215332 | 33.1199989318848 | 32.5400009155273 | 33.0 | 22566600.0 |
| 2006-06-30 | AACC-DELISTED | Stock | 19.95 | 19.97 | 19.66 | 19.76 | 713643.0 |
| 2006-06-30 | AACQ-DELISTED | Stock | 5.35 | 5.35 | 5.35 | 5.35 | 400.0 |
| 2006-06-30 | AACQW-DELISTED | Stock | 0.47 | 0.48 | 0.46 | 0.46 | 66500.0 |
| 2006-06-30 | AAI-DELISTED | Stock | 14.45 | 14.95 | 14.29 | 14.89 | 1277600.0 |
| 2006-06-30 | AAIC-DELISTED | Stock | 236.0 | 236.0 | 219.4 | 219.4 | 7268700.0 |
| 2006-06-30 | AAME | Stock | 2.98 | 2.98 | 2.98 | 2.98 | 100.0 |
| 2006-06-30 | AAON | Stock | 3.3514 | 3.4449 | 3.2935 | 3.3791 | 690272.0 |
| 2006-06-30 | AAP | Stock | 29.52 | 29.87 | 28.4 | 28.9 | 6435800.0 |
| 2006-06-30 | AATI-DELISTED | Stock | 10.45 | 10.99 | 10.23 | 10.47 | 1922101.0 |
| 2006-06-30 | AAU-DELISTED | Stock | 2.12 | 2.18 | 2.11 | 2.17 | 138300.0 |
| 2006-06-30 | AAUAF-DELISTED | Stock | 2.12 | 2.18 | 2.11 | 2.17 | 138300.0 |
| 2006-06-30 | AAV-DELISTED | Stock | 17.7 | 17.7226 | 17.35 | 17.45 | 443600.0 |
| 2006-06-30 | AAWW-DELISTED | Stock | 50.61 | 50.61 | 49.0 | 49.6 | 1429835.0 |
| 2006-06-30 | AAXN-DELISTED | Stock | 7.90999984741211 | 8.0 | 7.75 | 7.90999984741211 | 772500.0 |
| 2006-06-30 | AB | Stock | 61.2 | 61.3 | 60.25 | 61.14 | 158600.0 |
| 2006-06-30 | ABAX-DELISTED | Stock | 22.1 | 23.05 | 22.0 | 22.35 | 451567.0 |
| 2006-06-30 | ABB-DELISTED | Stock | 12.87 | 13.0 | 12.79 | 12.96 | 2078000.0 |
| 2006-06-30 | ABBC-DELISTED | Stock | 15.48 | 15.48 | 14.63 | 14.97 | 818992.0 |
| 2006-06-30 | ABC-DELISTED | Stock | 20.74 | 21.17 | 20.7 | 20.96 | 2938200.0 |
| 2006-06-30 | ABCB | Stock | 21.8261 | 22.5069 | 21.1744 | 22.5069 | 159875.0 |
| 2006-06-30 | ABCO-DELISTED | Stock | 24.28 | 24.67 | 23.85 | 24.0 | 313361.0 |
| 2006-06-30 | ABCW-DELISTED | Stock | 30.45 | 30.53 | 29.89 | 30.17 | 294080.0 |
| 2006-06-30 | ABD-DELISTED | Stock | 22.63 | 22.64 | 21.95 | 21.96 | 754310.0 |
| 2006-06-30 | ABE-DELISTED | Stock | 12.2 | 12.47 | 12.02 | 12.21 | 18300.0 |
| 2006-06-30 | ABFS-DELISTED | Stock | 49.65 | 50.32 | 49.5 | 50.2 | 501404.0 |
| 2006-06-30 | ABG | Stock | 20.89 | 20.96 | 20.66 | 20.94 | 148700.0 |
| 2006-06-30 | ABK-DELISTED | Stock | 80.78 | 81.15 | 80.4 | 81.01 | 692600.0 |
| 2006-06-30 | ABM | Stock | 17.42 | 17.44 | 16.97 | 17.1 | 488700.0 |
| 2006-06-30 | ABMD-DELISTED | Stock | 13.1 | 13.7 | 12.97 | 13.06 | 393737.0 |
| 2006-06-30 | ABP-DELISTED | Stock | 4.38 | 4.41 | 4.31 | 4.31 | 162500.0 |
| 2006-06-30 | ABR | Stock | 24.85 | 25.05 | 24.5 | 25.05 | 178500.0 |
| 2006-06-30 | ABT | Stock | 20.6314 | 20.9241 | 20.5114 | 20.9241 | 16660484.0 |
| 2006-06-30 | ABTL-DELISTED | Stock | 18.327 | 18.609 | 16.522 | 17.65 | 695793.0 |
| 2006-06-30 | ABV-DELISTED | Stock | 41.5 | 41.6 | 40.84 | 41.25 | 618800.0 |
| 2006-06-30 | ABVA-DELISTED | Stock | 16.43 | 16.5 | 16.4 | 16.5 | 4580.0 |
| 2006-06-30 | ABVT-DELISTED | Stock | 50.0 | 50.0 | 50.0 | 50.0 | 1000.0 |
| 2006-06-30 | ABX-DELISTED | Stock | 29.78 | 29.98 | 29.38 | 29.52 | 4011572.0 |
| 2006-06-30 | ACAD | Stock | 8.15 | 8.49 | 8.1 | 8.44 | 528200.0 |
| 2006-06-30 | ACAM-DELISTED | Stock | 6.34 | 6.34 | 6.0201 | 6.17 | 6450.0 |
| 2006-06-30 | ACAP-DELISTED | Stock | 49.5 | 52.36 | 48.97 | 51.59 | 170241.0 |
| 2006-06-30 | ACAS-DELISTED | Stock | 33.65 | 33.72 | 33.5 | 33.5 | 618487.0 |
| 2006-06-30 | ACAT-DELISTED | Stock | 19.74 | 19.74 | 18.96 | 19.51 | 171784.0 |
| 2006-06-30 | ACC-DELISTED | Stock | 24.47 | 25.11 | 24.4 | 24.89 | 300900.0 |
> showing 50 of 4,448 rows — these rows as CSV