PREVIEW / stock_daily / 2011-12-30
file: by_date/stock_daily/2011/2011-12-30.parquet size: 200 KB rows: 6,249 symbols: 3,620
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-12-30 | AAPL | Stock | 14.4111 | 14.51 | 14.4104 | 14.4643 | 179662000.0 |
| 2011-12-30 | MSFT | Stock | 26.0 | 26.12 | 25.91 | 25.96 | 27395700.0 |
| 2011-12-30 | NVDA | Stock | 0.348 | 0.3518 | 0.346 | 0.3465 | 186956000.0 |
| 2011-12-30 | AMZN | Stock | 8.668 | 8.7585 | 8.6245 | 8.655 | 85596000.0 |
| 2011-12-30 | TSLA | Stock | 1.8993 | 1.932 | 1.8833 | 1.904 | 5097000.0 |
| 2011-12-30 | TLT | Stock | 121.11 | 121.76 | 120.8872 | 121.25 | 5948796.0 |
| 2011-12-30 | ES | Stock | 36.23 | 36.4 | 36.06 | 36.07 | 955800.0 |
| 2011-12-30 | CL | Stock | 46.4 | 46.545 | 46.05 | 46.195 | 2985400.0 |
| 2011-12-30 | A | Stock | 24.9857 | 25.4006 | 24.907 | 24.9857 | 1930918.0 |
| 2011-12-30 | AABA-DELISTED | Stock | 16.18 | 16.21 | 16.03 | 16.12 | 9375593.0 |
| 2011-12-30 | AACC-DELISTED | Stock | 3.84 | 4.32 | 3.83 | 3.9 | 18931.0 |
| 2011-12-30 | AACG | Stock | 7.51 | 7.51 | 7.31 | 7.5 | 1600.0 |
| 2011-12-30 | AAIC-DELISTED | Stock | 22.07 | 22.19 | 21.27 | 21.33 | 67758.0 |
| 2011-12-30 | AAME | Stock | 1.99 | 1.99 | 1.97 | 1.97 | 8300.0 |
| 2011-12-30 | AAON | Stock | 6.1363 | 6.2074 | 6.0563 | 6.0711 | 202838.0 |
| 2011-12-30 | AAP | Stock | 70.02 | 70.53 | 69.6 | 69.63 | 452500.0 |
| 2011-12-30 | AAT | Stock | 20.75 | 21.12 | 20.45 | 20.51 | 246200.0 |
| 2011-12-30 | AATI-DELISTED | Stock | 5.78 | 5.79 | 5.77 | 5.78 | 657335.0 |
| 2011-12-30 | AAU-DELISTED | Stock | 2.44 | 2.536 | 2.44 | 2.52 | 130445.0 |
| 2011-12-30 | AAUAF-DELISTED | Stock | 2.44 | 2.536 | 2.44 | 2.52 | 130745.0 |
| 2011-12-30 | AAV-DELISTED | Stock | 4.07 | 4.22 | 4.07 | 4.15 | 284587.0 |
| 2011-12-30 | AAWW-DELISTED | Stock | 38.43 | 38.63 | 38.17 | 38.42 | 126175.0 |
| 2011-12-30 | AAXJ | Stock | 49.84 | 50.0 | 49.69 | 49.9 | 455988.0 |
| 2011-12-30 | AAXN-DELISTED | Stock | 5.36 | 5.38 | 5.11 | 5.12 | 664022.0 |
| 2011-12-30 | AB | Stock | 13.13 | 13.29 | 13.01 | 13.08 | 347900.0 |
| 2011-12-30 | ABAC-DELISTED | Stock | 1.3 | 1.31 | 1.23 | 1.26 | 59189.0 |
| 2011-12-30 | ABAX-DELISTED | Stock | 27.63 | 27.86 | 27.548 | 27.69 | 91058.0 |
| 2011-12-30 | ABB-DELISTED | Stock | 18.79 | 18.99 | 18.71 | 18.83 | 1464101.0 |
| 2011-12-30 | ABBNY-DELISTED | Stock | 18.79 | 18.99 | 18.71 | 18.83 | 1465466.0 |
| 2011-12-30 | ABC-DELISTED | Stock | 37.43 | 37.44 | 37.17 | 37.18 | 832263.0 |
| 2011-12-30 | ABCB | Stock | 10.32 | 10.35 | 10.17 | 10.28 | 35300.0 |
| 2011-12-30 | ABCD-DELISTED | Stock | 3.11 | 3.12 | 3.0 | 3.0 | 15544.0 |
| 2011-12-30 | ABCO-DELISTED | Stock | 36.83 | 37.7 | 36.56 | 37.09 | 147949.0 |
| 2011-12-30 | ABCW-DELISTED | Stock | 0.3364 | 0.3615 | 0.3364 | 0.3374 | 157730.0 |
| 2011-12-30 | ABD-DELISTED | Stock | 9.75 | 9.91 | 9.63 | 9.65 | 261240.0 |
| 2011-12-30 | ABE-DELISTED | Stock | 17.55 | 17.57 | 17.5 | 17.53 | 20273.0 |
| 2011-12-30 | ABEO | Stock | 1600.0 | 1800.0 | 1450.0 | 1800.0 | 111.0 |
| 2011-12-30 | ABFS-DELISTED | Stock | 19.25 | 19.5 | 19.16 | 19.26 | 295356.0 |
| 2011-12-30 | ABG | Stock | 21.4 | 21.73 | 21.24 | 21.56 | 201100.0 |
| 2011-12-30 | ABH-DELISTED | Stock | 14.48 | 14.59 | 14.48 | 14.55 | 95078.0 |
| 2011-12-30 | ABM | Stock | 20.74 | 20.87 | 20.62 | 20.62 | 209300.0 |
| 2011-12-30 | ABMD-DELISTED | Stock | 18.32 | 18.61 | 18.22 | 18.47 | 163385.0 |
| 2011-12-30 | ABR | Stock | 3.57 | 3.65 | 3.52 | 3.52 | 69800.0 |
| 2011-12-30 | ABT | Stock | 26.9024 | 27.0799 | 26.9024 | 26.9792 | 8582326.0 |
| 2011-12-30 | ABTL-DELISTED | Stock | 3.7495 | 3.7495 | 3.4005 | 3.5005 | 70104.0 |
| 2011-12-30 | ABUS | Stock | 1.49 | 1.55 | 1.49 | 1.5 | 18000.0 |
| 2011-12-30 | ABV-DELISTED | Stock | 36.1 | 36.39 | 35.96 | 36.07 | 1106162.0 |
| 2011-12-30 | ABVA-DELISTED | Stock | 3.41 | 3.48 | 3.41 | 3.48 | 3365.0 |
| 2011-12-30 | ABVT-DELISTED | Stock | 64.73 | 65.07 | 64.43 | 65.01 | 167201.0 |
| 2011-12-30 | ABX-DELISTED | Stock | 45.6 | 45.96 | 45.14 | 45.27 | 4359703.0 |
> showing 50 of 6,249 rows — these rows as CSV