PREVIEW / stock_daily / 2013-11-01
file: by_date/stock_daily/2013/2013-11-01.parquet size: 214 KB rows: 6,411 symbols: 3,532
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-11-01 | AAPL | Stock | 18.715 | 18.7429 | 18.4229 | 18.5725 | 274890000.0 |
| 2013-11-01 | MSFT | Stock | 35.67 | 35.69 | 35.39 | 35.53 | 40264600.0 |
| 2013-11-01 | NVDA | Stock | 0.3818 | 0.3833 | 0.3788 | 0.3815 | 206136000.0 |
| 2013-11-01 | AMZN | Stock | 18.2815 | 18.2885 | 17.805 | 17.95 | 66620000.0 |
| 2013-11-01 | META | Stock | 50.85 | 52.09 | 49.72 | 49.75 | 95033000.0 |
| 2013-11-01 | TSLA | Stock | 10.8667 | 11.06 | 10.694 | 10.8113 | 107709000.0 |
| 2013-11-01 | TLT | Stock | 106.97 | 107.0 | 106.14 | 106.19 | 11349769.0 |
| 2013-11-01 | ES | Stock | 42.89 | 43.18 | 42.2 | 42.5 | 3119800.0 |
| 2013-11-01 | CL | Stock | 64.82 | 65.56 | 64.56 | 65.39 | 3770700.0 |
| 2013-11-01 | A | Stock | 36.4235 | 36.8956 | 36.3662 | 36.5522 | 2699538.0 |
| 2013-11-01 | AABA-DELISTED | Stock | 33.06 | 33.345 | 33.0 | 33.18 | 15068347.0 |
| 2013-11-01 | AACG | Stock | 4.22 | 4.34 | 4.15 | 4.2 | 12600.0 |
| 2013-11-01 | AAIC-DELISTED | Stock | 24.75 | 24.839 | 24.3 | 24.55 | 140657.0 |
| 2013-11-01 | AAMC-DELISTED | Stock | 188.2353 | 188.2353 | 185.1353 | 187.6471 | 18476.0 |
| 2013-11-01 | AAMRQ-DELISTED | Stock | 7.37 | 7.96 | 7.35 | 7.9 | 15942723.0 |
| 2013-11-01 | AAOI | Stock | 12.87 | 12.95 | 12.29 | 12.76 | 46400.0 |
| 2013-11-01 | AAON | Stock | 11.9822 | 12.1378 | 11.6267 | 12.0444 | 349425.0 |
| 2013-11-01 | AAP | Stock | 98.26 | 100.14 | 97.27 | 99.91 | 977300.0 |
| 2013-11-01 | AAT | Stock | 33.19 | 33.41 | 32.83 | 33.16 | 327200.0 |
| 2013-11-01 | AAU-DELISTED | Stock | 1.34 | 1.36 | 1.28 | 1.32 | 72359.0 |
| 2013-11-01 | AAUAF-DELISTED | Stock | 1.34 | 1.36 | 1.28 | 1.31 | 73209.0 |
| 2013-11-01 | AAV-DELISTED | Stock | 4.06 | 4.08 | 4.0 | 4.03 | 394349.0 |
| 2013-11-01 | AAWW-DELISTED | Stock | 37.23 | 38.77 | 37.16 | 38.46 | 1140899.0 |
| 2013-11-01 | AAXJ | Stock | 60.37 | 60.63 | 60.12 | 60.48 | 165564.0 |
| 2013-11-01 | AAXN-DELISTED | Stock | 17.71 | 17.8869 | 16.81 | 16.87 | 2505827.0 |
| 2013-11-01 | AB | Stock | 22.12 | 22.81 | 22.0 | 22.47 | 365000.0 |
| 2013-11-01 | ABAC-DELISTED | Stock | 1.38 | 1.55 | 1.38 | 1.47 | 41845.0 |
| 2013-11-01 | ABAX-DELISTED | Stock | 35.7 | 35.73 | 34.89 | 34.9 | 292667.0 |
| 2013-11-01 | ABB-DELISTED | Stock | 25.15 | 25.29 | 25.0 | 25.21 | 1579156.0 |
| 2013-11-01 | ABBNY-DELISTED | Stock | 25.16 | 25.29 | 25.0 | 25.21 | 1674054.0 |
| 2013-11-01 | ABBV | Stock | 48.64 | 49.33 | 48.5 | 48.96 | 3866900.0 |
| 2013-11-01 | ABC-DELISTED | Stock | 65.55 | 66.38 | 65.16 | 66.36 | 2282892.0 |
| 2013-11-01 | ABCB | Stock | 18.24 | 18.49 | 17.85 | 17.99 | 126700.0 |
| 2013-11-01 | ABCD-DELISTED | Stock | 1.45 | 1.45 | 1.3197 | 1.32 | 7218.0 |
| 2013-11-01 | ABCO-DELISTED | Stock | 68.43 | 68.95 | 67.61 | 68.57 | 236662.0 |
| 2013-11-01 | ABE-DELISTED | Stock | 20.4 | 20.4 | 20.0 | 20.13 | 14426.0 |
| 2013-11-01 | ABEO | Stock | 400.0 | 425.0 | 375.0 | 425.0 | 50.0 |
| 2013-11-01 | ABFS-DELISTED | Stock | 27.33 | 27.8199 | 27.18 | 27.34 | 416919.0 |
| 2013-11-01 | ABG | Stock | 48.08 | 48.89 | 47.56 | 48.74 | 414400.0 |
| 2013-11-01 | ABGB-DELISTED | Stock | 12.0898 | 12.1 | 11.99 | 12.1 | 17565.0 |
| 2013-11-01 | ABM | Stock | 27.46 | 27.89 | 27.46 | 27.74 | 367800.0 |
| 2013-11-01 | ABMD-DELISTED | Stock | 23.92 | 24.43 | 23.29 | 24.35 | 820336.0 |
| 2013-11-01 | ABR | Stock | 6.64 | 6.65 | 6.54 | 6.58 | 94700.0 |
| 2013-11-01 | ABR.A-DELISTED | Stock | 25.15 | 25.15 | 25.15 | 25.15 | 1200.0 |
| 2013-11-01 | ABR.B-DELISTED | Stock | 23.45 | 23.45 | 23.11 | 23.4 | 3300.0 |
| 2013-11-01 | ABT | Stock | 36.69 | 37.04 | 36.61 | 36.96 | 5557400.0 |
| 2013-11-01 | ABTL-DELISTED | Stock | 8.13 | 8.15 | 7.401 | 7.62 | 129894.0 |
| 2013-11-01 | ABUS | Stock | 8.86 | 9.07 | 8.86 | 9.04 | 103400.0 |
| 2013-11-01 | ABV-DELISTED | Stock | 37.0 | 37.48 | 37.0 | 37.36 | 1813140.0 |
| 2013-11-01 | ABX-DELISTED | Stock | 18.15 | 18.46 | 17.87 | 18.01 | 73876974.0 |
> showing 50 of 6,411 rows — these rows as CSV