PREVIEW / stock_1min / 2013-08-16
file: by_date/stock_1min/2013/2013-08-16.parquet size: 13.5 MB rows: 993,838 symbols: 2,840
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-08-16 04:54:00 | AAPL | Stock | 17.8321 | 17.8321 | 17.8321 | 17.8321 | 8960.0 |
| 2013-08-16 04:55:00 | AAPL | Stock | 17.8682 | 17.8682 | 17.8682 | 17.8682 | 8708.0 |
| 2013-08-16 04:58:00 | AAPL | Stock | 17.8607 | 17.8607 | 17.8607 | 17.8607 | 2800.0 |
| 2013-08-16 04:59:00 | AAPL | Stock | 17.8607 | 17.8607 | 17.8607 | 17.8607 | 11200.0 |
| 2013-08-16 05:08:00 | AAPL | Stock | 17.8671 | 17.8671 | 17.8671 | 17.8671 | 2800.0 |
| 2013-08-16 05:10:00 | AAPL | Stock | 17.8671 | 17.8671 | 17.8671 | 17.8671 | 8400.0 |
| 2013-08-16 05:11:00 | AAPL | Stock | 17.8571 | 17.8571 | 17.8571 | 17.8571 | 2800.0 |
| 2013-08-16 05:13:00 | AAPL | Stock | 17.8571 | 17.8571 | 17.8571 | 17.8571 | 2800.0 |
| 2013-08-16 05:30:00 | AAPL | Stock | 17.8357 | 17.8357 | 17.8357 | 17.8357 | 14000.0 |
| 2013-08-16 05:33:00 | AAPL | Stock | 17.8393 | 17.8393 | 17.8393 | 17.8393 | 7812.0 |
| 2013-08-16 05:38:00 | AAPL | Stock | 17.8539 | 17.8539 | 17.85 | 17.85 | 5600.0 |
| 2013-08-16 05:40:00 | AAPL | Stock | 17.85 | 17.85 | 17.85 | 17.85 | 2800.0 |
| 2013-08-16 05:41:00 | AAPL | Stock | 17.85 | 17.85 | 17.85 | 17.85 | 8400.0 |
| 2013-08-16 05:42:00 | AAPL | Stock | 17.8482 | 17.8482 | 17.8482 | 17.8482 | 9520.0 |
| 2013-08-16 05:43:00 | AAPL | Stock | 17.8411 | 17.8411 | 17.8036 | 17.8036 | 28000.0 |
| 2013-08-16 05:44:00 | AAPL | Stock | 17.8211 | 17.8211 | 17.8211 | 17.8211 | 2800.0 |
| 2013-08-16 05:45:00 | AAPL | Stock | 17.8211 | 17.8211 | 17.8211 | 17.8211 | 16800.0 |
| 2013-08-16 06:24:00 | AAPL | Stock | 17.8496 | 17.8496 | 17.8496 | 17.8496 | 2800.0 |
| 2013-08-16 06:57:00 | AAPL | Stock | 17.8471 | 17.8471 | 17.8471 | 17.8471 | 2800.0 |
| 2013-08-16 07:02:00 | AAPL | Stock | 17.8393 | 17.8393 | 17.8393 | 17.8393 | 2800.0 |
| 2013-08-16 07:06:00 | AAPL | Stock | 17.8393 | 17.8393 | 17.8393 | 17.8393 | 5600.0 |
| 2013-08-16 07:12:00 | AAPL | Stock | 17.8289 | 17.8321 | 17.8232 | 17.8321 | 22120.0 |
| 2013-08-16 07:13:00 | AAPL | Stock | 17.8393 | 17.8393 | 17.8393 | 17.8393 | 19600.0 |
| 2013-08-16 07:14:00 | AAPL | Stock | 17.8304 | 17.8304 | 17.8304 | 17.8304 | 2800.0 |
| 2013-08-16 07:15:00 | AAPL | Stock | 17.8321 | 17.8321 | 17.8282 | 17.8282 | 5600.0 |
| 2013-08-16 07:17:00 | AAPL | Stock | 17.8386 | 17.8536 | 17.8386 | 17.8536 | 40152.0 |
| 2013-08-16 07:20:00 | AAPL | Stock | 17.8511 | 17.8511 | 17.8511 | 17.8511 | 2800.0 |
| 2013-08-16 07:21:00 | AAPL | Stock | 17.8507 | 17.8596 | 17.8482 | 17.8596 | 59640.0 |
| 2013-08-16 07:22:00 | AAPL | Stock | 17.8621 | 17.8636 | 17.8621 | 17.8636 | 8400.0 |
| 2013-08-16 07:23:00 | AAPL | Stock | 17.8671 | 17.8671 | 17.8636 | 17.8636 | 11200.0 |
| 2013-08-16 07:24:00 | AAPL | Stock | 17.8582 | 17.8582 | 17.8582 | 17.8582 | 2800.0 |
| 2013-08-16 07:25:00 | AAPL | Stock | 17.8571 | 17.8671 | 17.8571 | 17.8671 | 28000.0 |
| 2013-08-16 07:27:00 | AAPL | Stock | 17.8661 | 17.8661 | 17.8661 | 17.8661 | 2800.0 |
| 2013-08-16 07:28:00 | AAPL | Stock | 17.8743 | 17.8743 | 17.8743 | 17.8743 | 2800.0 |
| 2013-08-16 07:29:00 | AAPL | Stock | 17.8661 | 17.8661 | 17.8661 | 17.8661 | 2800.0 |
| 2013-08-16 07:32:00 | AAPL | Stock | 17.8593 | 17.8607 | 17.8593 | 17.8607 | 11200.0 |
| 2013-08-16 07:33:00 | AAPL | Stock | 17.8593 | 17.8593 | 17.8571 | 17.8571 | 11368.0 |
| 2013-08-16 07:34:00 | AAPL | Stock | 17.8525 | 17.8525 | 17.8482 | 17.8482 | 16800.0 |
| 2013-08-16 07:35:00 | AAPL | Stock | 17.8429 | 17.8429 | 17.8411 | 17.8411 | 8400.0 |
| 2013-08-16 07:36:00 | AAPL | Stock | 17.8536 | 17.8536 | 17.8536 | 17.8536 | 2800.0 |
| 2013-08-16 07:43:00 | AAPL | Stock | 17.8607 | 17.8696 | 17.8607 | 17.8696 | 14000.0 |
| 2013-08-16 07:44:00 | AAPL | Stock | 17.8661 | 17.8661 | 17.8661 | 17.8661 | 2800.0 |
| 2013-08-16 07:45:00 | AAPL | Stock | 17.8625 | 17.8696 | 17.8625 | 17.8696 | 29792.0 |
| 2013-08-16 07:47:00 | AAPL | Stock | 17.8696 | 17.875 | 17.8696 | 17.875 | 33600.0 |
| 2013-08-16 07:48:00 | AAPL | Stock | 17.8761 | 17.8761 | 17.8761 | 17.8761 | 2800.0 |
| 2013-08-16 07:49:00 | AAPL | Stock | 17.8832 | 17.8839 | 17.8761 | 17.8761 | 49000.0 |
| 2013-08-16 07:50:00 | AAPL | Stock | 17.8882 | 17.8882 | 17.8839 | 17.8882 | 8400.0 |
| 2013-08-16 07:51:00 | AAPL | Stock | 17.8829 | 17.8829 | 17.8789 | 17.8789 | 5600.0 |
| 2013-08-16 07:53:00 | AAPL | Stock | 17.8804 | 17.8804 | 17.875 | 17.875 | 11200.0 |
| 2013-08-16 07:58:00 | AAPL | Stock | 17.8825 | 17.8825 | 17.8771 | 17.8771 | 27720.0 |
> showing 50 of 993,838 rows — these rows as CSV