PREVIEW / stock_1min / 2012-08-03
file: by_date/stock_1min/2012/2012-08-03.parquet size: 12.8 MB rows: 962,373 symbols: 2,821
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-03 04:00:00 | AAPL | Stock | 21.7929 | 21.7939 | 21.7929 | 21.7939 | 5600.0 |
| 2012-08-03 04:10:00 | AAPL | Stock | 21.8129 | 21.8129 | 21.8125 | 21.8125 | 22400.0 |
| 2012-08-03 04:42:00 | AAPL | Stock | 21.8321 | 21.8321 | 21.8321 | 21.8321 | 7000.0 |
| 2012-08-03 05:13:00 | AAPL | Stock | 21.8393 | 21.8393 | 21.8393 | 21.8393 | 8400.0 |
| 2012-08-03 05:18:00 | AAPL | Stock | 21.8393 | 21.8393 | 21.8393 | 21.8393 | 8400.0 |
| 2012-08-03 05:28:00 | AAPL | Stock | 21.8393 | 21.8393 | 21.8393 | 21.8393 | 8400.0 |
| 2012-08-03 05:29:00 | AAPL | Stock | 21.8393 | 21.8393 | 21.8393 | 21.8393 | 8400.0 |
| 2012-08-03 05:30:00 | AAPL | Stock | 21.8393 | 21.8393 | 21.8393 | 21.8393 | 8400.0 |
| 2012-08-03 05:31:00 | AAPL | Stock | 21.8393 | 21.8393 | 21.8393 | 21.8393 | 14000.0 |
| 2012-08-03 05:35:00 | AAPL | Stock | 21.8393 | 21.8393 | 21.8393 | 21.8393 | 2800.0 |
| 2012-08-03 05:50:00 | AAPL | Stock | 21.8357 | 21.8357 | 21.8357 | 21.8357 | 2800.0 |
| 2012-08-03 06:23:00 | AAPL | Stock | 21.8464 | 21.8464 | 21.8464 | 21.8464 | 7000.0 |
| 2012-08-03 06:33:00 | AAPL | Stock | 21.8564 | 21.8564 | 21.8564 | 21.8564 | 2800.0 |
| 2012-08-03 06:34:00 | AAPL | Stock | 21.8643 | 21.8643 | 21.8643 | 21.8643 | 2800.0 |
| 2012-08-03 06:46:00 | AAPL | Stock | 21.8571 | 21.8571 | 21.8571 | 21.8571 | 2800.0 |
| 2012-08-03 07:00:00 | AAPL | Stock | 21.8507 | 21.8511 | 21.8393 | 21.8393 | 18200.0 |
| 2012-08-03 07:01:00 | AAPL | Stock | 21.8357 | 21.8357 | 21.8357 | 21.8357 | 2800.0 |
| 2012-08-03 07:02:00 | AAPL | Stock | 21.8393 | 21.8393 | 21.8393 | 21.8393 | 5600.0 |
| 2012-08-03 07:03:00 | AAPL | Stock | 21.8571 | 21.8714 | 21.8571 | 21.8714 | 14000.0 |
| 2012-08-03 07:04:00 | AAPL | Stock | 21.8714 | 21.8714 | 21.8561 | 21.8571 | 50008.0 |
| 2012-08-03 07:05:00 | AAPL | Stock | 21.8571 | 21.8632 | 21.8468 | 21.8468 | 26348.0 |
| 2012-08-03 07:06:00 | AAPL | Stock | 21.8596 | 21.8596 | 21.8596 | 21.8596 | 8400.0 |
| 2012-08-03 07:10:00 | AAPL | Stock | 21.8564 | 21.8564 | 21.8564 | 21.8564 | 2800.0 |
| 2012-08-03 07:14:00 | AAPL | Stock | 21.8546 | 21.8564 | 21.8546 | 21.8564 | 28000.0 |
| 2012-08-03 07:15:00 | AAPL | Stock | 21.8571 | 21.8571 | 21.8536 | 21.8536 | 6300.0 |
| 2012-08-03 07:22:00 | AAPL | Stock | 21.8464 | 21.8464 | 21.8464 | 21.8464 | 2800.0 |
| 2012-08-03 07:23:00 | AAPL | Stock | 21.8464 | 21.8464 | 21.8464 | 21.8464 | 3360.0 |
| 2012-08-03 07:26:00 | AAPL | Stock | 21.8429 | 21.8429 | 21.8304 | 21.8304 | 19600.0 |
| 2012-08-03 07:27:00 | AAPL | Stock | 21.8389 | 21.8529 | 21.8389 | 21.8475 | 160244.0 |
| 2012-08-03 07:28:00 | AAPL | Stock | 21.8482 | 21.8482 | 21.8475 | 21.8475 | 5600.0 |
| 2012-08-03 07:30:00 | AAPL | Stock | 21.8214 | 21.8296 | 21.8136 | 21.8214 | 65800.0 |
| 2012-08-03 07:31:00 | AAPL | Stock | 21.8211 | 21.8371 | 21.8207 | 21.8371 | 75600.0 |
| 2012-08-03 07:32:00 | AAPL | Stock | 21.8214 | 21.8218 | 21.8214 | 21.8214 | 19012.0 |
| 2012-08-03 07:33:00 | AAPL | Stock | 21.82 | 21.82 | 21.82 | 21.82 | 2800.0 |
| 2012-08-03 07:34:00 | AAPL | Stock | 21.8214 | 21.8214 | 21.8214 | 21.8214 | 2800.0 |
| 2012-08-03 07:35:00 | AAPL | Stock | 21.8214 | 21.8214 | 21.8214 | 21.8214 | 11200.0 |
| 2012-08-03 07:36:00 | AAPL | Stock | 21.8214 | 21.8214 | 21.8214 | 21.8214 | 2800.0 |
| 2012-08-03 07:38:00 | AAPL | Stock | 21.8214 | 21.8214 | 21.8214 | 21.8214 | 2800.0 |
| 2012-08-03 07:39:00 | AAPL | Stock | 21.8214 | 21.8214 | 21.8214 | 21.8214 | 16800.0 |
| 2012-08-03 07:40:00 | AAPL | Stock | 21.8207 | 21.8214 | 21.8207 | 21.8214 | 7560.0 |
| 2012-08-03 07:41:00 | AAPL | Stock | 21.8161 | 21.8161 | 21.8125 | 21.8125 | 19600.0 |
| 2012-08-03 07:42:00 | AAPL | Stock | 21.8193 | 21.8193 | 21.8193 | 21.8193 | 2800.0 |
| 2012-08-03 07:45:00 | AAPL | Stock | 21.8139 | 21.8139 | 21.8107 | 21.8107 | 11200.0 |
| 2012-08-03 07:49:00 | AAPL | Stock | 21.8018 | 21.8018 | 21.8014 | 21.8014 | 11200.0 |
| 2012-08-03 07:50:00 | AAPL | Stock | 21.7986 | 21.7986 | 21.7946 | 21.7946 | 50400.0 |
| 2012-08-03 07:51:00 | AAPL | Stock | 21.8036 | 21.8036 | 21.8036 | 21.8036 | 2800.0 |
| 2012-08-03 07:52:00 | AAPL | Stock | 21.8036 | 21.8036 | 21.8029 | 21.8036 | 22400.0 |
| 2012-08-03 07:53:00 | AAPL | Stock | 21.8089 | 21.8093 | 21.8089 | 21.8089 | 14000.0 |
| 2012-08-03 07:56:00 | AAPL | Stock | 21.8043 | 21.8043 | 21.8043 | 21.8043 | 3500.0 |
| 2012-08-03 07:58:00 | AAPL | Stock | 21.8004 | 21.8004 | 21.7946 | 21.7946 | 19600.0 |
> showing 50 of 962,373 rows — these rows as CSV