PREVIEW / stock_1min / 2013-09-06
file: by_date/stock_1min/2013/2013-09-06.parquet size: 13.5 MB rows: 987,139 symbols: 2,849
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-09-06 05:25:00 | AAPL | Stock | 17.7696 | 17.7696 | 17.7696 | 17.7696 | 12040.0 |
| 2013-09-06 05:31:00 | AAPL | Stock | 17.7607 | 17.7607 | 17.7607 | 17.7607 | 2800.0 |
| 2013-09-06 05:47:00 | AAPL | Stock | 17.7657 | 17.7657 | 17.7657 | 17.7657 | 2800.0 |
| 2013-09-06 05:55:00 | AAPL | Stock | 17.7661 | 17.7661 | 17.7657 | 17.7657 | 5600.0 |
| 2013-09-06 06:18:00 | AAPL | Stock | 17.7661 | 17.7661 | 17.7661 | 17.7661 | 2800.0 |
| 2013-09-06 06:23:00 | AAPL | Stock | 17.7814 | 17.7814 | 17.7814 | 17.7814 | 2800.0 |
| 2013-09-06 07:02:00 | AAPL | Stock | 17.7996 | 17.8 | 17.7996 | 17.8 | 6272.0 |
| 2013-09-06 07:08:00 | AAPL | Stock | 17.8018 | 17.8018 | 17.8018 | 17.8018 | 2800.0 |
| 2013-09-06 07:09:00 | AAPL | Stock | 17.8011 | 17.8021 | 17.8011 | 17.8018 | 22568.0 |
| 2013-09-06 07:10:00 | AAPL | Stock | 17.8014 | 17.8018 | 17.8014 | 17.8018 | 28000.0 |
| 2013-09-06 07:11:00 | AAPL | Stock | 17.79 | 17.79 | 17.79 | 17.79 | 14000.0 |
| 2013-09-06 07:12:00 | AAPL | Stock | 17.7857 | 17.7861 | 17.7857 | 17.7861 | 33600.0 |
| 2013-09-06 07:18:00 | AAPL | Stock | 17.7946 | 17.8 | 17.7946 | 17.8 | 30800.0 |
| 2013-09-06 07:19:00 | AAPL | Stock | 17.8039 | 17.8179 | 17.8039 | 17.8179 | 38080.0 |
| 2013-09-06 07:20:00 | AAPL | Stock | 17.8171 | 17.8304 | 17.8171 | 17.8304 | 25900.0 |
| 2013-09-06 07:21:00 | AAPL | Stock | 17.8289 | 17.8357 | 17.8071 | 17.8071 | 66724.0 |
| 2013-09-06 07:22:00 | AAPL | Stock | 17.8254 | 17.8254 | 17.8211 | 17.8211 | 19600.0 |
| 2013-09-06 07:23:00 | AAPL | Stock | 17.8218 | 17.8218 | 17.8214 | 17.8214 | 9352.0 |
| 2013-09-06 07:24:00 | AAPL | Stock | 17.8214 | 17.8214 | 17.8214 | 17.8214 | 2800.0 |
| 2013-09-06 07:25:00 | AAPL | Stock | 17.8211 | 17.8211 | 17.8211 | 17.8211 | 2800.0 |
| 2013-09-06 07:26:00 | AAPL | Stock | 17.8125 | 17.8125 | 17.8125 | 17.8125 | 2800.0 |
| 2013-09-06 07:28:00 | AAPL | Stock | 17.8104 | 17.8104 | 17.7864 | 17.8032 | 50652.0 |
| 2013-09-06 07:30:00 | AAPL | Stock | 17.8036 | 17.8036 | 17.8029 | 17.8036 | 15596.0 |
| 2013-09-06 07:36:00 | AAPL | Stock | 17.8089 | 17.8089 | 17.8089 | 17.8089 | 2800.0 |
| 2013-09-06 07:40:00 | AAPL | Stock | 17.8039 | 17.8039 | 17.8039 | 17.8039 | 5852.0 |
| 2013-09-06 07:41:00 | AAPL | Stock | 17.8057 | 17.8057 | 17.8057 | 17.8057 | 2800.0 |
| 2013-09-06 07:42:00 | AAPL | Stock | 17.8125 | 17.8125 | 17.8125 | 17.8125 | 2800.0 |
| 2013-09-06 07:44:00 | AAPL | Stock | 17.8057 | 17.8071 | 17.8057 | 17.8071 | 8400.0 |
| 2013-09-06 07:45:00 | AAPL | Stock | 17.8157 | 17.8332 | 17.8157 | 17.8332 | 92540.0 |
| 2013-09-06 07:46:00 | AAPL | Stock | 17.8321 | 17.8332 | 17.8321 | 17.8332 | 25200.0 |
| 2013-09-06 07:47:00 | AAPL | Stock | 17.8339 | 17.8354 | 17.8339 | 17.8354 | 8400.0 |
| 2013-09-06 07:48:00 | AAPL | Stock | 17.835 | 17.835 | 17.835 | 17.835 | 2800.0 |
| 2013-09-06 07:49:00 | AAPL | Stock | 17.8346 | 17.8479 | 17.8336 | 17.8411 | 104748.0 |
| 2013-09-06 07:51:00 | AAPL | Stock | 17.8386 | 17.8393 | 17.8386 | 17.8393 | 17920.0 |
| 2013-09-06 07:52:00 | AAPL | Stock | 17.8321 | 17.8321 | 17.8318 | 17.8321 | 14000.0 |
| 2013-09-06 07:53:00 | AAPL | Stock | 17.8321 | 17.8321 | 17.8268 | 17.8268 | 11200.0 |
| 2013-09-06 07:54:00 | AAPL | Stock | 17.8282 | 17.8282 | 17.8282 | 17.8282 | 5600.0 |
| 2013-09-06 07:55:00 | AAPL | Stock | 17.8286 | 17.8329 | 17.8271 | 17.8271 | 22428.0 |
| 2013-09-06 07:59:00 | AAPL | Stock | 17.8332 | 17.8393 | 17.8332 | 17.8393 | 33236.0 |
| 2013-09-06 08:00:00 | AAPL | Stock | 17.8393 | 17.8532 | 17.7686 | 17.85 | 209356.0 |
| 2013-09-06 08:01:00 | AAPL | Stock | 17.8489 | 17.8489 | 17.8404 | 17.8436 | 66332.0 |
| 2013-09-06 08:02:00 | AAPL | Stock | 17.8461 | 17.8461 | 17.8304 | 17.8304 | 116732.0 |
| 2013-09-06 08:03:00 | AAPL | Stock | 17.8389 | 17.8414 | 17.8336 | 17.8393 | 76720.0 |
| 2013-09-06 08:04:00 | AAPL | Stock | 17.8393 | 17.8429 | 17.8382 | 17.8429 | 68600.0 |
| 2013-09-06 08:05:00 | AAPL | Stock | 17.8475 | 17.8489 | 17.8296 | 17.8296 | 58800.0 |
| 2013-09-06 08:06:00 | AAPL | Stock | 17.8293 | 17.8304 | 17.8236 | 17.8236 | 16800.0 |
| 2013-09-06 08:07:00 | AAPL | Stock | 17.8389 | 17.8389 | 17.8329 | 17.8329 | 14000.0 |
| 2013-09-06 08:08:00 | AAPL | Stock | 17.8393 | 17.8393 | 17.8243 | 17.8243 | 88368.0 |
| 2013-09-06 08:09:00 | AAPL | Stock | 17.8246 | 17.8246 | 17.8214 | 17.8236 | 11200.0 |
| 2013-09-06 08:11:00 | AAPL | Stock | 17.8171 | 17.8179 | 17.8054 | 17.8089 | 45752.0 |
> showing 50 of 987,139 rows — these rows as CSV