PREVIEW / stock_1min / 2010-11-12
file: by_date/stock_1min/2010/2010-11-12.parquet size: 12.9 MB rows: 972,446 symbols: 2,818
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 |
|---|---|---|---|---|---|---|---|
| 2010-11-12 04:00:00 | AAPL | Stock | 11.2679 | 11.2679 | 11.2518 | 11.2518 | 19600.0 |
| 2010-11-12 04:01:00 | AAPL | Stock | 11.2457 | 11.2457 | 11.2143 | 11.2143 | 19600.0 |
| 2010-11-12 04:31:00 | AAPL | Stock | 11.1971 | 11.1971 | 11.1971 | 11.1971 | 2800.0 |
| 2010-11-12 04:38:00 | AAPL | Stock | 11.1839 | 11.1839 | 11.1839 | 11.1839 | 2800.0 |
| 2010-11-12 05:25:00 | AAPL | Stock | 11.2071 | 11.2071 | 11.2071 | 11.2071 | 8400.0 |
| 2010-11-12 05:26:00 | AAPL | Stock | 11.2071 | 11.2071 | 11.2071 | 11.2071 | 16800.0 |
| 2010-11-12 05:27:00 | AAPL | Stock | 11.2071 | 11.2071 | 11.2071 | 11.2071 | 44800.0 |
| 2010-11-12 05:29:00 | AAPL | Stock | 11.2071 | 11.2071 | 11.2071 | 11.2071 | 2800.0 |
| 2010-11-12 05:30:00 | AAPL | Stock | 11.2071 | 11.2071 | 11.2071 | 11.2071 | 31500.0 |
| 2010-11-12 05:41:00 | AAPL | Stock | 11.2321 | 11.2321 | 11.2321 | 11.2321 | 11200.0 |
| 2010-11-12 05:44:00 | AAPL | Stock | 11.2321 | 11.2321 | 11.2321 | 11.2321 | 8400.0 |
| 2010-11-12 05:50:00 | AAPL | Stock | 11.2321 | 11.2321 | 11.2321 | 11.2321 | 6720.0 |
| 2010-11-12 06:08:00 | AAPL | Stock | 11.2325 | 11.2325 | 11.2325 | 11.2325 | 5600.0 |
| 2010-11-12 06:09:00 | AAPL | Stock | 11.2329 | 11.2329 | 11.2286 | 11.2286 | 10164.0 |
| 2010-11-12 06:20:00 | AAPL | Stock | 11.2143 | 11.2143 | 11.2143 | 11.2143 | 2800.0 |
| 2010-11-12 06:22:00 | AAPL | Stock | 11.2214 | 11.2214 | 11.2214 | 11.2214 | 2800.0 |
| 2010-11-12 06:31:00 | AAPL | Stock | 11.2389 | 11.2389 | 11.2389 | 11.2389 | 2800.0 |
| 2010-11-12 06:32:00 | AAPL | Stock | 11.2214 | 11.2214 | 11.2214 | 11.2214 | 2800.0 |
| 2010-11-12 06:37:00 | AAPL | Stock | 11.2214 | 11.2393 | 11.2214 | 11.2393 | 12600.0 |
| 2010-11-12 06:42:00 | AAPL | Stock | 11.2375 | 11.2393 | 11.2375 | 11.2393 | 18900.0 |
| 2010-11-12 06:44:00 | AAPL | Stock | 11.2393 | 11.2393 | 11.2393 | 11.2393 | 2800.0 |
| 2010-11-12 07:00:00 | AAPL | Stock | 11.2625 | 11.2625 | 11.2625 | 11.2625 | 14000.0 |
| 2010-11-12 07:01:00 | AAPL | Stock | 11.2625 | 11.2636 | 11.2625 | 11.2625 | 20160.0 |
| 2010-11-12 07:04:00 | AAPL | Stock | 11.2268 | 11.2268 | 11.2246 | 11.2246 | 20440.0 |
| 2010-11-12 07:06:00 | AAPL | Stock | 11.2393 | 11.2393 | 11.2393 | 11.2393 | 3640.0 |
| 2010-11-12 07:09:00 | AAPL | Stock | 11.2379 | 11.2379 | 11.2339 | 11.2339 | 8400.0 |
| 2010-11-12 07:13:00 | AAPL | Stock | 11.25 | 11.25 | 11.25 | 11.25 | 5600.0 |
| 2010-11-12 07:18:00 | AAPL | Stock | 11.2582 | 11.2582 | 11.2582 | 11.2582 | 2800.0 |
| 2010-11-12 07:20:00 | AAPL | Stock | 11.2643 | 11.2643 | 11.2643 | 11.2643 | 11200.0 |
| 2010-11-12 07:21:00 | AAPL | Stock | 11.2696 | 11.2696 | 11.2696 | 11.2696 | 2800.0 |
| 2010-11-12 07:25:00 | AAPL | Stock | 11.2707 | 11.2707 | 11.2707 | 11.2707 | 2800.0 |
| 2010-11-12 07:28:00 | AAPL | Stock | 11.275 | 11.275 | 11.275 | 11.275 | 2800.0 |
| 2010-11-12 07:29:00 | AAPL | Stock | 11.2786 | 11.2786 | 11.275 | 11.2768 | 14000.0 |
| 2010-11-12 07:30:00 | AAPL | Stock | 11.275 | 11.275 | 11.275 | 11.275 | 2800.0 |
| 2010-11-12 07:31:00 | AAPL | Stock | 11.275 | 11.275 | 11.275 | 11.275 | 2800.0 |
| 2010-11-12 07:32:00 | AAPL | Stock | 11.2707 | 11.2707 | 11.2707 | 11.2707 | 21000.0 |
| 2010-11-12 07:34:00 | AAPL | Stock | 11.2679 | 11.2679 | 11.2679 | 11.2679 | 2800.0 |
| 2010-11-12 07:35:00 | AAPL | Stock | 11.2679 | 11.2679 | 11.2679 | 11.2679 | 2800.0 |
| 2010-11-12 07:36:00 | AAPL | Stock | 11.2707 | 11.2707 | 11.2707 | 11.2707 | 14000.0 |
| 2010-11-12 07:37:00 | AAPL | Stock | 11.2714 | 11.2714 | 11.2714 | 11.2714 | 8400.0 |
| 2010-11-12 07:38:00 | AAPL | Stock | 11.2679 | 11.2679 | 11.2679 | 11.2679 | 11200.0 |
| 2010-11-12 07:39:00 | AAPL | Stock | 11.2764 | 11.2764 | 11.2764 | 11.2764 | 7000.0 |
| 2010-11-12 07:41:00 | AAPL | Stock | 11.2718 | 11.2721 | 11.2718 | 11.2721 | 5600.0 |
| 2010-11-12 07:42:00 | AAPL | Stock | 11.2714 | 11.2714 | 11.2714 | 11.2714 | 2800.0 |
| 2010-11-12 07:44:00 | AAPL | Stock | 11.2771 | 11.2771 | 11.2771 | 11.2771 | 2800.0 |
| 2010-11-12 07:46:00 | AAPL | Stock | 11.2646 | 11.2646 | 11.2646 | 11.2646 | 5600.0 |
| 2010-11-12 07:47:00 | AAPL | Stock | 11.2654 | 11.2654 | 11.2654 | 11.2654 | 5600.0 |
| 2010-11-12 07:48:00 | AAPL | Stock | 11.2654 | 11.2654 | 11.2654 | 11.2654 | 2800.0 |
| 2010-11-12 07:49:00 | AAPL | Stock | 11.265 | 11.265 | 11.265 | 11.265 | 2800.0 |
| 2010-11-12 07:53:00 | AAPL | Stock | 11.2646 | 11.2661 | 11.2625 | 11.2625 | 75908.0 |
> showing 50 of 972,446 rows — these rows as CSV