PREVIEW / stock_5min / 2011-04-07
file: by_date/stock_5min/2011/2011-04-07.parquet size: 4.8 MB rows: 320,648 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 |
|---|---|---|---|---|---|---|---|
| 2011-04-07 06:15:00 | AAPL | Stock | 12.0857 | 12.0857 | 12.0857 | 12.0857 | 11200.0 |
| 2011-04-07 06:35:00 | AAPL | Stock | 12.0929 | 12.0932 | 12.0929 | 12.0932 | 5600.0 |
| 2011-04-07 07:00:00 | AAPL | Stock | 12.0775 | 12.0775 | 12.0771 | 12.0771 | 8400.0 |
| 2011-04-07 07:05:00 | AAPL | Stock | 12.0854 | 12.0854 | 12.0854 | 12.0854 | 2800.0 |
| 2011-04-07 07:10:00 | AAPL | Stock | 12.0775 | 12.0775 | 12.0775 | 12.0775 | 2800.0 |
| 2011-04-07 07:15:00 | AAPL | Stock | 12.0854 | 12.0854 | 12.0854 | 12.0854 | 2800.0 |
| 2011-04-07 07:20:00 | AAPL | Stock | 12.0857 | 12.0857 | 12.0839 | 12.0857 | 8400.0 |
| 2011-04-07 07:25:00 | AAPL | Stock | 12.0939 | 12.0964 | 12.0939 | 12.0964 | 11200.0 |
| 2011-04-07 07:30:00 | AAPL | Stock | 12.0932 | 12.0964 | 12.0932 | 12.0964 | 15400.0 |
| 2011-04-07 07:35:00 | AAPL | Stock | 12.1032 | 12.115 | 12.0982 | 12.115 | 48440.0 |
| 2011-04-07 07:40:00 | AAPL | Stock | 12.1071 | 12.1121 | 12.1071 | 12.1071 | 270536.0 |
| 2011-04-07 07:50:00 | AAPL | Stock | 12.1125 | 12.115 | 12.1125 | 12.115 | 8400.0 |
| 2011-04-07 07:55:00 | AAPL | Stock | 12.1154 | 12.1171 | 12.1125 | 12.1125 | 11200.0 |
| 2011-04-07 08:00:00 | AAPL | Stock | 12.1111 | 12.1321 | 12.1111 | 12.1321 | 135856.0 |
| 2011-04-07 08:05:00 | AAPL | Stock | 12.1246 | 12.1339 | 12.1246 | 12.125 | 237272.0 |
| 2011-04-07 08:10:00 | AAPL | Stock | 12.1268 | 12.1268 | 12.1161 | 12.1161 | 81760.0 |
| 2011-04-07 08:15:00 | AAPL | Stock | 12.1161 | 12.1161 | 12.1071 | 12.1082 | 265160.0 |
| 2011-04-07 08:20:00 | AAPL | Stock | 12.1143 | 12.1161 | 12.1114 | 12.1114 | 25200.0 |
| 2011-04-07 08:25:00 | AAPL | Stock | 12.1143 | 12.1161 | 12.1079 | 12.1107 | 60200.0 |
| 2011-04-07 08:30:00 | AAPL | Stock | 12.1079 | 12.1107 | 12.0893 | 12.1046 | 185640.0 |
| 2011-04-07 08:35:00 | AAPL | Stock | 12.0982 | 12.1036 | 12.0964 | 12.1036 | 55608.0 |
| 2011-04-07 08:40:00 | AAPL | Stock | 12.1036 | 12.1071 | 12.1036 | 12.1071 | 25200.0 |
| 2011-04-07 08:45:00 | AAPL | Stock | 12.1071 | 12.1071 | 12.1054 | 12.1071 | 18760.0 |
| 2011-04-07 08:50:00 | AAPL | Stock | 12.1054 | 12.1057 | 12.0964 | 12.1057 | 45920.0 |
| 2011-04-07 08:55:00 | AAPL | Stock | 12.0964 | 12.0964 | 12.0879 | 12.0946 | 138572.0 |
| 2011-04-07 09:00:00 | AAPL | Stock | 12.0989 | 12.1 | 12.0907 | 12.0921 | 98000.0 |
| 2011-04-07 09:05:00 | AAPL | Stock | 12.0957 | 12.1032 | 12.0896 | 12.0982 | 107940.0 |
| 2011-04-07 09:10:00 | AAPL | Stock | 12.0982 | 12.1011 | 12.0982 | 12.1011 | 36400.0 |
| 2011-04-07 09:15:00 | AAPL | Stock | 12.1004 | 12.1143 | 12.1 | 12.1071 | 126000.0 |
| 2011-04-07 09:20:00 | AAPL | Stock | 12.1086 | 12.1193 | 12.1071 | 12.1089 | 90664.0 |
| 2011-04-07 09:25:00 | AAPL | Stock | 12.1082 | 12.1143 | 12.0746 | 12.0746 | 311192.0 |
| 2011-04-07 09:30:00 | AAPL | Stock | 12.0743 | 12.1068 | 12.0454 | 12.0507 | 14199948.0 |
| 2011-04-07 09:35:00 | AAPL | Stock | 12.0511 | 12.1125 | 12.0496 | 12.0738 | 12739832.0 |
| 2011-04-07 09:40:00 | AAPL | Stock | 12.0736 | 12.1193 | 12.0721 | 12.1096 | 7695492.0 |
| 2011-04-07 09:45:00 | AAPL | Stock | 12.1096 | 12.1511 | 12.1046 | 12.1414 | 14649936.0 |
| 2011-04-07 09:50:00 | AAPL | Stock | 12.1425 | 12.1582 | 12.1393 | 12.146 | 8799784.0 |
| 2011-04-07 09:55:00 | AAPL | Stock | 12.1461 | 12.1557 | 12.1364 | 12.1511 | 6731172.0 |
| 2011-04-07 10:00:00 | AAPL | Stock | 12.1504 | 12.1575 | 12.1439 | 12.1546 | 5724264.0 |
| 2011-04-07 10:05:00 | AAPL | Stock | 12.1546 | 12.1554 | 12.1296 | 12.1412 | 7671216.0 |
| 2011-04-07 10:10:00 | AAPL | Stock | 12.1407 | 12.1425 | 12.1186 | 12.1271 | 4750760.0 |
| 2011-04-07 10:15:00 | AAPL | Stock | 12.1268 | 12.1271 | 12.1096 | 12.117 | 5394144.0 |
| 2011-04-07 10:20:00 | AAPL | Stock | 12.1164 | 12.1307 | 12.1164 | 12.1193 | 4434024.0 |
| 2011-04-07 10:25:00 | AAPL | Stock | 12.1193 | 12.1248 | 12.1004 | 12.1036 | 4537008.0 |
| 2011-04-07 10:30:00 | AAPL | Stock | 12.1046 | 12.1125 | 12.1029 | 12.1093 | 3462172.0 |
| 2011-04-07 10:35:00 | AAPL | Stock | 12.1071 | 12.1111 | 12.0586 | 12.0788 | 10349304.0 |
| 2011-04-07 10:40:00 | AAPL | Stock | 12.0811 | 12.0836 | 12.0196 | 12.03 | 14892472.0 |
| 2011-04-07 10:45:00 | AAPL | Stock | 12.0286 | 12.0686 | 12.0011 | 12.0672 | 16673160.0 |
| 2011-04-07 10:50:00 | AAPL | Stock | 12.0671 | 12.0714 | 12.0464 | 12.0666 | 7830648.0 |
| 2011-04-07 10:55:00 | AAPL | Stock | 12.0662 | 12.0696 | 12.0554 | 12.0568 | 3350844.0 |
| 2011-04-07 11:00:00 | AAPL | Stock | 12.0582 | 12.0614 | 12.0454 | 12.0546 | 5597284.0 |
> showing 50 of 320,648 rows — these rows as CSV