PREVIEW / stock_daily / 2005-10-13
file: by_date/stock_daily/2005/2005-10-13.parquet size: 139 KB rows: 4,190 symbols: 2,632
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-13 | AAPL | Stock | 1.7657 | 1.9268 | 1.7596 | 1.9193 | 1865575600.0 |
| 2005-10-13 | MSFT | Stock | 24.31 | 24.73 | 24.27 | 24.59 | 70192000.0 |
| 2005-10-13 | NVDA | Stock | 0.2677 | 0.2682 | 0.2567 | 0.2669 | 509304000.0 |
| 2005-10-13 | AMZN | Stock | 2.1215 | 2.149 | 2.095 | 2.131 | 76656000.0 |
| 2005-10-13 | CL | Stock | 25.855 | 26.07 | 25.785 | 25.89 | 2980000.0 |
| 2005-10-13 | A | Stock | 21.6381 | 21.8813 | 21.5379 | 21.8741 | 3057286.0 |
| 2005-10-13 | AABA-DELISTED | Stock | 33.7999992370605 | 33.8499984741211 | 32.9700012207031 | 33.3699989318848 | 16254600.0 |
| 2005-10-13 | AACC-DELISTED | Stock | 29.07 | 29.07 | 27.18 | 27.54 | 184924.0 |
| 2005-10-13 | AACQW-DELISTED | Stock | 0.51 | 0.51 | 0.51 | 0.51 | 2500.0 |
| 2005-10-13 | AAI-DELISTED | Stock | 12.92 | 13.37 | 12.7 | 13.35 | 1501500.0 |
| 2005-10-13 | AAIC-DELISTED | Stock | 172.0 | 184.0 | 171.4 | 181.4 | 3298300.0 |
| 2005-10-13 | AAME | Stock | 2.59 | 2.77 | 2.55 | 2.63 | 10500.0 |
| 2005-10-13 | AAON | Stock | 2.2887 | 2.294 | 2.2545 | 2.269 | 171619.0 |
| 2005-10-13 | AAP | Stock | 37.23 | 37.24 | 36.6 | 36.95 | 1024200.0 |
| 2005-10-13 | AATI-DELISTED | Stock | 10.4 | 10.5 | 10.01 | 10.13 | 119293.0 |
| 2005-10-13 | AAV-DELISTED | Stock | 17.18 | 17.32 | 16.73 | 17.18 | 68000.0 |
| 2005-10-13 | AAXN-DELISTED | Stock | 5.67999982833862 | 5.67999982833862 | 5.40999984741211 | 5.51000022888184 | 1096900.0 |
| 2005-10-13 | ABAX-DELISTED | Stock | 13.23 | 13.62 | 13.2 | 13.44 | 72734.0 |
| 2005-10-13 | ABB-DELISTED | Stock | 7.25 | 7.28 | 7.15 | 7.28 | 832300.0 |
| 2005-10-13 | ABBC-DELISTED | Stock | 12.5 | 12.5 | 12.08 | 12.08 | 6668.0 |
| 2005-10-13 | ABC-DELISTED | Stock | 18.6 | 18.79 | 18.6 | 18.73 | 2711200.0 |
| 2005-10-13 | ABCB | Stock | 17.5757 | 17.9064 | 17.3811 | 17.9064 | 9767.0 |
| 2005-10-13 | ABCO-DELISTED | Stock | 23.54 | 24.09 | 22.7 | 23.87 | 279525.0 |
| 2005-10-13 | ABCW-DELISTED | Stock | 29.15 | 29.65 | 28.96 | 29.6 | 136310.0 |
| 2005-10-13 | ABD-DELISTED | Stock | 26.07 | 26.2 | 25.5 | 25.84 | 221480.0 |
| 2005-10-13 | ABE-DELISTED | Stock | 10.65 | 10.7 | 10.56 | 10.67 | 27100.0 |
| 2005-10-13 | ABFS-DELISTED | Stock | 32.9 | 33.35 | 32.36 | 33.07 | 261690.0 |
| 2005-10-13 | ABG | Stock | 16.62 | 17.0 | 16.47 | 16.6 | 78200.0 |
| 2005-10-13 | ABK-DELISTED | Stock | 68.97 | 69.65 | 68.9 | 69.26 | 500400.0 |
| 2005-10-13 | ABM | Stock | 19.35 | 19.71 | 19.2 | 19.52 | 136400.0 |
| 2005-10-13 | ABMD-DELISTED | Stock | 9.05 | 9.19 | 8.81 | 9.12 | 73187.0 |
| 2005-10-13 | ABP-DELISTED | Stock | 7.3 | 7.3 | 6.68 | 6.98 | 1214300.0 |
| 2005-10-13 | ABR | Stock | 27.44 | 27.53 | 26.76 | 27.1 | 126600.0 |
| 2005-10-13 | ABT | Stock | 20.0652 | 20.545 | 20.0652 | 20.4251 | 12476240.0 |
| 2005-10-13 | ABTL-DELISTED | Stock | 22.93 | 23.72 | 22.83 | 23.27 | 40536.0 |
| 2005-10-13 | ABV-DELISTED | Stock | 35.6 | 36.03 | 35.13 | 35.95 | 352000.0 |
| 2005-10-13 | ABVA-DELISTED | Stock | 16.54 | 16.54 | 16.45 | 16.45 | 400.0 |
| 2005-10-13 | ABVT-DELISTED | Stock | 25.0 | 25.0 | 25.0 | 25.0 | 400.0 |
| 2005-10-13 | ABX-DELISTED | Stock | 27.4 | 27.41 | 26.7 | 27.27 | 2960100.0 |
| 2005-10-13 | ACAD | Stock | 10.83 | 11.05 | 10.67 | 10.98 | 83100.0 |
| 2005-10-13 | ACAP-DELISTED | Stock | 43.5 | 43.92 | 42.84 | 43.68 | 52575.0 |
| 2005-10-13 | ACAS-DELISTED | Stock | 35.04 | 35.43 | 34.65 | 35.27 | 624899.0 |
| 2005-10-13 | ACAT-DELISTED | Stock | 18.62 | 18.75 | 18.28 | 18.6 | 249508.0 |
| 2005-10-13 | ACC-DELISTED | Stock | 22.75 | 23.08 | 22.6 | 22.96 | 236100.0 |
| 2005-10-13 | ACCL-DELISTED | Stock | 6.28 | 6.58 | 6.18 | 6.58 | 82959.0 |
| 2005-10-13 | ACCO | Stock | 26.07 | 26.2 | 25.5 | 25.84 | 221600.0 |
| 2005-10-13 | ACE-DELISTED | Stock | 47.41 | 48.0 | 47.13 | 47.98 | 1673674.0 |
| 2005-10-13 | ACF-DELISTED | Stock | 22.33 | 22.64 | 22.1 | 22.51 | 1674200.0 |
| 2005-10-13 | ACFC-DELISTED | Stock | 68.83 | 68.83 | 67.35 | 68.06 | 3217.0 |
| 2005-10-13 | ACG-DELISTED | Stock | 8.22 | 8.22 | 8.05 | 8.13 | 573000.0 |
> showing 50 of 4,190 rows — these rows as CSV