PREVIEW / stock_daily / 2017-04-24
file: by_date/stock_daily/2017/2017-04-24.parquet size: 215 KB rows: 6,459 symbols: 3,036
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 |
|---|---|---|---|---|---|---|---|
| 2017-04-24 | AAPL | Stock | 35.875 | 35.9875 | 35.795 | 35.91 | 68537200.0 |
| 2017-04-24 | MSFT | Stock | 67.48 | 67.66 | 67.1 | 67.53 | 29770000.0 |
| 2017-04-24 | NVDA | Stock | 2.574 | 2.587 | 2.5528 | 2.5738 | 371820000.0 |
| 2017-04-24 | AMZN | Stock | 45.434 | 45.4995 | 45.191 | 45.3705 | 62458000.0 |
| 2017-04-24 | GOOGL | Stock | 43.422 | 43.998 | 43.3055 | 43.9465 | 33929660.0 |
| 2017-04-24 | META | Stock | 144.96 | 145.67 | 144.34 | 145.47 | 14407200.0 |
| 2017-04-24 | TSLA | Stock | 20.6147 | 20.7033 | 20.4013 | 20.5353 | 76252500.0 |
| 2017-04-24 | TLT | Stock | 122.55 | 123.16 | 122.46 | 122.93 | 8066371.0 |
| 2017-04-24 | ES | Stock | 60.0 | 60.19 | 59.51 | 60.03 | 1026100.0 |
| 2017-04-24 | CL | Stock | 73.29 | 73.76 | 73.21 | 73.66 | 3311300.0 |
| 2017-04-24 | A | Stock | 53.93 | 54.53 | 53.91 | 54.44 | 2257700.0 |
| 2017-04-24 | AA | Stock | 32.24 | 33.44 | 32.15 | 33.31 | 7907300.0 |
| 2017-04-24 | AAAP-DELISTED | Stock | 37.56 | 37.85 | 37.43 | 37.77 | 30354.0 |
| 2017-04-24 | AABA-DELISTED | Stock | 47.89 | 48.2 | 47.75 | 48.15 | 9519313.0 |
| 2017-04-24 | AAC-DELISTED | Stock | 7.48 | 7.4931 | 7.07 | 7.17 | 141092.0 |
| 2017-04-24 | AACG | Stock | 3.72 | 4.05 | 3.72 | 3.99 | 39000.0 |
| 2017-04-24 | AAIC-DELISTED | Stock | 14.5 | 14.5 | 14.3 | 14.45 | 336250.0 |
| 2017-04-24 | AAL | Stock | 45.5 | 46.44 | 45.47 | 46.44 | 6335300.0 |
| 2017-04-24 | AAM.A-DELISTED | Stock | 25.3 | 25.305 | 25.21 | 25.28 | 104517.0 |
| 2017-04-24 | AAMC-DELISTED | Stock | 21.0735 | 22.1324 | 20.1471 | 21.25 | 22358.0 |
| 2017-04-24 | AAME | Stock | 3.75 | 3.75 | 3.75 | 3.75 | 400.0 |
| 2017-04-24 | AAMI | Stock | 15.29 | 15.5 | 15.28 | 15.41 | 438100.0 |
| 2017-04-24 | AAOI | Stock | 46.83 | 48.89 | 45.83 | 48.78 | 6052100.0 |
| 2017-04-24 | AAON | Stock | 24.5667 | 24.6667 | 24.3667 | 24.5 | 139950.0 |
| 2017-04-24 | AAP | Stock | 147.88 | 148.35 | 145.92 | 147.1 | 905200.0 |
| 2017-04-24 | AAT | Stock | 44.58 | 44.61 | 43.07 | 43.09 | 330400.0 |
| 2017-04-24 | AAU-DELISTED | Stock | 1.45 | 1.58 | 1.45 | 1.57 | 337241.0 |
| 2017-04-24 | AAUAF-DELISTED | Stock | 1.45 | 1.58 | 1.45 | 1.58 | 339063.0 |
| 2017-04-24 | AAV-DELISTED | Stock | 6.45 | 6.525 | 6.4 | 6.45 | 39668.0 |
| 2017-04-24 | AAWW-DELISTED | Stock | 57.9 | 58.9 | 57.05 | 58.35 | 107667.0 |
| 2017-04-24 | AAXJ | Stock | 63.43 | 63.52 | 63.335 | 63.41 | 1335563.0 |
| 2017-04-24 | AAXN-DELISTED | Stock | 24.0 | 24.05 | 23.72 | 24.03 | 839286.0 |
| 2017-04-24 | AB | Stock | 23.25 | 23.26 | 22.75 | 22.75 | 323100.0 |
| 2017-04-24 | ABAC-DELISTED | Stock | 2.25 | 2.3 | 1.67 | 1.77 | 183986.0 |
| 2017-04-24 | ABAX-DELISTED | Stock | 49.34 | 49.8 | 49.2 | 49.29 | 75650.0 |
| 2017-04-24 | ABB-DELISTED | Stock | 23.85 | 23.97 | 23.79 | 23.93 | 2837858.0 |
| 2017-04-24 | ABBNY-DELISTED | Stock | 23.85 | 23.97 | 23.79 | 23.93 | 2907586.0 |
| 2017-04-24 | ABBV | Stock | 64.4 | 65.16 | 64.26 | 64.66 | 7121000.0 |
| 2017-04-24 | ABC-DELISTED | Stock | 82.03 | 82.105 | 80.81 | 81.07 | 1790590.0 |
| 2017-04-24 | ABCB | Stock | 47.45 | 47.9 | 47.0 | 47.45 | 260000.0 |
| 2017-04-24 | ABCD-DELISTED | Stock | 4.9 | 4.95 | 4.84 | 4.94 | 22602.0 |
| 2017-04-24 | ABCO-DELISTED | Stock | 47.8 | 47.95 | 46.95 | 47.0 | 151847.0 |
| 2017-04-24 | ABDC-DELISTED | Stock | 14.46 | 14.46 | 14.1 | 14.2 | 34076.0 |
| 2017-04-24 | ABE-DELISTED | Stock | 13.49 | 13.53 | 13.48 | 13.5 | 86960.0 |
| 2017-04-24 | ABEO | Stock | 131.25 | 131.25 | 127.5 | 131.25 | 6416.0 |
| 2017-04-24 | ABEV | Stock | 5.73 | 5.79 | 5.7 | 5.7 | 19057100.0 |
| 2017-04-24 | ABG | Stock | 62.45 | 63.85 | 62.35 | 63.1 | 261600.0 |
| 2017-04-24 | ABIL-DELISTED | Stock | 0.9998 | 1.01 | 0.9 | 0.92 | 154281.0 |
| 2017-04-24 | ABM | Stock | 43.59 | 43.65 | 43.3 | 43.54 | 227300.0 |
| 2017-04-24 | ABMD-DELISTED | Stock | 126.19 | 130.43 | 126.19 | 129.21 | 327871.0 |
> showing 50 of 6,459 rows — these rows as CSV