PREVIEW / stock_5min / 2013-06-03
file: by_date/stock_5min/2013/2013-06-03.parquet size: 5.4 MB rows: 360,137 symbols: 3,513
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-06-03 04:10:00 | AAPL | Stock | 16.0357 | 16.0357 | 16.0261 | 16.0261 | 11200.0 |
| 2013-06-03 04:15:00 | AAPL | Stock | 16.0357 | 16.0357 | 16.0357 | 16.0357 | 2800.0 |
| 2013-06-03 04:45:00 | AAPL | Stock | 16.0214 | 16.0214 | 16.0214 | 16.0214 | 5600.0 |
| 2013-06-03 05:10:00 | AAPL | Stock | 16.0136 | 16.0339 | 16.0136 | 16.0339 | 5600.0 |
| 2013-06-03 05:15:00 | AAPL | Stock | 16.0357 | 16.0357 | 16.0357 | 16.0357 | 2800.0 |
| 2013-06-03 05:20:00 | AAPL | Stock | 16.0321 | 16.0321 | 16.0321 | 16.0321 | 2800.0 |
| 2013-06-03 05:50:00 | AAPL | Stock | 16.0696 | 16.0714 | 16.0696 | 16.0714 | 30800.0 |
| 2013-06-03 05:55:00 | AAPL | Stock | 16.0786 | 16.0786 | 16.0786 | 16.0786 | 8400.0 |
| 2013-06-03 06:15:00 | AAPL | Stock | 16.0893 | 16.0893 | 16.0893 | 16.0893 | 2800.0 |
| 2013-06-03 06:25:00 | AAPL | Stock | 16.0714 | 16.0714 | 16.0714 | 16.0714 | 5600.0 |
| 2013-06-03 06:30:00 | AAPL | Stock | 16.0893 | 16.0893 | 16.0893 | 16.0893 | 2800.0 |
| 2013-06-03 06:35:00 | AAPL | Stock | 16.0893 | 16.0996 | 16.0893 | 16.0996 | 8400.0 |
| 2013-06-03 06:45:00 | AAPL | Stock | 16.1061 | 16.1354 | 16.1061 | 16.1354 | 14616.0 |
| 2013-06-03 07:00:00 | AAPL | Stock | 16.1357 | 16.1596 | 16.1357 | 16.1429 | 26768.0 |
| 2013-06-03 07:05:00 | AAPL | Stock | 16.1429 | 16.1446 | 16.1429 | 16.1429 | 35000.0 |
| 2013-06-03 07:10:00 | AAPL | Stock | 16.1446 | 16.1571 | 16.1446 | 16.1571 | 26628.0 |
| 2013-06-03 07:15:00 | AAPL | Stock | 16.1429 | 16.1429 | 16.1429 | 16.1429 | 5600.0 |
| 2013-06-03 07:20:00 | AAPL | Stock | 16.1429 | 16.1464 | 16.1425 | 16.1464 | 195664.0 |
| 2013-06-03 07:25:00 | AAPL | Stock | 16.1429 | 16.1518 | 16.1429 | 16.1518 | 166628.0 |
| 2013-06-03 07:30:00 | AAPL | Stock | 16.1546 | 16.1679 | 16.1546 | 16.1607 | 210112.0 |
| 2013-06-03 07:35:00 | AAPL | Stock | 16.1621 | 16.1643 | 16.1496 | 16.1643 | 84000.0 |
| 2013-06-03 07:40:00 | AAPL | Stock | 16.1536 | 16.1607 | 16.1414 | 16.1425 | 57428.0 |
| 2013-06-03 07:45:00 | AAPL | Stock | 16.1429 | 16.15 | 16.1429 | 16.15 | 101164.0 |
| 2013-06-03 07:50:00 | AAPL | Stock | 16.15 | 16.15 | 16.1425 | 16.1446 | 107576.0 |
| 2013-06-03 07:55:00 | AAPL | Stock | 16.1357 | 16.1525 | 16.1357 | 16.1525 | 19068.0 |
| 2013-06-03 08:00:00 | AAPL | Stock | 16.1443 | 16.1643 | 16.0714 | 16.1429 | 602728.0 |
| 2013-06-03 08:05:00 | AAPL | Stock | 16.1429 | 16.15 | 16.06 | 16.1414 | 308980.0 |
| 2013-06-03 08:10:00 | AAPL | Stock | 16.1429 | 16.1429 | 16.1286 | 16.1286 | 269192.0 |
| 2013-06-03 08:15:00 | AAPL | Stock | 16.125 | 16.1357 | 16.1207 | 16.1207 | 193060.0 |
| 2013-06-03 08:20:00 | AAPL | Stock | 16.1214 | 16.125 | 16.1111 | 16.125 | 335440.0 |
| 2013-06-03 08:25:00 | AAPL | Stock | 16.1264 | 16.1339 | 16.1075 | 16.1075 | 181440.0 |
| 2013-06-03 08:30:00 | AAPL | Stock | 16.1071 | 16.1246 | 16.1071 | 16.1107 | 251832.0 |
| 2013-06-03 08:35:00 | AAPL | Stock | 16.1143 | 16.1179 | 16.1075 | 16.1171 | 181328.0 |
| 2013-06-03 08:40:00 | AAPL | Stock | 16.1121 | 16.1214 | 16.1036 | 16.1143 | 426160.0 |
| 2013-06-03 08:45:00 | AAPL | Stock | 16.1164 | 16.1304 | 16.1143 | 16.1143 | 152740.0 |
| 2013-06-03 08:50:00 | AAPL | Stock | 16.1143 | 16.125 | 16.1143 | 16.125 | 20300.0 |
| 2013-06-03 08:55:00 | AAPL | Stock | 16.1239 | 16.1393 | 16.1239 | 16.1368 | 149744.0 |
| 2013-06-03 09:00:00 | AAPL | Stock | 16.1336 | 16.1379 | 16.1318 | 16.1318 | 87136.0 |
| 2013-06-03 09:05:00 | AAPL | Stock | 16.1339 | 16.1339 | 16.1182 | 16.1196 | 81200.0 |
| 2013-06-03 09:10:00 | AAPL | Stock | 16.1196 | 16.125 | 16.1179 | 16.125 | 85260.0 |
| 2013-06-03 09:15:00 | AAPL | Stock | 16.1239 | 16.1307 | 16.1211 | 16.1264 | 62300.0 |
| 2013-06-03 09:20:00 | AAPL | Stock | 16.1271 | 16.1411 | 16.125 | 16.1411 | 136892.0 |
| 2013-06-03 09:25:00 | AAPL | Stock | 16.1411 | 16.1554 | 16.0964 | 16.1075 | 1040648.0 |
| 2013-06-03 09:30:00 | AAPL | Stock | 16.1071 | 16.1557 | 16.0804 | 16.0986 | 16953104.0 |
| 2013-06-03 09:35:00 | AAPL | Stock | 16.0871 | 16.105 | 16.025 | 16.06 | 10459288.0 |
| 2013-06-03 09:40:00 | AAPL | Stock | 16.0557 | 16.0607 | 15.9714 | 15.987 | 11053588.0 |
| 2013-06-03 09:45:00 | AAPL | Stock | 15.9846 | 15.9889 | 15.8964 | 15.9168 | 12908196.0 |
| 2013-06-03 09:50:00 | AAPL | Stock | 15.9154 | 15.9643 | 15.9007 | 15.9632 | 10545528.0 |
| 2013-06-03 09:55:00 | AAPL | Stock | 15.9611 | 16.0139 | 15.9579 | 15.9943 | 7060172.0 |
| 2013-06-03 10:00:00 | AAPL | Stock | 15.9982 | 16.0179 | 15.9554 | 15.9739 | 8251180.0 |
> showing 50 of 360,137 rows — these rows as CSV