PREVIEW / stock_1min / 2012-08-24
file: by_date/stock_1min/2012/2012-08-24.parquet size: 11.6 MB rows: 859,463 symbols: 2,777
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-08-24 04:00:00 | AAPL | Stock | 23.6786 | 23.6786 | 23.6786 | 23.6786 | 2800.0 |
| 2012-08-24 04:15:00 | AAPL | Stock | 23.5939 | 23.5939 | 23.5939 | 23.5939 | 8400.0 |
| 2012-08-24 06:15:00 | AAPL | Stock | 23.625 | 23.625 | 23.625 | 23.625 | 2800.0 |
| 2012-08-24 06:25:00 | AAPL | Stock | 23.6 | 23.6 | 23.6 | 23.6 | 2800.0 |
| 2012-08-24 06:27:00 | AAPL | Stock | 23.5929 | 23.6079 | 23.5929 | 23.6079 | 11200.0 |
| 2012-08-24 07:01:00 | AAPL | Stock | 23.625 | 23.625 | 23.6229 | 23.6229 | 19600.0 |
| 2012-08-24 07:02:00 | AAPL | Stock | 23.6214 | 23.6214 | 23.6089 | 23.6104 | 12600.0 |
| 2012-08-24 07:03:00 | AAPL | Stock | 23.6125 | 23.6125 | 23.6125 | 23.6125 | 2800.0 |
| 2012-08-24 07:04:00 | AAPL | Stock | 23.6071 | 23.6071 | 23.6071 | 23.6071 | 8120.0 |
| 2012-08-24 07:07:00 | AAPL | Stock | 23.595 | 23.595 | 23.5929 | 23.5929 | 8680.0 |
| 2012-08-24 07:11:00 | AAPL | Stock | 23.6011 | 23.6011 | 23.6011 | 23.6011 | 2800.0 |
| 2012-08-24 07:16:00 | AAPL | Stock | 23.6293 | 23.6357 | 23.6293 | 23.6357 | 17360.0 |
| 2012-08-24 07:19:00 | AAPL | Stock | 23.6429 | 23.6429 | 23.6429 | 23.6429 | 2800.0 |
| 2012-08-24 07:22:00 | AAPL | Stock | 23.6318 | 23.6318 | 23.6125 | 23.6125 | 14000.0 |
| 2012-08-24 07:23:00 | AAPL | Stock | 23.6032 | 23.6032 | 23.6032 | 23.6032 | 2800.0 |
| 2012-08-24 07:24:00 | AAPL | Stock | 23.5893 | 23.5893 | 23.5893 | 23.5893 | 2800.0 |
| 2012-08-24 07:25:00 | AAPL | Stock | 23.5843 | 23.5843 | 23.575 | 23.575 | 36400.0 |
| 2012-08-24 07:27:00 | AAPL | Stock | 23.5429 | 23.5429 | 23.5375 | 23.5429 | 16464.0 |
| 2012-08-24 07:28:00 | AAPL | Stock | 23.5429 | 23.5429 | 23.5429 | 23.5429 | 14000.0 |
| 2012-08-24 07:29:00 | AAPL | Stock | 23.5418 | 23.5418 | 23.5361 | 23.5361 | 8680.0 |
| 2012-08-24 07:30:00 | AAPL | Stock | 23.525 | 23.525 | 23.525 | 23.525 | 2800.0 |
| 2012-08-24 07:32:00 | AAPL | Stock | 23.525 | 23.525 | 23.525 | 23.525 | 2800.0 |
| 2012-08-24 07:33:00 | AAPL | Stock | 23.5293 | 23.5293 | 23.5293 | 23.5293 | 2800.0 |
| 2012-08-24 07:36:00 | AAPL | Stock | 23.5461 | 23.5461 | 23.5461 | 23.5461 | 8400.0 |
| 2012-08-24 07:40:00 | AAPL | Stock | 23.5454 | 23.5454 | 23.5454 | 23.5454 | 2800.0 |
| 2012-08-24 07:41:00 | AAPL | Stock | 23.5643 | 23.5668 | 23.5643 | 23.5668 | 5600.0 |
| 2012-08-24 07:42:00 | AAPL | Stock | 23.5714 | 23.5714 | 23.5714 | 23.5714 | 9828.0 |
| 2012-08-24 07:43:00 | AAPL | Stock | 23.6004 | 23.6004 | 23.6004 | 23.6004 | 2800.0 |
| 2012-08-24 07:44:00 | AAPL | Stock | 23.6025 | 23.6071 | 23.6 | 23.6071 | 42392.0 |
| 2012-08-24 07:45:00 | AAPL | Stock | 23.6068 | 23.6071 | 23.6068 | 23.6071 | 15148.0 |
| 2012-08-24 07:46:00 | AAPL | Stock | 23.6214 | 23.6214 | 23.6214 | 23.6214 | 22400.0 |
| 2012-08-24 07:48:00 | AAPL | Stock | 23.6125 | 23.6125 | 23.6125 | 23.6125 | 5600.0 |
| 2012-08-24 07:50:00 | AAPL | Stock | 23.6321 | 23.6321 | 23.6321 | 23.6321 | 10500.0 |
| 2012-08-24 07:51:00 | AAPL | Stock | 23.6375 | 23.6375 | 23.6375 | 23.6375 | 2800.0 |
| 2012-08-24 07:52:00 | AAPL | Stock | 23.6289 | 23.6289 | 23.6289 | 23.6289 | 4900.0 |
| 2012-08-24 07:53:00 | AAPL | Stock | 23.6389 | 23.6393 | 23.6389 | 23.6393 | 8400.0 |
| 2012-08-24 07:56:00 | AAPL | Stock | 23.6525 | 23.6525 | 23.6525 | 23.6525 | 8960.0 |
| 2012-08-24 07:57:00 | AAPL | Stock | 23.6429 | 23.6429 | 23.6289 | 23.6318 | 16856.0 |
| 2012-08-24 07:58:00 | AAPL | Stock | 23.6414 | 23.6414 | 23.6325 | 23.6339 | 30800.0 |
| 2012-08-24 08:00:00 | AAPL | Stock | 23.6261 | 23.6429 | 23.5357 | 23.6354 | 55972.0 |
| 2012-08-24 08:02:00 | AAPL | Stock | 23.6229 | 23.6321 | 23.6214 | 23.6321 | 25508.0 |
| 2012-08-24 08:03:00 | AAPL | Stock | 23.6225 | 23.6225 | 23.5982 | 23.5982 | 36400.0 |
| 2012-08-24 08:04:00 | AAPL | Stock | 23.5975 | 23.6 | 23.5893 | 23.6 | 30744.0 |
| 2012-08-24 08:05:00 | AAPL | Stock | 23.6061 | 23.6061 | 23.5893 | 23.5893 | 21000.0 |
| 2012-08-24 08:06:00 | AAPL | Stock | 23.5914 | 23.5914 | 23.5893 | 23.5893 | 10500.0 |
| 2012-08-24 08:07:00 | AAPL | Stock | 23.5989 | 23.5993 | 23.5836 | 23.5893 | 21000.0 |
| 2012-08-24 08:08:00 | AAPL | Stock | 23.5893 | 23.5929 | 23.5893 | 23.5929 | 10640.0 |
| 2012-08-24 08:10:00 | AAPL | Stock | 23.5964 | 23.6064 | 23.5964 | 23.6064 | 30800.0 |
| 2012-08-24 08:11:00 | AAPL | Stock | 23.6 | 23.6075 | 23.6 | 23.6 | 51464.0 |
| 2012-08-24 08:12:00 | AAPL | Stock | 23.6 | 23.6 | 23.6 | 23.6 | 13160.0 |
> showing 50 of 859,463 rows — these rows as CSV