PREVIEW / stock_1min / 2011-09-30
file: by_date/stock_1min/2011/2011-09-30.parquet size: 13.3 MB rows: 1,000,156 symbols: 2,846
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 |
|---|---|---|---|---|---|---|---|
| 2011-09-30 04:00:00 | AAPL | Stock | 13.9932 | 13.9932 | 13.9325 | 13.9325 | 5600.0 |
| 2011-09-30 04:30:00 | AAPL | Stock | 13.9071 | 13.9071 | 13.9071 | 13.9071 | 2800.0 |
| 2011-09-30 05:10:00 | AAPL | Stock | 13.8518 | 13.8518 | 13.8393 | 13.8393 | 5600.0 |
| 2011-09-30 05:20:00 | AAPL | Stock | 13.8536 | 13.8536 | 13.8536 | 13.8536 | 2800.0 |
| 2011-09-30 05:32:00 | AAPL | Stock | 13.8536 | 13.8536 | 13.8536 | 13.8536 | 2800.0 |
| 2011-09-30 05:40:00 | AAPL | Stock | 13.8661 | 13.8661 | 13.8661 | 13.8661 | 2800.0 |
| 2011-09-30 05:45:00 | AAPL | Stock | 13.865 | 13.865 | 13.865 | 13.865 | 2800.0 |
| 2011-09-30 06:00:00 | AAPL | Stock | 13.8468 | 13.8468 | 13.8468 | 13.8468 | 4172.0 |
| 2011-09-30 06:11:00 | AAPL | Stock | 13.8714 | 13.8714 | 13.8714 | 13.8714 | 2800.0 |
| 2011-09-30 06:13:00 | AAPL | Stock | 13.8714 | 13.8714 | 13.8714 | 13.8714 | 2800.0 |
| 2011-09-30 06:20:00 | AAPL | Stock | 13.8525 | 13.8525 | 13.85 | 13.85 | 5600.0 |
| 2011-09-30 06:21:00 | AAPL | Stock | 13.8464 | 13.8464 | 13.8464 | 13.8464 | 2800.0 |
| 2011-09-30 06:24:00 | AAPL | Stock | 13.8286 | 13.8286 | 13.8286 | 13.8286 | 2800.0 |
| 2011-09-30 06:25:00 | AAPL | Stock | 13.8254 | 13.8254 | 13.8254 | 13.8254 | 5600.0 |
| 2011-09-30 06:26:00 | AAPL | Stock | 13.83 | 13.83 | 13.83 | 13.83 | 2800.0 |
| 2011-09-30 06:48:00 | AAPL | Stock | 13.8357 | 13.8357 | 13.8357 | 13.8357 | 2800.0 |
| 2011-09-30 06:52:00 | AAPL | Stock | 13.8196 | 13.8196 | 13.8196 | 13.8196 | 2800.0 |
| 2011-09-30 06:53:00 | AAPL | Stock | 13.8171 | 13.8171 | 13.8171 | 13.8171 | 2800.0 |
| 2011-09-30 07:02:00 | AAPL | Stock | 13.8393 | 13.8564 | 13.8393 | 13.8564 | 7000.0 |
| 2011-09-30 07:03:00 | AAPL | Stock | 13.8564 | 13.8571 | 13.8564 | 13.8571 | 14000.0 |
| 2011-09-30 07:04:00 | AAPL | Stock | 13.8639 | 13.8639 | 13.8639 | 13.8639 | 2800.0 |
| 2011-09-30 07:05:00 | AAPL | Stock | 13.8639 | 13.8639 | 13.8639 | 13.8639 | 2800.0 |
| 2011-09-30 07:06:00 | AAPL | Stock | 13.8639 | 13.8639 | 13.8639 | 13.8639 | 28000.0 |
| 2011-09-30 07:08:00 | AAPL | Stock | 13.8575 | 13.8575 | 13.8571 | 13.8571 | 19600.0 |
| 2011-09-30 07:09:00 | AAPL | Stock | 13.8429 | 13.8429 | 13.8393 | 13.8393 | 12040.0 |
| 2011-09-30 07:10:00 | AAPL | Stock | 13.8311 | 13.8329 | 13.8311 | 13.8321 | 28840.0 |
| 2011-09-30 07:11:00 | AAPL | Stock | 13.8275 | 13.8275 | 13.8275 | 13.8275 | 2800.0 |
| 2011-09-30 07:12:00 | AAPL | Stock | 13.8339 | 13.8429 | 13.8339 | 13.8429 | 30800.0 |
| 2011-09-30 07:15:00 | AAPL | Stock | 13.8393 | 13.84 | 13.8393 | 13.8396 | 24080.0 |
| 2011-09-30 07:17:00 | AAPL | Stock | 13.8407 | 13.8407 | 13.8407 | 13.8407 | 8400.0 |
| 2011-09-30 07:18:00 | AAPL | Stock | 13.8396 | 13.8396 | 13.8339 | 13.8339 | 28140.0 |
| 2011-09-30 07:19:00 | AAPL | Stock | 13.8343 | 13.8343 | 13.8304 | 13.8304 | 36120.0 |
| 2011-09-30 07:21:00 | AAPL | Stock | 13.8393 | 13.8557 | 13.8393 | 13.8557 | 11200.0 |
| 2011-09-30 07:25:00 | AAPL | Stock | 13.8554 | 13.8554 | 13.8554 | 13.8554 | 2800.0 |
| 2011-09-30 07:29:00 | AAPL | Stock | 13.8414 | 13.8414 | 13.8393 | 13.8393 | 77560.0 |
| 2011-09-30 07:31:00 | AAPL | Stock | 13.8286 | 13.8286 | 13.8286 | 13.8286 | 2800.0 |
| 2011-09-30 07:32:00 | AAPL | Stock | 13.83 | 13.83 | 13.83 | 13.83 | 3500.0 |
| 2011-09-30 07:33:00 | AAPL | Stock | 13.8393 | 13.8393 | 13.8393 | 13.8393 | 5600.0 |
| 2011-09-30 07:34:00 | AAPL | Stock | 13.8396 | 13.8396 | 13.8396 | 13.8396 | 2800.0 |
| 2011-09-30 07:35:00 | AAPL | Stock | 13.8393 | 13.8393 | 13.8393 | 13.8393 | 2800.0 |
| 2011-09-30 07:38:00 | AAPL | Stock | 13.8471 | 13.8471 | 13.8471 | 13.8471 | 2800.0 |
| 2011-09-30 07:39:00 | AAPL | Stock | 13.8464 | 13.8571 | 13.8421 | 13.8571 | 53200.0 |
| 2011-09-30 07:40:00 | AAPL | Stock | 13.8571 | 13.8607 | 13.8571 | 13.8607 | 5600.0 |
| 2011-09-30 07:42:00 | AAPL | Stock | 13.8579 | 13.8579 | 13.8554 | 13.8554 | 27664.0 |
| 2011-09-30 07:43:00 | AAPL | Stock | 13.8575 | 13.8575 | 13.8507 | 13.8507 | 69272.0 |
| 2011-09-30 07:44:00 | AAPL | Stock | 13.8571 | 13.8571 | 13.8504 | 13.8504 | 16800.0 |
| 2011-09-30 07:45:00 | AAPL | Stock | 13.8604 | 13.8604 | 13.8568 | 13.8568 | 14000.0 |
| 2011-09-30 07:47:00 | AAPL | Stock | 13.8557 | 13.8571 | 13.8557 | 13.8571 | 44800.0 |
| 2011-09-30 07:48:00 | AAPL | Stock | 13.8571 | 13.8571 | 13.8564 | 13.8571 | 36400.0 |
| 2011-09-30 07:49:00 | AAPL | Stock | 13.8571 | 13.8643 | 13.8571 | 13.8571 | 24500.0 |
> showing 50 of 1,000,156 rows — these rows as CSV