PREVIEW / stock_1min / 2014-04-04
file: by_date/stock_1min/2014/2014-04-04.parquet size: 15.8 MB rows: 1,129,254 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 |
|---|---|---|---|---|---|---|---|
| 2014-04-04 05:20:00 | AAPL | Stock | 19.2754 | 19.2754 | 19.2754 | 19.2754 | 2884.0 |
| 2014-04-04 06:01:00 | AAPL | Stock | 19.2754 | 19.2754 | 19.2754 | 19.2754 | 2800.0 |
| 2014-04-04 06:08:00 | AAPL | Stock | 19.2893 | 19.2896 | 19.2893 | 19.2896 | 14000.0 |
| 2014-04-04 07:34:00 | AAPL | Stock | 19.2839 | 19.2839 | 19.2839 | 19.2839 | 2800.0 |
| 2014-04-04 07:36:00 | AAPL | Stock | 19.2821 | 19.2821 | 19.2821 | 19.2821 | 22400.0 |
| 2014-04-04 07:56:00 | AAPL | Stock | 19.2754 | 19.2754 | 19.2696 | 19.2696 | 17836.0 |
| 2014-04-04 08:00:00 | AAPL | Stock | 19.2739 | 19.275 | 19.2739 | 19.275 | 14000.0 |
| 2014-04-04 08:01:00 | AAPL | Stock | 19.275 | 19.2779 | 19.275 | 19.2779 | 14000.0 |
| 2014-04-04 08:02:00 | AAPL | Stock | 19.2543 | 19.2746 | 19.1429 | 19.1429 | 14000.0 |
| 2014-04-04 08:13:00 | AAPL | Stock | 19.2743 | 19.2743 | 19.2743 | 19.2743 | 2800.0 |
| 2014-04-04 08:15:00 | AAPL | Stock | 19.2714 | 19.2729 | 19.2714 | 19.2729 | 12964.0 |
| 2014-04-04 08:17:00 | AAPL | Stock | 19.2721 | 19.2721 | 19.2721 | 19.2721 | 5600.0 |
| 2014-04-04 08:21:00 | AAPL | Stock | 19.275 | 19.2754 | 19.275 | 19.275 | 9800.0 |
| 2014-04-04 08:22:00 | AAPL | Stock | 19.2789 | 19.2804 | 19.2789 | 19.28 | 37128.0 |
| 2014-04-04 08:26:00 | AAPL | Stock | 19.2811 | 19.2821 | 19.2682 | 19.2682 | 17108.0 |
| 2014-04-04 08:30:00 | AAPL | Stock | 19.2636 | 19.2925 | 19.2521 | 19.2925 | 68684.0 |
| 2014-04-04 08:31:00 | AAPL | Stock | 19.2846 | 19.2857 | 19.2846 | 19.2857 | 16800.0 |
| 2014-04-04 08:33:00 | AAPL | Stock | 19.2818 | 19.2857 | 19.2693 | 19.2693 | 72688.0 |
| 2014-04-04 08:34:00 | AAPL | Stock | 19.2607 | 19.2679 | 19.2532 | 19.2582 | 33600.0 |
| 2014-04-04 08:35:00 | AAPL | Stock | 19.2639 | 19.2679 | 19.2639 | 19.2675 | 39200.0 |
| 2014-04-04 08:36:00 | AAPL | Stock | 19.2679 | 19.2679 | 19.2679 | 19.2679 | 25200.0 |
| 2014-04-04 08:37:00 | AAPL | Stock | 19.2675 | 19.2675 | 19.2425 | 19.2425 | 47040.0 |
| 2014-04-04 08:38:00 | AAPL | Stock | 19.2425 | 19.2429 | 19.2425 | 19.2429 | 30800.0 |
| 2014-04-04 08:39:00 | AAPL | Stock | 19.2471 | 19.2486 | 19.2443 | 19.2486 | 30800.0 |
| 2014-04-04 08:41:00 | AAPL | Stock | 19.2464 | 19.2657 | 19.2425 | 19.2657 | 75600.0 |
| 2014-04-04 08:42:00 | AAPL | Stock | 19.2504 | 19.2504 | 19.2504 | 19.2504 | 14000.0 |
| 2014-04-04 08:43:00 | AAPL | Stock | 19.25 | 19.25 | 19.2496 | 19.25 | 14000.0 |
| 2014-04-04 08:44:00 | AAPL | Stock | 19.2589 | 19.2589 | 19.2589 | 19.2589 | 5600.0 |
| 2014-04-04 08:45:00 | AAPL | Stock | 19.2543 | 19.2543 | 19.2518 | 19.2543 | 19600.0 |
| 2014-04-04 08:46:00 | AAPL | Stock | 19.26 | 19.26 | 19.26 | 19.26 | 16800.0 |
| 2014-04-04 08:48:00 | AAPL | Stock | 19.2621 | 19.2639 | 19.2607 | 19.2639 | 33600.0 |
| 2014-04-04 08:52:00 | AAPL | Stock | 19.2632 | 19.2643 | 19.2632 | 19.2643 | 27888.0 |
| 2014-04-04 08:56:00 | AAPL | Stock | 19.2611 | 19.2643 | 19.2593 | 19.2643 | 41132.0 |
| 2014-04-04 08:58:00 | AAPL | Stock | 19.2675 | 19.2686 | 19.2675 | 19.2682 | 89740.0 |
| 2014-04-04 08:59:00 | AAPL | Stock | 19.2757 | 19.2757 | 19.2757 | 19.2757 | 5600.0 |
| 2014-04-04 09:00:00 | AAPL | Stock | 19.2632 | 19.2632 | 19.2632 | 19.2632 | 5600.0 |
| 2014-04-04 09:05:00 | AAPL | Stock | 19.2696 | 19.2696 | 19.2696 | 19.2696 | 8372.0 |
| 2014-04-04 09:07:00 | AAPL | Stock | 19.2736 | 19.2736 | 19.2689 | 19.2689 | 36456.0 |
| 2014-04-04 09:10:00 | AAPL | Stock | 19.2732 | 19.2732 | 19.2732 | 19.2732 | 4200.0 |
| 2014-04-04 09:11:00 | AAPL | Stock | 19.2696 | 19.2696 | 19.2696 | 19.2696 | 28000.0 |
| 2014-04-04 09:12:00 | AAPL | Stock | 19.2696 | 19.2696 | 19.2629 | 19.2629 | 11200.0 |
| 2014-04-04 09:16:00 | AAPL | Stock | 19.2654 | 19.2654 | 19.2654 | 19.2654 | 2800.0 |
| 2014-04-04 09:17:00 | AAPL | Stock | 19.2671 | 19.2671 | 19.2671 | 19.2671 | 2800.0 |
| 2014-04-04 09:18:00 | AAPL | Stock | 19.2679 | 19.2679 | 19.2679 | 19.2679 | 5600.0 |
| 2014-04-04 09:19:00 | AAPL | Stock | 19.2625 | 19.2625 | 19.2625 | 19.2625 | 2800.0 |
| 2014-04-04 09:20:00 | AAPL | Stock | 19.2614 | 19.2614 | 19.2614 | 19.2614 | 2800.0 |
| 2014-04-04 09:23:00 | AAPL | Stock | 19.2614 | 19.2657 | 19.2614 | 19.2657 | 43400.0 |
| 2014-04-04 09:26:00 | AAPL | Stock | 19.2579 | 19.2589 | 19.2543 | 19.2589 | 34860.0 |
| 2014-04-04 09:27:00 | AAPL | Stock | 19.2554 | 19.2554 | 19.2554 | 19.2554 | 9268.0 |
| 2014-04-04 09:28:00 | AAPL | Stock | 19.2596 | 19.2839 | 19.2586 | 19.2825 | 239820.0 |
> showing 50 of 1,129,254 rows — these rows as CSV