PREVIEW / stock_daily / 2005-05-31
file: by_date/stock_daily/2005/2005-05-31.parquet size: 136 KB rows: 4,090 symbols: 2,565
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-05-31 | AAPL | Stock | 1.4521 | 1.455 | 1.4136 | 1.42 | 404205200.0 |
| 2005-05-31 | MSFT | Stock | 25.99 | 26.03 | 25.75 | 25.8 | 46131100.0 |
| 2005-05-31 | NVDA | Stock | 0.2283 | 0.2302 | 0.2221 | 0.2258 | 763176000.0 |
| 2005-05-31 | AMZN | Stock | 1.768 | 1.802 | 1.7645 | 1.7755 | 98604000.0 |
| 2005-05-31 | CL | Stock | 25.08 | 25.13 | 24.94 | 24.985 | 2566400.0 |
| 2005-05-31 | A | Stock | 16.9886 | 17.2747 | 16.9599 | 17.1745 | 2871632.0 |
| 2005-05-31 | AABA-DELISTED | Stock | 37.0299987792969 | 37.3499984741211 | 36.8499984741211 | 37.2000007629395 | 12498300.0 |
| 2005-05-31 | AACC-DELISTED | Stock | 22.85 | 24.63 | 22.83 | 24.54 | 218130.0 |
| 2005-05-31 | AACQ-DELISTED | Stock | 4.95 | 4.95 | 4.9 | 4.92 | 22000.0 |
| 2005-05-31 | AACQU-DELISTED | Stock | 6.1 | 6.1 | 6.1 | 6.1 | 500.0 |
| 2005-05-31 | AACQW-DELISTED | Stock | 0.56 | 0.56 | 0.56 | 0.56 | 46700.0 |
| 2005-05-31 | AAI-DELISTED | Stock | 9.94 | 10.0 | 9.75 | 9.75 | 1289100.0 |
| 2005-05-31 | AAIC-DELISTED | Stock | 258.2 | 262.6 | 257.2 | 261.0 | 1461800.0 |
| 2005-05-31 | AAON | Stock | 2.3704 | 2.3822 | 2.3216 | 2.3572 | 255909.0 |
| 2005-05-31 | AAP | Stock | 39.44 | 39.6533 | 38.9467 | 39.5133 | 1812600.0 |
| 2005-05-31 | AAV-DELISTED | Stock | 13.7 | 13.89 | 13.6 | 13.7 | 56400.0 |
| 2005-05-31 | AAXN-DELISTED | Stock | 11.1000003814697 | 11.7200002670288 | 11.0 | 11.3400001525879 | 5227300.0 |
| 2005-05-31 | ABAX-DELISTED | Stock | 10.61 | 10.79 | 10.41 | 10.45 | 87222.0 |
| 2005-05-31 | ABB-DELISTED | Stock | 6.56 | 6.59 | 6.51 | 6.55 | 721700.0 |
| 2005-05-31 | ABBC-DELISTED | Stock | 11.04 | 11.15 | 10.3 | 10.8 | 67093.0 |
| 2005-05-31 | ABC-DELISTED | Stock | 16.3 | 16.36 | 16.1 | 16.17 | 7790000.0 |
| 2005-05-31 | ABCB | Stock | 17.3325 | 17.3325 | 17.206 | 17.2644 | 3290.0 |
| 2005-05-31 | ABCO-DELISTED | Stock | 22.79 | 22.84 | 22.51 | 22.55 | 182536.0 |
| 2005-05-31 | ABCW-DELISTED | Stock | 27.84 | 27.88 | 27.63 | 27.66 | 36600.0 |
| 2005-05-31 | ABE-DELISTED | Stock | 9.75 | 9.75 | 9.68 | 9.68 | 7500.0 |
| 2005-05-31 | ABFS-DELISTED | Stock | 33.01 | 33.259 | 32.54 | 32.66 | 225032.0 |
| 2005-05-31 | ABG | Stock | 14.36 | 14.84 | 14.36 | 14.7 | 48300.0 |
| 2005-05-31 | ABK-DELISTED | Stock | 72.23 | 72.5 | 71.61 | 72.11 | 630600.0 |
| 2005-05-31 | ABM | Stock | 19.12 | 19.29 | 19.02 | 19.07 | 50900.0 |
| 2005-05-31 | ABMD-DELISTED | Stock | 10.0 | 10.45 | 8.94 | 9.39 | 307767.0 |
| 2005-05-31 | ABP-DELISTED | Stock | 2.55 | 2.79 | 2.55 | 2.73 | 258500.0 |
| 2005-05-31 | ABR | Stock | 26.65 | 26.84 | 26.6 | 26.65 | 92500.0 |
| 2005-05-31 | ABT | Stock | 23.1024 | 23.2223 | 22.9728 | 23.1456 | 7382659.0 |
| 2005-05-31 | ABTL-DELISTED | Stock | 20.05 | 24.75 | 20.05 | 24.3 | 69200.0 |
| 2005-05-31 | ABV-DELISTED | Stock | 30.26 | 30.3 | 30.02 | 30.19 | 256800.0 |
| 2005-05-31 | ABX-DELISTED | Stock | 22.65 | 23.1 | 22.43 | 22.94 | 2335503.0 |
| 2005-05-31 | ACAD | Stock | 8.58 | 8.82 | 8.56 | 8.73 | 17900.0 |
| 2005-05-31 | ACAP-DELISTED | Stock | 33.83 | 35.0 | 33.83 | 34.75 | 73134.0 |
| 2005-05-31 | ACAS-DELISTED | Stock | 34.71 | 35.06 | 34.69 | 35.01 | 754420.0 |
| 2005-05-31 | ACAT-DELISTED | Stock | 22.65 | 22.65 | 21.37 | 21.6 | 112568.0 |
| 2005-05-31 | ACC-DELISTED | Stock | 20.51 | 20.6 | 20.4 | 20.51 | 18202.0 |
| 2005-05-31 | ACCL-DELISTED | Stock | 5.42 | 5.46 | 5.24 | 5.26 | 115380.0 |
| 2005-05-31 | ACE-DELISTED | Stock | 43.55 | 43.6 | 42.89 | 43.16 | 979100.0 |
| 2005-05-31 | ACF-DELISTED | Stock | 24.52 | 25.0 | 24.45 | 24.92 | 1205900.0 |
| 2005-05-31 | ACFC-DELISTED | Stock | 59.29 | 61.74 | 58.78 | 58.78 | 2803.0 |
| 2005-05-31 | ACG-DELISTED | Stock | 8.24 | 8.28 | 8.22 | 8.27 | 410500.0 |
| 2005-05-31 | ACGL | Stock | 4.8611 | 4.9789 | 4.8456 | 4.9611 | 1228500.0 |
| 2005-05-31 | ACGN-DELISTED | Stock | 770.6712 | 861.3288 | 770.6712 | 838.6712 | 767900.0 |
| 2005-05-31 | ACH | Stock | 20.6667 | 21.0333 | 20.6667 | 20.6667 | 220650.0 |
| 2005-05-31 | ACH-DELISTED | Stock | 12.837 | 12.85 | 12.7 | 12.75 | 158000.0 |
> showing 50 of 4,090 rows — these rows as CSV