PREVIEW / stock_daily / 2005-04-18
file: by_date/stock_daily/2005/2005-04-18.parquet size: 135 KB rows: 4,056 symbols: 2,542
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 |
|---|---|---|---|---|---|---|---|
| 2005-04-18 | AAPL | Stock | 1.25 | 1.2964 | 1.2143 | 1.2721 | 1327177600.0 |
| 2005-04-18 | MSFT | Stock | 24.45 | 24.84 | 24.4 | 24.65 | 75766400.0 |
| 2005-04-18 | NVDA | Stock | 0.1768 | 0.1807 | 0.1758 | 0.1767 | 473100000.0 |
| 2005-04-18 | AMZN | Stock | 1.645 | 1.679 | 1.642 | 1.65 | 138340000.0 |
| 2005-04-18 | CL | Stock | 26.36 | 26.45 | 26.0 | 26.18 | 3755600.0 |
| 2005-04-18 | A | Stock | 14.5708 | 14.8712 | 14.5708 | 14.7854 | 3426917.0 |
| 2005-04-18 | AABA-DELISTED | Stock | 32.4300003051758 | 33.0900001525879 | 32.4000015258789 | 32.5499992370605 | 19201200.0 |
| 2005-04-18 | AACC-DELISTED | Stock | 19.44 | 20.3 | 19.21 | 20.2 | 466058.0 |
| 2005-04-18 | AACQU-DELISTED | Stock | 6.15 | 6.15 | 6.15 | 6.15 | 600.0 |
| 2005-04-18 | AACQW-DELISTED | Stock | 0.59 | 0.59 | 0.59 | 0.59 | 5000.0 |
| 2005-04-18 | AAI-DELISTED | Stock | 8.89 | 9.06 | 8.7502 | 8.89 | 662800.0 |
| 2005-04-18 | AAIC-DELISTED | Stock | 271.8 | 280.4 | 271.8 | 279.0 | 1479000.0 |
| 2005-04-18 | AAME | Stock | 3.03 | 3.04 | 3.01 | 3.01 | 1200.0 |
| 2005-04-18 | AAON | Stock | 2.2716 | 2.2716 | 2.2084 | 2.2202 | 93403.0 |
| 2005-04-18 | AAP | Stock | 32.5 | 32.9 | 32.46 | 32.64 | 803700.0 |
| 2005-04-18 | AAV-DELISTED | Stock | 14.77 | 15.0 | 14.77 | 14.89 | 57900.0 |
| 2005-04-18 | AAXN-DELISTED | Stock | 8.13000011444092 | 8.34000015258789 | 7.90999984741211 | 7.96999979019165 | 3825000.0 |
| 2005-04-18 | ABAX-DELISTED | Stock | 8.05 | 8.15 | 7.61 | 7.71 | 74090.0 |
| 2005-04-18 | ABB-DELISTED | Stock | 6.15 | 6.21 | 6.14 | 6.19 | 945100.0 |
| 2005-04-18 | ABBC-DELISTED | Stock | 11.789 | 12.3 | 11.55 | 12.0 | 10247.0 |
| 2005-04-18 | ABC-DELISTED | Stock | 15.13 | 15.14 | 14.7 | 14.83 | 15295200.0 |
| 2005-04-18 | ABCB | Stock | 16.389 | 17.8479 | 16.3696 | 17.7604 | 39583.0 |
| 2005-04-18 | ABCO-DELISTED | Stock | 21.2 | 21.3 | 20.98 | 21.1 | 444129.0 |
| 2005-04-18 | ABCW-DELISTED | Stock | 26.85 | 27.3 | 26.68 | 27.18 | 51900.0 |
| 2005-04-18 | ABE-DELISTED | Stock | 9.19 | 9.26 | 9.15 | 9.15 | 29300.0 |
| 2005-04-18 | ABFS-DELISTED | Stock | 32.8 | 33.59 | 32.64 | 32.69 | 409371.0 |
| 2005-04-18 | ABG | Stock | 13.86 | 14.11 | 13.79 | 13.79 | 19500.0 |
| 2005-04-18 | ABK-DELISTED | Stock | 74.15 | 74.7 | 73.81 | 74.12 | 544300.0 |
| 2005-04-18 | ABM | Stock | 18.65 | 18.75 | 18.44 | 18.65 | 122100.0 |
| 2005-04-18 | ABMD-DELISTED | Stock | 10.87 | 10.99 | 10.501 | 10.92 | 44907.0 |
| 2005-04-18 | ABP-DELISTED | Stock | 2.72 | 2.73 | 2.55 | 2.58 | 147300.0 |
| 2005-04-18 | ABR | Stock | 25.35 | 26.1 | 25.35 | 25.99 | 181700.0 |
| 2005-04-18 | ABT | Stock | 23.7021 | 23.8413 | 23.2175 | 23.5006 | 14942059.0 |
| 2005-04-18 | ABTL-DELISTED | Stock | 24.25 | 24.65 | 23.3 | 23.4 | 34500.0 |
| 2005-04-18 | ABV-DELISTED | Stock | 27.08 | 27.25 | 26.88 | 27.03 | 452000.0 |
| 2005-04-18 | ABVA-DELISTED | Stock | 15.2 | 15.2 | 14.75 | 14.9 | 1710.0 |
| 2005-04-18 | ABX-DELISTED | Stock | 22.42 | 22.77 | 22.41 | 22.58 | 2128900.0 |
| 2005-04-18 | ACAD | Stock | 7.0 | 7.18 | 7.0 | 7.15 | 4800.0 |
| 2005-04-18 | ACAP-DELISTED | Stock | 33.28 | 33.83 | 32.72 | 33.03 | 35420.0 |
| 2005-04-18 | ACAS-DELISTED | Stock | 31.09 | 31.56 | 31.02 | 31.52 | 608913.0 |
| 2005-04-18 | ACAT-DELISTED | Stock | 23.86 | 24.61 | 23.46 | 24.28 | 157233.0 |
| 2005-04-18 | ACC-DELISTED | Stock | 19.205 | 19.645 | 19.205 | 19.645 | 10500.0 |
| 2005-04-18 | ACCL-DELISTED | Stock | 5.35 | 5.69 | 5.25 | 5.59 | 164501.0 |
| 2005-04-18 | ACE-DELISTED | Stock | 39.55 | 39.7 | 38.96 | 39.28 | 1046900.0 |
| 2005-04-18 | ACF-DELISTED | Stock | 22.83 | 23.16 | 22.5 | 22.87 | 1285300.0 |
| 2005-04-18 | ACFC-DELISTED | Stock | 57.09 | 57.14 | 56.68 | 57.04 | 2415.0 |
| 2005-04-18 | ACG-DELISTED | Stock | 8.09 | 8.15 | 8.08 | 8.1 | 312500.0 |
| 2005-04-18 | ACGL | Stock | 4.4778 | 4.5011 | 4.44 | 4.45 | 681300.0 |
| 2005-04-18 | ACGN-DELISTED | Stock | 736.6712 | 748.0 | 691.3288 | 702.6712 | 175400.0 |
| 2005-04-18 | ACH | Stock | 18.2867 | 18.2867 | 17.76 | 17.8067 | 369900.0 |
> showing 50 of 4,056 rows — these rows as CSV