PREVIEW / stock_1min / 2011-02-08
file: by_date/stock_1min/2011/2011-02-08.parquet size: 13.0 MB rows: 969,113 symbols: 2,867
schema
timestamp TIMESTAMP symbol VARCHAR asset_type VARCHAR open DOUBLE high DOUBLE low DOUBLE close DOUBLE volume DOUBLE
sample rows
| timestamp | symbol | asset_type | open | high | low | close | volume |
|---|---|---|---|---|---|---|---|
| 2011-02-08 05:45:00 | AAPL | Stock | 12.5661 | 12.5661 | 12.5661 | 12.5661 | 2800.0 |
| 2011-02-08 06:11:00 | AAPL | Stock | 12.5771 | 12.5771 | 12.5771 | 12.5771 | 2800.0 |
| 2011-02-08 06:30:00 | AAPL | Stock | 12.5782 | 12.5857 | 12.5493 | 12.5857 | 14000.0 |
| 2011-02-08 07:01:00 | AAPL | Stock | 12.5671 | 12.5671 | 12.5521 | 12.5521 | 16800.0 |
| 2011-02-08 07:05:00 | AAPL | Stock | 12.5714 | 12.5714 | 12.5714 | 12.5714 | 5600.0 |
| 2011-02-08 07:06:00 | AAPL | Stock | 12.5875 | 12.5875 | 12.5786 | 12.5857 | 21560.0 |
| 2011-02-08 07:10:00 | AAPL | Stock | 12.5843 | 12.5843 | 12.5839 | 12.5839 | 18900.0 |
| 2011-02-08 07:11:00 | AAPL | Stock | 12.5846 | 12.5871 | 12.5846 | 12.5871 | 5600.0 |
| 2011-02-08 07:16:00 | AAPL | Stock | 12.5893 | 12.5893 | 12.5839 | 12.5839 | 5600.0 |
| 2011-02-08 07:25:00 | AAPL | Stock | 12.5771 | 12.5775 | 12.5679 | 12.5714 | 90888.0 |
| 2011-02-08 07:26:00 | AAPL | Stock | 12.5714 | 12.5714 | 12.5625 | 12.5625 | 18200.0 |
| 2011-02-08 07:29:00 | AAPL | Stock | 12.5607 | 12.5607 | 12.5607 | 12.5607 | 11200.0 |
| 2011-02-08 07:30:00 | AAPL | Stock | 12.5643 | 12.5643 | 12.5643 | 12.5643 | 14000.0 |
| 2011-02-08 07:34:00 | AAPL | Stock | 12.56 | 12.56 | 12.5557 | 12.5557 | 60200.0 |
| 2011-02-08 07:35:00 | AAPL | Stock | 12.5625 | 12.5625 | 12.5625 | 12.5625 | 11200.0 |
| 2011-02-08 07:41:00 | AAPL | Stock | 12.55 | 12.55 | 12.55 | 12.55 | 13300.0 |
| 2011-02-08 07:50:00 | AAPL | Stock | 12.5643 | 12.5643 | 12.5643 | 12.5643 | 5600.0 |
| 2011-02-08 07:52:00 | AAPL | Stock | 12.5643 | 12.5643 | 12.5643 | 12.5643 | 7000.0 |
| 2011-02-08 07:53:00 | AAPL | Stock | 12.5675 | 12.5679 | 12.5675 | 12.5679 | 16800.0 |
| 2011-02-08 07:59:00 | AAPL | Stock | 12.5804 | 12.5804 | 12.5804 | 12.5804 | 8400.0 |
| 2011-02-08 08:00:00 | AAPL | Stock | 12.5804 | 12.5839 | 12.5771 | 12.5793 | 208404.0 |
| 2011-02-08 08:01:00 | AAPL | Stock | 12.5821 | 12.5839 | 12.5804 | 12.5821 | 74508.0 |
| 2011-02-08 08:02:00 | AAPL | Stock | 12.5821 | 12.5864 | 12.5821 | 12.5829 | 147756.0 |
| 2011-02-08 08:04:00 | AAPL | Stock | 12.5871 | 12.5871 | 12.585 | 12.5871 | 26600.0 |
| 2011-02-08 08:05:00 | AAPL | Stock | 12.5886 | 12.5893 | 12.5882 | 12.5893 | 35840.0 |
| 2011-02-08 08:06:00 | AAPL | Stock | 12.5911 | 12.595 | 12.5911 | 12.5946 | 50820.0 |
| 2011-02-08 08:07:00 | AAPL | Stock | 12.5939 | 12.5982 | 12.5939 | 12.5982 | 49280.0 |
| 2011-02-08 08:08:00 | AAPL | Stock | 12.5993 | 12.6029 | 12.5993 | 12.6029 | 145040.0 |
| 2011-02-08 08:09:00 | AAPL | Stock | 12.6007 | 12.6029 | 12.6 | 12.6025 | 201600.0 |
| 2011-02-08 08:10:00 | AAPL | Stock | 12.6021 | 12.6029 | 12.5964 | 12.5982 | 148596.0 |
| 2011-02-08 08:11:00 | AAPL | Stock | 12.6014 | 12.6036 | 12.5989 | 12.6032 | 128856.0 |
| 2011-02-08 08:12:00 | AAPL | Stock | 12.6036 | 12.6107 | 12.6036 | 12.6107 | 184184.0 |
| 2011-02-08 08:13:00 | AAPL | Stock | 12.6107 | 12.6139 | 12.6104 | 12.6136 | 99960.0 |
| 2011-02-08 08:14:00 | AAPL | Stock | 12.6114 | 12.6114 | 12.6054 | 12.6068 | 161700.0 |
| 2011-02-08 08:15:00 | AAPL | Stock | 12.6068 | 12.6068 | 12.6036 | 12.6036 | 25060.0 |
| 2011-02-08 08:16:00 | AAPL | Stock | 12.6029 | 12.6036 | 12.5989 | 12.6014 | 83496.0 |
| 2011-02-08 08:17:00 | AAPL | Stock | 12.6021 | 12.6021 | 12.5982 | 12.5982 | 56280.0 |
| 2011-02-08 08:18:00 | AAPL | Stock | 12.5975 | 12.5993 | 12.5964 | 12.5964 | 99400.0 |
| 2011-02-08 08:19:00 | AAPL | Stock | 12.5946 | 12.5946 | 12.5914 | 12.5914 | 59388.0 |
| 2011-02-08 08:20:00 | AAPL | Stock | 12.5921 | 12.5946 | 12.5921 | 12.5946 | 33600.0 |
| 2011-02-08 08:21:00 | AAPL | Stock | 12.5954 | 12.5964 | 12.5954 | 12.5964 | 13664.0 |
| 2011-02-08 08:22:00 | AAPL | Stock | 12.5946 | 12.5946 | 12.5946 | 12.5946 | 2800.0 |
| 2011-02-08 08:24:00 | AAPL | Stock | 12.5943 | 12.5943 | 12.5943 | 12.5943 | 5600.0 |
| 2011-02-08 08:25:00 | AAPL | Stock | 12.5932 | 12.5964 | 12.5907 | 12.5907 | 36064.0 |
| 2011-02-08 08:26:00 | AAPL | Stock | 12.5907 | 12.5907 | 12.5907 | 12.5907 | 2800.0 |
| 2011-02-08 08:27:00 | AAPL | Stock | 12.5929 | 12.5929 | 12.5929 | 12.5929 | 16800.0 |
| 2011-02-08 08:28:00 | AAPL | Stock | 12.5943 | 12.5943 | 12.5886 | 12.5886 | 152880.0 |
| 2011-02-08 08:29:00 | AAPL | Stock | 12.5904 | 12.5911 | 12.59 | 12.5911 | 44800.0 |
| 2011-02-08 08:30:00 | AAPL | Stock | 12.5925 | 12.5964 | 12.5925 | 12.5964 | 148596.0 |
| 2011-02-08 08:32:00 | AAPL | Stock | 12.5929 | 12.5929 | 12.5929 | 12.5929 | 5600.0 |
> showing 50 of 969,113 rows — these rows as CSV