PREVIEW / stock_1min / 2013-01-15
file: by_date/stock_1min/2013/2013-01-15.parquet size: 12.6 MB rows: 931,740 symbols: 2,795
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-01-15 04:08:00 | AAPL | Stock | 17.8575 | 17.8575 | 17.8575 | 17.8575 | 11200.0 |
| 2013-01-15 04:51:00 | AAPL | Stock | 17.8575 | 17.8575 | 17.8575 | 17.8575 | 2800.0 |
| 2013-01-15 05:04:00 | AAPL | Stock | 17.8929 | 17.8929 | 17.8929 | 17.8929 | 2800.0 |
| 2013-01-15 05:35:00 | AAPL | Stock | 17.8814 | 17.8814 | 17.8814 | 17.8814 | 2800.0 |
| 2013-01-15 05:37:00 | AAPL | Stock | 17.875 | 17.875 | 17.875 | 17.875 | 2800.0 |
| 2013-01-15 06:04:00 | AAPL | Stock | 17.8557 | 17.8557 | 17.8557 | 17.8557 | 2800.0 |
| 2013-01-15 06:05:00 | AAPL | Stock | 17.8554 | 17.8554 | 17.8554 | 17.8554 | 2800.0 |
| 2013-01-15 06:06:00 | AAPL | Stock | 17.8554 | 17.8554 | 17.8554 | 17.8554 | 2800.0 |
| 2013-01-15 06:08:00 | AAPL | Stock | 17.875 | 17.875 | 17.875 | 17.875 | 2800.0 |
| 2013-01-15 06:25:00 | AAPL | Stock | 17.8714 | 17.8736 | 17.8714 | 17.8736 | 5600.0 |
| 2013-01-15 06:27:00 | AAPL | Stock | 17.8571 | 17.8571 | 17.8571 | 17.8571 | 2800.0 |
| 2013-01-15 06:38:00 | AAPL | Stock | 17.8571 | 17.8571 | 17.8571 | 17.8571 | 2800.0 |
| 2013-01-15 06:46:00 | AAPL | Stock | 17.8607 | 17.8607 | 17.8607 | 17.8607 | 14000.0 |
| 2013-01-15 06:47:00 | AAPL | Stock | 17.8607 | 17.8607 | 17.8607 | 17.8607 | 10500.0 |
| 2013-01-15 06:52:00 | AAPL | Stock | 17.8607 | 17.8607 | 17.8607 | 17.8607 | 2800.0 |
| 2013-01-15 06:53:00 | AAPL | Stock | 17.8607 | 17.8607 | 17.8607 | 17.8607 | 2800.0 |
| 2013-01-15 06:55:00 | AAPL | Stock | 17.8746 | 17.8746 | 17.8746 | 17.8746 | 2800.0 |
| 2013-01-15 07:00:00 | AAPL | Stock | 17.8754 | 17.8793 | 17.8754 | 17.8793 | 8400.0 |
| 2013-01-15 07:01:00 | AAPL | Stock | 17.8929 | 17.8929 | 17.8929 | 17.8929 | 5320.0 |
| 2013-01-15 07:02:00 | AAPL | Stock | 17.8929 | 17.9007 | 17.8929 | 17.9 | 11200.0 |
| 2013-01-15 07:03:00 | AAPL | Stock | 17.9029 | 17.9121 | 17.9029 | 17.9121 | 14000.0 |
| 2013-01-15 07:04:00 | AAPL | Stock | 17.9039 | 17.9039 | 17.8929 | 17.8929 | 11200.0 |
| 2013-01-15 07:05:00 | AAPL | Stock | 17.8839 | 17.8843 | 17.8839 | 17.8839 | 37660.0 |
| 2013-01-15 07:06:00 | AAPL | Stock | 17.8839 | 17.8857 | 17.8839 | 17.8857 | 14000.0 |
| 2013-01-15 07:07:00 | AAPL | Stock | 17.875 | 17.875 | 17.8696 | 17.875 | 46340.0 |
| 2013-01-15 07:08:00 | AAPL | Stock | 17.875 | 17.875 | 17.875 | 17.875 | 2800.0 |
| 2013-01-15 07:09:00 | AAPL | Stock | 17.8696 | 17.8696 | 17.8668 | 17.8668 | 5600.0 |
| 2013-01-15 07:10:00 | AAPL | Stock | 17.875 | 17.875 | 17.875 | 17.875 | 11200.0 |
| 2013-01-15 07:11:00 | AAPL | Stock | 17.8821 | 17.8821 | 17.8821 | 17.8821 | 2800.0 |
| 2013-01-15 07:12:00 | AAPL | Stock | 17.8882 | 17.8911 | 17.8882 | 17.8911 | 19600.0 |
| 2013-01-15 07:13:00 | AAPL | Stock | 17.8911 | 17.9021 | 17.8904 | 17.9 | 56224.0 |
| 2013-01-15 07:14:00 | AAPL | Stock | 17.9 | 17.9071 | 17.9 | 17.9071 | 8400.0 |
| 2013-01-15 07:16:00 | AAPL | Stock | 17.9036 | 17.905 | 17.9036 | 17.905 | 5600.0 |
| 2013-01-15 07:17:00 | AAPL | Stock | 17.9107 | 17.9107 | 17.9107 | 17.9107 | 11200.0 |
| 2013-01-15 07:18:00 | AAPL | Stock | 17.9089 | 17.9089 | 17.9021 | 17.9021 | 5600.0 |
| 2013-01-15 07:19:00 | AAPL | Stock | 17.8964 | 17.8964 | 17.8929 | 17.8929 | 19180.0 |
| 2013-01-15 07:24:00 | AAPL | Stock | 17.91 | 17.9107 | 17.91 | 17.9107 | 27440.0 |
| 2013-01-15 07:25:00 | AAPL | Stock | 17.9111 | 17.9111 | 17.9111 | 17.9111 | 2800.0 |
| 2013-01-15 07:29:00 | AAPL | Stock | 17.9143 | 17.9143 | 17.9054 | 17.9054 | 43400.0 |
| 2013-01-15 07:32:00 | AAPL | Stock | 17.9107 | 17.9143 | 17.9107 | 17.9143 | 15400.0 |
| 2013-01-15 07:33:00 | AAPL | Stock | 17.9089 | 17.9089 | 17.9089 | 17.9089 | 2800.0 |
| 2013-01-15 07:34:00 | AAPL | Stock | 17.9136 | 17.9264 | 17.9136 | 17.9264 | 14308.0 |
| 2013-01-15 07:35:00 | AAPL | Stock | 17.9282 | 17.9464 | 17.9282 | 17.9289 | 50456.0 |
| 2013-01-15 07:36:00 | AAPL | Stock | 17.9482 | 17.9536 | 17.9482 | 17.9518 | 37800.0 |
| 2013-01-15 07:37:00 | AAPL | Stock | 17.9464 | 17.9464 | 17.9357 | 17.9357 | 19600.0 |
| 2013-01-15 07:39:00 | AAPL | Stock | 17.9361 | 17.9361 | 17.9336 | 17.9336 | 8680.0 |
| 2013-01-15 07:40:00 | AAPL | Stock | 17.9329 | 17.9357 | 17.9182 | 17.9268 | 45276.0 |
| 2013-01-15 07:41:00 | AAPL | Stock | 17.9214 | 17.9304 | 17.9214 | 17.9254 | 39900.0 |
| 2013-01-15 07:42:00 | AAPL | Stock | 17.9129 | 17.9246 | 17.9118 | 17.9246 | 25200.0 |
| 2013-01-15 07:43:00 | AAPL | Stock | 17.9232 | 17.925 | 17.9107 | 17.9107 | 92092.0 |
> showing 50 of 931,740 rows — these rows as CSV