PREVIEW / stock_1min / 2012-07-30
file: by_date/stock_1min/2012/2012-07-30.parquet size: 12.1 MB rows: 902,868 symbols: 2,830
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 |
|---|---|---|---|---|---|---|---|
| 2012-07-30 04:24:00 | AAPL | Stock | 20.8964 | 20.8964 | 20.8964 | 20.8964 | 2800.0 |
| 2012-07-30 04:39:00 | AAPL | Stock | 20.8661 | 20.8661 | 20.8661 | 20.8661 | 2800.0 |
| 2012-07-30 04:56:00 | AAPL | Stock | 20.8679 | 20.8679 | 20.8679 | 20.8679 | 5600.0 |
| 2012-07-30 05:26:00 | AAPL | Stock | 20.8682 | 20.8682 | 20.8679 | 20.8679 | 14000.0 |
| 2012-07-30 05:28:00 | AAPL | Stock | 20.8682 | 20.8682 | 20.8682 | 20.8682 | 5600.0 |
| 2012-07-30 05:42:00 | AAPL | Stock | 20.8929 | 20.8929 | 20.8929 | 20.8929 | 4732.0 |
| 2012-07-30 05:55:00 | AAPL | Stock | 20.9171 | 20.9171 | 20.9171 | 20.9171 | 2800.0 |
| 2012-07-30 06:02:00 | AAPL | Stock | 20.9104 | 20.9104 | 20.9104 | 20.9104 | 2800.0 |
| 2012-07-30 06:22:00 | AAPL | Stock | 20.8929 | 20.8929 | 20.8929 | 20.8929 | 14000.0 |
| 2012-07-30 06:28:00 | AAPL | Stock | 20.8696 | 20.8696 | 20.8696 | 20.8696 | 3108.0 |
| 2012-07-30 06:39:00 | AAPL | Stock | 20.9107 | 20.9107 | 20.9107 | 20.9107 | 2800.0 |
| 2012-07-30 06:48:00 | AAPL | Stock | 20.8968 | 20.8968 | 20.8968 | 20.8968 | 5320.0 |
| 2012-07-30 06:57:00 | AAPL | Stock | 20.8964 | 20.8964 | 20.8964 | 20.8964 | 5208.0 |
| 2012-07-30 06:59:00 | AAPL | Stock | 20.8964 | 20.8964 | 20.8964 | 20.8964 | 5600.0 |
| 2012-07-30 07:00:00 | AAPL | Stock | 20.8964 | 20.8964 | 20.8964 | 20.8964 | 3192.0 |
| 2012-07-30 07:01:00 | AAPL | Stock | 20.8964 | 20.9107 | 20.8964 | 20.9107 | 44408.0 |
| 2012-07-30 07:02:00 | AAPL | Stock | 20.9107 | 20.9107 | 20.9107 | 20.9107 | 8400.0 |
| 2012-07-30 07:03:00 | AAPL | Stock | 20.9007 | 20.9007 | 20.9007 | 20.9007 | 2800.0 |
| 2012-07-30 07:04:00 | AAPL | Stock | 20.8929 | 20.8929 | 20.8929 | 20.8929 | 6720.0 |
| 2012-07-30 07:06:00 | AAPL | Stock | 20.8929 | 20.8929 | 20.8929 | 20.8929 | 2800.0 |
| 2012-07-30 07:10:00 | AAPL | Stock | 20.8929 | 20.8929 | 20.8929 | 20.8929 | 14000.0 |
| 2012-07-30 07:11:00 | AAPL | Stock | 20.9007 | 20.9007 | 20.9007 | 20.9007 | 20048.0 |
| 2012-07-30 07:12:00 | AAPL | Stock | 20.8932 | 20.8932 | 20.8932 | 20.8932 | 5880.0 |
| 2012-07-30 07:13:00 | AAPL | Stock | 20.9125 | 20.9125 | 20.9125 | 20.9125 | 5040.0 |
| 2012-07-30 07:14:00 | AAPL | Stock | 20.9125 | 20.9125 | 20.8929 | 20.8929 | 14000.0 |
| 2012-07-30 07:15:00 | AAPL | Stock | 20.8864 | 20.8864 | 20.8864 | 20.8864 | 2800.0 |
| 2012-07-30 07:16:00 | AAPL | Stock | 20.8921 | 20.8929 | 20.8921 | 20.8929 | 16464.0 |
| 2012-07-30 07:17:00 | AAPL | Stock | 20.8929 | 20.9086 | 20.8929 | 20.9086 | 5600.0 |
| 2012-07-30 07:18:00 | AAPL | Stock | 20.8936 | 20.8936 | 20.8932 | 20.8932 | 5600.0 |
| 2012-07-30 07:19:00 | AAPL | Stock | 20.8929 | 20.8929 | 20.8929 | 20.8929 | 8736.0 |
| 2012-07-30 07:21:00 | AAPL | Stock | 20.8789 | 20.8857 | 20.87 | 20.8857 | 10948.0 |
| 2012-07-30 07:26:00 | AAPL | Stock | 20.9014 | 20.9014 | 20.9014 | 20.9014 | 3052.0 |
| 2012-07-30 07:29:00 | AAPL | Stock | 20.9079 | 20.9086 | 20.9079 | 20.9086 | 8400.0 |
| 2012-07-30 07:30:00 | AAPL | Stock | 20.9071 | 20.9071 | 20.9071 | 20.9071 | 2800.0 |
| 2012-07-30 07:43:00 | AAPL | Stock | 20.8964 | 20.8964 | 20.8964 | 20.8964 | 2800.0 |
| 2012-07-30 07:44:00 | AAPL | Stock | 20.8929 | 20.8929 | 20.8857 | 20.8857 | 16800.0 |
| 2012-07-30 07:45:00 | AAPL | Stock | 20.8857 | 20.8857 | 20.8857 | 20.8857 | 8400.0 |
| 2012-07-30 07:46:00 | AAPL | Stock | 20.8857 | 20.8982 | 20.8857 | 20.8982 | 19600.0 |
| 2012-07-30 07:49:00 | AAPL | Stock | 20.9025 | 20.9029 | 20.9025 | 20.9029 | 23380.0 |
| 2012-07-30 07:50:00 | AAPL | Stock | 20.8946 | 20.8946 | 20.8929 | 20.8929 | 5600.0 |
| 2012-07-30 07:51:00 | AAPL | Stock | 20.8875 | 20.8875 | 20.8861 | 20.8861 | 22400.0 |
| 2012-07-30 07:58:00 | AAPL | Stock | 20.8839 | 20.8839 | 20.8839 | 20.8839 | 2800.0 |
| 2012-07-30 07:59:00 | AAPL | Stock | 20.8711 | 20.8839 | 20.8711 | 20.8839 | 14000.0 |
| 2012-07-30 08:00:00 | AAPL | Stock | 20.8832 | 20.9 | 20.875 | 20.9 | 249228.0 |
| 2012-07-30 08:01:00 | AAPL | Stock | 20.9025 | 20.9029 | 20.9025 | 20.9029 | 13580.0 |
| 2012-07-30 08:02:00 | AAPL | Stock | 20.9025 | 20.925 | 20.9021 | 20.9232 | 102872.0 |
| 2012-07-30 08:03:00 | AAPL | Stock | 20.9243 | 20.9286 | 20.9243 | 20.9286 | 64232.0 |
| 2012-07-30 08:04:00 | AAPL | Stock | 20.9346 | 20.9679 | 20.9343 | 20.9679 | 124096.0 |
| 2012-07-30 08:05:00 | AAPL | Stock | 20.965 | 21.0 | 20.965 | 20.9821 | 493192.0 |
| 2012-07-30 08:06:00 | AAPL | Stock | 20.9821 | 20.9821 | 20.9607 | 20.9818 | 129976.0 |
> showing 50 of 902,868 rows — these rows as CSV