PREVIEW / stock_1min / 2012-11-20
file: by_date/stock_1min/2012/2012-11-20.parquet size: 12.5 MB rows: 928,184 symbols: 2,810
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-11-20 04:00:00 | AAPL | Stock | 20.2764 | 20.2764 | 20.2764 | 20.2764 | 2800.0 |
| 2012-11-20 04:04:00 | AAPL | Stock | 20.275 | 20.275 | 20.275 | 20.275 | 5600.0 |
| 2012-11-20 04:05:00 | AAPL | Stock | 20.2746 | 20.2746 | 20.2746 | 20.2746 | 2800.0 |
| 2012-11-20 04:09:00 | AAPL | Stock | 20.2743 | 20.2743 | 20.2743 | 20.2743 | 8400.0 |
| 2012-11-20 04:11:00 | AAPL | Stock | 20.2554 | 20.2554 | 20.2554 | 20.2554 | 20020.0 |
| 2012-11-20 04:16:00 | AAPL | Stock | 20.2571 | 20.2571 | 20.2571 | 20.2571 | 2800.0 |
| 2012-11-20 04:18:00 | AAPL | Stock | 20.2739 | 20.2739 | 20.2739 | 20.2739 | 2800.0 |
| 2012-11-20 04:24:00 | AAPL | Stock | 20.2786 | 20.2786 | 20.2786 | 20.2786 | 2800.0 |
| 2012-11-20 04:26:00 | AAPL | Stock | 20.2661 | 20.2661 | 20.2625 | 20.2625 | 5600.0 |
| 2012-11-20 04:27:00 | AAPL | Stock | 20.2661 | 20.2661 | 20.2661 | 20.2661 | 2800.0 |
| 2012-11-20 04:29:00 | AAPL | Stock | 20.2646 | 20.2646 | 20.2643 | 20.2643 | 5880.0 |
| 2012-11-20 04:36:00 | AAPL | Stock | 20.2607 | 20.2607 | 20.2607 | 20.2607 | 2800.0 |
| 2012-11-20 04:39:00 | AAPL | Stock | 20.2554 | 20.2554 | 20.2554 | 20.2554 | 5600.0 |
| 2012-11-20 04:46:00 | AAPL | Stock | 20.2554 | 20.2554 | 20.2554 | 20.2554 | 2800.0 |
| 2012-11-20 04:47:00 | AAPL | Stock | 20.2536 | 20.2536 | 20.25 | 20.25 | 11200.0 |
| 2012-11-20 04:49:00 | AAPL | Stock | 20.2429 | 20.2429 | 20.2257 | 20.2325 | 20440.0 |
| 2012-11-20 04:55:00 | AAPL | Stock | 20.2386 | 20.2386 | 20.2386 | 20.2386 | 2800.0 |
| 2012-11-20 05:01:00 | AAPL | Stock | 20.2268 | 20.2268 | 20.2268 | 20.2268 | 2800.0 |
| 2012-11-20 05:05:00 | AAPL | Stock | 20.2386 | 20.25 | 20.2386 | 20.25 | 11200.0 |
| 2012-11-20 05:23:00 | AAPL | Stock | 20.25 | 20.25 | 20.25 | 20.25 | 7420.0 |
| 2012-11-20 05:24:00 | AAPL | Stock | 20.2329 | 20.2329 | 20.2325 | 20.2325 | 14000.0 |
| 2012-11-20 05:27:00 | AAPL | Stock | 20.2529 | 20.2529 | 20.2529 | 20.2529 | 2800.0 |
| 2012-11-20 05:33:00 | AAPL | Stock | 20.2554 | 20.2554 | 20.2554 | 20.2554 | 5600.0 |
| 2012-11-20 05:34:00 | AAPL | Stock | 20.2554 | 20.2554 | 20.2554 | 20.2554 | 6384.0 |
| 2012-11-20 05:35:00 | AAPL | Stock | 20.2679 | 20.2679 | 20.2679 | 20.2679 | 11200.0 |
| 2012-11-20 05:36:00 | AAPL | Stock | 20.2779 | 20.2779 | 20.2779 | 20.2779 | 2800.0 |
| 2012-11-20 05:37:00 | AAPL | Stock | 20.2779 | 20.2789 | 20.2779 | 20.2789 | 5600.0 |
| 2012-11-20 05:40:00 | AAPL | Stock | 20.2821 | 20.2821 | 20.2821 | 20.2821 | 8400.0 |
| 2012-11-20 05:42:00 | AAPL | Stock | 20.2789 | 20.2789 | 20.2789 | 20.2789 | 2800.0 |
| 2012-11-20 05:45:00 | AAPL | Stock | 20.3 | 20.3 | 20.3 | 20.3 | 2800.0 |
| 2012-11-20 05:49:00 | AAPL | Stock | 20.2875 | 20.2875 | 20.2875 | 20.2875 | 2800.0 |
| 2012-11-20 05:55:00 | AAPL | Stock | 20.2946 | 20.3 | 20.2861 | 20.2861 | 23604.0 |
| 2012-11-20 05:56:00 | AAPL | Stock | 20.2779 | 20.2779 | 20.2779 | 20.2779 | 2800.0 |
| 2012-11-20 05:59:00 | AAPL | Stock | 20.2779 | 20.2779 | 20.2779 | 20.2779 | 6580.0 |
| 2012-11-20 06:00:00 | AAPL | Stock | 20.2714 | 20.2714 | 20.2679 | 20.2679 | 14420.0 |
| 2012-11-20 06:02:00 | AAPL | Stock | 20.2679 | 20.2679 | 20.2679 | 20.2679 | 2800.0 |
| 2012-11-20 06:04:00 | AAPL | Stock | 20.2679 | 20.2679 | 20.2671 | 20.2671 | 8400.0 |
| 2012-11-20 06:06:00 | AAPL | Stock | 20.2554 | 20.2554 | 20.2554 | 20.2554 | 5600.0 |
| 2012-11-20 06:07:00 | AAPL | Stock | 20.2525 | 20.2525 | 20.2525 | 20.2525 | 2800.0 |
| 2012-11-20 06:10:00 | AAPL | Stock | 20.2521 | 20.2521 | 20.2518 | 20.2518 | 5600.0 |
| 2012-11-20 06:12:00 | AAPL | Stock | 20.2504 | 20.2668 | 20.2504 | 20.2668 | 5600.0 |
| 2012-11-20 06:13:00 | AAPL | Stock | 20.2554 | 20.2554 | 20.2554 | 20.2554 | 5600.0 |
| 2012-11-20 06:18:00 | AAPL | Stock | 20.2554 | 20.2554 | 20.2554 | 20.2554 | 65604.0 |
| 2012-11-20 06:20:00 | AAPL | Stock | 20.255 | 20.255 | 20.255 | 20.255 | 2800.0 |
| 2012-11-20 06:23:00 | AAPL | Stock | 20.255 | 20.2554 | 20.255 | 20.2554 | 42000.0 |
| 2012-11-20 06:25:00 | AAPL | Stock | 20.2554 | 20.2554 | 20.2554 | 20.2554 | 17220.0 |
| 2012-11-20 06:28:00 | AAPL | Stock | 20.2432 | 20.2432 | 20.2432 | 20.2432 | 6020.0 |
| 2012-11-20 06:29:00 | AAPL | Stock | 20.2536 | 20.2536 | 20.2536 | 20.2536 | 2800.0 |
| 2012-11-20 06:41:00 | AAPL | Stock | 20.2446 | 20.2446 | 20.2446 | 20.2446 | 11200.0 |
| 2012-11-20 06:44:00 | AAPL | Stock | 20.25 | 20.25 | 20.25 | 20.25 | 2800.0 |
> showing 50 of 928,184 rows — these rows as CSV