PREVIEW / stock_daily / 2013-10-04
file: by_date/stock_daily/2013/2013-10-04.parquet size: 213 KB rows: 6,388 symbols: 3,524
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-04 | AAPL | Stock | 17.2807 | 17.3071 | 17.0929 | 17.2511 | 258868400.0 |
| 2013-10-04 | MSFT | Stock | 33.69 | 33.99 | 33.62 | 33.88 | 33008100.0 |
| 2013-10-04 | NVDA | Stock | 0.384 | 0.393 | 0.383 | 0.3898 | 246228000.0 |
| 2013-10-04 | AMZN | Stock | 15.7565 | 15.96 | 15.631 | 15.952 | 36300000.0 |
| 2013-10-04 | META | Stock | 49.77 | 51.16 | 49.57 | 51.04 | 74447000.0 |
| 2013-10-04 | TSLA | Stock | 11.76 | 12.0787 | 11.51 | 12.0653 | 216210000.0 |
| 2013-10-04 | TLT | Stock | 105.67 | 105.78 | 105.35 | 105.71 | 5547172.0 |
| 2013-10-04 | ES | Stock | 41.0 | 41.16 | 40.82 | 41.02 | 1024000.0 |
| 2013-10-04 | CL | Stock | 59.22 | 59.49 | 58.9 | 59.33 | 2172500.0 |
| 2013-10-04 | A | Stock | 36.6023 | 37.0959 | 36.5308 | 37.0386 | 2611324.0 |
| 2013-10-04 | AABA-DELISTED | Stock | 33.96 | 35.06 | 33.96 | 34.88 | 23755322.0 |
| 2013-10-04 | AACG | Stock | 4.95 | 5.0 | 4.92 | 4.92 | 15800.0 |
| 2013-10-04 | AAIC-DELISTED | Stock | 23.36 | 23.609 | 23.36 | 23.53 | 101957.0 |
| 2013-10-04 | AAMC-DELISTED | Stock | 182.3176 | 198.5088 | 182.3176 | 197.3882 | 19764.0 |
| 2013-10-04 | AAME | Stock | 4.0 | 4.05 | 4.0 | 4.03 | 8500.0 |
| 2013-10-04 | AAMRQ-DELISTED | Stock | 4.64 | 5.05 | 4.64 | 5.04 | 12503235.0 |
| 2013-10-04 | AAOI | Stock | 10.1 | 10.2 | 9.82 | 10.2 | 109800.0 |
| 2013-10-04 | AAON | Stock | 11.6756 | 11.8978 | 11.4356 | 11.7956 | 64800.0 |
| 2013-10-04 | AAP | Stock | 81.87 | 83.17 | 81.86 | 83.16 | 281500.0 |
| 2013-10-04 | AAT | Stock | 31.64 | 31.88 | 30.95 | 31.0 | 488600.0 |
| 2013-10-04 | AAU-DELISTED | Stock | 1.34 | 1.34 | 1.31 | 1.33 | 22695.0 |
| 2013-10-04 | AAUAF-DELISTED | Stock | 1.34 | 1.34 | 1.31 | 1.33 | 23195.0 |
| 2013-10-04 | AAV-DELISTED | Stock | 3.9 | 4.0 | 3.8795 | 3.93 | 147618.0 |
| 2013-10-04 | AAWW-DELISTED | Stock | 44.9 | 45.01 | 42.83 | 44.01 | 461072.0 |
| 2013-10-04 | AAXJ | Stock | 59.67 | 60.122 | 59.53 | 60.04 | 200364.0 |
| 2013-10-04 | AAXN-DELISTED | Stock | 14.85 | 15.2803 | 13.45 | 14.035 | 5116518.0 |
| 2013-10-04 | AB | Stock | 19.87 | 20.24 | 19.87 | 19.92 | 175500.0 |
| 2013-10-04 | ABAC-DELISTED | Stock | 1.26 | 1.3 | 1.21 | 1.2994 | 245111.0 |
| 2013-10-04 | ABAX-DELISTED | Stock | 40.15 | 40.46 | 39.59 | 39.64 | 209612.0 |
| 2013-10-04 | ABB-DELISTED | Stock | 23.33 | 23.48 | 23.28 | 23.29 | 1052527.0 |
| 2013-10-04 | ABBNY-DELISTED | Stock | 23.33 | 23.48 | 23.28 | 23.31 | 1084473.0 |
| 2013-10-04 | ABBV | Stock | 46.18 | 46.88 | 46.0 | 46.8 | 4141400.0 |
| 2013-10-04 | ABC-DELISTED | Stock | 61.59 | 62.54 | 61.415 | 62.45 | 1318099.0 |
| 2013-10-04 | ABCB | Stock | 17.81 | 18.2 | 17.81 | 18.18 | 18700.0 |
| 2013-10-04 | ABCD-DELISTED | Stock | 1.47 | 1.4893 | 1.38 | 1.39 | 20306.0 |
| 2013-10-04 | ABCO-DELISTED | Stock | 60.66 | 61.73 | 60.05 | 61.05 | 73205.0 |
| 2013-10-04 | ABE-DELISTED | Stock | 19.85 | 19.91 | 19.85 | 19.91 | 4880.0 |
| 2013-10-04 | ABEO | Stock | 462.5 | 500.0 | 462.5 | 500.0 | 18.0 |
| 2013-10-04 | ABFS-DELISTED | Stock | 25.89 | 26.46 | 25.72 | 26.13 | 326560.0 |
| 2013-10-04 | ABG | Stock | 54.24 | 55.35 | 53.76 | 55.07 | 585400.0 |
| 2013-10-04 | ABM | Stock | 26.28 | 26.51 | 26.21 | 26.35 | 62100.0 |
| 2013-10-04 | ABMD-DELISTED | Stock | 19.15 | 19.48 | 18.98 | 19.23 | 307311.0 |
| 2013-10-04 | ABR | Stock | 6.77 | 6.93 | 6.63 | 6.63 | 302700.0 |
| 2013-10-04 | ABR.A-DELISTED | Stock | 24.48 | 24.8775 | 24.48 | 24.8775 | 2100.0 |
| 2013-10-04 | ABT | Stock | 33.31 | 33.71 | 33.26 | 33.56 | 7477600.0 |
| 2013-10-04 | ABTL-DELISTED | Stock | 7.15 | 7.4493 | 7.15 | 7.42 | 19414.0 |
| 2013-10-04 | ABUS | Stock | 8.98 | 9.65 | 8.68 | 8.92 | 960600.0 |
| 2013-10-04 | ABV-DELISTED | Stock | 38.18 | 38.75 | 38.09 | 38.53 | 1426085.0 |
| 2013-10-04 | ABX-DELISTED | Stock | 18.2 | 18.3 | 18.0 | 18.03 | 7194001.0 |
| 2013-10-04 | ACAD | Stock | 28.6 | 29.16 | 28.58 | 28.77 | 1865000.0 |
> showing 50 of 6,388 rows — these rows as CSV