PREVIEW / stock_daily / 2005-10-18
file: by_date/stock_daily/2005/2005-10-18.parquet size: 140 KB rows: 4,193 symbols: 2,637
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-10-18 | AAPL | Stock | 1.9018 | 1.9268 | 1.8643 | 1.8646 | 609588000.0 |
| 2005-10-18 | MSFT | Stock | 24.49 | 24.83 | 24.45 | 24.57 | 69328200.0 |
| 2005-10-18 | NVDA | Stock | 0.2705 | 0.271 | 0.2633 | 0.2651 | 299832000.0 |
| 2005-10-18 | AMZN | Stock | 2.246 | 2.2525 | 2.215 | 2.2325 | 89154000.0 |
| 2005-10-18 | CL | Stock | 26.0 | 26.2 | 25.875 | 26.055 | 2886200.0 |
| 2005-10-18 | A | Stock | 21.9957 | 22.0601 | 21.7597 | 21.9242 | 3007657.0 |
| 2005-10-18 | AABA-DELISTED | Stock | 34.4000015258789 | 34.7599983215332 | 33.6399993896484 | 33.7000007629395 | 35010300.0 |
| 2005-10-18 | AACC-DELISTED | Stock | 27.0 | 27.23 | 26.07 | 26.4 | 187684.0 |
| 2005-10-18 | AAI-DELISTED | Stock | 13.71 | 14.06 | 13.68 | 13.94 | 2898000.0 |
| 2005-10-18 | AAIC-DELISTED | Stock | 187.2 | 188.6 | 182.0 | 183.4 | 1982300.0 |
| 2005-10-18 | AAME | Stock | 2.81 | 2.81 | 2.61 | 2.78 | 1500.0 |
| 2005-10-18 | AAON | Stock | 2.2387 | 2.2413 | 2.2123 | 2.2176 | 94922.0 |
| 2005-10-18 | AAP | Stock | 37.16 | 37.25 | 36.4 | 36.87 | 736900.0 |
| 2005-10-18 | AATI-DELISTED | Stock | 11.04 | 11.36 | 11.04 | 11.31 | 83254.0 |
| 2005-10-18 | AAV-DELISTED | Stock | 17.1 | 17.29 | 16.95 | 17.1 | 33900.0 |
| 2005-10-18 | AAXN-DELISTED | Stock | 6.0 | 6.0 | 5.65999984741211 | 5.69999980926514 | 1214000.0 |
| 2005-10-18 | ABAX-DELISTED | Stock | 13.63 | 13.94 | 13.53 | 13.79 | 75418.0 |
| 2005-10-18 | ABB-DELISTED | Stock | 7.14 | 7.2 | 7.12 | 7.12 | 656000.0 |
| 2005-10-18 | ABBC-DELISTED | Stock | 12.06 | 12.06 | 12.02 | 12.02 | 1700.0 |
| 2005-10-18 | ABC-DELISTED | Stock | 18.92 | 19.08 | 18.88 | 19.05 | 4407200.0 |
| 2005-10-18 | ABCB | Stock | 17.527 | 17.566 | 17.3714 | 17.42 | 11515.0 |
| 2005-10-18 | ABCO-DELISTED | Stock | 23.63 | 23.87 | 23.44 | 23.57 | 191363.0 |
| 2005-10-18 | ABCW-DELISTED | Stock | 30.02 | 30.22 | 29.68 | 29.7 | 130350.0 |
| 2005-10-18 | ABD-DELISTED | Stock | 24.32 | 24.65 | 24.23 | 24.4 | 346400.0 |
| 2005-10-18 | ABE-DELISTED | Stock | 10.72 | 10.9699 | 10.7 | 10.8 | 30300.0 |
| 2005-10-18 | ABFS-DELISTED | Stock | 33.24 | 33.94 | 32.91 | 33.27 | 205181.0 |
| 2005-10-18 | ABG | Stock | 16.69 | 16.74 | 16.08 | 16.4 | 75200.0 |
| 2005-10-18 | ABK-DELISTED | Stock | 69.76 | 69.76 | 68.62 | 69.0 | 619600.0 |
| 2005-10-18 | ABM | Stock | 19.7 | 19.74 | 19.3 | 19.5 | 114000.0 |
| 2005-10-18 | ABMD-DELISTED | Stock | 9.27 | 9.27 | 8.76 | 8.79 | 106798.0 |
| 2005-10-18 | ABP-DELISTED | Stock | 7.34 | 7.34 | 7.05 | 7.1 | 704400.0 |
| 2005-10-18 | ABR | Stock | 27.99 | 28.06 | 27.33 | 27.44 | 177000.0 |
| 2005-10-18 | ABT | Stock | 20.2955 | 20.5162 | 20.2716 | 20.3435 | 8982076.0 |
| 2005-10-18 | ABTL-DELISTED | Stock | 23.18 | 23.18 | 22.43 | 22.57 | 48148.0 |
| 2005-10-18 | ABV-DELISTED | Stock | 35.25 | 35.31 | 34.17 | 34.28 | 475100.0 |
| 2005-10-18 | ABVA-DELISTED | Stock | 16.5 | 16.85 | 16.5 | 16.85 | 2413.0 |
| 2005-10-18 | ABX-DELISTED | Stock | 26.77 | 27.0 | 26.41 | 26.51 | 1742853.0 |
| 2005-10-18 | ACAD | Stock | 11.49 | 11.49 | 10.78 | 11.18 | 40900.0 |
| 2005-10-18 | ACAP-DELISTED | Stock | 43.53 | 43.68 | 42.44 | 43.19 | 44107.0 |
| 2005-10-18 | ACAS-DELISTED | Stock | 36.27 | 36.8 | 36.11 | 36.33 | 456381.0 |
| 2005-10-18 | ACAT-DELISTED | Stock | 19.01 | 19.01 | 18.42 | 18.42 | 173728.0 |
| 2005-10-18 | ACC-DELISTED | Stock | 23.53 | 23.58 | 23.1 | 23.12 | 41101.0 |
| 2005-10-18 | ACCL-DELISTED | Stock | 6.73 | 6.77 | 6.48 | 6.62 | 37607.0 |
| 2005-10-18 | ACCO | Stock | 24.32 | 24.65 | 24.23 | 24.4 | 374900.0 |
| 2005-10-18 | ACE-DELISTED | Stock | 49.8 | 50.2 | 49.52 | 50.05 | 3223700.0 |
| 2005-10-18 | ACF-DELISTED | Stock | 22.88 | 22.95 | 22.58 | 22.67 | 1418400.0 |
| 2005-10-18 | ACFC-DELISTED | Stock | 70.31 | 70.31 | 69.9 | 69.95 | 188.0 |
| 2005-10-18 | ACG-DELISTED | Stock | 8.1 | 8.16 | 8.06 | 8.12 | 372700.0 |
| 2005-10-18 | ACGL | Stock | 5.2833 | 5.2833 | 5.1533 | 5.2189 | 551700.0 |
| 2005-10-18 | ACGN-DELISTED | Stock | 906.6712 | 940.6712 | 872.6712 | 884.0 | 826900.0 |
> showing 50 of 4,193 rows — these rows as CSV