PREVIEW / stock_daily / 2006-03-01
file: by_date/stock_daily/2006/2006-03-01.parquet size: 147 KB rows: 4,384 symbols: 2,779
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 |
|---|---|---|---|---|---|---|---|
| 2006-03-01 | AAPL | Stock | 2.4586 | 2.4818 | 2.4293 | 2.4679 | 763817600.0 |
| 2006-03-01 | MSFT | Stock | 26.98 | 27.2 | 26.95 | 27.14 | 53061200.0 |
| 2006-03-01 | NVDA | Stock | 0.3942 | 0.41 | 0.3917 | 0.4077 | 703932000.0 |
| 2006-03-01 | AMZN | Stock | 1.8725 | 1.8845 | 1.8425 | 1.856 | 139630000.0 |
| 2006-03-01 | CL | Stock | 27.34 | 27.475 | 27.245 | 27.385 | 2252600.0 |
| 2006-03-01 | A | Stock | 25.8226 | 26.2589 | 25.8226 | 26.2589 | 2668083.0 |
| 2006-03-01 | AABA-DELISTED | Stock | 32.2099990844727 | 32.4199981689453 | 31.7199993133545 | 32.1800003051758 | 18466100.0 |
| 2006-03-01 | AACC-DELISTED | Stock | 19.99 | 20.08 | 19.42 | 19.71 | 310678.0 |
| 2006-03-01 | AACQ-DELISTED | Stock | 5.35 | 5.38 | 5.35 | 5.37 | 9800.0 |
| 2006-03-01 | AACQU-DELISTED | Stock | 6.75 | 6.8 | 6.75 | 6.8 | 12500.0 |
| 2006-03-01 | AACQW-DELISTED | Stock | 0.71 | 0.75 | 0.68 | 0.72 | 373500.0 |
| 2006-03-01 | AAI-DELISTED | Stock | 17.74 | 17.9501 | 17.57 | 17.87 | 1088900.0 |
| 2006-03-01 | AAIC-DELISTED | Stock | 199.2 | 200.4 | 195.2 | 196.4 | 2125000.0 |
| 2006-03-01 | AAON | Stock | 2.8616 | 2.8642 | 2.8352 | 2.8642 | 106312.0 |
| 2006-03-01 | AAP | Stock | 41.35 | 42.58 | 41.16 | 42.52 | 1063500.0 |
| 2006-03-01 | AATI-DELISTED | Stock | 12.0 | 12.1 | 11.89 | 12.0 | 191901.0 |
| 2006-03-01 | AAU-DELISTED | Stock | 2.86 | 2.87 | 2.78 | 2.83 | 34500.0 |
| 2006-03-01 | AAUAF-DELISTED | Stock | 2.86 | 2.87 | 2.78 | 2.83 | 34500.0 |
| 2006-03-01 | AAV-DELISTED | Stock | 19.74 | 19.9 | 19.68 | 19.85 | 191800.0 |
| 2006-03-01 | AAWW-DELISTED | Stock | 48.5 | 48.75 | 48.0 | 48.0 | 181100.0 |
| 2006-03-01 | AAXN-DELISTED | Stock | 9.5 | 10.0799999237061 | 9.30000019073486 | 10.0299997329712 | 3158000.0 |
| 2006-03-01 | AB | Stock | 64.1 | 65.5 | 63.85 | 64.94 | 175300.0 |
| 2006-03-01 | ABAX-DELISTED | Stock | 22.18 | 22.84 | 22.0 | 22.82 | 218401.0 |
| 2006-03-01 | ABB-DELISTED | Stock | 12.39 | 12.52 | 12.23 | 12.44 | 3498300.0 |
| 2006-03-01 | ABBC-DELISTED | Stock | 13.3 | 13.36 | 13.3 | 13.3 | 4598.0 |
| 2006-03-01 | ABC-DELISTED | Stock | 23.12 | 23.14 | 22.91 | 23.0 | 3390400.0 |
| 2006-03-01 | ABCB | Stock | 22.2735 | 22.7695 | 22.2735 | 22.4583 | 30330.0 |
| 2006-03-01 | ABCO-DELISTED | Stock | 26.98 | 27.94 | 26.88 | 27.64 | 179138.0 |
| 2006-03-01 | ABCW-DELISTED | Stock | 30.62 | 30.86 | 30.36 | 30.5 | 95660.0 |
| 2006-03-01 | ABD-DELISTED | Stock | 23.63 | 23.69 | 22.73 | 23.02 | 922360.0 |
| 2006-03-01 | ABE-DELISTED | Stock | 13.05 | 13.11 | 12.89 | 13.06 | 22100.0 |
| 2006-03-01 | ABFS-DELISTED | Stock | 41.6 | 42.77 | 41.54 | 42.69 | 267093.0 |
| 2006-03-01 | ABG | Stock | 19.15 | 19.56 | 18.9 | 19.47 | 83400.0 |
| 2006-03-01 | ABK-DELISTED | Stock | 75.19 | 75.62 | 74.65 | 75.52 | 344000.0 |
| 2006-03-01 | ABM | Stock | 18.54 | 18.79 | 18.45 | 18.73 | 149000.0 |
| 2006-03-01 | ABMD-DELISTED | Stock | 10.41 | 10.9 | 10.37 | 10.89 | 77298.0 |
| 2006-03-01 | ABP-DELISTED | Stock | 5.7 | 5.94 | 5.7 | 5.92 | 284800.0 |
| 2006-03-01 | ABR | Stock | 26.27 | 27.38 | 26.27 | 27.29 | 103800.0 |
| 2006-03-01 | ABT | Stock | 21.1976 | 21.2072 | 20.8329 | 21.1112 | 11510213.0 |
| 2006-03-01 | ABTL-DELISTED | Stock | 23.32 | 23.68 | 23.2 | 23.53 | 50178.0 |
| 2006-03-01 | ABV-DELISTED | Stock | 42.44 | 43.1 | 42.44 | 42.9 | 384400.0 |
| 2006-03-01 | ABVA-DELISTED | Stock | 18.758 | 18.822 | 18.654 | 18.822 | 3680.0 |
| 2006-03-01 | ABX-DELISTED | Stock | 27.51 | 27.96 | 27.37 | 27.51 | 3684540.0 |
| 2006-03-01 | ACAD | Stock | 14.97 | 15.08 | 14.12 | 14.63 | 524600.0 |
| 2006-03-01 | ACAP-DELISTED | Stock | 49.46 | 50.42 | 49.46 | 50.15 | 22055.0 |
| 2006-03-01 | ACAS-DELISTED | Stock | 35.72 | 36.0 | 35.5 | 35.62 | 982853.0 |
| 2006-03-01 | ACAT-DELISTED | Stock | 24.19 | 24.95 | 24.19 | 24.62 | 99676.0 |
| 2006-03-01 | ACC-DELISTED | Stock | 25.2 | 25.5 | 25.01 | 25.5 | 35900.0 |
| 2006-03-01 | ACCL-DELISTED | Stock | 6.24 | 6.5 | 6.18 | 6.44 | 74436.0 |
| 2006-03-01 | ACCO | Stock | 23.65 | 23.65 | 22.7 | 23.0 | 941300.0 |
> showing 50 of 4,384 rows — these rows as CSV