PREVIEW / stock_daily / 2005-10-17
file: by_date/stock_daily/2005/2005-10-17.parquet size: 140 KB rows: 4,198 symbols: 2,643
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-17 | AAPL | Stock | 1.9279 | 1.9368 | 1.8814 | 1.9086 | 616834400.0 |
| 2005-10-17 | MSFT | Stock | 24.68 | 24.69 | 24.44 | 24.53 | 46924400.0 |
| 2005-10-17 | NVDA | Stock | 0.2671 | 0.2722 | 0.2671 | 0.2695 | 243912000.0 |
| 2005-10-17 | AMZN | Stock | 2.1815 | 2.251 | 2.181 | 2.251 | 104500000.0 |
| 2005-10-17 | CL | Stock | 26.08 | 26.225 | 25.91 | 26.195 | 4067400.0 |
| 2005-10-17 | A | Stock | 22.0529 | 22.1316 | 21.7811 | 22.0601 | 3112367.0 |
| 2005-10-17 | AABA-DELISTED | Stock | 33.8499984741211 | 34.2999992370605 | 33.7999992370605 | 34.1599998474121 | 21994600.0 |
| 2005-10-17 | AACC-DELISTED | Stock | 27.64 | 27.67 | 26.7395 | 26.99 | 150198.0 |
| 2005-10-17 | AACQ-DELISTED | Stock | 5.1 | 5.1 | 5.1 | 5.1 | 5000.0 |
| 2005-10-17 | AACQW-DELISTED | Stock | 0.5 | 0.51 | 0.5 | 0.51 | 82500.0 |
| 2005-10-17 | AAI-DELISTED | Stock | 13.57 | 13.89 | 13.37 | 13.63 | 1169300.0 |
| 2005-10-17 | AAIC-DELISTED | Stock | 185.0 | 190.4 | 184.4 | 187.2 | 1328400.0 |
| 2005-10-17 | AAME | Stock | 2.57 | 2.87 | 2.57 | 2.87 | 1800.0 |
| 2005-10-17 | AAON | Stock | 2.2413 | 2.2637 | 2.2387 | 2.2545 | 96441.0 |
| 2005-10-17 | AAP | Stock | 36.75 | 37.16 | 36.56 | 37.02 | 714200.0 |
| 2005-10-17 | AATI-DELISTED | Stock | 10.68 | 11.05 | 10.67 | 11.03 | 125349.0 |
| 2005-10-17 | AAV-DELISTED | Stock | 17.4 | 17.93 | 17.3 | 17.4 | 57300.0 |
| 2005-10-17 | AAXN-DELISTED | Stock | 5.69000005722046 | 6.05000019073486 | 5.61999988555908 | 5.94000005722046 | 3039000.0 |
| 2005-10-17 | ABAX-DELISTED | Stock | 13.57 | 13.75 | 13.45 | 13.73 | 80415.0 |
| 2005-10-17 | ABB-DELISTED | Stock | 7.23 | 7.27 | 7.19 | 7.19 | 666600.0 |
| 2005-10-17 | ABBC-DELISTED | Stock | 12.02 | 12.23 | 12.02 | 12.14 | 4100.0 |
| 2005-10-17 | ABC-DELISTED | Stock | 18.73 | 18.92 | 18.72 | 18.88 | 4309600.0 |
| 2005-10-17 | ABCB | Stock | 17.8188 | 17.9453 | 17.5172 | 17.6826 | 9356.0 |
| 2005-10-17 | ABCO-DELISTED | Stock | 24.11 | 24.3 | 23.74 | 23.78 | 160933.0 |
| 2005-10-17 | ABCW-DELISTED | Stock | 29.92 | 30.1 | 29.87 | 30.07 | 125510.0 |
| 2005-10-17 | ABD-DELISTED | Stock | 24.75 | 25.25 | 24.21 | 24.48 | 186000.0 |
| 2005-10-17 | ABE-DELISTED | Stock | 10.67 | 10.88 | 10.61 | 10.75 | 36100.0 |
| 2005-10-17 | ABFS-DELISTED | Stock | 33.43 | 33.95 | 33.38 | 33.72 | 169061.0 |
| 2005-10-17 | ABG | Stock | 16.91 | 16.95 | 16.59 | 16.84 | 59400.0 |
| 2005-10-17 | ABK-DELISTED | Stock | 69.6 | 70.25 | 69.34 | 69.72 | 327100.0 |
| 2005-10-17 | ABM | Stock | 19.6 | 19.62 | 19.17 | 19.56 | 103800.0 |
| 2005-10-17 | ABMD-DELISTED | Stock | 9.13 | 9.33 | 9.02 | 9.25 | 42131.0 |
| 2005-10-17 | ABP-DELISTED | Stock | 7.3 | 7.5 | 7.3 | 7.49 | 839000.0 |
| 2005-10-17 | ABR | Stock | 27.85 | 28.1 | 27.68 | 27.97 | 142800.0 |
| 2005-10-17 | ABT | Stock | 20.3435 | 20.4299 | 20.1756 | 20.4155 | 7698833.0 |
| 2005-10-17 | ABTL-DELISTED | Stock | 23.05 | 23.4 | 22.8 | 23.2 | 18957.0 |
| 2005-10-17 | ABV-DELISTED | Stock | 35.2 | 35.34 | 34.78 | 35.17 | 346100.0 |
| 2005-10-17 | ABVA-DELISTED | Stock | 16.49 | 16.8 | 16.45 | 16.5 | 26204.0 |
| 2005-10-17 | ABVT-DELISTED | Stock | 25.0 | 25.0 | 25.0 | 25.0 | 800.0 |
| 2005-10-17 | ABX-DELISTED | Stock | 27.6 | 27.65 | 27.07 | 27.15 | 2055300.0 |
| 2005-10-17 | ACAD | Stock | 11.49 | 11.49 | 11.3 | 11.41 | 127200.0 |
| 2005-10-17 | ACAP-DELISTED | Stock | 44.31 | 44.31 | 42.08 | 43.5 | 92306.0 |
| 2005-10-17 | ACAS-DELISTED | Stock | 35.67 | 36.36 | 35.66 | 36.23 | 529209.0 |
| 2005-10-17 | ACAT-DELISTED | Stock | 18.91 | 19.03 | 18.53 | 18.88 | 96204.0 |
| 2005-10-17 | ACC-DELISTED | Stock | 23.6 | 23.63 | 23.05 | 23.54 | 65000.0 |
| 2005-10-17 | ACCL-DELISTED | Stock | 6.6 | 6.79 | 6.6 | 6.77 | 34595.0 |
| 2005-10-17 | ACCO | Stock | 24.75 | 25.25 | 24.21 | 24.48 | 186600.0 |
| 2005-10-17 | ACE-DELISTED | Stock | 49.34 | 49.75 | 48.89 | 49.5 | 2475559.0 |
| 2005-10-17 | ACF-DELISTED | Stock | 22.88 | 23.1 | 22.63 | 22.88 | 1221600.0 |
| 2005-10-17 | ACFC-DELISTED | Stock | 69.64 | 70.36 | 69.64 | 70.15 | 2112.0 |
> showing 50 of 4,198 rows — these rows as CSV