PREVIEW / stock_daily / 2013-10-24
file: by_date/stock_daily/2013/2013-10-24.parquet size: 215 KB rows: 6,426 symbols: 3,534
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-10-24 | AAPL | Stock | 18.75 | 19.0168 | 18.6589 | 18.9968 | 384764800.0 |
| 2013-10-24 | MSFT | Stock | 33.82 | 34.1 | 33.57 | 33.72 | 53209700.0 |
| 2013-10-24 | NVDA | Stock | 0.3885 | 0.391 | 0.384 | 0.3848 | 236436000.0 |
| 2013-10-24 | AMZN | Stock | 16.4815 | 16.6325 | 16.3375 | 16.6105 | 117694000.0 |
| 2013-10-24 | META | Stock | 52.38 | 52.84 | 51.59 | 52.45 | 46775000.0 |
| 2013-10-24 | TSLA | Stock | 11.0 | 11.6333 | 10.8553 | 11.5433 | 162385500.0 |
| 2013-10-24 | TLT | Stock | 108.61 | 108.67 | 107.87 | 107.89 | 7631370.0 |
| 2013-10-24 | ES | Stock | 43.13 | 43.27 | 42.74 | 42.88 | 1161700.0 |
| 2013-10-24 | CL | Stock | 62.42 | 63.3 | 61.93 | 63.04 | 5188300.0 |
| 2013-10-24 | A | Stock | 36.2446 | 36.6381 | 36.2446 | 36.5665 | 2496688.0 |
| 2013-10-24 | AABA-DELISTED | Stock | 33.19 | 33.31 | 32.81 | 33.08 | 14693225.0 |
| 2013-10-24 | AACG | Stock | 4.74 | 4.81 | 4.7 | 4.81 | 2600.0 |
| 2013-10-24 | AAIC-DELISTED | Stock | 25.46 | 25.6 | 25.39 | 25.53 | 124156.0 |
| 2013-10-24 | AAMC-DELISTED | Stock | 180.8824 | 188.7059 | 180.8824 | 183.8235 | 11611.0 |
| 2013-10-24 | AAME | Stock | 4.05 | 4.05 | 3.97 | 4.05 | 6000.0 |
| 2013-10-24 | AAMRQ-DELISTED | Stock | 6.4 | 7.06 | 6.4 | 6.9 | 25236296.0 |
| 2013-10-24 | AAOI | Stock | 13.1 | 13.49 | 12.45 | 12.61 | 74700.0 |
| 2013-10-24 | AAON | Stock | 12.2578 | 12.6311 | 12.2133 | 12.5511 | 121950.0 |
| 2013-10-24 | AAP | Stock | 99.44 | 99.51 | 98.5 | 99.42 | 767400.0 |
| 2013-10-24 | AAT | Stock | 33.85 | 34.29 | 33.85 | 33.99 | 252200.0 |
| 2013-10-24 | AAU-DELISTED | Stock | 1.43 | 1.4704 | 1.4 | 1.44 | 65532.0 |
| 2013-10-24 | AAUAF-DELISTED | Stock | 1.41 | 1.45 | 1.3901 | 1.44 | 66930.0 |
| 2013-10-24 | AAV-DELISTED | Stock | 3.94 | 4.0198 | 3.91 | 4.0 | 79416.0 |
| 2013-10-24 | AAWW-DELISTED | Stock | 47.38 | 49.23 | 47.04 | 48.72 | 401585.0 |
| 2013-10-24 | AAXJ | Stock | 60.32 | 60.35 | 59.97 | 60.0 | 1029180.0 |
| 2013-10-24 | AAXN-DELISTED | Stock | 15.38 | 15.6 | 15.24 | 15.345 | 660614.0 |
| 2013-10-24 | AB | Stock | 21.45 | 21.52 | 20.51 | 21.15 | 603900.0 |
| 2013-10-24 | ABAC-DELISTED | Stock | 1.69 | 1.69 | 1.51 | 1.54 | 122071.0 |
| 2013-10-24 | ABAX-DELISTED | Stock | 33.1 | 34.53 | 32.25 | 34.32 | 401552.0 |
| 2013-10-24 | ABB-DELISTED | Stock | 25.76 | 25.92 | 25.72 | 25.775 | 2409516.0 |
| 2013-10-24 | ABBNY-DELISTED | Stock | 25.76 | 25.92 | 25.72 | 25.78 | 3120028.0 |
| 2013-10-24 | ABBV | Stock | 48.63 | 48.98 | 47.74 | 47.93 | 5077900.0 |
| 2013-10-24 | ABC-DELISTED | Stock | 64.2 | 64.94 | 64.2 | 64.64 | 1071237.0 |
| 2013-10-24 | ABCB | Stock | 17.9 | 18.2 | 17.85 | 17.93 | 450000.0 |
| 2013-10-24 | ABCD-DELISTED | Stock | 1.28 | 1.33 | 1.28 | 1.33 | 15461.0 |
| 2013-10-24 | ABCO-DELISTED | Stock | 67.33 | 69.58 | 67.08 | 69.26 | 80860.0 |
| 2013-10-24 | ABE-DELISTED | Stock | 20.44 | 20.478 | 20.33 | 20.34 | 10330.0 |
| 2013-10-24 | ABEO | Stock | 412.5 | 425.0 | 400.0 | 425.0 | 46.0 |
| 2013-10-24 | ABFS-DELISTED | Stock | 27.29 | 27.5899 | 26.69 | 27.35 | 223020.0 |
| 2013-10-24 | ABG | Stock | 48.36 | 49.35 | 47.01 | 48.99 | 770400.0 |
| 2013-10-24 | ABGB-DELISTED | Stock | 12.36 | 12.48 | 12.22 | 12.42 | 93909.0 |
| 2013-10-24 | ABM | Stock | 28.84 | 28.88 | 28.47 | 28.63 | 196700.0 |
| 2013-10-24 | ABMD-DELISTED | Stock | 20.64 | 21.05 | 20.6 | 20.96 | 198038.0 |
| 2013-10-24 | ABR | Stock | 7.0 | 7.04 | 6.96 | 7.01 | 160500.0 |
| 2013-10-24 | ABR.A-DELISTED | Stock | 24.95 | 24.99 | 24.95 | 24.9899 | 2800.0 |
| 2013-10-24 | ABR.B-DELISTED | Stock | 23.59 | 23.6 | 23.31 | 23.31 | 3740.0 |
| 2013-10-24 | ABT | Stock | 37.22 | 37.62 | 37.2 | 37.21 | 6311200.0 |
| 2013-10-24 | ABTL-DELISTED | Stock | 8.545 | 8.605 | 8.44 | 8.55 | 66167.0 |
| 2013-10-24 | ABUS | Stock | 8.72 | 9.32 | 8.68 | 9.14 | 508200.0 |
| 2013-10-24 | ABV-DELISTED | Stock | 38.56 | 38.71 | 38.23 | 38.71 | 5975766.0 |
> showing 50 of 6,426 rows — these rows as CSV