PREVIEW / stock_daily / 2013-10-22
file: by_date/stock_daily/2013/2013-10-22.parquet size: 215 KB rows: 6,438 symbols: 3,558
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-22 | AAPL | Stock | 18.8004 | 18.8732 | 18.1439 | 18.5668 | 534063600.0 |
| 2013-10-22 | MSFT | Stock | 35.02 | 35.1 | 34.52 | 34.58 | 40438500.0 |
| 2013-10-22 | NVDA | Stock | 0.3962 | 0.3965 | 0.3908 | 0.3942 | 179452000.0 |
| 2013-10-22 | AMZN | Stock | 16.386 | 16.8555 | 16.284 | 16.627 | 78710000.0 |
| 2013-10-22 | META | Stock | 54.33 | 54.76 | 52.2 | 52.68 | 83204000.0 |
| 2013-10-22 | TSLA | Stock | 11.3667 | 11.852 | 11.074 | 11.436 | 170800500.0 |
| 2013-10-22 | TLT | Stock | 107.5999 | 108.12 | 107.56 | 107.89 | 9708542.0 |
| 2013-10-22 | ES | Stock | 42.33 | 42.82 | 42.21 | 42.6 | 1904100.0 |
| 2013-10-22 | CL | Stock | 62.39 | 63.61 | 62.25 | 63.47 | 3688600.0 |
| 2013-10-22 | A | Stock | 37.2675 | 37.3391 | 36.3662 | 36.495 | 5984139.0 |
| 2013-10-22 | AABA-DELISTED | Stock | 34.24 | 34.6 | 33.58 | 33.94 | 17289362.0 |
| 2013-10-22 | AACG | Stock | 4.68 | 4.98 | 4.68 | 4.73 | 45100.0 |
| 2013-10-22 | AAIC-DELISTED | Stock | 25.25 | 25.389 | 25.18 | 25.29 | 99741.0 |
| 2013-10-22 | AAMC-DELISTED | Stock | 161.7647 | 176.4706 | 161.7647 | 176.4706 | 7990.0 |
| 2013-10-22 | AAME | Stock | 4.05 | 4.05 | 4.04 | 4.05 | 1900.0 |
| 2013-10-22 | AAMRQ-DELISTED | Stock | 6.16 | 6.18 | 6.07 | 6.17 | 7180929.0 |
| 2013-10-22 | AAOI | Stock | 13.0 | 13.5 | 12.67 | 13.13 | 321200.0 |
| 2013-10-22 | AAON | Stock | 12.1111 | 12.1778 | 12.0178 | 12.1289 | 225450.0 |
| 2013-10-22 | AAP | Stock | 99.0 | 99.6 | 98.04 | 98.72 | 779300.0 |
| 2013-10-22 | AAT | Stock | 33.18 | 33.63 | 33.18 | 33.53 | 116600.0 |
| 2013-10-22 | AAU-DELISTED | Stock | 1.37 | 1.41 | 1.35 | 1.41 | 126695.0 |
| 2013-10-22 | AAUAF-DELISTED | Stock | 1.37 | 1.41 | 1.35 | 1.41 | 128045.0 |
| 2013-10-22 | AAV-DELISTED | Stock | 4.01 | 4.07 | 3.97 | 4.0 | 116282.0 |
| 2013-10-22 | AAWW-DELISTED | Stock | 46.31 | 47.01 | 45.99 | 46.73 | 165313.0 |
| 2013-10-22 | AAXJ | Stock | 61.35 | 61.8801 | 61.35 | 61.45 | 1211696.0 |
| 2013-10-22 | AAXN-DELISTED | Stock | 15.48 | 15.66 | 15.28 | 15.51 | 930098.0 |
| 2013-10-22 | AB | Stock | 21.67 | 21.89 | 21.47 | 21.52 | 329700.0 |
| 2013-10-22 | ABAC-DELISTED | Stock | 1.79 | 1.79 | 1.6801 | 1.72 | 107557.0 |
| 2013-10-22 | ABAX-DELISTED | Stock | 38.75 | 39.2042 | 37.8303 | 38.11 | 295868.0 |
| 2013-10-22 | ABB-DELISTED | Stock | 24.31 | 24.54 | 24.3 | 24.47 | 1863634.0 |
| 2013-10-22 | ABBNY-DELISTED | Stock | 24.31 | 24.54 | 24.3 | 24.46 | 1890828.0 |
| 2013-10-22 | ABBV | Stock | 48.39 | 49.31 | 48.11 | 49.0 | 6937500.0 |
| 2013-10-22 | ABC-DELISTED | Stock | 64.18 | 64.5599 | 63.53 | 63.75 | 1570578.0 |
| 2013-10-22 | ABCB | Stock | 17.95 | 18.06 | 17.95 | 17.99 | 233300.0 |
| 2013-10-22 | ABCD-DELISTED | Stock | 1.35 | 1.37 | 1.34 | 1.34 | 15582.0 |
| 2013-10-22 | ABCO-DELISTED | Stock | 68.34 | 68.83 | 67.52 | 67.66 | 154593.0 |
| 2013-10-22 | ABE-DELISTED | Stock | 20.78 | 20.78 | 20.48 | 20.6 | 6937.0 |
| 2013-10-22 | ABEO | Stock | 425.0 | 475.0 | 412.5 | 437.5 | 62.0 |
| 2013-10-22 | ABFS-DELISTED | Stock | 27.02 | 27.7325 | 26.4884 | 27.24 | 362178.0 |
| 2013-10-22 | ABG | Stock | 53.78 | 55.43 | 49.34 | 51.24 | 1675800.0 |
| 2013-10-22 | ABGB-DELISTED | Stock | 12.69 | 13.06 | 12.69 | 12.95 | 88663.0 |
| 2013-10-22 | ABM | Stock | 28.49 | 29.06 | 28.39 | 28.99 | 379600.0 |
| 2013-10-22 | ABMD-DELISTED | Stock | 20.35 | 20.61 | 20.15 | 20.1605 | 287679.0 |
| 2013-10-22 | ABR | Stock | 6.93 | 7.0 | 6.93 | 6.98 | 100600.0 |
| 2013-10-22 | ABR.A-DELISTED | Stock | 24.54 | 24.9899 | 24.54 | 24.9899 | 6070.0 |
| 2013-10-22 | ABR.B-DELISTED | Stock | 23.4 | 23.76 | 23.4 | 23.55 | 5546.0 |
| 2013-10-22 | ABT | Stock | 36.94 | 37.17 | 36.72 | 37.02 | 9726300.0 |
| 2013-10-22 | ABTL-DELISTED | Stock | 9.24 | 9.24 | 8.369 | 8.5495 | 139930.0 |
| 2013-10-22 | ABUS | Stock | 8.74 | 8.93 | 8.3 | 8.73 | 250400.0 |
| 2013-10-22 | ABV-DELISTED | Stock | 39.51 | 40.3 | 39.46 | 40.11 | 1719422.0 |
> showing 50 of 6,438 rows — these rows as CSV