PREVIEW / stock_daily / 2013-11-21
file: by_date/stock_daily/2013/2013-11-21.parquet size: 215 KB rows: 6,434 symbols: 3,531
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-21 | AAPL | Stock | 18.4857 | 18.6146 | 18.3454 | 18.6121 | 262026800.0 |
| 2013-11-21 | MSFT | Stock | 37.27 | 37.53 | 37.26 | 37.4 | 23064700.0 |
| 2013-11-21 | NVDA | Stock | 0.3808 | 0.384 | 0.379 | 0.3833 | 213568000.0 |
| 2013-11-21 | AMZN | Stock | 18.2025 | 18.4625 | 18.165 | 18.446 | 39292000.0 |
| 2013-11-21 | META | Stock | 46.99 | 47.46 | 46.69 | 46.7 | 34886000.0 |
| 2013-11-21 | TSLA | Stock | 8.1927 | 8.3193 | 8.0167 | 8.14 | 178557000.0 |
| 2013-11-21 | TLT | Stock | 102.51 | 103.19 | 102.16 | 102.95 | 8903032.0 |
| 2013-11-21 | ES | Stock | 42.13 | 42.42 | 41.94 | 42.18 | 1279000.0 |
| 2013-11-21 | CL | Stock | 65.37 | 66.04 | 65.32 | 65.98 | 3404500.0 |
| 2013-11-21 | A | Stock | 38.4835 | 39.02 | 38.412 | 38.6981 | 3379805.0 |
| 2013-11-21 | AABA-DELISTED | Stock | 36.23 | 36.6642 | 36.22 | 36.3 | 23340344.0 |
| 2013-11-21 | AACG | Stock | 4.05 | 4.1 | 4.02 | 4.05 | 10400.0 |
| 2013-11-21 | AAIC-DELISTED | Stock | 25.46 | 25.94 | 25.4435 | 25.91 | 92583.0 |
| 2013-11-21 | AAMC-DELISTED | Stock | 204.7794 | 208.8853 | 198.8412 | 208.8853 | 7480.0 |
| 2013-11-21 | AAME | Stock | 4.05 | 4.07 | 4.05 | 4.05 | 15900.0 |
| 2013-11-21 | AAMRQ-DELISTED | Stock | 12.04 | 12.18 | 11.98 | 12.0 | 6092737.0 |
| 2013-11-21 | AAOI | Stock | 12.5 | 12.56 | 12.38 | 12.56 | 27200.0 |
| 2013-11-21 | AAON | Stock | 12.6622 | 12.9067 | 12.6222 | 12.8933 | 177075.0 |
| 2013-11-21 | AAP | Stock | 100.0 | 100.88 | 99.16 | 100.04 | 949900.0 |
| 2013-11-21 | AAT | Stock | 31.72 | 32.21 | 31.53 | 32.12 | 163800.0 |
| 2013-11-21 | AAU-DELISTED | Stock | 1.11 | 1.14 | 1.06 | 1.1 | 108362.0 |
| 2013-11-21 | AAUAF-DELISTED | Stock | 1.11 | 1.14 | 1.06 | 1.1 | 110762.0 |
| 2013-11-21 | AAV-DELISTED | Stock | 3.89 | 4.01 | 3.89 | 4.0 | 136477.0 |
| 2013-11-21 | AAWW-DELISTED | Stock | 36.51 | 37.45 | 36.51 | 37.35 | 313329.0 |
| 2013-11-21 | AAXJ | Stock | 60.0 | 60.02 | 59.735 | 59.98 | 335872.0 |
| 2013-11-21 | AAXN-DELISTED | Stock | 16.83 | 17.17 | 16.75 | 16.99 | 941563.0 |
| 2013-11-21 | AB | Stock | 21.61 | 21.73 | 21.36 | 21.49 | 501000.0 |
| 2013-11-21 | ABAC-DELISTED | Stock | 1.8 | 1.9 | 1.7499 | 1.84 | 94179.0 |
| 2013-11-21 | ABAX-DELISTED | Stock | 35.54 | 35.86 | 35.23 | 35.51 | 141545.0 |
| 2013-11-21 | ABB-DELISTED | Stock | 25.06 | 25.06 | 24.9 | 25.02 | 697709.0 |
| 2013-11-21 | ABBNY-DELISTED | Stock | 25.06 | 25.06 | 24.9 | 25.02 | 816557.0 |
| 2013-11-21 | ABBV | Stock | 48.28 | 48.67 | 47.99 | 48.57 | 4459800.0 |
| 2013-11-21 | ABC-DELISTED | Stock | 69.3 | 70.04 | 69.28 | 69.8 | 1133903.0 |
| 2013-11-21 | ABCB | Stock | 19.25 | 19.78 | 19.22 | 19.57 | 55700.0 |
| 2013-11-21 | ABCD-DELISTED | Stock | 1.43 | 1.52 | 1.43 | 1.5 | 38811.0 |
| 2013-11-21 | ABCO-DELISTED | Stock | 60.5 | 61.78 | 60.15 | 61.42 | 117276.0 |
| 2013-11-21 | ABE-DELISTED | Stock | 19.601 | 19.8 | 19.601 | 19.799 | 5650.0 |
| 2013-11-21 | ABEO | Stock | 375.0 | 375.0 | 350.0 | 375.0 | 10.0 |
| 2013-11-21 | ABEV | Stock | 7.43 | 7.53 | 7.36 | 7.41 | 5432000.0 |
| 2013-11-21 | ABFS-DELISTED | Stock | 31.98 | 32.7044 | 31.6 | 32.25 | 441621.0 |
| 2013-11-21 | ABG | Stock | 50.45 | 51.68 | 50.22 | 51.47 | 167100.0 |
| 2013-11-21 | ABGB-DELISTED | Stock | 10.87 | 11.01 | 10.8 | 10.97 | 15560.0 |
| 2013-11-21 | ABM | Stock | 27.61 | 27.84 | 27.58 | 27.74 | 164000.0 |
| 2013-11-21 | ABMD-DELISTED | Stock | 27.43 | 28.5 | 27.25 | 28.38 | 409710.0 |
| 2013-11-21 | ABR | Stock | 6.63 | 6.63 | 6.51 | 6.53 | 61400.0 |
| 2013-11-21 | ABR.A-DELISTED | Stock | 25.92 | 25.92 | 25.92 | 25.92 | 500.0 |
| 2013-11-21 | ABR.B-DELISTED | Stock | 23.0 | 23.0 | 22.5 | 22.95 | 14040.0 |
| 2013-11-21 | ABT | Stock | 38.38 | 38.47 | 37.99 | 38.07 | 5049100.0 |
| 2013-11-21 | ABTL-DELISTED | Stock | 9.99 | 10.95 | 9.99 | 10.61 | 124108.0 |
| 2013-11-21 | ABUS | Stock | 7.89 | 8.03 | 7.7 | 7.82 | 148100.0 |
> showing 50 of 6,434 rows — these rows as CSV