PREVIEW / stock_daily / 2006-07-11
file: by_date/stock_daily/2006/2006-07-11.parquet size: 149 KB rows: 4,455 symbols: 2,813
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-11 | AAPL | Stock | 1.9682 | 1.9996 | 1.9475 | 1.9875 | 825022800.0 |
| 2006-07-11 | MSFT | Stock | 23.37 | 23.37 | 22.74 | 23.1 | 88676300.0 |
| 2006-07-11 | NVDA | Stock | 0.3078 | 0.3203 | 0.3033 | 0.3192 | 600582000.0 |
| 2006-07-11 | AMZN | Stock | 1.787 | 1.796 | 1.7505 | 1.783 | 121772000.0 |
| 2006-07-11 | CL | Stock | 30.75 | 30.88 | 30.605 | 30.82 | 1932800.0 |
| 2006-07-11 | A | Stock | 21.9242 | 21.9242 | 21.0086 | 21.588 | 7294205.0 |
| 2006-07-11 | AABA-DELISTED | Stock | 32.7900009155273 | 33.3499984741211 | 32.3199996948242 | 33.1699981689453 | 11285900.0 |
| 2006-07-11 | AACC-DELISTED | Stock | 19.49 | 19.8 | 19.19 | 19.75 | 147451.0 |
| 2006-07-11 | AACQ-DELISTED | Stock | 5.31 | 5.31 | 5.31 | 5.31 | 6000.0 |
| 2006-07-11 | AACQU-DELISTED | Stock | 6.18 | 6.18 | 6.18 | 6.18 | 3400.0 |
| 2006-07-11 | AACQW-DELISTED | Stock | 0.46 | 0.46 | 0.46 | 0.46 | 31000.0 |
| 2006-07-11 | AAI-DELISTED | Stock | 14.13 | 14.23 | 13.65 | 14.13 | 994500.0 |
| 2006-07-11 | AAIC-DELISTED | Stock | 215.8 | 215.8 | 208.0 | 214.0 | 1041700.0 |
| 2006-07-11 | AAME | Stock | 2.94 | 2.94 | 2.94 | 2.94 | 1000.0 |
| 2006-07-11 | AAON | Stock | 3.1565 | 3.2474 | 3.096 | 3.1658 | 192881.0 |
| 2006-07-11 | AAP | Stock | 29.5 | 29.57 | 29.15 | 29.29 | 1589200.0 |
| 2006-07-11 | AATI-DELISTED | Stock | 9.0 | 9.24 | 8.96 | 9.22 | 115003.0 |
| 2006-07-11 | AAU-DELISTED | Stock | 2.44 | 2.51 | 2.4 | 2.49 | 62300.0 |
| 2006-07-11 | AAUAF-DELISTED | Stock | 2.44 | 2.51 | 2.4 | 2.49 | 62300.0 |
| 2006-07-11 | AAV-DELISTED | Stock | 15.46 | 15.51 | 15.33 | 15.485 | 1702200.0 |
| 2006-07-11 | AAWW-DELISTED | Stock | 47.73 | 49.02 | 46.52 | 47.0 | 144278.0 |
| 2006-07-11 | AAXN-DELISTED | Stock | 8.19999980926514 | 8.82999992370605 | 7.90999984741211 | 8.56999969482422 | 1698400.0 |
| 2006-07-11 | AB | Stock | 60.9 | 60.9 | 59.01 | 59.4 | 310100.0 |
| 2006-07-11 | ABAX-DELISTED | Stock | 21.34 | 21.35 | 20.32 | 20.89 | 383580.0 |
| 2006-07-11 | ABB-DELISTED | Stock | 12.36 | 12.58 | 12.36 | 12.53 | 1827200.0 |
| 2006-07-11 | ABBC-DELISTED | Stock | 14.29 | 15.05 | 14.26 | 14.72 | 19482.0 |
| 2006-07-11 | ABC-DELISTED | Stock | 20.94 | 21.1 | 20.84 | 20.9 | 1667800.0 |
| 2006-07-11 | ABCB | Stock | 22.1276 | 22.4291 | 21.4565 | 22.4291 | 36910.0 |
| 2006-07-11 | ABCO-DELISTED | Stock | 23.41 | 24.07 | 23.17 | 23.95 | 161483.0 |
| 2006-07-11 | ABCW-DELISTED | Stock | 29.65 | 30.44 | 29.2 | 30.28 | 53550.0 |
| 2006-07-11 | ABD-DELISTED | Stock | 20.94 | 21.0 | 20.58 | 20.85 | 338200.0 |
| 2006-07-11 | ABE-DELISTED | Stock | 12.25 | 12.3699 | 12.25 | 12.36 | 4600.0 |
| 2006-07-11 | ABFS-DELISTED | Stock | 47.84 | 48.2 | 47.28 | 48.08 | 417697.0 |
| 2006-07-11 | ABG | Stock | 21.05 | 21.05 | 20.73 | 20.84 | 151800.0 |
| 2006-07-11 | ABK-DELISTED | Stock | 82.7 | 83.49 | 82.4 | 83.38 | 640800.0 |
| 2006-07-11 | ABM | Stock | 16.61 | 16.88 | 16.47 | 16.86 | 201300.0 |
| 2006-07-11 | ABMD-DELISTED | Stock | 13.51 | 13.8 | 13.15 | 13.63 | 156395.0 |
| 2006-07-11 | ABP-DELISTED | Stock | 4.47 | 4.59 | 4.41 | 4.5 | 110500.0 |
| 2006-07-11 | ABR | Stock | 25.13 | 25.35 | 24.94 | 25.12 | 76000.0 |
| 2006-07-11 | ABT | Stock | 20.9817 | 21.4423 | 20.9097 | 21.3799 | 12095456.0 |
| 2006-07-11 | ABTL-DELISTED | Stock | 16.024 | 17.276 | 16.024 | 17.026 | 87212.0 |
| 2006-07-11 | ABV-DELISTED | Stock | 40.75 | 41.34 | 40.53 | 41.22 | 336100.0 |
| 2006-07-11 | ABVA-DELISTED | Stock | 16.52 | 16.52 | 16.4 | 16.4 | 8971.0 |
| 2006-07-11 | ABVT-DELISTED | Stock | 48.5 | 48.5 | 48.5 | 48.5 | 300.0 |
| 2006-07-11 | ABX-DELISTED | Stock | 30.25 | 30.69 | 30.01 | 30.55 | 3375200.0 |
| 2006-07-11 | ACAD | Stock | 8.23 | 8.65 | 8.2 | 8.56 | 187900.0 |
| 2006-07-11 | ACAP-DELISTED | Stock | 50.44 | 50.79 | 49.35 | 50.78 | 25758.0 |
| 2006-07-11 | ACAS-DELISTED | Stock | 33.94 | 34.07 | 33.69 | 34.0 | 703947.0 |
| 2006-07-11 | ACAT-DELISTED | Stock | 18.51 | 18.51 | 17.5 | 18.11 | 66842.0 |
| 2006-07-11 | ACC-DELISTED | Stock | 25.25 | 26.02 | 25.11 | 26.0 | 51500.0 |
> showing 50 of 4,455 rows — these rows as CSV