PREVIEW / stock_1min / 2011-12-12
file: by_date/stock_1min/2011/2011-12-12.parquet size: 12.7 MB rows: 959,782 symbols: 2,854
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-12-12 04:02:00 | AAPL | Stock | 14.0268 | 14.0268 | 14.0268 | 14.0268 | 2800.0 |
| 2011-12-12 04:20:00 | AAPL | Stock | 14.0 | 14.0 | 14.0 | 14.0 | 2800.0 |
| 2011-12-12 04:21:00 | AAPL | Stock | 14.0 | 14.0 | 14.0 | 14.0 | 28000.0 |
| 2011-12-12 04:33:00 | AAPL | Stock | 13.9821 | 13.9821 | 13.9821 | 13.9821 | 2800.0 |
| 2011-12-12 04:34:00 | AAPL | Stock | 13.9764 | 13.9764 | 13.9764 | 13.9764 | 5600.0 |
| 2011-12-12 04:38:00 | AAPL | Stock | 13.98 | 13.98 | 13.98 | 13.98 | 5600.0 |
| 2011-12-12 04:46:00 | AAPL | Stock | 13.9643 | 13.9643 | 13.9643 | 13.9643 | 2800.0 |
| 2011-12-12 04:59:00 | AAPL | Stock | 13.9646 | 13.9646 | 13.9643 | 13.9643 | 7840.0 |
| 2011-12-12 05:00:00 | AAPL | Stock | 13.9643 | 13.9643 | 13.9643 | 13.9643 | 8400.0 |
| 2011-12-12 05:01:00 | AAPL | Stock | 13.9643 | 13.9643 | 13.9643 | 13.9643 | 2800.0 |
| 2011-12-12 05:34:00 | AAPL | Stock | 13.9714 | 13.9714 | 13.9714 | 13.9714 | 5600.0 |
| 2011-12-12 05:41:00 | AAPL | Stock | 13.9714 | 13.9714 | 13.9714 | 13.9714 | 5600.0 |
| 2011-12-12 06:10:00 | AAPL | Stock | 13.9679 | 13.9679 | 13.9643 | 13.9643 | 14560.0 |
| 2011-12-12 06:11:00 | AAPL | Stock | 13.9714 | 13.9714 | 13.9714 | 13.9714 | 2800.0 |
| 2011-12-12 07:00:00 | AAPL | Stock | 13.9682 | 14.0714 | 13.9682 | 14.0714 | 25200.0 |
| 2011-12-12 07:01:00 | AAPL | Stock | 14.0179 | 14.0304 | 14.0 | 14.0 | 14000.0 |
| 2011-12-12 07:04:00 | AAPL | Stock | 14.0143 | 14.0143 | 14.0143 | 14.0143 | 5600.0 |
| 2011-12-12 07:05:00 | AAPL | Stock | 14.0211 | 14.0211 | 14.0211 | 14.0211 | 2800.0 |
| 2011-12-12 07:11:00 | AAPL | Stock | 14.0225 | 14.0225 | 14.0225 | 14.0225 | 5600.0 |
| 2011-12-12 07:12:00 | AAPL | Stock | 14.0225 | 14.0225 | 14.0179 | 14.0179 | 19600.0 |
| 2011-12-12 07:16:00 | AAPL | Stock | 14.0143 | 14.0143 | 14.0143 | 14.0143 | 2800.0 |
| 2011-12-12 07:18:00 | AAPL | Stock | 14.0071 | 14.0071 | 14.0071 | 14.0071 | 5180.0 |
| 2011-12-12 07:23:00 | AAPL | Stock | 14.0111 | 14.0111 | 14.0111 | 14.0111 | 3360.0 |
| 2011-12-12 07:24:00 | AAPL | Stock | 14.0139 | 14.0143 | 14.0139 | 14.0143 | 14000.0 |
| 2011-12-12 07:25:00 | AAPL | Stock | 14.0143 | 14.0143 | 14.0143 | 14.0143 | 8400.0 |
| 2011-12-12 07:26:00 | AAPL | Stock | 14.0075 | 14.0075 | 14.0 | 14.0 | 42420.0 |
| 2011-12-12 07:27:00 | AAPL | Stock | 14.0 | 14.0 | 14.0 | 14.0 | 64400.0 |
| 2011-12-12 07:31:00 | AAPL | Stock | 14.0 | 14.0 | 14.0 | 14.0 | 2800.0 |
| 2011-12-12 07:35:00 | AAPL | Stock | 14.0029 | 14.0029 | 13.9964 | 13.9964 | 98000.0 |
| 2011-12-12 07:36:00 | AAPL | Stock | 14.0 | 14.0 | 13.9964 | 13.9964 | 8848.0 |
| 2011-12-12 07:37:00 | AAPL | Stock | 13.9979 | 13.9979 | 13.9979 | 13.9979 | 2800.0 |
| 2011-12-12 07:38:00 | AAPL | Stock | 13.9911 | 13.9911 | 13.9911 | 13.9911 | 21000.0 |
| 2011-12-12 07:42:00 | AAPL | Stock | 13.9975 | 13.9975 | 13.9975 | 13.9975 | 2800.0 |
| 2011-12-12 07:43:00 | AAPL | Stock | 14.0004 | 14.0004 | 13.9964 | 13.9964 | 8400.0 |
| 2011-12-12 07:44:00 | AAPL | Stock | 14.0068 | 14.0107 | 14.0068 | 14.0107 | 55132.0 |
| 2011-12-12 07:50:00 | AAPL | Stock | 14.0054 | 14.0054 | 14.0054 | 14.0054 | 2800.0 |
| 2011-12-12 07:52:00 | AAPL | Stock | 14.0046 | 14.005 | 14.0 | 14.0046 | 54432.0 |
| 2011-12-12 07:53:00 | AAPL | Stock | 14.0143 | 14.0143 | 14.0089 | 14.0089 | 5600.0 |
| 2011-12-12 07:54:00 | AAPL | Stock | 14.0007 | 14.0007 | 14.0004 | 14.0004 | 8400.0 |
| 2011-12-12 07:55:00 | AAPL | Stock | 14.0004 | 14.0004 | 14.0004 | 14.0004 | 2800.0 |
| 2011-12-12 07:56:00 | AAPL | Stock | 14.0054 | 14.0054 | 14.0054 | 14.0054 | 2800.0 |
| 2011-12-12 07:58:00 | AAPL | Stock | 14.0071 | 14.0086 | 14.0071 | 14.0086 | 36848.0 |
| 2011-12-12 07:59:00 | AAPL | Stock | 14.0071 | 14.0071 | 14.0071 | 14.0071 | 8400.0 |
| 2011-12-12 08:00:00 | AAPL | Stock | 14.0071 | 14.0071 | 14.0071 | 14.0071 | 110880.0 |
| 2011-12-12 08:01:00 | AAPL | Stock | 14.0071 | 14.0089 | 14.0071 | 14.0089 | 19600.0 |
| 2011-12-12 08:02:00 | AAPL | Stock | 14.0132 | 14.0143 | 14.0132 | 14.0143 | 5600.0 |
| 2011-12-12 08:03:00 | AAPL | Stock | 14.0071 | 14.0071 | 14.0071 | 14.0071 | 12936.0 |
| 2011-12-12 08:05:00 | AAPL | Stock | 14.0018 | 14.0018 | 14.0 | 14.0007 | 14000.0 |
| 2011-12-12 08:06:00 | AAPL | Stock | 14.0 | 14.0 | 14.0 | 14.0 | 2800.0 |
| 2011-12-12 08:07:00 | AAPL | Stock | 14.0018 | 14.0036 | 14.0007 | 14.0018 | 18900.0 |
> showing 50 of 959,782 rows — these rows as CSV