PREVIEW / stock_daily / 2015-04-22
file: by_date/stock_daily/2015/2015-04-22.parquet size: 223 KB rows: 6,630 symbols: 3,504
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-22 | AAPL | Stock | 31.7475 | 32.2175 | 31.58 | 32.155 | 150618000.0 |
| 2015-04-22 | MSFT | Stock | 42.67 | 43.13 | 42.55 | 42.99 | 25064300.0 |
| 2015-04-22 | NVDA | Stock | 0.5548 | 0.5585 | 0.5462 | 0.5578 | 207420000.0 |
| 2015-04-22 | AMZN | Stock | 19.5955 | 19.714 | 19.4 | 19.49 | 69494000.0 |
| 2015-04-22 | GOOGL | Stock | 27.153 | 27.55 | 27.066 | 27.459 | 31806400.0 |
| 2015-04-22 | META | Stock | 84.32 | 84.74 | 83.65 | 84.63 | 45548000.0 |
| 2015-04-22 | TSLA | Stock | 14.1667 | 14.792 | 14.1127 | 14.6293 | 117945000.0 |
| 2015-04-22 | TLT | Stock | 129.5 | 129.55 | 127.54 | 127.72 | 9707563.0 |
| 2015-04-22 | ES | Stock | 50.03 | 50.03 | 49.33 | 49.46 | 1614100.0 |
| 2015-04-22 | CL | Stock | 69.0 | 69.31 | 68.69 | 69.28 | 2350100.0 |
| 2015-04-22 | A | Stock | 42.72 | 42.84 | 42.37 | 42.71 | 2726100.0 |
| 2015-04-22 | AA.B-DELISTED | Stock | 45.8 | 45.85 | 45.43 | 45.75 | 28850.0 |
| 2015-04-22 | AABA-DELISTED | Stock | 44.58 | 44.85 | 43.67 | 43.97 | 30506476.0 |
| 2015-04-22 | AAC-DELISTED | Stock | 33.1 | 33.39 | 32.5 | 33.24 | 65650.0 |
| 2015-04-22 | AACG | Stock | 4.58 | 4.59 | 4.48 | 4.48 | 6200.0 |
| 2015-04-22 | AAIC-DELISTED | Stock | 23.91 | 23.95 | 23.65 | 23.7 | 474060.0 |
| 2015-04-22 | AAL | Stock | 51.4 | 51.54 | 50.4 | 51.4 | 7333300.0 |
| 2015-04-22 | AAMC-DELISTED | Stock | 66.7618 | 66.7618 | 63.4088 | 65.8324 | 47750.0 |
| 2015-04-22 | AAME | Stock | 3.96 | 3.96 | 3.96 | 3.96 | 200.0 |
| 2015-04-22 | AAMI | Stock | 18.93 | 19.26 | 18.896 | 19.08 | 69400.0 |
| 2015-04-22 | AAOI | Stock | 14.94 | 14.97 | 14.26 | 14.6 | 157500.0 |
| 2015-04-22 | AAON | Stock | 16.24 | 16.38 | 15.9667 | 16.3467 | 104100.0 |
| 2015-04-22 | AAP | Stock | 152.23 | 152.61 | 150.5 | 151.51 | 1189000.0 |
| 2015-04-22 | AAT | Stock | 41.29 | 41.64 | 40.62 | 41.35 | 192600.0 |
| 2015-04-22 | AAU-DELISTED | Stock | 0.83 | 0.83 | 0.8002 | 0.81 | 99364.0 |
| 2015-04-22 | AAUAF-DELISTED | Stock | 0.83 | 0.83 | 0.8002 | 0.81 | 100475.0 |
| 2015-04-22 | AAV-DELISTED | Stock | 6.07 | 6.17 | 5.94 | 5.98 | 51847.0 |
| 2015-04-22 | AAVL-DELISTED | Stock | 39.41 | 39.74 | 37.86 | 38.91 | 220731.0 |
| 2015-04-22 | AAWW-DELISTED | Stock | 43.78 | 43.95 | 42.97 | 42.99 | 173217.0 |
| 2015-04-22 | AAXJ | Stock | 69.07 | 69.17 | 68.8 | 69.13 | 973264.0 |
| 2015-04-22 | AAXN-DELISTED | Stock | 28.79 | 29.67 | 28.7 | 29.5 | 1475094.0 |
| 2015-04-22 | AB | Stock | 31.29 | 31.66 | 31.09 | 31.38 | 151200.0 |
| 2015-04-22 | ABAC-DELISTED | Stock | 1.6701 | 1.75 | 1.67 | 1.75 | 5600.0 |
| 2015-04-22 | ABAX-DELISTED | Stock | 63.37 | 63.5 | 62.55 | 63.22 | 46381.0 |
| 2015-04-22 | ABB-DELISTED | Stock | 21.87 | 21.91 | 21.78 | 21.86 | 1098151.0 |
| 2015-04-22 | ABBNY-DELISTED | Stock | 21.87 | 21.91 | 21.78 | 21.85 | 1165577.0 |
| 2015-04-22 | ABBV | Stock | 63.6 | 64.73 | 63.56 | 64.52 | 13874300.0 |
| 2015-04-22 | ABC-DELISTED | Stock | 113.85 | 114.41 | 113.37 | 113.82 | 1021113.0 |
| 2015-04-22 | ABCB | Stock | 25.74 | 25.8 | 25.29 | 25.67 | 52400.0 |
| 2015-04-22 | ABCD-DELISTED | Stock | 3.13 | 3.13 | 3.0 | 3.0 | 78728.0 |
| 2015-04-22 | ABCO-DELISTED | Stock | 52.23 | 52.35 | 51.46 | 51.98 | 197602.0 |
| 2015-04-22 | ABCW-DELISTED | Stock | 34.43 | 34.57 | 33.85 | 34.16 | 8603.0 |
| 2015-04-22 | ABDC-DELISTED | Stock | 13.82 | 13.88 | 13.65 | 13.7 | 40769.0 |
| 2015-04-22 | ABE-DELISTED | Stock | 13.32 | 13.4801 | 13.32 | 13.36 | 22473.0 |
| 2015-04-22 | ABEO | Stock | 79.25 | 86.5 | 77.75 | 84.25 | 7760.0 |
| 2015-04-22 | ABEOW-DELISTED | Stock | 1.25 | 1.28 | 1.24 | 1.28 | 55400.0 |
| 2015-04-22 | ABEV | Stock | 6.24 | 6.31 | 6.23 | 6.28 | 13352200.0 |
| 2015-04-22 | ABG | Stock | 87.24 | 88.79 | 85.95 | 86.97 | 277600.0 |
| 2015-04-22 | ABGB-DELISTED | Stock | 16.6 | 16.6 | 16.28 | 16.39 | 29913.0 |
| 2015-04-22 | ABIL-DELISTED | Stock | 10.12 | 10.2 | 10.12 | 10.2 | 15537.0 |
> showing 50 of 6,630 rows — these rows as CSV