PREVIEW / stock_1min / 2014-01-03
file: by_date/stock_1min/2014/2014-01-03.parquet size: 14.0 MB rows: 1,016,043 symbols: 2,842
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 |
|---|---|---|---|---|---|---|---|
| 2014-01-03 04:50:00 | AAPL | Stock | 19.7607 | 19.7607 | 19.7607 | 19.7607 | 2800.0 |
| 2014-01-03 05:01:00 | AAPL | Stock | 19.7607 | 19.7607 | 19.7607 | 19.7607 | 8400.0 |
| 2014-01-03 05:11:00 | AAPL | Stock | 19.7607 | 19.7607 | 19.7607 | 19.7607 | 2800.0 |
| 2014-01-03 05:12:00 | AAPL | Stock | 19.7607 | 19.7607 | 19.7607 | 19.7607 | 2800.0 |
| 2014-01-03 06:04:00 | AAPL | Stock | 19.7732 | 19.7732 | 19.7732 | 19.7732 | 3920.0 |
| 2014-01-03 06:41:00 | AAPL | Stock | 19.7979 | 19.7979 | 19.7979 | 19.7979 | 2800.0 |
| 2014-01-03 06:43:00 | AAPL | Stock | 19.7979 | 19.7979 | 19.7979 | 19.7979 | 4312.0 |
| 2014-01-03 06:57:00 | AAPL | Stock | 19.7993 | 19.8 | 19.7993 | 19.8 | 8400.0 |
| 2014-01-03 07:00:00 | AAPL | Stock | 19.8 | 19.8 | 19.7864 | 19.7864 | 11200.0 |
| 2014-01-03 07:02:00 | AAPL | Stock | 19.7864 | 19.7864 | 19.7864 | 19.7864 | 8400.0 |
| 2014-01-03 07:05:00 | AAPL | Stock | 19.8071 | 19.8196 | 19.8071 | 19.8196 | 22120.0 |
| 2014-01-03 07:09:00 | AAPL | Stock | 19.8196 | 19.8279 | 19.8196 | 19.8279 | 7000.0 |
| 2014-01-03 07:11:00 | AAPL | Stock | 19.8214 | 19.8214 | 19.8107 | 19.8107 | 31304.0 |
| 2014-01-03 07:19:00 | AAPL | Stock | 19.7896 | 19.7896 | 19.7875 | 19.7875 | 7840.0 |
| 2014-01-03 07:26:00 | AAPL | Stock | 19.8014 | 19.8014 | 19.8014 | 19.8014 | 2800.0 |
| 2014-01-03 07:31:00 | AAPL | Stock | 19.8036 | 19.8043 | 19.7968 | 19.7968 | 26460.0 |
| 2014-01-03 07:32:00 | AAPL | Stock | 19.8179 | 19.8179 | 19.8179 | 19.8179 | 2800.0 |
| 2014-01-03 07:33:00 | AAPL | Stock | 19.8075 | 19.8075 | 19.8036 | 19.8036 | 14000.0 |
| 2014-01-03 07:44:00 | AAPL | Stock | 19.8143 | 19.8143 | 19.8143 | 19.8143 | 2800.0 |
| 2014-01-03 07:46:00 | AAPL | Stock | 19.8046 | 19.8046 | 19.8036 | 19.8036 | 21980.0 |
| 2014-01-03 07:48:00 | AAPL | Stock | 19.8125 | 19.8175 | 19.8125 | 19.8175 | 11200.0 |
| 2014-01-03 07:57:00 | AAPL | Stock | 19.8143 | 19.8143 | 19.8143 | 19.8143 | 11088.0 |
| 2014-01-03 07:58:00 | AAPL | Stock | 19.8146 | 19.8146 | 19.8139 | 19.8139 | 5600.0 |
| 2014-01-03 08:00:00 | AAPL | Stock | 19.8111 | 19.8211 | 19.7946 | 19.8029 | 83160.0 |
| 2014-01-03 08:01:00 | AAPL | Stock | 19.8029 | 19.8036 | 19.8029 | 19.8036 | 15848.0 |
| 2014-01-03 08:02:00 | AAPL | Stock | 19.8089 | 19.8103 | 19.8089 | 19.8103 | 7420.0 |
| 2014-01-03 08:03:00 | AAPL | Stock | 19.8036 | 19.8121 | 19.8036 | 19.8121 | 11200.0 |
| 2014-01-03 08:04:00 | AAPL | Stock | 19.8125 | 19.8125 | 19.8107 | 19.8121 | 26712.0 |
| 2014-01-03 08:05:00 | AAPL | Stock | 19.8114 | 19.8125 | 19.8071 | 19.8071 | 38836.0 |
| 2014-01-03 08:06:00 | AAPL | Stock | 19.8114 | 19.8125 | 19.8107 | 19.8125 | 75908.0 |
| 2014-01-03 08:07:00 | AAPL | Stock | 19.8125 | 19.8143 | 19.8118 | 19.8121 | 20160.0 |
| 2014-01-03 08:08:00 | AAPL | Stock | 19.8114 | 19.8182 | 19.8114 | 19.8182 | 62720.0 |
| 2014-01-03 08:11:00 | AAPL | Stock | 19.8207 | 19.8214 | 19.8171 | 19.8214 | 64400.0 |
| 2014-01-03 08:12:00 | AAPL | Stock | 19.8204 | 19.8207 | 19.8204 | 19.8204 | 35980.0 |
| 2014-01-03 08:13:00 | AAPL | Stock | 19.8196 | 19.8196 | 19.8196 | 19.8196 | 3640.0 |
| 2014-01-03 08:14:00 | AAPL | Stock | 19.82 | 19.8204 | 19.82 | 19.8204 | 7840.0 |
| 2014-01-03 08:15:00 | AAPL | Stock | 19.8164 | 19.8164 | 19.8164 | 19.8164 | 7252.0 |
| 2014-01-03 08:16:00 | AAPL | Stock | 19.8161 | 19.8161 | 19.8036 | 19.8036 | 45556.0 |
| 2014-01-03 08:19:00 | AAPL | Stock | 19.8107 | 19.8107 | 19.8089 | 19.8089 | 8400.0 |
| 2014-01-03 08:21:00 | AAPL | Stock | 19.8039 | 19.8054 | 19.8032 | 19.8032 | 8400.0 |
| 2014-01-03 08:24:00 | AAPL | Stock | 19.8043 | 19.8043 | 19.7993 | 19.8036 | 66780.0 |
| 2014-01-03 08:25:00 | AAPL | Stock | 19.8125 | 19.8125 | 19.8036 | 19.8036 | 21560.0 |
| 2014-01-03 08:26:00 | AAPL | Stock | 19.8036 | 19.8036 | 19.7996 | 19.8036 | 28000.0 |
| 2014-01-03 08:27:00 | AAPL | Stock | 19.8036 | 19.8036 | 19.8036 | 19.8036 | 5600.0 |
| 2014-01-03 08:28:00 | AAPL | Stock | 19.8 | 19.8 | 19.7946 | 19.7946 | 72800.0 |
| 2014-01-03 08:30:00 | AAPL | Stock | 19.7911 | 19.7971 | 19.7911 | 19.7971 | 44800.0 |
| 2014-01-03 08:32:00 | AAPL | Stock | 19.8036 | 19.8036 | 19.7964 | 19.7964 | 33600.0 |
| 2014-01-03 08:34:00 | AAPL | Stock | 19.7929 | 19.7929 | 19.7914 | 19.7914 | 16800.0 |
| 2014-01-03 08:35:00 | AAPL | Stock | 19.7914 | 19.7914 | 19.7911 | 19.7911 | 12740.0 |
| 2014-01-03 08:36:00 | AAPL | Stock | 19.7943 | 19.7943 | 19.7943 | 19.7943 | 2800.0 |
> showing 50 of 1,016,043 rows — these rows as CSV