PREVIEW / stock_daily / 2013-10-14
file: by_date/stock_daily/2013/2013-10-14.parquet size: 212 KB rows: 6,377 symbols: 3,514
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-14 | AAPL | Stock | 17.4939 | 17.7707 | 17.4768 | 17.7157 | 261898000.0 |
| 2013-10-14 | MSFT | Stock | 33.9 | 34.5 | 33.78 | 34.45 | 27757900.0 |
| 2013-10-14 | NVDA | Stock | 0.3805 | 0.3873 | 0.3805 | 0.3873 | 166628000.0 |
| 2013-10-14 | AMZN | Stock | 15.461 | 15.5825 | 15.35 | 15.535 | 38782000.0 |
| 2013-10-14 | META | Stock | 48.31 | 49.63 | 47.91 | 49.51 | 68781000.0 |
| 2013-10-14 | TSLA | Stock | 11.6667 | 12.1667 | 11.61 | 11.9813 | 116544000.0 |
| 2013-10-14 | TLT | Stock | 105.39 | 105.64 | 104.33 | 104.61 | 4205714.0 |
| 2013-10-14 | ES | Stock | 42.0 | 42.15 | 41.33 | 41.73 | 1543100.0 |
| 2013-10-14 | CL | Stock | 61.15 | 61.59 | 61.06 | 61.53 | 1954300.0 |
| 2013-10-14 | A | Stock | 36.6237 | 36.7883 | 36.1302 | 36.7382 | 2950479.0 |
| 2013-10-14 | AABA-DELISTED | Stock | 33.77 | 34.1 | 33.68 | 34.0 | 17347733.0 |
| 2013-10-14 | AACG | Stock | 4.78 | 4.85 | 4.75 | 4.8 | 7000.0 |
| 2013-10-14 | AAIC-DELISTED | Stock | 23.76 | 24.11 | 23.66 | 24.08 | 125163.0 |
| 2013-10-14 | AAMC-DELISTED | Stock | 170.0 | 170.0 | 166.1088 | 166.1088 | 1584.0 |
| 2013-10-14 | AAME | Stock | 4.0 | 4.06 | 4.0 | 4.06 | 10900.0 |
| 2013-10-14 | AAMRQ-DELISTED | Stock | 4.865 | 5.13 | 4.83 | 5.12 | 3937670.0 |
| 2013-10-14 | AAOI | Stock | 9.51 | 10.05 | 9.07 | 10.0 | 64400.0 |
| 2013-10-14 | AAON | Stock | 11.7867 | 12.0444 | 11.5956 | 11.9333 | 128475.0 |
| 2013-10-14 | AAP | Stock | 82.16 | 83.62 | 82.0 | 83.61 | 405100.0 |
| 2013-10-14 | AAT | Stock | 31.98 | 32.27 | 31.97 | 32.25 | 217100.0 |
| 2013-10-14 | AAU-DELISTED | Stock | 1.26 | 1.27 | 1.2 | 1.24 | 102269.0 |
| 2013-10-14 | AAUAF-DELISTED | Stock | 1.26 | 1.27 | 1.2 | 1.24 | 102969.0 |
| 2013-10-14 | AAV-DELISTED | Stock | 3.837 | 3.9 | 3.83 | 3.87 | 55274.0 |
| 2013-10-14 | AAWW-DELISTED | Stock | 44.69 | 45.02 | 44.42 | 44.91 | 108607.0 |
| 2013-10-14 | AAXJ | Stock | 60.61 | 61.3 | 60.451 | 61.22 | 408710.0 |
| 2013-10-14 | AAXN-DELISTED | Stock | 14.92 | 15.18 | 14.626 | 15.11 | 1415586.0 |
| 2013-10-14 | AB | Stock | 20.2 | 20.43 | 20.14 | 20.43 | 547300.0 |
| 2013-10-14 | ABAC-DELISTED | Stock | 1.72 | 1.72 | 1.52 | 1.61 | 124233.0 |
| 2013-10-14 | ABAX-DELISTED | Stock | 39.56 | 39.89 | 39.28 | 39.62 | 168272.0 |
| 2013-10-14 | ABB-DELISTED | Stock | 23.18 | 23.48 | 23.16 | 23.41 | 1029151.0 |
| 2013-10-14 | ABBNY-DELISTED | Stock | 23.16 | 23.48 | 23.16 | 23.42 | 1043912.0 |
| 2013-10-14 | ABBV | Stock | 45.21 | 46.45 | 45.07 | 46.33 | 3377300.0 |
| 2013-10-14 | ABC-DELISTED | Stock | 62.46 | 63.14 | 62.18 | 63.1 | 1036225.0 |
| 2013-10-14 | ABCB | Stock | 18.0 | 18.2 | 18.0 | 18.1 | 55600.0 |
| 2013-10-14 | ABCD-DELISTED | Stock | 1.42 | 1.46 | 1.38 | 1.45 | 8266.0 |
| 2013-10-14 | ABCO-DELISTED | Stock | 63.25 | 65.36 | 63.25 | 65.26 | 212525.0 |
| 2013-10-14 | ABE-DELISTED | Stock | 19.92 | 20.14 | 19.775 | 20.14 | 5498.0 |
| 2013-10-14 | ABEO | Stock | 487.5 | 525.0 | 475.0 | 487.5 | 32.0 |
| 2013-10-14 | ABFS-DELISTED | Stock | 22.81 | 23.5 | 22.67 | 23.49 | 355713.0 |
| 2013-10-14 | ABG | Stock | 52.52 | 53.45 | 52.18 | 53.09 | 289900.0 |
| 2013-10-14 | ABM | Stock | 26.98 | 27.57 | 26.98 | 27.32 | 238900.0 |
| 2013-10-14 | ABMD-DELISTED | Stock | 19.69 | 20.57 | 19.69 | 20.29 | 293707.0 |
| 2013-10-14 | ABR | Stock | 6.64 | 6.73 | 6.6 | 6.66 | 171400.0 |
| 2013-10-14 | ABR.A-DELISTED | Stock | 24.65 | 24.65 | 24.65 | 24.65 | 200.0 |
| 2013-10-14 | ABR.B-DELISTED | Stock | 23.5 | 23.5 | 23.5 | 23.5 | 1000.0 |
| 2013-10-14 | ABT | Stock | 33.51 | 34.03 | 33.38 | 34.0 | 6817400.0 |
| 2013-10-14 | ABTL-DELISTED | Stock | 7.51 | 7.7005 | 7.36 | 7.63 | 68842.0 |
| 2013-10-14 | ABUS | Stock | 9.65 | 9.89 | 9.37 | 9.89 | 104900.0 |
| 2013-10-14 | ABV-DELISTED | Stock | 38.5 | 39.4101 | 38.42 | 39.17 | 1116314.0 |
| 2013-10-14 | ABX-DELISTED | Stock | 17.34 | 17.45 | 17.13 | 17.27 | 9548105.0 |
> showing 50 of 6,377 rows — these rows as CSV