PREVIEW / stock_daily / 2013-11-08
file: by_date/stock_daily/2013/2013-11-08.parquet size: 214 KB rows: 6,447 symbols: 3,551
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-08 | AAPL | Stock | 18.3779 | 18.6118 | 18.3068 | 18.5914 | 279316800.0 |
| 2013-11-08 | MSFT | Stock | 37.67 | 37.78 | 37.34 | 37.78 | 36737800.0 |
| 2013-11-08 | NVDA | Stock | 0.375 | 0.3902 | 0.3735 | 0.389 | 734532000.0 |
| 2013-11-08 | AMZN | Stock | 17.2975 | 17.5525 | 17.202 | 17.5155 | 53138000.0 |
| 2013-11-08 | META | Stock | 47.81 | 48.65 | 47.25 | 47.53 | 70731000.0 |
| 2013-11-08 | TSLA | Stock | 9.0987 | 9.3733 | 8.8213 | 9.1967 | 337168500.0 |
| 2013-11-08 | TLT | Stock | 103.97 | 104.11 | 103.39 | 103.41 | 16889902.0 |
| 2013-11-08 | ES | Stock | 42.27 | 42.27 | 41.49 | 42.27 | 1504000.0 |
| 2013-11-08 | CL | Stock | 64.65 | 64.85 | 64.13 | 64.83 | 3020200.0 |
| 2013-11-08 | A | Stock | 35.8655 | 36.4378 | 35.7725 | 36.3233 | 2601119.0 |
| 2013-11-08 | AABA-DELISTED | Stock | 32.25 | 33.12 | 32.2 | 33.12 | 14906089.0 |
| 2013-11-08 | AACG | Stock | 4.26 | 4.27 | 4.14 | 4.23 | 19600.0 |
| 2013-11-08 | AAIC-DELISTED | Stock | 24.85 | 24.92 | 24.631 | 24.82 | 117040.0 |
| 2013-11-08 | AAMC-DELISTED | Stock | 183.3412 | 188.0824 | 183.3412 | 185.4206 | 1343.0 |
| 2013-11-08 | AAME | Stock | 3.77 | 4.04 | 3.77 | 4.02 | 800.0 |
| 2013-11-08 | AAMRQ-DELISTED | Stock | 9.275 | 9.78 | 9.26 | 9.62 | 8720309.0 |
| 2013-11-08 | AAOI | Stock | 12.9 | 12.99 | 12.42 | 12.8 | 88200.0 |
| 2013-11-08 | AAON | Stock | 11.6667 | 12.3067 | 11.5556 | 11.64 | 278100.0 |
| 2013-11-08 | AAP | Stock | 96.92 | 97.96 | 96.65 | 96.96 | 426200.0 |
| 2013-11-08 | AAT | Stock | 31.79 | 32.01 | 31.27 | 31.94 | 109500.0 |
| 2013-11-08 | AAU-DELISTED | Stock | 1.26 | 1.29 | 1.22 | 1.28 | 70169.0 |
| 2013-11-08 | AAUAF-DELISTED | Stock | 1.26 | 1.29 | 1.22 | 1.28 | 70469.0 |
| 2013-11-08 | AAV-DELISTED | Stock | 3.74 | 3.99 | 3.74 | 3.96 | 373430.0 |
| 2013-11-08 | AAWW-DELISTED | Stock | 38.38 | 38.88 | 38.02 | 38.29 | 397133.0 |
| 2013-11-08 | AAXJ | Stock | 58.7 | 59.01 | 58.54 | 59.0 | 344729.0 |
| 2013-11-08 | AAXN-DELISTED | Stock | 15.98 | 17.08 | 15.8 | 16.87 | 1549522.0 |
| 2013-11-08 | AB | Stock | 21.78 | 22.26 | 21.39 | 21.79 | 379100.0 |
| 2013-11-08 | ABAC-DELISTED | Stock | 1.71 | 1.82 | 1.71 | 1.81 | 50944.0 |
| 2013-11-08 | ABAX-DELISTED | Stock | 34.97 | 35.63 | 34.81 | 35.19 | 128234.0 |
| 2013-11-08 | ABB-DELISTED | Stock | 24.95 | 25.27 | 24.93 | 25.27 | 1603122.0 |
| 2013-11-08 | ABBNY-DELISTED | Stock | 24.95 | 25.27 | 24.93 | 25.26 | 1715757.0 |
| 2013-11-08 | ABBV | Stock | 47.13 | 48.1 | 46.83 | 48.03 | 5190900.0 |
| 2013-11-08 | ABC-DELISTED | Stock | 66.92 | 68.02 | 66.75 | 68.0 | 1461816.0 |
| 2013-11-08 | ABCB | Stock | 18.52 | 19.0 | 18.52 | 18.81 | 168500.0 |
| 2013-11-08 | ABCD-DELISTED | Stock | 1.33 | 1.42 | 1.33 | 1.4 | 58799.0 |
| 2013-11-08 | ABCO-DELISTED | Stock | 60.3 | 62.35 | 60.19 | 61.92 | 215244.0 |
| 2013-11-08 | ABE-DELISTED | Stock | 19.48 | 19.79 | 19.48 | 19.78 | 2400.0 |
| 2013-11-08 | ABEO | Stock | 375.0 | 412.5 | 375.0 | 412.5 | 69.0 |
| 2013-11-08 | ABFS-DELISTED | Stock | 25.56 | 26.95 | 25.25 | 26.64 | 493144.0 |
| 2013-11-08 | ABG | Stock | 47.84 | 48.85 | 47.84 | 48.62 | 232800.0 |
| 2013-11-08 | ABGB-DELISTED | Stock | 11.48 | 11.6181 | 11.3 | 11.55 | 8700.0 |
| 2013-11-08 | ABM | Stock | 27.26 | 28.0 | 27.22 | 27.88 | 194700.0 |
| 2013-11-08 | ABMD-DELISTED | Stock | 25.72 | 27.24 | 25.71 | 27.2 | 733567.0 |
| 2013-11-08 | ABR | Stock | 6.52 | 6.6 | 6.26 | 6.52 | 298900.0 |
| 2013-11-08 | ABR.A-DELISTED | Stock | 25.119 | 25.119 | 25.0 | 25.0 | 3888.0 |
| 2013-11-08 | ABR.B-DELISTED | Stock | 23.5 | 23.5 | 23.5 | 23.5 | 1900.0 |
| 2013-11-08 | ABT | Stock | 37.51 | 38.14 | 37.22 | 38.12 | 8753900.0 |
| 2013-11-08 | ABTL-DELISTED | Stock | 8.72 | 9.89 | 8.7 | 9.59 | 650322.0 |
| 2013-11-08 | ABUS | Stock | 7.46 | 7.83 | 7.19 | 7.76 | 150000.0 |
| 2013-11-08 | ABV-DELISTED | Stock | 36.66 | 37.85 | 36.57 | 37.2 | 13454718.0 |
> showing 50 of 6,447 rows — these rows as CSV