PREVIEW / stock_1min / 2011-04-20
file: by_date/stock_1min/2011/2011-04-20.parquet size: 13.3 MB rows: 988,814 symbols: 2,877
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-04-20 04:00:00 | AAPL | Stock | 12.1393 | 12.1421 | 12.1393 | 12.1421 | 6440.0 |
| 2011-04-20 04:01:00 | AAPL | Stock | 12.2029 | 12.2029 | 12.2029 | 12.2029 | 2800.0 |
| 2011-04-20 04:12:00 | AAPL | Stock | 12.2161 | 12.2161 | 12.2161 | 12.2161 | 2800.0 |
| 2011-04-20 04:13:00 | AAPL | Stock | 12.2243 | 12.2243 | 12.2243 | 12.2243 | 5600.0 |
| 2011-04-20 04:16:00 | AAPL | Stock | 12.225 | 12.225 | 12.225 | 12.225 | 2800.0 |
| 2011-04-20 04:28:00 | AAPL | Stock | 12.225 | 12.225 | 12.225 | 12.225 | 2800.0 |
| 2011-04-20 04:29:00 | AAPL | Stock | 12.225 | 12.225 | 12.225 | 12.225 | 5600.0 |
| 2011-04-20 04:30:00 | AAPL | Stock | 12.225 | 12.225 | 12.225 | 12.225 | 2800.0 |
| 2011-04-20 04:47:00 | AAPL | Stock | 12.23 | 12.23 | 12.23 | 12.23 | 5600.0 |
| 2011-04-20 04:52:00 | AAPL | Stock | 12.2211 | 12.2211 | 12.2143 | 12.2143 | 11200.0 |
| 2011-04-20 04:54:00 | AAPL | Stock | 12.2143 | 12.2143 | 12.2143 | 12.2143 | 2800.0 |
| 2011-04-20 04:55:00 | AAPL | Stock | 12.2143 | 12.2143 | 12.2143 | 12.2143 | 8400.0 |
| 2011-04-20 04:58:00 | AAPL | Stock | 12.2214 | 12.2214 | 12.2214 | 12.2214 | 8400.0 |
| 2011-04-20 04:59:00 | AAPL | Stock | 12.2339 | 12.2346 | 12.2339 | 12.2346 | 9800.0 |
| 2011-04-20 05:00:00 | AAPL | Stock | 12.2464 | 12.2464 | 12.2346 | 12.2346 | 19320.0 |
| 2011-04-20 05:01:00 | AAPL | Stock | 12.245 | 12.245 | 12.2425 | 12.2425 | 5600.0 |
| 2011-04-20 05:17:00 | AAPL | Stock | 12.2496 | 12.2496 | 12.2496 | 12.2496 | 5600.0 |
| 2011-04-20 05:18:00 | AAPL | Stock | 12.25 | 12.25 | 12.25 | 12.25 | 9800.0 |
| 2011-04-20 05:20:00 | AAPL | Stock | 12.25 | 12.25 | 12.25 | 12.25 | 4200.0 |
| 2011-04-20 05:24:00 | AAPL | Stock | 12.2571 | 12.2571 | 12.2571 | 12.2571 | 16800.0 |
| 2011-04-20 05:28:00 | AAPL | Stock | 12.2504 | 12.2504 | 12.2504 | 12.2504 | 2800.0 |
| 2011-04-20 05:42:00 | AAPL | Stock | 12.2679 | 12.2679 | 12.2679 | 12.2679 | 2800.0 |
| 2011-04-20 05:44:00 | AAPL | Stock | 12.2679 | 12.2679 | 12.2679 | 12.2679 | 8400.0 |
| 2011-04-20 05:45:00 | AAPL | Stock | 12.2596 | 12.2596 | 12.2596 | 12.2596 | 2800.0 |
| 2011-04-20 05:54:00 | AAPL | Stock | 12.2639 | 12.2639 | 12.2639 | 12.2639 | 8400.0 |
| 2011-04-20 06:01:00 | AAPL | Stock | 12.2529 | 12.2529 | 12.2529 | 12.2529 | 2800.0 |
| 2011-04-20 06:05:00 | AAPL | Stock | 12.2675 | 12.2675 | 12.2675 | 12.2675 | 2800.0 |
| 2011-04-20 06:16:00 | AAPL | Stock | 12.2675 | 12.2675 | 12.2675 | 12.2675 | 7560.0 |
| 2011-04-20 06:17:00 | AAPL | Stock | 12.2671 | 12.2675 | 12.2671 | 12.2675 | 11200.0 |
| 2011-04-20 06:22:00 | AAPL | Stock | 12.2671 | 12.2679 | 12.2671 | 12.2679 | 14000.0 |
| 2011-04-20 06:23:00 | AAPL | Stock | 12.2768 | 12.2775 | 12.2768 | 12.2775 | 18200.0 |
| 2011-04-20 06:24:00 | AAPL | Stock | 12.2857 | 12.2857 | 12.2857 | 12.2857 | 23660.0 |
| 2011-04-20 06:25:00 | AAPL | Stock | 12.2929 | 12.2929 | 12.2857 | 12.2857 | 16800.0 |
| 2011-04-20 06:38:00 | AAPL | Stock | 12.2857 | 12.2857 | 12.2857 | 12.2857 | 14000.0 |
| 2011-04-20 06:40:00 | AAPL | Stock | 12.2857 | 12.2857 | 12.2857 | 12.2857 | 13636.0 |
| 2011-04-20 06:41:00 | AAPL | Stock | 12.2857 | 12.2857 | 12.2857 | 12.2857 | 14000.0 |
| 2011-04-20 06:45:00 | AAPL | Stock | 12.2943 | 12.2971 | 12.2857 | 12.2857 | 23800.0 |
| 2011-04-20 06:50:00 | AAPL | Stock | 12.2857 | 12.2857 | 12.2857 | 12.2857 | 8400.0 |
| 2011-04-20 06:51:00 | AAPL | Stock | 12.2857 | 12.2857 | 12.2857 | 12.2857 | 2800.0 |
| 2011-04-20 06:52:00 | AAPL | Stock | 12.2968 | 12.3036 | 12.2968 | 12.3036 | 33068.0 |
| 2011-04-20 06:53:00 | AAPL | Stock | 12.31 | 12.3114 | 12.31 | 12.3114 | 18200.0 |
| 2011-04-20 06:56:00 | AAPL | Stock | 12.2882 | 12.2882 | 12.2857 | 12.2857 | 31500.0 |
| 2011-04-20 07:00:00 | AAPL | Stock | 12.2857 | 12.2857 | 12.2857 | 12.2857 | 40376.0 |
| 2011-04-20 07:01:00 | AAPL | Stock | 12.2854 | 12.2854 | 12.2679 | 12.275 | 44800.0 |
| 2011-04-20 07:02:00 | AAPL | Stock | 12.2704 | 12.2818 | 12.2704 | 12.2818 | 33600.0 |
| 2011-04-20 07:03:00 | AAPL | Stock | 12.2818 | 12.2818 | 12.2675 | 12.2679 | 42700.0 |
| 2011-04-20 07:04:00 | AAPL | Stock | 12.2675 | 12.2675 | 12.25 | 12.25 | 8400.0 |
| 2011-04-20 07:05:00 | AAPL | Stock | 12.2521 | 12.2521 | 12.2464 | 12.2464 | 38920.0 |
| 2011-04-20 07:06:00 | AAPL | Stock | 12.2511 | 12.2511 | 12.2511 | 12.2511 | 2800.0 |
| 2011-04-20 07:07:00 | AAPL | Stock | 12.2446 | 12.2446 | 12.2446 | 12.2446 | 2800.0 |
> showing 50 of 988,814 rows — these rows as CSV