PREVIEW / stock_1min / 2012-09-24
file: by_date/stock_1min/2012/2012-09-24.parquet size: 12.9 MB rows: 956,105 symbols: 2,808
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-09-24 04:00:00 | AAPL | Stock | 24.9964 | 24.9964 | 24.9375 | 24.9375 | 21112.0 |
| 2012-09-24 04:02:00 | AAPL | Stock | 24.9375 | 24.9375 | 24.9375 | 24.9375 | 2800.0 |
| 2012-09-24 04:20:00 | AAPL | Stock | 24.9561 | 24.9561 | 24.9561 | 24.9561 | 8400.0 |
| 2012-09-24 04:22:00 | AAPL | Stock | 24.9375 | 24.9375 | 24.9375 | 24.9375 | 2800.0 |
| 2012-09-24 04:23:00 | AAPL | Stock | 24.9375 | 24.9375 | 24.9375 | 24.9375 | 8400.0 |
| 2012-09-24 04:25:00 | AAPL | Stock | 24.9375 | 24.9375 | 24.9375 | 24.9375 | 2800.0 |
| 2012-09-24 04:27:00 | AAPL | Stock | 24.9375 | 24.9375 | 24.9375 | 24.9375 | 2800.0 |
| 2012-09-24 04:32:00 | AAPL | Stock | 24.9464 | 24.9464 | 24.9464 | 24.9464 | 2800.0 |
| 2012-09-24 04:41:00 | AAPL | Stock | 24.9304 | 24.9304 | 24.9304 | 24.9304 | 2800.0 |
| 2012-09-24 04:43:00 | AAPL | Stock | 24.9286 | 24.9286 | 24.9286 | 24.9286 | 11200.0 |
| 2012-09-24 05:03:00 | AAPL | Stock | 24.9357 | 24.9357 | 24.9357 | 24.9357 | 2800.0 |
| 2012-09-24 05:05:00 | AAPL | Stock | 24.9446 | 24.9446 | 24.9446 | 24.9446 | 2800.0 |
| 2012-09-24 05:07:00 | AAPL | Stock | 24.9093 | 24.9093 | 24.8929 | 24.8929 | 13636.0 |
| 2012-09-24 05:20:00 | AAPL | Stock | 24.8893 | 24.8893 | 24.8893 | 24.8893 | 2800.0 |
| 2012-09-24 05:54:00 | AAPL | Stock | 24.8768 | 24.8768 | 24.8768 | 24.8768 | 2800.0 |
| 2012-09-24 05:57:00 | AAPL | Stock | 24.8929 | 24.8929 | 24.8929 | 24.8929 | 3976.0 |
| 2012-09-24 06:50:00 | AAPL | Stock | 24.8921 | 24.8921 | 24.8921 | 24.8921 | 2800.0 |
| 2012-09-24 06:57:00 | AAPL | Stock | 24.8929 | 24.8929 | 24.8929 | 24.8929 | 5600.0 |
| 2012-09-24 06:58:00 | AAPL | Stock | 24.8929 | 24.8929 | 24.8929 | 24.8929 | 5600.0 |
| 2012-09-24 06:59:00 | AAPL | Stock | 24.875 | 24.875 | 24.875 | 24.875 | 5600.0 |
| 2012-09-24 07:00:00 | AAPL | Stock | 24.8446 | 24.875 | 24.8446 | 24.8571 | 8400.0 |
| 2012-09-24 07:02:00 | AAPL | Stock | 24.8571 | 24.8611 | 24.8218 | 24.8218 | 29680.0 |
| 2012-09-24 07:03:00 | AAPL | Stock | 24.8357 | 24.8396 | 24.8357 | 24.8393 | 30800.0 |
| 2012-09-24 07:04:00 | AAPL | Stock | 24.8325 | 24.8393 | 24.8325 | 24.8393 | 7000.0 |
| 2012-09-24 07:06:00 | AAPL | Stock | 24.8393 | 24.8393 | 24.8393 | 24.8393 | 2800.0 |
| 2012-09-24 07:07:00 | AAPL | Stock | 24.8254 | 24.8393 | 24.8214 | 24.8214 | 63168.0 |
| 2012-09-24 07:08:00 | AAPL | Stock | 24.8214 | 24.8393 | 24.8114 | 24.8114 | 15820.0 |
| 2012-09-24 07:09:00 | AAPL | Stock | 24.8386 | 24.8393 | 24.8386 | 24.8393 | 11228.0 |
| 2012-09-24 07:10:00 | AAPL | Stock | 24.8393 | 24.8393 | 24.8321 | 24.8321 | 13300.0 |
| 2012-09-24 07:11:00 | AAPL | Stock | 24.8286 | 24.8286 | 24.8214 | 24.8214 | 23884.0 |
| 2012-09-24 07:12:00 | AAPL | Stock | 24.8214 | 24.8214 | 24.8214 | 24.8214 | 4200.0 |
| 2012-09-24 07:13:00 | AAPL | Stock | 24.8264 | 24.8357 | 24.8264 | 24.8357 | 20020.0 |
| 2012-09-24 07:14:00 | AAPL | Stock | 24.8321 | 24.8321 | 24.8321 | 24.8321 | 3976.0 |
| 2012-09-24 07:16:00 | AAPL | Stock | 24.8375 | 24.8389 | 24.8371 | 24.8389 | 19600.0 |
| 2012-09-24 07:17:00 | AAPL | Stock | 24.8354 | 24.8375 | 24.8354 | 24.8375 | 12768.0 |
| 2012-09-24 07:18:00 | AAPL | Stock | 24.8339 | 24.8339 | 24.8339 | 24.8339 | 3500.0 |
| 2012-09-24 07:19:00 | AAPL | Stock | 24.8371 | 24.8371 | 24.8371 | 24.8371 | 13972.0 |
| 2012-09-24 07:20:00 | AAPL | Stock | 24.8393 | 24.8393 | 24.8393 | 24.8393 | 24024.0 |
| 2012-09-24 07:21:00 | AAPL | Stock | 24.8393 | 24.8393 | 24.8393 | 24.8393 | 5600.0 |
| 2012-09-24 07:22:00 | AAPL | Stock | 24.8304 | 24.8304 | 24.8304 | 24.8304 | 2800.0 |
| 2012-09-24 07:24:00 | AAPL | Stock | 24.8214 | 24.8214 | 24.8214 | 24.8214 | 16968.0 |
| 2012-09-24 07:25:00 | AAPL | Stock | 24.8214 | 24.8214 | 24.8196 | 24.8214 | 13412.0 |
| 2012-09-24 07:26:00 | AAPL | Stock | 24.8214 | 24.8304 | 24.8214 | 24.8304 | 81956.0 |
| 2012-09-24 07:28:00 | AAPL | Stock | 24.8125 | 24.8125 | 24.8125 | 24.8125 | 5600.0 |
| 2012-09-24 07:30:00 | AAPL | Stock | 24.8211 | 24.8211 | 24.8211 | 24.8211 | 8400.0 |
| 2012-09-24 07:31:00 | AAPL | Stock | 24.8232 | 24.8232 | 24.8211 | 24.8211 | 28000.0 |
| 2012-09-24 07:32:00 | AAPL | Stock | 24.8282 | 24.8304 | 24.8179 | 24.8214 | 67452.0 |
| 2012-09-24 07:33:00 | AAPL | Stock | 24.8214 | 24.8304 | 24.8214 | 24.8214 | 22400.0 |
| 2012-09-24 07:34:00 | AAPL | Stock | 24.8214 | 24.8221 | 24.8214 | 24.8214 | 19600.0 |
| 2012-09-24 07:35:00 | AAPL | Stock | 24.8214 | 24.8214 | 24.8214 | 24.8214 | 14000.0 |
> showing 50 of 956,105 rows — these rows as CSV