PREVIEW / stock_1min / 2010-07-08
file: by_date/stock_1min/2010/2010-07-08.parquet size: 12.7 MB rows: 983,279 symbols: 2,806
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-07-08 04:43:00 | AAPL | Stock | 9.2714 | 9.2714 | 9.2714 | 9.2714 | 2800.0 |
| 2010-07-08 04:44:00 | AAPL | Stock | 9.275 | 9.2789 | 9.275 | 9.2789 | 5600.0 |
| 2010-07-08 04:45:00 | AAPL | Stock | 9.2789 | 9.2789 | 9.2789 | 9.2789 | 5600.0 |
| 2010-07-08 05:00:00 | AAPL | Stock | 9.2804 | 9.2804 | 9.2804 | 9.2804 | 2800.0 |
| 2010-07-08 05:16:00 | AAPL | Stock | 9.275 | 9.275 | 9.275 | 9.275 | 2800.0 |
| 2010-07-08 05:42:00 | AAPL | Stock | 9.2754 | 9.2754 | 9.275 | 9.275 | 36540.0 |
| 2010-07-08 05:43:00 | AAPL | Stock | 9.275 | 9.275 | 9.275 | 9.275 | 2800.0 |
| 2010-07-08 05:44:00 | AAPL | Stock | 9.275 | 9.275 | 9.275 | 9.275 | 8400.0 |
| 2010-07-08 05:45:00 | AAPL | Stock | 9.275 | 9.275 | 9.275 | 9.275 | 8260.0 |
| 2010-07-08 06:20:00 | AAPL | Stock | 9.2768 | 9.2768 | 9.2768 | 9.2768 | 2800.0 |
| 2010-07-08 06:36:00 | AAPL | Stock | 9.3018 | 9.3018 | 9.3018 | 9.3018 | 8400.0 |
| 2010-07-08 07:00:00 | AAPL | Stock | 9.2768 | 9.2768 | 9.275 | 9.2768 | 28000.0 |
| 2010-07-08 07:01:00 | AAPL | Stock | 9.2768 | 9.2857 | 9.2736 | 9.2736 | 27132.0 |
| 2010-07-08 07:02:00 | AAPL | Stock | 9.275 | 9.275 | 9.275 | 9.275 | 34888.0 |
| 2010-07-08 07:03:00 | AAPL | Stock | 9.2679 | 9.2679 | 9.2679 | 9.2679 | 13720.0 |
| 2010-07-08 07:04:00 | AAPL | Stock | 9.2714 | 9.2714 | 9.2679 | 9.2679 | 47600.0 |
| 2010-07-08 07:05:00 | AAPL | Stock | 9.2711 | 9.2711 | 9.2711 | 9.2711 | 11088.0 |
| 2010-07-08 07:06:00 | AAPL | Stock | 9.2707 | 9.2714 | 9.2554 | 9.2554 | 10500.0 |
| 2010-07-08 07:07:00 | AAPL | Stock | 9.2707 | 9.2711 | 9.2668 | 9.2668 | 14000.0 |
| 2010-07-08 07:08:00 | AAPL | Stock | 9.2643 | 9.2643 | 9.2625 | 9.2625 | 19600.0 |
| 2010-07-08 07:17:00 | AAPL | Stock | 9.2629 | 9.2629 | 9.2629 | 9.2629 | 2800.0 |
| 2010-07-08 07:20:00 | AAPL | Stock | 9.2704 | 9.2786 | 9.2704 | 9.2786 | 70000.0 |
| 2010-07-08 07:21:00 | AAPL | Stock | 9.2786 | 9.2786 | 9.2786 | 9.2786 | 70000.0 |
| 2010-07-08 07:22:00 | AAPL | Stock | 9.2768 | 9.2768 | 9.2768 | 9.2768 | 19600.0 |
| 2010-07-08 07:24:00 | AAPL | Stock | 9.2804 | 9.2807 | 9.2771 | 9.2771 | 89600.0 |
| 2010-07-08 07:25:00 | AAPL | Stock | 9.2732 | 9.2732 | 9.2732 | 9.2732 | 8400.0 |
| 2010-07-08 07:28:00 | AAPL | Stock | 9.2661 | 9.2661 | 9.2661 | 9.2661 | 2800.0 |
| 2010-07-08 07:30:00 | AAPL | Stock | 9.2679 | 9.2679 | 9.2679 | 9.2679 | 5600.0 |
| 2010-07-08 07:31:00 | AAPL | Stock | 9.2646 | 9.2646 | 9.2646 | 9.2646 | 2800.0 |
| 2010-07-08 07:32:00 | AAPL | Stock | 9.2643 | 9.2643 | 9.2629 | 9.2629 | 18200.0 |
| 2010-07-08 07:33:00 | AAPL | Stock | 9.2629 | 9.2629 | 9.2629 | 9.2629 | 5600.0 |
| 2010-07-08 07:34:00 | AAPL | Stock | 9.2629 | 9.2629 | 9.2629 | 9.2629 | 13020.0 |
| 2010-07-08 07:35:00 | AAPL | Stock | 9.2593 | 9.2593 | 9.25 | 9.25 | 46200.0 |
| 2010-07-08 07:38:00 | AAPL | Stock | 9.2521 | 9.2521 | 9.2521 | 9.2521 | 14000.0 |
| 2010-07-08 07:42:00 | AAPL | Stock | 9.2479 | 9.2479 | 9.2479 | 9.2479 | 14000.0 |
| 2010-07-08 07:43:00 | AAPL | Stock | 9.245 | 9.2461 | 9.245 | 9.2461 | 22400.0 |
| 2010-07-08 07:44:00 | AAPL | Stock | 9.245 | 9.245 | 9.245 | 9.245 | 2800.0 |
| 2010-07-08 07:46:00 | AAPL | Stock | 9.2607 | 9.2643 | 9.2607 | 9.2643 | 5600.0 |
| 2010-07-08 07:57:00 | AAPL | Stock | 9.2621 | 9.2621 | 9.2621 | 9.2621 | 2800.0 |
| 2010-07-08 07:58:00 | AAPL | Stock | 9.2621 | 9.2621 | 9.2621 | 9.2621 | 2800.0 |
| 2010-07-08 08:00:00 | AAPL | Stock | 9.2575 | 9.2679 | 9.25 | 9.2536 | 97916.0 |
| 2010-07-08 08:01:00 | AAPL | Stock | 9.2571 | 9.2621 | 9.2514 | 9.2586 | 61936.0 |
| 2010-07-08 08:02:00 | AAPL | Stock | 9.2607 | 9.275 | 9.2607 | 9.2736 | 171528.0 |
| 2010-07-08 08:03:00 | AAPL | Stock | 9.2682 | 9.2729 | 9.2679 | 9.2714 | 70840.0 |
| 2010-07-08 08:04:00 | AAPL | Stock | 9.2746 | 9.275 | 9.2721 | 9.275 | 50120.0 |
| 2010-07-08 08:05:00 | AAPL | Stock | 9.275 | 9.2964 | 9.275 | 9.2875 | 245392.0 |
| 2010-07-08 08:06:00 | AAPL | Stock | 9.2964 | 9.2964 | 9.2857 | 9.2882 | 112000.0 |
| 2010-07-08 08:07:00 | AAPL | Stock | 9.2921 | 9.2971 | 9.2871 | 9.2871 | 58520.0 |
| 2010-07-08 08:08:00 | AAPL | Stock | 9.2896 | 9.2954 | 9.2896 | 9.2954 | 71680.0 |
| 2010-07-08 08:09:00 | AAPL | Stock | 9.2943 | 9.2946 | 9.2918 | 9.2946 | 28000.0 |
> showing 50 of 983,279 rows — these rows as CSV