PREVIEW / stock_daily / 2010-01-15
file: by_date/stock_daily/2010/2010-01-15.parquet size: 189 KB rows: 5,886 symbols: 3,489
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-01-15 | AAPL | Stock | 7.5332 | 7.5571 | 7.3525 | 7.3546 | 594067600.0 |
| 2010-01-15 | MSFT | Stock | 31.08 | 31.24 | 30.71 | 30.86 | 79913200.0 |
| 2010-01-15 | NVDA | Stock | 0.4375 | 0.4412 | 0.422 | 0.4278 | 818192000.0 |
| 2010-01-15 | AMZN | Stock | 6.459 | 6.4825 | 6.353 | 6.357 | 307530000.0 |
| 2010-01-15 | TLT | Stock | 91.03 | 91.33 | 90.98 | 91.08 | 4142729.0 |
| 2010-01-15 | ES | Stock | 26.49 | 26.57 | 25.84 | 25.95 | 2549000.0 |
| 2010-01-15 | CL | Stock | 40.27 | 40.605 | 39.79 | 40.0 | 7913200.0 |
| 2010-01-15 | A | Stock | 22.3319 | 22.432 | 21.6953 | 21.7668 | 4626681.0 |
| 2010-01-15 | AABA-DELISTED | Stock | 17.24 | 17.25 | 16.75 | 16.82 | 16902607.0 |
| 2010-01-15 | AACC-DELISTED | Stock | 6.5 | 6.57 | 6.02 | 6.05 | 42033.0 |
| 2010-01-15 | AACG | Stock | 4.42 | 4.5 | 4.42 | 4.45 | 2800.0 |
| 2010-01-15 | AAI-DELISTED | Stock | 5.55 | 5.65 | 5.42 | 5.46 | 4260250.0 |
| 2010-01-15 | AAIC-DELISTED | Stock | 16.17 | 16.22 | 16.04 | 16.05 | 10775.0 |
| 2010-01-15 | AAME | Stock | 1.35 | 1.35 | 1.34 | 1.35 | 4900.0 |
| 2010-01-15 | AAON | Stock | 3.9506 | 3.9506 | 3.757 | 3.7827 | 386775.0 |
| 2010-01-15 | AAP | Stock | 39.34 | 39.66 | 39.17 | 39.31 | 738900.0 |
| 2010-01-15 | AATI-DELISTED | Stock | 4.01 | 4.01 | 3.76 | 3.92 | 364407.0 |
| 2010-01-15 | AAU-DELISTED | Stock | 1.2 | 1.2101 | 1.11 | 1.14 | 408502.0 |
| 2010-01-15 | AAUAF-DELISTED | Stock | 1.2 | 1.2101 | 1.11 | 1.14 | 411532.0 |
| 2010-01-15 | AAV-DELISTED | Stock | 7.03 | 7.05 | 6.95 | 7.04 | 406523.0 |
| 2010-01-15 | AAWW-DELISTED | Stock | 40.44 | 40.44 | 38.5 | 39.42 | 253799.0 |
| 2010-01-15 | AAXJ | Stock | 57.39 | 57.39 | 56.59 | 56.86 | 881408.0 |
| 2010-01-15 | AAXN-DELISTED | Stock | 6.42 | 6.43 | 5.99 | 6.29 | 1657001.0 |
| 2010-01-15 | AB | Stock | 29.55 | 29.66 | 28.92 | 29.0 | 643500.0 |
| 2010-01-15 | ABAX-DELISTED | Stock | 26.16 | 26.16 | 24.7899 | 25.52 | 148751.0 |
| 2010-01-15 | ABB-DELISTED | Stock | 20.22 | 20.24 | 19.93 | 20.01 | 3366175.0 |
| 2010-01-15 | ABBC-DELISTED | Stock | 7.12 | 7.25 | 7.05 | 7.05 | 151999.0 |
| 2010-01-15 | ABBNY-DELISTED | Stock | 20.22 | 20.24 | 19.93 | 20.04 | 3371338.0 |
| 2010-01-15 | ABC-DELISTED | Stock | 27.26 | 27.27 | 26.81 | 26.91 | 2062790.0 |
| 2010-01-15 | ABCB | Stock | 7.9606 | 8.0297 | 7.9013 | 8.0001 | 44853.0 |
| 2010-01-15 | ABCD-DELISTED | Stock | 3.95 | 4.05 | 3.95 | 4.02 | 9706.0 |
| 2010-01-15 | ABCO-DELISTED | Stock | 16.087 | 16.102 | 15.843 | 15.988 | 123279.0 |
| 2010-01-15 | ABCW-DELISTED | Stock | 0.95 | 1.02 | 0.95 | 1.02 | 422590.0 |
| 2010-01-15 | ABD-DELISTED | Stock | 8.09 | 8.2 | 7.75 | 8.14 | 415680.0 |
| 2010-01-15 | ABE-DELISTED | Stock | 16.92 | 17.01 | 16.8 | 16.8 | 9228.0 |
| 2010-01-15 | ABEO | Stock | 4062.5 | 4087.5 | 3937.5 | 4087.5 | 10.0 |
| 2010-01-15 | ABFS-DELISTED | Stock | 28.64 | 28.77 | 27.31 | 27.9 | 731680.0 |
| 2010-01-15 | ABG | Stock | 13.13 | 13.32 | 12.99 | 13.29 | 310900.0 |
| 2010-01-15 | ABII-DELISTED | Stock | 41.38 | 41.595 | 40.85 | 41.17 | 18605.0 |
| 2010-01-15 | ABK-DELISTED | Stock | 0.761 | 0.7799 | 0.7492 | 0.7586 | 10915659.0 |
| 2010-01-15 | ABM | Stock | 20.95 | 20.95 | 20.13 | 20.49 | 166800.0 |
| 2010-01-15 | ABMD-DELISTED | Stock | 8.29 | 8.31 | 7.99 | 8.04 | 196915.0 |
| 2010-01-15 | ABR | Stock | 2.37 | 2.44 | 2.28 | 2.44 | 66300.0 |
| 2010-01-15 | ABT | Stock | 26.5617 | 26.6625 | 26.4658 | 26.6241 | 16132555.0 |
| 2010-01-15 | ABTL-DELISTED | Stock | 4.692 | 4.83 | 4.232 | 4.6 | 17993.0 |
| 2010-01-15 | ABV-DELISTED | Stock | 106.19 | 106.59 | 103.41 | 104.42 | 476206.0 |
| 2010-01-15 | ABVT-DELISTED | Stock | 62.52 | 62.6525 | 60.57 | 61.27 | 117146.0 |
| 2010-01-15 | ABX-DELISTED | Stock | 40.19 | 40.27 | 39.36 | 39.65 | 11269957.0 |
| 2010-01-15 | ACAD | Stock | 1.52 | 1.53 | 1.42 | 1.45 | 824400.0 |
| 2010-01-15 | ACAP-DELISTED | Stock | 31.02 | 31.09 | 29.71 | 29.95 | 45198.0 |
> showing 50 of 5,886 rows — these rows as CSV