PREVIEW / stock_5min / 2014-01-10
file: by_date/stock_5min/2014/2014-01-10.parquet size: 5.5 MB rows: 359,688 symbols: 3,521
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-01-10 04:00:00 | AAPL | Stock | 19.1957 | 19.1957 | 19.175 | 19.175 | 5600.0 |
| 2014-01-10 04:15:00 | AAPL | Stock | 19.2054 | 19.2054 | 19.2054 | 19.2054 | 6020.0 |
| 2014-01-10 04:25:00 | AAPL | Stock | 19.1968 | 19.2054 | 19.1968 | 19.2054 | 5600.0 |
| 2014-01-10 04:35:00 | AAPL | Stock | 19.2054 | 19.2054 | 19.2054 | 19.2054 | 11900.0 |
| 2014-01-10 05:30:00 | AAPL | Stock | 19.25 | 19.25 | 19.25 | 19.25 | 2800.0 |
| 2014-01-10 05:35:00 | AAPL | Stock | 19.2579 | 19.2579 | 19.2579 | 19.2579 | 5600.0 |
| 2014-01-10 05:40:00 | AAPL | Stock | 19.2468 | 19.2468 | 19.2464 | 19.2464 | 5600.0 |
| 2014-01-10 06:00:00 | AAPL | Stock | 19.25 | 19.2504 | 19.25 | 19.2504 | 8400.0 |
| 2014-01-10 06:20:00 | AAPL | Stock | 19.2464 | 19.2575 | 19.2464 | 19.2575 | 8400.0 |
| 2014-01-10 06:35:00 | AAPL | Stock | 19.2575 | 19.2575 | 19.2575 | 19.2575 | 4900.0 |
| 2014-01-10 06:45:00 | AAPL | Stock | 19.2464 | 19.2479 | 19.2464 | 19.2479 | 11200.0 |
| 2014-01-10 06:55:00 | AAPL | Stock | 19.2504 | 19.2504 | 19.2407 | 19.2407 | 14000.0 |
| 2014-01-10 07:05:00 | AAPL | Stock | 19.2532 | 19.2532 | 19.2461 | 19.2464 | 25200.0 |
| 2014-01-10 07:10:00 | AAPL | Stock | 19.2464 | 19.2464 | 19.2464 | 19.2464 | 2800.0 |
| 2014-01-10 07:15:00 | AAPL | Stock | 19.2457 | 19.2464 | 19.2457 | 19.2464 | 5600.0 |
| 2014-01-10 07:20:00 | AAPL | Stock | 19.2411 | 19.2411 | 19.2411 | 19.2411 | 2800.0 |
| 2014-01-10 07:25:00 | AAPL | Stock | 19.2364 | 19.2364 | 19.2364 | 19.2364 | 5600.0 |
| 2014-01-10 07:30:00 | AAPL | Stock | 19.25 | 19.25 | 19.25 | 19.25 | 6692.0 |
| 2014-01-10 07:35:00 | AAPL | Stock | 19.2446 | 19.2446 | 19.2446 | 19.2446 | 8428.0 |
| 2014-01-10 07:40:00 | AAPL | Stock | 19.2468 | 19.2621 | 19.2468 | 19.2621 | 46620.0 |
| 2014-01-10 07:45:00 | AAPL | Stock | 19.2668 | 19.3086 | 19.2629 | 19.3086 | 215040.0 |
| 2014-01-10 07:50:00 | AAPL | Stock | 19.3157 | 19.3739 | 19.3104 | 19.3518 | 347200.0 |
| 2014-01-10 07:55:00 | AAPL | Stock | 19.3564 | 19.3693 | 19.3543 | 19.3679 | 196000.0 |
| 2014-01-10 08:00:00 | AAPL | Stock | 19.3625 | 19.3625 | 19.2857 | 19.3321 | 287588.0 |
| 2014-01-10 08:05:00 | AAPL | Stock | 19.3232 | 19.3371 | 19.3125 | 19.3125 | 224028.0 |
| 2014-01-10 08:10:00 | AAPL | Stock | 19.305 | 19.305 | 19.2857 | 19.2918 | 121940.0 |
| 2014-01-10 08:15:00 | AAPL | Stock | 19.2932 | 19.2932 | 19.2679 | 19.2679 | 144704.0 |
| 2014-01-10 08:20:00 | AAPL | Stock | 19.2782 | 19.2857 | 19.2629 | 19.2761 | 100156.0 |
| 2014-01-10 08:25:00 | AAPL | Stock | 19.2761 | 19.2857 | 19.2736 | 19.2857 | 120260.0 |
| 2014-01-10 08:30:00 | AAPL | Stock | 19.2857 | 19.2986 | 19.2393 | 19.2404 | 498456.0 |
| 2014-01-10 08:35:00 | AAPL | Stock | 19.235 | 19.2625 | 19.1796 | 19.2607 | 536788.0 |
| 2014-01-10 08:40:00 | AAPL | Stock | 19.259 | 19.3021 | 19.255 | 19.2868 | 364252.0 |
| 2014-01-10 08:45:00 | AAPL | Stock | 19.2893 | 19.2954 | 19.2768 | 19.2771 | 255248.0 |
| 2014-01-10 08:50:00 | AAPL | Stock | 19.2771 | 19.2771 | 19.2586 | 19.2607 | 171528.0 |
| 2014-01-10 08:55:00 | AAPL | Stock | 19.2579 | 19.2946 | 19.2557 | 19.2746 | 330820.0 |
| 2014-01-10 09:00:00 | AAPL | Stock | 19.2821 | 19.2982 | 19.2679 | 19.2686 | 289100.0 |
| 2014-01-10 09:05:00 | AAPL | Stock | 19.2686 | 19.2786 | 19.2679 | 19.2679 | 45304.0 |
| 2014-01-10 09:10:00 | AAPL | Stock | 19.2636 | 19.2857 | 19.2636 | 19.2786 | 184240.0 |
| 2014-01-10 09:15:00 | AAPL | Stock | 19.2789 | 19.2789 | 19.2575 | 19.2589 | 114324.0 |
| 2014-01-10 09:20:00 | AAPL | Stock | 19.2586 | 19.2607 | 19.2461 | 19.2607 | 95900.0 |
| 2014-01-10 09:25:00 | AAPL | Stock | 19.2543 | 19.2893 | 19.2543 | 19.2729 | 354312.0 |
| 2014-01-10 09:30:00 | AAPL | Stock | 19.2796 | 19.3143 | 19.2213 | 19.2268 | 17931900.0 |
| 2014-01-10 09:35:00 | AAPL | Stock | 19.2274 | 19.2768 | 19.2182 | 19.2668 | 5929532.0 |
| 2014-01-10 09:40:00 | AAPL | Stock | 19.2679 | 19.2711 | 19.1268 | 19.1452 | 9778636.0 |
| 2014-01-10 09:45:00 | AAPL | Stock | 19.1429 | 19.1618 | 19.125 | 19.1561 | 7046816.0 |
| 2014-01-10 09:50:00 | AAPL | Stock | 19.1586 | 19.1832 | 19.0875 | 19.1021 | 8054704.0 |
| 2014-01-10 09:55:00 | AAPL | Stock | 19.1014 | 19.1143 | 19.0679 | 19.1075 | 6034252.0 |
| 2014-01-10 10:00:00 | AAPL | Stock | 19.1075 | 19.1107 | 19.03 | 19.0643 | 7325248.0 |
| 2014-01-10 10:05:00 | AAPL | Stock | 19.0611 | 19.0625 | 18.9857 | 19.02 | 8897028.0 |
| 2014-01-10 10:10:00 | AAPL | Stock | 19.0182 | 19.0382 | 18.9925 | 19.0007 | 7681324.0 |
> showing 50 of 359,688 rows — these rows as CSV