PREVIEW / stock_daily / 2012-12-10
file: by_date/stock_daily/2012/2012-12-10.parquet size: 202 KB rows: 6,244 symbols: 3,526
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 |
|---|---|---|---|---|---|---|---|
| 2012-12-10 | AAPL | Stock | 18.75 | 19.2325 | 18.6279 | 18.9221 | 630484400.0 |
| 2012-12-10 | MSFT | Stock | 26.56 | 26.97 | 26.52 | 26.94 | 47031100.0 |
| 2012-12-10 | NVDA | Stock | 0.299 | 0.3113 | 0.2982 | 0.309 | 513644000.0 |
| 2012-12-10 | AMZN | Stock | 12.655 | 12.739 | 12.365 | 12.3885 | 70076000.0 |
| 2012-12-10 | META | Stock | 27.17 | 28.17 | 27.1 | 27.84 | 50608500.0 |
| 2012-12-10 | TSLA | Stock | 2.2953 | 2.32 | 2.2787 | 2.3047 | 13947000.0 |
| 2012-12-10 | TLT | Stock | 124.96 | 125.0801 | 124.54 | 124.98 | 2134231.0 |
| 2012-12-10 | ES | Stock | 39.08 | 39.32 | 38.95 | 39.14 | 1349700.0 |
| 2012-12-10 | CL | Stock | 53.825 | 54.18 | 53.315 | 53.395 | 3695800.0 |
| 2012-12-10 | A | Stock | 27.0386 | 27.6466 | 26.9742 | 27.5823 | 4262222.0 |
| 2012-12-10 | AABA-DELISTED | Stock | 19.18 | 19.47 | 19.15 | 19.44 | 23784460.0 |
| 2012-12-10 | AACC-DELISTED | Stock | 4.77 | 4.77 | 4.511 | 4.55 | 13499.0 |
| 2012-12-10 | AACG | Stock | 3.99 | 3.99 | 3.71 | 3.72 | 8200.0 |
| 2012-12-10 | AAIC-DELISTED | Stock | 21.82 | 22.13 | 21.75 | 22.06 | 154135.0 |
| 2012-12-10 | AAME | Stock | 2.94 | 2.94 | 2.91 | 2.94 | 400.0 |
| 2012-12-10 | AAMRQ-DELISTED | Stock | 0.5747 | 0.61 | 0.54 | 0.575 | 6733626.0 |
| 2012-12-10 | AAON | Stock | 6.2104 | 6.2104 | 6.0474 | 6.1215 | 213975.0 |
| 2012-12-10 | AAP | Stock | 71.13 | 72.95 | 71.06 | 72.7 | 643500.0 |
| 2012-12-10 | AAT | Stock | 27.2 | 27.34 | 26.96 | 27.09 | 57500.0 |
| 2012-12-10 | AAU-DELISTED | Stock | 3.0814 | 3.23 | 3.0715 | 3.22 | 276655.0 |
| 2012-12-10 | AAUAF-DELISTED | Stock | 3.11 | 3.249 | 3.09 | 3.22 | 275444.0 |
| 2012-12-10 | AAV-DELISTED | Stock | 3.25 | 3.36 | 3.21 | 3.31 | 225856.0 |
| 2012-12-10 | AAWW-DELISTED | Stock | 42.49 | 42.81 | 42.4201 | 42.72 | 241455.0 |
| 2012-12-10 | AAXJ | Stock | 59.0 | 59.57 | 58.99 | 59.43 | 184024.0 |
| 2012-12-10 | AAXN-DELISTED | Stock | 8.14 | 8.35 | 8.14 | 8.2 | 304902.0 |
| 2012-12-10 | AB | Stock | 16.78 | 16.95 | 16.52 | 16.78 | 470300.0 |
| 2012-12-10 | ABAC-DELISTED | Stock | 0.92 | 0.972 | 0.9 | 0.96 | 22798.0 |
| 2012-12-10 | ABAX-DELISTED | Stock | 38.13 | 38.74 | 37.9 | 38.21 | 96583.0 |
| 2012-12-10 | ABB-DELISTED | Stock | 19.69 | 19.9 | 19.69 | 19.85 | 1362570.0 |
| 2012-12-10 | ABBNY-DELISTED | Stock | 19.7 | 19.9 | 19.69 | 19.84 | 1385601.0 |
| 2012-12-10 | ABC-DELISTED | Stock | 42.31 | 42.5 | 42.14 | 42.24 | 2483642.0 |
| 2012-12-10 | ABCB | Stock | 11.72 | 11.75 | 11.6 | 11.68 | 56100.0 |
| 2012-12-10 | ABCD-DELISTED | Stock | 1.2 | 1.2 | 1.0 | 1.01 | 30579.0 |
| 2012-12-10 | ABCO-DELISTED | Stock | 48.57 | 49.05 | 48.08 | 48.35 | 235178.0 |
| 2012-12-10 | ABCW-DELISTED | Stock | 0.39 | 0.39 | 0.37 | 0.37 | 27986.0 |
| 2012-12-10 | ABE-DELISTED | Stock | 20.43 | 20.6 | 20.331 | 20.514 | 12630.0 |
| 2012-12-10 | ABEO | Stock | 337.5 | 337.5 | 300.0 | 300.0 | 80.0 |
| 2012-12-10 | ABFS-DELISTED | Stock | 8.68 | 9.21 | 8.57 | 9.07 | 802986.0 |
| 2012-12-10 | ABG | Stock | 30.68 | 30.91 | 30.28 | 30.53 | 291700.0 |
| 2012-12-10 | ABM | Stock | 19.55 | 19.97 | 19.53 | 19.73 | 400200.0 |
| 2012-12-10 | ABMD-DELISTED | Stock | 12.42 | 13.65 | 12.42 | 13.47 | 1179297.0 |
| 2012-12-10 | ABR | Stock | 5.18 | 5.18 | 5.06 | 5.08 | 126700.0 |
| 2012-12-10 | ABT | Stock | 31.2206 | 31.6428 | 31.0575 | 31.3453 | 15309712.0 |
| 2012-12-10 | ABTL-DELISTED | Stock | 3.77 | 3.7926 | 3.757 | 3.757 | 20359.0 |
| 2012-12-10 | ABUS | Stock | 5.25 | 5.25 | 4.99 | 5.16 | 41500.0 |
| 2012-12-10 | ABV-DELISTED | Stock | 41.96 | 42.9 | 41.94 | 42.35 | 1777667.0 |
| 2012-12-10 | ABVA-DELISTED | Stock | 4.79 | 4.97 | 4.78 | 4.86 | 3481.0 |
| 2012-12-10 | ABX-DELISTED | Stock | 33.83 | 34.31 | 33.8 | 34.19 | 5024776.0 |
| 2012-12-10 | ACAD | Stock | 4.5 | 4.53 | 4.17 | 4.18 | 3371500.0 |
| 2012-12-10 | ACAS-DELISTED | Stock | 11.85 | 12.09 | 11.83 | 12.03 | 3475405.0 |
> showing 50 of 6,244 rows — these rows as CSV