PREVIEW / stock_daily / 2005-10-19
file: by_date/stock_daily/2005/2005-10-19.parquet size: 141 KB rows: 4,214 symbols: 2,655
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-19 | AAPL | Stock | 1.8596 | 1.9629 | 1.8289 | 1.9621 | 1008683200.0 |
| 2005-10-19 | MSFT | Stock | 24.56 | 25.09 | 24.5 | 25.09 | 66574500.0 |
| 2005-10-19 | NVDA | Stock | 0.2617 | 0.2632 | 0.2542 | 0.2628 | 635952000.0 |
| 2005-10-19 | AMZN | Stock | 2.227 | 2.293 | 2.214 | 2.293 | 130570000.0 |
| 2005-10-19 | CL | Stock | 25.88 | 26.34 | 25.85 | 26.34 | 3405600.0 |
| 2005-10-19 | A | Stock | 21.9242 | 22.4535 | 21.7454 | 22.3033 | 5289613.0 |
| 2005-10-19 | AABA-DELISTED | Stock | 34.6199989318848 | 35.939998626709 | 34.5900001525879 | 35.9099998474121 | 63254000.0 |
| 2005-10-19 | AACC-DELISTED | Stock | 26.27 | 26.39 | 24.87 | 25.48 | 447076.0 |
| 2005-10-19 | AACQ-DELISTED | Stock | 5.11 | 5.11 | 5.11 | 5.11 | 1000.0 |
| 2005-10-19 | AAI-DELISTED | Stock | 13.9 | 14.12 | 13.59 | 14.08 | 2912500.0 |
| 2005-10-19 | AAIC-DELISTED | Stock | 184.0 | 187.0 | 180.0 | 186.6 | 1911400.0 |
| 2005-10-19 | AAME | Stock | 2.65 | 2.68 | 2.65 | 2.68 | 1200.0 |
| 2005-10-19 | AAON | Stock | 2.2123 | 2.236 | 2.1202 | 2.2347 | 315900.0 |
| 2005-10-19 | AAP | Stock | 36.87 | 37.6 | 36.35 | 37.57 | 842700.0 |
| 2005-10-19 | AATI-DELISTED | Stock | 11.19 | 11.4 | 11.19 | 11.34 | 342969.0 |
| 2005-10-19 | AAV-DELISTED | Stock | 17.09 | 17.1 | 16.27 | 17.09 | 52600.0 |
| 2005-10-19 | AAXN-DELISTED | Stock | 5.78000020980835 | 5.78000020980835 | 5.5 | 5.57999992370605 | 1464800.0 |
| 2005-10-19 | ABAX-DELISTED | Stock | 13.69 | 14.21 | 13.43 | 14.1799 | 278818.0 |
| 2005-10-19 | ABB-DELISTED | Stock | 7.01 | 7.11 | 6.92 | 7.1 | 881700.0 |
| 2005-10-19 | ABBC-DELISTED | Stock | 12.03 | 12.05 | 12.02 | 12.03 | 6100.0 |
| 2005-10-19 | ABC-DELISTED | Stock | 18.92 | 19.1 | 18.82 | 19.04 | 2750400.0 |
| 2005-10-19 | ABCB | Stock | 17.3519 | 17.7021 | 17.0893 | 17.7021 | 11823.0 |
| 2005-10-19 | ABCO-DELISTED | Stock | 23.47 | 24.38 | 23.2 | 24.35 | 164483.0 |
| 2005-10-19 | ABCW-DELISTED | Stock | 29.56 | 30.72 | 29.43 | 30.65 | 71410.0 |
| 2005-10-19 | ABD-DELISTED | Stock | 24.24 | 24.38 | 23.94 | 24.3 | 293780.0 |
| 2005-10-19 | ABE-DELISTED | Stock | 10.7 | 10.75 | 10.3501 | 10.71 | 43900.0 |
| 2005-10-19 | ABFS-DELISTED | Stock | 33.09 | 34.17 | 32.97 | 33.89 | 334746.0 |
| 2005-10-19 | ABG | Stock | 16.31 | 16.83 | 15.81 | 16.81 | 75700.0 |
| 2005-10-19 | ABK-DELISTED | Stock | 68.6 | 69.49 | 67.57 | 69.45 | 889200.0 |
| 2005-10-19 | ABM | Stock | 19.4 | 20.2 | 19.19 | 20.2 | 130400.0 |
| 2005-10-19 | ABMD-DELISTED | Stock | 8.76 | 8.77 | 8.35 | 8.62 | 125371.0 |
| 2005-10-19 | ABP-DELISTED | Stock | 7.09 | 7.12 | 6.7 | 7.08 | 1131200.0 |
| 2005-10-19 | ABR | Stock | 27.44 | 27.73 | 27.12 | 27.68 | 192200.0 |
| 2005-10-19 | ABT | Stock | 20.2716 | 21.1592 | 20.1756 | 21.0872 | 17332430.0 |
| 2005-10-19 | ABTL-DELISTED | Stock | 22.45 | 23.25 | 22.45 | 23.2 | 33408.0 |
| 2005-10-19 | ABV-DELISTED | Stock | 34.1 | 34.49 | 33.27 | 34.3 | 699100.0 |
| 2005-10-19 | ABVA-DELISTED | Stock | 16.6 | 16.78 | 16.6 | 16.61 | 1534.0 |
| 2005-10-19 | ABX-DELISTED | Stock | 26.1 | 26.27 | 25.74 | 26.12 | 3308996.0 |
| 2005-10-19 | ACAD | Stock | 11.04 | 11.47 | 10.89 | 11.47 | 67100.0 |
| 2005-10-19 | ACAP-DELISTED | Stock | 42.96 | 45.33 | 42.49 | 44.88 | 100437.0 |
| 2005-10-19 | ACAS-DELISTED | Stock | 36.37 | 37.1 | 35.91 | 37.08 | 444961.0 |
| 2005-10-19 | ACAT-DELISTED | Stock | 18.37 | 18.73 | 18.11 | 18.72 | 135632.0 |
| 2005-10-19 | ACC-DELISTED | Stock | 23.12 | 24.0 | 23.0 | 23.94 | 93372.0 |
| 2005-10-19 | ACCL-DELISTED | Stock | 6.52 | 6.5599 | 6.34 | 6.51 | 65426.0 |
| 2005-10-19 | ACCO | Stock | 24.25 | 24.4 | 23.95 | 24.29 | 293700.0 |
| 2005-10-19 | ACE-DELISTED | Stock | 50.04 | 50.19 | 49.31 | 49.74 | 2666800.0 |
| 2005-10-19 | ACF-DELISTED | Stock | 22.61 | 22.91 | 22.14 | 22.87 | 2339200.0 |
| 2005-10-19 | ACFC-DELISTED | Stock | 70.36 | 70.36 | 70.15 | 70.15 | 461.0 |
| 2005-10-19 | ACG-DELISTED | Stock | 8.15 | 8.2 | 8.12 | 8.17 | 307900.0 |
| 2005-10-19 | ACGL | Stock | 5.1933 | 5.2933 | 5.15 | 5.2633 | 902700.0 |
> showing 50 of 4,214 rows — these rows as CSV