PREVIEW / stock_daily / 2010-12-09
file: by_date/stock_daily/2010/2010-12-09.parquet size: 195 KB rows: 6,044 symbols: 3,547
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-12-09 | AAPL | Stock | 11.5046 | 11.5179 | 11.3936 | 11.42 | 294151200.0 |
| 2010-12-09 | MSFT | Stock | 27.28 | 27.34 | 27.01 | 27.08 | 47148300.0 |
| 2010-12-09 | NVDA | Stock | 0.3688 | 0.374 | 0.3635 | 0.3715 | 942408000.0 |
| 2010-12-09 | AMZN | Stock | 8.8885 | 8.9055 | 8.69 | 8.7425 | 91110000.0 |
| 2010-12-09 | TSLA | Stock | 2.1673 | 2.1813 | 2.11 | 2.1367 | 6090000.0 |
| 2010-12-09 | TLT | Stock | 93.6 | 94.27 | 92.73 | 93.72 | 17477335.0 |
| 2010-12-09 | ES | Stock | 31.45 | 31.47 | 31.14 | 31.44 | 1057400.0 |
| 2010-12-09 | CL | Stock | 39.44 | 39.55 | 39.035 | 39.095 | 4348400.0 |
| 2010-12-09 | A | Stock | 27.0744 | 27.2246 | 27.0172 | 27.2175 | 4770395.0 |
| 2010-12-09 | AABA-DELISTED | Stock | 17.14 | 17.19 | 16.8 | 16.95 | 8656803.0 |
| 2010-12-09 | AACC-DELISTED | Stock | 5.98 | 5.98 | 5.82 | 5.83 | 20422.0 |
| 2010-12-09 | AACG | Stock | 3.81 | 3.81 | 3.81 | 3.81 | 1500.0 |
| 2010-12-09 | AAI-DELISTED | Stock | 7.43 | 7.45 | 7.41 | 7.45 | 2238105.0 |
| 2010-12-09 | AAIC-DELISTED | Stock | 24.95 | 24.982 | 24.62 | 24.68 | 19108.0 |
| 2010-12-09 | AAME | Stock | 1.94 | 1.95 | 1.94 | 1.94 | 500.0 |
| 2010-12-09 | AAON | Stock | 5.839 | 5.839 | 5.7047 | 5.7817 | 270844.0 |
| 2010-12-09 | AAP | Stock | 67.9 | 68.24 | 67.64 | 67.87 | 337900.0 |
| 2010-12-09 | AATI-DELISTED | Stock | 3.9 | 3.92 | 3.86 | 3.91 | 135260.0 |
| 2010-12-09 | AAU-DELISTED | Stock | 4.25 | 4.28 | 4.0 | 4.11 | 307625.0 |
| 2010-12-09 | AAUAF-DELISTED | Stock | 4.25 | 4.28 | 4.0 | 4.12 | 308065.0 |
| 2010-12-09 | AAV-DELISTED | Stock | 6.42 | 6.59 | 6.42 | 6.59 | 303121.0 |
| 2010-12-09 | AAWW-DELISTED | Stock | 59.69 | 59.85 | 59.09 | 59.3 | 134883.0 |
| 2010-12-09 | AAXJ | Stock | 63.04 | 63.23 | 62.86 | 63.01 | 1354657.0 |
| 2010-12-09 | AAXN-DELISTED | Stock | 4.84 | 4.85 | 4.53 | 4.55 | 1150039.0 |
| 2010-12-09 | AB | Stock | 23.64 | 23.9 | 23.6 | 23.65 | 372900.0 |
| 2010-12-09 | ABAC-DELISTED | Stock | 5.22 | 5.22 | 4.96 | 5.17 | 29073.0 |
| 2010-12-09 | ABAX-DELISTED | Stock | 28.49 | 28.49 | 27.94 | 27.96 | 110307.0 |
| 2010-12-09 | ABB-DELISTED | Stock | 20.7 | 20.81 | 20.53 | 20.8 | 2109489.0 |
| 2010-12-09 | ABBC-DELISTED | Stock | 12.0 | 12.0 | 11.72 | 11.87 | 59837.0 |
| 2010-12-09 | ABBNY-DELISTED | Stock | 20.7 | 20.81 | 20.53 | 20.81 | 2123635.0 |
| 2010-12-09 | ABC-DELISTED | Stock | 31.91 | 32.11 | 31.58 | 31.73 | 1337191.0 |
| 2010-12-09 | ABCB | Stock | 9.82 | 9.97 | 9.67 | 9.96 | 43000.0 |
| 2010-12-09 | ABCD-DELISTED | Stock | 3.23 | 3.35 | 3.19 | 3.24 | 28749.0 |
| 2010-12-09 | ABCO-DELISTED | Stock | 24.87 | 24.88 | 24.35 | 24.39 | 88296.0 |
| 2010-12-09 | ABCW-DELISTED | Stock | 1.3207 | 1.35 | 1.311 | 1.35 | 201590.0 |
| 2010-12-09 | ABD-DELISTED | Stock | 8.0 | 8.282 | 7.77 | 8.22 | 631850.0 |
| 2010-12-09 | ABE-DELISTED | Stock | 18.88 | 18.9 | 18.53 | 18.714 | 28197.0 |
| 2010-12-09 | ABEO | Stock | 3187.5 | 4225.0 | 3187.5 | 4112.5 | 100.0 |
| 2010-12-09 | ABFS-DELISTED | Stock | 28.49 | 28.53 | 28.0 | 28.165 | 167053.0 |
| 2010-12-09 | ABG | Stock | 17.19 | 17.19 | 16.95 | 17.04 | 109500.0 |
| 2010-12-09 | ABM | Stock | 24.17 | 25.24 | 24.06 | 24.77 | 750200.0 |
| 2010-12-09 | ABMD-DELISTED | Stock | 9.41 | 9.5 | 9.32 | 9.43 | 492590.0 |
| 2010-12-09 | ABR | Stock | 5.49 | 5.89 | 5.45 | 5.59 | 77300.0 |
| 2010-12-09 | ABT | Stock | 22.4834 | 22.6466 | 22.4306 | 22.613 | 16280325.0 |
| 2010-12-09 | ABTL-DELISTED | Stock | 4.1512 | 4.1769 | 3.9985 | 4.1 | 17277.0 |
| 2010-12-09 | ABUS | Stock | 4.79 | 4.8 | 4.78 | 4.8 | 5300.0 |
| 2010-12-09 | ABV-DELISTED | Stock | 140.95 | 141.14 | 137.82 | 139.55 | 426297.0 |
| 2010-12-09 | ABVA-DELISTED | Stock | 3.5 | 3.59 | 3.5 | 3.59 | 500.0 |
| 2010-12-09 | ABVT-DELISTED | Stock | 57.5 | 57.95 | 56.89 | 57.23 | 92854.0 |
| 2010-12-09 | ABX-DELISTED | Stock | 53.74 | 53.74 | 52.84 | 53.34 | 5953905.0 |
> showing 50 of 6,044 rows — these rows as CSV