PREVIEW / stock_daily / 2005-01-26
file: by_date/stock_daily/2005/2005-01-26.parquet size: 133 KB rows: 3,964 symbols: 2,478
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-01-26 | AAPL | Stock | 1.2975 | 1.2991 | 1.2718 | 1.2902 | 739496800.0 |
| 2005-01-26 | MSFT | Stock | 26.07 | 26.17 | 25.9 | 26.01 | 64974500.0 |
| 2005-01-26 | NVDA | Stock | 0.1751 | 0.1792 | 0.1722 | 0.1767 | 429120000.0 |
| 2005-01-26 | AMZN | Stock | 2.059 | 2.09 | 2.013 | 2.067 | 154298000.0 |
| 2005-01-26 | CL | Stock | 25.0 | 25.195 | 24.925 | 24.94 | 4044200.0 |
| 2005-01-26 | A | Stock | 15.6724 | 15.7868 | 15.608 | 15.7368 | 2882396.0 |
| 2005-01-26 | AABA-DELISTED | Stock | 34.7099990844727 | 35.7400016784668 | 34.3899993896484 | 35.4700012207031 | 25767500.0 |
| 2005-01-26 | AACC-DELISTED | Stock | 20.73 | 20.73 | 20.36 | 20.49 | 48350.0 |
| 2005-01-26 | AAI-DELISTED | Stock | 8.11 | 8.24 | 7.61 | 7.88 | 2662900.0 |
| 2005-01-26 | AAIC-DELISTED | Stock | 389.0 | 392.0 | 382.4 | 391.0 | 684100.0 |
| 2005-01-26 | AAME | Stock | 3.0 | 3.01 | 2.99 | 3.01 | 9500.0 |
| 2005-01-26 | AAON | Stock | 1.8963 | 1.8963 | 1.8463 | 1.8765 | 53916.0 |
| 2005-01-26 | AAP | Stock | 28.3267 | 28.5333 | 28.2267 | 28.24 | 424200.0 |
| 2005-01-26 | AAV-DELISTED | Stock | 17.92 | 17.92 | 17.85 | 17.92 | 68800.0 |
| 2005-01-26 | AAXN-DELISTED | Stock | 16.4400005340576 | 16.4400005340576 | 16.0 | 16.2800006866455 | 3969900.0 |
| 2005-01-26 | ABAX-DELISTED | Stock | 12.81 | 13.33 | 12.58 | 13.15 | 173574.0 |
| 2005-01-26 | ABB-DELISTED | Stock | 5.48 | 5.53 | 5.44 | 5.5 | 485300.0 |
| 2005-01-26 | ABBC-DELISTED | Stock | 13.1 | 13.19 | 12.97 | 13.07 | 16902.0 |
| 2005-01-26 | ABC-DELISTED | Stock | 14.2 | 14.5 | 14.2 | 14.48 | 4991200.0 |
| 2005-01-26 | ABCB | Stock | 15.2138 | 15.6595 | 15.1814 | 15.4569 | 5921.0 |
| 2005-01-26 | ABCO-DELISTED | Stock | 17.752 | 17.883 | 17.532 | 17.803 | 173422.0 |
| 2005-01-26 | ABCW-DELISTED | Stock | 27.1 | 27.24 | 26.86 | 27.2 | 62170.0 |
| 2005-01-26 | ABE-DELISTED | Stock | 9.53 | 9.54 | 9.37 | 9.54 | 28800.0 |
| 2005-01-26 | ABFS-DELISTED | Stock | 41.073 | 41.38 | 40.6 | 41.37 | 257589.0 |
| 2005-01-26 | ABG | Stock | 16.97 | 17.06 | 16.86 | 16.95 | 71800.0 |
| 2005-01-26 | ABK-DELISTED | Stock | 79.61 | 79.78 | 76.15 | 77.3 | 1747300.0 |
| 2005-01-26 | ABM | Stock | 18.06 | 18.62 | 18.06 | 18.54 | 170800.0 |
| 2005-01-26 | ABMD-DELISTED | Stock | 11.14 | 11.25 | 11.01 | 11.09 | 138607.0 |
| 2005-01-26 | ABP-DELISTED | Stock | 1.97 | 2.09 | 1.97 | 2.06 | 160500.0 |
| 2005-01-26 | ABR | Stock | 24.46 | 24.48 | 24.32 | 24.39 | 47600.0 |
| 2005-01-26 | ABT | Stock | 22.0564 | 22.2243 | 22.0084 | 22.018 | 6843476.0 |
| 2005-01-26 | ABTL-DELISTED | Stock | 27.75 | 28.0 | 27.25 | 28.0 | 50500.0 |
| 2005-01-26 | ABV-DELISTED | Stock | 25.55 | 25.58 | 25.21 | 25.3 | 247600.0 |
| 2005-01-26 | ABVA-DELISTED | Stock | 16.0 | 16.0 | 16.0 | 16.0 | 1000.0 |
| 2005-01-26 | ABX-DELISTED | Stock | 22.39 | 22.47 | 22.21 | 22.24 | 1250400.0 |
| 2005-01-26 | ACAD | Stock | 6.53 | 6.75 | 6.53 | 6.74 | 3000.0 |
| 2005-01-26 | ACAP-DELISTED | Stock | 34.96 | 35.4 | 34.37 | 35.21 | 81518.0 |
| 2005-01-26 | ACAS-DELISTED | Stock | 33.1 | 33.53 | 33.08 | 33.44 | 636837.0 |
| 2005-01-26 | ACAT-DELISTED | Stock | 25.1 | 25.13 | 24.66 | 25.12 | 67832.0 |
| 2005-01-26 | ACC-DELISTED | Stock | 21.05 | 21.05 | 20.6 | 20.74 | 42200.0 |
| 2005-01-26 | ACCL-DELISTED | Stock | 5.5 | 5.58 | 5.15 | 5.58 | 281315.0 |
| 2005-01-26 | ACE-DELISTED | Stock | 42.63 | 43.24 | 42.56 | 43.15 | 1120354.0 |
| 2005-01-26 | ACF-DELISTED | Stock | 24.03 | 24.35 | 23.95 | 24.16 | 1184200.0 |
| 2005-01-26 | ACFC-DELISTED | Stock | 66.33 | 66.33 | 65.77 | 66.33 | 1816.0 |
| 2005-01-26 | ACG-DELISTED | Stock | 8.21 | 8.23 | 8.2 | 8.22 | 456500.0 |
| 2005-01-26 | ACGL | Stock | 4.1378 | 4.1433 | 4.1111 | 4.1189 | 822600.0 |
| 2005-01-26 | ACGN-DELISTED | Stock | 1008.6712 | 1020.0 | 736.6712 | 759.3288 | 1890200.0 |
| 2005-01-26 | ACH | Stock | 18.5267 | 18.8533 | 18.5267 | 18.84 | 529950.0 |
| 2005-01-26 | ACH-DELISTED | Stock | 13.562 | 13.724 | 13.534 | 13.699 | 194804.0 |
| 2005-01-26 | ACLS | Stock | 28.52 | 29.4 | 28.4 | 29.32 | 149325.0 |
> showing 50 of 3,964 rows — these rows as CSV