PREVIEW / stock_daily / 2010-09-16
file: by_date/stock_daily/2010/2010-09-16.parquet size: 190 KB rows: 5,947 symbols: 3,492
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-09-16 | AAPL | Stock | 9.6514 | 9.8811 | 9.625 | 9.8775 | 652103200.0 |
| 2010-09-16 | MSFT | Stock | 25.06 | 25.37 | 25.05 | 25.33 | 44548300.0 |
| 2010-09-16 | NVDA | Stock | 0.2605 | 0.2665 | 0.2605 | 0.2643 | 365280000.0 |
| 2010-09-16 | AMZN | Stock | 7.27 | 7.4115 | 7.258 | 7.4065 | 116540000.0 |
| 2010-09-16 | TSLA | Stock | 1.4767 | 1.544 | 1.3893 | 1.396 | 40267500.0 |
| 2010-09-16 | TLT | Stock | 101.53 | 101.82 | 100.85 | 101.26 | 17124897.0 |
| 2010-09-16 | ES | Stock | 29.59 | 29.7 | 29.15 | 29.26 | 1501400.0 |
| 2010-09-16 | CL | Stock | 38.16 | 38.29 | 37.875 | 38.29 | 5804200.0 |
| 2010-09-16 | A | Stock | 20.9871 | 21.6023 | 20.9299 | 21.4878 | 6245285.0 |
| 2010-09-16 | AABA-DELISTED | Stock | 14.19 | 14.24 | 13.98 | 14.2 | 26493346.0 |
| 2010-09-16 | AACC-DELISTED | Stock | 3.67 | 3.67 | 3.61 | 3.62 | 10991.0 |
| 2010-09-16 | AACG | Stock | 2.8 | 2.97 | 2.8 | 2.8 | 16600.0 |
| 2010-09-16 | AAI-DELISTED | Stock | 4.48 | 4.495 | 4.38 | 4.44 | 1606263.0 |
| 2010-09-16 | AAIC-DELISTED | Stock | 22.27 | 22.6 | 22.11 | 22.39 | 31422.0 |
| 2010-09-16 | AAME | Stock | 1.55 | 1.65 | 1.55 | 1.65 | 4900.0 |
| 2010-09-16 | AAON | Stock | 4.6736 | 4.6736 | 4.5847 | 4.6084 | 162506.0 |
| 2010-09-16 | AAP | Stock | 57.25 | 58.0 | 57.2 | 57.99 | 628400.0 |
| 2010-09-16 | AATI-DELISTED | Stock | 3.37 | 3.38 | 3.26 | 3.32 | 55176.0 |
| 2010-09-16 | AAU-DELISTED | Stock | 2.55 | 2.6 | 2.51 | 2.54 | 209192.0 |
| 2010-09-16 | AAUAF-DELISTED | Stock | 2.55 | 2.6 | 2.51 | 2.54 | 211472.0 |
| 2010-09-16 | AAV-DELISTED | Stock | 6.37 | 6.45 | 6.34 | 6.38 | 187804.0 |
| 2010-09-16 | AAWW-DELISTED | Stock | 47.85 | 49.01 | 47.63 | 48.24 | 142595.0 |
| 2010-09-16 | AAXJ | Stock | 58.15 | 58.25 | 57.9819 | 58.14 | 1078782.0 |
| 2010-09-16 | AAXN-DELISTED | Stock | 3.91 | 3.97 | 3.89 | 3.9 | 166567.0 |
| 2010-09-16 | AB | Stock | 25.97 | 25.97 | 25.55 | 25.71 | 228000.0 |
| 2010-09-16 | ABAC-DELISTED | Stock | 4.0 | 4.0 | 3.78 | 3.8 | 10616.0 |
| 2010-09-16 | ABAX-DELISTED | Stock | 20.35 | 20.5 | 20.1101 | 20.36 | 65041.0 |
| 2010-09-16 | ABB-DELISTED | Stock | 20.5 | 20.58 | 20.38 | 20.52 | 1866841.0 |
| 2010-09-16 | ABBC-DELISTED | Stock | 10.4 | 10.46 | 10.31 | 10.31 | 15506.0 |
| 2010-09-16 | ABBNY-DELISTED | Stock | 20.5 | 20.58 | 20.38 | 20.53 | 1907269.0 |
| 2010-09-16 | ABC-DELISTED | Stock | 30.18 | 30.23 | 29.83 | 30.14 | 3390029.0 |
| 2010-09-16 | ABCB | Stock | 8.69 | 8.76 | 8.49 | 8.68 | 49700.0 |
| 2010-09-16 | ABCD-DELISTED | Stock | 3.13 | 3.17 | 3.12 | 3.14 | 14744.0 |
| 2010-09-16 | ABCO-DELISTED | Stock | 21.7 | 21.7 | 21.07 | 21.11 | 93184.0 |
| 2010-09-16 | ABCW-DELISTED | Stock | 0.68 | 0.72 | 0.68 | 0.72 | 56550.0 |
| 2010-09-16 | ABD-DELISTED | Stock | 5.935 | 6.0249 | 5.8651 | 5.945 | 294670.0 |
| 2010-09-16 | ABE-DELISTED | Stock | 17.72 | 17.74 | 17.52 | 17.6701 | 8437.0 |
| 2010-09-16 | ABEO | Stock | 2412.5 | 2500.0 | 2412.5 | 2500.0 | 10.0 |
| 2010-09-16 | ABFS-DELISTED | Stock | 23.85 | 25.4 | 23.84 | 24.36 | 1367286.0 |
| 2010-09-16 | ABG | Stock | 12.72 | 12.72 | 12.25 | 12.39 | 192300.0 |
| 2010-09-16 | ABII-DELISTED | Stock | 74.91 | 75.2 | 74.66 | 75.11 | 12491.0 |
| 2010-09-16 | ABK-DELISTED | Stock | 0.6 | 0.6 | 0.525 | 0.5411 | 6241728.0 |
| 2010-09-16 | ABM | Stock | 21.8 | 21.82 | 21.18 | 21.51 | 149700.0 |
| 2010-09-16 | ABMD-DELISTED | Stock | 9.99 | 10.01 | 9.73 | 9.86 | 57380.0 |
| 2010-09-16 | ABR | Stock | 4.78 | 4.89 | 4.78 | 4.83 | 30600.0 |
| 2010-09-16 | ABT | Stock | 24.6665 | 24.844 | 24.4698 | 24.7625 | 11555857.0 |
| 2010-09-16 | ABTL-DELISTED | Stock | 4.3514 | 4.4041 | 4.0964 | 4.25 | 57558.0 |
| 2010-09-16 | ABV-DELISTED | Stock | 120.15 | 121.07 | 118.9 | 120.92 | 427622.0 |
| 2010-09-16 | ABVA-DELISTED | Stock | 2.7696 | 2.7696 | 2.7696 | 2.7696 | 605.0 |
| 2010-09-16 | ABVT-DELISTED | Stock | 52.2 | 52.65 | 50.94 | 51.33 | 49910.0 |
> showing 50 of 5,947 rows — these rows as CSV