PREVIEW / stock_daily / 2013-01-14
file: by_date/stock_daily/2013/2013-01-14.parquet size: 204 KB rows: 6,220 symbols: 3,484
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 |
|---|---|---|---|---|---|---|---|
| 2013-01-14 | AAPL | Stock | 17.9529 | 18.125 | 17.8039 | 17.9196 | 734207600.0 |
| 2013-01-14 | MSFT | Stock | 26.9 | 27.08 | 26.76 | 26.89 | 48324400.0 |
| 2013-01-14 | NVDA | Stock | 0.3073 | 0.3073 | 0.3015 | 0.305 | 305684000.0 |
| 2013-01-14 | AMZN | Stock | 13.4 | 13.713 | 13.377 | 13.6365 | 85500000.0 |
| 2013-01-14 | META | Stock | 32.08 | 32.21 | 30.62 | 30.95 | 98892800.0 |
| 2013-01-14 | TSLA | Stock | 2.2053 | 2.2253 | 2.19 | 2.2173 | 13876500.0 |
| 2013-01-14 | TLT | Stock | 120.04 | 120.28 | 119.37 | 119.52 | 3067158.0 |
| 2013-01-14 | ES | Stock | 39.21 | 39.34 | 38.97 | 39.04 | 1988500.0 |
| 2013-01-14 | CL | Stock | 53.655 | 54.06 | 53.5 | 53.965 | 1464400.0 |
| 2013-01-14 | A | Stock | 31.0658 | 31.1445 | 30.6795 | 31.1445 | 3229100.0 |
| 2013-01-14 | AABA-DELISTED | Stock | 19.33 | 19.54 | 19.25 | 19.43 | 13804991.0 |
| 2013-01-14 | AACC-DELISTED | Stock | 4.58 | 4.59 | 4.5 | 4.58 | 24504.0 |
| 2013-01-14 | AACG | Stock | 5.89 | 5.89 | 5.88 | 5.88 | 200.0 |
| 2013-01-14 | AAIC-DELISTED | Stock | 22.37 | 22.9 | 22.25 | 22.69 | 134088.0 |
| 2013-01-14 | AAMC-DELISTED | Stock | 32.6471 | 35.2941 | 32.3529 | 34.7059 | 142518.0 |
| 2013-01-14 | AAME | Stock | 3.24 | 3.24 | 3.24 | 3.24 | 800.0 |
| 2013-01-14 | AAMRQ-DELISTED | Stock | 1.57 | 1.66 | 1.34 | 1.44 | 24316283.0 |
| 2013-01-14 | AAON | Stock | 6.5837 | 6.7081 | 6.5333 | 6.7022 | 533925.0 |
| 2013-01-14 | AAP | Stock | 72.02 | 72.83 | 71.9 | 72.58 | 663200.0 |
| 2013-01-14 | AAT | Stock | 28.26 | 28.53 | 28.13 | 28.4 | 85900.0 |
| 2013-01-14 | AAU-DELISTED | Stock | 3.06 | 3.07 | 3.01 | 3.04 | 60051.0 |
| 2013-01-14 | AAUAF-DELISTED | Stock | 3.07 | 3.08 | 3.02 | 3.03 | 64293.0 |
| 2013-01-14 | AAV-DELISTED | Stock | 3.12 | 3.12 | 3.07 | 3.11 | 278484.0 |
| 2013-01-14 | AAWW-DELISTED | Stock | 45.29 | 45.46 | 44.5 | 44.79 | 171952.0 |
| 2013-01-14 | AAXJ | Stock | 61.07 | 61.07 | 60.66 | 60.95 | 278918.0 |
| 2013-01-14 | AAXN-DELISTED | Stock | 9.41 | 9.49 | 9.2 | 9.22 | 596961.0 |
| 2013-01-14 | AB | Stock | 19.96 | 20.13 | 19.84 | 19.99 | 380000.0 |
| 2013-01-14 | ABAC-DELISTED | Stock | 0.871 | 0.9 | 0.871 | 0.9 | 8700.0 |
| 2013-01-14 | ABAX-DELISTED | Stock | 39.8 | 39.825 | 38.75 | 38.96 | 63908.0 |
| 2013-01-14 | ABB-DELISTED | Stock | 21.27 | 21.32 | 21.15 | 21.2 | 1277455.0 |
| 2013-01-14 | ABBNY-DELISTED | Stock | 21.27 | 21.32 | 21.15 | 21.18 | 1312334.0 |
| 2013-01-14 | ABBV | Stock | 34.01 | 34.25 | 33.8 | 34.09 | 11584900.0 |
| 2013-01-14 | ABC-DELISTED | Stock | 43.99 | 44.37 | 43.8 | 44.31 | 1352031.0 |
| 2013-01-14 | ABCB | Stock | 12.82 | 12.93 | 12.68 | 12.8 | 24200.0 |
| 2013-01-14 | ABCD-DELISTED | Stock | 1.16 | 1.2 | 1.11 | 1.19 | 18612.0 |
| 2013-01-14 | ABCO-DELISTED | Stock | 51.48 | 53.03 | 51.14 | 52.63 | 173915.0 |
| 2013-01-14 | ABCW-DELISTED | Stock | 0.42 | 0.48 | 0.42 | 0.43 | 47100.0 |
| 2013-01-14 | ABE-DELISTED | Stock | 21.9 | 22.01 | 21.7601 | 21.949 | 8152.0 |
| 2013-01-14 | ABEO | Stock | 337.5 | 350.0 | 312.5 | 350.0 | 8.0 |
| 2013-01-14 | ABFS-DELISTED | Stock | 10.06 | 10.25 | 9.91 | 10.01 | 417794.0 |
| 2013-01-14 | ABG | Stock | 32.88 | 32.92 | 31.64 | 32.39 | 354800.0 |
| 2013-01-14 | ABM | Stock | 20.45 | 20.58 | 20.41 | 20.51 | 374200.0 |
| 2013-01-14 | ABMD-DELISTED | Stock | 12.19 | 12.41 | 12.0 | 12.33 | 939071.0 |
| 2013-01-14 | ABR | Stock | 6.84 | 7.25 | 6.74 | 6.95 | 502600.0 |
| 2013-01-14 | ABT | Stock | 33.48 | 33.57 | 33.14 | 33.36 | 6848700.0 |
| 2013-01-14 | ABTL-DELISTED | Stock | 3.94 | 3.95 | 3.91 | 3.95 | 20937.0 |
| 2013-01-14 | ABUS | Stock | 5.38 | 5.43 | 5.26 | 5.36 | 17900.0 |
| 2013-01-14 | ABV-DELISTED | Stock | 42.83 | 43.16 | 42.63 | 43.15 | 1187581.0 |
| 2013-01-14 | ABX-DELISTED | Stock | 34.46 | 34.62 | 34.09 | 34.17 | 6040152.0 |
| 2013-01-14 | ACAD | Stock | 5.04 | 5.7 | 5.0 | 5.61 | 5492100.0 |
> showing 50 of 6,220 rows — these rows as CSV