PREVIEW / stock_daily / 2010-11-24
file: by_date/stock_daily/2010/2010-11-24.parquet size: 194 KB rows: 6,010 symbols: 3,529
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-24 | AAPL | Stock | 11.1429 | 11.2643 | 11.1339 | 11.2429 | 413725200.0 |
| 2010-11-24 | MSFT | Stock | 25.2 | 25.46 | 25.16 | 25.37 | 56825900.0 |
| 2010-11-24 | NVDA | Stock | 0.3395 | 0.3455 | 0.3393 | 0.3442 | 397784000.0 |
| 2010-11-24 | AMZN | Stock | 8.5765 | 8.8945 | 8.5765 | 8.8625 | 200850000.0 |
| 2010-11-24 | TSLA | Stock | 2.3513 | 2.398 | 2.2887 | 2.3647 | 21375000.0 |
| 2010-11-24 | TLT | Stock | 96.81 | 96.99 | 95.58 | 95.74 | 11467563.0 |
| 2010-11-24 | ES | Stock | 31.63 | 31.85 | 31.48 | 31.85 | 1520300.0 |
| 2010-11-24 | CL | Stock | 39.005 | 39.12 | 38.66 | 38.985 | 5101600.0 |
| 2010-11-24 | A | Stock | 25.4793 | 26.0587 | 25.422 | 25.9943 | 3026530.0 |
| 2010-11-24 | AABA-DELISTED | Stock | 16.26 | 16.48 | 16.15 | 16.4 | 11424232.0 |
| 2010-11-24 | AACC-DELISTED | Stock | 5.28 | 5.46 | 5.28 | 5.45 | 10270.0 |
| 2010-11-24 | AACG | Stock | 3.66 | 3.68 | 3.66 | 3.68 | 1700.0 |
| 2010-11-24 | AAI-DELISTED | Stock | 7.44 | 7.5 | 7.43 | 7.43 | 6763049.0 |
| 2010-11-24 | AAIC-DELISTED | Stock | 23.62 | 23.62 | 23.23 | 23.42 | 22818.0 |
| 2010-11-24 | AAME | Stock | 1.87 | 1.93 | 1.75 | 1.92 | 6300.0 |
| 2010-11-24 | AAON | Stock | 4.9975 | 5.1101 | 4.964 | 5.1042 | 137194.0 |
| 2010-11-24 | AAP | Stock | 66.44 | 67.21 | 66.43 | 67.0 | 775700.0 |
| 2010-11-24 | AATI-DELISTED | Stock | 3.67 | 3.79 | 3.67 | 3.71 | 208774.0 |
| 2010-11-24 | AAU-DELISTED | Stock | 3.05 | 3.91 | 3.01 | 3.8367 | 3003556.0 |
| 2010-11-24 | AAUAF-DELISTED | Stock | 3.04 | 3.89 | 3.0 | 3.85 | 3016831.0 |
| 2010-11-24 | AAV-DELISTED | Stock | 6.66 | 6.78 | 6.66 | 6.7 | 285882.0 |
| 2010-11-24 | AAWW-DELISTED | Stock | 55.96 | 56.62 | 55.3 | 56.0 | 178275.0 |
| 2010-11-24 | AAXJ | Stock | 61.91 | 62.21 | 61.7619 | 62.17 | 314363.0 |
| 2010-11-24 | AAXN-DELISTED | Stock | 4.07 | 4.2 | 4.05 | 4.1 | 299848.0 |
| 2010-11-24 | AB | Stock | 23.09 | 23.4 | 22.97 | 23.37 | 387700.0 |
| 2010-11-24 | ABAC-DELISTED | Stock | 6.28 | 6.29 | 6.06 | 6.11 | 33272.0 |
| 2010-11-24 | ABAX-DELISTED | Stock | 26.45 | 27.12 | 26.41 | 26.95 | 134452.0 |
| 2010-11-24 | ABB-DELISTED | Stock | 19.84 | 19.99 | 19.79 | 19.97 | 5414033.0 |
| 2010-11-24 | ABBC-DELISTED | Stock | 11.83 | 11.96 | 11.8025 | 11.89 | 43868.0 |
| 2010-11-24 | ABBNY-DELISTED | Stock | 19.84 | 19.99 | 19.79 | 19.98 | 5856349.0 |
| 2010-11-24 | ABC-DELISTED | Stock | 31.01 | 31.22 | 30.74 | 30.92 | 1610281.0 |
| 2010-11-24 | ABCB | Stock | 9.74 | 9.95 | 9.74 | 9.89 | 41900.0 |
| 2010-11-24 | ABCD-DELISTED | Stock | 2.99 | 3.08 | 2.96 | 3.0 | 5852.0 |
| 2010-11-24 | ABCO-DELISTED | Stock | 23.56 | 23.89 | 23.29 | 23.88 | 77947.0 |
| 2010-11-24 | ABCW-DELISTED | Stock | 0.8507 | 0.8891 | 0.841 | 0.87 | 157730.0 |
| 2010-11-24 | ABD-DELISTED | Stock | 6.9798 | 7.32 | 6.9798 | 7.28 | 148920.0 |
| 2010-11-24 | ABE-DELISTED | Stock | 18.68 | 18.83 | 18.56 | 18.83 | 9300.0 |
| 2010-11-24 | ABEO | Stock | 3437.5 | 3687.5 | 3437.5 | 3687.5 | 9.0 |
| 2010-11-24 | ABFS-DELISTED | Stock | 24.28 | 25.24 | 24.28 | 25.19 | 148600.0 |
| 2010-11-24 | ABG | Stock | 15.58 | 16.32 | 15.58 | 16.15 | 232800.0 |
| 2010-11-24 | ABM | Stock | 23.55 | 23.7 | 23.42 | 23.67 | 245700.0 |
| 2010-11-24 | ABMD-DELISTED | Stock | 11.75 | 11.88 | 11.7 | 11.78 | 68502.0 |
| 2010-11-24 | ABR | Stock | 5.4 | 5.4 | 5.22 | 5.35 | 49800.0 |
| 2010-11-24 | ABT | Stock | 22.6514 | 22.7473 | 22.4786 | 22.5314 | 15429346.0 |
| 2010-11-24 | ABTL-DELISTED | Stock | 3.8949 | 4.0051 | 3.8549 | 4.0051 | 6339.0 |
| 2010-11-24 | ABUS | Stock | 5.47 | 5.51 | 5.25 | 5.34 | 12800.0 |
| 2010-11-24 | ABV-DELISTED | Stock | 141.25 | 142.35 | 140.2 | 141.28 | 607211.0 |
| 2010-11-24 | ABVA-DELISTED | Stock | 3.6699 | 3.6699 | 3.6699 | 3.6699 | 275.0 |
| 2010-11-24 | ABVT-DELISTED | Stock | 62.41 | 63.09 | 60.95 | 61.33 | 193750.0 |
| 2010-11-24 | ABX-DELISTED | Stock | 50.9 | 51.27 | 50.51 | 50.96 | 5362924.0 |
> showing 50 of 6,010 rows — these rows as CSV