PREVIEW / stock_1min / 2013-12-06
file: by_date/stock_1min/2013/2013-12-06.parquet size: 14.1 MB rows: 1,037,507 symbols: 2,854
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-12-06 04:00:00 | AAPL | Stock | 20.3214 | 20.3214 | 20.3214 | 20.3214 | 5320.0 |
| 2013-12-06 04:05:00 | AAPL | Stock | 20.3357 | 20.3357 | 20.3357 | 20.3357 | 2800.0 |
| 2013-12-06 04:15:00 | AAPL | Stock | 20.3279 | 20.3279 | 20.3279 | 20.3279 | 2800.0 |
| 2013-12-06 04:26:00 | AAPL | Stock | 20.3454 | 20.3454 | 20.3454 | 20.3454 | 5600.0 |
| 2013-12-06 04:56:00 | AAPL | Stock | 20.3629 | 20.3629 | 20.3629 | 20.3629 | 2800.0 |
| 2013-12-06 05:02:00 | AAPL | Stock | 20.3721 | 20.3721 | 20.3604 | 20.3604 | 5600.0 |
| 2013-12-06 05:04:00 | AAPL | Stock | 20.3564 | 20.3564 | 20.3564 | 20.3564 | 5600.0 |
| 2013-12-06 05:07:00 | AAPL | Stock | 20.3489 | 20.3489 | 20.3489 | 20.3489 | 2800.0 |
| 2013-12-06 05:16:00 | AAPL | Stock | 20.3571 | 20.3571 | 20.3571 | 20.3571 | 2800.0 |
| 2013-12-06 05:23:00 | AAPL | Stock | 20.3489 | 20.3489 | 20.3429 | 20.3429 | 8400.0 |
| 2013-12-06 05:28:00 | AAPL | Stock | 20.3429 | 20.3429 | 20.3429 | 20.3429 | 2912.0 |
| 2013-12-06 05:38:00 | AAPL | Stock | 20.3454 | 20.3454 | 20.3454 | 20.3454 | 2800.0 |
| 2013-12-06 05:39:00 | AAPL | Stock | 20.3536 | 20.3571 | 20.3536 | 20.3571 | 14000.0 |
| 2013-12-06 05:47:00 | AAPL | Stock | 20.3432 | 20.3432 | 20.3429 | 20.3429 | 5600.0 |
| 2013-12-06 06:00:00 | AAPL | Stock | 20.3482 | 20.3482 | 20.3482 | 20.3482 | 2800.0 |
| 2013-12-06 06:02:00 | AAPL | Stock | 20.3568 | 20.3568 | 20.3564 | 20.3568 | 16800.0 |
| 2013-12-06 06:06:00 | AAPL | Stock | 20.3321 | 20.3321 | 20.3214 | 20.3214 | 9800.0 |
| 2013-12-06 06:13:00 | AAPL | Stock | 20.3171 | 20.3171 | 20.3171 | 20.3171 | 2800.0 |
| 2013-12-06 06:27:00 | AAPL | Stock | 20.3125 | 20.3125 | 20.2857 | 20.2857 | 23856.0 |
| 2013-12-06 06:42:00 | AAPL | Stock | 20.2568 | 20.2568 | 20.2525 | 20.2564 | 14000.0 |
| 2013-12-06 06:43:00 | AAPL | Stock | 20.2564 | 20.2564 | 20.2564 | 20.2564 | 16800.0 |
| 2013-12-06 06:45:00 | AAPL | Stock | 20.2321 | 20.2321 | 20.2321 | 20.2321 | 4200.0 |
| 2013-12-06 06:50:00 | AAPL | Stock | 20.2254 | 20.2254 | 20.2143 | 20.2143 | 55636.0 |
| 2013-12-06 06:54:00 | AAPL | Stock | 20.2386 | 20.2386 | 20.2386 | 20.2386 | 5936.0 |
| 2013-12-06 06:59:00 | AAPL | Stock | 20.2411 | 20.2411 | 20.2411 | 20.2411 | 2800.0 |
| 2013-12-06 07:00:00 | AAPL | Stock | 20.25 | 20.2525 | 20.25 | 20.2525 | 7280.0 |
| 2013-12-06 07:01:00 | AAPL | Stock | 20.2525 | 20.2525 | 20.2507 | 20.2507 | 6020.0 |
| 2013-12-06 07:02:00 | AAPL | Stock | 20.2679 | 20.2679 | 20.2679 | 20.2679 | 5600.0 |
| 2013-12-06 07:05:00 | AAPL | Stock | 20.25 | 20.25 | 20.25 | 20.25 | 3220.0 |
| 2013-12-06 07:07:00 | AAPL | Stock | 20.2607 | 20.2679 | 20.2607 | 20.2679 | 19740.0 |
| 2013-12-06 07:13:00 | AAPL | Stock | 20.275 | 20.275 | 20.275 | 20.275 | 14000.0 |
| 2013-12-06 07:14:00 | AAPL | Stock | 20.275 | 20.275 | 20.275 | 20.275 | 11200.0 |
| 2013-12-06 07:15:00 | AAPL | Stock | 20.2682 | 20.2682 | 20.2643 | 20.2643 | 35140.0 |
| 2013-12-06 07:22:00 | AAPL | Stock | 20.2679 | 20.2679 | 20.2621 | 20.2621 | 14000.0 |
| 2013-12-06 07:23:00 | AAPL | Stock | 20.2629 | 20.2629 | 20.2621 | 20.2621 | 12600.0 |
| 2013-12-06 07:26:00 | AAPL | Stock | 20.2536 | 20.2536 | 20.2411 | 20.2411 | 19600.0 |
| 2013-12-06 07:27:00 | AAPL | Stock | 20.2411 | 20.2411 | 20.2321 | 20.2321 | 11760.0 |
| 2013-12-06 07:28:00 | AAPL | Stock | 20.2275 | 20.2275 | 20.2143 | 20.2143 | 15484.0 |
| 2013-12-06 07:29:00 | AAPL | Stock | 20.2143 | 20.2143 | 20.1875 | 20.1875 | 42000.0 |
| 2013-12-06 07:30:00 | AAPL | Stock | 20.1879 | 20.1879 | 20.1782 | 20.1782 | 62468.0 |
| 2013-12-06 07:31:00 | AAPL | Stock | 20.1964 | 20.1964 | 20.1679 | 20.1786 | 25172.0 |
| 2013-12-06 07:32:00 | AAPL | Stock | 20.1893 | 20.2064 | 20.1893 | 20.2064 | 50400.0 |
| 2013-12-06 07:33:00 | AAPL | Stock | 20.1789 | 20.1957 | 20.1789 | 20.1957 | 11200.0 |
| 2013-12-06 07:34:00 | AAPL | Stock | 20.1961 | 20.1979 | 20.1957 | 20.1971 | 33600.0 |
| 2013-12-06 07:36:00 | AAPL | Stock | 20.1875 | 20.1875 | 20.1875 | 20.1875 | 2800.0 |
| 2013-12-06 07:37:00 | AAPL | Stock | 20.1893 | 20.1989 | 20.1893 | 20.1989 | 8400.0 |
| 2013-12-06 07:38:00 | AAPL | Stock | 20.1989 | 20.1989 | 20.1989 | 20.1989 | 22400.0 |
| 2013-12-06 07:40:00 | AAPL | Stock | 20.1989 | 20.1989 | 20.1989 | 20.1989 | 5600.0 |
| 2013-12-06 07:41:00 | AAPL | Stock | 20.1989 | 20.1989 | 20.1986 | 20.1986 | 8400.0 |
| 2013-12-06 07:42:00 | AAPL | Stock | 20.2046 | 20.2143 | 20.2046 | 20.2143 | 15232.0 |
> showing 50 of 1,037,507 rows — these rows as CSV