PREVIEW / stock_daily / 2006-03-22
file: by_date/stock_daily/2006/2006-03-22.parquet size: 146 KB rows: 4,363 symbols: 2,756
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-22 | AAPL | Stock | 2.22 | 2.2589 | 2.1882 | 2.2025 | 1345895600.0 |
| 2006-03-22 | MSFT | Stock | 27.08 | 27.5 | 26.8 | 27.15 | 145696100.0 |
| 2006-03-22 | NVDA | Stock | 0.4125 | 0.4145 | 0.4018 | 0.4111 | 1158576000.0 |
| 2006-03-22 | AMZN | Stock | 1.8 | 1.827 | 1.7895 | 1.8 | 86016000.0 |
| 2006-03-22 | CL | Stock | 28.445 | 29.045 | 28.445 | 29.01 | 3318200.0 |
| 2006-03-22 | A | Stock | 26.5236 | 26.5951 | 26.3305 | 26.5379 | 4593409.0 |
| 2006-03-22 | AABA-DELISTED | Stock | 30.3299999237061 | 30.9099998474121 | 30.3099994659424 | 30.75 | 23147400.0 |
| 2006-03-22 | AACC-DELISTED | Stock | 19.67 | 19.67 | 19.34 | 19.39 | 195221.0 |
| 2006-03-22 | AACQW-DELISTED | Stock | 0.77 | 0.77 | 0.74 | 0.74 | 45000.0 |
| 2006-03-22 | AAI-DELISTED | Stock | 17.8 | 18.45 | 17.8 | 18.3987 | 1518000.0 |
| 2006-03-22 | AAIC-DELISTED | Stock | 182.4 | 186.2 | 182.2 | 185.8 | 721500.0 |
| 2006-03-22 | AAON | Stock | 2.8998 | 2.9551 | 2.8998 | 2.9419 | 71381.0 |
| 2006-03-22 | AAP | Stock | 41.05 | 41.67 | 41.02 | 41.54 | 602000.0 |
| 2006-03-22 | AATI-DELISTED | Stock | 11.2 | 11.22 | 10.95 | 11.03 | 416893.0 |
| 2006-03-22 | AAU-DELISTED | Stock | 2.59 | 2.59 | 2.52 | 2.59 | 41900.0 |
| 2006-03-22 | AAUAF-DELISTED | Stock | 2.59 | 2.59 | 2.52 | 2.59 | 41900.0 |
| 2006-03-22 | AAV-DELISTED | Stock | 18.71 | 19.0 | 18.65 | 19.0 | 348000.0 |
| 2006-03-22 | AAWW-DELISTED | Stock | 47.25 | 47.25 | 46.0 | 47.0 | 46800.0 |
| 2006-03-22 | AAXN-DELISTED | Stock | 10.3199996948242 | 10.8400001525879 | 10.2600002288818 | 10.6999998092651 | 2618600.0 |
| 2006-03-22 | AB | Stock | 64.4 | 65.0 | 64.23 | 64.73 | 100700.0 |
| 2006-03-22 | ABAX-DELISTED | Stock | 23.44 | 24.3 | 23.27 | 24.17 | 548035.0 |
| 2006-03-22 | ABB-DELISTED | Stock | 12.01 | 12.12 | 12.0 | 12.0899 | 1270300.0 |
| 2006-03-22 | ABBC-DELISTED | Stock | 13.33 | 13.42 | 13.3 | 13.4 | 11916.0 |
| 2006-03-22 | ABC-DELISTED | Stock | 23.58 | 23.9 | 23.47 | 23.87 | 1983000.0 |
| 2006-03-22 | ABCB | Stock | 21.3009 | 21.9331 | 21.2522 | 21.8747 | 8019.0 |
| 2006-03-22 | ABCO-DELISTED | Stock | 28.1 | 28.63 | 27.54 | 28.61 | 221240.0 |
| 2006-03-22 | ABCW-DELISTED | Stock | 29.36 | 29.89 | 29.31 | 29.49 | 86550.0 |
| 2006-03-22 | ABD-DELISTED | Stock | 22.55 | 22.56 | 21.99 | 22.15 | 200220.0 |
| 2006-03-22 | ABE-DELISTED | Stock | 12.67 | 12.82 | 12.61 | 12.65 | 22900.0 |
| 2006-03-22 | ABFS-DELISTED | Stock | 41.34 | 42.54 | 41.28 | 42.5 | 208269.0 |
| 2006-03-22 | ABG | Stock | 19.74 | 20.46 | 19.68 | 20.33 | 79500.0 |
| 2006-03-22 | ABK-DELISTED | Stock | 80.14 | 80.37 | 79.7 | 80.19 | 611700.0 |
| 2006-03-22 | ABM | Stock | 17.01 | 17.59 | 17.0 | 17.59 | 173300.0 |
| 2006-03-22 | ABMD-DELISTED | Stock | 11.67 | 11.97 | 11.53 | 11.97 | 70028.0 |
| 2006-03-22 | ABP-DELISTED | Stock | 5.57 | 5.75 | 5.57 | 5.7 | 228000.0 |
| 2006-03-22 | ABR | Stock | 26.47 | 26.62 | 26.29 | 26.6 | 62700.0 |
| 2006-03-22 | ABT | Stock | 21.1016 | 21.2072 | 20.9769 | 21.1592 | 9692372.0 |
| 2006-03-22 | ABTL-DELISTED | Stock | 23.05 | 23.5 | 22.45 | 22.75 | 50934.0 |
| 2006-03-22 | ABV-DELISTED | Stock | 41.95 | 42.55 | 41.86 | 42.29 | 430000.0 |
| 2006-03-22 | ABVA-DELISTED | Stock | 18.937 | 18.952 | 18.901 | 18.93 | 787.0 |
| 2006-03-22 | ABX-DELISTED | Stock | 26.1 | 26.11 | 25.76 | 25.91 | 3772000.0 |
| 2006-03-22 | ACAD | Stock | 15.27 | 15.71 | 14.93 | 15.62 | 438300.0 |
| 2006-03-22 | ACAP-DELISTED | Stock | 48.01 | 49.36 | 48.01 | 49.11 | 48919.0 |
| 2006-03-22 | ACAS-DELISTED | Stock | 35.3 | 35.64 | 35.3 | 35.41 | 631613.0 |
| 2006-03-22 | ACAT-DELISTED | Stock | 23.26 | 23.55 | 23.06 | 23.35 | 35924.0 |
| 2006-03-22 | ACC-DELISTED | Stock | 26.38 | 26.43 | 25.85 | 26.37 | 52409.0 |
| 2006-03-22 | ACCL-DELISTED | Stock | 7.21 | 7.42 | 7.21 | 7.32 | 71496.0 |
| 2006-03-22 | ACCO | Stock | 22.55 | 22.56 | 22.0 | 22.15 | 201500.0 |
| 2006-03-22 | ACCP-DELISTED | Stock | 1.45 | 1.5 | 1.45 | 1.5 | 24219.0 |
| 2006-03-22 | ACE-DELISTED | Stock | 55.19 | 55.46 | 55.07 | 55.31 | 554209.0 |
> showing 50 of 4,363 rows — these rows as CSV