PREVIEW / stock_daily / 2011-02-17
file: by_date/stock_daily/2011/2011-02-17.parquet size: 198 KB rows: 6,082 symbols: 3,555
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 |
|---|---|---|---|---|---|---|---|
| 2011-02-17 | AAPL | Stock | 12.7589 | 12.8668 | 12.7329 | 12.7964 | 530583200.0 |
| 2011-02-17 | MSFT | Stock | 26.97 | 27.37 | 26.91 | 27.21 | 57207300.0 |
| 2011-02-17 | NVDA | Stock | 0.568 | 0.6503 | 0.5652 | 0.642 | 3470096000.0 |
| 2011-02-17 | AMZN | Stock | 9.2885 | 9.4545 | 9.2655 | 9.388 | 68510000.0 |
| 2011-02-17 | TSLA | Stock | 1.642 | 1.6993 | 1.57 | 1.5733 | 39276000.0 |
| 2011-02-17 | TLT | Stock | 90.02 | 90.18 | 89.66 | 89.77 | 6740716.0 |
| 2011-02-17 | ES | Stock | 33.49 | 33.78 | 33.42 | 33.62 | 873500.0 |
| 2011-02-17 | CL | Stock | 39.12 | 39.2 | 38.99 | 39.2 | 4111000.0 |
| 2011-02-17 | A | Stock | 31.03 | 31.4735 | 30.7725 | 31.4163 | 3665276.0 |
| 2011-02-17 | AABA-DELISTED | Stock | 17.71 | 17.82 | 17.5 | 17.77 | 23128632.0 |
| 2011-02-17 | AACC-DELISTED | Stock | 5.55 | 5.74 | 5.53 | 5.71 | 27508.0 |
| 2011-02-17 | AACG | Stock | 4.38 | 4.4 | 4.37 | 4.4 | 2700.0 |
| 2011-02-17 | AAI-DELISTED | Stock | 7.4 | 7.43 | 7.39 | 7.41 | 1119658.0 |
| 2011-02-17 | AAIC-DELISTED | Stock | 27.9 | 28.58 | 27.81 | 28.43 | 52544.0 |
| 2011-02-17 | AAME | Stock | 2.1 | 2.11 | 2.1 | 2.11 | 1600.0 |
| 2011-02-17 | AAON | Stock | 5.9378 | 6.0267 | 5.8489 | 6.003 | 273375.0 |
| 2011-02-17 | AAP | Stock | 64.0 | 64.0 | 62.74 | 62.81 | 1494600.0 |
| 2011-02-17 | AAT | Stock | 21.3 | 21.89 | 21.3 | 21.54 | 146600.0 |
| 2011-02-17 | AATI-DELISTED | Stock | 4.26 | 4.29 | 4.22 | 4.27 | 310392.0 |
| 2011-02-17 | AAU-DELISTED | Stock | 4.33 | 4.57 | 4.33 | 4.5268 | 382137.0 |
| 2011-02-17 | AAUAF-DELISTED | Stock | 4.33 | 4.57 | 4.33 | 4.51 | 382797.0 |
| 2011-02-17 | AAV-DELISTED | Stock | 7.84 | 7.89 | 7.72 | 7.81 | 392825.0 |
| 2011-02-17 | AAWW-DELISTED | Stock | 69.17 | 71.24 | 69.0 | 71.04 | 310601.0 |
| 2011-02-17 | AAXJ | Stock | 61.18 | 61.44 | 61.01 | 61.44 | 219561.0 |
| 2011-02-17 | AAXN-DELISTED | Stock | 4.26 | 4.34 | 4.09 | 4.25 | 378497.0 |
| 2011-02-17 | AB | Stock | 22.38 | 22.86 | 22.32 | 22.76 | 842100.0 |
| 2011-02-17 | ABAC-DELISTED | Stock | 4.11 | 4.11 | 4.03 | 4.06 | 128937.0 |
| 2011-02-17 | ABAX-DELISTED | Stock | 27.06 | 27.1 | 26.6 | 26.84 | 102277.0 |
| 2011-02-17 | ABB-DELISTED | Stock | 23.8 | 23.83 | 23.5 | 23.62 | 3695532.0 |
| 2011-02-17 | ABBC-DELISTED | Stock | 13.08 | 13.13 | 12.96 | 13.1 | 131990.0 |
| 2011-02-17 | ABBNY-DELISTED | Stock | 23.8 | 23.83 | 23.5 | 23.63 | 3695532.0 |
| 2011-02-17 | ABC-DELISTED | Stock | 36.38 | 37.51 | 35.49 | 37.43 | 3571240.0 |
| 2011-02-17 | ABCB | Stock | 9.93 | 9.93 | 9.75 | 9.83 | 60800.0 |
| 2011-02-17 | ABCD-DELISTED | Stock | 3.88 | 3.88 | 3.81 | 3.86 | 8212.0 |
| 2011-02-17 | ABCO-DELISTED | Stock | 26.0 | 26.41 | 26.0 | 26.13 | 142892.0 |
| 2011-02-17 | ABCW-DELISTED | Stock | 1.16 | 1.19 | 1.1 | 1.1 | 289320.0 |
| 2011-02-17 | ABD-DELISTED | Stock | 9.18 | 9.23 | 9.01 | 9.12 | 173650.0 |
| 2011-02-17 | ABE-DELISTED | Stock | 18.09 | 18.302 | 18.09 | 18.18 | 6204.0 |
| 2011-02-17 | ABEO | Stock | 3087.5 | 3087.5 | 2937.5 | 3000.0 | 11.0 |
| 2011-02-17 | ABFS-DELISTED | Stock | 25.53 | 25.62 | 25.26 | 25.26 | 181400.0 |
| 2011-02-17 | ABG | Stock | 18.77 | 18.8 | 18.33 | 18.45 | 790400.0 |
| 2011-02-17 | ABH-DELISTED | Stock | 29.62 | 29.64 | 29.28 | 29.5 | 343218.0 |
| 2011-02-17 | ABM | Stock | 26.52 | 26.87 | 26.5 | 26.7 | 108200.0 |
| 2011-02-17 | ABMD-DELISTED | Stock | 13.27 | 13.36 | 13.1 | 13.24 | 147320.0 |
| 2011-02-17 | ABR | Stock | 6.61 | 6.66 | 6.57 | 6.63 | 34100.0 |
| 2011-02-17 | ABT | Stock | 22.1812 | 22.2723 | 22.0996 | 22.2243 | 14300542.0 |
| 2011-02-17 | ABTL-DELISTED | Stock | 5.5965 | 6.4614 | 5.5965 | 5.8 | 124141.0 |
| 2011-02-17 | ABUS | Stock | 5.22 | 5.25 | 5.19 | 5.19 | 5500.0 |
| 2011-02-17 | ABV-DELISTED | Stock | 27.24 | 27.73 | 27.21 | 27.63 | 2059783.0 |
| 2011-02-17 | ABVA-DELISTED | Stock | 4.99 | 5.0 | 4.85 | 4.85 | 650.0 |
> showing 50 of 6,082 rows — these rows as CSV