PREVIEW / stock_5min / 2013-07-12
file: by_date/stock_5min/2013/2013-07-12.parquet size: 5.0 MB rows: 331,862 symbols: 3,512
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 |
|---|---|---|---|---|---|---|---|
| 2013-07-12 04:55:00 | AAPL | Stock | 15.2407 | 15.2407 | 15.2407 | 15.2407 | 2800.0 |
| 2013-07-12 05:00:00 | AAPL | Stock | 15.2368 | 15.2368 | 15.2368 | 15.2368 | 2800.0 |
| 2013-07-12 06:00:00 | AAPL | Stock | 15.2371 | 15.2371 | 15.2371 | 15.2371 | 5600.0 |
| 2013-07-12 06:20:00 | AAPL | Stock | 15.2436 | 15.2436 | 15.2436 | 15.2436 | 2800.0 |
| 2013-07-12 07:00:00 | AAPL | Stock | 15.2575 | 15.2679 | 15.2575 | 15.2679 | 12572.0 |
| 2013-07-12 07:05:00 | AAPL | Stock | 15.2504 | 15.2504 | 15.25 | 15.25 | 5600.0 |
| 2013-07-12 07:10:00 | AAPL | Stock | 15.2539 | 15.2693 | 15.2536 | 15.2693 | 16996.0 |
| 2013-07-12 07:15:00 | AAPL | Stock | 15.2514 | 15.2514 | 15.2514 | 15.2514 | 2800.0 |
| 2013-07-12 07:30:00 | AAPL | Stock | 15.2671 | 15.2707 | 15.2671 | 15.2707 | 5600.0 |
| 2013-07-12 07:40:00 | AAPL | Stock | 15.2539 | 15.2654 | 15.2507 | 15.2546 | 50400.0 |
| 2013-07-12 07:45:00 | AAPL | Stock | 15.2554 | 15.2554 | 15.2368 | 15.2368 | 78400.0 |
| 2013-07-12 07:50:00 | AAPL | Stock | 15.2489 | 15.25 | 15.2489 | 15.25 | 5600.0 |
| 2013-07-12 08:00:00 | AAPL | Stock | 15.2336 | 15.2607 | 15.2325 | 15.2529 | 95956.0 |
| 2013-07-12 08:05:00 | AAPL | Stock | 15.2586 | 15.2711 | 15.2521 | 15.2711 | 54208.0 |
| 2013-07-12 08:10:00 | AAPL | Stock | 15.2611 | 15.2707 | 15.2536 | 15.2661 | 97944.0 |
| 2013-07-12 08:15:00 | AAPL | Stock | 15.2625 | 15.2675 | 15.2607 | 15.2675 | 52500.0 |
| 2013-07-12 08:20:00 | AAPL | Stock | 15.2604 | 15.2714 | 15.2604 | 15.2714 | 6300.0 |
| 2013-07-12 08:25:00 | AAPL | Stock | 15.2579 | 15.2589 | 15.2579 | 15.2579 | 19600.0 |
| 2013-07-12 08:30:00 | AAPL | Stock | 15.2596 | 15.2611 | 15.2457 | 15.2514 | 134680.0 |
| 2013-07-12 08:35:00 | AAPL | Stock | 15.2414 | 15.2489 | 15.2414 | 15.2489 | 11200.0 |
| 2013-07-12 08:40:00 | AAPL | Stock | 15.2436 | 15.2546 | 15.2414 | 15.2546 | 74032.0 |
| 2013-07-12 08:45:00 | AAPL | Stock | 15.2496 | 15.255 | 15.2496 | 15.25 | 70000.0 |
| 2013-07-12 08:50:00 | AAPL | Stock | 15.255 | 15.2696 | 15.255 | 15.2696 | 42000.0 |
| 2013-07-12 08:55:00 | AAPL | Stock | 15.2721 | 15.2732 | 15.2721 | 15.2732 | 25200.0 |
| 2013-07-12 09:00:00 | AAPL | Stock | 15.2707 | 15.2711 | 15.2707 | 15.2711 | 16800.0 |
| 2013-07-12 09:05:00 | AAPL | Stock | 15.2646 | 15.2804 | 15.2643 | 15.2779 | 70000.0 |
| 2013-07-12 09:10:00 | AAPL | Stock | 15.2764 | 15.2764 | 15.2643 | 15.2646 | 39200.0 |
| 2013-07-12 09:15:00 | AAPL | Stock | 15.2746 | 15.2764 | 15.2529 | 15.2629 | 133924.0 |
| 2013-07-12 09:20:00 | AAPL | Stock | 15.2657 | 15.2764 | 15.2657 | 15.2718 | 28000.0 |
| 2013-07-12 09:25:00 | AAPL | Stock | 15.2736 | 15.2761 | 15.2636 | 15.2761 | 86800.0 |
| 2013-07-12 09:30:00 | AAPL | Stock | 15.2732 | 15.3036 | 15.2461 | 15.2786 | 10401580.0 |
| 2013-07-12 09:35:00 | AAPL | Stock | 15.2761 | 15.3357 | 15.2732 | 15.3268 | 12430012.0 |
| 2013-07-12 09:40:00 | AAPL | Stock | 15.3268 | 15.3304 | 15.2429 | 15.2571 | 10165540.0 |
| 2013-07-12 09:45:00 | AAPL | Stock | 15.2546 | 15.3018 | 15.2532 | 15.2932 | 7246596.0 |
| 2013-07-12 09:50:00 | AAPL | Stock | 15.2943 | 15.2964 | 15.2789 | 15.285 | 4521440.0 |
| 2013-07-12 09:55:00 | AAPL | Stock | 15.2846 | 15.3146 | 15.27 | 15.2893 | 6649916.0 |
| 2013-07-12 10:00:00 | AAPL | Stock | 15.2893 | 15.305 | 15.2834 | 15.2857 | 3101672.0 |
| 2013-07-12 10:05:00 | AAPL | Stock | 15.2907 | 15.3071 | 15.2821 | 15.3061 | 1834392.0 |
| 2013-07-12 10:10:00 | AAPL | Stock | 15.3046 | 15.3186 | 15.2875 | 15.3107 | 3843980.0 |
| 2013-07-12 10:15:00 | AAPL | Stock | 15.3107 | 15.335 | 15.3036 | 15.3264 | 5215056.0 |
| 2013-07-12 10:20:00 | AAPL | Stock | 15.3289 | 15.3482 | 15.3093 | 15.3482 | 4027968.0 |
| 2013-07-12 10:25:00 | AAPL | Stock | 15.3454 | 15.3496 | 15.3254 | 15.3382 | 4990496.0 |
| 2013-07-12 10:30:00 | AAPL | Stock | 15.3362 | 15.3382 | 15.2861 | 15.2936 | 5693268.0 |
| 2013-07-12 10:35:00 | AAPL | Stock | 15.2941 | 15.31 | 15.2807 | 15.3011 | 4798948.0 |
| 2013-07-12 10:40:00 | AAPL | Stock | 15.3018 | 15.3186 | 15.2964 | 15.3071 | 2697968.0 |
| 2013-07-12 10:45:00 | AAPL | Stock | 15.3071 | 15.3179 | 15.2571 | 15.2611 | 3372488.0 |
| 2013-07-12 10:50:00 | AAPL | Stock | 15.2594 | 15.2771 | 15.2536 | 15.2679 | 3740492.0 |
| 2013-07-12 10:55:00 | AAPL | Stock | 15.2689 | 15.2771 | 15.2643 | 15.2768 | 1623300.0 |
| 2013-07-12 11:00:00 | AAPL | Stock | 15.27 | 15.2914 | 15.2661 | 15.2661 | 2394728.0 |
| 2013-07-12 11:05:00 | AAPL | Stock | 15.2684 | 15.2707 | 15.2536 | 15.2646 | 1592276.0 |
> showing 50 of 331,862 rows — these rows as CSV