PREVIEW / stock_1min / 2011-07-28
file: by_date/stock_1min/2011/2011-07-28.parquet size: 13.4 MB rows: 994,308 symbols: 2,848
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-07-28 04:00:00 | AAPL | Stock | 13.9682 | 13.9682 | 13.9682 | 13.9682 | 7000.0 |
| 2011-07-28 04:45:00 | AAPL | Stock | 14.0518 | 14.0518 | 14.0518 | 14.0518 | 2800.0 |
| 2011-07-28 04:50:00 | AAPL | Stock | 14.0539 | 14.0539 | 14.0539 | 14.0539 | 2800.0 |
| 2011-07-28 04:51:00 | AAPL | Stock | 14.0543 | 14.0543 | 14.0543 | 14.0543 | 2800.0 |
| 2011-07-28 05:04:00 | AAPL | Stock | 14.025 | 14.025 | 14.025 | 14.025 | 2800.0 |
| 2011-07-28 05:09:00 | AAPL | Stock | 14.0354 | 14.0354 | 14.0354 | 14.0354 | 2800.0 |
| 2011-07-28 05:16:00 | AAPL | Stock | 14.0179 | 14.0179 | 14.0179 | 14.0179 | 2800.0 |
| 2011-07-28 05:24:00 | AAPL | Stock | 14.0175 | 14.0175 | 14.0086 | 14.0086 | 14000.0 |
| 2011-07-28 05:26:00 | AAPL | Stock | 14.0146 | 14.0146 | 14.0146 | 14.0146 | 2800.0 |
| 2011-07-28 05:45:00 | AAPL | Stock | 13.9871 | 13.9871 | 13.9871 | 13.9871 | 5600.0 |
| 2011-07-28 05:46:00 | AAPL | Stock | 13.9839 | 13.9839 | 13.9839 | 13.9839 | 5600.0 |
| 2011-07-28 05:52:00 | AAPL | Stock | 13.9871 | 13.9871 | 13.9871 | 13.9871 | 2800.0 |
| 2011-07-28 05:53:00 | AAPL | Stock | 13.9871 | 13.9871 | 13.9871 | 13.9871 | 2800.0 |
| 2011-07-28 05:54:00 | AAPL | Stock | 13.9839 | 13.9839 | 13.9839 | 13.9839 | 2800.0 |
| 2011-07-28 05:55:00 | AAPL | Stock | 13.9925 | 13.9925 | 13.9871 | 13.9871 | 5600.0 |
| 2011-07-28 05:59:00 | AAPL | Stock | 13.9875 | 13.9875 | 13.9839 | 13.9839 | 5600.0 |
| 2011-07-28 06:02:00 | AAPL | Stock | 13.99 | 13.99 | 13.99 | 13.99 | 5600.0 |
| 2011-07-28 06:04:00 | AAPL | Stock | 13.99 | 13.99 | 13.99 | 13.99 | 2800.0 |
| 2011-07-28 06:10:00 | AAPL | Stock | 13.99 | 13.99 | 13.99 | 13.99 | 2800.0 |
| 2011-07-28 06:11:00 | AAPL | Stock | 13.99 | 13.99 | 13.99 | 13.99 | 5600.0 |
| 2011-07-28 06:13:00 | AAPL | Stock | 13.9904 | 13.9904 | 13.99 | 13.99 | 5600.0 |
| 2011-07-28 06:14:00 | AAPL | Stock | 13.99 | 13.99 | 13.9721 | 13.9721 | 28000.0 |
| 2011-07-28 06:18:00 | AAPL | Stock | 13.9618 | 13.9618 | 13.95 | 13.95 | 15400.0 |
| 2011-07-28 06:19:00 | AAPL | Stock | 13.95 | 13.9639 | 13.95 | 13.9639 | 20300.0 |
| 2011-07-28 06:20:00 | AAPL | Stock | 13.9639 | 13.9639 | 13.9639 | 13.9639 | 19600.0 |
| 2011-07-28 06:26:00 | AAPL | Stock | 13.95 | 13.95 | 13.95 | 13.95 | 2800.0 |
| 2011-07-28 06:27:00 | AAPL | Stock | 13.9643 | 13.9643 | 13.9643 | 13.9643 | 11200.0 |
| 2011-07-28 06:56:00 | AAPL | Stock | 13.9946 | 13.9946 | 13.9946 | 13.9946 | 2800.0 |
| 2011-07-28 07:00:00 | AAPL | Stock | 14.0 | 14.0 | 14.0 | 14.0 | 2800.0 |
| 2011-07-28 07:01:00 | AAPL | Stock | 14.0 | 14.0 | 13.9821 | 13.9821 | 34300.0 |
| 2011-07-28 07:03:00 | AAPL | Stock | 14.0 | 14.0 | 14.0 | 14.0 | 4256.0 |
| 2011-07-28 07:04:00 | AAPL | Stock | 13.9786 | 14.0154 | 13.9782 | 14.0089 | 31416.0 |
| 2011-07-28 07:05:00 | AAPL | Stock | 14.0089 | 14.0339 | 14.0089 | 14.0339 | 40600.0 |
| 2011-07-28 07:06:00 | AAPL | Stock | 14.0354 | 14.0357 | 14.0354 | 14.0357 | 35028.0 |
| 2011-07-28 07:07:00 | AAPL | Stock | 14.0357 | 14.0357 | 14.0357 | 14.0357 | 8400.0 |
| 2011-07-28 07:08:00 | AAPL | Stock | 14.0321 | 14.0321 | 14.0321 | 14.0321 | 2800.0 |
| 2011-07-28 07:09:00 | AAPL | Stock | 14.0271 | 14.0271 | 14.0271 | 14.0271 | 2800.0 |
| 2011-07-28 07:10:00 | AAPL | Stock | 14.0268 | 14.0321 | 14.0268 | 14.0321 | 11200.0 |
| 2011-07-28 07:11:00 | AAPL | Stock | 14.0354 | 14.0357 | 14.0354 | 14.0357 | 7000.0 |
| 2011-07-28 07:12:00 | AAPL | Stock | 14.0357 | 14.0357 | 14.0357 | 14.0357 | 2800.0 |
| 2011-07-28 07:14:00 | AAPL | Stock | 14.0396 | 14.0396 | 14.0396 | 14.0396 | 2800.0 |
| 2011-07-28 07:15:00 | AAPL | Stock | 14.0396 | 14.04 | 14.0396 | 14.04 | 5600.0 |
| 2011-07-28 07:16:00 | AAPL | Stock | 14.04 | 14.04 | 14.04 | 14.04 | 2800.0 |
| 2011-07-28 07:17:00 | AAPL | Stock | 14.0225 | 14.0304 | 14.0179 | 14.0304 | 25200.0 |
| 2011-07-28 07:18:00 | AAPL | Stock | 13.9982 | 14.0279 | 13.9982 | 14.0279 | 8400.0 |
| 2011-07-28 07:19:00 | AAPL | Stock | 14.0179 | 14.0179 | 14.0179 | 14.0179 | 2800.0 |
| 2011-07-28 07:20:00 | AAPL | Stock | 14.0018 | 14.0018 | 14.0 | 14.0 | 11200.0 |
| 2011-07-28 07:23:00 | AAPL | Stock | 14.0129 | 14.0179 | 14.0129 | 14.0179 | 21280.0 |
| 2011-07-28 07:24:00 | AAPL | Stock | 14.0132 | 14.0132 | 14.0129 | 14.0129 | 8400.0 |
| 2011-07-28 07:25:00 | AAPL | Stock | 14.0304 | 14.0346 | 14.0264 | 14.0264 | 17640.0 |
> showing 50 of 994,308 rows — these rows as CSV