PREVIEW / stock_1min / 2013-06-24
file: by_date/stock_1min/2013/2013-06-24.parquet size: 15.6 MB rows: 1,124,800 symbols: 2,849
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 |
|---|---|---|---|---|---|---|---|
| 2013-06-24 04:00:00 | AAPL | Stock | 14.7143 | 14.7304 | 14.7143 | 14.7304 | 11200.0 |
| 2013-06-24 04:11:00 | AAPL | Stock | 14.6786 | 14.6786 | 14.6786 | 14.6786 | 2800.0 |
| 2013-06-24 04:17:00 | AAPL | Stock | 14.6825 | 14.6825 | 14.6825 | 14.6825 | 2800.0 |
| 2013-06-24 04:37:00 | AAPL | Stock | 14.6589 | 14.6589 | 14.6589 | 14.6589 | 2800.0 |
| 2013-06-24 04:52:00 | AAPL | Stock | 14.6536 | 14.6589 | 14.6536 | 14.6589 | 14112.0 |
| 2013-06-24 05:07:00 | AAPL | Stock | 14.6432 | 14.6432 | 14.6429 | 14.6429 | 21336.0 |
| 2013-06-24 06:22:00 | AAPL | Stock | 14.6429 | 14.6429 | 14.6429 | 14.6429 | 5600.0 |
| 2013-06-24 06:34:00 | AAPL | Stock | 14.6321 | 14.6321 | 14.6321 | 14.6321 | 2800.0 |
| 2013-06-24 06:35:00 | AAPL | Stock | 14.6064 | 14.6064 | 14.5911 | 14.5911 | 5600.0 |
| 2013-06-24 06:36:00 | AAPL | Stock | 14.5896 | 14.5896 | 14.5896 | 14.5896 | 15400.0 |
| 2013-06-24 06:37:00 | AAPL | Stock | 14.625 | 14.625 | 14.625 | 14.625 | 7168.0 |
| 2013-06-24 06:38:00 | AAPL | Stock | 14.595 | 14.595 | 14.595 | 14.595 | 2800.0 |
| 2013-06-24 06:42:00 | AAPL | Stock | 14.6071 | 14.6071 | 14.6071 | 14.6071 | 14000.0 |
| 2013-06-24 06:45:00 | AAPL | Stock | 14.5954 | 14.5954 | 14.5954 | 14.5954 | 2800.0 |
| 2013-06-24 06:59:00 | AAPL | Stock | 14.6 | 14.6 | 14.6 | 14.6 | 2800.0 |
| 2013-06-24 07:00:00 | AAPL | Stock | 14.6107 | 14.6111 | 14.6107 | 14.6111 | 8400.0 |
| 2013-06-24 07:04:00 | AAPL | Stock | 14.6 | 14.6 | 14.6 | 14.6 | 7896.0 |
| 2013-06-24 07:05:00 | AAPL | Stock | 14.6068 | 14.6111 | 14.6068 | 14.6111 | 35784.0 |
| 2013-06-24 07:08:00 | AAPL | Stock | 14.6196 | 14.6196 | 14.6171 | 14.6196 | 14000.0 |
| 2013-06-24 07:14:00 | AAPL | Stock | 14.6196 | 14.6196 | 14.6196 | 14.6196 | 2800.0 |
| 2013-06-24 07:15:00 | AAPL | Stock | 14.6196 | 14.6196 | 14.6196 | 14.6196 | 5600.0 |
| 2013-06-24 07:22:00 | AAPL | Stock | 14.6125 | 14.6125 | 14.5964 | 14.5964 | 30800.0 |
| 2013-06-24 07:25:00 | AAPL | Stock | 14.6014 | 14.6018 | 14.6014 | 14.6018 | 19600.0 |
| 2013-06-24 07:26:00 | AAPL | Stock | 14.6018 | 14.6018 | 14.5968 | 14.5968 | 16604.0 |
| 2013-06-24 07:30:00 | AAPL | Stock | 14.5957 | 14.5957 | 14.5875 | 14.5879 | 29120.0 |
| 2013-06-24 07:31:00 | AAPL | Stock | 14.5771 | 14.5771 | 14.575 | 14.5757 | 27720.0 |
| 2013-06-24 07:32:00 | AAPL | Stock | 14.5693 | 14.5711 | 14.5693 | 14.5711 | 8400.0 |
| 2013-06-24 07:33:00 | AAPL | Stock | 14.5693 | 14.5714 | 14.5693 | 14.5714 | 23520.0 |
| 2013-06-24 07:35:00 | AAPL | Stock | 14.5696 | 14.5714 | 14.5271 | 14.5271 | 70168.0 |
| 2013-06-24 07:36:00 | AAPL | Stock | 14.5536 | 14.5625 | 14.5511 | 14.5532 | 28084.0 |
| 2013-06-24 07:37:00 | AAPL | Stock | 14.5514 | 14.5536 | 14.5411 | 14.5429 | 39900.0 |
| 2013-06-24 07:38:00 | AAPL | Stock | 14.5539 | 14.5539 | 14.5536 | 14.5536 | 11200.0 |
| 2013-06-24 07:40:00 | AAPL | Stock | 14.5693 | 14.5714 | 14.5371 | 14.5371 | 46060.0 |
| 2013-06-24 07:42:00 | AAPL | Stock | 14.5536 | 14.5536 | 14.5536 | 14.5536 | 24500.0 |
| 2013-06-24 07:43:00 | AAPL | Stock | 14.5543 | 14.5543 | 14.5543 | 14.5543 | 2800.0 |
| 2013-06-24 07:46:00 | AAPL | Stock | 14.5689 | 14.5714 | 14.5689 | 14.5714 | 11200.0 |
| 2013-06-24 07:47:00 | AAPL | Stock | 14.5561 | 14.5561 | 14.5561 | 14.5561 | 2800.0 |
| 2013-06-24 07:48:00 | AAPL | Stock | 14.5607 | 14.5607 | 14.5607 | 14.5607 | 5600.0 |
| 2013-06-24 07:51:00 | AAPL | Stock | 14.5661 | 14.5714 | 14.5661 | 14.5714 | 8400.0 |
| 2013-06-24 07:53:00 | AAPL | Stock | 14.5754 | 14.5754 | 14.5754 | 14.5754 | 8400.0 |
| 2013-06-24 07:55:00 | AAPL | Stock | 14.5786 | 14.5786 | 14.5786 | 14.5786 | 5600.0 |
| 2013-06-24 07:57:00 | AAPL | Stock | 14.5786 | 14.5786 | 14.5721 | 14.5721 | 5600.0 |
| 2013-06-24 07:58:00 | AAPL | Stock | 14.5714 | 14.5714 | 14.5689 | 14.5689 | 16800.0 |
| 2013-06-24 08:00:00 | AAPL | Stock | 14.5714 | 14.6075 | 14.5357 | 14.5771 | 117964.0 |
| 2013-06-24 08:01:00 | AAPL | Stock | 14.5771 | 14.5804 | 14.575 | 14.5754 | 60480.0 |
| 2013-06-24 08:02:00 | AAPL | Stock | 14.5754 | 14.5796 | 14.5714 | 14.5796 | 113400.0 |
| 2013-06-24 08:03:00 | AAPL | Stock | 14.75 | 14.75 | 14.5711 | 14.5714 | 30800.0 |
| 2013-06-24 08:04:00 | AAPL | Stock | 14.5714 | 14.5821 | 14.5714 | 14.5714 | 86100.0 |
| 2013-06-24 08:05:00 | AAPL | Stock | 14.5682 | 14.5714 | 14.5682 | 14.5714 | 21980.0 |
| 2013-06-24 08:06:00 | AAPL | Stock | 14.5714 | 14.5714 | 14.5607 | 14.5643 | 33712.0 |
> showing 50 of 1,124,800 rows — these rows as CSV