PREVIEW / stock_daily / 2005-07-21
file: by_date/stock_daily/2005/2005-07-21.parquet size: 138 KB rows: 4,111 symbols: 2,578
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-07-21 | AAPL | Stock | 1.5607 | 1.5729 | 1.5321 | 1.5461 | 404264000.0 |
| 2005-07-21 | MSFT | Stock | 26.3 | 26.48 | 26.0 | 26.44 | 112932100.0 |
| 2005-07-21 | NVDA | Stock | 0.2219 | 0.2229 | 0.2164 | 0.221 | 594528000.0 |
| 2005-07-21 | AMZN | Stock | 1.948 | 1.9875 | 1.888 | 1.8975 | 221112000.0 |
| 2005-07-21 | CL | Stock | 25.71 | 25.955 | 25.525 | 25.925 | 5047800.0 |
| 2005-07-21 | A | Stock | 18.5408 | 18.6981 | 18.412 | 18.4907 | 2903506.0 |
| 2005-07-21 | AABA-DELISTED | Stock | 33.75 | 33.7599983215332 | 32.75 | 32.939998626709 | 37778500.0 |
| 2005-07-21 | AACC-DELISTED | Stock | 25.0 | 25.05 | 24.35 | 24.63 | 51094.0 |
| 2005-07-21 | AACQ-DELISTED | Stock | 4.99 | 4.99 | 4.99 | 4.99 | 11400.0 |
| 2005-07-21 | AACQW-DELISTED | Stock | 0.47 | 0.47 | 0.47 | 0.47 | 5000.0 |
| 2005-07-21 | AAI-DELISTED | Stock | 10.92 | 10.98 | 10.58 | 10.61 | 1814000.0 |
| 2005-07-21 | AAIC-DELISTED | Stock | 295.4 | 296.8 | 287.2 | 287.4 | 1071800.0 |
| 2005-07-21 | AAME | Stock | 3.0 | 3.02 | 2.94 | 2.96 | 4000.0 |
| 2005-07-21 | AAON | Stock | 2.4507 | 2.5297 | 2.4507 | 2.5021 | 44044.0 |
| 2005-07-21 | AAP | Stock | 44.6267 | 44.6267 | 43.9933 | 44.2333 | 492150.0 |
| 2005-07-21 | AAV-DELISTED | Stock | 14.79 | 15.09 | 14.77 | 14.79 | 49400.0 |
| 2005-07-21 | AAXN-DELISTED | Stock | 9.64000034332275 | 9.90999984741211 | 9.55000019073486 | 9.69999980926514 | 1735900.0 |
| 2005-07-21 | ABAX-DELISTED | Stock | 11.74 | 12.3 | 11.63 | 12.0 | 168038.0 |
| 2005-07-21 | ABB-DELISTED | Stock | 6.58 | 6.6 | 6.47 | 6.54 | 423000.0 |
| 2005-07-21 | ABBC-DELISTED | Stock | 12.22 | 12.25 | 12.13 | 12.14 | 5500.0 |
| 2005-07-21 | ABC-DELISTED | Stock | 17.94 | 18.0 | 17.54 | 17.72 | 9357200.0 |
| 2005-07-21 | ABCB | Stock | 19.1026 | 19.1125 | 18.6067 | 18.7428 | 6683.0 |
| 2005-07-21 | ABCO-DELISTED | Stock | 24.0 | 24.16 | 23.65 | 23.79 | 185467.0 |
| 2005-07-21 | ABCW-DELISTED | Stock | 30.34 | 30.91 | 29.93 | 30.22 | 36516.0 |
| 2005-07-21 | ABE-DELISTED | Stock | 10.31 | 10.36 | 10.27 | 10.29 | 10400.0 |
| 2005-07-21 | ABFS-DELISTED | Stock | 35.59 | 37.44 | 35.27 | 36.31 | 646746.0 |
| 2005-07-21 | ABG | Stock | 16.9 | 17.12 | 16.75 | 16.85 | 52100.0 |
| 2005-07-21 | ABK-DELISTED | Stock | 71.36 | 71.7 | 70.75 | 71.1 | 640600.0 |
| 2005-07-21 | ABM | Stock | 19.85 | 19.95 | 19.48 | 19.53 | 188700.0 |
| 2005-07-21 | ABMD-DELISTED | Stock | 9.3 | 9.32 | 9.14 | 9.15 | 46673.0 |
| 2005-07-21 | ABP-DELISTED | Stock | 3.54 | 3.69 | 3.5 | 3.69 | 238400.0 |
| 2005-07-21 | ABR | Stock | 30.1 | 30.19 | 29.8 | 30.0 | 80600.0 |
| 2005-07-21 | ABT | Stock | 22.4978 | 22.5746 | 22.2771 | 22.2915 | 7426845.0 |
| 2005-07-21 | ABTL-DELISTED | Stock | 24.05 | 24.5 | 23.75 | 23.85 | 17771.0 |
| 2005-07-21 | ABV-DELISTED | Stock | 31.19 | 31.3 | 31.04 | 31.16 | 276500.0 |
| 2005-07-21 | ABVT-DELISTED | Stock | 32.0 | 32.5 | 23.0 | 23.0 | 10200.0 |
| 2005-07-21 | ABX-DELISTED | Stock | 24.49 | 24.8 | 24.28 | 24.65 | 2101200.0 |
| 2005-07-21 | ACAD | Stock | 9.55 | 9.75 | 9.16 | 9.21 | 278800.0 |
| 2005-07-21 | ACAP-DELISTED | Stock | 38.71 | 38.94 | 38.27 | 38.66 | 27887.0 |
| 2005-07-21 | ACAS-DELISTED | Stock | 37.68 | 37.74 | 37.26 | 37.52 | 409488.0 |
| 2005-07-21 | ACAT-DELISTED | Stock | 21.02 | 22.66 | 21.02 | 21.94 | 208992.0 |
| 2005-07-21 | ACC-DELISTED | Stock | 24.0 | 24.0 | 23.4 | 23.51 | 34300.0 |
| 2005-07-21 | ACCL-DELISTED | Stock | 5.6 | 5.64 | 5.45 | 5.64 | 108559.0 |
| 2005-07-21 | ACE-DELISTED | Stock | 46.48 | 46.79 | 45.81 | 46.26 | 1389700.0 |
| 2005-07-21 | ACF-DELISTED | Stock | 26.91 | 27.59 | 26.81 | 27.02 | 1963500.0 |
| 2005-07-21 | ACFC-DELISTED | Stock | 68.88 | 68.88 | 67.6 | 67.6 | 7512.0 |
| 2005-07-21 | ACG-DELISTED | Stock | 8.33 | 8.33 | 8.29 | 8.3 | 372800.0 |
| 2005-07-21 | ACGL | Stock | 4.9078 | 4.9322 | 4.8556 | 4.8956 | 1046700.0 |
| 2005-07-21 | ACGN-DELISTED | Stock | 623.3288 | 623.3288 | 589.3288 | 600.6712 | 97600.0 |
| 2005-07-21 | ACH | Stock | 20.0 | 20.62 | 19.6 | 19.9 | 1534950.0 |
> showing 50 of 4,111 rows — these rows as CSV