PREVIEW / stock_5min / 2010-11-11
file: by_date/stock_5min/2010/2010-11-11.parquet size: 4.8 MB rows: 325,019 symbols: 3,491
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-11 04:20:00 | AAPL | Stock | 11.25 | 11.25 | 11.25 | 11.25 | 2800.0 |
| 2010-11-11 04:25:00 | AAPL | Stock | 11.2607 | 11.2607 | 11.2607 | 11.2607 | 2800.0 |
| 2010-11-11 04:30:00 | AAPL | Stock | 11.2982 | 11.2982 | 11.2982 | 11.2982 | 2800.0 |
| 2010-11-11 05:25:00 | AAPL | Stock | 11.2857 | 11.2857 | 11.2857 | 11.2857 | 2800.0 |
| 2010-11-11 05:35:00 | AAPL | Stock | 11.2893 | 11.2893 | 11.2893 | 11.2893 | 2800.0 |
| 2010-11-11 06:15:00 | AAPL | Stock | 11.2954 | 11.2954 | 11.2939 | 11.2939 | 5600.0 |
| 2010-11-11 06:20:00 | AAPL | Stock | 11.295 | 11.295 | 11.2911 | 11.2911 | 5600.0 |
| 2010-11-11 06:30:00 | AAPL | Stock | 11.2664 | 11.2664 | 11.2664 | 11.2664 | 2800.0 |
| 2010-11-11 06:35:00 | AAPL | Stock | 11.2857 | 11.2857 | 11.2857 | 11.2857 | 2800.0 |
| 2010-11-11 07:00:00 | AAPL | Stock | 11.2782 | 11.2857 | 11.2782 | 11.2857 | 39200.0 |
| 2010-11-11 07:05:00 | AAPL | Stock | 11.3179 | 11.3179 | 11.2929 | 11.2929 | 33600.0 |
| 2010-11-11 07:15:00 | AAPL | Stock | 11.2914 | 11.2914 | 11.2914 | 11.2914 | 2800.0 |
| 2010-11-11 07:20:00 | AAPL | Stock | 11.2857 | 11.2871 | 11.2857 | 11.2871 | 8400.0 |
| 2010-11-11 07:35:00 | AAPL | Stock | 11.2693 | 11.2693 | 11.2679 | 11.2679 | 16800.0 |
| 2010-11-11 07:40:00 | AAPL | Stock | 11.2668 | 11.2668 | 11.2668 | 11.2668 | 3388.0 |
| 2010-11-11 07:45:00 | AAPL | Stock | 11.27 | 11.27 | 11.2668 | 11.2679 | 36400.0 |
| 2010-11-11 07:50:00 | AAPL | Stock | 11.2636 | 11.2679 | 11.2554 | 11.2554 | 65772.0 |
| 2010-11-11 07:55:00 | AAPL | Stock | 11.2571 | 11.2571 | 11.2571 | 11.2571 | 7840.0 |
| 2010-11-11 08:00:00 | AAPL | Stock | 11.2607 | 11.2807 | 11.2571 | 11.2779 | 207284.0 |
| 2010-11-11 08:05:00 | AAPL | Stock | 11.2714 | 11.2771 | 11.2696 | 11.2696 | 30800.0 |
| 2010-11-11 08:10:00 | AAPL | Stock | 11.2754 | 11.2768 | 11.2711 | 11.2768 | 89180.0 |
| 2010-11-11 08:15:00 | AAPL | Stock | 11.2814 | 11.2907 | 11.2786 | 11.2882 | 120120.0 |
| 2010-11-11 08:20:00 | AAPL | Stock | 11.2832 | 11.2961 | 11.2818 | 11.2857 | 402640.0 |
| 2010-11-11 08:25:00 | AAPL | Stock | 11.2857 | 11.2893 | 11.2789 | 11.2832 | 158060.0 |
| 2010-11-11 08:30:00 | AAPL | Stock | 11.2786 | 11.2786 | 11.2696 | 11.2732 | 50960.0 |
| 2010-11-11 08:35:00 | AAPL | Stock | 11.2732 | 11.2764 | 11.2732 | 11.2761 | 72800.0 |
| 2010-11-11 08:40:00 | AAPL | Stock | 11.2764 | 11.2775 | 11.2721 | 11.2721 | 61740.0 |
| 2010-11-11 08:45:00 | AAPL | Stock | 11.2725 | 11.2793 | 11.2725 | 11.2746 | 36680.0 |
| 2010-11-11 08:50:00 | AAPL | Stock | 11.2779 | 11.2786 | 11.2679 | 11.2679 | 273980.0 |
| 2010-11-11 08:55:00 | AAPL | Stock | 11.2707 | 11.2707 | 11.2657 | 11.2657 | 92400.0 |
| 2010-11-11 09:00:00 | AAPL | Stock | 11.2675 | 11.2679 | 11.2607 | 11.2611 | 83020.0 |
| 2010-11-11 09:05:00 | AAPL | Stock | 11.2632 | 11.2696 | 11.2632 | 11.2679 | 205324.0 |
| 2010-11-11 09:10:00 | AAPL | Stock | 11.2729 | 11.2779 | 11.2711 | 11.2711 | 151172.0 |
| 2010-11-11 09:15:00 | AAPL | Stock | 11.2693 | 11.2761 | 11.2693 | 11.2761 | 56140.0 |
| 2010-11-11 09:20:00 | AAPL | Stock | 11.2736 | 11.2736 | 11.2643 | 11.2696 | 172900.0 |
| 2010-11-11 09:25:00 | AAPL | Stock | 11.2693 | 11.2696 | 11.2507 | 11.2521 | 483980.0 |
| 2010-11-11 09:30:00 | AAPL | Stock | 11.2518 | 11.2679 | 11.2232 | 11.2489 | 21751940.0 |
| 2010-11-11 09:35:00 | AAPL | Stock | 11.2493 | 11.2696 | 11.2475 | 11.2664 | 14020748.0 |
| 2010-11-11 09:40:00 | AAPL | Stock | 11.2664 | 11.3 | 11.2564 | 11.2793 | 13931008.0 |
| 2010-11-11 09:45:00 | AAPL | Stock | 11.2793 | 11.2964 | 11.2714 | 11.2825 | 9879464.0 |
| 2010-11-11 09:50:00 | AAPL | Stock | 11.2842 | 11.3179 | 11.2768 | 11.3136 | 9483012.0 |
| 2010-11-11 09:55:00 | AAPL | Stock | 11.3143 | 11.3293 | 11.31 | 11.3146 | 9490432.0 |
| 2010-11-11 10:00:00 | AAPL | Stock | 11.3143 | 11.3179 | 11.2921 | 11.2979 | 7676480.0 |
| 2010-11-11 10:05:00 | AAPL | Stock | 11.2975 | 11.3368 | 11.2971 | 11.3357 | 8992396.0 |
| 2010-11-11 10:10:00 | AAPL | Stock | 11.3361 | 11.3596 | 11.3343 | 11.3471 | 9993032.0 |
| 2010-11-11 10:15:00 | AAPL | Stock | 11.3468 | 11.3639 | 11.3439 | 11.3635 | 6927928.0 |
| 2010-11-11 10:20:00 | AAPL | Stock | 11.3621 | 11.3714 | 11.3486 | 11.3518 | 7747488.0 |
| 2010-11-11 10:25:00 | AAPL | Stock | 11.3519 | 11.3643 | 11.3443 | 11.3514 | 5604368.0 |
| 2010-11-11 10:30:00 | AAPL | Stock | 11.3507 | 11.3536 | 11.3418 | 11.3477 | 4753560.0 |
| 2010-11-11 10:35:00 | AAPL | Stock | 11.3496 | 11.3536 | 11.3221 | 11.33 | 4930576.0 |
> showing 50 of 325,019 rows — these rows as CSV