PREVIEW / stock_daily / 2013-05-24
file: by_date/stock_daily/2013/2013-05-24.parquet size: 210 KB rows: 6,344 symbols: 3,530
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-05-24 | AAPL | Stock | 15.7446 | 15.9164 | 15.7271 | 15.8982 | 276166800.0 |
| 2013-05-24 | MSFT | Stock | 33.92 | 34.28 | 33.9 | 34.27 | 33174400.0 |
| 2013-05-24 | NVDA | Stock | 0.3638 | 0.3668 | 0.3595 | 0.3635 | 283304000.0 |
| 2013-05-24 | AMZN | Stock | 12.9925 | 13.0965 | 12.917 | 13.087 | 33926000.0 |
| 2013-05-24 | META | Stock | 24.97 | 24.97 | 24.08 | 24.31 | 58727900.0 |
| 2013-05-24 | TSLA | Stock | 6.1733 | 6.53 | 6.1333 | 6.472 | 241863000.0 |
| 2013-05-24 | TLT | Stock | 116.98 | 117.42 | 116.7149 | 116.8 | 5357595.0 |
| 2013-05-24 | ES | Stock | 43.37 | 43.37 | 42.51 | 42.84 | 1714700.0 |
| 2013-05-24 | CL | Stock | 60.87 | 61.31 | 60.48 | 61.17 | 1756700.0 |
| 2013-05-24 | A | Stock | 32.4464 | 32.6824 | 32.3677 | 32.6109 | 3111109.0 |
| 2013-05-24 | AABA-DELISTED | Stock | 25.83 | 26.48 | 25.65 | 26.33 | 14834136.0 |
| 2013-05-24 | AACC-DELISTED | Stock | 6.65 | 6.71 | 6.63 | 6.7 | 252273.0 |
| 2013-05-24 | AACG | Stock | 4.64 | 4.8 | 4.53 | 4.55 | 9700.0 |
| 2013-05-24 | AAIC-DELISTED | Stock | 28.2 | 28.4447 | 27.66 | 28.12 | 187102.0 |
| 2013-05-24 | AAMC-DELISTED | Stock | 86.7647 | 86.7647 | 81.4706 | 82.7941 | 20964.0 |
| 2013-05-24 | AAME | Stock | 3.69 | 3.86 | 3.65 | 3.86 | 31500.0 |
| 2013-05-24 | AAMRQ-DELISTED | Stock | 5.61 | 5.84 | 5.61 | 5.8 | 3410728.0 |
| 2013-05-24 | AAON | Stock | 9.7452 | 9.9852 | 9.6563 | 9.917 | 333450.0 |
| 2013-05-24 | AAP | Stock | 83.75 | 84.02 | 83.12 | 83.39 | 589900.0 |
| 2013-05-24 | AAT | Stock | 34.62 | 34.77 | 34.16 | 34.76 | 130800.0 |
| 2013-05-24 | AAU-DELISTED | Stock | 1.65 | 1.65 | 1.6 | 1.6 | 46337.0 |
| 2013-05-24 | AAUAF-DELISTED | Stock | 1.65 | 1.65 | 1.6 | 1.6 | 47437.0 |
| 2013-05-24 | AAV-DELISTED | Stock | 4.36 | 4.41 | 4.31 | 4.4 | 621885.0 |
| 2013-05-24 | AAWW-DELISTED | Stock | 45.1 | 45.44 | 44.2 | 45.32 | 163252.0 |
| 2013-05-24 | AAXJ | Stock | 59.23 | 59.35 | 59.03 | 59.19 | 2295926.0 |
| 2013-05-24 | AAXN-DELISTED | Stock | 9.12 | 9.65 | 9.1 | 9.56 | 1209638.0 |
| 2013-05-24 | AB | Stock | 25.65 | 25.74 | 25.12 | 25.17 | 200100.0 |
| 2013-05-24 | ABAC-DELISTED | Stock | 0.718 | 0.718 | 0.67 | 0.67 | 19900.0 |
| 2013-05-24 | ABAX-DELISTED | Stock | 43.35 | 44.072 | 43.12 | 43.67 | 52308.0 |
| 2013-05-24 | ABB-DELISTED | Stock | 22.28 | 22.31 | 22.18 | 22.25 | 1999243.0 |
| 2013-05-24 | ABBNY-DELISTED | Stock | 22.28 | 22.31 | 22.18 | 22.25 | 2106208.0 |
| 2013-05-24 | ABBV | Stock | 46.25 | 46.48 | 45.31 | 45.44 | 4511700.0 |
| 2013-05-24 | ABC-DELISTED | Stock | 54.36 | 54.56 | 54.04 | 54.44 | 1924741.0 |
| 2013-05-24 | ABCB | Stock | 16.04 | 16.39 | 15.9 | 16.39 | 18600.0 |
| 2013-05-24 | ABCD-DELISTED | Stock | 1.28 | 1.36 | 1.28 | 1.321 | 40431.0 |
| 2013-05-24 | ABCO-DELISTED | Stock | 49.94 | 50.51 | 49.72 | 50.41 | 107262.0 |
| 2013-05-24 | ABCW-DELISTED | Stock | 0.621 | 0.63 | 0.62 | 0.63 | 31361.0 |
| 2013-05-24 | ABE-DELISTED | Stock | 21.35 | 21.42 | 21.25 | 21.35 | 12659.0 |
| 2013-05-24 | ABEO | Stock | 650.0 | 687.5 | 600.0 | 662.5 | 7.0 |
| 2013-05-24 | ABFS-DELISTED | Stock | 17.59 | 17.7 | 17.3 | 17.65 | 352514.0 |
| 2013-05-24 | ABG | Stock | 40.73 | 41.29 | 40.43 | 41.11 | 166300.0 |
| 2013-05-24 | ABM | Stock | 23.32 | 23.51 | 23.13 | 23.5 | 94000.0 |
| 2013-05-24 | ABMD-DELISTED | Stock | 21.72 | 22.02 | 21.4 | 21.99 | 331568.0 |
| 2013-05-24 | ABR | Stock | 7.07 | 7.13 | 6.95 | 7.03 | 88500.0 |
| 2013-05-24 | ABR.A-DELISTED | Stock | 25.5999 | 25.66 | 25.53 | 25.5999 | 5769.0 |
| 2013-05-24 | ABR.B-DELISTED | Stock | 25.19 | 25.19 | 25.1499 | 25.18 | 3116.0 |
| 2013-05-24 | ABT | Stock | 37.17 | 37.84 | 37.11 | 37.76 | 5429900.0 |
| 2013-05-24 | ABTL-DELISTED | Stock | 4.9 | 5.04 | 4.63 | 4.63 | 33626.0 |
| 2013-05-24 | ABUS | Stock | 4.71 | 4.75 | 4.63 | 4.71 | 34400.0 |
| 2013-05-24 | ABV-DELISTED | Stock | 42.09 | 42.105 | 41.43 | 41.68 | 2158871.0 |
> showing 50 of 6,344 rows — these rows as CSV