PREVIEW / stock_daily / 2011-02-14
file: by_date/stock_daily/2011/2011-02-14.parquet size: 198 KB rows: 6,120 symbols: 3,576
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-14 | AAPL | Stock | 12.7425 | 12.8386 | 12.7396 | 12.8279 | 310416400.0 |
| 2011-02-14 | MSFT | Stock | 27.21 | 27.27 | 26.95 | 27.23 | 56766200.0 |
| 2011-02-14 | NVDA | Stock | 0.5938 | 0.6125 | 0.5755 | 0.5778 | 1287828000.0 |
| 2011-02-14 | AMZN | Stock | 9.4625 | 9.57 | 9.4175 | 9.521 | 81226000.0 |
| 2011-02-14 | TSLA | Stock | 1.576 | 1.6093 | 1.5367 | 1.5387 | 19246500.0 |
| 2011-02-14 | TLT | Stock | 89.31 | 89.93 | 89.31 | 89.521 | 8034044.0 |
| 2011-02-14 | ES | Stock | 33.58 | 33.59 | 33.14 | 33.4 | 1108500.0 |
| 2011-02-14 | CL | Stock | 39.42 | 39.84 | 39.205 | 39.505 | 9117400.0 |
| 2011-02-14 | A | Stock | 32.1888 | 32.4893 | 31.9886 | 32.0386 | 4865320.0 |
| 2011-02-14 | AABA-DELISTED | Stock | 16.84 | 16.93 | 16.72 | 16.88 | 14253276.0 |
| 2011-02-14 | AACC-DELISTED | Stock | 6.07 | 6.0819 | 6.01 | 6.02 | 8893.0 |
| 2011-02-14 | AACG | Stock | 4.18 | 4.25 | 4.17 | 4.25 | 8600.0 |
| 2011-02-14 | AAI-DELISTED | Stock | 7.41 | 7.43 | 7.39 | 7.39 | 1099987.0 |
| 2011-02-14 | AAIC-DELISTED | Stock | 26.16 | 26.39 | 26.09 | 26.32 | 27720.0 |
| 2011-02-14 | AAME | Stock | 2.16 | 2.16 | 2.07 | 2.1 | 3400.0 |
| 2011-02-14 | AAON | Stock | 5.683 | 5.7975 | 5.6138 | 5.76 | 116944.0 |
| 2011-02-14 | AAP | Stock | 64.95 | 65.0 | 63.5 | 63.78 | 1332400.0 |
| 2011-02-14 | AAT | Stock | 21.21 | 21.55 | 21.15 | 21.35 | 154900.0 |
| 2011-02-14 | AATI-DELISTED | Stock | 4.21 | 4.29 | 4.12 | 4.28 | 190591.0 |
| 2011-02-14 | AAU-DELISTED | Stock | 3.93 | 4.454 | 3.83 | 4.43 | 1373608.0 |
| 2011-02-14 | AAUAF-DELISTED | Stock | 3.93 | 4.454 | 3.83 | 4.42 | 1374808.0 |
| 2011-02-14 | AAV-DELISTED | Stock | 7.75 | 7.87 | 7.72 | 7.77 | 348484.0 |
| 2011-02-14 | AAWW-DELISTED | Stock | 60.48 | 66.88 | 59.8 | 63.78 | 1518881.0 |
| 2011-02-14 | AAXJ | Stock | 60.66 | 60.91 | 60.64 | 60.64 | 1028306.0 |
| 2011-02-14 | AAXN-DELISTED | Stock | 4.03 | 4.22 | 4.0 | 4.1 | 441857.0 |
| 2011-02-14 | AB | Stock | 22.19 | 22.8 | 22.11 | 22.74 | 767800.0 |
| 2011-02-14 | ABAC-DELISTED | Stock | 4.06 | 4.09 | 3.95 | 3.99 | 206684.0 |
| 2011-02-14 | ABAX-DELISTED | Stock | 26.31 | 27.02 | 26.09 | 27.02 | 35041.0 |
| 2011-02-14 | ABB-DELISTED | Stock | 23.69 | 23.91 | 23.68 | 23.81 | 2449240.0 |
| 2011-02-14 | ABBC-DELISTED | Stock | 12.98 | 13.12 | 12.89 | 13.11 | 147565.0 |
| 2011-02-14 | ABBNY-DELISTED | Stock | 23.69 | 23.91 | 23.68 | 23.82 | 2601040.0 |
| 2011-02-14 | ABC-DELISTED | Stock | 36.57 | 36.89 | 36.52 | 36.88 | 1720360.0 |
| 2011-02-14 | ABCB | Stock | 9.9 | 10.13 | 9.89 | 10.06 | 18700.0 |
| 2011-02-14 | ABCD-DELISTED | Stock | 3.93 | 3.93 | 3.82 | 3.85 | 33745.0 |
| 2011-02-14 | ABCO-DELISTED | Stock | 25.35 | 26.15 | 25.35 | 25.96 | 162844.0 |
| 2011-02-14 | ABCW-DELISTED | Stock | 1.28 | 1.32 | 1.28 | 1.29 | 52960.0 |
| 2011-02-14 | ABD-DELISTED | Stock | 8.86 | 9.12 | 8.82 | 8.98 | 316160.0 |
| 2011-02-14 | ABE-DELISTED | Stock | 18.02 | 18.23 | 18.02 | 18.08 | 12717.0 |
| 2011-02-14 | ABEO | Stock | 3000.0 | 3012.5 | 2862.5 | 3000.0 | 21.0 |
| 2011-02-14 | ABFS-DELISTED | Stock | 24.95 | 25.1798 | 24.86 | 24.93 | 57329.0 |
| 2011-02-14 | ABG | Stock | 20.0 | 20.0 | 19.53 | 19.59 | 69500.0 |
| 2011-02-14 | ABH-DELISTED | Stock | 29.96 | 30.54 | 29.66 | 29.96 | 3427456.0 |
| 2011-02-14 | ABM | Stock | 26.68 | 26.99 | 26.68 | 26.94 | 95100.0 |
| 2011-02-14 | ABMD-DELISTED | Stock | 13.43 | 13.58 | 13.4 | 13.5 | 110902.0 |
| 2011-02-14 | ABR | Stock | 6.63 | 6.65 | 6.45 | 6.61 | 27900.0 |
| 2011-02-14 | ABT | Stock | 21.9365 | 22.0948 | 21.8789 | 22.0612 | 17675698.0 |
| 2011-02-14 | ABTL-DELISTED | Stock | 4.8 | 4.85 | 4.7475 | 4.8 | 6523.0 |
| 2011-02-14 | ABUS | Stock | 5.25 | 5.28 | 5.15 | 5.25 | 7400.0 |
| 2011-02-14 | ABV-DELISTED | Stock | 26.76 | 26.8 | 26.162 | 26.5 | 3134426.0 |
| 2011-02-14 | ABVA-DELISTED | Stock | 4.6601 | 4.68 | 4.52 | 4.6 | 17285.0 |
> showing 50 of 6,120 rows — these rows as CSV