PREVIEW / stock_5min / 2011-02-22
file: by_date/stock_5min/2011/2011-02-22.parquet size: 5.3 MB rows: 355,121 symbols: 3,545
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 |
|---|---|---|---|---|---|---|---|
| 2011-02-22 04:00:00 | AAPL | Stock | 12.4286 | 12.4286 | 12.2896 | 12.3429 | 141400.0 |
| 2011-02-22 04:05:00 | AAPL | Stock | 12.3489 | 12.3489 | 12.345 | 12.345 | 5600.0 |
| 2011-02-22 04:15:00 | AAPL | Stock | 12.3304 | 12.3304 | 12.3304 | 12.3304 | 8400.0 |
| 2011-02-22 04:20:00 | AAPL | Stock | 12.3304 | 12.3304 | 12.3304 | 12.3304 | 11200.0 |
| 2011-02-22 04:25:00 | AAPL | Stock | 12.3393 | 12.3393 | 12.3393 | 12.3393 | 8400.0 |
| 2011-02-22 04:30:00 | AAPL | Stock | 12.3393 | 12.3393 | 12.3304 | 12.3304 | 176064.0 |
| 2011-02-22 04:35:00 | AAPL | Stock | 12.3482 | 12.3571 | 12.3482 | 12.3571 | 8400.0 |
| 2011-02-22 04:40:00 | AAPL | Stock | 12.3571 | 12.3929 | 12.3571 | 12.3929 | 96544.0 |
| 2011-02-22 05:05:00 | AAPL | Stock | 12.3668 | 12.3668 | 12.3668 | 12.3668 | 2800.0 |
| 2011-02-22 05:10:00 | AAPL | Stock | 12.3693 | 12.3714 | 12.3693 | 12.3714 | 9604.0 |
| 2011-02-22 05:15:00 | AAPL | Stock | 12.3664 | 12.3664 | 12.3664 | 12.3664 | 2800.0 |
| 2011-02-22 05:25:00 | AAPL | Stock | 12.3661 | 12.3661 | 12.3661 | 12.3661 | 2800.0 |
| 2011-02-22 05:30:00 | AAPL | Stock | 12.3857 | 12.3857 | 12.3857 | 12.3857 | 5600.0 |
| 2011-02-22 05:35:00 | AAPL | Stock | 12.3857 | 12.3857 | 12.3857 | 12.3857 | 2800.0 |
| 2011-02-22 05:45:00 | AAPL | Stock | 12.3771 | 12.3771 | 12.3689 | 12.3689 | 5600.0 |
| 2011-02-22 05:50:00 | AAPL | Stock | 12.375 | 12.375 | 12.375 | 12.375 | 5600.0 |
| 2011-02-22 05:55:00 | AAPL | Stock | 12.3857 | 12.3857 | 12.3857 | 12.3857 | 3472.0 |
| 2011-02-22 06:05:00 | AAPL | Stock | 12.3886 | 12.3886 | 12.3886 | 12.3886 | 3640.0 |
| 2011-02-22 06:20:00 | AAPL | Stock | 12.3839 | 12.3839 | 12.3839 | 12.3839 | 2800.0 |
| 2011-02-22 06:40:00 | AAPL | Stock | 12.3804 | 12.3804 | 12.3804 | 12.3804 | 11732.0 |
| 2011-02-22 06:45:00 | AAPL | Stock | 12.3804 | 12.3804 | 12.36 | 12.36 | 19068.0 |
| 2011-02-22 06:50:00 | AAPL | Stock | 12.3732 | 12.3732 | 12.3636 | 12.3636 | 14000.0 |
| 2011-02-22 06:55:00 | AAPL | Stock | 12.3636 | 12.3636 | 12.3579 | 12.3579 | 10276.0 |
| 2011-02-22 07:00:00 | AAPL | Stock | 12.3468 | 12.3468 | 12.3221 | 12.3339 | 136668.0 |
| 2011-02-22 07:05:00 | AAPL | Stock | 12.3343 | 12.3536 | 12.3214 | 12.34 | 53312.0 |
| 2011-02-22 07:10:00 | AAPL | Stock | 12.3368 | 12.35 | 12.3368 | 12.3407 | 43428.0 |
| 2011-02-22 07:15:00 | AAPL | Stock | 12.3379 | 12.3554 | 12.3379 | 12.3554 | 46340.0 |
| 2011-02-22 07:20:00 | AAPL | Stock | 12.3486 | 12.3486 | 12.3379 | 12.3379 | 58044.0 |
| 2011-02-22 07:25:00 | AAPL | Stock | 12.3482 | 12.3482 | 12.3429 | 12.3429 | 16800.0 |
| 2011-02-22 07:30:00 | AAPL | Stock | 12.3429 | 12.3571 | 12.3429 | 12.3571 | 20692.0 |
| 2011-02-22 07:35:00 | AAPL | Stock | 12.3732 | 12.3732 | 12.3714 | 12.3732 | 81088.0 |
| 2011-02-22 07:40:00 | AAPL | Stock | 12.3732 | 12.3732 | 12.3464 | 12.3464 | 110320.0 |
| 2011-02-22 07:45:00 | AAPL | Stock | 12.3396 | 12.355 | 12.3393 | 12.3396 | 40600.0 |
| 2011-02-22 07:50:00 | AAPL | Stock | 12.3521 | 12.3675 | 12.3521 | 12.3607 | 43820.0 |
| 2011-02-22 07:55:00 | AAPL | Stock | 12.3571 | 12.3643 | 12.3571 | 12.3643 | 14112.0 |
| 2011-02-22 08:00:00 | AAPL | Stock | 12.3504 | 12.3614 | 12.3018 | 12.3214 | 1097488.0 |
| 2011-02-22 08:05:00 | AAPL | Stock | 12.3221 | 12.325 | 12.3143 | 12.3146 | 392896.0 |
| 2011-02-22 08:10:00 | AAPL | Stock | 12.3164 | 12.3164 | 12.2936 | 12.3 | 445256.0 |
| 2011-02-22 08:15:00 | AAPL | Stock | 12.2954 | 12.2982 | 12.2357 | 12.2411 | 814492.0 |
| 2011-02-22 08:20:00 | AAPL | Stock | 12.2411 | 12.2775 | 12.2411 | 12.2761 | 886816.0 |
| 2011-02-22 08:25:00 | AAPL | Stock | 12.2764 | 12.2946 | 12.2732 | 12.2946 | 351876.0 |
| 2011-02-22 08:30:00 | AAPL | Stock | 12.2929 | 12.2929 | 12.2857 | 12.2914 | 150416.0 |
| 2011-02-22 08:35:00 | AAPL | Stock | 12.2871 | 12.2889 | 12.2696 | 12.2807 | 323344.0 |
| 2011-02-22 08:40:00 | AAPL | Stock | 12.2818 | 12.2857 | 12.2807 | 12.2857 | 92932.0 |
| 2011-02-22 08:45:00 | AAPL | Stock | 12.2839 | 12.3193 | 12.2825 | 12.3161 | 519008.0 |
| 2011-02-22 08:50:00 | AAPL | Stock | 12.3161 | 12.3161 | 12.2964 | 12.2971 | 331576.0 |
| 2011-02-22 08:55:00 | AAPL | Stock | 12.3 | 12.3079 | 12.2971 | 12.2971 | 248220.0 |
| 2011-02-22 09:00:00 | AAPL | Stock | 12.3 | 12.3 | 12.2686 | 12.2686 | 434672.0 |
| 2011-02-22 09:05:00 | AAPL | Stock | 12.2754 | 12.2857 | 12.2675 | 12.2857 | 877408.0 |
| 2011-02-22 09:10:00 | AAPL | Stock | 12.2857 | 12.3 | 12.2821 | 12.2893 | 598360.0 |
> showing 50 of 355,121 rows — these rows as CSV