PREVIEW / stock_daily / 2005-02-17
file: by_date/stock_daily/2005/2005-02-17.parquet size: 135 KB rows: 4,019 symbols: 2,523
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-02-17 | AAPL | Stock | 1.6188 | 1.6229 | 1.5616 | 1.568 | 1518473600.0 |
| 2005-02-17 | MSFT | Stock | 25.71 | 25.86 | 25.6 | 25.65 | 67024800.0 |
| 2005-02-17 | NVDA | Stock | 0.2174 | 0.2175 | 0.2109 | 0.2126 | 1017408000.0 |
| 2005-02-17 | AMZN | Stock | 1.787 | 1.7925 | 1.7625 | 1.7845 | 105962000.0 |
| 2005-02-17 | CL | Stock | 27.0 | 27.12 | 26.795 | 26.96 | 4638000.0 |
| 2005-02-17 | A | Stock | 17.0029 | 17.2818 | 16.917 | 16.9528 | 3459351.0 |
| 2005-02-17 | AABA-DELISTED | Stock | 34.4199981689453 | 34.7900009155273 | 33.7599983215332 | 33.8199996948242 | 16203500.0 |
| 2005-02-17 | AACC-DELISTED | Stock | 20.59 | 20.59 | 19.66 | 19.87 | 26887.0 |
| 2005-02-17 | AAI-DELISTED | Stock | 8.19 | 8.34 | 8.08 | 8.1 | 700900.0 |
| 2005-02-17 | AAIC-DELISTED | Stock | 388.0 | 393.8 | 387.0 | 390.4 | 1346900.0 |
| 2005-02-17 | AAME | Stock | 3.0 | 3.06 | 2.99 | 3.06 | 7800.0 |
| 2005-02-17 | AAON | Stock | 2.0122 | 2.0438 | 1.9371 | 1.9661 | 157950.0 |
| 2005-02-17 | AAP | Stock | 32.9333 | 34.64 | 32.5067 | 34.5333 | 6045150.0 |
| 2005-02-17 | AAV-DELISTED | Stock | 17.28 | 17.35 | 17.14 | 17.28 | 72100.0 |
| 2005-02-17 | AAXN-DELISTED | Stock | 14.8199996948242 | 14.8699998855591 | 14.1000003814697 | 14.3800001144409 | 4576400.0 |
| 2005-02-17 | ABAX-DELISTED | Stock | 13.26 | 13.31 | 13.11 | 13.16 | 90732.0 |
| 2005-02-17 | ABB-DELISTED | Stock | 5.89 | 6.0 | 5.87 | 5.91 | 1162300.0 |
| 2005-02-17 | ABBC-DELISTED | Stock | 13.37 | 13.45 | 13.3 | 13.44 | 26994.0 |
| 2005-02-17 | ABC-DELISTED | Stock | 15.26 | 15.33 | 14.94 | 14.95 | 9033200.0 |
| 2005-02-17 | ABCB | Stock | 16.6079 | 17.3049 | 16.3404 | 16.7457 | 36273.0 |
| 2005-02-17 | ABCO-DELISTED | Stock | 19.945 | 20.12 | 19.815 | 20.01 | 274522.0 |
| 2005-02-17 | ABCW-DELISTED | Stock | 27.8 | 27.8 | 27.15 | 27.3 | 26400.0 |
| 2005-02-17 | ABE-DELISTED | Stock | 10.03 | 10.07 | 9.98 | 10.0 | 18000.0 |
| 2005-02-17 | ABFS-DELISTED | Stock | 41.15 | 41.35 | 40.45 | 41.05 | 280846.0 |
| 2005-02-17 | ABG | Stock | 16.2 | 16.65 | 16.12 | 16.48 | 45300.0 |
| 2005-02-17 | ABK-DELISTED | Stock | 77.55 | 77.79 | 77.23 | 77.46 | 983700.0 |
| 2005-02-17 | ABM | Stock | 18.6 | 18.65 | 18.35 | 18.4 | 145800.0 |
| 2005-02-17 | ABMD-DELISTED | Stock | 10.42 | 10.42 | 10.0 | 10.0 | 81141.0 |
| 2005-02-17 | ABP-DELISTED | Stock | 2.03 | 2.21 | 2.03 | 2.08 | 286500.0 |
| 2005-02-17 | ABR | Stock | 25.56 | 25.82 | 25.5 | 25.61 | 39300.0 |
| 2005-02-17 | ABT | Stock | 22.469 | 22.4738 | 22.2099 | 22.3395 | 5633389.0 |
| 2005-02-17 | ABTL-DELISTED | Stock | 25.75 | 26.25 | 25.65 | 25.8 | 57800.0 |
| 2005-02-17 | ABV-DELISTED | Stock | 29.19 | 29.28 | 29.01 | 29.12 | 696900.0 |
| 2005-02-17 | ABVA-DELISTED | Stock | 16.65 | 16.91 | 16.5 | 16.9 | 7765.0 |
| 2005-02-17 | ABVT-DELISTED | Stock | 29.0 | 33.0 | 29.0 | 33.0 | 400.0 |
| 2005-02-17 | ABX-DELISTED | Stock | 23.22 | 24.05 | 23.22 | 23.99 | 2590300.0 |
| 2005-02-17 | ACAD | Stock | 8.03 | 8.13 | 8.0 | 8.05 | 2000.0 |
| 2005-02-17 | ACAP-DELISTED | Stock | 35.89 | 36.5 | 35.65 | 36.15 | 60843.0 |
| 2005-02-17 | ACAS-DELISTED | Stock | 35.5 | 35.7 | 34.9 | 35.03 | 1248510.0 |
| 2005-02-17 | ACAT-DELISTED | Stock | 28.24 | 28.26 | 27.59 | 27.88 | 58356.0 |
| 2005-02-17 | ACC-DELISTED | Stock | 21.5 | 21.6 | 21.46 | 21.54 | 20500.0 |
| 2005-02-17 | ACCL-DELISTED | Stock | 5.59 | 5.61 | 5.4 | 5.41 | 154503.0 |
| 2005-02-17 | ACE-DELISTED | Stock | 45.91 | 45.91 | 45.26 | 45.27 | 1353395.0 |
| 2005-02-17 | ACF-DELISTED | Stock | 25.0 | 25.0 | 24.47 | 24.55 | 621300.0 |
| 2005-02-17 | ACFC-DELISTED | Stock | 69.39 | 69.59 | 67.86 | 67.86 | 1409.0 |
| 2005-02-17 | ACG-DELISTED | Stock | 8.38 | 8.4 | 8.36 | 8.38 | 397200.0 |
| 2005-02-17 | ACGL | Stock | 4.6122 | 4.6256 | 4.5322 | 4.5411 | 977400.0 |
| 2005-02-17 | ACGN-DELISTED | Stock | 736.6712 | 736.6712 | 680.0 | 702.6712 | 104400.0 |
| 2005-02-17 | ACH | Stock | 18.5333 | 18.6067 | 18.1333 | 18.1667 | 402750.0 |
| 2005-02-17 | ACH-DELISTED | Stock | 15.25 | 15.36 | 15.121 | 15.3 | 145600.0 |
> showing 50 of 4,019 rows — these rows as CSV