PREVIEW / stock_daily / 2010-11-01
file: by_date/stock_daily/2010/2010-11-01.parquet size: 193 KB rows: 6,021 symbols: 3,544
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 |
|---|---|---|---|---|---|---|---|
| 2010-11-01 | AAPL | Stock | 10.7936 | 10.9143 | 10.7929 | 10.8636 | 423889200.0 |
| 2010-11-01 | MSFT | Stock | 26.88 | 27.22 | 26.7 | 26.95 | 61912100.0 |
| 2010-11-01 | NVDA | Stock | 0.3025 | 0.3073 | 0.2985 | 0.301 | 473920000.0 |
| 2010-11-01 | AMZN | Stock | 8.2225 | 8.229 | 8.076 | 8.129 | 104798000.0 |
| 2010-11-01 | TSLA | Stock | 1.4627 | 1.5167 | 1.4207 | 1.4273 | 6837000.0 |
| 2010-11-01 | TLT | Stock | 100.8 | 100.81 | 99.49 | 99.67 | 5921583.0 |
| 2010-11-01 | ES | Stock | 32.06 | 32.21 | 31.1 | 31.43 | 1882900.0 |
| 2010-11-01 | CL | Stock | 38.465 | 38.635 | 38.415 | 38.63 | 5421400.0 |
| 2010-11-01 | A | Stock | 24.9928 | 25.1216 | 24.5923 | 24.8569 | 2885472.0 |
| 2010-11-01 | AABA-DELISTED | Stock | 16.51 | 16.52 | 16.08 | 16.15 | 14234232.0 |
| 2010-11-01 | AACC-DELISTED | Stock | 5.81 | 5.81 | 5.45 | 5.46 | 15029.0 |
| 2010-11-01 | AACG | Stock | 3.49 | 3.5 | 3.22 | 3.46 | 1800.0 |
| 2010-11-01 | AAI-DELISTED | Stock | 7.4 | 7.46 | 7.35 | 7.41 | 9448394.0 |
| 2010-11-01 | AAIC-DELISTED | Stock | 23.89 | 23.89 | 22.75 | 22.85 | 72295.0 |
| 2010-11-01 | AAME | Stock | 1.7 | 1.75 | 1.7 | 1.75 | 3200.0 |
| 2010-11-01 | AAON | Stock | 4.8514 | 4.8711 | 4.8198 | 4.8494 | 97200.0 |
| 2010-11-01 | AAP | Stock | 65.29 | 65.34 | 64.46 | 64.76 | 555700.0 |
| 2010-11-01 | AATI-DELISTED | Stock | 3.79 | 3.79 | 3.63 | 3.73 | 199542.0 |
| 2010-11-01 | AAU-DELISTED | Stock | 2.89 | 2.9 | 2.75 | 2.81 | 210941.0 |
| 2010-11-01 | AAUAF-DELISTED | Stock | 2.89 | 2.9 | 2.75 | 2.81 | 212765.0 |
| 2010-11-01 | AAV-DELISTED | Stock | 6.19 | 6.4 | 6.19 | 6.33 | 410703.0 |
| 2010-11-01 | AAWW-DELISTED | Stock | 55.96 | 57.66 | 54.2 | 55.6 | 734478.0 |
| 2010-11-01 | AAXJ | Stock | 62.92 | 63.37 | 62.81 | 62.93 | 576979.0 |
| 2010-11-01 | AAXN-DELISTED | Stock | 3.98 | 4.04 | 3.86 | 3.89 | 329468.0 |
| 2010-11-01 | AB | Stock | 24.39 | 24.47 | 24.0 | 24.11 | 636400.0 |
| 2010-11-01 | ABAC-DELISTED | Stock | 5.8 | 6.14 | 5.8 | 6.05 | 118720.0 |
| 2010-11-01 | ABAX-DELISTED | Stock | 24.14 | 24.32 | 23.4 | 23.52 | 74206.0 |
| 2010-11-01 | ABB-DELISTED | Stock | 20.68 | 20.73 | 20.43 | 20.5301 | 3017748.0 |
| 2010-11-01 | ABBC-DELISTED | Stock | 10.65 | 10.79 | 10.58 | 10.68 | 48583.0 |
| 2010-11-01 | ABBNY-DELISTED | Stock | 20.68 | 20.73 | 20.43 | 20.55 | 3088009.0 |
| 2010-11-01 | ABC-DELISTED | Stock | 32.92 | 33.36 | 32.49 | 32.77 | 4177882.0 |
| 2010-11-01 | ABCB | Stock | 9.27 | 9.34 | 8.79 | 9.05 | 159100.0 |
| 2010-11-01 | ABCD-DELISTED | Stock | 3.14 | 3.2 | 3.01 | 3.01 | 27712.0 |
| 2010-11-01 | ABCO-DELISTED | Stock | 23.39 | 23.63 | 22.97 | 23.13 | 50370.0 |
| 2010-11-01 | ABCW-DELISTED | Stock | 0.7 | 0.7 | 0.65 | 0.65 | 35150.0 |
| 2010-11-01 | ABD-DELISTED | Stock | 6.26 | 6.48 | 5.96 | 6.07 | 456140.0 |
| 2010-11-01 | ABE-DELISTED | Stock | 19.03 | 19.22 | 19.0 | 19.044 | 66193.0 |
| 2010-11-01 | ABEO | Stock | 3687.5 | 3750.0 | 3625.0 | 3687.5 | 18.0 |
| 2010-11-01 | ABFS-DELISTED | Stock | 25.51 | 26.39 | 25.46 | 26.26 | 611135.0 |
| 2010-11-01 | ABG | Stock | 14.49 | 14.65 | 14.39 | 14.57 | 202600.0 |
| 2010-11-01 | ABK-DELISTED | Stock | 0.444 | 0.557 | 0.3335 | 0.415 | 126935206.0 |
| 2010-11-01 | ABM | Stock | 22.7 | 22.93 | 22.23 | 22.45 | 166000.0 |
| 2010-11-01 | ABMD-DELISTED | Stock | 10.32 | 10.5 | 10.31 | 10.45 | 126053.0 |
| 2010-11-01 | ABR | Stock | 5.29 | 5.29 | 5.21 | 5.27 | 30200.0 |
| 2010-11-01 | ABT | Stock | 24.7481 | 24.7769 | 24.1435 | 24.2779 | 20652980.0 |
| 2010-11-01 | ABTL-DELISTED | Stock | 4.1497 | 4.1497 | 3.9498 | 3.9503 | 46822.0 |
| 2010-11-01 | ABV-DELISTED | Stock | 141.33 | 141.589 | 138.35 | 139.86 | 477888.0 |
| 2010-11-01 | ABVA-DELISTED | Stock | 3.09 | 3.17 | 3.03 | 3.16 | 15974.0 |
| 2010-11-01 | ABVT-DELISTED | Stock | 57.29 | 57.9799 | 56.76 | 57.54 | 304573.0 |
| 2010-11-01 | ABX-DELISTED | Stock | 48.46 | 48.5 | 47.65 | 48.06 | 5370557.0 |
> showing 50 of 6,021 rows — these rows as CSV