PREVIEW / stock_daily / 2015-04-29
file: by_date/stock_daily/2015/2015-04-29.parquet size: 222 KB rows: 6,623 symbols: 3,495
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-04-29 | AAPL | Stock | 32.54 | 32.8975 | 32.075 | 32.16 | 253544400.0 |
| 2015-04-29 | MSFT | Stock | 48.72 | 49.31 | 48.5 | 49.06 | 47804600.0 |
| 2015-04-29 | NVDA | Stock | 0.5538 | 0.5592 | 0.5512 | 0.5535 | 195156000.0 |
| 2015-04-29 | AMZN | Stock | 21.3375 | 21.712 | 21.3015 | 21.4685 | 72434000.0 |
| 2015-04-29 | GOOGL | Stock | 28.0255 | 28.292 | 27.95 | 28.0695 | 33621280.0 |
| 2015-04-29 | META | Stock | 80.01 | 81.39 | 79.52 | 80.47 | 26430300.0 |
| 2015-04-29 | TSLA | Stock | 15.3367 | 15.6647 | 15.1753 | 15.4967 | 59041500.0 |
| 2015-04-29 | TLT | Stock | 125.81 | 126.44 | 125.28 | 125.73 | 11554821.0 |
| 2015-04-29 | ES | Stock | 49.95 | 50.32 | 49.57 | 50.01 | 996300.0 |
| 2015-04-29 | CL | Stock | 68.49 | 68.98 | 68.3 | 68.51 | 4647300.0 |
| 2015-04-29 | A | Stock | 42.04 | 42.2 | 41.44 | 41.96 | 2161000.0 |
| 2015-04-29 | AA.B-DELISTED | Stock | 45.32 | 46.01 | 45.32 | 46.01 | 71215.0 |
| 2015-04-29 | AABA-DELISTED | Stock | 43.88 | 44.05 | 43.09 | 43.28 | 11981406.0 |
| 2015-04-29 | AAC-DELISTED | Stock | 31.66 | 32.01 | 30.4 | 31.3 | 189194.0 |
| 2015-04-29 | AACG | Stock | 4.56 | 4.64 | 4.23 | 4.53 | 9500.0 |
| 2015-04-29 | AAIC-DELISTED | Stock | 21.99 | 22.24 | 21.85 | 22.23 | 565353.0 |
| 2015-04-29 | AAL | Stock | 50.58 | 50.8 | 47.66 | 48.88 | 18050300.0 |
| 2015-04-29 | AAMC-DELISTED | Stock | 63.4382 | 69.1176 | 63.2353 | 68.1029 | 40137.0 |
| 2015-04-29 | AAME | Stock | 3.9 | 3.96 | 3.9 | 3.96 | 300.0 |
| 2015-04-29 | AAMI | Stock | 19.67 | 19.9 | 19.42 | 19.63 | 98000.0 |
| 2015-04-29 | AAOI | Stock | 14.94 | 15.47 | 14.794 | 15.01 | 194900.0 |
| 2015-04-29 | AAON | Stock | 16.5467 | 16.5467 | 16.2467 | 16.3533 | 111600.0 |
| 2015-04-29 | AAP | Stock | 144.5 | 145.18 | 143.51 | 144.66 | 707900.0 |
| 2015-04-29 | AAT | Stock | 41.75 | 41.75 | 40.8 | 40.8 | 139700.0 |
| 2015-04-29 | AAU-DELISTED | Stock | 0.85 | 0.8535 | 0.8149 | 0.82 | 179401.0 |
| 2015-04-29 | AAUAF-DELISTED | Stock | 0.83 | 0.8379 | 0.8 | 0.815 | 183281.0 |
| 2015-04-29 | AAV-DELISTED | Stock | 5.98 | 6.28 | 5.98 | 6.16 | 110335.0 |
| 2015-04-29 | AAVL-DELISTED | Stock | 36.66 | 37.32 | 34.96 | 35.02 | 217864.0 |
| 2015-04-29 | AAWW-DELISTED | Stock | 43.36 | 43.78 | 42.91 | 43.71 | 172611.0 |
| 2015-04-29 | AAXJ | Stock | 69.01 | 69.2 | 68.77 | 69.01 | 1160892.0 |
| 2015-04-29 | AAXN-DELISTED | Stock | 28.76 | 28.79 | 27.88 | 28.06 | 2424595.0 |
| 2015-04-29 | AB | Stock | 31.26 | 31.44 | 30.91 | 31.1 | 225700.0 |
| 2015-04-29 | ABAC-DELISTED | Stock | 1.7245 | 1.75 | 1.7 | 1.7 | 21523.0 |
| 2015-04-29 | ABAX-DELISTED | Stock | 64.56 | 64.74 | 63.46 | 64.12 | 135075.0 |
| 2015-04-29 | ABB-DELISTED | Stock | 22.14 | 22.305 | 22.0 | 22.2 | 2698327.0 |
| 2015-04-29 | ABBNY-DELISTED | Stock | 22.14 | 22.305 | 22.0 | 22.2 | 3005061.0 |
| 2015-04-29 | ABBV | Stock | 65.7 | 66.18 | 65.51 | 65.63 | 9864300.0 |
| 2015-04-29 | ABC-DELISTED | Stock | 113.69 | 113.99 | 112.12 | 112.44 | 1899106.0 |
| 2015-04-29 | ABCB | Stock | 25.36 | 25.65 | 25.24 | 25.38 | 50300.0 |
| 2015-04-29 | ABCD-DELISTED | Stock | 3.04 | 3.04 | 2.95 | 3.02 | 38125.0 |
| 2015-04-29 | ABCO-DELISTED | Stock | 52.74 | 53.49 | 52.53 | 52.95 | 264833.0 |
| 2015-04-29 | ABCW-DELISTED | Stock | 35.0 | 37.35 | 34.99 | 36.87 | 19679.0 |
| 2015-04-29 | ABDC-DELISTED | Stock | 13.75 | 13.85 | 13.67 | 13.69 | 71590.0 |
| 2015-04-29 | ABE-DELISTED | Stock | 13.33 | 13.3441 | 13.24 | 13.24 | 19155.0 |
| 2015-04-29 | ABEO | Stock | 79.75 | 82.75 | 69.0 | 69.25 | 25532.0 |
| 2015-04-29 | ABEOW-DELISTED | Stock | 1.41 | 1.41 | 1.15 | 1.28 | 3904.0 |
| 2015-04-29 | ABEV | Stock | 6.39 | 6.45 | 6.35 | 6.37 | 7261000.0 |
| 2015-04-29 | ABG | Stock | 86.22 | 87.49 | 85.55 | 85.64 | 379500.0 |
| 2015-04-29 | ABGB-DELISTED | Stock | 16.36 | 16.47 | 16.28 | 16.34 | 15525.0 |
| 2015-04-29 | ABIL-DELISTED | Stock | 10.11 | 10.11 | 9.68 | 10.11 | 6573.0 |
> showing 50 of 6,623 rows — these rows as CSV