PREVIEW / stock_daily / 2015-03-06
file: by_date/stock_daily/2015/2015-03-06.parquet size: 223 KB rows: 6,640 symbols: 3,518
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-06 | AAPL | Stock | 32.1 | 32.3425 | 31.565 | 31.65 | 291368400.0 |
| 2015-03-06 | MSFT | Stock | 43.0 | 43.11 | 42.15 | 42.36 | 36248800.0 |
| 2015-03-06 | NVDA | Stock | 0.5682 | 0.571 | 0.5632 | 0.5638 | 257392000.0 |
| 2015-03-06 | AMZN | Stock | 19.276 | 19.35 | 18.944 | 19.0045 | 52540000.0 |
| 2015-03-06 | GOOGL | Stock | 29.1 | 29.139 | 28.603 | 28.645 | 37592380.0 |
| 2015-03-06 | META | Stock | 80.9 | 81.33 | 79.83 | 80.01 | 24488600.0 |
| 2015-03-06 | TSLA | Stock | 13.2807 | 13.3833 | 12.81 | 12.9253 | 100686000.0 |
| 2015-03-06 | TLT | Stock | 124.67 | 124.83 | 122.97 | 123.5 | 20022904.0 |
| 2015-03-06 | ES | Stock | 49.6 | 49.92 | 48.54 | 48.76 | 1293900.0 |
| 2015-03-06 | CL | Stock | 70.83 | 70.98 | 69.14 | 69.25 | 3555200.0 |
| 2015-03-06 | A | Stock | 41.95 | 42.05 | 41.49 | 41.53 | 1528600.0 |
| 2015-03-06 | AA.B-DELISTED | Stock | 47.5 | 47.89 | 47.25 | 47.35 | 61574.0 |
| 2015-03-06 | AABA-DELISTED | Stock | 43.98 | 44.24 | 43.4 | 43.45 | 10501429.0 |
| 2015-03-06 | AAC-DELISTED | Stock | 31.84 | 31.93 | 29.16 | 29.28 | 272594.0 |
| 2015-03-06 | AACG | Stock | 4.29 | 4.29 | 3.9 | 3.9 | 7100.0 |
| 2015-03-06 | AAIC-DELISTED | Stock | 25.06 | 25.24 | 24.67 | 24.67 | 357874.0 |
| 2015-03-06 | AAL | Stock | 48.33 | 48.94 | 47.9 | 48.0 | 7002300.0 |
| 2015-03-06 | AAMC-DELISTED | Stock | 57.2765 | 57.4265 | 57.0912 | 57.4265 | 4335.0 |
| 2015-03-06 | AAME | Stock | 4.02 | 4.02 | 3.94 | 3.97 | 4100.0 |
| 2015-03-06 | AAMI | Stock | 17.5 | 18.46 | 17.4 | 17.56 | 400300.0 |
| 2015-03-06 | AAOI | Stock | 12.72 | 12.97 | 12.39 | 12.41 | 266400.0 |
| 2015-03-06 | AAON | Stock | 14.66 | 14.86 | 14.46 | 14.6133 | 117450.0 |
| 2015-03-06 | AAP | Stock | 151.71 | 152.96 | 148.47 | 149.07 | 1711100.0 |
| 2015-03-06 | AAT | Stock | 41.23 | 41.23 | 40.09 | 40.11 | 124400.0 |
| 2015-03-06 | AAU-DELISTED | Stock | 1.05 | 1.05 | 0.97 | 0.97 | 419287.0 |
| 2015-03-06 | AAUAF-DELISTED | Stock | 1.05 | 1.05 | 0.97 | 0.97 | 420357.0 |
| 2015-03-06 | AAV-DELISTED | Stock | 5.35 | 5.35 | 5.21 | 5.29 | 83748.0 |
| 2015-03-06 | AAVL-DELISTED | Stock | 37.5 | 37.62 | 35.26 | 35.91 | 256554.0 |
| 2015-03-06 | AAWW-DELISTED | Stock | 46.14 | 46.55 | 45.71 | 45.78 | 122784.0 |
| 2015-03-06 | AAXJ | Stock | 62.96 | 63.02 | 62.32 | 62.52 | 1225362.0 |
| 2015-03-06 | AAXN-DELISTED | Stock | 22.32 | 22.71 | 22.06 | 22.665 | 1812462.0 |
| 2015-03-06 | AB | Stock | 28.47 | 28.76 | 28.32 | 28.33 | 246900.0 |
| 2015-03-06 | ABAC-DELISTED | Stock | 1.46 | 1.5299 | 1.46 | 1.46 | 1820.0 |
| 2015-03-06 | ABAX-DELISTED | Stock | 61.95 | 62.57 | 61.5004 | 62.39 | 146773.0 |
| 2015-03-06 | ABB-DELISTED | Stock | 21.0 | 21.02 | 20.715 | 20.74 | 1310502.0 |
| 2015-03-06 | ABBNY-DELISTED | Stock | 21.0 | 21.02 | 20.715 | 20.75 | 1356433.0 |
| 2015-03-06 | ABBV | Stock | 56.95 | 57.4 | 55.44 | 55.64 | 22853000.0 |
| 2015-03-06 | ABC-DELISTED | Stock | 103.19 | 103.59 | 102.0 | 102.25 | 1410840.0 |
| 2015-03-06 | ABCB | Stock | 25.52 | 26.4 | 25.28 | 25.4 | 81700.0 |
| 2015-03-06 | ABCD-DELISTED | Stock | 2.85 | 3.111 | 2.85 | 2.95 | 109140.0 |
| 2015-03-06 | ABCO-DELISTED | Stock | 53.33 | 54.11 | 52.53 | 53.1 | 210627.0 |
| 2015-03-06 | ABCW-DELISTED | Stock | 33.65 | 34.63 | 33.65 | 34.13 | 2753.0 |
| 2015-03-06 | ABDC-DELISTED | Stock | 13.57 | 13.61 | 13.44 | 13.48 | 37350.0 |
| 2015-03-06 | ABE-DELISTED | Stock | 12.99 | 12.99 | 12.8 | 12.8201 | 1980.0 |
| 2015-03-06 | ABEO | Stock | 88.75 | 89.75 | 84.5 | 87.5 | 828.0 |
| 2015-03-06 | ABEOW-DELISTED | Stock | 1.13 | 1.13 | 1.13 | 1.13 | 10000.0 |
| 2015-03-06 | ABEV | Stock | 6.0 | 6.05 | 5.94 | 5.98 | 9664500.0 |
| 2015-03-06 | ABG | Stock | 78.0 | 78.33 | 75.66 | 76.29 | 465600.0 |
| 2015-03-06 | ABGB-DELISTED | Stock | 17.34 | 17.58 | 17.34 | 17.46 | 65103.0 |
| 2015-03-06 | ABIL-DELISTED | Stock | 9.91 | 9.98 | 9.87 | 9.92 | 4000.0 |
> showing 50 of 6,640 rows — these rows as CSV