PREVIEW / stock_daily / 2015-03-10
file: by_date/stock_daily/2015/2015-03-10.parquet size: 222 KB rows: 6,629 symbols: 3,503
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 |
|---|---|---|---|---|---|---|---|
| 2015-03-10 | AAPL | Stock | 31.6025 | 31.805 | 30.95 | 31.1275 | 275426400.0 |
| 2015-03-10 | MSFT | Stock | 42.35 | 42.71 | 42.03 | 42.03 | 39159700.0 |
| 2015-03-10 | NVDA | Stock | 0.5678 | 0.5788 | 0.5668 | 0.575 | 527212000.0 |
| 2015-03-10 | AMZN | Stock | 18.8725 | 18.8885 | 18.459 | 18.4755 | 62420000.0 |
| 2015-03-10 | GOOGL | Stock | 28.4238 | 28.4881 | 27.991 | 27.9925 | 40080480.0 |
| 2015-03-10 | META | Stock | 78.5 | 79.26 | 77.55 | 77.55 | 23067100.0 |
| 2015-03-10 | TSLA | Stock | 12.564 | 12.9 | 12.5067 | 12.688 | 83695500.0 |
| 2015-03-10 | TLT | Stock | 125.97 | 126.44 | 125.76 | 126.28 | 9277945.0 |
| 2015-03-10 | ES | Stock | 48.85 | 49.83 | 48.69 | 49.11 | 1286900.0 |
| 2015-03-10 | CL | Stock | 69.28 | 69.3 | 68.4 | 68.4 | 2492600.0 |
| 2015-03-10 | A | Stock | 41.22 | 41.27 | 40.63 | 40.63 | 1961300.0 |
| 2015-03-10 | AA.B-DELISTED | Stock | 45.53 | 45.8 | 45.09 | 45.16 | 154820.0 |
| 2015-03-10 | AABA-DELISTED | Stock | 42.49 | 42.92 | 42.18 | 42.67 | 10016680.0 |
| 2015-03-10 | AAC-DELISTED | Stock | 26.22 | 26.22 | 25.33 | 25.79 | 313629.0 |
| 2015-03-10 | AACG | Stock | 3.92 | 4.2 | 3.92 | 4.2 | 10600.0 |
| 2015-03-10 | AAIC-DELISTED | Stock | 24.52 | 24.54 | 24.33 | 24.36 | 263459.0 |
| 2015-03-10 | AAL | Stock | 47.5 | 47.58 | 46.47 | 46.74 | 9337100.0 |
| 2015-03-10 | AAMC-DELISTED | Stock | 60.1471 | 61.7647 | 58.8235 | 59.4118 | 52533.0 |
| 2015-03-10 | AAME | Stock | 4.02 | 4.02 | 4.01 | 4.01 | 1200.0 |
| 2015-03-10 | AAMI | Stock | 17.39 | 17.53 | 16.89 | 17.41 | 190500.0 |
| 2015-03-10 | AAOI | Stock | 11.91 | 12.28 | 11.9 | 12.12 | 140500.0 |
| 2015-03-10 | AAON | Stock | 14.4533 | 14.6067 | 14.34 | 14.5267 | 131850.0 |
| 2015-03-10 | AAP | Stock | 146.8 | 147.65 | 145.1 | 146.53 | 1291400.0 |
| 2015-03-10 | AAT | Stock | 40.57 | 41.26 | 40.49 | 40.87 | 187500.0 |
| 2015-03-10 | AAU-DELISTED | Stock | 0.96 | 0.9706 | 0.8991 | 0.9 | 304486.0 |
| 2015-03-10 | AAUAF-DELISTED | Stock | 0.94 | 0.95 | 0.88 | 0.9 | 313379.0 |
| 2015-03-10 | AAV-DELISTED | Stock | 5.07 | 5.2 | 5.0 | 5.12 | 121493.0 |
| 2015-03-10 | AAVL-DELISTED | Stock | 37.99 | 39.45 | 36.34 | 37.97 | 337100.0 |
| 2015-03-10 | AAWW-DELISTED | Stock | 46.12 | 46.385 | 44.94 | 44.98 | 92449.0 |
| 2015-03-10 | AAXJ | Stock | 61.49 | 61.62 | 61.18 | 61.19 | 743628.0 |
| 2015-03-10 | AAXN-DELISTED | Stock | 21.65 | 21.963 | 21.39 | 21.84 | 1233537.0 |
| 2015-03-10 | AB | Stock | 27.82 | 28.11 | 27.54 | 28.05 | 275300.0 |
| 2015-03-10 | ABAC-DELISTED | Stock | 1.5299 | 1.5299 | 1.5 | 1.509 | 5550.0 |
| 2015-03-10 | ABAX-DELISTED | Stock | 62.69 | 63.4 | 62.18 | 62.26 | 168988.0 |
| 2015-03-10 | ABB-DELISTED | Stock | 20.21 | 20.3 | 20.18 | 20.21 | 1140108.0 |
| 2015-03-10 | ABBNY-DELISTED | Stock | 20.21 | 20.3 | 20.18 | 20.2 | 1239095.0 |
| 2015-03-10 | ABBV | Stock | 55.22 | 56.3 | 54.78 | 55.84 | 17907700.0 |
| 2015-03-10 | ABC-DELISTED | Stock | 102.62 | 103.52 | 102.22 | 102.96 | 1671503.0 |
| 2015-03-10 | ABCB | Stock | 25.33 | 25.5 | 25.15 | 25.44 | 68000.0 |
| 2015-03-10 | ABCD-DELISTED | Stock | 3.0 | 3.03 | 2.96 | 3.005 | 29133.0 |
| 2015-03-10 | ABCO-DELISTED | Stock | 52.74 | 53.27 | 51.41 | 51.83 | 199862.0 |
| 2015-03-10 | ABCW-DELISTED | Stock | 34.03 | 34.57 | 33.6 | 34.05 | 9720.0 |
| 2015-03-10 | ABDC-DELISTED | Stock | 13.74 | 13.8 | 13.58 | 13.6 | 18950.0 |
| 2015-03-10 | ABE-DELISTED | Stock | 12.6 | 12.69 | 12.57 | 12.58 | 12654.0 |
| 2015-03-10 | ABEO | Stock | 86.5 | 88.75 | 84.0 | 86.75 | 1204.0 |
| 2015-03-10 | ABEOW-DELISTED | Stock | 1.09 | 1.09 | 1.0322 | 1.0322 | 1000.0 |
| 2015-03-10 | ABEV | Stock | 5.83 | 5.88 | 5.73 | 5.73 | 13560600.0 |
| 2015-03-10 | ABG | Stock | 75.13 | 75.47 | 74.58 | 75.18 | 278000.0 |
| 2015-03-10 | ABGB-DELISTED | Stock | 16.82 | 17.17 | 16.58 | 16.97 | 35610.0 |
| 2015-03-10 | ABIL-DELISTED | Stock | 9.96 | 10.0 | 9.96 | 10.0 | 301.0 |
> showing 50 of 6,629 rows — these rows as CSV