PREVIEW / stock_daily / 2005-03-09
file: by_date/stock_daily/2005/2005-03-09.parquet size: 135 KB rows: 4,030 symbols: 2,524
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-03-09 | AAPL | Stock | 1.4157 | 1.4386 | 1.3868 | 1.4054 | 1322465200.0 |
| 2005-03-09 | MSFT | Stock | 25.39 | 25.57 | 25.28 | 25.31 | 62991800.0 |
| 2005-03-09 | NVDA | Stock | 0.2189 | 0.223 | 0.2139 | 0.2146 | 910140000.0 |
| 2005-03-09 | AMZN | Stock | 1.787 | 1.7965 | 1.745 | 1.77 | 148246000.0 |
| 2005-03-09 | CL | Stock | 26.28 | 26.365 | 25.85 | 25.88 | 3889600.0 |
| 2005-03-09 | A | Stock | 17.3176 | 17.5393 | 17.1316 | 17.1745 | 3013109.0 |
| 2005-03-09 | AABA-DELISTED | Stock | 33.0099983215332 | 33.1500015258789 | 32.0099983215332 | 32.3199996948242 | 21824400.0 |
| 2005-03-09 | AACC-DELISTED | Stock | 18.38 | 19.439 | 18.38 | 19.25 | 176943.0 |
| 2005-03-09 | AACQ-DELISTED | Stock | 5.15 | 5.2 | 5.15 | 5.17 | 67500.0 |
| 2005-03-09 | AACQU-DELISTED | Stock | 6.55 | 6.56 | 6.45 | 6.45 | 42000.0 |
| 2005-03-09 | AACQW-DELISTED | Stock | 0.7 | 0.73 | 0.67 | 0.67 | 928000.0 |
| 2005-03-09 | AAI-DELISTED | Stock | 8.46 | 8.47 | 8.18 | 8.26 | 1254200.0 |
| 2005-03-09 | AAIC-DELISTED | Stock | 383.0 | 383.0 | 372.0 | 373.6 | 989800.0 |
| 2005-03-09 | AAME | Stock | 3.01 | 3.01 | 3.01 | 3.01 | 100.0 |
| 2005-03-09 | AAON | Stock | 1.9753 | 2.0412 | 1.974 | 1.999 | 54675.0 |
| 2005-03-09 | AAP | Stock | 33.8667 | 33.94 | 33.6267 | 33.7133 | 688950.0 |
| 2005-03-09 | AAV-DELISTED | Stock | 16.82 | 16.95 | 16.7 | 16.82 | 46700.0 |
| 2005-03-09 | AAXN-DELISTED | Stock | 14.039999961853 | 14.4499998092651 | 13.75 | 14.1499996185303 | 5671900.0 |
| 2005-03-09 | ABAX-DELISTED | Stock | 10.5 | 10.8 | 10.07 | 10.68 | 170344.0 |
| 2005-03-09 | ABB-DELISTED | Stock | 6.27 | 6.28 | 6.2 | 6.26 | 218200.0 |
| 2005-03-09 | ABBC-DELISTED | Stock | 13.7 | 13.7 | 13.33 | 13.43 | 9485.0 |
| 2005-03-09 | ABC-DELISTED | Stock | 15.7 | 15.71 | 15.08 | 15.12 | 6488000.0 |
| 2005-03-09 | ABCB | Stock | 18.0263 | 18.0263 | 17.3698 | 17.3779 | 11352.0 |
| 2005-03-09 | ABCO-DELISTED | Stock | 19.488 | 19.807 | 19.463 | 19.592 | 176834.0 |
| 2005-03-09 | ABCW-DELISTED | Stock | 28.25 | 28.25 | 27.25 | 27.25 | 26430.0 |
| 2005-03-09 | ABE-DELISTED | Stock | 10.31 | 10.31 | 10.26 | 10.29 | 10600.0 |
| 2005-03-09 | ABFS-DELISTED | Stock | 44.93 | 45.1 | 44.08 | 44.5 | 331792.0 |
| 2005-03-09 | ABG | Stock | 15.47 | 15.49 | 15.35 | 15.46 | 76000.0 |
| 2005-03-09 | ABK-DELISTED | Stock | 78.7 | 78.88 | 77.96 | 78.44 | 274400.0 |
| 2005-03-09 | ABM | Stock | 19.29 | 19.68 | 19.15 | 19.5 | 255000.0 |
| 2005-03-09 | ABMD-DELISTED | Stock | 11.01 | 11.36 | 10.95 | 10.96 | 81700.0 |
| 2005-03-09 | ABP-DELISTED | Stock | 2.85 | 2.9 | 2.75 | 2.81 | 381400.0 |
| 2005-03-09 | ABR | Stock | 26.55 | 26.69 | 26.23 | 26.53 | 34700.0 |
| 2005-03-09 | ABT | Stock | 22.1668 | 22.2915 | 22.0132 | 22.0228 | 6714881.0 |
| 2005-03-09 | ABTL-DELISTED | Stock | 29.55 | 30.1 | 29.25 | 29.45 | 55200.0 |
| 2005-03-09 | ABV-DELISTED | Stock | 30.4 | 30.47 | 29.66 | 29.86 | 433400.0 |
| 2005-03-09 | ABVA-DELISTED | Stock | 16.934 | 16.934 | 16.934 | 16.934 | 1851.0 |
| 2005-03-09 | ABX-DELISTED | Stock | 25.93 | 26.33 | 25.85 | 25.91 | 1783679.0 |
| 2005-03-09 | ACAD | Stock | 7.0 | 7.44 | 6.96 | 7.17 | 6100.0 |
| 2005-03-09 | ACAP-DELISTED | Stock | 36.01 | 36.98 | 35.85 | 35.85 | 95534.0 |
| 2005-03-09 | ACAS-DELISTED | Stock | 34.75 | 34.82 | 34.34 | 34.34 | 450402.0 |
| 2005-03-09 | ACAT-DELISTED | Stock | 27.65 | 28.11 | 27.33 | 27.48 | 37451.0 |
| 2005-03-09 | ACC-DELISTED | Stock | 22.05 | 22.15 | 21.78 | 22.02 | 41500.0 |
| 2005-03-09 | ACCL-DELISTED | Stock | 5.2 | 5.29 | 5.11 | 5.18 | 95637.0 |
| 2005-03-09 | ACE-DELISTED | Stock | 45.74 | 45.95 | 45.24 | 45.44 | 797600.0 |
| 2005-03-09 | ACF-DELISTED | Stock | 24.03 | 24.08 | 23.57 | 23.75 | 1725400.0 |
| 2005-03-09 | ACFC-DELISTED | Stock | 67.47 | 68.24 | 67.42 | 67.47 | 2430.0 |
| 2005-03-09 | ACG-DELISTED | Stock | 8.39 | 8.4 | 8.25 | 8.27 | 562400.0 |
| 2005-03-09 | ACGL | Stock | 4.6433 | 4.6533 | 4.6044 | 4.6056 | 528300.0 |
| 2005-03-09 | ACGN-DELISTED | Stock | 623.3288 | 657.3288 | 600.6712 | 646.0 | 26600.0 |
> showing 50 of 4,030 rows — these rows as CSV