PREVIEW / stock_daily / 2013-12-05
file: by_date/stock_daily/2013/2013-12-05.parquet size: 215 KB rows: 6,441 symbols: 3,540
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-12-05 | AAPL | Stock | 20.4518 | 20.5407 | 20.2289 | 20.2821 | 447580000.0 |
| 2013-12-05 | MSFT | Stock | 38.85 | 38.88 | 37.18 | 38.0 | 116305000.0 |
| 2013-12-05 | NVDA | Stock | 0.3998 | 0.3998 | 0.392 | 0.3925 | 271812000.0 |
| 2013-12-05 | AMZN | Stock | 19.3325 | 19.3325 | 19.0685 | 19.2245 | 38130000.0 |
| 2013-12-05 | META | Stock | 48.15 | 48.7 | 47.87 | 48.34 | 43855000.0 |
| 2013-12-05 | TSLA | Stock | 9.3433 | 9.5567 | 9.3 | 9.3653 | 139326000.0 |
| 2013-12-05 | TLT | Stock | 102.48 | 102.85 | 102.22 | 102.43 | 7446004.0 |
| 2013-12-05 | ES | Stock | 41.05 | 41.21 | 40.79 | 40.91 | 1691200.0 |
| 2013-12-05 | CL | Stock | 64.84 | 65.05 | 64.47 | 64.54 | 2057100.0 |
| 2013-12-05 | A | Stock | 38.1617 | 38.4835 | 37.9971 | 38.269 | 2530939.0 |
| 2013-12-05 | AABA-DELISTED | Stock | 38.19 | 39.31 | 38.05 | 38.87 | 26871513.0 |
| 2013-12-05 | AACG | Stock | 3.91 | 3.94 | 3.78 | 3.83 | 39500.0 |
| 2013-12-05 | AAIC-DELISTED | Stock | 26.12 | 26.1796 | 25.65 | 25.69 | 114784.0 |
| 2013-12-05 | AAMC-DELISTED | Stock | 263.8235 | 264.7059 | 252.9412 | 257.3529 | 4114.0 |
| 2013-12-05 | AAME | Stock | 4.04 | 4.04 | 4.0 | 4.0 | 4700.0 |
| 2013-12-05 | AAMRQ-DELISTED | Stock | 10.35 | 10.8 | 9.46 | 10.6 | 37369328.0 |
| 2013-12-05 | AAOI | Stock | 12.75 | 13.2 | 12.75 | 13.12 | 126000.0 |
| 2013-12-05 | AAON | Stock | 13.1156 | 13.3822 | 12.8889 | 13.2533 | 148725.0 |
| 2013-12-05 | AAP | Stock | 104.65 | 105.62 | 104.0 | 104.95 | 852800.0 |
| 2013-12-05 | AAT | Stock | 31.41 | 31.85 | 31.25 | 31.68 | 109800.0 |
| 2013-12-05 | AAU-DELISTED | Stock | 1.03 | 1.14 | 1.03 | 1.09 | 105179.0 |
| 2013-12-05 | AAUAF-DELISTED | Stock | 1.03 | 1.14 | 1.03 | 1.1 | 113179.0 |
| 2013-12-05 | AAV-DELISTED | Stock | 4.0 | 4.28 | 4.0 | 4.28 | 375618.0 |
| 2013-12-05 | AAWW-DELISTED | Stock | 37.07 | 37.55 | 37.03 | 37.54 | 246150.0 |
| 2013-12-05 | AAXJ | Stock | 60.21 | 60.23 | 59.84 | 59.92 | 582373.0 |
| 2013-12-05 | AAXN-DELISTED | Stock | 16.02 | 16.56 | 15.89 | 16.5101 | 1201818.0 |
| 2013-12-05 | AB | Stock | 22.49 | 22.84 | 22.36 | 22.42 | 289900.0 |
| 2013-12-05 | ABAC-DELISTED | Stock | 2.02 | 2.2 | 1.9939 | 2.199 | 171139.0 |
| 2013-12-05 | ABAX-DELISTED | Stock | 35.455 | 36.26 | 35.455 | 36.09 | 85322.0 |
| 2013-12-05 | ABB-DELISTED | Stock | 25.02 | 25.14 | 24.91 | 24.94 | 788249.0 |
| 2013-12-05 | ABBNY-DELISTED | Stock | 25.02 | 25.14 | 24.91 | 24.94 | 874815.0 |
| 2013-12-05 | ABBV | Stock | 49.42 | 50.07 | 49.05 | 49.76 | 5449100.0 |
| 2013-12-05 | ABC-DELISTED | Stock | 69.24 | 69.61 | 68.88 | 69.14 | 1990261.0 |
| 2013-12-05 | ABCB | Stock | 19.77 | 20.01 | 19.59 | 19.81 | 32900.0 |
| 2013-12-05 | ABCD-DELISTED | Stock | 1.49 | 1.5627 | 1.49 | 1.55 | 46424.0 |
| 2013-12-05 | ABCO-DELISTED | Stock | 61.58 | 62.34 | 60.85 | 62.17 | 226476.0 |
| 2013-12-05 | ABE-DELISTED | Stock | 19.25 | 19.33 | 19.25 | 19.26 | 2600.0 |
| 2013-12-05 | ABEO | Stock | 337.5 | 337.5 | 312.5 | 337.5 | 83.0 |
| 2013-12-05 | ABEV | Stock | 7.0 | 7.24 | 6.99 | 7.19 | 7015000.0 |
| 2013-12-05 | ABFS-DELISTED | Stock | 34.81 | 35.956 | 33.58 | 33.8 | 529390.0 |
| 2013-12-05 | ABG | Stock | 50.87 | 52.12 | 50.5 | 51.59 | 289700.0 |
| 2013-12-05 | ABGB-DELISTED | Stock | 12.4 | 12.48 | 12.18 | 12.2 | 1851.0 |
| 2013-12-05 | ABM | Stock | 27.32 | 27.61 | 27.26 | 27.6 | 151900.0 |
| 2013-12-05 | ABMD-DELISTED | Stock | 27.38 | 28.0 | 27.18 | 27.72 | 486178.0 |
| 2013-12-05 | ABR | Stock | 6.52 | 6.53 | 6.46 | 6.5 | 98000.0 |
| 2013-12-05 | ABR.A-DELISTED | Stock | 24.3299 | 24.3299 | 24.01 | 24.2999 | 2800.0 |
| 2013-12-05 | ABR.B-DELISTED | Stock | 22.18 | 22.2 | 22.18 | 22.2 | 1000.0 |
| 2013-12-05 | ABT | Stock | 37.29 | 37.32 | 36.89 | 36.92 | 5289800.0 |
| 2013-12-05 | ABTL-DELISTED | Stock | 12.86 | 12.88 | 12.11 | 12.36 | 136864.0 |
| 2013-12-05 | ABUS | Stock | 8.15 | 8.2 | 8.0 | 8.07 | 69800.0 |
> showing 50 of 6,441 rows — these rows as CSV